1447: 'strategy.');
1448: End if;
1449: --raise fnd_api.g_exc_error;
1450: IF p_type_code = 1 THEN
1451: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;
1452: ELSIF p_type_code = 2 THEN
1453: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
1454: ELSIF p_type_code = 5 THEN
1455: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1449: --raise fnd_api.g_exc_error;
1450: IF p_type_code = 1 THEN
1451: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;
1452: ELSIF p_type_code = 2 THEN
1453: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
1454: ELSIF p_type_code = 5 THEN
1455: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1456: END IF;
1457: else
1451: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;
1452: ELSIF p_type_code = 2 THEN
1453: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
1454: ELSIF p_type_code = 5 THEN
1455: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1456: END IF;
1457: else
1458: If (g_debug = 1) then
1459: log_event(l_api_name, 'strategy_found',
1462: End if;
1463: -- Calls to populate globals used by Simulation form
1464: wms_engine_pvt.g_business_object_id := l_object_id;
1465: IF p_type_code = 1 THEN
1466: wms_search_order_globals_pvt.g_putaway_business_object_id := l_object_id;
1467: wms_search_order_globals_pvt.g_putaway_strategy_id := l_strategy_id;
1468: wms_search_order_globals_pvt.g_putaway_pk1_value:= l_pk1_value;
1469: wms_search_order_globals_pvt.g_putaway_pk2_value:= l_pk2_value;
1470: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1463: -- Calls to populate globals used by Simulation form
1464: wms_engine_pvt.g_business_object_id := l_object_id;
1465: IF p_type_code = 1 THEN
1466: wms_search_order_globals_pvt.g_putaway_business_object_id := l_object_id;
1467: wms_search_order_globals_pvt.g_putaway_strategy_id := l_strategy_id;
1468: wms_search_order_globals_pvt.g_putaway_pk1_value:= l_pk1_value;
1469: wms_search_order_globals_pvt.g_putaway_pk2_value:= l_pk2_value;
1470: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1471: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1464: wms_engine_pvt.g_business_object_id := l_object_id;
1465: IF p_type_code = 1 THEN
1466: wms_search_order_globals_pvt.g_putaway_business_object_id := l_object_id;
1467: wms_search_order_globals_pvt.g_putaway_strategy_id := l_strategy_id;
1468: wms_search_order_globals_pvt.g_putaway_pk1_value:= l_pk1_value;
1469: wms_search_order_globals_pvt.g_putaway_pk2_value:= l_pk2_value;
1470: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1471: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1472: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1465: IF p_type_code = 1 THEN
1466: wms_search_order_globals_pvt.g_putaway_business_object_id := l_object_id;
1467: wms_search_order_globals_pvt.g_putaway_strategy_id := l_strategy_id;
1468: wms_search_order_globals_pvt.g_putaway_pk1_value:= l_pk1_value;
1469: wms_search_order_globals_pvt.g_putaway_pk2_value:= l_pk2_value;
1470: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1471: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1472: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1473: ELSIF p_type_code = 2 THEN
1466: wms_search_order_globals_pvt.g_putaway_business_object_id := l_object_id;
1467: wms_search_order_globals_pvt.g_putaway_strategy_id := l_strategy_id;
1468: wms_search_order_globals_pvt.g_putaway_pk1_value:= l_pk1_value;
1469: wms_search_order_globals_pvt.g_putaway_pk2_value:= l_pk2_value;
1470: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1471: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1472: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1473: ELSIF p_type_code = 2 THEN
1474: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1467: wms_search_order_globals_pvt.g_putaway_strategy_id := l_strategy_id;
1468: wms_search_order_globals_pvt.g_putaway_pk1_value:= l_pk1_value;
1469: wms_search_order_globals_pvt.g_putaway_pk2_value:= l_pk2_value;
1470: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1471: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1472: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1473: ELSIF p_type_code = 2 THEN
1474: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1475: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1468: wms_search_order_globals_pvt.g_putaway_pk1_value:= l_pk1_value;
1469: wms_search_order_globals_pvt.g_putaway_pk2_value:= l_pk2_value;
1470: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1471: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1472: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1473: ELSIF p_type_code = 2 THEN
1474: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1475: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1476: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1470: wms_search_order_globals_pvt.g_putaway_pk3_value:= l_pk3_value;
1471: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1472: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1473: ELSIF p_type_code = 2 THEN
1474: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1475: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1476: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1477: wms_search_order_globals_pvt.g_pick_pk2_value:= l_pk2_value;
1478: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1471: wms_search_order_globals_pvt.g_putaway_pk4_value:= l_pk4_value;
1472: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1473: ELSIF p_type_code = 2 THEN
1474: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1475: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1476: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1477: wms_search_order_globals_pvt.g_pick_pk2_value:= l_pk2_value;
1478: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1479: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1472: wms_search_order_globals_pvt.g_putaway_pk5_value:= l_pk5_value;
1473: ELSIF p_type_code = 2 THEN
1474: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1475: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1476: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1477: wms_search_order_globals_pvt.g_pick_pk2_value:= l_pk2_value;
1478: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1479: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1480: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1473: ELSIF p_type_code = 2 THEN
1474: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1475: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1476: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1477: wms_search_order_globals_pvt.g_pick_pk2_value:= l_pk2_value;
1478: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1479: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1480: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1481: ELSIF p_type_code = 5 THEN
1474: wms_search_order_globals_pvt.g_pick_business_object_id := l_object_id;
1475: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1476: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1477: wms_search_order_globals_pvt.g_pick_pk2_value:= l_pk2_value;
1478: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1479: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1480: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1481: ELSIF p_type_code = 5 THEN
1482: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1475: wms_search_order_globals_pvt.g_pick_strategy_id := l_strategy_id;
1476: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1477: wms_search_order_globals_pvt.g_pick_pk2_value:= l_pk2_value;
1478: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1479: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1480: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1481: ELSIF p_type_code = 5 THEN
1482: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1483: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1476: wms_search_order_globals_pvt.g_pick_pk1_value:= l_pk1_value;
1477: wms_search_order_globals_pvt.g_pick_pk2_value:= l_pk2_value;
1478: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1479: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1480: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1481: ELSIF p_type_code = 5 THEN
1482: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1483: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1484: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1478: wms_search_order_globals_pvt.g_pick_pk3_value:= l_pk3_value;
1479: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1480: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1481: ELSIF p_type_code = 5 THEN
1482: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1483: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1484: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1485: wms_search_order_globals_pvt.g_costgroup_pk2_value:= l_pk2_value;
1486: wms_search_order_globals_pvt.g_costgroup_pk3_value:= l_pk3_value;
1479: wms_search_order_globals_pvt.g_pick_pk4_value:= l_pk4_value;
1480: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1481: ELSIF p_type_code = 5 THEN
1482: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1483: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1484: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1485: wms_search_order_globals_pvt.g_costgroup_pk2_value:= l_pk2_value;
1486: wms_search_order_globals_pvt.g_costgroup_pk3_value:= l_pk3_value;
1487: wms_search_order_globals_pvt.g_costgroup_pk4_value:= l_pk4_value;
1480: wms_search_order_globals_pvt.g_pick_pk5_value:= l_pk5_value;
1481: ELSIF p_type_code = 5 THEN
1482: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1483: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1484: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1485: wms_search_order_globals_pvt.g_costgroup_pk2_value:= l_pk2_value;
1486: wms_search_order_globals_pvt.g_costgroup_pk3_value:= l_pk3_value;
1487: wms_search_order_globals_pvt.g_costgroup_pk4_value:= l_pk4_value;
1488: wms_search_order_globals_pvt.g_costgroup_pk5_value:= l_pk5_value;
1481: ELSIF p_type_code = 5 THEN
1482: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1483: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1484: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1485: wms_search_order_globals_pvt.g_costgroup_pk2_value:= l_pk2_value;
1486: wms_search_order_globals_pvt.g_costgroup_pk3_value:= l_pk3_value;
1487: wms_search_order_globals_pvt.g_costgroup_pk4_value:= l_pk4_value;
1488: wms_search_order_globals_pvt.g_costgroup_pk5_value:= l_pk5_value;
1489: END IF;
1482: wms_search_order_globals_pvt.g_costgroup_business_object_id := l_object_id;
1483: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1484: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1485: wms_search_order_globals_pvt.g_costgroup_pk2_value:= l_pk2_value;
1486: wms_search_order_globals_pvt.g_costgroup_pk3_value:= l_pk3_value;
1487: wms_search_order_globals_pvt.g_costgroup_pk4_value:= l_pk4_value;
1488: wms_search_order_globals_pvt.g_costgroup_pk5_value:= l_pk5_value;
1489: END IF;
1490: end if;
1483: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_strategy_id;
1484: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1485: wms_search_order_globals_pvt.g_costgroup_pk2_value:= l_pk2_value;
1486: wms_search_order_globals_pvt.g_costgroup_pk3_value:= l_pk3_value;
1487: wms_search_order_globals_pvt.g_costgroup_pk4_value:= l_pk4_value;
1488: wms_search_order_globals_pvt.g_costgroup_pk5_value:= l_pk5_value;
1489: END IF;
1490: end if;
1491: x_strategy_id := l_strategy_id;
1484: wms_search_order_globals_pvt.g_costgroup_pk1_value:= l_pk1_value;
1485: wms_search_order_globals_pvt.g_costgroup_pk2_value:= l_pk2_value;
1486: wms_search_order_globals_pvt.g_costgroup_pk3_value:= l_pk3_value;
1487: wms_search_order_globals_pvt.g_costgroup_pk4_value:= l_pk4_value;
1488: wms_search_order_globals_pvt.g_costgroup_pk5_value:= l_pk5_value;
1489: END IF;
1490: end if;
1491: x_strategy_id := l_strategy_id;
1492: -- Clean up variables for dynamically bound input parameters