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.92.12020000.4 2012/07/26 05:25:14 ashlkuma ship $ */
3:
4: /*=======================================================================+
5: | Package Globals

Line 71: debug('arp_etax_util.clear_ebt_gt()+');

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

Line 90: debug('arp_etax_util.clear_ebt_gt()-');

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

Line 118: debug('arp_etax_util.build_ar_tax_lines()+');

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

Line 263: debug('arp_etax_util.build_ar_tax_lines()-');

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

Line 292: debug('arp_etax_util.delete_tax_lines_from_ar()+');

288: l_posted VARCHAR2(50);
289:
290: BEGIN
291: IF PG_DEBUG in ('Y', 'C') THEN
292: debug('arp_etax_util.delete_tax_lines_from_ar()+');
293: END IF;
294:
295: /* 8578810 - prevent deleting of posted rows or creation of additional
296: or duplicate distributions for late tax calculations */

Line 348: debug('arp_etax_util.delete_tax_lines_from_ar()-');

344:
345: IF PG_DEBUG in ('Y', 'C') THEN
346: l_rows := SQL%ROWCOUNT;
347: debug(' Deleted tax lines = ' || l_rows);
348: debug('arp_etax_util.delete_tax_lines_from_ar()-');
349: END IF;
350:
351: END delete_tax_lines_from_ar;
352:

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

380: debug('validate_and_default_tax_attr returns failure');
381: END IF;
382:
383: IF p_called_from_AI = 'Y' THEN
384: debug('arp_etax_util.validate_tax_int()+');
385: debug('ZX_API_PUB.validate_and_default_tax_attr returns failure');
386: END IF;
387:
388: IF l_return_status = FND_API.G_RET_STS_ERROR

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

451: debug('import_document_with_tax returns failure');
452: END IF;
453:
454: IF p_called_from_AI = 'Y' THEN
455: debug('arp_etax_util.calculate_tax_int()+');
456: debug('ZX_API_PUB.import_document_with_tax returns failure');
457: END IF;
458:
459: IF l_return_status = FND_API.G_RET_STS_ERROR

Line 520: debug('arp_etax_util.get_country_and_legal_ent()+');

516: l_msg VARCHAR2(2000);
517:
518: BEGIN
519: IF PG_DEBUG in ('Y', 'C') THEN
520: debug('arp_etax_util.get_country_and_legal_ent()+');
521: END IF;
522:
523:
524: xle_businessinfo_grp.get_operatingunit_info(l_return_status,

Line 540: debug('arp_etax_util.get_country_and_legal_ent()-');

536: IF PG_DEBUG in ('Y', 'C') THEN
537: debug('OU = ' || p_org_id);
538: debug('LE = ' || p_legal_ent);
539: debug('DEF Country = ' || p_def_country);
540: debug('arp_etax_util.get_country_and_legal_ent()-');
541: END IF;
542:
543: END get_country_and_legal_ent;
544:

Line 670: debug('arp_etax_util.synchronize_for_doc_seq()+');

666:
667: BEGIN
668: IF PG_DEBUG in ('Y', 'C')
669: THEN
670: debug('arp_etax_util.synchronize_for_doc_seq()+');
671: debug(' p_sync_line_data = ' || p_sync_line_data);
672: END IF;
673:
674: l_sync_trx_rec.application_id := 222;

Line 895: debug('arp_etax_util.synchronize_for_doc_seq()-');

891: END IF;
892:
893: IF PG_DEBUG in ('Y', 'C')
894: THEN
895: debug('arp_etax_util.synchronize_for_doc_seq()-');
896: END IF;
897:
898: END synchronize_for_doc_seq;
899:

Line 999: debug('arp_etax_util.global_document_update()+');

995:
996: BEGIN
997: IF PG_DEBUG in ('Y', 'C')
998: THEN
999: debug('arp_etax_util.global_document_update()+');
1000: debug(' trx_id = ' || p_customer_trx_id);
1001: debug(' req_id = ' || p_request_id);
1002: debug(' action = ' || p_action);
1003: END IF;

Line 1046: debug('arp_etax_util.global_document_update()-');

1042: END IF;
1043:
1044: IF PG_DEBUG in ('Y', 'C')
1045: THEN
1046: debug('arp_etax_util.global_document_update()-');
1047: END IF;
1048: END global_document_update;
1049:
1050: /*=======================================================================

Line 1111: debug('arp_etax_utils.get_default_tax_classification()+');

1107: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%type;
1108: l_concat_segments VARCHAR2(2000);
1109: l_fail_count NUMBER;
1110: BEGIN
1111: debug('arp_etax_utils.get_default_tax_classification()+');
1112:
1113: /* 4928047 - Call autoaccounting to get the ccid first, then
1114: feed it to zx */
1115: ARP_AUTO_ACCOUNTING.do_autoaccounting(

Line 1163: debug('arp_etax_util.get_default_tax_classification()-)');

1159: p_internal_organization_id => p_org_id,
1160: p_ccid => l_ccid,
1161: p_tax_classification_code => p_tax_classification_code);
1162:
1163: debug('arp_etax_util.get_default_tax_classification()-)');
1164:
1165: END get_default_tax_classification;
1166:
1167: /*=======================================================================

Line 1222: debug( 'arp_etax_util.set_default_tax_classification()+' );

1218: and zx.trx_line_id = tl.customer_trx_line_id;
1219:
1220: BEGIN
1221: IF PG_DEBUG = 'Y' THEN
1222: debug( 'arp_etax_util.set_default_tax_classification()+' );
1223: END IF;
1224:
1225: OPEN line_to_tax_class(p_request_id, p_phase);
1226: FETCH line_to_tax_class BULK COLLECT INTO

Line 1245: debug( 'arp_etax_util.set_default_tax_classification()-' );

1241:
1242: IF PG_DEBUG = 'Y' THEN
1243: debug( ' rows found : ' || l_rows_needing_update);
1244: debug( ' rows updated : ' || l_rows_updated);
1245: debug( 'arp_etax_util.set_default_tax_classification()-' );
1246: END IF;
1247:
1248: END;
1249:

Line 1262: debug('arp_etax_util.get_event_information()+)');

1258:
1259: BEGIN
1260:
1261: IF PG_DEBUG = 'Y' THEN
1262: debug('arp_etax_util.get_event_information()+)');
1263: END IF;
1264:
1265: BEGIN
1266:

Line 1308: debug('arp_etax_util.get_event_information()-)');

1304: IF PG_DEBUG = 'Y' THEN
1305: debug('TRX_CLASS = ' || l_trx_class || ', TRX_CLASS_CODE = ' ||
1306: p_event_class_code || ', P_EVENT_TYPE_CODE = ' ||
1307: p_event_type_code);
1308: debug('arp_etax_util.get_event_information()-)');
1309: END IF;
1310:
1311: RETURN l_return_var;
1312:

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

1330: l_round_adj NUMBER;
1331:
1332: BEGIN
1333: IF PG_DEBUG = 'Y' THEN
1334: debug( 'arp_etax_util.tax_curr_round(' || p_amount || ')+' );
1335: END IF;
1336:
1337: l_rounding_rule := p_rounding_rule;
1338:

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

1526:
1527:
1528: BEGIN
1529: IF PG_DEBUG in ('Y', 'C') THEN
1530: arp_util.debug('arp_etax_util.prorate_accounting()+');
1531: arp_util.debug(' p_mode = ' || p_mode);
1532: arp_util.debug(' p_trans_rec.trx_id = ' || p_transaction_rec.trx_id);
1533: arp_util.debug(' p_ra_app_id = ' || p_ra_app_id);
1534: arp_util.debug(' p_from_llca_call = ' || p_from_llca_call);

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

1782: END IF;
1783: END IF;
1784:
1785: IF PG_DEBUG in ('Y', 'C') THEN
1786: arp_util.debug('arp_etax_util.prorate_accounting()-');
1787: END IF;
1788:
1789: END prorate_accounting;
1790:

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

1801: l_ae_sys_rec arp_acct_main.ae_sys_rec_type;
1802:
1803: BEGIN
1804: IF PG_DEBUG in ('Y', 'C') THEN
1805: arp_util.debug('arp_etax_util.distribute_recoverable()+');
1806: arp_util.debug(' p_rec_app_id = ' || p_rec_app_id);
1807: END IF;
1808:
1809: SELECT *

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

1859: END IF;
1860: END IF;
1861:
1862: IF PG_DEBUG in ('Y', 'C') THEN
1863: arp_util.debug('arp_etax_util.distribute_recoverable()-');
1864: END IF;
1865:
1866: END distribute_recoverable;
1867:

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

1887: l_orig_tax_adj NUMBER := 0;
1888: l_ps_update_needed BOOLEAN := TRUE;
1889: BEGIN
1890: IF PG_DEBUG in ('Y', 'C') THEN
1891: arp_util.debug('arp_etax_util.update_adj_and_ps()+');
1892: arp_util.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
1893: arp_util.debug(' p_prorated_line = ' || p_prorated_line);
1894: arp_util.debug(' p_prorated_tax = ' || p_prorated_tax);
1895: END IF;

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

1968:
1969: END IF;
1970:
1971: IF PG_DEBUG in ('Y', 'C') THEN
1972: arp_util.debug('arp_etax_util.update_adj_and_ps()-');
1973: END IF;
1974: END update_adj_and_ps;
1975:
1976: /* 5677984 redirected original prorate_recoverable to the new

Line 2390: debug('arp_etax_util.prorate_recoverable()-');

2386: p_prorated_tax := 0;
2387: END IF;
2388: IF (PG_DEBUG in ('Y','C')) THEN
2389: debug('receivables activity is not recoverable');
2390: debug('arp_etax_util.prorate_recoverable()-');
2391: END IF;
2392: RETURN;
2393: END IF;
2394:

Line 2951: debug('arp_etax_util.prorate_recoverable()-');

2947: RETURN;
2948: END IF;
2949:
2950: IF PG_DEBUG in ('Y', 'C') THEN
2951: debug('arp_etax_util.prorate_recoverable()-');
2952: END IF;
2953:
2954: END prorate_recoverable;
2955:

Line 3066: debug('arp_etax_util.adjust_for_inclusive_tax()+');

3062:
3063: BEGIN
3064: IF PG_DEBUG in ('Y', 'C')
3065: THEN
3066: debug('arp_etax_util.adjust_for_inclusive_tax()+');
3067: debug(' trx_id = ' || p_trx_id);
3068: debug(' req_id = ' || p_request_id);
3069: debug(' phase = ' || p_phase);
3070: END IF;

Line 3171: debug('arp_etax_util.adjust_for_inclusive_tax()-');

3167: END IF;
3168:
3169: IF PG_DEBUG in ('Y', 'C')
3170: THEN
3171: debug('arp_etax_util.adjust_for_inclusive_tax()-');
3172: END IF;
3173: END adjust_for_inclusive_tax;
3174:
3175: /* Public Procedure - sets recoverable columns for transaction or batch.

Line 3187: debug('arp_etax_util.set_recoverable()+');

3183:
3184: BEGIN
3185: IF PG_DEBUG in ('Y', 'C')
3186: THEN
3187: debug('arp_etax_util.set_recoverable()+');
3188: debug(' trx_id = ' || p_trx_id);
3189: debug(' req_id = ' || p_request_id);
3190: debug(' phase = ' || p_phase);
3191: END IF;

Line 3233: debug('arp_etax_util.set_recoverable()-');

3229: END IF;
3230:
3231: IF PG_DEBUG in ('Y', 'C')
3232: THEN
3233: debug('arp_etax_util.set_recoverable()-');
3234: END IF;
3235: END set_recoverable;
3236:
3237: /* public function get_tax_account

Line 3301: debug('arp_etax_util.get_tax_account()+');

3297: l_return_status VARCHAR2(128);
3298: l_gl_date DATE;
3299: BEGIN
3300: /* Debug +/
3301: debug('arp_etax_util.get_tax_account()+');
3302: debug(' p_subject_id = ' || p_subject_id);
3303: debug(' p_gl_date = ' || p_gl_date);
3304: debug(' p_desired = ' || p_desired_account);
3305: debug(' p_subject_tab= ' || p_subject_table);

Line 3564: debug('arp_etax_util.calc_applied_and_remaining()+');

3560: l_gt_id NUMBER;
3561: BEGIN
3562: IF PG_DEBUG in ('Y', 'C')
3563: THEN
3564: debug('arp_etax_util.calc_applied_and_remaining()+');
3565: debug(' p_amt = ' || p_amt);
3566: debug(' p_receipt_id = ' || p_receipt_id);
3567: debug(' p_apply_date = ' || p_apply_date);
3568: debug(' p_trx_id = ' || p_trx_id);

Line 3689: debug('arp_etax_util.calc_applied_and_remaining()-');

3685: END IF;
3686:
3687: IF PG_DEBUG in ('Y', 'C')
3688: THEN
3689: debug('arp_etax_util.calc_applied_and_remaining()-');
3690: END IF;
3691: END calc_applied_and_remaining;
3692:
3693: /* PUBLIC FUNCTION get_discount_rate

Line 3768: debug('arp_etax_util.validate_for_tax()+');

3764: */
3765: BEGIN
3766: IF PG_DEBUG in ('Y', 'C')
3767: THEN
3768: debug('arp_etax_util.validate_for_tax()+');
3769: END IF;
3770:
3771:
3772: DELETE from ZX_TRX_HEADERS_GT zx

Line 3823: debug('arp_etax_util.validate_for_tax()-');

3819: END IF;
3820:
3821: IF PG_DEBUG in ('Y', 'C')
3822: THEN
3823: debug('arp_etax_util.validate_for_tax()-');
3824: END IF;
3825:
3826: END validate_for_tax;
3827:

Line 3847: END ARP_ETAX_UTIL;

3843: *=======================================================================*/
3844:
3845: BEGIN
3846: NULL;
3847: END ARP_ETAX_UTIL;