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: /*===========================================================================+
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;
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:
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:
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;
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:
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;
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;
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;
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:
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;
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;
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:
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;
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:
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:
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:
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: /*===========================================================================+
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 |
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:
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;
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:
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;
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:
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;
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;
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: