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_CONTAINER_ACTIONS dependencies on WSH_CONTAINER_ACTIONS

Line 1: PACKAGE BODY wsh_container_actions as

1: PACKAGE BODY wsh_container_actions as
2: /* $Header: WSHCMACB.pls 120.27.12020000.3 2013/03/01 00:41:40 adagur ship $ */
3:
4: LIMITED_PRECISION NUMBER := 5;
5: c_wms_code_present varchar2(2) := 'Y';

Line 103: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_CONTAINER_ACTIONS';

99: C_SUCCESS_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
100: C_UNEXP_ERROR_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
101:
102: --
103: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_CONTAINER_ACTIONS';
104: --
105:
106: --Bug #3005780 : Added the local function Get_Gcd
107: /*

Line 215: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Validate_Container',l_module_name);

211: WSH_DEBUG_SV.pop(l_module_name);
212: END IF;
213: EXCEPTION
214: WHEN Others THEN
215: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Validate_Container',l_module_name);
216: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
217: --
218: IF l_debug_on THEN
219: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 668: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.default_container_attr',l_module_name);

664: END IF;
665: --
666:
667: WHEN Others THEN
668: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.default_container_attr',l_module_name);
669: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
670:
671: --
672: IF l_debug_on THEN

Line 762: l_cont_rec wsh_container_actions.cont_inst_rec;

758: l_cont_name VARCHAR2(30);
759: l_org_name VARCHAR2(240);
760:
761: l_item_name VARCHAR2(2000);
762: l_cont_rec wsh_container_actions.cont_inst_rec;
763: l_cont_tab wsh_container_actions.cont_inst_tab;
764: i NUMBER;
765: j NUMBER;
766: cnt NUMBER;

Line 763: l_cont_tab wsh_container_actions.cont_inst_tab;

759: l_org_name VARCHAR2(240);
760:
761: l_item_name VARCHAR2(2000);
762: l_cont_rec wsh_container_actions.cont_inst_rec;
763: l_cont_tab wsh_container_actions.cont_inst_tab;
764: i NUMBER;
765: j NUMBER;
766: cnt NUMBER;
767: l_cont_dummy_tab WSH_UTIL_CORE.id_tab_type;

Line 1231: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi',l_module_name);

1227:
1228: WHEN Others THEN
1229: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
1230: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;
1231: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi',l_module_name);
1232: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1233:
1234: --
1235: IF l_debug_on THEN

Line 1566: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Delete_Containers',l_module_name);

1562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UNASSIGN_DEL_ERROR');
1563: END IF;
1564: --
1565: WHEN Others THEN
1566: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Delete_Containers',l_module_name);
1567: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1568:
1569: --
1570: IF l_debug_on THEN

Line 1782: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);

1778: -- container as the first line..
1779:
1780: --
1781: IF l_debug_on THEN
1782: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
1783: END IF;
1784: --
1785: wsh_container_actions.Check_Cont_Attributes (
1786: p_container_instance_id,

Line 1785: wsh_container_actions.Check_Cont_Attributes (

1781: IF l_debug_on THEN
1782: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
1783: END IF;
1784: --
1785: wsh_container_actions.Check_Cont_Attributes (
1786: p_container_instance_id,
1787: l_attr_flag,
1788: x_return_status);
1789:

Line 2055: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);

2051:
2052: --dbms_output.put_line('calling update cont hierarchy with ' || p_container_instance_id);
2053: --
2054: IF l_debug_on THEN
2055: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
2056: END IF;
2057: --
2058: wsh_container_actions.Update_Cont_Hierarchy (
2059: l_del_detail_id,

Line 2058: wsh_container_actions.Update_Cont_Hierarchy (

2054: IF l_debug_on THEN
2055: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
2056: END IF;
2057: --
2058: wsh_container_actions.Update_Cont_Hierarchy (
2059: l_del_detail_id,
2060: NULL,
2061: p_container_instance_id,
2062: x_return_status);

Line 2132: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Assign_Detail',l_module_name);

2128: --
2129: EXCEPTION
2130:
2131: WHEN Others THEN
2132: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Assign_Detail',l_module_name);
2133: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2134:
2135: --
2136: IF l_debug_on THEN

Line 2455: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.LAST_ASSIGNED_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);

2451: --dbms_output.put_line('calling last assigned line for ' || l_del_detail_rec(i));
2452:
2453: --
2454: IF l_debug_on THEN
2455: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.LAST_ASSIGNED_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
2456: END IF;
2457: --
2458: wsh_container_actions.Last_Assigned_Line (
2459: l_del_detail_rec(i),

Line 2458: wsh_container_actions.Last_Assigned_Line (

2454: IF l_debug_on THEN
2455: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.LAST_ASSIGNED_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
2456: END IF;
2457: --
2458: wsh_container_actions.Last_Assigned_Line (
2459: l_del_detail_rec(i),
2460: l_cont_tab(i),
2461: l_last_line_flag,
2462: x_return_status);

Line 2491: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);

2487: --dbms_output.put_line('calling check cont attr with ' || l_cont_tab(i));
2488:
2489: --
2490: IF l_debug_on THEN
2491: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
2492: END IF;
2493: --
2494: wsh_container_actions.Check_Cont_Attributes (
2495: l_cont_tab(i),

Line 2494: wsh_container_actions.Check_Cont_Attributes (

2490: IF l_debug_on THEN
2491: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
2492: END IF;
2493: --
2494: wsh_container_actions.Check_Cont_Attributes (
2495: l_cont_tab(i),
2496: l_attr_flag,
2497: x_return_status);
2498: --

Line 2587: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);

2583: END IF;
2584:
2585: --
2586: IF l_debug_on THEN
2587: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
2588: END IF;
2589: --
2590: wsh_container_actions.Update_Cont_Hierarchy (
2591: l_cont_tab(i),

Line 2590: wsh_container_actions.Update_Cont_Hierarchy (

2586: IF l_debug_on THEN
2587: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
2588: END IF;
2589: --
2590: wsh_container_actions.Update_Cont_Hierarchy (
2591: l_cont_tab(i),
2592: NULL,
2593: l_cont_tab(i),
2594: x_return_status);

Line 2697: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.LAST_ASSIGNED_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);

2693: -- Last_Assigned_Line and Check_Cont_Attributes will be called only if the container belongs to a delivery.
2694: IF (nvl(l_delivery_id,-99) = -99) THEN --{ Delivery Check
2695: --
2696: IF l_debug_on THEN
2697: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.LAST_ASSIGNED_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
2698: END IF;
2699: --
2700: wsh_container_actions.Last_Assigned_Line (
2701: NULL,

Line 2700: wsh_container_actions.Last_Assigned_Line (

2696: IF l_debug_on THEN
2697: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.LAST_ASSIGNED_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
2698: END IF;
2699: --
2700: wsh_container_actions.Last_Assigned_Line (
2701: NULL,
2702: l_del_detail_rec(i),
2703: l_last_line_flag,
2704: x_return_status);

Line 2732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);

2728: --dbms_output.put_line('calling check cont attr with ' || l_del_detail_rec(i));
2729:
2730: --
2731: IF l_debug_on THEN
2732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
2733: END IF;
2734: --
2735: wsh_container_actions.Check_Cont_Attributes (
2736: l_del_detail_rec(i),

Line 2735: wsh_container_actions.Check_Cont_Attributes (

2731: IF l_debug_on THEN
2732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
2733: END IF;
2734: --
2735: wsh_container_actions.Check_Cont_Attributes (
2736: l_del_detail_rec(i),
2737: l_attr_flag,
2738: x_return_status);
2739: --

Line 2824: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);

2820: END IF;
2821:
2822: --
2823: IF l_debug_on THEN
2824: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
2825: END IF;
2826: --
2827: wsh_container_actions.Update_Cont_Hierarchy (
2828: l_del_detail_rec(i),

Line 2827: wsh_container_actions.Update_Cont_Hierarchy (

2823: IF l_debug_on THEN
2824: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
2825: END IF;
2826: --
2827: wsh_container_actions.Update_Cont_Hierarchy (
2828: l_del_detail_rec(i),
2829: NULL,
2830: l_del_detail_rec(i),
2831: x_return_status);

Line 3081: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Unassign_Detail',l_module_name);

3077: --
3078: EXCEPTION
3079:
3080: WHEN Others THEN
3081: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Unassign_Detail',l_module_name);
3082: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3083:
3084: --
3085: IF l_debug_on THEN

Line 3135: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.Unassign_Detail',WSH_DEBUG_SV.C_PROC_LEVEL);

3131: END IF;
3132: --
3133: --
3134: IF l_debug_on THEN
3135: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.Unassign_Detail',WSH_DEBUG_SV.C_PROC_LEVEL);
3136: END IF;
3137: --
3138: Unassign_Detail
3139: (

Line 3157: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Unassign_Detail',l_module_name);

3153: --
3154: EXCEPTION
3155:
3156: WHEN Others THEN
3157: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Unassign_Detail',l_module_name);
3158: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3159: --
3160: IF l_debug_on THEN
3161: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3301: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_DELIVERY_ASSIGNMENT',WSH_DEBUG_SV.C_PROC_LEVEL);

3297: IF l_cont_org = l_del_org THEN
3298:
3299: --
3300: IF l_debug_on THEN
3301: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_DELIVERY_ASSIGNMENT',WSH_DEBUG_SV.C_PROC_LEVEL);
3302: END IF;
3303: --
3304: wsh_container_actions.Create_Delivery_Assignment(
3305: p_container_instance_id,

Line 3304: wsh_container_actions.Create_Delivery_Assignment(

3300: IF l_debug_on THEN
3301: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_DELIVERY_ASSIGNMENT',WSH_DEBUG_SV.C_PROC_LEVEL);
3302: END IF;
3303: --
3304: wsh_container_actions.Create_Delivery_Assignment(
3305: p_container_instance_id,
3306: p_delivery_id,
3307: x_return_status,
3308: x_dlvy_has_lines,

Line 3363: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Assign_To_Delivery',l_module_name);

3359: --
3360: EXCEPTION
3361:
3362: WHEN Others THEN
3363: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Assign_To_Delivery',l_module_name);
3364: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3365:
3366: --
3367: IF l_debug_on THEN

Line 3433: wsh_util_core.default_handler('WSH_CONTAINER_ACTIONS.Assign_To_Delivery',l_module_name);

3429: --
3430: EXCEPTION
3431: WHEN others THEN
3432: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3433: wsh_util_core.default_handler('WSH_CONTAINER_ACTIONS.Assign_To_Delivery',l_module_name);
3434: --
3435: IF l_debug_on THEN
3436: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3437: END IF;

Line 3522: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Delivery_Assignment',l_module_name);

3518: END IF;
3519: --
3520: EXCEPTION
3521: WHEN Others THEN
3522: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Delivery_Assignment',l_module_name);
3523: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3524: --
3525: IF l_debug_on THEN
3526: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3591: wsh_util_core.default_handler('WSH_CONTAINER_ACTIONS.Create_Delivery_Assignment',l_module_name);

3587: --
3588: EXCEPTION
3589: WHEN others THEN
3590: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3591: wsh_util_core.default_handler('WSH_CONTAINER_ACTIONS.Create_Delivery_Assignment',l_module_name);
3592: --
3593: IF l_debug_on THEN
3594: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3595: END IF;

Line 3972: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);

3968: END IF;
3969:
3970: --
3971: IF l_debug_on THEN
3972: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
3973: END IF;
3974: --
3975: wsh_container_actions.Check_Cont_Attributes (
3976: p_det_cont_inst_id,

Line 3975: wsh_container_actions.Check_Cont_Attributes (

3971: IF l_debug_on THEN
3972: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
3973: END IF;
3974: --
3975: wsh_container_actions.Check_Cont_Attributes (
3976: p_det_cont_inst_id,
3977: l_det_attr_flag,
3978: x_return_status);
3979:

Line 3998: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);

3994:
3995:
3996: --
3997: IF l_debug_on THEN
3998: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
3999: END IF;
4000: --
4001: wsh_container_actions.Check_Cont_Attributes (
4002: p_par_cont_inst_id,

Line 4001: wsh_container_actions.Check_Cont_Attributes (

3997: IF l_debug_on THEN
3998: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
3999: END IF;
4000: --
4001: wsh_container_actions.Check_Cont_Attributes (
4002: p_par_cont_inst_id,
4003: l_par_attr_flag,
4004: x_return_status);
4005:

Line 4116: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);

4112: --
4113: -- Debug Statements
4114: --
4115: IF l_debug_on THEN
4116: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
4117: END IF;
4118: --
4119: wsh_container_actions.Update_Cont_Hierarchy (
4120: p_par_cont_inst_id,

Line 4119: wsh_container_actions.Update_Cont_Hierarchy (

4115: IF l_debug_on THEN
4116: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
4117: END IF;
4118: --
4119: wsh_container_actions.Update_Cont_Hierarchy (
4120: p_par_cont_inst_id,
4121: l_det_del_id,
4122: p_det_cont_inst_id,
4123: x_return_status );

Line 4204: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);

4200: END IF;
4201:
4202: --
4203: IF l_debug_on THEN
4204: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
4205: END IF;
4206: --
4207: wsh_container_actions.Update_Cont_Hierarchy (
4208: p_det_cont_inst_id,

Line 4207: wsh_container_actions.Update_Cont_Hierarchy (

4203: IF l_debug_on THEN
4204: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
4205: END IF;
4206: --
4207: wsh_container_actions.Update_Cont_Hierarchy (
4208: p_det_cont_inst_id,
4209: l_par_del_id,
4210: p_par_cont_inst_id,
4211: x_return_status );

Line 4393: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Assign_To_Container',l_module_name);

4389: --
4390: EXCEPTION
4391:
4392: WHEN Others THEN
4393: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Assign_To_Container',l_module_name);
4394: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4395:
4396: --
4397: IF l_debug_on THEN

Line 4577: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Get_Cont_Load_Vol_info returned '||x_return_status||' with error count '||x_error_cnt);

4573: x_max_vol := g_cont_msi_tab(p_container_item_id).mtl_max_vol;
4574: x_wt_uom := g_cont_msi_tab(p_container_item_id).mtl_wt_uom;
4575: x_vol_uom := g_cont_msi_tab(p_container_item_id).mtl_vol_uom;
4576: --x_inventory_item_status_code := g_cont_msi_tab(p_container_item_id).inventory_item_status_code;
4577: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Get_Cont_Load_Vol_info returned '||x_return_status||' with error count '||x_error_cnt);
4578:
4579: --
4580: IF l_debug_on THEN
4581: WSH_DEBUG_SV.log(l_module_name,'MAX LOAD',x_max_load);

Line 4593: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Get_Cont_Load_Vol_info',l_module_name);

4589: WHEN Others THEN
4590: IF (Get_Cont_Msi%ISOPEN) THEN
4591: CLOSE Get_Cont_Msi;
4592: END IF;
4593: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Get_Cont_Load_Vol_info',l_module_name);
4594: x_return_status := C_UNEXP_ERROR_STATUS;
4595:
4596: --
4597: IF l_debug_on THEN

Line 4669: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Calc_Fill_Basis_and_proc_flag returned '||x_return_status);

4665: -- HW OPMCONV - No need to populate this value
4666: -- x_process_flag := l_param_info.process_flag;
4667: END IF;
4668:
4669: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Calc_Fill_Basis_and_proc_flag returned '||x_return_status);
4670:
4671: --
4672: IF l_debug_on THEN
4673: WSH_DEBUG_SV.pop(l_module_name);

Line 4685: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Calc_Fill_Basis_and_proc_flag',l_module_name);

4681: END IF;
4682: --
4683: EXCEPTION
4684: WHEN Others THEN
4685: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Calc_Fill_Basis_and_proc_flag',l_module_name);
4686: x_return_status := C_UNEXP_ERROR_STATUS;
4687: --
4688: IF l_debug_on THEN
4689: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4817: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Calc_Pref_Container returned '||x_return_status||' with error count '||x_error_cnt);

4813: --dbms_output.put_line('Caching Cont/Load info');
4814: END IF;
4815: x_cont_item_id := g_cache_cont_load_info_tab(p_inventory_item_id).cont_item_id;
4816: x_max_load_qty := g_cache_cont_load_info_tab(p_inventory_item_id).max_load_qty;
4817: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Calc_Pref_Container returned '||x_return_status||' with error count '||x_error_cnt);
4818:
4819: --
4820: IF l_debug_on THEN
4821: WSH_DEBUG_SV.pop(l_module_name);

Line 4836: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Calc_Pref_Container',l_module_name);

4832: WHEN Others THEN
4833: IF (Get_Cont_Load%ISOPEN) THEN
4834: CLOSE Get_Cont_Load;
4835: END IF;
4836: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Calc_Pref_Container',l_module_name);
4837: x_return_status := C_UNEXP_ERROR_STATUS;
4838:
4839: --
4840: IF l_debug_on THEN

Line 4859: p_line_cont_rec IN wsh_container_actions.line_cont_info,

4855: ------------------------------------------------------------------------------
4856: */
4857:
4858: PROCEDURE Pack_Delivery_Detail(
4859: p_line_cont_rec IN wsh_container_actions.line_cont_info,
4860: x_return_status OUT NOCOPY VARCHAR2) IS
4861:
4862: l_mtl_max_load NUMBER;
4863: l_mtl_max_vol NUMBER;

Line 5535: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Pack_Delivery_Detail',l_module_name);

5531: RETURN;
5532:
5533: EXCEPTION
5534: WHEN Others THEN
5535: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Pack_Delivery_Detail',l_module_name);
5536: x_return_status := C_UNEXP_ERROR_STATUS;
5537:
5538: --
5539: IF l_debug_on THEN

Line 5568: x_line_cont_tab OUT NOCOPY wsh_container_actions.line_cont_info_tab,

5564:
5565: PROCEDURE Validate_Dd_for_Pack(
5566: p_group_id_tab IN WSH_UTIL_CORE.id_tab_type,
5567: p_del_detail_tab IN WSH_UTIL_CORE.id_tab_type,
5568: x_line_cont_tab OUT NOCOPY wsh_container_actions.line_cont_info_tab,
5569: x_error_cnt OUT NOCOPY NUMBER,
5570: x_warn_cnt OUT NOCOPY NUMBER,
5571: x_fill_pc_warn_cnt OUT NOCOPY NUMBER, -- bug 3562797 jckwok
5572: x_release_warn_cnt OUT NOCOPY NUMBER) IS

Line 6316: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Validate_Dd_For_Pack',l_module_name);

6312: END IF;
6313: IF (Get_Cont_Item_Load%ISOPEN) THEN
6314: CLOSE Get_Cont_Item_Load;
6315: END IF;
6316: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Validate_Dd_For_Pack',l_module_name);
6317: --
6318: IF l_debug_on THEN
6319: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6320: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 6450: --l_cont_tab wsh_container_actions.cont_inst_tab;

6446: l_fill_pc_warn_count NUMBER := 0; -- bug 3562797 jckwok
6447: l_error_cnt NUMBER := 0;
6448:
6449: l_new_contid_count NUMBER := 0;
6450: --l_cont_tab wsh_container_actions.cont_inst_tab;
6451: l_cont_tab WSH_UTIL_CORE.id_tab_type;
6452:
6453: TYPE NumList IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6454: TYPE CharList IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;

Line 6572: --dbms_output.put_line('Start of WSH_CONTAINER_ACTIONS.Auto_Pack_Lines...');

6568: --dbms_output.put_line('==================================================');
6569: --dbms_output.put_line(' AUTO PACK LINES ');
6570: --dbms_output.put_line('==================================================');
6571:
6572: --dbms_output.put_line('Start of WSH_CONTAINER_ACTIONS.Auto_Pack_Lines...');
6573: -- Delete all Global PL/SQL tables to start with
6574: --
6575: --
6576:

Line 6810: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_CONT_INSTANCE_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);

6806: l_cont_name := null;
6807:
6808: --
6809: IF l_debug_on THEN
6810: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_CONT_INSTANCE_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);
6811: WSH_DEBUG_SV.logmsg(l_module_name,'Number of Containers'||g_new_container_tab(cnt).number_of_containers);
6812: WSH_DEBUG_SV.log(l_module_name,'Create Container'||g_new_container_tab(cnt).container_item_id||'<'||g_new_container_tab(cnt).organization_id||'>'||g_new_container_tab(cnt).number_of_containers);
6813: END IF;
6814: --

Line 6815: wsh_container_actions.Create_Cont_Instance_Multi (

6811: WSH_DEBUG_SV.logmsg(l_module_name,'Number of Containers'||g_new_container_tab(cnt).number_of_containers);
6812: WSH_DEBUG_SV.log(l_module_name,'Create Container'||g_new_container_tab(cnt).container_item_id||'<'||g_new_container_tab(cnt).organization_id||'>'||g_new_container_tab(cnt).number_of_containers);
6813: END IF;
6814: --
6815: wsh_container_actions.Create_Cont_Instance_Multi (
6816: x_cont_name => l_cont_name,
6817: p_cont_item_id => g_new_container_tab(cnt).container_item_id,
6818: x_cont_instance_id => l_cont_instance_id,
6819: p_par_detail_id => NULL,

Line 7857: -- 100.1 Call WSH_CONTAINER_ACTIONS.Auto_Pack_Conts depending on

7853: IF l_debug_on THEN
7854: WSH_DEBUG_SV.logmsg(l_module_name,'2L ret status -'||l_return_status);
7855: WSH_DEBUG_SV.logmsg(l_module_name,'2X ret status -'||x_return_status);
7856: END IF;
7857: -- 100.1 Call WSH_CONTAINER_ACTIONS.Auto_Pack_Conts depending on
7858: -- p_pack_cont_flag and if new detail containers are created
7859: IF l_detail_cont_tab.count > 0 AND p_pack_cont_flag = 'Y' THEN
7860:
7861: l_group_id_tab.delete;

Line 7866: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_CONTS',WSH_DEBUG_SV.C_PROC_LEVEL);

7862:
7863: --dbms_output.put_line('Calling AUTO PACK CONTS With x_cont_instance count of ' || x_cont_instance_tab.count);
7864: --
7865: IF l_debug_on THEN
7866: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_CONTS',WSH_DEBUG_SV.C_PROC_LEVEL);
7867: END IF;
7868: --
7869: wsh_container_actions.Auto_Pack_Conts (
7870: l_group_id_tab,

Line 7869: wsh_container_actions.Auto_Pack_Conts (

7865: IF l_debug_on THEN
7866: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_CONTS',WSH_DEBUG_SV.C_PROC_LEVEL);
7867: END IF;
7868: --
7869: wsh_container_actions.Auto_Pack_Conts (
7870: l_group_id_tab,
7871: l_detail_cont_tab,
7872: x_cont_instance_tab,
7873: l_mast_cont_tab,

Line 7901: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Auto_Pack_Conts created '||l_mast_cont_tab.COUNT||' Master Containers');

7897: x_return_status := C_WARNING_STATUS;
7898: END IF;
7899: END IF;
7900:
7901: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Auto_Pack_Conts created '||l_mast_cont_tab.COUNT||' Master Containers');
7902: IF l_mast_cont_tab.COUNT > 0 THEN
7903: i := 1;
7904: cnt := x_cont_instance_tab.COUNT;
7905: WHILE i <= l_mast_cont_tab.COUNT LOOP

Line 7962: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Auto_Pack_Lines',l_module_name);

7958: CLOSE c_get_tare_weight;
7959: END IF;
7960: -- End of OTM R12 : assign delivery detail
7961:
7962: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Auto_Pack_Lines',l_module_name);
7963: x_return_status := C_UNEXP_ERROR_STATUS;
7964:
7965: --
7966: IF l_debug_on THEN

Line 8138: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_LINES',WSH_DEBUG_SV.C_PROC_LEVEL);

8134: ELSE
8135:
8136: --
8137: IF l_debug_on THEN
8138: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_LINES',WSH_DEBUG_SV.C_PROC_LEVEL);
8139: END IF;
8140: --
8141:
8142: wsh_container_actions.Auto_Pack_Lines (

Line 8142: wsh_container_actions.Auto_Pack_Lines (

8138: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_LINES',WSH_DEBUG_SV.C_PROC_LEVEL);
8139: END IF;
8140: --
8141:
8142: wsh_container_actions.Auto_Pack_Lines (
8143: l_group_id_tab,
8144: l_del_detail_tab,
8145: p_pack_cont_flag,
8146: l_cont_instance_tab,

Line 8150: WSH_DEBUG_SV.log(l_module_name,'Return status from wsh_container_actions.Auto_Pack_Lines -',l_return_status);

8146: l_cont_instance_tab,
8147: l_return_status);
8148:
8149: IF l_debug_on THEN
8150: WSH_DEBUG_SV.log(l_module_name,'Return status from wsh_container_actions.Auto_Pack_Lines -',l_return_status);
8151: END IF;
8152: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
8153: --dbms_output.put_line('autopack lines failed');
8154: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 8327: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Auto_Pack_Delivery',l_module_name);

8323: END IF;
8324:
8325: WHEN Others THEN
8326: --
8327: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Auto_Pack_Delivery',l_module_name);
8328: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
8329:
8330: IF l_debug_on THEN
8331: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS FROM WHEN OTHERS',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 9021: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

9017: l_tmp_det_tab(1) := l_det_tab(j).delivery_detail_id;
9018:
9019: IF l_debug_on THEN
9020: WSH_DEBUG_SV.log(l_module_name,'assigning detail ' || l_tmp_det_tab(1) || ' to container ' || l_cont_tab(i).container_instance_id);
9021: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
9022: END IF;
9023:
9024: --
9025: wsh_container_actions.Assign_Detail (

Line 9025: wsh_container_actions.Assign_Detail (

9021: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
9022: END IF;
9023:
9024: --
9025: wsh_container_actions.Assign_Detail (
9026: l_cont_tab(i).container_instance_id,
9027: l_tmp_det_tab,
9028: l_pack_status,
9029: x_return_status,FALSE);

Line 9206: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

9202:
9203: END IF;
9204: --
9205: IF l_debug_on THEN
9206: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
9207: END IF;
9208: --
9209: wsh_container_actions.Assign_Detail (
9210: l_cont_tab(i).container_instance_id,

Line 9209: wsh_container_actions.Assign_Detail (

9205: IF l_debug_on THEN
9206: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
9207: END IF;
9208: --
9209: wsh_container_actions.Assign_Detail (
9210: l_cont_tab(i).container_instance_id,
9211: l_tmp_det_tab,
9212: l_pack_status,
9213: x_return_status,FALSE);

Line 9542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

9538: --dbms_output.put_line('* * * ASSIGNING detail ' || l_tmp_det_tab(1) || ' to container ' || l_cont_tab(i).container_instance_id);
9539:
9540: --
9541: IF l_debug_on THEN
9542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
9543: END IF;
9544: --
9545: wsh_container_actions.Assign_Detail (
9546: l_cont_tab(i).container_instance_id,

Line 9545: wsh_container_actions.Assign_Detail (

9541: IF l_debug_on THEN
9542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
9543: END IF;
9544: --
9545: wsh_container_actions.Assign_Detail (
9546: l_cont_tab(i).container_instance_id,
9547: l_tmp_det_tab,
9548: l_pack_status,
9549: x_return_status,FALSE);

Line 10055: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Pack_Multi',l_module_name);

10051: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');
10052: END IF;
10053: WHEN Others THEN
10054: --
10055: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Pack_Multi',l_module_name);
10056: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
10057: --
10058: IF l_debug_on THEN
10059: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 10302: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_Shipped_Qty',l_module_name);

10298: --
10299: EXCEPTION
10300:
10301: WHEN Others THEN
10302: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_Shipped_Qty',l_module_name);
10303: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
10304:
10305: --
10306: IF l_debug_on THEN

Line 10516: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Pack_Container',l_module_name);

10512: END IF;
10513: --
10514: EXCEPTION
10515: WHEN Others THEN
10516: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Pack_Container',l_module_name);
10517: x_return_status := C_UNEXP_ERROR_STATUS;
10518:
10519: --
10520: IF l_debug_on THEN

Line 10549: p_mast_cont_info_tab IN wsh_container_actions.empty_cont_info_tab,

10545:
10546: PROCEDURE Validate_Container_For_Pack(
10547: p_group_id_tab IN WSH_UTIL_CORE.id_tab_type,
10548: p_cont_info_tab IN wsh_util_core.id_tab_type,
10549: p_mast_cont_info_tab IN wsh_container_actions.empty_cont_info_tab,
10550: x_line_cont_tab OUT NOCOPY wsh_container_actions.cont_info_tab,
10551: x_error_cnt OUT NOCOPY NUMBER,
10552: x_warn_cnt OUT NOCOPY NUMBER,
10553: x_fill_pc_warn_cnt OUT NOCOPY NUMBER -- bug 3421823

Line 10550: x_line_cont_tab OUT NOCOPY wsh_container_actions.cont_info_tab,

10546: PROCEDURE Validate_Container_For_Pack(
10547: p_group_id_tab IN WSH_UTIL_CORE.id_tab_type,
10548: p_cont_info_tab IN wsh_util_core.id_tab_type,
10549: p_mast_cont_info_tab IN wsh_container_actions.empty_cont_info_tab,
10550: x_line_cont_tab OUT NOCOPY wsh_container_actions.cont_info_tab,
10551: x_error_cnt OUT NOCOPY NUMBER,
10552: x_warn_cnt OUT NOCOPY NUMBER,
10553: x_fill_pc_warn_cnt OUT NOCOPY NUMBER -- bug 3421823
10554: ) IS

Line 10580: line_cont_rec wsh_container_actions.cont_info;

10576: WHERE load_item_id = v_inv_item_id
10577: AND container_item_id = v_cont_item_id
10578: AND master_organization_id = v_organization_id;
10579:
10580: line_cont_rec wsh_container_actions.cont_info;
10581: line_cont_tab wsh_container_actions.cont_info_tab;
10582:
10583: l_return_status VARCHAR2(1);
10584: l_last_organization_id NUMBER;

Line 10581: line_cont_tab wsh_container_actions.cont_info_tab;

10577: AND container_item_id = v_cont_item_id
10578: AND master_organization_id = v_organization_id;
10579:
10580: line_cont_rec wsh_container_actions.cont_info;
10581: line_cont_tab wsh_container_actions.cont_info_tab;
10582:
10583: l_return_status VARCHAR2(1);
10584: l_last_organization_id NUMBER;
10585: l_dd_count NUMBER;

Line 11110: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Validate_Container_For_Pack',l_module_name);

11106: END IF;
11107: IF (Get_Cont_Item_Load%ISOPEN) THEN
11108: CLOSE Get_Cont_Item_Load;
11109: END IF;
11110: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Validate_Container_For_Pack',l_module_name);
11111: --
11112: IF l_debug_on THEN
11113: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
11114: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 11155: p_cont_info_tab IN wsh_container_actions.empty_cont_info_tab,

11151: */
11152:
11153: PROCEDURE Auto_Pack_Conts (
11154: p_group_id_tab IN WSH_UTIL_CORE.id_tab_type,
11155: p_cont_info_tab IN wsh_container_actions.empty_cont_info_tab,
11156: p_cont_detail_tab IN WSH_UTIL_CORE.id_tab_type,
11157: x_cont_instance_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
11158: x_return_status OUT NOCOPY VARCHAR2) IS
11159:

Line 11160: line_cont_rec wsh_container_actions.cont_info;

11156: p_cont_detail_tab IN WSH_UTIL_CORE.id_tab_type,
11157: x_cont_instance_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
11158: x_return_status OUT NOCOPY VARCHAR2) IS
11159:
11160: line_cont_rec wsh_container_actions.cont_info;
11161: line_cont_tab wsh_container_actions.cont_info_tab;
11162:
11163: l_group_id_temp_tab WSH_UTIL_CORE.id_tab_type;
11164: l_group_id_tab WSH_UTIL_CORE.id_tab_type;

Line 11161: line_cont_tab wsh_container_actions.cont_info_tab;

11157: x_cont_instance_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
11158: x_return_status OUT NOCOPY VARCHAR2) IS
11159:
11160: line_cont_rec wsh_container_actions.cont_info;
11161: line_cont_tab wsh_container_actions.cont_info_tab;
11162:
11163: l_group_id_temp_tab WSH_UTIL_CORE.id_tab_type;
11164: l_group_id_tab WSH_UTIL_CORE.id_tab_type;
11165: l_del_row_tab WSH_UTIL_CORE.id_tab_type;

Line 11224: --dbms_output.put_line('Start of WSH_CONTAINER_ACTIONS.Auto_Pack_Conts...');

11220: --
11221: BEGIN
11222:
11223: --dbms_output.put_line('==================================================');
11224: --dbms_output.put_line('Start of WSH_CONTAINER_ACTIONS.Auto_Pack_Conts...');
11225: --dbms_output.put_line('==================================================');
11226:
11227: -- Delete all Global PL/SQL tables to start with
11228: --

Line 11422: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_CONT_INSTANCE_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);

11418:
11419: --
11420: -- K LPN CONV. rv
11421: IF l_debug_on THEN
11422: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_CONT_INSTANCE_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);
11423: END IF;
11424: --
11425: WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi(
11426: x_cont_name => l_cont_name,

Line 11425: WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi(

11421: IF l_debug_on THEN
11422: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_CONT_INSTANCE_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);
11423: END IF;
11424: --
11425: WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi(
11426: x_cont_name => l_cont_name,
11427: p_cont_item_id => g_new_container_tab(cnt).container_item_id,
11428: x_cont_instance_id => l_cont_instance_id,
11429: p_par_detail_id => NULL,

Line 11558: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_TO_CONTAINER',WSH_DEBUG_SV.C_PROC_LEVEL);

11554:
11555: IF (l_cont_instance_id is NOT NULL) THEN
11556: --
11557: IF l_debug_on THEN
11558: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_TO_CONTAINER',WSH_DEBUG_SV.C_PROC_LEVEL);
11559: END IF;
11560: --
11561: wsh_container_actions.Assign_To_Container (
11562: p_det_cont_inst_id => g_assign_detail_tab(cnt).delivery_detail_id,

Line 11561: wsh_container_actions.Assign_To_Container (

11557: IF l_debug_on THEN
11558: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_TO_CONTAINER',WSH_DEBUG_SV.C_PROC_LEVEL);
11559: END IF;
11560: --
11561: wsh_container_actions.Assign_To_Container (
11562: p_det_cont_inst_id => g_assign_detail_tab(cnt).delivery_detail_id,
11563: p_par_cont_inst_id => l_cont_instance_id,
11564: x_return_status => l_return_status);
11565: IF l_debug_on THEN

Line 11569: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Assign_To_Container returned '||l_return_status);

11565: IF l_debug_on THEN
11566: WSH_DEBUG_SV.log(l_module_name,'return status',l_return_status);
11567: END IF;
11568:
11569: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Assign_To_Container returned '||l_return_status);
11570: IF l_return_status = C_ERROR_STATUS THEN
11571: error_cnt := error_cnt + 1;
11572: ELSIF l_return_status = C_WARNING_STATUS THEN
11573: warn_cnt := warn_cnt + 1;

Line 11627: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Auto_Pack_conts',l_module_name);

11623: END IF;
11624: --
11625: EXCEPTION
11626: WHEN Others THEN
11627: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Auto_Pack_conts',l_module_name);
11628: x_return_status := C_UNEXP_ERROR_STATUS;
11629:
11630: --
11631: IF l_debug_on THEN

Line 11960: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_Cont_Attributes',l_module_name);

11956: --
11957: EXCEPTION
11958:
11959: WHEN Others THEN
11960: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_Cont_Attributes',l_module_name);
11961: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
11962:
11963: --
11964: IF l_debug_on THEN

Line 12116: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Check_Cont_Attributes',l_module_name);

12112: --
12113: EXCEPTION
12114:
12115: WHEN Others THEN
12116: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Check_Cont_Attributes',l_module_name);
12117: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
12118:
12119: --
12120: IF l_debug_on THEN

Line 12233: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);

12229: --dbms_output.put_line('calling update cont attr with ' || cont.delivery_detail_id);
12230:
12231: --
12232: IF l_debug_on THEN
12233: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
12234: END IF;
12235: --
12236: wsh_container_actions.Update_Cont_Attributes (
12237: p_del_detail_id,

Line 12236: wsh_container_actions.Update_Cont_Attributes (

12232: IF l_debug_on THEN
12233: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
12234: END IF;
12235: --
12236: wsh_container_actions.Update_Cont_Attributes (
12237: p_del_detail_id,
12238: p_delivery_id,
12239: cont.delivery_detail_id,
12240: l_return_status);

Line 12286: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_Cont_Hierarchy',l_module_name);

12282: --
12283: EXCEPTION
12284:
12285: WHEN Others THEN
12286: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_Cont_Hierarchy',l_module_name);
12287: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
12288:
12289: --
12290: IF l_debug_on THEN

Line 12434: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Last_Assigned_Line',l_module_name);

12430: --
12431: EXCEPTION
12432:
12433: WHEN Others THEN
12434: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Last_Assigned_Line',l_module_name);
12435: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
12436:
12437: --
12438: IF l_debug_on THEN

Line 12687: WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi(

12683: --
12684: --
12685: -- K LPN CONV. rv
12686: --
12687: WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi(
12688: x_cont_name => l_cont_name,
12689: p_cont_item_id => NULL,
12690: x_cont_instance_id => l_container_instance_id,
12691: p_par_detail_id => NULL,

Line 12912: wsh_util_core.default_handler('wsh_container_actions.pack_inbound_lines', l_module_name);

12908:
12909: G_CALLED_FROM_INBOUND := FALSE;
12910: ROLLBACK TO pack_inbound_lines_sp;
12911: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
12912: wsh_util_core.default_handler('wsh_container_actions.pack_inbound_lines', l_module_name);
12913: IF l_debug_on THEN
12914: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
12915: END IF;
12916: --

Line 13118: wsh_util_core.default_handler('wsh_container_actions.unpack_inbound_delivery', l_module_name);

13114: WHEN OTHERS THEN
13115:
13116: ROLLBACK TO unpack_inbound_delivery_sp;
13117: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
13118: wsh_util_core.default_handler('wsh_container_actions.unpack_inbound_delivery', l_module_name);
13119: IF l_debug_on THEN
13120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
13121: END IF;
13122: --

Line 13255: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Multiple_Cont_names',l_module_name);

13251: --
13252: EXCEPTION
13253:
13254: WHEN Others THEN
13255: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Multiple_Cont_names',l_module_name);
13256: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
13257:
13258:
13259: IF l_debug_on THEN

Line 13365: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_child_inv_info',l_module_name);

13361: END IF;
13362: --
13363: WHEN Others THEN
13364: rollback to s_Update_child_inv_info;
13365: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_child_inv_info',l_module_name);
13366: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
13367:
13368:
13369: IF l_debug_on THEN

Line 14231: wsh_util_core.default_handler('wsh_container_actions.Assign_Container_to_Consol', l_module_name);

14227:
14228: WHEN OTHERS THEN
14229:
14230: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
14231: wsh_util_core.default_handler('wsh_container_actions.Assign_Container_to_Consol', l_module_name);
14232: IF l_debug_on THEN
14233: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
14234: END IF;
14235:

Line 14513: wsh_util_core.default_handler('wsh_container_actions.unassign_detail_from_consol',l_module_name);

14509: END IF;
14510: --
14511:
14512: WHEN OTHERS THEN
14513: wsh_util_core.default_handler('wsh_container_actions.unassign_detail_from_consol',l_module_name);
14514: --
14515: IF l_debug_on THEN
14516: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
14517: END IF;

Line 14595: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Get_Deliver_To_Location',l_module_name);

14591:
14592: EXCEPTION
14593:
14594: WHEN Others THEN
14595: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Get_Deliver_To_Location',l_module_name);
14596: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
14597:
14598: --
14599: IF l_debug_on THEN

Line 14606: END wsh_container_actions;

14602: END IF;
14603:
14604: END Get_Deliver_To_Location;
14605:
14606: END wsh_container_actions;