DBA Data[Home] [Help]

APPS.FTE_ACS_TRIP_PKG dependencies on WSH_UTIL_CORE

Line 115: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

111: FROM wsh_new_deliveries
112: WHERE delivery_id = p_delivery_id;*/
113: BEGIN
114: --{
115: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
116:
117: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
118: --
119: IF l_debug_on IS NULL

Line 297: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

293: p_trip_info_tab => l_trip_info_tab,
294: p_in_rec => l_trip_in_rec,
295: x_out_tab => l_trip_out_rec_tab);
296:
297: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
298: raise FND_API.G_EXC_UNEXPECTED_ERROR;
299: END IF;
300:
301: l_trip_id := l_trip_out_rec_tab(1).trip_id;

Line 349: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

345: x_msg_count => l_msg_count,
346: x_msg_data => l_msg_data,
347: x_stop_wt_vol_out_tab => l_stop_wt_vol_out_tab);
348:
349: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
350: raise FND_API.G_EXC_UNEXPECTED_ERROR;
351: END IF;
352:
353: IF l_debug_on THEN

Line 380: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

376: x_msg_count => l_msg_count,
377: x_msg_data => l_msg_data,
378: x_stop_wt_vol_out_tab => l_stop_wt_vol_out_tab);
379:
380: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
381: raise FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383:
384: IF l_debug_on THEN

Line 454: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

450: x_return_status => l_return_status,
451: x_msg_count => l_msg_count,
452: x_msg_data => l_msg_data);
453:
454: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
455: raise FND_API.G_EXC_UNEXPECTED_ERROR;
456: END IF;
457:
458: x_trip_id := l_trip_id;

Line 468: wsh_util_core.default_handler('FTE_ACS_TRIP_PKG.CARRIER_SEL_CREATE_TRIP',l_module_name);

464: --}
465: EXCEPTION
466:
467: WHEN OTHERS THEN
468: wsh_util_core.default_handler('FTE_ACS_TRIP_PKG.CARRIER_SEL_CREATE_TRIP',l_module_name);
469:
470: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
471:
472: IF c_dlvy_attr_csr%ISOPEN THEN

Line 470: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

466:
467: WHEN OTHERS THEN
468: wsh_util_core.default_handler('FTE_ACS_TRIP_PKG.CARRIER_SEL_CREATE_TRIP',l_module_name);
469:
470: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
471:
472: IF c_dlvy_attr_csr%ISOPEN THEN
473: CLOSE c_dlvy_attr_csr;
474: END IF;

Line 528: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

524: --
525: WSH_DEBUG_SV.log(l_module_name,'P_RULE_ID',P_RULE_ID);
526: END IF;
527:
528: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
529:
530: FTE_ACS_CACHE_PKG.GET_RESULTS_FOR_RULE( p_rule_id => p_rule_id,
531: x_result_tab => l_result_tab,
532: x_return_status => x_return_status);

Line 535: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

531: x_result_tab => l_result_tab,
532: x_return_status => x_return_status);
533:
534:
535: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
536: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
537: raise FND_API.G_EXC_UNEXPECTED_ERROR;
538: END IF;
539: END IF;

Line 536: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

532: x_return_status => x_return_status);
533:
534:
535: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
536: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
537: raise FND_API.G_EXC_UNEXPECTED_ERROR;
538: END IF;
539: END IF;
540:

Line 571: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

567: EXCEPTION
568:
569: WHEN CS_MULTILEG_RESULT THEN
570:
571: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
572:
573: OPEN get_rule_name;
574: FETCH get_rule_name INTO l_rule_name;
575: CLOSE get_rule_name;

Line 581: wsh_util_core.add_message(x_return_status);

577: --Routing Gide Rule RULE_NAME has changed, and the given Rule Detail cant be found.
578:
579: FND_MESSAGE.SET_NAME('FTE','FTE_CS_INVALID_RULE');
580: FND_MESSAGE.SET_TOKEN('RULE_NAME',l_rule_name);
581: wsh_util_core.add_message(x_return_status);
582:
583: IF l_debug_on THEN
584: WSH_DEBUG_SV.pop(l_module_name);
585: END IF;

Line 589: WSH_UTIL_CORE.default_handler('FTE_ACS_TRIP_PKG.GET_RANKED_RESULTS');

585: END IF;
586:
587: WHEN others THEN
588:
589: WSH_UTIL_CORE.default_handler('FTE_ACS_TRIP_PKG.GET_RANKED_RESULTS');
590: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
591:
592: IF l_debug_on THEN
593: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 590: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

586:
587: WHEN others THEN
588:
589: WSH_UTIL_CORE.default_handler('FTE_ACS_TRIP_PKG.GET_RANKED_RESULTS');
590: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
591:
592: IF l_debug_on THEN
593: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
594: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');