APPS.IGS_FI_P_SA_NOTES_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

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

Line 98: app_exception.raise_exception;

94: )
95: ) THEN
96: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100:
101: END check_uniqueness;
102:

Line 138: app_exception.raise_exception;

134: ELSE
135: CLOSE cur_rowid;
136: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: END IF;
140: END IF;
141:
142: IF (((old_references.reference_number = new_references.reference_number)) OR

Line 150: app_exception.raise_exception;

146: new_references.reference_number
147: ) THEN
148: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
149: igs_ge_msg_stack.add;
150: app_exception.raise_exception;
151: END IF;
152:
153: END check_parent_existance;
154:

Line 260: app_exception.raise_exception;

256: IF (cur_rowid%FOUND) THEN
257: CLOSE cur_rowid;
258: fnd_message.set_name ('IGS', 'IGS_FI_NOTE_GN_FK');
259: igs_ge_msg_stack.add;
260: app_exception.raise_exception;
261: RETURN;
262: END IF;
263: CLOSE cur_rowid;
264:

Line 317: app_exception.raise_exception;

313: )
314: ) THEN
315: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
316: igs_ge_msg_stack.add;
317: app_exception.raise_exception;
318: END IF;
319: check_uniqueness;
320: check_parent_existance;
321: ELSIF (p_action = 'UPDATE') THEN

Line 333: app_exception.raise_exception;

329: )
330: ) THEN
331: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
332: igs_ge_msg_stack.add;
333: app_exception.raise_exception;
334: END IF;
335: check_uniqueness;
336: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
337: check_uniqueness;

Line 389: app_exception.raise_exception;

385: END IF;
386: ELSE
387: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
388: igs_ge_msg_stack.add;
389: app_exception.raise_exception;
390: END IF;
391:
392: SELECT igs_fi_p_sa_notes_s.NEXTVAL
393: INTO x_party_sa_notes_id

Line 479: app_exception.raise_exception;

475: IF (c1%notfound) THEN
476: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
477: igs_ge_msg_stack.add;
478: CLOSE c1;
479: app_exception.raise_exception;
480: RETURN;
481: END IF;
482: CLOSE c1;
483:

Line 493: app_exception.raise_exception;

489: NULL;
490: ELSE
491: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
492: igs_ge_msg_stack.add;
493: app_exception.raise_exception;
494: END IF;
495:
496: RETURN;
497:

Line 542: app_exception.raise_exception;

538: END IF;
539: ELSE
540: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
541: igs_ge_msg_stack.add;
542: app_exception.raise_exception;
543: END IF;
544:
545: before_dml(
546: p_action => 'UPDATE',