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_RATE_DETM_PKG dependencies on ZX_TDS_CALC_SERVICES_PUB_PKG

Line 179: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NOT NULL AND

175:
176: FOR i in p_begin_index..p_end_index LOOP
177:
178:
179: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NOT NULL AND
180: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.source_event_class_code(p_structure_index) = 'INTERCOMPANY_TRX' THEN
181: IF (g_level_statement >= g_current_runtime_level ) THEN
182: FND_LOG.STRING(g_level_statement,
183: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 184: ' Intercompany Transaction : Tax rate : ' || ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate);

180: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.source_event_class_code(p_structure_index) = 'INTERCOMPANY_TRX' THEN
181: IF (g_level_statement >= g_current_runtime_level ) THEN
182: FND_LOG.STRING(g_level_statement,
183: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
184: ' Intercompany Transaction : Tax rate : ' || ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate);
185: END IF;
186: ELSE
187:
188: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_id;

Line 188: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_id;

184: ' Intercompany Transaction : Tax rate : ' || ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate);
185: END IF;
186: ELSE
187:
188: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_id;
189: l_tax := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax;
190: l_tax_status_code :=
191: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code;
192: l_tax_regime_code :=

Line 189: l_tax := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax;

185: END IF;
186: ELSE
187:
188: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_id;
189: l_tax := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax;
190: l_tax_status_code :=
191: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code;
192: l_tax_regime_code :=
193: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code;

Line 191: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code;

187:
188: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_id;
189: l_tax := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax;
190: l_tax_status_code :=
191: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code;
192: l_tax_regime_code :=
193: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code;
194:
195: l_tax_jurisdiction_code :=

Line 193: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code;

189: l_tax := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax;
190: l_tax_status_code :=
191: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code;
192: l_tax_regime_code :=
193: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code;
194:
195: l_tax_jurisdiction_code :=
196: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;
197: l_tax_jurisdiction_id :=

Line 196: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;

192: l_tax_regime_code :=
193: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code;
194:
195: l_tax_jurisdiction_code :=
196: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;
197: l_tax_jurisdiction_id :=
198: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id;
199:
200: --- Bug 7499374

Line 198: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id;

194:
195: l_tax_jurisdiction_code :=
196: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;
197: l_tax_jurisdiction_id :=
198: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id;
199:
200: --- Bug 7499374
201: l_tax_date := NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_date,
202: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);

Line 201: l_tax_date := NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_date,

197: l_tax_jurisdiction_id :=
198: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id;
199:
200: --- Bug 7499374
201: l_tax_date := NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_date,
202: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);
203:
204: IF (g_level_statement >= g_current_runtime_level ) THEN
205: FND_LOG.STRING(g_level_statement,

Line 202: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);

198: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id;
199:
200: --- Bug 7499374
201: l_tax_date := NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_date,
202: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);
203:
204: IF (g_level_statement >= g_current_runtime_level ) THEN
205: FND_LOG.STRING(g_level_statement,
206: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 211: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).multiple_jurisdictions_flag, 'N');

207: ' Tax Date ' || l_tax_date);
208: END IF;
209:
210: l_multiple_jurisdictions_flag :=
211: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).multiple_jurisdictions_flag, 'N');
212:
213: IF (g_level_statement >= g_current_runtime_level ) THEN
214: FND_LOG.STRING(g_level_statement,
215: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 231: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry =

227: -- offset tax lines will not be there in detail tax lines structure for
228: -- create or override case. Hence logic to exclude offset taxes is not included
229:
230:
231: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry =
232: 'TAX_AMOUNT' AND
233: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NULL
234: THEN
235: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR; -- 8568734

Line 233: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NULL

229:
230:
231: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry =
232: 'TAX_AMOUNT' AND
233: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NULL
234: THEN
235: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR; -- 8568734
236: p_error_buffer :=
237: 'Tax Rate must be entered when last manual entry is Tax Amount';

Line 248: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX'

244: END IF;
245:
246: CASE
247: WHEN
248: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX'
249: AND
250: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Recalc_Required_Flag IS NULL OR
251: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Recalc_Required_Flag = 'N'
252: )

Line 250: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Recalc_Required_Flag IS NULL OR

246: CASE
247: WHEN
248: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX'
249: AND
250: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Recalc_Required_Flag IS NULL OR
251: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Recalc_Required_Flag = 'N'
252: )
253: THEN
254:

Line 251: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Recalc_Required_Flag = 'N'

247: WHEN
248: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX'
249: AND
250: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Recalc_Required_Flag IS NULL OR
251: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Recalc_Required_Flag = 'N'
252: )
253: THEN
254:
255: -- RECALC_REQUIRED_FLAG will be populated by tax lines Determination

Line 265: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry in

261: -- Determination columns into detail tax lines structure.
262: NULL;
263:
264: WHEN
265: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry in
266: ('TAX_RATE', 'TAX_AMOUNT','STATUSTORATE' ) -- and -- bug fix 5237144
267: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX'
268: THEN
269: -- Check the last_manual_entry flag and if it is tax_rate or tax_amount or

Line 267: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX'

263:
264: WHEN
265: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry in
266: ('TAX_RATE', 'TAX_AMOUNT','STATUSTORATE' ) -- and -- bug fix 5237144
267: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX'
268: THEN
269: -- Check the last_manual_entry flag and if it is tax_rate or tax_amount or
270: -- status_to_rate, then do not perform this process.
271: /****************changed code for 6903249***************************/

Line 272: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'REFERENCE' AND

268: THEN
269: -- Check the last_manual_entry flag and if it is tax_rate or tax_amount or
270: -- status_to_rate, then do not perform this process.
271: /****************changed code for 6903249***************************/
272: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'REFERENCE' AND
273: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt = 0 AND
274: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_taxable_amt = 0 AND
275: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).manually_entered_flag = 'Y' AND
276: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).freeze_until_overridden_flag ='Y'

Line 273: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt = 0 AND

269: -- Check the last_manual_entry flag and if it is tax_rate or tax_amount or
270: -- status_to_rate, then do not perform this process.
271: /****************changed code for 6903249***************************/
272: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'REFERENCE' AND
273: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt = 0 AND
274: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_taxable_amt = 0 AND
275: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).manually_entered_flag = 'Y' AND
276: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).freeze_until_overridden_flag ='Y'
277: THEN

Line 274: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_taxable_amt = 0 AND

270: -- status_to_rate, then do not perform this process.
271: /****************changed code for 6903249***************************/
272: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'REFERENCE' AND
273: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt = 0 AND
274: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_taxable_amt = 0 AND
275: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).manually_entered_flag = 'Y' AND
276: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).freeze_until_overridden_flag ='Y'
277: THEN
278: NULL;

Line 275: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).manually_entered_flag = 'Y' AND

271: /****************changed code for 6903249***************************/
272: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'REFERENCE' AND
273: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt = 0 AND
274: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_taxable_amt = 0 AND
275: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).manually_entered_flag = 'Y' AND
276: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).freeze_until_overridden_flag ='Y'
277: THEN
278: NULL;
279: ELSE

Line 276: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).freeze_until_overridden_flag ='Y'

272: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'REFERENCE' AND
273: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_tax_amt = 0 AND
274: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).unrounded_taxable_amt = 0 AND
275: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).manually_entered_flag = 'Y' AND
276: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).freeze_until_overridden_flag ='Y'
277: THEN
278: NULL;
279: ELSE
280:

Line 282: l_tax_regime_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code;

278: NULL;
279: ELSE
280:
281: --bug#8679714
282: l_tax_regime_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code;
283: l_tax := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax;
284: l_tax_jurisdiction_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;
285: l_tax_status_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_codE;
286: l_tax_rate_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code;

Line 283: l_tax := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax;

279: ELSE
280:
281: --bug#8679714
282: l_tax_regime_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code;
283: l_tax := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax;
284: l_tax_jurisdiction_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;
285: l_tax_status_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_codE;
286: l_tax_rate_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code;
287:

Line 284: l_tax_jurisdiction_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;

280:
281: --bug#8679714
282: l_tax_regime_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code;
283: l_tax := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax;
284: l_tax_jurisdiction_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;
285: l_tax_status_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_codE;
286: l_tax_rate_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code;
287:
288: l_tax_rate_rec := NULL;

Line 285: l_tax_status_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_codE;

281: --bug#8679714
282: l_tax_regime_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code;
283: l_tax := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax;
284: l_tax_jurisdiction_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;
285: l_tax_status_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_codE;
286: l_tax_rate_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code;
287:
288: l_tax_rate_rec := NULL;
289:

Line 286: l_tax_rate_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code;

282: l_tax_regime_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code;
283: l_tax := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax;
284: l_tax_jurisdiction_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;
285: l_tax_status_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_codE;
286: l_tax_rate_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code;
287:
288: l_tax_rate_rec := NULL;
289:
290: -- Added if condition for Bug#9403476

Line 301: p_place_of_supply_type_code => ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).place_of_supply_type_code,

297: p_tax => l_tax,
298: p_tax_date => l_tax_date,
299: p_tax_status_code => l_tax_status_code,
300: p_tax_rate_code => l_tax_rate_code,
301: p_place_of_supply_type_code => ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).place_of_supply_type_code,
302: p_structure_index => p_structure_index,
303: p_multiple_jurisdictions_flag => l_multiple_jurisdictions_flag,
304: x_tax_rate_rec => l_tax_rate_rec,
305: x_return_status => p_return_status

Line 331: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=

327: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
328: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)'||p_return_status);
329: END IF;
330:
331: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
332: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
333: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
334: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
335:

Line 332: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;

328: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)'||p_return_status);
329: END IF;
330:
331: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
332: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
333: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
334: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
335:
336: ZX_API_PUB.add_msg(

Line 333: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

329: END IF;
330:
331: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
332: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
333: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
334: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
335:
336: ZX_API_PUB.add_msg(
337: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 334: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;

330:
331: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
332: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
333: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
334: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
335:
336: ZX_API_PUB.add_msg(
337: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
338:

Line 337: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

333: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
334: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
335:
336: ZX_API_PUB.add_msg(
337: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
338:
339: RETURN;
340: END IF;
341:

Line 357: AND nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code, 'Z')

353: l_allow_exceptions_flag := l_tax_rate_rec.allow_exceptions_flag;
354:
355: -- Start : Added to fix Bug#9540546
356: IF l_tax_rate_rec.tax_jurisdiction_code IS NOT NULL
357: AND nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code, 'Z')
358: <> l_tax_rate_rec.tax_jurisdiction_code
359: THEN
360: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code
361: := l_tax_rate_rec.tax_jurisdiction_code;

Line 360: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code

356: IF l_tax_rate_rec.tax_jurisdiction_code IS NOT NULL
357: AND nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code, 'Z')
358: <> l_tax_rate_rec.tax_jurisdiction_code
359: THEN
360: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code
361: := l_tax_rate_rec.tax_jurisdiction_code;
362:
363: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id
364: := l_tax_rate_rec.tax_jurisdiction_id;

Line 363: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id

359: THEN
360: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code
361: := l_tax_rate_rec.tax_jurisdiction_code;
362:
363: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id
364: := l_tax_rate_rec.tax_jurisdiction_id;
365: END IF;
366:
367: l_tax_jurisdiction_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;

Line 367: l_tax_jurisdiction_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;

363: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id
364: := l_tax_rate_rec.tax_jurisdiction_id;
365: END IF;
366:
367: l_tax_jurisdiction_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;
368: l_tax_jurisdiction_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id;
369: -- End : Added to fix Bug#9540546
370:
371: IF p_event_class_rec.allow_offset_tax_calc_flag = 'Y' THEN

Line 368: l_tax_jurisdiction_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id;

364: := l_tax_rate_rec.tax_jurisdiction_id;
365: END IF;
366:
367: l_tax_jurisdiction_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;
368: l_tax_jurisdiction_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id;
369: -- End : Added to fix Bug#9540546
370:
371: IF p_event_class_rec.allow_offset_tax_calc_flag = 'Y' THEN
372:

Line 544: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'Y';

540: FND_LOG.STRING(g_level_procedure,
541: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
542: 'Offset tax applicable...');
543: END IF;
544: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'Y';
545: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := l_offset_tax_rate_code;
546: ELSE
547: IF (g_level_statement >= g_current_runtime_level ) THEN
548: FND_LOG.STRING(g_level_statement,

Line 545: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := l_offset_tax_rate_code;

541: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
542: 'Offset tax applicable...');
543: END IF;
544: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'Y';
545: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := l_offset_tax_rate_code;
546: ELSE
547: IF (g_level_statement >= g_current_runtime_level ) THEN
548: FND_LOG.STRING(g_level_statement,
549: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 552: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'N';

548: FND_LOG.STRING(g_level_statement,
549: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
550: 'Offset tax not applicable...');
551: END IF;
552: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'N';
553: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := NULL;
554: END IF; -- l_offset_tax_appl
555: END IF; --p_return_status <> FND_API.G_RET_STS_SUCCESS
556:

Line 553: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := NULL;

549: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
550: 'Offset tax not applicable...');
551: END IF;
552: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'N';
553: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := NULL;
554: END IF; -- l_offset_tax_appl
555: END IF; --p_return_status <> FND_API.G_RET_STS_SUCCESS
556:
557: ELSE -- l_offset_tax_rate_code is NULL

Line 558: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'N';

554: END IF; -- l_offset_tax_appl
555: END IF; --p_return_status <> FND_API.G_RET_STS_SUCCESS
556:
557: ELSE -- l_offset_tax_rate_code is NULL
558: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'N';
559: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := l_offset_tax_rate_code;
560: END IF; --(l_offset_tax_rate_code is NOT NULL)
561: END IF; --p_event_class_rec.allow_offset_tax_calc_flag
562: END IF; --PO matched Not Applicable tax Line

Line 559: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := l_offset_tax_rate_code;

555: END IF; --p_return_status <> FND_API.G_RET_STS_SUCCESS
556:
557: ELSE -- l_offset_tax_rate_code is NULL
558: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'N';
559: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := l_offset_tax_rate_code;
560: END IF; --(l_offset_tax_rate_code is NOT NULL)
561: END IF; --p_event_class_rec.allow_offset_tax_calc_flag
562: END IF; --PO matched Not Applicable tax Line
563:

Line 569: ((ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE = 'ADJUSTED'

565:
566: -- Bug 12346041, added condition to stamp tax rate on AP intercompany credit memo, if the source is adjusted AR credit memo
567:
568: WHEN
569: ((ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE = 'ADJUSTED'
570: AND (NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_structure_index),'SALES_TRANSACTION') <> 'INTERCOMPANY_TRX'
571: OR ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NOT NULL)
572: )
573: OR

Line 571: OR ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NOT NULL)

567:
568: WHEN
569: ((ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE = 'ADJUSTED'
570: AND (NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_structure_index),'SALES_TRANSACTION') <> 'INTERCOMPANY_TRX'
571: OR ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NOT NULL)
572: )
573: OR
574: (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND
575: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag <> 'R')

Line 574: (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND

570: AND (NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_structure_index),'SALES_TRANSACTION') <> 'INTERCOMPANY_TRX'
571: OR ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NOT NULL)
572: )
573: OR
574: (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND
575: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag <> 'R')
576: ) AND
577: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code <> 'OVERRIDE_TAX'
578: THEN

Line 577: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code <> 'OVERRIDE_TAX'

573: OR
574: (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND
575: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag <> 'R')
576: ) AND
577: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code <> 'OVERRIDE_TAX'
578: THEN
579: -- In case when the tax line is copied from Applied From (applied_amt_handling_flag on
580: -- g_tax_rec_tbl(l_tax_id) is NOT 'R' ) or Adjusted Document,
581: -- Applicability process will copy Tax Regime, Tax, Status, Rate, Place of Supply,

Line 590: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Copied_From_Other_Doc_Flag = 'Y' AND

586: NULL;
587:
588: /* bug 3330127 : Included in the next case
589: WHEN
590: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Copied_From_Other_Doc_Flag = 'Y' AND
591: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Manually_Entered_Flag = 'Y'
592: THEN
593: -- When a manual tax line is copied from reference document, the Tax Regime, Tax, Status, Rate,
594: -- and other columns are copied from manual tax line in reference document as well. So

Line 591: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Manually_Entered_Flag = 'Y'

587:
588: /* bug 3330127 : Included in the next case
589: WHEN
590: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Copied_From_Other_Doc_Flag = 'Y' AND
591: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Manually_Entered_Flag = 'Y'
592: THEN
593: -- When a manual tax line is copied from reference document, the Tax Regime, Tax, Status, Rate,
594: -- and other columns are copied from manual tax line in reference document as well. So
595: -- no need to perform tax rate determination in this case.

Line 600: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Freeze_Until_Overridden_Flag = 'Y'

596:
597: NULL;
598: */
599: WHEN
600: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Freeze_Until_Overridden_Flag = 'Y'
601:
602: /* -- Bug 3330127: When user override tax line information, Freeze_Until_Overridden_Flag will
603: -- be set to 'N'
604: AND ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Overridden_Flag <> 'Y'

Line 604: AND ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Overridden_Flag <> 'Y'

600: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Freeze_Until_Overridden_Flag = 'Y'
601:
602: /* -- Bug 3330127: When user override tax line information, Freeze_Until_Overridden_Flag will
603: -- be set to 'N'
604: AND ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Overridden_Flag <> 'Y'
605: OR
606: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Copied_From_Other_Doc_Flag = 'Y' )
607: */
608: THEN

Line 606: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Copied_From_Other_Doc_Flag = 'Y' )

602: /* -- Bug 3330127: When user override tax line information, Freeze_Until_Overridden_Flag will
603: -- be set to 'N'
604: AND ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Overridden_Flag <> 'Y'
605: OR
606: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Copied_From_Other_Doc_Flag = 'Y' )
607: */
608: THEN
609:
610: -- When a manual tax line is copied from reference document, the Tax Regime, Tax, Status, Rate,

Line 627: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id is NOT NULL

623: /* -- bug 4673667: do not need to check delete_flag
624: WHEN
625: -- bug 3330127
626: -- Tax lines calculated by provider will not be pulled in for processing
627: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id is NOT NULL
628: OR
629:
630: UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag) = 'Y'
631: THEN

Line 630: UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag) = 'Y'

626: -- Tax lines calculated by provider will not be pulled in for processing
627: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id is NOT NULL
628: OR
629:
630: UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag) = 'Y'
631: THEN
632: -- Do not perform rate determination for tax lines calculated by providers
633: -- or for tax lines marked for deletion.
634:

Line 641: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code is null

637: WHEN
638: -- Bug 10273603
639: (NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_structure_index),'SALES_TRANSACTION') <> 'INTERCOMPANY_TRX' AND
640: (
641: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code is null
642: /* -- Bug 3330127: already handled in the above cases
643: AND
644: nvl(upper(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag),'N') <> 'Y' AND
645: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id is NULL

Line 644: nvl(upper(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag),'N') <> 'Y' AND

640: (
641: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code is null
642: /* -- Bug 3330127: already handled in the above cases
643: AND
644: nvl(upper(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag),'N') <> 'Y' AND
645: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id is NULL
646: */
647: ) OR
648: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry IN

Line 645: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id is NULL

641: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code is null
642: /* -- Bug 3330127: already handled in the above cases
643: AND
644: nvl(upper(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag),'N') <> 'Y' AND
645: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id is NULL
646: */
647: ) OR
648: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry IN
649: ('TAX_STATUS', 'TAX_RATE_CODE') -- AND --bug 5237144

Line 648: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry IN

644: nvl(upper(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag),'N') <> 'Y' AND
645: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id is NULL
646: */
647: ) OR
648: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry IN
649: ('TAX_STATUS', 'TAX_RATE_CODE') -- AND --bug 5237144
650: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX'
651: ) OR
652: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND

Line 650: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX'

646: */
647: ) OR
648: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry IN
649: ('TAX_STATUS', 'TAX_RATE_CODE') -- AND --bug 5237144
650: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX'
651: ) OR
652: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND
653: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'R'
654: ) OR

Line 652: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND

648: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry IN
649: ('TAX_STATUS', 'TAX_RATE_CODE') -- AND --bug 5237144
650: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX'
651: ) OR
652: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND
653: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'R'
654: ) OR
655: -- Bug 5176149: need to populate tax rate id and tax rate % for matched invoice
656: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE = 'REFERENCE'

Line 656: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE = 'REFERENCE'

652: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND
653: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'R'
654: ) OR
655: -- Bug 5176149: need to populate tax rate id and tax rate % for matched invoice
656: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE = 'REFERENCE'
657: ) OR
658: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).direct_rate_result_id IS NOT NULL
659: ) OR
660: ( p_event_class_rec.template_usage_code = 'TAX_RULES' AND

Line 658: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).direct_rate_result_id IS NOT NULL

654: ) OR
655: -- Bug 5176149: need to populate tax rate id and tax rate % for matched invoice
656: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE = 'REFERENCE'
657: ) OR
658: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).direct_rate_result_id IS NOT NULL
659: ) OR
660: ( p_event_class_rec.template_usage_code = 'TAX_RULES' AND
661: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NOT NULL
662: )

Line 661: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NOT NULL

657: ) OR
658: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).direct_rate_result_id IS NOT NULL
659: ) OR
660: ( p_event_class_rec.template_usage_code = 'TAX_RULES' AND
661: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NOT NULL
662: )
663: )
664: ) OR
665: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_structure_index) = 'INTERCOMPANY_TRX' AND

Line 666: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NOT NULL AND

662: )
663: )
664: ) OR
665: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_structure_index) = 'INTERCOMPANY_TRX' AND
666: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NOT NULL AND
667: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NULL
668: )
669: THEN
670: -- This is the normal processing case where rate determination needs to be performed

Line 667: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NULL

663: )
664: ) OR
665: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_structure_index) = 'INTERCOMPANY_TRX' AND
666: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NOT NULL AND
667: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NULL
668: )
669: THEN
670: -- This is the normal processing case where rate determination needs to be performed
671: -- When tax is not calculated by provider service and rate is not already

Line 676: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).process_for_recovery_flag:= 'Y';

672: -- available in detail tax lines structure and delete flag is not 'Y'
673: -- or an override case with last_manual_entry as 'TAX_STATUS', then determine
674: -- the tax rate to be applied to the tax line.
675:
676: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).process_for_recovery_flag:= 'Y';
677:
678: -- IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NOT NULL
679: -- bug 3330127: if last_manual_entry = 'TAX_STATUS', UI should set tax_rate_code to NULL
680: -- AND nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry,'N') <> 'TAX_STATUS'

Line 678: -- IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NOT NULL

674: -- the tax rate to be applied to the tax line.
675:
676: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).process_for_recovery_flag:= 'Y';
677:
678: -- IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NOT NULL
679: -- bug 3330127: if last_manual_entry = 'TAX_STATUS', UI should set tax_rate_code to NULL
680: -- AND nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry,'N') <> 'TAX_STATUS'
681: -- THEN
682: --

Line 680: -- AND nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry,'N') <> 'TAX_STATUS'

676: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).process_for_recovery_flag:= 'Y';
677:
678: -- IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NOT NULL
679: -- bug 3330127: if last_manual_entry = 'TAX_STATUS', UI should set tax_rate_code to NULL
680: -- AND nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry,'N') <> 'TAX_STATUS'
681: -- THEN
682: --
683: -- tax rate is already available on tax line. Use this tax rate
684: --

Line 685: -- l_tax_rate_code:= ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code;

681: -- THEN
682: --
683: -- tax rate is already available on tax line. Use this tax rate
684: --
685: -- l_tax_rate_code:= ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code;
686: --
687: -- ELSE -- get rate code
688:
689: -- If tax rate code is available on tax line. Use this tax rate.

Line 692: l_tax_rate_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code;

688:
689: -- If tax rate code is available on tax line. Use this tax rate.
690: -- Otherwise, need to determine tax rate code
691: --
692: l_tax_rate_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code;
693:
694: IF l_tax_rate_code IS NULL THEN
695:
696: -- select the tax rate rule flag from tax status cache

Line 743: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date,

739: p_structure_index,
740: p_event_class_rec,
741: l_tax_id,
742: l_tax_status_code,
743: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date,
744: NULL,
745: NULL,
746: l_zx_result_rec,
747: p_return_status,

Line 762: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

758: RETURN;
759: END IF;
760:
761: l_tax_rate_code:= l_zx_result_rec.alphanumeric_result;
762: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
763: i).rate_result_id := l_zx_result_rec.result_id;
764: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
765: i).legal_message_rate :=
766: ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(l_zx_result_rec.result_id,

Line 764: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

760:
761: l_tax_rate_code:= l_zx_result_rec.alphanumeric_result;
762: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
763: i).rate_result_id := l_zx_result_rec.result_id;
764: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
765: i).legal_message_rate :=
766: ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(l_zx_result_rec.result_id,
767: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_date);
768:

Line 766: ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(l_zx_result_rec.result_id,

762: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
763: i).rate_result_id := l_zx_result_rec.result_id;
764: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
765: i).legal_message_rate :=
766: ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(l_zx_result_rec.result_id,
767: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_date);
768:
769: IF (g_level_statement >= g_current_runtime_level ) THEN
770: FND_LOG.STRING(g_level_statement,

Line 767: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_date);

763: i).rate_result_id := l_zx_result_rec.result_id;
764: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
765: i).legal_message_rate :=
766: ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(l_zx_result_rec.result_id,
767: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_date);
768:
769: IF (g_level_statement >= g_current_runtime_level ) THEN
770: FND_LOG.STRING(g_level_statement,
771: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 789: p_place_of_supply_type_code => ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

785: p_tax => l_tax,
786: p_tax_date => l_tax_date,
787: p_tax_status_code => l_tax_status_code,
788: p_tax_rate_code => l_tax_rate_code,
789: p_place_of_supply_type_code => ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
790: i).place_of_supply_type_code,
791: p_structure_index => p_structure_index,
792: p_multiple_jurisdictions_flag => l_multiple_jurisdictions_flag,
793: x_tax_rate_rec => l_tax_rate_rec,

Line 809: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=

805: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)'||p_return_status);
806: END IF;
807:
808: -- in TCM, the error msg already saved on fnd msg stack
809: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
810: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
811: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
812: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
813:

Line 810: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;

806: END IF;
807:
808: -- in TCM, the error msg already saved on fnd msg stack
809: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
810: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
811: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
812: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
813:
814: ZX_API_PUB.add_msg(

Line 811: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

807:
808: -- in TCM, the error msg already saved on fnd msg stack
809: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
810: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
811: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
812: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
813:
814: ZX_API_PUB.add_msg(
815: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 812: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;

808: -- in TCM, the error msg already saved on fnd msg stack
809: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
810: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
811: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
812: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
813:
814: ZX_API_PUB.add_msg(
815: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
816:

Line 815: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

811: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
812: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
813:
814: ZX_API_PUB.add_msg(
815: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
816:
817: RETURN;
818: END IF;
819:

Line 840: AND nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code, 'Z')

836: -- tax line. Here the tax_jurisdition_id is got from he jurisdiction gtt.
837: -- NOTE: multiple_jurisdictions_flag won't change during override event
838:
839: IF l_tax_rate_rec.tax_jurisdiction_code IS NOT NULL
840: AND nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code, 'Z')
841: <> l_tax_rate_rec.tax_jurisdiction_code
842: THEN
843: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code
844: := l_tax_rate_rec.tax_jurisdiction_code;

Line 843: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code

839: IF l_tax_rate_rec.tax_jurisdiction_code IS NOT NULL
840: AND nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code, 'Z')
841: <> l_tax_rate_rec.tax_jurisdiction_code
842: THEN
843: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code
844: := l_tax_rate_rec.tax_jurisdiction_code;
845:
846: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id
847: := l_tax_rate_rec.tax_jurisdiction_id;

Line 846: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id

842: THEN
843: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code
844: := l_tax_rate_rec.tax_jurisdiction_code;
845:
846: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id
847: := l_tax_rate_rec.tax_jurisdiction_id;
848:
849: END IF; --l_tax_rate_rec.tax_jurisdiction_code IS NOT NULL
850:

Line 851: l_tax_jurisdiction_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;

847: := l_tax_rate_rec.tax_jurisdiction_id;
848:
849: END IF; --l_tax_rate_rec.tax_jurisdiction_code IS NOT NULL
850:
851: l_tax_jurisdiction_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;
852: l_tax_jurisdiction_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id;
853:
854: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(l_tax_rate_id) THEN
855: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id) := l_tax_rate_rec;

Line 852: l_tax_jurisdiction_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id;

848:
849: END IF; --l_tax_rate_rec.tax_jurisdiction_code IS NOT NULL
850:
851: l_tax_jurisdiction_code := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_code;
852: l_tax_jurisdiction_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_jurisdiction_id;
853:
854: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(l_tax_rate_id) THEN
855: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id) := l_tax_rate_rec;
856: END IF;

Line 860: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code:=

856: END IF;
857:
858: IF l_tax_rate_code IS NOT NULL THEN
859:
860: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code:=
861: l_tax_rate_code;
862: IF l_Rate_Type_Code = 'SLABBED' THEN
863:
864: -- slabbed rate not supported in phase 1a;

Line 886: -- IF l_uom_code <> ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).uom_code THEN

882:
883: -- For quantity based rates, if the UOM_CODE on the transaction does
884: -- not match the UOM_CODE on the rate, then raise error.
885:
886: -- IF l_uom_code <> ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).uom_code THEN
887: IF l_uom_code <>
888: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.uom_code(p_structure_index)
889: THEN
890: -- Raise error;

Line 912: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=

908: FND_MESSAGE.SET_TOKEN('UOM_TRX',
909: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.uom_code(p_structure_index) );
910:
911: -- FND_MSG_PUB.Add;
912: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
913: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
914: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
915: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
916:

Line 913: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;

909: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.uom_code(p_structure_index) );
910:
911: -- FND_MSG_PUB.Add;
912: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
913: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
914: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
915: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
916:
917: ZX_API_PUB.add_msg(

Line 914: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

910:
911: -- FND_MSG_PUB.Add;
912: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
913: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
914: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
915: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
916:
917: ZX_API_PUB.add_msg(
918: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 915: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;

911: -- FND_MSG_PUB.Add;
912: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
913: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
914: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
915: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
916:
917: ZX_API_PUB.add_msg(
918: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
919:

Line 918: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

914: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
915: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
916:
917: ZX_API_PUB.add_msg(
918: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
919:
920: RETURN;
921: END IF;
922:

Line 947: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=

943: FND_MESSAGE.SET_TOKEN('TAX_STATUS',l_tax_status_code);
944: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',l_tax_date); -- 8568734
945: --FND_MSG_PUB.Add;
946:
947: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
948: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
949: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
950: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
951:

Line 948: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;

944: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',l_tax_date); -- 8568734
945: --FND_MSG_PUB.Add;
946:
947: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
948: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
949: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
950: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
951:
952: ZX_API_PUB.add_msg(

Line 949: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

945: --FND_MSG_PUB.Add;
946:
947: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
948: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
949: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
950: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
951:
952: ZX_API_PUB.add_msg(
953: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 950: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;

946:
947: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
948: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
949: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
950: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
951:
952: ZX_API_PUB.add_msg(
953: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
954:

Line 953: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

949: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
950: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
951:
952: ZX_API_PUB.add_msg(
953: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
954:
955: RETURN;
956:
957: END IF; -- l_tax_rate_code is NOT NULL

Line 978: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=

974: FND_MESSAGE.SET_TOKEN('TAX_STATUS',l_tax_status_code);
975: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',l_tax_date);
976: --FND_MSG_PUB.Add;
977:
978: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
979: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
980: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
981: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
982:

Line 979: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;

975: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',l_tax_date);
976: --FND_MSG_PUB.Add;
977:
978: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
979: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
980: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
981: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
982:
983: ZX_API_PUB.add_msg(

Line 980: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

976: --FND_MSG_PUB.Add;
977:
978: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
979: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
980: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
981: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
982:
983: ZX_API_PUB.add_msg(
984: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 981: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;

977:
978: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
979: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
980: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
981: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
982:
983: ZX_API_PUB.add_msg(
984: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
985:

Line 984: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

980: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
981: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
982:
983: ZX_API_PUB.add_msg(
984: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
985:
986: p_error_buffer := 'Error: No tax rate found';
987: IF (g_level_error >= g_current_runtime_level ) THEN
988: FND_LOG.STRING(g_level_error,

Line 1003: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag = 'Y'

999: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1000: p_structure_index) IN ('CREATE', 'UPDATE')
1001: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
1002: p_structure_index) = 'INTERCOMPANY_TRX'
1003: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag = 'Y'
1004: THEN
1005:
1006: -- for intercompany the Offset_Flag on detail tax line marked as 'Y'
1007: -- only when the offset_tax_rate_code is not null, so no need to check

Line 1038: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1034: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');
1035: END IF;
1036: RETURN;
1037: ELSE
1038: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1039: i).offset_tax_rate_code := l_offset_tax_rate_code;
1040: END IF;
1041:
1042: ELSIF p_event_class_rec.allow_offset_tax_calc_flag = 'Y' THEN

Line 1051: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source,'X') NOT IN ('APPLIED_FROM', 'ADJUSTED') THEN

1047: -- perform applicability process for offset tax;
1048: --
1049: --bug8517610
1050: IF l_offset_tax_rate_code IS NOT NULL AND
1051: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source,'X') NOT IN ('APPLIED_FROM', 'ADJUSTED') THEN
1052:
1053: validate_offset_tax (
1054: p_tax_regime_code => l_tax_regime_code,
1055: p_tax => l_offset_tax,

Line 1239: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date,

1235: -- p_structure_index,
1236: -- p_event_class_rec,
1237: -- l_tax_id,
1238: -- l_tax_status_code,
1239: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date,
1240: -- l_offset_rule_code,
1241: -- null,
1242: -- l_zx_result_rec,
1243: -- p_return_status,

Line 1276: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'Y';

1272: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1273: 'Offset tax applicable...');
1274: END IF;
1275:
1276: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'Y';
1277:
1278:
1279: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1280: i).offset_tax_rate_code := l_offset_tax_rate_code;

Line 1279: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1275:
1276: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'Y';
1277:
1278:
1279: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1280: i).offset_tax_rate_code := l_offset_tax_rate_code;
1281: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1282: -- i).offset_tax_line_number :=
1283: -- NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number,0)+ 1;

Line 1281: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1277:
1278:
1279: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1280: i).offset_tax_rate_code := l_offset_tax_rate_code;
1281: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1282: -- i).offset_tax_line_number :=
1283: -- NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number,0)+ 1;
1284: ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number :=
1285: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number,0)+ 1;

Line 1283: -- NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number,0)+ 1;

1279: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1280: i).offset_tax_rate_code := l_offset_tax_rate_code;
1281: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1282: -- i).offset_tax_line_number :=
1283: -- NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number,0)+ 1;
1284: ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number :=
1285: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number,0)+ 1;
1286:
1287: --IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1284: ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number :=

1280: i).offset_tax_rate_code := l_offset_tax_rate_code;
1281: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1282: -- i).offset_tax_line_number :=
1283: -- NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number,0)+ 1;
1284: ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number :=
1285: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number,0)+ 1;
1286:
1287: --IF (g_level_statement >= g_current_runtime_level ) THEN
1288: -- FND_LOG.STRING(g_level_statement,

Line 1285: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number,0)+ 1;

1281: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1282: -- i).offset_tax_line_number :=
1283: -- NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number,0)+ 1;
1284: ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number :=
1285: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number,0)+ 1;
1286:
1287: --IF (g_level_statement >= g_current_runtime_level ) THEN
1288: -- FND_LOG.STRING(g_level_statement,
1289: -- 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 1291: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1287: --IF (g_level_statement >= g_current_runtime_level ) THEN
1288: -- FND_LOG.STRING(g_level_statement,
1289: -- 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1290: -- 'offset_tax_line_number = '||
1291: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1292: -- i).offset_tax_line_number);
1293: --END IF;
1294: ELSE
1295: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1301: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'N';

1297: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1298: 'Offset tax not applicable...');
1299: END IF;
1300:
1301: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'N';
1302: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := NULL;
1303: END IF; -- l_offset_tax_appl
1304: --END IF; -- p_return_status
1305: END IF; -- p_return_status after validate_offset_tax

Line 1302: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := NULL;

1298: 'Offset tax not applicable...');
1299: END IF;
1300:
1301: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'N';
1302: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := NULL;
1303: END IF; -- l_offset_tax_appl
1304: --END IF; -- p_return_status
1305: END IF; -- p_return_status after validate_offset_tax
1306: ELSE -- l_offset_tax_rate_code is NULL

Line 1307: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'N';

1303: END IF; -- l_offset_tax_appl
1304: --END IF; -- p_return_status
1305: END IF; -- p_return_status after validate_offset_tax
1306: ELSE -- l_offset_tax_rate_code is NULL
1307: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'N';
1308: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := l_offset_tax_rate_code;
1309: END IF; -- l_offset_tax_rate_code
1310: END IF; -- p_event_class_rec.allow_offset_tax_calc_flag = 'Y'
1311:

Line 1308: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := l_offset_tax_rate_code;

1304: --END IF; -- p_return_status
1305: END IF; -- p_return_status after validate_offset_tax
1306: ELSE -- l_offset_tax_rate_code is NULL
1307: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'N';
1308: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := l_offset_tax_rate_code;
1309: END IF; -- l_offset_tax_rate_code
1310: END IF; -- p_event_class_rec.allow_offset_tax_calc_flag = 'Y'
1311:
1312: -- When tax_event_type in the Event Class structure is 'OVERRIDE_TAX', tax rate

Line 1318: IF nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry,'N') = 'TAX_STATUS'

1314: -- After tax rate is determined for the line whose last_manual_entry =
1315: -- 'TAX_STATUS', last_manual_entry will be updated to 'STATUSTORATE'.
1316:
1317:
1318: IF nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry,'N') = 'TAX_STATUS'
1319: THEN
1320: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry := 'STATUSTORATE';
1321:
1322: END IF;

Line 1320: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry := 'STATUSTORATE';

1316:
1317:
1318: IF nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry,'N') = 'TAX_STATUS'
1319: THEN
1320: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry := 'STATUSTORATE';
1321:
1322: END IF;
1323:
1324: -- Bug 3973763: If direc_rate_result_id IS NOT NULL, check if

Line 1329: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).direct_rate_result_id IS NOT NULL

1325: -- numeric_result is populated. If yes, check if tax is adhoc. If yes,
1326: -- populate this value to tax_rate field, if not, check if
1327: -- l_tax_rate = l_numeric_result. If not, raise error.
1328: --
1329: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).direct_rate_result_id IS NOT NULL
1330: THEN
1331:
1332: OPEN get_numeric_value_csr(
1333: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).direct_rate_result_id);

Line 1333: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).direct_rate_result_id);

1329: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).direct_rate_result_id IS NOT NULL
1330: THEN
1331:
1332: OPEN get_numeric_value_csr(
1333: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).direct_rate_result_id);
1334: FETCH get_numeric_value_csr INTO l_numeric_result;
1335: CLOSE get_numeric_value_csr;
1336:
1337: IF l_numeric_result IS NOT NULL THEN

Line 1355: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=

1351: -- Bug 8568734: add a new message
1352: FND_MESSAGE.SET_NAME('ZX','ZX_EXCEPTION_RATE');
1353: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE', l_tax_rate_code);
1354:
1355: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1356: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
1357: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
1359:

Line 1356: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;

1352: FND_MESSAGE.SET_NAME('ZX','ZX_EXCEPTION_RATE');
1353: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE', l_tax_rate_code);
1354:
1355: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1356: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
1357: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
1359:
1360: ZX_API_PUB.add_msg(

Line 1357: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

1353: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE', l_tax_rate_code);
1354:
1355: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1356: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
1357: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
1359:
1360: ZX_API_PUB.add_msg(
1361: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 1358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;

1354:
1355: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1356: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
1357: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
1359:
1360: ZX_API_PUB.add_msg(
1361: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1362:

Line 1361: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

1357: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
1359:
1360: ZX_API_PUB.add_msg(
1361: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1362:
1363:
1364: IF (g_level_error >= g_current_runtime_level) THEN
1365: FND_LOG.STRING(g_level_error,

Line 1386: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exception_rate IS NOT NULL THEN

1382: END IF;
1383:
1384: --bug6604498
1385:
1386: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exception_rate IS NOT NULL THEN
1387: l_tax_rate := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exception_rate;
1388: END IF;
1389:
1390: -- Process Tax Exceptions

Line 1387: l_tax_rate := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exception_rate;

1383:
1384: --bug6604498
1385:
1386: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exception_rate IS NOT NULL THEN
1387: l_tax_rate := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exception_rate;
1388: END IF;
1389:
1390: -- Process Tax Exceptions
1391: IF l_allow_exceptions_flag ='Y' THEN

Line 1435: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1431: RETURN;
1432: END IF;
1433:
1434: IF l_exception_rec.tax_exception_id IS NOT NULL THEN
1435: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1436: i).TAX_EXCEPTION_ID := l_exception_rec.tax_exception_id;
1437:
1438: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1439: i).EXCEPTION_RATE := l_exception_rec.exception_rate;

Line 1438: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1434: IF l_exception_rec.tax_exception_id IS NOT NULL THEN
1435: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1436: i).TAX_EXCEPTION_ID := l_exception_rec.tax_exception_id;
1437:
1438: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1439: i).EXCEPTION_RATE := l_exception_rec.exception_rate;
1440:
1441: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1442: i).TAX_RATE_BEFORE_EXCEPTION := l_tax_rate;

Line 1441: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1437:
1438: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1439: i).EXCEPTION_RATE := l_exception_rec.exception_rate;
1440:
1441: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1442: i).TAX_RATE_BEFORE_EXCEPTION := l_tax_rate;
1443:
1444: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1445: i).TAX_RATE_NAME_BEFORE_EXCEPTION := l_tax_rate_code;

Line 1444: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1440:
1441: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1442: i).TAX_RATE_BEFORE_EXCEPTION := l_tax_rate;
1443:
1444: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1445: i).TAX_RATE_NAME_BEFORE_EXCEPTION := l_tax_rate_code;
1446:
1447: IF l_exception_rec.exception_type_code = 'SPECIAL_RATE' THEN
1448: l_tax_rate := l_exception_rec.exception_rate;

Line 1563: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=

1559: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)'||p_return_status);
1560: END IF;
1561:
1562: -- in TCM, the error msg already saved on fnd msg stack
1563: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1564: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
1565: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1566: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
1567:

Line 1564: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;

1560: END IF;
1561:
1562: -- in TCM, the error msg already saved on fnd msg stack
1563: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1564: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
1565: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1566: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
1567:
1568: ZX_API_PUB.add_msg(

Line 1565: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

1561:
1562: -- in TCM, the error msg already saved on fnd msg stack
1563: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1564: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
1565: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1566: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
1567:
1568: ZX_API_PUB.add_msg(
1569: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 1566: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;

1562: -- in TCM, the error msg already saved on fnd msg stack
1563: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1564: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
1565: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1566: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
1567:
1568: ZX_API_PUB.add_msg(
1569: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1570:

Line 1569: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

1565: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1566: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
1567:
1568: ZX_API_PUB.add_msg(
1569: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1570:
1571: RETURN;
1572: END IF;
1573:

Line 1593: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1589: END IF;
1590:
1591: IF l_exemption_rec.exemption_id IS NOT NULL THEN
1592:
1593: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1594: i).tax_exemption_id := l_exemption_rec.exemption_id;
1595:
1596: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1597: i).tax_rate_before_exemption := l_tax_rate;

Line 1596: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1592:
1593: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1594: i).tax_exemption_id := l_exemption_rec.exemption_id;
1595:
1596: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1597: i).tax_rate_before_exemption := l_tax_rate;
1598:
1599: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1600: i).tax_rate_name_before_exemption := l_tax_rate_code;

Line 1599: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1595:
1596: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1597: i).tax_rate_before_exemption := l_tax_rate;
1598:
1599: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1600: i).tax_rate_name_before_exemption := l_tax_rate_code;
1601:
1602: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1603: -- i).exempt_certificate_number

Line 1602: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1598:
1599: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1600: i).tax_rate_name_before_exemption := l_tax_rate_code;
1601:
1602: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1603: -- i).exempt_certificate_number
1604: -- := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.exempt_certificate_number(
1605: -- p_structure_index);
1606:

Line 1607: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1603: -- i).exempt_certificate_number
1604: -- := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.exempt_certificate_number(
1605: -- p_structure_index);
1606:
1607: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1608: -- i).exempt_reason
1609: -- := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.exempt_reason(
1610: -- p_structure_index);
1611:

Line 1612: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1608: -- i).exempt_reason
1609: -- := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.exempt_reason(
1610: -- p_structure_index);
1611:
1612: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1613: -- i).exempt_reason_code
1614: -- := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.exempt_reason_code(
1615: -- p_structure_index);
1616: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exempt_certificate_number

Line 1616: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exempt_certificate_number

1612: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1613: -- i).exempt_reason_code
1614: -- := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.exempt_reason_code(
1615: -- p_structure_index);
1616: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exempt_certificate_number
1617: := l_exemption_rec.exempt_certificate_number;
1618:
1619: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exempt_reason
1620: := l_exemption_rec.exempt_reason;

Line 1619: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exempt_reason

1615: -- p_structure_index);
1616: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exempt_certificate_number
1617: := l_exemption_rec.exempt_certificate_number;
1618:
1619: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exempt_reason
1620: := l_exemption_rec.exempt_reason;
1621:
1622: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exempt_reason_code
1623: := l_exemption_rec.exempt_reason_code;

Line 1622: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exempt_reason_code

1618:
1619: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exempt_reason
1620: := l_exemption_rec.exempt_reason;
1621:
1622: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exempt_reason_code
1623: := l_exemption_rec.exempt_reason_code;
1624:
1625:
1626: IF l_exemption_rec.discount_special_rate = 'SPECIAL_RATE' THEN

Line 1629: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exempt_rate_modifier

1625:
1626: IF l_exemption_rec.discount_special_rate = 'SPECIAL_RATE' THEN
1627:
1628: IF l_tax_rate <> 0 THEN
1629: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exempt_rate_modifier
1630: := l_exemption_rec.percent_exempt / l_tax_rate;
1631: l_tax_rate := l_exemption_rec.percent_exempt;
1632: ELSE
1633: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1641: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exempt_rate_modifier

1637: END IF;
1638: END IF;
1639:
1640: ELSE -- l_exemption_rec.discount_special_rate = 'DISCOUNT' THEN
1641: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).exempt_rate_modifier
1642: := (l_exemption_rec.percent_exempt)/100; -- Bug8206838
1643:
1644: if nvl(l_exemption_rec.percent_exempt,0)>100 then
1645: l_tax_rate := l_tax_rate*(l_exemption_rec.percent_exempt)/100;

Line 1656: update_tax_rate(-- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl,

1652: END IF; -- l_exemption_rec.exemption_id IS NOT NULL
1653:
1654: END IF; -- p_event_class_rec.allow_exemptions_flag ='Y'
1655:
1656: update_tax_rate(-- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl,
1657: i,
1658: l_tax_rate_code,
1659: l_tax_rate,
1660: l_tax_rate_id,

Line 1671: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate is NOT NULL

1667: -- ***** should the validation of rate be done ?
1668:
1669: -- If the rate is available then validate whether the tax rate can be used
1670: -- for the transaction
1671: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate is NOT NULL
1672: -- AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id is NULL
1673: -- AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag <> 'Y'
1674: THEN
1675: -- check whether the tax rate is ad-hoc

Line 1672: -- AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id is NULL

1668:
1669: -- If the rate is available then validate whether the tax rate can be used
1670: -- for the transaction
1671: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate is NOT NULL
1672: -- AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id is NULL
1673: -- AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag <> 'Y'
1674: THEN
1675: -- check whether the tax rate is ad-hoc
1676:

Line 1673: -- AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag <> 'Y'

1669: -- If the rate is available then validate whether the tax rate can be used
1670: -- for the transaction
1671: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate is NOT NULL
1672: -- AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id is NULL
1673: -- AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag <> 'Y'
1674: THEN
1675: -- check whether the tax rate is ad-hoc
1676:
1677: /* commented out for bug 3420310, the following check should have been done on the UI

Line 1714: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry = 'TAX_RATE' THEN

1710: -- the tax line. if this was an override case, and if last_manual_entry
1711: -- is Tax Amount, then the rate should not be available on the Tax Line.
1712:
1713: IF l_adhoc_tax_rate_flg <> 'Y'
1714: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry = 'TAX_RATE' THEN
1715:
1716: p_return_status:= FND_API.G_RET_STS_ERROR;
1717: p_error_buffer := 'You cannot specify a rate percentage on a tax which '||
1718: ' is not ad-hoc';

Line 1730: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Copied_From_Other_Doc_Flag = 'Y'

1726:
1727: END IF;
1728: end commented out for bug 3420310 */
1729:
1730: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Copied_From_Other_Doc_Flag = 'Y'
1731: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Manually_Entered_Flag <> 'Y'
1732: THEN
1733: -- The tax was prorated based on reference document; validate that
1734: -- the tax rate is valid for the transaction date.

Line 1731: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Manually_Entered_Flag <> 'Y'

1727: END IF;
1728: end commented out for bug 3420310 */
1729:
1730: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Copied_From_Other_Doc_Flag = 'Y'
1731: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Manually_Entered_Flag <> 'Y'
1732: THEN
1733: -- The tax was prorated based on reference document; validate that
1734: -- the tax rate is valid for the transaction date.
1735:

Line 1736: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date >=

1732: THEN
1733: -- The tax was prorated based on reference document; validate that
1734: -- the tax rate is valid for the transaction date.
1735:
1736: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date >=
1737: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from
1738: and ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date <=
1739: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to
1740: THEN

Line 1738: and ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date <=

1734: -- the tax rate is valid for the transaction date.
1735:
1736: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date >=
1737: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from
1738: and ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date <=
1739: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to
1740: THEN
1741: NULL;
1742:

Line 1746: to_char(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);

1742:
1743: else
1744: p_return_status:= FND_API.G_RET_STS_ERROR;
1745: p_error_buffer := 'The rate is not valid for the tax determination date'||
1746: to_char(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);
1747: IF (g_level_error >= g_current_runtime_level ) THEN
1748: FND_LOG.STRING(g_level_error,
1749: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1750: 'p_error_buffer: '|| p_error_buffer);

Line 1756: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax);

1752:
1753: -- bug 8568734: use ZX_RATE_NOT_FOUND
1754: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_NOT_FOUND');
1755: FND_MESSAGE.SET_TOKEN('TAX',
1756: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax);
1757: FND_MESSAGE.SET_TOKEN('TAX_STATUS',
1758: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code);
1759: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',
1760: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);

Line 1758: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code);

1754: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_NOT_FOUND');
1755: FND_MESSAGE.SET_TOKEN('TAX',
1756: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax);
1757: FND_MESSAGE.SET_TOKEN('TAX_STATUS',
1758: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code);
1759: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',
1760: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);
1761:
1762: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=

Line 1760: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);

1756: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax);
1757: FND_MESSAGE.SET_TOKEN('TAX_STATUS',
1758: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code);
1759: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',
1760: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);
1761:
1762: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1763: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
1764: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

Line 1762: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=

1758: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code);
1759: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',
1760: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);
1761:
1762: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1763: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
1764: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1765: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
1766:

Line 1763: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;

1759: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',
1760: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);
1761:
1762: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1763: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
1764: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1765: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
1766:
1767: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 1764: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

1760: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);
1761:
1762: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1763: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
1764: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1765: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
1766:
1767: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1768:

Line 1765: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;

1761:
1762: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1763: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
1764: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1765: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
1766:
1767: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1768:
1769: RETURN;

Line 1767: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

1763: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id;
1764: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1765: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type;
1766:
1767: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1768:
1769: RETURN;
1770: END IF;
1771: END IF;

Line 1803: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl in out nocopy zx_api_pub.detail_tax_line_tbl_type,

1799:
1800:
1801:
1802: PROCEDURE UPDATE_TAX_RATE(
1803: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl in out nocopy zx_api_pub.detail_tax_line_tbl_type,
1804: p_tax_line_index in number,
1805: p_tax_rate_code in zx_lines.tax_rate_code%TYPE,
1806: p_tax_rate in zx_lines.tax_rate%TYPE,
1807: p_tax_rate_id in number,

Line 1820: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_code:= p_tax_rate_code;

1816: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.update_tax_rate.BEGIN',
1817: 'ZX_TDS_RATE_DETM_PKG.update_tax_rate(+) ');
1818: END IF;
1819:
1820: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_code:= p_tax_rate_code;
1821: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate:= p_tax_rate;
1822: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_id := p_tax_rate_id ;
1823: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_type := p_Rate_Type_Code;
1824: BEGIN

Line 1821: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate:= p_tax_rate;

1817: 'ZX_TDS_RATE_DETM_PKG.update_tax_rate(+) ');
1818: END IF;
1819:
1820: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_code:= p_tax_rate_code;
1821: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate:= p_tax_rate;
1822: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_id := p_tax_rate_id ;
1823: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_type := p_Rate_Type_Code;
1824: BEGIN
1825: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate IS NULL THEN

Line 1822: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_id := p_tax_rate_id ;

1818: END IF;
1819:
1820: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_code:= p_tax_rate_code;
1821: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate:= p_tax_rate;
1822: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_id := p_tax_rate_id ;
1823: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_type := p_Rate_Type_Code;
1824: BEGIN
1825: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate IS NULL THEN
1826: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate := NULL;

Line 1823: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_type := p_Rate_Type_Code;

1819:
1820: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_code:= p_tax_rate_code;
1821: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate:= p_tax_rate;
1822: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_id := p_tax_rate_id ;
1823: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_type := p_Rate_Type_Code;
1824: BEGIN
1825: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate IS NULL THEN
1826: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate := NULL;
1827: END IF;

Line 1825: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate IS NULL THEN

1821: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate:= p_tax_rate;
1822: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_id := p_tax_rate_id ;
1823: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_type := p_Rate_Type_Code;
1824: BEGIN
1825: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate IS NULL THEN
1826: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate := NULL;
1827: END IF;
1828: EXCEPTION WHEN OTHERS THEN
1829: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate := NULL;

Line 1826: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate := NULL;

1822: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_id := p_tax_rate_id ;
1823: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_type := p_Rate_Type_Code;
1824: BEGIN
1825: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate IS NULL THEN
1826: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate := NULL;
1827: END IF;
1828: EXCEPTION WHEN OTHERS THEN
1829: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate := NULL;
1830: END;

Line 1829: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate := NULL;

1825: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate IS NULL THEN
1826: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate := NULL;
1827: END IF;
1828: EXCEPTION WHEN OTHERS THEN
1829: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate := NULL;
1830: END;
1831:
1832: IF (g_level_procedure >= g_current_runtime_level ) THEN
1833: FND_LOG.STRING(g_level_procedure,