APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_UNIT_OFR_PKG

Line 2532: IF igs_ps_unit_ofr_pkg.get_pk_for_validation ( x_unit_cd => p_usec_rec.unit_cd,

2528: ********************************************************************************************* */
2529: BEGIN
2530:
2531: /* Primary Key Validation */
2532: IF igs_ps_unit_ofr_pkg.get_pk_for_validation ( x_unit_cd => p_usec_rec.unit_cd,
2533: x_version_number => p_usec_rec.version_number,
2534: x_cal_type => l_c_cal_type ) THEN
2535: p_usec_rec.status := 'K';
2536: RETURN;

Line 2541: igs_ps_unit_ofr_pkg.check_constraints ( 'UNIT_CD', p_usec_rec.unit_cd );

2537: END IF;
2538:
2539: /* Validate Check Constraints */
2540: BEGIN
2541: igs_ps_unit_ofr_pkg.check_constraints ( 'UNIT_CD', p_usec_rec.unit_cd );
2542: EXCEPTION
2543: WHEN OTHERS THEN
2544: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE', 'UNIT_CD', 'LEGACY_TOKENS', TRUE);
2545: p_usec_rec.status := 'E';

Line 2549: igs_ps_unit_ofr_pkg.check_constraints ( 'CAL_TYPE', l_c_cal_type );

2545: p_usec_rec.status := 'E';
2546: END;
2547:
2548: BEGIN
2549: igs_ps_unit_ofr_pkg.check_constraints ( 'CAL_TYPE', l_c_cal_type );
2550: EXCEPTION
2551: WHEN OTHERS THEN
2552: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'ALT_CODE', 'LEGACY_TOKENS', TRUE);
2553: p_usec_rec.status := 'E';

Line 2738: IF NOT igs_ps_unit_ofr_pkg.get_pk_for_validation ( x_unit_cd => p_usec_rec.unit_cd,

2734: p_usec_rec.status := 'E';
2735: END IF;
2736:
2737: -- Check for existence of Unit Offering
2738: IF NOT igs_ps_unit_ofr_pkg.get_pk_for_validation ( x_unit_cd => p_usec_rec.unit_cd,
2739: x_version_number => p_usec_rec.version_number,
2740: x_cal_type => l_c_cal_type ) THEN
2741: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_OFR_PAT', 'LEGACY_TOKENS', FALSE);
2742: p_usec_rec.status := 'E';