DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ARP_UTIL_TAX

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

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

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

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

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

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

Line 53: arp_util_tax.debug(sqlerrm);

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

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

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

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

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

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

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

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

1419: from ZX_CONDITION_GROUPS_TL T
1420: where T.CONDITION_GROUP_ID = B.CONDITION_GROUP_ID
1421: and T.LANGUAGE = L.LANGUAGE_CODE);
1422: IF PG_DEBUG = 'Y' THEN
1423: arp_util_tax.debug('Create_Condition_Groups(-)');
1424: END IF;
1425: EXCEPTION
1426: WHEN OTHERS THEN
1427: IF PG_DEBUG = 'Y' THEN

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

1424: END IF;
1425: EXCEPTION
1426: WHEN OTHERS THEN
1427: IF PG_DEBUG = 'Y' THEN
1428: arp_util_tax.debug('EXCEPTION: Create_condition_groups ');
1429: arp_util_tax.debug(sqlerrm);
1430: arp_util_tax.debug('Create_Condition_Groups(-)');
1431: END IF;
1432: --app_exception.raise_exception;

Line 1429: arp_util_tax.debug(sqlerrm);

1425: EXCEPTION
1426: WHEN OTHERS THEN
1427: IF PG_DEBUG = 'Y' THEN
1428: arp_util_tax.debug('EXCEPTION: Create_condition_groups ');
1429: arp_util_tax.debug(sqlerrm);
1430: arp_util_tax.debug('Create_Condition_Groups(-)');
1431: END IF;
1432: --app_exception.raise_exception;
1433: END create_condition_groups;

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

1426: WHEN OTHERS THEN
1427: IF PG_DEBUG = 'Y' THEN
1428: arp_util_tax.debug('EXCEPTION: Create_condition_groups ');
1429: arp_util_tax.debug(sqlerrm);
1430: arp_util_tax.debug('Create_Condition_Groups(-)');
1431: END IF;
1432: --app_exception.raise_exception;
1433: END create_condition_groups;
1434:

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

1459:
1460: PROCEDURE create_rules(p_tax IN VARCHAR2 DEFAULT NULL) IS
1461: BEGIN
1462: IF PG_DEBUG = 'Y' THEN
1463: arp_util_tax.debug('Create_Rules(+)');
1464: END IF;
1465:
1466:
1467: --Rules for AP, AR Tax setup

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

2385:
2386: -- bug fix: 5548613 end
2387:
2388: IF PG_DEBUG = 'Y' THEN
2389: arp_util_tax.debug('Create_Rules(-)');
2390: END IF;
2391: EXCEPTION
2392: WHEN OTHERS THEN
2393: IF PG_DEBUG = 'Y' THEN

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

2390: END IF;
2391: EXCEPTION
2392: WHEN OTHERS THEN
2393: IF PG_DEBUG = 'Y' THEN
2394: arp_util_tax.debug('EXCEPTION: Create_rules ');
2395: arp_util_tax.debug(sqlerrm);
2396: arp_util_tax.debug('Create_Rules(-)');
2397: END IF;
2398: --app_exception.raise_exception;

Line 2395: arp_util_tax.debug(sqlerrm);

2391: EXCEPTION
2392: WHEN OTHERS THEN
2393: IF PG_DEBUG = 'Y' THEN
2394: arp_util_tax.debug('EXCEPTION: Create_rules ');
2395: arp_util_tax.debug(sqlerrm);
2396: arp_util_tax.debug('Create_Rules(-)');
2397: END IF;
2398: --app_exception.raise_exception;
2399: END create_rules;

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

2392: WHEN OTHERS THEN
2393: IF PG_DEBUG = 'Y' THEN
2394: arp_util_tax.debug('EXCEPTION: Create_rules ');
2395: arp_util_tax.debug(sqlerrm);
2396: arp_util_tax.debug('Create_Rules(-)');
2397: END IF;
2398: --app_exception.raise_exception;
2399: END create_rules;
2400:

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

2426: p_sync_module IN VARCHAR2 DEFAULT NULL
2427: ) IS
2428: BEGIN
2429: IF PG_DEBUG = 'Y' THEN
2430: arp_util_tax.debug('Create_Process_Results(+)');
2431: END IF;
2432:
2433: IF (nvl(p_sync_module,'AP') = 'AP') THEN
2434: --Process_Results for AP Tax codes and Tax Groups Setup

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

3389:
3390: END IF;
3391:
3392: IF PG_DEBUG = 'Y' THEN
3393: arp_util_tax.debug('Create_Process_Results(-)');
3394: END IF;
3395: EXCEPTION
3396: WHEN OTHERS THEN
3397: IF PG_DEBUG = 'Y' THEN

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

3394: END IF;
3395: EXCEPTION
3396: WHEN OTHERS THEN
3397: IF PG_DEBUG = 'Y' THEN
3398: arp_util_tax.debug('EXCEPTION: Create_process_results ');
3399: arp_util_tax.debug(sqlerrm);
3400: arp_util_tax.debug('Create_Process_Results(-)');
3401: END IF;
3402: --app_exception.raise_exception;

Line 3399: arp_util_tax.debug(sqlerrm);

3395: EXCEPTION
3396: WHEN OTHERS THEN
3397: IF PG_DEBUG = 'Y' THEN
3398: arp_util_tax.debug('EXCEPTION: Create_process_results ');
3399: arp_util_tax.debug(sqlerrm);
3400: arp_util_tax.debug('Create_Process_Results(-)');
3401: END IF;
3402: --app_exception.raise_exception;
3403: END create_process_results;

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

3396: WHEN OTHERS THEN
3397: IF PG_DEBUG = 'Y' THEN
3398: arp_util_tax.debug('EXCEPTION: Create_process_results ');
3399: arp_util_tax.debug(sqlerrm);
3400: arp_util_tax.debug('Create_Process_Results(-)');
3401: END IF;
3402: --app_exception.raise_exception;
3403: END create_process_results;
3404:

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

3410:
3411: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
3412:
3413: IF L_ORG_ID IS NULL THEN
3414: arp_util_tax.debug('MO: Operating Units site level profile option value not set , resulted in Null Org Id');
3415: END IF;
3416: ELSE
3417: L_ORG_ID := NULL;
3418: END IF;

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

3419:
3420:
3421: EXCEPTION
3422: WHEN OTHERS THEN
3423: arp_util_tax.debug('Exception in constructor of Tax Hierarchy Migration '||sqlerrm);
3424:
3425:
3426:
3427: END Zx_Migrate_Tax_Default_Hier;