99:
100: FND_MSG_PUB.initialize;
101: ELSE
102: -- Get message from dictionary
103: fnd_message.set_name('FEM',p_msg_name);
104:
105: -- Load token/value array
106: tokens_values := msg_array
107: (p_token1,p_value1,
114: IF (MOD(i,2) = 1) THEN
115: v_token := tokens_values(i);
116: IF (v_token IS NOT NULL) THEN
117: v_value := tokens_values(i+1);
118: fnd_message.set_token(v_token,v_value);
119: ELSE
120: EXIT;
121: END IF;
122: END IF;
121: END IF;
122: END IF;
123: END LOOP;
124:
125: v_msg_data := FND_MESSAGE.Get;
126:
127: INSERT INTO fem_tab_class_errors_gt
128: (TABLE_NAME, TABLE_CLASSIFICATION_CODE, MESSAGE_TEXT)
129: VALUES
217: FROM fem_tables_vl
218: WHERE table_name = p_tab_name;
219: EXCEPTION WHEN others THEN null;
220: END;
221: FND_MESSAGE.Set_Name('FEM','FEM_SD_LDR_OBJECT_NAME_TXT');
222: FND_MESSAGE.Set_Token('TAB_DISP_NAME',nvl(v_tab_disp_name,p_tab_name));
223: FND_MESSAGE.Set_Token('TAB_NAME',p_tab_name);
224: v_obj_name := substr(FND_MESSAGE.Get,1,150);
225:
218: WHERE table_name = p_tab_name;
219: EXCEPTION WHEN others THEN null;
220: END;
221: FND_MESSAGE.Set_Name('FEM','FEM_SD_LDR_OBJECT_NAME_TXT');
222: FND_MESSAGE.Set_Token('TAB_DISP_NAME',nvl(v_tab_disp_name,p_tab_name));
223: FND_MESSAGE.Set_Token('TAB_NAME',p_tab_name);
224: v_obj_name := substr(FND_MESSAGE.Get,1,150);
225:
226: fem_object_catalog_util_pkg.create_object(p_api_version => 1.0,
219: EXCEPTION WHEN others THEN null;
220: END;
221: FND_MESSAGE.Set_Name('FEM','FEM_SD_LDR_OBJECT_NAME_TXT');
222: FND_MESSAGE.Set_Token('TAB_DISP_NAME',nvl(v_tab_disp_name,p_tab_name));
223: FND_MESSAGE.Set_Token('TAB_NAME',p_tab_name);
224: v_obj_name := substr(FND_MESSAGE.Get,1,150);
225:
226: fem_object_catalog_util_pkg.create_object(p_api_version => 1.0,
227: p_commit => c_false,
220: END;
221: FND_MESSAGE.Set_Name('FEM','FEM_SD_LDR_OBJECT_NAME_TXT');
222: FND_MESSAGE.Set_Token('TAB_DISP_NAME',nvl(v_tab_disp_name,p_tab_name));
223: FND_MESSAGE.Set_Token('TAB_NAME',p_tab_name);
224: v_obj_name := substr(FND_MESSAGE.Get,1,150);
225:
226: fem_object_catalog_util_pkg.create_object(p_api_version => 1.0,
227: p_commit => c_false,
228: p_object_type_code => 'SOURCE_DATA_LOADER',