APPS.AR_AUTOREM_API dependencies on XLA_EVENTS

Line 1892: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;

1888: AR_REMIT_GT rec
1889: where hist.STATUS = 'REMITTED'
1890: and hist.cash_receipt_id = rec.cash_receipt_id;
1891:
1892: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;
1893:
1894: -- insert DIST variables.
1895: ins_dist1 long;
1896: rem_t4 number;

Line 2390: arp_xla_events.create_events(l_xla_ev_rec);

2386: fnd_file.put_line(FND_FILE.LOG,'xla_from_doc_id= '|| 'O');
2387: fnd_file.put_line(FND_FILE.LOG,'xla_from_doc_id= '|| 'B');
2388: END IF;
2389:
2390: arp_xla_events.create_events(l_xla_ev_rec);
2391:
2392:
2393: IF PG_DEBUG in ('Y', 'C') THEN
2394: fnd_file.put_line(FND_FILE.LOG,'RETURN STATUS FROM XLA () '|| to_char(SQLCODE));

Line 2673: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;

2669: AR_REMIT_GT rec
2670: where hist.STATUS = 'REMITTED'
2671: and hist.cash_receipt_id = rec.cash_receipt_id;
2672:
2673: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;
2674:
2675: -- insert DIST variables.
2676: ins_dist1 long;
2677: rem_t4 number;

Line 3162: arp_xla_events.create_events(l_xla_ev_rec);

3158: fnd_file.put_line(FND_FILE.LOG,'xla_from_doc_id= '|| 'O');
3159: fnd_file.put_line(FND_FILE.LOG,'xla_from_doc_id= '|| 'B');
3160: END IF;
3161:
3162: arp_xla_events.create_events(l_xla_ev_rec);
3163:
3164:
3165: IF PG_DEBUG in ('Y', 'C') THEN
3166: fnd_file.put_line(FND_FILE.LOG,'RETURN STATUS FROM XLA () '|| to_char(SQLCODE));

Line 6053: /* Start of delete XLA events code. Doing this is bulk */

6049: IF PG_DEBUG in ('Y','C') THEN
6050: fnd_file.put_line(FND_FILE.LOG,' rows DELETED CRH = ' || SQL%ROWCOUNT );
6051: END IF;
6052:
6053: /* Start of delete XLA events code. Doing this is bulk */
6054: BEGIN
6055:
6056: IF pg_debug IN('Y', 'C') THEN
6057: arp_debug.debug('Start calling xla delete_bulk_events');

Line 6058: arp_debug.debug('Inserting into xla_events_int_gt...');

6054: BEGIN
6055:
6056: IF pg_debug IN('Y', 'C') THEN
6057: arp_debug.debug('Start calling xla delete_bulk_events');
6058: arp_debug.debug('Inserting into xla_events_int_gt...');
6059: END IF;
6060:
6061: INSERT INTO xla_events_int_gt(
6062: event_id,

Line 6061: INSERT INTO xla_events_int_gt(

6057: arp_debug.debug('Start calling xla delete_bulk_events');
6058: arp_debug.debug('Inserting into xla_events_int_gt...');
6059: END IF;
6060:
6061: INSERT INTO xla_events_int_gt(
6062: event_id,
6063: ledger_id,
6064: entity_code,
6065: application_id,

Line 6114: xla_events xe

6110: reference_date_4,
6111: on_hold_flag
6112: FROM ar_cash_receipts cr,
6113: xla_transaction_entities_upg xte,
6114: xla_events xe
6115: WHERE cr.request_id = p_request_id
6116: AND cr.cc_error_flag = 'Y'
6117: AND nvl(xte.source_id_int_1, -99) = cr.cash_receipt_id
6118: AND xte.ledger_id = arp_standard.sysparm.set_of_books_id

Line 6155: arp_debug.debug('Calling xla_events_pub_pkg.delete_bulk_events()');

6151: AND mcd.event_id = xe.event_id));
6152:
6153: IF pg_debug IN('Y', 'C') THEN
6154: arp_debug.debug('rows inserted into xla gt table = ' || SQL % rowcount);
6155: arp_debug.debug('Calling xla_events_pub_pkg.delete_bulk_events()');
6156: END IF;
6157:
6158: xla_events_pub_pkg.delete_bulk_events(222);
6159:

Line 6158: xla_events_pub_pkg.delete_bulk_events(222);

6154: arp_debug.debug('rows inserted into xla gt table = ' || SQL % rowcount);
6155: arp_debug.debug('Calling xla_events_pub_pkg.delete_bulk_events()');
6156: END IF;
6157:
6158: xla_events_pub_pkg.delete_bulk_events(222);
6159:
6160: IF pg_debug IN('Y', 'C') THEN
6161: arp_debug.debug('End calling xla delete_bulk_events');
6162: END IF;

Line 6168: arp_debug.debug('Error in call to xla_events_pub_pkg.delete_bulk_events ' || sqlerrm);

6164: EXCEPTION
6165: WHEN others THEN
6166:
6167: IF pg_debug IN('Y', 'C') THEN
6168: arp_debug.debug('Error in call to xla_events_pub_pkg.delete_bulk_events ' || sqlerrm);
6169: END IF;
6170:
6171: END;
6172:

Line 6173: /* End of delete XLA events code */

6169: END IF;
6170:
6171: END;
6172:
6173: /* End of delete XLA events code */
6174:
6175:
6176:
6177: END IF;