APPS.ZX_AR_FORMULA_MIG_PKG dependencies on ARP_UTIL_TAX

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

159: -- for conflicting tax groups---------------------
160:
161: BEGIN
162:
163: arp_util_tax.debug('ZX_AR_FORMULA_MIG_PKG.FORMULA_MIGRATION_MAIN(+)');
164:
165: -- Initialize API return status to success
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167:

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

168: -- Case 1 Tax Codes in AR_VAT_TAX
169:
170: OPEN get_tax_cur;
171: i := 0;
172: arp_util_tax.debug('CASE 1: open cursor');
173:
174: LOOP
175:
176: arp_util_tax.debug('i='||i);

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

172: arp_util_tax.debug('CASE 1: open cursor');
173:
174: LOOP
175:
176: arp_util_tax.debug('i='||i);
177: i := i+1;
178:
179: FETCH get_tax_cur INTO
180: l_child_taxable_basis ,

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

192:
193: l_condition_grp_cd := NULL;
194: l_condition_grp_id := NULL;
195:
196: arp_util_tax.debug('case1:l_child_taxable_basis:'||l_child_taxable_basis);
197: arp_util_tax.debug('case1:l_tax_code:'||l_tax_code);
198: arp_util_tax.debug('case1:l_tax:'||l_tax);
199: arp_util_tax.debug('case1:l_tax_regime_code:'||l_tax_regime_code);
200: arp_util_tax.debug('case1:l_content_owner_id:'||l_content_owner_id);

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

193: l_condition_grp_cd := NULL;
194: l_condition_grp_id := NULL;
195:
196: arp_util_tax.debug('case1:l_child_taxable_basis:'||l_child_taxable_basis);
197: arp_util_tax.debug('case1:l_tax_code:'||l_tax_code);
198: arp_util_tax.debug('case1:l_tax:'||l_tax);
199: arp_util_tax.debug('case1:l_tax_regime_code:'||l_tax_regime_code);
200: arp_util_tax.debug('case1:l_content_owner_id:'||l_content_owner_id);
201:

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

194: l_condition_grp_id := NULL;
195:
196: arp_util_tax.debug('case1:l_child_taxable_basis:'||l_child_taxable_basis);
197: arp_util_tax.debug('case1:l_tax_code:'||l_tax_code);
198: arp_util_tax.debug('case1:l_tax:'||l_tax);
199: arp_util_tax.debug('case1:l_tax_regime_code:'||l_tax_regime_code);
200: arp_util_tax.debug('case1:l_content_owner_id:'||l_content_owner_id);
201:
202:

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

195:
196: arp_util_tax.debug('case1:l_child_taxable_basis:'||l_child_taxable_basis);
197: arp_util_tax.debug('case1:l_tax_code:'||l_tax_code);
198: arp_util_tax.debug('case1:l_tax:'||l_tax);
199: arp_util_tax.debug('case1:l_tax_regime_code:'||l_tax_regime_code);
200: arp_util_tax.debug('case1:l_content_owner_id:'||l_content_owner_id);
201:
202:
203: arp_util_tax.debug('CASE 1: before select');

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

196: arp_util_tax.debug('case1:l_child_taxable_basis:'||l_child_taxable_basis);
197: arp_util_tax.debug('case1:l_tax_code:'||l_tax_code);
198: arp_util_tax.debug('case1:l_tax:'||l_tax);
199: arp_util_tax.debug('case1:l_tax_regime_code:'||l_tax_regime_code);
200: arp_util_tax.debug('case1:l_content_owner_id:'||l_content_owner_id);
201:
202:
203: arp_util_tax.debug('CASE 1: before select');
204:

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

199: arp_util_tax.debug('case1:l_tax_regime_code:'||l_tax_regime_code);
200: arp_util_tax.debug('case1:l_content_owner_id:'||l_content_owner_id);
201:
202:
203: arp_util_tax.debug('CASE 1: before select');
204:
205:
206: BEGIN
207:

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

211: WHERE condition_group_code = l_tax_code;
212:
213:
214: EXCEPTION WHEN OTHERS THEN
215: arp_util_tax.debug('Case1: error for tax '||l_tax_code||' Error:'||sqlerrm);
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: END;
218:
219:

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

216: x_return_status := FND_API.G_RET_STS_ERROR;
217: END;
218:
219:
220: arp_util_tax.debug('case1:l_condition_grp_id:'||l_condition_grp_id);
221: arp_util_tax.debug('case1:l_condition_grp_cd:'||l_condition_grp_cd);
222:
223: IF l_child_taxable_basis = 'AFTER_EPD' THEN
224:

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

217: END;
218:
219:
220: arp_util_tax.debug('case1:l_condition_grp_id:'||l_condition_grp_id);
221: arp_util_tax.debug('case1:l_condition_grp_cd:'||l_condition_grp_cd);
222:
223: IF l_child_taxable_basis = 'AFTER_EPD' THEN
224:
225: l_alphanumeric_result := 'STANDARD_TB_DISCOUNT';

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

234:
235: IF (l_child_taxable_basis = 'AFTER_EPD' OR l_child_taxable_basis = 'QUANTITY')
236: AND (l_condition_grp_cd IS NOT NULL) THEN
237:
238: arp_util_tax.debug('CASE 1: in if.before create_rules');
239:
240: create_rules ( l_tax ,
241: l_tax_regime_code ,
242: l_start_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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

336: FROM DUAL;
337:
338: -- For width Issue (formula_code is VARCHAR2(30) only)
339:
340: arp_util_tax.debug('case 3:l_formula_code:'||l_formula_code);
341:
342: l_charge_flag := 'N';
343:
344: IF l_child_taxable_basis = 'AFTER_EPD' THEN

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

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

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

370: l_tax ,
371: x_msg_data
372: );
373:
374: arp_util_tax.debug('case 3:after create_formula');
375:
376: -- For creation of rules
377:
378:

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

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

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

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

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

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

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

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

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

444:
445: OPEN get_taxgrp_cmp_cur;
446:
447: i:=0;
448: arp_util_tax.debug('case 4: IN CASE4');
449: -- Assigning variable g_group_id to null
450: g_group_id := NULL;
451: g_child_tax_code := NULL;
452: g_child_regime_code := NULL;

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

452: g_child_regime_code := NULL;
453:
454: LOOP
455:
456: arp_util_tax.debug('case 4: i='||i);
457: i := i+1;
458:
459: FETCH get_taxgrp_cmp_cur INTO
460: l_group_id ,

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

478: l_tax;
479:
480:
481:
482: arp_util_tax.debug('case 4: l_group_id:'||l_group_id);
483: arp_util_tax.debug('case 4: l_child_tax_code:'||l_child_tax_code);
484: arp_util_tax.debug('case 4: l_child_regime_code:'||l_child_regime_code);
485: arp_util_tax.debug('case 4: l_child_precedence:'||l_child_precedence);
486:

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

479:
480:
481:
482: arp_util_tax.debug('case 4: l_group_id:'||l_group_id);
483: arp_util_tax.debug('case 4: l_child_tax_code:'||l_child_tax_code);
484: arp_util_tax.debug('case 4: l_child_regime_code:'||l_child_regime_code);
485: arp_util_tax.debug('case 4: l_child_precedence:'||l_child_precedence);
486:
487:

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

480:
481:
482: arp_util_tax.debug('case 4: l_group_id:'||l_group_id);
483: arp_util_tax.debug('case 4: l_child_tax_code:'||l_child_tax_code);
484: arp_util_tax.debug('case 4: l_child_regime_code:'||l_child_regime_code);
485: arp_util_tax.debug('case 4: l_child_precedence:'||l_child_precedence);
486:
487:
488:

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

481:
482: arp_util_tax.debug('case 4: l_group_id:'||l_group_id);
483: arp_util_tax.debug('case 4: l_child_tax_code:'||l_child_tax_code);
484: arp_util_tax.debug('case 4: l_child_regime_code:'||l_child_regime_code);
485: arp_util_tax.debug('case 4: l_child_precedence:'||l_child_precedence);
486:
487:
488:
489: --Assigning value for new group

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

487:
488:
489: --Assigning value for new group
490: IF l_group_id <> g_group_id THEN
491: arp_util_tax.debug('case 4:in if g_group_id IS NULL->'||g_group_id);
492: g_group_id := l_group_id;
493: END IF;
494:
495: arp_util_tax.debug('case 4:g_group_id:'||g_group_id);

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

491: arp_util_tax.debug('case 4:in if g_group_id IS NULL->'||g_group_id);
492: g_group_id := l_group_id;
493: END IF;
494:
495: arp_util_tax.debug('case 4:g_group_id:'||g_group_id);
496: arp_util_tax.debug('case 4:g_child_tax_code:'||g_child_tax_code);
497: arp_util_tax.debug('case 4:g_child_regime_code:'||g_child_regime_code);
498:
499: IF (l_group_id = g_group_id) AND

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

492: g_group_id := l_group_id;
493: END IF;
494:
495: arp_util_tax.debug('case 4:g_group_id:'||g_group_id);
496: arp_util_tax.debug('case 4:g_child_tax_code:'||g_child_tax_code);
497: arp_util_tax.debug('case 4:g_child_regime_code:'||g_child_regime_code);
498:
499: IF (l_group_id = g_group_id) AND
500: (l_child_tax_code = g_child_tax_code) AND

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

493: END IF;
494:
495: arp_util_tax.debug('case 4:g_group_id:'||g_group_id);
496: arp_util_tax.debug('case 4:g_child_tax_code:'||g_child_tax_code);
497: arp_util_tax.debug('case 4:g_child_regime_code:'||g_child_regime_code);
498:
499: IF (l_group_id = g_group_id) AND
500: (l_child_tax_code = g_child_tax_code) AND
501: (l_child_regime_code = g_child_regime_code) THEN

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

501: (l_child_regime_code = g_child_regime_code) THEN
502:
503: -- formula and formula details are already created for this childtax
504: -- when the previous row was processed. process the next row
505: arp_util_tax.debug('case 4: 1st if');
506: NULL;
507:
508: -- added OR condition "g_group_id IS NULL" in ELSIF
509: -- for running the first record of cursor

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

513:
514: -- If taxgroup is the same as previous taxgroup but child tax and child regime is different
515: -- from previous childtax. hence create a formula header
516:
517: arp_util_tax.debug('case 4: 2nd if');
518:
519: l_condition_grp_cd := NULL;
520: l_condition_grp_id := NULL;
521:

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

521:
522:
523: BEGIN
524:
525: arp_util_tax.debug('case 4:before select of cond grp');
526:
527: SELECT vat.tax_constraint_id
528: INTO l_tax_constraint_id
529: FROM ar_vat_tax_all vat

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

534: FROM zx_condition_groups_b
535: WHERE condition_group_code = l_tax_group_code|| decode(l_tax_constraint_id,NULL, '', '~'||l_tax_constraint_id);
536:
537: EXCEPTION WHEN OTHERS THEN
538: arp_util_tax.debug('Case 4:error for tax '||l_child_tax_code||' error:'||sqlerrm);
539: x_return_status := FND_API.G_RET_STS_ERROR;
540:
541: END;
542:

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

539: x_return_status := FND_API.G_RET_STS_ERROR;
540:
541: END;
542:
543: arp_util_tax.debug('Case 4:l_condition_grp_id->'||l_condition_grp_id);
544: arp_util_tax.debug('Case 4:l_condition_grp_cd->'||l_condition_grp_cd);
545:
546: IF l_child_taxable_basis = 'PRIOR_TAX' THEN
547: -- the taxable_basis_type in the formula will be prior_tax and

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

540:
541: END;
542:
543: arp_util_tax.debug('Case 4:l_condition_grp_id->'||l_condition_grp_id);
544: arp_util_tax.debug('Case 4:l_condition_grp_cd->'||l_condition_grp_cd);
545:
546: IF l_child_taxable_basis = 'PRIOR_TAX' THEN
547: -- the taxable_basis_type in the formula will be prior_tax and
548: -- there will be only one record in the Formula Details

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

554: l_tax_group_code||'_'||l_child_tax_code||'_TB')
555: INTO l_formula_code
556: FROM DUAL;
557:
558: arp_util_tax.debug('case 4: l_formula_code1'||l_formula_code);
559:
560:
561: l_discount_flag := 'N';
562: l_charge_flag := 'N';

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

560:
561: l_discount_flag := 'N';
562: l_charge_flag := 'N';
563:
564: arp_util_tax.debug('Case 4:before create_formula');
565:
566: create_formula (l_child_taxable_basis ,
567: l_formula_code ,
568: l_child_regime_code ,

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

580: l_tax ,
581: x_msg_data
582: );
583:
584: arp_util_tax.debug('Case 4:after create_formula');
585:
586: l_alphanumeric_result := l_formula_code;
587:
588: IF l_condition_grp_cd IS NOT NULL THEN

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

586: l_alphanumeric_result := l_formula_code;
587:
588: IF l_condition_grp_cd IS NOT NULL THEN
589:
590: arp_util_tax.debug('Case 4:before create_rules');
591:
592: create_rules ( l_tax ,
593: l_tax_regime_code ,
594: l_start_date ,

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

604: );
605: END IF;
606:
607:
608: arp_util_tax.debug('Case 4:after create_rules');
609:
610: ELSIF l_child_taxable_basis <> 'PRIOR_TAX' THEN
611: -- then create formula header with taxable basis type as LineAmount.
612: -- 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 638: arp_util_tax.debug('Case 4:before create_formula');

634:
635: END IF; -- end l_taxable_basis = 'AFTER_EPD'
636:
637:
638: arp_util_tax.debug('Case 4:before create_formula');
639: create_formula (l_child_taxable_basis ,
640: l_formula_code ,
641: l_child_regime_code ,
642: l_child_tax_code ,

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

654: x_msg_data
655: );
656:
657:
658: arp_util_tax.debug('Case 4:after create_formula');
659:
660:
661:
662:

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

663: l_alphanumeric_result := l_formula_code;
664:
665: IF l_condition_grp_cd IS NOT NULL THEN
666:
667: arp_util_tax.debug('Case 4:before create_rules');
668:
669: create_rules ( l_tax ,
670: l_tax_regime_code ,
671: l_start_date ,

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

680: x_msg_data
681: );
682: END IF;
683:
684: arp_util_tax.debug('Case 4:after create_rules');
685: END IF; --end l_taxable_basis = 'PRIOR_TAX'
686:
687: arp_util_tax.debug('Case 4:aftr end if of --> l_taxable_basis ');
688:

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

683:
684: arp_util_tax.debug('Case 4:after create_rules');
685: END IF; --end l_taxable_basis = 'PRIOR_TAX'
686:
687: arp_util_tax.debug('Case 4:aftr end if of --> l_taxable_basis ');
688:
689: END IF;
690:
691: -- Assigning values to variables

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

699: END LOOP; -- end Main Loop
700:
701: CLOSE get_taxgrp_cmp_cur;
702:
703: arp_util_tax.debug('LAST');
704:
705: EXCEPTION WHEN OTHERS THEN
706:
707: x_return_status := FND_API.G_RET_STS_ERROR;

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

741: BEGIN
742:
743: -- Inserting values in table zx_formula_b
744:
745: arp_util_tax.debug('in create_formula() for : '||p_tax_code);
746: BEGIN
747: --bug# 4610260 : Changed the ZX_FORMULA_B_TMP to ZX_FORMULA_B
748: INSERT INTO zx_formula_b_tmp (
749: formula_type_code ,

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

820: AND enabled_flag = 'Y'
821: );
822:
823: EXCEPTION WHEN OTHERS THEN
824: arp_util_tax.debug('In create_formula().formula_b: error-'||sqlerrm);
825: x_return_status := FND_API.G_RET_STS_ERROR;
826:
827: END ;
828:

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

863: WHERE t.formula_id = formula.formula_id
864: AND t.language = l.language_code);
865:
866: EXCEPTION WHEN OTHERS THEN
867: arp_util_tax.debug('In create_formula().formula_tl: error-'||sqlerrm);
868: x_return_status := FND_API.G_RET_STS_ERROR;
869:
870: END;
871:

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

871:
872:
873: -- Inserting values in table zx_formula_details
874:
875: arp_util_tax.debug('l_formula_id:'||l_formula_id);
876: IF p_taxable_basis = 'PRIOR_TAX' THEN
877:
878: BEGIN
879:

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

922: AND compounding_tax_regime_code = p_parent_regime_code
923: AND compounding_tax = p_parent_tax_code);
924:
925: EXCEPTION WHEN OTHERS THEN
926: arp_util_tax.debug('In create_formula().formula_details: error-'||sqlerrm);
927:
928: x_return_status := FND_API.G_RET_STS_ERROR;
929:
930: END;

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

984:
985: -- the above contains clause is introduced as part of 6718736
986:
987: EXCEPTION WHEN OTHERS THEN
988: arp_util_tax.debug('In create_formula().formula_b: error-'||sqlerrm);
989: x_return_status := FND_API.G_RET_STS_ERROR;
990:
991: END;
992:

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

1019: l_tax_rule_code zx_rules_b.tax_rule_code%TYPE;
1020:
1021: BEGIN
1022:
1023: arp_util_tax.debug('in create_rules() for : '||p_tax);
1024:
1025:
1026:
1027:

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

1031: 'O_TB_' || p_tax)
1032: INTO l_tax_rule_code
1033: FROM DUAL;
1034:
1035: arp_util_tax.debug('l_tax_rule_code'||l_tax_rule_code);
1036:
1037: -- Inserting values in table zx_rules_b
1038:
1039: BEGIN

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

1111: AND enabled_flag = 'Y'
1112: );
1113:
1114: EXCEPTION WHEN OTHERS THEN
1115: arp_util_tax.debug('In create_rules().rules_b: error-'||sqlerrm);
1116: x_return_status := FND_API.G_RET_STS_ERROR;
1117:
1118: END;
1119:

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

1154: WHERE t.tax_rule_id = rules.tax_rule_id
1155: AND t.language = l.language_code);
1156:
1157: EXCEPTION WHEN OTHERS THEN
1158: arp_util_tax.debug('In create_rules().rules_tl: error-'||sqlerrm);
1159: x_return_status := FND_API.G_RET_STS_ERROR;
1160:
1161: END;
1162:

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

1251: );
1252:
1253:
1254: EXCEPTION WHEN OTHERS THEN
1255: arp_util_tax.debug('In create_rules().process_results: error-'||sqlerrm);
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257:
1258: END;
1259: