APPS.IGS_GR_NOTE_TYPE_PKG dependencies on APP_EXCEPTION

Line 35: App_Exception.Raise_Exception;

31: Fetch cur_old_ref_values INTO old_references;
32: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
33: Close cur_old_ref_values;
34: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
35: App_Exception.Raise_Exception;
36: Return;
37: END IF;
38: Close cur_old_ref_values;
39:

Line 97: App_Exception.Raise_Exception ;

93:
94: IF upper(Column_name) = 'GRD_NOTE_TYPE' OR COLUMN_NAME IS NULL THEN
95: IF new_references.GRD_NOTE_TYPE<> upper(new_references.GRD_NOTE_TYPE) then
96: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
97: App_Exception.Raise_Exception ;
98: END IF;
99:
100: END IF ;
101:

Line 142: App_Exception.Raise_Exception;

138: IF (p_action = 'INSERT') THEN
139: -- Call all the procedures related to Before Insert.
140: IF GET_PK_FOR_VALIDATION(NEW_REFERENCES.grd_note_type) THEN
141: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
142: App_Exception.Raise_Exception;
143: END IF;
144:
145: check_constraints;
146: ELSIF (p_action = 'UPDATE') THEN

Line 156: App_Exception.Raise_Exception;

152: Check_Child_Existance;
153: ELSIF (p_action = 'VALIDATE_INSERT') THEN
154: IF GET_PK_FOR_VALIDATION(NEW_REFERENCES.grd_note_type) THEN
155: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
156: App_Exception.Raise_Exception;
157: END IF;
158:
159: check_constraints;
160: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 201: app_exception.raise_exception;

197: X_LAST_UPDATE_LOGIN := -1;
198: end if;
199: else
200: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
201: app_exception.raise_exception;
202: end if;
203:
204: Before_DML (
205: p_action => 'INSERT',

Line 261: app_exception.raise_exception;

257: fetch c1 into tlinfo;
258: if (c1%notfound) then
259: close c1;
260: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
261: app_exception.raise_exception;
262: return;
263: end if;
264: close c1;
265:

Line 271: app_exception.raise_exception;

267: ) then
268: null;
269: else
270: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
271: app_exception.raise_exception;
272: end if;
273: return;
274: end LOCK_ROW;
275:

Line 301: app_exception.raise_exception;

297: X_LAST_UPDATE_LOGIN := -1;
298: end if;
299: else
300: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
301: app_exception.raise_exception;
302: end if;
303:
304: Before_DML (
305: p_action => 'UPDATE',