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

Line 42: app_exception.raise_exception;

38: IF cur_delete%NOTFOUND THEN
39: CLOSE cur_delete;
40: fnd_message.set_name('IGS','IGS_PS_UNIT_SET_NO_DEL_ALLOWED');
41: igs_ge_msg_stack.add;
42: app_exception.raise_exception;
43: END IF;
44: CLOSE cur_delete;
45: END beforerowdelete;
46:

Line 93: app_exception.raise_exception;

89: IF cur_check_update%FOUND THEN
90: CLOSE cur_check_update;
91: fnd_message.set_name('IGS','IGS_PS_UNIT_SET_STATUS_NOTALT');
92: igs_ge_msg_stack.add;
93: app_exception.raise_exception;
94: END IF;
95: CLOSE cur_check_update;
96: END IF;
97: ELSE

Line 102: app_exception.raise_exception;

98: -- If the unit set status is not found then the record might have been deleted
99: CLOSE cur_get_status;
100: fnd_message.set_name('FND','FORM_RECORD_DELETED');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: END IF;
104: END beforerowupdate;
105:
106: PROCEDURE Set_Column_Values (

Line 170: App_Exception.Raise_Exception;

166: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
167: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
168: IGS_GE_MSG_STACK.ADD;
169: Close cur_old_ref_values;
170: App_Exception.Raise_Exception;
171: Return;
172: END IF;
173: Close cur_old_ref_values;
174:

Line 252: App_Exception.Raise_Exception;

248: new_references.responsible_ou_start_dt,
249: v_message_name) = FALSE THEN
250: Fnd_Message.Set_Name('IGS', v_message_name);
251: IGS_GE_MSG_STACK.ADD;
252: App_Exception.Raise_Exception;
253: END IF;
254: --
255: -- UNIT set status closed validation
256: IF IGS_PS_VAL_US.crsp_val_uss_closed (

Line 261: App_Exception.Raise_Exception;

257: new_references.unit_set_status,
258: v_message_name) = FALSE THEN
259: Fnd_Message.Set_Name('IGS', v_message_name);
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: --
264: -- UNIT set category closed validation
265: IF IGS_PS_VAL_US.crsp_val_usc_closed (

Line 270: App_Exception.Raise_Exception;

266: new_references.UNIT_SET_CAT,
267: v_message_name) = FALSE THEN
268: Fnd_Message.Set_Name('IGS', v_message_name);
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception;
271: END IF;
272: END IF;
273: -- Validate that inserts/updates are allowed
274: IF p_inserting OR p_updating THEN

Line 284: App_Exception.Raise_Exception;

280: new_references.expiry_dt,
281: v_message_name,FALSE) = FALSE THEN
282: Fnd_Message.Set_Name('IGS', v_message_name);
283: IGS_GE_MSG_STACK.ADD;
284: App_Exception.Raise_Exception;
285: END IF;
286: --
287: -- End date/UNIT set status cross-field validation
288: IF IGS_PS_VAL_US.crsp_val_us_end_sts (

Line 294: App_Exception.Raise_Exception;

290: new_references.unit_set_status,
291: v_message_name) = FALSE THEN
292: Fnd_Message.Set_Name('IGS', v_message_name);
293: IGS_GE_MSG_STACK.ADD;
294: App_Exception.Raise_Exception;
295: END IF;
296: --
297: -- Validate end date/UNIT set status when there are active students
298: IF new_references.end_dt IS NOT NULL or

Line 306: App_Exception.Raise_Exception;

302: new_references.version_number,
303: v_message_name) = FALSE THEN
304: Fnd_Message.Set_Name('IGS', v_message_name);
305: IGS_GE_MSG_STACK.ADD;
306: App_Exception.Raise_Exception;
307: END IF;
308: END IF;
309: --
310: -- Validate UNIT set status changes

Line 317: App_Exception.Raise_Exception;

313: new_references.unit_set_status,
314: v_message_name) = FALSE THEN
315: Fnd_Message.Set_Name('IGS', v_message_name);
316: IGS_GE_MSG_STACK.ADD;
317: App_Exception.Raise_Exception;
318: END IF;
319: --
320: -- Validate details can not be altered when INACTIVE unless
321: -- changing back to ACTIVE

Line 330: App_Exception.Raise_Exception;

326: new_references.version_number,
327: v_message_name) = FALSE THEN
328: Fnd_Message.Set_Name('IGS', v_message_name);
329: IGS_GE_MSG_STACK.ADD;
330: App_Exception.Raise_Exception;
331: END IF;
332: END IF;
333:
334:

Line 358: App_Exception.Raise_Exception;

354: New_References.expiry_dt,
355: v_message_name) = FALSE THEN
356: Fnd_Message.Set_Name('IGS', v_message_name);
357: IGS_GE_MSG_STACK.ADD;
358: App_Exception.Raise_Exception;
359: END IF;
360:
361: END AfterRowInsertUpdate2;
362:

Line 450: App_Exception.Raise_Exception;

446: IF ((UPPER (column_name) = 'ADMINISTRATIVE_IND') OR (column_name IS NULL)) THEN
447: IF new_references.administrative_ind NOT IN ('Y' , 'N' ) THEN
448: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
449: IGS_GE_MSG_STACK.ADD;
450: App_Exception.Raise_Exception;
451: END IF;
452: END IF;
453:
454:

Line 460: App_Exception.Raise_Exception;

456: IF new_references.version_number < 1 OR
457: new_references.version_number > 999 THEN
458: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
459: IGS_GE_MSG_STACK.ADD;
460: App_Exception.Raise_Exception;
461: END IF;
462: END IF;
463:
464:

Line 469: App_Exception.Raise_Exception;

465: IF ((UPPER (column_name) = 'AUTHORISATION_RQRD_IND') OR (column_name IS NULL)) THEN
466: IF (new_references.authorisation_rqrd_ind <> UPPER (new_references.authorisation_rqrd_ind)) THEN
467: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
468: IGS_GE_MSG_STACK.ADD;
469: App_Exception.Raise_Exception;
470: END IF;
471: END IF;
472:
473:

Line 478: App_Exception.Raise_Exception;

474: IF ((UPPER (column_name) = 'ABBREVIATION') OR (column_name IS NULL)) THEN
475: IF (new_references.abbreviation <> UPPER (new_references.abbreviation)) THEN
476: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
477: IGS_GE_MSG_STACK.ADD;
478: App_Exception.Raise_Exception;
479: END IF;
480: END IF;
481:
482: IF ((UPPER (column_name) = 'UNIT_SET_CAT') OR (column_name IS NULL)) THEN

Line 486: App_Exception.Raise_Exception;

482: IF ((UPPER (column_name) = 'UNIT_SET_CAT') OR (column_name IS NULL)) THEN
483: IF (new_references.UNIT_SET_CAT <> UPPER (new_references.UNIT_SET_CAT)) THEN
484: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
485: IGS_GE_MSG_STACK.ADD;
486: App_Exception.Raise_Exception;
487: END IF;
488: END IF;
489:
490:

Line 495: App_Exception.Raise_Exception;

491: IF ((UPPER (column_name) = 'UNIT_SET_CD') OR (column_name IS NULL)) THEN
492: IF (new_references.unit_set_cd <> UPPER (new_references.unit_set_cd)) THEN
493: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
494: IGS_GE_MSG_STACK.ADD;
495: App_Exception.Raise_Exception;
496: END IF;
497: END IF;
498:
499: IF ((UPPER (column_name) = 'UNIT_SET_STATUS') OR (column_name IS NULL)) THEN

Line 503: App_Exception.Raise_Exception;

499: IF ((UPPER (column_name) = 'UNIT_SET_STATUS') OR (column_name IS NULL)) THEN
500: IF (new_references.UNIT_SET_STATUS <> UPPER (new_references.UNIT_SET_STATUS)) THEN
501: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
502: IGS_GE_MSG_STACK.ADD;
503: App_Exception.Raise_Exception;
504: END IF;
505: END IF;
506:
507:

Line 527: App_Exception.Raise_Exception;

523: ) THEN
524:
525: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
526: IGS_GE_MSG_STACK.ADD;
527: App_Exception.Raise_Exception;
528:
529: END IF;
530:
531: END IF;

Line 544: App_Exception.Raise_Exception;

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

Line 560: App_Exception.Raise_Exception;

556: ) THEN
557:
558: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
559: IGS_GE_MSG_STACK.ADD;
560: App_Exception.Raise_Exception;
561:
562: END IF;
563: END IF;
564:

Line 781: App_Exception.Raise_Exception;

777: IF (cur_rowid%FOUND) THEN
778: Fnd_Message.Set_Name ('IGS', 'IGS_EN_US_OU_FK');
779: IGS_GE_MSG_STACK.ADD;
780: Close cur_rowid;
781: App_Exception.Raise_Exception;
782: Return;
783: END IF;
784: Close cur_rowid;
785:

Line 807: App_Exception.Raise_Exception;

803: IF (cur_rowid%FOUND) THEN
804: Fnd_Message.Set_Name ('IGS', 'IGS_EN_US_USC_FK');
805: IGS_GE_MSG_STACK.ADD;
806: Close cur_rowid;
807: App_Exception.Raise_Exception;
808: Return;
809: END IF;
810: Close cur_rowid;
811:

Line 833: App_Exception.Raise_Exception;

829: IF (cur_rowid%FOUND) THEN
830: Fnd_Message.Set_Name ('IGS', 'IGS_EN_US_USS_FK');
831: IGS_GE_MSG_STACK.ADD;
832: Close cur_rowid;
833: App_Exception.Raise_Exception;
834: Return;
835: END IF;
836: Close cur_rowid;
837: END GET_FK_IGS_EN_UNIT_SET_STAT;

Line 945: App_Exception.Raise_Exception;

941: ) THEN
942:
943: Fnd_message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
944: IGS_GE_MSG_STACK.ADD;
945: App_Exception.Raise_Exception;
946:
947: END IF;
948:
949: Check_Constraints;

Line 970: App_Exception.Raise_Exception;

966: new_references.version_number
967: ) THEN
968: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
969: IGS_GE_MSG_STACK.ADD;
970: App_Exception.Raise_Exception;
971: END IF;
972: Check_Constraints;
973: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
974: Check_Constraints;

Line 1072: app_exception.raise_exception;

1068: end if;
1069: else
1070: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1071: IGS_GE_MSG_STACK.ADD;
1072: app_exception.raise_exception;
1073: end if;
1074:
1075: Before_DML (
1076: p_action => 'INSERT',

Line 1311: app_exception.raise_exception;

1307: if (c1%notfound) then
1308: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1309: IGS_GE_MSG_STACK.ADD;
1310: close c1;
1311: app_exception.raise_exception;
1312: return;
1313: end if;
1314: close c1;
1315:

Line 1386: app_exception.raise_exception;

1382: null;
1383: else
1384: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1385: IGS_GE_MSG_STACK.ADD;
1386: app_exception.raise_exception;
1387: end if;
1388: return;
1389: end LOCK_ROW;
1390:

Line 1451: app_exception.raise_exception;

1447: end if;
1448: else
1449: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1450: IGS_GE_MSG_STACK.ADD;
1451: app_exception.raise_exception;
1452: end if;
1453:
1454: Before_DML(
1455: p_action => 'UPDATE' ,