DBA Data[Home] [Help]

APPS.IGS_EN_VAL_SCHO dependencies on APP_EXCEPTION

Line 67: App_Exception.Raise_Exception;

63: WHEN OTHERS THEN
64: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
65: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_scho_trgdel');
66: IGS_GE_MSG_STACK.ADD;
67: App_Exception.Raise_Exception;
68: END enrp_val_scho_trgdel;
69: --
70: -- To perform all validations on a scho record
71: FUNCTION ENRP_VAL_SCHO_ALL(

Line 420: App_Exception.Raise_Exception;

416: WHEN OTHERS THEN
417: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
418: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_scho_all');
419: IGS_GE_MSG_STACK.ADD;
420: App_Exception.Raise_Exception;
421: END enrp_val_scho_all;
422: --
423:
424:

Line 462: App_Exception.Raise_Exception;

458: WHEN OTHERS THEN
459: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
460: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_scho_open');
461: IGS_GE_MSG_STACK.ADD;
462: App_Exception.Raise_Exception;
463: END;
464: END enrp_val_scho_open;
465: --
466: -- Check for overlap in a students course hecs option records

Line 533: App_Exception.Raise_Exception;

529: WHEN OTHERS THEN
530: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
531: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_scho_ovrlp');
532: IGS_GE_MSG_STACK.ADD;
533: App_Exception.Raise_Exception;
534: END enrp_val_scho_ovrlp;
535: --
536: -- Validate student course HECS option start and end date.
537: FUNCTION enrp_val_scho_st_end(

Line 573: App_Exception.Raise_Exception;

569: WHEN OTHERS THEN
570: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
571: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_scho_st_end');
572: IGS_GE_MSG_STACK.ADD;
573: App_Exception.Raise_Exception;
574:
575: END;
576: END enrp_val_scho_st_end;
577: --

Line 632: App_Exception.Raise_Exception;

628: WHEN OTHERS THEN
629: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
630: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_scho_visa');
631: IGS_GE_MSG_STACK.ADD;
632: App_Exception.Raise_Exception;
633: END;
634: END enrp_val_scho_visa;
635: --
636: -- Validate student course attempt HECS payment option tax file number.

Line 759: App_Exception.Raise_Exception;

755: WHEN OTHERS THEN
756: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
757: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_scho_tfn');
758: IGS_GE_MSG_STACK.ADD;
759: App_Exception.Raise_Exception;
760: END;
761: END enrp_val_scho_tfn;
762: --
763: -- To validate the HECS Payment Option for a Student course HECS option

Line 922: App_Exception.Raise_Exception;

918: WHEN OTHERS THEN
919: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
920: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_scho_hpo');
921: IGS_GE_MSG_STACK.ADD;
922: App_Exception.Raise_Exception;
923: END enrp_val_scho_hpo;
924: --
925: -- Validate the insert of a student course HECS option record.
926: FUNCTION enrp_val_scho_insert(

Line 969: App_Exception.Raise_Exception;

965: WHEN OTHERS THEN
966: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
967: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_scho_insert');
968: IGS_GE_MSG_STACK.ADD;
969: App_Exception.Raise_Exception;
970: END;
971: END enrp_val_scho_insert;
972: --
973: -- Validate the update of a student course HECS option record.

Line 1002: App_Exception.Raise_Exception;

998: WHEN OTHERS THEN
999: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1000: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_scho_update');
1001: IGS_GE_MSG_STACK.ADD;
1002: App_Exception.Raise_Exception;
1003: END;
1004: END enrp_val_scho_update;
1005: --
1006: -- Validate the delete of a student course HECS option record.

Line 1035: App_Exception.Raise_Exception;

1031: WHEN OTHERS THEN
1032: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1033: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_scho_delete');
1034: IGS_GE_MSG_STACK.ADD;
1035: App_Exception.Raise_Exception;
1036: END;
1037: END enrp_val_scho_delete;
1038: --
1039: -- Validate HECS option, citizenship code and permanent resident.

Line 1129: App_Exception.Raise_Exception;

1125: WHEN OTHERS THEN
1126: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1127: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrpl_chk_whether_to_validate');
1128: IGS_GE_MSG_STACK.ADD;
1129: App_Exception.Raise_Exception;
1130: END;
1131: END enrpl_chk_whether_to_validate;
1132: FUNCTION enrpl_do_validations (
1133: p_outside_aus_res_ind IGS_EN_STDNT_PS_HECS_OPTION_V.outside_aus_res_ind%TYPE,

Line 1167: App_Exception.Raise_Exception;

1163: WHEN OTHERS THEN
1164: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1165: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrpl_do_validations');
1166: IGS_GE_MSG_STACK.ADD;
1167: App_Exception.Raise_Exception;
1168: END;
1169: END enrpl_do_validations;
1170: BEGIN
1171: -- This is the main module which validates the student_course_hecs_

Line 1282: App_Exception.Raise_Exception;

1278: WHEN OTHERS THEN
1279: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1280: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_ho_cic_prc');
1281: IGS_GE_MSG_STACK.ADD;
1282: App_Exception.Raise_Exception;
1283: END enrp_val_ho_cic_prc;
1284: --
1285: -- Validate HECS visa indicators, citizenship cd and permanent resident.
1286: FUNCTION enrp_val_vis_cic_prc(

Line 1368: App_Exception.Raise_Exception;

1364: WHEN OTHERS THEN
1365: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1366: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrpl_chk_whether_to_validate');
1367: IGS_GE_MSG_STACK.ADD;
1368: App_Exception.Raise_Exception;
1369: END;
1370: END enrpl_chk_whether_to_validate;
1371: FUNCTION enrpl_do_validations (
1372: p_outside_aus_res_ind IGS_EN_STDNT_PS_HECS_OPTION_V.outside_aus_res_ind%TYPE,

Line 1414: App_Exception.Raise_Exception;

1410: WHEN OTHERS THEN
1411: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1412: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrpl_do_validations');
1413: IGS_GE_MSG_STACK.ADD;
1414: App_Exception.Raise_Exception;
1415: END;
1416: END enrpl_do_validations;
1417: BEGIN
1418: -- This is the main module which validates the student_course_hecs_

Line 1537: App_Exception.Raise_Exception;

1533: WHEN OTHERS THEN
1534: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1535: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_vis_cic_prc');
1536: IGS_GE_MSG_STACK.ADD;
1537: App_Exception.Raise_Exception;
1538: END enrp_val_vis_cic_prc;
1539: --
1540: -- Validate the HECS Payment Option against the course type.
1541: FUNCTION enrp_val_hpo_crs_typ(

Line 1694: App_Exception.Raise_Exception;

1690: WHEN OTHERS THEN
1691: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1692: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_hpo_crs_typ');
1693: IGS_GE_MSG_STACK.ADD;
1694: App_Exception.Raise_Exception;
1695: END enrp_val_hpo_crs_typ;
1696: --
1697: -- Validate the HECS Payment Option against the special course type.
1698: FUNCTION enrp_val_hpo_spc_crs(

Line 1800: App_Exception.Raise_Exception;

1796: WHEN OTHERS THEN
1797: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1798: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_hpo_spc_crs');
1799: IGS_GE_MSG_STACK.ADD;
1800: App_Exception.Raise_Exception;
1801: END enrp_val_hpo_spc_crs;
1802: --
1803: -- Validate HECS payment option, visa indicators and citizenship code.
1804: FUNCTION enrp_val_hpo_vis_cic(

Line 1891: App_Exception.Raise_Exception;

1887: WHEN OTHERS THEN
1888: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1889: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrpl_chk_whether_to_validate');
1890: IGS_GE_MSG_STACK.ADD;
1891: App_Exception.Raise_Exception;
1892: END enrpl_chk_whether_to_validate;
1893: FUNCTION enrpl_do_validations (
1894: p_outside_aus_res_ind IGS_EN_STDNT_PS_HECS_OPTION_V.outside_aus_res_ind%TYPE,
1895: p_nz_citizen_ind IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_ind%TYPE,

Line 1968: App_Exception.Raise_Exception;

1964: WHEN OTHERS THEN
1965: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1966: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrpl_do_validations');
1967: IGS_GE_MSG_STACK.ADD;
1968: App_Exception.Raise_Exception;
1969: END enrpl_do_validations;
1970: BEGIN
1971: -- This is the main module which validates the student_course_hecs_
1972: -- option_v.IGS_FI_HECS_PAY_OPTN against the IGS_PE_STATISTICS.

Line 2097: App_Exception.Raise_Exception;

2093: WHEN OTHERS THEN
2094: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2095: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_hpo_vis_cic');
2096: IGS_GE_MSG_STACK.ADD;
2097: App_Exception.Raise_Exception;
2098: END enrp_val_hpo_vis_cic;
2099: --
2100: -- Validate HECS payment option, citizenship code and permanent resident.
2101: FUNCTION enrp_val_hpo_cic_prc(

Line 2190: App_Exception.Raise_Exception;

2186: WHEN OTHERS THEN
2187: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2188: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrpl_chk_whether_to_validate');
2189: IGS_GE_MSG_STACK.ADD;
2190: App_Exception.Raise_Exception;
2191: END;
2192: END enrpl_chk_whether_to_validate;
2193: FUNCTION enrpl_do_validations (
2194: p_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE,

Line 2247: App_Exception.Raise_Exception;

2243: WHEN OTHERS THEN
2244: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2245: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrpl_do_validations');
2246: IGS_GE_MSG_STACK.ADD;
2247: App_Exception.Raise_Exception;
2248: END;
2249: END enrpl_do_validations;
2250: BEGIN
2251: -- This is the main module which validates the student_course_hecs_

Line 2383: App_Exception.Raise_Exception;

2379: WHEN OTHERS THEN
2380: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2381: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.');
2382: IGS_GE_MSG_STACK.ADD;
2383: App_Exception.Raise_Exception;
2384: END enrp_val_hpo_cic_prc;
2385: --
2386: -- Validate the HECS pay option, the course type and the citizenship cd.
2387: FUNCTION enrp_val_hpo_crs_cic(

Line 2499: App_Exception.Raise_Exception;

2495: WHEN OTHERS THEN
2496: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2497: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrpl_chk_dates_overlap');
2498: IGS_GE_MSG_STACK.ADD;
2499: App_Exception.Raise_Exception;
2500: END;
2501: END enrpl_chk_dates_overlap;
2502: FUNCTION enrpl_perform_validation (
2503: p_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE,

Line 2622: App_Exception.Raise_Exception;

2618: WHEN OTHERS THEN
2619: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2620: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrpl_perform_validation');
2621: IGS_GE_MSG_STACK.ADD;
2622: App_Exception.Raise_Exception;
2623: END;
2624: END enrpl_perform_validation;
2625: BEGIN
2626: p_message_name := null;

Line 2705: App_Exception.Raise_Exception;

2701: WHEN OTHERS THEN
2702: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2703: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_hpo_crs_cic');
2704: IGS_GE_MSG_STACK.ADD;
2705: App_Exception.Raise_Exception;
2706: END enrp_val_hpo_crs_cic;
2707: --
2708: -- Validate HECS payment option and the citizenship code.
2709: FUNCTION enrp_val_hpo_cic(

Line 2989: App_Exception.Raise_Exception;

2985: WHEN OTHERS THEN
2986: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2987: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_hpo_cic');
2988: IGS_GE_MSG_STACK.ADD;
2989: App_Exception.Raise_Exception;
2990: END enrp_val_hpo_cic;
2991: --
2992: -- Validate the HECS payment option closed indicator.
2993: FUNCTION enrp_val_hpo_closed(

Line 3026: App_Exception.Raise_Exception;

3022: WHEN OTHERS THEN
3023: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3024: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_hpo_closed');
3025: IGS_GE_MSG_STACK.ADD;
3026: App_Exception.Raise_Exception;
3027: END;
3028: END enrp_val_hpo_closed;
3029: --
3030: -- Validate HECS payment option, citizenship code and other statistics.

Line 3125: App_Exception.Raise_Exception;

3121: WHEN OTHERS THEN
3122: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3123: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrpl_chk_dates_overlap');
3124: IGS_GE_MSG_STACK.ADD;
3125: App_Exception.Raise_Exception;
3126: END;
3127: END enrpl_chk_dates_overlap;
3128: FUNCTION enrpl_perform_validation (
3129: lp_govt_hecs_payment_option

Line 3310: App_Exception.Raise_Exception;

3306: WHEN OTHERS THEN
3307: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3308: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrpl_perform_validation');
3309: IGS_GE_MSG_STACK.ADD;
3310: App_Exception.Raise_Exception;
3311: END enrpl_perform_validation;
3312: BEGIN
3313: p_message_name := null;
3314: IF p_person_id IS NULL THEN

Line 3416: App_Exception.Raise_Exception;

3412: WHEN OTHERS THEN
3413: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3414: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_hpo_cic_ps');
3415: IGS_GE_MSG_STACK.ADD;
3416: App_Exception.Raise_Exception;
3417: END enrp_val_hpo_cic_ps;
3418: --
3419: -- Validate that scho end date is in accordance with expiry restriction.
3420: FUNCTION enrp_val_scho_expire(

Line 3492: App_Exception.Raise_Exception;

3488: WHEN OTHERS THEN
3489: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3490: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_scho_expire');
3491: IGS_GE_MSG_STACK.ADD;
3492: App_Exception.Raise_Exception;
3493: END;
3494: END enrp_val_scho_expire;
3495: --
3496: --

Line 3529: App_Exception.Raise_Exception;

3525: WHEN OTHERS THEN
3526: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3527: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_tfn_crtfct');
3528: IGS_GE_MSG_STACK.ADD;
3529: App_Exception.Raise_Exception;
3530: END enrp_val_tfn_crtfct;
3531: --
3532: -- Validate the HECS option tax file number invalid date.
3533: FUNCTION enrp_val_tfn_invalid(

Line 3566: App_Exception.Raise_Exception;

3562: WHEN OTHERS THEN
3563: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3564: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCHO.enrp_val_tfn_invalid');
3565: IGS_GE_MSG_STACK.ADD;
3566: App_Exception.Raise_Exception;
3567: END enrp_val_tfn_invalid;
3568: END IGS_EN_VAL_SCHO;