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 ZX_TDS_TAXABLE_BASIS_DETM_PKG

Line 1: PACKAGE BODY ZX_TDS_TAXABLE_BASIS_DETM_PKG AS

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;

Line 158: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.BEGIN',

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:
162: p_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 159: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (+)');

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:
162: p_return_status:= FND_API.G_RET_STS_SUCCESS;
163:

Line 170: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

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;
174: END IF;

Line 171: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)'||' skip processing for credit memo');

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;
174: END IF;
175:

Line 191: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

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

Line 192: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)'||' Error: begin index or end index is null');

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;
195:
196: END IF;

Line 260: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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,
264: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

Line 262: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag');

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,
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;

Line 264: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

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;
268: END IF;

Line 265: '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;
268: END IF;
269: END IF;

Line 351: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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

Line 468: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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:
472: else

Line 491: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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
495: l_formula_code:= l_def_formula;

Line 498: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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;
502: end if;

Line 529: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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
533: l_formula_code:= l_def_formula;

Line 536: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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;
540: END IF;

Line 547: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

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;
551: END IF;

Line 548: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)'||' error: can not determine formula code');

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;
551: END IF;
552:

Line 580: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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:= ' ||
584: parameter_tbl(l_tax_id).weird_indicator);

Line 627: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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',
631: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');

Line 630: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

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:
634: RETURN;

Line 631: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');

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:
634: RETURN;
635:

Line 681: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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',
685: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');

Line 684: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

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:
688: end if;

Line 685: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');

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:
688: end if;
689:

Line 695: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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: '||
699: l_Transfer_Charge_Appl_Flag||' TRANS_CHRG_APPL_FLG: '||L_TRANS_CHRG_APPL_FLG||

Line 738: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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 ,
742: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

Line 742: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

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

Line 743: '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;
746:
747: END IF;

Line 806: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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

Line 838: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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

Line 847: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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',
851: 'p_return_status is ' || p_return_status);

Line 850: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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',
854: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');

Line 853: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

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;
857: end if;

Line 854: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');

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;
857: end if;
858:

Line 867: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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);
871: END IF;

Line 905: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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',
909: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');

Line 908: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

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;
912: end if;

Line 909: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');

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;
912: end if;
913:

Line 916: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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

Line 961: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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,
965: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

Line 965: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

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:
969: RETURN;

Line 966: '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:
969: RETURN;
970: ELSE

Line 1002: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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

Line 1022: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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:
1026: IF nvl(p_return_status, 'SUCCESS') <> FND_API.G_RET_STS_ERROR THEN

Line 1032: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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',
1036: 'l_sum_constcoef is ' || l_sum_constcoef);

Line 1035: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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',
1039: 'l_common_comp_base is ' || l_common_comp_base);

Line 1038: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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
1042:

Line 1044: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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:
1048: for i in p_begin_index..p_end_index loop

Line 1181: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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: ' ||
1185: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_id );

Line 1187: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',

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;
1191: END IF;

Line 1188: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');

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;
1191: END IF;
1192: CLOSE getAdhocInfo;

Line 1242: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',

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',
1246: 'Tax_rate = 0, unrounded_tax_amt <> 0. ' ||

Line 1245: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',

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,
1249: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

Line 1249: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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',
1253: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');

Line 1252: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',

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;
1256: END IF;

Line 1253: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');

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;
1256: END IF;
1257: END IF; -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate

Line 1279: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',

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',
1283: 'Taxable_amt = 0, unrounded_tax_amt <> 0. ' ||

Line 1282: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',

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,
1286: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

Line 1286: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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',
1290: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');

Line 1289: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',

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;
1293: END IF;

Line 1290: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');

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;
1293: END IF;
1294:

Line 1341: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',

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:
1345: EXCEPTION

Line 1342: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');

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:
1345: EXCEPTION
1346: WHEN OTHERS THEN

Line 1352: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS',

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:
1356: END get_taxable_basis;

Line 1390: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag.BEGIN',

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:
1394: p_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 1391: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag (+)');

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:
1394: p_return_status:= FND_API.G_RET_STS_SUCCESS;
1395:

Line 1446: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

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;
1450: ELSE

Line 1460: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

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);
1464: END IF;

Line 1488: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

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,
1492: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

Line 1492: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

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

Line 1510: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

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

Line 1532: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

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,
1536: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

Line 1536: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

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

Line 1554: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

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;
1558: ELSE

Line 1572: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

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

Line 1587: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

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:
1591: ---- raise error because l_inclusive_tax_flag is not available

Line 1602: -- 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

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',
1606: -- 'Exception :ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag (-)');

Line 1605: -- 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

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

Line 1606: -- 'Exception :ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag (-)');

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;
1609:
1610: END IF; -- tax_amt_included_flag is avialbale from tax

Line 1619: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag.END',

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:
1623: EXCEPTION

Line 1620: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_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:
1623: EXCEPTION
1624: WHEN OTHERS THEN

Line 1630: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

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

Line 1635: END ZX_TDS_TAXABLE_BASIS_DETM_PKG;

1631: p_error_buffer);
1632: END IF;
1633: END populate_inclusive_tax_flag;
1634:
1635: END ZX_TDS_TAXABLE_BASIS_DETM_PKG;
1636: