APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_USEC_TCH_RESP_PKG

Line 1384: igs_ps_usec_tch_resp_pkg.update_row (

1380: l_new_lecture:=((c_teach_resp_rec.percentage_allocation/100)* p_usec_rec.work_load_cp_lecture);
1381: l_new_lab:=((c_teach_resp_rec.percentage_allocation/100)* p_usec_rec.work_load_cp_lab);
1382: l_new_other:=((c_teach_resp_rec.percentage_allocation/100)* p_usec_rec.work_load_other);
1383:
1384: igs_ps_usec_tch_resp_pkg.update_row (
1385: x_mode => 'R',
1386: x_rowid => c_teach_resp_rec.rowid,
1387: x_unit_section_teach_resp_id => c_teach_resp_rec.unit_section_teach_resp_id,
1388: x_instructor_id => c_teach_resp_rec.instructor_id,

Line 3363: igs_ps_usec_tch_resp_pkg.check_constraints('LEAD_INSTRUCTOR_FLAG', p_uso_ins_rec.lead_instructor_flag);

3359: END IF;
3360:
3361: -- Check constraints
3362: BEGIN
3363: igs_ps_usec_tch_resp_pkg.check_constraints('LEAD_INSTRUCTOR_FLAG', p_uso_ins_rec.lead_instructor_flag);
3364: EXCEPTION
3365: WHEN OTHERS THEN
3366: fnd_message.set_name('IGS','IGS_PS_LEAD_INSTRUCTOR_FLAG');
3367: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N',fnd_message.get, NULL,TRUE);

Line 3371: igs_ps_usec_tch_resp_pkg.check_constraints('CONFIRMED_FLAG', p_uso_ins_rec.confirmed_flag);

3367: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N',fnd_message.get, NULL,TRUE);
3368: p_uso_ins_rec.status :='E';
3369: END;
3370: BEGIN
3371: igs_ps_usec_tch_resp_pkg.check_constraints('CONFIRMED_FLAG', p_uso_ins_rec.confirmed_flag);
3372: EXCEPTION
3373: WHEN OTHERS THEN
3374: fnd_message.set_name('IGS','IGS_PS_CONFIRMED_FLAG');
3375: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N',fnd_message.get, NULL,TRUE);

Line 3393: igs_ps_usec_tch_resp_pkg.check_constraints('PERCENTAGE_ALLOCATION', p_uso_ins_rec.wl_percentage_allocation);

3389: END IF;
3390:
3391: IF p_uso_ins_rec.wl_percentage_allocation IS NOT NULL THEN
3392: BEGIN
3393: igs_ps_usec_tch_resp_pkg.check_constraints('PERCENTAGE_ALLOCATION', p_uso_ins_rec.wl_percentage_allocation);
3394: EXCEPTION
3395: WHEN OTHERS THEN
3396: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_PTS_RANGE_0_999','PERCENTAGE','LEGACY_TOKENS',TRUE);
3397: p_uso_ins_rec.status :='E';

Line 3411: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LECTURE', p_uso_ins_rec.instructional_load_lecture);

3407: END IF;
3408:
3409: IF p_uso_ins_rec.instructional_load_lecture IS NOT NULL THEN
3410: BEGIN
3411: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LECTURE', p_uso_ins_rec.instructional_load_lecture);
3412: EXCEPTION
3413: WHEN OTHERS THEN
3414: fnd_message.set_name('IGS','IGS_PS_INS_LOAD_LECTURE');
3415: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999D99',fnd_message.get, NULL,TRUE);

Line 3432: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LAB', p_uso_ins_rec.instructional_load_laboratory);

3428: END IF;
3429:
3430: IF p_uso_ins_rec.instructional_load_laboratory IS NOT NULL THEN
3431: BEGIN
3432: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LAB', p_uso_ins_rec.instructional_load_laboratory);
3433: EXCEPTION
3434: WHEN OTHERS THEN
3435: fnd_message.set_name('IGS','IGS_PS_INS_LOAD_LAB');
3436: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999D99',fnd_message.get,NULL,TRUE);

Line 3453: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD', p_uso_ins_rec.instructional_load_other);

3449: END IF;
3450:
3451: IF p_uso_ins_rec.instructional_load_other IS NOT NULL THEN
3452: BEGIN
3453: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD', p_uso_ins_rec.instructional_load_other);
3454: EXCEPTION
3455: WHEN OTHERS THEN
3456: fnd_message.set_name('IGS','IGS_PS_INS_LOAD_OTHER');
3457: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999D99',fnd_message.get,NULL,TRUE);