DBA Data[Home] [Help]

APPS.ZX_AR_EXTRACT_PKG dependencies on FND_MESSAGE

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

514:
515: EXCEPTION
516: WHEN OTHERS THEN
517: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
518: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
519: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_tax_data- '|| g_error_buffer);
520: FND_MSG_PUB.Add;
521: IF (g_level_unexpected >= g_current_runtime_level ) THEN
522: FND_LOG.STRING(g_level_unexpected,

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

515: EXCEPTION
516: WHEN OTHERS THEN
517: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
518: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
519: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_tax_data- '|| g_error_buffer);
520: FND_MSG_PUB.Add;
521: IF (g_level_unexpected >= g_current_runtime_level ) THEN
522: FND_LOG.STRING(g_level_unexpected,
523: 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_tax_data',

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

7733:
7734: EXCEPTION
7735: WHEN OTHERS THEN
7736: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
7737: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7738: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','build_sql- '|| g_error_buffer);
7739: FND_MSG_PUB.Add;
7740: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7741: FND_LOG.STRING(g_level_unexpected,

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

7734: EXCEPTION
7735: WHEN OTHERS THEN
7736: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
7737: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7738: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','build_sql- '|| g_error_buffer);
7739: FND_MSG_PUB.Add;
7740: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7741: FND_LOG.STRING(g_level_unexpected,
7742: 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

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

8375: FND_FILE.put_line(which => FND_FILE.LOG
8376: ,buff => 'Exception in VALUE_ERROR ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg : ' || SQLERRM);
8377: END IF;
8378: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
8379: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8380: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8381: FND_MSG_PUB.Add;
8382: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8383: FND_LOG.STRING(g_level_unexpected,

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

8376: ,buff => 'Exception in VALUE_ERROR ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg : ' || SQLERRM);
8377: END IF;
8378: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
8379: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8380: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8381: FND_MSG_PUB.Add;
8382: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8383: FND_LOG.STRING(g_level_unexpected,
8384: 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg - Numeric error',

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

8391: FND_FILE.put_line(which => FND_FILE.LOG
8392: ,buff => 'Exception in NO_DATA_FOUND ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg : ' || SQLERRM);
8393: END IF;
8394: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
8395: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8396: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8397: FND_MSG_PUB.Add;
8398: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8399: FND_LOG.STRING(g_level_unexpected,

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

8392: ,buff => 'Exception in NO_DATA_FOUND ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg : ' || SQLERRM);
8393: END IF;
8394: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);
8395: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8396: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8397: FND_MSG_PUB.Add;
8398: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8399: FND_LOG.STRING(g_level_unexpected,
8400: 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg-No data',

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

8407: FND_FILE.put_line(which => FND_FILE.LOG
8408: ,buff => 'Exception in OTHERS ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg : ' || SQLERRM);
8409: END IF;
8410: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
8411: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8412: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8413: FND_MSG_PUB.Add;
8414: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8415: FND_LOG.STRING(g_level_unexpected,

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

8408: ,buff => 'Exception in OTHERS ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg : ' || SQLERRM);
8409: END IF;
8410: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
8411: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8412: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8413: FND_MSG_PUB.Add;
8414: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8415: FND_LOG.STRING(g_level_unexpected,
8416: 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',

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

8880:
8881: EXCEPTION
8882: WHEN OTHERS THEN
8883: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
8884: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8885: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_ar_trx_info- '|| g_error_buffer);
8886: FND_MSG_PUB.Add;
8887: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8888: FND_LOG.STRING(g_level_unexpected,

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

8881: EXCEPTION
8882: WHEN OTHERS THEN
8883: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
8884: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8885: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_ar_trx_info- '|| g_error_buffer);
8886: FND_MSG_PUB.Add;
8887: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8888: FND_LOG.STRING(g_level_unexpected,
8889: 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',

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

9110: GT_BANKING_ACCOUNT_ID.DELETE;
9111: EXCEPTION
9112: WHEN OTHERS THEN
9113: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
9114: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
9115: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','init_ar_gt_tables- '|| g_error_buffer);
9116: FND_MSG_PUB.Add;
9117: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9118: FND_LOG.STRING(g_level_unexpected,

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

9111: EXCEPTION
9112: WHEN OTHERS THEN
9113: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
9114: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
9115: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','init_ar_gt_tables- '|| g_error_buffer);
9116: FND_MSG_PUB.Add;
9117: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9118: FND_LOG.STRING(g_level_unexpected,
9119: 'ZX.TRL.ZX_AR_EXTRACT_PKG.init_ar_gt_tables',

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

9290: END IF;
9291: EXCEPTION
9292: WHEN OTHERS THEN
9293: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
9294: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
9295: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','assign_ar_global_variables- '|| g_error_buffer);
9296: FND_MSG_PUB.Add;
9297: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9298: FND_LOG.STRING(g_level_unexpected,

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

9291: EXCEPTION
9292: WHEN OTHERS THEN
9293: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
9294: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
9295: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','assign_ar_global_variables- '|| g_error_buffer);
9296: FND_MSG_PUB.Add;
9297: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9298: FND_LOG.STRING(g_level_unexpected,
9299: 'ZX.TRL.ZX_AR_EXTRACT_PKG.assign_ar_global_variables',