8: -- Notes :
9: -- Modified : 7/24/2003 lezhang created
10:
11: g_txn_type_so_stg_xfr NUMBER := inv_globals.g_type_transfer_order_stgxfr;
12: g_op_dest_sys_suggested NUMBER := wms_globals.g_op_dest_sys_suggested;
13: g_op_dest_api NUMBER := wms_globals.g_op_dest_api;
14: g_op_dest_pre_specified NUMBER := wms_globals.g_op_dest_pre_specified;
15: g_op_dest_rules_engine NUMBER := wms_globals.g_op_dest_rules_engine;
16: g_wms_task_type_pick NUMBER := wms_globals.g_wms_task_type_pick;
9: -- Modified : 7/24/2003 lezhang created
10:
11: g_txn_type_so_stg_xfr NUMBER := inv_globals.g_type_transfer_order_stgxfr;
12: g_op_dest_sys_suggested NUMBER := wms_globals.g_op_dest_sys_suggested;
13: g_op_dest_api NUMBER := wms_globals.g_op_dest_api;
14: g_op_dest_pre_specified NUMBER := wms_globals.g_op_dest_pre_specified;
15: g_op_dest_rules_engine NUMBER := wms_globals.g_op_dest_rules_engine;
16: g_wms_task_type_pick NUMBER := wms_globals.g_wms_task_type_pick;
17: g_wms_task_type_stg_move NUMBER := wms_globals.g_wms_task_type_stg_move;
10:
11: g_txn_type_so_stg_xfr NUMBER := inv_globals.g_type_transfer_order_stgxfr;
12: g_op_dest_sys_suggested NUMBER := wms_globals.g_op_dest_sys_suggested;
13: g_op_dest_api NUMBER := wms_globals.g_op_dest_api;
14: g_op_dest_pre_specified NUMBER := wms_globals.g_op_dest_pre_specified;
15: g_op_dest_rules_engine NUMBER := wms_globals.g_op_dest_rules_engine;
16: g_wms_task_type_pick NUMBER := wms_globals.g_wms_task_type_pick;
17: g_wms_task_type_stg_move NUMBER := wms_globals.g_wms_task_type_stg_move;
18: g_wms_task_type_putaway NUMBER := wms_globals.g_wms_task_type_putaway;
11: g_txn_type_so_stg_xfr NUMBER := inv_globals.g_type_transfer_order_stgxfr;
12: g_op_dest_sys_suggested NUMBER := wms_globals.g_op_dest_sys_suggested;
13: g_op_dest_api NUMBER := wms_globals.g_op_dest_api;
14: g_op_dest_pre_specified NUMBER := wms_globals.g_op_dest_pre_specified;
15: g_op_dest_rules_engine NUMBER := wms_globals.g_op_dest_rules_engine;
16: g_wms_task_type_pick NUMBER := wms_globals.g_wms_task_type_pick;
17: g_wms_task_type_stg_move NUMBER := wms_globals.g_wms_task_type_stg_move;
18: g_wms_task_type_putaway NUMBER := wms_globals.g_wms_task_type_putaway;
19: g_wms_task_type_inspect NUMBER := wms_globals.g_wms_task_type_inspect;
12: g_op_dest_sys_suggested NUMBER := wms_globals.g_op_dest_sys_suggested;
13: g_op_dest_api NUMBER := wms_globals.g_op_dest_api;
14: g_op_dest_pre_specified NUMBER := wms_globals.g_op_dest_pre_specified;
15: g_op_dest_rules_engine NUMBER := wms_globals.g_op_dest_rules_engine;
16: g_wms_task_type_pick NUMBER := wms_globals.g_wms_task_type_pick;
17: g_wms_task_type_stg_move NUMBER := wms_globals.g_wms_task_type_stg_move;
18: g_wms_task_type_putaway NUMBER := wms_globals.g_wms_task_type_putaway;
19: g_wms_task_type_inspect NUMBER := wms_globals.g_wms_task_type_inspect;
20: g_op_drop_lpn_no_lpn NUMBER := wms_globals.g_op_drop_lpn_no_lpn;
13: g_op_dest_api NUMBER := wms_globals.g_op_dest_api;
14: g_op_dest_pre_specified NUMBER := wms_globals.g_op_dest_pre_specified;
15: g_op_dest_rules_engine NUMBER := wms_globals.g_op_dest_rules_engine;
16: g_wms_task_type_pick NUMBER := wms_globals.g_wms_task_type_pick;
17: g_wms_task_type_stg_move NUMBER := wms_globals.g_wms_task_type_stg_move;
18: g_wms_task_type_putaway NUMBER := wms_globals.g_wms_task_type_putaway;
19: g_wms_task_type_inspect NUMBER := wms_globals.g_wms_task_type_inspect;
20: g_op_drop_lpn_no_lpn NUMBER := wms_globals.g_op_drop_lpn_no_lpn;
21: g_op_drop_lpn_optional NUMBER := wms_globals.g_op_drop_lpn_optional;
14: g_op_dest_pre_specified NUMBER := wms_globals.g_op_dest_pre_specified;
15: g_op_dest_rules_engine NUMBER := wms_globals.g_op_dest_rules_engine;
16: g_wms_task_type_pick NUMBER := wms_globals.g_wms_task_type_pick;
17: g_wms_task_type_stg_move NUMBER := wms_globals.g_wms_task_type_stg_move;
18: g_wms_task_type_putaway NUMBER := wms_globals.g_wms_task_type_putaway;
19: g_wms_task_type_inspect NUMBER := wms_globals.g_wms_task_type_inspect;
20: g_op_drop_lpn_no_lpn NUMBER := wms_globals.g_op_drop_lpn_no_lpn;
21: g_op_drop_lpn_optional NUMBER := wms_globals.g_op_drop_lpn_optional;
22: g_ret_sts_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
15: g_op_dest_rules_engine NUMBER := wms_globals.g_op_dest_rules_engine;
16: g_wms_task_type_pick NUMBER := wms_globals.g_wms_task_type_pick;
17: g_wms_task_type_stg_move NUMBER := wms_globals.g_wms_task_type_stg_move;
18: g_wms_task_type_putaway NUMBER := wms_globals.g_wms_task_type_putaway;
19: g_wms_task_type_inspect NUMBER := wms_globals.g_wms_task_type_inspect;
20: g_op_drop_lpn_no_lpn NUMBER := wms_globals.g_op_drop_lpn_no_lpn;
21: g_op_drop_lpn_optional NUMBER := wms_globals.g_op_drop_lpn_optional;
22: g_ret_sts_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
23: g_ret_sts_unexp_error VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
16: g_wms_task_type_pick NUMBER := wms_globals.g_wms_task_type_pick;
17: g_wms_task_type_stg_move NUMBER := wms_globals.g_wms_task_type_stg_move;
18: g_wms_task_type_putaway NUMBER := wms_globals.g_wms_task_type_putaway;
19: g_wms_task_type_inspect NUMBER := wms_globals.g_wms_task_type_inspect;
20: g_op_drop_lpn_no_lpn NUMBER := wms_globals.g_op_drop_lpn_no_lpn;
21: g_op_drop_lpn_optional NUMBER := wms_globals.g_op_drop_lpn_optional;
22: g_ret_sts_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
23: g_ret_sts_unexp_error VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
24: g_ret_sts_error VARCHAR2(1) := fnd_api.g_ret_sts_error;
17: g_wms_task_type_stg_move NUMBER := wms_globals.g_wms_task_type_stg_move;
18: g_wms_task_type_putaway NUMBER := wms_globals.g_wms_task_type_putaway;
19: g_wms_task_type_inspect NUMBER := wms_globals.g_wms_task_type_inspect;
20: g_op_drop_lpn_no_lpn NUMBER := wms_globals.g_op_drop_lpn_no_lpn;
21: g_op_drop_lpn_optional NUMBER := wms_globals.g_op_drop_lpn_optional;
22: g_ret_sts_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
23: g_ret_sts_unexp_error VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
24: g_ret_sts_error VARCHAR2(1) := fnd_api.g_ret_sts_error;
25: g_msg_lvl_unexp_error NUMBER := fnd_msg_pub.g_msg_lvl_unexp_error;
26: g_msg_lvl_error NUMBER := fnd_msg_pub.g_msg_lvl_error;
27: g_version_printed BOOLEAN := FALSE;
28: g_pkg_name VARCHAR2(30) := 'WMS_ATF_RUNTIME_PUB_APIS';
29:
30: G_OP_TYPE_LOAD CONSTANT NUMBER := wms_globals.g_op_type_load;
31: G_OP_TYPE_DROP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_DROP;
32: G_OP_TYPE_SORT CONSTANT NUMBER:= wms_globals.G_OP_TYPE_SORT;
33: G_OP_TYPE_CONSOLIDATE CONSTANT NUMBER:= wms_globals.G_OP_TYPE_CONSOLIDATE;
34: G_OP_TYPE_PACK CONSTANT NUMBER:= wms_globals.G_OP_TYPE_PACK;
27: g_version_printed BOOLEAN := FALSE;
28: g_pkg_name VARCHAR2(30) := 'WMS_ATF_RUNTIME_PUB_APIS';
29:
30: G_OP_TYPE_LOAD CONSTANT NUMBER := wms_globals.g_op_type_load;
31: G_OP_TYPE_DROP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_DROP;
32: G_OP_TYPE_SORT CONSTANT NUMBER:= wms_globals.G_OP_TYPE_SORT;
33: G_OP_TYPE_CONSOLIDATE CONSTANT NUMBER:= wms_globals.G_OP_TYPE_CONSOLIDATE;
34: G_OP_TYPE_PACK CONSTANT NUMBER:= wms_globals.G_OP_TYPE_PACK;
35: G_OP_TYPE_LOAD_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_LOAD_SHIP;
28: g_pkg_name VARCHAR2(30) := 'WMS_ATF_RUNTIME_PUB_APIS';
29:
30: G_OP_TYPE_LOAD CONSTANT NUMBER := wms_globals.g_op_type_load;
31: G_OP_TYPE_DROP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_DROP;
32: G_OP_TYPE_SORT CONSTANT NUMBER:= wms_globals.G_OP_TYPE_SORT;
33: G_OP_TYPE_CONSOLIDATE CONSTANT NUMBER:= wms_globals.G_OP_TYPE_CONSOLIDATE;
34: G_OP_TYPE_PACK CONSTANT NUMBER:= wms_globals.G_OP_TYPE_PACK;
35: G_OP_TYPE_LOAD_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_LOAD_SHIP;
36: G_OP_TYPE_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_SHIP;
29:
30: G_OP_TYPE_LOAD CONSTANT NUMBER := wms_globals.g_op_type_load;
31: G_OP_TYPE_DROP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_DROP;
32: G_OP_TYPE_SORT CONSTANT NUMBER:= wms_globals.G_OP_TYPE_SORT;
33: G_OP_TYPE_CONSOLIDATE CONSTANT NUMBER:= wms_globals.G_OP_TYPE_CONSOLIDATE;
34: G_OP_TYPE_PACK CONSTANT NUMBER:= wms_globals.G_OP_TYPE_PACK;
35: G_OP_TYPE_LOAD_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_LOAD_SHIP;
36: G_OP_TYPE_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_SHIP;
37: G_OP_TYPE_CYCLE_COUNT CONSTANT NUMBER := wms_globals.G_OP_TYPE_CYCLE_COUNT;
30: G_OP_TYPE_LOAD CONSTANT NUMBER := wms_globals.g_op_type_load;
31: G_OP_TYPE_DROP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_DROP;
32: G_OP_TYPE_SORT CONSTANT NUMBER:= wms_globals.G_OP_TYPE_SORT;
33: G_OP_TYPE_CONSOLIDATE CONSTANT NUMBER:= wms_globals.G_OP_TYPE_CONSOLIDATE;
34: G_OP_TYPE_PACK CONSTANT NUMBER:= wms_globals.G_OP_TYPE_PACK;
35: G_OP_TYPE_LOAD_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_LOAD_SHIP;
36: G_OP_TYPE_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_SHIP;
37: G_OP_TYPE_CYCLE_COUNT CONSTANT NUMBER := wms_globals.G_OP_TYPE_CYCLE_COUNT;
38: G_OP_TYPE_INSPECT CONSTANT NUMBER := wms_globals.G_OP_TYPE_INSPECT;
31: G_OP_TYPE_DROP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_DROP;
32: G_OP_TYPE_SORT CONSTANT NUMBER:= wms_globals.G_OP_TYPE_SORT;
33: G_OP_TYPE_CONSOLIDATE CONSTANT NUMBER:= wms_globals.G_OP_TYPE_CONSOLIDATE;
34: G_OP_TYPE_PACK CONSTANT NUMBER:= wms_globals.G_OP_TYPE_PACK;
35: G_OP_TYPE_LOAD_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_LOAD_SHIP;
36: G_OP_TYPE_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_SHIP;
37: G_OP_TYPE_CYCLE_COUNT CONSTANT NUMBER := wms_globals.G_OP_TYPE_CYCLE_COUNT;
38: G_OP_TYPE_INSPECT CONSTANT NUMBER := wms_globals.G_OP_TYPE_INSPECT;
39: G_OP_TYPE_CROSSDOCK CONSTANT NUMBER:= wms_globals.G_OP_TYPE_CROSSDOCK;
32: G_OP_TYPE_SORT CONSTANT NUMBER:= wms_globals.G_OP_TYPE_SORT;
33: G_OP_TYPE_CONSOLIDATE CONSTANT NUMBER:= wms_globals.G_OP_TYPE_CONSOLIDATE;
34: G_OP_TYPE_PACK CONSTANT NUMBER:= wms_globals.G_OP_TYPE_PACK;
35: G_OP_TYPE_LOAD_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_LOAD_SHIP;
36: G_OP_TYPE_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_SHIP;
37: G_OP_TYPE_CYCLE_COUNT CONSTANT NUMBER := wms_globals.G_OP_TYPE_CYCLE_COUNT;
38: G_OP_TYPE_INSPECT CONSTANT NUMBER := wms_globals.G_OP_TYPE_INSPECT;
39: G_OP_TYPE_CROSSDOCK CONSTANT NUMBER:= wms_globals.G_OP_TYPE_CROSSDOCK;
40:
33: G_OP_TYPE_CONSOLIDATE CONSTANT NUMBER:= wms_globals.G_OP_TYPE_CONSOLIDATE;
34: G_OP_TYPE_PACK CONSTANT NUMBER:= wms_globals.G_OP_TYPE_PACK;
35: G_OP_TYPE_LOAD_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_LOAD_SHIP;
36: G_OP_TYPE_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_SHIP;
37: G_OP_TYPE_CYCLE_COUNT CONSTANT NUMBER := wms_globals.G_OP_TYPE_CYCLE_COUNT;
38: G_OP_TYPE_INSPECT CONSTANT NUMBER := wms_globals.G_OP_TYPE_INSPECT;
39: G_OP_TYPE_CROSSDOCK CONSTANT NUMBER:= wms_globals.G_OP_TYPE_CROSSDOCK;
40:
41: G_OP_ACTIVITY_INBOUND CONSTANT NUMBER:= wms_globals.G_OP_ACTIVITY_INBOUND;
34: G_OP_TYPE_PACK CONSTANT NUMBER:= wms_globals.G_OP_TYPE_PACK;
35: G_OP_TYPE_LOAD_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_LOAD_SHIP;
36: G_OP_TYPE_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_SHIP;
37: G_OP_TYPE_CYCLE_COUNT CONSTANT NUMBER := wms_globals.G_OP_TYPE_CYCLE_COUNT;
38: G_OP_TYPE_INSPECT CONSTANT NUMBER := wms_globals.G_OP_TYPE_INSPECT;
39: G_OP_TYPE_CROSSDOCK CONSTANT NUMBER:= wms_globals.G_OP_TYPE_CROSSDOCK;
40:
41: G_OP_ACTIVITY_INBOUND CONSTANT NUMBER:= wms_globals.G_OP_ACTIVITY_INBOUND;
42: g_task_status_dispatched CONSTANT NUMBER:= 3;
35: G_OP_TYPE_LOAD_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_LOAD_SHIP;
36: G_OP_TYPE_SHIP CONSTANT NUMBER:= wms_globals.G_OP_TYPE_SHIP;
37: G_OP_TYPE_CYCLE_COUNT CONSTANT NUMBER := wms_globals.G_OP_TYPE_CYCLE_COUNT;
38: G_OP_TYPE_INSPECT CONSTANT NUMBER := wms_globals.G_OP_TYPE_INSPECT;
39: G_OP_TYPE_CROSSDOCK CONSTANT NUMBER:= wms_globals.G_OP_TYPE_CROSSDOCK;
40:
41: G_OP_ACTIVITY_INBOUND CONSTANT NUMBER:= wms_globals.G_OP_ACTIVITY_INBOUND;
42: g_task_status_dispatched CONSTANT NUMBER:= 3;
43: g_task_status_loaded CONSTANT NUMBER:= 4;
37: G_OP_TYPE_CYCLE_COUNT CONSTANT NUMBER := wms_globals.G_OP_TYPE_CYCLE_COUNT;
38: G_OP_TYPE_INSPECT CONSTANT NUMBER := wms_globals.G_OP_TYPE_INSPECT;
39: G_OP_TYPE_CROSSDOCK CONSTANT NUMBER:= wms_globals.G_OP_TYPE_CROSSDOCK;
40:
41: G_OP_ACTIVITY_INBOUND CONSTANT NUMBER:= wms_globals.G_OP_ACTIVITY_INBOUND;
42: g_task_status_dispatched CONSTANT NUMBER:= 3;
43: g_task_status_loaded CONSTANT NUMBER:= 4;
44: G_OP_INS_STAT_PENDING CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_PENDING;
45: G_OP_INS_STAT_ACTIVE CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_ACTIVE;
40:
41: G_OP_ACTIVITY_INBOUND CONSTANT NUMBER:= wms_globals.G_OP_ACTIVITY_INBOUND;
42: g_task_status_dispatched CONSTANT NUMBER:= 3;
43: g_task_status_loaded CONSTANT NUMBER:= 4;
44: G_OP_INS_STAT_PENDING CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_PENDING;
45: G_OP_INS_STAT_ACTIVE CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_ACTIVE;
46: G_OP_INS_STAT_COMPLETED CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_COMPLETED;
47: G_OP_INS_STAT_ABORTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_ABORTED;
48: G_OP_INS_STAT_CANCELLED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_CANCELLED;
41: G_OP_ACTIVITY_INBOUND CONSTANT NUMBER:= wms_globals.G_OP_ACTIVITY_INBOUND;
42: g_task_status_dispatched CONSTANT NUMBER:= 3;
43: g_task_status_loaded CONSTANT NUMBER:= 4;
44: G_OP_INS_STAT_PENDING CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_PENDING;
45: G_OP_INS_STAT_ACTIVE CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_ACTIVE;
46: G_OP_INS_STAT_COMPLETED CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_COMPLETED;
47: G_OP_INS_STAT_ABORTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_ABORTED;
48: G_OP_INS_STAT_CANCELLED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_CANCELLED;
49: G_OP_INS_STAT_IN_PROGRESS CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_IN_PROGRESS;
42: g_task_status_dispatched CONSTANT NUMBER:= 3;
43: g_task_status_loaded CONSTANT NUMBER:= 4;
44: G_OP_INS_STAT_PENDING CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_PENDING;
45: G_OP_INS_STAT_ACTIVE CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_ACTIVE;
46: G_OP_INS_STAT_COMPLETED CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_COMPLETED;
47: G_OP_INS_STAT_ABORTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_ABORTED;
48: G_OP_INS_STAT_CANCELLED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_CANCELLED;
49: G_OP_INS_STAT_IN_PROGRESS CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_IN_PROGRESS;
50: G_OP_DEST_SYS_SUGGESTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_DEST_SYS_SUGGESTED;
43: g_task_status_loaded CONSTANT NUMBER:= 4;
44: G_OP_INS_STAT_PENDING CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_PENDING;
45: G_OP_INS_STAT_ACTIVE CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_ACTIVE;
46: G_OP_INS_STAT_COMPLETED CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_COMPLETED;
47: G_OP_INS_STAT_ABORTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_ABORTED;
48: G_OP_INS_STAT_CANCELLED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_CANCELLED;
49: G_OP_INS_STAT_IN_PROGRESS CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_IN_PROGRESS;
50: G_OP_DEST_SYS_SUGGESTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_DEST_SYS_SUGGESTED;
51:
44: G_OP_INS_STAT_PENDING CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_PENDING;
45: G_OP_INS_STAT_ACTIVE CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_ACTIVE;
46: G_OP_INS_STAT_COMPLETED CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_COMPLETED;
47: G_OP_INS_STAT_ABORTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_ABORTED;
48: G_OP_INS_STAT_CANCELLED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_CANCELLED;
49: G_OP_INS_STAT_IN_PROGRESS CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_IN_PROGRESS;
50: G_OP_DEST_SYS_SUGGESTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_DEST_SYS_SUGGESTED;
51:
52:
45: G_OP_INS_STAT_ACTIVE CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_ACTIVE;
46: G_OP_INS_STAT_COMPLETED CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_COMPLETED;
47: G_OP_INS_STAT_ABORTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_ABORTED;
48: G_OP_INS_STAT_CANCELLED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_CANCELLED;
49: G_OP_INS_STAT_IN_PROGRESS CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_IN_PROGRESS;
50: G_OP_DEST_SYS_SUGGESTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_DEST_SYS_SUGGESTED;
51:
52:
53: PROCEDURE print_debug(p_err_msg IN VARCHAR2, p_module_name IN VARCHAR2, p_level IN NUMBER) IS
46: G_OP_INS_STAT_COMPLETED CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_COMPLETED;
47: G_OP_INS_STAT_ABORTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_ABORTED;
48: G_OP_INS_STAT_CANCELLED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_CANCELLED;
49: G_OP_INS_STAT_IN_PROGRESS CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_IN_PROGRESS;
50: G_OP_DEST_SYS_SUGGESTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_DEST_SYS_SUGGESTED;
51:
52:
53: PROCEDURE print_debug(p_err_msg IN VARCHAR2, p_module_name IN VARCHAR2, p_level IN NUMBER) IS
54: BEGIN
377: /*If Plan Type is inspect or the last drop in the in PLan does not have a determination type
378: of system suggested*/
379:
380: IF l_operation_plan_rec.plan_type_id=2 OR
381: l_final_loc_sel_criter<>WMS_GLOBALS.G_OP_DEST_SYS_SUGGESTED THEN
382:
383: IF l_debug=1 THEN
384: print_debug('Locator Capacity needs to be reverted',l_module_name,9);
385: END IF;
893:
894: END IF;
895:
896: IF NVL(l_plan_details.sub_selection_criteria,0) =
897: wms_globals.G_OP_DEST_PRE_SPECIFIED
898: THEN
899:
900: l_attributes.sug_sub_code := l_plan_details.pre_specified_sub_code;
901:
916: * we get the values from Parent MMTT record
917: */
918:
919: IF NVL(l_plan_details.loc_selection_criteria,0) =
920: wms_globals.G_OP_DEST_PRE_SPECIFIED
921: THEN
922: l_attributes.sug_location_id := l_plan_details.pre_specified_loc_id;
923:
924: l_validate_loc := TRUE;
923:
924: l_validate_loc := TRUE;
925:
926: ELSIF NVL(l_plan_details.loc_selection_criteria,0) =
927: wms_globals.G_OP_DEST_API OR
928: NVL(l_plan_details.loc_selection_criteria,0) =
929: wms_globals.G_OP_DEST_CUSTOM_API
930: THEN
931:
925:
926: ELSIF NVL(l_plan_details.loc_selection_criteria,0) =
927: wms_globals.G_OP_DEST_API OR
928: NVL(l_plan_details.loc_selection_criteria,0) =
929: wms_globals.G_OP_DEST_CUSTOM_API
930: THEN
931:
932: /*
933: * The API should be validating its inputs so not validating
1062: print_debug('l_xd_loc_selection_api_id =>'||l_xd_loc_selection_api_id,l_module_name,4);
1063: print_debug('l_xd_drop_lpn_option =>'||l_xd_drop_lpn_option,l_module_name,4);
1064: END IF;
1065:
1066: IF (l_xd_loc_selection_criteria = wms_globals.g_op_dest_sys_suggested) THEN --4
1067: IF (l_debug = 1) THEN
1068: print_debug('Outbound plan should not have this value.',l_module_name,4);
1069: END IF;
1070: RAISE fnd_api.g_exc_error;
1067: IF (l_debug = 1) THEN
1068: print_debug('Outbound plan should not have this value.',l_module_name,4);
1069: END IF;
1070: RAISE fnd_api.g_exc_error;
1071: ELSIF (l_xd_loc_selection_criteria = wms_globals.g_op_dest_api) THEN --2
1072: IF (l_xd_loc_selection_api_id = 1) THEN--Consolidation Lane
1073:
1074: --If it is consolidation based in consolidation loc, always treat
1075: --it as within delivery
1242:
1243: END IF;
1244: END IF; --END IF (l_consolidation_method_id = 2 OR
1245: END IF;--END IF (l_plan_details.loc_selection_api_id = 1) THEN
1246: END IF;--END IF (l_plan_details.loc_selection_criteria = wms_globals.g_op_dest_sys_suggested) THEN
1247:
1248: IF l_attributes.sug_location_id IS NULL OR
1249: l_attributes.sug_sub_code IS NULL THEN
1250: IF (l_debug = 1) THEN
1259:
1260: END IF;--END IF l_attributes.sug_location_id IS NULL OR
1261:
1262: ELSIF NVL(l_plan_details.loc_selection_criteria,0) =
1263: wms_globals.G_OP_DEST_SYS_SUGGESTED
1264: THEN
1265:
1266: IF p_activity_type_id = wms_globals.g_op_activity_inbound THEN
1267:
1262: ELSIF NVL(l_plan_details.loc_selection_criteria,0) =
1263: wms_globals.G_OP_DEST_SYS_SUGGESTED
1264: THEN
1265:
1266: IF p_activity_type_id = wms_globals.g_op_activity_inbound THEN
1267:
1268: l_progress := '60';
1269:
1270: OPEN c_parent_locator;
1424: END IF;
1425:
1426:
1427: IF NVL(l_plan_details.lpn_selection_criteria,0) =
1428: wms_globals.G_OP_DEST_API OR
1429: NVL(l_plan_details.lpn_selection_criteria,0) =
1430: wms_globals.G_OP_DEST_CUSTOM_API
1431: THEN
1432:
1426:
1427: IF NVL(l_plan_details.lpn_selection_criteria,0) =
1428: wms_globals.G_OP_DEST_API OR
1429: NVL(l_plan_details.lpn_selection_criteria,0) =
1430: wms_globals.G_OP_DEST_CUSTOM_API
1431: THEN
1432:
1433: /*
1434: * The API should be validating its inputs so not validating
3187: print_debug('l_loc_sel_criteria_id = '||l_loc_sel_criteria_id,l_module_name,4);
3188: print_debug('l_loc_sel_api_id = '||l_loc_sel_api_id,l_module_name,4);
3189: END IF;
3190:
3191: IF l_loc_sel_criteria_id = wms_globals.G_OP_DEST_PRE_SPECIFIED
3192: OR l_loc_sel_criteria_id = wms_globals.G_OP_DEST_SYS_SUGGESTED
3193: THEN
3194:
3195: IF (l_debug=1) THEN
3188: print_debug('l_loc_sel_api_id = '||l_loc_sel_api_id,l_module_name,4);
3189: END IF;
3190:
3191: IF l_loc_sel_criteria_id = wms_globals.G_OP_DEST_PRE_SPECIFIED
3192: OR l_loc_sel_criteria_id = wms_globals.G_OP_DEST_SYS_SUGGESTED
3193: THEN
3194:
3195: IF (l_debug=1) THEN
3196: print_debug('Unforgivable error: User overrides pre-specified or system-suggested locator, need to abort operation plan ',l_module_name,4);
3196: print_debug('Unforgivable error: User overrides pre-specified or system-suggested locator, need to abort operation plan ',l_module_name,4);
3197: END IF;
3198: l_unforgivable_error_flag := 'Y';
3199:
3200: ELSIF l_loc_sel_criteria_id = wms_globals.G_OP_DEST_API
3201: OR l_loc_sel_criteria_id = wms_globals.G_OP_DEST_CUSTOM_API
3202: THEN
3203:
3204: IF (l_debug=1) THEN
3197: END IF;
3198: l_unforgivable_error_flag := 'Y';
3199:
3200: ELSIF l_loc_sel_criteria_id = wms_globals.G_OP_DEST_API
3201: OR l_loc_sel_criteria_id = wms_globals.G_OP_DEST_CUSTOM_API
3202: THEN
3203:
3204: IF (l_debug=1) THEN
3205: print_debug('User overrides API derived locator, need to validate',l_module_name,4);
3270: fnd_message.set_name('WMS', 'WMS_ATF_LOC_DET_NOT_DEFINED');
3271: fnd_msg_pub.ADD;
3272: RAISE FND_API.G_EXC_ERROR;
3273:
3274: END IF; -- IF NVL(l_loc_sel_criteria_id, 0) = wms_globals.G_OP_DEST_PRE_SPECIFIED
3275:
3276: END IF; -- IF l_wooi_data_rec.sug_to_locator_id <> Nvl(l_mmtt_rec.transfer_to_location
3277:
3278: IF l_unforgivable_error_flag = 'Y' THEN