197: l_dummy1 varchar2(2000);
198: l_dummy2 varchar2(2000);
199: l_schema varchar2(400);
200: Begin
201: if FND_INSTALLATION.GET_APP_INFO(p_product,l_dummy1, l_dummy2,l_schema) = false then
202: VBHDEBUG('FND_INSTALLATION.GET_APP_INFO returned with error');
203: return null;
204: end if;
205: return l_schema;
198: l_dummy2 varchar2(2000);
199: l_schema varchar2(400);
200: Begin
201: if FND_INSTALLATION.GET_APP_INFO(p_product,l_dummy1, l_dummy2,l_schema) = false then
202: VBHDEBUG('FND_INSTALLATION.GET_APP_INFO returned with error');
203: return null;
204: end if;
205: return l_schema;
206: Exception when others then