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 APP_EXCEPTION

Line 27: APP_EXCEPTION.RAISE_EXCEPTION;

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;
30:
31: --------------------------------------------------------------------------------

Line 95: APP_EXCEPTION.RAISE_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:
99: PROCEDURE FetchReportLineCursor(p_ReportLinesCursor IN OUT NOCOPY ReportLinesCursor,

Line 162: APP_EXCEPTION.RAISE_EXCEPTION;

158: WHEN OTHERS THEN
159: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
160: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
161: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','FetchReportLineCursor');
162: APP_EXCEPTION.RAISE_EXCEPTION;
163:
164: END FetchReportLineCursor;
165:
166:

Line 257: APP_EXCEPTION.RAISE_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:
261: --------------------------------------------------------------------------------

Line 461: APP_EXCEPTION.RAISE_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:
465: --------------------------------------------------------------------------------

Line 552: APP_EXCEPTION.RAISE_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:
556: /**

Line 581: APP_EXCEPTION.RAISE_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:
585:

Line 711: APP_EXCEPTION.RAISE_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:
715: /* This function was merged with the following functions:

Line 779: APP_EXCEPTION.RAISE_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:
783: -------------------------------------------------------------------

Line 811: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 843: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 876: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 902: APP_EXCEPTION.RAISE_EXCEPTION;

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: -------------------------------------------------------------------
906: FUNCTION GetReceiptViolationsTotal(p_report_header_id IN expLines_headerID,

Line 932: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 965: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 991: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 1014: APP_EXCEPTION.RAISE_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:
1018:

Line 1043: APP_EXCEPTION.RAISE_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:
1047: -------------------------------------------------------------------

Line 1073: APP_EXCEPTION.RAISE_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:
1077: -------------------------------------------------------------------

Line 1097: APP_EXCEPTION.RAISE_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:
1101:

Line 1120: APP_EXCEPTION.RAISE_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:
1124: -------------------------------------------------------------------

Line 1142: APP_EXCEPTION.RAISE_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:
1146:

Line 1174: APP_EXCEPTION.RAISE_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:
1178:

Line 1197: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 1220: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1223:
1224: --------------------------------------------------------------------------------

Line 1518: APP_EXCEPTION.RAISE_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:
1522:

Line 1601: APP_EXCEPTION.RAISE_EXCEPTION;

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
1604: IF (SQLCODE = -00054) THEN
1605: -- Tried to obtain lock when deleting on an already locked row

Line 1611: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1613: END IF;
1614: END AddPolicyShortPaidExpLines;
1615:

Line 1717: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1719: WHEN OTHERS THEN
1720: IF (SQLCODE = -00054) THEN
1721: -- Tried to obtain lock when deleting on an already locked row

Line 1727: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1729: END IF;
1730: END AddUnverifiedShortpaidLines;
1731:

Line 2063: APP_EXCEPTION.RAISE_EXCEPTION;

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: -------------------------------------------------------------------
2067: -- Name: CopyCCItemizationChildLines

Line 2116: APP_EXCEPTION.RAISE_EXCEPTION;

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: --------------------------------------------------------------------------------
2120: FUNCTION AddCCReportLines(p_report_header_id IN expLines_headerID,

Line 2167: APP_EXCEPTION.RAISE_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:
2171:

Line 2210: APP_EXCEPTION.RAISE_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:
2214: -----------------------------------------------------------------------------

Line 2252: APP_EXCEPTION.RAISE_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:
2256: -----------------------------------------------------------------------------

Line 2294: APP_EXCEPTION.RAISE_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: --------------------------------------------------------------------------------
2298: FUNCTION DeleteReportLines(P_ReportID IN expLines_headerID)

Line 2360: APP_EXCEPTION.RAISE_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:
2364:

Line 2388: APP_EXCEPTION.RAISE_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:
2392:

Line 2407: APP_EXCEPTION.RAISE_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:
2411:

Line 2435: APP_EXCEPTION.RAISE_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:
2439: -------------------------------------------------------------------

Line 2455: APP_EXCEPTION.RAISE_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:
2459:

Line 2477: APP_EXCEPTION.RAISE_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:
2481: --------------------------------------------------------------------------------

Line 2489: APP_EXCEPTION.RAISE_EXCEPTION;

2485: --------------------------------------------------------------------------------
2486: l_parameterId number;
2487: BEGIN
2488: if (AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_parameterId) <> TRUE) then
2489: APP_EXCEPTION.RAISE_EXCEPTION;
2490: end if;
2491:
2492: -- Bug 3253775: Included personal credit card transactions in the cursor and
2493: -- negated the personal transaction amt to be deducted later from invoice total.

Line 2519: APP_EXCEPTION.RAISE_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:
2523: --------------------------------------------------------------------------------

Line 2549: APP_EXCEPTION.RAISE_EXCEPTION;

2545: * lines
2546: */
2547: /*
2548: if (AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_parameterId) <> TRUE) then
2549: APP_EXCEPTION.RAISE_EXCEPTION;
2550: end if;
2551:
2552: SELECT sum(erl.amount)
2553: INTO l_prepaid_amt

Line 2598: APP_EXCEPTION.RAISE_EXCEPTION;

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: -------------------------------------------------------------------
2602: FUNCTION GetReceiptsMissingFlag( p_report_header_id IN expLines_headerID,

Line 2624: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 2736: APP_EXCEPTION.RAISE_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:
2740: --------------------------------------------------------------------------------

Line 2773: APP_EXCEPTION.RAISE_EXCEPTION;

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;
2777: END updateMileageExpLine;

Line 2776: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 2848: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 3209: APP_EXCEPTION.RAISE_EXCEPTION;

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',
3212: l_debug_Info);
3213: APP_EXCEPTION.RAISE_EXCEPTION;

Line 3213: APP_EXCEPTION.RAISE_EXCEPTION;

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;
3216:
3217:

Line 4175: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 4178: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 4204: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 4207: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 4235: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 4238: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 4261: APP_EXCEPTION.RAISE_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:
4265: -------------------------------------------------------------------

Line 4583: APP_EXCEPTION.RAISE_EXCEPTION;

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',
4586: l_debug_Info);
4587: APP_EXCEPTION.RAISE_EXCEPTION;

Line 4587: APP_EXCEPTION.RAISE_EXCEPTION;

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;
4590:
4591: /**

Line 4708: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 4734: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 4758: APP_EXCEPTION.RAISE_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:
4762: FUNCTION GetAdjustedLineExists(p_report_header_id IN expLines_headerID)

Line 4898: APP_EXCEPTION.RAISE_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:
4902:

Line 4940: APP_EXCEPTION.RAISE_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:
4944:

Line 4976: APP_EXCEPTION.RAISE_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:
4980: -----------------------------------------------------------------------------

Line 5004: APP_EXCEPTION.RAISE_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: /**
5008: * aling

Line 5031: APP_EXCEPTION.RAISE_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:
5035: --------------------------------------------------------------------------------

Line 5056: APP_EXCEPTION.RAISE_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:
5060: -------------------------------------------------------------------

Line 5086: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 5089: APP_EXCEPTION.RAISE_EXCEPTION;

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:
5093: -- 5666256: fp of 5464957 when accessing confirmation page from e-mail or comming from DBI