DBA Data[Home] [Help]

APPS.ZX_TDS_CALC_SERVICES_PUB_PKG dependencies on ZX_TDS_APPLICABILITY_DETM_PKG

Line 171: ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes (

167: -- use direct rate determination process to obtain the candidate taxes.
168:
169: IF l_template_usage_code = 'TAX_REGIME_DETERMINATION'
170: THEN
171: ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes (
172: p_trx_line_index,
173: p_event_class_rec,
174: x_return_status );
175: END IF;

Line 185: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes()');

181: IF (g_level_error >= g_current_runtime_level ) THEN
182: FND_LOG.STRING(g_level_error,
183: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.get_tax_regimes',
184: 'Incorrect return_status after calling ' ||
185: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes()');
186: FND_LOG.STRING(g_level_error,
187: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.get_tax_regimes',
188: 'RETURN_STATUS = ' || x_return_status);
189: FND_LOG.STRING(g_level_error,

Line 416: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date(

412: --
413: IF( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
414: p_trx_line_index) <> 'OVERRIDE_TAX') THEN
415:
416: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date(
417: p_trx_line_index,
418: l_tax_date,
419: l_tax_determine_date,
420: l_tax_point_date,

Line 428: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date()');

424: IF (g_level_error >= g_current_runtime_level ) THEN
425: FND_LOG.STRING(g_level_error,
426: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
427: 'Incorrect return_status after calling ' ||
428: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date()');
429: FND_LOG.STRING(g_level_error,
430: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
431: 'RETURN_STATUS = ' || x_return_status);
432: FND_LOG.STRING(g_level_error,

Line 495: ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(

491: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
492: p_trx_line_index) = 'OVERRIDE_TAX'
493: THEN
494:
495: ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(
496: p_event_class_rec,
497: p_trx_line_index,
498: NULL,
499: NULL,

Line 511: 'ZX_TDS_APPLICABILITY_DETM_PKG.');

507: IF (g_level_statement >= g_current_runtime_level ) THEN
508: FND_LOG.STRING(g_level_statement,
509: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
510: 'Incorrect return_status after calling ' ||
511: 'ZX_TDS_APPLICABILITY_DETM_PKG.');
512: FND_LOG.STRING(g_level_statement,
513: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
514: 'RETURN_STATUS = ' || x_return_status);
515: FND_LOG.STRING(g_level_statement,

Line 525: -- transaction on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines

521:
522: -- When no tax line found for the historical transaction, check if the trx line
523: -- exists in zx_lines_det_factors. If yes, it means the historical transaction
524: -- was migrated, but don't have tax. Otherwise, migrate the historical
525: -- transaction on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines
526: -- again to fetch the tax lines for the historical transaction.
527:
528: IF ((l_begin_index IS NULL) OR (l_begin_index = l_end_index)) AND
529: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag(p_trx_line_index) = 'Y' THEN

Line 572: ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(

568: RETURN;
569: END IF;
570:
571: -- after migrate the trx on the fly, fetch tax lines for historical trx again.
572: ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(
573: p_event_class_rec,
574: p_trx_line_index,
575: NULL,
576: NULL,

Line 588: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines');

584: IF (g_level_statement >= g_current_runtime_level ) THEN
585: FND_LOG.STRING(g_level_statement,
586: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
587: 'Incorrect return_status after calling ' ||
588: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines');
589: FND_LOG.STRING(g_level_statement,
590: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
591: 'RETURN_STATUS = ' || x_return_status);
592: FND_LOG.STRING(g_level_statement,

Line 605: ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust(

601:
602: ELSIF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
603: p_trx_line_index) IS NOT NULL ) THEN
604:
605: ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust(
606: p_event_class_rec,
607: p_trx_line_index,
608: l_tax_date,
609: l_tax_determine_date,

Line 620: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust');

616: IF (g_level_statement >= g_current_runtime_level ) THEN
617: FND_LOG.STRING(g_level_statement,
618: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
619: 'Incorrect return_status after calling ' ||
620: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust');
621: FND_LOG.STRING(g_level_statement,
622: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
623: 'RETURN_STATUS = ' || x_return_status);
624: FND_LOG.STRING(g_level_statement,

Line 635: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust

631: -- bug fix 4642405 : handle on the fly migration
632: -- When no tax line found for the adjusted doc, check if the trx line
633: -- exists in zx_lines_det_factors. If yes, it means the adjusted doc was
634: -- migrated, but don't have tax. Otherwise, migrate the adjusted doc
635: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust
636: -- again to fetch the tax lines for the adjusted doc.
637:
638: IF (l_begin_index IS NULL) OR (l_begin_index = l_end_index) THEN
639:

Line 687: ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust(

683: RETURN;
684: END IF;
685:
686: -- after migrate the trx on the fly, fetch tax lines for applied_from doc again.
687: ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust(
688: p_event_class_rec,
689: p_trx_line_index,
690: l_tax_date,
691: l_tax_determine_date,

Line 703: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust');

699: IF (g_level_statement >= g_current_runtime_level ) THEN
700: FND_LOG.STRING(g_level_statement,
701: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
702: 'Incorrect return_status after calling ' ||
703: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust');
704: FND_LOG.STRING(g_level_statement,
705: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
706: 'RETURN_STATUS = ' || x_return_status);
707: FND_LOG.STRING(g_level_statement,

Line 721: ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied(

717: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
718: p_trx_line_index) IS NOT NULL
719: THEN
720:
721: ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied(
722: p_event_class_rec,
723: p_trx_line_index,
724: l_tax_date,
725: l_tax_determine_date,

Line 737: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied');

733: IF (g_level_statement >= g_current_runtime_level ) THEN
734: FND_LOG.STRING(g_level_statement,
735: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
736: 'Incorrect return_status after calling ' ||
737: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied');
738: FND_LOG.STRING(g_level_statement,
739: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
740: 'RETURN_STATUS = ' || x_return_status);
741: FND_LOG.STRING(g_level_statement,

Line 752: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied

748: -- bug fix 4642405 : handle on the fly migration
749: -- When no tax line found for the applied_from doc, check if the trx line
750: -- exists in zx_lines_det_factors. If yes, it means the applied_from doc was
751: -- migrated, but don't have tax. Otherwise, migrate the applied_from doc
752: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied
753: -- again to fetch the tax lines for the applied_from doc.
754:
755: IF (l_begin_index IS NULL) OR (l_begin_index = l_end_index) THEN
756:

Line 804: ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied(

800: RETURN;
801: END IF;
802:
803: -- after migrate the trx on the fly, fetch tax lines for applied_from doc again.
804: ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied(
805: p_event_class_rec,
806: p_trx_line_index,
807: l_tax_date,
808: l_tax_determine_date,

Line 820: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied');

816: IF (g_level_statement >= g_current_runtime_level ) THEN
817: FND_LOG.STRING(g_level_statement,
818: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
819: 'Incorrect return_status after calling ' ||
820: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied');
821: FND_LOG.STRING(g_level_statement,
822: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
823: 'RETURN_STATUS = ' || x_return_status);
824: FND_LOG.STRING(g_level_statement,

Line 855: ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(

851: p_trx_line_index) <> 'INTERCOMPANY_TRX' OR
852: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(
853: p_trx_line_index) IS NULL) THEN -- Bug 5291394
854:
855: ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(
856: p_event_class_rec,
857: p_trx_line_index,
858: l_tax_date,
859: l_tax_determine_date,

Line 870: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines');

866: IF (g_level_statement >= g_current_runtime_level ) THEN
867: FND_LOG.STRING(g_level_statement,
868: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
869: 'Incorrect return_status after calling ' ||
870: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines');
871: FND_LOG.STRING(g_level_statement,
872: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
873: 'RETURN_STATUS = ' || x_return_status);
874: FND_LOG.STRING(g_level_statement,

Line 885: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines

881: -- bug fix 4642405 : handle on the fly migration
882: -- When no tax line found for docto be updated, check if the trx line
883: -- exists in zx_lines_det_factors. If yes, it means current doc was
884: -- migrated, but don't have tax. Otherwise, migrate current doc
885: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines
886: -- again to fetch the tax lines for current doc.
887:
888: IF (l_begin_index IS NULL) OR (l_begin_index = l_end_index) THEN
889:

Line 937: ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(

933: RETURN;
934: END IF;
935:
936: -- after migrate the trx on the fly, fetch tax lines for applied_from doc again.
937: ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(
938: p_event_class_rec,
939: p_trx_line_index,
940: l_tax_date,
941: l_tax_determine_date,

Line 953: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines');

949: IF (g_level_statement >= g_current_runtime_level ) THEN
950: FND_LOG.STRING(g_level_statement,
951: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
952: 'Incorrect return_status after calling ' ||
953: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines');
954: FND_LOG.STRING(g_level_statement,
955: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
956: 'RETURN_STATUS = ' || x_return_status);
957: FND_LOG.STRING(g_level_statement,

Line 976: ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(

972: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(
973: p_trx_line_index) IS NOT NULL
974: THEN
975:
976: ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(
977: p_event_class_rec,
978: p_trx_line_index,
979: l_tax_date,
980: l_tax_determine_date,

Line 991: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx');

987: IF (g_level_statement >= g_current_runtime_level ) THEN
988: FND_LOG.STRING(g_level_statement,
989: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
990: 'Incorrect return_status after calling ' ||
991: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx');
992: FND_LOG.STRING(g_level_statement,
993: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
994: 'RETURN_STATUS = ' || x_return_status);
995: FND_LOG.STRING(g_level_statement,

Line 1006: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines

1002: -- bug fix 4653504 : handle on the fly migration
1003: -- When no tax line found for doc to be updated, check if the trx line
1004: -- exists in zx_lines_det_factors. If yes, it means current doc was
1005: -- migrated, but don't have tax. Otherwise, migrate current doc
1006: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines
1007: -- again to fetch the tax lines for current doc.
1008:
1009: IF ((l_begin_index IS NULL) OR (l_begin_index = l_end_index) ) THEN
1010:

Line 1121: ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(

1117: RETURN;
1118: END IF;
1119:
1120: -- after migrate the trx on the fly, fetch tax lines for applied_from doc again.
1121: ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(
1122: p_event_class_rec,
1123: p_trx_line_index,
1124: l_tax_date,
1125: l_tax_determine_date,

Line 1136: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx');

1132: IF (g_level_statement >= g_current_runtime_level ) THEN
1133: FND_LOG.STRING(g_level_statement,
1134: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1135: 'Incorrect return_status after calling ' ||
1136: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx');
1137: FND_LOG.STRING(g_level_statement,
1138: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1139: 'RETURN_STATUS = ' || x_return_status);
1140: FND_LOG.STRING(g_level_statement,

Line 1185: ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results(p_trx_line_index,

1181:
1182: -- The direct rate determination is coded in the applicability pkg
1183: -- in order to reuse some of the existing logic there.
1184: --
1185: ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results(p_trx_line_index,
1186: l_tax_date,
1187: l_tax_determine_date,
1188: l_tax_point_date,
1189: p_event_class_rec,

Line 1199: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results()');

1195: IF (g_level_error >= g_current_runtime_level ) THEN
1196: FND_LOG.STRING(g_level_error,
1197: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1198: 'Incorrect return_status after calling ' ||
1199: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results()');
1200: FND_LOG.STRING(g_level_error,
1201: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1202: 'RETURN_STATUS = ' || x_return_status);
1203: FND_LOG.STRING(g_level_error,

Line 1231: ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes (

1227: IF (l_provider_id IS NULL) THEN
1228:
1229: -- If l_provider_id is null, this tax needs to be processed
1230: --
1231: ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes (
1232: l_tax_regime_id,
1233: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(
1234: l_tax_regime_id).tax_regime_code,
1235: p_trx_line_index,

Line 1250: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes()');

1246: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1247: FND_LOG.STRING(G_LEVEL_STATEMENT,
1248: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1249: 'Incorrect return_status after calling ' ||
1250: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes()');
1251: FND_LOG.STRING(G_LEVEL_STATEMENT,
1252: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1253: 'ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(-)');
1254: END IF;

Line 1270: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(

1266: IF p_event_class_rec.enforce_tax_from_acct_flag = 'Y' AND
1267: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index) > 0
1268: THEN
1269:
1270: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(
1271: p_event_class_rec,
1272: p_trx_line_index,
1273: l_tax_date,
1274: l_tax_determine_date,

Line 1285: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account');

1281: IF (g_level_statement >= g_current_runtime_level ) THEN
1282: FND_LOG.STRING(g_level_statement,
1283: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1284: 'Incorrect return_status after calling ' ||
1285: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account');
1286: FND_LOG.STRING(g_level_statement,
1287: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1288: 'RETURN_STATUS = ' || x_return_status);
1289: FND_LOG.STRING(g_level_statement,

Line 2116: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date( p_trx_line_index,

2112: IF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
2113: p_trx_line_index) = 'CREATE') THEN
2114: -- get tax dates
2115: --
2116: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date( p_trx_line_index,
2117: l_tax_date,
2118: l_tax_determine_date,
2119: l_tax_point_date,
2120: x_return_status );

Line 2127: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date()');

2123: IF (g_level_error >= g_current_runtime_level ) THEN
2124: FND_LOG.STRING(g_level_error,
2125: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax_for_import',
2126: 'Incorrect return_status after calling ' ||
2127: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date()');
2128: FND_LOG.STRING(g_level_error,
2129: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax_for_import',
2130: 'RETURN_STATUS = ' || x_return_status);
2131: FND_LOG.STRING(g_level_error,