DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ARP_UTIL_TAX

Line 41: arp_util_tax.debug('Migrate_Default_Hierarchy(+)');

37:
38: PROCEDURE migrate_default_hierarchy is
39: BEGIN
40: IF PG_DEBUG = 'Y' THEN
41: arp_util_tax.debug('Migrate_Default_Hierarchy(+)');
42: END IF;
43: Savepoint Default_Setup;
44: create_template; --Bug 4935978
45: create_condition_groups;

Line 49: arp_util_tax.debug('Migrate_Default_Hierarchy(-)');

45: create_condition_groups;
46: create_rules;
47: create_process_results;
48: IF PG_DEBUG = 'Y' THEN
49: arp_util_tax.debug('Migrate_Default_Hierarchy(-)');
50: END IF;
51: EXCEPTION
52: WHEN OTHERS THEN
53: IF PG_DEBUG = 'Y' THEN

Line 54: arp_util_tax.debug('EXCEPTION: Migrate_default_hierarchy ');

50: END IF;
51: EXCEPTION
52: WHEN OTHERS THEN
53: IF PG_DEBUG = 'Y' THEN
54: arp_util_tax.debug('EXCEPTION: Migrate_default_hierarchy ');
55: arp_util_tax.debug(sqlerrm);
56: arp_util_tax.debug('Migrate_Default_Hierarchy(-)');
57: END IF;
58: Rollback To Default_Setup;

Line 55: arp_util_tax.debug(sqlerrm);

51: EXCEPTION
52: WHEN OTHERS THEN
53: IF PG_DEBUG = 'Y' THEN
54: arp_util_tax.debug('EXCEPTION: Migrate_default_hierarchy ');
55: arp_util_tax.debug(sqlerrm);
56: arp_util_tax.debug('Migrate_Default_Hierarchy(-)');
57: END IF;
58: Rollback To Default_Setup;
59: --app_exception.raise_exception;

Line 56: arp_util_tax.debug('Migrate_Default_Hierarchy(-)');

52: WHEN OTHERS THEN
53: IF PG_DEBUG = 'Y' THEN
54: arp_util_tax.debug('EXCEPTION: Migrate_default_hierarchy ');
55: arp_util_tax.debug(sqlerrm);
56: arp_util_tax.debug('Migrate_Default_Hierarchy(-)');
57: END IF;
58: Rollback To Default_Setup;
59: --app_exception.raise_exception;
60: END migrate_default_hierarchy;

Line 86: arp_util_tax.debug('create_template(+)');

82:
83: PROCEDURE create_template IS
84: BEGIN
85: IF PG_DEBUG = 'Y' THEN
86: arp_util_tax.debug('create_template(+)');
87: END IF;
88:
89: -- Determining factor template: STCC
90: INSERT INTO ZX_DET_FACTOR_TEMPL_B

Line 540: arp_util_tax.debug('Create_Condition_Groups(+)');

536:
537: PROCEDURE create_condition_groups(p_name IN VARCHAR2 DEFAULT NULL) IS
538: BEGIN
539: IF PG_DEBUG = 'Y' THEN
540: arp_util_tax.debug('Create_Condition_Groups(+)');
541: END IF;
542:
543: --Insert records into both CONDITION_GROUPS and CONDITIONS.
544: --Insert of Input tax classification codes

Line 1579: arp_util_tax.debug('Create_Condition_Groups(-)');

1575: from ZX_CONDITION_GROUPS_TL T
1576: where T.CONDITION_GROUP_ID = B.CONDITION_GROUP_ID
1577: and T.LANGUAGE = L.LANGUAGE_CODE);
1578: IF PG_DEBUG = 'Y' THEN
1579: arp_util_tax.debug('Create_Condition_Groups(-)');
1580: END IF;
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: IF PG_DEBUG = 'Y' THEN

Line 1584: arp_util_tax.debug('EXCEPTION: Create_condition_groups ');

1580: END IF;
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: IF PG_DEBUG = 'Y' THEN
1584: arp_util_tax.debug('EXCEPTION: Create_condition_groups ');
1585: arp_util_tax.debug(sqlerrm);
1586: arp_util_tax.debug('Create_Condition_Groups(-)');
1587: END IF;
1588: --app_exception.raise_exception;

Line 1585: arp_util_tax.debug(sqlerrm);

1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: IF PG_DEBUG = 'Y' THEN
1584: arp_util_tax.debug('EXCEPTION: Create_condition_groups ');
1585: arp_util_tax.debug(sqlerrm);
1586: arp_util_tax.debug('Create_Condition_Groups(-)');
1587: END IF;
1588: --app_exception.raise_exception;
1589: END create_condition_groups;

Line 1586: arp_util_tax.debug('Create_Condition_Groups(-)');

1582: WHEN OTHERS THEN
1583: IF PG_DEBUG = 'Y' THEN
1584: arp_util_tax.debug('EXCEPTION: Create_condition_groups ');
1585: arp_util_tax.debug(sqlerrm);
1586: arp_util_tax.debug('Create_Condition_Groups(-)');
1587: END IF;
1588: --app_exception.raise_exception;
1589: END create_condition_groups;
1590:

Line 1619: arp_util_tax.debug('Create_Rules(+)');

1615:
1616: PROCEDURE create_rules(p_tax IN VARCHAR2 DEFAULT NULL) IS
1617: BEGIN
1618: IF PG_DEBUG = 'Y' THEN
1619: arp_util_tax.debug('Create_Rules(+)');
1620: END IF;
1621:
1622:
1623: --Rules for AP, AR Tax setup

Line 2555: arp_util_tax.debug('Create_Rules(-)');

2551:
2552: -- bug fix: 5548613 end
2553:
2554: IF PG_DEBUG = 'Y' THEN
2555: arp_util_tax.debug('Create_Rules(-)');
2556: END IF;
2557: EXCEPTION
2558: WHEN OTHERS THEN
2559: IF PG_DEBUG = 'Y' THEN

Line 2560: arp_util_tax.debug('EXCEPTION: Create_rules ');

2556: END IF;
2557: EXCEPTION
2558: WHEN OTHERS THEN
2559: IF PG_DEBUG = 'Y' THEN
2560: arp_util_tax.debug('EXCEPTION: Create_rules ');
2561: arp_util_tax.debug(sqlerrm);
2562: arp_util_tax.debug('Create_Rules(-)');
2563: END IF;
2564: --app_exception.raise_exception;

Line 2561: arp_util_tax.debug(sqlerrm);

2557: EXCEPTION
2558: WHEN OTHERS THEN
2559: IF PG_DEBUG = 'Y' THEN
2560: arp_util_tax.debug('EXCEPTION: Create_rules ');
2561: arp_util_tax.debug(sqlerrm);
2562: arp_util_tax.debug('Create_Rules(-)');
2563: END IF;
2564: --app_exception.raise_exception;
2565: END create_rules;

Line 2562: arp_util_tax.debug('Create_Rules(-)');

2558: WHEN OTHERS THEN
2559: IF PG_DEBUG = 'Y' THEN
2560: arp_util_tax.debug('EXCEPTION: Create_rules ');
2561: arp_util_tax.debug(sqlerrm);
2562: arp_util_tax.debug('Create_Rules(-)');
2563: END IF;
2564: --app_exception.raise_exception;
2565: END create_rules;
2566:

Line 2596: arp_util_tax.debug('Create_Process_Results(+)');

2592: p_sync_module IN VARCHAR2 DEFAULT NULL
2593: ) IS
2594: BEGIN
2595: IF PG_DEBUG = 'Y' THEN
2596: arp_util_tax.debug('Create_Process_Results(+)');
2597: END IF;
2598:
2599: IF (nvl(p_sync_module,'AP') = 'AP' and p_dir_rate_rules_cnt > 0) THEN
2600: --Process_Results for AP Tax codes and Tax Groups Setup

Line 3576: arp_util_tax.debug('Create_Process_Results(-)');

3572:
3573: END IF;
3574:
3575: IF PG_DEBUG = 'Y' THEN
3576: arp_util_tax.debug('Create_Process_Results(-)');
3577: END IF;
3578: EXCEPTION
3579: WHEN OTHERS THEN
3580: IF PG_DEBUG = 'Y' THEN

Line 3581: arp_util_tax.debug('EXCEPTION: Create_process_results ');

3577: END IF;
3578: EXCEPTION
3579: WHEN OTHERS THEN
3580: IF PG_DEBUG = 'Y' THEN
3581: arp_util_tax.debug('EXCEPTION: Create_process_results ');
3582: arp_util_tax.debug(sqlerrm);
3583: arp_util_tax.debug('Create_Process_Results(-)');
3584: END IF;
3585: --app_exception.raise_exception;

Line 3582: arp_util_tax.debug(sqlerrm);

3578: EXCEPTION
3579: WHEN OTHERS THEN
3580: IF PG_DEBUG = 'Y' THEN
3581: arp_util_tax.debug('EXCEPTION: Create_process_results ');
3582: arp_util_tax.debug(sqlerrm);
3583: arp_util_tax.debug('Create_Process_Results(-)');
3584: END IF;
3585: --app_exception.raise_exception;
3586: END create_process_results;

Line 3583: arp_util_tax.debug('Create_Process_Results(-)');

3579: WHEN OTHERS THEN
3580: IF PG_DEBUG = 'Y' THEN
3581: arp_util_tax.debug('EXCEPTION: Create_process_results ');
3582: arp_util_tax.debug(sqlerrm);
3583: arp_util_tax.debug('Create_Process_Results(-)');
3584: END IF;
3585: --app_exception.raise_exception;
3586: END create_process_results;
3587:

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

3593:
3594: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
3595:
3596: IF L_ORG_ID IS NULL THEN
3597: arp_util_tax.debug('MO: Operating Units site level profile option value not set , resulted in Null Org Id');
3598: END IF;
3599: ELSE
3600: L_ORG_ID := NULL;
3601: END IF;

Line 3606: arp_util_tax.debug('Exception in constructor of Tax Hierarchy Migration '||sqlerrm);

3602:
3603:
3604: EXCEPTION
3605: WHEN OTHERS THEN
3606: arp_util_tax.debug('Exception in constructor of Tax Hierarchy Migration '||sqlerrm);
3607:
3608:
3609:
3610: END Zx_Migrate_Tax_Default_Hier;