[Home] [Help]
54: SAVEPOINT WEBMARKETING_PLCE_CONTENT_TYPE;
55:
56: EXCEPTION
57:
58: WHEN AMS_Utility_PVT.resource_locked THEN
59: x_return_status := FND_API.g_ret_sts_error;
60: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
61:
62:
56: EXCEPTION
57:
58: WHEN AMS_Utility_PVT.resource_locked THEN
59: x_return_status := FND_API.g_ret_sts_error;
60: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
61:
62:
63: WHEN FND_API.G_EXC_ERROR THEN
64: ROLLBACK TO WEBMARKETING_PLCE_CONTENT_TYPE;
196:
197: -- Debug Message
198: --Bug Fix 4652859
199: IF (AMS_DEBUG_HIGH_ON) THEN
200: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
201: END IF;
202:
203:
204: -- Initialize API return status to SUCCESS
366:
367: -- Debug Message
368:
369: IF (AMS_DEBUG_HIGH_ON) THEN
370: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
371: END IF;
372:
373: -- Standard call to get message count and if count is 1, get message info.
374: FND_MSG_PUB.Count_And_Get
524: END IF;
525:
526: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
527: IF (AMS_DEBUG_HIGH_ON) THEN
528: AMS_UTILITY_PVT.debug_message('In Validate: before VALIDATE_WEB_PLCE_ASSOC call ' );
529: END IF;
530:
531: END IF;
532:
532:
533:
534: -- Debug Message
535: IF (AMS_DEBUG_HIGH_ON) THEN
536: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
537: END IF;
538:
539:
540: -- Initialize API return status to SUCCESS
542:
543:
544: -- Debug Message
545: IF (AMS_DEBUG_HIGH_ON) THEN
546: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
547: END IF;
548:
549: -- Standard call to get message count and if count is 1, get message info.
550: FND_MSG_PUB.Count_And_Get
553: );
554:
555: EXCEPTION
556:
557: WHEN AMS_Utility_PVT.resource_locked THEN
558: x_return_status := FND_API.g_ret_sts_error;
559: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
560: WHEN FND_API.G_EXC_ERROR THEN
561: ROLLBACK TO VALIDATE_WEB_PLCE_ASSOC_PVT;
555: EXCEPTION
556:
557: WHEN AMS_Utility_PVT.resource_locked THEN
558: x_return_status := FND_API.g_ret_sts_error;
559: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
560: WHEN FND_API.G_EXC_ERROR THEN
561: ROLLBACK TO VALIDATE_WEB_PLCE_ASSOC_PVT;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: -- Standard call to get message count and if count=1, get the message
568: );
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
570: ROLLBACK TO VALIDATE_WEB_PLCE_ASSOC_PVT;
571: IF (AMS_DEBUG_HIGH_ON) THEN
572: AMS_UTILITY_PVT.debug_message('In Validate - unexpected err: validation_mode= ' || p_validation_mode);
573: END IF;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: -- Standard call to get message count and if count=1, get the message
576: FND_MSG_PUB.Count_And_Get (
581: WHEN OTHERS THEN
582: ROLLBACK TO VALIDATE_WEB_PLCE_ASSOC_PVT;
583: IF (AMS_DEBUG_HIGH_ON) THEN
584:
585: AMS_UTILITY_PVT.debug_message('In Validate - others err: validation_mode= ' || p_validation_mode);
586: END IF;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
589: THEN
734: END IF;
735:
736: -- Debug Message
737: IF (AMS_DEBUG_HIGH_ON) THEN
738: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
739: END IF;
740:
741: -- Initialize API return status to SUCCESS
742: x_return_status := FND_API.G_RET_STS_SUCCESS;
748: -- =========================================================================
749:
750: IF FND_GLOBAL.User_Id IS NULL
751: THEN
752: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
753: RAISE FND_API.G_EXC_ERROR;
754: END IF;
755:
756:
759: THEN
760:
761: -- Debug message
762: IF (AMS_DEBUG_HIGH_ON) THEN
763: AMS_UTILITY_PVT.debug_message('Private API: VALIDATE_WEB_PLCE_ASSOC');
764: END IF;
765:
766: -- Invoke validation procedures
767:
768:
769: END IF;
770:
771: IF (AMS_DEBUG_HIGH_ON) THEN
772: AMS_UTILITY_PVT.debug_message('In CREATE_WEB_PLCE_ASSOC: before VALIDATE_WEB_PLCE_ASSOC call ' );
773: END IF;
774:
775: IF (AMS_DEBUG_HIGH_ON) THEN
776: AMS_UTILITY_PVT.debug_message('In CREATE_WEB_PLCE_ASSOC: before VALIDATE_WEB_PLCE_ASSOC call ' );
772: AMS_UTILITY_PVT.debug_message('In CREATE_WEB_PLCE_ASSOC: before VALIDATE_WEB_PLCE_ASSOC call ' );
773: END IF;
774:
775: IF (AMS_DEBUG_HIGH_ON) THEN
776: AMS_UTILITY_PVT.debug_message('In CREATE_WEB_PLCE_ASSOC: before VALIDATE_WEB_PLCE_ASSOC call ' );
777: END IF;
778:
779: -- Local variable initialization
780:
796:
797:
798: -- Debug Message
799: IF (AMS_DEBUG_HIGH_ON) THEN
800: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
801: END IF;
802:
803: -- Invoke table handler(AMS_WEB_PLCE_MP_PKG.INSERT_ROW)
804:
894: END IF;
895:
896: -- Debug Message
897: -- IF (AMS_DEBUG_HIGH_ON) THEN
898: -- AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
899: -- END IF;
900:
901: -- Standard call to get message count and if count is 1, get message info.
902: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
915: -- End of API body
916:
917: EXCEPTION
918:
919: WHEN AMS_Utility_PVT.resource_locked THEN
920: x_return_status := FND_API.g_ret_sts_error;
921: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
922:
923:
917: EXCEPTION
918:
919: WHEN AMS_Utility_PVT.resource_locked THEN
920: x_return_status := FND_API.g_ret_sts_error;
921: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
922:
923:
924: WHEN FND_API.G_EXC_ERROR THEN
925: ROLLBACK TO CREATE_WEB_PLCE_ASSOC;
1030:
1031: -- Debug Message
1032: --Bug Fix 4652859
1033: IF (AMS_DEBUG_HIGH_ON) THEN
1034: AMS_UTILITY_PVT.debug_message('Private API: ' || L_API_NAME || 'start');
1035: END IF;
1036:
1037:
1038: -- Initialize API return status to SUCCESS
1165:
1166: -- Debug Message
1167: --Bug Fix 4652859
1168: IF (AMS_DEBUG_HIGH_ON) THEN
1169: AMS_UTILITY_PVT.debug_message('Private API: ' || L_API_NAME || 'start');
1170: END IF;
1171:
1172:
1173: -- Initialize API return status to SUCCESS