API – Customer Additional Information (Price List , Payment Terms ,Sales Type )

CREATE OR REPLACE procedure APPS.XX_CUSTOMER_ADDITIONAL_LOAD
IS
p_cust_site_use_rec  HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE;
x_return_status      VARCHAR2(2000);
x_msg_count          NUMBER;
xio_p_object_version NUMBER;
x_msg_data           VARCHAR2(2000);
v_site_use_id        NUMBER;
V_OBJECT_VERSION     NUMBER;
BEGIN

--    FND_GLOBAL.APPS_INITIALIZE(<user_id>,<resp_id>,<resp_applicarion_id>);
--    MO_GLOBAL.INIT('AR');
--    MO_GLOBAL.SET_POLICY_CONTEXT('S', <org_id>);
     FND_GLOBAL.APPS_INITIALIZE(1535,50930,222);
     MO_GLOBAL.INIT('AR');
     MO_GLOBAL.SET_POLICY_CONTEXT('S', 1210);   
     BEGIN
            SELECT  HCSU.SITE_USE_ID,
                    HCSU.OBJECT_VERSION_NUMBER
            INTO    V_SITE_USE_ID,
                    V_OBJECT_VERSION
            FROM    HZ_PARTIES HP,
                    HZ_PARTY_SITES HPS,
                    HZ_CUST_ACCT_SITES_ALL HCAS,
                    HZ_CUST_SITE_USES_ALL HCSU
            WHERE   HP.PARTY_ID = HPS.PARTY_ID
            AND     HPS.PARTY_SITE_ID = HCAS.PARTY_SITE_ID
            AND     HCAS.CUST_ACCT_SITE_ID =HCSU.CUST_ACCT_SITE_ID
            AND     HCSU.SITE_USE_CODE = 'BILL_TO'
            AND     ltrim(rtrim(upper(HP.PARTY_NAME)))= ltrim(rtrim(upper('SSE Test Customer')));
     EXCEPTION WHEN OTHERS THEN
            DBMS_OUTPUT.PUT_LINE('ERROR IS'||SUBSTR(SQLERRM,1,150));            
     END;
   
     p_cust_site_use_rec.site_use_id:=  V_SITE_USE_ID;             -- Site USe to be updated
     xio_p_object_version           :=  V_OBJECT_VERSION;          --xio_p_object_version := 1;
     p_cust_site_use_rec.price_list_id   := 98202;              -- SSE Standard
     p_cust_site_use_rec.payment_term_id := 1000 ;              -- 90 Days
     p_cust_site_use_rec.order_type_id   := 1193;               --SSE Duabi Showroom Cash Sales
     hz_cust_account_site_v2pub.update_cust_site_use(
                                                    'T',
                                                    p_cust_site_use_rec,
                                                    xio_p_object_version,
                                                    x_return_status,
                                                    x_msg_count,
                                                    x_msg_data);


    dbms_output.put_line('***************************');
    dbms_output.put_line('Output information ....');
    dbms_output.put_line('x_return_status: '||x_return_status);
    dbms_output.put_line('x_msg_count: '||x_msg_count);
    dbms_output.put_line('xio_p_object_version: '||xio_p_object_version);
    dbms_output.put_line('x_msg_data: '||x_msg_data);
    dbms_output.put_line('***************************');    
    COMMIT;
END;
/