DBA Data[Home] [Help]

APPS.IGS_AZ_ADVISING_RELS_PKG dependencies on FND_MESSAGE

Line 48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

44: OPEN cur_old_ref_values;
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;

Line 96: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

92: new_references.group_advisor_id,
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:

Line 122: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

118: NULL;
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:

Line 133: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

129: NULL;
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:

Line 144: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

140: NULL;
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:

Line 251: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');

247: OPEN cur_rowid;
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;

Line 286: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');

282: OPEN cur_rowid;
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;

Line 321: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');

317: OPEN cur_rowid;
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;

Line 380: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

376: IF ( get_pk_for_validation(
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;

Line 396: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

392: IF ( get_pk_for_validation (
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;

Line 451: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

447: IF (x_last_update_login IS NULL) THEN
448: x_last_update_login := -1;
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;

Line 452: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISING_RELS_PKG.INSERT_ROW');

448: x_last_update_login := -1;
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:

Line 523: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

519: p_data => X_MSG_DATA);
520: RETURN;
521: WHEN OTHERS THEN
522: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
523: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
524: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
525: FND_MSG_PUB.ADD;
526: FND_MSG_PUB.Count_And_Get(
527: p_encoded => FND_API.G_FALSE,

Line 524: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);

520: RETURN;
521: WHEN OTHERS THEN
522: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
523: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
524: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
525: FND_MSG_PUB.ADD;
526: FND_MSG_PUB.Count_And_Get(
527: p_encoded => FND_API.G_FALSE,
528: p_count => x_MSG_COUNT,

Line 574: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

570: FND_MSG_PUB.initialize;
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;

Line 591: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

587: AND ((TRUNC(tlinfo.END_DATE) = TRUNC(x_END_DATE)) OR ((tlinfo.END_DATE IS NULL) AND (X_END_DATE IS NULL)))
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.

Line 621: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

617: p_data => X_MSG_DATA);
618: RETURN;
619: WHEN OTHERS THEN
620: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
621: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
622: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
623: FND_MSG_PUB.ADD;
624: FND_MSG_PUB.Count_And_Get(
625: p_encoded => FND_API.G_FALSE,

Line 622: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);

618: RETURN;
619: WHEN OTHERS THEN
620: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
621: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
622: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
623: FND_MSG_PUB.ADD;
624: FND_MSG_PUB.Count_And_Get(
625: p_encoded => FND_API.G_FALSE,
626: p_count => x_MSG_COUNT,

Line 676: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

672: IF (x_last_update_login IS NULL) THEN
673: x_last_update_login := -1;
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;

Line 677: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISING_RELS_PKG.UPDATE_ROW');

673: x_last_update_login := -1;
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:

Line 751: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

747: p_data => X_MSG_DATA);
748: RETURN;
749: WHEN OTHERS THEN
750: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
751: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
752: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
753: FND_MSG_PUB.ADD;
754: FND_MSG_PUB.Count_And_Get(
755: p_encoded => FND_API.G_FALSE,

Line 752: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);

748: RETURN;
749: WHEN OTHERS THEN
750: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
751: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
752: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
753: FND_MSG_PUB.ADD;
754: FND_MSG_PUB.Count_And_Get(
755: p_encoded => FND_API.G_FALSE,
756: p_count => x_MSG_COUNT,

Line 885: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

881: p_data => X_MSG_DATA);
882: RETURN;
883: WHEN OTHERS THEN
884: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
885: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
886: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
887: FND_MSG_PUB.ADD;
888: FND_MSG_PUB.Count_And_Get(
889: p_encoded => FND_API.G_FALSE,

Line 886: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);

882: RETURN;
883: WHEN OTHERS THEN
884: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
885: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
886: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
887: FND_MSG_PUB.ADD;
888: FND_MSG_PUB.Count_And_Get(
889: p_encoded => FND_API.G_FALSE,
890: p_count => x_MSG_COUNT,