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_ADVISORS_PKG dependencies on FND_API

Line 455: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

451: x_last_update_login
452: ) RETURNING ROWID, group_advisor_id INTO x_rowid, x_group_advisor_id;
453:
454: -- Initialize API return status to success.
455: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
456: -- Standard call to get message count and if count is 1, get message info.
457: FND_MSG_PUB.Count_And_Get(
458: p_encoded => FND_API.G_FALSE,
459: p_count => x_MSG_COUNT,

Line 458: p_encoded => FND_API.G_FALSE,

454: -- Initialize API return status to success.
455: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
456: -- Standard call to get message count and if count is 1, get message info.
457: FND_MSG_PUB.Count_And_Get(
458: p_encoded => FND_API.G_FALSE,
459: p_count => x_MSG_COUNT,
460: p_data => X_MSG_DATA);
461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN

Line 462: WHEN FND_API.G_EXC_ERROR THEN

458: p_encoded => FND_API.G_FALSE,
459: p_count => x_MSG_COUNT,
460: p_data => X_MSG_DATA);
461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN
463: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
464: FND_MSG_PUB.Count_And_Get(
465: p_encoded => FND_API.G_FALSE,
466: p_count => x_MSG_COUNT,

Line 463: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

459: p_count => x_MSG_COUNT,
460: p_data => X_MSG_DATA);
461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN
463: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
464: FND_MSG_PUB.Count_And_Get(
465: p_encoded => FND_API.G_FALSE,
466: p_count => x_MSG_COUNT,
467: p_data => X_MSG_DATA);

Line 465: p_encoded => FND_API.G_FALSE,

461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN
463: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
464: FND_MSG_PUB.Count_And_Get(
465: p_encoded => FND_API.G_FALSE,
466: p_count => x_MSG_COUNT,
467: p_data => X_MSG_DATA);
468: RETURN;
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

465: p_encoded => FND_API.G_FALSE,
466: p_count => x_MSG_COUNT,
467: p_data => X_MSG_DATA);
468: RETURN;
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
470: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
471: FND_MSG_PUB.Count_And_Get(
472: p_encoded => FND_API.G_FALSE,
473: p_count => x_MSG_COUNT,

Line 470: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

466: p_count => x_MSG_COUNT,
467: p_data => X_MSG_DATA);
468: RETURN;
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
470: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
471: FND_MSG_PUB.Count_And_Get(
472: p_encoded => FND_API.G_FALSE,
473: p_count => x_MSG_COUNT,
474: p_data => X_MSG_DATA);

Line 472: p_encoded => FND_API.G_FALSE,

468: RETURN;
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
470: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
471: FND_MSG_PUB.Count_And_Get(
472: p_encoded => FND_API.G_FALSE,
473: p_count => x_MSG_COUNT,
474: p_data => X_MSG_DATA);
475: RETURN;
476: WHEN OTHERS THEN

Line 477: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 482: p_encoded => FND_API.G_FALSE,

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,
484: p_data => X_MSG_DATA);
485: RETURN;
486:

Line 562: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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;
563: -- Standard call to get message count and if count is 1, get message info.
564: FND_MSG_PUB.Count_And_Get(
565: p_encoded => FND_API.G_FALSE,
566: p_count => x_MSG_COUNT,

Line 565: p_encoded => FND_API.G_FALSE,

561: -- Initialize API return status to success.
562: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
563: -- Standard call to get message count and if count is 1, get message info.
564: FND_MSG_PUB.Count_And_Get(
565: p_encoded => FND_API.G_FALSE,
566: p_count => x_MSG_COUNT,
567: p_data => X_MSG_DATA);
568: RETURN;
569:

Line 571: WHEN FND_API.G_EXC_ERROR THEN

567: p_data => X_MSG_DATA);
568: RETURN;
569:
570: EXCEPTION
571: WHEN FND_API.G_EXC_ERROR THEN
572: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
573: FND_MSG_PUB.Count_And_Get(
574: p_encoded => FND_API.G_FALSE,
575: p_count => x_MSG_COUNT,

Line 572: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

568: RETURN;
569:
570: EXCEPTION
571: WHEN FND_API.G_EXC_ERROR THEN
572: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
573: FND_MSG_PUB.Count_And_Get(
574: p_encoded => FND_API.G_FALSE,
575: p_count => x_MSG_COUNT,
576: p_data => X_MSG_DATA);

Line 574: p_encoded => FND_API.G_FALSE,

570: EXCEPTION
571: WHEN FND_API.G_EXC_ERROR THEN
572: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
573: FND_MSG_PUB.Count_And_Get(
574: p_encoded => FND_API.G_FALSE,
575: p_count => x_MSG_COUNT,
576: p_data => X_MSG_DATA);
577: RETURN;
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

574: p_encoded => FND_API.G_FALSE,
575: p_count => x_MSG_COUNT,
576: p_data => X_MSG_DATA);
577: RETURN;
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
580: FND_MSG_PUB.Count_And_Get(
581: p_encoded => FND_API.G_FALSE,
582: p_count => x_MSG_COUNT,

Line 579: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

575: p_count => x_MSG_COUNT,
576: p_data => X_MSG_DATA);
577: RETURN;
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
580: FND_MSG_PUB.Count_And_Get(
581: p_encoded => FND_API.G_FALSE,
582: p_count => x_MSG_COUNT,
583: p_data => X_MSG_DATA);

Line 581: p_encoded => FND_API.G_FALSE,

577: RETURN;
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
580: FND_MSG_PUB.Count_And_Get(
581: p_encoded => FND_API.G_FALSE,
582: p_count => x_MSG_COUNT,
583: p_data => X_MSG_DATA);
584: RETURN;
585: WHEN OTHERS THEN

Line 586: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 591: p_encoded => FND_API.G_FALSE,

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,
593: p_data => X_MSG_DATA);
594: RETURN;
595:

Line 703: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

699: RAISE NO_DATA_FOUND;
700: END IF;
701:
702: -- Initialize API return status to success.
703: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
704: -- Standard call to get message count and if count is 1, get message info.
705: FND_MSG_PUB.Count_And_Get(
706: p_encoded => FND_API.G_FALSE,
707: p_count => x_MSG_COUNT,

Line 706: p_encoded => FND_API.G_FALSE,

702: -- Initialize API return status to success.
703: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
704: -- Standard call to get message count and if count is 1, get message info.
705: FND_MSG_PUB.Count_And_Get(
706: p_encoded => FND_API.G_FALSE,
707: p_count => x_MSG_COUNT,
708: p_data => X_MSG_DATA);
709: EXCEPTION
710: WHEN FND_API.G_EXC_ERROR THEN

Line 710: WHEN FND_API.G_EXC_ERROR THEN

706: p_encoded => FND_API.G_FALSE,
707: p_count => x_MSG_COUNT,
708: p_data => X_MSG_DATA);
709: EXCEPTION
710: WHEN FND_API.G_EXC_ERROR THEN
711: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
712: FND_MSG_PUB.Count_And_Get(
713: p_encoded => FND_API.G_FALSE,
714: p_count => x_MSG_COUNT,

Line 711: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

707: p_count => x_MSG_COUNT,
708: p_data => X_MSG_DATA);
709: EXCEPTION
710: WHEN FND_API.G_EXC_ERROR THEN
711: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
712: FND_MSG_PUB.Count_And_Get(
713: p_encoded => FND_API.G_FALSE,
714: p_count => x_MSG_COUNT,
715: p_data => X_MSG_DATA);

Line 713: p_encoded => FND_API.G_FALSE,

709: EXCEPTION
710: WHEN FND_API.G_EXC_ERROR THEN
711: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
712: FND_MSG_PUB.Count_And_Get(
713: p_encoded => FND_API.G_FALSE,
714: p_count => x_MSG_COUNT,
715: p_data => X_MSG_DATA);
716: RETURN;
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

713: p_encoded => FND_API.G_FALSE,
714: p_count => x_MSG_COUNT,
715: p_data => X_MSG_DATA);
716: RETURN;
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
719: FND_MSG_PUB.Count_And_Get(
720: p_encoded => FND_API.G_FALSE,
721: p_count => x_MSG_COUNT,

Line 718: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

714: p_count => x_MSG_COUNT,
715: p_data => X_MSG_DATA);
716: RETURN;
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
719: FND_MSG_PUB.Count_And_Get(
720: p_encoded => FND_API.G_FALSE,
721: p_count => x_MSG_COUNT,
722: p_data => X_MSG_DATA);

Line 720: p_encoded => FND_API.G_FALSE,

716: RETURN;
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
719: FND_MSG_PUB.Count_And_Get(
720: p_encoded => FND_API.G_FALSE,
721: p_count => x_MSG_COUNT,
722: p_data => X_MSG_DATA);
723: RETURN;
724: WHEN OTHERS THEN

Line 725: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 730: p_encoded => FND_API.G_FALSE,

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,
732: p_data => X_MSG_DATA);
733: RETURN;
734:

Line 847: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

843: RAISE NO_DATA_FOUND;
844: END IF;
845:
846: -- Initialize API return status to success.
847: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
848: -- Standard call to get message count and if count is 1, get message info.
849: FND_MSG_PUB.Count_And_Get(
850: p_encoded => FND_API.G_FALSE,
851: p_count => x_MSG_COUNT,

Line 850: p_encoded => FND_API.G_FALSE,

846: -- Initialize API return status to success.
847: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
848: -- Standard call to get message count and if count is 1, get message info.
849: FND_MSG_PUB.Count_And_Get(
850: p_encoded => FND_API.G_FALSE,
851: p_count => x_MSG_COUNT,
852: p_data => X_MSG_DATA);
853: EXCEPTION
854: WHEN FND_API.G_EXC_ERROR THEN

Line 854: WHEN FND_API.G_EXC_ERROR THEN

850: p_encoded => FND_API.G_FALSE,
851: p_count => x_MSG_COUNT,
852: p_data => X_MSG_DATA);
853: EXCEPTION
854: WHEN FND_API.G_EXC_ERROR THEN
855: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
856: FND_MSG_PUB.Count_And_Get(
857: p_encoded => FND_API.G_FALSE,
858: p_count => x_MSG_COUNT,

Line 855: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

851: p_count => x_MSG_COUNT,
852: p_data => X_MSG_DATA);
853: EXCEPTION
854: WHEN FND_API.G_EXC_ERROR THEN
855: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
856: FND_MSG_PUB.Count_And_Get(
857: p_encoded => FND_API.G_FALSE,
858: p_count => x_MSG_COUNT,
859: p_data => X_MSG_DATA);

Line 857: p_encoded => FND_API.G_FALSE,

853: EXCEPTION
854: WHEN FND_API.G_EXC_ERROR THEN
855: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
856: FND_MSG_PUB.Count_And_Get(
857: p_encoded => FND_API.G_FALSE,
858: p_count => x_MSG_COUNT,
859: p_data => X_MSG_DATA);
860: RETURN;
861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

857: p_encoded => FND_API.G_FALSE,
858: p_count => x_MSG_COUNT,
859: p_data => X_MSG_DATA);
860: RETURN;
861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
862: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
863: FND_MSG_PUB.Count_And_Get(
864: p_encoded => FND_API.G_FALSE,
865: p_count => x_MSG_COUNT,

Line 862: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

858: p_count => x_MSG_COUNT,
859: p_data => X_MSG_DATA);
860: RETURN;
861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
862: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
863: FND_MSG_PUB.Count_And_Get(
864: p_encoded => FND_API.G_FALSE,
865: p_count => x_MSG_COUNT,
866: p_data => X_MSG_DATA);

Line 864: p_encoded => FND_API.G_FALSE,

860: RETURN;
861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
862: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
863: FND_MSG_PUB.Count_And_Get(
864: p_encoded => FND_API.G_FALSE,
865: p_count => x_MSG_COUNT,
866: p_data => X_MSG_DATA);
867: RETURN;
868: WHEN OTHERS THEN

Line 869: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 874: p_encoded => FND_API.G_FALSE,

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,
876: p_data => X_MSG_DATA);
877: RETURN;
878: