DBA Data[Home] [Help]

APPS.WSH_DELIVERY_LEGS_ACTIONS dependencies on WSH_TRIPS_PVT

Line 261: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

257:
258: /* H integration for Multi Leg */
259: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
260: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
261: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
262: l_pub_trip_rec WSH_TRIPS_PUB.TRIP_PUB_REC_TYPE;
263: l_return_status VARCHAR2(30);
264:
265: l_pickup_seq NUMBER;

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

511: <>
512:
513: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_ERROR');
514: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_name);
515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
516: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
517: l_num_error := l_num_error + 1;
518:
519: <>

Line 970: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);

966: FETCH c_check_dummystops INTO l_check_dummystops;
967: IF c_check_dummystops%NOTFOUND THEN
968: CLOSE c_check_dummystops;
969: IF l_debug_on THEN
970: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
971: END IF;
972: FND_MESSAGE.SET_NAME('WSH','WSH_FIRMTRIP_NO_NEW_STOP');
973: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
974: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);

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

969: IF l_debug_on THEN
970: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
971: END IF;
972: FND_MESSAGE.SET_NAME('WSH','WSH_FIRMTRIP_NO_NEW_STOP');
973: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
974: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
975: RAISE e_InvalidDelExcep; -- Bug 5336308
976: END IF;
977: CLOSE c_check_dummystops;

Line 1392: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);

1388: FETCH c_check_dummystops INTO l_check_dummystops;
1389: IF c_check_dummystops%NOTFOUND THEN
1390: CLOSE c_check_dummystops;
1391: IF l_debug_on THEN
1392: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
1393: END IF;
1394: FND_MESSAGE.SET_NAME('WSH','WSH_FIRMTRIP_NO_NEW_STOP');
1395: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
1396: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);

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

1391: IF l_debug_on THEN
1392: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
1393: END IF;
1394: FND_MESSAGE.SET_NAME('WSH','WSH_FIRMTRIP_NO_NEW_STOP');
1395: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
1396: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
1397: RAISE e_InvalidDelExcep; -- Bug 5336308
1398: END IF;
1399: CLOSE c_check_dummystops;

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

1974: END IF;
1975: --
1976: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_rows(i)));
1977: -- Bug 3439165
1978: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
1979: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
1980: l_num_error := l_num_error + 1;
1981: --
1982: WHEN e_CommonExcep THEN

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

2342:
2343: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_SUMMARY');
2344: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
2345: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_del_rows.count-l_num_error);
2346: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2347:
2348: IF (l_num_error = p_del_rows.count) THEN
2349: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2350: ELSE