DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_UNIT_DSCP_PKG

Line 1922: IF igs_ps_unit_dscp_pkg.get_pk_for_validation (

1918: PROCEDURE validate_db_cons ( p_unit_dscp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_rec_type ) AS
1919: BEGIN
1920:
1921: /* Validate PK Constraints */
1922: IF igs_ps_unit_dscp_pkg.get_pk_for_validation (
1923: x_unit_cd => p_unit_dscp_rec.unit_cd,
1924: x_version_number => p_unit_dscp_rec.version_number,
1925: x_discipline_group_cd => p_unit_dscp_rec.discipline_group_cd ) THEN
1926: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'UNIT_DISCIPLINE', 'LEGACY_TOKENS', FALSE);

Line 1933: igs_ps_unit_dscp_pkg.check_constraints ( 'UNIT_CD', p_unit_dscp_rec.unit_cd );

1929: END IF;
1930:
1931: /* Validate Check Constraints */
1932: BEGIN
1933: igs_ps_unit_dscp_pkg.check_constraints ( 'UNIT_CD', p_unit_dscp_rec.unit_cd );
1934: EXCEPTION
1935: WHEN OTHERS THEN
1936: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE', 'UNIT_CD', 'LEGACY_TOKENS', TRUE);
1937: p_unit_dscp_rec.status := 'E';

Line 1941: igs_ps_unit_dscp_pkg.check_constraints ( 'DISCIPLINE_GROUP_CD', p_unit_dscp_rec.discipline_group_cd );

1937: p_unit_dscp_rec.status := 'E';
1938: END;
1939:
1940: BEGIN
1941: igs_ps_unit_dscp_pkg.check_constraints ( 'DISCIPLINE_GROUP_CD', p_unit_dscp_rec.discipline_group_cd );
1942: EXCEPTION
1943: WHEN OTHERS THEN
1944: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE', 'DISCIPLINE_GROUP_CD', 'LEGACY_TOKENS', TRUE);
1945: p_unit_dscp_rec.status := 'E';

Line 1949: igs_ps_unit_dscp_pkg.check_constraints ( 'PERCENTAGE', p_unit_dscp_rec.percentage );

1945: p_unit_dscp_rec.status := 'E';
1946: END;
1947:
1948: BEGIN
1949: igs_ps_unit_dscp_pkg.check_constraints ( 'PERCENTAGE', p_unit_dscp_rec.percentage );
1950: EXCEPTION
1951: WHEN OTHERS THEN
1952: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_PER_0_100', null, null, TRUE);
1953: p_unit_dscp_rec.status := 'E';