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_ERROR_MESSAGE_PVT

Line 162: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

158: *********************************************************************/
159:
160: PROCEDURE Insert_Row
161: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
162: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
163: , x_return_Status OUT NOCOPY VARCHAR2
164: )
165: IS
166: l_return_status VARCHAR2(30);

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

349:
350:
351: EXCEPTION
352: WHEN OTHERS THEN
353: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
354: ( p_message_name => NULL
355: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
356: , x_mesg_token_Tbl => x_mesg_token_tbl
357: );

Line 374: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

370: *********************************************************************/
371:
372: PROCEDURE Update_Row
373: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
374: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
375: , x_return_Status OUT NOCOPY VARCHAR2
376: )
377: IS
378: l_return_status VARCHAR2(30) ;

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

483: *********************************************************************/
484:
485: PROCEDURE Delete_Row
486: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
487: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
488: , x_return_Status OUT NOCOPY VARCHAR2
489: )
490: IS
491:

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

540: *********************************************************************/
541:
542: PROCEDURE Perform_Writes
543: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
544: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
545: , x_return_status OUT NOCOPY VARCHAR2
546: )
547: IS
548: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 548: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

544: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
545: , x_return_status OUT NOCOPY VARCHAR2
546: )
547: IS
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