APPS.IGS_AS_EXM_SPRVSRTYP_PKG dependencies on APP_EXCEPTION

Line 39: App_Exception.Raise_Exception;

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

Line 125: App_Exception.Raise_Exception;

121: column_name is null Then
122: IF new_references.closed_ind <> UPPER(new_references.closed_ind) OR new_references.closed_ind NOT IN ( 'Y' , 'N' )Then
123: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
124: Igs_Ge_Msg_Stack.Add;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;
128:
129: IF upper(column_name) = 'IN_CHARGE_IND' OR

Line 134: App_Exception.Raise_Exception;

130: column_name is null Then
131: IF new_references.in_charge_ind <> UPPER(new_references.in_charge_ind) OR new_references.in_charge_ind NOT IN ( 'Y' , 'N' ) Then
132: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
133: Igs_Ge_Msg_Stack.Add;
134: App_Exception.Raise_Exception;
135: END IF;
136: END IF;
137: IF upper(column_name) = 'EXAM_SUPERVISOR_TYPE' OR
138: column_name is null Then

Line 142: App_Exception.Raise_Exception;

138: column_name is null Then
139: IF new_references.exam_supervisor_type <> UPPER(new_references.exam_supervisor_type) Then
140: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
141: Igs_Ge_Msg_Stack.Add;
142: App_Exception.Raise_Exception;
143: END IF;
144: END IF;
145:
146: END Check_Constraints;

Line 186: App_Exception.Raise_Exception;

182: new_references.exam_supervisor_type
183: ) THEN
184: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
185: Igs_Ge_Msg_Stack.Add;
186: App_Exception.Raise_Exception;
187: END IF;
188:
189: Check_Constraints;
190: ELSIF (p_action = 'UPDATE') THEN

Line 204: App_Exception.Raise_Exception;

200: new_references.exam_supervisor_type
201: ) THEN
202: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
203: Igs_Ge_Msg_Stack.Add;
204: App_Exception.Raise_Exception;
205: END IF;
206: Check_Constraints;
207: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
208: Check_Constraints;

Line 253: app_exception.raise_exception;

249: end if;
250: else
251: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
252: Igs_Ge_Msg_Stack.Add;
253: app_exception.raise_exception;
254: end if;
255: Before_DML(
256: p_action=>'INSERT',
257: x_rowid=>X_ROWID,

Line 321: app_exception.raise_exception;

317: if (c1%notfound) then
318: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
319: Igs_Ge_Msg_Stack.Add;
320: close c1;
321: app_exception.raise_exception;
322: return;
323: end if;
324: close c1;
325:

Line 334: app_exception.raise_exception;

330: null;
331: else
332: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
333: Igs_Ge_Msg_Stack.Add;
334: app_exception.raise_exception;
335: end if;
336: return;
337: end LOCK_ROW;
338:

Line 367: app_exception.raise_exception;

363: end if;
364: else
365: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
366: Igs_Ge_Msg_Stack.Add;
367: app_exception.raise_exception;
368: end if;
369: Before_DML(
370: p_action=>'UPDATE',
371: x_rowid=>X_ROWID,