[Home] [Help]
1: PACKAGE BODY wms_task_dispatch_engine AS
2: /* $Header: WMSTDENB.pls 120.34.12020000.8 2013/02/22 03:14:33 sahmahes ship $*/
3:
4:
5: --
65: --
66:
67:
68: -- Global constant holding the package name
69: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_Task_Dispatch_Engine';
70: g_move_order_mfg_pick CONSTANT NUMBER := inv_globals.g_move_order_mfg_pick;
71: g_move_order_pick_wave CONSTANT NUMBER := inv_globals.g_move_order_pick_wave;
72: g_exc_unexpected_error EXCEPTION ;
73: g_current_release_level CONSTANT NUMBER := WMS_CONTROL.G_CURRENT_RELEASE_LEVEL;
82:
83: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER) IS
84: BEGIN
85: -- dbms_output.put_line(p_err_msg);
86: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg, p_module => 'WMS_Task_Dispatch_Engine', p_level => p_level);
87: END print_debug;
88:
89: -- bug 4358107
90: PROCEDURE store_locked_tasks
4672: CLOSE l_curs_ordered_tasks_10;
4673: END IF;
4674:
4675: IF SQLCODE IS NOT NULL THEN
4676: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.dispatch_task', l_progress, SQLCODE);
4677: END IF;
4678:
4679: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4680:
7530: CLOSE l_curs_ordered_tasks_aw_exp;
7531: END IF;
7532:
7533: IF SQLCODE IS NOT NULL THEN
7534: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.dispatch_task', l_progress, SQLCODE);
7535: END IF;
7536:
7537: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7538:
11052: CLOSE l_cp_curs_ordered_tasks_no_sub;
11053: END IF;
11054:
11055: IF SQLCODE IS NOT NULL THEN
11056: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.dispatch_task', l_progress, SQLCODE);
11057: END IF;
11058:
11059: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11060:
11216: WHEN OTHERS THEN
11217: x_return_status := fnd_api.g_ret_sts_unexp_error;
11218:
11219: IF SQLCODE IS NOT NULL THEN
11220: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.split_tasks', l_progress, SQLCODE);
11221: END IF;
11222:
11223: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11224:
11486: END IF;
11487: EXCEPTION
11488: WHEN OTHERS THEN
11489: IF SQLCODE IS NOT NULL THEN
11490: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.is_equipment_cap_exceeded', l_progress, SQLCODE);
11491: END IF;
11492:
11493: IF (l_debug = 1) THEN
11494: print_debug('is_equipment_cap_exceeded: Other exception ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
13888: x_return_status := fnd_api.g_ret_sts_unexp_error;
13889: ROLLBACK TO sp_task_split;
13890:
13891: IF SQLCODE IS NOT NULL THEN
13892: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.split_task', l_progress, SQLCODE);
13893: END IF;
13894:
13895: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
13896:
14913: x_return_status := fnd_api.g_ret_sts_unexp_error;
14914:
14915: END insert_mtlt;
14916:
14917: END wms_task_dispatch_engine;