6 Replies Latest reply on Sep 20, 2010 6:16 PM by 730520

    Web ADI - How to return an error with a custom integrator

    763921
      Hey guys Iam facing problem when returning pkg exceptions to the web adi

      Scenario:
      We have temporary table where we upload the excel sheet data.
      After rows get uploaded through web ADI excel sheet, we call the pkg to process the data. Even if error or exception ocurred in pkg , the web adi after completion shows rows successfully processed.

      I have added the code like-
      begin
      SELECT action_type,quote_header_id into v_action_type,v_quote_header_id
      FROM quotes_upd_intf
      WHERE batch_id = p_batch_id AND ROWNUM < 2;

      select max_version_flag into v_max_version_flag
      from aso_quote_headers_all
      where
      quote_header_id=v_quote_header_id;


      if v_max_version_flag= 'Y' then


      If v_action_type ='U' then


      update_quote(p_batch_id);


      elsif v_action_type = 'C' then


      create_quote_version(p_batch_id);


      end if;
      else
      FND_MESSAGE.CLEAR;
      FND_MESSAGE.SET_NAME('BNE','WEBADI_ERROR');
      FND_MESSAGE.SET_TOKEN('MSG','Error');



      end if;
      END;

      This is my setup:
      Name: WEBADI_ERROR
      Language: US
      Application: Web Applications Desktop Integrator
      Type: 30% Expansion Prompt
      Current Message Text: &MSG


      But this code is not working. It not returns any error msg to excel webadi sheet.
      what would be the problem
      Please help me. its very urgent

      Thanks
      Uday