ora-6510 ora-6512 ora-1403 errors

[DaPi]

SELECT request_id INTO l_request_id
FROM table_B
WHERE request_id = cr.request_id;
if l_request_id is NULL

This does not do what you want (I think) - it will raise a no_data_found exception if the row doesn't exist.