Dear All,
Kindly assist to me.
Below error when I see the error_log table….
Error :
----- PL/SQL Call Stack ----- object line object handle number name 0xc75e7720 61 package body XXWF.XXWF_ERROR_LOG_PKG.RECORD_LOG 0xd33e4330 1781 package body XXWF.XXWF_EXP_APPROVAL_PROCESS_PKG.XXWF_APPROVE_EXP_REQUEST 0xc1efdd30 23 anonymous block 0xd6eb39a0 2120 package body SYS.DBMS_SYS_SQL.EXECUTE 0xe1ab2718 837 package body SYS.WWV_DBMS_SQL_APEX_220200.EXECUTE 0xe1b69ce0 2614 package body APEX_220200.WWV_FLOW_DYNAMIC_EXEC.RUN_BLOCK5 0xd6eba570 97 package body APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL.EXECUTE_INT 0xd6eba570 430 package body APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL.EXECUTE_RETURN_OUT_BINDS 0xd6ebdd50 614 package body APEX_220200.WWV_FLOW_CODE_EXEC.EXECUTE_RETURN_OUT_BINDS 0xd6d48748 3053 package body APEX_220200.WWV_FLOW_EXEC_LOCAL.OPEN_CODE_CONTEXT 0xd6d4e788 2642 package body APEX_220200.WWV_FLOW_EXEC.OPEN_PROCESS_CONTEXT 0xd6d4e788 2678 package body APEX_220200.WWV_FLOW_EXEC.OPEN_PROCESS_CONTEXT 0xdb45a2e8 34 package body APEX_220200.WWV_FLOW_PROCESS_NATIVE.PLSQL 0xdb45a2e8 1230 package body APEX_220200.WWV_FLOW_PROCESS_NATIVE.EXECUTE_PROCESS 0xe3dd60a0 3163 package body APEX_220200.WWV_FLOW_PLUGIN.EXECUTE_PROCESS 0xd6da4b18 170 package body APEX_220200.WWV_FLOW_PROCESS.PERFORM_PROCESS 0xd6da4b18 417 package body APEX_220200.WWV_FLOW_PROCESS.PERFORM 0xe31cc6f8 4214 package body APEX_220200.WWV_FLOW.ACCEPT 0xd3ad5bd8 2 anonymous block <br><br>
Code :
LOOP
SELECT
count(*)
INTO v_count_name
FROM
XXF_table
WHERE
TO_CHAR(ACTIONED_BY) IN (
SELECT COLUMN_VALUE
FROM TABLE(
apex_string.split(
rtrim(ltrim(xxf_package.get_exp_currentstage_person_id(p_exp_request_id => rreq.exp_request_id), ','), ','),
','
)
)
)
AND ACTION_TAKEN = 'Approved'
AND EXP_REQUEST_ID = rreq.exp_request_id;
IF v\_count\_name > 0 THEN
BEGIN
SELECT TO\_CHAR(ACTIONED\_BY)
INTO v\_action\_by
FROM XXF\_table
WHERE
TO\_CHAR(ACTIONED\_BY) IN (
SELECT COLUMN\_VALUE
FROM TABLE(
apex\_string.split(
rtrim(ltrim(xxf\_package.get\_exp\_currentstage\_person\_id(p\_exp\_request\_id => rreq.exp\_request\_id), ','), ','),
','
)
)
)
AND ACTION\_TAKEN = 'Approved'
AND EXP\_REQUEST\_ID = rreq.exp\_request\_id
AND ROWNUM = 1;
EXCEPTION
WHEN OTHERS THEN
xxwf\_error\_log\_pkg.record\_log('ERROR', 'Exception Occurred', SQLERRM, SQLCODE);
END;
-- Here I update auto approval status in table
BEGIN --/\* Push to next stage\*/
SELECT
column name
INTO varibale
FROM
xxf\_table
WHERE
conn.prcs\_id = rreq.flow\_process\_id
AND conn.sbfl\_id = rreq.subflow\_id
AND column name = 'Approved';
END;
BEGIN
xxf\_pkg.flow\_next\_branch(p\_process\_id => rreq.flow\_process\_id,
p\_subflow\_id => rreq.subflow\_id,
p\_branch\_name => v\_branch\_id
);
SELECT
column name
INTO variable
FROM
xxf\_table
WHERE
sbfl\_prcs\_id = rreq.flow\_process\_id;
IF v\_next\_step = 'simple-step' THEN
xxf\_pkg.process\_action(pi\_action => 'NEXT\_STEP',
pi\_prcs\_id => rreq.flow\_process\_id,
pi\_sbfl\_id => rreq.subflow\_id,
pi\_branch => NULL
);
END IF;
END;
ELSE
exit;
END IF;
END LOOP;
Kindly assist to me.. I got error above mentioned.
My Requirement :
I have multiple stages to approve. If first stage is same person in next stage or any other stages. If manual approved in first stage then auto approved the next stage if same person present. …
Thank you in advance..