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_AW_ADAPTER dependencies on BSC_AW_UTILITY

Line 70: if bsc_aw_utility.g_debug then

66: bsc_aw_bsc_metadata.get_dims_for_kpis(p_kpi_list,l_dim_list);
67: bsc_aw_adapter_dim.create_dim(l_dim_list,p_affected_kpi);
68: --check to see if we need to create calendar
69: --create calendar will only create if needed
70: if bsc_aw_utility.g_debug then
71: bsc_aw_calendar.g_debug:=true;
72: end if;
73: for i in 1..p_kpi_list.count loop
74: bsc_metadata.get_kpi_calendar(p_kpi_list(i),l_calendar);

Line 76: if bsc_aw_utility.in_array(l_calendar_processed,l_calendar)=false then

72: end if;
73: for i in 1..p_kpi_list.count loop
74: bsc_metadata.get_kpi_calendar(p_kpi_list(i),l_calendar);
75: l_affected_kpi.delete;
76: if bsc_aw_utility.in_array(l_calendar_processed,l_calendar)=false then
77: bsc_aw_calendar.create_calendar(l_calendar,l_affected_kpi);
78: bsc_aw_utility.merge_array(p_affected_kpi,l_affected_kpi);
79: l_calendar_processed(l_calendar_processed.count+1):=l_calendar;
80: end if;

Line 78: bsc_aw_utility.merge_array(p_affected_kpi,l_affected_kpi);

74: bsc_metadata.get_kpi_calendar(p_kpi_list(i),l_calendar);
75: l_affected_kpi.delete;
76: if bsc_aw_utility.in_array(l_calendar_processed,l_calendar)=false then
77: bsc_aw_calendar.create_calendar(l_calendar,l_affected_kpi);
78: bsc_aw_utility.merge_array(p_affected_kpi,l_affected_kpi);
79: l_calendar_processed(l_calendar_processed.count+1):=l_calendar;
80: end if;
81: end loop;
82: --

Line 84: bsc_aw_utility.subtract_array(p_affected_kpi,p_kpi_list);

80: end if;
81: end loop;
82: --
83: bsc_aw_adapter_kpi.create_kpi(p_kpi_list);
84: bsc_aw_utility.subtract_array(p_affected_kpi,p_kpi_list);
85: bsc_aw_utility.dmp_values(p_affected_kpi,'Affected KPIs');
86: Exception when others then
87: rollback;
88: log_n('Exception in implement_kpi_aw '||sqlerrm);

Line 85: bsc_aw_utility.dmp_values(p_affected_kpi,'Affected KPIs');

81: end loop;
82: --
83: bsc_aw_adapter_kpi.create_kpi(p_kpi_list);
84: bsc_aw_utility.subtract_array(p_affected_kpi,p_kpi_list);
85: bsc_aw_utility.dmp_values(p_affected_kpi,'Affected KPIs');
86: Exception when others then
87: rollback;
88: log_n('Exception in implement_kpi_aw '||sqlerrm);
89: raise;

Line 159: bsc_aw_utility.get_db_lock('bsc_aw_system_upgrade');

155: olap metadata*/
156: procedure upgrade(p_options varchar2) is /*call from upgrade script etc */
157: l_old_upgrade_version number;
158: Begin
159: bsc_aw_utility.get_db_lock('bsc_aw_system_upgrade');
160: set_up(p_options);
161: bsc_aw_md_api.clear_all_cache;
162: l_old_upgrade_version:=bsc_aw_md_api.get_upgrade_version;
163: log('System Upgrade, New version='||bsc_aw_utility.g_upgrade_version||', Old version='||l_old_upgrade_version);

Line 163: log('System Upgrade, New version='||bsc_aw_utility.g_upgrade_version||', Old version='||l_old_upgrade_version);

159: bsc_aw_utility.get_db_lock('bsc_aw_system_upgrade');
160: set_up(p_options);
161: bsc_aw_md_api.clear_all_cache;
162: l_old_upgrade_version:=bsc_aw_md_api.get_upgrade_version;
163: log('System Upgrade, New version='||bsc_aw_utility.g_upgrade_version||', Old version='||l_old_upgrade_version);
164: if bsc_aw_utility.g_upgrade_version>l_old_upgrade_version then
165: bsc_aw_management.get_workspace_lock('rw',p_options);
166: upgrade(bsc_aw_utility.g_upgrade_version,l_old_upgrade_version);
167: bsc_aw_management.commit_aw;

Line 164: if bsc_aw_utility.g_upgrade_version>l_old_upgrade_version then

160: set_up(p_options);
161: bsc_aw_md_api.clear_all_cache;
162: l_old_upgrade_version:=bsc_aw_md_api.get_upgrade_version;
163: log('System Upgrade, New version='||bsc_aw_utility.g_upgrade_version||', Old version='||l_old_upgrade_version);
164: if bsc_aw_utility.g_upgrade_version>l_old_upgrade_version then
165: bsc_aw_management.get_workspace_lock('rw',p_options);
166: upgrade(bsc_aw_utility.g_upgrade_version,l_old_upgrade_version);
167: bsc_aw_management.commit_aw;
168: commit;

Line 166: upgrade(bsc_aw_utility.g_upgrade_version,l_old_upgrade_version);

162: l_old_upgrade_version:=bsc_aw_md_api.get_upgrade_version;
163: log('System Upgrade, New version='||bsc_aw_utility.g_upgrade_version||', Old version='||l_old_upgrade_version);
164: if bsc_aw_utility.g_upgrade_version>l_old_upgrade_version then
165: bsc_aw_management.get_workspace_lock('rw',p_options);
166: upgrade(bsc_aw_utility.g_upgrade_version,l_old_upgrade_version);
167: bsc_aw_management.commit_aw;
168: commit;
169: bsc_aw_management.detach_workspace;
170: end if;

Line 171: bsc_aw_utility.release_db_lock('bsc_aw_system_upgrade');

167: bsc_aw_management.commit_aw;
168: commit;
169: bsc_aw_management.detach_workspace;
170: end if;
171: bsc_aw_utility.release_db_lock('bsc_aw_system_upgrade');
172: Exception when others then
173: rollback;
174: bsc_aw_utility.release_db_lock('bsc_aw_system_upgrade');
175: bsc_aw_management.detach_workspace;

Line 174: bsc_aw_utility.release_db_lock('bsc_aw_system_upgrade');

170: end if;
171: bsc_aw_utility.release_db_lock('bsc_aw_system_upgrade');
172: Exception when others then
173: rollback;
174: bsc_aw_utility.release_db_lock('bsc_aw_system_upgrade');
175: bsc_aw_management.detach_workspace;
176: log_n('Exception in upgrade '||sqlerrm);
177: raise;
178: End;

Line 199: bsc_aw_utility.open_file('TEST');

195: --------------------------------------------
196:
197: procedure set_up(p_options varchar2) is
198: Begin
199: bsc_aw_utility.open_file('TEST');
200: bsc_aw_utility.g_options.delete;
201: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
202: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
203: init_all;

Line 200: bsc_aw_utility.g_options.delete;

196:
197: procedure set_up(p_options varchar2) is
198: Begin
199: bsc_aw_utility.open_file('TEST');
200: bsc_aw_utility.g_options.delete;
201: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
202: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
203: init_all;
204: Exception when others then

Line 201: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);

197: procedure set_up(p_options varchar2) is
198: Begin
199: bsc_aw_utility.open_file('TEST');
200: bsc_aw_utility.g_options.delete;
201: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
202: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
203: init_all;
204: Exception when others then
205: rollback;

Line 202: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);

198: Begin
199: bsc_aw_utility.open_file('TEST');
200: bsc_aw_utility.g_options.delete;
201: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
202: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
203: init_all;
204: Exception when others then
205: rollback;
206: log_n('Exception in set_up '||sqlerrm);

Line 215: bsc_aw_utility.get_db_lock('bsc_aw_table_create_lock');

211: Begin
212: --set g_adv_sum_profile
213: g_adv_sum_profile:=0;
214: /*serialize entry here */
215: bsc_aw_utility.get_db_lock('bsc_aw_table_create_lock');
216: bsc_aw_utility.create_temp_tables;
217: bsc_aw_utility.create_perm_tables;
218: bsc_aw_utility.release_db_lock('bsc_aw_table_create_lock');
219: /* */

Line 216: bsc_aw_utility.create_temp_tables;

212: --set g_adv_sum_profile
213: g_adv_sum_profile:=0;
214: /*serialize entry here */
215: bsc_aw_utility.get_db_lock('bsc_aw_table_create_lock');
216: bsc_aw_utility.create_temp_tables;
217: bsc_aw_utility.create_perm_tables;
218: bsc_aw_utility.release_db_lock('bsc_aw_table_create_lock');
219: /* */
220: if bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'DEBUG LOG')='Y'

Line 217: bsc_aw_utility.create_perm_tables;

213: g_adv_sum_profile:=0;
214: /*serialize entry here */
215: bsc_aw_utility.get_db_lock('bsc_aw_table_create_lock');
216: bsc_aw_utility.create_temp_tables;
217: bsc_aw_utility.create_perm_tables;
218: bsc_aw_utility.release_db_lock('bsc_aw_table_create_lock');
219: /* */
220: if bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'DEBUG LOG')='Y'
221: or bsc_aw_utility.g_log_level>=FND_LOG.G_CURRENT_RUNTIME_LEVEL then

Line 218: bsc_aw_utility.release_db_lock('bsc_aw_table_create_lock');

214: /*serialize entry here */
215: bsc_aw_utility.get_db_lock('bsc_aw_table_create_lock');
216: bsc_aw_utility.create_temp_tables;
217: bsc_aw_utility.create_perm_tables;
218: bsc_aw_utility.release_db_lock('bsc_aw_table_create_lock');
219: /* */
220: if bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'DEBUG LOG')='Y'
221: or bsc_aw_utility.g_log_level>=FND_LOG.G_CURRENT_RUNTIME_LEVEL then
222: g_debug:=true;

Line 220: if bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'DEBUG LOG')='Y'

216: bsc_aw_utility.create_temp_tables;
217: bsc_aw_utility.create_perm_tables;
218: bsc_aw_utility.release_db_lock('bsc_aw_table_create_lock');
219: /* */
220: if bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'DEBUG LOG')='Y'
221: or bsc_aw_utility.g_log_level>=FND_LOG.G_CURRENT_RUNTIME_LEVEL then
222: g_debug:=true;
223: else
224: g_debug:=false;

Line 221: or bsc_aw_utility.g_log_level>=FND_LOG.G_CURRENT_RUNTIME_LEVEL then

217: bsc_aw_utility.create_perm_tables;
218: bsc_aw_utility.release_db_lock('bsc_aw_table_create_lock');
219: /* */
220: if bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'DEBUG LOG')='Y'
221: or bsc_aw_utility.g_log_level>=FND_LOG.G_CURRENT_RUNTIME_LEVEL then
222: g_debug:=true;
223: else
224: g_debug:=false;
225: end if;

Line 227: bsc_aw_utility.init_all(g_debug);

223: else
224: g_debug:=false;
225: end if;
226: /* */
227: bsc_aw_utility.init_all(g_debug);
228: bsc_aw_adapter_dim.init_all;
229: bsc_aw_adapter_kpi.init_all;
230: bsc_aw_load_dim.init_all;
231: bsc_aw_load_kpi.init_all;

Line 247: bsc_aw_utility.log(p_message);

243: End;
244:
245: procedure log(p_message varchar2) is
246: Begin
247: bsc_aw_utility.log(p_message);
248: Exception when others then
249: null;
250: End;
251: