DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_WV_UTILS

Line 505: l_qty2_to_unreserve := WSH_WV_UTILS.convert_uom

501:
502: IF ( l_qty2_to_unreserve is NOT NULL OR
503: l_qty2_to_unreserve <> FND_API.G_MISS_NUM ) THEN
504:
505: l_qty2_to_unreserve := WSH_WV_UTILS.convert_uom
506: (
507: item_id => l_line_rec.inventory_item_id
508: ,org_id => l_line_rec.organization_id
509: ,from_uom => l_line_rec.requested_quantity_uom

Line 2779: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);

2775: -- The third DD_WV_Post_Process will will increment the container W/V with DD W/V which in turn will adjust the
2776: -- delivery W/V, if the container is in a delivery.
2777: IF (l_del_id_for_detail.delivery_id is not null) THEN
2778: IF l_debug_on THEN
2779: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
2780: END IF;
2781:
2782: WSH_WV_UTILS.DD_WV_Post_Process(
2783: p_delivery_detail_id => p_detail_id,

Line 2782: WSH_WV_UTILS.DD_WV_Post_Process(

2778: IF l_debug_on THEN
2779: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
2780: END IF;
2781:
2782: WSH_WV_UTILS.DD_WV_Post_Process(
2783: p_delivery_detail_id => p_detail_id,
2784: p_diff_gross_wt => -1 * l_del_id_for_detail.gross_weight,
2785: p_diff_net_wt => -1 * l_del_id_for_detail.net_weight,
2786: p_diff_volume => -1 * l_del_id_for_detail.volume,

Line 3397: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);

3393: -- J: W/V Changes
3394: -- Container is being assigned to delivery. Call DD_WV_Post_Process to adjust the W/V of the parent
3395: IF l_debug_on THEN
3396: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning Container to Delivery');
3397: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3398: END IF;
3399:
3400: WSH_WV_UTILS.DD_WV_Post_Process(
3401: p_delivery_detail_id => p_parent_detail_id,

Line 3400: WSH_WV_UTILS.DD_WV_Post_Process(

3396: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning Container to Delivery');
3397: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3398: END IF;
3399:
3400: WSH_WV_UTILS.DD_WV_Post_Process(
3401: p_delivery_detail_id => p_parent_detail_id,
3402: p_diff_gross_wt => l_del_id_for_container.gross_weight,
3403: p_diff_net_wt => l_del_id_for_container.net_weight,
3404: p_diff_volume => l_del_id_for_container.volume,

Line 3433: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);

3429: THEN
3430: --{
3431: -- J: W/V Changes
3432: IF l_debug_on THEN
3433: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3434: END IF;
3435:
3436: WSH_WV_UTILS.DD_WV_Post_Process(
3437: p_delivery_detail_id => p_detail_id,

Line 3436: WSH_WV_UTILS.DD_WV_Post_Process(

3432: IF l_debug_on THEN
3433: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3434: END IF;
3435:
3436: WSH_WV_UTILS.DD_WV_Post_Process(
3437: p_delivery_detail_id => p_detail_id,
3438: p_diff_gross_wt => l_del_id_for_detail.gross_weight,
3439: p_diff_net_wt => l_del_id_for_detail.net_weight,
3440: p_diff_volume => l_del_id_for_detail.volume,

Line 3656: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);

3652:
3653: -- J: W/V Changes
3654: -- Decrement the DD W/V from container
3655: IF l_debug_on THEN
3656: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3657: END IF;
3658:
3659: WSH_WV_UTILS.DD_WV_Post_Process(
3660: p_delivery_detail_id => p_detail_id,

Line 3659: WSH_WV_UTILS.DD_WV_Post_Process(

3655: IF l_debug_on THEN
3656: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3657: END IF;
3658:
3659: WSH_WV_UTILS.DD_WV_Post_Process(
3660: p_delivery_detail_id => p_detail_id,
3661: p_diff_gross_wt => -1 * l_del_rec.gross_weight,
3662: p_diff_net_wt => -1 * l_del_rec.net_weight,
3663: p_diff_volume => -1 * l_del_rec.volume,

Line 3776: WSH_WV_UTILS.ADJUST_PARENT_WV(

3772: WSH_DEBUG_SV.logmsg(l_module_name,'Need to recalculate the fill% for container');
3773: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_CONTAINER_PKG.CALC_CONT_FILL_PC',WSH_DEBUG_SV.C_PROC_LEVEL);
3774: END IF;
3775:
3776: WSH_WV_UTILS.ADJUST_PARENT_WV(
3777: p_entity_type => 'CONTAINER',
3778: p_entity_id => l_del_rec.parent_delivery_detail_id,
3779: p_gross_weight => 0,
3780: p_net_weight => 0,

Line 3791: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_WV_UTILS.ADJUST_PARENT_WV returned '||l_return_status);

3787:
3788: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
3789: THEN
3790: IF l_debug_on THEN
3791: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_WV_UTILS.ADJUST_PARENT_WV returned '||l_return_status);
3792: END IF;
3793: RAISE e_abort;
3794: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3795: l_num_warnings := l_num_warnings + 1;

Line 3813: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);

3809: -- J: W/V Changes
3810: -- Assign the DD W/V back to delivery
3811: IF l_del_rec.delivery_id IS NOT NULL THEN
3812: IF l_debug_on THEN
3813: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3814: END IF;
3815:
3816: WSH_WV_UTILS.DD_WV_Post_Process(
3817: p_delivery_detail_id => p_detail_id,

Line 3816: WSH_WV_UTILS.DD_WV_Post_Process(

3812: IF l_debug_on THEN
3813: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3814: END IF;
3815:
3816: WSH_WV_UTILS.DD_WV_Post_Process(
3817: p_delivery_detail_id => p_detail_id,
3818: p_diff_gross_wt => l_del_rec.gross_weight,
3819: p_diff_net_wt => l_del_rec.net_weight,
3820: p_diff_volume => l_del_rec.volume,

Line 4916: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);

4912:
4913: -- J: W/V Changes
4914: -- Increment the delivery W/V by DD W/V
4915: IF l_debug_on THEN
4916: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
4917: END IF;
4918: WSH_WV_UTILS.DD_WV_Post_Process(
4919: p_delivery_detail_id => p_detail_id,
4920: p_diff_gross_wt => l_gross_wt,

Line 4918: WSH_WV_UTILS.DD_WV_Post_Process(

4914: -- Increment the delivery W/V by DD W/V
4915: IF l_debug_on THEN
4916: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
4917: END IF;
4918: WSH_WV_UTILS.DD_WV_Post_Process(
4919: p_delivery_detail_id => p_detail_id,
4920: p_diff_gross_wt => l_gross_wt,
4921: p_diff_net_wt => l_net_wt,
4922: p_diff_volume => l_vol,

Line 5946: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);

5942: -- The third DD_WV_Post_Process cll will increment the cont2 W/V with cont1 W/V which in turn will adjust the
5943: -- delivery W/V, if the cont2 is in a delivery.
5944: IF (l_del_id_for_container1.delivery_id is not null) THEN
5945: IF l_debug_on THEN
5946: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
5947: END IF;
5948:
5949: WSH_WV_UTILS.DD_WV_Post_Process(
5950: p_delivery_detail_id => p_detail_id1,

Line 5949: WSH_WV_UTILS.DD_WV_Post_Process(

5945: IF l_debug_on THEN
5946: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
5947: END IF;
5948:
5949: WSH_WV_UTILS.DD_WV_Post_Process(
5950: p_delivery_detail_id => p_detail_id1,
5951: p_diff_gross_wt => -1 * l_del_id_for_container1.gross_weight,
5952: p_diff_net_wt => -1 * l_del_id_for_container1.net_weight,
5953: p_diff_volume => -1 * l_del_id_for_container1.volume,

Line 6107: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);

6103:
6104: -- J: W/V Changes
6105: IF l_debug_on THEN
6106: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning Container to Delivery');
6107: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
6108: END IF;
6109:
6110: WSH_WV_UTILS.DD_WV_Post_Process(
6111: p_delivery_detail_id => p_detail_id2,

Line 6110: WSH_WV_UTILS.DD_WV_Post_Process(

6106: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning Container to Delivery');
6107: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
6108: END IF;
6109:
6110: WSH_WV_UTILS.DD_WV_Post_Process(
6111: p_delivery_detail_id => p_detail_id2,
6112: p_diff_gross_wt => l_del_id_for_container2.gross_weight,
6113: p_diff_net_wt => l_del_id_for_container2.net_weight,
6114: p_diff_volume => l_del_id_for_container2.volume,

Line 6347: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);

6343: THEN
6344: --{
6345: -- J: W/V Changes
6346: IF l_debug_on THEN
6347: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
6348: END IF;
6349: WSH_WV_UTILS.DD_WV_Post_Process(
6350: p_delivery_detail_id => p_detail_id1,
6351: p_diff_gross_wt => l_del_id_for_container1.gross_weight,

Line 6349: WSH_WV_UTILS.DD_WV_Post_Process(

6345: -- J: W/V Changes
6346: IF l_debug_on THEN
6347: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
6348: END IF;
6349: WSH_WV_UTILS.DD_WV_Post_Process(
6350: p_delivery_detail_id => p_detail_id1,
6351: p_diff_gross_wt => l_del_id_for_container1.gross_weight,
6352: p_diff_net_wt => l_del_id_for_container1.net_weight,
6353: p_diff_volume => l_del_id_for_container1.volume,

Line 6863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);

6859:
6860: -- J: W/V Changes
6861: -- Decrement the parent W/V by DD W/V
6862: IF l_debug_on THEN
6863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
6864: END IF;
6865: WSH_WV_UTILS.DD_WV_Post_Process(
6866: p_delivery_detail_id => p_detail_id,
6867: p_diff_gross_wt => -1 * l_gross_wt,

Line 6865: WSH_WV_UTILS.DD_WV_Post_Process(

6861: -- Decrement the parent W/V by DD W/V
6862: IF l_debug_on THEN
6863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
6864: END IF;
6865: WSH_WV_UTILS.DD_WV_Post_Process(
6866: p_delivery_detail_id => p_detail_id,
6867: p_diff_gross_wt => -1 * l_gross_wt,
6868: p_diff_net_wt => -1 * l_net_wt,
6869: p_diff_volume => -1 * l_vol,

Line 7388: WSH_WV_UTILS.ADJUST_PARENT_WV(

7384:
7385:
7386: IF l_shipping_param_info.PERCENT_FILL_BASIS_FLAG = 'Q' THEN
7387:
7388: WSH_WV_UTILS.ADJUST_PARENT_WV(
7389: p_entity_type => 'CONTAINER',
7390: p_entity_id => l_assign.parent_delivery_detail_id,
7391: p_gross_weight => 0,
7392: p_net_weight => 0,

Line 7403: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_WV_UTILS.ADJUST_PARENT_WV returned '||l_return_status);

7399:
7400: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR))
7401: THEN
7402: IF l_debug_on THEN
7403: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_WV_UTILS.ADJUST_PARENT_WV returned '||l_return_status);
7404: END IF;
7405: RAISE adjust_parent_wv_err;
7406: END IF;
7407:

Line 9595: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);

9591: l_total_vol := 0;
9592: ELSE
9593: -- end bug 4416863
9594: IF l_debug_on THEN
9595: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
9596: END IF;
9597:
9598: l_total_net_wt := 0;
9599: l_total_gross_wt := 0;

Line 9603: WSH_WV_UTILS.Detail_Weight_Volume(

9599: l_total_gross_wt := 0;
9600: l_total_vol := 0;
9601: FOR i in 1..l_dd_id_tab.count LOOP
9602:
9603: WSH_WV_UTILS.Detail_Weight_Volume(
9604: p_delivery_detail_id => l_dd_id_tab(i),
9605: p_update_flag => 'Y',
9606: x_net_weight => l_split_weight,
9607: x_volume => l_split_volume,

Line 9699: because non item does not use WSH_WV_UTILS.Detail_Weight_Volume to

9695: --
9696: -- HW OPMCONV - Removed branching
9697:
9698: /* Bug 2177410, also update net_weight and volume of original delivery detail
9699: because non item does not use WSH_WV_UTILS.Detail_Weight_Volume to
9700: adjust the net_weight and volume */
9701:
9702: x_split_detail_id := l_new_delivery_detail_id;
9703:

Line 9810: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);

9806: -- J: W/V Changes
9807: -- Decrement the DD W/V from parent if p_unassign_flag is 'Y'
9808: IF (p_unassign_flag = 'Y') THEN
9809: IF l_debug_on THEN
9810: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
9811: END IF;
9812: --
9813: WSH_WV_UTILS.DD_WV_Post_Process(
9814: p_delivery_detail_id => p_old_delivery_detail_rec.delivery_detail_id,

Line 9813: WSH_WV_UTILS.DD_WV_Post_Process(

9809: IF l_debug_on THEN
9810: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
9811: END IF;
9812: --
9813: WSH_WV_UTILS.DD_WV_Post_Process(
9814: p_delivery_detail_id => p_old_delivery_detail_rec.delivery_detail_id,
9815: p_diff_gross_wt => -1 * l_total_gross_wt,
9816: p_diff_net_wt => -1 * l_total_net_wt,
9817: p_diff_fill_volume => -1 * l_total_vol,

Line 10811: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);

10807: l_total_vol := 0;
10808: ELSE
10809: -- end bug 4416863
10810: IF l_debug_on THEN
10811: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
10812: END IF;
10813:
10814: WSH_WV_UTILS.Detail_Weight_Volume(
10815: p_delivery_detail_id => l_new_delivery_detail_id,

Line 10814: WSH_WV_UTILS.Detail_Weight_Volume(

10810: IF l_debug_on THEN
10811: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
10812: END IF;
10813:
10814: WSH_WV_UTILS.Detail_Weight_Volume(
10815: p_delivery_detail_id => l_new_delivery_detail_id,
10816: p_update_flag => 'Y',
10817: x_net_weight => l_split_weight,
10818: x_volume => l_split_volume,

Line 10904: because non item does not use WSH_WV_UTILS.Detail_Weight_Volume to

10900: /* LG new */
10901:
10902: /* HW OPMCONV - Removed branching
10903: /* Bug 2177410, also update net_weight and volume of original delivery detail
10904: because non item does not use WSH_WV_UTILS.Detail_Weight_Volume to
10905: adjust the net_weight and volume */
10906:
10907: x_split_detail_id := l_new_delivery_detail_id;
10908:

Line 10976: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);

10972: -- J: W/V Changes
10973: -- Decrement the DD W/V from parent if p_unassign_flag is 'Y'
10974: IF (p_unassign_flag = 'Y') THEN
10975: IF l_debug_on THEN
10976: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
10977: END IF;
10978: --
10979: WSH_WV_UTILS.DD_WV_Post_Process(
10980: p_delivery_detail_id => p_old_delivery_detail_rec.delivery_detail_id,

Line 10979: WSH_WV_UTILS.DD_WV_Post_Process(

10975: IF l_debug_on THEN
10976: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
10977: END IF;
10978: --
10979: WSH_WV_UTILS.DD_WV_Post_Process(
10980: p_delivery_detail_id => p_old_delivery_detail_rec.delivery_detail_id,
10981: p_diff_gross_wt => -1 * l_total_gross_wt,
10982: p_diff_net_wt => -1 * l_total_net_wt,
10983: p_diff_fill_volume => -1 * l_total_vol,

Line 12465: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);

12461:
12462: FOR l_index in l_cons_dd_ids.FIRST..l_cons_dd_ids.LAST LOOP
12463:
12464: IF l_debug_on THEN
12465: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
12466: END IF;
12467: --
12468: WSH_WV_UTILS.Detail_Weight_Volume(
12469: p_delivery_detail_id => l_cons_dd_ids(l_index),

Line 12468: WSH_WV_UTILS.Detail_Weight_Volume(

12464: IF l_debug_on THEN
12465: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
12466: END IF;
12467: --
12468: WSH_WV_UTILS.Detail_Weight_Volume(
12469: p_delivery_detail_id => l_cons_dd_ids(l_index),
12470: p_update_flag => 'Y',
12471: p_post_process_flag => 'Y',
12472: p_calc_wv_if_frozen => 'Y',

Line 12566: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);

12562: volume = l_new_vol
12563: WHERE delivery_detail_id = l_partial_dd_ids(l_index);
12564:
12565: IF l_debug_on THEN
12566: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
12567: END IF;
12568:
12569: WSH_WV_UTILS.DD_WV_Post_Process(
12570: p_delivery_detail_id => l_partial_dd_ids(l_index),

Line 12569: WSH_WV_UTILS.DD_WV_Post_Process(

12565: IF l_debug_on THEN
12566: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
12567: END IF;
12568:
12569: WSH_WV_UTILS.DD_WV_Post_Process(
12570: p_delivery_detail_id => l_partial_dd_ids(l_index),
12571: p_diff_gross_wt => -1 * (l_gross_weight - l_new_gross_wt),
12572: p_diff_net_wt => -1 * (l_net_weight - l_new_net_wt),
12573: p_diff_fill_volume => -1 * (l_volume - l_new_vol),