911: x_return_status := fnd_api.g_ret_sts_success;
912:
913: --- setting global variables used by Rules simulator and trace execution forms
914: IF p_type_code = 1 THEN
915: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;
916: wms_search_order_globals_pvt.g_putaway_seq_num := -999;
917: ELSIF p_type_code = 2 THEN
918: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
919: wms_search_order_globals_pvt.g_pick_seq_num := -999;
912:
913: --- setting global variables used by Rules simulator and trace execution forms
914: IF p_type_code = 1 THEN
915: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;
916: wms_search_order_globals_pvt.g_putaway_seq_num := -999;
917: ELSIF p_type_code = 2 THEN
918: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
919: wms_search_order_globals_pvt.g_pick_seq_num := -999;
920: ELSIF p_type_code = 5 THEN
914: IF p_type_code = 1 THEN
915: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;
916: wms_search_order_globals_pvt.g_putaway_seq_num := -999;
917: ELSIF p_type_code = 2 THEN
918: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
919: wms_search_order_globals_pvt.g_pick_seq_num := -999;
920: ELSIF p_type_code = 5 THEN
921: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
922: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;
915: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;
916: wms_search_order_globals_pvt.g_putaway_seq_num := -999;
917: ELSIF p_type_code = 2 THEN
918: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
919: wms_search_order_globals_pvt.g_pick_seq_num := -999;
920: ELSIF p_type_code = 5 THEN
921: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
922: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;
923: END IF; --- end of globol variables section
917: ELSIF p_type_code = 2 THEN
918: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
919: wms_search_order_globals_pvt.g_pick_seq_num := -999;
920: ELSIF p_type_code = 5 THEN
921: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
922: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;
923: END IF; --- end of globol variables section
924: End if;
925:
918: wms_search_order_globals_pvt.g_pick_strategy_id := -999;
919: wms_search_order_globals_pvt.g_pick_seq_num := -999;
920: ELSIF p_type_code = 5 THEN
921: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
922: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;
923: END IF; --- end of globol variables section
924: End if;
925:
926: If (cur_stg_selection%FOUND) Then
937: --- setting global variables used by Rules simulator and trace execution forms
938:
939: IF l_return_type_code = 'S' THEN
940: IF p_type_code = 1 THEN
941: wms_search_order_globals_pvt.g_putaway_strategy_id := l_return_type_id;
942: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;
943:
944: ELSIF p_type_code = 2 THEN
945: wms_search_order_globals_pvt.g_pick_strategy_id := l_return_type_id;
938:
939: IF l_return_type_code = 'S' THEN
940: IF p_type_code = 1 THEN
941: wms_search_order_globals_pvt.g_putaway_strategy_id := l_return_type_id;
942: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;
943:
944: ELSIF p_type_code = 2 THEN
945: wms_search_order_globals_pvt.g_pick_strategy_id := l_return_type_id;
946: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
941: wms_search_order_globals_pvt.g_putaway_strategy_id := l_return_type_id;
942: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;
943:
944: ELSIF p_type_code = 2 THEN
945: wms_search_order_globals_pvt.g_pick_strategy_id := l_return_type_id;
946: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
947:
948: ELSIF p_type_code = 5 THEN
949: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;
942: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;
943:
944: ELSIF p_type_code = 2 THEN
945: wms_search_order_globals_pvt.g_pick_strategy_id := l_return_type_id;
946: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
947:
948: ELSIF p_type_code = 5 THEN
949: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;
950: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
945: wms_search_order_globals_pvt.g_pick_strategy_id := l_return_type_id;
946: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
947:
948: ELSIF p_type_code = 5 THEN
949: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;
950: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
951: ELSIF p_type_code = 10 THEN
952: NULL;
953: ELSIF p_type_code = 11 THEN
946: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
947:
948: ELSIF p_type_code = 5 THEN
949: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;
950: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
951: ELSIF p_type_code = 10 THEN
952: NULL;
953: ELSIF p_type_code = 11 THEN
954: NULL;
955: END IF;
956:
957: ELSIF l_return_type_code = 'R' THEN
958: IF p_type_code = 1 THEN
959: wms_search_order_globals_pvt.g_putaway_rule_id := l_return_type_id;
960: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;
961:
962: ELSIF p_type_code = 2 THEN
963: wms_search_order_globals_pvt.g_pick_rule_id := l_return_type_id;
956:
957: ELSIF l_return_type_code = 'R' THEN
958: IF p_type_code = 1 THEN
959: wms_search_order_globals_pvt.g_putaway_rule_id := l_return_type_id;
960: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;
961:
962: ELSIF p_type_code = 2 THEN
963: wms_search_order_globals_pvt.g_pick_rule_id := l_return_type_id;
964: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
959: wms_search_order_globals_pvt.g_putaway_rule_id := l_return_type_id;
960: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;
961:
962: ELSIF p_type_code = 2 THEN
963: wms_search_order_globals_pvt.g_pick_rule_id := l_return_type_id;
964: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
965:
966: ELSIF p_type_code = 5 THEN
967: wms_search_order_globals_pvt.g_costgroup_rule_id := l_return_type_id;
960: wms_search_order_globals_pvt.g_putaway_seq_num := l_sequence_number;
961:
962: ELSIF p_type_code = 2 THEN
963: wms_search_order_globals_pvt.g_pick_rule_id := l_return_type_id;
964: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
965:
966: ELSIF p_type_code = 5 THEN
967: wms_search_order_globals_pvt.g_costgroup_rule_id := l_return_type_id;
968: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
963: wms_search_order_globals_pvt.g_pick_rule_id := l_return_type_id;
964: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
965:
966: ELSIF p_type_code = 5 THEN
967: wms_search_order_globals_pvt.g_costgroup_rule_id := l_return_type_id;
968: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
969: ELSIF p_type_code = 10 THEN
970: NULL;
971: ELSIF p_type_code = 11 THEN
964: wms_search_order_globals_pvt.g_pick_seq_num := l_sequence_number;
965:
966: ELSIF p_type_code = 5 THEN
967: wms_search_order_globals_pvt.g_costgroup_rule_id := l_return_type_id;
968: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
969: ELSIF p_type_code = 10 THEN
970: NULL;
971: ELSIF p_type_code = 11 THEN
972: NULL;
973: END IF;
974: ELSIF l_return_type_code = 'V' THEN
975:
976: IF p_type_code = 5 THEN
977: wms_search_order_globals_pvt.g_costgroup_id := l_return_type_id;
978: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
979: ELSIF p_type_code = 10 THEN
980: NULL;
981: ELSIF p_type_code = 11 THEN
974: ELSIF l_return_type_code = 'V' THEN
975:
976: IF p_type_code = 5 THEN
977: wms_search_order_globals_pvt.g_costgroup_id := l_return_type_id;
978: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
979: ELSIF p_type_code = 10 THEN
980: NULL;
981: ELSIF p_type_code = 11 THEN
982: NULL;
1329: l_return_type_id := NULL;
1330: l_sequence_number := NULL;
1331:
1332: IF p_type_code = 5 THEN
1333: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1334: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;
1335: END IF;
1336: x_return_status := fnd_api.g_ret_sts_success;
1337: End if;
1330: l_sequence_number := NULL;
1331:
1332: IF p_type_code = 5 THEN
1333: wms_search_order_globals_pvt.g_costgroup_strategy_id := -999;
1334: wms_search_order_globals_pvt.g_costgroup_seq_num := -999;
1335: END IF;
1336: x_return_status := fnd_api.g_ret_sts_success;
1337: End if;
1338:
1347: end if;
1348: --- setting global variables used by Rules simulator and trace execution forms
1349: IF p_type_code = 5 THEN
1350: IF l_return_type_code = 'S' THEN
1351: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;
1352: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1353: ELSIF( l_return_type_code = 'R' ) THEN
1354: wms_search_order_globals_pvt.G_COSTGROUP_RULE_ID := l_return_type_id;
1355: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1348: --- setting global variables used by Rules simulator and trace execution forms
1349: IF p_type_code = 5 THEN
1350: IF l_return_type_code = 'S' THEN
1351: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;
1352: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1353: ELSIF( l_return_type_code = 'R' ) THEN
1354: wms_search_order_globals_pvt.G_COSTGROUP_RULE_ID := l_return_type_id;
1355: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1356: ELSIF( l_return_type_code = 'V' ) THEN
1350: IF l_return_type_code = 'S' THEN
1351: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;
1352: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1353: ELSIF( l_return_type_code = 'R' ) THEN
1354: wms_search_order_globals_pvt.G_COSTGROUP_RULE_ID := l_return_type_id;
1355: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1356: ELSIF( l_return_type_code = 'V' ) THEN
1357: wms_search_order_globals_pvt.G_COSTGROUP_ID := l_return_type_id;
1358: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1351: wms_search_order_globals_pvt.g_costgroup_strategy_id := l_return_type_id;
1352: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1353: ELSIF( l_return_type_code = 'R' ) THEN
1354: wms_search_order_globals_pvt.G_COSTGROUP_RULE_ID := l_return_type_id;
1355: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1356: ELSIF( l_return_type_code = 'V' ) THEN
1357: wms_search_order_globals_pvt.G_COSTGROUP_ID := l_return_type_id;
1358: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1359: END IF;
1353: ELSIF( l_return_type_code = 'R' ) THEN
1354: wms_search_order_globals_pvt.G_COSTGROUP_RULE_ID := l_return_type_id;
1355: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1356: ELSIF( l_return_type_code = 'V' ) THEN
1357: wms_search_order_globals_pvt.G_COSTGROUP_ID := l_return_type_id;
1358: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1359: END IF;
1360: END IF;
1361: --- end of globol variables section
1354: wms_search_order_globals_pvt.G_COSTGROUP_RULE_ID := l_return_type_id;
1355: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1356: ELSIF( l_return_type_code = 'V' ) THEN
1357: wms_search_order_globals_pvt.G_COSTGROUP_ID := l_return_type_id;
1358: wms_search_order_globals_pvt.g_costgroup_seq_num := l_sequence_number;
1359: END IF;
1360: END IF;
1361: --- end of globol variables section
1362: if l_debug = 1 then