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

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_egc_bus.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< chk_df >----------------------------------|
13: -- ----------------------------------------------------------------------------

Line 46: g_debug:=hr_utility.debug_enabled;

42: --
43: l_proc varchar2(72);
44: --
45: begin
46: g_debug:=hr_utility.debug_enabled;
47: if g_debug then
48: l_proc := g_package || 'chk_df';
49: hr_utility.set_location('Entering:'||l_proc,10);
50: end if;

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

45: begin
46: g_debug:=hr_utility.debug_enabled;
47: if g_debug then
48: l_proc := g_package || 'chk_df';
49: hr_utility.set_location('Entering:'||l_proc,10);
50: end if;
51: --
52: if ((p_rec.entity_group_comp_id is not null) and (
53: nvl(hxc_egc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

186: );
187: end if;
188: --
189: if g_debug then
190: hr_utility.set_location(' Leaving:'||l_proc,20);
191: end if;
192: end chk_df;
193: --
194: -- ----------------------------------------------------------------------------

Line 319: g_debug:=hr_utility.debug_enabled;

315:
316: l_error varchar2(5) := NULL;
317:
318: BEGIN
319: g_debug:=hr_utility.debug_enabled;
320: if g_debug then
321: l_proc := g_package||'chk_entity_id';
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: end if;

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

318: BEGIN
319: g_debug:=hr_utility.debug_enabled;
320: if g_debug then
321: l_proc := g_package||'chk_entity_id';
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: end if;
324: -- check that the entity id has been entered
325: --
326: IF p_entity_id IS NULL

Line 329: hr_utility.set_message(809, 'HXC_EGC_ENTITY_ID_MAND');

325: --
326: IF p_entity_id IS NULL
327: THEN
328: --
329: hr_utility.set_message(809, 'HXC_EGC_ENTITY_ID_MAND');
330: hr_utility.raise_error;
331: --
332: END IF;
333:

Line 330: hr_utility.raise_error;

326: IF p_entity_id IS NULL
327: THEN
328: --
329: hr_utility.set_message(809, 'HXC_EGC_ENTITY_ID_MAND');
330: hr_utility.raise_error;
331: --
332: END IF;
333:
334: if g_debug then

Line 335: hr_utility.set_location('Processing:'||l_proc, 10);

331: --
332: END IF;
333:
334: if g_debug then
335: hr_utility.set_location('Processing:'||l_proc, 10);
336: end if;
337:
338: -- check to see what entity we are dealing with
339:

Line 352: hr_utility.set_message(809, 'HXC_EGC_ENTITY_ID_INVALID');

348:
349: IF l_error IS NOT NULL
350: THEN
351:
352: hr_utility.set_message(809, 'HXC_EGC_ENTITY_ID_INVALID');
353: hr_utility.raise_error;
354:
355: END IF;
356:

Line 353: hr_utility.raise_error;

349: IF l_error IS NOT NULL
350: THEN
351:
352: hr_utility.set_message(809, 'HXC_EGC_ENTITY_ID_INVALID');
353: hr_utility.raise_error;
354:
355: END IF;
356:
357: ELSIF ( p_entity_type = 'TIME_RECIPIENTS' )

Line 369: hr_utility.set_message(809, 'HXC_EGC_ENTITY_ID_INVALID');

365:
366: IF l_error IS NOT NULL
367: THEN
368:
369: hr_utility.set_message(809, 'HXC_EGC_ENTITY_ID_INVALID');
370: hr_utility.raise_error;
371:
372: END IF;
373:

Line 370: hr_utility.raise_error;

366: IF l_error IS NOT NULL
367: THEN
368:
369: hr_utility.set_message(809, 'HXC_EGC_ENTITY_ID_INVALID');
370: hr_utility.raise_error;
371:
372: END IF;
373:
374: ELSIF ( p_entity_type = 'RETRIEVAL_RULES' )

Line 386: hr_utility.set_message(809, 'HXC_EGC_ENTITY_ID_INVALID');

382:
383: IF l_error IS NOT NULL
384: THEN
385:
386: hr_utility.set_message(809, 'HXC_EGC_ENTITY_ID_INVALID');
387: hr_utility.raise_error;
388:
389: END IF;
390:

Line 387: hr_utility.raise_error;

383: IF l_error IS NOT NULL
384: THEN
385:
386: hr_utility.set_message(809, 'HXC_EGC_ENTITY_ID_INVALID');
387: hr_utility.raise_error;
388:
389: END IF;
390:
391: -- To handle Public Template Group Insert

Line 401: hr_utility.set_message(809, 'HXC_EGC_ENTITY_ID_INVALID');

397:
398: IF l_error IS NOT NULL
399: THEN
400:
401: hr_utility.set_message(809, 'HXC_EGC_ENTITY_ID_INVALID');
402: hr_utility.raise_error;
403:
404: END IF;
405:

Line 402: hr_utility.raise_error;

398: IF l_error IS NOT NULL
399: THEN
400:
401: hr_utility.set_message(809, 'HXC_EGC_ENTITY_ID_INVALID');
402: hr_utility.raise_error;
403:
404: END IF;
405:
406:

Line 409: hr_utility.set_message(809, 'HXC_EGC_ENTITY_TYPE_INVALID');

405:
406:
407: ELSE
408:
409: hr_utility.set_message(809, 'HXC_EGC_ENTITY_TYPE_INVALID');
410: hr_utility.raise_error;
411:
412: END IF; -- entity_type
413:

Line 410: hr_utility.raise_error;

406:
407: ELSE
408:
409: hr_utility.set_message(809, 'HXC_EGC_ENTITY_TYPE_INVALID');
410: hr_utility.raise_error;
411:
412: END IF; -- entity_type
413:
414: --

Line 458: g_debug:=hr_utility.debug_enabled;

454: --
455: l_error varchar2(5) := NULL;
456: --
457: BEGIN
458: g_debug:=hr_utility.debug_enabled;
459: if g_debug then
460: l_proc := g_package||'chk_entity_group_id';
461: hr_utility.set_location('Entering:'||l_proc, 5);
462: end if;

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

457: BEGIN
458: g_debug:=hr_utility.debug_enabled;
459: if g_debug then
460: l_proc := g_package||'chk_entity_group_id';
461: hr_utility.set_location('Entering:'||l_proc, 5);
462: end if;
463: --
464: -- check that the entity group id has been entered
465: --

Line 469: hr_utility.set_message(809, 'HXC_EGC_ENTITY_GROUP_ID_MAND');

465: --
466: IF p_entity_group_id IS NULL
467: THEN
468: --
469: hr_utility.set_message(809, 'HXC_EGC_ENTITY_GROUP_ID_MAND');
470: hr_utility.raise_error;
471: --
472: END IF;
473: if g_debug then

Line 470: hr_utility.raise_error;

466: IF p_entity_group_id IS NULL
467: THEN
468: --
469: hr_utility.set_message(809, 'HXC_EGC_ENTITY_GROUP_ID_MAND');
470: hr_utility.raise_error;
471: --
472: END IF;
473: if g_debug then
474: hr_utility.set_location('Processing:'||l_proc, 10);

Line 474: hr_utility.set_location('Processing:'||l_proc, 10);

470: hr_utility.raise_error;
471: --
472: END IF;
473: if g_debug then
474: hr_utility.set_location('Processing:'||l_proc, 10);
475: end if;
476: --
477: -- check that entity_group_id is valid
478: --

Line 486: hr_utility.set_message(809, 'HXC_EGC_ENTITY_GROUP_ID_INVLD');

482: --
483: IF l_error IS NOT NULL
484: THEN
485: --
486: hr_utility.set_message(809, 'HXC_EGC_ENTITY_GROUP_ID_INVLD');
487: hr_utility.raise_error;
488: --
489: END IF;
490: --

Line 487: hr_utility.raise_error;

483: IF l_error IS NOT NULL
484: THEN
485: --
486: hr_utility.set_message(809, 'HXC_EGC_ENTITY_GROUP_ID_INVLD');
487: hr_utility.raise_error;
488: --
489: END IF;
490: --
491: if g_debug then

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

488: --
489: END IF;
490: --
491: if g_debug then
492: hr_utility.set_location('Leaving:'||l_proc, 20);
493: end if;
494: --
495: END chk_entity_group_id;
496: --

Line 542: g_debug:=hr_utility.debug_enabled;

538: --
539: l_error varchar2(5) := NULL;
540: --
541: BEGIN
542: g_debug:=hr_utility.debug_enabled;
543: if g_debug then
544: l_proc := g_package||'chk_entity_type';
545: hr_utility.set_location('Entering:'||l_proc, 5);
546: end if;

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

541: BEGIN
542: g_debug:=hr_utility.debug_enabled;
543: if g_debug then
544: l_proc := g_package||'chk_entity_type';
545: hr_utility.set_location('Entering:'||l_proc, 5);
546: end if;
547: --
548: -- check that the entity type has been entered
549: --

Line 553: hr_utility.set_message(809, 'HXC_EGC_ENTITY_TYPE_MAND');

549: --
550: IF p_entity_type IS NULL
551: THEN
552: --
553: hr_utility.set_message(809, 'HXC_EGC_ENTITY_TYPE_MAND');
554: hr_utility.raise_error;
555: --
556: END IF;
557: if g_debug then

Line 554: hr_utility.raise_error;

550: IF p_entity_type IS NULL
551: THEN
552: --
553: hr_utility.set_message(809, 'HXC_EGC_ENTITY_TYPE_MAND');
554: hr_utility.raise_error;
555: --
556: END IF;
557: if g_debug then
558: hr_utility.set_location('Processing:'||l_proc, 10);

Line 558: hr_utility.set_location('Processing:'||l_proc, 10);

554: hr_utility.raise_error;
555: --
556: END IF;
557: if g_debug then
558: hr_utility.set_location('Processing:'||l_proc, 10);
559: end if;
560: --
561: -- check that entity_component_id is valid
562: --

Line 570: hr_utility.set_message(809, 'HXC_EGC_ENTITY_TYPE_INVLD');

566: --
567: IF l_error IS NOT NULL
568: THEN
569: --
570: hr_utility.set_message(809, 'HXC_EGC_ENTITY_TYPE_INVLD');
571: hr_utility.raise_error;
572: --
573: END IF;
574: --

Line 571: hr_utility.raise_error;

567: IF l_error IS NOT NULL
568: THEN
569: --
570: hr_utility.set_message(809, 'HXC_EGC_ENTITY_TYPE_INVLD');
571: hr_utility.raise_error;
572: --
573: END IF;
574: --
575: if g_debug then

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

572: --
573: END IF;
574: --
575: if g_debug then
576: hr_utility.set_location('Leaving:'||l_proc, 20);
577: end if;
578: --
579: END chk_entity_type;
580: -- Procedure to check if there are duplicate rules for a particular

Line 608: g_debug:=hr_utility.debug_enabled;

604: l_buff varchar2(20);
605: l_proc varchar2(72);
606:
607: Begin
608: g_debug:=hr_utility.debug_enabled;
609: if g_debug then
610: l_proc := g_package||'chk_dup_app_PTE';
611: hr_utility.set_location('Entering:'||l_proc, 5);
612: end if;

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

607: Begin
608: g_debug:=hr_utility.debug_enabled;
609: if g_debug then
610: l_proc := g_package||'chk_dup_app_PTE';
611: hr_utility.set_location('Entering:'||l_proc, 5);
612: end if;
613: open csr_chk_dup_app;
614: if g_debug then
615: hr_utility.trace('After open');

Line 615: hr_utility.trace('After open');

611: hr_utility.set_location('Entering:'||l_proc, 5);
612: end if;
613: open csr_chk_dup_app;
614: if g_debug then
615: hr_utility.trace('After open');
616: hr_utility.trace('Entity_id ' || p_entity_id);
617: hr_utility.trace('Group id ' || p_entity_group_id);
618: end if;
619: fetch csr_chk_dup_app into l_buff;

Line 616: hr_utility.trace('Entity_id ' || p_entity_id);

612: end if;
613: open csr_chk_dup_app;
614: if g_debug then
615: hr_utility.trace('After open');
616: hr_utility.trace('Entity_id ' || p_entity_id);
617: hr_utility.trace('Group id ' || p_entity_group_id);
618: end if;
619: fetch csr_chk_dup_app into l_buff;
620: if g_debug then

Line 617: hr_utility.trace('Group id ' || p_entity_group_id);

613: open csr_chk_dup_app;
614: if g_debug then
615: hr_utility.trace('After open');
616: hr_utility.trace('Entity_id ' || p_entity_id);
617: hr_utility.trace('Group id ' || p_entity_group_id);
618: end if;
619: fetch csr_chk_dup_app into l_buff;
620: if g_debug then
621: hr_utility.trace('res' || l_buff);

Line 621: hr_utility.trace('res' || l_buff);

617: hr_utility.trace('Group id ' || p_entity_group_id);
618: end if;
619: fetch csr_chk_dup_app into l_buff;
620: if g_debug then
621: hr_utility.trace('res' || l_buff);
622: end if;
623:
624: if (csr_chk_dup_app%FOUND) then
625: if g_debug then

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

622: end if;
623:
624: if (csr_chk_dup_app%FOUND) then
625: if g_debug then
626: hr_utility.set_location('Entering:'||l_proc, 10);
627: end if;
628: close csr_chk_dup_app;
629: hr_utility.set_message(809,'HXC_REC_APP_DUP');
630: hr_utility.raise_error;

Line 629: hr_utility.set_message(809,'HXC_REC_APP_DUP');

625: if g_debug then
626: hr_utility.set_location('Entering:'||l_proc, 10);
627: end if;
628: close csr_chk_dup_app;
629: hr_utility.set_message(809,'HXC_REC_APP_DUP');
630: hr_utility.raise_error;
631: end if;
632: close csr_chk_dup_app;
633: if g_debug then

Line 630: hr_utility.raise_error;

626: hr_utility.set_location('Entering:'||l_proc, 10);
627: end if;
628: close csr_chk_dup_app;
629: hr_utility.set_message(809,'HXC_REC_APP_DUP');
630: hr_utility.raise_error;
631: end if;
632: close csr_chk_dup_app;
633: if g_debug then
634: hr_utility.set_location('leaving:'||l_proc, 15);

Line 634: hr_utility.set_location('leaving:'||l_proc, 15);

630: hr_utility.raise_error;
631: end if;
632: close csr_chk_dup_app;
633: if g_debug then
634: hr_utility.set_location('leaving:'||l_proc, 15);
635: end if;
636: end chk_dup_app_PTE;
637:
638: -- ----------------------------------------------------------------------------

Line 650: g_debug:=hr_utility.debug_enabled;

646: --
647: l_proc varchar2(72);
648: --
649: Begin
650: g_debug:=hr_utility.debug_enabled;
651: if g_debug then
652: l_proc := g_package||'insert_validate';
653: hr_utility.set_location('Entering:'||l_proc, 5);
654: end if;

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

649: Begin
650: g_debug:=hr_utility.debug_enabled;
651: if g_debug then
652: l_proc := g_package||'insert_validate';
653: hr_utility.set_location('Entering:'||l_proc, 5);
654: end if;
655: --
656: -- Call all supporting business operations
657: --

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

686: chk_df(p_rec);
687: END IF;
688:
689: if g_debug then
690: hr_utility.set_location(' Leaving:'||l_proc, 10);
691: end if;
692: End insert_validate;
693: --
694: -- ----------------------------------------------------------------------------

Line 706: g_debug:=hr_utility.debug_enabled;

702: --
703: l_proc varchar2(72);
704: --
705: Begin
706: g_debug:=hr_utility.debug_enabled;
707: if g_debug then
708: l_proc := g_package||'update_validate';
709: hr_utility.set_location('Entering:'||l_proc, 5);
710: end if;

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

705: Begin
706: g_debug:=hr_utility.debug_enabled;
707: if g_debug then
708: l_proc := g_package||'update_validate';
709: hr_utility.set_location('Entering:'||l_proc, 5);
710: end if;
711: --
712: -- Call all supporting business operations
713: --

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

735: chk_df(p_rec);
736: END IF;
737:
738: if g_debug then
739: hr_utility.set_location(' Leaving:'||l_proc, 10);
740: end if;
741: End update_validate;
742: --
743: -- ----------------------------------------------------------------------------

Line 753: g_debug:=hr_utility.debug_enabled;

749: --
750: l_proc varchar2(72);
751: --
752: Begin
753: g_debug:=hr_utility.debug_enabled;
754: if g_debug then
755: l_proc := g_package||'delete_validate';
756: hr_utility.set_location('Entering:'||l_proc, 5);
757: end if;

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

752: Begin
753: g_debug:=hr_utility.debug_enabled;
754: if g_debug then
755: l_proc := g_package||'delete_validate';
756: hr_utility.set_location('Entering:'||l_proc, 5);
757: end if;
758: --
759: -- Call all supporting business operations
760: null;

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

759: -- Call all supporting business operations
760: null;
761:
762: if g_debug then
763: hr_utility.set_location(' Leaving:'||l_proc, 10);
764: end if;
765: End delete_validate;
766: --
767: end hxc_egc_bus;