DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERIES_PVT dependencies on WSH_WV_UTILS

Line 657: l_old_gross_wt := WSH_WV_UTILS.Convert_Uom(

653: END IF;
654:
655: IF l_weight_uom_code <> p_delivery_info.weight_uom_code THEN
656:
657: l_old_gross_wt := WSH_WV_UTILS.Convert_Uom(
658: from_uom => l_weight_uom_code,
659: to_uom => p_delivery_info.weight_uom_code,
660: quantity => l_gross_wt);
661:

Line 662: l_old_net_wt := WSH_WV_UTILS.Convert_Uom(

658: from_uom => l_weight_uom_code,
659: to_uom => p_delivery_info.weight_uom_code,
660: quantity => l_gross_wt);
661:
662: l_old_net_wt := WSH_WV_UTILS.Convert_Uom(
663: from_uom => l_weight_uom_code,
664: to_uom => p_delivery_info.weight_uom_code,
665: quantity => l_net_wt);
666: ELSE

Line 675: l_old_volume := WSH_WV_UTILS.Convert_Uom(

671: END IF;
672:
673: IF l_volume_uom_code <> p_delivery_info.volume_uom_code THEN
674:
675: l_old_volume := WSH_WV_UTILS.Convert_Uom(
676: from_uom => l_volume_uom_code,
677: to_uom => p_delivery_info.volume_uom_code,
678: quantity => l_volume);
679:

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

1058: -- If UOM changes then compute the delta (difference between new W/V and old W/V)
1059: IF ( NVL(l_weight_uom_code,'-99') <> NVL(p_delivery_info.weight_uom_code,'-99') AND
1060: l_gross_weight is not null ) THEN -- BugFix #4587421
1061: IF l_debug_on THEN
1062: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
1063: END IF;
1064: l_diff_gross_wt := WSH_WV_UTILS.convert_uom(
1065: from_uom => p_delivery_info.weight_uom_code,
1066: to_uom => l_weight_uom_code,

Line 1064: l_diff_gross_wt := WSH_WV_UTILS.convert_uom(

1060: l_gross_weight is not null ) THEN -- BugFix #4587421
1061: IF l_debug_on THEN
1062: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
1063: END IF;
1064: l_diff_gross_wt := WSH_WV_UTILS.convert_uom(
1065: from_uom => p_delivery_info.weight_uom_code,
1066: to_uom => l_weight_uom_code,
1067: quantity => l_gross_weight) - NVL(l_gross_wt,0); -- BugFix #4587421
1068:

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

1066: to_uom => l_weight_uom_code,
1067: quantity => l_gross_weight) - NVL(l_gross_wt,0); -- BugFix #4587421
1068:
1069: IF l_debug_on THEN
1070: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
1071: END IF;
1072: l_diff_net_wt := WSH_WV_UTILS.convert_uom(
1073: from_uom => p_delivery_info.weight_uom_code,
1074: to_uom => l_weight_uom_code,

Line 1072: l_diff_net_wt := WSH_WV_UTILS.convert_uom(

1068:
1069: IF l_debug_on THEN
1070: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
1071: END IF;
1072: l_diff_net_wt := WSH_WV_UTILS.convert_uom(
1073: from_uom => p_delivery_info.weight_uom_code,
1074: to_uom => l_weight_uom_code,
1075: quantity => l_net_weight) - NVL(l_net_wt,0); -- BigFix #4587421
1076: ELSE

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

1080:
1081: IF (NVL(l_volume_uom_code,'-99') <> NVL(p_delivery_info.volume_uom_code,'-99') AND
1082: p_delivery_info.volume is not null) THEN
1083: IF l_debug_on THEN
1084: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
1085: END IF;
1086: l_diff_vol := WSH_WV_UTILS.convert_uom(
1087: from_uom => p_delivery_info.volume_uom_code,
1088: to_uom => l_volume_uom_code,

Line 1086: l_diff_vol := WSH_WV_UTILS.convert_uom(

1082: p_delivery_info.volume is not null) THEN
1083: IF l_debug_on THEN
1084: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
1085: END IF;
1086: l_diff_vol := WSH_WV_UTILS.convert_uom(
1087: from_uom => p_delivery_info.volume_uom_code,
1088: to_uom => l_volume_uom_code,
1089: quantity => p_delivery_info.volume) - NVL(l_volume,0);
1090: ELSE

Line 1103: l_diff_gross_wt := WSH_WV_UTILS.convert_uom( from_uom => l_weight_uom_code,

1099: --
1100: IF (l_weight_uom_code<>p_delivery_info.weight_uom_code) THEN
1101:
1102: IF (l_diff_gross_wt IS NOT NULL) THEN
1103: l_diff_gross_wt := WSH_WV_UTILS.convert_uom( from_uom => l_weight_uom_code,
1104: to_uom =>p_delivery_info.weight_uom_code,
1105: quantity => l_diff_gross_wt);
1106: END IF;
1107:

Line 1109: l_diff_net_wt := WSH_WV_UTILS.convert_uom( from_uom => l_weight_uom_code,

1105: quantity => l_diff_gross_wt);
1106: END IF;
1107:
1108: IF (l_diff_net_wt IS NOT NULL) THEN
1109: l_diff_net_wt := WSH_WV_UTILS.convert_uom( from_uom => l_weight_uom_code,
1110: to_uom =>p_delivery_info.weight_uom_code,
1111: quantity => l_diff_net_wt);
1112: END IF;
1113: END IF;

Line 1116: l_diff_vol:= WSH_WV_UTILS.convert_uom( from_uom => l_volume_uom_code,

1112: END IF;
1113: END IF;
1114:
1115: IF (l_volume_uom_code<>p_delivery_info.volume_uom_code AND l_diff_vol IS NOT NULL) THEN
1116: l_diff_vol:= WSH_WV_UTILS.convert_uom( from_uom => l_volume_uom_code,
1117: to_uom => p_delivery_info.volume_uom_code,
1118: quantity => l_diff_vol);
1119:
1120: END IF;

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

1123: -- Bug No:4085560 - 11.5.10.1CU:INCORRECT WT SHOWN FOR THE STOP(end)
1124: --
1125:
1126: IF l_debug_on THEN
1127: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DEL_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
1128: END IF;
1129:
1130: WSH_WV_UTILS.DEL_WV_Post_Process(
1131: p_delivery_id => p_delivery_info.delivery_id,

Line 1130: WSH_WV_UTILS.DEL_WV_Post_Process(

1126: IF l_debug_on THEN
1127: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DEL_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
1128: END IF;
1129:
1130: WSH_WV_UTILS.DEL_WV_Post_Process(
1131: p_delivery_id => p_delivery_info.delivery_id,
1132: p_diff_gross_wt => l_diff_gross_wt,
1133: p_diff_net_wt => l_diff_net_wt,
1134: p_diff_volume => l_diff_vol,

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

1147: IF NVL(p_delivery_info.delivery_type, 'STANDARD')='STANDARD' AND NVL(p_delivery_info.PRORATE_WT_FLAG,'N')='Y'
1148: AND (nvl(l_diff_gross_wt,0) <> 0 OR nvl(l_diff_net_wt,0) <> 0) THEN --{
1149: --
1150: IF l_debug_on THEN
1151: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.prorate_weight',WSH_DEBUG_SV.C_PROC_LEVEL);
1152: END IF;
1153: --
1154: WSH_WV_UTILS.prorate_weight(
1155: p_entity_type => 'DELIVERY',

Line 1154: WSH_WV_UTILS.prorate_weight(

1150: IF l_debug_on THEN
1151: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.prorate_weight',WSH_DEBUG_SV.C_PROC_LEVEL);
1152: END IF;
1153: --
1154: WSH_WV_UTILS.prorate_weight(
1155: p_entity_type => 'DELIVERY',
1156: p_entity_id => p_delivery_info.delivery_id,
1157: p_old_gross_wt => l_gross_wt,
1158: p_new_gross_wt => l_gross_weight, -- BigFix #4587421

Line 1167: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WV_UTILS.prorate_weight',l_return_status);

1163: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1164: x_return_status := l_return_status;
1165: --
1166: IF l_debug_on THEN
1167: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WV_UTILS.prorate_weight',l_return_status);
1168: END IF;
1169: --
1170: wsh_util_core.api_post_call(
1171: p_return_status => l_return_status,