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_DESC_FLEX dependencies on BIS_DEBUG_PUB

Line 215: bis_debug_pub.Add('> parse_DF_Column_Line');

211: l_pos NUMBER;
212: --
213: BEGIN
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

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

230: , l_pos
231: , x_return_status
232: , x_error_Tbl
233: );
234: bis_debug_pub.Add('l_token = ' || l_token);
235:
236: IF(l_pos IS NOT NULL) THEN --- first real token exists
237: -- get next token, if any
238: x_prefix := bis_vg_parser.get_string_token

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

243: , x_return_status
244: , x_error_Tbl
245: );
246:
247: bis_debug_pub.Add('x_prefix = ' || x_prefix);
248:
249: --EDW flag change
250:
251: IF(upper(substr(x_prefix, 1, 4)) = '_EDW')

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

274: , x_return_status
275: , x_error_Tbl
276: );
277:
278: bis_debug_pub.Add('l_token = ' || l_token);
279:
280:
281: IF( UPPER(l_token) = '_EDW' )
282: THEN

Line 284: bis_debug_pub.Add('x_EDW_flag = TRUE');

280:
281: IF( UPPER(l_token) = '_EDW' )
282: THEN
283: x_EDW_flag := TRUE;
284: bis_debug_pub.Add('x_EDW_flag = TRUE');
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

Line 287: bis_debug_pub.Add('x_decode = TRUE');

283: x_EDW_flag := TRUE;
284: bis_debug_pub.Add('x_EDW_flag = TRUE');
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

Line 315: bis_debug_pub.Add('x_EDW_flag = TRUE');

311: x_decode := TRUE;
312: elsif (( upper(l_token) = '_EDW') AND (x_EDW_flag = FALSE))
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

Line 346: bis_debug_pub.Add('< parse_DF_Column_Line');

342: , p_Column_Pointer
343: , x_return_status
344: , x_error_Tbl
345: );
346: bis_debug_pub.Add('< parse_DF_Column_Line');
347: --
348:
349: EXCEPTION
350: when FND_API.G_EXC_ERROR then

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

390: select 1
391: from fnd_application_all_view
392: where application_short_name = p_app;
393: begin
394: BIS_DEBUG_PUB.Add('> check_application_validity');
395: open l_cursor ;
396: fetch l_cursor into l_dummy ;
397: l_return_value := l_cursor%found ;
398: close l_cursor ;

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

395: open l_cursor ;
396: fetch l_cursor into l_dummy ;
397: l_return_value := l_cursor%found ;
398: close l_cursor ;
399: BIS_DEBUG_PUB.Add('< check_application_validity');
400: return(l_return_value);
401:
402: END CHECK_APPLICATION_VALIDITY;
403:

Line 438: bis_debug_pub.Add('> parse_DF_Select_Line');

434: l_whole_tag VARCHAR2(2000);
435: l_tmp_pointer bis_vg_types.View_Character_Pointer_Type;
436: --
437: BEGIN
438: bis_debug_pub.Add('> parse_DF_Select_Line');
439: x_return_status := FND_API.G_RET_STS_SUCCESS;
440: -- get '_DF'
441: l_whole_tag := bis_vg_parser.get_token_increment_pointer
442: ( p_View_Select_Table

Line 539: bis_debug_pub.Add('x_Application_Name = ' || x_Application_Name);

535:
536: END IF;
537: --EDW flag change
538:
539: bis_debug_pub.Add('x_Application_Name = ' || x_Application_Name);
540: x_Desc_Flex_Name := bis_vg_parser.get_token_increment_pointer
541: ( p_View_Select_Table
542: , x_Select_Pointer
543: , ':'''

Line 577: bis_debug_pub.Add('x_Desc_Flex_Name = ' || x_Desc_Flex_Name);

573: RAISE FND_API.G_EXC_ERROR;
574:
575: END IF;
576:
577: bis_debug_pub.Add('x_Desc_Flex_Name = ' || x_Desc_Flex_Name);
578: x_Table_Alias := bis_vg_parser.get_token
579: ( p_View_Select_Table
580: , x_Select_Pointer
581: , ':'''

Line 586: bis_debug_pub.Add('x_Table_Alias = ' || x_Table_Alias);

582: , x_Select_Pointer
583: , x_return_status
584: , x_error_Tbl
585: );
586: bis_debug_pub.Add('x_Table_Alias = ' || x_Table_Alias);
587:
588:
589: IF (x_table_alias IS NULL
590: OR

Line 623: bis_debug_pub.Add('< parse_DF_Select_Line');

619: , x_Select_Pointer
620: , x_return_status
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'

Line 728: bis_debug_pub.Add('> add_desc_flexfield_segments');

724: type CurType is ref cursor;
725: cv CurType;
726: --
727: BEGIN
728: bis_debug_pub.Add('> add_desc_flexfield_segments');
729: x_return_status := FND_API.G_RET_STS_SUCCESS;
730: IF(p_Prefix IS NOT NULL) THEN
731: l_prefix := p_Prefix || '_';
732: END IF;

Line 734: bis_debug_pub.Add('l_prefix = ' || l_prefix);

730: IF(p_Prefix IS NOT NULL) THEN
731: l_prefix := p_Prefix || '_';
732: END IF;
733:
734: bis_debug_pub.Add('l_prefix = ' || l_prefix);
735:
736: x_attr_categ_flag := p_attr_categ_flag;
737: IF(p_Context_Code IS NOT NULL AND p_nContexts_flag = FALSE) THEN
738: -- l_context_code := '^' || p_Context_Code;

Line 775: bis_debug_pub.Add('x_Column_Table(1) = ' || x_Column_Table(1));

771: p_context_code;
772: END IF;
773: ---EDW flag change
774:
775: bis_debug_pub.Add('x_Column_Table(1) = ' || x_Column_Table(1));
776:
777: -- x_Select_Table(1) := ' ' || p_Table_Alias || '.'
778: -- || p_Flexinfo.context_column_name;
779: --EDW flag change

Line 804: bis_debug_pub.Add('x_Column_Table('|| l_count||') = '

800: x_Column_Comment_Table(l_count).column_comments :=p_flexfield.application_id||','||
801: p_flexfield.flexfield_name||','||
802: p_context_code||','||
803: l_segments.APPLICATION_COLUMN_NAME(j);
804: bis_debug_pub.Add('x_Column_Table('|| l_count||') = '
805: || x_Column_Table(l_count));
806: IF (p_decode = TRUE) THEN
807: x_Select_Table(l_count) := ', '
808: || 'DECODE( '

Line 859: bis_debug_pub.Add('x_Select_Table('|| l_count||') = ' || x_Select_Table(l_count));

855: || l_segments.APPLICATION_COLUMN_NAME(j);
856: END IF;
857: --EDW flag change
858: END IF;
859: bis_debug_pub.Add('x_Select_Table('|| l_count||') = ' || x_Select_Table(l_count));
860: --
861: l_count := l_count + 1;
862: END LOOP;
863: END IF;

Line 864: bis_debug_pub.Add('< add_desc_flexfield_segments');

860: --
861: l_count := l_count + 1;
862: END LOOP;
863: END IF;
864: bis_debug_pub.Add('< add_desc_flexfield_segments');
865: --
866: EXCEPTION
867: when FND_API.G_EXC_ERROR then
868: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 959: --- bis_debug_pub.debug_on;

955: l_dummy2 varchar2(2000);
956: l_schema varchar2(400);
957:
958: BEGIN
959: --- bis_debug_pub.debug_on;
960: bis_debug_pub.Add('> update_Desc_Flex_Tables');
961:
962: --get schema name
963: if FND_INSTALLATION.GET_APP_INFO(p_Application_Name,l_dummy1, l_dummy2,l_schema) = false then

Line 960: bis_debug_pub.Add('> update_Desc_Flex_Tables');

956: l_schema varchar2(400);
957:
958: BEGIN
959: --- bis_debug_pub.debug_on;
960: bis_debug_pub.Add('> update_Desc_Flex_Tables');
961:
962: --get schema name
963: if FND_INSTALLATION.GET_APP_INFO(p_Application_Name,l_dummy1, l_dummy2,l_schema) = false then
964: bis_debug_pub.Add('FND_INSTALLATION.GET_APP_INFO returned with error');

Line 964: bis_debug_pub.Add('FND_INSTALLATION.GET_APP_INFO returned with error');

960: bis_debug_pub.Add('> update_Desc_Flex_Tables');
961:
962: --get schema name
963: if FND_INSTALLATION.GET_APP_INFO(p_Application_Name,l_dummy1, l_dummy2,l_schema) = false then
964: bis_debug_pub.Add('FND_INSTALLATION.GET_APP_INFO returned with error');
965: end if;
966:
967: x_return_status := FND_API.G_RET_STS_SUCCESS;
968: FND_DFLEX.GET_FLEXFIELD( appl_short_name => p_Application_Name

Line 973: bis_debug_pub.Add('l_flexfield.FLEXFIELD_NAME = '

969: , flexfield_name => p_Desc_Flex_Name
970: , flexfield => l_flexfield
971: , flexinfo => l_flexinfo
972: );
973: bis_debug_pub.Add('l_flexfield.FLEXFIELD_NAME = '
974: || l_flexfield.FLEXFIELD_NAME);
975: bis_debug_pub.Add('l_flexinfo.TITLE = ' || l_flexinfo.TITLE);
976: IF p_column_table IS NULL
977: --- regular BVG behavior (not pruned)

Line 975: bis_debug_pub.Add('l_flexinfo.TITLE = ' || l_flexinfo.TITLE);

971: , flexinfo => l_flexinfo
972: );
973: bis_debug_pub.Add('l_flexfield.FLEXFIELD_NAME = '
974: || l_flexfield.FLEXFIELD_NAME);
975: bis_debug_pub.Add('l_flexinfo.TITLE = ' || l_flexinfo.TITLE);
976: IF p_column_table IS NULL
977: --- regular BVG behavior (not pruned)
978: THEN
979: GET_CONTEXTS

Line 983: bis_debug_pub.Add('l_contexts.NCONTEXTS = ' || l_contexts.NCONTEXTS);

979: GET_CONTEXTS
980: ( flexfield => l_flexfield
981: , contexts => l_contexts
982: );
983: bis_debug_pub.Add('l_contexts.NCONTEXTS = ' || l_contexts.NCONTEXTS);
984: -- set l_nContexts_flag if only one context or only one enabled context
985: IF(l_contexts.NCONTEXTS = 1) THEN
986: l_nContexts_flag := TRUE;
987: ELSE

Line 1067: bis_debug_pub.ADD ('Processing p_column_table(i).segment_name = '

1063: IF ( p_column_table(i).flex_field_type = 'D'
1064: AND p_column_table(i).id_flex_code = p_desc_flex_name)
1065: THEN
1066: l_count := l_count+1;
1067: bis_debug_pub.ADD ('Processing p_column_table(i).segment_name = '
1068: || p_column_table(i).segment_name);
1069: bis_debug_pub.ADD ('and p_column_table(i).structure_num = '
1070: || p_column_table(i).structure_num);
1071: bis_debug_pub.ADD ('and p_column_table(i).application_column_name = '

Line 1069: bis_debug_pub.ADD ('and p_column_table(i).structure_num = '

1065: THEN
1066: l_count := l_count+1;
1067: bis_debug_pub.ADD ('Processing p_column_table(i).segment_name = '
1068: || p_column_table(i).segment_name);
1069: bis_debug_pub.ADD ('and p_column_table(i).structure_num = '
1070: || p_column_table(i).structure_num);
1071: bis_debug_pub.ADD ('and p_column_table(i).application_column_name = '
1072: || p_column_table(i).application_column_name);
1073: x_column_table(l_count):= p_Prefix

Line 1071: bis_debug_pub.ADD ('and p_column_table(i).application_column_name = '

1067: bis_debug_pub.ADD ('Processing p_column_table(i).segment_name = '
1068: || p_column_table(i).segment_name);
1069: bis_debug_pub.ADD ('and p_column_table(i).structure_num = '
1070: || p_column_table(i).structure_num);
1071: bis_debug_pub.ADD ('and p_column_table(i).application_column_name = '
1072: || p_column_table(i).application_column_name);
1073: x_column_table(l_count):= p_Prefix
1074: || '_' || p_column_table(i).segment_name;
1075:

Line 1106: bis_debug_pub.ADD ('l_Flexinfo.context_column_name = '

1102:
1103: IF l_count > 1
1104: THEN
1105: x_Column_Table(1) := p_prefix || '_context';
1106: bis_debug_pub.ADD ('l_Flexinfo.context_column_name = '
1107: || l_Flexinfo.context_column_name);
1108: IF p_dummy_flag OR l_Flexinfo.context_column_name IS NULL
1109: THEN
1110: x_Select_Table(1) := 'NULL';

Line 1126: bis_debug_pub.Add('< update_Desc_Flex_Tables');

1122: ( x_Column_Table
1123: , x_return_status
1124: , x_error_Tbl
1125: );
1126: bis_debug_pub.Add('< update_Desc_Flex_Tables');
1127: --- bis_debug_pub.debug_off;
1128: --
1129:
1130: EXCEPTION

Line 1127: --- bis_debug_pub.debug_off;

1123: , x_return_status
1124: , x_error_Tbl
1125: );
1126: bis_debug_pub.Add('< update_Desc_Flex_Tables');
1127: --- bis_debug_pub.debug_off;
1128: --
1129:
1130: EXCEPTION
1131: when FND_API.G_EXC_ERROR then

Line 1216: bis_debug_pub.Add('> add_Desc_Flex_Info');

1212: l_decode BOOLEAN;
1213: l_EDW_Flag BOOLEAN; --EDW flag change
1214: l_DUMMY_Flag BOOLEAN; --EDW flag change
1215: BEGIN
1216: bis_debug_pub.Add('> add_Desc_Flex_Info');
1217: x_return_status := FND_API.G_RET_STS_SUCCESS;
1218:
1219: parse_DF_Column_Line( p_View_Column_Table
1220: , p_Column_Pointer

Line 1229: bis_debug_pub.Add('l_Prefix = ' || l_Prefix);

1225: , x_return_status
1226: , x_error_Tbl
1227: );
1228:
1229: bis_debug_pub.Add('l_Prefix = ' || l_Prefix);
1230:
1231: --- This clause catches flexfield tags that do not have the
1232: --- _EDW tags when the generator is called via generate_pruned_view
1233: IF (p_column_table IS NOT NULL AND l_edw_flag = FALSE )

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

1245: , l_DUMMY_Flag --EDW flag change
1246: , x_return_status
1247: , x_error_Tbl
1248: );
1249: bis_debug_pub.Add('l_Application_Name = ' || l_Application_Name);
1250: bis_debug_pub.Add('l_Desc_Flex_Name = ' || l_Desc_Flex_Name);
1251: bis_debug_pub.Add('l_Table_Alias = ' || l_Table_Alias);
1252: bis_debug_pub.Add('l_Prefix = ' || l_Prefix);
1253:

Line 1250: bis_debug_pub.Add('l_Desc_Flex_Name = ' || l_Desc_Flex_Name);

1246: , x_return_status
1247: , x_error_Tbl
1248: );
1249: bis_debug_pub.Add('l_Application_Name = ' || l_Application_Name);
1250: bis_debug_pub.Add('l_Desc_Flex_Name = ' || l_Desc_Flex_Name);
1251: bis_debug_pub.Add('l_Table_Alias = ' || l_Table_Alias);
1252: bis_debug_pub.Add('l_Prefix = ' || l_Prefix);
1253:
1254: IF(

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

1247: , x_error_Tbl
1248: );
1249: bis_debug_pub.Add('l_Application_Name = ' || l_Application_Name);
1250: bis_debug_pub.Add('l_Desc_Flex_Name = ' || l_Desc_Flex_Name);
1251: bis_debug_pub.Add('l_Table_Alias = ' || l_Table_Alias);
1252: bis_debug_pub.Add('l_Prefix = ' || l_Prefix);
1253:
1254: IF(
1255: (p_Mode <> bis_vg_types.remove_tags_mode)

Line 1252: bis_debug_pub.Add('l_Prefix = ' || l_Prefix);

1248: );
1249: bis_debug_pub.Add('l_Application_Name = ' || l_Application_Name);
1250: bis_debug_pub.Add('l_Desc_Flex_Name = ' || l_Desc_Flex_Name);
1251: bis_debug_pub.Add('l_Table_Alias = ' || l_Table_Alias);
1252: bis_debug_pub.Add('l_Prefix = ' || l_Prefix);
1253:
1254: IF(
1255: (p_Mode <> bis_vg_types.remove_tags_mode)
1256: AND

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

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
1288: );

Line 1289: bis_debug_pub.Add('SELECT 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');
1290: bis_vg_util.print_View_Pointer ( x_Select_Pointer
1291: , x_return_status
1292: , x_error_Tbl
1293: );

Line 1294: bis_debug_pub.Add('< add_Desc_Flex_Info');

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');
1295:
1296: --
1297:
1298: