eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_MX_GEN_HIER_VALID dependencies on HR_UTILITY

Line 126: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.VALIDATE_NODES');

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);

Line 127: hr_utility.trace('P_BUSINESS_GROUP_ID '||P_BUSINESS_GROUP_ID);

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);

Line 128: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_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);

Line 129: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);

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:

Line 130: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);

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:

Line 131: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_HIERARCHY_NODE_ID);

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

Line 132: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);

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

Line 143: hr_utility.trace('Active Hierarchy.');

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');

Line 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

Line 158: hr_utility.trace('Organization already exists in the hierarchy.');

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: --

Line 167: hr_utility.trace('Node is Location');

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

Line 179: hr_utility.trace('Location record already exists.');

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: --

Line 190: hr_utility.trace('Leaving: PER_MX_GEN_HIER_VALID.VALIDATE_NODES');

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: /************************************************************************

Line 243: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.CREATE_DEFAULT_LOCATION');

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);

Line 244: hr_utility.trace('P_HIERARCHY_NODE_ID '||P_HIERARCHY_NODE_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);

Line 245: hr_utility.trace('P_BUSINESS_GROUP_ID '||P_BUSINESS_GROUP_ID);

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);

Line 246: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_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);

Line 247: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);

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:

Line 248: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);

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

Line 249: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_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
253: NVL(PER_HIERARCHY_NODES_API.G_MODE, 'CREATE') <> 'COPY' THEN

Line 250: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);

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:

Line 260: hr_utility.trace('Creating location '||ln_location_id||

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

Line 280: hr_utility.trace('Leaving: PER_MX_GEN_HIER_VALID.CREATE_DEFAULT_LOCATION');

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: /************************************************************************

Line 331: -- hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.DELETE_NODES');

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

Line 332: -- hr_utility.trace('P_HIERARCHY_NODE_ID '||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);

Line 333: -- hr_utility.trace('P_OBJECT_VERSION_NUMBER '||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;

Line 341: -- hr_utility.trace('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: -- --

Line 361: -- hr_utility.trace('Location is/was associated to an assignment.');

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: -- --

Line 370: -- hr_utility.trace('Leaving: PER_MX_GEN_HIER_VALID.DELETE_NODES');

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: /************************************************************************

Line 429: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.UPDATE_NODES');

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);

Line 430: hr_utility.trace('P_ENTITY_ID '||P_ENTITY_ID);

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:

Line 431: hr_utility.trace('P_NODE_TYPE '||P_NODE_TYPE);

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);

Line 432: hr_utility.trace('P_PARENT_HIERARCHY_NODE_ID '||P_PARENT_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;

Line 433: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);

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;

Line 446: hr_utility.trace('Update any node is not allowed.');

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: --

Line 453: hr_utility.trace('Leaving: PER_MX_GEN_HIER_VALID.UPDATE_NODES');

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: /************************************************************************

Line 536: hr_utility.trace('Entering: PER_MX_GEN_HIER_VALID.UPDATE_HIER_VERSIONS');

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);

Line 537: hr_utility.trace('P_HIERARCHY_VERSION_ID '||P_HIERARCHY_VERSION_ID);

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);

Line 538: hr_utility.trace('P_VERSION_NUMBER '||P_VERSION_NUMBER);

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);

Line 539: hr_utility.trace('P_DATE_FROM '||P_DATE_FROM);

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:

Line 540: hr_utility.trace('P_DATE_TO '||P_DATE_TO);

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:

Line 541: hr_utility.trace('P_STATUS '||P_STATUS);

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

Line 542: hr_utility.trace('P_EFFECTIVE_DATE '||P_EFFECTIVE_DATE);

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 );

Line 551: hr_utility.trace('ln_bus_grp_id '||ln_bus_grp_id);

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:

Line 552: hr_utility.trace('lv_hier_status '||lv_hier_status);

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)

Line 566: hr_utility.trace('ln_node_exists '||ln_node_exists);

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: --

Line 569: hr_utility.trace('Organization already exists in the hierarchy.');

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: --

Line 579: hr_utility.trace('Leaving: PER_MX_GEN_HIER_VALID.UPDATE_HIER_VERSIONS');

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;