APPS.IGS_AS_SUAAI_OUHIST_PKG dependencies on APP_EXCEPTION

Line 71: app_exception.raise_exception;

67: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
68: CLOSE cur_old_ref_values;
69: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
70: igs_ge_msg_stack.add;
71: app_exception.raise_exception;
72: RETURN;
73: END IF;
74: CLOSE cur_old_ref_values;
75:

Line 158: app_exception.raise_exception;

154: ) THEN
155:
156: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
157: igs_ge_msg_stack.add;
158: app_exception.raise_exception;
159: END IF;
160:
161: IF (old_references.sua_ass_item_group_id = new_references.sua_ass_item_group_id
162: OR new_references.sua_ass_item_group_id IS NULL) THEN

Line 168: app_exception.raise_exception;

164: ELSIF NOT igs_as_sua_ai_group_pkg.get_pk_For_validation (
165: x_sua_ass_item_group_id => new_references.sua_ass_item_group_id) THEN
166: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
167: igs_ge_msg_stack.add;
168: app_exception.raise_exception;
169: END IF;
170:
171: END check_parent_existance;
172:

Line 256: app_exception.raise_exception;

252: IF (cur_rowid%FOUND) THEN
253: CLOSE cur_rowid;
254: fnd_message.set_name ('IGS', 'IGS_AS_ASHO_SUAAI_FK');
255: igs_ge_msg_stack.add;
256: app_exception.raise_exception;
257: RETURN;
258: END IF;
259: CLOSE cur_rowid;
260:

Line 290: app_exception.raise_exception;

286: IF (cur_rowid%FOUND) THEN
287: CLOSE cur_rowid;
288: fnd_message.set_name ('IGS', 'IGS_AS_ASHO_SUAAIG_FK');
289: igs_ge_msg_stack.add;
290: app_exception.raise_exception;
291: RETURN;
292: END IF;
293: CLOSE cur_rowid;
294:

Line 392: app_exception.raise_exception;

388: )
389: ) THEN
390: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
391: igs_ge_msg_stack.add;
392: app_exception.raise_exception;
393: END IF;
394: check_parent_existance;
395: ELSIF (p_action = 'UPDATE') THEN
396: -- Call all the procedures related to Before Update.

Line 411: app_exception.raise_exception;

407: )
408: ) THEN
409: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
410: igs_ge_msg_stack.add;
411: app_exception.raise_exception;
412: END IF;
413: END IF;
414:
415: END before_dml;

Line 489: app_exception.raise_exception;

485: END IF;
486: ELSE
487: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
488: igs_ge_msg_stack.add;
489: app_exception.raise_exception;
490: END IF;
491:
492: before_dml(
493: p_action => 'INSERT',

Line 672: app_exception.raise_exception;

668: IF (c1%notfound) THEN
669: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
670: igs_ge_msg_stack.add;
671: CLOSE c1;
672: app_exception.raise_exception;
673: RETURN;
674: END IF;
675: CLOSE c1;
676:

Line 700: app_exception.raise_exception;

696: NULL;
697: ELSE
698: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
699: igs_ge_msg_stack.add;
700: app_exception.raise_exception;
701: END IF;
702:
703: RETURN;
704:

Line 770: app_exception.raise_exception;

766: END IF;
767: ELSE
768: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
769: igs_ge_msg_stack.add;
770: app_exception.raise_exception;
771: END IF;
772:
773: before_dml(
774: p_action => 'UPDATE',