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

Line 41: App_Exception.Raise_Exception;

37: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: Igs_Ge_Msg_Stack.Add;
40: Close cur_old_ref_values;
41: App_Exception.Raise_Exception;
42: Return;
43: END IF;
44: Close cur_old_ref_values;
45:

Line 81: App_Exception.Raise_Exception;

77: IF IGS_AS_VAL_ESU.assp_val_est_closed(new_references.exam_supervisor_type,
78: v_message_name) = FALSE THEN
79: Fnd_Message.Set_Name('IGS', v_message_name);
80: Igs_Ge_Msg_Stack.Add;
81: App_Exception.Raise_Exception;
82: END IF;
83: END IF;
84: -- Validate that the organisation IGS_PS_UNIT is not INACTIVE.
85: IF p_inserting OR

Line 97: App_Exception.Raise_Exception;

93: new_references.responsible_ou_start_dt,
94: v_message_name) = FALSE THEN
95: Fnd_Message.Set_Name('IGS', v_message_name);
96: Igs_Ge_Msg_Stack.Add;
97: App_Exception.Raise_Exception;
98: END IF;
99: END IF;
100:
101:

Line 116: App_Exception.Raise_Exception;

112: new_references.exam_supervisor_type
113: ))THEN
114: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
115: Igs_Ge_Msg_Stack.Add;
116: App_Exception.Raise_Exception;
117: END IF;
118:
119: END IF;
120:

Line 133: App_Exception.Raise_Exception;

129: new_references.responsible_ou_start_dt
130: ))THEN
131: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
132: Igs_Ge_Msg_Stack.Add;
133: App_Exception.Raise_Exception;
134: END IF;
135: END IF;
136:
137: IF (((old_references.person_id = new_references.person_id)) OR

Line 146: App_Exception.Raise_Exception;

142: new_references.person_id
143: ))THEN
144: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
145: Igs_Ge_Msg_Stack.Add;
146: App_Exception.Raise_Exception;
147: END IF;
148: END IF;
149:
150: END Check_Parent_Existance;

Line 172: App_Exception.Raise_Exception;

168: column_name is null Then
169: IF new_references.exam_supervisor_type <> UPPER(new_references.exam_supervisor_type) Then
170: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
171: Igs_Ge_Msg_Stack.Add;
172: App_Exception.Raise_Exception;
173: END IF;
174: END IF;
175:
176: IF upper(column_name) = 'PREVIOUS_SESSIONS' OR

Line 181: App_Exception.Raise_Exception;

177: column_name is null Then
178: IF new_references.previous_sessions < 0 AND new_references.previous_sessions > 9999 Then
179: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
180: Igs_Ge_Msg_Stack.Add;
181: App_Exception.Raise_Exception;
182: END IF;
183: END IF;
184: END Check_Constraints;
185:

Line 248: App_Exception.Raise_Exception;

244: IF (cur_rowid%FOUND) THEN
245: Fnd_Message.Set_Name ('IGS', 'IGS_AS_ESU_EST_FK');
246: Igs_Ge_Msg_Stack.Add;
247: Close cur_rowid;
248: App_Exception.Raise_Exception;
249: Return;
250: END IF;
251: Close cur_rowid;
252:

Line 276: App_Exception.Raise_Exception;

272: IF (cur_rowid%FOUND) THEN
273: Fnd_Message.Set_Name ('IGS', 'IGS_AS_ESU_OU_FK');
274: Igs_Ge_Msg_Stack.Add;
275: Close cur_rowid;
276: App_Exception.Raise_Exception;
277: Return;
278: END IF;
279: Close cur_rowid;
280:

Line 302: App_Exception.Raise_Exception;

298: IF (cur_rowid%FOUND) THEN
299: Fnd_Message.Set_Name ('IGS', 'IGS_AS_ESU_PE_FK');
300: Igs_Ge_Msg_Stack.Add;
301: Close cur_rowid;
302: App_Exception.Raise_Exception;
303: Return;
304: END IF;
305: Close cur_rowid;
306:

Line 352: App_Exception.Raise_Exception;

348: new_references.person_id
349: ) THEN
350: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
351: Igs_Ge_Msg_Stack.Add;
352: App_Exception.Raise_Exception;
353: END IF;
354:
355: Check_Constraints;
356: Check_Parent_Existance;

Line 372: App_Exception.Raise_Exception;

368: new_references.person_id
369: ) THEN
370: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
371: Igs_Ge_Msg_Stack.Add;
372: App_Exception.Raise_Exception;
373: END IF;
374: Check_Constraints;
375: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
376: Check_Constraints;

Line 419: app_exception.raise_exception;

415: end if;
416: else
417: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
418: Igs_Ge_Msg_Stack.Add;
419: app_exception.raise_exception;
420: end if;
421: Before_DML(
422: p_action=>'INSERT',
423: x_rowid=>X_ROWID,

Line 500: app_exception.raise_exception;

496: if (c1%notfound) then
497: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
498: Igs_Ge_Msg_Stack.Add;
499: close c1;
500: app_exception.raise_exception;
501: return;
502: end if;
503: close c1;
504:

Line 523: app_exception.raise_exception;

519: null;
520: else
521: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
522: Igs_Ge_Msg_Stack.Add;
523: app_exception.raise_exception;
524: end if;
525: return;
526: end LOCK_ROW;
527:

Line 558: app_exception.raise_exception;

554: end if;
555: else
556: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
557: Igs_Ge_Msg_Stack.Add;
558: app_exception.raise_exception;
559: end if;
560: Before_DML(
561: p_action=>'UPDATE',
562: x_rowid=>X_ROWID,