DBA Data[Home] [Help]

APPS.POS_IMP_SUPP_PKG dependencies on FND_FILE

Line 478: fnd_file.put_line(fnd_file.output, l_error_message);

474: fnd_msg_pub.reset;
475: FOR i IN 1 .. fnd_msg_pub.count_msg LOOP
476: l_error_message := fnd_msg_pub.get(p_msg_index => i,
477: p_encoded => fnd_api.g_false);
478: fnd_file.put_line(fnd_file.output, l_error_message);
479: fnd_file.put_line(fnd_file.log, l_error_message);
480: END LOOP;
481: retcode := 2;
482: RETURN;

Line 479: fnd_file.put_line(fnd_file.log, l_error_message);

475: FOR i IN 1 .. fnd_msg_pub.count_msg LOOP
476: l_error_message := fnd_msg_pub.get(p_msg_index => i,
477: p_encoded => fnd_api.g_false);
478: fnd_file.put_line(fnd_file.output, l_error_message);
479: fnd_file.put_line(fnd_file.log, l_error_message);
480: END LOOP;
481: retcode := 2;
482: RETURN;
483: WHEN fnd_api.g_exc_unexpected_error THEN

Line 485: fnd_file.put_line(fnd_file.log, 'Unexpected error occured ');

481: retcode := 2;
482: RETURN;
483: WHEN fnd_api.g_exc_unexpected_error THEN
484: ROLLBACK WORK;
485: fnd_file.put_line(fnd_file.log, 'Unexpected error occured ');
486: fnd_file.put_line(fnd_file.log, SQLERRM);
487: retcode := 2;
488: RETURN;
489: WHEN OTHERS THEN

Line 486: fnd_file.put_line(fnd_file.log, SQLERRM);

482: RETURN;
483: WHEN fnd_api.g_exc_unexpected_error THEN
484: ROLLBACK WORK;
485: fnd_file.put_line(fnd_file.log, 'Unexpected error occured ');
486: fnd_file.put_line(fnd_file.log, SQLERRM);
487: retcode := 2;
488: RETURN;
489: WHEN OTHERS THEN
490: ROLLBACK WORK;

Line 491: fnd_file.put_line(fnd_file.log, SQLERRM);

487: retcode := 2;
488: RETURN;
489: WHEN OTHERS THEN
490: ROLLBACK WORK;
491: fnd_file.put_line(fnd_file.log, SQLERRM);
492: retcode := 2;
493: RETURN;
494: END;
495:

Line 512: fnd_file.put_line(fnd_file.log,

508: END IF;
509: EXCEPTION
510: WHEN fnd_api.g_exc_error THEN
511: ROLLBACK WORK;
512: fnd_file.put_line(fnd_file.log,
513: 'Error : You cannot purge a batch when a batch is being processed.');
514: retcode := 2;
515: RETURN;
516: WHEN OTHERS THEN

Line 518: fnd_file.put_line(fnd_file.log, SQLERRM);

514: retcode := 2;
515: RETURN;
516: WHEN OTHERS THEN
517: ROLLBACK WORK;
518: fnd_file.put_line(fnd_file.log, SQLERRM);
519: retcode := 2;
520: RETURN;
521: END;
522: fnd_file.put_line(fnd_file.log, ' Purge Starts ... ');

Line 522: fnd_file.put_line(fnd_file.log, ' Purge Starts ... ');

518: fnd_file.put_line(fnd_file.log, SQLERRM);
519: retcode := 2;
520: RETURN;
521: END;
522: fnd_file.put_line(fnd_file.log, ' Purge Starts ... ');
523:
524: -- Interface Tables
525: fnd_file.put_line(fnd_file.log, ' Purging Interface Tables ... ');
526:

Line 525: fnd_file.put_line(fnd_file.log, ' Purging Interface Tables ... ');

521: END;
522: fnd_file.put_line(fnd_file.log, ' Purge Starts ... ');
523:
524: -- Interface Tables
525: fnd_file.put_line(fnd_file.log, ' Purging Interface Tables ... ');
526:
527: DELETE ap_suppliers_int WHERE sdh_batch_id = p_batch_id;
528: COMMIT;
529:

Line 557: fnd_file.put_line(fnd_file.log, ' Purged Interface Tables ... ');

553:
554: DELETE pos_bank_accnt_owners_int WHERE batch_id = p_batch_id;
555: COMMIT;
556:
557: fnd_file.put_line(fnd_file.log, ' Purged Interface Tables ... ');
558:
559: fnd_file.put_line(fnd_file.log,
560: ' Update pos_imp_batch_summary table (+)');
561: -- Update pos_imp_batch_summary table.

Line 559: fnd_file.put_line(fnd_file.log,

555: COMMIT;
556:
557: fnd_file.put_line(fnd_file.log, ' Purged Interface Tables ... ');
558:
559: fnd_file.put_line(fnd_file.log,
560: ' Update pos_imp_batch_summary table (+)');
561: -- Update pos_imp_batch_summary table.
562: UPDATE pos_imp_batch_summary
563: SET batch_status = 'PURGED',

Line 569: fnd_file.put_line(fnd_file.log,

565: purged_by_user_id = hz_utility_v2pub.user_id
566: WHERE batch_id = p_batch_id;
567: COMMIT;
568:
569: fnd_file.put_line(fnd_file.log,
570: ' Update pos_imp_batch_summary table (-)');
571: EXCEPTION
572: WHEN OTHERS THEN
573: ROLLBACK WORK;

Line 574: fnd_file.put_line(fnd_file.log, SQLERRM);

570: ' Update pos_imp_batch_summary table (-)');
571: EXCEPTION
572: WHEN OTHERS THEN
573: ROLLBACK WORK;
574: fnd_file.put_line(fnd_file.log, SQLERRM);
575: retcode := 2;
576: RETURN;
577: END purge_batch;
578: