[Home] [Help]
320: "ARTrxGLDateFrom"
321: ,jmf_gta_trx_util.To_Xsd_Date_String(l_gl_date_to) AS
322: "ARTrxGLDateTo"))
323: INTO l_parameter
324: FROM dual;
325:
326: fnd_profile.get('JMF_GTA_ENABLED'
327: ,l_jmf_gta_enabled);
328:
344: ,xmlelement("ReportFailedMsg"
345: ,l_jmf_gta_gta_not_enabled)
346: ,l_parameter))
347: INTO l_report
348: FROM dual;
349:
350: jmf_gta_trx_util.output_conc(l_report.getclobval());
351: l_conc_succ := fnd_concurrent.set_completion_status(status => 'WARNING'
352: ,message => l_jmf_gta_gta_not_enabled);
401: ,l_gta_line_count AS "GTATrxLinePurged"
402: ,l_gt_header_count AS "GTTrxHeaderPurged"
403: ,l_gt_line_count AS "GTTrxLinePurged"))
404: INTO l_summary
405: FROM dual;
406:
407: --Generate Reports Xml Data
408: SELECT xmlelement("PurgeReport"
409: ,xmlconcat(xmlelement("ReportFailed"
414: ,jmf_gta_trx_util.To_Xsd_Date_String(SYSDATE))
415: ,l_parameter
416: ,l_summary))
417: INTO l_report
418: FROM dual;
419:
420: jmf_gta_trx_util.output_conc(l_report.getclobval());
421:
422: --logging for debug
552: AS "ARTrxDateFrom"
553: ,jmf_gta_trx_util.To_Xsd_Date_String(l_ar_inv_date_to)
554: AS "ARTrxDateTo"))
555: INTO l_parameter
556: FROM dual;
557:
558: fnd_message.set_name('JMF'
559: ,'JMF_GTA_GTA_NOT_ENABLE');
560: l_jmf_gta_gta_not_enabled := fnd_message.get();
570: ,xmlelement("ReportFailedMsg"
571: ,l_jmf_gta_gta_not_enabled)
572: ,l_parameter))
573: INTO l_report
574: FROM dual;
575:
576: jmf_gta_trx_util.output_conc(l_report.getclobval());
577: l_conc_succ := fnd_concurrent.set_completion_status(status => 'WARNING'
578: ,message => l_jmf_gta_gta_not_enabled);
1127: ,l_jmf_gta_not_enabled_msg AS
1128: "ReportFailedMsg"
1129: ,'N' AS "FailedWithParameters"))
1130: INTO l_report_xml
1131: FROM dual;
1132:
1133: --output error message to concurrent output
1134: fnd_file.put_line(fnd_file.output
1135: ,l_report_xml.getstringval());