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.109.12020000.2 2012/07/23 12:54:49 srajapar noship $ */
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.109.12020000.2 2012/07/23 12:54:49 srajapar noship $ */
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 146: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

142: FROM zx_rates_b
143: WHERE tax_rate_id = c_tax_rate_id;
144:
145: BEGIN
146: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
147:
148: IF (g_level_procedure >= g_current_runtime_level ) THEN
149: FND_LOG.STRING(g_level_procedure,
150: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.BEGIN',

Line 149: FND_LOG.STRING(g_level_procedure,

145: BEGIN
146: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
147:
148: IF (g_level_procedure >= g_current_runtime_level ) THEN
149: FND_LOG.STRING(g_level_procedure,
150: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.BEGIN',
151: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (+)');
152: END IF;
153:

Line 159: FND_LOG.STRING(g_level_procedure,

155:
156: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
157: p_structure_index) IS NOT NULL THEN
158: IF (g_level_procedure >= g_current_runtime_level ) THEN
159: FND_LOG.STRING(g_level_procedure,
160: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
161: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)'||
162: ' Skip processing for credit memo');
163: END IF;

Line 178: FND_LOG.STRING(g_level_procedure,

174:
175: IF p_begin_index IS NULL OR p_end_index IS NULL THEN
176: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
177: IF (g_level_procedure >= g_current_runtime_level) THEN
178: FND_LOG.STRING(g_level_procedure,
179: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
180: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)'||
181: ' Error: begin index or end index is null');
182: END IF;

Line 187: FND_LOG.STRING(g_level_statement,

183: RETURN;
184: END IF;
185:
186: IF (g_level_statement >= g_current_runtime_level) THEN
187: FND_LOG.STRING(g_level_statement,
188: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
189: 'Starting Loop for Building multipliers ...');
190: END IF;
191:

Line 195: FND_LOG.STRING(g_level_statement,

191:
192: FOR i IN p_begin_index..p_end_index LOOP
193:
194: IF (g_level_statement >= g_current_runtime_level) THEN
195: FND_LOG.STRING(g_level_statement,
196: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
197: 'Processing Tax Line '||TO_CHAR(i));
198: END IF;
199: -- Added Condition for Bug#12884787 to skip processing for cancel tax lines

Line 203: FND_LOG.STRING(g_level_statement,

199: -- Added Condition for Bug#12884787 to skip processing for cancel tax lines
200: IF NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).cancel_flag,'N') = 'Y'
201: THEN
202: IF (g_level_statement >= g_current_runtime_level) THEN
203: FND_LOG.STRING(g_level_statement,
204: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
205: 'Canceled Tax Line ... Do Nothing.');
206: END IF;
207: NULL;

Line 216: FND_LOG.STRING(g_level_statement,

212: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).manually_entered_flag = 'Y' AND
213: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).freeze_until_overridden_flag ='Y'
214: THEN
215: IF (g_level_statement >= g_current_runtime_level) THEN
216: FND_LOG.STRING(g_level_statement,
217: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
218: 'Zero Amount Reference Tax Line ... Do Nothing.');
219: END IF;
220: NULL;

Line 261: FND_LOG.STRING(g_level_statement,

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

Line 265: FND_LOG.STRING(g_level_statement,

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

Line 299: FND_LOG.STRING(g_level_statement,

295: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'P')
296: THEN
297:
298: IF (g_level_statement >= g_current_runtime_level ) THEN
299: FND_LOG.STRING(g_level_statement,
300: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
301: 'Case 1 ... Building multipliers');
302: END IF;
303:

Line 324: FND_LOG.STRING(g_level_statement,

320: parameter_tbl(l_tax_id).formula_code :=
321: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).taxable_basis_formula;
322:
323: IF (g_level_statement >= g_current_runtime_level) THEN
324: FND_LOG.STRING(g_level_statement,
325: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
326: 'parameter_tbl('||TO_CHAR(l_tax_id)||').formula_code : '||
327: parameter_tbl(l_tax_id).formula_code);
328: END IF;

Line 350: FND_LOG.STRING(g_level_statement,

346: parameter_tbl(l_tax_id).incl_indicator:= 0;
347: END IF;
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: 'parameter_tbl('||TO_CHAR(l_tax_id)||').incl_indicator:= ' ||
353: parameter_tbl(l_tax_id).incl_indicator||
354: ', weird_indicator:= ' ||

Line 376: FND_LOG.STRING(g_level_statement,

372: + parameter_tbl(l_tax_id).composite_incl_indicator *
373: parameter_tbl(l_tax_id).overrideconst;
374:
375: IF (g_level_statement >= g_current_runtime_level ) THEN
376: FND_LOG.STRING(g_level_statement,
377: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
378: ' sum_basiscoef: ' || l_sum_basiscoef||
379: ' sum_constcoef: ' || l_sum_constcoef);
380: END IF;

Line 388: FND_LOG.STRING(g_level_statement,

384: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag = 'Y'
385: THEN
386:
387: IF (g_level_statement >= g_current_runtime_level ) THEN
388: FND_LOG.STRING(g_level_statement,
389: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
390: 'Case 2 ... Do Nothing');
391: END IF;
392:

Line 405: FND_LOG.STRING(g_level_statement,

401: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_structure_index) <> 'INTERCOMPANY_TRX' --Bug 10162888
402: THEN
403:
404: IF (g_level_statement >= g_current_runtime_level ) THEN
405: FND_LOG.STRING(g_level_statement,
406: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
407: 'Case 3 ... Do Nothing');
408: END IF;
409:

Line 433: FND_LOG.STRING(g_level_statement,

429: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE = 'REFERENCE'
430: THEN
431:
432: IF (g_level_statement >= g_current_runtime_level ) THEN
433: FND_LOG.STRING(g_level_statement,
434: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
435: 'Case 4 ... Do Nothing');
436: END IF;
437:

Line 460: FND_LOG.STRING(g_level_statement,

456: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Overridden_Flag <> 'Y'
457: THEN
458:
459: IF (g_level_statement >= g_current_runtime_level ) THEN
460: FND_LOG.STRING(g_level_statement,
461: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
462: 'Case 5 ... Do Nothing');
463: END IF;
464:

Line 487: FND_LOG.STRING(g_level_statement,

483: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry,'X') <> 'TAX_AMOUNT')
484: THEN
485:
486: IF (g_level_statement >= g_current_runtime_level ) THEN
487: FND_LOG.STRING(g_level_statement,
488: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
489: 'Case 6 ... Building multipliers');
490: END IF;
491:

Line 524: FND_LOG.STRING(g_level_statement,

520:
521: IF l_zx_result_rec.alphanumeric_result IS NOT NULL THEN
522: l_formula_code:= l_zx_result_rec.alphanumeric_result;
523: IF (g_level_statement >= g_current_runtime_level ) THEN
524: FND_LOG.STRING(g_level_statement,
525: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
526: 'Get Formula code from rule_base_process : '|| l_formula_code);
527: END IF;
528: ELSE

Line 545: FND_LOG.STRING(g_level_statement,

541:
542: IF l_formula_from_rate IS NOT NULL THEN
543: l_formula_code:= l_formula_from_rate;
544: IF (g_level_statement >= g_current_runtime_level ) THEN
545: FND_LOG.STRING(g_level_statement,
546: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
547: 'Get Formula code from tax rate : '||l_formula_code);
548: END IF;
549: ELSE

Line 552: FND_LOG.STRING(g_level_statement,

548: END IF;
549: ELSE
550: l_formula_code:= l_def_formula;
551: IF (g_level_statement >= g_current_runtime_level ) THEN
552: FND_LOG.STRING(g_level_statement,
553: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
554: 'Get Default Formula code from tax : '||l_formula_code);
555: END IF;
556: END IF;

Line 583: FND_LOG.STRING(g_level_statement,

579:
580: IF l_formula_from_rate IS NOT NULL THEN
581: l_formula_code := l_formula_from_rate;
582: IF (g_level_statement >= g_current_runtime_level ) THEN
583: FND_LOG.STRING(g_level_statement,
584: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
585: 'Get Formula code from tax rate : '|| l_formula_code);
586: END IF;
587: ELSE

Line 590: FND_LOG.STRING(g_level_statement,

586: END IF;
587: ELSE
588: l_formula_code:= l_def_formula;
589: IF (g_level_statement >= g_current_runtime_level ) THEN
590: FND_LOG.STRING(g_level_statement,
591: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
592: 'Get Default Formula code from tax : '|| l_formula_code);
593: END IF;
594: END IF;

Line 607: FND_LOG.STRING(g_level_error ,

603:
604: IF l_formula_code IS NULL THEN
605: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606: IF (g_level_error >= g_current_runtime_level ) THEN
607: FND_LOG.STRING(g_level_error ,
608: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
609: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)'||
610: ' Error: can not determine formula code');
611: END IF;

Line 620: FND_LOG.STRING(g_level_statement,

616: parameter_tbl(l_tax_id).tax_rate:= ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate;
617: parameter_tbl(l_tax_id).formula_code:= l_formula_code;
618:
619: IF (g_level_statement >= g_current_runtime_level) THEN
620: FND_LOG.STRING(g_level_statement,
621: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
622: 'parameter_tbl('||TO_CHAR(l_tax_id)||').formula_code : '||
623: parameter_tbl(l_tax_id).formula_code);
624: END IF;

Line 647: FND_LOG.STRING(g_level_statement,

643: parameter_tbl(l_tax_id).incl_indicator:= 0;
644: END IF;
645:
646: IF (g_level_statement >= g_current_runtime_level ) THEN
647: FND_LOG.STRING(g_level_statement,
648: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
649: 'parameter_tbl('||TO_CHAR(l_tax_id)||').incl_indicator:= ' ||
650: parameter_tbl(l_tax_id).incl_indicator||
651: ', weird_indicator:= ' ||

Line 690: FND_LOG.STRING(g_level_error ,

686:
687: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
688:
689: IF (g_level_error >= g_current_runtime_level ) THEN
690: FND_LOG.STRING(g_level_error ,
691: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
692: 'Taxable basis type and tax Rate Type do not match ');
693: FND_LOG.STRING(g_level_error,
694: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

Line 693: FND_LOG.STRING(g_level_error,

689: IF (g_level_error >= g_current_runtime_level ) THEN
690: FND_LOG.STRING(g_level_error ,
691: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
692: 'Taxable basis type and tax Rate Type do not match ');
693: FND_LOG.STRING(g_level_error,
694: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
695: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');
696: END IF;
697: RETURN;

Line 742: FND_LOG.STRING(g_level_error,

738:
739: IF getFormulaInfoH%NOTFOUND THEN
740: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR; -- 8568734
741: IF (g_level_error >= g_current_runtime_level ) THEN
742: FND_LOG.STRING(g_level_error,
743: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
744: 'Formula Info not found for formula code : ' || l_formula_code );
745: FND_LOG.STRING(g_level_error,
746: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

Line 745: FND_LOG.STRING(g_level_error,

741: IF (g_level_error >= g_current_runtime_level ) THEN
742: FND_LOG.STRING(g_level_error,
743: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
744: 'Formula Info not found for formula code : ' || l_formula_code );
745: FND_LOG.STRING(g_level_error,
746: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
747: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');
748: END IF;
749: END IF;

Line 754: FND_LOG.STRING(g_level_statement,

750:
751: CLOSE getFormulaInfoH;
752:
753: IF (g_level_statement >= g_current_runtime_level ) THEN
754: FND_LOG.STRING(g_level_statement,
755: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
756: 'Taxable Basis Type: '|| l_taxable_basis_type_code||
757: ' Base Rate Modifier: '||l_base_rate_modifier||
758: ' Cash_Discount_Appl_Flag: '||l_cash_discount_appl_flag||

Line 794: FND_LOG.STRING(g_level_error ,

790:
791: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
792:
793: IF (g_level_error >= g_current_runtime_level ) THEN
794: FND_LOG.STRING(g_level_error ,
795: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
796: 'Taxable basis type for Formula Code '||l_formula_code||
797: ' and tax Rate Type QUANTITY do not match ');
798: FND_LOG.STRING(g_level_error ,

Line 798: FND_LOG.STRING(g_level_error ,

794: FND_LOG.STRING(g_level_error ,
795: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
796: 'Taxable basis type for Formula Code '||l_formula_code||
797: ' and tax Rate Type QUANTITY do not match ');
798: FND_LOG.STRING(g_level_error ,
799: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
800: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');
801: END IF;
802: RETURN;

Line 847: FND_LOG.STRING(g_level_statement,

843: ABS(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.other_charge(p_structure_index));
844: END IF;
845:
846: IF (g_level_statement >= g_current_runtime_level ) THEN
847: FND_LOG.STRING(g_level_statement,
848: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
849: 'Total discount or charge : '||NVL(l_discount_amt,0));
850: END IF;
851:

Line 872: FND_LOG.STRING(g_level_statement,

868: parameter_tbl(l_tax_id).constcoef := parameter_tbl(l_tax_id).discount;
869: parameter_tbl(l_tax_id).overrideconst := 0;
870:
871: IF (g_level_statement >= g_current_runtime_level ) THEN
872: FND_LOG.STRING(g_level_statement,
873: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
874: 'Basiscoef: ' ||parameter_tbl(l_tax_id).basiscoef ||
875: ', Constcoef: ' ||parameter_tbl(l_tax_id).constcoef);
876: END IF;

Line 881: FND_LOG.STRING(g_level_error ,

877:
878: IF l_formula_id IS NULL THEN
879: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
880: IF (g_level_error >= g_current_runtime_level ) THEN
881: FND_LOG.STRING(g_level_error ,
882: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
883: 'Error : l_formula_id IS NULL ');
884: FND_LOG.STRING(g_level_error ,
885: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

Line 884: FND_LOG.STRING(g_level_error ,

880: IF (g_level_error >= g_current_runtime_level ) THEN
881: FND_LOG.STRING(g_level_error ,
882: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
883: 'Error : l_formula_id IS NULL ');
884: FND_LOG.STRING(g_level_error ,
885: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
886: 'p_return_status : ' || p_return_status);
887: FND_LOG.STRING(g_level_error ,
888: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

Line 887: FND_LOG.STRING(g_level_error ,

883: 'Error : l_formula_id IS NULL ');
884: FND_LOG.STRING(g_level_error ,
885: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
886: 'p_return_status : ' || p_return_status);
887: FND_LOG.STRING(g_level_error ,
888: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
889: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');
890: END IF;
891: RETURN;

Line 900: FND_LOG.STRING(g_level_statement,

896: l_compounding_type_code, l_enforce_compounding_flag;
897:
898: WHILE getFormulaInfoD%found LOOP
899: IF (g_level_statement >= g_current_runtime_level ) THEN
900: FND_LOG.STRING(g_level_statement,
901: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
902: ' Compounding tax: ' || l_compounding_tax||
903: ' Compounding tax regime code: ' || l_cpdg_tax_regime_code||
904: ' Compounding tax type: ' || l_Compounding_Type_Code);

Line 949: FND_LOG.STRING(g_level_error ,

945:
946: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
947:
948: IF (g_level_error >= g_current_runtime_level ) THEN
949: FND_LOG.STRING(g_level_error ,
950: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
951: 'Compounding_Tax_Id does not exist');
952: FND_LOG.STRING(g_level_error ,
953: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

Line 952: FND_LOG.STRING(g_level_error ,

948: IF (g_level_error >= g_current_runtime_level ) THEN
949: FND_LOG.STRING(g_level_error ,
950: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
951: 'Compounding_Tax_Id does not exist');
952: FND_LOG.STRING(g_level_error ,
953: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
954: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');
955: END IF;
956: RETURN;

Line 960: FND_LOG.STRING(g_level_statement,

956: RETURN;
957: END IF;
958:
959: IF (g_level_statement >= g_current_runtime_level ) THEN
960: FND_LOG.STRING(g_level_statement,
961: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
962: ' Compounding_Tax_Id : ' || l_compounding_tax_id);
963: END IF;
964: -- CLOSE getTaxId;

Line 1039: FND_LOG.STRING(g_level_error,

1035:
1036: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1037:
1038: IF (g_level_error >= g_current_runtime_level ) THEN
1039: FND_LOG.STRING(g_level_error,
1040: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1041: 'Either Tax ' || l_compounding_tax_id ||
1042: ' is not applicable or compounding precedence is wrong');
1043: FND_LOG.STRING(g_level_error,

Line 1043: FND_LOG.STRING(g_level_error,

1039: FND_LOG.STRING(g_level_error,
1040: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1041: 'Either Tax ' || l_compounding_tax_id ||
1042: ' is not applicable or compounding precedence is wrong');
1043: FND_LOG.STRING(g_level_error,
1044: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',
1045: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');
1046: END IF;
1047: RETURN;

Line 1066: FND_LOG.STRING(g_level_statement,

1062: END IF; -- taxable basis type code
1063: END IF; -- l_formula_code
1064:
1065: IF (g_level_statement >= g_current_runtime_level ) THEN
1066: FND_LOG.STRING(g_level_statement,
1067: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1068: 'Composite Indicator: '|| parameter_tbl(l_tax_id).composite_incl_indicator||
1069: ', sum_basiscoef: ' || l_sum_basiscoef ||
1070: ', sum_basiscoef_qua: ' || l_sum_basiscoef_qua);

Line 1098: FND_LOG.STRING(g_level_statement,

1094: parameter_tbl(l_tax_id).overrideconst;
1095: END IF;
1096:
1097: IF (g_level_statement >= g_current_runtime_level ) THEN
1098: FND_LOG.STRING(g_level_statement,
1099: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1100: 'sum_basiscoef : ' || l_sum_basiscoef||
1101: ' sum_constcoef : ' || l_sum_constcoef);
1102: END IF;

Line 1106: FND_LOG.STRING(g_level_statement,

1102: END IF;
1103:
1104: ELSE -- default case
1105: IF (g_level_statement >= g_current_runtime_level ) THEN
1106: FND_LOG.STRING(g_level_statement,
1107: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1108: 'Default Case ... Do Nothing');
1109: END IF;
1110: NULL;

Line 1134: FND_LOG.STRING(g_level_statement,

1130: l_common_comp_base := 0;
1131: END IF;
1132:
1133: IF (g_level_statement >= g_current_runtime_level ) THEN
1134: FND_LOG.STRING(g_level_statement,
1135: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1136: 'l_sum_basiscoef : ' || l_sum_basiscoef ||
1137: ', l_sum_basiscoef_qua : '|| l_sum_basiscoef_qua);
1138: FND_LOG.STRING(g_level_statement,

Line 1138: FND_LOG.STRING(g_level_statement,

1134: FND_LOG.STRING(g_level_statement,
1135: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1136: 'l_sum_basiscoef : ' || l_sum_basiscoef ||
1137: ', l_sum_basiscoef_qua : '|| l_sum_basiscoef_qua);
1138: FND_LOG.STRING(g_level_statement,
1139: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1140: 'l_sum_constcoef : ' || l_sum_constcoef);
1141: FND_LOG.STRING(g_level_statement,
1142: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

Line 1141: FND_LOG.STRING(g_level_statement,

1137: ', l_sum_basiscoef_qua : '|| l_sum_basiscoef_qua);
1138: FND_LOG.STRING(g_level_statement,
1139: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1140: 'l_sum_constcoef : ' || l_sum_constcoef);
1141: FND_LOG.STRING(g_level_statement,
1142: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1143: 'l_common_comp_base : ' || l_common_comp_base);
1144: -- This complete the building of multipliers. Now update columns
1145: FND_LOG.STRING(g_level_statement,

Line 1145: FND_LOG.STRING(g_level_statement,

1141: FND_LOG.STRING(g_level_statement,
1142: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1143: 'l_common_comp_base : ' || l_common_comp_base);
1144: -- This complete the building of multipliers. Now update columns
1145: FND_LOG.STRING(g_level_statement,
1146: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1147: 'Building multipliers Completed.');
1148: FND_LOG.STRING(g_level_statement,
1149: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

Line 1148: FND_LOG.STRING(g_level_statement,

1144: -- This complete the building of multipliers. Now update columns
1145: FND_LOG.STRING(g_level_statement,
1146: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1147: 'Building multipliers Completed.');
1148: FND_LOG.STRING(g_level_statement,
1149: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1150: 'Starting Loop for Updating columns ...');
1151: END IF;
1152:

Line 1164: FND_LOG.STRING(g_level_statement,

1160: -- Even if Freeze_Until_Overridden_Flag is 'Y', if the tax event type is
1161: -- OVERRIDE, then taxable amount should be calculated.
1162:
1163: IF (g_level_statement >= g_current_runtime_level ) THEN
1164: FND_LOG.STRING(g_level_statement,
1165: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1166: 'Updating columns for Tax Line '||TO_CHAR(i));
1167: END IF;
1168:

Line 1175: FND_LOG.STRING(g_level_statement,

1171: -- Added Condition for Bug#12884787 to skip processing for cancel tax lines
1172: WHEN NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).cancel_flag,'N') = 'Y'
1173: THEN
1174: IF (g_level_statement >= g_current_runtime_level ) THEN
1175: FND_LOG.STRING(g_level_statement,
1176: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1177: 'Case 1 : Canceled Tax Line ... Do Nothing');
1178: END IF;
1179: NULL;

Line 1190: FND_LOG.STRING(g_level_statement,

1186: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).manually_entered_flag = 'Y' AND
1187: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).freeze_until_overridden_flag ='Y'
1188: THEN
1189: IF (g_level_statement >= g_current_runtime_level) THEN
1190: FND_LOG.STRING(g_level_statement,
1191: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1192: 'Case 2 : Zero Amount Reference Tax Line ... Do Nothing');
1193: END IF;
1194: NULL;

Line 1201: FND_LOG.STRING(g_level_statement,

1197: WHEN ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id IS NOT NULL OR
1198: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag = 'Y'
1199: THEN
1200: IF (g_level_statement >= g_current_runtime_level ) THEN
1201: FND_LOG.STRING(g_level_statement,
1202: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1203: 'Case 3 : Partner Tax Line ... Do Nothing');
1204: END IF;
1205: NULL;

Line 1215: FND_LOG.STRING(g_level_statement,

1211: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code <> 'OVERRIDE_TAX' AND
1212: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_structure_index) <> 'INTERCOMPANY_TRX'
1213: THEN
1214: IF (g_level_statement >= g_current_runtime_level ) THEN
1215: FND_LOG.STRING(g_level_statement,
1216: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1217: 'Case 4 ... Do Nothing');
1218: END IF;
1219: NULL;

Line 1227: FND_LOG.STRING(g_level_statement,

1223: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Manually_Entered_Flag = 'Y' AND
1224: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE = 'REFERENCE'
1225: THEN
1226: IF (g_level_statement >= g_current_runtime_level ) THEN
1227: FND_LOG.STRING(g_level_statement,
1228: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1229: 'Case 5 ... Do Nothing');
1230: END IF;
1231: NULL;

Line 1261: FND_LOG.STRING(g_level_statement,

1257: -- Taxable basis determination calcuates the taxable amount as
1258: -- tax amount / tax rate
1259:
1260: IF (g_level_statement >= g_current_runtime_level ) THEN
1261: FND_LOG.STRING(g_level_statement,
1262: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1263: 'Case 6 ... Updating columns');
1264: END IF;
1265:

Line 1285: FND_LOG.STRING(g_level_statement,

1281: THEN
1282: -- Taxable amounts should have been set to zero in applicability process.
1283: -- hence no processing required here.
1284: IF (g_level_statement >= g_current_runtime_level ) THEN
1285: FND_LOG.STRING(g_level_statement,
1286: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1287: 'Case 7 ... Do Nothing');
1288: END IF;
1289: NULL;

Line 1301: FND_LOG.STRING(g_level_statement,

1297: (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX' AND
1298: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Recalc_Required_Flag = 'Y')
1299: THEN
1300: IF (g_level_statement >= g_current_runtime_level ) THEN
1301: FND_LOG.STRING(g_level_statement,
1302: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1303: 'Case 8 ... Updating columns');
1304: END IF;
1305:

Line 1331: FND_LOG.STRING(g_level_statement,

1327: := parameter_tbl(l_tax_id).formula_code;
1328: END IF;
1329:
1330: IF (g_level_statement >= g_current_runtime_level ) THEN
1331: FND_LOG.STRING(g_level_statement,
1332: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1333: 'Taxable_Basis_formula : '||
1334: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).taxable_basis_formula);
1335: END IF;

Line 1386: -- FND_LOG.STRING(g_level_error,

1382: --IF getAdhocInfo%NOTFOUND THEN
1383: -- close getAdhocInfo;
1384: -- p_return_status := FND_API.G_RET_STS_ERROR;
1385: -- IF (g_level_error >= g_current_runtime_level ) THEN
1386: -- FND_LOG.STRING(g_level_error,
1387: -- 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1388: -- 'No Data Found for tax_rate_code: '||
1389: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code ||
1390: -- ' tax_rate_id: ' ||

Line 1392: -- FND_LOG.STRING(g_level_error,

1388: -- 'No Data Found for tax_rate_code: '||
1389: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code ||
1390: -- ' tax_rate_id: ' ||
1391: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_id );
1392: -- FND_LOG.STRING(g_level_error,
1393: -- 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',
1394: -- 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');
1395: -- END IF;
1396: -- RETURN;

Line 1416: FND_LOG.STRING(g_level_statement,

1412: l_adj_for_adhoc_amt_code := nvl(l_tax_rate_rec.adj_for_adhoc_amt_code,'TAXABLE_BASIS');
1413: l_allow_adhoc_tax_rate_flag := nvl(l_tax_rate_rec.Allow_Adhoc_Tax_Rate_Flag,'N');
1414:
1415: IF (g_level_statement >= g_current_runtime_level ) THEN
1416: FND_LOG.STRING(g_level_statement,
1417: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1418: 'Adj_for_adhoc_amt_code : ' ||l_adj_for_adhoc_amt_code);
1419: FND_LOG.STRING(g_level_statement,
1420: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',

Line 1419: FND_LOG.STRING(g_level_statement,

1415: IF (g_level_statement >= g_current_runtime_level ) THEN
1416: FND_LOG.STRING(g_level_statement,
1417: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1418: 'Adj_for_adhoc_amt_code : ' ||l_adj_for_adhoc_amt_code);
1419: FND_LOG.STRING(g_level_statement,
1420: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1421: 'Allow_adhoc_tax_rate_flag : ' ||l_allow_adhoc_tax_rate_flag);
1422: END IF;
1423:

Line 1445: FND_LOG.STRING(g_level_statement,

1441: IF NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).manually_entered_flag,'N') = 'Y' THEN
1442: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).taxable_basis_formula:= 'PRORATED_TB';
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.Get_taxable_basis',
1447: 'Manual Tax Line. Set Taxable_Basis_formula to '||
1448: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).taxable_basis_formula);
1449: END IF;

Line 1460: FND_LOG.STRING(g_level_statement,

1456: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt <> 0
1457: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).historical_flag,'N') = 'Y'
1458: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).manually_entered_flag,'N') = 'Y' THEN
1459: IF (g_level_statement >= g_current_runtime_level ) THEN
1460: FND_LOG.STRING(g_level_statement,
1461: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1462: 'Tax_Rate = 0, Unrounded_tax_amt <> 0, Historical_Flag = Y, '||
1463: 'Manually_entered_flag = Y. Skip Validation.');
1464: END IF;

Line 1470: FND_LOG.STRING(g_level_error,

1466: -- Error out when Tax_rate = 0, unrounded_tax_amt <> 0.
1467: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt <> 0 THEN
1468: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- 8568734
1469: IF (g_level_error >= g_current_runtime_level ) THEN
1470: FND_LOG.STRING(g_level_error,
1471: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1472: 'Tax_rate = 0, unrounded_tax_amt <> 0. ' ||
1473: 'Cannot calculate taxable basis amount.');
1474: FND_LOG.STRING(g_level_error,

Line 1474: FND_LOG.STRING(g_level_error,

1470: FND_LOG.STRING(g_level_error,
1471: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1472: 'Tax_rate = 0, unrounded_tax_amt <> 0. ' ||
1473: 'Cannot calculate taxable basis amount.');
1474: FND_LOG.STRING(g_level_error,
1475: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1476: 'p_return_status = ' || p_return_status);
1477: FND_LOG.STRING(g_level_error,
1478: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',

Line 1477: FND_LOG.STRING(g_level_error,

1473: 'Cannot calculate taxable basis amount.');
1474: FND_LOG.STRING(g_level_error,
1475: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1476: 'p_return_status = ' || p_return_status);
1477: FND_LOG.STRING(g_level_error,
1478: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',
1479: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');
1480: END IF;
1481: RETURN;

Line 1503: FND_LOG.STRING(g_level_error,

1499: -- Error out when Taxable_amt = 0, unrounded_tax_amt <> 0.
1500: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt <> 0 THEN
1501: p_return_status := FND_API.G_RET_STS_ERROR;
1502: IF (g_level_error >= g_current_runtime_level ) THEN
1503: FND_LOG.STRING(g_level_error,
1504: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1505: 'Taxable_amt = 0, unrounded_tax_amt <> 0. ' ||
1506: 'Cannot calculate tax rate.');
1507: FND_LOG.STRING(g_level_error,

Line 1507: FND_LOG.STRING(g_level_error,

1503: FND_LOG.STRING(g_level_error,
1504: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis',
1505: 'Taxable_amt = 0, unrounded_tax_amt <> 0. ' ||
1506: 'Cannot calculate tax rate.');
1507: FND_LOG.STRING(g_level_error,
1508: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1509: 'p_return_status = ' || p_return_status);
1510: FND_LOG.STRING(g_level_error,
1511: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',

Line 1510: FND_LOG.STRING(g_level_error,

1506: 'Cannot calculate tax rate.');
1507: FND_LOG.STRING(g_level_error,
1508: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1509: 'p_return_status = ' || p_return_status);
1510: FND_LOG.STRING(g_level_error,
1511: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',
1512: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');
1513: END IF;
1514: RETURN;

Line 1532: FND_LOG.STRING(g_level_statement,

1528:
1529: -- 9
1530: WHEN ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Freeze_Until_Overridden_Flag = 'Y' THEN
1531: IF (g_level_statement >= g_current_runtime_level ) THEN
1532: FND_LOG.STRING(g_level_statement,
1533: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1534: 'Case 9 ... Do Nothing');
1535: END IF;
1536: NULL;

Line 1540: FND_LOG.STRING(g_level_statement,

1536: NULL;
1537:
1538: ELSE -- default case
1539: IF (g_level_statement >= g_current_runtime_level ) THEN
1540: FND_LOG.STRING(g_level_statement,
1541: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
1542: 'Default Case ... Do Nothing');
1543: END IF;
1544: NULL;

Line 1567: FND_LOG.STRING(g_level_procedure,

1563: END LOOP;
1564: END IF;
1565:
1566: IF (g_level_procedure >= g_current_runtime_level ) THEN
1567: FND_LOG.STRING(g_level_procedure,
1568: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',
1569: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)');
1570: END IF;
1571:

Line 1578: FND_LOG.STRING(g_level_unexpected,

1574: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1575: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1576:
1577: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1578: FND_LOG.STRING(g_level_unexpected,
1579: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS',
1580: p_error_buffer);
1581: END IF;
1582:

Line 1614: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1610: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1611:
1612: BEGIN
1613:
1614: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1615:
1616: IF (g_level_procedure >= g_current_runtime_level ) THEN
1617: FND_LOG.STRING(g_level_procedure,
1618: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag.BEGIN',

Line 1617: FND_LOG.STRING(g_level_procedure,

1613:
1614: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1615:
1616: IF (g_level_procedure >= g_current_runtime_level ) THEN
1617: FND_LOG.STRING(g_level_procedure,
1618: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag.BEGIN',
1619: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag (+)');
1620: END IF;
1621:

Line 1656: FND_LOG.STRING(g_level_statement,

1652: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1653: p_tax_line_index).tax_amt_included_flag := l_inclusive_tax_flag;
1654:
1655: IF g_level_statement >= g_current_runtime_level THEN
1656: FND_LOG.STRING(g_level_statement,
1657: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1658: 'Get Inclusive_tax_flag from Tax Rate: ' || l_inclusive_tax_flag);
1659: END IF;
1660: ELSE

Line 1674: FND_LOG.STRING(g_level_statement,

1670: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1671: p_tax_line_index).tax_amt_included_flag := l_inclusive_tax_flag;
1672:
1673: IF g_level_statement >= g_current_runtime_level THEN
1674: FND_LOG.STRING(g_level_statement,
1675: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1676: 'Get tax_amt_included_flag from tax: ' || l_inclusive_tax_flag);
1677: END IF;
1678: ELSE

Line 1686: FND_LOG.STRING(g_level_statement,

1682: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1683: p_tax_line_index).tax_amt_included_flag := l_inclusive_tax_flag;
1684:
1685: IF g_level_statement >= g_current_runtime_level THEN
1686: FND_LOG.STRING(g_level_statement,
1687: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1688: 'Inclusive tax flag is defaulted to N. ');
1689: END IF;
1690: END IF; -- tax_amt_included_flag is available from tax

Line 1731: FND_LOG.STRING(g_level_statement,

1727: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1728: p_tax_line_index).tax_amt_included_flag := l_inclusive_tax_flag;
1729:
1730: IF g_level_statement >= g_current_runtime_level THEN
1731: FND_LOG.STRING(g_level_statement,
1732: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1733: 'Get Inclusive_tax_flag from Tax Rate: ' ||
1734: l_inclusive_tax_flag);
1735: END IF;

Line 1746: FND_LOG.STRING(g_level_statement,

1742: --
1743: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1744: p_tax_line_index).tax_amt_included_flag IS NOT NULL THEN
1745: IF g_level_statement >= g_current_runtime_level THEN
1746: FND_LOG.STRING(g_level_statement,
1747: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1748: 'tax_amt_included_flag available from tax registration. ' ||
1749: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1750: p_tax_line_index).tax_amt_included_flag);

Line 1769: FND_LOG.STRING(g_level_statement,

1765: SUBSTRB(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).registration_party_type, 1, 9)
1766: IN ('SHIP_FROM', 'BILL_FROM') THEN
1767: l_inclusive_tax_flag := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tax_inclusive_flg;
1768: IF g_level_statement >= g_current_runtime_level THEN
1769: FND_LOG.STRING(g_level_statement,
1770: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1771: 'For payables the supplier site should be used to get the inclusive flag ' ||
1772: l_inclusive_tax_flag);
1773: END IF;

Line 1785: FND_LOG.STRING(g_level_error ,

1781: p_return_status );
1782:
1783: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1784: IF (g_level_error >= g_current_runtime_level ) THEN
1785: FND_LOG.STRING(g_level_error ,
1786: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1787: 'Incorrect return_status after call ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value().');
1788:
1789: FND_LOG.STRING(g_level_error,

Line 1789: FND_LOG.STRING(g_level_error,

1785: FND_LOG.STRING(g_level_error ,
1786: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1787: 'Incorrect return_status after call ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value().');
1788:
1789: FND_LOG.STRING(g_level_error,
1790: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1791: 'return_status: '|| p_return_status);
1792: END IF;
1793: END IF;

Line 1808: FND_LOG.STRING(g_level_statement,

1804: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1805: p_tax_line_index).tax_amt_included_flag := l_inclusive_tax_flag;
1806:
1807: IF g_level_statement >= g_current_runtime_level THEN
1808: FND_LOG.STRING(g_level_statement,
1809: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1810: 'Get tax_amt_included_flag from SITE PTP: ' ||
1811: l_inclusive_tax_flag);
1812: END IF;

Line 1830: FND_LOG.STRING(g_level_statement,

1826: p_return_status );
1827:
1828: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1829: IF (g_level_statement>= g_current_runtime_level ) THEN
1830: FND_LOG.STRING(g_level_statement,
1831: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1832: 'Incorrect return_status after call ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value().');
1833:
1834: FND_LOG.STRING(g_level_statement,

Line 1834: FND_LOG.STRING(g_level_statement,

1830: FND_LOG.STRING(g_level_statement,
1831: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1832: 'Incorrect return_status after call ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value().');
1833:
1834: FND_LOG.STRING(g_level_statement,
1835: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1836: 'return_status: '|| p_return_status);
1837: END IF;
1838: END IF;

Line 1852: FND_LOG.STRING(g_level_statement,

1848: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1849: p_tax_line_index).tax_amt_included_flag := l_inclusive_tax_flag;
1850:
1851: IF g_level_statement >= g_current_runtime_level THEN
1852: FND_LOG.STRING(g_level_statement,
1853: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1854: 'Get tax_amt_included_flag from PARTY PTP: ' ||
1855: l_inclusive_tax_flag);
1856: END IF;

Line 1870: FND_LOG.STRING(g_level_statement,

1866: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1867: p_tax_line_index).tax_amt_included_flag := l_inclusive_tax_flag;
1868:
1869: IF g_level_statement >= g_current_runtime_level THEN
1870: FND_LOG.STRING(g_level_statement,
1871: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1872: 'Get tax_amt_included_flag from tax: ' ||
1873: l_inclusive_tax_flag);
1874: END IF;

Line 1885: FND_LOG.STRING(g_level_statement,

1881: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1882: p_tax_line_index).tax_amt_included_flag := l_inclusive_tax_flag;
1883:
1884: IF g_level_statement >= g_current_runtime_level THEN
1885: FND_LOG.STRING(g_level_statement,
1886: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1887: 'Inclusive tax flag is defaulted to N. ');
1888: END IF;
1889:

Line 1900: -- FND_LOG.STRING(g_level_unexpected,

1896: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
1897: -- 'populate_inclusive_tax_flag- '|| p_error_buffer);
1898: --FND_MSG_PUB.Add;
1899: --IF (g_level_unexpected >= g_current_runtime_level ) THEN
1900: -- FND_LOG.STRING(g_level_unexpected,
1901: -- 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1902: -- p_error_buffer);
1903: -- FND_LOG.STRING(g_level_unexpected,
1904: -- 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',

Line 1903: -- FND_LOG.STRING(g_level_unexpected,

1899: --IF (g_level_unexpected >= g_current_runtime_level ) THEN
1900: -- FND_LOG.STRING(g_level_unexpected,
1901: -- 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1902: -- p_error_buffer);
1903: -- FND_LOG.STRING(g_level_unexpected,
1904: -- 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1905: -- 'Exception :ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag (-)');
1906: --END IF;
1907: --RETURN;

Line 1917: FND_LOG.STRING(g_level_procedure,

1913: END IF; -- tax_amt_included_flag is avialbale from tax rate
1914: END IF; -- line_amt_includes_tax_flag
1915:
1916: IF (g_level_procedure >= g_current_runtime_level ) THEN
1917: FND_LOG.STRING(g_level_procedure,
1918: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag.END',
1919: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag (-)');
1920: END IF;
1921:

Line 1928: FND_LOG.STRING(g_level_unexpected,

1924: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1925: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1926:
1927: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1928: FND_LOG.STRING(g_level_unexpected,
1929: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1930: p_error_buffer);
1931: END IF;
1932: END populate_inclusive_tax_flag;