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_US_UNSCHED_CL_PKG dependencies on IGS_GE_MSG_STACK

Line 53: igs_ge_msg_stack.add;

49: FETCH cur_old_ref_values INTO old_references;
50: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
51: CLOSE cur_old_ref_values;
52: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
53: igs_ge_msg_stack.add;
54: app_exception.raise_exception;
55: RETURN;
56: END IF;
57: CLOSE cur_old_ref_values;

Line 107: igs_ge_msg_stack.add;

103: new_references.room_id
104: )
105: ) THEN
106: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
107: igs_ge_msg_stack.add;
108: app_exception.raise_exception;
109: END IF;
110:
111: END check_uniqueness;

Line 141: IGS_GE_MSG_STACK.ADD;

137:
138: IF UPPER(Column_Name)='NUMBER_OF_STUDENTS' OR Column_Name IS NULL THEN
139: IF New_References.number_of_students < 0 OR New_References.number_of_students > 9999999999 THEN
140: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
141: IGS_GE_MSG_STACK.ADD;
142: App_Exception.Raise_Exception;
143: END IF;
144: END IF;
145:

Line 149: IGS_GE_MSG_STACK.ADD;

145:
146: IF UPPER(Column_Name)='HOURS_PER_STUDENT' OR Column_Name IS NULL THEN
147: IF New_References.hours_per_student < 0 OR New_References.hours_per_student > 999.99 THEN
148: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: END IF;
152: END IF;
153:

Line 157: IGS_GE_MSG_STACK.ADD;

153:
154: IF UPPER(Column_Name)='HOURS_PER_FACULTY' OR Column_Name IS NULL THEN
155: IF New_References.hours_per_faculty < 0 OR New_References.hours_per_faculty > 999.99 THEN
156: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160: END IF;
161:

Line 192: igs_ge_msg_stack.add;

188: new_references.location_cd ,
189: 'N'
190: ) THEN
191: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
192: igs_ge_msg_stack.add;
193: app_exception.raise_exception;
194: END IF;
195:
196: IF (((old_references.building_id = new_references.building_id)) OR

Line 204: igs_ge_msg_stack.add;

200: new_references.building_id ,
201: 'N'
202: ) THEN
203: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
204: igs_ge_msg_stack.add;
205: app_exception.raise_exception;
206: END IF;
207:
208: IF (((old_references.room_id = new_references.room_id)) OR

Line 216: igs_ge_msg_stack.add;

212: new_references.room_id ,
213: 'N'
214: ) THEN
215: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
216: igs_ge_msg_stack.add;
217: app_exception.raise_exception;
218: END IF;
219:
220: IF (((old_references.uoo_id = new_references.uoo_id)) OR

Line 227: igs_ge_msg_stack.add;

223: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_For_validation (
224: new_references.uoo_id
225: ) THEN
226: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
227: igs_ge_msg_stack.add;
228: app_exception.raise_exception;
229: END IF;
230:
231: IF (((old_references.instructor_id = new_references.instructor_id)) OR

Line 242: igs_ge_msg_stack.add;

238: CLOSE cur_rowid;
239: ELSE
240: CLOSE cur_rowid;
241: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
242: igs_ge_msg_stack.add;
243: app_exception.raise_exception;
244: END IF;
245: END IF;
246:

Line 354: igs_ge_msg_stack.add;

350: FETCH cur_rowid INTO lv_rowid;
351: IF (cur_rowid%FOUND) THEN
352: CLOSE cur_rowid;
353: fnd_message.set_name ('IGS', 'IGS_PS_LOC_UUCL_FK1');
354: igs_ge_msg_stack.add;
355: app_exception.raise_exception;
356: RETURN;
357: END IF;
358: CLOSE cur_rowid;

Line 389: igs_ge_msg_stack.add;

385: FETCH cur_rowid INTO lv_rowid;
386: IF (cur_rowid%FOUND) THEN
387: CLOSE cur_rowid;
388: fnd_message.set_name ('IGS', 'IGS_PS_BLD_UUCL_FK2');
389: igs_ge_msg_stack.add;
390: app_exception.raise_exception;
391: RETURN;
392: END IF;
393: CLOSE cur_rowid;

Line 424: igs_ge_msg_stack.add;

420: FETCH cur_rowid INTO lv_rowid;
421: IF (cur_rowid%FOUND) THEN
422: CLOSE cur_rowid;
423: fnd_message.set_name ('IGS', 'IGS_PS_ROM_UUCL_FK3');
424: igs_ge_msg_stack.add;
425: app_exception.raise_exception;
426: RETURN;
427: END IF;
428: CLOSE cur_rowid;

Line 459: igs_ge_msg_stack.add;

455: FETCH cur_rowid INTO lv_rowid;
456: IF (cur_rowid%FOUND) THEN
457: CLOSE cur_rowid;
458: fnd_message.set_name ('IGS', 'IGS_PS_UOO_UUCL_FK4');
459: igs_ge_msg_stack.add;
460: app_exception.raise_exception;
461: RETURN;
462: END IF;
463: CLOSE cur_rowid;

Line 494: igs_ge_msg_stack.add;

490: FETCH cur_rowid INTO lv_rowid;
491: IF (cur_rowid%FOUND) THEN
492: CLOSE cur_rowid;
493: fnd_message.set_name ('IGS', 'IGS_PS_HZP_UUCL_FK5');
494: igs_ge_msg_stack.add;
495: app_exception.raise_exception;
496: RETURN;
497: END IF;
498: CLOSE cur_rowid;

Line 528: igs_ge_msg_stack.add;

524: FETCH cur_rowid INTO lv_rowid;
525: IF (cur_rowid%FOUND) THEN
526: CLOSE cur_rowid;
527: fnd_message.set_name ('IGS', 'IGS_PS_USAT_UUCL_FK6');
528: igs_ge_msg_stack.add;
529: app_exception.raise_exception;
530: RETURN;
531: END IF;
532: CLOSE cur_rowid;

Line 594: igs_ge_msg_stack.add;

590: new_references.us_unscheduled_cl_id
591: )
592: ) THEN
593: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
594: igs_ge_msg_stack.add;
595: app_exception.raise_exception;
596: END IF;
597: check_uniqueness;
598: Check_Constraints;

Line 612: igs_ge_msg_stack.add;

608: new_references.us_unscheduled_cl_id
609: )
610: ) THEN
611: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
612: igs_ge_msg_stack.add;
613: app_exception.raise_exception;
614: END IF;
615: check_uniqueness;
616: Check_Constraints;

Line 674: igs_ge_msg_stack.add;

670: x_last_update_login := -1;
671: END IF;
672: ELSE
673: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
674: igs_ge_msg_stack.add;
675: app_exception.raise_exception;
676: END IF;
677:
678: SELECT igs_ps_us_unsched_cl_s.NEXTVAL

Line 792: igs_ge_msg_stack.add;

788: OPEN c1;
789: FETCH c1 INTO tlinfo;
790: IF (c1%notfound) THEN
791: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
792: igs_ge_msg_stack.add;
793: CLOSE c1;
794: app_exception.raise_exception;
795: RETURN;
796: END IF;

Line 813: igs_ge_msg_stack.add;

809: ) THEN
810: NULL;
811: ELSE
812: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
813: igs_ge_msg_stack.add;
814: app_exception.raise_exception;
815: END IF;
816:
817: RETURN;

Line 866: igs_ge_msg_stack.add;

862: x_last_update_login := -1;
863: END IF;
864: ELSE
865: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
866: igs_ge_msg_stack.add;
867: app_exception.raise_exception;
868: END IF;
869:
870: before_dml(