APPS.EAM_DIRECT_ITEMS_UTILITY_PVT dependencies on FND_API

Line 48: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

44: , x_Return_status OUT NOCOPY VARCHAR2
45: )
46: IS
47: l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
48: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
49: l_dummy varchar2(10);
50: BEGIN
51:
52: SELECT

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

137: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
138: x_eam_direct_items_rec := l_eam_direct_items_rec;
139:
140: WHEN OTHERS THEN
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: x_eam_direct_items_rec := l_eam_direct_items_rec;
143:
144: END Query_Row;
145:

Line 268: x_return_status := FND_API.G_RET_STS_SUCCESS;

264:
265:
266: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new Direct Items') ; END IF;
267:
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269: -- API is called to set the estimation_status
270: EAM_AutomaticEst.Auto_Reest_of_Cost(
271: p_wip_entity_id =>p_eam_direct_items_rec.wip_entity_id,
272: p_api_name => 'EAM',

Line 293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

289: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
290: , x_mesg_token_Tbl => x_mesg_token_tbl
291: );
292:
293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
294:
295: END Insert_Row;
296:
297: /********************************************************************

Line 381: x_return_status := FND_API.G_RET_STS_SUCCESS;

377: AND ( operation_seq_num = p_eam_direct_items_rec.operation_seq_num
378: OR operation_seq_num = 1 ) /* Added the check operation_seq_num = 1 so that op seq num can be changed if it is 1 */
379: AND direct_item_sequence_id = p_eam_direct_items_rec.direct_item_sequence_id;
380:
381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:
383: -- comparing new quantity with existing quantity
384: IF ( p_eam_direct_items_rec.required_quantity <> l_req_qty )THEN
385:

Line 436: x_return_status := FND_API.G_RET_STS_SUCCESS;

432: AND wip_entity_id = p_eam_direct_items_rec.wip_entity_id
433: AND operation_seq_num = p_eam_direct_items_rec.operation_seq_num
434: AND direct_item_sequence_id = p_eam_direct_items_rec.direct_item_sequence_id;
435:
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:
438: -- API is called to set the estimation_status
439: EAM_AutomaticEst.Auto_Reest_of_Cost(
440: p_wip_entity_id => p_eam_direct_items_rec.wip_entity_id,

Line 474: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

470: , x_return_status OUT NOCOPY VARCHAR2
471: )
472: IS
473: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
474: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
475: BEGIN
476:
477: IF p_eam_direct_items_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
478: THEN