APPS.ZX_MIGR_AR_TAX_GROUP_LOOKUPS dependencies on ARP_UTIL_TAX

Line 37: arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.Migrate_Condition_Constraints(+)');

33: PROCEDURE MIGRATE_CONDITION_CONSTRAINTS is
34: BEGIN
35:
36: IF PG_DEBUG = 'Y' THEN
37: arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.Migrate_Condition_Constraints(+)');
38: END IF;
39:
40: Savepoint pre_migr_ar_tax_group_lookups;
41:

Line 46: arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.Migrate_Condition_Constraints(-)');

42: Disable_Ext_Ar_Tg_Lookups;
43: Create_Lookups;
44:
45: IF PG_DEBUG = 'Y' THEN
46: arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.Migrate_Condition_Constraints(-)');
47: END IF;
48:
49: EXCEPTION
50: WHEN OTHERS THEN

Line 52: arp_util_tax.debug('Exception in ZX_MIGRATE_AR_TAX_GROUPS.Migrate_Condition_Constraints: '

48:
49: EXCEPTION
50: WHEN OTHERS THEN
51: IF PG_DEBUG = 'Y' THEN
52: arp_util_tax.debug('Exception in ZX_MIGRATE_AR_TAX_GROUPS.Migrate_Condition_Constraints: '
53: || SQLCODE ||';'||SQLERRM);
54: END IF;
55:
56: Rollback To pre_migr_ar_tax_group_lookups;

Line 89: arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.disable_ext_ar_tg_lookups(+)');

85: PROCEDURE DISABLE_EXT_AR_TG_LOOKUPS is
86: BEGIN
87:
88: IF PG_DEBUG = 'Y' THEN
89: arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.disable_ext_ar_tg_lookups(+)');
90: END IF;
91:
92: UPDATE FND_LOOKUP_TYPES
93: SET CUSTOMIZATION_LEVEL = 'S'

Line 108: arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.disable_ext_ar_tg_lookups(-)');

104: AND CUSTOMIZATION_LEVEL = 'E'
105: AND APPLICATION_ID = 222;
106:
107: IF PG_DEBUG = 'Y' THEN
108: arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.disable_ext_ar_tg_lookups(-)');
109: END IF;
110:
111: END;
112:

Line 150: arp_util_tax.debug('Create_Lookups(+)');

146: PROCEDURE Create_Lookups IS
147: BEGIN
148:
149: IF PG_DEBUG = 'Y' THEN
150: arp_util_tax.debug('Create_Lookups(+)');
151: END IF;
152:
153: IF PG_DEBUG = 'Y' THEN
154: arp_util_tax.debug('creating FND_LOOKUP_TYPES....');

Line 154: arp_util_tax.debug('creating FND_LOOKUP_TYPES....');

150: arp_util_tax.debug('Create_Lookups(+)');
151: END IF;
152:
153: IF PG_DEBUG = 'Y' THEN
154: arp_util_tax.debug('creating FND_LOOKUP_TYPES....');
155: END IF;
156:
157: INSERT ALL
158: WHEN (NOT EXISTS

Line 441: arp_util_tax.debug('creating records in FND_LOOKUP_TYPES_TL...');

437: SELECT 1 FROM DUAL;
438:
439:
440: IF PG_DEBUG = 'Y' THEN
441: arp_util_tax.debug('creating records in FND_LOOKUP_TYPES_TL...');
442: END IF;
443:
444: INSERT INTO FND_LOOKUP_TYPES_TL
445: (

Line 495: arp_util_tax.debug('creating records in FND_LOOKUP_VALUES...');

491: and sub.language = l.language_code);
492:
493:
494: IF PG_DEBUG = 'Y' THEN
495: arp_util_tax.debug('creating records in FND_LOOKUP_VALUES...');
496: END IF;
497:
498: /* Insert lookup codes for the lookup types */
499: INSERT INTO FND_LOOKUP_VALUES

Line 1264: arp_util_tax.debug('Create_Lookup(-)');

1260: and lookup_type = 'ZX_TAX_CLASSIFICATION'
1261: and language = l.LANGUAGE_CODE);
1262:
1263: IF PG_DEBUG = 'Y' THEN
1264: arp_util_tax.debug('Create_Lookup(-)');
1265: END IF;
1266: Exception
1267: When others then
1268: IF PG_DEBUG = 'Y' THEN

Line 1269: arp_util_tax.debug('Exception: ZX_MIGRATE_AR_TAX_GROUPS.Create_Lookup:' ||

1265: END IF;
1266: Exception
1267: When others then
1268: IF PG_DEBUG = 'Y' THEN
1269: arp_util_tax.debug('Exception: ZX_MIGRATE_AR_TAX_GROUPS.Create_Lookup:' ||
1270: SQLCODE||' ; '||SQLERRM);
1271: END IF;
1272: raise;
1273: END Create_Lookups;

Line 1301: arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.end_date_cond_cons_lk(+)');

1297: PROCEDURE end_date_cond_cons_lk is
1298: BEGIN
1299:
1300: IF PG_DEBUG = 'Y' THEN
1301: arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.end_date_cond_cons_lk(+)');
1302: END IF;
1303:
1304: UPDATE fnd_lookup_values
1305: SET ENABLED_FLAG = 'N',

Line 1321: arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.end_date_cond_cons_lk(-)');

1317: AND view_application_id = 0;
1318:
1319:
1320: IF PG_DEBUG = 'Y' THEN
1321: arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.end_date_cond_cons_lk(-)');
1322: END IF;
1323:
1324: EXCEPTION
1325: WHEN OTHERS THEN

Line 1327: arp_util_tax.debug('Exception in ZX_MIGRATE_AR_TAX_GROUPS.end_date_cond_cons_lk: '||

1323:
1324: EXCEPTION
1325: WHEN OTHERS THEN
1326: IF PG_DEBUG = 'Y' THEN
1327: arp_util_tax.debug('Exception in ZX_MIGRATE_AR_TAX_GROUPS.end_date_cond_cons_lk: '||
1328: SQLCODE||' ; '||SQLERRM);
1329: END IF;
1330:
1331: END end_date_cond_cons_lk;