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_VG_REPOSITORY_MEDIATOR dependencies on BIS_DEBUG_PUB

Line 52: BIS_DEBUG_PUB.Add('> init_string_generator');

48: l_dummy NUMBER;
49: --
50: BEGIN
51:
52: BIS_DEBUG_PUB.Add('> init_string_generator');
53: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
54: l_statement := l_statement || '''' || p_View_Name || '''';
55: g_cursor := DBMS_SQL.OPEN_CURSOR;
56: DBMS_SQL.PARSE(g_cursor, l_statement, DBMS_SQL.NATIVE);

Line 61: BIS_DEBUG_PUB.Add('< init_string_generator');

57: DBMS_SQL.DEFINE_COLUMN_LONG(g_cursor, 1);
58: l_dummy := DBMS_SQL.EXECUTE(g_cursor);
59: l_dummy := DBMS_SQL.FETCH_ROWS(g_cursor);
60: g_current_posn := 0;
61: BIS_DEBUG_PUB.Add('< init_string_generator');
62:
63:
64: EXCEPTION
65: when FND_API.G_EXC_ERROR then

Line 107: BIS_DEBUG_PUB.Add('> String_Generator_Get_String');

103: IS
104: l_dummy VARCHAR2(1000);
105: l_chunk_size_ret INTEGER;
106: BEGIN
107: BIS_DEBUG_PUB.Add('> String_Generator_Get_String');
108: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
109: DBMS_SQL.COLUMN_VALUE_LONG( g_cursor
110: , 1
111: , p_chunk_size

Line 135: BIS_DEBUG_PUB.Add('< String_Generator_Get_String');

131: x_string := Substr(x_string, 1, l_chunk_size_ret);
132: ELSE
133: x_eod := TRUE;
134: END IF;
135: BIS_DEBUG_PUB.Add('< String_Generator_Get_String');
136:
137:
138: EXCEPTION
139: when FND_API.G_EXC_ERROR then

Line 182: BIS_DEBUG_PUB.Add('> create_View_Select_Text_Table');

178: l_string VARCHAR2(200);
179:
180: BEGIN
181:
182: BIS_DEBUG_PUB.Add('> create_View_Select_Text_Table');
183: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
184:
185: l_eod := FALSE;
186:

Line 199: bis_debug_pub.add('l_string := ' || l_string);

195: --- , x_return_status
196: , x_error_Tbl
197: );
198:
199: bis_debug_pub.add('l_string := ' || l_string);
200: x_View_Select_Text_Table(x_View_Select_Text_Table.COUNT + 1):= l_string;
201:
202: END LOOP;
203:

Line 206: BIS_DEBUG_PUB.Add('< create_View_Select_Text_Table');

202: END LOOP;
203:
204: DBMS_SQL.CLOSE_CURSOR(g_cursor);
205:
206: BIS_DEBUG_PUB.Add('< create_View_Select_Text_Table');
207:
208:
209: EXCEPTION
210: when FND_API.G_EXC_ERROR then

Line 268: BIS_DEBUG_PUB.Add('> create_View_Text_Tables');

264: where TABLE_NAME=Upper(p_view_name)
265: order by COLUMN_ID;
266: --
267: BEGIN
268: BIS_DEBUG_PUB.Add('> create_View_Text_Tables');
269: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
270: --
271: l_Done := FALSE;
272: l_count := 1;

Line 275: Bis_debug_pub.Add('view name = '||p_view_name);

271: l_Done := FALSE;
272: l_count := 1;
273: --
274: -- get the select text
275: Bis_debug_pub.Add('view name = '||p_view_name);
276:
277: create_View_Select_Text_Table ( p_View_name
278: , x_View_Select_Text_Table
279: --- , x_return_status

Line 283: BIS_DEBUG_PUB.Add('text count = '||x_View_Select_Text_Table.COUNT);

279: --- , x_return_status
280: , x_error_Tbl
281: );
282: --
283: BIS_DEBUG_PUB.Add('text count = '||x_View_Select_Text_Table.COUNT);
284: l_count := 1;
285: -- get the columns
286: FOR cr IN c_all_columns LOOP
287: x_view_column_text_table(l_count) := cr.column_name;

Line 291: BIS_DEBUG_PUB.Add('< create_View_Text_Tables');

287: x_view_column_text_table(l_count) := cr.column_name;
288: l_count := l_count + 1;
289: END LOOP;
290: --
291: BIS_DEBUG_PUB.Add('< create_View_Text_Tables');
292:
293: EXCEPTION
294: when FND_API.G_EXC_ERROR then
295:

Line 344: BIS_DEBUG_PUB.Add('> get_app_info');

340: FROM fnd_application
341: WHERE application_short_name = Lower(p_short_name);
342:
343: BEGIN
344: BIS_DEBUG_PUB.Add('> get_app_info');
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346: l_view_rec := p_view_rec;
347: l_pos := Instr(l_view_rec.view_name, 'BV_');
348: IF (l_pos = 0) THEN

Line 351: BIS_DEBUG_PUB.Add('< get_app_info');

347: l_pos := Instr(l_view_rec.view_name, 'BV_');
348: IF (l_pos = 0) THEN
349: l_pos := Instr(l_view_rec.view_name, 'FV_');
350: IF (l_pos = 0) THEN
351: BIS_DEBUG_PUB.Add('< get_app_info');
352: RETURN NULL;
353: END IF;
354: END IF;
355:

Line 368: BIS_DEBUG_PUB.Add('< get_app_info');

364: FOR cr IN app_cursor(l_view_rec.app_short_name) LOOP
365: l_view_rec.application_id := cr.application_id;
366: END LOOP;
367:
368: BIS_DEBUG_PUB.Add('< get_app_info');
369: RETURN l_view_rec;
370: CLOSE app_cursor;
371:
372: EXCEPTION

Line 421: BIS_DEBUG_PUB.Add('> valid_view');

417: l_compare_string_u VARCHAR2(1000);
418: l_compare_string_l VARCHAR2(1000);
419: BEGIN
420:
421: BIS_DEBUG_PUB.Add('> valid_view');
422: l_eod := FALSE;
423: l_compare_string_u := Upper(p_compare_string);
424: l_compare_string_l := Lower(p_compare_string);
425:

Line 447: BIS_DEBUG_PUB.Add('< valid_view');

443: END LOOP;
444:
445: DBMS_SQL.CLOSE_CURSOR(g_cursor);
446:
447: BIS_DEBUG_PUB.Add('< valid_view');
448:
449: RETURN l_found;
450:
451:

Line 520: BIS_DEBUG_PUB.Add('> retrieve_business_views_field');

516:
517: l_view_rec bis_vg_types.view_table_rec_type;
518: l_valid_view BOOLEAN;
519: begin
520: BIS_DEBUG_PUB.Add('> retrieve_business_views_field');
521:
522: FOR cr IN c_field_views(p_search_string) LOOP
523: l_view_rec.view_name := cr.view_name;
524: l_view_rec.text_length := cr.text_length;

Line 539: BIS_DEBUG_PUB.Add('< retrieve_business_views_field');

535: x_view_table(x_view_table.COUNT + 1) := l_view_rec;
536: END IF;
537:
538: END LOOP;
539: BIS_DEBUG_PUB.Add('< retrieve_business_views_field');
540:
541: EXCEPTION
542: when FND_API.G_EXC_ERROR then
543: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 589: BIS_DEBUG_PUB.Add('> retrieve_business_views_kfx');

585: l_search_string VARCHAR2(100);
586:
587: BEGIN
588:
589: BIS_DEBUG_PUB.Add('> retrieve_business_views_kfx');
590:
591: l_compare_string := '_KF:' || p_kf_app_short_name
592: ||':' ||p_key_flex_code;
593:

Line 602: BIS_DEBUG_PUB.Add('< retrieve_business_views_kfx');

598: , x_view_table
599: , x_return_status
600: , x_error_Tbl
601: );
602: BIS_DEBUG_PUB.Add('< retrieve_business_views_kfx');
603:
604: EXCEPTION
605: when FND_API.G_EXC_ERROR then
606: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 649: BIS_DEBUG_PUB.Add('> retrieve_business_views_dfx');

645: l_search_string VARCHAR2(100);
646:
647: BEGIN
648:
649: BIS_DEBUG_PUB.Add('> retrieve_business_views_dfx');
650:
651: l_compare_string := '_DF:' || p_df_app_short_name
652: ||':' ||p_Desc_Flex_Name;
653:

Line 662: BIS_DEBUG_PUB.Add('< retrieve_business_views_dfx');

658: , x_view_table
659: , x_return_status
660: , x_error_Tbl
661: );
662: BIS_DEBUG_PUB.Add('< retrieve_business_views_dfx');
663:
664: EXCEPTION
665: when FND_API.G_EXC_ERROR then
666: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 711: BIS_DEBUG_PUB.Add('> retrieve_business_views_lat');

707: l_search_string VARCHAR2(100);
708:
709: BEGIN
710:
711: BIS_DEBUG_PUB.Add('> retrieve_business_views_lat');
712:
713: l_compare_string := ':'||p_lookup_table_name||':'||p_lookup_Type||':';
714:
715: l_search_string := '\_LA:%';

Line 723: BIS_DEBUG_PUB.Add('< retrieve_business_views_lat');

719: , x_view_table
720: , x_return_status
721: , x_error_Tbl
722: );
723: BIS_DEBUG_PUB.Add('< retrieve_business_views_lat');
724:
725: EXCEPTION
726: when FND_API.G_EXC_ERROR then
727: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 772: BIS_DEBUG_PUB.Add('> retrieve_Business_Views_view_name');

768: FROM user_views
769: WHERE view_name = Upper(p_view_name);
770: l_view_rec bis_vg_types.view_table_rec_type;
771: BEGIN
772: BIS_DEBUG_PUB.Add('> retrieve_Business_Views_view_name');
773: BIS_DEBUG_PUB.Add('view-name is '||p_view_name);
774: FOR cr IN c_all_views LOOP
775: l_view_rec.view_name := cr.view_name;
776: l_view_rec.text_length := cr.text_length;

Line 773: BIS_DEBUG_PUB.Add('view-name is '||p_view_name);

769: WHERE view_name = Upper(p_view_name);
770: l_view_rec bis_vg_types.view_table_rec_type;
771: BEGIN
772: BIS_DEBUG_PUB.Add('> retrieve_Business_Views_view_name');
773: BIS_DEBUG_PUB.Add('view-name is '||p_view_name);
774: FOR cr IN c_all_views LOOP
775: l_view_rec.view_name := cr.view_name;
776: l_view_rec.text_length := cr.text_length;
777: l_view_rec := get_app_info(l_view_rec, x_return_status, x_error_Tbl);

Line 783: BIS_DEBUG_PUB.Add('< retrieve_Business_Views_view_name');

779: x_view_table(x_view_table.COUNT + 1) := l_view_rec;
780: END IF;
781:
782: END LOOP;
783: BIS_DEBUG_PUB.Add('< retrieve_Business_Views_view_name');
784:
785: EXCEPTION
786: when FND_API.G_EXC_ERROR then
787: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 852: BIS_DEBUG_PUB.Add('> retrieve_Business_Views_app');

848: l_app_abbrev BIS_VG_TYPES.app_short_name_type;
849: l_view_table BIS_VG_TYPES.view_table_type;
850: BEGIN
851:
852: BIS_DEBUG_PUB.Add('> retrieve_Business_Views_app');
853:
854: BIS_DEBUG_PUB.Add('short_name = '||p_app_short_name);
855: -- Handle HR product views as a special case
856: IF UPPER(p_app_short_name) = 'HR' then

Line 854: BIS_DEBUG_PUB.Add('short_name = '||p_app_short_name);

850: BEGIN
851:
852: BIS_DEBUG_PUB.Add('> retrieve_Business_Views_app');
853:
854: BIS_DEBUG_PUB.Add('short_name = '||p_app_short_name);
855: -- Handle HR product views as a special case
856: IF UPPER(p_app_short_name) = 'HR' then
857: FOR cr IN c_hr_views
858: LOOP

Line 859: BIS_DEBUG_PUB.Add('view_name = '||cr.view_name);

855: -- Handle HR product views as a special case
856: IF UPPER(p_app_short_name) = 'HR' then
857: FOR cr IN c_hr_views
858: LOOP
859: BIS_DEBUG_PUB.Add('view_name = '||cr.view_name);
860: BIS_DEBUG_PUB.Add('text length = '||cr.text_length);
861: l_view_rec.view_name := cr.view_name;
862: l_view_rec.text_length := cr.text_length;
863: l_view_rec := get_app_info(l_view_rec, x_return_status, x_error_Tbl);

Line 860: BIS_DEBUG_PUB.Add('text length = '||cr.text_length);

856: IF UPPER(p_app_short_name) = 'HR' then
857: FOR cr IN c_hr_views
858: LOOP
859: BIS_DEBUG_PUB.Add('view_name = '||cr.view_name);
860: BIS_DEBUG_PUB.Add('text length = '||cr.text_length);
861: l_view_rec.view_name := cr.view_name;
862: l_view_rec.text_length := cr.text_length;
863: l_view_rec := get_app_info(l_view_rec, x_return_status, x_error_Tbl);
864: x_view_table(l_count) := l_view_rec;

Line 866: BIS_DEBUG_PUB.Add('l_count = '||l_count);

862: l_view_rec.text_length := cr.text_length;
863: l_view_rec := get_app_info(l_view_rec, x_return_status, x_error_Tbl);
864: x_view_table(l_count) := l_view_rec;
865: l_count := l_count +1;
866: BIS_DEBUG_PUB.Add('l_count = '||l_count);
867: END LOOP;
868: ELSE
869: FOR cr IN c_all_views(p_app_short_name)
870: LOOP

Line 871: BIS_DEBUG_PUB.Add('view_name = '||cr.view_name);

867: END LOOP;
868: ELSE
869: FOR cr IN c_all_views(p_app_short_name)
870: LOOP
871: BIS_DEBUG_PUB.Add('view_name = '||cr.view_name);
872: BIS_DEBUG_PUB.Add('text length = '||cr.text_length);
873: l_view_rec.view_name := cr.view_name;
874: l_view_rec.text_length := cr.text_length;
875: l_view_rec := get_app_info(l_view_rec, x_return_status, x_error_Tbl);

Line 872: BIS_DEBUG_PUB.Add('text length = '||cr.text_length);

868: ELSE
869: FOR cr IN c_all_views(p_app_short_name)
870: LOOP
871: BIS_DEBUG_PUB.Add('view_name = '||cr.view_name);
872: BIS_DEBUG_PUB.Add('text length = '||cr.text_length);
873: l_view_rec.view_name := cr.view_name;
874: l_view_rec.text_length := cr.text_length;
875: l_view_rec := get_app_info(l_view_rec, x_return_status, x_error_Tbl);
876: x_view_table(l_count) := l_view_rec;

Line 878: BIS_DEBUG_PUB.Add('l_count = '||l_count);

874: l_view_rec.text_length := cr.text_length;
875: l_view_rec := get_app_info(l_view_rec, x_return_status, x_error_Tbl);
876: x_view_table(l_count) := l_view_rec;
877: l_count := l_count +1;
878: BIS_DEBUG_PUB.Add('l_count = '||l_count);
879: END LOOP;
880: END IF;
881:
882: -- handle special cases

Line 931: BIS_DEBUG_PUB.Add('< retrieve_Business_Views_app');

927: FOR i IN 1 .. l_view_table.COUNT LOOP
928: x_view_table(x_view_table.COUNT + 1) := l_view_table(i);
929: END LOOP;
930:
931: BIS_DEBUG_PUB.Add('< retrieve_Business_Views_app');
932:
933:
934: EXCEPTION
935: when FND_API.G_EXC_ERROR then

Line 1061: BIS_DEBUG_PUB.Add('> retrieve_Business_Views');

1057: IS
1058: --
1059: BEGIN
1060:
1061: BIS_DEBUG_PUB.Add('> retrieve_Business_Views');
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1063:
1064: IF (p_all_flag = fnd_api.g_true) THEN
1065:

Line 1121: BIS_DEBUG_PUB.Add('< retrieve_Business_Views');

1117: );
1118:
1119: END IF;
1120:
1121: BIS_DEBUG_PUB.Add('< retrieve_Business_Views');
1122:
1123: EXCEPTION
1124: when FND_API.G_EXC_ERROR then
1125: x_return_status := FND_API.G_RET_STS_ERROR ;