eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_DB_CCARD_PKG dependencies on AP_WEB_DB_UTIL_PKG

Line 26: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetExpRptCCTrxnCategoryCursor' );

22: WHEN NO_DATA_FOUND THEN
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;

Line 81: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCreditCardTrxnCursor' );

77: WHEN NO_DATA_FOUND THEN
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;

Line 128: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCreditCardInfoCursor' );

124: WHEN NO_DATA_FOUND THEN
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;

Line 178: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetUnpaidCreditCardTrxnCursor' );

174: WHEN NO_DATA_FOUND THEN
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:

Line 221: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetDisputedCcardTrxnCursor' );

217: WHEN NO_DATA_FOUND THEN
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;

Line 346: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetUnsubmittedCcardTrxnCursor' );

342: WHEN NO_DATA_FOUND THEN
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;

Line 466: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetTotalUnsubmittedCCCursor' );

462: WHEN NO_DATA_FOUND THEN
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;

Line 593: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetDunningCcardTrxnCursor' );

589: WHEN NO_DATA_FOUND THEN
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;

Line 702: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetTotalCcardTrxnCursor' );

698: WHEN NO_DATA_FOUND THEN
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;

Line 729: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCardProgramCurrencyCode' );

725: WHEN NO_DATA_FOUND THEN
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;

Line 754: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCCTrxnCategory' );

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

Line 784: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCompPrepaidInvID' );

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

Line 811: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetExpensedAmt' );

807: WHEN NO_DATA_FOUND THEN
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;

Line 842: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCardProgramInfo' );

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

Line 872: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetVendorIDs' );

868: WHEN NO_DATA_FOUND THEN
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;

Line 897: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCardProgramName' );

893: WHEN NO_DATA_FOUND THEN
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;

Line 923: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCardProgramID' );

919: WHEN NO_DATA_FOUND THEN
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;

Line 951: AP_WEB_DB_UTIL_PKG.RaiseException( 'CompanyHasTravelCardProgram' );

947: WHEN NO_DATA_FOUND THEN
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;

Line 997: AP_WEB_DB_UTIL_PKG.RaiseException( 'UserHasCreditCard' );

993: WHEN NO_DATA_FOUND THEN
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;

Line 1023: AP_WEB_DB_UTIL_PKG.RaiseException( 'SetCCTrxnReportHeaderID' );

1019: WHEN NO_DATA_FOUND THEN
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;

Line 1049: AP_WEB_DB_UTIL_PKG.RaiseException( 'SetCCPolicyShortPaidReportID' );

1045: WHEN NO_DATA_FOUND THEN
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;

Line 1079: AP_WEB_DB_UTIL_PKG.RaiseException( 'SetCCReceiptShortpaidReportID' );

1075: WHEN NO_DATA_FOUND THEN
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;

Line 1108: AP_WEB_DB_UTIL_PKG.RaiseException( 'UpdateExpensedAmount' );

1104: WHEN NO_DATA_FOUND THEN
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;

Line 1131: AP_WEB_DB_UTIL_PKG.RaiseException( 'ResetCCLines' );

1127: WHEN NO_DATA_FOUND THEN
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;

Line 1156: AP_WEB_DB_UTIL_PKG.RaiseException( 'SetStatus' );

1152: WHEN NO_DATA_FOUND THEN
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;

Line 1189: AP_WEB_DB_UTIL_PKG.RaiseException( 'ResetCCMgrRejectedCCLines' );

1185: WHEN NO_DATA_FOUND THEN
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;

Line 1215: AP_WEB_DB_UTIL_PKG.RaiseException( 'ResetPersonalTrxns' );

1211: WHEN NO_DATA_FOUND THEN
1212: RETURN FALSE;
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;

Line 1249: AP_WEB_DB_UTIL_PKG.RaiseException( 'ResetMgrRejectedPersonalTrxns' );

1245: WHEN NO_DATA_FOUND THEN
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;

Line 1275: AP_WEB_DB_UTIL_PKG.RaiseException( 'UpdateInvoiceId' );

1271: WHEN NO_DATA_FOUND THEN
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;

Line 1316: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCCardTrxnInfoForTrxnId' );

1312: WHEN NO_DATA_FOUND THEN
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;

Line 1339: AP_WEB_DB_UTIL_PKG.RaiseException( 'UpdateCCardCategory' );

1335: EXCEPTION
1336: WHEN NO_DATA_FOUND THEN
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;

Line 1363: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetExpensedAmountForTrxnId' );

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

Line 1398: AP_WEB_DB_UTIL_PKG.RaiseException( 'isMultPayments');

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

Line 1431: AP_WEB_DB_UTIL_PKG.RaiseException( 'getPaymentDueCodeFromTrxn' );

1427: WHEN NO_DATA_FOUND THEN
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: -----------------------------------------------------------------------------

Line 1521: AP_WEB_DB_UTIL_PKG.RaiseException( 'isCreditCardEnabled', l_debug_info );

1517: WHEN NO_DATA_FOUND THEN
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:

Line 1553: AP_WEB_DB_UTIL_PKG.RaiseException( 'getPreventCashCCAgeLimit', l_debug_info );

1549: WHEN NO_DATA_FOUND THEN
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:

Line 1584: AP_WEB_DB_UTIL_PKG.RaiseException( 'isPreventCashCCAgeLimitSet', l_debug_info );

1580: WHEN NO_DATA_FOUND THEN
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:

Line 1636: AP_WEB_DB_UTIL_PKG.RaiseException( 'getNumOldTrxns', l_debug_info );

1632: WHEN NO_DATA_FOUND THEN
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:

Line 1675: AP_WEB_DB_UTIL_PKG.RaiseException( 'getNumDisputedTrxns', l_debug_info );

1671: WHEN NO_DATA_FOUND THEN
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:

Line 1714: AP_WEB_DB_UTIL_PKG.RaiseException( 'getNumCredits', l_debug_info );

1710: WHEN NO_DATA_FOUND THEN
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:

Line 1784: AP_WEB_DB_UTIL_PKG.RaiseException( 'checkDelegatesForAlerts', l_debug_info );

1780: close delegates;
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:

Line 1845: AP_WEB_DB_UTIL_PKG.RaiseException('getAlertsForHomepage', l_debug_info);

1841: EXCEPTION
1842: WHEN NO_DATA_FOUND THEN
1843: NULL;
1844: WHEN OTHERS THEN
1845: AP_WEB_DB_UTIL_PKG.RaiseException('getAlertsForHomepage', l_debug_info);
1846:
1847: END getAlertsForHomepage;
1848:
1849: ---------------------------------------------------------------------------

Line 1901: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetDisputeCcardTrxnCursor' );

1897: WHEN NO_DATA_FOUND THEN
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;

Line 1967: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetTotalCreditCardAmount' );

1963: WHEN NO_DATA_FOUND THEN
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;

Line 2044: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetTotalNumberOutstanding' );

2040: WHEN NO_DATA_FOUND THEN
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;

Line 2103: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetTotalNumberOutstanding' );

2099: WHEN NO_DATA_FOUND THEN
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;

Line 2150: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetOldestAvailPostedDate' );

2146: WHEN NO_DATA_FOUND THEN
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;