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_ACTIONS dependencies on WSH_WMS_LPN_GRP

Line 3027: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3023: END IF;
3024: -- End of OTM R12 : update delivery
3025:
3026: -- K LPN CONV. rv
3027: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3028: AND nvl(l_del_id_FOR_container.line_direction,'O') IN ('O', 'IO')
3029: AND
3030: (
3031: ((WSH_WMS_LPN_GRP.GK_WMS_PACK or WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY) and l_wms_org = 'Y')

Line 3031: ((WSH_WMS_LPN_GRP.GK_WMS_PACK or WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY) and l_wms_org = 'Y')

3027: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3028: AND nvl(l_del_id_FOR_container.line_direction,'O') IN ('O', 'IO')
3029: AND
3030: (
3031: ((WSH_WMS_LPN_GRP.GK_WMS_PACK or WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY) and l_wms_org = 'Y')
3032: OR
3033: ((WSH_WMS_LPN_GRP.GK_INV_PACK or WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY) and l_wms_org = 'N')
3034: )
3035: THEN

Line 3033: ((WSH_WMS_LPN_GRP.GK_INV_PACK or WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY) and l_wms_org = 'N')

3029: AND
3030: (
3031: ((WSH_WMS_LPN_GRP.GK_WMS_PACK or WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY) and l_wms_org = 'Y')
3032: OR
3033: ((WSH_WMS_LPN_GRP.GK_INV_PACK or WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY) and l_wms_org = 'N')
3034: )
3035: THEN
3036: --{
3037: l_sync_tmp_rec.delivery_detail_id := p_detail_id;

Line 3137: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3133: OR (l_del_id_for_container.delivery_id = l_del_id_for_detail.delivery_id )THEN
3134: --
3135: -- K LPN CONV. rv
3136: -- Only packing.
3137: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3138: AND nvl(l_del_id_FOR_container.line_direction,'O') IN ('O', 'IO')
3139: AND
3140: (
3141: (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_wms_org = 'Y')

Line 3141: (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_wms_org = 'Y')

3137: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3138: AND nvl(l_del_id_FOR_container.line_direction,'O') IN ('O', 'IO')
3139: AND
3140: (
3141: (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_wms_org = 'Y')
3142: OR
3143: (WSH_WMS_LPN_GRP.GK_INV_PACK and l_wms_org = 'N')
3144: )
3145: THEN

Line 3143: (WSH_WMS_LPN_GRP.GK_INV_PACK and l_wms_org = 'N')

3139: AND
3140: (
3141: (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_wms_org = 'Y')
3142: OR
3143: (WSH_WMS_LPN_GRP.GK_INV_PACK and l_wms_org = 'N')
3144: )
3145: THEN
3146: --{
3147: --

Line 3288: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3284: --
3285: l_sync_tmp_recTbl.operation_type_tbl(1) := 'PRIOR';
3286: l_operation_type := 'PRIOR';
3287: --
3288: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3289: AND nvl(l_del_id_for_detail.line_direction,'O') IN ('O', 'IO')
3290: AND
3291: (
3292: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')

Line 3292: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')

3288: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3289: AND nvl(l_del_id_for_detail.line_direction,'O') IN ('O', 'IO')
3290: AND
3291: (
3292: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')
3293: OR
3294: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_wms_org = 'N')
3295: )
3296: THEN

Line 3294: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_wms_org = 'N')

3290: AND
3291: (
3292: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')
3293: OR
3294: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_wms_org = 'N')
3295: )
3296: THEN
3297: --{
3298: --

Line 3428: IF NOT( l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%')

3424: END IF;
3425:
3426:
3427: -- K LPN CONV. rv
3428: IF NOT( l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%')
3429: THEN
3430: --{
3431: -- J: W/V Changes
3432: IF l_debug_on THEN

Line 3649: IF NOT( l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%')

3645: END IF;
3646:
3647: -- K LPN CONV. rv
3648:
3649: IF NOT( l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%')
3650: THEN
3651: --{
3652:
3653: -- J: W/V Changes

Line 3688: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3684:
3685: -- K LPN CONV. rv
3686: --
3687: -- K LPN CONV. rv
3688: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3689: AND nvl(l_parent_cnt_line_dir,'O') IN ('O', 'IO')
3690: AND
3691: (
3692: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')

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

3688: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3689: AND nvl(l_parent_cnt_line_dir,'O') IN ('O', 'IO')
3690: AND
3691: (
3692: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')
3693: OR
3694: (WSH_WMS_LPN_GRP.GK_INV_UNPACK and l_wms_org = 'N')
3695: )
3696: THEN

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

3690: AND
3691: (
3692: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')
3693: OR
3694: (WSH_WMS_LPN_GRP.GK_INV_UNPACK and l_wms_org = 'N')
3695: )
3696: THEN
3697: --{
3698: l_sync_tmp_rec.delivery_detail_id := p_detail_id;

Line 3768: IF NOT( l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%')

3764:
3765: IF (l_param_info.percent_fill_basis_flag = 'Q') THEN
3766:
3767: -- K LPN CONV. rv
3768: IF NOT( l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%')
3769: THEN
3770: --{
3771: IF l_debug_on THEN
3772: WSH_DEBUG_SV.logmsg(l_module_name,'Need to recalculate the fill% for container');

Line 4373: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

4369: -- K LPN CONV. rv
4370: --
4371: l_detail_wms_org := wsh_util_validate.check_wms_org(l_detail.organization_id);
4372: --
4373: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
4374: AND l_detail.line_direction IN ('O','IO')
4375: AND
4376: (
4377: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_detail_wms_org = 'Y')

Line 4377: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_detail_wms_org = 'Y')

4373: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
4374: AND l_detail.line_direction IN ('O','IO')
4375: AND
4376: (
4377: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_detail_wms_org = 'Y')
4378: OR
4379: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_detail_wms_org = 'N')
4380: )
4381: THEN

Line 4379: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_detail_wms_org = 'N')

4375: AND
4376: (
4377: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_detail_wms_org = 'Y')
4378: OR
4379: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_detail_wms_org = 'N')
4380: )
4381: THEN
4382: --{
4383: l_sync_tmp_rec.delivery_detail_id := l_dd_id(j);

Line 4672: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

4668: RAISE DETAIL_DEL_FROM_to_not_SAME ;
4669: END IF;
4670: --
4671: -- K LPN CONV. rv
4672: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
4673: AND l_detail.line_direction IN ('O', 'IO')
4674: AND l_detail.container_flag='Y'
4675: AND
4676: (

Line 4677: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_detail_wms_org = 'Y')

4673: AND l_detail.line_direction IN ('O', 'IO')
4674: AND l_detail.container_flag='Y'
4675: AND
4676: (
4677: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_detail_wms_org = 'Y')
4678: OR
4679: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_detail_wms_org = 'N')
4680: )
4681: THEN

Line 4679: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_detail_wms_org = 'N')

4675: AND
4676: (
4677: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_detail_wms_org = 'Y')
4678: OR
4679: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_detail_wms_org = 'N')
4680: )
4681: THEN
4682: --{
4683: l_sync_tmp_rec.delivery_detail_id := l_detail.delivery_detail_id;

Line 6004: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

6000: l_sync_tmp_recTbl.operation_type_tbl(1) := 'PRIOR';
6001: l_operation_type := 'PRIOR';
6002: --
6003: --
6004: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6005: AND nvl(l_del_id_for_container2.line_direction,'O') IN ('O', 'IO')
6006: AND
6007: (
6008: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')

Line 6008: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')

6004: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6005: AND nvl(l_del_id_for_container2.line_direction,'O') IN ('O', 'IO')
6006: AND
6007: (
6008: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')
6009: OR
6010: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_wms_org = 'N')
6011: )
6012: THEN

Line 6010: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_wms_org = 'N')

6006: AND
6007: (
6008: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')
6009: OR
6010: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_wms_org = 'N')
6011: )
6012: THEN
6013: --{
6014: --

Line 6168: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

6164: l_sync_tmp_recTbl.operation_type_tbl(1) := 'PRIOR';
6165: l_operation_type := 'PRIOR';
6166: --
6167: --
6168: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6169: AND nvl(l_del_id_FOR_container2.line_direction,'O') IN ('O', 'IO')
6170: AND
6171: (
6172: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')

Line 6172: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')

6168: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6169: AND nvl(l_del_id_FOR_container2.line_direction,'O') IN ('O', 'IO')
6170: AND
6171: (
6172: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')
6173: OR
6174: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_wms_org = 'N')
6175: )
6176: THEN

Line 6174: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_wms_org = 'N')

6170: AND
6171: (
6172: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')
6173: OR
6174: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_wms_org = 'N')
6175: )
6176: THEN
6177: --{
6178: --

Line 6274: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

6270:
6271:
6272: --
6273: -- K LPN CONV. rv
6274: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6275: AND nvl(l_del_id_FOR_container2.line_direction,'O') IN ('O', 'IO')
6276: AND
6277: (
6278: (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_wms_org = 'Y')

Line 6278: (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_wms_org = 'Y')

6274: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6275: AND nvl(l_del_id_FOR_container2.line_direction,'O') IN ('O', 'IO')
6276: AND
6277: (
6278: (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_wms_org = 'Y')
6279: OR
6280: (WSH_WMS_LPN_GRP.GK_INV_PACK and l_wms_org = 'N')
6281: )
6282: THEN

Line 6280: (WSH_WMS_LPN_GRP.GK_INV_PACK and l_wms_org = 'N')

6276: AND
6277: (
6278: (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_wms_org = 'Y')
6279: OR
6280: (WSH_WMS_LPN_GRP.GK_INV_PACK and l_wms_org = 'N')
6281: )
6282: THEN
6283: --{
6284:

Line 6342: IF NOT( l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%')

6338: return;
6339: END IF;
6340:
6341: -- K LPN CONV. rv
6342: IF NOT( l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%')
6343: THEN
6344: --{
6345: -- J: W/V Changes
6346: IF l_debug_on THEN

Line 6938: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

6934: -- K LPN CONV. rv
6935: --
6936: l_loop_wms_org := wsh_util_validate.check_wms_org(l_det_org_id_tbl(j));
6937: --
6938: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6939: AND l_line_dir_tbl(j) IN ('O', 'IO')
6940: AND l_cnt_flag_tbl(j) = 'Y'
6941: AND
6942: (

Line 6943: (WSH_WMS_LPN_GRP.GK_WMS_UNASSIGN_DLVY and l_loop_wms_org = 'Y')

6939: AND l_line_dir_tbl(j) IN ('O', 'IO')
6940: AND l_cnt_flag_tbl(j) = 'Y'
6941: AND
6942: (
6943: (WSH_WMS_LPN_GRP.GK_WMS_UNASSIGN_DLVY and l_loop_wms_org = 'Y')
6944: OR
6945: (WSH_WMS_LPN_GRP.GK_INV_UNASSIGN_DLVY and l_loop_wms_org = 'N')
6946: )
6947: THEN

Line 6945: (WSH_WMS_LPN_GRP.GK_INV_UNASSIGN_DLVY and l_loop_wms_org = 'N')

6941: AND
6942: (
6943: (WSH_WMS_LPN_GRP.GK_WMS_UNASSIGN_DLVY and l_loop_wms_org = 'Y')
6944: OR
6945: (WSH_WMS_LPN_GRP.GK_INV_UNASSIGN_DLVY and l_loop_wms_org = 'N')
6946: )
6947: THEN
6948: --{
6949: l_sync_tmp_rec.delivery_detail_id := l_dd_id(j);

Line 7044: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

7040:
7041: IF l_detail_is_empty_cont ='Y' THEN
7042: --
7043: -- K LPN CONV. rv
7044: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7045: AND l_line_dir_tbl(j) IN ('O', 'IO')
7046: AND
7047: (
7048: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_loop_wms_org = 'Y')

Line 7048: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_loop_wms_org = 'Y')

7044: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7045: AND l_line_dir_tbl(j) IN ('O', 'IO')
7046: AND
7047: (
7048: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_loop_wms_org = 'Y')
7049: OR
7050: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_loop_wms_org = 'N')
7051: )
7052: THEN

Line 7050: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_loop_wms_org = 'N')

7046: AND
7047: (
7048: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_loop_wms_org = 'Y')
7049: OR
7050: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_loop_wms_org = 'N')
7051: )
7052: THEN
7053: --{
7054: l_sync_tmp_rec.delivery_detail_id := l_dd_id(j);

Line 7294: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

7290: l_wms_org := wsh_util_validate.check_wms_org(l_parent_cnt_orgn_id);
7291: --
7292: -- K LPN CONV. rv
7293: --
7294: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7295: AND nvl(l_parent_cnt_line_dir,'O') IN ('O', 'IO')
7296: AND
7297: (
7298: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')

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

7294: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7295: AND nvl(l_parent_cnt_line_dir,'O') IN ('O', 'IO')
7296: AND
7297: (
7298: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')
7299: OR
7300: (WSH_WMS_LPN_GRP.GK_INV_UNPACK and l_wms_org = 'N')
7301: )
7302: THEN

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

7296: AND
7297: (
7298: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')
7299: OR
7300: (WSH_WMS_LPN_GRP.GK_INV_UNPACK and l_wms_org = 'N')
7301: )
7302: THEN
7303: --{
7304: l_sync_tmp_rec.delivery_detail_id := p_detail_id;

Line 8025: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8021: END IF;
8022: --
8023: -- K LPN CONV. rv
8024: --
8025: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8026: THEN
8027: --{
8028: IF l_debug_on THEN
8029: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 8077: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8073: x_return_status := fnd_api.g_ret_sts_error;
8074: --
8075: -- K LPN CONV. rv
8076: --
8077: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8078: THEN
8079: --{
8080: IF l_debug_on THEN
8081: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 8116: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8112: --
8113: --
8114: -- K LPN CONV. rv
8115: --
8116: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8117: THEN
8118: --{
8119: IF l_debug_on THEN
8120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 8154: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8150: --
8151: --
8152: -- K LPN CONV. rv
8153: --
8154: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8155: THEN
8156: --{
8157: IF l_debug_on THEN
8158: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 8193: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8189: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8190: --
8191: -- K LPN CONV. rv
8192: --
8193: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8194: THEN
8195: --{
8196: IF l_debug_on THEN
8197: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 8239: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8235: --
8236: --
8237: -- K LPN CONV. rv
8238: --
8239: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8240: THEN
8241: --{
8242: IF l_debug_on THEN
8243: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 11752: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

11748: open l_get_cnt_org_csr(l_parent_container_id(1));
11749: fetch l_get_cnt_org_csr into l_orgn_id, l_line_dir;
11750: close l_get_cnt_org_csr;
11751: l_wms_org := wsh_util_validate.check_wms_org(l_orgn_id);
11752: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
11753: AND l_line_dir IN ('O', 'IO')
11754: AND l_wms_org = 'Y' THEN
11755: --{
11756: insert into wsh_wms_sync_tmp

Line 11762: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);

11758: operation_type,
11759: creation_date)
11760: values (l_parent_container_id(1),
11761: 'DELETE',
11762: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);
11763: --}
11764: END IF;
11765: -- lpn conv
11766:

Line 11796: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

11792:
11793: --
11794: -- K LPN CONV. rv
11795: --
11796: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
11797: THEN
11798: --{
11799: IF l_debug_on THEN
11800: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 11839: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

11835: WHEN e_return_excp THEN
11836: --
11837: -- K LPN CONV. rv
11838: --
11839: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
11840: THEN
11841: --{
11842: IF l_debug_on THEN
11843: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 11883: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

11879: --
11880: --
11881: -- K LPN CONV. rv
11882: --
11883: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
11884: THEN
11885: --{
11886: IF l_debug_on THEN
11887: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);