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_MO_INDICATOR_PKG dependencies on FND_LOG

Line 90: bsc_mo_helper_pkg.writeTmp('Exception, tableName='||TableName||' colTables=', FND_LOG.LEVEL_EXCEPTION, true);

86: End If;
87: return l_level;
88: EXCEPTION WHEN OTHERS THEN
89: g_error := sqlerrm;
90: bsc_mo_helper_pkg.writeTmp('Exception, tableName='||TableName||' colTables=', FND_LOG.LEVEL_EXCEPTION, true);
91: bsc_mo_helper_pkg.write_this(colTables, FND_LOG.LEVEL_EXCEPTION, true);
92: bsc_mo_helper_pkg.TerminateWithMsg('Exception in getTableLevel : '||g_error);
93: raise;
94: End;

Line 91: bsc_mo_helper_pkg.write_this(colTables, FND_LOG.LEVEL_EXCEPTION, true);

87: return l_level;
88: EXCEPTION WHEN OTHERS THEN
89: g_error := sqlerrm;
90: bsc_mo_helper_pkg.writeTmp('Exception, tableName='||TableName||' colTables=', FND_LOG.LEVEL_EXCEPTION, true);
91: bsc_mo_helper_pkg.write_this(colTables, FND_LOG.LEVEL_EXCEPTION, true);
92: bsc_mo_helper_pkg.TerminateWithMsg('Exception in getTableLevel : '||g_error);
93: raise;
94: End;
95:

Line 145: bsc_mo_helper_pkg.writeTmp('Exception, p_key='||p_key||', Dimension families=', FND_LOG.LEVEL_EXCEPTION, true);

141: END LOOP;
142: return -1;
143: EXCEPTION WHEN OTHERS THEN
144: g_error := sqlerrm;
145: bsc_mo_helper_pkg.writeTmp('Exception, p_key='||p_key||', Dimension families=', FND_LOG.LEVEL_EXCEPTION, true);
146: bsc_mo_helper_pkg.write_this(p_dimension_families, FND_LOG.LEVEL_EXCEPTION, true);
147: bsc_mo_helper_pkg.TerminateWithMsg('Exception in FindDimensionGroupIndexForKey : '||g_error);
148: raise;
149: End;

Line 146: bsc_mo_helper_pkg.write_this(p_dimension_families, FND_LOG.LEVEL_EXCEPTION, true);

142: return -1;
143: EXCEPTION WHEN OTHERS THEN
144: g_error := sqlerrm;
145: bsc_mo_helper_pkg.writeTmp('Exception, p_key='||p_key||', Dimension families=', FND_LOG.LEVEL_EXCEPTION, true);
146: bsc_mo_helper_pkg.write_this(p_dimension_families, FND_LOG.LEVEL_EXCEPTION, true);
147: bsc_mo_helper_pkg.TerminateWithMsg('Exception in FindDimensionGroupIndexForKey : '||g_error);
148: raise;
149: End;
150:

Line 174: bsc_mo_helper_pkg.writeTmp('Exception, p_s_table='||p_s_table||', p_s_table_list=', FND_LOG.LEVEL_EXCEPTION, true);

170: END LOOP;
171: return l_n_parents;
172: EXCEPTION WHEN OTHERS THEN
173: g_error := sqlerrm;
174: bsc_mo_helper_pkg.writeTmp('Exception, p_s_table='||p_s_table||', p_s_table_list=', FND_LOG.LEVEL_EXCEPTION, true);
175: bsc_mo_helper_pkg.write_this(p_s_table_list, FND_LOG.LEVEL_EXCEPTION, true);
176: bsc_mo_helper_pkg.TerminateWithMsg('Exception in get_n_parents : '||g_error);
177: raise;
178:

Line 175: bsc_mo_helper_pkg.write_this(p_s_table_list, FND_LOG.LEVEL_EXCEPTION, true);

171: return l_n_parents;
172: EXCEPTION WHEN OTHERS THEN
173: g_error := sqlerrm;
174: bsc_mo_helper_pkg.writeTmp('Exception, p_s_table='||p_s_table||', p_s_table_list=', FND_LOG.LEVEL_EXCEPTION, true);
175: bsc_mo_helper_pkg.write_this(p_s_table_list, FND_LOG.LEVEL_EXCEPTION, true);
176: bsc_mo_helper_pkg.TerminateWithMsg('Exception in get_n_parents : '||g_error);
177: raise;
178:
179: END;

Line 216: bsc_mo_helper_pkg.writeTmp('In Find join betweeen levels, p_key='||p_key.keyName||', p_zmv_key='||p_zmv_key.keyName, FND_LOG.LEVEL_STATEMENT, false);

212: l_index NUMBER;
213: l_level_table_high VARCHAR2(100);
214: l_level_table_low VARCHAR2(100);
215: BEGIN
216: bsc_mo_helper_pkg.writeTmp('In Find join betweeen levels, p_key='||p_key.keyName||', p_zmv_key='||p_zmv_key.keyName, FND_LOG.LEVEL_STATEMENT, false);
217: l_dim_group_index := FindDimensionGroupIndexForKey(p_dimensions, p_key.KeyName);
218: l_dimension_levels := BSC_MO_HELPER_PKG.get_Tab_clsLevels(p_dimensions, l_dim_group_index) ;
219: -- Find the dimension level for the lower level key
220: l_index := BSC_MO_HELPER_PKG.FindIndex(l_dimension_levels,p_key.KeyName);

Line 224: bsc_mo_helper_pkg.writeTmp('l_level_table_high='||l_level_table_high||', l_level_table_low='||l_level_table_low, FND_LOG.LEVEL_STATEMENT, false);

220: l_index := BSC_MO_HELPER_PKG.FindIndex(l_dimension_levels,p_key.KeyName);
221: l_level_table_high := l_dimension_levels(l_index).dimTable;
222: l_index := BSC_MO_HELPER_PKG.FindIndex(l_dimension_levels,p_zmv_key.KeyName);
223: l_level_table_low := l_dimension_levels(l_index).dimTable;
224: bsc_mo_helper_pkg.writeTmp('l_level_table_high='||l_level_table_high||', l_level_table_low='||l_level_table_low, FND_LOG.LEVEL_STATEMENT, false);
225: OPEN cJoin(g_current_indicator.code, g_current_dimset, l_level_table_high);
226: LOOP
227: FETCH cJoin INTO l_dim, l_parent, l_dim_fk, l_index;
228: EXIT WHEN cJoin%NOTFOUND;

Line 254: bsc_mo_helper_pkg.writeTmp('p_keys('||i||')='||p_keys(i).keyName, FND_LOG.LEVEL_STATEMENT, false);

250: l_join_parent_fk DBMS_SQL.VARCHAR2_TABLE;
251: l_stack varchar2(32000);
252: BEGIN
253: FOR i IN p_keys.first..p_keys.last LOOP
254: bsc_mo_helper_pkg.writeTmp('p_keys('||i||')='||p_keys(i).keyName, FND_LOG.LEVEL_STATEMENT, false);
255: IF (p_keys(i).keyName <> p_zmv_keys(i).keyName AND p_zero_code_states(i) =0) THEN
256: bsc_mo_helper_pkg.writeTmp('Find join betweeen levels', FND_LOG.LEVEL_STATEMENT, false);
257: find_join_betweens_levels(
258: p_keys(i),

Line 256: bsc_mo_helper_pkg.writeTmp('Find join betweeen levels', FND_LOG.LEVEL_STATEMENT, false);

252: BEGIN
253: FOR i IN p_keys.first..p_keys.last LOOP
254: bsc_mo_helper_pkg.writeTmp('p_keys('||i||')='||p_keys(i).keyName, FND_LOG.LEVEL_STATEMENT, false);
255: IF (p_keys(i).keyName <> p_zmv_keys(i).keyName AND p_zero_code_states(i) =0) THEN
256: bsc_mo_helper_pkg.writeTmp('Find join betweeen levels', FND_LOG.LEVEL_STATEMENT, false);
257: find_join_betweens_levels(
258: p_keys(i),
259: p_zmv_keys(i),
260: p_dimensions,

Line 264: bsc_mo_helper_pkg.writeTmp('Found join betweeen levels ', FND_LOG.LEVEL_STATEMENT, false);

260: p_dimensions,
261: l_join_dimensions,
262: l_join_parent ,
263: l_join_parent_fk );
264: bsc_mo_helper_pkg.writeTmp('Found join betweeen levels ', FND_LOG.LEVEL_STATEMENT, false);
265: bsc_mo_helper_pkg.writeTmp('l_join_dimensions are ', FND_LOG.LEVEL_STATEMENT, false);
266: bsc_mo_helper_pkg.write_this(l_join_dimensions, FND_LOG.LEVEL_STATEMENT, false);
267: bsc_mo_helper_pkg.writeTmp('l_join_parents are ', FND_LOG.LEVEL_STATEMENT, false);
268: bsc_mo_helper_pkg.write_this(l_join_parent, FND_LOG.LEVEL_STATEMENT, false);

Line 265: bsc_mo_helper_pkg.writeTmp('l_join_dimensions are ', FND_LOG.LEVEL_STATEMENT, false);

261: l_join_dimensions,
262: l_join_parent ,
263: l_join_parent_fk );
264: bsc_mo_helper_pkg.writeTmp('Found join betweeen levels ', FND_LOG.LEVEL_STATEMENT, false);
265: bsc_mo_helper_pkg.writeTmp('l_join_dimensions are ', FND_LOG.LEVEL_STATEMENT, false);
266: bsc_mo_helper_pkg.write_this(l_join_dimensions, FND_LOG.LEVEL_STATEMENT, false);
267: bsc_mo_helper_pkg.writeTmp('l_join_parents are ', FND_LOG.LEVEL_STATEMENT, false);
268: bsc_mo_helper_pkg.write_this(l_join_parent, FND_LOG.LEVEL_STATEMENT, false);
269: bsc_mo_helper_pkg.writeTmp('l_join_parent_fk are ', FND_LOG.LEVEL_STATEMENT, false);

Line 266: bsc_mo_helper_pkg.write_this(l_join_dimensions, FND_LOG.LEVEL_STATEMENT, false);

262: l_join_parent ,
263: l_join_parent_fk );
264: bsc_mo_helper_pkg.writeTmp('Found join betweeen levels ', FND_LOG.LEVEL_STATEMENT, false);
265: bsc_mo_helper_pkg.writeTmp('l_join_dimensions are ', FND_LOG.LEVEL_STATEMENT, false);
266: bsc_mo_helper_pkg.write_this(l_join_dimensions, FND_LOG.LEVEL_STATEMENT, false);
267: bsc_mo_helper_pkg.writeTmp('l_join_parents are ', FND_LOG.LEVEL_STATEMENT, false);
268: bsc_mo_helper_pkg.write_this(l_join_parent, FND_LOG.LEVEL_STATEMENT, false);
269: bsc_mo_helper_pkg.writeTmp('l_join_parent_fk are ', FND_LOG.LEVEL_STATEMENT, false);
270: bsc_mo_helper_pkg.write_this(l_join_parent_fk, FND_LOG.LEVEL_STATEMENT, false);

Line 267: bsc_mo_helper_pkg.writeTmp('l_join_parents are ', FND_LOG.LEVEL_STATEMENT, false);

263: l_join_parent_fk );
264: bsc_mo_helper_pkg.writeTmp('Found join betweeen levels ', FND_LOG.LEVEL_STATEMENT, false);
265: bsc_mo_helper_pkg.writeTmp('l_join_dimensions are ', FND_LOG.LEVEL_STATEMENT, false);
266: bsc_mo_helper_pkg.write_this(l_join_dimensions, FND_LOG.LEVEL_STATEMENT, false);
267: bsc_mo_helper_pkg.writeTmp('l_join_parents are ', FND_LOG.LEVEL_STATEMENT, false);
268: bsc_mo_helper_pkg.write_this(l_join_parent, FND_LOG.LEVEL_STATEMENT, false);
269: bsc_mo_helper_pkg.writeTmp('l_join_parent_fk are ', FND_LOG.LEVEL_STATEMENT, false);
270: bsc_mo_helper_pkg.write_this(l_join_parent_fk, FND_LOG.LEVEL_STATEMENT, false);
271: IF (l_join_dimensions.count>0) THEN

Line 268: bsc_mo_helper_pkg.write_this(l_join_parent, FND_LOG.LEVEL_STATEMENT, false);

264: bsc_mo_helper_pkg.writeTmp('Found join betweeen levels ', FND_LOG.LEVEL_STATEMENT, false);
265: bsc_mo_helper_pkg.writeTmp('l_join_dimensions are ', FND_LOG.LEVEL_STATEMENT, false);
266: bsc_mo_helper_pkg.write_this(l_join_dimensions, FND_LOG.LEVEL_STATEMENT, false);
267: bsc_mo_helper_pkg.writeTmp('l_join_parents are ', FND_LOG.LEVEL_STATEMENT, false);
268: bsc_mo_helper_pkg.write_this(l_join_parent, FND_LOG.LEVEL_STATEMENT, false);
269: bsc_mo_helper_pkg.writeTmp('l_join_parent_fk are ', FND_LOG.LEVEL_STATEMENT, false);
270: bsc_mo_helper_pkg.write_this(l_join_parent_fk, FND_LOG.LEVEL_STATEMENT, false);
271: IF (l_join_dimensions.count>0) THEN
272: FOR j IN l_join_dimensions.first..l_join_dimensions.last LOOP

Line 269: bsc_mo_helper_pkg.writeTmp('l_join_parent_fk are ', FND_LOG.LEVEL_STATEMENT, false);

265: bsc_mo_helper_pkg.writeTmp('l_join_dimensions are ', FND_LOG.LEVEL_STATEMENT, false);
266: bsc_mo_helper_pkg.write_this(l_join_dimensions, FND_LOG.LEVEL_STATEMENT, false);
267: bsc_mo_helper_pkg.writeTmp('l_join_parents are ', FND_LOG.LEVEL_STATEMENT, false);
268: bsc_mo_helper_pkg.write_this(l_join_parent, FND_LOG.LEVEL_STATEMENT, false);
269: bsc_mo_helper_pkg.writeTmp('l_join_parent_fk are ', FND_LOG.LEVEL_STATEMENT, false);
270: bsc_mo_helper_pkg.write_this(l_join_parent_fk, FND_LOG.LEVEL_STATEMENT, false);
271: IF (l_join_dimensions.count>0) THEN
272: FOR j IN l_join_dimensions.first..l_join_dimensions.last LOOP
273: p_join_dimensions(p_join_dimensions.count) := l_join_dimensions(j);

Line 270: bsc_mo_helper_pkg.write_this(l_join_parent_fk, FND_LOG.LEVEL_STATEMENT, false);

266: bsc_mo_helper_pkg.write_this(l_join_dimensions, FND_LOG.LEVEL_STATEMENT, false);
267: bsc_mo_helper_pkg.writeTmp('l_join_parents are ', FND_LOG.LEVEL_STATEMENT, false);
268: bsc_mo_helper_pkg.write_this(l_join_parent, FND_LOG.LEVEL_STATEMENT, false);
269: bsc_mo_helper_pkg.writeTmp('l_join_parent_fk are ', FND_LOG.LEVEL_STATEMENT, false);
270: bsc_mo_helper_pkg.write_this(l_join_parent_fk, FND_LOG.LEVEL_STATEMENT, false);
271: IF (l_join_dimensions.count>0) THEN
272: FOR j IN l_join_dimensions.first..l_join_dimensions.last LOOP
273: p_join_dimensions(p_join_dimensions.count) := l_join_dimensions(j);
274: p_join_parents(p_join_parents.count) := l_join_parent(j);

Line 282: bsc_mo_helper_pkg.writeTmp('p_keys, p_zmv_keys, p_zero_code_states, p_dimensions in order', FND_LOG.LEVEL_EXCEPTION, true);

278: END IF;
279: END IF;
280: END LOOP;
281: EXCEPTION WHEN OTHERS THEN
282: bsc_mo_helper_pkg.writeTmp('p_keys, p_zmv_keys, p_zero_code_states, p_dimensions in order', FND_LOG.LEVEL_EXCEPTION, true);
283: bsc_mo_helper_pkg.write_this(p_keys, FND_LOG.LEVEL_EXCEPTION, true);
284: bsc_mo_helper_pkg.write_this(p_zmv_keys, FND_LOG.LEVEL_EXCEPTION, true);
285: bsc_mo_helper_pkg.write_this(p_zero_code_states, FND_LOG.LEVEL_EXCEPTION, true);
286: bsc_mo_helper_pkg.write_this(p_dimensions, FND_LOG.LEVEL_EXCEPTION, true);

Line 283: bsc_mo_helper_pkg.write_this(p_keys, FND_LOG.LEVEL_EXCEPTION, true);

279: END IF;
280: END LOOP;
281: EXCEPTION WHEN OTHERS THEN
282: bsc_mo_helper_pkg.writeTmp('p_keys, p_zmv_keys, p_zero_code_states, p_dimensions in order', FND_LOG.LEVEL_EXCEPTION, true);
283: bsc_mo_helper_pkg.write_this(p_keys, FND_LOG.LEVEL_EXCEPTION, true);
284: bsc_mo_helper_pkg.write_this(p_zmv_keys, FND_LOG.LEVEL_EXCEPTION, true);
285: bsc_mo_helper_pkg.write_this(p_zero_code_states, FND_LOG.LEVEL_EXCEPTION, true);
286: bsc_mo_helper_pkg.write_this(p_dimensions, FND_LOG.LEVEL_EXCEPTION, true);
287: bsc_mo_helper_pkg.TerminateWithMsg('Exception in get_join_info:'||sqlerrm);

Line 284: bsc_mo_helper_pkg.write_this(p_zmv_keys, FND_LOG.LEVEL_EXCEPTION, true);

280: END LOOP;
281: EXCEPTION WHEN OTHERS THEN
282: bsc_mo_helper_pkg.writeTmp('p_keys, p_zmv_keys, p_zero_code_states, p_dimensions in order', FND_LOG.LEVEL_EXCEPTION, true);
283: bsc_mo_helper_pkg.write_this(p_keys, FND_LOG.LEVEL_EXCEPTION, true);
284: bsc_mo_helper_pkg.write_this(p_zmv_keys, FND_LOG.LEVEL_EXCEPTION, true);
285: bsc_mo_helper_pkg.write_this(p_zero_code_states, FND_LOG.LEVEL_EXCEPTION, true);
286: bsc_mo_helper_pkg.write_this(p_dimensions, FND_LOG.LEVEL_EXCEPTION, true);
287: bsc_mo_helper_pkg.TerminateWithMsg('Exception in get_join_info:'||sqlerrm);
288: raise;

Line 285: bsc_mo_helper_pkg.write_this(p_zero_code_states, FND_LOG.LEVEL_EXCEPTION, true);

281: EXCEPTION WHEN OTHERS THEN
282: bsc_mo_helper_pkg.writeTmp('p_keys, p_zmv_keys, p_zero_code_states, p_dimensions in order', FND_LOG.LEVEL_EXCEPTION, true);
283: bsc_mo_helper_pkg.write_this(p_keys, FND_LOG.LEVEL_EXCEPTION, true);
284: bsc_mo_helper_pkg.write_this(p_zmv_keys, FND_LOG.LEVEL_EXCEPTION, true);
285: bsc_mo_helper_pkg.write_this(p_zero_code_states, FND_LOG.LEVEL_EXCEPTION, true);
286: bsc_mo_helper_pkg.write_this(p_dimensions, FND_LOG.LEVEL_EXCEPTION, true);
287: bsc_mo_helper_pkg.TerminateWithMsg('Exception in get_join_info:'||sqlerrm);
288: raise;
289: END;

Line 286: bsc_mo_helper_pkg.write_this(p_dimensions, FND_LOG.LEVEL_EXCEPTION, true);

282: bsc_mo_helper_pkg.writeTmp('p_keys, p_zmv_keys, p_zero_code_states, p_dimensions in order', FND_LOG.LEVEL_EXCEPTION, true);
283: bsc_mo_helper_pkg.write_this(p_keys, FND_LOG.LEVEL_EXCEPTION, true);
284: bsc_mo_helper_pkg.write_this(p_zmv_keys, FND_LOG.LEVEL_EXCEPTION, true);
285: bsc_mo_helper_pkg.write_this(p_zero_code_states, FND_LOG.LEVEL_EXCEPTION, true);
286: bsc_mo_helper_pkg.write_this(p_dimensions, FND_LOG.LEVEL_EXCEPTION, true);
287: bsc_mo_helper_pkg.TerminateWithMsg('Exception in get_join_info:'||sqlerrm);
288: raise;
289: END;
290:

Line 349: bsc_mo_helper_pkg.writeTmp('Inside Optimize ZMV clause, p_table_level='||p_table_level||', p_system_levels='||p_system_levels, FND_LOG.level_Statement, false);

345: return false;
346: END IF;
347: -- note that get_n_parents returns the current s_table at position 0, and then its parents
348: -- at positions 1, 2 etc
349: bsc_mo_helper_pkg.writeTmp('Inside Optimize ZMV clause, p_table_level='||p_table_level||', p_system_levels='||p_system_levels, FND_LOG.level_Statement, false);
350: bsc_mo_helper_pkg.writeTmp('Zero Code states = ', FND_LOG.level_Statement, false);
351: bsc_mo_helper_pkg.write_this(p_zero_code_states, FND_LOG.level_Statement, false);
352: l_select_rest := p_sql_stmt;
353: l_nlevel_parents := get_n_parents(p_s_table, p_s_table_list, p_table_level-p_system_levels);

Line 350: bsc_mo_helper_pkg.writeTmp('Zero Code states = ', FND_LOG.level_Statement, false);

346: END IF;
347: -- note that get_n_parents returns the current s_table at position 0, and then its parents
348: -- at positions 1, 2 etc
349: bsc_mo_helper_pkg.writeTmp('Inside Optimize ZMV clause, p_table_level='||p_table_level||', p_system_levels='||p_system_levels, FND_LOG.level_Statement, false);
350: bsc_mo_helper_pkg.writeTmp('Zero Code states = ', FND_LOG.level_Statement, false);
351: bsc_mo_helper_pkg.write_this(p_zero_code_states, FND_LOG.level_Statement, false);
352: l_select_rest := p_sql_stmt;
353: l_nlevel_parents := get_n_parents(p_s_table, p_s_table_list, p_table_level-p_system_levels);
354: bsc_mo_helper_pkg.write_this(l_nlevel_parents, FND_LOG.level_Statement, false);

Line 351: bsc_mo_helper_pkg.write_this(p_zero_code_states, FND_LOG.level_Statement, false);

347: -- note that get_n_parents returns the current s_table at position 0, and then its parents
348: -- at positions 1, 2 etc
349: bsc_mo_helper_pkg.writeTmp('Inside Optimize ZMV clause, p_table_level='||p_table_level||', p_system_levels='||p_system_levels, FND_LOG.level_Statement, false);
350: bsc_mo_helper_pkg.writeTmp('Zero Code states = ', FND_LOG.level_Statement, false);
351: bsc_mo_helper_pkg.write_this(p_zero_code_states, FND_LOG.level_Statement, false);
352: l_select_rest := p_sql_stmt;
353: l_nlevel_parents := get_n_parents(p_s_table, p_s_table_list, p_table_level-p_system_levels);
354: bsc_mo_helper_pkg.write_this(l_nlevel_parents, FND_LOG.level_Statement, false);
355: IF l_nlevel_parents.count = 1 THEN -- no parents, only 1 level, itself

Line 354: bsc_mo_helper_pkg.write_this(l_nlevel_parents, FND_LOG.level_Statement, false);

350: bsc_mo_helper_pkg.writeTmp('Zero Code states = ', FND_LOG.level_Statement, false);
351: bsc_mo_helper_pkg.write_this(p_zero_code_states, FND_LOG.level_Statement, false);
352: l_select_rest := p_sql_stmt;
353: l_nlevel_parents := get_n_parents(p_s_table, p_s_table_list, p_table_level-p_system_levels);
354: bsc_mo_helper_pkg.write_this(l_nlevel_parents, FND_LOG.level_Statement, false);
355: IF l_nlevel_parents.count = 1 THEN -- no parents, only 1 level, itself
356: bsc_mo_helper_pkg.writeTmp('Completed Optimize ZMV clause', FND_LOG.level_Statement, false);
357: return false;
358: END IF;

Line 356: bsc_mo_helper_pkg.writeTmp('Completed Optimize ZMV clause', FND_LOG.level_Statement, false);

352: l_select_rest := p_sql_stmt;
353: l_nlevel_parents := get_n_parents(p_s_table, p_s_table_list, p_table_level-p_system_levels);
354: bsc_mo_helper_pkg.write_this(l_nlevel_parents, FND_LOG.level_Statement, false);
355: IF l_nlevel_parents.count = 1 THEN -- no parents, only 1 level, itself
356: bsc_mo_helper_pkg.writeTmp('Completed Optimize ZMV clause', FND_LOG.level_Statement, false);
357: return false;
358: END IF;
359: l_highest_table_with_zmv := l_nlevel_parents(l_nlevel_parents.last);
360: -- BSC Multiple Optimizers to run

Line 363: bsc_mo_helper_pkg.writeTmp('Highest table with zmv is '||l_highest_table_with_zmv||', with index='||l_index, FND_LOG.level_Statement, false);

359: l_highest_table_with_zmv := l_nlevel_parents(l_nlevel_parents.last);
360: -- BSC Multiple Optimizers to run
361: --l_zmv_keys := BSC_MO_HELPER_PKG.getAllKeyFields(l_highest_table_with_zmv);
362: l_index := BSC_MO_HELPER_PKG.findIndex(p_s_table_list, l_highest_table_with_zmv);
363: bsc_mo_helper_pkg.writeTmp('Highest table with zmv is '||l_highest_table_with_zmv||', with index='||l_index, FND_LOG.level_Statement, false);
364: l_zmv_keys := p_s_table_list(l_index).keys;
365:
366: IF (p_keys.count <> l_zmv_keys.count) THEN -- MN rel
367: bsc_mo_helper_pkg.writeTmp('Completed Optimize ZMV clause', FND_LOG.level_Statement, false);

Line 367: bsc_mo_helper_pkg.writeTmp('Completed Optimize ZMV clause', FND_LOG.level_Statement, false);

363: bsc_mo_helper_pkg.writeTmp('Highest table with zmv is '||l_highest_table_with_zmv||', with index='||l_index, FND_LOG.level_Statement, false);
364: l_zmv_keys := p_s_table_list(l_index).keys;
365:
366: IF (p_keys.count <> l_zmv_keys.count) THEN -- MN rel
367: bsc_mo_helper_pkg.writeTmp('Completed Optimize ZMV clause', FND_LOG.level_Statement, false);
368: return false;
369: END IF;
370: b_zmv_exists := false;
371: FOR i IN l_zmv_keys.first..l_zmv_keys.last LOOP

Line 378: bsc_mo_helper_pkg.writeTmp('Completed Optimize ZMV clause, Zero code mv with values for this level comb does not exist, returning false', FND_LOG.level_Statement, false);

374: EXIT;
375: END IF;
376: END LOOP;
377: IF (b_zmv_exists = false) THEN
378: bsc_mo_helper_pkg.writeTmp('Completed Optimize ZMV clause, Zero code mv with values for this level comb does not exist, returning false', FND_LOG.level_Statement, false);
379: return false;
380: ELSE
381: bsc_mo_helper_pkg.writeTmp('ZMV exists ', FND_LOG.level_Statement, false);
382: END IF;

Line 381: bsc_mo_helper_pkg.writeTmp('ZMV exists ', FND_LOG.level_Statement, false);

377: IF (b_zmv_exists = false) THEN
378: bsc_mo_helper_pkg.writeTmp('Completed Optimize ZMV clause, Zero code mv with values for this level comb does not exist, returning false', FND_LOG.level_Statement, false);
379: return false;
380: ELSE
381: bsc_mo_helper_pkg.writeTmp('ZMV exists ', FND_LOG.level_Statement, false);
382: END IF;
383: l_zmv := l_highest_table_with_zmv||'_ZMV';
384: -- Note: l_nlevel_parents(0) is the same as the current S table
385: -- Only l_nlevel_parents(1) and higher are the real parents

Line 425: bsc_mo_helper_pkg.writeTmp('Dimensions have been joined to, so we need to change the select clause', FND_LOG.level_Statement, false);

421: l_from_clause := substr(l_from_clause, 1, length(l_from_clause)-1);
422:
423: -- We need to add the ZMV. alias to the SELECT column keys
424: IF (b_dimensions_joined) THEN
425: bsc_mo_helper_pkg.writeTmp('Dimensions have been joined to, so we need to change the select clause', FND_LOG.level_Statement, false);
426: END IF;
427: l_select_keys_clause := 'SELECT ';
428: l_group_by_clause := ' GROUP BY ';
429: FOR j IN p_Keys.first..p_Keys.last LOOP

Line 448: bsc_mo_helper_pkg.writeTmp('l_where_clause final='||l_where_clause, FND_LOG.level_Statement, false);

444: l_where_clause := null;
445: ELSE
446: l_where_clause := substr(l_where_clause, 1, length(l_where_clause)-5);
447: END IF;
448: bsc_mo_helper_pkg.writeTmp('l_where_clause final='||l_where_clause, FND_LOG.level_Statement, false);
449:
450: bsc_mo_helper_pkg.writeTmp('l_select_keys_clause='||l_select_keys_clause, FND_LOG.level_Statement, false);
451: bsc_mo_helper_pkg.writeTmp('Intermediate l_group_by_clause='||l_group_by_clause, FND_LOG.level_Statement, false);
452: l_group_by_clause := l_group_by_clause ||' PERIODICITY_ID, YEAR, TYPE, PERIOD, PERIOD_TYPE_ID ';

Line 450: bsc_mo_helper_pkg.writeTmp('l_select_keys_clause='||l_select_keys_clause, FND_LOG.level_Statement, false);

446: l_where_clause := substr(l_where_clause, 1, length(l_where_clause)-5);
447: END IF;
448: bsc_mo_helper_pkg.writeTmp('l_where_clause final='||l_where_clause, FND_LOG.level_Statement, false);
449:
450: bsc_mo_helper_pkg.writeTmp('l_select_keys_clause='||l_select_keys_clause, FND_LOG.level_Statement, false);
451: bsc_mo_helper_pkg.writeTmp('Intermediate l_group_by_clause='||l_group_by_clause, FND_LOG.level_Statement, false);
452: l_group_by_clause := l_group_by_clause ||' PERIODICITY_ID, YEAR, TYPE, PERIOD, PERIOD_TYPE_ID ';
453: bsc_mo_helper_pkg.writeTmp('l_group_by_clause final='||l_group_by_clause, FND_LOG.level_Statement, false);
454: p_sql_stmt := l_select_keys_clause||' '||l_select_rest||' '||l_from_clause||' '||l_where_clause||' '||l_group_by_clause;

Line 451: bsc_mo_helper_pkg.writeTmp('Intermediate l_group_by_clause='||l_group_by_clause, FND_LOG.level_Statement, false);

447: END IF;
448: bsc_mo_helper_pkg.writeTmp('l_where_clause final='||l_where_clause, FND_LOG.level_Statement, false);
449:
450: bsc_mo_helper_pkg.writeTmp('l_select_keys_clause='||l_select_keys_clause, FND_LOG.level_Statement, false);
451: bsc_mo_helper_pkg.writeTmp('Intermediate l_group_by_clause='||l_group_by_clause, FND_LOG.level_Statement, false);
452: l_group_by_clause := l_group_by_clause ||' PERIODICITY_ID, YEAR, TYPE, PERIOD, PERIOD_TYPE_ID ';
453: bsc_mo_helper_pkg.writeTmp('l_group_by_clause final='||l_group_by_clause, FND_LOG.level_Statement, false);
454: p_sql_stmt := l_select_keys_clause||' '||l_select_rest||' '||l_from_clause||' '||l_where_clause||' '||l_group_by_clause;
455: bsc_mo_helper_pkg.writeTmp('Completed Optimize ZMV clause, sql_stmt='||p_sql_stmt, FND_LOG.level_Statement, false);

Line 453: bsc_mo_helper_pkg.writeTmp('l_group_by_clause final='||l_group_by_clause, FND_LOG.level_Statement, false);

449:
450: bsc_mo_helper_pkg.writeTmp('l_select_keys_clause='||l_select_keys_clause, FND_LOG.level_Statement, false);
451: bsc_mo_helper_pkg.writeTmp('Intermediate l_group_by_clause='||l_group_by_clause, FND_LOG.level_Statement, false);
452: l_group_by_clause := l_group_by_clause ||' PERIODICITY_ID, YEAR, TYPE, PERIOD, PERIOD_TYPE_ID ';
453: bsc_mo_helper_pkg.writeTmp('l_group_by_clause final='||l_group_by_clause, FND_LOG.level_Statement, false);
454: p_sql_stmt := l_select_keys_clause||' '||l_select_rest||' '||l_from_clause||' '||l_where_clause||' '||l_group_by_clause;
455: bsc_mo_helper_pkg.writeTmp('Completed Optimize ZMV clause, sql_stmt='||p_sql_stmt, FND_LOG.level_Statement, false);
456: return true;
457: EXCEPTION WHEN OTHERS THEN

Line 455: bsc_mo_helper_pkg.writeTmp('Completed Optimize ZMV clause, sql_stmt='||p_sql_stmt, FND_LOG.level_Statement, false);

451: bsc_mo_helper_pkg.writeTmp('Intermediate l_group_by_clause='||l_group_by_clause, FND_LOG.level_Statement, false);
452: l_group_by_clause := l_group_by_clause ||' PERIODICITY_ID, YEAR, TYPE, PERIOD, PERIOD_TYPE_ID ';
453: bsc_mo_helper_pkg.writeTmp('l_group_by_clause final='||l_group_by_clause, FND_LOG.level_Statement, false);
454: p_sql_stmt := l_select_keys_clause||' '||l_select_rest||' '||l_from_clause||' '||l_where_clause||' '||l_group_by_clause;
455: bsc_mo_helper_pkg.writeTmp('Completed Optimize ZMV clause, sql_stmt='||p_sql_stmt, FND_LOG.level_Statement, false);
456: return true;
457: EXCEPTION WHEN OTHERS THEN
458: bsc_mo_helper_pkg.writeTmp('Completed optimize_zmv_clause with error : '||sqlerrm, fnd_log.level_exception, true);
459: bsc_mo_helper_pkg.TerminateWithMsg('Exception in optimize_zmv_clause:'||sqlerrm);

Line 458: bsc_mo_helper_pkg.writeTmp('Completed optimize_zmv_clause with error : '||sqlerrm, fnd_log.level_exception, true);

454: p_sql_stmt := l_select_keys_clause||' '||l_select_rest||' '||l_from_clause||' '||l_where_clause||' '||l_group_by_clause;
455: bsc_mo_helper_pkg.writeTmp('Completed Optimize ZMV clause, sql_stmt='||p_sql_stmt, FND_LOG.level_Statement, false);
456: return true;
457: EXCEPTION WHEN OTHERS THEN
458: bsc_mo_helper_pkg.writeTmp('Completed optimize_zmv_clause with error : '||sqlerrm, fnd_log.level_exception, true);
459: bsc_mo_helper_pkg.TerminateWithMsg('Exception in optimize_zmv_clause:'||sqlerrm);
460: bsc_mo_helper_pkg.writeTmp('l_where_clause final='||l_where_clause, FND_LOG.level_exception, true);
461: raise;
462: return false;

Line 460: bsc_mo_helper_pkg.writeTmp('l_where_clause final='||l_where_clause, FND_LOG.level_exception, true);

456: return true;
457: EXCEPTION WHEN OTHERS THEN
458: bsc_mo_helper_pkg.writeTmp('Completed optimize_zmv_clause with error : '||sqlerrm, fnd_log.level_exception, true);
459: bsc_mo_helper_pkg.TerminateWithMsg('Exception in optimize_zmv_clause:'||sqlerrm);
460: bsc_mo_helper_pkg.writeTmp('l_where_clause final='||l_where_clause, FND_LOG.level_exception, true);
461: raise;
462: return false;
463: END;
464:

Line 517: bsc_mo_helper_pkg.writeTmp('# of levels = '||l_groups.count||' while max allowed = '||BSC_BIA_WRAPPER.MAX_ALLOWED_LEVELS, FND_LOG.LEVEL_STATEMENT, false);

513: l_newline varchar2(10):='
514: ';
515: BEGIN
516: l_groups := BSC_MO_HELPER_PKG.getGroupIds(p_dimension_families);
517: bsc_mo_helper_pkg.writeTmp('# of levels = '||l_groups.count||' while max allowed = '||BSC_BIA_WRAPPER.MAX_ALLOWED_LEVELS, FND_LOG.LEVEL_STATEMENT, false);
518: -- AWs, assume ZMV exists
519: IF (g_current_indicator.Impl_Type = 2) THEN
520: bForcedSQL := false;
521: ELSIF (l_groups.count > BSC_BIA_WRAPPER.MAX_ALLOWED_LEVELS) THEN

Line 523: bsc_mo_helper_pkg.writeTmp('Going to convert MVs to SQL because of DB limitation... # of levels = '||l_groups.count||' while max allowed = '||BSC_BIA_WRAPPER.MAX_ALLOWED_LEVELS, FND_LOG.LEVEL_statement, true);

519: IF (g_current_indicator.Impl_Type = 2) THEN
520: bForcedSQL := false;
521: ELSIF (l_groups.count > BSC_BIA_WRAPPER.MAX_ALLOWED_LEVELS) THEN
522: bForcedSQL := true;
523: bsc_mo_helper_pkg.writeTmp('Going to convert MVs to SQL because of DB limitation... # of levels = '||l_groups.count||' while max allowed = '||BSC_BIA_WRAPPER.MAX_ALLOWED_LEVELS, FND_LOG.LEVEL_statement, true);
524: --l_stack := l_stack || 'Going to convert MVs to SQL because of DB limitation... # of levels = '||l_groups.count||' while max allowed = '||BSC_BIA_WRAPPER.MAX_ALLOWED_LEVELS||l_newline;
525: END IF;
526: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
527: bsc_mo_helper_pkg.writeTmp(' ');

Line 574: bsc_mo_helper_pkg.writeTmp('Zero code is needed, no. of combinations = '||numCombinationsB, FND_LOG.level_Statement, false);

570: numCombinationsA := arrCombinationsA.count;
571: End If;
572: END LOOP;
573: If anyKeyNeedZeroCode Then
574: bsc_mo_helper_pkg.writeTmp('Zero code is needed, no. of combinations = '||numCombinationsB, FND_LOG.level_Statement, false);
575: For i IN 0..numCombinationsB - 1 LOOP
576: bsc_mo_helper_pkg.writeTmp('Processing combination '||i||'='||arrCombinationsB(i), FND_LOG.level_Statement, false);
577: l_stack := null;
578: configKpiMV := New_clsConfigKpiMV;

Line 576: bsc_mo_helper_pkg.writeTmp('Processing combination '||i||'='||arrCombinationsB(i), FND_LOG.level_Statement, false);

572: END LOOP;
573: If anyKeyNeedZeroCode Then
574: bsc_mo_helper_pkg.writeTmp('Zero code is needed, no. of combinations = '||numCombinationsB, FND_LOG.level_Statement, false);
575: For i IN 0..numCombinationsB - 1 LOOP
576: bsc_mo_helper_pkg.writeTmp('Processing combination '||i||'='||arrCombinationsB(i), FND_LOG.level_Statement, false);
577: l_stack := null;
578: configKpiMV := New_clsConfigKpiMV;
579: configKpiMV.LevelComb := arrCombinationsB(i);
580: isTotalCombination := False;

Line 645: bsc_mo_helper_pkg.writeTmp('Calling Optimize ZMV clause', FND_LOG.level_Statement, false);

641: l_stack := l_stack || 'check 2, sql_stmt is '||sql_stmt||l_newline;
642: End If;
643: END LOOP;
644: -- BEGIN added for bug 3944813
645: bsc_mo_helper_pkg.writeTmp('Calling Optimize ZMV clause', FND_LOG.level_Statement, false);
646: l_stack := l_stack || 'Calling Optimize ZMV clause'||l_newline;
647: IF (bForcedSQL =false) -- bug 4139837
648: AND TableLevel > to_number(BSC_METADATA_OPTIMIZER_PKG.g_Adv_Summarization_Level)
649: AND to_number(BSC_METADATA_OPTIMIZER_PKG.g_Adv_Summarization_Level) > 0

Line 659: bsc_mo_helper_pkg.writeTmp('Optimized sql_stmt='||sql_stmt, FND_LOG.level_Statement, false);

655: STable_Keys,
656: l_zero_code_states,
657: to_number(BSC_METADATA_OPTIMIZER_PKG.g_Adv_Summarization_Level),
658: sql_stmt)=true) THEN
659: bsc_mo_helper_pkg.writeTmp('Optimized sql_stmt='||sql_stmt, FND_LOG.level_Statement, false);
660:
661: ELSE
662: sql_stmt := l_select_key_clause || sql_stmt || ' FROM ' || MVName;
663: sql_stmt := sql_stmt || ' GROUP BY ' || group_by;

Line 686: bsc_mo_helper_pkg.writeTmp('Exception in GetColConfigKpiMV : '||g_error, FND_LOG.LEVEL_STATEMENT, true);

682: End If;
683: return colConfigKpiMV;
684: EXCEPTION WHEN OTHERS THEN
685: g_error := sqlerrm;
686: bsc_mo_helper_pkg.writeTmp('Exception in GetColConfigKpiMV : '||g_error, FND_LOG.LEVEL_STATEMENT, true);
687: bsc_mo_helper_pkg.writeTmp('Stack is '||l_stack, FND_LOG.LEVEL_STATEMENT, true);
688: bsc_mo_helper_pkg.TerminateWithMsg('Exception in GetColConfigKpiMV : '||g_error);
689: raise;
690: End ;

Line 687: bsc_mo_helper_pkg.writeTmp('Stack is '||l_stack, FND_LOG.LEVEL_STATEMENT, true);

683: return colConfigKpiMV;
684: EXCEPTION WHEN OTHERS THEN
685: g_error := sqlerrm;
686: bsc_mo_helper_pkg.writeTmp('Exception in GetColConfigKpiMV : '||g_error, FND_LOG.LEVEL_STATEMENT, true);
687: bsc_mo_helper_pkg.writeTmp('Stack is '||l_stack, FND_LOG.LEVEL_STATEMENT, true);
688: bsc_mo_helper_pkg.TerminateWithMsg('Exception in GetColConfigKpiMV : '||g_error);
689: raise;
690: End ;
691:

Line 781: bsc_mo_helper_pkg.writeTmp('Dimension tables are ', FND_LOG.LEVEL_ERROR, true);

777: return -1;
778: EXCEPTION WHEN OTHERS THEN
779: g_error := sqlerrm;
780: bsc_mo_helper_pkg.TerminateWithMsg('Exception in IndexRelation1N : '||g_error||', tablename='||tablename||', masterTableName='||masterTableName);
781: bsc_mo_helper_pkg.writeTmp('Dimension tables are ', FND_LOG.LEVEL_ERROR, true);
782: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gMastertable, FND_LOG.LEVEL_ERROR, true);
783: raise;
784: End;
785:

Line 782: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gMastertable, FND_LOG.LEVEL_ERROR, true);

778: EXCEPTION WHEN OTHERS THEN
779: g_error := sqlerrm;
780: bsc_mo_helper_pkg.TerminateWithMsg('Exception in IndexRelation1N : '||g_error||', tablename='||tablename||', masterTableName='||masterTableName);
781: bsc_mo_helper_pkg.writeTmp('Dimension tables are ', FND_LOG.LEVEL_ERROR, true);
782: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gMastertable, FND_LOG.LEVEL_ERROR, true);
783: raise;
784: End;
785:
786:

Line 921: bsc_mo_helper_pkg.writeTmp('Stack is '||l_stack, fnd_log.level_exception, true);

917:
918: EXCEPTION WHEN OTHERS THEN
919: g_error := sqlerrm;
920: bsc_mo_helper_pkg.TerminateWithMsg('Exception in GetPeriodicityOrigin, '||g_error);
921: bsc_mo_helper_pkg.writeTmp('Stack is '||l_stack, fnd_log.level_exception, true);
922: raise;
923: END;
924:
925: --****************************************************************************

Line 1493: bsc_mo_helper_pkg.writeTmp( 'In ConnectTargetTables, Configuration='||Configuration||', Indicator='||', System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);

1489: l_index1 NUMBER;
1490: l_next number;
1491: BEGIN
1492: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1493: bsc_mo_helper_pkg.writeTmp( 'In ConnectTargetTables, Configuration='||Configuration||', Indicator='||', System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
1494: END IF;
1495: bsc_mo_helper_pkg.write_this(Indicator);
1496: numVisitedTables := 0;
1497: anyTableVisited := True;

Line 1612: bsc_mo_helper_pkg.writeTmp( 'Done with ConnectTargetTables, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);

1608: i := l_next;
1609: END IF;
1610: END LOOP;
1611: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1612: bsc_mo_helper_pkg.writeTmp( 'Done with ConnectTargetTables, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
1613: END IF;
1614: EXCEPTION WHEN OTHERS THEN
1615: g_error := sqlerrm;
1616: bsc_mo_helper_pkg.TerminateWithMsg('Exception in ConnectTargetTables :' ||g_error);

Line 1730: ||bsc_mo_helper_pkg.boolean_decode(forTargetLevel)||', System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_procedure, false);

1726: l_tbl_kpidata tab_clsKPIData;
1727: BEGIN
1728: bsc_mo_helper_pkg.writeTmp( ' ');
1729: bsc_mo_helper_pkg.writeTmp( 'Inside deduce_and_configure_s_tables, Configuration = '||Configuration ||', forTargetLevel='
1730: ||bsc_mo_helper_pkg.boolean_decode(forTargetLevel)||', System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_procedure, false);
1731: --Delete from BSC_KPI_DATA_TABLES the records for this indicator and configuration
1732: If Not forTargetLevel Then
1733: --The tables are not for targets
1734: DELETE FROM BSC_KPI_DATA_TABLES WHERE INDICATOR = Indicator.Code

Line 1740: bsc_mo_helper_pkg.writeTmp( 'Compl. deduce_and_configure_s_tables, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_procedure, false);

1736: END IF;
1737: IF (colPeriodicities.count >0) THEN
1738: i := colPeriodicities.first;
1739: ELSE
1740: bsc_mo_helper_pkg.writeTmp( 'Compl. deduce_and_configure_s_tables, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_procedure, false);
1741: return;
1742: END IF;
1743: LOOP
1744: L_Periodicity := colPeriodicities(i);

Line 2026: bsc_mo_helper_pkg.writeTmp( 'Compl. deduce_and_configure_s_tables, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_procedure, false);

2022: END IF;
2023: EXIT WHEN i = colPeriodicities.last;
2024: i := colPeriodicities.next(i);
2025: END LOOP;
2026: bsc_mo_helper_pkg.writeTmp( 'Compl. deduce_and_configure_s_tables, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_procedure, false);
2027:
2028: EXCEPTION WHEN OTHERS THEN
2029: l_stmt := sqlerrm;
2030: bsc_mo_helper_pkg.writeTmp( 'exception in deduce_and_configure_s_tables:'||l_stmt, FND_LOG.LEVEL_UNEXPECTED, true);

Line 2030: bsc_mo_helper_pkg.writeTmp( 'exception in deduce_and_configure_s_tables:'||l_stmt, FND_LOG.LEVEL_UNEXPECTED, true);

2026: bsc_mo_helper_pkg.writeTmp( 'Compl. deduce_and_configure_s_tables, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_procedure, false);
2027:
2028: EXCEPTION WHEN OTHERS THEN
2029: l_stmt := sqlerrm;
2030: bsc_mo_helper_pkg.writeTmp( 'exception in deduce_and_configure_s_tables:'||l_stmt, FND_LOG.LEVEL_UNEXPECTED, true);
2031: fnd_message.set_name('BSC', 'BSC_KPICONFIG_SYSTABLES_FAILED');
2032: fnd_message.set_token('INDICATOR', Indicator.code);
2033: fnd_message.set_token('DIMENSION_SET', Configuration);
2034: g_error := fnd_message.get;

Line 2218: bsc_mo_helper_pkg.writeTmp('Inside DeduceInternalGraph, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);

2214: BEGIN
2215:
2216: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2217: bsc_mo_helper_pkg.writeTmp(' ');
2218: bsc_mo_helper_pkg.writeTmp('Inside DeduceInternalGraph, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
2219: bsc_mo_helper_pkg.writeTmp(' colSummaryTables is as above', FND_LOG.LEVEL_STATEMENT);
2220: END IF;
2221: IF (colSummaryTables.count >0) THEN
2222: i := colSummaryTables.first;

Line 2219: bsc_mo_helper_pkg.writeTmp(' colSummaryTables is as above', FND_LOG.LEVEL_STATEMENT);

2215:
2216: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2217: bsc_mo_helper_pkg.writeTmp(' ');
2218: bsc_mo_helper_pkg.writeTmp('Inside DeduceInternalGraph, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
2219: bsc_mo_helper_pkg.writeTmp(' colSummaryTables is as above', FND_LOG.LEVEL_STATEMENT);
2220: END IF;
2221: IF (colSummaryTables.count >0) THEN
2222: i := colSummaryTables.first;
2223: END IF;

Line 2376: bsc_mo_helper_pkg.writeTmp('Completed DeduceInternalGraph, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);

2372: i := colSummaryTables.next(i);
2373: END LOOP;
2374:
2375: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2376: bsc_mo_helper_pkg.writeTmp('Completed DeduceInternalGraph, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
2377: bsc_mo_helper_pkg.writeTmp(' colSummaryTables is ', FND_LOG.LEVEL_STATEMENT);
2378: bsc_mo_helper_pkg.write_this(colSummaryTables);
2379: END IF;
2380:

Line 2377: bsc_mo_helper_pkg.writeTmp(' colSummaryTables is ', FND_LOG.LEVEL_STATEMENT);

2373: END LOOP;
2374:
2375: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2376: bsc_mo_helper_pkg.writeTmp('Completed DeduceInternalGraph, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
2377: bsc_mo_helper_pkg.writeTmp(' colSummaryTables is ', FND_LOG.LEVEL_STATEMENT);
2378: bsc_mo_helper_pkg.write_this(colSummaryTables);
2379: END IF;
2380:
2381: EXCEPTION WHEN OTHERS THEN

Line 2456: bsc_mo_helper_pkg.writeTmp( 'Done with order_level_string, returning '||l_ordered_level_string, FND_LOG.LEVEL_PROCEDURE);

2452: For i in 0..numDriles - 1 LOOP
2453: l_ordered_level_string := l_ordered_level_string || arrConfDriles(i);
2454: END LOOP;
2455: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2456: bsc_mo_helper_pkg.writeTmp( 'Done with order_level_string, returning '||l_ordered_level_string, FND_LOG.LEVEL_PROCEDURE);
2457: END IF;
2458:
2459: return l_ordered_level_string;
2460:

Line 2495: ||', CampoLlave='||CampoLlave , FND_LOG.LEVEL_PROCEDURE);

2491: AND LEVEL_PK_COL = pKeyCol;
2492: BEGIN
2493: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2494: bsc_mo_helper_pkg.writeTmp( 'Inside GetFilterViewName, Indicator='||Indicator||', Configuration='||Configuration
2495: ||', CampoLlave='||CampoLlave , FND_LOG.LEVEL_PROCEDURE);
2496: END IF;
2497:
2498:
2499: OPEN cLevelViewName(Indicator, Configuration, upper(CampoLlave));

Line 2504: bsc_mo_helper_pkg.writeTmp( 'Completed GetFilterViewName, returning '||l_return, FND_LOG.LEVEL_PROCEDURE);

2500: FETCH cLevelViewName INTO l_return;
2501: CLOSE cLevelViewName;
2502:
2503: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2504: bsc_mo_helper_pkg.writeTmp( 'Completed GetFilterViewName, returning '||l_return, FND_LOG.LEVEL_PROCEDURE);
2505: END IF;
2506:
2507: return l_return;
2508:

Line 2673: bsc_mo_helper_pkg.write_this(p_cartesian_product, FND_LOG.LEVEL_STATEMENT);

2669: return;
2670: END IF;
2671: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2672: bsc_mo_helper_pkg.writeTmp( 'Inside CalcCartesianProduct, p_num_dimensions='||p_num_dimensions||' p_cartesian_product is ');
2673: bsc_mo_helper_pkg.write_this(p_cartesian_product, FND_LOG.LEVEL_STATEMENT);
2674: bsc_mo_helper_pkg.writeTmp( 'dimensionSizes is ', FND_LOG.LEVEL_STATEMENT);
2675: bsc_mo_helper_pkg.write_this(dimensionSizes, FND_LOG.LEVEL_STATEMENT);
2676: END IF;
2677:

Line 2674: bsc_mo_helper_pkg.writeTmp( 'dimensionSizes is ', FND_LOG.LEVEL_STATEMENT);

2670: END IF;
2671: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2672: bsc_mo_helper_pkg.writeTmp( 'Inside CalcCartesianProduct, p_num_dimensions='||p_num_dimensions||' p_cartesian_product is ');
2673: bsc_mo_helper_pkg.write_this(p_cartesian_product, FND_LOG.LEVEL_STATEMENT);
2674: bsc_mo_helper_pkg.writeTmp( 'dimensionSizes is ', FND_LOG.LEVEL_STATEMENT);
2675: bsc_mo_helper_pkg.write_this(dimensionSizes, FND_LOG.LEVEL_STATEMENT);
2676: END IF;
2677:
2678: l_num_tables := 1;

Line 2675: bsc_mo_helper_pkg.write_this(dimensionSizes, FND_LOG.LEVEL_STATEMENT);

2671: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2672: bsc_mo_helper_pkg.writeTmp( 'Inside CalcCartesianProduct, p_num_dimensions='||p_num_dimensions||' p_cartesian_product is ');
2673: bsc_mo_helper_pkg.write_this(p_cartesian_product, FND_LOG.LEVEL_STATEMENT);
2674: bsc_mo_helper_pkg.writeTmp( 'dimensionSizes is ', FND_LOG.LEVEL_STATEMENT);
2675: bsc_mo_helper_pkg.write_this(dimensionSizes, FND_LOG.LEVEL_STATEMENT);
2676: END IF;
2677:
2678: l_num_tables := 1;
2679: For i in 0..p_num_dimensions - 1 LOOP

Line 2702: bsc_mo_helper_pkg.writeTmp( 'Compl. CalcCartesianProduct, Cartesian product is ', FND_LOG.LEVEL_PROCEDURE);

2698:
2699: END LOOP;
2700:
2701: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2702: bsc_mo_helper_pkg.writeTmp( 'Compl. CalcCartesianProduct, Cartesian product is ', FND_LOG.LEVEL_PROCEDURE);
2703: bsc_mo_helper_pkg.write_this(p_cartesian_product, FND_LOG.LEVEL_STATEMENT);
2704: bsc_mo_helper_pkg.writeTmp( 'dimensionSizes is ', FND_LOG.LEVEL_STATEMENT);
2705: bsc_mo_helper_pkg.write_this(dimensionSizes, FND_LOG.LEVEL_STATEMENT);
2706: END IF;

Line 2703: bsc_mo_helper_pkg.write_this(p_cartesian_product, FND_LOG.LEVEL_STATEMENT);

2699: END LOOP;
2700:
2701: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2702: bsc_mo_helper_pkg.writeTmp( 'Compl. CalcCartesianProduct, Cartesian product is ', FND_LOG.LEVEL_PROCEDURE);
2703: bsc_mo_helper_pkg.write_this(p_cartesian_product, FND_LOG.LEVEL_STATEMENT);
2704: bsc_mo_helper_pkg.writeTmp( 'dimensionSizes is ', FND_LOG.LEVEL_STATEMENT);
2705: bsc_mo_helper_pkg.write_this(dimensionSizes, FND_LOG.LEVEL_STATEMENT);
2706: END IF;
2707:

Line 2704: bsc_mo_helper_pkg.writeTmp( 'dimensionSizes is ', FND_LOG.LEVEL_STATEMENT);

2700:
2701: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2702: bsc_mo_helper_pkg.writeTmp( 'Compl. CalcCartesianProduct, Cartesian product is ', FND_LOG.LEVEL_PROCEDURE);
2703: bsc_mo_helper_pkg.write_this(p_cartesian_product, FND_LOG.LEVEL_STATEMENT);
2704: bsc_mo_helper_pkg.writeTmp( 'dimensionSizes is ', FND_LOG.LEVEL_STATEMENT);
2705: bsc_mo_helper_pkg.write_this(dimensionSizes, FND_LOG.LEVEL_STATEMENT);
2706: END IF;
2707:
2708: EXCEPTION WHEN OTHERS THEN

Line 2705: bsc_mo_helper_pkg.write_this(dimensionSizes, FND_LOG.LEVEL_STATEMENT);

2701: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2702: bsc_mo_helper_pkg.writeTmp( 'Compl. CalcCartesianProduct, Cartesian product is ', FND_LOG.LEVEL_PROCEDURE);
2703: bsc_mo_helper_pkg.write_this(p_cartesian_product, FND_LOG.LEVEL_STATEMENT);
2704: bsc_mo_helper_pkg.writeTmp( 'dimensionSizes is ', FND_LOG.LEVEL_STATEMENT);
2705: bsc_mo_helper_pkg.write_this(dimensionSizes, FND_LOG.LEVEL_STATEMENT);
2706: END IF;
2707:
2708: EXCEPTION WHEN OTHERS THEN
2709: g_error := sqlerrm;

Line 2758: bsc_mo_helper_pkg.writeTmp(pKey||' is a recursive key..', FND_LOG.LEVEL_STATEMENT, false);

2754: OPEN CV for l_stmt using pIndicator, pKey;
2755: FETCH CV INTO l_num;
2756: IF (CV%FOUND) THEN -- this is a recursive key
2757: CLOSE CV;
2758: bsc_mo_helper_pkg.writeTmp(pKey||' is a recursive key..', FND_LOG.LEVEL_STATEMENT, false);
2759: return true;
2760: END IF;
2761: CLOSE CV;
2762: return false;

Line 2840: ||bsc_mo_helper_pkg.boolean_decode(forTargetLevel ) ||', System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_PROCEDURE, FALSE);

2836: l_groups := BSC_MO_HELPER_PKG.getGroupIDs(colDimLevelCombinations);
2837: l_level_groups := BSC_MO_HELPER_PKG.getGroupIDs(p_dimension_families);
2838: NumDimensions := l_groups.count;
2839: bsc_mo_helper_pkg.writeTmp( 'Inside GetBasicTables, Configuration ='||Configuration||', forTargetLevel ='
2840: ||bsc_mo_helper_pkg.boolean_decode(forTargetLevel ) ||', System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_PROCEDURE, FALSE);
2841: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2842: bsc_mo_helper_pkg.writeTmp( 'Indicator is ');
2843: bsc_mo_helper_pkg.write_this(Indicator);
2844: bsc_mo_helper_pkg.writeTmp( 'colDimLevelCombinations is as above');

Line 2973: bsc_mo_helper_pkg.writeTmp( 'Compl GetBasicTables, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_procedure, false);

2969: colBasicaTablas(colBasicaTablas.count) := Basica;
2970: --BSC_MO_HELPER_PKG.insertBasicTable(Basica, Basic_Keys, colDataColumns);
2971: END LOOP;
2972: END IF;
2973: bsc_mo_helper_pkg.writeTmp( 'Compl GetBasicTables, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_procedure, false);
2974: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2975: bsc_mo_helper_pkg.writeTmp( 'Returning colBasicaTablas as ');
2976: bsc_mo_helper_pkg.write_this(colBasicaTablas);
2977: END IF;

Line 3171: BSC_MO_HELPER_PKG.write_this(BSC_METADATA_OPTIMIZER_PKG.gLov, FND_LOG.LEVEL_EXCEPTION, true);

3167:
3168: EXCEPTION WHEN OTHERS THEN
3169: g_error := sqlerrm;
3170: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in AddInternalColumnInDB : '||g_error||', l_temp='||l_temp||', baseColumns(baseColumns.first)='||baseColumns(baseColumns.first)||' list of values is ');
3171: BSC_MO_HELPER_PKG.write_this(BSC_METADATA_OPTIMIZER_PKG.gLov, FND_LOG.LEVEL_EXCEPTION, true);
3172: raise;
3173: End;
3174:
3175:

Line 3496: bsc_mo_helper_pkg.writeTmp( 'Inside GetDataFields, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, false);

3492: l_source VARCHAR2(100);
3493: cv CurTyp;
3494:
3495: BEGIN
3496: bsc_mo_helper_pkg.writeTmp( 'Inside GetDataFields, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, false);
3497: select short_name into l_source from bsc_kpis_vl
3498: where indicator=Indic;
3499: -- Bug 4301819
3500: -- Dont include PMF measures if this is created by objective definer

Line 3618: bsc_mo_helper_pkg.writeTmp('ERROR BSC_PMA_OPT_DUP_MEASURE(Duplicate measure names) : '||g_error, FND_LOG.LEVEL_EXCEPTION, true);

3614: fnd_message.set_name('BSC', 'BSC_PMA_OPT_DUP_MEASURE');
3615: fnd_message.set_token('OBJECTIVE', Indic);
3616: fnd_message.set_token('MEASURE_NAME', l_measure_names_list(i));
3617: g_error := fnd_message.get;
3618: bsc_mo_helper_pkg.writeTmp('ERROR BSC_PMA_OPT_DUP_MEASURE(Duplicate measure names) : '||g_error, FND_LOG.LEVEL_EXCEPTION, true);
3619: bsc_mo_helper_pkg.terminateWithMsg(g_error);
3620: raise bsc_metadata_optimizer_pkg.optimizer_exception ;
3621: EXIT ;
3622: END IF;

Line 3710: bsc_mo_helper_pkg.writeTmp( 'Compl. GetDataFields, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, false);

3706: END IF;
3707: END IF;
3708: END Loop;
3709: close cv;
3710: bsc_mo_helper_pkg.writeTmp( 'Compl. GetDataFields, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, false);
3711: return l_col_measure_columns;
3712: EXCEPTION WHEN OTHERS THEN
3713: fnd_message.set_name('BSC', 'BSC_BASICTABLE_DEDUCT_FAILED');
3714: fnd_message.set_token('INDICATOR', Indic);

Line 4538: bsc_mo_helper_pkg.writeTmp(' ', fnd_log.level_statement, false);

4534: i NUMBER;
4535: iNext NUMBER;
4536: bLast boolean;
4537: BEGIN
4538: bsc_mo_helper_pkg.writeTmp(' ', fnd_log.level_statement, false);
4539: bsc_mo_helper_pkg.writeTmp( 'Inside ConfigureIndics for '||Indicator.code||', dimension set = '||Configuration||', System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
4540: g_current_dimset := Configuration;
4541: g_current_indicator := Indicator;
4542: If Indicator.Share_Flag = 0 Or Indicator.Share_Flag = 1 Or

Line 4539: bsc_mo_helper_pkg.writeTmp( 'Inside ConfigureIndics for '||Indicator.code||', dimension set = '||Configuration||', System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);

4535: iNext NUMBER;
4536: bLast boolean;
4537: BEGIN
4538: bsc_mo_helper_pkg.writeTmp(' ', fnd_log.level_statement, false);
4539: bsc_mo_helper_pkg.writeTmp( 'Inside ConfigureIndics for '||Indicator.code||', dimension set = '||Configuration||', System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
4540: g_current_dimset := Configuration;
4541: g_current_indicator := Indicator;
4542: If Indicator.Share_Flag = 0 Or Indicator.Share_Flag = 1 Or
4543: (

Line 4635: bsc_mo_helper_pkg.writeTmp( 'Compl ConfigureIndics, system time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);

4631: EXIT WHEN bLast = true;
4632: END Loop;
4633: End If;
4634: END IF;
4635: bsc_mo_helper_pkg.writeTmp( 'Compl ConfigureIndics, system time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
4636: EXCEPTION WHEN OTHERS THEN
4637: bsc_mo_helper_pkg.writeTmp( 'Exception in ConfigureIndics : '||sqlerrm, fnd_log.level_exception, true);
4638: fnd_message.set_name('BSC', 'BSC_KPI_TBLS_SET_DEDUCT_FAILED');
4639: fnd_message.set_token('INDICATOR', Indicator.code);

Line 4637: bsc_mo_helper_pkg.writeTmp( 'Exception in ConfigureIndics : '||sqlerrm, fnd_log.level_exception, true);

4633: End If;
4634: END IF;
4635: bsc_mo_helper_pkg.writeTmp( 'Compl ConfigureIndics, system time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
4636: EXCEPTION WHEN OTHERS THEN
4637: bsc_mo_helper_pkg.writeTmp( 'Exception in ConfigureIndics : '||sqlerrm, fnd_log.level_exception, true);
4638: fnd_message.set_name('BSC', 'BSC_KPI_TBLS_SET_DEDUCT_FAILED');
4639: fnd_message.set_token('INDICATOR', Indicator.code);
4640: fnd_message.set_token('DIMENSION_SET', Configuration);
4641: g_error := fnd_message.get ;

Line 4702: bsc_mo_helper_pkg.writeTmp( 'Inside IndicatorTables, # = '||BSC_METADATA_OPTIMIZER_PKG.gIndicators.count, fnd_log.level_statement, true);

4698: l_count number := 0;
4699: l_configs Number := 0;
4700: l_list dbms_sql.number_table;
4701: BEGIN
4702: bsc_mo_helper_pkg.writeTmp( 'Inside IndicatorTables, # = '||BSC_METADATA_OPTIMIZER_PKG.gIndicators.count, fnd_log.level_statement, true);
4703: IF BSC_METADATA_OPTIMIZER_PKG.gIndicators.count >0 THEN
4704: l_count := BSC_METADATA_OPTIMIZER_PKG.gIndicators.first;
4705: END IF;
4706:

Line 4734: bsc_mo_helper_pkg.writeTmp('Processing Indicator='||Indicator.Code||', dim set='||l_configuration||':'||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);

4730: bsc_mo_helper_pkg.writeTmp('colConfigurations.count = '||colConfigurations.count);
4731: LOOP
4732: EXIT WHEN colConfigurations.count = 0;
4733: l_configuration := colConfigurations(l_configs);
4734: bsc_mo_helper_pkg.writeTmp('Processing Indicator='||Indicator.Code||', dim set='||l_configuration||':'||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
4735: ConfigureIndics(Indicator, l_configuration);
4736: EXIT WHEN l_configs = colConfigurations.last;
4737: l_configs := colConfigurations.next(l_configs);
4738: END LOOP;

Line 4750: bsc_mo_helper_pkg.writeTmp( 'Compl IndicatorTables', fnd_log.level_statement, true);

4746: l_count := BSC_METADATA_OPTIMIZER_PKG.gIndicators.next(l_count) ;
4747: END LOOP;
4748: --Configure shared indicators without filters same tables as master indicator
4749: ConfigureMasterSharedIndics;
4750: bsc_mo_helper_pkg.writeTmp( 'Compl IndicatorTables', fnd_log.level_statement, true);
4751: exception when others then
4752: g_error := sqlerrm;
4753: BSC_MO_HELPER_PKG.TerminateWithMsg('IndicatorTables failed with : '||g_error);
4754: raise;