DBA Data[Home] [Help]

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;