315:
316: begin
317: select sid, serial#
318: into ssid, sserial#
319: from gv$session
320: where kill_session.audsid = gv$session.audsid
321: and kill_session.inst_id = gv$session.inst_id;
322: exception
323: when no_data_found then
316: begin
317: select sid, serial#
318: into ssid, sserial#
319: from gv$session
320: where kill_session.audsid = gv$session.audsid
321: and kill_session.inst_id = gv$session.inst_id;
322: exception
323: when no_data_found then
324: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
317: select sid, serial#
318: into ssid, sserial#
319: from gv$session
320: where kill_session.audsid = gv$session.audsid
321: and kill_session.inst_id = gv$session.inst_id;
322: exception
323: when no_data_found then
324: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
325: fnd_log.string(FND_LOG.LEVEL_ERROR,