supplier site creation
Hi,
We are trying to create the supplier site using the API following is the code we have used but whenever we run the API it runs into error. Kindly provide us with pointers as to what we are doing wrong.
DECLARE
p_vendor_site_rec AP_VENDOR_PUB_PKG.r_vendor_site_rec_type;
x_return_status VARCHAR2(8);
x_msg_count NUMBER;
x_msg_data VARCHAR2(4000);
x_vendor_site_id NUMBER;
x_party_site_id NUMBER;
x_location_id NUMBER;
V_TERRITORY_CODE VARCHAR2(10);
V_VENDOR_ID NUMBER;
BEGIN
SELECT VENDOR_ID INTO V_VENDOR_ID FROM PO_VENDORS WHERE VENDOR_NAME='TEST_SUPPLIER_AFAQ';