Oracle Apps: Create value set using API

Anonymous block to create a value set using fnd_flex_val_api.create_valueset_independent

DECLARE

value_set_name         VARCHAR2 (200);
description         VARCHAR2 (200);
security_available     VARCHAR2 (200);
enable_longlist     VARCHAR2 (200);
format_type         VARCHAR2 (200);
maximum_size        NUMBER;
PRECISION         NUMBER;
numbers_only         VARCHAR2 (200);
uppercase_only         VARCHAR2 (200);
right_justify_zero_fill VARCHAR2 (200);
min_value         VARCHAR2 (200);
max_value         VARCHAR2 (200);
v_session_mode         VARCHAR2 (20) := 'customer_data';
x             VARCHAR2 (200);
v_msg             VARCHAR2 (2000);

BEGIN

fnd_flex_val_api.set_session_mode (v_session_mode);

value_set_name := 'CUST_VAL_SET_WIP';
description    := 'Custom Valueset wipro';
security_available := 'N';
enable_longlist := 'N';
format_type := 'C';
maximum_size := 30;
PRECISION := 1;
numbers_only := 'N';
uppercase_only := 'N';
right_justify_zero_fill := 'N';
min_value := '1';
max_value := '30';


apps.fnd_flex_val_api.create_valueset_independent
(value_set_name,
 description,
 ecurity_available,
 enable_longlist,
 format_type,
 maximum_size,
 PRECISION,
 numbers_only,
 uppercase_only,
 right_justify_zero_fill,
 min_value,
 max_value
 );

EXCEPTION
WHEN OTHERS THEN
   v_msg := fnd_flex_val_api.MESSAGE;
   DBMS_OUTPUT.put_line (v_msg);
   DBMS_OUTPUT.put_line (SQLERRM);
END;

COMMIT ;
/