eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_MAT_REQ_UTILITY_PVT dependencies on EAM_PROCESS_WO_PVT

Line 136: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;

132: AND wro.organization_id = p_organization_id
133: AND wro.operation_seq_num = p_operation_seq_num
134: AND wro.inventory_item_id = p_inventory_item_id;
135:
136: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;
137: x_eam_mat_req_rec := l_eam_mat_req_rec;
138:
139: EXCEPTION
140: WHEN NO_DATA_FOUND THEN

Line 141: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;

137: x_eam_mat_req_rec := l_eam_mat_req_rec;
138:
139: EXCEPTION
140: WHEN NO_DATA_FOUND THEN
141: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
142: x_eam_mat_req_rec := l_eam_mat_req_rec;
143:
144: WHEN OTHERS THEN
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 177: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Material Requirements rec for ' || p_eam_mat_req_rec.inventory_item_id); END IF;

173: x_msg_data VARCHAR2(2000);
174:
175: BEGIN
176:
177: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Material Requirements rec for ' || p_eam_mat_req_rec.inventory_item_id); END IF;
178: --Bug3946253:Remove round() for the date_required
179:
180:
181: INSERT INTO WIP_REQUIREMENT_OPERATIONS

Line 327: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new Material Requirements') ; END IF;

323:
324: ;--p_eam_mat_req_rec.program_update_date);
325:
326:
327: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new Material Requirements') ; END IF;
328:
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330:
331: -- bug number 2251186

Line 386: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Material Requirements '|| p_eam_mat_req_rec.inventory_item_id); END IF;

382: l_api_version CONSTANT NUMBER:=1;
383: x_shortage_exists VARCHAR2(1);
384: BEGIN
385:
386: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Material Requirements '|| p_eam_mat_req_rec.inventory_item_id); END IF;
387:
388:
389:
390: SELECT required_quantity

Line 501: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Material Requirements '|| p_eam_mat_req_rec.inventory_item_id); END IF;

497: x_shortage_exists VARCHAR2(1);
498:
499: BEGIN
500:
501: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Material Requirements '|| p_eam_mat_req_rec.inventory_item_id); END IF;
502:
503: DELETE FROM WIP_REQUIREMENT_OPERATIONS
504: WHERE organization_id = p_eam_mat_req_rec.organization_id
505: AND wip_entity_id = p_eam_mat_req_rec.wip_entity_id

Line 552: IF p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE

548: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
549: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
550: BEGIN
551:
552: IF p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
553: THEN
554: Insert_Row
555: ( p_eam_mat_req_rec => p_eam_mat_req_rec
556: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 559: ELSIF p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE

555: ( p_eam_mat_req_rec => p_eam_mat_req_rec
556: , x_mesg_token_Tbl => l_mesg_token_tbl
557: , x_return_Status => l_return_status
558: );
559: ELSIF p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
560: THEN
561: Update_Row
562: ( p_eam_mat_req_rec => p_eam_mat_req_rec
563: , x_mesg_token_Tbl => l_mesg_token_tbl

Line 567: ELSIF p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE

563: , x_mesg_token_Tbl => l_mesg_token_tbl
564: , x_return_Status => l_return_status
565: );
566:
567: ELSIF p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE
568: THEN
569: Delete_Row
570: ( p_eam_mat_req_rec => p_eam_mat_req_rec
571: , x_mesg_token_Tbl => l_mesg_token_tbl