262: FROM fnd_user
263: WHERE user_id=l_user_id;
264: EXCEPTION
265: WHEN OTHERS THEN
266: WF_CORE.CONTEXT('fnd_session_management', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
267: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
268: return 'ERROR';
269: END;
270:
275: WHERE guid=p_guid;
276:
277: EXCEPTION
278: WHEN no_data_found THEN
279: WF_CORE.CONTEXT('fnd_session_management', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
280: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
281: return 'ERROR';
282: END;
283:
304: COMMIT;
305:
306: EXCEPTION
307: WHEN OTHERS THEN
308: WF_CORE.CONTEXT('fnd_session_management', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
309: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
310: return 'ERROR';
311: END;
312: NULL;