APPS.IGS_UC_COM_SCHSITES_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 111: app_exception.raise_exception;

107: new_references.school
108: ) THEN
109: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: END IF;
113:
114: END check_parent_existance;
115:

Line 200: app_exception.raise_exception;

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

Line 273: app_exception.raise_exception;

269: )
270: ) THEN
271: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
272: igs_ge_msg_stack.add;
273: app_exception.raise_exception;
274: END IF;
275: check_parent_existance;
276: ELSIF (p_action = 'UPDATE') THEN
277: -- Call all the procedures related to Before Update.

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: ELSIF (p_action = 'VALIDATE_DELETE') THEN
294: check_child_existance;
295: END IF;

Line 354: app_exception.raise_exception;

350: END IF;
351: ELSE
352: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
353: igs_ge_msg_stack.add;
354: app_exception.raise_exception;
355: END IF;
356:
357: before_dml(
358: p_action => 'INSERT',

Line 479: app_exception.raise_exception;

475: IF (c1%notfound) THEN
476: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
477: igs_ge_msg_stack.add;
478: CLOSE c1;
479: app_exception.raise_exception;
480: RETURN;
481: END IF;
482: CLOSE c1;
483:

Line 500: app_exception.raise_exception;

496: NULL;
497: ELSE
498: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
499: igs_ge_msg_stack.add;
500: app_exception.raise_exception;
501: END IF;
502:
503: RETURN;
504:

Line 556: app_exception.raise_exception;

552: END IF;
553: ELSE
554: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
555: igs_ge_msg_stack.add;
556: app_exception.raise_exception;
557: END IF;
558:
559: before_dml(
560: p_action => 'UPDATE',