1: PACKAGE BODY IGS_AS_VAL_GSG AS
2: /* $Header: IGSAS24B.pls 115.3 2002/11/28 22:45:30 nsidana ship $ */
3:
4: --
5: -- Validate grade's gs date range is current or future
31: RETURN TRUE;
32: END IF;
33: CLOSE c_gsg ;
34: -- Check if the grading schema is obsolete.
35: v_fnc_return_value := IGS_AS_VAL_GSG.GENP_VAL_DT_RANGE(v_gsg_rec.start_dt,
36: v_gsg_rec.end_dt,
37: p_message_name);
38: IF (NOT v_fnc_return_value) THEN
39: p_message_name := 'IGS_AS_GRD_SCHEMA_OBSLETE';
44: END;
45: EXCEPTION
46: WHEN OTHERS THEN
47: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
48: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_GSG.assp_val_gs_cur_fut');
49: IGS_GE_MSG_STACK.ADD;
50: App_Exception.Raise_Exception;
51: END assp_val_gs_cur_fut;
52: --
75: END;
76: EXCEPTION
77: WHEN OTHERS THEN
78: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
79: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_GSG.genp_val_dt_range');
80: IGS_GE_MSG_STACK.ADD;
81: App_Exception.Raise_Exception;
82: END genp_val_dt_range;
83: --
118: END;
119: EXCEPTION
120: WHEN OTHERS THEN
121: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
122: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_GSG.assp_val_gsg_mrk_rng');
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: END assp_val_gsg_mrk_rng;
126: --
146: END;
147: EXCEPTION
148: WHEN OTHERS THEN
149: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
150: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_GSG.assp_val_gsg_min_max');
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153: END assp_val_gsg_min_max;
154: --
205: END;
206: EXCEPTION
207: WHEN OTHERS THEN
208: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
209: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_GSG.assp_val_gsg_m_ovrlp');
210: IGS_GE_MSG_STACK.ADD;
211: App_Exception.Raise_Exception;
212: END assp_val_gsg_m_ovrlp;
213: --
251: END;
252: EXCEPTION
253: WHEN OTHERS THEN
254: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
255: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_GSG.assp_val_gsg_dflt');
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: END assp_val_gsg_dflt;
259: --
317: END;
318: EXCEPTION
319: WHEN OTHERS THEN
320: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
321: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_GSG.assp_val_gsg_gsgt');
322: IGS_GE_MSG_STACK.ADD;
323: App_Exception.Raise_Exception;
324: END assp_val_gsg_gsgt;
325: --
348: END;
349: EXCEPTION
350: WHEN OTHERS THEN
351: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
352: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_GSG.assp_val_gsg_ssgt');
353: IGS_GE_MSG_STACK.ADD;
354: App_Exception.Raise_Exception;
355: END assp_val_gsg_ssgt;
356: END IGS_AS_VAL_GSG;
352: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_GSG.assp_val_gsg_ssgt');
353: IGS_GE_MSG_STACK.ADD;
354: App_Exception.Raise_Exception;
355: END assp_val_gsg_ssgt;
356: END IGS_AS_VAL_GSG;