DBA Data[Home] [Help]

APPS.ZX_PTP_CUST_MIG_PKG dependencies on ARP_UTIL_TAX

Line 54: arp_util_tax.debug(' CUSTOMER_MIGRATE (+) ' );

50:
51: PROCEDURE CUSTOMER_MIGRATE IS
52: BEGIN
53:
54: arp_util_tax.debug(' CUSTOMER_MIGRATE (+) ' );
55:
56: arp_util_tax.debug(' Creating Customer PTP ' );
57:
58:

Line 56: arp_util_tax.debug(' Creating Customer PTP ' );

52: BEGIN
53:
54: arp_util_tax.debug(' CUSTOMER_MIGRATE (+) ' );
55:
56: arp_util_tax.debug(' Creating Customer PTP ' );
57:
58:
59: INSERT ALL
60: INTO

Line 152: arp_util_tax.debug(' CUSTOMER_MIGRATE (-) ' );

148: where party_id = HZP.PARTY_ID and Party_Type_Code = 'THIRD_PARTY'
149: );
150:
151:
152: arp_util_tax.debug(' CUSTOMER_MIGRATE (-) ' );
153:
154:
155: EXCEPTION
156: WHEN OTHERS THEN

Line 157: arp_util_tax.debug('Exception: Error Occurred during PTP Customer '|| SQLERRM );

153:
154:
155: EXCEPTION
156: WHEN OTHERS THEN
157: arp_util_tax.debug('Exception: Error Occurred during PTP Customer '|| SQLERRM );
158:
159: END CUSTOMER_MIGRATE;
160:
161:

Line 190: arp_util_tax.debug(' CUSTOMER_SITE_MIGRATE(+) ' );

186: l_status fnd_module_installations.status%TYPE;
187: l_db_status fnd_module_installations.DB_STATUS%TYPE;
188:
189: BEGIN
190: arp_util_tax.debug(' CUSTOMER_SITE_MIGRATE(+) ' );
191: arp_util_tax.debug(' Creating customer site PTP ' );
192:
193:
194: INSERT

Line 191: arp_util_tax.debug(' Creating customer site PTP ' );

187: l_db_status fnd_module_installations.DB_STATUS%TYPE;
188:
189: BEGIN
190: arp_util_tax.debug(' CUSTOMER_SITE_MIGRATE(+) ' );
191: arp_util_tax.debug(' Creating customer site PTP ' );
192:
193:
194: INSERT
195: INTO

Line 285: arp_util_tax.debug('Exception: Error in Cust Site Migration' || SQLERRM );

281:
282:
283: EXCEPTION
284: When Others then
285: arp_util_tax.debug('Exception: Error in Cust Site Migration' || SQLERRM );
286: arp_util_tax.debug(' CUSTOMER_SITE_USES Registration creation (-) ' );
287:
288:
289: END CUSTOMER_SITE_MIGRATE ;

Line 286: arp_util_tax.debug(' CUSTOMER_SITE_USES Registration creation (-) ' );

282:
283: EXCEPTION
284: When Others then
285: arp_util_tax.debug('Exception: Error in Cust Site Migration' || SQLERRM );
286: arp_util_tax.debug(' CUSTOMER_SITE_USES Registration creation (-) ' );
287:
288:
289: END CUSTOMER_SITE_MIGRATE ;
290:

Line 316: arp_util_tax.debug('Create_Lookup(+)');

312:
313: PROCEDURE Create_Lookups IS
314: BEGIN
315: IF PG_DEBUG = 'Y' THEN
316: arp_util_tax.debug('Create_Lookup(+)');
317: END IF;
318:
319: INSERT ALL
320: WHEN (NOT EXISTS

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

471: and lookup_type = 'ZX_PTPTR_GEO_TYPE_CLASS'
472: and language = l.LANGUAGE_CODE);
473:
474: IF PG_DEBUG = 'Y' THEN
475: arp_util_tax.debug('Create_Lookup(-)');
476: END IF;
477:
478: END Create_Lookups;
479:

Line 510: arp_util_tax.debug(' ZX_PTP_CUST_MIG... (+) ' );

506: BEGIN
507:
508: EXECUTE IMMEDIATE 'ALTER SEQUENCE ZX.ZX_PARTY_TAX_PROFILE_S CACHE 20000';
509:
510: arp_util_tax.debug(' ZX_PTP_CUST_MIG... (+) ' );
511:
512: arp_util_tax.debug(' Calling CREATE_LOOKUPS.. ' );
513:
514: --ZX_PTP_CUST_MIG_PKG.CREATE_LOOKUPS;

Line 512: arp_util_tax.debug(' Calling CREATE_LOOKUPS.. ' );

508: EXECUTE IMMEDIATE 'ALTER SEQUENCE ZX.ZX_PARTY_TAX_PROFILE_S CACHE 20000';
509:
510: arp_util_tax.debug(' ZX_PTP_CUST_MIG... (+) ' );
511:
512: arp_util_tax.debug(' Calling CREATE_LOOKUPS.. ' );
513:
514: --ZX_PTP_CUST_MIG_PKG.CREATE_LOOKUPS;
515:
516: arp_util_tax.debug(' Calling CUSTOMER_MIGRATE.. ' );

Line 516: arp_util_tax.debug(' Calling CUSTOMER_MIGRATE.. ' );

512: arp_util_tax.debug(' Calling CREATE_LOOKUPS.. ' );
513:
514: --ZX_PTP_CUST_MIG_PKG.CREATE_LOOKUPS;
515:
516: arp_util_tax.debug(' Calling CUSTOMER_MIGRATE.. ' );
517:
518: --ZX_PTP_CUST_MIG_PKG.CUSTOMER_MIGRATE;
519:
520: arp_util_tax.debug(' Calling CUSTOMER_SITE_MIGRATE.. ' );

Line 520: arp_util_tax.debug(' Calling CUSTOMER_SITE_MIGRATE.. ' );

516: arp_util_tax.debug(' Calling CUSTOMER_MIGRATE.. ' );
517:
518: --ZX_PTP_CUST_MIG_PKG.CUSTOMER_MIGRATE;
519:
520: arp_util_tax.debug(' Calling CUSTOMER_SITE_MIGRATE.. ' );
521:
522: --ZX_PTP_CUST_MIG_PKG.CUSTOMER_SITE_MIGRATE;
523:
524: EXECUTE IMMEDIATE 'ALTER SEQUENCE ZX.ZX_PARTY_TAX_PROFILE_S CACHE 20';