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

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

260: select xle.name into l_le_name from xle_entity_profiles xle
261: where xle.legal_entity_id = p_le_id;
262: END IF;
263:
264: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to Payables Report Date:'||to_char(sysdate,'DD-MON-YYYY HH:MM'));
265: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
266: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name );
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));

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

261: where xle.legal_entity_id = p_le_id;
262: END IF;
263:
264: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to Payables Report Date:'||to_char(sysdate,'DD-MON-YYYY HH:MM'));
265: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
266: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name );
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));

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

262: END IF;
263:
264: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to Payables Report Date:'||to_char(sysdate,'DD-MON-YYYY HH:MM'));
265: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
266: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name );
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit Payables Import: ' || l_run_payables_import);

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

263:
264: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to Payables Report Date:'||to_char(sysdate,'DD-MON-YYYY HH:MM'));
265: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
266: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name );
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit Payables Import: ' || l_run_payables_import);
271: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );

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

264: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to Payables Report Date:'||to_char(sysdate,'DD-MON-YYYY HH:MM'));
265: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
266: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name );
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit Payables Import: ' || l_run_payables_import);
271: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );

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

265: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
266: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name );
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit Payables Import: ' || l_run_payables_import);
271: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );
273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');

Line 270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit Payables Import: ' || l_run_payables_import);

266: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name );
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit Payables Import: ' || l_run_payables_import);
271: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );
273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');
274:

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

267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name );
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit Payables Import: ' || l_run_payables_import);
271: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );
273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');
274:
275:

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

268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit Payables Import: ' || l_run_payables_import);
271: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );
273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');
274:
275:
276: l_previous_org_id := 0;

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

269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit Payables Import: ' || l_run_payables_import);
271: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );
273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');
274:
275:
276: l_previous_org_id := 0;
277: OPEN c_trx;

Line 356: 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);

352: l_previous_org_id := l_to_org_id;
353: END IF;
354:
355: fnd_message.set_name('FUN','FUN_XFER_SUCCESS');
356: 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);
357: is_data_transferred:='Y';
358: EXCEPTION
359: WHEN OTHERS THEN
360: fnd_file.put_line(fnd_file.log,'Error :'||SQLERRM);

Line 360: fnd_file.put_line(fnd_file.log,'Error :'||SQLERRM);

356: 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);
357: is_data_transferred:='Y';
358: EXCEPTION
359: WHEN OTHERS THEN
360: fnd_file.put_line(fnd_file.log,'Error :'||SQLERRM);
361:
362:
363: END;
364: ELSIF (l_error = 2) THEN

Line 365: 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);

361:
362:
363: END;
364: ELSIF (l_error = 2) THEN
365: 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);
366: END IF;
367:
368: l_error := 1;
369:

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

368: l_error := 1;
369:
370: END LOOP;
371: CLOSE c_trx;
372: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
373: IF (l_counter = 0) THEN
374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****No Data Found*****');
375: ELSE
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****End Of Report*****');

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

370: END LOOP;
371: CLOSE c_trx;
372: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
373: IF (l_counter = 0) THEN
374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****No Data Found*****');
375: ELSE
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****End Of Report*****');
377: END IF;
378:

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

372: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
373: IF (l_counter = 0) THEN
374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****No Data Found*****');
375: ELSE
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****End Of Report*****');
377: END IF;
378:
379: COMMIT;
380:

Line 416: fnd_file.put_line(fnd_file.log,'Submitted the Payables Import Program. Request id: ' || l_request_id || ' for Org Id ' || org_id_table(I));

412: argument3 =>null,
413: argument4 =>null);
414:
415: IF l_request_id <> 0 THEN
416: fnd_file.put_line(fnd_file.log,'Submitted the Payables Import Program. Request id: ' || l_request_id || ' for Org Id ' || org_id_table(I));
417: commit;
418: ELSE
419: RAISE Request_Submission_Failure;
420: END IF;

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

426:
427: EXCEPTION
428:
429: WHEN Request_Submission_Failure THEN
430: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in submitting Payables Import Process');
431: retcode :=2;
432: WHEN OTHERS THEN
433: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);
434: retcode := 2;

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

429: WHEN Request_Submission_Failure THEN
430: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in submitting Payables Import Process');
431: retcode :=2;
432: WHEN OTHERS THEN
433: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);
434: retcode := 2;
435:
436: END transfer_batch;
437: