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 2142: wsh_trips wt,

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

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

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

Line 2435: FROM wsh_trips

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

Line 2441: FROM wsh_trips

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

Line 2521: p_trip_info IN WSH_TRIPS_PVT.trip_rec_type,

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

Line 2522: p_db_trip_info IN WSH_TRIPS_PVT.trip_rec_type,

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

Line 2525: l_vehicle_item_id wsh_trips.vehicle_item_id%type;

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

Line 2526: l_vehicle_organization_id wsh_trips.vehicle_organization_id%type;

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

Line 2527: l_ship_method_code wsh_trips.ship_method_code%type;

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

Line 2528: l_carrier_id wsh_trips.carrier_id%type;

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

Line 2529: l_service_level wsh_trips.service_level%type;

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

Line 2530: l_mode_of_transport wsh_trips.mode_of_transport%type;

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

Line 2531: l_lane_id wsh_trips.lane_id%type;

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

Line 2700: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type

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

Line 2701: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType

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

Line 2702: , x_trip_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type

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

Line 2992: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type

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

Line 2993: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type

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

Line 3158: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type

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

Line 3159: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type

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

Line 3462: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type

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

Line 3463: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType

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

Line 3467: , x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type

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

Line 3471: l_db_col_rec WSH_TRIPS_PVT.trip_rec_type;

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

Line 3561: WSH_TRIPS_PVT.populate_record(

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

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

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

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

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

Line 4616: from wsh_trips

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

Line 5040: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,

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

Line 5041: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,

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

Line 5042: p_in_rec IN WSH_TRIPS_GRP.TripInRecType,

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

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

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

Line 6031: WSH_TRIPS_PVT.get_name(p_trip_id));

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

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

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

Line 6042: WSH_TRIPS_ACTIONS.unassign_trip

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