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_WV_UTILS

Line 543: l_qty2_to_unreserve := WSH_WV_UTILS.convert_uom

539:
540: IF ( l_qty2_to_unreserve is NOT NULL OR
541: l_qty2_to_unreserve <> FND_API.G_MISS_NUM ) THEN
542:
543: l_qty2_to_unreserve := WSH_WV_UTILS.convert_uom
544: (
545: item_id => l_line_rec.inventory_item_id
546: ,org_id => l_line_rec.organization_id
547: ,from_uom => l_line_rec.requested_quantity_uom

Line 569: l_qty_to_unreserve := WSH_WV_UTILS.convert_uom

565:
566: IF ( l_qty_to_unreserve is NOT NULL OR
567: l_qty_to_unreserve <> FND_API.G_MISS_NUM ) THEN
568:
569: l_qty_to_unreserve := WSH_WV_UTILS.convert_uom
570: (
571: item_id => l_line_rec.inventory_item_id
572: ,org_id => l_line_rec.organization_id
573: ,from_uom => l_line_rec.ordered_quantity_uom2

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

2920: -- The third DD_WV_Post_Process will will increment the container W/V with DD W/V which in turn will adjust the
2921: -- delivery W/V, if the container is in a delivery.
2922: IF (l_del_id_for_detail.delivery_id is not null) THEN
2923: IF l_debug_on THEN
2924: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
2925: END IF;
2926:
2927: WSH_WV_UTILS.DD_WV_Post_Process(
2928: p_delivery_detail_id => p_detail_id,

Line 2927: WSH_WV_UTILS.DD_WV_Post_Process(

2923: IF l_debug_on THEN
2924: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
2925: END IF;
2926:
2927: WSH_WV_UTILS.DD_WV_Post_Process(
2928: p_delivery_detail_id => p_detail_id,
2929: p_diff_gross_wt => -1 * l_del_id_for_detail.gross_weight,
2930: p_diff_net_wt => -1 * l_del_id_for_detail.net_weight,
2931: p_diff_volume => -1 * l_del_id_for_detail.volume,

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

3538: -- J: W/V Changes
3539: -- Container is being assigned to delivery. Call DD_WV_Post_Process to adjust the W/V of the parent
3540: IF l_debug_on THEN
3541: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning Container to Delivery');
3542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3543: END IF;
3544:
3545: WSH_WV_UTILS.DD_WV_Post_Process(
3546: p_delivery_detail_id => p_parent_detail_id,

Line 3545: WSH_WV_UTILS.DD_WV_Post_Process(

3541: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning Container to Delivery');
3542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3543: END IF;
3544:
3545: WSH_WV_UTILS.DD_WV_Post_Process(
3546: p_delivery_detail_id => p_parent_detail_id,
3547: p_diff_gross_wt => l_del_id_for_container.gross_weight,
3548: p_diff_net_wt => l_del_id_for_container.net_weight,
3549: p_diff_volume => l_del_id_for_container.volume,

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

3574: THEN
3575: --{
3576: -- J: W/V Changes
3577: IF l_debug_on THEN
3578: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3579: END IF;
3580:
3581: WSH_WV_UTILS.DD_WV_Post_Process(
3582: p_delivery_detail_id => p_detail_id,

Line 3581: WSH_WV_UTILS.DD_WV_Post_Process(

3577: IF l_debug_on THEN
3578: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3579: END IF;
3580:
3581: WSH_WV_UTILS.DD_WV_Post_Process(
3582: p_delivery_detail_id => p_detail_id,
3583: p_diff_gross_wt => l_del_id_for_detail.gross_weight,
3584: p_diff_net_wt => l_del_id_for_detail.net_weight,
3585: p_diff_volume => l_del_id_for_detail.volume,

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

3797:
3798: -- J: W/V Changes
3799: -- Decrement the DD W/V from container
3800: IF l_debug_on THEN
3801: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3802: END IF;
3803:
3804: WSH_WV_UTILS.DD_WV_Post_Process(
3805: p_delivery_detail_id => p_detail_id,

Line 3804: WSH_WV_UTILS.DD_WV_Post_Process(

3800: IF l_debug_on THEN
3801: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3802: END IF;
3803:
3804: WSH_WV_UTILS.DD_WV_Post_Process(
3805: p_delivery_detail_id => p_detail_id,
3806: p_diff_gross_wt => -1 * l_del_rec.gross_weight,
3807: p_diff_net_wt => -1 * l_del_rec.net_weight,
3808: p_diff_volume => -1 * l_del_rec.volume,

Line 3921: WSH_WV_UTILS.ADJUST_PARENT_WV(

3917: WSH_DEBUG_SV.logmsg(l_module_name,'Need to recalculate the fill% for container');
3918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_CONTAINER_PKG.CALC_CONT_FILL_PC',WSH_DEBUG_SV.C_PROC_LEVEL);
3919: END IF;
3920:
3921: WSH_WV_UTILS.ADJUST_PARENT_WV(
3922: p_entity_type => 'CONTAINER',
3923: p_entity_id => l_del_rec.parent_delivery_detail_id,
3924: p_gross_weight => 0,
3925: p_net_weight => 0,

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

3932:
3933: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
3934: THEN
3935: IF l_debug_on THEN
3936: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_WV_UTILS.ADJUST_PARENT_WV returned '||l_return_status);
3937: END IF;
3938: RAISE e_abort;
3939: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3940: l_num_warnings := l_num_warnings + 1;

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

3954: -- J: W/V Changes
3955: -- Assign the DD W/V back to delivery
3956: IF l_del_rec.delivery_id IS NOT NULL THEN
3957: IF l_debug_on THEN
3958: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3959: END IF;
3960:
3961: WSH_WV_UTILS.DD_WV_Post_Process(
3962: p_delivery_detail_id => p_detail_id,

Line 3961: WSH_WV_UTILS.DD_WV_Post_Process(

3957: IF l_debug_on THEN
3958: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
3959: END IF;
3960:
3961: WSH_WV_UTILS.DD_WV_Post_Process(
3962: p_delivery_detail_id => p_detail_id,
3963: p_diff_gross_wt => l_del_rec.gross_weight,
3964: p_diff_net_wt => l_del_rec.net_weight,
3965: p_diff_volume => l_del_rec.volume,

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

5065:
5066: -- J: W/V Changes
5067: -- Increment the delivery W/V by DD W/V
5068: IF l_debug_on THEN
5069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
5070: END IF;
5071: WSH_WV_UTILS.DD_WV_Post_Process(
5072: p_delivery_detail_id => p_detail_id,
5073: p_diff_gross_wt => l_gross_wt,

Line 5071: WSH_WV_UTILS.DD_WV_Post_Process(

5067: -- Increment the delivery W/V by DD W/V
5068: IF l_debug_on THEN
5069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
5070: END IF;
5071: WSH_WV_UTILS.DD_WV_Post_Process(
5072: p_delivery_detail_id => p_detail_id,
5073: p_diff_gross_wt => l_gross_wt,
5074: p_diff_net_wt => l_net_wt,
5075: p_diff_volume => l_vol,

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

6096: -- The third DD_WV_Post_Process cll will increment the cont2 W/V with cont1 W/V which in turn will adjust the
6097: -- delivery W/V, if the cont2 is in a delivery.
6098: IF (l_del_id_for_container1.delivery_id is not null) THEN
6099: IF l_debug_on THEN
6100: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
6101: END IF;
6102:
6103: WSH_WV_UTILS.DD_WV_Post_Process(
6104: p_delivery_detail_id => p_detail_id1,

Line 6103: WSH_WV_UTILS.DD_WV_Post_Process(

6099: IF l_debug_on THEN
6100: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
6101: END IF;
6102:
6103: WSH_WV_UTILS.DD_WV_Post_Process(
6104: p_delivery_detail_id => p_detail_id1,
6105: p_diff_gross_wt => -1 * l_del_id_for_container1.gross_weight,
6106: p_diff_net_wt => -1 * l_del_id_for_container1.net_weight,
6107: p_diff_volume => -1 * l_del_id_for_container1.volume,

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

6257:
6258: -- J: W/V Changes
6259: IF l_debug_on THEN
6260: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning Container to Delivery');
6261: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
6262: END IF;
6263:
6264: WSH_WV_UTILS.DD_WV_Post_Process(
6265: p_delivery_detail_id => p_detail_id2,

Line 6264: WSH_WV_UTILS.DD_WV_Post_Process(

6260: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning Container to Delivery');
6261: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
6262: END IF;
6263:
6264: WSH_WV_UTILS.DD_WV_Post_Process(
6265: p_delivery_detail_id => p_detail_id2,
6266: p_diff_gross_wt => l_del_id_for_container2.gross_weight,
6267: p_diff_net_wt => l_del_id_for_container2.net_weight,
6268: p_diff_volume => l_del_id_for_container2.volume,

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

6497: THEN
6498: --{
6499: -- J: W/V Changes
6500: IF l_debug_on THEN
6501: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
6502: END IF;
6503: WSH_WV_UTILS.DD_WV_Post_Process(
6504: p_delivery_detail_id => p_detail_id1,
6505: p_diff_gross_wt => l_del_id_for_container1.gross_weight,

Line 6503: WSH_WV_UTILS.DD_WV_Post_Process(

6499: -- J: W/V Changes
6500: IF l_debug_on THEN
6501: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
6502: END IF;
6503: WSH_WV_UTILS.DD_WV_Post_Process(
6504: p_delivery_detail_id => p_detail_id1,
6505: p_diff_gross_wt => l_del_id_for_container1.gross_weight,
6506: p_diff_net_wt => l_del_id_for_container1.net_weight,
6507: p_diff_volume => l_del_id_for_container1.volume,

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

7028:
7029: -- J: W/V Changes
7030: -- Decrement the parent W/V by DD W/V
7031: IF l_debug_on THEN
7032: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
7033: END IF;
7034: WSH_WV_UTILS.DD_WV_Post_Process(
7035: p_delivery_detail_id => p_detail_id,
7036: p_diff_gross_wt => -1 * l_gross_wt,

Line 7034: WSH_WV_UTILS.DD_WV_Post_Process(

7030: -- Decrement the parent W/V by DD W/V
7031: IF l_debug_on THEN
7032: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
7033: END IF;
7034: WSH_WV_UTILS.DD_WV_Post_Process(
7035: p_delivery_detail_id => p_detail_id,
7036: p_diff_gross_wt => -1 * l_gross_wt,
7037: p_diff_net_wt => -1 * l_net_wt,
7038: p_diff_volume => -1 * l_vol,

Line 7552: WSH_WV_UTILS.ADJUST_PARENT_WV(

7548:
7549:
7550: IF l_shipping_param_info.PERCENT_FILL_BASIS_FLAG = 'Q' THEN
7551:
7552: WSH_WV_UTILS.ADJUST_PARENT_WV(
7553: p_entity_type => 'CONTAINER',
7554: p_entity_id => l_assign.parent_delivery_detail_id,
7555: p_gross_weight => 0,
7556: p_net_weight => 0,

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

7563:
7564: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR))
7565: THEN
7566: IF l_debug_on THEN
7567: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_WV_UTILS.ADJUST_PARENT_WV returned '||l_return_status);
7568: END IF;
7569: RAISE adjust_parent_wv_err;
7570: END IF;
7571:

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

9771: l_total_vol := 0;
9772: ELSE
9773: -- end bug 4416863
9774: IF l_debug_on THEN
9775: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
9776: END IF;
9777:
9778: l_total_net_wt := 0;
9779: l_total_gross_wt := 0;

Line 9783: WSH_WV_UTILS.Detail_Weight_Volume(

9779: l_total_gross_wt := 0;
9780: l_total_vol := 0;
9781: FOR i in 1..l_dd_id_tab.count LOOP
9782:
9783: WSH_WV_UTILS.Detail_Weight_Volume(
9784: p_delivery_detail_id => l_dd_id_tab(i),
9785: p_update_flag => 'Y',
9786: x_net_weight => l_split_weight,
9787: x_volume => l_split_volume,

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

9875: --
9876: -- HW OPMCONV - Removed branching
9877:
9878: /* Bug 2177410, also update net_weight and volume of original delivery detail
9879: because non item does not use WSH_WV_UTILS.Detail_Weight_Volume to
9880: adjust the net_weight and volume */
9881:
9882: x_split_detail_id := l_new_delivery_detail_id;
9883:

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

9986: -- J: W/V Changes
9987: -- Decrement the DD W/V from parent if p_unassign_flag is 'Y'
9988: IF (p_unassign_flag = 'Y') THEN
9989: IF l_debug_on THEN
9990: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
9991: END IF;
9992: --
9993: WSH_WV_UTILS.DD_WV_Post_Process(
9994: p_delivery_detail_id => p_old_delivery_detail_rec.delivery_detail_id,

Line 9993: WSH_WV_UTILS.DD_WV_Post_Process(

9989: IF l_debug_on THEN
9990: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
9991: END IF;
9992: --
9993: WSH_WV_UTILS.DD_WV_Post_Process(
9994: p_delivery_detail_id => p_old_delivery_detail_rec.delivery_detail_id,
9995: p_diff_gross_wt => -1 * l_total_gross_wt,
9996: p_diff_net_wt => -1 * l_total_net_wt,
9997: p_diff_fill_volume => -1 * l_total_vol,

Line 10289: wsh_wv_utils.convert_uom(

10285: -- primary reservation is more the primary requested and secondary reservation is less than the secondary requested
10286: -- then you will get a call to this api when -ve p_req_quantity
10287: IF l_fulfillment_base = 'S' and l_qty <= 0 THEN
10288: l_qty :=
10289: wsh_wv_utils.convert_uom(
10290: from_uom => old_delivery_detail_rec.requested_quantity_uom2,
10291: to_uom => old_delivery_detail_rec.requested_quantity_uom,
10292: quantity => l_qty2,
10293: item_id => old_delivery_detail_rec.inventory_item_id,

Line 10789: wsh_wv_utils.convert_uom(

10785:
10786: -- muom: Always split the detail's Primary based on conversion from Secondary
10787: IF p_fulfillment_base = 'S' and l_delivery_details_info.requested_quantity2 > 0 THEN
10788: l_delivery_details_info.requested_quantity :=
10789: wsh_wv_utils.convert_uom(
10790: from_uom => p_old_delivery_detail_rec.requested_quantity_uom2,
10791: to_uom => p_old_delivery_detail_rec.requested_quantity_uom,
10792: quantity => l_delivery_details_info.requested_quantity2,
10793: item_id => p_old_delivery_detail_rec.inventory_item_id,

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

11187: -- During Partial Shipping with the remain qty as staged, w/v value should not be
11188: -- deducted again from the original line since during entering shipped_quantity
11189: -- w/v has been calculated for the original line but W/V should be calculated on split staged DD.
11190: IF l_debug_on THEN
11191: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
11192: END IF;
11193: WSH_WV_UTILS.Detail_Weight_Volume(
11194: p_delivery_detail_id => l_new_delivery_detail_id,
11195: p_update_flag => 'Y',

Line 11193: WSH_WV_UTILS.Detail_Weight_Volume(

11189: -- w/v has been calculated for the original line but W/V should be calculated on split staged DD.
11190: IF l_debug_on THEN
11191: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
11192: END IF;
11193: WSH_WV_UTILS.Detail_Weight_Volume(
11194: p_delivery_detail_id => l_new_delivery_detail_id,
11195: p_update_flag => 'Y',
11196: x_net_weight => l_split_weight,
11197: x_volume => l_split_volume,

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

11297: /* LG new */
11298:
11299: /* HW OPMCONV - Removed branching
11300: /* Bug 2177410, also update net_weight and volume of original delivery detail
11301: because non item does not use WSH_WV_UTILS.Detail_Weight_Volume to
11302: adjust the net_weight and volume */
11303:
11304: x_split_detail_id := l_new_delivery_detail_id;
11305:

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

11383: END IF;
11384: IF (l_upd_wv_on_split_stg_dd = 'Y') THEN
11385: --{
11386: IF l_debug_on THEN
11387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
11388: END IF;
11389: WSH_WV_UTILS.DD_WV_Post_Process(
11390: p_delivery_detail_id => l_new_delivery_detail_id,
11391: p_diff_gross_wt => l_split_weight,

Line 11389: WSH_WV_UTILS.DD_WV_Post_Process(

11385: --{
11386: IF l_debug_on THEN
11387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
11388: END IF;
11389: WSH_WV_UTILS.DD_WV_Post_Process(
11390: p_delivery_detail_id => l_new_delivery_detail_id,
11391: p_diff_gross_wt => l_split_weight,
11392: p_diff_net_wt => l_split_weight,
11393: p_diff_fill_volume => NULL,

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

11403: -- J: W/V Changes
11404: -- Decrement the DD W/V from parent if p_unassign_flag is 'Y'
11405: IF (p_unassign_flag = 'Y') THEN
11406: IF l_debug_on THEN
11407: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
11408: END IF;
11409: --
11410: WSH_WV_UTILS.DD_WV_Post_Process(
11411: p_delivery_detail_id => p_old_delivery_detail_rec.delivery_detail_id,

Line 11410: WSH_WV_UTILS.DD_WV_Post_Process(

11406: IF l_debug_on THEN
11407: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
11408: END IF;
11409: --
11410: WSH_WV_UTILS.DD_WV_Post_Process(
11411: p_delivery_detail_id => p_old_delivery_detail_rec.delivery_detail_id,
11412: p_diff_gross_wt => -1 * l_total_gross_wt,
11413: p_diff_net_wt => -1 * l_total_net_wt,
11414: p_diff_fill_volume => -1 * l_total_vol,

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

12937:
12938: FOR l_index in l_cons_dd_ids.FIRST..l_cons_dd_ids.LAST LOOP
12939:
12940: IF l_debug_on THEN
12941: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
12942: END IF;
12943: --
12944: WSH_WV_UTILS.Detail_Weight_Volume(
12945: p_delivery_detail_id => l_cons_dd_ids(l_index),

Line 12944: WSH_WV_UTILS.Detail_Weight_Volume(

12940: IF l_debug_on THEN
12941: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
12942: END IF;
12943: --
12944: WSH_WV_UTILS.Detail_Weight_Volume(
12945: p_delivery_detail_id => l_cons_dd_ids(l_index),
12946: p_update_flag => 'Y',
12947: p_post_process_flag => 'Y',
12948: p_calc_wv_if_frozen => 'Y',

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

13038: volume = l_new_vol
13039: WHERE delivery_detail_id = l_partial_dd_ids(l_index);
13040:
13041: IF l_debug_on THEN
13042: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
13043: END IF;
13044:
13045: WSH_WV_UTILS.DD_WV_Post_Process(
13046: p_delivery_detail_id => l_partial_dd_ids(l_index),

Line 13045: WSH_WV_UTILS.DD_WV_Post_Process(

13041: IF l_debug_on THEN
13042: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DD_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
13043: END IF;
13044:
13045: WSH_WV_UTILS.DD_WV_Post_Process(
13046: p_delivery_detail_id => l_partial_dd_ids(l_index),
13047: p_diff_gross_wt => -1 * (l_gross_weight - l_new_gross_wt),
13048: p_diff_net_wt => -1 * (l_net_weight - l_new_net_wt),
13049: p_diff_fill_volume => -1 * (l_volume - l_new_vol),