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_VALIDATE_GENERIC_PKG dependencies on IGS_PS_VALIDATE_LGCY_PKG

Line 41: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN

37: p_usec_notes_rec.status := 'E';
38: END IF;
39:
40: --Check if the unit section is NOT_OFFERED
41: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN
42: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );
43: fnd_msg_pub.add;
44: p_usec_notes_rec.status := 'E';
45: END IF;

Line 93: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN

89:
90: BEGIN
91:
92: --Check if the unit section is NOT_OFFERED
93: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN
94: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );
95: fnd_msg_pub.add;
96: p_usec_assmnt_rec.status := 'E';
97: END IF;

Line 124: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'BUILDING_CODE', 'LEGACY_TOKENS', FALSE);

120: IF p_n_building_id IS NOT NULL THEN
121: OPEN c_building(p_n_building_id,p_usec_assmnt_rec.exam_location_cd);
122: FETCH c_building INTO l_c_var;
123: IF c_building%NOTFOUND THEN
124: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'BUILDING_CODE', 'LEGACY_TOKENS', FALSE);
125: p_usec_assmnt_rec.status := 'E';
126: END IF;
127: CLOSE c_building;
128: END IF;

Line 134: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'ROOM_CODE', 'LEGACY_TOKENS', FALSE);

130: IF p_n_building_id IS NOT NULL AND p_n_room_id IS NOT NULL THEN
131: OPEN c_room(p_n_room_id,p_n_building_id);
132: FETCH c_room INTO l_c_var;
133: IF c_room%NOTFOUND THEN
134: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'ROOM_CODE', 'LEGACY_TOKENS', FALSE);
135: p_usec_assmnt_rec.status := 'E';
136: END IF;
137: CLOSE c_room;
138: END IF;

Line 178: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN

174: p_tch_rsp_ovrd_rec.status := 'E';
175: END IF;
176:
177: --Check if the unit section is NOT_OFFERED
178: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN
179: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );
180: fnd_msg_pub.add;
181: p_tch_rsp_ovrd_rec.status := 'E';
182: END IF;

Line 215: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'FINAL_FORMULA_QTY', 'LEGACY_TOKENS', FALSE);

211:
212: BEGIN
213: IF p_as_us_ai_group_rec.final_formula_code IN ('ATLEAST_N', 'BEST_N') THEN
214: IF p_as_us_ai_group_rec.final_formula_qty IS NULL THEN
215: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'FINAL_FORMULA_QTY', 'LEGACY_TOKENS', FALSE);
216: p_as_us_ai_group_rec.status := 'E';
217: END IF;
218: END IF;
219:

Line 222: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'FINAL_WEIGHT_QTY', 'LEGACY_TOKENS', FALSE);

218: END IF;
219:
220: IF p_as_us_ai_group_rec.final_formula_code IN ('ATLEAST_N', 'BEST_N','WEIGHTED_AVERAGE') THEN
221: IF p_as_us_ai_group_rec.final_weight_qty IS NULL THEN
222: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'FINAL_WEIGHT_QTY', 'LEGACY_TOKENS', FALSE);
223: p_as_us_ai_group_rec.status := 'E';
224: END IF;
225: END IF;
226:

Line 229: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'MIDTERM_FORMULA_QTY', 'LEGACY_TOKENS', FALSE);

225: END IF;
226:
227: IF (p_as_us_ai_group_rec.midterm_formula_code IS NOT NULL) AND (p_as_us_ai_group_rec.midterm_formula_code IN ('ATLEAST_N', 'BEST_N')) THEN
228: IF p_as_us_ai_group_rec.midterm_formula_qty IS NULL THEN
229: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'MIDTERM_FORMULA_QTY', 'LEGACY_TOKENS', FALSE);
230: p_as_us_ai_group_rec.status := 'E';
231: END IF;
232: END IF;
233:

Line 236: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'MIDTERM_WEIGHT_QTY', 'LEGACY_TOKENS', FALSE);

232: END IF;
233:
234: IF (p_as_us_ai_group_rec.midterm_formula_code IS NOT NULL) AND (p_as_us_ai_group_rec.midterm_formula_code IN ('ATLEAST_N', 'BEST_N','WEIGHTED_AVERAGE')) THEN
235: IF p_as_us_ai_group_rec.midterm_weight_qty IS NULL THEN
236: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'MIDTERM_WEIGHT_QTY', 'LEGACY_TOKENS', FALSE);
237: p_as_us_ai_group_rec.status := 'E';
238: END IF;
239: END IF;
240:

Line 244: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'FINAL_FORMULA_QTY', 'LEGACY_TOKENS', FALSE);

240:
241:
242: --Final formula qty cannot have value when final formula code is null
243: IF p_as_us_ai_group_rec.final_formula_qty IS NOT NULL AND p_as_us_ai_group_rec.final_formula_code IS NULL THEN
244: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'FINAL_FORMULA_QTY', 'LEGACY_TOKENS', FALSE);
245: p_as_us_ai_group_rec.status := 'E';
246: END IF;
247:
248: --Final weight qty cannot have value when final formula code is null

Line 250: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'FINAL_WEIGHT_QTY', 'LEGACY_TOKENS', FALSE);

246: END IF;
247:
248: --Final weight qty cannot have value when final formula code is null
249: IF p_as_us_ai_group_rec.final_weight_qty IS NOT NULL AND p_as_us_ai_group_rec.final_formula_code IS NULL THEN
250: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'FINAL_WEIGHT_QTY', 'LEGACY_TOKENS', FALSE);
251: p_as_us_ai_group_rec.status := 'E';
252: END IF;
253:
254: --Midterm weight qty cannot have value when Midterm formula code is null

Line 256: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'MIDTERM_WEIGHT_QTY', 'LEGACY_TOKENS', FALSE);

252: END IF;
253:
254: --Midterm weight qty cannot have value when Midterm formula code is null
255: IF p_as_us_ai_group_rec.midterm_weight_qty IS NOT NULL AND p_as_us_ai_group_rec.midterm_formula_code IS NULL THEN
256: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'MIDTERM_WEIGHT_QTY', 'LEGACY_TOKENS', FALSE);
257: p_as_us_ai_group_rec.status := 'E';
258: END IF;
259:
260: --Midterm formula qty cannot have value when Midterm formula code is null

Line 262: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'MIDTERM_FORMULA_QTY', 'LEGACY_TOKENS', FALSE);

258: END IF;
259:
260: --Midterm formula qty cannot have value when Midterm formula code is null
261: IF p_as_us_ai_group_rec.midterm_formula_qty IS NOT NULL AND p_as_us_ai_group_rec.midterm_formula_code IS NULL THEN
262: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'MIDTERM_FORMULA_QTY', 'LEGACY_TOKENS', FALSE);
263: p_as_us_ai_group_rec.status := 'E';
264: END IF;
265:
266:

Line 270: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'FINAL_FORMULA_CODE', 'LEGACY_TOKENS', FALSE);

266:
267:
268: IF (p_as_us_ai_group_rec.final_formula_code IS NOT NULL) AND (p_as_us_ai_group_rec.final_formula_code NOT IN ('ATLEAST_N', 'BEST_N','WEIGHTED_AVERAGE')) THEN
269: p_as_us_ai_group_rec.status := 'E';
270: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'FINAL_FORMULA_CODE', 'LEGACY_TOKENS', FALSE);
271: END IF;
272:
273: IF (p_as_us_ai_group_rec.midterm_formula_code IS NOT NULL) AND (p_as_us_ai_group_rec.midterm_formula_code NOT IN ('ATLEAST_N', 'BEST_N','WEIGHTED_AVERAGE')) THEN
274: p_as_us_ai_group_rec.status := 'E';

Line 275: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'MIDTERM_FORMULA_CODE', 'LEGACY_TOKENS', FALSE);

271: END IF;
272:
273: IF (p_as_us_ai_group_rec.midterm_formula_code IS NOT NULL) AND (p_as_us_ai_group_rec.midterm_formula_code NOT IN ('ATLEAST_N', 'BEST_N','WEIGHTED_AVERAGE')) THEN
274: p_as_us_ai_group_rec.status := 'E';
275: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'MIDTERM_FORMULA_CODE', 'LEGACY_TOKENS', FALSE);
276: END IF;
277:
278: --Check if enrollment exists against a unit section then import is not allowed
279: OPEN cur_usec(p_n_uoo_id) ;

Line 303: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN

299: p_as_us_ai_group_rec.status := 'E';
300: END IF;
301:
302: --Check if the unit section is NOT_OFFERED
303: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN
304: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );
305: fnd_msg_pub.add;
306: p_as_us_ai_group_rec.status := 'E';
307: END IF;

Line 401: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'MIDTERM_MANDATORY_TYPE_CD', 'LEGACY_TOKENS', FALSE);

397: BEGIN
398:
399: IF (p_unitass_item_rec.midterm_mandatory_type_code IS NOT NULL) AND (p_unitass_item_rec.midterm_mandatory_type_code NOT IN ('MANDATORY', 'MANDATORY_PASS','OPTIONAL')) THEN
400: p_unitass_item_rec.status := 'E';
401: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'MIDTERM_MANDATORY_TYPE_CD', 'LEGACY_TOKENS', FALSE);
402: END IF;
403:
404: IF (p_unitass_item_rec.final_mandatory_type_code IS NOT NULL) AND (p_unitass_item_rec.final_mandatory_type_code NOT IN ('MANDATORY', 'MANDATORY_PASS','OPTIONAL')) THEN
405: p_unitass_item_rec.status := 'E';

Line 406: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'FINAL_MANDATORY_TYPE_CD', 'LEGACY_TOKENS', FALSE);

402: END IF;
403:
404: IF (p_unitass_item_rec.final_mandatory_type_code IS NOT NULL) AND (p_unitass_item_rec.final_mandatory_type_code NOT IN ('MANDATORY', 'MANDATORY_PASS','OPTIONAL')) THEN
405: p_unitass_item_rec.status := 'E';
406: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'FINAL_MANDATORY_TYPE_CD', 'LEGACY_TOKENS', FALSE);
407: END IF;
408:
409: --If midterm_mandatory_type_code is not null then MIDTERM_WEIGHT_QTY is mandatory.
410: IF p_unitass_item_rec.midterm_mandatory_type_code IS NOT NULL THEN

Line 412: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'MIDTERM_WEIGHT_QTY', 'LEGACY_TOKENS', FALSE);

408:
409: --If midterm_mandatory_type_code is not null then MIDTERM_WEIGHT_QTY is mandatory.
410: IF p_unitass_item_rec.midterm_mandatory_type_code IS NOT NULL THEN
411: IF p_unitass_item_rec.midterm_weight_qty_item IS NULL THEN
412: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'MIDTERM_WEIGHT_QTY', 'LEGACY_TOKENS', FALSE);
413: p_unitass_item_rec.status := 'E';
414: END IF;
415: END IF;
416:

Line 420: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'FINAL_WEIGHT_QTY', 'LEGACY_TOKENS', FALSE);

416:
417: --If final_mandatory_type_code is not null then FINAL_WEIGHT_QTY is mandatory.
418: IF p_unitass_item_rec.final_mandatory_type_code IS NOT NULL THEN
419: IF p_unitass_item_rec.final_weight_qty_item IS NULL THEN
420: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'FINAL_WEIGHT_QTY', 'LEGACY_TOKENS', FALSE);
421: p_unitass_item_rec.status := 'E';
422: END IF;
423: END IF;
424:

Line 428: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'MIDTERM_WEIGHT_QTY_ITEM', 'LEGACY_TOKENS', FALSE);

424:
425:
426: --Midterm weight qty cannot have value when Midterm mandatory Type code is null
427: IF p_unitass_item_rec.midterm_weight_qty_item IS NOT NULL AND p_unitass_item_rec.midterm_mandatory_type_code IS NULL THEN
428: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'MIDTERM_WEIGHT_QTY_ITEM', 'LEGACY_TOKENS', FALSE);
429: p_unitass_item_rec.status := 'E';
430: END IF;
431:
432: --Final weight qty cannot have value when Final mandatory Type code is null

Line 434: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'FINAL_WEIGHT_QTY_ITEM', 'LEGACY_TOKENS', FALSE);

430: END IF;
431:
432: --Final weight qty cannot have value when Final mandatory Type code is null
433: IF p_unitass_item_rec.final_weight_qty_item IS NOT NULL AND p_unitass_item_rec.final_mandatory_type_code IS NULL THEN
434: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'FINAL_WEIGHT_QTY_ITEM', 'LEGACY_TOKENS', FALSE);
435: p_unitass_item_rec.status := 'E';
436: END IF;
437:
438:

Line 457: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'GRADINGS_SCHEMA_CD', 'LEGACY_TOKENS', FALSE);

453: IF NVL (l_approved, 'N') = 'Y' THEN
454: OPEN cur_grading_approved(p_unitass_item_rec.unit_cd,p_unitass_item_rec.version_number,l_cur_assessment_id.assessment_type,p_unitass_item_rec.grading_schema_cd,p_unitass_item_rec.gs_version_number);
455: FETCH cur_grading_approved INTO l_c_var;
456: IF cur_grading_approved%NOTFOUND THEN
457: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'GRADINGS_SCHEMA_CD', 'LEGACY_TOKENS', FALSE);
458: p_unitass_item_rec.status := 'E';
459: END IF;
460: CLOSE cur_grading_approved;
461: ELSE

Line 465: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'GRADINGS_SCHEMA_CD', 'LEGACY_TOKENS', FALSE);

461: ELSE
462: OPEN cur_grading_assess(p_unitass_item_rec.grading_schema_cd,p_unitass_item_rec.gs_version_number);
463: FETCH cur_grading_assess INTO l_c_var;
464: IF cur_grading_assess%NOTFOUND THEN
465: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'GRADINGS_SCHEMA_CD', 'LEGACY_TOKENS', FALSE);
466: p_unitass_item_rec.status := 'E';
467: END IF;
468: CLOSE cur_grading_assess;
469: END IF;

Line 663: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN

659:
660: BEGIN
661:
662: --Check if the unit section is NOT_OFFERED
663: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN
664: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );
665: fnd_msg_pub.add;
666: p_uso_clas_meet_rec.status := 'E';
667: END IF;

Line 673: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);

669: --Validation on selection of
670: OPEN cur_usec;
671: FETCH cur_usec INTO cur_usec_rec;
672: IF cur_usec%NOTFOUND THEN
673: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
674: p_uso_clas_meet_rec.status := 'E';
675: END IF;
676: CLOSE cur_usec;
677:

Line 1276: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN

1272:
1273: BEGIN
1274:
1275: --Check if the unit section is NOT_OFFERED
1276: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN
1277: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );
1278: fnd_msg_pub.add;
1279: p_usec_x_grpmem.status := 'E';
1280: END IF;

Line 1287: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);

1283: --Validation on selection of
1284: OPEN cur_usec;
1285: FETCH cur_usec INTO cur_usec_rec;
1286: IF cur_usec%NOTFOUND THEN
1287: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);
1288: p_usec_x_grpmem.status := 'E';
1289: END IF;
1290: CLOSE cur_usec;
1291:

Line 2371: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN

2367:
2368: BEGIN
2369:
2370: --Check if the unit section is NOT_OFFERED
2371: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN
2372: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );
2373: fnd_msg_pub.add;
2374: p_uso_fclt_rec.status := 'E';
2375: END IF;

Line 2432: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN

2428: c_category_rec c_category%ROWTYPE;
2429: BEGIN
2430:
2431: --Check if the unit section is NOT_OFFERED
2432: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN
2433: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );
2434: fnd_msg_pub.add;
2435: p_usec_cat_rec.status := 'E';
2436: END IF;

Line 2479: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN

2475: p_usec_rsv_rec.status := 'E';
2476: END IF;
2477:
2478: --Check if the unit section is NOT_OFFERED
2479: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN
2480: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );
2481: fnd_msg_pub.add;
2482: p_usec_rsv_rec.status := 'E';
2483: END IF;

Line 2497: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'PRIORITY_ORDER', 'LEGACY_TOKENS', FALSE);

2493: CLOSE c_rsv_allow;
2494:
2495: IF p_insert_update = 'I' THEN
2496: IF p_usec_rsv_rec.priority_order IS NULL THEN
2497: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'PRIORITY_ORDER', 'LEGACY_TOKENS', FALSE);
2498: p_usec_rsv_rec.status := 'E';
2499: END IF;
2500: END IF;
2501:

Line 2586: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);

2582: IF p_usec_rsv_rec.priority_value = 'PERSON_GRP' THEN
2583: OPEN c_pgrp (p_usec_rsv_rec.preference_code);
2584: FETCH c_pgrp INTO c_pgrp_rec;
2585: IF c_pgrp%NOTFOUND THEN
2586: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);
2587: p_usec_rsv_rec.status := 'E';
2588: END IF;
2589: CLOSE c_pgrp;
2590: END IF;

Line 2597: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);

2593: IF p_usec_rsv_rec.priority_value = 'ORG_UNIT' THEN
2594: OPEN c_org (p_usec_rsv_rec.preference_code);
2595: FETCH c_org INTO c_org_rec;
2596: IF c_org%NOTFOUND THEN
2597: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);
2598: p_usec_rsv_rec.status := 'E';
2599: END IF;
2600: CLOSE c_org;
2601: END IF;

Line 2609: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);

2605: IF p_usec_rsv_rec.priority_value = 'CLASS_STD' THEN
2606: OPEN c_clstd (p_usec_rsv_rec.preference_code);
2607: FETCH c_clstd INTO c_clstd_rec;
2608: IF c_clstd%NOTFOUND THEN
2609: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);
2610: p_usec_rsv_rec.status := 'E';
2611: END IF;
2612: CLOSE c_clstd;
2613: END IF;

Line 2620: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);

2616: IF p_usec_rsv_rec.priority_value = 'PROGRAM_STAGE' THEN
2617: OPEN c_pstage (p_usec_rsv_rec.preference_code);
2618: FETCH c_pstage INTO c_pstage_rec;
2619: IF c_pstage%NOTFOUND THEN
2620: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);
2621: p_usec_rsv_rec.status := 'E';
2622: END IF;
2623: CLOSE c_pstage;
2624: END IF;

Line 2631: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);

2627: IF p_usec_rsv_rec.priority_value = 'PROGRAM' THEN
2628: OPEN c_prog (p_usec_rsv_rec.preference_code,p_usec_rsv_rec.preference_version);
2629: FETCH c_prog INTO c_prog_rec;
2630: IF c_prog%NOTFOUND THEN
2631: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);
2632: p_usec_rsv_rec.status := 'E';
2633: END IF;
2634: CLOSE c_prog;
2635: END IF;

Line 2642: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);

2638: IF p_usec_rsv_rec.priority_value = 'UNIT_SET' THEN
2639: OPEN c_unit_set (p_usec_rsv_rec.preference_code,p_usec_rsv_rec.preference_version);
2640: FETCH c_unit_set INTO c_unit_set_rec;
2641: IF c_unit_set%NOTFOUND THEN
2642: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);
2643: p_usec_rsv_rec.status := 'E';
2644: END IF;
2645: CLOSE c_unit_set;
2646: END IF;

Line 2722: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);

2718: IF p_usec_wlst_rec.priority_value = 'ORG_UNIT' THEN
2719: OPEN c_org (p_usec_wlst_rec.preference_code);
2720: FETCH c_org INTO c_org_rec;
2721: IF c_org%NOTFOUND THEN
2722: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);
2723: p_usec_wlst_rec.status := 'E';
2724: END IF;
2725: CLOSE c_org;
2726: END IF;

Line 2734: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);

2730: IF p_usec_wlst_rec.priority_value = 'CLASS_STD' THEN
2731: OPEN c_clstd (p_usec_wlst_rec.preference_code);
2732: FETCH c_clstd INTO c_clstd_rec;
2733: IF c_clstd%NOTFOUND THEN
2734: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);
2735: p_usec_wlst_rec.status := 'E';
2736: END IF;
2737: CLOSE c_clstd;
2738: END IF;

Line 2745: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);

2741: IF p_usec_wlst_rec.priority_value = 'PROGRAM_STAGE' THEN
2742: OPEN c_pstage (p_usec_wlst_rec.preference_code);
2743: FETCH c_pstage INTO c_pstage_rec;
2744: IF c_pstage%NOTFOUND THEN
2745: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);
2746: p_usec_wlst_rec.status := 'E';
2747: END IF;
2748: CLOSE c_pstage;
2749: END IF;

Line 2756: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);

2752: IF p_usec_wlst_rec.priority_value = 'PROGRAM' THEN
2753: OPEN c_prog (p_usec_wlst_rec.preference_code,p_usec_wlst_rec.preference_version);
2754: FETCH c_prog INTO c_prog_rec;
2755: IF c_prog%NOTFOUND THEN
2756: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);
2757: p_usec_wlst_rec.status := 'E';
2758: END IF;
2759: CLOSE c_prog;
2760: END IF;

Line 2767: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);

2763: IF p_usec_wlst_rec.priority_value = 'UNIT_SET' THEN
2764: OPEN c_unit_set (p_usec_wlst_rec.preference_code,p_usec_wlst_rec.preference_version);
2765: FETCH c_unit_set INTO c_unit_set_rec;
2766: IF c_unit_set%NOTFOUND THEN
2767: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'PREFERENCE_CODE', 'LEGACY_TOKENS', FALSE);
2768: p_usec_wlst_rec.status := 'E';
2769: END IF;
2770: CLOSE c_unit_set;
2771: END IF;

Line 2822: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN

2818: p_usec_wlst_rec.status := 'E';
2819: END IF;
2820:
2821: --Check if the unit section is NOT_OFFERED
2822: IF NOT igs_ps_validate_lgcy_pkg.check_not_offered_usec_status(p_n_uoo_id) THEN
2823: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );
2824: fnd_msg_pub.add;
2825: p_usec_wlst_rec.status := 'E';
2826: END IF;

Line 2852: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'PRIORITY_NUMBER', 'LEGACY_TOKENS', FALSE);

2848: CLOSE c_wlst_allow;
2849:
2850: IF p_insert_update = 'I' THEN
2851: IF p_usec_wlst_rec.priority_number IS NULL THEN
2852: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'PRIORITY_NUMBER', 'LEGACY_TOKENS', FALSE);
2853: p_usec_wlst_rec.status := 'E';
2854: END IF;
2855: END IF;
2856: