323: RETURN l_name;
324:
325: EXCEPTION
326: WHEN OTHERS THEN
327: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
328: fnd_message.set_token('ERRNO' ,SQLCODE);
329: fnd_message.set_token('REASON', SQLERRM);
330: fnd_message.set_token('ROUTINE', l_proc);
331: RAISE;
324:
325: EXCEPTION
326: WHEN OTHERS THEN
327: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
328: fnd_message.set_token('ERRNO' ,SQLCODE);
329: fnd_message.set_token('REASON', SQLERRM);
330: fnd_message.set_token('ROUTINE', l_proc);
331: RAISE;
332:
325: EXCEPTION
326: WHEN OTHERS THEN
327: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
328: fnd_message.set_token('ERRNO' ,SQLCODE);
329: fnd_message.set_token('REASON', SQLERRM);
330: fnd_message.set_token('ROUTINE', l_proc);
331: RAISE;
332:
333: END get_user_profile_name;
326: WHEN OTHERS THEN
327: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
328: fnd_message.set_token('ERRNO' ,SQLCODE);
329: fnd_message.set_token('REASON', SQLERRM);
330: fnd_message.set_token('ROUTINE', l_proc);
331: RAISE;
332:
333: END get_user_profile_name;
334: