DBA Data[Home] [Help]

APPS.JTF_DBSTREAM_UTILS dependencies on FND_MESSAGE

Line 39: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

35: readerCharIndex := 1;
36: readerRowIndex := inputStream.FIRST;
37: exception
38: when others then
39: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
40: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
41: fnd_message.set_token('MSG','jtf_dbstream_utils.initInputStreamVariables :'||SQLERRM);
42: app_exception.raise_exception;
43: end initInputStreamVariables;

Line 40: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

36: readerRowIndex := inputStream.FIRST;
37: exception
38: when others then
39: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
40: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
41: fnd_message.set_token('MSG','jtf_dbstream_utils.initInputStreamVariables :'||SQLERRM);
42: app_exception.raise_exception;
43: end initInputStreamVariables;
44: -----------------------------------------------------------------------------

Line 41: fnd_message.set_token('MSG','jtf_dbstream_utils.initInputStreamVariables :'||SQLERRM);

37: exception
38: when others then
39: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
40: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
41: fnd_message.set_token('MSG','jtf_dbstream_utils.initInputStreamVariables :'||SQLERRM);
42: app_exception.raise_exception;
43: end initInputStreamVariables;
44: -----------------------------------------------------------------------------
45:

Line 51: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

47: begin
48: inputStream.DELETE;
49: exception
50: when others then
51: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
52: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
53: fnd_message.set_token('MSG','jtf_dbstream_utils.clearInputStream :'||SQLERRM);
54: app_exception.raise_exception;
55: end clearInputStream;

Line 52: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

48: inputStream.DELETE;
49: exception
50: when others then
51: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
52: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
53: fnd_message.set_token('MSG','jtf_dbstream_utils.clearInputStream :'||SQLERRM);
54: app_exception.raise_exception;
55: end clearInputStream;
56:

Line 53: fnd_message.set_token('MSG','jtf_dbstream_utils.clearInputStream :'||SQLERRM);

49: exception
50: when others then
51: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
52: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
53: fnd_message.set_token('MSG','jtf_dbstream_utils.clearInputStream :'||SQLERRM);
54: app_exception.raise_exception;
55: end clearInputStream;
56:
57: -----------------------------------------------------------------------------

Line 65: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

61: begin
62: return instr(inputStream(rowIndex),trailingDelimiter,leadingDelimiterPos);
63: exception
64: when others then
65: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
66: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
67: fnd_message.set_token('MSG','jtf_dbstream_utils.getTrailingDelimiterPos :'||SQLERRM);
68: app_exception.raise_exception;
69: end getTrailingDelimiterPos;

Line 66: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

62: return instr(inputStream(rowIndex),trailingDelimiter,leadingDelimiterPos);
63: exception
64: when others then
65: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
66: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
67: fnd_message.set_token('MSG','jtf_dbstream_utils.getTrailingDelimiterPos :'||SQLERRM);
68: app_exception.raise_exception;
69: end getTrailingDelimiterPos;
70: ------------------------------------------------------------------------------

Line 67: fnd_message.set_token('MSG','jtf_dbstream_utils.getTrailingDelimiterPos :'||SQLERRM);

63: exception
64: when others then
65: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
66: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
67: fnd_message.set_token('MSG','jtf_dbstream_utils.getTrailingDelimiterPos :'||SQLERRM);
68: app_exception.raise_exception;
69: end getTrailingDelimiterPos;
70: ------------------------------------------------------------------------------
71:

Line 79: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

75: begin
76: return to_number(substr(inputStream(rowIndex),leadingDelimiterPos + 1,trailingDelimiterPos - leadingDelimiterPos - 1));
77: exception
78: when others then
79: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
80: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
81: fnd_message.set_token('MSG','jtf_dbstream_utils.getStringLength :'||SQLERRM);
82: app_exception.raise_exception;
83: end getStringLength;

Line 80: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

76: return to_number(substr(inputStream(rowIndex),leadingDelimiterPos + 1,trailingDelimiterPos - leadingDelimiterPos - 1));
77: exception
78: when others then
79: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
80: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
81: fnd_message.set_token('MSG','jtf_dbstream_utils.getStringLength :'||SQLERRM);
82: app_exception.raise_exception;
83: end getStringLength;
84: ------------------------------------------------------------------------------

Line 81: fnd_message.set_token('MSG','jtf_dbstream_utils.getStringLength :'||SQLERRM);

77: exception
78: when others then
79: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
80: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
81: fnd_message.set_token('MSG','jtf_dbstream_utils.getStringLength :'||SQLERRM);
82: app_exception.raise_exception;
83: end getStringLength;
84: ------------------------------------------------------------------------------
85:

Line 95: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

91: raise UNSUPPORTED_OPERATION;
92: end if;
93: exception
94: when NULL_STREAM then
95: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
96: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
97: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.checkForCommonErrors: No input stream has been set.');
98: app_exception.raise_exception;
99: when UNSUPPORTED_OPERATION then

Line 96: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

92: end if;
93: exception
94: when NULL_STREAM then
95: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
96: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
97: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.checkForCommonErrors: No input stream has been set.');
98: app_exception.raise_exception;
99: when UNSUPPORTED_OPERATION then
100: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

Line 97: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.checkForCommonErrors: No input stream has been set.');

93: exception
94: when NULL_STREAM then
95: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
96: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
97: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.checkForCommonErrors: No input stream has been set.');
98: app_exception.raise_exception;
99: when UNSUPPORTED_OPERATION then
100: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
101: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

Line 100: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

96: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
97: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.checkForCommonErrors: No input stream has been set.');
98: app_exception.raise_exception;
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;

Line 101: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

97: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.checkForCommonErrors: No input stream has been set.');
98: app_exception.raise_exception;
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

Line 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.'

98: app_exception.raise_exception;
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');

Line 106: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

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');
108: fnd_message.set_token('MSG','jtf_dbstream_utils.checkForCommonErrors :'||SQLERRM);
109: app_exception.raise_exception;
110: end checkForCommonErrors;

Line 107: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

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');
108: fnd_message.set_token('MSG','jtf_dbstream_utils.checkForCommonErrors :'||SQLERRM);
109: app_exception.raise_exception;
110: end checkForCommonErrors;
111: ------------------------------------------------------------------------------

Line 108: fnd_message.set_token('MSG','jtf_dbstream_utils.checkForCommonErrors :'||SQLERRM);

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');
108: fnd_message.set_token('MSG','jtf_dbstream_utils.checkForCommonErrors :'||SQLERRM);
109: app_exception.raise_exception;
110: end checkForCommonErrors;
111: ------------------------------------------------------------------------------
112:

Line 141: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

137: readerPosition := readerPosition + 1;
138: return substr(inputStream(readerRowIndex),trailingDelimiterPos + 1,stringLength);
139: exception
140: when END_OF_STREAM then
141: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
142: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
143: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: The end of the stream has been reached.');
144: app_exception.raise_exception;
145: when INVALID_DELIMITER then

Line 142: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

138: return substr(inputStream(readerRowIndex),trailingDelimiterPos + 1,stringLength);
139: exception
140: when END_OF_STREAM then
141: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
142: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
143: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: The end of the stream has been reached.');
144: app_exception.raise_exception;
145: when INVALID_DELIMITER then
146: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

Line 143: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: The end of the stream has been reached.');

139: exception
140: when END_OF_STREAM then
141: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
142: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
143: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: The end of the stream has been reached.');
144: app_exception.raise_exception;
145: when INVALID_DELIMITER then
146: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
147: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

Line 146: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

142: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
143: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: The end of the stream has been reached.');
144: app_exception.raise_exception;
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)||'>'

Line 147: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

143: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: The end of the stream has been reached.');
144: app_exception.raise_exception;
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)||'>');

Line 148: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: Invalid delimiter at:'

144: app_exception.raise_exception;
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;

Line 154: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

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

Line 155: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

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

Line 156: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: Invalid readerPositition:'

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

Line 162: -- fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

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);
164: -- app_exception.raise_exception;
165: end readNextString;
166:

Line 163: -- fnd_message.set_token('MSG','jtf_dbstream_utils.readNextString :'||SQLERRM);

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);
164: -- app_exception.raise_exception;
165: end readNextString;
166:
167:

Line 186: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

182: i := i + 1;
183: end loop;
184: exception
185: when others then
186: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
187: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
188: fnd_message.set_token('MSG','jtf_dbstream_utils.updateReaderIndexes :'||SQLERRM);
189: app_exception.raise_exception;
190: end updateReaderIndexes;

Line 187: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

183: end loop;
184: exception
185: when others then
186: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
187: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
188: fnd_message.set_token('MSG','jtf_dbstream_utils.updateReaderIndexes :'||SQLERRM);
189: app_exception.raise_exception;
190: end updateReaderIndexes;
191:

Line 188: fnd_message.set_token('MSG','jtf_dbstream_utils.updateReaderIndexes :'||SQLERRM);

184: exception
185: when others then
186: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
187: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
188: fnd_message.set_token('MSG','jtf_dbstream_utils.updateReaderIndexes :'||SQLERRM);
189: app_exception.raise_exception;
190: end updateReaderIndexes;
191:
192:

Line 211: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

207: end if;
208: outputStream(writerRowIndex) := outputStream(writerRowIndex) || newString;
209: exception
210: when others then
211: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
212: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
213: fnd_message.set_token('MSG','jtf_dbstream_utils.writeNextString :'||SQLERRM);
214: app_exception.raise_exception;
215: end writeNextString;

Line 212: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

208: outputStream(writerRowIndex) := outputStream(writerRowIndex) || newString;
209: exception
210: when others then
211: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
212: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
213: fnd_message.set_token('MSG','jtf_dbstream_utils.writeNextString :'||SQLERRM);
214: app_exception.raise_exception;
215: end writeNextString;
216:

Line 213: fnd_message.set_token('MSG','jtf_dbstream_utils.writeNextString :'||SQLERRM);

209: exception
210: when others then
211: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
212: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
213: fnd_message.set_token('MSG','jtf_dbstream_utils.writeNextString :'||SQLERRM);
214: app_exception.raise_exception;
215: end writeNextString;
216:
217: ------------------------------------------------------------------------------

Line 229: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

225: inputStream := stream;
226: initInputStreamVariables;
227: exception
228: when others then
229: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
230: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
231: fnd_message.set_token('MSG','jtf_dbstream_utils.setLongInputStream :'||SQLERRM);
232: app_exception.raise_exception;
233: end setLongInputStream;

Line 230: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

226: initInputStreamVariables;
227: exception
228: when others then
229: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
230: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
231: fnd_message.set_token('MSG','jtf_dbstream_utils.setLongInputStream :'||SQLERRM);
232: app_exception.raise_exception;
233: end setLongInputStream;
234:

Line 231: fnd_message.set_token('MSG','jtf_dbstream_utils.setLongInputStream :'||SQLERRM);

227: exception
228: when others then
229: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
230: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
231: fnd_message.set_token('MSG','jtf_dbstream_utils.setLongInputStream :'||SQLERRM);
232: app_exception.raise_exception;
233: end setLongInputStream;
234:
235: -----------------------------------------------------------------------------

Line 243: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

239: inputStream(1) := stream;
240: initInputStreamVariables;
241: exception
242: when others then
243: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
244: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
245: fnd_message.set_token('MSG','jtf_dbstream_utils.setInputStream :'||SQLERRM);
246: app_exception.raise_exception;
247: end setInputStream;

Line 244: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

240: initInputStreamVariables;
241: exception
242: when others then
243: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
244: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
245: fnd_message.set_token('MSG','jtf_dbstream_utils.setInputStream :'||SQLERRM);
246: app_exception.raise_exception;
247: end setInputStream;
248: -----------------------------------------------------------------------------

Line 245: fnd_message.set_token('MSG','jtf_dbstream_utils.setInputStream :'||SQLERRM);

241: exception
242: when others then
243: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
244: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
245: fnd_message.set_token('MSG','jtf_dbstream_utils.setInputStream :'||SQLERRM);
246: app_exception.raise_exception;
247: end setInputStream;
248: -----------------------------------------------------------------------------
249: procedure setReaderPosition(i in pls_integer) is

Line 254: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

250: begin
251: updateReaderIndexes(i);
252: exception
253: when others then
254: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
255: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
256: fnd_message.set_token('MSG','jtf_dbstream_utils.setReaderPosition :'||SQLERRM);
257: app_exception.raise_exception;
258: end setReaderPosition;

Line 255: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

251: updateReaderIndexes(i);
252: exception
253: when others then
254: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
255: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
256: fnd_message.set_token('MSG','jtf_dbstream_utils.setReaderPosition :'||SQLERRM);
257: app_exception.raise_exception;
258: end setReaderPosition;
259: -----------------------------------------------------------------------------

Line 256: fnd_message.set_token('MSG','jtf_dbstream_utils.setReaderPosition :'||SQLERRM);

252: exception
253: when others then
254: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
255: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
256: fnd_message.set_token('MSG','jtf_dbstream_utils.setReaderPosition :'||SQLERRM);
257: app_exception.raise_exception;
258: end setReaderPosition;
259: -----------------------------------------------------------------------------
260: function endOfInputStream return boolean is

Line 270: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

266: return true;
267: end if;
268: exception
269: when others then
270: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
271: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
272: fnd_message.set_token('MSG','jtf_dbstream_utils.endOfInputStream :'||SQLERRM);
273: app_exception.raise_exception;
274: end endOfInputStream;

Line 271: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

267: end if;
268: exception
269: when others then
270: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
271: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
272: fnd_message.set_token('MSG','jtf_dbstream_utils.endOfInputStream :'||SQLERRM);
273: app_exception.raise_exception;
274: end endOfInputStream;
275: -----------------------------------------------------------------------------

Line 272: fnd_message.set_token('MSG','jtf_dbstream_utils.endOfInputStream :'||SQLERRM);

268: exception
269: when others then
270: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
271: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
272: fnd_message.set_token('MSG','jtf_dbstream_utils.endOfInputStream :'||SQLERRM);
273: app_exception.raise_exception;
274: end endOfInputStream;
275: -----------------------------------------------------------------------------
276: function readString return varchar2 is

Line 281: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

277: begin
278: return readNextString;
279: exception
280: when others then
281: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
282: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
283: fnd_message.set_token('MSG','jtf_dbstream_utils.readString :'||SQLERRM);
284: app_exception.raise_exception;
285: end readString;

Line 282: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

278: return readNextString;
279: exception
280: when others then
281: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
282: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
283: fnd_message.set_token('MSG','jtf_dbstream_utils.readString :'||SQLERRM);
284: app_exception.raise_exception;
285: end readString;
286: -----------------------------------------------------------------------------

Line 283: fnd_message.set_token('MSG','jtf_dbstream_utils.readString :'||SQLERRM);

279: exception
280: when others then
281: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
282: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
283: fnd_message.set_token('MSG','jtf_dbstream_utils.readString :'||SQLERRM);
284: app_exception.raise_exception;
285: end readString;
286: -----------------------------------------------------------------------------
287: function readDate return date is

Line 292: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

288: begin
289: return fnd_date.displaydate_to_date(readNextString);
290: exception
291: when others then
292: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
293: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
294: fnd_message.set_token('MSG','jtf_dbstream_utils.readDate :'||SQLERRM);
295: app_exception.raise_exception;
296: end readDate;

Line 293: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

289: return fnd_date.displaydate_to_date(readNextString);
290: exception
291: when others then
292: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
293: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
294: fnd_message.set_token('MSG','jtf_dbstream_utils.readDate :'||SQLERRM);
295: app_exception.raise_exception;
296: end readDate;
297: -----------------------------------------------------------------------------

Line 294: fnd_message.set_token('MSG','jtf_dbstream_utils.readDate :'||SQLERRM);

290: exception
291: when others then
292: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
293: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
294: fnd_message.set_token('MSG','jtf_dbstream_utils.readDate :'||SQLERRM);
295: app_exception.raise_exception;
296: end readDate;
297: -----------------------------------------------------------------------------
298: function readDateTime return date is

Line 303: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

299: begin
300: return fnd_date.displayDT_to_date(readNextString);
301: exception
302: when others then
303: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
304: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
305: fnd_message.set_token('MSG','jtf_dbstream_utils.readDateTime :'||SQLERRM);
306: app_exception.raise_exception;
307: end readDateTime;

Line 304: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

300: return fnd_date.displayDT_to_date(readNextString);
301: exception
302: when others then
303: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
304: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
305: fnd_message.set_token('MSG','jtf_dbstream_utils.readDateTime :'||SQLERRM);
306: app_exception.raise_exception;
307: end readDateTime;
308: -----------------------------------------------------------------------------

Line 305: fnd_message.set_token('MSG','jtf_dbstream_utils.readDateTime :'||SQLERRM);

301: exception
302: when others then
303: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
304: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
305: fnd_message.set_token('MSG','jtf_dbstream_utils.readDateTime :'||SQLERRM);
306: app_exception.raise_exception;
307: end readDateTime;
308: -----------------------------------------------------------------------------
309: function readBoolean return boolean is

Line 314: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

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');
316: fnd_message.set_token('MSG','jtf_dbstream_utils.readBoolean :'||SQLERRM);
317: app_exception.raise_exception;
318: end readBoolean;

Line 315: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

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');
316: fnd_message.set_token('MSG','jtf_dbstream_utils.readBoolean :'||SQLERRM);
317: app_exception.raise_exception;
318: end readBoolean;
319: -----------------------------------------------------------------------------

Line 316: fnd_message.set_token('MSG','jtf_dbstream_utils.readBoolean :'||SQLERRM);

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');
316: fnd_message.set_token('MSG','jtf_dbstream_utils.readBoolean :'||SQLERRM);
317: app_exception.raise_exception;
318: end readBoolean;
319: -----------------------------------------------------------------------------
320: function readInt return integer is

Line 325: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

321: begin
322: return to_number(readNextString);
323: exception
324: when others then
325: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
326: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
327: fnd_message.set_token('MSG','jtf_dbstream_utils.readInt :'||SQLERRM);
328: app_exception.raise_exception;
329: end readInt;

Line 326: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

322: return to_number(readNextString);
323: exception
324: when others then
325: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
326: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
327: fnd_message.set_token('MSG','jtf_dbstream_utils.readInt :'||SQLERRM);
328: app_exception.raise_exception;
329: end readInt;
330: -----------------------------------------------------------------------------

Line 327: fnd_message.set_token('MSG','jtf_dbstream_utils.readInt :'||SQLERRM);

323: exception
324: when others then
325: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
326: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
327: fnd_message.set_token('MSG','jtf_dbstream_utils.readInt :'||SQLERRM);
328: app_exception.raise_exception;
329: end readInt;
330: -----------------------------------------------------------------------------
331: function readNumber return number is

Line 336: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

332: begin
333: return to_number(readNextString);
334: exception
335: when others then
336: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
337: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
338: fnd_message.set_token('MSG','jtf_dbstream_utils.readNumber :'||SQLERRM);
339: app_exception.raise_exception;
340: end readNumber;

Line 337: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

333: return to_number(readNextString);
334: exception
335: when others then
336: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
337: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
338: fnd_message.set_token('MSG','jtf_dbstream_utils.readNumber :'||SQLERRM);
339: app_exception.raise_exception;
340: end readNumber;
341:

Line 338: fnd_message.set_token('MSG','jtf_dbstream_utils.readNumber :'||SQLERRM);

334: exception
335: when others then
336: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
337: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
338: fnd_message.set_token('MSG','jtf_dbstream_utils.readNumber :'||SQLERRM);
339: app_exception.raise_exception;
340: end readNumber;
341:
342: -----------------------------------------------------------------------------

Line 354: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

350: begin
351: return outPutStream;
352: exception
353: when others then
354: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
355: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
356: fnd_message.set_token('MSG','jtf_dbstream_utils.getLongOutputStream :'||SQLERRM);
357: app_exception.raise_exception;
358: end getLongOutputStream;

Line 355: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

351: return outPutStream;
352: exception
353: when others then
354: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
355: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
356: fnd_message.set_token('MSG','jtf_dbstream_utils.getLongOutputStream :'||SQLERRM);
357: app_exception.raise_exception;
358: end getLongOutputStream;
359: -----------------------------------------------------------------------------

Line 356: fnd_message.set_token('MSG','jtf_dbstream_utils.getLongOutputStream :'||SQLERRM);

352: exception
353: when others then
354: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
355: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
356: fnd_message.set_token('MSG','jtf_dbstream_utils.getLongOutputStream :'||SQLERRM);
357: app_exception.raise_exception;
358: end getLongOutputStream;
359: -----------------------------------------------------------------------------
360: function getOutputStream return varchar2 is

Line 365: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

361: begin
362: return outputStream(outPutStream.FIRST);
363: exception
364: when others then
365: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
366: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
367: fnd_message.set_token('MSG','jtf_dbstream_utils.getOutputStream :'||SQLERRM);
368: app_exception.raise_exception;
369: end getOutputStream;

Line 366: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

362: return outputStream(outPutStream.FIRST);
363: exception
364: when others then
365: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
366: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
367: fnd_message.set_token('MSG','jtf_dbstream_utils.getOutputStream :'||SQLERRM);
368: app_exception.raise_exception;
369: end getOutputStream;
370: -----------------------------------------------------------------------------

Line 367: fnd_message.set_token('MSG','jtf_dbstream_utils.getOutputStream :'||SQLERRM);

363: exception
364: when others then
365: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
366: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
367: fnd_message.set_token('MSG','jtf_dbstream_utils.getOutputStream :'||SQLERRM);
368: app_exception.raise_exception;
369: end getOutputStream;
370: -----------------------------------------------------------------------------
371: function isLongOutputStream return boolean is

Line 380: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

376: return false;
377: end if;
378: exception
379: when others then
380: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
381: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
382: fnd_message.set_token('MSG','jtf_dbstream_utils.isLongOutputStream :'||SQLERRM);
383: app_exception.raise_exception;
384: end isLongOutputStream;

Line 381: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

377: end if;
378: exception
379: when others then
380: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
381: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
382: fnd_message.set_token('MSG','jtf_dbstream_utils.isLongOutputStream :'||SQLERRM);
383: app_exception.raise_exception;
384: end isLongOutputStream;
385: -----------------------------------------------------------------------------

Line 382: fnd_message.set_token('MSG','jtf_dbstream_utils.isLongOutputStream :'||SQLERRM);

378: exception
379: when others then
380: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
381: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
382: fnd_message.set_token('MSG','jtf_dbstream_utils.isLongOutputStream :'||SQLERRM);
383: app_exception.raise_exception;
384: end isLongOutputStream;
385: -----------------------------------------------------------------------------
386:

Line 393: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

389: outPutStream.DELETE;
390: writerRowIndex := null;
391: exception
392: when others then
393: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
394: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
395: fnd_message.set_token('MSG','jtf_dbstream_utils.clearOutputStream :'||SQLERRM);
396: app_exception.raise_exception;
397: end clearOutputStream;

Line 394: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

390: writerRowIndex := null;
391: exception
392: when others then
393: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
394: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
395: fnd_message.set_token('MSG','jtf_dbstream_utils.clearOutputStream :'||SQLERRM);
396: app_exception.raise_exception;
397: end clearOutputStream;
398: -----------------------------------------------------------------------------

Line 395: fnd_message.set_token('MSG','jtf_dbstream_utils.clearOutputStream :'||SQLERRM);

391: exception
392: when others then
393: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
394: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
395: fnd_message.set_token('MSG','jtf_dbstream_utils.clearOutputStream :'||SQLERRM);
396: app_exception.raise_exception;
397: end clearOutputStream;
398: -----------------------------------------------------------------------------
399: procedure writeString(s in varchar2) is

Line 404: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

400: begin
401: writeNextString(s);
402: exception
403: when others then
404: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
405: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
406: fnd_message.set_token('MSG','jtf_dbstream_utils.writeString :'||SQLERRM);
407: app_exception.raise_exception;
408: end writeString;

Line 405: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

401: writeNextString(s);
402: exception
403: when others then
404: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
405: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
406: fnd_message.set_token('MSG','jtf_dbstream_utils.writeString :'||SQLERRM);
407: app_exception.raise_exception;
408: end writeString;
409: -----------------------------------------------------------------------------

Line 406: fnd_message.set_token('MSG','jtf_dbstream_utils.writeString :'||SQLERRM);

402: exception
403: when others then
404: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
405: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
406: fnd_message.set_token('MSG','jtf_dbstream_utils.writeString :'||SQLERRM);
407: app_exception.raise_exception;
408: end writeString;
409: -----------------------------------------------------------------------------
410: procedure writeDate(d in date) is

Line 415: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

411: begin
412: writeNextString(fnd_date.date_to_displayDate(d));
413: exception
414: when others then
415: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
416: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
417: fnd_message.set_token('MSG','jtf_dbstream_utils.writeDate :'||SQLERRM);
418: app_exception.raise_exception;
419: end writeDate;

Line 416: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

412: writeNextString(fnd_date.date_to_displayDate(d));
413: exception
414: when others then
415: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
416: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
417: fnd_message.set_token('MSG','jtf_dbstream_utils.writeDate :'||SQLERRM);
418: app_exception.raise_exception;
419: end writeDate;
420: -----------------------------------------------------------------------------

Line 417: fnd_message.set_token('MSG','jtf_dbstream_utils.writeDate :'||SQLERRM);

413: exception
414: when others then
415: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
416: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
417: fnd_message.set_token('MSG','jtf_dbstream_utils.writeDate :'||SQLERRM);
418: app_exception.raise_exception;
419: end writeDate;
420: -----------------------------------------------------------------------------
421: procedure writeDateTime(d in date) is

Line 426: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

422: begin
423: writeNextString(fnd_date.date_to_displayDT(d));
424: exception
425: when others then
426: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
427: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
428: fnd_message.set_token('MSG','jtf_dbstream_utils.writeDateTime :'||SQLERRM);
429: app_exception.raise_exception;
430: end writeDateTime;

Line 427: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

423: writeNextString(fnd_date.date_to_displayDT(d));
424: exception
425: when others then
426: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
427: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
428: fnd_message.set_token('MSG','jtf_dbstream_utils.writeDateTime :'||SQLERRM);
429: app_exception.raise_exception;
430: end writeDateTime;
431: -----------------------------------------------------------------------------

Line 428: fnd_message.set_token('MSG','jtf_dbstream_utils.writeDateTime :'||SQLERRM);

424: exception
425: when others then
426: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
427: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
428: fnd_message.set_token('MSG','jtf_dbstream_utils.writeDateTime :'||SQLERRM);
429: app_exception.raise_exception;
430: end writeDateTime;
431: -----------------------------------------------------------------------------
432: procedure writeBoolean(b in boolean) is

Line 437: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

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');
439: fnd_message.set_token('MSG','jtf_dbstream_utils.writeBoolean :'||SQLERRM);
440: app_exception.raise_exception;
441: end writeBoolean;

Line 438: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

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');
439: fnd_message.set_token('MSG','jtf_dbstream_utils.writeBoolean :'||SQLERRM);
440: app_exception.raise_exception;
441: end writeBoolean;
442: -----------------------------------------------------------------------------

Line 439: fnd_message.set_token('MSG','jtf_dbstream_utils.writeBoolean :'||SQLERRM);

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');
439: fnd_message.set_token('MSG','jtf_dbstream_utils.writeBoolean :'||SQLERRM);
440: app_exception.raise_exception;
441: end writeBoolean;
442: -----------------------------------------------------------------------------
443: procedure writeInt(i in integer) is

Line 448: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

444: begin
445: writeNextString(to_char(i));
446: exception
447: when others then
448: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
449: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
450: fnd_message.set_token('MSG','jtf_dbstream_utils.writeInt :'||SQLERRM);
451: app_exception.raise_exception;
452: end writeInt;

Line 449: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

445: writeNextString(to_char(i));
446: exception
447: when others then
448: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
449: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
450: fnd_message.set_token('MSG','jtf_dbstream_utils.writeInt :'||SQLERRM);
451: app_exception.raise_exception;
452: end writeInt;
453: -----------------------------------------------------------------------------

Line 450: fnd_message.set_token('MSG','jtf_dbstream_utils.writeInt :'||SQLERRM);

446: exception
447: when others then
448: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
449: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
450: fnd_message.set_token('MSG','jtf_dbstream_utils.writeInt :'||SQLERRM);
451: app_exception.raise_exception;
452: end writeInt;
453: -----------------------------------------------------------------------------
454: procedure writeNumber(n in number) is

Line 459: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

455: begin
456: writeNextString(to_char(n));
457: exception
458: when others then
459: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
460: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
461: fnd_message.set_token('MSG','jtf_dbstream_utils.writeNumber :'||SQLERRM);
462: app_exception.raise_exception;
463: end writeNumber;

Line 460: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

456: writeNextString(to_char(n));
457: exception
458: when others then
459: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
460: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
461: fnd_message.set_token('MSG','jtf_dbstream_utils.writeNumber :'||SQLERRM);
462: app_exception.raise_exception;
463: end writeNumber;
464: -----------------------------------------------------------------------------

Line 461: fnd_message.set_token('MSG','jtf_dbstream_utils.writeNumber :'||SQLERRM);

457: exception
458: when others then
459: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
460: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
461: fnd_message.set_token('MSG','jtf_dbstream_utils.writeNumber :'||SQLERRM);
462: app_exception.raise_exception;
463: end writeNumber;
464: -----------------------------------------------------------------------------
465:

Line 490: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

486: end if;
487:
488: exception
489: when others then
490: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
491: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
492: fnd_message.set_token('MSG','jtf_dbstream_utils.addNumberToString :'||SQLERRM);
493: app_exception.raise_exception;
494: end;

Line 491: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

487:
488: exception
489: when others then
490: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
491: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
492: fnd_message.set_token('MSG','jtf_dbstream_utils.addNumberToString :'||SQLERRM);
493: app_exception.raise_exception;
494: end;
495: -----------------------------------------------------------------------------

Line 492: fnd_message.set_token('MSG','jtf_dbstream_utils.addNumberToString :'||SQLERRM);

488: exception
489: when others then
490: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
491: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
492: fnd_message.set_token('MSG','jtf_dbstream_utils.addNumberToString :'||SQLERRM);
493: app_exception.raise_exception;
494: end;
495: -----------------------------------------------------------------------------
496: /** appends all integers in inputList to the inputStream and returns the inputStream */

Line 510: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

506:
507: return l_inputStream;
508: exception
509: when others then
510: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
511: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
512: fnd_message.set_token('MSG','jtf_dbstream_utils.addIntToString :'||SQLERRM);
513: app_exception.raise_exception;
514: end;

Line 511: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

507: return l_inputStream;
508: exception
509: when others then
510: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
511: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
512: fnd_message.set_token('MSG','jtf_dbstream_utils.addIntToString :'||SQLERRM);
513: app_exception.raise_exception;
514: end;
515: -----------------------------------------------------------------------------

Line 512: fnd_message.set_token('MSG','jtf_dbstream_utils.addIntToString :'||SQLERRM);

508: exception
509: when others then
510: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
511: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
512: fnd_message.set_token('MSG','jtf_dbstream_utils.addIntToString :'||SQLERRM);
513: app_exception.raise_exception;
514: end;
515: -----------------------------------------------------------------------------
516:

Line 540: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

536:
537: return l_number_list;
538: exception
539: when others then
540: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
541: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
542: fnd_message.set_token('MSG','jtf_dbstream_utils.readFromString :'||SQLERRM);
543: app_exception.raise_exception;
544: end;

Line 541: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

537: return l_number_list;
538: exception
539: when others then
540: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
541: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
542: fnd_message.set_token('MSG','jtf_dbstream_utils.readFromString :'||SQLERRM);
543: app_exception.raise_exception;
544: end;
545: -----------------------------------------------------------------------------

Line 542: fnd_message.set_token('MSG','jtf_dbstream_utils.readFromString :'||SQLERRM);

538: exception
539: when others then
540: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
541: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
542: fnd_message.set_token('MSG','jtf_dbstream_utils.readFromString :'||SQLERRM);
543: app_exception.raise_exception;
544: end;
545: -----------------------------------------------------------------------------
546:

Line 570: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

566: end if;
567:
568: exception
569: when others then
570: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
571: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
572: fnd_message.set_token('MSG','jtf_dbstream_utils.checkNumberExists :'||SQLERRM);
573: app_exception.raise_exception;
574: end;

Line 571: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

567:
568: exception
569: when others then
570: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
571: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
572: fnd_message.set_token('MSG','jtf_dbstream_utils.checkNumberExists :'||SQLERRM);
573: app_exception.raise_exception;
574: end;
575: -----------------------------------------------------------------------------

Line 572: fnd_message.set_token('MSG','jtf_dbstream_utils.checkNumberExists :'||SQLERRM);

568: exception
569: when others then
570: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
571: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
572: fnd_message.set_token('MSG','jtf_dbstream_utils.checkNumberExists :'||SQLERRM);
573: app_exception.raise_exception;
574: end;
575: -----------------------------------------------------------------------------
576: /** removes the all occurances of the number from the string */

Line 600: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

596:
597: return l_inputStream;
598: exception
599: when others then
600: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
601: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
602: fnd_message.set_token('MSG','jtf_dbstream_utils.removeFromString :'||SQLERRM);
603: app_exception.raise_exception;
604: end;

Line 601: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');

597: return l_inputStream;
598: exception
599: when others then
600: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
601: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
602: fnd_message.set_token('MSG','jtf_dbstream_utils.removeFromString :'||SQLERRM);
603: app_exception.raise_exception;
604: end;
605:

Line 602: fnd_message.set_token('MSG','jtf_dbstream_utils.removeFromString :'||SQLERRM);

598: exception
599: when others then
600: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
601: fnd_message.set_token('SOURCE','JTF_DBSTREAM_UTILS');
602: fnd_message.set_token('MSG','jtf_dbstream_utils.removeFromString :'||SQLERRM);
603: app_exception.raise_exception;
604: end;
605:
606: