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_FREIGHT_COSTS_PVT dependencies on WSH_UTIL_CORE

Line 52: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

48: IF l_debug_on THEN
49: WSH_DEBUG_SV.push(l_module_name);
50: END IF;
51: --
52: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
53:
54: x_freight_cost_id := p_freight_cost_info.freight_cost_id;
55: IF (x_freight_cost_id IS NULL) THEN
56: LOOP

Line 199: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.CREATE_FREIGHT_COST');

195: END IF;
196: --
197: EXCEPTION
198: WHEN create_failure THEN
199: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.CREATE_FREIGHT_COST');
200: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
201:
202: --
203: -- Debug Statements

Line 200: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

196: --
197: EXCEPTION
198: WHEN create_failure THEN
199: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.CREATE_FREIGHT_COST');
200: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
201:
202: --
203: -- Debug Statements
204: --

Line 296: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

292: WSH_DEBUG_SV.log(l_module_name,'billable_uom',p_freight_cost_info.billable_uom);
293: WSH_DEBUG_SV.log(l_module_name,'billable_basis',p_freight_cost_info.billable_basis);
294: END IF;
295: --
296: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
297:
298: UPDATE wsh_freight_costs
299: SET
300: freight_cost_id = p_freight_cost_info.freight_cost_id,

Line 357: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

353: WHERE freight_cost_id = p_freight_cost_info.freight_cost_id;
354:
355: IF (SQL%NOTFOUND) THEN
356: RAISE NO_DATA_FOUND;
357: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
358: END IF;
359:
360: --
361: -- Debug Statements

Line 369: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

365: END IF;
366: --
367: EXCEPTION
368: WHEN OTHERS THEN
369: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
370: wsh_util_core.default_handler ('WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost');
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
373: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 370: wsh_util_core.default_handler ('WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost');

366: --
367: EXCEPTION
368: WHEN OTHERS THEN
369: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
370: wsh_util_core.default_handler ('WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost');
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
373: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
374: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 710: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

706: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
707: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_ID',P_FREIGHT_COST_ID);
708: END IF;
709: --
710: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
711: l_freight_cost_id := p_freight_cost_id;
712:
713: IF (p_rowid IS NOT NULL) THEN
714: OPEN C_Get_freight_cost_id;

Line 735: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.DELETE_FREIGHT_COST');

731: END IF;
732: --
733: EXCEPTION
734: WHEN others THEN
735: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.DELETE_FREIGHT_COST');
736: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
737: --
738: -- Debug Statements
739: --

Line 736: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

732: --
733: EXCEPTION
734: WHEN others THEN
735: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.DELETE_FREIGHT_COST');
736: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
737: --
738: -- Debug Statements
739: --
740: IF l_debug_on THEN

Line 816: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

812: l_new_unit_amount NUMBER := 0;
813: l_round_unit_amount NUMBER := 0;
814: l_remained_unit_amount NUMBER := 0;
815: l_rowid VARCHAR2(30) := NULL;
816: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
817: l_freight_cost_id NUMBER := 0;
818:
819: WSH_FC_NOT_FOUND EXCEPTION;
820:

Line 848: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

844: WSH_DEBUG_SV.log(l_module_name,'P_REQUESTED_QUANTITY',P_REQUESTED_QUANTITY);
845: WSH_DEBUG_SV.log(l_module_name,'P_SPLIT_REQUESTED_QUANTITY',P_SPLIT_REQUESTED_QUANTITY);
846: END IF;
847: --
848: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
849:
850:
851:
852: OPEN c_freight_cost( p_from_freight_cost_id);

Line 935: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

931: , x_freight_cost_id => l_freight_cost_id
932: , x_return_status => l_return_status
933: );
934:
935: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
936: UPDATE WSH_FREIGHT_COSTS
937: SET UNIT_AMOUNT = l_remained_unit_amount
938: WHERE CURRENT OF c_freight_cost;
939: ELSE

Line 955: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.SPLIT_FREIGHT_COST');

951: --
952: EXCEPTION
953:
954: WHEN WSH_FC_NOT_FOUND THEN
955: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.SPLIT_FREIGHT_COST');
956: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
957:
958: --
959: -- Debug Statements

Line 956: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

952: EXCEPTION
953:
954: WHEN WSH_FC_NOT_FOUND THEN
955: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.SPLIT_FREIGHT_COST');
956: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
957:
958: --
959: -- Debug Statements
960: --

Line 1042: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1038: IF l_debug_on THEN
1039: WSH_DEBUG_SV.push(l_module_name);
1040: END IF;
1041: --
1042: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1043:
1044: x_total_amount := NULL;
1045:
1046: IF p_entity_level = 'Delivery' THEN

Line 1066: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1062: p_amount => l_freight_cost,
1063: x_converted_amount => l_converted_amount,
1064: x_return_status => l_return_status) ;
1065:
1066: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1067: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1068: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1069: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1070: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 1068: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1064: x_return_status => l_return_status) ;
1065:
1066: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1067: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1068: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1069: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1070: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1071: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1072: END IF;

Line 1070: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1066: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1067: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1068: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1069: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1070: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1071: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1072: END IF;
1073: ELSE
1074: raise convert_amount_error;

Line 1071: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1067: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1068: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1069: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1070: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1071: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1072: END IF;
1073: ELSE
1074: raise convert_amount_error;
1075: END IF;

Line 1100: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1096: p_amount => l_freight_cost,
1097: x_converted_amount => l_converted_amount,
1098: x_return_status => l_return_status) ;
1099:
1100: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1101: l_total_amount := l_total_amount + NVL(l_converted_amount, 0);
1102: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1103: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1104: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 1102: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1098: x_return_status => l_return_status) ;
1099:
1100: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1101: l_total_amount := l_total_amount + NVL(l_converted_amount, 0);
1102: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1103: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1104: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1105: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1106: END IF;

Line 1104: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1100: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1101: l_total_amount := l_total_amount + NVL(l_converted_amount, 0);
1102: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1103: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1104: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1105: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1106: END IF;
1107: ELSE
1108: raise convert_amount_error;

Line 1105: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1101: l_total_amount := l_total_amount + NVL(l_converted_amount, 0);
1102: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1103: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1104: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1105: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1106: END IF;
1107: ELSE
1108: raise convert_amount_error;
1109: END IF;

Line 1127: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1123: --
1124: EXCEPTION
1125:
1126: WHEN convert_amount_error THEN
1127: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1128:
1129: x_total_amount := NULL;
1130: IF l_debug_on THEN
1131: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Total_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1133: END IF;
1134:
1135: WHEN OTHERS THEN
1136:
1137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1138:
1139: x_total_amount := NULL;
1140: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Total_Freight_Cost');
1141:

Line 1140: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Total_Freight_Cost');

1136:
1137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1138:
1139: x_total_amount := NULL;
1140: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Total_Freight_Cost');
1141:
1142: IF l_debug_on THEN
1143: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1144: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1154: p_in_ids IN wsh_util_core.id_tab_type,

1150:
1151:
1152: --TL Rating
1153: PROCEDURE Get_Detail_Freight_Cost(
1154: p_in_ids IN wsh_util_core.id_tab_type,
1155: p_currency_code IN VARCHAR2,
1156: x_detail_amount OUT NOCOPY NUMBER ,
1157: x_return_status OUT NOCOPY VARCHAR2) IS
1158:

Line 1205: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1201: IF l_debug_on THEN
1202: WSH_DEBUG_SV.push(l_module_name);
1203: END IF;
1204: --
1205: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1206:
1207: x_detail_amount := NULL;
1208: l_index:=p_in_ids.FIRST;
1209: WHILE l_index is not null LOOP

Line 1229: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1225: p_amount => l_freight_cost,
1226: x_converted_amount => l_converted_amount,
1227: x_return_status => l_return_status) ;
1228:
1229: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1230: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1231: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1232: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1233: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 1231: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1227: x_return_status => l_return_status) ;
1228:
1229: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1230: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1231: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1232: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1233: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1234: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1235: END IF;

Line 1233: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1229: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1230: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1231: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1232: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1233: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1234: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1235: END IF;
1236: ELSE
1237: raise convert_amount_error;

Line 1234: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1230: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1231: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1232: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1233: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1234: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1235: END IF;
1236: ELSE
1237: raise convert_amount_error;
1238: END IF;

Line 1262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1258: EXCEPTION
1259:
1260: WHEN convert_amount_error THEN
1261: CLOSE freight_cost_at_detail;
1262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1263: x_detail_amount := NULL;
1264: IF l_debug_on THEN
1265: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Detail_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1266: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Detail_Freight_Cost FILURE');

Line 1270: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1266: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Detail_Freight_Cost FILURE');
1267: END IF;
1268:
1269: WHEN OTHERS THEN
1270: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1271: x_detail_amount := NULL;
1272: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_detail_Freight_Cost');
1273: IF l_debug_on THEN
1274: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1272: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_detail_Freight_Cost');

1268:
1269: WHEN OTHERS THEN
1270: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1271: x_detail_amount := NULL;
1272: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_detail_Freight_Cost');
1273: IF l_debug_on THEN
1274: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1275: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1276: END IF;

Line 1281: p_in_ids IN wsh_util_core.id_tab_type,

1277:
1278: END Get_Detail_Freight_Cost;
1279:
1280: PROCEDURE Get_LPN_Freight_Cost(
1281: p_in_ids IN wsh_util_core.id_tab_type,
1282: p_currency_code IN VARCHAR2,
1283: x_main_lpn_amount OUT NOCOPY NUMBER, --to be used only if calling entity is LPN
1284: x_lpn_amount OUT NOCOPY NUMBER,
1285: x_detail_amount OUT NOCOPY NUMBER ,

Line 1305: l_dd_ids wsh_util_core.id_tab_type;

1301: from wsh_delivery_details
1302: where delivery_detail_id=p_detailid
1303: and container_flag='Y';
1304:
1305: l_dd_ids wsh_util_core.id_tab_type;
1306: l_cont_ids wsh_util_core.id_tab_type;
1307:
1308: l_freight_cost NUMBER := 0;
1309: l_currency_code VARCHAR2(15) := NULL;

Line 1306: l_cont_ids wsh_util_core.id_tab_type;

1302: where delivery_detail_id=p_detailid
1303: and container_flag='Y';
1304:
1305: l_dd_ids wsh_util_core.id_tab_type;
1306: l_cont_ids wsh_util_core.id_tab_type;
1307:
1308: l_freight_cost NUMBER := 0;
1309: l_currency_code VARCHAR2(15) := NULL;
1310: l_conversion_type_code VARCHAR2(15) := NULL;

Line 1343: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1339: IF l_debug_on THEN
1340: WSH_DEBUG_SV.push(l_module_name);
1341: END IF;
1342: --
1343: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1344:
1345: x_lpn_amount := NULL;
1346: x_detail_amount:=null;
1347:

Line 1373: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1369: p_in_ids => l_dd_ids,
1370: p_currency_code => p_currency_code,
1371: x_detail_amount => l_detail_amount ,
1372: x_return_status => l_return_status);
1373: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1374: raise details_freight_error;
1375: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1376: x_return_status:=l_return_status;
1377: END IF;

Line 1375: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1371: x_detail_amount => l_detail_amount ,
1372: x_return_status => l_return_status);
1373: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1374: raise details_freight_error;
1375: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1376: x_return_status:=l_return_status;
1377: END IF;
1378: END IF;
1379:

Line 1386: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1382: p_in_ids => l_cont_ids,
1383: p_currency_code => p_currency_code,
1384: x_detail_amount => l_lpn_amount,
1385: x_return_status => l_return_status);
1386: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1387: raise details_freight_error;
1388: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1389: x_return_status:=l_return_status;
1390: END IF;

Line 1388: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1384: x_detail_amount => l_lpn_amount,
1385: x_return_status => l_return_status);
1386: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1387: raise details_freight_error;
1388: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1389: x_return_status:=l_return_status;
1390: END IF;
1391: END IF;
1392:

Line 1399: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1395: p_in_ids => p_in_ids,
1396: p_currency_code => p_currency_code,
1397: x_detail_amount => l_main_lpn_amount,
1398: x_return_status => l_return_status);
1399: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1400: raise details_freight_error;
1401: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1402: x_return_status:=l_return_status;
1403: END IF;

Line 1401: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1397: x_detail_amount => l_main_lpn_amount,
1398: x_return_status => l_return_status);
1399: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1400: raise details_freight_error;
1401: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1402: x_return_status:=l_return_status;
1403: END IF;
1404: END IF;
1405:

Line 1423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1419: END IF;
1420: --
1421: EXCEPTION
1422: WHEN details_freight_error THEN
1423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1424: x_main_lpn_amount := NULL;
1425: x_lpn_amount := NULL;
1426: x_detail_amount := NULL;
1427: IF l_debug_on THEN

Line 1432: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1428: WSH_DEBUG_SV.logmsg(l_module_name,'Get_LPN_Freight_Cost exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1429: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_LPN_Freight_Cost FILURE');
1430: END IF;
1431: WHEN OTHERS THEN
1432: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1433: x_main_lpn_amount := NULL;
1434: x_lpn_amount := NULL;
1435: x_detail_amount := NULL;
1436: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_LPN_Freight_Cost');

Line 1436: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_LPN_Freight_Cost');

1432: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1433: x_main_lpn_amount := NULL;
1434: x_lpn_amount := NULL;
1435: x_detail_amount := NULL;
1436: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_LPN_Freight_Cost');
1437: IF l_debug_on THEN
1438: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1439: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1440: END IF;

Line 1446: p_in_ids IN wsh_util_core.id_tab_type,

1442: END Get_LPN_Freight_Cost;
1443:
1444:
1445: PROCEDURE Get_Delivery_Freight_Cost(
1446: p_in_ids IN wsh_util_core.id_tab_type,
1447: p_currency_code IN VARCHAR2,
1448: x_delivery_amount OUT NOCOPY NUMBER,
1449: x_lpn_amount OUT NOCOPY NUMBER,
1450: x_detail_amount OUT NOCOPY NUMBER ,

Line 1472: l_dd_ids wsh_util_core.id_tab_type;

1468: freight_cost_type_id <> -1 AND
1469: unit_amount > 0 AND
1470: delivery_detail_id is null;
1471:
1472: l_dd_ids wsh_util_core.id_tab_type;
1473: l_cont_ids wsh_util_core.id_tab_type;
1474:
1475:
1476: l_freight_cost NUMBER := 0;

Line 1473: l_cont_ids wsh_util_core.id_tab_type;

1469: unit_amount > 0 AND
1470: delivery_detail_id is null;
1471:
1472: l_dd_ids wsh_util_core.id_tab_type;
1473: l_cont_ids wsh_util_core.id_tab_type;
1474:
1475:
1476: l_freight_cost NUMBER := 0;
1477: l_currency_code VARCHAR2(15) := NULL;

Line 1533: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1529: --bugfix 6692716
1530: --l_container_flag_yes := 'Y'; -- BugFix3788678
1531: --l_container_flag_no := 'N'; -- BugFix3788678
1532:
1533: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1534:
1535: x_delivery_amount := NULL;
1536:
1537: l_index:=p_in_ids.FIRST;

Line 1558: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1554: p_amount => l_freight_cost,
1555: x_converted_amount => l_converted_amount,
1556: x_return_status => l_return_status) ;
1557:
1558: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1559: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1560: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1561: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1562: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 1560: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1556: x_return_status => l_return_status) ;
1557:
1558: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1559: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1560: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1561: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1562: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1563: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1564: END IF;

Line 1562: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1558: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1559: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1560: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1561: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1562: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1563: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1564: END IF;
1565: ELSE
1566: raise convert_amount_error;

Line 1563: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1559: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1560: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1561: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1562: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1563: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1564: END IF;
1565: ELSE
1566: raise convert_amount_error;
1567: END IF;

Line 1589: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1585: p_in_ids => l_dd_ids,
1586: p_currency_code => p_currency_code,
1587: x_detail_amount => l_detail_amount ,
1588: x_return_status => l_return_status);
1589: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1590: raise details_freight_error;
1591: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1592: x_return_status:=l_return_status;
1593: END IF;

Line 1591: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1587: x_detail_amount => l_detail_amount ,
1588: x_return_status => l_return_status);
1589: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1590: raise details_freight_error;
1591: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1592: x_return_status:=l_return_status;
1593: END IF;
1594: END IF;
1595:

Line 1604: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1600: x_detail_amount => l_detail_amount_temp ,
1601: x_main_lpn_amount => l_main_lpn_amount,
1602: x_lpn_amount => l_lpn_amount,
1603: x_return_status => l_return_status);
1604: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1605: raise details_freight_error;
1606: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1607: x_return_status:=l_return_status;
1608: END IF;

Line 1606: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1602: x_lpn_amount => l_lpn_amount,
1603: x_return_status => l_return_status);
1604: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1605: raise details_freight_error;
1606: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1607: x_return_status:=l_return_status;
1608: END IF;
1609: END IF;
1610:

Line 1630: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1626: END IF;
1627: --
1628: EXCEPTION
1629: WHEN details_freight_error THEN
1630: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1631: x_delivery_amount := NULL;
1632: x_lpn_amount := NULL;
1633: x_detail_amount := NULL;
1634: IF l_debug_on THEN

Line 1640: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Delivery_Freight_Cost FILURE');
1637: END IF;
1638: WHEN convert_amount_error THEN
1639: CLOSE freight_cost_at_delivery;
1640: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1641: x_delivery_amount := NULL;
1642: x_lpn_amount := NULL;
1643: x_detail_amount := NULL;
1644: IF l_debug_on THEN

Line 1650: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1646: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Delivery_Freight_Cost FILURE');
1647: END IF;
1648:
1649: WHEN OTHERS THEN
1650: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1651: x_delivery_amount := NULL;
1652: x_lpn_amount := NULL;
1653: x_detail_amount := NULL;
1654: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_delivery_Freight_Cost');

Line 1654: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_delivery_Freight_Cost');

1650: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1651: x_delivery_amount := NULL;
1652: x_lpn_amount := NULL;
1653: x_detail_amount := NULL;
1654: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_delivery_Freight_Cost');
1655: IF l_debug_on THEN
1656: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1657: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1658: END IF;

Line 1663: p_in_ids IN wsh_util_core.id_tab_type,

1659:
1660: END Get_Delivery_Freight_Cost;
1661:
1662: PROCEDURE Get_Stop_Freight_Cost(
1663: p_in_ids IN wsh_util_core.id_tab_type,
1664: p_currency_code IN VARCHAR2,
1665: x_stop_amount OUT NOCOPY NUMBER ,
1666: x_return_status OUT NOCOPY VARCHAR2) IS
1667:

Line 1731: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1727: IF l_debug_on THEN
1728: WSH_DEBUG_SV.push(l_module_name);
1729: END IF;
1730: --
1731: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1732:
1733: x_stop_amount := NULL;
1734: l_index:=p_in_ids.FIRST;
1735: WHILE l_index is not null LOOP

Line 1756: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1752: p_amount => l_freight_cost,
1753: x_converted_amount => l_converted_amount,
1754: x_return_status => l_return_status) ;
1755:
1756: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1757: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1758: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1759: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1760: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 1758: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1754: x_return_status => l_return_status) ;
1755:
1756: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1757: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1758: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1759: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1760: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1761: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1762: END IF;

Line 1760: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1756: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1757: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1758: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1759: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1760: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1761: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1762: END IF;
1763: ELSE
1764: raise convert_amount_error;

Line 1761: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1757: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1758: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1759: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1760: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1761: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1762: END IF;
1763: ELSE
1764: raise convert_amount_error;
1765: END IF;

Line 1791: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1787: EXCEPTION
1788:
1789: WHEN convert_amount_error THEN
1790: CLOSE freight_cost_at_stop;
1791: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1792: x_stop_amount := NULL;
1793: IF l_debug_on THEN
1794: WSH_DEBUG_SV.logmsg(l_module_name,'Get_stop_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1795: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_stop_Freight_Cost FILURE');

Line 1799: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1795: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_stop_Freight_Cost FILURE');
1796: END IF;
1797:
1798: WHEN OTHERS THEN
1799: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1800: x_stop_amount := NULL;
1801: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_stop_Freight_Cost');
1802: IF l_debug_on THEN
1803: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1801: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_stop_Freight_Cost');

1797:
1798: WHEN OTHERS THEN
1799: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1800: x_stop_amount := NULL;
1801: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_stop_Freight_Cost');
1802: IF l_debug_on THEN
1803: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1804: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1805: END IF;

Line 1810: p_in_ids IN wsh_util_core.id_tab_type,

1806:
1807: END Get_Stop_Freight_Cost;
1808:
1809: PROCEDURE Get_Trip_Freight_Cost(
1810: p_in_ids IN wsh_util_core.id_tab_type,
1811: p_currency_code IN VARCHAR2,
1812: x_trip_amount OUT NOCOPY NUMBER,
1813: x_stop_amount OUT NOCOPY NUMBER,
1814: x_delivery_amount OUT NOCOPY NUMBER,

Line 1862: l_stop_ids wsh_util_core.id_tab_type;

1858: wfc.freight_cost_type_id <> -1 AND
1859: wfc.unit_amount > 0 AND
1860: wfct.FREIGHT_COST_TYPE_ID = wfc.FREIGHT_COST_TYPE_ID AND
1861: NOT (wfct.name='SUMMARY' and wfct.freight_cost_type_code='FTESUMMARY');
1862: l_stop_ids wsh_util_core.id_tab_type;
1863: l_del_ids wsh_util_core.id_tab_type;
1864:
1865:
1866: l_freight_cost NUMBER := 0;

Line 1863: l_del_ids wsh_util_core.id_tab_type;

1859: wfc.unit_amount > 0 AND
1860: wfct.FREIGHT_COST_TYPE_ID = wfc.FREIGHT_COST_TYPE_ID AND
1861: NOT (wfct.name='SUMMARY' and wfct.freight_cost_type_code='FTESUMMARY');
1862: l_stop_ids wsh_util_core.id_tab_type;
1863: l_del_ids wsh_util_core.id_tab_type;
1864:
1865:
1866: l_freight_cost NUMBER := 0;
1867: l_currency_code VARCHAR2(15) := NULL;

Line 1902: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1898: IF l_debug_on THEN
1899: WSH_DEBUG_SV.push(l_module_name);
1900: END IF;
1901: --
1902: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1903:
1904: x_trip_amount := NULL;
1905: x_stop_amount := NULL;
1906: x_delivery_amount := NULL;

Line 1932: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1928: p_amount => l_freight_cost,
1929: x_converted_amount => l_converted_amount,
1930: x_return_status => l_return_status) ;
1931:
1932: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1933: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1934: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1935: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1936: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 1934: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1930: x_return_status => l_return_status) ;
1931:
1932: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1933: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1934: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1935: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1936: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1937: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1938: END IF;

Line 1936: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1932: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1933: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1934: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1935: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1936: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1937: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1938: END IF;
1939: ELSE
1940: raise convert_amount_error;

Line 1937: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1933: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1934: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1935: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
1936: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1937: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1938: END IF;
1939: ELSE
1940: raise convert_amount_error;
1941: END IF;

Line 1963: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1959: p_in_ids => l_stop_ids,
1960: p_currency_code => p_currency_code,
1961: x_stop_amount => l_stop_amount ,
1962: x_return_status => l_return_status);
1963: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1964: raise details_freight_error;
1965: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1966: x_return_status:=l_return_status;
1967: END IF;

Line 1965: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1961: x_stop_amount => l_stop_amount ,
1962: x_return_status => l_return_status);
1963: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1964: raise details_freight_error;
1965: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1966: x_return_status:=l_return_status;
1967: END IF;
1968: END IF;
1969:

Line 1978: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1974: x_detail_amount => l_detail_amount ,
1975: x_lpn_amount => l_lpn_amount,
1976: x_delivery_amount=> l_delivery_amount,
1977: x_return_status => l_return_status);
1978: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1979: raise details_freight_error;
1980: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1981: x_return_status:=l_return_status;
1982: END IF;

Line 1980: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1976: x_delivery_amount=> l_delivery_amount,
1977: x_return_status => l_return_status);
1978: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1979: raise details_freight_error;
1980: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1981: x_return_status:=l_return_status;
1982: END IF;
1983: END IF;
1984:

Line 2004: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2000: END IF;
2001: --
2002: EXCEPTION
2003: WHEN details_freight_error THEN
2004: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2005: x_trip_amount := NULL;
2006: x_delivery_amount := NULL;
2007: x_stop_amount := NULL;
2008: x_lpn_amount := NULL;

Line 2016: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2012: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Trip_Freight_Cost FILURE');
2013: END IF;
2014: WHEN convert_amount_error THEN
2015: CLOSE freight_cost_at_trip;
2016: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2017: x_trip_amount := NULL;
2018: x_stop_amount := NULL;
2019: x_delivery_amount := NULL;
2020: x_lpn_amount := NULL;

Line 2028: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2024: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Trip_Freight_Cost FILURE');
2025: END IF;
2026:
2027: WHEN OTHERS THEN
2028: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2029: x_trip_amount := NULL;
2030: x_stop_amount := NULL;
2031: x_delivery_amount := NULL;
2032: x_lpn_amount := NULL;

Line 2034: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Trip_Freight_Cost');

2030: x_stop_amount := NULL;
2031: x_delivery_amount := NULL;
2032: x_lpn_amount := NULL;
2033: x_detail_amount := NULL;
2034: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Trip_Freight_Cost');
2035: IF l_debug_on THEN
2036: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2037: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2038: END IF;

Line 2070: l_in_ids wsh_util_core.id_tab_type;

2066: l_delivery_amount NUMBER;
2067: l_main_lpn_amount NUMBER;
2068: l_lpn_amount NUMBER;
2069: l_detail_amount NUMBER;
2070: l_in_ids wsh_util_core.id_tab_type;
2071:
2072: l_return_status VARCHAR2(10) := NULL;
2073: l_msg_data VARCHAR2(2000);
2074: total_freight_error EXCEPTION;

Line 2098: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2094: WSH_DEBUG_SV.push(l_module_name);
2095: WSH_DEBUG_SV.log(l_module_name,'Entity, entity_id : '||p_entity_level||p_entity_id);
2096: END IF;
2097: --
2098: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2099: l_in_ids(1):=p_entity_id;
2100:
2101: IF p_entity_level = l_c_delivery THEN
2102: Get_Delivery_Freight_Cost(

Line 2145: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

2141: IF l_debug_on THEN
2142: WSH_DEBUG_SV.log(l_module_name,'amounts trip, stop, del, main lpn, lpn, detail: '||l_trip_amount||', '||l_stop_amount||', '||l_delivery_amount||', '||l_main_lpn_amount||', '||l_lpn_amount||', '||l_detail_amount);
2143: END IF;
2144:
2145: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2146: raise total_freight_error;
2147: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2148: x_return_status:=l_return_status;
2149: END IF;

Line 2147: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2143: END IF;
2144:
2145: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2146: raise total_freight_error;
2147: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2148: x_return_status:=l_return_status;
2149: END IF;
2150:
2151: x_trip_amount := l_trip_amount;

Line 2168: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2164: --
2165: EXCEPTION
2166:
2167: WHEN total_freight_error THEN
2168: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2169: x_trip_amount := NULL;
2170: x_stop_amount := NULL;
2171: x_delivery_amount := NULL;
2172: x_lpn_amount := NULL;

Line 2180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2176: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Total_Freight_Cost FILURE');
2177: END IF;
2178:
2179: WHEN OTHERS THEN
2180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2181: x_trip_amount := NULL;
2182: x_stop_amount := NULL;
2183: x_delivery_amount := NULL;
2184: x_lpn_amount := NULL;

Line 2186: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Total_Freight_Cost');

2182: x_stop_amount := NULL;
2183: x_delivery_amount := NULL;
2184: x_lpn_amount := NULL;
2185: x_detail_amount := NULL;
2186: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Total_Freight_Cost');
2187:
2188: IF l_debug_on THEN
2189: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2190: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2273: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2269: IF l_debug_on THEN
2270: WSH_DEBUG_SV.push(l_module_name);
2271: END IF;
2272: --
2273: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2274: x_total_amount := 0;
2275: x_reprice_required := 'N';
2276:
2277: IF p_entity_level = 'Delivery' THEN

Line 2307: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2303: p_amount => l_freight_cost,
2304: x_converted_amount => l_converted_amount,
2305: x_return_status => l_return_status) ;
2306:
2307: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2308: l_total_amount := l_total_amount + NVL(l_converted_amount, 0);
2309: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2310: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
2311: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 2309: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2305: x_return_status => l_return_status) ;
2306:
2307: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2308: l_total_amount := l_total_amount + NVL(l_converted_amount, 0);
2309: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2310: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
2311: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2312: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2313: END IF;

Line 2311: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2307: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2308: l_total_amount := l_total_amount + NVL(l_converted_amount, 0);
2309: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2310: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
2311: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2312: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2313: END IF;
2314: ELSE
2315: raise convert_amount_error;

Line 2312: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2308: l_total_amount := l_total_amount + NVL(l_converted_amount, 0);
2309: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2310: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
2311: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2312: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2313: END IF;
2314: ELSE
2315: raise convert_amount_error;
2316: END IF;

Line 2334: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2330: --
2331: EXCEPTION
2332:
2333: WHEN convert_amount_error THEN
2334: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2335:
2336: IF l_debug_on THEN
2337: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Summary_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2338: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Summary_Freight_Cost FILURE');

Line 2343: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2339: END IF;
2340:
2341: WHEN OTHERS THEN
2342:
2343: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2344: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Summary_Freight_Cost');
2345:
2346: IF l_debug_on THEN
2347: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 2344: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Summary_Freight_Cost');

2340:
2341: WHEN OTHERS THEN
2342:
2343: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2344: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Summary_Freight_Cost');
2345:
2346: IF l_debug_on THEN
2347: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2348: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2388: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2384: IF l_debug_on THEN
2385: WSH_DEBUG_SV.push(l_module_name);
2386: END IF;
2387: --
2388: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2389:
2390: IF p_amount = 0 THEN
2391: x_converted_amount := 0;
2392: ELSIF p_from_currency = p_to_currency THEN

Line 2563: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2559:
2560: EXCEPTION
2561:
2562: WHEN WSH_NO_RATE THEN
2563: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2564: x_converted_amount := NULL;
2565: IF l_debug_on THEN
2566: WSH_DEBUG_SV.logmsg(l_module_name,'Convert_Amount exception has occured. No convertion rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2567: WSH_DEBUG_SV.pop(l_module_name);

Line 2572: WSH_UTIL_CORE.Add_Message(x_return_status);

2568: END IF;
2569: FND_MESSAGE.Set_Name('WSH', 'WSH_FC_NO_RATE');
2570: FND_MESSAGE.Set_Token('FROM_CURRENCY', p_from_currency);
2571: FND_MESSAGE.Set_Token('TO_CURRENCY', p_to_currency);
2572: WSH_UTIL_CORE.Add_Message(x_return_status);
2573:
2574: WHEN WSH_INVALID_CURRENCY THEN
2575: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2576: x_converted_amount := NULL;

Line 2575: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2571: FND_MESSAGE.Set_Token('TO_CURRENCY', p_to_currency);
2572: WSH_UTIL_CORE.Add_Message(x_return_status);
2573:
2574: WHEN WSH_INVALID_CURRENCY THEN
2575: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2576: x_converted_amount := NULL;
2577: IF l_debug_on THEN
2578: WSH_DEBUG_SV.logmsg(l_module_name,'Convert_Amount exception has occured. Invalid currency.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2579: WSH_DEBUG_SV.pop(l_module_name);

Line 2582: WSH_UTIL_CORE.Add_Message(x_return_status);

2578: WSH_DEBUG_SV.logmsg(l_module_name,'Convert_Amount exception has occured. Invalid currency.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2579: WSH_DEBUG_SV.pop(l_module_name);
2580: END IF;
2581: FND_MESSAGE.Set_Name('WSH', 'WSH_FC_INVALID_CURRENCY');
2582: WSH_UTIL_CORE.Add_Message(x_return_status);
2583:
2584: WHEN WSH_CONVERT_ERROR THEN
2585: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2586: x_converted_amount := NULL;

Line 2585: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2581: FND_MESSAGE.Set_Name('WSH', 'WSH_FC_INVALID_CURRENCY');
2582: WSH_UTIL_CORE.Add_Message(x_return_status);
2583:
2584: WHEN WSH_CONVERT_ERROR THEN
2585: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2586: x_converted_amount := NULL;
2587: IF l_debug_on THEN
2588: WSH_DEBUG_SV.logmsg(l_module_name,'Convert_Amount exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2589: WSH_DEBUG_SV.pop(l_module_name);

Line 2594: WSH_UTIL_CORE.Add_Message(x_return_status);

2590: END IF;
2591: FND_MESSAGE.Set_Name('WSH', 'WSH_FC_NO_RATE');
2592: FND_MESSAGE.Set_Token('FROM_CURRENCY', p_from_currency);
2593: FND_MESSAGE.Set_Token('TO_CURRENCY', p_to_currency);
2594: WSH_UTIL_CORE.Add_Message(x_return_status);
2595:
2596: WHEN others THEN
2597: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2598: x_converted_amount := NULL;

Line 2597: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2593: FND_MESSAGE.Set_Token('TO_CURRENCY', p_to_currency);
2594: WSH_UTIL_CORE.Add_Message(x_return_status);
2595:
2596: WHEN others THEN
2597: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2598: x_converted_amount := NULL;
2599: IF l_debug_on THEN
2600: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2601: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2603: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Convert_Amount');

2599: IF l_debug_on THEN
2600: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2601: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2602: END IF;
2603: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Convert_Amount');
2604:
2605: END Convert_Amount;
2606:
2607:

Line 2613: p_delivery_details_tab IN WSH_UTIL_CORE.Id_Tab_Type,

2609: -- --------------------------------
2610: -- PROCEDURE Remove_FTE_Freight_Costs
2611: -- --------------------------------
2612: PROCEDURE Remove_FTE_Freight_Costs(
2613: p_delivery_details_tab IN WSH_UTIL_CORE.Id_Tab_Type,
2614: x_return_status OUT NOCOPY VARCHAR2 ) IS
2615:
2616: CURSOR lock_freight_costs(c_delivery_detail_id NUMBER) IS
2617: SELECT freight_cost_id

Line 2639: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2635: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'REMOVE_FC_FREIGHT_COSTS';
2636: --
2637: BEGIN
2638: SAVEPOINT befor_delete;
2639: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2640: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2641: --
2642: IF l_debug_on IS NULL
2643: THEN

Line 2675: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2671: CLOSE lock_freight_costs;
2672: END IF;
2673: CLOSE get_freight_costs;
2674: END LOOP;
2675: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2676: IF l_debug_on THEN
2677: WSH_DEBUG_SV.pop(l_module_name);
2678: END IF;
2679: EXCEPTION

Line 2683: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2679: EXCEPTION
2680:
2681: WHEN OTHERS THEN
2682:
2683: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2684: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.Remove_FTE_Freight_Costs',l_module_name);
2685: ROLLBACK TO before_delete;
2686: --
2687: IF l_debug_on THEN

Line 2684: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.Remove_FTE_Freight_Costs',l_module_name);

2680:
2681: WHEN OTHERS THEN
2682:
2683: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2684: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.Remove_FTE_Freight_Costs',l_module_name);
2685: ROLLBACK TO before_delete;
2686: --
2687: IF l_debug_on THEN
2688: WSH_DEBUG_SV.logmsg(l_module_name,'Cannot lock the fright cost records '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2751: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2747: IF l_debug_on THEN
2748: WSH_DEBUG_SV.push(l_module_name);
2749: END IF;
2750: --
2751: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2752:
2753: x_trip_amount := NULL;
2754:
2755: OPEN freight_cost_at_trip(p_trip_id);

Line 2776: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2772: p_amount => l_freight_cost,
2773: x_converted_amount => l_converted_amount,
2774: x_return_status => l_return_status) ;
2775:
2776: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2777: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
2778: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2779: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
2780: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 2778: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2774: x_return_status => l_return_status) ;
2775:
2776: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2777: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
2778: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2779: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
2780: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2781: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2782: END IF;

Line 2780: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2776: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2777: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
2778: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2779: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
2780: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2781: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2782: END IF;
2783: ELSE
2784: raise convert_amount_error;

Line 2781: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2777: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
2778: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2779: l_total_amount := l_total_amount + NVL(l_converted_amount,0);
2780: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2781: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2782: END IF;
2783: ELSE
2784: raise convert_amount_error;
2785: END IF;

Line 2805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2801: --
2802: EXCEPTION
2803: WHEN convert_amount_error THEN
2804: CLOSE freight_cost_at_trip;
2805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2806: x_trip_amount := NULL;
2807: IF l_debug_on THEN
2808: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Trip_Manual_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2809: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Trip_Freight_Cost FAILURE');

Line 2813: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2809: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Trip_Freight_Cost FAILURE');
2810: END IF;
2811:
2812: WHEN OTHERS THEN
2813: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2814: x_trip_amount := NULL;
2815: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Trip_Freight_Cost');
2816: IF l_debug_on THEN
2817: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2815: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Trip_Freight_Cost');

2811:
2812: WHEN OTHERS THEN
2813: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2814: x_trip_amount := NULL;
2815: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Trip_Freight_Cost');
2816: IF l_debug_on THEN
2817: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2818: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2819: END IF;