[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 (AMS_DEBUG_HIGH_ON) THEN
254: AMS_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
338: l_rowid ROWID;
339: l_media_id Number;
340:
341: BEGIN
342: -- Standard Start of API savepoint
343: SAVEPOINT UPDATE_Fnd_Attachment_PVT;
344:
345: -- Standard call to check for call compatibility.
346: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
341: BEGIN
342: -- Standard Start of API savepoint
343: SAVEPOINT UPDATE_Fnd_Attachment_PVT;
344:
345: -- Standard call to check for call compatibility.
346: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
347: p_api_version_number,
348: l_api_name,
349: G_PKG_NAME)
472:
473: -- End of API body.
474: --
475:
476: -- Standard check for p_commit
477: IF FND_API.to_Boolean( p_commit )
478: THEN
479: COMMIT WORK;
480: END IF;
484: IF (AMS_DEBUG_HIGH_ON) THEN
485: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
486: END IF;
487:
488: -- Standard call to get message count and if count is 1, get message info.
489: FND_MSG_PUB.Count_And_Get
490: (p_count => x_msg_count,
491: p_data => x_msg_data
492: );
498:
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO UPDATE_Fnd_Attachment_PVT;
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: -- Standard call to get message count and if count=1, get the message
503: FND_MSG_PUB.Count_And_Get (
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO UPDATE_Fnd_Attachment_PVT;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: -- Standard call to get message count and if count=1, get the message
513: FND_MSG_PUB.Count_And_Get (
514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data
522: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
523: THEN
524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
525: END IF;
526: -- Standard call to get message count and if count=1, get the message
527: FND_MSG_PUB.Count_And_Get (
528: p_encoded => FND_API.G_FALSE,
529: p_count => x_msg_count,
530: p_data => x_msg_data
576: and b.document_id <> p_document_id
577: );
578:
579: BEGIN
580: -- Standard Start of API savepoint
581: SAVEPOINT DELETE_Fnd_Attachment_PVT;
582:
583: -- Standard call to check for call compatibility.
584: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
579: BEGIN
580: -- Standard Start of API savepoint
581: SAVEPOINT DELETE_Fnd_Attachment_PVT;
582:
583: -- Standard call to check for call compatibility.
584: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
585: p_api_version_number,
586: l_api_name,
587: G_PKG_NAME)
669: --
670: -- End of API body
671: --
672:
673: -- Standard check for p_commit
674: IF FND_API.to_Boolean( p_commit )
675: THEN
676: COMMIT WORK;
677: END IF;
681: IF (AMS_DEBUG_HIGH_ON) THEN
682: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
683: END IF;
684:
685: -- Standard call to get message count and if count is 1, get message info.
686: FND_MSG_PUB.Count_And_Get
687: (p_count => x_msg_count,
688: p_data => x_msg_data
689: );
695:
696: WHEN FND_API.G_EXC_ERROR THEN
697: ROLLBACK TO DELETE_Fnd_Attachment_PVT;
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: -- Standard call to get message count and if count=1, get the message
700: FND_MSG_PUB.Count_And_Get (
701: p_encoded => FND_API.G_FALSE,
702: p_count => x_msg_count,
703: p_data => x_msg_data
705:
706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
707: ROLLBACK TO DELETE_Fnd_Attachment_PVT;
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: -- Standard call to get message count and if count=1, get the message
710: FND_MSG_PUB.Count_And_Get (
711: p_encoded => FND_API.G_FALSE,
712: p_count => x_msg_count,
713: p_data => x_msg_data
719: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
720: THEN
721: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
722: END IF;
723: -- Standard call to get message count and if count=1, get the message
724: FND_MSG_PUB.Count_And_Get (
725: p_encoded => FND_API.G_FALSE,
726: p_count => x_msg_count,
727: p_data => x_msg_data