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_AR_BATCH_TRANSFER dependencies on FND_FILE

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

203: select xle.name into l_le_name from xle_entity_profiles xle
204: where xle.legal_entity_id = p_le_id;
205: END IF;
206:
207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to Receivables Report Date: '||to_char(sysdate,'DD-MON-YYYY HH:MM'));
208: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);
210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name);
211: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));

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

204: where xle.legal_entity_id = p_le_id;
205: END IF;
206:
207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to Receivables Report Date: '||to_char(sysdate,'DD-MON-YYYY HH:MM'));
208: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);
210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name);
211: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
212: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));

Line 209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);

205: END IF;
206:
207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to Receivables Report Date: '||to_char(sysdate,'DD-MON-YYYY HH:MM'));
208: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);
210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name);
211: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
212: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
213: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit AR Auto Invoice: ' || l_run_autoinvoice_import);

Line 210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name);

206:
207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to Receivables Report Date: '||to_char(sysdate,'DD-MON-YYYY HH:MM'));
208: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);
210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name);
211: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
212: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
213: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit AR Auto Invoice: ' || l_run_autoinvoice_import);
214: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );

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

207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to Receivables Report Date: '||to_char(sysdate,'DD-MON-YYYY HH:MM'));
208: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);
210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name);
211: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
212: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
213: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit AR Auto Invoice: ' || l_run_autoinvoice_import);
214: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
215: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );

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

208: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);
210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name);
211: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
212: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
213: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit AR Auto Invoice: ' || l_run_autoinvoice_import);
214: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
215: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );
216: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');

Line 213: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit AR Auto Invoice: ' || l_run_autoinvoice_import);

209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);
210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name);
211: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
212: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
213: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit AR Auto Invoice: ' || l_run_autoinvoice_import);
214: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
215: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );
216: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');
217:

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

210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name);
211: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
212: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
213: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit AR Auto Invoice: ' || l_run_autoinvoice_import);
214: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
215: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );
216: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');
217:
218:

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

211: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
212: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
213: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit AR Auto Invoice: ' || l_run_autoinvoice_import);
214: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
215: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );
216: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');
217:
218:
219: open c_info;

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

212: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
213: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit AR Auto Invoice: ' || l_run_autoinvoice_import);
214: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
215: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );
216: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');
217:
218:
219: open c_info;
220:

Line 550: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(substr(l_batch_num,1,15),20)||rpad(substr(l_trx_num,1,15),20)||fnd_message.get);

546: END LOOP; --c_dist
547: CLOSE c_dist;
548:
549: fnd_message.set_name('FUN','FUN_XFER_SUCCESS');
550: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(substr(l_batch_num,1,15),20)||rpad(substr(l_trx_num,1,15),20)||fnd_message.get);
551:
552: -- update transaction status
553:
554: FUN_TRX_PVT.update_trx_status(p_api_version =>1.0,

Line 575: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(substr(l_batch_num,1,15),20)||rpad(substr(l_trx_num,1,15),20)||fnd_message.get);

571: raise FND_API.G_EXC_UNEXPECTED_ERROR;
572: END IF;
573:
574: ELSIF l_error=2 THEN
575: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(substr(l_batch_num,1,15),20)||rpad(substr(l_trx_num,1,15),20)||fnd_message.get);
576: END IF; -- l_error
577: l_error := 1;
578:
579: End Loop; -- c_info

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

578:
579: End Loop; -- c_info
580:
581: close c_info;
582: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
583: IF (l_counter = 0) THEN
584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****No Data Found*****');
585: ELSE
586: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****End Of Report*****');

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

580:
581: close c_info;
582: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
583: IF (l_counter = 0) THEN
584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****No Data Found*****');
585: ELSE
586: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****End Of Report*****');
587: END IF;
588:

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

582: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
583: IF (l_counter = 0) THEN
584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****No Data Found*****');
585: ELSE
586: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****End Of Report*****');
587: END IF;
588:
589: COMMIT;
590:

Line 602: fnd_file.put_line(fnd_file.log,'AR Auto Invoice Program submitted for Org ID: ' || org_id_table(I)||' with Request id: ' || l_request_id);

598: '','','','','','','','','','','',
599: '','','','','','','','','', 'YES','');
600:
601: IF l_request_id <> 0 THEN
602: fnd_file.put_line(fnd_file.log,'AR Auto Invoice Program submitted for Org ID: ' || org_id_table(I)||' with Request id: ' || l_request_id);
603: commit;
604: ELSE
605: RAISE Request_Submission_Failure;
606: END IF;

Line 613: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in submitting AutoInovice Import Process');

609:
610:
611: EXCEPTION
612: WHEN Request_Submission_Failure THEN
613: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in submitting AutoInovice Import Process');
614: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);
615: WHEN NO_DATA_FOUND THEN
616: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Data Found');
617: WHEN OTHERS THEN

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

610:
611: EXCEPTION
612: WHEN Request_Submission_Failure THEN
613: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in submitting AutoInovice Import Process');
614: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);
615: WHEN NO_DATA_FOUND THEN
616: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Data Found');
617: WHEN OTHERS THEN
618: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);

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

612: WHEN Request_Submission_Failure THEN
613: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in submitting AutoInovice Import Process');
614: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);
615: WHEN NO_DATA_FOUND THEN
616: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Data Found');
617: WHEN OTHERS THEN
618: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);
619: retcode := 2;
620: end;

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

614: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);
615: WHEN NO_DATA_FOUND THEN
616: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Data Found');
617: WHEN OTHERS THEN
618: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);
619: retcode := 2;
620: end;
621:
622: END FUN_AR_BATCH_TRANSFER;