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 474: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 539: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 569: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 640: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 651: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 869: APP_EXCEPTION.RAISE_EXCEPTION;

865: WHEN NO_DATA_FOUND THEN
866: return FALSE;
867: WHEN OTHERS THEN
868: AP_WEB_DB_UTIL_PKG.RaiseException('InsertReportHeaderLikeExisting');
869: APP_EXCEPTION.RAISE_EXCEPTION;
870: return FALSE;
871: END InsertReportHeaderLikeExisting;
872:
873: FUNCTION SetDefaultExchRateType(p_report_header_id IN expHdr_headerID,

Line 887: APP_EXCEPTION.RAISE_EXCEPTION;

883: WHEN NO_DATA_FOUND THEN
884: return FALSE;
885: WHEN OTHERS THEN
886: AP_WEB_DB_UTIL_PKG.RaiseException('SetDefaultExchRateType');
887: APP_EXCEPTION.RAISE_EXCEPTION;
888: return FALSE;
889: END SetDefaultExchRateType;
890:
891: ------------------------------------------------------------------

Line 932: APP_EXCEPTION.RAISE_EXCEPTION;

928: WHEN NO_DATA_FOUND THEN
929: return FALSE;
930: WHEN OTHERS THEN
931: AP_WEB_DB_UTIL_PKG.RaiseException('SetExpenseHeaderInfo');
932: APP_EXCEPTION.RAISE_EXCEPTION;
933: return FALSE;
934: END SetExpenseHeaderInfo;
935:
936:

Line 975: APP_EXCEPTION.RAISE_EXCEPTION;

971: WHEN NO_DATA_FOUND THEN
972: return FALSE;
973: WHEN OTHERS THEN
974: AP_WEB_DB_UTIL_PKG.RaiseException('SetAmtDuesAndTotal');
975: APP_EXCEPTION.RAISE_EXCEPTION;
976: return FALSE;
977: END SetAmtDuesAndTotal;
978:
979:

Line 1021: APP_EXCEPTION.RAISE_EXCEPTION;

1017: WHEN NO_DATA_FOUND THEN
1018: return FALSE;
1019: WHEN OTHERS THEN
1020: AP_WEB_DB_UTIL_PKG.RaiseException('SetBothpayReportHeader');
1021: APP_EXCEPTION.RAISE_EXCEPTION;
1022: return FALSE;
1023: END SetBothpayReportHeader;
1024:
1025: -------------------------------------------------------------------

Line 1048: APP_EXCEPTION.RAISE_EXCEPTION;

1044: WHEN NO_DATA_FOUND THEN
1045: return FALSE;
1046: WHEN OTHERS THEN
1047: AP_WEB_DB_UTIL_PKG.RaiseException('SetWkflApprvdFlagAndSource');
1048: APP_EXCEPTION.RAISE_EXCEPTION;
1049: return FALSE;
1050: END SetWkflApprvdFlagAndSource;
1051:
1052:

Line 1076: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 1100: APP_EXCEPTION.RAISE_EXCEPTION;

1096: WHEN NO_DATA_FOUND THEN
1097: return FALSE;
1098: WHEN OTHERS THEN
1099: AP_WEB_DB_UTIL_PKG.RaiseException('SetWkflApprvdFlag2');
1100: APP_EXCEPTION.RAISE_EXCEPTION;
1101: return FALSE;
1102: END SetWkflApprvdFlag2;
1103:
1104: -------------------------------------------------------------------

Line 1136: APP_EXCEPTION.RAISE_EXCEPTION;

1132: WHEN NO_DATA_FOUND THEN
1133: return FALSE;
1134: WHEN OTHERS THEN
1135: AP_WEB_DB_UTIL_PKG.RaiseException('DeleteReportHeaderAtDate');
1136: APP_EXCEPTION.RAISE_EXCEPTION;
1137: return FALSE;
1138: END DeleteReportHeaderAtDate;
1139:
1140:

Line 1170: APP_EXCEPTION.RAISE_EXCEPTION;

1166: WHEN NO_DATA_FOUND THEN
1167: return FALSE;
1168: WHEN OTHERS THEN
1169: AP_WEB_DB_UTIL_PKG.RaiseException('DeleteExpenseReport');
1170: APP_EXCEPTION.RAISE_EXCEPTION;
1171: return FALSE;
1172: END DeleteExpenseReport;
1173:
1174: -------------------------------------------------------------------

Line 1195: APP_EXCEPTION.RAISE_EXCEPTION;

1191:
1192: EXCEPTION
1193: WHEN OTHERS THEN
1194: AP_WEB_DB_UTIL_PKG.RaiseException('ResubmitExpenseReport');
1195: APP_EXCEPTION.RAISE_EXCEPTION;
1196: return FALSE;
1197: END ResubmitExpenseReport;
1198:
1199:

Line 1394: APP_EXCEPTION.RAISE_EXCEPTION;

1390: WHEN NO_DATA_FOUND THEN
1391: return FALSE;
1392: WHEN OTHERS THEN
1393: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateHeaderTotal');
1394: APP_EXCEPTION.RAISE_EXCEPTION;
1395: return FALSE;
1396: END UpdateHeaderTotal;
1397:
1398: --------------------------------------------------------------------------------

Line 1418: APP_EXCEPTION.RAISE_EXCEPTION;

1414: WHEN NO_DATA_FOUND THEN
1415: return FALSE;
1416: WHEN OTHERS THEN
1417: AP_WEB_DB_UTIL_PKG.RaiseException('GetReimbCurr');
1418: APP_EXCEPTION.RAISE_EXCEPTION;
1419: return FALSE;
1420:
1421: END GetReimbCurr;
1422: -------------------------------------------------------------------

Line 1439: APP_EXCEPTION.RAISE_EXCEPTION;

1435: WHEN NO_DATA_FOUND THEN
1436: return FALSE;
1437: WHEN OTHERS THEN
1438: AP_WEB_DB_UTIL_PKG.RaiseException('GetHeaderTotal');
1439: APP_EXCEPTION.RAISE_EXCEPTION;
1440: return FALSE;
1441: END GetHeaderTotal ;
1442: -------------------------------------------------------------------
1443:

Line 1474: APP_EXCEPTION.RAISE_EXCEPTION;

1470: RETURN FALSE;
1471:
1472: WHEN OTHERS THEN
1473: AP_WEB_DB_UTIL_PKG.RaiseException( 'getPaymentDueFromReport');
1474: APP_EXCEPTION.RAISE_EXCEPTION;
1475:
1476: END getPaymentDueFromReport;
1477: -----------------------------------------------------------------------------
1478:

Line 1508: APP_EXCEPTION.RAISE_EXCEPTION;

1504: WHEN NO_DATA_FOUND THEN
1505: RETURN false;
1506: WHEN OTHERS THEN
1507: AP_WEB_DB_UTIL_PKG.RaiseException('getAuditReturnReasonInstr');
1508: APP_EXCEPTION.RAISE_EXCEPTION;
1509: END getAuditReturnReasonInstr;
1510:
1511: -----------------------------------------------------------------------------
1512: /*Written By :Ron Langi

Line 1534: APP_EXCEPTION.RAISE_EXCEPTION;

1530: WHEN NO_DATA_FOUND THEN
1531: RETURN ;
1532: WHEN OTHERS THEN
1533: AP_WEB_DB_UTIL_PKG.RaiseException('clearAuditReturnReasonInstr');
1534: APP_EXCEPTION.RAISE_EXCEPTION;
1535: END clearAuditReturnReasonInstr;
1536:
1537: --------------------------------------------------------------------------------
1538: FUNCTION GetDefaultEmpCCID(

Line 1571: APP_EXCEPTION.RAISE_EXCEPTION;

1567: return FALSE;
1568: WHEN OTHERS THEN
1569: AP_WEB_DB_UTIL_PKG.RaiseException('GetDefaultEmpCCID',
1570: l_debugInfo);
1571: APP_EXCEPTION.RAISE_EXCEPTION;
1572: return FALSE;
1573: END GetDefaultEmpCCID;
1574:
1575: --------------------------------------------------------------------------------

Line 1618: APP_EXCEPTION.RAISE_EXCEPTION;

1614: return FALSE;
1615: WHEN OTHERS THEN
1616: AP_WEB_DB_UTIL_PKG.RaiseException('GetChartOfAccountsID',
1617: l_debugInfo);
1618: APP_EXCEPTION.RAISE_EXCEPTION;
1619: return FALSE;
1620: END GetChartOfAccountsID;
1621:
1622:

Line 1647: APP_EXCEPTION.RAISE_EXCEPTION;

1643: return FALSE;
1644: WHEN OTHERS THEN
1645: AP_WEB_DB_UTIL_PKG.RaiseException('GetFlexConcactenated',
1646: l_debugInfo);
1647: APP_EXCEPTION.RAISE_EXCEPTION;
1648: return FALSE;
1649: END GetFlexConcactenated;
1650:
1651: /*Written By :Maulik Vadera

Line 1689: APP_EXCEPTION.RAISE_EXCEPTION;

1685: return l_invoice_num;
1686: EXCEPTION
1687: WHEN OTHERS THEN
1688: AP_WEB_DB_UTIL_PKG.RaiseException('GetERInvoiceNumber');
1689: APP_EXCEPTION.RAISE_EXCEPTION;
1690: END GetERInvoiceNumber;
1691:
1692: ------------------------------------------------------------------------
1693: -- FUNCTION GetERWorkflowApproved

Line 1711: APP_EXCEPTION.RAISE_EXCEPTION;

1707: return l_workflow_approved_flag;
1708: EXCEPTION
1709: WHEN OTHERS THEN
1710: AP_WEB_DB_UTIL_PKG.RaiseException('GetERWorkflowApprovedFlag');
1711: APP_EXCEPTION.RAISE_EXCEPTION;
1712: END GetERWorkflowApprovedFlag;
1713:
1714: FUNCTION GetERLastUpdateDate(p_report_header_id IN NUMBER)
1715: RETURN VARCHAR2 IS

Line 1728: APP_EXCEPTION.RAISE_EXCEPTION;

1724: return l_last_update_date;
1725: EXCEPTION
1726: WHEN OTHERS THEN
1727: AP_WEB_DB_UTIL_PKG.RaiseException('GetERLastUpdateDate');
1728: APP_EXCEPTION.RAISE_EXCEPTION;
1729: END GetERLastUpdateDate;
1730:
1731: ------------------------------------------------------------------------
1732: -- FUNCTION CopyAttachments

Line 1907: APP_EXCEPTION.RAISE_EXCEPTION;

1903:
1904: EXCEPTION
1905: WHEN OTHERS THEN
1906: AP_WEB_DB_UTIL_PKG.RaiseException('CopyAttachments');
1907: APP_EXCEPTION.RAISE_EXCEPTION;
1908: END CopyAttachments;
1909:
1910: END AP_WEB_DB_EXPRPT_PKG;