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_AR_FORMULA_MIG_PKG dependencies on ARP_UTIL_TAX

Line 176: arp_util_tax.debug('ZX_AR_FORMULA_MIG_PKG.FORMULA_MIGRATION_MAIN(+)');

172: -- for conflicting tax groups---------------------
173:
174: BEGIN
175:
176: arp_util_tax.debug('ZX_AR_FORMULA_MIG_PKG.FORMULA_MIGRATION_MAIN(+)');
177:
178: -- Initialize API return status to success
179: x_return_status := FND_API.G_RET_STS_SUCCESS;
180:

Line 185: arp_util_tax.debug('CASE 1: open cursor');

181: -- Case 1 Tax Codes in AR_VAT_TAX
182:
183: OPEN get_tax_cur;
184: i := 0;
185: arp_util_tax.debug('CASE 1: open cursor');
186:
187: LOOP
188:
189: arp_util_tax.debug('i='||i);

Line 189: arp_util_tax.debug('i='||i);

185: arp_util_tax.debug('CASE 1: open cursor');
186:
187: LOOP
188:
189: arp_util_tax.debug('i='||i);
190: i := i+1;
191:
192: FETCH get_tax_cur INTO
193: l_child_taxable_basis,

Line 208: arp_util_tax.debug('case1:l_child_taxable_basis:'||l_child_taxable_basis);

204:
205: l_condition_grp_cd := NULL;
206: l_condition_grp_id := NULL;
207:
208: arp_util_tax.debug('case1:l_child_taxable_basis:'||l_child_taxable_basis);
209: arp_util_tax.debug('case1:l_tax_code:'||l_tax_code);
210: arp_util_tax.debug('case1:l_tax:'||l_tax);
211: arp_util_tax.debug('case1:l_tax_regime_code:'||l_tax_regime_code);
212: arp_util_tax.debug('case1:l_content_owner_id:'||l_content_owner_id);

Line 209: arp_util_tax.debug('case1:l_tax_code:'||l_tax_code);

205: l_condition_grp_cd := NULL;
206: l_condition_grp_id := NULL;
207:
208: arp_util_tax.debug('case1:l_child_taxable_basis:'||l_child_taxable_basis);
209: arp_util_tax.debug('case1:l_tax_code:'||l_tax_code);
210: arp_util_tax.debug('case1:l_tax:'||l_tax);
211: arp_util_tax.debug('case1:l_tax_regime_code:'||l_tax_regime_code);
212: arp_util_tax.debug('case1:l_content_owner_id:'||l_content_owner_id);
213: arp_util_tax.debug('CASE 1: before select');

Line 210: arp_util_tax.debug('case1:l_tax:'||l_tax);

206: l_condition_grp_id := NULL;
207:
208: arp_util_tax.debug('case1:l_child_taxable_basis:'||l_child_taxable_basis);
209: arp_util_tax.debug('case1:l_tax_code:'||l_tax_code);
210: arp_util_tax.debug('case1:l_tax:'||l_tax);
211: arp_util_tax.debug('case1:l_tax_regime_code:'||l_tax_regime_code);
212: arp_util_tax.debug('case1:l_content_owner_id:'||l_content_owner_id);
213: arp_util_tax.debug('CASE 1: before select');
214:

Line 211: arp_util_tax.debug('case1:l_tax_regime_code:'||l_tax_regime_code);

207:
208: arp_util_tax.debug('case1:l_child_taxable_basis:'||l_child_taxable_basis);
209: arp_util_tax.debug('case1:l_tax_code:'||l_tax_code);
210: arp_util_tax.debug('case1:l_tax:'||l_tax);
211: arp_util_tax.debug('case1:l_tax_regime_code:'||l_tax_regime_code);
212: arp_util_tax.debug('case1:l_content_owner_id:'||l_content_owner_id);
213: arp_util_tax.debug('CASE 1: before select');
214:
215: BEGIN

Line 212: arp_util_tax.debug('case1:l_content_owner_id:'||l_content_owner_id);

208: arp_util_tax.debug('case1:l_child_taxable_basis:'||l_child_taxable_basis);
209: arp_util_tax.debug('case1:l_tax_code:'||l_tax_code);
210: arp_util_tax.debug('case1:l_tax:'||l_tax);
211: arp_util_tax.debug('case1:l_tax_regime_code:'||l_tax_regime_code);
212: arp_util_tax.debug('case1:l_content_owner_id:'||l_content_owner_id);
213: arp_util_tax.debug('CASE 1: before select');
214:
215: BEGIN
216:

Line 213: arp_util_tax.debug('CASE 1: before select');

209: arp_util_tax.debug('case1:l_tax_code:'||l_tax_code);
210: arp_util_tax.debug('case1:l_tax:'||l_tax);
211: arp_util_tax.debug('case1:l_tax_regime_code:'||l_tax_regime_code);
212: arp_util_tax.debug('case1:l_content_owner_id:'||l_content_owner_id);
213: arp_util_tax.debug('CASE 1: before select');
214:
215: BEGIN
216:
217: SELECT condition_group_id, condition_group_code

Line 223: arp_util_tax.debug('Case1: error for tax '||l_tax_code||' Error:'||sqlerrm);

219: FROM zx_condition_groups_b
220: WHERE condition_group_code = l_tax_code;
221:
222: EXCEPTION WHEN OTHERS THEN
223: arp_util_tax.debug('Case1: error for tax '||l_tax_code||' Error:'||sqlerrm);
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: END;
226:
227: arp_util_tax.debug('case1:l_condition_grp_id:'||l_condition_grp_id);

Line 227: arp_util_tax.debug('case1:l_condition_grp_id:'||l_condition_grp_id);

223: arp_util_tax.debug('Case1: error for tax '||l_tax_code||' Error:'||sqlerrm);
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: END;
226:
227: arp_util_tax.debug('case1:l_condition_grp_id:'||l_condition_grp_id);
228: arp_util_tax.debug('case1:l_condition_grp_cd:'||l_condition_grp_cd);
229:
230: IF l_child_taxable_basis = 'AFTER_EPD' THEN
231: l_alphanumeric_result := 'STANDARD_TB_DISCOUNT';

Line 228: arp_util_tax.debug('case1:l_condition_grp_cd:'||l_condition_grp_cd);

224: x_return_status := FND_API.G_RET_STS_ERROR;
225: END;
226:
227: arp_util_tax.debug('case1:l_condition_grp_id:'||l_condition_grp_id);
228: arp_util_tax.debug('case1:l_condition_grp_cd:'||l_condition_grp_cd);
229:
230: IF l_child_taxable_basis = 'AFTER_EPD' THEN
231: l_alphanumeric_result := 'STANDARD_TB_DISCOUNT';
232: ELSIF l_child_taxable_basis = 'QUANTITY' THEN

Line 239: arp_util_tax.debug('CASE 1: in if.before create_rules');

235:
236: IF (l_child_taxable_basis = 'AFTER_EPD' OR l_child_taxable_basis = 'QUANTITY')
237: AND (l_condition_grp_cd IS NOT NULL) THEN
238:
239: arp_util_tax.debug('CASE 1: in if.before create_rules');
240: create_rules ( l_tax,
241: l_tax_regime_code,
242: l_start_date,
243: l_end_date,

Line 253: arp_util_tax.debug('CASE 1:after create_rules');

249: NULL, -- for tax_condition_id
250: NULL, -- for tax_exception_id
251: x_msg_data
252: );
253: arp_util_tax.debug('CASE 1:after create_rules');
254: END IF;
255:
256: IF l_child_taxable_basis = 'PL/SQL formula' THEN
257: -- open issue

Line 273: arp_util_tax.debug('ZX_AR_FORMULA_MIG_PKG.fORMULA_MIGRATION_MAIN()--> in CASE 3');

269: /**********************(This case is not required)***************/
270:
271:
272: -- Case 3 Tax groups, which have compounding precedence but do not have compounding branches
273: arp_util_tax.debug('ZX_AR_FORMULA_MIG_PKG.fORMULA_MIGRATION_MAIN()--> in CASE 3');
274: i:=0 ;
275: OPEN get_taxgrp_cur;
276:
277: -- Assigning variable g_tax_group to null

Line 306: arp_util_tax.debug('i='||i);

302:
303: --(for precedence 1, there is no need for formula, we can use the STANDARD_TB formula)
304: -- so working for precedence <> 1
305:
306: arp_util_tax.debug('i='||i);
307: arp_util_tax.debug('l_group_id'||l_group_id);
308: arp_util_tax.debug('l_tax_group_code '||l_tax_group_code);
309: arp_util_tax.debug('l_parent_tax_code '||l_parent_tax_code);
310: arp_util_tax.debug('l_parent_precedence '||l_parent_precedence);

Line 307: arp_util_tax.debug('l_group_id'||l_group_id);

303: --(for precedence 1, there is no need for formula, we can use the STANDARD_TB formula)
304: -- so working for precedence <> 1
305:
306: arp_util_tax.debug('i='||i);
307: arp_util_tax.debug('l_group_id'||l_group_id);
308: arp_util_tax.debug('l_tax_group_code '||l_tax_group_code);
309: arp_util_tax.debug('l_parent_tax_code '||l_parent_tax_code);
310: arp_util_tax.debug('l_parent_precedence '||l_parent_precedence);
311: arp_util_tax.debug('l_parent_regime_code '||l_parent_regime_code);

Line 308: arp_util_tax.debug('l_tax_group_code '||l_tax_group_code);

304: -- so working for precedence <> 1
305:
306: arp_util_tax.debug('i='||i);
307: arp_util_tax.debug('l_group_id'||l_group_id);
308: arp_util_tax.debug('l_tax_group_code '||l_tax_group_code);
309: arp_util_tax.debug('l_parent_tax_code '||l_parent_tax_code);
310: arp_util_tax.debug('l_parent_precedence '||l_parent_precedence);
311: arp_util_tax.debug('l_parent_regime_code '||l_parent_regime_code);
312: arp_util_tax.debug('l_child_tax_code '||l_child_tax_code );

Line 309: arp_util_tax.debug('l_parent_tax_code '||l_parent_tax_code);

305:
306: arp_util_tax.debug('i='||i);
307: arp_util_tax.debug('l_group_id'||l_group_id);
308: arp_util_tax.debug('l_tax_group_code '||l_tax_group_code);
309: arp_util_tax.debug('l_parent_tax_code '||l_parent_tax_code);
310: arp_util_tax.debug('l_parent_precedence '||l_parent_precedence);
311: arp_util_tax.debug('l_parent_regime_code '||l_parent_regime_code);
312: arp_util_tax.debug('l_child_tax_code '||l_child_tax_code );
313: arp_util_tax.debug('l_child_precedence '||l_child_precedence );

Line 310: arp_util_tax.debug('l_parent_precedence '||l_parent_precedence);

306: arp_util_tax.debug('i='||i);
307: arp_util_tax.debug('l_group_id'||l_group_id);
308: arp_util_tax.debug('l_tax_group_code '||l_tax_group_code);
309: arp_util_tax.debug('l_parent_tax_code '||l_parent_tax_code);
310: arp_util_tax.debug('l_parent_precedence '||l_parent_precedence);
311: arp_util_tax.debug('l_parent_regime_code '||l_parent_regime_code);
312: arp_util_tax.debug('l_child_tax_code '||l_child_tax_code );
313: arp_util_tax.debug('l_child_precedence '||l_child_precedence );
314: arp_util_tax.debug('l_child_regime_code '||l_child_regime_code);

Line 311: arp_util_tax.debug('l_parent_regime_code '||l_parent_regime_code);

307: arp_util_tax.debug('l_group_id'||l_group_id);
308: arp_util_tax.debug('l_tax_group_code '||l_tax_group_code);
309: arp_util_tax.debug('l_parent_tax_code '||l_parent_tax_code);
310: arp_util_tax.debug('l_parent_precedence '||l_parent_precedence);
311: arp_util_tax.debug('l_parent_regime_code '||l_parent_regime_code);
312: arp_util_tax.debug('l_child_tax_code '||l_child_tax_code );
313: arp_util_tax.debug('l_child_precedence '||l_child_precedence );
314: arp_util_tax.debug('l_child_regime_code '||l_child_regime_code);
315: arp_util_tax.debug('l_child_taxable_basis '||l_child_taxable_basis);

Line 312: arp_util_tax.debug('l_child_tax_code '||l_child_tax_code );

308: arp_util_tax.debug('l_tax_group_code '||l_tax_group_code);
309: arp_util_tax.debug('l_parent_tax_code '||l_parent_tax_code);
310: arp_util_tax.debug('l_parent_precedence '||l_parent_precedence);
311: arp_util_tax.debug('l_parent_regime_code '||l_parent_regime_code);
312: arp_util_tax.debug('l_child_tax_code '||l_child_tax_code );
313: arp_util_tax.debug('l_child_precedence '||l_child_precedence );
314: arp_util_tax.debug('l_child_regime_code '||l_child_regime_code);
315: arp_util_tax.debug('l_child_taxable_basis '||l_child_taxable_basis);
316: arp_util_tax.debug('l_branch '||l_branch);

Line 313: arp_util_tax.debug('l_child_precedence '||l_child_precedence );

309: arp_util_tax.debug('l_parent_tax_code '||l_parent_tax_code);
310: arp_util_tax.debug('l_parent_precedence '||l_parent_precedence);
311: arp_util_tax.debug('l_parent_regime_code '||l_parent_regime_code);
312: arp_util_tax.debug('l_child_tax_code '||l_child_tax_code );
313: arp_util_tax.debug('l_child_precedence '||l_child_precedence );
314: arp_util_tax.debug('l_child_regime_code '||l_child_regime_code);
315: arp_util_tax.debug('l_child_taxable_basis '||l_child_taxable_basis);
316: arp_util_tax.debug('l_branch '||l_branch);
317: arp_util_tax.debug('l_enabled_flag '||l_enabled_flag);

Line 314: arp_util_tax.debug('l_child_regime_code '||l_child_regime_code);

310: arp_util_tax.debug('l_parent_precedence '||l_parent_precedence);
311: arp_util_tax.debug('l_parent_regime_code '||l_parent_regime_code);
312: arp_util_tax.debug('l_child_tax_code '||l_child_tax_code );
313: arp_util_tax.debug('l_child_precedence '||l_child_precedence );
314: arp_util_tax.debug('l_child_regime_code '||l_child_regime_code);
315: arp_util_tax.debug('l_child_taxable_basis '||l_child_taxable_basis);
316: arp_util_tax.debug('l_branch '||l_branch);
317: arp_util_tax.debug('l_enabled_flag '||l_enabled_flag);
318: arp_util_tax.debug('l_start_date '||l_start_date);

Line 315: arp_util_tax.debug('l_child_taxable_basis '||l_child_taxable_basis);

311: arp_util_tax.debug('l_parent_regime_code '||l_parent_regime_code);
312: arp_util_tax.debug('l_child_tax_code '||l_child_tax_code );
313: arp_util_tax.debug('l_child_precedence '||l_child_precedence );
314: arp_util_tax.debug('l_child_regime_code '||l_child_regime_code);
315: arp_util_tax.debug('l_child_taxable_basis '||l_child_taxable_basis);
316: arp_util_tax.debug('l_branch '||l_branch);
317: arp_util_tax.debug('l_enabled_flag '||l_enabled_flag);
318: arp_util_tax.debug('l_start_date '||l_start_date);
319: arp_util_tax.debug('l_end_date '||l_end_date);

Line 316: arp_util_tax.debug('l_branch '||l_branch);

312: arp_util_tax.debug('l_child_tax_code '||l_child_tax_code );
313: arp_util_tax.debug('l_child_precedence '||l_child_precedence );
314: arp_util_tax.debug('l_child_regime_code '||l_child_regime_code);
315: arp_util_tax.debug('l_child_taxable_basis '||l_child_taxable_basis);
316: arp_util_tax.debug('l_branch '||l_branch);
317: arp_util_tax.debug('l_enabled_flag '||l_enabled_flag);
318: arp_util_tax.debug('l_start_date '||l_start_date);
319: arp_util_tax.debug('l_end_date '||l_end_date);
320: arp_util_tax.debug('l_tax_condition_id '||l_tax_condition_id);

Line 317: arp_util_tax.debug('l_enabled_flag '||l_enabled_flag);

313: arp_util_tax.debug('l_child_precedence '||l_child_precedence );
314: arp_util_tax.debug('l_child_regime_code '||l_child_regime_code);
315: arp_util_tax.debug('l_child_taxable_basis '||l_child_taxable_basis);
316: arp_util_tax.debug('l_branch '||l_branch);
317: arp_util_tax.debug('l_enabled_flag '||l_enabled_flag);
318: arp_util_tax.debug('l_start_date '||l_start_date);
319: arp_util_tax.debug('l_end_date '||l_end_date);
320: arp_util_tax.debug('l_tax_condition_id '||l_tax_condition_id);
321: arp_util_tax.debug('l_tax_exception_id '||l_tax_exception_id);

Line 318: arp_util_tax.debug('l_start_date '||l_start_date);

314: arp_util_tax.debug('l_child_regime_code '||l_child_regime_code);
315: arp_util_tax.debug('l_child_taxable_basis '||l_child_taxable_basis);
316: arp_util_tax.debug('l_branch '||l_branch);
317: arp_util_tax.debug('l_enabled_flag '||l_enabled_flag);
318: arp_util_tax.debug('l_start_date '||l_start_date);
319: arp_util_tax.debug('l_end_date '||l_end_date);
320: arp_util_tax.debug('l_tax_condition_id '||l_tax_condition_id);
321: arp_util_tax.debug('l_tax_exception_id '||l_tax_exception_id);
322: arp_util_tax.debug('l_content_owner_id '||l_content_owner_id);

Line 319: arp_util_tax.debug('l_end_date '||l_end_date);

315: arp_util_tax.debug('l_child_taxable_basis '||l_child_taxable_basis);
316: arp_util_tax.debug('l_branch '||l_branch);
317: arp_util_tax.debug('l_enabled_flag '||l_enabled_flag);
318: arp_util_tax.debug('l_start_date '||l_start_date);
319: arp_util_tax.debug('l_end_date '||l_end_date);
320: arp_util_tax.debug('l_tax_condition_id '||l_tax_condition_id);
321: arp_util_tax.debug('l_tax_exception_id '||l_tax_exception_id);
322: arp_util_tax.debug('l_content_owner_id '||l_content_owner_id);
323: arp_util_tax.debug('l_tax_regime_code '||l_tax_regime_code);

Line 320: arp_util_tax.debug('l_tax_condition_id '||l_tax_condition_id);

316: arp_util_tax.debug('l_branch '||l_branch);
317: arp_util_tax.debug('l_enabled_flag '||l_enabled_flag);
318: arp_util_tax.debug('l_start_date '||l_start_date);
319: arp_util_tax.debug('l_end_date '||l_end_date);
320: arp_util_tax.debug('l_tax_condition_id '||l_tax_condition_id);
321: arp_util_tax.debug('l_tax_exception_id '||l_tax_exception_id);
322: arp_util_tax.debug('l_content_owner_id '||l_content_owner_id);
323: arp_util_tax.debug('l_tax_regime_code '||l_tax_regime_code);
324: arp_util_tax.debug('l_tax '||l_tax);

Line 321: arp_util_tax.debug('l_tax_exception_id '||l_tax_exception_id);

317: arp_util_tax.debug('l_enabled_flag '||l_enabled_flag);
318: arp_util_tax.debug('l_start_date '||l_start_date);
319: arp_util_tax.debug('l_end_date '||l_end_date);
320: arp_util_tax.debug('l_tax_condition_id '||l_tax_condition_id);
321: arp_util_tax.debug('l_tax_exception_id '||l_tax_exception_id);
322: arp_util_tax.debug('l_content_owner_id '||l_content_owner_id);
323: arp_util_tax.debug('l_tax_regime_code '||l_tax_regime_code);
324: arp_util_tax.debug('l_tax '||l_tax);
325: i := i+1;

Line 322: arp_util_tax.debug('l_content_owner_id '||l_content_owner_id);

318: arp_util_tax.debug('l_start_date '||l_start_date);
319: arp_util_tax.debug('l_end_date '||l_end_date);
320: arp_util_tax.debug('l_tax_condition_id '||l_tax_condition_id);
321: arp_util_tax.debug('l_tax_exception_id '||l_tax_exception_id);
322: arp_util_tax.debug('l_content_owner_id '||l_content_owner_id);
323: arp_util_tax.debug('l_tax_regime_code '||l_tax_regime_code);
324: arp_util_tax.debug('l_tax '||l_tax);
325: i := i+1;
326:

Line 323: arp_util_tax.debug('l_tax_regime_code '||l_tax_regime_code);

319: arp_util_tax.debug('l_end_date '||l_end_date);
320: arp_util_tax.debug('l_tax_condition_id '||l_tax_condition_id);
321: arp_util_tax.debug('l_tax_exception_id '||l_tax_exception_id);
322: arp_util_tax.debug('l_content_owner_id '||l_content_owner_id);
323: arp_util_tax.debug('l_tax_regime_code '||l_tax_regime_code);
324: arp_util_tax.debug('l_tax '||l_tax);
325: i := i+1;
326:
327: IF l_child_precedence <> 1 THEN

Line 324: arp_util_tax.debug('l_tax '||l_tax);

320: arp_util_tax.debug('l_tax_condition_id '||l_tax_condition_id);
321: arp_util_tax.debug('l_tax_exception_id '||l_tax_exception_id);
322: arp_util_tax.debug('l_content_owner_id '||l_content_owner_id);
323: arp_util_tax.debug('l_tax_regime_code '||l_tax_regime_code);
324: arp_util_tax.debug('l_tax '||l_tax);
325: i := i+1;
326:
327: IF l_child_precedence <> 1 THEN
328:

Line 343: arp_util_tax.debug('case 3:l_formula_code:'||l_formula_code);

339: END IF;
340:
341: -- For width Issue (formula_code is VARCHAR2(30) only)
342:
343: arp_util_tax.debug('case 3:l_formula_code:'||l_formula_code);
344:
345: l_charge_flag := 'N';
346:
347: IF l_child_taxable_basis = 'AFTER_EPD' THEN

Line 355: arp_util_tax.debug('case 3:before create_formula');

351: ELSE
352: l_discount_flag := 'N';
353: END IF;
354:
355: arp_util_tax.debug('case 3:before create_formula');
356:
357: create_formula (l_child_taxable_basis, -- values can be equal to or <> to 'PRIOR_TAX'
358: l_formula_code,
359: l_child_regime_code,

Line 375: arp_util_tax.debug('case 3:after create_formula');

371: l_tax,
372: x_msg_data
373: );
374:
375: arp_util_tax.debug('case 3:after create_formula');
376:
377: -- For creation of rules
378: --Check if the condition group code exists with condition group code as follows
379: -- if exists populate it in local variables

Line 385: arp_util_tax.debug('case 3:bef select');

381: l_condition_grp_cd := NULL;
382: l_condition_grp_id := NULL;
383:
384: BEGIN
385: arp_util_tax.debug('case 3:bef select');
386:
387: SELECT vat.tax_constraint_id
388: INTO l_tax_constraint_id
389: FROM ar_vat_tax_all vat

Line 402: arp_util_tax.debug('Case 3:error for tax '||l_child_tax_code||' error:'||sqlerrm);

398: substrb(l_tax_group_code,1,40)||'~'||l_tax_constraint_id)
399: );
400:
401: EXCEPTION WHEN OTHERS THEN
402: arp_util_tax.debug('Case 3:error for tax '||l_child_tax_code||' error:'||sqlerrm);
403: x_return_status := FND_API.G_RET_STS_ERROR;
404:
405: END;
406:

Line 412: arp_util_tax.debug('case 3:before create_rules ');

408: l_alphanumeric_result := l_formula_code;
409:
410: IF l_condition_grp_cd IS NOT NULL THEN
411:
412: arp_util_tax.debug('case 3:before create_rules ');
413: create_rules ( l_tax,
414: l_tax_regime_code,
415: l_start_date,
416: l_end_date,

Line 428: arp_util_tax.debug('case 3: ');

424: x_msg_data
425: );
426: END IF;
427:
428: arp_util_tax.debug('case 3: ');
429: END IF;
430: EXIT WHEN get_taxgrp_cur%NOTFOUND;
431: END LOOP;
432:

Line 439: arp_util_tax.debug('case 4: IN CASE4');

435: -- Case 4 Tax groups which have compounding branches
436: OPEN get_taxgrp_cmp_cur;
437:
438: i:=0;
439: arp_util_tax.debug('case 4: IN CASE4');
440: -- Assigning variable g_group_id to null
441: g_group_id := NULL;
442: g_child_tax_code := NULL;
443: g_child_regime_code := NULL;

Line 447: arp_util_tax.debug('case 4: i='||i);

443: g_child_regime_code := NULL;
444:
445: LOOP
446:
447: arp_util_tax.debug('case 4: i='||i);
448: i := i+1;
449:
450: FETCH get_taxgrp_cmp_cur INTO
451: l_group_id,

Line 471: arp_util_tax.debug('case 4: l_group_id:'||l_group_id);

467: l_tax_group_id,
468: l_tax_regime_code,
469: l_tax;
470:
471: arp_util_tax.debug('case 4: l_group_id:'||l_group_id);
472: arp_util_tax.debug('case 4: l_child_tax_code:'||l_child_tax_code);
473: arp_util_tax.debug('case 4: l_child_regime_code:'||l_child_regime_code);
474: arp_util_tax.debug('case 4: l_child_precedence:'||l_child_precedence);
475:

Line 472: arp_util_tax.debug('case 4: l_child_tax_code:'||l_child_tax_code);

468: l_tax_regime_code,
469: l_tax;
470:
471: arp_util_tax.debug('case 4: l_group_id:'||l_group_id);
472: arp_util_tax.debug('case 4: l_child_tax_code:'||l_child_tax_code);
473: arp_util_tax.debug('case 4: l_child_regime_code:'||l_child_regime_code);
474: arp_util_tax.debug('case 4: l_child_precedence:'||l_child_precedence);
475:
476: --Assigning value for new group

Line 473: arp_util_tax.debug('case 4: l_child_regime_code:'||l_child_regime_code);

469: l_tax;
470:
471: arp_util_tax.debug('case 4: l_group_id:'||l_group_id);
472: arp_util_tax.debug('case 4: l_child_tax_code:'||l_child_tax_code);
473: arp_util_tax.debug('case 4: l_child_regime_code:'||l_child_regime_code);
474: arp_util_tax.debug('case 4: l_child_precedence:'||l_child_precedence);
475:
476: --Assigning value for new group
477: IF l_group_id <> g_group_id THEN

Line 474: arp_util_tax.debug('case 4: l_child_precedence:'||l_child_precedence);

470:
471: arp_util_tax.debug('case 4: l_group_id:'||l_group_id);
472: arp_util_tax.debug('case 4: l_child_tax_code:'||l_child_tax_code);
473: arp_util_tax.debug('case 4: l_child_regime_code:'||l_child_regime_code);
474: arp_util_tax.debug('case 4: l_child_precedence:'||l_child_precedence);
475:
476: --Assigning value for new group
477: IF l_group_id <> g_group_id THEN
478: arp_util_tax.debug('case 4:in if g_group_id IS NULL->'||g_group_id);

Line 478: arp_util_tax.debug('case 4:in if g_group_id IS NULL->'||g_group_id);

474: arp_util_tax.debug('case 4: l_child_precedence:'||l_child_precedence);
475:
476: --Assigning value for new group
477: IF l_group_id <> g_group_id THEN
478: arp_util_tax.debug('case 4:in if g_group_id IS NULL->'||g_group_id);
479: g_group_id := l_group_id;
480: END IF;
481:
482: arp_util_tax.debug('case 4:g_group_id:'||g_group_id);

Line 482: arp_util_tax.debug('case 4:g_group_id:'||g_group_id);

478: arp_util_tax.debug('case 4:in if g_group_id IS NULL->'||g_group_id);
479: g_group_id := l_group_id;
480: END IF;
481:
482: arp_util_tax.debug('case 4:g_group_id:'||g_group_id);
483: arp_util_tax.debug('case 4:g_child_tax_code:'||g_child_tax_code);
484: arp_util_tax.debug('case 4:g_child_regime_code:'||g_child_regime_code);
485:
486: IF (l_group_id = g_group_id) AND

Line 483: arp_util_tax.debug('case 4:g_child_tax_code:'||g_child_tax_code);

479: g_group_id := l_group_id;
480: END IF;
481:
482: arp_util_tax.debug('case 4:g_group_id:'||g_group_id);
483: arp_util_tax.debug('case 4:g_child_tax_code:'||g_child_tax_code);
484: arp_util_tax.debug('case 4:g_child_regime_code:'||g_child_regime_code);
485:
486: IF (l_group_id = g_group_id) AND
487: (l_child_tax_code = g_child_tax_code) AND

Line 484: arp_util_tax.debug('case 4:g_child_regime_code:'||g_child_regime_code);

480: END IF;
481:
482: arp_util_tax.debug('case 4:g_group_id:'||g_group_id);
483: arp_util_tax.debug('case 4:g_child_tax_code:'||g_child_tax_code);
484: arp_util_tax.debug('case 4:g_child_regime_code:'||g_child_regime_code);
485:
486: IF (l_group_id = g_group_id) AND
487: (l_child_tax_code = g_child_tax_code) AND
488: (l_child_regime_code = g_child_regime_code) THEN

Line 492: arp_util_tax.debug('case 4: 1st if');

488: (l_child_regime_code = g_child_regime_code) THEN
489:
490: -- formula and formula details are already created for this childtax
491: -- when the previous row was processed. process the next row
492: arp_util_tax.debug('case 4: 1st if');
493: NULL;
494:
495: -- added OR condition "g_group_id IS NULL" in ELSIF
496: -- for running the first record of cursor

Line 504: arp_util_tax.debug('case 4: 2nd if');

500:
501: -- If taxgroup is the same as previous taxgroup but child tax and child regime is different
502: -- from previous childtax. hence create a formula header
503:
504: arp_util_tax.debug('case 4: 2nd if');
505:
506: l_condition_grp_cd := NULL;
507: l_condition_grp_id := NULL;
508:

Line 512: arp_util_tax.debug('case 4:before select of cond grp');

508:
509:
510: BEGIN
511:
512: arp_util_tax.debug('case 4:before select of cond grp');
513:
514: SELECT vat.tax_constraint_id
515: INTO l_tax_constraint_id
516: FROM ar_vat_tax_all vat

Line 529: arp_util_tax.debug('Case 4:error for tax '||l_child_tax_code||' error:'||sqlerrm);

525: substrb(l_tax_group_code,1,40)||'~'||l_tax_constraint_id)
526: );
527:
528: EXCEPTION WHEN OTHERS THEN
529: arp_util_tax.debug('Case 4:error for tax '||l_child_tax_code||' error:'||sqlerrm);
530: x_return_status := FND_API.G_RET_STS_ERROR;
531:
532: END;
533:

Line 534: arp_util_tax.debug('Case 4:l_condition_grp_id->'||l_condition_grp_id);

530: x_return_status := FND_API.G_RET_STS_ERROR;
531:
532: END;
533:
534: arp_util_tax.debug('Case 4:l_condition_grp_id->'||l_condition_grp_id);
535: arp_util_tax.debug('Case 4:l_condition_grp_cd->'||l_condition_grp_cd);
536:
537: IF l_child_taxable_basis = 'PRIOR_TAX' THEN
538: -- the taxable_basis_type in the formula will be prior_tax and

Line 535: arp_util_tax.debug('Case 4:l_condition_grp_cd->'||l_condition_grp_cd);

531:
532: END;
533:
534: arp_util_tax.debug('Case 4:l_condition_grp_id->'||l_condition_grp_id);
535: arp_util_tax.debug('Case 4:l_condition_grp_cd->'||l_condition_grp_cd);
536:
537: IF l_child_taxable_basis = 'PRIOR_TAX' THEN
538: -- the taxable_basis_type in the formula will be prior_tax and
539: -- there will be only one record in the Formula Details

Line 554: arp_util_tax.debug('case 4: l_formula_code1'||l_formula_code);

550: ELSE
551: l_formula_code := l_tax_group_code||'_'||l_child_tax_code||'_TB';
552: END IF;
553:
554: arp_util_tax.debug('case 4: l_formula_code1'||l_formula_code);
555:
556: l_discount_flag := 'N';
557: l_charge_flag := 'N';
558:

Line 559: arp_util_tax.debug('Case 4:before create_formula');

555:
556: l_discount_flag := 'N';
557: l_charge_flag := 'N';
558:
559: arp_util_tax.debug('Case 4:before create_formula');
560:
561: create_formula (l_child_taxable_basis,
562: l_formula_code,
563: l_child_regime_code,

Line 579: arp_util_tax.debug('Case 4:after create_formula');

575: l_tax,
576: x_msg_data
577: );
578:
579: arp_util_tax.debug('Case 4:after create_formula');
580:
581: l_alphanumeric_result := l_formula_code;
582:
583: IF l_condition_grp_cd IS NOT NULL THEN

Line 585: arp_util_tax.debug('Case 4:before create_rules');

581: l_alphanumeric_result := l_formula_code;
582:
583: IF l_condition_grp_cd IS NOT NULL THEN
584:
585: arp_util_tax.debug('Case 4:before create_rules');
586:
587: create_rules ( l_tax,
588: l_tax_regime_code,
589: l_start_date,

Line 603: arp_util_tax.debug('Case 4:after create_rules');

599: );
600: END IF;
601:
602:
603: arp_util_tax.debug('Case 4:after create_rules');
604:
605: ELSIF l_child_taxable_basis <> 'PRIOR_TAX' THEN
606: -- then create formula header with taxable basis type as LineAmount.
607: -- INSERT INTO zx_formula_b with taxable_basis_type = 'LINE_AMOUNT';

Line 625: arp_util_tax.debug('case 4: l_formula_code2'||l_formula_code);

621:
622: l_discount_flag := 'N';
623: l_charge_flag := 'N';
624:
625: arp_util_tax.debug('case 4: l_formula_code2'||l_formula_code);
626:
627: IF l_child_taxable_basis = 'AFTER_EPD' THEN
628:
629: -- If the taxable_basis is After Discount then set the

Line 635: arp_util_tax.debug('Case 4:before create_formula');

631:
632: l_discount_flag := 'Y';
633: END IF; -- end l_taxable_basis = 'AFTER_EPD'
634:
635: arp_util_tax.debug('Case 4:before create_formula');
636: create_formula (l_child_taxable_basis,
637: l_formula_code,
638: l_child_regime_code,
639: l_child_tax_code,

Line 654: arp_util_tax.debug('Case 4:after create_formula');

650: l_tax,
651: x_msg_data
652: );
653:
654: arp_util_tax.debug('Case 4:after create_formula');
655:
656: l_alphanumeric_result := l_formula_code;
657:
658: IF l_condition_grp_cd IS NOT NULL THEN

Line 660: arp_util_tax.debug('Case 4:before create_rules');

656: l_alphanumeric_result := l_formula_code;
657:
658: IF l_condition_grp_cd IS NOT NULL THEN
659:
660: arp_util_tax.debug('Case 4:before create_rules');
661:
662: create_rules ( l_tax,
663: l_tax_regime_code,
664: l_start_date,

Line 677: arp_util_tax.debug('Case 4:after create_rules');

673: x_msg_data
674: );
675: END IF;
676:
677: arp_util_tax.debug('Case 4:after create_rules');
678: END IF; --end l_taxable_basis = 'PRIOR_TAX'
679:
680: arp_util_tax.debug('Case 4:aftr end if of --> l_taxable_basis ');
681:

Line 680: arp_util_tax.debug('Case 4:aftr end if of --> l_taxable_basis ');

676:
677: arp_util_tax.debug('Case 4:after create_rules');
678: END IF; --end l_taxable_basis = 'PRIOR_TAX'
679:
680: arp_util_tax.debug('Case 4:aftr end if of --> l_taxable_basis ');
681:
682: END IF;
683:
684: -- Assigning values to variables

Line 707: arp_util_tax.debug('LAST');

703: AND R.SERVICE_TYPE_CODE = 'DET_TAXABLE_BASIS'
704: AND R.RECORD_TYPE_CODE = 'MIGRATED'
705: AND R.ENABLED_FLAG = 'Y');
706:
707: arp_util_tax.debug('LAST');
708:
709: EXCEPTION WHEN OTHERS THEN
710:
711: x_return_status := FND_API.G_RET_STS_ERROR;

Line 760: arp_util_tax.debug('in create_formula() for : '||p_tax_code);

756: BEGIN
757:
758: -- Inserting values in table zx_formula_b
759:
760: arp_util_tax.debug('in create_formula() for : '||p_tax_code);
761: BEGIN
762: --bug# 4610260 : Changed the ZX_FORMULA_B_TMP to ZX_FORMULA_B
763: INSERT INTO zx_formula_b_tmp (
764: formula_type_code,

Line 837: arp_util_tax.debug('In create_formula().formula_b: error-'||sqlerrm);

833: AND enabled_flag = p_enabled_flag
834: );
835:
836: EXCEPTION WHEN OTHERS THEN
837: arp_util_tax.debug('In create_formula().formula_b: error-'||sqlerrm);
838: x_return_status := FND_API.G_RET_STS_ERROR;
839:
840: END ;
841:

Line 880: arp_util_tax.debug('In create_formula().formula_tl: error-'||sqlerrm);

876: WHERE t.formula_id = formula.formula_id
877: AND t.language = l.language_code);
878:
879: EXCEPTION WHEN OTHERS THEN
880: arp_util_tax.debug('In create_formula().formula_tl: error-'||sqlerrm);
881: x_return_status := FND_API.G_RET_STS_ERROR;
882:
883: END;
884:

Line 899: arp_util_tax.debug('In create_formula().formula_tl: error-'||sqlerrm);

895: AND tax_regime_code=p_tax_regime_code
896: AND enabled_flag = p_enabled_flag;
897: -- Bug 9504903
898: EXCEPTION WHEN OTHERS THEN
899: arp_util_tax.debug('In create_formula().formula_tl: error-'||sqlerrm);
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: RETURN;
902: END;
903:

Line 906: arp_util_tax.debug('l_formula_id:'|| l_formula_id);

902: END;
903:
904: -- Inserting values in table zx_formula_details
905:
906: arp_util_tax.debug('l_formula_id:'|| l_formula_id);
907:
908:
909: IF p_taxable_basis = 'PRIOR_TAX' THEN
910:

Line 962: arp_util_tax.debug('In create_formula().formula_details: error-'||sqlerrm);

958: )
959: AND rownum = 1;
960:
961: EXCEPTION WHEN OTHERS THEN
962: arp_util_tax.debug('In create_formula().formula_details: error-'||sqlerrm);
963:
964: x_return_status := FND_API.G_RET_STS_ERROR;
965:
966: END;

Line 1024: arp_util_tax.debug('In create_formula().formula_b: error-'||sqlerrm);

1020:
1021: -- the above contains clause is introduced as part of 6718736
1022:
1023: EXCEPTION WHEN OTHERS THEN
1024: arp_util_tax.debug('In create_formula().formula_b: error-'||sqlerrm);
1025: x_return_status := FND_API.G_RET_STS_ERROR;
1026:
1027: END;
1028:

Line 1060: arp_util_tax.debug('in create_rules() for : '||p_tax);

1056: l_tax_rule_id NUMBER;
1057:
1058: BEGIN
1059:
1060: arp_util_tax.debug('in create_rules() for : '||p_tax);
1061:
1062:
1063:
1064:

Line 1072: arp_util_tax.debug('l_tax_rule_code'||l_tax_rule_code);

1068: 'O_TB_' || p_tax)
1069: INTO l_tax_rule_code
1070: FROM DUAL;
1071:
1072: arp_util_tax.debug('l_tax_rule_code'||l_tax_rule_code);
1073:
1074: -- Inserting values in table zx_rules_b
1075:
1076: BEGIN

Line 1153: arp_util_tax.debug('In create_rules().rules_b: error-'||sqlerrm);

1149: AND enabled_flag = 'Y'
1150: );
1151:
1152: EXCEPTION WHEN OTHERS THEN
1153: arp_util_tax.debug('In create_rules().rules_b: error-'||sqlerrm);
1154: x_return_status := FND_API.G_RET_STS_ERROR;
1155:
1156: END;
1157:

Line 1196: arp_util_tax.debug('In create_rules().rules_tl: error-'||sqlerrm);

1192: WHERE t.tax_rule_id = rules.tax_rule_id
1193: AND t.language = l.language_code);
1194:
1195: EXCEPTION WHEN OTHERS THEN
1196: arp_util_tax.debug('In create_rules().rules_tl: error-'||sqlerrm);
1197: x_return_status := FND_API.G_RET_STS_ERROR;
1198:
1199: END;
1200:

Line 1215: arp_util_tax.debug('In create_rules().rules_b: error-'||sqlerrm);

1211: AND enabled_flag = p_enabled_flag
1212: AND (effective_from BETWEEN p_effective_from and nvl(p_effective_to,SYSDATE)
1213: OR NVL(effective_to,sysdate) BETWEEN p_effective_from and nvl(p_effective_to,sysdate));
1214: EXCEPTION WHEN OTHERS THEN
1215: arp_util_tax.debug('In create_rules().rules_b: error-'||sqlerrm);
1216: x_return_status := FND_API.G_RET_STS_ERROR;
1217: RETURN;
1218: END;
1219: -- Bug 8429806

Line 1312: arp_util_tax.debug('In create_rules().process_results: error-'||sqlerrm);

1308: );
1309:
1310:
1311: EXCEPTION WHEN OTHERS THEN
1312: arp_util_tax.debug('In create_rules().process_results: error-'||sqlerrm);
1313: x_return_status := FND_API.G_RET_STS_ERROR;
1314:
1315: END;
1316: