APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_UNIT_OFR_PAT_PKG

Line 2748: igs_ps_unit_ofr_pat_pkg.check_constraints ( 'WAITLIST_ALLOWED', p_usec_rec.waitlist_allowed);

2744:
2745: -- Check Constraints checking.
2746: IF p_usec_rec.waitlist_allowed IS NOT NULL THEN
2747: BEGIN
2748: igs_ps_unit_ofr_pat_pkg.check_constraints ( 'WAITLIST_ALLOWED', p_usec_rec.waitlist_allowed);
2749: EXCEPTION
2750: WHEN OTHERS THEN
2751: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'WAITLIST_ALLOWED', 'LEGACY_TOKENS', TRUE);
2752: p_usec_rec.status := 'E';

Line 2758: igs_ps_unit_ofr_pat_pkg.check_constraints ( 'MAX_STUDENTS_PER_WAITLIST', p_usec_rec.max_students_per_waitlist);

2754: END IF;
2755:
2756: IF p_usec_rec.max_students_per_waitlist IS NOT NULL THEN
2757: BEGIN
2758: igs_ps_unit_ofr_pat_pkg.check_constraints ( 'MAX_STUDENTS_PER_WAITLIST', p_usec_rec.max_students_per_waitlist);
2759: EXCEPTION
2760: WHEN OTHERS THEN
2761: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999', 'MAX_STUDENTS_PER_WAITLIST', 'LEGACY_TOKENS', TRUE);
2762: p_usec_rec.status := 'E';

Line 3164: IF NOT igs_ps_unit_ofr_pat_pkg.get_pk_for_validation ( x_unit_cd => p_usec_rec.unit_cd,

3160:
3161: /* Check for Foreign Key Validations */
3162:
3163: -- Check for existence of Unit Offering Pattern
3164: IF NOT igs_ps_unit_ofr_pat_pkg.get_pk_for_validation ( x_unit_cd => p_usec_rec.unit_cd,
3165: x_version_number => p_usec_rec.version_number,
3166: x_cal_type => l_c_cal_type,
3167: x_ci_sequence_number => l_n_seq_num ) THEN
3168: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_OFR_PAT', 'LEGACY_TOKENS', FALSE);

Line 5303: igs_ps_unit_ofr_pat_pkg.check_constraints ('WAITLIST_ALLOWED', p_usec_rec.usec_waitlist_allowed);

5299: END IF;
5300:
5301: IF p_usec_rec.usec_waitlist_allowed IS NOT NULL THEN
5302: BEGIN
5303: igs_ps_unit_ofr_pat_pkg.check_constraints ('WAITLIST_ALLOWED', p_usec_rec.usec_waitlist_allowed);
5304: EXCEPTION
5305: WHEN OTHERS THEN
5306: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','WAITLIST_ALLOWED', 'LEGACY_TOKENS', TRUE);
5307: p_usec_rec.status := 'E';

Line 5313: igs_ps_unit_ofr_pat_pkg.check_constraints('MAX_STUDENTS_PER_WAITLIST',p_usec_rec.usec_max_students_per_waitlist);

5309: END IF;
5310:
5311: IF p_usec_rec.usec_max_students_per_waitlist IS NOT NULL THEN
5312: BEGIN
5313: igs_ps_unit_ofr_pat_pkg.check_constraints('MAX_STUDENTS_PER_WAITLIST',p_usec_rec.usec_max_students_per_waitlist);
5314: EXCEPTION
5315: WHEN OTHERS THEN
5316: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999','MAX_STUDENTS_PER_WAITLIST','LEGACY_TOKENS',TRUE);
5317: p_usec_rec.status :='E';