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.ECX_STANDARD dependencies on XMLDOM

Line 2088: l_xml_doc xmlDOM.DOMDocument;

2084: i_dtd_version in varchar2
2085: )
2086: is
2087: l_parser xmlparser.parser;
2088: l_xml_doc xmlDOM.DOMDocument;
2089: i_version number;
2090: l_dtd_payload clob;
2091: l_doctype xmlDOM.DOMDocumentType;
2092:

Line 2091: l_doctype xmlDOM.DOMDocumentType;

2087: l_parser xmlparser.parser;
2088: l_xml_doc xmlDOM.DOMDocument;
2089: i_version number;
2090: l_dtd_payload clob;
2091: l_doctype xmlDOM.DOMDocumentType;
2092:
2093: cursor get_dtd is
2094: select payload
2095: from ecx_dtds

Line 2179: ecx_utils.g_xmldoc := xmlDOM.makeNode(l_xml_doc);

2175: xmlparser.parseCLOB(l_parser, i_xml_file);
2176:
2177: l_xml_doc := xmlparser.getDocument(l_parser);
2178:
2179: ecx_utils.g_xmldoc := xmlDOM.makeNode(l_xml_doc);
2180:
2181: /* Bug #2517237 : Trim the Clob before writing the transformed xml */
2182: dbms_lob.trim(i_xml_file, 0);
2183: /* bug 10254870: Calling overloaded procedure by passing out parameter of type clob

Line 2194: -- xmlDOM.writeToClob(ecx_utils.g_xmldoc, i_xml_file);

2190: );
2191: -- get the transformed xml from ecx_utils.g_xml_doc
2192: -- convert from DOMNode to clob and set it in original xmlfile
2193: /*bug 10254870: getting transformed i_xml_file clob and hence not required to copy from node to clob here */
2194: -- xmlDOM.writeToClob(ecx_utils.g_xmldoc, i_xml_file);
2195:
2196: -- free all the used variables
2197: l_dtd_payload := null;
2198: xmlparser.freeParser(l_parser);

Line 2199: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then

2195:
2196: -- free all the used variables
2197: l_dtd_payload := null;
2198: xmlparser.freeParser(l_parser);
2199: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2200: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2201: end if;
2202: ecx_utils.g_logdir := null;
2203: ecx_utils.g_logfile := null;

Line 2200: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));

2196: -- free all the used variables
2197: l_dtd_payload := null;
2198: xmlparser.freeParser(l_parser);
2199: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2200: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2201: end if;
2202: ecx_utils.g_logdir := null;
2203: ecx_utils.g_logfile := null;
2204: if (not xmldom.isNull(l_xml_doc))

Line 2204: if (not xmldom.isNull(l_xml_doc))

2200: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2201: end if;
2202: ecx_utils.g_logdir := null;
2203: ecx_utils.g_logfile := null;
2204: if (not xmldom.isNull(l_xml_doc))
2205: then
2206: xmldom.freeDocument(l_xml_doc);
2207: end if;
2208:

Line 2206: xmldom.freeDocument(l_xml_doc);

2202: ecx_utils.g_logdir := null;
2203: ecx_utils.g_logfile := null;
2204: if (not xmldom.isNull(l_xml_doc))
2205: then
2206: xmldom.freeDocument(l_xml_doc);
2207: end if;
2208:
2209: i_retcode := 0;
2210: i_retmsg := ecx_debug.getTranslatedMessage('ECX_XSLT_TRANSFORMED');

Line 2220: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then

2216:
2217: -- free all the used variables
2218: l_dtd_payload := null;
2219: xmlparser.freeParser(l_parser);
2220: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2221: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2222: end if;
2223: ecx_utils.g_logdir := null;
2224: ecx_utils.g_logfile := null;

Line 2221: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));

2217: -- free all the used variables
2218: l_dtd_payload := null;
2219: xmlparser.freeParser(l_parser);
2220: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2221: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2222: end if;
2223: ecx_utils.g_logdir := null;
2224: ecx_utils.g_logfile := null;
2225: ecx_utils.i_ret_code := 0;

Line 2228: if (not xmldom.isNull(l_xml_doc))

2224: ecx_utils.g_logfile := null;
2225: ecx_utils.i_ret_code := 0;
2226: ecx_utils.i_errbuf := null;
2227: ecx_utils.i_errparams := null;
2228: if (not xmldom.isNull(l_xml_doc))
2229: then
2230: xmldom.freeDocument(l_xml_doc);
2231: end if;
2232: when others then

Line 2230: xmldom.freeDocument(l_xml_doc);

2226: ecx_utils.i_errbuf := null;
2227: ecx_utils.i_errparams := null;
2228: if (not xmldom.isNull(l_xml_doc))
2229: then
2230: xmldom.freeDocument(l_xml_doc);
2231: end if;
2232: when others then
2233: i_retmsg:= SQLERRM || ' - ECX_STANDARD.PERFORM_XSLT_TRANSFORMATION';
2234: i_retcode := 2;

Line 2239: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then

2235:
2236: -- free all the used variables
2237: l_dtd_payload := null;
2238: xmlparser.freeParser(l_parser);
2239: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2240: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2241: end if;
2242: ecx_utils.g_logdir := null;
2243: ecx_utils.g_logfile := null;

Line 2240: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));

2236: -- free all the used variables
2237: l_dtd_payload := null;
2238: xmlparser.freeParser(l_parser);
2239: if (not xmldom.isNull(ecx_utils.g_xmldoc)) then
2240: xmldom.freeDocument(xmldom.makeDocument(ecx_utils.g_xmldoc));
2241: end if;
2242: ecx_utils.g_logdir := null;
2243: ecx_utils.g_logfile := null;
2244: ecx_utils.i_ret_code := 0;

Line 2247: if (not xmldom.isNull(l_xml_doc))

2243: ecx_utils.g_logfile := null;
2244: ecx_utils.i_ret_code := 0;
2245: ecx_utils.i_errbuf := null;
2246: ecx_utils.i_errparams := null;
2247: if (not xmldom.isNull(l_xml_doc))
2248: then
2249: xmldom.freeDocument(l_xml_doc);
2250: end if;
2251: end perform_xslt_transformation;

Line 2249: xmldom.freeDocument(l_xml_doc);

2245: ecx_utils.i_errbuf := null;
2246: ecx_utils.i_errparams := null;
2247: if (not xmldom.isNull(l_xml_doc))
2248: then
2249: xmldom.freeDocument(l_xml_doc);
2250: end if;
2251: end perform_xslt_transformation;
2252:
2253:

Line 2295: l_dom_document XMLDOM.DOMDOCUMENT;

2291: l_api_version CONSTANT NUMBER := 1.0;
2292: l_api_name CONSTANT VARCHAR2(30) := 'GET_VALUE_FOR_XPATH';
2293:
2294: l_parser XMLPARSER.PARSER;
2295: l_dom_document XMLDOM.DOMDOCUMENT;
2296: l_node_list XMLDOM.DOMNODELIST;
2297: l_node XMLDOM.DOMNODE;
2298:
2299: INVALID_NODE_IN_NODELIST EXCEPTION;

Line 2296: l_node_list XMLDOM.DOMNODELIST;

2292: l_api_name CONSTANT VARCHAR2(30) := 'GET_VALUE_FOR_XPATH';
2293:
2294: l_parser XMLPARSER.PARSER;
2295: l_dom_document XMLDOM.DOMDOCUMENT;
2296: l_node_list XMLDOM.DOMNODELIST;
2297: l_node XMLDOM.DOMNODE;
2298:
2299: INVALID_NODE_IN_NODELIST EXCEPTION;
2300: BEGIN

Line 2297: l_node XMLDOM.DOMNODE;

2293:
2294: l_parser XMLPARSER.PARSER;
2295: l_dom_document XMLDOM.DOMDOCUMENT;
2296: l_node_list XMLDOM.DOMNODELIST;
2297: l_node XMLDOM.DOMNODE;
2298:
2299: INVALID_NODE_IN_NODELIST EXCEPTION;
2300: BEGIN
2301: -- Standard call to check for call compatibility

Line 2320: l_node_list := XSLPROCESSOR.selectNodes(XMLDOM.makeNode(l_dom_document),p_XPATH_EXPRESSION);

2316: l_dom_document := XMLPARSER.getDocument(l_parser);
2317: XMLParser.freeParser(l_parser);
2318:
2319: --Obtain the nodes, present at the location specified by the XPATH Expression
2320: l_node_list := XSLPROCESSOR.selectNodes(XMLDOM.makeNode(l_dom_document),p_XPATH_EXPRESSION);
2321:
2322: FOR i IN 1..XMLDOM.getLength(l_node_list) LOOP
2323: -- Fetch node with index (i-1) from nodelist
2324: l_node := XMLDOM.ITEM(l_node_list, i-1);

Line 2322: FOR i IN 1..XMLDOM.getLength(l_node_list) LOOP

2318:
2319: --Obtain the nodes, present at the location specified by the XPATH Expression
2320: l_node_list := XSLPROCESSOR.selectNodes(XMLDOM.makeNode(l_dom_document),p_XPATH_EXPRESSION);
2321:
2322: FOR i IN 1..XMLDOM.getLength(l_node_list) LOOP
2323: -- Fetch node with index (i-1) from nodelist
2324: l_node := XMLDOM.ITEM(l_node_list, i-1);
2325:
2326: --If no nodes are present raise error

Line 2324: l_node := XMLDOM.ITEM(l_node_list, i-1);

2320: l_node_list := XSLPROCESSOR.selectNodes(XMLDOM.makeNode(l_dom_document),p_XPATH_EXPRESSION);
2321:
2322: FOR i IN 1..XMLDOM.getLength(l_node_list) LOOP
2323: -- Fetch node with index (i-1) from nodelist
2324: l_node := XMLDOM.ITEM(l_node_list, i-1);
2325:
2326: --If no nodes are present raise error
2327: IF (XMLDOM.isNull(l_node)) THEN
2328: RAISE INVALID_NODE_IN_NODELIST;

Line 2327: IF (XMLDOM.isNull(l_node)) THEN

2323: -- Fetch node with index (i-1) from nodelist
2324: l_node := XMLDOM.ITEM(l_node_list, i-1);
2325:
2326: --If no nodes are present raise error
2327: IF (XMLDOM.isNull(l_node)) THEN
2328: RAISE INVALID_NODE_IN_NODELIST;
2329: END IF;
2330:
2331: --Check if current node has any child nodes

Line 2332: IF XMLDOM.hasChildNodes(l_node) THEN

2328: RAISE INVALID_NODE_IN_NODELIST;
2329: END IF;
2330:
2331: --Check if current node has any child nodes
2332: IF XMLDOM.hasChildNodes(l_node) THEN
2333: l_node := XMLDOM.getFirstChild(l_node);
2334: LOOP
2335: IF XMLDOM.getNodeType(l_node) = XMLDOM.TEXT_NODE THEN
2336: -- Append x_XPATH_VALUE with Previous x_XPATH_VALUE and

Line 2333: l_node := XMLDOM.getFirstChild(l_node);

2329: END IF;
2330:
2331: --Check if current node has any child nodes
2332: IF XMLDOM.hasChildNodes(l_node) THEN
2333: l_node := XMLDOM.getFirstChild(l_node);
2334: LOOP
2335: IF XMLDOM.getNodeType(l_node) = XMLDOM.TEXT_NODE THEN
2336: -- Append x_XPATH_VALUE with Previous x_XPATH_VALUE and
2337: -- include a comma at the end to generate a list of comma separated values.

Line 2335: IF XMLDOM.getNodeType(l_node) = XMLDOM.TEXT_NODE THEN

2331: --Check if current node has any child nodes
2332: IF XMLDOM.hasChildNodes(l_node) THEN
2333: l_node := XMLDOM.getFirstChild(l_node);
2334: LOOP
2335: IF XMLDOM.getNodeType(l_node) = XMLDOM.TEXT_NODE THEN
2336: -- Append x_XPATH_VALUE with Previous x_XPATH_VALUE and
2337: -- include a comma at the end to generate a list of comma separated values.
2338: x_XPATH_VALUE := x_XPATH_VALUE || TRIM(XMLDOM.getNodeValue(l_node)) || ',';
2339: EXIT;

Line 2338: x_XPATH_VALUE := x_XPATH_VALUE || TRIM(XMLDOM.getNodeValue(l_node)) || ',';

2334: LOOP
2335: IF XMLDOM.getNodeType(l_node) = XMLDOM.TEXT_NODE THEN
2336: -- Append x_XPATH_VALUE with Previous x_XPATH_VALUE and
2337: -- include a comma at the end to generate a list of comma separated values.
2338: x_XPATH_VALUE := x_XPATH_VALUE || TRIM(XMLDOM.getNodeValue(l_node)) || ',';
2339: EXIT;
2340: END IF;
2341:
2342: l_node := XMLDOM.getNextSibling(l_node);

Line 2342: l_node := XMLDOM.getNextSibling(l_node);

2338: x_XPATH_VALUE := x_XPATH_VALUE || TRIM(XMLDOM.getNodeValue(l_node)) || ',';
2339: EXIT;
2340: END IF;
2341:
2342: l_node := XMLDOM.getNextSibling(l_node);
2343: EXIT WHEN XMLDOM.isNull(l_node);
2344: END LOOP;
2345: END IF;
2346:

Line 2343: EXIT WHEN XMLDOM.isNull(l_node);

2339: EXIT;
2340: END IF;
2341:
2342: l_node := XMLDOM.getNextSibling(l_node);
2343: EXIT WHEN XMLDOM.isNull(l_node);
2344: END LOOP;
2345: END IF;
2346:
2347: END LOOP;

Line 2351: XMLDOM.freeDocument(l_dom_document);

2347: END LOOP;
2348:
2349: --Removing the extra comma from the end of the string
2350: x_XPATH_VALUE := SUBSTR(x_XPATH_VALUE, 0, LENGTH(x_XPATH_VALUE)-1);
2351: XMLDOM.freeDocument(l_dom_document);
2352:
2353: EXCEPTION
2354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2355: x_XPATH_VALUE := NULL;