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

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

41: --
42: Begin
43: --
44: l_proc := g_package||'chk_noac_la_id';
45: hr_utility.set_location('Entering:'||l_proc, 5);
46: --
47: l_api_updating := ghr_nla_shd.api_updating
48: (p_noac_la_id => p_noac_la_id,
49: p_object_version_number => p_object_version_number);

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

69: end if;
70: --
71: end if;
72: --
73: hr_utility.set_location('Leaving:'||l_proc, 10);
74: --
75: End chk_noac_la_id;
76: --
77: -- ----------------------------------------------------------------------------

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

113: where a.nature_of_action_id = p_nature_of_action_id;
114: --
115: Begin
116: --
117: hr_utility.set_location('Entering:'||l_proc,5);
118: --
119: l_api_updating := ghr_nla_shd.api_updating
120: (p_noac_la_id => p_noac_la_id,
121: p_object_version_number => p_object_version_number);

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

144: close c1;
145: --
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc,10);
149: --
150: End chk_nature_of_action_id;
151: --
152: -- ----------------------------------------------------------------------------

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

185: --
186: Begin
187: --
188: l_proc := g_package||'chk_enabled_flag';
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: l_api_updating := ghr_nla_shd.api_updating
192: (p_noac_la_id => p_noac_la_id,
193: p_object_version_number => p_object_version_number);

Line 210: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

206: p_effective_date => p_effective_date) then
207: --
208: -- raise error as does not exist as lookup
209: --
210: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
211: hr_utility.raise_error;
212: --
213: end if;
214: --

Line 211: hr_utility.raise_error;

207: --
208: -- raise error as does not exist as lookup
209: --
210: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
211: hr_utility.raise_error;
212: --
213: end if;
214: --
215: end if;

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

213: end if;
214: --
215: end if;
216: --
217: hr_utility.set_location('Leaving:'||l_proc,10);
218: --
219: end chk_enabled_flag;
220: --
221: -- ----------------------------------------------------------------------------

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

254: --
255: Begin
256: --
257: l_proc := g_package||'chk_valid_second_lac_flag';
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: l_api_updating := ghr_nla_shd.api_updating
261: (p_noac_la_id => p_noac_la_id,
262: p_object_version_number => p_object_version_number);

Line 279: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

275: p_effective_date => p_effective_date) then
276: --
277: -- raise error as does not exist as lookup
278: --
279: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
280: hr_utility.raise_error;
281: --
282: end if;
283: --

Line 280: hr_utility.raise_error;

276: --
277: -- raise error as does not exist as lookup
278: --
279: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
280: hr_utility.raise_error;
281: --
282: end if;
283: --
284: end if;

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

282: end if;
283: --
284: end if;
285: --
286: hr_utility.set_location('Leaving:'||l_proc,10);
287: --
288: end chk_valid_second_lac_flag;
289: --
290: -- ----------------------------------------------------------------------------

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

323: --
324: Begin
325: --
326: l_proc := g_package||'chk_valid_first_lac_flag';
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: l_api_updating := ghr_nla_shd.api_updating
330: (p_noac_la_id => p_noac_la_id,
331: p_object_version_number => p_object_version_number);

Line 348: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

344: p_effective_date => p_effective_date) then
345: --
346: -- raise error as does not exist as lookup
347: --
348: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
349: hr_utility.raise_error;
350: --
351: end if;
352: --

Line 349: hr_utility.raise_error;

345: --
346: -- raise error as does not exist as lookup
347: --
348: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
349: hr_utility.raise_error;
350: --
351: end if;
352: --
353: end if;

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

351: end if;
352: --
353: end if;
354: --
355: hr_utility.set_location('Leaving:'||l_proc,10);
356: --
357: end chk_valid_first_lac_flag;
358: --
359: -- ----------------------------------------------------------------------------

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

395: --
396: Begin
397: --
398: l_proc := g_package||'chk_date_from';
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: l_api_updating := ghr_nla_shd.api_updating
402: (p_noac_la_id => p_noac_la_id,
403: p_object_version_number => p_object_version_number);

Line 424: hr_utility.set_message(8301,'GHR_38196_TO_DATE_LESSER');

420: -- greater than or equal to date_from
421: --
422: if p_date_to is not null then
423: if trunc(p_date_from) > trunc(p_date_to) then
424: hr_utility.set_message(8301,'GHR_38196_TO_DATE_LESSER');
425: hr_utility.raise_error;
426: end if;
427: end if;
428:

Line 425: hr_utility.raise_error;

421: --
422: if p_date_to is not null then
423: if trunc(p_date_from) > trunc(p_date_to) then
424: hr_utility.set_message(8301,'GHR_38196_TO_DATE_LESSER');
425: hr_utility.raise_error;
426: end if;
427: end if;
428:
429:

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

426: end if;
427: end if;
428:
429:
430: hr_utility.set_location('Leaving:'||l_proc,10);
431: --
432: end chk_date_from;
433: --
434: -- ----------------------------------------------------------------------------

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

476: --
477: Begin
478: --
479: l_proc := g_package||'chk_unique_act_lac_cd';
480: hr_utility.set_location('Entering:'||l_proc, 5);
481: --
482: l_api_updating := ghr_nla_shd.api_updating
483: (p_noac_la_id => p_noac_la_id,
484: p_object_version_number => p_object_version_number);

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

482: l_api_updating := ghr_nla_shd.api_updating
483: (p_noac_la_id => p_noac_la_id,
484: p_object_version_number => p_object_version_number);
485: --
486: hr_utility.set_location('Entering:'||l_proc, 10);
487: --
488: if (l_api_updating
489: and ( p_nature_of_action_id
490: <> nvl(ghr_nla_shd.g_old_rec.nature_of_action_id,hr_api.g_number)

Line 500: hr_utility.set_location('Entering:'||l_proc, 15);

496: --
497: -- check if the combination of action_id and lac_lookup_code already exits
498: --
499: --
500: hr_utility.set_location('Entering:'||l_proc, 15);
501: --
502: open c1;
503: --
504: --

Line 505: hr_utility.set_location('Entering:'||l_proc, 16);

501: --
502: open c1;
503: --
504: --
505: hr_utility.set_location('Entering:'||l_proc, 16);
506: --
507: fetch c1 into l_dummy;
508: --
509: hr_utility.set_location('Entering:'||l_proc, 17);

Line 509: hr_utility.set_location('Entering:'||l_proc, 17);

505: hr_utility.set_location('Entering:'||l_proc, 16);
506: --
507: fetch c1 into l_dummy;
508: --
509: hr_utility.set_location('Entering:'||l_proc, 17);
510: --
511: if c1%found then
512: --
513: close c1;

Line 516: hr_utility.set_location('Entering:'||l_proc, 18);

512: --
513: close c1;
514: --
515: --
516: hr_utility.set_location('Entering:'||l_proc, 18);
517: --
518: -- raise error as the combination already exists
519: --
520: hr_utility.set_message(8301,'GHR_NOAC_LAC_DUPLICATE');

Line 520: hr_utility.set_message(8301,'GHR_NOAC_LAC_DUPLICATE');

516: hr_utility.set_location('Entering:'||l_proc, 18);
517: --
518: -- raise error as the combination already exists
519: --
520: hr_utility.set_message(8301,'GHR_NOAC_LAC_DUPLICATE');
521: hr_utility.raise_error;
522: end if;
523: --
524: close c1;

Line 521: hr_utility.raise_error;

517: --
518: -- raise error as the combination already exists
519: --
520: hr_utility.set_message(8301,'GHR_NOAC_LAC_DUPLICATE');
521: hr_utility.raise_error;
522: end if;
523: --
524: close c1;
525:

Line 528: hr_utility.set_location('Leaving:'||l_proc,25);

524: close c1;
525:
526: end if;
527: --
528: hr_utility.set_location('Leaving:'||l_proc,25);
529: --
530: end chk_unique_act_lac_cd;
531: --
532: -- ----------------------------------------------------------------------------

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

565: --
566: Begin
567: --
568: l_proc := g_package||'chk_lac_lookup_code';
569: hr_utility.set_location('Entering:'||l_proc, 5);
570: --
571: l_api_updating := ghr_nla_shd.api_updating
572: (p_noac_la_id => p_noac_la_id,
573: p_object_version_number => p_object_version_number);

Line 590: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

586: p_effective_date => p_effective_date) then
587: --
588: -- raise error as does not exist as lookup
589: --
590: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
591: hr_utility.raise_error;
592: --
593: end if;
594: --

Line 591: hr_utility.raise_error;

587: --
588: -- raise error as does not exist as lookup
589: --
590: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
591: hr_utility.raise_error;
592: --
593: end if;
594: --
595: end if;

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

593: end if;
594: --
595: end if;
596: --
597: hr_utility.set_location('Leaving:'||l_proc,10);
598: --
599: end chk_lac_lookup_code;
600: --
601: -- ----------------------------------------------------------------------------

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

607: l_proc varchar2(72);
608: --
609: Begin
610: l_proc := g_package||'insert_validate';
611: hr_utility.set_location('Entering:'||l_proc, 5);
612: --
613: -- Set up the CLIENT_INFO
614: --
615: ghr_utility.set_client_info;

Line 615: ghr_utility.set_client_info;

611: hr_utility.set_location('Entering:'||l_proc, 5);
612: --
613: -- Set up the CLIENT_INFO
614: --
615: ghr_utility.set_client_info;
616: --
617: -- Call all supporting business operations
618: --
619: chk_noac_la_id

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

663: p_object_version_number => p_rec.object_version_number);
664: --
665: --
666: --
667: hr_utility.set_location(' Leaving:'||l_proc, 10);
668: End insert_validate;
669: --
670: -- ----------------------------------------------------------------------------
671: -- |---------------------------< update_validate >----------------------------|

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

676: l_proc varchar2(72);
677: --
678: Begin
679: l_proc := g_package||'update_validate';
680: hr_utility.set_location('Entering:'||l_proc, 5);
681: --
682: -- Set up the CLIENT_INFO
683: --
684: ghr_utility.set_client_info;

Line 684: ghr_utility.set_client_info;

680: hr_utility.set_location('Entering:'||l_proc, 5);
681: --
682: -- Set up the CLIENT_INFO
683: --
684: ghr_utility.set_client_info;
685: --
686: -- Call all supporting business operations
687: --
688: chk_noac_la_id

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

732: p_object_version_number => p_rec.object_version_number);
733: --
734: --
735: --
736: hr_utility.set_location(' Leaving:'||l_proc, 10);
737: End update_validate;
738: --
739: -- ----------------------------------------------------------------------------
740: -- |---------------------------< delete_validate >----------------------------|

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

745: l_proc varchar2(72) ;
746: --
747: Begin
748: l_proc := g_package||'delete_validate';
749: hr_utility.set_location('Entering:'||l_proc, 5);
750: --
751: -- Call all supporting business operations
752: --
753: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

749: hr_utility.set_location('Entering:'||l_proc, 5);
750: --
751: -- Call all supporting business operations
752: --
753: hr_utility.set_location(' Leaving:'||l_proc, 10);
754: End delete_validate;
755: --
756: end ghr_nla_bus;