DBA Data[Home] [Help]

APPS.IGF_GR_YTD_LOAD_DATA dependencies on FND_FILE

Line 80: fnd_file.put_line(fnd_file.log,fnd_message.get);

76: IF get_orig_rec.rec_count = 0 THEN
77:
78: fnd_message.set_name('IGF','IGF_GR_REC_NOT_FOUND');
79: fnd_message.set_token('ORIG_ID',p_ytd_orig_row.origination_id);
80: fnd_file.put_line(fnd_file.log,fnd_message.get);
81: RAISE igf_gr_gen.skip_this_record;
82:
83: ELSE
84:

Line 265: fnd_file.put_line(fnd_file.log,fnd_message.get);

261: IF get_orig_rec.rec_count = 0 THEN
262:
263: fnd_message.set_name('IGF','IGF_GR_REC_NOT_FOUND');
264: fnd_message.set_token('ORIG_ID',p_ytd_disb_row.origination_id);
265: fnd_file.put_line(fnd_file.log,fnd_message.get);
266: RAISE igf_gr_gen.skip_this_record;
267:
268: ELSE
269:

Line 502: fnd_file.put_line(fnd_file.log,fnd_message.get);

498: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
499: fnd_message.set_token('BATCH',l_batch_id);
500: fnd_message.set_token('AWD_YR',g_c_alt_code);
501: fnd_message.set_token('VRSN',g_ver_num);
502: fnd_file.put_line(fnd_file.log,fnd_message.get);
503: RAISE invalid_version;
504: END IF;
505:
506: IF l_number_rec > 0 THEN

Line 553: fnd_file.put_line(fnd_file.log,fnd_message.get());

549: -- Make an entry in the log file indicating Success
550: --
551: fnd_message.set_name('IGF','IGF_GR_YTDOR_LOAD_PASS');
552: fnd_message.set_token('ORIGINATION_ID',lv_ytdor_row.origination_id);
553: fnd_file.put_line(fnd_file.log,fnd_message.get());
554:
555: lp_count := lp_count + 1;
556:
557: EXCEPTION

Line 561: fnd_file.put_line(fnd_file.log,fnd_message.get());

557: EXCEPTION
558: WHEN igf_gr_gen.skip_this_record THEN
559: fnd_message.set_name('IGF','IGF_GR_YTDOR_LOAD_FAIL');
560: fnd_message.set_token('ORIGINATION_ID',SUBSTR( ytd_rec_data.record_data, 2, 23));
561: fnd_file.put_line(fnd_file.log,fnd_message.get());
562: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
563: fnd_file.put_line(fnd_file.log,fnd_message.get);
564: lf_count := lf_count + 1;
565:

Line 563: fnd_file.put_line(fnd_file.log,fnd_message.get);

559: fnd_message.set_name('IGF','IGF_GR_YTDOR_LOAD_FAIL');
560: fnd_message.set_token('ORIGINATION_ID',SUBSTR( ytd_rec_data.record_data, 2, 23));
561: fnd_file.put_line(fnd_file.log,fnd_message.get());
562: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
563: fnd_file.put_line(fnd_file.log,fnd_message.get);
564: lf_count := lf_count + 1;
565:
566: WHEN igf_gr_gen.no_file_version THEN
567: RAISE;

Line 592: fnd_file.put_line(fnd_file.log,fnd_message.get());

588: -- Make an entry in the log file indicating Success
589: --
590: fnd_message.set_name('IGF','IGF_GR_YTDDS_LOAD_PASS');
591: fnd_message.set_token('ORIGINATION_ID',lv_ytdds_row.origination_id);
592: fnd_file.put_line(fnd_file.log,fnd_message.get());
593:
594: lp_count := lp_count + 1;
595:
596: EXCEPTION

Line 604: fnd_file.put_line(fnd_file.log,fnd_message.get());

600: -- Make an entry in the log file indicating Failure
601: --
602: fnd_message.set_name('IGF','IGF_GR_YTDDS_LOAD_FAIL');
603: fnd_message.set_token('ORIGINATION_ID',SUBSTR( ytd_rec_data.record_data, 2, 23));
604: fnd_file.put_line(fnd_file.log,fnd_message.get());
605: lf_count := lf_count + 1;
606: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
607: fnd_file.put_line(fnd_file.log,fnd_message.get);
608:

Line 607: fnd_file.put_line(fnd_file.log,fnd_message.get);

603: fnd_message.set_token('ORIGINATION_ID',SUBSTR( ytd_rec_data.record_data, 2, 23));
604: fnd_file.put_line(fnd_file.log,fnd_message.get());
605: lf_count := lf_count + 1;
606: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
607: fnd_file.put_line(fnd_file.log,fnd_message.get);
608:
609: WHEN igf_gr_gen.no_file_version THEN
610: RAISE;
611:

Line 625: fnd_file.put_line(fnd_file.log,fnd_message.get);

621: END IF;
622:
623: IF l_number_rec <> (lp_count + lf_count) THEN
624: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
625: fnd_file.put_line(fnd_file.log,fnd_message.get);
626: RAISE igf_gr_gen.file_not_loaded;
627: END IF;
628:
629: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');

Line 631: fnd_file.put_line(fnd_file.log,fnd_message.get);

627: END IF;
628:
629: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
630: fnd_message.set_token('CNT',l_number_rec);
631: fnd_file.put_line(fnd_file.log,fnd_message.get);
632:
633: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
634: fnd_message.set_token('CNT',lp_count);
635: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 635: fnd_file.put_line(fnd_file.log,fnd_message.get);

631: fnd_file.put_line(fnd_file.log,fnd_message.get);
632:
633: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
634: fnd_message.set_token('CNT',lp_count);
635: fnd_file.put_line(fnd_file.log,fnd_message.get);
636:
637: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
638: fnd_message.set_token('CNT',lf_count);
639: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 639: fnd_file.put_line(fnd_file.log,fnd_message.get);

635: fnd_file.put_line(fnd_file.log,fnd_message.get);
636:
637: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
638: fnd_message.set_token('CNT',lf_count);
639: fnd_file.put_line(fnd_file.log,fnd_message.get);
640:
641: EXCEPTION
642:
643: WHEN invalid_version THEN

Line 720: fnd_file.put_line(fnd_file.log,errbuf);

716: WHEN param_error THEN
717: ROLLBACK;
718: retcode := 2;
719: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
720: fnd_file.put_line(fnd_file.log,errbuf);
721:
722: WHEN igf_gr_gen.corrupt_data_file THEN
723: ROLLBACK;
724: retcode := 2;

Line 726: fnd_file.put_line(fnd_file.log,errbuf);

722: WHEN igf_gr_gen.corrupt_data_file THEN
723: ROLLBACK;
724: retcode := 2;
725: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
726: fnd_file.put_line(fnd_file.log,errbuf);
727:
728: WHEN igf_gr_gen.file_not_loaded THEN
729: ROLLBACK;
730: retcode := 2;

Line 732: fnd_file.put_line(fnd_file.log,errbuf);

728: WHEN igf_gr_gen.file_not_loaded THEN
729: ROLLBACK;
730: retcode := 2;
731: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
732: fnd_file.put_line(fnd_file.log,errbuf);
733:
734: WHEN igf_gr_gen.no_file_version THEN
735: ROLLBACK;
736: retcode := 2;