good question. as alwazs manz approaches to get the aim.
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.
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.
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