DBA Data[Home] [Help]

APPS.ZX_AR_EXTRACT_PKG dependencies on FND_MESSAGE

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

472:
473: EXCEPTION
474: WHEN OTHERS THEN
475: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
476: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
477: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_tax_data- '|| g_error_buffer);
478: FND_MSG_PUB.Add;
479: IF (g_level_unexpected >= g_current_runtime_level ) THEN
480: FND_LOG.STRING(g_level_unexpected,

Line 477: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_tax_data- '|| g_error_buffer);

473: EXCEPTION
474: WHEN OTHERS THEN
475: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
476: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
477: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_tax_data- '|| g_error_buffer);
478: FND_MSG_PUB.Add;
479: IF (g_level_unexpected >= g_current_runtime_level ) THEN
480: FND_LOG.STRING(g_level_unexpected,
481: 'ZX.TRL.ZX_EXTRACT_PKG.insert_tax_data',

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

7723:
7724: EXCEPTION
7725: WHEN OTHERS THEN
7726: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
7727: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7728: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','build_sql- '|| g_error_buffer);
7729: FND_MSG_PUB.Add;
7730: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7731: FND_LOG.STRING(g_level_unexpected,

Line 7728: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','build_sql- '|| g_error_buffer);

7724: EXCEPTION
7725: WHEN OTHERS THEN
7726: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
7727: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7728: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','build_sql- '|| g_error_buffer);
7729: FND_MSG_PUB.Add;
7730: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7731: FND_LOG.STRING(g_level_unexpected,
7732: 'ZX.TRL.ZX_EXTRACT_PKG.build_sql',

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

8332:
8333: EXCEPTION
8334: WHEN VALUE_ERROR THEN
8335: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
8336: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8337: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8338: FND_MSG_PUB.Add;
8339: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8340: FND_LOG.STRING(g_level_unexpected,

Line 8337: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);

8333: EXCEPTION
8334: WHEN VALUE_ERROR THEN
8335: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
8336: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8337: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8338: FND_MSG_PUB.Add;
8339: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8340: FND_LOG.STRING(g_level_unexpected,
8341: 'ZX.TRL.ZX_EXTRACT_PKG.execute_dynamic_sql_strg - Numeric error',

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

8345:
8346: WHEN NO_DATA_FOUND THEN
8347:
8348: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
8349: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8350: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8351: FND_MSG_PUB.Add;
8352: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8353: FND_LOG.STRING(g_level_unexpected,

Line 8350: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);

8346: WHEN NO_DATA_FOUND THEN
8347:
8348: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
8349: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8350: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8351: FND_MSG_PUB.Add;
8352: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8353: FND_LOG.STRING(g_level_unexpected,
8354: 'ZX.TRL.ZX_EXTRACT_PKG.execute_dynamic_sql_strg-No data',

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

8357: g_retcode := 2;
8358:
8359: WHEN OTHERS THEN
8360: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
8361: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8362: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8363: FND_MSG_PUB.Add;
8364: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8365: FND_LOG.STRING(g_level_unexpected,

Line 8362: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);

8358:
8359: WHEN OTHERS THEN
8360: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
8361: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8362: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8363: FND_MSG_PUB.Add;
8364: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8365: FND_LOG.STRING(g_level_unexpected,
8366: 'ZX.TRL.ZX_EXTRACT_PKG.execute_dynamic_sql_strg',

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

8830:
8831: EXCEPTION
8832: WHEN OTHERS THEN
8833: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
8834: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8835: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_ar_trx_info- '|| g_error_buffer);
8836: FND_MSG_PUB.Add;
8837: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8838: FND_LOG.STRING(g_level_unexpected,

Line 8835: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_ar_trx_info- '|| g_error_buffer);

8831: EXCEPTION
8832: WHEN OTHERS THEN
8833: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
8834: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8835: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_ar_trx_info- '|| g_error_buffer);
8836: FND_MSG_PUB.Add;
8837: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8838: FND_LOG.STRING(g_level_unexpected,
8839: 'ZX.TRL.ZX_EXTRACT_PKG.insert_ar_trx_info',

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

9060: GT_BANKING_ACCOUNT_ID.DELETE;
9061: EXCEPTION
9062: WHEN OTHERS THEN
9063: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
9064: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
9065: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','init_ar_gt_tables- '|| g_error_buffer);
9066: FND_MSG_PUB.Add;
9067: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9068: FND_LOG.STRING(g_level_unexpected,

Line 9065: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','init_ar_gt_tables- '|| g_error_buffer);

9061: EXCEPTION
9062: WHEN OTHERS THEN
9063: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
9064: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
9065: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','init_ar_gt_tables- '|| g_error_buffer);
9066: FND_MSG_PUB.Add;
9067: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9068: FND_LOG.STRING(g_level_unexpected,
9069: 'ZX.TRL.ZX_EXTRACT_PKG.init_ar_gt_tables',

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

9234: END IF;
9235: EXCEPTION
9236: WHEN OTHERS THEN
9237: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
9238: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
9239: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','assign_ar_global_variables- '|| g_error_buffer);
9240: FND_MSG_PUB.Add;
9241: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9242: FND_LOG.STRING(g_level_unexpected,

Line 9239: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','assign_ar_global_variables- '|| g_error_buffer);

9235: EXCEPTION
9236: WHEN OTHERS THEN
9237: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
9238: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
9239: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','assign_ar_global_variables- '|| g_error_buffer);
9240: FND_MSG_PUB.Add;
9241: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9242: FND_LOG.STRING(g_level_unexpected,
9243: 'ZX.TRL.ZX_EXTRACT_PKG.assign_ar_global_variables',