API to Create Default Job Posting

DECLARE
   l_position_id             NUMBER (15) := NULL;
   l_brief_description       VARCHAR2 (2000) := 'Enter Job Description';
   l_detailed_description VARCHAR2 (2000)  := 'Enter Job Detailed Description' ;
   l_job_requirements        VARCHAR2 (2000) := 'Enter Job Requirements';
   l_additional_details      VARCHAR2 (2000) := NULL;
   l_how_to_apply            VARCHAR2 (2000) := NULL;
   l_default_posting_id      NUMBER := NULL;
   l_object_version_number   NUMBER := NULL;
BEGIN
   -- get position id
   BEGIN
      SELECT   hapf.position_id
        INTO   l_position_id
        FROM   hr_all_positions_f hapf
       WHERE   TRUNC (SYSDATE) BETWEEN hapf.effective_start_date
                                   AND  hapf.effective_end_date
               AND hapf.availability_status_id = 1
               AND hapf.name =
                     'GRAPHIC DESIGNER.P.HEALTH EDUCATION PORTAL (Sec) - F.08';
   EXCEPTION
      WHEN OTHERS
      THEN
         l_position_id := NULL;
   END;

   BEGIN
      irc_default_posting_api.create_default_posting (
         p_validate                => FALSE,
         p_language_code           => 'US',
         p_position_id             => l_position_id,
         p_job_id                  => NULL,
         p_org_name                => NULL,
         p_org_description         => NULL,
         p_job_title               => NULL,
         p_brief_description       => l_brief_description,
         p_detailed_description    => l_detailed_description,
         p_job_requirements        => l_job_requirements,
         p_additional_details      => l_additional_details,
         p_how_to_apply            => l_how_to_apply,
         p_default_posting_id      => l_default_posting_id,
         p_object_version_number   => l_object_version_number
      );
      DBMS_OUTPUT.put_line ('Success : ' || l_default_posting_id);
   EXCEPTION
      WHEN OTHERS
      THEN
         DBMS_OUTPUT.put_line ('API Error: ' || SQLERRM);
   END;
EXCEPTION
   WHEN OTHERS
   THEN
      DBMS_OUTPUT.put_line ('Main Exception: ' || SQLERRM);
END;