APPS.FTE_LANE_SEARCH dependencies on WSH_UTIL_CORE

Line 456: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

452: WSH_DEBUG_SV.log(l_module_name,'P_MODE_CODE',P_MODE_CODE);
453: END IF;
454: --
455:
456: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
457: --Logic for calculating Transit time is in WSH_MAP_LOCATION_REGION_PKG Bug 4653381
458: WSH_MAP_LOCATION_REGION_PKG.Get_Transit_Time(
459: p_ship_from_loc_id => p_ship_from_loc_id ,
460: p_ship_to_site_id=>p_ship_to_site_id,

Line 526: x_return_message := WSH_UTIL_CORE.g_ret_sts_success;

522: BEGIN
523: --
524: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
525: --
526: x_return_message := WSH_UTIL_CORE.g_ret_sts_success;
527: IF l_debug_on IS NULL
528: THEN
529: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
530: END IF;

Line 556: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

552: x_lane_results => l_lane_results,
553: x_schedule_results => l_schedule_results,
554: x_return_message => x_return_message,
555: x_return_status => x_return_status);
556: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
557: x_return_message := FND_MESSAGE.GET;
558: return;
559: END IF;
560: IF p_search_type = 'L' THEN

Line 603: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

599: --
600: EXCEPTION
601: WHEN OTHERS THEN
602: x_return_message := g_message || 'Unexpected Error in Search_Lanes Package: ' || sqlerrm;
603: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
604: IF l_debug_on THEN
605: WSH_DEBUG_SV.pop(l_module_name);
606: END IF;
607:

Line 765: l_success_trips WSH_UTIL_CORE.id_tab_type;

761: l_shipping_control VARCHAR2(30);
762: l_dleg_info_rec WSH_FTE_CONSTRAINT_FRAMEWORK.dleg_ccinfo_rec_type;
763: l_lane_info_rec WSH_FTE_CONSTRAINT_FRAMEWORK.lane_ccinfo_rec_type;
764: l_lane_info_tab WSH_FTE_CONSTRAINT_FRAMEWORK.lane_ccinfo_tab_type;
765: l_success_trips WSH_UTIL_CORE.id_tab_type;
766: l_success_lanes WSH_UTIL_CORE.id_tab_type;
767: l_validate_result VARCHAR2(1);
768: l_msg_count NUMBER;
769: l_msg_data VARCHAR2(400);

Line 766: l_success_lanes WSH_UTIL_CORE.id_tab_type;

762: l_dleg_info_rec WSH_FTE_CONSTRAINT_FRAMEWORK.dleg_ccinfo_rec_type;
763: l_lane_info_rec WSH_FTE_CONSTRAINT_FRAMEWORK.lane_ccinfo_rec_type;
764: l_lane_info_tab WSH_FTE_CONSTRAINT_FRAMEWORK.lane_ccinfo_tab_type;
765: l_success_trips WSH_UTIL_CORE.id_tab_type;
766: l_success_lanes WSH_UTIL_CORE.id_tab_type;
767: l_validate_result VARCHAR2(1);
768: l_msg_count NUMBER;
769: l_msg_data VARCHAR2(400);
770: l_good_lane VARCHAR2(1);

Line 771: l_dummy_exception WSH_UTIL_CORE.Column_Tab_Type;

767: l_validate_result VARCHAR2(1);
768: l_msg_count NUMBER;
769: l_msg_data VARCHAR2(400);
770: l_good_lane VARCHAR2(1);
771: l_dummy_exception WSH_UTIL_CORE.Column_Tab_Type;
772: l_dummy_trips WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
773:
774: l_cc_lane_counter NUMBER;
775:

Line 1187: IF (l_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1183: x_return_status => l_status);
1184: End IF;
1185: END IF;
1186:
1187: IF (l_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1188: x_return_status := l_status;
1189: FND_MESSAGE.SET_NAME('FTE', 'FTE_CANNOT_GET_TRANSIT_TIME');
1190: FND_MESSAGE.SET_TOKEN('LANE_NUMBER', v_lane_number(n + l_offset));
1191: x_return_message := FND_MESSAGE.GET;

Line 1539: IF (l_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1535: End IF;
1536: END IF;
1537:
1538:
1539: IF (l_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1540: x_return_status := l_status;
1541: FND_MESSAGE.SET_NAME('FTE', 'FTE_CANNOT_GET_TRANSIT_TIME');
1542: FND_MESSAGE.SET_TOKEN('LANE_NUMBER', v_lane_number(n + l_offset));
1543: x_return_message := FND_MESSAGE.GET;

Line 2008: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2004: --
2005: EXCEPTION
2006: WHEN OTHERS THEN
2007: x_return_message := g_message || 'Unexpected Error in Search_Lanes Package: ' || sqlerrm;
2008: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2009: END Search_Lanes;
2010:
2011:
2012: -- ----------------------------------------------------------------