DBA Data[Home] [Help]

APPS.ZX_TDS_CALC_PKG dependencies on FND_LOG

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

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;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:

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

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;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: ------------------------------------------------------------------------------

Line 7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: ------------------------------------------------------------------------------
11: -- PUBLIC PROCEDURE

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

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_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: ------------------------------------------------------------------------------
11: -- PUBLIC PROCEDURE
12: -- GET_TAX_AMOUNT

Line 81: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

77: where formula_code = c_formula_code;
78:
79:
80: 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',

Line 84: FND_LOG.STRING(g_level_procedure,

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

Line 97: FND_LOG.STRING(g_level_procedure,

93: p_structure_index) IS NOT NULL THEN
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;

Line 108: FND_LOG.STRING(g_level_statement,

104: IF p_begin_index IS NULL OR p_end_index IS NULL THEN
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;

Line 118: FND_LOG.STRING(g_level_statement,

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

Line 126: FND_LOG.STRING(g_level_statement,

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

Line 141: FND_LOG.STRING(g_level_statement,

137: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).freeze_until_overridden_flag ='Y'
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;

Line 215: FND_LOG.STRING(g_level_statement,

211: if l_zx_result_rec.alphanumeric_result is not null then
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

Line 223: FND_LOG.STRING(g_level_statement,

219: else
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;

Line 240: FND_LOG.STRING(g_level_statement,

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

Line 262: FND_LOG.STRING(g_level_statement,

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

Line 321: FND_LOG.STRING(g_level_statement,

317: p_return_status:= FND_API.G_RET_STS_ERROR;
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:

Line 378: FND_LOG.STRING(g_level_statement,

374: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_amt:= NULL;
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;

Line 396: FND_LOG.STRING(g_level_statement,

392: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt;
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;

Line 407: FND_LOG.STRING(g_level_procedure,

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

Line 418: FND_LOG.STRING(g_level_unexpected,

414: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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: