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

Line 54: BIS_DEBUG_PUB.Add('> put_column_name');

50: l_str VARCHAR2(1000);
51: l_col VARCHAR2(1000);
52: l_num NUMBER;
53: BEGIN
54: BIS_DEBUG_PUB.Add('> put_column_name');
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56: --
57: -- skip the _LA part
58: l_str := bis_vg_parser.Skip_Tag( p_View_Column_Table

Line 96: bis_debug_pub.ADD('column pos = '||l_num);

92: ELSE
93: x_column_pointer.col_num := l_num;
94: END IF;
95: --
96: bis_debug_pub.ADD('column pos = '||l_num);
97: --
98: IF (l_str IS NULL) THEN
99: BIS_VG_UTIL.Add_Error_message
100: ( p_error_msg_name => bis_vg_lookup.lat_col_tag_exp_msg

Line 117: bis_debug_pub.ADD('column name = '||l_str);

113: --
114: -- save to output file
115: x_column_table(x_column_table.COUNT + 1) := l_str;
116: --
117: bis_debug_pub.ADD('column name = '||l_str);
118: -- bis_vg_util.print_view_text(x_column_table, x_return_status, x_error_Tbl );
119: bis_vg_util.print_view_pointer ( x_column_pointer
120: , x_return_status
121: , x_error_Tbl

Line 128: BIS_DEBUG_PUB.Add('< put_column_name');

124: IF(p_Mode = bis_vg_types.remove_tags_mode) THEN
125: x_column_table.DELETE;
126: x_column_table(1) := l_str;
127: END IF;
128: BIS_DEBUG_PUB.Add('< put_column_name');
129: --
130: EXCEPTION
131: when FND_API.G_EXC_ERROR then
132: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 178: BIS_DEBUG_PUB.Add('> get_select_statement');

174: RETURN VARCHAR2
175: IS
176: l_select VARCHAR2(1000);
177: BEGIN
178: BIS_DEBUG_PUB.Add('> get_select_statement');
179: x_return_status := FND_API.G_RET_STS_SUCCESS;
180: --
181: l_select := 'select lookup_code, '||p_lookup_column;
182: l_select := l_select || ' from '||p_lookup_table;

Line 185: BIS_DEBUG_PUB.Add(' l_select = '||l_select);

181: l_select := 'select lookup_code, '||p_lookup_column;
182: l_select := l_select || ' from '||p_lookup_table;
183: l_select := l_select || ' where lookup_type = '''||p_lookup_type||'''';
184: --
185: BIS_DEBUG_PUB.Add(' l_select = '||l_select);
186: --
187: BIS_DEBUG_PUB.Add('< get_select_statement');
188: RETURN l_select;
189: --

Line 187: BIS_DEBUG_PUB.Add('< get_select_statement');

183: l_select := l_select || ' where lookup_type = '''||p_lookup_type||'''';
184: --
185: BIS_DEBUG_PUB.Add(' l_select = '||l_select);
186: --
187: BIS_DEBUG_PUB.Add('< get_select_statement');
188: RETURN l_select;
189: --
190:
191: EXCEPTION

Line 250: BIS_DEBUG_PUB.Add('> write_decode_statement');

246: l_decode_nest_level NUMBER := 0;
247: l_lookup_type_valid BOOLEAN := FALSE;
248: l_num_rows NUMBER;
249: BEGIN
250: BIS_DEBUG_PUB.Add('> write_decode_statement');
251: x_return_status := FND_API.G_RET_STS_SUCCESS;
252: -- open the cursor
253: l_cursor_id := dbms_sql.open_cursor;
254: --

Line 258: BIS_DEBUG_PUB.Add('after parsing');

254: --
255: -- parse the statement
256: dbms_sql.parse(l_cursor_id, p_select, dbms_sql.V7);
257: --
258: BIS_DEBUG_PUB.Add('after parsing');
259: --
260: -- define output variables
261: dbms_sql.define_column(l_cursor_id, 1, l_lookup_code, 250);
262: dbms_sql.define_column(l_cursor_id, 2, l_meaning, 250);

Line 277: bis_debug_pub.add('l_DECODE_flag is TRUE');

273: END IF;
274: --
275: WHILE (l_num_rows <> 0) LOOP
276: IF(l_DECODE_flag = TRUE) THEN
277: bis_debug_pub.add('l_DECODE_flag is TRUE');
278: ELSE
279: bis_debug_pub.add('l_DECODE_flag is FALSE');
280: END IF;
281: l_lookup_type_valid := TRUE;

Line 279: bis_debug_pub.add('l_DECODE_flag is FALSE');

275: WHILE (l_num_rows <> 0) LOOP
276: IF(l_DECODE_flag = TRUE) THEN
277: bis_debug_pub.add('l_DECODE_flag is TRUE');
278: ELSE
279: bis_debug_pub.add('l_DECODE_flag is FALSE');
280: END IF;
281: l_lookup_type_valid := TRUE;
282: IF(l_DECODE_flag = TRUE OR l_stmt_count = 100 ) THEN
283: -- first pass, need to start the decode

Line 307: bis_debug_pub.add('l_lookup_code = ' || l_lookup_code);

303: );
304: l_DECODE_flag := FALSE;
305: END IF;
306: --
307: bis_debug_pub.add('l_lookup_code = ' || l_lookup_code);
308: bis_debug_pub.add('l_meaning = ' || l_meaning);
309: dbms_sql.column_value(l_cursor_id, 1, l_lookup_code);
310: dbms_sql.column_value(l_cursor_id, 2, l_meaning);
311: -- make sure that the ' in l_lookup_code are replace by ''

Line 308: bis_debug_pub.add('l_meaning = ' || l_meaning);

304: l_DECODE_flag := FALSE;
305: END IF;
306: --
307: bis_debug_pub.add('l_lookup_code = ' || l_lookup_code);
308: bis_debug_pub.add('l_meaning = ' || l_meaning);
309: dbms_sql.column_value(l_cursor_id, 1, l_lookup_code);
310: dbms_sql.column_value(l_cursor_id, 2, l_meaning);
311: -- make sure that the ' in l_lookup_code are replace by ''
312: l_lookup_code := REPLACE(l_lookup_code,'''','''''');

Line 339: BIS_DEBUG_PUB.Add('< write_decode_statement');

335: END LOOP;
336: END IF;
337: dbms_sql.close_cursor(l_cursor_id);
338: --
339: BIS_DEBUG_PUB.Add('< write_decode_statement');
340: --
341: --
342: EXCEPTION
343: when FND_API.G_EXC_ERROR then

Line 398: BIS_DEBUG_PUB.Add('> put_decode_statement');

394: )
395: IS
396: l_select VARCHAR2(1000);
397: BEGIN
398: BIS_DEBUG_PUB.Add('> put_decode_statement');
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);
401: BIS_DEBUG_PUB.Add('p_lookup_table = ' || p_lookup_table);
402: BIS_DEBUG_PUB.Add('p_lookup_type = ' || p_lookup_type);

Line 400: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);

396: l_select VARCHAR2(1000);
397: BEGIN
398: BIS_DEBUG_PUB.Add('> put_decode_statement');
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);
401: BIS_DEBUG_PUB.Add('p_lookup_table = ' || p_lookup_table);
402: BIS_DEBUG_PUB.Add('p_lookup_type = ' || p_lookup_type);
403: BIS_DEBUG_PUB.Add('p_expr = ' || p_expr);
404: -- select statement

Line 401: BIS_DEBUG_PUB.Add('p_lookup_table = ' || p_lookup_table);

397: BEGIN
398: BIS_DEBUG_PUB.Add('> put_decode_statement');
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);
401: BIS_DEBUG_PUB.Add('p_lookup_table = ' || p_lookup_table);
402: BIS_DEBUG_PUB.Add('p_lookup_type = ' || p_lookup_type);
403: BIS_DEBUG_PUB.Add('p_expr = ' || p_expr);
404: -- select statement
405: l_select := get_select_statement( p_lookup_table

Line 402: BIS_DEBUG_PUB.Add('p_lookup_type = ' || p_lookup_type);

398: BIS_DEBUG_PUB.Add('> put_decode_statement');
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);
401: BIS_DEBUG_PUB.Add('p_lookup_table = ' || p_lookup_table);
402: BIS_DEBUG_PUB.Add('p_lookup_type = ' || p_lookup_type);
403: BIS_DEBUG_PUB.Add('p_expr = ' || p_expr);
404: -- select statement
405: l_select := get_select_statement( p_lookup_table
406: , p_lookup_type

Line 403: BIS_DEBUG_PUB.Add('p_expr = ' || p_expr);

399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);
401: BIS_DEBUG_PUB.Add('p_lookup_table = ' || p_lookup_table);
402: BIS_DEBUG_PUB.Add('p_lookup_type = ' || p_lookup_type);
403: BIS_DEBUG_PUB.Add('p_expr = ' || p_expr);
404: -- select statement
405: l_select := get_select_statement( p_lookup_table
406: , p_lookup_type
407: , p_lookup_column

Line 413: BIS_DEBUG_PUB.Add(' l_select = '||l_select);

409: , x_error_Tbl
410: );
411: --
412: --
413: BIS_DEBUG_PUB.Add(' l_select = '||l_select);
414: --
415: -- write the decode statement
416: write_decode_statement ( p_expr
417: , l_select

Line 444: BIS_DEBUG_PUB.Add('< put_decode_statement');

440: RAISE FND_API.G_EXC_ERROR;
441: END IF;
442:
443: --
444: BIS_DEBUG_PUB.Add('< put_decode_statement');
445: --
446:
447: EXCEPTION
448: when FND_API.G_EXC_ERROR then

Line 507: BIS_DEBUG_PUB.Add('> put_decode_statement_lang');

503: l_meaning VARCHAR2(250);
504: l_dummy INTEGER;
505: BEGIN
506: --
507: BIS_DEBUG_PUB.Add('> put_decode_statement_lang');
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509: --
510: BIS_DEBUG_PUB.Add('> put_decode_statement');
511: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);

Line 510: BIS_DEBUG_PUB.Add('> put_decode_statement');

506: --
507: BIS_DEBUG_PUB.Add('> put_decode_statement_lang');
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509: --
510: BIS_DEBUG_PUB.Add('> put_decode_statement');
511: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);
512: BIS_DEBUG_PUB.Add('p_lookup_table = ' || p_lookup_table);
513: BIS_DEBUG_PUB.Add('p_lookup_type = ' || p_lookup_type);
514: BIS_DEBUG_PUB.Add('p_expr = ' || p_expr);

Line 511: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);

507: BIS_DEBUG_PUB.Add('> put_decode_statement_lang');
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509: --
510: BIS_DEBUG_PUB.Add('> put_decode_statement');
511: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);
512: BIS_DEBUG_PUB.Add('p_lookup_table = ' || p_lookup_table);
513: BIS_DEBUG_PUB.Add('p_lookup_type = ' || p_lookup_type);
514: BIS_DEBUG_PUB.Add('p_expr = ' || p_expr);
515: BIS_DEBUG_PUB.Add('p_language = ' || p_language);

Line 512: BIS_DEBUG_PUB.Add('p_lookup_table = ' || p_lookup_table);

508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509: --
510: BIS_DEBUG_PUB.Add('> put_decode_statement');
511: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);
512: BIS_DEBUG_PUB.Add('p_lookup_table = ' || p_lookup_table);
513: BIS_DEBUG_PUB.Add('p_lookup_type = ' || p_lookup_type);
514: BIS_DEBUG_PUB.Add('p_expr = ' || p_expr);
515: BIS_DEBUG_PUB.Add('p_language = ' || p_language);
516: -- select statement

Line 513: BIS_DEBUG_PUB.Add('p_lookup_type = ' || p_lookup_type);

509: --
510: BIS_DEBUG_PUB.Add('> put_decode_statement');
511: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);
512: BIS_DEBUG_PUB.Add('p_lookup_table = ' || p_lookup_table);
513: BIS_DEBUG_PUB.Add('p_lookup_type = ' || p_lookup_type);
514: BIS_DEBUG_PUB.Add('p_expr = ' || p_expr);
515: BIS_DEBUG_PUB.Add('p_language = ' || p_language);
516: -- select statement
517: l_select := get_select_statement( p_lookup_table

Line 514: BIS_DEBUG_PUB.Add('p_expr = ' || p_expr);

510: BIS_DEBUG_PUB.Add('> put_decode_statement');
511: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);
512: BIS_DEBUG_PUB.Add('p_lookup_table = ' || p_lookup_table);
513: BIS_DEBUG_PUB.Add('p_lookup_type = ' || p_lookup_type);
514: BIS_DEBUG_PUB.Add('p_expr = ' || p_expr);
515: BIS_DEBUG_PUB.Add('p_language = ' || p_language);
516: -- select statement
517: l_select := get_select_statement( p_lookup_table
518: , p_lookup_type

Line 515: BIS_DEBUG_PUB.Add('p_language = ' || p_language);

511: BIS_DEBUG_PUB.Add('p_lookup_column = ' || p_lookup_column);
512: BIS_DEBUG_PUB.Add('p_lookup_table = ' || p_lookup_table);
513: BIS_DEBUG_PUB.Add('p_lookup_type = ' || p_lookup_type);
514: BIS_DEBUG_PUB.Add('p_expr = ' || p_expr);
515: BIS_DEBUG_PUB.Add('p_language = ' || p_language);
516: -- select statement
517: l_select := get_select_statement( p_lookup_table
518: , p_lookup_type
519: , p_lookup_column

Line 526: BIS_DEBUG_PUB.Add(' l_select = '||l_select);

522: );
523: -- add the language restraint
524: l_select := l_select || ' and language = '''|| p_language ||'''';
525: --
526: BIS_DEBUG_PUB.Add(' l_select = '||l_select);
527: --
528: -- write the decode statement
529: write_decode_statement ( p_expr
530: , l_select

Line 536: BIS_DEBUG_PUB.Add('< put_decode_statement_lang');

532: , x_return_status
533: , x_error_Tbl
534: );
535: --
536: BIS_DEBUG_PUB.Add('< put_decode_statement_lang');
537: --
538:
539: EXCEPTION
540: when FND_API.G_EXC_ERROR then

Line 594: BIS_DEBUG_PUB.Add('> put_decode_statement_languages');

590: l_cursor_id INTEGER;
591: l_language VARCHAR2(250);
592: l_dummy INTEGER;
593: BEGIN
594: BIS_DEBUG_PUB.Add('> put_decode_statement_languages');
595: -- open the cursor
596: l_cursor_id := dbms_sql.open_cursor;
597: --
598: -- select statement

Line 643: BIS_DEBUG_PUB.Add('< put_decode_statement_languages');

639: -- end the decode statement
640: x_select_table(x_select_table.COUNT + 1) := ', NULL )';
641: --
642: dbms_sql.close_cursor(l_cursor_id);
643: BIS_DEBUG_PUB.Add('< put_decode_statement_languages');
644: --
645:
646:
647:

Line 774: BIS_DEBUG_PUB.Add('> add_select_info');

770: )
771: IS
772: l_lang BOOLEAN := FALSE;
773: BEGIN
774: BIS_DEBUG_PUB.Add('> add_select_info');
775: --
776: -- find if the language is supported for this lookup
777: l_lang := check_language(p_lookup_table, x_return_status, x_error_Tbl);
778: --

Line 781: BIS_DEBUG_PUB.Add('language is there for table '||p_lookup_table);

777: l_lang := check_language(p_lookup_table, x_return_status, x_error_Tbl);
778: --
779: -- debug info
780: IF (l_lang = TRUE) THEN
781: BIS_DEBUG_PUB.Add('language is there for table '||p_lookup_table);
782: --
783: put_decode_statement_languages( p_expr
784: , p_lookup_table
785: , p_lookup_type

Line 793: BIS_DEBUG_PUB.Add('language not there in table '||p_lookup_table);

789: , x_error_Tbl
790: );
791: --
792: ELSE
793: BIS_DEBUG_PUB.Add('language not there in table '||p_lookup_table);
794: --
795: -- now put in the decode statement
796: put_decode_statement( p_expr
797: , p_lookup_table

Line 805: BIS_DEBUG_PUB.Add('< add_select_info');

801: , x_return_status
802: , x_error_Tbl
803: );
804: END IF;
805: BIS_DEBUG_PUB.Add('< add_select_info');
806: --
807:
808: EXCEPTION
809: when FND_API.G_EXC_ERROR then

Line 866: BIS_DEBUG_PUB.Add('> parse_LA_select');

862: l_str VARCHAR2(2000);
863: l_tmp_pointer bis_vg_types.View_Character_Pointer_Type;
864: BEGIN
865:
866: BIS_DEBUG_PUB.Add('> parse_LA_select');
867: -- skip the _LA part
868: l_str := bis_vg_parser.Skip_Tag( p_View_Select_Table
869: , p_select_pointer
870: , x_select_pointer

Line 946: BIS_DEBUG_PUB.Add('x_expr = '||x_expr);

942: END IF;
943: --
944: -- replace two consecutive single quotes by one single quote
945: x_expr := REPLACE(x_expr, '''''', '''');
946: BIS_DEBUG_PUB.Add('x_expr = '||x_expr);
947: --
948: -- get the lookup table
949: x_lookup_table := bis_vg_parser.get_token_increment_pointer
950: ( p_View_Select_Table

Line 957: BIS_DEBUG_PUB.Add('x_lookup_table = '||x_lookup_table);

953: , x_select_pointer
954: , x_return_status
955: , x_error_Tbl
956: );
957: BIS_DEBUG_PUB.Add('x_lookup_table = '||x_lookup_table);
958: --
959: IF (x_lookup_table IS NULL
960: OR
961: bis_vg_util.equal_pointers(

Line 994: BIS_DEBUG_PUB.Add('x_lookup_type = '||x_lookup_type);

990: , x_select_pointer
991: , x_return_status
992: , x_error_Tbl
993: );
994: BIS_DEBUG_PUB.Add('x_lookup_type = '||x_lookup_type);
995: --
996: IF (x_lookup_type IS NULL
997: OR
998: bis_vg_util.equal_pointers(

Line 1032: BIS_DEBUG_PUB.Add('x_lookup_column = '||x_lookup_column);

1028: , x_return_status
1029: , x_error_Tbl
1030: );
1031: --
1032: BIS_DEBUG_PUB.Add('x_lookup_column = '||x_lookup_column);
1033: --
1034: IF (x_lookup_column IS NULL
1035: ) THEN
1036: BIS_VG_UTIL.Add_Error_message

Line 1052: BIS_DEBUG_PUB.Add('Parse_LA_Select Tag = '|| l_str);

1048: );
1049: RAISE FND_API.G_EXC_ERROR;
1050: END IF;
1051:
1052: BIS_DEBUG_PUB.Add('Parse_LA_Select Tag = '|| l_str);
1053:
1054:
1055: BIS_DEBUG_PUB.Add('< parse_LA_select');
1056: --

Line 1055: BIS_DEBUG_PUB.Add('< parse_LA_select');

1051:
1052: BIS_DEBUG_PUB.Add('Parse_LA_Select Tag = '|| l_str);
1053:
1054:
1055: BIS_DEBUG_PUB.Add('< parse_LA_select');
1056: --
1057: EXCEPTION
1058: when FND_API.G_EXC_ERROR then
1059: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1134: BIS_DEBUG_PUB.Add('> check_lookup_exists');

1130: from user_tab_columns col1
1131: where col1.table_name =UPPER(p_table)
1132: and col1.column_name = UPPER(p_column);
1133: begin
1134: BIS_DEBUG_PUB.Add('> check_lookup_exists');
1135: BIS_DEBUG_PUB.Add('Table = '|| p_table);
1136: BIS_DEBUG_PUB.Add('Column = '|| p_column);
1137: open l_object_cursor;
1138: fetch l_object_cursor into l_object_type;

Line 1135: BIS_DEBUG_PUB.Add('Table = '|| p_table);

1131: where col1.table_name =UPPER(p_table)
1132: and col1.column_name = UPPER(p_column);
1133: begin
1134: BIS_DEBUG_PUB.Add('> check_lookup_exists');
1135: BIS_DEBUG_PUB.Add('Table = '|| p_table);
1136: BIS_DEBUG_PUB.Add('Column = '|| p_column);
1137: open l_object_cursor;
1138: fetch l_object_cursor into l_object_type;
1139: close l_object_cursor;

Line 1136: BIS_DEBUG_PUB.Add('Column = '|| p_column);

1132: and col1.column_name = UPPER(p_column);
1133: begin
1134: BIS_DEBUG_PUB.Add('> check_lookup_exists');
1135: BIS_DEBUG_PUB.Add('Table = '|| p_table);
1136: BIS_DEBUG_PUB.Add('Column = '|| p_column);
1137: open l_object_cursor;
1138: fetch l_object_cursor into l_object_type;
1139: close l_object_cursor;
1140:

Line 1146: BIS_DEBUG_PUB.Add('< check_lookup_exists');

1142: open l_tab_view_cursor ;
1143: fetch l_tab_view_cursor into l_dummy ;
1144: l_return_value := l_tab_view_cursor%found;
1145: close l_tab_view_cursor ;
1146: BIS_DEBUG_PUB.Add('< check_lookup_exists');
1147: return(l_return_value);
1148: elsif l_object_type='SYNONYM' then
1149: open l_tab_syn_cursor ;
1150: fetch l_tab_syn_cursor into l_dummy ;

Line 1153: BIS_DEBUG_PUB.Add('< check_lookup_exists');

1149: open l_tab_syn_cursor ;
1150: fetch l_tab_syn_cursor into l_dummy ;
1151: l_return_value := l_tab_syn_cursor%found;
1152: close l_tab_syn_cursor ;
1153: BIS_DEBUG_PUB.Add('< check_lookup_exists');
1154: return(l_return_value);
1155: else
1156: BIS_DEBUG_PUB.Add('check_lookup_exists returned '||NVL(l_object_type,'NULL')||'object type');
1157: return FALSE;

Line 1156: BIS_DEBUG_PUB.Add('check_lookup_exists returned '||NVL(l_object_type,'NULL')||'object type');

1152: close l_tab_syn_cursor ;
1153: BIS_DEBUG_PUB.Add('< check_lookup_exists');
1154: return(l_return_value);
1155: else
1156: BIS_DEBUG_PUB.Add('check_lookup_exists returned '||NVL(l_object_type,'NULL')||'object type');
1157: return FALSE;
1158: end if;
1159:
1160: END CHECK_LOOKUP_EXISTS;

Line 1196: BIS_DEBUG_PUB.Add('> put_decode_in_select');

1192: l_lookup_type VARCHAR2(1000);
1193: l_lookup_column VARCHAR2(100);
1194:
1195: BEGIN
1196: BIS_DEBUG_PUB.Add('> put_decode_in_select');
1197:
1198: parse_LA_select ( p_View_Select_Table
1199: , p_Select_Pointer
1200: , l_expr

Line 1255: BIS_DEBUG_PUB.Add('> put_decode_in_select');

1251: RAISE FND_API.G_EXC_ERROR;
1252: END IF;
1253: END IF;
1254: --
1255: BIS_DEBUG_PUB.Add('> put_decode_in_select');
1256: --
1257: EXCEPTION
1258: when FND_API.G_EXC_ERROR then
1259: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1318: BIS_DEBUG_PUB.Add('> add_Lookup_Info :-)');

1314: )
1315: IS
1316: --
1317: BEGIN
1318: BIS_DEBUG_PUB.Add('> add_Lookup_Info :-)');
1319: --
1320: put_column_name( p_view_column_table
1321: , p_column_pointer
1322: , p_Mode

Line 1341: BIS_DEBUG_PUB.Add('< add_Lookup_Info :-(');

1337: --
1338: -- bis_vg_util.print_view_text(x_column_table, x_return_status, x_error_Tbl);
1339: -- bis_vg_util.print_view_text(x_select_table, x_return_status, x_error_Tbl);
1340: --
1341: BIS_DEBUG_PUB.Add('< add_Lookup_Info :-(');
1342: --
1343:
1344:
1345: EXCEPTION