DBA Data[Home] [Help]

APPS.PER_RCF_BUS dependencies on HR_UTILITY

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

37: l_proc varchar2(72) := g_package||'set_security_group_id';
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error

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

72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --
76: hr_utility.set_location(' Leaving:'|| l_proc, 20);
77: --
78: end set_security_group_id;
79: --
80: -- ---------------------------------------------------------------------------

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

101: l_proc varchar2(72) := g_package||'return_legislation_code';
102: --
103: Begin
104: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error

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

119: -- call to this function. Just return the value in the global
120: -- variable.
121: --
122: l_legislation_code := per_rcf_bus.g_legislation_code;
123: hr_utility.set_location(l_proc, 20);
124: else
125: --
126: -- The ID is different to the last call to this function
127: -- or this is the first call to this function.

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

136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are
143: -- available for the next call to this function.
144: --

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

145: close csr_leg_code;
146: per_rcf_bus.g_rec_activity_for_id := p_rec_activity_for_id;
147: per_rcf_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
152: --
153: -- ----------------------------------------------------------------------------

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

183: --
184: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
185: --
186: Begin
187: hr_utility.set_location('Entering:'|| l_proc, 10);
188: --
189: -- Only proceed with the validation if a row exists for the current
190: -- record in the HR Schema.
191: --

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

209: ,p_base_table => per_rcf_shd.g_tab_nam
210: );
211: end if;
212: --
213: hr_utility.set_location(' Leaving:'|| l_proc, 40);
214: End chk_non_updateable_args;
215: --
216: -- ----------------------------------------------------------------------------
217: -- |-----------------------< chk_vacancy_id >---------------------------------|

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

263: from per_all_vacancies
264: where vacancy_id = p_vacancy_id;
265: --
266: Begin
267: hr_utility.set_location('Entering:'|| l_proc, 10);
268: --
269: l_api_updating := per_rcf_shd.api_updating(p_rec_activity_for_id,
270: p_object_version_number);
271: --

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

270: p_object_version_number);
271: --
272: -- Check to see if the vacancy id has changed.
273: --
274: hr_utility.set_location(l_proc, 20);
275: if ((l_api_updating
276: and (nvl(per_rcf_shd.g_old_rec.vacancy_id,hr_api.g_number) <>
277: p_vacancy_id))
278: or (NOT l_api_updating)) then

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

278: or (NOT l_api_updating)) then
279: --
280: -- Check to ensure that the vacancy id is not null.
281: --
282: hr_utility.set_location(l_proc, 30);
283: if p_vacancy_id is null then
284: hr_api.mandatory_arg_error
285: (p_api_name => l_proc
286: ,p_argument => 'vacancy_id'

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

291: -- Check that the vacancy id exists in the PER_ALL_VACANCIES table.
292: --
293: open csr_vacancy_id;
294: fetch csr_vacancy_id into l_vacancy_id,l_business_group_id;
295: hr_utility.set_location(l_proc, 40);
296: if csr_vacancy_id%notfound then
297: hr_utility.set_location(l_proc, 41);
298: close csr_vacancy_id;
299: fnd_message.set_name('PER','PER_289469_RCF_INV_VAC_ID');

Line 297: hr_utility.set_location(l_proc, 41);

293: open csr_vacancy_id;
294: fetch csr_vacancy_id into l_vacancy_id,l_business_group_id;
295: hr_utility.set_location(l_proc, 40);
296: if csr_vacancy_id%notfound then
297: hr_utility.set_location(l_proc, 41);
298: close csr_vacancy_id;
299: fnd_message.set_name('PER','PER_289469_RCF_INV_VAC_ID');
300: hr_multi_message.add
301: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID'

Line 308: hr_utility.set_location(l_proc, 50);

304: --
305: -- Check that the business group id is the same as that in the
306: -- PER_ALL_VACANCIES table for this vacancy_id.
307: --
308: hr_utility.set_location(l_proc, 50);
309: if(l_business_group_id <> p_business_group_id) then
310: hr_utility.set_location(l_proc, 51);
311: close csr_vacancy_id;
312: fnd_message.set_name('PER', 'PER_289468_RCF_INV_VAC_BG');

Line 310: hr_utility.set_location(l_proc, 51);

306: -- PER_ALL_VACANCIES table for this vacancy_id.
307: --
308: hr_utility.set_location(l_proc, 50);
309: if(l_business_group_id <> p_business_group_id) then
310: hr_utility.set_location(l_proc, 51);
311: close csr_vacancy_id;
312: fnd_message.set_name('PER', 'PER_289468_RCF_INV_VAC_BG');
313: hr_multi_message.add
314: (p_associated_column1 =>

Line 320: hr_utility.set_location(l_proc, 60);

316: ,p_associated_column2 =>
317: 'PER_RECRUITMENT_ACTIVITY_FOR.BUSINESS_GROUP_ID'
318: );
319: else
320: hr_utility.set_location(l_proc, 60);
321: close csr_vacancy_id;
322: end if;
323: end if;
324: --

Line 326: hr_utility.set_location(' Leaving:'|| l_proc, 70);

322: end if;
323: end if;
324: --
325: end if;
326: hr_utility.set_location(' Leaving:'|| l_proc, 70);
327: --
328: end chk_vacancy_id;
329: --
330: -- ----------------------------------------------------------------------------

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

378: from per_recruitment_activities
379: where recruitment_activity_id = p_rec_activity_id;
380: --
381: Begin
382: hr_utility.set_location('Entering:'|| l_proc, 10);
383: --
384: l_api_updating := per_rcf_shd.api_updating(p_rec_activity_for_id,
385: p_object_version_number);
386: --

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

385: p_object_version_number);
386: --
387: -- Check to see if the recruitment activity id has changed.
388: --
389: hr_utility.set_location(l_proc, 20);
390: if ((l_api_updating
391: and (nvl(per_rcf_shd.g_old_rec.rec_activity_id,hr_api.g_number) <>
392: p_rec_activity_id))
393: or (NOT l_api_updating)) then

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

393: or (NOT l_api_updating)) then
394: --
395: -- Check to ensure that the recruitment_activity_id is not null.
396: --
397: hr_utility.set_location(l_proc, 30);
398: if p_rec_activity_id is null then
399: hr_api.mandatory_arg_error
400: (p_api_name => l_proc
401: ,p_argument => 'rec_activity_id'

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

407: -- PER_RECRUITMENT_ACTIVITIES table.
408: --
409: open csr_rec_activity_id;
410: fetch csr_rec_activity_id into l_rec_activity_id, l_business_group_id;
411: hr_utility.set_location(l_proc, 40);
412: if csr_rec_activity_id%notfound then
413: hr_utility.set_location(l_proc, 41);
414: close csr_rec_activity_id;
415: fnd_message.set_name('PER','PER_289470_RCF_INV_ACT_ID');

Line 413: hr_utility.set_location(l_proc, 41);

409: open csr_rec_activity_id;
410: fetch csr_rec_activity_id into l_rec_activity_id, l_business_group_id;
411: hr_utility.set_location(l_proc, 40);
412: if csr_rec_activity_id%notfound then
413: hr_utility.set_location(l_proc, 41);
414: close csr_rec_activity_id;
415: fnd_message.set_name('PER','PER_289470_RCF_INV_ACT_ID');
416: hr_multi_message.add
417: (p_associated_column1 =>

Line 425: hr_utility.set_location(l_proc, 50);

421: --
422: -- Check that the business group id is the same as that in the
423: -- PER_RECRUITMENT_ACTIVITY_FOR table for this recruitment_activity_id.
424: --
425: hr_utility.set_location(l_proc, 50);
426: if (l_business_group_id <> p_business_group_id) then
427: hr_utility.set_location(l_proc, 51);
428: close csr_rec_activity_id;
429: fnd_message.set_name('PER', 'PER_289471_RCF_INV_ACT_BG');

Line 427: hr_utility.set_location(l_proc, 51);

423: -- PER_RECRUITMENT_ACTIVITY_FOR table for this recruitment_activity_id.
424: --
425: hr_utility.set_location(l_proc, 50);
426: if (l_business_group_id <> p_business_group_id) then
427: hr_utility.set_location(l_proc, 51);
428: close csr_rec_activity_id;
429: fnd_message.set_name('PER', 'PER_289471_RCF_INV_ACT_BG');
430: hr_multi_message.add
431: (p_associated_column1 =>

Line 437: hr_utility.set_location(l_proc, 60);

433: ,p_associated_column2 =>
434: 'PER_RECRUITMENT_ACTIVITY_FOR.BUSINESS_GROUP_ID'
435: );
436: else
437: hr_utility.set_location(l_proc, 60);
438: close csr_rec_activity_id;
439: end if;
440: end if;
441: --

Line 443: hr_utility.set_location(' Leaving:'|| l_proc, 70);

439: end if;
440: end if;
441: --
442: end if;
443: hr_utility.set_location(' Leaving:'|| l_proc, 70);
444: --
445: end chk_rec_activity_id;
446: --
447: --

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

515: where pra.recruitment_activity_id = p_rec_activity_id
516: and pra.recruiting_site_id = irs.recruiting_site_id;
517: --
518: Begin
519: hr_utility.set_location('Entering:'|| l_proc, 10);
520: --
521: if hr_multi_message.no_exclusive_error
522: (p_check_column1 => 'PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID'
523: ,p_check_column2 => 'PER_RECRUITMENT_ACTIVITY_FOR.RECRUITMENT_ACTIVITY_ID'

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

525: open csr_rse;
526: fetch csr_rse into l_internal,l_external;
527: close csr_rse;
528: --
529: hr_utility.set_location(l_proc, 20);
530: if l_internal = 'Y'
531: then
532: hr_utility.set_location(l_proc, 30);
533: open csr_internal;

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

528: --
529: hr_utility.set_location(l_proc, 20);
530: if l_internal = 'Y'
531: then
532: hr_utility.set_location(l_proc, 30);
533: open csr_internal;
534: fetch csr_internal into l_ret;
535: if csr_internal%found
536: then

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

534: fetch csr_internal into l_ret;
535: if csr_internal%found
536: then
537: close csr_internal;
538: hr_utility.set_location(l_proc,40);
539: fnd_message.set_name('PER','IRC_412174_VAC_INT_SITE_EXT');
540: fnd_message.raise_error;
541: end if;
542: close csr_internal;

Line 546: hr_utility.set_location(l_proc, 50);

542: close csr_internal;
543: end if;
544: if l_external = 'Y'
545: then
546: hr_utility.set_location(l_proc, 50);
547: open csr_external;
548: fetch csr_external into l_ret;
549: if csr_external%found
550: then

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

548: fetch csr_external into l_ret;
549: if csr_external%found
550: then
551: close csr_external;
552: hr_utility.set_location(l_proc,60);
553: fnd_message.set_name('PER','IRC_412175_VAC_EXT_SITE_EXT');
554: fnd_message.raise_error;
555: end if;
556: hr_utility.set_location(l_proc,70);

Line 556: hr_utility.set_location(l_proc,70);

552: hr_utility.set_location(l_proc,60);
553: fnd_message.set_name('PER','IRC_412175_VAC_EXT_SITE_EXT');
554: fnd_message.raise_error;
555: end if;
556: hr_utility.set_location(l_proc,70);
557: close csr_external;
558: end if;
559: --
560: hr_utility.set_location('Leaving :' || l_proc,80);

Line 560: hr_utility.set_location('Leaving :' || l_proc,80);

556: hr_utility.set_location(l_proc,70);
557: close csr_external;
558: end if;
559: --
560: hr_utility.set_location('Leaving :' || l_proc,80);
561: --
562: end if;
563: --
564: exception

Line 572: hr_utility.set_location(' Exception :'||l_proc,90);

568: 'per_recruitment_activity_for.VACANCY_ID'
569: ,p_associated_column2 =>
570: 'per_recruitment_activity_for.RECRUITMENT_ACTIVITY_ID'
571: ) then
572: hr_utility.set_location(' Exception :'||l_proc,90);
573: raise;
574: end if;
575: hr_utility.set_location(' Exception :'|| l_proc, 91);
576: --

Line 575: hr_utility.set_location(' Exception :'|| l_proc, 91);

571: ) then
572: hr_utility.set_location(' Exception :'||l_proc,90);
573: raise;
574: end if;
575: hr_utility.set_location(' Exception :'|| l_proc, 91);
576: --
577: end chk_vacancy_rec_activity;
578: --
579: --

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

648: and pra.recruiting_site_id = irs.recruiting_site_id;
649: --
650: Begin
651: --
652: hr_utility.set_location('Entering:'|| l_proc, 10);
653: --
654: if hr_multi_message.no_exclusive_error
655: (p_check_column1 => 'PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID'
656: ,p_check_column2 => 'PER_RECRUITMENT_ACTIVITY_FOR.RECRUITMENT_ACTIVITY_ID'

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

655: (p_check_column1 => 'PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID'
656: ,p_check_column2 => 'PER_RECRUITMENT_ACTIVITY_FOR.RECRUITMENT_ACTIVITY_ID'
657: ) then
658: --
659: hr_utility.set_location(l_proc, 15);
660: --
661: open csr_rse;
662: fetch csr_rse into l_internal,l_external,l_start_date;
663: close csr_rse;

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

661: open csr_rse;
662: fetch csr_rse into l_internal,l_external,l_start_date;
663: close csr_rse;
664: --
665: hr_utility.set_location(l_proc, 20);
666: --
667: if l_internal = 'Y'
668: then
669: --

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

666: --
667: if l_internal = 'Y'
668: then
669: --
670: hr_utility.set_location(l_proc, 25);
671: --
672: open csr_external;
673: fetch csr_external into l_start_date_exists;
674: if csr_external%found

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

673: fetch csr_external into l_start_date_exists;
674: if csr_external%found
675: then
676: --
677: hr_utility.set_location(l_proc, 30);
678: --
679: if l_start_date > l_start_date_exists
680: then
681: --

Line 682: hr_utility.set_location(l_proc, 35);

678: --
679: if l_start_date > l_start_date_exists
680: then
681: --
682: hr_utility.set_location(l_proc, 35);
683: --
684: close csr_external;
685: fnd_message.set_name('PER','IRC_412176_POST_ST_DT_INVALID');
686: fnd_message.raise_error;

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

685: fnd_message.set_name('PER','IRC_412176_POST_ST_DT_INVALID');
686: fnd_message.raise_error;
687: end if;
688: --
689: hr_utility.set_location(l_proc, 40);
690: --
691: end if;
692: --
693: hr_utility.set_location(l_proc, 45);

Line 693: hr_utility.set_location(l_proc, 45);

689: hr_utility.set_location(l_proc, 40);
690: --
691: end if;
692: --
693: hr_utility.set_location(l_proc, 45);
694: --
695: close csr_external;
696: end if;
697: --

Line 698: hr_utility.set_location(l_proc, 50);

694: --
695: close csr_external;
696: end if;
697: --
698: hr_utility.set_location(l_proc, 50);
699: --
700: if l_external = 'Y'
701: then
702: --

Line 703: hr_utility.set_location(l_proc, 55);

699: --
700: if l_external = 'Y'
701: then
702: --
703: hr_utility.set_location(l_proc, 55);
704: --
705: open csr_internal;
706: fetch csr_internal into l_start_date_exists;
707: if csr_internal%found

Line 710: hr_utility.set_location(l_proc, 60);

706: fetch csr_internal into l_start_date_exists;
707: if csr_internal%found
708: then
709: --
710: hr_utility.set_location(l_proc, 60);
711: --
712: if l_start_date < l_start_date_exists
713: then
714: --

Line 715: hr_utility.set_location(l_proc, 65);

711: --
712: if l_start_date < l_start_date_exists
713: then
714: --
715: hr_utility.set_location(l_proc, 65);
716: --
717: close csr_internal;
718: fnd_message.set_name('PER','IRC_412176_POST_ST_DT_INVALID');
719: fnd_message.raise_error;

Line 722: hr_utility.set_location(l_proc, 70);

718: fnd_message.set_name('PER','IRC_412176_POST_ST_DT_INVALID');
719: fnd_message.raise_error;
720: end if;
721: --
722: hr_utility.set_location(l_proc, 70);
723: --
724: end if;
725: --
726: hr_utility.set_location(l_proc, 75);

Line 726: hr_utility.set_location(l_proc, 75);

722: hr_utility.set_location(l_proc, 70);
723: --
724: end if;
725: --
726: hr_utility.set_location(l_proc, 75);
727: --
728: close csr_internal;
729: end if;
730: --

Line 731: hr_utility.set_location(l_proc, 80);

727: --
728: close csr_internal;
729: end if;
730: --
731: hr_utility.set_location(l_proc, 80);
732: --
733: end if;
734: --
735: hr_utility.set_location('Exiting ' || l_proc, 85);

Line 735: hr_utility.set_location('Exiting ' || l_proc, 85);

731: hr_utility.set_location(l_proc, 80);
732: --
733: end if;
734: --
735: hr_utility.set_location('Exiting ' || l_proc, 85);
736: --
737: exception
738: when app_exception.application_exception then
739: if hr_multi_message.exception_add

Line 745: hr_utility.set_location(' Exception :'||l_proc,90);

741: 'per_recruitment_activity_for.VACANCY_ID'
742: ,p_associated_column2 =>
743: 'per_recruitment_activity_for.RECRUITMENT_ACTIVITY_ID'
744: ) then
745: hr_utility.set_location(' Exception :'||l_proc,90);
746: raise;
747: end if;
748: hr_utility.set_location(' Exception :'|| l_proc,95);
749: --

Line 748: hr_utility.set_location(' Exception :'|| l_proc,95);

744: ) then
745: hr_utility.set_location(' Exception :'||l_proc,90);
746: raise;
747: end if;
748: hr_utility.set_location(' Exception :'|| l_proc,95);
749: --
750: end chk_rec_activity_dates;
751: --
752: -- ----------------------------------------------------------------------------

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

758: --
759: l_proc varchar2(72) := g_package||'insert_validate';
760: --
761: Begin
762: hr_utility.set_location('Entering:'||l_proc, 10);
763: --
764: -- Validate Important Attributes
765: --
766: hr_api.validate_bus_grp_id

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

772: -- if Multiple Message detection is enabled and at least
773: -- one error has been found then abort further validation.
774: --
775: hr_multi_message.end_validation_set;
776: hr_utility.set_location(l_proc, 20);
777: --
778: per_rcf_bus.chk_vacancy_id
779: (p_vacancy_id => p_rec.vacancy_id
780: ,p_business_group_id => p_rec.business_group_id

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

780: ,p_business_group_id => p_rec.business_group_id
781: ,p_rec_activity_for_id => p_rec.rec_activity_for_id
782: ,p_object_version_number => p_rec.object_version_number
783: );
784: hr_utility.set_location(l_proc, 30);
785: --
786: per_rcf_bus.chk_rec_activity_id
787: (p_rec_activity_id => p_rec.rec_activity_id
788: ,p_business_group_id => p_rec.business_group_id

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

788: ,p_business_group_id => p_rec.business_group_id
789: ,p_rec_activity_for_id => p_rec.rec_activity_for_id
790: ,p_object_version_number => p_rec.object_version_number
791: );
792: hr_utility.set_location(l_proc, 40);
793: --
794: per_rcf_bus.chk_vacancy_rec_activity
795: (p_vacancy_id => p_rec.vacancy_id
796: ,p_rec_activity_id => p_rec.rec_activity_id

Line 799: hr_utility.set_location(l_proc, 60);

795: (p_vacancy_id => p_rec.vacancy_id
796: ,p_rec_activity_id => p_rec.rec_activity_id
797: );
798: --
799: hr_utility.set_location(l_proc, 60);
800: per_rcf_bus.chk_rec_activity_dates
801: (
802: p_vacancy_id => p_rec.vacancy_id
803: ,p_rec_activity_id => p_rec.rec_activity_id

Line 806: hr_utility.set_location(' Leaving:'||l_proc, 80);

802: p_vacancy_id => p_rec.vacancy_id
803: ,p_rec_activity_id => p_rec.rec_activity_id
804: );
805: --
806: hr_utility.set_location(' Leaving:'||l_proc, 80);
807: End insert_validate;
808: --
809: -- ----------------------------------------------------------------------------
810: -- |---------------------------< update_validate >----------------------------|

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

815: --
816: l_proc varchar2(72) := g_package||'update_validate';
817: --
818: Begin
819: hr_utility.set_location('Entering:'||l_proc, 10);
820: --
821: -- Call all supporting business operations
822: --
823: hr_utility.set_location(l_proc, 20);

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

819: hr_utility.set_location('Entering:'||l_proc, 10);
820: --
821: -- Call all supporting business operations
822: --
823: hr_utility.set_location(l_proc, 20);
824: --
825: per_rcf_bus.chk_non_updateable_args
826: (p_rec => p_rec
827: );

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

824: --
825: per_rcf_bus.chk_non_updateable_args
826: (p_rec => p_rec
827: );
828: hr_utility.set_location(l_proc, 30);
829: --
830: per_rcf_bus.chk_vacancy_id
831: (p_vacancy_id => p_rec.vacancy_id
832: ,p_business_group_id => per_rcf_shd.g_old_rec.business_group_id

Line 836: hr_utility.set_location(l_proc, 50);

832: ,p_business_group_id => per_rcf_shd.g_old_rec.business_group_id
833: ,p_rec_activity_for_id => p_rec.rec_activity_for_id
834: ,p_object_version_number => p_rec.object_version_number
835: );
836: hr_utility.set_location(l_proc, 50);
837: --
838: per_rcf_bus.chk_rec_activity_id
839: (p_rec_activity_id => p_rec.rec_activity_id
840: ,p_business_group_id => per_rcf_shd.g_old_rec.business_group_id

Line 844: hr_utility.set_location(l_proc, 60);

840: ,p_business_group_id => per_rcf_shd.g_old_rec.business_group_id
841: ,p_rec_activity_for_id => p_rec.rec_activity_for_id
842: ,p_object_version_number => p_rec.object_version_number
843: );
844: hr_utility.set_location(l_proc, 60);
845: --
846: per_rcf_bus.chk_vacancy_rec_activity
847: (p_vacancy_id => p_rec.vacancy_id
848: ,p_rec_activity_id => p_rec.rec_activity_id

Line 851: hr_utility.set_location(l_proc, 70);

847: (p_vacancy_id => p_rec.vacancy_id
848: ,p_rec_activity_id => p_rec.rec_activity_id
849: );
850: --
851: hr_utility.set_location(l_proc, 70);
852: per_rcf_bus.chk_rec_activity_dates
853: (
854: p_vacancy_id => p_rec.vacancy_id
855: ,p_rec_activity_id => p_rec.rec_activity_id

Line 858: hr_utility.set_location(' Leaving:'||l_proc, 80);

854: p_vacancy_id => p_rec.vacancy_id
855: ,p_rec_activity_id => p_rec.rec_activity_id
856: );
857: --
858: hr_utility.set_location(' Leaving:'||l_proc, 80);
859: End update_validate;
860: --
861: -- ----------------------------------------------------------------------------
862: -- |---------------------------< delete_validate >----------------------------|

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

867: --
868: l_proc varchar2(72) := g_package||'delete_validate';
869: --
870: Begin
871: hr_utility.set_location('Entering:'||l_proc, 5);
872: --
873: -- Call all supporting business operations
874: --
875: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

871: hr_utility.set_location('Entering:'||l_proc, 5);
872: --
873: -- Call all supporting business operations
874: --
875: hr_utility.set_location(' Leaving:'||l_proc, 10);
876: End delete_validate;
877: --
878: end per_rcf_bus;