Error while trying to create "Supplier" using API AP_VENDOR_PUB_PKG

Hi,

We are using R12.2.9 and trying to create supplier by using API.

I have tried to call the API AP_VENDOR_PUB_PKG.create_vendor or pos_vendor_pub.Create_Vendor for creating a supplier but always failed with 36 errors. Please advise if anyone has idea how to resolve it.

If I login with same responsibility and user in system, I can create the supplier without any issue. However, I cannot do it by calling the API. However, I tried to update the Vendor API is work fine but just not work for create vendor API.

Here is the error after running the attached Create Vendor API in sql/develoepr.