APPS.WSH_TRIP_STOPS_VALIDATIONS dependencies on WSH_TRIP_STOPS_VALIDATIONS

Line 1: PACKAGE BODY WSH_TRIP_STOPS_VALIDATIONS as

1: PACKAGE BODY WSH_TRIP_STOPS_VALIDATIONS as
2: /* $Header: WSHSTVLB.pls 120.8.12010000.2 2009/12/03 13:06:24 mvudugul ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIP_STOPS_VALIDATIONS';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIP_STOPS_VALIDATIONS';

1: PACKAGE BODY WSH_TRIP_STOPS_VALIDATIONS as
2: /* $Header: WSHSTVLB.pls 120.8.12010000.2 2009/12/03 13:06:24 mvudugul ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIP_STOPS_VALIDATIONS';
6:
7: --3509004 :public api changes
8: PROCEDURE user_non_updatable_columns
9: (p_user_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

Line 523: l_rec_stop WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;

519: WHERE trip_id = p_trip_id
520: AND status_code = 'OP' -- this is a case only for Open stops
521: AND stop_id <> p_stop_id ;
522:
523: l_rec_stop WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;
524:
525: -- Question , Can there be multiple record with same stop id as pickup
526: CURSOR c_wdl_details1 IS
527: SELECT pick_up_stop_id,

Line 541: l_rec_wdl1 WSH_TRIP_STOPS_VALIDATIONS.dleg_details_tab;

537: delivery_id
538: FROM wsh_delivery_legs
539: WHERE drop_off_stop_id = p_stop_id;
540:
541: l_rec_wdl1 WSH_TRIP_STOPS_VALIDATIONS.dleg_details_tab;
542: --l_rec_wdl2 c_wdl_details%TYPE;
543:
544: stop_count NUMBER := 0;
545: dleg_count NUMBER := 0;

Line 2367: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_disabled_list', l_module_name);

2363: IF c_tbl_rec%ISOPEN THEN
2364: CLOSE c_tbl_rec;
2365: END IF;
2366: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2367: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_disabled_list', l_module_name);
2368: IF l_debug_on THEN
2369: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
2370: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2371: END IF;

Line 2475: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_disabled_list', l_module_name);

2471: END IF;
2472: EXCEPTION
2473: WHEN OTHERS THEN
2474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2475: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_disabled_list', l_module_name);
2476: IF l_debug_on THEN
2477: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
2478: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2479: END IF;

Line 2745: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag', l_module_name);

2741: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2742: END IF;
2743: WHEN OTHERS THEN
2744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2745: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag', l_module_name);
2746: IF l_debug_on THEN
2747: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2748: END IF;
2749: --}

Line 5227: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_stop_close_date', l_module_name);

5223: --
5224: WHEN OTHERS THEN
5225:
5226: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5227: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_stop_close_date', l_module_name);
5228: IF l_debug_on THEN
5229: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5230: END IF;
5231: --

Line 5801: END WSH_TRIP_STOPS_VALIDATIONS;

5797: --
5798: END user_non_updatable_columns;
5799:
5800:
5801: END WSH_TRIP_STOPS_VALIDATIONS;