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_AW_GEN_003 dependencies on FND_MESSAGE

Line 424: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

420:
421: EXCEPTION
422:
423: WHEN OTHERS THEN
424: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
425: fnd_message.set_token('NAME','IGF_AW_GEN_003.CREATE_PELL_DISB'||' ' ||SQLERRM);
426: app_exception.raise_exception;
427:
428: END create_pell_disb;

Line 425: fnd_message.set_token('NAME','IGF_AW_GEN_003.CREATE_PELL_DISB'||' ' ||SQLERRM);

421: EXCEPTION
422:
423: WHEN OTHERS THEN
424: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
425: fnd_message.set_token('NAME','IGF_AW_GEN_003.CREATE_PELL_DISB'||' ' ||SQLERRM);
426: app_exception.raise_exception;
427:
428: END create_pell_disb;
429:

Line 702: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

698:
699: EXCEPTION
700:
701: WHEN OTHERS THEN
702: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
703: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATING_COA_IN_FA_BASE'||' ' ||SQLERRM);
704: app_exception.raise_exception;
705:
706: END updating_coa_in_fa_base;

Line 703: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATING_COA_IN_FA_BASE'||' ' ||SQLERRM);

699: EXCEPTION
700:
701: WHEN OTHERS THEN
702: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
703: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATING_COA_IN_FA_BASE'||' ' ||SQLERRM);
704: app_exception.raise_exception;
705:
706: END updating_coa_in_fa_base;
707:

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

2375:
2376: EXCEPTION
2377:
2378: WHEN NO_COMMON_TERMS THEN
2379: fnd_message.set_name('IGF','IGF_AW_COA_COMMON_TERMS_FAIL');
2380: fnd_message.set_token('PLAN_CD',l_adplans_name);
2381: fnd_file.put_line(fnd_file.log,fnd_message.get);
2382: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2383: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_gen_003.create_auto_disb.exception','no common terms between COA and distribution plan');

Line 2380: fnd_message.set_token('PLAN_CD',l_adplans_name);

2376: EXCEPTION
2377:
2378: WHEN NO_COMMON_TERMS THEN
2379: fnd_message.set_name('IGF','IGF_AW_COA_COMMON_TERMS_FAIL');
2380: fnd_message.set_token('PLAN_CD',l_adplans_name);
2381: fnd_file.put_line(fnd_file.log,fnd_message.get);
2382: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2383: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_gen_003.create_auto_disb.exception','no common terms between COA and distribution plan');
2384: END IF;

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

2377:
2378: WHEN NO_COMMON_TERMS THEN
2379: fnd_message.set_name('IGF','IGF_AW_COA_COMMON_TERMS_FAIL');
2380: fnd_message.set_token('PLAN_CD',l_adplans_name);
2381: fnd_file.put_line(fnd_file.log,fnd_message.get);
2382: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2383: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_gen_003.create_auto_disb.exception','no common terms between COA and distribution plan');
2384: END IF;
2385:

Line 2387: fnd_message.set_name('IGF','IGF_AW_NO_APDP_COM_TERM');

2383: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_gen_003.create_auto_disb.exception','no common terms between COA and distribution plan');
2384: END IF;
2385:
2386: WHEN NO_AP_DP_COMM_TERMS THEN
2387: fnd_message.set_name('IGF','IGF_AW_NO_APDP_COM_TERM');
2388: app_exception.raise_exception;
2389:
2390: WHEN others THEN
2391: IF c_auto_disb%ISOPEN THEN

Line 2423: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2419: IF c_auto_disb_coa_match_pell%ISOPEN THEN
2420: CLOSE c_auto_disb_coa_match_pell;
2421: END IF;
2422:
2423: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2424: fnd_message.set_token('NAME','IGF_AW_GEN_003.CREATE_AUTO_DISB' || ' ' || SQLERRM);
2425: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2426: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_gen_003.create_auto_disb.exception','sql error message:'|| SQLERRM);
2427: END IF;

Line 2424: fnd_message.set_token('NAME','IGF_AW_GEN_003.CREATE_AUTO_DISB' || ' ' || SQLERRM);

2420: CLOSE c_auto_disb_coa_match_pell;
2421: END IF;
2422:
2423: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2424: fnd_message.set_token('NAME','IGF_AW_GEN_003.CREATE_AUTO_DISB' || ' ' || SQLERRM);
2425: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2426: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_gen_003.create_auto_disb.exception','sql error message:'|| SQLERRM);
2427: END IF;
2428: app_exception.raise_exception;

Line 2538: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2534: CLOSE c_chk_sys_disb_holds;
2535:
2536: EXCEPTION
2537: WHEN OTHERS THEN
2538: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2539: fnd_message.set_token('NAME','IGF_AW_GEN_003.REMOVE_AWD_RULES_OVERRIDE'||' ' ||SQLERRM);
2540: app_exception.raise_exception;
2541:
2542: END remove_awd_rules_override;

Line 2539: fnd_message.set_token('NAME','IGF_AW_GEN_003.REMOVE_AWD_RULES_OVERRIDE'||' ' ||SQLERRM);

2535:
2536: EXCEPTION
2537: WHEN OTHERS THEN
2538: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2539: fnd_message.set_token('NAME','IGF_AW_GEN_003.REMOVE_AWD_RULES_OVERRIDE'||' ' ||SQLERRM);
2540: app_exception.raise_exception;
2541:
2542: END remove_awd_rules_override;
2543:

Line 2589: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2585:
2586: EXCEPTION
2587:
2588: WHEN OTHERS THEN
2589: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2590: fnd_message.set_token('NAME','IGF_AW_GEN_003.PLACE_OVAWD_HOLDS'||' ' ||SQLERRM);
2591: app_exception.raise_exception;
2592:
2593: END place_ovawd_holds;

Line 2590: fnd_message.set_token('NAME','IGF_AW_GEN_003.PLACE_OVAWD_HOLDS'||' ' ||SQLERRM);

2586: EXCEPTION
2587:
2588: WHEN OTHERS THEN
2589: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2590: fnd_message.set_token('NAME','IGF_AW_GEN_003.PLACE_OVAWD_HOLDS'||' ' ||SQLERRM);
2591: app_exception.raise_exception;
2592:
2593: END place_ovawd_holds;
2594:

Line 2663: fnd_message.parse_encoded(fnd_message.get_encoded, l_app, l_name);

2659: --
2660: -- This will ensure exception raised from the insert hold tbh
2661: -- are is not thrown in the form
2662: --
2663: fnd_message.parse_encoded(fnd_message.get_encoded, l_app, l_name);
2664: IF l_name = 'IGF_DB_HOLD_EXISTS' THEN
2665: NULL;
2666: ELSE
2667: RAISE;

Line 2677: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2673:
2674: EXCEPTION
2675:
2676: WHEN OTHERS THEN
2677: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2678: fnd_message.set_token('NAME','IGF_AW_GEN_003.CREATE_OVER_AWD_HOLDS'||' ' ||SQLERRM);
2679: app_exception.raise_exception;
2680:
2681: END create_over_awd_holds;

Line 2678: fnd_message.set_token('NAME','IGF_AW_GEN_003.CREATE_OVER_AWD_HOLDS'||' ' ||SQLERRM);

2674: EXCEPTION
2675:
2676: WHEN OTHERS THEN
2677: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2678: fnd_message.set_token('NAME','IGF_AW_GEN_003.CREATE_OVER_AWD_HOLDS'||' ' ||SQLERRM);
2679: app_exception.raise_exception;
2680:
2681: END create_over_awd_holds;
2682:

Line 2785: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2781: WHEN app_exception.record_lock_exception THEN
2782: ROLLBACK;
2783:
2784: WHEN OTHERS THEN
2785: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2786: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_ACCEPT_AMOUNT'||' ' ||SQLERRM);
2787: app_exception.raise_exception;
2788:
2789: END update_accept_amount;

Line 2786: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_ACCEPT_AMOUNT'||' ' ||SQLERRM);

2782: ROLLBACK;
2783:
2784: WHEN OTHERS THEN
2785: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2786: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_ACCEPT_AMOUNT'||' ' ||SQLERRM);
2787: app_exception.raise_exception;
2788:
2789: END update_accept_amount;
2790:

Line 2876: fnd_message.set_name('IGF','IGF_AW_PELL_DISB_ERR');

2872:
2873: IF NVL(p_return_status,'N') = 'E' THEN
2874: RETURN;
2875: ELSIF NVL(p_term_aid,0) < term_amounts_rec.term_total THEN
2876: fnd_message.set_name('IGF','IGF_AW_PELL_DISB_ERR');
2877: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));
2878: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',term_amounts_rec.base_attendance_type_code));
2879: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);
2880: fnd_message.set_token('CALC_AMT',p_term_aid);

Line 2877: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));

2873: IF NVL(p_return_status,'N') = 'E' THEN
2874: RETURN;
2875: ELSIF NVL(p_term_aid,0) < term_amounts_rec.term_total THEN
2876: fnd_message.set_name('IGF','IGF_AW_PELL_DISB_ERR');
2877: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));
2878: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',term_amounts_rec.base_attendance_type_code));
2879: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);
2880: fnd_message.set_token('CALC_AMT',p_term_aid);
2881: p_message := fnd_message.get;

Line 2878: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',term_amounts_rec.base_attendance_type_code));

2874: RETURN;
2875: ELSIF NVL(p_term_aid,0) < term_amounts_rec.term_total THEN
2876: fnd_message.set_name('IGF','IGF_AW_PELL_DISB_ERR');
2877: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));
2878: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',term_amounts_rec.base_attendance_type_code));
2879: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);
2880: fnd_message.set_token('CALC_AMT',p_term_aid);
2881: p_message := fnd_message.get;
2882: RETURN;

Line 2879: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);

2875: ELSIF NVL(p_term_aid,0) < term_amounts_rec.term_total THEN
2876: fnd_message.set_name('IGF','IGF_AW_PELL_DISB_ERR');
2877: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));
2878: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',term_amounts_rec.base_attendance_type_code));
2879: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);
2880: fnd_message.set_token('CALC_AMT',p_term_aid);
2881: p_message := fnd_message.get;
2882: RETURN;
2883: END IF;

Line 2880: fnd_message.set_token('CALC_AMT',p_term_aid);

2876: fnd_message.set_name('IGF','IGF_AW_PELL_DISB_ERR');
2877: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));
2878: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',term_amounts_rec.base_attendance_type_code));
2879: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);
2880: fnd_message.set_token('CALC_AMT',p_term_aid);
2881: p_message := fnd_message.get;
2882: RETURN;
2883: END IF;
2884: END LOOP;

Line 2881: p_message := fnd_message.get;

2877: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));
2878: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',term_amounts_rec.base_attendance_type_code));
2879: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);
2880: fnd_message.set_token('CALC_AMT',p_term_aid);
2881: p_message := fnd_message.get;
2882: RETURN;
2883: END IF;
2884: END LOOP;
2885:

Line 3016: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

3012: WHEN app_exception.record_lock_exception THEN
3013: ROLLBACK;
3014:
3015: WHEN OTHERS THEN
3016: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3017: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_AWD_CANCELL_TO_OFFER'||' ' || SQLERRM);
3018: app_exception.raise_exception;
3019:
3020: END update_awd_cancell_to_offer;

Line 3017: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_AWD_CANCELL_TO_OFFER'||' ' || SQLERRM);

3013: ROLLBACK;
3014:
3015: WHEN OTHERS THEN
3016: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3017: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_AWD_CANCELL_TO_OFFER'||' ' || SQLERRM);
3018: app_exception.raise_exception;
3019:
3020: END update_awd_cancell_to_offer;
3021:

Line 3118: fnd_message.set_name('IGF','IGF_DB_DISB_ORDER');

3114: LOOP
3115: ln_count_i := ln_count_i + 1;
3116: EXIT WHEN ln_count_i > ln_tot_rec;
3117: IF disb_num_ele(ln_count_i).disb_num <> disb_dat_ele(ln_count_i).disb_num THEN
3118: fnd_message.set_name('IGF','IGF_DB_DISB_ORDER');
3119:
3120: lv_message := fnd_message.get;
3121: RETURN lv_message;
3122: END IF;

Line 3120: lv_message := fnd_message.get;

3116: EXIT WHEN ln_count_i > ln_tot_rec;
3117: IF disb_num_ele(ln_count_i).disb_num <> disb_dat_ele(ln_count_i).disb_num THEN
3118: fnd_message.set_name('IGF','IGF_DB_DISB_ORDER');
3119:
3120: lv_message := fnd_message.get;
3121: RETURN lv_message;
3122: END IF;
3123:
3124: END LOOP;

Line 3135: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

3131:
3132: EXCEPTION
3133:
3134: WHEN OTHERS THEN
3135: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3136: fnd_message.set_token('NAME','IGF_AW_GEN_003.CHECK_DISBDTS'||' ' || SQLERRM);
3137: app_exception.raise_exception;
3138:
3139: END check_disbdts;

Line 3136: fnd_message.set_token('NAME','IGF_AW_GEN_003.CHECK_DISBDTS'||' ' || SQLERRM);

3132: EXCEPTION
3133:
3134: WHEN OTHERS THEN
3135: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3136: fnd_message.set_token('NAME','IGF_AW_GEN_003.CHECK_DISBDTS'||' ' || SQLERRM);
3137: app_exception.raise_exception;
3138:
3139: END check_disbdts;
3140:

Line 3448: fnd_message.set_name('IGF','IGF_DB_NO_DISB_AWD');

3444: CLOSE c_award_status;
3445:
3446:
3447: IF ln_count_rec = 0 THEN
3448: fnd_message.set_name('IGF','IGF_DB_NO_DISB_AWD');
3449: lv_message := fnd_message.get;
3450: RETURN lv_message;
3451: END IF;
3452:

Line 3449: lv_message := fnd_message.get;

3445:
3446:
3447: IF ln_count_rec = 0 THEN
3448: fnd_message.set_name('IGF','IGF_DB_NO_DISB_AWD');
3449: lv_message := fnd_message.get;
3450: RETURN lv_message;
3451: END IF;
3452:
3453: --

Line 3457: fnd_message.set_name('IGF','IGF_AW_NO_ENUGH_FNDS');

3453: --
3454: -- Check Whether the award amount is exceeding the remaining amount in the fund
3455: --
3456: IF fund_details_rec.remaining_amt < 0 THEN
3457: fnd_message.set_name('IGF','IGF_AW_NO_ENUGH_FNDS');
3458: lv_message := fnd_message.get;
3459: RETURN lv_message;
3460: END IF;
3461:

Line 3458: lv_message := fnd_message.get;

3454: -- Check Whether the award amount is exceeding the remaining amount in the fund
3455: --
3456: IF fund_details_rec.remaining_amt < 0 THEN
3457: fnd_message.set_name('IGF','IGF_AW_NO_ENUGH_FNDS');
3458: lv_message := fnd_message.get;
3459: RETURN lv_message;
3460: END IF;
3461:
3462: -- l_subz_loan is set to 'Y' for Subsidized loans. This is needed bcoz for Subsidized

Line 3485: fnd_message.set_name('IGF','IGF_DB_ENTER_ACCEPT_AMT');

3481: -- Bug id :
3482: FOR disb_num_rec IN cur_disb_num (p_award_id) LOOP
3483: IF disb_num_rec.trans_type IN ('P','A')AND c_award_status_rec.award_status ='ACCEPTED' THEN
3484: IF disb_num_rec.accepted_amt IS NULL THEN
3485: fnd_message.set_name('IGF','IGF_DB_ENTER_ACCEPT_AMT');
3486: fnd_message.set_token('DISB_NUM',disb_num_rec.disb_num);
3487: lv_message := fnd_message.get;
3488: RETURN lv_message;
3489: END IF;

Line 3486: fnd_message.set_token('DISB_NUM',disb_num_rec.disb_num);

3482: FOR disb_num_rec IN cur_disb_num (p_award_id) LOOP
3483: IF disb_num_rec.trans_type IN ('P','A')AND c_award_status_rec.award_status ='ACCEPTED' THEN
3484: IF disb_num_rec.accepted_amt IS NULL THEN
3485: fnd_message.set_name('IGF','IGF_DB_ENTER_ACCEPT_AMT');
3486: fnd_message.set_token('DISB_NUM',disb_num_rec.disb_num);
3487: lv_message := fnd_message.get;
3488: RETURN lv_message;
3489: END IF;
3490: END IF;

Line 3487: lv_message := fnd_message.get;

3483: IF disb_num_rec.trans_type IN ('P','A')AND c_award_status_rec.award_status ='ACCEPTED' THEN
3484: IF disb_num_rec.accepted_amt IS NULL THEN
3485: fnd_message.set_name('IGF','IGF_DB_ENTER_ACCEPT_AMT');
3486: fnd_message.set_token('DISB_NUM',disb_num_rec.disb_num);
3487: lv_message := fnd_message.get;
3488: RETURN lv_message;
3489: END IF;
3490: END IF;
3491: END LOOP;

Line 3502: fnd_message.set_name('IGF','IGF_AW_MIN_NUM_DISB_NOT_EXCEED');

3498:
3499:
3500: IF fund_details_rec.min_num_disb IS NOT NULL THEN
3501: IF ln_count_rec < fund_details_rec.min_num_disb THEN
3502: fnd_message.set_name('IGF','IGF_AW_MIN_NUM_DISB_NOT_EXCEED');
3503: lv_message := fnd_message.get;
3504: RETURN lv_message;
3505: END IF;
3506: END IF;

Line 3503: lv_message := fnd_message.get;

3499:
3500: IF fund_details_rec.min_num_disb IS NOT NULL THEN
3501: IF ln_count_rec < fund_details_rec.min_num_disb THEN
3502: fnd_message.set_name('IGF','IGF_AW_MIN_NUM_DISB_NOT_EXCEED');
3503: lv_message := fnd_message.get;
3504: RETURN lv_message;
3505: END IF;
3506: END IF;
3507:

Line 3510: fnd_message.set_name('IGF','IGF_AW_MAX_NUM_DISB_EXCEEDED');

3506: END IF;
3507:
3508: IF fund_details_rec.max_num_disb IS NOT NULL THEN
3509: IF ln_count_rec > fund_details_rec.max_num_disb THEN
3510: fnd_message.set_name('IGF','IGF_AW_MAX_NUM_DISB_EXCEEDED');
3511: lv_message := fnd_message.get;
3512: RETURN lv_message;
3513: END IF;
3514: ELSE

Line 3511: lv_message := fnd_message.get;

3507:
3508: IF fund_details_rec.max_num_disb IS NOT NULL THEN
3509: IF ln_count_rec > fund_details_rec.max_num_disb THEN
3510: fnd_message.set_name('IGF','IGF_AW_MAX_NUM_DISB_EXCEEDED');
3511: lv_message := fnd_message.get;
3512: RETURN lv_message;
3513: END IF;
3514: ELSE
3515:

Line 3522: fnd_message.set_name('IGF','IGF_AW_PLUS_DISB');

3518: -- If the maximum disb num is not specified, for PLUS it is 4/ For Sub/unsub 20
3519: --
3520: IF p_fed_fund_code IN ('DLP','FLP') THEN -- PLUS
3521: IF ln_count_rec > 4 THEN
3522: fnd_message.set_name('IGF','IGF_AW_PLUS_DISB');
3523: lv_message := fnd_message.get;
3524: RETURN lv_message;
3525: END IF;
3526: ELSIF p_fed_fund_code IN ('DLS','FLS','DLU','FLU') THEN -- S.UNS.

Line 3523: lv_message := fnd_message.get;

3519: --
3520: IF p_fed_fund_code IN ('DLP','FLP') THEN -- PLUS
3521: IF ln_count_rec > 4 THEN
3522: fnd_message.set_name('IGF','IGF_AW_PLUS_DISB');
3523: lv_message := fnd_message.get;
3524: RETURN lv_message;
3525: END IF;
3526: ELSIF p_fed_fund_code IN ('DLS','FLS','DLU','FLU') THEN -- S.UNS.
3527: IF ln_count_rec > 20 THEN

Line 3528: fnd_message.set_name('IGF','IGF_AW_SUNS_DISB');

3524: RETURN lv_message;
3525: END IF;
3526: ELSIF p_fed_fund_code IN ('DLS','FLS','DLU','FLU') THEN -- S.UNS.
3527: IF ln_count_rec > 20 THEN
3528: fnd_message.set_name('IGF','IGF_AW_SUNS_DISB');
3529: lv_message := fnd_message.get;
3530: RETURN lv_message;
3531: END IF;
3532: END IF;

Line 3529: lv_message := fnd_message.get;

3525: END IF;
3526: ELSIF p_fed_fund_code IN ('DLS','FLS','DLU','FLU') THEN -- S.UNS.
3527: IF ln_count_rec > 20 THEN
3528: fnd_message.set_name('IGF','IGF_AW_SUNS_DISB');
3529: lv_message := fnd_message.get;
3530: RETURN lv_message;
3531: END IF;
3532: END IF;
3533:

Line 3540: fnd_message.set_name('IGF','IGF_AW_PELL_DISB');

3536: --
3537: -- If the maximum disb num is not specified, for Pell it can be 90
3538: --
3539: IF ln_count_rec > 90 THEN
3540: fnd_message.set_name('IGF','IGF_AW_PELL_DISB');
3541: lv_message := fnd_message.get;
3542: RETURN lv_message;
3543: END IF;
3544: END IF;

Line 3541: lv_message := fnd_message.get;

3537: -- If the maximum disb num is not specified, for Pell it can be 90
3538: --
3539: IF ln_count_rec > 90 THEN
3540: fnd_message.set_name('IGF','IGF_AW_PELL_DISB');
3541: lv_message := fnd_message.get;
3542: RETURN lv_message;
3543: END IF;
3544: END IF;
3545:

Line 3575: fnd_message.set_name('IGF','IGF_AW_PELL_DISB_WARN');

3571: IF NVL(p_return_status,'N') = 'E' THEN
3572: lv_message := p_message;
3573: RETURN lv_message;
3574: ELSIF NVL(p_term_aid,0) < term_amounts_rec.term_total THEN
3575: fnd_message.set_name('IGF','IGF_AW_PELL_DISB_WARN');
3576: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));
3577: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',term_amounts_rec.base_attendance_type_code));
3578: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);
3579: fnd_message.set_token('CALC_AMT',p_term_aid);

Line 3576: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));

3572: lv_message := p_message;
3573: RETURN lv_message;
3574: ELSIF NVL(p_term_aid,0) < term_amounts_rec.term_total THEN
3575: fnd_message.set_name('IGF','IGF_AW_PELL_DISB_WARN');
3576: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));
3577: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',term_amounts_rec.base_attendance_type_code));
3578: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);
3579: fnd_message.set_token('CALC_AMT',p_term_aid);
3580: fnd_msg_pub.add;

Line 3577: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',term_amounts_rec.base_attendance_type_code));

3573: RETURN lv_message;
3574: ELSIF NVL(p_term_aid,0) < term_amounts_rec.term_total THEN
3575: fnd_message.set_name('IGF','IGF_AW_PELL_DISB_WARN');
3576: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));
3577: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',term_amounts_rec.base_attendance_type_code));
3578: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);
3579: fnd_message.set_token('CALC_AMT',p_term_aid);
3580: fnd_msg_pub.add;
3581: END IF;

Line 3578: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);

3574: ELSIF NVL(p_term_aid,0) < term_amounts_rec.term_total THEN
3575: fnd_message.set_name('IGF','IGF_AW_PELL_DISB_WARN');
3576: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));
3577: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',term_amounts_rec.base_attendance_type_code));
3578: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);
3579: fnd_message.set_token('CALC_AMT',p_term_aid);
3580: fnd_msg_pub.add;
3581: END IF;
3582: END LOOP;

Line 3579: fnd_message.set_token('CALC_AMT',p_term_aid);

3575: fnd_message.set_name('IGF','IGF_AW_PELL_DISB_WARN');
3576: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));
3577: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',term_amounts_rec.base_attendance_type_code));
3578: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);
3579: fnd_message.set_token('CALC_AMT',p_term_aid);
3580: fnd_msg_pub.add;
3581: END IF;
3582: END LOOP;
3583: --

Line 3654: fnd_message.set_name('IGF','IGF_AW_MIN_AMT_FAILED');

3650: -- Check Whether the award amount is exceeding the Min Limit Amounts in the fund
3651: --
3652:
3653: IF NVL(total_award_amt_rec.total_award_amt,0) < fund_details_rec.min_award_amt THEN
3654: fnd_message.set_name('IGF','IGF_AW_MIN_AMT_FAILED');
3655: fnd_message.set_token('AMOUNT',fund_details_rec.min_award_amt);
3656: fnd_message.set_token('FUND',p_fund_code);
3657: fnd_msg_pub.add;
3658: END IF;

Line 3655: fnd_message.set_token('AMOUNT',fund_details_rec.min_award_amt);

3651: --
3652:
3653: IF NVL(total_award_amt_rec.total_award_amt,0) < fund_details_rec.min_award_amt THEN
3654: fnd_message.set_name('IGF','IGF_AW_MIN_AMT_FAILED');
3655: fnd_message.set_token('AMOUNT',fund_details_rec.min_award_amt);
3656: fnd_message.set_token('FUND',p_fund_code);
3657: fnd_msg_pub.add;
3658: END IF;
3659:

Line 3656: fnd_message.set_token('FUND',p_fund_code);

3652:
3653: IF NVL(total_award_amt_rec.total_award_amt,0) < fund_details_rec.min_award_amt THEN
3654: fnd_message.set_name('IGF','IGF_AW_MIN_AMT_FAILED');
3655: fnd_message.set_token('AMOUNT',fund_details_rec.min_award_amt);
3656: fnd_message.set_token('FUND',p_fund_code);
3657: fnd_msg_pub.add;
3658: END IF;
3659:
3660: --

Line 3664: fnd_message.set_name('IGF','IGF_AW_MAX_AMT_EXCEED');

3660: --
3661: -- Check if the Award Amount is exceeding the Max Award Amount in the fund
3662: --
3663: IF NVL(total_award_amt_rec.total_award_amt,0) > fund_details_rec.max_award_amt THEN
3664: fnd_message.set_name('IGF','IGF_AW_MAX_AMT_EXCEED');
3665: fnd_message.set_token('AMOUNT',fund_details_rec.max_award_amt);
3666: fnd_message.set_token('FUND',p_fund_code);
3667: fnd_msg_pub.add;
3668: END IF;

Line 3665: fnd_message.set_token('AMOUNT',fund_details_rec.max_award_amt);

3661: -- Check if the Award Amount is exceeding the Max Award Amount in the fund
3662: --
3663: IF NVL(total_award_amt_rec.total_award_amt,0) > fund_details_rec.max_award_amt THEN
3664: fnd_message.set_name('IGF','IGF_AW_MAX_AMT_EXCEED');
3665: fnd_message.set_token('AMOUNT',fund_details_rec.max_award_amt);
3666: fnd_message.set_token('FUND',p_fund_code);
3667: fnd_msg_pub.add;
3668: END IF;
3669:

Line 3666: fnd_message.set_token('FUND',p_fund_code);

3662: --
3663: IF NVL(total_award_amt_rec.total_award_amt,0) > fund_details_rec.max_award_amt THEN
3664: fnd_message.set_name('IGF','IGF_AW_MAX_AMT_EXCEED');
3665: fnd_message.set_token('AMOUNT',fund_details_rec.max_award_amt);
3666: fnd_message.set_token('FUND',p_fund_code);
3667: fnd_msg_pub.add;
3668: END IF;
3669:
3670: --

Line 3675: fnd_message.set_name('IGF','IGF_AW_STD_EXCED_MAX_YR_AMT');

3671: -- Check if the Award Amount is exceeding the Max Yearly Amounts in the fund
3672: --
3673: IF fund_details_rec.max_yearly_amt > 0 THEN
3674: IF NVL(total_fund_awd_rec.total_fund_amt,0) > fund_details_rec.max_yearly_amt THEN
3675: fnd_message.set_name('IGF','IGF_AW_STD_EXCED_MAX_YR_AMT');
3676: fnd_message.set_token('AMOUNT',fund_details_rec.max_yearly_amt);
3677: fnd_message.set_token('FUND',p_fund_code);
3678: fnd_msg_pub.add;
3679: END IF;

Line 3676: fnd_message.set_token('AMOUNT',fund_details_rec.max_yearly_amt);

3672: --
3673: IF fund_details_rec.max_yearly_amt > 0 THEN
3674: IF NVL(total_fund_awd_rec.total_fund_amt,0) > fund_details_rec.max_yearly_amt THEN
3675: fnd_message.set_name('IGF','IGF_AW_STD_EXCED_MAX_YR_AMT');
3676: fnd_message.set_token('AMOUNT',fund_details_rec.max_yearly_amt);
3677: fnd_message.set_token('FUND',p_fund_code);
3678: fnd_msg_pub.add;
3679: END IF;
3680: END IF;

Line 3677: fnd_message.set_token('FUND',p_fund_code);

3673: IF fund_details_rec.max_yearly_amt > 0 THEN
3674: IF NVL(total_fund_awd_rec.total_fund_amt,0) > fund_details_rec.max_yearly_amt THEN
3675: fnd_message.set_name('IGF','IGF_AW_STD_EXCED_MAX_YR_AMT');
3676: fnd_message.set_token('AMOUNT',fund_details_rec.max_yearly_amt);
3677: fnd_message.set_token('FUND',p_fund_code);
3678: fnd_msg_pub.add;
3679: END IF;
3680: END IF;
3681: --

Line 3686: fnd_message.set_name('IGF','IGF_AW_STD_EXCED_MAX_LF_AMT');

3682: -- Check whether the Award Amount is exceeding the LifeTime Amount in the fund
3683: --
3684: IF fund_details_rec.max_life_amt >0 THEN
3685: IF NVL(max_lf_count_rec.lf_total,0) > fund_details_rec.max_life_amt THEN
3686: fnd_message.set_name('IGF','IGF_AW_STD_EXCED_MAX_LF_AMT');
3687: fnd_message.set_token('AMOUNT',fund_details_rec.max_life_amt);
3688: fnd_message.set_token('FUND',p_fund_code);
3689: fnd_msg_pub.add;
3690: END IF;

Line 3687: fnd_message.set_token('AMOUNT',fund_details_rec.max_life_amt);

3683: --
3684: IF fund_details_rec.max_life_amt >0 THEN
3685: IF NVL(max_lf_count_rec.lf_total,0) > fund_details_rec.max_life_amt THEN
3686: fnd_message.set_name('IGF','IGF_AW_STD_EXCED_MAX_LF_AMT');
3687: fnd_message.set_token('AMOUNT',fund_details_rec.max_life_amt);
3688: fnd_message.set_token('FUND',p_fund_code);
3689: fnd_msg_pub.add;
3690: END IF;
3691: END IF;

Line 3688: fnd_message.set_token('FUND',p_fund_code);

3684: IF fund_details_rec.max_life_amt >0 THEN
3685: IF NVL(max_lf_count_rec.lf_total,0) > fund_details_rec.max_life_amt THEN
3686: fnd_message.set_name('IGF','IGF_AW_STD_EXCED_MAX_LF_AMT');
3687: fnd_message.set_token('AMOUNT',fund_details_rec.max_life_amt);
3688: fnd_message.set_token('FUND',p_fund_code);
3689: fnd_msg_pub.add;
3690: END IF;
3691: END IF;
3692: --

Line 3698: fnd_message.set_name('IGF','IGF_DB_MAX_LIFE_TERM_EXCEED');

3694: --
3695:
3696: IF fund_details_rec.max_life_term >0 THEN
3697: IF NVL(max_lf_count_rec.lf_count,0) > fund_details_rec.max_life_term THEN
3698: fnd_message.set_name('IGF','IGF_DB_MAX_LIFE_TERM_EXCEED');
3699: fnd_message.set_token('TERM',fund_details_rec.max_life_term );
3700: fnd_message.set_token('FUND',p_fund_code);
3701: fnd_msg_pub.add;
3702: END IF;

Line 3699: fnd_message.set_token('TERM',fund_details_rec.max_life_term );

3695:
3696: IF fund_details_rec.max_life_term >0 THEN
3697: IF NVL(max_lf_count_rec.lf_count,0) > fund_details_rec.max_life_term THEN
3698: fnd_message.set_name('IGF','IGF_DB_MAX_LIFE_TERM_EXCEED');
3699: fnd_message.set_token('TERM',fund_details_rec.max_life_term );
3700: fnd_message.set_token('FUND',p_fund_code);
3701: fnd_msg_pub.add;
3702: END IF;
3703: END IF;

Line 3700: fnd_message.set_token('FUND',p_fund_code);

3696: IF fund_details_rec.max_life_term >0 THEN
3697: IF NVL(max_lf_count_rec.lf_count,0) > fund_details_rec.max_life_term THEN
3698: fnd_message.set_name('IGF','IGF_DB_MAX_LIFE_TERM_EXCEED');
3699: fnd_message.set_token('TERM',fund_details_rec.max_life_term );
3700: fnd_message.set_token('FUND',p_fund_code);
3701: fnd_msg_pub.add;
3702: END IF;
3703: END IF;
3704:

Line 3746: fnd_message.set_name('IGF',l_msg_name);

3742: l_msg_name := 'IGF_AW_DEP_STAT_NOT_FND';
3743: ELSIF l_msg_name = 'IGF_AW_LOAN_LMT_NOT_FND' THEN
3744: l_msg_name := 'IGF_AW_LOAN_LMT_NOT_FND_WNG';
3745: END IF;
3746: fnd_message.set_name('IGF',l_msg_name);
3747: fnd_msg_pub.add;
3748: ELSIF ln_corrected_amt < 0 THEN
3749: -- if the ln_corrected_amt is less than 0 then some of the Stafford loan limit check has failed so
3750: -- we are displaying the appropriate warning message since the user can override the message.

Line 3766: fnd_message.set_name('IGF',l_msg_name);

3762: l_msg_name := 'IGF_AW_UNSUB_AGGR_LMT_WNG';
3763: ELSIF l_msg_name = 'IGF_AW_UNSUB_LMT_ERR' THEN
3764: l_msg_name := 'IGF_AW_UNSUB_LMT_WNG';
3765: END IF;
3766: fnd_message.set_name('IGF',l_msg_name);
3767: fnd_message.set_token('FUND_CODE',p_fund_code);
3768: fnd_msg_pub.add;
3769: END IF;
3770: END IF;

Line 3767: fnd_message.set_token('FUND_CODE',p_fund_code);

3763: ELSIF l_msg_name = 'IGF_AW_UNSUB_LMT_ERR' THEN
3764: l_msg_name := 'IGF_AW_UNSUB_LMT_WNG';
3765: END IF;
3766: fnd_message.set_name('IGF',l_msg_name);
3767: fnd_message.set_token('FUND_CODE',p_fund_code);
3768: fnd_msg_pub.add;
3769: END IF;
3770: END IF;
3771: END IF;

Line 3864: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

3860: RETURN lv_message;
3861:
3862: EXCEPTION
3863: WHEN OTHERS THEN
3864: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3865: fnd_message.set_token('NAME','IGF_AW_GEN_003.CHECK_AMOUNTS'|| ' ' ||SQLERRM );
3866: app_exception.raise_exception;
3867:
3868: END check_amounts;

Line 3865: fnd_message.set_token('NAME','IGF_AW_GEN_003.CHECK_AMOUNTS'|| ' ' ||SQLERRM );

3861:
3862: EXCEPTION
3863: WHEN OTHERS THEN
3864: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3865: fnd_message.set_token('NAME','IGF_AW_GEN_003.CHECK_AMOUNTS'|| ' ' ||SQLERRM );
3866: app_exception.raise_exception;
3867:
3868: END check_amounts;
3869:

Line 3974: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');

3970: EXCEPTION
3971:
3972: WHEN app_exception.record_lock_exception THEN
3973: ROLLBACK to bill_upd_sp;
3974: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
3975: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_BILL_FLAG' );
3976: app_exception.raise_exception;
3977:
3978: WHEN others THEN

Line 3975: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_BILL_FLAG' );

3971:
3972: WHEN app_exception.record_lock_exception THEN
3973: ROLLBACK to bill_upd_sp;
3974: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
3975: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_BILL_FLAG' );
3976: app_exception.raise_exception;
3977:
3978: WHEN others THEN
3979: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

Line 3979: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

3975: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_BILL_FLAG' );
3976: app_exception.raise_exception;
3977:
3978: WHEN others THEN
3979: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3980: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_BILL_FLAG'|| ' ' || SQLERRM);
3981: app_exception.raise_exception;
3982:
3983:

Line 3980: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_BILL_FLAG'|| ' ' || SQLERRM);

3976: app_exception.raise_exception;
3977:
3978: WHEN others THEN
3979: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3980: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_BILL_FLAG'|| ' ' || SQLERRM);
3981: app_exception.raise_exception;
3982:
3983:
3984: END update_bill_flag;

Line 4141: fnd_message.set_name('IGF','IGF_AW_NO_DEL_PELL');

4137: FETCH cur_pell_awd INTO pell_awd_rec;
4138: CLOSE cur_pell_awd;
4139:
4140: IF pell_awd_rec.awd_count > 0 THEN
4141: fnd_message.set_name('IGF','IGF_AW_NO_DEL_PELL');
4142: lv_message := fnd_message.get;
4143: RETURN lv_message;
4144: END IF;
4145:

Line 4142: lv_message := fnd_message.get;

4138: CLOSE cur_pell_awd;
4139:
4140: IF pell_awd_rec.awd_count > 0 THEN
4141: fnd_message.set_name('IGF','IGF_AW_NO_DEL_PELL');
4142: lv_message := fnd_message.get;
4143: RETURN lv_message;
4144: END IF;
4145:
4146:

Line 4152: fnd_message.set_name('IGF','IGF_AW_NO_DEL_LOAN');

4148: FETCH cur_loan_awd INTO loan_awd_rec;
4149: CLOSE cur_loan_awd;
4150:
4151: IF loan_awd_rec.awd_count > 0 THEN
4152: fnd_message.set_name('IGF','IGF_AW_NO_DEL_LOAN');
4153: lv_message := fnd_message.get;
4154: RETURN lv_message;
4155: END IF;
4156:

Line 4153: lv_message := fnd_message.get;

4149: CLOSE cur_loan_awd;
4150:
4151: IF loan_awd_rec.awd_count > 0 THEN
4152: fnd_message.set_name('IGF','IGF_AW_NO_DEL_LOAN');
4153: lv_message := fnd_message.get;
4154: RETURN lv_message;
4155: END IF;
4156:
4157: -- Check for the FWS fund before detion of the Awards and its Disbursements

Line 4165: fnd_message.set_name('IGF','IGF_SE_AUTH_OR_PAID_PRSNT');

4161: FETCH cur_fws_awd INTO fws_awd_rec;
4162: CLOSE cur_fws_awd;
4163:
4164: IF fws_awd_rec.awd_count > 0 THEN
4165: fnd_message.set_name('IGF','IGF_SE_AUTH_OR_PAID_PRSNT');
4166: lv_message := fnd_message.get;
4167: RETURN lv_message;
4168: END IF;
4169:

Line 4166: lv_message := fnd_message.get;

4162: CLOSE cur_fws_awd;
4163:
4164: IF fws_awd_rec.awd_count > 0 THEN
4165: fnd_message.set_name('IGF','IGF_SE_AUTH_OR_PAID_PRSNT');
4166: lv_message := fnd_message.get;
4167: RETURN lv_message;
4168: END IF;
4169:
4170: END IF;

Line 4187: fnd_message.set_name('IGF','IGF_DB_DISB_DBCHG_FK');

4183: FOR get_chg_dtls IN cur_chg_dtls(p_award_id,get_adisb_rec.disb_num) LOOP
4184: IF get_chg_dtls.disb_status IN ('G') THEN
4185: igf_aw_db_chg_dtls_pkg.delete_row(get_chg_dtls.row_id);
4186: ELSE
4187: fnd_message.set_name('IGF','IGF_DB_DISB_DBCHG_FK');
4188: lv_message := fnd_message.get;
4189: RETURN lv_message;
4190: END IF;
4191: END LOOP;

Line 4188: lv_message := fnd_message.get;

4184: IF get_chg_dtls.disb_status IN ('G') THEN
4185: igf_aw_db_chg_dtls_pkg.delete_row(get_chg_dtls.row_id);
4186: ELSE
4187: fnd_message.set_name('IGF','IGF_DB_DISB_DBCHG_FK');
4188: lv_message := fnd_message.get;
4189: RETURN lv_message;
4190: END IF;
4191: END LOOP;
4192: END IF;

Line 4208: fnd_message.parse_encoded(fnd_message.get_encoded, l_app, l_name);

4204: --
4205: -- Return Adjustment fk message
4206: --
4207: ROLLBACK;
4208: fnd_message.parse_encoded(fnd_message.get_encoded, l_app, l_name);
4209: IF l_name = 'IGF_DB_DDTL_AWDD_FK' THEN
4210: fnd_message.set_name('IGF','IGF_DB_DDTL_AWDD_FK');
4211: lv_message := fnd_message.get;
4212: RETURN lv_message;

Line 4210: fnd_message.set_name('IGF','IGF_DB_DDTL_AWDD_FK');

4206: --
4207: ROLLBACK;
4208: fnd_message.parse_encoded(fnd_message.get_encoded, l_app, l_name);
4209: IF l_name = 'IGF_DB_DDTL_AWDD_FK' THEN
4210: fnd_message.set_name('IGF','IGF_DB_DDTL_AWDD_FK');
4211: lv_message := fnd_message.get;
4212: RETURN lv_message;
4213: ELSIF
4214: l_name = 'IGS_FI_FIPC_ADISB_FK' THEN

Line 4211: lv_message := fnd_message.get;

4207: ROLLBACK;
4208: fnd_message.parse_encoded(fnd_message.get_encoded, l_app, l_name);
4209: IF l_name = 'IGF_DB_DDTL_AWDD_FK' THEN
4210: fnd_message.set_name('IGF','IGF_DB_DDTL_AWDD_FK');
4211: lv_message := fnd_message.get;
4212: RETURN lv_message;
4213: ELSIF
4214: l_name = 'IGS_FI_FIPC_ADISB_FK' THEN
4215: fnd_message.set_name('IGS','IGS_FI_FIPC_ADISB_FK');

Line 4215: fnd_message.set_name('IGS','IGS_FI_FIPC_ADISB_FK');

4211: lv_message := fnd_message.get;
4212: RETURN lv_message;
4213: ELSIF
4214: l_name = 'IGS_FI_FIPC_ADISB_FK' THEN
4215: fnd_message.set_name('IGS','IGS_FI_FIPC_ADISB_FK');
4216: lv_message := fnd_message.get;
4217: RETURN lv_message;
4218: ELSE
4219: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP' );

Line 4216: lv_message := fnd_message.get;

4212: RETURN lv_message;
4213: ELSIF
4214: l_name = 'IGS_FI_FIPC_ADISB_FK' THEN
4215: fnd_message.set_name('IGS','IGS_FI_FIPC_ADISB_FK');
4216: lv_message := fnd_message.get;
4217: RETURN lv_message;
4218: ELSE
4219: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP' );
4220: fnd_message.set_token('NAME','IGF_AW_GEN_003.DELETE_AWD_DISB'||' '||SQLERRM);

Line 4219: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP' );

4215: fnd_message.set_name('IGS','IGS_FI_FIPC_ADISB_FK');
4216: lv_message := fnd_message.get;
4217: RETURN lv_message;
4218: ELSE
4219: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP' );
4220: fnd_message.set_token('NAME','IGF_AW_GEN_003.DELETE_AWD_DISB'||' '||SQLERRM);
4221: app_exception.raise_exception;
4222: END IF;
4223:

Line 4220: fnd_message.set_token('NAME','IGF_AW_GEN_003.DELETE_AWD_DISB'||' '||SQLERRM);

4216: lv_message := fnd_message.get;
4217: RETURN lv_message;
4218: ELSE
4219: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP' );
4220: fnd_message.set_token('NAME','IGF_AW_GEN_003.DELETE_AWD_DISB'||' '||SQLERRM);
4221: app_exception.raise_exception;
4222: END IF;
4223:
4224:

Line 4261: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

4257:
4258: EXCEPTION
4259:
4260: WHEN OTHERS THEN
4261: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
4262: fnd_message.set_token('NAME','IGF_AW_GEN_003.GET_TOTAL_DISB' || ' ' || SQLERRM);
4263: app_exception.raise_exception;
4264:
4265: END get_total_disb;

Line 4262: fnd_message.set_token('NAME','IGF_AW_GEN_003.GET_TOTAL_DISB' || ' ' || SQLERRM);

4258: EXCEPTION
4259:
4260: WHEN OTHERS THEN
4261: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
4262: fnd_message.set_token('NAME','IGF_AW_GEN_003.GET_TOTAL_DISB' || ' ' || SQLERRM);
4263: app_exception.raise_exception;
4264:
4265: END get_total_disb;
4266:

Line 4352: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP' );

4348: IF (c_chk_awd_grp_per%ISOPEN) THEN
4349: CLOSE c_chk_awd_grp_per;
4350: END IF;
4351:
4352: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP' );
4353: fnd_message.set_token('NAME','IGF_AW_GEN_003.AWD_GROUP_FREEZE'||' '|| SQLERRM);
4354: app_exception.raise_exception;
4355:
4356: END awd_group_freeze;

Line 4353: fnd_message.set_token('NAME','IGF_AW_GEN_003.AWD_GROUP_FREEZE'||' '|| SQLERRM);

4349: CLOSE c_chk_awd_grp_per;
4350: END IF;
4351:
4352: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP' );
4353: fnd_message.set_token('NAME','IGF_AW_GEN_003.AWD_GROUP_FREEZE'||' '|| SQLERRM);
4354: app_exception.raise_exception;
4355:
4356: END awd_group_freeze;
4357:

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

4605: END IF;
4606:
4607: EXCEPTION
4608: WHEN OTHERS THEN
4609: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4610: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_AWARD_APP_TRANS '||SQLERRM);
4611: igs_ge_msg_stack.add;
4612: app_exception.raise_exception;
4613:

Line 4610: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_AWARD_APP_TRANS '||SQLERRM);

4606:
4607: EXCEPTION
4608: WHEN OTHERS THEN
4609: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4610: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_AWARD_APP_TRANS '||SQLERRM);
4611: igs_ge_msg_stack.add;
4612: app_exception.raise_exception;
4613:
4614: END update_award_app_trans;

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

4637: RETURN TRUE;
4638: END IF;
4639: EXCEPTION
4640: WHEN OTHERS THEN
4641: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4642: fnd_message.set_token('NAME','IGF_AW_GEN_003.CHECK_COA '||SQLERRM);
4643: igs_ge_msg_stack.add;
4644: app_exception.raise_exception;
4645:

Line 4642: fnd_message.set_token('NAME','IGF_AW_GEN_003.CHECK_COA '||SQLERRM);

4638: END IF;
4639: EXCEPTION
4640: WHEN OTHERS THEN
4641: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4642: fnd_message.set_token('NAME','IGF_AW_GEN_003.CHECK_COA '||SQLERRM);
4643: igs_ge_msg_stack.add;
4644: app_exception.raise_exception;
4645:
4646: END check_coa;