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_INVAPI_UTIL dependencies on ARP_ETAX_INVAPI_UTIL

Line 1: PACKAGE BODY ARP_ETAX_INVAPI_UTIL AS

1: PACKAGE BODY ARP_ETAX_INVAPI_UTIL AS
2: /* $Header: AREBTIAB.pls 120.37.12020000.2 2012/07/27 09:33:48 kkikkise ship $ */
3:
4: /*=======================================================================+
5: | Package Globals

Line 43: debug('arp_etax_invapi_util.insert_headers()+');

39: p_request_id IN NUMBER) IS
40:
41: BEGIN
42: IF PG_DEBUG in ('Y', 'C') THEN
43: debug('arp_etax_invapi_util.insert_headers()+');
44: END IF;
45:
46: /* 4666566 added ship_to columns. Note that invoice API
47: only supports ship_to at header level at this time

Line 186: debug('arp_etax_invapi_util.insert_headers()-');

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

Line 192: debug('arp_etax_invapi_util.insert_headers()- No transaction headers to process.');

188:
189: EXCEPTION
190: WHEN NO_DATA_FOUND
191: THEN
192: debug('arp_etax_invapi_util.insert_headers()- No transaction headers to process.');
193: RETURN;
194: WHEN OTHERS
195: THEN
196: debug('EXCEPTION: ARP_ETAX_INVAPI_UTIL.insert_headers()-');

Line 196: debug('EXCEPTION: ARP_ETAX_INVAPI_UTIL.insert_headers()-');

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

Line 223: debug('arp_etax_invapi_util.insert_lines()+');

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

Line 437: debug('arp_etax_invapi_util.insert_lines()-');

433:
434: IF PG_DEBUG in ('Y', 'C') THEN
435: l_lines_updated := SQL%ROWCOUNT;
436: debug('lines update (poo columns) = ' || l_lines_updated);
437: debug('arp_etax_invapi_util.insert_lines()-');
438: END IF;
439:
440:
441: EXCEPTION

Line 444: debug('EXCEPTION: ARP_ETAX_INVAPI_UTIL.insert_lines()- ' ||

440:
441: EXCEPTION
442: WHEN OTHERS
443: THEN
444: debug('EXCEPTION: ARP_ETAX_INVAPI_UTIL.insert_lines()- ' ||
445: SQLERRM);
446: RAISE;
447: END insert_lines;
448:

Line 460: debug('arp_etax_invapi_util.insert_tax_lines()+');

456: PROCEDURE insert_tax_lines IS
457:
458: BEGIN
459: IF PG_DEBUG in ('Y', 'C') THEN
460: debug('arp_etax_invapi_util.insert_tax_lines()+');
461: END IF;
462:
463:
464: INSERT INTO ZX_IMPORT_TAX_LINES_GT

Line 536: debug('arp_etax_invapi_util.insert_tax_lines()-');

532: END IF;
533:
534:
535: IF PG_DEBUG in ('Y', 'C') THEN
536: debug('arp_etax_invapi_util.insert_tax_lines()-');
537: END IF;
538:
539: EXCEPTION
540: WHEN OTHERS

Line 542: debug('EXCEPTION: ARP_ETAX_INVAPI_UTIL.insert_tax_lines()-');

538:
539: EXCEPTION
540: WHEN OTHERS
541: THEN
542: debug('EXCEPTION: ARP_ETAX_INVAPI_UTIL.insert_tax_lines()-');
543: RAISE;
544:
545: END insert_tax_lines;
546:

Line 573: debug('arp_etax_invapi_util.populate_ebt_gt()+');

569:
570: BEGIN
571:
572: IF PG_DEBUG in ('Y', 'C') THEN
573: debug('arp_etax_invapi_util.populate_ebt_gt()+');
574: END IF;
575:
576: /* Insert lines into ZX_TRX_HEADERS_GT */
577: insert_headers(p_request_id);

Line 589: debug('arp_etax_invapi_util.populate_ebt_gt()-');

585: IF PG_DEBUG in ('Y', 'C') THEN
586: debug('headers inserted : ' || g_headers_inserted);
587: debug('lines inserted : ' || g_lines_inserted);
588: debug('tax lines inserted : ' || g_tax_lines_inserted);
589: debug('arp_etax_invapi_util.populate_ebt_gt()-');
590: END IF;
591:
592: EXCEPTION
593: WHEN OTHERS THEN

Line 595: debug('EXCEPTION: ARP_ETAX_INVAPI_UTIL.populate_ebt_gt()');

591:
592: EXCEPTION
593: WHEN OTHERS THEN
594: IF PG_DEBUG in ('Y', 'C') THEN
595: debug('EXCEPTION: ARP_ETAX_INVAPI_UTIL.populate_ebt_gt()');
596: END IF;
597: RAISE;
598:
599: END populate_ebt_gt;

Line 618: debug('arp_etax_invapi_util.build_ar_tax_lines()+');

614:
615:
616: BEGIN
617: IF PG_DEBUG in ('Y', 'C') THEN
618: debug('arp_etax_invapi_util.build_ar_tax_lines()+');
619: END IF;
620:
621: /* Dev Notes:
622: 1) swapped zx_detail_tax_lines_gt to zx_lines per svaze in IM

Line 854: debug('arp_etax_invapi_util.build_ar_tax_lines()-');

850:
851: IF PG_DEBUG in ('Y', 'C') THEN
852: debug(' Number of tax lines retrieved autotax lines = ' || l_rows2);
853: debug(' Number of tax lines retrieved manualtax lines = ' || l_rows1);
854: debug('arp_etax_invapi_util.build_ar_tax_lines()-');
855: END IF;
856: END build_ar_tax_lines;
857:
858: /* Procedure to extract error/validation messages from ZX

Line 867: debug('arp_etax_invapi_util.retrieve_tax_validation_errors()+');

863: l_trx_validation_errors NUMBER := 0;
864: BEGIN
865:
866: IF PG_DEBUG in ('Y', 'C') THEN
867: debug('arp_etax_invapi_util.retrieve_tax_validation_errors()+');
868: END IF;
869:
870: /* Dev Notes:
871: When an error is returned on any transaction line, the API

Line 920: debug('arp_etax_invapi_util.retrieve_tax_validation_errors()-');

916:
917: IF PG_DEBUG in ('Y', 'C') THEN
918: debug('Validation errors: ' || l_trx_validation_errors);
919: debug('Calculation errors: ' || l_trx_errors);
920: debug('arp_etax_invapi_util.retrieve_tax_validation_errors()-');
921: END IF;
922:
923: END retrieve_tax_validation_errors;
924:

Line 935: debug('arp_etax_invapi_util.calculate_tax()+');

931: l_return_status NUMBER := 0;
932: BEGIN
933: IF PG_DEBUG in ('Y', 'C')
934: THEN
935: debug('arp_etax_invapi_util.calculate_tax()+');
936: END IF;
937:
938: /* Insert data into ebt tables */
939: populate_ebt_gt(p_request_id);

Line 976: debug('arp_etax_invapi_util.calculate_tax()-');

972: END IF;
973:
974: IF PG_DEBUG in ('Y', 'C')
975: THEN
976: debug('arp_etax_invapi_util.calculate_tax()-');
977: END IF;
978: END calculate_tax;
979:
980: PROCEDURE cleanup_tax(p_trx_id IN NUMBER) IS

Line 1025: debug('EXCEPTION: ARP_ETAX_INVAPI_UTIL.INITIALIZE()');

1021: END IF;
1022:
1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: debug('EXCEPTION: ARP_ETAX_INVAPI_UTIL.INITIALIZE()');
1026: RAISE;
1027:
1028: END ARP_ETAX_INVAPI_UTIL;

Line 1028: END ARP_ETAX_INVAPI_UTIL;

1024: WHEN OTHERS THEN
1025: debug('EXCEPTION: ARP_ETAX_INVAPI_UTIL.INITIALIZE()');
1026: RAISE;
1027:
1028: END ARP_ETAX_INVAPI_UTIL;