DBA Data[Home] [Help]

APPS.ZX_P2P_DEF_AP_PREUPG dependencies on ARP_UTIL_TAX

Line 39: arp_util_tax.debug('Exception: Error Occurred during Operating Units Extract in PTP'||SQLERRM );

35:
36: NULL;
37: EXCEPTION
38: WHEN OTHERS THEN
39: arp_util_tax.debug('Exception: Error Occurred during Operating Units Extract in PTP'||SQLERRM );
40:
41: END;
42:
43: /*===========================================================================+

Line 100: arp_util_tax.debug('EXCEPTION: Migrate_normal_tax_codes ');

96:
97: EXCEPTION
98: WHEN OTHERS THEN
99: IF PG_DEBUG = 'Y' THEN
100: arp_util_tax.debug('EXCEPTION: Migrate_normal_tax_codes ');
101: arp_util_tax.debug(sqlerrm);
102: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');
103: END IF;
104: --app_exception.raise_exception;

Line 101: arp_util_tax.debug(sqlerrm);

97: EXCEPTION
98: WHEN OTHERS THEN
99: IF PG_DEBUG = 'Y' THEN
100: arp_util_tax.debug('EXCEPTION: Migrate_normal_tax_codes ');
101: arp_util_tax.debug(sqlerrm);
102: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');
103: END IF;
104: --app_exception.raise_exception;
105:

Line 102: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');

98: WHEN OTHERS THEN
99: IF PG_DEBUG = 'Y' THEN
100: arp_util_tax.debug('EXCEPTION: Migrate_normal_tax_codes ');
101: arp_util_tax.debug(sqlerrm);
102: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');
103: END IF;
104: --app_exception.raise_exception;
105:
106:

Line 148: arp_util_tax.debug('EXCEPTION: Migrate_assign_offset_codes ');

144:
145: EXCEPTION
146: WHEN OTHERS THEN
147: IF PG_DEBUG = 'Y' THEN
148: arp_util_tax.debug('EXCEPTION: Migrate_assign_offset_codes ');
149: arp_util_tax.debug(sqlerrm);
150: arp_util_tax.debug('Migrate_Assign_Offset_Codes(-)');
151: END IF;
152: --app_exception.raise_exception;

Line 149: arp_util_tax.debug(sqlerrm);

145: EXCEPTION
146: WHEN OTHERS THEN
147: IF PG_DEBUG = 'Y' THEN
148: arp_util_tax.debug('EXCEPTION: Migrate_assign_offset_codes ');
149: arp_util_tax.debug(sqlerrm);
150: arp_util_tax.debug('Migrate_Assign_Offset_Codes(-)');
151: END IF;
152: --app_exception.raise_exception;
153:

Line 150: arp_util_tax.debug('Migrate_Assign_Offset_Codes(-)');

146: WHEN OTHERS THEN
147: IF PG_DEBUG = 'Y' THEN
148: arp_util_tax.debug('EXCEPTION: Migrate_assign_offset_codes ');
149: arp_util_tax.debug(sqlerrm);
150: arp_util_tax.debug('Migrate_Assign_Offset_Codes(-)');
151: END IF;
152: --app_exception.raise_exception;
153:
154: END migrate_assign_offset_codes;

Line 191: arp_util_tax.debug('EXCEPTION: Migrate_unassign_offset_codes ');

187:
188: EXCEPTION
189: WHEN OTHERS THEN
190: IF PG_DEBUG = 'Y' THEN
191: arp_util_tax.debug('EXCEPTION: Migrate_unassign_offset_codes ');
192: arp_util_tax.debug(sqlerrm);
193: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(-)');
194: END IF;
195: --app_exception.raise_exception;

Line 192: arp_util_tax.debug(sqlerrm);

188: EXCEPTION
189: WHEN OTHERS THEN
190: IF PG_DEBUG = 'Y' THEN
191: arp_util_tax.debug('EXCEPTION: Migrate_unassign_offset_codes ');
192: arp_util_tax.debug(sqlerrm);
193: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(-)');
194: END IF;
195: --app_exception.raise_exception;
196: END migrate_unassign_offset_codes;

Line 193: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(-)');

189: WHEN OTHERS THEN
190: IF PG_DEBUG = 'Y' THEN
191: arp_util_tax.debug('EXCEPTION: Migrate_unassign_offset_codes ');
192: arp_util_tax.debug(sqlerrm);
193: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(-)');
194: END IF;
195: --app_exception.raise_exception;
196: END migrate_unassign_offset_codes;
197:

Line 234: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates ');

230:
231: EXCEPTION
232: WHEN OTHERS THEN
233: IF PG_DEBUG = 'Y' THEN
234: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates ');
235: arp_util_tax.debug(sqlerrm);
236: arp_util_tax.debug('Migrate_Recovery_Rates(-)');
237: END IF;
238: --app_exception.raise_exception;

Line 235: arp_util_tax.debug(sqlerrm);

231: EXCEPTION
232: WHEN OTHERS THEN
233: IF PG_DEBUG = 'Y' THEN
234: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates ');
235: arp_util_tax.debug(sqlerrm);
236: arp_util_tax.debug('Migrate_Recovery_Rates(-)');
237: END IF;
238: --app_exception.raise_exception;
239: END migrate_recovery_rates;

Line 236: arp_util_tax.debug('Migrate_Recovery_Rates(-)');

232: WHEN OTHERS THEN
233: IF PG_DEBUG = 'Y' THEN
234: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates ');
235: arp_util_tax.debug(sqlerrm);
236: arp_util_tax.debug('Migrate_Recovery_Rates(-)');
237: END IF;
238: --app_exception.raise_exception;
239: END migrate_recovery_rates;
240:

Line 340: arp_util_tax.debug('EXCEPTION: Migrate_disabled_tax_codes ');

336:
337: EXCEPTION
338: WHEN OTHERS THEN
339: IF PG_DEBUG = 'Y' THEN
340: arp_util_tax.debug('EXCEPTION: Migrate_disabled_tax_codes ');
341: arp_util_tax.debug(sqlerrm);
342: arp_util_tax.debug('Migrate_disabled_Tax_Codes(-)');
343: END IF;
344: --app_exception.raise_exception;

Line 341: arp_util_tax.debug(sqlerrm);

337: EXCEPTION
338: WHEN OTHERS THEN
339: IF PG_DEBUG = 'Y' THEN
340: arp_util_tax.debug('EXCEPTION: Migrate_disabled_tax_codes ');
341: arp_util_tax.debug(sqlerrm);
342: arp_util_tax.debug('Migrate_disabled_Tax_Codes(-)');
343: END IF;
344: --app_exception.raise_exception;
345:

Line 342: arp_util_tax.debug('Migrate_disabled_Tax_Codes(-)');

338: WHEN OTHERS THEN
339: IF PG_DEBUG = 'Y' THEN
340: arp_util_tax.debug('EXCEPTION: Migrate_disabled_tax_codes ');
341: arp_util_tax.debug(sqlerrm);
342: arp_util_tax.debug('Migrate_disabled_Tax_Codes(-)');
343: END IF;
344: --app_exception.raise_exception;
345:
346:

Line 379: arp_util_tax.debug('EXCEPTION: pre_upgrade_wrapper ');

375:
376: EXCEPTION
377: WHEN OTHERS THEN
378:
379: arp_util_tax.debug('EXCEPTION: pre_upgrade_wrapper ');
380: arp_util_tax.debug(sqlerrm);
381: arp_util_tax.debug('pre_upgrade_wrapper(-)');
382: END pre_upgrade_wrapper;
383:

Line 380: arp_util_tax.debug(sqlerrm);

376: EXCEPTION
377: WHEN OTHERS THEN
378:
379: arp_util_tax.debug('EXCEPTION: pre_upgrade_wrapper ');
380: arp_util_tax.debug(sqlerrm);
381: arp_util_tax.debug('pre_upgrade_wrapper(-)');
382: END pre_upgrade_wrapper;
383:
384: /*===========================================================================+

Line 381: arp_util_tax.debug('pre_upgrade_wrapper(-)');

377: WHEN OTHERS THEN
378:
379: arp_util_tax.debug('EXCEPTION: pre_upgrade_wrapper ');
380: arp_util_tax.debug(sqlerrm);
381: arp_util_tax.debug('pre_upgrade_wrapper(-)');
382: END pre_upgrade_wrapper;
383:
384: /*===========================================================================+
385: | Procedure : PRE_UPGRADE_WRAPPER |

Line 412: arp_util_tax.debug('EXCEPTION: pre_upgrade_wrapper ');

408:
409: EXCEPTION
410: WHEN OTHERS THEN
411:
412: arp_util_tax.debug('EXCEPTION: pre_upgrade_wrapper ');
413: arp_util_tax.debug(sqlerrm);
414: arp_util_tax.debug('pre_upgrade_wrapper(-)');
415:
416:

Line 413: arp_util_tax.debug(sqlerrm);

409: EXCEPTION
410: WHEN OTHERS THEN
411:
412: arp_util_tax.debug('EXCEPTION: pre_upgrade_wrapper ');
413: arp_util_tax.debug(sqlerrm);
414: arp_util_tax.debug('pre_upgrade_wrapper(-)');
415:
416:
417: END;

Line 414: arp_util_tax.debug('pre_upgrade_wrapper(-)');

410: WHEN OTHERS THEN
411:
412: arp_util_tax.debug('EXCEPTION: pre_upgrade_wrapper ');
413: arp_util_tax.debug(sqlerrm);
414: arp_util_tax.debug('pre_upgrade_wrapper(-)');
415:
416:
417: END;
418:

Line 430: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);

426: ar_vat_tax_all_b
427: where tax_id = vat_tax_id);
428: EXCEPTION
429: WHEN no_data_found THEN
430: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);
431:
432: WHEN OTHERS THEN
433: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);
434: END;

Line 433: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);

429: WHEN no_data_found THEN
430: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);
431:
432: WHEN OTHERS THEN
433: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);
434: END;
435:
436: BEGIN
437:

Line 446: arp_util_tax.debug('MO: Operating Units site level profile option value not set , resulted in Null Org Id');

442:
443: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
444:
445: IF L_ORG_ID IS NULL THEN
446: arp_util_tax.debug('MO: Operating Units site level profile option value not set , resulted in Null Org Id');
447: END IF;
448: ELSE
449: L_ORG_ID := NULL;
450: END IF;

Line 454: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);

450: END IF;
451:
452: EXCEPTION
453: WHEN no_data_found THEN
454: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);
455:
456: WHEN others THEN
457: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);
458: END;

Line 457: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);

453: WHEN no_data_found THEN
454: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);
455:
456: WHEN others THEN
457: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);
458: END;
459:
460:
461: