Getting error on line 3 at column 1: Premature end of data in tag YTDAUTO line 2 in my procedure

Good day people

I have written a new procedure that will deliver data in excel format. The structure is as follows:

Unit Opening Balance Billings Credit Notes Interest Adjustments Receipts Closing Balance

XXX 10.00 25.00 1.00 2.00 1.00 10.00 27.00

The sql part of the procedure pulls the data perfectly and there are no issues.

After the code for the extract of data my xml build is setup as follows:

BEGIN

FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'<?xml version="1.0"?>');
FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'<YTDAUTO>');

FOR v_ytdauto IN xml_ytdauto

LOOP

FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'<P_YTDAUTO>');