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;
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;
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:
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;
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;
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:
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:
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('
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
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;
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:
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;
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;
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:
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;
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:
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;
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:
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;
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:
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;
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('
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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:
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;
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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:
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:
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
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;
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:
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;
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:
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');
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');
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();
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');
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();
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');
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();
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');
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();
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
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
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
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');
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);
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
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());
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;
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;
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:
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,
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,
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,
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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';
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 :=
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';
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 :=
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
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
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);
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;
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:
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;
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:
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;
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:
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;
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:
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);
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:
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;
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;
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:
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: ------------------------------------------------------------------------