eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TDS_TAXABLE_BASIS_DETM_PKG dependencies on FND_LOG

Line 5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

1: PACKAGE BODY ZX_TDS_TAXABLE_BASIS_DETM_PKG AS
2: /* $Header: zxditxbsisdtpkgb.pls 120.80.12010000.3 2008/11/26 02:07:28 tsen ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
9:

Line 6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

2: /* $Header: zxditxbsisdtpkgb.pls 120.80.12010000.3 2008/11/26 02:07:28 tsen ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
9:
10: PROCEDURE populate_inclusive_tax_flag (

Line 7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
9:
10: PROCEDURE populate_inclusive_tax_flag (
11: p_tax_line_index IN NUMBER,

Line 8: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
9:
10: PROCEDURE populate_inclusive_tax_flag (
11: p_tax_line_index IN NUMBER,
12: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

Line 154: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

150: WHERE tax_rate_id = c_tax_rate_id;
151:
152: BEGIN
153:
154: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
155:
156: IF (g_level_procedure >= g_current_runtime_level ) THEN
157: FND_LOG.STRING(g_level_procedure,
158: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.BEGIN',

Line 157: FND_LOG.STRING(g_level_procedure,

153:
154: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
155:
156: IF (g_level_procedure >= g_current_runtime_level ) THEN
157: FND_LOG.STRING(g_level_procedure,
158: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.BEGIN',
159: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (+)');
160: END IF;
161:

Line 169: FND_LOG.STRING(g_level_procedure,

165: p_structure_index) IS NOT NULL THEN
166:
167: IF (g_level_procedure >= g_current_runtime_level ) THEN
168:
169: FND_LOG.STRING(g_level_procedure,
170: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
171: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)'||' skip processing for credit memo');
172: END IF;
173: RETURN;

Line 190: FND_LOG.STRING(g_level_procedure,

186:
187: p_return_status:= FND_API.G_RET_STS_ERROR;
188: IF (g_level_procedure >= g_current_runtime_level ) THEN
189:
190: FND_LOG.STRING(g_level_procedure,
191: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
192: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)'||' Error: begin index or end index is null');
193: END IF;
194: RETURN;

Line 259: FND_LOG.STRING(g_level_statement,

255: p_error_buffer => p_error_buffer);
256:
257: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
258: IF (g_level_statement>= g_current_runtime_level ) THEN
259: FND_LOG.STRING(g_level_statement,
260: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
261: 'Incorrect return_status after calling ' ||
262: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag');
263: FND_LOG.STRING(g_level_statement,

Line 263: FND_LOG.STRING(g_level_statement,

259: FND_LOG.STRING(g_level_statement,
260: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
261: 'Incorrect return_status after calling ' ||
262: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag');
263: FND_LOG.STRING(g_level_statement,
264: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
265: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');
266: END IF;
267: RETURN;

Line 350: FND_LOG.STRING(g_level_statement,

346: + parameter_tbl(l_tax_id).composite_incl_indicator *
347: parameter_tbl(l_tax_id).overrideconst;
348:
349: IF (g_level_statement >= g_current_runtime_level ) THEN
350: FND_LOG.STRING(g_level_statement,
351: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
352: ' sum_basiscoef: ' || l_sum_basiscoef||
353: ' sum_constcoef: ' || l_sum_constcoef);
354: END IF;

Line 467: FND_LOG.STRING(g_level_statement,

463:
464: if l_zx_result_rec.alphanumeric_result is not null then
465: l_formula_code:= l_zx_result_rec.alphanumeric_result;
466: IF (g_level_statement >= g_current_runtime_level ) THEN
467: FND_LOG.STRING(g_level_statement,
468: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
469: 'Get Formula code from rule_base_process '|| l_formula_code);
470: END IF;
471:

Line 490: FND_LOG.STRING(g_level_statement,

486:
487: IF l_formula_from_rate IS NOT NULL THEN
488: l_formula_code:= l_formula_from_rate;
489: IF (g_level_statement >= g_current_runtime_level ) THEN
490: FND_LOG.STRING(g_level_statement,
491: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
492: 'Get Formula code from tax rate '||l_formula_code);
493: END IF;
494: ELSE

Line 497: FND_LOG.STRING(g_level_statement,

493: END IF;
494: ELSE
495: l_formula_code:= l_def_formula;
496: IF (g_level_statement >= g_current_runtime_level ) THEN
497: FND_LOG.STRING(g_level_statement,
498: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
499: 'Get Default Formula code from tax '||l_formula_code);
500: END IF;
501: END IF;

Line 528: FND_LOG.STRING(g_level_statement,

524:
525: IF l_formula_from_rate IS NOT NULL THEN
526: l_formula_code := l_formula_from_rate;
527: IF (g_level_statement >= g_current_runtime_level ) THEN
528: FND_LOG.STRING(g_level_statement,
529: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
530: 'Get Formula code from tax rate '|| l_formula_code);
531: END IF;
532: ELSE

Line 535: FND_LOG.STRING(g_level_statement,

531: END IF;
532: ELSE
533: l_formula_code:= l_def_formula;
534: IF (g_level_statement >= g_current_runtime_level ) THEN
535: FND_LOG.STRING(g_level_statement,
536: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
537: 'Get Default Formula code from tax '|| l_formula_code);
538: END IF;
539: END IF;

Line 546: FND_LOG.STRING(g_level_error ,

542: IF l_formula_code IS NULL THEN
543: p_return_status := FND_API.G_RET_STS_ERROR;
544: IF (g_level_error >= g_current_runtime_level ) THEN
545:
546: FND_LOG.STRING(g_level_error ,
547: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
548: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)'||' error: can not determine formula code');
549: END IF;
550: RETURN;

Line 579: FND_LOG.STRING(g_level_statement,

575: parameter_tbl(l_tax_id).incl_indicator:= 0;
576: END IF;
577:
578: IF (g_level_statement >= g_current_runtime_level ) THEN
579: FND_LOG.STRING(g_level_statement,
580: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
581: 'parameter_tbl( ' || l_tax_id || ' ).incl_indicator:= ' ||
582: parameter_tbl(l_tax_id).incl_indicator||
583: 'weird_indicator:= ' ||

Line 626: FND_LOG.STRING(g_level_error ,

622: ZX_API_PUB.add_msg(
623: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
624:
625: IF (g_level_error >= g_current_runtime_level ) THEN
626: FND_LOG.STRING(g_level_error ,
627: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
628: 'Taxable basis type and tax Rate Type do not match ');
629: FND_LOG.STRING(g_level_error,
630: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

Line 629: FND_LOG.STRING(g_level_error,

625: IF (g_level_error >= g_current_runtime_level ) THEN
626: FND_LOG.STRING(g_level_error ,
627: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
628: 'Taxable basis type and tax Rate Type do not match ');
629: FND_LOG.STRING(g_level_error,
630: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
631: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');
632: END IF;
633:

Line 680: FND_LOG.STRING(g_level_error,

676: if getFormulaInfoH%notfound then
677:
678: p_return_status:= FND_API.G_RET_STS_ERROR;
679: IF (g_level_error >= g_current_runtime_level ) THEN
680: FND_LOG.STRING(g_level_error,
681: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
682: 'Formula Info not found for formula code ' || l_formula_code );
683: FND_LOG.STRING(g_level_error,
684: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

Line 683: FND_LOG.STRING(g_level_error,

679: IF (g_level_error >= g_current_runtime_level ) THEN
680: FND_LOG.STRING(g_level_error,
681: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
682: 'Formula Info not found for formula code ' || l_formula_code );
683: FND_LOG.STRING(g_level_error,
684: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
685: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');
686: END IF;
687:

Line 694: FND_LOG.STRING(g_level_statement,

690: close getFormulaInfoH;
691:
692: IF (g_level_statement >= g_current_runtime_level ) THEN
693:
694: FND_LOG.STRING(g_level_statement,
695: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
696: 'Taxable Basis Type: '|| l_Taxable_Basis_Type_Code||' base rate modifier: '||l_BASE_RATE_MODIFIER||
697: 'Cash_Discount_Appl_Flag: '||l_Cash_Discount_Appl_Flag||' Volume_Discount_Appl_Flag: '||l_Volume_Discount_Appl_Flag||
698: ' Trading_Discount_Appl_Flag: '||l_Trading_Discount_Appl_Flag||' Transfer_Charge_Appl_Flag: '||

Line 737: FND_LOG.STRING(g_level_error ,

733: ZX_API_PUB.add_msg(
734: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
735:
736: IF (g_level_error >= g_current_runtime_level ) THEN
737: FND_LOG.STRING(g_level_error ,
738: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
739: 'Taxable basis type for Formula Code '||l_formula_code||
740: ' and tax Rate Type QUANTITY do not match ');
741: FND_LOG.STRING(g_level_error ,

Line 741: FND_LOG.STRING(g_level_error ,

737: FND_LOG.STRING(g_level_error ,
738: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
739: 'Taxable basis type for Formula Code '||l_formula_code||
740: ' and tax Rate Type QUANTITY do not match ');
741: FND_LOG.STRING(g_level_error ,
742: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
743: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');
744: END IF;
745: RETURN;

Line 805: FND_LOG.STRING(g_level_statement,

801:
802: end if;
803:
804: IF (g_level_statement >= g_current_runtime_level ) THEN
805: FND_LOG.STRING(g_level_statement,
806: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
807: 'Total discount or charge: '||
808: nvl(l_discount_amt,0));
809: END IF;

Line 837: FND_LOG.STRING(g_level_statement,

833: parameter_tbl(l_tax_id).discount;
834:
835: parameter_tbl(l_tax_id).overrideconst:= 0;
836: IF (g_level_statement >= g_current_runtime_level ) THEN
837: FND_LOG.STRING(g_level_statement,
838: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
839: 'basiscoef: ' ||parameter_tbl(l_tax_id).basiscoef ||' constcoef: ' ||
840: parameter_tbl(l_tax_id).constcoef);
841: END IF;

Line 846: FND_LOG.STRING(g_level_error ,

842:
843: if l_formula_id is null then
844: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
845: IF (g_level_error >= g_current_runtime_level ) THEN
846: FND_LOG.STRING(g_level_error ,
847: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
848: 'l_formula_id is null ');
849: FND_LOG.STRING(g_level_error ,
850: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

Line 849: FND_LOG.STRING(g_level_error ,

845: IF (g_level_error >= g_current_runtime_level ) THEN
846: FND_LOG.STRING(g_level_error ,
847: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
848: 'l_formula_id is null ');
849: FND_LOG.STRING(g_level_error ,
850: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
851: 'p_return_status is ' || p_return_status);
852: FND_LOG.STRING(g_level_error ,
853: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

Line 852: FND_LOG.STRING(g_level_error ,

848: 'l_formula_id is null ');
849: FND_LOG.STRING(g_level_error ,
850: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
851: 'p_return_status is ' || p_return_status);
852: FND_LOG.STRING(g_level_error ,
853: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
854: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');
855: END IF;
856: RETURN;

Line 866: FND_LOG.STRING(g_level_statement,

862:
863: while getFormulaInfoD%found loop
864:
865: IF (g_level_statement >= g_current_runtime_level ) THEN
866: FND_LOG.STRING(g_level_statement,
867: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
868: ' Compounding tax: ' || l_compounding_tax||
869: ' Compounding tax regime code: ' || l_cpdg_tax_regime_code||
870: ' Compounding tax type: ' || l_Compounding_Type_Code);

Line 904: FND_LOG.STRING(g_level_error ,

900: if l_compounding_tax_id IS NULL then
901: p_return_status:= FND_API.G_RET_STS_ERROR;
902:
903: IF (g_level_error >= g_current_runtime_level ) THEN
904: FND_LOG.STRING(g_level_error ,
905: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
906: ' Compounding tax id does not exist');
907: FND_LOG.STRING(g_level_error ,
908: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

Line 907: FND_LOG.STRING(g_level_error ,

903: IF (g_level_error >= g_current_runtime_level ) THEN
904: FND_LOG.STRING(g_level_error ,
905: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
906: ' Compounding tax id does not exist');
907: FND_LOG.STRING(g_level_error ,
908: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
909: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');
910: END IF;
911: RETURN;

Line 915: FND_LOG.STRING(g_level_statement,

911: RETURN;
912: end if;
913:
914: IF (g_level_statement >= g_current_runtime_level ) THEN
915: FND_LOG.STRING(g_level_statement,
916: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
917: ' Compounding tax id is ' || l_compounding_tax_id);
918: END IF;
919: -- close getTaxId;

Line 960: FND_LOG.STRING(g_level_error,

956: ZX_API_PUB.add_msg(
957: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
958:
959: IF (g_level_error >= g_current_runtime_level ) THEN
960: FND_LOG.STRING(g_level_error,
961: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
962: 'Either Tax ' || l_compounding_tax_id ||
963: ' is not applicable or compounding precedence is wrong');
964: FND_LOG.STRING(g_level_error,

Line 964: FND_LOG.STRING(g_level_error,

960: FND_LOG.STRING(g_level_error,
961: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
962: 'Either Tax ' || l_compounding_tax_id ||
963: ' is not applicable or compounding precedence is wrong');
964: FND_LOG.STRING(g_level_error,
965: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
966: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');
967: END IF;
968:

Line 1001: FND_LOG.STRING(g_level_statement,

997: + parameter_tbl(l_tax_id).composite_incl_indicator *
998: parameter_tbl(l_tax_id).overrideconst;
999:
1000: IF (g_level_statement >= g_current_runtime_level ) THEN
1001: FND_LOG.STRING(g_level_statement,
1002: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1003: ' sum_basiscoef: ' || l_sum_basiscoef||
1004: ' sum_constcoef: ' || l_sum_constcoef);
1005: END IF;

Line 1021: FND_LOG.STRING(g_level_statement,

1017:
1018: END LOOP;
1019:
1020: IF (g_level_statement >= g_current_runtime_level ) THEN
1021: FND_LOG.STRING(g_level_statement,
1022: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1023: ' ');
1024: END IF;
1025:

Line 1031: FND_LOG.STRING(g_level_statement,

1027:
1028: l_common_comp_base := (l_line_amt - l_sum_constcoef) / l_sum_basiscoef;
1029:
1030: IF (g_level_statement >= g_current_runtime_level ) THEN
1031: FND_LOG.STRING(g_level_statement,
1032: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1033: 'l_sum_basiscoef is ' || l_sum_basiscoef);
1034: FND_LOG.STRING(g_level_statement,
1035: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

Line 1034: FND_LOG.STRING(g_level_statement,

1030: IF (g_level_statement >= g_current_runtime_level ) THEN
1031: FND_LOG.STRING(g_level_statement,
1032: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1033: 'l_sum_basiscoef is ' || l_sum_basiscoef);
1034: FND_LOG.STRING(g_level_statement,
1035: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1036: 'l_sum_constcoef is ' || l_sum_constcoef);
1037: FND_LOG.STRING(g_level_statement,
1038: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

Line 1037: FND_LOG.STRING(g_level_statement,

1033: 'l_sum_basiscoef is ' || l_sum_basiscoef);
1034: FND_LOG.STRING(g_level_statement,
1035: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1036: 'l_sum_constcoef is ' || l_sum_constcoef);
1037: FND_LOG.STRING(g_level_statement,
1038: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1039: 'l_common_comp_base is ' || l_common_comp_base);
1040:
1041: --This complete the building of multipliers. Now update columns

Line 1043: FND_LOG.STRING(g_level_statement,

1039: 'l_common_comp_base is ' || l_common_comp_base);
1040:
1041: --This complete the building of multipliers. Now update columns
1042:
1043: FND_LOG.STRING(g_level_statement,
1044: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1045: 'update columns');
1046: END IF;
1047:

Line 1180: FND_LOG.STRING(g_level_error,

1176: IF getAdhocInfo%NOTFOUND THEN
1177: close getAdhocInfo;
1178: p_return_status := FND_API.G_RET_STS_ERROR;
1179: IF (g_level_error >= g_current_runtime_level ) THEN
1180: FND_LOG.STRING(g_level_error,
1181: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1182: 'No Data Found for tax_rate_code: '||
1183: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code ||
1184: ' tax_rate_id: ' ||

Line 1186: FND_LOG.STRING(g_level_error,

1182: 'No Data Found for tax_rate_code: '||
1183: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code ||
1184: ' tax_rate_id: ' ||
1185: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_id );
1186: FND_LOG.STRING(g_level_error,
1187: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',
1188: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');
1189: END IF;
1190: RETURN;

Line 1241: FND_LOG.STRING(g_level_error,

1237: -- Error out when Tax_rate = 0, unrounded_tax_amt <> 0.
1238: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt <> 0 THEN
1239: p_return_status := FND_API.G_RET_STS_ERROR;
1240: IF (g_level_error >= g_current_runtime_level ) THEN
1241: FND_LOG.STRING(g_level_error,
1242: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1243: 'adj_for_adhoc_amt_code: ' ||l_adj_for_adhoc_amt_code );
1244: FND_LOG.STRING(g_level_error,
1245: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',

Line 1244: FND_LOG.STRING(g_level_error,

1240: IF (g_level_error >= g_current_runtime_level ) THEN
1241: FND_LOG.STRING(g_level_error,
1242: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1243: 'adj_for_adhoc_amt_code: ' ||l_adj_for_adhoc_amt_code );
1244: FND_LOG.STRING(g_level_error,
1245: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1246: 'Tax_rate = 0, unrounded_tax_amt <> 0. ' ||
1247: 'Cannot calculate taxable basis amount.');
1248: FND_LOG.STRING(g_level_error,

Line 1248: FND_LOG.STRING(g_level_error,

1244: FND_LOG.STRING(g_level_error,
1245: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1246: 'Tax_rate = 0, unrounded_tax_amt <> 0. ' ||
1247: 'Cannot calculate taxable basis amount.');
1248: FND_LOG.STRING(g_level_error,
1249: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1250: 'p_return_status = ' || p_return_status);
1251: FND_LOG.STRING(g_level_error,
1252: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',

Line 1251: FND_LOG.STRING(g_level_error,

1247: 'Cannot calculate taxable basis amount.');
1248: FND_LOG.STRING(g_level_error,
1249: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1250: 'p_return_status = ' || p_return_status);
1251: FND_LOG.STRING(g_level_error,
1252: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',
1253: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');
1254: END IF;
1255: RETURN;

Line 1278: FND_LOG.STRING(g_level_error,

1274: -- Error out when Taxable_amt = 0, unrounded_tax_amt <> 0.
1275: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt <> 0 THEN
1276: p_return_status := FND_API.G_RET_STS_ERROR;
1277: IF (g_level_error >= g_current_runtime_level ) THEN
1278: FND_LOG.STRING(g_level_error,
1279: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1280: 'adj_for_adhoc_amt_code: ' ||l_adj_for_adhoc_amt_code );
1281: FND_LOG.STRING(g_level_error,
1282: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',

Line 1281: FND_LOG.STRING(g_level_error,

1277: IF (g_level_error >= g_current_runtime_level ) THEN
1278: FND_LOG.STRING(g_level_error,
1279: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1280: 'adj_for_adhoc_amt_code: ' ||l_adj_for_adhoc_amt_code );
1281: FND_LOG.STRING(g_level_error,
1282: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1283: 'Taxable_amt = 0, unrounded_tax_amt <> 0. ' ||
1284: 'Cannot calculate tax rate.');
1285: FND_LOG.STRING(g_level_error,

Line 1285: FND_LOG.STRING(g_level_error,

1281: FND_LOG.STRING(g_level_error,
1282: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1283: 'Taxable_amt = 0, unrounded_tax_amt <> 0. ' ||
1284: 'Cannot calculate tax rate.');
1285: FND_LOG.STRING(g_level_error,
1286: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1287: 'p_return_status = ' || p_return_status);
1288: FND_LOG.STRING(g_level_error,
1289: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',

Line 1288: FND_LOG.STRING(g_level_error,

1284: 'Cannot calculate tax rate.');
1285: FND_LOG.STRING(g_level_error,
1286: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1287: 'p_return_status = ' || p_return_status);
1288: FND_LOG.STRING(g_level_error,
1289: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',
1290: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');
1291: END IF;
1292: RETURN;

Line 1340: FND_LOG.STRING(g_level_procedure,

1336:
1337: END IF;
1338:
1339: IF (g_level_procedure >= g_current_runtime_level ) THEN
1340: FND_LOG.STRING(g_level_procedure,
1341: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',
1342: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');
1343: END IF;
1344:

Line 1351: FND_LOG.STRING(g_level_unexpected,

1347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1349:
1350: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1351: FND_LOG.STRING(g_level_unexpected,
1352: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS',
1353: p_error_buffer);
1354: END IF;
1355:

Line 1386: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1382: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1383:
1384: BEGIN
1385:
1386: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1387:
1388: IF (g_level_procedure >= g_current_runtime_level ) THEN
1389: FND_LOG.STRING(g_level_procedure,
1390: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag.BEGIN',

Line 1389: FND_LOG.STRING(g_level_procedure,

1385:
1386: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1387:
1388: IF (g_level_procedure >= g_current_runtime_level ) THEN
1389: FND_LOG.STRING(g_level_procedure,
1390: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag.BEGIN',
1391: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag (+)');
1392: END IF;
1393:

Line 1445: FND_LOG.STRING(g_level_statement,

1441: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1442: p_tax_line_index).tax_amt_included_flag := l_inclusive_tax_flag;
1443:
1444: IF g_level_statement >= g_current_runtime_level THEN
1445: FND_LOG.STRING(g_level_statement,
1446: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1447: 'Get Inclusive_tax_flag from Tax Rate: ' ||
1448: l_inclusive_tax_flag);
1449: END IF;

Line 1459: FND_LOG.STRING(g_level_statement,

1455: --
1456: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1457: p_tax_line_index).tax_amt_included_flag IS NOT NULL THEN
1458: IF g_level_statement >= g_current_runtime_level THEN
1459: FND_LOG.STRING(g_level_statement,
1460: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1461: 'tax_amt_included_flag available from tax registration. ' ||
1462: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1463: p_tax_line_index).tax_amt_included_flag);

Line 1487: FND_LOG.STRING(g_level_error ,

1483: p_return_status );
1484:
1485: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1486: IF (g_level_error >= g_current_runtime_level ) THEN
1487: FND_LOG.STRING(g_level_error ,
1488: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1489: 'Incorrect return_status after call ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value().');
1490:
1491: FND_LOG.STRING(g_level_error,

Line 1491: FND_LOG.STRING(g_level_error,

1487: FND_LOG.STRING(g_level_error ,
1488: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1489: 'Incorrect return_status after call ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value().');
1490:
1491: FND_LOG.STRING(g_level_error,
1492: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1493: 'return_status: '|| p_return_status);
1494: END IF;
1495: END IF;

Line 1509: FND_LOG.STRING(g_level_statement,

1505: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1506: p_tax_line_index).tax_amt_included_flag := l_inclusive_tax_flag;
1507:
1508: IF g_level_statement >= g_current_runtime_level THEN
1509: FND_LOG.STRING(g_level_statement,
1510: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1511: 'Get tax_amt_included_flag from SITE PTP: ' ||
1512: l_inclusive_tax_flag);
1513: END IF;

Line 1531: FND_LOG.STRING(g_level_statement,

1527: p_return_status );
1528:
1529: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1530: IF (g_level_statement>= g_current_runtime_level ) THEN
1531: FND_LOG.STRING(g_level_statement,
1532: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1533: 'Incorrect return_status after call ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value().');
1534:
1535: FND_LOG.STRING(g_level_statement,

Line 1535: FND_LOG.STRING(g_level_statement,

1531: FND_LOG.STRING(g_level_statement,
1532: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1533: 'Incorrect return_status after call ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value().');
1534:
1535: FND_LOG.STRING(g_level_statement,
1536: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1537: 'return_status: '|| p_return_status);
1538: END IF;
1539: END IF;

Line 1553: FND_LOG.STRING(g_level_statement,

1549: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1550: p_tax_line_index).tax_amt_included_flag := l_inclusive_tax_flag;
1551:
1552: IF g_level_statement >= g_current_runtime_level THEN
1553: FND_LOG.STRING(g_level_statement,
1554: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1555: 'Get tax_amt_included_flag from PARTY PTP: ' ||
1556: l_inclusive_tax_flag);
1557: END IF;

Line 1571: FND_LOG.STRING(g_level_statement,

1567: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1568: p_tax_line_index).tax_amt_included_flag := l_inclusive_tax_flag;
1569:
1570: IF g_level_statement >= g_current_runtime_level THEN
1571: FND_LOG.STRING(g_level_statement,
1572: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1573: 'Get tax_amt_included_flag from tax: ' ||
1574: l_inclusive_tax_flag);
1575: END IF;

Line 1586: FND_LOG.STRING(g_level_statement,

1582: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1583: p_tax_line_index).tax_amt_included_flag := l_inclusive_tax_flag;
1584:
1585: IF g_level_statement >= g_current_runtime_level THEN
1586: FND_LOG.STRING(g_level_statement,
1587: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1588: 'Inclusive tax flag is defaulted to N. ');
1589: END IF;
1590:

Line 1601: -- FND_LOG.STRING(g_level_unexpected,

1597: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
1598: -- 'populate_inclusive_tax_flag- '|| p_error_buffer);
1599: --FND_MSG_PUB.Add;
1600: --IF (g_level_unexpected >= g_current_runtime_level ) THEN
1601: -- FND_LOG.STRING(g_level_unexpected,
1602: -- 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1603: -- p_error_buffer);
1604: -- FND_LOG.STRING(g_level_unexpected,
1605: -- 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

Line 1604: -- FND_LOG.STRING(g_level_unexpected,

1600: --IF (g_level_unexpected >= g_current_runtime_level ) THEN
1601: -- FND_LOG.STRING(g_level_unexpected,
1602: -- 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1603: -- p_error_buffer);
1604: -- FND_LOG.STRING(g_level_unexpected,
1605: -- 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1606: -- 'Exception :ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag (-)');
1607: --END IF;
1608: --RETURN;

Line 1618: FND_LOG.STRING(g_level_procedure,

1614: END IF; -- tax_amt_included_flag is avialbale from tax rate
1615: END IF; -- line_amt_includes_tax_flag
1616:
1617: IF (g_level_procedure >= g_current_runtime_level ) THEN
1618: FND_LOG.STRING(g_level_procedure,
1619: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag.END',
1620: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag (-)');
1621: END IF;
1622:

Line 1629: FND_LOG.STRING(g_level_unexpected,

1625: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1627:
1628: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1629: FND_LOG.STRING(g_level_unexpected,
1630: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1631: p_error_buffer);
1632: END IF;
1633: END populate_inclusive_tax_flag;