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 APP_EXCEPTION

Line 54: app_exception.raise_exception;

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

Line 108: app_exception.raise_exception;

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

Line 142: App_Exception.Raise_Exception;

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:
146: IF UPPER(Column_Name)='HOURS_PER_STUDENT' OR Column_Name IS NULL THEN

Line 150: App_Exception.Raise_Exception;

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:
154: IF UPPER(Column_Name)='HOURS_PER_FACULTY' OR Column_Name IS NULL THEN

Line 158: App_Exception.Raise_Exception;

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:
162: END Check_Constraints;

Line 193: app_exception.raise_exception;

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
197: ((new_references.building_id IS NULL))) THEN

Line 205: app_exception.raise_exception;

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
209: ((new_references.room_id IS NULL))) THEN

Line 217: app_exception.raise_exception;

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
221: ((new_references.uoo_id IS NULL))) THEN

Line 228: app_exception.raise_exception;

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
232: ((new_references.instructor_id IS NULL))) THEN

Line 243: app_exception.raise_exception;

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:
247: END check_parent_existance;

Line 355: app_exception.raise_exception;

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

Line 390: app_exception.raise_exception;

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

Line 425: app_exception.raise_exception;

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

Line 460: app_exception.raise_exception;

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

Line 495: app_exception.raise_exception;

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

Line 529: app_exception.raise_exception;

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

Line 595: app_exception.raise_exception;

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;
599: check_parent_existance;

Line 613: app_exception.raise_exception;

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;
617: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 675: app_exception.raise_exception;

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
679: INTO x_us_unscheduled_cl_id

Line 794: app_exception.raise_exception;

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;
797: CLOSE c1;
798:

Line 814: app_exception.raise_exception;

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

Line 867: app_exception.raise_exception;

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(
871: p_action => 'UPDATE',