139: RAISE;
140: END;
141: EXCEPTION
142: WHEN OTHERS THEN
143: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
144: FND_MESSAGE.SET_TOKEN('NAME','IGSST_GEN_002.stap_get_crs_study');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END stap_get_crs_study;
140: END;
141: EXCEPTION
142: WHEN OTHERS THEN
143: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
144: FND_MESSAGE.SET_TOKEN('NAME','IGSST_GEN_002.stap_get_crs_study');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END stap_get_crs_study;
148:
169: RETURN v_ret_val;
170: END;
171: EXCEPTION
172: WHEN OTHERS THEN
173: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
174: FND_MESSAGE.SET_TOKEN('NAME','IGSST_GEN_002.stap_get_govt_ou_cd');
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END stap_get_govt_ou_cd;
170: END;
171: EXCEPTION
172: WHEN OTHERS THEN
173: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
174: FND_MESSAGE.SET_TOKEN('NAME','IGSST_GEN_002.stap_get_govt_ou_cd');
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END stap_get_govt_ou_cd;
178:
304: RETURN v_ret_val;
305: END;
306: EXCEPTION
307: WHEN OTHERS THEN
308: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
309: FND_MESSAGE.SET_TOKEN('NAME','IGSST_GEN_002.stap_get_new_hgh_edu');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception;
312: END stap_get_new_hgh_edu;
305: END;
306: EXCEPTION
307: WHEN OTHERS THEN
308: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
309: FND_MESSAGE.SET_TOKEN('NAME','IGSST_GEN_002.stap_get_new_hgh_edu');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception;
312: END stap_get_new_hgh_edu;
313:
444: RAISE;
445: END;
446: EXCEPTION
447: WHEN OTHERS THEN
448: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
449: FND_MESSAGE.SET_TOKEN('NAME','IGSST_GEN_002.stap_get_pcc_pe_dtl');
450: IGS_GE_MSG_STACK.ADD;
451: App_Exception.Raise_Exception;
452: END stap_get_pcc_pe_dtl;
445: END;
446: EXCEPTION
447: WHEN OTHERS THEN
448: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
449: FND_MESSAGE.SET_TOKEN('NAME','IGSST_GEN_002.stap_get_pcc_pe_dtl');
450: IGS_GE_MSG_STACK.ADD;
451: App_Exception.Raise_Exception;
452: END stap_get_pcc_pe_dtl;
453:
619: NULL);
620: END;
621: EXCEPTION
622: WHEN OTHERS THEN
623: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
624: FND_MESSAGE.SET_TOKEN('NAME','IGSST_GEN_002.stapl_ins_log_message');
625: IGS_GE_MSG_STACK.ADD;
626: App_Exception.Raise_Exception;
627: END stapl_ins_log_message;
620: END;
621: EXCEPTION
622: WHEN OTHERS THEN
623: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
624: FND_MESSAGE.SET_TOKEN('NAME','IGSST_GEN_002.stapl_ins_log_message');
625: IGS_GE_MSG_STACK.ADD;
626: App_Exception.Raise_Exception;
627: END stapl_ins_log_message;
628: BEGIN -- this routine returns all the person details
632: v_sex;
633: -- raise an exception if no person record found
634: IF (c_get_person_dtls%NOTFOUND) THEN
635: CLOSE c_get_person_dtls;
636: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
637: IGS_GE_MSG_STACK.ADD;
638: App_Exception.Raise_Exception;
639: gv_other_detail := 'Parm:'
640: || ' p_person_id-' || TO_CHAR(p_person_id)
1330: p_govt_disability := v_govt_disability;
1331: END;
1332: EXCEPTION
1333: WHEN OTHERS THEN
1334: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1335: FND_MESSAGE.SET_TOKEN('NAME','IGSST_GEN_002.stap_get_person_data');
1336: IGS_GE_MSG_STACK.ADD;
1337: App_Exception.Raise_Exception;
1338: END stap_get_person_data;
1331: END;
1332: EXCEPTION
1333: WHEN OTHERS THEN
1334: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1335: FND_MESSAGE.SET_TOKEN('NAME','IGSST_GEN_002.stap_get_person_data');
1336: IGS_GE_MSG_STACK.ADD;
1337: App_Exception.Raise_Exception;
1338: END stap_get_person_data;
1339: