ADD Supplier_site_code

Dear All,

i'm trying to add a supplier_site using API,

i created the procedure & it run with no error:

procedure:

Create or replace PROCEDURE  XX_create_supplier_site_api (nb in number) IS

l_vendor_site_rec     ap_vendor_pub_pkg.r_vendor_site_rec_type;

lc_return_status        VARCHAR2(10);

ln_msg_count            NUMBER;

lc_msg_data             VARCHAR2(1000);

ln_vendor_site_id       NUMBER;

ln_party_site_id        NUMBER;

ln_location_id          NUMBER;

vendor_id               ap_suppliers.vendor_id%type;

BEGIN

        -- Required 

        l_vendor_site_rec.vendor_id             := 471176;

-- this is the vendor_id that ive insert.

        l_vendor_site_rec.vendor_site_code      := 'Supplier_SiteEE';