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
70: p_message_name := null;
71: IF admpl_del_if_not_locked (
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:
95: Function Admp_Del_Acaiu_Hist(
96: p_person_id IN NUMBER ,
136: WHEN OTHERS THEN
137: IF c_acaiuh%ISOPEN THEN
138: CLOSE c_acaiuh;
139: END IF;
140: App_Exception.Raise_Exception;
141: END;
142: EXCEPTION
143: WHEN OTHERS THEN
144: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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:
150: Function Admp_Del_Acai_Hist(
151: p_person_id IN NUMBER ,
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
212: p_message_name := null;
213: IF(admp_del_if_not_locked (
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:
231: Function Admp_Del_Aca_Hist(
232: p_person_id IN NUMBER ,
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
285: p_message_name := null;
286: IF(admp_del_if_not_locked (
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:
303: --removed the Function Admp_Del_Eap_Cepi (bug 2664699) rghosh
304:
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:
340: Procedure Admp_Del_Sca_Unconf(
341: p_log_creation_dt OUT NOCOPY DATE )
592: END IF;
593: IF c_sua_del%ISOPEN THEN
594: CLOSE c_sua_del;
595: END IF;
596: App_Exception.Raise_Exception;
597: END;
598: EXCEPTION
599: WHEN OTHERS THEN
600: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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:
606: --------------------------------------------------------------------------------
607: -- ADMPL_DEL_SUAH ---------------------------------------------------------------
668: END IF;
669: IF c_suah_del%ISOPEN THEN
670: CLOSE c_suah_del;
671: END IF;
672: App_Exception.Raise_Exception;
673: END;
674: EXCEPTION
675: WHEN OTHERS THEN
676: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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:
682: --------------------------------------------------------------------------------
683: -- ADMPL_DEL_SUSA --------------------------------------------------------------
887: END IF;
888: -- Must reset database trigger validation if been turned off
889: IGS_GE_MNT_SDTT.genp_del_sdtt(
890: 'ADMP_DEL_SCA_UNCONF');
891: App_Exception.Raise_Exception;
892: END;
893: EXCEPTION
894: WHEN OTHERS THEN
895: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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: --------------------------------------------------------------------------------
901: -- ADMPL_DEL_SCHO --------------------------------------------------------------
902: --------------------------------------------------------------------------------
955: END IF;
956: IF c_scho_del%ISOPEN THEN
957: CLOSE c_scho_del;
958: END IF;
959: App_Exception.Raise_Exception;
960: END;
961: EXCEPTION
962: WHEN OTHERS THEN
963: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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: --------------------------------------------------------------------------------
969: -- ADMPL_DEL_SCAE --------------------------------------------------------------
970: --------------------------------------------------------------------------------
998: WHEN OTHERS THEN
999: IF c_scae%ISOPEN THEN
1000: CLOSE c_scae;
1001: END IF;
1002: App_Exception.Raise_Exception;
1003: END;
1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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: --------------------------------------------------------------------------------
1012: -- ADMPL_DEL_SCAN --------------------------------------------------------------
1013: --------------------------------------------------------------------------------
1042: WHEN OTHERS THEN
1043: IF c_scan%ISOPEN THEN
1044: CLOSE c_scan;
1045: END IF;
1046: App_Exception.Raise_Exception;
1047: END;
1048: EXCEPTION
1049: WHEN OTHERS THEN
1050: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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: --------------------------------------------------------------------------------
1056: -- ADMPL_CHK_AS ----------------------------------------------------------------
1057: --------------------------------------------------------------------------------
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: --------------------------------------------------------------------------------
1098: -- ADMPL_UPD_RE_CANDIDATURE ------------------------------------------------------------
1099: ----
1148: WHEN OTHERS THEN
1149: IF c_ca%ISOPEN THEN
1150: CLOSE c_ca;
1151: END IF;
1152: App_Exception.Raise_Exception;
1153: END;
1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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:
1162: --------------------------------------------------------------------------------
1163: -- ADMPL_DEL_GUA ---------------------------------------------------------------
1318: END IF;
1319: IF c_gac_del%ISOPEN THEN
1320: CLOSE c_gac_del;
1321: END IF;
1322: App_Exception.Raise_Exception;
1323: END;
1324: EXCEPTION
1325: WHEN OTHERS THEN
1326: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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: --------------------------------------------------------------------------------
1332: -- ADMPL_DEL_GSA ---------------------------------------------------------------
1333: --Who When What
1391: END IF;
1392: IF c_gsa_del%ISOPEN THEN
1393: CLOSE c_gsa_del;
1394: END IF;
1395: App_Exception.Raise_Exception;
1396: END;
1397: EXCEPTION
1398: WHEN OTHERS THEN
1399: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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:
1405: FUNCTION admpl_del_psaa(
1406: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1461: END IF;
1462: IF c_psaa_del%ISOPEN THEN
1463: CLOSE c_psaa_del;
1464: END IF;
1465: App_Exception.Raise_Exception;
1466: END;
1467: EXCEPTION
1468: WHEN OTHERS THEN
1469: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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: --------------------------------------------------------------------------------
1475: -- ADMPL_DEL_PSSR ---------------------------------------------------------------
1476: --Who When What
1534: END IF;
1535: IF c_pssr_del%ISOPEN THEN
1536: CLOSE c_pssr_del;
1537: END IF;
1538: App_Exception.Raise_Exception;
1539: END;
1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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:
1548: --------------------------------------------------------------------------------
1549: -- ADMPL_DEL_ESAA ---------------------------------------------------------------
1604: END IF;
1605: IF c_esaa_del%ISOPEN THEN
1606: CLOSE c_esaa_del;
1607: END IF;
1608: App_Exception.Raise_Exception;
1609: END;
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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:
1618: --------------------------------------------------------------------------------
1619: -- ADMPL_DEL_HSSA ---------------------------------------------------------------
1731: END IF;
1732: IF c_hssua_del%ISOPEN THEN
1733: CLOSE c_hssua_del;
1734: END IF;
1735: App_Exception.Raise_Exception;
1736: END;
1737: EXCEPTION
1738: WHEN OTHERS THEN
1739: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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:
1745: --------------------------------------------------------------------------------
1746: -- ADMPL_UPD_PR_RULE_APPL ---------------------------------------------------------------
1830: END IF;
1831: IF c_pra_del%ISOPEN THEN
1832: CLOSE c_pra_del;
1833: END IF;
1834: App_Exception.Raise_Exception;
1835: END;
1836: EXCEPTION
1837: WHEN OTHERS THEN
1838: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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:
1844: --------------------------------------------------------------------------------
1845: -- ADMPL_DEL_HSSC ---------------------------------------------------------------
1899: END IF;
1900: IF c_hssc_del%ISOPEN THEN
1901: CLOSE c_hssc_del;
1902: END IF;
1903: App_Exception.Raise_Exception;
1904: END;
1905: EXCEPTION
1906: WHEN OTHERS THEN
1907: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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:
1913: BEGIN
1914: -- Create log
2227: END IF;
2228: IF c_cir%ISOPEN THEN
2229: CLOSE c_cir;
2230: END IF;
2231: App_Exception.Raise_Exception;
2232: END;
2233: EXCEPTION
2234: WHEN OTHERS THEN
2235: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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:
2241: PROCEDURE Set_Token(Token Varchar2)
2242: