Illegal SQL rejected:

Yeah, Apps 8 wants to only see application objects in the dictionary cache. Sorry, I haven’t worked in Apps 8 in two years.

Here’s another work-around to try:

CREATE SEQUENCE c_sequence_id_seq;

CREATE OR REPLACE PACKAGE c_sequence_id_api AUTHID DEFINER IS
module_  CONSTANT VARCHAR2(25) := 'FNDBAS';
lu_name_ CONSTANT VARCHAR2(25) := 'CSequenceId';

FUNCTION get_nextval RETURN NUMBER;

PROCEDURE init;

END c_sequence_id_api;
/

CREATE OR REPLACE PACKAGE BODY c_sequence_id_api IS

FUNCTION get_nextval RETURN NUMBER
IS
BEGIN
   general_sys.init_method(lu_name_, 'C_SEQUENCE_ID_API', 'GET_NEXTVAL');
   RETURN c_sequence_id_seq.nextval;
END get_nextval;

PROCEDURE init IS BEGIN NULL; END init;

END c_sequence_id_api;
/


EXEC dictionary_sys.rebuild_dictionary_storage_(0);
EXEC security_sys.grant_package('C_SEQUENCE_ID_API', 'FND_ENDUSER');
EXEC security_sys.refresh_active_list__(0);



-- Event action code:

DECLARE
   n_ NUMBER := 0;
BEGIN
   n_ := ifsapp.c_sequence_id_api.get_nextval;
   ifsapp.trace_sys.message('######## n_ = ' || n_);
END;
/