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_VALIDATIONS dependencies on WSH_TRIPS

Line 7: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,

3:
4: --
5: --3509004:public api changes
6: PROCEDURE user_non_updatable_columns
7: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,
8: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,
9: p_in_rec IN WSH_TRIPS_GRP.TripInRecType,
10: x_return_status OUT NOCOPY VARCHAR2);
11:

Line 8: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,

4: --
5: --3509004:public api changes
6: PROCEDURE user_non_updatable_columns
7: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,
8: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,
9: p_in_rec IN WSH_TRIPS_GRP.TripInRecType,
10: x_return_status OUT NOCOPY VARCHAR2);
11:
12:

Line 9: p_in_rec IN WSH_TRIPS_GRP.TripInRecType,

5: --3509004:public api changes
6: PROCEDURE user_non_updatable_columns
7: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,
8: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,
9: p_in_rec IN WSH_TRIPS_GRP.TripInRecType,
10: x_return_status OUT NOCOPY VARCHAR2);
11:
12:
13: -----------------------------------------------------------------------------

Line 44: FROM wsh_trips

40: CURSOR trip_info IS
41: SELECT vehicle_item_id,
42: ship_method_code,
43: mode_of_transport
44: FROM wsh_trips
45: WHERE trip_id = p_trip_id;
46:
47: CURSOR deliveries_exist IS
48: SELECT dl.delivery_id

Line 49: FROM wsh_trips t,

45: WHERE trip_id = p_trip_id;
46:
47: CURSOR deliveries_exist IS
48: SELECT dl.delivery_id
49: FROM wsh_trips t,
50: wsh_trip_stops st,
51: wsh_delivery_legs dg,
52: wsh_new_deliveries dl
53: WHERE t.trip_id = p_trip_id AND

Line 70: FROM wsh_trips t,

66: CURSOR vehicle_info IS
67: SELECT msi.minimum_fill_percent,
68: msi.maximum_load_weight,
69: msi.internal_volume
70: FROM wsh_trips t,
71: mtl_system_items msi
72: WHERE t.trip_id = p_trip_id AND
73: t.vehicle_item_id = msi.inventory_item_id AND
74: t.vehicle_organization_id = msi.organization_id;

Line 83: l_mode wsh_trips.mode_of_transport%TYPE;

79: l_min_fill NUMBER;
80: l_max_wt NUMBER;
81: l_max_vol NUMBER;
82: l_ship_method VARCHAR2(30);
83: l_mode wsh_trips.mode_of_transport%TYPE;
84:
85: --
86: l_debug_on BOOLEAN;
87: --

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

115: --
116: -- Debug Statements
117: --
118: IF l_debug_on THEN
119: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
120: END IF;
121: --
122: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
123: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 122: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

118: IF l_debug_on THEN
119: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
120: END IF;
121: --
122: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
123: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
124: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
125: --
126: -- Debug Statements

Line 159: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

155: --changes in 'firm' behavior - only ship method is reqd.
156: --if tp is installed and mode happens to be TL, vehicle is required
157: IF (l_ship_method IS NULL) THEN
158: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_VEHICLE_SH_M_REQ');
159: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
160: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
161: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
162: --
163: -- Debug Statements

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

171:
172: IF l_mode='TRUCK' and l_vehicle is NULL AND WSH_UTIL_CORE.TP_IS_INSTALLED='Y' THEN
173: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_MODE_TR_REQ_VEH');
174: IF l_debug_on THEN
175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
176: END IF;
177: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
178: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
179: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 177: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

173: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_MODE_TR_REQ_VEH');
174: IF l_debug_on THEN
175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
176: END IF;
177: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
178: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
179: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
180: --
181: -- Debug Statements

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

198: --
199: -- Debug Statements
200: --
201: IF l_debug_on THEN
202: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
203: END IF;
204: --
205: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
206: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 205: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

201: IF l_debug_on THEN
202: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
203: END IF;
204: --
205: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
206: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
207: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
208: END IF;
209:

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

218: --
219: -- Debug Statements
220: --
221: IF l_debug_on THEN
222: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
223: END IF;
224: --
225: -- Bug 3697947
226: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(st.stop_id,p_caller));

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

231: --
232: -- Debug Statements
233: --
234: IF l_debug_on THEN
235: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
236: END IF;
237: --
238: -- Bug 3697947
239: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(st.stop_id,p_caller));

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

246: --
247: -- Debug Statements
248: --
249: IF l_debug_on THEN
250: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
251: END IF;
252: --
253: -- Bug 3697947
254: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(st.stop_id, p_caller));

Line 301: FROM wsh_trips

297: CURSOR trip_info IS
298: SELECT status_code,
299: planned_flag,
300: NVL(shipments_type_flag,'O') shipments_type_flag -- J-IB-NPARIKH
301: FROM wsh_trips
302: WHERE trip_id = p_trip_id;
303:
304: l_status_code VARCHAR2(2);
305: l_planned_flag VARCHAR2(1);

Line 776: FROM wsh_trips

772:
773: CURSOR trip_info IS
774: SELECT status_code,
775: planned_flag
776: FROM wsh_trips
777: WHERE trip_id = p_trip_id;
778:
779: CURSOR stops_info IS
780: SELECT stop_id

Line 842: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

838: CLOSE trip_info;
839:
840: IF (l_status_code <> 'OP') THEN
841: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_INVALID_STATUS');
842: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
843: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
844: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
845: --
846: -- Debug Statements

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

859: --
860: -- Debug Statements
861: --
862: IF l_debug_on THEN
863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
864: END IF;
865: --
866: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(p_trip_id));
867: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 866: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(p_trip_id));

862: IF l_debug_on THEN
863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
864: END IF;
865: --
866: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(p_trip_id));
867: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
868: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
869: ELSIF (l_planned_flag='F') THEN
870: FND_MESSAGE.SET_NAME('WSH','WSH_DELETE_FIRM_TRIP');

Line 871: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

867: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
868: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
869: ELSIF (l_planned_flag='F') THEN
870: FND_MESSAGE.SET_NAME('WSH','WSH_DELETE_FIRM_TRIP');
871: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
872: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
873: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
874: IF l_debug_on THEN
875: WSH_DEBUG_SV.pop(l_module_name);

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

914: --
915: -- Debug Statements
916: --
917: IF l_debug_on THEN
918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
919: END IF;
920: --
921: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(p_trip_id));
922: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 921: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(p_trip_id));

917: IF l_debug_on THEN
918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
919: END IF;
920: --
921: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(p_trip_id));
922: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
923: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
924: END IF;
925:

Line 965: FROM wsh_trips

961:
962: CURSOR trip_info IS
963: SELECT status_code,
964: planned_flag
965: FROM wsh_trips
966: WHERE trip_id = p_trip_id;
967:
968: CURSOR group_by_carrier_set IS
969: SELECT count(*)

Line 1419: FROM wsh_trips t,

1415: SELECT t.status_code,
1416: t.planned_flag,
1417: st.status_code,
1418: t.trip_id
1419: FROM wsh_trips t,
1420: wsh_trip_stops st
1421: WHERE st.stop_id = p_stop_id AND
1422: st.trip_id = t.trip_id;
1423:

Line 1515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trip_id));

1511: END IF;
1512:
1513: IF (l_trip_status_code = 'CL') THEN
1514: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_INVALID_STATUS');
1515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trip_id));
1516: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1517: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1518: --
1519: -- Debug Statements

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

1530: --
1531: -- Debug Statements
1532: --
1533: IF l_debug_on THEN
1534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1535: END IF;
1536: --
1537: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
1538: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1537: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));

1533: IF l_debug_on THEN
1534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1535: END IF;
1536: --
1537: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
1538: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1539: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1540: --
1541: -- Debug Statements

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

1550: --
1551: -- Debug Statements
1552: --
1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1555: END IF;
1556: --
1557: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
1558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1557: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));

1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1555: END IF;
1556: --
1557: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
1558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1559: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1560: --
1561: -- Debug Statements

Line 1664: FROM wsh_trips

1660: SELECT status_code, planned_flag, SHIPMENTS_TYPE_FLAG, --3509004:public api changes
1661: vehicle_organization_id, -- Bug 3599626
1662: lane_id,
1663: tp_plan_name -- OTM R12, glog proj
1664: FROM wsh_trips
1665: WHERE trip_id = p_trip_id;
1666:
1667: i NUMBER := 0;
1668: l_tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE; -- OTM R12, glog proj

Line 1668: l_tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE; -- OTM R12, glog proj

1664: FROM wsh_trips
1665: WHERE trip_id = p_trip_id;
1666:
1667: i NUMBER := 0;
1668: l_tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE; -- OTM R12, glog proj
1669: l_gc3_is_installed VARCHAR(1); --OTM R12, glog proj
1670: l_status_code VARCHAR2(10) := NULL;
1671: l_planned_flag VARCHAR2(10) := NULL;
1672: l_vehicle_org_id NUMBER; -- Bug 3599626

Line 2001: FROM wsh_trips

1997:
1998: -- kept it separte because this need not execute everytime
1999: CURSOR c_get_trip_planned(v_trip_id IN NUMBER) IS
2000: SELECT planned_flag
2001: FROM wsh_trips
2002: WHERE trip_id = v_trip_id;
2003:
2004: l_stop_sequence_number NUMBER;
2005: l_trip_id NUMBER;

Line 2141: wsh_trips wt,

2137: FROM wsh_new_deliveries wnd,
2138: wsh_delivery_legs wdl,
2139: wsh_trip_stops wts1,
2140: wsh_trip_stops wts2,
2141: wsh_trips wt,
2142: wsh_shipping_parameters wsp -- OTM R12, glog proj
2143: WHERE wnd.delivery_id = wdl.delivery_id
2144: AND wts1.stop_id = wdl.PICK_UP_STOP_ID
2145: AND wts2.stop_id = wdl.DROP_OFF_STOP_ID

Line 2367: wsh_trips_pvt.get_name(x_error_ids(x_error_ids.COUNT)));

2363: IF p_caller = 'WSH_PUB' or p_caller like 'FTE%' THEN
2364: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_ACTION_INELIGIBLE');
2365: FND_MESSAGE.Set_Token('ACTION',wsh_util_core.get_action_meaning('TRIP',p_action));
2366: FND_MESSAGE.Set_Token('TRIP_NAME',
2367: wsh_trips_pvt.get_name(x_error_ids(x_error_ids.COUNT)));
2368: wsh_util_core.add_message('E',l_module_name);
2369: END IF;
2370: END;
2371:

Line 2432: FROM wsh_trips

2428: x_return_status OUT NOCOPY VARCHAR2) IS
2429:
2430: CURSOR get_trip_id(cp_arr_after_trip_id NUMBER) IS
2431: SELECT 'X'
2432: FROM wsh_trips
2433: WHERE trip_id = cp_arr_after_trip_id
2434: AND status_code <> 'CL';
2435:
2436: CURSOR get_trip_name(cp_arr_after_trip_name VARCHAR2) IS

Line 2438: FROM wsh_trips

2434: AND status_code <> 'CL';
2435:
2436: CURSOR get_trip_name(cp_arr_after_trip_name VARCHAR2) IS
2437: SELECT 'X',trip_id
2438: FROM wsh_trips
2439: WHERE name = cp_arr_after_trip_name
2440: AND status_code <> 'CL';
2441:
2442: l_debug_on BOOLEAN;

Line 2518: p_trip_info IN WSH_TRIPS_PVT.trip_rec_type,

2514: END Validate_Arrive_after_trip;
2515:
2516:
2517: PROCEDURE Validate_Consol_Allowed(
2518: p_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
2519: p_db_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
2520: x_return_status OUT NOCOPY VARCHAR2) IS
2521:
2522: l_vehicle_item_id wsh_trips.vehicle_item_id%type;

Line 2519: p_db_trip_info IN WSH_TRIPS_PVT.trip_rec_type,

2515:
2516:
2517: PROCEDURE Validate_Consol_Allowed(
2518: p_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
2519: p_db_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
2520: x_return_status OUT NOCOPY VARCHAR2) IS
2521:
2522: l_vehicle_item_id wsh_trips.vehicle_item_id%type;
2523: l_vehicle_organization_id wsh_trips.vehicle_organization_id%type;

Line 2522: l_vehicle_item_id wsh_trips.vehicle_item_id%type;

2518: p_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
2519: p_db_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
2520: x_return_status OUT NOCOPY VARCHAR2) IS
2521:
2522: l_vehicle_item_id wsh_trips.vehicle_item_id%type;
2523: l_vehicle_organization_id wsh_trips.vehicle_organization_id%type;
2524: l_ship_method_code wsh_trips.ship_method_code%type;
2525: l_carrier_id wsh_trips.carrier_id%type;
2526: l_service_level wsh_trips.service_level%type;

Line 2523: l_vehicle_organization_id wsh_trips.vehicle_organization_id%type;

2519: p_db_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
2520: x_return_status OUT NOCOPY VARCHAR2) IS
2521:
2522: l_vehicle_item_id wsh_trips.vehicle_item_id%type;
2523: l_vehicle_organization_id wsh_trips.vehicle_organization_id%type;
2524: l_ship_method_code wsh_trips.ship_method_code%type;
2525: l_carrier_id wsh_trips.carrier_id%type;
2526: l_service_level wsh_trips.service_level%type;
2527: l_mode_of_transport wsh_trips.mode_of_transport%type;

Line 2524: l_ship_method_code wsh_trips.ship_method_code%type;

2520: x_return_status OUT NOCOPY VARCHAR2) IS
2521:
2522: l_vehicle_item_id wsh_trips.vehicle_item_id%type;
2523: l_vehicle_organization_id wsh_trips.vehicle_organization_id%type;
2524: l_ship_method_code wsh_trips.ship_method_code%type;
2525: l_carrier_id wsh_trips.carrier_id%type;
2526: l_service_level wsh_trips.service_level%type;
2527: l_mode_of_transport wsh_trips.mode_of_transport%type;
2528: l_lane_id wsh_trips.lane_id%type;

Line 2525: l_carrier_id wsh_trips.carrier_id%type;

2521:
2522: l_vehicle_item_id wsh_trips.vehicle_item_id%type;
2523: l_vehicle_organization_id wsh_trips.vehicle_organization_id%type;
2524: l_ship_method_code wsh_trips.ship_method_code%type;
2525: l_carrier_id wsh_trips.carrier_id%type;
2526: l_service_level wsh_trips.service_level%type;
2527: l_mode_of_transport wsh_trips.mode_of_transport%type;
2528: l_lane_id wsh_trips.lane_id%type;
2529: l_c_truck CONSTANT VARCHAR2(10):='TRUCK';

Line 2526: l_service_level wsh_trips.service_level%type;

2522: l_vehicle_item_id wsh_trips.vehicle_item_id%type;
2523: l_vehicle_organization_id wsh_trips.vehicle_organization_id%type;
2524: l_ship_method_code wsh_trips.ship_method_code%type;
2525: l_carrier_id wsh_trips.carrier_id%type;
2526: l_service_level wsh_trips.service_level%type;
2527: l_mode_of_transport wsh_trips.mode_of_transport%type;
2528: l_lane_id wsh_trips.lane_id%type;
2529: l_c_truck CONSTANT VARCHAR2(10):='TRUCK';
2530:

Line 2527: l_mode_of_transport wsh_trips.mode_of_transport%type;

2523: l_vehicle_organization_id wsh_trips.vehicle_organization_id%type;
2524: l_ship_method_code wsh_trips.ship_method_code%type;
2525: l_carrier_id wsh_trips.carrier_id%type;
2526: l_service_level wsh_trips.service_level%type;
2527: l_mode_of_transport wsh_trips.mode_of_transport%type;
2528: l_lane_id wsh_trips.lane_id%type;
2529: l_c_truck CONSTANT VARCHAR2(10):='TRUCK';
2530:
2531: l_debug_on BOOLEAN;

Line 2528: l_lane_id wsh_trips.lane_id%type;

2524: l_ship_method_code wsh_trips.ship_method_code%type;
2525: l_carrier_id wsh_trips.carrier_id%type;
2526: l_service_level wsh_trips.service_level%type;
2527: l_mode_of_transport wsh_trips.mode_of_transport%type;
2528: l_lane_id wsh_trips.lane_id%type;
2529: l_c_truck CONSTANT VARCHAR2(10):='TRUCK';
2530:
2531: l_debug_on BOOLEAN;
2532: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'VALIDATE_CONSOL_ALLOWED';

Line 2697: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type

2693:
2694:
2695:
2696: PROCEDURE eliminate_displayonly_fields (
2697: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type
2698: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
2699: , x_trip_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
2700: )
2701: IS

Line 2698: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType

2694:
2695:
2696: PROCEDURE eliminate_displayonly_fields (
2697: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type
2698: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
2699: , x_trip_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
2700: )
2701: IS
2702: BEGIN

Line 2699: , x_trip_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type

2695:
2696: PROCEDURE eliminate_displayonly_fields (
2697: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type
2698: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
2699: , x_trip_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
2700: )
2701: IS
2702: BEGIN
2703:

Line 2989: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type

2985: -----------------------------------------------------------*/
2986:
2987: PROCEDURE disable_from_list(
2988: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
2989: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type
2990: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
2991: , x_return_status OUT NOCOPY VARCHAR2
2992: , x_field_name OUT NOCOPY VARCHAR2
2993:

Line 2990: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type

2986:
2987: PROCEDURE disable_from_list(
2988: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
2989: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type
2990: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
2991: , x_return_status OUT NOCOPY VARCHAR2
2992: , x_field_name OUT NOCOPY VARCHAR2
2993:
2994: ) IS

Line 3155: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type

3151: -----------------------------------------------------------*/
3152:
3153: PROCEDURE enable_from_list(
3154: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
3155: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type
3156: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
3157: , x_return_status OUT NOCOPY VARCHAR2
3158: , x_field_name OUT NOCOPY VARCHAR2
3159:

Line 3156: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type

3152:
3153: PROCEDURE enable_from_list(
3154: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
3155: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type
3156: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
3157: , x_return_status OUT NOCOPY VARCHAR2
3158: , x_field_name OUT NOCOPY VARCHAR2
3159:
3160: ) IS

Line 3459: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type

3455: -- Overloaded procedure
3456: -- Bug 2678363: Added new parameter p_in_rec, in place of p_action
3457: --
3458: PROCEDURE Get_Disabled_List (
3459: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type
3460: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
3461: , x_return_status OUT NOCOPY VARCHAR2
3462: , x_msg_count OUT NOCOPY NUMBER
3463: , x_msg_data OUT NOCOPY VARCHAR2

Line 3460: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType

3456: -- Bug 2678363: Added new parameter p_in_rec, in place of p_action
3457: --
3458: PROCEDURE Get_Disabled_List (
3459: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type
3460: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
3461: , x_return_status OUT NOCOPY VARCHAR2
3462: , x_msg_count OUT NOCOPY NUMBER
3463: , x_msg_data OUT NOCOPY VARCHAR2
3464: , x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type

Line 3464: , x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type

3460: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
3461: , x_return_status OUT NOCOPY VARCHAR2
3462: , x_msg_count OUT NOCOPY NUMBER
3463: , x_msg_data OUT NOCOPY VARCHAR2
3464: , x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
3465: )
3466: IS
3467: l_disabled_list WSH_UTIL_CORE.column_tab_type;
3468: l_db_col_rec WSH_TRIPS_PVT.trip_rec_type;

Line 3468: l_db_col_rec WSH_TRIPS_PVT.trip_rec_type;

3464: , x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
3465: )
3466: IS
3467: l_disabled_list WSH_UTIL_CORE.column_tab_type;
3468: l_db_col_rec WSH_TRIPS_PVT.trip_rec_type;
3469: l_return_status VARCHAR2(30);
3470: l_field_name VARCHAR2(100);
3471: l_debug_on BOOLEAN;
3472: l_module_name CONSTANT VARCHAR2(100) :=

Line 3558: WSH_TRIPS_PVT.populate_record(

3554: END IF;
3555: END IF;
3556: --
3557:
3558: WSH_TRIPS_PVT.populate_record(
3559: p_trip_id => p_trip_rec.trip_id,
3560: x_trip_info => x_trip_rec,
3561: x_return_status => x_return_status);
3562:

Line 4157: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trips_pvt.get_name(l_exceptions_tab(exp_cnt).entity_id));

4153: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN
4154: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
4155: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
4156: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
4157: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trips_pvt.get_name(l_exceptions_tab(exp_cnt).entity_id));
4158: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
4159: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4160: wsh_util_core.add_message(x_return_status);
4161: l_num_warnings := l_num_warnings + 1;

Line 4450: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trips_pvt.get_name(l_exceptions_tab(exp_cnt).entity_id));

4446: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN
4447: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
4448: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
4449: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
4450: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trips_pvt.get_name(l_exceptions_tab(exp_cnt).entity_id));
4451: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
4452: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4453: wsh_util_core.add_message(x_return_status);
4454: l_num_warnings := l_num_warnings + 1;

Line 4613: from wsh_trips

4609:
4610: CURSOR trip_csr (p_trip_id NUMBER)
4611: IS
4612: select status_code, name, nvl(planned_flag,'N') planned_flag
4613: from wsh_trips
4614: where trip_id = p_trip_id;
4615: --
4616: l_trip_rec trip_csr%ROWTYPE;
4617: --

Line 5037: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,

5033: -- J-IB-NPARIKH-}
5034: --
5035: --3509004:public api change
5036: PROCEDURE user_non_updatable_columns
5037: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,
5038: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,
5039: p_in_rec IN WSH_TRIPS_GRP.TripInRecType,
5040: x_return_status OUT NOCOPY VARCHAR2)
5041:

Line 5038: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,

5034: --
5035: --3509004:public api change
5036: PROCEDURE user_non_updatable_columns
5037: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,
5038: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,
5039: p_in_rec IN WSH_TRIPS_GRP.TripInRecType,
5040: x_return_status OUT NOCOPY VARCHAR2)
5041:
5042: IS

Line 5039: p_in_rec IN WSH_TRIPS_GRP.TripInRecType,

5035: --3509004:public api change
5036: PROCEDURE user_non_updatable_columns
5037: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,
5038: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,
5039: p_in_rec IN WSH_TRIPS_GRP.TripInRecType,
5040: x_return_status OUT NOCOPY VARCHAR2)
5041:
5042: IS
5043: l_attributes VARCHAR2(2500) ;

Line 5964: IF WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN

5960: END IF;
5961:
5962: -- SSN Change
5963: -- Date validations are applicable only for Profile option = PAD and not if it is set to SSN
5964: IF WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
5965: IF l_debug_on THEN
5966: WSH_DEBUG_SV.logmsg(l_module_name,'Stop Sequence Mode is SSN');
5967: WSH_DEBUG_SV.pop(l_module_name);
5968: END IF;

Line 6028: WSH_TRIPS_PVT.get_name(p_trip_id));

6024: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_TRIP');
6025: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
6026: WSH_NEW_DELIVERIES_PVT.get_name(l_del_to_unassign(i)));
6027: FND_MESSAGE.SET_TOKEN('TRIP_NAME',
6028: WSH_TRIPS_PVT.get_name(p_trip_id));
6029: l_num_warn := l_num_warn + 1;
6030: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
6031:
6032: i := l_del_to_unassign.next(i);

Line 6036: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.UNASSIGN_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);

6032: i := l_del_to_unassign.next(i);
6033: END LOOP;
6034:
6035: IF l_debug_on THEN
6036: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.UNASSIGN_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
6037: END IF;
6038:
6039: WSH_TRIPS_ACTIONS.unassign_trip
6040: (p_del_rows => l_del_to_unassign,

Line 6039: WSH_TRIPS_ACTIONS.unassign_trip

6035: IF l_debug_on THEN
6036: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.UNASSIGN_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
6037: END IF;
6038:
6039: WSH_TRIPS_ACTIONS.unassign_trip
6040: (p_del_rows => l_del_to_unassign,
6041: p_trip_id => p_trip_id,
6042: x_return_status => l_return_status);
6043: