DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on APP_EXCEPTION

Line 915: APP_EXCEPTION.RAISE_EXCEPTION;

911: END IF;
912:
913: -- always raise exceptions regardless it from StartExpenseReportProcess
914: -- or other callees
915: APP_EXCEPTION.RAISE_EXCEPTION;
916:
917: END StartExpenseReportProcess;
918:
919:

Line 999: APP_EXCEPTION.RAISE_EXCEPTION;

995: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
996: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GenTableHeader');
997: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
998: END IF;
999: APP_EXCEPTION.RAISE_EXCEPTION;
1000:
1001: END GenTableHeader;
1002:
1003: ---------------------------------------------------------

Line 1154: APP_EXCEPTION.RAISE_EXCEPTION;

1150: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1151: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GenTableRows');
1152: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1153: END IF;
1154: APP_EXCEPTION.RAISE_EXCEPTION;
1155:
1156: END GenTableRows;
1157:
1158: BEGIN

Line 1734: APP_EXCEPTION.RAISE_EXCEPTION;

1730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToWFSSError');
1732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_exceed_error_msg);
1733: END IF;
1734: APP_EXCEPTION.RAISE_EXCEPTION;
1735:
1736: END AddToWFSSError;
1737:
1738: ----------------------------------------------------------------------

Line 1792: APP_EXCEPTION.RAISE_EXCEPTION;

1788: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1789: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToHeaderErrors');
1790: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1791: END IF;
1792: APP_EXCEPTION.RAISE_EXCEPTION;
1793:
1794: END AddToHeaderErrors;
1795:
1796:

Line 1861: APP_EXCEPTION.RAISE_EXCEPTION;

1857: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1858: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'HandleInvalidDistCCID');
1859: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1860: END IF;
1861: APP_EXCEPTION.RAISE_EXCEPTION;
1862: END HandleInvalidDistCCID;
1863:
1864:
1865: ----------------------------------------------------------------------

Line 2658: APP_EXCEPTION.RAISE_EXCEPTION;

2654: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2655: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DoAPValidation');
2656: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2657: END IF;
2658: APP_EXCEPTION.RAISE_EXCEPTION;
2659: END DoAPValidation;
2660:
2661: -------------------------------------
2662: PROCEDURE OpenExp(p1 varchar2,

Line 4239: APP_EXCEPTION.RAISE_EXCEPTION;

4235: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4236: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MissingReceiptShortPay');
4237: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4238: END IF;
4239: APP_EXCEPTION.RAISE_EXCEPTION;
4240: END MissingReceiptShortPay;
4241:
4242: -----------------------------------------------------------------------------
4243: PROCEDURE PolicyViolationShortPay(p_item_type IN VARCHAR2,

Line 4288: APP_EXCEPTION.RAISE_EXCEPTION;

4284: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4285: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PolicyViolationShortPay');
4286: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4287: END IF;
4288: APP_EXCEPTION.RAISE_EXCEPTION;
4289: END PolicyViolationShortPay;
4290:
4291: -----------------------------------------------------------------------------
4292: FUNCTION GetNewShortPayDocumentNum(p_last_document_num IN VARCHAR2) RETURN VARCHAR2 IS

Line 5041: APP_EXCEPTION.RAISE_EXCEPTION;

5037: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5038: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DeleteExpReportFromAPTables');
5039: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5040: END IF;
5041: APP_EXCEPTION.RAISE_EXCEPTION;
5042: END DeleteExpReportFromAPTables;
5043:
5044: ---------------------------------------------------
5045: PROCEDURE ResetAttrValues(p_item_type IN VARCHAR2,

Line 5357: APP_EXCEPTION.RAISE_EXCEPTION;

5353:
5354: EXCEPTION
5355: WHEN OTHERS THEN
5356: ROLLBACK;
5357: APP_EXCEPTION.RAISE_EXCEPTION;
5358: END ResetCCardTxns;
5359:
5360: PROCEDURE AMEAbortRequestApprovals(
5361: p_rep_header_id IN AP_WEB_DB_EXPLINE_PKG.expLines_headerID,

Line 10807: app_exception.raise_exception;

10803: --Bug 2742114:raise exception when preparer id and trasferee is same.
10804:
10805: IF l_preparer_id = l_TransferToID THEN
10806: FND_MESSAGE.SET_NAME('SQLAP','OIE_TRANSFEREE_CANTBE_PREPARER');
10807: app_exception.raise_exception;
10808:
10809: ELSIF ((l_preparer_id <> l_employee_id) and (l_employee_id = l_TransferToID)) THEN
10810: FND_MESSAGE.SET_NAME('SQLAP','OIE_TRANSFEREE_CANTBE_EMPLOYEE');
10811: app_exception.raise_exception;

Line 10811: app_exception.raise_exception;

10807: app_exception.raise_exception;
10808:
10809: ELSIF ((l_preparer_id <> l_employee_id) and (l_employee_id = l_TransferToID)) THEN
10810: FND_MESSAGE.SET_NAME('SQLAP','OIE_TRANSFEREE_CANTBE_EMPLOYEE');
10811: app_exception.raise_exception;
10812: END IF;
10813:
10814:
10815: ----------------------------------------------------------

Line 11949: APP_EXCEPTION.RAISE_EXCEPTION;

11945:
11946: EXCEPTION
11947: WHEN OTHERS THEN
11948: ROLLBACK;
11949: APP_EXCEPTION.RAISE_EXCEPTION;
11950: END WithdrawExpenseRep;
11951:
11952:
11953: PROCEDURE GenerateExpClobLines(document_id IN VARCHAR2,

Line 13045: APP_EXCEPTION.RAISE_EXCEPTION;

13041:
13042: EXCEPTION
13043: WHEN OTHERS THEN
13044: AP_WEB_DB_UTIL_PKG.RaiseException('determineMileageAdjusted');
13045: APP_EXCEPTION.RAISE_EXCEPTION;
13046: END determineMileageAdjusted;
13047:
13048:
13049:

Line 13237: APP_EXCEPTION.RAISE_EXCEPTION;

13233: EXCEPTION
13234: WHEN OTHERS THEN
13235: AP_WEB_DB_UTIL_PKG.RaiseException('getScheduleLineArray',
13236: l_debug_info);
13237: APP_EXCEPTION.RAISE_EXCEPTION;
13238: END getScheduleLineArray;
13239:
13240:
13241: -------------------------------------------------------------------------------

Line 13290: APP_EXCEPTION.RAISE_EXCEPTION;

13286:
13287: EXCEPTION
13288: WHEN OTHERS THEN
13289: AP_WEB_DB_UTIL_PKG.RaiseException('updateCumulativeMileage');
13290: APP_EXCEPTION.RAISE_EXCEPTION;
13291: END updateCumulativeMileage;
13292:
13293:
13294: FUNCTION getAddonMileageRatesSum(p_report_header_id IN NUMBER,

Line 13400: APP_EXCEPTION.RAISE_EXCEPTION;

13396: WHEN NO_DATA_FOUND THEN
13397: return 0;
13398: WHEN OTHERS THEN
13399: AP_WEB_DB_UTIL_PKG.RaiseException('getRate');
13400: APP_EXCEPTION.RAISE_EXCEPTION;
13401: return 0;
13402: END getRate;
13403:
13404:

Line 13434: APP_EXCEPTION.RAISE_EXCEPTION;

13430:
13431: EXCEPTION
13432: WHEN OTHERS THEN
13433: AP_WEB_DB_UTIL_PKG.RaiseException('copyMileageArray');
13434: APP_EXCEPTION.RAISE_EXCEPTION;
13435: END copyMileageArray;
13436:
13437:
13438: -------------------------------------------------------------------------------

Line 13472: APP_EXCEPTION.RAISE_EXCEPTION;

13468:
13469: EXCEPTION
13470: WHEN OTHERS THEN
13471: AP_WEB_DB_UTIL_PKG.RaiseException('addToMileageArray');
13472: APP_EXCEPTION.RAISE_EXCEPTION;
13473: END addToMileageArray;
13474:
13475: -------------------------------------------------------------------------------
13476: PROCEDURE updateNewDistNumber(

Line 13505: APP_EXCEPTION.RAISE_EXCEPTION;

13501:
13502: EXCEPTION
13503: WHEN OTHERS THEN
13504: AP_WEB_DB_UTIL_PKG.RaiseException('updateNewDistNumber');
13505: APP_EXCEPTION.RAISE_EXCEPTION;
13506: END updateNewDistNumber;
13507:
13508: --------------------------------------------------------------------------------
13509: PROCEDURE processCrossThreshold(

Line 13741: APP_EXCEPTION.RAISE_EXCEPTION;

13737:
13738: EXCEPTION
13739: WHEN NO_DATA_FOUND THEN
13740: AP_WEB_DB_UTIL_PKG.RaiseException('No Data found: processCrossThreshold');
13741: APP_EXCEPTION.RAISE_EXCEPTION;
13742: WHEN OTHERS THEN
13743: AP_WEB_DB_UTIL_PKG.RaiseException('processCrossThreshold');
13744: APP_EXCEPTION.RAISE_EXCEPTION;
13745: END processCrossThreshold;

Line 13744: APP_EXCEPTION.RAISE_EXCEPTION;

13740: AP_WEB_DB_UTIL_PKG.RaiseException('No Data found: processCrossThreshold');
13741: APP_EXCEPTION.RAISE_EXCEPTION;
13742: WHEN OTHERS THEN
13743: AP_WEB_DB_UTIL_PKG.RaiseException('processCrossThreshold');
13744: APP_EXCEPTION.RAISE_EXCEPTION;
13745: END processCrossThreshold;
13746:
13747: -------------------------------------------------------------------------------
13748: PROCEDURE ProcessMileageLines(p_item_type IN VARCHAR2,

Line 14213: APP_EXCEPTION.RAISE_EXCEPTION;

14209:
14210: EXCEPTION
14211: WHEN OTHERS THEN
14212: AP_WEB_DB_UTIL_PKG.RaiseException('ProcessMileageLines');
14213: APP_EXCEPTION.RAISE_EXCEPTION;
14214: END ProcessMileageLines;
14215:
14216: -------------------------------------------------------------------------------
14217: PROCEDURE hasCompanyViolations( p_item_type IN VARCHAR2,

Line 14271: APP_EXCEPTION.RAISE_EXCEPTION;

14267:
14268: EXCEPTION
14269: WHEN OTHERS THEN
14270: AP_WEB_DB_UTIL_PKG.RaiseException('hasCompanyViolations');
14271: APP_EXCEPTION.RAISE_EXCEPTION;
14272: END hasCompanyViolations;
14273:
14274:
14275: -------------------------------------------------------------------------------

Line 14667: APP_EXCEPTION.RAISE_EXCEPTION;

14663: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14664: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToOtherErrors');
14665: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14666: END IF;
14667: APP_EXCEPTION.RAISE_EXCEPTION;
14668:
14669: END AddToOtherErrors;
14670:
14671: /*

Line 15924: APP_EXCEPTION.RAISE_EXCEPTION;

15920: END IF;
15921:
15922: -- always raise exceptions regardless it from RaiseSubmitEvent
15923: -- or other callees
15924: APP_EXCEPTION.RAISE_EXCEPTION;
15925:
15926: END RaiseSubmitEvent;
15927:
15928:

Line 17265: APP_EXCEPTION.RAISE_EXCEPTION;

17261: EXCEPTION
17262: WHEN OTHERS THEN
17263: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_EXPENSE_WF.getItemKey',
17264: l_debug_info);
17265: APP_EXCEPTION.RAISE_EXCEPTION;
17266: END getItemKey;
17267:
17268: ----------------------------------------------------------------------
17269: PROCEDURE IsPreparerActive(p_item_type IN VARCHAR2,