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 ...

Get Oracle E-Business Suite R12 Core Development and Extension Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.