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 44: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

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

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

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

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

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

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

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

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

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

Line 209: hr_utility.raise_error;

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

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

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

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

251: l_api_updating boolean;
252: --
253: Begin
254: --
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: l_api_updating := ghr_nla_shd.api_updating
258: (p_noac_la_id => p_noac_la_id,
259: p_object_version_number => p_object_version_number);

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

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

Line 277: hr_utility.raise_error;

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

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

279: end if;
280: --
281: end if;
282: --
283: hr_utility.set_location('Leaving:'||l_proc,10);
284: --
285: end chk_valid_second_lac_flag;
286: --
287: -- ----------------------------------------------------------------------------

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

319: l_api_updating boolean;
320: --
321: Begin
322: --
323: hr_utility.set_location('Entering:'||l_proc, 5);
324: --
325: l_api_updating := ghr_nla_shd.api_updating
326: (p_noac_la_id => p_noac_la_id,
327: p_object_version_number => p_object_version_number);

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

340: p_effective_date => p_effective_date) then
341: --
342: -- raise error as does not exist as lookup
343: --
344: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
345: hr_utility.raise_error;
346: --
347: end if;
348: --

Line 345: hr_utility.raise_error;

341: --
342: -- raise error as does not exist as lookup
343: --
344: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
345: hr_utility.raise_error;
346: --
347: end if;
348: --
349: end if;

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

347: end if;
348: --
349: end if;
350: --
351: hr_utility.set_location('Leaving:'||l_proc,10);
352: --
353: end chk_valid_first_lac_flag;
354: --
355: -- ----------------------------------------------------------------------------

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

390: l_api_updating boolean;
391: --
392: Begin
393: --
394: hr_utility.set_location('Entering:'||l_proc, 5);
395: --
396: l_api_updating := ghr_nla_shd.api_updating
397: (p_noac_la_id => p_noac_la_id,
398: p_object_version_number => p_object_version_number);

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

415: -- greater than or equal to date_from
416: --
417: if p_date_to is not null then
418: if trunc(p_date_from) > trunc(p_date_to) then
419: hr_utility.set_message(8301,'GHR_38196_TO_DATE_LESSER');
420: hr_utility.raise_error;
421: end if;
422: end if;
423:

Line 420: hr_utility.raise_error;

416: --
417: if p_date_to is not null then
418: if trunc(p_date_from) > trunc(p_date_to) then
419: hr_utility.set_message(8301,'GHR_38196_TO_DATE_LESSER');
420: hr_utility.raise_error;
421: end if;
422: end if;
423:
424:

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

421: end if;
422: end if;
423:
424:
425: hr_utility.set_location('Leaving:'||l_proc,10);
426: --
427: end chk_date_from;
428: --
429: -- ----------------------------------------------------------------------------

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

470: and a.lac_lookup_code = p_lac_lookup_code;
471: --
472: Begin
473: --
474: hr_utility.set_location('Entering:'||l_proc, 5);
475: --
476: l_api_updating := ghr_nla_shd.api_updating
477: (p_noac_la_id => p_noac_la_id,
478: p_object_version_number => p_object_version_number);

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

476: l_api_updating := ghr_nla_shd.api_updating
477: (p_noac_la_id => p_noac_la_id,
478: p_object_version_number => p_object_version_number);
479: --
480: hr_utility.set_location('Entering:'||l_proc, 10);
481: --
482: if (l_api_updating
483: and ( p_nature_of_action_id
484: <> nvl(ghr_nla_shd.g_old_rec.nature_of_action_id,hr_api.g_number)

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

490: --
491: -- check if the combination of action_id and lac_lookup_code already exits
492: --
493: --
494: hr_utility.set_location('Entering:'||l_proc, 15);
495: --
496: open c1;
497: --
498: --

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

495: --
496: open c1;
497: --
498: --
499: hr_utility.set_location('Entering:'||l_proc, 16);
500: --
501: fetch c1 into l_dummy;
502: --
503: hr_utility.set_location('Entering:'||l_proc, 17);

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

499: hr_utility.set_location('Entering:'||l_proc, 16);
500: --
501: fetch c1 into l_dummy;
502: --
503: hr_utility.set_location('Entering:'||l_proc, 17);
504: --
505: if c1%found then
506: --
507: close c1;

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

506: --
507: close c1;
508: --
509: --
510: hr_utility.set_location('Entering:'||l_proc, 18);
511: --
512: -- raise error as the combination already exists
513: --
514: hr_utility.set_message(8301,'GHR_NOAC_LAC_DUPLICATE');

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

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

Line 515: hr_utility.raise_error;

511: --
512: -- raise error as the combination already exists
513: --
514: hr_utility.set_message(8301,'GHR_NOAC_LAC_DUPLICATE');
515: hr_utility.raise_error;
516: end if;
517: --
518: close c1;
519:

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

518: close c1;
519:
520: end if;
521: --
522: hr_utility.set_location('Leaving:'||l_proc,25);
523: --
524: end chk_unique_act_lac_cd;
525: --
526: -- ----------------------------------------------------------------------------

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

558: l_api_updating boolean;
559: --
560: Begin
561: --
562: hr_utility.set_location('Entering:'||l_proc, 5);
563: --
564: l_api_updating := ghr_nla_shd.api_updating
565: (p_noac_la_id => p_noac_la_id,
566: p_object_version_number => p_object_version_number);

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

579: p_effective_date => p_effective_date) then
580: --
581: -- raise error as does not exist as lookup
582: --
583: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
584: hr_utility.raise_error;
585: --
586: end if;
587: --

Line 584: hr_utility.raise_error;

580: --
581: -- raise error as does not exist as lookup
582: --
583: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
584: hr_utility.raise_error;
585: --
586: end if;
587: --
588: end if;

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

586: end if;
587: --
588: end if;
589: --
590: hr_utility.set_location('Leaving:'||l_proc,10);
591: --
592: end chk_lac_lookup_code;
593: --
594: -- ----------------------------------------------------------------------------

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

599: --
600: l_proc varchar2(72) := g_package||'insert_validate';
601: --
602: Begin
603: hr_utility.set_location('Entering:'||l_proc, 5);
604: --
605: -- Set up the CLIENT_INFO
606: --
607: ghr_utility.set_client_info;

Line 607: ghr_utility.set_client_info;

603: hr_utility.set_location('Entering:'||l_proc, 5);
604: --
605: -- Set up the CLIENT_INFO
606: --
607: ghr_utility.set_client_info;
608: --
609: -- Call all supporting business operations
610: --
611: chk_noac_la_id

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

655: p_object_version_number => p_rec.object_version_number);
656: --
657: --
658: --
659: hr_utility.set_location(' Leaving:'||l_proc, 10);
660: End insert_validate;
661: --
662: -- ----------------------------------------------------------------------------
663: -- |---------------------------< update_validate >----------------------------|

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

667: --
668: l_proc varchar2(72) := g_package||'update_validate';
669: --
670: Begin
671: hr_utility.set_location('Entering:'||l_proc, 5);
672: --
673: -- Set up the CLIENT_INFO
674: --
675: ghr_utility.set_client_info;

Line 675: ghr_utility.set_client_info;

671: hr_utility.set_location('Entering:'||l_proc, 5);
672: --
673: -- Set up the CLIENT_INFO
674: --
675: ghr_utility.set_client_info;
676: --
677: -- Call all supporting business operations
678: --
679: chk_noac_la_id

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

723: p_object_version_number => p_rec.object_version_number);
724: --
725: --
726: --
727: hr_utility.set_location(' Leaving:'||l_proc, 10);
728: End update_validate;
729: --
730: -- ----------------------------------------------------------------------------
731: -- |---------------------------< delete_validate >----------------------------|

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

735: --
736: l_proc varchar2(72) := g_package||'delete_validate';
737: --
738: Begin
739: hr_utility.set_location('Entering:'||l_proc, 5);
740: --
741: -- Call all supporting business operations
742: --
743: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

739: hr_utility.set_location('Entering:'||l_proc, 5);
740: --
741: -- Call all supporting business operations
742: --
743: hr_utility.set_location(' Leaving:'||l_proc, 10);
744: End delete_validate;
745: --
746: end ghr_nla_bus;