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.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_LTP_MTL_REQ_PVT

Line 481: l_prim_quantity := AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(l_inventory_item_id, l_uom_code, l_requested_quantity);

477: 'Primary Uom Code : '|| l_prim_uom_code || ', Source Uom Code : '|| l_uom_code);
478: END IF;
479:
480: -- yazhou 04Aug2005 Starts
481: l_prim_quantity := AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(l_inventory_item_id, l_uom_code, l_requested_quantity);
482:
483: -- Required to check the UOM Conversion exists in mtl_units_of_measure
484: IF l_prim_quantity IS NULL THEN
485: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );

Line 1194: l_route_mtl_req_tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;

1190: l_route_id NUMBER;
1191: l_instance_id NUMBER;
1192: l_requirement_date DATE;
1193: l_visit_tasks_rec Get_visit_tasks_cur%ROWTYPE;
1194: l_route_mtl_req_tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
1195:
1196: BEGIN
1197:
1198: IF (l_log_procedure >= l_log_current_level)THEN

Line 1316: 'Before calling ahl ltp mtl req pvt.Get Route Mtl Req'

1312: fnd_log.string
1313: (
1314: l_log_procedure,
1315: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1316: 'Before calling ahl ltp mtl req pvt.Get Route Mtl Req'
1317: );
1318:
1319: END IF;
1320:

Line 1321: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req

1317: );
1318:
1319: END IF;
1320:
1321: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req
1322: (p_api_version => l_api_version,
1323: p_init_msg_list => p_init_msg_list,
1324: p_validation_level => p_validation_level,
1325: x_return_status => l_return_status,

Line 1342: 'After calling ahl ltp mtl req pvt.Get Route Mtl Req, Return Status : '|| l_return_status

1338: fnd_log.string
1339: (
1340: l_log_procedure,
1341: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
1342: 'After calling ahl ltp mtl req pvt.Get Route Mtl Req, Return Status : '|| l_return_status
1343: );
1344: END IF;
1345: -- Check Error Message stack.
1346: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1652: l_route_mtl_req_tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;

1648: l_return_status VARCHAR2(1);
1649: l_msg_count NUMBER;
1650: j NUMBER := 0;
1651: l_visit_tasks_rec Get_visit_tasks_cur%ROWTYPE;
1652: l_route_mtl_req_tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
1653: l_Planned_Items_Rec Planned_Items_cur%ROWTYPE;
1654: l_requirement_date DATE;
1655: l_Visit_Task_Route_Tbl Visit_Task_Route_Tbl_Type;
1656: i_x NUMBER;

Line 1786: 'Before calling AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req');

1782: END IF;
1783:
1784: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1785: fnd_log.string(fnd_log.level_statement, L_DEBUG_KEY,
1786: 'Before calling AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req');
1787: END IF;
1788:
1789: --Call to get items
1790: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req

Line 1790: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req

1786: 'Before calling AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req');
1787: END IF;
1788:
1789: --Call to get items
1790: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req
1791: (p_api_version => l_api_version,
1792: p_init_msg_list => p_init_msg_list,
1793: p_validation_level => p_validation_level,
1794: x_return_status => l_return_status,

Line 1807: 'After calling AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req, Return Status: ' || l_return_status);

1803: p_request_type => 'PLANNED',
1804: x_route_mtl_req_tbl => l_route_mtl_req_tbl);
1805: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1806: fnd_log.string(fnd_log.level_statement, L_DEBUG_KEY,
1807: 'After calling AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req, Return Status: ' || l_return_status);
1808: END IF;
1809: -- Check Error Message stack.
1810: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1811: l_msg_count := FND_MSG_PUB.count_msg;

Line 1819: 'After Calling AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req, l_route_mtl_req_tbl.COUNT = ' || l_route_mtl_req_tbl.COUNT);

1815: END IF;
1816:
1817: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1818: fnd_log.string(fnd_log.level_statement, L_DEBUG_KEY,
1819: 'After Calling AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req, l_route_mtl_req_tbl.COUNT = ' || l_route_mtl_req_tbl.COUNT);
1820: END IF;
1821:
1822: IF l_route_mtl_req_tbl.COUNT > 0 THEN
1823: FOR j IN l_route_mtl_req_tbl.FIRST..l_route_mtl_req_tbl.LAST

Line 3702: l_prim_quantity := AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(l_nrp_mat_req_tbl(i).INVENTORY_ITEM_ID, l_nrp_mat_req_tbl(i).UOM_CODE, l_nrp_mat_req_tbl(i).QUANTITY);

3698: FETCH get_stage_task INTO l_stage_task_rec;
3699: CLOSE get_stage_task;
3700:
3701: --For the required quantity in l_req_material_tbl, get the quantity in primary UOM of the item
3702: l_prim_quantity := AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(l_nrp_mat_req_tbl(i).INVENTORY_ITEM_ID, l_nrp_mat_req_tbl(i).UOM_CODE, l_nrp_mat_req_tbl(i).QUANTITY);
3703: IF (l_log_statement >= l_log_current_level)THEN
3704: fnd_log.string (l_log_statement,
3705: l_debug_key,
3706: 'Inside the loop for NR materials, Visit_id: '|| p_visit_id ||' ,visit_task_id: '|| l_stage_task_rec.visit_task_id ||' ,INVENTORY_ITEM_ID: '

Line 4146: l_prim_req_quantity := AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(l_nrp_mat_req_tbl(i).INVENTORY_ITEM_ID, l_nrp_mat_req_tbl(i).UOM_CODE, l_nrp_mat_req_tbl(i).QUANTITY);

4142:
4143: OPEN get_scheduled_mat_detls (l_stage_task_rec.visit_task_id, l_nrp_mat_req_tbl(i).INVENTORY_ITEM_ID);
4144: FETCH get_scheduled_mat_detls INTO l_scheduled_material_id, l_requested_quantity, l_prim_sch_quantity, l_uom_code;
4145: IF get_scheduled_mat_detls%FOUND THEN
4146: l_prim_req_quantity := AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(l_nrp_mat_req_tbl(i).INVENTORY_ITEM_ID, l_nrp_mat_req_tbl(i).UOM_CODE, l_nrp_mat_req_tbl(i).QUANTITY);
4147: l_nr_profile_qty := l_prim_req_quantity;
4148:
4149: IF l_prim_req_quantity > l_prim_sch_quantity THEN
4150: l_prim_sch_quantity := 0;