DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_UNIT_REF_CD_PKG

Line 7604: IF igs_ps_unit_ref_cd_pkg.get_uk_for_validation(p_ref_cd_rec.unit_cd,

7600:
7601: BEGIN
7602: -- Unique Key Validation
7603: IF p_ref_cd_rec.gen_ref_flag = 'Y' THEN -- if generic reference code
7604: IF igs_ps_unit_ref_cd_pkg.get_uk_for_validation(p_ref_cd_rec.unit_cd,
7605: p_ref_cd_rec.version_number,
7606: p_ref_cd_rec.reference_cd_type) THEN
7607: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'UNIT_REFERENCE_CD','LEGACY_TOKENS', FALSE);
7608: p_ref_cd_rec.status := 'W';

Line 7626: igs_ps_unit_ref_cd_pkg.check_constraints('UNIT_CD', p_ref_cd_rec.unit_cd);

7622: END IF;
7623:
7624: -- Check Constraints: Unit Code Should be in Upper Case
7625: BEGIN
7626: igs_ps_unit_ref_cd_pkg.check_constraints('UNIT_CD', p_ref_cd_rec.unit_cd);
7627: EXCEPTION
7628: WHEN OTHERS THEN
7629: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE', 'UNIT_CD','LEGACY_TOKENS', TRUE);
7630: p_ref_cd_rec.status := 'E';

Line 7635: igs_ps_unit_ref_cd_pkg.check_constraints('REFERENCE_CD', p_ref_cd_rec.reference_cd);

7631: END;
7632:
7633: -- Check Constraints: Reference Code Should be in Upper Case
7634: BEGIN
7635: igs_ps_unit_ref_cd_pkg.check_constraints('REFERENCE_CD', p_ref_cd_rec.reference_cd);
7636: EXCEPTION
7637: WHEN OTHERS THEN
7638: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE', 'REFERENCE_CD','LEGACY_TOKENS', TRUE);
7639: p_ref_cd_rec.status := 'E';

Line 7644: igs_ps_unit_ref_cd_pkg.check_constraints('REFERENCE_CD_TYPE', p_ref_cd_rec.reference_cd_type);

7640: END;
7641:
7642: -- Check Constraints: Reference Code Type Should be in Upper Case
7643: BEGIN
7644: igs_ps_unit_ref_cd_pkg.check_constraints('REFERENCE_CD_TYPE', p_ref_cd_rec.reference_cd_type);
7645: EXCEPTION
7646: WHEN OTHERS THEN
7647: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE', 'REFERENCE_CD_TYPE','LEGACY_TOKENS', TRUE);
7648: p_ref_cd_rec.status := 'E';