[Home] [Help]
1549: l_prorated_tax NUMBER;
1550: l_called_from_api VARCHAR2(1);
1551:
1552: --Bug#2750340
1553: l_xla_ev_rec arp_xla_events.xla_events_type;
1554: l_xla_doc_table VARCHAR2(20);
1555:
1556: -- Bug 7241111
1557: l_llca_exist_rev varchar(1) := 'N';
1698: l_xla_ev_rec.xla_to_doc_id := l_ra_id;
1699: l_xla_ev_rec.xla_mode := 'O';
1700: l_xla_ev_rec.xla_call := 'B';
1701: l_xla_ev_rec.xla_doc_table := 'APP';
1702: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
1703: END IF;
1704:
1705: IF PG_DEBUG in ('Y', 'C') THEN
1706: arp_debug.debug( 'p_ra_rec.rec_app_id :'||p_ra_rec.receivable_application_id);
1953: l_xla_ev_rec.xla_to_doc_id := l_ra_id;
1954: l_xla_ev_rec.xla_mode := 'O';
1955: l_xla_ev_rec.xla_call := 'B';
1956: l_xla_ev_rec.xla_doc_table := 'APP';
1957: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
1958: END IF;
1959: END IF;
1960:
1961: IF PG_DEBUG in ('Y', 'C') THEN
2188: l_xla_ev_rec.xla_to_doc_id := l_ra_id;
2189: l_xla_ev_rec.xla_mode := 'O';
2190: l_xla_ev_rec.xla_call := 'B';
2191: l_xla_ev_rec.xla_doc_table := 'APP';
2192: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
2193: END IF;
2194: END IF;
2195:
2196: IF PG_DEBUG in ('Y', 'C') THEN
3354: l_on_account_total NUMBER;
3355: l_ae_doc_rec ae_doc_rec_type;
3356:
3357: --Bug#2750340
3358: l_xla_ev_rec arp_xla_events.xla_events_type;
3359: l_xla_doc_table VARCHAR2(20);
3360:
3361:
3362: l_receipt_info_rec AR_AUTOREC_API.receipt_info_rec;
4328: l_xla_ev_rec.xla_to_doc_id := l_rec_ra_rec.receivable_application_id;
4329: l_xla_ev_rec.xla_mode := 'O';
4330: l_xla_ev_rec.xla_call := 'B';
4331: l_xla_ev_rec.xla_doc_table := 'APP';
4332: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
4333: END IF;
4334: --BUG#5416481
4335: IF l_inv_ra_rec.receivable_application_id IS NOT NULL THEN
4336: l_xla_ev_rec.xla_from_doc_id := l_inv_ra_rec.receivable_application_id;
4337: l_xla_ev_rec.xla_to_doc_id := l_inv_ra_rec.receivable_application_id;
4338: l_xla_ev_rec.xla_mode := 'O';
4339: l_xla_ev_rec.xla_call := 'B';
4340: l_xla_ev_rec.xla_doc_table := 'APP';
4341: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
4342: END IF;
4343: END IF;
4344:
4345: -- Return the receivable_application_id for the APP row to the client.
4702: l_allow_over_application VARCHAR2(1);
4703: l_effective_amount_applied NUMBER;
4704:
4705: --Bug#2750340
4706: l_xla_ev_rec arp_xla_events.xla_events_type;
4707: l_xla_doc_table VARCHAR2(20);
4708:
4709:
4710: l_nocopy_amt_due_remain ar_payment_schedules.amount_due_remaining%TYPE;
4962: l_xla_ev_rec.xla_to_doc_id := l_inv_ra_rec.receivable_application_id;
4963: l_xla_ev_rec.xla_mode := 'O';
4964: l_xla_ev_rec.xla_call := 'B';
4965: l_xla_ev_rec.xla_doc_table := 'CMAPP';
4966: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
4967: END IF;
4968: -----------------------------------------------------------------------
4969: -- Process MRC data
4970: -----------------------------------------------------------------------
5257: l_ae_doc_rec ae_doc_rec_type;
5258: l_prev_unapp_id NUMBER;
5259: l_called_from_api VARCHAR2(1);
5260: --Bug#2750340
5261: l_xla_ev_rec arp_xla_events.xla_events_type;
5262: l_xla_doc_table VARCHAR2(20);
5263:
5264: BEGIN
5265: IF PG_DEBUG in ('Y', 'C') THEN
5403: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
5404: l_xla_ev_rec.xla_mode := 'O';
5405: l_xla_ev_rec.xla_call := 'B';
5406: l_xla_ev_rec.xla_doc_table := 'APP';
5407: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
5408: END IF;
5409:
5410:
5411: --Set UNAPP id for PAIRING
5456: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
5457: l_xla_ev_rec.xla_mode := 'O';
5458: l_xla_ev_rec.xla_call := 'B';
5459: l_xla_ev_rec.xla_doc_table := 'APP';
5460: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
5461: END IF;
5462:
5463: --
5464: --Release 11.5 VAT changes, create paired UNAPP record accounting
5881: l_called_from_api VARCHAR2(1);
5882:
5883:
5884: --Bug#2750340
5885: l_xla_ev_rec arp_xla_events.xla_events_type;
5886: l_xla_doc_table VARCHAR2(20);
5887:
5888: -- Bug 7317841
5889: l_pymnt_trxn_ext_id_temp ar_cash_receipts.payment_trxn_extension_id%TYPE;
6310: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
6311: l_xla_ev_rec.xla_mode := 'O';
6312: l_xla_ev_rec.xla_call := 'B';
6313: l_xla_ev_rec.xla_doc_table := 'APP';
6314: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
6315: END IF;
6316:
6317: l_unapp_ra_rec := l_ra_rec;
6318:
6386: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
6387: l_xla_ev_rec.xla_mode := 'O';
6388: l_xla_ev_rec.xla_call := 'B';
6389: l_xla_ev_rec.xla_doc_table := 'APP';
6390: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
6391: END IF;
6392:
6393: arp_debug.debug('netted cash receipt id = ' || to_char(p_netted_cash_receipt_id));
6394: IF (p_receivables_trx_id = -16) THEN
7102:
7103: trade_mgt_err EXCEPTION;
7104:
7105: --Bug#2750340
7106: l_xla_ev_rec arp_xla_events.xla_events_type;
7107: l_xla_doc_table VARCHAR2(20);
7108:
7109: BEGIN
7110: IF PG_DEBUG in ('Y', 'C') THEN
7307: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
7308: l_xla_ev_rec.xla_mode := 'O';
7309: l_xla_ev_rec.xla_call := 'B';
7310: l_xla_ev_rec.xla_doc_table := 'APP';
7311: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
7312: END IF;
7313:
7314:
7315: --Set UNAPP id for PAIRING
7452: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
7453: l_xla_ev_rec.xla_mode := 'O';
7454: l_xla_ev_rec.xla_call := 'B';
7455: l_xla_ev_rec.xla_doc_table := 'APP';
7456: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
7457: END IF;
7458:
7459: -- Call mrc engine to process inserts in to receivable apps
7460: --
8753: l_activity_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
8754:
8755: API_exception EXCEPTION;
8756: --Bug#2750340
8757: l_xla_ev_rec arp_xla_events.xla_events_type;
8758: l_xla_doc_table VARCHAR2(20);
8759:
8760: BEGIN
8761: IF PG_DEBUG in ('Y', 'C') THEN
8984: l_xla_ev_rec.xla_to_doc_id := l_inv_ra_rec.receivable_application_id;
8985: l_xla_ev_rec.xla_mode := 'O';
8986: l_xla_ev_rec.xla_call := 'B';
8987: l_xla_ev_rec.xla_doc_table := 'CMAPP';
8988: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
8989: END IF;
8990: -----------------------------------------------------------------------
8991: -- Process MRC data
8992: -----------------------------------------------------------------------