DBA Data[Home] [Help]

APPS.WSH_TRIPS_ACTIONS dependencies on WSH_WV_UTILS

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

5334: IF (l_vehicle_item_id IS NOT NULL) AND (l_vehicle_org_id IS NOT NULL) THEN
5335:
5336: IF (l_fill_basis = 'W') AND (l_trip_max_weight IS NOT NULL) AND (l_trip_weight_uom IS NOT NULL) THEN
5337: IF l_debug_on THEN
5338: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5339: END IF;
5340: --
5341: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_weight_uom, l_stop_wt_uom, l_trip_max_weight);
5342: IF (l_wt_vol_tmp > 0) THEN

Line 5341: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_weight_uom, l_stop_wt_uom, l_trip_max_weight);

5337: IF l_debug_on THEN
5338: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5339: END IF;
5340: --
5341: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_weight_uom, l_stop_wt_uom, l_trip_max_weight);
5342: IF (l_wt_vol_tmp > 0) THEN
5343: x_stop_fill_percent := round( 100 * p_gross_weight / l_wt_vol_tmp);
5344: END IF;
5345: ELSIF (l_fill_basis = 'V') AND (l_trip_max_volume IS NOT NULL) AND (l_trip_volume_uom IS NOT NULL) THEN

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

5344: END IF;
5345: ELSIF (l_fill_basis = 'V') AND (l_trip_max_volume IS NOT NULL) AND (l_trip_volume_uom IS NOT NULL) THEN
5346:
5347: IF l_debug_on THEN
5348: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5349: END IF;
5350: --
5351: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_volume_uom, l_stop_vol_uom, l_trip_max_volume);
5352: IF (l_wt_vol_tmp > 0) THEN

Line 5351: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_volume_uom, l_stop_vol_uom, l_trip_max_volume);

5347: IF l_debug_on THEN
5348: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5349: END IF;
5350: --
5351: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_volume_uom, l_stop_vol_uom, l_trip_max_volume);
5352: IF (l_wt_vol_tmp > 0) THEN
5353: x_stop_fill_percent := round( 100 * p_volume / l_wt_vol_tmp );
5354: END IF;
5355: ELSE

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

5812: --
5813: -- Debug Statements
5814: --
5815: IF l_debug_on THEN
5816: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5817: END IF;
5818: --
5819: l_total_net_weight := wsh_wv_utils.convert_uom(l_prev_wt_uom, l_stop_wt_uom, l_total_net_weight);
5820: --

Line 5819: l_total_net_weight := wsh_wv_utils.convert_uom(l_prev_wt_uom, l_stop_wt_uom, l_total_net_weight);

5815: IF l_debug_on THEN
5816: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5817: END IF;
5818: --
5819: l_total_net_weight := wsh_wv_utils.convert_uom(l_prev_wt_uom, l_stop_wt_uom, l_total_net_weight);
5820: --
5821: -- Debug Statements
5822: --
5823: IF l_debug_on THEN

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

5820: --
5821: -- Debug Statements
5822: --
5823: IF l_debug_on THEN
5824: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5825: END IF;
5826: --
5827: l_total_gross_weight := wsh_wv_utils.convert_uom(l_prev_wt_uom, l_stop_wt_uom, l_total_gross_weight);
5828: --

Line 5827: l_total_gross_weight := wsh_wv_utils.convert_uom(l_prev_wt_uom, l_stop_wt_uom, l_total_gross_weight);

5823: IF l_debug_on THEN
5824: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5825: END IF;
5826: --
5827: l_total_gross_weight := wsh_wv_utils.convert_uom(l_prev_wt_uom, l_stop_wt_uom, l_total_gross_weight);
5828: --
5829: -- Debug Statements
5830: --
5831: IF l_debug_on THEN

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

5828: --
5829: -- Debug Statements
5830: --
5831: IF l_debug_on THEN
5832: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5833: END IF;
5834: --
5835: l_volume := wsh_wv_utils.convert_uom(l_prev_vol_uom, l_stop_vol_uom, l_total_volume);
5836:

Line 5835: l_volume := wsh_wv_utils.convert_uom(l_prev_vol_uom, l_stop_vol_uom, l_total_volume);

5831: IF l_debug_on THEN
5832: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5833: END IF;
5834: --
5835: l_volume := wsh_wv_utils.convert_uom(l_prev_vol_uom, l_stop_vol_uom, l_total_volume);
5836:
5837: g_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5838:
5839: IF l_debug_on THEN

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

5846: --
5847: -- Debug Statements
5848: --
5849: IF l_debug_on THEN
5850: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DELIVERY_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
5851: END IF;
5852: --
5853: wsh_wv_utils.delivery_weight_volume(
5854: p_delivery_id => pkup_dl.d_id,

Line 5853: wsh_wv_utils.delivery_weight_volume(

5849: IF l_debug_on THEN
5850: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DELIVERY_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
5851: END IF;
5852: --
5853: wsh_wv_utils.delivery_weight_volume(
5854: p_delivery_id => pkup_dl.d_id,
5855: p_update_flag => 'Y',
5856: p_calc_wv_if_frozen => p_calc_wv_if_frozen,
5857: x_gross_weight => l_gross_weight,

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

5897: -- J: W/V Changes
5898: IF l_net_weight >= 0 THEN
5899: IF pkup_dl.wt_uom <> l_stop_wt_uom THEN
5900: IF l_debug_on THEN
5901: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5902: END IF;
5903: --
5904: IF l_net_weight > 0
5905: THEN

Line 5906: l_total_net_weight := l_total_net_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_net_weight);

5902: END IF;
5903: --
5904: IF l_net_weight > 0
5905: THEN
5906: l_total_net_weight := l_total_net_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_net_weight);
5907: ELSE
5908: l_total_net_weight := l_total_net_weight + l_net_weight;
5909: END IF;
5910: ELSE

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

5914:
5915: IF l_gross_weight >= 0 THEN
5916: IF pkup_dl.wt_uom <> l_stop_wt_uom THEN
5917: IF l_debug_on THEN
5918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5919: END IF;
5920: --
5921: IF l_gross_weight > 0
5922: THEN

Line 5923: l_total_gross_weight := l_total_gross_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_gross_weight);

5919: END IF;
5920: --
5921: IF l_gross_weight > 0
5922: THEN
5923: l_total_gross_weight := l_total_gross_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_gross_weight);
5924: --R12 MDC
5925: l_total_pick_up_weight := l_total_pick_up_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_gross_weight);
5926: ELSE
5927: l_total_gross_weight := l_total_gross_weight + l_gross_weight;

Line 5925: l_total_pick_up_weight := l_total_pick_up_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_gross_weight);

5921: IF l_gross_weight > 0
5922: THEN
5923: l_total_gross_weight := l_total_gross_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_gross_weight);
5924: --R12 MDC
5925: l_total_pick_up_weight := l_total_pick_up_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_gross_weight);
5926: ELSE
5927: l_total_gross_weight := l_total_gross_weight + l_gross_weight;
5928: --R12 MDC
5929: l_total_pick_up_weight := l_total_pick_up_weight + l_gross_weight;

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

5937:
5938: IF l_volume >= 0 THEN
5939: IF pkup_dl.vol_uom <> l_stop_vol_uom THEN
5940: IF l_debug_on THEN
5941: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5942: END IF;
5943: --
5944: IF l_volume > 0
5945: THEN

Line 5946: l_total_volume := l_total_volume + wsh_wv_utils.convert_uom(pkup_dl.vol_uom, l_stop_vol_uom, l_volume);

5942: END IF;
5943: --
5944: IF l_volume > 0
5945: THEN
5946: l_total_volume := l_total_volume + wsh_wv_utils.convert_uom(pkup_dl.vol_uom, l_stop_vol_uom, l_volume);
5947: --R12 MDC
5948: l_total_pick_up_volume := l_total_pick_up_volume + wsh_wv_utils.convert_uom(pkup_dl.vol_uom, l_stop_vol_uom, l_volume);
5949: ELSE
5950: l_total_volume := l_total_volume + l_volume;

Line 5948: l_total_pick_up_volume := l_total_pick_up_volume + wsh_wv_utils.convert_uom(pkup_dl.vol_uom, l_stop_vol_uom, l_volume);

5944: IF l_volume > 0
5945: THEN
5946: l_total_volume := l_total_volume + wsh_wv_utils.convert_uom(pkup_dl.vol_uom, l_stop_vol_uom, l_volume);
5947: --R12 MDC
5948: l_total_pick_up_volume := l_total_pick_up_volume + wsh_wv_utils.convert_uom(pkup_dl.vol_uom, l_stop_vol_uom, l_volume);
5949: ELSE
5950: l_total_volume := l_total_volume + l_volume;
5951: --R12 MDC
5952: l_total_pick_up_volume := l_total_pick_up_volume + l_volume;

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

5985: -- J: W/V Changes
5986: IF pickup_del_tab(l_dpoff_dl_id_mod).net_weight > 0 THEN
5987: IF pickup_del_tab(l_dpoff_dl_id_mod).wt_uom <> l_stop_wt_uom THEN
5988: IF l_debug_on THEN
5989: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5990: END IF;
5991: --
5992: l_total_net_weight := l_total_net_weight - wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).wt_uom, l_stop_wt_uom , pickup_del_tab(l_dpoff_dl_id_mod).net_weight);
5993: ELSE

Line 5992: l_total_net_weight := l_total_net_weight - wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).wt_uom, l_stop_wt_uom , pickup_del_tab(l_dpoff_dl_id_mod).net_weight);

5988: IF l_debug_on THEN
5989: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5990: END IF;
5991: --
5992: l_total_net_weight := l_total_net_weight - wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).wt_uom, l_stop_wt_uom , pickup_del_tab(l_dpoff_dl_id_mod).net_weight);
5993: ELSE
5994: l_total_net_weight := l_total_net_weight - pickup_del_tab(l_dpoff_dl_id_mod).net_weight;
5995: END IF;
5996: END IF;

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

5998:
5999: IF pickup_del_tab(l_dpoff_dl_id_mod).gross_weight > 0 THEN
6000: IF pickup_del_tab(l_dpoff_dl_id_mod).wt_uom <> l_stop_wt_uom THEN
6001: IF l_debug_on THEN
6002: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6003: END IF;
6004: --
6005: IF l_stop_id <> l_last_stop_id THEN
6006: l_total_gross_weight := l_total_gross_weight - wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).wt_uom, l_stop_wt_uom, pickup_del_tab(l_dpoff_dl_id_mod).gross_weight);

Line 6006: l_total_gross_weight := l_total_gross_weight - wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).wt_uom, l_stop_wt_uom, pickup_del_tab(l_dpoff_dl_id_mod).gross_weight);

6002: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6003: END IF;
6004: --
6005: IF l_stop_id <> l_last_stop_id THEN
6006: l_total_gross_weight := l_total_gross_weight - wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).wt_uom, l_stop_wt_uom, pickup_del_tab(l_dpoff_dl_id_mod).gross_weight);
6007: END IF;
6008: --R12 MDC
6009: l_total_drop_off_weight := l_total_drop_off_weight + wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).wt_uom, l_stop_wt_uom, pickup_del_tab(l_dpoff_dl_id_mod).gross_weight);
6010: ELSE

Line 6009: l_total_drop_off_weight := l_total_drop_off_weight + wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).wt_uom, l_stop_wt_uom, pickup_del_tab(l_dpoff_dl_id_mod).gross_weight);

6005: IF l_stop_id <> l_last_stop_id THEN
6006: l_total_gross_weight := l_total_gross_weight - wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).wt_uom, l_stop_wt_uom, pickup_del_tab(l_dpoff_dl_id_mod).gross_weight);
6007: END IF;
6008: --R12 MDC
6009: l_total_drop_off_weight := l_total_drop_off_weight + wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).wt_uom, l_stop_wt_uom, pickup_del_tab(l_dpoff_dl_id_mod).gross_weight);
6010: ELSE
6011: IF l_stop_id <> l_last_stop_id THEN
6012: l_total_gross_weight := l_total_gross_weight - pickup_del_tab(l_dpoff_dl_id_mod).gross_weight;
6013: END IF;

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

6018:
6019: IF pickup_del_tab(l_dpoff_dl_id_mod).volume > 0 THEN
6020: IF pickup_del_tab(l_dpoff_dl_id_mod).vol_uom <> l_stop_vol_uom THEN
6021: IF l_debug_on THEN
6022: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6023: END IF;
6024: --
6025: IF l_stop_id <> l_last_stop_id THEN
6026: l_total_volume := l_total_volume - wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).vol_uom, l_stop_vol_uom, pickup_del_tab(l_dpoff_dl_id_mod).volume);

Line 6026: l_total_volume := l_total_volume - wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).vol_uom, l_stop_vol_uom, pickup_del_tab(l_dpoff_dl_id_mod).volume);

6022: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6023: END IF;
6024: --
6025: IF l_stop_id <> l_last_stop_id THEN
6026: l_total_volume := l_total_volume - wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).vol_uom, l_stop_vol_uom, pickup_del_tab(l_dpoff_dl_id_mod).volume);
6027: END IF;
6028: --R12 MDC
6029: l_total_drop_off_volume := l_total_drop_off_volume + wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).vol_uom, l_stop_vol_uom, pickup_del_tab(l_dpoff_dl_id_mod).volume);
6030: ELSE

Line 6029: l_total_drop_off_volume := l_total_drop_off_volume + wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).vol_uom, l_stop_vol_uom, pickup_del_tab(l_dpoff_dl_id_mod).volume);

6025: IF l_stop_id <> l_last_stop_id THEN
6026: l_total_volume := l_total_volume - wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).vol_uom, l_stop_vol_uom, pickup_del_tab(l_dpoff_dl_id_mod).volume);
6027: END IF;
6028: --R12 MDC
6029: l_total_drop_off_volume := l_total_drop_off_volume + wsh_wv_utils.convert_uom(pickup_del_tab(l_dpoff_dl_id_mod).vol_uom, l_stop_vol_uom, pickup_del_tab(l_dpoff_dl_id_mod).volume);
6030: ELSE
6031: IF l_stop_id <> l_last_stop_id THEN
6032: l_total_volume := l_total_volume - pickup_del_tab(l_dpoff_dl_id_mod).volume;
6033: END IF;

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

6056: --
6057: -- Debug Statements
6058: --
6059: IF l_debug_on THEN
6060: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6061: END IF;
6062: --
6063: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_weight_uom, l_stop_wt_uom, l_trip_max_weight);
6064: IF (l_wt_vol_tmp > 0) THEN

Line 6063: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_weight_uom, l_stop_wt_uom, l_trip_max_weight);

6059: IF l_debug_on THEN
6060: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6061: END IF;
6062: --
6063: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_weight_uom, l_stop_wt_uom, l_trip_max_weight);
6064: IF (l_wt_vol_tmp > 0) THEN
6065: l_stop_fill_percent := round( 100 * l_total_gross_weight / l_wt_vol_tmp);
6066: END IF;
6067: ELSIF (l_fill_basis = 'V') AND (l_trip_max_volume IS NOT NULL) AND (l_trip_volume_uom IS NOT NULL) THEN

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

6069: --
6070: -- Debug Statements
6071: --
6072: IF l_debug_on THEN
6073: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6074: END IF;
6075: --
6076: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_volume_uom, l_stop_vol_uom, l_trip_max_volume);
6077: IF (l_wt_vol_tmp > 0) THEN

Line 6076: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_volume_uom, l_stop_vol_uom, l_trip_max_volume);

6072: IF l_debug_on THEN
6073: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6074: END IF;
6075: --
6076: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_volume_uom, l_stop_vol_uom, l_trip_max_volume);
6077: IF (l_wt_vol_tmp > 0) THEN
6078: l_stop_fill_percent := round( 100 * l_total_volume / l_wt_vol_tmp );
6079: END IF;
6080: ELSE

Line 8360: l_pickup_weight_convert := WSH_WV_UTILS.Convert_Uom(

8356:
8357: IF nvl(l_cs_tripstops_tab(j).PICK_UP_WEIGHT,0) <> 0 THEN
8358:
8359: IF l_cs_tripstops_tab(j).weight_uom_code <> l_base_weight_uom THEN
8360: l_pickup_weight_convert := WSH_WV_UTILS.Convert_Uom(
8361: from_uom => l_cs_tripstops_tab(j).weight_uom_code,
8362: to_uom => l_base_weight_uom,
8363: quantity => l_cs_tripstops_tab(j).PICK_UP_WEIGHT);
8364: ELSE

Line 8373: l_pickup_volume_convert := WSH_WV_UTILS.Convert_Uom(

8369:
8370: IF nvl(l_cs_tripstops_tab(j).PICK_UP_volume,0) <> 0 THEN
8371:
8372: IF l_cs_tripstops_tab(j).volume_uom_code <> l_base_volume_uom THEN
8373: l_pickup_volume_convert := WSH_WV_UTILS.Convert_Uom(
8374: from_uom => l_cs_tripstops_tab(j).volume_uom_code,
8375: to_uom => l_base_volume_uom,
8376: quantity => l_cs_tripstops_tab(j).PICK_UP_volume);
8377: ELSE