[Home] [Help]
613: WHERE SUCCEEDED = 'W'
614: OR SUCCEEDED = 'Y';
615:
616: -- generate validate xml string
617: SELECT xmlelement("ReportFailed", 'N') INTO l_Reportfailed FROM dual;
618:
619: SELECT xmlelement("FailedWithParameters", 'N')
620: INTO l_FailedWithParameters
621: FROM dual;
617: SELECT xmlelement("ReportFailed", 'N') INTO l_Reportfailed FROM dual;
618:
619: SELECT xmlelement("FailedWithParameters", 'N')
620: INTO l_FailedWithParameters
621: FROM dual;
622:
623: -- generate xmlsring of parameters of transfer program
624: SELECT xmlelement("Parameters",
625: xmlforest(l_operation_unit AS "OperationUnit",
639: l_trx_date_to AS "TransactionDateTo",
640: l_doc_num_from AS "DocNumberFrom",
641: l_doc_num_to AS "DocNumberTo"))
642: INTO l_parameter
643: FROM dual;
644:
645: --generate summary section
646: SELECT xmlelement("Summary",
647: xmlforest(l_succ_rows AS "NumOfSucc",
651: l_succ_amount AS "AmountSucc",
652: l_failed_amount AS "AmountWarning",
653: l_warning_amount AS "AmountFail"))
654: INTO l_summary
655: FROM dual;
656:
657: -- generate the xmltype for failed inv
658: SELECT XMLElement("Invoices",
659: xmlagg(xmlelement("Invoice",
724: l_failed AS "FailedInvoices",
725: l_warning AS "WarningInvoices",
726: l_succeeded AS "SuccInvoices"))
727: INTO l_report_XML
728: FROM dual;
729:
730: --Yao Zhang add for bug 13594122
731: If Fnd_Profile.VALUE(NAME => 'ICX_CLIENT_IANA_ENCODING') = 'GBK'
732: THEN
2766:
2767: -- begin insert value into l_trx_header
2768: SELECT ar_gta_trx_headers_all_s.NEXTVAL
2769: INTO l_trx_header.gta_trx_header_id
2770: FROM dual;
2771:
2772: --yao zhang add for bug 8234250 begin
2773: SELECT previous_customer_trx_id
2774: INTO l_origin_trx_id
3347: l_error_string,
3348: NULL,
3349: l_tp_registration_number --added by Yao Zhang for bug 7644235
3350: -- to distinguish different tax reg number on trx lines.
3351: FROM dual;
3352:
3353: END IF; -- IF (l_cm_warn = TRUE OR l_cm_warn2= TRUE)
3354:
3355: IF (l_gt_inv_excep = true or l_ar_inv_excep = true) THEN
4228: l_rac_bill_to_customer_name,
4229: NULL,
4230: l_error_string,
4231: NULL
4232: FROM dual;
4233: WHEN l_repeat_exception THEN
4234: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4235: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4236: G_MODULE_PREFIX || l_procedure_name,