利用API创建独立值集，并插值

declare
  l_msg_count NUMBER;
  l_msg_data  VARCHAR2(1000);
begin
  fnd_flex_val_api.set_session_mode ('customer_data'); --必须，否则会报错
  --利用create_valueset_dependent 创建独立值集
  FND_FLEX_VAL_API.create_valueset_independent(value_set_name     => 'CUX_LCY_INDEPENDENT_DEMO', --Value Set Name
                                               description        => '利用API创建独立值集', --Description
                                               security_available => 'N',
                                               --Sececurity Type: 'N'-No Sececurity
                                               --'H'-Hierarchical Sececurity
                                               --'Y'-Non-Hierarchical Sececurity
                                               enable_longlist => 'N',
                                               --List Type : 'N'-List of Values
                                               --'Y'-Long List of Values
                                               --'X'-Poplist
                                               format_type             => 'C',
                                               maximum_size            => 100,
                                               precision               => NULL,
                                               numbers_only            => 'N',
                                               uppercase_only          => 'N',
                                               right_j