[Home] [Help]
339: "ARTrxGLDateFrom"
340: ,ar_gta_trx_util.To_Xsd_Date_String(l_gl_date_to) AS
341: "ARTrxGLDateTo"))
342: INTO l_parameter
343: FROM dual;
344:
345: fnd_profile.get('AR_GTA_ENABLED'
346: ,l_ar_gta_enabled);
347:
363: ,xmlelement("ReportFailedMsg"
364: ,l_ar_gta_gta_not_enabled)
365: ,l_parameter))
366: INTO l_report
367: FROM dual;
368:
369: ar_gta_trx_util.output_conc(l_report.getclobval());
370: l_conc_succ := fnd_concurrent.set_completion_status(status => 'WARNING'
371: ,message => l_ar_gta_gta_not_enabled);
420: ,l_gta_line_count AS "GTATrxLinePurged"
421: ,l_gt_header_count AS "GTTrxHeaderPurged"
422: ,l_gt_line_count AS "GTTrxLinePurged"))
423: INTO l_summary
424: FROM dual;
425:
426: --Generate Reports Xml Data
427: SELECT xmlelement("PurgeReport"
428: ,xmlconcat(xmlelement("ReportFailed"
433: ,ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))
434: ,l_parameter
435: ,l_summary))
436: INTO l_report
437: FROM dual;
438:
439: ar_gta_trx_util.output_conc(l_report.getclobval());
440:
441: --logging for debug
571: AS "ARTrxDateFrom"
572: ,ar_gta_trx_util.To_Xsd_Date_String(l_ar_inv_date_to)
573: AS "ARTrxDateTo"))
574: INTO l_parameter
575: FROM dual;
576:
577: fnd_message.set_name('AR'
578: ,'AR_GTA_GTA_NOT_ENABLE');
579: l_ar_gta_gta_not_enabled := fnd_message.get();
589: ,xmlelement("ReportFailedMsg"
590: ,l_ar_gta_gta_not_enabled)
591: ,l_parameter))
592: INTO l_report
593: FROM dual;
594:
595: ar_gta_trx_util.output_conc(l_report.getclobval());
596: l_conc_succ := fnd_concurrent.set_completion_status(status => 'WARNING'
597: ,message => l_ar_gta_gta_not_enabled);
1151: ,l_ar_gta_not_enabled_msg AS
1152: "ReportFailedMsg"
1153: ,'N' AS "FailedWithParameters"))
1154: INTO l_report_xml
1155: FROM dual;
1156:
1157: --output error message to concurrent output
1158: fnd_file.put_line(fnd_file.output
1159: ,l_report_xml.getstringval());
1677: , p_consol_trx_num_from AS "ConsolidationTrxNumFrom"
1678: , p_consol_trx_num_to AS "ConsolidationTrxNumTo"
1679: , p_invoice_type AS "InvoiceType"))
1680: INTO l_parameter
1681: FROM dual;
1682: */
1683: fnd_message.set_name('AR', 'AR_GTA_GTA_NOT_ENABLE');
1684: -- modified by Allen Yang 02-Sep-2009 for bug 8848798
1685: ------------------------------------------------------------------------
1692: ,xmlelement("RepDate",ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))
1693: ,xmlelement("ReportFailedMsg",l_ar_gta_gta_not_enabled)
1694: ,l_parameter))
1695: INTO l_report
1696: FROM dual;
1697:
1698: ar_gta_trx_util.output_conc(l_report.getclobval());
1699: */
1700: l_ar_gta_gta_not_enabled := '