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

Line 46: BIS_DEBUG_PUB.Add('> is_char_delimiter');

42: )
43: RETURN BOOLEAN IS
44: --
45: BEGIN
46: BIS_DEBUG_PUB.Add('> is_char_delimiter');
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48:
49: IF( p_character = ' '
50: -- OR p_character = ' '

Line 54: BIS_DEBUG_PUB.Add('return TRUE');

50: -- OR p_character = ' '
51: OR p_character = ','
52: OR p_character = '-'
53: ) THEN
54: BIS_DEBUG_PUB.Add('return TRUE');
55: BIS_DEBUG_PUB.Add('< is_char_delimiter');
56: RETURN TRUE;
57: ELSE
58: bis_debug_pub.Add('char = <' || p_character || '>');

Line 55: BIS_DEBUG_PUB.Add('< is_char_delimiter');

51: OR p_character = ','
52: OR p_character = '-'
53: ) THEN
54: BIS_DEBUG_PUB.Add('return TRUE');
55: BIS_DEBUG_PUB.Add('< is_char_delimiter');
56: RETURN TRUE;
57: ELSE
58: bis_debug_pub.Add('char = <' || p_character || '>');
59: BIS_DEBUG_PUB.Add('return FALSE');

Line 58: bis_debug_pub.Add('char = <' || p_character || '>');

54: BIS_DEBUG_PUB.Add('return TRUE');
55: BIS_DEBUG_PUB.Add('< is_char_delimiter');
56: RETURN TRUE;
57: ELSE
58: bis_debug_pub.Add('char = <' || p_character || '>');
59: BIS_DEBUG_PUB.Add('return FALSE');
60: BIS_DEBUG_PUB.Add('< is_char_delimiter');
61: RETURN FALSE;
62: END IF;

Line 59: BIS_DEBUG_PUB.Add('return FALSE');

55: BIS_DEBUG_PUB.Add('< is_char_delimiter');
56: RETURN TRUE;
57: ELSE
58: bis_debug_pub.Add('char = <' || p_character || '>');
59: BIS_DEBUG_PUB.Add('return FALSE');
60: BIS_DEBUG_PUB.Add('< is_char_delimiter');
61: RETURN FALSE;
62: END IF;
63:

Line 60: BIS_DEBUG_PUB.Add('< is_char_delimiter');

56: RETURN TRUE;
57: ELSE
58: bis_debug_pub.Add('char = <' || p_character || '>');
59: BIS_DEBUG_PUB.Add('return FALSE');
60: BIS_DEBUG_PUB.Add('< is_char_delimiter');
61: RETURN FALSE;
62: END IF;
63:
64: EXCEPTION

Line 103: bis_debug_pub.Add('> create_Text_Table');

99: l_string VARCHAR2(200);
100: l_old_chunk_size NUMBER;
101: --
102: BEGIN
103: bis_debug_pub.Add('> create_Text_Table');
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105:
106: l_string_len := LENGTH(p_String);
107: IF(l_string_len <= l_chunk_size) THEN

Line 115: bis_debug_pub.add('length of l_string = ' || LENGTH(l_string));

111: LOOP
112: -- take string og length l_chunk_size from l_beg_pos
113: l_string := SUBSTR(p_string, l_beg_pos, l_chunk_size);
114: l_old_chunk_size := l_chunk_size;
115: bis_debug_pub.add('length of l_string = ' || LENGTH(l_string));
116: bis_debug_pub.add('l_string = ' || l_string);
117: IF( LENGTH(l_string) < l_chunk_size ) THEN
118: -- string can be stored in one row of table;
119: -- prepend l_end_string from previous iteration

Line 116: bis_debug_pub.add('l_string = ' || l_string);

112: -- take string og length l_chunk_size from l_beg_pos
113: l_string := SUBSTR(p_string, l_beg_pos, l_chunk_size);
114: l_old_chunk_size := l_chunk_size;
115: bis_debug_pub.add('length of l_string = ' || LENGTH(l_string));
116: bis_debug_pub.add('l_string = ' || l_string);
117: IF( LENGTH(l_string) < l_chunk_size ) THEN
118: -- string can be stored in one row of table;
119: -- prepend l_end_string from previous iteration
120: x_View_Table(x_View_Table.COUNT + 1) := l_end_string || l_string;

Line 135: bis_debug_pub.add('l_pos = ' || l_pos);

131:
132: ) LOOP
133: l_pos := l_pos - 1;
134: END LOOP;
135: bis_debug_pub.add('l_pos = ' || l_pos);
136: bis_debug_pub.add('l_beg_pos = ' || l_beg_pos);
137: bis_debug_pub.add('l_chunk_size = ' || l_chunk_size);
138: -- store the portion of string till the valid delimiter
139: l_beg_string := SUBSTR(l_string, 1, l_pos);

Line 136: bis_debug_pub.add('l_beg_pos = ' || l_beg_pos);

132: ) LOOP
133: l_pos := l_pos - 1;
134: END LOOP;
135: bis_debug_pub.add('l_pos = ' || l_pos);
136: bis_debug_pub.add('l_beg_pos = ' || l_beg_pos);
137: bis_debug_pub.add('l_chunk_size = ' || l_chunk_size);
138: -- store the portion of string till the valid delimiter
139: l_beg_string := SUBSTR(l_string, 1, l_pos);
140: bis_debug_pub.add('l_beg_string = ' || l_beg_string);

Line 137: bis_debug_pub.add('l_chunk_size = ' || l_chunk_size);

133: l_pos := l_pos - 1;
134: END LOOP;
135: bis_debug_pub.add('l_pos = ' || l_pos);
136: bis_debug_pub.add('l_beg_pos = ' || l_beg_pos);
137: bis_debug_pub.add('l_chunk_size = ' || l_chunk_size);
138: -- store the portion of string till the valid delimiter
139: l_beg_string := SUBSTR(l_string, 1, l_pos);
140: bis_debug_pub.add('l_beg_string = ' || l_beg_string);
141: -- prepend l_end_string from previous iteration to l_beg_string

Line 140: bis_debug_pub.add('l_beg_string = ' || l_beg_string);

136: bis_debug_pub.add('l_beg_pos = ' || l_beg_pos);
137: bis_debug_pub.add('l_chunk_size = ' || l_chunk_size);
138: -- store the portion of string till the valid delimiter
139: l_beg_string := SUBSTR(l_string, 1, l_pos);
140: bis_debug_pub.add('l_beg_string = ' || l_beg_string);
141: -- prepend l_end_string from previous iteration to l_beg_string
142: -- to create a row of the table
143: x_View_Table(x_View_Table.COUNT + 1) := l_end_string || l_beg_string;
144: IF(l_pos = l_chunk_size) THEN

Line 148: bis_debug_pub.add('l_end_string = NULL; l_chunk_size = 200');

144: IF(l_pos = l_chunk_size) THEN
145: -- got delimiter at the end of l_string; reset values
146: l_end_string := NULL;
147: l_chunk_size := 200;
148: bis_debug_pub.add('l_end_string = NULL; l_chunk_size = 200');
149: ELSE
150: -- store the end portion of string beyond the delimiter
151: l_end_string := SUBSTR(l_string, l_pos + 1);
152: -- set l_chunk_size for next iteration to account for the spillover

Line 154: bis_debug_pub.add('l_end_string = ' || l_end_string);

150: -- store the end portion of string beyond the delimiter
151: l_end_string := SUBSTR(l_string, l_pos + 1);
152: -- set l_chunk_size for next iteration to account for the spillover
153: l_chunk_size := 200 - LENGTH(l_end_string);
154: bis_debug_pub.add('l_end_string = ' || l_end_string);
155: bis_debug_pub.add('l_chunk_size = ' || l_chunk_size);
156: END IF;
157: END IF;
158: -- exit if we did not find enough characters ie., end of string reached

Line 155: bis_debug_pub.add('l_chunk_size = ' || l_chunk_size);

151: l_end_string := SUBSTR(l_string, l_pos + 1);
152: -- set l_chunk_size for next iteration to account for the spillover
153: l_chunk_size := 200 - LENGTH(l_end_string);
154: bis_debug_pub.add('l_end_string = ' || l_end_string);
155: bis_debug_pub.add('l_chunk_size = ' || l_chunk_size);
156: END IF;
157: END IF;
158: -- exit if we did not find enough characters ie., end of string reached
159: EXIT WHEN LENGTH(l_string) < l_old_chunk_size;

Line 162: bis_debug_pub.Add('< create_Text_Table');

158: -- exit if we did not find enough characters ie., end of string reached
159: EXIT WHEN LENGTH(l_string) < l_old_chunk_size;
160: END LOOP;
161: END IF;
162: bis_debug_pub.Add('< create_Text_Table');
163:
164:
165: EXCEPTION
166: when FND_API.G_EXC_ERROR then

Line 198: bis_debug_pub.Add('> get_string_len30');

194: l_CursorID INTEGER;
195: l_dummy INTEGER;
196: --
197: BEGIN
198: bis_debug_pub.Add('> get_string_len30');
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
201: l_String := REPLACE(p_Col_Name, ' ', '_');
202: l_String := REPLACE(l_String, '^', '_');

Line 215: bis_debug_pub.Add('< get_string_len30');

211: l_String := '"' || l_String || '"';
212: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
213: END;
214: RETURN l_String;
215: bis_debug_pub.Add('< get_string_len30');
216:
217:
218: EXCEPTION
219: when FND_API.G_EXC_ERROR then

Line 252: BIS_DEBUG_PUB.Add('> get_string_len30');

248: l_String VARCHAR2(100);
249: l_Suffix_Len NUMBER := 0;
250: --
251: BEGIN
252: BIS_DEBUG_PUB.Add('> get_string_len30');
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: IF(p_Suffix IS NOT NULL) THEN
256: l_Suffix_Len := LENGTH(p_Suffix);

Line 260: BIS_DEBUG_PUB.Add('< get_string_len30');

256: l_Suffix_Len := LENGTH(p_Suffix);
257: END IF;
258: l_String := SUBSTR(p_Prefix || p_String, 1, 30 - l_Suffix_Len) || p_Suffix;
259: RETURN l_String;
260: BIS_DEBUG_PUB.Add('< get_string_len30');
261:
262:
263: EXCEPTION
264: when FND_API.G_EXC_ERROR then

Line 298: BIS_DEBUG_PUB.Add('> get_string');

294: l_str VARCHAR2(32000);
295: end_pointer bis_vg_types.view_character_pointer_type;
296: BEGIN
297:
298: BIS_DEBUG_PUB.Add('> get_string');
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300:
301: print_view_pointer ( p_start_pointer
302: , x_return_status

Line 350: BIS_DEBUG_PUB.Add('< get_string');

346: END IF;
347: END LOOP;
348: END IF;
349:
350: BIS_DEBUG_PUB.Add('< get_string');
351: RETURN l_ret;
352:
353: EXCEPTION
354: when FND_API.G_EXC_ERROR then

Line 415: BIS_DEBUG_PUB.Add('> increment_pointer');

411: is
412: l_str VARCHAR2(2000);
413: l_pointer bis_vg_types.view_character_pointer_type;
414: begin
415: BIS_DEBUG_PUB.Add('> increment_pointer');
416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417: l_str := p_view_table(p_pointer.row_num);
418: IF (p_pointer.col_num = Length(l_str)) THEN
419: -- if at end of table return null

Line 428: BIS_DEBUG_PUB.Add('< increment_pointer');

424: ELSE
425: l_pointer.row_num := p_pointer.row_num;
426: l_pointer.col_num := p_pointer.col_num + 1;
427: END IF;
428: BIS_DEBUG_PUB.Add('< increment_pointer');
429: RETURN l_pointer;
430:
431:
432: EXCEPTION

Line 464: BIS_DEBUG_PUB.Add('> concatenate_Tables');

460: IS
461: --
462: l_count INTEGER;
463: BEGIN
464: BIS_DEBUG_PUB.Add('> concatenate_Tables');
465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466: x_View_Table := p_View_Table_A;
467: l_count := x_View_Table.COUNT + 1;
468: for p_ind in 1 .. p_View_Table_B.COUNT loop

Line 472: BIS_DEBUG_PUB.Add('< concatenate_Tables');

468: for p_ind in 1 .. p_View_Table_B.COUNT loop
469: x_View_Table(l_count) := p_View_Table_B(p_ind);
470: l_count := l_count + 1;
471: end loop;
472: BIS_DEBUG_PUB.Add('< concatenate_Tables');
473:
474:
475: EXCEPTION
476: when FND_API.G_EXC_ERROR then

Line 507: BIS_DEBUG_PUB.Add('> concatenate_Tables Flex_Column_Comment');

503: IS
504: --
505: l_count INTEGER;
506: BEGIN
507: BIS_DEBUG_PUB.Add('> concatenate_Tables Flex_Column_Comment');
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509: x_View_Table := p_View_Table_A;
510: l_count := x_View_Table.COUNT + 1;
511: for p_ind in 1 .. p_View_Table_B.COUNT loop

Line 515: BIS_DEBUG_PUB.Add('< concatenate_Tables Flex_Column_Comment');

511: for p_ind in 1 .. p_View_Table_B.COUNT loop
512: x_View_Table(l_count) := p_View_Table_B(p_ind);
513: l_count := l_count + 1;
514: end loop;
515: BIS_DEBUG_PUB.Add('< concatenate_Tables Flex_Column_Comment');
516:
517:
518: EXCEPTION
519: when FND_API.G_EXC_ERROR then

Line 548: BIS_DEBUG_PUB.Add('> equal_pointers');

544: )
545: RETURN BOOLEAN IS
546: --
547: BEGIN
548: BIS_DEBUG_PUB.Add('> equal_pointers');
549: x_return_status := FND_API.G_RET_STS_SUCCESS;
550: -- both are null; return true
551: IF (null_pointer(p_start_pointer, x_return_status, x_error_Tbl) = TRUE)
552: AND (null_pointer(p_end_pointer, x_return_status, x_error_Tbl) = TRUE) THEN

Line 567: BIS_DEBUG_PUB.Add('< equal_pointers');

563: RETURN TRUE;
564: ELSE
565: RETURN FALSE;
566: END IF;
567: BIS_DEBUG_PUB.Add('< equal_pointers');
568:
569:
570: EXCEPTION
571: when FND_API.G_EXC_ERROR then

Line 605: BIS_DEBUG_PUB.Add('> copy part of table');

601: l_start NUMBER;
602: l_end NUMBER;
603: j NUMBER;
604: BEGIN
605: BIS_DEBUG_PUB.Add('> copy part of table');
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607:
608: print_view_pointer ( p_start_pointer
609: , x_return_status

Line 624: BIS_DEBUG_PUB.Add('count = '||p_view_table_a.COUNT);

620: )
621: ) THEN
622: RETURN;
623: END IF;
624: BIS_DEBUG_PUB.Add('count = '||p_view_table_a.COUNT);
625:
626: IF (null_pointer(p_start_pointer, x_return_status, x_error_Tbl)
627: = TRUE
628: )

Line 639: BIS_DEBUG_PUB.Add('l_str = '||l_str);

635: ) = TRUE
636: OR p_start_pointer.row_num < p_end_pointer.row_num
637: ) THEN
638: l_str := p_view_table_a(p_start_pointer.row_num);
639: BIS_DEBUG_PUB.Add('l_str = '||l_str);
640: x_view_table(1) := Substr(l_str, p_start_pointer.col_num);
641: BIS_DEBUG_PUB.Add('part str = '||x_view_table(1));
642:
643: l_start := p_start_pointer.row_num + 1;

Line 641: BIS_DEBUG_PUB.Add('part str = '||x_view_table(1));

637: ) THEN
638: l_str := p_view_table_a(p_start_pointer.row_num);
639: BIS_DEBUG_PUB.Add('l_str = '||l_str);
640: x_view_table(1) := Substr(l_str, p_start_pointer.col_num);
641: BIS_DEBUG_PUB.Add('part str = '||x_view_table(1));
642:
643: l_start := p_start_pointer.row_num + 1;
644:
645: BIS_DEBUG_PUB.Add('after assignment');

Line 645: BIS_DEBUG_PUB.Add('after assignment');

641: BIS_DEBUG_PUB.Add('part str = '||x_view_table(1));
642:
643: l_start := p_start_pointer.row_num + 1;
644:
645: BIS_DEBUG_PUB.Add('after assignment');
646:
647: IF (p_end_pointer.row_num IS NULL) THEN
648: l_end := p_view_table_a.COUNT;
649: else

Line 654: BIS_DEBUG_PUB.Add('l_end = '||l_end||' l_start = '||l_start);

650: l_end := p_end_pointer.row_num - 1;
651: END IF;
652:
653: j := 2;
654: BIS_DEBUG_PUB.Add('l_end = '||l_end||' l_start = '||l_start);
655:
656: IF (l_end >= l_start) THEN
657: FOR i IN l_start .. l_end LOOP
658: BIS_DEBUG_PUB.Add(i||'th = '||p_view_table_a(i));

Line 658: BIS_DEBUG_PUB.Add(i||'th = '||p_view_table_a(i));

654: BIS_DEBUG_PUB.Add('l_end = '||l_end||' l_start = '||l_start);
655:
656: IF (l_end >= l_start) THEN
657: FOR i IN l_start .. l_end LOOP
658: BIS_DEBUG_PUB.Add(i||'th = '||p_view_table_a(i));
659: BIS_DEBUG_PUB.Add('j = '||j);
660: x_view_table(j) := p_view_table_a(i);
661: BIS_DEBUG_PUB.Add(j||'th = '||x_view_table(j));
662: j := j + 1;

Line 659: BIS_DEBUG_PUB.Add('j = '||j);

655:
656: IF (l_end >= l_start) THEN
657: FOR i IN l_start .. l_end LOOP
658: BIS_DEBUG_PUB.Add(i||'th = '||p_view_table_a(i));
659: BIS_DEBUG_PUB.Add('j = '||j);
660: x_view_table(j) := p_view_table_a(i);
661: BIS_DEBUG_PUB.Add(j||'th = '||x_view_table(j));
662: j := j + 1;
663: END LOOP;

Line 661: BIS_DEBUG_PUB.Add(j||'th = '||x_view_table(j));

657: FOR i IN l_start .. l_end LOOP
658: BIS_DEBUG_PUB.Add(i||'th = '||p_view_table_a(i));
659: BIS_DEBUG_PUB.Add('j = '||j);
660: x_view_table(j) := p_view_table_a(i);
661: BIS_DEBUG_PUB.Add(j||'th = '||x_view_table(j));
662: j := j + 1;
663: END LOOP;
664: END IF;
665:

Line 666: BIS_DEBUG_PUB.Add('after the loop');

662: j := j + 1;
663: END LOOP;
664: END IF;
665:
666: BIS_DEBUG_PUB.Add('after the loop');
667:
668: IF (l_end <> p_view_table_a.COUNT AND p_end_pointer.col_num > 1) THEN
669: bis_debug_pub.ADD(' putting in the last line');
670: l_str := p_view_table_a(p_end_pointer.row_num);

Line 669: bis_debug_pub.ADD(' putting in the last line');

665:
666: BIS_DEBUG_PUB.Add('after the loop');
667:
668: IF (l_end <> p_view_table_a.COUNT AND p_end_pointer.col_num > 1) THEN
669: bis_debug_pub.ADD(' putting in the last line');
670: l_str := p_view_table_a(p_end_pointer.row_num);
671: j := x_view_table.COUNT + 1;
672: x_view_table(j) := Substr(l_str, 1, p_end_pointer.col_num - 1);
673: END IF;

Line 676: BIS_DEBUG_PUB.Add('l_str = '||l_str);

672: x_view_table(j) := Substr(l_str, 1, p_end_pointer.col_num - 1);
673: END IF;
674: ELSIF (p_start_pointer.row_num = p_end_pointer.row_num) THEN
675: l_str := p_view_table_a(p_start_pointer.row_num);
676: BIS_DEBUG_PUB.Add('l_str = '||l_str);
677: x_view_table(1) := Substr( l_str
678: , p_start_pointer.col_num
679: , p_end_pointer.col_num -
680: p_start_pointer.col_num

Line 683: BIS_DEBUG_PUB.Add('< copy part of table');

679: , p_end_pointer.col_num -
680: p_start_pointer.col_num
681: );
682: END IF;
683: BIS_DEBUG_PUB.Add('< copy part of table');
684:
685:
686: EXCEPTION
687: when FND_API.G_EXC_ERROR then

Line 726: BIS_DEBUG_PUB.Add('> print_View_Text');

722: --
723: i NUMBER;
724: --
725: BEGIN
726: BIS_DEBUG_PUB.Add('> print_View_Text');
727: x_return_status := FND_API.G_RET_STS_SUCCESS;
728: bis_debug_pub.ADD('# of rows in table = '||p_view_text_table.COUNT);
729: for i in 1 .. p_View_Text_Table.COUNT loop
730: BIS_DEBUG_PUB.Add(p_View_Text_Table(i));

Line 728: bis_debug_pub.ADD('# of rows in table = '||p_view_text_table.COUNT);

724: --
725: BEGIN
726: BIS_DEBUG_PUB.Add('> print_View_Text');
727: x_return_status := FND_API.G_RET_STS_SUCCESS;
728: bis_debug_pub.ADD('# of rows in table = '||p_view_text_table.COUNT);
729: for i in 1 .. p_View_Text_Table.COUNT loop
730: BIS_DEBUG_PUB.Add(p_View_Text_Table(i));
731: end loop;
732: BIS_DEBUG_PUB.Add('< print_View_Text');

Line 730: BIS_DEBUG_PUB.Add(p_View_Text_Table(i));

726: BIS_DEBUG_PUB.Add('> print_View_Text');
727: x_return_status := FND_API.G_RET_STS_SUCCESS;
728: bis_debug_pub.ADD('# of rows in table = '||p_view_text_table.COUNT);
729: for i in 1 .. p_View_Text_Table.COUNT loop
730: BIS_DEBUG_PUB.Add(p_View_Text_Table(i));
731: end loop;
732: BIS_DEBUG_PUB.Add('< print_View_Text');
733:
734:

Line 732: BIS_DEBUG_PUB.Add('< print_View_Text');

728: bis_debug_pub.ADD('# of rows in table = '||p_view_text_table.COUNT);
729: for i in 1 .. p_View_Text_Table.COUNT loop
730: BIS_DEBUG_PUB.Add(p_View_Text_Table(i));
731: end loop;
732: BIS_DEBUG_PUB.Add('< print_View_Text');
733:
734:
735: EXCEPTION
736: when FND_API.G_EXC_ERROR then

Line 772: BIS_DEBUG_PUB.Add('> print_View_pointer');

768: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
769: )
770: IS
771: BEGIN
772: BIS_DEBUG_PUB.Add('> print_View_pointer');
773: x_return_status := FND_API.G_RET_STS_SUCCESS;
774: BIS_DEBUG_PUB.Add('pointer row num = '||p_pointer.row_num ||
775: ' pointer col num = '||p_pointer.col_num);
776: BIS_DEBUG_PUB.Add('< print_View_pointer');

Line 774: BIS_DEBUG_PUB.Add('pointer row num = '||p_pointer.row_num ||

770: IS
771: BEGIN
772: BIS_DEBUG_PUB.Add('> print_View_pointer');
773: x_return_status := FND_API.G_RET_STS_SUCCESS;
774: BIS_DEBUG_PUB.Add('pointer row num = '||p_pointer.row_num ||
775: ' pointer col num = '||p_pointer.col_num);
776: BIS_DEBUG_PUB.Add('< print_View_pointer');
777:
778:

Line 776: BIS_DEBUG_PUB.Add('< print_View_pointer');

772: BIS_DEBUG_PUB.Add('> print_View_pointer');
773: x_return_status := FND_API.G_RET_STS_SUCCESS;
774: BIS_DEBUG_PUB.Add('pointer row num = '||p_pointer.row_num ||
775: ' pointer col num = '||p_pointer.col_num);
776: BIS_DEBUG_PUB.Add('< print_View_pointer');
777:
778:
779: EXCEPTION
780: when FND_API.G_EXC_ERROR then

Line 822: BIS_DEBUG_PUB.Add('> position_before_characters');

818: RETURN bis_vg_types.view_character_pointer_type
819: IS
820: l_pointer bis_vg_types.view_character_pointer_type;
821: BEGIN
822: BIS_DEBUG_PUB.Add('> position_before_characters');
823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824: l_pointer.row_num := p_view_text_table.COUNT;
825: l_pointer.col_num := Length(p_view_text_table(l_pointer.row_num));
826: BIS_DEBUG_PUB.Add('< position_before_characters');

Line 826: BIS_DEBUG_PUB.Add('< position_before_characters');

822: BIS_DEBUG_PUB.Add('> position_before_characters');
823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824: l_pointer.row_num := p_view_text_table.COUNT;
825: l_pointer.col_num := Length(p_view_text_table(l_pointer.row_num));
826: BIS_DEBUG_PUB.Add('< position_before_characters');
827: RETURN (position_before_characters(p_view_text_table
828: , p_str
829: , l_pointer
830: , x_return_status

Line 881: BIS_DEBUG_PUB.Add('> position_before_characters');

877: l_pointer bis_vg_types.view_character_pointer_type;
878: l_char VARCHAR2(1);
879: l_pos NUMBER;
880: BEGIN
881: BIS_DEBUG_PUB.Add('> position_before_characters');
882: x_return_status := FND_API.G_RET_STS_SUCCESS;
883:
884: IF (p_pointer.row_num IS NULL) THEN
885: return p_pointer;

Line 887: BIS_DEBUG_PUB.Add('p_str = ' || p_str);

883:
884: IF (p_pointer.row_num IS NULL) THEN
885: return p_pointer;
886: END IF;
887: BIS_DEBUG_PUB.Add('p_str = ' || p_str);
888: print_view_pointer ( p_pointer
889: , x_return_status
890: , x_error_Tbl
891: );

Line 905: BIS_DEBUG_PUB.Add('l_char = ' || l_char || ' l_pos = ' || l_pos);

901: );
902: l_pos := Instr(p_str, l_char);
903:
904: WHILE (l_pos <> 0) LOOP
905: BIS_DEBUG_PUB.Add('l_char = ' || l_char || ' l_pos = ' || l_pos);
906: BIS_VG_UTIL.print_View_Pointer( l_pointer
907: , x_return_status
908: , x_error_Tbl
909: );

Line 923: bis_debug_pub.ADD('out of loop');

919: );
920: l_pos := Instr(p_str, l_char);
921: END LOOP;
922:
923: bis_debug_pub.ADD('out of loop');
924: BIS_VG_UTIL.print_View_Pointer ( l_pointer
925: , x_return_status
926: , x_error_Tbl
927: );

Line 928: BIS_DEBUG_PUB.Add('< position_before_characters');

924: BIS_VG_UTIL.print_View_Pointer ( l_pointer
925: , x_return_status
926: , x_error_Tbl
927: );
928: BIS_DEBUG_PUB.Add('< position_before_characters');
929: RETURN l_pointer;
930:
931: EXCEPTION
932: when FND_API.G_EXC_ERROR then

Line 964: BIS_DEBUG_PUB.Add('> decrement_pointer');

960: IS
961: l_str VARCHAR2(2000);
962: l_pointer bis_vg_types.view_character_pointer_type;
963: BEGIN
964: BIS_DEBUG_PUB.Add('> decrement_pointer');
965: x_return_status := FND_API.G_RET_STS_SUCCESS;
966:
967: IF (p_pointer.row_num IS NULL) THEN
968: return p_pointer;

Line 984: BIS_DEBUG_PUB.Add('< decrement_pointer');

980: l_pointer.col_num := Length(l_str);
981: ELSE
982: l_pointer.col_num := l_pointer.col_num - 1;
983: END IF;
984: BIS_DEBUG_PUB.Add('< decrement_pointer');
985: RETURN l_pointer;
986:
987: EXCEPTION
988: when FND_API.G_EXC_ERROR then

Line 1096: BIS_DEBUG_PUB.Add('> increment_pointer_by_row ');

1092: RETURN bis_vg_types.view_character_pointer_type
1093: IS
1094: l_pointer bis_vg_types.view_character_pointer_type;
1095: BEGIN
1096: BIS_DEBUG_PUB.Add('> increment_pointer_by_row ');
1097: x_return_status := FND_API.G_RET_STS_SUCCESS;
1098: IF ( null_pointer ( p_pointer
1099: , x_return_status
1100: , x_error_Tbl

Line 1110: BIS_DEBUG_PUB.Add('< increment_pointer_by_row ');

1106:
1107: l_pointer := p_pointer;
1108: l_pointer.row_num := l_pointer.row_num + 1;
1109: l_pointer.col_num := 1;
1110: BIS_DEBUG_PUB.Add('< increment_pointer_by_row ');
1111: RETURN l_pointer;
1112:
1113: EXCEPTION
1114: when FND_API.G_EXC_ERROR then

Line 1147: bis_debug_pub.Add('> get_generated_view_name');

1143: l_pos NUMBER;
1144: --
1145: BEGIN
1146:
1147: bis_debug_pub.Add('> get_generated_view_name');
1148: x_return_status := FND_API.G_RET_STS_SUCCESS;
1149: l_pos := INSTR(p_View_Name, 'V_');
1150: l_View_Name := SUBSTR(p_View_Name, 1, l_pos - 1)
1151: || 'G'

Line 1156: bis_debug_pub.Add('< get_generated_view_name');

1152: || SUBSTR( p_View_Name
1153: , l_pos + 1
1154: , LENGTH(p_View_Name) - l_pos
1155: );
1156: bis_debug_pub.Add('< get_generated_view_name');
1157: RETURN l_view_name;
1158:
1159: EXCEPTION
1160: when FND_API.G_EXC_ERROR then