Create GL Code Combination using API

Hi Oracle Gurus,

I am trying to create new GL Code Combination after changes made to flexfield value set.

Below is my code and I keep getting this message: " Value 20 for the flexfield segment HE_CO does not exist in the value set HE_CO."

But i have checked my value set for this segment and the value is there.

create or replace function HES_GL_FLEX_CREATION

( p_concat_segs in varchar2

) return varchar2

is

  l_x     NUMBER;

  l_coa_id            NUMBER;

  l_err_msg           VARCHAR2(200);

 

begin

  begin

    select chart_of_accounts_id

    into   l_coa_id

    from   gl_sets_of_books