199: BEGIN
200:
201: SELECT transaction_error_id
202: INTO l_error_id
203: FROM csi_txn_errors
204: WHERE source_type = 'CSEFATIE'
205: AND source_id = l_error_rec.source_id
206: AND rownum < 2;
207:
204: WHERE source_type = 'CSEFATIE'
205: AND source_id = l_error_rec.source_id
206: AND rownum < 2;
207:
208: UPDATE csi_txn_errors
209: SET error_text = l_error_rec.error_text,
210: last_updated_by = fnd_global.user_id,
211: last_update_login = fnd_global.login_id,
212: last_update_date = sysdate