DBA Data[Home] [Help]

APPS.IGF_GR_PELL_CALC dependencies on IGS_GE_MSG_STACK

Line 198: igs_ge_msg_stack.add;

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);
202: END IF;

Line 668: igs_ge_msg_stack.ADD;

664: fnd_message.set_token(
665: 'NAME',
666: 'igf_gr_pell_calc.get_pell_setup ' || SQLERRM
667: );
668: igs_ge_msg_stack.ADD;
669:
670: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level
671: THEN
672: fnd_log.STRING(

Line 794: igs_ge_msg_stack.add;

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;
798: app_exception.raise_exception;

Line 1185: igs_ge_msg_stack.add;

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;
1189: app_exception.raise_exception;

Line 1357: igs_ge_msg_stack.add;

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;
1361: app_exception.raise_exception;

Line 1640: igs_ge_msg_stack.add;

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);
1644: END IF;

Line 1863: igs_ge_msg_stack.add;

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;
1867: app_exception.raise_exception;

Line 3014: igs_ge_msg_stack.add;

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;
3018: app_exception.raise_exception;

Line 3110: igs_ge_msg_stack.add;

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;
3114: RETURN;

Line 3122: igs_ge_msg_stack.add;

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

Line 3128: igs_ge_msg_stack.add;

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;
3132: END IF;

Line 3147: igs_ge_msg_stack.add;

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',
3151: 'Person Number ' ||igf_gr_gen.get_per_num(cp_base_id)|| ' not eligible for Pell because this person has already completed a Bacheolor/Professional program'

Line 3165: igs_ge_msg_stack.add;

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;
3169: app_exception.raise_exception;

Line 3454: igs_ge_msg_stack.add;

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;
3458: app_exception.raise_exception;

Line 3729: igs_ge_msg_stack.add;

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;
3733: app_exception.raise_exception;