APPS.IGS_UC_APP_CLR_RND_PKG dependencies on APP_EXCEPTION

Line 64: app_exception.raise_exception;

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

Line 158: app_exception.raise_exception;

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

Line 172: app_exception.raise_exception;

168: new_references.clearing_app_id
169: ) THEN
170: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
171: igs_ge_msg_stack.add;
172: app_exception.raise_exception;
173: END IF;
174:
175: END check_parent_existance;
176:

Line 247: app_exception.raise_exception;

243: IF (cur_rowid%FOUND) THEN
244: CLOSE cur_rowid;
245: fnd_message.set_name ('IGS', 'IGS_UC_UCAPCR_UCCSDE_FK');
246: igs_ge_msg_stack.add;
247: app_exception.raise_exception;
248: RETURN;
249: END IF;
250: CLOSE cur_rowid;
251:

Line 284: app_exception.raise_exception;

280: IF (cur_rowid%FOUND) THEN
281: CLOSE cur_rowid;
282: fnd_message.set_name ('IGS', 'IGS_UC_UCAPCR_UCAPCL_FK');
283: igs_ge_msg_stack.add;
284: app_exception.raise_exception;
285: RETURN;
286: END IF;
287: CLOSE cur_rowid;
288:

Line 368: app_exception.raise_exception;

364: )
365: ) THEN
366: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
367: igs_ge_msg_stack.add;
368: app_exception.raise_exception;
369: END IF;
370: check_parent_existance;
371: ELSIF (p_action = 'UPDATE') THEN
372: -- Call all the procedures related to Before Update.

Line 382: app_exception.raise_exception;

378: )
379: ) THEN
380: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
381: igs_ge_msg_stack.add;
382: app_exception.raise_exception;
383: END IF;
384: END IF;
385:
386: END before_dml;

Line 448: app_exception.raise_exception;

444: END IF;
445: ELSE
446: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
447: igs_ge_msg_stack.add;
448: app_exception.raise_exception;
449: END IF;
450:
451: SELECT igs_uc_app_clr_rnd_s.NEXTVAL
452: INTO x_app_clear_round_id

Line 608: app_exception.raise_exception;

604: IF (c1%notfound) THEN
605: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
606: igs_ge_msg_stack.add;
607: CLOSE c1;
608: app_exception.raise_exception;
609: RETURN;
610: END IF;
611: CLOSE c1;
612:

Line 636: app_exception.raise_exception;

632: NULL;
633: ELSE
634: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
635: igs_ge_msg_stack.add;
636: app_exception.raise_exception;
637: END IF;
638:
639: RETURN;
640:

Line 698: app_exception.raise_exception;

694: END IF;
695: ELSE
696: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
697: igs_ge_msg_stack.add;
698: app_exception.raise_exception;
699: END IF;
700:
701: before_dml(
702: p_action => 'UPDATE',