DBA Data[Home] [Help]

APPS.EAM_DIRECT_ITEMS_UTILITY_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 158: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

154: *********************************************************************/
155:
156: PROCEDURE Insert_Row
157: ( p_eam_direct_items_rec IN EAM_PROCESS_WO_PUB.eam_direct_items_rec_type
158: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
159: , x_return_Status OUT NOCOPY VARCHAR2
160: )
161: IS
162: l_return_status VARCHAR2(30) := '';

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 287: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

283:
284:
285: EXCEPTION
286: WHEN OTHERS THEN
287: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
288: ( p_message_name => NULL
289: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
290: , x_mesg_token_Tbl => x_mesg_token_tbl
291: );

Line 308: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

304: *********************************************************************/
305:
306: PROCEDURE Update_Row
307: ( p_eam_direct_items_rec IN EAM_PROCESS_WO_PUB.eam_direct_items_rec_type
308: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
309: , x_return_Status OUT NOCOPY VARCHAR2
310: )
311: IS
312: l_return_status VARCHAR2(30) := '';

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 419: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

415: *********************************************************************/
416:
417: PROCEDURE Delete_Row
418: ( p_eam_direct_items_rec IN EAM_PROCESS_WO_PUB.eam_direct_items_rec_type
419: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
420: , x_return_Status OUT NOCOPY VARCHAR2
421: )
422: IS
423: l_return_status VARCHAR2(30) := '';

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 469: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

465: *********************************************************************/
466:
467: PROCEDURE Perform_Writes
468: ( p_eam_direct_items_rec IN EAM_PROCESS_WO_PUB.eam_direct_items_rec_type
469: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
470: , x_return_status OUT NOCOPY VARCHAR2
471: )
472: IS
473: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 473: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

469: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
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