10696: END LOOP;
10697: END IF;
10698: END LOOP;
10699: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,' No rates failed list::= '||l_no_rates_delv_ids);
10700: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_NORATES');
10701: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_fail_delivery_name_list);
10702: --FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10703: FND_MSG_PUB.ADD;
10704: raise l_delivery_validation_failed;
10697: END IF;
10698: END LOOP;
10699: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,' No rates failed list::= '||l_no_rates_delv_ids);
10700: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_NORATES');
10701: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_fail_delivery_name_list);
10702: --FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10703: FND_MSG_PUB.ADD;
10704: raise l_delivery_validation_failed;
10705: END IF;
10698: END LOOP;
10699: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,' No rates failed list::= '||l_no_rates_delv_ids);
10700: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_NORATES');
10701: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_fail_delivery_name_list);
10702: --FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10703: FND_MSG_PUB.ADD;
10704: raise l_delivery_validation_failed;
10705: END IF;
10706:
10895: IF l_warning_list.COUNT > 0 THEN
10896: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10897: IF l_delv_with_multlegs_names IS NOT NULL THEN
10898: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,' Delv with MulipleLegs::= '||l_delv_with_multlegs_names);
10899: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_MULTILEG_WARN');
10900: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_delv_with_multlegs_names);
10901: FND_MSG_PUB.ADD;
10902: END IF;
10903: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_SHIPMENT_WARNIN');
10896: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10897: IF l_delv_with_multlegs_names IS NOT NULL THEN
10898: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,' Delv with MulipleLegs::= '||l_delv_with_multlegs_names);
10899: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_MULTILEG_WARN');
10900: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_delv_with_multlegs_names);
10901: FND_MSG_PUB.ADD;
10902: END IF;
10903: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_SHIPMENT_WARNIN');
10904: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_warn_delivery_name_list);
10899: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_MULTILEG_WARN');
10900: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_delv_with_multlegs_names);
10901: FND_MSG_PUB.ADD;
10902: END IF;
10903: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_SHIPMENT_WARNIN');
10904: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_warn_delivery_name_list);
10905: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10906: FND_MSG_PUB.ADD;
10907: END IF;
10900: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_delv_with_multlegs_names);
10901: FND_MSG_PUB.ADD;
10902: END IF;
10903: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_SHIPMENT_WARNIN');
10904: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_warn_delivery_name_list);
10905: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10906: FND_MSG_PUB.ADD;
10907: END IF;
10908:
10901: FND_MSG_PUB.ADD;
10902: END IF;
10903: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_SHIPMENT_WARNIN');
10904: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_warn_delivery_name_list);
10905: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10906: FND_MSG_PUB.ADD;
10907: END IF;
10908:
10909:
10909:
10910: IF l_failed_list.COUNT >0 THEN
10911: IF l_delv_srv_failed_names IS NOT NULL THEN
10912: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Service failed list::= '||l_delv_srv_failed_names);
10913: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_SERVICE_FAILED');
10914: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_delv_srv_failed_names);
10915: --FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10916: FND_MSG_PUB.ADD;
10917: END IF;
10910: IF l_failed_list.COUNT >0 THEN
10911: IF l_delv_srv_failed_names IS NOT NULL THEN
10912: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Service failed list::= '||l_delv_srv_failed_names);
10913: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_SERVICE_FAILED');
10914: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_delv_srv_failed_names);
10915: --FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10916: FND_MSG_PUB.ADD;
10917: END IF;
10918: IF l_closed_trips_delv_ids IS NOT NULL THEN
10911: IF l_delv_srv_failed_names IS NOT NULL THEN
10912: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Service failed list::= '||l_delv_srv_failed_names);
10913: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_SERVICE_FAILED');
10914: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_delv_srv_failed_names);
10915: --FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10916: FND_MSG_PUB.ADD;
10917: END IF;
10918: IF l_closed_trips_delv_ids IS NOT NULL THEN
10919: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Deliveries with Closed Trips list::= '||l_close_trdelv_name_list);
10916: FND_MSG_PUB.ADD;
10917: END IF;
10918: IF l_closed_trips_delv_ids IS NOT NULL THEN
10919: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Deliveries with Closed Trips list::= '||l_close_trdelv_name_list);
10920: FND_MESSAGE.SET_NAME('FTE','FTE_MLS_CANNOT_UPD_RATE');
10921: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_close_trdelv_name_list);
10922: FND_MESSAGE.SET_TOKEN('DELIVERY_STATUS',l_status);
10923: --FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10924: FND_MSG_PUB.ADD;
10917: END IF;
10918: IF l_closed_trips_delv_ids IS NOT NULL THEN
10919: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Deliveries with Closed Trips list::= '||l_close_trdelv_name_list);
10920: FND_MESSAGE.SET_NAME('FTE','FTE_MLS_CANNOT_UPD_RATE');
10921: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_close_trdelv_name_list);
10922: FND_MESSAGE.SET_TOKEN('DELIVERY_STATUS',l_status);
10923: --FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10924: FND_MSG_PUB.ADD;
10925: END IF;
10918: IF l_closed_trips_delv_ids IS NOT NULL THEN
10919: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Deliveries with Closed Trips list::= '||l_close_trdelv_name_list);
10920: FND_MESSAGE.SET_NAME('FTE','FTE_MLS_CANNOT_UPD_RATE');
10921: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_close_trdelv_name_list);
10922: FND_MESSAGE.SET_TOKEN('DELIVERY_STATUS',l_status);
10923: --FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10924: FND_MSG_PUB.ADD;
10925: END IF;
10926: IF l_fail_delivery_name_list IS NOT NULL THEN
10919: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Deliveries with Closed Trips list::= '||l_close_trdelv_name_list);
10920: FND_MESSAGE.SET_NAME('FTE','FTE_MLS_CANNOT_UPD_RATE');
10921: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_close_trdelv_name_list);
10922: FND_MESSAGE.SET_TOKEN('DELIVERY_STATUS',l_status);
10923: --FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10924: FND_MSG_PUB.ADD;
10925: END IF;
10926: IF l_fail_delivery_name_list IS NOT NULL THEN
10927: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,' failed list::= '||l_fail_delivery_name_list);
10924: FND_MSG_PUB.ADD;
10925: END IF;
10926: IF l_fail_delivery_name_list IS NOT NULL THEN
10927: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,' failed list::= '||l_fail_delivery_name_list);
10928: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_SHIPMENT_FAIL');
10929: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_fail_delivery_name_list);
10930: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10931: FND_MSG_PUB.ADD;
10932: END IF;
10925: END IF;
10926: IF l_fail_delivery_name_list IS NOT NULL THEN
10927: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,' failed list::= '||l_fail_delivery_name_list);
10928: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_SHIPMENT_FAIL');
10929: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_fail_delivery_name_list);
10930: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10931: FND_MSG_PUB.ADD;
10932: END IF;
10933: IF l_success_list.COUNT > 0 OR l_warning_list.COUNT > 0 THEN
10926: IF l_fail_delivery_name_list IS NOT NULL THEN
10927: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,' failed list::= '||l_fail_delivery_name_list);
10928: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_SHIPMENT_FAIL');
10929: FND_MESSAGE.SET_TOKEN('DEL_NAMES',l_fail_delivery_name_list);
10930: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
10931: FND_MSG_PUB.ADD;
10932: END IF;
10933: IF l_success_list.COUNT > 0 OR l_warning_list.COUNT > 0 THEN
10934: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;