DBA Data[Home] [Help]

APPS.JTF_DBSTREAM_UTILS dependencies on APP_EXCEPTION

Line 42: app_exception.raise_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:
46: procedure clearInputStream is

Line 54: app_exception.raise_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: -----------------------------------------------------------------------------
58:

Line 68: app_exception.raise_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:
72: function getStringLength(rowIndex in pls_integer

Line 82: app_exception.raise_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:
86: procedure checkForCommonErrors is

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

Line 104: app_exception.raise_exception;

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

Line 109: 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:
113: function readNextString return varchar2 is

Line 144: app_exception.raise_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');
148: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: Invalid delimiter at:'

Line 152: app_exception.raise_exception;

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');
156: fnd_message.set_token('MSG','An unexpected error occurred in jtf_dbstream_utils.readNextString: Invalid readerPositition:'

Line 160: app_exception.raise_exception;

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

Line 164: -- app_exception.raise_exception;

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:
168: ------------------------------------------------------------------------------

Line 189: app_exception.raise_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:
193: procedure writeNextString(s in varchar2) is

Line 214: app_exception.raise_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: ------------------------------------------------------------------------------
218: -- PUBLIC METHODS

Line 232: app_exception.raise_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: -----------------------------------------------------------------------------
236: procedure setInputStream(stream in varchar2) is

Line 246: app_exception.raise_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
250: begin

Line 257: app_exception.raise_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
261: begin

Line 273: app_exception.raise_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
277: begin

Line 284: app_exception.raise_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
288: begin

Line 295: app_exception.raise_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
299: begin

Line 306: app_exception.raise_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
310: begin

Line 317: app_exception.raise_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
321: begin

Line 328: app_exception.raise_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
332: begin

Line 339: app_exception.raise_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: -----------------------------------------------------------------------------
343: function readCurrency(currencyCode in varchar2) return number is

Line 357: app_exception.raise_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
361: begin

Line 368: app_exception.raise_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
372: begin

Line 383: app_exception.raise_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:
387: procedure clearOutputStream is

Line 396: app_exception.raise_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
400: begin

Line 407: app_exception.raise_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
411: begin

Line 418: app_exception.raise_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
422: begin

Line 429: app_exception.raise_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
433: begin

Line 440: app_exception.raise_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
444: begin

Line 451: app_exception.raise_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
455: begin

Line 462: app_exception.raise_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:
466: procedure writeCurrency(c in number, currencyCode in varchar2) is

Line 493: app_exception.raise_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 */
497: function addNumberToString(inputList in int_table,

Line 513: app_exception.raise_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:
517: /** returns an table of integers from a string */

Line 543: app_exception.raise_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:
547:

Line 573: app_exception.raise_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 */
577: function removeFromString(inputStream in varchar2,

Line 603: app_exception.raise_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:
607: