APPS.IGS_AZ_ADVISING_RELS_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

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

Line 98: app_exception.raise_exception;

94: )
95: ) THEN
96: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100:
101: END check_uniqueness;
102:

Line 124: app_exception.raise_exception;

120: new_references.group_name
121: ) THEN
122: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
123: igs_ge_msg_stack.add;
124: app_exception.raise_exception;
125: END IF;
126:
127: IF (((old_references.group_student_id = new_references.group_student_id)) OR
128: ((new_references.group_student_id IS NULL))) THEN

Line 135: app_exception.raise_exception;

131: new_references.group_student_id
132: ) THEN
133: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
134: igs_ge_msg_stack.add;
135: app_exception.raise_exception;
136: END IF;
137:
138: IF (((old_references.group_advisor_id = new_references.group_advisor_id)) OR
139: ((new_references.group_advisor_id IS NULL))) THEN

Line 146: app_exception.raise_exception;

142: new_references.group_advisor_id
143: ) THEN
144: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
145: igs_ge_msg_stack.add;
146: app_exception.raise_exception;
147: END IF;
148:
149: END check_parent_existance;
150:

Line 253: app_exception.raise_exception;

249: IF (cur_rowid%FOUND) THEN
250: CLOSE cur_rowid;
251: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
252: igs_ge_msg_stack.add;
253: app_exception.raise_exception;
254: RETURN;
255: END IF;
256: CLOSE cur_rowid;
257:

Line 288: app_exception.raise_exception;

284: IF (cur_rowid%FOUND) THEN
285: CLOSE cur_rowid;
286: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
287: igs_ge_msg_stack.add;
288: app_exception.raise_exception;
289: RETURN;
290: END IF;
291: CLOSE cur_rowid;
292:

Line 323: app_exception.raise_exception;

319: IF (cur_rowid%FOUND) THEN
320: CLOSE cur_rowid;
321: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: RETURN;
325: END IF;
326: CLOSE cur_rowid;
327:

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: check_uniqueness;
385: check_parent_existance;
386: ELSIF (p_action = 'UPDATE') THEN

Line 398: app_exception.raise_exception;

394: )
395: ) THEN
396: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
397: igs_ge_msg_stack.add;
398: app_exception.raise_exception;
399: END IF;
400: check_uniqueness;
401: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
402: check_uniqueness;

Line 454: app_exception.raise_exception;

450: ELSE
451: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
452: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISING_RELS_PKG.INSERT_ROW');
453: igs_ge_msg_stack.add;
454: app_exception.raise_exception;
455: END IF;
456:
457: x_group_advising_rel_id := NULL;
458:

Line 577: app_exception.raise_exception;

573: IF (c1%notfound) THEN
574: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
575: igs_ge_msg_stack.add;
576: CLOSE c1;
577: app_exception.raise_exception;
578: RETURN;
579: END IF;
580: CLOSE c1;
581:

Line 593: app_exception.raise_exception;

589: NULL;
590: ELSE
591: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
592: igs_ge_msg_stack.add;
593: app_exception.raise_exception;
594: END IF;
595: -- Initialize API return status to success.
596: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
597: -- Standard call to get message count and if count is 1, get message

Line 679: app_exception.raise_exception;

675: ELSE
676: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
677: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISING_RELS_PKG.UPDATE_ROW');
678: igs_ge_msg_stack.add;
679: app_exception.raise_exception;
680: END IF;
681:
682: -- x_group_advising_rel_id := NULL;
683: