APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_USEC_REF_PKG

Line 4286: igs_ps_usec_ref_pkg.check_constraints ( 'EXCLUDE_FROM_MAX_CP_LIMIT', p_usec_rec.exclude_from_max_cp_limit);

4282: END IF;
4283:
4284: IF p_usec_rec.exclude_from_max_cp_limit IS NOT NULL THEN
4285: BEGIN
4286: igs_ps_usec_ref_pkg.check_constraints ( 'EXCLUDE_FROM_MAX_CP_LIMIT', p_usec_rec.exclude_from_max_cp_limit);
4287: EXCEPTION
4288: WHEN OTHERS THEN
4289: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'EXCLUDE_FROM_MAX_CP_LIMIT', 'LEGACY_TOKENS', TRUE);
4290: p_usec_rec.status := 'E';

Line 4664: IF igs_ps_usec_ref_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN

4660: PROCEDURE validate_ref_db_cons ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,p_insert_update VARCHAR2 ) AS
4661: BEGIN
4662: IF p_insert_update = 'I' THEN
4663: /* Check for Unique Key Constraints */
4664: IF igs_ps_usec_ref_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
4665: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'UNIT_SEC_REF', 'LEGACY_TOKENS', FALSE);
4666: p_usec_rec.status := 'W';
4667: RETURN;
4668: END IF;

Line 4681: igs_ps_usec_ref_pkg.check_constraints ( 'REFERENCE_SUBTITLE_MOD_FLAG', p_usec_rec.reference_subtitle_mod_flag);

4677:
4678:
4679: IF p_usec_rec.reference_subtitle_mod_flag IS NOT NULL THEN
4680: BEGIN
4681: igs_ps_usec_ref_pkg.check_constraints ( 'REFERENCE_SUBTITLE_MOD_FLAG', p_usec_rec.reference_subtitle_mod_flag);
4682: EXCEPTION
4683: WHEN OTHERS THEN
4684: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'REFERENCE_SUBTITLE_MOD_FLAG', 'LEGACY_TOKENS', TRUE);
4685: p_usec_rec.status := 'E';

Line 4691: igs_ps_usec_ref_pkg.check_constraints ( 'REFERENCE_CLASS_SCH_EXCL_FLAG', p_usec_rec.reference_class_sch_excl_flag);

4687: END IF;
4688:
4689: IF p_usec_rec.reference_class_sch_excl_flag IS NOT NULL THEN
4690: BEGIN
4691: igs_ps_usec_ref_pkg.check_constraints ( 'REFERENCE_CLASS_SCH_EXCL_FLAG', p_usec_rec.reference_class_sch_excl_flag);
4692: EXCEPTION
4693: WHEN OTHERS THEN
4694: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'REFERENCE_CLASS_SCH_EXCL_FLAG', 'LEGACY_TOKENS', TRUE);
4695: p_usec_rec.status := 'E';

Line 4701: igs_ps_usec_ref_pkg.check_constraints ( 'REFERENCE_REC_EXCLUSION_FLAG', p_usec_rec.reference_rec_exclusion_flag);

4697: END IF;
4698:
4699: IF p_usec_rec.reference_rec_exclusion_flag IS NOT NULL THEN
4700: BEGIN
4701: igs_ps_usec_ref_pkg.check_constraints ( 'REFERENCE_REC_EXCLUSION_FLAG', p_usec_rec.reference_rec_exclusion_flag);
4702: EXCEPTION
4703: WHEN OTHERS THEN
4704: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'REFERENCE_REC_EXCLUSION_FLAG', 'LEGACY_TOKENS', TRUE);
4705: p_usec_rec.status := 'E';

Line 7721: IF NOT igs_ps_usec_ref_pkg.get_pk_for_validation(l_n_usec_ref_id) THEN

7717: END IF;
7718: CLOSE c_res_flag;
7719:
7720: -- Foreign Key Validation : Unit Section doesn't exists
7721: IF NOT igs_ps_usec_ref_pkg.get_pk_for_validation(l_n_usec_ref_id) THEN
7722: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS',
7723: igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_SECTION','LEGACY_TOKENS') || ' ' ||
7724: igs_ps_validate_lgcy_pkg.get_lkup_meaning('REFERENCE_CD','LEGACY_TOKENS'),
7725: NULL, FALSE);