3 Replies Latest reply on Aug 22, 2013 12:24 PM by Vigneswar Battu

    SSRM Absence Management - User Hook Issue

    984260

      Hello,

       

      We have implemented Leave Management in Oracle HR. Employees apply leave through self service and there are different validations that needs to perform before submitting the absence.

      We have did below steps:


      1. Found the API_HOOK_ID, api_module_id, package & procedure as follows:
      3839     1731     HR_PERSON_ABSENCE_BK1     CREATE_PERSON_ABSENCE_B

      2. Created a custom package for validations, which is working absolutely fine from backend validations as we have checked with p_person_id, p_date_start, p_date_end

      3. Linked the custom procedure with api_hook_id as follows:
      DECLARE
      l_api_hook_call_id NUMBER;
      l_object_version_number NUMBER;
      BEGIN
      hr_api_hook_call_api.create_api_hook_call
      (p_validate => FALSE,
      p_effective_date => TO_DATE('01-JAN-2013'),
      p_api_hook_id => 3839,
      p_api_hook_call_type => 'PP',
      p_sequence => 3000,
      p_enabled_flag => 'Y',
      p_call_package => 'XXHR_ABS_VALIDS',
      p_call_procedure => 'XXHR_ABS_MAIN',
      p_api_hook_call_id => l_api_hook_call_id,
      p_object_version_number => l_object_version_number
      );
      END;

      4. which created a record in HR_API_HOOK_CALLS with STATUS 'N'

      5. Ran pre-processor hrahkall.sql which completed successfully

      7. TESTED by going to SSHR Apply Leave page. It is NOT stopping the custom validation process.

       

      Please suggest if any step is missing or how to debug why custom package validation does not call.

       

      Regards,

      Aniruddha