APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on WSH_LOCATIONS

Line 3216: FROM wsh_locations

3212: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INTERFACE_DETAIL_TO_INV';
3213:
3214: CURSOR c_convert_locId (v_location_id NUMBER) IS
3215: SELECT source_location_id
3216: FROM wsh_locations
3217: WHERE wsh_location_id = v_location_id;
3218:
3219: --HVOP heali
3220: l_mtl_txn_if_rec Mtl_txn_if_rec_type;

Line 3929: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program WSH_LOCATIONS_PKG.Get_Intransit_Time');

3925: ELSIF ( l_mtl_txn_if_rec.ship_method_code(l_index) IS NOT NULL )
3926: THEN
3927:
3928: IF l_debug_on THEN
3929: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program WSH_LOCATIONS_PKG.Get_Intransit_Time');
3930: END IF;
3931:
3932: OPEN get_session_id;
3933: FETCH get_session_id INTO l_session_id;

Line 3954: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returned from WSH_LOCATIONS_PKG.Get_Intransit_Time');

3950: x_return_status := l_return_status;
3951:
3952: IF l_debug_on THEN
3953: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
3954: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returned from WSH_LOCATIONS_PKG.Get_Intransit_Time');
3955: WSH_DEBUG_SV.pop(l_module_name);
3956: END IF;
3957:
3958: RETURN;