156:
157: IF l_node_val_exists > 0 THEN
158: hr_utility.trace('Organization already exists in the hierarchy.');
159: --
160: fnd_message.set_name('PER', 'HR_MX_GENHIER_ND_EXISTS');
161: fnd_message.raise_error;
162: --
163: END IF;
164:
157: IF l_node_val_exists > 0 THEN
158: hr_utility.trace('Organization already exists in the hierarchy.');
159: --
160: fnd_message.set_name('PER', 'HR_MX_GENHIER_ND_EXISTS');
161: fnd_message.raise_error;
162: --
163: END IF;
164:
165: ELSIF P_NODE_TYPE = 'MX LOCATION' THEN
177:
178: IF l_node_val_exists > 0 THEN
179: hr_utility.trace('Location record already exists.');
180: --
181: fnd_message.set_name('PER', 'HR_MX_GENHIER_LOC_EXIST_IN_GRE');
182: fnd_message.raise_error;
183: --
184: END IF;
185:
178: IF l_node_val_exists > 0 THEN
179: hr_utility.trace('Location record already exists.');
180: --
181: fnd_message.set_name('PER', 'HR_MX_GENHIER_LOC_EXIST_IN_GRE');
182: fnd_message.raise_error;
183: --
184: END IF;
185:
186: END IF;
339: --
340: -- IF ln_child_node_exists > 0 THEN
341: -- hr_utility.trace('Child node exists.');
342: -- --
343: -- fnd_message.set_name('PER', 'HR_MX_INVALID_ELEMENT_NAME');
344: -- fnd_message.raise_error;
345: -- --
346: -- END IF;
347: --
340: -- IF ln_child_node_exists > 0 THEN
341: -- hr_utility.trace('Child node exists.');
342: -- --
343: -- fnd_message.set_name('PER', 'HR_MX_INVALID_ELEMENT_NAME');
344: -- fnd_message.raise_error;
345: -- --
346: -- END IF;
347: --
348: -- open c_get_node_value( P_HIERARCHY_NODE_ID
359: --
360: -- IF ln_asg_loc_exists > 0 THEN
361: -- hr_utility.trace('Location is/was associated to an assignment.');
362: -- --
363: -- fnd_message.set_name('PER', 'HR_MX_INVALID_ELEMENT_NAME');
364: -- fnd_message.raise_error;
365: -- --
366: -- END IF;
367: --
360: -- IF ln_asg_loc_exists > 0 THEN
361: -- hr_utility.trace('Location is/was associated to an assignment.');
362: -- --
363: -- fnd_message.set_name('PER', 'HR_MX_INVALID_ELEMENT_NAME');
364: -- fnd_message.raise_error;
365: -- --
366: -- END IF;
367: --
368: -- END IF;
444:
445: if l_active_hierarchy > 0 then
446: hr_utility.trace('Update any node is not allowed.');
447: --
448: fnd_message.set_name('PER', 'HR_MX_GENHIER_ND_UPD_NOT_ALLOW');
449: fnd_message.raise_error;
450: --
451: end if;
452:
445: if l_active_hierarchy > 0 then
446: hr_utility.trace('Update any node is not allowed.');
447: --
448: fnd_message.set_name('PER', 'HR_MX_GENHIER_ND_UPD_NOT_ALLOW');
449: fnd_message.raise_error;
450: --
451: end if;
452:
453: hr_utility.trace('Leaving: PER_MX_GEN_HIER_VALID.UPDATE_NODES');
567:
568: IF ln_node_exists > 0 THEN
569: hr_utility.trace('Organization already exists in the hierarchy.');
570: --
571: fnd_message.set_name('PER', 'HR_MX_GENHIER_ND_EXST_IN_ACTIV');
572: fnd_message.raise_error;
573: --
574: END IF;
575:
568: IF ln_node_exists > 0 THEN
569: hr_utility.trace('Organization already exists in the hierarchy.');
570: --
571: fnd_message.set_name('PER', 'HR_MX_GENHIER_ND_EXST_IN_ACTIV');
572: fnd_message.raise_error;
573: --
574: END IF;
575:
576: end loop;