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

Line 150: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.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:
154: p_return_status:= FND_API.G_RET_STS_SUCCESS;

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

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

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

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

Line 161: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)'||

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;
164: RETURN;
165: END IF;

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

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

Line 180: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)'||

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;
183: RETURN;
184: END IF;

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

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:
192: FOR i IN p_begin_index..p_end_index LOOP

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

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
200: IF NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).cancel_flag,'N') = 'Y'

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

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

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

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

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

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

Line 264: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag');

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

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

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

Line 267: '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;
270: END IF;
271: END IF;

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

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:
304: -- RECALC_REQUIRED_FLAG will be populated by tax lines Determination

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

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

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

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

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

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

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

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:
393: -- Do not perform taxable basis determination for provider calculated lines. Taxes

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

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:
410: -- In case when the tax line is copied from 'Applied From' or 'Adjusted' Document,

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

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:
438: -- When a manual tax line is copied from reference document, the Tax Regime, Tax, Status, Rate,

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

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:
465: -- When the transaction is matched to a reference document, and if a tax

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

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:
492: -- Initialize compounding_dep_tax_flag and compounding_tax_miss_flag

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

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
529: --use cache

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

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

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

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

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

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

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

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

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

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

Line 609: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.GET_TAXABLE_BASIS (-)'||

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;
612: RETURN;
613: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
750:
751: CLOSE getFormulaInfoH;

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

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||
759: ' Volume_Discount_Appl_Flag: '||l_volume_discount_appl_flag||

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

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

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

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

Line 800: '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;
803: END IF;
804:

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

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:
852: parameter_tbl(l_tax_id).discount:= nvl(l_discount_amt,0);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1045: '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;
1048: ELSE
1049: -- bug 3644541: set compounding_tax_miss_flag

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

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

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

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

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

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

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

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

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

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

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

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

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

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',
1150: 'Starting Loop for Updating columns ...');

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

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:
1153: FOR i IN p_begin_index..p_end_index LOOP

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

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:
1169: CASE

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

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

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

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

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

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

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

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

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

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

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

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:
1266: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_line_amt <> 0 THEN

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

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

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

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:
1306: -- A migrated invoice can have 2 tax lines with same Regime and Tax

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

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

Line 1387: -- 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

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

Line 1393: -- 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis.END',

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

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

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;
1397: --END IF;
1398: --CLOSE getAdhocInfo;

Line 1417: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_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',
1421: 'Allow_adhoc_tax_rate_flag : ' ||l_allow_adhoc_tax_rate_flag);

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

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:
1424: IF l_allow_adhoc_tax_rate_flag = 'N' OR

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:
1572: EXCEPTION
1573: WHEN OTHERS THEN

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

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

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

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

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

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

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

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
1661: IF NVL(ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

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

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
1679: -- Bug 4778841: default l_inclusive_tax_flag to 'Y' when it is NULL

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

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
1691: END IF; -- tax_amt_included_flag is available from tax rate

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1919: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_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:
1922: EXCEPTION
1923: WHEN OTHERS THEN

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

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

Line 1934: END ZX_TDS_TAXABLE_BASIS_DETM_PKG;

1930: p_error_buffer);
1931: END IF;
1932: END populate_inclusive_tax_flag;
1933:
1934: END ZX_TDS_TAXABLE_BASIS_DETM_PKG;