DBA Data[Home] [Help]

APPS.WSH_USA_INV_PVT dependencies on WSH_WMS_LPN_GRP

Line 345: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

341: END IF;
342:
343: l_wms_org := wsh_util_validate.check_wms_org(l_cnt_orgn_id);
344:
345: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
346: AND p_backorder_rec_tbl(i).line_direction IN ('O', 'IO')
347: AND
348: (
349: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')

Line 349: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')

345: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
346: AND p_backorder_rec_tbl(i).line_direction IN ('O', 'IO')
347: AND
348: (
349: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')
350: OR
351: (WSH_WMS_LPN_GRP.GK_INV_UNPACK and l_wms_org = 'N')
352: )
353: THEN

Line 351: (WSH_WMS_LPN_GRP.GK_INV_UNPACK and l_wms_org = 'N')

347: AND
348: (
349: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')
350: OR
351: (WSH_WMS_LPN_GRP.GK_INV_UNPACK and l_wms_org = 'N')
352: )
353: THEN
354: --{
355: --

Line 3664: l_original_caller VARCHAR2(100) := WSH_WMS_LPN_GRP.g_caller;

3660: l_backordered_item_id NUMBER;
3661: l_top_model_item_id NUMBER;
3662:
3663: -- LPN CONV rv
3664: l_original_caller VARCHAR2(100) := WSH_WMS_LPN_GRP.g_caller;
3665: l_orig_callback_reqd VARCHAR2(100) := WSH_WMS_LPN_GRP.g_callback_required;
3666: -- LPN CONV rv
3667:
3668: --Bug 3878429: treat fnd_api.g_miss_num in pending_quantity2 as zero

Line 3665: l_orig_callback_reqd VARCHAR2(100) := WSH_WMS_LPN_GRP.g_callback_required;

3661: l_top_model_item_id NUMBER;
3662:
3663: -- LPN CONV rv
3664: l_original_caller VARCHAR2(100) := WSH_WMS_LPN_GRP.g_caller;
3665: l_orig_callback_reqd VARCHAR2(100) := WSH_WMS_LPN_GRP.g_callback_required;
3666: -- LPN CONV rv
3667:
3668: --Bug 3878429: treat fnd_api.g_miss_num in pending_quantity2 as zero
3669: l_pending_quantity2 NUMBER;

Line 5373: WSH_WMS_LPN_GRP.g_caller := 'WMS';

5369: END IF ;--}
5370:
5371: --
5372: -- LPN CONV rv
5373: WSH_WMS_LPN_GRP.g_caller := 'WMS';
5374: WSH_WMS_LPN_GRP.g_callback_required := 'N';
5375: -- LPN CONV rv
5376: --
5377: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Detail_To_Cont (

Line 5374: WSH_WMS_LPN_GRP.g_callback_required := 'N';

5370:
5371: --
5372: -- LPN CONV rv
5373: WSH_WMS_LPN_GRP.g_caller := 'WMS';
5374: WSH_WMS_LPN_GRP.g_callback_required := 'N';
5375: -- LPN CONV rv
5376: --
5377: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Detail_To_Cont (
5378: p_changed_attributes(l_Counter).delivery_detail_id,

Line 5405: WSH_WMS_LPN_GRP.g_caller := l_original_caller;

5401:
5402: --}
5403: END IF;
5404:
5405: WSH_WMS_LPN_GRP.g_caller := l_original_caller;
5406: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;
5407: -- LPN CONV rv
5408: --
5409: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,

Line 5406: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;

5402: --}
5403: END IF;
5404:
5405: WSH_WMS_LPN_GRP.g_caller := l_original_caller;
5406: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;
5407: -- LPN CONV rv
5408: --
5409: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
5410: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

Line 6395: WSH_WMS_LPN_GRP.g_caller := l_original_caller;

6391: WHEN Delivery_Line_Direction_Err THEN
6392: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6393: --
6394: -- LPN CONV rv
6395: WSH_WMS_LPN_GRP.g_caller := l_original_caller;
6396: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;
6397: -- LPN CONV rv
6398: --
6399: IF l_debug_on THEN

Line 6396: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;

6392: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6393: --
6394: -- LPN CONV rv
6395: WSH_WMS_LPN_GRP.g_caller := l_original_caller;
6396: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;
6397: -- LPN CONV rv
6398: --
6399: IF l_debug_on THEN
6400: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Delivery_Line_Direction_Err');

Line 6410: WSH_WMS_LPN_GRP.g_caller := l_original_caller;

6406: x_return_status := l_return_status;
6407:
6408: --
6409: -- LPN CONV rv
6410: WSH_WMS_LPN_GRP.g_caller := l_original_caller;
6411: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;
6412: -- LPN CONV rv
6413: --
6414: IF l_debug_on THEN

Line 6411: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;

6407:
6408: --
6409: -- LPN CONV rv
6410: WSH_WMS_LPN_GRP.g_caller := l_original_caller;
6411: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;
6412: -- LPN CONV rv
6413: --
6414: IF l_debug_on THEN
6415: WSH_DEBUG_SV.logmsg(l_module_name,'Adjust_Planned_Flag_Err exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 6425: WSH_WMS_LPN_GRP.g_caller := l_original_caller;

6421: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6422: wsh_util_core.default_handler('WSH_USA_INV_PVT.Update_Inventory_Info',l_module_name);
6423: --
6424: -- LPN CONV rv
6425: WSH_WMS_LPN_GRP.g_caller := l_original_caller;
6426: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;
6427: -- LPN CONV rv
6428: --
6429: IF l_debug_on THEN

Line 6426: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;

6422: wsh_util_core.default_handler('WSH_USA_INV_PVT.Update_Inventory_Info',l_module_name);
6423: --
6424: -- LPN CONV rv
6425: WSH_WMS_LPN_GRP.g_caller := l_original_caller;
6426: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;
6427: -- LPN CONV rv
6428: --
6429: IF l_debug_on THEN
6430: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);