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 473: AP_WEB_DB_UTIL_PKG.RaiseException('GetAccountingInfo');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1569: AP_WEB_DB_UTIL_PKG.RaiseException('GetDefaultEmpCCID',

1565: EXCEPTION
1566: WHEN NO_DATA_FOUND THEN
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;

Line 1616: AP_WEB_DB_UTIL_PKG.RaiseException('GetChartOfAccountsID',

1612: EXCEPTION
1613: WHEN NO_DATA_FOUND THEN
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;

Line 1645: AP_WEB_DB_UTIL_PKG.RaiseException('GetFlexConcactenated',

1641: EXCEPTION
1642: WHEN NO_DATA_FOUND THEN
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;

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

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

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

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

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

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

Line 1906: AP_WEB_DB_UTIL_PKG.RaiseException('CopyAttachments');

1902: END LOOP;
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;