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.MSC_ATP_REFRESH_MVIEW dependencies on MSC_UTIL

Line 56: msc_util.msc_log('Begin REFRESH_MVIEW');

52: BEGIN
53: -- Bug 3304390 Disable Trace
54: -- Deleted related code
55:
56: msc_util.msc_log('Begin REFRESH_MVIEW');
57: l_retval := FND_INSTALLATION.GET_APP_INFO('FND', dummy1, dummy2, l_applsys_schema);
58: /*
59: SELECT a.oracle_username
60: INTO l_msc_schema

Line 75: msc_util.msc_log('Profile Option value' || l_msc_cap_allocation);

71:
72:
73: -- bug 2383867 : krajan
74: l_msc_cap_allocation := NVL(FND_PROFILE.VALUE('MSC_CAP_ALLOCATION'), 'Y');
75: msc_util.msc_log('Profile Option value' || l_msc_cap_allocation);
76:
77: msc_util.msc_log('Before getting partitions name');
78: IF (l_msc_cap_allocation = 'Y') THEN
79:

Line 77: msc_util.msc_log('Before getting partitions name');

73: -- bug 2383867 : krajan
74: l_msc_cap_allocation := NVL(FND_PROFILE.VALUE('MSC_CAP_ALLOCATION'), 'Y');
75: msc_util.msc_log('Profile Option value' || l_msc_cap_allocation);
76:
77: msc_util.msc_log('Before getting partitions name');
78: IF (l_msc_cap_allocation = 'Y') THEN
79:
80: msc_util.msc_log('AATP Profile Option Set. Getting everything.');
81: SELECT table_name, partition_name, partition_name || '_TEMP',

Line 80: msc_util.msc_log('AATP Profile Option Set. Getting everything.');

76:
77: msc_util.msc_log('Before getting partitions name');
78: IF (l_msc_cap_allocation = 'Y') THEN
79:
80: msc_util.msc_log('AATP Profile Option Set. Getting everything.');
81: SELECT table_name, partition_name, partition_name || '_TEMP',
82: --subpartition_count,
83: tablespace_name
84: BULK COLLECT

Line 97: msc_util.msc_log('AATP Profile Option Set. Getting everything.');

93: ORDER BY table_name, partition_name;
94:
95: -- :In Case of Huge data in MSC_ITEM_HIERARCHY_MV and MSC_RESOURCE_HIERARCHY_MV --5053818
96: -- need to set proper Initial extent and next extent value for customers
97: msc_util.msc_log('AATP Profile Option Set. Getting everything.');
98:
99: BEGIN
100: SELECT nvl(ITEM_HIER_INIT_EXTENT,40),
101: nvl(ITEM_HIER_NEXT_EXTENT,5),

Line 135: msc_util.msc_log('AATP Profile Option set to NO. Not getting Resource Hierarchy.');

131: l_res_hier_indx_pct_inc :=0;
132: END;
133:
134: ELSE
135: msc_util.msc_log('AATP Profile Option set to NO. Not getting Resource Hierarchy.');
136: SELECT table_name, partition_name, partition_name || '_TEMP',
137: --subpartition_count,
138: tablespace_name
139: BULK COLLECT

Line 152: msc_util.msc_log('AATP Profile Option Set. Getting everything.');

148: ORDER BY partition_name;
149:
150: -- :In Case of Huge data in MSC_ITEM_HIERARCHY_MV and MSC_RESOURCE_HIERARCHY_MV --5053818
151: -- need to set proper Initial extent and next extent value for customers
152: msc_util.msc_log('AATP Profile Option Set. Getting everything.');
153:
154: BEGIN
155: SELECT NVL(ITEM_HIER_INIT_EXTENT,40),
156: nvl(ITEM_HIER_NEXT_EXTENT,5),

Line 180: msc_util.msc_log('Before Create Temp Table Loop');

176: -- End bug 2383867 changes : krajan
177:
178: i := l_part_name.FIRST;
179:
180: msc_util.msc_log('Before Create Temp Table Loop');
181: WHILE i IS NOT NULL LOOP
182:
183: IF i > 1 THEN
184: IF l_cur_table(i) <> l_cur_table(i-1) THEN

Line 650: msc_util.msc_log('Before AD_DDL');

646: --storage(INITIAL 40K NEXT 2M PCTINCREASE 0) LOCAL tablespace ' || l_tbspace(i);
647:
648: END IF;
649:
650: msc_util.msc_log('Before AD_DDL');
651: BEGIN
652: msc_util.msc_log('Before create table : ' ||l_temp_table(i));
653: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
654: APPLICATION_SHORT_NAME => l_apps_schema,

Line 652: msc_util.msc_log('Before create table : ' ||l_temp_table(i));

648: END IF;
649:
650: msc_util.msc_log('Before AD_DDL');
651: BEGIN
652: msc_util.msc_log('Before create table : ' ||l_temp_table(i));
653: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
654: APPLICATION_SHORT_NAME => l_apps_schema,
655: STATEMENT_TYPE => ad_ddl.create_table,
656: STATEMENT => sql_stmt1,

Line 662: msc_util.msc_log('SYNONYM already created in APPS schema.');

658: EXCEPTION
659: WHEN others THEN
660:
661: IF SQLCODE IN (-01471) THEN
662: msc_util.msc_log('SYNONYM already created in APPS schema.');
663: msc_util.msc_log('After create table SYNONYM: ' ||l_temp_table(i));
664: ELSIF SQLCODE IN (-00955) THEN
665: msc_util.msc_log('Object already created in APPS Schema. No Need to create SYNONYM again');
666: msc_util.msc_log('After create table OBJECT SYNONYM: ' ||l_temp_table(i));

Line 663: msc_util.msc_log('After create table SYNONYM: ' ||l_temp_table(i));

659: WHEN others THEN
660:
661: IF SQLCODE IN (-01471) THEN
662: msc_util.msc_log('SYNONYM already created in APPS schema.');
663: msc_util.msc_log('After create table SYNONYM: ' ||l_temp_table(i));
664: ELSIF SQLCODE IN (-00955) THEN
665: msc_util.msc_log('Object already created in APPS Schema. No Need to create SYNONYM again');
666: msc_util.msc_log('After create table OBJECT SYNONYM: ' ||l_temp_table(i));
667: ELSE

Line 665: msc_util.msc_log('Object already created in APPS Schema. No Need to create SYNONYM again');

661: IF SQLCODE IN (-01471) THEN
662: msc_util.msc_log('SYNONYM already created in APPS schema.');
663: msc_util.msc_log('After create table SYNONYM: ' ||l_temp_table(i));
664: ELSIF SQLCODE IN (-00955) THEN
665: msc_util.msc_log('Object already created in APPS Schema. No Need to create SYNONYM again');
666: msc_util.msc_log('After create table OBJECT SYNONYM: ' ||l_temp_table(i));
667: ELSE
668: msc_util.msc_log(sqlerrm);
669: msc_util.msc_log('Inside Exception of create table : ' ||l_temp_table(i));

Line 666: msc_util.msc_log('After create table OBJECT SYNONYM: ' ||l_temp_table(i));

662: msc_util.msc_log('SYNONYM already created in APPS schema.');
663: msc_util.msc_log('After create table SYNONYM: ' ||l_temp_table(i));
664: ELSIF SQLCODE IN (-00955) THEN
665: msc_util.msc_log('Object already created in APPS Schema. No Need to create SYNONYM again');
666: msc_util.msc_log('After create table OBJECT SYNONYM: ' ||l_temp_table(i));
667: ELSE
668: msc_util.msc_log(sqlerrm);
669: msc_util.msc_log('Inside Exception of create table : ' ||l_temp_table(i));
670:

Line 668: msc_util.msc_log(sqlerrm);

664: ELSIF SQLCODE IN (-00955) THEN
665: msc_util.msc_log('Object already created in APPS Schema. No Need to create SYNONYM again');
666: msc_util.msc_log('After create table OBJECT SYNONYM: ' ||l_temp_table(i));
667: ELSE
668: msc_util.msc_log(sqlerrm);
669: msc_util.msc_log('Inside Exception of create table : ' ||l_temp_table(i));
670:
671: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
672: APPLICATION_SHORT_NAME => l_apps_schema,

Line 669: msc_util.msc_log('Inside Exception of create table : ' ||l_temp_table(i));

665: msc_util.msc_log('Object already created in APPS Schema. No Need to create SYNONYM again');
666: msc_util.msc_log('After create table OBJECT SYNONYM: ' ||l_temp_table(i));
667: ELSE
668: msc_util.msc_log(sqlerrm);
669: msc_util.msc_log('Inside Exception of create table : ' ||l_temp_table(i));
670:
671: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
672: APPLICATION_SHORT_NAME => l_apps_schema,
673: STATEMENT_TYPE => ad_ddl.drop_table,

Line 677: msc_util.msc_log('After Drop table : ' ||l_temp_table(i));

673: STATEMENT_TYPE => ad_ddl.drop_table,
674: STATEMENT => 'DROP TABLE ' || l_temp_table(i),
675: OBJECT_NAME => l_temp_table(i));
676:
677: msc_util.msc_log('After Drop table : ' ||l_temp_table(i));
678: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
679: APPLICATION_SHORT_NAME => l_apps_schema,
680: STATEMENT_TYPE => ad_ddl.create_table,
681: STATEMENT => sql_stmt1,

Line 683: msc_util.msc_log('After create table : ' ||l_temp_table(i));

679: APPLICATION_SHORT_NAME => l_apps_schema,
680: STATEMENT_TYPE => ad_ddl.create_table,
681: STATEMENT => sql_stmt1,
682: OBJECT_NAME => l_temp_table(i));
683: msc_util.msc_log('After create table : ' ||l_temp_table(i));
684:
685: END IF;
686: END;
687:

Line 689: msc_util.msc_log('Before create index : ' ||l_temp_table(i));

685: END IF;
686: END;
687:
688: BEGIN
689: msc_util.msc_log('Before create index : ' ||l_temp_table(i));
690: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
691: APPLICATION_SHORT_NAME => l_apps_schema,
692: STATEMENT_TYPE => ad_ddl.create_index,
693: STATEMENT => sql_stmt2,

Line 698: msc_util.msc_log(sqlerrm);

694: OBJECT_NAME => l_temp_table(i));
695: EXCEPTION
696: WHEN others THEN
697:
698: msc_util.msc_log(sqlerrm);
699: msc_util.msc_log('Inside Exception of create index : ' ||l_temp_table(i));
700: --- bug 4156016: Raise exception so that we could error out gracefully
701: RAISE FND_API.G_EXC_ERROR;
702:

Line 699: msc_util.msc_log('Inside Exception of create index : ' ||l_temp_table(i));

695: EXCEPTION
696: WHEN others THEN
697:
698: msc_util.msc_log(sqlerrm);
699: msc_util.msc_log('Inside Exception of create index : ' ||l_temp_table(i));
700: --- bug 4156016: Raise exception so that we could error out gracefully
701: RAISE FND_API.G_EXC_ERROR;
702:
703: END;

Line 729: msc_util.msc_log('Before alter table : ' ||l_cur_table(i));

725: l_part_name(i) || ' with table ' || l_temp_table(i) ||
726: ' including indexes without validation';
727:
728: BEGIN
729: msc_util.msc_log('Before alter table : ' ||l_cur_table(i));
730: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
731: APPLICATION_SHORT_NAME => l_apps_schema,
732: STATEMENT_TYPE => ad_ddl.alter_table,
733: STATEMENT => sql_stmt1,

Line 738: msc_util.msc_log(sqlerrm);

734: OBJECT_NAME => l_cur_table(i));
735: EXCEPTION
736: WHEN others THEN
737:
738: msc_util.msc_log(sqlerrm);
739: msc_util.msc_log('Inside Exception of alter table : ' ||l_cur_table(i));
740: --- bug 4156016: Raise exception so that we could error out gracefully
741: RAISE FND_API.G_EXC_ERROR;
742:

Line 739: msc_util.msc_log('Inside Exception of alter table : ' ||l_cur_table(i));

735: EXCEPTION
736: WHEN others THEN
737:
738: msc_util.msc_log(sqlerrm);
739: msc_util.msc_log('Inside Exception of alter table : ' ||l_cur_table(i));
740: --- bug 4156016: Raise exception so that we could error out gracefully
741: RAISE FND_API.G_EXC_ERROR;
742:
743: END;

Line 748: msc_util.msc_log('Before drop table : ' ||l_temp_table(i));

744:
745: sql_stmt2 := 'DROP TABLE ' || l_temp_table(i);
746:
747: BEGIN
748: msc_util.msc_log('Before drop table : ' ||l_temp_table(i));
749: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
750: APPLICATION_SHORT_NAME => l_apps_schema,
751: STATEMENT_TYPE => ad_ddl.drop_table,
752: STATEMENT => sql_stmt2,

Line 757: msc_util.msc_log(sqlerrm);

753: OBJECT_NAME => l_temp_table(i));
754: EXCEPTION
755: WHEN others THEN
756:
757: msc_util.msc_log(sqlerrm);
758: msc_util.msc_log('Inside Exception of alter table : ' ||l_temp_table(i));
759: --- bug 4156016: Raise exception so that we could error out gracefully
760: RAISE FND_API.G_EXC_ERROR;
761:

Line 758: msc_util.msc_log('Inside Exception of alter table : ' ||l_temp_table(i));

754: EXCEPTION
755: WHEN others THEN
756:
757: msc_util.msc_log(sqlerrm);
758: msc_util.msc_log('Inside Exception of alter table : ' ||l_temp_table(i));
759: --- bug 4156016: Raise exception so that we could error out gracefully
760: RAISE FND_API.G_EXC_ERROR;
761:
762: END;

Line 768: msc_util.msc_log('End REFRESH_MVIEW');

764: i := l_cur_table.NEXT(i);
765: END LOOP; -- WHILE i IS NOT NULL LOOP
766:
767: RETCODE:= G_SUCCESS;
768: msc_util.msc_log('End REFRESH_MVIEW');
769: EXCEPTION
770: WHEN OTHERS THEN
771: msc_util.msc_log(sqlerrm);
772: msc_util.msc_log('Inside Main Exception');

Line 771: msc_util.msc_log(sqlerrm);

767: RETCODE:= G_SUCCESS;
768: msc_util.msc_log('End REFRESH_MVIEW');
769: EXCEPTION
770: WHEN OTHERS THEN
771: msc_util.msc_log(sqlerrm);
772: msc_util.msc_log('Inside Main Exception');
773: --bug 4156016: Set the error code here so that if an unhandled eception occurs in
774: --- exception block then atleast the program will error out.
775: RETCODE:= G_ERROR;

Line 772: msc_util.msc_log('Inside Main Exception');

768: msc_util.msc_log('End REFRESH_MVIEW');
769: EXCEPTION
770: WHEN OTHERS THEN
771: msc_util.msc_log(sqlerrm);
772: msc_util.msc_log('Inside Main Exception');
773: --bug 4156016: Set the error code here so that if an unhandled eception occurs in
774: --- exception block then atleast the program will error out.
775: RETCODE:= G_ERROR;
776: ERRBUF:= SQLERRM;

Line 790: msc_util.msc_log('Error in droping table ' || l_temp_table(i));

786: STATEMENT => sql_stmt2,
787: OBJECT_NAME => l_temp_table(i));
788: EXCEPTION
789: WHEN OTHERS THEN
790: msc_util.msc_log('Error in droping table ' || l_temp_table(i));
791: END;
792:
793: i := l_temp_table.NEXT(i);
794: END LOOP; -- WHILE i IS NOT NULL LOOP