155: EXCEPTION WHEN OTHERS THEN
156: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
157: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.exception',SQLERRM);
158: END IF;
159: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
160: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_CL_HOLD_REL_IND');
161: igs_ge_msg_stack.conc_exception_hndl;
162: app_exception.raise_exception;
163:
156: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
157: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.exception',SQLERRM);
158: END IF;
159: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
160: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_CL_HOLD_REL_IND');
161: igs_ge_msg_stack.conc_exception_hndl;
162: app_exception.raise_exception;
163:
164: END get_cl_hold_rel_ind;
233: EXCEPTION WHEN OTHERS THEN
234: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
235: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.exception',SQLERRM);
236: END IF;
237: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
238: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_CL_AUTO_LATE_IND');
239: igs_ge_msg_stack.conc_exception_hndl;
240: app_exception.raise_exception;
241:
234: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
235: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.exception',SQLERRM);
236: END IF;
237: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
238: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_CL_AUTO_LATE_IND');
239: igs_ge_msg_stack.conc_exception_hndl;
240: app_exception.raise_exception;
241:
242: END get_cl_auto_late_ind;
366: EXCEPTION WHEN OTHERS THEN
367: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
368: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee1.exception',SQLERRM);
369: END IF;
370: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
371: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_FEE1');
372: igs_ge_msg_stack.conc_exception_hndl;
373: app_exception.raise_exception;
374:
367: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
368: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee1.exception',SQLERRM);
369: END IF;
370: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
371: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_FEE1');
372: igs_ge_msg_stack.conc_exception_hndl;
373: app_exception.raise_exception;
374:
375: END get_loan_fee1;
470: EXCEPTION WHEN OTHERS THEN
471: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
472: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee2.exception',SQLERRM);
473: END IF;
474: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
475: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_FEE2');
476: igs_ge_msg_stack.conc_exception_hndl;
477: app_exception.raise_exception;
478: END get_loan_fee2;
471: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
472: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee2.exception',SQLERRM);
473: END IF;
474: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
475: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_FEE2');
476: igs_ge_msg_stack.conc_exception_hndl;
477: app_exception.raise_exception;
478: END get_loan_fee2;
479:
526: WHEN OTHERS THEN
527: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
528: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_disb_date.exception',SQLERRM);
529: END IF;
530: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
531: fnd_message.set_token('NAME','IGF_SL_AWARD.CHK_DISB_DATE');
532: igs_ge_msg_stack.conc_exception_hndl;
533: app_exception.raise_exception;
534:
527: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
528: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_disb_date.exception',SQLERRM);
529: END IF;
530: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
531: fnd_message.set_token('NAME','IGF_SL_AWARD.CHK_DISB_DATE');
532: igs_ge_msg_stack.conc_exception_hndl;
533: app_exception.raise_exception;
534:
535: END chk_disb_date;
557: EXCEPTION WHEN OTHERS THEN
558: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
559: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_alt_rel_code.exception',SQLERRM);
560: END IF;
561: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
562: fnd_message.set_token('NAME','IGF_SL_AWARD.get_alt_rel_code');
563: igs_ge_msg_stack.conc_exception_hndl;
564: app_exception.raise_exception;
565:
558: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
559: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_alt_rel_code.exception',SQLERRM);
560: END IF;
561: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
562: fnd_message.set_token('NAME','IGF_SL_AWARD.get_alt_rel_code');
563: igs_ge_msg_stack.conc_exception_hndl;
564: app_exception.raise_exception;
565:
566: END get_alt_rel_code;
651: EXCEPTION WHEN OTHERS THEN
652: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
653: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_loan_upd_lock.exception',SQLERRM);
654: END IF;
655: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
656: fnd_message.set_token('NAME','IGF_SL_AWARD.CHK_LOAN_UPD_LOCK');
657: igs_ge_msg_stack.conc_exception_hndl;
658: app_exception.raise_exception;
659:
652: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
653: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_loan_upd_lock.exception',SQLERRM);
654: END IF;
655: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
656: fnd_message.set_token('NAME','IGF_SL_AWARD.CHK_LOAN_UPD_LOCK');
657: igs_ge_msg_stack.conc_exception_hndl;
658: app_exception.raise_exception;
659:
660: END chk_loan_upd_lock;
712: EXCEPTION WHEN OTHERS THEN
713: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
714: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_amts.exception',SQLERRM);
715: END IF;
716: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
717: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_AMTS');
718: igs_ge_msg_stack.conc_exception_hndl;
719: app_exception.raise_exception;
720:
713: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
714: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_amts.exception',SQLERRM);
715: END IF;
716: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
717: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_AMTS');
718: igs_ge_msg_stack.conc_exception_hndl;
719: app_exception.raise_exception;
720:
721:
909: EXCEPTION WHEN OTHERS THEN
910: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
911: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.recalc_fees.exception',SQLERRM);
912: END IF;
913: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
914: fnd_message.set_token('NAME','IGF_SL_AWARD.RECALC_FEES');
915: igs_ge_msg_stack.conc_exception_hndl;
916: app_exception.raise_exception;
917:
910: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
911: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.recalc_fees.exception',SQLERRM);
912: END IF;
913: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
914: fnd_message.set_token('NAME','IGF_SL_AWARD.RECALC_FEES');
915: igs_ge_msg_stack.conc_exception_hndl;
916: app_exception.raise_exception;
917:
918: END recalc_fees;
1127:
1128: IF find_lender_rec.relationship_cd IS NULL THEN
1129: --bug #3847105 - Log message in case the Loan is created using Default Lender setup
1130: --despite of Preferred Lender as the Preferred Lender is not setup for the Award Year.
1131: fnd_message.set_name('IGF','IGF_SL_DFLT_LEN_LOAN');
1132: fnd_message.set_token('DEFAULT_LEN',l_get_default_lender.relationship_cd);
1133: fnd_message.set_token('PREFER_LEN',l_chk_pref_lender.relationship_cd);
1134: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_cal_type,p_sequence_number));
1135: fnd_file.put_line(fnd_file.log, fnd_message.get);
1128: IF find_lender_rec.relationship_cd IS NULL THEN
1129: --bug #3847105 - Log message in case the Loan is created using Default Lender setup
1130: --despite of Preferred Lender as the Preferred Lender is not setup for the Award Year.
1131: fnd_message.set_name('IGF','IGF_SL_DFLT_LEN_LOAN');
1132: fnd_message.set_token('DEFAULT_LEN',l_get_default_lender.relationship_cd);
1133: fnd_message.set_token('PREFER_LEN',l_chk_pref_lender.relationship_cd);
1134: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_cal_type,p_sequence_number));
1135: fnd_file.put_line(fnd_file.log, fnd_message.get);
1136:
1129: --bug #3847105 - Log message in case the Loan is created using Default Lender setup
1130: --despite of Preferred Lender as the Preferred Lender is not setup for the Award Year.
1131: fnd_message.set_name('IGF','IGF_SL_DFLT_LEN_LOAN');
1132: fnd_message.set_token('DEFAULT_LEN',l_get_default_lender.relationship_cd);
1133: fnd_message.set_token('PREFER_LEN',l_chk_pref_lender.relationship_cd);
1134: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_cal_type,p_sequence_number));
1135: fnd_file.put_line(fnd_file.log, fnd_message.get);
1136:
1137: g_rel_code := l_get_default_lender.relationship_cd;
1130: --despite of Preferred Lender as the Preferred Lender is not setup for the Award Year.
1131: fnd_message.set_name('IGF','IGF_SL_DFLT_LEN_LOAN');
1132: fnd_message.set_token('DEFAULT_LEN',l_get_default_lender.relationship_cd);
1133: fnd_message.set_token('PREFER_LEN',l_chk_pref_lender.relationship_cd);
1134: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_cal_type,p_sequence_number));
1135: fnd_file.put_line(fnd_file.log, fnd_message.get);
1136:
1137: g_rel_code := l_get_default_lender.relationship_cd;
1138: END IF;
1131: fnd_message.set_name('IGF','IGF_SL_DFLT_LEN_LOAN');
1132: fnd_message.set_token('DEFAULT_LEN',l_get_default_lender.relationship_cd);
1133: fnd_message.set_token('PREFER_LEN',l_chk_pref_lender.relationship_cd);
1134: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_cal_type,p_sequence_number));
1135: fnd_file.put_line(fnd_file.log, fnd_message.get);
1136:
1137: g_rel_code := l_get_default_lender.relationship_cd;
1138: END IF;
1139:
1188:
1189: IF find_lender_rec.relationship_cd IS NULL THEN
1190: --bug #3847105 - Log message in case the Loan is created using Default Lender setup
1191: --despite of Preferred Lender as the Preferred Lender is not setup for the Award Year.
1192: fnd_message.set_name('IGF','IGF_SL_DFLT_LEN_LOAN');
1193: fnd_message.set_token('DEFAULT_LEN',l_get_default_lender.relationship_cd);
1194: fnd_message.set_token('PREFER_LEN',l_chk_pref_lender.relationship_cd);
1195: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_cal_type,p_sequence_number));
1196: g_rel_code := l_get_default_lender.relationship_cd;
1189: IF find_lender_rec.relationship_cd IS NULL THEN
1190: --bug #3847105 - Log message in case the Loan is created using Default Lender setup
1191: --despite of Preferred Lender as the Preferred Lender is not setup for the Award Year.
1192: fnd_message.set_name('IGF','IGF_SL_DFLT_LEN_LOAN');
1193: fnd_message.set_token('DEFAULT_LEN',l_get_default_lender.relationship_cd);
1194: fnd_message.set_token('PREFER_LEN',l_chk_pref_lender.relationship_cd);
1195: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_cal_type,p_sequence_number));
1196: g_rel_code := l_get_default_lender.relationship_cd;
1197: fnd_file.put_line(fnd_file.log, fnd_message.get);
1190: --bug #3847105 - Log message in case the Loan is created using Default Lender setup
1191: --despite of Preferred Lender as the Preferred Lender is not setup for the Award Year.
1192: fnd_message.set_name('IGF','IGF_SL_DFLT_LEN_LOAN');
1193: fnd_message.set_token('DEFAULT_LEN',l_get_default_lender.relationship_cd);
1194: fnd_message.set_token('PREFER_LEN',l_chk_pref_lender.relationship_cd);
1195: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_cal_type,p_sequence_number));
1196: g_rel_code := l_get_default_lender.relationship_cd;
1197: fnd_file.put_line(fnd_file.log, fnd_message.get);
1198: END IF;
1191: --despite of Preferred Lender as the Preferred Lender is not setup for the Award Year.
1192: fnd_message.set_name('IGF','IGF_SL_DFLT_LEN_LOAN');
1193: fnd_message.set_token('DEFAULT_LEN',l_get_default_lender.relationship_cd);
1194: fnd_message.set_token('PREFER_LEN',l_chk_pref_lender.relationship_cd);
1195: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_cal_type,p_sequence_number));
1196: g_rel_code := l_get_default_lender.relationship_cd;
1197: fnd_file.put_line(fnd_file.log, fnd_message.get);
1198: END IF;
1199:
1193: fnd_message.set_token('DEFAULT_LEN',l_get_default_lender.relationship_cd);
1194: fnd_message.set_token('PREFER_LEN',l_chk_pref_lender.relationship_cd);
1195: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_cal_type,p_sequence_number));
1196: g_rel_code := l_get_default_lender.relationship_cd;
1197: fnd_file.put_line(fnd_file.log, fnd_message.get);
1198: END IF;
1199:
1200: ELSE
1201: g_rel_code := l_get_default_lender.relationship_cd;
1209: EXCEPTION WHEN OTHERS THEN
1210: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
1211: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.pick_setup.exception',SQLERRM);
1212: END IF;
1213: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1214: fnd_message.set_token('NAME','IGF_SL_AWARD.PICK_SETUP');
1215: igs_ge_msg_stack.conc_exception_hndl;
1216: app_exception.raise_exception;
1217:
1210: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
1211: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.pick_setup.exception',SQLERRM);
1212: END IF;
1213: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1214: fnd_message.set_token('NAME','IGF_SL_AWARD.PICK_SETUP');
1215: igs_ge_msg_stack.conc_exception_hndl;
1216: app_exception.raise_exception;
1217:
1218: END pick_setup;
1269: WHEN OTHERS THEN
1270: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1271: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_chg_enable exception',SQLERRM);
1272: END IF;
1273: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1274: fnd_message.set_token('NAME','igf_sl_award.chk_chg_enable');
1275: igs_ge_msg_stack.add;
1276: app_exception.raise_exception;
1277: END chk_chg_enable;
1270: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1271: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_chg_enable exception',SQLERRM);
1272: END IF;
1273: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1274: fnd_message.set_token('NAME','igf_sl_award.chk_chg_enable');
1275: igs_ge_msg_stack.add;
1276: app_exception.raise_exception;
1277: END chk_chg_enable;
1278:
1343: WHEN OTHERS THEN
1344: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1345: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_add_new_disb exception',SQLERRM);
1346: END IF;
1347: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1348: fnd_message.set_token('NAME','igf_sl_award.chk_add_new_disb');
1349: igs_ge_msg_stack.add;
1350: app_exception.raise_exception;
1351: END chk_add_new_disb;
1344: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1345: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_add_new_disb exception',SQLERRM);
1346: END IF;
1347: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1348: fnd_message.set_token('NAME','igf_sl_award.chk_add_new_disb');
1349: igs_ge_msg_stack.add;
1350: app_exception.raise_exception;
1351: END chk_add_new_disb;
1352:
1448: WHEN OTHERS THEN
1449: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1450: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_loan_increase exception',SQLERRM);
1451: END IF;
1452: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1453: fnd_message.set_token('NAME','igf_sl_award.chk_loan_increase');
1454: igs_ge_msg_stack.add;
1455: app_exception.raise_exception;
1456: END chk_loan_increase;
1449: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1450: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_loan_increase exception',SQLERRM);
1451: END IF;
1452: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1453: fnd_message.set_token('NAME','igf_sl_award.chk_loan_increase');
1454: igs_ge_msg_stack.add;
1455: app_exception.raise_exception;
1456: END chk_loan_increase;
1457:
1526: WHEN OTHERS THEN
1527: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1528: fnd_log.string(fnd_log.level_exception,'igf_sl_award.get_loan_cl_version exception',SQLERRM);
1529: END IF;
1530: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1531: fnd_message.set_token('NAME','igf_sl_award.get_loan_cl_version');
1532: igs_ge_msg_stack.add;
1533: app_exception.raise_exception;
1534: END get_loan_cl_version;
1527: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1528: fnd_log.string(fnd_log.level_exception,'igf_sl_award.get_loan_cl_version exception',SQLERRM);
1529: END IF;
1530: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1531: fnd_message.set_token('NAME','igf_sl_award.get_loan_cl_version');
1532: igs_ge_msg_stack.add;
1533: app_exception.raise_exception;
1534: END get_loan_cl_version;
1535:
1609: WHEN OTHERS THEN
1610: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1611: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_fund_st_chg exception',SQLERRM);
1612: END IF;
1613: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1614: fnd_message.set_token('NAME','igf_sl_award.chk_fund_st_chg');
1615: igs_ge_msg_stack.add;
1616: app_exception.raise_exception;
1617: END chk_fund_st_chg;
1610: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1611: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_fund_st_chg exception',SQLERRM);
1612: END IF;
1613: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1614: fnd_message.set_token('NAME','igf_sl_award.chk_fund_st_chg');
1615: igs_ge_msg_stack.add;
1616: app_exception.raise_exception;
1617: END chk_fund_st_chg;
1618: