227: -- Start : Rivendell Changes
228: -- Insert into pv_search_attr_values at the time of creating partner
229: -- Debug Message
230: IF (PV_DEBUG_HIGH_ON) THEN
231: PVX_UTILITY_PVT.debug_message('Start : Inserting into pv_search_attr_values table for partner :'||l_partner_id);
232: END IF;
233:
234: EXECUTE IMMEDIATE
235: ' INSERT INTO pv_search_attr_values
299:
300: -- end : Rivendell Changes
301: -- vansub
302: IF (PV_DEBUG_HIGH_ON) THEN
303: PVX_UTILITY_PVT.debug_message('End : Inserting into search table ');
304: END IF;
305:
306: -- Standard check for p_commit
307: IF FND_API.to_Boolean( p_commit )
310: END IF;
311:
312: -- Debug Message
313: IF (PV_DEBUG_HIGH_ON) THEN
314: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
315: END IF;
316:
317: -- Standard call to get message count and if count is 1, get message info.
318: FND_MSG_PUB.Count_And_Get
438: END IF;
439:
440: -- Debug Message
441: IF (PV_DEBUG_HIGH_ON) THEN
442: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
443: END IF;
444:
445: -- Initialize API return status to SUCCESS
446: x_return_status := FND_API.G_RET_STS_SUCCESS;
449: l_organization_rec.organization_name := p_organization_rec.organization_name;
450:
451: -- Debug Message
452: IF (PV_DEBUG_HIGH_ON) THEN
453: PVX_UTILITY_PVT.debug_message( 'Public API: Calling create Organization API');
454: END IF;
455:
456: -- Call HZ_PARTY_V2PUB.Create_Organization API, for creating a Party record
457: -- in HZ_PARTIES table for the supplied organization.
476: END IF;
477:
478: -- Debug Message
479: IF (PV_DEBUG_HIGH_ON) THEN
480: PVX_UTILITY_PVT.debug_message( 'Public API: Successfully completed HZ_PARTY_V2PUB.Create_Organization API Call');
481: END IF;
482:
483: -- Debug Message
484: IF (PV_DEBUG_HIGH_ON) THEN
481: END IF;
482:
483: -- Debug Message
484: IF (PV_DEBUG_HIGH_ON) THEN
485: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create Location API');
486: END IF;
487:
488: -- Initialize the l_location rec from the supplied parameter p_location_rec variable.
489: map_location_rec( p_location_rec => p_location_rec ,
508: END IF;
509:
510: -- Debug Message
511: IF (PV_DEBUG_HIGH_ON) THEN
512: PVX_UTILITY_PVT.debug_message( 'Public API: Successfully completed HZ_LOCATION_V2PUB.Create_Location API Call');
513: END IF;
514:
515: -- Debug Message
516: IF (PV_DEBUG_HIGH_ON) THEN
513: END IF;
514:
515: -- Debug Message
516: IF (PV_DEBUG_HIGH_ON) THEN
517: PVX_UTILITY_PVT.debug_message( 'Public API: Calling create Party Site API');
518: END IF;
519:
520: -- Initialize some of the Party Site related variable.
521: l_party_site_rec := p_party_site_rec;
544: END IF;
545:
546: -- Debug Message
547: IF (PV_DEBUG_HIGH_ON) THEN
548: PVX_UTILITY_PVT.debug_message( 'Private API: Successfully completed create Party Site API Call');
549: END IF;
550:
551: -- Call the Create_Realtionship API for creating rest of the stuff
552: -- related to partner organization.
600: -- Start : Rivendell Changes
601: -- Insert into pv_search_attr_values at the time of creating partner
602: -- Debug Message
603: IF (PV_DEBUG_HIGH_ON) THEN
604: PVX_UTILITY_PVT.debug_message('Start : Inserting into pv_search_attr_values table for partner :'||l_partner_id);
605: END IF;
606:
607: EXECUTE IMMEDIATE
608: ' INSERT INTO pv_search_attr_values
672:
673: -- end : Rivendell Changes
674: -- vansub
675: IF (PV_DEBUG_HIGH_ON) THEN
676: PVX_UTILITY_PVT.debug_message('End : Inserting into search table ');
677: END IF;
678:
679: -- Standard check for p_commit
680: IF FND_API.to_Boolean( p_commit )
683: END IF;
684:
685: -- Debug Message
686: IF (PV_DEBUG_HIGH_ON) THEN
687: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
688: END IF;
689:
690: -- Standard call to get message count and if count is 1, get message info.
691: FND_MSG_PUB.Count_And_Get
694: );
695: */
696: EXCEPTION
697:
698: WHEN PVX_UTILITY_PVT.resource_locked THEN
699: x_return_status := FND_API.g_ret_sts_error;
700: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
701:
702: WHEN FND_API.G_EXC_ERROR THEN
696: EXCEPTION
697:
698: WHEN PVX_UTILITY_PVT.resource_locked THEN
699: x_return_status := FND_API.g_ret_sts_error;
700: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
701:
702: WHEN FND_API.G_EXC_ERROR THEN
703: ROLLBACK TO create_partner_pvt;
704: x_return_status := FND_API.G_RET_STS_ERROR;
1140: FND_MSG_PUB.initialize;
1141: END IF;
1142:
1143: -- Debug Message
1144: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1145:
1146: -- Initialize API return status to SUCCESS
1147: x_return_status := FND_API.G_RET_STS_SUCCESS;
1148:
1505: END IF;
1506:
1507: -- Debug Message
1508: IF (PV_DEBUG_HIGH_ON) THEN
1509: PVX_UTILITY_PVT.debug_message('Prior to calling Create_Default_Membership API ');
1510: END IF;
1511:
1512: pv_prgm_approval_pvt.Create_Default_Membership (
1513: p_api_version_number => p_api_version_number
1522: );
1523:
1524: -- Debug Message
1525: IF (PV_DEBUG_HIGH_ON) THEN
1526: PVX_UTILITY_PVT.debug_message('After call to Create_Default_Membership API. l_return_status: ' || l_return_status);
1527: END IF;
1528:
1529: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1533: END IF;
1534:
1535: -- Debug Message
1536: IF (PV_DEBUG_HIGH_ON) THEN
1537: PVX_UTILITY_PVT.debug_message('Prior to calling update_elig_prgm_4_new_ptnr ');
1538: END IF;
1539:
1540:
1541: PV_USER_MGMT_PVT.update_elig_prgm_4_new_ptnr(
1551: );
1552:
1553: -- Debug Message
1554: IF (PV_DEBUG_HIGH_ON) THEN
1555: PVX_UTILITY_PVT.debug_message('After call to update_elig_prgm_4_new_ptnr API. l_return_status: ' || l_return_status);
1556: END IF;
1557:
1558: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1569: END IF;
1570:
1571: -- Debug Message
1572: IF (PV_DEBUG_HIGH_ON) THEN
1573: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
1574: END IF;
1575:
1576: -- Standard call to get message count and if count is 1, get message info.
1577: FND_MSG_PUB.Count_And_Get
1583:
1584:
1585: EXCEPTION
1586:
1587: WHEN PVX_UTILITY_PVT.resource_locked THEN
1588: x_return_status := FND_API.g_ret_sts_error;
1589: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1590:
1591: WHEN FND_API.G_EXC_ERROR THEN
1585: EXCEPTION
1586:
1587: WHEN PVX_UTILITY_PVT.resource_locked THEN
1588: x_return_status := FND_API.g_ret_sts_error;
1589: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1590:
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: ROLLBACK TO create_relationship_pvt;
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1947: FND_MSG_PUB.initialize;
1948: END IF;
1949:
1950: -- Debug Message
1951: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
1952:
1953: -- Initialize API return status to SUCCESS
1954: x_return_status := FND_API.G_RET_STS_SUCCESS;
1955:
2223: END IF;
2224:
2225: -- Debug Message
2226: IF (PV_DEBUG_HIGH_ON) THEN
2227: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' end.');
2228: END IF;
2229:
2230: -- Standard call to get message count and if count is 1, get message info.
2231: FND_MSG_PUB.Count_And_Get
2234: );
2235:
2236: EXCEPTION
2237:
2238: WHEN PVX_UTILITY_PVT.resource_locked THEN
2239: x_return_status := FND_API.g_ret_sts_error;
2240: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2241:
2242: WHEN FND_API.G_EXC_ERROR THEN
2236: EXCEPTION
2237:
2238: WHEN PVX_UTILITY_PVT.resource_locked THEN
2239: x_return_status := FND_API.g_ret_sts_error;
2240: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2241:
2242: WHEN FND_API.G_EXC_ERROR THEN
2243: ROLLBACK TO invite_partner_pvt;
2244: x_return_status := FND_API.G_RET_STS_ERROR;