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:
696:
697: EXCEPTION
698: WHEN OTHERS THEN
699: BEGIN
700: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
701: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
703: current_calling_sequence);
704: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
697: EXCEPTION
698: WHEN OTHERS THEN
699: BEGIN
700: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
701: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
703: current_calling_sequence);
704: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
705: APP_EXCEPTION.RAISE_EXCEPTION;
698: WHEN OTHERS THEN
699: BEGIN
700: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
701: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
703: current_calling_sequence);
704: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
705: APP_EXCEPTION.RAISE_EXCEPTION;
706: END;
700: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
701: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
703: current_calling_sequence);
704: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
705: APP_EXCEPTION.RAISE_EXCEPTION;
706: END;
707: END ValidateReceiptLine;
708:
821: WHERE REPORT_HEADER_ID = p_report_header_id
822: AND (itemization_parent_id is null OR itemization_parent_id <> -1);
823: EXCEPTION
824: WHEN OTHERS THEN
825: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
826: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
827: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'OASubmitWorkflow');
828: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
829: APP_EXCEPTION.RAISE_EXCEPTION;
822: AND (itemization_parent_id is null OR itemization_parent_id <> -1);
823: EXCEPTION
824: WHEN OTHERS THEN
825: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
826: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
827: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'OASubmitWorkflow');
828: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
829: APP_EXCEPTION.RAISE_EXCEPTION;
830: END;
823: EXCEPTION
824: WHEN OTHERS THEN
825: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
826: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
827: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'OASubmitWorkflow');
828: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
829: APP_EXCEPTION.RAISE_EXCEPTION;
830: END;
831:
824: WHEN OTHERS THEN
825: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
826: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
827: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'OASubmitWorkflow');
828: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
829: APP_EXCEPTION.RAISE_EXCEPTION;
830: END;
831:
832: ------------------------------------------------------------
869:
870: EXCEPTION
871: WHEN OTHERS THEN
872: IF (SQLCODE <> -20001) THEN
873: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
874: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
875: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'OASubmitWorkflow');
876: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
877: APP_EXCEPTION.RAISE_EXCEPTION;
870: EXCEPTION
871: WHEN OTHERS THEN
872: IF (SQLCODE <> -20001) THEN
873: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
874: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
875: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'OASubmitWorkflow');
876: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
877: APP_EXCEPTION.RAISE_EXCEPTION;
878: ELSE
871: WHEN OTHERS THEN
872: IF (SQLCODE <> -20001) THEN
873: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
874: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
875: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'OASubmitWorkflow');
876: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
877: APP_EXCEPTION.RAISE_EXCEPTION;
878: ELSE
879: -- bug 2203689: caught exception from StartExpenseReprotProcess
872: IF (SQLCODE <> -20001) THEN
873: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
874: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
875: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'OASubmitWorkflow');
876: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
877: APP_EXCEPTION.RAISE_EXCEPTION;
878: ELSE
879: -- bug 2203689: caught exception from StartExpenseReprotProcess
880:
877: APP_EXCEPTION.RAISE_EXCEPTION;
878: ELSE
879: -- bug 2203689: caught exception from StartExpenseReprotProcess
880:
881: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_WORKFLOW_ERROR');
882: FND_MESSAGE.SET_TOKEN('ERROR_NAME', wf_core.error_name);
883: FND_MESSAGE.SET_TOKEN('ERROR_NUMBER', wf_core.error_number);
884: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', wf_core.error_message);
885: FND_MESSAGE.SET_TOKEN('ERROR_STACK', wf_core.error_stack);
878: ELSE
879: -- bug 2203689: caught exception from StartExpenseReprotProcess
880:
881: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_WORKFLOW_ERROR');
882: FND_MESSAGE.SET_TOKEN('ERROR_NAME', wf_core.error_name);
883: FND_MESSAGE.SET_TOKEN('ERROR_NUMBER', wf_core.error_number);
884: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', wf_core.error_message);
885: FND_MESSAGE.SET_TOKEN('ERROR_STACK', wf_core.error_stack);
886:
879: -- bug 2203689: caught exception from StartExpenseReprotProcess
880:
881: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_WORKFLOW_ERROR');
882: FND_MESSAGE.SET_TOKEN('ERROR_NAME', wf_core.error_name);
883: FND_MESSAGE.SET_TOKEN('ERROR_NUMBER', wf_core.error_number);
884: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', wf_core.error_message);
885: FND_MESSAGE.SET_TOKEN('ERROR_STACK', wf_core.error_stack);
886:
887: -- APP_EXCEPTION.RAISE_EXCEPTION can only display error message with less than
880:
881: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_WORKFLOW_ERROR');
882: FND_MESSAGE.SET_TOKEN('ERROR_NAME', wf_core.error_name);
883: FND_MESSAGE.SET_TOKEN('ERROR_NUMBER', wf_core.error_number);
884: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', wf_core.error_message);
885: FND_MESSAGE.SET_TOKEN('ERROR_STACK', wf_core.error_stack);
886:
887: -- APP_EXCEPTION.RAISE_EXCEPTION can only display error message with less than
888: -- 512 characters. In order to display the compelte workflow information for bug
881: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_WORKFLOW_ERROR');
882: FND_MESSAGE.SET_TOKEN('ERROR_NAME', wf_core.error_name);
883: FND_MESSAGE.SET_TOKEN('ERROR_NUMBER', wf_core.error_number);
884: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', wf_core.error_message);
885: FND_MESSAGE.SET_TOKEN('ERROR_STACK', wf_core.error_stack);
886:
887: -- APP_EXCEPTION.RAISE_EXCEPTION can only display error message with less than
888: -- 512 characters. In order to display the compelte workflow information for bug
889: -- 2203689, call addExpError and checkErrors to get message from error stack
888: -- 512 characters. In order to display the compelte workflow information for bug
889: -- 2203689, call addExpError and checkErrors to get message from error stack
890:
891: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
892: fnd_message.get_encoded(),
893: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
894:
895: fnd_msg_pub.count_and_get(p_count => p_msg_count,
896: p_data => l_msg_data);
1072: END IF;
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', 'GetUserID');
1079: AP_WEB_UTILITIES_PKG.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', 'GetUserID');
1079: AP_WEB_UTILITIES_PKG.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', 'GetUserID');
1079: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1080: END;
1081:
1082:
1075: BEGIN
1076: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1077: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1078: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetUserID');
1079: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1080: END;
1081:
1082:
1083: END GetUserID;
1111: 'end WithdrawExpenseReport');
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: IF (SQLCODE <> -20001) THEN
1115: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1116: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1117: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'WithdrawExpenseReport');
1118: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1119: APP_EXCEPTION.RAISE_EXCEPTION;
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: IF (SQLCODE <> -20001) THEN
1115: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1116: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1117: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'WithdrawExpenseReport');
1118: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1119: APP_EXCEPTION.RAISE_EXCEPTION;
1120: ELSE
1113: WHEN OTHERS THEN
1114: IF (SQLCODE <> -20001) THEN
1115: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1116: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1117: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'WithdrawExpenseReport');
1118: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1119: APP_EXCEPTION.RAISE_EXCEPTION;
1120: ELSE
1121: -- Do not need to set the token since it has been done in the
1114: IF (SQLCODE <> -20001) THEN
1115: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1116: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1117: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'WithdrawExpenseReport');
1118: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1119: APP_EXCEPTION.RAISE_EXCEPTION;
1120: ELSE
1121: -- Do not need to set the token since it has been done in the
1122: -- child process
1476:
1477: EXCEPTION
1478: WHEN OTHERS THEN
1479: BEGIN
1480: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1481: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1482: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updateExpensedAmount');
1483: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1484: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1477: EXCEPTION
1478: WHEN OTHERS THEN
1479: BEGIN
1480: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1481: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1482: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updateExpensedAmount');
1483: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1484: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1485: END;
1478: WHEN OTHERS THEN
1479: BEGIN
1480: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1481: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1482: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updateExpensedAmount');
1483: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1484: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1485: END;
1486: END updateExpensedAmount;
1479: BEGIN
1480: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1481: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1482: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updateExpensedAmount');
1483: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1484: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1485: END;
1486: END updateExpensedAmount;
1487:
1480: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1481: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1482: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updateExpensedAmount');
1483: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1484: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1485: END;
1486: END updateExpensedAmount;
1487:
1488: /*
1549:
1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: BEGIN
1553: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1554: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1555: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updChargesFromDeletedReport');
1556: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1557: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: BEGIN
1553: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1554: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1555: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updChargesFromDeletedReport');
1556: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1557: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1558: END;
1551: WHEN OTHERS THEN
1552: BEGIN
1553: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1554: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1555: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updChargesFromDeletedReport');
1556: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1557: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1558: END;
1559: END updChargesFromDeletedReport;
1552: BEGIN
1553: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1554: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1555: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updChargesFromDeletedReport');
1556: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1557: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1558: END;
1559: END updChargesFromDeletedReport;
1560:
1553: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1554: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1555: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updChargesFromDeletedReport');
1556: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1557: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1558: END;
1559: END updChargesFromDeletedReport;
1560:
1561: PROCEDURE DeleteReport(