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

Line 43: APP_EXCEPTION.RAISE_EXCEPTION;

39: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
40:
41: IGS_GE_MSG_STACK.ADD;
42: Close cur_old_ref_values;
43: APP_EXCEPTION.RAISE_EXCEPTION;
44:
45: Return;
46: END IF;
47: Close cur_old_ref_values;

Line 100: APP_EXCEPTION.RAISE_EXCEPTION;

96: IF IGS_AS_VAL_ESU.assp_val_est_closed(new_references.exam_supervisor_type,
97: v_message_name) = FALSE THEN
98: FND_message.SET_NAME('IGS',v_message_name);
99: IGS_GE_MSG_STACK.ADD;
100: APP_EXCEPTION.RAISE_EXCEPTION;
101: END IF;
102: END IF;
103: END BeforeRowInsertUpdate1;
104:

Line 135: APP_EXCEPTION.RAISE_EXCEPTION;

131: new_references.end_time,
132: new_references.venue_cd ) THEN
133: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
134: IGS_GE_MSG_STACK.ADD;
135: APP_EXCEPTION.RAISE_EXCEPTION;
136:
137:
138: END IF;
139: IF (((old_references.ese_id = new_references.ese_id)) OR

Line 146: APP_EXCEPTION.RAISE_EXCEPTION;

142: ELSIF NOT IGS_AS_EXAM_SESSION_PKG.Get_UK_For_Validation (
143: new_references.ese_id )THEN
144: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
145: IGS_GE_MSG_STACK.ADD;
146: APP_EXCEPTION.RAISE_EXCEPTION;
147:
148: END IF;
149: IF (((old_references.exam_supervisor_type = new_references.exam_supervisor_type)) OR
150: ((new_references.exam_supervisor_type IS NULL))) THEN

Line 157: APP_EXCEPTION.RAISE_EXCEPTION;

153: new_references.exam_supervisor_type
154: )THEN
155: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
156: IGS_GE_MSG_STACK.ADD;
157: APP_EXCEPTION.RAISE_EXCEPTION;
158:
159: END IF;
160: IF (((old_references.person_id = new_references.person_id)) OR
161: ((new_references.person_id IS NULL))) THEN

Line 167: APP_EXCEPTION.RAISE_EXCEPTION;

163: ELSIF NOT IGS_AS_EXM_SUPRVISOR_PKG.Get_PK_For_Validation (
164: new_references.person_id )THEN
165: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
166: IGS_GE_MSG_STACK.ADD;
167: APP_EXCEPTION.RAISE_EXCEPTION;
168:
169: END IF;
170: END Check_Parent_Existance;
171: function Get_PK_For_Validation (

Line 237: APP_EXCEPTION.RAISE_EXCEPTION;

233: IF (cur_rowid%FOUND) THEN
234: Fnd_Message.Set_Name ('IGS', 'IGS_AS_EIS_EI_FK');
235: IGS_GE_MSG_STACK.ADD;
236: Close cur_rowid;
237: APP_EXCEPTION.RAISE_EXCEPTION;
238:
239: Return;
240: END IF;
241: Close cur_rowid;

Line 258: APP_EXCEPTION.RAISE_EXCEPTION;

254: IF (cur_rowid%FOUND) THEN
255: Fnd_Message.Set_Name ('IGS', 'IGS_AS_EIS_ESE_UFK');
256: IGS_GE_MSG_STACK.ADD;
257: Close cur_rowid;
258: APP_EXCEPTION.RAISE_EXCEPTION;
259:
260: Return;
261: END IF;
262: Close cur_rowid;

Line 279: APP_EXCEPTION.RAISE_EXCEPTION;

275: IF (cur_rowid%FOUND) THEN
276: Fnd_Message.Set_Name ('IGS', 'IGS_AS_EIS_EST_FK');
277: IGS_GE_MSG_STACK.ADD;
278: Close cur_rowid;
279: APP_EXCEPTION.RAISE_EXCEPTION;
280:
281: Return;
282: END IF;
283: Close cur_rowid;

Line 300: APP_EXCEPTION.RAISE_EXCEPTION;

296: IF (cur_rowid%FOUND) THEN
297: Fnd_Message.Set_Name ('IGS', 'IGS_AS_EIS_ESU_FK');
298: IGS_GE_MSG_STACK.ADD;
299: Close cur_rowid;
300: APP_EXCEPTION.RAISE_EXCEPTION;
301:
302: Return;
303: END IF;
304: Close cur_rowid;

Line 367: APP_EXCEPTION.RAISE_EXCEPTION;

363: NEW_REFERENCES.end_time,
364: NEW_REFERENCES.venue_cd ) THEN
365: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
366: IGS_GE_MSG_STACK.ADD;
367: APP_EXCEPTION.RAISE_EXCEPTION;
368: END IF;
369:
370: Check_Constraints;
371: Check_Parent_Existance;

Line 391: APP_EXCEPTION.RAISE_EXCEPTION;

387: NEW_REFERENCES.end_time,
388: NEW_REFERENCES.venue_cd ) THEN
389: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
390: IGS_GE_MSG_STACK.ADD;
391: APP_EXCEPTION.RAISE_EXCEPTION;
392: END IF;
393:
394: Check_Constraints;
395: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 448: APP_EXCEPTION.RAISE_EXCEPTION;

444: end if;
445: else
446: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
447: IGS_GE_MSG_STACK.ADD;
448: APP_EXCEPTION.RAISE_EXCEPTION;
449: end if;
450: Before_DML(
451: p_action=>'INSERT',
452: x_rowid=>X_ROWID,

Line 550: APP_EXCEPTION.RAISE_EXCEPTION;

546: fetch c1 into tlinfo;
547: if (c1%notfound) then
548: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
549: IGS_GE_MSG_STACK.ADD;
550: APP_EXCEPTION.RAISE_EXCEPTION;
551: close c1;
552: return;
553: end if;
554: close c1;

Line 568: APP_EXCEPTION.RAISE_EXCEPTION;

564: null;
565: else
566: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
567: IGS_GE_MSG_STACK.ADD;
568: APP_EXCEPTION.RAISE_EXCEPTION;
569: end if;
570: return;
571: end LOCK_ROW;
572: procedure UPDATE_ROW (

Line 609: APP_EXCEPTION.RAISE_EXCEPTION;

605: end if;
606: else
607: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
608: IGS_GE_MSG_STACK.ADD;
609: APP_EXCEPTION.RAISE_EXCEPTION;
610: end if;
611: Before_DML(
612: p_action=>'UPDATE',
613: x_rowid=>X_ROWID,

Line 760: APP_EXCEPTION.RAISE_EXCEPTION;

756: column_name is null Then
757: IF new_references.DT_ALIAS <> UPPER(new_references.DT_ALIAS) Then
758: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
759: IGS_GE_MSG_STACK.ADD;
760: APP_EXCEPTION.RAISE_EXCEPTION;
761: END IF;
762: END IF;
763: IF upper(column_name) = 'EXAM_CAL_TYPE' OR
764: column_name is null Then

Line 768: APP_EXCEPTION.RAISE_EXCEPTION;

764: column_name is null Then
765: IF new_references.EXAM_CAL_TYPE <> UPPER(new_references.EXAM_CAL_TYPE) Then
766: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
767: IGS_GE_MSG_STACK.ADD;
768: APP_EXCEPTION.RAISE_EXCEPTION;
769: END IF;
770: END IF;
771: IF upper(column_name) = 'EXAM_SUPERVISOR_TYPE' OR
772: column_name is null Then

Line 776: APP_EXCEPTION.RAISE_EXCEPTION;

772: column_name is null Then
773: IF new_references.EXAM_SUPERVISOR_TYPE <> UPPER(new_references.EXAM_SUPERVISOR_TYPE) Then
774: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
775: IGS_GE_MSG_STACK.ADD;
776: APP_EXCEPTION.RAISE_EXCEPTION;
777: END IF;
778: END IF;
779: IF upper(column_name) = 'VENUE_CD' OR
780: column_name is null Then

Line 784: APP_EXCEPTION.RAISE_EXCEPTION;

780: column_name is null Then
781: IF new_references.VENUE_CD <> UPPER(new_references.VENUE_CD) Then
782: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
783: IGS_GE_MSG_STACK.ADD;
784: APP_EXCEPTION.RAISE_EXCEPTION;
785: END IF;
786: END IF;
787:
788: IF upper(column_name) = 'DAI_SEQUENCE_NUMBER' OR

Line 793: APP_EXCEPTION.RAISE_EXCEPTION;

789: column_name is null Then
790: IF new_references.DAI_SEQUENCE_NUMBER < 1 OR new_references.DAI_SEQUENCE_NUMBER > 999999 THEN
791: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
792: IGS_GE_MSG_STACK.ADD;
793: APP_EXCEPTION.RAISE_EXCEPTION;
794: END IF;
795: END IF;
796: IF upper(column_name) = 'EXAM_CI_SEQUENCE_NUMBER' OR
797: column_name is null Then

Line 801: APP_EXCEPTION.RAISE_EXCEPTION;

797: column_name is null Then
798: IF new_references.EXAM_CI_SEQUENCE_NUMBER < 1 OR new_references.EXAM_CI_SEQUENCE_NUMBER > 999999 Then
799: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
800: IGS_GE_MSG_STACK.ADD;
801: APP_EXCEPTION.RAISE_EXCEPTION;
802: END IF;
803: END IF;
804: IF upper(column_name) = 'ESE_ID' OR
805: column_name is null Then

Line 809: APP_EXCEPTION.RAISE_EXCEPTION;

805: column_name is null Then
806: IF new_references.ESE_ID < 1 OR new_references.ESE_ID > 999999 Then
807: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
808: IGS_GE_MSG_STACK.ADD;
809: APP_EXCEPTION.RAISE_EXCEPTION;
810: END IF;
811: END IF;
812: END Check_Constraints;
813: end IGS_AS_EXM_INS_SPVSR_PKG;