DBA Data[Home] [Help]

APPS.EAM_DIRECT_ITEMS_UTILITY_PVT dependencies on EAM_PROCESS_WO_PVT

Line 132: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;

128: AND wedi.organization_id = p_organization_id
129: AND wedi.operation_seq_num = p_operation_seq_num
130: AND wedi.direct_item_sequence_id = p_direct_item_sequence_id;
131:
132: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;
133: x_eam_direct_items_rec := l_eam_direct_items_rec;
134:
135: EXCEPTION
136: WHEN NO_DATA_FOUND THEN

Line 137: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;

133: x_eam_direct_items_rec := l_eam_direct_items_rec;
134:
135: EXCEPTION
136: WHEN NO_DATA_FOUND THEN
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;

Line 168: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Direct Items rec for ' || p_eam_direct_items_rec.direct_item_sequence_id); END IF;

164: l_msg_data VARCHAR2(2000) := '';
165:
166: BEGIN
167:
168: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Direct Items rec for ' || p_eam_direct_items_rec.direct_item_sequence_id); END IF;
169:
170: INSERT INTO WIP_EAM_DIRECT_ITEMS
171: (
172: DESCRIPTION

Line 266: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new Direct Items') ; END IF;

262: , p_eam_direct_items_rec.program_id
263: , SYSDATE);
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(

Line 319: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Direct Items '|| p_eam_direct_items_rec.direct_item_sequence_id); END IF;

315: l_req_qty NUMBER := 0;
316:
317: BEGIN
318:
319: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Direct Items '|| p_eam_direct_items_rec.direct_item_sequence_id); END IF;
320:
321: SELECT required_quantity
322: INTO l_req_qty
323: FROM WIP_EAM_DIRECT_ITEMS

Line 428: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Direct Items '|| p_eam_direct_items_rec.direct_item_sequence_id); END IF;

424: l_msg_count NUMBER := 0;
425: l_msg_data VARCHAR2(2000) := '';
426: BEGIN
427:
428: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Direct Items '|| p_eam_direct_items_rec.direct_item_sequence_id); END IF;
429:
430: DELETE FROM WIP_EAM_DIRECT_ITEMS
431: WHERE organization_id = p_eam_direct_items_rec.organization_id
432: AND wip_entity_id = p_eam_direct_items_rec.wip_entity_id

Line 477: IF p_eam_direct_items_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE

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
479: Insert_Row
480: ( p_eam_direct_items_rec => p_eam_direct_items_rec
481: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 484: ELSIF p_eam_direct_items_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE

480: ( p_eam_direct_items_rec => p_eam_direct_items_rec
481: , x_mesg_token_Tbl => l_mesg_token_tbl
482: , x_return_Status => l_return_status
483: );
484: ELSIF p_eam_direct_items_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
485: THEN
486: Update_Row
487: ( p_eam_direct_items_rec => p_eam_direct_items_rec
488: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 492: ELSIF p_eam_direct_items_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE

488: , x_mesg_token_Tbl => l_mesg_token_tbl
489: , x_return_Status => l_return_status
490: );
491:
492: ELSIF p_eam_direct_items_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE
493: THEN
494: Delete_Row
495: ( p_eam_direct_items_rec => p_eam_direct_items_rec
496: , x_mesg_token_Tbl => l_mesg_token_tbl