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 55: msc_util.msc_log('Begin REFRESH_MVIEW');

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

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

64:
65:
66: -- bug 2383867 : krajan
67: l_msc_cap_allocation := NVL(FND_PROFILE.VALUE('MSC_CAP_ALLOCATION'), 'Y');
68: msc_util.msc_log('Profile Option value' || l_msc_cap_allocation);
69:
70: msc_util.msc_log('Before getting partitions name');
71: IF (l_msc_cap_allocation = 'Y') THEN
72:

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

66: -- bug 2383867 : krajan
67: l_msc_cap_allocation := NVL(FND_PROFILE.VALUE('MSC_CAP_ALLOCATION'), 'Y');
68: msc_util.msc_log('Profile Option value' || l_msc_cap_allocation);
69:
70: msc_util.msc_log('Before getting partitions name');
71: IF (l_msc_cap_allocation = 'Y') THEN
72:
73: msc_util.msc_log('AATP Profile Option Set. Getting everything.');
74: SELECT table_name, partition_name, partition_name || '_TEMP',

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

69:
70: msc_util.msc_log('Before getting partitions name');
71: IF (l_msc_cap_allocation = 'Y') THEN
72:
73: msc_util.msc_log('AATP Profile Option Set. Getting everything.');
74: SELECT table_name, partition_name, partition_name || '_TEMP',
75: --subpartition_count,
76: tablespace_name
77: BULK COLLECT

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

86: ORDER BY table_name, partition_name;
87:
88: -- :In Case of Huge data in MSC_ITEM_HIERARCHY_MV and MSC_RESOURCE_HIERARCHY_MV --5053818
89: -- need to set proper Initial extent and next extent value for customers
90: msc_util.msc_log('AATP Profile Option Set. Getting everything.');
91:
92: BEGIN
93: SELECT nvl(ITEM_HIER_INIT_EXTENT,40),
94: nvl(ITEM_HIER_NEXT_EXTENT,5),

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

124: l_res_hier_indx_pct_inc :=0;
125: END;
126:
127: ELSE
128: msc_util.msc_log('AATP Profile Option set to NO. Not getting Resource Hierarchy.');
129: SELECT table_name, partition_name, partition_name || '_TEMP',
130: --subpartition_count,
131: tablespace_name
132: BULK COLLECT

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

141: ORDER BY partition_name;
142:
143: -- :In Case of Huge data in MSC_ITEM_HIERARCHY_MV and MSC_RESOURCE_HIERARCHY_MV --5053818
144: -- need to set proper Initial extent and next extent value for customers
145: msc_util.msc_log('AATP Profile Option Set. Getting everything.');
146:
147: BEGIN
148: SELECT NVL(ITEM_HIER_INIT_EXTENT,40),
149: nvl(ITEM_HIER_NEXT_EXTENT,5),

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

169: -- End bug 2383867 changes : krajan
170:
171: i := l_part_name.FIRST;
172:
173: msc_util.msc_log('Before Create Temp Table Loop');
174: WHILE i IS NOT NULL LOOP
175:
176: IF i > 1 THEN
177: IF l_cur_table(i) <> l_cur_table(i-1) THEN

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

639: --storage(INITIAL 40K NEXT 2M PCTINCREASE 0) LOCAL tablespace ' || l_tbspace(i);
640:
641: END IF;
642:
643: msc_util.msc_log('Before AD_DDL');
644: BEGIN
645: msc_util.msc_log('Before create table : ' ||l_temp_table(i));
646: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
647: APPLICATION_SHORT_NAME => 'MSC',

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

641: END IF;
642:
643: msc_util.msc_log('Before AD_DDL');
644: BEGIN
645: msc_util.msc_log('Before create table : ' ||l_temp_table(i));
646: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
647: APPLICATION_SHORT_NAME => 'MSC',
648: STATEMENT_TYPE => ad_ddl.create_table,
649: STATEMENT => sql_stmt1,

Line 654: msc_util.msc_log(sqlerrm);

650: OBJECT_NAME => l_temp_table(i));
651: EXCEPTION
652: WHEN others THEN
653:
654: msc_util.msc_log(sqlerrm);
655: msc_util.msc_log('Inside Exception of create table : ' ||l_temp_table(i));
656: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
657: APPLICATION_SHORT_NAME => 'MSC',
658: STATEMENT_TYPE => ad_ddl.drop_table,

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

651: EXCEPTION
652: WHEN others THEN
653:
654: msc_util.msc_log(sqlerrm);
655: msc_util.msc_log('Inside Exception of create table : ' ||l_temp_table(i));
656: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
657: APPLICATION_SHORT_NAME => 'MSC',
658: STATEMENT_TYPE => ad_ddl.drop_table,
659: STATEMENT => 'DROP TABLE ' || l_temp_table(i),

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

658: STATEMENT_TYPE => ad_ddl.drop_table,
659: STATEMENT => 'DROP TABLE ' || l_temp_table(i),
660: OBJECT_NAME => l_temp_table(i));
661:
662: msc_util.msc_log('After Drop table : ' ||l_temp_table(i));
663: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
664: APPLICATION_SHORT_NAME => 'MSC',
665: STATEMENT_TYPE => ad_ddl.create_table,
666: STATEMENT => sql_stmt1,

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

664: APPLICATION_SHORT_NAME => 'MSC',
665: STATEMENT_TYPE => ad_ddl.create_table,
666: STATEMENT => sql_stmt1,
667: OBJECT_NAME => l_temp_table(i));
668: msc_util.msc_log('After create table : ' ||l_temp_table(i));
669: END;
670:
671: BEGIN
672: msc_util.msc_log('Before create index : ' ||l_temp_table(i));

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

668: msc_util.msc_log('After create table : ' ||l_temp_table(i));
669: END;
670:
671: BEGIN
672: msc_util.msc_log('Before create index : ' ||l_temp_table(i));
673: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
674: APPLICATION_SHORT_NAME => 'MSC',
675: STATEMENT_TYPE => ad_ddl.create_index,
676: STATEMENT => sql_stmt2,

Line 681: msc_util.msc_log(sqlerrm);

677: OBJECT_NAME => l_temp_table(i));
678: EXCEPTION
679: WHEN others THEN
680:
681: msc_util.msc_log(sqlerrm);
682: msc_util.msc_log('Inside Exception of create index : ' ||l_temp_table(i));
683: --- bug 4156016: Raise exception so that we could error out gracefully
684: RAISE FND_API.G_EXC_ERROR;
685:

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

678: EXCEPTION
679: WHEN others THEN
680:
681: msc_util.msc_log(sqlerrm);
682: msc_util.msc_log('Inside Exception of create index : ' ||l_temp_table(i));
683: --- bug 4156016: Raise exception so that we could error out gracefully
684: RAISE FND_API.G_EXC_ERROR;
685:
686: END;

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

708: l_part_name(i) || ' with table ' || l_temp_table(i) ||
709: ' including indexes without validation';
710:
711: BEGIN
712: msc_util.msc_log('Before alter table : ' ||l_cur_table(i));
713: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
714: APPLICATION_SHORT_NAME => 'MSC',
715: STATEMENT_TYPE => ad_ddl.alter_table,
716: STATEMENT => sql_stmt1,

Line 721: msc_util.msc_log(sqlerrm);

717: OBJECT_NAME => l_cur_table(i));
718: EXCEPTION
719: WHEN others THEN
720:
721: msc_util.msc_log(sqlerrm);
722: msc_util.msc_log('Inside Exception of alter table : ' ||l_cur_table(i));
723: --- bug 4156016: Raise exception so that we could error out gracefully
724: RAISE FND_API.G_EXC_ERROR;
725:

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

718: EXCEPTION
719: WHEN others THEN
720:
721: msc_util.msc_log(sqlerrm);
722: msc_util.msc_log('Inside Exception of alter table : ' ||l_cur_table(i));
723: --- bug 4156016: Raise exception so that we could error out gracefully
724: RAISE FND_API.G_EXC_ERROR;
725:
726: END;

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

727:
728: sql_stmt2 := 'DROP TABLE ' || l_temp_table(i);
729:
730: BEGIN
731: msc_util.msc_log('Before drop table : ' ||l_temp_table(i));
732: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
733: APPLICATION_SHORT_NAME => 'MSC',
734: STATEMENT_TYPE => ad_ddl.drop_table,
735: STATEMENT => sql_stmt2,

Line 740: msc_util.msc_log(sqlerrm);

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

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

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

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

747: i := l_cur_table.NEXT(i);
748: END LOOP; -- WHILE i IS NOT NULL LOOP
749:
750: RETCODE:= G_SUCCESS;
751: msc_util.msc_log('End REFRESH_MVIEW');
752: EXCEPTION
753: WHEN OTHERS THEN
754: msc_util.msc_log(sqlerrm);
755: msc_util.msc_log('Inside Main Exception');

Line 754: msc_util.msc_log(sqlerrm);

750: RETCODE:= G_SUCCESS;
751: msc_util.msc_log('End REFRESH_MVIEW');
752: EXCEPTION
753: WHEN OTHERS THEN
754: msc_util.msc_log(sqlerrm);
755: msc_util.msc_log('Inside Main Exception');
756: --bug 4156016: Set the error code here so that if an unhandled eception occurs in
757: --- exception block then atleast the program will error out.
758: RETCODE:= G_ERROR;

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

751: msc_util.msc_log('End REFRESH_MVIEW');
752: EXCEPTION
753: WHEN OTHERS THEN
754: msc_util.msc_log(sqlerrm);
755: msc_util.msc_log('Inside Main Exception');
756: --bug 4156016: Set the error code here so that if an unhandled eception occurs in
757: --- exception block then atleast the program will error out.
758: RETCODE:= G_ERROR;
759: ERRBUF:= SQLERRM;

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

769: STATEMENT => sql_stmt2,
770: OBJECT_NAME => l_temp_table(i));
771: EXCEPTION
772: WHEN OTHERS THEN
773: msc_util.msc_log('Error in droping table ' || l_temp_table(i));
774: END;
775:
776: i := l_temp_table.NEXT(i);
777: END LOOP; -- WHILE i IS NOT NULL LOOP