200: FETCH l_user_cur INTO l_user_name;
201: IF l_user_cur%NOTFOUND THEN
202: -- the user has been end-dated
203: CLOSE l_user_cur;
204: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
205: fnd_log.string(fnd_log.level_exception, g_log_module_name || '.' || lv_proc_name, 'GUEST user has been end-dated');
206: END IF;
207: RETURN;
208: END IF;
201: IF l_user_cur%NOTFOUND THEN
202: -- the user has been end-dated
203: CLOSE l_user_cur;
204: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
205: fnd_log.string(fnd_log.level_exception, g_log_module_name || '.' || lv_proc_name, 'GUEST user has been end-dated');
206: END IF;
207: RETURN;
208: END IF;
209: CLOSE l_user_cur;
215: -- end-dated. do not assign the responsibility in this case
216: -- should have end-dated the assignment too. but presumably, there is
217: -- no such assignment (because Form prevents the assignment...)
218: CLOSE l_resp_cur;
219: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
220: fnd_log.string(fnd_log.level_exception, g_log_module_name || '.' || lv_proc_name, 'guest responsibility has been end-dated');
221: END IF;
222: RETURN;
223: END IF;
216: -- should have end-dated the assignment too. but presumably, there is
217: -- no such assignment (because Form prevents the assignment...)
218: CLOSE l_resp_cur;
219: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
220: fnd_log.string(fnd_log.level_exception, g_log_module_name || '.' || lv_proc_name, 'guest responsibility has been end-dated');
221: END IF;
222: RETURN;
223: END IF;
224: CLOSE l_resp_cur;