APPS.FEM_DATA_LOADER_PKG dependencies on FND_MESSAGE

Line 349: l_message := fnd_message.get;

345:
346: IF p_trace_what = 'SEPARATOR' THEN
347: l_message := l_separator;
348: ELSIF p_trace_what = 'MESSAGE' THEN
349: l_message := fnd_message.get;
350: ELSIF p_trace_what = 'BLANKLINE' THEN
351: l_message := '';
352: END IF;
353:

Line 2964: fnd_message.set_name('FEM','FEM_DLLDR_LOAD_DIM_MSG');

2960: WHERE table_name = p_table_name )
2961: LOOP
2962: IF l_table_name IS NULL THEN
2963: l_table_name := dim_rec.table_name;
2964: fnd_message.set_name('FEM','FEM_DLLDR_LOAD_DIM_MSG');
2965: fnd_message.set_token('TABLE_NAME',l_table_name);
2966: trace('SEPARATOR');
2967: trace('MESSAGE');
2968: ELSE

Line 2965: fnd_message.set_token('TABLE_NAME',l_table_name);

2961: LOOP
2962: IF l_table_name IS NULL THEN
2963: l_table_name := dim_rec.table_name;
2964: fnd_message.set_name('FEM','FEM_DLLDR_LOAD_DIM_MSG');
2965: fnd_message.set_token('TABLE_NAME',l_table_name);
2966: trace('SEPARATOR');
2967: trace('MESSAGE');
2968: ELSE
2969: IF l_table_name <> dim_rec.table_name THEN

Line 2971: fnd_message.set_name('FEM','FEM_DLLDR_LOAD_DIM_MSG');

2967: trace('MESSAGE');
2968: ELSE
2969: IF l_table_name <> dim_rec.table_name THEN
2970: l_table_name := dim_rec.table_name;
2971: fnd_message.set_name('FEM','FEM_DLLDR_LOAD_DIM_MSG');
2972: fnd_message.set_token('TABLE_NAME',l_table_name);
2973: trace('SEPARATOR');
2974: trace('MESSAGE');
2975: END IF;

Line 2972: fnd_message.set_token('TABLE_NAME',l_table_name);

2968: ELSE
2969: IF l_table_name <> dim_rec.table_name THEN
2970: l_table_name := dim_rec.table_name;
2971: fnd_message.set_name('FEM','FEM_DLLDR_LOAD_DIM_MSG');
2972: fnd_message.set_token('TABLE_NAME',l_table_name);
2973: trace('SEPARATOR');
2974: trace('MESSAGE');
2975: END IF;
2976: END IF;

Line 2980: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_LOADED');

2976: END IF;
2977:
2978: IF dim_rec.request_id > 0 THEN
2979: IF dim_rec.status = 'Y' THEN
2980: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_LOADED');
2981: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
2982: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2983: ELSE
2984: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_ERR');

Line 2981: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);

2977:
2978: IF dim_rec.request_id > 0 THEN
2979: IF dim_rec.status = 'Y' THEN
2980: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_LOADED');
2981: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
2982: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2983: ELSE
2984: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_ERR');
2985: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);

Line 2982: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);

2978: IF dim_rec.request_id > 0 THEN
2979: IF dim_rec.status = 'Y' THEN
2980: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_LOADED');
2981: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
2982: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2983: ELSE
2984: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_ERR');
2985: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
2986: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);

Line 2984: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_ERR');

2980: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_LOADED');
2981: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
2982: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2983: ELSE
2984: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_ERR');
2985: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
2986: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2987: END IF;
2988: ELSIF dim_rec.request_id < 0 THEN

Line 2985: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);

2981: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
2982: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2983: ELSE
2984: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_ERR');
2985: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
2986: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2987: END IF;
2988: ELSIF dim_rec.request_id < 0 THEN
2989: fnd_message.set_name('FEM', 'FEM_DLLDR_DIMENSION_NO_DATA');

Line 2986: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);

2982: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2983: ELSE
2984: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_ERR');
2985: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
2986: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2987: END IF;
2988: ELSIF dim_rec.request_id < 0 THEN
2989: fnd_message.set_name('FEM', 'FEM_DLLDR_DIMENSION_NO_DATA');
2990: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);

Line 2989: fnd_message.set_name('FEM', 'FEM_DLLDR_DIMENSION_NO_DATA');

2985: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
2986: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2987: END IF;
2988: ELSIF dim_rec.request_id < 0 THEN
2989: fnd_message.set_name('FEM', 'FEM_DLLDR_DIMENSION_NO_DATA');
2990: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2991: ELSE
2992: fnd_message.set_name('FEM', 'FEM_DLLDR_DIM_CONC_PGM_ERR');
2993: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);

Line 2990: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);

2986: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2987: END IF;
2988: ELSIF dim_rec.request_id < 0 THEN
2989: fnd_message.set_name('FEM', 'FEM_DLLDR_DIMENSION_NO_DATA');
2990: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2991: ELSE
2992: fnd_message.set_name('FEM', 'FEM_DLLDR_DIM_CONC_PGM_ERR');
2993: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2994: END IF;

Line 2992: fnd_message.set_name('FEM', 'FEM_DLLDR_DIM_CONC_PGM_ERR');

2988: ELSIF dim_rec.request_id < 0 THEN
2989: fnd_message.set_name('FEM', 'FEM_DLLDR_DIMENSION_NO_DATA');
2990: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2991: ELSE
2992: fnd_message.set_name('FEM', 'FEM_DLLDR_DIM_CONC_PGM_ERR');
2993: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2994: END IF;
2995:
2996: trace('MESSAGE');

Line 2993: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);

2989: fnd_message.set_name('FEM', 'FEM_DLLDR_DIMENSION_NO_DATA');
2990: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2991: ELSE
2992: fnd_message.set_name('FEM', 'FEM_DLLDR_DIM_CONC_PGM_ERR');
2993: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
2994: END IF;
2995:
2996: trace('MESSAGE');
2997:

Line 3047: fnd_message.set_name('FEM','FEM_DLLDR_LOAD_HIER_MSG');

3043: WHERE table_name = p_table_name )
3044: LOOP
3045: IF l_table_name IS NULL THEN
3046: l_table_name := hier_rec.table_name;
3047: fnd_message.set_name('FEM','FEM_DLLDR_LOAD_HIER_MSG');
3048: fnd_message.set_token('TABLE_NAME',l_table_name);
3049: trace('SEPARATOR');
3050: trace('MESSAGE');
3051: ELSE

Line 3048: fnd_message.set_token('TABLE_NAME',l_table_name);

3044: LOOP
3045: IF l_table_name IS NULL THEN
3046: l_table_name := hier_rec.table_name;
3047: fnd_message.set_name('FEM','FEM_DLLDR_LOAD_HIER_MSG');
3048: fnd_message.set_token('TABLE_NAME',l_table_name);
3049: trace('SEPARATOR');
3050: trace('MESSAGE');
3051: ELSE
3052: IF l_table_name <> hier_rec.table_name THEN

Line 3054: fnd_message.set_name('FEM','FEM_DLLDR_LOAD_HIER_MSG');

3050: trace('MESSAGE');
3051: ELSE
3052: IF l_table_name <> hier_rec.table_name THEN
3053: l_table_name := hier_rec.table_name;
3054: fnd_message.set_name('FEM','FEM_DLLDR_LOAD_HIER_MSG');
3055: fnd_message.set_token('TABLE_NAME',l_table_name);
3056: trace('SEPARATOR');
3057: trace('MESSAGE');
3058: END IF;

Line 3055: fnd_message.set_token('TABLE_NAME',l_table_name);

3051: ELSE
3052: IF l_table_name <> hier_rec.table_name THEN
3053: l_table_name := hier_rec.table_name;
3054: fnd_message.set_name('FEM','FEM_DLLDR_LOAD_HIER_MSG');
3055: fnd_message.set_token('TABLE_NAME',l_table_name);
3056: trace('SEPARATOR');
3057: trace('MESSAGE');
3058: END IF;
3059: END IF;

Line 3063: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_LOADED');

3059: END IF;
3060:
3061: IF hier_rec.request_id > 0 THEN
3062: IF hier_rec.status = 'Y' THEN
3063: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_LOADED');
3064: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
3065: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);
3066: ELSE
3067: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_ERR');

Line 3064: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);

3060:
3061: IF hier_rec.request_id > 0 THEN
3062: IF hier_rec.status = 'Y' THEN
3063: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_LOADED');
3064: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
3065: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);
3066: ELSE
3067: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_ERR');
3068: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);

Line 3065: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);

3061: IF hier_rec.request_id > 0 THEN
3062: IF hier_rec.status = 'Y' THEN
3063: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_LOADED');
3064: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
3065: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);
3066: ELSE
3067: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_ERR');
3068: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
3069: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);

Line 3067: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_ERR');

3063: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_LOADED');
3064: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
3065: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);
3066: ELSE
3067: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_ERR');
3068: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
3069: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);
3070: fnd_message.set_token('DIM_LABEL',hier_rec.dimension_varchar_label);
3071: END IF;

Line 3068: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);

3064: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
3065: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);
3066: ELSE
3067: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_ERR');
3068: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
3069: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);
3070: fnd_message.set_token('DIM_LABEL',hier_rec.dimension_varchar_label);
3071: END IF;
3072: ELSE

Line 3069: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);

3065: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);
3066: ELSE
3067: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_ERR');
3068: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
3069: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);
3070: fnd_message.set_token('DIM_LABEL',hier_rec.dimension_varchar_label);
3071: END IF;
3072: ELSE
3073: fnd_message.set_name('FEM', 'FEM_DLLDR_HIER_CONC_PGM_ERR');

Line 3070: fnd_message.set_token('DIM_LABEL',hier_rec.dimension_varchar_label);

3066: ELSE
3067: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_ERR');
3068: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
3069: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);
3070: fnd_message.set_token('DIM_LABEL',hier_rec.dimension_varchar_label);
3071: END IF;
3072: ELSE
3073: fnd_message.set_name('FEM', 'FEM_DLLDR_HIER_CONC_PGM_ERR');
3074: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);

Line 3073: fnd_message.set_name('FEM', 'FEM_DLLDR_HIER_CONC_PGM_ERR');

3069: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);
3070: fnd_message.set_token('DIM_LABEL',hier_rec.dimension_varchar_label);
3071: END IF;
3072: ELSE
3073: fnd_message.set_name('FEM', 'FEM_DLLDR_HIER_CONC_PGM_ERR');
3074: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);
3075: END IF;
3076:
3077: trace('MESSAGE');

Line 3074: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);

3070: fnd_message.set_token('DIM_LABEL',hier_rec.dimension_varchar_label);
3071: END IF;
3072: ELSE
3073: fnd_message.set_name('FEM', 'FEM_DLLDR_HIER_CONC_PGM_ERR');
3074: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' || hier_rec.hier_obj_def_display_name);
3075: END IF;
3076:
3077: trace('MESSAGE');
3078:

Line 3144: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_COMPLETE');

3140:
3141: IF g_master_rec(i).request_id > 0 THEN
3142: IF g_master_rec(i).status = 'Y' THEN
3143: IF g_loader_type = 'CLIENT' THEN
3144: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_COMPLETE');
3145: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3146: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3147: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3148: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);

Line 3145: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);

3141: IF g_master_rec(i).request_id > 0 THEN
3142: IF g_master_rec(i).status = 'Y' THEN
3143: IF g_loader_type = 'CLIENT' THEN
3144: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_COMPLETE');
3145: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3146: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3147: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3148: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);
3149: fnd_message.set_token('TABLE_NAME',p_table_name);

Line 3146: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);

3142: IF g_master_rec(i).status = 'Y' THEN
3143: IF g_loader_type = 'CLIENT' THEN
3144: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_COMPLETE');
3145: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3146: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3147: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3148: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);
3149: fnd_message.set_token('TABLE_NAME',p_table_name);
3150: ELSE

Line 3147: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);

3143: IF g_loader_type = 'CLIENT' THEN
3144: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_COMPLETE');
3145: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3146: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3147: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3148: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);
3149: fnd_message.set_token('TABLE_NAME',p_table_name);
3150: ELSE
3151: IF g_master_rec(i).budget_id IS NULL AND g_master_rec(i).enc_type_id IS NULL THEN

Line 3148: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);

3144: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_COMPLETE');
3145: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3146: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3147: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3148: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);
3149: fnd_message.set_token('TABLE_NAME',p_table_name);
3150: ELSE
3151: IF g_master_rec(i).budget_id IS NULL AND g_master_rec(i).enc_type_id IS NULL THEN
3152: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOAD_COMPLETE');

Line 3149: fnd_message.set_token('TABLE_NAME',p_table_name);

3145: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3146: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3147: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3148: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);
3149: fnd_message.set_token('TABLE_NAME',p_table_name);
3150: ELSE
3151: IF g_master_rec(i).budget_id IS NULL AND g_master_rec(i).enc_type_id IS NULL THEN
3152: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOAD_COMPLETE');
3153: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);

Line 3152: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOAD_COMPLETE');

3148: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);
3149: fnd_message.set_token('TABLE_NAME',p_table_name);
3150: ELSE
3151: IF g_master_rec(i).budget_id IS NULL AND g_master_rec(i).enc_type_id IS NULL THEN
3152: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOAD_COMPLETE');
3153: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3154: fnd_message.set_token('TABLE_NAME',p_table_name);
3155: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3156: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);

Line 3153: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);

3149: fnd_message.set_token('TABLE_NAME',p_table_name);
3150: ELSE
3151: IF g_master_rec(i).budget_id IS NULL AND g_master_rec(i).enc_type_id IS NULL THEN
3152: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOAD_COMPLETE');
3153: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3154: fnd_message.set_token('TABLE_NAME',p_table_name);
3155: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3156: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3157: fnd_message.set_token('ROW',p_table_row);

Line 3154: fnd_message.set_token('TABLE_NAME',p_table_name);

3150: ELSE
3151: IF g_master_rec(i).budget_id IS NULL AND g_master_rec(i).enc_type_id IS NULL THEN
3152: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOAD_COMPLETE');
3153: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3154: fnd_message.set_token('TABLE_NAME',p_table_name);
3155: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3156: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3157: fnd_message.set_token('ROW',p_table_row);
3158: ELSIF g_master_rec(i).budget_id IS NOT NULL THEN

Line 3155: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);

3151: IF g_master_rec(i).budget_id IS NULL AND g_master_rec(i).enc_type_id IS NULL THEN
3152: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOAD_COMPLETE');
3153: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3154: fnd_message.set_token('TABLE_NAME',p_table_name);
3155: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3156: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3157: fnd_message.set_token('ROW',p_table_row);
3158: ELSIF g_master_rec(i).budget_id IS NOT NULL THEN
3159: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_B');

Line 3156: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);

3152: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOAD_COMPLETE');
3153: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3154: fnd_message.set_token('TABLE_NAME',p_table_name);
3155: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3156: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3157: fnd_message.set_token('ROW',p_table_row);
3158: ELSIF g_master_rec(i).budget_id IS NOT NULL THEN
3159: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_B');
3160: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);

Line 3157: fnd_message.set_token('ROW',p_table_row);

3153: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3154: fnd_message.set_token('TABLE_NAME',p_table_name);
3155: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3156: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3157: fnd_message.set_token('ROW',p_table_row);
3158: ELSIF g_master_rec(i).budget_id IS NOT NULL THEN
3159: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_B');
3160: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3161: fnd_message.set_token('TABLE_NAME',p_table_name);

Line 3159: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_B');

3155: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3156: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3157: fnd_message.set_token('ROW',p_table_row);
3158: ELSIF g_master_rec(i).budget_id IS NOT NULL THEN
3159: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_B');
3160: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3161: fnd_message.set_token('TABLE_NAME',p_table_name);
3162: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3163: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);

Line 3160: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);

3156: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3157: fnd_message.set_token('ROW',p_table_row);
3158: ELSIF g_master_rec(i).budget_id IS NOT NULL THEN
3159: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_B');
3160: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3161: fnd_message.set_token('TABLE_NAME',p_table_name);
3162: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3163: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3164: fnd_message.set_token('BUDGET_DISPLAY_CODE', g_master_rec(i).budget_display_code);

Line 3161: fnd_message.set_token('TABLE_NAME',p_table_name);

3157: fnd_message.set_token('ROW',p_table_row);
3158: ELSIF g_master_rec(i).budget_id IS NOT NULL THEN
3159: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_B');
3160: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3161: fnd_message.set_token('TABLE_NAME',p_table_name);
3162: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3163: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3164: fnd_message.set_token('BUDGET_DISPLAY_CODE', g_master_rec(i).budget_display_code);
3165: fnd_message.set_token('ROW',p_table_row);

Line 3162: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);

3158: ELSIF g_master_rec(i).budget_id IS NOT NULL THEN
3159: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_B');
3160: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3161: fnd_message.set_token('TABLE_NAME',p_table_name);
3162: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3163: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3164: fnd_message.set_token('BUDGET_DISPLAY_CODE', g_master_rec(i).budget_display_code);
3165: fnd_message.set_token('ROW',p_table_row);
3166: ELSIF g_master_rec(i).enc_type_id IS NOT NULL THEN

Line 3163: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);

3159: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_B');
3160: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3161: fnd_message.set_token('TABLE_NAME',p_table_name);
3162: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3163: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3164: fnd_message.set_token('BUDGET_DISPLAY_CODE', g_master_rec(i).budget_display_code);
3165: fnd_message.set_token('ROW',p_table_row);
3166: ELSIF g_master_rec(i).enc_type_id IS NOT NULL THEN
3167: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_E');

Line 3164: fnd_message.set_token('BUDGET_DISPLAY_CODE', g_master_rec(i).budget_display_code);

3160: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3161: fnd_message.set_token('TABLE_NAME',p_table_name);
3162: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3163: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3164: fnd_message.set_token('BUDGET_DISPLAY_CODE', g_master_rec(i).budget_display_code);
3165: fnd_message.set_token('ROW',p_table_row);
3166: ELSIF g_master_rec(i).enc_type_id IS NOT NULL THEN
3167: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_E');
3168: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);

Line 3165: fnd_message.set_token('ROW',p_table_row);

3161: fnd_message.set_token('TABLE_NAME',p_table_name);
3162: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3163: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3164: fnd_message.set_token('BUDGET_DISPLAY_CODE', g_master_rec(i).budget_display_code);
3165: fnd_message.set_token('ROW',p_table_row);
3166: ELSIF g_master_rec(i).enc_type_id IS NOT NULL THEN
3167: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_E');
3168: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3169: fnd_message.set_token('TABLE_NAME',p_table_name);

Line 3167: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_E');

3163: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3164: fnd_message.set_token('BUDGET_DISPLAY_CODE', g_master_rec(i).budget_display_code);
3165: fnd_message.set_token('ROW',p_table_row);
3166: ELSIF g_master_rec(i).enc_type_id IS NOT NULL THEN
3167: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_E');
3168: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3169: fnd_message.set_token('TABLE_NAME',p_table_name);
3170: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3171: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);

Line 3168: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);

3164: fnd_message.set_token('BUDGET_DISPLAY_CODE', g_master_rec(i).budget_display_code);
3165: fnd_message.set_token('ROW',p_table_row);
3166: ELSIF g_master_rec(i).enc_type_id IS NOT NULL THEN
3167: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_E');
3168: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3169: fnd_message.set_token('TABLE_NAME',p_table_name);
3170: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3171: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3172: fnd_message.set_token('ENC_TYPE_CODE', g_master_rec(i).enc_type_code);

Line 3169: fnd_message.set_token('TABLE_NAME',p_table_name);

3165: fnd_message.set_token('ROW',p_table_row);
3166: ELSIF g_master_rec(i).enc_type_id IS NOT NULL THEN
3167: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_E');
3168: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3169: fnd_message.set_token('TABLE_NAME',p_table_name);
3170: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3171: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3172: fnd_message.set_token('ENC_TYPE_CODE', g_master_rec(i).enc_type_code);
3173: fnd_message.set_token('ROW',p_table_row);

Line 3170: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);

3166: ELSIF g_master_rec(i).enc_type_id IS NOT NULL THEN
3167: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_E');
3168: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3169: fnd_message.set_token('TABLE_NAME',p_table_name);
3170: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3171: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3172: fnd_message.set_token('ENC_TYPE_CODE', g_master_rec(i).enc_type_code);
3173: fnd_message.set_token('ROW',p_table_row);
3174: END IF;

Line 3171: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);

3167: fnd_message.set_name('FEM', 'FEM_DLLDR_LDGR_LOAD_COMPLETE_E');
3168: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3169: fnd_message.set_token('TABLE_NAME',p_table_name);
3170: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3171: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3172: fnd_message.set_token('ENC_TYPE_CODE', g_master_rec(i).enc_type_code);
3173: fnd_message.set_token('ROW',p_table_row);
3174: END IF;
3175: END IF;

Line 3172: fnd_message.set_token('ENC_TYPE_CODE', g_master_rec(i).enc_type_code);

3168: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3169: fnd_message.set_token('TABLE_NAME',p_table_name);
3170: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3171: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3172: fnd_message.set_token('ENC_TYPE_CODE', g_master_rec(i).enc_type_code);
3173: fnd_message.set_token('ROW',p_table_row);
3174: END IF;
3175: END IF;
3176:

Line 3173: fnd_message.set_token('ROW',p_table_row);

3169: fnd_message.set_token('TABLE_NAME',p_table_name);
3170: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3171: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3172: fnd_message.set_token('ENC_TYPE_CODE', g_master_rec(i).enc_type_code);
3173: fnd_message.set_token('ROW',p_table_row);
3174: END IF;
3175: END IF;
3176:
3177: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 3207: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_ERR');

3203:
3204: ELSE -- g_master_rec(i).status = 'Y'
3205:
3206: IF g_loader_type = 'CLIENT' THEN
3207: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_ERR');
3208: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3209: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3210: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3211: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);

Line 3208: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);

3204: ELSE -- g_master_rec(i).status = 'Y'
3205:
3206: IF g_loader_type = 'CLIENT' THEN
3207: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_ERR');
3208: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3209: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3210: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3211: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);
3212: fnd_message.set_token('TABLE_NAME',p_table_name);

Line 3209: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);

3205:
3206: IF g_loader_type = 'CLIENT' THEN
3207: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_ERR');
3208: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3209: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3210: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3211: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);
3212: fnd_message.set_token('TABLE_NAME',p_table_name);
3213: ELSE

Line 3210: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);

3206: IF g_loader_type = 'CLIENT' THEN
3207: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_ERR');
3208: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3209: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3210: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3211: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);
3212: fnd_message.set_token('TABLE_NAME',p_table_name);
3213: ELSE
3214: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_ERR');

Line 3211: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);

3207: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_ERR');
3208: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3209: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3210: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3211: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);
3212: fnd_message.set_token('TABLE_NAME',p_table_name);
3213: ELSE
3214: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_ERR');
3215: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);

Line 3212: fnd_message.set_token('TABLE_NAME',p_table_name);

3208: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3209: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3210: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3211: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);
3212: fnd_message.set_token('TABLE_NAME',p_table_name);
3213: ELSE
3214: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_ERR');
3215: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3216: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);

Line 3214: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_ERR');

3210: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3211: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);
3212: fnd_message.set_token('TABLE_NAME',p_table_name);
3213: ELSE
3214: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_ERR');
3215: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3216: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3217: fnd_message.set_token('TABLE_NAME',p_table_name);
3218: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);

Line 3215: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);

3211: fnd_message.set_token('SOURCE_SYSTEM_CODE', g_master_rec(i).source_system_display_code);
3212: fnd_message.set_token('TABLE_NAME',p_table_name);
3213: ELSE
3214: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_ERR');
3215: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3216: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3217: fnd_message.set_token('TABLE_NAME',p_table_name);
3218: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3219: fnd_message.set_token('ROW',p_table_row);

Line 3216: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);

3212: fnd_message.set_token('TABLE_NAME',p_table_name);
3213: ELSE
3214: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_ERR');
3215: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3216: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3217: fnd_message.set_token('TABLE_NAME',p_table_name);
3218: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3219: fnd_message.set_token('ROW',p_table_row);
3220: END IF;

Line 3217: fnd_message.set_token('TABLE_NAME',p_table_name);

3213: ELSE
3214: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_ERR');
3215: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3216: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3217: fnd_message.set_token('TABLE_NAME',p_table_name);
3218: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3219: fnd_message.set_token('ROW',p_table_row);
3220: END IF;
3221:

Line 3218: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);

3214: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_ERR');
3215: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3216: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3217: fnd_message.set_token('TABLE_NAME',p_table_name);
3218: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3219: fnd_message.set_token('ROW',p_table_row);
3220: END IF;
3221:
3222: END IF; -- g_master_rec(i).status = 'Y'

Line 3219: fnd_message.set_token('ROW',p_table_row);

3215: fnd_message.set_token('REQUEST_ID', g_master_rec(i).request_id);
3216: fnd_message.set_token('LEDGER_DISPLAY_CODE', g_master_rec(i).ledger_display_code);
3217: fnd_message.set_token('TABLE_NAME',p_table_name);
3218: fnd_message.set_token('DATASET_DISPLAY_CODE', g_master_rec(i).dataset_display_code);
3219: fnd_message.set_token('ROW',p_table_row);
3220: END IF;
3221:
3222: END IF; -- g_master_rec(i).status = 'Y'
3223:

Line 3225: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_CONC_PGM_ERR');

3221:
3222: END IF; -- g_master_rec(i).status = 'Y'
3223:
3224: ELSE -- g_master_rec(i).request_id > 0
3225: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_CONC_PGM_ERR');
3226: fnd_message.set_token('TABLE_NAME',p_table_name);
3227: END IF; -- g_master_rec(i).request_id > 0
3228:
3229: trace('MESSAGE');

Line 3226: fnd_message.set_token('TABLE_NAME',p_table_name);

3222: END IF; -- g_master_rec(i).status = 'Y'
3223:
3224: ELSE -- g_master_rec(i).request_id > 0
3225: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_CONC_PGM_ERR');
3226: fnd_message.set_token('TABLE_NAME',p_table_name);
3227: END IF; -- g_master_rec(i).request_id > 0
3228:
3229: trace('MESSAGE');
3230:

Line 3280: fnd_message.set_name('FEM', 'FEM_ALL_TXT');

3276: fem_engines_pkg.tech_message (p_severity => g_log_level_2
3277: ,p_module => g_block||'.populate_log(PROCEDURE)'
3278: ,p_msg_text => 'BEGIN..for populate_log');
3279:
3280: fnd_message.set_name('FEM', 'FEM_ALL_TXT');
3281: all_str := fnd_message.get;
3282:
3283: FOR i IN 1..gs_table_name_tab.COUNT LOOP
3284: IF gs_ledger_tab(i) = -1 THEN

Line 3281: all_str := fnd_message.get;

3277: ,p_module => g_block||'.populate_log(PROCEDURE)'
3278: ,p_msg_text => 'BEGIN..for populate_log');
3279:
3280: fnd_message.set_name('FEM', 'FEM_ALL_TXT');
3281: all_str := fnd_message.get;
3282:
3283: FOR i IN 1..gs_table_name_tab.COUNT LOOP
3284: IF gs_ledger_tab(i) = -1 THEN
3285: gs_ledger_code_tab(i) := all_str;

Line 3336: fnd_message.set_name('FEM', 'FEM_DLLDR_LOAD_DATA_MSG');

3332:
3333: FOR i IN 1..gs_table_name_tab.COUNT LOOP
3334: trace('SEPARATOR');
3335: IF g_loader_type = 'CLIENT' THEN
3336: fnd_message.set_name('FEM', 'FEM_DLLDR_LOAD_DATA_MSG');
3337: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3338: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3339: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3340: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));

Line 3337: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));

3333: FOR i IN 1..gs_table_name_tab.COUNT LOOP
3334: trace('SEPARATOR');
3335: IF g_loader_type = 'CLIENT' THEN
3336: fnd_message.set_name('FEM', 'FEM_DLLDR_LOAD_DATA_MSG');
3337: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3338: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3339: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3340: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3341: ELSE

Line 3338: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));

3334: trace('SEPARATOR');
3335: IF g_loader_type = 'CLIENT' THEN
3336: fnd_message.set_name('FEM', 'FEM_DLLDR_LOAD_DATA_MSG');
3337: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3338: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3339: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3340: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3341: ELSE
3342: fnd_message.set_name('FEM', 'FEM_DLLDR_LOAD_DATA_MSG_L');

Line 3339: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));

3335: IF g_loader_type = 'CLIENT' THEN
3336: fnd_message.set_name('FEM', 'FEM_DLLDR_LOAD_DATA_MSG');
3337: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3338: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3339: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3340: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3341: ELSE
3342: fnd_message.set_name('FEM', 'FEM_DLLDR_LOAD_DATA_MSG_L');
3343: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));

Line 3340: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));

3336: fnd_message.set_name('FEM', 'FEM_DLLDR_LOAD_DATA_MSG');
3337: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3338: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3339: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3340: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3341: ELSE
3342: fnd_message.set_name('FEM', 'FEM_DLLDR_LOAD_DATA_MSG_L');
3343: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3344: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));

Line 3342: fnd_message.set_name('FEM', 'FEM_DLLDR_LOAD_DATA_MSG_L');

3338: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3339: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3340: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3341: ELSE
3342: fnd_message.set_name('FEM', 'FEM_DLLDR_LOAD_DATA_MSG_L');
3343: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3344: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3345: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3346: END IF;

Line 3343: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));

3339: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3340: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3341: ELSE
3342: fnd_message.set_name('FEM', 'FEM_DLLDR_LOAD_DATA_MSG_L');
3343: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3344: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3345: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3346: END IF;
3347: trace('MESSAGE');

Line 3344: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));

3340: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3341: ELSE
3342: fnd_message.set_name('FEM', 'FEM_DLLDR_LOAD_DATA_MSG_L');
3343: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3344: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3345: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3346: END IF;
3347: trace('MESSAGE');
3348: trace('SEPARATOR');

Line 3345: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));

3341: ELSE
3342: fnd_message.set_name('FEM', 'FEM_DLLDR_LOAD_DATA_MSG_L');
3343: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3344: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3345: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3346: END IF;
3347: trace('MESSAGE');
3348: trace('SEPARATOR');
3349: IF gs_load_opt_tab(i) = 'DD' THEN

Line 3363: fnd_message.set_name('FEM', 'FEM_DLLDR_LOADER_PROD_DS');

3359:
3360: FOR j IN 1..g_inv_table_row.COUNT LOOP
3361: IF g_inv_table_row(j) = i THEN
3362: IF g_inv_ds_pd_flag(j) = 'N' THEN
3363: fnd_message.set_name('FEM', 'FEM_DLLDR_LOADER_PROD_DS');
3364: fnd_message.set_token('DATASET',g_inv_dataset(j));
3365: trace('MESSAGE');
3366: trace('SEPARATOR');
3367: END IF;

Line 3364: fnd_message.set_token('DATASET',g_inv_dataset(j));

3360: FOR j IN 1..g_inv_table_row.COUNT LOOP
3361: IF g_inv_table_row(j) = i THEN
3362: IF g_inv_ds_pd_flag(j) = 'N' THEN
3363: fnd_message.set_name('FEM', 'FEM_DLLDR_LOADER_PROD_DS');
3364: fnd_message.set_token('DATASET',g_inv_dataset(j));
3365: trace('MESSAGE');
3366: trace('SEPARATOR');
3367: END IF;
3368: END IF;

Line 3375: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_WARN');

3371: CASE gs_valid_rows(i)
3372:
3373: WHEN 0 THEN
3374: IF g_loader_type = 'CLIENT' THEN
3375: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_WARN');
3376: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3377: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3378: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3379: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));

Line 3376: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));

3372:
3373: WHEN 0 THEN
3374: IF g_loader_type = 'CLIENT' THEN
3375: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_WARN');
3376: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3377: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3378: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3379: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3380: ELSE

Line 3377: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));

3373: WHEN 0 THEN
3374: IF g_loader_type = 'CLIENT' THEN
3375: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_WARN');
3376: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3377: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3378: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3379: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3380: ELSE
3381: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_WARN');

Line 3378: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));

3374: IF g_loader_type = 'CLIENT' THEN
3375: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_WARN');
3376: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3377: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3378: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3379: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3380: ELSE
3381: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_WARN');
3382: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));

Line 3379: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));

3375: fnd_message.set_name('FEM', 'FEM_DLLDR_DATA_LOADER_WARN');
3376: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3377: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3378: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3379: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3380: ELSE
3381: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_WARN');
3382: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3383: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));

Line 3381: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_WARN');

3377: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3378: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3379: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3380: ELSE
3381: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_WARN');
3382: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3383: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3384: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3385: fnd_message.set_token('ROW',gs_table_row_tab(i));

Line 3382: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));

3378: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3379: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3380: ELSE
3381: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_WARN');
3382: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3383: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3384: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3385: fnd_message.set_token('ROW',gs_table_row_tab(i));
3386: END IF;

Line 3383: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));

3379: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3380: ELSE
3381: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_WARN');
3382: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3383: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3384: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3385: fnd_message.set_token('ROW',gs_table_row_tab(i));
3386: END IF;
3387: trace('MESSAGE');

Line 3384: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));

3380: ELSE
3381: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_WARN');
3382: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3383: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3384: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3385: fnd_message.set_token('ROW',gs_table_row_tab(i));
3386: END IF;
3387: trace('MESSAGE');
3388: trace('SEPARATOR');

Line 3385: fnd_message.set_token('ROW',gs_table_row_tab(i));

3381: fnd_message.set_name('FEM', 'FEM_DLLDR_LEDGER_LOADER_WARN');
3382: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3383: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3384: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3385: fnd_message.set_token('ROW',gs_table_row_tab(i));
3386: END IF;
3387: trace('MESSAGE');
3388: trace('SEPARATOR');
3389: WHEN -1 THEN

Line 3391: fnd_message.set_name('FEM', 'FEM_DLLDR_INTERFACE_NO_DATA');

3387: trace('MESSAGE');
3388: trace('SEPARATOR');
3389: WHEN -1 THEN
3390: IF g_loader_type = 'CLIENT' THEN
3391: fnd_message.set_name('FEM', 'FEM_DLLDR_INTERFACE_NO_DATA');
3392: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3393: ELSE
3394: fnd_message.set_name('FEM', 'FEM_DLLDR_INTERFACE_NO_DATA_L');
3395: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));

Line 3392: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));

3388: trace('SEPARATOR');
3389: WHEN -1 THEN
3390: IF g_loader_type = 'CLIENT' THEN
3391: fnd_message.set_name('FEM', 'FEM_DLLDR_INTERFACE_NO_DATA');
3392: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3393: ELSE
3394: fnd_message.set_name('FEM', 'FEM_DLLDR_INTERFACE_NO_DATA_L');
3395: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3396: fnd_message.set_token('DATASET_TYPE',gs_ds_bal_code_tab(i));

Line 3394: fnd_message.set_name('FEM', 'FEM_DLLDR_INTERFACE_NO_DATA_L');

3390: IF g_loader_type = 'CLIENT' THEN
3391: fnd_message.set_name('FEM', 'FEM_DLLDR_INTERFACE_NO_DATA');
3392: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3393: ELSE
3394: fnd_message.set_name('FEM', 'FEM_DLLDR_INTERFACE_NO_DATA_L');
3395: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3396: fnd_message.set_token('DATASET_TYPE',gs_ds_bal_code_tab(i));
3397: fnd_message.set_token('ROW',gs_table_row_tab(i));
3398: END IF;

Line 3395: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));

3391: fnd_message.set_name('FEM', 'FEM_DLLDR_INTERFACE_NO_DATA');
3392: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3393: ELSE
3394: fnd_message.set_name('FEM', 'FEM_DLLDR_INTERFACE_NO_DATA_L');
3395: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3396: fnd_message.set_token('DATASET_TYPE',gs_ds_bal_code_tab(i));
3397: fnd_message.set_token('ROW',gs_table_row_tab(i));
3398: END IF;
3399: trace('MESSAGE');

Line 3396: fnd_message.set_token('DATASET_TYPE',gs_ds_bal_code_tab(i));

3392: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3393: ELSE
3394: fnd_message.set_name('FEM', 'FEM_DLLDR_INTERFACE_NO_DATA_L');
3395: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3396: fnd_message.set_token('DATASET_TYPE',gs_ds_bal_code_tab(i));
3397: fnd_message.set_token('ROW',gs_table_row_tab(i));
3398: END IF;
3399: trace('MESSAGE');
3400: trace('SEPARATOR');

Line 3397: fnd_message.set_token('ROW',gs_table_row_tab(i));

3393: ELSE
3394: fnd_message.set_name('FEM', 'FEM_DLLDR_INTERFACE_NO_DATA_L');
3395: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3396: fnd_message.set_token('DATASET_TYPE',gs_ds_bal_code_tab(i));
3397: fnd_message.set_token('ROW',gs_table_row_tab(i));
3398: END IF;
3399: trace('MESSAGE');
3400: trace('SEPARATOR');
3401: WHEN -2 THEN

Line 3402: fnd_message.set_name('FEM', 'FEM_DLLDR_INTERFACE_TABLE_ERR');

3398: END IF;
3399: trace('MESSAGE');
3400: trace('SEPARATOR');
3401: WHEN -2 THEN
3402: fnd_message.set_name('FEM', 'FEM_DLLDR_INTERFACE_TABLE_ERR');
3403: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3404: trace('MESSAGE');
3405: trace('SEPARATOR');
3406: WHEN -3 THEN

Line 3403: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));

3399: trace('MESSAGE');
3400: trace('SEPARATOR');
3401: WHEN -2 THEN
3402: fnd_message.set_name('FEM', 'FEM_DLLDR_INTERFACE_TABLE_ERR');
3403: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3404: trace('MESSAGE');
3405: trace('SEPARATOR');
3406: WHEN -3 THEN
3407: IF g_loader_type = 'CLIENT' THEN

Line 3408: fnd_message.set_name('FEM', 'FEM_DLLDR_CAL_PERIOD_ERR');

3404: trace('MESSAGE');
3405: trace('SEPARATOR');
3406: WHEN -3 THEN
3407: IF g_loader_type = 'CLIENT' THEN
3408: fnd_message.set_name('FEM', 'FEM_DLLDR_CAL_PERIOD_ERR');
3409: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3410: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3411: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3412: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));

Line 3409: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));

3405: trace('SEPARATOR');
3406: WHEN -3 THEN
3407: IF g_loader_type = 'CLIENT' THEN
3408: fnd_message.set_name('FEM', 'FEM_DLLDR_CAL_PERIOD_ERR');
3409: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3410: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3411: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3412: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3413: ELSE

Line 3410: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));

3406: WHEN -3 THEN
3407: IF g_loader_type = 'CLIENT' THEN
3408: fnd_message.set_name('FEM', 'FEM_DLLDR_CAL_PERIOD_ERR');
3409: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3410: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3411: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3412: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3413: ELSE
3414: fnd_message.set_name('FEM', 'FEM_DLLDR_CAL_PERIOD_ERR_L');

Line 3411: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));

3407: IF g_loader_type = 'CLIENT' THEN
3408: fnd_message.set_name('FEM', 'FEM_DLLDR_CAL_PERIOD_ERR');
3409: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3410: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3411: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3412: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3413: ELSE
3414: fnd_message.set_name('FEM', 'FEM_DLLDR_CAL_PERIOD_ERR_L');
3415: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));

Line 3412: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));

3408: fnd_message.set_name('FEM', 'FEM_DLLDR_CAL_PERIOD_ERR');
3409: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3410: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3411: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3412: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3413: ELSE
3414: fnd_message.set_name('FEM', 'FEM_DLLDR_CAL_PERIOD_ERR_L');
3415: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3416: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));

Line 3414: fnd_message.set_name('FEM', 'FEM_DLLDR_CAL_PERIOD_ERR_L');

3410: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3411: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3412: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3413: ELSE
3414: fnd_message.set_name('FEM', 'FEM_DLLDR_CAL_PERIOD_ERR_L');
3415: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3416: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3417: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3418: fnd_message.set_token('ROW',gs_table_row_tab(i));

Line 3415: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));

3411: fnd_message.set_token('SOURCE_SYSTEM_CODE', gs_ss_code_tab(i));
3412: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3413: ELSE
3414: fnd_message.set_name('FEM', 'FEM_DLLDR_CAL_PERIOD_ERR_L');
3415: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3416: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3417: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3418: fnd_message.set_token('ROW',gs_table_row_tab(i));
3419: END IF;

Line 3416: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));

3412: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3413: ELSE
3414: fnd_message.set_name('FEM', 'FEM_DLLDR_CAL_PERIOD_ERR_L');
3415: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3416: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3417: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3418: fnd_message.set_token('ROW',gs_table_row_tab(i));
3419: END IF;
3420: trace('MESSAGE');

Line 3417: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));

3413: ELSE
3414: fnd_message.set_name('FEM', 'FEM_DLLDR_CAL_PERIOD_ERR_L');
3415: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3416: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3417: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3418: fnd_message.set_token('ROW',gs_table_row_tab(i));
3419: END IF;
3420: trace('MESSAGE');
3421: trace('SEPARATOR');

Line 3418: fnd_message.set_token('ROW',gs_table_row_tab(i));

3414: fnd_message.set_name('FEM', 'FEM_DLLDR_CAL_PERIOD_ERR_L');
3415: fnd_message.set_token('LEDGER_DISPLAY_CODE', gs_ledger_code_tab(i));
3416: fnd_message.set_token('DATASET_DISPLAY_CODE', gs_ds_code_tab(i));
3417: fnd_message.set_token('TABLE_NAME',gs_table_name_tab(i));
3418: fnd_message.set_token('ROW',gs_table_row_tab(i));
3419: END IF;
3420: trace('MESSAGE');
3421: trace('SEPARATOR');
3422: ELSE