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.
set serveroutput on;
result number := null;
result := PO_CHANGE_API1_S.update_po(
P_BUYER_NAME => NULL
WHEN OTHERS THEN
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.