DBA Data[Home] [Help]

APPS.IGS_EN_GEN_010 dependencies on IGS_EN_GEN_010

Line 1: PACKAGE BODY IGS_EN_GEN_010 AS

1: PACKAGE BODY IGS_EN_GEN_010 AS
2: /* $Header: IGSEN10B.pls 120.22 2006/09/15 06:26:36 amanohar ship $ */
3:
4: -------------------------------------------------------------------------------------------
5: --Change History:

Line 100: g_module_head CONSTANT VARCHAR2(40) := 'igs.plsql.igs_en_gen_010.';

96: -- stuta 26-Nov-05 modified enrp_ins_suai_trnsfr for bug#4744323
97: -- smaddali 16-jan-2006 Modified cursors for performance repository bug#3699726
98: -- ckasu 07-MAR-2006 modified as a part of bug#5070730
99: -------------------------------------------------------------------------------------------
100: g_module_head CONSTANT VARCHAR2(40) := 'igs.plsql.igs_en_gen_010.';
101: --
102: FUNCTION create_stream_unit_sets(
103: p_person_id IN NUMBER,
104: p_course_cd IN VARCHAR2,

Line 228: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.copy_hesa_details');

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');
229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231:
232: END copy_hesa_details;

Line 725: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_check_eligibility');

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');
726: IGS_GE_MSG_STACK.ADD;
727: App_Exception.Raise_Exception;
728:
729: END enrpl_check_eligibility;

Line 802: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_check_offer');

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');
803: IGS_GE_MSG_STACK.ADD;
804: App_Exception.Raise_Exception;
805:
806: END enrpl_check_offer;

Line 972: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_upd_candidature.APP_EXP','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);

968: IF c_ca_upd%ISOPEN THEN
969: CLOSE c_ca_upd;
970: END IF;
971: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
972: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_upd_candidature.APP_EXP','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
973: END IF;
974: RAISE;
975: WHEN OTHERS THEN
976: IF c_ca%ISOPEN THEN

Line 986: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_upd_candidature.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);

982: IF c_ca_upd%ISOPEN THEN
983: CLOSE c_ca_upd;
984: END IF;
985: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
986: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_upd_candidature.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
987: END IF;
988: RAISE;
989: END;
990: END enrpl_upd_candidature;

Line 1535: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.APP_EXP1','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);

1531: IF c_crv%ISOPEN THEN
1532: CLOSE c_crv;
1533: END IF;
1534: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1535: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.APP_EXP1','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1536: END IF;
1537: RAISE;
1538: WHEN OTHERS THEN
1539: IF c_sca_upd%ISOPEN THEN

Line 1550: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_sca1');

1546: CLOSE c_crv;
1547: END IF;
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

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

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;
1557: RAISE;
1558: END;
1559: ELSIF v_sca_rec.course_attempt_status = cst_discontin THEN

Line 1681: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.APP_EXP2','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);

1677: IF c_crv%ISOPEN THEN
1678: CLOSE c_crv;
1679: END IF;
1680: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1681: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.APP_EXP2','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1682: END IF;
1683: RAISE;
1684: WHEN OTHERS THEN
1685: IF c_sca_upd%ISOPEN THEN

Line 1695: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP2','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);

1691: IF c_crv%ISOPEN THEN
1692: CLOSE c_crv;
1693: END IF;
1694: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1695: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP2','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1696: END IF;
1697: RAISE;
1698: END;
1699: ELSE

Line 1834: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.APP_EXP3','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);

1830: IF c_crv%ISOPEN THEN
1831: CLOSE c_crv;
1832: END IF;
1833: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1834: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.APP_EXP3','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1835: END IF;
1836: RAISE;
1837: WHEN OTHERS THEN
1838: IF c_sca_upd%ISOPEN THEN

Line 1848: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP3','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);

1844: IF c_crv%ISOPEN THEN
1845: CLOSE c_crv;
1846: END IF;
1847: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1848: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP3','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1849: END IF;
1850: RAISE;
1851: END;
1852: END IF;

Line 1895: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);

1891: IF c_crv%ISOPEN THEN
1892: CLOSE c_crv;
1893: END IF;
1894: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1895: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1896: END IF;
1897: RAISE;
1898: END;
1899:

Line 1903: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_sca4');

1899:
1900: /*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

Line 2073: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_scae1');

2069: IF c_scae_upd%ISOPEN THEN
2070: CLOSE c_scae_upd;
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;

Line 2096: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_scae2');

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');
2097: IGS_GE_MSG_STACK.ADD;
2098: App_Exception.Raise_Exception;
2099:
2100: END enrpl_create_scae;

Line 2388: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_copy_adm_unit_sets');

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');
2389: IGS_GE_MSG_STACK.ADD;
2390: App_Exception.Raise_Exception;
2391:
2392: END enrpl_copy_adm_unit_sets;

Line 2406: --ptandon 06-Oct-2003 Modified to get the value of core indicator and pass to Igs_En_Gen_010.enrp_vald_inst_sua

2402: /*****************************************************/
2403: --Who When What
2404: --mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in insert row of IGS_EN_SU_ATTEMPT
2405: -- for Bug 2554109 MINI Waitlist Build for Jan 03 Release
2406: --ptandon 06-Oct-2003 Modified to get the value of core indicator and pass to Igs_En_Gen_010.enrp_vald_inst_sua
2407: -- as part of Prevent Dropping Core Units. Enh Bug# 3052432.
2408: /****************************************************/
2409:
2410: BEGIN -- enrpl_copy_adm_sua

Line 2575: IF igs_en_gen_010.enrp_vald_inst_sua(p_person_id => p_person_id,

2571: l_core_indicator := igs_en_gen_009.enrp_check_usec_core(p_person_id, p_course_cd, l_uoo_id);
2572:
2573: -- IGS_PS_UNIT doesn?t exist against the students record or as
2574: -- advanced standing, so insert unconfirmed IGS_PS_UNIT attempt.
2575: IF igs_en_gen_010.enrp_vald_inst_sua(p_person_id => p_person_id,
2576: p_course_cd => p_course_cd,
2577: p_unit_cd => v_acaiu_rec.unit_cd,
2578: p_version_number => v_acaiu_rec.uv_version_number,
2579: p_teach_cal_type => v_acaiu_rec.cal_type,

Line 2689: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_copy_adm_sua');

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');
2690: IGS_GE_MSG_STACK.ADD;
2691: App_Exception.Raise_Exception;
2692: END enrpl_copy_adm_sua;
2693:

Line 2706: --ptandon 06-Oct-2003 Modified to get the value of core indicator and pass to Igs_En_Gen_010.enrp_vald_inst_sua

2702: -------------------------------------------------------------------------------------------
2703: --Change History:
2704: --Who When What
2705: --kkillams 28-04-2003 Modified the c_sua cursor w.r.t. bug number 2829262
2706: --ptandon 06-Oct-2003 Modified to get the value of core indicator and pass to Igs_En_Gen_010.enrp_vald_inst_sua
2707: -- as part of Prevent Dropping Core Units. Enh Bug# 3052432.
2708: --svanukur 19-oct-2003 Made the following modifaications part of placements build:
2709: -- Reordered the units so that the superior units are processed first becuase of the validation in
2710: -- sua_api that checks for an appropriate superior unit attempt when a subordinate unit is enrolled.

Line 3063: IF igs_en_gen_010.enrp_vald_inst_sua(p_person_id => p_person_id,

3059:
3060: -- Get the Core Indicator for the Unit Section
3061: l_core_indicator := igs_en_gen_009.enrp_check_usec_core(p_person_id, p_course_cd, l_uoo_id);
3062:
3063: IF igs_en_gen_010.enrp_vald_inst_sua(p_person_id => p_person_id,
3064: p_course_cd => p_course_cd,
3065: p_unit_cd => NULL,
3066: p_version_number => NULL,
3067: p_teach_cal_type => NULL,

Line 3185: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_copy_param_sua');

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');
3186: IGS_GE_MSG_STACK.ADD;
3187: App_Exception.Raise_Exception;
3188: END enrpl_copy_param_sua;
3189:

Line 3257: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_pos_sua');

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');
3258: IGS_GE_MSG_STACK.ADD;
3259: App_Exception.Raise_Exception;
3260: END enrpl_create_pos_sua;
3261:

Line 3380: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_fee_contract');

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');
3381: IGS_GE_MSG_STACK.ADD;
3382: App_Exception.Raise_Exception;
3383: END enrpl_create_fee_contract;
3384:

Line 3967: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_snew_prenrl');

3963: p_del => ';');
3964: END IF;
3965: ELSE
3966: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3967: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_snew_prenrl');
3968: l_mesg_txt := fnd_message.get;
3969: igs_ge_gen_003.genp_ins_log_entry(p_s_log_type => cst_pre_enrol,
3970: p_creation_dt => p_log_creation_dt,
3971: p_key => p_warn_level||','||TO_CHAR(p_person_id)||','||p_course_cd,

Line 3978: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);

3974: END IF;
3975: l_message_name := NULL;
3976: ELSE
3977: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3978: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
3979: END IF;
3980: RAISE;
3981: END IF;
3982: END;

Line 4354: --ptandon 06-Oct-2003 Modified to get the value of core indicator and pass to Igs_En_Gen_010.enrp_vald_inst_sua

4350: /*-------------------------------------------------------------------------------------------
4351: --Change History:
4352: --Who When What
4353: --kkillams 28-04-2003 Modified the c_sua cursor w.r.t. bug number 2829262
4354: --ptandon 06-Oct-2003 Modified to get the value of core indicator and pass to Igs_En_Gen_010.enrp_vald_inst_sua
4355: -- as part of Prevent Dropping Core Units. Enh Bug# 3052432.
4356: --svanukur 19-oct-2003 MAde the following modifaications part of placements build:
4357: -- Reordered the units so that the superior units are processed first becuase of the validation in
4358: -- sua_api that checks for an appropriate superior unit attempt when a subordinate unit is enrolled.

Line 4721: IF igs_en_gen_010.enrp_vald_inst_sua(p_person_id => p_person_id,

4717:
4718: -- Get the Core Indicator for the Unit Section
4719: l_core_indicator := igs_en_gen_009.enrp_check_usec_core(p_person_id, p_course_cd, l_uoo_id);
4720:
4721: IF igs_en_gen_010.enrp_vald_inst_sua(p_person_id => p_person_id,
4722: p_course_cd => p_course_cd,
4723: p_unit_cd => NULL,
4724: p_version_number => NULL,
4725: p_teach_cal_type => NULL,

Line 4840: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_copy_param_sua');

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');
4841: IGS_GE_MSG_STACK.ADD;
4842: App_Exception.Raise_Exception;
4843: END enrpl_copy_param_sua;
4844:

Line 4984: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_sret_preenrol');

4980: IF c_scae_upd%ISOPEN THEN
4981: CLOSE c_scae_upd;
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

Line 5547: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_snew_prenrl');

5543: p_del => ';');
5544: END IF;
5545: ELSE -- unhandled exception
5546: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
5547: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_snew_prenrl');
5548: l_mesg_txt := fnd_message.get;
5549: igs_ge_gen_003.genp_ins_log_entry(p_s_log_type => cst_pre_enrol,
5550: p_creation_dt => p_log_creation_dt,
5551: p_key => p_warn_level||','||TO_CHAR(p_person_id)||','||p_course_cd,

Line 5566: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_sret_prenrl');

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');
5567: IGS_GE_MSG_STACK.ADD;
5568: App_Exception.Raise_Exception;
5569: END enrp_ins_sret_prenrl;
5570:

Line 5992: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_sua_hist');

5988: END;
5989: /*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:

Line 6363: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_sua_trnsfr');

6359: CLOSE c_sua_career;
6360: -- if career not setup then throw error
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:

Line 6799: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_susa_hist');

6795: END;
6796: 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:

Line 7027: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_susa_trnsfr');

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');
7028: IGS_GE_MSG_STACK.ADD;
7029: App_Exception.Raise_Exception;
7030: END enrp_ins_susa_trnsfr;
7031:

Line 9427: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_sua_trnsfr');

9423: CLOSE c_sua_career;
9424: -- if career not setup then throw error
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:

Line 10347: END IGS_EN_GEN_010;

10343: END enrp_val_sua_cnfrm_before_pt;
10344:
10345:
10346:
10347: END IGS_EN_GEN_010;