eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_VAL_US dependencies on APP_EXCEPTION

Line 42: App_Exception.Raise_Exception;

38: WHEN OTHERS THEN
39: IF (c_uss%ISOPEN) THEN
40: CLOSE c_uss;
41: END IF;
42: App_Exception.Raise_Exception;
43: END;
44: EXCEPTION
45: WHEN OTHERS THEN
46: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

Line 49: App_Exception.Raise_Exception;

45: WHEN OTHERS THEN
46: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
47: FND_MESSAGE.SET_TOKEN('NAME','IGS_PS_VAL_US.crsp_val_uss_closed');
48: IGS_GE_MSG_STACK.ADD;
49: App_Exception.Raise_Exception;
50: END crsp_val_uss_closed;
51: --
52: -- Validate the IGS_PS_UNIT set category closed indicator.
53: FUNCTION crsp_val_usc_closed(

Line 85: App_Exception.Raise_Exception;

81: WHEN OTHERS THEN
82: IF (c_usc%ISOPEN) THEN
83: CLOSE c_usc;
84: END IF;
85: App_Exception.Raise_Exception;
86: END;
87: EXCEPTION
88: WHEN OTHERS THEN
89: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

Line 92: App_Exception.Raise_Exception;

88: WHEN OTHERS THEN
89: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
90: FND_MESSAGE.SET_TOKEN('NAME','IGS_PS_VAL_US.crsp_val_usc_closed');
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END crsp_val_usc_closed;
94: --
95: -- Validate version dates for IGS_PS_COURSE and IGS_PS_UNIT versions.
96: FUNCTION crsp_val_ver_dt(

Line 151: App_Exception.Raise_Exception;

147: WHEN OTHERS THEN
148: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
149: FND_MESSAGE.SET_TOKEN('NAME','IGS_PS_VAL_US.crsp_val_ver_dt');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception;
152: END crsp_val_ver_dt;
153: --
154: -- Validate IGS_PS_UNIT set end date and IGS_PS_UNIT set status
155: FUNCTION crsp_val_us_end_sts(

Line 201: App_Exception.Raise_Exception;

197: WHEN OTHERS THEN
198: IF (c_uss%ISOPEN) THEN
199: CLOSE c_uss;
200: END IF;
201: App_Exception.Raise_Exception;
202: END;
203: EXCEPTION
204: WHEN OTHERS THEN
205: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

Line 208: App_Exception.Raise_Exception;

204: WHEN OTHERS THEN
205: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
206: FND_MESSAGE.SET_TOKEN('NAME','IGS_PS_VAL_US.crsp_val_us_end_sts');
207: IGS_GE_MSG_STACK.ADD;
208: App_Exception.Raise_Exception;
209: END crsp_val_us_end_sts;
210: --
211: -- Validate IGS_PS_UNIT set end date and status when active students exist
212: FUNCTION crsp_val_us_enr(

Line 257: App_Exception.Raise_Exception;

253: WHEN OTHERS THEN
254: IF (c_sca_susa%ISOPEN) THEN
255: CLOSE c_sca_susa;
256: END IF;
257: App_Exception.Raise_Exception;
258: END;
259: EXCEPTION
260: WHEN OTHERS THEN
261: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

Line 264: App_Exception.Raise_Exception;

260: WHEN OTHERS THEN
261: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
262: FND_MESSAGE.SET_TOKEN('NAME','IGS_PS_VAL_US.crsp_val_us_enr');
263: IGS_GE_MSG_STACK.ADD;
264: App_Exception.Raise_Exception;
265: END crsp_val_us_enr;
266: --
267: -- Validate IGS_PS_UNIT set status changes
268: FUNCTION crsp_val_us_status(

Line 315: App_Exception.Raise_Exception;

311: WHEN OTHERS THEN
312: IF (c_uss%ISOPEN) THEN
313: CLOSE c_uss;
314: END IF;
315: App_Exception.Raise_Exception;
316: END;
317: EXCEPTION
318: WHEN OTHERS THEN
319: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

Line 322: App_Exception.Raise_Exception;

318: WHEN OTHERS THEN
319: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
320: FND_MESSAGE.SET_TOKEN('NAME','IGS_PS_VAL_US.crsp_val_us_status');
321: IGS_GE_MSG_STACK.ADD;
322: App_Exception.Raise_Exception;
323: END crsp_val_us_status;
324: --
325: -- Validate IGS_PS_UNIT set expiry date and IGS_PS_UNIT set status
326: FUNCTION crsp_val_us_exp_sts(

Line 389: App_Exception.Raise_Exception;

385: END IF;
386: IF c_us_uss%ISOPEN THEN
387: CLOSE c_us_uss;
388: END IF;
389: App_Exception.Raise_Exception;
390: END;
391: EXCEPTION
392: WHEN OTHERS THEN
393: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

Line 396: App_Exception.Raise_Exception;

392: WHEN OTHERS THEN
393: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
394: FND_MESSAGE.SET_TOKEN('NAME','IGS_PS_VAL_US.crsp_val_us_exp_sts');
395: IGS_GE_MSG_STACK.ADD;
396: App_Exception.Raise_Exception;
397: END crsp_val_us_exp_sts;
398: --
399: -- Validate IGS_PS_UNIT set status for ins/upd/del of IGS_PS_UNIT set details
400: FUNCTION crsp_val_iud_us_dtl2(

Line 454: App_Exception.Raise_Exception;

450: END IF;
451: IF (c_old_uss%NOTFOUND) THEN
452: CLOSE c_old_uss;
453: END IF;
454: App_Exception.Raise_Exception;
455: END;
456: EXCEPTION
457: WHEN OTHERS THEN
458: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

Line 461: App_Exception.Raise_Exception;

457: WHEN OTHERS THEN
458: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
459: FND_MESSAGE.SET_TOKEN('NAME','IGS_PS_VAL_US.crsp_val_iud_us_dtl2');
460: IGS_GE_MSG_STACK.ADD;
461: App_Exception.Raise_Exception;
462: END crsp_val_iud_us_dtl2;
463: --
464: --Validate IGS_PS_UNIT set category changes
465: FUNCTION crsp_val_us_category(

Line 505: App_Exception.Raise_Exception;

501: WHEN OTHERS THEN
502: IF (c_uss%ISOPEN) THEN
503: CLOSE c_uss;
504: END IF;
505: App_Exception.Raise_Exception;
506: END;
507: EXCEPTION
508: WHEN OTHERS THEN
509: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

Line 512: App_Exception.Raise_Exception;

508: WHEN OTHERS THEN
509: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
510: FND_MESSAGE.SET_TOKEN('NAME','IGS_PS_VAL_US.crsp_val_us_category');
511: IGS_GE_MSG_STACK.ADD;
512: App_Exception.Raise_Exception;
513: END crsp_val_us_category ;
514: --
515: END IGS_PS_VAL_US;