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.BIS_TARGET_UTIL dependencies on BIS_DEBUG_PUB

Line 89: BIS_debug_pub.Debug_OFF;

85: l_return_status Varchar2(30);
86: l_msg Varchar2(100);
87: l_file Varchar2(20);
88: Begin
89: BIS_debug_pub.Debug_OFF;
90:
91: l_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: -- Initialize message list.

Line 98: BIS_debug_pub.add('Selecting row from BIS_target_levels for : '

94: if p_msg_init = FND_API.G_TRUE then
95: FND_MSG_PUB.initialize;
96: end if;
97:
98: BIS_debug_pub.add('Selecting row from BIS_target_levels for : '
99: || p_ind_level_name);
100:
101: select *
102: into l_trg_lvl_rec

Line 107: BIS_debug_pub.add('Select Level Name For Time');

103: from BIS_target_levels
104: where short_name = p_ind_level_name;
105:
106: -- Time dimension
107: BIS_debug_pub.add('Select Level Name For Time');
108: if l_trg_lvl_rec.time_level_id is not null then
109: Get_Level_name
110: (p_level_id => l_trg_lvl_rec.time_level_id
111: ,x_level_name => l_level_name

Line 116: BIS_debug_pub.add('The return status is ' || l_return_status || ': and'

112: ,x_return_status => l_return_status
113: ,x_msg_count => x_msg_count
114: ,x_msg_data => x_msg_data);
115:
116: BIS_debug_pub.add('The return status is ' || l_return_status || ': and'
117: || ' time level name is :' || l_level_name);
118:
119: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 162: BIS_debug_pub.add('Select Level Name For Org');

158: end if;
159:
160: -- Org Dimension
161: if l_trg_lvl_rec.org_level_id is not null then
162: BIS_debug_pub.add('Select Level Name For Org');
163: Get_Level_name
164: (p_level_id => l_trg_lvl_rec.org_level_id
165: ,x_level_name => l_level_name
166: ,x_return_status => l_return_status

Line 169: BIS_debug_pub.add('The return status is ' || l_return_status || ': and'

165: ,x_level_name => l_level_name
166: ,x_return_status => l_return_status
167: ,x_msg_count => x_msg_count
168: ,x_msg_data => x_msg_data);
169: BIS_debug_pub.add('The return status is ' || l_return_status || ': and'
170: || ' org level name is:' || l_level_name);
171: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 185: BIS_debug_pub.add('Select Level Name For Dimension 1');

181: end if;
182: end if;
183: -- Dimesion 1
184: if l_trg_lvl_rec.dimension1_level_id is not null then
185: BIS_debug_pub.add('Select Level Name For Dimension 1');
186: Get_Level_name
187: (p_level_id => l_trg_lvl_rec.dimension1_level_id
188: ,x_level_name => l_level_name
189: ,x_return_status => l_return_status

Line 192: BIS_debug_pub.add('The return status is ' || l_return_status || ': and'

188: ,x_level_name => l_level_name
189: ,x_return_status => l_return_status
190: ,x_msg_count => x_msg_count
191: ,x_msg_data => x_msg_data);
192: BIS_debug_pub.add('The return status is ' || l_return_status || ': and'
193: || ' Dimension1 level name is:' || l_level_name);
194: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 208: BIS_debug_pub.add('Select Level Name For Dimension 2');

204: end if;
205: end if;
206: -- Dimesion 2
207: if l_trg_lvl_rec.dimension2_level_id is not null then
208: BIS_debug_pub.add('Select Level Name For Dimension 2');
209: Get_Level_name
210: (p_level_id => l_trg_lvl_rec.dimension2_level_id
211: ,x_level_name => l_level_name
212: ,x_return_status => l_return_status

Line 215: BIS_debug_pub.add('The return status is ' || l_return_status || ': and'

211: ,x_level_name => l_level_name
212: ,x_return_status => l_return_status
213: ,x_msg_count => x_msg_count
214: ,x_msg_data => x_msg_data);
215: BIS_debug_pub.add('The return status is ' || l_return_status || ': and'
216: || ' Dimension2 level name is:' || l_level_name);
217: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 231: BIS_debug_pub.add('Select Level Name For Dimension 3');

227: end if;
228: end if;
229: -- Dimesion 3
230: if l_trg_lvl_rec.dimension3_level_id is not null then
231: BIS_debug_pub.add('Select Level Name For Dimension 3');
232: Get_Level_name
233: (p_level_id => l_trg_lvl_rec.dimension3_level_id
234: ,x_level_name => l_level_name
235: ,x_return_status => l_return_status

Line 238: BIS_debug_pub.add('The return status is ' || l_return_status || ': and'

234: ,x_level_name => l_level_name
235: ,x_return_status => l_return_status
236: ,x_msg_count => x_msg_count
237: ,x_msg_data => x_msg_data);
238: BIS_debug_pub.add('The return status is ' || l_return_status || ': and'
239: || ' Dimension3 level name is:' || l_level_name);
240: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 254: BIS_debug_pub.add('Select Level Name For Dimension 4');

250: end if;
251: end if;
252: -- Dimesion 4
253: if l_trg_lvl_rec.dimension4_level_id is not null then
254: BIS_debug_pub.add('Select Level Name For Dimension 4');
255: Get_Level_name
256: (p_level_id => l_trg_lvl_rec.dimension4_level_id
257: ,x_level_name => l_level_name
258: ,x_return_status => l_return_status

Line 261: BIS_debug_pub.add('The return status is ' || l_return_status || ': and'

257: ,x_level_name => l_level_name
258: ,x_return_status => l_return_status
259: ,x_msg_count => x_msg_count
260: ,x_msg_data => x_msg_data);
261: BIS_debug_pub.add('The return status is ' || l_return_status || ': and'
262: || ' Dimension4 level name is:' || l_level_name);
263: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 277: BIS_debug_pub.add('Select Level Name For Dimension 5');

273: end if;
274: end if;
275: -- Dimesion 5
276: if l_trg_lvl_rec.dimension5_level_id is not null then
277: BIS_debug_pub.add('Select Level Name For Dimension 5');
278: Get_Level_name
279: (p_level_id => l_trg_lvl_rec.dimension5_level_id
280: ,x_level_name => l_level_name
281: ,x_return_status => l_return_status

Line 284: BIS_debug_pub.add('The return status is ' || l_return_status || ': and'

280: ,x_level_name => l_level_name
281: ,x_return_status => l_return_status
282: ,x_msg_count => x_msg_count
283: ,x_msg_data => x_msg_data);
284: BIS_debug_pub.add('The return status is ' || l_return_status || ': and'
285: || ' Dimension5 level name is:' || l_level_name);
286: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 303: BIS_debug_pub.add('sql statement: ' || ' create or replace force view bis_'

299: -- Open cursor
300: l_cursor := dbms_sql.open_cursor;
301:
302: -- parse the statment
303: BIS_debug_pub.add('sql statement: ' || ' create or replace force view bis_'
304: || substr(replace(p_ind_level_name,' ','_'),1,24)
305: || '_v(' );
306: BIS_debug_pub.add(l_level_col_list1 || l_level_col_list2);
307: BIS_debug_pub.add(l_level_col_list3|| ') as select ' );

Line 306: BIS_debug_pub.add(l_level_col_list1 || l_level_col_list2);

302: -- parse the statment
303: BIS_debug_pub.add('sql statement: ' || ' create or replace force view bis_'
304: || substr(replace(p_ind_level_name,' ','_'),1,24)
305: || '_v(' );
306: BIS_debug_pub.add(l_level_col_list1 || l_level_col_list2);
307: BIS_debug_pub.add(l_level_col_list3|| ') as select ' );
308: BIS_debug_pub.add(l_level_select_list1 || l_level_select_list2|| l_level_select_list3);
309: BIS_debug_pub.add(l_view_from_stmt);
310: BIS_debug_pub.add(substr(l_view_from_stmt2,1,150));

Line 307: BIS_debug_pub.add(l_level_col_list3|| ') as select ' );

303: BIS_debug_pub.add('sql statement: ' || ' create or replace force view bis_'
304: || substr(replace(p_ind_level_name,' ','_'),1,24)
305: || '_v(' );
306: BIS_debug_pub.add(l_level_col_list1 || l_level_col_list2);
307: BIS_debug_pub.add(l_level_col_list3|| ') as select ' );
308: BIS_debug_pub.add(l_level_select_list1 || l_level_select_list2|| l_level_select_list3);
309: BIS_debug_pub.add(l_view_from_stmt);
310: BIS_debug_pub.add(substr(l_view_from_stmt2,1,150));
311: BIS_debug_pub.add(substr(l_view_from_stmt2,151));

Line 308: BIS_debug_pub.add(l_level_select_list1 || l_level_select_list2|| l_level_select_list3);

304: || substr(replace(p_ind_level_name,' ','_'),1,24)
305: || '_v(' );
306: BIS_debug_pub.add(l_level_col_list1 || l_level_col_list2);
307: BIS_debug_pub.add(l_level_col_list3|| ') as select ' );
308: BIS_debug_pub.add(l_level_select_list1 || l_level_select_list2|| l_level_select_list3);
309: BIS_debug_pub.add(l_view_from_stmt);
310: BIS_debug_pub.add(substr(l_view_from_stmt2,1,150));
311: BIS_debug_pub.add(substr(l_view_from_stmt2,151));
312:

Line 309: BIS_debug_pub.add(l_view_from_stmt);

305: || '_v(' );
306: BIS_debug_pub.add(l_level_col_list1 || l_level_col_list2);
307: BIS_debug_pub.add(l_level_col_list3|| ') as select ' );
308: BIS_debug_pub.add(l_level_select_list1 || l_level_select_list2|| l_level_select_list3);
309: BIS_debug_pub.add(l_view_from_stmt);
310: BIS_debug_pub.add(substr(l_view_from_stmt2,1,150));
311: BIS_debug_pub.add(substr(l_view_from_stmt2,151));
312:
313: dbms_sql.parse(c => l_cursor

Line 310: BIS_debug_pub.add(substr(l_view_from_stmt2,1,150));

306: BIS_debug_pub.add(l_level_col_list1 || l_level_col_list2);
307: BIS_debug_pub.add(l_level_col_list3|| ') as select ' );
308: BIS_debug_pub.add(l_level_select_list1 || l_level_select_list2|| l_level_select_list3);
309: BIS_debug_pub.add(l_view_from_stmt);
310: BIS_debug_pub.add(substr(l_view_from_stmt2,1,150));
311: BIS_debug_pub.add(substr(l_view_from_stmt2,151));
312:
313: dbms_sql.parse(c => l_cursor
314: ,statement=> ' create or replace force view bis_'

Line 311: BIS_debug_pub.add(substr(l_view_from_stmt2,151));

307: BIS_debug_pub.add(l_level_col_list3|| ') as select ' );
308: BIS_debug_pub.add(l_level_select_list1 || l_level_select_list2|| l_level_select_list3);
309: BIS_debug_pub.add(l_view_from_stmt);
310: BIS_debug_pub.add(substr(l_view_from_stmt2,1,150));
311: BIS_debug_pub.add(substr(l_view_from_stmt2,151));
312:
313: dbms_sql.parse(c => l_cursor
314: ,statement=> ' create or replace force view bis_'
315: || substr(replace(p_ind_level_name,' ','_'),1,24)

Line 330: BIS_debug_pub.add('The view creation sql execution result is :'

326: l_sql_result := dbms_sql.execute(l_cursor);
327: -- Close the cursor
328: dbms_sql.close_cursor(l_cursor);
329: -- check for sql execution result
330: BIS_debug_pub.add('The view creation sql execution result is :'
331: || to_char(l_sql_result));
332:
333: if nvl(l_sql_result,-1) <> 0 then
334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 415: BIS_debug_pub.add('In Create Indicator Views');

411: where lvl.indicator_id = ind.indicator_id
412: and ind.short_name = p_indicator_name;
413: l_return_status varchar2(10);
414: Begin
415: BIS_debug_pub.add('In Create Indicator Views');
416: BIS_debug_pub.add('Select Levels for Indicator:' || p_indicator_name);
417: l_return_status := FND_API.G_RET_STS_SUCCESS;
418:
419: -- Initialize message list.

Line 416: BIS_debug_pub.add('Select Levels for Indicator:' || p_indicator_name);

412: and ind.short_name = p_indicator_name;
413: l_return_status varchar2(10);
414: Begin
415: BIS_debug_pub.add('In Create Indicator Views');
416: BIS_debug_pub.add('Select Levels for Indicator:' || p_indicator_name);
417: l_return_status := FND_API.G_RET_STS_SUCCESS;
418:
419: -- Initialize message list.
420: if p_msg_init = FND_API.G_TRUE then

Line 425: BIS_debug_pub.add('Calling Create Level force View for Level:'

421: FND_MSG_PUB.initialize;
422: end if;
423:
424: for r1 in c_levels(p_indicator_name) loop
425: BIS_debug_pub.add('Calling Create Level force View for Level:'
426: || r1.short_name);
427: Create_Ind_Level_View
428: (p_ind_level_name => r1.short_name
429: ,p_msg_init => fnd_api.g_false

Line 494: BIS_debug_pub.add('In Create BIS Views');

490: select short_name
491: from BIS_indicators ;
492: l_return_status varchar2(10);
493: Begin
494: BIS_debug_pub.add('In Create BIS Views');
495: l_return_status := FND_API.G_RET_STS_SUCCESS;
496:
497: -- Initialize message list.
498: if p_msg_init = FND_API.G_TRUE then

Line 503: BIS_debug_pub.add('Calling Create BIS force View for Indicator:'

499: FND_MSG_PUB.initialize;
500: end if;
501:
502: for r1 in c_indicator loop
503: BIS_debug_pub.add('Calling Create BIS force View for Indicator:'
504: || r1.short_name);
505: Create_Indicator_views
506: (p_indicator_name => r1.short_name
507: ,p_msg_init => fnd_api.g_false