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_ETAX_RECURR_UTIL dependencies on ARP_ETAX_RECURR_UTIL

Line 1: PACKAGE BODY ARP_ETAX_RECURR_UTIL AS

1: PACKAGE BODY ARP_ETAX_RECURR_UTIL AS
2: /* $Header: AREBTICB.pls 120.39.12020000.3 2012/11/23 12:30:08 kknekkal ship $ */
3:
4: /*=======================================================================+
5: | Package Globals

Line 36: debug('arp_etax_recurr_util.insert_header()+');

32: PROCEDURE insert_header(p_customer_trx_id IN NUMBER) IS
33:
34: BEGIN
35: IF PG_DEBUG in ('Y', 'C') THEN
36: debug('arp_etax_recurr_util.insert_header()+');
37: END IF;
38:
39: INSERT INTO ZX_TRX_HEADERS_GT
40: (

Line 158: debug('arp_etax_recurr_util.insert_header()-');

154: g_headers_inserted := SQL%ROWCOUNT;
155:
156: IF PG_DEBUG in ('Y', 'C') THEN
157: debug(' headers inserted : ' || g_headers_inserted);
158: debug('arp_etax_recurr_util.insert_header()-');
159: END IF;
160:
161: EXCEPTION
162: WHEN NO_DATA_FOUND

Line 164: debug('arp_etax_recurr_util.insert_header()- No transaction headers to process.');

160:
161: EXCEPTION
162: WHEN NO_DATA_FOUND
163: THEN
164: debug('arp_etax_recurr_util.insert_header()- No transaction headers to process.');
165: RETURN;
166: WHEN OTHERS
167: THEN
168: debug('EXCEPTION: ARP_ETAX_RECURR_UTIL.insert_header()-');

Line 168: debug('EXCEPTION: ARP_ETAX_RECURR_UTIL.insert_header()-');

164: debug('arp_etax_recurr_util.insert_header()- No transaction headers to process.');
165: RETURN;
166: WHEN OTHERS
167: THEN
168: debug('EXCEPTION: ARP_ETAX_RECURR_UTIL.insert_header()-');
169: RAISE;
170:
171: END insert_header;
172:

Line 197: debug('arp_etax_recurr_util.insert_line()+');

193: l_so_org_id VARCHAR2(20);
194: l_lines_updated NUMBER;
195: BEGIN
196: IF PG_DEBUG in ('Y', 'C') THEN
197: debug('arp_etax_recurr_util.insert_line()+');
198: END IF;
199:
200: l_so_org_id := oe_profile.value('SO_ORGANIZATION_ID',
201: arp_global.sysparam.org_id);

Line 406: debug('arp_etax_recurr_util.insert_line()-');

402:
403: IF PG_DEBUG in ('Y', 'C') THEN
404: l_lines_updated := SQL%ROWCOUNT;
405: debug('lines update (poo columns) = ' || l_lines_updated);
406: debug('arp_etax_recurr_util.insert_line()-');
407: END IF;
408:
409:
410: EXCEPTION

Line 413: debug('EXCEPTION: ARP_ETAX_RECURR_UTIL.insert_line()- ' ||

409:
410: EXCEPTION
411: WHEN OTHERS
412: THEN
413: debug('EXCEPTION: ARP_ETAX_RECURR_UTIL.insert_line()- ' ||
414: SQLERRM);
415: RAISE;
416: END insert_line;
417:

Line 444: debug('arp_etax_recurr_util.insert_tax_lines()+');

440: p_new_line_id IN NUMBER,
441: p_request_id IN NUMBER) IS
442: BEGIN
443: IF PG_DEBUG in ('Y', 'C') THEN
444: debug('arp_etax_recurr_util.insert_tax_lines()+');
445: END IF;
446:
447: /* NOTE: We are passing the line_id of the original tax line
448: into this table. That means that we can get that same line

Line 516: debug('arp_etax_recurr_util.insert_tax_lines()-');

512:
513: g_tax_lines_inserted := SQL%ROWCOUNT;
514:
515: IF PG_DEBUG in ('Y', 'C') THEN
516: debug('arp_etax_recurr_util.insert_tax_lines()-');
517: END IF;
518:
519: EXCEPTION
520: WHEN OTHERS

Line 522: debug('EXCEPTION: ARP_ETAX_RECURR_UTIL.insert_tax_lines()-');

518:
519: EXCEPTION
520: WHEN OTHERS
521: THEN
522: debug('EXCEPTION: ARP_ETAX_RECURR_UTIL.insert_tax_lines()-');
523: RAISE;
524:
525: END insert_tax_lines;
526:

Line 537: debug('arp_etax_recurr_util.build_ar_tax_lines()+');

533: l_rows NUMBER;
534:
535: BEGIN
536: IF PG_DEBUG in ('Y', 'C') THEN
537: debug('arp_etax_recurr_util.build_ar_tax_lines()+');
538: END IF;
539:
540: /* Dev Notes:
541:

Line 623: debug('arp_etax_recurr_util.build_ar_tax_lines()-');

619: arp_etax_util.set_recoverable(null, p_request_id, 'INV');
620:
621: IF PG_DEBUG in ('Y', 'C') THEN
622: debug(' Number of tax lines retrieved = ' || l_rows);
623: debug('arp_etax_recurr_util.build_ar_tax_lines()-');
624: END IF;
625: END build_ar_tax_lines;
626:
627: /* Procedure to extract error/validation messages from ZX

Line 643: debug('arp_etax_recurr_util.retrieve_tax_validation_errors()+');

639:
640: BEGIN
641:
642: IF PG_DEBUG in ('Y', 'C') THEN
643: debug('arp_etax_recurr_util.retrieve_tax_validation_errors()+');
644: END IF;
645:
646: /* Dev Notes:
647:

Line 671: debug('arp_etax_recurr_util.retrieve_tax_validation_errors()-');

667: p_error_count := l_errors;
668:
669: IF PG_DEBUG in ('Y', 'C') THEN
670: debug('Validation errors: ' || l_errors);
671: debug('arp_etax_recurr_util.retrieve_tax_validation_errors()-');
672: END IF;
673:
674: END retrieve_tax_validation_errors;
675:

Line 741: debug('arp_etax_recurr_util.calculate_tax()+');

737: l_return_status NUMBER := 0;
738: BEGIN
739: IF PG_DEBUG in ('Y', 'C')
740: THEN
741: debug('arp_etax_recurr_util.calculate_tax()+');
742: debug('request_id = ' || p_request_id);
743: END IF;
744:
745: /* Call validate_and_default_tax_attr */

Line 769: debug('arp_etax_recurr_util.calculate_tax()-');

765: /* 4904679 - removed detect_missing_tax_lines */
766:
767: IF PG_DEBUG in ('Y', 'C')
768: THEN
769: debug('arp_etax_recurr_util.calculate_tax()-');
770: END IF;
771: END calculate_tax;
772:
773:

Line 797: debug('EXCEPTION: ARP_ETAX_RECURR_UTIL.INITIALIZE()');

793: NULL;
794:
795: EXCEPTION
796: WHEN OTHERS THEN
797: debug('EXCEPTION: ARP_ETAX_RECURR_UTIL.INITIALIZE()');
798: RAISE;
799:
800: END ARP_ETAX_RECURR_UTIL;

Line 800: END ARP_ETAX_RECURR_UTIL;

796: WHEN OTHERS THEN
797: debug('EXCEPTION: ARP_ETAX_RECURR_UTIL.INITIALIZE()');
798: RAISE;
799:
800: END ARP_ETAX_RECURR_UTIL;