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_EXPRPT_PKG dependencies on APP_EXCEPTION

Line 23: APP_EXCEPTION.RAISE_EXCEPTION;

19:
20: EXCEPTION
21: WHEN OTHERS THEN
22: AP_WEB_DB_UTIL_PKG.RaiseException('GetEmployeeIdFromBothPayParent');
23: APP_EXCEPTION.RAISE_EXCEPTION;
24: END GetEmployeeIdFromBothPayParent;
25:
26:
27:

Line 75: APP_EXCEPTION.RAISE_EXCEPTION;

71: WHEN NO_DATA_FOUND THEN
72: return FALSE;
73: WHEN OTHERS THEN
74: AP_WEB_DB_UTIL_PKG.RaiseException('GetRestorableReportsCursor');
75: APP_EXCEPTION.RAISE_EXCEPTION;
76: return FALSE;
77: END GetRestorableReportsCursor;
78:
79:

Line 103: APP_EXCEPTION.RAISE_EXCEPTION;

99: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
100: return FALSE;
101: WHEN OTHERS THEN
102: AP_WEB_DB_UTIL_PKG.RaiseException(l_curr_calling_sequence, l_debug_info);
103: APP_EXCEPTION.RAISE_EXCEPTION;
104: return FALSE;
105:
106: END GetExpWorkflowInfo;
107:

Line 137: APP_EXCEPTION.RAISE_EXCEPTION;

133: WHEN NO_DATA_FOUND THEN
134: return FALSE;
135: WHEN OTHERS THEN
136: AP_WEB_DB_UTIL_PKG.RaiseException('GetReportInfo');
137: APP_EXCEPTION.RAISE_EXCEPTION;
138: return FALSE;
139:
140: END GetReportInfo;
141:

Line 160: APP_EXCEPTION.RAISE_EXCEPTION;

156: WHEN NO_DATA_FOUND THEN
157: return FALSE;
158: WHEN OTHERS THEN
159: AP_WEB_DB_UTIL_PKG.RaiseException('GetOverrideApproverID');
160: APP_EXCEPTION.RAISE_EXCEPTION;
161: return FALSE;
162:
163: END GetOverrideApproverID;
164:

Line 183: APP_EXCEPTION.RAISE_EXCEPTION;

179: WHEN NO_DATA_FOUND THEN
180: return FALSE;
181: WHEN OTHERS THEN
182: AP_WEB_DB_UTIL_PKG.RaiseException('GetOrgIdByReportHeaderId');
183: APP_EXCEPTION.RAISE_EXCEPTION;
184: return FALSE;
185: END GetOrgIdByReportHeaderId;
186:
187: -------------------------------------------------------------------

Line 269: APP_EXCEPTION.RAISE_EXCEPTION;

265: WHEN NO_DATA_FOUND THEN
266: return FALSE;
267: WHEN OTHERS THEN
268: AP_WEB_DB_UTIL_PKG.RaiseException('GetReportHeaderAttributes');
269: APP_EXCEPTION.RAISE_EXCEPTION;
270: return FALSE;
271: END GetReportHeaderAttributes;
272:
273:

Line 319: APP_EXCEPTION.RAISE_EXCEPTION;

315: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
316: return FALSE;
317: WHEN OTHERS THEN
318: AP_WEB_DB_UTIL_PKG.RaiseException('GetReportHeaderInfo');
319: APP_EXCEPTION.RAISE_EXCEPTION;
320: return FALSE;
321: END GetReportHeaderInfo;
322:
323:

Line 346: APP_EXCEPTION.RAISE_EXCEPTION;

342: WHEN NO_DATA_FOUND THEN
343: return FALSE;
344: WHEN OTHERS THEN
345: AP_WEB_DB_UTIL_PKG.RaiseException('GetExpReportExchCurrInfo');
346: APP_EXCEPTION.RAISE_EXCEPTION;
347: return FALSE;
348: END GetExpReportExchCurrInfo;
349:
350:

Line 369: APP_EXCEPTION.RAISE_EXCEPTION;

365: WHEN NO_DATA_FOUND THEN
366: return FALSE;
367: WHEN OTHERS THEN
368: AP_WEB_DB_UTIL_PKG.RaiseException('GetNextExpReportID', l_debug_info);
369: APP_EXCEPTION.RAISE_EXCEPTION;
370: return FALSE;
371: END GetNextExpReportID;
372:
373: -------------------------------------------------------------------

Line 391: APP_EXCEPTION.RAISE_EXCEPTION;

387: WHEN NO_DATA_FOUND THEN
388: return FALSE;
389: WHEN OTHERS THEN
390: AP_WEB_DB_UTIL_PKG.RaiseException('GetNextRptHdrID', l_debug_info);
391: APP_EXCEPTION.RAISE_EXCEPTION;
392: return FALSE;
393: END GetNextRptHdrID;
394:
395: -------------------------------------------------------------------

Line 472: APP_EXCEPTION.RAISE_EXCEPTION;

468: WHEN NO_DATA_FOUND THEN
469: return FALSE;
470: WHEN OTHERS THEN
471: AP_WEB_DB_UTIL_PKG.RaiseException('GetAccountingInfo');
472: APP_EXCEPTION.RAISE_EXCEPTION;
473: return FALSE;
474: END GetAccountingInfo;
475:
476:

Line 537: APP_EXCEPTION.RAISE_EXCEPTION;

533: WHEN NO_DATA_FOUND THEN
534: return FALSE;
535: WHEN OTHERS THEN
536: AP_WEB_DB_UTIL_PKG.RaiseException('GetExpReportInfo');
537: APP_EXCEPTION.RAISE_EXCEPTION;
538: return FALSE;
539: END GetExpReportInfo;
540:
541:

Line 567: APP_EXCEPTION.RAISE_EXCEPTION;

563: WHEN NO_DATA_FOUND THEN
564: return FALSE;
565: WHEN OTHERS THEN
566: AP_WEB_DB_UTIL_PKG.RaiseException('ExpReportShortpaid');
567: APP_EXCEPTION.RAISE_EXCEPTION;
568: return FALSE;
569: END ExpReportShortpaid;
570:
571: -------------------------------------------------------------------

Line 638: APP_EXCEPTION.RAISE_EXCEPTION;

634: AP_WEB_DB_UTIL_PKG.RaiseException('InsertReportHeader',l_debug_info,
635: 'AP_WEB_SAVESUB_DELETE_FAILED',
636: 'V_ReportHeaderID = ' || p_xpense_rec.report_header_id
637: ||', Invoice Num = '|| p_xpense_rec.document_number);
638: APP_EXCEPTION.RAISE_EXCEPTION;
639: return FALSE;
640: WHEN OTHERS THEN
641: IF (SQLCODE = -00054) THEN
642: -- Tried to obtain lock when deleting on an already locked row

Line 649: APP_EXCEPTION.RAISE_EXCEPTION;

645: AP_WEB_DB_UTIL_PKG.RaiseException('InsertReportHeader',l_debug_info,
646: 'AP_WEB_SAVESUB_LOCK_FAILED',
647: 'V_ReportHeaderID = ' || p_xpense_rec.report_header_id
648: );
649: APP_EXCEPTION.RAISE_EXCEPTION;
650: END IF;
651: return FALSE;
652: END InsertReportHeader; -- Block which encapsulates the delete and insert code
653:

Line 859: APP_EXCEPTION.RAISE_EXCEPTION;

855: WHEN NO_DATA_FOUND THEN
856: return FALSE;
857: WHEN OTHERS THEN
858: AP_WEB_DB_UTIL_PKG.RaiseException('InsertReportHeaderLikeExisting');
859: APP_EXCEPTION.RAISE_EXCEPTION;
860: return FALSE;
861: END InsertReportHeaderLikeExisting;
862:
863: FUNCTION SetDefaultExchRateType(p_report_header_id IN expHdr_headerID,

Line 877: APP_EXCEPTION.RAISE_EXCEPTION;

873: WHEN NO_DATA_FOUND THEN
874: return FALSE;
875: WHEN OTHERS THEN
876: AP_WEB_DB_UTIL_PKG.RaiseException('SetDefaultExchRateType');
877: APP_EXCEPTION.RAISE_EXCEPTION;
878: return FALSE;
879: END SetDefaultExchRateType;
880:
881: ------------------------------------------------------------------

Line 922: APP_EXCEPTION.RAISE_EXCEPTION;

918: WHEN NO_DATA_FOUND THEN
919: return FALSE;
920: WHEN OTHERS THEN
921: AP_WEB_DB_UTIL_PKG.RaiseException('SetExpenseHeaderInfo');
922: APP_EXCEPTION.RAISE_EXCEPTION;
923: return FALSE;
924: END SetExpenseHeaderInfo;
925:
926:

Line 965: APP_EXCEPTION.RAISE_EXCEPTION;

961: WHEN NO_DATA_FOUND THEN
962: return FALSE;
963: WHEN OTHERS THEN
964: AP_WEB_DB_UTIL_PKG.RaiseException('SetAmtDuesAndTotal');
965: APP_EXCEPTION.RAISE_EXCEPTION;
966: return FALSE;
967: END SetAmtDuesAndTotal;
968:
969:

Line 1011: APP_EXCEPTION.RAISE_EXCEPTION;

1007: WHEN NO_DATA_FOUND THEN
1008: return FALSE;
1009: WHEN OTHERS THEN
1010: AP_WEB_DB_UTIL_PKG.RaiseException('SetBothpayReportHeader');
1011: APP_EXCEPTION.RAISE_EXCEPTION;
1012: return FALSE;
1013: END SetBothpayReportHeader;
1014:
1015: -------------------------------------------------------------------

Line 1036: APP_EXCEPTION.RAISE_EXCEPTION;

1032: WHEN NO_DATA_FOUND THEN
1033: return FALSE;
1034: WHEN OTHERS THEN
1035: AP_WEB_DB_UTIL_PKG.RaiseException('SetWkflApprvdFlagAndSource');
1036: APP_EXCEPTION.RAISE_EXCEPTION;
1037: return FALSE;
1038: END SetWkflApprvdFlagAndSource;
1039:
1040:

Line 1064: APP_EXCEPTION.RAISE_EXCEPTION;

1060: WHEN NO_DATA_FOUND THEN
1061: return FALSE;
1062: WHEN OTHERS THEN
1063: AP_WEB_DB_UTIL_PKG.RaiseException('SetWkflApprvdFlag');
1064: APP_EXCEPTION.RAISE_EXCEPTION;
1065: return FALSE;
1066: END SetWkflApprvdFlag;
1067:
1068: -------------------------------------------------------------------

Line 1088: APP_EXCEPTION.RAISE_EXCEPTION;

1084: WHEN NO_DATA_FOUND THEN
1085: return FALSE;
1086: WHEN OTHERS THEN
1087: AP_WEB_DB_UTIL_PKG.RaiseException('SetWkflApprvdFlag2');
1088: APP_EXCEPTION.RAISE_EXCEPTION;
1089: return FALSE;
1090: END SetWkflApprvdFlag2;
1091:
1092: -------------------------------------------------------------------

Line 1124: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 1158: APP_EXCEPTION.RAISE_EXCEPTION;

1154: WHEN NO_DATA_FOUND THEN
1155: return FALSE;
1156: WHEN OTHERS THEN
1157: AP_WEB_DB_UTIL_PKG.RaiseException('DeleteExpenseReport');
1158: APP_EXCEPTION.RAISE_EXCEPTION;
1159: return FALSE;
1160: END DeleteExpenseReport;
1161:
1162: -------------------------------------------------------------------

Line 1183: APP_EXCEPTION.RAISE_EXCEPTION;

1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: AP_WEB_DB_UTIL_PKG.RaiseException('ResubmitExpenseReport');
1183: APP_EXCEPTION.RAISE_EXCEPTION;
1184: return FALSE;
1185: END ResubmitExpenseReport;
1186:
1187:

Line 1380: APP_EXCEPTION.RAISE_EXCEPTION;

1376: WHEN NO_DATA_FOUND THEN
1377: return FALSE;
1378: WHEN OTHERS THEN
1379: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateHeaderTotal');
1380: APP_EXCEPTION.RAISE_EXCEPTION;
1381: return FALSE;
1382: END UpdateHeaderTotal;
1383:
1384: --------------------------------------------------------------------------------

Line 1404: APP_EXCEPTION.RAISE_EXCEPTION;

1400: WHEN NO_DATA_FOUND THEN
1401: return FALSE;
1402: WHEN OTHERS THEN
1403: AP_WEB_DB_UTIL_PKG.RaiseException('GetReimbCurr');
1404: APP_EXCEPTION.RAISE_EXCEPTION;
1405: return FALSE;
1406:
1407: END GetReimbCurr;
1408: -------------------------------------------------------------------

Line 1425: APP_EXCEPTION.RAISE_EXCEPTION;

1421: WHEN NO_DATA_FOUND THEN
1422: return FALSE;
1423: WHEN OTHERS THEN
1424: AP_WEB_DB_UTIL_PKG.RaiseException('GetHeaderTotal');
1425: APP_EXCEPTION.RAISE_EXCEPTION;
1426: return FALSE;
1427: END GetHeaderTotal ;
1428: -------------------------------------------------------------------
1429:

Line 1460: APP_EXCEPTION.RAISE_EXCEPTION;

1456: RETURN FALSE;
1457:
1458: WHEN OTHERS THEN
1459: AP_WEB_DB_UTIL_PKG.RaiseException( 'getPaymentDueFromReport');
1460: APP_EXCEPTION.RAISE_EXCEPTION;
1461:
1462: END getPaymentDueFromReport;
1463: -----------------------------------------------------------------------------
1464:

Line 1494: APP_EXCEPTION.RAISE_EXCEPTION;

1490: WHEN NO_DATA_FOUND THEN
1491: RETURN false;
1492: WHEN OTHERS THEN
1493: AP_WEB_DB_UTIL_PKG.RaiseException('getAuditReturnReasonInstr');
1494: APP_EXCEPTION.RAISE_EXCEPTION;
1495: END getAuditReturnReasonInstr;
1496:
1497: -----------------------------------------------------------------------------
1498: /*Written By :Ron Langi

Line 1520: APP_EXCEPTION.RAISE_EXCEPTION;

1516: WHEN NO_DATA_FOUND THEN
1517: RETURN ;
1518: WHEN OTHERS THEN
1519: AP_WEB_DB_UTIL_PKG.RaiseException('clearAuditReturnReasonInstr');
1520: APP_EXCEPTION.RAISE_EXCEPTION;
1521: END clearAuditReturnReasonInstr;
1522:
1523: --------------------------------------------------------------------------------
1524: FUNCTION GetDefaultEmpCCID(

Line 1557: APP_EXCEPTION.RAISE_EXCEPTION;

1553: return FALSE;
1554: WHEN OTHERS THEN
1555: AP_WEB_DB_UTIL_PKG.RaiseException('GetDefaultEmpCCID',
1556: l_debugInfo);
1557: APP_EXCEPTION.RAISE_EXCEPTION;
1558: return FALSE;
1559: END GetDefaultEmpCCID;
1560:
1561: --------------------------------------------------------------------------------

Line 1604: APP_EXCEPTION.RAISE_EXCEPTION;

1600: return FALSE;
1601: WHEN OTHERS THEN
1602: AP_WEB_DB_UTIL_PKG.RaiseException('GetChartOfAccountsID',
1603: l_debugInfo);
1604: APP_EXCEPTION.RAISE_EXCEPTION;
1605: return FALSE;
1606: END GetChartOfAccountsID;
1607:
1608:

Line 1633: APP_EXCEPTION.RAISE_EXCEPTION;

1629: return FALSE;
1630: WHEN OTHERS THEN
1631: AP_WEB_DB_UTIL_PKG.RaiseException('GetFlexConcactenated',
1632: l_debugInfo);
1633: APP_EXCEPTION.RAISE_EXCEPTION;
1634: return FALSE;
1635: END GetFlexConcactenated;
1636:
1637: /*Written By :Maulik Vadera

Line 1675: APP_EXCEPTION.RAISE_EXCEPTION;

1671: return l_invoice_num;
1672: EXCEPTION
1673: WHEN OTHERS THEN
1674: AP_WEB_DB_UTIL_PKG.RaiseException('GetERInvoiceNumber');
1675: APP_EXCEPTION.RAISE_EXCEPTION;
1676: END GetERInvoiceNumber;
1677:
1678: ------------------------------------------------------------------------
1679: -- FUNCTION GetERWorkflowApproved

Line 1697: APP_EXCEPTION.RAISE_EXCEPTION;

1693: return l_workflow_approved_flag;
1694: EXCEPTION
1695: WHEN OTHERS THEN
1696: AP_WEB_DB_UTIL_PKG.RaiseException('GetERWorkflowApprovedFlag');
1697: APP_EXCEPTION.RAISE_EXCEPTION;
1698: END GetERWorkflowApprovedFlag;
1699:
1700: FUNCTION GetERLastUpdateDate(p_report_header_id IN NUMBER)
1701: RETURN VARCHAR2 IS

Line 1714: APP_EXCEPTION.RAISE_EXCEPTION;

1710: return l_last_update_date;
1711: EXCEPTION
1712: WHEN OTHERS THEN
1713: AP_WEB_DB_UTIL_PKG.RaiseException('GetERLastUpdateDate');
1714: APP_EXCEPTION.RAISE_EXCEPTION;
1715: END GetERLastUpdateDate;
1716:
1717: END AP_WEB_DB_EXPRPT_PKG;