DBA Data[Home] [Help]

APPS.WSH_TRIP_VALIDATIONS dependencies on WSH_TRIPS_PVT

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 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 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 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 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 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 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 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 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 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 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);