APPS.IGS_HE_EX_RN_DAT_LN_PKG dependencies on APP_EXCEPTION

Line 57: app_exception.raise_exception;

53: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
54: CLOSE cur_old_ref_values;
55: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
56: igs_ge_msg_stack.add;
57: app_exception.raise_exception;
58: RETURN;
59: END IF;
60: CLOSE cur_old_ref_values;
61:

Line 112: app_exception.raise_exception;

108: new_references.extract_run_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 202: app_exception.raise_exception;

198: IF (cur_rowid%FOUND) THEN
199: CLOSE cur_rowid;
200: fnd_message.set_name ('IGS', 'IGS_HE_HEERDALN_HEERDTL_FK');
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203: RETURN;
204: END IF;
205: CLOSE cur_rowid;
206:

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 294: app_exception.raise_exception;

290: )
291: ) THEN
292: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: END IF;
296: ELSIF (p_action = 'VALIDATE_DELETE') THEN
297: check_child_existance;
298: END IF;

Line 357: app_exception.raise_exception;

353: END IF;
354: ELSE
355: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: END IF;
359:
360: /* this is added by rgopalan as this key is kept as unique key and not primary key */
361:

Line 490: app_exception.raise_exception;

486: IF (c1%notfound) THEN
487: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
488: igs_ge_msg_stack.add;
489: CLOSE c1;
490: app_exception.raise_exception;
491: RETURN;
492: END IF;
493: CLOSE c1;
494:

Line 512: app_exception.raise_exception;

508: NULL;
509: ELSE
510: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
511: igs_ge_msg_stack.add;
512: app_exception.raise_exception;
513: END IF;
514:
515: RETURN;
516:

Line 568: app_exception.raise_exception;

564: END IF;
565: ELSE
566: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
567: igs_ge_msg_stack.add;
568: app_exception.raise_exception;
569: END IF;
570:
571: before_dml(
572: p_action => 'UPDATE',