APPS.IGS_PS_VAL_POS dependencies on APP_EXCEPTION

Line 49: App_Exception.Raise_Exception;

45: WHEN OTHERS THEN
46: IF (c_ac%ISOPEN) THEN
47: CLOSE c_ac;
48: END IF;
49: App_Exception.Raise_Exception;
50: END;
51: EXCEPTION
52: WHEN OTHERS THEN
53: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 56: App_Exception.Raise_Exception;

52: WHEN OTHERS THEN
53: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
54: Fnd_Message.Set_Token('NAME','IGS_PS_VAL_POS.CRSP_VAL_AC_CLOSED');
55: IGS_GE_MSG_STACK.ADD;
56: App_Exception.Raise_Exception;
57: END crsp_val_ac_closed;
58: --
59:
60: -- Validate the calendar type is categorised admission and is not closed.

Line 110: App_Exception.Raise_Exception;

106: WHEN OTHERS THEN
107: IF (c_cat%ISOPEN) THEN
108: CLOSE c_cat;
109: END IF;
110: App_Exception.Raise_Exception;
111: END;
112: EXCEPTION
113: WHEN OTHERS THEN
114: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 117: App_Exception.Raise_Exception;

113: WHEN OTHERS THEN
114: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
115: Fnd_Message.Set_Token('NAME','IGS_PS_VAL_POS.CRSP_VAL_POS_CAT');
116: IGS_GE_MSG_STACK.ADD;
117: App_Exception.Raise_Exception;
118: END crsp_val_pos_cat;
119: --
120: -- Warn if no IGS_PS_COURSE offering exists for the specified options.
121: FUNCTION crsp_val_pos_coo(

Line 177: App_Exception.Raise_Exception;

173: WHEN OTHERS THEN
174: IF (c_coo%ISOPEN) THEN
175: CLOSE c_coo;
176: END IF;
177: App_Exception.Raise_Exception;
178: END;
179: EXCEPTION
180: WHEN OTHERS THEN
181: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 184: App_Exception.Raise_Exception;

180: WHEN OTHERS THEN
181: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
182: Fnd_Message.Set_Token('NAME','IGS_PS_VAL_POS.CRSP_VAL_POS_COO');
183: IGS_GE_MSG_STACK.ADD;
184: App_Exception.Raise_Exception;
185: END crsp_val_pos_coo;
186: --
187: -- Warn if no IGS_PS_COURSE offering IGS_PS_UNIT set record exists.
188: FUNCTION crsp_val_pos_cous(

Line 238: App_Exception.Raise_Exception;

234: WHEN OTHERS THEN
235: IF (c_cous_us_uss%ISOPEN) THEN
236: CLOSE c_cous_us_uss;
237: END IF;
238: App_Exception.Raise_Exception;
239: END;
240: EXCEPTION
241: WHEN OTHERS THEN
242: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 245: App_Exception.Raise_Exception;

241: WHEN OTHERS THEN
242: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
243: Fnd_Message.Set_Token('NAME','IGS_PS_VAL_POS.CRSP_VAL_POS_COUS');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END crsp_val_pos_cous;
247: --
248: -- Validate pattern of study record is not ambiguous.
249: FUNCTION crsp_val_pos_iu(

Line 495: App_Exception.Raise_Exception;

491: END IF;
492: IF (c_pos3%ISOPEN) THEN
493: CLOSE c_pos3;
494: END IF;
495: App_Exception.Raise_Exception;
496: END;
497: EXCEPTION
498: WHEN OTHERS THEN
499: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 502: App_Exception.Raise_Exception;

498: WHEN OTHERS THEN
499: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
500: Fnd_Message.Set_Token('NAME','IGS_PS_VAL_POS.CRSP_VAL_POS_IU');
501: IGS_GE_MSG_STACK.ADD;
502: App_Exception.Raise_Exception;
503: END crsp_val_pos_iu;
504: --
505: -- Validate a least one version of the IGS_PS_UNIT set is active.
506: FUNCTION crsp_val_us_active(

Line 545: App_Exception.Raise_Exception;

541: WHEN OTHERS THEN
542: IF (c_us_uss%ISOPEN) THEN
543: CLOSE c_us_uss;
544: END IF;
545: App_Exception.Raise_Exception;
546: END;
547: EXCEPTION
548: WHEN OTHERS THEN
549: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 552: App_Exception.Raise_Exception;

548: WHEN OTHERS THEN
549: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
550: Fnd_Message.Set_Token('NAME','IGS_PS_VAL_POS.CRSP_VAL_US_ACTIVE');
551: IGS_GE_MSG_STACK.ADD;
552: App_Exception.Raise_Exception;
553: END crsp_val_us_active;
554: END IGS_PS_VAL_POS;