289: sysdate ,
290: ln_uid ,
291: sysdate ,
292: null ,
293: fnd_profile.value('PROG_APPL_ID'),
294: fnd_profile.value('CONC_PROGRAM_ID'),
295: fnd_profile.value('CONC_LOGIN_ID'),
296: fnd_profile.value('CONC_REQUEST_ID')
297: );
290: ln_uid ,
291: sysdate ,
292: null ,
293: fnd_profile.value('PROG_APPL_ID'),
294: fnd_profile.value('CONC_PROGRAM_ID'),
295: fnd_profile.value('CONC_LOGIN_ID'),
296: fnd_profile.value('CONC_REQUEST_ID')
297: );
298:
291: sysdate ,
292: null ,
293: fnd_profile.value('PROG_APPL_ID'),
294: fnd_profile.value('CONC_PROGRAM_ID'),
295: fnd_profile.value('CONC_LOGIN_ID'),
296: fnd_profile.value('CONC_REQUEST_ID')
297: );
298:
299:
292: null ,
293: fnd_profile.value('PROG_APPL_ID'),
294: fnd_profile.value('CONC_PROGRAM_ID'),
295: fnd_profile.value('CONC_LOGIN_ID'),
296: fnd_profile.value('CONC_REQUEST_ID')
297: );
298:
299:
300: if nvl(p_simulation, 'N') <> 'Y' then
1086: sysdate,
1087: ln_uid,
1088: sysdate,
1089: null,
1090: fnd_profile.value('PROG_APPL_ID'),
1091: fnd_profile.value('CONC_PROGRAM_ID'),
1092: fnd_profile.value('CONC_LOGIN_ID'),
1093: fnd_profile.value('CONC_REQUEST_ID')
1094: );
1087: ln_uid,
1088: sysdate,
1089: null,
1090: fnd_profile.value('PROG_APPL_ID'),
1091: fnd_profile.value('CONC_PROGRAM_ID'),
1092: fnd_profile.value('CONC_LOGIN_ID'),
1093: fnd_profile.value('CONC_REQUEST_ID')
1094: );
1095:
1088: sysdate,
1089: null,
1090: fnd_profile.value('PROG_APPL_ID'),
1091: fnd_profile.value('CONC_PROGRAM_ID'),
1092: fnd_profile.value('CONC_LOGIN_ID'),
1093: fnd_profile.value('CONC_REQUEST_ID')
1094: );
1095:
1096: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 2. After insert into jai_rcv_tp_invoices ' );
1089: null,
1090: fnd_profile.value('PROG_APPL_ID'),
1091: fnd_profile.value('CONC_PROGRAM_ID'),
1092: fnd_profile.value('CONC_LOGIN_ID'),
1093: fnd_profile.value('CONC_REQUEST_ID')
1094: );
1095:
1096: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 2. After insert into jai_rcv_tp_invoices ' );
1097: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :jai_rcv_tp_invoice table insert end:');