1: PACKAGE BODY IGS_AD_GEN_001 AS
2: /* $Header: IGSAD01B.pls 120.3 2005/09/22 05:26:17 appldev ship $ */
3: Function Admp_Del_Aa_Hist(
4: p_person_id IN NUMBER ,
5: p_admission_appl_number IN NUMBER ,
61: WHEN e_resource_busy_exception THEN
62: RETURN FALSE;
63: WHEN OTHERS THEN
64: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
65: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_del_if_not_locked');
66: IGS_GE_MSG_STACK.ADD;
67: App_Exception.Raise_Exception;
68: END admpl_del_if_not_locked;
69: BEGIN
86: END;
87: EXCEPTION
88: WHEN OTHERS THEN
89: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
90: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admp_del_aa_hist');
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END admp_del_aa_hist;
94:
141: END;
142: EXCEPTION
143: WHEN OTHERS THEN
144: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
145: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admp_del_acaiu_hist');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END admp_del_acaiu_hist;
149:
203: WHEN e_resource_busy_exception THEN
204: RETURN FALSE;
205: WHEN OTHERS THEN
206: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
207: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admp_del_if_not_locked');
208: IGS_GE_MSG_STACK.ADD;
209: App_Exception.Raise_Exception;
210: END admp_del_if_not_locked;
211: BEGIN
222: END;
223: EXCEPTION
224: WHEN OTHERS THEN
225: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
226: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admp_del_acai_hist');
227: IGS_GE_MSG_STACK.ADD;
228: App_Exception.Raise_Exception;
229: END admp_del_acai_hist;
230:
276: WHEN e_resource_busy_exception THEN
277: RETURN FALSE;
278: WHEN OTHERS THEN
279: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
280: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admp_del_if_not_locked');
281: IGS_GE_MSG_STACK.ADD;
282: App_Exception.Raise_Exception;
283: END admp_del_if_not_locked;
284: BEGIN
294: END;
295: EXCEPTION
296: WHEN OTHERS THEN
297: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
298: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admp_del_aca_hist');
299: IGS_GE_MSG_STACK.ADD;
300: App_Exception.Raise_Exception;
301: END admp_del_aca_hist;
302:
331: COMMIT;
332: EXCEPTION
333: WHEN OTHERS THEN
334: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
335: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_del_ins_log_entry');
336: IGS_GE_MSG_STACK.ADD;
337: App_Exception.Raise_Exception;
338: END admpl_del_ins_log_entry;
339:
597: END;
598: EXCEPTION
599: WHEN OTHERS THEN
600: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
601: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_del_sua');
602: IGS_GE_MSG_STACK.ADD;
603: App_Exception.Raise_Exception;
604: END admpl_del_sua;
605:
673: END;
674: EXCEPTION
675: WHEN OTHERS THEN
676: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
677: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_del_suah');
678: IGS_GE_MSG_STACK.ADD;
679: App_Exception.Raise_Exception;
680: END admpl_del_suah;
681:
892: END;
893: EXCEPTION
894: WHEN OTHERS THEN
895: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
896: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_del_susa');
897: IGS_GE_MSG_STACK.ADD;
898: App_Exception.Raise_Exception;
899: END admpl_del_susa;
900: --------------------------------------------------------------------------------
960: END;
961: EXCEPTION
962: WHEN OTHERS THEN
963: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
964: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_del_scho');
965: IGS_GE_MSG_STACK.ADD;
966: App_Exception.Raise_Exception;
967: END admpl_del_scho;
968: --------------------------------------------------------------------------------
1003: END;
1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1007: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_del_scae');
1008: IGS_GE_MSG_STACK.ADD;
1009: App_Exception.Raise_Exception;
1010: END admpl_del_scae;
1011: --------------------------------------------------------------------------------
1047: END;
1048: EXCEPTION
1049: WHEN OTHERS THEN
1050: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1051: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_del_scan');
1052: IGS_GE_MSG_STACK.ADD;
1053: App_Exception.Raise_Exception;
1054: END admpl_del_scan;
1055: --------------------------------------------------------------------------------
1089: END;
1090: EXCEPTION
1091: WHEN OTHERS THEN
1092: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1093: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_chk_as');
1094: IGS_GE_MSG_STACK.ADD;
1095: App_Exception.Raise_Exception;
1096: END admpl_chk_as;
1097: --------------------------------------------------------------------------------
1153: END;
1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1157: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_upd_re_candidature');
1158: IGS_GE_MSG_STACK.ADD;
1159: App_Exception.Raise_Exception;
1160: END admpl_upd_re_candidature;
1161:
1323: END;
1324: EXCEPTION
1325: WHEN OTHERS THEN
1326: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1327: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_del_gua');
1328: IGS_GE_MSG_STACK.ADD;
1329: App_Exception.Raise_Exception;
1330: END admpl_del_gua;
1331: --------------------------------------------------------------------------------
1396: END;
1397: EXCEPTION
1398: WHEN OTHERS THEN
1399: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1400: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_del_gsa');
1401: IGS_GE_MSG_STACK.ADD;
1402: App_Exception.Raise_Exception;
1403: END admpl_del_gsa;
1404:
1466: END;
1467: EXCEPTION
1468: WHEN OTHERS THEN
1469: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1470: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_del_psaa');
1471: IGS_GE_MSG_STACK.ADD;
1472: App_Exception.Raise_Exception;
1473: END admpl_del_psaa;
1474: --------------------------------------------------------------------------------
1539: END;
1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1543: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_del_pssr');
1544: IGS_GE_MSG_STACK.ADD;
1545: App_Exception.Raise_Exception;
1546: END admpl_del_pssr;
1547:
1609: END;
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1613: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_del_esaa');
1614: IGS_GE_MSG_STACK.ADD;
1615: App_Exception.Raise_Exception;
1616: END admpl_del_esaa;
1617:
1736: END;
1737: EXCEPTION
1738: WHEN OTHERS THEN
1739: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1740: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_del_hssa');
1741: IGS_GE_MSG_STACK.ADD;
1742: App_Exception.Raise_Exception;
1743: END admpl_del_hssa;
1744:
1835: END;
1836: EXCEPTION
1837: WHEN OTHERS THEN
1838: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1839: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_upd_pr_rule_appl');
1840: IGS_GE_MSG_STACK.ADD;
1841: App_Exception.Raise_Exception;
1842: END admpl_upd_pr_rule_appl;
1843:
1904: END;
1905: EXCEPTION
1906: WHEN OTHERS THEN
1907: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1908: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admpl_del_hssc');
1909: IGS_GE_MSG_STACK.ADD;
1910: App_Exception.Raise_Exception;
1911: END admpl_del_hssc;
1912:
2232: END;
2233: EXCEPTION
2234: WHEN OTHERS THEN
2235: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2236: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_001.admp_del_sca_unconf');
2237: IGS_GE_MSG_STACK.ADD;
2238: App_Exception.Raise_Exception;
2239: END admp_del_sca_unconf;
2240:
2362: END IF;
2363: END get_user_form_name;
2364:
2365:
2366: END IGS_AD_GEN_001;