DBA Data[Home] [Help]

APPS.PV_USER_RESP_PVT dependencies on PVX_UTILITY_PVT

Line 74: Pvx_Utility_Pvt.debug_message('g_log_to_file = ' || g_log_to_file);

70: )
71: IS
72: BEGIN
73: IF (PV_DEBUG_HIGH_ON) THEN
74: Pvx_Utility_Pvt.debug_message('g_log_to_file = ' || g_log_to_file);
75: END IF;
76: IF (g_log_to_file = 'N') THEN
77: Pvx_Utility_Pvt.debug_message(p_msg_string);
78: ELSIF (g_log_to_file = 'Y') THEN

Line 77: Pvx_Utility_Pvt.debug_message(p_msg_string);

73: IF (PV_DEBUG_HIGH_ON) THEN
74: Pvx_Utility_Pvt.debug_message('g_log_to_file = ' || g_log_to_file);
75: END IF;
76: IF (g_log_to_file = 'N') THEN
77: Pvx_Utility_Pvt.debug_message(p_msg_string);
78: ELSIF (g_log_to_file = 'Y') THEN
79: FND_MESSAGE.Set_Name('PV', p_msg_type);
80: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
81: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );

Line 1024: WHEN PVX_Utility_PVT.resource_locked THEN

1020: );
1021:
1022: EXCEPTION
1023:
1024: WHEN PVX_Utility_PVT.resource_locked THEN
1025: x_return_status := FND_API.g_ret_sts_error;
1026: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1027:
1028: WHEN FND_API.G_EXC_ERROR THEN

Line 1026: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1022: EXCEPTION
1023:
1024: WHEN PVX_Utility_PVT.resource_locked THEN
1025: x_return_status := FND_API.g_ret_sts_error;
1026: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1027:
1028: WHEN FND_API.G_EXC_ERROR THEN
1029: ROLLBACK TO get_default_resp;
1030: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1220: WHEN PVX_Utility_PVT.resource_locked THEN

1216: );
1217:
1218: EXCEPTION
1219:
1220: WHEN PVX_Utility_PVT.resource_locked THEN
1221: x_return_status := FND_API.g_ret_sts_error;
1222: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1223:
1224: WHEN FND_API.G_EXC_ERROR THEN

Line 1222: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1218: EXCEPTION
1219:
1220: WHEN PVX_Utility_PVT.resource_locked THEN
1221: x_return_status := FND_API.g_ret_sts_error;
1222: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1223:
1224: WHEN FND_API.G_EXC_ERROR THEN
1225: ROLLBACK TO get_default_org_resp;
1226: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1408: WHEN PVX_Utility_PVT.resource_locked THEN

1404: );
1405:
1406: EXCEPTION
1407:
1408: WHEN PVX_Utility_PVT.resource_locked THEN
1409: x_return_status := FND_API.g_ret_sts_error;
1410: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1411:
1412: WHEN FND_API.G_EXC_ERROR THEN

Line 1410: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1406: EXCEPTION
1407:
1408: WHEN PVX_Utility_PVT.resource_locked THEN
1409: x_return_status := FND_API.g_ret_sts_error;
1410: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1411:
1412: WHEN FND_API.G_EXC_ERROR THEN
1413: ROLLBACK TO get_program_resp;
1414: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1550: WHEN PVX_Utility_PVT.resource_locked THEN

1546: );
1547:
1548: EXCEPTION
1549:
1550: WHEN PVX_Utility_PVT.resource_locked THEN
1551: x_return_status := FND_API.g_ret_sts_error;
1552: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1553:
1554: WHEN FND_API.G_EXC_ERROR THEN

Line 1552: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1548: EXCEPTION
1549:
1550: WHEN PVX_Utility_PVT.resource_locked THEN
1551: x_return_status := FND_API.g_ret_sts_error;
1552: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1553:
1554: WHEN FND_API.G_EXC_ERROR THEN
1555: ROLLBACK TO get_store_prgm_resps;
1556: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1689: WHEN PVX_Utility_PVT.resource_locked THEN

1685: );
1686:
1687: EXCEPTION
1688:
1689: WHEN PVX_Utility_PVT.resource_locked THEN
1690: x_return_status := FND_API.g_ret_sts_error;
1691: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1692:
1693: WHEN FND_API.G_EXC_ERROR THEN

Line 1691: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1687: EXCEPTION
1688:
1689: WHEN PVX_Utility_PVT.resource_locked THEN
1690: x_return_status := FND_API.g_ret_sts_error;
1691: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1692:
1693: WHEN FND_API.G_EXC_ERROR THEN
1694: ROLLBACK TO get_store_prgm_resps;
1695: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1870: WHEN PVX_Utility_PVT.resource_locked THEN

1866: );
1867:
1868: EXCEPTION
1869:
1870: WHEN PVX_Utility_PVT.resource_locked THEN
1871: x_return_status := FND_API.g_ret_sts_error;
1872: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1873:
1874: WHEN FND_API.G_EXC_ERROR THEN

Line 1872: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1868: EXCEPTION
1869:
1870: WHEN PVX_Utility_PVT.resource_locked THEN
1871: x_return_status := FND_API.g_ret_sts_error;
1872: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1873:
1874: WHEN FND_API.G_EXC_ERROR THEN
1875: x_return_status := FND_API.G_RET_STS_ERROR;
1876: -- Standard call to get message count and if count=1, get the message

Line 2026: WHEN PVX_Utility_PVT.resource_locked THEN

2022: );
2023:
2024: EXCEPTION
2025:
2026: WHEN PVX_Utility_PVT.resource_locked THEN
2027: x_return_status := FND_API.g_ret_sts_error;
2028: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2029:
2030: WHEN FND_API.G_EXC_ERROR THEN

Line 2028: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

2024: EXCEPTION
2025:
2026: WHEN PVX_Utility_PVT.resource_locked THEN
2027: x_return_status := FND_API.g_ret_sts_error;
2028: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2029:
2030: WHEN FND_API.G_EXC_ERROR THEN
2031: ROLLBACK TO assign_first_user_resp;
2032: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2315: WHEN PVX_Utility_PVT.resource_locked THEN

2311: );
2312:
2313: EXCEPTION
2314:
2315: WHEN PVX_Utility_PVT.resource_locked THEN
2316: x_return_status := FND_API.g_ret_sts_error;
2317: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2318:
2319: WHEN FND_API.G_EXC_ERROR THEN

Line 2317: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

2313: EXCEPTION
2314:
2315: WHEN PVX_Utility_PVT.resource_locked THEN
2316: x_return_status := FND_API.g_ret_sts_error;
2317: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2318:
2319: WHEN FND_API.G_EXC_ERROR THEN
2320: ROLLBACK TO assign_user_resps;
2321: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2453: WHEN PVX_Utility_PVT.resource_locked THEN

2449: );
2450:
2451: EXCEPTION
2452:
2453: WHEN PVX_Utility_PVT.resource_locked THEN
2454: x_return_status := FND_API.g_ret_sts_error;
2455: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2456:
2457: WHEN FND_API.G_EXC_ERROR THEN

Line 2455: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

2451: EXCEPTION
2452:
2453: WHEN PVX_Utility_PVT.resource_locked THEN
2454: x_return_status := FND_API.g_ret_sts_error;
2455: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2456:
2457: WHEN FND_API.G_EXC_ERROR THEN
2458: ROLLBACK TO assign_user_resps_2;
2459: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2683: WHEN PVX_Utility_PVT.resource_locked THEN

2679: );
2680:
2681: EXCEPTION
2682:
2683: WHEN PVX_Utility_PVT.resource_locked THEN
2684: x_return_status := FND_API.g_ret_sts_error;
2685: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2686:
2687: WHEN FND_API.G_EXC_ERROR THEN

Line 2685: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

2681: EXCEPTION
2682:
2683: WHEN PVX_Utility_PVT.resource_locked THEN
2684: x_return_status := FND_API.g_ret_sts_error;
2685: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2686:
2687: WHEN FND_API.G_EXC_ERROR THEN
2688: ROLLBACK TO switch_user_resp;
2689: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2861: WHEN PVX_Utility_PVT.resource_locked THEN

2857: );
2858:
2859: EXCEPTION
2860:
2861: WHEN PVX_Utility_PVT.resource_locked THEN
2862: x_return_status := FND_API.g_ret_sts_error;
2863: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2864:
2865: WHEN FND_API.G_EXC_ERROR THEN

Line 2863: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

2859: EXCEPTION
2860:
2861: WHEN PVX_Utility_PVT.resource_locked THEN
2862: x_return_status := FND_API.g_ret_sts_error;
2863: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2864:
2865: WHEN FND_API.G_EXC_ERROR THEN
2866: RAISE FND_API.G_EXC_ERROR;
2867: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3203: WHEN PVX_Utility_PVT.resource_locked THEN

3199: END IF;
3200:
3201: EXCEPTION
3202:
3203: WHEN PVX_Utility_PVT.resource_locked THEN
3204: x_return_status := FND_API.g_ret_sts_error;
3205: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
3206:
3207: WHEN FND_API.G_EXC_ERROR THEN

Line 3205: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

3201: EXCEPTION
3202:
3203: WHEN PVX_Utility_PVT.resource_locked THEN
3204: x_return_status := FND_API.g_ret_sts_error;
3205: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
3206:
3207: WHEN FND_API.G_EXC_ERROR THEN
3208: ROLLBACK TO manage_ter_exp_memb_resp;
3209: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3718: WHEN PVX_Utility_PVT.resource_locked THEN

3714: );
3715:
3716: EXCEPTION
3717:
3718: WHEN PVX_Utility_PVT.resource_locked THEN
3719: x_return_status := FND_API.g_ret_sts_error;
3720: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
3721:
3722: WHEN FND_API.G_EXC_ERROR THEN

Line 3720: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

3716: EXCEPTION
3717:
3718: WHEN PVX_Utility_PVT.resource_locked THEN
3719: x_return_status := FND_API.g_ret_sts_error;
3720: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
3721:
3722: WHEN FND_API.G_EXC_ERROR THEN
3723: ROLLBACK TO manage_active_memb_resp;
3724: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3871: WHEN PVX_Utility_PVT.resource_locked THEN

3867: );
3868:
3869: EXCEPTION
3870:
3871: WHEN PVX_Utility_PVT.resource_locked THEN
3872: x_return_status := FND_API.g_ret_sts_error;
3873: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
3874:
3875: WHEN FND_API.G_EXC_ERROR THEN

Line 3873: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

3869: EXCEPTION
3870:
3871: WHEN PVX_Utility_PVT.resource_locked THEN
3872: x_return_status := FND_API.g_ret_sts_error;
3873: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
3874:
3875: WHEN FND_API.G_EXC_ERROR THEN
3876: ROLLBACK TO manage_memb_resp;
3877: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4236: WHEN PVX_Utility_PVT.resource_locked THEN

4232: );
4233:
4234: EXCEPTION
4235:
4236: WHEN PVX_Utility_PVT.resource_locked THEN
4237: x_return_status := FND_API.g_ret_sts_error;
4238: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4239:
4240: WHEN FND_API.G_EXC_ERROR THEN

Line 4238: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

4234: EXCEPTION
4235:
4236: WHEN PVX_Utility_PVT.resource_locked THEN
4237: x_return_status := FND_API.g_ret_sts_error;
4238: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4239:
4240: WHEN FND_API.G_EXC_ERROR THEN
4241: ROLLBACK TO delete_resp_mapping;
4242: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4473: WHEN PVX_Utility_PVT.resource_locked THEN

4469: );
4470:
4471: EXCEPTION
4472:
4473: WHEN PVX_Utility_PVT.resource_locked THEN
4474: x_return_status := FND_API.g_ret_sts_error;
4475: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4476:
4477: WHEN FND_API.G_EXC_ERROR THEN

Line 4475: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

4471: EXCEPTION
4472:
4473: WHEN PVX_Utility_PVT.resource_locked THEN
4474: x_return_status := FND_API.g_ret_sts_error;
4475: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4476:
4477: WHEN FND_API.G_EXC_ERROR THEN
4478: ROLLBACK TO update_resp_mapping;
4479: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4887: WHEN PVX_Utility_PVT.resource_locked THEN

4883: );
4884:
4885: EXCEPTION
4886:
4887: WHEN PVX_Utility_PVT.resource_locked THEN
4888: x_return_status := FND_API.g_ret_sts_error;
4889: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4890:
4891: WHEN FND_API.G_EXC_ERROR THEN

Line 4889: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

4885: EXCEPTION
4886:
4887: WHEN PVX_Utility_PVT.resource_locked THEN
4888: x_return_status := FND_API.g_ret_sts_error;
4889: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4890:
4891: WHEN FND_API.G_EXC_ERROR THEN
4892: ROLLBACK TO create_resp_mapping;
4893: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5055: WHEN PVX_Utility_PVT.resource_locked THEN

5051: );
5052:
5053: EXCEPTION
5054:
5055: WHEN PVX_Utility_PVT.resource_locked THEN
5056: x_return_status := FND_API.g_ret_sts_error;
5057: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5058:
5059: WHEN FND_API.G_EXC_ERROR THEN

Line 5057: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

5053: EXCEPTION
5054:
5055: WHEN PVX_Utility_PVT.resource_locked THEN
5056: x_return_status := FND_API.g_ret_sts_error;
5057: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5058:
5059: WHEN FND_API.G_EXC_ERROR THEN
5060: ROLLBACK TO revoke_user_resps;
5061: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5186: WHEN PVX_Utility_PVT.resource_locked THEN

5182: );
5183:
5184: EXCEPTION
5185:
5186: WHEN PVX_Utility_PVT.resource_locked THEN
5187: x_return_status := FND_API.g_ret_sts_error;
5188: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5189:
5190: WHEN FND_API.G_EXC_ERROR THEN

Line 5188: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

5184: EXCEPTION
5185:
5186: WHEN PVX_Utility_PVT.resource_locked THEN
5187: x_return_status := FND_API.g_ret_sts_error;
5188: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5189:
5190: WHEN FND_API.G_EXC_ERROR THEN
5191: ROLLBACK TO revoke_user_resps;
5192: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5380: WHEN PVX_Utility_PVT.resource_locked THEN

5376: );
5377:
5378: EXCEPTION
5379:
5380: WHEN PVX_Utility_PVT.resource_locked THEN
5381: x_return_status := FND_API.g_ret_sts_error;
5382: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5383:
5384: WHEN FND_API.G_EXC_ERROR THEN

Line 5382: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

5378: EXCEPTION
5379:
5380: WHEN PVX_Utility_PVT.resource_locked THEN
5381: x_return_status := FND_API.g_ret_sts_error;
5382: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5383:
5384: WHEN FND_API.G_EXC_ERROR THEN
5385: ROLLBACK TO manage_store_resp_on_create;
5386: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5605: WHEN PVX_Utility_PVT.resource_locked THEN

5601: );
5602:
5603: EXCEPTION
5604:
5605: WHEN PVX_Utility_PVT.resource_locked THEN
5606: x_return_status := FND_API.g_ret_sts_error;
5607: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5608:
5609: WHEN FND_API.G_EXC_ERROR THEN

Line 5607: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

5603: EXCEPTION
5604:
5605: WHEN PVX_Utility_PVT.resource_locked THEN
5606: x_return_status := FND_API.g_ret_sts_error;
5607: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5608:
5609: WHEN FND_API.G_EXC_ERROR THEN
5610: ROLLBACK TO manage_store_resp_on_delete;
5611: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5937: WHEN PVX_Utility_PVT.resource_locked THEN

5933: END IF;
5934:
5935: EXCEPTION
5936:
5937: WHEN PVX_Utility_PVT.resource_locked THEN
5938: x_return_status := FND_API.g_ret_sts_error;
5939: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5940:
5941: WHEN FND_API.G_EXC_ERROR THEN

Line 5939: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

5935: EXCEPTION
5936:
5937: WHEN PVX_Utility_PVT.resource_locked THEN
5938: x_return_status := FND_API.g_ret_sts_error;
5939: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5940:
5941: WHEN FND_API.G_EXC_ERROR THEN
5942: ROLLBACK TO assign_default_resp;
5943: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6323: WHEN PVX_Utility_PVT.resource_locked THEN

6319: ,p_data => x_msg_data
6320: );
6321:
6322: EXCEPTION
6323: WHEN PVX_Utility_PVT.resource_locked THEN
6324: x_return_status := FND_API.g_ret_sts_error;
6325: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
6326:
6327: WHEN FND_API.G_EXC_ERROR THEN

Line 6325: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

6321:
6322: EXCEPTION
6323: WHEN PVX_Utility_PVT.resource_locked THEN
6324: x_return_status := FND_API.g_ret_sts_error;
6325: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
6326:
6327: WHEN FND_API.G_EXC_ERROR THEN
6328: ROLLBACK TO manage_resp_on_address_change;
6329: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6414: Pvx_Utility_Pvt.debug_message('g_log_to_file... = ' || g_log_to_file);

6410: THEN
6411: Fnd_Msg_Pub.initialize;
6412: END IF;
6413: /*
6414: Pvx_Utility_Pvt.debug_message('g_log_to_file... = ' || g_log_to_file);
6415:
6416: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
6417: FND_MESSAGE.set_token('TEXT', g_log_to_file);
6418: FND_MSG_PUB.add;

Line 6511: WHEN PVX_Utility_PVT.resource_locked THEN

6507: );
6508:
6509: EXCEPTION
6510:
6511: WHEN PVX_Utility_PVT.resource_locked THEN
6512: x_return_status := FND_API.g_ret_sts_error;
6513: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
6514:
6515: WHEN FND_API.G_EXC_ERROR THEN

Line 6513: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

6509: EXCEPTION
6510:
6511: WHEN PVX_Utility_PVT.resource_locked THEN
6512: x_return_status := FND_API.g_ret_sts_error;
6513: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
6514:
6515: WHEN FND_API.G_EXC_ERROR THEN
6516: ROLLBACK TO revoke_default_resp;
6517: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6696: WHEN PVX_Utility_PVT.resource_locked THEN

6692: );
6693:
6694: EXCEPTION
6695:
6696: WHEN PVX_Utility_PVT.resource_locked THEN
6697: x_return_status := FND_API.g_ret_sts_error;
6698: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
6699:
6700: WHEN FND_API.G_EXC_ERROR THEN

Line 6698: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

6694: EXCEPTION
6695:
6696: WHEN PVX_Utility_PVT.resource_locked THEN
6697: x_return_status := FND_API.g_ret_sts_error;
6698: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
6699:
6700: WHEN FND_API.G_EXC_ERROR THEN
6701: ROLLBACK TO assign_user_resps;
6702: x_return_status := FND_API.G_RET_STS_ERROR;

Line 7367: WHEN PVX_Utility_PVT.resource_locked THEN

7363: );
7364:
7365: EXCEPTION
7366:
7367: WHEN PVX_Utility_PVT.resource_locked THEN
7368: x_return_status := FND_API.g_ret_sts_error;
7369: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
7370:
7371: WHEN FND_API.G_EXC_ERROR THEN

Line 7369: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

7365: EXCEPTION
7366:
7367: WHEN PVX_Utility_PVT.resource_locked THEN
7368: x_return_status := FND_API.g_ret_sts_error;
7369: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
7370:
7371: WHEN FND_API.G_EXC_ERROR THEN
7372: ROLLBACK TO manage_merged_party_memb_resp;
7373: x_return_status := FND_API.G_RET_STS_ERROR;