8: begin
9: null;
10: EXCEPTION
11: WHEN OTHERS THEN
12: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
13: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','ICXAdminSig_helpWinScript');
15: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
16: APP_EXCEPTION.RAISE_EXCEPTION;
9: null;
10: EXCEPTION
11: WHEN OTHERS THEN
12: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
13: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','ICXAdminSig_helpWinScript');
15: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
16: APP_EXCEPTION.RAISE_EXCEPTION;
17:
10: EXCEPTION
11: WHEN OTHERS THEN
12: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
13: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','ICXAdminSig_helpWinScript');
15: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
16: APP_EXCEPTION.RAISE_EXCEPTION;
17:
18: END ICXAdminSig_helpWinScript;
11: WHEN OTHERS THEN
12: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
13: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','ICXAdminSig_helpWinScript');
15: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
16: APP_EXCEPTION.RAISE_EXCEPTION;
17:
18: END ICXAdminSig_helpWinScript;
19:
25: BEGIN
26: null;
27: EXCEPTION
28: WHEN OTHERS THEN
29: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
30: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
31: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.SetUpClientInfo');
32: APP_EXCEPTION.RAISE_EXCEPTION;
33:
26: null;
27: EXCEPTION
28: WHEN OTHERS THEN
29: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
30: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
31: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.SetUpClientInfo');
32: APP_EXCEPTION.RAISE_EXCEPTION;
33:
34: END SetUpClientInfo;
27: EXCEPTION
28: WHEN OTHERS THEN
29: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
30: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
31: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.SetUpClientInfo');
32: APP_EXCEPTION.RAISE_EXCEPTION;
33:
34: END SetUpClientInfo;
35:
62: return FND_DATE.string_to_date(p_string, p_mask);
63:
64: EXCEPTION
65: WHEN OTHERS THEN
66: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
67: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
68: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.string_to_date');
69: APP_EXCEPTION.RAISE_EXCEPTION;
70: END string_to_date;
63:
64: EXCEPTION
65: WHEN OTHERS THEN
66: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
67: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
68: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.string_to_date');
69: APP_EXCEPTION.RAISE_EXCEPTION;
70: END string_to_date;
71:
64: EXCEPTION
65: WHEN OTHERS THEN
66: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
67: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
68: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.string_to_date');
69: APP_EXCEPTION.RAISE_EXCEPTION;
70: END string_to_date;
71:
72:
89: null;
90:
91: EXCEPTION
92: WHEN OTHERS THEN
93: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
94: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
95: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.GenTaxFunctions');
96: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
97: APP_EXCEPTION.RAISE_EXCEPTION;
90:
91: EXCEPTION
92: WHEN OTHERS THEN
93: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
94: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
95: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.GenTaxFunctions');
96: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
97: APP_EXCEPTION.RAISE_EXCEPTION;
98:
91: EXCEPTION
92: WHEN OTHERS THEN
93: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
94: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
95: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.GenTaxFunctions');
96: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
97: APP_EXCEPTION.RAISE_EXCEPTION;
98:
99: END GenTaxFunctions;
92: WHEN OTHERS THEN
93: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
94: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
95: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.GenTaxFunctions');
96: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
97: APP_EXCEPTION.RAISE_EXCEPTION;
98:
99: END GenTaxFunctions;
100:
192: */
193:
194: EXCEPTION
195: WHEN OTHERS THEN
196: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
197: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
198: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.insert_dist');
199: APP_EXCEPTION.RAISE_EXCEPTION;
200:
193:
194: EXCEPTION
195: WHEN OTHERS THEN
196: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
197: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
198: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.insert_dist');
199: APP_EXCEPTION.RAISE_EXCEPTION;
200:
201: END insert_dist;
194: EXCEPTION
195: WHEN OTHERS THEN
196: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
197: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
198: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.insert_dist');
199: APP_EXCEPTION.RAISE_EXCEPTION;
200:
201: END insert_dist;
202:
304:
305: EXCEPTION
306: WHEN OTHERS THEN
307: BEGIN
308: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
309: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
310: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ValidatePATransaction');
311: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
312: END;
305: EXCEPTION
306: WHEN OTHERS THEN
307: BEGIN
308: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
309: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
310: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ValidatePATransaction');
311: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
312: END;
313: END ValidatePATransaction;
306: WHEN OTHERS THEN
307: BEGIN
308: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
309: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
310: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ValidatePATransaction');
311: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
312: END;
313: END ValidatePATransaction;
314:
307: BEGIN
308: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
309: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
310: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ValidatePATransaction');
311: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
312: END;
313: END ValidatePATransaction;
314:
315: ---------------------------------------------------------------------
355:
356: EXCEPTION
357: WHEN OTHERS THEN
358: BEGIN
359: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
360: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
361: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'HaveAMEReCreateApprovalChain');
362: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
363: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
356: EXCEPTION
357: WHEN OTHERS THEN
358: BEGIN
359: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
360: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
361: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'HaveAMEReCreateApprovalChain');
362: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
363: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
364: END;
357: WHEN OTHERS THEN
358: BEGIN
359: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
360: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
361: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'HaveAMEReCreateApprovalChain');
362: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
363: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
364: END;
365: END HaveAMEReCreateApprovalChain;
358: BEGIN
359: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
360: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
361: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'HaveAMEReCreateApprovalChain');
362: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
363: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
364: END;
365: END HaveAMEReCreateApprovalChain;
366:
359: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
360: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
361: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'HaveAMEReCreateApprovalChain');
362: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
363: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
364: END;
365: END HaveAMEReCreateApprovalChain;
366:
367: ---------------------------------------------------------------------
406:
407: EXCEPTION
408: WHEN OTHERS THEN
409: BEGIN
410: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
411: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
412: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SetRejectStatusInAME');
413: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
414: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
407: EXCEPTION
408: WHEN OTHERS THEN
409: BEGIN
410: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
411: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
412: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SetRejectStatusInAME');
413: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
414: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
415: END;
408: WHEN OTHERS THEN
409: BEGIN
410: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
411: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
412: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SetRejectStatusInAME');
413: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
414: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
415: END;
416: END SetRejectStatusInAME;
409: BEGIN
410: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
411: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
412: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SetRejectStatusInAME');
413: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
414: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
415: END;
416: END SetRejectStatusInAME;
417:
410: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
411: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
412: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SetRejectStatusInAME');
413: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
414: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
415: END;
416: END SetRejectStatusInAME;
417:
418: ---------------------------------------------------------------------
509:
510: EXCEPTION
511: WHEN OTHERS THEN
512: BEGIN
513: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
515: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SetRejectStatusInAME');
516: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
517: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
510: EXCEPTION
511: WHEN OTHERS THEN
512: BEGIN
513: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
515: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SetRejectStatusInAME');
516: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
517: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
518: END;
511: WHEN OTHERS THEN
512: BEGIN
513: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
515: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SetRejectStatusInAME');
516: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
517: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
518: END;
519: END SetForwardInfoInAME;
512: BEGIN
513: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
515: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SetRejectStatusInAME');
516: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
517: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
518: END;
519: END SetForwardInfoInAME;
520:
513: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
515: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SetRejectStatusInAME');
516: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
517: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
518: END;
519: END SetForwardInfoInAME;
520:
521:
531:
532:
533: EXCEPTION
534: WHEN OTHERS THEN
535: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
536: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
537: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.isPopList');
538: APP_EXCEPTION.RAISE_EXCEPTION;
539:
532:
533: EXCEPTION
534: WHEN OTHERS THEN
535: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
536: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
537: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.isPopList');
538: APP_EXCEPTION.RAISE_EXCEPTION;
539:
540: END isPopList;
533: EXCEPTION
534: WHEN OTHERS THEN
535: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
536: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
537: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.isPopList');
538: APP_EXCEPTION.RAISE_EXCEPTION;
539:
540: END isPopList;
541: