DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on APP_EXCEPTION

Line 898: APP_EXCEPTION.RAISE_EXCEPTION;

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:

Line 982: APP_EXCEPTION.RAISE_EXCEPTION;

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: ---------------------------------------------------------

Line 1137: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 1717: APP_EXCEPTION.RAISE_EXCEPTION;

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: ----------------------------------------------------------------------

Line 1775: APP_EXCEPTION.RAISE_EXCEPTION;

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:

Line 1844: APP_EXCEPTION.RAISE_EXCEPTION;

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: ----------------------------------------------------------------------

Line 2641: APP_EXCEPTION.RAISE_EXCEPTION;

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,

Line 4151: APP_EXCEPTION.RAISE_EXCEPTION;

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,

Line 4200: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 4735: APP_EXCEPTION.RAISE_EXCEPTION;

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,

Line 5038: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 10200: app_exception.raise_exception;

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: ----------------------------------------------------------

Line 11186: APP_EXCEPTION.RAISE_EXCEPTION;

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,

Line 12282: APP_EXCEPTION.RAISE_EXCEPTION;

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:

Line 12455: APP_EXCEPTION.RAISE_EXCEPTION;

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: -------------------------------------------------------------------------------

Line 12508: APP_EXCEPTION.RAISE_EXCEPTION;

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,

Line 12613: APP_EXCEPTION.RAISE_EXCEPTION;

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:

Line 12647: APP_EXCEPTION.RAISE_EXCEPTION;

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: -------------------------------------------------------------------------------

Line 12685: APP_EXCEPTION.RAISE_EXCEPTION;

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(

Line 12718: APP_EXCEPTION.RAISE_EXCEPTION;

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(

Line 12953: APP_EXCEPTION.RAISE_EXCEPTION;

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;

Line 12956: APP_EXCEPTION.RAISE_EXCEPTION;

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,

Line 13443: APP_EXCEPTION.RAISE_EXCEPTION;

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,

Line 13501: APP_EXCEPTION.RAISE_EXCEPTION;

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: -------------------------------------------------------------------------------

Line 13792: APP_EXCEPTION.RAISE_EXCEPTION;

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: /*

Line 14959: APP_EXCEPTION.RAISE_EXCEPTION;

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:

Line 16166: APP_EXCEPTION.RAISE_EXCEPTION;

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,