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.AS_SC_DENORM dependencies on AS_UTILITY_PVT

Line 34: AS_UTILITY_PVT.Debug_Message(p_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, p_mssg);

30:
31: --IF G_Debug AND p_debug_source = G_DEBUG_TRIGGER THEN
32: -- Write debug message to message stack
33: IF l_debug THEN
34: AS_UTILITY_PVT.Debug_Message(p_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, p_mssg);
35: END IF;
36: --END IF;
37:
38: IF p_debug_source = G_DEBUG_CONCURRENT THEN

Line 768: --Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'DEGREE OF PARALLELISM used: '||as_utility_pvt.get_degree_parallelism);

764: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'PREFERRED_CURRENCY used: '||G_PREFERRED_CURRENCY);
765: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'CONVERSION_TYPE used: '||G_CONVERSION_TYPE);
766: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'PERIOD_TYPE used: '||G_PERIOD_TYPE);
767: --Code commented as per suggestion given in bug#5802537 by Lester
768: --Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'DEGREE OF PARALLELISM used: '||as_utility_pvt.get_degree_parallelism);
769: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
770: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_SALES_CREDITS_DENORM';
771: clear_snapshots;
772: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Capturing Index Definitions');

Line 773: as_utility_pvt.capture_index_definitions(ERRBUF,RETCODE,'AS_SALES_CREDITS_DENORM',l_oracle_schema);

769: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
770: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_SALES_CREDITS_DENORM';
771: clear_snapshots;
772: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Capturing Index Definitions');
773: as_utility_pvt.capture_index_definitions(ERRBUF,RETCODE,'AS_SALES_CREDITS_DENORM',l_oracle_schema);
774: IF (RETCODE = 0) THEN
775: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Droping indexes on AS_SALES_CREDITS_DENORM');
776: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'DROP','AS_SALES_CREDITS_DENORM',l_oracle_schema);
777: COMMIT;

Line 776: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'DROP','AS_SALES_CREDITS_DENORM',l_oracle_schema);

772: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Capturing Index Definitions');
773: as_utility_pvt.capture_index_definitions(ERRBUF,RETCODE,'AS_SALES_CREDITS_DENORM',l_oracle_schema);
774: IF (RETCODE = 0) THEN
775: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Droping indexes on AS_SALES_CREDITS_DENORM');
776: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'DROP','AS_SALES_CREDITS_DENORM',l_oracle_schema);
777: COMMIT;
778: END IF;
779: IF (RETCODE = 0) THEN
780: insert_scd (ERRBUF, RETCODE, l_scd_cnt);

Line 785: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'BUILD','AS_SALES_CREDITS_DENORM',l_oracle_schema);

781: COMMIT;
782: END IF;
783: IF (RETCODE = 0) THEN
784: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Building indexes on AS_SALES_CREDITS_DENORM');
785: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'BUILD','AS_SALES_CREDITS_DENORM',l_oracle_schema);
786: COMMIT;
787: END IF;
788: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Total records inserted into AS_SALES_CREDITS_DENORMS = ' || l_scd_cnt);
789: ELSIF (p_mode = 2) THEN