61: RETURN v_ret_val;
62: END;
63: EXCEPTION
64: WHEN OTHERS THEN
65: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
66: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_ESE.assp_val_ese_num');
67: IGS_GE_MSG_STACK.ADD;
68: END assp_val_ese_num;
69: --
62: END;
63: EXCEPTION
64: WHEN OTHERS THEN
65: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
66: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_ESE.assp_val_ese_num');
67: IGS_GE_MSG_STACK.ADD;
68: END assp_val_ese_num;
69: --
70: -- To validate for overlap in start/end times of exam sessions
157: RETURN TRUE;
158: END;
159: EXCEPTION
160: WHEN OTHERS THEN
161: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
162: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_ESE.assp_val_ese_ovrlp');
163: IGS_GE_MSG_STACK.ADD;
164: END assp_val_ese_ovrlp;
165: --
158: END;
159: EXCEPTION
160: WHEN OTHERS THEN
161: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
162: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_ESE.assp_val_ese_ovrlp');
163: IGS_GE_MSG_STACK.ADD;
164: END assp_val_ese_ovrlp;
165: --
166: -- Validate the IGS_AS_EXAM_SESSION calendar instance
225: RETURN TRUE;
226: END;
227: EXCEPTION
228: WHEN OTHERS THEN
229: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
230: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_ESE.assp_val_ese_ci');
231: IGS_GE_MSG_STACK.ADD;
232: END assp_val_ese_ci;
233: --
226: END;
227: EXCEPTION
228: WHEN OTHERS THEN
229: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
230: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_ESE.assp_val_ese_ci');
231: IGS_GE_MSG_STACK.ADD;
232: END assp_val_ese_ci;
233: --
234: -- Compare time component of two dates and start time is before end time.
257: END IF;
258: END;
259: EXCEPTION
260: WHEN OTHERS THEN
261: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
262: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_ESE.GENP_VAL_STRT_END_TM');
263: IGS_GE_MSG_STACK.ADD;
264: END GENP_VAL_STRT_END_TM;
265: END IGS_AS_VAL_ESE;
258: END;
259: EXCEPTION
260: WHEN OTHERS THEN
261: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
262: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_ESE.GENP_VAL_STRT_END_TM');
263: IGS_GE_MSG_STACK.ADD;
264: END GENP_VAL_STRT_END_TM;
265: END IGS_AS_VAL_ESE;