1240:
1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1244: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1245: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1246: FND_MSG_PUB.Add;
1247: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1248: FND_LOG.STRING(g_level_unexpected,
1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1244: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1245: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1246: FND_MSG_PUB.Add;
1247: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1248: FND_LOG.STRING(g_level_unexpected,
1249: 'ZX.TRL.ZX_GL_EXTRACT_PKG.BUILD_SQL',
1877:
1878: EXCEPTION
1879: WHEN OTHERS THEN
1880: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1881: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1882: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1883: FND_MSG_PUB.Add;
1884: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1885: FND_LOG.STRING(g_level_unexpected,
1878: EXCEPTION
1879: WHEN OTHERS THEN
1880: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1881: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1882: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1883: FND_MSG_PUB.Add;
1884: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1885: FND_LOG.STRING(g_level_unexpected,
1886: 'ZX.TRL.ZX_GL_EXTRACT_PKG.INSERT_GL_SUB_ITF',
2142:
2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2146: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2147: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2148: FND_MSG_PUB.Add;
2149: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2150: FND_LOG.STRING(g_level_unexpected,
2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2146: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2147: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2148: FND_MSG_PUB.Add;
2149: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2150: FND_LOG.STRING(g_level_unexpected,
2151: 'ZX.TRL.ZX_GL_EXTRACT_PKG.FETCH_TAX_INFO',
2836:
2837: EXCEPTION
2838: WHEN OTHERS THEN
2839: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2840: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2841: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_accounting_segments- '|| g_error_buffer);
2842: FND_MSG_PUB.Add;
2843: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2844: FND_LOG.STRING(g_level_unexpected,
2837: EXCEPTION
2838: WHEN OTHERS THEN
2839: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2840: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2841: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_accounting_segments- '|| g_error_buffer);
2842: FND_MSG_PUB.Add;
2843: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2844: FND_LOG.STRING(g_level_unexpected,
2845: 'ZX.TRL.ZX_GL_EXTRACT_PKG.GET_ACCOUNTING_SEGMENTS',