122: l_node_val_exists number := 0;
123:
124: BEGIN
125:
126: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.VALIDATE_NODES');
127: hr_utility.trace('P_BUSINESS_GROUP_ID '||P_BUSINESS_GROUP_ID);
128: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
129: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
130: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
123:
124: BEGIN
125:
126: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.VALIDATE_NODES');
127: hr_utility.trace('P_BUSINESS_GROUP_ID '||P_BUSINESS_GROUP_ID);
128: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
129: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
130: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
131: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
124: BEGIN
125:
126: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.VALIDATE_NODES');
127: hr_utility.trace('P_BUSINESS_GROUP_ID '||P_BUSINESS_GROUP_ID);
128: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
129: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
130: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
131: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
132: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
125:
126: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.VALIDATE_NODES');
127: hr_utility.trace('P_BUSINESS_GROUP_ID '||P_BUSINESS_GROUP_ID);
128: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
129: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
130: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
131: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
132: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
133:
126: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.VALIDATE_NODES');
127: hr_utility.trace('P_BUSINESS_GROUP_ID '||P_BUSINESS_GROUP_ID);
128: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
129: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
130: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
131: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
132: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
133:
134:
127: hr_utility.trace('P_BUSINESS_GROUP_ID '||P_BUSINESS_GROUP_ID);
128: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
129: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
130: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
131: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
132: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
133:
134:
135: open c_active_hier( P_BUSINESS_GROUP_ID
128: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
129: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
130: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
131: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
132: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
133:
134:
135: open c_active_hier( P_BUSINESS_GROUP_ID
136: ,P_HIERARCHY_VERSION_ID
139: close c_active_hier;
140:
141: if l_active_hierarchy > 0 then
142:
143: hr_utility.trace('Active Hierarchy.');
144:
145: IF P_NODE_TYPE in ( 'MX LEGAL EMPLOYER', 'MX GRE' ) THEN
146:
147: hr_utility.trace('Node is either Legal Employer or GRE');
143: hr_utility.trace('Active Hierarchy.');
144:
145: IF P_NODE_TYPE in ( 'MX LEGAL EMPLOYER', 'MX GRE' ) THEN
146:
147: hr_utility.trace('Node is either Legal Employer or GRE');
148:
149: open c_node_exists( P_BUSINESS_GROUP_ID
150: ,P_NODE_TYPE
151: ,P_ENTITY_ID
154: close c_node_exists;
155:
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:
165: ELSIF P_NODE_TYPE = 'MX LOCATION' THEN
166:
167: hr_utility.trace('Node is Location');
168:
169: open c_loc_node_exists( P_BUSINESS_GROUP_ID
170: ,P_HIERARCHY_VERSION_ID
171: ,P_NODE_TYPE
175: close c_loc_node_exists;
176:
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: --
186: END IF;
187:
188: end if;
189:
190: hr_utility.trace('Leaving: PER_MX_GEN_HIER_VALID.VALIDATE_NODES');
191:
192: END validate_nodes;
193:
194: /************************************************************************
239: ln_ovn number;
240:
241: BEGIN
242:
243: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.CREATE_DEFAULT_LOCATION');
244: hr_utility.trace('P_HIERARCHY_NODE_ID '||P_HIERARCHY_NODE_ID);
245: hr_utility.trace('P_BUSINESS_GROUP_ID '||P_BUSINESS_GROUP_ID);
246: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
247: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
240:
241: BEGIN
242:
243: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.CREATE_DEFAULT_LOCATION');
244: hr_utility.trace('P_HIERARCHY_NODE_ID '||P_HIERARCHY_NODE_ID);
245: hr_utility.trace('P_BUSINESS_GROUP_ID '||P_BUSINESS_GROUP_ID);
246: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
247: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
248: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
241: BEGIN
242:
243: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.CREATE_DEFAULT_LOCATION');
244: hr_utility.trace('P_HIERARCHY_NODE_ID '||P_HIERARCHY_NODE_ID);
245: hr_utility.trace('P_BUSINESS_GROUP_ID '||P_BUSINESS_GROUP_ID);
246: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
247: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
248: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
249: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
242:
243: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.CREATE_DEFAULT_LOCATION');
244: hr_utility.trace('P_HIERARCHY_NODE_ID '||P_HIERARCHY_NODE_ID);
245: hr_utility.trace('P_BUSINESS_GROUP_ID '||P_BUSINESS_GROUP_ID);
246: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
247: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
248: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
249: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
250: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
243: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.CREATE_DEFAULT_LOCATION');
244: hr_utility.trace('P_HIERARCHY_NODE_ID '||P_HIERARCHY_NODE_ID);
245: hr_utility.trace('P_BUSINESS_GROUP_ID '||P_BUSINESS_GROUP_ID);
246: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
247: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
248: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
249: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
250: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
251:
244: hr_utility.trace('P_HIERARCHY_NODE_ID '||P_HIERARCHY_NODE_ID);
245: hr_utility.trace('P_BUSINESS_GROUP_ID '||P_BUSINESS_GROUP_ID);
246: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
247: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
248: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
249: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
250: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
251:
252: IF P_NODE_TYPE = 'MX GRE' AND
245: hr_utility.trace('P_BUSINESS_GROUP_ID '||P_BUSINESS_GROUP_ID);
246: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
247: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
248: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
249: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
250: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
251:
252: IF P_NODE_TYPE = 'MX GRE' AND
253: NVL(PER_HIERARCHY_NODES_API.G_MODE, 'CREATE') <> 'COPY' THEN
246: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
247: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
248: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
249: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
250: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
251:
252: IF P_NODE_TYPE = 'MX GRE' AND
253: NVL(PER_HIERARCHY_NODES_API.G_MODE, 'CREATE') <> 'COPY' THEN
254:
256: ,P_ENTITY_ID );
257: fetch c_get_loc_id into ln_location_id;
258: close c_get_loc_id;
259:
260: hr_utility.trace('Creating location '||ln_location_id||
261: ' for GRE '|| P_ENTITY_ID);
262:
263: per_hierarchy_nodes_api.create_hierarchy_nodes(
264: p_hierarchy_node_id => ln_hier_node_id
276: ,p_effective_date => p_effective_date );
277:
278: END IF;
279:
280: hr_utility.trace('Leaving: PER_MX_GEN_HIER_VALID.CREATE_DEFAULT_LOCATION');
281:
282: END create_default_location;
283:
284: /************************************************************************
327: --
328: --
329: -- BEGIN
330: --
331: -- hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.DELETE_NODES');
332: -- hr_utility.trace('P_HIERARCHY_NODE_ID '||P_HIERARCHY_NODE_ID);
333: -- hr_utility.trace('P_OBJECT_VERSION_NUMBER '||P_OBJECT_VERSION_NUMBER);
334: --
335: -- open c_child_node_exists( P_HIERARCHY_NODE_ID
328: --
329: -- BEGIN
330: --
331: -- hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.DELETE_NODES');
332: -- hr_utility.trace('P_HIERARCHY_NODE_ID '||P_HIERARCHY_NODE_ID);
333: -- hr_utility.trace('P_OBJECT_VERSION_NUMBER '||P_OBJECT_VERSION_NUMBER);
334: --
335: -- open c_child_node_exists( P_HIERARCHY_NODE_ID
336: -- ,P_OBJECT_VERSION_NUMBER);
329: -- BEGIN
330: --
331: -- hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.DELETE_NODES');
332: -- hr_utility.trace('P_HIERARCHY_NODE_ID '||P_HIERARCHY_NODE_ID);
333: -- hr_utility.trace('P_OBJECT_VERSION_NUMBER '||P_OBJECT_VERSION_NUMBER);
334: --
335: -- open c_child_node_exists( P_HIERARCHY_NODE_ID
336: -- ,P_OBJECT_VERSION_NUMBER);
337: -- fetch c_child_node_exists into ln_child_node_exists;
337: -- fetch c_child_node_exists into ln_child_node_exists;
338: -- close c_child_node_exists;
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: -- --
357: -- fetch c_asg_loc_exists into ln_asg_loc_exists;
358: -- close c_asg_loc_exists;
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: --
368: -- END IF;
369: --
370: -- hr_utility.trace('Leaving: PER_MX_GEN_HIER_VALID.DELETE_NODES');
371: --
372: -- END delete_nodes;
373:
374: /************************************************************************
425: ln_hier_vers_id number;
426:
427: BEGIN
428:
429: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.UPDATE_NODES');
430: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
431: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
432: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
433: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
426:
427: BEGIN
428:
429: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.UPDATE_NODES');
430: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
431: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
432: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
433: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
434:
427: BEGIN
428:
429: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.UPDATE_NODES');
430: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
431: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
432: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
433: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
434:
435: open c_get_node_val(P_HIERARCHY_NODE_ID);
428:
429: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.UPDATE_NODES');
430: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
431: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
432: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
433: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
434:
435: open c_get_node_val(P_HIERARCHY_NODE_ID);
436: fetch c_get_node_val into ln_bus_grp_id, ln_hier_vers_id;
429: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.UPDATE_NODES');
430: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);
431: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);
432: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);
433: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
434:
435: open c_get_node_val(P_HIERARCHY_NODE_ID);
436: fetch c_get_node_val into ln_bus_grp_id, ln_hier_vers_id;
437: close c_get_node_val;
442: fetch c_active_hier into l_active_hierarchy;
443: close c_active_hier;
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: --
449: fnd_message.raise_error;
450: --
451: end if;
452:
453: hr_utility.trace('Leaving: PER_MX_GEN_HIER_VALID.UPDATE_NODES');
454:
455: END update_nodes;
456:
457: /************************************************************************
532: ln_node_exists number := 0;
533:
534: BEGIN
535:
536: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.UPDATE_HIER_VERSIONS');
537: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
538: hr_utility.trace('P_VERSION_NUMBER '||P_VERSION_NUMBER);
539: hr_utility.trace('P_DATE_FROM '||P_DATE_FROM);
540: hr_utility.trace('P_DATE_TO '||P_DATE_TO);
533:
534: BEGIN
535:
536: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.UPDATE_HIER_VERSIONS');
537: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
538: hr_utility.trace('P_VERSION_NUMBER '||P_VERSION_NUMBER);
539: hr_utility.trace('P_DATE_FROM '||P_DATE_FROM);
540: hr_utility.trace('P_DATE_TO '||P_DATE_TO);
541: hr_utility.trace('P_STATUS '||P_STATUS);
534: BEGIN
535:
536: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.UPDATE_HIER_VERSIONS');
537: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
538: hr_utility.trace('P_VERSION_NUMBER '||P_VERSION_NUMBER);
539: hr_utility.trace('P_DATE_FROM '||P_DATE_FROM);
540: hr_utility.trace('P_DATE_TO '||P_DATE_TO);
541: hr_utility.trace('P_STATUS '||P_STATUS);
542: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
535:
536: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.UPDATE_HIER_VERSIONS');
537: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
538: hr_utility.trace('P_VERSION_NUMBER '||P_VERSION_NUMBER);
539: hr_utility.trace('P_DATE_FROM '||P_DATE_FROM);
540: hr_utility.trace('P_DATE_TO '||P_DATE_TO);
541: hr_utility.trace('P_STATUS '||P_STATUS);
542: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
543:
536: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.UPDATE_HIER_VERSIONS');
537: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
538: hr_utility.trace('P_VERSION_NUMBER '||P_VERSION_NUMBER);
539: hr_utility.trace('P_DATE_FROM '||P_DATE_FROM);
540: hr_utility.trace('P_DATE_TO '||P_DATE_TO);
541: hr_utility.trace('P_STATUS '||P_STATUS);
542: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
543:
544:
537: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);
538: hr_utility.trace('P_VERSION_NUMBER '||P_VERSION_NUMBER);
539: hr_utility.trace('P_DATE_FROM '||P_DATE_FROM);
540: hr_utility.trace('P_DATE_TO '||P_DATE_TO);
541: hr_utility.trace('P_STATUS '||P_STATUS);
542: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
543:
544:
545: open c_hier_status( P_HIERARCHY_VERSION_ID
538: hr_utility.trace('P_VERSION_NUMBER '||P_VERSION_NUMBER);
539: hr_utility.trace('P_DATE_FROM '||P_DATE_FROM);
540: hr_utility.trace('P_DATE_TO '||P_DATE_TO);
541: hr_utility.trace('P_STATUS '||P_STATUS);
542: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);
543:
544:
545: open c_hier_status( P_HIERARCHY_VERSION_ID
546: ,P_VERSION_NUMBER );
547: fetch c_hier_status into ln_bus_grp_id
548: ,lv_hier_status;
549: close c_hier_status;
550:
551: hr_utility.trace('ln_bus_grp_id '||ln_bus_grp_id);
552: hr_utility.trace('lv_hier_status '||lv_hier_status);
553:
554: if lv_hier_status = 'I' and p_status = 'A' then
555:
548: ,lv_hier_status;
549: close c_hier_status;
550:
551: hr_utility.trace('ln_bus_grp_id '||ln_bus_grp_id);
552: hr_utility.trace('lv_hier_status '||lv_hier_status);
553:
554: if lv_hier_status = 'I' and p_status = 'A' then
555:
556: for nd in c_get_nodes(ln_bus_grp_id, p_hierarchy_version_id)
562: ,p_date_from );
563: fetch c_node_exists into ln_node_exists;
564: close c_node_exists;
565:
566: hr_utility.trace('ln_node_exists '||ln_node_exists);
567:
568: IF ln_node_exists > 0 THEN
569: hr_utility.trace('Organization already exists in the hierarchy.');
570: --
565:
566: hr_utility.trace('ln_node_exists '||ln_node_exists);
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: --
575:
576: end loop;
577: end if;
578:
579: hr_utility.trace('Leaving: PER_MX_GEN_HIER_VALID.UPDATE_HIER_VERSIONS');
580:
581: END update_hier_versions;
582:
583: END per_mx_gen_hier_valid;