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.IBY_VALIDATIONSETS_PUB dependencies on DBMS_XMLQUERY

Line 5874: l_ctx DBMS_XMLQuery.ctxType;

5870: IS
5871: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.getXMLClob';
5872: l_xml_clob CLOB := NULL;
5873:
5874: l_ctx DBMS_XMLQuery.ctxType;
5875: l_sql VARCHAR2(2000);
5876: l_sqlcode NUMBER;
5877: l_sqlerrm VARCHAR2(300);
5878:

Line 5903: l_ctx := DBMS_XMLQuery.newContext(l_sql);

5899: || 'FROM iby_docs_payable_all '
5900: || 'WHERE payment_service_request_id = :payreq_id '
5901: || 'AND document_status <> :doc_status';
5902:
5903: l_ctx := DBMS_XMLQuery.newContext(l_sql);
5904: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
5905: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_VALIDATED);
5906: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
5907:

Line 5904: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);

5900: || 'WHERE payment_service_request_id = :payreq_id '
5901: || 'AND document_status <> :doc_status';
5902:
5903: l_ctx := DBMS_XMLQuery.newContext(l_sql);
5904: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
5905: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_VALIDATED);
5906: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
5907:
5908: /* raise an exception if no rows were found */

Line 5905: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_VALIDATED);

5901: || 'AND document_status <> :doc_status';
5902:
5903: l_ctx := DBMS_XMLQuery.newContext(l_sql);
5904: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
5905: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_VALIDATED);
5906: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
5907:
5908: /* raise an exception if no rows were found */
5909: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);

Line 5906: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);

5902:
5903: l_ctx := DBMS_XMLQuery.newContext(l_sql);
5904: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
5905: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_VALIDATED);
5906: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
5907:
5908: /* raise an exception if no rows were found */
5909: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
5910: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);

Line 5909: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);

5905: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_VALIDATED);
5906: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
5907:
5908: /* raise an exception if no rows were found */
5909: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
5910: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
5911: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
5912:
5913: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);

Line 5910: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);

5906: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
5907:
5908: /* raise an exception if no rows were found */
5909: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
5910: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
5911: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
5912:
5913: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
5914: DBMS_XMLQuery.closeContext(l_ctx);

Line 5911: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);

5907:
5908: /* raise an exception if no rows were found */
5909: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
5910: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
5911: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
5912:
5913: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
5914: DBMS_XMLQuery.closeContext(l_ctx);
5915:

Line 5913: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);

5909: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
5910: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
5911: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
5912:
5913: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
5914: DBMS_XMLQuery.closeContext(l_ctx);
5915:
5916: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5917: print_debuginfo(l_module_name, 'EXIT');

Line 5914: DBMS_XMLQuery.closeContext(l_ctx);

5910: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
5911: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
5912:
5913: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
5914: DBMS_XMLQuery.closeContext(l_ctx);
5915:
5916: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5917: print_debuginfo(l_module_name, 'EXIT');
5918:

Line 5925: DBMS_XMLQuery.getExceptionContent(l_ctx, l_sqlcode, l_sqlerrm);

5921:
5922: EXCEPTION
5923:
5924: WHEN OTHERS THEN
5925: DBMS_XMLQuery.getExceptionContent(l_ctx, l_sqlcode, l_sqlerrm);
5926: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5927: print_debuginfo(l_module_name, 'SQL code: ' || l_sqlcode);
5928: print_debuginfo(l_module_name, 'SQL err msg: '|| l_sqlerrm);
5929: