Hello All,

I have got a scenario for which I need your help.

I am fetching and bulk collecting records into a pl/SQl table. Record Contains the following fields. As a sample, I have given the values of the fields:
--------------------------------------------------------------
Meta_:Product:Col1:Col2:Col3:Col4......:Col18:Region_Id:Status
--------------------------------------------------------------
 1   : PR001 : 5  :  5 : 5  : 5 .......: 5   : APAC    : Null
--------------------------------------------------------------

Here I need to do the following:
For every record, I need to validate the Product Column Value, All Col(1-18) Values and Region_Id VAlue. As part of validation, I have written relevant functions to validate Product, Col(1-18) and Region_Id.

Product validation will return me - Valid or Invalid
Col(1-18) validation will return me - Valid, Invalid, Null
Region_Id validation will return me - Valid, Invalid

Now, Question is - 

For every record, I need to validate Product,Col(1-18),Region_id and then push the records into exception table which are not valid

--------------------------------------------------------------
Meta_Info_Id:Product:Col1:Col2:Col4......:Col18:Region_Id:Status
--------------------------------------------------------------
      1     : PR001 : 5  :  5 : 5  : 5 .......: 5   : APAC:
--------------------------------------------------------------
Status column will have error message as - Product is null
                                           Col1 is invalid
                                           Col17 is null
                                           Col18 is invalid
Assuming that - Product column has some issue
              - Col1, Col17, Col17 has issues

Idea, on the above as how to proceed will help me a lot.