eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PAY_REL_CUST_PKG dependencies on ARP_DEBUG

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 71: arp_debug.debug(' p_worker_number:' || p_worker_number);

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
75: build it now */

Line 101: arp_debug.debug('l_pay_any = ' || l_pay_any);

97: END LOOP;
98:
99: IF PG_DEBUG in ('Y','C')
100: THEN
101: arp_debug.debug('l_pay_any = ' || l_pay_any);
102: arp_debug.debug('l_pay_top_down = ' || l_pay_top_down);
103: END IF;
104:
105: /* relationships do matter - build list */

Line 102: arp_debug.debug('l_pay_top_down = ' || l_pay_top_down);

98:
99: IF PG_DEBUG in ('Y','C')
100: THEN
101: arp_debug.debug('l_pay_any = ' || l_pay_any);
102: arp_debug.debug('l_pay_top_down = ' || l_pay_top_down);
103: END IF;
104:
105: /* relationships do matter - build list */
106:

Line 242: arp_debug.debug(' rows inserted: ' || l_rows_inserted);

238:
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

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 307: arp_debug.debug(' pay unrelated invoices = ' ||

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);
311: END IF;

Line 309: arp_debug.debug(' payment_rec_type = ' || p_payment_rec_type);

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);
311: END IF;
312:
313: /* Only build the first time we are called for a given

Line 310: arp_debug.debug(' transmission_id = ' || p_transmission_id);

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);
311: END IF;
312:
313: /* Only build the first time we are called for a given
314: transmission_id. This is called 2-3 times within lockbox

Line 341: arp_debug.debug('l_pay_any = ' || l_pay_any);

337: END LOOP;
338:
339: IF PG_DEBUG in ('Y','C')
340: THEN
341: arp_debug.debug('l_pay_any = ' || l_pay_any);
342: arp_debug.debug('l_pay_top_down = ' || l_pay_top_down);
343: END IF;
344:
345: /* relationships do matter - build list */

Line 342: arp_debug.debug('l_pay_top_down = ' || l_pay_top_down);

338:
339: IF PG_DEBUG in ('Y','C')
340: THEN
341: arp_debug.debug('l_pay_any = ' || l_pay_any);
342: arp_debug.debug('l_pay_top_down = ' || l_pay_top_down);
343: END IF;
344:
345: /* relationships do matter - build list */
346:

Line 493: arp_debug.debug(' inserted ' || l_rows_inserted || ' customer/relationships. ');

489: NULL;
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;

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 551: arp_debug.debug(' pay unrelated invoices = ' ||

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);
555: END IF;

Line 553: arp_debug.debug(' customer_id = ' || p_customer_id);

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);
555: END IF;
556:
557: IF NVL(G_BUILD_ID, -999) <> p_customer_id

Line 554: arp_debug.debug(' apply_date = ' || p_apply_date);

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);
555: END IF;
556:
557: IF NVL(G_BUILD_ID, -999) <> p_customer_id
558: OR NVL(G_PAY_UNRELATED, 'X') <> p_pay_unrelated_invoices

Line 578: arp_debug.debug(' Customer already loaded');

574: from ar_potential_customers_gt
575: where cust_account_id = p_customer_id;
576:
577: IF PG_DEBUG in ('Y','C') THEN
578: arp_debug.debug(' Customer already loaded');
579: END IF;
580: RETURN;
581: EXCEPTION
582: WHEN NO_DATA_FOUND THEN

Line 600: arp_debug.debug('l_pay_any = ' || l_pay_any);

596: END LOOP;
597:
598: IF PG_DEBUG in ('Y','C')
599: THEN
600: arp_debug.debug('l_pay_any = ' || l_pay_any);
601: arp_debug.debug('l_pay_top_down = ' || l_pay_top_down);
602: END IF;
603:
604: /* relationships do matter - build list */

Line 601: arp_debug.debug('l_pay_top_down = ' || l_pay_top_down);

597:
598: IF PG_DEBUG in ('Y','C')
599: THEN
600: arp_debug.debug('l_pay_any = ' || l_pay_any);
601: arp_debug.debug('l_pay_top_down = ' || l_pay_top_down);
602: END IF;
603:
604: /* relationships do matter - build list */
605:

Line 740: arp_debug.debug(' inserted ' || l_rows_inserted || ' customer/relationships. ');

736: NULL;
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;

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;