APPS.ZX_MIGRATE_UTIL dependencies on ARP_UTIL_TAX

Line 105: arp_util_tax.debug( ' IS_INSTALLED .. (+) ' );

101: l_product_id Number;
102:
103: BEGIN
104:
105: arp_util_tax.debug( ' IS_INSTALLED .. (+) ' );
106:
107: IF p_product_code = 'INV' THEN
108: l_product_id := 401;
109: ELSIF p_product_code = 'AP' THEN

Line 124: arp_util_tax.debug('Error while getting status and db status value from FND_PRODUCT_INSTALLATIONS');

120: WHERE
121: APPLICATION_ID = l_product_id;
122: EXCEPTION
123: WHEN OTHERS THEN
124: arp_util_tax.debug('Error while getting status and db status value from FND_PRODUCT_INSTALLATIONS');
125: END;
126:
127: arp_util_tax.debug( ' IS_INSTALLED .. (-) ' );
128:

Line 127: arp_util_tax.debug( ' IS_INSTALLED .. (-) ' );

123: WHEN OTHERS THEN
124: arp_util_tax.debug('Error while getting status and db status value from FND_PRODUCT_INSTALLATIONS');
125: END;
126:
127: arp_util_tax.debug( ' IS_INSTALLED .. (-) ' );
128:
129: IF (nvl(l_status,'N') in ('I','S') or
130: nvl(l_db_status,'N') in ('I','S')) THEN
131: return 'Y';

Line 158: arp_util_tax.debug('ZX_UPDATE_LOOKUPS (+) ' );

154: PROCEDURE ZX_UPDATE_LOOKUPS(P_UPGRADE_MODE IN VARCHAR2) IS
155:
156: BEGIN
157:
158: arp_util_tax.debug('ZX_UPDATE_LOOKUPS (+) ' );
159:
160: IF P_UPGRADE_MODE = 'PRE-UPGRADE' THEN
161:
162: arp_util_tax.debug(' Updating fnd_lookup_types setting the customization level to System' );

Line 162: arp_util_tax.debug(' Updating fnd_lookup_types setting the customization level to System' );

158: arp_util_tax.debug('ZX_UPDATE_LOOKUPS (+) ' );
159:
160: IF P_UPGRADE_MODE = 'PRE-UPGRADE' THEN
161:
162: arp_util_tax.debug(' Updating fnd_lookup_types setting the customization level to System' );
163:
164: UPDATE fnd_lookup_types
165: SET customization_level = 'S'
166: WHERE lookup_type in

Line 178: arp_util_tax.debug(' Updating fnd_lookup_types setting the customization level to Extensible..' );

174: );
175:
176: ELSE
177:
178: arp_util_tax.debug(' Updating fnd_lookup_types setting the customization level to Extensible..' );
179:
180: UPDATE fnd_lookup_types
181: SET customization_level = 'U'
182: WHERE lookup_type in

Line 190: arp_util_tax.debug(' Updating fnd_lookup_types setting the customization level to user..' );

186: -- Tax Def Lookups
187: 'JLCL_TAX_CODE_CLASS'
188: );
189:
190: arp_util_tax.debug(' Updating fnd_lookup_types setting the customization level to user..' );
191:
192: UPDATE fnd_lookup_types
193: SET customization_level = 'E'
194: WHERE lookup_type in

Line 203: arp_util_tax.debug(' ZX_UPDATE_LOOKUPS (-) ' );

199: );
200:
201: END IF;
202:
203: arp_util_tax.debug(' ZX_UPDATE_LOOKUPS (-) ' );
204:
205: END ZX_UPDATE_LOOKUPS;
206:
207:

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

381:
382: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
383:
384: IF L_ORG_ID IS NULL THEN
385: arp_util_tax.debug('MO: Operating Units site level profile option value not set , resulted in Null Org Id');
386: END IF;
387: ELSE
388: L_ORG_ID := NULL;
389: END IF;

Line 395: arp_util_tax.debug('Exception in constructor of Migrate Util '||sqlerrm);

391:
392:
393: EXCEPTION
394: WHEN OTHERS THEN
395: arp_util_tax.debug('Exception in constructor of Migrate Util '||sqlerrm);
396:
397:
398: end Zx_Migrate_Util;