1409: 'strategy.');
1410: End if;
1411: --raise fnd_api.g_exc_error;
1412: IF p_type_code = 1 THEN
1413: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;
1414: ELSIF p_type_code = 2 THEN
1415: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
1416: ELSIF p_type_code = 5 THEN
1417: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1411: --raise fnd_api.g_exc_error;
1412: IF p_type_code = 1 THEN
1413: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;
1414: ELSIF p_type_code = 2 THEN
1415: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
1416: ELSIF p_type_code = 5 THEN
1417: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1418: END IF;
1419: else
1413: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;
1414: ELSIF p_type_code = 2 THEN
1415: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
1416: ELSIF p_type_code = 5 THEN
1417: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1418: END IF;
1419: else
1420: If (g_debug = 1) then
1421: log_event(l_api_name, 'strategy_found',
1424: End if;
1425: -- Calls to populate globals used by Simulation form
1426: wms_engine_pvt.g_business_object_id := l_object_id;
1427: IF p_type_code = 1 THEN
1428: wms_search_order_globals_pvt.g_putaway_business_object_id := l_object_id;
1429: wms_search_order_globals_pvt.g_putaway_strategy_id := l_strategy_id;
1430: wms_search_order_globals_pvt.g_putaway_pk1_value:= l_pk1_value;
1431: wms_search_order_globals_pvt.g_putaway_pk2_value:= l_pk2_value;
1432: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1425: -- Calls to populate globals used by Simulation form
1426: wms_engine_pvt.g_business_object_id := l_object_id;
1427: IF p_type_code = 1 THEN
1428: wms_search_order_globals_pvt.g_putaway_business_object_id := l_object_id;
1429: wms_search_order_globals_pvt.g_putaway_strategy_id := l_strategy_id;
1430: wms_search_order_globals_pvt.g_putaway_pk1_value:= l_pk1_value;
1431: wms_search_order_globals_pvt.g_putaway_pk2_value:= l_pk2_value;
1432: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1433: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1426: wms_engine_pvt.g_business_object_id := l_object_id;
1427: IF p_type_code = 1 THEN
1428: wms_search_order_globals_pvt.g_putaway_business_object_id := l_object_id;
1429: wms_search_order_globals_pvt.g_putaway_strategy_id := l_strategy_id;
1430: wms_search_order_globals_pvt.g_putaway_pk1_value:= l_pk1_value;
1431: wms_search_order_globals_pvt.g_putaway_pk2_value:= l_pk2_value;
1432: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1433: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1434: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1427: IF p_type_code = 1 THEN
1428: wms_search_order_globals_pvt.g_putaway_business_object_id := l_object_id;
1429: wms_search_order_globals_pvt.g_putaway_strategy_id := l_strategy_id;
1430: wms_search_order_globals_pvt.g_putaway_pk1_value:= l_pk1_value;
1431: wms_search_order_globals_pvt.g_putaway_pk2_value:= l_pk2_value;
1432: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1433: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1434: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1435: ELSIF p_type_code = 2 THEN
1428: wms_search_order_globals_pvt.g_putaway_business_object_id := l_object_id;
1429: wms_search_order_globals_pvt.g_putaway_strategy_id := l_strategy_id;
1430: wms_search_order_globals_pvt.g_putaway_pk1_value:= l_pk1_value;
1431: wms_search_order_globals_pvt.g_putaway_pk2_value:= l_pk2_value;
1432: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1433: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1434: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1435: ELSIF p_type_code = 2 THEN
1436: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1429: wms_search_order_globals_pvt.g_putaway_strategy_id := l_strategy_id;
1430: wms_search_order_globals_pvt.g_putaway_pk1_value:= l_pk1_value;
1431: wms_search_order_globals_pvt.g_putaway_pk2_value:= l_pk2_value;
1432: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1433: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1434: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1435: ELSIF p_type_code = 2 THEN
1436: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1437: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1430: wms_search_order_globals_pvt.g_putaway_pk1_value:= l_pk1_value;
1431: wms_search_order_globals_pvt.g_putaway_pk2_value:= l_pk2_value;
1432: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1433: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1434: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1435: ELSIF p_type_code = 2 THEN
1436: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1437: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1438: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1432: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1433: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1434: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1435: ELSIF p_type_code = 2 THEN
1436: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1437: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1438: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1439: wms_search_order_globals_pvt.g_pick_pk2_value:= l_pk2_value;
1440: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1433: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1434: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1435: ELSIF p_type_code = 2 THEN
1436: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1437: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1438: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1439: wms_search_order_globals_pvt.g_pick_pk2_value:= l_pk2_value;
1440: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1441: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1434: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1435: ELSIF p_type_code = 2 THEN
1436: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1437: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1438: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1439: wms_search_order_globals_pvt.g_pick_pk2_value:= l_pk2_value;
1440: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1441: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1442: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1435: ELSIF p_type_code = 2 THEN
1436: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1437: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1438: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1439: wms_search_order_globals_pvt.g_pick_pk2_value:= l_pk2_value;
1440: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1441: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1442: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1443: ELSIF p_type_code = 5 THEN
1436: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1437: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1438: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1439: wms_search_order_globals_pvt.g_pick_pk2_value:= l_pk2_value;
1440: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1441: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1442: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1443: ELSIF p_type_code = 5 THEN
1444: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1437: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1438: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1439: wms_search_order_globals_pvt.g_pick_pk2_value:= l_pk2_value;
1440: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1441: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1442: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1443: ELSIF p_type_code = 5 THEN
1444: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1445: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1438: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1439: wms_search_order_globals_pvt.g_pick_pk2_value:= l_pk2_value;
1440: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1441: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1442: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1443: ELSIF p_type_code = 5 THEN
1444: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1445: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1446: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1440: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1441: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1442: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1443: ELSIF p_type_code = 5 THEN
1444: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1445: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1446: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1447: wms_search_order_globals_pvt.g_costgroup_pk2_value:= l_pk2_value;
1448: wms_search_order_globals_pvt.g_costgroup_pk3_value:= l_pk3_value;
1441: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1442: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1443: ELSIF p_type_code = 5 THEN
1444: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1445: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1446: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1447: wms_search_order_globals_pvt.g_costgroup_pk2_value:= l_pk2_value;
1448: wms_search_order_globals_pvt.g_costgroup_pk3_value:= l_pk3_value;
1449: wms_search_order_globals_pvt.g_costgroup_pk4_value:= l_pk4_value;
1442: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1443: ELSIF p_type_code = 5 THEN
1444: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1445: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1446: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1447: wms_search_order_globals_pvt.g_costgroup_pk2_value:= l_pk2_value;
1448: wms_search_order_globals_pvt.g_costgroup_pk3_value:= l_pk3_value;
1449: wms_search_order_globals_pvt.g_costgroup_pk4_value:= l_pk4_value;
1450: wms_search_order_globals_pvt.g_costgroup_pk5_value:= l_pk5_value;
1443: ELSIF p_type_code = 5 THEN
1444: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1445: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1446: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1447: wms_search_order_globals_pvt.g_costgroup_pk2_value:= l_pk2_value;
1448: wms_search_order_globals_pvt.g_costgroup_pk3_value:= l_pk3_value;
1449: wms_search_order_globals_pvt.g_costgroup_pk4_value:= l_pk4_value;
1450: wms_search_order_globals_pvt.g_costgroup_pk5_value:= l_pk5_value;
1451: END IF;
1444: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1445: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1446: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1447: wms_search_order_globals_pvt.g_costgroup_pk2_value:= l_pk2_value;
1448: wms_search_order_globals_pvt.g_costgroup_pk3_value:= l_pk3_value;
1449: wms_search_order_globals_pvt.g_costgroup_pk4_value:= l_pk4_value;
1450: wms_search_order_globals_pvt.g_costgroup_pk5_value:= l_pk5_value;
1451: END IF;
1452: end if;
1445: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1446: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1447: wms_search_order_globals_pvt.g_costgroup_pk2_value:= l_pk2_value;
1448: wms_search_order_globals_pvt.g_costgroup_pk3_value:= l_pk3_value;
1449: wms_search_order_globals_pvt.g_costgroup_pk4_value:= l_pk4_value;
1450: wms_search_order_globals_pvt.g_costgroup_pk5_value:= l_pk5_value;
1451: END IF;
1452: end if;
1453: x_strategy_id := l_strategy_id;
1446: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1447: wms_search_order_globals_pvt.g_costgroup_pk2_value:= l_pk2_value;
1448: wms_search_order_globals_pvt.g_costgroup_pk3_value:= l_pk3_value;
1449: wms_search_order_globals_pvt.g_costgroup_pk4_value:= l_pk4_value;
1450: wms_search_order_globals_pvt.g_costgroup_pk5_value:= l_pk5_value;
1451: END IF;
1452: end if;
1453: x_strategy_id := l_strategy_id;
1454: -- Clean up variables for dynamically bound input parameters