948611 wrote:Hi, Siva
I have a multi block child record. In that there are series of columns ....say column 1 to 6.
I am validating these columns against certain values and if the validation fails , I am raising when form trigger failure
I am doing this at the when validate record of the block level.
values := VARCHAR2 (1000) ;
values := :b1.c1||:b1.c2||:b1.c3||:b1.c4||:b1.c5||:b1.c6;
validation_flag = 'N'
1) What should be the appropriate to handle this since this validation should happen if all the six segments are entered.
There is no particular order in which the six segments are entered.
Dont think when validate record s the correct one.
2) As a work around, this message is being thrown after the user tries to save the record but he is able to navigate to the next record when he presses a down error. This shouldnt happen if the user wants to save the data.
the above are the 2 options we are considering
Please provide your poitners.