How to restrict invoice number to exactly 10 characters through form personalization in oracle apps

1.2k Views Asked by At

My requirement is when the draft invoice is approved release button is enabled in release block we can enter invoice number. I need to restrict the invoice number exactly equal to 10 digits. If the user enters invoice number less than or greater than 10 I need to show error. Every thing is working fine but the problem is suppose for example if user enters invoice number less than 10 characters and presses ok error is shown and if user clicks cancel button after that. The release block is closed and the invoice status is changed to released and invoice number will be the number which is given by user, but my requirement is suppose user clicks cancel after pressing ok button the invoice status should not change to released.

I am using when-validate-record trigger for release block and in condition checking whether length of invoice_number is 10 and based on that showing error.

0

There are 0 best solutions below