Line 2374: select sysdate into l_sysdate from dual;
2370: -- ===========
2371: -- Get sysdate
2372: -- ===========
2373: BEGIN 2374: select sysdate into l_sysdate from dual; 2375: EXCEPTION WHEN OTHERS THEN
2376: LOG_MESSAGE('Error while fetching sysdate');
2377: LOG_MESSAGE(SQLERRM);
2378: RETCODE := G_ERROR;