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.BSC_METADATA_OPTIMIZER_PKG dependencies on FND_LOG

Line 14: BSC_MO_HELPER_PKG.writeTmp('Going to drop '||l_table_name , FND_LOG.LEVEL_STATEMENT, false);

10: l_table_name varchar2(30) := g_filtered_indics;
11: BEGIN
12: l_stmt := 'drop table '||l_table_name ;
13: begin
14: BSC_MO_HELPER_PKG.writeTmp('Going to drop '||l_table_name , FND_LOG.LEVEL_STATEMENT, false);
15: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.drop_table, l_table_name);
16: exception when others then
17: null;
18: --BSC_MO_HELPER_PKG.writeTmp(l_table_name ||' does not exist... ignoring error while trying to drop');

Line 32: BSC_MO_HELPER_PKG.writeTmp('Going to create '||l_table_name , FND_LOG.LEVEL_STATEMENT, false);

28: AND K.INDICATOR = kpi.indicator
29: --AND K.DIM_SET_ID = dimset.dim_set_id
30: AND UPPER(S.LEVEL_VIEW_NAME) <> UPPER(K.LEVEL_VIEW_NAME)
31: AND K.STATUS = 2 ';
32: BSC_MO_HELPER_PKG.writeTmp('Going to create '||l_table_name , FND_LOG.LEVEL_STATEMENT, false);
33: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.create_table, l_table_name);
34: l_stmt := 'create unique index '||l_table_name||'_u1 on '||l_table_name ||'(indicator, dim_set_id, level_pk_col)';
35: l_stmt := l_stmt ||' TABLESPACE '|| BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName||' '|| BSC_METADATA_OPTIMIZER_PKG.gStorageClause;
36: BSC_MO_HELPER_PKG.writeTmp('Going to create '||l_table_name ||'_u1', FND_LOG.LEVEL_STATEMENT, false);

Line 36: BSC_MO_HELPER_PKG.writeTmp('Going to create '||l_table_name ||'_u1', FND_LOG.LEVEL_STATEMENT, false);

32: BSC_MO_HELPER_PKG.writeTmp('Going to create '||l_table_name , FND_LOG.LEVEL_STATEMENT, false);
33: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.create_table, l_table_name);
34: l_stmt := 'create unique index '||l_table_name||'_u1 on '||l_table_name ||'(indicator, dim_set_id, level_pk_col)';
35: l_stmt := l_stmt ||' TABLESPACE '|| BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName||' '|| BSC_METADATA_OPTIMIZER_PKG.gStorageClause;
36: BSC_MO_HELPER_PKG.writeTmp('Going to create '||l_table_name ||'_u1', FND_LOG.LEVEL_STATEMENT, false);
37: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.create_index, l_table_name ||'_u1');
38:
39: END;
40:

Line 71: ||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);

67: BEGIN
68: return;
69: /*
70: bsc_mo_helper_pkg.writeTmp( 'Starting writeTableCounts, System time is '
71: ||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
72: SELECT count(1) INTO l_num
73: FROM bsc_db_tables
74: WHERE table_name like 'BSC_I_%';
75: bsc_mo_helper_pkg.writeTmp('No. of I tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);

Line 75: bsc_mo_helper_pkg.writeTmp('No. of I tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);

71: ||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
72: SELECT count(1) INTO l_num
73: FROM bsc_db_tables
74: WHERE table_name like 'BSC_I_%';
75: bsc_mo_helper_pkg.writeTmp('No. of I tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
76: SELECT count(1)INTO l_num
77: FROM bsc_db_tables
78: WHERE table_name like 'BSC_B_%';
79: bsc_mo_helper_pkg.writeTmp('No. of B tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);

Line 79: bsc_mo_helper_pkg.writeTmp('No. of B tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);

75: bsc_mo_helper_pkg.writeTmp('No. of I tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
76: SELECT count(1)INTO l_num
77: FROM bsc_db_tables
78: WHERE table_name like 'BSC_B_%';
79: bsc_mo_helper_pkg.writeTmp('No. of B tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
80: SELECT count(1)INTO l_num
81: FROM bsc_db_tables
82: WHERE table_name like 'BSC_T_%';
83: bsc_mo_helper_pkg.writeTmp('No. of T tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);

Line 83: bsc_mo_helper_pkg.writeTmp('No. of T tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);

79: bsc_mo_helper_pkg.writeTmp('No. of B tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
80: SELECT count(1)INTO l_num
81: FROM bsc_db_tables
82: WHERE table_name like 'BSC_T_%';
83: bsc_mo_helper_pkg.writeTmp('No. of T tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
84: SELECT count(1) INTO l_num
85: FROM bsc_db_tables
86: WHERE table_name like 'BSC_S_%';
87: bsc_mo_helper_pkg.writeTmp('No. of S tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);

Line 87: bsc_mo_helper_pkg.writeTmp('No. of S tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);

83: bsc_mo_helper_pkg.writeTmp('No. of T tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
84: SELECT count(1) INTO l_num
85: FROM bsc_db_tables
86: WHERE table_name like 'BSC_S_%';
87: bsc_mo_helper_pkg.writeTmp('No. of S tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
88: bsc_mo_helper_pkg.writeTmp(bsc_mo_helper_pkg.get_time||' Indicators with no rows in BSC_DB_tables : ', FND_LOG.LEVEL_STATEMENT, true);
89: OPEN cv for l_stmt;
90: LOOP
91: FETCH cv INTO l_num;

Line 88: bsc_mo_helper_pkg.writeTmp(bsc_mo_helper_pkg.get_time||' Indicators with no rows in BSC_DB_tables : ', FND_LOG.LEVEL_STATEMENT, true);

84: SELECT count(1) INTO l_num
85: FROM bsc_db_tables
86: WHERE table_name like 'BSC_S_%';
87: bsc_mo_helper_pkg.writeTmp('No. of S tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
88: bsc_mo_helper_pkg.writeTmp(bsc_mo_helper_pkg.get_time||' Indicators with no rows in BSC_DB_tables : ', FND_LOG.LEVEL_STATEMENT, true);
89: OPEN cv for l_stmt;
90: LOOP
91: FETCH cv INTO l_num;
92: EXIT WHEN cv%NOTFOUND;

Line 96: bsc_mo_helper_pkg.writeTmp(l_problem_indics, FND_LOG.LEVEL_STATEMENT, true);

92: EXIT WHEN cv%NOTFOUND;
93: l_count:= l_count + 1;
94: l_problem_indics := l_problem_indics||', '||l_num;
95: IF (l_count = 15) THEN
96: bsc_mo_helper_pkg.writeTmp(l_problem_indics, FND_LOG.LEVEL_STATEMENT, true);
97: l_count := 0;
98: l_problem_indics := null;
99: END IF;
100: END LOOP;

Line 103: bsc_mo_helper_pkg.writeTmp(l_problem_indics, FND_LOG.LEVEL_STATEMENT, true);

99: END IF;
100: END LOOP;
101: close cv;
102: if (l_count > 0 ) THEN
103: bsc_mo_helper_pkg.writeTmp(l_problem_indics, FND_LOG.LEVEL_STATEMENT, true);
104: end if;
105: bsc_mo_helper_pkg.writeTmp( 'Done writeTableCounts, System time is '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
106: */
107: END;

Line 105: bsc_mo_helper_pkg.writeTmp( 'Done writeTableCounts, System time is '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);

101: close cv;
102: if (l_count > 0 ) THEN
103: bsc_mo_helper_pkg.writeTmp(l_problem_indics, FND_LOG.LEVEL_STATEMENT, true);
104: end if;
105: bsc_mo_helper_pkg.writeTmp( 'Done writeTableCounts, System time is '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
106: */
107: END;
108:
109: Function getUtlFileDir return VARCHAR2 IS

Line 184: bsc_mo_helper_pkg.writeTmp('Inside InitLanguages', FND_LOG.LEVEL_PROCEDURE);

180: WHERE INSTALLED_FLAG IN ('I', 'B');
181:
182: BEGIN
183: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
184: bsc_mo_helper_pkg.writeTmp('Inside InitLanguages', FND_LOG.LEVEL_PROCEDURE);
185: END IF;
186: gNumInstalled_Languages := 0;
187: OPEN c1;
188: FETCH c1 INTO gNLSLang;

Line 202: bsc_mo_helper_pkg.writeTmp('Compl InitLanguages', FND_LOG.LEVEL_PROCEDURE);

198: End If ;
199: END LOOP;
200: close cLangs;
201: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
202: bsc_mo_helper_pkg.writeTmp('Compl InitLanguages', FND_LOG.LEVEL_PROCEDURE);
203: bsc_mo_helper_pkg.writeTmp('gInstalled_Languages IS', FND_LOG.LEVEL_STATEMENT);
204: bsc_mo_helper_pkg.write_this(gInstalled_Languages, FND_LOG.LEVEL_STATEMENT);
205: END IF;
206: EXCEPTION WHEN others then

Line 203: bsc_mo_helper_pkg.writeTmp('gInstalled_Languages IS', FND_LOG.LEVEL_STATEMENT);

199: END LOOP;
200: close cLangs;
201: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
202: bsc_mo_helper_pkg.writeTmp('Compl InitLanguages', FND_LOG.LEVEL_PROCEDURE);
203: bsc_mo_helper_pkg.writeTmp('gInstalled_Languages IS', FND_LOG.LEVEL_STATEMENT);
204: bsc_mo_helper_pkg.write_this(gInstalled_Languages, FND_LOG.LEVEL_STATEMENT);
205: END IF;
206: EXCEPTION WHEN others then
207: bsc_mo_helper_pkg.writeTmp('EXCEPTION in InitLanguages:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

Line 204: bsc_mo_helper_pkg.write_this(gInstalled_Languages, FND_LOG.LEVEL_STATEMENT);

200: close cLangs;
201: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
202: bsc_mo_helper_pkg.writeTmp('Compl InitLanguages', FND_LOG.LEVEL_PROCEDURE);
203: bsc_mo_helper_pkg.writeTmp('gInstalled_Languages IS', FND_LOG.LEVEL_STATEMENT);
204: bsc_mo_helper_pkg.write_this(gInstalled_Languages, FND_LOG.LEVEL_STATEMENT);
205: END IF;
206: EXCEPTION WHEN others then
207: bsc_mo_helper_pkg.writeTmp('EXCEPTION in InitLanguages:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
208: RAISE;

Line 207: bsc_mo_helper_pkg.writeTmp('EXCEPTION in InitLanguages:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

203: bsc_mo_helper_pkg.writeTmp('gInstalled_Languages IS', FND_LOG.LEVEL_STATEMENT);
204: bsc_mo_helper_pkg.write_this(gInstalled_Languages, FND_LOG.LEVEL_STATEMENT);
205: END IF;
206: EXCEPTION WHEN others then
207: bsc_mo_helper_pkg.writeTmp('EXCEPTION in InitLanguages:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
208: RAISE;
209: END;
210:
211: PROCEDURE InitReservedFunctions IS

Line 223: bsc_mo_helper_pkg.writeTmp('Inside InitReservedFunctions', FND_LOG.LEVEL_PROCEDURE);

219: IF (gNumReservedFunctions >0 and gNumReservedOperators >0) THEN
220: return;
221: END IF;
222: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
223: bsc_mo_helper_pkg.writeTmp('Inside InitReservedFunctions', FND_LOG.LEVEL_PROCEDURE);
224: END IF;
225: l_stmt := 'SELECT WORD FROM BSC_DB_RESERVED_WORDS WHERE WORD IS NOT NULL AND TYPE = 1';
226: gNumReservedFunctions := 0;
227:

Line 252: bsc_mo_helper_pkg.writeTmp('Compl InitReservedFunctions', FND_LOG.LEVEL_PROCEDURE);--commit;

248:
249: END LOOP;
250: CLOSE CV;
251: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
252: bsc_mo_helper_pkg.writeTmp('Compl InitReservedFunctions', FND_LOG.LEVEL_PROCEDURE);--commit;
253: bsc_mo_helper_pkg.writeTmp( 'gReservedOperators are', FND_LOG.LEVEL_STATEMENT);
254: bsc_mo_helper_pkg.write_this(gReservedOperators, FND_LOG.LEVEL_STATEMENT);
255: END IF;
256:

Line 253: bsc_mo_helper_pkg.writeTmp( 'gReservedOperators are', FND_LOG.LEVEL_STATEMENT);

249: END LOOP;
250: CLOSE CV;
251: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
252: bsc_mo_helper_pkg.writeTmp('Compl InitReservedFunctions', FND_LOG.LEVEL_PROCEDURE);--commit;
253: bsc_mo_helper_pkg.writeTmp( 'gReservedOperators are', FND_LOG.LEVEL_STATEMENT);
254: bsc_mo_helper_pkg.write_this(gReservedOperators, FND_LOG.LEVEL_STATEMENT);
255: END IF;
256:
257: EXCEPTION WHEN others then

Line 254: bsc_mo_helper_pkg.write_this(gReservedOperators, FND_LOG.LEVEL_STATEMENT);

250: CLOSE CV;
251: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
252: bsc_mo_helper_pkg.writeTmp('Compl InitReservedFunctions', FND_LOG.LEVEL_PROCEDURE);--commit;
253: bsc_mo_helper_pkg.writeTmp( 'gReservedOperators are', FND_LOG.LEVEL_STATEMENT);
254: bsc_mo_helper_pkg.write_this(gReservedOperators, FND_LOG.LEVEL_STATEMENT);
255: END IF;
256:
257: EXCEPTION WHEN others then
258: bsc_mo_helper_pkg.writeTmp('EXCEPTION in InitReservedFunctions', FND_LOG.LEVEL_UNEXPECTED, TRUE);

Line 258: bsc_mo_helper_pkg.writeTmp('EXCEPTION in InitReservedFunctions', FND_LOG.LEVEL_UNEXPECTED, TRUE);

254: bsc_mo_helper_pkg.write_this(gReservedOperators, FND_LOG.LEVEL_STATEMENT);
255: END IF;
256:
257: EXCEPTION WHEN others then
258: bsc_mo_helper_pkg.writeTmp('EXCEPTION in InitReservedFunctions', FND_LOG.LEVEL_UNEXPECTED, TRUE);
259: RAISE;
260: END;
261:
262:

Line 274: bsc_mo_helper_pkg.writeTmp('EXCEPTION in logProgress'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

270: values (USERENV('SESSIONID'), -200, g_progressCounter,
271: pStage||' '||pMessage||' '||bsc_mo_helper_pkg.get_time);
272: commit;
273: EXCEPTION WHEN others then
274: bsc_mo_helper_pkg.writeTmp('EXCEPTION in logProgress'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
275: RAISE;
276: END;
277:
278: function is_totally_shared_obj(p_objective in number) return boolean is

Line 336: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);

332: l_dummy1 varchar2(1000);
333: l_dummy2 varchar2(1000);
334: BEGIN
335: bsc_mo_helper_pkg.writeTmp('Inside GenerateActualization, system time is '||
336: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
337: bsc_mo_helper_pkg.writeTmp('Starting InitializePeriodicities, system time is '||
338: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
339: logProgress('INIT', 'Starting InitializePeriodicities');
340: BSC_MO_HELPER_PKG.InitializePeriodicities;

Line 338: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);

334: BEGIN
335: bsc_mo_helper_pkg.writeTmp('Inside GenerateActualization, system time is '||
336: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
337: bsc_mo_helper_pkg.writeTmp('Starting InitializePeriodicities, system time is '||
338: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
339: logProgress('INIT', 'Starting InitializePeriodicities');
340: BSC_MO_HELPER_PKG.InitializePeriodicities;
341: IF (g_retcode = 0) THEN
342: logProgress('INIT', 'Completed InitializePeriodicities');

Line 348: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);

344: logProgress('INIT', 'InitializePeriodicities return code='||g_retcode||', so quitting');
345: return;
346: END IF;
347: bsc_mo_helper_pkg.writeTmp('Starting InitializeCalendars, system time is '||
348: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
349: logProgress('INIT', 'Starting InitializeCalendars');
350: BSC_MO_HELPER_PKG.InitializeCalendars;
351: logProgress('INIT', 'Completed InitializeCalendars');
352: IF (g_retcode = 0) THEN

Line 366: bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);

362: logProgress('INIT', 'Starting CreateLastTables');
363: bsc_mo_helper_pkg.CreateLastTables;
364: logProgress('INIT', 'Completed CreateLastTables');
365: bsc_mo_helper_pkg.writeTmp('Done with createLastTables, system time is '||
366: bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
367: --Initialize array of old kpis and old base tables.
368: --This is done based on _LAST tables.
369: logProgress('INIT', 'Starting InitInfoOldSystem');
370: bsc_mo_helper_pkg.writeTmp('Starting InitInfoOldSystem, system time is '||

Line 371: bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);

367: --Initialize array of old kpis and old base tables.
368: --This is done based on _LAST tables.
369: logProgress('INIT', 'Starting InitInfoOldSystem');
370: bsc_mo_helper_pkg.writeTmp('Starting InitInfoOldSystem, system time is '||
371: bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
372: bsc_mo_helper_pkg.InitInfoOldSystem;
373: bsc_mo_helper_pkg.writeTmp('Done InitInfoOldSystem, system time is '||
374: bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
375: logProgress('INIT', 'Completed InitInfoOldSystem');

Line 374: bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);

370: bsc_mo_helper_pkg.writeTmp('Starting InitInfoOldSystem, system time is '||
371: bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
372: bsc_mo_helper_pkg.InitInfoOldSystem;
373: bsc_mo_helper_pkg.writeTmp('Done InitInfoOldSystem, system time is '||
374: bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
375: logProgress('INIT', 'Completed InitInfoOldSystem');
376: End If;
377: writeTableCounts;
378: bsc_mo_helper_pkg.writeTmp('Calling deletePreviousRunTables, system time is '||

Line 379: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);

375: logProgress('INIT', 'Completed InitInfoOldSystem');
376: End If;
377: writeTableCounts;
378: bsc_mo_helper_pkg.writeTmp('Calling deletePreviousRunTables, system time is '||
379: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
380: logProgress('INIT', 'Starting deletePreviousRunTables');
381: bsc_mo_helper_pkg.deletePreviousRunTables;
382: logProgress('INIT', 'Completed deletePreviousRunTables');
383: bsc_mo_helper_pkg.writeTmp('Done with deletePreviousRunTables, system time is '||

Line 384: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE);

380: logProgress('INIT', 'Starting deletePreviousRunTables');
381: bsc_mo_helper_pkg.deletePreviousRunTables;
382: logProgress('INIT', 'Completed deletePreviousRunTables');
383: bsc_mo_helper_pkg.writeTmp('Done with deletePreviousRunTables, system time is '||
384: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE);
385: writeTableCounts;
386: ------------------------------------------------------------
387: --Indicator Tables
388: --BSC-MV Note: Process indicator tables when there is structural changes

Line 391: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);

387: --Indicator Tables
388: --BSC-MV Note: Process indicator tables when there is structural changes
389: --or when there is summarization level change
390: bsc_mo_helper_pkg.writeTmp('Starting Indicator tables, system time is '||
391: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
392: logProgress('INDICATORS', 'Starting IndicatorTables');
393: BSC_MO_INDICATOR_PKG.IndicatorTables;
394: logProgress('INDICATORS', 'Completed IndicatorTables');
395: bsc_mo_helper_pkg.writeTmp('Done with Indicator tables, system time is '||

Line 396: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);

392: logProgress('INDICATORS', 'Starting IndicatorTables');
393: BSC_MO_INDICATOR_PKG.IndicatorTables;
394: logProgress('INDICATORS', 'Completed IndicatorTables');
395: bsc_mo_helper_pkg.writeTmp('Done with Indicator tables, system time is '||
396: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
397: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
398: bsc_mo_helper_pkg.writeTmp( newline||newline, FND_LOG.LEVEL_STATEMENT);
399: bsc_mo_helper_pkg.writeTmp( 'gTables is ', FND_LOG.LEVEL_STATEMENT);
400: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT);

Line 398: bsc_mo_helper_pkg.writeTmp( newline||newline, FND_LOG.LEVEL_STATEMENT);

394: logProgress('INDICATORS', 'Completed IndicatorTables');
395: bsc_mo_helper_pkg.writeTmp('Done with Indicator tables, system time is '||
396: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
397: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
398: bsc_mo_helper_pkg.writeTmp( newline||newline, FND_LOG.LEVEL_STATEMENT);
399: bsc_mo_helper_pkg.writeTmp( 'gTables is ', FND_LOG.LEVEL_STATEMENT);
400: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT);
401: bsc_mo_helper_pkg.writeTmp( newline||newline, FND_LOG.LEVEL_STATEMENT);
402: END IF;

Line 399: bsc_mo_helper_pkg.writeTmp( 'gTables is ', FND_LOG.LEVEL_STATEMENT);

395: bsc_mo_helper_pkg.writeTmp('Done with Indicator tables, system time is '||
396: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
397: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
398: bsc_mo_helper_pkg.writeTmp( newline||newline, FND_LOG.LEVEL_STATEMENT);
399: bsc_mo_helper_pkg.writeTmp( 'gTables is ', FND_LOG.LEVEL_STATEMENT);
400: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT);
401: bsc_mo_helper_pkg.writeTmp( newline||newline, FND_LOG.LEVEL_STATEMENT);
402: END IF;
403: ------------------------------------------------------------

Line 400: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT);

396: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
397: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
398: bsc_mo_helper_pkg.writeTmp( newline||newline, FND_LOG.LEVEL_STATEMENT);
399: bsc_mo_helper_pkg.writeTmp( 'gTables is ', FND_LOG.LEVEL_STATEMENT);
400: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT);
401: bsc_mo_helper_pkg.writeTmp( newline||newline, FND_LOG.LEVEL_STATEMENT);
402: END IF;
403: ------------------------------------------------------------
404: --Input tables

Line 401: bsc_mo_helper_pkg.writeTmp( newline||newline, FND_LOG.LEVEL_STATEMENT);

397: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
398: bsc_mo_helper_pkg.writeTmp( newline||newline, FND_LOG.LEVEL_STATEMENT);
399: bsc_mo_helper_pkg.writeTmp( 'gTables is ', FND_LOG.LEVEL_STATEMENT);
400: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT);
401: bsc_mo_helper_pkg.writeTmp( newline||newline, FND_LOG.LEVEL_STATEMENT);
402: END IF;
403: ------------------------------------------------------------
404: --Input tables
405: --BSC-MV Note: We need to process input tables when there is structural changes

Line 408: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);

404: --Input tables
405: --BSC-MV Note: We need to process input tables when there is structural changes
406: --or when there is summarization level change (upgrade case only)
407: bsc_mo_helper_pkg.writeTmp('Starting InputTables in GenerateActualization, system time is '||
408: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
409:
410: logProgress('INPUT', 'Starting InputTables');
411: BSC_MO_INPUT_TABLE_PKG.InputTables;
412: logProgress('INPUT', 'Completed InputTables');

Line 414: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);

410: logProgress('INPUT', 'Starting InputTables');
411: BSC_MO_INPUT_TABLE_PKG.InputTables;
412: logProgress('INPUT', 'Completed InputTables');
413: bsc_mo_helper_pkg.writeTmp('Done with InputTables in GenerateActualization, system time is '||
414: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
415: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
416: bsc_mo_helper_pkg.writeTmp( 'gTables is ', FND_LOG.LEVEL_STATEMENT, false);
417: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT, false, true);
418: bsc_mo_helper_pkg.writeTmp( ' ');

Line 416: bsc_mo_helper_pkg.writeTmp( 'gTables is ', FND_LOG.LEVEL_STATEMENT, false);

412: logProgress('INPUT', 'Completed InputTables');
413: bsc_mo_helper_pkg.writeTmp('Done with InputTables in GenerateActualization, system time is '||
414: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
415: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
416: bsc_mo_helper_pkg.writeTmp( 'gTables is ', FND_LOG.LEVEL_STATEMENT, false);
417: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT, false, true);
418: bsc_mo_helper_pkg.writeTmp( ' ');
419: END IF;
420: ------------------------------------------------------------

Line 417: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT, false, true);

413: bsc_mo_helper_pkg.writeTmp('Done with InputTables in GenerateActualization, system time is '||
414: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
415: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
416: bsc_mo_helper_pkg.writeTmp( 'gTables is ', FND_LOG.LEVEL_STATEMENT, false);
417: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT, false, true);
418: bsc_mo_helper_pkg.writeTmp( ' ');
419: END IF;
420: ------------------------------------------------------------
421: --Loader Configuration

Line 423: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);

419: END IF;
420: ------------------------------------------------------------
421: --Loader Configuration
422: bsc_mo_helper_pkg.writeTmp('Starting Loader Configuration, system time is '||
423: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
424: --BSC-MV Note: We need to configure loader when there is structural changes
425: --or when there is summarization level change (upgrade case only)
426:
427: logProgress('CONFIG', 'Starting Loader Configuration');

Line 432: FND_LOG.LEVEL_STATEMENT, true);

428: BSC_MO_LOADER_CONFIG_PKG.ConfigureActualization;
429: logProgress('CONFIG', 'Completed Loader Configuration');
430: bsc_mo_helper_pkg.writeTmp('Done Loader Configuration... '||
431: 'checking for incremental changes, system time is '||bsc_mo_helper_pkg.get_time,
432: FND_LOG.LEVEL_STATEMENT, true);
433:
434: If gGAA_RUN_MODE <> 0 Then -- incremental
435: IF (gIndicators.count>0 ) THEN
436: i := gIndicators.first;

Line 441: bsc_mo_helper_pkg.writeTmp( 'Has non structural change, calling ReConfigureUploadFieldsIndic', FND_LOG.LEVEL_STATEMENT);

437: LOOP
438: Indic := gIndicators(i);
439: If Indic.Action_Flag = 4 Then
440: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
441: bsc_mo_helper_pkg.writeTmp( 'Has non structural change, calling ReConfigureUploadFieldsIndic', FND_LOG.LEVEL_STATEMENT);
442: END IF;
443: BSC_MO_LOADER_CONFIG_PKG.ReConfigureUploadFieldsIndic (Indic.Code);
444:
445: --EDW Note: The materialize views are created taking rollup

Line 459: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);

455: END IF;
456: End If;
457: logProgress('CONFIG', 'Completed All of ConfigureActualization');
458: bsc_mo_helper_pkg.writeTmp('Done Loader Configuration, system time is '||
459: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
460: writeTableCounts;
461: logProgress('MISC', 'Starting drop_unused_columns');
462: IF BSC_METADATA_OPTIMIZER_PKG.gSYSTEM_STAGE = 2 THEN
463: bsc_mo_helper_pkg.writeTmp('Starting drop_unused_columns');

Line 471: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);

467: -- Adjustments
468: --BSC-MV Note: Process indicators when there is structural changes
469: --or when there is summarization level change
470: bsc_mo_helper_pkg.writeTmp('Starting Corrections, system time is '||
471: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
472:
473: logProgress('MISC', 'Starting Corrections');
474: BSC_MO_LOADER_CONFIG_PKG.Corrections;
475: logProgress('MISC', 'Completed Corrections');

Line 477: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);

473: logProgress('MISC', 'Starting Corrections');
474: BSC_MO_LOADER_CONFIG_PKG.Corrections;
475: logProgress('MISC', 'Completed Corrections');
476: bsc_mo_helper_pkg.writeTmp('Done with Corrections, system time is '||
477: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
478: writetableCounts;
479:
480: --Create tables in the database
481: --BSC-MV Note: Process tables when there is structural changes

Line 484: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);

480: --Create tables in the database
481: --BSC-MV Note: Process tables when there is structural changes
482: --or when there is summarization level change
483: bsc_mo_helper_pkg.writeTmp('Starting CreateAllTables,system time is '||
484: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
485: logProgress('DB', 'Starting CreateAllTables');
486: BSC_MO_DB_PKG.CreateAllTables;
487: logProgress('DB', 'Completed CreateAllTables');
488: bsc_mo_helper_pkg.writeTmp('Done with CreateAllTables, system time is '||

Line 489: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);

485: logProgress('DB', 'Starting CreateAllTables');
486: BSC_MO_DB_PKG.CreateAllTables;
487: logProgress('DB', 'Completed CreateAllTables');
488: bsc_mo_helper_pkg.writeTmp('Done with CreateAllTables, system time is '||
489: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
490: writetableCounts;
491: --Initialize year
492: --bug#3426728 Need to run reporting calendar before creating MVs
493: bsc_mo_helper_pkg.writeTmp('Initializing year', FND_LOG.LEVEL_STATEMENT, true);

Line 493: bsc_mo_helper_pkg.writeTmp('Initializing year', FND_LOG.LEVEL_STATEMENT, true);

489: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
490: writetableCounts;
491: --Initialize year
492: --bug#3426728 Need to run reporting calendar before creating MVs
493: bsc_mo_helper_pkg.writeTmp('Initializing year', FND_LOG.LEVEL_STATEMENT, true);
494: logProgress('MISC', 'Starting InitializeYear');
495: BSC_MO_HELPER_PKG.InitializeYear;
496: logProgress('MISC', 'Completed InitializeYear');
497: writetableCounts;

Line 507: bsc_mo_helper_pkg.writeTmp('Drop reporting key global temporary tables', FND_LOG.LEVEL_STATEMENT, true);

503: logProgress('MISC', 'Completed Load_Reporting_Calendar');
504: END IF;
505: --BSC-MV Note: Drop reporting key global temporary tables
506: If g_BSC_MV Then
507: bsc_mo_helper_pkg.writeTmp('Drop reporting key global temporary tables', FND_LOG.LEVEL_STATEMENT, true);
508: logProgress('MISC', 'Drop reporting key global temporary tables');
509: BSC_BIA_WRAPPER.Drop_Rpt_Key_Table_VB(NULL);
510: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Rpt_Key_Table_VB');
511: writetableCounts;

Line 522: BSC_MO_HELPER_PKG.TerminateWithMsg('EXCEPTION in bsc_update_dim.create_dbi_dim_tables : '||l_error, FND_LOG.LEVEL_UNEXPECTED);

518: -- Create DBI Dimension tables.
519: -- Added 03/14/2005 for AW project
520: IF NOT bsc_update_dim.create_dbi_dim_tables(l_error) THEN
521: logprogress('ERROR', 'Exception in bsc_update_dim.create_dbi_dim_tables');
522: BSC_MO_HELPER_PKG.TerminateWithMsg('EXCEPTION in bsc_update_dim.create_dbi_dim_tables : '||l_error, FND_LOG.LEVEL_UNEXPECTED);
523: raise optimizer_exception;
524: END IF;
525: bsc_mo_helper_pkg.writeTmp('Create MVs for all Indicators', FND_LOG.LEVEL_STATEMENT, true);
526: logProgress('DB', 'Starting CreateMVs');

Line 525: bsc_mo_helper_pkg.writeTmp('Create MVs for all Indicators', FND_LOG.LEVEL_STATEMENT, true);

521: logprogress('ERROR', 'Exception in bsc_update_dim.create_dbi_dim_tables');
522: BSC_MO_HELPER_PKG.TerminateWithMsg('EXCEPTION in bsc_update_dim.create_dbi_dim_tables : '||l_error, FND_LOG.LEVEL_UNEXPECTED);
523: raise optimizer_exception;
524: END IF;
525: bsc_mo_helper_pkg.writeTmp('Create MVs for all Indicators', FND_LOG.LEVEL_STATEMENT, true);
526: logProgress('DB', 'Starting CreateMVs');
527: writetableCounts;
528: --For kpis with structural changes or non-structural changes
529: --Also create MVs when summarization level has changed

Line 532: bsc_mo_helper_pkg.writeTmp('Total indics = '||gIndicators.count, FND_LOG.LEVEL_PROCEDURE);

528: --For kpis with structural changes or non-structural changes
529: --Also create MVs when summarization level has changed
530: l_count := gIndicators.first;
531: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
532: bsc_mo_helper_pkg.writeTmp('Total indics = '||gIndicators.count, FND_LOG.LEVEL_PROCEDURE);
533: END IF;
534:
535: LOOP
536: EXIT WHEN gIndicators.count = 0;

Line 553: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, false);

549: advSumLevel := to_number(g_Adv_Summarization_Level);
550: --BSC-MV Note: If the change is only the summarization level (example from 2 to 3)
551: --we pass pass Reset MV Levels in TRUE
552: bsc_mo_helper_pkg.writeTmp('Calling Create MV for Indicator '||Indic.code||', Time is '||
553: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, false);
554: logProgress('MV', 'Creating MV for '||Indic.code);
555: If Indic.Action_Flag = 0 And g_Sum_Level_Change = 2 Then
556: BSC_BIA_WRAPPER.Implement_Bsc_MV_VB(indic.code, advSumLevel, TRUE);
557: Else

Line 589: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);

585: --This situation should not happen, but due to some unkown issue in the past
586: --some tables could be there but no indicator is using it.
587:
588: bsc_mo_helper_pkg.writeTmp('Starting CleanDatabase, system time is '||
589: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
590: logProgress('MISC', 'Starting CleanDatabase');
591: BSC_MO_HELPER_PKG.CleanDatabase;
592: logProgress('MISC', 'Completed CleanDatabase');
593: writeTableCounts;

Line 597: FND_LOG.LEVEL_STATEMENT, true);

593: writeTableCounts;
594:
595: --Generate documentation
596: bsc_mo_helper_pkg.writeTmp('Starting Doc, system time is '||bsc_mo_helper_pkg.get_time,
597: FND_LOG.LEVEL_STATEMENT, true);
598: logProgress('DOC', 'Starting Doc');
599: BSC_MO_DOC_PKG.Documentation(1);
600: logProgress('DOC', 'Completed Doc');
601: bsc_mo_helper_pkg.writeTmp('Done with Doc, system time is '||

Line 602: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);

598: logProgress('DOC', 'Starting Doc');
599: BSC_MO_DOC_PKG.Documentation(1);
600: logProgress('DOC', 'Completed Doc');
601: bsc_mo_helper_pkg.writeTmp('Done with Doc, system time is '||
602: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
603: writetableCounts;
604: bsc_mo_helper_pkg.writeTmp('Starting UpdateFlags, system time is '||
605: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
606: logProgress('MISC', 'Calling UpdateFlags');

Line 605: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);

601: bsc_mo_helper_pkg.writeTmp('Done with Doc, system time is '||
602: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
603: writetableCounts;
604: bsc_mo_helper_pkg.writeTmp('Starting UpdateFlags, system time is '||
605: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
606: logProgress('MISC', 'Calling UpdateFlags');
607: --Update flags
608: BSC_MO_HELPER_PKG.UpdateFlags;
609: logProgress('MISC', 'Completed UpdateFlags');

Line 611: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);

607: --Update flags
608: BSC_MO_HELPER_PKG.UpdateFlags;
609: logProgress('MISC', 'Completed UpdateFlags');
610: bsc_mo_helper_pkg.writeTmp('Done with UpdateFlags, system time is '||
611: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
612: -- Call OUT API to populate display tables used by the UI
613: BEGIN
614: logProgress('MISC', 'Calling BSC_PMD_OPT_DOC_UTIL.GEN_TBL_RELS_DISPLAY');
615: execute immediate 'begin BSC_PMD_OPT_DOC_UTIL.GEN_TBL_RELS_DISPLAY; end;';

Line 619: bsc_mo_helper_pkg.writeTmp('EXCEPTION in UI Call OUT BSC_PMD_OPT_DOC_UTIL.GEN_TBL_RELS_DISPLAY : '||l_error, FND_LOG.LEVEL_UNEXPECTED, true);

615: execute immediate 'begin BSC_PMD_OPT_DOC_UTIL.GEN_TBL_RELS_DISPLAY; end;';
616: logProgress('MISC', 'Completed BSC_PMD_OPT_DOC_UTIL.GEN_TBL_RELS_DISPLAY');
617: EXCEPTION when others then
618: l_error := sqlerrm;
619: bsc_mo_helper_pkg.writeTmp('EXCEPTION in UI Call OUT BSC_PMD_OPT_DOC_UTIL.GEN_TBL_RELS_DISPLAY : '||l_error, FND_LOG.LEVEL_UNEXPECTED, true);
620: END;
621: bsc_mo_helper_pkg.writeTmp('Done with display tables API call, system time is '||
622: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
623: writeTableCounts;

Line 622: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);

618: l_error := sqlerrm;
619: bsc_mo_helper_pkg.writeTmp('EXCEPTION in UI Call OUT BSC_PMD_OPT_DOC_UTIL.GEN_TBL_RELS_DISPLAY : '||l_error, FND_LOG.LEVEL_UNEXPECTED, true);
620: END;
621: bsc_mo_helper_pkg.writeTmp('Done with display tables API call, system time is '||
622: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
623: writeTableCounts;
624:
625: fnd_stats.gather_table_stats(l_dummy1, l_dummy2, gBSCSchema,'BSC_KPI_DATA_TABLES');
626:

Line 630: BSC_MO_HELPER_PKG.TerminateWithMsg('EXCEPTION in generateACtualization : '||l_error, FND_LOG.LEVEL_UNEXPECTED);

626:
627: EXCEPTION when others then
628: logprogress('ERROR', 'Exception in generateACtualization');
629: l_error := sqlerrm;
630: BSC_MO_HELPER_PKG.TerminateWithMsg('EXCEPTION in generateACtualization : '||l_error, FND_LOG.LEVEL_UNEXPECTED);
631: RAISE;
632: END;
633:
634: PROCEDURE initMVFlags IS

Line 643: bsc_mo_helper_pkg.writeTmp('Current MV levels ='||g_Current_Adv_Sum_Level ||', Target MV levels='||g_Adv_Summarization_Level, FND_LOG.LEVEL_STATEMENT,true);

639: g_Current_Adv_Sum_Level := bsc_mo_helper_pkg.getInitColumn('ADV_SUM_LEVEL');
640:
641: If (g_Current_Adv_Sum_Level IS NOT NULL AND g_Adv_Summarization_Level IS NULL) Then
642: --User cannot go back to old architecture.
643: bsc_mo_helper_pkg.writeTmp('Current MV levels ='||g_Current_Adv_Sum_Level ||', Target MV levels='||g_Adv_Summarization_Level, FND_LOG.LEVEL_STATEMENT,true);
644: bsc_mo_helper_pkg.writeTmp('Cannot go back to Summary table architecture', FND_LOG.LEVEL_STATEMENT, true); --force this OUT
645: BSC_MO_HELPER_PKG.TerminateWithError('BSC_SUM_LEVEL_INVALID');
646: raise optimizer_exception;
647: return;

Line 644: bsc_mo_helper_pkg.writeTmp('Cannot go back to Summary table architecture', FND_LOG.LEVEL_STATEMENT, true); --force this OUT

640:
641: If (g_Current_Adv_Sum_Level IS NOT NULL AND g_Adv_Summarization_Level IS NULL) Then
642: --User cannot go back to old architecture.
643: bsc_mo_helper_pkg.writeTmp('Current MV levels ='||g_Current_Adv_Sum_Level ||', Target MV levels='||g_Adv_Summarization_Level, FND_LOG.LEVEL_STATEMENT,true);
644: bsc_mo_helper_pkg.writeTmp('Cannot go back to Summary table architecture', FND_LOG.LEVEL_STATEMENT, true); --force this OUT
645: BSC_MO_HELPER_PKG.TerminateWithError('BSC_SUM_LEVEL_INVALID');
646: raise optimizer_exception;
647: return;
648: End If;

Line 660: bsc_mo_helper_pkg.writeTmp('Upgrading to MV architecture, MV levels='|| g_Adv_Summarization_Level , FND_LOG.LEVEL_STATEMENT, true);

656: g_sum_level_change := 0; -- Entire system running for MVs first time, so not an upgrade
657: ELSE
658: g_Sum_Level_Change := 1; --Upgrade to new architecture (null to notnull)
659: END IF;
660: bsc_mo_helper_pkg.writeTmp('Upgrading to MV architecture, MV levels='|| g_Adv_Summarization_Level , FND_LOG.LEVEL_STATEMENT, true);
661: Else
662: If g_Current_Adv_Sum_Level <> g_Adv_Summarization_Level Then
663: g_Sum_Level_Change := 2;
664: Else

Line 667: bsc_mo_helper_pkg.writeTmp('Current MV level = '||g_Current_Adv_Sum_Level||', Target MV level = '|| g_Adv_Summarization_Level , FND_LOG.LEVEL_STATEMENT, true); --force this OUT

663: g_Sum_Level_Change := 2;
664: Else
665: g_Sum_Level_Change := 0;
666: End If;
667: bsc_mo_helper_pkg.writeTmp('Current MV level = '||g_Current_Adv_Sum_Level||', Target MV level = '|| g_Adv_Summarization_Level , FND_LOG.LEVEL_STATEMENT, true); --force this OUT
668: End If;
669: If g_Adv_Summarization_Level IS NULL Then
670: bsc_mo_helper_pkg.writeTmp('Summary Table architecture', FND_LOG.LEVEL_STATEMENT, true);
671: g_BSC_MV := False;

Line 670: bsc_mo_helper_pkg.writeTmp('Summary Table architecture', FND_LOG.LEVEL_STATEMENT, true);

666: End If;
667: bsc_mo_helper_pkg.writeTmp('Current MV level = '||g_Current_Adv_Sum_Level||', Target MV level = '|| g_Adv_Summarization_Level , FND_LOG.LEVEL_STATEMENT, true); --force this OUT
668: End If;
669: If g_Adv_Summarization_Level IS NULL Then
670: bsc_mo_helper_pkg.writeTmp('Summary Table architecture', FND_LOG.LEVEL_STATEMENT, true);
671: g_BSC_MV := False;
672: Else
673: bsc_mo_helper_pkg.writeTmp('MV architecture', FND_LOG.LEVEL_STATEMENT, true);
674: g_BSC_MV := True;

Line 673: bsc_mo_helper_pkg.writeTmp('MV architecture', FND_LOG.LEVEL_STATEMENT, true);

669: If g_Adv_Summarization_Level IS NULL Then
670: bsc_mo_helper_pkg.writeTmp('Summary Table architecture', FND_LOG.LEVEL_STATEMENT, true);
671: g_BSC_MV := False;
672: Else
673: bsc_mo_helper_pkg.writeTmp('MV architecture', FND_LOG.LEVEL_STATEMENT, true);
674: g_BSC_MV := True;
675: End If;
676: END;
677:

Line 697: bsc_mo_helper_pkg.writeTmp('Inside InitGlobalVars', FND_LOG.LEVEL_PROCEDURE, true);

693: END;
694:
695: PROCEDURE InitGlobalVars IS
696: BEGIN
697: bsc_mo_helper_pkg.writeTmp('Inside InitGlobalVars', FND_LOG.LEVEL_PROCEDURE, true);
698: logProgress('INIT', 'Starting InitGlobalVars');
699: InitLanguages;
700: InitReservedFunctions;
701: BSC_MO_HELPER_PKG.InitArrReservedWords;

Line 771: bsc_mo_helper_pkg.writeTmp('Completed InitGlobalVars', FND_LOG.LEVEL_PROCEDURE, true);

767: bsc_mo_helper_pkg.CreateDBMeasureByDimSetTmp;
768: logProgress('INIT', 'Starting initLOV');
769: BSC_MO_HELPER_PKG.InitLOV;
770: logProgress('INIT', 'Completed initLOV');
771: bsc_mo_helper_pkg.writeTmp('Completed InitGlobalVars', FND_LOG.LEVEL_PROCEDURE, true);
772: logProgress('INIT', 'Completed InitGlobalVars');
773: EXCEPTION when others then
774: bsc_mo_helper_pkg.writeTmp('EXCEPTION in InitGlobalVars:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
775: RAISE;

Line 774: bsc_mo_helper_pkg.writeTmp('EXCEPTION in InitGlobalVars:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

770: logProgress('INIT', 'Completed initLOV');
771: bsc_mo_helper_pkg.writeTmp('Completed InitGlobalVars', FND_LOG.LEVEL_PROCEDURE, true);
772: logProgress('INIT', 'Completed InitGlobalVars');
773: EXCEPTION when others then
774: bsc_mo_helper_pkg.writeTmp('EXCEPTION in InitGlobalVars:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
775: RAISE;
776: END;
777:
778: PROCEDURE writeKPIList IS

Line 789: bsc_mo_helper_pkg.writeTmp('Code = '||i.indicator||', Name ='||i.name||', prototype_flag='||i.prototype_flag||', Implementation='||i.impl_type, FND_LOG.LEVEL_PROCEDURE, true);

785: and prop.property_code(+) = 'IMPLEMENTATION_TYPE'
786: order by indicator;
787: BEGIN
788: FOR i IN cList LOOP
789: bsc_mo_helper_pkg.writeTmp('Code = '||i.indicator||', Name ='||i.name||', prototype_flag='||i.prototype_flag||', Implementation='||i.impl_type, FND_LOG.LEVEL_PROCEDURE, true);
790: END LOOP;
791: END;
792:
793: PROCEDURE Setup IS

Line 810: g_log_level := FND_LOG.g_current_runtime_level;

806: g_log_level := fnd_profile.value('AFLOG_LEVEL');
807: IF (FND_PROFILE.VALUE('BIS_PMF_DEBUG') = 'Y') THEN
808: g_log := TRUE;
809: ELSE -- IF BIS_PMF_DEBUG is set, then enable logging automatically
810: g_log_level := FND_LOG.g_current_runtime_level;
811: END IF;
812: IF (g_dir is null OR fnd_global.CONC_REQUEST_ID = -1) THEN -- run manually
813: BSC_METADATA_OPTIMIZER_PKG.g_dir:=BSC_METADATA_OPTIMIZER_PKG.getUtlFileDir;
814: g_log := TRUE;

Line 815: g_log_level := FND_LOG.LEVEL_STATEMENT;

811: END IF;
812: IF (g_dir is null OR fnd_global.CONC_REQUEST_ID = -1) THEN -- run manually
813: BSC_METADATA_OPTIMIZER_PKG.g_dir:=BSC_METADATA_OPTIMIZER_PKG.getUtlFileDir;
814: g_log := TRUE;
815: g_log_level := FND_LOG.LEVEL_STATEMENT;
816: END IF;
817: g_log_level := FND_LOG.LEVEL_STATEMENT;
818: fnd_file.put_names(g_filename||'.log', g_filename||'.OUT', g_dir);
819: g_fileOpened := TRUE;

Line 817: g_log_level := FND_LOG.LEVEL_STATEMENT;

813: BSC_METADATA_OPTIMIZER_PKG.g_dir:=BSC_METADATA_OPTIMIZER_PKG.getUtlFileDir;
814: g_log := TRUE;
815: g_log_level := FND_LOG.LEVEL_STATEMENT;
816: END IF;
817: g_log_level := FND_LOG.LEVEL_STATEMENT;
818: fnd_file.put_names(g_filename||'.log', g_filename||'.OUT', g_dir);
819: g_fileOpened := TRUE;
820: --g_doc_file := utl_file.fOPEN(g_dir, 'METADATA.OUT' ,'w');
821: logProgress('INIT', 'Completed Setup');

Line 824: ||newline, fnd_log.level_procedure, true);

820: --g_doc_file := utl_file.fOPEN(g_dir, 'METADATA.OUT' ,'w');
821: logProgress('INIT', 'Completed Setup');
822:
823: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------'
824: ||newline, fnd_log.level_procedure, true);
825: bsc_mo_helper_pkg.writeTmp('Database Generator, Start Time is '
826: ||bsc_mo_helper_pkg.get_time, fnd_log.level_procedure, true);
827: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------'
828: ||newline, fnd_log.level_procedure, true);

Line 826: ||bsc_mo_helper_pkg.get_time, fnd_log.level_procedure, true);

822:
823: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------'
824: ||newline, fnd_log.level_procedure, true);
825: bsc_mo_helper_pkg.writeTmp('Database Generator, Start Time is '
826: ||bsc_mo_helper_pkg.get_time, fnd_log.level_procedure, true);
827: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------'
828: ||newline, fnd_log.level_procedure, true);
829: bsc_mo_helper_pkg.writeTmp(newline);
830: bsc_mo_helper_pkg.writeTmp('Logging = '||bsc_mo_helper_pkg.boolean_decode(g_log)||

Line 828: ||newline, fnd_log.level_procedure, true);

824: ||newline, fnd_log.level_procedure, true);
825: bsc_mo_helper_pkg.writeTmp('Database Generator, Start Time is '
826: ||bsc_mo_helper_pkg.get_time, fnd_log.level_procedure, true);
827: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------'
828: ||newline, fnd_log.level_procedure, true);
829: bsc_mo_helper_pkg.writeTmp(newline);
830: bsc_mo_helper_pkg.writeTmp('Logging = '||bsc_mo_helper_pkg.boolean_decode(g_log)||
831: ', logging level='||g_log_level, FND_LOG.LEVEL_PROCEDURE, true);
832:

Line 831: ', logging level='||g_log_level, FND_LOG.LEVEL_PROCEDURE, true);

827: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------'
828: ||newline, fnd_log.level_procedure, true);
829: bsc_mo_helper_pkg.writeTmp(newline);
830: bsc_mo_helper_pkg.writeTmp('Logging = '||bsc_mo_helper_pkg.boolean_decode(g_log)||
831: ', logging level='||g_log_level, FND_LOG.LEVEL_PROCEDURE, true);
832:
833: EXCEPTION WHEN OTHERS THEN
834: l_error := sqlerrm;
835: bsc_mo_helper_pkg.writeTmp('EXCEPTION in Setup : '||l_error, FND_LOG.LEVEL_UNEXPECTED, true);

Line 835: bsc_mo_helper_pkg.writeTmp('EXCEPTION in Setup : '||l_error, FND_LOG.LEVEL_UNEXPECTED, true);

831: ', logging level='||g_log_level, FND_LOG.LEVEL_PROCEDURE, true);
832:
833: EXCEPTION WHEN OTHERS THEN
834: l_error := sqlerrm;
835: bsc_mo_helper_pkg.writeTmp('EXCEPTION in Setup : '||l_error, FND_LOG.LEVEL_UNEXPECTED, true);
836: bsc_mo_helper_pkg.TerminatewithMsg('EXCEPTION in Seti[ : '||l_error);
837: RAISE;
838: end;
839:

Line 855: bsc_mo_helper_pkg.writeTmp('Processing all objectives', FND_LOG.LEVEL_STATEMENT, true);

851: logProgress('INIT', 'Starting initMVFlags');
852: initMVFlags;
853: logProgress('INIT', 'Completed initMVFlags');
854: IF (gGAA_RUN_MODE=0) THEN
855: bsc_mo_helper_pkg.writeTmp('Processing all objectives', FND_LOG.LEVEL_STATEMENT, true);
856: ELSIF (gGAA_RUN_MODE=1) THEN
857: bsc_mo_helper_pkg.writeTmp('Processing modified objectives', FND_LOG.LEVEL_STATEMENT, true);
858: writeKPIList;
859: ELSIF (gGAA_RUN_MODE=2) THEN

Line 857: bsc_mo_helper_pkg.writeTmp('Processing modified objectives', FND_LOG.LEVEL_STATEMENT, true);

853: logProgress('INIT', 'Completed initMVFlags');
854: IF (gGAA_RUN_MODE=0) THEN
855: bsc_mo_helper_pkg.writeTmp('Processing all objectives', FND_LOG.LEVEL_STATEMENT, true);
856: ELSIF (gGAA_RUN_MODE=1) THEN
857: bsc_mo_helper_pkg.writeTmp('Processing modified objectives', FND_LOG.LEVEL_STATEMENT, true);
858: writeKPIList;
859: ELSIF (gGAA_RUN_MODE=2) THEN
860: bsc_mo_helper_pkg.writeTmp('Processing selected objectives', FND_LOG.LEVEL_STATEMENT, true);
861: writeKPIList;

Line 860: bsc_mo_helper_pkg.writeTmp('Processing selected objectives', FND_LOG.LEVEL_STATEMENT, true);

856: ELSIF (gGAA_RUN_MODE=1) THEN
857: bsc_mo_helper_pkg.writeTmp('Processing modified objectives', FND_LOG.LEVEL_STATEMENT, true);
858: writeKPIList;
859: ELSIF (gGAA_RUN_MODE=2) THEN
860: bsc_mo_helper_pkg.writeTmp('Processing selected objectives', FND_LOG.LEVEL_STATEMENT, true);
861: writeKPIList;
862: ELSE
863: bsc_mo_helper_pkg.writeTmp('Processing selected reports', FND_LOG.LEVEL_STATEMENT, true);
864: writeKPIList;

Line 863: bsc_mo_helper_pkg.writeTmp('Processing selected reports', FND_LOG.LEVEL_STATEMENT, true);

859: ELSIF (gGAA_RUN_MODE=2) THEN
860: bsc_mo_helper_pkg.writeTmp('Processing selected objectives', FND_LOG.LEVEL_STATEMENT, true);
861: writeKPIList;
862: ELSE
863: bsc_mo_helper_pkg.writeTmp('Processing selected reports', FND_LOG.LEVEL_STATEMENT, true);
864: writeKPIList;
865: END IF;
866: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------'
867: ||newline, fnd_log.level_procedure, true);

Line 867: ||newline, fnd_log.level_procedure, true);

863: bsc_mo_helper_pkg.writeTmp('Processing selected reports', FND_LOG.LEVEL_STATEMENT, true);
864: writeKPIList;
865: END IF;
866: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------'
867: ||newline, fnd_log.level_procedure, true);
868:
869: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
870: bsc_mo_helper_pkg.writeTmp('Starting database generation process ', FND_LOG.LEVEL_STATEMENT, true);
871: bsc_mo_helper_pkg.writeTmp('Initializing System', FND_LOG.LEVEL_PROCEDURE, true);

Line 869: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);

865: END IF;
866: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------'
867: ||newline, fnd_log.level_procedure, true);
868:
869: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
870: bsc_mo_helper_pkg.writeTmp('Starting database generation process ', FND_LOG.LEVEL_STATEMENT, true);
871: bsc_mo_helper_pkg.writeTmp('Initializing System', FND_LOG.LEVEL_PROCEDURE, true);
872:
873: InitGlobalVars;

Line 870: bsc_mo_helper_pkg.writeTmp('Starting database generation process ', FND_LOG.LEVEL_STATEMENT, true);

866: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------'
867: ||newline, fnd_log.level_procedure, true);
868:
869: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
870: bsc_mo_helper_pkg.writeTmp('Starting database generation process ', FND_LOG.LEVEL_STATEMENT, true);
871: bsc_mo_helper_pkg.writeTmp('Initializing System', FND_LOG.LEVEL_PROCEDURE, true);
872:
873: InitGlobalVars;
874: IF (g_retcode <> 0) THEN

Line 871: bsc_mo_helper_pkg.writeTmp('Initializing System', FND_LOG.LEVEL_PROCEDURE, true);

867: ||newline, fnd_log.level_procedure, true);
868:
869: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
870: bsc_mo_helper_pkg.writeTmp('Starting database generation process ', FND_LOG.LEVEL_STATEMENT, true);
871: bsc_mo_helper_pkg.writeTmp('Initializing System', FND_LOG.LEVEL_PROCEDURE, true);
872:
873: InitGlobalVars;
874: IF (g_retcode <> 0) THEN
875: bsc_mo_helper_pkg.writeTmp('InitGlobalVars did not succeed :'||g_errbuf);

Line 888: bsc_mo_helper_pkg.writeTmp('Initialization completed.', FND_LOG.LEVEL_PROCEDURE, true);

884: --autonomous txn, have to commit
885: commit;
886: return;
887: END IF;
888: bsc_mo_helper_pkg.writeTmp('Initialization completed.', FND_LOG.LEVEL_PROCEDURE, true);
889: logProgress('INIT', 'Completed Initialize');
890: --autonomous txn, have to commit
891: commit;
892: EXCEPTION when others then

Line 894: bsc_mo_helper_pkg.writeTmp('EXCEPTION in Initialize : '||l_error, FND_LOG.LEVEL_UNEXPECTED, true);

890: --autonomous txn, have to commit
891: commit;
892: EXCEPTION when others then
893: l_error := sqlerrm;
894: bsc_mo_helper_pkg.writeTmp('EXCEPTION in Initialize : '||l_error, FND_LOG.LEVEL_UNEXPECTED, true);
895: bsc_mo_helper_pkg.TerminatewithMsg('EXCEPTION in Initialize : '||l_error);
896: commit;
897: RAISE;
898: END;

Line 908: bsc_mo_helper_pkg.writeTmp('Inside Wrapup', FND_LOG.LEVEL_PROCEDURE, true);

904: x_msg_data varchar2(1000);
905:
906: BEGIN
907:
908: bsc_mo_helper_pkg.writeTmp('Inside Wrapup', FND_LOG.LEVEL_PROCEDURE, true);
909: bsc_mo_helper_pkg.writeTmp('Starting Doc CP, system time is '||
910: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
911: --Launch doc as a separate process
912: l_docRequestID := FND_REQUEST.SUBMIT_REQUEST(

Line 910: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);

906: BEGIN
907:
908: bsc_mo_helper_pkg.writeTmp('Inside Wrapup', FND_LOG.LEVEL_PROCEDURE, true);
909: bsc_mo_helper_pkg.writeTmp('Starting Doc CP, system time is '||
910: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
911: --Launch doc as a separate process
912: l_docRequestID := FND_REQUEST.SUBMIT_REQUEST(
913: application=>'BSC',
914: program=>'BSC_METADATA_OPTIMIZER_DOC');

Line 919: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);

915:
916: commit;
917: logProgress('DOC', 'Completed Submitting Doc process, request id = '||l_docRequestID);
918: bsc_mo_helper_pkg.writeTmp('Done with Doc, system time is '||
919: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
920: bsc_mo_helper_pkg.writeTmp('Starting Doc CP, system time is '||
921: bsc_mo_helper_pkg.get_time||', request id = '||l_docRequestID, FND_LOG.LEVEL_STATEMENT, true);
922: bsc_mo_helper_pkg.writeTmp('Submitted Doc process, request id = '||l_docRequestID, FND_LOG.LEVEL_STATEMENT, true);
923: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);

Line 921: bsc_mo_helper_pkg.get_time||', request id = '||l_docRequestID, FND_LOG.LEVEL_STATEMENT, true);

917: logProgress('DOC', 'Completed Submitting Doc process, request id = '||l_docRequestID);
918: bsc_mo_helper_pkg.writeTmp('Done with Doc, system time is '||
919: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
920: bsc_mo_helper_pkg.writeTmp('Starting Doc CP, system time is '||
921: bsc_mo_helper_pkg.get_time||', request id = '||l_docRequestID, FND_LOG.LEVEL_STATEMENT, true);
922: bsc_mo_helper_pkg.writeTmp('Submitted Doc process, request id = '||l_docRequestID, FND_LOG.LEVEL_STATEMENT, true);
923: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
924: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
925: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);

Line 922: bsc_mo_helper_pkg.writeTmp('Submitted Doc process, request id = '||l_docRequestID, FND_LOG.LEVEL_STATEMENT, true);

918: bsc_mo_helper_pkg.writeTmp('Done with Doc, system time is '||
919: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
920: bsc_mo_helper_pkg.writeTmp('Starting Doc CP, system time is '||
921: bsc_mo_helper_pkg.get_time||', request id = '||l_docRequestID, FND_LOG.LEVEL_STATEMENT, true);
922: bsc_mo_helper_pkg.writeTmp('Submitted Doc process, request id = '||l_docRequestID, FND_LOG.LEVEL_STATEMENT, true);
923: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
924: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
925: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
926: BEGIN

Line 923: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);

919: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
920: bsc_mo_helper_pkg.writeTmp('Starting Doc CP, system time is '||
921: bsc_mo_helper_pkg.get_time||', request id = '||l_docRequestID, FND_LOG.LEVEL_STATEMENT, true);
922: bsc_mo_helper_pkg.writeTmp('Submitted Doc process, request id = '||l_docRequestID, FND_LOG.LEVEL_STATEMENT, true);
923: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
924: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
925: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
926: BEGIN
927: logProgress('MISC', 'Calling BSC_LOCKS_PUB.SYNCHRONIZE');

Line 924: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);

920: bsc_mo_helper_pkg.writeTmp('Starting Doc CP, system time is '||
921: bsc_mo_helper_pkg.get_time||', request id = '||l_docRequestID, FND_LOG.LEVEL_STATEMENT, true);
922: bsc_mo_helper_pkg.writeTmp('Submitted Doc process, request id = '||l_docRequestID, FND_LOG.LEVEL_STATEMENT, true);
923: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
924: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
925: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
926: BEGIN
927: logProgress('MISC', 'Calling BSC_LOCKS_PUB.SYNCHRONIZE');
928: BSC_LOCKS_PUB.SYNCHRONIZE (-200, BSC_APPS.apps_user_id, x_return_status, x_msg_count, x_msg_data);

Line 925: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);

921: bsc_mo_helper_pkg.get_time||', request id = '||l_docRequestID, FND_LOG.LEVEL_STATEMENT, true);
922: bsc_mo_helper_pkg.writeTmp('Submitted Doc process, request id = '||l_docRequestID, FND_LOG.LEVEL_STATEMENT, true);
923: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
924: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
925: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
926: BEGIN
927: logProgress('MISC', 'Calling BSC_LOCKS_PUB.SYNCHRONIZE');
928: BSC_LOCKS_PUB.SYNCHRONIZE (-200, BSC_APPS.apps_user_id, x_return_status, x_msg_count, x_msg_data);
929: logProgress('MISC', 'Completed BSC_LOCKS_PUB.SYNCHRONIZE');

Line 932: bsc_mo_helper_pkg.writeTmp('WARNING: EXCEPTION in Call OUT BSC_LOCKS_PUB.SYNCHRONIZE : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

928: BSC_LOCKS_PUB.SYNCHRONIZE (-200, BSC_APPS.apps_user_id, x_return_status, x_msg_count, x_msg_data);
929: logProgress('MISC', 'Completed BSC_LOCKS_PUB.SYNCHRONIZE');
930: EXCEPTION when others then
931: g_retcode := 1;
932: bsc_mo_helper_pkg.writeTmp('WARNING: EXCEPTION in Call OUT BSC_LOCKS_PUB.SYNCHRONIZE : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
933: END;
934: bsc_mo_helper_pkg.writeTmp('Completed Wrapup', FND_LOG.LEVEL_PROCEDURE, true);
935: EXCEPTION when others then
936: logProgress('ALL', 'Exception in wrapup:'||sqlerrm);

Line 934: bsc_mo_helper_pkg.writeTmp('Completed Wrapup', FND_LOG.LEVEL_PROCEDURE, true);

930: EXCEPTION when others then
931: g_retcode := 1;
932: bsc_mo_helper_pkg.writeTmp('WARNING: EXCEPTION in Call OUT BSC_LOCKS_PUB.SYNCHRONIZE : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
933: END;
934: bsc_mo_helper_pkg.writeTmp('Completed Wrapup', FND_LOG.LEVEL_PROCEDURE, true);
935: EXCEPTION when others then
936: logProgress('ALL', 'Exception in wrapup:'||sqlerrm);
937: bsc_mo_helper_pkg.writeTmp('Uh oh... EXCEPTION in Wrapup : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
938: RAISE;

Line 937: bsc_mo_helper_pkg.writeTmp('Uh oh... EXCEPTION in Wrapup : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

933: END;
934: bsc_mo_helper_pkg.writeTmp('Completed Wrapup', FND_LOG.LEVEL_PROCEDURE, true);
935: EXCEPTION when others then
936: logProgress('ALL', 'Exception in wrapup:'||sqlerrm);
937: bsc_mo_helper_pkg.writeTmp('Uh oh... EXCEPTION in Wrapup : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
938: RAISE;
939: END;
940:
941: PROCEDURE run_metadata_optimizer_pvt IS

Line 956: bsc_mo_helper_pkg.writeTmp('GenerateActualization did not succeed :retcode='||g_retcode||', error buffer='||g_errbuf, FND_LOG.level_exception, true);

952: logProgress('ALL', 'Completed GenerateActualization');
953: Wrapup;
954: logProgress('ALL', 'Completed Wrapup, retcode='||g_retcode);
955: ELSE
956: bsc_mo_helper_pkg.writeTmp('GenerateActualization did not succeed :retcode='||g_retcode||', error buffer='||g_errbuf, FND_LOG.level_exception, true);
957: logProgress('ALL', 'GenerateActualization did not succeed :retcode='||g_retcode||', error buffer='||g_errbuf);
958: END IF;
959:
960: bsc_mo_helper_pkg.writeTmp('System time is '|| bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);

Line 960: bsc_mo_helper_pkg.writeTmp('System time is '|| bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);

956: bsc_mo_helper_pkg.writeTmp('GenerateActualization did not succeed :retcode='||g_retcode||', error buffer='||g_errbuf, FND_LOG.level_exception, true);
957: logProgress('ALL', 'GenerateActualization did not succeed :retcode='||g_retcode||', error buffer='||g_errbuf);
958: END IF;
959:
960: bsc_mo_helper_pkg.writeTmp('System time is '|| bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
961: bsc_mo_helper_pkg.writeTmp('Completed Generating Database, releasing file handle after the following message.... goodbye' , FND_LOG.LEVEL_PROCEDURE, true);
962: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_PROCEDURE, true);
963: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------', FND_LOG.LEVEL_PROCEDURE, true);
964: bsc_mo_helper_pkg.writeTmp('Generate Database process has completed successfully. Now, you must load data ', FND_LOG.LEVEL_PROCEDURE, true);

Line 961: bsc_mo_helper_pkg.writeTmp('Completed Generating Database, releasing file handle after the following message.... goodbye' , FND_LOG.LEVEL_PROCEDURE, true);

957: logProgress('ALL', 'GenerateActualization did not succeed :retcode='||g_retcode||', error buffer='||g_errbuf);
958: END IF;
959:
960: bsc_mo_helper_pkg.writeTmp('System time is '|| bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
961: bsc_mo_helper_pkg.writeTmp('Completed Generating Database, releasing file handle after the following message.... goodbye' , FND_LOG.LEVEL_PROCEDURE, true);
962: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_PROCEDURE, true);
963: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------', FND_LOG.LEVEL_PROCEDURE, true);
964: bsc_mo_helper_pkg.writeTmp('Generate Database process has completed successfully. Now, you must load data ', FND_LOG.LEVEL_PROCEDURE, true);
965: bsc_mo_helper_pkg.writeTmp('in the Interface Tables and run Data Loader to get information in the system.', FND_LOG.LEVEL_PROCEDURE, true);

Line 962: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_PROCEDURE, true);

958: END IF;
959:
960: bsc_mo_helper_pkg.writeTmp('System time is '|| bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
961: bsc_mo_helper_pkg.writeTmp('Completed Generating Database, releasing file handle after the following message.... goodbye' , FND_LOG.LEVEL_PROCEDURE, true);
962: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_PROCEDURE, true);
963: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------', FND_LOG.LEVEL_PROCEDURE, true);
964: bsc_mo_helper_pkg.writeTmp('Generate Database process has completed successfully. Now, you must load data ', FND_LOG.LEVEL_PROCEDURE, true);
965: bsc_mo_helper_pkg.writeTmp('in the Interface Tables and run Data Loader to get information in the system.', FND_LOG.LEVEL_PROCEDURE, true);
966: logProgress('ALL', 'Completed Generate Database successfully');

Line 963: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------', FND_LOG.LEVEL_PROCEDURE, true);

959:
960: bsc_mo_helper_pkg.writeTmp('System time is '|| bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
961: bsc_mo_helper_pkg.writeTmp('Completed Generating Database, releasing file handle after the following message.... goodbye' , FND_LOG.LEVEL_PROCEDURE, true);
962: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_PROCEDURE, true);
963: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------', FND_LOG.LEVEL_PROCEDURE, true);
964: bsc_mo_helper_pkg.writeTmp('Generate Database process has completed successfully. Now, you must load data ', FND_LOG.LEVEL_PROCEDURE, true);
965: bsc_mo_helper_pkg.writeTmp('in the Interface Tables and run Data Loader to get information in the system.', FND_LOG.LEVEL_PROCEDURE, true);
966: logProgress('ALL', 'Completed Generate Database successfully');
967: fnd_file.release_names(g_filename||'.log', g_filename||'.OUT');

Line 964: bsc_mo_helper_pkg.writeTmp('Generate Database process has completed successfully. Now, you must load data ', FND_LOG.LEVEL_PROCEDURE, true);

960: bsc_mo_helper_pkg.writeTmp('System time is '|| bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
961: bsc_mo_helper_pkg.writeTmp('Completed Generating Database, releasing file handle after the following message.... goodbye' , FND_LOG.LEVEL_PROCEDURE, true);
962: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_PROCEDURE, true);
963: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------', FND_LOG.LEVEL_PROCEDURE, true);
964: bsc_mo_helper_pkg.writeTmp('Generate Database process has completed successfully. Now, you must load data ', FND_LOG.LEVEL_PROCEDURE, true);
965: bsc_mo_helper_pkg.writeTmp('in the Interface Tables and run Data Loader to get information in the system.', FND_LOG.LEVEL_PROCEDURE, true);
966: logProgress('ALL', 'Completed Generate Database successfully');
967: fnd_file.release_names(g_filename||'.log', g_filename||'.OUT');
968: g_fileOpened := false;

Line 965: bsc_mo_helper_pkg.writeTmp('in the Interface Tables and run Data Loader to get information in the system.', FND_LOG.LEVEL_PROCEDURE, true);

961: bsc_mo_helper_pkg.writeTmp('Completed Generating Database, releasing file handle after the following message.... goodbye' , FND_LOG.LEVEL_PROCEDURE, true);
962: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_PROCEDURE, true);
963: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------', FND_LOG.LEVEL_PROCEDURE, true);
964: bsc_mo_helper_pkg.writeTmp('Generate Database process has completed successfully. Now, you must load data ', FND_LOG.LEVEL_PROCEDURE, true);
965: bsc_mo_helper_pkg.writeTmp('in the Interface Tables and run Data Loader to get information in the system.', FND_LOG.LEVEL_PROCEDURE, true);
966: logProgress('ALL', 'Completed Generate Database successfully');
967: fnd_file.release_names(g_filename||'.log', g_filename||'.OUT');
968: g_fileOpened := false;
969: commit;

Line 983: bsc_mo_helper_pkg.writeTmp('LOCKING going to lock entire system ', fnd_log.level_statement, true);

979: g_log := false;
980: FND_MSG_PUB.Initialize;
981: BSC_LOCKS_PUB.GET_SYSTEM_LOCK (-200,BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);
982: IF (gGAA_RUN_MODE = 0) THEN -- whole system
983: bsc_mo_helper_pkg.writeTmp('LOCKING going to lock entire system ', fnd_log.level_statement, true);
984: BSC_LOCKS_PUB.GET_SYSTEM_LOCK ('OBJECTIVE', 'W', sysdate, -200,
985: BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);
986: IF (x_return_status<> FND_API.G_RET_STS_SUCCESS) THEN
987: bsc_mo_helper_pkg.writeTmp('EXCEPTION while trying to Lock in Initialize : '||

Line 988: x_msg_data, FND_LOG.LEVEL_UNEXPECTED, true);

984: BSC_LOCKS_PUB.GET_SYSTEM_LOCK ('OBJECTIVE', 'W', sysdate, -200,
985: BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);
986: IF (x_return_status<> FND_API.G_RET_STS_SUCCESS) THEN
987: bsc_mo_helper_pkg.writeTmp('EXCEPTION while trying to Lock in Initialize : '||
988: x_msg_data, FND_LOG.LEVEL_UNEXPECTED, true);
989: bsc_mo_helper_pkg.TerminateWithMsg(x_msg_data);
990: fnd_message.set_name('BSC', 'BSC_MUSERS_LOCKED_SYSTEM');
991: app_exception.raise_exception;
992: return;

Line 997: bsc_mo_helper_pkg.writeTmp('LOCKING going to lock objective '||i.indicator, fnd_log.level_statement, true);

993: END IF;
994: ELSE--selected or inter-related
995: FOR i IN (select indicator from bsc_tmp_opt_ui_kpis where process_id = g_processID) LOOP
996: logProgress('LOCK', 'Locking '||i.indicator);
997: bsc_mo_helper_pkg.writeTmp('LOCKING going to lock objective '||i.indicator, fnd_log.level_statement, true);
998: BSC_LOCKS_PUB.GET_SYSTEM_LOCK (
999: i.indicator, 'OBJECTIVE', 'W', sysdate, -200,BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);
1000: IF (x_return_status<> FND_API.G_RET_STS_SUCCESS) THEN
1001: bsc_mo_helper_pkg.writeTmp('EXCEPTION while trying to Lock in Initialize : '||

Line 1002: x_msg_data, FND_LOG.LEVEL_UNEXPECTED, true);

998: BSC_LOCKS_PUB.GET_SYSTEM_LOCK (
999: i.indicator, 'OBJECTIVE', 'W', sysdate, -200,BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);
1000: IF (x_return_status<> FND_API.G_RET_STS_SUCCESS) THEN
1001: bsc_mo_helper_pkg.writeTmp('EXCEPTION while trying to Lock in Initialize : '||
1002: x_msg_data, FND_LOG.LEVEL_UNEXPECTED, true);
1003: bsc_mo_helper_pkg.TerminateWithMsg(x_msg_data);
1004: fnd_message.set_name('BSC', 'BSC_MUSERS_LOCKED_SYSTEM');
1005: app_exception.raise_exception;
1006: return;

Line 1042: bsc_mo_helper_pkg.writeTmp('EXCEPTION in run_metadata_optimizer : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

1038: retcode := g_retcode;
1039: errbuf := g_errbuf;
1040: --bsc_security.Delete_Bsc_Session;
1041: bsc_locks_pub.remove_system_lock;
1042: bsc_mo_helper_pkg.writeTmp('EXCEPTION in run_metadata_optimizer : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
1043: fnd_file.release_names(g_filename||'.log', g_filename||'.OUT');
1044: when others then -- general failure, dump the stack
1045: logProgress('ALL', 'Failed to Generate Database, general failure, dumping stack');
1046: retcode := g_retcode;

Line 1050: bsc_mo_helper_pkg.writeTmp('EXCEPTION in run_metadata_optimizer : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

1046: retcode := g_retcode;
1047: errbuf := g_errbuf;
1048: --bsc_security.Delete_Bsc_Session;
1049: bsc_locks_pub.remove_system_lock;
1050: bsc_mo_helper_pkg.writeTmp('EXCEPTION in run_metadata_optimizer : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
1051: bsc_mo_helper_pkg.writeTmp('gTables is ', FND_LOG.LEVEL_UNEXPECTED, true);
1052: bsc_mo_helper_pkg.write_this(gTables, FND_LOG.LEVEL_ERROR, true);
1053: bsc_mo_helper_pkg.dump_stack;
1054: fnd_file.release_names(g_filename||'.log', g_filename||'.OUT');

Line 1051: bsc_mo_helper_pkg.writeTmp('gTables is ', FND_LOG.LEVEL_UNEXPECTED, true);

1047: errbuf := g_errbuf;
1048: --bsc_security.Delete_Bsc_Session;
1049: bsc_locks_pub.remove_system_lock;
1050: bsc_mo_helper_pkg.writeTmp('EXCEPTION in run_metadata_optimizer : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
1051: bsc_mo_helper_pkg.writeTmp('gTables is ', FND_LOG.LEVEL_UNEXPECTED, true);
1052: bsc_mo_helper_pkg.write_this(gTables, FND_LOG.LEVEL_ERROR, true);
1053: bsc_mo_helper_pkg.dump_stack;
1054: fnd_file.release_names(g_filename||'.log', g_filename||'.OUT');
1055: END;

Line 1052: bsc_mo_helper_pkg.write_this(gTables, FND_LOG.LEVEL_ERROR, true);

1048: --bsc_security.Delete_Bsc_Session;
1049: bsc_locks_pub.remove_system_lock;
1050: bsc_mo_helper_pkg.writeTmp('EXCEPTION in run_metadata_optimizer : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
1051: bsc_mo_helper_pkg.writeTmp('gTables is ', FND_LOG.LEVEL_UNEXPECTED, true);
1052: bsc_mo_helper_pkg.write_this(gTables, FND_LOG.LEVEL_ERROR, true);
1053: bsc_mo_helper_pkg.dump_stack;
1054: fnd_file.release_names(g_filename||'.log', g_filename||'.OUT');
1055: END;
1056: PROCEDURE Documentation(

Line 1069: bsc_mo_helper_pkg.writeTmp('LOCKING going to lock for documentation ', fnd_log.level_statement, true);

1065: gApplsysSchema := BSC_MO_HELPER_PKG.getApplsysSchema;
1066: -- modified call to include user_id so that session management module can recognise the
1067: -- session lock #bug 3593694
1068: --bsc_security.Check_System_Lock(-201,NULL,BSC_APPS.apps_user_id);
1069: bsc_mo_helper_pkg.writeTmp('LOCKING going to lock for documentation ', fnd_log.level_statement, true);
1070: BSC_LOCKS_PUB.GET_SYSTEM_LOCK(-201,BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);
1071: IF (x_return_status<> FND_API.G_RET_STS_SUCCESS) THEN
1072: bsc_mo_helper_pkg.writeTmp('EXCEPTION while trying to Lock in Initialize : '||x_msg_data, FND_LOG.LEVEL_UNEXPECTED, true);
1073: bsc_mo_helper_pkg.TerminateWithMsg(x_msg_data);

Line 1072: bsc_mo_helper_pkg.writeTmp('EXCEPTION while trying to Lock in Initialize : '||x_msg_data, FND_LOG.LEVEL_UNEXPECTED, true);

1068: --bsc_security.Check_System_Lock(-201,NULL,BSC_APPS.apps_user_id);
1069: bsc_mo_helper_pkg.writeTmp('LOCKING going to lock for documentation ', fnd_log.level_statement, true);
1070: BSC_LOCKS_PUB.GET_SYSTEM_LOCK(-201,BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);
1071: IF (x_return_status<> FND_API.G_RET_STS_SUCCESS) THEN
1072: bsc_mo_helper_pkg.writeTmp('EXCEPTION while trying to Lock in Initialize : '||x_msg_data, FND_LOG.LEVEL_UNEXPECTED, true);
1073: bsc_mo_helper_pkg.TerminateWithMsg(x_msg_data);
1074: fnd_message.set_name('BSC', 'BSC_MUSERS_LOCKED_SYSTEM');
1075: app_exception.raise_exception;
1076: return;

Line 1085: bsc_mo_helper_pkg.writeTmp('EXCEPTION in Documentation : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

1081: bsc_locks_pub.remove_system_lock;
1082: EXCEPTION WHEN OTHERS THEN
1083: --bsc_security.Delete_Bsc_Session;
1084: bsc_locks_pub.remove_system_lock;
1085: bsc_mo_helper_pkg.writeTmp('EXCEPTION in Documentation : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
1086: raise;
1087: END;
1088: END BSC_METADATA_OPTIMIZER_PKG;