4313: FROM fnd_user
4314: WHERE user_id=l_user_id;
4315: EXCEPTION
4316: WHEN OTHERS THEN
4317: WF_CORE.CONTEXT('icx_sec', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
4318: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
4319: return 'ERROR';
4320: END;
4321:
4329:
4330:
4331: EXCEPTION
4332: WHEN no_data_found THEN
4333: WF_CORE.CONTEXT('icx_sec', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
4334: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
4335: return 'ERROR';
4336:
4337: END;
4347: COMMIT;
4348:
4349: EXCEPTION
4350: WHEN OTHERS THEN
4351: WF_CORE.CONTEXT('icx_sec', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
4352: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
4353:
4354: return 'ERROR';
4355: END;