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 399: arp_util_tax.debug('REG_REP_DRIVER_PROC(+)');

395: = decode(l_multi_org_flag,'N',l_org_id,ARP.org_id(+));
396:
397: BEGIN
398:
399: arp_util_tax.debug('REG_REP_DRIVER_PROC(+)');
400:
401: ------------INITIALIZING THE FLAGS--------------------------------
402: l_ins_flag_one:=FALSE;
403: --------------Fetch all records into PL sql tables-----------------

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

451: END LOOP;
452:
453: END LOOP;
454:
455: arp_util_tax.debug('REG_REP_DRIVER_PROC(-)');
456: EXCEPTION
457: WHEN NO_DATA_FOUND THEN
458: NULL;
459: WHEN OTHERS THEN

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

456: EXCEPTION
457: WHEN NO_DATA_FOUND THEN
458: NULL;
459: WHEN OTHERS THEN
460: arp_util_tax.debug('ERROR IN REG_REP_DRIVER_PROC');
461: END REG_REP_DRIVER_PROC;
462:
463: /*=========================================================================+
464: | PROCEDURE |

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

528: and decode(l_multi_org_flag,'N',l_org_id,HrOrgUnits.organization_id) =
529: decode(l_multi_org_flag,'N',l_org_id,FinSysParam.org_id(+));
530:
531: BEGIN
532: arp_util_tax.debug('REG_REP_DRIVER_PROC_OU(+)');
533:
534: OPEN C_GET_REG_NUMBERS;
535:
536: LOOP

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

577: END IF;
578: END LOOP;
579:
580: END LOOP;
581: arp_util_tax.debug('REG_REP_DRIVER_PROC_OU(-)');
582: EXCEPTION
583: WHEN NO_DATA_FOUND THEN
584: NULL;
585: WHEN OTHERS THEN

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

582: EXCEPTION
583: WHEN NO_DATA_FOUND THEN
584: NULL;
585: WHEN OTHERS THEN
586: arp_util_tax.debug('ERROR REG_REP_DRIVER_PROC_OU');
587: END REG_REP_DRIVER_PROC_OU;
588:
589:
590:

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

614: IS
615:
616: BEGIN
617:
618: arp_util_tax.debug(' FIRST_PARTY_EXTRACT (+) ' );
619:
620: INSERT into
621: ZX_PARTY_TAX_PROFILE(
622: Party_Tax_Profile_Id,

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

683: AND decode(l_multi_org_flag,'N',l_org_id,HrOU.organization_id(+)) = XEP.legal_entity_id
684: AND not exists ( select 1 from zx_party_tax_profile
685: WHERE party_id = XEP.Party_ID and Party_Type_Code = 'FIRST_PARTY'));
686:
687: arp_util_tax.debug(' FIRST_PARTY_EXTRACT (-) ' );
688:
689: EXCEPTION
690: WHEN OTHERS THEN
691: arp_util_tax.debug('Exception: Error Occurred during First party Extract in PTP/REGISTRATIONS Migration '||SQLERRM );

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

687: arp_util_tax.debug(' FIRST_PARTY_EXTRACT (-) ' );
688:
689: EXCEPTION
690: WHEN OTHERS THEN
691: arp_util_tax.debug('Exception: Error Occurred during First party Extract in PTP/REGISTRATIONS Migration '||SQLERRM );
692:
693: END;
694:
695:

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

723: l_db_status fnd_module_installations.DB_STATUS%TYPE;
724:
725: BEGIN
726:
727: arp_util_tax.debug(' LEGAL_ESTABLISHMENT (+) ' );
728:
729: INSERT INTO ZX_PARTY_TAX_PROFILE
730: (
731: Party_Tax_Profile_Id,

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

924: EXCEPTION
925: WHEN NO_DATA_FOUND THEN
926: NULL;
927: WHEN OTHERS THEN
928: arp_util_tax.debug('Exception: Error Occurred in Supplier sites Extract in PTP/REGISTRATIONS Migration '||SQLERRM );
929: END;
930:
931: IF (nvl(l_status,'N') in ('I','S') or nvl(l_db_status,'N') in ('I','S')) THEN
932:

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

1175:
1176: END IF; -- (nvl(l_status,'N') = 'Y' or nvl(l_db_status,'N') = 'Y') Brazil Localizations
1177: -- Brazilian Tax Registation Number Upgrade
1178:
1179: arp_util_tax.debug(' LEGAL_ESTABLISHMENT (-) ' );
1180:
1181: EXCEPTION
1182: WHEN NO_DATA_FOUND THEN
1183: NULL;

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

1181: EXCEPTION
1182: WHEN NO_DATA_FOUND THEN
1183: NULL;
1184: WHEN OTHERS THEN
1185: arp_util_tax.debug('Exception: Error Occurred during Legal Establishment Extract in PTP/REGISTRATIONS Migration '||SQLERRM );
1186: END LEGAL_ESTABLISHMENT;
1187:
1188: /*===========================================================================+
1189: | Procedure : SUPPLIER_EXTRACT |

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

1227:
1228:
1229: BEGIN
1230:
1231: arp_util_tax.debug(' SUPPLIER_EXTRACT(+) ' );
1232:
1233: /*
1234: The logic to create PTPs for suppliers is to loop through po_vendors based on
1235: po_vendors.party_id. TRN will be stored in zx_party_tax_profile it self. In

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

1476: lookup_code = fnd.lookup_code) );
1477:
1478: END IF;
1479:
1480: arp_util_tax.debug(' Now calling SUPPLIER_TYPE_EXTRACT ' );
1481:
1482: ZX_PTP_MIGRATE_PKG.SUPPLIER_TYPE_EXTRACT;
1483:
1484:

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

1481:
1482: ZX_PTP_MIGRATE_PKG.SUPPLIER_TYPE_EXTRACT;
1483:
1484:
1485: arp_util_tax.debug(' Now calling SUPPLIER_ASSOC_EXTRACT ' );
1486:
1487: ZX_PTP_MIGRATE_PKG.SUPPLIER_ASSOC_EXTRACT;
1488:
1489: arp_util_tax.debug(' SUPPLIER_EXTRACT(-) ' );

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

1485: arp_util_tax.debug(' Now calling SUPPLIER_ASSOC_EXTRACT ' );
1486:
1487: ZX_PTP_MIGRATE_PKG.SUPPLIER_ASSOC_EXTRACT;
1488:
1489: arp_util_tax.debug(' SUPPLIER_EXTRACT(-) ' );
1490:
1491: EXCEPTION
1492: WHEN OTHERS THEN
1493: arp_util_tax.debug('Exception: Error Occurred during Supplier extract in PTP/REGISTRATIONS Migration '||SQLERRM );

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

1489: arp_util_tax.debug(' SUPPLIER_EXTRACT(-) ' );
1490:
1491: EXCEPTION
1492: WHEN OTHERS THEN
1493: arp_util_tax.debug('Exception: Error Occurred during Supplier extract in PTP/REGISTRATIONS Migration '||SQLERRM );
1494:
1495: END; -- End Suppliers Migration
1496:
1497: -- Supplier Sites Migration

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

1526:
1527:
1528: BEGIN
1529:
1530: arp_util_tax.debug(' SUPPLIER_SITE_EXTRACT(+) ' );
1531:
1532: /*
1533: Bug 4317072 as per this bug we would no longer be requiring the ad_parallel_update feature in the pls file
1534: Separate scripts have been written to deal with this feature

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

1895:
1896: EXCEPTION
1897:
1898: WHEN OTHERS THEN
1899: arp_util_tax.debug('Exception: Error Occurred in Supplier sites Extract in PTP/REGISTRATIONS Migration '||SQLERRM );
1900:
1901: END;
1902:
1903:

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

2128:
2129: END IF; -- (nvl(l_status,'N') = 'Y' or nvl(l_db_status,'N') = 'Y') Brazil Localizations
2130:
2131: */
2132: arp_util_tax.debug(' SUPPLIER_SITE_EXTRACT(-) ' );
2133:
2134: EXCEPTION
2135: WHEN OTHERS THEN
2136: arp_util_tax.debug('Exception: Error Occurred during Supplier sites Extract in PTP/REGISTRATIONS Migration '||SQLERRM );

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

2132: arp_util_tax.debug(' SUPPLIER_SITE_EXTRACT(-) ' );
2133:
2134: EXCEPTION
2135: WHEN OTHERS THEN
2136: arp_util_tax.debug('Exception: Error Occurred during Supplier sites Extract in PTP/REGISTRATIONS Migration '||SQLERRM );
2137:
2138: END;
2139: /*===========================================================================+
2140: | Procedure : OU_EXTRACT |

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

2160: PROCEDURE OU_EXTRACT(p_party_id in NUMBER) IS
2161:
2162: BEGIN
2163:
2164: arp_util_tax.debug(' OU_EXTRACT(+) ' );
2165: IF L_MULTI_ORG_FLAG = 'N'
2166: --Bug Fix 4460944
2167: THEN
2168: INSERT INTO

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

2297: END IF;
2298:
2299:
2300:
2301: arp_util_tax.debug(' OU_EXTRACT(-) ' );
2302:
2303: EXCEPTION
2304: WHEN OTHERS THEN
2305: arp_util_tax.debug('Exception: Error Occurred during Operating Units Extract in PTP/REGISTRATIONS Migration '||SQLERRM );

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

2301: arp_util_tax.debug(' OU_EXTRACT(-) ' );
2302:
2303: EXCEPTION
2304: WHEN OTHERS THEN
2305: arp_util_tax.debug('Exception: Error Occurred during Operating Units Extract in PTP/REGISTRATIONS Migration '||SQLERRM );
2306:
2307: END;
2308:
2309:

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

2341:
2342: PROCEDURE SUPPLIER_TYPE_EXTRACT IS
2343: BEGIN
2344:
2345: arp_util_tax.debug(' SUPPLIER_TYPE_EXTRACT .. (+) ' );
2346:
2347: -- Migrate fnd lookups source of Supplier Type
2348:
2349: arp_util_tax.debug(' Creating Fiscal classification types .. (+) ' );

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

2345: arp_util_tax.debug(' SUPPLIER_TYPE_EXTRACT .. (+) ' );
2346:
2347: -- Migrate fnd lookups source of Supplier Type
2348:
2349: arp_util_tax.debug(' Creating Fiscal classification types .. (+) ' );
2350:
2351: INSERT ALL
2352: INTO ZX_FC_TYPES_B(
2353: CLASSIFICATION_TYPE_ID,

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

2439: fc_types.CLASSIFICATION_TYPE_ID
2440: and T.LANGUAGE = L.LANGUAGE_CODE);
2441:
2442:
2443: /* arp_util_tax.debug(' Creating Fiscal classification codes .. (+) ' );
2444:
2445: INSERT ALL
2446: INTO ZX_FC_CODES_B (
2447: classification_type_code,

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

2623: CODE.CLASSIFICATION_ID
2624: and T.LANGUAGE = L.LANGUAGE_CODE);*/
2625:
2626:
2627: arp_util_tax.debug(' SUPPLIER_TYPE_EXTRACT .. (-) ' );
2628:
2629: END;
2630:
2631: /*===========================================================================+

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

2662: PROCEDURE SUPPLIER_ASSOC_EXTRACT IS
2663:
2664: BEGIN
2665:
2666: arp_util_tax.debug(' SUPPLIER_ASSOC_EXTRACT .. (+) ' );
2667: /*
2668: ---Migrate the association of Supplier Type to a Supplier.
2669: ---In PTP Extract
2670: INSERT INTO

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

2732: WHERE POV.PARTY_ID = PTP.PARTY_ID
2733: AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
2734: AND POV.VENDOR_TYPE_LOOKUP_CODE is not null;
2735: */
2736: arp_util_tax.debug(' SUPPLIER_ASSOC_EXTRACT .. (-) ' );
2737:
2738: END ;
2739:
2740: /*===========================================================================+

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

2779:
2780: BEGIN
2781:
2782:
2783: arp_util_tax.debug(' Party_Assoc_Extract .. (+) ' );
2784:
2785: IF p_party_source in ('ZX_PARTY_TAX_PROFILE' , 'PO_VENDOR' ,'PO_VENDOR_SITES') THEN
2786: l_table_owner := 'ZX_PARTY_TAX_PROFILE';
2787: ELSIF p_party_source = 'HR_ORGANIZATIONS' or p_party_source = 'AP_REPORTING_ENTITIES' THEN

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

2849:
2850:
2851: EXCEPTION
2852: WHEN OTHERS THEN
2853: arp_util_tax.debug('Error while Inserting data into
2854: HZ_CODE_ASSIGNMENTS for Party ID ' ||
2855: p_party_tax_profile_id );
2856: arp_util_tax.debug('Error Code: '||SQLCODE|| '. Error Message '|| SQLERRM);
2857:

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

2852: WHEN OTHERS THEN
2853: arp_util_tax.debug('Error while Inserting data into
2854: HZ_CODE_ASSIGNMENTS for Party ID ' ||
2855: p_party_tax_profile_id );
2856: arp_util_tax.debug('Error Code: '||SQLCODE|| '. Error Message '|| SQLERRM);
2857:
2858: END ;
2859:
2860: ELSIF p_dml_type= 'U' THEN

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

2864: -- If Update fails it means that for this record
2865: -- VENDOR_TYPE_LOOKUP_CODE was updated from Null to NOT Null
2866: -- In this case we create a new row.
2867:
2868: arp_util_tax.debug('Updating the data , since the fiscal classification code is not null now ');
2869:
2870:
2871:
2872:

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

2960:
2961:
2962: EXCEPTION
2963: WHEN OTHERS THEN
2964: arp_util_tax.debug('Error while merging data into
2965: HZ_CODE_ASSIGNMENTS for Party ID ' || p_party_tax_profile_id );
2966: arp_util_tax.debug('Error Code: '||SQLCODE||'. Error Message '|| SQLERRM);
2967: END;
2968:

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

2962: EXCEPTION
2963: WHEN OTHERS THEN
2964: arp_util_tax.debug('Error while merging data into
2965: HZ_CODE_ASSIGNMENTS for Party ID ' || p_party_tax_profile_id );
2966: arp_util_tax.debug('Error Code: '||SQLCODE||'. Error Message '|| SQLERRM);
2967: END;
2968:
2969:
2970: ELSE

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

2969:
2970: ELSE
2971:
2972:
2973: arp_util_tax.debug('Updating the data in HZ_CODE_ASSIGNMENTS ');
2974:
2975:
2976: UPDATE HZ_CODE_ASSIGNMENTS
2977: SET

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

3000:
3001: END IF;
3002:
3003:
3004: arp_util_tax.debug(' Party_Assoc_Extract .. (-) ' );
3005:
3006: END;
3007:
3008:

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

3134: where lookup_type = 'JLZZ_AP_VAT_REG_STAT_CODE' and
3135: lookup_code = fnd.lookup_code) );
3136:
3137: END IF;
3138: arp_util_tax.debug(' Now calling SUPPLIER_TYPE_EXTRACT ' );
3139:
3140: ZX_PTP_MIGRATE_PKG.SUPPLIER_TYPE_EXTRACT;
3141:
3142:

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

3139:
3140: ZX_PTP_MIGRATE_PKG.SUPPLIER_TYPE_EXTRACT;
3141:
3142:
3143: arp_util_tax.debug(' Now calling SUPPLIER_ASSOC_EXTRACT ' );
3144:
3145: ZX_PTP_MIGRATE_PKG.SUPPLIER_ASSOC_EXTRACT;
3146:
3147:

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

3182: PROCEDURE ZX_PTP_MAIN IS
3183:
3184: BEGIN
3185:
3186: arp_util_tax.debug(' ZX_PTP_MAIN .. (+) ' );
3187:
3188: arp_util_tax.debug(' Now calling FIRST_PARTY_EXTRACT.. ' );
3189:
3190: ZX_PTP_MIGRATE_PKG.FIRST_PARTY_EXTRACT(null);

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

3184: BEGIN
3185:
3186: arp_util_tax.debug(' ZX_PTP_MAIN .. (+) ' );
3187:
3188: arp_util_tax.debug(' Now calling FIRST_PARTY_EXTRACT.. ' );
3189:
3190: ZX_PTP_MIGRATE_PKG.FIRST_PARTY_EXTRACT(null);
3191:
3192: arp_util_tax.debug(' calling LEGAL_ESTABLISHMENT... ' );

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

3188: arp_util_tax.debug(' Now calling FIRST_PARTY_EXTRACT.. ' );
3189:
3190: ZX_PTP_MIGRATE_PKG.FIRST_PARTY_EXTRACT(null);
3191:
3192: arp_util_tax.debug(' calling LEGAL_ESTABLISHMENT... ' );
3193:
3194: ZX_PTP_MIGRATE_PKG.LEGAL_ESTABLISHMENT(null);
3195:
3196: /* The following calls have been commented out on account of bug 4317072

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

3199: purpose only */
3200:
3201:
3202: /*
3203: arp_util_tax.debug(' calling SUPPLIER_EXTRACT... ' );
3204:
3205: ZX_PTP_MIGRATE_PKG.SUPPLIER_EXTRACT(null, null);
3206:
3207: arp_util_tax.debug(' calling SUPPLIER_SITE_EXTRACT... ' );

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

3203: arp_util_tax.debug(' calling SUPPLIER_EXTRACT... ' );
3204:
3205: ZX_PTP_MIGRATE_PKG.SUPPLIER_EXTRACT(null, null);
3206:
3207: arp_util_tax.debug(' calling SUPPLIER_SITE_EXTRACT... ' );
3208:
3209: ZX_PTP_MIGRATE_PKG.SUPPLIER_SITE_EXTRACT(null, null) ;
3210: */
3211: END;

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

3219:
3220: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
3221:
3222: IF L_ORG_ID IS NULL THEN
3223: arp_util_tax.debug('MO: Operating Units site level profile option value not set,
3224: resulted in Null Org Id');
3225: END IF;
3226: ELSE
3227: L_ORG_ID := NULL;

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

3228: END IF;
3229:
3230: EXCEPTION
3231: WHEN OTHERS THEN
3232: arp_util_tax.debug('Exception in constructor of P2P PTP '||sqlerrm);
3233:
3234: END ZX_PTP_MIGRATE_PKG;