Trying to Inactivate Account Sites but not working

Hi All,

I'm trying to Inactivate account sites using below API but it is not working. please help or share any code/API you used to inactivate account sites.

"It says No customer account site was found for ID 1480261." but there are some active sites.

Thanks In Advance

CREATE OR REPLACE PROCEDURE APPS.xxpq_inactivate_cust_acct_site (   p_party_site_id      IN     VARCHAR2,   p_err_flag           OUT VARCHAR2,   p_err_msg            OUT VARCHAR2)   AS   l_cust_acct_site_rec      HZ_CUST_ACCOUNT_SITE_V2PUB.cust_acct_site_rec_type;   x_return_status           VARCHAR2 (2000);   x_msg_count               NUMBER;   x_msg_data                VARCHAR2 (2000);   --l_SITE_USE_ID              NUMBER;   l_cust_acct_site_id        NUMBER;   l_object_version_number   NUMBER;    BEGIN   p_err_flag := 'N';   p_err_msg := NULL;      BEGIN    select  cust_acct_site_id,object_version_number    INTO    l_cust_acct_site_id,l_object_version_number   FROM    apps.hz_cust_acct_sites_all where party_site_id= 1870882;   EXCEPTION   WHEN OTHERS      THEN         p_err_flag := 'E';         p_err_msg :=               'Error in getting Account Site id for Account number:'            ||  p_party_site_id            || ':'            || SQLERRM;         apps.fnd_file.put_line (            apps.fnd_file.LOG,               'Error in getting Account Site id for Account number:'            ||  p_party_site_id            || ':'            || SQLERRM);         DBMS_OUTPUT.put_line (               'Error in getting Account