DBA Data[Home] [Help]

APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USEC_TCH_RESP_PKG

Line 6899: igs_ps_usec_tch_resp_pkg.check_constraints('LEAD_INSTRUCTOR_FLAG', p_usec_teach_resp_rec.lead_instructor_flag);

6895: p_usec_teach_resp_rec.status :='E';
6896: END;
6897:
6898: BEGIN
6899: igs_ps_usec_tch_resp_pkg.check_constraints('LEAD_INSTRUCTOR_FLAG', p_usec_teach_resp_rec.lead_instructor_flag);
6900: EXCEPTION
6901: WHEN OTHERS THEN
6902: fnd_message.set_name('IGS','IGS_PS_LEAD_INSTRUCTOR_FLAG');
6903: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N',fnd_message.get, NULL,TRUE);

Line 6908: igs_ps_usec_tch_resp_pkg.check_constraints('CONFIRMED_FLAG', p_usec_teach_resp_rec.confirmed_flag);

6904: p_usec_teach_resp_rec.status :='E';
6905: END;
6906:
6907: BEGIN
6908: igs_ps_usec_tch_resp_pkg.check_constraints('CONFIRMED_FLAG', p_usec_teach_resp_rec.confirmed_flag);
6909: EXCEPTION
6910: WHEN OTHERS THEN
6911: fnd_message.set_name('IGS','IGS_PS_CONFIRMED_FLAG');
6912: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N',fnd_message.get, NULL,TRUE);

Line 6918: igs_ps_usec_tch_resp_pkg.check_constraints('PERCENTAGE_ALLOCATION', p_usec_teach_resp_rec.wl_percentage_allocation);

6914: END;
6915:
6916: IF p_usec_teach_resp_rec.wl_percentage_allocation IS NOT NULL THEN
6917: BEGIN
6918: igs_ps_usec_tch_resp_pkg.check_constraints('PERCENTAGE_ALLOCATION', p_usec_teach_resp_rec.wl_percentage_allocation);
6919: EXCEPTION
6920: WHEN OTHERS THEN
6921: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_PTS_RANGE_0_999','PERCENTAGE','LEGACY_TOKENS',TRUE);
6922: p_usec_teach_resp_rec.status :='E';

Line 6928: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LECTURE', p_usec_teach_resp_rec.instructional_load_lecture);

6924: END IF;
6925:
6926: IF p_usec_teach_resp_rec.instructional_load_lecture IS NOT NULL THEN
6927: BEGIN
6928: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LECTURE', p_usec_teach_resp_rec.instructional_load_lecture);
6929: EXCEPTION
6930: WHEN OTHERS THEN
6931: fnd_message.set_name('IGS','IGS_PS_INS_LOAD_LECTURE');
6932: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999D99',fnd_message.get, NULL,TRUE);

Line 6939: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LAB', p_usec_teach_resp_rec.instructional_load_laboratory);

6935: END IF;
6936:
6937: IF p_usec_teach_resp_rec.instructional_load_laboratory IS NOT NULL THEN
6938: BEGIN
6939: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LAB', p_usec_teach_resp_rec.instructional_load_laboratory);
6940: EXCEPTION
6941: WHEN OTHERS THEN
6942: fnd_message.set_name('IGS','IGS_PS_INS_LOAD_LAB');
6943: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999D99',fnd_message.get,NULL,TRUE);

Line 6950: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD', p_usec_teach_resp_rec.instructional_load_other);

6946: END IF;
6947:
6948: IF p_usec_teach_resp_rec.instructional_load_other IS NOT NULL THEN
6949: BEGIN
6950: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD', p_usec_teach_resp_rec.instructional_load_other);
6951: EXCEPTION
6952: WHEN OTHERS THEN
6953: fnd_message.set_name('IGS','IGS_PS_INS_LOAD_OTHER');
6954: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999D99',fnd_message.get,NULL,TRUE);