[Home] [Help]
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
225: fnd_log.string
226: (
227: G_DEBUG_STMT ,
228: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
229: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API :p_route_id :p_mr_route_id : p_item_instance_id : p_requirement_date'
230: || ue_mr_routes_rec.route_id || ':' || ue_mr_routes_rec.mr_route_id || ':' ||P_applicable_instances_tbl(i).csi_item_instance_id
231: || ':' ||ue_mr_routes_rec.due_date
232: );
233: -- log into concurrent log file.
242: fnd_log.string
243: (
244: G_DEBUG_STMT ,
245: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
246: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API :p_route_id :p_mr_route_id : '
247: || ue_mr_routes_rec.route_id || ':' || ue_mr_routes_rec.mr_route_id
248: );
249: END IF;
250: 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
260:
261: IF( NVL(l_previous_route_id,-1) <> ue_mr_routes_rec.route_id OR
262: TRUNC(NVL(l_previous_req_date,l_requirement_date - 1)) <> TRUNC(l_requirement_date))THEN
263:
264: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req
265: (
266: p_api_version => 1.0,
267: p_init_msg_list => FND_API.G_FALSE,
268: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
284: fnd_log.string
285: (
286: fnd_log.level_error,
287: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
288: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error'
289: );
290: END IF;
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;
297: fnd_log.string
298: (
299: G_DEBUG_STMT,
300: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
301: 'After call AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API : l_Route_Mtl_Req_Tbl.COUNT : ' || l_Route_Mtl_Req_Tbl.COUNT
302: );
303: END IF;
304: FOR j IN l_Route_Mtl_Req_Tbl.FIRST..l_Route_Mtl_Req_Tbl.LAST LOOP
305: OPEN schedule_mtl_exists_csr(ue_mr_routes_rec.unit_effectivity_id,
1039:
1040: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Material_Req';
1041: l_Schedule_Mtl_Req_rec AHL_SCHEDULE_MATERIALS%ROWTYPE;
1042: l_requirement_date DATE;
1043: l_Route_Mtl_Req_Tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
1044:
1045: l_msg_data VARCHAR2(2000);
1046: l_msg_count NUMBER;
1047: l_return_status VARCHAR2(1);
1081:
1082: -- IF (NVL(G_previous_route_id,-1) <> p_route_id OR
1083: -- TRUNC(NVL(G_previous_req_date,l_requirement_date - 1)) <> TRUNC(l_requirement_date))THEN
1084:
1085: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req
1086: (
1087: p_api_version => 1.0,
1088: p_init_msg_list => FND_API.G_FALSE,
1089: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1103:
1104: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1105: IF (fnd_log.level_error >= G_DEBUG_LEVEL) THEN
1106: fnd_log.string(fnd_log.level_error, l_debug_module,
1107: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error');
1108: END IF;
1109: RAISE FND_API.G_EXC_ERROR;
1110: END IF;
1111:
1113:
1114: IF (l_Route_Mtl_Req_Tbl IS NOT NULL AND l_Route_Mtl_Req_Tbl.COUNT > 0) THEN
1115: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1116: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1117: 'After call AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API : l_Route_Mtl_Req_Tbl.COUNT : ' ||
1118: l_Route_Mtl_Req_Tbl.COUNT);
1119: END IF;
1120:
1121: FOR j IN l_Route_Mtl_Req_Tbl.FIRST..l_Route_Mtl_Req_Tbl.LAST LOOP