60: EXCEPTION
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;
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
85: RETURN TRUE;
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;
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:
140: App_Exception.Raise_Exception;
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;
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:
202: EXCEPTION
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;
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
221: RETURN TRUE;
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;
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:
275: EXCEPTION
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;
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
293: RETURN TRUE;
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;
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:
330: END;
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;
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:
503:
504: igs_ge_msg_stack.delete_msg(l_msg_idx_start);
505: l_new_msg_count := l_new_msg_count -1;
506:
507: fnd_message.parse_encoded (l_msg_txt, l_app_nme, l_msg_nme);
508: fnd_message.set_encoded (l_msg_txt);
509: l_msg_txt := fnd_message.get;
510:
511: IF l_msg_txt IS NOT NULL THEN
504: igs_ge_msg_stack.delete_msg(l_msg_idx_start);
505: l_new_msg_count := l_new_msg_count -1;
506:
507: fnd_message.parse_encoded (l_msg_txt, l_app_nme, l_msg_nme);
508: fnd_message.set_encoded (l_msg_txt);
509: l_msg_txt := fnd_message.get;
510:
511: IF l_msg_txt IS NOT NULL THEN
512: admpl_del_ins_log_entry (
505: l_new_msg_count := l_new_msg_count -1;
506:
507: fnd_message.parse_encoded (l_msg_txt, l_app_nme, l_msg_nme);
508: fnd_message.set_encoded (l_msg_txt);
509: l_msg_txt := fnd_message.get;
510:
511: IF l_msg_txt IS NOT NULL THEN
512: admpl_del_ins_log_entry (
513: p_message_name => l_msg_nme,
596: App_Exception.Raise_Exception;
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;
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:
672: App_Exception.Raise_Exception;
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;
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:
891: App_Exception.Raise_Exception;
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;
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: --------------------------------------------------------------------------------
959: App_Exception.Raise_Exception;
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;
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: --------------------------------------------------------------------------------
1002: App_Exception.Raise_Exception;
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;
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: --------------------------------------------------------------------------------
1046: App_Exception.Raise_Exception;
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;
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: --------------------------------------------------------------------------------
1079: p_person_id,
1080: p_course_cd,
1081: v_message_name,
1082: v_default_msg) THEN
1083: FND_MESSAGE.SET_NAME('IGS',v_message_name);
1084: IGS_GE_MSG_STACK.ADD;
1085: RETURN FALSE;
1086: END IF;
1087: END IF;
1088: RETURN TRUE;
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;
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: --------------------------------------------------------------------------------
1152: App_Exception.Raise_Exception;
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;
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:
1322: App_Exception.Raise_Exception;
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;
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: --------------------------------------------------------------------------------
1395: App_Exception.Raise_Exception;
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;
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:
1465: App_Exception.Raise_Exception;
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;
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: --------------------------------------------------------------------------------
1538: App_Exception.Raise_Exception;
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;
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:
1608: App_Exception.Raise_Exception;
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;
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:
1735: App_Exception.Raise_Exception;
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;
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:
1834: App_Exception.Raise_Exception;
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;
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:
1903: App_Exception.Raise_Exception;
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;
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:
2175: p_key => v_key,
2176: p_s_log_type => cst_del_un_sca);
2177: ELSE
2178: IF l_entity_name IS NOT NULL THEN
2179: FND_MESSAGE.SET_NAME('IGS','IGS_AD_UNCONF_SCA_REC_LOCKED');
2180: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity_name);
2181: IGS_GE_MSG_STACK.ADD;
2182: END IF;
2183: extract_msg_from_stack(l_msg_at_index);
2176: p_s_log_type => cst_del_un_sca);
2177: ELSE
2178: IF l_entity_name IS NOT NULL THEN
2179: FND_MESSAGE.SET_NAME('IGS','IGS_AD_UNCONF_SCA_REC_LOCKED');
2180: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity_name);
2181: IGS_GE_MSG_STACK.ADD;
2182: END IF;
2183: extract_msg_from_stack(l_msg_at_index);
2184: END IF;
2186: CLOSE c_sca_upd;
2187: EXCEPTION
2188: WHEN e_resource_busy THEN
2189: l_entity_name := 'IGS_EN_STDNT_PS_ATT_ALL';
2190: FND_MESSAGE.SET_NAME('IGS','IGS_AD_UNCONF_SCA_REC_LOCKED');
2191: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity_name);
2192: IGS_GE_MSG_STACK.ADD;
2193: extract_msg_from_stack(l_msg_at_index);
2194: ROLLBACK TO sp_sca_del;
2187: EXCEPTION
2188: WHEN e_resource_busy THEN
2189: l_entity_name := 'IGS_EN_STDNT_PS_ATT_ALL';
2190: FND_MESSAGE.SET_NAME('IGS','IGS_AD_UNCONF_SCA_REC_LOCKED');
2191: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity_name);
2192: IGS_GE_MSG_STACK.ADD;
2193: extract_msg_from_stack(l_msg_at_index);
2194: ROLLBACK TO sp_sca_del;
2195: WHEN e_savepoint_lost THEN
2231: App_Exception.Raise_Exception;
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;
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:
2243: IS
2244:
2245: BEGIN
2246:
2247: FND_MESSAGE.SET_TOKEN('ADM',Token);
2248:
2249: END Set_Token;
2250:
2251: PROCEDURE Check_Mand_Person_Type