DBA Data[Home] [Help]

APPS.ZX_TDS_CALC_PKG dependencies on ZX_TDS_CALC_PKG

Line 1: PACKAGE BODY ZX_TDS_CALC_PKG AS

1: PACKAGE BODY ZX_TDS_CALC_PKG AS
2: /* $Header: zxdicalctaxspkgb.pls 120.37.12020000.2 2012/07/23 12:52:19 srajapar noship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 85: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT.BEGIN',

81: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
82:
83: IF (g_level_procedure >= g_current_runtime_level ) THEN
84: FND_LOG.STRING(g_level_procedure,
85: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT.BEGIN',
86: 'ZX_TDS_CALC_PKG: GET_TAX_AMOUNT (+)');
87: END IF;
88:
89: p_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 86: 'ZX_TDS_CALC_PKG: GET_TAX_AMOUNT (+)');

82:
83: IF (g_level_procedure >= g_current_runtime_level ) THEN
84: FND_LOG.STRING(g_level_procedure,
85: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT.BEGIN',
86: 'ZX_TDS_CALC_PKG: GET_TAX_AMOUNT (+)');
87: END IF;
88:
89: p_return_status:= FND_API.G_RET_STS_SUCCESS;
90: p_error_buffer := NULL;

Line 98: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT.END',

94:
95: IF (g_level_procedure >= g_current_runtime_level ) THEN
96:
97: FND_LOG.STRING(g_level_procedure,
98: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT.END',
99: 'ZX_TDS_CALC_PKG.GET_TAX_AMOUNT (-)'||' skip processing adjustment and credit memo');
100: END IF;
101: RETURN;
102: END IF;

Line 99: 'ZX_TDS_CALC_PKG.GET_TAX_AMOUNT (-)'||' skip processing adjustment and credit memo');

95: IF (g_level_procedure >= g_current_runtime_level ) THEN
96:
97: FND_LOG.STRING(g_level_procedure,
98: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT.END',
99: 'ZX_TDS_CALC_PKG.GET_TAX_AMOUNT (-)'||' skip processing adjustment and credit memo');
100: END IF;
101: RETURN;
102: END IF;
103:

Line 109: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT.END',

105: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
106:
107: IF (g_level_statement >= g_current_runtime_level ) THEN
108: FND_LOG.STRING(g_level_statement,
109: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT.END',
110: 'ZX_TDS_CALC_PKG.GET_TAX_AMOUNT (-)'||' begin index or end index is null');
111: END IF;
112: RETURN;
113: END IF;

Line 110: 'ZX_TDS_CALC_PKG.GET_TAX_AMOUNT (-)'||' begin index or end index is null');

106:
107: IF (g_level_statement >= g_current_runtime_level ) THEN
108: FND_LOG.STRING(g_level_statement,
109: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT.END',
110: 'ZX_TDS_CALC_PKG.GET_TAX_AMOUNT (-)'||' begin index or end index is null');
111: END IF;
112: RETURN;
113: END IF;
114:

Line 119: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',

115: FOR i IN p_begin_index..p_end_index
116: LOOP
117: IF (g_level_statement >= g_current_runtime_level) THEN
118: FND_LOG.STRING(g_level_statement,
119: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',
120: 'Calculating Tax for Tax Line '||TO_CHAR(i));
121: END IF;
122:
123: IF NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).cancel_flag,'N') = 'Y'

Line 127: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',

123: IF NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).cancel_flag,'N') = 'Y'
124: THEN
125: IF (g_level_statement >= g_current_runtime_level) THEN
126: FND_LOG.STRING(g_level_statement,
127: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',
128: 'Canceled Tax Line. Unrounded_Tax_amt = '||
129: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt);
130: END IF;
131: NULL;

Line 142: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',

138: THEN
139:
140: IF (g_level_statement >= g_current_runtime_level) THEN
141: FND_LOG.STRING(g_level_statement,
142: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',
143: 'Zero Amount Reference Tax Line. Unrounded_Tax_amt = '||
144: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt);
145: END IF;
146: NULL;

Line 216: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',

212: l_formula_code:= l_zx_result_rec.alphanumeric_result;
213: IF (g_level_statement >= g_current_runtime_level ) THEN
214:
215: FND_LOG.STRING(g_level_statement,
216: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',
217: 'formula code from rule ' || l_formula_code);
218: END IF;
219: else
220: l_formula_code:= l_def_formula;

Line 224: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',

220: l_formula_code:= l_def_formula;
221: IF (g_level_statement >= g_current_runtime_level ) THEN
222:
223: FND_LOG.STRING(g_level_statement,
224: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',
225: 'default formula code ' || l_formula_code);
226: END IF;
227: end if;
228:

Line 241: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',

237: l_formula_code:= l_def_formula;
238: IF (g_level_statement >= g_current_runtime_level ) THEN
239:
240: FND_LOG.STRING(g_level_statement,
241: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',
242: 'default formula code ' || l_formula_code);
243: END IF;
244:
245: open getFormulaId(l_formula_code);

Line 263: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',

259: IF l_formula_code <> 'STANDARD_TC' AND l_formula_id is not NULL THEN
260:
261: IF (g_level_statement >= g_current_runtime_level ) THEN
262: FND_LOG.STRING(g_level_statement,
263: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',
264: 'Get compounding information...');
265: END IF;
266:
267: open getFormulaInfoD(l_formula_id);

Line 322: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',

318:
319: IF (g_level_statement >= g_current_runtime_level ) THEN
320:
321: FND_LOG.STRING(g_level_statement,
322: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',
323: 'Tax amount is not calculated for tax_id ' || l_d_tax_id );
324: END IF;
325:
326: FND_MESSAGE.SET_NAME('ZX','ZX_COMPND_TAX_NOT_FOUND');

Line 379: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',

375:
376: ELSE
377: IF (g_level_statement >= g_current_runtime_level ) THEN
378: FND_LOG.STRING(g_level_statement,
379: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',
380: 'ELSE CASE ' );
381: END IF;
382: NULL;
383:

Line 397: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',

393:
394:
395: IF (g_level_statement >= g_current_runtime_level ) THEN
396: FND_LOG.STRING(g_level_statement,
397: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',
398: ' Unrounded_Tax_Amt for Tax ' || l_tax_id || ' is '||
399: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt);
400: END IF;
401:

Line 408: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT.END',

404: END LOOP;
405:
406: IF (g_level_procedure >= g_current_runtime_level ) THEN
407: FND_LOG.STRING(g_level_procedure,
408: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT.END',
409: 'ZX_TDS_CALC_PKG: GET_TAX_AMOUNT (-)');
410: END IF;
411:
412: EXCEPTION

Line 409: 'ZX_TDS_CALC_PKG: GET_TAX_AMOUNT (-)');

405:
406: IF (g_level_procedure >= g_current_runtime_level ) THEN
407: FND_LOG.STRING(g_level_procedure,
408: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT.END',
409: 'ZX_TDS_CALC_PKG: GET_TAX_AMOUNT (-)');
410: END IF;
411:
412: EXCEPTION
413: WHEN OTHERS THEN

Line 419: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',

415: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
416:
417: IF (g_level_unexpected >= g_current_runtime_level ) THEN
418: FND_LOG.STRING(g_level_unexpected,
419: 'ZX.PLSQL.ZX_TDS_CALC_PKG.GET_TAX_AMOUNT',
420: p_error_buffer);
421: END IF;
422:
423: END GET_TAX_AMOUNT;

Line 425: END ZX_TDS_CALC_PKG;

421: END IF;
422:
423: END GET_TAX_AMOUNT;
424:
425: END ZX_TDS_CALC_PKG;