APPS.IGS_EN_SUA_API dependencies on APP_EXCEPTION

Line 712: APP_EXCEPTION.RAISE_EXCEPTION;

708: -- exceeds the maximum allowed number
709: IF (l_audit_attempts_count > l_max_auditors_allowed) THEN
710: FND_MESSAGE.SET_NAME('IGS','IGS_EN_AU_LIM_UNIT_CROSS');
711: IGS_GE_MSG_STACK.ADD;
712: APP_EXCEPTION.RAISE_EXCEPTION;
713: END IF;
714:
715: -- Get the Load calander for the passed Teaching calander.
716: OPEN cur_teach_to_load( usec_row.cal_type, usec_row.ci_sequence_number );

Line 734: APP_EXCEPTION.RAISE_EXCEPTION;

730: IF new_references.UNIT_ATTEMPT_STATUS = cst_waitlisted AND l_waitlist_ind IS NULL THEN
731: usec_row := NULL;
732: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MAX_WAIT_REACH');
733: IGS_GE_MSG_STACK.ADD;
734: APP_EXCEPTION.RAISE_EXCEPTION;
735: ELSIF ((l_waitlist_ind IS NULL OR l_waitlist_ind = 'Y') AND (new_references.UNIT_ATTEMPT_STATUS <> cst_waitlisted)) THEN
736: usec_row := NULL;
737: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MAX_ENR_REACH');
738: IGS_GE_MSG_STACK.ADD;

Line 739: APP_EXCEPTION.RAISE_EXCEPTION;

735: ELSIF ((l_waitlist_ind IS NULL OR l_waitlist_ind = 'Y') AND (new_references.UNIT_ATTEMPT_STATUS <> cst_waitlisted)) THEN
736: usec_row := NULL;
737: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MAX_ENR_REACH');
738: IGS_GE_MSG_STACK.ADD;
739: APP_EXCEPTION.RAISE_EXCEPTION;
740: END IF;
741:
742: -- get the program version
743: OPEN cur_get_prog_ver(new_references.person_id, new_references.course_cd);

Line 767: APP_EXCEPTION.RAISE_EXCEPTION;

763: IF new_references.UNIT_ATTEMPT_STATUS = cst_waitlisted THEN
764: IF nvl(v_count_wlst_Stud,0) > nvl(v_max_wlst_stud,9999) THEN
765: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MAX_WLST_STUD_RCH');
766: IGS_GE_MSG_STACK.ADD;
767: APP_EXCEPTION.RAISE_EXCEPTION;
768: END IF;
769: END IF;
770:
771: --simultaneaous wailist validations

Line 802: APP_EXCEPTION.RAISE_EXCEPTION;

798:
799: IF v_simul_term_wlst_flag IS NOT NULL THEN --restricted hence raise error
800: FND_MESSAGE.SET_NAME('IGS','IGS_EN_SIMULT_WLST_NOT_ALLWD');
801: IGS_GE_MSG_STACK.ADD;
802: APP_EXCEPTION.RAISE_EXCEPTION;
803: ELSE
804: --check at org level if simultaneous waitlist allowed
805: OPEN cur_simul_org_allwd(rec_teach_to_load.load_cal_type,new_references.uoo_id);
806: FETCH cur_simul_org_allwd INTO v_simul_org_allwd;

Line 812: APP_EXCEPTION.RAISE_EXCEPTION;

808:
809: IF v_simul_org_allwd = 'N' THEN
810: FND_MESSAGE.SET_NAME('IGS','IGS_EN_SIMULT_WLST_NOT_ALLWD');--org level
811: IGS_GE_MSG_STACK.ADD;
812: APP_EXCEPTION.RAISE_EXCEPTION;
813: END IF;
814: END IF;
815:
816: ELSE

Line 819: APP_EXCEPTION.RAISE_EXCEPTION;

815:
816: ELSE
817: FND_MESSAGE.SET_NAME('IGS','IGS_EN_SIMULT_WLST_NOT_ALLWD');--instituion level
818: IGS_GE_MSG_STACK.ADD;
819: APP_EXCEPTION.RAISE_EXCEPTION;
820: END IF;
821: END IF;
822: END IF;
823: END IF;