DBA Data[Home] [Help]

APPS.BIS_VG_KEY_FLEX dependencies on BIS_DEBUG_PUB

Line 86: bis_debug_pub.Add('> parse_KF_Column_Line');

82: l_pos NUMBER;
83: l_message_token VARCHAR2(2000);
84: --
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

Line 105: bis_debug_pub.Add('l_token = ' || l_token);

101: , l_pos
102: , x_return_status
103: , x_error_Tbl
104: );
105: bis_debug_pub.Add('l_token = ' || l_token);
106:
107: -- get concatenated segment
108: x_Concat_Seg_Name := bis_vg_parser.get_string_token
109: ( l_string

Line 116: bis_debug_pub.Add('x_Concat_Seg_Name = ' || x_Concat_Seg_Name);

112: , l_pos
113: , x_return_status
114: , x_error_Tbl
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

Line 145: bis_debug_pub.Add('l_token = ' || l_token);

141: , l_pos
142: , x_return_status
143: , x_error_Tbl
144: );
145: bis_debug_pub.Add('l_token = ' || l_token);
146:
147: IF( UPPER(l_token) = '_CO' ) THEN
148: x_concat_segment_flag := TRUE;
149: bis_debug_pub.Add('x_concat_segment_flag = TRUE');

Line 149: bis_debug_pub.Add('x_concat_segment_flag = TRUE');

145: bis_debug_pub.Add('l_token = ' || l_token);
146:
147: IF( UPPER(l_token) = '_CO' ) THEN
148: x_concat_segment_flag := TRUE;
149: bis_debug_pub.Add('x_concat_segment_flag = TRUE');
150: ELSIF ( UPPER(l_token) = '_BS') THEN
151: x_decode_on_segments := TRUE;
152: bis_debug_pub.Add('x_decode_on_segements = TRUE');
153: ELSIF ( UPPER(l_token) = '_EDW') THEN --EDW flag change

Line 152: bis_debug_pub.Add('x_decode_on_segements = TRUE');

148: x_concat_segment_flag := TRUE;
149: bis_debug_pub.Add('x_concat_segment_flag = TRUE');
150: ELSIF ( UPPER(l_token) = '_BS') THEN
151: x_decode_on_segments := TRUE;
152: bis_debug_pub.Add('x_decode_on_segements = TRUE');
153: ELSIF ( UPPER(l_token) = '_EDW') THEN --EDW flag change
154: x_EDW_flag:=true;
155: bis_debug_pub.Add('x_EDW_flag = TRUE'); --EDW flag change
156: ELSE

Line 155: bis_debug_pub.Add('x_EDW_flag = TRUE'); --EDW flag change

151: x_decode_on_segments := TRUE;
152: bis_debug_pub.Add('x_decode_on_segements = TRUE');
153: ELSIF ( UPPER(l_token) = '_EDW') THEN --EDW flag change
154: x_EDW_flag:=true;
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

Line 180: bis_debug_pub.Add('x_prefix = ' || x_prefix);

176: END IF;
177:
178: --
179: x_prefix := l_token;
180: bis_debug_pub.Add('x_prefix = ' || x_prefix);
181: IF(l_pos IS NOT NULL) THEN
182: l_token := bis_vg_parser.get_string_token
183: ( l_string
184: , l_pos

Line 190: bis_debug_pub.Add('l_token = ' || l_token);

186: , l_pos
187: , x_return_status
188: , x_error_Tbl
189: );
190: bis_debug_pub.Add('l_token = ' || l_token);
191:
192: IF( UPPER(l_token) = '_CO' ) THEN
193: x_concat_segment_flag := TRUE;
194: bis_debug_pub.Add('x_concat_segment_flag = TRUE');

Line 194: bis_debug_pub.Add('x_concat_segment_flag = TRUE');

190: bis_debug_pub.Add('l_token = ' || l_token);
191:
192: IF( UPPER(l_token) = '_CO' ) THEN
193: x_concat_segment_flag := TRUE;
194: bis_debug_pub.Add('x_concat_segment_flag = TRUE');
195: ELSIF ( UPPER(l_token) = '_BS') THEN
196: x_decode_on_segments := TRUE;
197: bis_debug_pub.Add('x_decode_on_segements = TRUE');
198: ELSIF ( UPPER(l_token) ='_EDW') THEN --EDW flag change

Line 197: bis_debug_pub.Add('x_decode_on_segements = TRUE');

193: x_concat_segment_flag := TRUE;
194: bis_debug_pub.Add('x_concat_segment_flag = TRUE');
195: ELSIF ( UPPER(l_token) = '_BS') THEN
196: x_decode_on_segments := TRUE;
197: bis_debug_pub.Add('x_decode_on_segements = TRUE');
198: ELSIF ( UPPER(l_token) ='_EDW') THEN --EDW flag change
199: x_EDW_flag := TRUE;
200: bis_debug_pub.Add('x_EDW_flag = TRUE'); --EDW flag change
201: ELSE

Line 200: bis_debug_pub.Add('x_EDW_flag = TRUE'); --EDW flag change

196: x_decode_on_segments := TRUE;
197: bis_debug_pub.Add('x_decode_on_segements = TRUE');
198: ELSIF ( UPPER(l_token) ='_EDW') THEN --EDW flag change
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

Line 230: bis_debug_pub.Add('< parse_KF_Column_Line');

226: , p_Column_Pointer
227: , x_return_status
228: , x_error_Tbl
229: );
230: bis_debug_pub.Add('< parse_KF_Column_Line');
231: --
232: EXCEPTION
233: when FND_API.G_EXC_ERROR then
234: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 278: BIS_DEBUG_PUB.Add('> check_application_validity');

274: select 1
275: from fnd_application_all_view
276: where application_short_name = p_app;
277: begin
278: BIS_DEBUG_PUB.Add('> check_application_validity');
279: open l_cursor ;
280: fetch l_cursor into l_dummy ;
281: l_return_value := l_cursor%found ;
282: close l_cursor ;

Line 283: BIS_DEBUG_PUB.Add('< check_application_validity');

279: open l_cursor ;
280: fetch l_cursor into l_dummy ;
281: l_return_value := l_cursor%found ;
282: close l_cursor ;
283: BIS_DEBUG_PUB.Add('< check_application_validity');
284: return(l_return_value);
285:
286: END CHECK_APPLICATION_VALIDITY;
287:

Line 328: bis_debug_pub.Add('> parse_KF_Select_Line');

324: l_message_token VARCHAR2(2000);
325: l_tmp_pointer bis_vg_types.View_Character_Pointer_Type;
326: --
327: BEGIN
328: bis_debug_pub.Add('> parse_KF_Select_Line');
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330: l_message_token := bis_vg_parser.get_expression( p_View_Select_Table
331: , p_Select_Pointer
332: , l_tmp_pointer

Line 501: bis_debug_pub.Add('< parse_KF_Select_Line');

497: , x_Select_Pointer
498: , x_return_status
499: , x_error_Tbl
500: );
501: bis_debug_pub.Add('< parse_KF_Select_Line');
502: --
503:
504: EXCEPTION
505: when MALFORMED_KFX_SEL_TAG_NO_FIELD

Line 602: bis_debug_pub.Add('> add_key_flexfield_segments');

598: l_Concat_Seg_Name VARCHAR2(100) := NULL;
599: l_Segment_Name NUMBER := 0;
600: --
601: BEGIN
602: bis_debug_pub.Add('> add_key_flexfield_segments');
603: x_return_status := FND_API.G_RET_STS_SUCCESS;
604: l_Concat_Segment_Flag := FALSE;
605: --
606: FND_FLEX_KEY_API.GET_SEGMENTS( flexfield => p_Flexfield

Line 617: bis_debug_pub.Add('p_Concat_Seg_Name = ' || p_Concat_Seg_Name);

613: IF( l_nSegments > 0 ) THEN
614: IF(p_prefix IS NOT NULL) THEN
615: l_prefix := p_prefix || '_';
616: END IF;
617: bis_debug_pub.Add('p_Concat_Seg_Name = ' || p_Concat_Seg_Name);
618: --
619:
620: x_Select_Table(1) := ' ';
621: FOR i IN 1 .. l_nSegments LOOP

Line 680: bis_debug_pub.Add('< add_key_flexfield_segments');

676:
677: END LOOP;
678: END IF;
679:
680: bis_debug_pub.Add('< add_key_flexfield_segments');
681:
682:
683: EXCEPTION
684: when FND_API.G_EXC_ERROR then

Line 743: bis_debug_pub.Add('> add_kfx_segments_concat');

739: l_Concat_Seg_Name VARCHAR2(100) := NULL;
740: l_Segment_Name NUMBER := 0;
741: --
742: BEGIN
743: bis_debug_pub.Add('> add_kfx_segments_concat');
744: x_return_status := FND_API.G_RET_STS_SUCCESS;
745: FND_FLEX_KEY_API.GET_SEGMENTS( flexfield => p_Flexfield
746: , structure => p_Structure
747: , enabled_only => TRUE

Line 782: bis_debug_pub.Add('< add_kfx_segments_concat');

778: || l_Segment.column_name;
779: END IF;
780: END LOOP;
781: END IF;
782: bis_debug_pub.Add('< add_kfx_segments_concat');
783: --
784:
785:
786: EXCEPTION

Line 890: bis_debug_pub.debug_on;

886: --
887:
888: BEGIN
889: --
890: bis_debug_pub.debug_on;
891: bis_debug_pub.Add('> update_Key_Flex_Tables');
892: x_return_status := FND_API.G_RET_STS_SUCCESS;
893: bis_debug_pub.Add('p_Table_Alias = ' || p_Table_Alias);
894: IF(p_prefix IS NOT NULL) THEN

Line 891: bis_debug_pub.Add('> update_Key_Flex_Tables');

887:
888: BEGIN
889: --
890: bis_debug_pub.debug_on;
891: bis_debug_pub.Add('> update_Key_Flex_Tables');
892: x_return_status := FND_API.G_RET_STS_SUCCESS;
893: bis_debug_pub.Add('p_Table_Alias = ' || p_Table_Alias);
894: IF(p_prefix IS NOT NULL) THEN
895: l_prefix := p_prefix || '_';

Line 893: bis_debug_pub.Add('p_Table_Alias = ' || p_Table_Alias);

889: --
890: bis_debug_pub.debug_on;
891: bis_debug_pub.Add('> update_Key_Flex_Tables');
892: x_return_status := FND_API.G_RET_STS_SUCCESS;
893: bis_debug_pub.Add('p_Table_Alias = ' || p_Table_Alias);
894: IF(p_prefix IS NOT NULL) THEN
895: l_prefix := p_prefix || '_';
896: END IF;
897:

Line 921: bis_debug_pub.add('flag error');

917: );
918: END IF; --- dummy flag
919:
920: ELSE --- plsql expression with no concat segment clause: Should not occur
921: bis_debug_pub.add('flag error');
922: END IF; --- concat segment flag
923:
924: --- not a plsql expression - must be a flexfield
925: ELSIF (p_column_table IS NULL)

Line 928: bis_debug_pub.Add('regular BVG behavior (not pruned)');

924: --- not a plsql expression - must be a flexfield
925: ELSIF (p_column_table IS NULL)
926: --- regular BVG behavior (not pruned)
927: THEN
928: bis_debug_pub.Add('regular BVG behavior (not pruned)');
929: FND_FLEX_KEY_API.SET_SESSION_MODE(session_mode => 'customer_data');
930: l_Flexfield := FND_FLEX_KEY_API.FIND_FLEXFIELD
931: ( appl_short_name => p_Application_Name
932: , flex_code => p_Key_Flex_Code

Line 943: bis_debug_pub.add('No Structures');

939:
940: ---EDW flag change
941: IF(l_nStructures = 0) THEN
942: --- If the flexfield is not defined then we do not want to do anything.
943: bis_debug_pub.add('No Structures');
944: l_dummy_flag := TRUE;
945: ELSE
946: l_dummy_flag := p_dummy_flag;
947: --- bis_debug_pub.Add('< update_Key_Flex_Tables');

Line 947: --- bis_debug_pub.Add('< update_Key_Flex_Tables');

943: bis_debug_pub.add('No Structures');
944: l_dummy_flag := TRUE;
945: ELSE
946: l_dummy_flag := p_dummy_flag;
947: --- bis_debug_pub.Add('< update_Key_Flex_Tables');
948: --- return;
949: END IF;
950:
951: IF (p_EDW_Flag ) THEN

Line 979: bis_debug_pub.Add('l_nStructures = ' || l_nstructures);

975: || '.'
976: || l_Flexfield.structure_column;
977: END IF;
978:
979: bis_debug_pub.Add('l_nStructures = ' || l_nstructures);
980: --
981: FOR i IN 1 .. l_nStructures LOOP
982: -- nest a DECODE statement if we have more then 127 structures in the outer DECODE
983: -- as we nest DECODE statements inside DECODE statements, the max number of

Line 994: bis_debug_pub.ADD('before calling fnd');

990: l_decode_Counter := l_decode_Counter +1;
991: l_decode_max := l_decode_max - 1;
992: END IF;
993:
994: bis_debug_pub.ADD('before calling fnd');
995: l_Structure := FND_FLEX_KEY_API.FIND_STRUCTURE( flexfield => l_Flexfield
996: , structure_number => l_Structure_List(i)
997: );
998: bis_debug_pub.ADD('after calling fnd');

Line 998: bis_debug_pub.ADD('after calling fnd');

994: bis_debug_pub.ADD('before calling fnd');
995: l_Structure := FND_FLEX_KEY_API.FIND_STRUCTURE( flexfield => l_Flexfield
996: , structure_number => l_Structure_List(i)
997: );
998: bis_debug_pub.ADD('after calling fnd');
999: bis_debug_pub.Add('l_Structure.structure_name = ' ||l_Structure.structure_name);
1000: bis_debug_pub.Add('l_Structure.structure_number = ' ||l_Structure.structure_number);
1001: bis_debug_pub.Add('l_Structure.segment_separator = ' ||l_Structure.segment_separator);
1002: --

Line 999: bis_debug_pub.Add('l_Structure.structure_name = ' ||l_Structure.structure_name);

995: l_Structure := FND_FLEX_KEY_API.FIND_STRUCTURE( flexfield => l_Flexfield
996: , structure_number => l_Structure_List(i)
997: );
998: bis_debug_pub.ADD('after calling fnd');
999: bis_debug_pub.Add('l_Structure.structure_name = ' ||l_Structure.structure_name);
1000: bis_debug_pub.Add('l_Structure.structure_number = ' ||l_Structure.structure_number);
1001: bis_debug_pub.Add('l_Structure.segment_separator = ' ||l_Structure.segment_separator);
1002: --
1003:

Line 1000: bis_debug_pub.Add('l_Structure.structure_number = ' ||l_Structure.structure_number);

996: , structure_number => l_Structure_List(i)
997: );
998: bis_debug_pub.ADD('after calling fnd');
999: bis_debug_pub.Add('l_Structure.structure_name = ' ||l_Structure.structure_name);
1000: bis_debug_pub.Add('l_Structure.structure_number = ' ||l_Structure.structure_number);
1001: bis_debug_pub.Add('l_Structure.segment_separator = ' ||l_Structure.segment_separator);
1002: --
1003:
1004: add_kfx_segments_concat(l_nStructures

Line 1001: bis_debug_pub.Add('l_Structure.segment_separator = ' ||l_Structure.segment_separator);

997: );
998: bis_debug_pub.ADD('after calling fnd');
999: bis_debug_pub.Add('l_Structure.structure_name = ' ||l_Structure.structure_name);
1000: bis_debug_pub.Add('l_Structure.structure_number = ' ||l_Structure.structure_number);
1001: bis_debug_pub.Add('l_Structure.segment_separator = ' ||l_Structure.segment_separator);
1002: --
1003:
1004: add_kfx_segments_concat(l_nStructures
1005: , l_Flexfield

Line 1031: bis_debug_pub.ADD('after the loop');

1027:
1028:
1029: END LOOP;
1030: --
1031: bis_debug_pub.ADD('after the loop');
1032: IF(l_nStructures > 1) THEN
1033: IF(x_Select_Table.COUNT = 1) THEN
1034: -- seems like none of the structures had any segments defined
1035: -- hence add a NULL pair to make decode compile

Line 1054: bis_debug_pub.Add('p_Concat_Segment_Flag = TRUE');

1050: --
1051: END IF; --- dummy flag
1052:
1053: IF (p_concat_segment_flag) THEN
1054: bis_debug_pub.Add('p_Concat_Segment_Flag = TRUE');
1055: --- we need to put in the columns as well
1056: NULL;
1057: ELSE
1058: bis_debug_pub.Add('p_Concat_Segment_Flag = FALSE');

Line 1058: bis_debug_pub.Add('p_Concat_Segment_Flag = FALSE');

1054: bis_debug_pub.Add('p_Concat_Segment_Flag = TRUE');
1055: --- we need to put in the columns as well
1056: NULL;
1057: ELSE
1058: bis_debug_pub.Add('p_Concat_Segment_Flag = FALSE');
1059: --
1060: --- we need to put in the columns as well
1061:
1062: bis_debug_pub.ADD('adding columns to the table');

Line 1062: bis_debug_pub.ADD('adding columns to the table');

1058: bis_debug_pub.Add('p_Concat_Segment_Flag = FALSE');
1059: --
1060: --- we need to put in the columns as well
1061:
1062: bis_debug_pub.ADD('adding columns to the table');
1063:
1064: FOR i IN 1 .. l_nStructures LOOP
1065: bis_debug_pub.ADD('before calling fnd');
1066: l_Structure := FND_FLEX_KEY_API.FIND_STRUCTURE( flexfield => l_Flexfield

Line 1065: bis_debug_pub.ADD('before calling fnd');

1061:
1062: bis_debug_pub.ADD('adding columns to the table');
1063:
1064: FOR i IN 1 .. l_nStructures LOOP
1065: bis_debug_pub.ADD('before calling fnd');
1066: l_Structure := FND_FLEX_KEY_API.FIND_STRUCTURE( flexfield => l_Flexfield
1067: , structure_number => l_Structure_List(i)
1068: );
1069: bis_debug_pub.ADD('after calling fnd');

Line 1069: bis_debug_pub.ADD('after calling fnd');

1065: bis_debug_pub.ADD('before calling fnd');
1066: l_Structure := FND_FLEX_KEY_API.FIND_STRUCTURE( flexfield => l_Flexfield
1067: , structure_number => l_Structure_List(i)
1068: );
1069: bis_debug_pub.ADD('after calling fnd');
1070: bis_debug_pub.Add('l_Structure.structure_name = '||l_Structure.structure_name);
1071: bis_debug_pub.Add('l_Structure.structure_number = '||l_Structure.structure_number);
1072: bis_debug_pub.Add('l_Structure.segment_separator = '||l_Structure.segment_separator);
1073: --

Line 1070: bis_debug_pub.Add('l_Structure.structure_name = '||l_Structure.structure_name);

1066: l_Structure := FND_FLEX_KEY_API.FIND_STRUCTURE( flexfield => l_Flexfield
1067: , structure_number => l_Structure_List(i)
1068: );
1069: bis_debug_pub.ADD('after calling fnd');
1070: bis_debug_pub.Add('l_Structure.structure_name = '||l_Structure.structure_name);
1071: bis_debug_pub.Add('l_Structure.structure_number = '||l_Structure.structure_number);
1072: bis_debug_pub.Add('l_Structure.segment_separator = '||l_Structure.segment_separator);
1073: --
1074: IF(l_nStructures > 1 OR p_edw_flag) THEN

Line 1071: bis_debug_pub.Add('l_Structure.structure_number = '||l_Structure.structure_number);

1067: , structure_number => l_Structure_List(i)
1068: );
1069: bis_debug_pub.ADD('after calling fnd');
1070: bis_debug_pub.Add('l_Structure.structure_name = '||l_Structure.structure_name);
1071: bis_debug_pub.Add('l_Structure.structure_number = '||l_Structure.structure_number);
1072: bis_debug_pub.Add('l_Structure.segment_separator = '||l_Structure.segment_separator);
1073: --
1074: IF(l_nStructures > 1 OR p_edw_flag) THEN
1075: -- we should use '^' rather than '_' (bug 2259939)

Line 1072: bis_debug_pub.Add('l_Structure.segment_separator = '||l_Structure.segment_separator);

1068: );
1069: bis_debug_pub.ADD('after calling fnd');
1070: bis_debug_pub.Add('l_Structure.structure_name = '||l_Structure.structure_name);
1071: bis_debug_pub.Add('l_Structure.structure_number = '||l_Structure.structure_number);
1072: bis_debug_pub.Add('l_Structure.segment_separator = '||l_Structure.segment_separator);
1073: --
1074: IF(l_nStructures > 1 OR p_edw_flag) THEN
1075: -- we should use '^' rather than '_' (bug 2259939)
1076: l_Suffix := '^' || TO_CHAR(l_Structure.structure_number);

Line 1120: bis_debug_pub.Add('The pruned case');

1116: --
1117: END IF; --- Concat_segment_flag false
1118:
1119: ELSE --- The pruned case - no need for concatenated segments column.
1120: bis_debug_pub.Add('The pruned case');
1121: FND_FLEX_KEY_API.SET_SESSION_MODE(session_mode => 'customer_data');
1122: l_Flexfield := FND_FLEX_KEY_API.FIND_FLEXFIELD
1123: (appl_short_name => p_Application_Name
1124: , flex_code => p_Key_Flex_Code

Line 1179: bis_debug_pub.Add('< update_Key_Flex_Tables');

1175: , x_error_Tbl
1176: );
1177:
1178: --
1179: bis_debug_pub.Add('< update_Key_Flex_Tables');
1180: bis_debug_pub.debug_off;
1181: --- ====== ====== ====== ====== ====== ======
1182: --- OBSOLETE FUNCTIONALITY: we no longer care if there are no segments in
1183: --- the flexfield - leave a blank in the view

Line 1180: bis_debug_pub.debug_off;

1176: );
1177:
1178: --
1179: bis_debug_pub.Add('< update_Key_Flex_Tables');
1180: bis_debug_pub.debug_off;
1181: --- ====== ====== ====== ====== ====== ======
1182: --- OBSOLETE FUNCTIONALITY: we no longer care if there are no segments in
1183: --- the flexfield - leave a blank in the view
1184: --- ====== ====== ====== ====== ====== ======

Line 1298: bis_debug_pub.Add('> add_Key_Flex_Info');

1294: l_Structure_Column VARCHAR2(100);
1295: --
1296: BEGIN
1297: --
1298: bis_debug_pub.Add('> add_Key_Flex_Info');
1299: x_return_status := FND_API.G_RET_STS_SUCCESS;
1300: parse_KF_Column_Line( p_View_Column_Table
1301: , p_Column_Pointer
1302: , x_Column_Pointer

Line 1313: --- bis_debug_pub.Add('l_Concat_Seg_Name = ' || l_Concat_Seg_Name);

1309: , x_error_Tbl
1310: );
1311:
1312: --- --- DEBUG ---
1313: --- bis_debug_pub.Add('l_Concat_Seg_Name = ' || l_Concat_Seg_Name);
1314: ---
1315: ---
1316: --- IF(l_Concat_Segment_Flag = TRUE) THEN
1317: --- bis_debug_pub.Add('l_Concat_Segment_Flag = TRUE');

Line 1317: --- bis_debug_pub.Add('l_Concat_Segment_Flag = TRUE');

1313: --- bis_debug_pub.Add('l_Concat_Seg_Name = ' || l_Concat_Seg_Name);
1314: ---
1315: ---
1316: --- IF(l_Concat_Segment_Flag = TRUE) THEN
1317: --- bis_debug_pub.Add('l_Concat_Segment_Flag = TRUE');
1318: --- ELSE
1319: --- bis_debug_pub.Add('l_Concat_Segment_Flag = FALSE');
1320: --- END IF;
1321: --- --- -- -

Line 1319: --- bis_debug_pub.Add('l_Concat_Segment_Flag = FALSE');

1315: ---
1316: --- IF(l_Concat_Segment_Flag = TRUE) THEN
1317: --- bis_debug_pub.Add('l_Concat_Segment_Flag = TRUE');
1318: --- ELSE
1319: --- bis_debug_pub.Add('l_Concat_Segment_Flag = FALSE');
1320: --- END IF;
1321: --- --- -- -
1322:
1323: --- This clause catches flexfield tags that do not have the

Line 1342: bis_debug_pub.Add('l_PLSQL_Expression = ' || l_PLSQL_Expression);

1338: , l_DUMMY_Flag ---EDW flag change
1339: , x_return_status
1340: , x_error_Tbl
1341: );
1342: bis_debug_pub.Add('l_PLSQL_Expression = ' || l_PLSQL_Expression);
1343: bis_debug_pub.Add('l_Application_Name = ' || l_Application_Name);
1344: bis_debug_pub.Add('l_Key_Flex_Code = ' || l_Key_Flex_Code);
1345: bis_debug_pub.Add('l_Table_Alias = ' || l_Table_Alias);
1346: bis_debug_pub.Add('l_Structure_Column = ' || l_Structure_Column);

Line 1343: bis_debug_pub.Add('l_Application_Name = ' || l_Application_Name);

1339: , x_return_status
1340: , x_error_Tbl
1341: );
1342: bis_debug_pub.Add('l_PLSQL_Expression = ' || l_PLSQL_Expression);
1343: bis_debug_pub.Add('l_Application_Name = ' || l_Application_Name);
1344: bis_debug_pub.Add('l_Key_Flex_Code = ' || l_Key_Flex_Code);
1345: bis_debug_pub.Add('l_Table_Alias = ' || l_Table_Alias);
1346: bis_debug_pub.Add('l_Structure_Column = ' || l_Structure_Column);
1347:

Line 1344: bis_debug_pub.Add('l_Key_Flex_Code = ' || l_Key_Flex_Code);

1340: , x_error_Tbl
1341: );
1342: bis_debug_pub.Add('l_PLSQL_Expression = ' || l_PLSQL_Expression);
1343: bis_debug_pub.Add('l_Application_Name = ' || l_Application_Name);
1344: bis_debug_pub.Add('l_Key_Flex_Code = ' || l_Key_Flex_Code);
1345: bis_debug_pub.Add('l_Table_Alias = ' || l_Table_Alias);
1346: bis_debug_pub.Add('l_Structure_Column = ' || l_Structure_Column);
1347:
1348: IF(

Line 1345: bis_debug_pub.Add('l_Table_Alias = ' || l_Table_Alias);

1341: );
1342: bis_debug_pub.Add('l_PLSQL_Expression = ' || l_PLSQL_Expression);
1343: bis_debug_pub.Add('l_Application_Name = ' || l_Application_Name);
1344: bis_debug_pub.Add('l_Key_Flex_Code = ' || l_Key_Flex_Code);
1345: bis_debug_pub.Add('l_Table_Alias = ' || l_Table_Alias);
1346: bis_debug_pub.Add('l_Structure_Column = ' || l_Structure_Column);
1347:
1348: IF(
1349: (p_Mode <> bis_vg_types.remove_tags_mode)

Line 1346: bis_debug_pub.Add('l_Structure_Column = ' || l_Structure_Column);

1342: bis_debug_pub.Add('l_PLSQL_Expression = ' || l_PLSQL_Expression);
1343: bis_debug_pub.Add('l_Application_Name = ' || l_Application_Name);
1344: bis_debug_pub.Add('l_Key_Flex_Code = ' || l_Key_Flex_Code);
1345: bis_debug_pub.Add('l_Table_Alias = ' || l_Table_Alias);
1346: bis_debug_pub.Add('l_Structure_Column = ' || l_Structure_Column);
1347:
1348: IF(
1349: (p_Mode <> bis_vg_types.remove_tags_mode)
1350: AND

Line 1385: bis_debug_pub.Add('COLUMN POINTER');

1381: , x_error_Tbl
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: );

Line 1390: bis_debug_pub.Add('SELECT 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');
1391: bis_vg_util.print_View_Pointer( x_Select_Pointer
1392: , x_return_status
1393: , x_error_Tbl
1394: );

Line 1395: --- bis_debug_pub.debug_on;

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;
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');

Line 1399: bis_debug_pub.Add('< add_Key_Flex_Info');

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: --
1402:
1403:

Line 1400: --- bis_debug_pub.debug_off;

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: --
1402:
1403:
1404: EXCEPTION