611: g_phase := 'Calling ALTER SESSION SET global_names = false ';
612: l_stmt := 'ALTER SESSION SET global_names = false';
613: EXECUTE IMMEDIATE l_stmt;
614:
615: g_fii_user_id := FND_GLOBAL.User_Id;
616: g_fii_login_id := FND_GLOBAL.Login_Id;
617:
618: EXCEPTION
619: WHEN OTHERS THEN
612: l_stmt := 'ALTER SESSION SET global_names = false';
613: EXECUTE IMMEDIATE l_stmt;
614:
615: g_fii_user_id := FND_GLOBAL.User_Id;
616: g_fii_login_id := FND_GLOBAL.Login_Id;
617:
618: EXCEPTION
619: WHEN OTHERS THEN
620: rollback;
2030:
2031: errbuf := NULL;
2032: retcode := 0;
2033:
2034: g_fii_user_id := FND_GLOBAL.User_Id;
2035: g_fii_login_id := FND_GLOBAL.Login_Id;
2036:
2037: IF (g_fii_user_id IS NULL OR g_fii_login_id IS NULL) THEN
2038: RAISE G_LOGIN_INFO_NOT_AVABLE;
2031: errbuf := NULL;
2032: retcode := 0;
2033:
2034: g_fii_user_id := FND_GLOBAL.User_Id;
2035: g_fii_login_id := FND_GLOBAL.Login_Id;
2036:
2037: IF (g_fii_user_id IS NULL OR g_fii_login_id IS NULL) THEN
2038: RAISE G_LOGIN_INFO_NOT_AVABLE;
2039: END IF;