eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_SS_GEN_001 dependencies on IGS_GE_MSG_STACK

Line 148: l_msg_index := IGS_GE_MSG_STACK.count_msg;

144: BEGIN
145: logHeader('transfer_data', 'S');
146: -- Set the G_CALLED_FROM to 'S' to skip the commit happening in Tracking item completion job
147: IGS_AD_TI_COMP.G_CALLED_FROM := 'S';
148: l_msg_index := IGS_GE_MSG_STACK.count_msg;
149:
150: OPEN c_adm_appl;
151: FETCH c_adm_appl
152: INTO c_adm_appl_rec;

Line 177: IGS_GE_MSG_STACK.ADD;

173: ELSE
174: --Program import failed, Set the message and return, in calling proc , check for ret_stat , if 'E' set message sent from here
175: IF FND_MSG_PUB.Count_Msg < 1 AND l_message_name IS NOT NULL THEN
176: FND_MESSAGE.SET_NAME('IGS', l_message_name);
177: IGS_GE_MSG_STACK.ADD;
178: END IF;
179: x_message_name := l_message_name;
180: x_return_status := l_return_status;
181: RETURN;

Line 187: IGS_GE_MSG_STACK.ADD;

183: ELSE
184: --Application import failed, Set the message and return, in calling proc , check for ret_stat , if 'E' set message sent from here
185: IF FND_MSG_PUB.Count_Msg < 1 AND l_message_name IS NOT NULL THEN
186: FND_MESSAGE.SET_NAME('IGS', l_message_name);
187: IGS_GE_MSG_STACK.ADD;
188: END IF;
189: x_message_name := l_message_name;
190: x_return_status := l_return_status;
191: RETURN;

Line 215: IGS_GE_MSG_STACK.ADD;

211: IF l_message_name <> 'IGS_SC_POLICY_EXCEPTION' AND l_message_name <> 'IGS_GE_UNHANDLED_EXP' AND
212: FND_MSG_PUB.Count_Msg < 1 THEN
213: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
214: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.transfer_data -'||SQLERRM);
215: IGS_GE_MSG_STACK.ADD;
216: x_message_name := 'IGS_GE_UNHANDLED_EXP';
217: END IF;
218: App_Exception.Raise_Exception;
219: -- App_Exception.Raise_Exception; x_return_status is an OUT NOCOPY parameter and will not show the value set, for it if the exception is raised. So commenting out NOCOPY Bug# 2224624

Line 333: IGS_GE_MSG_STACK.ADD;

329: IF l_message_name <> 'IGS_SC_POLICY_EXCEPTION' AND l_message_name <> 'IGS_GE_UNHANDLED_EXP' AND
330: FND_MSG_PUB.Count_Msg < 1 THEN
331: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
332: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.create_application -'||SQLERRM);
333: IGS_GE_MSG_STACK.ADD;
334: p_message_name := 'IGS_GE_UNHANDLED_EXP';
335: END IF;
336: App_Exception.Raise_Exception;
337:

Line 638: IGS_GE_MSG_STACK.ADD;

634: IF l_message_name <> 'IGS_SC_POLICY_EXCEPTION' AND l_message_name <> 'IGS_GE_UNHANDLED_EXP' AND
635: FND_MSG_PUB.Count_Msg < 1 THEN
636: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
637: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.create_program -'||SQLERRM);
638: IGS_GE_MSG_STACK.ADD;
639: p_message_name := 'IGS_GE_UNHANDLED_EXP';
640: END IF;
641: App_Exception.Raise_Exception;
642:

Line 725: IGS_GE_MSG_STACK.ADD;

721: 'S');
722: IF FND_MSG_PUB.Count_Msg < 1 THEN
723: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
724: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_person_type -'||SQLERRM);
725: IGS_GE_MSG_STACK.ADD;
726: END IF;
727: App_Exception.Raise_Exception;
728: END update_person_type;
729:

Line 812: IGS_GE_MSG_STACK.ADD;

808: 'S');
809: IF FND_MSG_PUB.Count_Msg < 1 THEN
810: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
811: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_unit_set_dtls -'||SQLERRM);
812: IGS_GE_MSG_STACK.ADD;
813: END IF;
814:
815: App_Exception.Raise_Exception;
816: END insert_unit_set_dtls;

Line 876: IGS_GE_MSG_STACK.ADD;

872: 'S');
873: IF FND_MSG_PUB.Count_Msg < 1 THEN
874: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
875: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_acad_interest -'||SQLERRM);
876: IGS_GE_MSG_STACK.ADD;
877: END IF;
878: App_Exception.Raise_Exception;
879: END insert_acad_interest;
880:

Line 955: IGS_GE_MSG_STACK.ADD;

951: 'S');
952: IF FND_MSG_PUB.Count_Msg < 1 THEN
953: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
954: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_applicant_intent -'||SQLERRM);
955: IGS_GE_MSG_STACK.ADD;
956: END IF;
957: App_Exception.Raise_Exception;
958: END insert_applicant_intent;
959:

Line 1014: IGS_GE_MSG_STACK.ADD;

1010: 'S');
1011: IF FND_MSG_PUB.Count_Msg < 1 THEN
1012: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1013: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_spl_talent -'||SQLERRM);
1014: IGS_GE_MSG_STACK.ADD;
1015: END IF;
1016: App_Exception.Raise_Exception;
1017: END insert_spl_talent;
1018:

Line 1073: IGS_GE_MSG_STACK.ADD;

1069: 'S');
1070: IF FND_MSG_PUB.Count_Msg < 1 THEN
1071: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1072: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_special_interest -'||SQLERRM);
1073: IGS_GE_MSG_STACK.ADD;
1074: END IF;
1075: App_Exception.Raise_Exception;
1076: END insert_special_interest;
1077: --added by nshee during build for Applicant-BOSS SS Bug 2622488

Line 1131: IGS_GE_MSG_STACK.ADD;

1127: 'S');
1128: IF FND_MSG_PUB.Count_Msg < 1 THEN
1129: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1130: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_othinst -'||SQLERRM);
1131: IGS_GE_MSG_STACK.ADD;
1132: END IF;
1133: App_Exception.Raise_Exception;
1134: END insert_othinst;
1135: --dhan

Line 1198: IGS_GE_MSG_STACK.ADD;

1194: 'S');
1195: IF FND_MSG_PUB.Count_Msg < 1 THEN
1196: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1197: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_edugoal_details -'||SQLERRM);
1198: IGS_GE_MSG_STACK.ADD;
1199: END IF;
1200: App_Exception.Raise_Exception;
1201: END insert_edugoal_details;
1202:

Line 1267: IGS_GE_MSG_STACK.ADD;

1263: x_message_name := 'IGS_GE_UNHANDLED_EXP';
1264: IF FND_MSG_PUB.Count_Msg < 1 THEN
1265: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1266: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_ss_appl_stg -'||SQLERRM);
1267: IGS_GE_MSG_STACK.ADD;
1268: END IF;
1269: App_Exception.Raise_Exception;
1270: END insert_ss_appl_stg;
1271:

Line 1353: IGS_GE_MSG_STACK.ADD;

1349: p_message_data := 'IGS_GE_UNHANDLED_EXP';
1350: IF FND_MSG_PUB.Count_Msg < 1 THEN
1351: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1352: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_ss_appl_perstat_stg -'||SQLERRM);
1353: IGS_GE_MSG_STACK.ADD;
1354: END IF;
1355: App_Exception.Raise_Exception;
1356: END insert_ss_appl_perstat_stg;
1357:

Line 1383: l_msg_index := IGS_GE_MSG_STACK.count_msg;

1379: l_msg_data VARCHAR2(2000);
1380: p_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
1381:
1382: BEGIN
1383: l_msg_index := IGS_GE_MSG_STACK.count_msg;
1384:
1385: BEGIN
1386: DELETE FROM igs_ss_ad_sec_stat
1387: WHERE person_id = p_person_id

Line 1450: IGS_GE_MSG_STACK.ADD;

1446: x_message_name := 'IGS_GE_UNHANDLED_EXP';
1447: IF FND_MSG_PUB.Count_Msg < 1 THEN
1448: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1449: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.delete_ss_appl_stg -'||SQLERRM);
1450: IGS_GE_MSG_STACK.ADD;
1451: END IF;
1452: App_Exception.Raise_Exception;
1453:
1454: END delete_ss_appl_stg;

Line 1590: IGS_GE_MSG_STACK.ADD;

1586: logDetail('Exception from transfer_attachment ' || SQLERRM, 'S');
1587: IF FND_MSG_PUB.Count_Msg < 1 THEN
1588: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1589: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.transfer_attachment -'||SQLERRM);
1590: IGS_GE_MSG_STACK.ADD;
1591: END IF;
1592:
1593: App_Exception.Raise_Exception;
1594: END transfer_attachment;

Line 1647: IGS_GE_MSG_STACK.ADD;

1643:
1644: IF cur_sequence%NOTFOUND THEN
1645: fnd_message.set_name('IGS', 'IGS_AD_INQ_ADMCAL_SEQ_NOTDFN');
1646: fnd_message.set_token('CAL_TYPE', p_adm_cal_type);
1647: IGS_GE_MSG_STACK.ADD;
1648: app_exception.raise_exception;
1649: END IF;
1650:
1651: p_adm_seq := sequence_rec.adm_sequence_number;

Line 1756: IGS_GE_MSG_STACK.ADD;

1752: logDetail('Exception from Check_FeeExists ' || SQLERRM, 'S');
1753: IF FND_MSG_PUB.Count_Msg < 1 THEN
1754: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1755: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Check_FeeExists -'||SQLERRM);
1756: IGS_GE_MSG_STACK.ADD;
1757: END IF;
1758: App_Exception.Raise_Exception;
1759:
1760: END Check_FeeExists;

Line 1847: IGS_GE_MSG_STACK.ADD;

1843: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1844: END IF;
1845:
1846: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_ONESTOP_NO_DATA_FOUND');
1847: IGS_GE_MSG_STACK.ADD;
1848: x_return_status := 'N'; -- This is used to specify that application is not onestop
1849: x_message_data := 'IGS_AD_ONESTOP_NO_DATA_FOUND';
1850:
1851: WHEN OTHERS THEN

Line 1864: IGS_GE_MSG_STACK.ADD;

1860: logDetail('Exception from Check_OneStop ' || SQLERRM, 'S');
1861: IF FND_MSG_PUB.Count_Msg < 1 THEN
1862: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1863: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Check_OneStop -'||SQLERRM);
1864: IGS_GE_MSG_STACK.ADD;
1865: END IF;
1866: App_Exception.Raise_Exception;
1867:
1868: END Check_OneStop;

Line 1957: IGS_GE_MSG_STACK.ADD;

1953: IF p_role <> 'ADMIN' THEN
1954: l_msg_data := 'IGS_AD_APPL_PRC_FAILED';
1955: END IF;
1956: FND_MESSAGE.SET_NAME('IGS', l_msg_data);
1957: IGS_GE_MSG_STACK.ADD;
1958: x_return_status := 'E';
1959: x_message_data := l_msg_data;
1960: RETURN;
1961:

Line 1985: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack

1981: END IF;
1982:
1983: IF l_return_status = 'E' THEN --- Update_Appl_Eqdo_Inst return status
1984: IF p_role <> 'ADMIN' THEN
1985: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack
1986: l_msg_data := 'IGS_AD_APPL_PRC_FAILED';
1987: FND_MESSAGE.SET_NAME('IGS', l_msg_data);
1988: IGS_GE_MSG_STACK.ADD;
1989: END IF;

Line 1988: IGS_GE_MSG_STACK.ADD;

1984: IF p_role <> 'ADMIN' THEN
1985: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack
1986: l_msg_data := 'IGS_AD_APPL_PRC_FAILED';
1987: FND_MESSAGE.SET_NAME('IGS', l_msg_data);
1988: IGS_GE_MSG_STACK.ADD;
1989: END IF;
1990: x_return_status := 'E';
1991: x_message_data := l_msg_data;
1992: RETURN;

Line 2018: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack

2014: END IF;
2015:
2016: IF l_return_status = 'E' THEN -- check_offer_update return status
2017: IF p_role <> 'ADMIN' THEN
2018: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack
2019: l_msg_data := 'IGS_AD_APPL_PRC_FAILED';
2020: END IF;
2021: FND_MESSAGE.SET_NAME('IGS', l_msg_data);
2022: IGS_GE_MSG_STACK.ADD;

Line 2022: IGS_GE_MSG_STACK.ADD;

2018: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack
2019: l_msg_data := 'IGS_AD_APPL_PRC_FAILED';
2020: END IF;
2021: FND_MESSAGE.SET_NAME('IGS', l_msg_data);
2022: IGS_GE_MSG_STACK.ADD;
2023: x_return_status := 'E';
2024: x_message_data := l_msg_data;
2025: RETURN;
2026:

Line 2047: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack

2043: END IF;
2044:
2045: IF l_return_status = 'E' THEN -- Update_Appl_Ofr_Inst return status
2046: IF p_role <> 'ADMIN' THEN
2047: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack
2048: l_message_data := 'IGS_AD_APPL_PRC_FAILED';
2049: FND_MESSAGE.SET_NAME('IGS', l_message_data);
2050: IGS_GE_MSG_STACK.ADD;
2051: END IF;

Line 2050: IGS_GE_MSG_STACK.ADD;

2046: IF p_role <> 'ADMIN' THEN
2047: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack
2048: l_message_data := 'IGS_AD_APPL_PRC_FAILED';
2049: FND_MESSAGE.SET_NAME('IGS', l_message_data);
2050: IGS_GE_MSG_STACK.ADD;
2051: END IF;
2052: x_return_status := 'E';
2053: x_message_data := l_message_data;
2054: RETURN;

Line 2065: IGS_GE_MSG_STACK.ADD;

2061: EXCEPTION
2062: WHEN OTHERS THEN
2063: IF FND_MSG_PUB.Count_Msg < 1 AND l_message_data IS NOT NULL THEN
2064: FND_MESSAGE.SET_NAME('IGS', l_message_data);
2065: IGS_GE_MSG_STACK.ADD;
2066: END IF;
2067: x_return_status := 'E';
2068: x_message_data := l_message_data;
2069: END;

Line 2084: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack

2080: WHEN OTHERS THEN
2081: logDetail('Exception from Process_OneStop, ' || SQLERRM, 'S');
2082: x_return_status := 'E';
2083: IF p_role <> 'ADMIN' THEN
2084: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack
2085: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APPL_PRC_FAILED');
2086: IGS_GE_MSG_STACK.ADD;
2087: x_message_data := 'IGS_AD_APPL_PRC_FAILED';
2088: ELSE

Line 2086: IGS_GE_MSG_STACK.ADD;

2082: x_return_status := 'E';
2083: IF p_role <> 'ADMIN' THEN
2084: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack
2085: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APPL_PRC_FAILED');
2086: IGS_GE_MSG_STACK.ADD;
2087: x_message_data := 'IGS_AD_APPL_PRC_FAILED';
2088: ELSE
2089: IF FND_MSG_PUB.Count_Msg < 1 THEN
2090: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 2092: IGS_GE_MSG_STACK.ADD;

2088: ELSE
2089: IF FND_MSG_PUB.Count_Msg < 1 THEN
2090: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2091: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Process_OneStop -'||SQLERRM);
2092: IGS_GE_MSG_STACK.ADD;
2093: App_Exception.Raise_Exception;
2094: END IF;
2095: x_message_data := 'IGS_GE_UNHANDLED_EXP';
2096: END IF;

Line 2298: IGS_GE_MSG_STACK.ADD;

2294: x_msg_data := 'IGS_GE_UNHANDLED_EXP';
2295: IF FND_MSG_PUB.Count_Msg < 1 THEN
2296: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2297: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_ad_offer_resp_and_fee -'||SQLERRM);
2298: IGS_GE_MSG_STACK.ADD;
2299: END IF;
2300: END update_ad_offer_resp_and_fee;
2301:
2302: -- This procedure will only be called if it is a one-stop application

Line 2411: IGS_GE_MSG_STACK.ADD;

2407: IF p_role <> 'ADMIN' THEN
2408: l_msg_data := 'IGS_AD_APPL_PRC_FAILED';
2409: END IF;
2410: FND_MESSAGE.SET_NAME('IGS', l_msg_data);
2411: IGS_GE_MSG_STACK.ADD;
2412: x_return_status := 'E';
2413: x_msg_data := l_msg_data;
2414: RETURN;
2415:

Line 2452: IGS_GE_MSG_STACK.ADD;

2448: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2449: END IF;
2450:
2451: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_AUTO_ENR_FAILED');
2452: IGS_GE_MSG_STACK.ADD;
2453: x_return_status := 'E';
2454: x_msg_data := 'IGS_AD_AUTO_ENR_FAILED'; --Supressing the error message from the Pre Enr process as per communication on bug2405076
2455: RETURN;
2456: ELSE

Line 2490: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack

2486: WHEN OTHERS THEN
2487: logDetail('Exception from Process_OneStop2, ' || SQLERRM, 'S');
2488: x_return_status := 'E';
2489: IF p_role <> 'ADMIN' THEN
2490: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack
2491: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APPL_PRC_FAILED');
2492: IGS_GE_MSG_STACK.ADD;
2493: x_msg_data := 'IGS_AD_APPL_PRC_FAILED';
2494: ELSE

Line 2492: IGS_GE_MSG_STACK.ADD;

2488: x_return_status := 'E';
2489: IF p_role <> 'ADMIN' THEN
2490: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack
2491: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APPL_PRC_FAILED');
2492: IGS_GE_MSG_STACK.ADD;
2493: x_msg_data := 'IGS_AD_APPL_PRC_FAILED';
2494: ELSE
2495: IF FND_MSG_PUB.Count_Msg < 1 THEN
2496: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 2498: IGS_GE_MSG_STACK.ADD;

2494: ELSE
2495: IF FND_MSG_PUB.Count_Msg < 1 THEN
2496: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2497: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Process_OneStop2 -'||SQLERRM);
2498: IGS_GE_MSG_STACK.ADD;
2499: App_Exception.Raise_Exception;
2500: END IF;
2501: x_msg_data := 'IGS_GE_UNHANDLED_EXP';
2502: END IF;

Line 2726: l_sc_msg_count := IGS_GE_MSG_STACK.COUNT_MSG;

2722: x_return_status := 'S';
2723: x_message_data := NULL;
2724: EXCEPTION
2725: WHEN OTHERS THEN
2726: l_sc_msg_count := IGS_GE_MSG_STACK.COUNT_MSG;
2727: WHILE l_sc_msg_count <> 0 loop
2728: igs_ge_msg_stack.get(l_sc_msg_count, 'T', l_sc_encoded_text, l_sc_msg_index);
2729: fnd_message.parse_encoded(l_sc_encoded_text, l_sc_app_short_name, l_sc_message_name);
2730: IF l_sc_message_name = 'IGS_SC_POLICY_EXCEPTION' OR l_sc_message_name = 'IGS_SC_POLICY_UPD_DEL_EXCEP' THEN

Line 2728: igs_ge_msg_stack.get(l_sc_msg_count, 'T', l_sc_encoded_text, l_sc_msg_index);

2724: EXCEPTION
2725: WHEN OTHERS THEN
2726: l_sc_msg_count := IGS_GE_MSG_STACK.COUNT_MSG;
2727: WHILE l_sc_msg_count <> 0 loop
2728: igs_ge_msg_stack.get(l_sc_msg_count, 'T', l_sc_encoded_text, l_sc_msg_index);
2729: fnd_message.parse_encoded(l_sc_encoded_text, l_sc_app_short_name, l_sc_message_name);
2730: IF l_sc_message_name = 'IGS_SC_POLICY_EXCEPTION' OR l_sc_message_name = 'IGS_SC_POLICY_UPD_DEL_EXCEP' THEN
2731: x_return_status := 'E';
2732: x_message_data := 'IGS_SC_POLICY_EXCEPTION';

Line 2741: IGS_GE_MSG_STACK.ADD;

2737:
2738: IF FND_MSG_PUB.Count_Msg < 1 THEN
2739: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2740: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Update_Appl_Eqdo_Inst -'||SQLERRM);
2741: IGS_GE_MSG_STACK.ADD;
2742: App_Exception.Raise_Exception;
2743: END IF;
2744: x_return_status := 'E';
2745: x_message_data := 'IGS_GE_UNHANDLED_EXP';

Line 2949: l_sc_msg_count := IGS_GE_MSG_STACK.COUNT_MSG;

2945: x_return_status := 'S';
2946: x_message_data := NULL;
2947: EXCEPTION
2948: WHEN OTHERS THEN
2949: l_sc_msg_count := IGS_GE_MSG_STACK.COUNT_MSG;
2950: WHILE l_sc_msg_count <> 0 loop
2951: igs_ge_msg_stack.get(l_sc_msg_count, 'T', l_sc_encoded_text, l_sc_msg_index);
2952: fnd_message.parse_encoded(l_sc_encoded_text, l_sc_app_short_name, l_sc_message_name);
2953: IF l_sc_message_name = 'IGS_SC_POLICY_EXCEPTION' OR l_sc_message_name = 'IGS_SC_POLICY_UPD_DEL_EXCEP' THEN

Line 2951: igs_ge_msg_stack.get(l_sc_msg_count, 'T', l_sc_encoded_text, l_sc_msg_index);

2947: EXCEPTION
2948: WHEN OTHERS THEN
2949: l_sc_msg_count := IGS_GE_MSG_STACK.COUNT_MSG;
2950: WHILE l_sc_msg_count <> 0 loop
2951: igs_ge_msg_stack.get(l_sc_msg_count, 'T', l_sc_encoded_text, l_sc_msg_index);
2952: fnd_message.parse_encoded(l_sc_encoded_text, l_sc_app_short_name, l_sc_message_name);
2953: IF l_sc_message_name = 'IGS_SC_POLICY_EXCEPTION' OR l_sc_message_name = 'IGS_SC_POLICY_UPD_DEL_EXCEP' THEN
2954: x_return_status := 'E';
2955: x_message_data := 'IGS_SC_POLICY_EXCEPTION';

Line 2964: IGS_GE_MSG_STACK.ADD;

2960:
2961: IF FND_MSG_PUB.Count_Msg < 1 THEN
2962: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2963: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Update_Appl_Ofr_Inst -'||SQLERRM);
2964: IGS_GE_MSG_STACK.ADD;
2965: App_Exception.Raise_Exception;
2966: END IF;
2967: x_return_status := 'E';
2968: x_message_data := 'IGS_GE_UNHANDLED_EXP';

Line 3222: IGS_GE_MSG_STACK.ADD;

3218: WHEN OTHERS THEN
3219: IF FND_MSG_PUB.Count_Msg < 1 THEN
3220: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3221: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_appl_section_stat -'||SQLERRM);
3222: IGS_GE_MSG_STACK.ADD;
3223: END IF;
3224: x_return_status := 'E';
3225: x_message_name := 'IGS_GE_UNHANDLED_EXP';
3226: App_Exception.Raise_Exception;

Line 3371: IGS_GE_MSG_STACK.ADD;

3367: 'S');
3368: IF FND_MSG_PUB.Count_Msg < 1 THEN
3369: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3370: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_application_fee -'||SQLERRM);
3371: IGS_GE_MSG_STACK.ADD;
3372: END IF;
3373: App_Exception.Raise_Exception;
3374:
3375: END insert_application_fee;

Line 4572: IGS_GE_MSG_STACK.ADD;

4568:
4569: IF FND_MSG_PUB.Count_Msg < 1 THEN
4570: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4571: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_appl_section_stat -'||SQLERRM);
4572: IGS_GE_MSG_STACK.ADD;
4573: END IF;
4574: END update_appl_section_stat;
4575:
4576:

Line 4638: IGS_GE_MSG_STACK.ADD;

4634: logDetail('Exception from sync_appl_section_stat: ' || SQLERRM, 'S');
4635: IF FND_MSG_PUB.Count_Msg < 1 THEN
4636: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4637: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.sync_appl_section_stat -'||SQLERRM);
4638: IGS_GE_MSG_STACK.ADD;
4639: END IF;
4640: IF c_NoPgs%ISOPEN THEN
4641: CLOSE c_NoPgs;
4642: END IF;

Line 4855: IGS_GE_MSG_STACK.ADD;

4851: x_message_name := 'IGS_GE_UNHANDLED_EXP';
4852: IF FND_MSG_PUB.Count_Msg < 1 THEN
4853: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4854: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.auto_assign_pgs_comps_terms -'||SQLERRM);
4855: IGS_GE_MSG_STACK.ADD;
4856: END IF;
4857: END auto_assign_pgs_comps_terms;
4858:
4859:

Line 5777: IGS_GE_MSG_STACK.ADD;

5773: x_concat_desc := NULL;
5774: IF FND_MSG_PUB.Count_Msg < 1 THEN
5775: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5776: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.get_ss_lookup_desc -'||SQLERRM);
5777: IGS_GE_MSG_STACK.ADD;
5778: END IF;
5779: END get_ss_lookup_desc;
5780:
5781: PROCEDURE CHECK_INSTANCE_SECURITY( p_person_id IN NUMBER,

Line 5824: IGS_GE_MSG_STACK.ADD;

5820: ELSE
5821: fnd_message.set_name( 'IGS', 'IGS_SC_NO_ACCESS_PRIV');
5822: x_error_msg := 'IGS_SC_NO_ACCESS_PRIV';
5823: END IF;
5824: IGS_GE_MSG_STACK.ADD;
5825: END IF;
5826:
5827: END CHECK_INSTANCE_SECURITY;
5828:

Line 5884: IGS_GE_MSG_STACK.ADD;

5880: logDetail('Exception from create_application_detail, MAIN LOOP: ' || SQLERRM, 'S');
5881: IF FND_MSG_PUB.Count_Msg < 1 THEN
5882: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
5883: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.create_application_detail -'||SQLERRM);
5884: IGS_GE_MSG_STACK.ADD;
5885: END IF;
5886: App_Exception.Raise_Exception;
5887:
5888: END create_application_detail;