[Home] [Help]
59: FROM FND_ATTACHED_DOCUMENTS
60: WHERE document_id = l_id;
61:
62: BEGIN
63: -- Standard Start of API savepoint
64: SAVEPOINT CREATE_Fnd_Attachment_PVT;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
62: BEGIN
63: -- Standard Start of API savepoint
64: SAVEPOINT CREATE_Fnd_Attachment_PVT;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
68: p_api_version_number,
69: l_api_name,
70: G_PKG_NAME)
241: );
242: end if;
243:
244:
245: -- Standard check for p_commit
246: IF FND_API.to_Boolean( p_commit )
247: THEN
248: COMMIT WORK;
249: END IF;
253: IF (AMW_DEBUG_HIGH_ON) THEN
254: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
255: END IF;
256:
257: -- Standard call to get message count and if count is 1, get message info.
258: FND_MSG_PUB.Count_And_Get
259: (p_count => x_msg_count,
260: p_data => x_msg_data
261: );
269:
270: WHEN FND_API.G_EXC_ERROR THEN
271: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: -- Standard call to get message count and if count=1, get the message
274: FND_MSG_PUB.Count_And_Get (
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,
277: p_data => x_msg_data
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: -- Standard call to get message count and if count=1, get the message
284: FND_MSG_PUB.Count_And_Get (
285: p_encoded => FND_API.G_FALSE,
286: p_count => x_msg_count,
287: p_data => x_msg_data
293: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
294: THEN
295: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
296: END IF;
297: -- Standard call to get message count and if count=1, get the message
298: FND_MSG_PUB.Count_And_Get (
299: p_encoded => FND_API.G_FALSE,
300: p_count => x_msg_count,
301: p_data => x_msg_data