APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_US_UNSCHED_CL_PKG

Line 8190: IF igs_ps_us_unsched_cl_pkg.get_uk_for_validation ( x_uoo_id => l_n_uoo_id,

8186: BEGIN
8187:
8188: IF p_insert_update = 'I' THEN
8189: -- Unique Key Validation
8190: IF igs_ps_us_unsched_cl_pkg.get_uk_for_validation ( x_uoo_id => l_n_uoo_id,
8191: x_activity_type_id => l_n_activity_id,
8192: x_location_cd => p_usec_plus_hr_rec.activity_location_cd,
8193: x_building_id => l_n_building_id,
8194: x_room_id => l_n_room_id ) THEN

Line 8204: igs_ps_us_unsched_cl_pkg.check_constraints('NUMBER_OF_STUDENTS', p_usec_plus_hr_rec.number_of_students);

8200:
8201: -- Check Constraints
8202:
8203: BEGIN
8204: igs_ps_us_unsched_cl_pkg.check_constraints('NUMBER_OF_STUDENTS', p_usec_plus_hr_rec.number_of_students);
8205: EXCEPTION
8206: WHEN OTHERS THEN
8207: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999999999','NUMBER_OF_STUDENTS','LEGACY_TOKENS',TRUE);
8208: p_usec_plus_hr_rec.status :='E';

Line 8212: igs_ps_us_unsched_cl_pkg.check_constraints('HOURS_PER_STUDENT', p_usec_plus_hr_rec.hours_per_student);

8208: p_usec_plus_hr_rec.status :='E';
8209: END;
8210:
8211: BEGIN
8212: igs_ps_us_unsched_cl_pkg.check_constraints('HOURS_PER_STUDENT', p_usec_plus_hr_rec.hours_per_student);
8213: EXCEPTION
8214: WHEN OTHERS THEN
8215: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D99','HOURS_PER_STUDENT','LEGACY_TOKENS',TRUE);
8216: p_usec_plus_hr_rec.status :='E';

Line 8220: igs_ps_us_unsched_cl_pkg.check_constraints('HOURS_PER_FACULTY', p_usec_plus_hr_rec.hours_per_faculty);

8216: p_usec_plus_hr_rec.status :='E';
8217: END;
8218:
8219: BEGIN
8220: igs_ps_us_unsched_cl_pkg.check_constraints('HOURS_PER_FACULTY', p_usec_plus_hr_rec.hours_per_faculty);
8221: EXCEPTION
8222: WHEN OTHERS THEN
8223: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D99','HOURS_PER_FACULTY','LEGACY_TOKENS',TRUE);
8224: p_usec_plus_hr_rec.status :='E';