APPS.IGF_GR_PELL_CALC dependencies on FND_MESSAGE

Line 125: fnd_message.set_name( 'IGF','IGF_AW_NO_ANNL_INST_TIME');

121: || ' -> ' || p_acad_weeks);
122: END IF;
123:
124: IF p_acad_weeks IS NULL THEN
125: fnd_message.set_name( 'IGF','IGF_AW_NO_ANNL_INST_TIME');
126: fnd_message.set_token('PROGRAM_CODE',p_course_cd);
127: fnd_message.set_token('VERSION_NUM',p_version_number);
128: p_message := fnd_message.get ;
129: p_result := 'E' ;

Line 126: fnd_message.set_token('PROGRAM_CODE',p_course_cd);

122: END IF;
123:
124: IF p_acad_weeks IS NULL THEN
125: fnd_message.set_name( 'IGF','IGF_AW_NO_ANNL_INST_TIME');
126: fnd_message.set_token('PROGRAM_CODE',p_course_cd);
127: fnd_message.set_token('VERSION_NUM',p_version_number);
128: p_message := fnd_message.get ;
129: p_result := 'E' ;
130: RETURN;

Line 127: fnd_message.set_token('VERSION_NUM',p_version_number);

123:
124: IF p_acad_weeks IS NULL THEN
125: fnd_message.set_name( 'IGF','IGF_AW_NO_ANNL_INST_TIME');
126: fnd_message.set_token('PROGRAM_CODE',p_course_cd);
127: fnd_message.set_token('VERSION_NUM',p_version_number);
128: p_message := fnd_message.get ;
129: p_result := 'E' ;
130: RETURN;
131: ELSIF p_acad_weeks = 0 THEN

Line 128: p_message := fnd_message.get ;

124: IF p_acad_weeks IS NULL THEN
125: fnd_message.set_name( 'IGF','IGF_AW_NO_ANNL_INST_TIME');
126: fnd_message.set_token('PROGRAM_CODE',p_course_cd);
127: fnd_message.set_token('VERSION_NUM',p_version_number);
128: p_message := fnd_message.get ;
129: p_result := 'E' ;
130: RETURN;
131: ELSIF p_acad_weeks = 0 THEN
132: fnd_message.set_name( 'IGF','IGF_AW_ZERO_ANNL_TIME');

Line 132: fnd_message.set_name( 'IGF','IGF_AW_ZERO_ANNL_TIME');

128: p_message := fnd_message.get ;
129: p_result := 'E' ;
130: RETURN;
131: ELSIF p_acad_weeks = 0 THEN
132: fnd_message.set_name( 'IGF','IGF_AW_ZERO_ANNL_TIME');
133: fnd_message.set_token('PROGRAM_CODE',p_course_cd);
134: fnd_message.set_token('VERSION_NUM',p_version_number);
135: p_message := fnd_message.get ;
136: p_result := 'E' ;

Line 133: fnd_message.set_token('PROGRAM_CODE',p_course_cd);

129: p_result := 'E' ;
130: RETURN;
131: ELSIF p_acad_weeks = 0 THEN
132: fnd_message.set_name( 'IGF','IGF_AW_ZERO_ANNL_TIME');
133: fnd_message.set_token('PROGRAM_CODE',p_course_cd);
134: fnd_message.set_token('VERSION_NUM',p_version_number);
135: p_message := fnd_message.get ;
136: p_result := 'E' ;
137: RETURN;

Line 134: fnd_message.set_token('VERSION_NUM',p_version_number);

130: RETURN;
131: ELSIF p_acad_weeks = 0 THEN
132: fnd_message.set_name( 'IGF','IGF_AW_ZERO_ANNL_TIME');
133: fnd_message.set_token('PROGRAM_CODE',p_course_cd);
134: fnd_message.set_token('VERSION_NUM',p_version_number);
135: p_message := fnd_message.get ;
136: p_result := 'E' ;
137: RETURN;
138: END IF;

Line 135: p_message := fnd_message.get ;

131: ELSIF p_acad_weeks = 0 THEN
132: fnd_message.set_name( 'IGF','IGF_AW_ZERO_ANNL_TIME');
133: fnd_message.set_token('PROGRAM_CODE',p_course_cd);
134: fnd_message.set_token('VERSION_NUM',p_version_number);
135: p_message := fnd_message.get ;
136: p_result := 'E' ;
137: RETURN;
138: END IF;
139:

Line 156: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_ACAD_TIME');

152: || ' -> ' || p_term_weeks);
153: END IF;
154:
155: IF p_term_weeks = 0 THEN
156: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_ACAD_TIME');
157: fnd_message.set_token('PROGRAM_CODE',p_course_cd);
158: fnd_message.set_token('VERSION_NUM',p_version_number);
159: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
160: p_message := fnd_message.get;

Line 157: fnd_message.set_token('PROGRAM_CODE',p_course_cd);

153: END IF;
154:
155: IF p_term_weeks = 0 THEN
156: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_ACAD_TIME');
157: fnd_message.set_token('PROGRAM_CODE',p_course_cd);
158: fnd_message.set_token('VERSION_NUM',p_version_number);
159: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
160: p_message := fnd_message.get;
161: p_result := 'E';

Line 158: fnd_message.set_token('VERSION_NUM',p_version_number);

154:
155: IF p_term_weeks = 0 THEN
156: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_ACAD_TIME');
157: fnd_message.set_token('PROGRAM_CODE',p_course_cd);
158: fnd_message.set_token('VERSION_NUM',p_version_number);
159: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
160: p_message := fnd_message.get;
161: p_result := 'E';
162: RETURN;

Line 159: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));

155: IF p_term_weeks = 0 THEN
156: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_ACAD_TIME');
157: fnd_message.set_token('PROGRAM_CODE',p_course_cd);
158: fnd_message.set_token('VERSION_NUM',p_version_number);
159: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
160: p_message := fnd_message.get;
161: p_result := 'E';
162: RETURN;
163: END IF;

Line 160: p_message := fnd_message.get;

156: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_ACAD_TIME');
157: fnd_message.set_token('PROGRAM_CODE',p_course_cd);
158: fnd_message.set_token('VERSION_NUM',p_version_number);
159: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
160: p_message := fnd_message.get;
161: p_result := 'E';
162: RETURN;
163: END IF;
164:

Line 176: fnd_message.set_name('IGF','IGF_AW_NO_TERM_INST_TIME');

172:
173: p_term_weeks := get_term_time_rec.term_instruction_time;
174:
175: IF p_term_weeks IS NULL THEN
176: fnd_message.set_name('IGF','IGF_AW_NO_TERM_INST_TIME');
177: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
178: p_message := fnd_message.get;
179: p_result := 'E';
180: ELSIF p_term_weeks = 0 THEN

Line 177: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));

173: p_term_weeks := get_term_time_rec.term_instruction_time;
174:
175: IF p_term_weeks IS NULL THEN
176: fnd_message.set_name('IGF','IGF_AW_NO_TERM_INST_TIME');
177: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
178: p_message := fnd_message.get;
179: p_result := 'E';
180: ELSIF p_term_weeks = 0 THEN
181: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_TIME');

Line 178: p_message := fnd_message.get;

174:
175: IF p_term_weeks IS NULL THEN
176: fnd_message.set_name('IGF','IGF_AW_NO_TERM_INST_TIME');
177: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
178: p_message := fnd_message.get;
179: p_result := 'E';
180: ELSIF p_term_weeks = 0 THEN
181: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_TIME');
182: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));

Line 181: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_TIME');

177: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
178: p_message := fnd_message.get;
179: p_result := 'E';
180: ELSIF p_term_weeks = 0 THEN
181: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_TIME');
182: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
183: p_message := fnd_message.get;
184: p_result := 'E';
185: END IF;

Line 182: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));

178: p_message := fnd_message.get;
179: p_result := 'E';
180: ELSIF p_term_weeks = 0 THEN
181: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_TIME');
182: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
183: p_message := fnd_message.get;
184: p_result := 'E';
185: END IF;
186: END IF;

Line 183: p_message := fnd_message.get;

179: p_result := 'E';
180: ELSIF p_term_weeks = 0 THEN
181: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_TIME');
182: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
183: p_message := fnd_message.get;
184: p_result := 'E';
185: END IF;
186: END IF;
187:

Line 196: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

192: END IF;
193:
194: EXCEPTION
195: WHEN OTHERS THEN
196: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
197: fnd_message.set_token('NAME','IGF_GR_PELL_CALC.GET_PM_3_ACAD_TERM_WKS '||SQLERRM);
198: igs_ge_msg_stack.add;
199: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
200: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.get_pm_3_acad_term_wks.exception',

Line 197: fnd_message.set_token('NAME','IGF_GR_PELL_CALC.GET_PM_3_ACAD_TERM_WKS '||SQLERRM);

193:
194: EXCEPTION
195: WHEN OTHERS THEN
196: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
197: fnd_message.set_token('NAME','IGF_GR_PELL_CALC.GET_PM_3_ACAD_TERM_WKS '||SQLERRM);
198: igs_ge_msg_stack.add;
199: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
200: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.get_pm_3_acad_term_wks.exception',
201: 'sql error message: '||SQLERRM);

Line 437: fnd_message.set_name('IGF', 'IGF_GR_NO_ATTEND_ENTITY_ID');

433: x_msg_data => l_msg_data
434: );
435: IF l_ret_status = 'E' THEN
436: cp_return_status := l_ret_status;
437: fnd_message.set_name('IGF', 'IGF_GR_NO_ATTEND_ENTITY_ID');
438: cp_message := fnd_message.get;
439: RETURN;
440: END IF;
441: END IF;

Line 438: cp_message := fnd_message.get;

434: );
435: IF l_ret_status = 'E' THEN
436: cp_return_status := l_ret_status;
437: fnd_message.set_name('IGF', 'IGF_GR_NO_ATTEND_ENTITY_ID');
438: cp_message := fnd_message.get;
439: RETURN;
440: END IF;
441: END IF;
442:

Line 459: fnd_message.set_name('IGF', 'IGF_GR_NOREP_ENTITY');

455:
456: IF (l_rep_entity_id_txt IS NULL)
457: THEN
458: l_stu_num := igf_gr_gen.get_per_num(cp_base_id);
459: fnd_message.set_name('IGF', 'IGF_GR_NOREP_ENTITY');
460: fnd_message.set_token('STU_NUMBER', l_stu_num);
461: cp_message := fnd_message.get;
462: cp_return_status := 'E';
463: RETURN;

Line 460: fnd_message.set_token('STU_NUMBER', l_stu_num);

456: IF (l_rep_entity_id_txt IS NULL)
457: THEN
458: l_stu_num := igf_gr_gen.get_per_num(cp_base_id);
459: fnd_message.set_name('IGF', 'IGF_GR_NOREP_ENTITY');
460: fnd_message.set_token('STU_NUMBER', l_stu_num);
461: cp_message := fnd_message.get;
462: cp_return_status := 'E';
463: RETURN;
464: END IF;

Line 461: cp_message := fnd_message.get;

457: THEN
458: l_stu_num := igf_gr_gen.get_per_num(cp_base_id);
459: fnd_message.set_name('IGF', 'IGF_GR_NOREP_ENTITY');
460: fnd_message.set_token('STU_NUMBER', l_stu_num);
461: cp_message := fnd_message.get;
462: cp_return_status := 'E';
463: RETURN;
464: END IF;
465:

Line 485: fnd_message.set_name('IGF', 'IGF_GR_NO_PELL_SETUP_COD');

481: IF c_pell_def_setup_cod%NOTFOUND
482: THEN
483: CLOSE c_pell_def_setup_cod;
484: cp_return_status := 'E';
485: fnd_message.set_name('IGF', 'IGF_GR_NO_PELL_SETUP_COD');
486: fnd_message.set_token('REP_ENTITY_ID_TXT', l_rep_entity_id_txt);
487: cp_message := fnd_message.get;
488: RETURN;
489: END IF;

Line 486: fnd_message.set_token('REP_ENTITY_ID_TXT', l_rep_entity_id_txt);

482: THEN
483: CLOSE c_pell_def_setup_cod;
484: cp_return_status := 'E';
485: fnd_message.set_name('IGF', 'IGF_GR_NO_PELL_SETUP_COD');
486: fnd_message.set_token('REP_ENTITY_ID_TXT', l_rep_entity_id_txt);
487: cp_message := fnd_message.get;
488: RETURN;
489: END IF;
490:

Line 487: cp_message := fnd_message.get;

483: CLOSE c_pell_def_setup_cod;
484: cp_return_status := 'E';
485: fnd_message.set_name('IGF', 'IGF_GR_NO_PELL_SETUP_COD');
486: fnd_message.set_token('REP_ENTITY_ID_TXT', l_rep_entity_id_txt);
487: cp_message := fnd_message.get;
488: RETURN;
489: END IF;
490:
491: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 555: fnd_message.set_name('IGF', 'IGF_GR_NO_ATTEND_PELL');

551: x_msg_data => l_msg_data
552: );
553: IF l_ret_status = 'E' THEN
554: cp_return_status := l_ret_status;
555: fnd_message.set_name('IGF', 'IGF_GR_NO_ATTEND_PELL');
556: cp_message := fnd_message.get;
557: RETURN;
558: END IF;
559: END IF;

Line 556: cp_message := fnd_message.get;

552: );
553: IF l_ret_status = 'E' THEN
554: cp_return_status := l_ret_status;
555: fnd_message.set_name('IGF', 'IGF_GR_NO_ATTEND_PELL');
556: cp_message := fnd_message.get;
557: RETURN;
558: END IF;
559: END IF;
560:

Line 576: fnd_message.set_name('IGF', 'IGF_GR_NOREP_PELL');

572:
573: IF (l_rep_pell_id IS NULL)
574: THEN
575: l_stu_num := igf_gr_gen.get_per_num(cp_base_id);
576: fnd_message.set_name('IGF', 'IGF_GR_NOREP_PELL');
577: fnd_message.set_token('STU_NUMBER', l_stu_num);
578: cp_message := fnd_message.get;
579: cp_return_status := 'E';
580: RETURN;

Line 577: fnd_message.set_token('STU_NUMBER', l_stu_num);

573: IF (l_rep_pell_id IS NULL)
574: THEN
575: l_stu_num := igf_gr_gen.get_per_num(cp_base_id);
576: fnd_message.set_name('IGF', 'IGF_GR_NOREP_PELL');
577: fnd_message.set_token('STU_NUMBER', l_stu_num);
578: cp_message := fnd_message.get;
579: cp_return_status := 'E';
580: RETURN;
581: END IF;

Line 578: cp_message := fnd_message.get;

574: THEN
575: l_stu_num := igf_gr_gen.get_per_num(cp_base_id);
576: fnd_message.set_name('IGF', 'IGF_GR_NOREP_PELL');
577: fnd_message.set_token('STU_NUMBER', l_stu_num);
578: cp_message := fnd_message.get;
579: cp_return_status := 'E';
580: RETURN;
581: END IF;
582:

Line 592: fnd_message.set_name('IGF', 'IGF_GR_NO_PELL_SETUP');

588: IF c_pell_def_setup%NOTFOUND
589: THEN
590: CLOSE c_pell_def_setup;
591: cp_return_status := 'E';
592: fnd_message.set_name('IGF', 'IGF_GR_NO_PELL_SETUP');
593: fnd_message.set_token('REP_PELL_ID', l_rep_pell_id);
594: cp_message := fnd_message.get;
595: RETURN;
596: END IF;

Line 593: fnd_message.set_token('REP_PELL_ID', l_rep_pell_id);

589: THEN
590: CLOSE c_pell_def_setup;
591: cp_return_status := 'E';
592: fnd_message.set_name('IGF', 'IGF_GR_NO_PELL_SETUP');
593: fnd_message.set_token('REP_PELL_ID', l_rep_pell_id);
594: cp_message := fnd_message.get;
595: RETURN;
596: END IF;
597:

Line 594: cp_message := fnd_message.get;

590: CLOSE c_pell_def_setup;
591: cp_return_status := 'E';
592: fnd_message.set_name('IGF', 'IGF_GR_NO_PELL_SETUP');
593: fnd_message.set_token('REP_PELL_ID', l_rep_pell_id);
594: cp_message := fnd_message.get;
595: RETURN;
596: END IF;
597:
598: CLOSE c_pell_def_setup;

Line 651: fnd_message.set_name('IGF', 'IGF_GR_INVALID_PYMNT_PRD');

647: IF cp_pell_setup_rec.payment_method IN ('1', '2')
648: AND NVL(cp_pell_setup_rec.payment_periods_num, 0) = 0
649: THEN
650: cp_return_status := 'E';
651: fnd_message.set_name('IGF', 'IGF_GR_INVALID_PYMNT_PRD');
652: cp_message := fnd_message.get;
653: RETURN;
654: END IF;
655:

Line 652: cp_message := fnd_message.get;

648: AND NVL(cp_pell_setup_rec.payment_periods_num, 0) = 0
649: THEN
650: cp_return_status := 'E';
651: fnd_message.set_name('IGF', 'IGF_GR_INVALID_PYMNT_PRD');
652: cp_message := fnd_message.get;
653: RETURN;
654: END IF;
655:
656: cp_return_status := 'S';

Line 663: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXP');

659:
660: EXCEPTION
661: WHEN OTHERS
662: THEN
663: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXP');
664: fnd_message.set_token(
665: 'NAME',
666: 'igf_gr_pell_calc.get_pell_setup ' || SQLERRM
667: );

Line 664: fnd_message.set_token(

660: EXCEPTION
661: WHEN OTHERS
662: THEN
663: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXP');
664: fnd_message.set_token(
665: 'NAME',
666: 'igf_gr_pell_calc.get_pell_setup ' || SQLERRM
667: );
668: igs_ge_msg_stack.ADD;

Line 792: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

788: END IF;
789:
790: EXCEPTION
791: WHEN OTHERS THEN
792: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
793: fnd_message.set_token('NAME','igf_gr_pell_calc.get_pell_coa_efc '||SQLERRM);
794: igs_ge_msg_stack.add;
795: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
796: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.get_pell_coa_efc.exception','sql error message: '||SQLERRM);

Line 793: fnd_message.set_token('NAME','igf_gr_pell_calc.get_pell_coa_efc '||SQLERRM);

789:
790: EXCEPTION
791: WHEN OTHERS THEN
792: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
793: fnd_message.set_token('NAME','igf_gr_pell_calc.get_pell_coa_efc '||SQLERRM);
794: igs_ge_msg_stack.add;
795: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
796: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.get_pell_coa_efc.exception','sql error message: '||SQLERRM);
797: END IF;

Line 942: fnd_message.set_name('IGF','IGF_AW_EN_LD_STDA');

938: );
939:
940: IF l_effctive_cens_dt IS NULL THEN
941: cp_return_status := 'E';
942: fnd_message.set_name('IGF','IGF_AW_EN_LD_STDA');
943: fnd_message.set_token('LD_CI_ALT_CODE',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));
944: cp_message := fnd_message.get ;
945:
946: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 943: fnd_message.set_token('LD_CI_ALT_CODE',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));

939:
940: IF l_effctive_cens_dt IS NULL THEN
941: cp_return_status := 'E';
942: fnd_message.set_name('IGF','IGF_AW_EN_LD_STDA');
943: fnd_message.set_token('LD_CI_ALT_CODE',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));
944: cp_message := fnd_message.get ;
945:
946: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
947: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_pell_calc.get_pell_attendance_type.debug','Error deriving Effective Census Date');

Line 944: cp_message := fnd_message.get ;

940: IF l_effctive_cens_dt IS NULL THEN
941: cp_return_status := 'E';
942: fnd_message.set_name('IGF','IGF_AW_EN_LD_STDA');
943: fnd_message.set_token('LD_CI_ALT_CODE',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));
944: cp_message := fnd_message.get ;
945:
946: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
947: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_pell_calc.get_pell_attendance_type.debug','Error deriving Effective Census Date');
948: END IF;

Line 981: fnd_message.set_name('IGF','IGF_AW_INV_START_DT');

977: END IF;
978:
979: IF p_ld_start_dt IS NULL THEN
980: cp_return_status := 'E';
981: fnd_message.set_name('IGF','IGF_AW_INV_START_DT');
982: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));
983: cp_message := fnd_message.get ;
984: RETURN;
985: END IF;

Line 982: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));

978:
979: IF p_ld_start_dt IS NULL THEN
980: cp_return_status := 'E';
981: fnd_message.set_name('IGF','IGF_AW_INV_START_DT');
982: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));
983: cp_message := fnd_message.get ;
984: RETURN;
985: END IF;
986:

Line 983: cp_message := fnd_message.get ;

979: IF p_ld_start_dt IS NULL THEN
980: cp_return_status := 'E';
981: fnd_message.set_name('IGF','IGF_AW_INV_START_DT');
982: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));
983: cp_message := fnd_message.get ;
984: RETURN;
985: END IF;
986:
987: -- museshad (Bug 5006587 - Build FA 162). Adjust (+ or -) term start date with term offset. Use the new term start date to determine l_enrl_mode.

Line 1050: fnd_message.set_name('IGF','IGF_SL_LI_NO_ACTIVE_ISIR');

1046: OPEN c_isir(cp_base_id);
1047: FETCH c_isir INTO cp_attendance_type ;
1048: IF c_isir%NOTFOUND THEN
1049: cp_return_status := 'E';
1050: fnd_message.set_name('IGF','IGF_SL_LI_NO_ACTIVE_ISIR');
1051: cp_message := fnd_message.get ;
1052: CLOSE c_isir;
1053: RETURN;
1054: ELSE

Line 1051: cp_message := fnd_message.get ;

1047: FETCH c_isir INTO cp_attendance_type ;
1048: IF c_isir%NOTFOUND THEN
1049: cp_return_status := 'E';
1050: fnd_message.set_name('IGF','IGF_SL_LI_NO_ACTIVE_ISIR');
1051: cp_message := fnd_message.get ;
1052: CLOSE c_isir;
1053: RETURN;
1054: ELSE
1055: CLOSE c_isir;

Line 1060: fnd_message.set_name('IGF','IGF_GR_ANTICIP_ATT_NOT_AVAIL');

1056: END IF;
1057:
1058: IF (cp_attendance_type IS NULL) THEN
1059: cp_return_status := 'E';
1060: fnd_message.set_name('IGF','IGF_GR_ANTICIP_ATT_NOT_AVAIL');
1061: cp_message := fnd_message.get ;
1062: RETURN;
1063: END IF;
1064:

Line 1061: cp_message := fnd_message.get ;

1057:
1058: IF (cp_attendance_type IS NULL) THEN
1059: cp_return_status := 'E';
1060: fnd_message.set_name('IGF','IGF_GR_ANTICIP_ATT_NOT_AVAIL');
1061: cp_message := fnd_message.get ;
1062: RETURN;
1063: END IF;
1064:
1065: ELSIF l_enrl_mode = 'PRG_NOMINATED' THEN

Line 1090: fnd_message.set_name('IGF','IGF_GR_NOM_ATT_NOT_EXIST');

1086: 'Attendance Type from FA anticipated data is '|| NVL(l_attendance_type, ''));
1087: END IF;
1088: IF cp_attendance_type IS NULL THEN
1089: cp_return_status := 'E';
1090: fnd_message.set_name('IGF','IGF_GR_NOM_ATT_NOT_EXIST');
1091: cp_message := fnd_message.get ;
1092: RETURN;
1093: END IF;
1094: ELSE

Line 1091: cp_message := fnd_message.get ;

1087: END IF;
1088: IF cp_attendance_type IS NULL THEN
1089: cp_return_status := 'E';
1090: fnd_message.set_name('IGF','IGF_GR_NOM_ATT_NOT_EXIST');
1091: cp_message := fnd_message.get ;
1092: RETURN;
1093: END IF;
1094: ELSE
1095: cp_return_status := 'E';

Line 1096: fnd_message.set_name('IGF','IGF_GR_NOM_ATT_NOT_EXIST');

1092: RETURN;
1093: END IF;
1094: ELSE
1095: cp_return_status := 'E';
1096: fnd_message.set_name('IGF','IGF_GR_NOM_ATT_NOT_EXIST');
1097: cp_message := fnd_message.get ;
1098: RETURN;
1099: END IF;
1100: END IF;

Line 1097: cp_message := fnd_message.get ;

1093: END IF;
1094: ELSE
1095: cp_return_status := 'E';
1096: fnd_message.set_name('IGF','IGF_GR_NOM_ATT_NOT_EXIST');
1097: cp_message := fnd_message.get ;
1098: RETURN;
1099: END IF;
1100: END IF;
1101:

Line 1129: cp_message := fnd_message.get;

1125: EXCEPTION
1126: /*The above Enrollment wrapper can return an App exception (or)
1127: any unhandled exception.*/
1128: WHEN OTHERS THEN
1129: cp_message := fnd_message.get;
1130: IF cp_message IS NOT NULL THEN
1131: -- App Exception from Enrollment wrapper.
1132: -- We know how this needs to be handled.
1133: cp_return_status := 'E';

Line 1149: fnd_message.set_name('IGF','IGF_GR_NO_OSS_ATTEND');

1145: END IF;
1146: CLOSE c_chk_enr;
1147:
1148: IF l_attendance_type IS NULL THEN
1149: fnd_message.set_name('IGF','IGF_GR_NO_OSS_ATTEND');
1150: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));
1151: cp_message := fnd_message.get;
1152: cp_return_status := 'E';
1153: cp_attendance_type := 'XX';

Line 1150: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));

1146: CLOSE c_chk_enr;
1147:
1148: IF l_attendance_type IS NULL THEN
1149: fnd_message.set_name('IGF','IGF_GR_NO_OSS_ATTEND');
1150: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));
1151: cp_message := fnd_message.get;
1152: cp_return_status := 'E';
1153: cp_attendance_type := 'XX';
1154: RETURN;

Line 1151: cp_message := fnd_message.get;

1147:
1148: IF l_attendance_type IS NULL THEN
1149: fnd_message.set_name('IGF','IGF_GR_NO_OSS_ATTEND');
1150: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));
1151: cp_message := fnd_message.get;
1152: cp_return_status := 'E';
1153: cp_attendance_type := 'XX';
1154: RETURN;
1155: END IF;

Line 1164: fnd_message.set_name('IGF','IGF_GR_PELL_ATT_NOT_EXIST');

1160: l_fabase_rec.ci_sequence_number);
1161:
1162: FETCH c_get_pell_att INTO cp_attendance_type;
1163: IF c_get_pell_att%NOTFOUND THEN
1164: fnd_message.set_name('IGF','IGF_GR_PELL_ATT_NOT_EXIST');
1165: fnd_message.set_token('ATTEND_TYPE',NVL(l_attendance_type,'Null'));
1166: cp_message := fnd_message.get;
1167: cp_return_status := 'E' ;
1168: CLOSE c_get_pell_att;

Line 1165: fnd_message.set_token('ATTEND_TYPE',NVL(l_attendance_type,'Null'));

1161:
1162: FETCH c_get_pell_att INTO cp_attendance_type;
1163: IF c_get_pell_att%NOTFOUND THEN
1164: fnd_message.set_name('IGF','IGF_GR_PELL_ATT_NOT_EXIST');
1165: fnd_message.set_token('ATTEND_TYPE',NVL(l_attendance_type,'Null'));
1166: cp_message := fnd_message.get;
1167: cp_return_status := 'E' ;
1168: CLOSE c_get_pell_att;
1169:

Line 1166: cp_message := fnd_message.get;

1162: FETCH c_get_pell_att INTO cp_attendance_type;
1163: IF c_get_pell_att%NOTFOUND THEN
1164: fnd_message.set_name('IGF','IGF_GR_PELL_ATT_NOT_EXIST');
1165: fnd_message.set_token('ATTEND_TYPE',NVL(l_attendance_type,'Null'));
1166: cp_message := fnd_message.get;
1167: cp_return_status := 'E' ;
1168: CLOSE c_get_pell_att;
1169:
1170: RETURN;

Line 1183: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1179:
1180: END IF;
1181: EXCEPTION
1182: WHEN OTHERS THEN
1183: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1184: fnd_message.set_token('NAME','igf_gr_pell_calc.get_pell_attendance_type '||SQLERRM);
1185: igs_ge_msg_stack.add;
1186: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1187: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.get_pell_attendance_type.exception','sql error message: '||SQLERRM);

Line 1184: fnd_message.set_token('NAME','igf_gr_pell_calc.get_pell_attendance_type '||SQLERRM);

1180: END IF;
1181: EXCEPTION
1182: WHEN OTHERS THEN
1183: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1184: fnd_message.set_token('NAME','igf_gr_pell_calc.get_pell_attendance_type '||SQLERRM);
1185: igs_ge_msg_stack.add;
1186: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1187: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.get_pell_attendance_type.exception','sql error message: '||SQLERRM);
1188: END IF;

Line 1281: fnd_message.set_name('IGF','IGF_GR_PELL_RNG_ERR_FRM');

1277: IF c_pell_rng%FOUND THEN
1278: CLOSE c_pell_rng;
1279: cp_aid := l_pell_rng.amount ;
1280: ELSE
1281: fnd_message.set_name('IGF','IGF_GR_PELL_RNG_ERR_FRM');
1282: IF cp_pell_coa IS NULL THEN
1283: fnd_message.set_token('COA','NULL');
1284: ELSE
1285: fnd_message.set_token('COA',TO_CHAR(cp_pell_coa));

Line 1283: fnd_message.set_token('COA','NULL');

1279: cp_aid := l_pell_rng.amount ;
1280: ELSE
1281: fnd_message.set_name('IGF','IGF_GR_PELL_RNG_ERR_FRM');
1282: IF cp_pell_coa IS NULL THEN
1283: fnd_message.set_token('COA','NULL');
1284: ELSE
1285: fnd_message.set_token('COA',TO_CHAR(cp_pell_coa));
1286: END IF;
1287: IF cp_efc IS NULL THEN

Line 1285: fnd_message.set_token('COA',TO_CHAR(cp_pell_coa));

1281: fnd_message.set_name('IGF','IGF_GR_PELL_RNG_ERR_FRM');
1282: IF cp_pell_coa IS NULL THEN
1283: fnd_message.set_token('COA','NULL');
1284: ELSE
1285: fnd_message.set_token('COA',TO_CHAR(cp_pell_coa));
1286: END IF;
1287: IF cp_efc IS NULL THEN
1288: fnd_message.set_token('EFC','NULL');
1289: ELSE

Line 1288: fnd_message.set_token('EFC','NULL');

1284: ELSE
1285: fnd_message.set_token('COA',TO_CHAR(cp_pell_coa));
1286: END IF;
1287: IF cp_efc IS NULL THEN
1288: fnd_message.set_token('EFC','NULL');
1289: ELSE
1290: fnd_message.set_token('EFC',TO_CHAR(cp_efc));
1291: END IF;
1292: fnd_message.set_token('ATT',NVL(igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',cp_enrl_stat),'NULL'));

Line 1290: fnd_message.set_token('EFC',TO_CHAR(cp_efc));

1286: END IF;
1287: IF cp_efc IS NULL THEN
1288: fnd_message.set_token('EFC','NULL');
1289: ELSE
1290: fnd_message.set_token('EFC',TO_CHAR(cp_efc));
1291: END IF;
1292: fnd_message.set_token('ATT',NVL(igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',cp_enrl_stat),'NULL'));
1293: CLOSE c_pell_rng;
1294: cp_return_status := 'E';

Line 1292: fnd_message.set_token('ATT',NVL(igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',cp_enrl_stat),'NULL'));

1288: fnd_message.set_token('EFC','NULL');
1289: ELSE
1290: fnd_message.set_token('EFC',TO_CHAR(cp_efc));
1291: END IF;
1292: fnd_message.set_token('ATT',NVL(igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',cp_enrl_stat),'NULL'));
1293: CLOSE c_pell_rng;
1294: cp_return_status := 'E';
1295: cp_message := fnd_message.get ;
1296: RETURN;

Line 1295: cp_message := fnd_message.get ;

1291: END IF;
1292: fnd_message.set_token('ATT',NVL(igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',cp_enrl_stat),'NULL'));
1293: CLOSE c_pell_rng;
1294: cp_return_status := 'E';
1295: cp_message := fnd_message.get ;
1296: RETURN;
1297: END IF;
1298:
1299: ELSE

Line 1315: fnd_message.set_name('IGF','IGF_GR_PELL_RNG_ERR_FRM_ALT');

1311: CLOSE c_alt_pell;
1312: cp_aid := l_alt_pell.amount ;
1313:
1314: ELSE
1315: fnd_message.set_name('IGF','IGF_GR_PELL_RNG_ERR_FRM_ALT');
1316: IF cp_pell_coa IS NULL THEN
1317: fnd_message.set_token('COA','NULL');
1318: ELSE
1319: fnd_message.set_token('COA',TO_CHAR(cp_pell_coa));

Line 1317: fnd_message.set_token('COA','NULL');

1313:
1314: ELSE
1315: fnd_message.set_name('IGF','IGF_GR_PELL_RNG_ERR_FRM_ALT');
1316: IF cp_pell_coa IS NULL THEN
1317: fnd_message.set_token('COA','NULL');
1318: ELSE
1319: fnd_message.set_token('COA',TO_CHAR(cp_pell_coa));
1320: END IF;
1321: IF cp_efc IS NULL THEN

Line 1319: fnd_message.set_token('COA',TO_CHAR(cp_pell_coa));

1315: fnd_message.set_name('IGF','IGF_GR_PELL_RNG_ERR_FRM_ALT');
1316: IF cp_pell_coa IS NULL THEN
1317: fnd_message.set_token('COA','NULL');
1318: ELSE
1319: fnd_message.set_token('COA',TO_CHAR(cp_pell_coa));
1320: END IF;
1321: IF cp_efc IS NULL THEN
1322: fnd_message.set_token('EFC','NULL');
1323: ELSE

Line 1322: fnd_message.set_token('EFC','NULL');

1318: ELSE
1319: fnd_message.set_token('COA',TO_CHAR(cp_pell_coa));
1320: END IF;
1321: IF cp_efc IS NULL THEN
1322: fnd_message.set_token('EFC','NULL');
1323: ELSE
1324: fnd_message.set_token('EFC',TO_CHAR(cp_efc));
1325: END IF;
1326: fnd_message.set_token('ATT',NVL(igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',cp_enrl_stat),'NULL'));

Line 1324: fnd_message.set_token('EFC',TO_CHAR(cp_efc));

1320: END IF;
1321: IF cp_efc IS NULL THEN
1322: fnd_message.set_token('EFC','NULL');
1323: ELSE
1324: fnd_message.set_token('EFC',TO_CHAR(cp_efc));
1325: END IF;
1326: fnd_message.set_token('ATT',NVL(igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',cp_enrl_stat),'NULL'));
1327: IF cp_pell_alt_exp IS NULL THEN
1328: fnd_message.set_token('ALT_EXP','NULL');

Line 1326: fnd_message.set_token('ATT',NVL(igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',cp_enrl_stat),'NULL'));

1322: fnd_message.set_token('EFC','NULL');
1323: ELSE
1324: fnd_message.set_token('EFC',TO_CHAR(cp_efc));
1325: END IF;
1326: fnd_message.set_token('ATT',NVL(igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',cp_enrl_stat),'NULL'));
1327: IF cp_pell_alt_exp IS NULL THEN
1328: fnd_message.set_token('ALT_EXP','NULL');
1329: ELSE
1330: fnd_message.set_token('ALT_EXP',TO_CHAR(cp_pell_alt_exp));

Line 1328: fnd_message.set_token('ALT_EXP','NULL');

1324: fnd_message.set_token('EFC',TO_CHAR(cp_efc));
1325: END IF;
1326: fnd_message.set_token('ATT',NVL(igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',cp_enrl_stat),'NULL'));
1327: IF cp_pell_alt_exp IS NULL THEN
1328: fnd_message.set_token('ALT_EXP','NULL');
1329: ELSE
1330: fnd_message.set_token('ALT_EXP',TO_CHAR(cp_pell_alt_exp));
1331: END IF;
1332:

Line 1330: fnd_message.set_token('ALT_EXP',TO_CHAR(cp_pell_alt_exp));

1326: fnd_message.set_token('ATT',NVL(igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',cp_enrl_stat),'NULL'));
1327: IF cp_pell_alt_exp IS NULL THEN
1328: fnd_message.set_token('ALT_EXP','NULL');
1329: ELSE
1330: fnd_message.set_token('ALT_EXP',TO_CHAR(cp_pell_alt_exp));
1331: END IF;
1332:
1333: cp_aid := 0 ;
1334: CLOSE c_alt_pell;

Line 1336: cp_message := fnd_message.get ;

1332:
1333: cp_aid := 0 ;
1334: CLOSE c_alt_pell;
1335: cp_return_status := 'E';
1336: cp_message := fnd_message.get ;
1337: RETURN;
1338:
1339: END IF;
1340:

Line 1355: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1351: WHEN NO_SETUP THEN
1352: RAISE;
1353:
1354: WHEN OTHERS THEN
1355: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1356: fnd_message.set_token('NAME','igf_gr_pell_calc.get_pell_matrix_amt '||SQLERRM);
1357: igs_ge_msg_stack.add;
1358: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1359: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.get_pell_matrix_amt.exception','sql error message: '||SQLERRM);

Line 1356: fnd_message.set_token('NAME','igf_gr_pell_calc.get_pell_matrix_amt '||SQLERRM);

1352: RAISE;
1353:
1354: WHEN OTHERS THEN
1355: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1356: fnd_message.set_token('NAME','igf_gr_pell_calc.get_pell_matrix_amt '||SQLERRM);
1357: igs_ge_msg_stack.add;
1358: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1359: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.get_pell_matrix_amt.exception','sql error message: '||SQLERRM);
1360: END IF;

Line 1638: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1634:
1635: p_return_status := 'S';
1636: EXCEPTION
1637: WHEN OTHERS THEN
1638: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1639: fnd_message.set_token('NAME','igf_gr_pell_calc.round_term_disbursements '||SQLERRM);
1640: igs_ge_msg_stack.add;
1641:
1642: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

Line 1639: fnd_message.set_token('NAME','igf_gr_pell_calc.round_term_disbursements '||SQLERRM);

1635: p_return_status := 'S';
1636: EXCEPTION
1637: WHEN OTHERS THEN
1638: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1639: fnd_message.set_token('NAME','igf_gr_pell_calc.round_term_disbursements '||SQLERRM);
1640: igs_ge_msg_stack.add;
1641:
1642: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1643: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.round_term_disbursements.exception','sql error message: '||SQLERRM);

Line 1861: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1857: p_return_status := 'S';
1858:
1859: EXCEPTION
1860: WHEN OTHERS THEN
1861: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1862: fnd_message.set_token('NAME','igf_gr_pell_calc.round_all_disbursements '||SQLERRM);
1863: igs_ge_msg_stack.add;
1864: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1865: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.round_all_disbursements.exception','sql error message: '||SQLERRM);

Line 1862: fnd_message.set_token('NAME','igf_gr_pell_calc.round_all_disbursements '||SQLERRM);

1858:
1859: EXCEPTION
1860: WHEN OTHERS THEN
1861: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1862: fnd_message.set_token('NAME','igf_gr_pell_calc.round_all_disbursements '||SQLERRM);
1863: igs_ge_msg_stack.add;
1864: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1865: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.round_all_disbursements.exception','sql error message: '||SQLERRM);
1866: END IF;

Line 2246: fnd_message.set_name('IGF','IGF_AW_DIST_CODE_FAIL');

2242: END IF;
2243: l_total_term_weeks := 0;
2244: -- If no plan ID is passed , Not possible to calculate Pell hence return
2245: IF cp_plan_id IS NULL THEN
2246: fnd_message.set_name('IGF','IGF_AW_DIST_CODE_FAIL');
2247: cp_message := fnd_message.get ;
2248: cp_return_status := 'E' ;
2249: return;
2250: ELSE

Line 2247: cp_message := fnd_message.get ;

2243: l_total_term_weeks := 0;
2244: -- If no plan ID is passed , Not possible to calculate Pell hence return
2245: IF cp_plan_id IS NULL THEN
2246: fnd_message.set_name('IGF','IGF_AW_DIST_CODE_FAIL');
2247: cp_message := fnd_message.get ;
2248: cp_return_status := 'E' ;
2249: return;
2250: ELSE
2251: -- Get the CP_Plan code to be displayed in the Log

Line 2256: fnd_message.set_name('IGF','IGF_AW_DIST_CODE_FAIL');

2252: OPEN c_dp_details(cp_plan_id);
2253: FETCH c_dp_details INTO l_dp_details_rec;
2254: IF c_dp_details%NOTFOUND THEN
2255: CLOSE c_dp_details;
2256: fnd_message.set_name('IGF','IGF_AW_DIST_CODE_FAIL');
2257: cp_message := fnd_message.get ;
2258: cp_return_status := 'E' ;
2259: return;
2260: END IF;

Line 2257: cp_message := fnd_message.get ;

2253: FETCH c_dp_details INTO l_dp_details_rec;
2254: IF c_dp_details%NOTFOUND THEN
2255: CLOSE c_dp_details;
2256: fnd_message.set_name('IGF','IGF_AW_DIST_CODE_FAIL');
2257: cp_message := fnd_message.get ;
2258: cp_return_status := 'E' ;
2259: return;
2260: END IF;
2261: CLOSE c_dp_details;

Line 2275: fnd_message.set_name('IGF','IGF_AW_NO_PELL_HIGH_DEG');

2271: FETCH c_acad_hist INTO l_acad_hist;
2272:
2273: IF (c_acad_hist%FOUND) THEN
2274: l_aid := 0;
2275: fnd_message.set_name('IGF','IGF_AW_NO_PELL_HIGH_DEG');
2276: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));
2277: cp_message := fnd_message.get ;
2278:
2279: cp_return_status := 'E' ;

Line 2276: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));

2272:
2273: IF (c_acad_hist%FOUND) THEN
2274: l_aid := 0;
2275: fnd_message.set_name('IGF','IGF_AW_NO_PELL_HIGH_DEG');
2276: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));
2277: cp_message := fnd_message.get ;
2278:
2279: cp_return_status := 'E' ;
2280: CLOSE c_acad_hist;

Line 2277: cp_message := fnd_message.get ;

2273: IF (c_acad_hist%FOUND) THEN
2274: l_aid := 0;
2275: fnd_message.set_name('IGF','IGF_AW_NO_PELL_HIGH_DEG');
2276: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));
2277: cp_message := fnd_message.get ;
2278:
2279: cp_return_status := 'E' ;
2280: CLOSE c_acad_hist;
2281: RETURN;

Line 2293: fnd_message.set_name('IGF','IGF_AP_NO_PELL_AWARD');

2289: FETCH c_pell_elig INTO l_pell_elig;
2290: IF l_pell_elig.pell_grant_elig_flag = 'N' THEN
2291: l_aid := 0;
2292:
2293: fnd_message.set_name('IGF','IGF_AP_NO_PELL_AWARD');
2294: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));
2295: cp_message := fnd_message.get ;
2296: cp_return_status := 'E' ;
2297: CLOSE c_pell_elig;

Line 2294: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));

2290: IF l_pell_elig.pell_grant_elig_flag = 'N' THEN
2291: l_aid := 0;
2292:
2293: fnd_message.set_name('IGF','IGF_AP_NO_PELL_AWARD');
2294: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));
2295: cp_message := fnd_message.get ;
2296: cp_return_status := 'E' ;
2297: CLOSE c_pell_elig;
2298: RETURN;

Line 2295: cp_message := fnd_message.get ;

2291: l_aid := 0;
2292:
2293: fnd_message.set_name('IGF','IGF_AP_NO_PELL_AWARD');
2294: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));
2295: cp_message := fnd_message.get ;
2296: cp_return_status := 'E' ;
2297: CLOSE c_pell_elig;
2298: RETURN;
2299: END IF;

Line 2312: fnd_message.set_name('IGF','IGF_AW_NO_PELL_HIGH_DEG');

2308: FETCH c_get_prog_type INTO l_get_prog_type;
2309:
2310: IF (c_get_prog_type%FOUND) THEN
2311: -- Display error message
2312: fnd_message.set_name('IGF','IGF_AW_NO_PELL_HIGH_DEG');
2313: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));
2314: cp_message := fnd_message.get ;
2315:
2316: -- Log error

Line 2313: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));

2309:
2310: IF (c_get_prog_type%FOUND) THEN
2311: -- Display error message
2312: fnd_message.set_name('IGF','IGF_AW_NO_PELL_HIGH_DEG');
2313: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));
2314: cp_message := fnd_message.get ;
2315:
2316: -- Log error
2317: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2314: cp_message := fnd_message.get ;

2310: IF (c_get_prog_type%FOUND) THEN
2311: -- Display error message
2312: fnd_message.set_name('IGF','IGF_AW_NO_PELL_HIGH_DEG');
2313: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));
2314: cp_message := fnd_message.get ;
2315:
2316: -- Log error
2317: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2318: fnd_log.string(fnd_log.level_statement,

Line 2345: fnd_message.set_name('IGF','IGF_AW_COA_COMMON_TERMS_FAIL');

2341:
2342: IF NVL(l_terms_rec.total_terms,0) = 0 THEN
2343:
2344: cp_return_status := 'E';
2345: fnd_message.set_name('IGF','IGF_AW_COA_COMMON_TERMS_FAIL');
2346: fnd_message.set_token('PLAN_CD',l_dp_details_rec.awd_dist_plan_cd);
2347: cp_message := fnd_message.get ;
2348: RETURN;
2349: END IF;

Line 2346: fnd_message.set_token('PLAN_CD',l_dp_details_rec.awd_dist_plan_cd);

2342: IF NVL(l_terms_rec.total_terms,0) = 0 THEN
2343:
2344: cp_return_status := 'E';
2345: fnd_message.set_name('IGF','IGF_AW_COA_COMMON_TERMS_FAIL');
2346: fnd_message.set_token('PLAN_CD',l_dp_details_rec.awd_dist_plan_cd);
2347: cp_message := fnd_message.get ;
2348: RETURN;
2349: END IF;
2350:

Line 2347: cp_message := fnd_message.get ;

2343:
2344: cp_return_status := 'E';
2345: fnd_message.set_name('IGF','IGF_AW_COA_COMMON_TERMS_FAIL');
2346: fnd_message.set_token('PLAN_CD',l_dp_details_rec.awd_dist_plan_cd);
2347: cp_message := fnd_message.get ;
2348: RETURN;
2349: END IF;
2350:
2351: -- Get the students key program details

Line 2384: fnd_message.set_name('IGS', 'IGS_EN_NO_KEY_PRG');

2380: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_pell_calc.calc_pell.debug','Cannot compute key program details.');
2381: END IF;
2382:
2383: cp_return_status := 'E';
2384: fnd_message.set_name('IGS', 'IGS_EN_NO_KEY_PRG');
2385: fnd_message.set_token('PERSON', igf_gr_gen.get_per_num(cp_base_id));
2386: cp_message := fnd_message.get;
2387: RETURN;
2388: END IF;

Line 2385: fnd_message.set_token('PERSON', igf_gr_gen.get_per_num(cp_base_id));

2381: END IF;
2382:
2383: cp_return_status := 'E';
2384: fnd_message.set_name('IGS', 'IGS_EN_NO_KEY_PRG');
2385: fnd_message.set_token('PERSON', igf_gr_gen.get_per_num(cp_base_id));
2386: cp_message := fnd_message.get;
2387: RETURN;
2388: END IF;
2389: END IF;

Line 2386: cp_message := fnd_message.get;

2382:
2383: cp_return_status := 'E';
2384: fnd_message.set_name('IGS', 'IGS_EN_NO_KEY_PRG');
2385: fnd_message.set_token('PERSON', igf_gr_gen.get_per_num(cp_base_id));
2386: cp_message := fnd_message.get;
2387: RETURN;
2388: END IF;
2389: END IF;
2390: END IF;

Line 2422: fnd_message.set_name('IGF','IGF_GR_INVALID_PAY_PERIODS');

2418: END IF;
2419:
2420: -- Check if the Pell Setup Payment periods are greater than the total number of payment periods
2421: IF l_terms_rec.total_terms > l_pell_setup_rec.payment_periods_num THEN
2422: fnd_message.set_name('IGF','IGF_GR_INVALID_PAY_PERIODS');
2423: fnd_message.set_token('REPORT_PELL_ID', l_pell_setup_rec.rep_pell_id);
2424: fnd_file.put_line(fnd_file.log, fnd_message.get);
2425:
2426: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2423: fnd_message.set_token('REPORT_PELL_ID', l_pell_setup_rec.rep_pell_id);

2419:
2420: -- Check if the Pell Setup Payment periods are greater than the total number of payment periods
2421: IF l_terms_rec.total_terms > l_pell_setup_rec.payment_periods_num THEN
2422: fnd_message.set_name('IGF','IGF_GR_INVALID_PAY_PERIODS');
2423: fnd_message.set_token('REPORT_PELL_ID', l_pell_setup_rec.rep_pell_id);
2424: fnd_file.put_line(fnd_file.log, fnd_message.get);
2425:
2426: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_pell_calc.calc_pell.debug','Pell Setup pymnt prds - > ' || TO_CHAR(l_pell_setup_rec.payment_periods_num) || ' Actual periods ->' || TO_CHAR(l_terms_rec.total_terms));

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

2420: -- Check if the Pell Setup Payment periods are greater than the total number of payment periods
2421: IF l_terms_rec.total_terms > l_pell_setup_rec.payment_periods_num THEN
2422: fnd_message.set_name('IGF','IGF_GR_INVALID_PAY_PERIODS');
2423: fnd_message.set_token('REPORT_PELL_ID', l_pell_setup_rec.rep_pell_id);
2424: fnd_file.put_line(fnd_file.log, fnd_message.get);
2425:
2426: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_pell_calc.calc_pell.debug','Pell Setup pymnt prds - > ' || TO_CHAR(l_pell_setup_rec.payment_periods_num) || ' Actual periods ->' || TO_CHAR(l_terms_rec.total_terms));
2428: END IF;

Line 2435: fnd_message.set_name('IGF','IGF_AW_NO_SUCH_FUND');

2431: -- Get fund attributes to set at Disbursement Level.
2432: OPEN c_fund(cp_fund_id);
2433: FETCH c_fund into l_fund_rec;
2434: IF c_fund%NOTFOUND THEN
2435: fnd_message.set_name('IGF','IGF_AW_NO_SUCH_FUND');
2436: fnd_message.set_token('FUND_ID',TO_CHAR(cp_fund_id));
2437: cp_message := fnd_message.get ;
2438: cp_return_status := 'E' ;
2439: CLOSE c_fund;

Line 2436: fnd_message.set_token('FUND_ID',TO_CHAR(cp_fund_id));

2432: OPEN c_fund(cp_fund_id);
2433: FETCH c_fund into l_fund_rec;
2434: IF c_fund%NOTFOUND THEN
2435: fnd_message.set_name('IGF','IGF_AW_NO_SUCH_FUND');
2436: fnd_message.set_token('FUND_ID',TO_CHAR(cp_fund_id));
2437: cp_message := fnd_message.get ;
2438: cp_return_status := 'E' ;
2439: CLOSE c_fund;
2440: RETURN;

Line 2437: cp_message := fnd_message.get ;

2433: FETCH c_fund into l_fund_rec;
2434: IF c_fund%NOTFOUND THEN
2435: fnd_message.set_name('IGF','IGF_AW_NO_SUCH_FUND');
2436: fnd_message.set_token('FUND_ID',TO_CHAR(cp_fund_id));
2437: cp_message := fnd_message.get ;
2438: cp_return_status := 'E' ;
2439: CLOSE c_fund;
2440: RETURN;
2441: END IF;

Line 2636: fnd_message.set_name('IGF','IGF_AW_ZERO_PELL_AMT');

2632: CLOSE c_terms_det ;
2633: RETURN;
2634: END IF;
2635: IF l_aid = 0 THEN
2636: fnd_message.set_name('IGF','IGF_AW_ZERO_PELL_AMT');
2637: cp_message := fnd_message.get;
2638: cp_return_status := 'E' ;
2639: RETURN;
2640: END IF;

Line 2637: cp_message := fnd_message.get;

2633: RETURN;
2634: END IF;
2635: IF l_aid = 0 THEN
2636: fnd_message.set_name('IGF','IGF_AW_ZERO_PELL_AMT');
2637: cp_message := fnd_message.get;
2638: cp_return_status := 'E' ;
2639: RETURN;
2640: END IF;
2641: -- Get the Term Level Amount

Line 2828: fnd_message.set_name('IGF','IGF_AW_ZERO_PELL_AMT');

2824:
2825: -- Check if cp_pell_tab is NOT filled for some reason. If so, error out and return
2826: IF (cp_pell_tab IS NULL) OR (cp_pell_tab IS NOT NULL AND cp_pell_tab.COUNT = 0) THEN
2827: -- cp_pell_tab is not filled, so the Pell awd amount will be 0
2828: fnd_message.set_name('IGF','IGF_AW_ZERO_PELL_AMT');
2829: cp_message := fnd_message.get;
2830: cp_return_status := 'E';
2831: cp_aid := 0;
2832:

Line 2829: cp_message := fnd_message.get;

2825: -- Check if cp_pell_tab is NOT filled for some reason. If so, error out and return
2826: IF (cp_pell_tab IS NULL) OR (cp_pell_tab IS NOT NULL AND cp_pell_tab.COUNT = 0) THEN
2827: -- cp_pell_tab is not filled, so the Pell awd amount will be 0
2828: fnd_message.set_name('IGF','IGF_AW_ZERO_PELL_AMT');
2829: cp_message := fnd_message.get;
2830: cp_return_status := 'E';
2831: cp_aid := 0;
2832:
2833: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2956: fnd_message.set_name('IGF','IGF_AW_PELL_LMT_EXCEED');

2952: -- Total awarded amount is greater than the limit
2953: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2954: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_pell_calc.calc_pell.debug','raising IGF_AW_PELL_LMT_EXCEED with cp_aid/l_aid->'||cp_aid||'/'||l_aid);
2955: END IF;
2956: fnd_message.set_name('IGF','IGF_AW_PELL_LMT_EXCEED');
2957: cp_message := fnd_message.get;
2958: cp_return_status := 'E' ;
2959: RETURN;
2960: END IF;*/

Line 2957: cp_message := fnd_message.get;

2953: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2954: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_pell_calc.calc_pell.debug','raising IGF_AW_PELL_LMT_EXCEED with cp_aid/l_aid->'||cp_aid||'/'||l_aid);
2955: END IF;
2956: fnd_message.set_name('IGF','IGF_AW_PELL_LMT_EXCEED');
2957: cp_message := fnd_message.get;
2958: cp_return_status := 'E' ;
2959: RETURN;
2960: END IF;*/
2961: -- Check to compare the award amount with the full time pell amount that a student can get.

Line 2985: fnd_message.set_name('IGF','IGF_AW_PELL_LMT_EXCEED');

2981: cp_return_status := 'E' ;
2982: RETURN;
2983: ELSE
2984: IF cp_aid > l_ft_pell_amt THEN
2985: fnd_message.set_name('IGF','IGF_AW_PELL_LMT_EXCEED');
2986: cp_message := fnd_message.get;
2987: cp_return_status := 'E' ;
2988: RETURN;
2989: END IF;

Line 2986: cp_message := fnd_message.get;

2982: RETURN;
2983: ELSE
2984: IF cp_aid > l_ft_pell_amt THEN
2985: fnd_message.set_name('IGF','IGF_AW_PELL_LMT_EXCEED');
2986: cp_message := fnd_message.get;
2987: cp_return_status := 'E' ;
2988: RETURN;
2989: END IF;
2990: END IF;

Line 3012: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

3008: END IF;
3009:
3010: EXCEPTION
3011: WHEN OTHERS THEN
3012: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3013: fnd_message.set_token('NAME','igf_gr_pell_calc.calc_pell '||SQLERRM);
3014: igs_ge_msg_stack.add;
3015: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3016: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.calc_pell.exception','sql error message: '||SQLERRM);

Line 3013: fnd_message.set_token('NAME','igf_gr_pell_calc.calc_pell '||SQLERRM);

3009:
3010: EXCEPTION
3011: WHEN OTHERS THEN
3012: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3013: fnd_message.set_token('NAME','igf_gr_pell_calc.calc_pell '||SQLERRM);
3014: igs_ge_msg_stack.add;
3015: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3016: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.calc_pell.exception','sql error message: '||SQLERRM);
3017: END IF;

Line 3108: fnd_message.set_name('IGF','IGF_AW_NO_PELL_HIGH_DEG');

3104: FETCH c_acad_hist INTO l_acad_hist;
3105:
3106: IF (c_acad_hist%FOUND) THEN
3107: -- Not eligible for Pell
3108: fnd_message.set_name('IGF','IGF_AW_NO_PELL_HIGH_DEG');
3109: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));
3110: igs_ge_msg_stack.add;
3111:
3112: cp_return_status := 'E';

Line 3109: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));

3105:
3106: IF (c_acad_hist%FOUND) THEN
3107: -- Not eligible for Pell
3108: fnd_message.set_name('IGF','IGF_AW_NO_PELL_HIGH_DEG');
3109: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));
3110: igs_ge_msg_stack.add;
3111:
3112: cp_return_status := 'E';
3113: CLOSE c_acad_hist;

Line 3121: fnd_message.set_name('IGF','IGF_AP_ACT_ISIR_NOT_FOUND');

3117:
3118: OPEN c_pell_elig(cp_base_id);
3119: FETCH c_pell_elig INTO l_pell_elig;
3120: IF (c_pell_elig%NOTFOUND) THEN
3121: fnd_message.set_name('IGF','IGF_AP_ACT_ISIR_NOT_FOUND');
3122: igs_ge_msg_stack.add;
3123: cp_return_status := 'E' ;
3124: ELSE
3125: IF NVL(l_pell_elig.pell_grant_elig_flag,'N') = 'N' THEN

Line 3126: fnd_message.set_name('IGF','IGF_AP_NO_PELL_AWARD');

3122: igs_ge_msg_stack.add;
3123: cp_return_status := 'E' ;
3124: ELSE
3125: IF NVL(l_pell_elig.pell_grant_elig_flag,'N') = 'N' THEN
3126: fnd_message.set_name('IGF','IGF_AP_NO_PELL_AWARD');
3127: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));
3128: igs_ge_msg_stack.add;
3129: cp_return_status := 'E' ;
3130: CLOSE c_pell_elig;

Line 3127: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));

3123: cp_return_status := 'E' ;
3124: ELSE
3125: IF NVL(l_pell_elig.pell_grant_elig_flag,'N') = 'N' THEN
3126: fnd_message.set_name('IGF','IGF_AP_NO_PELL_AWARD');
3127: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));
3128: igs_ge_msg_stack.add;
3129: cp_return_status := 'E' ;
3130: CLOSE c_pell_elig;
3131: RETURN;

Line 3145: fnd_message.set_name('IGF','IGF_AW_NO_PELL_HIGH_DEG');

3141: FETCH c_get_prog_type INTO l_get_prog_type;
3142:
3143: IF (c_get_prog_type%FOUND) THEN
3144: -- Not eligible for Pell
3145: fnd_message.set_name('IGF','IGF_AW_NO_PELL_HIGH_DEG');
3146: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));
3147: igs_ge_msg_stack.add;
3148: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3149: fnd_log.string(fnd_log.level_statement,

Line 3146: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));

3142:
3143: IF (c_get_prog_type%FOUND) THEN
3144: -- Not eligible for Pell
3145: fnd_message.set_name('IGF','IGF_AW_NO_PELL_HIGH_DEG');
3146: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(cp_base_id));
3147: igs_ge_msg_stack.add;
3148: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3149: fnd_log.string(fnd_log.level_statement,
3150: 'igf.plsql.igf_gr_pell_calc.pell_elig.debug',

Line 3163: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

3159: CLOSE c_get_prog_type;
3160:
3161: EXCEPTION
3162: WHEN OTHERS THEN
3163: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3164: fnd_message.set_token('NAME','igf_gr_pell_calc.pell_elig '||SQLERRM);
3165: igs_ge_msg_stack.add;
3166: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3167: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.pell_elig.exception','sql error message: '||SQLERRM);

Line 3164: fnd_message.set_token('NAME','igf_gr_pell_calc.pell_elig '||SQLERRM);

3160:
3161: EXCEPTION
3162: WHEN OTHERS THEN
3163: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3164: fnd_message.set_token('NAME','igf_gr_pell_calc.pell_elig '||SQLERRM);
3165: igs_ge_msg_stack.add;
3166: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3167: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.pell_elig.exception','sql error message: '||SQLERRM);
3168: END IF;

Line 3312: fnd_message.set_name('IGS', 'IGS_EN_NO_KEY_PRG');

3308: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_pell_calc.calc_term_pell.debug','Cannot compute key program details.');
3309: END IF;
3310:
3311: cp_return_status := 'E' ;
3312: fnd_message.set_name('IGS', 'IGS_EN_NO_KEY_PRG');
3313: fnd_message.set_token('PERSON', igf_gr_gen.get_per_num(cp_base_id));
3314: cp_message := fnd_message.get;
3315: RETURN;
3316: END IF;

Line 3313: fnd_message.set_token('PERSON', igf_gr_gen.get_per_num(cp_base_id));

3309: END IF;
3310:
3311: cp_return_status := 'E' ;
3312: fnd_message.set_name('IGS', 'IGS_EN_NO_KEY_PRG');
3313: fnd_message.set_token('PERSON', igf_gr_gen.get_per_num(cp_base_id));
3314: cp_message := fnd_message.get;
3315: RETURN;
3316: END IF;
3317: END IF;

Line 3314: cp_message := fnd_message.get;

3310:
3311: cp_return_status := 'E' ;
3312: fnd_message.set_name('IGS', 'IGS_EN_NO_KEY_PRG');
3313: fnd_message.set_token('PERSON', igf_gr_gen.get_per_num(cp_base_id));
3314: cp_message := fnd_message.get;
3315: RETURN;
3316: END IF;
3317: END IF;
3318: END IF;

Line 3393: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_PELL_AMT');

3389: cp_return_status := 'E' ;
3390: RETURN;
3391: END IF;
3392: IF l_aid = 0 THEN
3393: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_PELL_AMT');
3394: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));
3395: cp_message := fnd_message.get;
3396: cp_return_status := 'E' ;
3397: RETURN;

Line 3394: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));

3390: RETURN;
3391: END IF;
3392: IF l_aid = 0 THEN
3393: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_PELL_AMT');
3394: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));
3395: cp_message := fnd_message.get;
3396: cp_return_status := 'E' ;
3397: RETURN;
3398: END IF;

Line 3395: cp_message := fnd_message.get;

3391: END IF;
3392: IF l_aid = 0 THEN
3393: fnd_message.set_name('IGF','IGF_AW_ZERO_TERM_PELL_AMT');
3394: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(cp_ld_cal_type,cp_ld_sequence_number));
3395: cp_message := fnd_message.get;
3396: cp_return_status := 'E' ;
3397: RETURN;
3398: END IF;
3399: -- Get the Term Level Amount

Line 3452: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

3448: END IF;
3449:
3450: EXCEPTION
3451: WHEN OTHERS THEN
3452: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3453: fnd_message.set_token('NAME','igf_gr_pell_calc.calc_term_pell '||SQLERRM);
3454: igs_ge_msg_stack.add;
3455: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3456: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.calc_term_pell.exception','sql error message: '||SQLERRM);

Line 3453: fnd_message.set_token('NAME','igf_gr_pell_calc.calc_term_pell '||SQLERRM);

3449:
3450: EXCEPTION
3451: WHEN OTHERS THEN
3452: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3453: fnd_message.set_token('NAME','igf_gr_pell_calc.calc_term_pell '||SQLERRM);
3454: igs_ge_msg_stack.add;
3455: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3456: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.calc_term_pell.exception','sql error message: '||SQLERRM);
3457: END IF;

Line 3627: fnd_message.set_name('IGS', 'IGS_EN_NO_KEY_PRG');

3623: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_pell_calc.calc_ft_max_pell.debug','Cannot compute key program details');
3624: END IF;
3625:
3626: cp_return_status := 'E' ;
3627: fnd_message.set_name('IGS', 'IGS_EN_NO_KEY_PRG');
3628: fnd_message.set_token('PERSON', igf_gr_gen.get_per_num(cp_base_id));
3629: cp_message := fnd_message.get;
3630: RETURN;
3631: END IF;

Line 3628: fnd_message.set_token('PERSON', igf_gr_gen.get_per_num(cp_base_id));

3624: END IF;
3625:
3626: cp_return_status := 'E' ;
3627: fnd_message.set_name('IGS', 'IGS_EN_NO_KEY_PRG');
3628: fnd_message.set_token('PERSON', igf_gr_gen.get_per_num(cp_base_id));
3629: cp_message := fnd_message.get;
3630: RETURN;
3631: END IF;
3632: END IF;

Line 3629: cp_message := fnd_message.get;

3625:
3626: cp_return_status := 'E' ;
3627: fnd_message.set_name('IGS', 'IGS_EN_NO_KEY_PRG');
3628: fnd_message.set_token('PERSON', igf_gr_gen.get_per_num(cp_base_id));
3629: cp_message := fnd_message.get;
3630: RETURN;
3631: END IF;
3632: END IF;
3633: END IF;

Line 3678: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');

3674: OPEN c_rfms(cp_base_id);
3675: FETCH c_rfms INTO l_rfms_rec;
3676: IF c_rfms%NOTFOUND THEN
3677: CLOSE c_rfms;
3678: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
3679: cp_message := fnd_message.get;
3680: cp_return_status := 'E' ;
3681: RETURN;
3682: END IF;

Line 3679: cp_message := fnd_message.get;

3675: FETCH c_rfms INTO l_rfms_rec;
3676: IF c_rfms%NOTFOUND THEN
3677: CLOSE c_rfms;
3678: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
3679: cp_message := fnd_message.get;
3680: cp_return_status := 'E' ;
3681: RETURN;
3682: END IF;
3683:

Line 3727: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

3723: END IF;
3724:
3725: EXCEPTION
3726: WHEN OTHERS THEN
3727: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3728: fnd_message.set_token('NAME','igf_gr_pell_calc.calc_ft_max_pell '||SQLERRM);
3729: igs_ge_msg_stack.add;
3730: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3731: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.calc_ft_max_pell.exception','sql error message: '||SQLERRM);

Line 3728: fnd_message.set_token('NAME','igf_gr_pell_calc.calc_ft_max_pell '||SQLERRM);

3724:
3725: EXCEPTION
3726: WHEN OTHERS THEN
3727: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3728: fnd_message.set_token('NAME','igf_gr_pell_calc.calc_ft_max_pell '||SQLERRM);
3729: igs_ge_msg_stack.add;
3730: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3731: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_pell_calc.calc_ft_max_pell.exception','sql error message: '||SQLERRM);
3732: END IF;