DBA Data[Home] [Help]

APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_TCH_RESP_OVRD_PKG

Line 1571: IF igs_ps_tch_resp_ovrd_pkg.get_pk_for_validation ( x_unit_cd => p_tch_rsp_ovrd_rec.unit_cd,

1567: BEGIN
1568: IF (p_insert_update = 'I') THEN
1569:
1570: /* Unique Key Validation */
1571: IF igs_ps_tch_resp_ovrd_pkg.get_pk_for_validation ( x_unit_cd => p_tch_rsp_ovrd_rec.unit_cd,
1572: x_version_number => p_tch_rsp_ovrd_rec.version_number,
1573: x_cal_type=>l_c_cal_type,
1574: x_ci_sequence_number=>l_n_seq_num,
1575: x_location_cd=>p_tch_rsp_ovrd_rec.location_cd,

Line 1587: igs_ps_tch_resp_ovrd_pkg.check_constraints ( 'CI_SEQUENCE_NUMBER', l_n_seq_num);

1583: END IF;
1584:
1585: /* Validate Check Constraints */
1586: BEGIN
1587: igs_ps_tch_resp_ovrd_pkg.check_constraints ( 'CI_SEQUENCE_NUMBER', l_n_seq_num);
1588: EXCEPTION
1589: WHEN OTHERS THEN
1590: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'CI_SEQUENCE_NUMBER', 'LEGACY_TOKENS', TRUE);
1591: p_tch_rsp_ovrd_rec.status := 'E';

Line 1595: igs_ps_tch_resp_ovrd_pkg.check_constraints ( 'UOO_ID', l_n_uoo_id);

1591: p_tch_rsp_ovrd_rec.status := 'E';
1592: END;
1593:
1594: BEGIN
1595: igs_ps_tch_resp_ovrd_pkg.check_constraints ( 'UOO_ID', l_n_uoo_id);
1596: EXCEPTION
1597: WHEN OTHERS THEN
1598: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'UOO_ID', 'LEGACY_TOKENS', TRUE);
1599: p_tch_rsp_ovrd_rec.status := 'E';

Line 1603: igs_ps_tch_resp_ovrd_pkg.check_constraints ( 'PERCENTAGE', p_tch_rsp_ovrd_rec.percentage);

1599: p_tch_rsp_ovrd_rec.status := 'E';
1600: END;
1601:
1602: BEGIN
1603: igs_ps_tch_resp_ovrd_pkg.check_constraints ( 'PERCENTAGE', p_tch_rsp_ovrd_rec.percentage);
1604: EXCEPTION
1605: WHEN OTHERS THEN
1606: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_PER_0_100', null, null, TRUE);
1607: p_tch_rsp_ovrd_rec.status := 'E';