XML Bursting Not Working

Hi All,

My Bursting is not working.I was encountering error like below intially

Debug Flag: N

{P_DATE=2019/01/08 00:00:00}

Calling XDO Data Engine...

[010919_171128601][][EXCEPTION] SQLException encounter while executing data trigger....

java.sql.SQLException: ORA-06550: line 2, column 28:

PLS-00302: component 'P_DATE' must be declared

After going through the some links on here found that we need to add the P_DATE parameter in the package Specification. I have added it in the SPEC but encountering below error

Calling XDO Data Engine...

[010919_174001604][][EXCEPTION] SQLException encounter while executing data trigger....

java.sql.SQLException: ORA-06503: PL/SQL: Function returned without value

ORA-06512: at "PQINF.XXPQ_EDI_INV_STS_RPT", line 37