[Home] [Help]
1: PACKAGE BODY EAM_ASSET_LOG_PUB AS
2: /* $Header: EAMPALGB.pls 120.8 2012/01/27 10:50:53 vchidura ship $ */
3:
4: /*
5: --Start of comments
2: /* $Header: EAMPALGB.pls 120.8 2012/01/27 10:50:53 vchidura ship $ */
3:
4: /*
5: --Start of comments
6: -- API name : EAM_ASSET_LOG_PUB
7: -- Type : Public
8: -- Function : Inserts Asset Log into EAM ASSET LOG Table
9: -- Pre-reqs : None.
10: */
34: x_return_status OUT NOCOPY varchar2,
35: x_msg_count OUT NOCOPY number,
36: x_msg_data OUT NOCOPY varchar2)
37: IS
38: l_api_name CONSTANT varchar2(30) :='EAM_ASSET_LOG_PUB';
39: l_api_version CONSTANT number := 1.0;
40: l_association_id number;
41: l_validated boolean;
42: l_item_type number;
63: cii.last_vld_organization_id = mp.organization_id;
64:
65: BEGIN
66: /* Standard Start of API savepoint */
67: SAVEPOINT EAM_ASSET_LOG_PUB_SV;
68:
69: /* Standard call to check for call compatibility. */
70: IF NOT FND_API.Compatible_API_Call
71: ( l_api_version ,
253: );
254:
255: EXCEPTION
256: WHEN FND_API.G_EXC_ERROR THEN
257: ROLLBACK TO EAM_ASSET_LOG_PUB_SV;
258: x_return_status := FND_API.G_RET_STS_ERROR ;
259: FND_MSG_PUB.Get
260: ( p_msg_index_out => x_msg_count ,
261: p_data => x_msg_data
261: p_data => x_msg_data
262: );
263:
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: ROLLBACK TO EAM_ASSET_LOG_PUB_SV;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
267: FND_MSG_PUB.get
268: ( p_msg_index_out => x_msg_count ,
269: p_data => x_msg_data
269: p_data => x_msg_data
270: );
271:
272: WHEN OTHERS THEN
273: ROLLBACK TO EAM_ASSET_LOG_PUB_SV;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275:
276: IF FND_MSG_PUB.Check_Msg_Level
277: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
288: );
289:
290: END LOG_EVENT;
291:
292: END EAM_ASSET_LOG_PUB;