230: 'end ValidateReportHeader');
231: exception
232: when others then
233: BEGIN
234: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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);
231: exception
232: when others then
233: BEGIN
234: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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;
232: when others then
233: BEGIN
234: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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;
234: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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:
698:
699: EXCEPTION
700: WHEN OTHERS THEN
701: BEGIN
702: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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);
699: EXCEPTION
700: WHEN OTHERS THEN
701: BEGIN
702: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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;
700: WHEN OTHERS THEN
701: BEGIN
702: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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;
702: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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:
823: WHERE REPORT_HEADER_ID = p_report_header_id
824: AND (itemization_parent_id is null OR itemization_parent_id <> -1);
825: EXCEPTION
826: WHEN OTHERS THEN
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;
824: AND (itemization_parent_id is null OR itemization_parent_id <> -1);
825: EXCEPTION
826: WHEN OTHERS THEN
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;
825: EXCEPTION
826: WHEN OTHERS THEN
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:
826: WHEN OTHERS THEN
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: ------------------------------------------------------------
871:
872: EXCEPTION
873: WHEN OTHERS THEN
874: IF (SQLCODE <> -20001) THEN
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;
872: EXCEPTION
873: WHEN OTHERS THEN
874: IF (SQLCODE <> -20001) THEN
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
873: WHEN OTHERS THEN
874: IF (SQLCODE <> -20001) THEN
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
874: IF (SQLCODE <> -20001) THEN
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:
879: APP_EXCEPTION.RAISE_EXCEPTION;
880: ELSE
881: -- bug 2203689: caught exception from StartExpenseReprotProcess
882:
883: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_WORKFLOW_ERROR');
884: FND_MESSAGE.SET_TOKEN('ERROR_NAME', wf_core.error_name);
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);
880: ELSE
881: -- bug 2203689: caught exception from StartExpenseReprotProcess
882:
883: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_WORKFLOW_ERROR');
884: FND_MESSAGE.SET_TOKEN('ERROR_NAME', wf_core.error_name);
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:
881: -- bug 2203689: caught exception from StartExpenseReprotProcess
882:
883: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_WORKFLOW_ERROR');
884: FND_MESSAGE.SET_TOKEN('ERROR_NAME', wf_core.error_name);
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
882:
883: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_WORKFLOW_ERROR');
884: FND_MESSAGE.SET_TOKEN('ERROR_NAME', wf_core.error_name);
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
883: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_WORKFLOW_ERROR');
884: FND_MESSAGE.SET_TOKEN('ERROR_NAME', wf_core.error_name);
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
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,
894: fnd_message.get_encoded(),
895: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
896:
897: fnd_msg_pub.count_and_get(p_count => p_msg_count,
898: p_data => l_msg_data);
1074: END IF;
1075: EXCEPTION
1076: WHEN OTHERS THEN
1077: BEGIN
1078: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1079: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetUserID');
1081: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1082: END;
1075: EXCEPTION
1076: WHEN OTHERS THEN
1077: BEGIN
1078: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1079: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetUserID');
1081: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1082: END;
1083:
1076: WHEN OTHERS THEN
1077: BEGIN
1078: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1079: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetUserID');
1081: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1082: END;
1083:
1084:
1077: BEGIN
1078: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1079: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetUserID');
1081: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1082: END;
1083:
1084:
1085: END GetUserID;
1113: 'end WithdrawExpenseReport');
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: IF (SQLCODE <> -20001) THEN
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;
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: IF (SQLCODE <> -20001) THEN
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
1115: WHEN OTHERS THEN
1116: IF (SQLCODE <> -20001) THEN
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
1116: IF (SQLCODE <> -20001) THEN
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
1478:
1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: BEGIN
1482: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1483: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1484: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updateExpensedAmount');
1485: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1486: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: BEGIN
1482: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1483: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1484: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updateExpensedAmount');
1485: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1486: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1487: END;
1480: WHEN OTHERS THEN
1481: BEGIN
1482: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1483: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1484: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updateExpensedAmount');
1485: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1486: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1487: END;
1488: END updateExpensedAmount;
1481: BEGIN
1482: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1483: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1484: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updateExpensedAmount');
1485: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1486: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1487: END;
1488: END updateExpensedAmount;
1489:
1482: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1483: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1484: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updateExpensedAmount');
1485: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1486: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1487: END;
1488: END updateExpensedAmount;
1489:
1490: /*
1551:
1552: EXCEPTION
1553: WHEN OTHERS THEN
1554: BEGIN
1555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1556: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1557: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updChargesFromDeletedReport');
1558: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1559: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1552: EXCEPTION
1553: WHEN OTHERS THEN
1554: BEGIN
1555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1556: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1557: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updChargesFromDeletedReport');
1558: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1559: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1560: END;
1553: WHEN OTHERS THEN
1554: BEGIN
1555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1556: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1557: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updChargesFromDeletedReport');
1558: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1559: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1560: END;
1561: END updChargesFromDeletedReport;
1554: BEGIN
1555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1556: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1557: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updChargesFromDeletedReport');
1558: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1559: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1560: END;
1561: END updChargesFromDeletedReport;
1562:
1555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1556: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1557: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updChargesFromDeletedReport');
1558: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1559: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1560: END;
1561: END updChargesFromDeletedReport;
1562:
1563: PROCEDURE DeleteReport(