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.5.12000000.4 2007/06/29 21:45:07 dramamoo 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.5.12000000.4 2007/06/29 21:45:07 dramamoo 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 2363: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_disabled_list', l_module_name);

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

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

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

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

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

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

5219: --
5220: WHEN OTHERS THEN
5221:
5222: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5223: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_stop_close_date', l_module_name);
5224: IF l_debug_on THEN
5225: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5226: END IF;
5227: --

Line 5797: END WSH_TRIP_STOPS_VALIDATIONS;

5793: --
5794: END user_non_updatable_columns;
5795:
5796:
5797: END WSH_TRIP_STOPS_VALIDATIONS;