[Home] [Help]
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 )
308: THEN
309: COMMIT WORK;
310: END IF;
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
319: (p_count => x_msg_count,
320: p_data => x_msg_data
321: );
404: -- Local variable declaration for Create_Relationship API.
405: l_partner_id NUMBER;
406: l_default_resp_id NUMBER;
407:
408: -- Local variable declaration for Standard Out variables.
409: l_return_status VARCHAR2(1);
410: l_msg_count NUMBER;
411: l_msg_data VARCHAR2(2000);
412:
418:
419:
420: BEGIN
421:
422: -- Standard Start of API savepoint
423: SAVEPOINT create_partner_pvt;
424:
425: -- Standard call to check for call compatibility.
426: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
421:
422: -- Standard Start of API savepoint
423: SAVEPOINT create_partner_pvt;
424:
425: -- Standard call to check for call compatibility.
426: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
427: p_api_version_number,
428: l_api_name,
429: G_PKG_NAME)
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 )
681: THEN
682: COMMIT WORK;
683: END IF;
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
692: (p_count => x_msg_count,
693: p_data => x_msg_data
694: );
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;
705: -- Standard call to get message count and if count=1, get the message
706: FND_MSG_PUB.Count_And_Get (
707: p_encoded => FND_API.G_FALSE,
708: p_count => x_msg_count,
709: p_data => x_msg_data
718:
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: ROLLBACK TO create_partner_pvt;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: -- Standard call to get message count and if count=1, get the message
723: FND_MSG_PUB.Count_And_Get (
724: p_encoded => FND_API.G_FALSE,
725: p_count => x_msg_count,
726: p_data => x_msg_data
739: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
740: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
741: END IF;
742:
743: -- Standard call to get message count and if count=1, get the message
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 );
806: l_party_site_id number;
807: l_party_site_use_id number;
808: l_party_site_use VARCHAR2(20);
809:
810: -- Local variable declaration for Standard Out variables.
811: l_return_status VARCHAR2(1);
812: l_msg_count NUMBER;
813: l_msg_data VARCHAR2(2000);
814: l_cnt NUMBER;
1115:
1116: l_attr_value_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;
1117: l_prtnr_access_id_tbl PV_TERR_ASSIGN_PUB.prtnr_aces_tbl_type;
1118:
1119: -- Local variable declaration for Standard Out variables.
1120: l_return_status VARCHAR2(1);
1121: l_msg_count NUMBER;
1122: l_msg_data VARCHAR2(2000);
1123:
1121: l_msg_count NUMBER;
1122: l_msg_data VARCHAR2(2000);
1123:
1124: BEGIN
1125: -- Standard Start of API savepoint
1126: SAVEPOINT create_relationship_pvt;
1127:
1128: -- Standard call to check for call compatibility.
1129: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1124: BEGIN
1125: -- Standard Start of API savepoint
1126: SAVEPOINT create_relationship_pvt;
1127:
1128: -- Standard call to check for call compatibility.
1129: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1130: p_api_version_number,
1131: l_api_name,
1132: G_PKG_NAME)
1561: RAISE FND_API.G_EXC_ERROR;
1562: END IF;
1563:
1564:
1565: -- Standard check for p_commit
1566: IF FND_API.to_Boolean( p_commit )
1567: THEN
1568: COMMIT WORK;
1569: END IF;
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
1578: (p_count => x_msg_count,
1579: p_data => x_msg_data
1580: );
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;
1594: -- Standard call to get message count and if count=1, get the message
1595: FND_MSG_PUB.Count_And_Get (
1596: p_encoded => FND_API.G_FALSE,
1597: p_count => x_msg_count,
1598: p_data => x_msg_data
1600:
1601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1602: ROLLBACK TO create_relationship_pvt;
1603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1604: -- Standard call to get message count and if count=1, get the message
1605: FND_MSG_PUB.Count_And_Get (
1606: p_encoded => FND_API.G_FALSE,
1607: p_count => x_msg_count,
1608: p_data => x_msg_data
1614: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1615: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1616: END IF;
1617:
1618: -- Standard call to get message count and if count=1, get the message
1619: FND_MSG_PUB.Count_And_Get (
1620: p_encoded => FND_API.G_FALSE,
1621: p_count => x_msg_count,
1622: p_data => x_msg_data );
1695: --Table for qualifier records
1696: l_partner_qualifiers_tbl PV_TERR_ASSIGN_PUB.partner_qualifiers_tbl_type;
1697: l_party_id NUMBER := p_party_id;
1698:
1699: -- Local variable declaration for Standard Out variables.
1700: l_return_status VARCHAR2(1);
1701: l_msg_count NUMBER;
1702: l_msg_data VARCHAR2(2000);
1703:
1779:
1780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1781: ROLLBACK TO create_relationship_pvt;
1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1783: -- Standard call to get message count and if count=1, get the message
1784: FND_MSG_PUB.Count_And_Get (
1785: p_encoded => FND_API.G_FALSE,
1786: p_count => x_msg_count,
1787: p_data => x_msg_data
1793: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1794: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1795: END IF;
1796:
1797: -- Standard call to get message count and if count=1, get the message
1798: FND_MSG_PUB.Count_And_Get (
1799: p_encoded => FND_API.G_FALSE,
1800: p_count => x_msg_count,
1801: p_data => x_msg_data );
1921: -- Some common local variables used by all the API call.
1922: l_application_id NUMBER := 691; -- FND_GLOBAL.application_id;
1923: l_appl_short_name VARCHAR2(5) := 'PV'; -- FND_GLOBAL.APPLICATION_SHORT_NAME;
1924:
1925: -- Local variable declaration for Standard Out variables.
1926: l_return_status VARCHAR2(1);
1927: l_msg_count NUMBER;
1928: l_msg_data VARCHAR2(2000);
1929:
1928: l_msg_data VARCHAR2(2000);
1929:
1930: BEGIN
1931:
1932: -- Standard Start of API savepoint
1933: SAVEPOINT invite_partner_pvt;
1934:
1935: -- Standard call to check for call compatibility.
1936: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1931:
1932: -- Standard Start of API savepoint
1933: SAVEPOINT invite_partner_pvt;
1934:
1935: -- Standard call to check for call compatibility.
1936: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1937: p_api_version_number,
1938: l_api_name,
1939: G_PKG_NAME)
2215: END IF;
2216: END IF;
2217: **/
2218:
2219: -- Standard check for p_commit
2220: IF FND_API.to_Boolean( p_commit )
2221: THEN
2222: COMMIT WORK;
2223: END IF;
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
2232: (p_count => x_msg_count,
2233: p_data => x_msg_data
2234: );
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;
2245: -- Standard call to get message count and if count=1, get the message
2246: FND_MSG_PUB.Count_And_Get (
2247: p_encoded => FND_API.G_FALSE,
2248: p_count => x_msg_count,
2249: p_data => x_msg_data
2251:
2252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2253: ROLLBACK TO invite_partner_pvt;
2254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2255: -- Standard call to get message count and if count=1, get the message
2256: FND_MSG_PUB.Count_And_Get (
2257: p_encoded => FND_API.G_FALSE,
2258: p_count => x_msg_count,
2259: p_data => x_msg_data
2265: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2266: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2267: END IF;
2268:
2269: -- Standard call to get message count and if count=1, get the message
2270: FND_MSG_PUB.Count_And_Get (
2271: p_encoded => FND_API.G_FALSE,
2272: p_count => x_msg_count,
2273: p_data => x_msg_data );