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

Line 47: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 103: APP_EXCEPTION.RAISE_EXCEPTION;

99: IF igs_gr_val_gc.assp_val_ve_closed( new_references.venue_cd,
100: v_message_name) = FALSE THEN
101: FND_MESSAGE.SET_NAME('IGS',V_MESSAGE_NAME);
102: IGS_GE_MSG_STACK.ADD;
103: APP_EXCEPTION.RAISE_EXCEPTION;
104: END IF;
105: -- Validate other elements on insert.
106: IF IGS_AS_VAL_EI.assp_val_ei_ins( new_references.exam_cal_type,
107: new_references.exam_ci_sequence_number,

Line 112: APP_EXCEPTION.RAISE_EXCEPTION;

108: new_references.ass_id,
109: v_message_name) = FALSE THEN
110: FND_MESSAGE.SET_NAME('IGS',V_MESSAGE_NAME);
111: IGS_GE_MSG_STACK.ADD;
112: APP_EXCEPTION.RAISE_EXCEPTION;
113: END IF;
114: END BeforeRowInsert1;
115: PROCEDURE Check_Parent_Existance AS
116: BEGIN

Line 124: APP_EXCEPTION.RAISE_EXCEPTION;

120: ELSIF NOT IGS_AS_ASSESSMNT_ITM_PKG.Get_PK_For_Validation (
121: new_references.ass_id ) THEN
122: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
123: IGS_GE_MSG_STACK.ADD;
124: APP_EXCEPTION.RAISE_EXCEPTION;
125:
126: END IF;
127: IF (((old_references.exam_cal_type = new_references.exam_cal_type) AND
128: (old_references.exam_ci_sequence_number = new_references.exam_ci_sequence_number) AND

Line 149: APP_EXCEPTION.RAISE_EXCEPTION;

145: new_references.start_time,
146: new_references.end_time ) THEN
147: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
148: IGS_GE_MSG_STACK.ADD;
149: APP_EXCEPTION.RAISE_EXCEPTION;
150:
151: END IF;
152: IF (((old_references.ese_id = new_references.ese_id)) OR
153: ((new_references.ese_id IS NULL))) THEN

Line 159: APP_EXCEPTION.RAISE_EXCEPTION;

155: ELSIF NOT IGS_AS_EXAM_SESSION_PKG.Get_UK_For_Validation (
156: new_references.ese_id ) THEN
157: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
158: IGS_GE_MSG_STACK.ADD;
159: APP_EXCEPTION.RAISE_EXCEPTION;
160:
161: END IF;
162: IF (((old_references.collect_person_id = new_references.collect_person_id)) OR
163: ((new_references.collect_person_id IS NULL))) THEN

Line 169: APP_EXCEPTION.RAISE_EXCEPTION;

165: ELSIF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
166: new_references.collect_person_id ) THEN
167: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
168: IGS_GE_MSG_STACK.ADD;
169: APP_EXCEPTION.RAISE_EXCEPTION;
170:
171: END IF;
172: IF (((old_references.venue_cd = new_references.venue_cd)) OR
173: ((new_references.venue_cd IS NULL))) THEN

Line 179: APP_EXCEPTION.RAISE_EXCEPTION;

175: ELSIF NOT IGS_GR_VENUE_PKG.Get_PK_For_Validation (
176: new_references.venue_cd ) THEN
177: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
178: IGS_GE_MSG_STACK.ADD;
179: APP_EXCEPTION.RAISE_EXCEPTION;
180:
181: END IF;
182: END Check_Parent_Existance;
183: PROCEDURE Check_Child_Existance AS

Line 255: APP_EXCEPTION.RAISE_EXCEPTION;

251: IF (cur_rowid%FOUND) THEN
252: Fnd_Message.Set_Name ('IGS', 'IGS_AS_EI_AI_FK');
253: IGS_GE_MSG_STACK.ADD;
254: Close cur_rowid;
255: APP_EXCEPTION.RAISE_EXCEPTION;
256:
257: Return;
258: END IF;
259: Close cur_rowid;

Line 286: APP_EXCEPTION.RAISE_EXCEPTION;

282: IF (cur_rowid%FOUND) THEN
283: Fnd_Message.Set_Name ('IGS', 'IGS_AS_EI_ESE_UFK');
284: IGS_GE_MSG_STACK.ADD;
285: Close cur_rowid;
286: APP_EXCEPTION.RAISE_EXCEPTION;
287:
288: Return;
289: END IF;
290: Close cur_rowid;

Line 307: APP_EXCEPTION.RAISE_EXCEPTION;

303: IF (cur_rowid%FOUND) THEN
304: Fnd_Message.Set_Name ('IGS', 'IGS_AS_EI_ESE_UFK');
305: IGS_GE_MSG_STACK.ADD;
306: Close cur_rowid;
307: APP_EXCEPTION.RAISE_EXCEPTION;
308:
309: Return;
310: END IF;
311: Close cur_rowid;

Line 328: APP_EXCEPTION.RAISE_EXCEPTION;

324: IF (cur_rowid%FOUND) THEN
325: Fnd_Message.Set_Name ('IGS', 'IGS_AS_EI_PE_FK');
326: IGS_GE_MSG_STACK.ADD;
327: Close cur_rowid;
328: APP_EXCEPTION.RAISE_EXCEPTION;
329:
330: Return;
331: END IF;
332: Close cur_rowid;

Line 349: APP_EXCEPTION.RAISE_EXCEPTION;

345: IF (cur_rowid%FOUND) THEN
346: Fnd_Message.Set_Name ('IGS', 'IGS_AS_EI_VE_FK');
347: IGS_GE_MSG_STACK.ADD;
348: Close cur_rowid;
349: APP_EXCEPTION.RAISE_EXCEPTION;
350:
351: Return;
352: END IF;
353: Close cur_rowid;

Line 423: APP_EXCEPTION.RAISE_EXCEPTION;

419: new_references.end_time ,
420: new_references.venue_cd ) THEN
421: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
422: IGS_GE_MSG_STACK.ADD;
423: APP_EXCEPTION.RAISE_EXCEPTION;
424: END IF;
425:
426: Check_Constraints;
427: Check_Parent_Existance;

Line 446: APP_EXCEPTION.RAISE_EXCEPTION;

442: new_references.end_time ,
443: new_references.venue_cd ) THEN
444: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
445: IGS_GE_MSG_STACK.ADD;
446: APP_EXCEPTION.RAISE_EXCEPTION;
447: END IF;
448:
449: Check_Constraints;
450: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 510: APP_EXCEPTION.RAISE_EXCEPTION;

506: end if;
507: else
508: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
509: IGS_GE_MSG_STACK.ADD;
510: APP_EXCEPTION.RAISE_EXCEPTION;
511: end if;
512: Before_DML(
513: p_action=>'INSERT',
514: x_rowid=>X_ROWID,

Line 636: APP_EXCEPTION.RAISE_EXCEPTION;

632: fetch c1 into tlinfo;
633: if (c1%notfound) then
634: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
635: IGS_GE_MSG_STACK.ADD;
636: APP_EXCEPTION.RAISE_EXCEPTION;
637: close c1;
638: return;
639: end if;
640: close c1;

Line 669: APP_EXCEPTION.RAISE_EXCEPTION;

665: null;
666: else
667: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
668: IGS_GE_MSG_STACK.ADD;
669: APP_EXCEPTION.RAISE_EXCEPTION;
670: end if;
671: return;
672: end LOCK_ROW;
673: procedure UPDATE_ROW (

Line 714: APP_EXCEPTION.RAISE_EXCEPTION;

710: end if;
711: else
712: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
713: IGS_GE_MSG_STACK.ADD;
714: APP_EXCEPTION.RAISE_EXCEPTION;
715: end if;
716: Before_DML(
717: p_action=>'UPDATE',
718: x_rowid=>X_ROWID,

Line 888: APP_EXCEPTION.RAISE_EXCEPTION;

884: column_name is null Then
885: IF new_references.DT_ALIAS <> UPPER(new_references.DT_ALIAS) Then
886: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
887: IGS_GE_MSG_STACK.ADD;
888: APP_EXCEPTION.RAISE_EXCEPTION;
889: END IF;
890: END IF;
891: IF upper(column_name) = 'EXAM_CAL_TYPE' OR
892: column_name is null Then

Line 896: APP_EXCEPTION.RAISE_EXCEPTION;

892: column_name is null Then
893: IF new_references.EXAM_CAL_TYPE <> UPPER(new_references.EXAM_CAL_TYPE) Then
894: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
895: IGS_GE_MSG_STACK.ADD;
896: APP_EXCEPTION.RAISE_EXCEPTION;
897: END IF;
898: END IF;
899: IF upper(column_name) = 'SPECIAL_SESSION_IND' OR
900: column_name is null Then

Line 904: APP_EXCEPTION.RAISE_EXCEPTION;

900: column_name is null Then
901: IF new_references.SPECIAL_SESSION_IND <> UPPER(new_references.SPECIAL_SESSION_IND) Then
902: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
903: IGS_GE_MSG_STACK.ADD;
904: APP_EXCEPTION.RAISE_EXCEPTION;
905: END IF;
906: END IF;
907: IF upper(column_name) = 'VENUE_CD' OR
908: column_name is null Then

Line 912: APP_EXCEPTION.RAISE_EXCEPTION;

908: column_name is null Then
909: IF new_references.VENUE_CD <> UPPER(new_references.VENUE_CD) Then
910: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
911: IGS_GE_MSG_STACK.ADD;
912: APP_EXCEPTION.RAISE_EXCEPTION;
913: END IF;
914: END IF;
915:
916: IF upper(column_name) = 'DAI_SEQUENCE_NUMBER' OR

Line 921: APP_EXCEPTION.RAISE_EXCEPTION;

917: column_name is null Then
918: IF new_references.DAI_SEQUENCE_NUMBER < 1 OR new_references.DAI_SEQUENCE_NUMBER > 99999 Then
919: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
920: IGS_GE_MSG_STACK.ADD;
921: APP_EXCEPTION.RAISE_EXCEPTION;
922: END IF;
923: END IF;
924:
925: IF upper(column_name) = 'EXAM_CI_SEQUENCE_NUMBER' OR

Line 930: APP_EXCEPTION.RAISE_EXCEPTION;

926: column_name is null Then
927: IF new_references.EXAM_CI_SEQUENCE_NUMBER < 1 OR new_references.EXAM_CI_SEQUENCE_NUMBER> 99999 Then
928: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
929: IGS_GE_MSG_STACK.ADD;
930: APP_EXCEPTION.RAISE_EXCEPTION;
931: END IF;
932: END IF;
933:
934: IF upper(column_name) = 'SPECIAL_SESSION_IND' OR

Line 939: APP_EXCEPTION.RAISE_EXCEPTION;

935: column_name is null Then
936: IF new_references.SPECIAL_SESSION_IND NOT IN ('Y','N') Then
937: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
938: IGS_GE_MSG_STACK.ADD;
939: APP_EXCEPTION.RAISE_EXCEPTION;
940: END IF;
941: END IF;
942: IF upper(column_name) = 'ESE_ID' OR
943: column_name is null Then

Line 947: APP_EXCEPTION.RAISE_EXCEPTION;

943: column_name is null Then
944: IF new_references.ESE_ID < 1 OR new_references.ESE_ID > 999999 Then
945: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
946: IGS_GE_MSG_STACK.ADD;
947: APP_EXCEPTION.RAISE_EXCEPTION;
948: END IF;
949: END IF;
950:
951: