-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Oracle E-Business Suite R12 Core Development and Extension Cookbook
By :

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 statement
Add a warning message
Test the validation
Stop any further processing
Check a database value against a form value
We are going to create a lookup that we can use to store valid strings that we will look for in the e-mail address...
Change the font size
Change margin width
Change background colour