894: END IF;
895:
896: -- always raise exceptions regardless it from StartExpenseReportProcess
897: -- or other callees
898: APP_EXCEPTION.RAISE_EXCEPTION;
899:
900: END StartExpenseReportProcess;
901:
902:
978: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
979: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GenTableHeader');
980: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
981: END IF;
982: APP_EXCEPTION.RAISE_EXCEPTION;
983:
984: END GenTableHeader;
985:
986: ---------------------------------------------------------
1133: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1134: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GenTableRows');
1135: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1136: END IF;
1137: APP_EXCEPTION.RAISE_EXCEPTION;
1138:
1139: END GenTableRows;
1140:
1141: BEGIN
1713: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1714: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToWFSSError');
1715: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_exceed_error_msg);
1716: END IF;
1717: APP_EXCEPTION.RAISE_EXCEPTION;
1718:
1719: END AddToWFSSError;
1720:
1721: ----------------------------------------------------------------------
1771: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1772: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToHeaderErrors');
1773: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1774: END IF;
1775: APP_EXCEPTION.RAISE_EXCEPTION;
1776:
1777: END AddToHeaderErrors;
1778:
1779:
1840: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1841: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'HandleInvalidDistCCID');
1842: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1843: END IF;
1844: APP_EXCEPTION.RAISE_EXCEPTION;
1845: END HandleInvalidDistCCID;
1846:
1847:
1848: ----------------------------------------------------------------------
2637: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2638: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DoAPValidation');
2639: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2640: END IF;
2641: APP_EXCEPTION.RAISE_EXCEPTION;
2642: END DoAPValidation;
2643:
2644: -------------------------------------
2645: PROCEDURE OpenExp(p1 varchar2,
4147: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4148: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MissingReceiptShortPay');
4149: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4150: END IF;
4151: APP_EXCEPTION.RAISE_EXCEPTION;
4152: END MissingReceiptShortPay;
4153:
4154: -----------------------------------------------------------------------------
4155: PROCEDURE PolicyViolationShortPay(p_item_type IN VARCHAR2,
4196: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4197: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PolicyViolationShortPay');
4198: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4199: END IF;
4200: APP_EXCEPTION.RAISE_EXCEPTION;
4201: END PolicyViolationShortPay;
4202:
4203: -----------------------------------------------------------------------------
4204: FUNCTION GetNewShortPayDocumentNum(p_last_document_num IN VARCHAR2) RETURN VARCHAR2 IS
4731: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4732: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DeleteExpReportFromAPTables');
4733: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4734: END IF;
4735: APP_EXCEPTION.RAISE_EXCEPTION;
4736: END DeleteExpReportFromAPTables;
4737:
4738: ---------------------------------------------------
4739: PROCEDURE ResetAttrValues(p_item_type IN VARCHAR2,
5034:
5035: EXCEPTION
5036: WHEN OTHERS THEN
5037: ROLLBACK;
5038: APP_EXCEPTION.RAISE_EXCEPTION;
5039: END ResetCCardTxns;
5040:
5041: PROCEDURE AMEAbortRequestApprovals(p_rep_header_id IN AP_WEB_DB_EXPLINE_PKG.expLines_headerID)
5042: IS
10196: --Bug 2742114:raise exception when preparer id and trasferee is same.
10197:
10198: IF l_preparer_id = l_TransferToID THEN
10199: FND_MESSAGE.SET_NAME('SQLAP','OIE_TRANSFEREE_CANTBE_PREPARER');
10200: app_exception.raise_exception;
10201: END IF;
10202:
10203:
10204: ----------------------------------------------------------
11182:
11183: EXCEPTION
11184: WHEN OTHERS THEN
11185: ROLLBACK;
11186: APP_EXCEPTION.RAISE_EXCEPTION;
11187: END WithdrawExpenseRep;
11188:
11189:
11190: PROCEDURE GenerateExpClobLines(document_id IN VARCHAR2,
12278:
12279: EXCEPTION
12280: WHEN OTHERS THEN
12281: AP_WEB_DB_UTIL_PKG.RaiseException('determineMileageAdjusted');
12282: APP_EXCEPTION.RAISE_EXCEPTION;
12283: END determineMileageAdjusted;
12284:
12285:
12286:
12451: EXCEPTION
12452: WHEN OTHERS THEN
12453: AP_WEB_DB_UTIL_PKG.RaiseException('getScheduleLineArray',
12454: l_debug_info);
12455: APP_EXCEPTION.RAISE_EXCEPTION;
12456: END getScheduleLineArray;
12457:
12458:
12459: -------------------------------------------------------------------------------
12504:
12505: EXCEPTION
12506: WHEN OTHERS THEN
12507: AP_WEB_DB_UTIL_PKG.RaiseException('updateCumulativeMileage');
12508: APP_EXCEPTION.RAISE_EXCEPTION;
12509: END updateCumulativeMileage;
12510:
12511:
12512: FUNCTION getAddonMileageRatesSum(p_report_header_id IN NUMBER,
12609: WHEN NO_DATA_FOUND THEN
12610: return 0;
12611: WHEN OTHERS THEN
12612: AP_WEB_DB_UTIL_PKG.RaiseException('getRate');
12613: APP_EXCEPTION.RAISE_EXCEPTION;
12614: return 0;
12615: END getRate;
12616:
12617:
12643:
12644: EXCEPTION
12645: WHEN OTHERS THEN
12646: AP_WEB_DB_UTIL_PKG.RaiseException('copyMileageArray');
12647: APP_EXCEPTION.RAISE_EXCEPTION;
12648: END copyMileageArray;
12649:
12650:
12651: -------------------------------------------------------------------------------
12681:
12682: EXCEPTION
12683: WHEN OTHERS THEN
12684: AP_WEB_DB_UTIL_PKG.RaiseException('addToMileageArray');
12685: APP_EXCEPTION.RAISE_EXCEPTION;
12686: END addToMileageArray;
12687:
12688: -------------------------------------------------------------------------------
12689: PROCEDURE updateNewDistNumber(
12714:
12715: EXCEPTION
12716: WHEN OTHERS THEN
12717: AP_WEB_DB_UTIL_PKG.RaiseException('updateNewDistNumber');
12718: APP_EXCEPTION.RAISE_EXCEPTION;
12719: END updateNewDistNumber;
12720:
12721: --------------------------------------------------------------------------------
12722: PROCEDURE processCrossThreshold(
12949:
12950: EXCEPTION
12951: WHEN NO_DATA_FOUND THEN
12952: AP_WEB_DB_UTIL_PKG.RaiseException('No Data found: processCrossThreshold');
12953: APP_EXCEPTION.RAISE_EXCEPTION;
12954: WHEN OTHERS THEN
12955: AP_WEB_DB_UTIL_PKG.RaiseException('processCrossThreshold');
12956: APP_EXCEPTION.RAISE_EXCEPTION;
12957: END processCrossThreshold;
12952: AP_WEB_DB_UTIL_PKG.RaiseException('No Data found: processCrossThreshold');
12953: APP_EXCEPTION.RAISE_EXCEPTION;
12954: WHEN OTHERS THEN
12955: AP_WEB_DB_UTIL_PKG.RaiseException('processCrossThreshold');
12956: APP_EXCEPTION.RAISE_EXCEPTION;
12957: END processCrossThreshold;
12958:
12959: -------------------------------------------------------------------------------
12960: PROCEDURE ProcessMileageLines(p_item_type IN VARCHAR2,
13439:
13440: EXCEPTION
13441: WHEN OTHERS THEN
13442: AP_WEB_DB_UTIL_PKG.RaiseException('ProcessMileageLines');
13443: APP_EXCEPTION.RAISE_EXCEPTION;
13444: END ProcessMileageLines;
13445:
13446: -------------------------------------------------------------------------------
13447: PROCEDURE hasCompanyViolations( p_item_type IN VARCHAR2,
13497:
13498: EXCEPTION
13499: WHEN OTHERS THEN
13500: AP_WEB_DB_UTIL_PKG.RaiseException('hasCompanyViolations');
13501: APP_EXCEPTION.RAISE_EXCEPTION;
13502: END hasCompanyViolations;
13503:
13504:
13505: -------------------------------------------------------------------------------
13788: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
13789: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToOtherErrors');
13790: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
13791: END IF;
13792: APP_EXCEPTION.RAISE_EXCEPTION;
13793:
13794: END AddToOtherErrors;
13795:
13796: /*
14955: END IF;
14956:
14957: -- always raise exceptions regardless it from RaiseSubmitEvent
14958: -- or other callees
14959: APP_EXCEPTION.RAISE_EXCEPTION;
14960:
14961: END RaiseSubmitEvent;
14962:
14963:
16162: EXCEPTION
16163: WHEN OTHERS THEN
16164: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_EXPENSE_WF.getItemKey',
16165: l_debug_info);
16166: APP_EXCEPTION.RAISE_EXCEPTION;
16167: END getItemKey;
16168:
16169: ----------------------------------------------------------------------
16170: PROCEDURE IsPreparerActive(p_item_type IN VARCHAR2,