DBA Data[Home] [Help]

APPS.FND_FLEX_SERVER dependencies on FND_FLEX_HIERARCHY_COMPILER

Line 4690: fnd_flex_hierarchy_compiler.request_lock(l_vset.flex_value_set_name, l_lock_handle);

4686: --
4687: IF ((l_vset.security_enabled_flag = 'H') AND
4688: (l_vset.validation_type <> 'D')) THEN
4689:
4690: fnd_flex_hierarchy_compiler.request_lock(l_vset.flex_value_set_name, l_lock_handle);
4691:
4692: l_sql :=
4693: 'SELECT r.error_message' ||
4694: ' FROM fnd_flex_value_rules_vl r, fnd_flex_value_rule_usages u, fnd_flex_value_hier_all h, fnd_flex_value_rule_lines l' ||

Line 4843: fnd_flex_hierarchy_compiler.release_lock(l_vset.flex_value_set_name, l_lock_handle);

4839:
4840: <>
4841:
4842: IF (l_lock_handle IS NOT NULL) THEN
4843: fnd_flex_hierarchy_compiler.release_lock(l_vset.flex_value_set_name, l_lock_handle);
4844: END IF;
4845:
4846: x_security_status := l_x_security_status;
4847: x_error_message := Substrb(l_x_error_message, 1, 1950);

Line 4853: fnd_flex_hierarchy_compiler.release_lock(l_vset.flex_value_set_name, l_lock_handle);

4849: RETURN;
4850: EXCEPTION
4851: WHEN OTHERS THEN
4852: IF (l_lock_handle IS NOT NULL) THEN
4853: fnd_flex_hierarchy_compiler.release_lock(l_vset.flex_value_set_name, l_lock_handle);
4854: END IF;
4855: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4856: FND_MESSAGE.set_token('MSG', 'SSV.check_value_security(): ' || SQLERRM);
4857: x_security_status := 'EXCEPTION';