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 868: BIS_VG_UTIL.Add_Error_Message

864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
866: when others then
867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
868: BIS_VG_UTIL.Add_Error_Message
869: ( p_error_msg_id => SQLCODE
870: , p_error_description => SQLERRM
871: , p_error_proc_name => G_PKG_NAME||'.add_desc_flexfield_segments'
872: , p_error_table => x_error_tbl

Line 928: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

924: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
925: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
926: , x_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
927: , x_return_status OUT VARCHAR2
928: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
929: )
930: IS
931: --
932: i NUMBER;

Line 1030: bis_vg_util.concatenate_Tables( x_Column_Table

1026:
1027: );
1028:
1029: --- Append the latest context's segments to the list
1030: bis_vg_util.concatenate_Tables( x_Column_Table
1031: , l_Column_Table
1032: , x_Column_Table
1033: , x_return_status
1034: , x_error_Tbl

Line 1036: bis_vg_util.concatenate_Tables( x_Select_Table

1032: , x_Column_Table
1033: , x_return_status
1034: , x_error_Tbl
1035: );
1036: bis_vg_util.concatenate_Tables( x_Select_Table
1037: , l_Select_Table
1038: , x_Select_Table
1039: , x_return_status
1040: , x_error_Tbl

Line 1042: bis_vg_util.concatenate_Tables( x_Column_Comment_Table

1038: , x_Select_Table
1039: , x_return_status
1040: , x_error_Tbl
1041: );
1042: bis_vg_util.concatenate_Tables( x_Column_Comment_Table
1043: , l_Column_Comment_Table
1044: , x_Column_Comment_Table
1045: , x_return_status
1046: , x_error_Tbl

Line 1114: bis_vg_util.print_View_Text

1110: END IF;
1111:
1112: END IF; --- Prune or no prune
1113: --- DEBUG
1114: bis_vg_util.print_View_Text
1115: ( x_Column_Table
1116: , x_return_status
1117: , x_error_Tbl
1118: );

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||'.update_Desc_Flex_Tables'
1136: , p_error_table => x_error_tbl

Line 1194: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1190: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1191: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1192: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1193: , x_return_status OUT VARCHAR2
1194: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1195: )
1196: IS
1197: --
1198: l_Prefix VARCHAR2(100);

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

1271: , x_return_status
1272: , x_error_Tbl
1273: );
1274: END IF;
1275: bis_vg_util.print_View_Text(x_Column_Table, x_return_status, x_error_Tbl);
1276: bis_vg_util.print_View_Text(x_Select_Table, x_return_status, x_error_Tbl);
1277: bis_debug_pub.Add('COLUMN POINTER');
1278: bis_vg_util.print_View_Pointer ( x_Column_Pointer
1279: , x_return_status

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

1272: , x_error_Tbl
1273: );
1274: END IF;
1275: bis_vg_util.print_View_Text(x_Column_Table, x_return_status, x_error_Tbl);
1276: bis_vg_util.print_View_Text(x_Select_Table, x_return_status, x_error_Tbl);
1277: bis_debug_pub.Add('COLUMN POINTER');
1278: bis_vg_util.print_View_Pointer ( x_Column_Pointer
1279: , x_return_status
1280: , x_error_Tbl

Line 1278: bis_vg_util.print_View_Pointer ( x_Column_Pointer

1274: END IF;
1275: bis_vg_util.print_View_Text(x_Column_Table, x_return_status, x_error_Tbl);
1276: bis_vg_util.print_View_Text(x_Select_Table, x_return_status, x_error_Tbl);
1277: bis_debug_pub.Add('COLUMN POINTER');
1278: bis_vg_util.print_View_Pointer ( x_Column_Pointer
1279: , x_return_status
1280: , x_error_Tbl
1281: );
1282: bis_debug_pub.Add('SELECT POINTER');

Line 1283: bis_vg_util.print_View_Pointer ( x_Select_Pointer

1279: , x_return_status
1280: , x_error_Tbl
1281: );
1282: bis_debug_pub.Add('SELECT POINTER');
1283: bis_vg_util.print_View_Pointer ( x_Select_Pointer
1284: , x_return_status
1285: , x_error_Tbl
1286: );
1287: bis_debug_pub.Add('< add_Desc_Flex_Info');

Line 1303: BIS_VG_UTIL.Add_Error_Message

1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1300: RAISE; -- same exception
1301: when others then
1302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1303: BIS_VG_UTIL.Add_Error_Message
1304: ( p_error_msg_id => SQLCODE
1305: , p_error_description => SQLERRM
1306: , p_error_proc_name => G_PKG_NAME||'.add_Desc_Flex_Info'
1307: , p_error_table => x_error_tbl