APPS.WSH_TMS_RELEASE dependencies on WMS_DOCK_APPOINTMENTS_PUB

Line 1018: l_dock_appt_tab WMS_DOCK_APPOINTMENTS_PUB.DOCKAPPTTABTYPE;

1014:
1015: l_lock_rec c_lock_trip_interface%ROWTYPE;
1016:
1017: -- bug 6700792: OTM Dock Door App Sched Proj
1018: l_dock_appt_tab WMS_DOCK_APPOINTMENTS_PUB.DOCKAPPTTABTYPE;
1019: l_dock_appt_index NUMBER;
1020: --
1021:
1022: l_trip_info_rec tms_trip_rec_type;

Line 3648: WSH_DEBUG_SV.log(l_module_name, 'Calling wms_dock_appointments_pub.OTM_Dock_Appointment',WSH_DEBUG_SV.C_PROC_LEVEL);

3644: l_message VARCHAR2(2000);
3645: BEGIN
3646: IF (l_dock_appt_tab.COUNT > 0) THEN --{
3647: IF l_debug_on THEN
3648: WSH_DEBUG_SV.log(l_module_name, 'Calling wms_dock_appointments_pub.OTM_Dock_Appointment',WSH_DEBUG_SV.C_PROC_LEVEL);
3649: END IF;
3650: -- Calling the WMS API with the Dock Door App Sched Info.
3651: wms_dock_appointments_pub.OTM_Dock_Appointment(p_dock_appt_tab => l_dock_appt_tab,
3652: x_return_status => l_rs,

Line 3651: wms_dock_appointments_pub.OTM_Dock_Appointment(p_dock_appt_tab => l_dock_appt_tab,

3647: IF l_debug_on THEN
3648: WSH_DEBUG_SV.log(l_module_name, 'Calling wms_dock_appointments_pub.OTM_Dock_Appointment',WSH_DEBUG_SV.C_PROC_LEVEL);
3649: END IF;
3650: -- Calling the WMS API with the Dock Door App Sched Info.
3651: wms_dock_appointments_pub.OTM_Dock_Appointment(p_dock_appt_tab => l_dock_appt_tab,
3652: x_return_status => l_rs,
3653: x_msg_count => l_msg_count,
3654: x_msg_data => l_msg_data);
3655: IF l_debug_on THEN

Line 3656: WSH_DEBUG_SV.log(l_module_name, 'wms_dock_appointments_pub.OTM_Dock_Appointment: Return Status', l_rs);

3652: x_return_status => l_rs,
3653: x_msg_count => l_msg_count,
3654: x_msg_data => l_msg_data);
3655: IF l_debug_on THEN
3656: WSH_DEBUG_SV.log(l_module_name, 'wms_dock_appointments_pub.OTM_Dock_Appointment: Return Status', l_rs);
3657: END IF;
3658: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3659: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3660: FOR l_err_msg IN 1..l_msg_count LOOP

Line 3677: WSH_DEBUG_SV.log(l_module_name, 'Error while calling wms_dock_appointments_pub.OTM_Dock_Appointment' || SQLERRM);

3673: EXCEPTION
3674: WHEN OTHERS THEN
3675: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3676: IF l_debug_on THEN
3677: WSH_DEBUG_SV.log(l_module_name, 'Error while calling wms_dock_appointments_pub.OTM_Dock_Appointment' || SQLERRM);
3678: END IF;
3679: GOTO trip_error;
3680: END;
3681: --