APPS.IGF_AP_PERS_NOTE_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;
52: CLOSE cur_old_ref_values;
53:

Line 100: App_Exception.Raise_Exception;

96: new_references.pe_note_type
97: ) THEN
98: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101: END IF;
102: END IF;
103:
104: IF (((old_references.base_id = new_references.base_id)) OR

Line 112: app_exception.raise_exception;

108: new_references.base_id
109: ) THEN
110: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
111: igs_ge_msg_stack.add;
112: app_exception.raise_exception;
113: END IF;
114:
115: END check_parent_existance;
116:

Line 182: app_exception.raise_exception;

178: IF (cur_rowid%FOUND) THEN
179: CLOSE cur_rowid;
180: fnd_message.set_name ('IGF', 'IGF_AP_APN_APT_FK');
181: igs_ge_msg_stack.add;
182: app_exception.raise_exception;
183: RETURN;
184: END IF;
185: CLOSE cur_rowid;
186:

Line 219: app_exception.raise_exception;

215: IF (cur_rowid%FOUND) THEN
216: CLOSE cur_rowid;
217: fnd_message.set_name ('IGF', 'IGF_AP_APN_FABASE_FK');
218: igs_ge_msg_stack.add;
219: app_exception.raise_exception;
220: RETURN;
221: END IF;
222: CLOSE cur_rowid;
223:

Line 276: app_exception.raise_exception;

272: )
273: ) THEN
274: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
275: igs_ge_msg_stack.add;
276: app_exception.raise_exception;
277: END IF;
278: check_parent_existance;
279: ELSIF (p_action = 'UPDATE') THEN
280: -- Call all the procedures related to Before Update.

Line 290: app_exception.raise_exception;

286: )
287: ) THEN
288: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
289: igs_ge_msg_stack.add;
290: app_exception.raise_exception;
291: END IF;
292: END IF;
293:
294: END before_dml;

Line 342: app_exception.raise_exception;

338: END IF;
339: ELSE
340: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
341: igs_ge_msg_stack.add;
342: app_exception.raise_exception;
343: END IF;
344:
345:
346: before_dml(

Line 433: app_exception.raise_exception;

429: IF (c1%notfound) THEN
430: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
431: igs_ge_msg_stack.add;
432: CLOSE c1;
433: app_exception.raise_exception;
434: RETURN;
435: END IF;
436: CLOSE c1;
437:

Line 448: app_exception.raise_exception;

444: NULL;
445: ELSE
446: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
447: igs_ge_msg_stack.add;
448: app_exception.raise_exception;
449: END IF;
450:
451: RETURN;
452:

Line 496: app_exception.raise_exception;

492: END IF;
493: ELSE
494: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
495: igs_ge_msg_stack.add;
496: app_exception.raise_exception;
497: END IF;
498:
499: before_dml(
500: p_action => 'UPDATE',