APPS.AHL_UMP_FORECAST_REQ_PVT dependencies on AHL_LTP_MTL_REQ_PVT

Line 109: l_Route_Mtl_Req_Tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;

105: x_msg_data OUT NOCOPY VARCHAR2,
106: P_applicable_instances_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type
107: ) IS
108:
109: l_Route_Mtl_Req_Tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
110:
111: /* Delete orphan forecast record in AHL_SCHEDULE_MATERIALS table for
112: * deleted unit effectivities
113: * unit effectivities where due date is null after the re-calculation

Line 237: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API :p_route_id :p_mr_route_id : p_item_instance_id : p_requirement_date'

233: fnd_log.string
234: (
235: G_DEBUG_STMT ,
236: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
237: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API :p_route_id :p_mr_route_id : p_item_instance_id : p_requirement_date'
238: || ue_mr_routes_rec.route_id || ':' || ue_mr_routes_rec.mr_route_id || ':' ||P_applicable_instances_tbl(i).csi_item_instance_id
239: || ':' ||ue_mr_routes_rec.due_date
240: );
241: -- log into concurrent log file.

Line 254: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API :p_route_id :p_mr_route_id : '

250: fnd_log.string
251: (
252: G_DEBUG_STMT ,
253: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
254: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API :p_route_id :p_mr_route_id : '
255: || ue_mr_routes_rec.route_id || ':' || ue_mr_routes_rec.mr_route_id
256: );
257: END IF;
258: FOR del_exp_route_rec IN del_exp_route_schedule_mtl_csr(ue_mr_routes_rec.unit_effectivity_id, ue_mr_routes_rec.mr_route_id) LOOP

Line 277: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req

273: OPEN get_visit_id_csr(ue_mr_routes_rec.unit_effectivity_id);
274: FETCH get_visit_id_csr INTO l_visit_id;
275: CLOSE get_visit_id_csr;
276:
277: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req
278: (
279: p_api_version => 1.0,
280: p_init_msg_list => FND_API.G_FALSE,
281: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 302: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error'

298: fnd_log.string
299: (
300: fnd_log.level_error,
301: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
302: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error'
303: );
304: END IF;
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: END IF;

Line 315: 'After call AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API : l_Route_Mtl_Req_Tbl.COUNT : ' || l_Route_Mtl_Req_Tbl.COUNT

311: fnd_log.string
312: (
313: G_DEBUG_STMT,
314: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
315: 'After call AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API : l_Route_Mtl_Req_Tbl.COUNT : ' || l_Route_Mtl_Req_Tbl.COUNT
316: );
317: END IF;
318: FOR j IN l_Route_Mtl_Req_Tbl.FIRST..l_Route_Mtl_Req_Tbl.LAST LOOP
319: OPEN schedule_mtl_exists_csr(ue_mr_routes_rec.unit_effectivity_id,

Line 1073: l_Route_Mtl_Req_Tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;

1069:
1070: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Material_Req';
1071: l_Schedule_Mtl_Req_rec AHL_SCHEDULE_MATERIALS%ROWTYPE;
1072: l_requirement_date DATE;
1073: l_Route_Mtl_Req_Tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
1074: l_visit_id NUMBER;
1075:
1076: l_msg_data VARCHAR2(2000);
1077: l_msg_count NUMBER;

Line 1121: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req

1117: OPEN get_visit_id_csr(p_unit_effectivity_id);
1118: FETCH get_visit_id_csr INTO l_visit_id;
1119: CLOSE get_visit_id_csr;
1120:
1121: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req
1122: (
1123: p_api_version => 1.0,
1124: p_init_msg_list => FND_API.G_FALSE,
1125: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1144: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error');

1140:
1141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1142: IF (fnd_log.level_error >= G_DEBUG_LEVEL) THEN
1143: fnd_log.string(fnd_log.level_error, l_debug_module,
1144: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error');
1145: END IF;
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148:

Line 1154: 'After call AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API : l_Route_Mtl_Req_Tbl.COUNT : ' ||

1150:
1151: IF (l_Route_Mtl_Req_Tbl IS NOT NULL AND l_Route_Mtl_Req_Tbl.COUNT > 0) THEN
1152: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1153: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1154: 'After call AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API : l_Route_Mtl_Req_Tbl.COUNT : ' ||
1155: l_Route_Mtl_Req_Tbl.COUNT);
1156: END IF;
1157:
1158: FOR j IN l_Route_Mtl_Req_Tbl.FIRST..l_Route_Mtl_Req_Tbl.LAST LOOP