DBA Data[Home] [Help]

APPS.IGS_AD_VAL_ACAI dependencies on APP_EXCEPTION

Line 347: APP_EXCEPTION.RAISE_EXCEPTION;

343: WHEN OTHERS THEN
344: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
345: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acai_insert');
346: IGS_GE_MSG_STACK.ADD;
347: APP_EXCEPTION.RAISE_EXCEPTION;
348: END admp_val_acai_insert;
349: --
350: -- Validate update of an IGS_AD_PS_APPL_INST record.
351: FUNCTION admp_val_acai_update(

Line 447: APP_EXCEPTION.RAISE_EXCEPTION;

443: WHEN OTHERS THEN
444: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
445: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acai_update');
446: IGS_GE_MSG_STACK.ADD;
447: APP_EXCEPTION.RAISE_EXCEPTION;
448: END admp_val_acai_update;
449: --
450: -- Validate delete of an IGS_AD_PS_APPL_INST record.
451: FUNCTION admp_val_acai_delete(

Line 524: APP_EXCEPTION.RAISE_EXCEPTION;

520: WHEN OTHERS THEN
521: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
522: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acai_delete');
523: IGS_GE_MSG_STACK.ADD;
524: APP_EXCEPTION.RAISE_EXCEPTION;
525: END admp_val_acai_delete;
526: --
527: -- Validate change of preferences.
528: FUNCTION admp_val_chg_of_pref(

Line 588: APP_EXCEPTION.RAISE_EXCEPTION;

584: WHEN OTHERS THEN
585: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
586: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_chg_of_pref');
587: IGS_GE_MSG_STACK.ADD;
588: APP_EXCEPTION.RAISE_EXCEPTION;
589: END admp_val_chg_of_pref;
590: --
591:
592: -- Validate the course code of the admission application.

Line 732: APP_EXCEPTION.RAISE_EXCEPTION;

728: WHEN OTHERS THEN
729: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
730: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acai_course');
731: IGS_GE_MSG_STACK.ADD;
732: APP_EXCEPTION.RAISE_EXCEPTION;
733: END admp_val_acai_course;
734: --
735: -- Perform encumbrance check for admission_course_appl_instance.course_cd
736: FUNCTION admp_val_acai_encmb(

Line 797: APP_EXCEPTION.RAISE_EXCEPTION;

793: WHEN OTHERS THEN
794: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
795: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acai_encmb');
796: IGS_GE_MSG_STACK.ADD;
797: APP_EXCEPTION.RAISE_EXCEPTION;
798: END admp_val_acai_encmb;
799: --
800: -- Validate course appl process type against the student course attempt.
801: FUNCTION admp_val_aca_sca(

Line 1006: APP_EXCEPTION.RAISE_EXCEPTION;

1002: WHEN OTHERS THEN
1003: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
1004: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_aca_sca');
1005: IGS_GE_MSG_STACK.ADD;
1006: APP_EXCEPTION.RAISE_EXCEPTION;
1007: END admp_val_aca_sca;
1008: --
1009: -- Validate the adm course application instance course offering pattern.
1010: FUNCTION admp_val_acai_cop(

Line 1117: APP_EXCEPTION.RAISE_EXCEPTION;

1113: WHEN OTHERS THEN
1114: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
1115: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acai_cop');
1116: IGS_GE_MSG_STACK.ADD;
1117: APP_EXCEPTION.RAISE_EXCEPTION;
1118: END admp_val_acai_cop;
1119: --
1120: -- Validate the adm course application instance course offering option.
1121: FUNCTION admp_val_acai_coo(

Line 1597: APP_EXCEPTION.RAISE_EXCEPTION;

1593: WHEN OTHERS THEN
1594: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
1595: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admpl_val_param');
1596: IGS_GE_MSG_STACK.ADD;
1597: APP_EXCEPTION.RAISE_EXCEPTION;
1598: END admpl_val_param;
1599: ----------------------------------------- MAIN ---------------------------------
1600: BEGIN
1601: p_message_name := NULL;

Line 1627: APP_EXCEPTION.RAISE_EXCEPTION;

1623: WHEN OTHERS THEN
1624: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
1625: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acai_opt');
1626: IGS_GE_MSG_STACK.ADD;
1627: APP_EXCEPTION.RAISE_EXCEPTION;
1628: END admp_val_acai_opt;
1629: --
1630: -- Validate the admission course application unit set.
1631: FUNCTION admp_val_acai_us(

Line 1936: APP_EXCEPTION.RAISE_EXCEPTION;

1932: WHEN OTHERS THEN
1933: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
1934: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acai_us');
1935: IGS_GE_MSG_STACK.ADD;
1936: APP_EXCEPTION.RAISE_EXCEPTION;
1937: END admp_val_acai_us;
1938: --
1939: -- Validate CACUS can only be created when US is not a subordinate
1940: FUNCTION crsp_val_cacus_sub(

Line 1997: APP_EXCEPTION.RAISE_EXCEPTION;

1993: WHEN OTHERS THEN
1994: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
1995: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.crsp_val_cacus_sub');
1996: IGS_GE_MSG_STACK.ADD;
1997: APP_EXCEPTION.RAISE_EXCEPTION;
1998: END crsp_val_cacus_sub;
1999: --
2000: -- Do encumbrance checks for the IGS_AD_PS_APPL_INST.unit_set_cd.
2001: FUNCTION admp_val_us_encmb(

Line 2065: APP_EXCEPTION.RAISE_EXCEPTION;

2061: WHEN OTHERS THEN
2062: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2063: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_us_encmb');
2064: IGS_GE_MSG_STACK.ADD;
2065: APP_EXCEPTION.RAISE_EXCEPTION;
2066: END admp_val_us_encmb;
2067: --
2068: -- Validate the IGS_AD_PS_APPL_INST.offer_dt.
2069: FUNCTION admp_val_offer_dt(

Line 2110: APP_EXCEPTION.RAISE_EXCEPTION;

2106: WHEN OTHERS THEN
2107: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2108: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_offer_dt');
2109: IGS_GE_MSG_STACK.ADD;
2110: APP_EXCEPTION.RAISE_EXCEPTION;
2111: END admp_val_offer_dt;
2112: --
2113: -- Validate the IGS_AD_PS_APPL_INST.offer_response_dt.
2114: FUNCTION admp_val_off_resp_dt(

Line 2155: APP_EXCEPTION.RAISE_EXCEPTION;

2151: WHEN OTHERS THEN
2152: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2153: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_off_resp_dt');
2154: IGS_GE_MSG_STACK.ADD;
2155: APP_EXCEPTION.RAISE_EXCEPTION;
2156: END admp_val_off_resp_dt;
2157: --
2158: -- Validate the IGS_AD_PS_APPL_INST.actual_response_dt.
2159: FUNCTION admp_val_act_resp_dt(

Line 2208: APP_EXCEPTION.RAISE_EXCEPTION;

2204: WHEN OTHERS THEN
2205: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2206: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_act_resp_dt');
2207: IGS_GE_MSG_STACK.ADD;
2208: APP_EXCEPTION.RAISE_EXCEPTION;
2209: END admp_val_act_resp_dt;
2210: --
2211: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_satisfied_dt.
2212: FUNCTION admp_val_stsfd_dt(

Line 2256: APP_EXCEPTION.RAISE_EXCEPTION;

2252: WHEN OTHERS THEN
2253: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2254: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_stsfd_dt');
2255: IGS_GE_MSG_STACK.ADD;
2256: APP_EXCEPTION.RAISE_EXCEPTION;
2257: END admp_val_stsfd_dt;
2258: --
2259: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_cndtn.
2260: FUNCTION admp_val_offer_cndtn(

Line 2296: APP_EXCEPTION.RAISE_EXCEPTION;

2292: WHEN OTHERS THEN
2293: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2294: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_offer_cndtn');
2295: IGS_GE_MSG_STACK.ADD;
2296: APP_EXCEPTION.RAISE_EXCEPTION;
2297: END admp_val_offer_cndtn;
2298: --
2299: -- Validate the IGS_AD_PS_APPL_INST.applicant_acptnce_cndtn.
2300: FUNCTION admp_val_acpt_cndtn(

Line 2339: APP_EXCEPTION.RAISE_EXCEPTION;

2335: WHEN OTHERS THEN
2336: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2337: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acpt_cndtn');
2338: IGS_GE_MSG_STACK.ADD;
2339: APP_EXCEPTION.RAISE_EXCEPTION;
2340: END admp_val_acpt_cndtn;
2341: --
2342: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_must_be_stsfd_ind.
2343: FUNCTION admp_val_must_stsfd(

Line 2388: APP_EXCEPTION.RAISE_EXCEPTION;

2384: WHEN OTHERS THEN
2385: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2386: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_must_stsfd');
2387: IGS_GE_MSG_STACK.ADD;
2388: APP_EXCEPTION.RAISE_EXCEPTION;
2389: END admp_val_must_stsfd;
2390: --
2391: -- Validate adm course application instance deferred admission calendar.
2392: FUNCTION admp_val_dfrmnt_cal(

Line 2538: APP_EXCEPTION.RAISE_EXCEPTION;

2534: WHEN OTHERS THEN
2535: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2536: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_dfrmnt_cal');
2537: IGS_GE_MSG_STACK.ADD;
2538: APP_EXCEPTION.RAISE_EXCEPTION;
2539: END admp_val_dfrmnt_cal;
2540: --
2541: -- Validate if admission course application instance corresponce cat.
2542: FUNCTION admp_val_acai_cc(

Line 2588: APP_EXCEPTION.RAISE_EXCEPTION;

2584: WHEN OTHERS THEN
2585: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2586: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acai_cc');
2587: IGS_GE_MSG_STACK.ADD;
2588: APP_EXCEPTION.RAISE_EXCEPTION;
2589: END admp_val_acai_cc;
2590: --
2591: -- Validate if IGS_CO_CAT.correspondence_cat is closed.
2592: FUNCTION corp_val_cc_closed(

Line 2624: APP_EXCEPTION.RAISE_EXCEPTION;

2620: WHEN OTHERS THEN
2621: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2622: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.corp_val_cc_closed');
2623: IGS_GE_MSG_STACK.ADD;
2624: APP_EXCEPTION.RAISE_EXCEPTION;
2625: END corp_val_cc_closed;
2626: --
2627: -- Validate if admission course application instance enrolment category.
2628: FUNCTION admp_val_acai_ec(

Line 2674: APP_EXCEPTION.RAISE_EXCEPTION;

2670: WHEN OTHERS THEN
2671: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2672: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acai_ec');
2673: IGS_GE_MSG_STACK.ADD;
2674: APP_EXCEPTION.RAISE_EXCEPTION;
2675: END admp_val_acai_ec;
2676:
2677:
2678: --

Line 2734: APP_EXCEPTION.RAISE_EXCEPTION;

2730: WHEN OTHERS THEN
2731: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2732: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acai_fc');
2733: IGS_GE_MSG_STACK.ADD;
2734: APP_EXCEPTION.RAISE_EXCEPTION;
2735: END admp_val_acai_fc;
2736: --
2737: -- Validate admission course application instance HECS payment option.
2738: FUNCTION admp_val_acai_hpo(

Line 2781: APP_EXCEPTION.RAISE_EXCEPTION;

2777: WHEN OTHERS THEN
2778: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2779: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acai_hpo');
2780: IGS_GE_MSG_STACK.ADD;
2781: APP_EXCEPTION.RAISE_EXCEPTION;
2782: END admp_val_acai_hpo;
2783: --
2784: --
2785: -- Validate the IGS_AD_PS_APPL_INST.adm_outcome_status_auth_dt.

Line 2822: APP_EXCEPTION.RAISE_EXCEPTION;

2818: WHEN OTHERS THEN
2819: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2820: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_ovrd_dt');
2821: IGS_GE_MSG_STACK.ADD;
2822: APP_EXCEPTION.RAISE_EXCEPTION;
2823: END admp_val_ovrd_dt;
2824: --
2825: -- Validate the IGS_AD_PS_APPL_INST.adm_otcm_status_auth_person_id.
2826: FUNCTION admp_val_ovrd_person(

Line 2884: APP_EXCEPTION.RAISE_EXCEPTION;

2880: WHEN OTHERS THEN
2881: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
2882: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_ovrd_person');
2883: IGS_GE_MSG_STACK.ADD;
2884: APP_EXCEPTION.RAISE_EXCEPTION;
2885: END admp_val_ovrd_person;
2886: --
2887: -- Validate a IGS_PE_PERSON id to ensure the IGS_PE_PERSON is a staff member.
2888: FUNCTION genp_val_staff_prsn(

Line 3041: APP_EXCEPTION.RAISE_EXCEPTION;

3037: WHEN OTHERS THEN
3038: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
3039: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_ovrd_reason');
3040: IGS_GE_MSG_STACK.ADD;
3041: APP_EXCEPTION.RAISE_EXCEPTION;
3042: END admp_val_ovrd_reason;
3043: --
3044: -- Validate that the course application is complete on offer.
3045: FUNCTION admp_val_offer_comp(

Line 3357: APP_EXCEPTION.RAISE_EXCEPTION;

3353: WHEN OTHERS THEN
3354: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
3355: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_offer_comp');
3356: IGS_GE_MSG_STACK.ADD;
3357: APP_EXCEPTION.RAISE_EXCEPTION;
3358: END admp_val_offer_comp;
3359: --
3360: -- Validate if the specified IGS_AD_PS_APPL_INST is complete.
3361: FUNCTION admp_val_acai_comp(

Line 4378: APP_EXCEPTION.RAISE_EXCEPTION;

4374: WHEN OTHERS THEN
4375: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
4376: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acai_comp');
4377: IGS_GE_MSG_STACK.ADD;
4378: APP_EXCEPTION.RAISE_EXCEPTION;
4379: END admp_val_acai_comp;
4380: --
4381: -- Validate if the specified admission application IGS_PE_PERSON is complete.
4382: FUNCTION admp_val_pe_comp(

Line 4761: APP_EXCEPTION.RAISE_EXCEPTION;

4757: WHEN OTHERS THEN
4758: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
4759: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_pe_comp');
4760: IGS_GE_MSG_STACK.ADD;
4761: APP_EXCEPTION.RAISE_EXCEPTION;
4762: END admp_val_pe_comp;
4763: --
4764: -- Validate the deferment of IGS_AD_PS_APLINSTUNT records.
4765: FUNCTION admp_val_acaiu_defer(

Line 4845: APP_EXCEPTION.RAISE_EXCEPTION;

4841: WHEN OTHERS THEN
4842: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
4843: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acaiu_defer');
4844: IGS_GE_MSG_STACK.ADD;
4845: APP_EXCEPTION.RAISE_EXCEPTION;
4846: END admp_val_acaiu_defer;
4847: --
4848: -- Validate the IGS_AD_PS_APPL_INST.preference_number.
4849: FUNCTION admp_val_acai_pref(

Line 4884: APP_EXCEPTION.RAISE_EXCEPTION;

4880: WHEN OTHERS THEN
4881: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
4882: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acai_pref');
4883: IGS_GE_MSG_STACK.ADD;
4884: APP_EXCEPTION.RAISE_EXCEPTION;
4885: END admp_val_acai_pref;
4886: --
4887: -- Validate adm course application instance expected completion details.
4888: FUNCTION admp_val_expctd_comp(

Line 4916: APP_EXCEPTION.RAISE_EXCEPTION;

4912: WHEN OTHERS THEN
4913: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
4914: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_expctd_comp');
4915: IGS_GE_MSG_STACK.ADD;
4916: APP_EXCEPTION.RAISE_EXCEPTION;
4917: END admp_val_expctd_comp;
4918: --
4919: -- Validate the admission course application instance funding source.
4920: FUNCTION admp_val_acai_fs(

Line 4987: APP_EXCEPTION.RAISE_EXCEPTION;

4983: WHEN OTHERS THEN
4984: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXP');
4985: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_AD_VAL_ACAI.admp_val_acai_fs');
4986: IGS_GE_MSG_STACK.ADD;
4987: APP_EXCEPTION.RAISE_EXCEPTION;
4988: END admp_val_acai_fs; -- admp_val_acai_fs
4989:
4990: END igs_ad_val_acai;