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

Line 48: App_Exception.Raise_Exception;

44: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
45: Close cur_old_ref_values;
46: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
47: IGS_GE_MSG_STACK.ADD;
48: App_Exception.Raise_Exception;
49: Return;
50: END IF;
51: Close cur_old_ref_values;
52:

Line 96: App_Exception.Raise_Exception;

92: new_references.version_number,
93: v_message_name) = FALSE THEN
94: Fnd_Message.Set_Name('IGS', v_message_name);
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: END IF;
98: ELSE
99: IF IGS_PS_VAL_CRS.crsp_val_iud_crv_dtl(
100: old_references.course_cd,

Line 105: App_Exception.Raise_Exception;

101: old_references.version_number,
102: v_message_name) = FALSE THEN
103: Fnd_Message.Set_Name('IGS', v_message_name);
104: IGS_GE_MSG_STACK.ADD;
105: App_Exception.Raise_Exception;
106: END IF;
107: END IF;
108: -- Validate the insert/update
109: IF p_inserting OR p_updating THEN

Line 119: App_Exception.Raise_Exception;

115: new_references.location_cd,
116: v_message_name) = FALSE THEN
117: Fnd_Message.Set_Name('IGS', v_message_name);
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception;
120: END IF;
121: END IF;
122: -- Validate the Attendance Mode
123: IF (new_references.attendance_mode IS NOT NULL AND (p_inserting OR

Line 130: App_Exception.Raise_Exception;

126: new_references.attendance_mode,
127: v_message_name) = FALSE THEN
128: Fnd_Message.Set_Name('IGS', v_message_name);
129: IGS_GE_MSG_STACK.ADD;
130: App_Exception.Raise_Exception;
131: END IF;
132: END IF;
133: -- Validate the Attendance Type
134: IF (new_references.attendance_type IS NOT NULL AND (p_inserting OR

Line 141: App_Exception.Raise_Exception;

137: new_references.attendance_type,
138: v_message_name) = FALSE THEN
139: Fnd_Message.Set_Name('IGS', v_message_name);
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF;
144: -- Validate the IGS_PS_UNIT Set Code
145: IF (new_references.unit_set_cd IS NOT NULL AND (p_inserting OR

Line 152: App_Exception.Raise_Exception;

148: new_references.unit_set_cd,
149: v_message_name) = FALSE THEN
150: Fnd_Message.Set_Name('IGS', v_message_name);
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153: END IF;
154: END IF;
155: -- Validate the Admission Calendar Type
156: IF (new_references.admission_cal_type IS NOT NULL AND (p_inserting OR

Line 163: App_Exception.Raise_Exception;

159: new_references.admission_cal_type,
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: END IF;
166: -- Validate the Admission Category
167: IF (new_references.admission_cat IS NOT NULL AND (p_inserting OR

Line 174: App_Exception.Raise_Exception;

170: new_references.admission_cat,
171: v_message_name) = FALSE THEN
172: Fnd_Message.Set_Name('IGS', v_message_name);
173: IGS_GE_MSG_STACK.ADD;
174: App_Exception.Raise_Exception;
175: END IF;
176: END IF;
177: -- Validate the Aproved Calendar Instance
178: IF (new_references.aprvd_ci_sequence_number IS NOT NULL AND

Line 187: App_Exception.Raise_Exception;

183: new_references.aprvd_ci_sequence_number,
184: v_message_name) = FALSE THEN
185: Fnd_Message.Set_Name('IGS', v_message_name);
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception;
188: END IF;
189: END IF;
190: END IF;
191:

Line 239: App_Exception.Raise_Exception;

235: column_name is null Then
236: IF new_references.admission_cal_type <> UPPER(new_references.admission_cal_type) Then
237: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
238: IGS_GE_MSG_STACK.ADD;
239: App_Exception.Raise_Exception;
240: END IF;
241: END IF;
242:
243: IF upper(column_name) = 'ADMISSION_CAT' OR

Line 248: App_Exception.Raise_Exception;

244: column_name is null Then
245: IF new_references.admission_cat <> UPPER(new_references.admission_cat) Then
246: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
247: IGS_GE_MSG_STACK.ADD;
248: App_Exception.Raise_Exception;
249: END IF;
250: END IF;
251:
252: IF upper(column_name) = 'ATTENDANCE_MODE' OR

Line 257: App_Exception.Raise_Exception;

253: column_name is null Then
254: IF new_references.attendance_mode <> UPPER(new_references.attendance_mode) Then
255: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: END IF;
259: END IF;
260:
261: IF upper(column_name) = 'ATTENDANCE_TYPE' OR

Line 266: App_Exception.Raise_Exception;

262: column_name is null Then
263: IF new_references.attendance_type <> UPPER(new_references.attendance_type) Then
264: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
265: IGS_GE_MSG_STACK.ADD;
266: App_Exception.Raise_Exception;
267: END IF;
268: END IF;
269:
270: IF upper(column_name) = 'CAL_TYPE' OR

Line 275: App_Exception.Raise_Exception;

271: column_name is null Then
272: IF new_references.cal_type <> UPPER(new_references.cal_type) Then
273: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
274: IGS_GE_MSG_STACK.ADD;
275: App_Exception.Raise_Exception;
276: END IF;
277: END IF;
278:
279: IF upper(column_name) = 'COURSE_CD' OR

Line 284: App_Exception.Raise_Exception;

280: column_name is null Then
281: IF new_references.course_cd <> UPPER(new_references.course_cd) Then
282: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
283: IGS_GE_MSG_STACK.ADD;
284: App_Exception.Raise_Exception;
285: END IF;
286: END IF;
287:
288: IF upper(column_name) = 'LOCATION_CD' OR

Line 293: App_Exception.Raise_Exception;

289: column_name is null Then
290: IF new_references.location_cd <> UPPER(new_references.location_cd) Then
291: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
292: IGS_GE_MSG_STACK.ADD;
293: App_Exception.Raise_Exception;
294: END IF;
295: END IF;
296:
297: IF upper(column_name) = 'UNIT_SET_CD' OR

Line 302: App_Exception.Raise_Exception;

298: column_name is null Then
299: IF new_references.unit_set_cd <> UPPER(new_references.unit_set_cd) Then
300: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
301: IGS_GE_MSG_STACK.ADD;
302: App_Exception.Raise_Exception;
303: END IF;
304: END IF;
305:
306: IF upper(column_name) = 'SEQUENCE_NUMBER' OR

Line 311: App_Exception.Raise_Exception;

307: column_name is null Then
308: IF new_references.sequence_number < 0 OR new_references.sequence_number > 999999 Then
309: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception;
312: END IF;
313: END IF;
314:
315: IF upper(column_name) = 'NUMBER_OF_PERIODS' OR

Line 320: App_Exception.Raise_Exception;

316: column_name is null Then
317: IF new_references.number_of_periods < 1 OR new_references.number_of_periods > 99 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: IF upper(column_name) = 'ALWAYS_PRE_ENROL_IND' OR

Line 329: App_Exception.Raise_Exception;

325: column_name is null Then
326: IF new_references.always_pre_enrol_ind NOT IN ('Y','N') THEN
327: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
328: IGS_GE_MSG_STACK.ADD;
329: App_Exception.Raise_Exception;
330: END IF;
331: END IF;
332:
333: IF upper(column_name) = 'APRVD_CI_SEQUENCE_NUMBER' OR

Line 338: App_Exception.Raise_Exception;

334: column_name is null Then
335: IF new_references.aprvd_ci_sequence_number < 0 OR new_references.aprvd_ci_sequence_number > 999999 Then
336: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
337: IGS_GE_MSG_STACK.ADD;
338: App_Exception.Raise_Exception;
339: END IF;
340: END IF;
341:
342: IF upper(column_name) = 'VERSION_NUMBER' OR

Line 347: App_Exception.Raise_Exception;

343: column_name is null Then
344: IF new_references.version_number < 0 OR new_references.version_number > 999 Then
345: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
346: IGS_GE_MSG_STACK.ADD;
347: App_Exception.Raise_Exception;
348: END IF;
349: END IF;
350:
351: END check_constraints;

Line 366: App_Exception.Raise_Exception;

362: 'N'
363: ) THEN
364: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
365: IGS_GE_MSG_STACK.ADD;
366: App_Exception.Raise_Exception;
367: END IF;
368:
369: END IF;
370:

Line 380: App_Exception.Raise_Exception;

376: new_references.attendance_mode
377: ) THEN
378: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
379: IGS_GE_MSG_STACK.ADD;
380: App_Exception.Raise_Exception;
381: END IF;
382:
383: END IF;
384:

Line 394: App_Exception.Raise_Exception;

390: new_references.attendance_type
391: ) THEN
392: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
393: IGS_GE_MSG_STACK.ADD;
394: App_Exception.Raise_Exception;
395: END IF;
396:
397: END IF;
398:

Line 408: App_Exception.Raise_Exception;

404: new_references.admission_cal_type
405: ) THEN
406: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
407: IGS_GE_MSG_STACK.ADD;
408: App_Exception.Raise_Exception;
409: END IF;
410:
411: END IF;
412:

Line 426: App_Exception.Raise_Exception;

422: new_references.aprvd_ci_sequence_number
423: ) THEN
424: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
425: IGS_GE_MSG_STACK.ADD;
426: App_Exception.Raise_Exception;
427: END IF;
428: END IF;
429:
430: IF (((old_references.course_cd = new_references.course_cd) AND

Line 445: App_Exception.Raise_Exception;

441: new_references.cal_type
442: ) THEN
443: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
444: IGS_GE_MSG_STACK.ADD;
445: App_Exception.Raise_Exception;
446: END IF;
447: END IF;
448:
449: IF (((old_references.location_cd = new_references.location_cd)) OR

Line 459: App_Exception.Raise_Exception;

455: 'N'
456: ) THEN
457: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
458: IGS_GE_MSG_STACK.ADD;
459: App_Exception.Raise_Exception;
460: END IF;
461:
462: END IF;
463:

Line 528: App_Exception.Raise_Exception;

524: IF (cur_rowid%FOUND) THEN
525: Close cur_rowid;
526: Fnd_Message.Set_Name ('IGS', 'IGS_PS_POS_AC_FK');
527: IGS_GE_MSG_STACK.ADD;
528: App_Exception.Raise_Exception;
529: Return;
530: END IF;
531: Close cur_rowid;
532:

Line 554: App_Exception.Raise_Exception;

550: IF (cur_rowid%FOUND) THEN
551: Close cur_rowid;
552: Fnd_Message.Set_Name ('IGS', 'IGS_PS_POS_AM_FK');
553: IGS_GE_MSG_STACK.ADD;
554: App_Exception.Raise_Exception;
555: Return;
556: END IF;
557: Close cur_rowid;
558:

Line 580: App_Exception.Raise_Exception;

576: IF (cur_rowid%FOUND) THEN
577: Close cur_rowid;
578: Fnd_Message.Set_Name ('IGS', 'IGS_PS_POS_ATT_FK');
579: IGS_GE_MSG_STACK.ADD;
580: App_Exception.Raise_Exception;
581: Return;
582: END IF;
583: Close cur_rowid;
584:

Line 606: App_Exception.Raise_Exception;

602: IF (cur_rowid%FOUND) THEN
603: Close cur_rowid;
604: Fnd_Message.Set_Name ('IGS', 'IGS_PS_POS_CAT_ADM_FK');
605: IGS_GE_MSG_STACK.ADD;
606: App_Exception.Raise_Exception;
607: Return;
608: END IF;
609: Close cur_rowid;
610:

Line 634: App_Exception.Raise_Exception;

630: IF (cur_rowid%FOUND) THEN
631: Close cur_rowid;
632: Fnd_Message.Set_Name ('IGS', 'IGS_PS_POS_CI_APRVD_FK');
633: IGS_GE_MSG_STACK.ADD;
634: App_Exception.Raise_Exception;
635: Return;
636: END IF;
637: Close cur_rowid;
638:

Line 664: App_Exception.Raise_Exception;

660: IF (cur_rowid%FOUND) THEN
661: Close cur_rowid;
662: Fnd_Message.Set_Name ('IGS', 'IGS_PS_POS_CO_FK');
663: IGS_GE_MSG_STACK.ADD;
664: App_Exception.Raise_Exception;
665: Return;
666: END IF;
667: Close cur_rowid;
668:

Line 690: App_Exception.Raise_Exception;

686: IF (cur_rowid%FOUND) THEN
687: Close cur_rowid;
688: Fnd_Message.Set_Name ('IGS', 'IGS_PS_POS_LOC_FK');
689: IGS_GE_MSG_STACK.ADD;
690: App_Exception.Raise_Exception;
691: Return;
692: END IF;
693: Close cur_rowid;
694:

Line 757: App_Exception.Raise_Exception;

753: new_references.sequence_number
754: ) THEN
755: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
756: IGS_GE_MSG_STACK.ADD;
757: App_Exception.Raise_Exception;
758: END IF;
759: Check_Constraints;
760: Check_Parent_Existance;
761: ELSIF (p_action = 'UPDATE') THEN

Line 779: App_Exception.Raise_Exception;

775: new_references.sequence_number
776: ) THEN
777: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
778: IGS_GE_MSG_STACK.ADD;
779: App_Exception.Raise_Exception;
780: END IF;
781: Check_Constraints;
782: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
783: Check_Constraints;

Line 844: app_exception.raise_exception;

840: end if;
841: else
842: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
843: IGS_GE_MSG_STACK.ADD;
844: app_exception.raise_exception;
845: end if;
846:
847: Before_DML( p_action => 'INSERT',
848: x_rowid => X_ROWID,

Line 964: app_exception.raise_exception;

960: if (c1%notfound) then
961: close c1;
962: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
963: IGS_GE_MSG_STACK.ADD;
964: app_exception.raise_exception;
965: return;
966: end if;
967: close c1;
968:

Line 1000: app_exception.raise_exception;

996: null;
997: else
998: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
999: IGS_GE_MSG_STACK.ADD;
1000: app_exception.raise_exception;
1001: end if;
1002: return;
1003: end LOCK_ROW;
1004:

Line 1043: app_exception.raise_exception;

1039: end if;
1040: else
1041: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1042: IGS_GE_MSG_STACK.ADD;
1043: app_exception.raise_exception;
1044: end if;
1045: Before_DML( p_action => 'UDPATE',
1046: x_rowid => X_ROWID,
1047: x_course_cd => X_COURSE_CD,