DBA Data[Home] [Help]

APPS.GCS_DATA_PREP_PKG dependencies on FND_MESSAGE

Line 1131: fnd_message.set_name('GCS', 'GCS_DP_SRC_LEDGER_ERR');

1127: WHEN gcs_dp_src_ledger_error THEN
1128: -- we don't need the savepoint anymore since we'll need to commit
1129: -- within Data Prep
1130: -- ROLLBACK TO main_data_prep_start;
1131: fnd_message.set_name('GCS', 'GCS_DP_SRC_LEDGER_ERR');
1132: x_errbuf := fnd_message.get;
1133: x_retcode := '2';
1134: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1135: fnd_log.STRING(fnd_log.level_error,

Line 1132: x_errbuf := fnd_message.get;

1128: -- we don't need the savepoint anymore since we'll need to commit
1129: -- within Data Prep
1130: -- ROLLBACK TO main_data_prep_start;
1131: fnd_message.set_name('GCS', 'GCS_DP_SRC_LEDGER_ERR');
1132: x_errbuf := fnd_message.get;
1133: x_retcode := '2';
1134: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1135: fnd_log.STRING(fnd_log.level_error,
1136: g_pkg_name || '.' || l_api_name,

Line 1150: fnd_message.set_name('GCS', 'GCS_DP_SRC_DATA_ERR');

1146: WHEN gcs_dp_src_data_error THEN
1147: -- bug 5071794 fix: we don't need the savepoint anymore since we'll need to commit
1148: -- within Data Prep
1149: -- ROLLBACK TO main_data_prep_start;
1150: fnd_message.set_name('GCS', 'GCS_DP_SRC_DATA_ERR');
1151: x_errbuf := fnd_message.get;
1152: x_retcode := '2';
1153: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1154: fnd_log.STRING(fnd_log.level_error,

Line 1151: x_errbuf := fnd_message.get;

1147: -- bug 5071794 fix: we don't need the savepoint anymore since we'll need to commit
1148: -- within Data Prep
1149: -- ROLLBACK TO main_data_prep_start;
1150: fnd_message.set_name('GCS', 'GCS_DP_SRC_DATA_ERR');
1151: x_errbuf := fnd_message.get;
1152: x_retcode := '2';
1153: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1154: fnd_log.STRING(fnd_log.level_error,
1155: g_pkg_name || '.' || l_api_name,

Line 1845: fnd_message.set_name(''GCS'', ''GCS_DP_NO_HIER_OBJ_DEF_ERR'');

1841: RETURN l_mapping_required;
1842: EXCEPTION
1843: WHEN gcs_dp_no_hier_obj_def_id THEN
1844: retcode := gcs_utility_pkg.g_ret_sts_error;
1845: fnd_message.set_name(''GCS'', ''GCS_DP_NO_HIER_OBJ_DEF_ERR'');
1846: fnd_message.set_token(''DIMENSION'', l_index_column_name);
1847: errbuf := fnd_message.get;
1848: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1849: THEN

Line 1846: fnd_message.set_token(''DIMENSION'', l_index_column_name);

1842: EXCEPTION
1843: WHEN gcs_dp_no_hier_obj_def_id THEN
1844: retcode := gcs_utility_pkg.g_ret_sts_error;
1845: fnd_message.set_name(''GCS'', ''GCS_DP_NO_HIER_OBJ_DEF_ERR'');
1846: fnd_message.set_token(''DIMENSION'', l_index_column_name);
1847: errbuf := fnd_message.get;
1848: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1849: THEN
1850: fnd_log.STRING (fnd_log.level_error,

Line 1847: errbuf := fnd_message.get;

1843: WHEN gcs_dp_no_hier_obj_def_id THEN
1844: retcode := gcs_utility_pkg.g_ret_sts_error;
1845: fnd_message.set_name(''GCS'', ''GCS_DP_NO_HIER_OBJ_DEF_ERR'');
1846: fnd_message.set_token(''DIMENSION'', l_index_column_name);
1847: errbuf := fnd_message.get;
1848: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1849: THEN
1850: fnd_log.STRING (fnd_log.level_error,
1851: g_pkg_name || ''.'' || l_api_name,

Line 1861: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_GLOBAL_VS_ERR'');

1857: END IF;
1858: RETURN retcode;
1859: WHEN global_vs_id_error THEN
1860: retcode := gcs_utility_pkg.g_ret_sts_error;
1861: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_GLOBAL_VS_ERR'');
1862: errbuf := fnd_message.get;
1863: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1864: THEN
1865: fnd_log.STRING (fnd_log.level_error,

Line 1862: errbuf := fnd_message.get;

1858: RETURN retcode;
1859: WHEN global_vs_id_error THEN
1860: retcode := gcs_utility_pkg.g_ret_sts_error;
1861: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_GLOBAL_VS_ERR'');
1862: errbuf := fnd_message.get;
1863: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1864: THEN
1865: fnd_log.STRING (fnd_log.level_error,
1866: g_pkg_name || ''.'' || l_api_name,

Line 1876: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_UNEXP_ERR'');

1872: END IF;
1873: RETURN retcode;
1874: WHEN OTHERS THEN
1875: retcode := gcs_utility_pkg.G_RET_STS_UNEXP_ERROR;
1876: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_UNEXP_ERR'');
1877: errbuf := fnd_message.get;
1878: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1879: THEN
1880: fnd_log.STRING (fnd_log.level_error,

Line 1877: errbuf := fnd_message.get;

1873: RETURN retcode;
1874: WHEN OTHERS THEN
1875: retcode := gcs_utility_pkg.G_RET_STS_UNEXP_ERROR;
1876: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_UNEXP_ERR'');
1877: errbuf := fnd_message.get;
1878: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1879: THEN
1880: fnd_log.STRING (fnd_log.level_error,
1881: g_pkg_name || ''.'' || l_api_name,

Line 2673: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_SUSPENSE_ERR'');

2669: END IF;
2670: EXCEPTION
2671: WHEN no_suspense_template_error THEN
2672: retcode := gcs_utility_pkg.g_ret_sts_error;
2673: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_SUSPENSE_ERR'');
2674: errbuf := fnd_message.get;
2675:
2676: DELETE FROM gcs_entry_headers
2677: WHERE entry_id IN (l_entry_id, l_stat_entry_id,

Line 2674: errbuf := fnd_message.get;

2670: EXCEPTION
2671: WHEN no_suspense_template_error THEN
2672: retcode := gcs_utility_pkg.g_ret_sts_error;
2673: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_SUSPENSE_ERR'');
2674: errbuf := fnd_message.get;
2675:
2676: DELETE FROM gcs_entry_headers
2677: WHERE entry_id IN (l_entry_id, l_stat_entry_id,
2678: l_proportional_entry_id, l_stat_proportional_entry_id);

Line 2696: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_RE_ERR'');

2692: END IF;
2693: raise gcs_dp_proc_data_error;
2694: WHEN no_re_template_error THEN
2695: retcode := gcs_utility_pkg.g_ret_sts_error;
2696: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_RE_ERR'');
2697: errbuf := fnd_message.get;
2698:
2699: DELETE FROM gcs_entry_headers
2700: WHERE entry_id IN (l_entry_id, l_stat_entry_id,

Line 2697: errbuf := fnd_message.get;

2693: raise gcs_dp_proc_data_error;
2694: WHEN no_re_template_error THEN
2695: retcode := gcs_utility_pkg.g_ret_sts_error;
2696: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_RE_ERR'');
2697: errbuf := fnd_message.get;
2698:
2699: DELETE FROM gcs_entry_headers
2700: WHERE entry_id IN (l_entry_id, l_stat_entry_id,
2701: l_proportional_entry_id, l_stat_proportional_entry_id);

Line 2721: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_DATA_ERR'');

2717: WHEN init_mapping_error THEN
2718: raise gcs_dp_proc_data_error;
2719: WHEN no_data_error THEN
2720: retcode := gcs_utility_pkg.g_ret_sts_warn;
2721: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_DATA_ERR'');
2722: errbuf := fnd_message.get;
2723: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
2724: fnd_log.STRING (fnd_log.level_error,
2725: g_pkg_name || ''.'' || l_api_name,

Line 2722: errbuf := fnd_message.get;

2718: raise gcs_dp_proc_data_error;
2719: WHEN no_data_error THEN
2720: retcode := gcs_utility_pkg.g_ret_sts_warn;
2721: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_DATA_ERR'');
2722: errbuf := fnd_message.get;
2723: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
2724: fnd_log.STRING (fnd_log.level_error,
2725: g_pkg_name || ''.'' || l_api_name,
2726: gcs_utility_pkg.g_module_failure

Line 3213: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_SUSPENSE_ERR'');

3209: END IF;
3210: EXCEPTION
3211: WHEN no_suspense_template_error THEN
3212: retcode := gcs_utility_pkg.g_ret_sts_error;
3213: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_SUSPENSE_ERR'');
3214: errbuf := fnd_message.get;
3215: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
3216: THEN
3217: fnd_log.STRING (fnd_log.level_error,

Line 3214: errbuf := fnd_message.get;

3210: EXCEPTION
3211: WHEN no_suspense_template_error THEN
3212: retcode := gcs_utility_pkg.g_ret_sts_error;
3213: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_SUSPENSE_ERR'');
3214: errbuf := fnd_message.get;
3215: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
3216: THEN
3217: fnd_log.STRING (fnd_log.level_error,
3218: g_pkg_name || ''.'' || l_api_name,

Line 3228: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_RE_ERR'');

3224: END IF;
3225: raise gcs_dp_proc_data_error;
3226: WHEN no_re_template_error THEN
3227: retcode := gcs_utility_pkg.g_ret_sts_error;
3228: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_RE_ERR'');
3229: errbuf := fnd_message.get;
3230: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
3231: THEN
3232: fnd_log.STRING (fnd_log.level_error,

Line 3229: errbuf := fnd_message.get;

3225: raise gcs_dp_proc_data_error;
3226: WHEN no_re_template_error THEN
3227: retcode := gcs_utility_pkg.g_ret_sts_error;
3228: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_RE_ERR'');
3229: errbuf := fnd_message.get;
3230: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
3231: THEN
3232: fnd_log.STRING (fnd_log.level_error,
3233: g_pkg_name || ''.'' || l_api_name,

Line 3245: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_DATA_ERR'');

3241: WHEN init_mapping_error THEN
3242: raise gcs_dp_proc_data_error;
3243: WHEN no_data_error THEN
3244: retcode := gcs_utility_pkg.g_ret_sts_warn;
3245: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_DATA_ERR'');
3246: errbuf := fnd_message.get;
3247: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
3248: fnd_log.STRING (fnd_log.level_error,
3249: g_pkg_name || ''.'' || l_api_name,

Line 3246: errbuf := fnd_message.get;

3242: raise gcs_dp_proc_data_error;
3243: WHEN no_data_error THEN
3244: retcode := gcs_utility_pkg.g_ret_sts_warn;
3245: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_DATA_ERR'');
3246: errbuf := fnd_message.get;
3247: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
3248: fnd_log.STRING (fnd_log.level_error,
3249: g_pkg_name || ''.'' || l_api_name,
3250: gcs_utility_pkg.g_module_failure

Line 3289: fnd_message.set_name('GCS', 'GCS_DP_NODIM_ERR');

3285: -- no required dimension found
3286: -- this shouldn't happen because we know for sure at least line_item is required
3287: WHEN NO_DATA_FOUND THEN
3288: ROLLBACK TO create_process_start;
3289: fnd_message.set_name('GCS', 'GCS_DP_NODIM_ERR');
3290: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
3291: fnd_log.STRING(fnd_log.level_error,
3292: g_pkg_name || '.' || l_api_name,
3293: gcs_utility_pkg.g_module_failure || ' ' ||

Line 3305: fnd_message.set_name('GCS', 'GCS_DP_UNEXP_ERR');

3301: '=========================================');
3302: WHEN OTHERS THEN
3303: ROLLBACK TO create_process_start;
3304: x_errbuf := SQLERRM;
3305: fnd_message.set_name('GCS', 'GCS_DP_UNEXP_ERR');
3306: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
3307: fnd_log.STRING(fnd_log.level_error,
3308: g_pkg_name || '.' || l_api_name,
3309: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf || ' ' ||