APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_UNIT_OFR_OPT_PKG

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

219: END IF;
220: END IF;
221: /* Validate FK Constraints */
222:
223: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
224: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
225: p_usec_rsv_rec.status := 'E';
226: END IF;
227:

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

1238: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'CATEGORY', 'LEGACY_TOKENS', FALSE);
1239: p_usec_cat_rec.status := 'E';
1240: END IF;
1241:
1242: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (l_n_uoo_id) THEN
1243: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
1244: p_usec_cat_rec.status := 'E';
1245: END IF;
1246:

Line 1611: IF NOT igs_ps_unit_ofr_opt_pkg.get_pk_for_validation ( p_tch_rsp_ovrd_rec.unit_cd, p_tch_rsp_ovrd_rec.version_number,

1607: p_tch_rsp_ovrd_rec.status := 'E';
1608: END;
1609:
1610: /* Validate FK Constraints */
1611: IF NOT igs_ps_unit_ofr_opt_pkg.get_pk_for_validation ( p_tch_rsp_ovrd_rec.unit_cd, p_tch_rsp_ovrd_rec.version_number,
1612: l_c_cal_type,l_n_seq_num,p_tch_rsp_ovrd_rec.location_cd,p_tch_rsp_ovrd_rec.unit_class) THEN
1613: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
1614: p_tch_rsp_ovrd_rec.status := 'E';
1615: END IF;

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

1618: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'ORG_UNIT', 'LEGACY_TOKENS', FALSE);
1619: p_tch_rsp_ovrd_rec.status := 'E';
1620: END IF;
1621:
1622: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
1623: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
1624: p_tch_rsp_ovrd_rec.status := 'E';
1625: END IF;
1626: END validate_db_cons;

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

2193: END IF;
2194:
2195:
2196: /* Validate FK Constraints */
2197: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
2198: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
2199: p_as_us_ai_group_rec.status := 'E';
2200: END IF;
2201:

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

2755: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'GRADING_SCHEMA', 'LEGACY_TOKENS', FALSE);
2756: p_unitass_item_rec.status := 'E';
2757: END IF;
2758:
2759: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
2760: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
2761: p_unitass_item_rec.status := 'E';
2762: END IF;
2763:

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

3566: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'USEC_MEET_WITH_CLASS_GROUP', 'LEGACY_TOKENS', FALSE);
3567: p_uso_clas_meet_rec.status := 'E';
3568: END IF;
3569:
3570: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
3571: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
3572: p_uso_clas_meet_rec.status := 'E';
3573: END IF;
3574:

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

4321: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'USEC_CROSS_LIST_GROUP', 'LEGACY_TOKENS', FALSE);
4322: p_usec_x_grpmem.status := 'E';
4323: END IF;
4324:
4325: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
4326: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
4327: p_usec_x_grpmem.status := 'E';
4328: END IF;
4329:

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

4742: END IF;
4743: END IF;
4744: /* Validate FK Constraints */
4745:
4746: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
4747: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
4748: p_usec_wlst_rec.status := 'E';
4749: END IF;
4750:

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

5446: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'CRS_NOTE_TYPE', 'LEGACY_TOKENS', FALSE);
5447: p_usec_notes_rec.status := 'E';
5448: END IF;
5449:
5450: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
5451: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
5452: p_usec_notes_rec.status := 'E';
5453: END IF;
5454:

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

5983: END IF;
5984: END IF;
5985:
5986:
5987: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
5988: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
5989: p_usec_assmnt_rec.status := 'E';
5990: END IF;
5991:

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

6434: fnd_message.set_name('IGS','IGS_PS_INS_PERSON_NUMBER');
6435: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', fnd_message.get, NULL, FALSE);
6436: p_uso_ins_rec.status := 'E';
6437: END IF;
6438: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (l_n_uoo_id ) THEN
6439: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
6440: p_uso_ins_rec.status := 'E';
6441: END IF;
6442:

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

6962: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', fnd_message.get, NULL, FALSE);
6963: p_usec_teach_resp_rec.status := 'E';
6964: END IF;
6965:
6966: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (l_n_uoo_id ) THEN
6967: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
6968: p_usec_teach_resp_rec.status := 'E';
6969: END IF;
6970:

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

7614:
7615:
7616: -- Foreign Key Checking
7617:
7618: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (l_n_uoo_id ) THEN
7619: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
7620: p_usec_sp_fee_rec.status := 'E';
7621: END IF;
7622:

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

8225: END;
8226:
8227: -- Foreign Key Checking
8228: --Check for the existence of the unit section
8229: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (l_n_uoo_id ) THEN
8230: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
8231: p_usec_plus_hr_rec.status := 'E';
8232: END IF;
8233:

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

8695: END IF;
8696:
8697: -- Foreign Key Checking
8698: --Check for the existence of the unit section
8699: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (l_n_uoo_id ) THEN
8700: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
8701: p_usec_rule_rec.status := 'E';
8702: END IF;
8703:

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

9083: END IF;
9084:
9085: -- Foreign Key Checking
9086: --Check for the existence of the unit section
9087: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (l_n_uoo_id ) THEN
9088: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
9089: p_usec_enr_dead_rec.status := 'E';
9090: END IF;
9091:

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

9662: END IF;
9663:
9664: -- Foreign Key Checking
9665: --Check for the existence of the unit section
9666: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (l_n_uoo_id ) THEN
9667: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
9668: p_usec_enr_dis_rec.status := 'E';
9669: END IF;
9670:

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

10283:
10284:
10285: -- Foreign Key Checking
10286: --Check for the existence of the unit section
10287: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (l_n_uoo_id ) THEN
10288: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
10289: p_usec_ret_rec.status := 'E';
10290: END IF;
10291:

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

10954: END IF;
10955:
10956: -- Foreign Key Checking
10957: --Check for the existence of the unit section
10958: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (l_n_uoo_id ) THEN
10959: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
10960: p_usec_ret_dtl_rec.status := 'E';
10961: END IF;
10962: