[Home] [Help]
53: -- x_return_status OUT VARCHAR2
54: -- x_msg_count OUT NUMBER
55: -- x_msg_data OUT VARCHAR2
56: -- Version : Current version 1.0
57: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
58: -- and basic operation, developer must manually add parameters and business logic as necessary.
59: --
60: -- History
61: --
95: SELECT 1
96: FROM PV_PARTNER_ACCESSES
97: WHERE partner_access_id = l_id;
98: BEGIN
99: -- Standard Start of API savepoint
100: SAVEPOINT create_partner_accesses_pvt;
101:
102: -- Standard call to check for call compatibility.
103: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
98: BEGIN
99: -- Standard Start of API savepoint
100: SAVEPOINT create_partner_accesses_pvt;
101:
102: -- Standard call to check for call compatibility.
103: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
104: p_api_version_number,
105: l_api_name,
106: G_PKG_NAME)
231: --
232: -- End of API body
233: --
234:
235: -- Standard check for p_commit
236: IF FND_API.to_Boolean( p_commit )
237: THEN
238: COMMIT WORK;
239: END IF;
242: IF (PV_DEBUG_HIGH_ON) THEN
243: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end.');
244: END IF;
245:
246: -- Standard call to get message count and if count is 1, get message info.
247: FND_MSG_PUB.Count_And_Get
248: (p_count => x_msg_count,
249: p_data => x_msg_data
250: );
256:
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO CREATE_Partner_Accesses_PVT;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: -- Standard call to get message count and if count=1, get the message
261: FND_MSG_PUB.Count_And_Get (
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,
264: p_data => x_msg_data
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO CREATE_Partner_Accesses_PVT;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: -- Standard call to get message count and if count=1, get the message
271: FND_MSG_PUB.Count_And_Get (
272: p_encoded => FND_API.G_FALSE,
273: p_count => x_msg_count,
274: p_data => x_msg_data
280: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
281: THEN
282: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
283: END IF;
284: -- Standard call to get message count and if count=1, get the message
285: FND_MSG_PUB.Count_And_Get (
286: p_encoded => FND_API.G_FALSE,
287: p_count => x_msg_count,
288: p_data => x_msg_data
311: -- x_return_status OUT VARCHAR2
312: -- x_msg_count OUT NUMBER
313: -- x_msg_data OUT VARCHAR2
314: -- Version : Current version 1.0
315: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
316: -- and basic operation, developer must manually add parameters and business logic as necessary.
317: --
318: -- History
319: --
350: l_tar_partner_access_rec partner_access_rec_type := P_partner_access_rec;
351: l_rowid ROWID;
352: l_err_msg VARCHAR2(2000);
353: BEGIN
354: -- Standard Start of API savepoint
355: SAVEPOINT update_partner_accesses_pvt;
356:
357: -- Standard call to check for call compatibility.
358: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
353: BEGIN
354: -- Standard Start of API savepoint
355: SAVEPOINT update_partner_accesses_pvt;
356:
357: -- Standard call to check for call compatibility.
358: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
359: p_api_version_number,
360: l_api_name,
361: G_PKG_NAME)
498: --
499: -- End of API body.
500: --
501:
502: -- Standard check for p_commit
503: IF FND_API.to_Boolean( p_commit )
504: THEN
505: COMMIT WORK;
506: END IF;
510: IF (PV_DEBUG_HIGH_ON) THEN
511: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
512: END IF;
513:
514: -- Standard call to get message count and if count is 1, get message info.
515: FND_MSG_PUB.Count_And_Get
516: (p_count => x_msg_count,
517: p_data => x_msg_data
518: );
524:
525: WHEN FND_API.G_EXC_ERROR THEN
526: ROLLBACK TO UPDATE_Partner_Accesses_PVT;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: -- Standard call to get message count and if count=1, get the message
529: FND_MSG_PUB.Count_And_Get (
530: p_encoded => FND_API.G_FALSE,
531: p_count => x_msg_count,
532: p_data => x_msg_data
534:
535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
536: ROLLBACK TO UPDATE_Partner_Accesses_PVT;
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: -- Standard call to get message count and if count=1, get the message
539: FND_MSG_PUB.Count_And_Get (
540: p_encoded => FND_API.G_FALSE,
541: p_count => x_msg_count,
542: p_data => x_msg_data
548: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
549: THEN
550: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
551: END IF;
552: -- Standard call to get message count and if count=1, get the message
553: FND_MSG_PUB.Count_And_Get (
554: p_encoded => FND_API.G_FALSE,
555: p_count => x_msg_count,
556: p_data => x_msg_data
580: -- x_return_status OUT VARCHAR2
581: -- x_msg_count OUT NUMBER
582: -- x_msg_data OUT VARCHAR2
583: -- Version : Current version 1.0
584: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
585: -- and basic operation, developer must manually add parameters and business logic as necessary.
586: --
587: -- History
588: --
609: l_object_version_number NUMBER;
610: l_err_msg VARCHAR2(2000);
611:
612: BEGIN
613: -- Standard Start of API savepoint
614: SAVEPOINT delete_partner_accesses_pvt;
615:
616: -- Standard call to check for call compatibility.
617: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
612: BEGIN
613: -- Standard Start of API savepoint
614: SAVEPOINT delete_partner_accesses_pvt;
615:
616: -- Standard call to check for call compatibility.
617: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
618: p_api_version_number,
619: l_api_name,
620: G_PKG_NAME)
667: --
668: -- End of API body
669: --
670:
671: -- Standard check for p_commit
672: IF FND_API.to_Boolean( p_commit )
673: THEN
674: COMMIT WORK;
675: END IF;
678: IF (PV_DEBUG_HIGH_ON) THEN
679: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
680: END IF;
681:
682: -- Standard call to get message count and if count is 1, get message info.
683: FND_MSG_PUB.Count_And_Get
684: (p_count => x_msg_count,
685: p_data => x_msg_data
686: );
693: WHEN FND_API.G_EXC_ERROR THEN
694: ROLLBACK TO DELETE_Partner_Accesses_PVT;
695: x_return_status := FND_API.G_RET_STS_ERROR;
696:
697: -- Standard call to get message count and if count=1, get the message
698: FND_MSG_PUB.Count_And_Get (
699: p_encoded => FND_API.G_FALSE,
700: p_count => x_msg_count,
701: p_data => x_msg_data
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: ROLLBACK TO DELETE_Partner_Accesses_PVT;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707:
708: -- Standard call to get message count and if count=1, get the message
709: FND_MSG_PUB.Count_And_Get (
710: p_encoded => FND_API.G_FALSE,
711: p_count => x_msg_count,
712: p_data => x_msg_data
720: THEN
721: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
722: END IF;
723:
724: -- Standard call to get message count and if count=1, get the message
725: FND_MSG_PUB.Count_And_Get (
726: p_encoded => FND_API.G_FALSE,
727: p_count => x_msg_count,
728: p_data => x_msg_data
752: -- x_return_status OUT VARCHAR2
753: -- x_msg_count OUT NUMBER
754: -- x_msg_data OUT VARCHAR2
755: -- Version : Current version 1.0
756: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
757: -- and basic operation, developer must manually add parameters and business logic as necessary.
758: --
759: -- History
760: --
780: l_partner_access_id NUMBER;
781: l_err_msg VARCHAR2(2000);
782:
783: BEGIN
784: -- Standard Start of API savepoint
785: SAVEPOINT Lock_Partner_Accesses;
786:
787: -- Debug Message
788: IF (PV_DEBUG_HIGH_ON) THEN
794: THEN
795: FND_MSG_PUB.initialize;
796: END IF;
797:
798: -- Standard call to check for call compatibility.
799: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
800: p_api_version_number,
801: l_api_name,
802: G_PKG_NAME)
839:
840: WHEN FND_API.G_EXC_ERROR THEN
841: ROLLBACK TO Lock_Partner_Accesses;
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: -- Standard call to get message count and if count=1, get the message
844: FND_MSG_PUB.Count_And_Get (
845: p_encoded => FND_API.G_FALSE,
846: p_count => x_msg_count,
847: p_data => x_msg_data
849:
850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
851: ROLLBACK TO Lock_Partner_Accesses;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: -- Standard call to get message count and if count=1, get the message
854: FND_MSG_PUB.Count_And_Get (
855: p_encoded => FND_API.G_FALSE,
856: p_count => x_msg_count,
857: p_data => x_msg_data
863: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
864: THEN
865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
866: END IF;
867: -- Standard call to get message count and if count=1, get the message
868: FND_MSG_PUB.Count_And_Get (
869: p_encoded => FND_API.G_FALSE,
870: p_count => x_msg_count,
871: p_data => x_msg_data
1292: l_partner_access_rec partner_access_rec_type ;
1293: ld_partner_access_rec partner_access_rec_type ;
1294:
1295: BEGIN
1296: -- Standard Start of API savepoint
1297: SAVEPOINT validate_partner_accesses;
1298:
1299: -- Standard call to check for call compatibility.
1300: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1295: BEGIN
1296: -- Standard Start of API savepoint
1297: SAVEPOINT validate_partner_accesses;
1298:
1299: -- Standard call to check for call compatibility.
1300: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1301: p_api_version_number,
1302: l_api_name,
1303: G_PKG_NAME)
1366: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1367: END IF;
1368:
1369:
1370: -- Standard call to get message count and if count is 1, get message info.
1371: FND_MSG_PUB.Count_And_Get
1372: (p_count => x_msg_count,
1373: p_data => x_msg_data
1374: );
1380: WHEN FND_API.G_EXC_ERROR THEN
1381: ROLLBACK TO VALIDATE_Partner_Accesses;
1382: x_return_status := FND_API.G_RET_STS_ERROR;
1383:
1384: -- Standard call to get message count and if count=1, get the message
1385: FND_MSG_PUB.Count_And_Get (
1386: p_encoded => FND_API.G_FALSE,
1387: p_count => x_msg_count,
1388: p_data => x_msg_data
1391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1392: ROLLBACK TO VALIDATE_Partner_Accesses;
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394:
1395: -- Standard call to get message count and if count=1, get the message
1396: FND_MSG_PUB.Count_And_Get (
1397: p_encoded => FND_API.G_FALSE,
1398: p_count => x_msg_count,
1399: p_data => x_msg_data
1407: THEN
1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1409: END IF;
1410:
1411: -- Standard call to get message count and if count=1, get the message
1412: FND_MSG_PUB.Count_And_Get (
1413: p_encoded => FND_API.G_FALSE,
1414: p_count => x_msg_count,
1415: p_data => x_msg_data
1451: PVX_UTILITY_PVT.Error_Message('PV_INVALID_FLAG');
1452: x_return_status := FND_API.G_RET_STS_ERROR;
1453: END IF;
1454:
1455: -- Standard call to get message count and if count is 1, get message info.
1456: FND_MSG_PUB.Count_And_Get
1457: (p_count => x_msg_count,
1458: p_data => x_msg_data
1459: );