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.JTF_DBSTREAM_UTILS dependencies on JTF_DBSTRING_UTILS

Line 23: MAX_STREAM_LENGTH constant pls_integer := jtf_dbstring_utils.getMaxStringLength - STREAM_OVERHEAD;

19: UNSUPPORTED_OPERATION exception;
20: END_OF_STREAM exception;
21:
22: STREAM_OVERHEAD constant pls_integer := 100;
23: MAX_STREAM_LENGTH constant pls_integer := jtf_dbstring_utils.getMaxStringLength - STREAM_OVERHEAD;
24: MAX_STRING_LENGTH constant pls_integer := 32767;
25:
26: INT_SEPARATOR constant varchar2(1) := ':';
27:

Line 103: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'rows: <'||nvl(to_char(inputStream.COUNT),jtf_dbstring_utils.getNullString)||'>');

99: when UNSUPPORTED_OPERATION then
100: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
101: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
102: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.checkForCommonErrors: Streams made up of multiple rows are not supported in this release.'
103: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'rows: <'||nvl(to_char(inputStream.COUNT),jtf_dbstring_utils.getNullString)||'>');
104: app_exception.raise_exception;
105: when others then
106: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
107: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

Line 149: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'position: <'||nvl(to_char(leadingDelimiterPos),jtf_dbstring_utils.getNullString)||'>'

145: when INVALID_DELIMITER then
146: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
147: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
148: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: Invalid delimiter at:'
149: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'position: <'||nvl(to_char(leadingDelimiterPos),jtf_dbstring_utils.getNullString)||'>'
150: ||jtf_dbstring_utils.getLineFeed||'row: <'||nvl(to_char(readerRowIndex),jtf_dbstring_utils.getNullString)||'>'
151: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'in stream <'||inputStream(readerRowIndex)||'>');
152: app_exception.raise_exception;
153: when INVALID_STREAM then

Line 150: ||jtf_dbstring_utils.getLineFeed||'row: <'||nvl(to_char(readerRowIndex),jtf_dbstring_utils.getNullString)||'>'

146: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
147: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
148: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: Invalid delimiter at:'
149: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'position: <'||nvl(to_char(leadingDelimiterPos),jtf_dbstring_utils.getNullString)||'>'
150: ||jtf_dbstring_utils.getLineFeed||'row: <'||nvl(to_char(readerRowIndex),jtf_dbstring_utils.getNullString)||'>'
151: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'in stream <'||inputStream(readerRowIndex)||'>');
152: app_exception.raise_exception;
153: when INVALID_STREAM then
154: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

Line 151: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'in stream <'||inputStream(readerRowIndex)||'>');

147: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
148: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: Invalid delimiter at:'
149: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'position: <'||nvl(to_char(leadingDelimiterPos),jtf_dbstring_utils.getNullString)||'>'
150: ||jtf_dbstring_utils.getLineFeed||'row: <'||nvl(to_char(readerRowIndex),jtf_dbstring_utils.getNullString)||'>'
151: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'in stream <'||inputStream(readerRowIndex)||'>');
152: app_exception.raise_exception;
153: when INVALID_STREAM then
154: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
155: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

Line 157: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'readerPosition: <'||nvl(to_char(readerPosition),jtf_dbstring_utils.getNullString)||'>'

153: when INVALID_STREAM then
154: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
155: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
156: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: Invalid readerPositition:'
157: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'readerPosition: <'||nvl(to_char(readerPosition),jtf_dbstring_utils.getNullString)||'>'
158: ||jtf_dbstring_utils.getLineFeed||'row: <'||nvl(to_char(readerRowIndex),jtf_dbstring_utils.getNullString)||'>'
159: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'for stream <'||inputStream(readerRowIndex)||'>');
160: app_exception.raise_exception;
161: -- when others then

Line 158: ||jtf_dbstring_utils.getLineFeed||'row: <'||nvl(to_char(readerRowIndex),jtf_dbstring_utils.getNullString)||'>'

154: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
155: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
156: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: Invalid readerPositition:'
157: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'readerPosition: <'||nvl(to_char(readerPosition),jtf_dbstring_utils.getNullString)||'>'
158: ||jtf_dbstring_utils.getLineFeed||'row: <'||nvl(to_char(readerRowIndex),jtf_dbstring_utils.getNullString)||'>'
159: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'for stream <'||inputStream(readerRowIndex)||'>');
160: app_exception.raise_exception;
161: -- when others then
162: -- fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

Line 159: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'for stream <'||inputStream(readerRowIndex)||'>');

155: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
156: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: Invalid readerPositition:'
157: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'readerPosition: <'||nvl(to_char(readerPosition),jtf_dbstring_utils.getNullString)||'>'
158: ||jtf_dbstring_utils.getLineFeed||'row: <'||nvl(to_char(readerRowIndex),jtf_dbstring_utils.getNullString)||'>'
159: ||jtf_dbstring_utils.getLineFeed||jtf_dbstring_utils.getLineFeed||'for stream <'||inputStream(readerRowIndex)||'>');
160: app_exception.raise_exception;
161: -- when others then
162: -- fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
163: -- fnd_message.set_token('MSG','jtf_dbstream_utils.readNextString :'||SQLERRM);

Line 177: dummy jtf_dbstring_utils.maxString%TYPE;

173: -- AND ONE ROW IN THE STREAM IN THIS VERSION.
174: -----------------------------------------------------------------------------
175: procedure updateReaderIndexes(newReaderPos in pls_integer) is
176: i integer := 1;
177: dummy jtf_dbstring_utils.maxString%TYPE;
178: begin
179: initInputStreamVariables;
180: while i < newReaderPos loop
181: dummy := readNextString;

Line 195: newString jtf_dbstring_utils.maxString%TYPE := leadingDelimiter || to_char(stringLength) || trailingDelimiter || s;

191:
192:
193: procedure writeNextString(s in varchar2) is
194: stringLength integer := nvl(length(s),0);
195: newString jtf_dbstring_utils.maxString%TYPE := leadingDelimiter || to_char(stringLength) || trailingDelimiter || s;
196: begin
197: if outputStream.COUNT = 0 then
198: writerRowIndex := 1;
199: outputStream(writerRowIndex) := null;

Line 201: -- if (length(outputStream(writerRowIndex)) + length(newString)) > jtf_dbstring_utils.getMaxStringLength then

197: if outputStream.COUNT = 0 then
198: writerRowIndex := 1;
199: outputStream(writerRowIndex) := null;
200: end if;
201: -- if (length(outputStream(writerRowIndex)) + length(newString)) > jtf_dbstring_utils.getMaxStringLength then
202:
203: --The length method is changed to lengthb to fix bug#2613658
204: if (lengthb(outputStream(writerRowIndex)) + lengthb(newString)) > MAX_STREAM_LENGTH then
205: writerRowIndex := writerRowIndex + 1;

Line 311: return jtf_dbstring_utils.getBoolean(readNextString);

307: end readDateTime;
308: -----------------------------------------------------------------------------
309: function readBoolean return boolean is
310: begin
311: return jtf_dbstring_utils.getBoolean(readNextString);
312: exception
313: when others then
314: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
315: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

Line 345: return to_number(readNextString,fnd_currency.get_format_mask(currencyCode,jtf_dbstring_utils.getCurrencyFormatLength));

341:
342: -----------------------------------------------------------------------------
343: function readCurrency(currencyCode in varchar2) return number is
344: begin
345: return to_number(readNextString,fnd_currency.get_format_mask(currencyCode,jtf_dbstring_utils.getCurrencyFormatLength));
346: end readCurrency;
347:
348: -----------------------------------------------------------------------------
349: function getLongOutputStream return streamType is

Line 434: writeNextString(jtf_dbstring_utils.getBooleanString(b));

430: end writeDateTime;
431: -----------------------------------------------------------------------------
432: procedure writeBoolean(b in boolean) is
433: begin
434: writeNextString(jtf_dbstring_utils.getBooleanString(b));
435: exception
436: when others then
437: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
438: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

Line 468: writeNextString(to_char(c,fnd_currency.get_format_mask(currencyCode,jtf_dbstring_utils.getCurrencyFormatLength)));

464: -----------------------------------------------------------------------------
465:
466: procedure writeCurrency(c in number, currencyCode in varchar2) is
467: begin
468: writeNextString(to_char(c,fnd_currency.get_format_mask(currencyCode,jtf_dbstring_utils.getCurrencyFormatLength)));
469: end writeCurrency;
470:
471: ----------------------------------------------------------------------------
472: FUNCTION getVersion RETURN VARCHAR2 IS