APPS.WSH_UTIL_VALIDATE dependencies on WSH_TRIPS

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

2304: -- PROCEDURE : Validate_Stop_Name
2305: --
2306: -- COMMENT : Validates Stop_id OR
2307: -- Trip_id+Stop_Location_id+Planned_Departure_date against table
2308: -- wsh_trips. If both validations are possible then only
2309: -- stop_id is validated
2310: --========================================================================
2311:
2312: PROCEDURE Validate_Stop_Name

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

2386: --========================================================================
2387: -- PROCEDURE : Validate_Trip_Name
2388: --
2389: -- COMMENT : Validates Trip_id/Trip_Name against table
2390: -- wsh_trips. If both values are specified then only
2391: -- trip_id is used
2392: --========================================================================
2393:
2394: PROCEDURE Validate_Trip_Name

Line 2401: FROM wsh_trips

2397: x_return_status OUT NOCOPY VARCHAR2 ) IS
2398:
2399: CURSOR check_trip_name IS
2400: SELECT trip_id
2401: FROM wsh_trips
2402: WHERE NVL(p_trip_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2403: trip_id = p_trip_id
2404: UNION ALL
2405: SELECT trip_id

Line 2406: FROM wsh_trips

2402: WHERE NVL(p_trip_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2403: trip_id = p_trip_id
2404: UNION ALL
2405: SELECT trip_id
2406: FROM wsh_trips
2407: WHERE NVL(p_trip_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND
2408: name = p_trip_name;
2409:
2410: --

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

2505: FETCH check_stop_count INTO l_stop_count;
2506:
2507: IF l_stop_count = 3 THEN
2508:
2509: l_trip_name := WSH_TRIPS_PVT.Get_Name(p_trip_id);
2510: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MOT_STOP_COUNT');
2511: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
2512: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2513: wsh_util_core.add_message(x_return_status,l_module_name);

Line 2761: from wsh_trips

2757:
2758: /* J TP Release : If assigning del to trip doesn't introduce new stops, ok to assign to planned trips */
2759: CURSOR get_trip_status_1(l_trip_id NUMBER) IS
2760: select 'X', name
2761: from wsh_trips
2762: where trip_id = p_trip_id
2763: and
2764: (
2765: ( status_code IN ( 'OP','IT' )

Line 2774: from wsh_trips

2770: and nvl(planned_flag,'N') ='N'
2771: and rownum = 1;
2772: CURSOR get_trip_status_2(l_trip_id NUMBER) IS
2773: select 'X', name
2774: from wsh_trips
2775: where trip_id = p_trip_id
2776: and
2777: (
2778: ( status_code IN ( 'OP' )

Line 3117: from wsh_trips

3113: select carrier_id,
3114: service_level,
3115: mode_of_transport,
3116: ship_method_code
3117: from wsh_trips
3118: where trip_id = p_trip_id;
3119:
3120:
3121: -- Bug 4086855

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

3518: CLOSE l_trip_stop_count;
3519:
3520: IF l_stop_count = 3 THEN
3521:
3522: l_trip_name := WSH_TRIPS_PVT.Get_Name(p_entity_id);
3523: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MOT_STOP_COUNT');
3524: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
3525: x_return_status := wsh_util_core.g_ret_sts_error;
3526: wsh_util_core.add_message(x_return_status,l_module_name);