Oracle E-Business Suite R12 Core Development and Extension Cookbook

Performing complex validation

We are now going to perform some more advanced validation. The scenario is that we need to check that the e-mail address entered for the employee belongs to a specific domain. We are going to validate this by checking the domain of an e-mail address to ensure that it contains a specified string. First we are going to create a lookup that will contain valid strings that we will check for in our personalization. Then we will create a database function that will check the e-mail address on a WHEN-VALIDATE-RECORD trigger. If the string does not exist in the e-mail address, then a warning message will be displayed. So we are going to perform the following tasks:

• Create a lookup
• Call a database function from a condition ...