DBA Data[Home] [Help]

APPS.IGS_AZ_ADVISORS_PKG dependencies on FND_MESSAGE

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

47: OPEN cur_old_ref_values;
48: FETCH cur_old_ref_values INTO old_references;
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;

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

97: new_references.advisor_person_id,
98: new_references.group_name
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:

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

123: NULL;
124: ELSIF NOT igs_az_groups_pkg.get_pk_for_validation (
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:

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

246: OPEN cur_rowid;
247: FETCH cur_rowid INTO lv_rowid;
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;

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

311: IF ( get_pk_for_validation(
312: new_references.group_advisor_id
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;

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

330: IF ( get_pk_for_validation (
331: new_references.group_advisor_id
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;

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

391: IF (x_last_update_login IS NULL) THEN
392: x_last_update_login := -1;
393: END IF;
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;

Line 396: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISORS_PKG.INSERT_ROW');

392: x_last_update_login := -1;
393: END IF;
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:

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

474: p_data => X_MSG_DATA);
475: RETURN;
476: WHEN OTHERS THEN
477: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
478: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
479: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
480: FND_MSG_PUB.ADD;
481: FND_MSG_PUB.Count_And_Get(
482: p_encoded => FND_API.G_FALSE,

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

475: RETURN;
476: WHEN OTHERS THEN
477: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
478: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
479: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
480: FND_MSG_PUB.ADD;
481: FND_MSG_PUB.Count_And_Get(
482: p_encoded => FND_API.G_FALSE,
483: p_count => x_MSG_COUNT,

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

532: FND_MSG_PUB.initialize;
533: OPEN c1;
534: FETCH c1 INTO tlinfo;
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;

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

552: AND ((tlinfo.accept_delete_flag = x_accept_delete_flag) OR ((tlinfo.accept_delete_flag IS NULL) AND (x_accept_delete_flag IS NULL)))
553: ) THEN
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:

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

583: p_data => X_MSG_DATA);
584: RETURN;
585: WHEN OTHERS THEN
586: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
587: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
588: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
589: FND_MSG_PUB.ADD;
590: FND_MSG_PUB.Count_And_Get(
591: p_encoded => FND_API.G_FALSE,

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

584: RETURN;
585: WHEN OTHERS THEN
586: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
587: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
588: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
589: FND_MSG_PUB.ADD;
590: FND_MSG_PUB.Count_And_Get(
591: p_encoded => FND_API.G_FALSE,
592: p_count => x_MSG_COUNT,

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

641: IF (x_last_update_login IS NULL) THEN
642: x_last_update_login := -1;
643: END IF;
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;

Line 646: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISORS_PKG.UPDATE_ROW');

642: x_last_update_login := -1;
643: END IF;
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:

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

722: p_data => X_MSG_DATA);
723: RETURN;
724: WHEN OTHERS THEN
725: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
726: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
727: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
728: FND_MSG_PUB.ADD;
729: FND_MSG_PUB.Count_And_Get(
730: p_encoded => FND_API.G_FALSE,

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

723: RETURN;
724: WHEN OTHERS THEN
725: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
726: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
727: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
728: FND_MSG_PUB.ADD;
729: FND_MSG_PUB.Count_And_Get(
730: p_encoded => FND_API.G_FALSE,
731: p_count => x_MSG_COUNT,

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

866: p_data => X_MSG_DATA);
867: RETURN;
868: WHEN OTHERS THEN
869: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
871: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
872: FND_MSG_PUB.ADD;
873: FND_MSG_PUB.Count_And_Get(
874: p_encoded => FND_API.G_FALSE,

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

867: RETURN;
868: WHEN OTHERS THEN
869: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
871: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
872: FND_MSG_PUB.ADD;
873: FND_MSG_PUB.Count_And_Get(
874: p_encoded => FND_API.G_FALSE,
875: p_count => x_MSG_COUNT,