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 27: AP_WEB_DB_UTIL_PKG.RaiseException('GetTrxIdAndAmt',

23: EXCEPTION
24: WHEN NO_DATA_FOUND THEN
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

808: p_no_receipts_ccard_amt:= 0;
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:

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

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

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

873: p_policy_emp_amt:= 0;
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:

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

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

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

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

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

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

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

988: p_emp_amt := 0;
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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1219: return TRUE;
1220: WHEN NO_DATA_FOUND THEN
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;

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

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

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

1600: return TRUE;
1601:
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

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

1609: IF (SQLCODE = -00054) THEN
1610: -- Tried to obtain lock when deleting on an already locked row
1611: -- Get invoice prefix profile option, and trim if it is too long
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;

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

1717: return TRUE;
1718:
1719: EXCEPTION -- Block which encapsulates the delete and insert code
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;

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

1727: IF (SQLCODE = -00054) THEN
1728: -- Tried to obtain lock when deleting on an already locked row
1729: -- Get invoice prefix profile option, and trim if it is too long
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;

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

1835: return TRUE;
1836:
1837: EXCEPTION -- Block which encapsulates the delete and insert code
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;

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

1845: IF (SQLCODE = -00054) THEN
1846: -- Tried to obtain lock when deleting on an already locked row
1847: -- Get invoice prefix profile option, and trim if it is too long
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;

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

1954: return TRUE;
1955:
1956: EXCEPTION -- Block which encapsulates the delete and insert code
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;

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

1964: IF (SQLCODE = -00054) THEN
1965: -- Tried to obtain lock when deleting on an already locked row
1966: -- Get invoice prefix profile option, and trim if it is too long
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;

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

2307: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end InsertCCLine');
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: -------------------------------------------------------------------

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

2360: 'end CopyCCItemizationChildLines');
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: --------------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2876: p_missing_receipts_flag := 'N';
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;

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

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

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

3038: l_currency_code);
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;

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

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;
3048:
3049:

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

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

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

3488: AND ROWNUM = 1);
3489:
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',

Line 3496: AP_WEB_DB_UTIL_PKG.RaiseException('AddMileageExpLine',

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;
3499:
3500: END AddMileageExpLine;

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

4484: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end ResetAPValidationErrors');
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;

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

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:
4494: END ResetAPValidationErrors;
4495:

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

4513: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end UpdateAPValidationError');
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;

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

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:
4523: END UpdateAPValidationError;
4524:

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

4544: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end resetAPflags');
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;

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

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:
4554: END resetAPflags;
4555:

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

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

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

4891: ap_expense_report_lines_s.nextval);
4892:
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',

Line 4899: AP_WEB_DB_UTIL_PKG.RaiseException('InsertLine',

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;
4902:
4903: END InsertLine;

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

5017: p_ccard_amt := 0;
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:

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

5043: p_shortpaid_flag := 'N';
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5397: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end resetApplyAdvances');
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;

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

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:
5407: END resetApplyAdvances;
5408:

Line 5461: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumImageShortpaidLines');

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

Line 5486: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumOriginalShortpaidLines');

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

Line 5513: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumImageShortpaidLines');

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