APPS.AP_WEB_UTILITIES_PKG dependencies on FND_MESSAGE

Line 62: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

58:
59: EXCEPTION
60: WHEN OTHERS THEN
61: BEGIN
62: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
63: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
64: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'IsMobileApp');
65: APP_EXCEPTION.RAISE_EXCEPTION;
66: END;

Line 63: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

59: EXCEPTION
60: WHEN OTHERS THEN
61: BEGIN
62: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
63: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
64: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'IsMobileApp');
65: APP_EXCEPTION.RAISE_EXCEPTION;
66: END;
67: END;

Line 64: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'IsMobileApp');

60: WHEN OTHERS THEN
61: BEGIN
62: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
63: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
64: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'IsMobileApp');
65: APP_EXCEPTION.RAISE_EXCEPTION;
66: END;
67: END;
68:

Line 100: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

96: l_has = 'Y' AND l_cCardEnabled = 'Y');
97: EXCEPTION
98: WHEN OTHERS THEN
99: BEGIN
100: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
101: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
102: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'isCreditCardEnabled');
103: DisplayException(fnd_message.get);
104: END;

Line 101: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

97: EXCEPTION
98: WHEN OTHERS THEN
99: BEGIN
100: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
101: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
102: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'isCreditCardEnabled');
103: DisplayException(fnd_message.get);
104: END;
105: END isCreditCardEnabled;

Line 102: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'isCreditCardEnabled');

98: WHEN OTHERS THEN
99: BEGIN
100: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
101: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
102: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'isCreditCardEnabled');
103: DisplayException(fnd_message.get);
104: END;
105: END isCreditCardEnabled;
106:

Line 103: DisplayException(fnd_message.get);

99: BEGIN
100: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
101: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
102: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'isCreditCardEnabled');
103: DisplayException(fnd_message.get);
104: END;
105: END isCreditCardEnabled;
106:
107:

Line 117: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_GO_BACK');

113: ------------------------------------------------------------------------
114: PROCEDURE DisplayException (P_ErrorText Long) IS
115: BEGIN
116: htp.htmlOpen;
117: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_GO_BACK');
118: htp.p('');
119: htp.p(replace(P_ErrorText,'
120: ',' '));
121: htp.p('

');

Line 124: htp.p(fnd_message.get||'');

120: ',' '));
121: htp.p('

');
122: htp.p('');
124: htp.p(fnd_message.get||'');
125: htp.p('');
126: htp.htmlClose;
127: EXCEPTION
128: WHEN OTHERS THEN

Line 130: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

126: htp.htmlClose;
127: EXCEPTION
128: WHEN OTHERS THEN
129: BEGIN
130: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
131: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
132: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DisplayException' || P_ErrorText);
133: APP_EXCEPTION.RAISE_EXCEPTION;
134: END;

Line 131: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

127: EXCEPTION
128: WHEN OTHERS THEN
129: BEGIN
130: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
131: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
132: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DisplayException' || P_ErrorText);
133: APP_EXCEPTION.RAISE_EXCEPTION;
134: END;
135:

Line 132: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DisplayException' || P_ErrorText);

128: WHEN OTHERS THEN
129: BEGIN
130: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
131: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
132: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DisplayException' || P_ErrorText);
133: APP_EXCEPTION.RAISE_EXCEPTION;
134: END;
135:
136: END;

Line 160: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

156:
157: EXCEPTION
158: WHEN OTHERS THEN
159: BEGIN
160: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
161: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
162: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetUserAgent');
163: DisplayException(fnd_message.get);
164: END;

Line 161: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

157: EXCEPTION
158: WHEN OTHERS THEN
159: BEGIN
160: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
161: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
162: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetUserAgent');
163: DisplayException(fnd_message.get);
164: END;
165:

Line 162: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetUserAgent');

158: WHEN OTHERS THEN
159: BEGIN
160: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
161: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
162: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetUserAgent');
163: DisplayException(fnd_message.get);
164: END;
165:
166: END GetUserAgent;

Line 163: DisplayException(fnd_message.get);

159: BEGIN
160: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
161: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
162: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetUserAgent');
163: DisplayException(fnd_message.get);
164: END;
165:
166: END GetUserAgent;
167:

Line 220: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

216: CLOSE l_curr_cursor;
217: EXCEPTION
218: WHEN OTHERS THEN
219: BEGIN
220: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
221: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
222: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PopulateCurrencyArray');
223: DisplayException(fnd_message.get);
224: END;

Line 221: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

217: EXCEPTION
218: WHEN OTHERS THEN
219: BEGIN
220: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
221: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
222: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PopulateCurrencyArray');
223: DisplayException(fnd_message.get);
224: END;
225:

Line 222: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PopulateCurrencyArray');

218: WHEN OTHERS THEN
219: BEGIN
220: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
221: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
222: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PopulateCurrencyArray');
223: DisplayException(fnd_message.get);
224: END;
225:
226: END PopulateCurrencyArray;

Line 223: DisplayException(fnd_message.get);

219: BEGIN
220: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
221: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
222: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PopulateCurrencyArray');
223: DisplayException(fnd_message.get);
224: END;
225:
226: END PopulateCurrencyArray;
227:

Line 295: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_CANCEL_REPORT');

291: htp.p('
292: function CancelExpenseReport() {
293: ');
294:
295: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_CANCEL_REPORT');
296:
297: htp.p('
298: if (!confirm("'||AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get, TRUE)||'"))
299: return;

Line 298: if (!confirm("'||AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get, TRUE)||'"))

294:
295: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_CANCEL_REPORT');
296:
297: htp.p('
298: if (!confirm("'||AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get, TRUE)||'"))
299: return;
300: ');
301: ExitExpenseReport;
302: htp.p('

Line 360: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

356:
357: EXCEPTION
358: WHEN OTHERS THEN
359: BEGIN
360: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
361: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
362: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitDayOFWeekArray');
363: DisplayException(fnd_message.get);
364: END;

Line 361: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

357: EXCEPTION
358: WHEN OTHERS THEN
359: BEGIN
360: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
361: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
362: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitDayOFWeekArray');
363: DisplayException(fnd_message.get);
364: END;
365:

Line 362: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitDayOFWeekArray');

358: WHEN OTHERS THEN
359: BEGIN
360: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
361: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
362: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitDayOFWeekArray');
363: DisplayException(fnd_message.get);
364: END;
365:
366: END InitDayOFWeekArray;

Line 363: DisplayException(fnd_message.get);

359: BEGIN
360: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
361: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
362: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitDayOFWeekArray');
363: DisplayException(fnd_message.get);
364: END;
365:
366: END InitDayOFWeekArray;
367:

Line 390: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

386:
387: EXCEPTION
388: WHEN OTHERS THEN
389: BEGIN
390: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
391: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
392: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NDaysInCalendar');
393: DisplayException(fnd_message.get);
394: END;

Line 391: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

387: EXCEPTION
388: WHEN OTHERS THEN
389: BEGIN
390: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
391: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
392: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NDaysInCalendar');
393: DisplayException(fnd_message.get);
394: END;
395:

Line 392: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NDaysInCalendar');

388: WHEN OTHERS THEN
389: BEGIN
390: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
391: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
392: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NDaysInCalendar');
393: DisplayException(fnd_message.get);
394: END;
395:
396: END;

Line 393: DisplayException(fnd_message.get);

389: BEGIN
390: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
391: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
392: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NDaysInCalendar');
393: DisplayException(fnd_message.get);
394: END;
395:
396: END;
397:

Line 424: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

420: END IF;
421: EXCEPTION
422: WHEN OTHERS THEN
423: BEGIN
424: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
425: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
426: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PopulateEquation');
427: DisplayException(fnd_message.get);
428: END;

Line 425: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

421: EXCEPTION
422: WHEN OTHERS THEN
423: BEGIN
424: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
425: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
426: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PopulateEquation');
427: DisplayException(fnd_message.get);
428: END;
429:

Line 426: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PopulateEquation');

422: WHEN OTHERS THEN
423: BEGIN
424: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
425: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
426: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PopulateEquation');
427: DisplayException(fnd_message.get);
428: END;
429:
430: END PopulateEquation;

Line 427: DisplayException(fnd_message.get);

423: BEGIN
424: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
425: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
426: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PopulateEquation');
427: DisplayException(fnd_message.get);
428: END;
429:
430: END PopulateEquation;
431:

Line 464: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

460:
461: EXCEPTION
462: WHEN OTHERS THEN
463: BEGIN
464: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
465: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
466: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RetrieveJustifFlag');
467: DisplayException(fnd_message.get);
468: END;

Line 465: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

461: EXCEPTION
462: WHEN OTHERS THEN
463: BEGIN
464: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
465: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
466: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RetrieveJustifFlag');
467: DisplayException(fnd_message.get);
468: END;
469:

Line 466: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RetrieveJustifFlag');

462: WHEN OTHERS THEN
463: BEGIN
464: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
465: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
466: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RetrieveJustifFlag');
467: DisplayException(fnd_message.get);
468: END;
469:
470: END RetrieveJustifFlag;

Line 467: DisplayException(fnd_message.get);

463: BEGIN
464: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
465: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
466: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RetrieveJustifFlag');
467: DisplayException(fnd_message.get);
468: END;
469:
470: END RetrieveJustifFlag;
471:

Line 489: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

485: }');
486: EXCEPTION
487: WHEN OTHERS THEN
488: BEGIN
489: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
490: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
491: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RetrieveJustifFlagIndex');
492: DisplayException(fnd_message.get);
493: END;

Line 490: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

486: EXCEPTION
487: WHEN OTHERS THEN
488: BEGIN
489: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
490: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
491: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RetrieveJustifFlagIndex');
492: DisplayException(fnd_message.get);
493: END;
494:

Line 491: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RetrieveJustifFlagIndex');

487: WHEN OTHERS THEN
488: BEGIN
489: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
490: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
491: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RetrieveJustifFlagIndex');
492: DisplayException(fnd_message.get);
493: END;
494:
495: END RetrieveJustifFlagIndex;

Line 492: DisplayException(fnd_message.get);

488: BEGIN
489: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
490: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
491: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RetrieveJustifFlagIndex');
492: DisplayException(fnd_message.get);
493: END;
494:
495: END RetrieveJustifFlagIndex;
496:

Line 518: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

514:
515: EXCEPTION
516: WHEN OTHERS THEN
517: BEGIN
518: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
519: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
520: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CurrencyInfo');
521: DisplayException(fnd_message.get);
522: END;

Line 519: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

515: EXCEPTION
516: WHEN OTHERS THEN
517: BEGIN
518: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
519: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
520: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CurrencyInfo');
521: DisplayException(fnd_message.get);
522: END;
523:

Line 520: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CurrencyInfo');

516: WHEN OTHERS THEN
517: BEGIN
518: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
519: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
520: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CurrencyInfo');
521: DisplayException(fnd_message.get);
522: END;
523:
524: END CurrencyInfo;

Line 521: DisplayException(fnd_message.get);

517: BEGIN
518: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
519: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
520: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CurrencyInfo');
521: DisplayException(fnd_message.get);
522: END;
523:
524: END CurrencyInfo;
525:

Line 553: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

549:
550: EXCEPTION
551: WHEN OTHERS THEN
552: BEGIN
553: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
554: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
555: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RetrieveCurrencyIndex');
556: DisplayException(fnd_message.get);
557: END;

Line 554: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

550: EXCEPTION
551: WHEN OTHERS THEN
552: BEGIN
553: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
554: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
555: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RetrieveCurrencyIndex');
556: DisplayException(fnd_message.get);
557: END;
558:

Line 555: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RetrieveCurrencyIndex');

551: WHEN OTHERS THEN
552: BEGIN
553: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
554: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
555: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RetrieveCurrencyIndex');
556: DisplayException(fnd_message.get);
557: END;
558:
559: END RetrieveCurrencyIndex;

Line 556: DisplayException(fnd_message.get);

552: BEGIN
553: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
554: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
555: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RetrieveCurrencyIndex');
556: DisplayException(fnd_message.get);
557: END;
558:
559: END RetrieveCurrencyIndex;
560:

Line 728: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

724:
725: EXCEPTION
726: WHEN OTHERS THEN
727: BEGIN
728: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
729: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
730: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MoneyFormat');
731: DisplayException(fnd_message.get);
732: END;

Line 729: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

725: EXCEPTION
726: WHEN OTHERS THEN
727: BEGIN
728: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
729: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
730: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MoneyFormat');
731: DisplayException(fnd_message.get);
732: END;
733:

Line 730: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MoneyFormat');

726: WHEN OTHERS THEN
727: BEGIN
728: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
729: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
730: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MoneyFormat');
731: DisplayException(fnd_message.get);
732: END;
733:
734: END MoneyFormat;

Line 731: DisplayException(fnd_message.get);

727: BEGIN
728: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
729: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
730: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MoneyFormat');
731: DisplayException(fnd_message.get);
732: END;
733:
734: END MoneyFormat;
735:

Line 826: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

822:
823: EXCEPTION
824: WHEN OTHERS THEN
825: BEGIN
826: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
827: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
828: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MoneyFormat2');
829: DisplayException(fnd_message.get);
830: END;

Line 827: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

823: EXCEPTION
824: WHEN OTHERS THEN
825: BEGIN
826: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
827: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
828: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MoneyFormat2');
829: DisplayException(fnd_message.get);
830: END;
831:

Line 828: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MoneyFormat2');

824: WHEN OTHERS THEN
825: BEGIN
826: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
827: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
828: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MoneyFormat2');
829: DisplayException(fnd_message.get);
830: END;
831:
832: END MoneyFormat2;

Line 829: DisplayException(fnd_message.get);

825: BEGIN
826: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
827: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
828: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MoneyFormat2');
829: DisplayException(fnd_message.get);
830: END;
831:
832: END MoneyFormat2;
833:

Line 847: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

843:
844: EXCEPTION
845: WHEN OTHERS THEN
846: BEGIN
847: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
848: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
849: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DisplayHelp');
850: DisplayException(fnd_message.get);
851: END;

Line 848: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

844: EXCEPTION
845: WHEN OTHERS THEN
846: BEGIN
847: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
848: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
849: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DisplayHelp');
850: DisplayException(fnd_message.get);
851: END;
852:

Line 849: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DisplayHelp');

845: WHEN OTHERS THEN
846: BEGIN
847: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
848: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
849: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DisplayHelp');
850: DisplayException(fnd_message.get);
851: END;
852:
853: END DisplayHelp;

Line 850: DisplayException(fnd_message.get);

846: BEGIN
847: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
848: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
849: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DisplayHelp');
850: DisplayException(fnd_message.get);
851: END;
852:
853: END DisplayHelp;
854:

Line 877: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

873:
874: EXCEPTION
875: WHEN OTHERS THEN
876: BEGIN
877: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
878: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
879: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'OverrideRequired');
880: DisplayException(fnd_message.get);
881: END;

Line 878: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

874: EXCEPTION
875: WHEN OTHERS THEN
876: BEGIN
877: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
878: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
879: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'OverrideRequired');
880: DisplayException(fnd_message.get);
881: END;
882:

Line 879: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'OverrideRequired');

875: WHEN OTHERS THEN
876: BEGIN
877: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
878: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
879: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'OverrideRequired');
880: DisplayException(fnd_message.get);
881: END;
882:
883: END OverrideRequired;

Line 880: DisplayException(fnd_message.get);

876: BEGIN
877: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
878: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
879: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'OverrideRequired');
880: DisplayException(fnd_message.get);
881: END;
882:
883: END OverrideRequired;
884:

Line 914: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

910:
911: EXCEPTION
912: WHEN OTHERS THEN
913: BEGIN
914: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
915: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
916: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PrepArg');
917: DisplayException(fnd_message.get);
918: END;

Line 915: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

911: EXCEPTION
912: WHEN OTHERS THEN
913: BEGIN
914: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
915: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
916: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PrepArg');
917: DisplayException(fnd_message.get);
918: END;
919:

Line 916: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PrepArg');

912: WHEN OTHERS THEN
913: BEGIN
914: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
915: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
916: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PrepArg');
917: DisplayException(fnd_message.get);
918: END;
919:
920: END PrepArg;

Line 917: DisplayException(fnd_message.get);

913: BEGIN
914: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
915: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
916: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PrepArg');
917: DisplayException(fnd_message.get);
918: END;
919:
920: END PrepArg;
921:

Line 945: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

941:
942: EXCEPTION
943: WHEN OTHERS THEN
944: BEGIN
945: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
946: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
947: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DownloadHTML');
948: DisplayException(fnd_message.get);
949: END;

Line 946: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

942: EXCEPTION
943: WHEN OTHERS THEN
944: BEGIN
945: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
946: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
947: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DownloadHTML');
948: DisplayException(fnd_message.get);
949: END;
950:

Line 947: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DownloadHTML');

943: WHEN OTHERS THEN
944: BEGIN
945: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
946: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
947: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DownloadHTML');
948: DisplayException(fnd_message.get);
949: END;
950:
951: END DownloadHTML;

Line 948: DisplayException(fnd_message.get);

944: BEGIN
945: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
946: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
947: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DownloadHTML');
948: DisplayException(fnd_message.get);
949: END;
950:
951: END DownloadHTML;
952:

Line 995: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

991:
992: EXCEPTION
993: WHEN OTHERS THEN
994: BEGIN
995: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
996: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
997: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetNextDelimited');
998: DisplayException(fnd_message.get);
999: END;

Line 996: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

992: EXCEPTION
993: WHEN OTHERS THEN
994: BEGIN
995: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
996: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
997: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetNextDelimited');
998: DisplayException(fnd_message.get);
999: END;
1000:

Line 997: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetNextDelimited');

993: WHEN OTHERS THEN
994: BEGIN
995: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
996: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
997: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetNextDelimited');
998: DisplayException(fnd_message.get);
999: END;
1000:
1001: END GetNextDelimited;

Line 998: DisplayException(fnd_message.get);

994: BEGIN
995: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
996: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
997: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetNextDelimited');
998: DisplayException(fnd_message.get);
999: END;
1000:
1001: END GetNextDelimited;
1002:

Line 1035: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1031:
1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: BEGIN
1035: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1036: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1037: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ContainsError');
1038: DisplayException(fnd_message.get);
1039: END;

Line 1036: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: BEGIN
1035: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1036: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1037: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ContainsError');
1038: DisplayException(fnd_message.get);
1039: END;
1040:

Line 1037: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ContainsError');

1033: WHEN OTHERS THEN
1034: BEGIN
1035: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1036: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1037: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ContainsError');
1038: DisplayException(fnd_message.get);
1039: END;
1040:
1041:

Line 1038: DisplayException(fnd_message.get);

1034: BEGIN
1035: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1036: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1037: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ContainsError');
1038: DisplayException(fnd_message.get);
1039: END;
1040:
1041:
1042: END ContainsError;

Line 1076: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1072:
1073: EXCEPTION
1074: WHEN OTHERS THEN
1075: BEGIN
1076: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1077: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1078: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ContainsWarning');
1079: DisplayException(fnd_message.get);
1080: END;

Line 1077: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1073: EXCEPTION
1074: WHEN OTHERS THEN
1075: BEGIN
1076: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1077: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1078: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ContainsWarning');
1079: DisplayException(fnd_message.get);
1080: END;
1081:

Line 1078: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ContainsWarning');

1074: WHEN OTHERS THEN
1075: BEGIN
1076: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1077: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1078: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ContainsWarning');
1079: DisplayException(fnd_message.get);
1080: END;
1081:
1082: END ContainsWarning;

Line 1079: DisplayException(fnd_message.get);

1075: BEGIN
1076: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1077: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1078: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ContainsWarning');
1079: DisplayException(fnd_message.get);
1080: END;
1081:
1082: END ContainsWarning;
1083:

Line 1117: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1113:
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: BEGIN
1117: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1118: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ContainsErrorOrWarning');
1120: DisplayException(fnd_message.get);
1121: END;

Line 1118: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: BEGIN
1117: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1118: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ContainsErrorOrWarning');
1120: DisplayException(fnd_message.get);
1121: END;
1122:

Line 1119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ContainsErrorOrWarning');

1115: WHEN OTHERS THEN
1116: BEGIN
1117: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1118: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ContainsErrorOrWarning');
1120: DisplayException(fnd_message.get);
1121: END;
1122:
1123: END ContainsErrorOrWarning;

Line 1120: DisplayException(fnd_message.get);

1116: BEGIN
1117: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1118: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ContainsErrorOrWarning');
1120: DisplayException(fnd_message.get);
1121: END;
1122:
1123: END ContainsErrorOrWarning;
1124:

Line 1152: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1148:
1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: BEGIN
1152: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1153: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1154: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ReceiptContainsError');
1155: DisplayException(fnd_message.get);
1156: END;

Line 1153: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: BEGIN
1152: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1153: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1154: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ReceiptContainsError');
1155: DisplayException(fnd_message.get);
1156: END;
1157:

Line 1154: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ReceiptContainsError');

1150: WHEN OTHERS THEN
1151: BEGIN
1152: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1153: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1154: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ReceiptContainsError');
1155: DisplayException(fnd_message.get);
1156: END;
1157:
1158: END ReceiptContainsError;

Line 1155: DisplayException(fnd_message.get);

1151: BEGIN
1152: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1153: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1154: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ReceiptContainsError');
1155: DisplayException(fnd_message.get);
1156: END;
1157:
1158: END ReceiptContainsError;
1159:

Line 1183: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: BEGIN
1183: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1184: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1185: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ReceiptContainsWarning');
1186: DisplayException(fnd_message.get);
1187: END;

Line 1184: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: BEGIN
1183: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1184: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1185: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ReceiptContainsWarning');
1186: DisplayException(fnd_message.get);
1187: END;
1188:

Line 1185: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ReceiptContainsWarning');

1181: WHEN OTHERS THEN
1182: BEGIN
1183: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1184: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1185: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ReceiptContainsWarning');
1186: DisplayException(fnd_message.get);
1187: END;
1188:
1189: END ReceiptContainsWarning;

Line 1186: DisplayException(fnd_message.get);

1182: BEGIN
1183: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1184: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1185: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ReceiptContainsWarning');
1186: DisplayException(fnd_message.get);
1187: END;
1188:
1189: END ReceiptContainsWarning;
1190:

Line 1218: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1214: return V_FieldContainsError = 'Y';
1215: EXCEPTION
1216: WHEN OTHERS THEN
1217: BEGIN
1218: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1219: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1220: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'FieldContainsError');
1221: DisplayException(fnd_message.get);
1222: END;

Line 1219: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1215: EXCEPTION
1216: WHEN OTHERS THEN
1217: BEGIN
1218: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1219: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1220: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'FieldContainsError');
1221: DisplayException(fnd_message.get);
1222: END;
1223:

Line 1220: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'FieldContainsError');

1216: WHEN OTHERS THEN
1217: BEGIN
1218: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1219: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1220: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'FieldContainsError');
1221: DisplayException(fnd_message.get);
1222: END;
1223:
1224: END FieldContainsError;

Line 1221: DisplayException(fnd_message.get);

1217: BEGIN
1218: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1219: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1220: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'FieldContainsError');
1221: DisplayException(fnd_message.get);
1222: END;
1223:
1224: END FieldContainsError;
1225:

Line 1265: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1261:
1262: EXCEPTION
1263: WHEN OTHERS THEN
1264: BEGIN
1265: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1266: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1267: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NumOfReceiptWithError');
1268: DisplayException(fnd_message.get);
1269: END;

Line 1266: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1262: EXCEPTION
1263: WHEN OTHERS THEN
1264: BEGIN
1265: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1266: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1267: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NumOfReceiptWithError');
1268: DisplayException(fnd_message.get);
1269: END;
1270:

Line 1267: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NumOfReceiptWithError');

1263: WHEN OTHERS THEN
1264: BEGIN
1265: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1266: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1267: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NumOfReceiptWithError');
1268: DisplayException(fnd_message.get);
1269: END;
1270:
1271: END NumOfReceiptWithError;

Line 1268: DisplayException(fnd_message.get);

1264: BEGIN
1265: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1266: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1267: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NumOfReceiptWithError');
1268: DisplayException(fnd_message.get);
1269: END;
1270:
1271: END NumOfReceiptWithError;
1272:

Line 1298: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1294:
1295: EXCEPTION
1296: WHEN OTHERS THEN
1297: BEGIN
1298: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1299: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1300: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NumOfReceiptWithWarning' );
1301: DisplayException(fnd_message.get);
1302: END;

Line 1299: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1295: EXCEPTION
1296: WHEN OTHERS THEN
1297: BEGIN
1298: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1299: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1300: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NumOfReceiptWithWarning' );
1301: DisplayException(fnd_message.get);
1302: END;
1303:

Line 1300: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NumOfReceiptWithWarning' );

1296: WHEN OTHERS THEN
1297: BEGIN
1298: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1299: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1300: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NumOfReceiptWithWarning' );
1301: DisplayException(fnd_message.get);
1302: END;
1303:
1304: END NumOfReceiptWithWarning;

Line 1301: DisplayException(fnd_message.get);

1297: BEGIN
1298: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1299: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1300: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NumOfReceiptWithWarning' );
1301: DisplayException(fnd_message.get);
1302: END;
1303:
1304: END NumOfReceiptWithWarning;
1305:

Line 1335: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1331: return V_NumOfValidReceipt;
1332: EXCEPTION
1333: WHEN OTHERS THEN
1334: BEGIN
1335: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1336: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1337: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NumOfValidReceipt');
1338: DisplayException(fnd_message.get);
1339: END;

Line 1336: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1332: EXCEPTION
1333: WHEN OTHERS THEN
1334: BEGIN
1335: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1336: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1337: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NumOfValidReceipt');
1338: DisplayException(fnd_message.get);
1339: END;
1340:

Line 1337: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NumOfValidReceipt');

1333: WHEN OTHERS THEN
1334: BEGIN
1335: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1336: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1337: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NumOfValidReceipt');
1338: DisplayException(fnd_message.get);
1339: END;
1340:
1341: END NumOfValidReceipt;

Line 1338: DisplayException(fnd_message.get);

1334: BEGIN
1335: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1336: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1337: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'NumOfValidReceipt');
1338: DisplayException(fnd_message.get);
1339: END;
1340:
1341: END NumOfValidReceipt;
1342:

Line 1366: fnd_message.set_encoded(P_MessageText);

1362: -- Added for NewUI
1363: -- Replaced P_MessageText with V_MessageText
1364:
1365:
1366: fnd_message.set_encoded(P_MessageText);
1367: V_MessageText := fnd_message.get();
1368: fnd_message.set_encoded(P_MessageText);
1369: fnd_msg_pub.add();
1370:

Line 1367: V_MessageText := fnd_message.get();

1363: -- Replaced P_MessageText with V_MessageText
1364:
1365:
1366: fnd_message.set_encoded(P_MessageText);
1367: V_MessageText := fnd_message.get();
1368: fnd_message.set_encoded(P_MessageText);
1369: fnd_msg_pub.add();
1370:
1371:

Line 1368: fnd_message.set_encoded(P_MessageText);

1364:
1365:
1366: fnd_message.set_encoded(P_MessageText);
1367: V_MessageText := fnd_message.get();
1368: fnd_message.set_encoded(P_MessageText);
1369: fnd_msg_pub.add();
1370:
1371:
1372: -- Append message fields

Line 1429: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1425: end if;
1426: EXCEPTION
1427: WHEN OTHERS THEN
1428: BEGIN
1429: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1430: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1431: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddMessage');
1432: DisplayException(fnd_message.get);
1433: END;

Line 1430: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1426: EXCEPTION
1427: WHEN OTHERS THEN
1428: BEGIN
1429: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1430: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1431: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddMessage');
1432: DisplayException(fnd_message.get);
1433: END;
1434:

Line 1431: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddMessage');

1427: WHEN OTHERS THEN
1428: BEGIN
1429: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1430: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1431: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddMessage');
1432: DisplayException(fnd_message.get);
1433: END;
1434:
1435: END AddMessage;

Line 1432: DisplayException(fnd_message.get);

1428: BEGIN
1429: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1430: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1431: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddMessage');
1432: DisplayException(fnd_message.get);
1433: END;
1434:
1435: END AddMessage;
1436:

Line 1494: fnd_message.set_encoded(l_text);

1490:
1491: -- Introduced the set_encoded() and fnd_msg_pub.add() for the newUI
1492:
1493: l_count := p_errors.COUNT + 1;
1494: fnd_message.set_encoded(l_text);
1495:
1496: if (p_IsMobileApp = true AND p_MessageCategory <> C_OtherMessageCategory) then
1497: if (p_MessageCategory = C_PAMessageCategory) then
1498: fnd_message.set_name('SQLAP', 'AP_OME_PA_ERROR');

Line 1498: fnd_message.set_name('SQLAP', 'AP_OME_PA_ERROR');

1494: fnd_message.set_encoded(l_text);
1495:
1496: if (p_IsMobileApp = true AND p_MessageCategory <> C_OtherMessageCategory) then
1497: if (p_MessageCategory = C_PAMessageCategory) then
1498: fnd_message.set_name('SQLAP', 'AP_OME_PA_ERROR');
1499: p_errors(l_count).text := fnd_message.get_encoded();
1500: l_text := p_errors(l_count).text;
1501: elsif (p_MessageCategory = C_PATCMessageCategory) then
1502: fnd_message.set_name('SQLAP', 'AP_OME_PATC_ERROR');

Line 1499: p_errors(l_count).text := fnd_message.get_encoded();

1495:
1496: if (p_IsMobileApp = true AND p_MessageCategory <> C_OtherMessageCategory) then
1497: if (p_MessageCategory = C_PAMessageCategory) then
1498: fnd_message.set_name('SQLAP', 'AP_OME_PA_ERROR');
1499: p_errors(l_count).text := fnd_message.get_encoded();
1500: l_text := p_errors(l_count).text;
1501: elsif (p_MessageCategory = C_PATCMessageCategory) then
1502: fnd_message.set_name('SQLAP', 'AP_OME_PATC_ERROR');
1503: p_errors(l_count).text := fnd_message.get_encoded();

Line 1502: fnd_message.set_name('SQLAP', 'AP_OME_PATC_ERROR');

1498: fnd_message.set_name('SQLAP', 'AP_OME_PA_ERROR');
1499: p_errors(l_count).text := fnd_message.get_encoded();
1500: l_text := p_errors(l_count).text;
1501: elsif (p_MessageCategory = C_PATCMessageCategory) then
1502: fnd_message.set_name('SQLAP', 'AP_OME_PATC_ERROR');
1503: p_errors(l_count).text := fnd_message.get_encoded();
1504: l_text := p_errors(l_count).text;
1505: elsif (p_MessageCategory = C_TaxMessageCategory) then
1506: fnd_message.set_name('SQLAP', 'AP_OME_TAX_ERROR');

Line 1503: p_errors(l_count).text := fnd_message.get_encoded();

1499: p_errors(l_count).text := fnd_message.get_encoded();
1500: l_text := p_errors(l_count).text;
1501: elsif (p_MessageCategory = C_PATCMessageCategory) then
1502: fnd_message.set_name('SQLAP', 'AP_OME_PATC_ERROR');
1503: p_errors(l_count).text := fnd_message.get_encoded();
1504: l_text := p_errors(l_count).text;
1505: elsif (p_MessageCategory = C_TaxMessageCategory) then
1506: fnd_message.set_name('SQLAP', 'AP_OME_TAX_ERROR');
1507: p_errors(l_count).text := fnd_message.get_encoded();

Line 1506: fnd_message.set_name('SQLAP', 'AP_OME_TAX_ERROR');

1502: fnd_message.set_name('SQLAP', 'AP_OME_PATC_ERROR');
1503: p_errors(l_count).text := fnd_message.get_encoded();
1504: l_text := p_errors(l_count).text;
1505: elsif (p_MessageCategory = C_TaxMessageCategory) then
1506: fnd_message.set_name('SQLAP', 'AP_OME_TAX_ERROR');
1507: p_errors(l_count).text := fnd_message.get_encoded();
1508: l_text := p_errors(l_count).text;
1509: elsif (p_MessageCategory = C_ItemizationMessageCategory) then
1510: fnd_message.set_name('SQLAP', 'AP_OME_ITEMIZATION_ERROR');

Line 1507: p_errors(l_count).text := fnd_message.get_encoded();

1503: p_errors(l_count).text := fnd_message.get_encoded();
1504: l_text := p_errors(l_count).text;
1505: elsif (p_MessageCategory = C_TaxMessageCategory) then
1506: fnd_message.set_name('SQLAP', 'AP_OME_TAX_ERROR');
1507: p_errors(l_count).text := fnd_message.get_encoded();
1508: l_text := p_errors(l_count).text;
1509: elsif (p_MessageCategory = C_ItemizationMessageCategory) then
1510: fnd_message.set_name('SQLAP', 'AP_OME_ITEMIZATION_ERROR');
1511: p_errors(l_count).text := fnd_message.get_encoded();

Line 1510: fnd_message.set_name('SQLAP', 'AP_OME_ITEMIZATION_ERROR');

1506: fnd_message.set_name('SQLAP', 'AP_OME_TAX_ERROR');
1507: p_errors(l_count).text := fnd_message.get_encoded();
1508: l_text := p_errors(l_count).text;
1509: elsif (p_MessageCategory = C_ItemizationMessageCategory) then
1510: fnd_message.set_name('SQLAP', 'AP_OME_ITEMIZATION_ERROR');
1511: p_errors(l_count).text := fnd_message.get_encoded();
1512: l_text := p_errors(l_count).text;
1513: elsif (p_MessageCategory = C_DFFMessageCategory) then
1514: fnd_message.set_name('SQLAP', 'AP_OME_DFF_ERROR');

Line 1511: p_errors(l_count).text := fnd_message.get_encoded();

1507: p_errors(l_count).text := fnd_message.get_encoded();
1508: l_text := p_errors(l_count).text;
1509: elsif (p_MessageCategory = C_ItemizationMessageCategory) then
1510: fnd_message.set_name('SQLAP', 'AP_OME_ITEMIZATION_ERROR');
1511: p_errors(l_count).text := fnd_message.get_encoded();
1512: l_text := p_errors(l_count).text;
1513: elsif (p_MessageCategory = C_DFFMessageCategory) then
1514: fnd_message.set_name('SQLAP', 'AP_OME_DFF_ERROR');
1515: p_errors(l_count).text := fnd_message.get_encoded();

Line 1514: fnd_message.set_name('SQLAP', 'AP_OME_DFF_ERROR');

1510: fnd_message.set_name('SQLAP', 'AP_OME_ITEMIZATION_ERROR');
1511: p_errors(l_count).text := fnd_message.get_encoded();
1512: l_text := p_errors(l_count).text;
1513: elsif (p_MessageCategory = C_DFFMessageCategory) then
1514: fnd_message.set_name('SQLAP', 'AP_OME_DFF_ERROR');
1515: p_errors(l_count).text := fnd_message.get_encoded();
1516: l_text := p_errors(l_count).text;
1517: end if;
1518: else

Line 1515: p_errors(l_count).text := fnd_message.get_encoded();

1511: p_errors(l_count).text := fnd_message.get_encoded();
1512: l_text := p_errors(l_count).text;
1513: elsif (p_MessageCategory = C_DFFMessageCategory) then
1514: fnd_message.set_name('SQLAP', 'AP_OME_DFF_ERROR');
1515: p_errors(l_count).text := fnd_message.get_encoded();
1516: l_text := p_errors(l_count).text;
1517: end if;
1518: else
1519: if (p_MessageCategory = C_PATCMessageCategory) then

Line 1520: fnd_message.set_name('SQLAP', 'OIE_PATC_MSG');

1516: l_text := p_errors(l_count).text;
1517: end if;
1518: else
1519: if (p_MessageCategory = C_PATCMessageCategory) then
1520: fnd_message.set_name('SQLAP', 'OIE_PATC_MSG');
1521: fnd_message.set_token('MESSAGE', p_text);
1522: l_text := fnd_message.get_encoded();
1523: p_errors(l_count).text := AP_WEB_DB_UTIL_PKG.jsPrepString(p_text);
1524: elsif (p_MessageCategory = C_GMSMessageCategory) then

Line 1521: fnd_message.set_token('MESSAGE', p_text);

1517: end if;
1518: else
1519: if (p_MessageCategory = C_PATCMessageCategory) then
1520: fnd_message.set_name('SQLAP', 'OIE_PATC_MSG');
1521: fnd_message.set_token('MESSAGE', p_text);
1522: l_text := fnd_message.get_encoded();
1523: p_errors(l_count).text := AP_WEB_DB_UTIL_PKG.jsPrepString(p_text);
1524: elsif (p_MessageCategory = C_GMSMessageCategory) then
1525: fnd_message.set_name('SQLAP', 'OIE_GMS_MSG');

Line 1522: l_text := fnd_message.get_encoded();

1518: else
1519: if (p_MessageCategory = C_PATCMessageCategory) then
1520: fnd_message.set_name('SQLAP', 'OIE_PATC_MSG');
1521: fnd_message.set_token('MESSAGE', p_text);
1522: l_text := fnd_message.get_encoded();
1523: p_errors(l_count).text := AP_WEB_DB_UTIL_PKG.jsPrepString(p_text);
1524: elsif (p_MessageCategory = C_GMSMessageCategory) then
1525: fnd_message.set_name('SQLAP', 'OIE_GMS_MSG');
1526: fnd_message.set_token('MESSAGE', p_text);

Line 1525: fnd_message.set_name('SQLAP', 'OIE_GMS_MSG');

1521: fnd_message.set_token('MESSAGE', p_text);
1522: l_text := fnd_message.get_encoded();
1523: p_errors(l_count).text := AP_WEB_DB_UTIL_PKG.jsPrepString(p_text);
1524: elsif (p_MessageCategory = C_GMSMessageCategory) then
1525: fnd_message.set_name('SQLAP', 'OIE_GMS_MSG');
1526: fnd_message.set_token('MESSAGE', p_text);
1527: l_text := fnd_message.get_encoded();
1528: p_errors(l_count).text := AP_WEB_DB_UTIL_PKG.jsPrepString(p_text);
1529: else

Line 1526: fnd_message.set_token('MESSAGE', p_text);

1522: l_text := fnd_message.get_encoded();
1523: p_errors(l_count).text := AP_WEB_DB_UTIL_PKG.jsPrepString(p_text);
1524: elsif (p_MessageCategory = C_GMSMessageCategory) then
1525: fnd_message.set_name('SQLAP', 'OIE_GMS_MSG');
1526: fnd_message.set_token('MESSAGE', p_text);
1527: l_text := fnd_message.get_encoded();
1528: p_errors(l_count).text := AP_WEB_DB_UTIL_PKG.jsPrepString(p_text);
1529: else
1530: p_errors(l_count).text := AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get());

Line 1527: l_text := fnd_message.get_encoded();

1523: p_errors(l_count).text := AP_WEB_DB_UTIL_PKG.jsPrepString(p_text);
1524: elsif (p_MessageCategory = C_GMSMessageCategory) then
1525: fnd_message.set_name('SQLAP', 'OIE_GMS_MSG');
1526: fnd_message.set_token('MESSAGE', p_text);
1527: l_text := fnd_message.get_encoded();
1528: p_errors(l_count).text := AP_WEB_DB_UTIL_PKG.jsPrepString(p_text);
1529: else
1530: p_errors(l_count).text := AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get());
1531: end if;

Line 1530: p_errors(l_count).text := AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get());

1526: fnd_message.set_token('MESSAGE', p_text);
1527: l_text := fnd_message.get_encoded();
1528: p_errors(l_count).text := AP_WEB_DB_UTIL_PKG.jsPrepString(p_text);
1529: else
1530: p_errors(l_count).text := AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get());
1531: end if;
1532: end if;
1533:
1534: p_errors(l_count).type := p_type;

Line 1537: fnd_message.set_encoded(l_text);

1533:
1534: p_errors(l_count).type := p_type;
1535: p_errors(l_count).field := p_field;
1536: p_errors(l_count).ind := p_index;
1537: fnd_message.set_encoded(l_text);
1538: fnd_msg_pub.add();
1539:
1540: END AddExpError;
1541:

Line 1560: fnd_message.set_name('SQLAP', 'OIE_NOT_ENCODED_MSG');

1556:
1557: BEGIN
1558:
1559: l_IsMobileApp := IsMobileApp;
1560: fnd_message.set_name('SQLAP', 'OIE_NOT_ENCODED_MSG');
1561: fnd_message.set_token('MESSAGE', p_text);
1562: AddExpError(p_errors,
1563: fnd_message.get_encoded(),
1564: p_type,

Line 1561: fnd_message.set_token('MESSAGE', p_text);

1557: BEGIN
1558:
1559: l_IsMobileApp := IsMobileApp;
1560: fnd_message.set_name('SQLAP', 'OIE_NOT_ENCODED_MSG');
1561: fnd_message.set_token('MESSAGE', p_text);
1562: AddExpError(p_errors,
1563: fnd_message.get_encoded(),
1564: p_type,
1565: p_field,

Line 1563: fnd_message.get_encoded(),

1559: l_IsMobileApp := IsMobileApp;
1560: fnd_message.set_name('SQLAP', 'OIE_NOT_ENCODED_MSG');
1561: fnd_message.set_token('MESSAGE', p_text);
1562: AddExpError(p_errors,
1563: fnd_message.get_encoded(),
1564: p_type,
1565: p_field,
1566: p_index,
1567: p_MessageCategory,

Line 1592: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1588:
1589: EXCEPTION
1590: WHEN OTHERS THEN
1591: BEGIN
1592: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1593: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1594: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PrintMessage');
1595: DisplayException(fnd_message.get);
1596: END;

Line 1593: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1589: EXCEPTION
1590: WHEN OTHERS THEN
1591: BEGIN
1592: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1593: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1594: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PrintMessage');
1595: DisplayException(fnd_message.get);
1596: END;
1597:

Line 1594: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PrintMessage');

1590: WHEN OTHERS THEN
1591: BEGIN
1592: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1593: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1594: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PrintMessage');
1595: DisplayException(fnd_message.get);
1596: END;
1597:
1598: END PrintMessages;

Line 1595: DisplayException(fnd_message.get);

1591: BEGIN
1592: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1593: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1594: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PrintMessage');
1595: DisplayException(fnd_message.get);
1596: END;
1597:
1598: END PrintMessages;
1599:

Line 1660: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1656: END LOOP;
1657: EXCEPTION
1658: WHEN OTHERS THEN
1659: BEGIN
1660: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1661: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1662: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MergeErrorStacks');
1663: DisplayException(fnd_message.get);
1664: END;

Line 1661: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1657: EXCEPTION
1658: WHEN OTHERS THEN
1659: BEGIN
1660: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1661: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1662: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MergeErrorStacks');
1663: DisplayException(fnd_message.get);
1664: END;
1665:

Line 1662: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MergeErrorStacks');

1658: WHEN OTHERS THEN
1659: BEGIN
1660: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1661: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1662: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MergeErrorStacks');
1663: DisplayException(fnd_message.get);
1664: END;
1665:
1666: END MergeErrorStacks;

Line 1663: DisplayException(fnd_message.get);

1659: BEGIN
1660: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1661: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1662: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MergeErrorStacks');
1663: DisplayException(fnd_message.get);
1664: END;
1665:
1666: END MergeErrorStacks;
1667:

Line 1712: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1708:
1709: EXCEPTION
1710: WHEN OTHERS THEN
1711: BEGIN
1712: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1713: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1714: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MergeErrors');
1715: DisplayException(fnd_message.get);
1716: END;

Line 1713: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1709: EXCEPTION
1710: WHEN OTHERS THEN
1711: BEGIN
1712: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1713: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1714: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MergeErrors');
1715: DisplayException(fnd_message.get);
1716: END;
1717:

Line 1714: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MergeErrors');

1710: WHEN OTHERS THEN
1711: BEGIN
1712: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1713: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1714: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MergeErrors');
1715: DisplayException(fnd_message.get);
1716: END;
1717:
1718: END MergeErrors;

Line 1715: DisplayException(fnd_message.get);

1711: BEGIN
1712: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1713: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1714: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MergeErrors');
1715: DisplayException(fnd_message.get);
1716: END;
1717:
1718: END MergeErrors;
1719:

Line 1748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1744: END LOOP;
1745: EXCEPTION
1746: WHEN OTHERS THEN
1747: BEGIN
1748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MergeExpErrors');
1751: DisplayException(fnd_message.get);
1752: END;

Line 1749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1745: EXCEPTION
1746: WHEN OTHERS THEN
1747: BEGIN
1748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MergeExpErrors');
1751: DisplayException(fnd_message.get);
1752: END;
1753:

Line 1750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MergeExpErrors');

1746: WHEN OTHERS THEN
1747: BEGIN
1748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MergeExpErrors');
1751: DisplayException(fnd_message.get);
1752: END;
1753:
1754: END MergeExpErrors;

Line 1751: DisplayException(fnd_message.get);

1747: BEGIN
1748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MergeExpErrors');
1751: DisplayException(fnd_message.get);
1752: END;
1753:
1754: END MergeExpErrors;
1755:

Line 1777: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1773: END LOOP;
1774: EXCEPTION
1775: WHEN OTHERS THEN
1776: BEGIN
1777: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1778: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1779: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ClearMessages');
1780: DisplayException(fnd_message.get);
1781: END;

Line 1778: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1774: EXCEPTION
1775: WHEN OTHERS THEN
1776: BEGIN
1777: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1778: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1779: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ClearMessages');
1780: DisplayException(fnd_message.get);
1781: END;
1782:

Line 1779: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ClearMessages');

1775: WHEN OTHERS THEN
1776: BEGIN
1777: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1778: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1779: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ClearMessages');
1780: DisplayException(fnd_message.get);
1781: END;
1782:
1783: END ClearMessages;

Line 1780: DisplayException(fnd_message.get);

1776: BEGIN
1777: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1778: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1779: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ClearMessages');
1780: DisplayException(fnd_message.get);
1781: END;
1782:
1783: END ClearMessages;
1784:

Line 1815: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1811: END LOOP;
1812: EXCEPTION
1813: WHEN OTHERS THEN
1814: BEGIN
1815: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1816: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1817: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CopyMessages');
1818: DisplayException(fnd_message.get);
1819: END;

Line 1816: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1812: EXCEPTION
1813: WHEN OTHERS THEN
1814: BEGIN
1815: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1816: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1817: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CopyMessages');
1818: DisplayException(fnd_message.get);
1819: END;
1820:

Line 1817: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CopyMessages');

1813: WHEN OTHERS THEN
1814: BEGIN
1815: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1816: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1817: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CopyMessages');
1818: DisplayException(fnd_message.get);
1819: END;
1820:
1821: END CopyMessages;

Line 1818: DisplayException(fnd_message.get);

1814: BEGIN
1815: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1816: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1817: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CopyMessages');
1818: DisplayException(fnd_message.get);
1819: END;
1820:
1821: END CopyMessages;
1822:

Line 1900: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1896:
1897: EXCEPTION
1898: WHEN OTHERS THEN
1899: BEGIN
1900: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1901: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1902: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifErrorFields');
1903: DisplayException(fnd_message.get);
1904: END;

Line 1901: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1897: EXCEPTION
1898: WHEN OTHERS THEN
1899: BEGIN
1900: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1901: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1902: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifErrorFields');
1903: DisplayException(fnd_message.get);
1904: END;
1905:

Line 1902: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifErrorFields');

1898: WHEN OTHERS THEN
1899: BEGIN
1900: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1901: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1902: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifErrorFields');
1903: DisplayException(fnd_message.get);
1904: END;
1905:
1906: END ArrayifyErrorFields;

Line 1903: DisplayException(fnd_message.get);

1899: BEGIN
1900: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1901: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1902: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifErrorFields');
1903: DisplayException(fnd_message.get);
1904: END;
1905:
1906: END ArrayifyErrorFields;
1907:

Line 1919: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1915:
1916: EXCEPTION
1917: WHEN OTHERS THEN
1918: BEGIN
1919: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1920: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1921: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifWarningFields');
1922: DisplayException(fnd_message.get);
1923: END;

Line 1920: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1916: EXCEPTION
1917: WHEN OTHERS THEN
1918: BEGIN
1919: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1920: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1921: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifWarningFields');
1922: DisplayException(fnd_message.get);
1923: END;
1924:

Line 1921: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifWarningFields');

1917: WHEN OTHERS THEN
1918: BEGIN
1919: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1920: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1921: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifWarningFields');
1922: DisplayException(fnd_message.get);
1923: END;
1924:
1925: END ArrayifyWarningFields;

Line 1922: DisplayException(fnd_message.get);

1918: BEGIN
1919: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1920: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1921: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifWarningFields');
1922: DisplayException(fnd_message.get);
1923: END;
1924:
1925: END ArrayifyWarningFields;
1926:

Line 1983: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1979:
1980: EXCEPTION
1981: WHEN OTHERS THEN
1982: BEGIN
1983: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1984: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifErrorText');
1986: DisplayException(fnd_message.get);
1987: END;

Line 1984: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1980: EXCEPTION
1981: WHEN OTHERS THEN
1982: BEGIN
1983: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1984: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifErrorText');
1986: DisplayException(fnd_message.get);
1987: END;
1988:

Line 1985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifErrorText');

1981: WHEN OTHERS THEN
1982: BEGIN
1983: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1984: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifErrorText');
1986: DisplayException(fnd_message.get);
1987: END;
1988:
1989: END ArrayifyErrorText;

Line 1986: DisplayException(fnd_message.get);

1982: BEGIN
1983: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1984: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifErrorText');
1986: DisplayException(fnd_message.get);
1987: END;
1988:
1989: END ArrayifyErrorText;
1990:

Line 2001: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1997:
1998: EXCEPTION
1999: WHEN OTHERS THEN
2000: BEGIN
2001: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2002: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2003: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifWarningText');
2004: DisplayException(fnd_message.get);
2005: END;

Line 2002: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1998: EXCEPTION
1999: WHEN OTHERS THEN
2000: BEGIN
2001: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2002: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2003: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifWarningText');
2004: DisplayException(fnd_message.get);
2005: END;
2006:

Line 2003: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifWarningText');

1999: WHEN OTHERS THEN
2000: BEGIN
2001: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2002: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2003: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifWarningText');
2004: DisplayException(fnd_message.get);
2005: END;
2006:
2007: END ArrayifyWarningText;

Line 2004: DisplayException(fnd_message.get);

2000: BEGIN
2001: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2002: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2003: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ArrayifWarningText');
2004: DisplayException(fnd_message.get);
2005: END;
2006:
2007: END ArrayifyWarningText;
2008:

Line 2051: debug_info := 'Getting FND Message';

2047: debug_info := 'Getting Date Format';
2048: l_date_format := icx_sec.getID( icx_sec.PV_DATE_FORMAT );
2049:
2050: -- l_date_format := AP_WEB_INFRASTRUCTURE_PKG.getDateFormat;
2051: debug_info := 'Getting FND Message';
2052: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_INVALID_DATE');
2053: debug_info := 'Setting FND Token';
2054: FND_MESSAGE.SET_TOKEN('format', l_date_format);
2055: debug_info := 'invalid date msg';

Line 2052: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_INVALID_DATE');

2048: l_date_format := icx_sec.getID( icx_sec.PV_DATE_FORMAT );
2049:
2050: -- l_date_format := AP_WEB_INFRASTRUCTURE_PKG.getDateFormat;
2051: debug_info := 'Getting FND Message';
2052: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_INVALID_DATE');
2053: debug_info := 'Setting FND Token';
2054: FND_MESSAGE.SET_TOKEN('format', l_date_format);
2055: debug_info := 'invalid date msg';
2056: l_invalid_date_msg :=

Line 2054: FND_MESSAGE.SET_TOKEN('format', l_date_format);

2050: -- l_date_format := AP_WEB_INFRASTRUCTURE_PKG.getDateFormat;
2051: debug_info := 'Getting FND Message';
2052: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_INVALID_DATE');
2053: debug_info := 'Setting FND Token';
2054: FND_MESSAGE.SET_TOKEN('format', l_date_format);
2055: debug_info := 'invalid date msg';
2056: l_invalid_date_msg :=
2057: AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get, TRUE);
2058: debug_info := 'date not allowed';

Line 2057: AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get, TRUE);

2053: debug_info := 'Setting FND Token';
2054: FND_MESSAGE.SET_TOKEN('format', l_date_format);
2055: debug_info := 'invalid date msg';
2056: l_invalid_date_msg :=
2057: AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get, TRUE);
2058: debug_info := 'date not allowed';
2059: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_DATE_NOT_ALLOWED');
2060: debug_info := 'date not allowed msg';
2061: l_date_not_allowed_msg :=

Line 2059: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_DATE_NOT_ALLOWED');

2055: debug_info := 'invalid date msg';
2056: l_invalid_date_msg :=
2057: AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get, TRUE);
2058: debug_info := 'date not allowed';
2059: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_DATE_NOT_ALLOWED');
2060: debug_info := 'date not allowed msg';
2061: l_date_not_allowed_msg :=
2062: AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get, TRUE);
2063: -- Get year string. RRRR

Line 2062: AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get, TRUE);

2058: debug_info := 'date not allowed';
2059: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_DATE_NOT_ALLOWED');
2060: debug_info := 'date not allowed msg';
2061: l_date_not_allowed_msg :=
2062: AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get, TRUE);
2063: -- Get year string. RRRR
2064: -- dtong added UPPER to ignore year's case
2065: l_index_y1 := instrb(UPPER(l_date_format), 'RRRR');
2066: if (l_index_y1 = 0) then

Line 2471: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

2467:
2468: EXCEPTION
2469: WHEN OTHERS THEN
2470: BEGIN
2471: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2472: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2473: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'convertDate');
2474: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2475: DisplayException(fnd_message.get);

Line 2472: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

2468: EXCEPTION
2469: WHEN OTHERS THEN
2470: BEGIN
2471: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2472: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2473: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'convertDate');
2474: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2475: DisplayException(fnd_message.get);
2476: END;

Line 2473: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'convertDate');

2469: WHEN OTHERS THEN
2470: BEGIN
2471: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2472: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2473: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'convertDate');
2474: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2475: DisplayException(fnd_message.get);
2476: END;
2477:

Line 2474: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

2470: BEGIN
2471: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2472: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2473: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'convertDate');
2474: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2475: DisplayException(fnd_message.get);
2476: END;
2477:
2478: END convertDate;

Line 2475: DisplayException(fnd_message.get);

2471: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2472: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2473: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'convertDate');
2474: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2475: DisplayException(fnd_message.get);
2476: END;
2477:
2478: END convertDate;
2479:

Line 2551: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

2547: }');
2548: EXCEPTION
2549: WHEN OTHERS THEN
2550: BEGIN
2551: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2552: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2553: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DetermineConversion');
2554: DisplayException(fnd_message.get);
2555: END;

Line 2552: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

2548: EXCEPTION
2549: WHEN OTHERS THEN
2550: BEGIN
2551: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2552: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2553: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DetermineConversion');
2554: DisplayException(fnd_message.get);
2555: END;
2556:

Line 2553: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DetermineConversion');

2549: WHEN OTHERS THEN
2550: BEGIN
2551: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2552: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2553: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DetermineConversion');
2554: DisplayException(fnd_message.get);
2555: END;
2556:
2557: END DetermineConversion;

Line 2554: DisplayException(fnd_message.get);

2550: BEGIN
2551: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2552: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2553: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DetermineConversion');
2554: DisplayException(fnd_message.get);
2555: END;
2556:
2557: END DetermineConversion;
2558:

Line 2595: fnd_message.set_name('SQLAP', 'AP_WEB_NUMBER_REQUIRED');

2591: ------------------
2592: l_message VARCHAR2(2000);
2593: BEGIN
2594:
2595: fnd_message.set_name('SQLAP', 'AP_WEB_NUMBER_REQUIRED');
2596: l_message := AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get, TRUE);
2597:
2598: htp.p('function isNum(str, showalert){
2599: var ch=str.substring(0,1);

Line 2596: l_message := AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get, TRUE);

2592: l_message VARCHAR2(2000);
2593: BEGIN
2594:
2595: fnd_message.set_name('SQLAP', 'AP_WEB_NUMBER_REQUIRED');
2596: l_message := AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get, TRUE);
2597:
2598: htp.p('function isNum(str, showalert){
2599: var ch=str.substring(0,1);
2600:

Line 2902: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

2898: return(l_temp);
2899: EXCEPTION
2900: WHEN OTHERS THEN
2901: BEGIN
2902: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2903: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2904: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RtrimMultiByteSpaces');
2905: DisplayException(fnd_message.get);
2906: END;

Line 2903: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

2899: EXCEPTION
2900: WHEN OTHERS THEN
2901: BEGIN
2902: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2903: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2904: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RtrimMultiByteSpaces');
2905: DisplayException(fnd_message.get);
2906: END;
2907: END;

Line 2904: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RtrimMultiByteSpaces');

2900: WHEN OTHERS THEN
2901: BEGIN
2902: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2903: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2904: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RtrimMultiByteSpaces');
2905: DisplayException(fnd_message.get);
2906: END;
2907: END;
2908:

Line 2905: DisplayException(fnd_message.get);

2901: BEGIN
2902: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2903: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2904: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RtrimMultiByteSpaces');
2905: DisplayException(fnd_message.get);
2906: END;
2907: END;
2908:
2909: ------------------------------------------------------------------------