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 STANDARD

Line 54: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

50: -- x_return_status OUT VARCHAR2
51: -- x_msg_count OUT NUMBER
52: -- x_msg_data OUT VARCHAR2
53: -- Version : Current version 1.0
54: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
55: -- and basic operation, developer must manually add parameters and business logic as necessary.
56: --
57: -- End of Comments
58: -- ==============================================================================

Line 226: -- Standard Start of API savepoint

222: l_postal_code_end VARCHAR2(6);
223:
224:
225: BEGIN
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,

Line 229: -- Standard call to check for call compatibility.

225: BEGIN
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)

Line 440: -- Standard call to get message count and if count is 1, get message info.

436:
437: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
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

Line 453: -- Standard call to get message count and if count=1, get the message

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
456: ,p_count => x_msg_count
457: ,p_data => x_msg_data

Line 463: -- Standard call to get message count and if count=1, get the message

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
467: ,p_data => x_msg_data

Line 477: -- Standard call to get message count and if count=1, get the message

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;
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

Line 618: -- Standard Start of API savepoint

614: and PP.partner_id = cv_partner_id
615: and PS.identifying_address_flag = 'Y';
616:
617: BEGIN
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,

Line 621: -- Standard call to check for call compatibility.

617: BEGIN
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)

Line 654: -- Standard call to get message count and if count=1, get the message

650: ,x_geo_hierarchy_id => x_geo_hierarchy_id
651: );
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

Line 670: -- Standard call to get message count and if count=1, get the message

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;
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

Line 711: -- Standard Start of API savepoint

707: and PS.party_id = cv_party_id
708: and PS.identifying_address_flag = 'Y';
709:
710: BEGIN
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,

Line 714: -- Standard call to check for call compatibility.

710: BEGIN
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)

Line 747: -- Standard call to get message count and if count=1, get the message

743: ,x_geo_hierarchy_id => x_geo_hierarchy_id
744: );
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

Line 763: -- Standard call to get message count and if count=1, get the message

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;
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