How to get error of API FND_FLEX_VAL_API.create_independent_vset_value
Hi ,
I am trying to add values in value set for PO Category. I am using API FND_FLEX_VAL_API.create_independent_vset_value to load values.
My concern is the API does have any return status parameter. It has only one out parameter x_storage_value.
How do I get API status or error then?
Sample code:
declare
x varchar2(200);
v_msg varchar2(2000);
begin
FND_FLEX_VAL_API.create_independent_vset_value
(p_flex_value_set_name => 'PO_CATEGORY',
p_flex_value => '2222',
p_description => 'Inserted from API',
p_enabled_flag => 'Y',
p_start_date_active => NULL,