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 2082: l_xml_doc xmlDOM.DOMDocument;

2078: i_dtd_version in varchar2
2079: )
2080: is
2081: l_parser xmlparser.parser;
2082: l_xml_doc xmlDOM.DOMDocument;
2083: i_version number;
2084: l_dtd_payload clob;
2085: l_doctype xmlDOM.DOMDocumentType;
2086:

Line 2085: l_doctype xmlDOM.DOMDocumentType;

2081: l_parser xmlparser.parser;
2082: l_xml_doc xmlDOM.DOMDocument;
2083: i_version number;
2084: l_dtd_payload clob;
2085: l_doctype xmlDOM.DOMDocumentType;
2086:
2087: cursor get_dtd is
2088: select payload
2089: from ecx_dtds

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

2157: xmlparser.parseCLOB(l_parser, i_xml_file);
2158:
2159: l_xml_doc := xmlparser.getDocument(l_parser);
2160:
2161: ecx_utils.g_xmldoc := xmlDOM.makeNode(l_xml_doc);
2162:
2163: -- call transform_xml_with_xslt to do the transformation
2164: ecx_actions.transform_xml_with_xslt (i_xslt_file_name,
2165: i_version,

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

2170:
2171: /* Bug #2517237 : Trim the Clob before writing the transformed xml */
2172: dbms_lob.trim(i_xml_file, 0);
2173:
2174: xmlDOM.writeToClob(ecx_utils.g_xmldoc, i_xml_file);
2175:
2176: -- free all the used variables
2177: l_dtd_payload := null;
2178: xmlparser.freeParser(l_parser);

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

2178: xmlparser.freeParser(l_parser);
2179: ecx_utils.g_xmldoc := null;
2180: ecx_utils.g_logdir := null;
2181: ecx_utils.g_logfile := null;
2182: if (not xmldom.isNull(l_xml_doc))
2183: then
2184: xmldom.freeDocument(l_xml_doc);
2185: end if;
2186:

Line 2184: xmldom.freeDocument(l_xml_doc);

2180: ecx_utils.g_logdir := null;
2181: ecx_utils.g_logfile := null;
2182: if (not xmldom.isNull(l_xml_doc))
2183: then
2184: xmldom.freeDocument(l_xml_doc);
2185: end if;
2186:
2187: i_retcode := 0;
2188: i_retmsg := ecx_debug.getTranslatedMessage('ECX_XSLT_TRANSFORMED');

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

2200: ecx_utils.g_logfile := null;
2201: ecx_utils.i_ret_code := 0;
2202: ecx_utils.i_errbuf := null;
2203: ecx_utils.i_errparams := null;
2204: if (not xmldom.isNull(l_xml_doc))
2205: then
2206: xmldom.freeDocument(l_xml_doc);
2207: end if;
2208: when others then

Line 2206: xmldom.freeDocument(l_xml_doc);

2202: ecx_utils.i_errbuf := null;
2203: ecx_utils.i_errparams := null;
2204: if (not xmldom.isNull(l_xml_doc))
2205: then
2206: xmldom.freeDocument(l_xml_doc);
2207: end if;
2208: when others then
2209: i_retmsg:= SQLERRM || ' - ECX_STANDARD.PERFORM_XSLT_TRANSFORMATION';
2210: i_retcode := 2;

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

2217: ecx_utils.g_logfile := null;
2218: ecx_utils.i_ret_code := 0;
2219: ecx_utils.i_errbuf := null;
2220: ecx_utils.i_errparams := null;
2221: if (not xmldom.isNull(l_xml_doc))
2222: then
2223: xmldom.freeDocument(l_xml_doc);
2224: end if;
2225: end perform_xslt_transformation;

Line 2223: xmldom.freeDocument(l_xml_doc);

2219: ecx_utils.i_errbuf := null;
2220: ecx_utils.i_errparams := null;
2221: if (not xmldom.isNull(l_xml_doc))
2222: then
2223: xmldom.freeDocument(l_xml_doc);
2224: end if;
2225: end perform_xslt_transformation;
2226:
2227:

Line 2269: l_dom_document XMLDOM.DOMDOCUMENT;

2265: l_api_version CONSTANT NUMBER := 1.0;
2266: l_api_name CONSTANT VARCHAR2(30) := 'GET_VALUE_FOR_XPATH';
2267:
2268: l_parser XMLPARSER.PARSER;
2269: l_dom_document XMLDOM.DOMDOCUMENT;
2270: l_node_list XMLDOM.DOMNODELIST;
2271: l_node XMLDOM.DOMNODE;
2272:
2273: INVALID_NODE_IN_NODELIST EXCEPTION;

Line 2270: l_node_list XMLDOM.DOMNODELIST;

2266: l_api_name CONSTANT VARCHAR2(30) := 'GET_VALUE_FOR_XPATH';
2267:
2268: l_parser XMLPARSER.PARSER;
2269: l_dom_document XMLDOM.DOMDOCUMENT;
2270: l_node_list XMLDOM.DOMNODELIST;
2271: l_node XMLDOM.DOMNODE;
2272:
2273: INVALID_NODE_IN_NODELIST EXCEPTION;
2274: BEGIN

Line 2271: l_node XMLDOM.DOMNODE;

2267:
2268: l_parser XMLPARSER.PARSER;
2269: l_dom_document XMLDOM.DOMDOCUMENT;
2270: l_node_list XMLDOM.DOMNODELIST;
2271: l_node XMLDOM.DOMNODE;
2272:
2273: INVALID_NODE_IN_NODELIST EXCEPTION;
2274: BEGIN
2275: -- Standard call to check for call compatibility

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

2290: l_dom_document := XMLPARSER.getDocument(l_parser);
2291: XMLParser.freeParser(l_parser);
2292:
2293: --Obtain the nodes, present at the location specified by the XPATH Expression
2294: l_node_list := XSLPROCESSOR.selectNodes(XMLDOM.makeNode(l_dom_document),p_XPATH_EXPRESSION);
2295:
2296: FOR i IN 1..XMLDOM.getLength(l_node_list) LOOP
2297: -- Fetch node with index (i-1) from nodelist
2298: l_node := XMLDOM.ITEM(l_node_list, i-1);

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

2292:
2293: --Obtain the nodes, present at the location specified by the XPATH Expression
2294: l_node_list := XSLPROCESSOR.selectNodes(XMLDOM.makeNode(l_dom_document),p_XPATH_EXPRESSION);
2295:
2296: FOR i IN 1..XMLDOM.getLength(l_node_list) LOOP
2297: -- Fetch node with index (i-1) from nodelist
2298: l_node := XMLDOM.ITEM(l_node_list, i-1);
2299:
2300: --If no nodes are present raise error

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

2294: l_node_list := XSLPROCESSOR.selectNodes(XMLDOM.makeNode(l_dom_document),p_XPATH_EXPRESSION);
2295:
2296: FOR i IN 1..XMLDOM.getLength(l_node_list) LOOP
2297: -- Fetch node with index (i-1) from nodelist
2298: l_node := XMLDOM.ITEM(l_node_list, i-1);
2299:
2300: --If no nodes are present raise error
2301: IF (XMLDOM.isNull(l_node)) THEN
2302: RAISE INVALID_NODE_IN_NODELIST;

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

2297: -- Fetch node with index (i-1) from nodelist
2298: l_node := XMLDOM.ITEM(l_node_list, i-1);
2299:
2300: --If no nodes are present raise error
2301: IF (XMLDOM.isNull(l_node)) THEN
2302: RAISE INVALID_NODE_IN_NODELIST;
2303: END IF;
2304:
2305: --Check if current node has any child nodes

Line 2306: IF XMLDOM.hasChildNodes(l_node) THEN

2302: RAISE INVALID_NODE_IN_NODELIST;
2303: END IF;
2304:
2305: --Check if current node has any child nodes
2306: IF XMLDOM.hasChildNodes(l_node) THEN
2307: l_node := XMLDOM.getFirstChild(l_node);
2308: LOOP
2309: IF XMLDOM.getNodeType(l_node) = XMLDOM.TEXT_NODE THEN
2310: -- Append x_XPATH_VALUE with Previous x_XPATH_VALUE and

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

2303: END IF;
2304:
2305: --Check if current node has any child nodes
2306: IF XMLDOM.hasChildNodes(l_node) THEN
2307: l_node := XMLDOM.getFirstChild(l_node);
2308: LOOP
2309: IF XMLDOM.getNodeType(l_node) = XMLDOM.TEXT_NODE THEN
2310: -- Append x_XPATH_VALUE with Previous x_XPATH_VALUE and
2311: -- include a comma at the end to generate a list of comma separated values.

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

2305: --Check if current node has any child nodes
2306: IF XMLDOM.hasChildNodes(l_node) THEN
2307: l_node := XMLDOM.getFirstChild(l_node);
2308: LOOP
2309: IF XMLDOM.getNodeType(l_node) = XMLDOM.TEXT_NODE THEN
2310: -- Append x_XPATH_VALUE with Previous x_XPATH_VALUE and
2311: -- include a comma at the end to generate a list of comma separated values.
2312: x_XPATH_VALUE := x_XPATH_VALUE || TRIM(XMLDOM.getNodeValue(l_node)) || ',';
2313: EXIT;

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

2308: LOOP
2309: IF XMLDOM.getNodeType(l_node) = XMLDOM.TEXT_NODE THEN
2310: -- Append x_XPATH_VALUE with Previous x_XPATH_VALUE and
2311: -- include a comma at the end to generate a list of comma separated values.
2312: x_XPATH_VALUE := x_XPATH_VALUE || TRIM(XMLDOM.getNodeValue(l_node)) || ',';
2313: EXIT;
2314: END IF;
2315:
2316: l_node := XMLDOM.getNextSibling(l_node);

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

2312: x_XPATH_VALUE := x_XPATH_VALUE || TRIM(XMLDOM.getNodeValue(l_node)) || ',';
2313: EXIT;
2314: END IF;
2315:
2316: l_node := XMLDOM.getNextSibling(l_node);
2317: EXIT WHEN XMLDOM.isNull(l_node);
2318: END LOOP;
2319: END IF;
2320:

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

2313: EXIT;
2314: END IF;
2315:
2316: l_node := XMLDOM.getNextSibling(l_node);
2317: EXIT WHEN XMLDOM.isNull(l_node);
2318: END LOOP;
2319: END IF;
2320:
2321: END LOOP;

Line 2325: XMLDOM.freeDocument(l_dom_document);

2321: END LOOP;
2322:
2323: --Removing the extra comma from the end of the string
2324: x_XPATH_VALUE := SUBSTR(x_XPATH_VALUE, 0, LENGTH(x_XPATH_VALUE)-1);
2325: XMLDOM.freeDocument(l_dom_document);
2326:
2327: EXCEPTION
2328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2329: x_XPATH_VALUE := NULL;