create code_combonation_id returns ora-0000 error

when I create code_combonation_id in my programes using fnd_flex_ext.get_ccid or fnd_flex_keyval.validate_segs,it returns: ORA-0000: normal, successful completion,but when I implement the same code in  a test script or a new windows,it returns OK.Please help me to solve the problem,thank you vary much.

additional my code:

BEGIN

              

                BEGIN

                  SELECT gcc.code_combination_id

                    INTO l_dr_id

                    FROM gl_code_combinations_kfv gcc

                   WHERE gcc.concatenated_segments = l_dr_seg

                     AND nvl(gcc.end_date_active, SYSDATE + 1) > SYSDATE;

                EXCEPTION

                  WHEN no_data_found THEN

                    l_result := fnd_flex_keyval.validate_segs('CREATE_COMBINATION',