APPS.ARP_PAY_REL_CUST_PKG dependencies on ARP_PAY_REL_CUST_PKG

Line 1: PACKAGE BODY ARP_PAY_REL_CUST_PKG AS

1: PACKAGE BODY ARP_PAY_REL_CUST_PKG AS
2: /* $Header: ARPRCPKB.pls 120.2 2011/03/17 18:03:48 mraymond noship $ */
3:
4: /*=======================================================================+
5: | Package Global Constants

Line 70: arp_debug.debug('arp_pay_rel_cust_pkg.build_for_automatch()+');

66: l_ins_sql CLOB;
67: l_rows_inserted NUMBER;
68: BEGIN
69: IF PG_DEBUG in ('Y', 'C') THEN
70: arp_debug.debug('arp_pay_rel_cust_pkg.build_for_automatch()+');
71: arp_debug.debug(' p_worker_number:' || p_worker_number);
72: END IF;
73:
74: /* Determine if this list has already been built, and if not

Line 243: arp_debug.debug('arp_pay_rel_cust_pkg.build_for_automatch()-');

239: END IF; /* end pay_unrelated */
240:
241: IF PG_DEBUG in ('Y', 'C') THEN
242: arp_debug.debug(' rows inserted: ' || l_rows_inserted);
243: arp_debug.debug('arp_pay_rel_cust_pkg.build_for_automatch()-');
244: END IF;
245: EXCEPTION
246: WHEN OTHERS THEN
247: IF PG_DEBUG in ('Y', 'C') THEN

Line 248: arp_debug.debug('EXCEPTION: arp_pay_rel_cust_pkg.build_for_automatch');

244: END IF;
245: EXCEPTION
246: WHEN OTHERS THEN
247: IF PG_DEBUG in ('Y', 'C') THEN
248: arp_debug.debug('EXCEPTION: arp_pay_rel_cust_pkg.build_for_automatch');
249: END IF;
250: RAISE;
251: END build_for_automatch;
252:

Line 306: arp_debug.debug('arp_pay_rel_cust_pkg.build_for_lockbox()+');

302: cur_ins INTEGER;
303:
304: BEGIN
305: IF PG_DEBUG in ('Y','C') THEN
306: arp_debug.debug('arp_pay_rel_cust_pkg.build_for_lockbox()+');
307: arp_debug.debug(' pay unrelated invoices = ' ||
308: p_pay_unrelated_invoices);
309: arp_debug.debug(' payment_rec_type = ' || p_payment_rec_type);
310: arp_debug.debug(' transmission_id = ' || p_transmission_id);

Line 494: arp_debug.debug('arp_pay_rel_cust_pkg.build_for_lockbox()-');

490: END IF;
491:
492: IF PG_DEBUG in ('Y','C') THEN
493: arp_debug.debug(' inserted ' || l_rows_inserted || ' customer/relationships. ');
494: arp_debug.debug('arp_pay_rel_cust_pkg.build_for_lockbox()-');
495: END IF;
496:
497: END build_for_lockbox;
498:

Line 550: arp_debug.debug('arp_pay_rel_cust_pkg.build_for_app_lov()+');

546: cur_ins INTEGER;
547: l_is_cust_there VARCHAR2(20);
548: BEGIN
549: IF PG_DEBUG in ('Y','C') THEN
550: arp_debug.debug('arp_pay_rel_cust_pkg.build_for_app_lov()+');
551: arp_debug.debug(' pay unrelated invoices = ' ||
552: p_pay_unrelated_invoices);
553: arp_debug.debug(' customer_id = ' || p_customer_id);
554: arp_debug.debug(' apply_date = ' || p_apply_date);

Line 741: arp_debug.debug('arp_pay_rel_cust_pkg.build_for_app_lov()-');

737: END IF;
738:
739: IF PG_DEBUG in ('Y','C') THEN
740: arp_debug.debug(' inserted ' || l_rows_inserted || ' customer/relationships. ');
741: arp_debug.debug('arp_pay_rel_cust_pkg.build_for_app_lov()-');
742: END IF;
743:
744: END build_for_app_lov;
745:

Line 749: arp_debug.debug('arp_pay_rel_cust_pkg.clear_table()+');

745:
746: PROCEDURE clear_table IS
747: BEGIN
748: IF PG_DEBUG in ('Y','C') THEN
749: arp_debug.debug('arp_pay_rel_cust_pkg.clear_table()+');
750: END IF;
751:
752: delete from ar_potential_customers_gt;
753:

Line 755: arp_debug.debug('arp_pay_rel_cust_pkg.clear_table()-');

751:
752: delete from ar_potential_customers_gt;
753:
754: IF PG_DEBUG in ('Y','C') THEN
755: arp_debug.debug('arp_pay_rel_cust_pkg.clear_table()-');
756: END IF;
757: END clear_table;
758:
759: END ARP_PAY_REL_CUST_PKG;

Line 759: END ARP_PAY_REL_CUST_PKG;

755: arp_debug.debug('arp_pay_rel_cust_pkg.clear_table()-');
756: END IF;
757: END clear_table;
758:
759: END ARP_PAY_REL_CUST_PKG;