APPS.IGS_UC_COM_SCH_PKG dependencies on APP_EXCEPTION

Line 63: app_exception.raise_exception;

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

Line 175: app_exception.raise_exception;

171: new_references.country
172: ) THEN
173: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
174: igs_ge_msg_stack.add;
175: app_exception.raise_exception;
176: END IF;
177:
178: END check_parent_existance;
179:

Line 208: app_exception.raise_exception;

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

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: before_dml(
379: p_action => 'INSERT',

Line 534: app_exception.raise_exception;

530: IF (c1%notfound) THEN
531: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
532: igs_ge_msg_stack.add;
533: CLOSE c1;
534: app_exception.raise_exception;
535: RETURN;
536: END IF;
537: CLOSE c1;
538: -- smaddali corrected typo in comparision of stats_date , it was comparing with ucas_status instead of stats_date, bug#3091973

Line 562: app_exception.raise_exception;

558: NULL;
559: ELSE
560: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
561: igs_ge_msg_stack.add;
562: app_exception.raise_exception;
563: END IF;
564:
565: RETURN;
566:

Line 623: app_exception.raise_exception;

619: END IF;
620: ELSE
621: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
622: igs_ge_msg_stack.add;
623: app_exception.raise_exception;
624: END IF;
625:
626: before_dml(
627: p_action => 'UPDATE',