APPS.ZX_MIGRATE_UTIL dependencies on ARP_UTIL_TAX

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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