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_VG_UTIL

Line 42: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

38: -- ===========================================================================
39: PROCEDURE string_generator_init
40: ( p_view_name IN BIS_VG_TYPES.view_name_type
41: --- , x_return_status OUT VARCHAR2
42: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
43: )
44: IS
45:
46: l_statement VARCHAR2(100)

Line 73: BIS_VG_UTIL.Add_Error_Message

69: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: when others then
72: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: BIS_VG_UTIL.Add_Error_Message
74: ( p_error_msg_id => SQLCODE
75: , p_error_description => SQLERRM
76: , p_error_proc_name => G_PKG_NAME||'.string_generator_init'
77: , p_error_table => x_error_tbl

Line 101: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

97: ( p_chunk_size IN INTEGER
98: , x_string OUT VARCHAR2
99: , x_eod OUT BOOLEAN
100: --- , x_return_status OUT VARCHAR2
101: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
102: )
103: IS
104: l_dummy VARCHAR2(1000);
105: l_chunk_size_ret INTEGER;

Line 120: WHILE ( NOT bis_vg_util.is_char_delimiter( SUBSTR( x_string

116:
117: x_eod := FALSE;
118: IF (l_chunk_size_ret = p_chunk_size) THEN
119: -- we retrived what was required, check that we end on delimiter
120: WHILE ( NOT bis_vg_util.is_char_delimiter( SUBSTR( x_string
121: , l_chunk_size_ret
122: , 1
123: )
124: , l_dummy

Line 147: BIS_VG_UTIL.Add_Error_Message

143: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: when others then
146: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
147: BIS_VG_UTIL.Add_Error_Message
148: ( p_error_msg_id => SQLCODE
149: , p_error_description => SQLERRM
150: , p_error_proc_name => G_PKG_NAME||'.String_Generator_Get_String'
151: , p_error_table => x_error_tbl

Line 173: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

169: -- ============================================================================
170: PROCEDURE create_View_Select_Text_Table
171: ( p_view_name IN BIS_VG_TYPES.View_name_Type := null
172: , x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
173: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
174: )
175: IS
176: --
177: l_eod BOOLEAN;

Line 221: BIS_VG_UTIL.Add_Error_Message

217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: when others then
219: DBMS_SQL.CLOSE_CURSOR(g_cursor);
220:
221: BIS_VG_UTIL.Add_Error_Message
222: ( p_error_msg_id => SQLCODE
223: , p_error_description => SQLERRM
224: , p_error_proc_name => G_PKG_NAME||'.create_View_Select_Text_Table'
225: , p_error_table => x_error_tbl

Line 249: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

245: PROCEDURE create_View_Text_Tables
246: ( p_view_name IN BIS_VG_TYPES.View_name_type := null
247: , x_View_Column_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
248: , x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
249: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
250: )
251: IS
252: l_count NUMBER;
253: l_done BOOLEAN;

Line 305: BIS_VG_UTIL.Add_Error_Message

301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: when others then
303:
304: CLOSE c_all_columns;
305: BIS_VG_UTIL.Add_Error_Message
306: ( p_error_msg_id => SQLCODE
307: , p_error_description => SQLERRM
308: , p_error_proc_name => G_PKG_NAME||'.create_View_Text_Tables'
309: , p_error_table => x_error_tbl

Line 330: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

326: ========================================================================== */
327: FUNCTION get_app_info
328: ( p_view_rec IN bis_vg_types.view_table_rec_type
329: , x_return_status OUT VARCHAR2
330: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
331: )
332: RETURN bis_vg_types.view_table_rec_type
333: IS
334: l_str fnd_application.application_short_name%TYPE;

Line 384: BIS_VG_UTIL.Add_Error_Message

380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: when others then
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383: CLOSE app_cursor;
384: BIS_VG_UTIL.Add_Error_Message
385: ( p_error_msg_id => SQLCODE
386: , p_error_description => SQLERRM
387: , p_error_proc_name => G_PKG_NAME||'.get_app_info'
388: , p_error_table => x_error_tbl

Line 410: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

406: FUNCTION valid_view
407: ( p_compare_string IN VARCHAR2
408: , p_view_name IN VARCHAR2
409: , x_return_status OUT VARCHAR2
410: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
411: )
412: RETURN BOOLEAN
413: IS
414: l_eod BOOLEAN;

Line 464: BIS_VG_UTIL.Add_Error_Message

460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: when others then
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
463: dbms_sql.close_cursor(g_cursor);
464: BIS_VG_UTIL.Add_Error_Message
465: ( p_error_msg_id => SQLCODE
466: , p_error_description => SQLERRM
467: , p_error_proc_name => G_PKG_NAME||'.valid_view'
468: , p_error_table => x_error_tbl

Line 491: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

487: ( p_compare_string IN VARCHAR2
488: , p_search_string IN VARCHAR2
489: , x_View_Table OUT BIS_VG_TYPES.view_table_type
490: , x_return_status OUT VARCHAR2
491: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
492: )
493: IS
494:
495: CURSOR c_field_views(p_like_str IN VARCHAR2) IS

Line 553: BIS_VG_UTIL.Add_Error_Message

549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: when others then
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
552: CLOSE c_field_views;
553: BIS_VG_UTIL.Add_Error_Message
554: ( p_error_msg_id => SQLCODE
555: , p_error_description => SQLERRM
556: , p_error_proc_name => G_PKG_NAME||'.retrieve_business_views_field'
557: , p_error_table => x_error_tbl

Line 580: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

576: ( p_KF_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
577: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
578: , x_View_Table OUT BIS_VG_TYPES.view_table_type
579: , x_return_status OUT VARCHAR2
580: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
581: )
582: IS
583:
584: l_compare_string VARCHAR2(100);

Line 613: BIS_VG_UTIL.Add_Error_Message

609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: when others then
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
613: BIS_VG_UTIL.Add_Error_Message
614: ( p_error_msg_id => SQLCODE
615: , p_error_description => SQLERRM
616: , p_error_proc_name => G_PKG_NAME||'.retrieve_business_views_kfx'
617: , p_error_table => x_error_tbl

Line 640: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

636: ( p_DF_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
637: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
638: , x_View_Table OUT BIS_VG_TYPES.view_table_type
639: , x_return_status OUT VARCHAR2
640: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
641: )
642: IS
643:
644: l_compare_string VARCHAR2(100);

Line 673: BIS_VG_UTIL.Add_Error_Message

669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
671: when others then
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
673: BIS_VG_UTIL.Add_Error_Message
674: ( p_error_msg_id => SQLCODE
675: , p_error_description => SQLERRM
676: , p_error_proc_name => G_PKG_NAME||'.retrieve_business_views_dfx'
677: , p_error_table => x_error_tbl

Line 702: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

698: ( p_Lookup_Table_Name IN VARCHAR2
699: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
700: , x_View_Table OUT BIS_VG_TYPES.view_table_type
701: , x_return_status OUT VARCHAR2
702: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
703: )
704: IS
705:
706: l_compare_string VARCHAR2(100);

Line 734: BIS_VG_UTIL.Add_Error_Message

730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: when others then
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
734: BIS_VG_UTIL.Add_Error_Message
735: ( p_error_msg_id => SQLCODE
736: , p_error_description => SQLERRM
737: , p_error_proc_name => G_PKG_NAME||'.retrieve_business_views_lat'
738: , p_error_table => x_error_tbl

Line 761: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

757: PROCEDURE retrieve_business_view_name
758: ( p_view_name IN BIS_VG_TYPES.View_name_Type
759: , x_View_Table OUT BIS_VG_TYPES.view_table_type
760: , x_return_status OUT VARCHAR2
761: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
762: )
763: IS
764: CURSOR C_all_views IS
765: select

Line 797: BIS_VG_UTIL.Add_Error_Message

793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: when others then
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
796: CLOSE c_all_views;
797: BIS_VG_UTIL.Add_Error_Message
798: ( p_error_msg_id => SQLCODE
799: , p_error_description => SQLERRM
800: , p_error_proc_name => G_PKG_NAME||'.retrieve_Business_View_name'
801: , p_error_table => x_error_tbl

Line 824: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

820: PROCEDURE retrieve_business_views_app
821: ( p_app_short_name IN BIS_VG_TYPES.App_Short_Name_Type
822: , x_View_Table OUT BIS_VG_TYPES.view_table_type
823: , x_return_status OUT VARCHAR2
824: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
825: )
826: IS
827:
828: CURSOR c_all_views(p_app_abbrev IN VARCHAR2) IS

Line 946: BIS_VG_UTIL.Add_Error_Message

942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: when others then
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
945: CLOSE c_all_views;
946: BIS_VG_UTIL.Add_Error_Message
947: ( p_error_msg_id => SQLCODE
948: , p_error_description => SQLERRM
949: , p_error_proc_name => G_PKG_NAME||'.retrieve_business_views_app'
950: , p_error_table => x_error_tbl

Line 971: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

967: ========================================================================== */
968: PROCEDURE retrieve_business_views_all
969: (x_View_Table OUT BIS_VG_TYPES.view_table_type
970: , x_return_status OUT VARCHAR2
971: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
972: )
973: IS
974:
975: CURSOR C_all_views IS

Line 1013: BIS_VG_UTIL.Add_Error_Message

1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: when others then
1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1012: CLOSE c_all_views;
1013: BIS_VG_UTIL.Add_Error_Message
1014: ( p_error_msg_id => SQLCODE
1015: , p_error_description => SQLERRM
1016: , p_error_proc_name => G_PKG_NAME||'.retrieve_business_views_all'
1017: , p_error_table => x_error_tbl

Line 1055: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1051: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type := NULL
1052: , p_View_Name IN BIS_VG_TYPES.View_name_Type := NULL
1053: , x_View_Table OUT BIS_VG_TYPES.View_Table_Type
1054: , x_return_status OUT VARCHAR2
1055: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1056: )
1057: IS
1058: --
1059: BEGIN

Line 1132: BIS_VG_UTIL.Add_Error_Message

1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: when others then
1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1132: BIS_VG_UTIL.Add_Error_Message
1133: ( p_error_msg_id => SQLCODE
1134: , p_error_description => SQLERRM
1135: , p_error_proc_name => G_PKG_NAME||'.retrieve_Business_Views'
1136: , p_error_table => x_error_tbl