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_HRP_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_hrp_bus.'; -- Global package name
9: g_debug boolean :=hr_utility.debug_enabled;
10: --
11: -- The following two global variables are only to be
12: -- used by the return_legislation_code function.
13: --

Line 47: g_debug:=hr_utility.debug_enabled;

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

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

46: --
47: g_debug:=hr_utility.debug_enabled;
48: if g_debug then
49: l_proc := g_package||'set_security_group_id';
50: hr_utility.set_location('Entering:'|| l_proc, 10);
51: end if;
52: --
53: -- Ensure that all the mandatory parameter are not null
54: --

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

79: (p_security_group_id => l_security_group_id
80: );
81: --
82: if g_debug then
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: end if ;
85: --
86: end set_security_group_id;
87: --

Line 119: g_debug:=hr_utility.debug_enabled;

115: l_proc varchar2(72);
116: --
117: Begin
118: --
119: g_debug:=hr_utility.debug_enabled;
120: if g_debug then
121: l_proc := g_package||'return_legislation_code';
122: hr_utility.set_location('Entering:'|| l_proc, 10);
123: end if;

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

118: --
119: g_debug:=hr_utility.debug_enabled;
120: if g_debug then
121: l_proc := g_package||'return_legislation_code';
122: hr_utility.set_location('Entering:'|| l_proc, 10);
123: end if;
124: --
125: -- Ensure that all the mandatory parameter are not null
126: --

Line 142: hr_utility.set_location(l_proc, 20);

138: -- variable.
139: --
140: l_legislation_code := hxc_hrp_bus.g_legislation_code;
141: if g_debug then
142: hr_utility.set_location(l_proc, 20);
143: end if;
144: else
145: --
146: -- The ID is different to the last call to this function

Line 161: hr_utility.set_location(l_proc,30);

157: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
158: fnd_message.raise_error;
159: end if;
160: if g_debug then
161: hr_utility.set_location(l_proc,30);
162: end if;
163: --
164: -- Set the global variables so the values are
165: -- available for the next call to this function.

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

168: hxc_hrp_bus.g_recurring_period_id:= p_recurring_period_id;
169: hxc_hrp_bus.g_legislation_code := l_legislation_code;
170: end if;
171: if g_debug then
172: hr_utility.set_location(' Leaving:'|| l_proc, 40);
173: end if;
174: return l_legislation_code;
175: end return_legislation_code;
176: --

Line 286: g_debug:=hr_utility.debug_enabled;

282: --
283: l_error varchar2(5) := NULL;
284: --
285: BEGIN
286: g_debug:=hr_utility.debug_enabled;
287: if g_debug then
288: l_proc := g_package||'chk_name';
289: hr_utility.set_location('Entering:'||l_proc, 5);
290: end if;

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

285: BEGIN
286: g_debug:=hr_utility.debug_enabled;
287: if g_debug then
288: l_proc := g_package||'chk_name';
289: hr_utility.set_location('Entering:'||l_proc, 5);
290: end if;
291: --
292: -- Raise error if name is NULL as it is a mandatory field.
293: --

Line 297: hr_utility.set_message(809, 'HXC_0079_HRP_PERIOD_NAME_MAND');

293: --
294: IF p_name IS NULL
295: THEN
296: --
297: hr_utility.set_message(809, 'HXC_0079_HRP_PERIOD_NAME_MAND');
298: hr_utility.raise_error;
299: --
300: END IF;
301: if g_debug then

Line 298: hr_utility.raise_error;

294: IF p_name IS NULL
295: THEN
296: --
297: hr_utility.set_message(809, 'HXC_0079_HRP_PERIOD_NAME_MAND');
298: hr_utility.raise_error;
299: --
300: END IF;
301: if g_debug then
302: hr_utility.set_location('Processing:'||l_proc, 10);

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

298: hr_utility.raise_error;
299: --
300: END IF;
301: if g_debug then
302: hr_utility.set_location('Processing:'||l_proc, 10);
303: end if;
304: --
305: -- Raise an error if the period name is not unique
306: --

Line 314: hr_utility.set_message(809, 'HXC_0080_HRP_DUP_PERIOD_NAME');

310: --
311: IF l_error IS NOT NULL
312: THEN
313: --
314: hr_utility.set_message(809, 'HXC_0080_HRP_DUP_PERIOD_NAME');
315: hr_utility.raise_error;
316: --
317: END IF;
318: --

Line 315: hr_utility.raise_error;

311: IF l_error IS NOT NULL
312: THEN
313: --
314: hr_utility.set_message(809, 'HXC_0080_HRP_DUP_PERIOD_NAME');
315: hr_utility.raise_error;
316: --
317: END IF;
318: --
319: if g_debug then

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

316: --
317: END IF;
318: --
319: if g_debug then
320: hr_utility.set_location('Leaving:'||l_proc, 20);
321: end if;
322: --
323: END chk_name;
324: --

Line 372: g_debug:=hr_utility.debug_enabled;

368: l_proc varchar2(72) ;
369: l_error varchar2(5) := NULL;
370: --
371: BEGIN
372: g_debug:=hr_utility.debug_enabled;
373: if g_debug then
374: l_proc:= g_package||'chk_period_type';
375: hr_utility.set_location('Entering:'||l_proc, 5);
376: end if;

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

371: BEGIN
372: g_debug:=hr_utility.debug_enabled;
373: if g_debug then
374: l_proc:= g_package||'chk_period_type';
375: hr_utility.set_location('Entering:'||l_proc, 5);
376: end if;
377: --
378: -- Check to see if this is a valid per time period type
379: --

Line 386: hr_utility.set_location(l_proc, 10);

382:
383: open c_period_type(p_period_type);
384: fetch c_period_type into l_error;
385: if g_debug then
386: hr_utility.set_location(l_proc, 10);
387: end if;
388:
389: if c_period_type%NOTFOUND then
390: --

Line 394: hr_utility.set_location(l_proc, 15);

390: --
391: -- This isn't a valid period type, raise an error.
392: --
393: if g_debug then
394: hr_utility.set_location(l_proc, 15);
395: end if;
396: close c_period_type;
397: FND_MESSAGE.SET_NAME('HXC','HXC_0152_INVALID_PERIOD_TYPE');
398: FND_MESSAGE.RAISE_ERROR;

Line 401: hr_utility.set_location(l_proc, 20);

397: FND_MESSAGE.SET_NAME('HXC','HXC_0152_INVALID_PERIOD_TYPE');
398: FND_MESSAGE.RAISE_ERROR;
399: else
400: if g_debug then
401: hr_utility.set_location(l_proc, 20);
402: end if;
403: close c_period_type;
404: end if;
405:

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

405:
406: end if;
407:
408: if g_debug then
409: hr_utility.set_location('Leaving:'||l_proc, 30);
410: end if;
411: --
412: END chk_period_type;
413: --

Line 449: g_debug:=hr_utility.debug_enabled;

445: l_proc varchar2(72);
446: l_error varchar2(5) := NULL;
447: --
448: BEGIN
449: g_debug:=hr_utility.debug_enabled;
450: if g_debug then
451: l_proc := g_package||'chk_type_duration';
452: hr_utility.set_location('Entering:'||l_proc, 5);
453: end if;

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

448: BEGIN
449: g_debug:=hr_utility.debug_enabled;
450: if g_debug then
451: l_proc := g_package||'chk_type_duration';
452: hr_utility.set_location('Entering:'||l_proc, 5);
453: end if;
454: --
455: -- Raise error if both type and duration are null for a period.
456: --

Line 461: hr_utility.set_message(809, 'HXC_0081_HRP_TYPE_OR_DAYS_MAND');

457: IF p_period_type IS NULL
458: AND p_duration_in_days IS NULL
459: THEN
460: --
461: hr_utility.set_message(809, 'HXC_0081_HRP_TYPE_OR_DAYS_MAND');
462: hr_utility.raise_error;
463: --
464: END IF;
465: if g_debug then

Line 462: hr_utility.raise_error;

458: AND p_duration_in_days IS NULL
459: THEN
460: --
461: hr_utility.set_message(809, 'HXC_0081_HRP_TYPE_OR_DAYS_MAND');
462: hr_utility.raise_error;
463: --
464: END IF;
465: if g_debug then
466: hr_utility.set_location('Leaving:'||l_proc, 10);

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

462: hr_utility.raise_error;
463: --
464: END IF;
465: if g_debug then
466: hr_utility.set_location('Leaving:'||l_proc, 10);
467: end if;
468: --
469: END chk_type_duration;
470: --

Line 510: g_debug:=hr_utility.debug_enabled;

506: --
507: l_exists VARCHAR2(6) := NULL;
508: --
509: BEGIN
510: g_debug:=hr_utility.debug_enabled;
511: if g_debug then
512: l_proc := g_package||'chk_delete';
513: hr_utility.set_location('Entering:'||l_proc, 5);
514: end if;

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

509: BEGIN
510: g_debug:=hr_utility.debug_enabled;
511: if g_debug then
512: l_proc := g_package||'chk_delete';
513: hr_utility.set_location('Entering:'||l_proc, 5);
514: end if;
515: --
516: -- check that recurring period is not being used
517: --

Line 522: hr_utility.set_location('Calling num_hierarchy_occurances: '||l_proc, 10);

518: /* OPEN csr_chk_apc;
519: FETCH csr_chk_apc INTO l_exists;
520: CLOSE csr_chk_apc;*/
521: if g_debug then
522: hr_utility.set_location('Calling num_hierarchy_occurances: '||l_proc, 10);
523: end if;
524: l_exists := HXC_PREFERENCE_EVALUATION.num_hierarchy_occurances
525: ('TC_W_TCRD_PERIOD'
526: ,1

Line 529: hr_utility.set_location('After calling num_hierarchy_occurances:'||l_proc,20);

525: ('TC_W_TCRD_PERIOD'
526: ,1
527: ,TO_CHAR(p_recurring_period_id));
528: if g_debug then
529: hr_utility.set_location('After calling num_hierarchy_occurances:'||l_proc,20);
530: end if;
531: --
532: if g_debug then
533: hr_utility.set_location('Processing: '||l_proc, 10);

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

529: hr_utility.set_location('After calling num_hierarchy_occurances:'||l_proc,20);
530: end if;
531: --
532: if g_debug then
533: hr_utility.set_location('Processing: '||l_proc, 10);
534: end if;
535: --
536: IF l_exists <> 0 THEN
537: --

Line 538: hr_utility.set_message(809, 'HXC_0082_HRP_PERIOD_IN_APRSET');

534: end if;
535: --
536: IF l_exists <> 0 THEN
537: --
538: hr_utility.set_message(809, 'HXC_0082_HRP_PERIOD_IN_APRSET');
539: hr_utility.raise_error;
540: --
541: END IF;
542: --

Line 539: hr_utility.raise_error;

535: --
536: IF l_exists <> 0 THEN
537: --
538: hr_utility.set_message(809, 'HXC_0082_HRP_PERIOD_IN_APRSET');
539: hr_utility.raise_error;
540: --
541: END IF;
542: --
543: if g_debug then

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

540: --
541: END IF;
542: --
543: if g_debug then
544: hr_utility.set_location('Entering:'||l_proc, 5);
545: end if;
546: --
547: END chk_delete;
548:

Line 561: g_debug:=hr_utility.debug_enabled;

557: --
558: l_proc varchar2(72);
559: --
560: Begin
561: g_debug:=hr_utility.debug_enabled;
562: if g_debug then
563: l_proc := g_package||'insert_validate';
564: hr_utility.set_location('Entering:'||l_proc, 5);
565: end if;

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

560: Begin
561: g_debug:=hr_utility.debug_enabled;
562: if g_debug then
563: l_proc := g_package||'insert_validate';
564: hr_utility.set_location('Entering:'||l_proc, 5);
565: end if;
566: --
567: -- No business group context. HR_STANDARD_LOOKUPS used for validation.
568: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS.

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

570: -- Call all supporting business operations
571: --
572: --
573: if g_debug then
574: hr_utility.set_location('Processing:'||l_proc, 10);
575: end if;
576: --
577: chk_name ( p_name => p_rec.name,
578: p_object_version_number => p_rec.object_version_number );

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

577: chk_name ( p_name => p_rec.name,
578: p_object_version_number => p_rec.object_version_number );
579: --
580: if g_debug then
581: hr_utility.set_location(' Leaving:'||l_proc, 10);
582: end if;
583: --
584: if g_debug then
585: hr_utility.set_location(' Processing:'||l_proc, 15);

Line 585: hr_utility.set_location(' Processing:'||l_proc, 15);

581: hr_utility.set_location(' Leaving:'||l_proc, 10);
582: end if;
583: --
584: if g_debug then
585: hr_utility.set_location(' Processing:'||l_proc, 15);
586: end if;
587: --
588: chk_period_type
589: (p_period_type => p_rec.period_type);

Line 592: hr_utility.set_location(' Processing:'||l_proc, 20);

588: chk_period_type
589: (p_period_type => p_rec.period_type);
590: --
591: if g_debug then
592: hr_utility.set_location(' Processing:'||l_proc, 20);
593: end if;
594: --
595: if g_debug then
596: hr_utility.set_location('Processing:'||l_proc, 25);

Line 596: hr_utility.set_location('Processing:'||l_proc, 25);

592: hr_utility.set_location(' Processing:'||l_proc, 20);
593: end if;
594: --
595: if g_debug then
596: hr_utility.set_location('Processing:'||l_proc, 25);
597: end if;
598: --
599:
600: chk_type_duration ( p_period_type => p_rec.period_type,

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

600: chk_type_duration ( p_period_type => p_rec.period_type,
601: p_duration_in_days => p_rec.duration_in_days );
602: --
603: if g_debug then
604: hr_utility.set_location(' Leaving:'||l_proc, 30);
605: end if;
606: --
607:
608: End insert_validate;

Line 621: g_debug:=hr_utility.debug_enabled;

617: --
618: l_proc varchar2(72);
619: --
620: Begin
621: g_debug:=hr_utility.debug_enabled;
622: if g_debug then
623: l_proc := g_package||'update_validate';
624: hr_utility.set_location('Entering:'||l_proc, 5);
625: end if;

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

620: Begin
621: g_debug:=hr_utility.debug_enabled;
622: if g_debug then
623: l_proc := g_package||'update_validate';
624: hr_utility.set_location('Entering:'||l_proc, 5);
625: end if;
626: --
627: -- Call all supporting business operations
628: --

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

626: --
627: -- Call all supporting business operations
628: --
629: if g_debug then
630: hr_utility.set_location('Processing:'||l_proc, 10);
631: end if;
632: --
633: chk_name ( p_name => p_rec.name,
634: p_object_version_number => p_rec.object_version_number );

Line 637: hr_utility.set_location(' Leaving:'||l_proc, 15);

633: chk_name ( p_name => p_rec.name,
634: p_object_version_number => p_rec.object_version_number );
635: --
636: if g_debug then
637: hr_utility.set_location(' Leaving:'||l_proc, 15);
638: --
639: hr_utility.set_location(' Processing:'||l_proc, 20);
640: end if;
641: --

Line 639: hr_utility.set_location(' Processing:'||l_proc, 20);

635: --
636: if g_debug then
637: hr_utility.set_location(' Leaving:'||l_proc, 15);
638: --
639: hr_utility.set_location(' Processing:'||l_proc, 20);
640: end if;
641: --
642: chk_period_type
643: (p_period_type => p_rec.period_type);

Line 646: hr_utility.set_location(' Processing:'||l_proc, 25);

642: chk_period_type
643: (p_period_type => p_rec.period_type);
644: --
645: if g_debug then
646: hr_utility.set_location(' Processing:'||l_proc, 25);
647: --
648: hr_utility.set_location('Processing:'||l_proc, 30);
649: end if;
650: --

Line 648: hr_utility.set_location('Processing:'||l_proc, 30);

644: --
645: if g_debug then
646: hr_utility.set_location(' Processing:'||l_proc, 25);
647: --
648: hr_utility.set_location('Processing:'||l_proc, 30);
649: end if;
650: --
651:
652: chk_type_duration ( p_period_type => p_rec.period_type,

Line 656: hr_utility.set_location(' Leaving:'||l_proc, 35);

652: chk_type_duration ( p_period_type => p_rec.period_type,
653: p_duration_in_days => p_rec.duration_in_days );
654: --
655: if g_debug then
656: hr_utility.set_location(' Leaving:'||l_proc, 35);
657: end if;
658: --
659: -- " No business group context. HR_STANDARD_LOOKUPS used for validation."
660: -- " CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS."

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

665: );
666: --
667: --
668: if g_debug then
669: hr_utility.set_location(' Leaving:'||l_proc, 40);
670: end if;
671: End update_validate;
672: --
673: -- ----------------------------------------------------------------------------

Line 683: g_debug:=hr_utility.debug_enabled;

679: --
680: l_proc varchar2(72);
681: --
682: Begin
683: g_debug:=hr_utility.debug_enabled;
684: if g_debug then
685: l_proc := g_package||'delete_validate';
686: hr_utility.set_location('Entering:'||l_proc, 5);
687: end if;

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

682: Begin
683: g_debug:=hr_utility.debug_enabled;
684: if g_debug then
685: l_proc := g_package||'delete_validate';
686: hr_utility.set_location('Entering:'||l_proc, 5);
687: end if;
688: --
689: -- Call all supporting business operations
690: --

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

693: p_recurring_period_id => p_rec.recurring_period_id
694: );
695: --
696: if g_debug then
697: hr_utility.set_location(' Leaving:'||l_proc, 10);
698: end if;
699: End delete_validate;
700: --
701: end hxc_hrp_bus;