[Home] [Help]
112:
113: BEGIN
114:
115: ---------------Initialize --------------------
116: -- Standard Start of API savepoint
117: SAVEPOINT create_user_resource;
118:
119: -- Initialize message list if p_init_msg_list is set to TRUE.
120: IF FND_API.to_Boolean( p_init_msg_list )
121: THEN
122: FND_MSG_PUB.initialize;
123: END IF;
124:
125: -- Standard call to check for call compatibility.
126: IF NOT FND_API.Compatible_API_Call (
127: l_api_version_number
128: ,p_api_version_number
129: ,l_api_name
404:
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: ROLLBACK TO create_user_resource;
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: -- Standard call to get message count and if count=1, get the message
409: FND_MSG_PUB.Count_And_Get (
410: p_encoded => FND_API.G_FALSE
411: ,p_count => x_msg_count
412: ,p_data => x_msg_data
484:
485: BEGIN
486:
487: ---------------Initialize --------------------
488: -- Standard Start of API savepoint
489: SAVEPOINT Register_Partner_And_User;
490:
491: -- Initialize message list if p_init_msg_list is set to TRUE.
492: IF FND_API.to_Boolean( p_init_msg_list )
493: THEN
494: FND_MSG_PUB.initialize;
495: END IF;
496:
497: -- Standard call to check for call compatibility.
498: IF NOT FND_API.Compatible_API_Call (
499: l_api_version_number
500: ,p_api_version_number
501: ,l_api_name
632:
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: ROLLBACK TO Register_Partner_And_User;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: -- Standard call to get message count and if count=1, get the message
637: FND_MSG_PUB.Count_And_Get (
638: p_encoded => FND_API.G_FALSE
639: ,p_count => x_msg_count
640: ,p_data => x_msg_data
704:
705: BEGIN
706:
707: ---------------Initialize --------------------
708: -- Standard Start of API savepoint
709: SAVEPOINT register_partner_user;
710:
711: -- Initialize message list if p_init_msg_list is set to TRUE.
712: IF FND_API.to_Boolean( p_init_msg_list )
713: THEN
714: FND_MSG_PUB.initialize;
715: END IF;
716:
717: -- Standard call to check for call compatibility.
718: IF NOT FND_API.Compatible_API_Call (
719: l_api_version_number
720: ,p_api_version_number
721: ,l_api_name
834:
835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
836: ROLLBACK TO register_partner_user;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: -- Standard call to get message count and if count=1, get the message
839: FND_MSG_PUB.Count_And_Get (
840: p_encoded => FND_API.G_FALSE
841: ,p_count => x_msg_count
842: ,p_data => x_msg_data
920:
921: BEGIN
922:
923: ---------------Initialize --------------------
924: -- Standard Start of API savepoint
925: SAVEPOINT revoke_role;
926:
927: -- Initialize message list if p_init_msg_list is set to TRUE.
928: IF FND_API.to_Boolean( p_init_msg_list )
929: THEN
930: FND_MSG_PUB.initialize;
931: END IF;
932:
933: -- Standard call to check for call compatibility.
934: IF NOT FND_API.Compatible_API_Call (
935: l_api_version_number
936: ,p_api_version_number
937: ,l_api_name
1073:
1074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1075: ROLLBACK TO revoke_role;
1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1077: -- Standard call to get message count and if count=1, get the message
1078: FND_MSG_PUB.Count_And_Get (
1079: p_encoded => FND_API.G_FALSE
1080: ,p_count => x_msg_count
1081: ,p_data => x_msg_data
1171:
1172: BEGIN
1173:
1174: ---------------Initialize --------------------
1175: -- Standard Start of API savepoint
1176: SAVEPOINT delete_role;
1177:
1178: -- Initialize message list if p_init_msg_list is set to TRUE.
1179: IF FND_API.to_Boolean( p_init_msg_list )
1180: THEN
1181: FND_MSG_PUB.initialize;
1182: END IF;
1183:
1184: -- Standard call to check for call compatibility.
1185: IF NOT FND_API.Compatible_API_Call (
1186: l_api_version_number
1187: ,p_api_version_number
1188: ,l_api_name
1351:
1352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1353: ROLLBACK TO delete_role;
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1355: -- Standard call to get message count and if count=1, get the message
1356: FND_MSG_PUB.Count_And_Get (
1357: p_encoded => FND_API.G_FALSE
1358: ,p_count => x_msg_count
1359: ,p_data => x_msg_data
1438:
1439: BEGIN
1440:
1441: ---------------Initialize --------------------
1442: -- Standard Start of API savepoint
1443: SAVEPOINT assign_role;
1444:
1445: -- Initialize message list if p_init_msg_list is set to TRUE.
1446: IF FND_API.to_Boolean( p_init_msg_list )
1447: THEN
1448: FND_MSG_PUB.initialize;
1449: END IF;
1450:
1451: -- Standard call to check for call compatibility.
1452: IF NOT FND_API.Compatible_API_Call (
1453: l_api_version_number
1454: ,p_api_version_number
1455: ,l_api_name
1594:
1595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1596: ROLLBACK TO assign_role;
1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1598: -- Standard call to get message count and if count=1, get the message
1599: FND_MSG_PUB.Count_And_Get (
1600: p_encoded => FND_API.G_FALSE
1601: ,p_count => x_msg_count
1602: ,p_data => x_msg_data
1695:
1696: BEGIN
1697:
1698: ---------------Initialize --------------------
1699: -- Standard Start of API savepoint
1700: SAVEPOINT update_role;
1701:
1702: -- Initialize message list if p_init_msg_list is set to TRUE.
1703: IF FND_API.to_Boolean( p_init_msg_list )
1704: THEN
1705: FND_MSG_PUB.initialize;
1706: END IF;
1707:
1708: -- Standard call to check for call compatibility.
1709: IF NOT FND_API.Compatible_API_Call (
1710: l_api_version_number
1711: ,p_api_version_number
1712: ,l_api_name
1952:
1953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1954: ROLLBACK TO update_role;
1955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1956: -- Standard call to get message count and if count=1, get the message
1957: FND_MSG_PUB.Count_And_Get (
1958: p_encoded => FND_API.G_FALSE
1959: ,p_count => x_msg_count
1960: ,p_data => x_msg_data
2478: p_count => x_msg_count,
2479: p_data => x_msg_data
2480: );
2481:
2482: -- Standard check for p_commit
2483: IF FND_API.to_Boolean( p_commit ) THEN
2484: COMMIT WORK;
2485: END IF;
2486:
2490: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2491:
2492: WHEN FND_API.G_EXC_ERROR THEN
2493: x_return_status := FND_API.G_RET_STS_ERROR;
2494: -- Standard call to get message count and if count=1, get the message
2495: FND_MSG_PUB.Count_And_Get (
2496: p_encoded => FND_API.G_FALSE,
2497: p_count => x_msg_count,
2498: p_data => x_msg_data
2499: );
2500:
2501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2503: -- Standard call to get message count and if count=1, get the message
2504: FND_MSG_PUB.Count_And_Get (
2505: p_encoded => FND_API.G_FALSE,
2506: p_count => x_msg_count,
2507: p_data => x_msg_data
2512: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2513: THEN
2514: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2515: END IF;
2516: -- Standard call to get message count and if count=1, get the message
2517: FND_MSG_PUB.Count_And_Get (
2518: p_encoded => FND_API.G_FALSE,
2519: p_count => x_msg_count,
2520: p_data => x_msg_data