eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_GL_BATCH_TRANSFER dependencies on FND_FILE

Line 186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to General Ledger Report Date:'||to_char(sysdate,'DD-MON-YYYY HH:MM'));

182: glps.set_of_books_id = ledgers.ledger_id';
183:
184: select sysdate into l_init_sysdate from dual;
185:
186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to General Ledger Report Date:'||to_char(sysdate,'DD-MON-YYYY HH:MM'));
187: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
188: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger From: ' || p_ledger_low);

Line 187: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );

183:
184: select sysdate into l_init_sysdate from dual;
185:
186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to General Ledger Report Date:'||to_char(sysdate,'DD-MON-YYYY HH:MM'));
187: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
188: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger From: ' || p_ledger_low);
191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger To: ' || p_ledger_high);

Line 188: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));

184: select sysdate into l_init_sysdate from dual;
185:
186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to General Ledger Report Date:'||to_char(sysdate,'DD-MON-YYYY HH:MM'));
187: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
188: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger From: ' || p_ledger_low);
191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger To: ' || p_ledger_high);
192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity From: ' || p_le_low);

Line 189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));

185:
186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to General Ledger Report Date:'||to_char(sysdate,'DD-MON-YYYY HH:MM'));
187: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
188: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger From: ' || p_ledger_low);
191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger To: ' || p_ledger_high);
192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity From: ' || p_le_low);
193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity To: ' || p_le_high);

Line 190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger From: ' || p_ledger_low);

186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to General Ledger Report Date:'||to_char(sysdate,'DD-MON-YYYY HH:MM'));
187: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
188: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger From: ' || p_ledger_low);
191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger To: ' || p_ledger_high);
192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity From: ' || p_le_low);
193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity To: ' || p_le_high);
194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Intercompany Organization From: ' || p_ic_org_low);

Line 191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger To: ' || p_ledger_high);

187: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
188: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger From: ' || p_ledger_low);
191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger To: ' || p_ledger_high);
192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity From: ' || p_le_low);
193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity To: ' || p_le_high);
194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Intercompany Organization From: ' || p_ic_org_low);
195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Intercompany Organization To: ' || p_ic_org_high);

Line 192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity From: ' || p_le_low);

188: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger From: ' || p_ledger_low);
191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger To: ' || p_ledger_high);
192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity From: ' || p_le_low);
193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity To: ' || p_le_high);
194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Intercompany Organization From: ' || p_ic_org_low);
195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Intercompany Organization To: ' || p_ic_org_high);
196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Run Journal Import: ' || l_run_journal_import);

Line 193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity To: ' || p_le_high);

189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger From: ' || p_ledger_low);
191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger To: ' || p_ledger_high);
192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity From: ' || p_le_low);
193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity To: ' || p_le_high);
194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Intercompany Organization From: ' || p_ic_org_low);
195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Intercompany Organization To: ' || p_ic_org_high);
196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Run Journal Import: ' || l_run_journal_import);
197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Create Summary Journals: ' || l_create_summary_journals);

Line 194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Intercompany Organization From: ' || p_ic_org_low);

190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger From: ' || p_ledger_low);
191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger To: ' || p_ledger_high);
192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity From: ' || p_le_low);
193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity To: ' || p_le_high);
194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Intercompany Organization From: ' || p_ic_org_low);
195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Intercompany Organization To: ' || p_ic_org_high);
196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Run Journal Import: ' || l_run_journal_import);
197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Create Summary Journals: ' || l_create_summary_journals);
198: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );

Line 195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Intercompany Organization To: ' || p_ic_org_high);

191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Ledger To: ' || p_ledger_high);
192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity From: ' || p_le_low);
193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity To: ' || p_le_high);
194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Intercompany Organization From: ' || p_ic_org_low);
195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Intercompany Organization To: ' || p_ic_org_high);
196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Run Journal Import: ' || l_run_journal_import);
197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Create Summary Journals: ' || l_create_summary_journals);
198: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );

Line 196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Run Journal Import: ' || l_run_journal_import);

192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity From: ' || p_le_low);
193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity To: ' || p_le_high);
194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Intercompany Organization From: ' || p_ic_org_low);
195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Intercompany Organization To: ' || p_ic_org_high);
196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Run Journal Import: ' || l_run_journal_import);
197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Create Summary Journals: ' || l_create_summary_journals);
198: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );
200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');

Line 197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Create Summary Journals: ' || l_create_summary_journals);

193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity To: ' || p_le_high);
194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Intercompany Organization From: ' || p_ic_org_low);
195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Intercompany Organization To: ' || p_ic_org_high);
196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Run Journal Import: ' || l_run_journal_import);
197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Create Summary Journals: ' || l_create_summary_journals);
198: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );
200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');
201:

Line 198: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );

194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Intercompany Organization From: ' || p_ic_org_low);
195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Intercompany Organization To: ' || p_ic_org_high);
196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Run Journal Import: ' || l_run_journal_import);
197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Create Summary Journals: ' || l_create_summary_journals);
198: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );
200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');
201:
202: /* Insert data into temp table */

Line 199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );

195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Intercompany Organization To: ' || p_ic_org_high);
196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Run Journal Import: ' || l_run_journal_import);
197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Create Summary Journals: ' || l_create_summary_journals);
198: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );
200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');
201:
202: /* Insert data into temp table */
203: begin

Line 200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');

196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Run Journal Import: ' || l_run_journal_import);
197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Create Summary Journals: ' || l_create_summary_journals);
198: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );
200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');
201:
202: /* Insert data into temp table */
203: begin
204: gt_insert_clause :='INSERT INTO fun_transfers(BATCH_ID, trx_id, org_name, org_id, le_id,

Line 417: FND_FILE.PUT_LINE(FND_FILE.LOG,'INSERT BLOCK: No Data Found');

413: EXCEPTION
414: WHEN NO_DATA_FOUND THEN
415: -- Bug # 6842245
416: -- null
417: FND_FILE.PUT_LINE(FND_FILE.LOG,'INSERT BLOCK: No Data Found');
418: raise;
419:
420:
421: WHEN DUP_VAL_ON_INDEX THEN

Line 422: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );

418: raise;
419:
420:
421: WHEN DUP_VAL_ON_INDEX THEN
422: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
423: FND_FILE.PUT_LINE(fnd_file.output,' *****Another GL Transfer process is running with same set of transactions.*****');
424: FND_FILE.PUT_LINE(FND_FILE.LOG,'Another GL Transfer process is running with same set of transactions.');
425: rollback;
426: raise;

Line 423: FND_FILE.PUT_LINE(fnd_file.output,' Another GL Transfer process is running with same set of transactions.');

419:
420:
421: WHEN DUP_VAL_ON_INDEX THEN
422: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
423: FND_FILE.PUT_LINE(fnd_file.output,' *****Another GL Transfer process is running with same set of transactions.*****');
424: FND_FILE.PUT_LINE(FND_FILE.LOG,'Another GL Transfer process is running with same set of transactions.');
425: rollback;
426: raise;
427: WHEN OTHERS THEN

Line 424: FND_FILE.PUT_LINE(FND_FILE.LOG,'Another GL Transfer process is running with same set of transactions.');

420:
421: WHEN DUP_VAL_ON_INDEX THEN
422: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
423: FND_FILE.PUT_LINE(fnd_file.output,' *****Another GL Transfer process is running with same set of transactions.*****');
424: FND_FILE.PUT_LINE(FND_FILE.LOG,'Another GL Transfer process is running with same set of transactions.');
425: rollback;
426: raise;
427: WHEN OTHERS THEN
428: -- Bug # 6842245

Line 429: FND_FILE.PUT_LINE(FND_FILE.LOG,'INSERT BLOCK: Unexpected error:' || sqlcode || sqlerrm);

425: rollback;
426: raise;
427: WHEN OTHERS THEN
428: -- Bug # 6842245
429: FND_FILE.PUT_LINE(FND_FILE.LOG,'INSERT BLOCK: Unexpected error:' || sqlcode || sqlerrm);
430: retcode := 2;
431: raise;
432: END;
433:

Line 528: fnd_file.put_line(fnd_file.output, rpad(substr(l_batch_num(l_index), 1,15),20)||rpad(substr(l_trx_num(l_index),1,15),20)||fnd_message.get);

524: FOR l_index IN l_trx_id_tbl.FIRST .. l_trx_id_tbl.LAST
525: LOOP
526: IF (l_error_mesg_tbl(l_index) like 'GL_PERIOD_NOT_OPEN%') THEN
527: fnd_message.set_name('FUN','GL_PERIOD_NOT_OPEN');
528: fnd_file.put_line(fnd_file.output, rpad(substr(l_batch_num(l_index), 1,15),20)||rpad(substr(l_trx_num(l_index),1,15),20)||fnd_message.get);
529: ELSIF (l_error_mesg_tbl(l_index) like 'FUN_API_CONV_RATE_NOT_FOUND') THEN
530: fnd_message.set_name('FUN','FUN_API_CONV_RATE_NOT_FOUND');
531: fnd_file.put_line(fnd_file.output, rpad(substr(l_batch_num(l_index), 1,15),20)||rpad(substr(l_trx_num(l_index),1,15),20)||fnd_message.get);
532: ELSE

Line 531: fnd_file.put_line(fnd_file.output, rpad(substr(l_batch_num(l_index), 1,15),20)||rpad(substr(l_trx_num(l_index),1,15),20)||fnd_message.get);

527: fnd_message.set_name('FUN','GL_PERIOD_NOT_OPEN');
528: fnd_file.put_line(fnd_file.output, rpad(substr(l_batch_num(l_index), 1,15),20)||rpad(substr(l_trx_num(l_index),1,15),20)||fnd_message.get);
529: ELSIF (l_error_mesg_tbl(l_index) like 'FUN_API_CONV_RATE_NOT_FOUND') THEN
530: fnd_message.set_name('FUN','FUN_API_CONV_RATE_NOT_FOUND');
531: fnd_file.put_line(fnd_file.output, rpad(substr(l_batch_num(l_index), 1,15),20)||rpad(substr(l_trx_num(l_index),1,15),20)||fnd_message.get);
532: ELSE
533: fnd_message.set_name('FUN','FUN_API_TRX_TRANSFERRED');
534: fnd_file.put_line(fnd_file.output, rpad(substr(l_batch_num(l_index), 1,15),20)||rpad(substr(l_trx_num(l_index),1,15),20)||fnd_message.get);
535: END IF;

Line 534: fnd_file.put_line(fnd_file.output, rpad(substr(l_batch_num(l_index), 1,15),20)||rpad(substr(l_trx_num(l_index),1,15),20)||fnd_message.get);

530: fnd_message.set_name('FUN','FUN_API_CONV_RATE_NOT_FOUND');
531: fnd_file.put_line(fnd_file.output, rpad(substr(l_batch_num(l_index), 1,15),20)||rpad(substr(l_trx_num(l_index),1,15),20)||fnd_message.get);
532: ELSE
533: fnd_message.set_name('FUN','FUN_API_TRX_TRANSFERRED');
534: fnd_file.put_line(fnd_file.output, rpad(substr(l_batch_num(l_index), 1,15),20)||rpad(substr(l_trx_num(l_index),1,15),20)||fnd_message.get);
535: END IF;
536: END LOOP;
537: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****End Of Report*****');

Line 537: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );

533: fnd_message.set_name('FUN','FUN_API_TRX_TRANSFERRED');
534: fnd_file.put_line(fnd_file.output, rpad(substr(l_batch_num(l_index), 1,15),20)||rpad(substr(l_trx_num(l_index),1,15),20)||fnd_message.get);
535: END IF;
536: END LOOP;
537: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****End Of Report*****');
539: ELSE
540: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****No Data Found*****');

Line 538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' End Of Report');

534: fnd_file.put_line(fnd_file.output, rpad(substr(l_batch_num(l_index), 1,15),20)||rpad(substr(l_trx_num(l_index),1,15),20)||fnd_message.get);
535: END IF;
536: END LOOP;
537: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****End Of Report*****');
539: ELSE
540: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****No Data Found*****');
542: END IF;

Line 540: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );

536: END LOOP;
537: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****End Of Report*****');
539: ELSE
540: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****No Data Found*****');
542: END IF;
543:
544: /* Bug 6797385.

Line 541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' No Data Found');

537: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****End Of Report*****');
539: ELSE
540: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****No Data Found*****');
542: END IF;
543:
544: /* Bug 6797385.
545: UPDATE fun_trx_batches

Line 559: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Data Found');

555: commit;
556:
557: EXCEPTION
558: WHEN NO_DATA_FOUND THEN
559: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Data Found');
560: -- Bug # 6842245
561: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rolling Back All The Transactions');
562: rollback;
563:

Line 561: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rolling Back All The Transactions');

557: EXCEPTION
558: WHEN NO_DATA_FOUND THEN
559: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Data Found');
560: -- Bug # 6842245
561: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rolling Back All The Transactions');
562: rollback;
563:
564: DELETE fun_transfers
565: WHERE REQUEST_ID = P_REQUEST_ID;

Line 569: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);

565: WHERE REQUEST_ID = P_REQUEST_ID;
566: commit;
567:
568: WHEN OTHERS THEN
569: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);
570: retcode := 2;
571: -- Bug # 6842245
572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rolling Back All The Transactions');
573: rollback;

Line 572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rolling Back All The Transactions');

568: WHEN OTHERS THEN
569: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);
570: retcode := 2;
571: -- Bug # 6842245
572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rolling Back All The Transactions');
573: rollback;
574:
575: DELETE fun_transfers
576: WHERE REQUEST_ID = P_REQUEST_ID;