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.53.12020000.2 2012/07/27 06:57:23 kkikkise ship $ */
3:
4: /*=======================================================================+
5: | Package Globals

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

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

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

186: WHERE HGT.trx_id = IL.customer_trx_id
187: GROUP BY IL.customer_trx_id);
188:
189: IF PG_DEBUG in ('Y', 'C') THEN
190: debug('arp_etax_autoinv_util.insert_headers()-');
191: END IF;
192:
193: EXCEPTION
194: WHEN NO_DATA_FOUND

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

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

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

196: debug('arp_etax_autoinv_util.insert_headers()- No transaction headers to process.');
197: RETURN;
198: WHEN OTHERS
199: THEN
200: debug('EXCEPTION: ARP_ETAX_AUTOINV_UTIL.insert_headers()-');
201: RAISE;
202:
203: END insert_headers;
204:

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

229: l_so_org_id VARCHAR2(20);
230: l_lines_updated NUMBER;
231: BEGIN
232: IF PG_DEBUG in ('Y', 'C') THEN
233: debug('arp_etax_autoinv_util.insert_lines()+');
234: END IF;
235:
236: l_so_org_id := oe_profile.value('SO_ORGANIZATION_ID',
237: arp_global.sysparam.org_id);

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

498:
499: END IF;
500:
501: IF PG_DEBUG in ('Y', 'C') THEN
502: debug('arp_etax_autoinv_util.insert_lines()-');
503: END IF;
504:
505: EXCEPTION
506: WHEN OTHERS

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

504:
505: EXCEPTION
506: WHEN OTHERS
507: THEN
508: debug('EXCEPTION: ARP_ETAX_AUTOINV_UTIL.insert_lines()- ' ||
509: SQLERRM);
510: RAISE;
511: END insert_lines;
512:

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

530: p_phase IN VARCHAR2) IS
531:
532: BEGIN
533: IF PG_DEBUG in ('Y', 'C') THEN
534: debug('arp_etax_autoinv_util.insert_tax_lines()+');
535: END IF;
536:
537: /* Note that this code does not directly use p_phase
538: However, it does join to ZX_TRX_HEADERS_GT which

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

610: WHERE tax.trx_line_id = line.trx_line_id);
611: END IF;
612:
613: IF PG_DEBUG in ('Y', 'C') THEN
614: debug('arp_etax_autoinv_util.insert_tax_lines()-');
615: END IF;
616:
617: EXCEPTION
618: WHEN OTHERS

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

616:
617: EXCEPTION
618: WHEN OTHERS
619: THEN
620: debug('EXCEPTION: ARP_ETAX_AUTOINV_UTIL.insert_tax_lines()-');
621: RAISE;
622:
623: END insert_tax_lines;
624:

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

637: l_ret_val NUMBER := 0;
638:
639: BEGIN
640: IF PG_DEBUG in ('Y', 'C') THEN
641: debug('arp_etax_autoinv_util.detect_manual_tax()+');
642: END IF;
643:
644: /* This routine detects presence of at least one
645: manual tax line for invoices and credits separately.

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

715: END IF;
716:
717:
718: IF PG_DEBUG in ('Y', 'C') THEN
719: debug('arp_etax_autoinv_util.detect_manual_tax()-');
720: END IF;
721:
722: END detect_manual_tax;
723:

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

828:
829: EXCEPTION
830: WHEN OTHERS THEN
831: IF PG_DEBUG in ('Y', 'C') THEN
832: debug('EXCEPTION: ARP_ETAX_AUTOINV_UTIL.populate_ebt_gt()');
833: END IF;
834: RAISE;
835:
836: END populate_ebt_gt;

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

1146:
1147: BEGIN
1148: IF PG_DEBUG in ('Y', 'C')
1149: THEN
1150: debug('arp_etax_autoinv_util.calculate_tax()+');
1151: debug('request_id = ' || p_request_id);
1152: debug('phase = ' || p_phase);
1153: END IF;
1154:

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

1184: END IF;
1185:
1186: IF PG_DEBUG in ('Y', 'C')
1187: THEN
1188: debug('arp_etax_autoinv_util.calculate_tax()-');
1189: END IF;
1190: END calculate_tax;
1191:
1192: /*========================================================================

Line 1209: END ARP_ETAX_AUTOINV_UTIL;

1205: *=======================================================================*/
1206:
1207: BEGIN
1208: NULL;
1209: END ARP_ETAX_AUTOINV_UTIL;