eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AD_TSPACE_UTIL dependencies on FND_PRODUCT_INSTALLATIONS

Line 312: FROM FND_PRODUCT_INSTALLATIONS

308: then
309: begin
310: SELECT UPPER(nvl(TABLESPACE, 'UNKNOWN'))
311: INTO l_tspace
312: FROM FND_PRODUCT_INSTALLATIONS
313: WHERE APPLICATION_ID = 191
314: AND install_group_num in (0, 1);
315:
316: if (l_tspace = 'UNKNOWN')

Line 319: 'in FND_PRODUCT_INSTALLATIONS. The default tablespace '||

315:
316: if (l_tspace = 'UNKNOWN')
317: then raise_application_error(-20001,
318: 'The tablespace value for application "BIS" is NULL '||
319: 'in FND_PRODUCT_INSTALLATIONS. The default tablespace '||
320: 'for MVIEW is the tablespace of "BIS".');
321: end if;
322:
323: x_tablespace := l_tspace;

Line 329: 'FND_PRODUCT_INSTALLATIONS. The default'||

325: exception
326: when NO_DATA_FOUND then
327: raise_application_error(-20001,
328: 'Application "BIS" is not registered in '||
329: 'FND_PRODUCT_INSTALLATIONS. The default'||
330: ' tablespace for MVIEW is the tablespace of "BIS".');
331: end;
332:
333:

Line 342: FROM FND_PRODUCT_INSTALLATIONS

338: then
339: begin
340: SELECT UPPER(nvl(INDEX_TABLESPACE, 'UNKNOWN'))
341: INTO l_tspace
342: FROM FND_PRODUCT_INSTALLATIONS
343: WHERE APPLICATION_ID = l_appl_id;
344:
345: if (l_tspace = 'UNKNOWN')
346: then raise_application_error(-20001,

Line 350: 'in FND_PRODUCT_INSTALLATIONS');

346: then raise_application_error(-20001,
347: 'The index tablespace value for application "'||
348: UPPER(x_product_short_name)||
349: '" is NULL '||
350: 'in FND_PRODUCT_INSTALLATIONS');
351: end if;
352:
353: x_tablespace := l_tspace;
354:

Line 360: '" is not registered in FND_PRODUCT_INSTALLATIONS.');

356: when NO_DATA_FOUND then
357: raise_application_error(-20001,
358: 'Application "'||
359: UPPER(x_product_short_name)||
360: '" is not registered in FND_PRODUCT_INSTALLATIONS.');
361: end;
362:
363:
364: else

Line 366: -- get tablespace from FND_PRODUCT_INSTALLATIONS for

362:
363:
364: else
365:
366: -- get tablespace from FND_PRODUCT_INSTALLATIONS for
367: -- TABLE, AQ_TABLE, IOT_TABLE and MV_LOGs
368:
369: begin
370:

Line 373: FROM FND_PRODUCT_INSTALLATIONS

369: begin
370:
371: SELECT UPPER(nvl(TABLESPACE, 'UNKNOWN'))
372: INTO l_tspace
373: FROM FND_PRODUCT_INSTALLATIONS
374: WHERE APPLICATION_ID = l_appl_id;
375:
376: if (l_tspace = 'UNKNOWN')
377: then raise_application_error(-20001,

Line 381: 'in FND_PRODUCT_INSTALLATIONS');

377: then raise_application_error(-20001,
378: 'The data tablespace value for application "'||
379: UPPER(x_product_short_name)||
380: '" is NULL '||
381: 'in FND_PRODUCT_INSTALLATIONS');
382:
383: end if;
384:
385: x_tablespace := l_tspace;

Line 392: '" is not registered in FND_PRODUCT_INSTALLATIONS.');

388: when NO_DATA_FOUND then
389: raise_application_error(-20001,
390: 'Application "'||
391: UPPER(x_product_short_name)||
392: '" is not registered in FND_PRODUCT_INSTALLATIONS.');
393: end;
394:
395: end if; -- end if (UPPER(x_index_lookup_flag) = 'Y')
396:

Line 525: FROM FND_PRODUCT_INSTALLATIONS

521: then
522: begin
523: SELECT UPPER(nvl(INDEX_TABLESPACE, 'UNKNOWN'))
524: INTO l_tspace
525: FROM FND_PRODUCT_INSTALLATIONS
526: WHERE APPLICATION_ID = l_appl_id;
527:
528: if (l_tspace = 'UNKNOWN')
529: then raise_application_error(-20001,

Line 533: 'in FND_PRODUCT_INSTALLATIONS');

529: then raise_application_error(-20001,
530: 'The index tablespace value for application "'||
531: UPPER(x_product_short_name)||
532: '" is NULL '||
533: 'in FND_PRODUCT_INSTALLATIONS');
534: end if;
535:
536: x_tablespace := l_tspace;
537:

Line 543: '" is not registered in FND_PRODUCT_INSTALLATIONS.');

539: when NO_DATA_FOUND then
540: raise_application_error(-20001,
541: 'Application "'||
542: UPPER(x_product_short_name)||
543: '" is not registered in FND_PRODUCT_INSTALLATIONS.');
544: end;
545:
546: -- get tablespace for SUMMARY (MVIEW)
547: -- same logic as AD_TABLESPACE_UTILITIES

Line 556: FROM FND_PRODUCT_INSTALLATIONS

552: then
553: begin
554: SELECT UPPER(nvl(TABLESPACE, 'UNKNOWN'))
555: INTO l_tspace
556: FROM FND_PRODUCT_INSTALLATIONS
557: WHERE APPLICATION_ID = 191
558: AND install_group_num in (0, 1);
559:
560: if (l_tspace = 'UNKNOWN')

Line 563: 'in FND_PRODUCT_INSTALLATIONS. The default tablespace '||

559:
560: if (l_tspace = 'UNKNOWN')
561: then raise_application_error(-20001,
562: 'The tablespace value for application "BIS" is NULL '||
563: 'in FND_PRODUCT_INSTALLATIONS. The default tablespace '||
564: 'for SUMMARY is the tablespace of "BIS".');
565: end if;
566:
567: x_tablespace := l_tspace;

Line 573: 'FND_PRODUCT_INSTALLATIONS. The default'||

569: exception
570: when NO_DATA_FOUND then
571: raise_application_error(-20001,
572: 'Application "BIS" is not registered in '||
573: 'FND_PRODUCT_INSTALLATIONS. The default'||
574: ' tablespace for SUMMARY is the tablespace of "BIS".');
575: end;
576:
577: else

Line 585: FROM FND_PRODUCT_INSTALLATIONS

581: begin
582:
583: SELECT UPPER(nvl(TABLESPACE, 'UNKNOWN'))
584: INTO l_tspace
585: FROM FND_PRODUCT_INSTALLATIONS
586: WHERE APPLICATION_ID = l_appl_id;
587:
588: if (l_tspace = 'UNKNOWN')
589: then raise_application_error(-20001,

Line 593: 'in FND_PRODUCT_INSTALLATIONS');

589: then raise_application_error(-20001,
590: 'The data tablespace value for application "'||
591: UPPER(x_product_short_name)||
592: '" is NULL '||
593: 'in FND_PRODUCT_INSTALLATIONS');
594:
595: end if;
596:
597: x_tablespace := l_tspace;

Line 604: '" is not registered in FND_PRODUCT_INSTALLATIONS.');

600: when NO_DATA_FOUND then
601: raise_application_error(-20001,
602: 'Application "'||
603: UPPER(x_product_short_name)||
604: '" is not registered in FND_PRODUCT_INSTALLATIONS.');
605: end;
606:
607: end if; -- end if (UPPER(x_tablespace_type) = 'TRANSACTION_INDEXES')
608: