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_OFR_PAT_PKG dependencies on APP_EXCEPTION

Line 60: App_Exception.Raise_Exception;

56: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
57: Close cur_old_ref_values;
58: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
59: IGS_GE_MSG_STACK.ADD;
60: App_Exception.Raise_Exception;
61: Return;
62: END IF;
63: Close cur_old_ref_values;
64:

Line 154: App_Exception.Raise_Exception;

150: v_version_number,
151: v_message_name) = FALSE THEN
152: Fnd_Message.Set_Name('IGS',v_message_name);
153: IGS_GE_MSG_STACK.ADD;
154: App_Exception.Raise_Exception;
155: END IF;
156: -- Validate calendar instance is active
157: IF igs_as_val_uai.crsp_val_crs_ci (
158: v_cal_type,

Line 163: App_Exception.Raise_Exception;

159: v_ci_sequence_number,
160: v_message_name) = FALSE THEN
161: Fnd_Message.Set_Name('IGS',v_message_name);
162: IGS_GE_MSG_STACK.ADD;
163: App_Exception.Raise_Exception;
164: END IF;
165: -- Validate that inserts are allowed
166: IF p_inserting THEN
167: -- Validate IGS_PS_COURSE offering option

Line 179: App_Exception.Raise_Exception;

175: new_references.attendance_type,
176: v_message_name) = FALSE THEN
177: Fnd_Message.Set_Name('IGS',v_message_name);
178: IGS_GE_MSG_STACK.ADD;
179: App_Exception.Raise_Exception;
180: END IF;
181: END IF;
182: IF p_inserting OR p_updating THEN
183: -- Validate entry assessment scores.

Line 190: App_Exception.Raise_Exception;

186: new_references.guaranteed_entry_ass_scr,
187: v_message_name) = FALSE THEN
188: Fnd_Message.Set_Name('IGS',v_message_name);
189: IGS_GE_MSG_STACK.ADD;
190: App_Exception.Raise_Exception;
191: END IF;
192: END IF;
193:
194:

Line 205: App_Exception.Raise_Exception;

201: new_references.cop_id
202: )THEN
203: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
204: IGS_GE_MSG_STACK.ADD;
205: App_Exception.Raise_Exception;
206: END IF;
207: END Check_Uniqueness;
208:
209: PROCEDURE Check_Constraints(

Line 260: App_Exception.Raise_Exception;

256: IF new_references.attendance_mode <> UPPER(new_references.attendance_mode)
257: THEN
258: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
259: IGS_GE_MSG_STACK.ADD;
260: App_Exception.Raise_Exception;
261: END IF;
262: END IF;
263:
264: IF upper(column_name)= 'ATTENDANCE_TYPE' OR

Line 270: App_Exception.Raise_Exception;

266: IF new_references.attendance_type <> UPPER(new_references.attendance_type)
267: THEN
268: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception;
271: END IF;
272: END IF;
273:
274: IF upper(column_name)= 'CAL_TYPE' OR

Line 280: App_Exception.Raise_Exception;

276: IF new_references.cal_type <> UPPER(new_references.cal_type)
277: THEN
278: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: END IF;
282: END IF;
283:
284: IF upper(column_name)= 'COURSE_CD' OR

Line 290: App_Exception.Raise_Exception;

286: IF new_references.course_cd <> UPPER(new_references.course_cd)
287: THEN
288: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
289: IGS_GE_MSG_STACK.ADD;
290: App_Exception.Raise_Exception;
291: END IF;
292: END IF;
293:
294: IF upper(column_name)= 'GRADING_SCHEMA_CD' OR

Line 300: App_Exception.Raise_Exception;

296: IF new_references.grading_schema_cd <> UPPER(new_references.grading_schema_cd)
297: THEN
298: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
299: IGS_GE_MSG_STACK.ADD;
300: App_Exception.Raise_Exception;
301: END IF;
302: END IF;
303:
304: IF upper(column_name)= 'LOCATION_CD' OR

Line 310: App_Exception.Raise_Exception;

306: IF new_references.location_cd <> UPPER(new_references.location_cd)
307: THEN
308: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
309: IGS_GE_MSG_STACK.ADD;
310: App_Exception.Raise_Exception;
311: END IF;
312: END IF;
313:
314: IF upper(column_name)= 'PRE_ENROL_UNITS_IND' OR

Line 320: App_Exception.Raise_Exception;

316: IF new_references.pre_enrol_units_ind NOT IN ( 'Y' , 'N' )
317: THEN
318: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
319: IGS_GE_MSG_STACK.ADD;
320: App_Exception.Raise_Exception;
321: END IF;
322: END IF;
323:
324:

Line 331: App_Exception.Raise_Exception;

327: IF new_references.enrollable_ind NOT IN ( 'Y' , 'N' )
328: THEN
329: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: END IF;
333: END IF;
334:
335: IF upper(column_name)= 'IVRS_AVAILABLE_IND' OR

Line 341: App_Exception.Raise_Exception;

337: IF new_references.ivrs_available_ind NOT IN ( 'Y' , 'N' )
338: THEN
339: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
340: IGS_GE_MSG_STACK.ADD;
341: App_Exception.Raise_Exception;
342: END IF;
343: END IF;
344:
345: IF upper(column_name)= 'MIN_ENTRY_ASS_SCORE' OR

Line 352: App_Exception.Raise_Exception;

348: new_references.min_entry_ass_score > 999
349: THEN
350: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
351: IGS_GE_MSG_STACK.ADD;
352: App_Exception.Raise_Exception;
353: END IF;
354: END IF;
355:
356:

Line 362: App_Exception.Raise_Exception;

358: IF new_references.min_entry_ass_score > new_references.guaranteed_entry_ass_scr
359: THEN
360: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
361: IGS_GE_MSG_STACK.ADD;
362: App_Exception.Raise_Exception;
363: END IF;
364: END IF;
365:
366: IF upper(column_name)= 'GUARANTEED_ENTRY_ASS_SCR' OR

Line 373: App_Exception.Raise_Exception;

369: new_references.guaranteed_entry_ass_scr > 999
370: THEN
371: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
372: IGS_GE_MSG_STACK.ADD;
373: App_Exception.Raise_Exception;
374: END IF;
375: END IF;
376:
377: IF upper(column_name)= 'MAX_CROSS_FACULTY_CP' OR

Line 384: App_Exception.Raise_Exception;

380: new_references.max_cross_faculty_cp > 999.999
381: THEN
382: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
383: IGS_GE_MSG_STACK.ADD;
384: App_Exception.Raise_Exception;
385: END IF;
386: END IF;
387:
388: IF upper(column_name)= 'MAX_CROSS_LOCATION_CP' OR

Line 395: App_Exception.Raise_Exception;

391: new_references.max_cross_location_cp > 999.999
392: THEN
393: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
394: IGS_GE_MSG_STACK.ADD;
395: App_Exception.Raise_Exception;
396: END IF;
397: END IF;
398:
399: IF upper(column_name)= 'MAX_CROSS_MODE_CP' OR

Line 406: App_Exception.Raise_Exception;

402: new_references.max_cross_mode_cp > 999.999
403: THEN
404: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
405: IGS_GE_MSG_STACK.ADD;
406: App_Exception.Raise_Exception;
407: END IF;
408: END IF;
409:
410: IF upper(column_name)= 'MAX_HIST_CROSS_FACULTY_CP' OR

Line 417: App_Exception.Raise_Exception;

413: new_references.max_hist_cross_faculty_cp > 999.999
414: THEN
415: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
416: IGS_GE_MSG_STACK.ADD;
417: App_Exception.Raise_Exception;
418: END IF;
419: END IF;
420:
421: IF upper(column_name)= 'OFFERED_IND' OR

Line 427: App_Exception.Raise_Exception;

423: IF new_references.offered_ind NOT IN ( 'Y' , 'N' )
424: THEN
425: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
426: IGS_GE_MSG_STACK.ADD;
427: App_Exception.Raise_Exception;
428: END IF;
429: END IF;
430:
431: IF upper(column_name)= 'CONFIRMED_OFFERING_IND' OR

Line 437: App_Exception.Raise_Exception;

433: IF new_references.confirmed_offering_ind NOT IN ( 'Y' , 'N' )
434: THEN
435: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
436: IGS_GE_MSG_STACK.ADD;
437: App_Exception.Raise_Exception;
438: END IF;
439: END IF;
440:
441: IF upper(column_name)= 'ENTRY_POINT_IND' OR

Line 447: App_Exception.Raise_Exception;

443: IF new_references.entry_point_ind NOT IN ( 'Y' , 'N' )
444: THEN
445: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
446: IGS_GE_MSG_STACK.ADD;
447: App_Exception.Raise_Exception;
448: END IF;
449: END IF;
450:
451: END Check_Constraints;

Line 474: App_Exception.Raise_Exception;

470: new_references.ci_sequence_number
471: )THEN
472: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
473: IGS_GE_MSG_STACK.ADD;
474: App_Exception.Raise_Exception;
475: END IF;
476: END IF;
477:
478: IF (((old_references.course_cd = new_references.course_cd) AND

Line 502: App_Exception.Raise_Exception;

498: new_references.attendance_type
499: )THEN
500: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
501: IGS_GE_MSG_STACK.ADD;
502: App_Exception.Raise_Exception;
503: END IF;
504: END IF;
505:
506: IF (((old_references.coo_id = new_references.coo_id)) OR

Line 515: App_Exception.Raise_Exception;

511: new_references.coo_id
512: )THEN
513: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
514: IGS_GE_MSG_STACK.ADD;
515: App_Exception.Raise_Exception;
516: END IF;
517: END IF;
518:
519: IF (((old_references.grading_schema_cd = new_references.grading_schema_cd) AND

Line 531: App_Exception.Raise_Exception;

527: new_references.gs_version_number
528: )THEN
529: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
530: IGS_GE_MSG_STACK.ADD;
531: App_Exception.Raise_Exception;
532: END IF;
533: END IF;
534:
535: IF (((old_references.adm_ass_officer_person_id = new_references.adm_ass_officer_person_id)) OR

Line 544: App_Exception.Raise_Exception;

540: new_references.adm_ass_officer_person_id
541: )THEN
542: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
543: IGS_GE_MSG_STACK.ADD;
544: App_Exception.Raise_Exception;
545: END IF;
546: END IF;
547:
548: IF (((old_references.adm_contact_person_id = new_references.adm_contact_person_id)) OR

Line 557: App_Exception.Raise_Exception;

553: new_references.adm_contact_person_id
554: )THEN
555: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
556: IGS_GE_MSG_STACK.ADD;
557: App_Exception.Raise_Exception;
558: END IF;
559: END IF;
560:
561: END Check_Parent_Existance;

Line 684: App_Exception.Raise_Exception;

680: IF (cur_rowid%FOUND) THEN
681: Close cur_rowid;
682: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COP_COI_FK');
683: IGS_GE_MSG_STACK.ADD;
684: App_Exception.Raise_Exception;
685: Return;
686: END IF;
687: Close cur_rowid;
688:

Line 720: App_Exception.Raise_Exception;

716: IF (cur_rowid%FOUND) THEN
717: Close cur_rowid;
718: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COP_COO_FK');
719: IGS_GE_MSG_STACK.ADD;
720: App_Exception.Raise_Exception;
721: Return;
722: END IF;
723: Close cur_rowid;
724:

Line 746: App_Exception.Raise_Exception;

742: IF (cur_rowid%FOUND) THEN
743: Close cur_rowid;
744: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COP_COO_FK');
745: IGS_GE_MSG_STACK.ADD;
746: App_Exception.Raise_Exception;
747: Return;
748: END IF;
749: Close cur_rowid;
750:

Line 774: App_Exception.Raise_Exception;

770: IF (cur_rowid%FOUND) THEN
771: Close cur_rowid;
772: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COP_GS_FK');
773: IGS_GE_MSG_STACK.ADD;
774: App_Exception.Raise_Exception;
775: Return;
776: END IF;
777: Close cur_rowid;
778:

Line 801: App_Exception.Raise_Exception;

797: IF (cur_rowid%FOUND) THEN
798: Close cur_rowid;
799: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COP_PE_AAO_FK');
800: IGS_GE_MSG_STACK.ADD;
801: App_Exception.Raise_Exception;
802: Return;
803: END IF;
804: Close cur_rowid;
805:

Line 893: App_Exception.Raise_Exception;

889: new_references.attendance_type
890: ) THEN
891: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
892: IGS_GE_MSG_STACK.ADD;
893: App_Exception.Raise_Exception;
894: END IF;
895: Check_Uniqueness;
896: Check_Constraints;
897: Check_Parent_Existance;

Line 921: App_Exception.Raise_Exception;

917: new_references.attendance_type
918: ) THEN
919: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
920: IGS_GE_MSG_STACK.ADD;
921: App_Exception.Raise_Exception;
922: END IF;
923: Check_Uniqueness;
924: Check_Constraints;
925: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 1018: app_exception.raise_exception;

1014: END IF;
1015: else
1016: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1017: IGS_GE_MSG_STACK.ADD;
1018: app_exception.raise_exception;
1019: end if;
1020: Before_DML (
1021: p_action => 'INSERT',
1022: x_rowid => X_ROWID,

Line 1199: app_exception.raise_exception;

1195: if (c1%notfound) then
1196: close c1;
1197: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1198: IGS_GE_MSG_STACK.ADD;
1199: app_exception.raise_exception;
1200: return;
1201: end if;
1202: close c1;
1203:

Line 1247: app_exception.raise_exception;

1243: null;
1244: else
1245: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1246: IGS_GE_MSG_STACK.ADD;
1247: app_exception.raise_exception;
1248: end if;
1249: return;
1250: end LOCK_ROW;
1251:

Line 1305: app_exception.raise_exception;

1301: end if;
1302: else
1303: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1304: IGS_GE_MSG_STACK.ADD;
1305: app_exception.raise_exception;
1306: end if;
1307:
1308: Before_DML (
1309: p_action => 'UPDATE',