eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_UNIT_OFR_OPT_PKG

Line 3005: sarakshi 11-Sep-2003 Enh#3052452, Added call to igs_ps_unit_ofr_opt_pkg.check_constraints

3001: Purpose :
3002: Known limitations,enhancements,remarks:
3003: Change History (in reverse chronological order)
3004: Who When What
3005: sarakshi 11-Sep-2003 Enh#3052452, Added call to igs_ps_unit_ofr_opt_pkg.check_constraints
3006: for validating default_enroll_flag.
3007: vvutukur 19-Aug-2003 Enh#3045069.PSP Enh Build. Added call to igs_ps_unit_ofr_opt_pkg.check_constraints
3008: for validating not_multiple_section_flag.
3009: ********************************************************************************************* */

Line 3007: vvutukur 19-Aug-2003 Enh#3045069.PSP Enh Build. Added call to igs_ps_unit_ofr_opt_pkg.check_constraints

3003: Change History (in reverse chronological order)
3004: Who When What
3005: sarakshi 11-Sep-2003 Enh#3052452, Added call to igs_ps_unit_ofr_opt_pkg.check_constraints
3006: for validating default_enroll_flag.
3007: vvutukur 19-Aug-2003 Enh#3045069.PSP Enh Build. Added call to igs_ps_unit_ofr_opt_pkg.check_constraints
3008: for validating not_multiple_section_flag.
3009: ********************************************************************************************* */
3010: BEGIN
3011:

Line 3014: IF igs_ps_unit_ofr_opt_pkg.get_pk_for_validation ( x_unit_cd => p_usec_rec.unit_cd,

3010: BEGIN
3011:
3012: IF p_insert_update = 'I' THEN
3013: /* Check for Unique Key Validation */
3014: IF igs_ps_unit_ofr_opt_pkg.get_pk_for_validation ( x_unit_cd => p_usec_rec.unit_cd,
3015: x_version_number => p_usec_rec.version_number,
3016: x_cal_type => l_c_cal_type,
3017: x_ci_sequence_number => l_n_seq_num,
3018: x_location_cd => p_usec_rec.location_cd,

Line 3030: igs_ps_unit_ofr_opt_pkg.check_constraints('NOT_MULTIPLE_SECTION_FLAG',p_usec_rec.not_multiple_section_flag);

3026: /* Check for Check Constraints */
3027:
3028: --Validate whether the column not_multiple_section_flag has value other than 'Y' or 'N'.
3029: BEGIN
3030: igs_ps_unit_ofr_opt_pkg.check_constraints('NOT_MULTIPLE_SECTION_FLAG',p_usec_rec.not_multiple_section_flag);
3031: EXCEPTION
3032: WHEN OTHERS THEN
3033: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N',
3034: 'NOT_MULTIPLE_SECTION_FLAG',

Line 3042: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'UNIT_CLASS', p_usec_rec.unit_class );

3038: END;
3039:
3040: -- Unit Class should be in Upper Case
3041: BEGIN
3042: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'UNIT_CLASS', p_usec_rec.unit_class );
3043: EXCEPTION
3044: WHEN OTHERS THEN
3045: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE', 'UNIT_CLASS', 'LEGACY_TOKENS', TRUE);
3046: p_usec_rec.status := 'E';

Line 3056: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'GRADING_SCHEMA_CD', p_usec_rec.grading_schema_cd );

3052: p_usec_rec.status := 'E';
3053: END IF;
3054:
3055: BEGIN
3056: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'GRADING_SCHEMA_CD', p_usec_rec.grading_schema_cd );
3057: EXCEPTION
3058: WHEN OTHERS THEN
3059: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE', 'USEC_GRADING_SCHM_CD', 'LEGACY_TOKENS', TRUE);
3060: p_usec_rec.status := 'E';

Line 3064: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'LOCATION_CD', p_usec_rec.location_cd );

3060: p_usec_rec.status := 'E';
3061: END;
3062:
3063: BEGIN
3064: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'LOCATION_CD', p_usec_rec.location_cd );
3065: EXCEPTION
3066: WHEN OTHERS THEN
3067: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE', 'LOCATION_CD', 'LEGACY_TOKENS', TRUE);
3068: p_usec_rec.status := 'E';

Line 3072: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'UNIT_QUOTA', p_usec_rec.unit_quota );

3068: p_usec_rec.status := 'E';
3069: END;
3070:
3071: BEGIN
3072: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'UNIT_QUOTA', p_usec_rec.unit_quota );
3073: EXCEPTION
3074: WHEN OTHERS THEN
3075: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999', 'UNIT_QUOTA', 'LEGACY_TOKENS', TRUE);
3076: p_usec_rec.status := 'E';

Line 3081: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'UNIT_QUOTA_RESERVED_PLACES', p_usec_rec.unit_quota_reserved_places );

3077: END;
3078:
3079: IF p_usec_rec.unit_quota_reserved_places IS NOT NULL THEN
3080: BEGIN
3081: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'UNIT_QUOTA_RESERVED_PLACES', p_usec_rec.unit_quota_reserved_places );
3082: EXCEPTION
3083: WHEN OTHERS THEN
3084: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999', 'UNIT_QUOTA_RESERVED_PLACES', 'LEGACY_TOKENS', TRUE);
3085: p_usec_rec.status := 'E';

Line 3090: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'CI_SEQUENCE_NUMBER', l_n_seq_num );

3086: END;
3087: END IF;
3088:
3089: BEGIN
3090: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'CI_SEQUENCE_NUMBER', l_n_seq_num );
3091: EXCEPTION
3092: WHEN OTHERS THEN
3093: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999999', 'CAL_SEQ_NUM', 'LEGACY_TOKENS', TRUE);
3094: p_usec_rec.status := 'E';

Line 3098: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'GRADING_SCHEMA_PRCDNCE_IND', p_usec_rec.grading_schema_prcdnce_ind );

3094: p_usec_rec.status := 'E';
3095: END;
3096:
3097: BEGIN
3098: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'GRADING_SCHEMA_PRCDNCE_IND', p_usec_rec.grading_schema_prcdnce_ind );
3099: EXCEPTION
3100: WHEN OTHERS THEN
3101: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'GRADING_SCHEMA_PRCDNCE_IND', 'LEGACY_TOKENS', TRUE);
3102: p_usec_rec.status := 'E';

Line 3106: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'IVRS_AVAILABLE_IND', p_usec_rec.ivrs_available_ind );

3102: p_usec_rec.status := 'E';
3103: END;
3104:
3105: BEGIN
3106: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'IVRS_AVAILABLE_IND', p_usec_rec.ivrs_available_ind );
3107: EXCEPTION
3108: WHEN OTHERS THEN
3109: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'IVRS_AVAILABLE_IND', 'LEGACY_TOKENS', TRUE);
3110: p_usec_rec.status := 'E';

Line 3114: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'OFFERED_IND', p_usec_rec.offered_ind );

3110: p_usec_rec.status := 'E';
3111: END;
3112:
3113: BEGIN
3114: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'OFFERED_IND', p_usec_rec.offered_ind );
3115: EXCEPTION
3116: WHEN OTHERS THEN
3117: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'OFFERED_IND', 'LEGACY_TOKENS', TRUE);
3118: p_usec_rec.status := 'E';

Line 3122: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'NON_STD_USEC_IND', p_usec_rec.non_std_usec_ind );

3118: p_usec_rec.status := 'E';
3119: END;
3120:
3121: BEGIN
3122: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'NON_STD_USEC_IND', p_usec_rec.non_std_usec_ind );
3123: EXCEPTION
3124: WHEN OTHERS THEN
3125: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'NON_STD_USEC_IND', 'LEGACY_TOKENS', TRUE);
3126: p_usec_rec.status := 'E';

Line 3130: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'AUDITABLE_IND', p_usec_rec.auditable_ind );

3126: p_usec_rec.status := 'E';
3127: END;
3128:
3129: BEGIN
3130: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'AUDITABLE_IND', p_usec_rec.auditable_ind );
3131: EXCEPTION
3132: WHEN OTHERS THEN
3133: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'AUDITABLE_IND', 'LEGACY_TOKENS', TRUE);
3134: p_usec_rec.status := 'E';

Line 3138: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'AUDIT_PERMISSION_IND', p_usec_rec.audit_permission_ind );

3134: p_usec_rec.status := 'E';
3135: END;
3136:
3137: BEGIN
3138: igs_ps_unit_ofr_opt_pkg.check_constraints ( 'AUDIT_PERMISSION_IND', p_usec_rec.audit_permission_ind );
3139: EXCEPTION
3140: WHEN OTHERS THEN
3141: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'AUDIT_PERMISSION_IND', 'LEGACY_TOKENS', TRUE);
3142: p_usec_rec.status := 'E';

Line 3206: igs_ps_unit_ofr_opt_pkg.check_constraints('DEFAULT_ENROLL_FLAG',p_usec_rec.default_enroll_flag);

3202: END IF;
3203:
3204: --Validate default enroll flag
3205: BEGIN
3206: igs_ps_unit_ofr_opt_pkg.check_constraints('DEFAULT_ENROLL_FLAG',p_usec_rec.default_enroll_flag);
3207: EXCEPTION
3208: WHEN OTHERS THEN
3209: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','DEFAULT_ENROLL_FLAG','LEGACY_TOKENS',TRUE);
3210: p_usec_rec.status :='E';

Line 3854: p_usec_rec.call_number := igs_ps_unit_ofr_opt_pkg.get_call_number( l_c_cal_type, l_n_seq_num);

3850: --Set the value of the call_number if the profile option is AUTO
3851:
3852: IF l_insert_update = 'I' THEN
3853: IF FND_PROFILE.VALUE('IGS_PS_CALL_NUMBER') = 'AUTO' THEN
3854: p_usec_rec.call_number := igs_ps_unit_ofr_opt_pkg.get_call_number( l_c_cal_type, l_n_seq_num);
3855: END IF;
3856:
3857: INSERT INTO igs_ps_unit_ofr_opt_all
3858: (unit_cd,

Line 4087: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN

4083: END IF;
4084: END IF;
4085:
4086: /* Check for Foreign Key Constraints */
4087: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
4088: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
4089: p_usec_rec.status := 'E';
4090: END IF;
4091:

Line 4672: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN

4668: END IF;
4669: END IF;
4670:
4671: /* Check for Foreign Key Constraints */
4672: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
4673: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
4674: p_usec_rec.status := 'E';
4675: END IF;
4676:

Line 5321: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN

5317: p_usec_rec.status :='E';
5318: END;
5319: END IF;
5320:
5321: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
5322: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
5323: p_usec_rec.status := 'E';
5324: END IF;
5325:

Line 5819: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN

5815: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'USEC_GRADING_SCHM', 'LEGACY_TOKENS', FALSE);
5816: p_usec_gs_rec.status := 'E';
5817: END IF;
5818:
5819: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
5820: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
5821: p_usec_gs_rec.status := 'E';
5822: END IF;
5823: END validate_db_cons;

Line 6386: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN

6382:
6383: /* Validate FK Constraints */
6384:
6385: -- Check for the existence of Unit Section
6386: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
6387: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
6388: p_uso_rec.status := 'E';
6389: END IF;
6390:

Line 8552: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (l_n_uoo_id ) THEN

8548: fnd_message.set_name('IGS','IGS_PS_INS_PERSON_NUMBER');
8549: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', fnd_message.get, NULL, FALSE);
8550: p_uso_ins_rec.status := 'E';
8551: END IF;
8552: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (l_n_uoo_id ) THEN
8553: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
8554: p_uso_ins_rec.status := 'E';
8555: END IF;
8556: