Do not use deprecated `SourceFileLoader.load_module()` in dynamic module loading
Author: XuehaiPan
Pull request: yes

# What does this PR do?

<!--
Congratulations! You've made it this far! You're not quite done yet though.

Once merged, your PR is going to appear in the release notes with the title you set, so make sure it's a great title that fully reflects the extent of your awesome contribution.

Then, please replace this with a description of the change and which issue is fixed (if applicable). Please also include relevant motivation and context. List any dependencies (if any) that are required for this change.

Once you're done, someone will review your PR shortly (see the section "Who can review?" below to tag some potential reviewers). They may suggest changes to make the code even better. If no one reviewed your PR after a week has passed, don't hesitate to post a new comment @-mentioning the same persons---sometimes notifications get lost.
-->

<!-- Remove if not applicable -->

Remove deprecated [`SourceFileLoader.load_module()`](https://docs.python.org/3/library/importlib.html#importlib.abc.Loader.load_module) in dynamic module loading. Replace it with [`exec_module()`](https://docs.python.org/3/library/importlib.html#importlib.abc.Loader.exec_module).

https://github.com/python/cpython/blob/e3671ead9419c7afab6a4e501ade86bc9bc10950/Lib/importlib/_bootstrap_external.py#L1166-L1176

```python
    @_check_name
    def load_module(self, fullname):
        """Load a module from a file.


        This method is deprecated.  Use exec_module() instead.


        """
        # The only reason for this method is for the name check.
        # Issue #14857: Avoid the zero-argument form of super so the implementation
        # of that form can be updated without breaking the frozen module.
        return super(FileLoader, self).load_module(fullname)
```

> `load_module(fullname)`
>
> Deprecated since version 3.4: The recommended API for loading a module is [exec_module()](https://docs.python.org/3/library/importlib.html#importlib.abc.Loader.exec_module) (and [create_module()](https://docs.python.org/3/library/importlib.html#importlib.abc.Loader.create_module)). Loaders should implement it instead of [load_module()](https://docs.python.org/3/library/importlib.html#importlib.abc.Loader.load_module). The import machinery takes care of all the other responsibilities of [load_module()](https://docs.python.org/3/library/importlib.html#importlib.abc.Loader.load_module) when [exec_module()](https://docs.python.org/3/library/importlib.html#importlib.abc.Loader.exec_module) is implemented.

## Before submitting
- [ ] This PR fixes a typo or improves the docs (you can dismiss the other checks if that's the case).
- [X] Did you read the [contributor guideline](https://github.com/huggingface/transformers/blob/main/CONTRIBUTING.md#create-a-pull-request),
      Pull Request section?
- [ ] Was this discussed/approved via a Github issue or the [forum](https://discuss.huggingface.co/)? Please add a link
      to it if that's the case.
- [ ] Did you make sure to update the documentation with your changes? Here are the
      [documentation guidelines](https://github.com/huggingface/transformers/tree/main/docs), and
      [here are tips on formatting docstrings](https://github.com/huggingface/transformers/tree/main/docs#writing-source-documentation).
- [ ] Did you write any new necessary tests?


## Who can review?

Anyone in the community is free to review the PR once the tests have passed. Feel free to tag
members/contributors who may be interested in your PR.

<!-- Your PR will be replied to more quickly if you can figure out the right person to tag with @

 If you know how to use git blame, that is the easiest way, otherwise, here is a rough guide of **who to tag**.
 Please tag fewer than 3 people.

Models:

- text models: @ArthurZucker and @younesbelkada
- vision models: @amyeroberts
- speech models: @sanchit-gandhi
- graph models: @clefourrier

Library:

- flax: @sanchit-gandhi
- generate: @gante
- pipelines: @Narsil
- tensorflow: @gante and @Rocketknight1
- tokenizers: @ArthurZucker
- trainer: @muellerzr and @pacman100

Integrations:

- deepspeed: HF Trainer/Accelerate: @pacman100
- ray/raytune: @richardliaw, @amogkam
- Big Model Inference: @SunMarc
- quantization (bitsandbytes, autogpt): @SunMarc and @younesbelkada

Documentation: @stevhliu and @MKhalusova

HF projects:

- accelerate: [different repo](https://github.com/huggingface/accelerate)
- datasets: [different repo](https://github.com/huggingface/datasets)
- diffusers: [different repo](https://github.com/huggingface/diffusers)
- rust tokenizers: [different repo](https://github.com/huggingface/tokenizers)

Maintained examples (not research project or legacy):

- Flax: @sanchit-gandhi
- PyTorch: See Models above and tag the person corresponding to the modality of the example.
- TensorFlow: @Rocketknight1

 -->


Comments:
cc @ydshieh 

Hi @XuehaiPan  Thank you for opening this PR ❤️ .

Overall LGTM, but there is one test failing

> tests/models/auto/test_modeling_auto.py::AutoModelTest::test_from_pretrained_dynamic_model_with_period

Could you check if it pass on `main` and if so why it starts to fail on this PR?

Hi @ydshieh, I have fixed the test error.

Thanks! CI is green. I will check !

Ah, thank you for the quick action ❤️ . I was thinking probably better not to bother you further 

The docs for this PR live [here](https://moon-ci-docs.huggingface.co/docs/transformers/pr_30370). All of your documentation changes will be reflected on that endpoint. The docs are available until 30 days after the last update.