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.HR_HRC_BUS dependencies on HR_UTILITY

Line 120: hr_utility.set_location(' Entering:' || l_proc,10);

116: l_proc varchar2(72) := g_package ||'chk_hierarchy_key';
117: l_found varchar2(10);
118:
119: Begin
120: hr_utility.set_location(' Entering:' || l_proc,10);
121: --
122: hr_api.mandatory_arg_error
123: (p_api_name => l_proc
124: ,p_argument => 'HIERARCHY_KEY'

Line 128: hr_utility.set_location(' Opening the cursor csr_hrc_key:' || l_proc,20);

124: ,p_argument => 'HIERARCHY_KEY'
125: ,p_argument_value => p_hierarchy_key
126: );
127:
128: hr_utility.set_location(' Opening the cursor csr_hrc_key:' || l_proc,20);
129:
130: OPEN csr_hrc_key;
131: FETCH csr_hrc_key into l_found;
132:

Line 141: hr_utility.set_location(' Closed the cursor csr_hrc_key:' || l_proc,30);

137: END IF;
138:
139: CLOSE csr_hrc_key;
140:
141: hr_utility.set_location(' Closed the cursor csr_hrc_key:' || l_proc,30);
142:
143: --
144: hr_utility.set_location(' Leaving:' || l_proc,40);
145: Exception

Line 144: hr_utility.set_location(' Leaving:' || l_proc,40);

140:
141: hr_utility.set_location(' Closed the cursor csr_hrc_key:' || l_proc,30);
142:
143: --
144: hr_utility.set_location(' Leaving:' || l_proc,40);
145: Exception
146: when app_exception.application_exception then
147: IF hr_multi_message.exception_add
148: (p_associated_column1 => 'HR_KI_HIERARCHIES.HIERARCHY_KEY'

Line 151: hr_utility.set_location(' Leaving:'|| l_proc,50);

147: IF hr_multi_message.exception_add
148: (p_associated_column1 => 'HR_KI_HIERARCHIES.HIERARCHY_KEY'
149: )
150: THEN
151: hr_utility.set_location(' Leaving:'|| l_proc,50);
152: raise;
153: END IF;
154:
155: hr_utility.set_location(' Leaving:'|| l_proc,60);

Line 155: hr_utility.set_location(' Leaving:'|| l_proc,60);

151: hr_utility.set_location(' Leaving:'|| l_proc,50);
152: raise;
153: END IF;
154:
155: hr_utility.set_location(' Leaving:'|| l_proc,60);
156: --
157: End chk_hierarchy_key ;
158:
159: -- ----------------------------------------------------------------------------

Line 213: hr_utility.set_location(' Entering:'|| l_proc,10);

209: l_found varchar2(10);
210:
211: Begin
212:
213: hr_utility.set_location(' Entering:'|| l_proc,10);
214:
215:
216: -- if the parent hierarchy id is null, then check if there is already a
217: -- global functional node

Line 221: hr_utility.set_location(' Parent hierarchy id is null:'|| l_proc,20);

217: -- global functional node
218:
219: if p_parent_hierarchy_id is null then
220:
221: hr_utility.set_location(' Parent hierarchy id is null:'|| l_proc,20);
222:
223: open csr_check_null;
224: fetch csr_check_null into l_found;
225:

Line 227: hr_utility.set_location(' Global functional node already exists:'

223: open csr_check_null;
224: fetch csr_check_null into l_found;
225:
226: If csr_check_null%FOUND then
227: hr_utility.set_location(' Global functional node already exists:'
228: || l_proc,30);
229: close csr_check_null;
230: fnd_message.set_name( 'PER','PER_449915_HRC_GLBL_FUNC_PRES');
231: fnd_message.raise_error;

Line 238: hr_utility.set_location(' Parent hierarchy is not null:'|| l_proc,40);

234: close csr_check_null;
235:
236: else
237:
238: hr_utility.set_location(' Parent hierarchy is not null:'|| l_proc,40);
239:
240: open csr_hrc_parent_id;
241: fetch csr_hrc_parent_id into l_found;
242:

Line 244: hr_utility.set_location(' Parent hierarchy does not exist:'

240: open csr_hrc_parent_id;
241: fetch csr_hrc_parent_id into l_found;
242:
243: If csr_hrc_parent_id%NOTFOUND then
244: hr_utility.set_location(' Parent hierarchy does not exist:'
245: || l_proc,50);
246: close csr_hrc_parent_id;
247: fnd_message.set_name( 'PER','PER_449916_HRC_PARNT_ID_ABSNT');
248: fnd_message.raise_error;

Line 255: hr_utility.set_location(' Leaving:'|| l_proc,60);

251: close csr_hrc_parent_id;
252:
253: End If;
254:
255: hr_utility.set_location(' Leaving:'|| l_proc,60);
256:
257: Exception
258: when app_exception.application_exception then
259: If hr_multi_message.exception_add

Line 263: hr_utility.set_location(' Leaving:'|| l_proc,70);

259: If hr_multi_message.exception_add
260: (p_associated_column1 =>
261: 'HR_KI_HIERARCHIES.PARENT_HIERARCHY_ID'
262: ) THEN
263: hr_utility.set_location(' Leaving:'|| l_proc,70);
264: raise;
265: End If;
266:
267: hr_utility.set_location(' Leaving:'|| l_proc,80);

Line 267: hr_utility.set_location(' Leaving:'|| l_proc,80);

263: hr_utility.set_location(' Leaving:'|| l_proc,70);
264: raise;
265: End If;
266:
267: hr_utility.set_location(' Leaving:'|| l_proc,80);
268: --
269: End chk_parent_hierarchy_id ;
270: -- ----------------------------------------------------------------------------
271: -- ---------------------< CHK_PARENT_HIERARCHY_ID_UPDATE>----------------------

Line 305: hr_utility.set_location(' Entering:'|| l_proc,10);

301: l_found varchar2(10);
302:
303: Begin
304:
305: hr_utility.set_location(' Entering:'|| l_proc,10);
306:
307: -- check if we are trying to update the parent id of global func node
308: if hr_hrc_shd.g_old_rec.parent_hierarchy_id is null and
309: (nvl(p_parent_hierarchy_id, hr_api.g_number) <>

Line 312: hr_utility.set_location(' Parent hierarchy id of global node updated:'

308: if hr_hrc_shd.g_old_rec.parent_hierarchy_id is null and
309: (nvl(p_parent_hierarchy_id, hr_api.g_number) <>
310: nvl(hr_hrc_shd.g_old_rec.parent_hierarchy_id,hr_api.g_number))
311: then
312: hr_utility.set_location(' Parent hierarchy id of global node updated:'
313: || l_proc,20);
314: fnd_message.set_name( 'PER','PER_449914_HRC_GLBLND_NONUPD');
315: fnd_message.raise_error;
316: end if;

Line 318: hr_utility.set_location(' Leaving:' || l_proc,30);

314: fnd_message.set_name( 'PER','PER_449914_HRC_GLBLND_NONUPD');
315: fnd_message.raise_error;
316: end if;
317:
318: hr_utility.set_location(' Leaving:' || l_proc,30);
319:
320: Exception
321: when app_exception.application_exception then
322: IF hr_multi_message.exception_add

Line 325: hr_utility.set_location(' Leaving:'|| l_proc,40);

321: when app_exception.application_exception then
322: IF hr_multi_message.exception_add
323: (p_associated_column1 =>'HR_KI_HIERARCHIES.PARENT_HIERARCHY_ID'
324: )THEN
325: hr_utility.set_location(' Leaving:'|| l_proc,40);
326: raise;
327: END IF;
328: hr_utility.set_location(' Leaving:'|| l_proc,50);
329:

Line 328: hr_utility.set_location(' Leaving:'|| l_proc,50);

324: )THEN
325: hr_utility.set_location(' Leaving:'|| l_proc,40);
326: raise;
327: END IF;
328: hr_utility.set_location(' Leaving:'|| l_proc,50);
329:
330: End chk_parent_hierarchy_id_update;
331:
332: -- ----------------------------------------------------------------------------

Line 384: hr_utility.set_location(' Entering:'|| l_proc,10);

380: l_found varchar2(10);
381:
382: Begin
383:
384: hr_utility.set_location(' Entering:'|| l_proc,10);
385:
386: -- check if the parent_hierarchy_id that we are updating to will yield a cycle
387: open csr_cycle_chk;
388: fetch csr_cycle_chk into l_found;

Line 391: hr_utility.set_location(' Update will result in a cyclic hierarchy, aborting'

387: open csr_cycle_chk;
388: fetch csr_cycle_chk into l_found;
389:
390: If csr_cycle_chk%FOUND then
391: hr_utility.set_location(' Update will result in a cyclic hierarchy, aborting'
392: || l_proc,20);
393: close csr_cycle_chk;
394: fnd_message.set_name( 'PER','PER_449087_HRC_UPD_CYCLIC');
395: fnd_message.raise_error;

Line 400: hr_utility.set_location(' Leaving:' || l_proc,30);

396: End If;
397:
398: close csr_cycle_chk;
399:
400: hr_utility.set_location(' Leaving:' || l_proc,30);
401:
402: Exception
403: when app_exception.application_exception then
404: IF hr_multi_message.exception_add

Line 407: hr_utility.set_location(' Leaving:'|| l_proc,40);

403: when app_exception.application_exception then
404: IF hr_multi_message.exception_add
405: (p_associated_column1 =>'HR_KI_HIERARCHIES.PARENT_HIERARCHY_ID'
406: )THEN
407: hr_utility.set_location(' Leaving:'|| l_proc,40);
408: raise;
409: END IF;
410: hr_utility.set_location(' Leaving:'|| l_proc,50);
411:

Line 410: hr_utility.set_location(' Leaving:'|| l_proc,50);

406: )THEN
407: hr_utility.set_location(' Leaving:'|| l_proc,40);
408: raise;
409: END IF;
410: hr_utility.set_location(' Leaving:'|| l_proc,50);
411:
412: End chk_cyclic_hierarhcy;
413: -- ----------------------------------------------------------------------------
414: -- -----------------------------< CHK_DELETE>----------------------------------

Line 472: hr_utility.set_location(' Entering:' || l_proc,10);

468: l_proc varchar2(72) := g_package ||'chk_delete';
469:
470: Begin
471:
472: hr_utility.set_location(' Entering:' || l_proc,10);
473: open csr_hrc_id;
474: fetch csr_hrc_id into l_found;
475:
476: if csr_hrc_id%FOUND then

Line 506: hr_utility.set_location(' Leaving:' || l_proc,20);

502: end if;
503:
504: close csr_htl_id;
505:
506: hr_utility.set_location(' Leaving:' || l_proc,20);
507:
508: Exception
509: when app_exception.application_exception then
510: IF hr_multi_message.exception_add

Line 513: hr_utility.set_location(' Leaving:'|| l_proc,30);

509: when app_exception.application_exception then
510: IF hr_multi_message.exception_add
511: (p_associated_column1 => 'HR_KI_HIERARCHIES.HIERARCHY_ID'
512: )THEN
513: hr_utility.set_location(' Leaving:'|| l_proc,30);
514: raise;
515: END IF;
516: hr_utility.set_location(' Leaving:'|| l_proc,40);
517:

Line 516: hr_utility.set_location(' Leaving:'|| l_proc,40);

512: )THEN
513: hr_utility.set_location(' Leaving:'|| l_proc,30);
514: raise;
515: END IF;
516: hr_utility.set_location(' Leaving:'|| l_proc,40);
517:
518: End chk_delete;
519: --
520: -- ----------------------------------------------------------------------------

Line 530: hr_utility.set_location('Entering:'||l_proc, 5);

526: --
527: l_proc varchar2(72) := g_package||'insert_validate';
528: --
529: Begin
530: hr_utility.set_location('Entering:'||l_proc, 5);
531: --
532: -- Call all supporting business operations
533: --
534: --

Line 539: hr_utility.set_location(' Leaving:'||l_proc, 10);

535: -- "-- No business group context. HR_STANDARD_LOOKUPS used for validation."
536: chk_hierarchy_key(p_hierarchy_key => p_rec.hierarchy_key);
537: chk_parent_hierarchy_id(p_parent_hierarchy_id => p_rec.parent_hierarchy_id);
538: --
539: hr_utility.set_location(' Leaving:'||l_proc, 10);
540: End insert_validate;
541: --
542: -- ----------------------------------------------------------------------------
543: -- |---------------------------< update_validate >----------------------------|

Line 552: hr_utility.set_location('Entering:'||l_proc, 5);

548: --
549: l_proc varchar2(72) := g_package||'update_validate';
550: --
551: Begin
552: hr_utility.set_location('Entering:'||l_proc, 5);
553: --
554: -- Call all supporting business operations
555: --
556: --

Line 573: hr_utility.set_location(' Leaving:'||l_proc, 10);

569: p_parent_hierarchy_id => p_rec.parent_hierarchy_id
570: );
571: --
572: --
573: hr_utility.set_location(' Leaving:'||l_proc, 10);
574: End update_validate;
575: --
576: -- ----------------------------------------------------------------------------
577: -- |---------------------------< delete_validate >----------------------------|

Line 586: hr_utility.set_location('Entering:'||l_proc, 5);

582: --
583: l_proc varchar2(72) := g_package||'delete_validate';
584: --
585: Begin
586: hr_utility.set_location('Entering:'||l_proc, 5);
587: --
588: -- Call all supporting business operations
589: --
590: chk_delete(p_hierarchy_id => p_rec.hierarchy_id);

Line 592: hr_utility.set_location(' Leaving:'||l_proc, 10);

588: -- Call all supporting business operations
589: --
590: chk_delete(p_hierarchy_id => p_rec.hierarchy_id);
591: --
592: hr_utility.set_location(' Leaving:'||l_proc, 10);
593: End delete_validate;
594: --
595: end hr_hrc_bus;