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

Line 76: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

72: , x_decode_on_segments OUT BOOLEAN
73: , x_EDW_flag OUT BOOLEAN
74: , x_prefix OUT VARCHAR2
75: , x_return_status OUT VARCHAR2
76: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
77: )
78: IS
79: --
80: l_token VARCHAR2(100);

Line 89: l_string := bis_vg_util.get_row ( p_View_Column_Table

85: BEGIN
86: bis_debug_pub.Add('> parse_KF_Column_Line');
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88: -- get row of text from table
89: l_string := bis_vg_util.get_row ( p_View_Column_Table
90: , p_Column_Pointer
91: , x_return_status
92: , x_error_Tbl
93: );

Line 119: BIS_VG_UTIL.Add_Error_message

115: );
116: bis_debug_pub.Add('x_Concat_Seg_Name = ' || x_Concat_Seg_Name);
117: --
118: IF (x_concat_seg_name IS NULL) THEN
119: BIS_VG_UTIL.Add_Error_message
120: ( p_error_msg_name => BIS_VG_KEY_FLEX.KFX_COL_TAG_EXP_NO_SEG_MSG
121: , p_error_proc_name => G_PKG_NAME||'.parse_KF_Column_Line'
122: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
123: , p_token1 => 'tag'

Line 159: BIS_VG_UTIL.Add_Error_message

155: bis_debug_pub.Add('x_EDW_flag = TRUE'); --EDW flag change
156: ELSE
157: IF(SUBSTR(l_token, 1, 1) = '_') THEN
158: --
159: BIS_VG_UTIL.Add_Error_message
160: ( p_error_msg_name => BIS_VG_KEY_FLEX.KFX_COL_TAG_PREF_CO_MSG
161: , p_error_proc_name => G_PKG_NAME||'.parse_KF_Column_Line'
162: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
163: , p_token1 => 'tag'

Line 203: BIS_VG_UTIL.Add_Error_message

199: x_EDW_flag := TRUE;
200: bis_debug_pub.Add('x_EDW_flag = TRUE'); --EDW flag change
201: ELSE
202: --
203: BIS_VG_UTIL.Add_Error_message
204: ( p_error_msg_name => BIS_VG_KEY_FLEX.KFX_COL_TAG_EXP_BAD_FLAG_MSG
205: , p_error_proc_name => G_PKG_NAME||'.parse_KF_Column_Line'
206: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
207: , p_token1 => 'tag'

Line 224: x_Column_Pointer := bis_vg_util.increment_pointer_by_row

220: END IF;
221: END IF;
222: END IF;
223: END IF;
224: x_Column_Pointer := bis_vg_util.increment_pointer_by_row
225: ( p_View_Column_Table
226: , p_Column_Pointer
227: , x_return_status
228: , x_error_Tbl

Line 241: BIS_VG_UTIL.Add_Error_Message

237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
239: when others then
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
241: BIS_VG_UTIL.Add_Error_Message
242: ( p_error_msg_id => SQLCODE
243: , p_error_description => SQLERRM
244: , p_error_proc_name => G_PKG_NAME||'.parse_KF_Column_Line'
245: , p_error_table => x_error_tbl

Line 319: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

315: , x_Table_Alias OUT VARCHAR2
316: , x_Structure_Column OUT VARCHAR2
317: , x_DUMMY_flag OUT BOOLEAN --EDW flag change
318: , x_return_status OUT VARCHAR2
319: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
320: )
321: IS
322: --
323: l_token VARCHAR2(100);

Line 336: l_tmp_pointer := bis_vg_util.increment_pointer

332: , l_tmp_pointer
333: , x_return_status
334: , x_error_Tbl
335: );
336: l_tmp_pointer := bis_vg_util.increment_pointer
337: ( p_View_Select_Table
338: , l_tmp_pointer
339: , x_return_status
340: , x_error_Tbl

Line 353: IF bis_vg_util.equal_pointers(

349: , x_Select_Pointer
350: , x_return_status
351: , x_error_Tbl
352: );
353: IF bis_vg_util.equal_pointers(
354: l_tmp_pointer
355: , x_select_pointer
356: , x_return_status
357: , x_error_Tbl

Line 374: bis_vg_util.equal_pointers(

370: );
371:
372: IF (l_token IS NULL
373: OR
374: bis_vg_util.equal_pointers(
375: l_tmp_pointer
376: , x_select_pointer
377: , x_return_status
378: , x_error_Tbl

Line 422: BIS_VG_UTIL.Add_Error_message

418: ELSE
419: x_Application_Name := l_token;
420: IF NOT check_application_validity(x_Application_Name)
421: THEN
422: BIS_VG_UTIL.Add_Error_message
423: ( p_error_msg_name => BIS_VG_KEY_FLEX.KFX_SEL_TAG_EXP_INVALID_APP
424: , p_error_proc_name => G_PKG_NAME||'.parse_DF_Select_Line'
425: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
426: , p_token1 => 'tag'

Line 450: bis_vg_util.equal_pointers(

446: );
447: IF(
448: x_Key_Flex_Code IS NULL
449: OR
450: bis_vg_util.equal_pointers(
451: l_tmp_pointer
452: , x_select_pointer
453: , x_return_status
454: , x_error_Tbl

Line 474: IF(bis_vg_util.get_char( p_View_Select_Table

470: IF (x_Table_Alias IS NULL) THEN
471: raise MALFORMED_KFX_SEL_TAG_NO_FIELD;
472: END IF;
473: --
474: IF(bis_vg_util.get_char( p_View_Select_Table
475: , x_Select_Pointer
476: , x_return_status
477: , x_error_Tbl
478: ) = ':') THEN

Line 479: x_Select_Pointer := bis_vg_util.increment_pointer

475: , x_Select_Pointer
476: , x_return_status
477: , x_error_Tbl
478: ) = ':') THEN
479: x_Select_Pointer := bis_vg_util.increment_pointer
480: ( p_View_Select_Table
481: , x_Select_Pointer
482: , x_return_status
483: , x_error_Tbl

Line 495: x_Select_Pointer := bis_vg_util.increment_pointer

491: , x_error_Tbl
492: );
493: END IF;
494: END IF;
495: x_Select_Pointer := bis_vg_util.increment_pointer
496: ( p_View_Select_Table
497: , x_Select_Pointer
498: , x_return_status
499: , x_error_Tbl

Line 508: BIS_VG_UTIL.Add_Error_message

504: EXCEPTION
505: when MALFORMED_KFX_SEL_TAG_NO_FIELD
506: THEN
507: x_return_status := FND_API.G_RET_STS_ERROR ;
508: BIS_VG_UTIL.Add_Error_message
509: ( p_error_msg_name => BIS_VG_KEY_FLEX.KFX_SEL_TAG_EXP_NO_FIELD_MSG
510: , p_error_proc_name => G_PKG_NAME||'.parse_KF_Select_Line'
511: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
512: , p_token1 => 'tag'

Line 531: BIS_VG_UTIL.Add_Error_Message

527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
529: when others then
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
531: BIS_VG_UTIL.Add_Error_Message
532: ( p_error_msg_id => SQLCODE
533: , p_error_description => SQLERRM
534: , p_error_proc_name => G_PKG_NAME||'.parse_KF_Select_Line'
535: , p_error_table => x_error_tbl

Line 586: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

582: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
583: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
584: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
585: , x_return_status OUT VARCHAR2
586: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
587: )
588: IS
589: --
590: l_Segment_List FND_FLEX_KEY_API.SEGMENT_LIST;

Line 692: BIS_VG_UTIL.Add_Error_Message

688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
690: when others then
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
692: BIS_VG_UTIL.Add_Error_Message
693: ( p_error_msg_id => SQLCODE
694: , p_error_description => SQLERRM
695: , p_error_proc_name => G_PKG_NAME||'.add_key_flexfield_segments'
696: , p_error_table => x_error_tbl

Line 729: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

725: , p_Table_Alias IN VARCHAR2
726: , p_pad_count IN NUMBER
727: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
728: , x_return_status OUT VARCHAR2
729: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
730: )
731: IS
732: --
733: l_Segment_List FND_FLEX_KEY_API.SEGMENT_LIST;

Line 795: BIS_VG_UTIL.Add_Error_Message

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

Line 863: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

859: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
860: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
861: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
862: , x_return_status OUT VARCHAR2
863: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
864: )
865: IS
866: --
867:

Line 906: bis_vg_util.create_Text_Table('NULL'

902: --- -1- column table
903: x_Column_Table(1) := l_Prefix || p_Concat_Seg_Name;
904: --- -2- select table
905: IF p_dummy_flag THEN
906: bis_vg_util.create_Text_Table('NULL'
907: , x_Select_Table
908: , x_return_status
909: , x_error_tbl
910: );

Line 913: bis_vg_util.create_Text_Table(p_PLSQL_Expression

909: , x_error_tbl
910: );
911: ELSE
912:
913: bis_vg_util.create_Text_Table(p_PLSQL_Expression
914: , x_Select_Table
915: , x_return_status
916: , x_error_Tbl
917: );

Line 1019: bis_vg_util.concatenate_Tables( x_Select_Table

1015: x_Select_Table(x_Select_Table.COUNT + 1) :=
1016: lpad(', ', 1 + (l_decode_counter * 8));
1017: END IF;
1018:
1019: bis_vg_util.concatenate_Tables( x_Select_Table
1020: , l_Select_Table
1021: , x_Select_Table
1022: , x_return_status
1023: , x_error_Tbl

Line 1095: bis_vg_util.concatenate_Tables(x_Column_Table

1091: , x_return_status
1092: , x_error_Tbl
1093: );
1094: --
1095: bis_vg_util.concatenate_Tables(x_Column_Table
1096: , l_Column_Table
1097: , x_Column_Table
1098: , x_return_status
1099: , x_error_Tbl

Line 1102: bis_vg_util.concatenate_Tables(x_Select_Table

1098: , x_return_status
1099: , x_error_Tbl
1100: );
1101:
1102: bis_vg_util.concatenate_Tables(x_Select_Table
1103: , l_Select_Table
1104: , x_Select_Table
1105: , x_return_status
1106: , x_error_Tbl

Line 1109: bis_vg_util.concatenate_Tables( x_column_comment_table

1105: , x_return_status
1106: , x_error_Tbl
1107: );
1108:
1109: bis_vg_util.concatenate_Tables( x_column_comment_table
1110: , l_column_comment_table
1111: , x_column_comment_table
1112: , x_return_status
1113: , x_error_Tbl

Line 1166: bis_vg_util.print_View_Text

1162: END IF; --- dummy flag
1163: END IF; --- l_count > 2
1164: END IF; ---PLSQL_expression ELSE flexfield full lookup ELSE pruned lookup
1165:
1166: bis_vg_util.print_View_Text
1167: ( x_Column_Table
1168: , x_return_status
1169: , x_error_Tbl
1170: );

Line 1172: bis_vg_util.print_View_Text

1168: , x_return_status
1169: , x_error_Tbl
1170: );
1171:
1172: bis_vg_util.print_View_Text
1173: ( x_Select_Table
1174: , x_return_status
1175: , x_error_Tbl
1176: );

Line 1188: --- BIS_VG_UTIL.Add_Error_message

1184: --- ====== ====== ====== ====== ====== ======
1185: --- IF (x_select_table.COUNT = 0) THEN
1186: --- -- no segments in the key flex.
1187: --- --
1188: --- BIS_VG_UTIL.Add_Error_message
1189: --- ( p_error_msg_name => BIS_VG_KEY_FLEX.NO_SEGMENTS_IN_KEY_FLEX_MSG
1190: --- , p_error_proc_name => G_PKG_NAME||'.update_Key_Flex_Tables'
1191: --- , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1192: --- , p_error_table => x_error_tbl

Line 1218: BIS_VG_UTIL.Add_Error_Message

1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1216: when others then
1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1218: BIS_VG_UTIL.Add_Error_Message
1219: ( p_error_msg_id => SQLCODE
1220: , p_error_description => SQLERRM
1221: , p_error_proc_name => G_PKG_NAME||'.update_Key_Flex_Tables'
1222: , p_error_table => x_error_tbl

Line 1278: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1274: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1275: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1276: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1277: , x_return_status OUT VARCHAR2
1278: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1279: )
1280: IS
1281: --
1282: l_Concat_Seg_Name VARCHAR2(100);

Line 1386: bis_vg_util.print_View_Pointer( x_Column_Pointer

1382: );
1383:
1384: END IF;
1385: bis_debug_pub.Add('COLUMN POINTER');
1386: bis_vg_util.print_View_Pointer( x_Column_Pointer
1387: , x_return_status
1388: , x_error_Tbl
1389: );
1390: bis_debug_pub.Add('SELECT POINTER');

Line 1391: bis_vg_util.print_View_Pointer( x_Select_Pointer

1387: , x_return_status
1388: , x_error_Tbl
1389: );
1390: bis_debug_pub.Add('SELECT POINTER');
1391: bis_vg_util.print_View_Pointer( x_Select_Pointer
1392: , x_return_status
1393: , x_error_Tbl
1394: );
1395: --- bis_debug_pub.debug_on;

Line 1396: bis_vg_util.print_View_Text(x_Column_Table, x_return_status, x_error_Tbl);

1392: , x_return_status
1393: , x_error_Tbl
1394: );
1395: --- bis_debug_pub.debug_on;
1396: bis_vg_util.print_View_Text(x_Column_Table, x_return_status, x_error_Tbl);
1397: bis_vg_util.print_View_Text(x_Select_Table, x_return_status, x_error_Tbl);
1398: --
1399: bis_debug_pub.Add('< add_Key_Flex_Info');
1400: --- bis_debug_pub.debug_off;

Line 1397: bis_vg_util.print_View_Text(x_Select_Table, x_return_status, x_error_Tbl);

1393: , x_error_Tbl
1394: );
1395: --- bis_debug_pub.debug_on;
1396: bis_vg_util.print_View_Text(x_Column_Table, x_return_status, x_error_Tbl);
1397: bis_vg_util.print_View_Text(x_Select_Table, x_return_status, x_error_Tbl);
1398: --
1399: bis_debug_pub.Add('< add_Key_Flex_Info');
1400: --- bis_debug_pub.debug_off;
1401: --

Line 1415: BIS_VG_UTIL.Add_Error_Message

1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1412: RAISE; -- same exception
1413: when others then
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1415: BIS_VG_UTIL.Add_Error_Message
1416: ( p_error_msg_id => SQLCODE
1417: , p_error_description => SQLERRM
1418: , p_error_proc_name => G_PKG_NAME||'.add_Key_Flex_Info'
1419: , p_error_table => x_error_tbl