APPS.ARP_ETAX_UTIL dependencies on STANDARD

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 205: arp_standard.profile.user_id,

201: )
202: SELECT
203: ra_customer_trx_lines_s.nextval,
204: sysdate,
205: arp_standard.profile.user_id,
206: sysdate,
207: arp_standard.profile.user_id,
208: arp_standard.profile.user_id,
209: arp_standard.profile.program_id,

Line 207: arp_standard.profile.user_id,

203: ra_customer_trx_lines_s.nextval,
204: sysdate,
205: arp_standard.profile.user_id,
206: sysdate,
207: arp_standard.profile.user_id,
208: arp_standard.profile.user_id,
209: arp_standard.profile.program_id,
210: arp_standard.application_id,
211: zxt.trx_id,

Line 208: arp_standard.profile.user_id,

204: sysdate,
205: arp_standard.profile.user_id,
206: sysdate,
207: arp_standard.profile.user_id,
208: arp_standard.profile.user_id,
209: arp_standard.profile.program_id,
210: arp_standard.application_id,
211: zxt.trx_id,
212: zxt.tax_line_number,

Line 209: arp_standard.profile.program_id,

205: arp_standard.profile.user_id,
206: sysdate,
207: arp_standard.profile.user_id,
208: arp_standard.profile.user_id,
209: arp_standard.profile.program_id,
210: arp_standard.application_id,
211: zxt.trx_id,
212: zxt.tax_line_number,
213: arp_standard.sysparm.set_of_books_id,

Line 210: arp_standard.application_id,

206: sysdate,
207: arp_standard.profile.user_id,
208: arp_standard.profile.user_id,
209: arp_standard.profile.program_id,
210: arp_standard.application_id,
211: zxt.trx_id,
212: zxt.tax_line_number,
213: arp_standard.sysparm.set_of_books_id,
214: 'TAX',

Line 213: arp_standard.sysparm.set_of_books_id,

209: arp_standard.profile.program_id,
210: arp_standard.application_id,
211: zxt.trx_id,
212: zxt.tax_line_number,
213: arp_standard.sysparm.set_of_books_id,
214: 'TAX',
215: zxt.trx_line_id,
216: plin.default_ussgl_transaction_code,
217: NULL, -- request_id

Line 261: arp_standard.debug(' Number of tax lines retrieved = ' || l_rows);

257: to autoaccounting and other followon code */
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:

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 308: arp_standard.debug(' Deleted tax dists = ' || l_rows);

304: AND posting_control_id = -3;
305:
306: IF PG_DEBUG in ('Y', 'C') THEN
307: l_rows := SQL%ROWCOUNT;
308: arp_standard.debug(' Deleted tax dists = ' || l_rows);
309: END IF;
310:
311: /* NOTE: zx_lines_u2 uses only tax_line_id as key */
312:

Line 322: arp_standard.debug(' Deleted tax lines = ' || l_rows);

318: FROM ZX_LINES);
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;

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 350: arp_standard.debug('validate_and_default_tax_attr returns successfully');

346:
347: IF l_return_status = FND_API.G_RET_STS_SUCCESS
348: THEN
349: IF PG_DEBUG in ('Y', 'C') THEN
350: arp_standard.debug('validate_and_default_tax_attr returns successfully');
351: END IF;
352: p_return_status := 0;
353: ELSE /* fatal error */
354: IF PG_DEBUG in ('Y', 'C') THEN

Line 355: arp_standard.debug('validate_and_default_tax_attr returns failure');

351: END IF;
352: p_return_status := 0;
353: ELSE /* fatal error */
354: IF PG_DEBUG in ('Y', 'C') THEN
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()+');

Line 374: arp_standard.debug(l_message_data);

370:
371: /* Retrieve and log errors */
372: IF l_message_count = 1
373: THEN
374: arp_standard.debug(l_message_data);
375: IF p_called_from_AI = 'Y' THEN
376: debug(l_message_data);
377: END IF;
378: ELSIF l_message_count > 1

Line 387: arp_standard.debug(l_msg);

383: IF l_msg IS NULL
384: THEN
385: EXIT;
386: ELSE
387: arp_standard.debug(l_msg);
388: IF p_called_from_AI = 'Y' THEN
389: debug(l_msg);
390: END IF;
391: END IF;

Line 421: arp_standard.debug('import_document_with_tax returns successfully');

417:
418: IF l_return_status = FND_API.G_RET_STS_SUCCESS
419: THEN
420: IF PG_DEBUG in ('Y', 'C') THEN
421: arp_standard.debug('import_document_with_tax returns successfully');
422: END IF;
423: p_return_status := 0;
424: ELSE /* fatal error */
425: IF PG_DEBUG in ('Y', 'C') THEN

Line 426: arp_standard.debug('import_document_with_tax returns failure');

422: END IF;
423: p_return_status := 0;
424: ELSE /* fatal error */
425: IF PG_DEBUG in ('Y', 'C') THEN
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()+');

Line 445: arp_standard.debug(l_message_data);

441:
442: /* Retrieve and log errors */
443: IF l_message_count = 1
444: THEN
445: arp_standard.debug(l_message_data);
446: IF p_called_from_AI = 'Y' THEN
447: debug(l_message_data);
448: END IF;
449: ELSIF l_message_count > 1

Line 458: arp_standard.debug(l_msg);

454: IF l_msg IS NULL
455: THEN
456: EXIT;
457: ELSE
458: arp_standard.debug(l_msg);
459: IF p_called_from_AI = 'Y' THEN
460: debug(l_msg);
461: END IF;
462: END IF;

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 512: arp_standard.debug('OU = ' || p_org_id);

508: p_legal_ent := xle_tbl(1).legal_entity_id;
509:
510:
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;

Line 513: arp_standard.debug('LE = ' || p_legal_ent);

509:
510:
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:

Line 514: arp_standard.debug('DEF Country = ' || p_def_country);

510:
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;

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 725: arp_standard.debug('sychronize_tax returns successfully');

721: /* If a problem arises with synchronization, document it */
722: IF l_return_status = FND_API.G_RET_STS_SUCCESS
723: THEN
724: IF PG_DEBUG in ('Y', 'C') THEN
725: arp_standard.debug('sychronize_tax returns successfully');
726: END IF;
727: p_return_status := 0;
728: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
729: THEN

Line 731: arp_standard.debug('synchronize_tax returns with validation errors');

727: p_return_status := 0;
728: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
729: THEN
730: IF PG_DEBUG in ('Y', 'C') THEN
731: arp_standard.debug('synchronize_tax returns with validation errors');
732: END IF;
733: p_return_status := 1;
734: ELSE /* fatal error */
735: p_return_status := 2;

Line 737: arp_standard.debug('synchronize_tax returns failure');

733: p_return_status := 1;
734: ELSE /* fatal error */
735: p_return_status := 2;
736: IF PG_DEBUG in ('Y', 'C') THEN
737: arp_standard.debug('synchronize_tax returns failure');
738: END IF;
739:
740: /* Retrieve and log errors */
741: IF l_message_count = 1

Line 743: arp_standard.debug(l_message_data);

739:
740: /* Retrieve and log errors */
741: IF l_message_count = 1
742: THEN
743: arp_standard.debug(l_message_data);
744: ELSIF l_message_count > 1
745: THEN
746: LOOP
747: l_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,

Line 753: arp_standard.debug(l_msg);

749: IF l_msg IS NULL
750: THEN
751: EXIT;
752: ELSE
753: arp_standard.debug(l_msg);
754: END IF;
755: END LOOP;
756: END IF;
757: END IF;

Line 814: arp_standard.debug('sychronize_tax returns successfully');

810: /* If a problem arises with synchronization, document it */
811: IF l_return_status = FND_API.G_RET_STS_SUCCESS
812: THEN
813: IF PG_DEBUG in ('Y', 'C') THEN
814: arp_standard.debug('sychronize_tax returns successfully');
815: END IF;
816: p_return_status := 0;
817: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
818: THEN

Line 820: arp_standard.debug('synchronize_tax returns with validation errors');

816: p_return_status := 0;
817: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
818: THEN
819: IF PG_DEBUG in ('Y', 'C') THEN
820: arp_standard.debug('synchronize_tax returns with validation errors');
821: END IF;
822: p_return_status := 1;
823: ELSE /* fatal error */
824: p_return_status := 2;

Line 826: arp_standard.debug('synchronize_tax returns failure');

822: p_return_status := 1;
823: ELSE /* fatal error */
824: p_return_status := 2;
825: IF PG_DEBUG in ('Y', 'C') THEN
826: arp_standard.debug('synchronize_tax returns failure');
827: END IF;
828:
829: /* Retrieve and log errors */
830: IF l_message_count = 1

Line 832: arp_standard.debug(l_message_data);

828:
829: /* Retrieve and log errors */
830: IF l_message_count = 1
831: THEN
832: arp_standard.debug(l_message_data);
833: ELSIF l_message_count > 1
834: THEN
835: LOOP
836: l_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,

Line 842: arp_standard.debug(l_msg);

838: IF l_msg IS NULL
839: THEN
840: EXIT;
841: ELSE
842: arp_standard.debug(l_msg);
843: END IF;
844: END LOOP;
845: END IF;
846: END IF;

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 874: arp_standard.debug('zx_global_document_update called for ' ||

870: l_msg VARCHAR2(2000);
871:
872: BEGIN
873: IF PG_DEBUG in ('Y', 'C') THEN
874: arp_standard.debug('zx_global_document_update called for ' ||
875: p_trx_rec.trx_id);
876: END IF;
877:
878: /* Now call the API to synchronize the repository */

Line 894: arp_standard.debug('gdu returns successfully');

890: /* If a problem arises with synchronization, document it */
891: IF l_return_status = FND_API.G_RET_STS_SUCCESS
892: THEN
893: IF PG_DEBUG in ('Y', 'C') THEN
894: arp_standard.debug('gdu returns successfully');
895: END IF;
896: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
897: THEN
898: IF PG_DEBUG in ('Y', 'C') THEN

Line 899: arp_standard.debug('gdu returns with validation errors');

895: END IF;
896: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
897: THEN
898: IF PG_DEBUG in ('Y', 'C') THEN
899: arp_standard.debug('gdu returns with validation errors');
900: END IF;
901: ELSE /* fatal error */
902: IF PG_DEBUG in ('Y', 'C') THEN
903: arp_standard.debug('gdu returns failure');

Line 903: arp_standard.debug('gdu returns failure');

899: arp_standard.debug('gdu returns with validation errors');
900: END IF;
901: ELSE /* fatal error */
902: IF PG_DEBUG in ('Y', 'C') THEN
903: arp_standard.debug('gdu returns failure');
904: END IF;
905:
906: /* Retrieve and log errors */
907: IF l_message_count = 1

Line 909: arp_standard.debug(l_message_data);

905:
906: /* Retrieve and log errors */
907: IF l_message_count = 1
908: THEN
909: arp_standard.debug(l_message_data);
910: ELSIF l_message_count > 1
911: THEN
912: LOOP
913: l_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,

Line 919: arp_standard.debug(l_msg);

915: IF l_msg IS NULL
916: THEN
917: EXIT;
918: ELSE
919: arp_standard.debug(l_msg);
920: END IF;
921: END LOOP;
922: END IF;
923: END IF;

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 959: arp_standard.debug(' trx_id = ' || p_customer_trx_id);

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;
963:

Line 960: arp_standard.debug(' req_id = ' || p_request_id);

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;
963:
964: l_trx_rec.internal_organization_id := arp_global.sysparam.org_id;

Line 961: arp_standard.debug(' action = ' || p_action);

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;
963:
964: l_trx_rec.internal_organization_id := arp_global.sysparam.org_id;
965: l_trx_rec.application_id := 222;

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 1097: arp_standard.debug('Unable to fetch ccid');

1093: ,l_fail_count);
1094:
1095: IF l_ccid = -1
1096: THEN
1097: arp_standard.debug('Unable to fetch ccid');
1098: l_ccid := NULL;
1099: END IF;
1100:
1101: zx_ar_tax_classificatn_def_pkg.get_default_tax_classification(

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 1204: arp_standard.debug( ' rows found : ' || l_rows_needing_update);

1200:
1201: l_rows_updated := SQL%ROWCOUNT;
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:

Line 1205: arp_standard.debug( ' rows updated : ' || l_rows_updated);

1201: l_rows_updated := SQL%ROWCOUNT;
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;

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 1275: if p_trx_currency_code = arp_standard.sysparm.tax_currency_code and p_autotax_flag in ( 'Y','U')

1271: END IF;
1272:
1273: l_rounding_rule := p_rounding_rule;
1274:
1275: if p_trx_currency_code = arp_standard.sysparm.tax_currency_code and p_autotax_flag in ( 'Y','U')
1276: THEN
1277:
1278: l_precision := least( p_precision, nvl(arp_standard.sysparm.tax_precision, p_precision) );
1279: l_min_acct_unit := greatest( nvl(p_min_acct_unit, arp_standard.sysparm.tax_minimum_accountable_unit),

Line 1278: l_precision := least( p_precision, nvl(arp_standard.sysparm.tax_precision, p_precision) );

1274:
1275: if p_trx_currency_code = arp_standard.sysparm.tax_currency_code and p_autotax_flag in ( 'Y','U')
1276: THEN
1277:
1278: l_precision := least( p_precision, nvl(arp_standard.sysparm.tax_precision, p_precision) );
1279: l_min_acct_unit := greatest( nvl(p_min_acct_unit, arp_standard.sysparm.tax_minimum_accountable_unit),
1280: nvl(arp_standard.sysparm.tax_minimum_accountable_unit, p_min_acct_unit));
1281:
1282: ELSE

Line 1279: l_min_acct_unit := greatest( nvl(p_min_acct_unit, arp_standard.sysparm.tax_minimum_accountable_unit),

1275: if p_trx_currency_code = arp_standard.sysparm.tax_currency_code and p_autotax_flag in ( 'Y','U')
1276: THEN
1277:
1278: l_precision := least( p_precision, nvl(arp_standard.sysparm.tax_precision, p_precision) );
1279: l_min_acct_unit := greatest( nvl(p_min_acct_unit, arp_standard.sysparm.tax_minimum_accountable_unit),
1280: nvl(arp_standard.sysparm.tax_minimum_accountable_unit, p_min_acct_unit));
1281:
1282: ELSE
1283:

Line 1280: nvl(arp_standard.sysparm.tax_minimum_accountable_unit, p_min_acct_unit));

1276: THEN
1277:
1278: l_precision := least( p_precision, nvl(arp_standard.sysparm.tax_precision, p_precision) );
1279: l_min_acct_unit := greatest( nvl(p_min_acct_unit, arp_standard.sysparm.tax_minimum_accountable_unit),
1280: nvl(arp_standard.sysparm.tax_minimum_accountable_unit, p_min_acct_unit));
1281:
1282: ELSE
1283:
1284: l_precision := p_precision;

Line 1290: arp_standard.debug(' trx currency = :'||p_trx_currency_code||':');

1286:
1287: END IF;
1288:
1289: IF PG_DEBUG = 'Y' THEN
1290: arp_standard.debug(' trx currency = :'||p_trx_currency_code||':');
1291: arp_standard.debug(' sys currency = :'||arp_standard.sysparm.tax_currency_code||':');
1292: arp_standard.debug(' autotax = :'||p_autotax_flag||':');
1293: arp_standard.debug(' rounding rule = :'||l_rounding_rule||':');
1294: arp_standard.debug(' precision = :'||l_precision||':');

Line 1291: arp_standard.debug(' sys currency = :'||arp_standard.sysparm.tax_currency_code||':');

1287: END IF;
1288:
1289: IF PG_DEBUG = 'Y' THEN
1290: arp_standard.debug(' trx currency = :'||p_trx_currency_code||':');
1291: arp_standard.debug(' sys currency = :'||arp_standard.sysparm.tax_currency_code||':');
1292: arp_standard.debug(' autotax = :'||p_autotax_flag||':');
1293: arp_standard.debug(' rounding rule = :'||l_rounding_rule||':');
1294: arp_standard.debug(' precision = :'||l_precision||':');
1295: arp_standard.debug(' mau = :'||l_min_acct_unit||':');

Line 1292: arp_standard.debug(' autotax = :'||p_autotax_flag||':');

1288:
1289: IF PG_DEBUG = 'Y' THEN
1290: arp_standard.debug(' trx currency = :'||p_trx_currency_code||':');
1291: arp_standard.debug(' sys currency = :'||arp_standard.sysparm.tax_currency_code||':');
1292: arp_standard.debug(' autotax = :'||p_autotax_flag||':');
1293: arp_standard.debug(' rounding rule = :'||l_rounding_rule||':');
1294: arp_standard.debug(' precision = :'||l_precision||':');
1295: arp_standard.debug(' mau = :'||l_min_acct_unit||':');
1296: END IF;

Line 1293: arp_standard.debug(' rounding rule = :'||l_rounding_rule||':');

1289: IF PG_DEBUG = 'Y' THEN
1290: arp_standard.debug(' trx currency = :'||p_trx_currency_code||':');
1291: arp_standard.debug(' sys currency = :'||arp_standard.sysparm.tax_currency_code||':');
1292: arp_standard.debug(' autotax = :'||p_autotax_flag||':');
1293: arp_standard.debug(' rounding rule = :'||l_rounding_rule||':');
1294: arp_standard.debug(' precision = :'||l_precision||':');
1295: arp_standard.debug(' mau = :'||l_min_acct_unit||':');
1296: END IF;
1297:

Line 1294: arp_standard.debug(' precision = :'||l_precision||':');

1290: arp_standard.debug(' trx currency = :'||p_trx_currency_code||':');
1291: arp_standard.debug(' sys currency = :'||arp_standard.sysparm.tax_currency_code||':');
1292: arp_standard.debug(' autotax = :'||p_autotax_flag||':');
1293: arp_standard.debug(' rounding rule = :'||l_rounding_rule||':');
1294: arp_standard.debug(' precision = :'||l_precision||':');
1295: arp_standard.debug(' mau = :'||l_min_acct_unit||':');
1296: END IF;
1297:
1298: IF ( nvl(l_min_acct_unit,0) <> 0 )

Line 1295: arp_standard.debug(' mau = :'||l_min_acct_unit||':');

1291: arp_standard.debug(' sys currency = :'||arp_standard.sysparm.tax_currency_code||':');
1292: arp_standard.debug(' autotax = :'||p_autotax_flag||':');
1293: arp_standard.debug(' rounding rule = :'||l_rounding_rule||':');
1294: arp_standard.debug(' precision = :'||l_precision||':');
1295: arp_standard.debug(' mau = :'||l_min_acct_unit||':');
1296: END IF;
1297:
1298: IF ( nvl(l_min_acct_unit,0) <> 0 )
1299: THEN

Line 1363: arp_standard.debug( 'arp_tax_compound.tax_curr_round('||l_rounded_amount||')-');

1359:
1360: END IF;
1361:
1362: IF PG_DEBUG = 'Y' THEN
1363: arp_standard.debug( 'arp_tax_compound.tax_curr_round('||l_rounded_amount||')-');
1364: END IF;
1365: RETURN (l_rounded_amount);
1366:
1367: EXCEPTION

Line 1369: arp_standard.debug( 'EXCEPTION: arp_tax_compound.tax_curr_round(-)');

1365: RETURN (l_rounded_amount);
1366:
1367: EXCEPTION
1368: WHEN OTHERS THEN
1369: arp_standard.debug( 'EXCEPTION: arp_tax_compound.tax_curr_round(-)');
1370: RAISE;
1371: END tax_curr_round;
1372:
1373: /* init accounting structure */

Line 1703: arp_standard.debug(l_msg_data);

1699:
1700: /* Retrieve and log errors */
1701: IF l_msg_count = 1
1702: THEN
1703: arp_standard.debug(l_msg_data);
1704: p_gt_id := 0;
1705: ELSIF l_msg_count > 1
1706: THEN
1707: LOOP

Line 1714: arp_standard.debug(l_msg);

1710: IF l_msg IS NULL
1711: THEN
1712: EXIT;
1713: ELSE
1714: arp_standard.debug(l_msg);
1715: END IF;
1716: END LOOP;
1717: p_gt_id := 0;
1718: END IF;

Line 1782: arp_standard.debug(l_msg_data);

1778:
1779: /* Retrieve and log errors */
1780: IF l_msg_count = 1
1781: THEN
1782: arp_standard.debug(l_msg_data);
1783: ELSIF l_msg_count > 1
1784: THEN
1785: LOOP
1786: l_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,

Line 1792: arp_standard.debug(l_msg);

1788: IF l_msg IS NULL
1789: THEN
1790: EXIT;
1791: ELSE
1792: arp_standard.debug(l_msg);
1793: END IF;
1794: END LOOP;
1795: END IF;
1796: END IF;

Line 2302: arp_standard.debug('EXCEPTION: unknown mode : ' || p_mode);

2298: and cr.remit_bank_acct_use_id = arm.remit_bank_acct_use_id; --bug6401710
2299:
2300: ELSE
2301: /* Unknown condition, note it in log for debugging */
2302: arp_standard.debug('EXCEPTION: unknown mode : ' || p_mode);
2303: p_prorated_line := p_amount;
2304: p_prorated_tax := 0;
2305: RETURN;
2306: END IF;

Line 2330: arp_standard.debug('historical transaction - flag as non-recoverable');

2326: IF l_historical_flag = 'Y'
2327: THEN
2328: /* Override to nonrecoverable */
2329: IF (PG_DEBUG in ('Y','C')) THEN
2330: arp_standard.debug('historical transaction - flag as non-recoverable');
2331: END IF;
2332: l_recov_flag := 'N';
2333: END IF;
2334:

Line 2337: arp_standard.debug('no lines to process, flag as non-recoverable');

2333: END IF;
2334:
2335: EXCEPTION
2336: WHEN NO_DATA_FOUND THEN
2337: arp_standard.debug('no lines to process, flag as non-recoverable');
2338: l_recov_flag := 'N';
2339: WHEN OTHERS THEN
2340: arp_standard.debug('Unable to determine historical status of trx lines, flagging as non-recoverable');
2341: l_recov_flag := 'N';

Line 2340: arp_standard.debug('Unable to determine historical status of trx lines, flagging as non-recoverable');

2336: WHEN NO_DATA_FOUND THEN
2337: arp_standard.debug('no lines to process, flag as non-recoverable');
2338: l_recov_flag := 'N';
2339: WHEN OTHERS THEN
2340: arp_standard.debug('Unable to determine historical status of trx lines, flagging as non-recoverable');
2341: l_recov_flag := 'N';
2342:
2343: END;
2344:

Line 2357: arp_standard.debug('receivables activity is not recoverable');

2353: p_prorated_line := p_amount;
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;

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 2401: arp_standard.debug('tax-only adjustment so divisor only considers tax');

2397: AND tax_line.link_to_cust_trx_line_id = line.customer_trx_line_id
2398: AND tax_line.line_type = 'TAX';
2399:
2400: IF (PG_DEBUG in ('Y','C')) THEN
2401: arp_standard.debug('tax-only adjustment so divisor only considers tax');
2402: END IF;
2403:
2404: ELSE
2405: /* Both LINE and TAX or discounts that prorate LINE and TAX */

Line 2422: arp_standard.debug('sum (divisor) for proration calc = ' || l_sum);

2418: AND tl.line_type = 'LINE';
2419: END IF;
2420:
2421: IF (PG_DEBUG in ('Y','C')) THEN
2422: arp_standard.debug('sum (divisor) for proration calc = ' || l_sum);
2423: END IF;
2424:
2425: /* Now iterate through the lines and figure the prorated amounts.
2426: Insert them into the ZX structure for processing */

Line 2430: arp_standard.debug('processing trx_line_id ' || c_tl.inv_trx_line_id);

2426: Insert them into the ZX structure for processing */
2427: FOR c_tl in trx_lines(p_target_id, p_target_line_id) LOOP
2428:
2429: IF (PG_DEBUG in ('Y','C')) THEN
2430: arp_standard.debug('processing trx_line_id ' || c_tl.inv_trx_line_id);
2431: arp_standard.debug(' extended_amount = ' || c_tl.line_amt);
2432: arp_standard.debug(' line_recoverable = ' || c_tl.line_recoverable);
2433: arp_standard.debug(' tax_recoverable = ' || c_tl.tax_recoverable);
2434: END IF;

Line 2431: arp_standard.debug(' extended_amount = ' || c_tl.line_amt);

2427: FOR c_tl in trx_lines(p_target_id, p_target_line_id) LOOP
2428:
2429: IF (PG_DEBUG in ('Y','C')) THEN
2430: arp_standard.debug('processing trx_line_id ' || c_tl.inv_trx_line_id);
2431: arp_standard.debug(' extended_amount = ' || c_tl.line_amt);
2432: arp_standard.debug(' line_recoverable = ' || c_tl.line_recoverable);
2433: arp_standard.debug(' tax_recoverable = ' || c_tl.tax_recoverable);
2434: END IF;
2435:

Line 2432: arp_standard.debug(' line_recoverable = ' || c_tl.line_recoverable);

2428:
2429: IF (PG_DEBUG in ('Y','C')) THEN
2430: arp_standard.debug('processing trx_line_id ' || c_tl.inv_trx_line_id);
2431: arp_standard.debug(' extended_amount = ' || c_tl.line_amt);
2432: arp_standard.debug(' line_recoverable = ' || c_tl.line_recoverable);
2433: arp_standard.debug(' tax_recoverable = ' || c_tl.tax_recoverable);
2434: END IF;
2435:
2436: /* calculate the prorated adjustment */

Line 2433: arp_standard.debug(' tax_recoverable = ' || c_tl.tax_recoverable);

2429: IF (PG_DEBUG in ('Y','C')) THEN
2430: arp_standard.debug('processing trx_line_id ' || c_tl.inv_trx_line_id);
2431: arp_standard.debug(' extended_amount = ' || c_tl.line_amt);
2432: arp_standard.debug(' line_recoverable = ' || c_tl.line_recoverable);
2433: arp_standard.debug(' tax_recoverable = ' || c_tl.tax_recoverable);
2434: END IF;
2435:
2436: /* calculate the prorated adjustment */
2437: IF p_mode = 'TAX'

Line 2746: last_updated_by = arp_standard.profile.user_id,

2742:
2743: UPDATE RA_CUSTOMER_TRX_LINES
2744: SET line_recoverable = line_recoverable + l_prorated_line,
2745: tax_recoverable = tax_recoverable + l_prorated_tax,
2746: last_updated_by = arp_standard.profile.user_id,
2747: last_update_date = sysdate
2748: WHERE customer_trx_line_id = c_tax_lines.adjusted_doc_line_id;
2749:
2750: IF PG_DEBUG in ('Y', 'C') THEN

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 3005: arp_standard.debug(' trx_id = ' || p_trx_id);

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;
3009:

Line 3006: arp_standard.debug(' req_id = ' || p_request_id);

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;
3009:
3010: /* Initialize currency info */

Line 3007: arp_standard.debug(' phase = ' || p_phase);

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;
3009:
3010: /* Initialize currency info */
3011: SELECT

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 3126: arp_standard.debug(' trx_id = ' || p_trx_id);

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;
3130:

Line 3127: arp_standard.debug(' req_id = ' || p_request_id);

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;
3130:
3131: IF p_trx_id IS NOT NULL

Line 3128: arp_standard.debug(' phase = ' || p_phase);

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;
3130:
3131: IF p_trx_id IS NOT NULL
3132: THEN

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 3240: arp_standard.debug(' p_subject_id = ' || p_subject_id);

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);
3244: /+ end debug */

Line 3241: arp_standard.debug(' p_gl_date = ' || p_gl_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);
3244: /+ end debug */
3245:

Line 3242: arp_standard.debug(' p_desired = ' || p_desired_account);

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);
3244: /+ end debug */
3245:
3246: /* Process from cache or zx based on subject_table and

Line 3243: arp_standard.debug(' p_subject_tab= ' || p_subject_table);

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);
3244: /+ end debug */
3245:
3246: /* Process from cache or zx based on subject_table and
3247: cached ID */

Line 3367: arp_standard.debug('EXCEPTION: Unknown subject table ' || p_subject_Table);

3363: p_finchrg_non_rec_tax_ccid => l_finchrg_non_rec_tax_ccid,
3364: x_return_status => l_return_status);
3365:
3366: ELSE
3367: arp_standard.debug('EXCEPTION: Unknown subject table ' || p_subject_Table);
3368: RETURN -1;
3369: END IF;
3370:
3371: /* 4917065 - Moved return logic inside IF/ELSE */

Line 3396: arp_standard.debug('EXCEPTION: get_output_tax_ccid returns error');

3392: g_edisc_non_rec_tax_ccid := -1;
3393: g_unedisc_non_rec_tax_ccid := -1;
3394: g_finchrg_non_rec_tax_ccid := -1;
3395:
3396: arp_standard.debug('EXCEPTION: get_output_tax_ccid returns error');
3397: RETURN -1;
3398: END IF;
3399:
3400: END IF;

Line 3403: arp_standard.debug('Returning ccids:');

3399:
3400: END IF;
3401:
3402: /* Debug +/
3403: arp_standard.debug('Returning ccids:');
3404: arp_standard.debug(' tax: ' || g_tax_account_ccid);
3405: arp_standard.debug(' interim: ' || g_interim_tax_ccid);
3406: arp_standard.debug(' adj: ' || g_adj_ccid);
3407: arp_standard.debug(' adj_non_rec: ' || g_adj_non_rec_tax_ccid);

Line 3404: arp_standard.debug(' tax: ' || g_tax_account_ccid);

3400: END IF;
3401:
3402: /* Debug +/
3403: arp_standard.debug('Returning ccids:');
3404: arp_standard.debug(' tax: ' || g_tax_account_ccid);
3405: arp_standard.debug(' interim: ' || g_interim_tax_ccid);
3406: arp_standard.debug(' adj: ' || g_adj_ccid);
3407: arp_standard.debug(' adj_non_rec: ' || g_adj_non_rec_tax_ccid);
3408: arp_standard.debug(' finchrg: ' || g_finchrg_ccid);

Line 3405: arp_standard.debug(' interim: ' || g_interim_tax_ccid);

3401:
3402: /* Debug +/
3403: arp_standard.debug('Returning ccids:');
3404: arp_standard.debug(' tax: ' || g_tax_account_ccid);
3405: arp_standard.debug(' interim: ' || g_interim_tax_ccid);
3406: arp_standard.debug(' adj: ' || g_adj_ccid);
3407: arp_standard.debug(' adj_non_rec: ' || g_adj_non_rec_tax_ccid);
3408: arp_standard.debug(' finchrg: ' || g_finchrg_ccid);
3409: arp_standard.debug(' finchrg_non_rec: ' || g_finchrg_non_rec_tax_ccid);

Line 3406: arp_standard.debug(' adj: ' || g_adj_ccid);

3402: /* Debug +/
3403: arp_standard.debug('Returning ccids:');
3404: arp_standard.debug(' tax: ' || g_tax_account_ccid);
3405: arp_standard.debug(' interim: ' || g_interim_tax_ccid);
3406: arp_standard.debug(' adj: ' || g_adj_ccid);
3407: arp_standard.debug(' adj_non_rec: ' || g_adj_non_rec_tax_ccid);
3408: arp_standard.debug(' finchrg: ' || g_finchrg_ccid);
3409: arp_standard.debug(' finchrg_non_rec: ' || g_finchrg_non_rec_tax_ccid);
3410: arp_standard.debug(' edisc: ' || g_edisc_ccid);

Line 3407: arp_standard.debug(' adj_non_rec: ' || g_adj_non_rec_tax_ccid);

3403: arp_standard.debug('Returning ccids:');
3404: arp_standard.debug(' tax: ' || g_tax_account_ccid);
3405: arp_standard.debug(' interim: ' || g_interim_tax_ccid);
3406: arp_standard.debug(' adj: ' || g_adj_ccid);
3407: arp_standard.debug(' adj_non_rec: ' || g_adj_non_rec_tax_ccid);
3408: arp_standard.debug(' finchrg: ' || g_finchrg_ccid);
3409: arp_standard.debug(' finchrg_non_rec: ' || g_finchrg_non_rec_tax_ccid);
3410: arp_standard.debug(' edisc: ' || g_edisc_ccid);
3411: arp_standard.debug(' unedisc: ' || g_unedisc_ccid);

Line 3408: arp_standard.debug(' finchrg: ' || g_finchrg_ccid);

3404: arp_standard.debug(' tax: ' || g_tax_account_ccid);
3405: arp_standard.debug(' interim: ' || g_interim_tax_ccid);
3406: arp_standard.debug(' adj: ' || g_adj_ccid);
3407: arp_standard.debug(' adj_non_rec: ' || g_adj_non_rec_tax_ccid);
3408: arp_standard.debug(' finchrg: ' || g_finchrg_ccid);
3409: arp_standard.debug(' finchrg_non_rec: ' || g_finchrg_non_rec_tax_ccid);
3410: arp_standard.debug(' edisc: ' || g_edisc_ccid);
3411: arp_standard.debug(' unedisc: ' || g_unedisc_ccid);
3412: arp_standard.debug(' edisc_non_rec: ' || g_edisc_non_rec_tax_ccid);

Line 3409: arp_standard.debug(' finchrg_non_rec: ' || g_finchrg_non_rec_tax_ccid);

3405: arp_standard.debug(' interim: ' || g_interim_tax_ccid);
3406: arp_standard.debug(' adj: ' || g_adj_ccid);
3407: arp_standard.debug(' adj_non_rec: ' || g_adj_non_rec_tax_ccid);
3408: arp_standard.debug(' finchrg: ' || g_finchrg_ccid);
3409: arp_standard.debug(' finchrg_non_rec: ' || g_finchrg_non_rec_tax_ccid);
3410: arp_standard.debug(' edisc: ' || g_edisc_ccid);
3411: arp_standard.debug(' unedisc: ' || g_unedisc_ccid);
3412: arp_standard.debug(' edisc_non_rec: ' || g_edisc_non_rec_tax_ccid);
3413: arp_standard.debug(' unedisc_non_rec: ' || g_unedisc_non_rec_tax_ccid);

Line 3410: arp_standard.debug(' edisc: ' || g_edisc_ccid);

3406: arp_standard.debug(' adj: ' || g_adj_ccid);
3407: arp_standard.debug(' adj_non_rec: ' || g_adj_non_rec_tax_ccid);
3408: arp_standard.debug(' finchrg: ' || g_finchrg_ccid);
3409: arp_standard.debug(' finchrg_non_rec: ' || g_finchrg_non_rec_tax_ccid);
3410: arp_standard.debug(' edisc: ' || g_edisc_ccid);
3411: arp_standard.debug(' unedisc: ' || g_unedisc_ccid);
3412: arp_standard.debug(' edisc_non_rec: ' || g_edisc_non_rec_tax_ccid);
3413: arp_standard.debug(' unedisc_non_rec: ' || g_unedisc_non_rec_tax_ccid);
3414: /+ End debug */

Line 3411: arp_standard.debug(' unedisc: ' || g_unedisc_ccid);

3407: arp_standard.debug(' adj_non_rec: ' || g_adj_non_rec_tax_ccid);
3408: arp_standard.debug(' finchrg: ' || g_finchrg_ccid);
3409: arp_standard.debug(' finchrg_non_rec: ' || g_finchrg_non_rec_tax_ccid);
3410: arp_standard.debug(' edisc: ' || g_edisc_ccid);
3411: arp_standard.debug(' unedisc: ' || g_unedisc_ccid);
3412: arp_standard.debug(' edisc_non_rec: ' || g_edisc_non_rec_tax_ccid);
3413: arp_standard.debug(' unedisc_non_rec: ' || g_unedisc_non_rec_tax_ccid);
3414: /+ End debug */
3415:

Line 3412: arp_standard.debug(' edisc_non_rec: ' || g_edisc_non_rec_tax_ccid);

3408: arp_standard.debug(' finchrg: ' || g_finchrg_ccid);
3409: arp_standard.debug(' finchrg_non_rec: ' || g_finchrg_non_rec_tax_ccid);
3410: arp_standard.debug(' edisc: ' || g_edisc_ccid);
3411: arp_standard.debug(' unedisc: ' || g_unedisc_ccid);
3412: arp_standard.debug(' edisc_non_rec: ' || g_edisc_non_rec_tax_ccid);
3413: arp_standard.debug(' unedisc_non_rec: ' || g_unedisc_non_rec_tax_ccid);
3414: /+ End debug */
3415:
3416: /* Now return a value */

Line 3413: arp_standard.debug(' unedisc_non_rec: ' || g_unedisc_non_rec_tax_ccid);

3409: arp_standard.debug(' finchrg_non_rec: ' || g_finchrg_non_rec_tax_ccid);
3410: arp_standard.debug(' edisc: ' || g_edisc_ccid);
3411: arp_standard.debug(' unedisc: ' || g_unedisc_ccid);
3412: arp_standard.debug(' edisc_non_rec: ' || g_edisc_non_rec_tax_ccid);
3413: arp_standard.debug(' unedisc_non_rec: ' || g_unedisc_non_rec_tax_ccid);
3414: /+ End debug */
3415:
3416: /* Now return a value */
3417: IF p_desired_account = 'TAX'

Line 3449: arp_standard.debug('EXCEPTION: Invalid desired account = ' || p_desired_account);

3445: THEN
3446: RETURN g_unedisc_non_rec_tax_ccid;
3447: ELSE
3448: /* no idea what they want */
3449: arp_standard.debug('EXCEPTION: Invalid desired account = ' || p_desired_account);
3450: RETURN -1;
3451: END IF;
3452:
3453: END get_tax_account;

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 3503: arp_standard.debug(' p_amt = ' || p_amt);

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);
3507: arp_standard.debug(' p_mode = ' || p_mode);

Line 3504: arp_standard.debug(' p_receipt_id = ' || p_receipt_id);

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);
3507: arp_standard.debug(' p_mode = ' || p_mode);
3508: arp_standard.debug(' p_rule_set_id = ' || p_rule_set_id);

Line 3505: arp_standard.debug(' p_apply_date = ' || p_apply_date);

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);
3507: arp_standard.debug(' p_mode = ' || p_mode);
3508: arp_standard.debug(' p_rule_set_id = ' || p_rule_set_id);
3509: arp_standard.debug(' p_currency = ' || p_currency);

Line 3506: arp_standard.debug(' p_trx_id = ' || p_trx_id);

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);
3507: arp_standard.debug(' p_mode = ' || p_mode);
3508: arp_standard.debug(' p_rule_set_id = ' || p_rule_set_id);
3509: arp_standard.debug(' p_currency = ' || p_currency);
3510: arp_standard.debug(' p_line_remaining = ' || p_line_remaining);

Line 3507: arp_standard.debug(' p_mode = ' || p_mode);

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);
3507: arp_standard.debug(' p_mode = ' || p_mode);
3508: arp_standard.debug(' p_rule_set_id = ' || p_rule_set_id);
3509: arp_standard.debug(' p_currency = ' || p_currency);
3510: arp_standard.debug(' p_line_remaining = ' || p_line_remaining);
3511: arp_standard.debug(' p_line_tax_remaining = ' || p_line_tax_remaining);

Line 3508: arp_standard.debug(' p_rule_set_id = ' || p_rule_set_id);

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);
3507: arp_standard.debug(' p_mode = ' || p_mode);
3508: arp_standard.debug(' p_rule_set_id = ' || p_rule_set_id);
3509: arp_standard.debug(' p_currency = ' || p_currency);
3510: arp_standard.debug(' p_line_remaining = ' || p_line_remaining);
3511: arp_standard.debug(' p_line_tax_remaining = ' || p_line_tax_remaining);
3512: arp_standard.debug(' p_rec_app_id = ' || p_rec_app_id);

Line 3509: arp_standard.debug(' p_currency = ' || p_currency);

3505: arp_standard.debug(' p_apply_date = ' || p_apply_date);
3506: arp_standard.debug(' p_trx_id = ' || p_trx_id);
3507: arp_standard.debug(' p_mode = ' || p_mode);
3508: arp_standard.debug(' p_rule_set_id = ' || p_rule_set_id);
3509: arp_standard.debug(' p_currency = ' || p_currency);
3510: arp_standard.debug(' p_line_remaining = ' || p_line_remaining);
3511: arp_standard.debug(' p_line_tax_remaining = ' || p_line_tax_remaining);
3512: arp_standard.debug(' p_rec_app_id = ' || p_rec_app_id);
3513: END IF;

Line 3510: arp_standard.debug(' p_line_remaining = ' || p_line_remaining);

3506: arp_standard.debug(' p_trx_id = ' || p_trx_id);
3507: arp_standard.debug(' p_mode = ' || p_mode);
3508: arp_standard.debug(' p_rule_set_id = ' || p_rule_set_id);
3509: arp_standard.debug(' p_currency = ' || p_currency);
3510: arp_standard.debug(' p_line_remaining = ' || p_line_remaining);
3511: arp_standard.debug(' p_line_tax_remaining = ' || p_line_tax_remaining);
3512: arp_standard.debug(' p_rec_app_id = ' || p_rec_app_id);
3513: END IF;
3514: IF p_receipt_id IS NOT NULL

Line 3511: arp_standard.debug(' p_line_tax_remaining = ' || p_line_tax_remaining);

3507: arp_standard.debug(' p_mode = ' || p_mode);
3508: arp_standard.debug(' p_rule_set_id = ' || p_rule_set_id);
3509: arp_standard.debug(' p_currency = ' || p_currency);
3510: arp_standard.debug(' p_line_remaining = ' || p_line_remaining);
3511: arp_standard.debug(' p_line_tax_remaining = ' || p_line_tax_remaining);
3512: arp_standard.debug(' p_rec_app_id = ' || p_rec_app_id);
3513: END IF;
3514: IF p_receipt_id IS NOT NULL
3515: THEN

Line 3512: arp_standard.debug(' p_rec_app_id = ' || p_rec_app_id);

3508: arp_standard.debug(' p_rule_set_id = ' || p_rule_set_id);
3509: arp_standard.debug(' p_currency = ' || p_currency);
3510: arp_standard.debug(' p_line_remaining = ' || p_line_remaining);
3511: arp_standard.debug(' p_line_tax_remaining = ' || p_line_tax_remaining);
3512: arp_standard.debug(' p_rec_app_id = ' || p_rec_app_id);
3513: END IF;
3514: IF p_receipt_id IS NOT NULL
3515: THEN
3516:

Line 3554: arp_standard.debug(' returned from arp_app_calc_pkg.calc_applied_and_remaining');

3550: p_charges_applied);
3551:
3552: IF PG_DEBUG in ('Y', 'C')
3553: THEN
3554: arp_standard.debug(' returned from arp_app_calc_pkg.calc_applied_and_remaining');
3555: END IF;
3556:
3557: IF l_tax_recov = 'Y'
3558: THEN

Line 3561: arp_standard.debug(' tax is recoverable ');

3557: IF l_tax_recov = 'Y'
3558: THEN
3559: IF PG_DEBUG in ('Y', 'C')
3560: THEN
3561: arp_standard.debug(' tax is recoverable ');
3562: END IF;
3563: /* Deduction activity is recoverable. Put the
3564: original tax amount back into the line bucket
3565: and call etax to prorate it */

Line 3593: arp_standard.debug(' g_gt_id = ' || g_gt_id);

3589: p_rec_app_id);
3590:
3591: IF PG_DEBUG in ('Y', 'C')
3592: THEN
3593: arp_standard.debug(' g_gt_id = ' || g_gt_id);
3594: arp_standard.debug(' p_rec_app_id = ' || p_rec_app_id);
3595: END IF;
3596:
3597: IF nvl(g_gt_id,0) <> 0

Line 3594: arp_standard.debug(' p_rec_app_id = ' || p_rec_app_id);

3590:
3591: IF PG_DEBUG in ('Y', 'C')
3592: THEN
3593: arp_standard.debug(' g_gt_id = ' || g_gt_id);
3594: arp_standard.debug(' p_rec_app_id = ' || p_rec_app_id);
3595: END IF;
3596:
3597: IF nvl(g_gt_id,0) <> 0
3598: THEN

Line 3606: arp_standard.debug(' tax now prorated ');

3602: p_line_tax_remaining := p_line_tax_remaining - p_line_tax_applied;
3603:
3604: IF PG_DEBUG in ('Y', 'C')
3605: THEN
3606: arp_standard.debug(' tax now prorated ');
3607: arp_standard.debug(' line_applied (post etax) = ' ||
3608: l_line_applied);
3609: arp_standard.debug(' tax_applied (post etax) = ' ||
3610: l_line_tax_applied);

Line 3607: arp_standard.debug(' line_applied (post etax) = ' ||

3603:
3604: IF PG_DEBUG in ('Y', 'C')
3605: THEN
3606: arp_standard.debug(' tax now prorated ');
3607: arp_standard.debug(' line_applied (post etax) = ' ||
3608: l_line_applied);
3609: arp_standard.debug(' tax_applied (post etax) = ' ||
3610: l_line_tax_applied);
3611: arp_standard.debug(' line_remaining = ' || p_line_remaining);

Line 3609: arp_standard.debug(' tax_applied (post etax) = ' ||

3605: THEN
3606: arp_standard.debug(' tax now prorated ');
3607: arp_standard.debug(' line_applied (post etax) = ' ||
3608: l_line_applied);
3609: arp_standard.debug(' tax_applied (post etax) = ' ||
3610: l_line_tax_applied);
3611: arp_standard.debug(' line_remaining = ' || p_line_remaining);
3612: arp_standard.debug(' tax_remaining = ' ||
3613: p_line_tax_remaining);

Line 3611: arp_standard.debug(' line_remaining = ' || p_line_remaining);

3607: arp_standard.debug(' line_applied (post etax) = ' ||
3608: l_line_applied);
3609: arp_standard.debug(' tax_applied (post etax) = ' ||
3610: l_line_tax_applied);
3611: arp_standard.debug(' line_remaining = ' || p_line_remaining);
3612: arp_standard.debug(' tax_remaining = ' ||
3613: p_line_tax_remaining);
3614: END IF;
3615: END IF;

Line 3612: arp_standard.debug(' tax_remaining = ' ||

3608: l_line_applied);
3609: arp_standard.debug(' tax_applied (post etax) = ' ||
3610: l_line_tax_applied);
3611: arp_standard.debug(' line_remaining = ' || p_line_remaining);
3612: arp_standard.debug(' tax_remaining = ' ||
3613: p_line_tax_remaining);
3614: END IF;
3615: END IF;
3616: ELSE

Line 3619: arp_standard.debug(' Non-recoverable activity (' || l_rec_act_id ||

3615: END IF;
3616: ELSE
3617: IF PG_DEBUG in ('Y', 'C')
3618: THEN
3619: arp_standard.debug(' Non-recoverable activity (' || l_rec_act_id ||
3620: ') etax skipped');
3621: END IF;
3622:
3623: END IF;

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