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_EN_GEN_010 dependencies on APP_EXCEPTION

Line 198: App_Exception.Raise_Exception;

194:
195: IF NVL(l_Status,0) = 2 THEN -- ie. The procedure call has resulted in error.
196: Fnd_Message.Set_Name('IGS', l_message_name);
197: IGS_GE_MSG_STACK.ADD;
198: App_Exception.Raise_Exception;
199: END IF;
200:
201: -- Calling the Hesa procedure
202: l_message_name := NULL;

Line 218: App_Exception.Raise_Exception;

214: p_status => l_status);
215: IF NVL(l_Status,0) = 2 THEN -- ie. The procedure call has resulted in error.
216: Fnd_Message.Set_Name('IGS', l_message_name);
217: IGS_GE_MSG_STACK.ADD;
218: App_Exception.Raise_Exception;
219: END IF;
220:
221: END IF; -- IF fnd_profile.value('OSS_COUNTRY_CODE') = 'GB'
222:

Line 224: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

220:
221: END IF; -- IF fnd_profile.value('OSS_COUNTRY_CODE') = 'GB'
222:
223: EXCEPTION
224: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
225: RAISE;
226: WHEN OTHERS THEN
227: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
228: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.copy_hesa_details');

Line 230: App_Exception.Raise_Exception;

226: WHEN OTHERS THEN
227: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
228: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.copy_hesa_details');
229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231:
232: END copy_hesa_details;
233:
234: FUNCTION Enrp_Ins_Snew_Prenrl(

Line 721: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

717: END IF;
718: RETURN TRUE;
719: END;
720: EXCEPTION
721: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
722: RAISE;
723: WHEN OTHERS THEN
724: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
725: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_check_eligibility');

Line 727: App_Exception.Raise_Exception;

723: WHEN OTHERS THEN
724: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
725: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_check_eligibility');
726: IGS_GE_MSG_STACK.ADD;
727: App_Exception.Raise_Exception;
728:
729: END enrpl_check_eligibility;
730:
731: FUNCTION enrpl_check_offer(

Line 798: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

794: END IF;
795: RAISE;
796: END;
797: EXCEPTION
798: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
799: RAISE;
800: WHEN OTHERS THEN
801: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
802: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_check_offer');

Line 804: App_Exception.Raise_Exception;

800: WHEN OTHERS THEN
801: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
802: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_check_offer');
803: IGS_GE_MSG_STACK.ADD;
804: App_Exception.Raise_Exception;
805:
806: END enrpl_check_offer;
807:
808: FUNCTION enrpl_upd_candidature(

Line 961: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

957: END IF;
958: p_message_name := 'IGS_EN_CANDID_KEY_DETAIL';
959: p_warn_level := cst_error;
960: RETURN FALSE;
961: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
962: IF c_ca%ISOPEN THEN
963: CLOSE c_ca;
964: END IF;
965: IF c_ca2%ISOPEN THEN

Line 1327: App_Exception.Raise_Exception;

1323: IF NVL(l_Status,0) = 2 THEN
1324: -- ie. The procedure call has resulted in error.
1325: Fnd_Message.Set_Name('IGS', l_message_name);
1326: IGS_GE_MSG_STACK.ADD;
1327: App_Exception.Raise_Exception;
1328: END IF;
1329:
1330: END IF;
1331: -- end smaddali

Line 1524: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

1520: END IF;
1521: p_message_name := 'IGS_EN_STUD_PRG_REC_LOCKED';
1522: p_warn_level := cst_error;
1523: RETURN;
1524: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1525: IF c_sca_upd%ISOPEN THEN
1526: CLOSE c_sca_upd;
1527: END IF;
1528: IF c_sca%ISOPEN THEN

Line 1552: App_Exception.Raise_Exception;

1548: /* commented for Bug 1510921
1549: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1550: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_sca1');
1551: IGS_GE_MSG_STACK.ADD;
1552: App_Exception.Raise_Exception;
1553: */
1554: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1555: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP1','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1556: END IF;

Line 1670: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

1666: END IF;
1667: p_message_name := 'IGS_EN_STUD_PRG_REC_LOCKED';
1668: p_warn_level := cst_error;
1669: RETURN;
1670: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1671: IF c_sca_upd%ISOPEN THEN
1672: CLOSE c_sca_upd;
1673: END IF;
1674: IF c_sca%ISOPEN THEN

Line 1823: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

1819: END IF;
1820: p_message_name := 'IGS_EN_STUD_PRG_REC_LOCKED';
1821: p_warn_level := cst_minor;
1822: RETURN;
1823: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1824: IF c_sca_upd%ISOPEN THEN
1825: CLOSE c_sca_upd;
1826: END IF;
1827: IF c_sca%ISOPEN THEN

Line 1905: App_Exception.Raise_Exception; */

1901: WHEN OTHERS THEN
1902: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1903: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_sca4');
1904: IGS_GE_MSG_STACK.ADD;
1905: App_Exception.Raise_Exception; */
1906: -- The exception part has been commented as a part of bug fix # 1520688 , as
1907: -- the Raise stmt trasferred control to when others , rather than showing
1908: -- the correct error message.
1909:

Line 2063: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

2059: END IF;
2060: p_message_name := 'IGS_EN_STUD_PRG_LAPSE_USER';
2061: p_warn_level := cst_error;
2062: RETURN FALSE;
2063: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
2064: IF c_scae_upd%ISOPEN THEN
2065: CLOSE c_scae_upd;
2066: END IF;
2067: RAISE;

Line 2075: App_Exception.Raise_Exception;

2071: END IF;
2072: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
2073: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_scae1');
2074: IGS_GE_MSG_STACK.ADD;
2075: App_Exception.Raise_Exception;
2076: END;
2077: END IF;
2078: END IF;
2079: RETURN TRUE;

Line 2092: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

2088: END IF;
2089: RAISE;
2090: END;
2091: EXCEPTION
2092: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
2093: RAISE;
2094: WHEN OTHERS THEN
2095: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
2096: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_scae2');

Line 2098: App_Exception.Raise_Exception;

2094: WHEN OTHERS THEN
2095: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
2096: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_scae2');
2097: IGS_GE_MSG_STACK.ADD;
2098: App_Exception.Raise_Exception;
2099:
2100: END enrpl_create_scae;
2101:
2102: FUNCTION enrpl_copy_adm_unit_sets

Line 2384: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

2380: END IF;
2381: RAISE;
2382: END;
2383: EXCEPTION
2384: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
2385: RAISE;
2386: WHEN OTHERS THEN
2387: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
2388: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_copy_adm_unit_sets');

Line 2390: App_Exception.Raise_Exception;

2386: WHEN OTHERS THEN
2387: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
2388: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_copy_adm_unit_sets');
2389: IGS_GE_MSG_STACK.ADD;
2390: App_Exception.Raise_Exception;
2391:
2392: END enrpl_copy_adm_unit_sets;
2393:
2394: PROCEDURE enrpl_copy_adm_sua (

Line 2685: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

2681:
2682: RAISE;
2683: END;
2684: EXCEPTION
2685: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
2686: RAISE;
2687: WHEN OTHERS THEN
2688: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
2689: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_copy_adm_sua');

Line 2691: App_Exception.Raise_Exception;

2687: WHEN OTHERS THEN
2688: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
2689: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_copy_adm_sua');
2690: IGS_GE_MSG_STACK.ADD;
2691: App_Exception.Raise_Exception;
2692: END enrpl_copy_adm_sua;
2693:
2694: PROCEDURE enrpl_copy_param_sua (
2695: p_warn_level OUT NOCOPY VARCHAR2,

Line 3181: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

3177: END IF;
3178: RAISE;
3179: END;
3180: EXCEPTION
3181: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
3182: RAISE;
3183: WHEN OTHERS THEN
3184: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
3185: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_copy_param_sua');

Line 3187: App_Exception.Raise_Exception;

3183: WHEN OTHERS THEN
3184: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
3185: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_copy_param_sua');
3186: IGS_GE_MSG_STACK.ADD;
3187: App_Exception.Raise_Exception;
3188: END enrpl_copy_param_sua;
3189:
3190: PROCEDURE enrpl_create_pos_sua (
3191: p_unit_set_cd IN igs_en_unit_set.unit_set_cd%TYPE,

Line 3253: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

3249: END IF;
3250: RETURN;
3251: END;
3252: EXCEPTION
3253: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
3254: RAISE;
3255: WHEN OTHERS THEN
3256: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
3257: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_pos_sua');

Line 3259: App_Exception.Raise_Exception;

3255: WHEN OTHERS THEN
3256: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
3257: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_pos_sua');
3258: IGS_GE_MSG_STACK.ADD;
3259: App_Exception.Raise_Exception;
3260: END enrpl_create_pos_sua;
3261:
3262: PROCEDURE enrpl_create_fee_contract(
3263: p_warn_level OUT NOCOPY VARCHAR2,

Line 3376: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

3372: END IF;
3373: RAISE;
3374: END;
3375: EXCEPTION
3376: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
3377: RAISE;
3378: WHEN OTHERS THEN
3379: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
3380: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_fee_contract');

Line 3382: App_Exception.Raise_Exception;

3378: WHEN OTHERS THEN
3379: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
3380: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_fee_contract');
3381: IGS_GE_MSG_STACK.ADD;
3382: App_Exception.Raise_Exception;
3383: END enrpl_create_fee_contract;
3384:
3385: BEGIN -- begin of the function, Enrp_Ins_Snew_Prenrl
3386:

Line 4836: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

4832:
4833: RAISE;
4834: END;
4835: EXCEPTION
4836: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
4837: RAISE;
4838: WHEN OTHERS THEN
4839: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
4840: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_copy_param_sua');

Line 4842: App_Exception.Raise_Exception;

4838: WHEN OTHERS THEN
4839: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
4840: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_copy_param_sua');
4841: IGS_GE_MSG_STACK.ADD;
4842: App_Exception.Raise_Exception;
4843: END enrpl_copy_param_sua;
4844:
4845:
4846: BEGIN -- enrp_ins_sret_prenrl

Line 4986: App_Exception.Raise_Exception;

4982: END IF;
4983: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
4984: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_sret_preenrol');
4985: IGS_GE_MSG_STACK.ADD;
4986: App_Exception.Raise_Exception;
4987: END;
4988: END IF; --v_scae_details <> p_enrolment_cat
4989: END IF; --p_enrolment_cat
4990: ELSE

Line 5562: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

5558: END IF;
5559:
5560: END;
5561: EXCEPTION
5562: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
5563: RAISE;
5564: WHEN OTHERS THEN
5565: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
5566: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_sret_prenrl');

Line 5568: App_Exception.Raise_Exception;

5564: WHEN OTHERS THEN
5565: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
5566: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_sret_prenrl');
5567: IGS_GE_MSG_STACK.ADD;
5568: App_Exception.Raise_Exception;
5569: END enrp_ins_sret_prenrl;
5570:
5571: FUNCTION Enrp_Ins_Suao_Discon(
5572: p_person_id IN NUMBER ,

Line 5994: App_Exception.Raise_Exception;*/

5990: WHEN OTHERS THEN
5991: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
5992: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_sua_hist');
5993: IGS_GE_MSG_STACK.ADD;
5994: App_Exception.Raise_Exception;*/
5995: END enrp_ins_sua_hist;
5996:
5997:
5998: FUNCTION unit_effect_or_future_term( p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,

Line 6365: App_Exception.Raise_Exception;

6361: IF v_source_course_type IS NULL OR v_destn_course_type IS NULL THEN
6362: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
6363: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_sua_trnsfr');
6364: IGS_GE_MSG_STACK.ADD;
6365: App_Exception.Raise_Exception;
6366: END IF;
6367:
6368: -- set the unit attempt status for the destination
6369: IF v_sua_rec.unit_attempt_status = cst_enrolled THEN

Line 6801: App_Exception.Raise_Exception;

6797: WHEN OTHERS THEN
6798: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
6799: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_susa_hist');
6800: IGS_GE_MSG_STACK.ADD;
6801: App_Exception.Raise_Exception;
6802: END enrp_ins_susa_hist;
6803:
6804: FUNCTION Enrp_Ins_Susa_Trnsfr(
6805: p_person_id IN NUMBER ,

Line 7023: App_Exception.Raise_Exception;

7019: EXCEPTION
7020: WHEN INVALID_PARAM THEN
7021: Fnd_Message.Set_Name('IGS', p_message_name);
7022: IGS_GE_MSG_STACK.ADD;
7023: App_Exception.Raise_Exception;
7024:
7025: WHEN OTHERS THEN
7026: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
7027: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_susa_trnsfr');

Line 7029: App_Exception.Raise_Exception;

7025: WHEN OTHERS THEN
7026: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
7027: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_susa_trnsfr');
7028: IGS_GE_MSG_STACK.ADD;
7029: App_Exception.Raise_Exception;
7030: END enrp_ins_susa_trnsfr;
7031:
7032: FUNCTION Enrp_Ins_Sut_Trnsfr(
7033: p_person_id IN NUMBER ,

Line 7916: App_Exception.Raise_Exception;

7912:
7913: IF NVL(l_Status,0) = 2 THEN -- ie. The procedure call has resulted in error.
7914: Fnd_Message.Set_Name('IGS', p_message_name);
7915: IGS_GE_MSG_STACK.ADD;
7916: App_Exception.Raise_Exception;
7917: END IF;
7918: END IF;
7919:
7920: EXCEPTION

Line 9429: App_Exception.Raise_Exception;

9425: IF l_source_course_type IS NULL OR l_destn_course_type IS NULL THEN
9426: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
9427: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_sua_trnsfr');
9428: IGS_GE_MSG_STACK.ADD;
9429: App_Exception.Raise_Exception;
9430: END IF;
9431:
9432: -- if it is an intra career transfer then drop unit from source reducing counts as this unit was not transfered
9433: IF NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y' AND