Procurement - EBS (MOSC)

MOSC Banner

How to get error of API FND_FLEX_VAL_API.create_independent_vset_value

edited Jun 18, 2020 6:02AM in Procurement - EBS (MOSC) 5 commentsAnswered ✓

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center