eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AZ_ADVISING_RELS_PKG dependencies on FND_API

Line 503: p_encoded => FND_API.G_FALSE,

499: ) RETURNING ROWID, group_advising_rel_id INTO x_rowid, x_group_advising_rel_id;
500: -- Standard call to get message count and if count is 1, get message
501: -- info.
502: FND_MSG_PUB.Count_And_Get(
503: p_encoded => FND_API.G_FALSE,
504: p_count => x_MSG_COUNT,
505: p_data => X_MSG_DATA);
506: EXCEPTION
507: WHEN FND_API.G_EXC_ERROR THEN

Line 507: WHEN FND_API.G_EXC_ERROR THEN

503: p_encoded => FND_API.G_FALSE,
504: p_count => x_MSG_COUNT,
505: p_data => X_MSG_DATA);
506: EXCEPTION
507: WHEN FND_API.G_EXC_ERROR THEN
508: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
509: FND_MSG_PUB.Count_And_Get(
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_MSG_COUNT,

Line 508: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

504: p_count => x_MSG_COUNT,
505: p_data => X_MSG_DATA);
506: EXCEPTION
507: WHEN FND_API.G_EXC_ERROR THEN
508: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
509: FND_MSG_PUB.Count_And_Get(
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_MSG_COUNT,
512: p_data => X_MSG_DATA);

Line 510: p_encoded => FND_API.G_FALSE,

506: EXCEPTION
507: WHEN FND_API.G_EXC_ERROR THEN
508: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
509: FND_MSG_PUB.Count_And_Get(
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_MSG_COUNT,
512: p_data => X_MSG_DATA);
513: RETURN;
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

510: p_encoded => FND_API.G_FALSE,
511: p_count => x_MSG_COUNT,
512: p_data => X_MSG_DATA);
513: RETURN;
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
516: FND_MSG_PUB.Count_And_Get(
517: p_encoded => FND_API.G_FALSE,
518: p_count => x_MSG_COUNT,

Line 515: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

511: p_count => x_MSG_COUNT,
512: p_data => X_MSG_DATA);
513: RETURN;
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
516: FND_MSG_PUB.Count_And_Get(
517: p_encoded => FND_API.G_FALSE,
518: p_count => x_MSG_COUNT,
519: p_data => X_MSG_DATA);

Line 517: p_encoded => FND_API.G_FALSE,

513: RETURN;
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
516: FND_MSG_PUB.Count_And_Get(
517: p_encoded => FND_API.G_FALSE,
518: p_count => x_MSG_COUNT,
519: p_data => X_MSG_DATA);
520: RETURN;
521: WHEN OTHERS THEN

Line 522: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

518: p_count => x_MSG_COUNT,
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(

Line 527: p_encoded => FND_API.G_FALSE,

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,
529: p_data => X_MSG_DATA);
530: RETURN;
531:

Line 596: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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
598: -- info.
599: FND_MSG_PUB.Count_And_Get(
600: p_encoded => FND_API.G_FALSE,

Line 600: p_encoded => FND_API.G_FALSE,

596: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
597: -- Standard call to get message count and if count is 1, get message
598: -- info.
599: FND_MSG_PUB.Count_And_Get(
600: p_encoded => FND_API.G_FALSE,
601: p_count => x_MSG_COUNT,
602: p_data => X_MSG_DATA);
603: RETURN;
604: EXCEPTION

Line 605: WHEN FND_API.G_EXC_ERROR THEN

601: p_count => x_MSG_COUNT,
602: p_data => X_MSG_DATA);
603: RETURN;
604: EXCEPTION
605: WHEN FND_API.G_EXC_ERROR THEN
606: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
607: FND_MSG_PUB.Count_And_Get(
608: p_encoded => FND_API.G_FALSE,
609: p_count => x_MSG_COUNT,

Line 606: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

602: p_data => X_MSG_DATA);
603: RETURN;
604: EXCEPTION
605: WHEN FND_API.G_EXC_ERROR THEN
606: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
607: FND_MSG_PUB.Count_And_Get(
608: p_encoded => FND_API.G_FALSE,
609: p_count => x_MSG_COUNT,
610: p_data => X_MSG_DATA);

Line 608: p_encoded => FND_API.G_FALSE,

604: EXCEPTION
605: WHEN FND_API.G_EXC_ERROR THEN
606: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
607: FND_MSG_PUB.Count_And_Get(
608: p_encoded => FND_API.G_FALSE,
609: p_count => x_MSG_COUNT,
610: p_data => X_MSG_DATA);
611: RETURN;
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

608: p_encoded => FND_API.G_FALSE,
609: p_count => x_MSG_COUNT,
610: p_data => X_MSG_DATA);
611: RETURN;
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
614: FND_MSG_PUB.Count_And_Get(
615: p_encoded => FND_API.G_FALSE,
616: p_count => x_MSG_COUNT,

Line 613: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

609: p_count => x_MSG_COUNT,
610: p_data => X_MSG_DATA);
611: RETURN;
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
614: FND_MSG_PUB.Count_And_Get(
615: p_encoded => FND_API.G_FALSE,
616: p_count => x_MSG_COUNT,
617: p_data => X_MSG_DATA);

Line 615: p_encoded => FND_API.G_FALSE,

611: RETURN;
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
614: FND_MSG_PUB.Count_And_Get(
615: p_encoded => FND_API.G_FALSE,
616: p_count => x_MSG_COUNT,
617: p_data => X_MSG_DATA);
618: RETURN;
619: WHEN OTHERS THEN

Line 620: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

616: p_count => x_MSG_COUNT,
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(

Line 625: p_encoded => FND_API.G_FALSE,

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,
627: p_data => X_MSG_DATA);
628: RETURN;
629:

Line 727: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

723: IF (SQL%NOTFOUND) THEN
724: RAISE NO_DATA_FOUND;
725: END IF;
726: -- Initialize API return status to success.
727: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
728: -- Standard call to get message count and if count is 1, get message
729: -- info.
730: FND_MSG_PUB.Count_And_Get(
731: p_encoded => FND_API.G_FALSE,

Line 731: p_encoded => FND_API.G_FALSE,

727: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
728: -- Standard call to get message count and if count is 1, get message
729: -- info.
730: FND_MSG_PUB.Count_And_Get(
731: p_encoded => FND_API.G_FALSE,
732: p_count => x_MSG_COUNT,
733: p_data => X_MSG_DATA);
734: EXCEPTION
735: WHEN FND_API.G_EXC_ERROR THEN

Line 735: WHEN FND_API.G_EXC_ERROR THEN

731: p_encoded => FND_API.G_FALSE,
732: p_count => x_MSG_COUNT,
733: p_data => X_MSG_DATA);
734: EXCEPTION
735: WHEN FND_API.G_EXC_ERROR THEN
736: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
737: FND_MSG_PUB.Count_And_Get(
738: p_encoded => FND_API.G_FALSE,
739: p_count => x_MSG_COUNT,

Line 736: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

732: p_count => x_MSG_COUNT,
733: p_data => X_MSG_DATA);
734: EXCEPTION
735: WHEN FND_API.G_EXC_ERROR THEN
736: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
737: FND_MSG_PUB.Count_And_Get(
738: p_encoded => FND_API.G_FALSE,
739: p_count => x_MSG_COUNT,
740: p_data => X_MSG_DATA);

Line 738: p_encoded => FND_API.G_FALSE,

734: EXCEPTION
735: WHEN FND_API.G_EXC_ERROR THEN
736: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
737: FND_MSG_PUB.Count_And_Get(
738: p_encoded => FND_API.G_FALSE,
739: p_count => x_MSG_COUNT,
740: p_data => X_MSG_DATA);
741: RETURN;
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

738: p_encoded => FND_API.G_FALSE,
739: p_count => x_MSG_COUNT,
740: p_data => X_MSG_DATA);
741: RETURN;
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
744: FND_MSG_PUB.Count_And_Get(
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_MSG_COUNT,

Line 743: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

739: p_count => x_MSG_COUNT,
740: p_data => X_MSG_DATA);
741: RETURN;
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
744: FND_MSG_PUB.Count_And_Get(
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_MSG_COUNT,
747: p_data => X_MSG_DATA);

Line 745: p_encoded => FND_API.G_FALSE,

741: RETURN;
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
744: FND_MSG_PUB.Count_And_Get(
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_MSG_COUNT,
747: p_data => X_MSG_DATA);
748: RETURN;
749: WHEN OTHERS THEN

Line 750: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

746: p_count => x_MSG_COUNT,
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(

Line 755: p_encoded => FND_API.G_FALSE,

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,
757: p_data => X_MSG_DATA);
758: RETURN;
759: END update_row;

Line 861: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

857: IF (SQL%NOTFOUND) THEN
858: RAISE NO_DATA_FOUND;
859: END IF;
860: -- Initialize API return status to success.
861: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
862: -- Standard call to get message count and if count is 1, get message
863: -- info.
864: FND_MSG_PUB.Count_And_Get(
865: p_encoded => FND_API.G_FALSE,

Line 865: p_encoded => FND_API.G_FALSE,

861: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
862: -- Standard call to get message count and if count is 1, get message
863: -- info.
864: FND_MSG_PUB.Count_And_Get(
865: p_encoded => FND_API.G_FALSE,
866: p_count => x_MSG_COUNT,
867: p_data => X_MSG_DATA);
868: EXCEPTION
869: WHEN FND_API.G_EXC_ERROR THEN

Line 869: WHEN FND_API.G_EXC_ERROR THEN

865: p_encoded => FND_API.G_FALSE,
866: p_count => x_MSG_COUNT,
867: p_data => X_MSG_DATA);
868: EXCEPTION
869: WHEN FND_API.G_EXC_ERROR THEN
870: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
871: FND_MSG_PUB.Count_And_Get(
872: p_encoded => FND_API.G_FALSE,
873: p_count => x_MSG_COUNT,

Line 870: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

866: p_count => x_MSG_COUNT,
867: p_data => X_MSG_DATA);
868: EXCEPTION
869: WHEN FND_API.G_EXC_ERROR THEN
870: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
871: FND_MSG_PUB.Count_And_Get(
872: p_encoded => FND_API.G_FALSE,
873: p_count => x_MSG_COUNT,
874: p_data => X_MSG_DATA);

Line 872: p_encoded => FND_API.G_FALSE,

868: EXCEPTION
869: WHEN FND_API.G_EXC_ERROR THEN
870: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
871: FND_MSG_PUB.Count_And_Get(
872: p_encoded => FND_API.G_FALSE,
873: p_count => x_MSG_COUNT,
874: p_data => X_MSG_DATA);
875: RETURN;
876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

872: p_encoded => FND_API.G_FALSE,
873: p_count => x_MSG_COUNT,
874: p_data => X_MSG_DATA);
875: RETURN;
876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
877: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
878: FND_MSG_PUB.Count_And_Get(
879: p_encoded => FND_API.G_FALSE,
880: p_count => x_MSG_COUNT,

Line 877: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

873: p_count => x_MSG_COUNT,
874: p_data => X_MSG_DATA);
875: RETURN;
876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
877: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
878: FND_MSG_PUB.Count_And_Get(
879: p_encoded => FND_API.G_FALSE,
880: p_count => x_MSG_COUNT,
881: p_data => X_MSG_DATA);

Line 879: p_encoded => FND_API.G_FALSE,

875: RETURN;
876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
877: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
878: FND_MSG_PUB.Count_And_Get(
879: p_encoded => FND_API.G_FALSE,
880: p_count => x_MSG_COUNT,
881: p_data => X_MSG_DATA);
882: RETURN;
883: WHEN OTHERS THEN

Line 884: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

880: p_count => x_MSG_COUNT,
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(

Line 889: p_encoded => FND_API.G_FALSE,

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,
891: p_data => X_MSG_DATA);
892: RETURN;
893: END delete_row;