DBA Data[Home] [Help]

APPS.IGF_AW_GEN_003 dependencies on APP_EXCEPTION

Line 426: app_exception.raise_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:
430: PROCEDURE updating_coa_in_fa_base (p_base_id igf_ap_fa_base_rec.base_id%TYPE)

Line 704: app_exception.raise_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:
708: PROCEDURE round_off_disbursements(

Line 2388: app_exception.raise_exception;

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
2392: CLOSE c_auto_disb;

Line 2428: app_exception.raise_exception;

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;
2429:
2430: END create_auto_disb;
2431:
2432:

Line 2540: app_exception.raise_exception;

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:
2544: FUNCTION place_ovawd_holds (p_award_id igf_aw_award.award_id%TYPE,

Line 2591: app_exception.raise_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:
2595:

Line 2679: app_exception.raise_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:
2683: PROCEDURE update_accept_amount (p_award_id IN igf_aw_award.award_id%TYPE )

Line 2781: WHEN app_exception.record_lock_exception THEN

2777: END LOOP;
2778:
2779: EXCEPTION
2780:
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');

Line 2787: app_exception.raise_exception;

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:
2791: PROCEDURE update_awd_cancell_to_offer(p_award_id IN igf_aw_award.award_id%TYPE,

Line 3012: WHEN app_exception.record_lock_exception THEN

3008: );
3009: END LOOP;
3010: END IF;
3011: EXCEPTION
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');

Line 3018: app_exception.raise_exception;

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:
3022:

Line 3137: app_exception.raise_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:
3141:

Line 3866: app_exception.raise_exception;

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:
3870:

Line 3972: WHEN app_exception.record_lock_exception THEN

3968:
3969:
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;

Line 3976: app_exception.raise_exception;

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');
3980: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_BILL_FLAG'|| ' ' || SQLERRM);

Line 3981: 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;
3985:

Line 4221: app_exception.raise_exception;

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:
4225: END delete_awd_disb;

Line 4263: app_exception.raise_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:
4267: PROCEDURE awd_group_freeze(p_award_grp IN VARCHAR2,

Line 4354: app_exception.raise_exception;

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:
4358: PROCEDURE get_common_perct(

Line 4612: app_exception.raise_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;
4615:
4616: FUNCTION check_coa(

Line 4644: app_exception.raise_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;
4647: END igf_aw_gen_003;