APPS.WSH_TMS_RELEASE dependencies on WMS_DOCK_APPOINTMENTS_PUB

Line 1025: l_dock_appt_tab WMS_DOCK_APPOINTMENTS_PUB.DOCKAPPTTABTYPE;

1021:
1022: l_lock_rec c_lock_trip_interface%ROWTYPE;
1023:
1024: -- bug 6700792: OTM Dock Door App Sched Proj
1025: l_dock_appt_tab WMS_DOCK_APPOINTMENTS_PUB.DOCKAPPTTABTYPE;
1026: l_dock_appt_index NUMBER;
1027: --
1028:
1029: l_trip_info_rec tms_trip_rec_type;

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

3652: l_message VARCHAR2(2000);
3653: BEGIN
3654: IF (l_dock_appt_tab.COUNT > 0) THEN --{
3655: IF l_debug_on THEN
3656: WSH_DEBUG_SV.log(l_module_name, 'Calling wms_dock_appointments_pub.OTM_Dock_Appointment',WSH_DEBUG_SV.C_PROC_LEVEL);
3657: END IF;
3658: -- Calling the WMS API with the Dock Door App Sched Info.
3659: wms_dock_appointments_pub.OTM_Dock_Appointment(p_dock_appt_tab => l_dock_appt_tab,
3660: x_return_status => l_rs,

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

3655: IF l_debug_on THEN
3656: WSH_DEBUG_SV.log(l_module_name, 'Calling wms_dock_appointments_pub.OTM_Dock_Appointment',WSH_DEBUG_SV.C_PROC_LEVEL);
3657: END IF;
3658: -- Calling the WMS API with the Dock Door App Sched Info.
3659: wms_dock_appointments_pub.OTM_Dock_Appointment(p_dock_appt_tab => l_dock_appt_tab,
3660: x_return_status => l_rs,
3661: x_msg_count => l_msg_count,
3662: x_msg_data => l_msg_data);
3663: IF l_debug_on THEN

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

3660: x_return_status => l_rs,
3661: x_msg_count => l_msg_count,
3662: x_msg_data => l_msg_data);
3663: IF l_debug_on THEN
3664: WSH_DEBUG_SV.log(l_module_name, 'wms_dock_appointments_pub.OTM_Dock_Appointment: Return Status', l_rs);
3665: END IF;
3666: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3667: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3668: FOR l_err_msg IN 1..l_msg_count LOOP

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

3681: EXCEPTION
3682: WHEN OTHERS THEN
3683: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3684: IF l_debug_on THEN
3685: WSH_DEBUG_SV.log(l_module_name, 'Error while calling wms_dock_appointments_pub.OTM_Dock_Appointment' || SQLERRM);
3686: END IF;
3687: GOTO trip_error;
3688: END;
3689: --