XML Parsing Error: junk after document element in EBS BI Publisher using PLSQL Code
Hi All,
Generating XMLP data tags using PLSQL code...
BEGIN
fnd_file.put_line(fnd_file.output,'<?xml version="1.0" encoding="UTF-8"?>');
FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'<XXC_ORDER_DET>');
FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'<LIST_G_MAIN>');
FOR c_rec IN c_1 LOOP
FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'<G_MAIN>');
FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'<ORDER_NUM>'||dbms_xmlgen.CONVERT(c_rec.ORDER_NUM)||'</ORDER_NUM>');
FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'</G_MAIN>');
END LOOP;
FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'</LIST_G_MAIN>');