APPS.WSH_UTIL_VALIDATE dependencies on WSH_TRIPS

Line 2330: -- wsh_trips. If both validations are possible then only

2326: -- PROCEDURE : Validate_Stop_Name
2327: --
2328: -- COMMENT : Validates Stop_id OR
2329: -- Trip_id+Stop_Location_id+Planned_Departure_date against table
2330: -- wsh_trips. If both validations are possible then only
2331: -- stop_id is validated
2332: --========================================================================
2333:
2334: PROCEDURE Validate_Stop_Name

Line 2412: -- wsh_trips. If both values are specified then only

2408: --========================================================================
2409: -- PROCEDURE : Validate_Trip_Name
2410: --
2411: -- COMMENT : Validates Trip_id/Trip_Name against table
2412: -- wsh_trips. If both values are specified then only
2413: -- trip_id is used
2414: --========================================================================
2415:
2416: PROCEDURE Validate_Trip_Name

Line 2423: FROM wsh_trips

2419: x_return_status OUT NOCOPY VARCHAR2 ) IS
2420:
2421: CURSOR check_trip_name IS
2422: SELECT trip_id
2423: FROM wsh_trips
2424: WHERE NVL(p_trip_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2425: trip_id = p_trip_id
2426: UNION ALL
2427: SELECT trip_id

Line 2428: FROM wsh_trips

2424: WHERE NVL(p_trip_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2425: trip_id = p_trip_id
2426: UNION ALL
2427: SELECT trip_id
2428: FROM wsh_trips
2429: WHERE NVL(p_trip_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND
2430: name = p_trip_name;
2431:
2432: --

Line 2531: l_trip_name := WSH_TRIPS_PVT.Get_Name(p_trip_id);

2527: FETCH check_stop_count INTO l_stop_count;
2528:
2529: IF l_stop_count = 3 THEN
2530:
2531: l_trip_name := WSH_TRIPS_PVT.Get_Name(p_trip_id);
2532: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MOT_STOP_COUNT');
2533: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
2534: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2535: wsh_util_core.add_message(x_return_status,l_module_name);

Line 2783: from wsh_trips

2779:
2780: /* J TP Release : If assigning del to trip doesn't introduce new stops, ok to assign to planned trips */
2781: CURSOR get_trip_status_1(l_trip_id NUMBER) IS
2782: select 'X', name
2783: from wsh_trips
2784: where trip_id = p_trip_id
2785: and
2786: (
2787: ( status_code IN ( 'OP','IT' )

Line 2796: from wsh_trips

2792: and nvl(planned_flag,'N') ='N'
2793: and rownum = 1;
2794: CURSOR get_trip_status_2(l_trip_id NUMBER) IS
2795: select 'X', name
2796: from wsh_trips
2797: where trip_id = p_trip_id
2798: and
2799: (
2800: ( status_code IN ( 'OP' )

Line 3139: from wsh_trips

3135: select carrier_id,
3136: service_level,
3137: mode_of_transport,
3138: ship_method_code
3139: from wsh_trips
3140: where trip_id = p_trip_id;
3141:
3142:
3143: -- Bug 4086855

Line 3560: l_trip_name := WSH_TRIPS_PVT.Get_Name(p_entity_id);

3556: CLOSE l_trip_stop_count;
3557:
3558: IF l_stop_count = 3 THEN
3559:
3560: l_trip_name := WSH_TRIPS_PVT.Get_Name(p_entity_id);
3561: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MOT_STOP_COUNT');
3562: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
3563: x_return_status := wsh_util_core.g_ret_sts_error;
3564: wsh_util_core.add_message(x_return_status,l_module_name);