our requirement is to modify the Payment confirm program and shoot out emails and transmit a file once confirmation.
Any ideas? have any one tried it before?
help needed urgently.

thanks
SB

Hallo bonnerjis,

yes, i was customizing this part of applications.
Now heading on for writing same peace for AR Part.

I think best thing would be to update the packages the oracle supplies.
Then you can rename them and address as your own.

for transmitting files i was using concsub calls to scripts from reports.

mtc,
Alexandre

hey Alexandre ..
How did u do it?
Its a spawned job.. you can not change it i guess.
did u change the form API to call a wrapper script that in turn calls the confirm payment batch?

details will be very helpful.

thx
sb

Hi sb,

good question. as alwazs manz approaches to get the aim.
1st.
I did following :
found out which ORACLE routine is being called at the moment of making confirmation.
(actually i changed the whole process, so i changed also the order and the names of theroutines called)
but in your case you need only to find the place where the routine (report) is being called.

The report itself is a junk made by report builder in an IMPOSSIBLE way of programming. I still have difficulties to
understand it right. BUT the only thing you need is to use the TRIGGER after the report. that`s all in your case.

So i think actually, you only need to write a single trigger : AFTER REPORT in a Oracle owned report, which is doing your Job.
then you rename the customized file to prevent it from being overwritten. Then reattach it as your new payment confirmation routine.
then DONE.

mtc,
Alexandre

2nd same things are of course can be done by creating some new PLSQL modules and calling them within the oracle
APPS Payment Processor plsql package. i think the routine name was smth about get_short_name
so you can put everything there inside also.

3rd approach.
just write the java classes to do what you need and attach them on a same place within payment processor. I think it is MUCH
more efficient then PLSQL since japan is born for file management and mails and such staff.

hope i could help

If this is for AP, then there is a standard business event called ORACLE.APPS.AP.PROCESSPAYMENT.CONFIRM ,this has substription PROCESS_XML_PAYMENT to create XML file format to send to trading partnter.
So mysuggestion is create a Custom WF and receice this event and do whatever you want to do.
SJ

I think I was too short.

1) First check ORACLE.APPS.AP.PROCESSPAYMENT.CONFIRM is enabled.

2) check whether this business event is actually raised.

3) create a custom WF (start point is receiving this event)

4) the process. what you customer need.

Thanks
SJ