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_ST_GEN_001 dependencies on APP_EXCEPTION

Line 263: App_Exception.Raise_Exception;

259: WHEN OTHERS THEN
260: IF c_gse%ISOPEN THEN
261: CLOSE c_gse;
262: END IF;
263: App_Exception.Raise_Exception;
264: END;
265: EXCEPTION
266: WHEN OTHERS THEN
267: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 270: App_Exception.Raise_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:
273: FUNCTION stapl_check_curr_prior_gse(
274: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

Line 325: App_Exception.Raise_Exception;

321: WHEN OTHERS THEN
322: IF c_api_pit%ISOPEN THEN
323: CLOSE c_api_pit;
324: END IF;
325: App_Exception.Raise_Exception;
326: END;
327: EXCEPTION
328: WHEN OTHERS THEN
329: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 332: App_Exception.Raise_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:
335: FUNCTION stapl_retrieve_prev_prior_gse(
336: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

Line 365: App_Exception.Raise_Exception;

361: WHEN OTHERS THEN
362: IF c_gse%ISOPEN THEN
363: CLOSE c_gse;
364: END IF;
365: App_Exception.Raise_Exception;
366: END;
367: EXCEPTION
368: WHEN OTHERS THEN
369: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 372: App_Exception.Raise_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:
375: FUNCTION stapl_check_prev_prior_gse(
376: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

Line 426: App_Exception.Raise_Exception;

422: WHEN OTHERS THEN
423: IF c_api_pit%ISOPEN THEN
424: CLOSE c_api_pit;
425: END IF;
426: App_Exception.Raise_Exception;
427: END;
428: EXCEPTION
429: WHEN OTHERS THEN
430: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 433: App_Exception.Raise_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:
436: FUNCTION stapl_check_prev_crs_enrolled(
437: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

Line 466: App_Exception.Raise_Exception;

462: WHEN OTHERS THEN
463: IF c_sua%ISOPEN THEN
464: CLOSE c_sua;
465: END IF;
466: App_Exception.Raise_Exception;
467: END;
468: EXCEPTION
469: WHEN OTHERS THEN
470: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 473: App_Exception.Raise_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(
476: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
477: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE,

Line 521: App_Exception.Raise_Exception;

517: WHEN OTHERS THEN
518: IF c_caw%ISOPEN THEN
519: CLOSE c_caw;
520: END IF;
521: App_Exception.Raise_Exception;
522: END;
523: EXCEPTION
524: WHEN OTHERS THEN
525: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 528: App_Exception.Raise_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(
531: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
532: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE,

Line 574: App_Exception.Raise_Exception;

570: WHEN OTHERS THEN
571: IF c_cgm%ISOPEN THEN
572: CLOSE c_cgm;
573: END IF;
574: App_Exception.Raise_Exception;
575: END;
576: EXCEPTION
577: WHEN OTHERS THEN
578: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 581: App_Exception.Raise_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(
584: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
585: p_version_nunber IGS_EN_STDNT_PS_ATT.version_number%TYPE)

Line 616: App_Exception.Raise_Exception;

612: WHEN OTHERS THEN
613: IF c_cgm_cgr_cgt%ISOPEN THEN
614: CLOSE c_cgm_cgr_cgt;
615: END IF;
616: App_Exception.Raise_Exception;
617: END;
618: EXCEPTION
619: WHEN OTHERS THEN
620: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 623: App_Exception.Raise_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:
626: FUNCTION stapl_check_comp_req(
627: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

Line 677: App_Exception.Raise_Exception;

673: WHEN OTHERS THEN
674: IF c_sua%ISOPEN THEN
675: CLOSE c_sua;
676: END IF;
677: App_Exception.Raise_Exception;
678: END;
679: EXCEPTION
680: WHEN OTHERS THEN
681: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 684: App_Exception.Raise_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:
687: FUNCTION stapl_check_course_transfer(
688: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

Line 753: App_Exception.Raise_Exception;

749: END IF;
750: IF c_cgm%ISOPEN THEN
751: CLOSE c_cgm;
752: END IF;
753: App_Exception.Raise_Exception;
754: END;
755: EXCEPTION
756: WHEN OTHERS THEN
757: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 760: App_Exception.Raise_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(
763: p_prev_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
764: p_prev_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,

Line 793: App_Exception.Raise_Exception;

789: WHEN OTHERS THEN
790: IF c_gse%ISOPEN THEN
791: CLOSE c_gse;
792: END IF;
793: App_Exception.Raise_Exception;
794: END;
795: EXCEPTION
796: WHEN OTHERS THEN
797: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 800: App_Exception.Raise_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
803: -- Routine to determine the commencing student indicator for a student's
804: -- course attempt. The logic has been determined by the DEETYA Element

Line 1128: APP_EXCEPTION.RAISE_EXCEPTION;

1124: EXCEPTION
1125: WHEN E_NO_SCA_RECORD_FOUND THEN
1126: FND_MESSAGE.SET_NAME('IGS','IGS_ST_COMM_DT_NOT_DETER');
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;

Line 1133: 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
1136: CLOSE c_sca;
1137: END IF;

Line 1144: APP_EXCEPTION.RAISE_EXCEPTION;

1140: END IF;
1141: IF c_prev_sca%ISOPEN THEN
1142: CLOSE c_prev_sca;
1143: END IF;
1144: APP_EXCEPTION.RAISE_EXCEPTION;
1145: END;
1146: EXCEPTION
1147: WHEN OTHERS THEN
1148: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 1151: App_Exception.Raise_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:
1154: END IGS_ST_GEN_001;