APPS.IGS_UC_APP_CLEARING_PKG dependencies on APP_EXCEPTION

Line 62: app_exception.raise_exception;

58: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
59: CLOSE cur_old_ref_values;
60: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
61: igs_ge_msg_stack.add;
62: app_exception.raise_exception;
63: RETURN;
64: END IF;
65: CLOSE cur_old_ref_values;
66:

Line 121: app_exception.raise_exception;

117: new_references.app_id
118: ) THEN
119: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
120: igs_ge_msg_stack.add;
121: app_exception.raise_exception;
122: END IF;
123:
124: END check_parent_existance;
125:

Line 209: app_exception.raise_exception;

205: IF (cur_rowid%FOUND) THEN
206: CLOSE cur_rowid;
207: fnd_message.set_name ('IGS', 'IGS_UC_UCAPCL_UCAP_FK');
208: igs_ge_msg_stack.add;
209: app_exception.raise_exception;
210: RETURN;
211: END IF;
212: CLOSE cur_rowid;
213:

Line 291: app_exception.raise_exception;

287: )
288: ) THEN
289: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
290: igs_ge_msg_stack.add;
291: app_exception.raise_exception;
292: END IF;
293: check_parent_existance;
294: ELSIF (p_action = 'UPDATE') THEN
295: -- Call all the procedures related to Before Update.

Line 308: app_exception.raise_exception;

304: )
305: ) THEN
306: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309: END IF;
310: ELSIF (p_action = 'VALIDATE_DELETE') THEN
311: check_child_existance;
312: END IF;

Line 375: app_exception.raise_exception;

371: END IF;
372: ELSE
373: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
374: igs_ge_msg_stack.add;
375: app_exception.raise_exception;
376: END IF;
377:
378: SELECT igs_uc_app_clearing_s.NEXTVAL
379: INTO x_clearing_app_id

Line 530: app_exception.raise_exception;

526: IF (c1%notfound) THEN
527: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
528: igs_ge_msg_stack.add;
529: CLOSE c1;
530: app_exception.raise_exception;
531: RETURN;
532: END IF;
533: CLOSE c1;
534:

Line 557: app_exception.raise_exception;

553: NULL;
554: ELSE
555: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
556: igs_ge_msg_stack.add;
557: app_exception.raise_exception;
558: END IF;
559:
560: RETURN;
561:

Line 618: app_exception.raise_exception;

614: END IF;
615: ELSE
616: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
617: igs_ge_msg_stack.add;
618: app_exception.raise_exception;
619: END IF;
620:
621: before_dml(
622: p_action => 'UPDATE',