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 3172: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3168: END IF;
3169: -- End of OTM R12 : update delivery
3170:
3171: -- K LPN CONV. rv
3172: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3173: AND nvl(l_del_id_FOR_container.line_direction,'O') IN ('O', 'IO')
3174: AND
3175: (
3176: ((WSH_WMS_LPN_GRP.GK_WMS_PACK or WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY) and l_wms_org = 'Y')

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

3172: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3173: AND nvl(l_del_id_FOR_container.line_direction,'O') IN ('O', 'IO')
3174: AND
3175: (
3176: ((WSH_WMS_LPN_GRP.GK_WMS_PACK or WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY) and l_wms_org = 'Y')
3177: OR
3178: ((WSH_WMS_LPN_GRP.GK_INV_PACK or WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY) and l_wms_org = 'N')
3179: )
3180: THEN

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

3174: AND
3175: (
3176: ((WSH_WMS_LPN_GRP.GK_WMS_PACK or WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY) and l_wms_org = 'Y')
3177: OR
3178: ((WSH_WMS_LPN_GRP.GK_INV_PACK or WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY) and l_wms_org = 'N')
3179: )
3180: THEN
3181: --{
3182: l_sync_tmp_rec.delivery_detail_id := p_detail_id;

Line 3282: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3278: OR (l_del_id_for_container.delivery_id = l_del_id_for_detail.delivery_id )THEN
3279: --
3280: -- K LPN CONV. rv
3281: -- Only packing.
3282: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3283: AND nvl(l_del_id_FOR_container.line_direction,'O') IN ('O', 'IO')
3284: AND
3285: (
3286: (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_wms_org = 'Y')

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

3282: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3283: AND nvl(l_del_id_FOR_container.line_direction,'O') IN ('O', 'IO')
3284: AND
3285: (
3286: (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_wms_org = 'Y')
3287: OR
3288: (WSH_WMS_LPN_GRP.GK_INV_PACK and l_wms_org = 'N')
3289: )
3290: THEN

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

3284: AND
3285: (
3286: (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_wms_org = 'Y')
3287: OR
3288: (WSH_WMS_LPN_GRP.GK_INV_PACK and l_wms_org = 'N')
3289: )
3290: THEN
3291: --{
3292: --

Line 3433: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3429: --
3430: l_sync_tmp_recTbl.operation_type_tbl(1) := 'PRIOR';
3431: l_operation_type := 'PRIOR';
3432: --
3433: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3434: AND nvl(l_del_id_for_detail.line_direction,'O') IN ('O', 'IO')
3435: AND
3436: (
3437: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')

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

3433: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3434: AND nvl(l_del_id_for_detail.line_direction,'O') IN ('O', 'IO')
3435: AND
3436: (
3437: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')
3438: OR
3439: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_wms_org = 'N')
3440: )
3441: THEN

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

3435: AND
3436: (
3437: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')
3438: OR
3439: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_wms_org = 'N')
3440: )
3441: THEN
3442: --{
3443: --

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

3569: END IF;
3570:
3571:
3572: -- K LPN CONV. rv
3573: IF NOT( l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%')
3574: THEN
3575: --{
3576: -- J: W/V Changes
3577: IF l_debug_on THEN

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

3790: END IF;
3791:
3792: -- K LPN CONV. rv
3793:
3794: IF NOT( l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%')
3795: THEN
3796: --{
3797:
3798: -- J: W/V Changes

Line 3833: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

3829:
3830: -- K LPN CONV. rv
3831: --
3832: -- K LPN CONV. rv
3833: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3834: AND nvl(l_parent_cnt_line_dir,'O') IN ('O', 'IO')
3835: AND
3836: (
3837: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')

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

3833: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3834: AND nvl(l_parent_cnt_line_dir,'O') IN ('O', 'IO')
3835: AND
3836: (
3837: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')
3838: OR
3839: (WSH_WMS_LPN_GRP.GK_INV_UNPACK and l_wms_org = 'N')
3840: )
3841: THEN

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

3835: AND
3836: (
3837: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')
3838: OR
3839: (WSH_WMS_LPN_GRP.GK_INV_UNPACK and l_wms_org = 'N')
3840: )
3841: THEN
3842: --{
3843: l_sync_tmp_rec.delivery_detail_id := p_detail_id;

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

3909:
3910: IF (l_param_info.percent_fill_basis_flag = 'Q') THEN
3911:
3912: -- K LPN CONV. rv
3913: IF NOT( l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%')
3914: THEN
3915: --{
3916: IF l_debug_on THEN
3917: WSH_DEBUG_SV.logmsg(l_module_name,'Need to recalculate the fill% for container');

Line 4521: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

4517: -- K LPN CONV. rv
4518: --
4519: l_detail_wms_org := wsh_util_validate.check_wms_org(l_detail.organization_id);
4520: --
4521: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
4522: AND l_detail.line_direction IN ('O','IO')
4523: AND
4524: (
4525: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_detail_wms_org = 'Y')

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

4521: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
4522: AND l_detail.line_direction IN ('O','IO')
4523: AND
4524: (
4525: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_detail_wms_org = 'Y')
4526: OR
4527: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_detail_wms_org = 'N')
4528: )
4529: THEN

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

4523: AND
4524: (
4525: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_detail_wms_org = 'Y')
4526: OR
4527: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_detail_wms_org = 'N')
4528: )
4529: THEN
4530: --{
4531: l_sync_tmp_rec.delivery_detail_id := l_dd_id(j);

Line 4823: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

4819: RAISE DETAIL_DEL_FROM_to_not_SAME ;
4820: END IF;
4821: --
4822: -- K LPN CONV. rv
4823: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
4824: AND l_detail.line_direction IN ('O', 'IO')
4825: AND l_detail.container_flag='Y'
4826: AND
4827: (

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

4824: AND l_detail.line_direction IN ('O', 'IO')
4825: AND l_detail.container_flag='Y'
4826: AND
4827: (
4828: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_detail_wms_org = 'Y')
4829: OR
4830: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_detail_wms_org = 'N')
4831: )
4832: THEN

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

4826: AND
4827: (
4828: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_detail_wms_org = 'Y')
4829: OR
4830: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_detail_wms_org = 'N')
4831: )
4832: THEN
4833: --{
4834: l_sync_tmp_rec.delivery_detail_id := l_detail.delivery_detail_id;

Line 6158: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

6154: l_sync_tmp_recTbl.operation_type_tbl(1) := 'PRIOR';
6155: l_operation_type := 'PRIOR';
6156: --
6157: --
6158: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6159: AND nvl(l_del_id_for_container2.line_direction,'O') IN ('O', 'IO')
6160: AND
6161: (
6162: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')

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

6158: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6159: AND nvl(l_del_id_for_container2.line_direction,'O') IN ('O', 'IO')
6160: AND
6161: (
6162: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')
6163: OR
6164: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_wms_org = 'N')
6165: )
6166: THEN

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

6160: AND
6161: (
6162: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')
6163: OR
6164: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_wms_org = 'N')
6165: )
6166: THEN
6167: --{
6168: --

Line 6322: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

6318: l_sync_tmp_recTbl.operation_type_tbl(1) := 'PRIOR';
6319: l_operation_type := 'PRIOR';
6320: --
6321: --
6322: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6323: AND nvl(l_del_id_FOR_container2.line_direction,'O') IN ('O', 'IO')
6324: AND
6325: (
6326: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')

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

6322: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6323: AND nvl(l_del_id_FOR_container2.line_direction,'O') IN ('O', 'IO')
6324: AND
6325: (
6326: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')
6327: OR
6328: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_wms_org = 'N')
6329: )
6330: THEN

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

6324: AND
6325: (
6326: (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_wms_org = 'Y')
6327: OR
6328: (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_wms_org = 'N')
6329: )
6330: THEN
6331: --{
6332: --

Line 6428: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

6424:
6425:
6426: --
6427: -- K LPN CONV. rv
6428: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6429: AND nvl(l_del_id_FOR_container2.line_direction,'O') IN ('O', 'IO')
6430: AND
6431: (
6432: (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_wms_org = 'Y')

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

6428: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
6429: AND nvl(l_del_id_FOR_container2.line_direction,'O') IN ('O', 'IO')
6430: AND
6431: (
6432: (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_wms_org = 'Y')
6433: OR
6434: (WSH_WMS_LPN_GRP.GK_INV_PACK and l_wms_org = 'N')
6435: )
6436: THEN

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

6430: AND
6431: (
6432: (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_wms_org = 'Y')
6433: OR
6434: (WSH_WMS_LPN_GRP.GK_INV_PACK and l_wms_org = 'N')
6435: )
6436: THEN
6437: --{
6438:

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

6492: return;
6493: END IF;
6494:
6495: -- K LPN CONV. rv
6496: IF NOT( l_wms_org = 'Y' AND nvl(wsh_wms_lpn_grp.g_caller,'WSH') like 'WMS%')
6497: THEN
6498: --{
6499: -- J: W/V Changes
6500: IF l_debug_on THEN

Line 7107: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

7103: -- K LPN CONV. rv
7104: --
7105: l_loop_wms_org := wsh_util_validate.check_wms_org(l_det_org_id_tbl(j));
7106: --
7107: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7108: AND l_line_dir_tbl(j) IN ('O', 'IO')
7109: AND l_cnt_flag_tbl(j) = 'Y'
7110: AND
7111: (

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

7108: AND l_line_dir_tbl(j) IN ('O', 'IO')
7109: AND l_cnt_flag_tbl(j) = 'Y'
7110: AND
7111: (
7112: (WSH_WMS_LPN_GRP.GK_WMS_UNASSIGN_DLVY and l_loop_wms_org = 'Y')
7113: OR
7114: (WSH_WMS_LPN_GRP.GK_INV_UNASSIGN_DLVY and l_loop_wms_org = 'N')
7115: )
7116: THEN

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

7110: AND
7111: (
7112: (WSH_WMS_LPN_GRP.GK_WMS_UNASSIGN_DLVY and l_loop_wms_org = 'Y')
7113: OR
7114: (WSH_WMS_LPN_GRP.GK_INV_UNASSIGN_DLVY and l_loop_wms_org = 'N')
7115: )
7116: THEN
7117: --{
7118: l_sync_tmp_rec.delivery_detail_id := l_dd_id(j);

Line 7213: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

7209:
7210: IF l_detail_is_empty_cont ='Y' THEN
7211: --
7212: -- K LPN CONV. rv
7213: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7214: AND l_line_dir_tbl(j) IN ('O', 'IO')
7215: AND
7216: (
7217: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_loop_wms_org = 'Y')

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

7213: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7214: AND l_line_dir_tbl(j) IN ('O', 'IO')
7215: AND
7216: (
7217: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_loop_wms_org = 'Y')
7218: OR
7219: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_loop_wms_org = 'N')
7220: )
7221: THEN

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

7215: AND
7216: (
7217: (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_loop_wms_org = 'Y')
7218: OR
7219: (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_loop_wms_org = 'N')
7220: )
7221: THEN
7222: --{
7223: l_sync_tmp_rec.delivery_detail_id := l_dd_id(j);

Line 7458: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

7454: l_wms_org := wsh_util_validate.check_wms_org(l_parent_cnt_orgn_id);
7455: --
7456: -- K LPN CONV. rv
7457: --
7458: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7459: AND nvl(l_parent_cnt_line_dir,'O') IN ('O', 'IO')
7460: AND
7461: (
7462: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')

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

7458: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7459: AND nvl(l_parent_cnt_line_dir,'O') IN ('O', 'IO')
7460: AND
7461: (
7462: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')
7463: OR
7464: (WSH_WMS_LPN_GRP.GK_INV_UNPACK and l_wms_org = 'N')
7465: )
7466: THEN

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

7460: AND
7461: (
7462: (WSH_WMS_LPN_GRP.GK_WMS_UNPACK and l_wms_org = 'Y')
7463: OR
7464: (WSH_WMS_LPN_GRP.GK_INV_UNPACK and l_wms_org = 'N')
7465: )
7466: THEN
7467: --{
7468: l_sync_tmp_rec.delivery_detail_id := p_detail_id;

Line 8189: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8185: END IF;
8186: --
8187: -- K LPN CONV. rv
8188: --
8189: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8190: THEN
8191: --{
8192: IF l_debug_on THEN
8193: 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 8241: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8237: x_return_status := fnd_api.g_ret_sts_error;
8238: --
8239: -- K LPN CONV. rv
8240: --
8241: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8242: THEN
8243: --{
8244: IF l_debug_on THEN
8245: 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 8280: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8276: --
8277: --
8278: -- K LPN CONV. rv
8279: --
8280: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8281: THEN
8282: --{
8283: IF l_debug_on THEN
8284: 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 8318: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8314: --
8315: --
8316: -- K LPN CONV. rv
8317: --
8318: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8319: THEN
8320: --{
8321: IF l_debug_on THEN
8322: 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 8357: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8353: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8354: --
8355: -- K LPN CONV. rv
8356: --
8357: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8358: THEN
8359: --{
8360: IF l_debug_on THEN
8361: 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 8403: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

8399: --
8400: --
8401: -- K LPN CONV. rv
8402: --
8403: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8404: THEN
8405: --{
8406: IF l_debug_on THEN
8407: 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 12217: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

12213: open l_get_cnt_org_csr(l_parent_container_id(1));
12214: fetch l_get_cnt_org_csr into l_orgn_id, l_line_dir;
12215: close l_get_cnt_org_csr;
12216: l_wms_org := wsh_util_validate.check_wms_org(l_orgn_id);
12217: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
12218: AND l_line_dir IN ('O', 'IO')
12219: AND l_wms_org = 'Y' THEN
12220: --{
12221: insert into wsh_wms_sync_tmp

Line 12227: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);

12223: operation_type,
12224: creation_date)
12225: values (l_parent_container_id(1),
12226: 'DELETE',
12227: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);
12228: --}
12229: END IF;
12230: -- lpn conv
12231:

Line 12261: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

12257:
12258: --
12259: -- K LPN CONV. rv
12260: --
12261: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
12262: THEN
12263: --{
12264: IF l_debug_on THEN
12265: 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 12304: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

12300: WHEN e_return_excp THEN
12301: --
12302: -- K LPN CONV. rv
12303: --
12304: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
12305: THEN
12306: --{
12307: IF l_debug_on THEN
12308: 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 12348: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

12344: --
12345: --
12346: -- K LPN CONV. rv
12347: --
12348: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
12349: THEN
12350: --{
12351: IF l_debug_on THEN
12352: 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);