Add deb822 format ppa support on Ubuntu 24.04

[brunoleon]

Summary

New repo added using add-apt-repository command have a .sources extension (used to be .list) Without this update, add-apt-repository keeps being called for ppa repo on each Puppet run because if does not look for .sources files

Additional Context

This only covers repo adde using add-apt-repository command

Related Issues (if any)

Mention any related issues or pull requests.

Checklist

• [ ] 🟢 Spec tests.
• [ ] 🟢 Acceptance tests.
• [x] Manually verified. (For example puppet apply)

[kenyon]

Duplicate of #1169.

[brunoleon]

Sorry I missed #1169 indeed