APPS.AHL_UMP_BOM_PVT dependencies on AHL_LTP_MTL_REQ_PVT

Line 508: l_Route_Mtl_Req_Tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;

504: l_count NUMBER;
505: l_err_msg VARCHAR2(2000);
506: l_msg_index_out NUMBER;
507:
508: l_Route_Mtl_Req_Tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
509:
510: BEGIN
511:
512: G_DEBUG_LINE_NUM := l_debug_module||': '||4000;

Line 559: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Calling AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req');

555: l_requirement_date := p_due_date;
556: END IF;
557:
558: -- Call API
559: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Calling AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req');
560: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Params passed - p_route_id:'||p_route_id_tbl(k)||
561: ' p_mr_route_id:'||p_mr_route_tbl(k)||
562: ' p_item_instance_id:'||p_csi_item_instance_id||
563: ' p_requirement_date:'||l_requirement_date);

Line 566: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req (p_api_version => 1.0,

562: ' p_item_instance_id:'||p_csi_item_instance_id||
563: ' p_requirement_date:'||l_requirement_date);
564: G_DEBUG_LINE_NUM := l_debug_module||': '||4050;
565: BEGIN
566: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req (p_api_version => 1.0,
567: p_init_msg_list => FND_API.G_FALSE,
568: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
569: x_return_status => l_return_status,
570: x_msg_count => l_msg_count,

Line 583: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Exception in AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req -'||SQLERRM);

579: EXCEPTION
580: WHEN OTHERS
581: THEN
582: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' ****************************** Exception ******************************');
583: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Exception in AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req -'||SQLERRM);
584: g_ret_status := 2;
585: RAISE;
586: END;
587: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 590: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' ****************************** AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error ****************************** ');

586: END;
587: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
588: THEN
589:
590: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' ****************************** AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error ****************************** ');
591: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' message data = '||l_msg_data);
592: l_msg_count := Fnd_Msg_Pub.count_msg;
593: IF (l_msg_count > 0) THEN
594:

Line 610: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' After AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req, l_Route_Mtl_Req_Tbl.COUNT = '||l_Route_Mtl_Req_Tbl.COUNT);

606: RAISE FND_API.G_EXC_ERROR;-- Raise Error
607: END IF;
608:
609: --Log
610: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' After AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req, l_Route_Mtl_Req_Tbl.COUNT = '||l_Route_Mtl_Req_Tbl.COUNT);
611: G_DEBUG_LINE_NUM := l_debug_module||': '||4060;
612: -- Process the result if no error is raised earlier
613: IF (l_Route_Mtl_Req_Tbl IS NOT NULL AND l_Route_Mtl_Req_Tbl.COUNT > 0)
614: THEN