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

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

39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

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

79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------

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

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

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

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := pay_esu_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

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

143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

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

152: close csr_leg_code;
153: pay_esu_bus.g_element_span_usage_id := p_element_span_usage_id;
154: pay_esu_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

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

207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
210: --
211: hr_utility.set_location(l_proc, 10);
212: --
213: if nvl(p_rec.business_group_id, hr_api.g_number) <>
214: nvl(pay_esu_shd.g_old_rec.business_group_id, hr_api.g_number) then
215: l_argument := 'business_group_id';

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

214: nvl(pay_esu_shd.g_old_rec.business_group_id, hr_api.g_number) then
215: l_argument := 'business_group_id';
216: raise l_error;
217: end if;
218: hr_utility.set_location(l_proc, 15);
219: --
220: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
221: nvl(pay_esu_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
222: l_argument := 'legislation_code';

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

221: nvl(pay_esu_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
222: l_argument := 'legislation_code';
223: raise l_error;
224: end if;
225: hr_utility.set_location(l_proc, 20);
226: --
227: if nvl(p_rec.retro_component_usage_id, hr_api.g_number) <>
228: nvl(pay_esu_shd.g_old_rec.retro_component_usage_id, hr_api.g_number) then
229: l_argument := 'retro_component_usage_id';

Line 232: hr_utility.set_location(l_proc, 25);

228: nvl(pay_esu_shd.g_old_rec.retro_component_usage_id, hr_api.g_number) then
229: l_argument := 'retro_component_usage_id';
230: raise l_error;
231: end if;
232: hr_utility.set_location(l_proc, 25);
233: --
234: if nvl(p_rec.time_span_id, hr_api.g_number) <>
235: nvl(pay_esu_shd.g_old_rec.time_span_id, hr_api.g_number) then
236: l_argument := 'time_span_id';

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

235: nvl(pay_esu_shd.g_old_rec.time_span_id, hr_api.g_number) then
236: l_argument := 'time_span_id';
237: raise l_error;
238: end if;
239: hr_utility.set_location(l_proc, 30);
240: --
241: exception
242: when l_error then
243: hr_api.argument_changed_error

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

346: and nvl(business_group_id, nvl(p_business_group_id, l_number))
347: = nvl(p_business_group_id, l_number);
348: --
349: begin
350: hr_utility.set_location('Entering:'|| l_proc, 10);
351: --
352: -- Check mandatory parameters have been set
353: --
354: hr_api.mandatory_arg_error

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

366:
367: --
368: -- Check if the retro component usage exists.
369: --
370: hr_utility.set_location(l_proc, 20);
371: open csr_retro_component_usage;
372: fetch csr_retro_component_usage into l_exists;
373: if csr_retro_component_usage%notfound then
374: close csr_retro_component_usage;

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

378:
379: end if;
380: close csr_retro_component_usage;
381:
382: hr_utility.set_location(' Leaving:'|| l_proc, 50);
383: end chk_retro_component_usage_id;
384: --
385: -- -------------------------------------------------------------------------
386: -- |-------------------------< chk_time_span_id >--------------------------|

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

435: and pts.creator_type = 'RC'
436: and pts.creator_id = rcu.retro_component_id;
437: --
438: begin
439: hr_utility.set_location('Entering:'|| l_proc, 10);
440: --
441: -- Check mandatory parameters have been set
442: --
443: hr_api.mandatory_arg_error

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

453:
454: --
455: -- Check if the time span exists.
456: --
457: hr_utility.set_location(l_proc, 20);
458: open csr_time_span;
459: fetch csr_time_span into l_exists;
460: if csr_time_span%notfound then
461: close csr_time_span;

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

465:
466: end if;
467: close csr_time_span;
468:
469: hr_utility.set_location(' Leaving:'|| l_proc, 50);
470: end chk_time_span_id;
471: --
472: -- -------------------------------------------------------------------------
473: -- |------------------------< chk_adjustment_type >------------------------|

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

515: l_api_updating boolean;
516:
517: --
518: begin
519: hr_utility.set_location('Entering:'|| l_proc, 10);
520: --
521: -- Check mandatory parameters have been set
522: --
523: hr_api.mandatory_arg_error

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

525: ,p_argument => 'effective_date'
526: ,p_argument_value => p_effective_date
527: );
528:
529: hr_utility.set_location(l_proc, 15);
530: --
531: -- Check if the element span usage is being updated and ensure that
532: -- g_old_rec contains the values for this element_span_usage_id.
533: --

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

535: pay_esu_shd.api_updating
536: (p_element_span_usage_id => p_element_span_usage_id
537: ,p_object_version_number => p_object_version_number);
538:
539: hr_utility.set_location(l_proc, 20);
540: --
541: -- Only proceed with validation if:
542: -- a) During update, the value has actually changed to
543: -- another not null value.

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

548: <> nvl(p_adjustment_type, hr_api.g_varchar2))
549: or
550: NOT l_api_updating) then
551: --
552: hr_utility.set_location(l_proc, 30);
553:
554: --
555: -- If adjustment_type is not null then
556: -- Check if the adjustment_type value exists in hr_lookups

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

571: end if;
572: end if;
573: end if;
574:
575: hr_utility.set_location(' Leaving:'|| l_proc, 50);
576: end chk_adjustment_type;
577: --
578: --
579: -- -------------------------------------------------------------------------

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

640: and nvl(business_group_id, nvl(p_business_group_id, l_number))
641: = nvl(p_business_group_id, l_number);
642: --
643: begin
644: hr_utility.set_location('Entering:'|| l_proc, 10);
645: --
646: -- Check mandatory parameters have been set
647: --
648: hr_api.mandatory_arg_error

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

665: pay_esu_shd.api_updating
666: (p_element_span_usage_id => p_element_span_usage_id
667: ,p_object_version_number => p_object_version_number);
668:
669: hr_utility.set_location(l_proc, 20);
670: --
671: -- Only proceed with validation if:
672: -- a) During update, the value has actually changed to
673: -- another not null value.

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

677: pay_esu_shd.g_old_rec.retro_element_type_id <> p_retro_element_type_id)
678: or
679: NOT l_api_updating) then
680: --
681: hr_utility.set_location(l_proc, 30);
682:
683: --
684: -- Check if the retro element type exists.
685: --

Line 686: hr_utility.set_location(l_proc, 40);

682:
683: --
684: -- Check if the retro element type exists.
685: --
686: hr_utility.set_location(l_proc, 40);
687: open csr_retro_element_type;
688: fetch csr_retro_element_type into l_exists;
689: if csr_retro_element_type%notfound then
690: close csr_retro_element_type;

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

695: end if;
696: close csr_retro_element_type;
697: end if;
698:
699: hr_utility.set_location(' Leaving:'|| l_proc, 50);
700: end chk_retro_element_type_id;
701: --
702:
703: --

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

711: --
712: l_proc varchar2(72) := g_package||'insert_validate';
713: --
714: Begin
715: hr_utility.set_location('Entering:'||l_proc, 5);
716: --
717: -- Call all supporting business operations
718: --
719: --

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

768: ,p_object_version_number => p_rec.object_version_number
769: ,p_effective_date => p_effective_date
770: );
771:
772: hr_utility.set_location(' Leaving:'||l_proc, 10);
773: End insert_validate;
774: --
775: -- ----------------------------------------------------------------------------
776: -- |---------------------------< update_validate >----------------------------|

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

782: --
783: l_proc varchar2(72) := g_package||'update_validate';
784: --
785: Begin
786: hr_utility.set_location('Entering:'||l_proc, 5);
787: --
788: -- Call all supporting business operations
789: --
790: --

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

833: ,p_effective_date => p_effective_date
834: );
835:
836: --
837: hr_utility.set_location(' Leaving:'||l_proc, 10);
838: End update_validate;
839: --
840: -- ----------------------------------------------------------------------------
841: -- |---------------------------< delete_validate >----------------------------|

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

846: --
847: l_proc varchar2(72) := g_package||'delete_validate';
848: --
849: Begin
850: hr_utility.set_location('Entering:'||l_proc, 5);
851: --
852: --
853: chk_startup_action(false
854: ,pay_esu_shd.g_old_rec.business_group_id

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

868: END IF;
869: --
870: -- Call all supporting business operations
871: --
872: hr_utility.set_location(' Leaving:'||l_proc, 10);
873: End delete_validate;
874: --
875: end pay_esu_bus;