9597:
9598: END IF;
9599:
9600: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
9601: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'shipment_price_consolidate_standard','start');
9602:
9603:
9604: l_trip_id:=NULL;
9605: l_mode:=NULL;
9681: raise FTE_FREIGHT_PRICING_UTIL.g_price_consolidate_failed;
9682: END IF;
9683: END IF;
9684:
9685: -- Standard call to get message count and if count is 1,
9686: -- get message info.
9687: FND_MSG_PUB.Count_And_Get (
9688: p_count => x_msg_count,
9689: p_data => x_msg_data );
9687: FND_MSG_PUB.Count_And_Get (
9688: p_count => x_msg_count,
9689: p_data => x_msg_data );
9690:
9691: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate_standard');
9692: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9693: FTE_FREIGHT_PRICING_UTIL.close_logs;
9694: END IF;
9695:
9696: EXCEPTION
9697:
9698: WHEN FTE_FREIGHT_PRICING_UTIL.g_get_trip_mode_fail THEN
9699: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9700: FTE_FREIGHT_PRICING_UTIL.set_exit_exception('shipment_price_consolidate_standard','g_get_trip_mode_fail');
9701: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate_standard');
9702: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9703: FTE_FREIGHT_PRICING_UTIL.close_logs;
9704: END IF;
9697:
9698: WHEN FTE_FREIGHT_PRICING_UTIL.g_get_trip_mode_fail THEN
9699: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9700: FTE_FREIGHT_PRICING_UTIL.set_exit_exception('shipment_price_consolidate_standard','g_get_trip_mode_fail');
9701: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate_standard');
9702: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9703: FTE_FREIGHT_PRICING_UTIL.close_logs;
9704: END IF;
9705:
9705:
9706:
9707: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_trip_fail THEN
9708: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9709: FTE_FREIGHT_PRICING_UTIL.set_exit_exception('shipment_price_consolidate_standard','g_tl_rate_trip_fail');
9710: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate_standard');
9711: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9712: FTE_FREIGHT_PRICING_UTIL.close_logs;
9713: END IF;
9706:
9707: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_trip_fail THEN
9708: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9709: FTE_FREIGHT_PRICING_UTIL.set_exit_exception('shipment_price_consolidate_standard','g_tl_rate_trip_fail');
9710: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate_standard');
9711: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9712: FTE_FREIGHT_PRICING_UTIL.close_logs;
9713: END IF;
9714:
9714:
9715:
9716: WHEN FTE_FREIGHT_PRICING_UTIL.g_price_consolidate_failed THEN
9717: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9718: FTE_FREIGHT_PRICING_UTIL.set_exit_exception('shipment_price_consolidate_standard','g_price_consolidate_failed');
9719: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate_standard');
9720: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9721: FTE_FREIGHT_PRICING_UTIL.close_logs;
9722: END IF;
9715:
9716: WHEN FTE_FREIGHT_PRICING_UTIL.g_price_consolidate_failed THEN
9717: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9718: FTE_FREIGHT_PRICING_UTIL.set_exit_exception('shipment_price_consolidate_standard','g_price_consolidate_failed');
9719: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate_standard');
9720: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9721: FTE_FREIGHT_PRICING_UTIL.close_logs;
9722: END IF;
9723: WHEN others THEN
9721: FTE_FREIGHT_PRICING_UTIL.close_logs;
9722: END IF;
9723: WHEN others THEN
9724: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
9725: FTE_FREIGHT_PRICING_UTIL.set_exit_exception('shipment_price_consolidate_standard','g_others');
9726: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
9727: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate_standard');
9728: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9729: FTE_FREIGHT_PRICING_UTIL.close_logs;
9723: WHEN others THEN
9724: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
9725: FTE_FREIGHT_PRICING_UTIL.set_exit_exception('shipment_price_consolidate_standard','g_others');
9726: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
9727: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate_standard');
9728: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9729: FTE_FREIGHT_PRICING_UTIL.close_logs;
9730: END IF;
9731: END shipment_price_consolidate;
10552:
10553: BEGIN
10554: SAVEPOINT rerate_shipment_online;
10555: --
10556: -- Standard call to check for call compatibility.
10557: IF NOT FND_API.Compatible_API_Call
10558: (
10559: l_api_version,
10560: p_api_version,
13018: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'l_cum_wt='||l_cum_wt);
13019: x_total_comm_wt := l_cum_wt;
13020: x_wt_uom := l_target_wt_uom;
13021:
13022: -- Standard call to get message count and if count is 1,
13023: -- get message info.
13024: FND_MSG_PUB.Count_And_Get (
13025: p_count => x_msg_count,
13026: p_data => x_msg_data );