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

Line 40: -- Removed igf_gr_gen.get_pell_efc call from

36: ------------------------------------------------------------------------
37: -- sjadhav 01-Aug-2003 Bug 3062062
38: -- Removed variable lv_enrollment_status from
39: -- pell_calc routine
40: -- Removed igf_gr_gen.get_pell_efc call from
41: -- pell_calc routine
42: -- Modified pell_calc routine to default
43: -- Enrollment Status to Full time when called
44: -- from IGFGR02B - Pell Origination process

Line 83: -- igf_gr_gen.get_cycle_year

79: ------------------------------------------------------------------------
80: -- sjadhav 10-Feb-2003 Bug 2758812 - FA116 Pell Build
81: -- Modified generate_origination_id to read
82: -- pell cycle year using function
83: -- igf_gr_gen.get_cycle_year
84: ------------------------------------------------------------------------
85: -- sjadhav FA105 108 Bug 2613546,2606001
86: -- modified pell_calc routine
87: -- modified c_fa_base cursor to read

Line 439: fnd_message.set_token('STUD',igf_gr_gen.get_per_num(l_award.base_id));

435: CLOSE c_fa_base ;
436:
437: fnd_file.new_line(fnd_file.log,1);
438: fnd_message.set_name('IGF','IGF_AW_PROCESS_STUD');
439: fnd_message.set_token('STUD',igf_gr_gen.get_per_num(l_award.base_id));
440: fnd_file.put_line(fnd_file.log,fnd_message.get);
441: fnd_file.new_line(fnd_file.log,1);
442:
443: OPEN cur_payment_isir(l_award.base_id);

Line 557: l_stu_num:=igf_gr_gen.get_per_num(l_award.base_id);

553: FETCH c_get_rep_entity_id INTO l_rep_entity_id;
554: CLOSE c_get_rep_entity_id;
555:
556: IF (l_rep_entity_id IS NULL) THEN
557: l_stu_num:=igf_gr_gen.get_per_num(l_award.base_id);
558: fnd_message.set_name( 'IGF', 'IGF_GR_NOREP_ENTITY');
559: fnd_message.set_token('STU_NUMBER',l_stu_num);
560: fnd_file.put_line(fnd_file.log,fnd_message.get());
561: RAISE MY_EXP;

Line 571: l_stu_num:=igf_gr_gen.get_per_num(l_award.base_id);

567: FETCH c_get_rep_pell_id INTO l_rep_pell_id;
568: CLOSE c_get_rep_pell_id;
569:
570: IF (l_rep_pell_id IS NULL) THEN
571: l_stu_num:=igf_gr_gen.get_per_num(l_award.base_id);
572: fnd_message.set_name( 'IGF', 'IGF_GR_NOREP_PELL');
573: fnd_message.set_token('STU_NUMBER',l_stu_num);
574: fnd_file.put_line(fnd_file.log,fnd_message.get());
575: RAISE MY_EXP;

Line 607: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(l_fa_base.base_id));

603: IF (cur_chk_duplicate_ssn%FOUND) THEN
604: CLOSE cur_chk_duplicate_ssn;
605: fnd_message.set_name( 'IGF', 'IGF_SL_SSN_IN_USE');
606: fnd_message.set_token('VALUE',SUBSTR(l_origination_id,1,9));
607: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(l_fa_base.base_id));
608: fnd_file.put_line(fnd_file.log,fnd_message.get());
609: RAISE MY_EXP;
610: END IF;
611: CLOSE cur_chk_duplicate_ssn;

Line 615: fnd_message.set_token('STUD', igf_gr_gen.get_per_num(l_fa_base.base_id));

611: CLOSE cur_chk_duplicate_ssn;
612:
613: IF ( l_error = 'ISIR' ) THEN
614: fnd_message.set_name( 'IGF', 'IGF_GR_ISIR_NOT_FOUND');
615: fnd_message.set_token('STUD', igf_gr_gen.get_per_num(l_fa_base.base_id));
616: fnd_file.put_line(fnd_file.log,fnd_message.get());
617: RAISE NO_SETUP;
618:
619: ELSIF ( l_error = 'CAL' ) THEN

Line 622: fnd_message.set_token('STUD', igf_gr_gen.get_per_num(l_fa_base.base_id));

618:
619: ELSIF ( l_error = 'CAL' ) THEN
620:
621: fnd_message.set_name( 'IGF', 'IGF_GR_CAL_NOT_FOUND');
622: fnd_message.set_token('STUD', igf_gr_gen.get_per_num(l_fa_base.base_id));
623: fnd_file.put_line(fnd_file.log,fnd_message.get());
624: RAISE NO_SETUP;
625:
626: ELSIF ( l_error = 'VAL_NULL' ) then

Line 629: fnd_message.set_token('STUD',igf_gr_gen.get_per_num(l_fa_base.base_id));

625:
626: ELSIF ( l_error = 'VAL_NULL' ) then
627:
628: fnd_message.set_name( 'IGF', 'IGF_GR_VALS_NULL');
629: fnd_message.set_token('STUD',igf_gr_gen.get_per_num(l_fa_base.base_id));
630: fnd_file.put_line(fnd_file.log,fnd_message.get());
631:
632: RAISE NO_SETUP;
633:

Line 644: l_rfms_rec.efc := igf_gr_gen.get_pell_efc(l_fa_base.base_id);

640: l_rfms_rec.award_id := l_award.award_id;
641: l_rfms_rec.sys_orig_ssn := LTRIM(RTRIM(l_fa_base.original_ssn));
642: l_rfms_rec.sys_orig_name_cd := LTRIM(RTRIM(l_fa_base.orig_name_id));
643: l_rfms_rec.transaction_num := l_fa_base.transaction_num;
644: l_rfms_rec.efc := igf_gr_gen.get_pell_efc(l_fa_base.base_id);
645:
646: --
647: -- Federal Verification Status Mapping with Grants Verification Status Code is impletemented
648: -- in igf_ap_batch_ver_prc_pkg packages The call has been added here

Line 654: l_rfms_rec.secondary_efc_cd := igf_gr_gen.get_pell_efc_code(l_fa_base.base_id);

650:
651: l_rfms_rec.ver_status_code := igf_ap_batch_ver_prc_pkg.get_gr_ver_code(l_fa_base.fed_verif_status,
652: l_fa_base.ci_cal_type,
653: l_fa_base.ci_sequence_number);
654: l_rfms_rec.secondary_efc_cd := igf_gr_gen.get_pell_efc_code(l_fa_base.base_id);
655:
656: ---
657: -- Bug ID : 1774268
658: --

Line 748: l_rfms_rec.low_tution_fee := igf_gr_gen.get_tufees_code(l_fa_base.base_id,

744: --
745:
746: l_pell_mat := l_award.alt_pell_schedule;
747: IF l_pell_mat = 'A' THEN
748: l_rfms_rec.low_tution_fee := igf_gr_gen.get_tufees_code(l_fa_base.base_id,
749: l_fa_base.ci_cal_type,
750: l_fa_base.ci_sequence_number);
751: ELSE
752: l_rfms_rec.low_tution_fee := NULL;

Line 819: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(l_fa_base.base_id));

815: x_document_id_txt => NULL );
816:
817: fnd_file.put_line(fnd_file.log,'');
818: fnd_message.set_name('IGF','IGF_GR_CREATE_RFMS');
819: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(l_fa_base.base_id));
820: fnd_message.set_token('ORIG_ID',l_rfms_rec.origination_id);
821: fnd_file.put_line(fnd_file.log, fnd_message.get);
822: fnd_file.put_line(fnd_file.log,'');
823:

Line 1031: -- igf_gr_gen.get_cycle_year

1027: ------------------------------------------------------------------------
1028: -- sjadhav 10-Feb-2003 Bug 2758812 - FA116 Pell Build
1029: -- Modified generate_origination_id to read
1030: -- pell cycle year using function
1031: -- igf_gr_gen.get_cycle_year
1032: ------------------------------------------------------------------------
1033:
1034: CURSOR c_isir ( x_base_id igf_ap_fa_base_rec.base_id%TYPE)
1035: IS

Line 1088: igf_gr_gen.get_cycle_year

1084: (l_cal.ci_cal_type IS NOT NULL) AND
1085: (l_attend_pell_id IS NOT NULL)) THEN
1086: l_origination_id := l_isir.original_ssn ||
1087: RPAD(l_isir.orig_name_id,2,' ') ||
1088: igf_gr_gen.get_cycle_year
1089: (l_cal.ci_cal_type,
1090: l_cal.ci_sequence_number) ||
1091: RTRIM(LTRIM(l_attend_pell_id)) ||
1092: '00';