APPS.ARP_ETAX_AUTOINV_UTIL dependencies on ARP_ETAX_AUTOINV_UTIL

Line 1: PACKAGE BODY ARP_ETAX_AUTOINV_UTIL AS

1: PACKAGE BODY ARP_ETAX_AUTOINV_UTIL AS
2: /* $Header: AREBTAIB.pls 120.31.12010000.9 2008/12/22 17:49:43 mraymond ship $ */
3:
4: /*=======================================================================+
5: | Package Globals

Line 46: debug('arp_etax_autoinv_util.insert_headers()+');

42: p_phase IN VARCHAR2) IS
43:
44: BEGIN
45: IF PG_DEBUG in ('Y', 'C') THEN
46: debug('arp_etax_autoinv_util.insert_headers()+');
47: END IF;
48:
49: INSERT INTO ZX_TRX_HEADERS_GT
50: (

Line 184: debug('arp_etax_autoinv_util.insert_headers()-');

180: WHERE HGT.trx_id = IL.customer_trx_id
181: GROUP BY IL.customer_trx_id);
182:
183: IF PG_DEBUG in ('Y', 'C') THEN
184: debug('arp_etax_autoinv_util.insert_headers()-');
185: END IF;
186:
187: EXCEPTION
188: WHEN NO_DATA_FOUND

Line 190: debug('arp_etax_autoinv_util.insert_headers()- No transaction headers to process.');

186:
187: EXCEPTION
188: WHEN NO_DATA_FOUND
189: THEN
190: debug('arp_etax_autoinv_util.insert_headers()- No transaction headers to process.');
191: RETURN;
192: WHEN OTHERS
193: THEN
194: debug('EXCEPTION: ARP_ETAX_AUTOINV_UTIL.insert_headers()-');

Line 194: debug('EXCEPTION: ARP_ETAX_AUTOINV_UTIL.insert_headers()-');

190: debug('arp_etax_autoinv_util.insert_headers()- No transaction headers to process.');
191: RETURN;
192: WHEN OTHERS
193: THEN
194: debug('EXCEPTION: ARP_ETAX_AUTOINV_UTIL.insert_headers()-');
195: RAISE;
196:
197: END insert_headers;
198:

Line 224: debug('arp_etax_autoinv_util.insert_lines()+');

220: l_so_org_id VARCHAR2(20);
221: l_lines_updated NUMBER;
222: BEGIN
223: IF PG_DEBUG in ('Y', 'C') THEN
224: debug('arp_etax_autoinv_util.insert_lines()+');
225: END IF;
226:
227: l_so_org_id := oe_profile.value('SO_ORGANIZATION_ID',
228: arp_global.sysparam.org_id);

Line 487: debug('arp_etax_autoinv_util.insert_lines()-');

483:
484: END IF;
485:
486: IF PG_DEBUG in ('Y', 'C') THEN
487: debug('arp_etax_autoinv_util.insert_lines()-');
488: END IF;
489:
490: EXCEPTION
491: WHEN OTHERS

Line 493: debug('EXCEPTION: ARP_ETAX_AUTOINV_UTIL.insert_lines()- ' ||

489:
490: EXCEPTION
491: WHEN OTHERS
492: THEN
493: debug('EXCEPTION: ARP_ETAX_AUTOINV_UTIL.insert_lines()- ' ||
494: SQLERRM);
495: RAISE;
496: END insert_lines;
497:

Line 519: debug('arp_etax_autoinv_util.insert_tax_lines()+');

515: p_phase IN VARCHAR2) IS
516:
517: BEGIN
518: IF PG_DEBUG in ('Y', 'C') THEN
519: debug('arp_etax_autoinv_util.insert_tax_lines()+');
520: END IF;
521:
522: /* Note that this code does not directly use p_phase
523: However, it does join to ZX_TRX_HEADERS_GT which

Line 599: debug('arp_etax_autoinv_util.insert_tax_lines()-');

595: WHERE tax.trx_line_id = line.trx_line_id);
596: END IF;
597:
598: IF PG_DEBUG in ('Y', 'C') THEN
599: debug('arp_etax_autoinv_util.insert_tax_lines()-');
600: END IF;
601:
602: EXCEPTION
603: WHEN OTHERS

Line 605: debug('EXCEPTION: ARP_ETAX_AUTOINV_UTIL.insert_tax_lines()-');

601:
602: EXCEPTION
603: WHEN OTHERS
604: THEN
605: debug('EXCEPTION: ARP_ETAX_AUTOINV_UTIL.insert_tax_lines()-');
606: RAISE;
607:
608: END insert_tax_lines;
609:

Line 626: debug('arp_etax_autoinv_util.detect_manual_tax()+');

622: l_ret_val NUMBER := 0;
623:
624: BEGIN
625: IF PG_DEBUG in ('Y', 'C') THEN
626: debug('arp_etax_autoinv_util.detect_manual_tax()+');
627: END IF;
628:
629: /* This routine detects presence of at least one
630: manual tax line for invoices and credits separately.

Line 704: debug('arp_etax_autoinv_util.detect_manual_tax()-');

700: END IF;
701:
702:
703: IF PG_DEBUG in ('Y', 'C') THEN
704: debug('arp_etax_autoinv_util.detect_manual_tax()-');
705: END IF;
706:
707: END detect_manual_tax;
708:

Line 817: debug('EXCEPTION: ARP_ETAX_AUTOINV_UTIL.populate_ebt_gt()');

813:
814: EXCEPTION
815: WHEN OTHERS THEN
816: IF PG_DEBUG in ('Y', 'C') THEN
817: debug('EXCEPTION: ARP_ETAX_AUTOINV_UTIL.populate_ebt_gt()');
818: END IF;
819: RAISE;
820:
821: END populate_ebt_gt;

Line 1128: debug('arp_etax_autoinv_util.calculate_tax()+');

1124:
1125: BEGIN
1126: IF PG_DEBUG in ('Y', 'C')
1127: THEN
1128: debug('arp_etax_autoinv_util.calculate_tax()+');
1129: debug('request_id = ' || p_request_id);
1130: debug('phase = ' || p_phase);
1131: END IF;
1132:

Line 1166: debug('arp_etax_autoinv_util.calculate_tax()-');

1162: END IF;
1163:
1164: IF PG_DEBUG in ('Y', 'C')
1165: THEN
1166: debug('arp_etax_autoinv_util.calculate_tax()-');
1167: END IF;
1168: END calculate_tax;
1169:
1170: /*========================================================================

Line 1187: END ARP_ETAX_AUTOINV_UTIL;

1183: *=======================================================================*/
1184:
1185: BEGIN
1186: NULL;
1187: END ARP_ETAX_AUTOINV_UTIL;