191: FROM ego_user_v
192: where user_name = x_user_name;
193: exception
194: when no_data_found then
195: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
196: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
197: 'NAVISTAR EGO_ITEM_PEOPLE_IMPORT_PKG' || l_api_name || '.end_nodatafound', 'returning NULLs.');
198: end if;
199: return;
192: where user_name = x_user_name;
193: exception
194: when no_data_found then
195: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
196: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
197: 'NAVISTAR EGO_ITEM_PEOPLE_IMPORT_PKG' || l_api_name || '.end_nodatafound', 'returning NULLs.');
198: end if;
199: return;
200: end;