DBA Data[Home] [Help]

APPS.GHR_NRE_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_remark_id';
45: hr_utility.set_location('Entering:'||l_proc, 5);
46: --
47: l_api_updating := ghr_nre_shd.api_updating
48: (p_noac_remark_id => p_noac_remark_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_remark_id;
76: --
77: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

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

Line 286: hr_utility.raise_error;

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

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

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

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

329: --
330: Begin
331: --
332: l_proc := g_package||'chk_required_flag';
333: hr_utility.set_location('Entering:'||l_proc, 5);
334: --
335: l_api_updating := ghr_nre_shd.api_updating
336: (p_noac_remark_id => p_noac_remark_id,
337: p_object_version_number => p_object_version_number);

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

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

Line 355: hr_utility.raise_error;

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

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

357: end if;
358: --
359: end if;
360: --
361: hr_utility.set_location('Leaving:'||l_proc,10);
362: --
363: end chk_required_flag;
364: --
365: -- ----------------------------------------------------------------------------

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

401: --
402: Begin
403: --
404: l_proc := g_package||'chk_date_from';
405: hr_utility.set_location('Entering:'||l_proc, 5);
406: --
407: l_api_updating := ghr_nre_shd.api_updating
408: (p_noac_remark_id => p_noac_remark_id,
409: p_object_version_number => p_object_version_number);

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

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

Line 431: hr_utility.raise_error;

427: --
428: if p_date_to is not null then
429: if trunc(p_date_from) > trunc(p_date_to) then
430: hr_utility.set_message(8301,'GHR_38196_TO_DATE_LESSER');
431: hr_utility.raise_error;
432: end if;
433: end if;
434:
435:

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

432: end if;
433: end if;
434:
435:
436: hr_utility.set_location('Leaving:'||l_proc,10);
437: --
438: end chk_date_from;
439: --
440: --

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

483: --
484: Begin
485: --
486: l_proc := g_package||'chk_unique_act_rem_id';
487: hr_utility.set_location('Entering:'||l_proc, 5);
488: --
489: l_api_updating := ghr_nre_shd.api_updating
490: (p_noac_remark_id => p_noac_remark_id,
491: p_object_version_number => p_object_version_number);

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

489: l_api_updating := ghr_nre_shd.api_updating
490: (p_noac_remark_id => p_noac_remark_id,
491: p_object_version_number => p_object_version_number);
492: --
493: hr_utility.set_location('Entering:'||l_proc, 10);
494: --
495: if (l_api_updating
496: and ( p_nature_of_action_id
497: <> nvl(ghr_nre_shd.g_old_rec.nature_of_action_id,hr_api.g_number)

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

503: --
504: -- check if the combination of action_id and remark_id already exits
505: --
506: --
507: hr_utility.set_location('Entering:'||l_proc, 15);
508: --
509: open c1;
510: --
511: --

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

508: --
509: open c1;
510: --
511: --
512: hr_utility.set_location('Entering:'||l_proc, 16);
513: --
514: fetch c1 into l_dummy;
515: --
516: hr_utility.set_location('Entering:'||l_proc, 17);

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

512: hr_utility.set_location('Entering:'||l_proc, 16);
513: --
514: fetch c1 into l_dummy;
515: --
516: hr_utility.set_location('Entering:'||l_proc, 17);
517: --
518: if c1%found then
519: --
520: close c1;

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

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

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

523: hr_utility.set_location('Entering:'||l_proc, 18);
524: --
525: -- raise error as the combination already exists
526: --
527: hr_utility.set_message(8301,'GHR_NOAC_REM_DUPLICATE');
528: hr_utility.raise_error;
529: end if;
530: --
531: close c1;

Line 528: hr_utility.raise_error;

524: --
525: -- raise error as the combination already exists
526: --
527: hr_utility.set_message(8301,'GHR_NOAC_REM_DUPLICATE');
528: hr_utility.raise_error;
529: end if;
530: --
531: close c1;
532:

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

531: close c1;
532:
533: end if;
534: --
535: hr_utility.set_location('Leaving:'||l_proc,25);
536: --
537: end chk_unique_act_rem_id;
538: --
539: -- ----------------------------------------------------------------------------

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

545: l_proc varchar2(72);
546: --
547: Begin
548: l_proc := g_package||'insert_validate';
549: hr_utility.set_location('Entering:'||l_proc, 5);
550: --
551: -- Set up the CLIENT_INFO
552: --
553: ghr_utility.set_client_info;

Line 553: ghr_utility.set_client_info;

549: hr_utility.set_location('Entering:'||l_proc, 5);
550: --
551: -- Set up the CLIENT_INFO
552: --
553: ghr_utility.set_client_info;
554: --
555: -- Call all supporting business operations
556: --
557: chk_noac_remark_id

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

591: p_nature_of_action_id => p_rec.nature_of_action_id,
592: p_remark_id => p_rec.remark_id,
593: p_object_version_number => p_rec.object_version_number);
594: --
595: hr_utility.set_location(' Leaving:'||l_proc, 10);
596: End insert_validate;
597: --
598: -- ----------------------------------------------------------------------------
599: -- |---------------------------< update_validate >----------------------------|

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

604: l_proc varchar2(72);
605: --
606: Begin
607: l_proc := g_package||'update_validate';
608: hr_utility.set_location('Entering:'||l_proc, 5);
609: --
610: -- Set up the CLIENT_INFO
611: --
612: ghr_utility.set_client_info;

Line 612: ghr_utility.set_client_info;

608: hr_utility.set_location('Entering:'||l_proc, 5);
609: --
610: -- Set up the CLIENT_INFO
611: --
612: ghr_utility.set_client_info;
613: --
614: -- Call all supporting business operations
615: --
616: chk_noac_remark_id

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

652: p_object_version_number => p_rec.object_version_number);
653: --
654: --
655: --
656: hr_utility.set_location(' Leaving:'||l_proc, 10);
657: End update_validate;
658: --
659: -- ----------------------------------------------------------------------------
660: -- |---------------------------< delete_validate >----------------------------|

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

665: l_proc varchar2(72);
666: --
667: Begin
668: l_proc := g_package||'delete_validate';
669: hr_utility.set_location('Entering:'||l_proc, 5);
670: --
671: -- Call all supporting business operations
672: --
673: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

669: hr_utility.set_location('Entering:'||l_proc, 5);
670: --
671: -- Call all supporting business operations
672: --
673: hr_utility.set_location(' Leaving:'||l_proc, 10);
674: End delete_validate;
675: --
676: end ghr_nre_bus;