APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_UNIT_REF_CD

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';

Line 8012: INSERT INTO igs_ps_unit_ref_cd (

8008: IF p_tab_ref_cd(i).status = 'S' THEN
8009: IF p_tab_ref_cd(i).data_type = 'UNIT' THEN
8010: IF p_tab_ref_cd(i).gen_ref_flag = 'Y' THEN -- if generic reference code
8011: -- Creating the unit refernce code if the datatype is UNIT.
8012: INSERT INTO igs_ps_unit_ref_cd (
8013: UNIT_CD,
8014: VERSION_NUMBER,
8015: REFERENCE_CD_TYPE,
8016: REFERENCE_CD,

Line 8036: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_unit_ref_cd',

8032: g_n_user_id,
8033: g_n_login_id
8034: );
8035: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8036: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_unit_ref_cd',
8037: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8038: ||p_tab_ref_cd(i).version_number||' '||'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||
8039: 'reference_cd:'||p_tab_ref_cd(i).reference_cd||' '||'gen_ref_flag:'||p_tab_ref_cd(i).gen_ref_flag);
8040: END IF;