eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TRIP_STOPS_VALIDATIONS dependencies on WSH_TRIP_STOPS

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 9: (p_user_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

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,
10: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
11: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
12: x_return_status OUT NOCOPY VARCHAR2);
13:

Line 10: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

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,
10: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
11: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
12: x_return_status OUT NOCOPY VARCHAR2);
13:
14:

Line 11: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,

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,
10: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
11: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
12: x_return_status OUT NOCOPY VARCHAR2);
13:
14:
15: /*

Line 232: FROM wsh_trip_stops

228:
229: -- nvl is if no records exist
230: CURSOR c_check_max IS
231: SELECT nvl(max(stop_sequence_number),0) stop_sequence_number
232: FROM wsh_trip_stops
233: WHERE trip_id = p_trip_id
234: AND status_code IN ('AR','CL');
235:
236: l_max_sequence NUMBER;

Line 305: FROM wsh_trip_stops

301: x_return_status OUT NOCOPY VARCHAR2) IS
302:
303: CURSOR c_check_unique IS
304: SELECT stop_id
305: FROM wsh_trip_stops
306: WHERE trip_id = p_trip_id
307: AND stop_sequence_number = p_stop_sequence_number
308: AND rownum = 1 ;
309:

Line 518: FROM wsh_trip_stops

514:
515: CURSOR c_stop_details IS
516: SELECT stop_sequence_number,
517: stop_id
518: FROM wsh_trip_stops
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:

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 764: FROM wsh_trip_stops

760: ) IS
761:
762: CURSOR c_get_max_sequence IS
763: SELECT nvl(max(stop_sequence_number),0) stop_sequence_number
764: FROM wsh_trip_stops
765: WHERE trip_id = p_trip_id;
766:
767: l_stop_sequence_number NUMBER;
768:

Line 909: NVL(wnd.tms_interface_flag,WSH_TRIP_STOPS_PVT.C_TMS_NOT_TO_BE_SENT) tms_interface_flag, -- OTM R12, glog proj

905: /*J inbound logistics new column jckwok*/
906: NVL(wnd.shipment_direction, 'O') shipment_direction,
907: wnd.delivery_type, --MDC
908: NVL(wnd.ignore_for_planning, 'N') ignore_for_planning, --OTM R12, glog proj
909: NVL(wnd.tms_interface_flag,WSH_TRIP_STOPS_PVT.C_TMS_NOT_TO_BE_SENT) tms_interface_flag, -- OTM R12, glog proj
910: NVL(mcp.otm_enabled,wsp.otm_enabled) otm_enabled, -- LSP PROJECT : checking OTM enabled flag on client parameters.
911: wnd.client_id -- LSP PROJECT
912: from wsh_new_deliveries wnd,
913: wsh_delivery_legs wdl,

Line 1287: p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1283:
1284:
1285:
1286: PROCEDURE eliminate_displayonly_fields (
1287: p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1288: , p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType
1289: , x_stop_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1290: )
1291: IS

Line 1288: , p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType

1284:
1285:
1286: PROCEDURE eliminate_displayonly_fields (
1287: p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1288: , p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType
1289: , x_stop_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1290: )
1291: IS
1292: BEGIN

Line 1289: , x_stop_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1285:
1286: PROCEDURE eliminate_displayonly_fields (
1287: p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1288: , p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType
1289: , x_stop_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1290: )
1291: IS
1292: BEGIN
1293:

Line 1324: -- it will be re-sequenced in WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP right after

1320: (WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD))
1321: THEN
1322: -- csun stop sequence enhancement for 11.5.10, the stop sequence number for a
1323: -- trip stop is set to -99 initially since it is a required filed in the table,
1324: -- it will be re-sequenced in WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP right after
1325: -- it is created.
1326: x_stop_rec.STOP_SEQUENCE_NUMBER := -99;
1327: -- but for mode = SSN, stop_sequence_number field would always have to be specified
1328: -- when creating a stop

Line 1591: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1587: -----------------------------------------------------------*/
1588:
1589: PROCEDURE disable_from_list(
1590: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
1591: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1592: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1593: , x_return_status OUT NOCOPY VARCHAR2
1594: , x_field_name OUT NOCOPY VARCHAR2
1595:

Line 1592: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1588:
1589: PROCEDURE disable_from_list(
1590: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
1591: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1592: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1593: , x_return_status OUT NOCOPY VARCHAR2
1594: , x_field_name OUT NOCOPY VARCHAR2
1595:
1596: ) IS

Line 1777: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1773: -----------------------------------------------------------*/
1774:
1775: PROCEDURE enable_from_list(
1776: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
1777: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1778: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1779: , x_return_status OUT NOCOPY VARCHAR2
1780: , x_field_name OUT NOCOPY VARCHAR2
1781:

Line 1778: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1774:
1775: PROCEDURE enable_from_list(
1776: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
1777: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1778: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1779: , x_return_status OUT NOCOPY VARCHAR2
1780: , x_field_name OUT NOCOPY VARCHAR2
1781:
1782: ) IS

Line 1984: p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1980: --
1981: -- Bug 2678363 - Added p_in_rec as a parameter instead of p_action
1982: --
1983: PROCEDURE Get_Disabled_List (
1984: p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1985: , p_parent_entity_id IN NUMBER
1986: , p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType
1987: , x_return_status OUT NOCOPY VARCHAR2
1988: , x_msg_count OUT NOCOPY NUMBER

Line 1986: , p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType

1982: --
1983: PROCEDURE Get_Disabled_List (
1984: p_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1985: , p_parent_entity_id IN NUMBER
1986: , p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType
1987: , x_return_status OUT NOCOPY VARCHAR2
1988: , x_msg_count OUT NOCOPY NUMBER
1989: , x_msg_data OUT NOCOPY VARCHAR2
1990: , x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type

Line 1990: , x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type

1986: , p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType
1987: , x_return_status OUT NOCOPY VARCHAR2
1988: , x_msg_count OUT NOCOPY NUMBER
1989: , x_msg_data OUT NOCOPY VARCHAR2
1990: , x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1991: )
1992: IS
1993: l_disabled_list WSH_UTIL_CORE.column_tab_type;
1994: l_db_col_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

Line 1994: l_db_col_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

1990: , x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1991: )
1992: IS
1993: l_disabled_list WSH_UTIL_CORE.column_tab_type;
1994: l_db_col_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
1995: l_return_status VARCHAR2(30);
1996: l_field_name VARCHAR2(100);
1997: l_parent_entity_id NUMBER;
1998: l_debug_on BOOLEAN;

Line 2004: FROM wsh_trip_stops

2000: 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_DISABLED_LIST';
2001:
2002: CURSOR get_trip_id(p_stop_id NUMBER) IS
2003: SELECT trip_id
2004: FROM wsh_trip_stops
2005: WHERE stop_id = p_stop_rec.STOP_ID;
2006:
2007: CURSOR c_tbl_rec IS
2008: SELECT STOP_ID

Line 2093: FROM wsh_trip_stops

2089: , tp_stop_id
2090: , physical_stop_id
2091: , physical_location_id
2092: , TMS_INTERFACE_FLAG -- OTM R12, glog proj
2093: FROM wsh_trip_stops
2094: WHERE stop_id = p_stop_rec.STOP_ID;
2095:
2096: e_dp_no_entity EXCEPTION;
2097: e_bad_field EXCEPTION;

Line 2177: WSH_TRIP_STOPS_PVT.Get_Disabled_List( p_stop_rec.stop_id

2173: l_caller := p_in_rec.caller;
2174: IF (l_caller like 'FTE%' AND l_caller <> 'FTE_TMS_INTEGRATION') THEN
2175: l_caller := 'WSH_PUB';
2176: END IF;
2177: WSH_TRIP_STOPS_PVT.Get_Disabled_List( p_stop_rec.stop_id
2178: ,l_parent_entity_id
2179: , 'FORM'
2180: , x_return_status
2181: , l_disabled_list

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 2815: FROM wsh_trip_stops wts,

2811: -- J: W/V Changes
2812: wts.departure_gross_weight,
2813: wts.departure_volume,
2814: wts.physical_location_id
2815: FROM wsh_trip_stops wts,
2816: wsh_trips wt
2817: WHERE stop_id = p_stop_id
2818: AND wts.trip_id = wt.trip_id;
2819: --

Line 2844: FROM wsh_trip_stops wts

2840: nvl(wts.shipments_type_flag,'O') shipments_Type_flag,
2841: wts.stop_location_id,
2842: wts.departure_gross_weight,
2843: wts.departure_volume
2844: FROM wsh_trip_stops wts
2845: WHERE wts.physical_stop_id = p_stop_id
2846: AND wts.trip_id = p_trip_id
2847: AND wts.status_code IN ('OP', 'AR');
2848: --

Line 2870: FROM wsh_trip_stops wts

2866: wts.shipments_type_flag shipments_Type_flag,
2867: wts.stop_location_id,
2868: wts.departure_gross_weight,
2869: wts.departure_volume
2870: FROM wsh_trip_stops wts
2871: WHERE wts.physical_stop_id = p_stop_id
2872: AND wts.trip_id = p_trip_id
2873: AND wts.status_code IN ('OP', 'AR')
2874: AND wts.shipments_type_flag = 'I';

Line 2895: FROM wsh_trip_stops

2891: )
2892: IS
2893: SELECT nvl(shipments_type_flag,'O') shipments_Type_flag,
2894: stop_location_id
2895: FROM wsh_trip_stops
2896: WHERE trip_id = p_trip_id
2897: AND status_code IN ('OP','AR')
2898: AND stop_sequence_number < p_stop_sequence
2899: AND stop_id <> NVL(p_linked_stop_id, -1)

Line 2982: FROM wsh_trip_stops prev_leg_do_stop,

2978: DECODE(prev_leg_do_stop.status_code,'OP','OP','XX') do_stop_status_code_ord,
2979: DECODE(prev_leg_pu_stop.status_code,'OP','OP','XX') pu_stop_status_code_ord,
2980: prev_leg_do_stop.trip_id prev_leg_trip_id,
2981: wt.name prev_leg_trip_name
2982: FROM wsh_trip_stops prev_leg_do_stop,
2983: wsh_trip_stops prev_leg_pu_stop,
2984: wsh_trip_stops curr_leg_pu_stop,
2985: wsh_delivery_legs prev_leg,
2986: wsh_delivery_legs curr_leg,

Line 2983: wsh_trip_stops prev_leg_pu_stop,

2979: DECODE(prev_leg_pu_stop.status_code,'OP','OP','XX') pu_stop_status_code_ord,
2980: prev_leg_do_stop.trip_id prev_leg_trip_id,
2981: wt.name prev_leg_trip_name
2982: FROM wsh_trip_stops prev_leg_do_stop,
2983: wsh_trip_stops prev_leg_pu_stop,
2984: wsh_trip_stops curr_leg_pu_stop,
2985: wsh_delivery_legs prev_leg,
2986: wsh_delivery_legs curr_leg,
2987: wsh_new_deliveries wnd,

Line 2984: wsh_trip_stops curr_leg_pu_stop,

2980: prev_leg_do_stop.trip_id prev_leg_trip_id,
2981: wt.name prev_leg_trip_name
2982: FROM wsh_trip_stops prev_leg_do_stop,
2983: wsh_trip_stops prev_leg_pu_stop,
2984: wsh_trip_stops curr_leg_pu_stop,
2985: wsh_delivery_legs prev_leg,
2986: wsh_delivery_legs curr_leg,
2987: wsh_new_deliveries wnd,
2988: wsh_trips wt

Line 3040: FROM wsh_trip_stops prev_leg_do_stop,

3036: DECODE(prev_leg_do_stop.status_code,'OP','OP','XX') do_stop_status_code_ord,
3037: DECODE(prev_leg_pu_stop.status_code,'OP','OP','XX') pu_stop_status_code_ord,
3038: prev_leg_do_stop.trip_id prev_leg_trip_id,
3039: wt.name prev_leg_trip_name
3040: FROM wsh_trip_stops prev_leg_do_stop,
3041: wsh_trip_stops prev_leg_pu_stop,
3042: wsh_trip_stops curr_leg_pu_stop,
3043: wsh_delivery_legs prev_leg,
3044: wsh_delivery_legs curr_leg,

Line 3041: wsh_trip_stops prev_leg_pu_stop,

3037: DECODE(prev_leg_pu_stop.status_code,'OP','OP','XX') pu_stop_status_code_ord,
3038: prev_leg_do_stop.trip_id prev_leg_trip_id,
3039: wt.name prev_leg_trip_name
3040: FROM wsh_trip_stops prev_leg_do_stop,
3041: wsh_trip_stops prev_leg_pu_stop,
3042: wsh_trip_stops curr_leg_pu_stop,
3043: wsh_delivery_legs prev_leg,
3044: wsh_delivery_legs curr_leg,
3045: wsh_new_deliveries wnd,

Line 3042: wsh_trip_stops curr_leg_pu_stop,

3038: prev_leg_do_stop.trip_id prev_leg_trip_id,
3039: wt.name prev_leg_trip_name
3040: FROM wsh_trip_stops prev_leg_do_stop,
3041: wsh_trip_stops prev_leg_pu_stop,
3042: wsh_trip_stops curr_leg_pu_stop,
3043: wsh_delivery_legs prev_leg,
3044: wsh_delivery_legs curr_leg,
3045: wsh_new_deliveries wnd,
3046: wsh_trips wt

Line 3079: FROM wsh_trip_stops st1,

3075: st1.stop_id pu_stop_id,
3076: wnd.delivery_id delivery_id,
3077: wnd.status_code delivery_statusCode,
3078: wnd.initial_pickup_location_id dlvy_initialPULocationId
3079: FROM wsh_trip_stops st1,
3080: wsh_delivery_legs dl2,
3081: wsh_new_deliveries wnd
3082: WHERE dl2.pick_up_stop_id = st1.stop_id
3083: AND st1.status_code = 'CL'

Line 3101: wsh_trip_stops st

3097: dl.name,
3098: dl.status_code
3099: FROM wsh_new_deliveries dl,
3100: wsh_delivery_legs dg,
3101: wsh_trip_stops st
3102: WHERE dg.delivery_id = dl.delivery_id
3103: AND st.stop_location_id = dl.initial_pickup_location_id
3104: AND st.stop_id = dg.pick_up_stop_id
3105: AND st.stop_id = p_stop_id

Line 3124: wsh_trip_stops st

3120: dl.status_code,
3121: dg.drop_off_stop_id
3122: FROM wsh_new_deliveries dl,
3123: wsh_delivery_legs dg,
3124: wsh_trip_stops st
3125: WHERE dg.delivery_id = dl.delivery_id
3126: AND st.stop_location_id = dl.ultimate_dropoff_location_id
3127: AND st.stop_id = dg.drop_off_stop_id
3128: AND st.stop_id IN (p_stop_id, p_dummy_stop_id)

Line 3202: l_virtual_shipments_type_flag WSH_TRIP_STOPS.SHIPMENTS_TYPE_FLAG%TYPE;

3198: --
3199: l_location_id NUMBER;
3200:
3201: --
3202: l_virtual_shipments_type_flag WSH_TRIP_STOPS.SHIPMENTS_TYPE_FLAG%TYPE;
3203:
3204: -- Following three variables are added for BufFix #3947506
3205: l_out_entity_id VARCHAR2(100);
3206: l_out_entity_name VARCHAR2(100);

Line 3446: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trip_stops_pvt.get_name(l_exceptions_tbl(exp_cnt).entity_id)); --BugFix #3925590

3442: ELSIF l_exceptions_tbl(exp_cnt).exception_behavior = 'WARNING' THEN
3443: IF l_exceptions_tbl(exp_cnt).entity_name = 'STOP' THEN
3444: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
3445: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Stop');
3446: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trip_stops_pvt.get_name(l_exceptions_tbl(exp_cnt).entity_id)); --BugFix #3925590
3447: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
3448: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3449: wsh_util_core.add_message(x_return_status);
3450: l_stop_warnings := l_stop_warnings + 1;

Line 4373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

4369:
4370: IF (l_param_info.percent_fill_basis_flag = 'W' and l_stop_info_rec.departure_gross_weight is NULL) THEN
4371: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WV');
4372: IF l_debug_on THEN
4373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4374: END IF;
4375: --
4376: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Stop');
4377: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));

Line 4377: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));

4373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4374: END IF;
4375: --
4376: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Stop');
4377: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));
4378: FND_MESSAGE.SET_TOKEN('WV','Weight');
4379: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4380: wsh_util_core.add_message(x_return_status);
4381: l_stop_warnings := l_stop_warnings + 1;

Line 4387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

4383:
4384: IF (l_param_info.percent_fill_basis_flag = 'V' and l_stop_info_rec.departure_volume is NULL) THEN
4385: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WV');
4386: IF l_debug_on THEN
4387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4388: END IF;
4389: --
4390: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Stop');
4391: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));

Line 4391: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));

4387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4388: END IF;
4389: --
4390: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Stop');
4391: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));
4392: FND_MESSAGE.SET_TOKEN('WV','Volume');
4393: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4394: wsh_util_core.add_message(x_return_status);
4395: l_stop_warnings := l_stop_warnings + 1;

Line 5065: wsh_trip_stops wts

5061: SELECT wnd.initial_pickup_date delivery_Date,
5062: DECODE(wts.stop_location_id,wnd.initial_pickup_location_id,1,3) order_seq
5063: FROM wsh_new_deliveries wnd,
5064: wsh_delivery_legs wdl,
5065: wsh_trip_stops wts
5066: WHERE wts.stop_id = p_stop_id
5067: AND wdl.pick_up_stop_id = wts.stop_id
5068: AND wdl.delivery_id = wnd.delivery_id
5069: UNION

Line 5074: wsh_trip_stops wts

5070: SELECT wnd.ultimate_dropoff_date delivery_Date,
5071: DECODE(wts.stop_location_id,wnd.ultimate_dropoff_location_id,2,4) order_seq
5072: FROM wsh_new_deliveries wnd,
5073: wsh_delivery_legs wdl,
5074: wsh_trip_stops wts
5075: WHERE wts.stop_id = p_stop_id
5076: AND wdl.drop_off_stop_id = wts.stop_id
5077: AND wdl.delivery_id = wnd.delivery_id
5078: ORDER BY order_seq ASC;

Line 5083: FROM wsh_trip_stops

5079: --
5080: CURSOR prev_stop_cur (p_trip_id IN NUMBER, p_stop_sequence_number IN NUMBER)
5081: IS
5082: SELECT actual_departure_date
5083: FROM wsh_trip_stops
5084: WHERE trip_id = p_trip_id
5085: AND stop_sequence_number < p_stop_sequence_number
5086: ORDER BY stop_sequence_number DESC;
5087: --

Line 5091: FROM wsh_trip_stops

5087: --
5088: CURSOR next_stop_cur (p_trip_id IN NUMBER, p_stop_sequence_number IN NUMBER)
5089: IS
5090: SELECT actual_departure_date
5091: FROM wsh_trip_stops
5092: WHERE trip_id = p_trip_id
5093: AND stop_sequence_number > p_stop_sequence_number
5094: ORDER BY stop_sequence_number ASC;
5095: --

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 5241: (p_user_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

5237:
5238:
5239: --3509004:public api change
5240: PROCEDURE user_non_updatable_columns
5241: (p_user_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
5242: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
5243: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
5244: x_return_status OUT NOCOPY VARCHAR2)
5245:

Line 5242: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

5238:
5239: --3509004:public api change
5240: PROCEDURE user_non_updatable_columns
5241: (p_user_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
5242: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
5243: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
5244: x_return_status OUT NOCOPY VARCHAR2)
5245:
5246: IS

Line 5243: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,

5239: --3509004:public api change
5240: PROCEDURE user_non_updatable_columns
5241: (p_user_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
5242: p_out_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
5243: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
5244: x_return_status OUT NOCOPY VARCHAR2)
5245:
5246: IS
5247: l_attributes VARCHAR2(2500) ;

Line 5801: END WSH_TRIP_STOPS_VALIDATIONS;

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