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 AP_WEB_DB_UTIL_PKG

Line 22: AP_WEB_DB_UTIL_PKG.RaiseException('GetEmployeeIdFromBothPayParent');

18: WHERE report_header_id = p_bothpay_parent_id;
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:

Line 74: AP_WEB_DB_UTIL_PKG.RaiseException('GetRestorableReportsCursor');

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

Line 102: AP_WEB_DB_UTIL_PKG.RaiseException(l_curr_calling_sequence, l_debug_info);

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

Line 136: AP_WEB_DB_UTIL_PKG.RaiseException('GetReportInfo');

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

Line 159: AP_WEB_DB_UTIL_PKG.RaiseException('GetOverrideApproverID');

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

Line 182: AP_WEB_DB_UTIL_PKG.RaiseException('GetOrgIdByReportHeaderId');

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

Line 268: AP_WEB_DB_UTIL_PKG.RaiseException('GetReportHeaderAttributes');

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

Line 298: TO_CHAR(last_update_date,AP_WEB_DB_UTIL_PKG.C_DetailedDateFormat)

294: flex_concatenated,
295: TO_CHAR(override_approver_id),
296: override_approver_name,
297: employee_id,
298: TO_CHAR(last_update_date,AP_WEB_DB_UTIL_PKG.C_DetailedDateFormat)
299: INTO P_ExpHdrRec.template_id,
300: P_ExpHdrRec.last_receipt_date,
301: P_ExpHdrRec.description,
302: P_ExpHdrRec.default_curr_code,

Line 318: AP_WEB_DB_UTIL_PKG.RaiseException('GetReportHeaderInfo');

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

Line 345: AP_WEB_DB_UTIL_PKG.RaiseException('GetExpReportExchCurrInfo');

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

Line 368: AP_WEB_DB_UTIL_PKG.RaiseException('GetNextExpReportID', l_debug_info);

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

Line 390: AP_WEB_DB_UTIL_PKG.RaiseException('GetNextRptHdrID', l_debug_info);

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

Line 471: AP_WEB_DB_UTIL_PKG.RaiseException('GetAccountingInfo');

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

Line 536: AP_WEB_DB_UTIL_PKG.RaiseException('GetExpReportInfo');

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

Line 566: AP_WEB_DB_UTIL_PKG.RaiseException('ExpReportShortpaid');

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

Line 634: AP_WEB_DB_UTIL_PKG.RaiseException('InsertReportHeader',l_debug_info,

630:
631: return TRUE;
632: EXCEPTION -- Block which encapsulates the delete and insert code
633: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
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;

Line 645: AP_WEB_DB_UTIL_PKG.RaiseException('InsertReportHeader',l_debug_info,

641: IF (SQLCODE = -00054) THEN
642: -- Tried to obtain lock when deleting on an already locked row
643: -- Get invoice prefix profile option, and trim if it is too long
644: -- Get message stating delete failed
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;

Line 858: AP_WEB_DB_UTIL_PKG.RaiseException('InsertReportHeaderLikeExisting');

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

Line 876: AP_WEB_DB_UTIL_PKG.RaiseException('SetDefaultExchRateType');

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

Line 921: AP_WEB_DB_UTIL_PKG.RaiseException('SetExpenseHeaderInfo');

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

Line 964: AP_WEB_DB_UTIL_PKG.RaiseException('SetAmtDuesAndTotal');

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

Line 1010: AP_WEB_DB_UTIL_PKG.RaiseException('SetBothpayReportHeader');

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

Line 1035: AP_WEB_DB_UTIL_PKG.RaiseException('SetWkflApprvdFlagAndSource');

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

Line 1063: AP_WEB_DB_UTIL_PKG.RaiseException('SetWkflApprvdFlag');

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

Line 1087: AP_WEB_DB_UTIL_PKG.RaiseException('SetWkflApprvdFlag2');

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

Line 1123: AP_WEB_DB_UTIL_PKG.RaiseException('DeleteReportHeaderAtDate');

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

Line 1157: AP_WEB_DB_UTIL_PKG.RaiseException('DeleteExpenseReport');

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

Line 1182: AP_WEB_DB_UTIL_PKG.RaiseException('ResubmitExpenseReport');

1178: end if;
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:

Line 1379: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateHeaderTotal');

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

Line 1403: AP_WEB_DB_UTIL_PKG.RaiseException('GetReimbCurr');

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

Line 1424: AP_WEB_DB_UTIL_PKG.RaiseException('GetHeaderTotal');

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

Line 1459: AP_WEB_DB_UTIL_PKG.RaiseException( 'getPaymentDueFromReport');

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

Line 1493: AP_WEB_DB_UTIL_PKG.RaiseException('getAuditReturnReasonInstr');

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

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

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

Line 1555: AP_WEB_DB_UTIL_PKG.RaiseException('GetDefaultEmpCCID',

1551: EXCEPTION
1552: WHEN NO_DATA_FOUND THEN
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;

Line 1602: AP_WEB_DB_UTIL_PKG.RaiseException('GetChartOfAccountsID',

1598: EXCEPTION
1599: WHEN NO_DATA_FOUND THEN
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;

Line 1631: AP_WEB_DB_UTIL_PKG.RaiseException('GetFlexConcactenated',

1627: EXCEPTION
1628: WHEN NO_DATA_FOUND THEN
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;

Line 1674: AP_WEB_DB_UTIL_PKG.RaiseException('GetERInvoiceNumber');

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

Line 1696: AP_WEB_DB_UTIL_PKG.RaiseException('GetERWorkflowApprovedFlag');

1692:
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)

Line 1713: AP_WEB_DB_UTIL_PKG.RaiseException('GetERLastUpdateDate');

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