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.

[Home] [Help]

APPS.AP_WEB_DB_EXPLINE_PKG dependencies on APP_EXCEPTION

Line 29: APP_EXCEPTION.RAISE_EXCEPTION;

25: return FALSE;
26: WHEN OTHERS THEN
27: AP_WEB_DB_UTIL_PKG.RaiseException('GetTrxIdAndAmt',
28: l_debugInfo);
29: APP_EXCEPTION.RAISE_EXCEPTION;
30: return FALSE;
31: END GetTrxIdsAndAmtsCursor;
32:
33: --------------------------------------------------------------------------------

Line 97: APP_EXCEPTION.RAISE_EXCEPTION;

93: WHEN NO_DATA_FOUND THEN
94: return FALSE;
95: WHEN OTHERS THEN
96: AP_WEB_DB_UTIL_PKG.RaiseException('GetReportLineCursor');
97: APP_EXCEPTION.RAISE_EXCEPTION;
98: return FALSE;
99: END GetReportLineCursor;
100:
101: PROCEDURE FetchReportLineCursor(p_ReportLinesCursor IN OUT NOCOPY ReportLinesCursor,

Line 164: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 259: APP_EXCEPTION.RAISE_EXCEPTION;

255: WHEN NO_DATA_FOUND THEN
256: return FALSE;
257: WHEN OTHERS THEN
258: AP_WEB_DB_UTIL_PKG.RaiseException('GetDisplayXpenseLinesCursor');
259: APP_EXCEPTION.RAISE_EXCEPTION;
260: return FALSE;
261: END GetDisplayXpenseLinesCursor;
262:
263: --------------------------------------------------------------------------------

Line 463: APP_EXCEPTION.RAISE_EXCEPTION;

459: WHEN NO_DATA_FOUND THEN
460: return FALSE;
461: WHEN OTHERS THEN
462: AP_WEB_DB_UTIL_PKG.RaiseException('GetDisplayXpenseLinesCursor');
463: APP_EXCEPTION.RAISE_EXCEPTION;
464: return FALSE;
465: END GetDisplayXpenseLinesCursor;
466:
467: --------------------------------------------------------------------------------

Line 554: APP_EXCEPTION.RAISE_EXCEPTION;

550: WHEN NO_DATA_FOUND THEN
551: return FALSE;
552: WHEN OTHERS THEN
553: AP_WEB_DB_UTIL_PKG.RaiseException('GetDisplayPersonalLinesCursor');
554: APP_EXCEPTION.RAISE_EXCEPTION;
555: return FALSE;
556: END GetDisplayPersonalLinesCursor;
557:
558: /**

Line 583: APP_EXCEPTION.RAISE_EXCEPTION;

579: WHEN NO_DATA_FOUND THEN
580: return FALSE;
581: WHEN OTHERS THEN
582: AP_WEB_DB_UTIL_PKG.RaiseException('AnyAuditIssue');
583: APP_EXCEPTION.RAISE_EXCEPTION;
584: return FALSE;
585: END AnyAuditIssue;
586:
587:

Line 713: APP_EXCEPTION.RAISE_EXCEPTION;

709: WHEN NO_DATA_FOUND THEN
710: return FALSE;
711: WHEN OTHERS THEN
712: AP_WEB_DB_UTIL_PKG.RaiseException('GetAdjustmentsCursor');
713: APP_EXCEPTION.RAISE_EXCEPTION;
714: return FALSE;
715: END GetAdjustmentsCursor;
716:
717: /* This function was merged with the following functions:

Line 781: APP_EXCEPTION.RAISE_EXCEPTION;

777: WHEN NO_DATA_FOUND THEN
778: return FALSE;
779: WHEN OTHERS THEN
780: AP_WEB_DB_UTIL_PKG.RaiseException('GetExpDistAcctCursor');
781: APP_EXCEPTION.RAISE_EXCEPTION;
782: return FALSE;
783: END GetExpDistAcctCursor;
784:
785: -------------------------------------------------------------------

Line 813: APP_EXCEPTION.RAISE_EXCEPTION;

809: p_no_receipts_emp_amt:= 0;
810: return FALSE;
811: WHEN OTHERS THEN
812: AP_WEB_DB_UTIL_PKG.RaiseException('CalcNoReceiptsShortpayAmts');
813: APP_EXCEPTION.RAISE_EXCEPTION;
814: return FALSE;
815: END CalcNoReceiptsShortpayAmts;
816:
817:

Line 845: APP_EXCEPTION.RAISE_EXCEPTION;

841: p_personal_total:= 0;
842: return FALSE;
843: WHEN OTHERS THEN
844: AP_WEB_DB_UTIL_PKG.RaiseException('CalcNoReceiptsPersonalTotal');
845: APP_EXCEPTION.RAISE_EXCEPTION;
846: return FALSE;
847: END CalcNoReceiptsPersonalTotal;
848:
849: -------------------------------------------------------------------

Line 878: APP_EXCEPTION.RAISE_EXCEPTION;

874: p_policy_shortpay_total := 0;
875: return FALSE;
876: WHEN OTHERS THEN
877: AP_WEB_DB_UTIL_PKG.RaiseException('CalculatePolicyShortpayAmts');
878: APP_EXCEPTION.RAISE_EXCEPTION;
879: return FALSE;
880: END CalculatePolicyShortpayAmts;
881:
882: -------------------------------------------------------------------

Line 904: APP_EXCEPTION.RAISE_EXCEPTION;

900: p_sum_missing_receipts:= 0;
901: return FALSE;
902: WHEN OTHERS THEN
903: AP_WEB_DB_UTIL_PKG.RaiseException('GetReceiptMissingTotal');
904: APP_EXCEPTION.RAISE_EXCEPTION;
905: return FALSE;
906: END GetReceiptMissingTotal;
907: -------------------------------------------------------------------
908: FUNCTION GetReceiptViolationsTotal(p_report_header_id IN expLines_headerID,

Line 934: APP_EXCEPTION.RAISE_EXCEPTION;

930: p_sum_violations:= 0;
931: return FALSE;
932: WHEN OTHERS THEN
933: AP_WEB_DB_UTIL_PKG.RaiseException('GetReceiptViolationsTotal');
934: APP_EXCEPTION.RAISE_EXCEPTION;
935: return FALSE;
936: END GetReceiptViolationsTotal;
937:
938: -------------------------------------------------------------------

Line 967: APP_EXCEPTION.RAISE_EXCEPTION;

963: p_personal_total:= 0;
964: return FALSE;
965: WHEN OTHERS THEN
966: AP_WEB_DB_UTIL_PKG.RaiseException('GetPersonalTotalOfExpRpt');
967: APP_EXCEPTION.RAISE_EXCEPTION;
968: return FALSE;
969: END GetPersonalTotalOfExpRpt;
970:
971: --------------------------------------------------------------------------------

Line 993: APP_EXCEPTION.RAISE_EXCEPTION;

989: p_ccard_amt := 0;
990: return FALSE;
991: WHEN OTHERS THEN
992: AP_WEB_DB_UTIL_PKG.RaiseException('CalculateAmtsDue');
993: APP_EXCEPTION.RAISE_EXCEPTION;
994: return FALSE;
995: END CalculateAmtsDue;
996:
997: -------------------------------------------------------------------

Line 1016: APP_EXCEPTION.RAISE_EXCEPTION;

1012: WHEN NO_DATA_FOUND THEN
1013: return FALSE;
1014: WHEN OTHERS THEN
1015: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumReceiptRequiredLines');
1016: APP_EXCEPTION.RAISE_EXCEPTION;
1017: return FALSE;
1018: END GetNumReceiptRequiredLines;
1019:
1020:

Line 1045: APP_EXCEPTION.RAISE_EXCEPTION;

1041: WHEN NO_DATA_FOUND THEN
1042: return FALSE;
1043: WHEN OTHERS THEN
1044: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumReceiptShortpaidLines');
1045: APP_EXCEPTION.RAISE_EXCEPTION;
1046: return FALSE;
1047: END GetNumReceiptShortpaidLines;
1048:
1049: -------------------------------------------------------------------

Line 1078: APP_EXCEPTION.RAISE_EXCEPTION;

1074: WHEN NO_DATA_FOUND THEN
1075: return FALSE;
1076: WHEN OTHERS THEN
1077: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumShortpaidLines');
1078: APP_EXCEPTION.RAISE_EXCEPTION;
1079: return FALSE;
1080: END GetNumShortpaidLines;
1081:
1082: -------------------------------------------------------------------

Line 1102: APP_EXCEPTION.RAISE_EXCEPTION;

1098: WHEN NO_DATA_FOUND THEN
1099: return FALSE;
1100: WHEN OTHERS THEN
1101: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumJustReqdLines');
1102: APP_EXCEPTION.RAISE_EXCEPTION;
1103: return FALSE;
1104: END GetNumJustReqdLines;
1105:
1106:

Line 1125: APP_EXCEPTION.RAISE_EXCEPTION;

1121: WHEN NO_DATA_FOUND THEN
1122: return FALSE;
1123: WHEN OTHERS THEN
1124: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumberOfExpLines');
1125: APP_EXCEPTION.RAISE_EXCEPTION;
1126: return FALSE;
1127: END GetNumberOfExpLines;
1128:
1129: -------------------------------------------------------------------

Line 1147: APP_EXCEPTION.RAISE_EXCEPTION;

1143: WHEN NO_DATA_FOUND THEN
1144: return FALSE;
1145: WHEN OTHERS THEN
1146: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumCCLinesIncluded');
1147: APP_EXCEPTION.RAISE_EXCEPTION;
1148: return FALSE;
1149: END GetNumCCLinesIncluded;
1150:
1151:

Line 1179: APP_EXCEPTION.RAISE_EXCEPTION;

1175: WHEN NO_DATA_FOUND THEN
1176: return FALSE;
1177: WHEN OTHERS THEN
1178: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumberOfPersonalLines');
1179: APP_EXCEPTION.RAISE_EXCEPTION;
1180: return FALSE;
1181: END GetNumberOfPersonalLines;
1182:
1183:

Line 1202: APP_EXCEPTION.RAISE_EXCEPTION;

1198: return FALSE;
1199:
1200: WHEN OTHERS THEN
1201: AP_WEB_DB_UTIL_PKG.RaiseException( 'ContainProjectRelatedLine' );
1202: APP_EXCEPTION.RAISE_EXCEPTION;
1203: return FALSE;
1204: END ContainsProjectRelatedLine;
1205:
1206:

Line 1225: APP_EXCEPTION.RAISE_EXCEPTION;

1221: return FALSE;
1222: WHEN OTHERS THEN
1223: AP_WEB_DB_UTIL_PKG.RaiseException( 'ContainsNonProjectRelatedLine' );
1224:
1225: APP_EXCEPTION.RAISE_EXCEPTION;
1226: return FALSE;
1227: END ContainsNonProjectRelatedLine;
1228:
1229: --------------------------------------------------------------------------------

Line 1523: APP_EXCEPTION.RAISE_EXCEPTION;

1519: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
1520: return FALSE;
1521: WHEN OTHERS THEN
1522: AP_WEB_DB_UTIL_PKG.RaiseException('AddReportLines');
1523: APP_EXCEPTION.RAISE_EXCEPTION;
1524: return FALSE;
1525: END AddReportLines;
1526:
1527:

Line 1606: APP_EXCEPTION.RAISE_EXCEPTION;

1602: EXCEPTION -- Block which encapsulates the delete and insert code
1603: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
1604: AP_WEB_DB_UTIL_PKG.RaiseException('AddPolicyShortPaidExpLines','',
1605: 'AP_WEB_SAVESUB_DELETE_FAILED');
1606: APP_EXCEPTION.RAISE_EXCEPTION;
1607: return FALSE;
1608: WHEN OTHERS THEN
1609: IF (SQLCODE = -00054) THEN
1610: -- Tried to obtain lock when deleting on an already locked row

Line 1616: APP_EXCEPTION.RAISE_EXCEPTION;

1612: -- Get message stating delete failed
1613: AP_WEB_DB_UTIL_PKG.RaiseException('AddPolicyShortPaidExpLines','',
1614: 'AP_WEB_SAVESUB_LOCK_FAILED',
1615: 'V_ReportHeaderID = ' || p_orig_expense_report_id);
1616: APP_EXCEPTION.RAISE_EXCEPTION;
1617: return FALSE;
1618: END IF;
1619: END AddPolicyShortPaidExpLines;
1620:

Line 1724: APP_EXCEPTION.RAISE_EXCEPTION;

1720: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
1721: AP_WEB_DB_UTIL_PKG.RaiseException('AddUnverifiedShortpaidLines','',
1722: 'AP_WEB_SAVESUB_DELETE_FAILED',
1723: 'V_ReportHeaderID = ' || p_orig_expense_report_id);
1724: APP_EXCEPTION.RAISE_EXCEPTION;
1725: return FALSE;
1726: WHEN OTHERS THEN
1727: IF (SQLCODE = -00054) THEN
1728: -- Tried to obtain lock when deleting on an already locked row

Line 1734: APP_EXCEPTION.RAISE_EXCEPTION;

1730: -- Get message stating delete failed
1731: AP_WEB_DB_UTIL_PKG.RaiseException('AddUnverifiedShortpaidLines','',
1732: 'AP_WEB_SAVESUB_LOCK_FAILED',
1733: 'V_ReportHeaderID = ' || p_orig_expense_report_id);
1734: APP_EXCEPTION.RAISE_EXCEPTION;
1735: return FALSE;
1736: END IF;
1737: END AddUnverifiedShortpaidLines;
1738:

Line 1842: APP_EXCEPTION.RAISE_EXCEPTION;

1838: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
1839: AP_WEB_DB_UTIL_PKG.RaiseException('AddUnverifiedShortpaidLines','',
1840: 'AP_WEB_SAVESUB_DELETE_FAILED',
1841: 'V_ReportHeaderID = ' || p_orig_expense_report_id);
1842: APP_EXCEPTION.RAISE_EXCEPTION;
1843: return FALSE;
1844: WHEN OTHERS THEN
1845: IF (SQLCODE = -00054) THEN
1846: -- Tried to obtain lock when deleting on an already locked row

Line 1852: APP_EXCEPTION.RAISE_EXCEPTION;

1848: -- Get message stating delete failed
1849: AP_WEB_DB_UTIL_PKG.RaiseException('AddUnverifiedShortpaidLines','',
1850: 'AP_WEB_SAVESUB_LOCK_FAILED',
1851: 'V_ReportHeaderID = ' || p_orig_expense_report_id);
1852: APP_EXCEPTION.RAISE_EXCEPTION;
1853: return FALSE;
1854: END IF;
1855: END AddUnverifiedImgShortpaidLines;
1856:

Line 1961: APP_EXCEPTION.RAISE_EXCEPTION;

1957: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
1958: AP_WEB_DB_UTIL_PKG.RaiseException('AddUnverifiedShortpaidLines','',
1959: 'AP_WEB_SAVESUB_DELETE_FAILED',
1960: 'V_ReportHeaderID = ' || p_orig_expense_report_id);
1961: APP_EXCEPTION.RAISE_EXCEPTION;
1962: return FALSE;
1963: WHEN OTHERS THEN
1964: IF (SQLCODE = -00054) THEN
1965: -- Tried to obtain lock when deleting on an already locked row

Line 1971: APP_EXCEPTION.RAISE_EXCEPTION;

1967: -- Get message stating delete failed
1968: AP_WEB_DB_UTIL_PKG.RaiseException('AddUnverifiedShortpaidLines','',
1969: 'AP_WEB_SAVESUB_LOCK_FAILED',
1970: 'V_ReportHeaderID = ' || p_orig_expense_report_id);
1971: APP_EXCEPTION.RAISE_EXCEPTION;
1972: return FALSE;
1973: END IF;
1974: END AddUnverifiedBtShortpaidLines;
1975:

Line 2312: APP_EXCEPTION.RAISE_EXCEPTION;

2308:
2309: EXCEPTION
2310: WHEN OTHERS THEN
2311: AP_WEB_DB_UTIL_PKG.RaiseException('InsertCCLine');
2312: APP_EXCEPTION.RAISE_EXCEPTION;
2313: END InsertCCLine;
2314:
2315: -------------------------------------------------------------------
2316: -- Name: CopyCCItemizationChildLines

Line 2365: APP_EXCEPTION.RAISE_EXCEPTION;

2361:
2362: EXCEPTION
2363: WHEN OTHERS THEN
2364: AP_WEB_DB_UTIL_PKG.RaiseException('CopyCCItemizationChildLines');
2365: APP_EXCEPTION.RAISE_EXCEPTION;
2366: END CopyCCItemizationChildLines;
2367:
2368: --------------------------------------------------------------------------------
2369: FUNCTION AddCCReportLines(p_report_header_id IN expLines_headerID,

Line 2416: APP_EXCEPTION.RAISE_EXCEPTION;

2412: WHEN NO_DATA_FOUND THEN
2413: return FALSE;
2414: WHEN OTHERS THEN
2415: AP_WEB_DB_UTIL_PKG.RaiseException('AddCCReportLines');
2416: APP_EXCEPTION.RAISE_EXCEPTION;
2417: return FALSE;
2418: END AddCCReportLines;
2419:
2420:

Line 2459: APP_EXCEPTION.RAISE_EXCEPTION;

2455: WHEN NO_DATA_FOUND THEN
2456: NULL;
2457: WHEN OTHERS THEN
2458: AP_WEB_DB_UTIL_PKG.RaiseException('DeleteAddonRates');
2459: APP_EXCEPTION.RAISE_EXCEPTION;
2460: END DeleteAddonRates;
2461:
2462:
2463: -----------------------------------------------------------------------------

Line 2501: APP_EXCEPTION.RAISE_EXCEPTION;

2497: WHEN NO_DATA_FOUND THEN
2498: NULL;
2499: WHEN OTHERS THEN
2500: AP_WEB_DB_UTIL_PKG.RaiseException('DeletePDMDailyBreakup');
2501: APP_EXCEPTION.RAISE_EXCEPTION;
2502: END DeletePDMDailyBreakup;
2503:
2504:
2505: -----------------------------------------------------------------------------

Line 2543: APP_EXCEPTION.RAISE_EXCEPTION;

2539: WHEN NO_DATA_FOUND THEN
2540: NULL;
2541: WHEN OTHERS THEN
2542: AP_WEB_DB_UTIL_PKG.RaiseException('DeletePDMDestination');
2543: APP_EXCEPTION.RAISE_EXCEPTION;
2544: END DeletePDMDestination;
2545:
2546: --------------------------------------------------------------------------------
2547: FUNCTION DeleteReportLines(P_ReportID IN expLines_headerID)

Line 2609: APP_EXCEPTION.RAISE_EXCEPTION;

2605: WHEN NO_DATA_FOUND THEN
2606: return FALSE;
2607: WHEN OTHERS THEN
2608: AP_WEB_DB_UTIL_PKG.RaiseException('DeleteReportLines');
2609: APP_EXCEPTION.RAISE_EXCEPTION;
2610: return FALSE;
2611: END DeleteReportLines;
2612:
2613:

Line 2645: APP_EXCEPTION.RAISE_EXCEPTION;

2641: WHEN NO_DATA_FOUND THEN
2642: return FALSE;
2643: WHEN OTHERS THEN
2644: AP_WEB_DB_UTIL_PKG.RaiseException('DeletePersonalLines');
2645: APP_EXCEPTION.RAISE_EXCEPTION;
2646: return FALSE;
2647: END DeletePersonalLines;
2648:
2649:

Line 2664: APP_EXCEPTION.RAISE_EXCEPTION;

2660: WHEN NO_DATA_FOUND THEN
2661: return FALSE;
2662: WHEN OTHERS THEN
2663: AP_WEB_DB_UTIL_PKG.RaiseException('DeleteCreditReportLines');
2664: APP_EXCEPTION.RAISE_EXCEPTION;
2665: return FALSE;
2666: END DeleteCreditReportLines;
2667:
2668:

Line 2692: APP_EXCEPTION.RAISE_EXCEPTION;

2688: WHEN NO_DATA_FOUND THEN
2689: return FALSE;
2690: WHEN OTHERS THEN
2691: AP_WEB_DB_UTIL_PKG.RaiseException('SetAWTGroupIDAndJustif');
2692: APP_EXCEPTION.RAISE_EXCEPTION;
2693: return FALSE;
2694: END SetAWTGroupIDAndJustif;
2695:
2696: -------------------------------------------------------------------

Line 2712: APP_EXCEPTION.RAISE_EXCEPTION;

2708: WHEN NO_DATA_FOUND THEN
2709: return FALSE;
2710: WHEN OTHERS THEN
2711: AP_WEB_DB_UTIL_PKG.RaiseException('SetReceiptMissing');
2712: APP_EXCEPTION.RAISE_EXCEPTION;
2713: return FALSE;
2714: END SetReceiptMissing;
2715:
2716:

Line 2734: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 2746: APP_EXCEPTION.RAISE_EXCEPTION;

2742: --------------------------------------------------------------------------------
2743: l_parameterId number;
2744: BEGIN
2745: if (AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_parameterId) <> TRUE) then
2746: APP_EXCEPTION.RAISE_EXCEPTION;
2747: end if;
2748:
2749: -- Bug 3253775: Included personal credit card transactions in the cursor and
2750: -- negated the personal transaction amt to be deducted later from invoice total.

Line 2776: APP_EXCEPTION.RAISE_EXCEPTION;

2772: WHEN NO_DATA_FOUND THEN
2773: return FALSE;
2774: WHEN OTHERS THEN
2775: AP_WEB_DB_UTIL_PKG.RaiseException('GetCCardLineCursor');
2776: APP_EXCEPTION.RAISE_EXCEPTION;
2777: return FALSE;
2778: END GetCCardLineCursor;
2779:
2780: --------------------------------------------------------------------------------

Line 2806: APP_EXCEPTION.RAISE_EXCEPTION;

2802: * lines
2803: */
2804: /*
2805: if (AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_parameterId) <> TRUE) then
2806: APP_EXCEPTION.RAISE_EXCEPTION;
2807: end if;
2808:
2809: SELECT sum(erl.amount)
2810: INTO l_prepaid_amt

Line 2855: APP_EXCEPTION.RAISE_EXCEPTION;

2851:
2852: EXCEPTION
2853: WHEN OTHERS THEN
2854: AP_WEB_DB_UTIL_PKG.RaiseException('GetCCPrepaidAdjustedInvAmt');
2855: APP_EXCEPTION.RAISE_EXCEPTION;
2856: END GetCCPrepaidAdjustedInvAmt;
2857:
2858: -------------------------------------------------------------------
2859: FUNCTION GetReceiptsMissingFlag( p_report_header_id IN expLines_headerID,

Line 2881: APP_EXCEPTION.RAISE_EXCEPTION;

2877: return FALSE;
2878:
2879: WHEN OTHERS THEN
2880: AP_WEB_DB_UTIL_PKG.RaiseException('GetReceiptsMissingFlag');
2881: APP_EXCEPTION.RAISE_EXCEPTION;
2882: return FALSE;
2883:
2884: END GetReceiptsMissingFlag;
2885: --------------------------------------------------------------------------------

Line 2993: APP_EXCEPTION.RAISE_EXCEPTION;

2989: WHEN NO_DATA_FOUND THEN
2990: return FALSE;
2991: WHEN OTHERS THEN
2992: AP_WEB_DB_UTIL_PKG.RaiseException('GetExpMileageLinesCursor');
2993: APP_EXCEPTION.RAISE_EXCEPTION;
2994: return FALSE;
2995: END GetExpMileageLinesCursor;
2996:
2997: --------------------------------------------------------------------------------

Line 3043: APP_EXCEPTION.RAISE_EXCEPTION;

3039:
3040: EXCEPTION
3041: WHEN NO_DATA_FOUND THEN
3042: AP_WEB_DB_UTIL_PKG.RaiseException('updateMileageExpLine: no data found');
3043: APP_EXCEPTION.RAISE_EXCEPTION;
3044: WHEN OTHERS THEN
3045: AP_WEB_DB_UTIL_PKG.RaiseException('updateMileageExpLine');
3046: APP_EXCEPTION.RAISE_EXCEPTION;
3047: END updateMileageExpLine;

Line 3046: APP_EXCEPTION.RAISE_EXCEPTION;

3042: AP_WEB_DB_UTIL_PKG.RaiseException('updateMileageExpLine: no data found');
3043: APP_EXCEPTION.RAISE_EXCEPTION;
3044: WHEN OTHERS THEN
3045: AP_WEB_DB_UTIL_PKG.RaiseException('updateMileageExpLine');
3046: APP_EXCEPTION.RAISE_EXCEPTION;
3047: END updateMileageExpLine;
3048:
3049:
3050: --------------------------------------------------------------------------------

Line 3133: APP_EXCEPTION.RAISE_EXCEPTION;

3129:
3130: EXCEPTION
3131: WHEN OTHERS THEN
3132: AP_WEB_DB_UTIL_PKG.RaiseException('updateExpenseMileageLines');
3133: APP_EXCEPTION.RAISE_EXCEPTION;
3134: END updateExpenseMileageLines;
3135:
3136:
3137: --------------------------------------------------------------------------------

Line 3494: APP_EXCEPTION.RAISE_EXCEPTION;

3490: EXCEPTION
3491: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
3492: AP_WEB_DB_UTIL_PKG.RaiseException('AddMileageExpLine','',
3493: 'AP_WEB_SAVESUB_DELETE_FAILED');
3494: APP_EXCEPTION.RAISE_EXCEPTION;
3495: WHEN OTHERS THEN
3496: AP_WEB_DB_UTIL_PKG.RaiseException('AddMileageExpLine',
3497: l_debug_Info);
3498: APP_EXCEPTION.RAISE_EXCEPTION;

Line 3498: APP_EXCEPTION.RAISE_EXCEPTION;

3494: APP_EXCEPTION.RAISE_EXCEPTION;
3495: WHEN OTHERS THEN
3496: AP_WEB_DB_UTIL_PKG.RaiseException('AddMileageExpLine',
3497: l_debug_Info);
3498: APP_EXCEPTION.RAISE_EXCEPTION;
3499:
3500: END AddMileageExpLine;
3501:
3502:

Line 4489: APP_EXCEPTION.RAISE_EXCEPTION;

4485:
4486: EXCEPTION
4487: WHEN NO_DATA_FOUND THEN
4488: AP_WEB_DB_UTIL_PKG.RaiseException('ResetAPValidationErrors');
4489: APP_EXCEPTION.RAISE_EXCEPTION;
4490: WHEN OTHERS THEN
4491: AP_WEB_DB_UTIL_PKG.RaiseException('ResetAPValidationErrors');
4492: APP_EXCEPTION.RAISE_EXCEPTION;
4493:

Line 4492: APP_EXCEPTION.RAISE_EXCEPTION;

4488: AP_WEB_DB_UTIL_PKG.RaiseException('ResetAPValidationErrors');
4489: APP_EXCEPTION.RAISE_EXCEPTION;
4490: WHEN OTHERS THEN
4491: AP_WEB_DB_UTIL_PKG.RaiseException('ResetAPValidationErrors');
4492: APP_EXCEPTION.RAISE_EXCEPTION;
4493:
4494: END ResetAPValidationErrors;
4495:
4496: -------------------------------------------------------------------

Line 4518: APP_EXCEPTION.RAISE_EXCEPTION;

4514:
4515: EXCEPTION
4516: WHEN NO_DATA_FOUND THEN
4517: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateAPValidationError');
4518: APP_EXCEPTION.RAISE_EXCEPTION;
4519: WHEN OTHERS THEN
4520: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateAPValidationError');
4521: APP_EXCEPTION.RAISE_EXCEPTION;
4522:

Line 4521: APP_EXCEPTION.RAISE_EXCEPTION;

4517: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateAPValidationError');
4518: APP_EXCEPTION.RAISE_EXCEPTION;
4519: WHEN OTHERS THEN
4520: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateAPValidationError');
4521: APP_EXCEPTION.RAISE_EXCEPTION;
4522:
4523: END UpdateAPValidationError;
4524:
4525: -------------------------------------------------------------------

Line 4549: APP_EXCEPTION.RAISE_EXCEPTION;

4545:
4546: EXCEPTION
4547: WHEN NO_DATA_FOUND THEN
4548: AP_WEB_DB_UTIL_PKG.RaiseException('resetAPflags');
4549: APP_EXCEPTION.RAISE_EXCEPTION;
4550: WHEN OTHERS THEN
4551: AP_WEB_DB_UTIL_PKG.RaiseException('resetAPflags');
4552: APP_EXCEPTION.RAISE_EXCEPTION;
4553:

Line 4552: APP_EXCEPTION.RAISE_EXCEPTION;

4548: AP_WEB_DB_UTIL_PKG.RaiseException('resetAPflags');
4549: APP_EXCEPTION.RAISE_EXCEPTION;
4550: WHEN OTHERS THEN
4551: AP_WEB_DB_UTIL_PKG.RaiseException('resetAPflags');
4552: APP_EXCEPTION.RAISE_EXCEPTION;
4553:
4554: END resetAPflags;
4555:
4556: -------------------------------------------------------------------

Line 4575: APP_EXCEPTION.RAISE_EXCEPTION;

4571: WHEN NO_DATA_FOUND THEN
4572: return FALSE;
4573: WHEN OTHERS THEN
4574: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumCashLinesWOMerch');
4575: APP_EXCEPTION.RAISE_EXCEPTION;
4576: return FALSE;
4577: END GetNumCashLinesWOMerch;
4578:
4579: -------------------------------------------------------------------

Line 4897: APP_EXCEPTION.RAISE_EXCEPTION;

4893: EXCEPTION
4894: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
4895: AP_WEB_DB_UTIL_PKG.RaiseException('InsertLine','',
4896: 'AP_WEB_SAVESUB_DELETE_FAILED');
4897: APP_EXCEPTION.RAISE_EXCEPTION;
4898: WHEN OTHERS THEN
4899: AP_WEB_DB_UTIL_PKG.RaiseException('InsertLine',
4900: l_debug_Info);
4901: APP_EXCEPTION.RAISE_EXCEPTION;

Line 4901: APP_EXCEPTION.RAISE_EXCEPTION;

4897: APP_EXCEPTION.RAISE_EXCEPTION;
4898: WHEN OTHERS THEN
4899: AP_WEB_DB_UTIL_PKG.RaiseException('InsertLine',
4900: l_debug_Info);
4901: APP_EXCEPTION.RAISE_EXCEPTION;
4902:
4903: END InsertLine;
4904:
4905: /**

Line 5022: APP_EXCEPTION.RAISE_EXCEPTION;

5018: p_total_amt := 0;
5019: return FALSE;
5020: WHEN OTHERS THEN
5021: AP_WEB_DB_UTIL_PKG.RaiseException('CalculateAmtsDue');
5022: APP_EXCEPTION.RAISE_EXCEPTION;
5023: return FALSE;
5024: END CalculateAmtsDue;
5025:
5026: /**

Line 5048: APP_EXCEPTION.RAISE_EXCEPTION;

5044: return FALSE;
5045:
5046: WHEN OTHERS THEN
5047: AP_WEB_DB_UTIL_PKG.RaiseException('GetShortpaidFlag');
5048: APP_EXCEPTION.RAISE_EXCEPTION;
5049: return FALSE;
5050:
5051: END GetShortpaidFlag;
5052:

Line 5073: APP_EXCEPTION.RAISE_EXCEPTION;

5069: WHEN NO_DATA_FOUND THEN
5070: return FALSE;
5071: WHEN OTHERS THEN
5072: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumPolicyShortpaidLines');
5073: APP_EXCEPTION.RAISE_EXCEPTION;
5074: return FALSE;
5075: END GetNumPolicyShortpaidLines;
5076:
5077: FUNCTION GetAdjustedLineExists(p_report_header_id IN expLines_headerID)

Line 5213: APP_EXCEPTION.RAISE_EXCEPTION;

5209: WHEN NO_DATA_FOUND THEN
5210: RETURN p_region;
5211: WHEN OTHERS THEN
5212: AP_WEB_DB_UTIL_PKG.RaiseException('GetCountyProvince');
5213: APP_EXCEPTION.RAISE_EXCEPTION;
5214: END;
5215:
5216:
5217:

Line 5255: APP_EXCEPTION.RAISE_EXCEPTION;

5251: WHEN NO_DATA_FOUND THEN
5252: return FALSE;
5253: WHEN OTHERS THEN
5254: AP_WEB_DB_UTIL_PKG.RaiseException('GetBothPayPersonalLinesCursor');
5255: APP_EXCEPTION.RAISE_EXCEPTION;
5256: return FALSE;
5257: END GetBothPayPersonalLinesCursor;
5258:
5259:

Line 5291: APP_EXCEPTION.RAISE_EXCEPTION;

5287: WHEN NO_DATA_FOUND THEN
5288: return FALSE;
5289: WHEN OTHERS THEN
5290: AP_WEB_DB_UTIL_PKG.RaiseException('GetNoOfBothPayPersonalLines');
5291: APP_EXCEPTION.RAISE_EXCEPTION;
5292: return FALSE;
5293: END GetNoOfBothPayPersonalLines;
5294:
5295: -----------------------------------------------------------------------------

Line 5320: APP_EXCEPTION.RAISE_EXCEPTION;

5316: WHEN NO_DATA_FOUND THEN
5317: RETURN ;
5318: WHEN OTHERS THEN
5319: AP_WEB_DB_UTIL_PKG.RaiseException('clearAuditReturnReasonInstr');
5320: APP_EXCEPTION.RAISE_EXCEPTION;
5321: END clearAuditReturnReasonInstr;
5322:
5323: /**
5324: * aling

Line 5347: APP_EXCEPTION.RAISE_EXCEPTION;

5343: WHEN NO_DATA_FOUND THEN
5344: return FALSE;
5345: WHEN OTHERS THEN
5346: AP_WEB_DB_UTIL_PKG.RaiseException('AnyPolicyViolation');
5347: APP_EXCEPTION.RAISE_EXCEPTION;
5348: return FALSE;
5349: END AnyPolicyViolation;
5350:
5351: --------------------------------------------------------------------------------

Line 5372: APP_EXCEPTION.RAISE_EXCEPTION;

5368: WHEN NO_DATA_FOUND THEN
5369: return FALSE;
5370: WHEN OTHERS THEN
5371: AP_WEB_DB_UTIL_PKG.RaiseException('GetLineCCIDCursor');
5372: APP_EXCEPTION.RAISE_EXCEPTION;
5373: return FALSE;
5374: END GetLineCCIDCursor;
5375:
5376: -------------------------------------------------------------------

Line 5402: APP_EXCEPTION.RAISE_EXCEPTION;

5398:
5399: EXCEPTION
5400: WHEN NO_DATA_FOUND THEN
5401: AP_WEB_DB_UTIL_PKG.RaiseException('resetApplyAdvances');
5402: APP_EXCEPTION.RAISE_EXCEPTION;
5403: WHEN OTHERS THEN
5404: AP_WEB_DB_UTIL_PKG.RaiseException('resetApplyAdvances');
5405: APP_EXCEPTION.RAISE_EXCEPTION;
5406:

Line 5405: APP_EXCEPTION.RAISE_EXCEPTION;

5401: AP_WEB_DB_UTIL_PKG.RaiseException('resetApplyAdvances');
5402: APP_EXCEPTION.RAISE_EXCEPTION;
5403: WHEN OTHERS THEN
5404: AP_WEB_DB_UTIL_PKG.RaiseException('resetApplyAdvances');
5405: APP_EXCEPTION.RAISE_EXCEPTION;
5406:
5407: END resetApplyAdvances;
5408:
5409: -- 5666256: fp of 5464957 when accessing confirmation page from e-mail or comming from DBI

Line 5462: APP_EXCEPTION.RAISE_EXCEPTION;

5458: WHEN NO_DATA_FOUND THEN
5459: return FALSE;
5460: WHEN OTHERS THEN
5461: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumImageShortpaidLines');
5462: APP_EXCEPTION.RAISE_EXCEPTION;
5463: return FALSE;
5464:
5465: END GetNumImageShortpaidLines;
5466:

Line 5487: APP_EXCEPTION.RAISE_EXCEPTION;

5483: WHEN NO_DATA_FOUND THEN
5484: return FALSE;
5485: WHEN OTHERS THEN
5486: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumOriginalShortpaidLines');
5487: APP_EXCEPTION.RAISE_EXCEPTION;
5488: return FALSE;
5489:
5490: END GetNumOriginalShortpaidLines;
5491:

Line 5514: APP_EXCEPTION.RAISE_EXCEPTION;

5510: WHEN NO_DATA_FOUND THEN
5511: return FALSE;
5512: WHEN OTHERS THEN
5513: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumImageShortpaidLines');
5514: APP_EXCEPTION.RAISE_EXCEPTION;
5515: return FALSE;
5516:
5517: END GetNumBothShortpaidLines;
5518: