1 Reply Latest reply on Dec 20, 2008 12:28 PM by 578444

    PurchasingOrder Change API(update_po) no result.

    663404
      Hi all,

      I used the following pl/sql block with the api PO_CHANGE_API1_S.UPDATE_PO but I dont find any result's in the base table ie po_headers_all and po_lines_all. Could any one explain as to what the API is doing and where to check the output. I know the API is updating the po 4443 but where to check the output. When I run the block the the return
      RESULT is 0 which indicates the procedure executed without any errors.

      Please help.


      set serveroutput on;
      declare
      result number := null;
      X_API_ERRORS_MSG PO_API_ERRORS_REC_TYPE;
      BEGIN
      result := PO_CHANGE_API1_S.update_po(
      X_PO_NUMBER =>'4443',
      X_RELEASE_NUMBER =>0,
      X_REVISION_NUMBER =>0,
      X_LINE_NUMBER =>1,
      X_SHIPMENT_NUMBER =>1,
      NEW_QUANTITY =>50,
      NEW_PRICE =>NULL,
      NEW_PROMISED_DATE =>NULL,
      LAUNCH_APPROVALS_FLAG =>'Y',
      UPDATE_SOURCE =>NULL,
      VERSION =>'1.0',
      X_OVERRIDE_DATE =>NULL,
      X_API_ERRORS =>X_API_ERRORS_MSG,
      P_BUYER_NAME => NULL
      );
      dbms_output.put_line('result:'||result);
      EXCEPTION
      WHEN OTHERS THEN
      raise;
      end;
      /
        • 1. Re: PurchasingOrder Change API(update_po) no result.
          578444
          Hi,

          Please use the fnd_global.apps_intialize to set your environment setup. FND_GLOBAL.apps_initialize (User_id,responsibility_id,application_id).
          If the result is 1, then the API has successfully updated the document, if the result is 0, then the API has not updated properly.

          If you want to find out the error you can take the help of the x_api_errors parameter.

          Please let me know if you are still facing any issue.

          Regards,
          Jyoti