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_NEW_DELIVERIES_PVT dependencies on WSH_DELIVERY_VALIDATIONS

Line 589: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

585: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
586: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
587: l_tms_update VARCHAR2(1);
588: l_trip_not_found VARCHAR2(1);
589: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
590: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;
591: l_gc3_is_installed VARCHAR2(1);
592: l_sysdate DATE;
593: api_return_fail EXCEPTION;

Line 736: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',WSH_DEBUG_SV.C_PROC_LEVEL);

732: l_tms_version_number := 1;
733:
734: --get trip information for delivery, no update when trip not OPEN
735: IF l_debug_on THEN
736: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',WSH_DEBUG_SV.C_PROC_LEVEL);
737: END IF;
738:
739: WSH_DELIVERY_VALIDATIONS.get_trip_information
740: (p_delivery_id => p_delivery_info.delivery_id,

Line 739: WSH_DELIVERY_VALIDATIONS.get_trip_information

735: IF l_debug_on THEN
736: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',WSH_DEBUG_SV.C_PROC_LEVEL);
737: END IF;
738:
739: WSH_DELIVERY_VALIDATIONS.get_trip_information
740: (p_delivery_id => p_delivery_info.delivery_id,
741: x_trip_info_rec => l_trip_info_rec,
742: x_return_status => l_return_status);
743:

Line 745: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',l_return_status);

741: x_trip_info_rec => l_trip_info_rec,
742: x_return_status => l_return_status);
743:
744: IF l_debug_on THEN
745: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',l_return_status);
746: END IF;
747:
748: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
749: IF l_debug_on THEN

Line 750: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');

746: END IF;
747:
748: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
749: IF l_debug_on THEN
750: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
751: END IF;
752: RAISE api_return_fail;
753: END IF;
754:

Line 763: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);

759: -- only do changes when there's no trip or trip status is OPEN
760: IF (l_trip_info_rec.status_code = 'OP' OR l_trip_not_found = 'Y') THEN
761:
762: IF l_debug_on THEN
763: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);
764: END IF;
765:
766: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
767: p_delivery_id => p_delivery_info.delivery_id,

Line 766: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

762: IF l_debug_on THEN
763: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);
764: END IF;
765:
766: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
767: p_delivery_id => p_delivery_info.delivery_id,
768: x_delivery_rec => l_delivery_info,
769: x_return_status => l_return_status);
770:

Line 772: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.get_delivery_information',l_return_status);

768: x_delivery_rec => l_delivery_info,
769: x_return_status => l_return_status);
770:
771: IF l_debug_on THEN
772: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.get_delivery_information',l_return_status);
773: END IF;
774:
775: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
776: IF l_debug_on THEN

Line 777: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');

773: END IF;
774:
775: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
776: IF l_debug_on THEN
777: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
778: END IF;
779: RAISE api_return_fail;
780: END IF;
781:

Line 1331: wsh_delivery_validations.check_delete_delivery(

1327: WSH_DEBUG_SV.log(l_module_name,'l_delivery_id',l_delivery_id);
1328: END IF;
1329:
1330: IF (p_validate_flag = 'Y') THEN
1331: wsh_delivery_validations.check_delete_delivery(
1332: p_delivery_id => l_delivery_id,
1333: x_return_status => l_return_status);
1334: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1335: RAISE cannot_delete_delivery;

Line 3523: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

3519: l_new_tms_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
3520: l_new_tms_version_number_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3521: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3522: l_trip_not_found VARCHAR2(1);
3523: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
3524: i NUMBER;
3525: l_count NUMBER;
3526: l_gc3_is_installed VARCHAR2(1);
3527: RECORD_LOCKED EXCEPTION;

Line 3582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',WSH_DEBUG_SV.C_PROC_LEVEL);

3578: l_trip_not_found := 'N';
3579:
3580: --get trip information for delivery, no update when trip not OPEN
3581: IF l_debug_on THEN
3582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',WSH_DEBUG_SV.C_PROC_LEVEL);
3583: END IF;
3584: WSH_DELIVERY_VALIDATIONS.get_trip_information
3585: (p_delivery_id => p_delivery_id_tab(i),
3586: x_trip_info_rec => l_trip_info_rec,

Line 3584: WSH_DELIVERY_VALIDATIONS.get_trip_information

3580: --get trip information for delivery, no update when trip not OPEN
3581: IF l_debug_on THEN
3582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',WSH_DEBUG_SV.C_PROC_LEVEL);
3583: END IF;
3584: WSH_DELIVERY_VALIDATIONS.get_trip_information
3585: (p_delivery_id => p_delivery_id_tab(i),
3586: x_trip_info_rec => l_trip_info_rec,
3587: x_return_status => l_return_status);
3588:

Line 3590: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',l_return_status);

3586: x_trip_info_rec => l_trip_info_rec,
3587: x_return_status => l_return_status);
3588:
3589: IF l_debug_on THEN
3590: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',l_return_status);
3591: END IF;
3592:
3593: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3594: IF l_debug_on THEN

Line 3613: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);

3609: --Bug 7408338 Trip in status 'In-Transit' should also get processed.
3610: IF (l_trip_info_rec.status_code IN ('OP','IT','CL') OR l_trip_not_found = 'Y') THEN
3611:
3612: IF l_debug_on THEN
3613: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);
3614: END IF;
3615:
3616: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
3617: p_delivery_id => p_delivery_id_tab(i),

Line 3616: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

3612: IF l_debug_on THEN
3613: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);
3614: END IF;
3615:
3616: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
3617: p_delivery_id => p_delivery_id_tab(i),
3618: x_delivery_rec => l_delivery_info,
3619: x_return_status => l_return_status);
3620:

Line 3622: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.get_delivery_information',l_return_status);

3618: x_delivery_rec => l_delivery_info,
3619: x_return_status => l_return_status);
3620:
3621: IF l_debug_on THEN
3622: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.get_delivery_information',l_return_status);
3623: END IF;
3624:
3625: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3626: IF l_debug_on THEN