[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
483:
484: BEGIN
485:
486: ---------------Initialize --------------------
487: -- Standard Start of API savepoint
488: SAVEPOINT Register_Partner_And_User;
489:
490: -- Initialize message list if p_init_msg_list is set to TRUE.
491: IF FND_API.to_Boolean( p_init_msg_list )
492: THEN
493: FND_MSG_PUB.initialize;
494: END IF;
495:
496: -- Standard call to check for call compatibility.
497: IF NOT FND_API.Compatible_API_Call (
498: l_api_version_number
499: ,p_api_version_number
500: ,l_api_name
631:
632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
633: ROLLBACK TO Register_Partner_And_User;
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: -- Standard call to get message count and if count=1, get the message
636: FND_MSG_PUB.Count_And_Get (
637: p_encoded => FND_API.G_FALSE
638: ,p_count => x_msg_count
639: ,p_data => x_msg_data
702:
703: BEGIN
704:
705: ---------------Initialize --------------------
706: -- Standard Start of API savepoint
707: SAVEPOINT register_partner_user;
708:
709: -- Initialize message list if p_init_msg_list is set to TRUE.
710: IF FND_API.to_Boolean( p_init_msg_list )
711: THEN
712: FND_MSG_PUB.initialize;
713: END IF;
714:
715: -- Standard call to check for call compatibility.
716: IF NOT FND_API.Compatible_API_Call (
717: l_api_version_number
718: ,p_api_version_number
719: ,l_api_name
832:
833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
834: ROLLBACK TO register_partner_user;
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: -- Standard call to get message count and if count=1, get the message
837: FND_MSG_PUB.Count_And_Get (
838: p_encoded => FND_API.G_FALSE
839: ,p_count => x_msg_count
840: ,p_data => x_msg_data
918:
919: BEGIN
920:
921: ---------------Initialize --------------------
922: -- Standard Start of API savepoint
923: SAVEPOINT revoke_role;
924:
925: -- Initialize message list if p_init_msg_list is set to TRUE.
926: IF FND_API.to_Boolean( p_init_msg_list )
927: THEN
928: FND_MSG_PUB.initialize;
929: END IF;
930:
931: -- Standard call to check for call compatibility.
932: IF NOT FND_API.Compatible_API_Call (
933: l_api_version_number
934: ,p_api_version_number
935: ,l_api_name
1071:
1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1073: ROLLBACK TO revoke_role;
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1075: -- Standard call to get message count and if count=1, get the message
1076: FND_MSG_PUB.Count_And_Get (
1077: p_encoded => FND_API.G_FALSE
1078: ,p_count => x_msg_count
1079: ,p_data => x_msg_data
1169:
1170: BEGIN
1171:
1172: ---------------Initialize --------------------
1173: -- Standard Start of API savepoint
1174: SAVEPOINT delete_role;
1175:
1176: -- Initialize message list if p_init_msg_list is set to TRUE.
1177: IF FND_API.to_Boolean( p_init_msg_list )
1178: THEN
1179: FND_MSG_PUB.initialize;
1180: END IF;
1181:
1182: -- Standard call to check for call compatibility.
1183: IF NOT FND_API.Compatible_API_Call (
1184: l_api_version_number
1185: ,p_api_version_number
1186: ,l_api_name
1349:
1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1351: ROLLBACK TO delete_role;
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1353: -- Standard call to get message count and if count=1, get the message
1354: FND_MSG_PUB.Count_And_Get (
1355: p_encoded => FND_API.G_FALSE
1356: ,p_count => x_msg_count
1357: ,p_data => x_msg_data
1436:
1437: BEGIN
1438:
1439: ---------------Initialize --------------------
1440: -- Standard Start of API savepoint
1441: SAVEPOINT assign_role;
1442:
1443: -- Initialize message list if p_init_msg_list is set to TRUE.
1444: IF FND_API.to_Boolean( p_init_msg_list )
1445: THEN
1446: FND_MSG_PUB.initialize;
1447: END IF;
1448:
1449: -- Standard call to check for call compatibility.
1450: IF NOT FND_API.Compatible_API_Call (
1451: l_api_version_number
1452: ,p_api_version_number
1453: ,l_api_name
1592:
1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1594: ROLLBACK TO assign_role;
1595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1596: -- Standard call to get message count and if count=1, get the message
1597: FND_MSG_PUB.Count_And_Get (
1598: p_encoded => FND_API.G_FALSE
1599: ,p_count => x_msg_count
1600: ,p_data => x_msg_data
1693:
1694: BEGIN
1695:
1696: ---------------Initialize --------------------
1697: -- Standard Start of API savepoint
1698: SAVEPOINT update_role;
1699:
1700: -- Initialize message list if p_init_msg_list is set to TRUE.
1701: IF FND_API.to_Boolean( p_init_msg_list )
1702: THEN
1703: FND_MSG_PUB.initialize;
1704: END IF;
1705:
1706: -- Standard call to check for call compatibility.
1707: IF NOT FND_API.Compatible_API_Call (
1708: l_api_version_number
1709: ,p_api_version_number
1710: ,l_api_name
1950:
1951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1952: ROLLBACK TO update_role;
1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1954: -- Standard call to get message count and if count=1, get the message
1955: FND_MSG_PUB.Count_And_Get (
1956: p_encoded => FND_API.G_FALSE
1957: ,p_count => x_msg_count
1958: ,p_data => x_msg_data
2475: p_count => x_msg_count,
2476: p_data => x_msg_data
2477: );
2478:
2479: -- Standard check for p_commit
2480: IF FND_API.to_Boolean( p_commit ) THEN
2481: COMMIT WORK;
2482: END IF;
2483:
2487: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2488:
2489: WHEN FND_API.G_EXC_ERROR THEN
2490: x_return_status := FND_API.G_RET_STS_ERROR;
2491: -- Standard call to get message count and if count=1, get the message
2492: FND_MSG_PUB.Count_And_Get (
2493: p_encoded => FND_API.G_FALSE,
2494: p_count => x_msg_count,
2495: p_data => x_msg_data
2496: );
2497:
2498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2500: -- Standard call to get message count and if count=1, get the message
2501: FND_MSG_PUB.Count_And_Get (
2502: p_encoded => FND_API.G_FALSE,
2503: p_count => x_msg_count,
2504: p_data => x_msg_data
2509: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2510: THEN
2511: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2512: END IF;
2513: -- Standard call to get message count and if count=1, get the message
2514: FND_MSG_PUB.Count_And_Get (
2515: p_encoded => FND_API.G_FALSE,
2516: p_count => x_msg_count,
2517: p_data => x_msg_data