1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Approved supplier list creation through api in r12

Discussion in 'Oracle Apps Technical' started by Dilip Nomula, Dec 29, 2015.

  1. Dilip Nomula

    Dilip Nomula Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Hyderabad
    Hi Friends,

    I have a requirement to assign ASL to the Item in R12!

    I am using the following API to assign the ASL to the item, i am facing the error saying as shown below -

    declare
    l_interface_header number:=0;
    l_interface_line number:=0;
    begin
    select PO_HEADERS_INTERFACE_S.NEXTVAL into l_interface_header from dual;
    select po_lines_interface_s.nextval into l_interface_line from dual;
    PO_APPROVED_SUPPLIER_LIST_SV.CREATE_PO_ASL_ENTRIES(X_INTERFACE_HEADER_ID => 2707128,
    X_INTERFACE_LINE_ID => 2757477,
    X_ITEM_ID => 1370405,
    X_CATEGORY_ID => NULL,
    X_PO_HEADER_ID => NULL,
    X_PO_LINE_ID => NULL,
    X_DOCUMENT_TYPE => NULL,
    X_VENDOR_SITE_ID => 43470,
    X_REL_GEN_METHOD => NULL,
    X_ASL_ORG_ID => 6,
    X_HEADER_PROCESSABLE_FLAG => PO_INTERFACE_ERRORS_SV1.handle_interface_errors,
    X_PO_INTERFACE_ERROR_CODE => 'ASLTEST',
    p_sourcing_level => NULL);
    end;
    /

    ERROR at line 17:
    ORA-06550: line 17, column 71:
    PLS-00306: wrong number or types of arguments in call to
    'HANDLE_INTERFACE_ERRORS'
    ORA-06550: line 7, column 1:
    PL/SQL: Statement ignored

    Pls help, how to handle this error!
     
  2. anasazii

    anasazii Starter

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    US
    Hi Dilip,

    I don't think that is the correct API to call to work with the ASL programmatically, or at least one that is supported by Oracle. Look into note 1613320.1 on My Oracle Support - Oracle Purchasing - API to Create, Update and Delete Approved Supplier List. The API (PO_ASL_API_PUB) is available with patch 18493909.