API – User Security Attribute Creation
declare
x_return_status VARCHAR2(2000);
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000);
x_vendor_site_id number;
begin
icx_user_sec_attr_pub.create_user_sec_attr(
p_api_version_number => 1,
p_return_status => x_return_status,
p_msg_count => x_msg_count,
p_msg_data => x_msg_data,
p_web_user_id => 1394,
p_attribute_code => ‘ICX_SUPPLIER_ORG_ID’,
p_attribute_appl_id => 177, —-iSupplier Portal
p_varchar2_value => ”,
p_date_value => ”,
p_number_value => 493, — Vendor_ID for ICX_SUPPLIER_ORG_ID’and Vendor_site_id for ICX_SUPPLIER_SITE_ID’ attribute code
p_created_by => -1,
p_creation_date => sysdate,
p_last_updated_by => -1,
p_last_update_date => sysdate,
p_last_update_login => -1);
if (x_return_status <> ‘S’) then
dbms_output.put_line(‘Encountered ERROR in Attribute Creation!!!’);
dbms_output.put_line(‘————————————–‘);
dbms_output.put_line(x_msg_data);
IF x_msg_count > 1 THEN
FOR i IN 1..x_msg_count LOOP
dbms_output.put_line(substr(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ),1,255));
END LOOP;
END IF;
ELSE
dbms_output.put_line(‘Attribute has been attached !!!!!!’);
end if;
end;
x_return_status VARCHAR2(2000);
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000);
x_vendor_site_id number;
begin
icx_user_sec_attr_pub.create_user_sec_attr(
p_api_version_number => 1,
p_return_status => x_return_status,
p_msg_count => x_msg_count,
p_msg_data => x_msg_data,
p_web_user_id => 1394,
p_attribute_code => ‘ICX_SUPPLIER_ORG_ID’,
p_attribute_appl_id => 177, —-iSupplier Portal
p_varchar2_value => ”,
p_date_value => ”,
p_number_value => 493, — Vendor_ID for ICX_SUPPLIER_ORG_ID’and Vendor_site_id for ICX_SUPPLIER_SITE_ID’ attribute code
p_created_by => -1,
p_creation_date => sysdate,
p_last_updated_by => -1,
p_last_update_date => sysdate,
p_last_update_login => -1);
if (x_return_status <> ‘S’) then
dbms_output.put_line(‘Encountered ERROR in Attribute Creation!!!’);
dbms_output.put_line(‘————————————–‘);
dbms_output.put_line(x_msg_data);
IF x_msg_count > 1 THEN
FOR i IN 1..x_msg_count LOOP
dbms_output.put_line(substr(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ),1,255));
END LOOP;
END IF;
ELSE
dbms_output.put_line(‘Attribute has been attached !!!!!!’);
end if;
end;
Thanks for the script. It worked for me !!!