APEX

I'm stumped. I have a really odd situation. Any help is appreciated...I've deleted the page, reloaded the app, deleted all the processes and recreated them...all to no avail.

I have about 20 after submit processes. Everything seems to look OK. However, a couple of the processes don't seem to be executing and others are executing but not listed in the debug on the page.

Example of debug:

0.03: ...Process "Get PK for PHYSICAL_INTERFACE_ID Create/Create Another": PLSQL (AFTER_SUBMIT) declare function get_pk return varchar2 is begin for c1 in (select PHYSICAL_INTERFACE_ID_SEQ.nextval next_val from dual) loop return c1.next_val; end loop; end; begin :P780_PHYSICAL_INTERFACE_I
0.03: ...Session State: Saved Item "P780_PHYSICAL_INTERFACE_ID" New Value="32"
0.04: ...Do not run process "Get PK for PHYSICAL_INTERFACE_ID Create/Done", process point=AFTER_SUBMIT, condition type=, when button pressed=CREATE
0.04: ...Process "Get PK for VIRTUAL_INTERFACE_ID Create/Create Another": PLSQL (AFTER_SUBMIT) declare function get_pk2 return varchar2 is begin for c1 in (select VIRTUAL_INTERFACE_ID_SEQ.nextval next_val from dual) loop return c1.next_val; end loop; end; begin :P780_VIRTUAL_INTERFACE_ID
0.05: ...Session State: Saved Item "P780_PKG_RETURN_VALUE2" New Value="ERROR: Problem Creating Virtual Interface Table"
0.05: ...Do not run process "Call stored procedure - Virtual Interface Create/Done", process point=AFTER_SUBMIT, condition type=, when button pressed=CREATE

After running the process "Get PK for VIRTUAL_INTERFACE_ID Create/Create Another" I would expect to see a session state saved similar to the physical interface at time .03 The saved item "P780_PKG_RETURN_VALUE2" actually occurs in a process at a later sequence (which is actually much later--it seems to have skipped a couple processes).

Has anyone else see this type of problem? The last thing I can do is recreate the whole page (ouch!).

Thanks,
-Carmine