1: PACKAGE BODY IGS_ST_GEN_001 AS
2: /* $Header: IGSST01B.pls 120.0 2005/06/01 13:36:13 appldev noship $ */
3: -- smvk 03-Jun-2003 Bug # 2858436. Modified the cursor c_caw in the procedure stapl_check_same_award.
4: -- svenkata 25-02-02 Removed the procedure Stap_Del_Ess as part of CCR
5: -- ENCR024 .Bug # 2239050
264: END;
265: EXCEPTION
266: WHEN OTHERS THEN
267: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
268: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_001.stapl_retrieve_curr_prior_gse');
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception;
271: END stapl_retrieve_curr_prior_gse;
272:
326: END;
327: EXCEPTION
328: WHEN OTHERS THEN
329: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
330: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_001.stapl_check_curr_prior_gse');
331: IGS_GE_MSG_STACK.ADD;
332: App_Exception.Raise_Exception;
333: END stapl_check_curr_prior_gse;
334:
366: END;
367: EXCEPTION
368: WHEN OTHERS THEN
369: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
370: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_001.stapl_retrieve_prev_prior_gse');
371: IGS_GE_MSG_STACK.ADD;
372: App_Exception.Raise_Exception;
373: END stapl_retrieve_prev_prior_gse;
374:
427: END;
428: EXCEPTION
429: WHEN OTHERS THEN
430: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
431: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_001.stapl_check_prev_prior_gse');
432: IGS_GE_MSG_STACK.ADD;
433: App_Exception.Raise_Exception;
434: END stapl_check_prev_prior_gse;
435:
467: END;
468: EXCEPTION
469: WHEN OTHERS THEN
470: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
471: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_001.stapl_check_prev_crs_enrolled');
472: IGS_GE_MSG_STACK.ADD;
473: App_Exception.Raise_Exception;
474: END stapl_check_prev_crs_enrolled;
475: FUNCTION stapl_check_same_award(
522: END;
523: EXCEPTION
524: WHEN OTHERS THEN
525: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
526: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_001.stapl_check_same_award');
527: IGS_GE_MSG_STACK.ADD;
528: App_Exception.Raise_Exception;
529: END stapl_check_same_award;
530: FUNCTION stapl_check_same_equiv(
575: END;
576: EXCEPTION
577: WHEN OTHERS THEN
578: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
579: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_001.stapl_check_same_equiv');
580: IGS_GE_MSG_STACK.ADD;
581: App_Exception.Raise_Exception;
582: END stapl_check_same_equiv;
583: FUNCTION stapl_check_combined(
617: END;
618: EXCEPTION
619: WHEN OTHERS THEN
620: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
621: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_001.stapl_check_combined');
622: IGS_GE_MSG_STACK.ADD;
623: App_Exception.Raise_Exception;
624: END stapl_check_combined;
625:
678: END;
679: EXCEPTION
680: WHEN OTHERS THEN
681: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
682: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_001.stapl_check_comp_req');
683: IGS_GE_MSG_STACK.ADD;
684: App_Exception.Raise_Exception;
685: END stapl_check_comp_req;
686:
754: END;
755: EXCEPTION
756: WHEN OTHERS THEN
757: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
758: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_001.stapl_check_course_transfer');
759: IGS_GE_MSG_STACK.ADD;
760: App_Exception.Raise_Exception;
761: END stapl_check_course_transfer;
762: FUNCTION stapl_get_comm_dt(
794: END;
795: EXCEPTION
796: WHEN OTHERS THEN
797: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
798: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_001.stapl_get_comm_dt');
799: IGS_GE_MSG_STACK.ADD;
800: App_Exception.Raise_Exception;
801: END stapl_get_comm_dt;
802: BEGIN -- main
1127: IGS_GE_MSG_STACK.ADD;
1128: APP_EXCEPTION.RAISE_EXCEPTION;
1129: WHEN E_COMM_DT_NULL THEN
1130: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1131: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_001.Stap_Get_Comm_Stdnt');
1132: IGS_GE_MSG_STACK.ADD;
1133: APP_EXCEPTION.RAISE_EXCEPTION;
1134: WHEN OTHERS THEN
1135: IF c_sca%ISOPEN THEN
1145: END;
1146: EXCEPTION
1147: WHEN OTHERS THEN
1148: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1149: FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_GEN_001.stap_get_comm_stdnt');
1150: IGS_GE_MSG_STACK.ADD;
1151: App_Exception.Raise_Exception;
1152: END stap_get_comm_stdnt;
1153:
1150: IGS_GE_MSG_STACK.ADD;
1151: App_Exception.Raise_Exception;
1152: END stap_get_comm_stdnt;
1153:
1154: END IGS_ST_GEN_001;