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 591: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

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

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

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

Line 741: WSH_DELIVERY_VALIDATIONS.get_trip_information

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

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

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

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

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

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

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

Line 768: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

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

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

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

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

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

Line 1336: wsh_delivery_validations.check_delete_delivery(

1332: WSH_DEBUG_SV.log(l_module_name,'l_delivery_id',l_delivery_id);
1333: END IF;
1334:
1335: IF (p_validate_flag = 'Y') THEN
1336: wsh_delivery_validations.check_delete_delivery(
1337: p_delivery_id => l_delivery_id,
1338: x_return_status => l_return_status);
1339: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1340: RAISE cannot_delete_delivery;

Line 3547: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

3543: l_new_tms_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
3544: l_new_tms_version_number_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3545: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3546: l_trip_not_found VARCHAR2(1);
3547: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
3548: i NUMBER;
3549: l_count NUMBER;
3550: l_gc3_is_installed VARCHAR2(1);
3551: RECORD_LOCKED EXCEPTION;

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

3602: l_trip_not_found := 'N';
3603:
3604: --get trip information for delivery, no update when trip not OPEN
3605: IF l_debug_on THEN
3606: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',WSH_DEBUG_SV.C_PROC_LEVEL);
3607: END IF;
3608: WSH_DELIVERY_VALIDATIONS.get_trip_information
3609: (p_delivery_id => p_delivery_id_tab(i),
3610: x_trip_info_rec => l_trip_info_rec,

Line 3608: WSH_DELIVERY_VALIDATIONS.get_trip_information

3604: --get trip information for delivery, no update when trip not OPEN
3605: IF l_debug_on THEN
3606: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',WSH_DEBUG_SV.C_PROC_LEVEL);
3607: END IF;
3608: WSH_DELIVERY_VALIDATIONS.get_trip_information
3609: (p_delivery_id => p_delivery_id_tab(i),
3610: x_trip_info_rec => l_trip_info_rec,
3611: x_return_status => l_return_status);
3612:

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

3610: x_trip_info_rec => l_trip_info_rec,
3611: x_return_status => l_return_status);
3612:
3613: IF l_debug_on THEN
3614: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.GET_TRIP_INFORMATION',l_return_status);
3615: END IF;
3616:
3617: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3618: IF l_debug_on THEN

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

3633: --Bug 7408338 Trip in status 'In-Transit' should also get processed.
3634: IF (l_trip_info_rec.status_code IN ('OP','IT','CL') OR l_trip_not_found = 'Y') THEN
3635:
3636: IF l_debug_on THEN
3637: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);
3638: END IF;
3639:
3640: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
3641: p_delivery_id => p_delivery_id_tab(i),

Line 3640: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

3636: IF l_debug_on THEN
3637: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);
3638: END IF;
3639:
3640: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
3641: p_delivery_id => p_delivery_id_tab(i),
3642: x_delivery_rec => l_delivery_info,
3643: x_return_status => l_return_status);
3644:

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

3642: x_delivery_rec => l_delivery_info,
3643: x_return_status => l_return_status);
3644:
3645: IF l_debug_on THEN
3646: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_DELIVERY_VALIDATIONS.get_delivery_information',l_return_status);
3647: END IF;
3648:
3649: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3650: IF l_debug_on THEN