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_LOOKUP dependencies on BIS_VG_UTIL

Line 47: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

43: , p_Mode IN NUMBER
44: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
45: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
46: , x_return_status OUT VARCHAR2
47: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
48: )
49: IS
50: l_str VARCHAR2(1000);
51: l_col VARCHAR2(1000);

Line 65: bis_vg_util.print_view_pointer ( x_column_pointer

61: , x_return_status
62: , x_error_Tbl
63: );
64: --
65: bis_vg_util.print_view_pointer ( x_column_pointer
66: , x_return_status
67: , x_error_Tbl
68: );
69: --

Line 70: l_str := bis_vg_util.get_row ( p_view_column_table

66: , x_return_status
67: , x_error_Tbl
68: );
69: --
70: l_str := bis_vg_util.get_row ( p_view_column_table
71: , p_column_pointer
72: , x_return_status
73: , x_error_Tbl
74: );

Line 86: x_column_pointer := bis_vg_util.increment_pointer_by_row

82: , x_error_Tbl
83: );
84: --
85: IF (l_num IS NULL) THEN
86: x_column_pointer := bis_vg_util.increment_pointer_by_row
87: ( p_view_column_table
88: , x_column_pointer
89: , x_return_status
90: , x_error_Tbl

Line 99: BIS_VG_UTIL.Add_Error_message

95: --
96: bis_debug_pub.ADD('column pos = '||l_num);
97: --
98: IF (l_str IS NULL) THEN
99: BIS_VG_UTIL.Add_Error_message
100: ( p_error_msg_name => bis_vg_lookup.lat_col_tag_exp_msg
101: , p_error_proc_name => G_PKG_NAME||'.put_column_name'
102: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
103: , p_error_table => x_error_tbl

Line 118: -- bis_vg_util.print_view_text(x_column_table, x_return_status, x_error_Tbl );

114: -- save to output file
115: x_column_table(x_column_table.COUNT + 1) := l_str;
116: --
117: bis_debug_pub.ADD('column name = '||l_str);
118: -- bis_vg_util.print_view_text(x_column_table, x_return_status, x_error_Tbl );
119: bis_vg_util.print_view_pointer ( x_column_pointer
120: , x_return_status
121: , x_error_Tbl
122: );

Line 119: bis_vg_util.print_view_pointer ( x_column_pointer

115: x_column_table(x_column_table.COUNT + 1) := l_str;
116: --
117: bis_debug_pub.ADD('column name = '||l_str);
118: -- bis_vg_util.print_view_text(x_column_table, x_return_status, x_error_Tbl );
119: bis_vg_util.print_view_pointer ( x_column_pointer
120: , x_return_status
121: , x_error_Tbl
122: );
123: --

Line 139: BIS_VG_UTIL.Add_Error_Message

135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: when others then
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139: BIS_VG_UTIL.Add_Error_Message
140: ( p_error_msg_id => SQLCODE
141: , p_error_description => SQLERRM
142: , p_error_proc_name => G_PKG_NAME||'.put_column_name'
143: , p_error_table => x_error_tbl

Line 172: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

168: ( p_lookup_table IN VARCHAR2
169: , p_lookup_type IN VARCHAR2
170: , p_lookup_column IN VARCHAR2
171: , x_return_status OUT VARCHAR2
172: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
173: )
174: RETURN VARCHAR2
175: IS
176: l_select VARCHAR2(1000);

Line 200: BIS_VG_UTIL.Add_Error_Message

196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: when others then
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
200: BIS_VG_UTIL.Add_Error_Message
201: ( p_error_msg_id => SQLCODE
202: , p_error_description => SQLERRM
203: , p_error_proc_name => G_PKG_NAME||'.get_select_statement'
204: , p_error_table => x_error_tbl

Line 234: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

230: ( p_expr IN VARCHAR2
231: , p_select IN VARCHAR2
232: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
233: , x_return_status OUT VARCHAR2
234: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
235: )
236: IS
237: l_cursor_id INTEGER;
238: l_lookup_code VARCHAR2(250);

Line 293: bis_vg_util.create_Text_Table( '( ' || p_expr

289: END IF;
290: --
291: x_select_table(x_select_table.COUNT + 1) := 'DECODE';
292: --
293: bis_vg_util.create_Text_Table( '( ' || p_expr
294: , l_select_table
295: , x_return_status
296: , x_error_Tbl
297: );

Line 298: bis_vg_util.concatenate_Tables( x_select_table

294: , l_select_table
295: , x_return_status
296: , x_error_Tbl
297: );
298: bis_vg_util.concatenate_Tables( x_select_table
299: , l_select_table
300: , x_select_table
301: , x_return_status
302: , x_error_Tbl

Line 354: BIS_VG_UTIL.Add_Error_Message

350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: when others then
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
353: dbms_sql.close_cursor(l_cursor_id);
354: BIS_VG_UTIL.Add_Error_Message
355: ( p_error_msg_id => SQLCODE
356: , p_error_description => SQLERRM
357: , p_error_proc_name => G_PKG_NAME||'.write_decode_statement'
358: , p_error_table => x_error_tbl

Line 393: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

389: , p_lookup_type IN VARCHAR2
390: , p_lookup_column IN VARCHAR2
391: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
392: , x_return_status OUT VARCHAR2
393: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
394: )
395: IS
396: l_select VARCHAR2(1000);
397: BEGIN

Line 424: BIS_VG_UTIL.Add_Error_message

420: , x_error_Tbl
421: );
422: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
423: THEN
424: BIS_VG_UTIL.Add_Error_message
425: ( p_error_msg_name => bis_vg_lookup.LAT_INVALID_LOOKUP_TYPE_MSG
426: , p_error_proc_name => G_PKG_NAME||'. write_decode_statement'
427: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
428: , p_token1 => 'tag'

Line 456: BIS_VG_UTIL.Add_Error_Message

452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: when others then
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: BIS_VG_UTIL.Add_Error_Message
457: ( p_error_msg_id => SQLCODE
458: , p_error_description => SQLERRM
459: , p_error_proc_name => G_PKG_NAME||'.put_decode_statement'
460: , p_error_table => x_error_tbl

Line 497: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

493: , p_lookup_column IN VARCHAR2
494: , p_language IN VARCHAR2
495: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
496: , x_return_status OUT VARCHAR2
497: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
498: )
499: IS
500: l_select VARCHAR2(1000);
501: l_cursor_id INTEGER;

Line 548: BIS_VG_UTIL.Add_Error_Message

544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: when others then
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548: BIS_VG_UTIL.Add_Error_Message
549: ( p_error_msg_id => SQLCODE
550: , p_error_description => SQLERRM
551: , p_error_proc_name => G_PKG_NAME||'.put_decode_statement_lang'
552: , p_error_table => x_error_tbl

Line 586: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

582: , p_lookup_type IN VARCHAR2
583: , p_lookup_column IN VARCHAR2
584: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
585: , x_return_status OUT VARCHAR2
586: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
587: )
588: IS
589: l_select VARCHAR2(1000);
590: l_cursor_id INTEGER;

Line 660: BIS_VG_UTIL.Add_Error_Message

656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: when others then
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
659: dbms_sql.close_cursor(l_cursor_id);
660: BIS_VG_UTIL.Add_Error_Message
661: ( p_error_msg_id => SQLCODE
662: , p_error_description => SQLERRM
663: , p_error_proc_name => G_PKG_NAME||'.put_decode_statement_languages'
664: , p_error_table => x_error_tbl

Line 690: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

686: ===========================================================================*/
687: FUNCTION check_language
688: ( p_lookup_table IN VARCHAR2
689: , x_return_status OUT VARCHAR2
690: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
691: )
692: RETURN BOOLEAN
693: IS
694: CURSOR col_cursor IS

Line 730: BIS_VG_UTIL.Add_Error_Message

726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
727: if (col_cursor%ISOPEN) THEN
728: CLOSE col_cursor;
729: end if;
730: BIS_VG_UTIL.Add_Error_Message
731: ( p_error_msg_id => SQLCODE
732: , p_error_description => SQLERRM
733: , p_error_proc_name => G_PKG_NAME||'.check_language'
734: , p_error_table => x_error_tbl

Line 769: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

765: , p_lookup_type IN VARCHAR2
766: , p_lookup_column IN VARCHAR2
767: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
768: , x_return_status OUT VARCHAR2
769: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
770: )
771: IS
772: l_lang BOOLEAN := FALSE;
773: BEGIN

Line 817: BIS_VG_UTIL.Add_Error_Message

813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: when others then
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
817: BIS_VG_UTIL.Add_Error_Message
818: ( p_error_msg_id => SQLCODE
819: , p_error_description => SQLERRM
820: , p_error_proc_name => G_PKG_NAME||'.add_select_info'
821: , p_error_table => x_error_tbl

Line 859: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

855: , x_lookup_type OUT VARCHAR2
856: , x_lookup_column OUT VARCHAR2
857: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
858: , x_return_status OUT VARCHAR2
859: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
860: )
861: IS
862: l_str VARCHAR2(2000);
863: l_tmp_pointer bis_vg_types.View_Character_Pointer_Type;

Line 880: IF (bis_vg_util.equal_pointers(

876: , l_tmp_pointer
877: , x_return_status
878: , x_error_Tbl
879: );
880: IF (bis_vg_util.equal_pointers(
881: l_tmp_pointer
882: , x_select_pointer
883: , x_return_status
884: , x_error_Tbl

Line 887: BIS_VG_UTIL.Add_Error_message

883: , x_return_status
884: , x_error_Tbl
885: )
886: ) THEN
887: BIS_VG_UTIL.Add_Error_message
888: ( p_error_msg_name => bis_vg_lookup.LAT_COL_TAG_EXP_NO_EXP_MSG
889: , p_error_proc_name => G_PKG_NAME||'.parse_LA_select'
890: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
891: , p_token1 => 'tag'

Line 903: l_tmp_pointer := bis_vg_util.increment_pointer

899: );
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902:
903: l_tmp_pointer := bis_vg_util.increment_pointer
904: ( p_View_Select_Table
905: , l_tmp_pointer
906: , x_return_status
907: , x_error_Tbl

Line 921: bis_vg_util.equal_pointers(

917: );
918: --
919: IF (x_expr IS NULL
920: OR
921: bis_vg_util.equal_pointers(
922: l_tmp_pointer
923: , x_select_pointer
924: , x_return_status
925: , x_error_Tbl

Line 928: BIS_VG_UTIL.Add_Error_message

924: , x_return_status
925: , x_error_Tbl
926: )
927: ) THEN
928: BIS_VG_UTIL.Add_Error_message
929: ( p_error_msg_name => bis_vg_lookup.LAT_COL_TAG_EXP_NO_EXP_MSG
930: , p_error_proc_name => G_PKG_NAME||'.parse_LA_select'
931: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
932: , p_token1 => 'tag'

Line 961: bis_vg_util.equal_pointers(

957: BIS_DEBUG_PUB.Add('x_lookup_table = '||x_lookup_table);
958: --
959: IF (x_lookup_table IS NULL
960: OR
961: bis_vg_util.equal_pointers(
962: l_tmp_pointer
963: , x_select_pointer
964: , x_return_status
965: , x_error_Tbl

Line 968: BIS_VG_UTIL.Add_Error_message

964: , x_return_status
965: , x_error_Tbl
966: )
967: ) THEN
968: BIS_VG_UTIL.Add_Error_message
969: ( p_error_msg_name => bis_vg_lookup.LAT_SEL_TAG_EXP_NO_TABLE_MSG
970: , p_error_proc_name => G_PKG_NAME||'.parse_LA_select'
971: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
972: , p_token1 => 'tag'

Line 998: bis_vg_util.equal_pointers(

994: BIS_DEBUG_PUB.Add('x_lookup_type = '||x_lookup_type);
995: --
996: IF (x_lookup_type IS NULL
997: OR
998: bis_vg_util.equal_pointers(
999: l_tmp_pointer
1000: , x_select_pointer
1001: , x_return_status
1002: , x_error_Tbl

Line 1005: BIS_VG_UTIL.Add_Error_message

1001: , x_return_status
1002: , x_error_Tbl
1003: )
1004: ) THEN
1005: BIS_VG_UTIL.Add_Error_message
1006: ( p_error_msg_name => bis_vg_lookup.LAT_SEL_TAG_EXP_NO_TYPE_MSG
1007: , p_error_proc_name => G_PKG_NAME||'.parse_LA_select'
1008: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1009: , p_token1 => 'tag'

Line 1036: BIS_VG_UTIL.Add_Error_message

1032: BIS_DEBUG_PUB.Add('x_lookup_column = '||x_lookup_column);
1033: --
1034: IF (x_lookup_column IS NULL
1035: ) THEN
1036: BIS_VG_UTIL.Add_Error_message
1037: ( p_error_msg_name => bis_vg_lookup.LAT_SEL_TAG_EXP_NO_COL_MSG
1038: , p_error_proc_name => G_PKG_NAME||'.parse_LA_select'
1039: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1040: , p_token1 => 'tag'

Line 1066: BIS_VG_UTIL.Add_Error_Message

1062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1064: when others then
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1066: BIS_VG_UTIL.Add_Error_Message
1067: ( p_error_msg_id => SQLCODE
1068: , p_error_description => SQLERRM
1069: , p_error_proc_name => G_PKG_NAME||'.parse_LA_select'
1070: , p_error_table => x_error_tbl

Line 1171: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1167: , p_Mode IN NUMBER
1168: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1169: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
1170: , x_return_status OUT VARCHAR2
1171: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1172: )
1173: IS
1174: l_expr VARCHAR2(2000);
1175: l_tag VARCHAR2(3000);

Line 1195: l_tag := bis_vg_util.get_string ( p_View_Select_Table

1191: , x_error_Tbl
1192:
1193: );
1194:
1195: l_tag := bis_vg_util.get_string ( p_View_Select_Table
1196: , p_Select_Pointer
1197: , x_Select_Pointer
1198: , x_return_status
1199: , x_error_Tbl

Line 1219: BIS_VG_UTIL.Add_Error_message

1215: );
1216: ELSE
1217: -- The lookup table either does not exist
1218: -- or does not contain the column demanded
1219: BIS_VG_UTIL.Add_Error_message
1220: ( p_error_msg_name => bis_vg_lookup.LAT_SEL_TAG_UNDEF_TAB
1221: , p_error_proc_name => G_PKG_NAME||'.put_decode_in_select'
1222: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1223: , p_token1 => 'tab'

Line 1251: BIS_VG_UTIL.Add_Error_Message

1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1249: when others then
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1251: BIS_VG_UTIL.Add_Error_Message
1252: ( p_error_msg_id => SQLCODE
1253: , p_error_description => SQLERRM
1254: , p_error_proc_name => G_PKG_NAME||'.put_decode_in_select'
1255: , p_error_table => x_error_tbl

Line 1298: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1294: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1295: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
1296: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
1297: , x_return_status OUT VARCHAR2
1298: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1299: )
1300: IS
1301: --
1302: BEGIN

Line 1323: -- bis_vg_util.print_view_text(x_column_table, x_return_status, x_error_Tbl);

1319: , x_return_status
1320: , x_error_Tbl
1321: );
1322: --
1323: -- bis_vg_util.print_view_text(x_column_table, x_return_status, x_error_Tbl);
1324: -- bis_vg_util.print_view_text(x_select_table, x_return_status, x_error_Tbl);
1325: --
1326: BIS_DEBUG_PUB.Add('< add_Lookup_Info :-(');
1327: --

Line 1324: -- bis_vg_util.print_view_text(x_select_table, x_return_status, x_error_Tbl);

1320: , x_error_Tbl
1321: );
1322: --
1323: -- bis_vg_util.print_view_text(x_column_table, x_return_status, x_error_Tbl);
1324: -- bis_vg_util.print_view_text(x_select_table, x_return_status, x_error_Tbl);
1325: --
1326: BIS_DEBUG_PUB.Add('< add_Lookup_Info :-(');
1327: --
1328:

Line 1339: BIS_VG_UTIL.Add_Error_Message

1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: when others then
1338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1339: BIS_VG_UTIL.Add_Error_Message
1340: ( p_error_msg_id => SQLCODE
1341: , p_error_description => SQLERRM
1342: , p_error_proc_name => G_PKG_NAME||'.add_Lookup_Info'
1343: , p_error_table => x_error_tbl