DBA Data[Home] [Help]

APPS.IGS_AD_GEN_002 dependencies on APP_EXCEPTION

Line 126: App_Exception.Raise_Exception;

122: WHEN OTHERS THEN
123: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
124: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_chk_non_num');
125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: END admpl_chk_non_num;
128: ---------------
129: ---------------
130: FUNCTION admpl_strip_non_alpha (

Line 158: App_Exception.Raise_Exception;

154: WHEN OTHERS THEN
155: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
156: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_strip_non_alpha');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END admpl_strip_non_alpha;
160: ---------------
161: ---------------
162: FUNCTION admpl_strip_spaces (

Line 186: App_Exception.Raise_Exception;

182: WHEN OTHERS THEN
183: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
184: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_strip_spaces');
185: IGS_GE_MSG_STACK.ADD;
186: App_Exception.Raise_Exception;
187: END admpl_strip_spaces;
188: ---------------
189: ---------------
190: PROCEDURE admpl_store_matched_table (

Line 271: App_Exception.Raise_Exception;

267: WHEN OTHERS THEN
268: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
269: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_store_matched_table');
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END admpl_store_matched_table;
273: ---------------
274: ---------------
275: PROCEDURE admpl_match_criteria11 (

Line 304: App_Exception.Raise_Exception;

300: WHEN OTHERS THEN
301: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
302: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria11');
303: IGS_GE_MSG_STACK.ADD;
304: App_Exception.Raise_Exception;
305: END admpl_match_criteria11;
306: ---------------
307: ---------------
308: PROCEDURE admpl_match_criteria10 (

Line 334: App_Exception.Raise_Exception;

330: WHEN OTHERS THEN
331: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
332: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria10');
333: IGS_GE_MSG_STACK.ADD;
334: App_Exception.Raise_Exception;
335: END admpl_match_criteria10;
336: ---------------
337: ---------------
338: PROCEDURE admpl_match_criteria9 (

Line 394: App_Exception.Raise_Exception;

390: WHEN OTHERS THEN
391: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
392: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria9');
393: IGS_GE_MSG_STACK.ADD;
394: App_Exception.Raise_Exception;
395: END admpl_match_criteria9;
396: ---------------
397: ---------------
398: PROCEDURE admpl_match_criteria8 (

Line 436: App_Exception.Raise_Exception;

432: WHEN OTHERS THEN
433: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
434: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria8');
435: IGS_GE_MSG_STACK.ADD;
436: App_Exception.Raise_Exception;
437: END admpl_match_criteria8;
438: ---------------
439: ---------------
440: PROCEDURE admpl_match_criteria7 (

Line 497: App_Exception.Raise_Exception;

493: WHEN OTHERS THEN
494: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
495: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria7');
496: IGS_GE_MSG_STACK.ADD;
497: App_Exception.Raise_Exception;
498: END admpl_match_criteria7;
499: ---------------
500: ---------------
501: PROCEDURE admpl_match_criteria6 (

Line 542: App_Exception.Raise_Exception;

538: WHEN OTHERS THEN
539: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
540: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria6');
541: IGS_GE_MSG_STACK.ADD;
542: App_Exception.Raise_Exception;
543: END admpl_match_criteria6;
544: ---------------
545: ---------------
546: PROCEDURE admpl_match_criteria5 (

Line 576: App_Exception.Raise_Exception;

572: WHEN OTHERS THEN
573: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
574: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria5');
575: IGS_GE_MSG_STACK.ADD;
576: App_Exception.Raise_Exception;
577: END admpl_match_criteria5;
578: ---------------
579: ---------------
580: PROCEDURE admpl_match_criteria4a (

Line 612: App_Exception.Raise_Exception;

608: WHEN OTHERS THEN
609: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
610: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria4a');
611: IGS_GE_MSG_STACK.ADD;
612: App_Exception.Raise_Exception;
613: END admpl_match_criteria4a;
614: ---------------
615: ---------------
616: PROCEDURE admpl_match_criteria4 (

Line 680: App_Exception.Raise_Exception;

676: WHEN OTHERS THEN
677: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
678: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria4');
679: IGS_GE_MSG_STACK.ADD;
680: App_Exception.Raise_Exception;
681: END admpl_match_criteria4;
682: ---------------
683: ---------------
684: PROCEDURE admpl_match_criteria3 (

Line 731: App_Exception.Raise_Exception;

727: WHEN OTHERS THEN
728: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
729: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria3');
730: IGS_GE_MSG_STACK.ADD;
731: App_Exception.Raise_Exception;
732: END admpl_match_criteria3;
733: ---------------
734: ---------------
735: PROCEDURE admpl_match_criteria2 (

Line 802: App_Exception.Raise_Exception;

798: WHEN OTHERS THEN
799: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
800: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria2');
801: IGS_GE_MSG_STACK.ADD;
802: App_Exception.Raise_Exception;
803: END admpl_match_criteria2;
804: ---------------
805: ---------------
806: PROCEDURE admpl_match_criteria1 (

Line 854: App_Exception.Raise_Exception;

850: WHEN OTHERS THEN
851: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
852: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_criteria1');
853: IGS_GE_MSG_STACK.ADD;
854: App_Exception.Raise_Exception;
855: END admpl_match_criteria1;
856: ---------------
857: ---------------
858: PROCEDURE admpl_match_any_name (

Line 911: App_Exception.Raise_Exception;

907: WHEN OTHERS THEN
908: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
909: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_any_name');
910: IGS_GE_MSG_STACK.ADD;
911: App_Exception.Raise_Exception;
912: END admpl_match_any_name;
913: ---------------
914: ---------------
915: PROCEDURE admpl_match_loose_name (

Line 953: App_Exception.Raise_Exception;

949: WHEN OTHERS THEN
950: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
951: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_loose_name');
952: IGS_GE_MSG_STACK.ADD;
953: App_Exception.Raise_Exception;
954: END admpl_match_loose_name;
955: ---------------
956: ---------------
957: PROCEDURE admpl_match_exact_name (

Line 978: App_Exception.Raise_Exception;

974: WHEN OTHERS THEN
975: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
976: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_exact_name');
977: IGS_GE_MSG_STACK.ADD;
978: App_Exception.Raise_Exception;
979: END admpl_match_exact_name;
980: ---------------
981: ---------------
982: PROCEDURE admpl_match_any_id (

Line 1043: App_Exception.Raise_Exception;

1039: WHEN OTHERS THEN
1040: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1041: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_any_id');
1042: IGS_GE_MSG_STACK.ADD;
1043: App_Exception.Raise_Exception;
1044: END admpl_match_any_id;
1045: ---------------
1046: ---------------
1047: PROCEDURE admpl_match_exact_id (

Line 1080: App_Exception.Raise_Exception;

1076: WHEN OTHERS THEN
1077: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1078: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_exact_id');
1079: IGS_GE_MSG_STACK.ADD;
1080: App_Exception.Raise_Exception;
1081: END admpl_match_exact_id;
1082: ---------------
1083: ---------------
1084: PROCEDURE admpl_match_standard_6 (

Line 1138: App_Exception.Raise_Exception;

1134: WHEN OTHERS THEN
1135: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1136: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_standard_6');
1137: IGS_GE_MSG_STACK.ADD;
1138: App_Exception.Raise_Exception;
1139: END admpl_match_standard_6;
1140: PROCEDURE admpl_match_standard (
1141: p_convert_id IN IGS_PE_PERSON.person_id%TYPE,
1142: p_convert_family_name IN IGS_PE_PERSON.surname%TYPE,

Line 1229: App_Exception.Raise_Exception;

1225: WHEN OTHERS THEN
1226: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1227: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_standard');
1228: IGS_GE_MSG_STACK.ADD;
1229: App_Exception.Raise_Exception;
1230: END admpl_match_standard;
1231: ---------------
1232: ---------------
1233: PROCEDURE admpl_write_course_header (

Line 1281: App_Exception.Raise_Exception;

1277: WHEN OTHERS THEN
1278: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1279: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_write_course_header');
1280: IGS_GE_MSG_STACK.ADD;
1281: App_Exception.Raise_Exception;
1282: END admpl_write_course_header;
1283: PROCEDURE admpl_write_student_details (
1284: p_matched_id IN r_matched_id_rec.person_id%TYPE,
1285: p_basis_of_match IN r_matched_id_rec.basis_of_match%TYPE,

Line 1790: App_Exception.Raise_Exception;

1786: WHEN OTHERS THEN
1787: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1788: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_write_student_details');
1789: IGS_GE_MSG_STACK.ADD;
1790: App_Exception.Raise_Exception;
1791: END admpl_write_student_details;
1792: FUNCTION admpl_prc_previous_header (
1793: p_previous_name_records_cnt IN NUMBER,
1794: p_number_of_matches IN OUT NOCOPY NUMBER)

Line 2051: App_Exception.Raise_Exception;

2047: WHEN OTHERS THEN
2048: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2049: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_prc_previous_header');
2050: IGS_GE_MSG_STACK.ADD;
2051: App_Exception.Raise_Exception;
2052: END admpl_prc_previous_header;
2053: ---------------
2054: ---------------
2055: PROCEDURE admpl_store_rec (

Line 2096: App_Exception.Raise_Exception;

2092: WHEN OTHERS THEN
2093: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2094: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_store_rec');
2095: IGS_GE_MSG_STACK.ADD;
2096: App_Exception.Raise_Exception;
2097: END admpl_store_rec;
2098: ---------------
2099: ---------------
2100: PROCEDURE admpl_read_rec (

Line 2139: App_Exception.Raise_Exception;

2135: WHEN OTHERS THEN
2136: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2137: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_read_rec');
2138: IGS_GE_MSG_STACK.ADD;
2139: App_Exception.Raise_Exception;
2140: END admpl_read_rec;
2141: ---------------
2142: ---------------
2143: BEGIN

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_GEN_002.admp_ext_tac_arts');
2255: IGS_GE_MSG_STACK.ADD;
2256: App_Exception.Raise_Exception;
2257: END admp_ext_tac_arts;
2258: Procedure Admp_Ext_Vtac_Return(
2259: errbuf OUT NOCOPY VARCHAR2,
2260: retcode OUT NOCOPY NUMBER,

Line 2343: App_Exception.Raise_Exception;

2339: RETURN FALSE;
2340: WHEN UTL_FILE.READ_ERROR THEN
2341: Fnd_Message.Set_Name('IGS','IGS_GE_UNABLE_READ_FILE');
2342: IGS_GE_MSG_STACK.ADD;
2343: App_Exception.Raise_Exception;
2344: RETURN FALSE;
2345: END admpl_read_input;
2346: -- Define a procedure for writing the output file.
2347: -- The output file format is the same

Line 2381: App_Exception.Raise_Exception;

2377: p_acad_ci_sequence_number IS NULL OR
2378: p_input_file IS NULL) THEN
2379: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
2380: IGS_GE_MSG_STACK.ADD;
2381: App_Exception.Raise_Exception;
2382: END IF;
2383: fnd_profile.get('IGS_IN_FILE_PATH',v_tmp_dir);
2384: --Open input file
2385: BEGIN

Line 2391: App_Exception.Raise_Exception;

2387: EXCEPTION
2388: WHEN UTL_FILE.INVALID_OPERATION THEN
2389: Fnd_Message.Set_Name('IGS','IGS_GE_UNABLE_READ_FILE');
2390: IGS_GE_MSG_STACK.ADD;
2391: App_Exception.Raise_Exception;
2392: WHEN UTL_FILE.INVALID_PATH THEN
2393: Fnd_Message.Set_Name('IGS','IGS_GE_UNABLE_READ_FILE');
2394: IGS_GE_MSG_STACK.ADD;
2395: App_Exception.Raise_Exception;

Line 2395: App_Exception.Raise_Exception;

2391: App_Exception.Raise_Exception;
2392: WHEN UTL_FILE.INVALID_PATH THEN
2393: Fnd_Message.Set_Name('IGS','IGS_GE_UNABLE_READ_FILE');
2394: IGS_GE_MSG_STACK.ADD;
2395: App_Exception.Raise_Exception;
2396: END;
2397: WHILE admpl_read_input LOOP
2398: IF (v_vtac_number IS NULL OR
2399: v_vtac_course_cd IS NULL) THEN

Line 2522: App_Exception.Raise_Exception;

2518: WHEN OTHERS THEN
2519: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2520: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_aal_sent_dt');
2521: IGS_GE_MSG_STACK.ADD;
2522: App_Exception.Raise_Exception;
2523: END admp_get_aal_sent_dt;
2524: Function Admp_Get_Aa_Aas(
2525: p_person_id IN NUMBER ,
2526: p_admission_appl_number IN NUMBER ,

Line 2682: App_Exception.Raise_Exception;

2678: WHEN OTHERS THEN
2679: IF c_aca%ISOPEN THEN
2680: CLOSE c_aca;
2681: END IF;
2682: App_Exception.Raise_Exception;
2683: END;
2684: EXCEPTION
2685: WHEN OTHERS THEN
2686: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 2689: App_Exception.Raise_Exception;

2685: WHEN OTHERS THEN
2686: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2687: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_aa_aas');
2688: IGS_GE_MSG_STACK.ADD;
2689: App_Exception.Raise_Exception;
2690: END admp_get_aa_aas;
2691: Procedure Admp_Get_Aa_Created(
2692: p_person_id IN NUMBER ,
2693: p_admission_appl_number IN NUMBER ,

Line 2738: App_Exception.Raise_Exception;

2734: WHEN OTHERS THEN
2735: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2736: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_aa_created');
2737: IGS_GE_MSG_STACK.ADD;
2738: App_Exception.Raise_Exception;
2739: END admp_get_aa_created;
2740: Procedure Admp_Get_Aa_Dtl(
2741: p_person_id IN NUMBER ,
2742: p_admission_appl_number IN NUMBER ,

Line 2817: App_Exception.Raise_Exception;

2813: WHEN OTHERS THEN
2814: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2815: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_aa_dtl');
2816: IGS_GE_MSG_STACK.ADD;
2817: App_Exception.Raise_Exception;
2818: END admp_get_aa_dtl;
2819: Function Admp_Get_Acai_Acadcd(
2820: p_person_id IN NUMBER ,
2821: p_admission_appl_number IN NUMBER ,

Line 2912: App_Exception.Raise_Exception;

2908: WHEN OTHERS THEN
2909: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2910: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admp_get_acai_aos_dt');
2911: IGS_GE_MSG_STACK.ADD;
2912: App_Exception.Raise_Exception;
2913: END admp_get_acai_aos_dt;
2914: Procedure ADMS_EXT_TAC_ARTS (
2915: errbuf out NOCOPY varchar2,
2916: retcode out NOCOPY number,

Line 3159: app_exception.raise_exception; -- application instance is withdrawn

3155:
3156: IF NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(l_appl_inst_status),'-1') = cst_withdrawn THEN
3157: fnd_message.set_name('IGS','IGS_AD_APPL_INST_WITHD');
3158: igs_ge_msg_stack.add;
3159: app_exception.raise_exception; -- application instance is withdrawn
3160: END IF;
3161:
3162: IF Is_App_Inst_Complete( p_person_id,
3163: p_admission_appl_number,

Line 3179: app_exception.raise_exception;

3175: (l_def_term_adm_appl_num IS NOT NULL OR l_def_appl_sequence_num IS NOT NULL)
3176: THEN
3177: fnd_message.set_name('IGS','IGS_AD_APPL_INST_COMPL');
3178: igs_ge_msg_stack.add;
3179: app_exception.raise_exception;
3180: END IF;
3181:
3182: END IF;
3183: -------end APADEGAL - ADTD001 RE-OPEN BUILD- IGS.M

Line 3208: app_exception.raise_exception;

3204: fnd_message.set_name('IGS','IGS_AD_APPL_INST_COMPL');
3205: END IF;
3206:
3207: igs_ge_msg_stack.add;
3208: app_exception.raise_exception;
3209: END IF;
3210: ELSE
3211: IF IGS_AD_GEN_007.ADMP_GET_SAAS(l_adm_appl_status_new) = cst_withdrawn THEN
3212: fnd_message.set_name('IGS','IGS_AD_CANNOT_CHG_APPL_DTL');

Line 3214: app_exception.raise_exception;

3210: ELSE
3211: IF IGS_AD_GEN_007.ADMP_GET_SAAS(l_adm_appl_status_new) = cst_withdrawn THEN
3212: fnd_message.set_name('IGS','IGS_AD_CANNOT_CHG_APPL_DTL');
3213: igs_ge_msg_stack.add;
3214: app_exception.raise_exception;
3215: END IF;
3216: END IF;
3217:
3218: END check_adm_appl_inst_stat;

Line 3325: App_Exception.Raise_Exception;

3321: WHEN OTHERS THEN
3322: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3323: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.res_pending_fee_status');
3324: IGS_GE_MSG_STACK.ADD;
3325: App_Exception.Raise_Exception;
3326: END res_pending_fee_status;
3327:
3328: PROCEDURE Admp_resub_inst(
3329: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

Line 3898: App_Exception.Raise_Exception;

3894: )
3895: THEN
3896:
3897:
3898: App_Exception.Raise_Exception;
3899: ELSE
3900:
3901: -- Re-open the related Application Person Types - nullify the 'End'fields.
3902: