942:
943: EXCEPTION
944: WHEN OTHERS THEN
945: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
946: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
947: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
948: FND_MSG_PUB.Add;
949: IF (g_level_unexpected >= g_current_runtime_level ) THEN
950: FND_LOG.STRING(g_level_unexpected,
943: EXCEPTION
944: WHEN OTHERS THEN
945: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
946: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
947: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
948: FND_MSG_PUB.Add;
949: IF (g_level_unexpected >= g_current_runtime_level ) THEN
950: FND_LOG.STRING(g_level_unexpected,
951: 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data',
1549:
1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1553: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1554: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','initialize- '|| g_error_buffer);
1555: FND_MSG_PUB.Add;
1556: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1557: FND_LOG.STRING(g_level_unexpected,
1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1553: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1554: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','initialize- '|| g_error_buffer);
1555: FND_MSG_PUB.Add;
1556: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1557: FND_LOG.STRING(g_level_unexpected,
1558: 'ZX.TRL.ZX_EXTRACT_PKG.initialize',
1781:
1782: EXCEPTION
1783: WHEN OTHERS THEN
1784: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1785: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1786: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1787: FND_MSG_PUB.Add;
1788: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1789: FND_LOG.STRING(g_level_unexpected,
1782: EXCEPTION
1783: WHEN OTHERS THEN
1784: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1785: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1786: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1787: FND_MSG_PUB.Add;
1788: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1789: FND_LOG.STRING(g_level_unexpected,
1790: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1828:
1829: EXCEPTION
1830: WHEN OTHERS THEN
1831: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1832: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1833: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1834: FND_MSG_PUB.Add;
1835: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1836: FND_LOG.STRING(g_level_unexpected,
1829: EXCEPTION
1830: WHEN OTHERS THEN
1831: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1832: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1833: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1834: FND_MSG_PUB.Add;
1835: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1836: FND_LOG.STRING(g_level_unexpected,
1837: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1851:
1852: EXCEPTION
1853: WHEN OTHERS THEN
1854: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1855: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1856: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1857: FND_MSG_PUB.Add;
1858: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1859: FND_LOG.STRING(g_level_unexpected,
1852: EXCEPTION
1853: WHEN OTHERS THEN
1854: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1855: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1856: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1857: FND_MSG_PUB.Add;
1858: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1859: FND_LOG.STRING(g_level_unexpected,
1860: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1917:
1918: EXCEPTION
1919: WHEN OTHERS THEN
1920: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1921: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1922: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1923: FND_MSG_PUB.Add;
1924: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1925: FND_LOG.STRING(g_level_unexpected,
1918: EXCEPTION
1919: WHEN OTHERS THEN
1920: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1921: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1922: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1923: FND_MSG_PUB.Add;
1924: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1925: FND_LOG.STRING(g_level_unexpected,
1926: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
2025: FETCH ledger_ou_cursor INTO l_operating_unit_id;
2026:
2027: IF ledger_ou_cursor%NOTFOUND THEN
2028: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2029: -- FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2030: -- FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2031: -- FND_MSG_PUB.Add;
2032: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2033: FND_LOG.STRING(g_level_unexpected,
2026:
2027: IF ledger_ou_cursor%NOTFOUND THEN
2028: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2029: -- FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2030: -- FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2031: -- FND_MSG_PUB.Add;
2032: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2033: FND_LOG.STRING(g_level_unexpected,
2034: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
2061:
2062: EXCEPTION
2063: WHEN OTHERS THEN
2064: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2065: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2066: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2067: FND_MSG_PUB.Add;
2068: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2069: FND_LOG.STRING(g_level_unexpected,
2062: EXCEPTION
2063: WHEN OTHERS THEN
2064: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2065: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2066: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2067: FND_MSG_PUB.Add;
2068: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2069: FND_LOG.STRING(g_level_unexpected,
2070: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
2193:
2194: EXCEPTION
2195: WHEN OTHERS THEN
2196: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2197: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2198: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2199: FND_MSG_PUB.Add;
2200: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2201: FND_LOG.STRING(g_level_unexpected,
2194: EXCEPTION
2195: WHEN OTHERS THEN
2196: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2197: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2198: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2199: FND_MSG_PUB.Add;
2200: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2201: FND_LOG.STRING(g_level_unexpected,
2202: 'ZX.TRL.ZX_EXTRACT_PKG.extract_tax_info',
2303:
2304: EXCEPTION
2305: WHEN OTHERS THEN
2306: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2307: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2308: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','extract_additional_info- '|| g_error_buffer);
2309: FND_MSG_PUB.Add;
2310: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2311: FND_LOG.STRING(g_level_unexpected,
2304: EXCEPTION
2305: WHEN OTHERS THEN
2306: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2307: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2308: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','extract_additional_info- '|| g_error_buffer);
2309: FND_MSG_PUB.Add;
2310: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2311: FND_LOG.STRING(g_level_unexpected,
2312: 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
2428:
2429: EXCEPTION
2430: WHEN OTHERS THEN
2431: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2432: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2433: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2434: FND_MSG_PUB.Add;
2435: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2436: FND_LOG.STRING(g_level_unexpected,
2429: EXCEPTION
2430: WHEN OTHERS THEN
2431: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2432: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2433: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2434: FND_MSG_PUB.Add;
2435: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2436: FND_LOG.STRING(g_level_unexpected,
2437: 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
2560: EXCEPTION
2561: WHEN OTHERS THEN
2562: STACK_ERROR('FND','SQL_PLSQL_ERROR','ERRNO',SQLCODE,'REASON',SQLERRM,
2563: 'ROUTINE','ZX_EXTRACT_PKG.CLEANUP');
2564: L_MSG := FND_MESSAGE.GET;
2565:
2566: END;
2567:
2568: declarer_id_lookup_table.delete;
3137:
3138: EXCEPTION
3139: WHEN OTHERS THEN
3140: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3141: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3142: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_rep_context_itf- '|| g_error_buffer);
3143: FND_MSG_PUB.Add;
3144: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3145: FND_LOG.STRING(g_level_unexpected,
3138: EXCEPTION
3139: WHEN OTHERS THEN
3140: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3141: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3142: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_rep_context_itf- '|| g_error_buffer);
3143: FND_MSG_PUB.Add;
3144: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3145: FND_LOG.STRING(g_level_unexpected,
3146: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3218:
3219: EXCEPTION
3220: WHEN OTHERS THEN
3221: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3222: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3223: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','location_value- '|| g_error_buffer);
3224: FND_MSG_PUB.Add;
3225: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3226: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_EXTRACT_PKG.location_value',
3219: EXCEPTION
3220: WHEN OTHERS THEN
3221: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3222: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3223: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','location_value- '|| g_error_buffer);
3224: FND_MSG_PUB.Add;
3225: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3226: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_EXTRACT_PKG.location_value',
3227: g_error_buffer);
3332:
3333: EXCEPTION
3334: WHEN OTHERS THEN
3335: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3336: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3337: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_location_column- '|| g_error_buffer);
3338: FND_MSG_PUB.Add;
3339: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3340: FND_LOG.STRING(g_level_unexpected,
3333: EXCEPTION
3334: WHEN OTHERS THEN
3335: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3336: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3337: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_location_column- '|| g_error_buffer);
3338: FND_MSG_PUB.Add;
3339: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3340: FND_LOG.STRING(g_level_unexpected,
3341: 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3376: p_token3 VARCHAR2 DEFAULT NULL,
3377: p_value3 VARCHAR2 DEFAULT NULL ) IS
3378: BEGIN
3379:
3380: fnd_message.set_name(nvl(p_application,'AR'),nvl(p_msgname,'GENERIC_MESSAGE'));
3381:
3382: IF ( p_token1 IS NOT NULL ) THEN
3383: fnd_message.set_token(p_token1, p_value1);
3384: END IF;
3379:
3380: fnd_message.set_name(nvl(p_application,'AR'),nvl(p_msgname,'GENERIC_MESSAGE'));
3381:
3382: IF ( p_token1 IS NOT NULL ) THEN
3383: fnd_message.set_token(p_token1, p_value1);
3384: END IF;
3385:
3386: IF ( p_token2 IS NOT NULL ) THEN
3387: fnd_message.set_token(p_token2, p_value2);
3383: fnd_message.set_token(p_token1, p_value1);
3384: END IF;
3385:
3386: IF ( p_token2 IS NOT NULL ) THEN
3387: fnd_message.set_token(p_token2, p_value2);
3388: END IF;
3389:
3390:
3391: IF ( p_token3 IS NOT NULL ) THEN
3388: END IF;
3389:
3390:
3391: IF ( p_token3 IS NOT NULL ) THEN
3392: fnd_message.set_token(p_token3, p_value3);
3393: END IF;
3394:
3395: END stack_error;
3396: