APPS.LNS_FINANCIALS dependencies on DBMS_XMLPARSER

Line 11804: l_parser dbms_xmlparser.Parser;

11800: +-----------------------------------------------------------------------*/
11801:
11802: l_api_name CONSTANT VARCHAR2(30) := 'LOAD_ORIGINAL_SCHEDULE';
11803: l_clob CLOB;
11804: l_parser dbms_xmlparser.Parser;
11805: l_doc dbms_xmldom.DOMDocument;
11806: l_nl dbms_xmldom.DOMNodeList;
11807: l_n dbms_xmldom.DOMNode;
11808: i number;

Line 11855: l_parser := dbms_xmlparser.newParser;

11851: end if;
11852:
11853: -- Create a parser.
11854: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Creating a parser...');
11855: l_parser := dbms_xmlparser.newParser;
11856:
11857: -- Parse the document and create a new DOM document.
11858: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Parsing the document and creating a new DOM document...');
11859: dbms_xmlparser.parseClob(l_parser, l_clob);

Line 11859: dbms_xmlparser.parseClob(l_parser, l_clob);

11855: l_parser := dbms_xmlparser.newParser;
11856:
11857: -- Parse the document and create a new DOM document.
11858: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Parsing the document and creating a new DOM document...');
11859: dbms_xmlparser.parseClob(l_parser, l_clob);
11860: l_doc := dbms_xmlparser.getDocument(l_parser);
11861:
11862: -- Free resources associated with the CLOB and Parser now they are no longer needed.
11863: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Freeing resources...');

Line 11860: l_doc := dbms_xmlparser.getDocument(l_parser);

11856:
11857: -- Parse the document and create a new DOM document.
11858: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Parsing the document and creating a new DOM document...');
11859: dbms_xmlparser.parseClob(l_parser, l_clob);
11860: l_doc := dbms_xmlparser.getDocument(l_parser);
11861:
11862: -- Free resources associated with the CLOB and Parser now they are no longer needed.
11863: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Freeing resources...');
11864: dbms_xmlparser.freeParser(l_parser);

Line 11864: dbms_xmlparser.freeParser(l_parser);

11860: l_doc := dbms_xmlparser.getDocument(l_parser);
11861:
11862: -- Free resources associated with the CLOB and Parser now they are no longer needed.
11863: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Freeing resources...');
11864: dbms_xmlparser.freeParser(l_parser);
11865:
11866: get_char2num_conv_chars(l_chars_to_replace, l_replace_chars);
11867:
11868: -- Get a list of all the RATE_SCHEDULE_ROW nodes in the document using the XPATH syntax.

Line 12153: dbms_xmlparser.freeParser(l_parser);

12149: -- Free any resources associated with the document now it
12150: -- is no longer needed.
12151: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Freeing resources...');
12152: dbms_xmldom.freeDocument(l_doc);
12153: dbms_xmlparser.freeParser(l_parser);
12154:
12155: x_loan_amort_tbl := l_amort_tbl;
12156: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
12157:

Line 12162: dbms_xmlparser.freeParser(l_parser);

12158: EXCEPTION
12159: WHEN OTHERS THEN
12160: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, ' - in exception. Error: ' || sqlerrm);
12161: --dbms_lob.freetemporary(l_clob);
12162: dbms_xmlparser.freeParser(l_parser);
12163: dbms_xmldom.freeDocument(l_doc);
12164: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
12165: FND_MESSAGE.SET_TOKEN('ERROR' ,sqlerrm);
12166: FND_MSG_PUB.Add;