Delete record

Hello,

I have question about api_Datasource.deleterow.

I have grid, in the grid selected 10 records. On the delete button execute this code: decalre p_row_id number := api_Datasource.getcurrentrowid(p_ds); begin api_Datasource.deleterow(p_ds); api_Datasource.doCommit(p_ds); Exceptiom When othres then api_datasource.refreshrowbyid(p_ds,p_row_id); show error end; Is all ok this record deleted from DB and record from grid, but if record have child records i get error: "ORA-02292: integrity constraint (RPK.RPK_RPGT_RT_FK) violated - child record found" (I'm understand this error), after this error fire api_datasource.refreshrowbyid(p_ds,p_row_id), but record don't back to grid (i can't see on the grid). I see that record status (BDF_STATUS_CD=NULL).

What should I do, that record back to the grid ?
I can't make api_Datasource.executequery, because im using infinity scroll (100000 redords) and after failure delete i would like to put curosr to same record, which want delete.

Thanks