Here's an example of 1 of the queries...

SELECT ltrim(to_char(NVL(SUM(sc.haul_cost),0),'0999999.99')) INTO l_bol_line_haul
FROM fp_so_cost sc
, fp_shipment_order so
WHERE so.cost_key = sc.cost_key
AND sc.cost_type = 'I'
AND so.load_id = bol_rec.inv_bol;

Is there anything I can do before or after executing this SQL stmt that will help me know if there has been any SQL errors during execution?