[Home] [Help]
371: AND ver.citem_Version_id = (select max(citem_version_id) from ibc_citem_versions_b where content_item_id = ci.content_item_id);
372: --anchaudh on 27 Oct '03: added the above extra clause.
373:
374: BEGIN
375: -- Standard Start of API savepoint
376: SAVEPOINT Approve_Content_Item;
377:
378: -- Initialize message list if p_init_msg_list is set to TRUE.
379: IF FND_API.to_Boolean( p_init_msg_list )
420: END IF;
421: --
422: -- End of API body.
423: --
424: -- Standard check for p_commit
425: IF FND_API.to_Boolean( p_commit )
426: THEN
427: COMMIT WORK;
428: END IF;
430:
431: -- Debug Message
432: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
433:
434: -- Standard call to get message count and if count is 1, get message info.
435: FND_MSG_PUB.Count_And_Get
436: (p_count => x_msg_count,
437: p_data => x_msg_data
438: );
448:
449: WHEN FND_API.G_EXC_ERROR THEN
450: ROLLBACK TO Approve_Content_Item;
451: x_return_status := FND_API.G_RET_STS_ERROR;
452: -- Standard call to get message count and if count=1, get the message
453: FND_MSG_PUB.Count_And_Get (
454: p_encoded => FND_API.G_FALSE,
455: p_count => x_msg_count,
456: p_data => x_msg_data
458:
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: ROLLBACK TO Approve_Content_Item;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: -- Standard call to get message count and if count=1, get the message
463: FND_MSG_PUB.Count_And_Get (
464: p_encoded => FND_API.G_FALSE,
465: p_count => x_msg_count,
466: p_data => x_msg_data
472: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
473: THEN
474: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
475: END IF;
476: -- Standard call to get message count and if count=1, get the message
477: FND_MSG_PUB.Count_And_Get (
478: p_encoded => FND_API.G_FALSE,
479: p_count => x_msg_count,
480: p_data => x_msg_data