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.PV_PARTNER_GEO_MATCH_PVT dependencies on FND_API

Line 47: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

43: -- Parameters
44: --
45: -- IN
46: -- p_api_version_number IN NUMBER Required
47: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
48: --
49: -- OUT
50: -- x_return_status OUT VARCHAR2
51: -- x_msg_count OUT NUMBER

Line 66: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

62: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
63:
64: PROCEDURE Get_Matched_Geo_Hierarchy_Id(
65: p_api_version_number IN NUMBER
66: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
67:
68: ,x_return_status OUT NOCOPY VARCHAR2
69: ,x_msg_count OUT NOCOPY NUMBER
70: ,x_msg_data OUT NOCOPY VARCHAR2

Line 230: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

226: -- Standard Start of API savepoint
227: SAVEPOINT Get_Matched_Geo_Hierarchy_Id;
228:
229: -- Standard call to check for call compatibility.
230: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
231: p_api_version_number,
232: l_api_name,
233: G_PKG_NAME)
234: THEN

Line 235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

231: p_api_version_number,
232: l_api_name,
233: G_PKG_NAME)
234: THEN
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: END IF;
237:
238: -- Initialize message list if p_init_msg_list is set to TRUE.
239: IF FND_API.to_Boolean( p_init_msg_list )

Line 239: IF FND_API.to_Boolean( p_init_msg_list )

235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: END IF;
237:
238: -- Initialize message list if p_init_msg_list is set to TRUE.
239: IF FND_API.to_Boolean( p_init_msg_list )
240: THEN
241: FND_MSG_PUB.initialize;
242: END IF;
243:

Line 253: x_return_status := FND_API.G_RET_STS_SUCCESS;

249:
250:
251:
252: -- Initialize API return status to SUCCESS
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: -- open c_get_address fetch into l_address_rec;
256: OPEN c_get_address(p_partner_party_id);
257: FETCH c_get_address INTO l_address_rec;

Line 442: ( p_encoded => FND_API.G_FALSE,

438: END IF;
439:
440: -- Standard call to get message count and if count is 1, get message info.
441: FND_MSG_PUB.Count_And_Get
442: ( p_encoded => FND_API.G_FALSE,
443: p_count => x_msg_count,
444: p_data => x_msg_data
445: );
446:

Line 449: WHEN Fnd_Api.G_EXC_ERROR THEN

445: );
446:
447: EXCEPTION
448:
449: WHEN Fnd_Api.G_EXC_ERROR THEN
450: ROLLBACK TO Get_Matched_Geo_Hierarchy_Id;
451: x_return_status := Fnd_Api.G_RET_STS_ERROR;
452:
453: -- Standard call to get message count and if count=1, get the message

Line 451: x_return_status := Fnd_Api.G_RET_STS_ERROR;

447: EXCEPTION
448:
449: WHEN Fnd_Api.G_EXC_ERROR THEN
450: ROLLBACK TO Get_Matched_Geo_Hierarchy_Id;
451: x_return_status := Fnd_Api.G_RET_STS_ERROR;
452:
453: -- Standard call to get message count and if count=1, get the message
454: Fnd_Msg_Pub.Count_And_Get (
455: p_encoded => Fnd_Api.G_FALSE

Line 455: p_encoded => Fnd_Api.G_FALSE

451: x_return_status := Fnd_Api.G_RET_STS_ERROR;
452:
453: -- Standard call to get message count and if count=1, get the message
454: Fnd_Msg_Pub.Count_And_Get (
455: p_encoded => Fnd_Api.G_FALSE
456: ,p_count => x_msg_count
457: ,p_data => x_msg_data
458: );
459:

Line 460: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

456: ,p_count => x_msg_count
457: ,p_data => x_msg_data
458: );
459:
460: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
461: ROLLBACK TO Get_Matched_Geo_Hierarchy_Id;
462: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
463: -- Standard call to get message count and if count=1, get the message
464: Fnd_Msg_Pub.Count_And_Get (

Line 462: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

458: );
459:
460: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
461: ROLLBACK TO Get_Matched_Geo_Hierarchy_Id;
462: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
463: -- Standard call to get message count and if count=1, get the message
464: Fnd_Msg_Pub.Count_And_Get (
465: p_encoded => Fnd_Api.G_FALSE
466: ,p_count => x_msg_count

Line 465: p_encoded => Fnd_Api.G_FALSE

461: ROLLBACK TO Get_Matched_Geo_Hierarchy_Id;
462: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
463: -- Standard call to get message count and if count=1, get the message
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: );
469:

Line 472: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

468: );
469:
470: WHEN OTHERS THEN
471: ROLLBACK TO Get_Matched_Geo_Hierarchy_Id;
472: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
473: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
474: THEN
475: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
476: END IF;

Line 479: p_encoded => Fnd_Api.G_FALSE

475: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
476: END IF;
477: -- Standard call to get message count and if count=1, get the message
478: Fnd_Msg_Pub.Count_And_Get (
479: p_encoded => Fnd_Api.G_FALSE
480: ,p_count => x_msg_count
481: ,p_data => x_msg_data
482: );
483:

Line 594: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

590: *
591: ******/
592: PROCEDURE Get_Ptnr_Matched_Geo_Id (
593: p_api_version_number IN NUMBER
594: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
595:
596: ,x_return_status OUT NOCOPY VARCHAR2
597: ,x_msg_count OUT NOCOPY NUMBER
598: ,x_msg_data OUT NOCOPY VARCHAR2

Line 622: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

618: -- Standard Start of API savepoint
619: SAVEPOINT Get_Ptnr_Matched_Geo_Id;
620:
621: -- Standard call to check for call compatibility.
622: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
623: p_api_version_number,
624: l_api_name,
625: G_PKG_NAME)
626: THEN

Line 627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

623: p_api_version_number,
624: l_api_name,
625: G_PKG_NAME)
626: THEN
627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
628: END IF;
629:
630: -- Initialize message list if p_init_msg_list is set to TRUE.
631: IF FND_API.to_Boolean( p_init_msg_list )

Line 631: IF FND_API.to_Boolean( p_init_msg_list )

627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
628: END IF;
629:
630: -- Initialize message list if p_init_msg_list is set to TRUE.
631: IF FND_API.to_Boolean( p_init_msg_list )
632: THEN
633: FND_MSG_PUB.initialize;
634: END IF;
635:

Line 643: x_return_status := FND_API.G_RET_STS_SUCCESS;

639: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
640: END IF;
641:
642: -- Initialize API return status to SUCCESS
643: x_return_status := FND_API.G_RET_STS_SUCCESS;
644:
645: FOR x in c_get_address(p_partner_id)
646: LOOP
647: Get_Matched_Geo_Id_By_Country (

Line 656: p_encoded => Fnd_Api.G_FALSE

652: END LOOP;
653:
654: -- Standard call to get message count and if count=1, get the message
655: Fnd_Msg_Pub.Count_And_Get (
656: p_encoded => Fnd_Api.G_FALSE
657: ,p_count => x_msg_count
658: ,p_data => x_msg_data
659: );
660:

Line 665: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

661: EXCEPTION
662:
663: WHEN OTHERS THEN
664: ROLLBACK TO Get_Ptnr_Matched_Geo_Id;
665: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
666: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
667: THEN
668: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
669: END IF;

Line 672: p_encoded => Fnd_Api.G_FALSE

668: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
669: END IF;
670: -- Standard call to get message count and if count=1, get the message
671: Fnd_Msg_Pub.Count_And_Get (
672: p_encoded => Fnd_Api.G_FALSE
673: ,p_count => x_msg_count
674: ,p_data => x_msg_data
675: );
676:

Line 688: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

684: *
685: ******/
686: PROCEDURE Get_Ptnr_Org_Matched_Geo_Id (
687: p_api_version_number IN NUMBER
688: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
689:
690: ,x_return_status OUT NOCOPY VARCHAR2
691: ,x_msg_count OUT NOCOPY NUMBER
692: ,x_msg_data OUT NOCOPY VARCHAR2

Line 715: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

711: -- Standard Start of API savepoint
712: SAVEPOINT Get_Ptnr_Org_Matched_Geo_Id;
713:
714: -- Standard call to check for call compatibility.
715: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
716: p_api_version_number,
717: l_api_name,
718: G_PKG_NAME)
719: THEN

Line 720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

716: p_api_version_number,
717: l_api_name,
718: G_PKG_NAME)
719: THEN
720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
721: END IF;
722:
723: -- Initialize message list if p_init_msg_list is set to TRUE.
724: IF FND_API.to_Boolean( p_init_msg_list )

Line 724: IF FND_API.to_Boolean( p_init_msg_list )

720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
721: END IF;
722:
723: -- Initialize message list if p_init_msg_list is set to TRUE.
724: IF FND_API.to_Boolean( p_init_msg_list )
725: THEN
726: FND_MSG_PUB.initialize;
727: END IF;
728:

Line 736: x_return_status := FND_API.G_RET_STS_SUCCESS;

732: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
733: END IF;
734:
735: -- Initialize API return status to SUCCESS
736: x_return_status := FND_API.G_RET_STS_SUCCESS;
737:
738: FOR x in c_get_address(p_party_id)
739: LOOP
740: Get_Matched_Geo_Id_By_Country (

Line 749: p_encoded => Fnd_Api.G_FALSE

745: END LOOP;
746:
747: -- Standard call to get message count and if count=1, get the message
748: Fnd_Msg_Pub.Count_And_Get (
749: p_encoded => Fnd_Api.G_FALSE
750: ,p_count => x_msg_count
751: ,p_data => x_msg_data
752: );
753:

Line 758: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

754: EXCEPTION
755:
756: WHEN OTHERS THEN
757: ROLLBACK TO Get_Ptnr_Org_Matched_Geo_Id;
758: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
759: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
760: THEN
761: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
762: END IF;

Line 765: p_encoded => Fnd_Api.G_FALSE

761: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
762: END IF;
763: -- Standard call to get message count and if count=1, get the message
764: Fnd_Msg_Pub.Count_And_Get (
765: p_encoded => Fnd_Api.G_FALSE
766: ,p_count => x_msg_count
767: ,p_data => x_msg_data
768: );
769: