API to Load Location in Arabic

DECLARE

   CURSOR c1

   IS

      SELECT *

        FROM hr_locations_all

       WHERE UPPER (location_code) = 'AL MUBARAKA';

BEGIN

   FOR i IN c1

   LOOP

      BEGIN

         HR_LOT_UPD.upd_tl (p_language_code   => 'AR',

                            p_location_id     => i.location_id,

                            p_location_code   => 'آل آمي',

                            p_description     => 'آل آمي');

         COMMIT;

         DBMS_OUTPUT.put_line ('Location Loaded in Arabic !!!');

      EXCEPTION

         WHEN OTHERS

         THEN

            DBMS_OUTPUT.put_line (location_id || ' - ' || SQLERRM);

      END;

   END LOOP;

EXCEPTION

   WHEN OTHERS

   THEN

      DBMS_OUTPUT.put_line ('Main Exception: ' || SQLERRM);

END;