DBA Data[Home] [Help]

APPS.FUN_AP_TRANSFER dependencies on FND_FILE

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

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

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

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

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

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

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

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

Line 273: 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, ' Transfer Intercompany Transactions to Payables Report Date:'||to_char(sysdate,'DD-MON-YYYY HH:MM'));
270: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Operating Unit: ' || l_org_name);
272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Legal Entity: ' || l_le_name );
273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));
274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date To: ' || to_char(l_date_high,'DD-MON-YYYY'));
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Submit Payables Import: ' || l_run_payables_import);
276: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Transaction Number Transfer Status' );

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

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

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

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

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

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

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

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

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

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

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

358: l_previous_org_id := l_to_org_id;
359: END IF;
360:
361: fnd_message.set_name('FUN','FUN_XFER_SUCCESS');
362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(substr(l_batch_num, 1,20),20)||rpad(substr(l_trx_num,1,15),20)||fnd_message.get);
363: is_data_transferred:='Y';
364:
365: --Bug:12703241. Cancel open workflw activities and the notifications
366:

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

367: FUN_WF_COMMON.wf_abort(l_batch_id, l_trx_id, 'FUNAPINT');
368:
369: EXCEPTION
370: WHEN OTHERS THEN
371: fnd_file.put_line(fnd_file.log,'Error :'||SQLERRM);
372:
373:
374: END;
375: ELSIF (l_error = 2) THEN

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

372:
373:
374: END;
375: ELSIF (l_error = 2) THEN
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(substr(l_batch_num,1,20),20)||rpad(substr(l_trx_num,1,15),20)||fnd_message.get);
377: END IF;
378:
379: l_error := 1;
380:

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

379: l_error := 1;
380:
381: END LOOP;
382: CLOSE c_trx;
383: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
384: IF (l_counter = 0) THEN
385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****No Data Found*****');
386: ELSE
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****End Of Report*****');

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

381: END LOOP;
382: CLOSE c_trx;
383: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
384: IF (l_counter = 0) THEN
385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****No Data Found*****');
386: ELSE
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****End Of Report*****');
388: END IF;
389:

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

383: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
384: IF (l_counter = 0) THEN
385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****No Data Found*****');
386: ELSE
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****End Of Report*****');
388: END IF;
389:
390: COMMIT;
391:

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

423: argument3 =>null,
424: argument4 =>null);
425:
426: IF l_request_id <> 0 THEN
427: fnd_file.put_line(fnd_file.log,'Submitted the Payables Import Program. Request id: ' || l_request_id || ' for Org Id ' || org_id_table(I));
428: commit;
429: ELSE
430: RAISE Request_Submission_Failure;
431: END IF;

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

437:
438: EXCEPTION
439:
440: WHEN Request_Submission_Failure THEN
441: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in submitting Payables Import Process');
442: retcode :=2;
443: WHEN OTHERS THEN
444: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);
445: retcode := 2;

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

440: WHEN Request_Submission_Failure THEN
441: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in submitting Payables Import Process');
442: retcode :=2;
443: WHEN OTHERS THEN
444: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);
445: retcode := 2;
446:
447: END transfer_batch;
448: