[Home] [Help]
1: PACKAGE BODY wms_task_dispatch_engine AS
2: /* $Header: WMSTDENB.pls 120.13.12010000.4 2008/10/23 06:37:43 avuppala 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
4333: CLOSE l_curs_ordered_tasks_10;
4334: END IF;
4335:
4336: IF SQLCODE IS NOT NULL THEN
4337: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.dispatch_task', l_progress, SQLCODE);
4338: END IF;
4339:
4340: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4341:
7191: CLOSE l_curs_ordered_tasks_aw_exp;
7192: END IF;
7193:
7194: IF SQLCODE IS NOT NULL THEN
7195: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.dispatch_task', l_progress, SQLCODE);
7196: END IF;
7197:
7198: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7199:
10713: CLOSE l_cp_curs_ordered_tasks_no_sub;
10714: END IF;
10715:
10716: IF SQLCODE IS NOT NULL THEN
10717: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.dispatch_task', l_progress, SQLCODE);
10718: END IF;
10719:
10720: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
10721:
10877: WHEN OTHERS THEN
10878: x_return_status := fnd_api.g_ret_sts_unexp_error;
10879:
10880: IF SQLCODE IS NOT NULL THEN
10881: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.split_tasks', l_progress, SQLCODE);
10882: END IF;
10883:
10884: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
10885:
11075: END IF;
11076: EXCEPTION
11077: WHEN OTHERS THEN
11078: IF SQLCODE IS NOT NULL THEN
11079: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.is_equipment_cap_exceeded', l_progress, SQLCODE);
11080: END IF;
11081:
11082: IF (l_debug = 1) THEN
11083: print_debug('is_equipment_cap_exceeded: Other exception ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
13234: x_return_status := fnd_api.g_ret_sts_unexp_error;
13235: ROLLBACK TO sp_task_split;
13236:
13237: IF SQLCODE IS NOT NULL THEN
13238: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.split_task', l_progress, SQLCODE);
13239: END IF;
13240:
13241: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
13242:
14183: , l_wct_rec.serial_allocated_flag
14184: , l_wct_rec.move_order_header_id
14185: );
14186: END insert_wct;
14187: END wms_task_dispatch_engine;