4316: FROM fnd_user
4317: WHERE user_id=l_user_id;
4318: EXCEPTION
4319: WHEN OTHERS THEN
4320: WF_CORE.CONTEXT('icx_sec', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
4321: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
4322: return 'ERROR';
4323: END;
4324:
4332:
4333:
4334: EXCEPTION
4335: WHEN no_data_found THEN
4336: WF_CORE.CONTEXT('icx_sec', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
4337: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
4338: return 'ERROR';
4339:
4340: END;
4351: COMMIT;
4352:
4353: EXCEPTION
4354: WHEN OTHERS THEN
4355: WF_CORE.CONTEXT('icx_sec', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
4356: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
4357:
4358: return 'ERROR';
4359: END;