[Home] [Help]
5044:
5045:
5046: -- Bug 6839052. Payment Cancellation cannot account for upgraded payments
5047: -- since the amounts are not populated in the pay dists table or in the
5048: -- xla distribution links table and XLA depends on these amounts for
5049: -- creating reversal accounting.
5050: --bug 10336668
5051: IF p_xla_event_rec.event_type_code IN
5052: ('PAYMENT CANCELLED','REFUND CANCELLED',
5410: '.begin', l_log_msg);
5411: END IF;
5412:
5413: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5414: l_log_msg := 'Deleting xla_distribution_links';
5415: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
5416: END IF;
5417:
5418: DELETE FROM xla_distribution_links
5414: l_log_msg := 'Deleting xla_distribution_links';
5415: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
5416: END IF;
5417:
5418: DELETE FROM xla_distribution_links
5419: WHERE application_id = 200
5420: AND ae_header_id IN
5421: (SELECT ae_header_id
5422: FROM xla_ae_headers aeh,
5429: AND upg_batch_id IS NOT NULL;
5430:
5431:
5432: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5433: l_log_msg := 'Inserting xla_distribution_links for event '||
5434: p_accounting_event_id;
5435: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
5436: END IF;
5437:
5439: -- AND AEH.ledger_id = ASP.Set_Of_Books_ID
5440: -- In this insert, we are prorating the amounts on the basis of the table
5441: -- ap_invoice_distributions_all
5442:
5443: INSERT INTO XLA_Distribution_Links t1
5444: (APPLICATION_ID,
5445: EVENT_ID,
5446: AE_HEADER_ID,
5447: AE_LINE_NUM,
5858: WHERE FC.Currency_Code = ADL.Base_Currency_Code);
5859:
5860:
5861: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5862: l_log_msg := 'Done inserting into xla_distribution_links for primary ledger';
5863: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,
5864: l_log_msg);
5865: END IF;
5866:
5864: l_log_msg);
5865: END IF;
5866:
5867: -- Bug 8708443 For all other non-primary ledgers, the proration of amounts
5868: -- while inserting into xla_distribution_links should happen on the basis of
5869: -- the amounts in the table ap_mc_invoice_dists, this is required becasue
5870: -- if the primary ledger and the secondary ledger have a different currency,
5871: -- then doing the proration for accounting entries of secondary ledger on the
5872: -- basis of the amounts in ap_invoice_distributions_all, which is in another
5871: -- then doing the proration for accounting entries of secondary ledger on the
5872: -- basis of the amounts in ap_invoice_distributions_all, which is in another
5873: -- currency would be wrong.
5874:
5875: INSERT INTO XLA_Distribution_Links t1
5876: (APPLICATION_ID,
5877: EVENT_ID,
5878: AE_HEADER_ID,
5879: AE_LINE_NUM,
6266: FND_Currencies FC
6267: WHERE FC.Currency_Code = ADL.Base_Currency_Code );
6268:
6269: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6270: l_log_msg := 'Done inserting into xla_distribution_links for non-primary ledgers';
6271: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,
6272: l_log_msg);
6273: END IF;
6274:
6288: FROM ap_payment_hist_dists aphd,
6289: ap_payment_history_all aph,
6290: xla_ae_headers xh,
6291: ap_system_parameters_all asp,
6292: xla_distribution_links xdl
6293: WHERE aphd.payment_history_id = aph.payment_history_id
6294: AND aph.related_event_id = xh.event_id
6295: AND xh.application_id = 200
6296: AND aphd.accounting_event_id = p_xla_event_rec.event_id --event_id of cancellation_event