API to Create Independent Value Set (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_DEMO';
   description := 'Custom Valueset';
   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';
   FND_FLEX_VAL_API.CREATE_VALUESET_INDEPENDENT (value_set_name,
                                                 description,
                                                 security_available,
                                                 enable_longlist,
                                                 format_type,
                                                 maximum_size,
                                                 PRECISION,
                                                 numbers_only,
                                                 uppercase_only,
                                                 right_justify_zero_fill,
                                                 min_value,
                                                 max_value);
   COMMIT;
EXCEPTION
   WHEN OTHERS
   THEN
      ROLLBACK;
      v_msg := fnd_flex_val_api.MESSAGE;
      DBMS_OUTPUT.put_line (v_msg);
      DBMS_OUTPUT.put_line (SQLERRM);
END;