DBA Data[Home] [Help]

APPS.AP_WEB_DB_CCARD_PKG dependencies on APP_EXCEPTION

Line 27: APP_EXCEPTION.RAISE_EXCEPTION;

23: RETURN FALSE;
24:
25: WHEN OTHERS THEN
26: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetExpRptCCTrxnCategoryCursor' );
27: APP_EXCEPTION.RAISE_EXCEPTION;
28: return FALSE;
29:
30: END GetExpRptCCTrxnCategoryCursor;
31:

Line 82: APP_EXCEPTION.RAISE_EXCEPTION;

78: RETURN FALSE;
79:
80: WHEN OTHERS THEN
81: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCreditCardTrxnCursor' );
82: APP_EXCEPTION.RAISE_EXCEPTION;
83: return FALSE;
84:
85: END GetCreditCardTrxnCursor;
86:

Line 129: APP_EXCEPTION.RAISE_EXCEPTION;

125: RETURN FALSE;
126:
127: WHEN OTHERS THEN
128: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCreditCardInfoCursor' );
129: APP_EXCEPTION.RAISE_EXCEPTION;
130: return FALSE;
131:
132: END GetCreditCardInfoCursor;
133:

Line 179: APP_EXCEPTION.RAISE_EXCEPTION;

175: RETURN FALSE;
176:
177: WHEN OTHERS THEN
178: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetUnpaidCreditCardTrxnCursor' );
179: APP_EXCEPTION.RAISE_EXCEPTION;
180: return FALSE;
181: END GetUnpaidCreditCardTrxnCursor;
182:
183: ---------------------------------------------------------------------------

Line 222: APP_EXCEPTION.RAISE_EXCEPTION;

218: RETURN FALSE;
219:
220: WHEN OTHERS THEN
221: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetDisputedCcardTrxnCursor' );
222: APP_EXCEPTION.RAISE_EXCEPTION;
223: return FALSE;
224:
225: END GetDisputedCcardTrxnCursor;
226:

Line 347: APP_EXCEPTION.RAISE_EXCEPTION;

343: RETURN FALSE;
344:
345: WHEN OTHERS THEN
346: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetUnsubmittedCcardTrxnCursor' );
347: APP_EXCEPTION.RAISE_EXCEPTION;
348: return FALSE;
349:
350: END GetUnsubmittedCcardTrxnCursor;
351:

Line 467: APP_EXCEPTION.RAISE_EXCEPTION;

463: RETURN FALSE;
464:
465: WHEN OTHERS THEN
466: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetTotalUnsubmittedCCCursor' );
467: APP_EXCEPTION.RAISE_EXCEPTION;
468: return FALSE;
469:
470: END GetTotalUnsubmittedCCCursor;
471:

Line 594: APP_EXCEPTION.RAISE_EXCEPTION;

590: RETURN FALSE;
591:
592: WHEN OTHERS THEN
593: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetDunningCcardTrxnCursor' );
594: APP_EXCEPTION.RAISE_EXCEPTION;
595: return FALSE;
596:
597: END GetDunningCcardTrxnCursor;
598:

Line 703: APP_EXCEPTION.RAISE_EXCEPTION;

699: RETURN FALSE;
700:
701: WHEN OTHERS THEN
702: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetTotalCcardTrxnCursor' );
703: APP_EXCEPTION.RAISE_EXCEPTION;
704: return FALSE;
705:
706: END GetTotalCcardTrxnCursor;
707:

Line 730: APP_EXCEPTION.RAISE_EXCEPTION;

726: RETURN FALSE;
727:
728: WHEN OTHERS THEN
729: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCardProgramCurrencyCode' );
730: APP_EXCEPTION.RAISE_EXCEPTION;
731: return FALSE;
732:
733: END GetCardProgramCurrencyCode;
734:

Line 755: APP_EXCEPTION.RAISE_EXCEPTION;

751: WHEN NO_DATA_FOUND THEN
752: RETURN FALSE;
753: WHEN OTHERS THEN
754: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCCTrxnCategory' );
755: APP_EXCEPTION.RAISE_EXCEPTION;
756: return FALSE;
757:
758:
759: END GetCCTrxnCategory;

Line 785: APP_EXCEPTION.RAISE_EXCEPTION;

781: WHEN NO_DATA_FOUND THEN
782: RETURN FALSE;
783: WHEN OTHERS THEN
784: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCompPrepaidInvID' );
785: APP_EXCEPTION.RAISE_EXCEPTION;
786: return FALSE;
787:
788:
789: END GetCompPrepaidInvID;

Line 812: APP_EXCEPTION.RAISE_EXCEPTION;

808: RETURN FALSE;
809:
810: WHEN OTHERS THEN
811: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetExpensedAmt' );
812: APP_EXCEPTION.RAISE_EXCEPTION;
813: return FALSE;
814:
815: END GetExpensedAmt;
816:

Line 843: APP_EXCEPTION.RAISE_EXCEPTION;

839: WHEN NO_DATA_FOUND THEN
840: RETURN FALSE;
841: WHEN OTHERS THEN
842: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCardProgramInfo' );
843: APP_EXCEPTION.RAISE_EXCEPTION;
844: return FALSE;
845: END GetCardProgramInfo;
846:
847:

Line 873: APP_EXCEPTION.RAISE_EXCEPTION;

869: RETURN FALSE;
870:
871: WHEN OTHERS THEN
872: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetVendorIDs' );
873: APP_EXCEPTION.RAISE_EXCEPTION;
874: return FALSE;
875:
876: END GetVendorIDs;
877:

Line 898: APP_EXCEPTION.RAISE_EXCEPTION;

894: RETURN FALSE;
895:
896: WHEN OTHERS THEN
897: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCardProgramName' );
898: APP_EXCEPTION.RAISE_EXCEPTION;
899: return FALSE;
900:
901: END GetCardProgramName;
902:

Line 924: APP_EXCEPTION.RAISE_EXCEPTION;

920: RETURN FALSE;
921:
922: WHEN OTHERS THEN
923: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCardProgramID' );
924: APP_EXCEPTION.RAISE_EXCEPTION;
925: return FALSE;
926:
927: END GetCardProgramID;
928:

Line 952: APP_EXCEPTION.RAISE_EXCEPTION;

948: RETURN FALSE;
949:
950: WHEN OTHERS THEN
951: AP_WEB_DB_UTIL_PKG.RaiseException( 'CompanyHasTravelCardProgram' );
952: APP_EXCEPTION.RAISE_EXCEPTION;
953: return FALSE;
954:
955: END CompanyHasTravelCardProgram;
956:

Line 998: APP_EXCEPTION.RAISE_EXCEPTION;

994: RETURN FALSE;
995:
996: WHEN OTHERS THEN
997: AP_WEB_DB_UTIL_PKG.RaiseException( 'UserHasCreditCard' );
998: APP_EXCEPTION.RAISE_EXCEPTION;
999: return FALSE;
1000:
1001: END UserHasCreditCard;
1002:

Line 1024: APP_EXCEPTION.RAISE_EXCEPTION;

1020: RETURN FALSE;
1021:
1022: WHEN OTHERS THEN
1023: AP_WEB_DB_UTIL_PKG.RaiseException( 'SetCCTrxnReportHeaderID' );
1024: APP_EXCEPTION.RAISE_EXCEPTION;
1025: return FALSE;
1026:
1027: END SetCCTrxnReportHeaderID;
1028:

Line 1050: APP_EXCEPTION.RAISE_EXCEPTION;

1046: RETURN FALSE;
1047:
1048: WHEN OTHERS THEN
1049: AP_WEB_DB_UTIL_PKG.RaiseException( 'SetCCPolicyShortPaidReportID' );
1050: APP_EXCEPTION.RAISE_EXCEPTION;
1051: return FALSE;
1052:
1053: END SetCCPolicyShortpaidReportID;
1054:

Line 1080: APP_EXCEPTION.RAISE_EXCEPTION;

1076: RETURN FALSE;
1077:
1078: WHEN OTHERS THEN
1079: AP_WEB_DB_UTIL_PKG.RaiseException( 'SetCCReceiptShortpaidReportID' );
1080: APP_EXCEPTION.RAISE_EXCEPTION;
1081: return FALSE;
1082:
1083: END SetCCReceiptShortpaidReportID;
1084:

Line 1109: APP_EXCEPTION.RAISE_EXCEPTION;

1105: RETURN FALSE;
1106:
1107: WHEN OTHERS THEN
1108: AP_WEB_DB_UTIL_PKG.RaiseException( 'UpdateExpensedAmount' );
1109: APP_EXCEPTION.RAISE_EXCEPTION;
1110: return FALSE;
1111:
1112: END UpdateExpensedAmount;
1113:

Line 1132: APP_EXCEPTION.RAISE_EXCEPTION;

1128: RETURN FALSE;
1129:
1130: WHEN OTHERS THEN
1131: AP_WEB_DB_UTIL_PKG.RaiseException( 'ResetCCLines' );
1132: APP_EXCEPTION.RAISE_EXCEPTION;
1133: return FALSE;
1134:
1135: END ResetCCLines;
1136:

Line 1157: APP_EXCEPTION.RAISE_EXCEPTION;

1153: RETURN FALSE;
1154:
1155: WHEN OTHERS THEN
1156: AP_WEB_DB_UTIL_PKG.RaiseException( 'SetStatus' );
1157: APP_EXCEPTION.RAISE_EXCEPTION;
1158: return FALSE;
1159:
1160: END SetStatus;
1161:

Line 1190: APP_EXCEPTION.RAISE_EXCEPTION;

1186: RETURN FALSE;
1187:
1188: WHEN OTHERS THEN
1189: AP_WEB_DB_UTIL_PKG.RaiseException( 'ResetCCMgrRejectedCCLines' );
1190: APP_EXCEPTION.RAISE_EXCEPTION;
1191: return FALSE;
1192:
1193: END ResetCCMgrRejectedCCLines;
1194:

Line 1217: APP_EXCEPTION.RAISE_EXCEPTION;

1213:
1214: WHEN OTHERS THEN
1215: AP_WEB_DB_UTIL_PKG.RaiseException( 'ResetPersonalTrxns' );
1216:
1217: APP_EXCEPTION.RAISE_EXCEPTION;
1218: return FALSE;
1219: END ResetPersonalTrxns;
1220:
1221: --------------------------------------------------------------------------------

Line 1250: APP_EXCEPTION.RAISE_EXCEPTION;

1246: RETURN FALSE;
1247:
1248: WHEN OTHERS THEN
1249: AP_WEB_DB_UTIL_PKG.RaiseException( 'ResetMgrRejectedPersonalTrxns' );
1250: APP_EXCEPTION.RAISE_EXCEPTION;
1251: return FALSE;
1252:
1253: END ResetMgrRejectPersonalTrxns;
1254:

Line 1276: APP_EXCEPTION.RAISE_EXCEPTION;

1272: RETURN FALSE;
1273:
1274: WHEN OTHERS THEN
1275: AP_WEB_DB_UTIL_PKG.RaiseException( 'UpdateInvoiceId' );
1276: APP_EXCEPTION.RAISE_EXCEPTION;
1277: return FALSE;
1278:
1279: END SetCCTrxnInvoiceId;
1280:

Line 1317: APP_EXCEPTION.RAISE_EXCEPTION;

1313: RETURN FALSE;
1314:
1315: WHEN OTHERS THEN
1316: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCCardTrxnInfoForTrxnId' );
1317: APP_EXCEPTION.RAISE_EXCEPTION;
1318: return FALSE;
1319:
1320: END GetCCardTrxnInfoForTrxnId;
1321:

Line 1341: APP_EXCEPTION.RAISE_EXCEPTION;

1337: RETURN FALSE;
1338: WHEN OTHERS THEN
1339: AP_WEB_DB_UTIL_PKG.RaiseException( 'UpdateCCardCategory' );
1340:
1341: APP_EXCEPTION.RAISE_EXCEPTION;
1342: return FALSE;
1343: END UpdateCCardCategory;
1344:
1345: ------------------------------------------------------------------------------

Line 1364: APP_EXCEPTION.RAISE_EXCEPTION;

1360: WHEN NO_DATA_FOUND THEN
1361: RETURN FALSE;
1362: WHEN OTHERS THEN
1363: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetExpensedAmountForTrxnId' );
1364: APP_EXCEPTION.RAISE_EXCEPTION;
1365: return FALSE;
1366: END GetExpensedAmountForTrxnId;
1367:
1368: ------------------------------------------------------------------------------

Line 1399: APP_EXCEPTION.RAISE_EXCEPTION;

1395: WHEN NO_DATA_FOUND THEN
1396: RETURN FALSE;
1397: WHEN OTHERS THEN
1398: AP_WEB_DB_UTIL_PKG.RaiseException( 'isMultPayments');
1399: APP_EXCEPTION.RAISE_EXCEPTION;
1400: return FALSE;
1401: END isMultPayments;
1402: -------------------------------------------------------------------------------
1403: /*Written By :Amulya Mishra

Line 1432: APP_EXCEPTION.RAISE_EXCEPTION;

1428: RETURN null;
1429:
1430: WHEN OTHERS THEN
1431: AP_WEB_DB_UTIL_PKG.RaiseException( 'getPaymentDueCodeFromTrxn' );
1432: APP_EXCEPTION.RAISE_EXCEPTION;
1433:
1434: END getPaymentDueCodeFromTrxn;
1435: -----------------------------------------------------------------------------
1436: /*Written By :Amulya Mishra

Line 1522: APP_EXCEPTION.RAISE_EXCEPTION;

1518: RETURN 'N';
1519:
1520: WHEN OTHERS THEN
1521: AP_WEB_DB_UTIL_PKG.RaiseException( 'isCreditCardEnabled', l_debug_info );
1522: APP_EXCEPTION.RAISE_EXCEPTION;
1523:
1524: END isCreditCardEnabled;
1525:
1526: /*Written By : Ron Langi

Line 1554: APP_EXCEPTION.RAISE_EXCEPTION;

1550: RETURN null;
1551:
1552: WHEN OTHERS THEN
1553: AP_WEB_DB_UTIL_PKG.RaiseException( 'getPreventCashCCAgeLimit', l_debug_info );
1554: APP_EXCEPTION.RAISE_EXCEPTION;
1555:
1556: END getPreventCashCCAgeLimit;
1557:
1558: /*Written By : Ron Langi

Line 1585: APP_EXCEPTION.RAISE_EXCEPTION;

1581: RETURN false;
1582:
1583: WHEN OTHERS THEN
1584: AP_WEB_DB_UTIL_PKG.RaiseException( 'isPreventCashCCAgeLimitSet', l_debug_info );
1585: APP_EXCEPTION.RAISE_EXCEPTION;
1586:
1587: END isPreventCashCCAgeLimitSet;
1588:
1589: /*Written By : Ron Langi

Line 1637: APP_EXCEPTION.RAISE_EXCEPTION;

1633: p_num_old := 0;
1634:
1635: WHEN OTHERS THEN
1636: AP_WEB_DB_UTIL_PKG.RaiseException( 'getNumOldTrxns', l_debug_info );
1637: APP_EXCEPTION.RAISE_EXCEPTION;
1638:
1639: END getNumOldTrxns;
1640:
1641: /*Written By : Ron Langi

Line 1676: APP_EXCEPTION.RAISE_EXCEPTION;

1672: p_num_disputed := 0;
1673:
1674: WHEN OTHERS THEN
1675: AP_WEB_DB_UTIL_PKG.RaiseException( 'getNumDisputedTrxns', l_debug_info );
1676: APP_EXCEPTION.RAISE_EXCEPTION;
1677:
1678: END getNumDisputedTrxns;
1679:
1680: /*Written By : Ron Langi

Line 1715: APP_EXCEPTION.RAISE_EXCEPTION;

1711: p_num_credits := 0;
1712:
1713: WHEN OTHERS THEN
1714: AP_WEB_DB_UTIL_PKG.RaiseException( 'getNumCredits', l_debug_info );
1715: APP_EXCEPTION.RAISE_EXCEPTION;
1716:
1717: END getNumCredits;
1718:
1719: /*Written By : Ron Langi

Line 1785: APP_EXCEPTION.RAISE_EXCEPTION;

1781:
1782: EXCEPTION
1783: WHEN OTHERS THEN
1784: AP_WEB_DB_UTIL_PKG.RaiseException( 'checkDelegatesForAlerts', l_debug_info );
1785: APP_EXCEPTION.RAISE_EXCEPTION;
1786:
1787: END checkDelegatesForAlerts;
1788:
1789:

Line 1902: APP_EXCEPTION.RAISE_EXCEPTION;

1898: RETURN FALSE;
1899:
1900: WHEN OTHERS THEN
1901: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetDisputeCcardTrxnCursor' );
1902: APP_EXCEPTION.RAISE_EXCEPTION;
1903: return FALSE;
1904:
1905: END GetDisputeCcardTrxnCursor;
1906:

Line 1968: APP_EXCEPTION.RAISE_EXCEPTION;

1964: RETURN FALSE;
1965:
1966: WHEN OTHERS THEN
1967: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetTotalCreditCardAmount' );
1968: APP_EXCEPTION.RAISE_EXCEPTION;
1969: return FALSE;
1970:
1971: END GetTotalCreditCardAmount;
1972:

Line 2045: APP_EXCEPTION.RAISE_EXCEPTION;

2041: RETURN FALSE;
2042:
2043: WHEN OTHERS THEN
2044: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetTotalNumberOutstanding' );
2045: APP_EXCEPTION.RAISE_EXCEPTION;
2046: return FALSE;
2047:
2048: END GetTotalNumberOutstanding;
2049:

Line 2104: APP_EXCEPTION.RAISE_EXCEPTION;

2100: RETURN FALSE;
2101:
2102: WHEN OTHERS THEN
2103: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetTotalNumberOutstanding' );
2104: APP_EXCEPTION.RAISE_EXCEPTION;
2105: return FALSE;
2106:
2107: END GetTotalNumberDispute;
2108:

Line 2151: APP_EXCEPTION.RAISE_EXCEPTION;

2147: RETURN sysdate;
2148:
2149: WHEN OTHERS THEN
2150: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetOldestAvailPostedDate' );
2151: APP_EXCEPTION.RAISE_EXCEPTION;
2152: return sysdate;
2153:
2154: END GetOldestAvailPostedDate;
2155: