Add self_managed add_on_purchase trait

What does this MR do and why?

• In this MR we are introducing a trait for self-managed add_on_purchase
• This is a follow-up on !139539 (comment 1691600822)

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.