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 FND_MSG_PUB

Line 36: fnd_msg_pub.add;

32: v_message_name VARCHAR2(30);
33: BEGIN
34: IF NOT igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_notes_rec.unit_cd, p_usec_notes_rec.version_number,v_message_name ) THEN
35: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS');
36: fnd_msg_pub.add;
37: p_usec_notes_rec.status := 'E';
38: END IF;
39:
40: --Check if the unit section is NOT_OFFERED

Line 43: fnd_msg_pub.add;

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;
46:
47: END validate_usec_notes;

Line 95: fnd_msg_pub.add;

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;
98:
99: IF p_usec_assmnt_rec.final_exam_date IS NOT NULL

Line 102: fnd_msg_pub.add;

98:
99: IF p_usec_assmnt_rec.final_exam_date IS NOT NULL
100: AND (p_d_exam_start_time IS NULL OR p_d_exam_end_time IS NULL ) THEN
101: fnd_message.set_name ('IGS','IGS_PS_XM_ST_END_TIME_ENTR' );
102: fnd_msg_pub.add;
103: p_usec_assmnt_rec.status := 'E';
104: END IF;
105:
106: IF p_d_exam_end_time IS NOT NULL AND p_d_exam_start_time IS NOT NULL

Line 110: fnd_msg_pub.add;

106: IF p_d_exam_end_time IS NOT NULL AND p_d_exam_start_time IS NOT NULL
107: AND (TO_NUMBER(TO_CHAR(p_d_exam_end_time,'HH24MI')) <
108: TO_NUMBER(TO_CHAR(p_d_exam_start_time,'HH24MI'))) THEN
109: fnd_message.set_name ( 'IGS','IGS_PS_XM_END_GR_ST_TM');
110: fnd_msg_pub.add;
111: p_usec_assmnt_rec.status := 'E';
112: END IF;
113:
114: IF (p_d_exam_start_time IS NOT NULL OR p_d_exam_end_time IS NOT NULL) AND (p_usec_assmnt_rec.final_exam_date IS NULL ) THEN

Line 116: fnd_msg_pub.add;

112: END IF;
113:
114: IF (p_d_exam_start_time IS NOT NULL OR p_d_exam_end_time IS NOT NULL) AND (p_usec_assmnt_rec.final_exam_date IS NULL ) THEN
115: fnd_message.set_name ('IGS','IGS_PS_FIN_XM_DT_ST_ET');
116: fnd_msg_pub.add;
117: p_usec_assmnt_rec.status := 'E';
118: END IF;
119:
120: IF p_n_building_id IS NOT NULL THEN

Line 147: fnd_msg_pub.add;

143: FETCH c_check_host INTO l_host;
144: IF c_check_host%FOUND THEN
145: IF l_host = 'Y' THEN
146: fnd_message.set_name('IGS','IGS_PS_CHANGE_US_HOST_REM');
147: fnd_msg_pub.add;
148: p_usec_assmnt_rec.status := 'E';
149: END IF;
150: END IF;
151: CLOSE c_check_host;

Line 173: fnd_msg_pub.add;

169: BEGIN
170: -- Check if unit status is inactive.
171: IF NOT igs_ps_val_unit.crsp_val_iud_uv_dtl(p_tch_rsp_ovrd_rec.unit_cd,p_tch_rsp_ovrd_rec.version_number,l_c_message) THEN
172: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );
173: fnd_msg_pub.add;
174: p_tch_rsp_ovrd_rec.status := 'E';
175: END IF;
176:
177: --Check if the unit section is NOT_OFFERED

Line 180: fnd_msg_pub.add;

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;
183:
184: -- Check if orgunit is inactive.

Line 187: fnd_msg_pub.add;

183:
184: -- Check if orgunit is inactive.
185: IF NOT igs_ps_val_crv.crsp_val_ou_sys_sts(p_tch_rsp_ovrd_rec.org_unit_cd,p_tch_rsp_ovrd_rec.ou_start_dt,l_c_message) THEN
186: fnd_message.set_name ( 'IGS', 'IGS_PS_ORGUNIT_STATUS_INACTIV' );
187: fnd_msg_pub.add;
188: p_tch_rsp_ovrd_rec.status := 'E';
189: END IF;
190: END validate_tch_rsp_ovrd;
191:

Line 283: fnd_msg_pub.add;

279: OPEN cur_usec(p_n_uoo_id) ;
280: FETCH cur_usec INTO l_c_var;
281: IF cur_usec%FOUND THEN
282: fnd_message.set_name ( 'IGS', 'IGS_PS_ENR_EXISTS_NO_IMPORT' );
283: fnd_msg_pub.add;
284: p_as_us_ai_group_rec.status := 'E';
285: END IF;
286: CLOSE cur_usec;
287:

Line 291: fnd_msg_pub.add;

287:
288: --check if location code is closed.
289: IF NOT igs_ps_val_uoo.crsp_val_loc_cd(p_as_us_ai_group_rec.location_cd,l_c_message) THEN
290: fnd_message.set_name ( 'IGS', l_c_message );
291: fnd_msg_pub.add;
292: p_as_us_ai_group_rec.status := 'E';
293: END IF;
294:
295: -- Check if unit status is inactive.

Line 298: fnd_msg_pub.add;

294:
295: -- Check if unit status is inactive.
296: IF NOT igs_ps_val_unit.crsp_val_iud_uv_dtl(p_as_us_ai_group_rec.unit_cd,p_as_us_ai_group_rec.version_number,l_c_message) THEN
297: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );
298: fnd_msg_pub.add;
299: p_as_us_ai_group_rec.status := 'E';
300: END IF;
301:
302: --Check if the unit section is NOT_OFFERED

Line 305: fnd_msg_pub.add;

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;
308:
309: END validate_as_us_ai_group;

Line 475: fnd_msg_pub.add;

471: --Release date should be greater than or equal to due date
472: IF p_unitass_item_rec.release_date IS NOT NULL AND p_unitass_item_rec.due_dt IS NOT NULL THEN
473: IF p_unitass_item_rec.release_date < p_unitass_item_rec.due_dt THEN
474: fnd_message.set_name ( 'IGS', 'IGS_AS_DUE_DT_LESS_RELEASE_DT' );
475: fnd_msg_pub.add;
476: p_unitass_item_rec.status := 'E';
477: END IF;
478: END IF;
479:

Line 486: fnd_msg_pub.add;

482: OPEN c_reference(p_n_uoo_id,p_unitass_item_rec.reference);
483: FETCH c_reference INTO c_reference_rec;
484: IF c_reference%FOUND THEN
485: fnd_message.set_name ( 'IGS', 'IGS_PS_REF_USAI_UNIQUE_US' );
486: fnd_msg_pub.add;
487: p_unitass_item_rec.status := 'E';
488: END IF;
489: CLOSE c_reference;
490: ELSE

Line 498: fnd_msg_pub.add;

494: OPEN c_reference(p_n_uoo_id,p_unitass_item_rec.reference);
495: FETCH c_reference INTO c_reference_rec;
496: IF c_reference%FOUND THEN
497: fnd_message.set_name ( 'IGS', 'IGS_PS_REF_USAI_UNIQUE_US' );
498: fnd_msg_pub.add;
499: p_unitass_item_rec.status := 'E';
500: END IF;
501: CLOSE c_reference;
502: END IF;

Line 512: fnd_msg_pub.add;

508: --If item is examinable then validate that reference is set
509: IF NVL (p_unitass_item_rec.reference, 'NULL666') = 'NULL666'
510: AND (igs_as_val_aiem.assp_val_ai_exmnbl (p_unitass_item_rec.assessment_id, l_c_message) OR igs_as_gen_002.assp_get_ai_s_type (p_unitass_item_rec.assessment_id) = 'ASSIGNMENT') THEN
511: fnd_message.set_name ( 'IGS', 'IGS_AS_REF_ASSITEM_EXAM' );
512: fnd_msg_pub.add;
513: p_unitass_item_rec.status := 'E';
514: END IF;
515:
516: --If the assessment item is examinable,Validate that the reference number id unique within a UOP.Else if record has not been deleted, again validate the reference number.

Line 526: fnd_msg_pub.add;

522: p_unitass_item_rec.reference,
523: p_unitass_item_rec.assessment_id,
524: l_c_message) = FALSE THEN
525: fnd_message.set_name ( 'IGS', l_c_message );
526: fnd_msg_pub.add;
527: p_unitass_item_rec.status := 'E';
528: ELSIF NVL(p_unitass_item_rec.logical_delete_dt, igs_ge_date.igsdate ('1900/01/01')) = igs_ge_date.igsdate ('1900/01/01') THEN
529: IF igs_ps_val_uai.assp_val_uai_opt_ref (
530: p_unitass_item_rec.unit_cd,

Line 540: fnd_msg_pub.add;

536: igs_as_gen_001.assp_get_ai_a_type (p_unitass_item_rec.assessment_id),
537: l_c_message) = FALSE THEN
538:
539: fnd_message.set_name ( 'IGS', l_c_message );
540: fnd_msg_pub.add;
541: p_unitass_item_rec.status := 'E';
542: END IF;
543: END IF;
544: END IF;

Line 562: fnd_msg_pub.add;

558: l_c_token_val:= fnd_message.get;
559:
560: fnd_message.set_name ('IGS', 'IGS_PS_UA_DUDT_IN_TP');
561: fnd_message.set_token ('PERIOD', l_c_token_val);
562: fnd_msg_pub.add;
563: p_unitass_item_rec.status := 'E';
564:
565: END IF;
566: ELSIF c_usec_rec.unit_section_end_date IS NULL THEN

Line 574: fnd_msg_pub.add;

570: l_c_token_val:= fnd_message.get;
571:
572: fnd_message.set_name ('IGS', 'IGS_PS_UA_DUDT_IN_TP');
573: fnd_message.set_token ('PERIOD', l_c_token_val);
574: fnd_msg_pub.add;
575: p_unitass_item_rec.status := 'E';
576:
577: END IF;
578: ELSE

Line 586: fnd_msg_pub.add;

582: l_c_token_val:= fnd_message.get;
583:
584: fnd_message.set_name ('IGS', 'IGS_PS_UA_DUDT_IN_TP');
585: fnd_message.set_token ('PERIOD', l_c_token_val);
586: fnd_msg_pub.add;
587: p_unitass_item_rec.status := 'E';
588:
589: END IF;
590: END IF;

Line 599: fnd_msg_pub.add;

595: l_c_token_val:= fnd_message.get;
596:
597: fnd_message.set_name ('IGS', 'IGS_PS_UA_DUDT_IN_TP');
598: fnd_message.set_token ('PERIOD', l_c_token_val);
599: fnd_msg_pub.add;
600: p_unitass_item_rec.status := 'E';
601: END IF;
602: END IF;
603: END IF;

Line 665: fnd_msg_pub.add;

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;
668:
669: --Validation on selection of

Line 683: fnd_msg_pub.add;

679: OPEN c_x_grpmem(p_n_uoo_id);
680: FETCH c_x_grpmem INTO c_x_grpmem_rec;
681: IF c_x_grpmem%FOUND THEN
682: fnd_message.set_name('IGS','IGS_PS_UNT_SEC_DEFINED_GRP');
683: fnd_msg_pub.add;
684: p_uso_clas_meet_rec.status := 'E';
685: END IF;
686: CLOSE c_x_grpmem;
687:

Line 699: l_c_msg := FND_MSG_PUB.GET(p_msg_index => l_n_msg_count, p_encoded => 'T');

695: l_c_msg VARCHAR2(3000);
696: l_c_msg_name fnd_new_messages.message_name%TYPE;
697: l_appl_name VARCHAR2(30);
698: BEGIN
699: l_c_msg := FND_MSG_PUB.GET(p_msg_index => l_n_msg_count, p_encoded => 'T');
700: FND_MESSAGE.SET_ENCODED (l_c_msg);
701: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED,l_appl_name, l_c_msg_name);
702: RETURN l_c_msg_name;
703: END get_msg_from_stack;

Line 781: fnd_msg_pub.add;

777: ) ;
778: EXCEPTION
779: WHEN OTHERS THEN
780: fnd_message.set_name('IGS', get_msg_from_stack(1));
781: fnd_msg_pub.add;
782: p_uso_clas_meet_rec.status := 'E';
783: END;
784:
785: END LOOP;

Line 931: fnd_msg_pub.add;

927: l_b_status := FALSE;
928: l_b_error := TRUE;
929: fnd_message.set_name ( 'IGS', 'IGS_PS_CM_NO_HOST' );
930: fnd_message.set_token('GROUP_NAME',p_class_meet_tab(i).class_meet_group_name);
931: fnd_msg_pub.add;
932: l_n_count_msg := fnd_msg_pub.count_msg;
933: ELSIF NVL(c_host_rec.cnt,0) > 1 THEN
934: l_b_status := FALSE;
935: l_b_error := TRUE;

Line 932: l_n_count_msg := fnd_msg_pub.count_msg;

928: l_b_error := TRUE;
929: fnd_message.set_name ( 'IGS', 'IGS_PS_CM_NO_HOST' );
930: fnd_message.set_token('GROUP_NAME',p_class_meet_tab(i).class_meet_group_name);
931: fnd_msg_pub.add;
932: l_n_count_msg := fnd_msg_pub.count_msg;
933: ELSIF NVL(c_host_rec.cnt,0) > 1 THEN
934: l_b_status := FALSE;
935: l_b_error := TRUE;
936: fnd_message.set_name ( 'IGS', 'IGS_PS_CM_ONLY_ONE_HOST' );

Line 937: fnd_msg_pub.add;

933: ELSIF NVL(c_host_rec.cnt,0) > 1 THEN
934: l_b_status := FALSE;
935: l_b_error := TRUE;
936: fnd_message.set_name ( 'IGS', 'IGS_PS_CM_ONLY_ONE_HOST' );
937: fnd_msg_pub.add;
938: l_n_count_msg := fnd_msg_pub.count_msg;
939: END IF;
940: IF l_b_error THEN
941: FOR j in 1..p_tab_usec_meet_with.LAST LOOP

Line 938: l_n_count_msg := fnd_msg_pub.count_msg;

934: l_b_status := FALSE;
935: l_b_error := TRUE;
936: fnd_message.set_name ( 'IGS', 'IGS_PS_CM_ONLY_ONE_HOST' );
937: fnd_msg_pub.add;
938: l_n_count_msg := fnd_msg_pub.count_msg;
939: END IF;
940: IF l_b_error THEN
941: FOR j in 1..p_tab_usec_meet_with.LAST LOOP
942: IF p_tab_usec_meet_with.EXISTS(j) THEN

Line 968: fnd_msg_pub.add;

964:
965: IF ((c_cm_grp_rec.max_ovr_group IS NOT NULL) AND (NVL(c_cm_grp_rec.max_ovr_group,0) < NVL(c_sum_enract_rec.sum_enrollment_actual,0))) THEN
966: l_b_status := FALSE;
967: fnd_message.set_name('IGS','IGS_PS_MAX_OVR_MAX');
968: fnd_msg_pub.add;
969: l_n_count_msg := fnd_msg_pub.count_msg;
970: FOR j in 1..p_tab_usec_meet_with.LAST LOOP
971: IF p_tab_usec_meet_with.EXISTS(j) THEN
972: OPEN cur_group_id(p_tab_usec_meet_with(j).class_meet_group_name,p_tab_usec_meet_with(j).teach_cal_alternate_code);

Line 969: l_n_count_msg := fnd_msg_pub.count_msg;

965: IF ((c_cm_grp_rec.max_ovr_group IS NOT NULL) AND (NVL(c_cm_grp_rec.max_ovr_group,0) < NVL(c_sum_enract_rec.sum_enrollment_actual,0))) THEN
966: l_b_status := FALSE;
967: fnd_message.set_name('IGS','IGS_PS_MAX_OVR_MAX');
968: fnd_msg_pub.add;
969: l_n_count_msg := fnd_msg_pub.count_msg;
970: FOR j in 1..p_tab_usec_meet_with.LAST LOOP
971: IF p_tab_usec_meet_with.EXISTS(j) THEN
972: OPEN cur_group_id(p_tab_usec_meet_with(j).class_meet_group_name,p_tab_usec_meet_with(j).teach_cal_alternate_code);
973: FETCH cur_group_id INTO l_cur_group_id;

Line 1153: fnd_msg_pub.add;

1149:
1150: --Cannot enter a value for Override Maximum when Enrollment Maximum is null
1151: IF ((p_uso_cm_grp_rec.max_ovr_group IS NOT NULL) AND (p_uso_cm_grp_rec.max_enr_group IS NULL)) THEN
1152: fnd_message.set_name ( 'IGS', 'IGS_PS_ENR_NULL_OVR_NOT' );
1153: fnd_msg_pub.add;
1154: p_uso_cm_grp_rec.status := 'E';
1155: END IF;
1156:
1157: --Group Override Maximum should always be greater than or equal toMaximum Enrollment for the group

Line 1160: fnd_msg_pub.add;

1156:
1157: --Group Override Maximum should always be greater than or equal toMaximum Enrollment for the group
1158: IF ((p_uso_cm_grp_rec.max_ovr_group IS NOT NULL) AND (NVL(p_uso_cm_grp_rec.max_ovr_group,0) < NVL(p_uso_cm_grp_rec.max_enr_group,0))) THEN
1159: fnd_message.set_name ( 'IGS', 'IGS_PS_OVERIDE_MIN_MAX_CP' );
1160: fnd_msg_pub.add;
1161: p_uso_cm_grp_rec.status := 'E';
1162: END IF;
1163:
1164:

Line 1198: fnd_msg_pub.add;

1194: l_message_name := 'IGS_PS_SCST_PROC';
1195: END IF;
1196:
1197: fnd_message.set_name('IGS',l_message_name);
1198: fnd_msg_pub.add;
1199: p_uso_cm_grp_rec.status := 'E';
1200: --update the schedule status to 'Rescheduling Requested', if unit section occurrence is a scheduled one.
1201: ELSIF igs_ps_usec_schedule.prgp_upd_usec_dtls
1202: (

Line 1213: fnd_msg_pub.add;

1209: p_request_id => l_request_id,
1210: p_message_name => l_message_name
1211: ) = FALSE THEN
1212: fnd_message.set_name('IGS',l_message_name);
1213: fnd_msg_pub.add;
1214: p_uso_cm_grp_rec.status := 'E';
1215: END IF;
1216: END LOOP;
1217: END IF;

Line 1278: fnd_msg_pub.add;

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;
1281:
1282:

Line 1297: fnd_msg_pub.add;

1293: OPEN c_uso_cm(p_n_uoo_id);
1294: FETCH c_uso_cm INTO c_uso_cm_rec;
1295: IF c_uso_cm%FOUND THEN
1296: fnd_message.set_name('IGS','IGS_PS_UNT_SEC_DEFINED_GRP');
1297: fnd_msg_pub.add;
1298: p_usec_x_grpmem.status := 'E';
1299: END IF;
1300: CLOSE c_uso_cm;
1301:

Line 1313: l_c_msg := FND_MSG_PUB.GET(p_msg_index => l_n_msg_count, p_encoded => 'T');

1309: l_c_msg VARCHAR2(3000);
1310: l_c_msg_name fnd_new_messages.message_name%TYPE;
1311: l_appl_name VARCHAR2(30);
1312: BEGIN
1313: l_c_msg := FND_MSG_PUB.GET(p_msg_index => l_n_msg_count, p_encoded => 'T');
1314: FND_MESSAGE.SET_ENCODED (l_c_msg);
1315: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED,l_appl_name, l_c_msg_name);
1316: RETURN l_c_msg_name;
1317: END get_msg_from_stack;

Line 1394: fnd_msg_pub.add;

1390: ) ;
1391: EXCEPTION
1392: WHEN OTHERS THEN
1393: fnd_message.set_name('IGS', get_msg_from_stack(1));
1394: fnd_msg_pub.add;
1395: p_usec_x_grpmem.status := 'E';
1396: END;
1397:
1398: END LOOP;

Line 1486: fnd_msg_pub.add;

1482: l_b_status := FALSE;
1483: l_b_error := TRUE;
1484: fnd_message.set_name ( 'IGS', 'IGS_PS_USXL_NO_PARENT' );
1485: fnd_message.set_token ( 'GROUP_NAME',p_cross_group_tab(i).usec_x_listed_group_name );
1486: fnd_msg_pub.add;
1487: l_n_count_msg := fnd_msg_pub.count_msg;
1488: ELSIF NVL(c_parent_rec.cnt,0) > 1 THEN
1489: l_b_status := FALSE;
1490: l_b_error := TRUE;

Line 1487: l_n_count_msg := fnd_msg_pub.count_msg;

1483: l_b_error := TRUE;
1484: fnd_message.set_name ( 'IGS', 'IGS_PS_USXL_NO_PARENT' );
1485: fnd_message.set_token ( 'GROUP_NAME',p_cross_group_tab(i).usec_x_listed_group_name );
1486: fnd_msg_pub.add;
1487: l_n_count_msg := fnd_msg_pub.count_msg;
1488: ELSIF NVL(c_parent_rec.cnt,0) > 1 THEN
1489: l_b_status := FALSE;
1490: l_b_error := TRUE;
1491: fnd_message.set_name ( 'IGS', 'IGS_PS_UXL_ONLY_ONE_PARENT' );

Line 1492: fnd_msg_pub.add;

1488: ELSIF NVL(c_parent_rec.cnt,0) > 1 THEN
1489: l_b_status := FALSE;
1490: l_b_error := TRUE;
1491: fnd_message.set_name ( 'IGS', 'IGS_PS_UXL_ONLY_ONE_PARENT' );
1492: fnd_msg_pub.add;
1493: l_n_count_msg := fnd_msg_pub.count_msg;
1494: END IF;
1495: IF l_b_error THEN
1496: FOR j in 1..p_tab_usec_cross_group.LAST LOOP

Line 1493: l_n_count_msg := fnd_msg_pub.count_msg;

1489: l_b_status := FALSE;
1490: l_b_error := TRUE;
1491: fnd_message.set_name ( 'IGS', 'IGS_PS_UXL_ONLY_ONE_PARENT' );
1492: fnd_msg_pub.add;
1493: l_n_count_msg := fnd_msg_pub.count_msg;
1494: END IF;
1495: IF l_b_error THEN
1496: FOR j in 1..p_tab_usec_cross_group.LAST LOOP
1497: IF p_tab_usec_cross_group.EXISTS(j) THEN

Line 1524: fnd_msg_pub.add;

1520:
1521: IF ((c_x_grp_rec.max_ovr_group IS NOT NULL) AND (NVL(c_x_grp_rec.max_ovr_group,0) < NVL(c_sum_enract_rec.sum_enrollment_actual,0))) THEN
1522: l_b_status := FALSE;
1523: fnd_message.set_name('IGS','IGS_PS_MAX_OVR_MAX');
1524: fnd_msg_pub.add;
1525: l_n_count_msg := fnd_msg_pub.count_msg;
1526: FOR j in 1..p_tab_usec_cross_group.LAST LOOP
1527: IF p_tab_usec_cross_group.EXISTS(j) THEN
1528: OPEN cur_group_id(p_tab_usec_cross_group(j).usec_x_listed_group_name,p_tab_usec_cross_group(j).teach_cal_alternate_code);

Line 1525: l_n_count_msg := fnd_msg_pub.count_msg;

1521: IF ((c_x_grp_rec.max_ovr_group IS NOT NULL) AND (NVL(c_x_grp_rec.max_ovr_group,0) < NVL(c_sum_enract_rec.sum_enrollment_actual,0))) THEN
1522: l_b_status := FALSE;
1523: fnd_message.set_name('IGS','IGS_PS_MAX_OVR_MAX');
1524: fnd_msg_pub.add;
1525: l_n_count_msg := fnd_msg_pub.count_msg;
1526: FOR j in 1..p_tab_usec_cross_group.LAST LOOP
1527: IF p_tab_usec_cross_group.EXISTS(j) THEN
1528: OPEN cur_group_id(p_tab_usec_cross_group(j).usec_x_listed_group_name,p_tab_usec_cross_group(j).teach_cal_alternate_code);
1529: FETCH cur_group_id INTO l_cur_group_id;

Line 1714: fnd_msg_pub.add;

1710:
1711: --Cannot enter a value for Override Maximum when Enrollment Maximum is null
1712: IF ((p_usec_x_grp_rec.max_ovr_group IS NOT NULL) AND (p_usec_x_grp_rec.max_enr_group IS NULL)) THEN
1713: fnd_message.set_name ( 'IGS', 'IGS_PS_ENR_NULL_OVR_NOT' );
1714: fnd_msg_pub.add;
1715: p_usec_x_grp_rec.status := 'E';
1716: END IF;
1717:
1718: --Group Override Maximum should always be greater than or equal toMaximum Enrollment for the group

Line 1721: fnd_msg_pub.add;

1717:
1718: --Group Override Maximum should always be greater than or equal toMaximum Enrollment for the group
1719: IF ((p_usec_x_grp_rec.max_ovr_group IS NOT NULL) AND (NVL(p_usec_x_grp_rec.max_ovr_group,0) < NVL(p_usec_x_grp_rec.max_enr_group,0))) THEN
1720: fnd_message.set_name ( 'IGS', 'IGS_PS_OVERIDE_MIN_MAX_CP' );
1721: fnd_msg_pub.add;
1722: p_usec_x_grp_rec.status := 'E';
1723: END IF;
1724:
1725:

Line 1743: fnd_msg_pub.add;

1739: --validation related to location_inheritance
1740: IF p_insert_update = 'U' THEN
1741: IF p_usec_x_grp_rec.location_inheritance = 'N' AND c_old_cmgrp_rec.location_inheritance ='Y' THEN
1742: Fnd_Message.Set_Name('IGS', 'IGS_PS_LOC_INHR_CANNOT_UPD');
1743: fnd_msg_pub.add;
1744: p_usec_x_grp_rec.status := 'E';
1745: END IF;
1746: END IF;
1747:

Line 1766: fnd_msg_pub.add;

1762: l_message_name := 'IGS_PS_SCST_PROC';
1763: END IF;
1764:
1765: fnd_message.set_name('IGS',l_message_name);
1766: fnd_msg_pub.add;
1767: p_usec_x_grp_rec.status := 'E';
1768: --update the schedule status to 'Rescheduling Requested', if unit section occurrence is a scheduled one.
1769: ELSIF igs_ps_usec_schedule.prgp_upd_usec_dtls
1770: (

Line 1781: fnd_msg_pub.add;

1777: p_request_id => l_request_id,
1778: p_message_name => l_message_name
1779: ) = FALSE THEN
1780: fnd_message.set_name('IGS',l_message_name);
1781: fnd_msg_pub.add;
1782: p_usec_x_grp_rec.status := 'E';
1783: END IF;
1784: END LOOP;
1785: END IF;

Line 1860: fnd_msg_pub.add;

1856: IF (rec_aig.group_midterm_weight_qty > 0) THEN
1857: IF (rec_ai.number_of_ai >= 0) THEN
1858: IF (rec_ai.sum_midterm_weight_qty = 0) THEN
1859: fnd_message.set_name ('IGS', 'IGS_AS_GRP_WEIT_GT_SUM_AI_WEIT');
1860: fnd_msg_pub.add;
1861: l_n_count_msg := fnd_msg_pub.count_msg;
1862: FOR j in 1..p_tab_as_us_ai.LAST LOOP
1863: IF p_tab_as_us_ai.EXISTS(j) THEN
1864: OPEN cur_group( p_tab_as_us_ai(j));

Line 1861: l_n_count_msg := fnd_msg_pub.count_msg;

1857: IF (rec_ai.number_of_ai >= 0) THEN
1858: IF (rec_ai.sum_midterm_weight_qty = 0) THEN
1859: fnd_message.set_name ('IGS', 'IGS_AS_GRP_WEIT_GT_SUM_AI_WEIT');
1860: fnd_msg_pub.add;
1861: l_n_count_msg := fnd_msg_pub.count_msg;
1862: FOR j in 1..p_tab_as_us_ai.LAST LOOP
1863: IF p_tab_as_us_ai.EXISTS(j) THEN
1864: OPEN cur_group( p_tab_as_us_ai(j));
1865: FETCH cur_group INTO l_cur_group;

Line 1886: fnd_msg_pub.add;

1882: IF (rec_aig.group_final_weight_qty > 0) THEN
1883: IF (rec_ai.number_of_ai >= 0) THEN
1884: IF (rec_ai.sum_final_weight_qty = 0) THEN
1885: fnd_message.set_name ('IGS', 'IGS_AS_GRP_WEIT_GT_SUM_AI_WEIT');
1886: fnd_msg_pub.add;
1887: l_n_count_msg := fnd_msg_pub.count_msg;
1888: FOR j in 1..p_tab_as_us_ai.LAST LOOP
1889: IF p_tab_as_us_ai.EXISTS(j) THEN
1890: OPEN cur_group( p_tab_as_us_ai(j));

Line 1887: l_n_count_msg := fnd_msg_pub.count_msg;

1883: IF (rec_ai.number_of_ai >= 0) THEN
1884: IF (rec_ai.sum_final_weight_qty = 0) THEN
1885: fnd_message.set_name ('IGS', 'IGS_AS_GRP_WEIT_GT_SUM_AI_WEIT');
1886: fnd_msg_pub.add;
1887: l_n_count_msg := fnd_msg_pub.count_msg;
1888: FOR j in 1..p_tab_as_us_ai.LAST LOOP
1889: IF p_tab_as_us_ai.EXISTS(j) THEN
1890: OPEN cur_group( p_tab_as_us_ai(j));
1891: FETCH cur_group INTO l_cur_group;

Line 1911: fnd_msg_pub.add;

1907: --
1908: IF ((rec_ai.number_of_default_ai < rec_aig.group_final_formula_qty) OR
1909: (rec_ai.number_of_default_ai < rec_aig.group_midterm_formula_qty)) THEN
1910: fnd_message.set_name ('IGS', 'IGS_AS_NOT_ENOUGH_DFLT_AI');
1911: fnd_msg_pub.add;
1912: l_n_count_msg := fnd_msg_pub.count_msg;
1913: FOR j in 1..p_tab_as_us_ai.LAST LOOP
1914: IF p_tab_as_us_ai.EXISTS(j) THEN
1915: OPEN cur_group( p_tab_as_us_ai(j));

Line 1912: l_n_count_msg := fnd_msg_pub.count_msg;

1908: IF ((rec_ai.number_of_default_ai < rec_aig.group_final_formula_qty) OR
1909: (rec_ai.number_of_default_ai < rec_aig.group_midterm_formula_qty)) THEN
1910: fnd_message.set_name ('IGS', 'IGS_AS_NOT_ENOUGH_DFLT_AI');
1911: fnd_msg_pub.add;
1912: l_n_count_msg := fnd_msg_pub.count_msg;
1913: FOR j in 1..p_tab_as_us_ai.LAST LOOP
1914: IF p_tab_as_us_ai.EXISTS(j) THEN
1915: OPEN cur_group( p_tab_as_us_ai(j));
1916: FETCH cur_group INTO l_cur_group;

Line 1979: fnd_msg_pub.add;

1975: CLOSE c_tro_perc_sum;
1976: IF (c_tro_perc_sum_rec.percentage) <> 100 THEN
1977: l_b_status:= FALSE;
1978: fnd_message.set_name ( 'IGS', 'IGS_PS_PRCALLOC_TEACH_RESP' );
1979: fnd_msg_pub.add;
1980: l_n_count_msg := fnd_msg_pub.count_msg;
1981: FOR j in 1..p_tab_tch_rsp_ovrd.LAST LOOP
1982: OPEN c_uoo_id (p_tab_tch_rsp_ovrd(j));
1983: FETCH c_uoo_id INTO c_uoo_id_rec;

Line 1980: l_n_count_msg := fnd_msg_pub.count_msg;

1976: IF (c_tro_perc_sum_rec.percentage) <> 100 THEN
1977: l_b_status:= FALSE;
1978: fnd_message.set_name ( 'IGS', 'IGS_PS_PRCALLOC_TEACH_RESP' );
1979: fnd_msg_pub.add;
1980: l_n_count_msg := fnd_msg_pub.count_msg;
1981: FOR j in 1..p_tab_tch_rsp_ovrd.LAST LOOP
1982: OPEN c_uoo_id (p_tab_tch_rsp_ovrd(j));
1983: FETCH c_uoo_id INTO c_uoo_id_rec;
1984: CLOSE c_uoo_id;

Line 2071: fnd_msg_pub.add;

2067: IF c_usec_rsvprfc_ser%NOTFOUND THEN
2068: l_b_status:= FALSE;
2069: fnd_message.set_name ( 'IGS', 'IGS_EN_PREF_REQ_PRIOR');
2070: fnd_message.set_token('PRIORITY',rec_priority_id.priority_value);
2071: fnd_msg_pub.add;
2072: l_n_count_msg := fnd_msg_pub.count_msg;
2073: FOR j in 1..p_tab_usec_rsv.LAST LOOP
2074: IF p_tab_usec_rsv.EXISTS(j) THEN
2075: OPEN c_uoo_id(p_tab_usec_rsv(j));

Line 2072: l_n_count_msg := fnd_msg_pub.count_msg;

2068: l_b_status:= FALSE;
2069: fnd_message.set_name ( 'IGS', 'IGS_EN_PREF_REQ_PRIOR');
2070: fnd_message.set_token('PRIORITY',rec_priority_id.priority_value);
2071: fnd_msg_pub.add;
2072: l_n_count_msg := fnd_msg_pub.count_msg;
2073: FOR j in 1..p_tab_usec_rsv.LAST LOOP
2074: IF p_tab_usec_rsv.EXISTS(j) THEN
2075: OPEN c_uoo_id(p_tab_usec_rsv(j));
2076: FETCH c_uoo_id INTO c_uoo_id_rec;

Line 2098: fnd_msg_pub.add;

2094: FETCH c_rsv_perc_sum INTO c_rsv_perc_sum_rec;
2095: IF (c_rsv_perc_sum_rec.percentage_reserved) > 100 THEN
2096: l_b_status:= FALSE;
2097: fnd_message.set_name ( 'IGS', 'IGS_PS_PREF_SUM_BET_0_100' );
2098: fnd_msg_pub.add;
2099: l_n_count_msg := fnd_msg_pub.count_msg;
2100: FOR j in 1..p_tab_usec_rsv.LAST LOOP
2101: IF p_tab_usec_rsv.EXISTS(j) THEN
2102: OPEN c_uoo_id(p_tab_usec_rsv(j));

Line 2099: l_n_count_msg := fnd_msg_pub.count_msg;

2095: IF (c_rsv_perc_sum_rec.percentage_reserved) > 100 THEN
2096: l_b_status:= FALSE;
2097: fnd_message.set_name ( 'IGS', 'IGS_PS_PREF_SUM_BET_0_100' );
2098: fnd_msg_pub.add;
2099: l_n_count_msg := fnd_msg_pub.count_msg;
2100: FOR j in 1..p_tab_usec_rsv.LAST LOOP
2101: IF p_tab_usec_rsv.EXISTS(j) THEN
2102: OPEN c_uoo_id(p_tab_usec_rsv(j));
2103: FETCH c_uoo_id INTO c_uoo_id_rec;

Line 2122: fnd_msg_pub.add;

2118: FOR c_usec_rsvpric_ser_rec IN c_usec_rsvpric_ser(p_tab_uoo(i)) LOOP
2119: IF l_n_counter <> c_usec_rsvpric_ser_rec.priority_order THEN
2120: l_b_status:= FALSE;
2121: fnd_message.set_name ( 'IGS', 'IGS_PS_RSV_PRI_NOT_IN_SERIES' );
2122: fnd_msg_pub.add;
2123: l_n_count_msg := fnd_msg_pub.count_msg;
2124: FOR j in 1..p_tab_usec_rsv.LAST LOOP
2125: IF p_tab_usec_rsv.EXISTS(j) THEN
2126: OPEN c_uoo_id(p_tab_usec_rsv(j));

Line 2123: l_n_count_msg := fnd_msg_pub.count_msg;

2119: IF l_n_counter <> c_usec_rsvpric_ser_rec.priority_order THEN
2120: l_b_status:= FALSE;
2121: fnd_message.set_name ( 'IGS', 'IGS_PS_RSV_PRI_NOT_IN_SERIES' );
2122: fnd_msg_pub.add;
2123: l_n_count_msg := fnd_msg_pub.count_msg;
2124: FOR j in 1..p_tab_usec_rsv.LAST LOOP
2125: IF p_tab_usec_rsv.EXISTS(j) THEN
2126: OPEN c_uoo_id(p_tab_usec_rsv(j));
2127: FETCH c_uoo_id INTO c_uoo_id_rec;

Line 2153: fnd_msg_pub.add;

2149:
2150: IF l_n_counter <> c_usec_rsvprfc_ser_rec.preference_order THEN
2151: l_b_status:= FALSE;
2152: fnd_message.set_name ( 'IGS', 'IGS_PS_RSV_PRF_NOT_IN_SERIES' );
2153: fnd_msg_pub.add;
2154: l_n_count_msg := fnd_msg_pub.count_msg;
2155: FOR j in 1..p_tab_usec_rsv.LAST LOOP
2156: IF p_tab_usec_rsv.EXISTS(j) THEN
2157: OPEN c_uoo_id(p_tab_usec_rsv(j));

Line 2154: l_n_count_msg := fnd_msg_pub.count_msg;

2150: IF l_n_counter <> c_usec_rsvprfc_ser_rec.preference_order THEN
2151: l_b_status:= FALSE;
2152: fnd_message.set_name ( 'IGS', 'IGS_PS_RSV_PRF_NOT_IN_SERIES' );
2153: fnd_msg_pub.add;
2154: l_n_count_msg := fnd_msg_pub.count_msg;
2155: FOR j in 1..p_tab_usec_rsv.LAST LOOP
2156: IF p_tab_usec_rsv.EXISTS(j) THEN
2157: OPEN c_uoo_id(p_tab_usec_rsv(j));
2158: FETCH c_uoo_id INTO c_uoo_id_rec;

Line 2244: fnd_msg_pub.add;

2240: IF c_usec_wlstprfc_ser%NOTFOUND THEN
2241: l_b_status:= FALSE;
2242: fnd_message.set_name ( 'IGS', 'IGS_EN_PREF_REQ_PRIOR');
2243: fnd_message.set_token('PRIORITY',rec_priority_id.priority_value);
2244: fnd_msg_pub.add;
2245: l_n_count_msg := fnd_msg_pub.count_msg;
2246: FOR j in 1..p_tab_usec_wlst.LAST LOOP
2247: IF p_tab_usec_wlst.EXISTS(j) THEN
2248: OPEN c_uoo_id(p_tab_usec_wlst(j));

Line 2245: l_n_count_msg := fnd_msg_pub.count_msg;

2241: l_b_status:= FALSE;
2242: fnd_message.set_name ( 'IGS', 'IGS_EN_PREF_REQ_PRIOR');
2243: fnd_message.set_token('PRIORITY',rec_priority_id.priority_value);
2244: fnd_msg_pub.add;
2245: l_n_count_msg := fnd_msg_pub.count_msg;
2246: FOR j in 1..p_tab_usec_wlst.LAST LOOP
2247: IF p_tab_usec_wlst.EXISTS(j) THEN
2248: OPEN c_uoo_id(p_tab_usec_wlst(j));
2249: FETCH c_uoo_id INTO c_uoo_id_rec;

Line 2269: fnd_msg_pub.add;

2265: FOR c_usec_wlstpric_ser_rec IN c_usec_wlstpric_ser(p_tab_uoo(i)) LOOP
2266: IF l_n_counter <> c_usec_wlstpric_ser_rec.priority_number THEN
2267: l_b_status:= FALSE;
2268: fnd_message.set_name ( 'IGS', 'IGS_PS_WLST_PRI_NOT_IN_SERIES' );
2269: fnd_msg_pub.add;
2270: l_n_count_msg := fnd_msg_pub.count_msg;
2271: FOR j in 1..p_tab_usec_wlst.LAST LOOP
2272: IF p_tab_usec_wlst.EXISTS(j) THEN
2273: OPEN c_uoo_id(p_tab_usec_wlst(j));

Line 2270: l_n_count_msg := fnd_msg_pub.count_msg;

2266: IF l_n_counter <> c_usec_wlstpric_ser_rec.priority_number THEN
2267: l_b_status:= FALSE;
2268: fnd_message.set_name ( 'IGS', 'IGS_PS_WLST_PRI_NOT_IN_SERIES' );
2269: fnd_msg_pub.add;
2270: l_n_count_msg := fnd_msg_pub.count_msg;
2271: FOR j in 1..p_tab_usec_wlst.LAST LOOP
2272: IF p_tab_usec_wlst.EXISTS(j) THEN
2273: OPEN c_uoo_id(p_tab_usec_wlst(j));
2274: FETCH c_uoo_id INTO c_uoo_id_rec;

Line 2300: fnd_msg_pub.add;

2296:
2297: IF l_n_counter <> c_usec_wlstprfc_ser_rec.preference_order THEN
2298: l_b_status:= FALSE;
2299: fnd_message.set_name ( 'IGS', 'IGS_PS_WLST_PRF_NOT_IN_SERIES' );
2300: fnd_msg_pub.add;
2301: l_n_count_msg := fnd_msg_pub.count_msg;
2302: FOR j in 1..p_tab_usec_wlst.LAST LOOP
2303: IF p_tab_usec_wlst.EXISTS(j) THEN
2304: OPEN c_uoo_id(p_tab_usec_wlst(j));

Line 2301: l_n_count_msg := fnd_msg_pub.count_msg;

2297: IF l_n_counter <> c_usec_wlstprfc_ser_rec.preference_order THEN
2298: l_b_status:= FALSE;
2299: fnd_message.set_name ( 'IGS', 'IGS_PS_WLST_PRF_NOT_IN_SERIES' );
2300: fnd_msg_pub.add;
2301: l_n_count_msg := fnd_msg_pub.count_msg;
2302: FOR j in 1..p_tab_usec_wlst.LAST LOOP
2303: IF p_tab_usec_wlst.EXISTS(j) THEN
2304: OPEN c_uoo_id(p_tab_usec_wlst(j));
2305: FETCH c_uoo_id INTO c_uoo_id_rec;

Line 2373: fnd_msg_pub.add;

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;
2376:
2377: --Facility code cannot be closed

Line 2382: fnd_msg_pub.add;

2378: OPEN cur_facility_closed( p_uso_fclt_rec.facility_code);
2379: FETCH cur_facility_closed INTO l_c_var;
2380: IF cur_facility_closed%FOUND THEN
2381: fnd_message.set_name ( 'IGS', 'IGS_PS_FACILITY_CLOSED' );
2382: fnd_msg_pub.add;
2383: p_uso_fclt_rec.status := 'E';
2384: END IF;
2385: CLOSE cur_facility_closed;
2386:

Line 2393: fnd_msg_pub.add;

2389: OPEN c_facility (p_uso_id);
2390: FETCH c_facility INTO l_c_var;
2391: IF c_facility%FOUND THEN
2392: fnd_message.set_name ( 'IGS', 'IGS_PS_SCHEDULING_IN_PROGRESS' );
2393: fnd_msg_pub.add;
2394: p_uso_fclt_rec.status := 'E';
2395: END IF;
2396: CLOSE c_facility;
2397:

Line 2434: fnd_msg_pub.add;

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;
2437:
2438: OPEN c_category(p_usec_cat_rec.unit_cat);

Line 2442: fnd_msg_pub.add;

2438: OPEN c_category(p_usec_cat_rec.unit_cat);
2439: FETCH c_category INTO c_category_rec;
2440: IF c_category%FOUND THEN
2441: fnd_message.set_name ( 'IGS', 'IGS_PS_CATEGORY_CLOSED' );
2442: fnd_msg_pub.add;
2443: p_usec_cat_rec.status := 'E';
2444: END IF;
2445: CLOSE c_category;
2446:

Line 2474: fnd_msg_pub.add;

2470:
2471: -- Check if unit status is inactive.
2472: IF NOT igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_rsv_rec.unit_cd,p_usec_rsv_rec.version_number,l_c_message) THEN
2473: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );
2474: fnd_msg_pub.add;
2475: p_usec_rsv_rec.status := 'E';
2476: END IF;
2477:
2478: --Check if the unit section is NOT_OFFERED

Line 2481: fnd_msg_pub.add;

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;
2484:
2485:

Line 2490: fnd_msg_pub.add;

2486: OPEN c_rsv_allow (p_n_uoo_id);
2487: FETCH c_rsv_allow INTO c_rsvpri_rec;
2488: IF c_rsvpri_rec.reserved_seating_allowed = 'N' THEN
2489: fnd_message.set_name ( 'IGS', 'IGS_PS_RSV_SEAT_NOT_ALLOWED' );
2490: fnd_msg_pub.add;
2491: p_usec_rsv_rec.status := 'E';
2492: END IF;
2493: CLOSE c_rsv_allow;
2494:

Line 2817: fnd_msg_pub.add;

2813:
2814: -- Check if unit status is inactive.
2815: IF NOT igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_wlst_rec.unit_cd,p_usec_wlst_rec.version_number,l_c_message) THEN
2816: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );
2817: fnd_msg_pub.add;
2818: p_usec_wlst_rec.status := 'E';
2819: END IF;
2820:
2821: --Check if the unit section is NOT_OFFERED

Line 2824: fnd_msg_pub.add;

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;
2827:
2828: --Waitlist should be allowed at section level if record exists else at pattern level such that priorities and preferences

Line 2835: fnd_msg_pub.add;

2831: FETCH c_wlst_allow INTO c_wlst_allow_rec;
2832: IF c_wlst_allow%FOUND THEN
2833: IF c_wlst_allow_rec.waitlist_allowed = 'N' THEN
2834: fnd_message.set_name ( 'IGS', 'IGS_PS_WAITLIST_NOT_ALLOWED' );
2835: fnd_msg_pub.add;
2836: p_usec_wlst_rec.status := 'E';
2837: END IF;
2838: ELSE
2839: OPEN c_wlst_allow_pat(p_n_uoo_id);

Line 2843: fnd_msg_pub.add;

2839: OPEN c_wlst_allow_pat(p_n_uoo_id);
2840: FETCH c_wlst_allow_pat INTO l_c_var;
2841: IF c_wlst_allow_pat%NOTFOUND THEN
2842: fnd_message.set_name ( 'IGS', 'IGS_PS_WAITLIST_NOT_ALLOWED' );
2843: fnd_msg_pub.add;
2844: p_usec_wlst_rec.status := 'E';
2845: END IF;
2846: CLOSE c_wlst_allow_pat;
2847: END IF;