CREATE OR REPLACE procedure APPS.xxaj_site_use_status
isx_return_status varchar2(10);
x_msg_count number(10);
x_msg_data varchar2(1200);
p_object_version_number number(10):=4;
P_CUST_SITE_USE_REC hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
begin
--Apps Initialization
FND_GLOBAL.APPS_INITIALIZE (
USER_ID => 1318,
RESP_ID => 50583,
RESP_APPL_ID => 401
);
P_CUST_SITE_USE_REC.site_use_id:=4126;
P_CUST_SITE_USE_REC.status:= 'A';
P_CUST_SITE_USE_REC.cust_acct_site_id :=3995;
P_CUST_SITE_USE_REC.SITE_USE_CODE := 'BILL_TO';
P_CUST_SITE_USE_REC.CREATED_BY_MODULE := 'TCA_V2_API';
hz_cust_account_site_v2pub.update_cust_site_use
(
p_init_msg_list => 'T',
P_CUST_SITE_USE_REC => P_CUST_SITE_USE_REC,
p_object_version_number => p_object_version_number,
x_return_status => x_return_status,
x_msg_count => x_msg_count ,
x_msg_data => x_msg_data
);
IF x_return_status = 'S' THEN
dbms_output.put_line(' Now site use is active' );
ELSE
IF NVL (x_msg_count, 0) > 1 THEN
FOR i IN 1 .. x_msg_count LOOP
dbms_output.put_line(' Error Status ' ||x_return_status);
dbms_output.put_line(' Error message ' ||x_msg_data);
END LOOP;
ELSE
dbms_output.put_line(' Error message ' ||x_msg_data);
END IF;
END IF;
commit;
exception when others then
dbms_output.put_line(' Error Here'||sqlcode||sqlerrm);
end;
/
SQL> EXEC xxaj_site_use_status;
No comments:
Post a Comment