[Home] [Help]
167: || v_global_vs_id||') does not match the'
168: ||' GVSC for ledger.');
169: END IF;
170:
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:
174: IF (v_folder_id <> Nvl(p_folder_id, v_folder_id)) THEN
175: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
181: || v_folder_id||') does not match the'
182: ||' parameter folder id.');
183: END IF;
184:
185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
186: END IF;
187:
188: IF (v_rule_type <> p_rule_type) THEN
189: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
195: || v_rule_type||') does not match the'
196: ||' parameter rule type.');
197: END IF;
198:
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201: END IF; -- IF (p_object_id IS NOT NULL)
202:
203: -- Get a non-production dataset if one exists.
228: p_app_name => 'FEM',
229: p_msg_name => 'FEM_MISSING_DATASET_GROUP');
230: END IF;
231:
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END;
234:
235: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
236: FEM_ENGINES_PKG.TECH_MESSAGE(
267: p_msg_text => 'FEM_RULE_SET_MANAGER.FEM_Preprocess_RuleSet_PVT'
268: ||' returned with status: '||v_return_status);
269: END IF;
270:
271: IF v_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274:
275: -- Move valid flattened rule versions from the
268: ||' returned with status: '||v_return_status);
269: END IF;
270:
271: IF v_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274:
275: -- Move valid flattened rule versions from the
276: -- FEM_RULESET_PROCESS_DATA table to the FEM_BR_ROOT_RULES_GT table.
286: x_msg_count => v_msg_count,
287: x_msg_data => v_msg_data,
288: p_RuleSet_Object_ID => p_object_id);
289:
290: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
291: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
292: FEM_ENGINES_PKG.TECH_MESSAGE(
293: p_severity => FND_LOG.level_unexpected,
294: p_module => C_MODULE,
296: ||' FEM_RULE_SET_MANAGER.FEM_DeleteFlatRuleList_PVT'
297: ||' failed with return status: '||v_return_status);
298: END IF;
299:
300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
301: END IF;
302:
303: ELSE -- ELSIF (v_is_ruleset = 'N')
304: -- If ruleset is not provided, find all rules limited by the
331: ||' returned with status: '||v_return_status);
332: END IF;
333:
334: -- If rule is valid, get its version info
335: IF v_return_status = FND_API.G_RET_STS_SUCCESS THEN
336: FEM_RULE_SET_MANAGER.Get_ValidDefinition_Pub(
337: p_Object_ID => all_root_rules.object_id,
338: p_Rule_Effective_Date => FND_DATE.Date_To_Canonical(p_effective_date),
339: x_Object_Definition_ID => v_obj_def_id,
354: ||' FEM_RULE_SET_MANAGER.Get_ValidDefinition_Pub'
355: ||' failed with x_err_msg: '||v_msg_data);
356: END IF;
357:
358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
359: END IF;
360:
361: ELSIF v_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357:
358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
359: END IF;
360:
361: ELSIF v_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
363:
364: END IF;
365:
358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
359: END IF;
360:
361: ELSIF v_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
363:
364: END IF;
365:
366: END LOOP; -- c_all_root_rules
480: ||' FEM_RULE_SET_MANAGER.Get_ValidDefinition_Pub'
481: ||' failed with x_err_msg: '||v_msg_data);
482: END IF;
483:
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;
486:
487: -- Now recurse on the referenced rule
488: Validate_Root_Rule(p_obj_def_id => v_ref_obj_def_id,
758: p_module => C_MODULE,
759: p_msg_text => 'This rule type is not supported: '||v_rule_type);
760: END IF;
761:
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END IF; -- IF (v_rule_type = 'MAPPING_RULE') THEN
764:
765: -- Insert validation status into FEM_BR_VALID_STATUS_GT
766: INSERT INTO fem_br_valid_status_gt (object_definition_id, valid_flag)
2017: p_module => C_MODULE,
2018: p_msg_text => 'Begin Procedure');
2019: END IF;
2020:
2021: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
2022: p_count => v_msg_count,
2023: p_data => v_msg_data);
2024:
2025: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2048: ELSIF (v_msg_count > 1) THEN
2049: FOR i IN 1..v_msg_count LOOP
2050: FND_MSG_PUB.Get(
2051: p_msg_index => i,
2052: p_encoded => FND_API.G_FALSE,
2053: p_data => v_message,
2054: p_msg_index_out => v_msg_out);
2055:
2056: FEM_ENGINES_PKG.User_Message(p_msg_text => v_message);
2321: p_module => C_MODULE,
2322: p_msg_text => 'v_global_vs_id = '||v_global_vs_id);
2323: END IF;
2324:
2325: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2326: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2327: FEM_ENGINES_PKG.TECH_MESSAGE(
2328: p_severity => FND_LOG.level_unexpected,
2329: p_module => C_MODULE,
2331: ||' FEM_DIMENSION_UTIL_PKG.Global_VS_Combo_ID'
2332: ||' failed with return status: '||v_return_status);
2333: END IF;
2334:
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: END IF;
2337:
2338: -- Find the set of root rules that needs to be checked for
2339: -- disabled dimension members and place them in FEM_BR_ROOT_RULES_GT.