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_UTIL dependencies on ARP_ETAX_UTIL

Line 1: PACKAGE BODY ARP_ETAX_UTIL AS

1: PACKAGE BODY ARP_ETAX_UTIL AS
2: /* $Header: AREBTUTB.pls 120.47.12010000.13 2008/12/01 10:00:07 ankuagar ship $ */
3:
4: /*=======================================================================+
5: | Package Globals

Line 70: arp_standard.debug('arp_etax_util.clear_ebt_gt()+');

66: l_owner VARCHAR2(30);
67:
68: BEGIN
69: IF PG_DEBUG in ('Y', 'C') THEN
70: arp_standard.debug('arp_etax_util.clear_ebt_gt()+');
71: END IF;
72:
73: /* The eTax GT tables are cleared upon commit. However
74: we cannot blindly issue a commit in between our first

Line 89: arp_standard.debug('arp_etax_util.clear_ebt_gt()-');

85: DELETE FROM ZX_TRX_TAX_LINK_GT;
86: DELETE FROM ZX_DETAIL_TAX_LINES_GT;
87:
88: IF PG_DEBUG in ('Y', 'C') THEN
89: arp_standard.debug('arp_etax_util.clear_ebt_gt()-');
90: END IF;
91: END;
92:
93: /* Procedure to retrieve TAX lines from ZX and populate

Line 117: arp_standard.debug('arp_etax_util.build_ar_tax_lines()+');

113: l_rows NUMBER;
114:
115: BEGIN
116: IF PG_DEBUG in ('Y', 'C') THEN
117: arp_standard.debug('arp_etax_util.build_ar_tax_lines()+');
118: END IF;
119:
120: /* Dev Notes:
121:

Line 262: arp_standard.debug('arp_etax_util.build_ar_tax_lines()-');

258: p_rows_inserted := l_rows;
259:
260: IF PG_DEBUG in ('Y', 'C') THEN
261: arp_standard.debug(' Number of tax lines retrieved = ' || l_rows);
262: arp_standard.debug('arp_etax_util.build_ar_tax_lines()-');
263: END IF;
264: END build_ar_tax_lines;
265:
266: /* Procedure for removing tax lines from AR prior to calculate

Line 290: arp_standard.debug('arp_etax_util.delete_tax_lines_from_ar()+');

286: l_rows NUMBER;
287:
288: BEGIN
289: IF PG_DEBUG in ('Y', 'C') THEN
290: arp_standard.debug('arp_etax_util.delete_tax_lines_from_ar()+');
291: END IF;
292:
293: DELETE FROM RA_CUST_TRX_LINE_GL_DIST gld
294: WHERE customer_trx_line_id in (

Line 323: arp_standard.debug('arp_etax_util.delete_tax_lines_from_ar()-');

319:
320: IF PG_DEBUG in ('Y', 'C') THEN
321: l_rows := SQL%ROWCOUNT;
322: arp_standard.debug(' Deleted tax lines = ' || l_rows);
323: arp_standard.debug('arp_etax_util.delete_tax_lines_from_ar()-');
324: END IF;
325:
326: END delete_tax_lines_from_ar;
327:

Line 359: debug('arp_etax_util.validate_tax_int()+');

355: arp_standard.debug('validate_and_default_tax_attr returns failure');
356: END IF;
357:
358: IF p_called_from_AI = 'Y' THEN
359: debug('arp_etax_util.validate_tax_int()+');
360: debug('ZX_API_PUB.validate_and_default_tax_attr returns failure');
361: END IF;
362:
363: IF l_return_status = FND_API.G_RET_STS_ERROR

Line 430: debug('arp_etax_util.calculate_tax_int()+');

426: arp_standard.debug('import_document_with_tax returns failure');
427: END IF;
428:
429: IF p_called_from_AI = 'Y' THEN
430: debug('arp_etax_util.calculate_tax_int()+');
431: debug('ZX_API_PUB.import_document_with_tax returns failure');
432: END IF;
433:
434: IF l_return_status = FND_API.G_RET_STS_ERROR

Line 495: arp_standard.debug('arp_etax_util.get_country_and_legal_ent()+');

491: l_msg VARCHAR2(2000);
492:
493: BEGIN
494: IF PG_DEBUG in ('Y', 'C') THEN
495: arp_standard.debug('arp_etax_util.get_country_and_legal_ent()+');
496: END IF;
497:
498:
499: xle_businessinfo_grp.get_operatingunit_info(l_return_status,

Line 515: arp_standard.debug('arp_etax_util.get_country_and_legal_ent()-');

511: IF PG_DEBUG in ('Y', 'C') THEN
512: arp_standard.debug('OU = ' || p_org_id);
513: arp_standard.debug('LE = ' || p_legal_ent);
514: arp_standard.debug('DEF Country = ' || p_def_country);
515: arp_standard.debug('arp_etax_util.get_country_and_legal_ent()-');
516: END IF;
517:
518: END get_country_and_legal_ent;
519:

Line 643: arp_debug.debug('arp_etax_util.synchronize_for_doc_seq()+');

639:
640: BEGIN
641: IF PG_DEBUG in ('Y', 'C')
642: THEN
643: arp_debug.debug('arp_etax_util.synchronize_for_doc_seq()+');
644: arp_debug.debug(' p_sync_line_data = ' || p_sync_line_data);
645: END IF;
646:
647: l_sync_trx_rec.application_id := 222;

Line 854: arp_standard.debug('arp_etax_util.synchronize_for_doc_seq()-');

850: END IF;
851:
852: IF PG_DEBUG in ('Y', 'C')
853: THEN
854: arp_standard.debug('arp_etax_util.synchronize_for_doc_seq()-');
855: END IF;
856:
857: END synchronize_for_doc_seq;
858:

Line 958: arp_standard.debug('arp_etax_util.global_document_update()+');

954:
955: BEGIN
956: IF PG_DEBUG in ('Y', 'C')
957: THEN
958: arp_standard.debug('arp_etax_util.global_document_update()+');
959: arp_standard.debug(' trx_id = ' || p_customer_trx_id);
960: arp_standard.debug(' req_id = ' || p_request_id);
961: arp_standard.debug(' action = ' || p_action);
962: END IF;

Line 1005: arp_standard.debug('arp_etax_util.global_document_update()-');

1001: END IF;
1002:
1003: IF PG_DEBUG in ('Y', 'C')
1004: THEN
1005: arp_standard.debug('arp_etax_util.global_document_update()-');
1006: END IF;
1007: END global_document_update;
1008:
1009: /*=======================================================================

Line 1070: arp_standard.debug('arp_etax_utils.get_default_tax_classification()+');

1066: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%type;
1067: l_concat_segments VARCHAR2(2000);
1068: l_fail_count NUMBER;
1069: BEGIN
1070: arp_standard.debug('arp_etax_utils.get_default_tax_classification()+');
1071:
1072: /* 4928047 - Call autoaccounting to get the ccid first, then
1073: feed it to zx */
1074: ARP_AUTO_ACCOUNTING.do_autoaccounting(

Line 1122: arp_standard.debug('arp_etax_util.get_default_tax_classification()-)');

1118: p_internal_organization_id => p_org_id,
1119: p_ccid => l_ccid,
1120: p_tax_classification_code => p_tax_classification_code);
1121:
1122: arp_standard.debug('arp_etax_util.get_default_tax_classification()-)');
1123:
1124: END get_default_tax_classification;
1125:
1126: /*=======================================================================

Line 1183: arp_standard.debug( 'arp_etax_util.set_default_tax_classification()+' );

1179: and zx.trx_line_id = tl.customer_trx_line_id;
1180:
1181: BEGIN
1182: IF PG_DEBUG = 'Y' THEN
1183: arp_standard.debug( 'arp_etax_util.set_default_tax_classification()+' );
1184: END IF;
1185:
1186: OPEN line_to_tax_class(p_request_id, p_phase);
1187: FETCH line_to_tax_class BULK COLLECT INTO

Line 1206: arp_standard.debug( 'arp_etax_util.set_default_tax_classification()-' );

1202:
1203: IF PG_DEBUG = 'Y' THEN
1204: arp_standard.debug( ' rows found : ' || l_rows_needing_update);
1205: arp_standard.debug( ' rows updated : ' || l_rows_updated);
1206: arp_standard.debug( 'arp_etax_util.set_default_tax_classification()-' );
1207: END IF;
1208:
1209: END;
1210:

Line 1221: arp_standard.debug('arp_etax_util.get_event_information()+)');

1217: l_trx_class RA_CUST_TRX_TYPES.TYPE%TYPE;
1218: l_return_var BOOLEAN := TRUE;
1219:
1220: BEGIN
1221: arp_standard.debug('arp_etax_util.get_event_information()+)');
1222:
1223: Select type.type
1224: into l_trx_class
1225: from ra_customer_trx trx,

Line 1248: arp_standard.debug('arp_etax_util.get_event_information()-)');

1244: p_event_type_code := l_trx_class || '_' || p_action;
1245:
1246: RETURN l_return_var;
1247:
1248: arp_standard.debug('arp_etax_util.get_event_information()-)');
1249: END get_event_information;
1250:
1251: /* Pulled from arp_tax_compound verbatum. Need to support same logic
1252: but wanted to get away from dependency to old tax logic */

Line 1270: arp_standard.debug( 'arp_etax_util.tax_curr_round(' || p_amount || ')+' );

1266: l_round_adj NUMBER;
1267:
1268: BEGIN
1269: IF PG_DEBUG = 'Y' THEN
1270: arp_standard.debug( 'arp_etax_util.tax_curr_round(' || p_amount || ')+' );
1271: END IF;
1272:
1273: l_rounding_rule := p_rounding_rule;
1274:

Line 1466: arp_util.debug('arp_etax_util.prorate_accounting()+');

1462:
1463:
1464: BEGIN
1465: IF PG_DEBUG in ('Y', 'C') THEN
1466: arp_util.debug('arp_etax_util.prorate_accounting()+');
1467: arp_util.debug(' p_mode = ' || p_mode);
1468: arp_util.debug(' p_trans_rec.trx_id = ' || p_transaction_rec.trx_id);
1469: arp_util.debug(' p_ra_app_id = ' || p_ra_app_id);
1470: arp_util.debug(' p_from_llca_call = ' || p_from_llca_call);

Line 1722: arp_util.debug('arp_etax_util.prorate_accounting()-');

1718: END IF;
1719: END IF;
1720:
1721: IF PG_DEBUG in ('Y', 'C') THEN
1722: arp_util.debug('arp_etax_util.prorate_accounting()-');
1723: END IF;
1724:
1725: END prorate_accounting;
1726:

Line 1741: arp_util.debug('arp_etax_util.distribute_recoverable()+');

1737: l_ae_sys_rec arp_acct_main.ae_sys_rec_type;
1738:
1739: BEGIN
1740: IF PG_DEBUG in ('Y', 'C') THEN
1741: arp_util.debug('arp_etax_util.distribute_recoverable()+');
1742: arp_util.debug(' p_rec_app_id = ' || p_rec_app_id);
1743: END IF;
1744:
1745: SELECT *

Line 1799: arp_util.debug('arp_etax_util.distribute_recoverable()-');

1795: END IF;
1796: END IF;
1797:
1798: IF PG_DEBUG in ('Y', 'C') THEN
1799: arp_util.debug('arp_etax_util.distribute_recoverable()-');
1800: END IF;
1801:
1802: END distribute_recoverable;
1803:

Line 1827: arp_util.debug('arp_etax_util.update_adj_and_ps()+');

1823: l_orig_tax_adj NUMBER := 0;
1824: l_ps_update_needed BOOLEAN := TRUE;
1825: BEGIN
1826: IF PG_DEBUG in ('Y', 'C') THEN
1827: arp_util.debug('arp_etax_util.update_adj_and_ps()+');
1828: arp_util.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
1829: arp_util.debug(' p_prorated_line = ' || p_prorated_line);
1830: arp_util.debug(' p_prorated_tax = ' || p_prorated_tax);
1831: END IF;

Line 1908: arp_util.debug('arp_etax_util.update_adj_and_ps()-');

1904:
1905: END IF;
1906:
1907: IF PG_DEBUG in ('Y', 'C') THEN
1908: arp_util.debug('arp_etax_util.update_adj_and_ps()-');
1909: END IF;
1910: END update_adj_and_ps;
1911:
1912: /* 5677984 redirected original prorate_recoverable to the new

Line 2358: arp_standard.debug('arp_etax_util.prorate_recoverable()-');

2354: p_prorated_tax := 0;
2355: END IF;
2356: IF (PG_DEBUG in ('Y','C')) THEN
2357: arp_standard.debug('receivables activity is not recoverable');
2358: arp_standard.debug('arp_etax_util.prorate_recoverable()-');
2359: END IF;
2360: RETURN;
2361: END IF;
2362:

Line 2894: arp_debug.debug('arp_etax_util.prorate_recoverable()-');

2890: RETURN;
2891: END IF;
2892:
2893: IF PG_DEBUG in ('Y', 'C') THEN
2894: arp_debug.debug('arp_etax_util.prorate_recoverable()-');
2895: END IF;
2896:
2897: END prorate_recoverable;
2898:

Line 3004: arp_standard.debug('arp_etax_util.adjust_for_inclusive_tax()+');

3000:
3001: BEGIN
3002: IF PG_DEBUG in ('Y', 'C')
3003: THEN
3004: arp_standard.debug('arp_etax_util.adjust_for_inclusive_tax()+');
3005: arp_standard.debug(' trx_id = ' || p_trx_id);
3006: arp_standard.debug(' req_id = ' || p_request_id);
3007: arp_standard.debug(' phase = ' || p_phase);
3008: END IF;

Line 3109: arp_standard.debug('arp_etax_util.adjust_for_inclusive_tax()-');

3105: END IF;
3106:
3107: IF PG_DEBUG in ('Y', 'C')
3108: THEN
3109: arp_standard.debug('arp_etax_util.adjust_for_inclusive_tax()-');
3110: END IF;
3111: END adjust_for_inclusive_tax;
3112:
3113: /* Public Procedure - sets recoverable columns for transaction or batch.

Line 3125: arp_standard.debug('arp_etax_util.set_recoverable()+');

3121:
3122: BEGIN
3123: IF PG_DEBUG in ('Y', 'C')
3124: THEN
3125: arp_standard.debug('arp_etax_util.set_recoverable()+');
3126: arp_standard.debug(' trx_id = ' || p_trx_id);
3127: arp_standard.debug(' req_id = ' || p_request_id);
3128: arp_standard.debug(' phase = ' || p_phase);
3129: END IF;

Line 3171: arp_standard.debug('arp_etax_util.set_recoverable()-');

3167: END IF;
3168:
3169: IF PG_DEBUG in ('Y', 'C')
3170: THEN
3171: arp_standard.debug('arp_etax_util.set_recoverable()-');
3172: END IF;
3173: END set_recoverable;
3174:
3175: /* public function get_tax_account

Line 3239: arp_standard.debug('arp_etax_util.get_tax_account()+');

3235: l_return_status VARCHAR2(128);
3236: l_gl_date DATE;
3237: BEGIN
3238: /* Debug +/
3239: arp_standard.debug('arp_etax_util.get_tax_account()+');
3240: arp_standard.debug(' p_subject_id = ' || p_subject_id);
3241: arp_standard.debug(' p_gl_date = ' || p_gl_date);
3242: arp_standard.debug(' p_desired = ' || p_desired_account);
3243: arp_standard.debug(' p_subject_tab= ' || p_subject_table);

Line 3502: arp_standard.debug('arp_etax_util.calc_applied_and_remaining()+');

3498: l_gt_id NUMBER;
3499: BEGIN
3500: IF PG_DEBUG in ('Y', 'C')
3501: THEN
3502: arp_standard.debug('arp_etax_util.calc_applied_and_remaining()+');
3503: arp_standard.debug(' p_amt = ' || p_amt);
3504: arp_standard.debug(' p_receipt_id = ' || p_receipt_id);
3505: arp_standard.debug(' p_apply_date = ' || p_apply_date);
3506: arp_standard.debug(' p_trx_id = ' || p_trx_id);

Line 3627: arp_standard.debug('arp_etax_util.calc_applied_and_remaining()-');

3623: END IF;
3624:
3625: IF PG_DEBUG in ('Y', 'C')
3626: THEN
3627: arp_standard.debug('arp_etax_util.calc_applied_and_remaining()-');
3628: END IF;
3629: END calc_applied_and_remaining;
3630:
3631: /* PUBLIC FUNCTION get_discount_rate

Line 3706: arp_debug.debug('arp_etax_util.validate_for_tax()+');

3702: */
3703: BEGIN
3704: IF PG_DEBUG in ('Y', 'C')
3705: THEN
3706: arp_debug.debug('arp_etax_util.validate_for_tax()+');
3707: END IF;
3708:
3709:
3710: DELETE from ZX_TRX_HEADERS_GT zx

Line 3761: arp_debug.debug('arp_etax_util.validate_for_tax()-');

3757: END IF;
3758:
3759: IF PG_DEBUG in ('Y', 'C')
3760: THEN
3761: arp_debug.debug('arp_etax_util.validate_for_tax()-');
3762: END IF;
3763:
3764: END validate_for_tax;
3765:

Line 3785: END ARP_ETAX_UTIL;

3781: *=======================================================================*/
3782:
3783: BEGIN
3784: NULL;
3785: END ARP_ETAX_UTIL;