APPS.IGS_AS_ANON_ID_US_PKG dependencies on APP_EXCEPTION

Line 54: app_exception.raise_exception;

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

Line 144: app_exception.raise_exception;

140: new_references.load_ci_sequence_number
141: )) THEN
142: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
143: igs_ge_msg_stack.add;
144: app_exception.raise_exception;
145: END IF;
146:
147: END check_uniqueness;
148:

Line 174: app_exception.raise_exception;

170: new_references.load_ci_sequence_number
171: ) THEN
172: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175: END IF;
176:
177: IF (((old_references.person_id = new_references.person_id) AND
178: (old_references.course_cd = new_references.course_cd) AND

Line 191: app_exception.raise_exception;

187: new_references.uoo_id
188: ) THEN
189: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: END IF;
193:
194: IF (((old_references.person_id = new_references.person_id) AND
195: (old_references.course_cd = new_references.course_cd)) OR

Line 205: app_exception.raise_exception;

201: new_references.course_cd
202: ) THEN
203: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
204: igs_ge_msg_stack.add;
205: app_exception.raise_exception;
206: END IF;
207:
208: IF (((old_references.uoo_id = new_references.uoo_id)) OR
209: ((new_references.uoo_id IS NULL))) THEN

Line 216: app_exception.raise_exception;

212: new_references.uoo_id
213: ) THEN
214: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
215: igs_ge_msg_stack.add;
216: app_exception.raise_exception;
217: END IF;
218:
219: END check_parent_existance;
220:

Line 291: app_exception.raise_exception;

287: IF (cur_rowid%FOUND) THEN
288: CLOSE cur_rowid;
289: fnd_message.set_name ('IGS', 'IGS_AS_ASEC_CI_FK');
290: igs_ge_msg_stack.add;
291: app_exception.raise_exception;
292: RETURN;
293: END IF;
294: CLOSE cur_rowid;
295:

Line 331: app_exception.raise_exception;

327: IF (cur_rowid%FOUND) THEN
328: CLOSE cur_rowid;
329: fnd_message.set_name ('IGS', 'IGS_AS_ASEC_SUA_FK');
330: igs_ge_msg_stack.add;
331: app_exception.raise_exception;
332: RETURN;
333: END IF;
334: CLOSE cur_rowid;
335:

Line 368: app_exception.raise_exception;

364: IF (cur_rowid%FOUND) THEN
365: CLOSE cur_rowid;
366: fnd_message.set_name ('IGS', 'IGS_AS_ASEC_SCA_FK');
367: igs_ge_msg_stack.add;
368: app_exception.raise_exception;
369: RETURN;
370: END IF;
371: CLOSE cur_rowid;
372:

Line 403: app_exception.raise_exception;

399: IF (cur_rowid%FOUND) THEN
400: CLOSE cur_rowid;
401: fnd_message.set_name ('IGS', 'IGS_AS_ASEC_UOO_FK');
402: igs_ge_msg_stack.add;
403: app_exception.raise_exception;
404: RETURN;
405: END IF;
406: CLOSE cur_rowid;
407:

Line 471: app_exception.raise_exception;

467: new_references.uoo_id
468: )) THEN
469: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
470: igs_ge_msg_stack.add;
471: app_exception.raise_exception;
472: END IF;
473: check_uniqueness;
474: check_parent_existance;
475: ELSIF (p_action = 'UPDATE') THEN

Line 488: app_exception.raise_exception;

484: new_references.uoo_id
485: ) ) THEN
486: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
487: igs_ge_msg_stack.add;
488: app_exception.raise_exception;
489: END IF;
490: check_uniqueness;
491: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
492: check_uniqueness;

Line 567: app_exception.raise_exception;

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

Line 686: app_exception.raise_exception;

682: IF (c1%notfound) THEN
683: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
684: igs_ge_msg_stack.add;
685: CLOSE c1;
686: app_exception.raise_exception;
687: RETURN;
688: END IF;
689: CLOSE c1;
690:

Line 702: app_exception.raise_exception;

698: NULL;
699: ELSE
700: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
701: igs_ge_msg_stack.add;
702: app_exception.raise_exception;
703: END IF;
704:
705: RETURN;
706:

Line 759: app_exception.raise_exception;

755: END IF;
756: ELSE
757: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
758: igs_ge_msg_stack.add;
759: app_exception.raise_exception;
760: END IF;
761:
762: before_dml(
763: p_action => 'UPDATE',