APPS.IGS_AZ_ADVISORS_PKG dependencies on APP_EXCEPTION

Line 53: app_exception.raise_exception;

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

Line 103: app_exception.raise_exception;

99: )
100: ) THEN
101: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
102: igs_ge_msg_stack.add;
103: app_exception.raise_exception;
104: END IF;
105:
106: END check_uniqueness;
107:

Line 129: app_exception.raise_exception;

125: new_references.group_name
126: ) THEN
127: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
128: igs_ge_msg_stack.add;
129: app_exception.raise_exception;
130: END IF;
131:
132: END check_parent_existance;
133:

Line 252: app_exception.raise_exception;

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

Line 317: app_exception.raise_exception;

313: )
314: ) THEN
315: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
316: igs_ge_msg_stack.add;
317: app_exception.raise_exception;
318: END IF;
319: check_uniqueness;
320: check_parent_existance;
321: ELSIF (p_action = 'UPDATE') THEN

Line 336: app_exception.raise_exception;

332: )
333: ) THEN
334: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
335: igs_ge_msg_stack.add;
336: app_exception.raise_exception;
337: END IF;
338: check_uniqueness;
339: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
340: check_uniqueness;

Line 398: app_exception.raise_exception;

394: ELSE
395: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
396: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISORS_PKG.INSERT_ROW');
397: igs_ge_msg_stack.add;
398: app_exception.raise_exception;
399: END IF;
400:
401: x_group_advisor_id := NULL;
402:

Line 539: app_exception.raise_exception;

535: IF (c1%notfound) THEN
536: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
537: igs_ge_msg_stack.add;
538: CLOSE c1;
539: app_exception.raise_exception;
540: RETURN;
541: END IF;
542: CLOSE c1;
543:

Line 558: app_exception.raise_exception;

554: NULL;
555: ELSE
556: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
557: igs_ge_msg_stack.add;
558: app_exception.raise_exception;
559: END IF;
560:
561: -- Initialize API return status to success.
562: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 648: app_exception.raise_exception;

644: ELSE
645: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
646: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISORS_PKG.UPDATE_ROW');
647: igs_ge_msg_stack.add;
648: app_exception.raise_exception;
649: END IF;
650:
651: before_dml(
652: p_action => 'UPDATE',