[EBS - AP] Pop up message on new line added or discarded on an old invoice

Hello gurus,

For my customer I'm asked to create a customization that would generate a warning message when they are entering or deleting an invoice line on an invoice booked on a previous accounting year.

My current approach is to compare the new line record GL date with the invoice header gl date and display the message when line gl date is superior to invoice gl date

trigger event : WHEN-NEW-RECORD-INSTANCE

trigger object : LINE_SUM_FOLDER

condition : (to_char(:INV_SUM_FOLDER.GL_DATE, 'YYYY') < to_char(sysdate,'YYYY'))

Processing mode : Not in Enter-Query Mode

The warning message is displayed when entering and navigating within the Lines tab