DBA Data[Home] [Help]

APPS.AMS_LIST_QUERY_PUB dependencies on AMS_UTILITY_PVT

Line 63: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

59:
60: -- Debug Message
61: IF (AMS_DEBUG_HIGH_ON) THEN
62:
63: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
64: END IF;
65:
66:
67: -- Initialize API return status to SUCCESS

Line 107: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

103:
104: -- Debug Message
105: IF (AMS_DEBUG_HIGH_ON) THEN
106:
107: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
108: END IF;
109:
110: -- Standard call to get message count and if count is 1, get message info.
111: FND_MSG_PUB.Count_And_Get

Line 117: WHEN AMS_Utility_PVT.resource_locked THEN

113: p_data => x_msg_data
114: );
115: EXCEPTION
116:
117: WHEN AMS_Utility_PVT.resource_locked THEN
118: x_return_status := FND_API.g_ret_sts_error;
119: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
120:
121: WHEN FND_API.G_EXC_ERROR THEN

Line 119: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

115: EXCEPTION
116:
117: WHEN AMS_Utility_PVT.resource_locked THEN
118: x_return_status := FND_API.g_ret_sts_error;
119: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
120:
121: WHEN FND_API.G_EXC_ERROR THEN
122: ROLLBACK TO CREATE_List_Query_PUB;
123: x_return_status := FND_API.G_RET_STS_ERROR;

Line 199: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

195:
196: -- Debug Message
197: IF (AMS_DEBUG_HIGH_ON) THEN
198:
199: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
200: END IF;
201:
202:
203: -- Initialize API return status to SUCCESS

Line 244: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

240:
241: -- Debug Message
242: IF (AMS_DEBUG_HIGH_ON) THEN
243:
244: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
245: END IF;
246:
247: -- Standard call to get message count and if count is 1, get message info.
248: FND_MSG_PUB.Count_And_Get

Line 254: WHEN AMS_Utility_PVT.resource_locked THEN

250: p_data => x_msg_data
251: );
252: EXCEPTION
253:
254: WHEN AMS_Utility_PVT.resource_locked THEN
255: x_return_status := FND_API.g_ret_sts_error;
256: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
257:
258: WHEN FND_API.G_EXC_ERROR THEN

Line 256: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

252: EXCEPTION
253:
254: WHEN AMS_Utility_PVT.resource_locked THEN
255: x_return_status := FND_API.g_ret_sts_error;
256: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
257:
258: WHEN FND_API.G_EXC_ERROR THEN
259: ROLLBACK TO CREATE_List_Query_PUB;
260: x_return_status := FND_API.G_RET_STS_ERROR;

Line 336: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

332:
333: -- Debug Message
334: IF (AMS_DEBUG_HIGH_ON) THEN
335:
336: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
337: END IF;
338:
339:
340: -- Initialize API return status to SUCCESS

Line 378: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

374:
375: -- Debug Message
376: IF (AMS_DEBUG_HIGH_ON) THEN
377:
378: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
379: END IF;
380:
381: -- Standard call to get message count and if count is 1, get message info.
382: FND_MSG_PUB.Count_And_Get

Line 388: WHEN AMS_Utility_PVT.resource_locked THEN

384: p_data => x_msg_data
385: );
386: EXCEPTION
387:
388: WHEN AMS_Utility_PVT.resource_locked THEN
389: x_return_status := FND_API.g_ret_sts_error;
390: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
391:
392: WHEN FND_API.G_EXC_ERROR THEN

Line 390: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

386: EXCEPTION
387:
388: WHEN AMS_Utility_PVT.resource_locked THEN
389: x_return_status := FND_API.g_ret_sts_error;
390: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
391:
392: WHEN FND_API.G_EXC_ERROR THEN
393: ROLLBACK TO UPDATE_List_Query_PUB;
394: x_return_status := FND_API.G_RET_STS_ERROR;

Line 472: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

468:
469: -- Debug Message
470: IF (AMS_DEBUG_HIGH_ON) THEN
471:
472: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
473: END IF;
474:
475:
476: -- Initialize API return status to SUCCESS

Line 516: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

512:
513: -- Debug Message
514: IF (AMS_DEBUG_HIGH_ON) THEN
515:
516: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
517: END IF;
518:
519: -- Standard call to get message count and if count is 1, get message info.
520: FND_MSG_PUB.Count_And_Get

Line 526: WHEN AMS_Utility_PVT.resource_locked THEN

522: p_data => x_msg_data
523: );
524: EXCEPTION
525:
526: WHEN AMS_Utility_PVT.resource_locked THEN
527: x_return_status := FND_API.g_ret_sts_error;
528: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
529:
530: WHEN FND_API.G_EXC_ERROR THEN

Line 528: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

524: EXCEPTION
525:
526: WHEN AMS_Utility_PVT.resource_locked THEN
527: x_return_status := FND_API.g_ret_sts_error;
528: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
529:
530: WHEN FND_API.G_EXC_ERROR THEN
531: ROLLBACK TO UPDATE_List_Query_PUB;
532: x_return_status := FND_API.G_RET_STS_ERROR;

Line 607: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

603:
604: -- Debug Message
605: IF (AMS_DEBUG_HIGH_ON) THEN
606:
607: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
608: END IF;
609:
610:
611: -- Initialize API return status to SUCCESS

Line 649: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

645:
646: -- Debug Message
647: IF (AMS_DEBUG_HIGH_ON) THEN
648:
649: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
650: END IF;
651:
652: -- Standard call to get message count and if count is 1, get message info.
653: FND_MSG_PUB.Count_And_Get

Line 659: WHEN AMS_Utility_PVT.resource_locked THEN

655: p_data => x_msg_data
656: );
657: EXCEPTION
658:
659: WHEN AMS_Utility_PVT.resource_locked THEN
660: x_return_status := FND_API.g_ret_sts_error;
661: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
662:
663: WHEN FND_API.G_EXC_ERROR THEN

Line 661: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

657: EXCEPTION
658:
659: WHEN AMS_Utility_PVT.resource_locked THEN
660: x_return_status := FND_API.g_ret_sts_error;
661: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
662:
663: WHEN FND_API.G_EXC_ERROR THEN
664: ROLLBACK TO DELETE_List_Query_PUB;
665: x_return_status := FND_API.G_RET_STS_ERROR;

Line 739: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

735:
736: -- Debug Message
737: IF (AMS_DEBUG_HIGH_ON) THEN
738:
739: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
740: END IF;
741:
742:
743: -- Initialize API return status to SUCCESS

Line 781: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

777:
778: -- Debug Message
779: IF (AMS_DEBUG_HIGH_ON) THEN
780:
781: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
782: END IF;
783:
784: -- Standard call to get message count and if count is 1, get message info.
785: FND_MSG_PUB.Count_And_Get

Line 791: WHEN AMS_Utility_PVT.resource_locked THEN

787: p_data => x_msg_data
788: );
789: EXCEPTION
790:
791: WHEN AMS_Utility_PVT.resource_locked THEN
792: x_return_status := FND_API.g_ret_sts_error;
793: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
794:
795: WHEN FND_API.G_EXC_ERROR THEN

Line 793: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

789: EXCEPTION
790:
791: WHEN AMS_Utility_PVT.resource_locked THEN
792: x_return_status := FND_API.g_ret_sts_error;
793: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
794:
795: WHEN FND_API.G_EXC_ERROR THEN
796: ROLLBACK TO DELETE_List_Query_PUB;
797: x_return_status := FND_API.G_RET_STS_ERROR;

Line 867: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

863:
864: -- Debug Message
865: IF (AMS_DEBUG_HIGH_ON) THEN
866:
867: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
868: END IF;
869:
870:
871: -- Initialize API return status to SUCCESS

Line 902: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

898:
899: -- Debug Message
900: IF (AMS_DEBUG_HIGH_ON) THEN
901:
902: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
903: END IF;
904:
905: EXCEPTION
906:

Line 907: WHEN AMS_Utility_PVT.resource_locked THEN

903: END IF;
904:
905: EXCEPTION
906:
907: WHEN AMS_Utility_PVT.resource_locked THEN
908: x_return_status := FND_API.g_ret_sts_error;
909: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
910:
911: WHEN FND_API.G_EXC_ERROR THEN

Line 909: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

905: EXCEPTION
906:
907: WHEN AMS_Utility_PVT.resource_locked THEN
908: x_return_status := FND_API.g_ret_sts_error;
909: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
910:
911: WHEN FND_API.G_EXC_ERROR THEN
912: ROLLBACK TO LOCK_List_Query_PUB;
913: x_return_status := FND_API.G_RET_STS_ERROR;