DBA Data[Home] [Help]

APPS.GHR_NRE_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_nre_shd.api_updating
47: (p_noac_remark_id => p_noac_remark_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_remark_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.remark_id = p_remark_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := ghr_nre_shd.api_updating
119: (p_noac_remark_id => p_noac_remark_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_remark_id;
150: --
151: -- ----------------------------------------------------------------------------

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

187: where a.nature_of_action_id = p_nature_of_action_id;
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := ghr_nre_shd.api_updating
194: (p_noac_remark_id => p_noac_remark_id,
195: p_object_version_number => p_object_version_number);

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

218: close c1;
219: --
220: end if;
221: --
222: hr_utility.set_location('Leaving:'||l_proc,10);
223: --
224: End chk_nature_of_action_id;
225: --
226: -- ----------------------------------------------------------------------------

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

258: l_api_updating boolean;
259: --
260: Begin
261: --
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: l_api_updating := ghr_nre_shd.api_updating
265: (p_noac_remark_id => p_noac_remark_id,
266: p_object_version_number => p_object_version_number);

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

279: p_effective_date => p_effective_date) then
280: --
281: -- raise error as does not exist as lookup
282: --
283: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
284: hr_utility.raise_error;
285: --
286: end if;
287: --

Line 284: hr_utility.raise_error;

280: --
281: -- raise error as does not exist as lookup
282: --
283: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
284: hr_utility.raise_error;
285: --
286: end if;
287: --
288: end if;

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

286: end if;
287: --
288: end if;
289: --
290: hr_utility.set_location('Leaving:'||l_proc,10);
291: --
292: end chk_enabled_flag;
293: --
294: -- ----------------------------------------------------------------------------

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

326: l_api_updating boolean;
327: --
328: Begin
329: --
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: l_api_updating := ghr_nre_shd.api_updating
333: (p_noac_remark_id => p_noac_remark_id,
334: p_object_version_number => p_object_version_number);

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

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

Line 352: hr_utility.raise_error;

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

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

354: end if;
355: --
356: end if;
357: --
358: hr_utility.set_location('Leaving:'||l_proc,10);
359: --
360: end chk_required_flag;
361: --
362: -- ----------------------------------------------------------------------------

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

397: l_api_updating boolean;
398: --
399: Begin
400: --
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: --
403: l_api_updating := ghr_nre_shd.api_updating
404: (p_noac_remark_id => p_noac_remark_id,
405: p_object_version_number => p_object_version_number);

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

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

Line 427: hr_utility.raise_error;

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

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

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

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

478: and a.remark_id = p_remark_id;
479: --
480: Begin
481: --
482: hr_utility.set_location('Entering:'||l_proc, 5);
483: --
484: l_api_updating := ghr_nre_shd.api_updating
485: (p_noac_remark_id => p_noac_remark_id,
486: p_object_version_number => p_object_version_number);

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

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

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

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

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

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

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

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

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

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

Line 522: hr_utility.set_message(8301,'GHR_NOAC_REM_DUPLICATE');

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

Line 523: hr_utility.raise_error;

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

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

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

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

539: --
540: l_proc varchar2(72) := g_package||'insert_validate';
541: --
542: Begin
543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: -- Set up the CLIENT_INFO
546: --
547: ghr_utility.set_client_info;

Line 547: ghr_utility.set_client_info;

543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: -- Set up the CLIENT_INFO
546: --
547: ghr_utility.set_client_info;
548: --
549: -- Call all supporting business operations
550: --
551: chk_noac_remark_id

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

585: p_nature_of_action_id => p_rec.nature_of_action_id,
586: p_remark_id => p_rec.remark_id,
587: p_object_version_number => p_rec.object_version_number);
588: --
589: hr_utility.set_location(' Leaving:'||l_proc, 10);
590: End insert_validate;
591: --
592: -- ----------------------------------------------------------------------------
593: -- |---------------------------< update_validate >----------------------------|

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

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

Line 605: ghr_utility.set_client_info;

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

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

645: p_object_version_number => p_rec.object_version_number);
646: --
647: --
648: --
649: hr_utility.set_location(' Leaving:'||l_proc, 10);
650: End update_validate;
651: --
652: -- ----------------------------------------------------------------------------
653: -- |---------------------------< delete_validate >----------------------------|

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

657: --
658: l_proc varchar2(72) := g_package||'delete_validate';
659: --
660: Begin
661: hr_utility.set_location('Entering:'||l_proc, 5);
662: --
663: -- Call all supporting business operations
664: --
665: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

661: hr_utility.set_location('Entering:'||l_proc, 5);
662: --
663: -- Call all supporting business operations
664: --
665: hr_utility.set_location(' Leaving:'||l_proc, 10);
666: End delete_validate;
667: --
668: end ghr_nre_bus;