DBA Data[Home] [Help]

APPS.IGF_GR_YTD_LOAD_DATA dependencies on FND_MESSAGE

Line 78: fnd_message.set_name('IGF','IGF_GR_REC_NOT_FOUND');

74: -- If origination id does not exist in the System, skip this record
75: --
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:

Line 79: fnd_message.set_token('ORIG_ID',p_ytd_orig_row.origination_id);

75: --
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

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 203: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

199: WHEN igf_gr_gen.no_file_version THEN
200: RAISE;
201:
202: WHEN OTHERS THEN
203: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
204: fnd_message.set_token('NAME','igf_gr_ytd_load_data.split_into_orig_fields');
205: igs_ge_msg_stack.add;
206: app_exception.raise_exception;
207:

Line 204: fnd_message.set_token('NAME','igf_gr_ytd_load_data.split_into_orig_fields');

200: RAISE;
201:
202: WHEN OTHERS THEN
203: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
204: fnd_message.set_token('NAME','igf_gr_ytd_load_data.split_into_orig_fields');
205: igs_ge_msg_stack.add;
206: app_exception.raise_exception;
207:
208: END split_into_orig_fields;

Line 263: fnd_message.set_name('IGF','IGF_GR_REC_NOT_FOUND');

259: -- If origination id does not exist in the System, skip this record
260: --
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:

Line 264: fnd_message.set_token('ORIG_ID',p_ytd_disb_row.origination_id);

260: --
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

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 321: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

317: WHEN igf_gr_gen.no_file_version THEN
318: RAISE;
319:
320: WHEN OTHERS THEN
321: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
322: fnd_message.set_token('NAME','igf_gr_ytd_load_data.split_into_disb_fields');
323: igs_ge_msg_stack.add;
324: app_exception.raise_exception;
325:

Line 322: fnd_message.set_token('NAME','igf_gr_ytd_load_data.split_into_disb_fields');

318: RAISE;
319:
320: WHEN OTHERS THEN
321: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
322: fnd_message.set_token('NAME','igf_gr_ytd_load_data.split_into_disb_fields');
323: igs_ge_msg_stack.add;
324: app_exception.raise_exception;
325:
326: END split_into_disb_fields ;

Line 403: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

399:
400: EXCEPTION
401:
402: WHEN OTHERS THEN
403: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
404: fnd_message.set_token('NAME','igf_gr_ytd_load_data.insert_in_ytdor_table');
405: igs_ge_msg_stack.add;
406: app_exception.raise_exception;
407:

Line 404: fnd_message.set_token('NAME','igf_gr_ytd_load_data.insert_in_ytdor_table');

400: EXCEPTION
401:
402: WHEN OTHERS THEN
403: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
404: fnd_message.set_token('NAME','igf_gr_ytd_load_data.insert_in_ytdor_table');
405: igs_ge_msg_stack.add;
406: app_exception.raise_exception;
407:
408: END insert_in_ytdor_table;

Line 457: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

453:
454: EXCEPTION
455:
456: WHEN OTHERS THEN
457: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
458: fnd_message.set_token('NAME','igf_gr_ytd_load_data.insert_in_ytdds_table');
459: igs_ge_msg_stack.add;
460: app_exception.raise_exception;
461:

Line 458: fnd_message.set_token('NAME','igf_gr_ytd_load_data.insert_in_ytdds_table');

454: EXCEPTION
455:
456: WHEN OTHERS THEN
457: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
458: fnd_message.set_token('NAME','igf_gr_ytd_load_data.insert_in_ytdds_table');
459: igs_ge_msg_stack.add;
460: app_exception.raise_exception;
461:
462: END insert_in_ytdds_table;

Line 497: fnd_message.set_name ('IGF',l_c_message);

493:
494: -- Check the award year matches with the award year in PELL setup.
495: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, l_c_message);
496: IF l_c_message = 'IGF_GR_VRSN_MISMTCH' THEN
497: fnd_message.set_name ('IGF',l_c_message);
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);

Line 498: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));

494: -- Check the award year matches with the award year in PELL setup.
495: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, l_c_message);
496: IF l_c_message = 'IGF_GR_VRSN_MISMTCH' THEN
497: fnd_message.set_name ('IGF',l_c_message);
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);

Line 499: fnd_message.set_token('BATCH',l_batch_id);

495: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, l_c_message);
496: IF l_c_message = 'IGF_GR_VRSN_MISMTCH' THEN
497: fnd_message.set_name ('IGF',l_c_message);
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;

Line 500: fnd_message.set_token('AWD_YR',g_c_alt_code);

496: IF l_c_message = 'IGF_GR_VRSN_MISMTCH' THEN
497: fnd_message.set_name ('IGF',l_c_message);
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;

Line 501: fnd_message.set_token('VRSN',g_ver_num);

497: fnd_message.set_name ('IGF',l_c_message);
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:

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 551: fnd_message.set_name('IGF','IGF_GR_YTDOR_LOAD_PASS');

547: insert_in_ytdor_table (lv_ytdor_row );
548: --
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;

Line 552: fnd_message.set_token('ORIGINATION_ID',lv_ytdor_row.origination_id);

548: --
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:

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 559: fnd_message.set_name('IGF','IGF_GR_YTDOR_LOAD_FAIL');

555: lp_count := lp_count + 1;
556:
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);

Line 560: fnd_message.set_token('ORIGINATION_ID',SUBSTR( ytd_rec_data.record_data, 2, 23));

556:
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;

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 562: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

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:
566: WHEN igf_gr_gen.no_file_version THEN

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 590: fnd_message.set_name('IGF','IGF_GR_YTDDS_LOAD_PASS');

586: insert_in_ytdds_table (lv_ytdds_row ) ;
587: --
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;

Line 591: fnd_message.set_token('ORIGINATION_ID',lv_ytdds_row.origination_id);

587: --
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:

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 602: fnd_message.set_name('IGF','IGF_GR_YTDDS_LOAD_FAIL');

598: WHEN igf_gr_gen.skip_this_record THEN
599: --
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');

Line 603: fnd_message.set_token('ORIGINATION_ID',SUBSTR( ytd_rec_data.record_data, 2, 23));

599: --
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);

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 606: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

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:
609: WHEN igf_gr_gen.no_file_version THEN
610: RAISE;

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 624: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');

620:
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:

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 629: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');

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');
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');

Line 630: fnd_message.set_token('CNT',l_number_rec);

626: RAISE igf_gr_gen.file_not_loaded;
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);

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 633: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');

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);
636:
637: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');

Line 634: fnd_message.set_token('CNT',lp_count);

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);
636:
637: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
638: fnd_message.set_token('CNT',lf_count);

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 637: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');

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);
640:
641: EXCEPTION

Line 638: fnd_message.set_token('CNT',lf_count);

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);
640:
641: EXCEPTION
642:

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 653: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

649: WHEN igf_gr_gen.file_not_loaded THEN
650: RAISE;
651:
652: WHEN OTHERS THEN
653: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
654: fnd_message.set_token('NAME','igf_gr_ytd_load_data.load_ack');
655: igs_ge_msg_stack.add;
656: app_exception.raise_exception;
657:

Line 654: fnd_message.set_token('NAME','igf_gr_ytd_load_data.load_ack');

650: RAISE;
651:
652: WHEN OTHERS THEN
653: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
654: fnd_message.set_token('NAME','igf_gr_ytd_load_data.load_ack');
655: igs_ge_msg_stack.add;
656: app_exception.raise_exception;
657:
658: END load_ack;

Line 719: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');

715:
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;

Line 725: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');

721:
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;

Line 731: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');

727:
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;

Line 737: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');

733:
734: WHEN igf_gr_gen.no_file_version THEN
735: ROLLBACK;
736: retcode := 2;
737: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');
738: igs_ge_msg_stack.conc_exception_hndl;
739:
740: WHEN others THEN
741:

Line 744: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');

740: WHEN others THEN
741:
742: ROLLBACK;
743: retcode := 2;
744: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
745: igs_ge_msg_stack.conc_exception_hndl;
746:
747: END ytd_load_file;
748: