DBA Data[Home] [Help]

APPS.ZX_AR_ACTG_EXTRACT_PKG dependencies on FND_MESSAGE

Line 516: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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,

Line 517: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INSERT_TAX_DATA- '|| g_error_buffer);

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',

Line 5497: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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,

Line 5498: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','BUILD_SQL- '|| g_error_buffer);

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',

Line 6467: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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,

Line 6468: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','EXECUTE_DYNAMIC_SQL_STRG- '|| g_error_buffer);

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',

Line 6479: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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,

Line 6480: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','EXECUTE_DYNAMIC_SQL_STRG- '|| g_error_buffer);

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',

Line 6490: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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,

Line 6491: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','EXECUTE_DYNAMIC_SQL_STRG- '|| g_error_buffer);

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',

Line 7171: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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,

Line 7172: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INSERT_AR_TRX_INFO- '|| g_error_buffer);

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',

Line 7650: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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,

Line 7651: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INIT_AR_GT_TABLES- '|| g_error_buffer);

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',

Line 7807: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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,

Line 7808: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ASSIGN_AR_GLOBAL_VARIABLES- '|| g_error_buffer);

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',