eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_PTP_MIGRATE_PKG dependencies on ARP_UTIL_TAX

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

80: IS
81: BEGIN
82:
83:
84: arp_util_tax.debug('ZX_CREATE_REG(+)');
85:
86:
87: INSERT
88: INTO ZX_REGISTRATIONS (

Line 167: arp_util_tax.debug('ZX_CREATE_REG(-)');

163: AND NOT EXISTS
164: (SELECT 1 FROM ZX_REGISTRATIONS WHERE REGISTRATION_NUMBER=p_reg_info
165: AND party_tax_profile_id = p_ptp_id);
166:
167: arp_util_tax.debug('ZX_CREATE_REG(-)');
168:
169:
170: END ZX_CREATE_REG;
171:

Line 212: arp_util_tax.debug('ZX_CREATE_REGISTRATIONS(+)');

208: IS
209: BEGIN
210:
211:
212: arp_util_tax.debug('ZX_CREATE_REGISTRATIONS(+)');
213:
214: IF p_ptp_id is not null THEN
215:
216: IF p_level = 1 THEN

Line 236: arp_util_tax.debug('ZX_CREATE_REGISTRATIONS(-)');

232:
233: END IF;
234:
235:
236: arp_util_tax.debug('ZX_CREATE_REGISTRATIONS(-)');
237:
238: END IF;
239: END ZX_CREATE_REGISTRATIONS;
240:

Line 284: arp_util_tax.debug('ZX_CREATE_REP_TYPE_ASSOC(+)');

280:
281: I NUMBER;
282: BEGIN
283:
284: arp_util_tax.debug('ZX_CREATE_REP_TYPE_ASSOC(+)');
285:
286: IF p_ptp_id IS NOT NULL THEN
287:
288: IF p_level =2 THEN

Line 309: arp_util_tax.debug('ZX_CREATE_REP_TYPE_ASSOC(-)');

305: END IF;
306:
307: END IF;
308:
309: arp_util_tax.debug('ZX_CREATE_REP_TYPE_ASSOC(-)');
310:
311:
312: END ZX_CREATE_REP_TYPE_ASSOC;
313:

Line 410: arp_util_tax.debug('REG_REP_DRIVER_PROC(+)');

406: = decode(l_multi_org_flag,'N',l_org_id,ARP.org_id(+));
407:
408: BEGIN
409:
410: arp_util_tax.debug('REG_REP_DRIVER_PROC(+)');
411:
412: ------------INITIALIZING THE FLAGS--------------------------------
413: l_ins_flag_one:=FALSE;
414: --------------Fetch all records into PL sql tables-----------------

Line 466: arp_util_tax.debug('REG_REP_DRIVER_PROC(-)');

462: END LOOP;
463:
464: END LOOP;
465:
466: arp_util_tax.debug('REG_REP_DRIVER_PROC(-)');
467: EXCEPTION
468: WHEN NO_DATA_FOUND THEN
469: NULL;
470: WHEN OTHERS THEN

Line 471: arp_util_tax.debug('ERROR IN REG_REP_DRIVER_PROC');

467: EXCEPTION
468: WHEN NO_DATA_FOUND THEN
469: NULL;
470: WHEN OTHERS THEN
471: arp_util_tax.debug('ERROR IN REG_REP_DRIVER_PROC');
472: END REG_REP_DRIVER_PROC;
473:
474: /*=========================================================================+
475: | PROCEDURE |

Line 543: arp_util_tax.debug('REG_REP_DRIVER_PROC_OU(+)');

539: and decode(l_multi_org_flag,'N',l_org_id,HrOrgUnits.organization_id) =
540: decode(l_multi_org_flag,'N',l_org_id,FinSysParam.org_id(+));
541:
542: BEGIN
543: arp_util_tax.debug('REG_REP_DRIVER_PROC_OU(+)');
544:
545: OPEN C_GET_REG_NUMBERS;
546:
547: LOOP

Line 592: arp_util_tax.debug('REG_REP_DRIVER_PROC_OU(-)');

588: END IF;
589: END LOOP;
590:
591: END LOOP;
592: arp_util_tax.debug('REG_REP_DRIVER_PROC_OU(-)');
593: EXCEPTION
594: WHEN NO_DATA_FOUND THEN
595: NULL;
596: WHEN OTHERS THEN

Line 597: arp_util_tax.debug('ERROR REG_REP_DRIVER_PROC_OU');

593: EXCEPTION
594: WHEN NO_DATA_FOUND THEN
595: NULL;
596: WHEN OTHERS THEN
597: arp_util_tax.debug('ERROR REG_REP_DRIVER_PROC_OU');
598: END REG_REP_DRIVER_PROC_OU;
599:
600:
601:

Line 629: arp_util_tax.debug(' FIRST_PARTY_EXTRACT (+) ' );

625: IS
626:
627: BEGIN
628:
629: arp_util_tax.debug(' FIRST_PARTY_EXTRACT (+) ' );
630:
631: INSERT into
632: ZX_PARTY_TAX_PROFILE(
633: Party_Tax_Profile_Id,

Line 698: arp_util_tax.debug(' FIRST_PARTY_EXTRACT (-) ' );

694: AND decode(l_multi_org_flag,'N',l_org_id,HrOU.organization_id(+)) = XEP.legal_entity_id
695: AND not exists ( select 1 from zx_party_tax_profile
696: WHERE party_id = XEP.Party_ID and Party_Type_Code = 'FIRST_PARTY'));
697:
698: arp_util_tax.debug(' FIRST_PARTY_EXTRACT (-) ' );
699:
700: EXCEPTION
701: WHEN OTHERS THEN
702: arp_util_tax.debug('Exception: Error Occurred during First party Extract in PTP/REGISTRATIONS Migration '||SQLERRM );

Line 702: arp_util_tax.debug('Exception: Error Occurred during First party Extract in PTP/REGISTRATIONS Migration '||SQLERRM );

698: arp_util_tax.debug(' FIRST_PARTY_EXTRACT (-) ' );
699:
700: EXCEPTION
701: WHEN OTHERS THEN
702: arp_util_tax.debug('Exception: Error Occurred during First party Extract in PTP/REGISTRATIONS Migration '||SQLERRM );
703:
704: END;
705:
706:

Line 738: arp_util_tax.debug(' LEGAL_ESTABLISHMENT (+) ' );

734: l_db_status fnd_module_installations.DB_STATUS%TYPE;
735:
736: BEGIN
737:
738: arp_util_tax.debug(' LEGAL_ESTABLISHMENT (+) ' );
739:
740: -- Following insert creates the associated establishments to the Operating units.
741:
742: INSERT INTO ZX_PARTY_TAX_PROFILE

Line 1048: arp_util_tax.debug('Exception: Error Occurred in Supplier sites Extract in PTP/REGISTRATIONS Migration '||SQLERRM );

1044: EXCEPTION
1045: WHEN NO_DATA_FOUND THEN
1046: NULL;
1047: WHEN OTHERS THEN
1048: arp_util_tax.debug('Exception: Error Occurred in Supplier sites Extract in PTP/REGISTRATIONS Migration '||SQLERRM );
1049: END;
1050:
1051: IF (nvl(l_status,'N') in ('I','S') or nvl(l_db_status,'N') in ('I','S')) THEN
1052:

Line 1299: arp_util_tax.debug(' LEGAL_ESTABLISHMENT (-) ' );

1295:
1296: END IF; -- (nvl(l_status,'N') = 'Y' or nvl(l_db_status,'N') = 'Y') Brazil Localizations
1297: -- Brazilian Tax Registation Number Upgrade
1298:
1299: arp_util_tax.debug(' LEGAL_ESTABLISHMENT (-) ' );
1300:
1301: EXCEPTION
1302: WHEN NO_DATA_FOUND THEN
1303: NULL;

Line 1305: arp_util_tax.debug('Exception: Error Occurred during Legal Establishment Extract in PTP/REGISTRATIONS Migration '||SQLERRM );

1301: EXCEPTION
1302: WHEN NO_DATA_FOUND THEN
1303: NULL;
1304: WHEN OTHERS THEN
1305: arp_util_tax.debug('Exception: Error Occurred during Legal Establishment Extract in PTP/REGISTRATIONS Migration '||SQLERRM );
1306: END LEGAL_ESTABLISHMENT;
1307:
1308: /*===========================================================================+
1309: | Procedure : SUPPLIER_EXTRACT |

Line 1351: arp_util_tax.debug(' SUPPLIER_EXTRACT(+) ' );

1347:
1348:
1349: BEGIN
1350:
1351: arp_util_tax.debug(' SUPPLIER_EXTRACT(+) ' );
1352:
1353: /*
1354: The logic to create PTPs for suppliers is to loop through po_vendors based on
1355: po_vendors.party_id. TRN will be stored in zx_party_tax_profile it self. In

Line 1600: arp_util_tax.debug(' Now calling SUPPLIER_TYPE_EXTRACT ' );

1596: lookup_code = fnd.lookup_code) );
1597:
1598: END IF;
1599:
1600: arp_util_tax.debug(' Now calling SUPPLIER_TYPE_EXTRACT ' );
1601:
1602: ZX_PTP_MIGRATE_PKG.SUPPLIER_TYPE_EXTRACT;
1603:
1604:

Line 1605: arp_util_tax.debug(' Now calling SUPPLIER_ASSOC_EXTRACT ' );

1601:
1602: ZX_PTP_MIGRATE_PKG.SUPPLIER_TYPE_EXTRACT;
1603:
1604:
1605: arp_util_tax.debug(' Now calling SUPPLIER_ASSOC_EXTRACT ' );
1606:
1607: ZX_PTP_MIGRATE_PKG.SUPPLIER_ASSOC_EXTRACT;
1608:
1609: arp_util_tax.debug(' SUPPLIER_EXTRACT(-) ' );

Line 1609: arp_util_tax.debug(' SUPPLIER_EXTRACT(-) ' );

1605: arp_util_tax.debug(' Now calling SUPPLIER_ASSOC_EXTRACT ' );
1606:
1607: ZX_PTP_MIGRATE_PKG.SUPPLIER_ASSOC_EXTRACT;
1608:
1609: arp_util_tax.debug(' SUPPLIER_EXTRACT(-) ' );
1610:
1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: arp_util_tax.debug('Exception: Error Occurred during Supplier extract in PTP/REGISTRATIONS Migration '||SQLERRM );

Line 1613: arp_util_tax.debug('Exception: Error Occurred during Supplier extract in PTP/REGISTRATIONS Migration '||SQLERRM );

1609: arp_util_tax.debug(' SUPPLIER_EXTRACT(-) ' );
1610:
1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: arp_util_tax.debug('Exception: Error Occurred during Supplier extract in PTP/REGISTRATIONS Migration '||SQLERRM );
1614:
1615: END; -- End Suppliers Migration
1616:
1617: -- Supplier Sites Migration

Line 1650: arp_util_tax.debug(' SUPPLIER_SITE_EXTRACT(+) ' );

1646:
1647:
1648: BEGIN
1649:
1650: arp_util_tax.debug(' SUPPLIER_SITE_EXTRACT(+) ' );
1651:
1652: /*
1653: Bug 4317072 as per this bug we would no longer be requiring the ad_parallel_update feature in the pls file
1654: Separate scripts have been written to deal with this feature

Line 2019: arp_util_tax.debug('Exception: Error Occurred in Supplier sites Extract in PTP/REGISTRATIONS Migration '||SQLERRM );

2015:
2016: EXCEPTION
2017:
2018: WHEN OTHERS THEN
2019: arp_util_tax.debug('Exception: Error Occurred in Supplier sites Extract in PTP/REGISTRATIONS Migration '||SQLERRM );
2020:
2021: END;
2022:
2023:

Line 2252: arp_util_tax.debug(' SUPPLIER_SITE_EXTRACT(-) ' );

2248:
2249: END IF; -- (nvl(l_status,'N') = 'Y' or nvl(l_db_status,'N') = 'Y') Brazil Localizations
2250:
2251: */
2252: arp_util_tax.debug(' SUPPLIER_SITE_EXTRACT(-) ' );
2253:
2254: EXCEPTION
2255: WHEN OTHERS THEN
2256: arp_util_tax.debug('Exception: Error Occurred during Supplier sites Extract in PTP/REGISTRATIONS Migration '||SQLERRM );

Line 2256: arp_util_tax.debug('Exception: Error Occurred during Supplier sites Extract in PTP/REGISTRATIONS Migration '||SQLERRM );

2252: arp_util_tax.debug(' SUPPLIER_SITE_EXTRACT(-) ' );
2253:
2254: EXCEPTION
2255: WHEN OTHERS THEN
2256: arp_util_tax.debug('Exception: Error Occurred during Supplier sites Extract in PTP/REGISTRATIONS Migration '||SQLERRM );
2257:
2258: END;
2259: /*===========================================================================+
2260: | Procedure : OU_EXTRACT |

Line 2284: arp_util_tax.debug(' OU_EXTRACT(+) ' );

2280: PROCEDURE OU_EXTRACT(p_party_id in NUMBER) IS
2281:
2282: BEGIN
2283:
2284: arp_util_tax.debug(' OU_EXTRACT(+) ' );
2285: IF L_MULTI_ORG_FLAG = 'N'
2286: --Bug Fix 4460944
2287: THEN
2288: INSERT INTO

Line 2421: arp_util_tax.debug(' OU_EXTRACT(-) ' );

2417: END IF;
2418:
2419:
2420:
2421: arp_util_tax.debug(' OU_EXTRACT(-) ' );
2422:
2423: EXCEPTION
2424: WHEN OTHERS THEN
2425: arp_util_tax.debug('Exception: Error Occurred during Operating Units Extract in PTP/REGISTRATIONS Migration '||SQLERRM );

Line 2425: arp_util_tax.debug('Exception: Error Occurred during Operating Units Extract in PTP/REGISTRATIONS Migration '||SQLERRM );

2421: arp_util_tax.debug(' OU_EXTRACT(-) ' );
2422:
2423: EXCEPTION
2424: WHEN OTHERS THEN
2425: arp_util_tax.debug('Exception: Error Occurred during Operating Units Extract in PTP/REGISTRATIONS Migration '||SQLERRM );
2426:
2427: END;
2428:
2429:

Line 2465: arp_util_tax.debug(' SUPPLIER_TYPE_EXTRACT .. (+) ' );

2461:
2462: PROCEDURE SUPPLIER_TYPE_EXTRACT IS
2463: BEGIN
2464:
2465: arp_util_tax.debug(' SUPPLIER_TYPE_EXTRACT .. (+) ' );
2466:
2467: -- Migrate fnd lookups source of Supplier Type
2468:
2469: arp_util_tax.debug(' Creating Fiscal classification types .. (+) ' );

Line 2469: arp_util_tax.debug(' Creating Fiscal classification types .. (+) ' );

2465: arp_util_tax.debug(' SUPPLIER_TYPE_EXTRACT .. (+) ' );
2466:
2467: -- Migrate fnd lookups source of Supplier Type
2468:
2469: arp_util_tax.debug(' Creating Fiscal classification types .. (+) ' );
2470:
2471: INSERT ALL
2472: INTO ZX_FC_TYPES_B(
2473: CLASSIFICATION_TYPE_ID,

Line 2563: /* arp_util_tax.debug(' Creating Fiscal classification codes .. (+) ' );

2559: fc_types.CLASSIFICATION_TYPE_ID
2560: and T.LANGUAGE = L.LANGUAGE_CODE);
2561:
2562:
2563: /* arp_util_tax.debug(' Creating Fiscal classification codes .. (+) ' );
2564:
2565: INSERT ALL
2566: INTO ZX_FC_CODES_B (
2567: classification_type_code,

Line 2747: arp_util_tax.debug(' SUPPLIER_TYPE_EXTRACT .. (-) ' );

2743: CODE.CLASSIFICATION_ID
2744: and T.LANGUAGE = L.LANGUAGE_CODE);*/
2745:
2746:
2747: arp_util_tax.debug(' SUPPLIER_TYPE_EXTRACT .. (-) ' );
2748:
2749: END;
2750:
2751: /*===========================================================================+

Line 2786: arp_util_tax.debug(' SUPPLIER_ASSOC_EXTRACT .. (+) ' );

2782: PROCEDURE SUPPLIER_ASSOC_EXTRACT IS
2783:
2784: BEGIN
2785:
2786: arp_util_tax.debug(' SUPPLIER_ASSOC_EXTRACT .. (+) ' );
2787: /*
2788: ---Migrate the association of Supplier Type to a Supplier.
2789: ---In PTP Extract
2790: INSERT INTO

Line 2856: arp_util_tax.debug(' SUPPLIER_ASSOC_EXTRACT .. (-) ' );

2852: WHERE POV.PARTY_ID = PTP.PARTY_ID
2853: AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
2854: AND POV.VENDOR_TYPE_LOOKUP_CODE is not null;
2855: */
2856: arp_util_tax.debug(' SUPPLIER_ASSOC_EXTRACT .. (-) ' );
2857:
2858: END ;
2859:
2860: /*===========================================================================+

Line 2903: arp_util_tax.debug(' Party_Assoc_Extract .. (+) ' );

2899:
2900: BEGIN
2901:
2902:
2903: arp_util_tax.debug(' Party_Assoc_Extract .. (+) ' );
2904:
2905: IF p_party_source in ('ZX_PARTY_TAX_PROFILE' , 'PO_VENDOR' ,'PO_VENDOR_SITES') THEN
2906: l_table_owner := 'ZX_PARTY_TAX_PROFILE';
2907: ELSIF p_party_source = 'HR_ORGANIZATIONS' or p_party_source = 'AP_REPORTING_ENTITIES' THEN

Line 2973: arp_util_tax.debug('Error while Inserting data into

2969:
2970:
2971: EXCEPTION
2972: WHEN OTHERS THEN
2973: arp_util_tax.debug('Error while Inserting data into
2974: HZ_CODE_ASSIGNMENTS for Party ID ' ||
2975: p_party_tax_profile_id );
2976: arp_util_tax.debug('Error Code: '||SQLCODE|| '. Error Message '|| SQLERRM);
2977:

Line 2976: arp_util_tax.debug('Error Code: '||SQLCODE|| '. Error Message '|| SQLERRM);

2972: WHEN OTHERS THEN
2973: arp_util_tax.debug('Error while Inserting data into
2974: HZ_CODE_ASSIGNMENTS for Party ID ' ||
2975: p_party_tax_profile_id );
2976: arp_util_tax.debug('Error Code: '||SQLCODE|| '. Error Message '|| SQLERRM);
2977:
2978: END ;
2979:
2980: ELSIF p_dml_type= 'U' THEN

Line 2988: arp_util_tax.debug('Updating the data , since the fiscal classification code is not null now ');

2984: -- If Update fails it means that for this record
2985: -- VENDOR_TYPE_LOOKUP_CODE was updated from Null to NOT Null
2986: -- In this case we create a new row.
2987:
2988: arp_util_tax.debug('Updating the data , since the fiscal classification code is not null now ');
2989:
2990:
2991:
2992:

Line 3084: arp_util_tax.debug('Error while merging data into

3080:
3081:
3082: EXCEPTION
3083: WHEN OTHERS THEN
3084: arp_util_tax.debug('Error while merging data into
3085: HZ_CODE_ASSIGNMENTS for Party ID ' || p_party_tax_profile_id );
3086: arp_util_tax.debug('Error Code: '||SQLCODE||'. Error Message '|| SQLERRM);
3087: END;
3088:

Line 3086: arp_util_tax.debug('Error Code: '||SQLCODE||'. Error Message '|| SQLERRM);

3082: EXCEPTION
3083: WHEN OTHERS THEN
3084: arp_util_tax.debug('Error while merging data into
3085: HZ_CODE_ASSIGNMENTS for Party ID ' || p_party_tax_profile_id );
3086: arp_util_tax.debug('Error Code: '||SQLCODE||'. Error Message '|| SQLERRM);
3087: END;
3088:
3089:
3090: ELSE

Line 3093: arp_util_tax.debug('Updating the data in HZ_CODE_ASSIGNMENTS ');

3089:
3090: ELSE
3091:
3092:
3093: arp_util_tax.debug('Updating the data in HZ_CODE_ASSIGNMENTS ');
3094:
3095:
3096: UPDATE HZ_CODE_ASSIGNMENTS
3097: SET

Line 3124: arp_util_tax.debug(' Party_Assoc_Extract .. (-) ' );

3120:
3121: END IF;
3122:
3123:
3124: arp_util_tax.debug(' Party_Assoc_Extract .. (-) ' );
3125:
3126: END;
3127:
3128:

Line 3258: arp_util_tax.debug(' Now calling SUPPLIER_TYPE_EXTRACT ' );

3254: where lookup_type = 'JLZZ_AP_VAT_REG_STAT_CODE' and
3255: lookup_code = fnd.lookup_code) );
3256:
3257: END IF;
3258: arp_util_tax.debug(' Now calling SUPPLIER_TYPE_EXTRACT ' );
3259:
3260: ZX_PTP_MIGRATE_PKG.SUPPLIER_TYPE_EXTRACT;
3261:
3262:

Line 3263: arp_util_tax.debug(' Now calling SUPPLIER_ASSOC_EXTRACT ' );

3259:
3260: ZX_PTP_MIGRATE_PKG.SUPPLIER_TYPE_EXTRACT;
3261:
3262:
3263: arp_util_tax.debug(' Now calling SUPPLIER_ASSOC_EXTRACT ' );
3264:
3265: ZX_PTP_MIGRATE_PKG.SUPPLIER_ASSOC_EXTRACT;
3266:
3267:

Line 3306: arp_util_tax.debug(' ZX_PTP_MAIN .. (+) ' );

3302: PROCEDURE ZX_PTP_MAIN IS
3303:
3304: BEGIN
3305:
3306: arp_util_tax.debug(' ZX_PTP_MAIN .. (+) ' );
3307:
3308: arp_util_tax.debug(' Now calling FIRST_PARTY_EXTRACT.. ' );
3309:
3310: ZX_PTP_MIGRATE_PKG.FIRST_PARTY_EXTRACT(null);

Line 3308: arp_util_tax.debug(' Now calling FIRST_PARTY_EXTRACT.. ' );

3304: BEGIN
3305:
3306: arp_util_tax.debug(' ZX_PTP_MAIN .. (+) ' );
3307:
3308: arp_util_tax.debug(' Now calling FIRST_PARTY_EXTRACT.. ' );
3309:
3310: ZX_PTP_MIGRATE_PKG.FIRST_PARTY_EXTRACT(null);
3311:
3312: arp_util_tax.debug(' calling LEGAL_ESTABLISHMENT... ' );

Line 3312: arp_util_tax.debug(' calling LEGAL_ESTABLISHMENT... ' );

3308: arp_util_tax.debug(' Now calling FIRST_PARTY_EXTRACT.. ' );
3309:
3310: ZX_PTP_MIGRATE_PKG.FIRST_PARTY_EXTRACT(null);
3311:
3312: arp_util_tax.debug(' calling LEGAL_ESTABLISHMENT... ' );
3313:
3314: ZX_PTP_MIGRATE_PKG.LEGAL_ESTABLISHMENT(null);
3315:
3316: /* The following calls have been commented out on account of bug 4317072

Line 3323: arp_util_tax.debug(' calling SUPPLIER_EXTRACT... ' );

3319: purpose only */
3320:
3321:
3322: /*
3323: arp_util_tax.debug(' calling SUPPLIER_EXTRACT... ' );
3324:
3325: ZX_PTP_MIGRATE_PKG.SUPPLIER_EXTRACT(null, null);
3326:
3327: arp_util_tax.debug(' calling SUPPLIER_SITE_EXTRACT... ' );

Line 3327: arp_util_tax.debug(' calling SUPPLIER_SITE_EXTRACT... ' );

3323: arp_util_tax.debug(' calling SUPPLIER_EXTRACT... ' );
3324:
3325: ZX_PTP_MIGRATE_PKG.SUPPLIER_EXTRACT(null, null);
3326:
3327: arp_util_tax.debug(' calling SUPPLIER_SITE_EXTRACT... ' );
3328:
3329: ZX_PTP_MIGRATE_PKG.SUPPLIER_SITE_EXTRACT(null, null) ;
3330: */
3331: END;

Line 3343: arp_util_tax.debug('MO: Operating Units site level profile option value not set,

3339:
3340: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
3341:
3342: IF L_ORG_ID IS NULL THEN
3343: arp_util_tax.debug('MO: Operating Units site level profile option value not set,
3344: resulted in Null Org Id');
3345: END IF;
3346: ELSE
3347: L_ORG_ID := NULL;

Line 3352: arp_util_tax.debug('Exception in constructor of P2P PTP '||sqlerrm);

3348: END IF;
3349:
3350: EXCEPTION
3351: WHEN OTHERS THEN
3352: arp_util_tax.debug('Exception in constructor of P2P PTP '||sqlerrm);
3353:
3354: END ZX_PTP_MIGRATE_PKG;