310: sysdate ,
311: ln_uid ,
312: sysdate ,
313: null ,
314: fnd_profile.value('PROG_APPL_ID'),
315: fnd_profile.value('CONC_PROGRAM_ID'),
316: fnd_profile.value('CONC_LOGIN_ID'),
317: fnd_profile.value('CONC_REQUEST_ID')
318: );
311: ln_uid ,
312: sysdate ,
313: null ,
314: fnd_profile.value('PROG_APPL_ID'),
315: fnd_profile.value('CONC_PROGRAM_ID'),
316: fnd_profile.value('CONC_LOGIN_ID'),
317: fnd_profile.value('CONC_REQUEST_ID')
318: );
319:
312: sysdate ,
313: null ,
314: fnd_profile.value('PROG_APPL_ID'),
315: fnd_profile.value('CONC_PROGRAM_ID'),
316: fnd_profile.value('CONC_LOGIN_ID'),
317: fnd_profile.value('CONC_REQUEST_ID')
318: );
319:
320:
313: null ,
314: fnd_profile.value('PROG_APPL_ID'),
315: fnd_profile.value('CONC_PROGRAM_ID'),
316: fnd_profile.value('CONC_LOGIN_ID'),
317: fnd_profile.value('CONC_REQUEST_ID')
318: );
319:
320:
321: if nvl(p_simulation, 'N') <> 'Y' then
1200: sysdate,
1201: ln_uid,
1202: sysdate,
1203: null,
1204: fnd_profile.value('PROG_APPL_ID'),
1205: fnd_profile.value('CONC_PROGRAM_ID'),
1206: fnd_profile.value('CONC_LOGIN_ID'),
1207: fnd_profile.value('CONC_REQUEST_ID')
1208: );
1201: ln_uid,
1202: sysdate,
1203: null,
1204: fnd_profile.value('PROG_APPL_ID'),
1205: fnd_profile.value('CONC_PROGRAM_ID'),
1206: fnd_profile.value('CONC_LOGIN_ID'),
1207: fnd_profile.value('CONC_REQUEST_ID')
1208: );
1209:
1202: sysdate,
1203: null,
1204: fnd_profile.value('PROG_APPL_ID'),
1205: fnd_profile.value('CONC_PROGRAM_ID'),
1206: fnd_profile.value('CONC_LOGIN_ID'),
1207: fnd_profile.value('CONC_REQUEST_ID')
1208: );
1209:
1210: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 2. After insert into jai_rcv_tp_invoices ' );
1203: null,
1204: fnd_profile.value('PROG_APPL_ID'),
1205: fnd_profile.value('CONC_PROGRAM_ID'),
1206: fnd_profile.value('CONC_LOGIN_ID'),
1207: fnd_profile.value('CONC_REQUEST_ID')
1208: );
1209:
1210: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 2. After insert into jai_rcv_tp_invoices ' );
1211: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :jai_rcv_tp_invoice table insert end:');