[Home] [Help]
842: END IF;
843:
844: -- Debug Message
845: IF (AMW_DEBUG_HIGH_ON) THEN
846: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
847: END IF;
848:
849:
850: -- Initialize API return status to SUCCESS
857: -- =========================================================================
858:
859: IF FND_GLOBAL.User_Id IS NULL
860: THEN
861: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
862: RAISE FND_API.G_EXC_ERROR;
863: END IF;
864:
865: -- Debug Message
863: END IF;
864:
865: -- Debug Message
866: IF (AMW_DEBUG_HIGH_ON) THEN
867: AMW_UTILITY_PVT.debug_message( 'Private API: Calling table handler fnd_documents_pkg.insert_row');
868: END IF;
869:
870: l_media_id := p_Fnd_Attachment_rec.media_id;
871:
1013:
1014:
1015: -- Debug Message
1016: IF (AMW_DEBUG_HIGH_ON) THEN
1017: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1018: END IF;
1019:
1020: -- Standard call to get message count and if count is 1, get message info.
1021: FND_MSG_PUB.Count_And_Get
1025:
1026:
1027: EXCEPTION
1028:
1029: WHEN AMW_Utility_PVT.resource_locked THEN
1030: x_return_status := FND_API.g_ret_sts_error;
1031: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1032:
1033: WHEN FND_API.G_EXC_ERROR THEN
1027: EXCEPTION
1028:
1029: WHEN AMW_Utility_PVT.resource_locked THEN
1030: x_return_status := FND_API.g_ret_sts_error;
1031: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1032:
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
1035: x_return_status := FND_API.G_RET_STS_ERROR;