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_EXPLINE_PKG dependencies on AP_WEB_DB_UTIL_PKG

Line 25: AP_WEB_DB_UTIL_PKG.RaiseException('GetTrxIdAndAmt',

21: EXCEPTION
22: WHEN NO_DATA_FOUND THEN
23: return FALSE;
24: WHEN OTHERS THEN
25: AP_WEB_DB_UTIL_PKG.RaiseException('GetTrxIdAndAmt',
26: l_debugInfo);
27: APP_EXCEPTION.RAISE_EXCEPTION;
28: return FALSE;
29: END GetTrxIdsAndAmtsCursor;

Line 94: AP_WEB_DB_UTIL_PKG.RaiseException('GetReportLineCursor');

90: EXCEPTION
91: WHEN NO_DATA_FOUND THEN
92: return FALSE;
93: WHEN OTHERS THEN
94: AP_WEB_DB_UTIL_PKG.RaiseException('GetReportLineCursor');
95: APP_EXCEPTION.RAISE_EXCEPTION;
96: return FALSE;
97: END GetReportLineCursor;
98:

Line 256: AP_WEB_DB_UTIL_PKG.RaiseException('GetDisplayXpenseLinesCursor');

252: EXCEPTION
253: WHEN NO_DATA_FOUND THEN
254: return FALSE;
255: WHEN OTHERS THEN
256: AP_WEB_DB_UTIL_PKG.RaiseException('GetDisplayXpenseLinesCursor');
257: APP_EXCEPTION.RAISE_EXCEPTION;
258: return FALSE;
259: END GetDisplayXpenseLinesCursor;
260:

Line 460: AP_WEB_DB_UTIL_PKG.RaiseException('GetDisplayXpenseLinesCursor');

456: EXCEPTION
457: WHEN NO_DATA_FOUND THEN
458: return FALSE;
459: WHEN OTHERS THEN
460: AP_WEB_DB_UTIL_PKG.RaiseException('GetDisplayXpenseLinesCursor');
461: APP_EXCEPTION.RAISE_EXCEPTION;
462: return FALSE;
463: END GetDisplayXpenseLinesCursor;
464:

Line 551: AP_WEB_DB_UTIL_PKG.RaiseException('GetDisplayPersonalLinesCursor');

547: EXCEPTION
548: WHEN NO_DATA_FOUND THEN
549: return FALSE;
550: WHEN OTHERS THEN
551: AP_WEB_DB_UTIL_PKG.RaiseException('GetDisplayPersonalLinesCursor');
552: APP_EXCEPTION.RAISE_EXCEPTION;
553: return FALSE;
554: END GetDisplayPersonalLinesCursor;
555:

Line 580: AP_WEB_DB_UTIL_PKG.RaiseException('AnyAuditIssue');

576: EXCEPTION
577: WHEN NO_DATA_FOUND THEN
578: return FALSE;
579: WHEN OTHERS THEN
580: AP_WEB_DB_UTIL_PKG.RaiseException('AnyAuditIssue');
581: APP_EXCEPTION.RAISE_EXCEPTION;
582: return FALSE;
583: END AnyAuditIssue;
584:

Line 710: AP_WEB_DB_UTIL_PKG.RaiseException('GetAdjustmentsCursor');

706: EXCEPTION
707: WHEN NO_DATA_FOUND THEN
708: return FALSE;
709: WHEN OTHERS THEN
710: AP_WEB_DB_UTIL_PKG.RaiseException('GetAdjustmentsCursor');
711: APP_EXCEPTION.RAISE_EXCEPTION;
712: return FALSE;
713: END GetAdjustmentsCursor;
714:

Line 778: AP_WEB_DB_UTIL_PKG.RaiseException('GetExpDistAcctCursor');

774: EXCEPTION
775: WHEN NO_DATA_FOUND THEN
776: return FALSE;
777: WHEN OTHERS THEN
778: AP_WEB_DB_UTIL_PKG.RaiseException('GetExpDistAcctCursor');
779: APP_EXCEPTION.RAISE_EXCEPTION;
780: return FALSE;
781: END GetExpDistAcctCursor;
782:

Line 810: AP_WEB_DB_UTIL_PKG.RaiseException('CalcNoReceiptsShortpayAmts');

806: p_no_receipts_ccard_amt:= 0;
807: p_no_receipts_emp_amt:= 0;
808: return FALSE;
809: WHEN OTHERS THEN
810: AP_WEB_DB_UTIL_PKG.RaiseException('CalcNoReceiptsShortpayAmts');
811: APP_EXCEPTION.RAISE_EXCEPTION;
812: return FALSE;
813: END CalcNoReceiptsShortpayAmts;
814:

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

838: WHEN NO_DATA_FOUND THEN
839: p_personal_total:= 0;
840: return FALSE;
841: WHEN OTHERS THEN
842: AP_WEB_DB_UTIL_PKG.RaiseException('CalcNoReceiptsPersonalTotal');
843: APP_EXCEPTION.RAISE_EXCEPTION;
844: return FALSE;
845: END CalcNoReceiptsPersonalTotal;
846:

Line 875: AP_WEB_DB_UTIL_PKG.RaiseException('CalculatePolicyShortpayAmts');

871: p_policy_emp_amt:= 0;
872: p_policy_shortpay_total := 0;
873: return FALSE;
874: WHEN OTHERS THEN
875: AP_WEB_DB_UTIL_PKG.RaiseException('CalculatePolicyShortpayAmts');
876: APP_EXCEPTION.RAISE_EXCEPTION;
877: return FALSE;
878: END CalculatePolicyShortpayAmts;
879:

Line 901: AP_WEB_DB_UTIL_PKG.RaiseException('GetReceiptMissingTotal');

897: WHEN NO_DATA_FOUND THEN
898: p_sum_missing_receipts:= 0;
899: return FALSE;
900: WHEN OTHERS THEN
901: AP_WEB_DB_UTIL_PKG.RaiseException('GetReceiptMissingTotal');
902: APP_EXCEPTION.RAISE_EXCEPTION;
903: return FALSE;
904: END GetReceiptMissingTotal;
905: -------------------------------------------------------------------

Line 931: AP_WEB_DB_UTIL_PKG.RaiseException('GetReceiptViolationsTotal');

927: WHEN NO_DATA_FOUND THEN
928: p_sum_violations:= 0;
929: return FALSE;
930: WHEN OTHERS THEN
931: AP_WEB_DB_UTIL_PKG.RaiseException('GetReceiptViolationsTotal');
932: APP_EXCEPTION.RAISE_EXCEPTION;
933: return FALSE;
934: END GetReceiptViolationsTotal;
935:

Line 964: AP_WEB_DB_UTIL_PKG.RaiseException('GetPersonalTotalOfExpRpt');

960: WHEN NO_DATA_FOUND THEN
961: p_personal_total:= 0;
962: return FALSE;
963: WHEN OTHERS THEN
964: AP_WEB_DB_UTIL_PKG.RaiseException('GetPersonalTotalOfExpRpt');
965: APP_EXCEPTION.RAISE_EXCEPTION;
966: return FALSE;
967: END GetPersonalTotalOfExpRpt;
968:

Line 990: AP_WEB_DB_UTIL_PKG.RaiseException('CalculateAmtsDue');

986: p_emp_amt := 0;
987: p_ccard_amt := 0;
988: return FALSE;
989: WHEN OTHERS THEN
990: AP_WEB_DB_UTIL_PKG.RaiseException('CalculateAmtsDue');
991: APP_EXCEPTION.RAISE_EXCEPTION;
992: return FALSE;
993: END CalculateAmtsDue;
994:

Line 1013: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumReceiptRequiredLines');

1009: EXCEPTION
1010: WHEN NO_DATA_FOUND THEN
1011: return FALSE;
1012: WHEN OTHERS THEN
1013: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumReceiptRequiredLines');
1014: APP_EXCEPTION.RAISE_EXCEPTION;
1015: return FALSE;
1016: END GetNumReceiptRequiredLines;
1017:

Line 1042: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumReceiptShortpaidLines');

1038: EXCEPTION
1039: WHEN NO_DATA_FOUND THEN
1040: return FALSE;
1041: WHEN OTHERS THEN
1042: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumReceiptShortpaidLines');
1043: APP_EXCEPTION.RAISE_EXCEPTION;
1044: return FALSE;
1045: END GetNumReceiptShortpaidLines;
1046:

Line 1072: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumShortpaidLines');

1068: EXCEPTION
1069: WHEN NO_DATA_FOUND THEN
1070: return FALSE;
1071: WHEN OTHERS THEN
1072: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumShortpaidLines');
1073: APP_EXCEPTION.RAISE_EXCEPTION;
1074: return FALSE;
1075: END GetNumShortpaidLines;
1076:

Line 1096: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumJustReqdLines');

1092: EXCEPTION
1093: WHEN NO_DATA_FOUND THEN
1094: return FALSE;
1095: WHEN OTHERS THEN
1096: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumJustReqdLines');
1097: APP_EXCEPTION.RAISE_EXCEPTION;
1098: return FALSE;
1099: END GetNumJustReqdLines;
1100:

Line 1119: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumberOfExpLines');

1115: EXCEPTION
1116: WHEN NO_DATA_FOUND THEN
1117: return FALSE;
1118: WHEN OTHERS THEN
1119: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumberOfExpLines');
1120: APP_EXCEPTION.RAISE_EXCEPTION;
1121: return FALSE;
1122: END GetNumberOfExpLines;
1123:

Line 1141: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumCCLinesIncluded');

1137: EXCEPTION
1138: WHEN NO_DATA_FOUND THEN
1139: return FALSE;
1140: WHEN OTHERS THEN
1141: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumCCLinesIncluded');
1142: APP_EXCEPTION.RAISE_EXCEPTION;
1143: return FALSE;
1144: END GetNumCCLinesIncluded;
1145:

Line 1173: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumberOfPersonalLines');

1169: EXCEPTION
1170: WHEN NO_DATA_FOUND THEN
1171: return FALSE;
1172: WHEN OTHERS THEN
1173: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumberOfPersonalLines');
1174: APP_EXCEPTION.RAISE_EXCEPTION;
1175: return FALSE;
1176: END GetNumberOfPersonalLines;
1177:

Line 1196: AP_WEB_DB_UTIL_PKG.RaiseException( 'ContainProjectRelatedLine' );

1192: WHEN NO_DATA_FOUND THEN
1193: return FALSE;
1194:
1195: WHEN OTHERS THEN
1196: AP_WEB_DB_UTIL_PKG.RaiseException( 'ContainProjectRelatedLine' );
1197: APP_EXCEPTION.RAISE_EXCEPTION;
1198: return FALSE;
1199: END ContainsProjectRelatedLine;
1200:

Line 1218: AP_WEB_DB_UTIL_PKG.RaiseException( 'ContainsNonProjectRelatedLine' );

1214: return TRUE;
1215: WHEN NO_DATA_FOUND THEN
1216: return FALSE;
1217: WHEN OTHERS THEN
1218: AP_WEB_DB_UTIL_PKG.RaiseException( 'ContainsNonProjectRelatedLine' );
1219:
1220: APP_EXCEPTION.RAISE_EXCEPTION;
1221: return FALSE;
1222: END ContainsNonProjectRelatedLine;

Line 1517: AP_WEB_DB_UTIL_PKG.RaiseException('AddReportLines');

1513: EXCEPTION
1514: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
1515: return FALSE;
1516: WHEN OTHERS THEN
1517: AP_WEB_DB_UTIL_PKG.RaiseException('AddReportLines');
1518: APP_EXCEPTION.RAISE_EXCEPTION;
1519: return FALSE;
1520: END AddReportLines;
1521:

Line 1599: AP_WEB_DB_UTIL_PKG.RaiseException('AddPolicyShortPaidExpLines','',

1595: return TRUE;
1596:
1597: EXCEPTION -- Block which encapsulates the delete and insert code
1598: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
1599: AP_WEB_DB_UTIL_PKG.RaiseException('AddPolicyShortPaidExpLines','',
1600: 'AP_WEB_SAVESUB_DELETE_FAILED');
1601: APP_EXCEPTION.RAISE_EXCEPTION;
1602: return FALSE;
1603: WHEN OTHERS THEN

Line 1608: AP_WEB_DB_UTIL_PKG.RaiseException('AddPolicyShortPaidExpLines','',

1604: IF (SQLCODE = -00054) THEN
1605: -- Tried to obtain lock when deleting on an already locked row
1606: -- Get invoice prefix profile option, and trim if it is too long
1607: -- Get message stating delete failed
1608: AP_WEB_DB_UTIL_PKG.RaiseException('AddPolicyShortPaidExpLines','',
1609: 'AP_WEB_SAVESUB_LOCK_FAILED',
1610: 'V_ReportHeaderID = ' || p_orig_expense_report_id);
1611: APP_EXCEPTION.RAISE_EXCEPTION;
1612: return FALSE;

Line 1714: AP_WEB_DB_UTIL_PKG.RaiseException('AddUnverifiedShortpaidLines','',

1710: return TRUE;
1711:
1712: EXCEPTION -- Block which encapsulates the delete and insert code
1713: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
1714: AP_WEB_DB_UTIL_PKG.RaiseException('AddUnverifiedShortpaidLines','',
1715: 'AP_WEB_SAVESUB_DELETE_FAILED',
1716: 'V_ReportHeaderID = ' || p_orig_expense_report_id);
1717: APP_EXCEPTION.RAISE_EXCEPTION;
1718: return FALSE;

Line 1724: AP_WEB_DB_UTIL_PKG.RaiseException('AddUnverifiedShortpaidLines','',

1720: IF (SQLCODE = -00054) THEN
1721: -- Tried to obtain lock when deleting on an already locked row
1722: -- Get invoice prefix profile option, and trim if it is too long
1723: -- Get message stating delete failed
1724: AP_WEB_DB_UTIL_PKG.RaiseException('AddUnverifiedShortpaidLines','',
1725: 'AP_WEB_SAVESUB_LOCK_FAILED',
1726: 'V_ReportHeaderID = ' || p_orig_expense_report_id);
1727: APP_EXCEPTION.RAISE_EXCEPTION;
1728: return FALSE;

Line 2062: AP_WEB_DB_UTIL_PKG.RaiseException('InsertCCLine');

2058: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end InsertCCLine');
2059:
2060: EXCEPTION
2061: WHEN OTHERS THEN
2062: AP_WEB_DB_UTIL_PKG.RaiseException('InsertCCLine');
2063: APP_EXCEPTION.RAISE_EXCEPTION;
2064: END InsertCCLine;
2065:
2066: -------------------------------------------------------------------

Line 2115: AP_WEB_DB_UTIL_PKG.RaiseException('CopyCCItemizationChildLines');

2111: 'end CopyCCItemizationChildLines');
2112:
2113: EXCEPTION
2114: WHEN OTHERS THEN
2115: AP_WEB_DB_UTIL_PKG.RaiseException('CopyCCItemizationChildLines');
2116: APP_EXCEPTION.RAISE_EXCEPTION;
2117: END CopyCCItemizationChildLines;
2118:
2119: --------------------------------------------------------------------------------

Line 2166: AP_WEB_DB_UTIL_PKG.RaiseException('AddCCReportLines');

2162: EXCEPTION
2163: WHEN NO_DATA_FOUND THEN
2164: return FALSE;
2165: WHEN OTHERS THEN
2166: AP_WEB_DB_UTIL_PKG.RaiseException('AddCCReportLines');
2167: APP_EXCEPTION.RAISE_EXCEPTION;
2168: return FALSE;
2169: END AddCCReportLines;
2170:

Line 2209: AP_WEB_DB_UTIL_PKG.RaiseException('DeleteAddonRates');

2205: EXCEPTION
2206: WHEN NO_DATA_FOUND THEN
2207: NULL;
2208: WHEN OTHERS THEN
2209: AP_WEB_DB_UTIL_PKG.RaiseException('DeleteAddonRates');
2210: APP_EXCEPTION.RAISE_EXCEPTION;
2211: END DeleteAddonRates;
2212:
2213:

Line 2251: AP_WEB_DB_UTIL_PKG.RaiseException('DeletePDMDailyBreakup');

2247: EXCEPTION
2248: WHEN NO_DATA_FOUND THEN
2249: NULL;
2250: WHEN OTHERS THEN
2251: AP_WEB_DB_UTIL_PKG.RaiseException('DeletePDMDailyBreakup');
2252: APP_EXCEPTION.RAISE_EXCEPTION;
2253: END DeletePDMDailyBreakup;
2254:
2255:

Line 2293: AP_WEB_DB_UTIL_PKG.RaiseException('DeletePDMDestination');

2289: EXCEPTION
2290: WHEN NO_DATA_FOUND THEN
2291: NULL;
2292: WHEN OTHERS THEN
2293: AP_WEB_DB_UTIL_PKG.RaiseException('DeletePDMDestination');
2294: APP_EXCEPTION.RAISE_EXCEPTION;
2295: END DeletePDMDestination;
2296:
2297: --------------------------------------------------------------------------------

Line 2359: AP_WEB_DB_UTIL_PKG.RaiseException('DeleteReportLines');

2355: EXCEPTION
2356: WHEN NO_DATA_FOUND THEN
2357: return FALSE;
2358: WHEN OTHERS THEN
2359: AP_WEB_DB_UTIL_PKG.RaiseException('DeleteReportLines');
2360: APP_EXCEPTION.RAISE_EXCEPTION;
2361: return FALSE;
2362: END DeleteReportLines;
2363:

Line 2387: AP_WEB_DB_UTIL_PKG.RaiseException('DeletePersonalLines');

2383: EXCEPTION
2384: WHEN NO_DATA_FOUND THEN
2385: return FALSE;
2386: WHEN OTHERS THEN
2387: AP_WEB_DB_UTIL_PKG.RaiseException('DeletePersonalLines');
2388: APP_EXCEPTION.RAISE_EXCEPTION;
2389: return FALSE;
2390: END DeletePersonalLines;
2391:

Line 2406: AP_WEB_DB_UTIL_PKG.RaiseException('DeleteCreditReportLines');

2402: EXCEPTION
2403: WHEN NO_DATA_FOUND THEN
2404: return FALSE;
2405: WHEN OTHERS THEN
2406: AP_WEB_DB_UTIL_PKG.RaiseException('DeleteCreditReportLines');
2407: APP_EXCEPTION.RAISE_EXCEPTION;
2408: return FALSE;
2409: END DeleteCreditReportLines;
2410:

Line 2434: AP_WEB_DB_UTIL_PKG.RaiseException('SetAWTGroupIDAndJustif');

2430: EXCEPTION
2431: WHEN NO_DATA_FOUND THEN
2432: return FALSE;
2433: WHEN OTHERS THEN
2434: AP_WEB_DB_UTIL_PKG.RaiseException('SetAWTGroupIDAndJustif');
2435: APP_EXCEPTION.RAISE_EXCEPTION;
2436: return FALSE;
2437: END SetAWTGroupIDAndJustif;
2438:

Line 2454: AP_WEB_DB_UTIL_PKG.RaiseException('SetReceiptMissing');

2450: EXCEPTION
2451: WHEN NO_DATA_FOUND THEN
2452: return FALSE;
2453: WHEN OTHERS THEN
2454: AP_WEB_DB_UTIL_PKG.RaiseException('SetReceiptMissing');
2455: APP_EXCEPTION.RAISE_EXCEPTION;
2456: return FALSE;
2457: END SetReceiptMissing;
2458:

Line 2476: AP_WEB_DB_UTIL_PKG.RaiseException('SetReceiptRequired');

2472: EXCEPTION
2473: WHEN NO_DATA_FOUND THEN
2474: return FALSE;
2475: WHEN OTHERS THEN
2476: AP_WEB_DB_UTIL_PKG.RaiseException('SetReceiptRequired');
2477: APP_EXCEPTION.RAISE_EXCEPTION;
2478: return FALSE;
2479: END SetReceiptRequired;
2480:

Line 2518: AP_WEB_DB_UTIL_PKG.RaiseException('GetCCardLineCursor');

2514: EXCEPTION
2515: WHEN NO_DATA_FOUND THEN
2516: return FALSE;
2517: WHEN OTHERS THEN
2518: AP_WEB_DB_UTIL_PKG.RaiseException('GetCCardLineCursor');
2519: APP_EXCEPTION.RAISE_EXCEPTION;
2520: return FALSE;
2521: END GetCCardLineCursor;
2522:

Line 2597: AP_WEB_DB_UTIL_PKG.RaiseException('GetCCPrepaidAdjustedInvAmt');

2593:
2594:
2595: EXCEPTION
2596: WHEN OTHERS THEN
2597: AP_WEB_DB_UTIL_PKG.RaiseException('GetCCPrepaidAdjustedInvAmt');
2598: APP_EXCEPTION.RAISE_EXCEPTION;
2599: END GetCCPrepaidAdjustedInvAmt;
2600:
2601: -------------------------------------------------------------------

Line 2623: AP_WEB_DB_UTIL_PKG.RaiseException('GetReceiptsMissingFlag');

2619: p_missing_receipts_flag := 'N';
2620: return FALSE;
2621:
2622: WHEN OTHERS THEN
2623: AP_WEB_DB_UTIL_PKG.RaiseException('GetReceiptsMissingFlag');
2624: APP_EXCEPTION.RAISE_EXCEPTION;
2625: return FALSE;
2626:
2627: END GetReceiptsMissingFlag;

Line 2735: AP_WEB_DB_UTIL_PKG.RaiseException('GetExpMileageLinesCursor');

2731: EXCEPTION
2732: WHEN NO_DATA_FOUND THEN
2733: return FALSE;
2734: WHEN OTHERS THEN
2735: AP_WEB_DB_UTIL_PKG.RaiseException('GetExpMileageLinesCursor');
2736: APP_EXCEPTION.RAISE_EXCEPTION;
2737: return FALSE;
2738: END GetExpMileageLinesCursor;
2739:

Line 2772: AP_WEB_DB_UTIL_PKG.RaiseException('updateMileageExpLine: no data found');

2768:
2769:
2770: EXCEPTION
2771: WHEN NO_DATA_FOUND THEN
2772: AP_WEB_DB_UTIL_PKG.RaiseException('updateMileageExpLine: no data found');
2773: APP_EXCEPTION.RAISE_EXCEPTION;
2774: WHEN OTHERS THEN
2775: AP_WEB_DB_UTIL_PKG.RaiseException('updateMileageExpLine');
2776: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2775: AP_WEB_DB_UTIL_PKG.RaiseException('updateMileageExpLine');

2771: WHEN NO_DATA_FOUND THEN
2772: AP_WEB_DB_UTIL_PKG.RaiseException('updateMileageExpLine: no data found');
2773: APP_EXCEPTION.RAISE_EXCEPTION;
2774: WHEN OTHERS THEN
2775: AP_WEB_DB_UTIL_PKG.RaiseException('updateMileageExpLine');
2776: APP_EXCEPTION.RAISE_EXCEPTION;
2777: END updateMileageExpLine;
2778:
2779:

Line 2847: AP_WEB_DB_UTIL_PKG.RaiseException('updateExpenseMileageLines');

2843:
2844:
2845: EXCEPTION
2846: WHEN OTHERS THEN
2847: AP_WEB_DB_UTIL_PKG.RaiseException('updateExpenseMileageLines');
2848: APP_EXCEPTION.RAISE_EXCEPTION;
2849: END updateExpenseMileageLines;
2850:
2851:

Line 3207: AP_WEB_DB_UTIL_PKG.RaiseException('AddMileageExpLine','',

3203: AND ROWNUM = 1);
3204:
3205: EXCEPTION
3206: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
3207: AP_WEB_DB_UTIL_PKG.RaiseException('AddMileageExpLine','',
3208: 'AP_WEB_SAVESUB_DELETE_FAILED');
3209: APP_EXCEPTION.RAISE_EXCEPTION;
3210: WHEN OTHERS THEN
3211: AP_WEB_DB_UTIL_PKG.RaiseException('AddMileageExpLine',

Line 3211: AP_WEB_DB_UTIL_PKG.RaiseException('AddMileageExpLine',

3207: AP_WEB_DB_UTIL_PKG.RaiseException('AddMileageExpLine','',
3208: 'AP_WEB_SAVESUB_DELETE_FAILED');
3209: APP_EXCEPTION.RAISE_EXCEPTION;
3210: WHEN OTHERS THEN
3211: AP_WEB_DB_UTIL_PKG.RaiseException('AddMileageExpLine',
3212: l_debug_Info);
3213: APP_EXCEPTION.RAISE_EXCEPTION;
3214:
3215: END AddMileageExpLine;

Line 4174: AP_WEB_DB_UTIL_PKG.RaiseException('ResetAPValidationErrors');

4170: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end ResetAPValidationErrors');
4171:
4172: EXCEPTION
4173: WHEN NO_DATA_FOUND THEN
4174: AP_WEB_DB_UTIL_PKG.RaiseException('ResetAPValidationErrors');
4175: APP_EXCEPTION.RAISE_EXCEPTION;
4176: WHEN OTHERS THEN
4177: AP_WEB_DB_UTIL_PKG.RaiseException('ResetAPValidationErrors');
4178: APP_EXCEPTION.RAISE_EXCEPTION;

Line 4177: AP_WEB_DB_UTIL_PKG.RaiseException('ResetAPValidationErrors');

4173: WHEN NO_DATA_FOUND THEN
4174: AP_WEB_DB_UTIL_PKG.RaiseException('ResetAPValidationErrors');
4175: APP_EXCEPTION.RAISE_EXCEPTION;
4176: WHEN OTHERS THEN
4177: AP_WEB_DB_UTIL_PKG.RaiseException('ResetAPValidationErrors');
4178: APP_EXCEPTION.RAISE_EXCEPTION;
4179:
4180: END ResetAPValidationErrors;
4181:

Line 4203: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateAPValidationError');

4199: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end UpdateAPValidationError');
4200:
4201: EXCEPTION
4202: WHEN NO_DATA_FOUND THEN
4203: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateAPValidationError');
4204: APP_EXCEPTION.RAISE_EXCEPTION;
4205: WHEN OTHERS THEN
4206: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateAPValidationError');
4207: APP_EXCEPTION.RAISE_EXCEPTION;

Line 4206: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateAPValidationError');

4202: WHEN NO_DATA_FOUND THEN
4203: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateAPValidationError');
4204: APP_EXCEPTION.RAISE_EXCEPTION;
4205: WHEN OTHERS THEN
4206: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateAPValidationError');
4207: APP_EXCEPTION.RAISE_EXCEPTION;
4208:
4209: END UpdateAPValidationError;
4210:

Line 4234: AP_WEB_DB_UTIL_PKG.RaiseException('resetAPflags');

4230: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end resetAPflags');
4231:
4232: EXCEPTION
4233: WHEN NO_DATA_FOUND THEN
4234: AP_WEB_DB_UTIL_PKG.RaiseException('resetAPflags');
4235: APP_EXCEPTION.RAISE_EXCEPTION;
4236: WHEN OTHERS THEN
4237: AP_WEB_DB_UTIL_PKG.RaiseException('resetAPflags');
4238: APP_EXCEPTION.RAISE_EXCEPTION;

Line 4237: AP_WEB_DB_UTIL_PKG.RaiseException('resetAPflags');

4233: WHEN NO_DATA_FOUND THEN
4234: AP_WEB_DB_UTIL_PKG.RaiseException('resetAPflags');
4235: APP_EXCEPTION.RAISE_EXCEPTION;
4236: WHEN OTHERS THEN
4237: AP_WEB_DB_UTIL_PKG.RaiseException('resetAPflags');
4238: APP_EXCEPTION.RAISE_EXCEPTION;
4239:
4240: END resetAPflags;
4241:

Line 4260: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumCashLinesWOMerch');

4256: EXCEPTION
4257: WHEN NO_DATA_FOUND THEN
4258: return FALSE;
4259: WHEN OTHERS THEN
4260: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumCashLinesWOMerch');
4261: APP_EXCEPTION.RAISE_EXCEPTION;
4262: return FALSE;
4263: END GetNumCashLinesWOMerch;
4264:

Line 4581: AP_WEB_DB_UTIL_PKG.RaiseException('InsertLine','',

4577: ap_expense_report_lines_s.nextval);
4578:
4579: EXCEPTION
4580: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
4581: AP_WEB_DB_UTIL_PKG.RaiseException('InsertLine','',
4582: 'AP_WEB_SAVESUB_DELETE_FAILED');
4583: APP_EXCEPTION.RAISE_EXCEPTION;
4584: WHEN OTHERS THEN
4585: AP_WEB_DB_UTIL_PKG.RaiseException('InsertLine',

Line 4585: AP_WEB_DB_UTIL_PKG.RaiseException('InsertLine',

4581: AP_WEB_DB_UTIL_PKG.RaiseException('InsertLine','',
4582: 'AP_WEB_SAVESUB_DELETE_FAILED');
4583: APP_EXCEPTION.RAISE_EXCEPTION;
4584: WHEN OTHERS THEN
4585: AP_WEB_DB_UTIL_PKG.RaiseException('InsertLine',
4586: l_debug_Info);
4587: APP_EXCEPTION.RAISE_EXCEPTION;
4588:
4589: END InsertLine;

Line 4707: AP_WEB_DB_UTIL_PKG.RaiseException('CalculateAmtsDue');

4703: p_ccard_amt := 0;
4704: p_total_amt := 0;
4705: return FALSE;
4706: WHEN OTHERS THEN
4707: AP_WEB_DB_UTIL_PKG.RaiseException('CalculateAmtsDue');
4708: APP_EXCEPTION.RAISE_EXCEPTION;
4709: return FALSE;
4710: END CalculateAmtsDue;
4711:

Line 4733: AP_WEB_DB_UTIL_PKG.RaiseException('GetShortpaidFlag');

4729: p_shortpaid_flag := 'N';
4730: return FALSE;
4731:
4732: WHEN OTHERS THEN
4733: AP_WEB_DB_UTIL_PKG.RaiseException('GetShortpaidFlag');
4734: APP_EXCEPTION.RAISE_EXCEPTION;
4735: return FALSE;
4736:
4737: END GetShortpaidFlag;

Line 4757: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumPolicyShortpaidLines');

4753: EXCEPTION
4754: WHEN NO_DATA_FOUND THEN
4755: return FALSE;
4756: WHEN OTHERS THEN
4757: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumPolicyShortpaidLines');
4758: APP_EXCEPTION.RAISE_EXCEPTION;
4759: return FALSE;
4760: END GetNumPolicyShortpaidLines;
4761:

Line 4897: AP_WEB_DB_UTIL_PKG.RaiseException('GetCountyProvince');

4893: EXCEPTION
4894: WHEN NO_DATA_FOUND THEN
4895: RETURN p_region;
4896: WHEN OTHERS THEN
4897: AP_WEB_DB_UTIL_PKG.RaiseException('GetCountyProvince');
4898: APP_EXCEPTION.RAISE_EXCEPTION;
4899: END;
4900:
4901:

Line 4939: AP_WEB_DB_UTIL_PKG.RaiseException('GetBothPayPersonalLinesCursor');

4935: EXCEPTION
4936: WHEN NO_DATA_FOUND THEN
4937: return FALSE;
4938: WHEN OTHERS THEN
4939: AP_WEB_DB_UTIL_PKG.RaiseException('GetBothPayPersonalLinesCursor');
4940: APP_EXCEPTION.RAISE_EXCEPTION;
4941: return FALSE;
4942: END GetBothPayPersonalLinesCursor;
4943:

Line 4975: AP_WEB_DB_UTIL_PKG.RaiseException('GetNoOfBothPayPersonalLines');

4971: EXCEPTION
4972: WHEN NO_DATA_FOUND THEN
4973: return FALSE;
4974: WHEN OTHERS THEN
4975: AP_WEB_DB_UTIL_PKG.RaiseException('GetNoOfBothPayPersonalLines');
4976: APP_EXCEPTION.RAISE_EXCEPTION;
4977: return FALSE;
4978: END GetNoOfBothPayPersonalLines;
4979:

Line 5003: AP_WEB_DB_UTIL_PKG.RaiseException('clearAuditReturnReasonInstr');

4999: EXCEPTION
5000: WHEN NO_DATA_FOUND THEN
5001: RETURN ;
5002: WHEN OTHERS THEN
5003: AP_WEB_DB_UTIL_PKG.RaiseException('clearAuditReturnReasonInstr');
5004: APP_EXCEPTION.RAISE_EXCEPTION;
5005: END clearAuditReturnReasonInstr;
5006:
5007: /**

Line 5030: AP_WEB_DB_UTIL_PKG.RaiseException('AnyPolicyViolation');

5026: EXCEPTION
5027: WHEN NO_DATA_FOUND THEN
5028: return FALSE;
5029: WHEN OTHERS THEN
5030: AP_WEB_DB_UTIL_PKG.RaiseException('AnyPolicyViolation');
5031: APP_EXCEPTION.RAISE_EXCEPTION;
5032: return FALSE;
5033: END AnyPolicyViolation;
5034:

Line 5055: AP_WEB_DB_UTIL_PKG.RaiseException('GetLineCCIDCursor');

5051: EXCEPTION
5052: WHEN NO_DATA_FOUND THEN
5053: return FALSE;
5054: WHEN OTHERS THEN
5055: AP_WEB_DB_UTIL_PKG.RaiseException('GetLineCCIDCursor');
5056: APP_EXCEPTION.RAISE_EXCEPTION;
5057: return FALSE;
5058: END GetLineCCIDCursor;
5059:

Line 5085: AP_WEB_DB_UTIL_PKG.RaiseException('resetApplyAdvances');

5081: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end resetApplyAdvances');
5082:
5083: EXCEPTION
5084: WHEN NO_DATA_FOUND THEN
5085: AP_WEB_DB_UTIL_PKG.RaiseException('resetApplyAdvances');
5086: APP_EXCEPTION.RAISE_EXCEPTION;
5087: WHEN OTHERS THEN
5088: AP_WEB_DB_UTIL_PKG.RaiseException('resetApplyAdvances');
5089: APP_EXCEPTION.RAISE_EXCEPTION;

Line 5088: AP_WEB_DB_UTIL_PKG.RaiseException('resetApplyAdvances');

5084: WHEN NO_DATA_FOUND THEN
5085: AP_WEB_DB_UTIL_PKG.RaiseException('resetApplyAdvances');
5086: APP_EXCEPTION.RAISE_EXCEPTION;
5087: WHEN OTHERS THEN
5088: AP_WEB_DB_UTIL_PKG.RaiseException('resetApplyAdvances');
5089: APP_EXCEPTION.RAISE_EXCEPTION;
5090:
5091: END resetApplyAdvances;
5092: