eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DELIVERY_DETAILS_SPLITTER dependencies on WSH_DELIVERY_DETAILS

Line 1: PACKAGE BODY WSH_DELIVERY_DETAILS_SPLITTER as

1: PACKAGE BODY WSH_DELIVERY_DETAILS_SPLITTER as
2: /* $Header: WSHDTSPB.pls 120.3.12020000.2 2013/04/13 01:24:28 rvarghes ship $ */
3:
4: G_PACKAGE_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_DETAILS_SPLITTER';
5:

Line 4: G_PACKAGE_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_DETAILS_SPLITTER';

1: PACKAGE BODY WSH_DELIVERY_DETAILS_SPLITTER as
2: /* $Header: WSHDTSPB.pls 120.3.12020000.2 2013/04/13 01:24:28 rvarghes ship $ */
3:
4: G_PACKAGE_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_DETAILS_SPLITTER';
5:
6:
7: --OTM R12
8: ------------------------------------------------------------

Line 34: FROM wsh_delivery_details

30:
31: -- LSP PROJECT :
32: CURSOR c_get_client(p_delivery_detail_id IN NUMBER) IS
33: SELECT client_id
34: FROM wsh_delivery_details
35: WHERE delivery_detail_id = p_delivery_detail_id;
36: --
37: l_client_id NUMBER;
38: l_standalone_mode VARCHAR2(1);

Line 42: l_max_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;

38: l_standalone_mode VARCHAR2(1);
39: -- LSP PROJECT : end
40: l_parameter_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_REC_TYP;
41: l_global_param_info WSH_SHIPPING_PARAMS_PVT.GLOBAL_PARAMETERS_REC_TYP;
42: l_max_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
43: l_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
44: l_new_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE;
45: l_num_split NUMBER;
46: l_msg_count NUMBER;

Line 43: l_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;

39: -- LSP PROJECT : end
40: l_parameter_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_REC_TYP;
41: l_global_param_info WSH_SHIPPING_PARAMS_PVT.GLOBAL_PARAMETERS_REC_TYP;
42: l_max_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
43: l_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
44: l_new_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE;
45: l_num_split NUMBER;
46: l_msg_count NUMBER;
47: l_msg_data VARCHAR2(32767);

Line 44: l_new_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE;

40: l_parameter_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_REC_TYP;
41: l_global_param_info WSH_SHIPPING_PARAMS_PVT.GLOBAL_PARAMETERS_REC_TYP;
42: l_max_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
43: l_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
44: l_new_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE;
45: l_num_split NUMBER;
46: l_msg_count NUMBER;
47: l_msg_data VARCHAR2(32767);
48: l_exception_id WSH_EXCEPTIONS.EXCEPTION_ID%TYPE;

Line 59: l_requested_quantity_uom WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM%TYPE;

55: i NUMBER;
56: split_error EXCEPTION;
57: l_gc3_is_installed VARCHAR2(1);
58: -- muom + 16597177
59: l_requested_quantity_uom WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM%TYPE;
60: l_requested_quantity_uom2 WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM2%TYPE;
61: l_max_quantity2 WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY2%TYPE;
62: --
63: l_debug_on BOOLEAN;

Line 60: l_requested_quantity_uom2 WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM2%TYPE;

56: split_error EXCEPTION;
57: l_gc3_is_installed VARCHAR2(1);
58: -- muom + 16597177
59: l_requested_quantity_uom WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM%TYPE;
60: l_requested_quantity_uom2 WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM2%TYPE;
61: l_max_quantity2 WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY2%TYPE;
62: --
63: l_debug_on BOOLEAN;
64: --

Line 61: l_max_quantity2 WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY2%TYPE;

57: l_gc3_is_installed VARCHAR2(1);
58: -- muom + 16597177
59: l_requested_quantity_uom WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM%TYPE;
60: l_requested_quantity_uom2 WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM2%TYPE;
61: l_max_quantity2 WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY2%TYPE;
62: --
63: l_debug_on BOOLEAN;
64: --
65: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' ||

Line 216: FROM wsh_delivery_details

212: l_requested_quantity_uom2 := null;
213: BEGIN
214: SELECT requested_quantity_uom, requested_quantity_uom2
215: INTO l_requested_quantity_uom, l_requested_quantity_uom2
216: FROM wsh_delivery_details
217: WHERE delivery_detail_id = p_detail_tab(i).entity_id;
218:
219: EXCEPTION
220: when others then

Line 343: 'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS_BULK',

339: l_new_detail_id := NULL;
340:
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.logmsg(l_module_name,
343: 'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS_BULK',
344: WSH_DEBUG_SV.C_PROC_LEVEL);
345: WSH_DEBUG_SV.log(l_module_name, 'l_num_split', l_num_split);
346: END IF;
347:

Line 348: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details_bulk (

344: WSH_DEBUG_SV.C_PROC_LEVEL);
345: WSH_DEBUG_SV.log(l_module_name, 'l_num_split', l_num_split);
346: END IF;
347:
348: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details_bulk (
349: p_from_detail_id => p_detail_tab(i).entity_id,
350: p_req_quantity => l_max_quantity,
351: -- muom + 16597177
352: p_req_quantity2 => l_max_quantity2,

Line 360: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS_BULK: ' || l_return_status);

356: x_return_status => l_return_status
357: );
358:
359: IF l_debug_on THEN
360: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS_BULK: ' || l_return_status);
361: END IF;
362:
363: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
364: RAISE split_error;

Line 420: 'WSH_DELIVERY_DETAILS_SPLITTER.TMS_DELIVERY_DETAIL_SPLIT exception has occured ',

416: END IF;
417:
418: IF l_debug_on THEN
419: wsh_debug_sv.logmsg(l_module_name,
420: 'WSH_DELIVERY_DETAILS_SPLITTER.TMS_DELIVERY_DETAIL_SPLIT exception has occured ',
421: wsh_debug_sv.c_excep_level);
422: END IF;
423:
424: END;

Line 452: 'WSH_DELIVERY_DETAILS_SPLITTER.TMS_DELIVERY_DETAIL_SPLIT', l_module_name);

448:
449: WHEN OTHERS THEN
450: --
451: WSH_UTIL_CORE.default_handler(
452: 'WSH_DELIVERY_DETAILS_SPLITTER.TMS_DELIVERY_DETAIL_SPLIT', l_module_name);
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.logmsg(l_module_name,
455: 'Unexpected error has occured. Oracle error message is '||
456: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 461: END WSH_DELIVERY_DETAILS_SPLITTER;

457: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
458: END IF;
459: END TMS_DELIVERY_DETAIL_SPLIT;
460:
461: END WSH_DELIVERY_DETAILS_SPLITTER;