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_MESSAGE

Line 35: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS');

31: ********************************************************************************************** */
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:

Line 42: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );

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;
46:

Line 94: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );

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;
98:

Line 101: fnd_message.set_name ('IGS','IGS_PS_XM_ST_END_TIME_ENTR' );

97: END IF;
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:

Line 109: fnd_message.set_name ( 'IGS','IGS_PS_XM_END_GR_ST_TM');

105:
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:

Line 115: fnd_message.set_name ('IGS','IGS_PS_FIN_XM_DT_ST_ET');

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
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:

Line 146: fnd_message.set_name('IGS','IGS_PS_CHANGE_US_HOST_REM');

142: OPEN c_check_host(p_n_uoo_id );
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;

Line 172: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );

168: l_c_message VARCHAR2(30);
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:

Line 179: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );

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;
183:

Line 186: fnd_message.set_name ( 'IGS', 'IGS_PS_ORGUNIT_STATUS_INACTIV' );

182: END IF;
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;

Line 282: fnd_message.set_name ( 'IGS', 'IGS_PS_ENR_EXISTS_NO_IMPORT' );

278: --Check if enrollment exists against a unit section then import is not allowed
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;

Line 290: fnd_message.set_name ( 'IGS', l_c_message );

286: CLOSE cur_usec;
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:

Line 297: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );

293: END IF;
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:

Line 304: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );

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;
308:

Line 474: fnd_message.set_name ( 'IGS', 'IGS_AS_DUE_DT_LESS_RELEASE_DT' );

470:
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;

Line 485: fnd_message.set_name ( 'IGS', 'IGS_PS_REF_USAI_UNIQUE_US' );

481: IF p_insert = 'I' THEN
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;

Line 497: fnd_message.set_name ( 'IGS', 'IGS_PS_REF_USAI_UNIQUE_US' );

493: IF c_action_dt_rec.reference <>p_unitass_item_rec.reference THEN
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;

Line 511: fnd_message.set_name ( 'IGS', 'IGS_AS_REF_ASSITEM_EXAM' );

507:
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:

Line 525: fnd_message.set_name ( 'IGS', l_c_message );

521: p_unitass_item_rec.sequence_number,
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 (

Line 539: fnd_message.set_name ( 'IGS', l_c_message );

535: p_unitass_item_rec.assessment_id,
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;

Line 557: fnd_message.set_name ('IGS', 'IGS_PS_USEC_EFFET_DATES');

553: OR c_usec_rec.unit_section_end_date IS NOT NULL THEN
554: IF c_usec_rec.unit_section_start_date IS NULL THEN
555: IF p_unitass_item_rec.due_dt < TRUNC (cp_st_en_dt_rec.start_dt)
556: OR p_unitass_item_rec.due_dt > TRUNC (c_usec_rec.unit_section_end_date) THEN
557: fnd_message.set_name ('IGS', 'IGS_PS_USEC_EFFET_DATES');
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);

Line 558: l_c_token_val:= fnd_message.get;

554: IF c_usec_rec.unit_section_start_date IS NULL THEN
555: IF p_unitass_item_rec.due_dt < TRUNC (cp_st_en_dt_rec.start_dt)
556: OR p_unitass_item_rec.due_dt > TRUNC (c_usec_rec.unit_section_end_date) THEN
557: fnd_message.set_name ('IGS', 'IGS_PS_USEC_EFFET_DATES');
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;

Line 560: fnd_message.set_name ('IGS', 'IGS_PS_UA_DUDT_IN_TP');

556: OR p_unitass_item_rec.due_dt > TRUNC (c_usec_rec.unit_section_end_date) THEN
557: fnd_message.set_name ('IGS', 'IGS_PS_USEC_EFFET_DATES');
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:

Line 561: fnd_message.set_token ('PERIOD', l_c_token_val);

557: fnd_message.set_name ('IGS', 'IGS_PS_USEC_EFFET_DATES');
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;

Line 569: fnd_message.set_name ('IGS', 'IGS_PS_USEC_EFFET_DATES');

565: END IF;
566: ELSIF c_usec_rec.unit_section_end_date IS NULL THEN
567: IF p_unitass_item_rec.due_dt < TRUNC (c_usec_rec.unit_section_start_date)
568: OR p_unitass_item_rec.due_dt > TRUNC (cp_st_en_dt_rec.end_dt) THEN
569: fnd_message.set_name ('IGS', 'IGS_PS_USEC_EFFET_DATES');
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);

Line 570: l_c_token_val:= fnd_message.get;

566: ELSIF c_usec_rec.unit_section_end_date IS NULL THEN
567: IF p_unitass_item_rec.due_dt < TRUNC (c_usec_rec.unit_section_start_date)
568: OR p_unitass_item_rec.due_dt > TRUNC (cp_st_en_dt_rec.end_dt) THEN
569: fnd_message.set_name ('IGS', 'IGS_PS_USEC_EFFET_DATES');
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;

Line 572: fnd_message.set_name ('IGS', 'IGS_PS_UA_DUDT_IN_TP');

568: OR p_unitass_item_rec.due_dt > TRUNC (cp_st_en_dt_rec.end_dt) THEN
569: fnd_message.set_name ('IGS', 'IGS_PS_USEC_EFFET_DATES');
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:

Line 573: fnd_message.set_token ('PERIOD', l_c_token_val);

569: fnd_message.set_name ('IGS', 'IGS_PS_USEC_EFFET_DATES');
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;

Line 581: fnd_message.set_name ('IGS', 'IGS_PS_USEC_EFFET_DATES');

577: END IF;
578: ELSE
579: IF p_unitass_item_rec.due_dt < TRUNC (c_usec_rec.unit_section_start_date)
580: OR p_unitass_item_rec.due_dt > TRUNC (c_usec_rec.unit_section_end_date) THEN
581: fnd_message.set_name ('IGS', 'IGS_PS_USEC_EFFET_DATES');
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);

Line 582: l_c_token_val:= fnd_message.get;

578: ELSE
579: IF p_unitass_item_rec.due_dt < TRUNC (c_usec_rec.unit_section_start_date)
580: OR p_unitass_item_rec.due_dt > TRUNC (c_usec_rec.unit_section_end_date) THEN
581: fnd_message.set_name ('IGS', 'IGS_PS_USEC_EFFET_DATES');
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;

Line 584: fnd_message.set_name ('IGS', 'IGS_PS_UA_DUDT_IN_TP');

580: OR p_unitass_item_rec.due_dt > TRUNC (c_usec_rec.unit_section_end_date) THEN
581: fnd_message.set_name ('IGS', 'IGS_PS_USEC_EFFET_DATES');
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:

Line 585: fnd_message.set_token ('PERIOD', l_c_token_val);

581: fnd_message.set_name ('IGS', 'IGS_PS_USEC_EFFET_DATES');
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;

Line 594: fnd_message.set_name ('IGS', 'IGS_PS_TP_DATES');

590: END IF;
591: ELSE
592: IF p_unitass_item_rec.due_dt < TRUNC (cp_st_en_dt_rec.start_dt)
593: OR p_unitass_item_rec.due_dt > TRUNC (cp_st_en_dt_rec.end_dt) THEN
594: fnd_message.set_name ('IGS', 'IGS_PS_TP_DATES');
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);

Line 595: l_c_token_val:= fnd_message.get;

591: ELSE
592: IF p_unitass_item_rec.due_dt < TRUNC (cp_st_en_dt_rec.start_dt)
593: OR p_unitass_item_rec.due_dt > TRUNC (cp_st_en_dt_rec.end_dt) THEN
594: fnd_message.set_name ('IGS', 'IGS_PS_TP_DATES');
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;

Line 597: fnd_message.set_name ('IGS', 'IGS_PS_UA_DUDT_IN_TP');

593: OR p_unitass_item_rec.due_dt > TRUNC (cp_st_en_dt_rec.end_dt) THEN
594: fnd_message.set_name ('IGS', 'IGS_PS_TP_DATES');
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;

Line 598: fnd_message.set_token ('PERIOD', l_c_token_val);

594: fnd_message.set_name ('IGS', 'IGS_PS_TP_DATES');
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;

Line 664: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );

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;
668:

Line 682: fnd_message.set_name('IGS','IGS_PS_UNT_SEC_DEFINED_GRP');

678: --This unit section should not be present in any cross listed Unit section group
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;

Line 700: FND_MESSAGE.SET_ENCODED (l_c_msg);

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;
704:

Line 701: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED,l_appl_name, l_c_msg_name);

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;
704:
705: BEGIN

Line 780: fnd_message.set_name('IGS', get_msg_from_stack(1));

776: X_CORE_INDICATOR_CODE => l_c_fetch_record_cur.core_indicator_code
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:

Line 929: fnd_message.set_name ( 'IGS', 'IGS_PS_CM_NO_HOST' );

925: CLOSE c_host;
926: IF NVL(c_host_rec.cnt,0) = 0 THEN
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

Line 930: fnd_message.set_token('GROUP_NAME',p_class_meet_tab(i).class_meet_group_name);

926: IF NVL(c_host_rec.cnt,0) = 0 THEN
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;

Line 936: fnd_message.set_name ( 'IGS', 'IGS_PS_CM_ONLY_ONE_HOST' );

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' );
937: fnd_msg_pub.add;
938: l_n_count_msg := fnd_msg_pub.count_msg;
939: END IF;
940: IF l_b_error THEN

Line 967: fnd_message.set_name('IGS','IGS_PS_MAX_OVR_MAX');

963: CLOSE c_cm_grp;
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

Line 1152: fnd_message.set_name ( 'IGS', 'IGS_PS_ENR_NULL_OVR_NOT' );

1148: BEGIN
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:

Line 1159: fnd_message.set_name ( 'IGS', 'IGS_PS_OVERIDE_MIN_MAX_CP' );

1155: END IF;
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:

Line 1197: fnd_message.set_name('IGS',l_message_name);

1193: IF l_message_name IS NULL THEN
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

Line 1212: fnd_message.set_name('IGS',l_message_name);

1208: p_enrollment_expected => NULL,
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;

Line 1277: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );

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

Line 1296: fnd_message.set_name('IGS','IGS_PS_UNT_SEC_DEFINED_GRP');

1292: --This unit section should not be present in any Unit section meet with class group
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;

Line 1314: FND_MESSAGE.SET_ENCODED (l_c_msg);

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;
1318: BEGIN

Line 1315: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED,l_appl_name, l_c_msg_name);

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;
1318: BEGIN
1319:

Line 1393: fnd_message.set_name('IGS', get_msg_from_stack(1));

1389: X_CORE_INDICATOR_CODE => l_c_fetch_record_cur.core_indicator_code
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:

Line 1484: fnd_message.set_name ( 'IGS', 'IGS_PS_USXL_NO_PARENT' );

1480: CLOSE c_parent;
1481: IF NVL(c_parent_rec.cnt,0) = 0 THEN
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

Line 1485: fnd_message.set_token ( 'GROUP_NAME',p_cross_group_tab(i).usec_x_listed_group_name );

1481: IF NVL(c_parent_rec.cnt,0) = 0 THEN
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;

Line 1491: fnd_message.set_name ( 'IGS', 'IGS_PS_UXL_ONLY_ONE_PARENT' );

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' );
1492: fnd_msg_pub.add;
1493: l_n_count_msg := fnd_msg_pub.count_msg;
1494: END IF;
1495: IF l_b_error THEN

Line 1523: fnd_message.set_name('IGS','IGS_PS_MAX_OVR_MAX');

1519: CLOSE c_x_grp;
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

Line 1713: fnd_message.set_name ( 'IGS', 'IGS_PS_ENR_NULL_OVR_NOT' );

1709: BEGIN
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:

Line 1720: fnd_message.set_name ( 'IGS', 'IGS_PS_OVERIDE_MIN_MAX_CP' );

1716: END IF;
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:

Line 1742: Fnd_Message.Set_Name('IGS', 'IGS_PS_LOC_INHR_CANNOT_UPD');

1738:
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;

Line 1765: fnd_message.set_name('IGS',l_message_name);

1761: IF l_message_name IS NULL THEN
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

Line 1780: fnd_message.set_name('IGS',l_message_name);

1776: p_enrollment_expected => NULL,
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;

Line 1859: fnd_message.set_name ('IGS', 'IGS_AS_GRP_WEIT_GT_SUM_AI_WEIT');

1855: --
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

Line 1885: fnd_message.set_name ('IGS', 'IGS_AS_GRP_WEIT_GT_SUM_AI_WEIT');

1881: --
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

Line 1910: fnd_message.set_name ('IGS', 'IGS_AS_NOT_ENOUGH_DFLT_AI');

1906: -- Assessment Item Group's Final/Midterm Grading Period formula number.
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

Line 1978: fnd_message.set_name ( 'IGS', 'IGS_PS_PRCALLOC_TEACH_RESP' );

1974: FETCH c_tro_perc_sum INTO c_tro_perc_sum_rec;
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));

Line 2069: fnd_message.set_name ( 'IGS', 'IGS_EN_PREF_REQ_PRIOR');

2065: OPEN c_usec_rsvprfc_ser(rec_priority_id.rsv_usec_pri_id);
2066: FETCH c_usec_rsvprfc_ser INTO l_c_usec_rsvprfc_ser;
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

Line 2070: fnd_message.set_token('PRIORITY',rec_priority_id.priority_value);

2066: FETCH c_usec_rsvprfc_ser INTO l_c_usec_rsvprfc_ser;
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

Line 2097: fnd_message.set_name ( 'IGS', 'IGS_PS_PREF_SUM_BET_0_100' );

2093: OPEN c_rsv_perc_sum (p_tab_uoo(i));
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

Line 2121: fnd_message.set_name ( 'IGS', 'IGS_PS_RSV_PRI_NOT_IN_SERIES' );

2117: l_n_counter :=1;
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

Line 2152: fnd_message.set_name ( 'IGS', 'IGS_PS_RSV_PRF_NOT_IN_SERIES' );

2148: FOR c_usec_rsvprfc_ser_rec IN c_usec_rsvprfc_ser(rec_priority_id.rsv_usec_pri_id) LOOP
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

Line 2242: fnd_message.set_name ( 'IGS', 'IGS_EN_PREF_REQ_PRIOR');

2238: OPEN c_usec_wlstprfc_ser(rec_priority_id.unit_sec_waitlist_priority_id);
2239: FETCH c_usec_wlstprfc_ser INTO l_c_usec_wlstprfc_ser;
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

Line 2243: fnd_message.set_token('PRIORITY',rec_priority_id.priority_value);

2239: FETCH c_usec_wlstprfc_ser INTO l_c_usec_wlstprfc_ser;
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

Line 2268: fnd_message.set_name ( 'IGS', 'IGS_PS_WLST_PRI_NOT_IN_SERIES' );

2264: l_n_counter :=1;
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

Line 2299: fnd_message.set_name ( 'IGS', 'IGS_PS_WLST_PRF_NOT_IN_SERIES' );

2295: FOR c_usec_wlstprfc_ser_rec IN c_usec_wlstprfc_ser(rec_priority_id.unit_sec_waitlist_priority_id) LOOP
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

Line 2372: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );

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;
2376:

Line 2381: fnd_message.set_name ( 'IGS', 'IGS_PS_FACILITY_CLOSED' );

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

Line 2392: fnd_message.set_name ( 'IGS', 'IGS_PS_SCHEDULING_IN_PROGRESS' );

2388: IF p_calling_context <> 'S' THEN
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;

Line 2433: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );

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;
2437:

Line 2441: fnd_message.set_name ( 'IGS', 'IGS_PS_CATEGORY_CLOSED' );

2437:
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;

Line 2473: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );

2469: BEGIN
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:

Line 2480: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );

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

Line 2489: fnd_message.set_name ( 'IGS', 'IGS_PS_RSV_SEAT_NOT_ALLOWED' );

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

Line 2816: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );

2812: BEGIN
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:

Line 2823: fnd_message.set_name ( 'IGS', 'IGS_PS_IMP_NOT_ALD_NOT_OFFERED' );

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;
2827:

Line 2834: fnd_message.set_name ( 'IGS', 'IGS_PS_WAITLIST_NOT_ALLOWED' );

2830: OPEN c_wlst_allow (p_n_uoo_id);
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

Line 2842: fnd_message.set_name ( 'IGS', 'IGS_PS_WAITLIST_NOT_ALLOWED' );

2838: ELSE
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;