APPS.ARP_ETAX_SERVICES_PKG dependencies on ARP_UTIL

Line 103: arp_util.debug(' pg_use_inv_acctg = ' || pg_use_inv_acctg);

99: THEN
100: pg_use_inv_acctg := 'N';
101: END IF;
102:
103: arp_util.debug(' pg_use_inv_acctg = ' || pg_use_inv_acctg);
104: END IF;
105:
106: IF pg_use_inv_acctg = 'Y'
107: THEN

Line 123: arp_util.debug('arp_etax_services_pkg.copy_inv_tax_dists()+');

119: l_rows NUMBER := 0;
120: BEGIN
121: IF PG_DEBUG in ('Y','C')
122: THEN
123: arp_util.debug('arp_etax_services_pkg.copy_inv_tax_dists()+');
124: END IF;
125:
126: /* Get base precision and minimum accountable unit */
127: base_min_acc_unit := arp_trx_global.system_info.base_min_acc_unit;

Line 294: arp_util.debug(' tax dists inserted = ' || l_rows);

290: l_rows := SQL%ROWCOUNT;
291:
292: IF PG_DEBUG in ('Y','C')
293: THEN
294: arp_util.debug(' tax dists inserted = ' || l_rows);
295: arp_util.debug('arp_etax_services_pkg.copy_inv_tax_dists()-');
296: END IF;
297: END copy_inv_tax_dists;
298:

Line 295: arp_util.debug('arp_etax_services_pkg.copy_inv_tax_dists()-');

291:
292: IF PG_DEBUG in ('Y','C')
293: THEN
294: arp_util.debug(' tax dists inserted = ' || l_rows);
295: arp_util.debug('arp_etax_services_pkg.copy_inv_tax_dists()-');
296: END IF;
297: END copy_inv_tax_dists;
298:
299: /* Records tax accounting prior to deletion in global plsql tables.

Line 543: arp_util.debug('ARP_ETAX_SERVICES_PKG.Calculate(+)');

539: l_event_type_code VARCHAR2(80);
540: l_success BOOLEAN;
541: l_rows NUMBER;
542: BEGIN
543: arp_util.debug('ARP_ETAX_SERVICES_PKG.Calculate(+)');
544: /* get event class code */
545: l_success := arp_etax_util.get_event_information(
546: p_customer_trx_id => p_customer_trx_id,
547: p_action => p_action,

Line 551: arp_util.debug('customer trx id = ' || p_customer_trx_id);

547: p_action => p_action,
548: p_event_class_code => l_event_class_code,
549: p_event_type_code => l_event_type_code);
550:
551: arp_util.debug('customer trx id = ' || p_customer_trx_id);
552: arp_util.debug('action = ' || p_action);
553: arp_util.debug('event class code = ' || l_event_class_code);
554: arp_util.debug('event type code = ' || l_event_type_code);
555:

Line 552: arp_util.debug('action = ' || p_action);

548: p_event_class_code => l_event_class_code,
549: p_event_type_code => l_event_type_code);
550:
551: arp_util.debug('customer trx id = ' || p_customer_trx_id);
552: arp_util.debug('action = ' || p_action);
553: arp_util.debug('event class code = ' || l_event_class_code);
554: arp_util.debug('event type code = ' || l_event_type_code);
555:
556: IF (l_success) THEN

Line 553: arp_util.debug('event class code = ' || l_event_class_code);

549: p_event_type_code => l_event_type_code);
550:
551: arp_util.debug('customer trx id = ' || p_customer_trx_id);
552: arp_util.debug('action = ' || p_action);
553: arp_util.debug('event class code = ' || l_event_class_code);
554: arp_util.debug('event type code = ' || l_event_type_code);
555:
556: IF (l_success) THEN
557: /* populate transaction rec type */

Line 554: arp_util.debug('event type code = ' || l_event_type_code);

550:
551: arp_util.debug('customer trx id = ' || p_customer_trx_id);
552: arp_util.debug('action = ' || p_action);
553: arp_util.debug('event class code = ' || l_event_class_code);
554: arp_util.debug('event type code = ' || l_event_type_code);
555:
556: IF (l_success) THEN
557: /* populate transaction rec type */
558: l_transaction_rec.internal_organization_id := arp_global.sysparam.org_id;

Line 570: arp_util.debug('calling populate_ebt_plsql_tables ');

566: ZX_GLOBAL_STRUCTURES_PKG.INIT_TRX_LINE_DIST_TBL(1); */
567:
568: /* insert data into ebt plsql tables
569:
570: arp_util.debug('calling populate_ebt_plsql_tables ');
571: populate_ebt_plsql_tables(
572: p_customer_trx_id => p_customer_trx_id,
573: p_customer_trx_line_id => p_cust_trx_line_id,
574: p_event_type_code => l_event_type_code,

Line 583: arp_util.debug('calling ZX api to calculate tax');

579: /* 5152340 - Remove AR tax lines before calculating tax */
580: arp_etax_util.delete_Tax_lines_from_ar(p_customer_trx_id);
581:
582: /* call Tax */
583: arp_util.debug('calling ZX api to calculate tax');
584: arp_util.debug('ORG ID = ' || l_transaction_rec.internal_organization_id);
585:
586: zx_api_pub.calculate_tax(
587: p_api_version => 1.0,

Line 584: arp_util.debug('ORG ID = ' || l_transaction_rec.internal_organization_id);

580: arp_etax_util.delete_Tax_lines_from_ar(p_customer_trx_id);
581:
582: /* call Tax */
583: arp_util.debug('calling ZX api to calculate tax');
584: arp_util.debug('ORG ID = ' || l_transaction_rec.internal_organization_id);
585:
586: zx_api_pub.calculate_tax(
587: p_api_version => 1.0,
588: p_init_msg_list => FND_API.G_TRUE,

Line 599: arp_util.debug('return status service = ' || l_return_status_service);

595: x_msg_count => l_msg_count,
596: x_msg_data => l_msg_data,
597: x_doc_level_recalc_flag => l_doc_level_recalc_flag );
598:
599: arp_util.debug('return status service = ' || l_return_status_service);
600:
601: IF (l_return_status_service = 'S') THEN
602: -- insert Tax records into ra_customer_trx_lines based upon
603: -- customer trx line id

Line 604: arp_util.debug('calling build_ar_tax_lines ...');

600:
601: IF (l_return_status_service = 'S') THEN
602: -- insert Tax records into ra_customer_trx_lines based upon
603: -- customer trx line id
604: arp_util.debug('calling build_ar_tax_lines ...');
605: arp_util.debug('customer trx id = ' || p_customer_trx_id);
606:
607: arp_etax_util.build_ar_tax_lines(
608: p_customer_trx_id => p_customer_trx_id,

Line 605: arp_util.debug('customer trx id = ' || p_customer_trx_id);

601: IF (l_return_status_service = 'S') THEN
602: -- insert Tax records into ra_customer_trx_lines based upon
603: -- customer trx line id
604: arp_util.debug('calling build_ar_tax_lines ...');
605: arp_util.debug('customer trx id = ' || p_customer_trx_id);
606:
607: arp_etax_util.build_ar_tax_lines(
608: p_customer_trx_id => p_customer_trx_id,
609: p_rows_inserted => l_rows);

Line 612: arp_util.debug('Calculate returned error');

608: p_customer_trx_id => p_customer_trx_id,
609: p_rows_inserted => l_rows);
610:
611: ELSE
612: arp_util.debug('Calculate returned error');
613: IF ( l_msg_count = 1 ) THEN
614: -- then there is only 1 message raised by the API, and
615: -- it has been sent out in the parameter x_msg_data.
616: l_msg_data_out := l_msg_data;

Line 617: arp_util.debug('API failed with : ' || l_msg_data_out);

613: IF ( l_msg_count = 1 ) THEN
614: -- then there is only 1 message raised by the API, and
615: -- it has been sent out in the parameter x_msg_data.
616: l_msg_data_out := l_msg_data;
617: arp_util.debug('API failed with : ' || l_msg_data_out);
618: l_mesg := l_msg_data_out;
619:
620: ELSIF (l_msg_count > 1) THEN
621: -- the messages are on the stack and there is more then

Line 629: arp_util.debug('API failed with : ' || l_mesg);

625: FND_API.G_FALSE);
626: if (l_mesg IS NULL) THEN
627: EXIT;
628: end if;
629: arp_util.debug('API failed with : ' || l_mesg);
630: end loop;
631: END IF;
632:
633: -- raise error

Line 689: arp_util.debug('populate_ebt_plsql_tables(+)');

685: l_cmline_line_amount NUMBER;
686: l_cmline_tax_amount NUMBER;
687: BEGIN
688: IF PG_DEBUG in ('Y','C') THEN
689: arp_util.debug('populate_ebt_plsql_tables(+)');
690: END IF;
691:
692: /* Set pg_so_org_id any time it is not set or
693: any time the OU changes. This supports cases where

Line 1058: arp_util.debug('Fetching values of primary_salesrep_id, memo_line_id, inventory_item_id and cust_trx_type_id to use it for calculating CCID of REV account.');

1054: -- 6874006 - merged memo line/product category into main insert
1055: --Bug6126010 begin, removed the existing query to find revenue CCID and added new query to retrieve CCID for REV account and passing it for tax calculation.
1056:
1057: IF PG_DEBUG in ('Y','C') THEN
1058: arp_util.debug('Fetching values of primary_salesrep_id, memo_line_id, inventory_item_id and cust_trx_type_id to use it for calculating CCID of REV account.');
1059: END IF;
1060:
1061: SELECT ctl.inventory_item_id, ctl.memo_line_id,
1062: ctx.cust_trx_type_id, ctx.primary_salesrep_id

Line 1070: arp_util.debug('Calling ARP_Auto_Accounting');

1066: AND ctl.customer_trx_line_id = p_customer_trx_line_id
1067: AND ctl.customer_trx_id=ctx.customer_trx_id;
1068:
1069: IF PG_DEBUG in ('Y','C') THEN
1070: arp_util.debug('Calling ARP_Auto_Accounting');
1071: arp_util.debug('customer_trx_id : '||p_customer_trx_id);
1072: arp_util.debug('customer_trx__line_id : '||p_customer_trx_line_id);
1073: arp_util.debug('trx_type_id : '||p_trx_type_id);
1074: arp_util.debug('primary_salesrep_id : '||p_salesrep_id);

Line 1071: arp_util.debug('customer_trx_id : '||p_customer_trx_id);

1067: AND ctl.customer_trx_id=ctx.customer_trx_id;
1068:
1069: IF PG_DEBUG in ('Y','C') THEN
1070: arp_util.debug('Calling ARP_Auto_Accounting');
1071: arp_util.debug('customer_trx_id : '||p_customer_trx_id);
1072: arp_util.debug('customer_trx__line_id : '||p_customer_trx_line_id);
1073: arp_util.debug('trx_type_id : '||p_trx_type_id);
1074: arp_util.debug('primary_salesrep_id : '||p_salesrep_id);
1075: arp_util.debug('inventory_item_id : '||p_inv_item_id);

Line 1072: arp_util.debug('customer_trx__line_id : '||p_customer_trx_line_id);

1068:
1069: IF PG_DEBUG in ('Y','C') THEN
1070: arp_util.debug('Calling ARP_Auto_Accounting');
1071: arp_util.debug('customer_trx_id : '||p_customer_trx_id);
1072: arp_util.debug('customer_trx__line_id : '||p_customer_trx_line_id);
1073: arp_util.debug('trx_type_id : '||p_trx_type_id);
1074: arp_util.debug('primary_salesrep_id : '||p_salesrep_id);
1075: arp_util.debug('inventory_item_id : '||p_inv_item_id);
1076: arp_util.debug('Memo_line_id : '||p_memo_line_id);

Line 1073: arp_util.debug('trx_type_id : '||p_trx_type_id);

1069: IF PG_DEBUG in ('Y','C') THEN
1070: arp_util.debug('Calling ARP_Auto_Accounting');
1071: arp_util.debug('customer_trx_id : '||p_customer_trx_id);
1072: arp_util.debug('customer_trx__line_id : '||p_customer_trx_line_id);
1073: arp_util.debug('trx_type_id : '||p_trx_type_id);
1074: arp_util.debug('primary_salesrep_id : '||p_salesrep_id);
1075: arp_util.debug('inventory_item_id : '||p_inv_item_id);
1076: arp_util.debug('Memo_line_id : '||p_memo_line_id);
1077: END IF;

Line 1074: arp_util.debug('primary_salesrep_id : '||p_salesrep_id);

1070: arp_util.debug('Calling ARP_Auto_Accounting');
1071: arp_util.debug('customer_trx_id : '||p_customer_trx_id);
1072: arp_util.debug('customer_trx__line_id : '||p_customer_trx_line_id);
1073: arp_util.debug('trx_type_id : '||p_trx_type_id);
1074: arp_util.debug('primary_salesrep_id : '||p_salesrep_id);
1075: arp_util.debug('inventory_item_id : '||p_inv_item_id);
1076: arp_util.debug('Memo_line_id : '||p_memo_line_id);
1077: END IF;
1078:

Line 1075: arp_util.debug('inventory_item_id : '||p_inv_item_id);

1071: arp_util.debug('customer_trx_id : '||p_customer_trx_id);
1072: arp_util.debug('customer_trx__line_id : '||p_customer_trx_line_id);
1073: arp_util.debug('trx_type_id : '||p_trx_type_id);
1074: arp_util.debug('primary_salesrep_id : '||p_salesrep_id);
1075: arp_util.debug('inventory_item_id : '||p_inv_item_id);
1076: arp_util.debug('Memo_line_id : '||p_memo_line_id);
1077: END IF;
1078:
1079: ARP_Auto_Accounting.do_autoaccounting(

Line 1076: arp_util.debug('Memo_line_id : '||p_memo_line_id);

1072: arp_util.debug('customer_trx__line_id : '||p_customer_trx_line_id);
1073: arp_util.debug('trx_type_id : '||p_trx_type_id);
1074: arp_util.debug('primary_salesrep_id : '||p_salesrep_id);
1075: arp_util.debug('inventory_item_id : '||p_inv_item_id);
1076: arp_util.debug('Memo_line_id : '||p_memo_line_id);
1077: END IF;
1078:
1079: ARP_Auto_Accounting.do_autoaccounting(
1080: p_mode => 'G',

Line 1102: arp_util.debug('Failure Count ' || p_num_fail);

1098: p_failure_count => p_num_fail);
1099: /* Bug 8758638 */
1100: IF NVL(p_ccid,-1) = -1 THEN
1101: IF PG_DEBUG in ('Y','C') THEN
1102: arp_util.debug('Failure Count ' || p_num_fail);
1103: arp_util.debug('EXCEPTION: ARP_Auto_Accounting returned 0'||
1104: ' and no ccid is being passed for Tax Calculation.');
1105: END IF;
1106: p_ccid := NULL;

Line 1103: arp_util.debug('EXCEPTION: ARP_Auto_Accounting returned 0'||

1099: /* Bug 8758638 */
1100: IF NVL(p_ccid,-1) = -1 THEN
1101: IF PG_DEBUG in ('Y','C') THEN
1102: arp_util.debug('Failure Count ' || p_num_fail);
1103: arp_util.debug('EXCEPTION: ARP_Auto_Accounting returned 0'||
1104: ' and no ccid is being passed for Tax Calculation.');
1105: END IF;
1106: p_ccid := NULL;
1107:

Line 1110: arp_util.debug('REV CCID passed for tax calculation :'|| p_ccid);

1106: p_ccid := NULL;
1107:
1108: ELSE
1109: IF PG_DEBUG in ('Y','C') THEN
1110: arp_util.debug('REV CCID passed for tax calculation :'|| p_ccid);
1111: END IF;
1112:
1113: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ACCOUNT_CCID(1):= p_ccid;
1114: END IF;

Line 1128: arp_util.debug('Fetching poo values for salesrep');

1124: THEN
1125: pg_salesrep_id := p_salesrep_id;
1126:
1127: IF PG_DEBUG in ('Y','C') THEN
1128: arp_util.debug('Fetching poo values for salesrep');
1129: arp_util.debug(' salesrep_id = ' || pg_salesrep_id);
1130: arp_util.debug(' org_id = ' || pg_org_id);
1131: END IF;
1132:

Line 1129: arp_util.debug(' salesrep_id = ' || pg_salesrep_id);

1125: pg_salesrep_id := p_salesrep_id;
1126:
1127: IF PG_DEBUG in ('Y','C') THEN
1128: arp_util.debug('Fetching poo values for salesrep');
1129: arp_util.debug(' salesrep_id = ' || pg_salesrep_id);
1130: arp_util.debug(' org_id = ' || pg_org_id);
1131: END IF;
1132:
1133: BEGIN

Line 1130: arp_util.debug(' org_id = ' || pg_org_id);

1126:
1127: IF PG_DEBUG in ('Y','C') THEN
1128: arp_util.debug('Fetching poo values for salesrep');
1129: arp_util.debug(' salesrep_id = ' || pg_salesrep_id);
1130: arp_util.debug(' org_id = ' || pg_org_id);
1131: END IF;
1132:
1133: BEGIN
1134: select SR_PER.organization_id, -- poo_party_id

Line 1161: arp_util.debug('poo_party_id := ' || pg_poo_party_id);

1157: pg_poo_location_id := NULL;
1158: END IF;
1159:
1160: IF PG_DEBUG in ('Y','C') THEN
1161: arp_util.debug('poo_party_id := ' || pg_poo_party_id);
1162: arp_util.debug('poo_location_id = ' || pg_poo_location_id);
1163: END IF;
1164:
1165: /* Now copy POO values from cache or POA */

Line 1162: arp_util.debug('poo_location_id = ' || pg_poo_location_id);

1158: END IF;
1159:
1160: IF PG_DEBUG in ('Y','C') THEN
1161: arp_util.debug('poo_party_id := ' || pg_poo_party_id);
1162: arp_util.debug('poo_location_id = ' || pg_poo_location_id);
1163: END IF;
1164:
1165: /* Now copy POO values from cache or POA */
1166: IF pg_poo_party_id IS NOT NULL

Line 1288: arp_util.debug('setting credit memo tax limit');

1284: AND cml.line_type = 'LINE'
1285: AND cm.previous_customer_trx_id = invp.customer_trx_id;
1286:
1287: IF PG_DEBUG in ('Y','C') THEN
1288: arp_util.debug('setting credit memo tax limit');
1289: arp_util.debug(' allow_overapp : ' || l_allow_overapp);
1290: arp_util.debug(' invoice line_remaining: ' || l_inv_line_remaining);
1291: arp_util.debug(' cm line total : ' || l_cm_line_total);
1292: arp_util.debug(' invoice tax remaining : ' || l_inv_tax_remaining);

Line 1289: arp_util.debug(' allow_overapp : ' || l_allow_overapp);

1285: AND cm.previous_customer_trx_id = invp.customer_trx_id;
1286:
1287: IF PG_DEBUG in ('Y','C') THEN
1288: arp_util.debug('setting credit memo tax limit');
1289: arp_util.debug(' allow_overapp : ' || l_allow_overapp);
1290: arp_util.debug(' invoice line_remaining: ' || l_inv_line_remaining);
1291: arp_util.debug(' cm line total : ' || l_cm_line_total);
1292: arp_util.debug(' invoice tax remaining : ' || l_inv_tax_remaining);
1293: END IF;

Line 1290: arp_util.debug(' invoice line_remaining: ' || l_inv_line_remaining);

1286:
1287: IF PG_DEBUG in ('Y','C') THEN
1288: arp_util.debug('setting credit memo tax limit');
1289: arp_util.debug(' allow_overapp : ' || l_allow_overapp);
1290: arp_util.debug(' invoice line_remaining: ' || l_inv_line_remaining);
1291: arp_util.debug(' cm line total : ' || l_cm_line_total);
1292: arp_util.debug(' invoice tax remaining : ' || l_inv_tax_remaining);
1293: END IF;
1294:

Line 1291: arp_util.debug(' cm line total : ' || l_cm_line_total);

1287: IF PG_DEBUG in ('Y','C') THEN
1288: arp_util.debug('setting credit memo tax limit');
1289: arp_util.debug(' allow_overapp : ' || l_allow_overapp);
1290: arp_util.debug(' invoice line_remaining: ' || l_inv_line_remaining);
1291: arp_util.debug(' cm line total : ' || l_cm_line_total);
1292: arp_util.debug(' invoice tax remaining : ' || l_inv_tax_remaining);
1293: END IF;
1294:
1295: IF l_cm_line_total * -1 = l_inv_line_remaining

Line 1292: arp_util.debug(' invoice tax remaining : ' || l_inv_tax_remaining);

1288: arp_util.debug('setting credit memo tax limit');
1289: arp_util.debug(' allow_overapp : ' || l_allow_overapp);
1290: arp_util.debug(' invoice line_remaining: ' || l_inv_line_remaining);
1291: arp_util.debug(' cm line total : ' || l_cm_line_total);
1292: arp_util.debug(' invoice tax remaining : ' || l_inv_tax_remaining);
1293: END IF;
1294:
1295: IF l_cm_line_total * -1 = l_inv_line_remaining
1296: THEN

Line 1320: arp_util.debug('setting credit memo tax limit for over application');

1316: AND cm_line.cm_customer_trx_id is null
1317: AND cm.previous_customer_trx_id = inv_pay.customer_trx_id;
1318:
1319: IF PG_DEBUG in ('Y','C') THEN
1320: arp_util.debug('setting credit memo tax limit for over application');
1321: arp_util.debug(' l_inv_line_remaining : ' || l_inv_line_remaining);
1322: arp_util.debug(' l_inv_tax_remaining : ' || l_inv_tax_remaining);
1323: arp_util.debug(' l_cmline_line_amount : ' || l_cmline_line_amount);
1324: arp_util.debug(' l_cmline_tax_amount : ' || l_cmline_tax_amount);

Line 1321: arp_util.debug(' l_inv_line_remaining : ' || l_inv_line_remaining);

1317: AND cm.previous_customer_trx_id = inv_pay.customer_trx_id;
1318:
1319: IF PG_DEBUG in ('Y','C') THEN
1320: arp_util.debug('setting credit memo tax limit for over application');
1321: arp_util.debug(' l_inv_line_remaining : ' || l_inv_line_remaining);
1322: arp_util.debug(' l_inv_tax_remaining : ' || l_inv_tax_remaining);
1323: arp_util.debug(' l_cmline_line_amount : ' || l_cmline_line_amount);
1324: arp_util.debug(' l_cmline_tax_amount : ' || l_cmline_tax_amount);
1325: END IF;

Line 1322: arp_util.debug(' l_inv_tax_remaining : ' || l_inv_tax_remaining);

1318:
1319: IF PG_DEBUG in ('Y','C') THEN
1320: arp_util.debug('setting credit memo tax limit for over application');
1321: arp_util.debug(' l_inv_line_remaining : ' || l_inv_line_remaining);
1322: arp_util.debug(' l_inv_tax_remaining : ' || l_inv_tax_remaining);
1323: arp_util.debug(' l_cmline_line_amount : ' || l_cmline_line_amount);
1324: arp_util.debug(' l_cmline_tax_amount : ' || l_cmline_tax_amount);
1325: END IF;
1326:

Line 1323: arp_util.debug(' l_cmline_line_amount : ' || l_cmline_line_amount);

1319: IF PG_DEBUG in ('Y','C') THEN
1320: arp_util.debug('setting credit memo tax limit for over application');
1321: arp_util.debug(' l_inv_line_remaining : ' || l_inv_line_remaining);
1322: arp_util.debug(' l_inv_tax_remaining : ' || l_inv_tax_remaining);
1323: arp_util.debug(' l_cmline_line_amount : ' || l_cmline_line_amount);
1324: arp_util.debug(' l_cmline_tax_amount : ' || l_cmline_tax_amount);
1325: END IF;
1326:
1327: IF (l_inv_line_remaining > 0) THEN

Line 1324: arp_util.debug(' l_cmline_tax_amount : ' || l_cmline_tax_amount);

1320: arp_util.debug('setting credit memo tax limit for over application');
1321: arp_util.debug(' l_inv_line_remaining : ' || l_inv_line_remaining);
1322: arp_util.debug(' l_inv_tax_remaining : ' || l_inv_tax_remaining);
1323: arp_util.debug(' l_cmline_line_amount : ' || l_cmline_line_amount);
1324: arp_util.debug(' l_cmline_tax_amount : ' || l_cmline_tax_amount);
1325: END IF;
1326:
1327: IF (l_inv_line_remaining > 0) THEN
1328: l_inv_line_remaining := l_inv_line_remaining * -1;

Line 1361: arp_util.debug('provides a tax amount that also closes the tax bucket');

1357: AND cml.line_type = 'LINE'
1358: AND cm.previous_customer_trx_id = invp.customer_trx_id;
1359: --
1360: IF PG_DEBUG in ('Y','C') THEN
1361: arp_util.debug('provides a tax amount that also closes the tax bucket');
1362: arp_util.debug(' invoice line_remaining: ' || l_inv_line_remaining);
1363: arp_util.debug(' cm line total : ' || l_cm_line_total);
1364: arp_util.debug(' invoice tax remaining : ' || l_inv_tax_remaining);
1365: END IF;

Line 1362: arp_util.debug(' invoice line_remaining: ' || l_inv_line_remaining);

1358: AND cm.previous_customer_trx_id = invp.customer_trx_id;
1359: --
1360: IF PG_DEBUG in ('Y','C') THEN
1361: arp_util.debug('provides a tax amount that also closes the tax bucket');
1362: arp_util.debug(' invoice line_remaining: ' || l_inv_line_remaining);
1363: arp_util.debug(' cm line total : ' || l_cm_line_total);
1364: arp_util.debug(' invoice tax remaining : ' || l_inv_tax_remaining);
1365: END IF;
1366:

Line 1363: arp_util.debug(' cm line total : ' || l_cm_line_total);

1359: --
1360: IF PG_DEBUG in ('Y','C') THEN
1361: arp_util.debug('provides a tax amount that also closes the tax bucket');
1362: arp_util.debug(' invoice line_remaining: ' || l_inv_line_remaining);
1363: arp_util.debug(' cm line total : ' || l_cm_line_total);
1364: arp_util.debug(' invoice tax remaining : ' || l_inv_tax_remaining);
1365: END IF;
1366:
1367: IF l_cm_line_total * -1 = l_inv_line_remaining

Line 1364: arp_util.debug(' invoice tax remaining : ' || l_inv_tax_remaining);

1360: IF PG_DEBUG in ('Y','C') THEN
1361: arp_util.debug('provides a tax amount that also closes the tax bucket');
1362: arp_util.debug(' invoice line_remaining: ' || l_inv_line_remaining);
1363: arp_util.debug(' cm line total : ' || l_cm_line_total);
1364: arp_util.debug(' invoice tax remaining : ' || l_inv_tax_remaining);
1365: END IF;
1366:
1367: IF l_cm_line_total * -1 = l_inv_line_remaining
1368: THEN

Line 1377: arp_util_tax.debug( 'EXCEPTION: arp_etax_services_pkg.setting credit memo tax limit for over application');

1373: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CTRL_TOTAL_HDR_TX_AMT(1) := NULL;
1374: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(1) := 'N';
1375: END IF;
1376: WHEN OTHERS THEN
1377: arp_util_tax.debug( 'EXCEPTION: arp_etax_services_pkg.setting credit memo tax limit for over application');
1378: RAISE;
1379: END;
1380: END IF; -- l_allow_overapp = 'Y
1381: ELSE

Line 1397: arp_util.debug('populate_ebt_plsql_tables(-)');

1393: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CTRL_TOTAL_LINE_TX_AMT(1) := p_tax_amount;
1394:
1395: IF PG_DEBUG in ('Y','C') THEN
1396: arp_etax_services_pkg.print_ebt_plsql_vars;
1397: arp_util.debug('populate_ebt_plsql_tables(-)');
1398: END IF;
1399: END populate_ebt_plsql_tables;
1400:
1401: /*=============================================================================

Line 1455: arp_util.debug('ARP_ETAX_SERVICES_PKG.set_line_flags()+');

1451: l_warehouse_flag_changed BOOLEAN;
1452: l_ship_to_changed BOOLEAN;
1453:
1454: BEGIN
1455: arp_util.debug('ARP_ETAX_SERVICES_PKG.set_line_flags()+');
1456: arp_util.debug('p_cust_trx_line_id = ' || to_char(p_customer_trx_line_id));
1457:
1458: /*-----------------------------------------+
1459: | Fetch the old record from the database |

Line 1456: arp_util.debug('p_cust_trx_line_id = ' || to_char(p_customer_trx_line_id));

1452: l_ship_to_changed BOOLEAN;
1453:
1454: BEGIN
1455: arp_util.debug('ARP_ETAX_SERVICES_PKG.set_line_flags()+');
1456: arp_util.debug('p_cust_trx_line_id = ' || to_char(p_customer_trx_line_id));
1457:
1458: /*-----------------------------------------+
1459: | Fetch the old record from the database |
1460: +-----------------------------------------*/

Line 1583: arp_util_tax.debug('p_inventory_item_changed : '||

1579:
1580: -- do we need to check for GDF changes???
1581:
1582: -- IF PG_DEBUG = 'Y' THEN
1583: arp_util_tax.debug('p_inventory_item_changed : '||
1584: arp_trx_util.boolean_to_varchar2(l_inventory_item_changed));
1585: arp_util_tax.debug('p_memo_line_changed : '||
1586: arp_trx_util.boolean_to_varchar2(l_memo_line_changed));
1587: arp_util_tax.debug('p_quantity_changed : '||

Line 1585: arp_util_tax.debug('p_memo_line_changed : '||

1581:
1582: -- IF PG_DEBUG = 'Y' THEN
1583: arp_util_tax.debug('p_inventory_item_changed : '||
1584: arp_trx_util.boolean_to_varchar2(l_inventory_item_changed));
1585: arp_util_tax.debug('p_memo_line_changed : '||
1586: arp_trx_util.boolean_to_varchar2(l_memo_line_changed));
1587: arp_util_tax.debug('p_quantity_changed : '||
1588: arp_trx_util.boolean_to_varchar2(l_quantity_changed));
1589: arp_util_tax.debug('p_extended_amount_changed : ' ||

Line 1587: arp_util_tax.debug('p_quantity_changed : '||

1583: arp_util_tax.debug('p_inventory_item_changed : '||
1584: arp_trx_util.boolean_to_varchar2(l_inventory_item_changed));
1585: arp_util_tax.debug('p_memo_line_changed : '||
1586: arp_trx_util.boolean_to_varchar2(l_memo_line_changed));
1587: arp_util_tax.debug('p_quantity_changed : '||
1588: arp_trx_util.boolean_to_varchar2(l_quantity_changed));
1589: arp_util_tax.debug('p_extended_amount_changed : ' ||
1590: arp_trx_util.boolean_to_varchar2(l_extended_amount_changed )); arp_util_tax.debug('p_tax_exempt_flag_changed : ' ||
1591: arp_trx_util.boolean_to_varchar2(l_tax_exempt_flag_changed )); arp_util_tax.debug('p_tax_exempt_reason_changed : ' ||

Line 1589: arp_util_tax.debug('p_extended_amount_changed : ' ||

1585: arp_util_tax.debug('p_memo_line_changed : '||
1586: arp_trx_util.boolean_to_varchar2(l_memo_line_changed));
1587: arp_util_tax.debug('p_quantity_changed : '||
1588: arp_trx_util.boolean_to_varchar2(l_quantity_changed));
1589: arp_util_tax.debug('p_extended_amount_changed : ' ||
1590: arp_trx_util.boolean_to_varchar2(l_extended_amount_changed )); arp_util_tax.debug('p_tax_exempt_flag_changed : ' ||
1591: arp_trx_util.boolean_to_varchar2(l_tax_exempt_flag_changed )); arp_util_tax.debug('p_tax_exempt_reason_changed : ' ||
1592: arp_trx_util.boolean_to_varchar2(l_tax_exempt_reason_changed ));
1593: arp_util_tax.debug('p_tax_exempt_cert_changed : ' ||

Line 1590: arp_trx_util.boolean_to_varchar2(l_extended_amount_changed )); arp_util_tax.debug('p_tax_exempt_flag_changed : ' ||

1586: arp_trx_util.boolean_to_varchar2(l_memo_line_changed));
1587: arp_util_tax.debug('p_quantity_changed : '||
1588: arp_trx_util.boolean_to_varchar2(l_quantity_changed));
1589: arp_util_tax.debug('p_extended_amount_changed : ' ||
1590: arp_trx_util.boolean_to_varchar2(l_extended_amount_changed )); arp_util_tax.debug('p_tax_exempt_flag_changed : ' ||
1591: arp_trx_util.boolean_to_varchar2(l_tax_exempt_flag_changed )); arp_util_tax.debug('p_tax_exempt_reason_changed : ' ||
1592: arp_trx_util.boolean_to_varchar2(l_tax_exempt_reason_changed ));
1593: arp_util_tax.debug('p_tax_exempt_cert_changed : ' ||
1594: arp_trx_util.boolean_to_varchar2(l_tax_exempt_cert_changed )); arp_util_tax.debug('p_tax_code_changed : '||

Line 1591: arp_trx_util.boolean_to_varchar2(l_tax_exempt_flag_changed )); arp_util_tax.debug('p_tax_exempt_reason_changed : ' ||

1587: arp_util_tax.debug('p_quantity_changed : '||
1588: arp_trx_util.boolean_to_varchar2(l_quantity_changed));
1589: arp_util_tax.debug('p_extended_amount_changed : ' ||
1590: arp_trx_util.boolean_to_varchar2(l_extended_amount_changed )); arp_util_tax.debug('p_tax_exempt_flag_changed : ' ||
1591: arp_trx_util.boolean_to_varchar2(l_tax_exempt_flag_changed )); arp_util_tax.debug('p_tax_exempt_reason_changed : ' ||
1592: arp_trx_util.boolean_to_varchar2(l_tax_exempt_reason_changed ));
1593: arp_util_tax.debug('p_tax_exempt_cert_changed : ' ||
1594: arp_trx_util.boolean_to_varchar2(l_tax_exempt_cert_changed )); arp_util_tax.debug('p_tax_code_changed : '||
1595: arp_trx_util.boolean_to_varchar2(l_tax_code_changed));

Line 1593: arp_util_tax.debug('p_tax_exempt_cert_changed : ' ||

1589: arp_util_tax.debug('p_extended_amount_changed : ' ||
1590: arp_trx_util.boolean_to_varchar2(l_extended_amount_changed )); arp_util_tax.debug('p_tax_exempt_flag_changed : ' ||
1591: arp_trx_util.boolean_to_varchar2(l_tax_exempt_flag_changed )); arp_util_tax.debug('p_tax_exempt_reason_changed : ' ||
1592: arp_trx_util.boolean_to_varchar2(l_tax_exempt_reason_changed ));
1593: arp_util_tax.debug('p_tax_exempt_cert_changed : ' ||
1594: arp_trx_util.boolean_to_varchar2(l_tax_exempt_cert_changed )); arp_util_tax.debug('p_tax_code_changed : '||
1595: arp_trx_util.boolean_to_varchar2(l_tax_code_changed));
1596: arp_util_tax.debug('p_warehouse_flag_changed : '||
1597: arp_trx_util.boolean_to_varchar2(l_warehouse_flag_changed));

Line 1594: arp_trx_util.boolean_to_varchar2(l_tax_exempt_cert_changed )); arp_util_tax.debug('p_tax_code_changed : '||

1590: arp_trx_util.boolean_to_varchar2(l_extended_amount_changed )); arp_util_tax.debug('p_tax_exempt_flag_changed : ' ||
1591: arp_trx_util.boolean_to_varchar2(l_tax_exempt_flag_changed )); arp_util_tax.debug('p_tax_exempt_reason_changed : ' ||
1592: arp_trx_util.boolean_to_varchar2(l_tax_exempt_reason_changed ));
1593: arp_util_tax.debug('p_tax_exempt_cert_changed : ' ||
1594: arp_trx_util.boolean_to_varchar2(l_tax_exempt_cert_changed )); arp_util_tax.debug('p_tax_code_changed : '||
1595: arp_trx_util.boolean_to_varchar2(l_tax_code_changed));
1596: arp_util_tax.debug('p_warehouse_flag_changed : '||
1597: arp_trx_util.boolean_to_varchar2(l_warehouse_flag_changed));
1598: arp_util_tax.debug('p_ship_to_changed : '||

Line 1596: arp_util_tax.debug('p_warehouse_flag_changed : '||

1592: arp_trx_util.boolean_to_varchar2(l_tax_exempt_reason_changed ));
1593: arp_util_tax.debug('p_tax_exempt_cert_changed : ' ||
1594: arp_trx_util.boolean_to_varchar2(l_tax_exempt_cert_changed )); arp_util_tax.debug('p_tax_code_changed : '||
1595: arp_trx_util.boolean_to_varchar2(l_tax_code_changed));
1596: arp_util_tax.debug('p_warehouse_flag_changed : '||
1597: arp_trx_util.boolean_to_varchar2(l_warehouse_flag_changed));
1598: arp_util_tax.debug('p_ship_to_changed : '||
1599: arp_trx_util.boolean_to_varchar2(l_ship_to_changed));
1600: -- END IF;

Line 1598: arp_util_tax.debug('p_ship_to_changed : '||

1594: arp_trx_util.boolean_to_varchar2(l_tax_exempt_cert_changed )); arp_util_tax.debug('p_tax_code_changed : '||
1595: arp_trx_util.boolean_to_varchar2(l_tax_code_changed));
1596: arp_util_tax.debug('p_warehouse_flag_changed : '||
1597: arp_trx_util.boolean_to_varchar2(l_warehouse_flag_changed));
1598: arp_util_tax.debug('p_ship_to_changed : '||
1599: arp_trx_util.boolean_to_varchar2(l_ship_to_changed));
1600: -- END IF;
1601:
1602: p_inventory_item_changed := l_inventory_item_changed;

Line 1615: arp_util.debug('ARP_ETAX_SERVICES_PKG.set_line_flags()-');

1611: p_ship_to_changed := l_ship_to_changed;
1612:
1613: pg_extended_amount_changed := l_extended_amount_changed;
1614:
1615: arp_util.debug('ARP_ETAX_SERVICES_PKG.set_line_flags()-');
1616:
1617: END set_line_flags;
1618:
1619: /*===========================================================================+

Line 1653: arp_util.debug('ARP_ETAX_SERVICES_PKG.delete_tax_f_ctl_id()+');

1649: AND line_type = 'TAX';
1650:
1651: BEGIN
1652:
1653: arp_util.debug('ARP_ETAX_SERVICES_PKG.delete_tax_f_ctl_id()+');
1654:
1655: FOR tax in s_tax_lines_for_inv_line( p_customer_trx_line_id )
1656: LOOP
1657:

Line 1658: arp_util.debug('customer trx line id = ' || to_char(p_customer_Trx_line_id));

1654:
1655: FOR tax in s_tax_lines_for_inv_line( p_customer_trx_line_id )
1656: LOOP
1657:
1658: arp_util.debug('customer trx line id = ' || to_char(p_customer_Trx_line_id));
1659: arp_util.debug('assoc customer trx line id = ' ||
1660: to_char(tax.customer_Trx_line_id));
1661:
1662: /*********************************************************************

Line 1659: arp_util.debug('assoc customer trx line id = ' ||

1655: FOR tax in s_tax_lines_for_inv_line( p_customer_trx_line_id )
1656: LOOP
1657:
1658: arp_util.debug('customer trx line id = ' || to_char(p_customer_Trx_line_id));
1659: arp_util.debug('assoc customer trx line id = ' ||
1660: to_char(tax.customer_Trx_line_id));
1661:
1662: /*********************************************************************
1663: | Delete the account assignments and account sets associated with |

Line 1677: arp_util.debug('ARP_ETAX_SERVICES_PKG.delete_tax_f_ctl_id()-');

1673: arp_ctl_pkg.delete_p( tax.customer_trx_line_id );
1674:
1675:
1676: END LOOP;
1677: arp_util.debug('ARP_ETAX_SERVICES_PKG.delete_tax_f_ctl_id()-');
1678:
1679: EXCEPTION
1680: WHEN OTHERS
1681: THEN

Line 1683: arp_util_tax.debug( 'EXCEPTION: arp_etax_services_pkg.delete_tax_f_ctl_id()');

1679: EXCEPTION
1680: WHEN OTHERS
1681: THEN
1682: IF PG_DEBUG = 'Y' THEN
1683: arp_util_tax.debug( 'EXCEPTION: arp_etax_services_pkg.delete_tax_f_ctl_id()');
1684: END IF;
1685: RAISE;
1686:
1687: END delete_tax_f_ctl_id;

Line 1731: arp_util.debug('ARP_ETAX_SERVICES_PKG.before_update_line()+');

1727: l_ship_to_changed BOOLEAN;
1728: l_trx_id NUMBER;
1729:
1730: BEGIN
1731: arp_util.debug('ARP_ETAX_SERVICES_PKG.before_update_line()+');
1732: arp_util.debug('customer_trx_line_id = ' || to_char(p_customer_trx_line_id));
1733:
1734: arp_etax_services_pkg.set_line_flags(
1735: p_customer_trx_line_id,

Line 1732: arp_util.debug('customer_trx_line_id = ' || to_char(p_customer_trx_line_id));

1728: l_trx_id NUMBER;
1729:
1730: BEGIN
1731: arp_util.debug('ARP_ETAX_SERVICES_PKG.before_update_line()+');
1732: arp_util.debug('customer_trx_line_id = ' || to_char(p_customer_trx_line_id));
1733:
1734: arp_etax_services_pkg.set_line_flags(
1735: p_customer_trx_line_id,
1736: p_line_rec,

Line 1766: arp_util.debug('ARP_ETAX_SERVICES_PKG.before_update_line()-');

1762: END IF;
1763:
1764: p_recalc_tax := pg_line_changed;
1765:
1766: arp_util.debug('ARP_ETAX_SERVICES_PKG.before_update_line()-');
1767:
1768: END before_update_line;
1769:
1770: /*=============================================================================

Line 1814: arp_util.debug('ARP_ETAX_SERVICES_PKG.Mark_Tax_Lines_Deleted()+');

1810: l_return_status BOOLEAN := TRUE;
1811: l_success BOOLEAN;
1812: BEGIN
1813:
1814: arp_util.debug('ARP_ETAX_SERVICES_PKG.Mark_Tax_Lines_Deleted()+');
1815:
1816: -- populate the trx header local record.
1817: BEGIN
1818: OPEN Trx_Header;

Line 1830: arp_util.debug('customer trx id = ' || p_customer_trx_id);

1826: p_action => 'UPDATE',
1827: p_event_class_code => l_event_class_code,
1828: p_event_type_code => l_event_type_code);
1829:
1830: arp_util.debug('customer trx id = ' || p_customer_trx_id);
1831: arp_util.debug('event class code = ' || l_event_class_code);
1832: arp_util.debug('event type code = ' || l_event_type_code);
1833:
1834: IF (l_success) THEN

Line 1831: arp_util.debug('event class code = ' || l_event_class_code);

1827: p_event_class_code => l_event_class_code,
1828: p_event_type_code => l_event_type_code);
1829:
1830: arp_util.debug('customer trx id = ' || p_customer_trx_id);
1831: arp_util.debug('event class code = ' || l_event_class_code);
1832: arp_util.debug('event type code = ' || l_event_type_code);
1833:
1834: IF (l_success) THEN
1835: -- populate the transaction_line_rec for use in the tax service

Line 1832: arp_util.debug('event type code = ' || l_event_type_code);

1828: p_event_type_code => l_event_type_code);
1829:
1830: arp_util.debug('customer trx id = ' || p_customer_trx_id);
1831: arp_util.debug('event class code = ' || l_event_class_code);
1832: arp_util.debug('event type code = ' || l_event_type_code);
1833:
1834: IF (l_success) THEN
1835: -- populate the transaction_line_rec for use in the tax service
1836: l_transaction_line_rec.internal_organization_id :=

Line 1865: arp_util.debug('ARP_ETAX_SERVICES_PKG.Mark_Tax_Lines_Deleted()-');

1861: ELSE
1862: RETURN FALSE;
1863: END IF;
1864:
1865: arp_util.debug('ARP_ETAX_SERVICES_PKG.Mark_Tax_Lines_Deleted()-');
1866: RETURN l_return_status;
1867:
1868: EXCEPTION
1869: WHEN OTHERS THEN

Line 1896: arp_util.debug('ARP_ETAX_SERVICES_PKG.before_delete_line()+');

1892: p_customer_trx_id IN Number) IS
1893: l_success BOOLEAN;
1894: BEGIN
1895:
1896: arp_util.debug('ARP_ETAX_SERVICES_PKG.before_delete_line()+');
1897:
1898: -- delete tax line from ra_customer_Trx_lines and associated accting.
1899:
1900: arp_etax_services_pkg.delete_tax_f_ctl_id(

Line 1908: arp_util.debug('unable to mark tax for deletion');

1904: p_customer_trx_line_id => p_customer_trx_line_id,
1905: p_customer_trx_id => p_customer_trx_id);
1906:
1907: IF (not l_success) THEN
1908: arp_util.debug('unable to mark tax for deletion');
1909: END IF;
1910:
1911: arp_util.debug('ARP_ETAX_SERVICES_PKG.before_delete_line()-');
1912:

Line 1911: arp_util.debug('ARP_ETAX_SERVICES_PKG.before_delete_line()-');

1907: IF (not l_success) THEN
1908: arp_util.debug('unable to mark tax for deletion');
1909: END IF;
1910:
1911: arp_util.debug('ARP_ETAX_SERVICES_PKG.before_delete_line()-');
1912:
1913: END Before_Delete_Line;
1914:
1915:

Line 1919: arp_util.debug(' internal_organization_id i:' ||

1915:
1916: PROCEDURE print_ebt_plsql_vars IS
1917: BEGIN
1918:
1919: arp_util.debug(' internal_organization_id i:' ||
1920: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(1) );
1921:
1922: arp_util.debug('application_id: ' ||
1923: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLICATION_ID(1) );

Line 1922: arp_util.debug('application_id: ' ||

1918:
1919: arp_util.debug(' internal_organization_id i:' ||
1920: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(1) );
1921:
1922: arp_util.debug('application_id: ' ||
1923: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLICATION_ID(1) );
1924:
1925: arp_util.debug('entity_code : ' ||
1926: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ENTITY_CODE(1));

Line 1925: arp_util.debug('entity_code : ' ||

1921:
1922: arp_util.debug('application_id: ' ||
1923: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLICATION_ID(1) );
1924:
1925: arp_util.debug('entity_code : ' ||
1926: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ENTITY_CODE(1));
1927:
1928: arp_util.debug('event_class_code : ' ||
1929: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EVENT_CLASS_CODE(1));

Line 1928: arp_util.debug('event_class_code : ' ||

1924:
1925: arp_util.debug('entity_code : ' ||
1926: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ENTITY_CODE(1));
1927:
1928: arp_util.debug('event_class_code : ' ||
1929: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EVENT_CLASS_CODE(1));
1930:
1931: arp_util.debug('event_type_code : ' ||
1932: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EVENT_TYPE_CODE(1) );

Line 1931: arp_util.debug('event_type_code : ' ||

1927:
1928: arp_util.debug('event_class_code : ' ||
1929: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EVENT_CLASS_CODE(1));
1930:
1931: arp_util.debug('event_type_code : ' ||
1932: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EVENT_TYPE_CODE(1) );
1933:
1934: arp_util.debug('trx_id : ' ||
1935: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID(1));

Line 1934: arp_util.debug('trx_id : ' ||

1930:
1931: arp_util.debug('event_type_code : ' ||
1932: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EVENT_TYPE_CODE(1) );
1933:
1934: arp_util.debug('trx_id : ' ||
1935: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID(1));
1936:
1937: arp_util.debug('trx_date : ' ||
1938: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DATE(1));

Line 1937: arp_util.debug('trx_date : ' ||

1933:
1934: arp_util.debug('trx_id : ' ||
1935: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID(1));
1936:
1937: arp_util.debug('trx_date : ' ||
1938: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DATE(1));
1939:
1940: arp_util.debug('ledger_id : ' ||
1941: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEDGER_ID(1));

Line 1940: arp_util.debug('ledger_id : ' ||

1936:
1937: arp_util.debug('trx_date : ' ||
1938: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DATE(1));
1939:
1940: arp_util.debug('ledger_id : ' ||
1941: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEDGER_ID(1));
1942:
1943: arp_util.debug('trx_currency_code : ' ||
1944: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_CURRENCY_CODE(1));

Line 1943: arp_util.debug('trx_currency_code : ' ||

1939:
1940: arp_util.debug('ledger_id : ' ||
1941: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEDGER_ID(1));
1942:
1943: arp_util.debug('trx_currency_code : ' ||
1944: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_CURRENCY_CODE(1));
1945:
1946: arp_util.debug('currency_conversion_date : ' ||
1947: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(1));

Line 1946: arp_util.debug('currency_conversion_date : ' ||

1942:
1943: arp_util.debug('trx_currency_code : ' ||
1944: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_CURRENCY_CODE(1));
1945:
1946: arp_util.debug('currency_conversion_date : ' ||
1947: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(1));
1948:
1949: arp_util.debug('currency_conversion_rate : ' ||
1950: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(1));

Line 1949: arp_util.debug('currency_conversion_rate : ' ||

1945:
1946: arp_util.debug('currency_conversion_date : ' ||
1947: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(1));
1948:
1949: arp_util.debug('currency_conversion_rate : ' ||
1950: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(1));
1951:
1952: arp_util.debug('currency_conversion_type : ' ||
1953: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(1));

Line 1952: arp_util.debug('currency_conversion_type : ' ||

1948:
1949: arp_util.debug('currency_conversion_rate : ' ||
1950: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(1));
1951:
1952: arp_util.debug('currency_conversion_type : ' ||
1953: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(1));
1954:
1955: arp_util.debug('minimum_accountable_unit : ' ||
1956: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT(1));

Line 1955: arp_util.debug('minimum_accountable_unit : ' ||

1951:
1952: arp_util.debug('currency_conversion_type : ' ||
1953: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(1));
1954:
1955: arp_util.debug('minimum_accountable_unit : ' ||
1956: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT(1));
1957:
1958: arp_util.debug('precision : ' ||
1959: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRECISION(1));

Line 1958: arp_util.debug('precision : ' ||

1954:
1955: arp_util.debug('minimum_accountable_unit : ' ||
1956: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT(1));
1957:
1958: arp_util.debug('precision : ' ||
1959: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRECISION(1));
1960:
1961: arp_util.debug('legal_entity_id : ' ||
1962: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEGAL_ENTITY_ID(1));

Line 1961: arp_util.debug('legal_entity_id : ' ||

1957:
1958: arp_util.debug('precision : ' ||
1959: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRECISION(1));
1960:
1961: arp_util.debug('legal_entity_id : ' ||
1962: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEGAL_ENTITY_ID(1));
1963:
1964: arp_util.debug('rounding_ship_to_party_id : ' ||
1965: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ROUNDING_SHIP_TO_PARTY_ID(1));

Line 1964: arp_util.debug('rounding_ship_to_party_id : ' ||

1960:
1961: arp_util.debug('legal_entity_id : ' ||
1962: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEGAL_ENTITY_ID(1));
1963:
1964: arp_util.debug('rounding_ship_to_party_id : ' ||
1965: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ROUNDING_SHIP_TO_PARTY_ID(1));
1966:
1967: arp_util.debug('rounding_bill_to_party_id : ' ||
1968: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ROUNDING_BILL_TO_PARTY_ID(1));

Line 1967: arp_util.debug('rounding_bill_to_party_id : ' ||

1963:
1964: arp_util.debug('rounding_ship_to_party_id : ' ||
1965: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ROUNDING_SHIP_TO_PARTY_ID(1));
1966:
1967: arp_util.debug('rounding_bill_to_party_id : ' ||
1968: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ROUNDING_BILL_TO_PARTY_ID(1));
1969:
1970: arp_util.debug('rndg_ship_to_party_site_id : ' ||
1971: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_SHIP_TO_PARTY_SITE_ID(1));

Line 1970: arp_util.debug('rndg_ship_to_party_site_id : ' ||

1966:
1967: arp_util.debug('rounding_bill_to_party_id : ' ||
1968: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ROUNDING_BILL_TO_PARTY_ID(1));
1969:
1970: arp_util.debug('rndg_ship_to_party_site_id : ' ||
1971: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_SHIP_TO_PARTY_SITE_ID(1));
1972:
1973: arp_util.debug('rndg_bill_to_party_site_id :' ||
1974: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_BILL_TO_PARTY_SITE_ID(1));

Line 1973: arp_util.debug('rndg_bill_to_party_site_id :' ||

1969:
1970: arp_util.debug('rndg_ship_to_party_site_id : ' ||
1971: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_SHIP_TO_PARTY_SITE_ID(1));
1972:
1973: arp_util.debug('rndg_bill_to_party_site_id :' ||
1974: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_BILL_TO_PARTY_SITE_ID(1));
1975:
1976: arp_util.debug('receivables_trx_type_id : ' ||
1977: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RECEIVABLES_TRX_TYPE_ID(1));

Line 1976: arp_util.debug('receivables_trx_type_id : ' ||

1972:
1973: arp_util.debug('rndg_bill_to_party_site_id :' ||
1974: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_BILL_TO_PARTY_SITE_ID(1));
1975:
1976: arp_util.debug('receivables_trx_type_id : ' ||
1977: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RECEIVABLES_TRX_TYPE_ID(1));
1978:
1979: arp_util.debug('tax_reporting_flag : ' ||
1980: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_REPORTING_FLAG(1));

Line 1979: arp_util.debug('tax_reporting_flag : ' ||

1975:
1976: arp_util.debug('receivables_trx_type_id : ' ||
1977: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RECEIVABLES_TRX_TYPE_ID(1));
1978:
1979: arp_util.debug('tax_reporting_flag : ' ||
1980: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_REPORTING_FLAG(1));
1981:
1982: arp_util.debug('quote_flag : ' ||
1983: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.QUOTE_FLAG(1));

Line 1982: arp_util.debug('quote_flag : ' ||

1978:
1979: arp_util.debug('tax_reporting_flag : ' ||
1980: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_REPORTING_FLAG(1));
1981:
1982: arp_util.debug('quote_flag : ' ||
1983: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.QUOTE_FLAG(1));
1984:
1985: arp_util.debug('trx_number : ' ||
1986: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_NUMBER(1));

Line 1985: arp_util.debug('trx_number : ' ||

1981:
1982: arp_util.debug('quote_flag : ' ||
1983: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.QUOTE_FLAG(1));
1984:
1985: arp_util.debug('trx_number : ' ||
1986: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_NUMBER(1));
1987:
1988: arp_util.debug('trx_description : ' ||
1989: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DESCRIPTION(1));

Line 1988: arp_util.debug('trx_description : ' ||

1984:
1985: arp_util.debug('trx_number : ' ||
1986: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_NUMBER(1));
1987:
1988: arp_util.debug('trx_description : ' ||
1989: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DESCRIPTION(1));
1990:
1991: arp_util.debug('trx_communicated_date : ' ||
1992: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_COMMUNICATED_DATE(1));

Line 1991: arp_util.debug('trx_communicated_date : ' ||

1987:
1988: arp_util.debug('trx_description : ' ||
1989: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DESCRIPTION(1));
1990:
1991: arp_util.debug('trx_communicated_date : ' ||
1992: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_COMMUNICATED_DATE(1));
1993:
1994: arp_util.debug('batch_source_id : ' ||
1995: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BATCH_SOURCE_ID(1));

Line 1994: arp_util.debug('batch_source_id : ' ||

1990:
1991: arp_util.debug('trx_communicated_date : ' ||
1992: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_COMMUNICATED_DATE(1));
1993:
1994: arp_util.debug('batch_source_id : ' ||
1995: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BATCH_SOURCE_ID(1));
1996:
1997: arp_util.debug('batch_source_name : ' ||
1998: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BATCH_SOURCE_NAME(1));

Line 1997: arp_util.debug('batch_source_name : ' ||

1993:
1994: arp_util.debug('batch_source_id : ' ||
1995: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BATCH_SOURCE_ID(1));
1996:
1997: arp_util.debug('batch_source_name : ' ||
1998: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BATCH_SOURCE_NAME(1));
1999:
2000: arp_util.debug('doc_seq_id : ' ||
2001: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_SEQ_ID(1));

Line 2000: arp_util.debug('doc_seq_id : ' ||

1996:
1997: arp_util.debug('batch_source_name : ' ||
1998: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BATCH_SOURCE_NAME(1));
1999:
2000: arp_util.debug('doc_seq_id : ' ||
2001: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_SEQ_ID(1));
2002:
2003: arp_util.debug('doc_seq_name :' ||
2004: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_SEQ_NAME(1));

Line 2003: arp_util.debug('doc_seq_name :' ||

1999:
2000: arp_util.debug('doc_seq_id : ' ||
2001: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_SEQ_ID(1));
2002:
2003: arp_util.debug('doc_seq_name :' ||
2004: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_SEQ_NAME(1));
2005:
2006: arp_util.debug('doc_seq_value : ' ||
2007: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_SEQ_VALUE(1));

Line 2006: arp_util.debug('doc_seq_value : ' ||

2002:
2003: arp_util.debug('doc_seq_name :' ||
2004: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_SEQ_NAME(1));
2005:
2006: arp_util.debug('doc_seq_value : ' ||
2007: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_SEQ_VALUE(1));
2008:
2009: arp_util.debug('trx_due_date : ' ||
2010: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DUE_DATE(1));

Line 2009: arp_util.debug('trx_due_date : ' ||

2005:
2006: arp_util.debug('doc_seq_value : ' ||
2007: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_SEQ_VALUE(1));
2008:
2009: arp_util.debug('trx_due_date : ' ||
2010: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DUE_DATE(1));
2011:
2012: arp_util.debug('trx_type_description : ' ||
2013: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_TYPE_DESCRIPTION(1));

Line 2012: arp_util.debug('trx_type_description : ' ||

2008:
2009: arp_util.debug('trx_due_date : ' ||
2010: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DUE_DATE(1));
2011:
2012: arp_util.debug('trx_type_description : ' ||
2013: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_TYPE_DESCRIPTION(1));
2014:
2015: arp_util.debug('trx_level_type : ' ||
2016: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LEVEL_TYPE(1));

Line 2015: arp_util.debug('trx_level_type : ' ||

2011:
2012: arp_util.debug('trx_type_description : ' ||
2013: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_TYPE_DESCRIPTION(1));
2014:
2015: arp_util.debug('trx_level_type : ' ||
2016: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LEVEL_TYPE(1));
2017:
2018: arp_util.debug('trx_line_id : ' ||
2019: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_ID(1));

Line 2018: arp_util.debug('trx_line_id : ' ||

2014:
2015: arp_util.debug('trx_level_type : ' ||
2016: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LEVEL_TYPE(1));
2017:
2018: arp_util.debug('trx_line_id : ' ||
2019: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_ID(1));
2020:
2021: arp_util.debug('line_class : ' ||
2022: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_CLASS(1));

Line 2021: arp_util.debug('line_class : ' ||

2017:
2018: arp_util.debug('trx_line_id : ' ||
2019: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_ID(1));
2020:
2021: arp_util.debug('line_class : ' ||
2022: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_CLASS(1));
2023:
2024: arp_util.debug('line_level_action : ' ||
2025: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_LEVEL_ACTION(1));

Line 2024: arp_util.debug('line_level_action : ' ||

2020:
2021: arp_util.debug('line_class : ' ||
2022: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_CLASS(1));
2023:
2024: arp_util.debug('line_level_action : ' ||
2025: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_LEVEL_ACTION(1));
2026:
2027: arp_util.debug('trx_shipping_date : ' ||
2028: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_SHIPPING_DATE(1));

Line 2027: arp_util.debug('trx_shipping_date : ' ||

2023:
2024: arp_util.debug('line_level_action : ' ||
2025: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_LEVEL_ACTION(1));
2026:
2027: arp_util.debug('trx_shipping_date : ' ||
2028: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_SHIPPING_DATE(1));
2029:
2030: arp_util.debug('trx_line_type : ' ||
2031: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_TYPE(1));

Line 2030: arp_util.debug('trx_line_type : ' ||

2026:
2027: arp_util.debug('trx_shipping_date : ' ||
2028: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_SHIPPING_DATE(1));
2029:
2030: arp_util.debug('trx_line_type : ' ||
2031: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_TYPE(1));
2032:
2033: arp_util.debug('trx_line_date : ' ||
2034: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_DATE(1));

Line 2033: arp_util.debug('trx_line_date : ' ||

2029:
2030: arp_util.debug('trx_line_type : ' ||
2031: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_TYPE(1));
2032:
2033: arp_util.debug('trx_line_date : ' ||
2034: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_DATE(1));
2035:
2036: arp_util.debug('line_amt_includes_tax_flag : ' ||
2037: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG(1));

Line 2036: arp_util.debug('line_amt_includes_tax_flag : ' ||

2032:
2033: arp_util.debug('trx_line_date : ' ||
2034: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_DATE(1));
2035:
2036: arp_util.debug('line_amt_includes_tax_flag : ' ||
2037: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG(1));
2038:
2039: arp_util.debug('line_amt : ' ||
2040: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_AMT(1));

Line 2039: arp_util.debug('line_amt : ' ||

2035:
2036: arp_util.debug('line_amt_includes_tax_flag : ' ||
2037: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG(1));
2038:
2039: arp_util.debug('line_amt : ' ||
2040: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_AMT(1));
2041:
2042: arp_util.debug('trx_line_quantity : ' ||
2043: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_QUANTITY(1));

Line 2042: arp_util.debug('trx_line_quantity : ' ||

2038:
2039: arp_util.debug('line_amt : ' ||
2040: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_AMT(1));
2041:
2042: arp_util.debug('trx_line_quantity : ' ||
2043: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_QUANTITY(1));
2044:
2045: arp_util.debug('unit_price : ' ||
2046: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.UNIT_PRICE(1));

Line 2045: arp_util.debug('unit_price : ' ||

2041:
2042: arp_util.debug('trx_line_quantity : ' ||
2043: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_QUANTITY(1));
2044:
2045: arp_util.debug('unit_price : ' ||
2046: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.UNIT_PRICE(1));
2047:
2048: arp_util.debug('exemption_control_flag : ' ||
2049: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(1));

Line 2048: arp_util.debug('exemption_control_flag : ' ||

2044:
2045: arp_util.debug('unit_price : ' ||
2046: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.UNIT_PRICE(1));
2047:
2048: arp_util.debug('exemption_control_flag : ' ||
2049: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(1));
2050:
2051: arp_util.debug('exempt_certificate_number : ' ||
2052: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(1));

Line 2051: arp_util.debug('exempt_certificate_number : ' ||

2047:
2048: arp_util.debug('exemption_control_flag : ' ||
2049: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(1));
2050:
2051: arp_util.debug('exempt_certificate_number : ' ||
2052: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(1));
2053:
2054: arp_util.debug('exempt_reason : ' ||
2055: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPT_REASON_CODE(1));

Line 2054: arp_util.debug('exempt_reason : ' ||

2050:
2051: arp_util.debug('exempt_certificate_number : ' ||
2052: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(1));
2053:
2054: arp_util.debug('exempt_reason : ' ||
2055: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPT_REASON_CODE(1));
2056:
2057: arp_util.debug('product_id : ' ||
2058: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_ID(1));

Line 2057: arp_util.debug('product_id : ' ||

2053:
2054: arp_util.debug('exempt_reason : ' ||
2055: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPT_REASON_CODE(1));
2056:
2057: arp_util.debug('product_id : ' ||
2058: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_ID(1));
2059:
2060: arp_util.debug('product_org_id : ' ||
2061: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_ORG_ID(1));

Line 2060: arp_util.debug('product_org_id : ' ||

2056:
2057: arp_util.debug('product_id : ' ||
2058: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_ID(1));
2059:
2060: arp_util.debug('product_org_id : ' ||
2061: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_ORG_ID(1));
2062:
2063: arp_util.debug('uom_code : ' ||
2064: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.UOM_CODE(1));

Line 2063: arp_util.debug('uom_code : ' ||

2059:
2060: arp_util.debug('product_org_id : ' ||
2061: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_ORG_ID(1));
2062:
2063: arp_util.debug('uom_code : ' ||
2064: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.UOM_CODE(1));
2065:
2066: arp_util.debug('fob_point : ' ||
2067: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.FOB_POINT(1));

Line 2066: arp_util.debug('fob_point : ' ||

2062:
2063: arp_util.debug('uom_code : ' ||
2064: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.UOM_CODE(1));
2065:
2066: arp_util.debug('fob_point : ' ||
2067: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.FOB_POINT(1));
2068:
2069: arp_util.debug('ship_to_party_id : ' ||
2070: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_PARTY_ID(1));

Line 2069: arp_util.debug('ship_to_party_id : ' ||

2065:
2066: arp_util.debug('fob_point : ' ||
2067: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.FOB_POINT(1));
2068:
2069: arp_util.debug('ship_to_party_id : ' ||
2070: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_PARTY_ID(1));
2071:
2072: arp_util.debug('ship_from_party_id : ' ||
2073: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(1));

Line 2072: arp_util.debug('ship_from_party_id : ' ||

2068:
2069: arp_util.debug('ship_to_party_id : ' ||
2070: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_PARTY_ID(1));
2071:
2072: arp_util.debug('ship_from_party_id : ' ||
2073: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(1));
2074:
2075: arp_util.debug('bill_to_party_id : ' ||
2076: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_PARTY_ID(1));

Line 2075: arp_util.debug('bill_to_party_id : ' ||

2071:
2072: arp_util.debug('ship_from_party_id : ' ||
2073: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(1));
2074:
2075: arp_util.debug('bill_to_party_id : ' ||
2076: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_PARTY_ID(1));
2077:
2078: arp_util.debug('ship_to_party_site_id : ' ||
2079: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_PARTY_SITE_ID(1));

Line 2078: arp_util.debug('ship_to_party_site_id : ' ||

2074:
2075: arp_util.debug('bill_to_party_id : ' ||
2076: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_PARTY_ID(1));
2077:
2078: arp_util.debug('ship_to_party_site_id : ' ||
2079: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_PARTY_SITE_ID(1));
2080:
2081: arp_util.debug('ship_to_location_id : ' ||
2082: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(1));

Line 2081: arp_util.debug('ship_to_location_id : ' ||

2077:
2078: arp_util.debug('ship_to_party_site_id : ' ||
2079: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_PARTY_SITE_ID(1));
2080:
2081: arp_util.debug('ship_to_location_id : ' ||
2082: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(1));
2083:
2084: arp_util.debug('bill_to_location_id : ' ||
2085: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_LOCATION_ID(1));

Line 2084: arp_util.debug('bill_to_location_id : ' ||

2080:
2081: arp_util.debug('ship_to_location_id : ' ||
2082: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(1));
2083:
2084: arp_util.debug('bill_to_location_id : ' ||
2085: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_LOCATION_ID(1));
2086:
2087: arp_util.debug('account_ccid : ' ||
2088: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ACCOUNT_CCID(1));

Line 2087: arp_util.debug('account_ccid : ' ||

2083:
2084: arp_util.debug('bill_to_location_id : ' ||
2085: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_LOCATION_ID(1));
2086:
2087: arp_util.debug('account_ccid : ' ||
2088: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ACCOUNT_CCID(1));
2089:
2090: arp_util.debug('output_tax_classification_code : ' ||
2091: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(1));

Line 2090: arp_util.debug('output_tax_classification_code : ' ||

2086:
2087: arp_util.debug('account_ccid : ' ||
2088: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ACCOUNT_CCID(1));
2089:
2090: arp_util.debug('output_tax_classification_code : ' ||
2091: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(1));
2092:
2093: arp_util.debug('interface_entity_code : ' ||
2094: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERFACE_ENTITY_CODE(1));

Line 2093: arp_util.debug('interface_entity_code : ' ||

2089:
2090: arp_util.debug('output_tax_classification_code : ' ||
2091: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(1));
2092:
2093: arp_util.debug('interface_entity_code : ' ||
2094: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERFACE_ENTITY_CODE(1));
2095:
2096: arp_util.debug('interface_line_id : ' ||
2097: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERFACE_LINE_ID(1));

Line 2096: arp_util.debug('interface_line_id : ' ||

2092:
2093: arp_util.debug('interface_entity_code : ' ||
2094: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERFACE_ENTITY_CODE(1));
2095:
2096: arp_util.debug('interface_line_id : ' ||
2097: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERFACE_LINE_ID(1));
2098:
2099: arp_util.debug('trx_line_number : ' ||
2100: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_NUMBER(1));

Line 2099: arp_util.debug('trx_line_number : ' ||

2095:
2096: arp_util.debug('interface_line_id : ' ||
2097: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERFACE_LINE_ID(1));
2098:
2099: arp_util.debug('trx_line_number : ' ||
2100: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_NUMBER(1));
2101:
2102: arp_util.debug('historical_flag : ' ||
2103: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HISTORICAL_FLAG(1));

Line 2102: arp_util.debug('historical_flag : ' ||

2098:
2099: arp_util.debug('trx_line_number : ' ||
2100: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_NUMBER(1));
2101:
2102: arp_util.debug('historical_flag : ' ||
2103: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HISTORICAL_FLAG(1));
2104:
2105: arp_util.debug('ctrl_hdr_tx_appl_flag : ' ||
2106: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(1));

Line 2105: arp_util.debug('ctrl_hdr_tx_appl_flag : ' ||

2101:
2102: arp_util.debug('historical_flag : ' ||
2103: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HISTORICAL_FLAG(1));
2104:
2105: arp_util.debug('ctrl_hdr_tx_appl_flag : ' ||
2106: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(1));
2107:
2108: arp_util.debug('ship_third_pty_acct_site_id : ' ||
2109: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(1));

Line 2108: arp_util.debug('ship_third_pty_acct_site_id : ' ||

2104:
2105: arp_util.debug('ctrl_hdr_tx_appl_flag : ' ||
2106: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(1));
2107:
2108: arp_util.debug('ship_third_pty_acct_site_id : ' ||
2109: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(1));
2110:
2111: arp_util.debug('bill_third_pty_acct_site_id : ' ||
2112: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_SITE_ID(1));

Line 2111: arp_util.debug('bill_third_pty_acct_site_id : ' ||

2107:
2108: arp_util.debug('ship_third_pty_acct_site_id : ' ||
2109: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(1));
2110:
2111: arp_util.debug('bill_third_pty_acct_site_id : ' ||
2112: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_SITE_ID(1));
2113:
2114: arp_util.debug('ship_third_pty_acct_id : ' ||
2115: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(1));

Line 2114: arp_util.debug('ship_third_pty_acct_id : ' ||

2110:
2111: arp_util.debug('bill_third_pty_acct_site_id : ' ||
2112: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_SITE_ID(1));
2113:
2114: arp_util.debug('ship_third_pty_acct_id : ' ||
2115: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(1));
2116:
2117: arp_util.debug('bill_third_pty_acct_id : ' ||
2118: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_ID(1));

Line 2117: arp_util.debug('bill_third_pty_acct_id : ' ||

2113:
2114: arp_util.debug('ship_third_pty_acct_id : ' ||
2115: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(1));
2116:
2117: arp_util.debug('bill_third_pty_acct_id : ' ||
2118: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_ID(1));
2119:
2120: arp_util.debug('ship_to_cust_acct_site_use_id : ' ||
2121: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(1));

Line 2120: arp_util.debug('ship_to_cust_acct_site_use_id : ' ||

2116:
2117: arp_util.debug('bill_third_pty_acct_id : ' ||
2118: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_ID(1));
2119:
2120: arp_util.debug('ship_to_cust_acct_site_use_id : ' ||
2121: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(1));
2122:
2123: arp_util.debug('bill_to_cust_acct_site_use_id : ' ||
2124: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(1));

Line 2123: arp_util.debug('bill_to_cust_acct_site_use_id : ' ||

2119:
2120: arp_util.debug('ship_to_cust_acct_site_use_id : ' ||
2121: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(1));
2122:
2123: arp_util.debug('bill_to_cust_acct_site_use_id : ' ||
2124: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(1));
2125:
2126: END print_ebt_plsql_vars;
2127:

Line 2172: arp_util.debug('ARP_ETAX_SERVICES_PKG.Line_det_factors()+');

2168: l_tax_amount NUMBER;
2169:
2170: BEGIN
2171:
2172: arp_util.debug('ARP_ETAX_SERVICES_PKG.Line_det_factors()+');
2173:
2174: IF (p_mode IN ('INSERT','INSERT_NO_TAX','INSERT_NO_TAX_EVER',
2175: 'INSERT_NO_LINE')) THEN
2176: l_action := 'CREATE';

Line 2205: arp_util.debug('customer trx id = ' || p_customer_trx_id);

2201: p_action => l_action,
2202: p_event_class_code => l_event_class_code,
2203: p_event_type_code => l_event_type_code);
2204:
2205: arp_util.debug('customer trx id = ' || p_customer_trx_id);
2206: arp_util.debug('event class code = ' || l_event_class_code);
2207: arp_util.debug('event type code = ' || l_event_type_code);
2208: arp_util.debug('line level action = ' || l_line_level_action);
2209:

Line 2206: arp_util.debug('event class code = ' || l_event_class_code);

2202: p_event_class_code => l_event_class_code,
2203: p_event_type_code => l_event_type_code);
2204:
2205: arp_util.debug('customer trx id = ' || p_customer_trx_id);
2206: arp_util.debug('event class code = ' || l_event_class_code);
2207: arp_util.debug('event type code = ' || l_event_type_code);
2208: arp_util.debug('line level action = ' || l_line_level_action);
2209:
2210: arp_util.debug('line level action = ' || l_line_level_action);

Line 2207: arp_util.debug('event type code = ' || l_event_type_code);

2203: p_event_type_code => l_event_type_code);
2204:
2205: arp_util.debug('customer trx id = ' || p_customer_trx_id);
2206: arp_util.debug('event class code = ' || l_event_class_code);
2207: arp_util.debug('event type code = ' || l_event_type_code);
2208: arp_util.debug('line level action = ' || l_line_level_action);
2209:
2210: arp_util.debug('line level action = ' || l_line_level_action);
2211: IF (l_success) THEN

Line 2208: arp_util.debug('line level action = ' || l_line_level_action);

2204:
2205: arp_util.debug('customer trx id = ' || p_customer_trx_id);
2206: arp_util.debug('event class code = ' || l_event_class_code);
2207: arp_util.debug('event type code = ' || l_event_type_code);
2208: arp_util.debug('line level action = ' || l_line_level_action);
2209:
2210: arp_util.debug('line level action = ' || l_line_level_action);
2211: IF (l_success) THEN
2212:

Line 2210: arp_util.debug('line level action = ' || l_line_level_action);

2206: arp_util.debug('event class code = ' || l_event_class_code);
2207: arp_util.debug('event type code = ' || l_event_type_code);
2208: arp_util.debug('line level action = ' || l_line_level_action);
2209:
2210: arp_util.debug('line level action = ' || l_line_level_action);
2211: IF (l_success) THEN
2212:
2213: -- populate the transaction_line_rec for use in the tax service
2214: l_transaction_line_rec.internal_organization_id := NULL;

Line 2226: arp_util.debug('calling populate_ebt_plsql_tables ');

2222:
2223: /* initialize the plsql table */
2224: ZX_GLOBAL_STRUCTURES_PKG.INIT_TRX_LINE_DIST_TBL(1);
2225:
2226: arp_util.debug('calling populate_ebt_plsql_tables ');
2227: populate_ebt_plsql_tables(
2228: p_customer_trx_id => p_customer_trx_id,
2229: p_customer_trx_line_id => p_customer_trx_line_id,
2230: p_event_type_code => l_event_type_code,

Line 2265: arp_util.debug('line_det_factors returned error');

2261: end if;
2262:
2263: -- verify the return status from the tax api.
2264: IF (l_return_status_service <> 'S') THEN -- handle errors
2265: arp_util.debug('line_det_factors returned error');
2266: IF ( l_msg_count = 1 ) THEN
2267: -- then there is only 1 message raised by the API, and
2268: -- it has been sent out in the parameter x_msg_data.
2269: l_msg_data_out := l_msg_data;

Line 2270: arp_util.debug('API failed with : ' || l_msg_data_out);

2266: IF ( l_msg_count = 1 ) THEN
2267: -- then there is only 1 message raised by the API, and
2268: -- it has been sent out in the parameter x_msg_data.
2269: l_msg_data_out := l_msg_data;
2270: arp_util.debug('API failed with : ' || l_msg_data_out);
2271: l_mesg := l_msg_data_out;
2272:
2273: ELSIF (l_msg_count > 1) THEN
2274: -- the messages are on the stack and there is more then

Line 2282: arp_util.debug('API failed with : ' || l_mesg);

2278: FND_API.G_FALSE);
2279: if (l_mesg IS NULL) THEN
2280: EXIT;
2281: end if;
2282: arp_util.debug('API failed with : ' || l_mesg);
2283: end loop;
2284: END IF;
2285:
2286: -- raise error

Line 2295: arp_util.debug('ERROR getting EVENT INFORMATION');

2291:
2292: APP_EXCEPTION.RAISE_EXCEPTION;
2293: END IF;
2294: ELSE
2295: arp_util.debug('ERROR getting EVENT INFORMATION');
2296: END IF;
2297: arp_util.debug('ARP_ETAX_SERVICES_PKG.Line_det_factors()-');
2298:
2299: END line_det_factors;

Line 2297: arp_util.debug('ARP_ETAX_SERVICES_PKG.Line_det_factors()-');

2293: END IF;
2294: ELSE
2295: arp_util.debug('ERROR getting EVENT INFORMATION');
2296: END IF;
2297: arp_util.debug('ARP_ETAX_SERVICES_PKG.Line_det_factors()-');
2298:
2299: END line_det_factors;
2300:
2301: /*=============================================================================

Line 2335: arp_util.debug('arp_etax_services_pkg.Header_det_factors(+)');

2331: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
2332: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
2333: l_llst_exists NUMBER := 0; -- 4713671
2334: BEGIN
2335: arp_util.debug('arp_etax_services_pkg.Header_det_factors(+)');
2336:
2337: /* Initializing return status ..*/
2338: x_return_status := FND_API.G_RET_STS_SUCCESS;
2339:

Line 2428: arp_util.debug('customer trx id = ' || p_customer_trx_id);

2424: p_action => l_action,
2425: p_event_class_code => l_event_class_code,
2426: p_event_type_code => l_event_type_code);
2427:
2428: arp_util.debug('customer trx id = ' || p_customer_trx_id);
2429: arp_util.debug('event class code = ' || l_event_class_code);
2430: arp_util.debug('event type code = ' || l_event_type_code);
2431:
2432: IF (l_success) THEN

Line 2429: arp_util.debug('event class code = ' || l_event_class_code);

2425: p_event_class_code => l_event_class_code,
2426: p_event_type_code => l_event_type_code);
2427:
2428: arp_util.debug('customer trx id = ' || p_customer_trx_id);
2429: arp_util.debug('event class code = ' || l_event_class_code);
2430: arp_util.debug('event type code = ' || l_event_type_code);
2431:
2432: IF (l_success) THEN
2433: -- need to select from the table as items have been posted to

Line 2430: arp_util.debug('event type code = ' || l_event_type_code);

2426: p_event_type_code => l_event_type_code);
2427:
2428: arp_util.debug('customer trx id = ' || p_customer_trx_id);
2429: arp_util.debug('event class code = ' || l_event_class_code);
2430: arp_util.debug('event type code = ' || l_event_type_code);
2431:
2432: IF (l_success) THEN
2433: -- need to select from the table as items have been posted to
2434: -- populate the header_det_factors_rec_type

Line 2609: arp_util.debug('ERROR getting EVENT INFORMATION');

2605:
2606: END IF; -- end header is null
2607: END IF; -- end llst exists
2608: ELSE
2609: arp_util.debug('ERROR getting EVENT INFORMATION');
2610: END IF;
2611:
2612: -- need to call the tax api
2613: zx_api_pub.update_det_factors_hdr(

Line 2625: arp_util.debug('arp_etax_services_pkg.Header_det_factors(-)');

2621: p_hdr_det_factors_rec => l_hdr_det_factors_rec
2622: );
2623:
2624: END IF;
2625: arp_util.debug('arp_etax_services_pkg.Header_det_factors(-)');
2626:
2627: END Header_det_factors;
2628:
2629: /*=============================================================================

Line 2680: arp_util.debug('ARP_ETAX_SERVICES_PKG.Calculate_tax(+)');

2676: l_account_set_flag VARCHAR2(1);
2677: l_rtn NUMBER;
2678: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;
2679: BEGIN
2680: arp_util.debug('ARP_ETAX_SERVICES_PKG.Calculate_tax(+)');
2681: arp_util.debug('p_action = ' || p_action);
2682:
2683: /* initializing precision, mau, hdr level rdn */
2684: pg_base_precision := arp_trx_global.system_info.base_precision;

Line 2681: arp_util.debug('p_action = ' || p_action);

2677: l_rtn NUMBER;
2678: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;
2679: BEGIN
2680: arp_util.debug('ARP_ETAX_SERVICES_PKG.Calculate_tax(+)');
2681: arp_util.debug('p_action = ' || p_action);
2682:
2683: /* initializing precision, mau, hdr level rdn */
2684: pg_base_precision := arp_trx_global.system_info.base_precision;
2685: pg_base_min_acc_unit := arp_trx_global.system_info.base_min_acc_unit;

Line 2699: arp_util.debug('customer trx id = ' || p_customer_trx_id);

2695: p_action => p_action,
2696: p_event_class_code => l_event_class_code,
2697: p_event_type_code => l_event_type_code);
2698:
2699: arp_util.debug('customer trx id = ' || p_customer_trx_id);
2700: arp_util.debug('action = ' || p_action);
2701: arp_util.debug('event class code = ' || l_event_class_code);
2702: arp_util.debug('event type code = ' || l_event_type_code);
2703:

Line 2700: arp_util.debug('action = ' || p_action);

2696: p_event_class_code => l_event_class_code,
2697: p_event_type_code => l_event_type_code);
2698:
2699: arp_util.debug('customer trx id = ' || p_customer_trx_id);
2700: arp_util.debug('action = ' || p_action);
2701: arp_util.debug('event class code = ' || l_event_class_code);
2702: arp_util.debug('event type code = ' || l_event_type_code);
2703:
2704: IF (l_success) THEN

Line 2701: arp_util.debug('event class code = ' || l_event_class_code);

2697: p_event_type_code => l_event_type_code);
2698:
2699: arp_util.debug('customer trx id = ' || p_customer_trx_id);
2700: arp_util.debug('action = ' || p_action);
2701: arp_util.debug('event class code = ' || l_event_class_code);
2702: arp_util.debug('event type code = ' || l_event_type_code);
2703:
2704: IF (l_success) THEN
2705: /* populate transaction rec type */

Line 2702: arp_util.debug('event type code = ' || l_event_type_code);

2698:
2699: arp_util.debug('customer trx id = ' || p_customer_trx_id);
2700: arp_util.debug('action = ' || p_action);
2701: arp_util.debug('event class code = ' || l_event_class_code);
2702: arp_util.debug('event type code = ' || l_event_type_code);
2703:
2704: IF (l_success) THEN
2705: /* populate transaction rec type */
2706: l_transaction_rec.internal_organization_id := arp_global.sysparam.org_id; l_transaction_rec.application_id := 222;

Line 2723: arp_util.debug('calling ZX api to calculate tax');

2719: /* 5152340 - Remove AR tax lines prior to calculate call */
2720: arp_etax_util.delete_tax_lines_from_ar(p_customer_trx_id);
2721:
2722: /* call Tax */
2723: arp_util.debug('calling ZX api to calculate tax');
2724:
2725: zx_api_pub.calculate_tax(
2726: p_api_version => 1.0,
2727: p_init_msg_list => FND_API.G_TRUE,

Line 2738: arp_util.debug('return status service = ' || x_return_status);

2734: x_msg_count => x_msg_count,
2735: x_msg_data => x_msg_data,
2736: x_doc_level_recalc_flag => l_doc_level_recalc_flag );
2737:
2738: arp_util.debug('return status service = ' || x_return_status);
2739:
2740: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2741: -- insert Tax records into ra_customer_trx_lines based upon
2742: -- customer trx id

Line 2743: arp_util.debug('calling build_ar_tax_lines ...');

2739:
2740: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2741: -- insert Tax records into ra_customer_trx_lines based upon
2742: -- customer trx id
2743: arp_util.debug('calling build_ar_tax_lines ...');
2744:
2745: arp_etax_util.build_ar_tax_lines(
2746: p_customer_trx_id => p_customer_trx_id,
2747: p_rows_inserted => l_rows);

Line 2866: arp_util.debug('EXCEPTION: arp_etax_services_pkg.calculate_tax()');

2862: pg_trx_header_level_rounding ,
2863: 'N',
2864: 'N') = 0 -- FALSE
2865: THEN
2866: arp_util.debug('EXCEPTION: arp_etax_services_pkg.calculate_tax()');
2867: arp_util.debug(l_error_message);
2868: fnd_message.set_name('AR', 'AR_ROUNDING_ERROR');
2869: fnd_message.set_token('ROUTINE','ARP_ETAX_SERVICES_PKG.CALCULATE_TAX');
2870: APP_EXCEPTION.raise_exception;

Line 2867: arp_util.debug(l_error_message);

2863: 'N',
2864: 'N') = 0 -- FALSE
2865: THEN
2866: arp_util.debug('EXCEPTION: arp_etax_services_pkg.calculate_tax()');
2867: arp_util.debug(l_error_message);
2868: fnd_message.set_name('AR', 'AR_ROUNDING_ERROR');
2869: fnd_message.set_token('ROUTINE','ARP_ETAX_SERVICES_PKG.CALCULATE_TAX');
2870: APP_EXCEPTION.raise_exception;
2871: END IF;

Line 2881: arp_util.debug('ARP_ETAX_SERVICES_PKG.Calculate_tax(-)');

2877: ELSE
2878: arp_standard.debug('could not get an event class code');
2879: END IF;
2880:
2881: arp_util.debug('ARP_ETAX_SERVICES_PKG.Calculate_tax(-)');
2882: END Calculate_tax;
2883:
2884: /*=============================================================================
2885: | FUNCTION - Get_Tax_Action()

Line 2907: arp_util.debug('ARP_ETAX_SERVICES_PKG.Get_Tax_Action(+)');

2903: l_action VARCHAR2(12);
2904:
2905: BEGIN
2906:
2907: arp_util.debug('ARP_ETAX_SERVICES_PKG.Get_Tax_Action(+)');
2908:
2909: select count(customer_trx_id)
2910: INTO l_count
2911: FROM ra_customer_trx_lines

Line 2921: arp_util.debug('ARP_ETAX_SERVICES_PKG.Get_Tax_Action(-)');

2917: ELSE
2918: l_action := 'UPDATE';
2919: END IF;
2920:
2921: arp_util.debug('ARP_ETAX_SERVICES_PKG.Get_Tax_Action(-)');
2922:
2923: return l_action;
2924:
2925: END Get_Tax_Action;

Line 2970: arp_util.debug('ARP_ETAX_SERVICES_PKG.Override_Tax_Lines(+)');

2966: pg_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
2967: pg_trx_header_level_rounding ar_system_parameters.trx_header_level_rounding%type;
2968:
2969: BEGIN
2970: arp_util.debug('ARP_ETAX_SERVICES_PKG.Override_Tax_Lines(+)');
2971:
2972: /* Bug 8220233: Initializing precision, mau, hdr level rounding */
2973: pg_base_precision := arp_trx_global.system_info.base_precision;
2974: pg_base_min_acc_unit := arp_trx_global.system_info.base_min_acc_unit;

Line 2987: arp_util.debug('customer trx id = ' || p_customer_trx_id);

2983: p_action => p_action,
2984: p_event_class_code => l_event_class_code,
2985: p_event_type_code => l_event_type_code);
2986:
2987: arp_util.debug('customer trx id = ' || p_customer_trx_id);
2988: arp_util.debug('action = ' || p_action);
2989: arp_util.debug('event class code = ' || l_event_class_code);
2990: arp_util.debug('event type code = ' || l_event_type_code);
2991:

Line 2988: arp_util.debug('action = ' || p_action);

2984: p_event_class_code => l_event_class_code,
2985: p_event_type_code => l_event_type_code);
2986:
2987: arp_util.debug('customer trx id = ' || p_customer_trx_id);
2988: arp_util.debug('action = ' || p_action);
2989: arp_util.debug('event class code = ' || l_event_class_code);
2990: arp_util.debug('event type code = ' || l_event_type_code);
2991:
2992: IF (l_success) THEN

Line 2989: arp_util.debug('event class code = ' || l_event_class_code);

2985: p_event_type_code => l_event_type_code);
2986:
2987: arp_util.debug('customer trx id = ' || p_customer_trx_id);
2988: arp_util.debug('action = ' || p_action);
2989: arp_util.debug('event class code = ' || l_event_class_code);
2990: arp_util.debug('event type code = ' || l_event_type_code);
2991:
2992: IF (l_success) THEN
2993: /* populate transaction rec type */

Line 2990: arp_util.debug('event type code = ' || l_event_type_code);

2986:
2987: arp_util.debug('customer trx id = ' || p_customer_trx_id);
2988: arp_util.debug('action = ' || p_action);
2989: arp_util.debug('event class code = ' || l_event_class_code);
2990: arp_util.debug('event type code = ' || l_event_type_code);
2991:
2992: IF (l_success) THEN
2993: /* populate transaction rec type */
2994: l_transaction_rec.internal_organization_id := arp_global.sysparam.org_id;

Line 3024: arp_util.debug('calling build_ar_tax_lines ...');

3020: -- update AR with return from tax
3021: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3022: -- insert Tax records into ra_customer_trx_lines based upon
3023: -- customer trx id
3024: arp_util.debug('calling build_ar_tax_lines ...');
3025:
3026: arp_etax_util.build_ar_tax_lines(
3027: p_customer_trx_id => p_customer_trx_id,
3028: p_rows_inserted => l_rows);

Line 3104: arp_util.debug('EXCEPTION: arp_etax_services_pkg.Override_Tax_Lines()');

3100: pg_trx_header_level_rounding ,
3101: 'N',
3102: 'N') = 0 -- FALSE
3103: THEN
3104: arp_util.debug('EXCEPTION: arp_etax_services_pkg.Override_Tax_Lines()');
3105: arp_util.debug(l_error_message);
3106: fnd_message.set_name('AR', 'AR_ROUNDING_ERROR');
3107: fnd_message.set_token('ROUTINE','ARP_ETAX_SERVICES_PKG.OVERRIDE_TAX_LINES');
3108: APP_EXCEPTION.raise_exception;

Line 3105: arp_util.debug(l_error_message);

3101: 'N',
3102: 'N') = 0 -- FALSE
3103: THEN
3104: arp_util.debug('EXCEPTION: arp_etax_services_pkg.Override_Tax_Lines()');
3105: arp_util.debug(l_error_message);
3106: fnd_message.set_name('AR', 'AR_ROUNDING_ERROR');
3107: fnd_message.set_token('ROUTINE','ARP_ETAX_SERVICES_PKG.OVERRIDE_TAX_LINES');
3108: APP_EXCEPTION.raise_exception;
3109: END IF;

Line 3117: arp_util.debug('ARP_ETAX_SERVICES_PKG.Override_Tax_Lines(-)');

3113: END IF; -- l_rows
3114: END IF;
3115:
3116: END IF; -- if event codes were derived.
3117: arp_util.debug('ARP_ETAX_SERVICES_PKG.Override_Tax_Lines(-)');
3118: END Override_Tax_Lines;
3119:
3120: /*=============================================================================
3121: | FUNCTION - is_trx_completed()

Line 3147: arp_util.debug('ARP_ETAX_SERVICES_PKG.is_tax_update_allowed()+');

3143: l_update boolean;
3144: l_complete_flag varchar2(1);
3145: BEGIN
3146:
3147: arp_util.debug('ARP_ETAX_SERVICES_PKG.is_tax_update_allowed()+');
3148:
3149: SELECT complete_flag
3150: INTO l_complete_flag
3151: FROM ra_customer_trx

Line 3158: arp_util.debug(' updates prevented by complete_flag');

3154: IF (l_complete_flag = 'Y' )
3155: THEN
3156: /* trx is complete, prevent updates */
3157: l_update := FALSE;
3158: arp_util.debug(' updates prevented by complete_flag');
3159: ELSE
3160: /* trx is incomplete, changes are allowed */
3161: l_update := TRUE;
3162: END IF;

Line 3164: arp_util.debug('ARP_ETAX_SERVICES_PKG.is_tax_update_allowed()-');

3160: /* trx is incomplete, changes are allowed */
3161: l_update := TRUE;
3162: END IF;
3163:
3164: arp_util.debug('ARP_ETAX_SERVICES_PKG.is_tax_update_allowed()-');
3165:
3166: return l_update;
3167:
3168: END is_tax_update_allowed;