21: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
22: 'end DeleteExpenseReport');
23: EXCEPTION
24: WHEN OTHERS THEN
25: APP_EXCEPTION.RAISE_EXCEPTION;
26:
27: END DeleteExpenseReport;
28:
29: PROCEDURE GetEmployeeIdFromBothPayParent(p_bothpay_parent_id IN NUMBER,
235: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
236: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
237: current_calling_sequence);
238: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
239: APP_EXCEPTION.RAISE_EXCEPTION;
240: END;
241: END ValidateReportHeader;
242:
243:
703: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
704: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
705: current_calling_sequence);
706: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
707: APP_EXCEPTION.RAISE_EXCEPTION;
708: END;
709: END ValidateReceiptLine;
710:
711:
827: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
828: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
829: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'OASubmitWorkflow');
830: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
831: APP_EXCEPTION.RAISE_EXCEPTION;
832: END;
833:
834: ------------------------------------------------------------
835: l_debug_info := 'Starting workflow process';
875: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
876: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
877: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'OASubmitWorkflow');
878: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
879: APP_EXCEPTION.RAISE_EXCEPTION;
880: ELSE
881: -- bug 2203689: caught exception from StartExpenseReprotProcess
882:
883: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_WORKFLOW_ERROR');
885: FND_MESSAGE.SET_TOKEN('ERROR_NUMBER', wf_core.error_number);
886: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', wf_core.error_message);
887: FND_MESSAGE.SET_TOKEN('ERROR_STACK', wf_core.error_stack);
888:
889: -- APP_EXCEPTION.RAISE_EXCEPTION can only display error message with less than
890: -- 512 characters. In order to display the compelte workflow information for bug
891: -- 2203689, call addExpError and checkErrors to get message from error stack
892:
893: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
1117: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1118: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'WithdrawExpenseReport');
1120: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1121: APP_EXCEPTION.RAISE_EXCEPTION;
1122: ELSE
1123: -- Do not need to set the token since it has been done in the
1124: -- child process
1125: RAISE;
1158: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
1159: 'end GetFunctionalCurrencyInfo ');
1160: EXCEPTION
1161: WHEN OTHERS THEN
1162: APP_EXCEPTION.RAISE_EXCEPTION;
1163:
1164: END GetFunctionalCurrencyInfo;
1165:
1166:
1620: COMMIT;
1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: ROLLBACK;
1624: APP_EXCEPTION.RAISE_EXCEPTION;
1625: END DeleteReport;
1626:
1627:
1628: