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.IGF_GR_YTD_LOAD_DATA dependencies on IGF_GR_GEN

Line 81: RAISE igf_gr_gen.skip_this_record;

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:
85: p_ytd_orig_row.original_ssn := SUBSTR( p_record_data, 25, 9);

Line 136: RAISE igf_gr_gen.skip_this_record;

132: END IF;
133:
134: EXCEPTION
135: WHEN OTHERS THEN -- Number / Date format exception
136: RAISE igf_gr_gen.skip_this_record;
137:
138: END;
139:
140: ELSIF g_ver_num IN ('2005-2006','2006-2007') THEN

Line 191: RAISE igf_gr_gen.no_file_version;

187: p_ytd_orig_row.process_date := fnd_date.string_to_date(SUBSTR( p_record_data, 337, 8), 'YYYYMMDD');
188:
189:
190: ELSE
191: RAISE igf_gr_gen.no_file_version;
192: END IF;
193:
194: EXCEPTION
195:

Line 196: WHEN igf_gr_gen.skip_this_record THEN

192: END IF;
193:
194: EXCEPTION
195:
196: WHEN igf_gr_gen.skip_this_record THEN
197: RAISE;
198:
199: WHEN igf_gr_gen.no_file_version THEN
200: RAISE;

Line 199: WHEN igf_gr_gen.no_file_version THEN

195:
196: WHEN igf_gr_gen.skip_this_record THEN
197: RAISE;
198:
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');

Line 266: RAISE igf_gr_gen.skip_this_record;

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:
270: p_ytd_disb_row.inst_cross_ref_code := SUBSTR( p_record_data, 25, 13);

Line 283: RAISE igf_gr_gen.skip_this_record;

279: END IF;
280:
281: EXCEPTION
282: WHEN OTHERS THEN -- Number / Date format exception
283: RAISE igf_gr_gen.skip_this_record;
284:
285: END;
286:
287: ELSIF g_ver_num IN ('2005-2006','2006-2007') THEN

Line 309: RAISE igf_gr_gen.no_file_version;

305: p_ytd_disb_row.disb_rel_ind := SUBSTR(p_record_data, 204, 1);
306: p_ytd_disb_row.prev_disb_seq_num := TO_NUMBER(SUBSTR(p_record_data, 205, 2));
307:
308: ELSE
309: RAISE igf_gr_gen.no_file_version;
310: END IF;
311:
312: EXCEPTION
313:

Line 314: WHEN igf_gr_gen.skip_this_record THEN

310: END IF;
311:
312: EXCEPTION
313:
314: WHEN igf_gr_gen.skip_this_record THEN
315: RAISE;
316:
317: WHEN igf_gr_gen.no_file_version THEN
318: RAISE;

Line 317: WHEN igf_gr_gen.no_file_version THEN

313:
314: WHEN igf_gr_gen.skip_this_record THEN
315: RAISE;
316:
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');

Line 488: igf_gr_gen.process_pell_ack ( g_ver_num,

484: l_c_message VARCHAR2(30); -- Local variable to hold message
485:
486: BEGIN
487:
488: igf_gr_gen.process_pell_ack ( g_ver_num,
489: 'YTD',
490: l_number_rec,
491: l_last_gldr_id,
492: l_batch_id);

Line 495: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, l_c_message);

491: l_last_gldr_id,
492: l_batch_id);
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);

Line 558: WHEN igf_gr_gen.skip_this_record THEN

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

Line 566: WHEN igf_gr_gen.no_file_version THEN

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;
568:
569: END;
570:

Line 598: WHEN igf_gr_gen.skip_this_record THEN

594: lp_count := lp_count + 1;
595:
596: EXCEPTION
597:
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');

Line 609: WHEN igf_gr_gen.no_file_version THEN

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:
612: END ;
613: ELSE

Line 626: RAISE igf_gr_gen.file_not_loaded;

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');
630: fnd_message.set_token('CNT',l_number_rec);

Line 645: WHEN igf_gr_gen.no_file_version THEN

641: EXCEPTION
642:
643: WHEN invalid_version THEN
644: RAISE;
645: WHEN igf_gr_gen.no_file_version THEN
646: RAISE;
647: WHEN igf_gr_gen.corrupt_data_file THEN
648: RAISE;
649: WHEN igf_gr_gen.file_not_loaded THEN

Line 647: WHEN igf_gr_gen.corrupt_data_file THEN

643: WHEN invalid_version THEN
644: RAISE;
645: WHEN igf_gr_gen.no_file_version THEN
646: RAISE;
647: WHEN igf_gr_gen.corrupt_data_file THEN
648: RAISE;
649: WHEN igf_gr_gen.file_not_loaded THEN
650: RAISE;
651:

Line 649: WHEN igf_gr_gen.file_not_loaded THEN

645: WHEN igf_gr_gen.no_file_version THEN
646: RAISE;
647: WHEN igf_gr_gen.corrupt_data_file THEN
648: RAISE;
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');

Line 700: g_c_alt_code := igf_gr_gen.get_alt_code(g_ci_cal_type,g_ci_sequence_number);

696: --
697: -- Get the Flat File Version and then Proceed
698: --
699: g_ver_num := igf_aw_gen.get_ver_num(g_ci_cal_type,g_ci_sequence_number,'P');
700: g_c_alt_code := igf_gr_gen.get_alt_code(g_ci_cal_type,g_ci_sequence_number);
701:
702: IF g_ver_num ='NULL' THEN
703: RAISE igf_gr_gen.no_file_version;
704: ELSE

Line 703: RAISE igf_gr_gen.no_file_version;

699: g_ver_num := igf_aw_gen.get_ver_num(g_ci_cal_type,g_ci_sequence_number,'P');
700: g_c_alt_code := igf_gr_gen.get_alt_code(g_ci_cal_type,g_ci_sequence_number);
701:
702: IF g_ver_num ='NULL' THEN
703: RAISE igf_gr_gen.no_file_version;
704: ELSE
705: load_ack;
706: END IF;
707:

Line 722: WHEN igf_gr_gen.corrupt_data_file THEN

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;
725: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
726: fnd_file.put_line(fnd_file.log,errbuf);

Line 728: WHEN igf_gr_gen.file_not_loaded THEN

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;
731: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
732: fnd_file.put_line(fnd_file.log,errbuf);

Line 734: WHEN igf_gr_gen.no_file_version THEN

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;
737: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');
738: igs_ge_msg_stack.conc_exception_hndl;