APEX

Hello

I am running into Issue, with confirm Dialog Box

My setting as below.

1 action execuate Server side code

DECLARE
  x       NUMBER;
  v_error VARCHAR2(100);
BEGIN

:P2120_V_ERROR :=  NULL; 
v_error := NULL;

SELECT 'A person by this name already exists. Individual Id - ' || individuals_id
                                     INTO v_error
                                     FROM
                                     individuals i
    WHERE  Instr(Upper(i.first_name), Upper(:p2120_first_name), 1, 1) > 0
           AND Instr(Upper(i.last_name), Upper(:p2120_last_name), 1, 1) > 0
           or ( Instr(Upper(i.nationality), Upper(:p2120_nationality), 1, 1) is not null and    Instr(Upper(i.nationality), Upper(:p2120_nationality), 1, 1) > 0 )
           fetch first 1 rows only;
           
IF v_error is not null THEN
  :p2120_v_error := v_error;
ELSE
  :p2120_v_error := null;
END IF;

EXCEPTION
    WHEN no_data_found THEN
       :p2120_v_error := NULL;
END;

2 . confirm

{if !P2120_V_ERROR===null/}
Are you sure to create? <strong> &P2120_V_ERROR. </strong>
{else/}

{endif/}	

Out of the box Process form create new individual

Issue,

it directly going to branched page, without waiting for user input.

Please suggest.