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_UPGRADE_CONTROL_PKG dependencies on ARP_UTIL_TAX

Line 316: arp_util_tax.debug(' Insert of SYNC SUPPLIERS(+) ' );

312:
313: BEGIN
314:
315: IF P_DML_TYPE = 'I' THEN
316: arp_util_tax.debug(' Insert of SYNC SUPPLIERS(+) ' );
317:
318: INSERT INTO
319: ZX_PARTY_TAX_PROFILE(
320: Party_Tax_Profile_Id

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

439: FROM zx_party_tax_profile ptp
440: WHERE PTP.Party_ID = P_VENDOR_ID
441: AND PTP.Party_Type_code = 'SUPPLIER');
442:
443: arp_util_tax.debug(' Now calling SUPPLIER_TYPE_EXTRACT ' );
444:
445: SELECT PTP.PARTY_TAX_PROFILE_ID
446: INTO l_party_tax_profile_id
447: FROM ZX_PARTY_TAX_PROFILE PTP

Line 467: arp_util_tax.debug(' Update of SYNC SUPPLIERS (+) ' );

463: END IF; -- For P_DML_TYPE = 'I'
464:
465: IF P_DML_TYPE = 'U' THEN
466:
467: arp_util_tax.debug(' Update of SYNC SUPPLIERS (+) ' );
468:
469:
470: UPDATE ZX_PARTY_TAX_PROFILE
471: SET Rounding_Level_code =

Line 528: arp_util_tax.debug(' SYNC_SUPPLIERS(-) ' );

524: p_dml_type =>'U');
525:
526: END IF; -- For P_DML_TYPE = 'U'
527:
528: arp_util_tax.debug(' SYNC_SUPPLIERS(-) ' );
529:
530: EXCEPTION
531: WHEN OTHERS THEN
532: arp_util_tax.debug('Exception: Error Occurred during Supplier synchronization ..'||SQLERRM );

Line 532: arp_util_tax.debug('Exception: Error Occurred during Supplier synchronization ..'||SQLERRM );

528: arp_util_tax.debug(' SYNC_SUPPLIERS(-) ' );
529:
530: EXCEPTION
531: WHEN OTHERS THEN
532: arp_util_tax.debug('Exception: Error Occurred during Supplier synchronization ..'||SQLERRM );
533:
534: END SYNC_SUPPLIERS;
535:
536:

Line 742: arp_util_tax.debug(' SYNC_SUPPLIER_SITES(+) ' );

738: BEGIN
739:
740:
741: IF P_DML_TYPE = 'I' THEN
742: arp_util_tax.debug(' SYNC_SUPPLIER_SITES(+) ' );
743:
744: INSERT INTO ZX_PARTY_TAX_PROFILE(
745: Party_Tax_Profile_Id
746: ,Party_Id

Line 1151: arp_util_tax.debug(' Update of SYNC_SUPPLIER_SITES(+) ' );

1147: END IF; -- End for insert mode
1148:
1149: IF P_DML_TYPE = 'U' THEN
1150:
1151: arp_util_tax.debug(' Update of SYNC_SUPPLIER_SITES(+) ' );
1152:
1153:
1154: UPDATE ZX_PARTY_TAX_PROFILE
1155: SET

Line 1287: arp_util_tax.debug(' SYNC_SUPPLIER_SITES(-) ' );

1283: END IF; -- Brazil Localizations
1284:
1285: END IF; -- End of p_dml_type = update
1286:
1287: arp_util_tax.debug(' SYNC_SUPPLIER_SITES(-) ' );
1288:
1289: EXCEPTION
1290: WHEN OTHERS THEN
1291: arp_util_tax.debug('Exception: Error Occurred during Supplier sites Extract in PTP/REGISTRATIONS Migration '||SQLERRM );

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

1287: arp_util_tax.debug(' SYNC_SUPPLIER_SITES(-) ' );
1288:
1289: EXCEPTION
1290: WHEN OTHERS THEN
1291: arp_util_tax.debug('Exception: Error Occurred during Supplier sites Extract in PTP/REGISTRATIONS Migration '||SQLERRM );
1292:
1293: END SYNC_SUPPLIER_SITES;
1294:
1295: /* ==========================================================================*

Line 1392: arp_util_tax.debug('SYNC_GL_ACCOUNT_TAX(+)');

1388:
1389: l_tax VARCHAR2(30);
1390: BEGIN
1391:
1392: arp_util_tax.debug('SYNC_GL_ACCOUNT_TAX(+)');
1393: null;
1394: arp_util_tax.debug('SYNC_GL_ACCOUNT_TAX(-)');
1395:
1396: END SYNC_GL_ACCOUNT_TAX;

Line 1394: arp_util_tax.debug('SYNC_GL_ACCOUNT_TAX(-)');

1390: BEGIN
1391:
1392: arp_util_tax.debug('SYNC_GL_ACCOUNT_TAX(+)');
1393: null;
1394: arp_util_tax.debug('SYNC_GL_ACCOUNT_TAX(-)');
1395:
1396: END SYNC_GL_ACCOUNT_TAX;
1397:
1398: /* Following Function Call will be placed in the appropriate

Line 1639: arp_util_tax.debug('SYNC_AR_TAX_GROUP_CODES(+)');

1635:
1636: l_tax VARCHAR2(30);
1637: l_name VARCHAR2(30);
1638: BEGIN
1639: arp_util_tax.debug('SYNC_AR_TAX_GROUP_CODES(+)');
1640: IF P_TAX_GROUP_TYPE = 'AP' AND P_DML_TYPE = 'I' THEN
1641: /* Following code creates the RULEs gateway entities for the Tax codes
1642: within the Tax groups,where as the associated CONDITIONs entities
1643: for the corresponding Tax group was already created in

Line 1683: arp_util_tax.debug('SYNC_AR_TAX_GROUP_CODES(-)');

1679: p_sync_module => 'AR');
1680: -- End of sync for Default Hierarchy
1681:
1682: END IF;
1683: arp_util_tax.debug('SYNC_AR_TAX_GROUP_CODES(-)');
1684: END SYNC_AR_TAX_GROUP_CODES;
1685:
1686:
1687: /* =========================================================================*

Line 1794: arp_util_tax.debug('SYNC_AP_TAX_CODES (+)');

1790: l_tax VARCHAR2(30);
1791:
1792: BEGIN
1793: IF PG_DEBUG = 'Y' THEN
1794: arp_util_tax.debug('SYNC_AP_TAX_CODES (+)');
1795: END IF;
1796:
1797: --IF control_table THEN
1798:

Line 1886: arp_util_tax.debug('SYNC_AP_TAX_CODES (-)');

1882: END IF;
1883:
1884: --END IF;
1885: IF PG_DEBUG = 'Y' THEN
1886: arp_util_tax.debug('SYNC_AP_TAX_CODES (-)');
1887: END IF;
1888: END SYNC_AP_TAX_CODES;
1889:
1890: /* ==========================================================================*

Line 1960: arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RULES()+');

1956: P_GLOBAL_ATTRIBUTE20 IN VARCHAR2) IS
1957:
1958: BEGIN
1959: IF PG_DEBUG = 'Y' THEN
1960: arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RULES()+');
1961: END IF;
1962: null;
1963: IF PG_DEBUG = 'Y' THEN
1964: arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RULES()-');

Line 1964: arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RULES()-');

1960: arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RULES()+');
1961: END IF;
1962: null;
1963: IF PG_DEBUG = 'Y' THEN
1964: arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RULES()-');
1965: END IF;
1966: END SYNC_AP_TAX_RECVRY_RULES;
1967:
1968: /* =========================================================================*

Line 2047: arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RATES()+');

2043: P_GLOBAL_ATTRIBUTE20 IN VARCHAR2) IS
2044:
2045: BEGIN
2046: IF PG_DEBUG = 'Y' THEN
2047: arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RATES()+');
2048: END IF;
2049: IF p_dml_type = 'I' THEN
2050: ZX_MIGRATE_TAX_DEF.create_condition_groups(p_rate_id);
2051: END IF;

Line 2053: arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RATES()-');

2049: IF p_dml_type = 'I' THEN
2050: ZX_MIGRATE_TAX_DEF.create_condition_groups(p_rate_id);
2051: END IF;
2052: IF PG_DEBUG = 'Y' THEN
2053: arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RATES()-');
2054: END IF;
2055:
2056: END SYNC_AP_TAX_RECVRY_RATES;
2057:

Line 3365: arp_util_tax.debug('MIGRATE_SCO_CODE_LTE(+)');

3361: l_count NUMBER;
3362:
3363: BEGIN
3364:
3365: arp_util_tax.debug('MIGRATE_SCO_CODE_LTE(+)');
3366: arp_util_tax.debug('Regime tax Code :'||p_tax_regime_code);
3367: arp_util_tax.debug('P_ORG_ID:'||to_char(P_ORG_ID));
3368:
3369: OPEN pty_org_id_cur;

Line 3366: arp_util_tax.debug('Regime tax Code :'||p_tax_regime_code);

3362:
3363: BEGIN
3364:
3365: arp_util_tax.debug('MIGRATE_SCO_CODE_LTE(+)');
3366: arp_util_tax.debug('Regime tax Code :'||p_tax_regime_code);
3367: arp_util_tax.debug('P_ORG_ID:'||to_char(P_ORG_ID));
3368:
3369: OPEN pty_org_id_cur;
3370: FETCH pty_org_id_cur INTO l_pty_org_id;

Line 3367: arp_util_tax.debug('P_ORG_ID:'||to_char(P_ORG_ID));

3363: BEGIN
3364:
3365: arp_util_tax.debug('MIGRATE_SCO_CODE_LTE(+)');
3366: arp_util_tax.debug('Regime tax Code :'||p_tax_regime_code);
3367: arp_util_tax.debug('P_ORG_ID:'||to_char(P_ORG_ID));
3368:
3369: OPEN pty_org_id_cur;
3370: FETCH pty_org_id_cur INTO l_pty_org_id;
3371: CLOSE pty_org_id_cur;

Line 3380: arp_util_tax.debug('l_pty_org_id:'||to_char(l_pty_org_id));

3376:
3377: OPEN sub_usage_id_cur(p_tax_regime_code,l_pty_org_id);
3378: FETCH sub_usage_id_cur INTO l_count;
3379:
3380: arp_util_tax.debug('l_pty_org_id:'||to_char(l_pty_org_id));
3381: IF sub_usage_id_cur%NOTFOUND THEN
3382: BEGIN
3383: arp_util_tax.debug('sub_usage_id_cur NOTFOUND :');
3384:

Line 3383: arp_util_tax.debug('sub_usage_id_cur NOTFOUND :');

3379:
3380: arp_util_tax.debug('l_pty_org_id:'||to_char(l_pty_org_id));
3381: IF sub_usage_id_cur%NOTFOUND THEN
3382: BEGIN
3383: arp_util_tax.debug('sub_usage_id_cur NOTFOUND :');
3384:
3385: SELECT zx_regimes_usages_s.nextval
3386: INTO l_regime_usage_id
3387: FROM dual;

Line 3503: arp_util_tax.debug('MIGRATE_SCO_CODE_LTE(-)');

3499: P_LAST_UPDATE_LOGIN);
3500: END;
3501: END IF;
3502: CLOSE sub_usage_id_cur;
3503: arp_util_tax.debug('MIGRATE_SCO_CODE_LTE(-)');
3504: EXCEPTION
3505: WHEN OTHERS THEN
3506: CLOSE sub_usage_id_cur;
3507: END migrate_sco_code_lte;

Line 3625: arp_util_tax.debug('SYNC_AR_VAT_TAX(+)');

3621: l_tax VARCHAR2(30);
3622: --x_return_status VARCHAR2(30);
3623: BEGIN
3624:
3625: arp_util_tax.debug('SYNC_AR_VAT_TAX(+)');
3626: arp_util_tax.debug('p_vat_tax_id :'||to_char(p_vat_tax_id));
3627: arp_util_tax.debug('p_dml_type :'||p_dml_type);
3628: arp_util_tax.debug('p_tax_type :'||p_tax_type);
3629:

Line 3626: arp_util_tax.debug('p_vat_tax_id :'||to_char(p_vat_tax_id));

3622: --x_return_status VARCHAR2(30);
3623: BEGIN
3624:
3625: arp_util_tax.debug('SYNC_AR_VAT_TAX(+)');
3626: arp_util_tax.debug('p_vat_tax_id :'||to_char(p_vat_tax_id));
3627: arp_util_tax.debug('p_dml_type :'||p_dml_type);
3628: arp_util_tax.debug('p_tax_type :'||p_tax_type);
3629:
3630: IF p_dml_type = 'I' THEN

Line 3627: arp_util_tax.debug('p_dml_type :'||p_dml_type);

3623: BEGIN
3624:
3625: arp_util_tax.debug('SYNC_AR_VAT_TAX(+)');
3626: arp_util_tax.debug('p_vat_tax_id :'||to_char(p_vat_tax_id));
3627: arp_util_tax.debug('p_dml_type :'||p_dml_type);
3628: arp_util_tax.debug('p_tax_type :'||p_tax_type);
3629:
3630: IF p_dml_type = 'I' THEN
3631: --Tax Code Synch

Line 3628: arp_util_tax.debug('p_tax_type :'||p_tax_type);

3624:
3625: arp_util_tax.debug('SYNC_AR_VAT_TAX(+)');
3626: arp_util_tax.debug('p_vat_tax_id :'||to_char(p_vat_tax_id));
3627: arp_util_tax.debug('p_dml_type :'||p_dml_type);
3628: arp_util_tax.debug('p_tax_type :'||p_tax_type);
3629:
3630: IF p_dml_type = 'I' THEN
3631: --Tax Code Synch
3632: zx_migrate_tax_def_common.load_results_for_ar(p_vat_tax_id);

Line 3668: arp_util_tax.debug('p_dml_type'||p_dml_type);

3664:
3665: --End of Sync for AR tax defaulting process.
3666: ELSIF p_dml_type = 'U' THEN
3667:
3668: arp_util_tax.debug('p_dml_type'||p_dml_type);
3669:
3670: -- 6820043: moving description from zx_rates_b to zx_rates_tl
3671: UPDATE ZX_RATES_B_TMP
3672: SET EFFECTIVE_TO = P_END_DATE,

Line 3744: arp_util_tax.debug('SYNC_AR_VAT_TAX(-)');

3740: P_LAST_UPDATE_DATE,
3741: P_LAST_UPDATED_BY,
3742: P_LAST_UPDATE_LOGIN);
3743:
3744: arp_util_tax.debug('SYNC_AR_VAT_TAX(-)');
3745: END SYNC_AR_VAT_TAX;
3746:
3747: END ZX_UPGRADE_CONTROL_PKG ;