DBA Data[Home] [Help]

APPS.IGS_AD_GEN_001 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_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 (

Line 92: App_Exception.Raise_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:
95: Function Admp_Del_Acaiu_Hist(
96: p_person_id IN NUMBER ,

Line 140: App_Exception.Raise_Exception;

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');

Line 147: App_Exception.Raise_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:
150: Function Admp_Del_Acai_Hist(
151: p_person_id IN NUMBER ,

Line 209: App_Exception.Raise_Exception;

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 (

Line 228: App_Exception.Raise_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:
231: Function Admp_Del_Aca_Hist(
232: p_person_id IN NUMBER ,

Line 282: App_Exception.Raise_Exception;

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 (

Line 300: App_Exception.Raise_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:
303: --removed the Function Admp_Del_Eap_Cepi (bug 2664699) rghosh
304:

Line 337: App_Exception.Raise_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:
340: Procedure Admp_Del_Sca_Unconf(
341: p_log_creation_dt OUT NOCOPY DATE )

Line 596: App_Exception.Raise_Exception;

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');

Line 603: App_Exception.Raise_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:
606: --------------------------------------------------------------------------------
607: -- ADMPL_DEL_SUAH ---------------------------------------------------------------

Line 672: App_Exception.Raise_Exception;

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');

Line 679: App_Exception.Raise_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:
682: --------------------------------------------------------------------------------
683: -- ADMPL_DEL_SUSA --------------------------------------------------------------

Line 891: App_Exception.Raise_Exception;

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');

Line 898: App_Exception.Raise_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: --------------------------------------------------------------------------------
901: -- ADMPL_DEL_SCHO --------------------------------------------------------------
902: --------------------------------------------------------------------------------

Line 959: App_Exception.Raise_Exception;

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');

Line 966: App_Exception.Raise_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: --------------------------------------------------------------------------------
969: -- ADMPL_DEL_SCAE --------------------------------------------------------------
970: --------------------------------------------------------------------------------

Line 1002: App_Exception.Raise_Exception;

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');

Line 1009: App_Exception.Raise_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: --------------------------------------------------------------------------------
1012: -- ADMPL_DEL_SCAN --------------------------------------------------------------
1013: --------------------------------------------------------------------------------

Line 1046: App_Exception.Raise_Exception;

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');

Line 1053: App_Exception.Raise_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: --------------------------------------------------------------------------------
1056: -- ADMPL_CHK_AS ----------------------------------------------------------------
1057: --------------------------------------------------------------------------------

Line 1095: App_Exception.Raise_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: --------------------------------------------------------------------------------
1098: -- ADMPL_UPD_RE_CANDIDATURE ------------------------------------------------------------
1099: ----

Line 1152: App_Exception.Raise_Exception;

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');

Line 1159: App_Exception.Raise_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:
1162: --------------------------------------------------------------------------------
1163: -- ADMPL_DEL_GUA ---------------------------------------------------------------

Line 1322: App_Exception.Raise_Exception;

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');

Line 1329: App_Exception.Raise_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: --------------------------------------------------------------------------------
1332: -- ADMPL_DEL_GSA ---------------------------------------------------------------
1333: --Who When What

Line 1395: App_Exception.Raise_Exception;

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');

Line 1402: App_Exception.Raise_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:
1405: FUNCTION admpl_del_psaa(
1406: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

Line 1465: App_Exception.Raise_Exception;

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');

Line 1472: App_Exception.Raise_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: --------------------------------------------------------------------------------
1475: -- ADMPL_DEL_PSSR ---------------------------------------------------------------
1476: --Who When What

Line 1538: App_Exception.Raise_Exception;

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');

Line 1545: App_Exception.Raise_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:
1548: --------------------------------------------------------------------------------
1549: -- ADMPL_DEL_ESAA ---------------------------------------------------------------

Line 1608: App_Exception.Raise_Exception;

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');

Line 1615: App_Exception.Raise_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:
1618: --------------------------------------------------------------------------------
1619: -- ADMPL_DEL_HSSA ---------------------------------------------------------------

Line 1735: App_Exception.Raise_Exception;

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');

Line 1742: App_Exception.Raise_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:
1745: --------------------------------------------------------------------------------
1746: -- ADMPL_UPD_PR_RULE_APPL ---------------------------------------------------------------

Line 1834: App_Exception.Raise_Exception;

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');

Line 1841: App_Exception.Raise_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:
1844: --------------------------------------------------------------------------------
1845: -- ADMPL_DEL_HSSC ---------------------------------------------------------------

Line 1903: App_Exception.Raise_Exception;

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');

Line 1910: App_Exception.Raise_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:
1913: BEGIN
1914: -- Create log

Line 2231: App_Exception.Raise_Exception;

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');

Line 2238: App_Exception.Raise_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:
2241: PROCEDURE Set_Token(Token Varchar2)
2242: