APPS.IGS_AZ_ADVISING_RELS_PKG dependencies on IGS_GE_MSG_STACK

Line 49: igs_ge_msg_stack.add;

45: FETCH cur_old_ref_values INTO old_references;
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;

Line 97: igs_ge_msg_stack.add;

93: new_references.group_student_id
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;

Line 123: igs_ge_msg_stack.add;

119: ELSIF NOT IGS_AZ_GROUPS_pkg.get_pk_for_validation (
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

Line 134: igs_ge_msg_stack.add;

130: ELSIF NOT IGS_AZ_STUDENTS_pkg.get_pk_for_validation (
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

Line 145: igs_ge_msg_stack.add;

141: ELSIF NOT IGS_AZ_ADVISORS_pkg.get_pk_for_validation (
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;

Line 252: igs_ge_msg_stack.add;

248: FETCH cur_rowid INTO lv_rowid;
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;

Line 287: igs_ge_msg_stack.add;

283: FETCH cur_rowid INTO lv_rowid;
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;

Line 322: igs_ge_msg_stack.add;

318: FETCH cur_rowid INTO lv_rowid;
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;

Line 381: igs_ge_msg_stack.add;

377: new_references.group_advising_rel_id
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;

Line 397: igs_ge_msg_stack.add;

393: new_references.group_advising_rel_id
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

Line 453: igs_ge_msg_stack.add;

449: END IF;
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;

Line 575: igs_ge_msg_stack.add;

571: OPEN c1;
572: FETCH c1 INTO tlinfo;
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;

Line 592: igs_ge_msg_stack.add;

588: ) THEN
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;

Line 678: igs_ge_msg_stack.add;

674: END IF;
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;