2262: END IF;
2263: END LOOP;
2264: COMMIT;
2265:
2266: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Records processed: ' || l_count);
2267:
2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in filling geometry column: ' || SQLERRM);
2266: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Records processed: ' || l_count);
2267:
2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in filling geometry column: ' || SQLERRM);
2271:
2272: END fill_geometry_for_locations;
2273: /*----------------------------------------------------------------------------*
2274: | procedure |