512:
513: EXCEPTION
514: WHEN OTHERS THEN
515: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
516: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
517: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INSERT_TAX_DATA- '|| g_error_buffer);
518: FND_MSG_PUB.Add;
519: IF (g_level_unexpected >= g_current_runtime_level ) THEN
520: FND_LOG.STRING(g_level_unexpected,
513: EXCEPTION
514: WHEN OTHERS THEN
515: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
516: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
517: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INSERT_TAX_DATA- '|| g_error_buffer);
518: FND_MSG_PUB.Add;
519: IF (g_level_unexpected >= g_current_runtime_level ) THEN
520: FND_LOG.STRING(g_level_unexpected,
521: 'ZX.TRL.ZX_EXTRACT_PKG.INSERT_TAX_DATA',
5493:
5494: EXCEPTION
5495: WHEN OTHERS THEN
5496: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
5497: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
5498: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','BUILD_SQL- '|| g_error_buffer);
5499: FND_MSG_PUB.Add;
5500: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5501: FND_LOG.STRING(g_level_unexpected,
5494: EXCEPTION
5495: WHEN OTHERS THEN
5496: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
5497: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
5498: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','BUILD_SQL- '|| g_error_buffer);
5499: FND_MSG_PUB.Add;
5500: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5501: FND_LOG.STRING(g_level_unexpected,
5502: 'ZX.TRL.ZX_EXTRACT_PKG.BUILD_SQL',
6463:
6464: EXCEPTION
6465: WHEN VALUE_ERROR THEN
6466: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
6467: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
6468: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','EXECUTE_DYNAMIC_SQL_STRG- '|| g_error_buffer);
6469: FND_MSG_PUB.Add;
6470: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6471: FND_LOG.STRING(g_level_unexpected,
6464: EXCEPTION
6465: WHEN VALUE_ERROR THEN
6466: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
6467: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
6468: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','EXECUTE_DYNAMIC_SQL_STRG- '|| g_error_buffer);
6469: FND_MSG_PUB.Add;
6470: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6471: FND_LOG.STRING(g_level_unexpected,
6472: 'ZX.TRL.ZX_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG - Numeric error',
6475:
6476: WHEN NO_DATA_FOUND THEN
6477:
6478: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
6479: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
6480: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','EXECUTE_DYNAMIC_SQL_STRG- '|| g_error_buffer);
6481: FND_MSG_PUB.Add;
6482: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6483: FND_LOG.STRING(g_level_unexpected,
6476: WHEN NO_DATA_FOUND THEN
6477:
6478: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
6479: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
6480: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','EXECUTE_DYNAMIC_SQL_STRG- '|| g_error_buffer);
6481: FND_MSG_PUB.Add;
6482: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6483: FND_LOG.STRING(g_level_unexpected,
6484: 'ZX.TRL.ZX_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG-No data',
6486: END IF;
6487:
6488: WHEN OTHERS THEN
6489: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6490: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
6491: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','EXECUTE_DYNAMIC_SQL_STRG- '|| g_error_buffer);
6492: FND_MSG_PUB.Add;
6493: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6494: FND_LOG.STRING(g_level_unexpected,
6487:
6488: WHEN OTHERS THEN
6489: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6490: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
6491: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','EXECUTE_DYNAMIC_SQL_STRG- '|| g_error_buffer);
6492: FND_MSG_PUB.Add;
6493: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6494: FND_LOG.STRING(g_level_unexpected,
6495: 'ZX.TRL.ZX_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG',
7167:
7168: EXCEPTION
7169: WHEN OTHERS THEN
7170: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
7171: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7172: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INSERT_AR_TRX_INFO- '|| g_error_buffer);
7173: FND_MSG_PUB.Add;
7174: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7175: FND_LOG.STRING(g_level_unexpected,
7168: EXCEPTION
7169: WHEN OTHERS THEN
7170: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
7171: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7172: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INSERT_AR_TRX_INFO- '|| g_error_buffer);
7173: FND_MSG_PUB.Add;
7174: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7175: FND_LOG.STRING(g_level_unexpected,
7176: 'ZX.TRL.ZX_EXTRACT_PKG.INSERT_AR_TRX_INFO',
7646:
7647: EXCEPTION
7648: WHEN OTHERS THEN
7649: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
7650: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7651: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INIT_AR_GT_TABLES- '|| g_error_buffer);
7652: FND_MSG_PUB.Add;
7653: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7654: FND_LOG.STRING(g_level_unexpected,
7647: EXCEPTION
7648: WHEN OTHERS THEN
7649: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
7650: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7651: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INIT_AR_GT_TABLES- '|| g_error_buffer);
7652: FND_MSG_PUB.Add;
7653: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7654: FND_LOG.STRING(g_level_unexpected,
7655: 'ZX.TRL.ZX_EXTRACT_PKG.INIT_AR_GT_TABLES',
7803: END IF;
7804: EXCEPTION
7805: WHEN OTHERS THEN
7806: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
7807: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7808: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ASSIGN_AR_GLOBAL_VARIABLES- '|| g_error_buffer);
7809: FND_MSG_PUB.Add;
7810: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7811: FND_LOG.STRING(g_level_unexpected,
7804: EXCEPTION
7805: WHEN OTHERS THEN
7806: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
7807: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7808: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ASSIGN_AR_GLOBAL_VARIABLES- '|| g_error_buffer);
7809: FND_MSG_PUB.Add;
7810: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7811: FND_LOG.STRING(g_level_unexpected,
7812: 'ZX.TRL.ZX_EXTRACT_PKG.ASSIGN_AR_GLOBAL_VARIABLES',