title: Can I put a validation on an Interactive Grid row deletion?
body: <p>I'm trying to add a validation on an Interactive Grid, basically to check to see if anything is dependent on the row, so I can display a user friendly error instead of "Ajax call returned server error ORA-20987: APEX - ORA-02292: integrity constraint (FOO.MY_CONSTRAINT)...", but validations always seem to be skipped for deleted rows. Am I doing something wrong? I'm using Apex 5.1.2.</p>
  
  <p>To test, I created a validation on the Interactive Grid, Type = No Rows Returned, SQL Query = SELECT 1 FROM dual WHERE :APEX$ROW_STATUS = 'D'. I would expect this would prevent any row from being deleted. Instead, the validation is always skipped. The debug log looks like this:</p>
  
  <pre><code>Perform custom validations:
  ...Validation "New" - Type: NOT_EXISTS
  ......Skip for row 1 because "Row Status" is "Deleted"
  </code></pre>
  
  <p>I've tried changing the type of the validation, setting Always Execute to Yes, using a scope of either All Submitted Rows and Created and Modified rows, but no luck.</p>
  
  <p>I've created a demo here: <a href="https://apex.oracle.com/pls/apex/f?p=62159:10" rel="nofollow noreferrer">https://apex.oracle.com/pls/apex/f?p=62159:10</a></p>