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_MIGRATE_TAX_DEF dependencies on FND_LOOKUPS

Line 48: arp_util_tax.debug('b:Migrate FND LOOKUPS');

44: END IF;
45: SavePoint Ap_Tax_Setup;
46:
47: BEGIN
48: arp_util_tax.debug('b:Migrate FND LOOKUPS');
49: BEGIN
50: migrate_fnd_lookups;
51: EXCEPTION WHEN OTHERS THEN
52: arp_util_tax.debug('Exception encountered in migrate_fnd_lookups:'||sqlerrm);

Line 50: migrate_fnd_lookups;

46:
47: BEGIN
48: arp_util_tax.debug('b:Migrate FND LOOKUPS');
49: BEGIN
50: migrate_fnd_lookups;
51: EXCEPTION WHEN OTHERS THEN
52: arp_util_tax.debug('Exception encountered in migrate_fnd_lookups:'||sqlerrm);
53: END;
54: arp_util_tax.debug('a:Migrate FND LOOKUPS');

Line 52: arp_util_tax.debug('Exception encountered in migrate_fnd_lookups:'||sqlerrm);

48: arp_util_tax.debug('b:Migrate FND LOOKUPS');
49: BEGIN
50: migrate_fnd_lookups;
51: EXCEPTION WHEN OTHERS THEN
52: arp_util_tax.debug('Exception encountered in migrate_fnd_lookups:'||sqlerrm);
53: END;
54: arp_util_tax.debug('a:Migrate FND LOOKUPS');
55:
56: --BugFix 3557681

Line 54: arp_util_tax.debug('a:Migrate FND LOOKUPS');

50: migrate_fnd_lookups;
51: EXCEPTION WHEN OTHERS THEN
52: arp_util_tax.debug('Exception encountered in migrate_fnd_lookups:'||sqlerrm);
53: END;
54: arp_util_tax.debug('a:Migrate FND LOOKUPS');
55:
56: --BugFix 3557681
57: arp_util_tax.debug('b:Create Tax Classifications');
58: BEGIN

Line 218: | migrate_fnd_lookups |

214: END migrate_ap_tax_codes_setup;
215:
216: /*===========================================================================+
217: | PROCEDURE |
218: | migrate_fnd_lookups |
219: | |
220: | DESCRIPTION |
221: | This routine processes AP Tax_setup related fnd_lookups and creates |
222: | appropriate ZX lookups in FND_LOOKUPS. |

Line 221: | This routine processes AP Tax_setup related fnd_lookups and creates |

217: | PROCEDURE |
218: | migrate_fnd_lookups |
219: | |
220: | DESCRIPTION |
221: | This routine processes AP Tax_setup related fnd_lookups and creates |
222: | appropriate ZX lookups in FND_LOOKUPS. |
223: | For Instance |
224: | AP_TAX_CODES_ALL.VAT_TRANSACTION_TYPE --> ZX_RATES.VAT_TRANSACTION_TYPE|
225: | |

Line 222: | appropriate ZX lookups in FND_LOOKUPS. |

218: | migrate_fnd_lookups |
219: | |
220: | DESCRIPTION |
221: | This routine processes AP Tax_setup related fnd_lookups and creates |
222: | appropriate ZX lookups in FND_LOOKUPS. |
223: | For Instance |
224: | AP_TAX_CODES_ALL.VAT_TRANSACTION_TYPE --> ZX_RATES.VAT_TRANSACTION_TYPE|
225: | |
226: | SCOPE - PUBLIC |

Line 239: PROCEDURE migrate_fnd_lookups IS

235: | 24-Dec-03 Srinivas Lokam Created. |
236: | |
237: |==========================================================================*/
238:
239: PROCEDURE migrate_fnd_lookups IS
240:
241: l_cnt PLS_INTEGER := 0;
242:
243: BEGIN

Line 245: arp_util_tax.debug('Migrate_fnd_lookups(+)');

241: l_cnt PLS_INTEGER := 0;
242:
243: BEGIN
244: IF PG_DEBUG = 'Y' THEN
245: arp_util_tax.debug('Migrate_fnd_lookups(+)');
246: END IF;
247: /* For VAT_TRANSACTION_TYPE Lookup */
248:
249: /*SELECT count(vat_transaction_type)

Line 336: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups : JEBE_VAT_TRANS_TYPE');

332: and lookup_code = ap_lookups.lookup_code);
333: EXCEPTION
334: WHEN OTHERS THEN
335: IF PG_DEBUG = 'Y' THEN
336: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups : JEBE_VAT_TRANS_TYPE');
337: arp_util_tax.debug(sqlerrm);
338: arp_util_tax.debug('Migrate_fnd_lookups(-)');
339: END IF;
340: END ;

Line 338: arp_util_tax.debug('Migrate_fnd_lookups(-)');

334: WHEN OTHERS THEN
335: IF PG_DEBUG = 'Y' THEN
336: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups : JEBE_VAT_TRANS_TYPE');
337: arp_util_tax.debug(sqlerrm);
338: arp_util_tax.debug('Migrate_fnd_lookups(-)');
339: END IF;
340: END ;
341:
342: --END IF;

Line 439: arp_util_tax.debug('Migrate_fnd_lookups(-)');

435:
436: --END IF;
437:
438: IF PG_DEBUG = 'Y' THEN
439: arp_util_tax.debug('Migrate_fnd_lookups(-)');
440: END IF;
441:
442:
443:

Line 447: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups ');

443:
444: EXCEPTION
445: WHEN OTHERS THEN
446: IF PG_DEBUG = 'Y' THEN
447: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups ');
448: arp_util_tax.debug(sqlerrm);
449: arp_util_tax.debug('Migrate_fnd_lookups(-)');
450: END IF;
451: --app_exception.raise_exception;

Line 449: arp_util_tax.debug('Migrate_fnd_lookups(-)');

445: WHEN OTHERS THEN
446: IF PG_DEBUG = 'Y' THEN
447: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups ');
448: arp_util_tax.debug(sqlerrm);
449: arp_util_tax.debug('Migrate_fnd_lookups(-)');
450: END IF;
451: --app_exception.raise_exception;
452:
453: END migrate_fnd_lookups;

Line 453: END migrate_fnd_lookups;

449: arp_util_tax.debug('Migrate_fnd_lookups(-)');
450: END IF;
451: --app_exception.raise_exception;
452:
453: END migrate_fnd_lookups;
454:
455: /*===========================================================================+
456: | PROCEDURE |
457: | Create_Tax_Classifications |

Line 461: | Tax Classification records in FND_LOOKUPS. |

457: | Create_Tax_Classifications |
458: | |
459: | DESCRIPTION |
460: | This routine processes AP Tax Codes and creates associated |
461: | Tax Classification records in FND_LOOKUPS. |
462: | |
463: | SCOPE - PUBLIC |
464: | |
465: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 7966: FND_LOOKUPS

7962: (
7963: SELECT
7964: lookup_code,lookup_type
7965: FROM
7966: FND_LOOKUPS
7967: WHERE
7968: lookup_type = 'JGZZ_TAX_ORIGIN'
7969: OR lookup_type = 'JECH_VAT_REGIME'
7970: OR lookup_type = 'JLCL_TAX_CODE_CLASS'

Line 7976: fnd_lookups

7972: SELECT
7973: lookup_code,lookup_type
7974: FROM
7975: ap_tax_codes_all,
7976: fnd_lookups
7977: WHERE
7978: (lookup_type = 'JGZZ_TAX_ORIGIN'
7979: AND global_attribute_category = 'JE.CZ.APXTADTC.TAX_ORIGIN'
7980: AND global_attribute1 = lookup_code) --Review1 changes

Line 8392: FND_LOOKUPS

8388: (
8389: SELECT
8390: lookup_code,lookup_type
8391: FROM
8392: FND_LOOKUPS
8393: WHERE
8394: lookup_type = 'JGZZ_TAX_ORIGIN'
8395: OR lookup_type = 'JECH_VAT_REGIME'
8396: OR lookup_type = 'JLCL_TAX_CODE_CLASS'

Line 8402: fnd_lookups

8398: SELECT
8399: lookup_code,lookup_type
8400: FROM
8401: ap_tax_codes_all,
8402: fnd_lookups
8403: WHERE
8404: (lookup_type = 'JGZZ_TAX_ORIGIN'
8405: AND global_attribute_category = 'JE.CZ.APXTADTC.TAX_ORIGIN'
8406: AND global_attribute1 = lookup_code) --Review1 changes