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_ESS_ESD_DATA dependencies on IGF_GR_GEN

Line 72: RAISE igf_gr_gen.skip_this_record;

68:
69:
70: EXCEPTION
71: WHEN OTHERS THEN -- Number / Date format exception
72: RAISE igf_gr_gen.skip_this_record;
73:
74: END;
75:
76: ELSIF g_ver_num IN ('2005-2006','2006-2007') THEN

Line 100: RAISE igf_gr_gen.skip_this_record;

96:
97:
98: EXCEPTION
99: WHEN OTHERS THEN -- Number / Date format exception
100: RAISE igf_gr_gen.skip_this_record;
101:
102: END;
103: ELSE
104: RAISE igf_gr_gen.no_file_version;

Line 104: RAISE igf_gr_gen.no_file_version;

100: RAISE igf_gr_gen.skip_this_record;
101:
102: END;
103: ELSE
104: RAISE igf_gr_gen.no_file_version;
105: END IF;
106:
107: EXCEPTION
108:

Line 109: WHEN igf_gr_gen.skip_this_record THEN

105: END IF;
106:
107: EXCEPTION
108:
109: WHEN igf_gr_gen.skip_this_record THEN
110: RAISE;
111:
112: WHEN igf_gr_gen.no_file_version THEN
113: RAISE;

Line 112: WHEN igf_gr_gen.no_file_version THEN

108:
109: WHEN igf_gr_gen.skip_this_record THEN
110: RAISE;
111:
112: WHEN igf_gr_gen.no_file_version THEN
113: RAISE;
114:
115: WHEN OTHERS THEN
116: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

Line 155: RAISE igf_gr_gen.skip_this_record;

151: p_esd_rec.adj_batch_id := SUBSTR(p_record_data,74,26);
152:
153: EXCEPTION
154: WHEN OTHERS THEN -- Number / Date format exception
155: RAISE igf_gr_gen.skip_this_record;
156: END;
157:
158: ELSIF g_ver_num IN ('2005-2006','2006-2007') THEN
159:

Line 172: RAISE igf_gr_gen.skip_this_record;

168: p_esd_rec.adj_batch_id := SUBSTR(p_record_data,74,30);
169:
170: EXCEPTION
171: WHEN OTHERS THEN -- Number / Date format exception
172: RAISE igf_gr_gen.skip_this_record;
173: END;
174:
175: ELSE
176: RAISE igf_gr_gen.no_file_version;

Line 176: RAISE igf_gr_gen.no_file_version;

172: RAISE igf_gr_gen.skip_this_record;
173: END;
174:
175: ELSE
176: RAISE igf_gr_gen.no_file_version;
177: END IF;
178:
179: EXCEPTION
180:

Line 181: WHEN igf_gr_gen.skip_this_record THEN

177: END IF;
178:
179: EXCEPTION
180:
181: WHEN igf_gr_gen.skip_this_record THEN
182: RAISE;
183:
184: WHEN igf_gr_gen.no_file_version THEN
185: RAISE;

Line 184: WHEN igf_gr_gen.no_file_version THEN

180:
181: WHEN igf_gr_gen.skip_this_record THEN
182: RAISE;
183:
184: WHEN igf_gr_gen.no_file_version THEN
185: RAISE;
186:
187: WHEN OTHERS THEN
188: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

Line 311: igf_gr_gen.process_pell_ack ( g_ver_num,

307: l_c_message VARCHAR2(30); -- Local variable to hold message
308:
309: BEGIN
310:
311: igf_gr_gen.process_pell_ack ( g_ver_num,
312: 'ESS',
313: l_number_rec,
314: l_last_gldr_id,
315: l_batch_id);

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

314: l_last_gldr_id,
315: l_batch_id);
316:
317: -- Check the award year matches with the award year in PELL setup.
318: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, l_c_message);
319: IF l_c_message = 'IGF_GR_VRSN_MISMTCH' THEN
320: fnd_message.set_name ('IGF',l_c_message);
321: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
322: fnd_message.set_token('BATCH',l_batch_id);

Line 377: WHEN igf_gr_gen.skip_this_record THEN

373:
374: lp_count := lp_count + 1;
375:
376: EXCEPTION
377: WHEN igf_gr_gen.skip_this_record THEN
378: fnd_message.set_name('IGF','IGF_GR_ESS_LOAD_FAIL');
379: fnd_message.set_token('VALUE',' ');
380: fnd_file.put_line(fnd_file.log,fnd_message.get);
381:

Line 386: WHEN igf_gr_gen.no_file_version THEN

382: lf_count := lf_count + 1;
383: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
384: fnd_file.put_line(fnd_file.log,fnd_message.get);
385:
386: WHEN igf_gr_gen.no_file_version THEN
387: RAISE;
388:
389: END;
390: ELSE

Line 402: RAISE igf_gr_gen.file_not_loaded;

398:
399: IF l_number_rec <> (lp_count + lf_count) THEN
400: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
401: fnd_file.put_line(fnd_file.log,fnd_message.get);
402: RAISE igf_gr_gen.file_not_loaded;
403: END IF;
404:
405: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
406: fnd_message.set_token('CNT',l_number_rec);

Line 422: WHEN igf_gr_gen.no_file_version THEN

418: EXCEPTION
419: WHEN invalid_version THEN
420: RAISE;
421:
422: WHEN igf_gr_gen.no_file_version THEN
423: RAISE;
424: WHEN igf_gr_gen.corrupt_data_file THEN
425: RAISE;
426: WHEN igf_gr_gen.file_not_loaded THEN

Line 424: WHEN igf_gr_gen.corrupt_data_file THEN

420: RAISE;
421:
422: WHEN igf_gr_gen.no_file_version THEN
423: RAISE;
424: WHEN igf_gr_gen.corrupt_data_file THEN
425: RAISE;
426: WHEN igf_gr_gen.file_not_loaded THEN
427: RAISE;
428:

Line 426: WHEN igf_gr_gen.file_not_loaded THEN

422: WHEN igf_gr_gen.no_file_version THEN
423: RAISE;
424: WHEN igf_gr_gen.corrupt_data_file THEN
425: RAISE;
426: WHEN igf_gr_gen.file_not_loaded THEN
427: RAISE;
428:
429: WHEN OTHERS THEN
430: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

Line 460: igf_gr_gen.process_pell_ack ( g_ver_num,

456: l_c_message VARCHAR2(30); -- Local variable to hold message
457:
458: BEGIN
459:
460: igf_gr_gen.process_pell_ack ( g_ver_num,
461: 'ESD',
462: l_number_rec,
463: l_last_gldr_id,
464: l_batch_id);

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

463: l_last_gldr_id,
464: l_batch_id);
465:
466: -- Check the award year matches with the award year in PELL setup.
467: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, l_c_message);
468: IF l_c_message = 'IGF_GR_VRSN_MISMTCH' THEN
469: fnd_message.set_name ('IGF',l_c_message);
470: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
471: fnd_message.set_token('BATCH',l_batch_id);

Line 524: WHEN igf_gr_gen.skip_this_record THEN

520: fnd_file.put_line(fnd_file.log,fnd_message.get);
521: lp_count := lp_count + 1;
522:
523: EXCEPTION
524: WHEN igf_gr_gen.skip_this_record THEN
525: fnd_message.set_name('IGF','IGF_GR_ESD_LOAD_FAIL');
526: fnd_message.set_token('VALUE',' ' );
527: fnd_file.put_line(fnd_file.log,fnd_message.get);
528: lf_count := lf_count + 1;

Line 532: WHEN igf_gr_gen.no_file_version THEN

528: lf_count := lf_count + 1;
529: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
530: fnd_file.put_line(fnd_file.log,fnd_message.get);
531:
532: WHEN igf_gr_gen.no_file_version THEN
533: RAISE;
534: END;
535: ELSE
536: lf_count := lf_count + 1;

Line 547: RAISE igf_gr_gen.file_not_loaded;

543:
544: IF l_number_rec <> (lp_count + lf_count) THEN
545: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
546: fnd_file.put_line(fnd_file.log,fnd_message.get);
547: RAISE igf_gr_gen.file_not_loaded;
548: END IF;
549:
550: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
551: fnd_message.set_token('CNT',l_number_rec);

Line 567: WHEN igf_gr_gen.no_file_version THEN

563:
564: EXCEPTION
565: WHEN invalid_version THEN
566: RAISE;
567: WHEN igf_gr_gen.no_file_version THEN
568: RAISE;
569: WHEN igf_gr_gen.corrupt_data_file THEN
570: RAISE;
571: WHEN igf_gr_gen.file_not_loaded THEN

Line 569: WHEN igf_gr_gen.corrupt_data_file THEN

565: WHEN invalid_version THEN
566: RAISE;
567: WHEN igf_gr_gen.no_file_version THEN
568: RAISE;
569: WHEN igf_gr_gen.corrupt_data_file THEN
570: RAISE;
571: WHEN igf_gr_gen.file_not_loaded THEN
572: RAISE;
573:

Line 571: WHEN igf_gr_gen.file_not_loaded THEN

567: WHEN igf_gr_gen.no_file_version THEN
568: RAISE;
569: WHEN igf_gr_gen.corrupt_data_file THEN
570: RAISE;
571: WHEN igf_gr_gen.file_not_loaded THEN
572: RAISE;
573:
574: WHEN OTHERS THEN
575: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

Line 627: g_c_alt_code := igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number);

623:
624: -- Get the Flat File Version and then Proceed
625: --
626: g_ver_num := igf_aw_gen.get_ver_num(l_ci_cal_type,l_ci_sequence_number,'P');
627: g_c_alt_code := igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number);
628:
629: IF g_ver_num ='NULL' THEN
630: RAISE igf_gr_gen.no_file_version;
631: ELSE

Line 630: RAISE igf_gr_gen.no_file_version;

626: g_ver_num := igf_aw_gen.get_ver_num(l_ci_cal_type,l_ci_sequence_number,'P');
627: g_c_alt_code := igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number);
628:
629: IF g_ver_num ='NULL' THEN
630: RAISE igf_gr_gen.no_file_version;
631: ELSE
632: esd_load;
633: END IF;
634:

Line 655: WHEN igf_gr_gen.corrupt_data_file THEN

651: retcode := 2;
652: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
653: fnd_file.put_line(fnd_file.log,errbuf);
654:
655: WHEN igf_gr_gen.corrupt_data_file THEN
656: ROLLBACK;
657: retcode := 2;
658: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
659: fnd_file.put_line(fnd_file.log,errbuf);

Line 661: WHEN igf_gr_gen.file_not_loaded THEN

657: retcode := 2;
658: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
659: fnd_file.put_line(fnd_file.log,errbuf);
660:
661: WHEN igf_gr_gen.file_not_loaded THEN
662: ROLLBACK;
663: retcode := 2;
664: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
665: fnd_file.put_line(fnd_file.log,errbuf);

Line 667: WHEN igf_gr_gen.no_file_version THEN

663: retcode := 2;
664: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
665: fnd_file.put_line(fnd_file.log,errbuf);
666:
667: WHEN igf_gr_gen.no_file_version THEN
668: ROLLBACK;
669: retcode := 2;
670: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');
671: igs_ge_msg_stack.conc_exception_hndl;

Line 726: g_c_alt_code := igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number);

722: --
723: -- Get the Flat File Version and then Proceed
724: --
725: g_ver_num := igf_aw_gen.get_ver_num(l_ci_cal_type,l_ci_sequence_number,'P');
726: g_c_alt_code := igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number);
727:
728: IF g_ver_num ='NULL' THEN
729: RAISE igf_gr_gen.no_file_version;
730: ELSE

Line 729: RAISE igf_gr_gen.no_file_version;

725: g_ver_num := igf_aw_gen.get_ver_num(l_ci_cal_type,l_ci_sequence_number,'P');
726: g_c_alt_code := igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number);
727:
728: IF g_ver_num ='NULL' THEN
729: RAISE igf_gr_gen.no_file_version;
730: ELSE
731: ess_load;
732: END IF;
733:

Line 748: WHEN igf_gr_gen.corrupt_data_file THEN

744: retcode := 2;
745: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
746: fnd_file.put_line(fnd_file.log,errbuf);
747:
748: WHEN igf_gr_gen.corrupt_data_file THEN
749: ROLLBACK;
750: retcode := 2;
751: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
752: fnd_file.put_line(fnd_file.log,errbuf);

Line 754: WHEN igf_gr_gen.file_not_loaded THEN

750: retcode := 2;
751: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
752: fnd_file.put_line(fnd_file.log,errbuf);
753:
754: WHEN igf_gr_gen.file_not_loaded THEN
755: ROLLBACK;
756: retcode := 2;
757: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
758: fnd_file.put_line(fnd_file.log,errbuf);

Line 760: WHEN igf_gr_gen.no_file_version THEN

756: retcode := 2;
757: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
758: fnd_file.put_line(fnd_file.log,errbuf);
759:
760: WHEN igf_gr_gen.no_file_version THEN
761: ROLLBACK;
762: retcode := 2;
763: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');
764: igs_ge_msg_stack.conc_exception_hndl;