DBA Data[Home] [Help]

APPS.BIS_VG_DESC_FLEX dependencies on BIS_VG_UTIL

Line 205: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

201: , x_EDW_flag OUT BOOLEAN --EDW flag change
202: , x_prefix OUT VARCHAR2
203: , x_decode OUT BOOLEAN
204: , x_return_status OUT VARCHAR2
205: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
206: )
207: IS
208: --
209: l_token VARCHAR2(100);

Line 218: l_string := bis_vg_util.get_row ( p_View_Column_Table

214:
215: bis_debug_pub.Add('> parse_DF_Column_Line');
216: x_return_status := FND_API.G_RET_STS_SUCCESS;
217: -- get row of text from table
218: l_string := bis_vg_util.get_row ( p_View_Column_Table
219: , p_Column_Pointer
220: , x_return_status
221: , x_error_Tbl
222: );

Line 254: bis_vg_util.add_message

250:
251: IF(upper(substr(x_prefix, 1, 4)) = '_EDW')
252: --- '_EDW' in forst position
253: THEN
254: bis_vg_util.add_message
255: ( DFX_COL_TAG_EXP_BAD_FLAG_MSG
256: , FND_MSG_PUB.G_MSG_LVL_ERROR
257: , 'MESSAGE_TAG'
258: , l_string

Line 289: bis_vg_util.add_message

285: ELSIF (UPPER(l_token) = '_BS' ) THEN
286: x_decode := TRUE;
287: bis_debug_pub.Add('x_decode = TRUE');
288: ELSE --- second token is not a valid flag
289: bis_vg_util.add_message
290: ( DFX_COL_TAG_EXP_BAD_FLAG_MSG
291: , FND_MSG_PUB.G_MSG_LVL_ERROR
292: , 'MESSAGE_TAG'
293: , l_string

Line 317: bis_vg_util.add_message

313: then
314: x_EDW_flag := TRUE;
315: bis_debug_pub.Add('x_EDW_flag = TRUE');
316: else --- Third token is not a valid flag
317: bis_vg_util.add_message
318: ( DFX_COL_TAG_EXP_BAD_FLAG_MSG
319: , FND_MSG_PUB.G_MSG_LVL_ERROR
320: , 'MESSAGE_TAG'
321: , l_string

Line 340: x_Column_Pointer := bis_vg_util.increment_pointer_by_row

336: END IF; --- first token exists
337:
338:
339:
340: x_Column_Pointer := bis_vg_util.increment_pointer_by_row
341: ( p_View_Column_Table
342: , p_Column_Pointer
343: , x_return_status
344: , x_error_Tbl

Line 358: BIS_VG_UTIL.Add_Error_Message

354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: when others then
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358: BIS_VG_UTIL.Add_Error_Message
359: ( p_error_msg_id => SQLCODE
360: , p_error_description => SQLERRM
361: , p_error_proc_name => G_PKG_NAME||'.parse_DF_Column_Line'
362: , p_error_table => x_error_tbl

Line 430: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

426: , x_Desc_Flex_Name OUT VARCHAR2
427: , x_Table_Alias OUT VARCHAR2
428: , x_DUMMY_flag OUT BOOLEAN
429: , x_return_status OUT VARCHAR2
430: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
431: )
432: IS
433: --
434: l_whole_tag VARCHAR2(2000);

Line 456: l_tmp_pointer := bis_vg_util.increment_pointer

452: , l_tmp_pointer
453: , x_return_status
454: , x_error_Tbl
455: );
456: l_tmp_pointer := bis_vg_util.increment_pointer
457: ( p_View_Select_Table
458: , l_tmp_pointer
459: , x_return_status
460: , x_error_Tbl

Line 464: IF bis_vg_util.equal_pointers(

460: , x_error_Tbl
461: );
462:
463:
464: IF bis_vg_util.equal_pointers(
465: l_tmp_pointer
466: , x_select_pointer
467: , x_return_status
468: , x_error_Tbl

Line 471: BIS_VG_UTIL.Add_Error_message

467: , x_return_status
468: , x_error_Tbl
469: )
470: THEN
471: BIS_VG_UTIL.Add_Error_message
472: ( p_error_msg_name => bis_vg_desc_flex.DFX_SEL_TAG_EXP_NO_APP_MSG
473: , p_error_proc_name => G_PKG_NAME||'.parse_DF_Select_Line'
474: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
475: , p_token1 => 'tag'

Line 498: bis_vg_util.equal_pointers(

494: );
495:
496: IF (x_Application_Name IS NULL
497: OR
498: bis_vg_util.equal_pointers(
499: l_tmp_pointer
500: , x_select_pointer
501: , x_return_status
502: , x_error_Tbl

Line 506: BIS_VG_UTIL.Add_Error_message

502: , x_error_Tbl
503: )
504:
505: ) THEN
506: BIS_VG_UTIL.Add_Error_message
507: ( p_error_msg_name => bis_vg_desc_flex.DFX_SEL_TAG_EXP_NO_APP_MSG
508: , p_error_proc_name => G_PKG_NAME||'.parse_DF_Select_Line'
509: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
510: , p_token1 => 'tag'

Line 551: bis_vg_util.equal_pointers(

547: );
548:
549: IF (x_desc_flex_name IS NULL
550: OR
551: bis_vg_util.equal_pointers(
552: l_tmp_pointer
553: , x_select_pointer
554: , x_return_status
555: , x_error_Tbl

Line 560: BIS_VG_UTIL.Add_Error_message

556: )
557:
558: ) THEN
559:
560: BIS_VG_UTIL.Add_Error_message
561: ( p_error_msg_name => bis_vg_desc_flex.DFX_SEL_TAG_EXP_NO_NAME_MSG
562: , p_error_proc_name => G_PKG_NAME||'.parse_DF_Select_Line'
563: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
564: , p_token1 => 'tag'

Line 591: bis_vg_util.equal_pointers(

587:
588:
589: IF (x_table_alias IS NULL
590: OR
591: bis_vg_util.equal_pointers(
592: l_tmp_pointer
593: , x_select_pointer
594: , x_return_status
595: , x_error_Tbl

Line 599: BIS_VG_UTIL.Add_Error_message

595: , x_error_Tbl
596: )
597:
598: ) THEN
599: BIS_VG_UTIL.Add_Error_message
600: ( p_error_msg_name => bis_vg_desc_flex.DFX_SEL_TAG_EXP_NO_TABLE_MSG
601: , p_error_proc_name => G_PKG_NAME||'.parse_DF_Select_Line'
602: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
603: , p_token1 => 'tag'

Line 618: x_Select_Pointer := bis_vg_util.increment_pointer( p_View_Select_Table

614:
615: IF check_application_validity(x_Application_Name)
616: THEN
617: -- EVERYTHING IS FINE
618: x_Select_Pointer := bis_vg_util.increment_pointer( p_View_Select_Table
619: , x_Select_Pointer
620: , x_return_status
621: , x_error_Tbl
622: );

Line 625: BIS_VG_UTIL.Add_Error_message

621: , x_error_Tbl
622: );
623: bis_debug_pub.Add('< parse_DF_Select_Line');
624: ELSE
625: BIS_VG_UTIL.Add_Error_message
626: ( p_error_msg_name => bis_vg_desc_flex.DFX_SEL_TAG_EXP_INVALID_APP
627: , p_error_proc_name => G_PKG_NAME||'.parse_DF_Select_Line'
628: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
629: , p_token1 => 'tag'

Line 655: BIS_VG_UTIL.Add_Error_Message

651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: when others then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: BIS_VG_UTIL.Add_Error_Message
656: ( p_error_msg_id => SQLCODE
657: , p_error_description => SQLERRM
658: , p_error_proc_name => G_PKG_NAME||'.parse_DF_Select_Line'
659: , p_error_table => x_error_tbl

Line 713: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

709: , x_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
710: , p_attr_categ_flag IN BOOLEAN
711: , x_attr_categ_flag OUT BOOLEAN
712: , x_return_status OUT VARCHAR2
713: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
714: , p_schema IN VARCHAR2 --schema name
715: )
716: IS
717: --

Line 875: BIS_VG_UTIL.Add_Error_Message

871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
873: when others then
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
875: BIS_VG_UTIL.Add_Error_Message
876: ( p_error_msg_id => SQLCODE
877: , p_error_description => SQLERRM
878: , p_error_proc_name => G_PKG_NAME||'.add_desc_flexfield_segments'
879: , p_error_table => x_error_tbl

Line 935: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

931: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
932: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
933: , x_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
934: , x_return_status OUT VARCHAR2
935: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
936: )
937: IS
938: --
939: i NUMBER;

Line 1037: bis_vg_util.concatenate_Tables( x_Column_Table

1033:
1034: );
1035:
1036: --- Append the latest context's segments to the list
1037: bis_vg_util.concatenate_Tables( x_Column_Table
1038: , l_Column_Table
1039: , x_Column_Table
1040: , x_return_status
1041: , x_error_Tbl

Line 1043: bis_vg_util.concatenate_Tables( x_Select_Table

1039: , x_Column_Table
1040: , x_return_status
1041: , x_error_Tbl
1042: );
1043: bis_vg_util.concatenate_Tables( x_Select_Table
1044: , l_Select_Table
1045: , x_Select_Table
1046: , x_return_status
1047: , x_error_Tbl

Line 1049: bis_vg_util.concatenate_Tables( x_Column_Comment_Table

1045: , x_Select_Table
1046: , x_return_status
1047: , x_error_Tbl
1048: );
1049: bis_vg_util.concatenate_Tables( x_Column_Comment_Table
1050: , l_Column_Comment_Table
1051: , x_Column_Comment_Table
1052: , x_return_status
1053: , x_error_Tbl

Line 1121: bis_vg_util.print_View_Text

1117: END IF;
1118:
1119: END IF; --- Prune or no prune
1120: --- DEBUG
1121: bis_vg_util.print_View_Text
1122: ( x_Column_Table
1123: , x_return_status
1124: , x_error_Tbl
1125: );

Line 1139: BIS_VG_UTIL.Add_Error_Message

1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: when others then
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1139: BIS_VG_UTIL.Add_Error_Message
1140: ( p_error_msg_id => SQLCODE
1141: , p_error_description => SQLERRM
1142: , p_error_proc_name => G_PKG_NAME||'.update_Desc_Flex_Tables'
1143: , p_error_table => x_error_tbl

Line 1201: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1197: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1198: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1199: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1200: , x_return_status OUT VARCHAR2
1201: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1202: )
1203: IS
1204: --
1205: l_Prefix VARCHAR2(100);

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

1278: , x_return_status
1279: , x_error_Tbl
1280: );
1281: END IF;
1282: bis_vg_util.print_View_Text(x_Column_Table, x_return_status, x_error_Tbl);
1283: bis_vg_util.print_View_Text(x_Select_Table, x_return_status, x_error_Tbl);
1284: bis_debug_pub.Add('COLUMN POINTER');
1285: bis_vg_util.print_View_Pointer ( x_Column_Pointer
1286: , x_return_status

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

1279: , x_error_Tbl
1280: );
1281: END IF;
1282: bis_vg_util.print_View_Text(x_Column_Table, x_return_status, x_error_Tbl);
1283: bis_vg_util.print_View_Text(x_Select_Table, x_return_status, x_error_Tbl);
1284: bis_debug_pub.Add('COLUMN POINTER');
1285: bis_vg_util.print_View_Pointer ( x_Column_Pointer
1286: , x_return_status
1287: , x_error_Tbl

Line 1285: bis_vg_util.print_View_Pointer ( x_Column_Pointer

1281: END IF;
1282: bis_vg_util.print_View_Text(x_Column_Table, x_return_status, x_error_Tbl);
1283: bis_vg_util.print_View_Text(x_Select_Table, x_return_status, x_error_Tbl);
1284: bis_debug_pub.Add('COLUMN POINTER');
1285: bis_vg_util.print_View_Pointer ( x_Column_Pointer
1286: , x_return_status
1287: , x_error_Tbl
1288: );
1289: bis_debug_pub.Add('SELECT POINTER');

Line 1290: bis_vg_util.print_View_Pointer ( x_Select_Pointer

1286: , x_return_status
1287: , x_error_Tbl
1288: );
1289: bis_debug_pub.Add('SELECT POINTER');
1290: bis_vg_util.print_View_Pointer ( x_Select_Pointer
1291: , x_return_status
1292: , x_error_Tbl
1293: );
1294: bis_debug_pub.Add('< add_Desc_Flex_Info');

Line 1310: BIS_VG_UTIL.Add_Error_Message

1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1307: RAISE; -- same exception
1308: when others then
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1310: BIS_VG_UTIL.Add_Error_Message
1311: ( p_error_msg_id => SQLCODE
1312: , p_error_description => SQLERRM
1313: , p_error_proc_name => G_PKG_NAME||'.add_Desc_Flex_Info'
1314: , p_error_table => x_error_tbl