DBA Data[Home] [Help]

APPS.IGS_GE_NOTE_PKG dependencies on APP_EXCEPTION

Line 38: App_Exception.Raise_Exception;

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

Line 74: App_Exception.Raise_Exception;

70: IF upper(Column_name) = 'S_NOTE_FORMAT_TYPE' OR column_name is null then
71: IF new_references.s_note_format_type <> UPPER(new_references.s_note_format_type) then
72: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
73: IGS_GE_MSG_STACK.ADD;
74: App_Exception.Raise_Exception;
75: END IF;
76: END IF;
77:
78: END Check_Constraints;

Line 94: App_Exception.Raise_Exception;

90: new_references.s_note_format_type
91: ) THEN
92: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96:
97: END IF;
98:

Line 239: App_Exception.Raise_Exception;

235: IF (p_action = 'INSERT') THEN
236: IF GET_PK_FOR_VALIDATION (new_references.reference_number) THEN
237: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
238: IGS_GE_MSG_STACK.ADD;
239: App_Exception.Raise_Exception;
240: END IF;
241: Check_Constraints;
242: -- Call all the procedures related to Before Insert.
243: Check_Parent_Existance;

Line 255: App_Exception.Raise_Exception;

251: ELSIF (p_action = 'VALIDATE_INSERT') THEN
252: IF GET_PK_FOR_VALIDATION (new_references.reference_number) THEN
253: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: END IF;
257: Check_Constraints;
258: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
259: Check_Constraints;

Line 316: app_exception.raise_exception;

312: end if;
313: else
314: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
315: IGS_GE_MSG_STACK.ADD;
316: app_exception.raise_exception;
317: end if;
318: Before_DML (
319: p_action => 'INSERT',
320: x_rowid => X_ROWID,

Line 385: app_exception.raise_exception;

381: if (c1%notfound) then
382: close c1;
383: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
384: IGS_GE_MSG_STACK.ADD;
385: app_exception.raise_exception;
386: return;
387: end if;
388: close c1;
389:

Line 400: app_exception.raise_exception;

396: null;
397: else
398: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
399: IGS_GE_MSG_STACK.ADD;
400: app_exception.raise_exception;
401: end if;
402: return;
403: end LOCK_ROW;
404:

Line 432: app_exception.raise_exception;

428: end if;
429: else
430: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
431: IGS_GE_MSG_STACK.ADD;
432: app_exception.raise_exception;
433: end if;
434:
435: Before_DML (
436: p_action => 'UPDATE',