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

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

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

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

67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------

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

96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error

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

114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := per_evt_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.

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

131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --

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

140: close csr_leg_code;
141: per_evt_bus.g_event_id := p_event_id;
142: per_evt_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ----------------------------------------------------------------------------

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

179: --
180: l_proc varchar2(72) := g_package || 'chk_df';
181: --
182: begin
183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.event_id is not null) and (
186: nvl(per_evt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

278: ,p_attribute20_value => p_rec.attribute20
279: );
280: end if;
281: --
282: hr_utility.set_location(' Leaving:'||l_proc,20);
283: end chk_df;
284: --
285: -- ----------------------------------------------------------------------------
286: -- |-----------------------< chk_non_updateable_args >------------------------|

Line 380: hr_utility.set_location('Entering:'|| l_proc, 20);

376: --
377: l_proc varchar2(72):=g_package||'chk_type';
378: --
379: begin
380: hr_utility.set_location('Entering:'|| l_proc, 20);
381: --
382: -- Check mandatory parameters have been set
383: --
384: hr_api.mandatory_arg_error

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

387: p_argument => 'type',
388: p_argument_value => p_type
389: );
390:
391: hr_utility.set_location('Leaving:'|| l_proc, 20);
392: --
393: end chk_event_type;
394:
395: --

Line 436: hr_utility.set_location('Entering:'|| l_proc, 1);

432: l_time_start date;
433: l_time_end date;
434: --
435: begin
436: hr_utility.set_location('Entering:'|| l_proc, 1);
437: --
438: -- Check mandatory parameters have been set
439: --
440: hr_api.mandatory_arg_error

Line 453: hr_utility.set_message(800, 'HR_289319_START_TIME_INVALID');

449: l_time_start := to_date(p_time_start, 'HH24:MI');
450: Exception
451: WHEN OTHERS THEN
452: -- raise an error with message "The Start time is not valid"
453: hr_utility.set_message(800, 'HR_289319_START_TIME_INVALID');
454: hr_utility.raise_error;
455: end;
456: end if;
457:

Line 454: hr_utility.raise_error;

450: Exception
451: WHEN OTHERS THEN
452: -- raise an error with message "The Start time is not valid"
453: hr_utility.set_message(800, 'HR_289319_START_TIME_INVALID');
454: hr_utility.raise_error;
455: end;
456: end if;
457:
458: if (p_time_end IS NOT NULL) then

Line 464: hr_utility.set_message(800, 'HR_289320_END_TIME_INVALID');

460: l_time_end := to_date(p_time_end, 'HH24:MI');
461: Exception
462: WHEN OTHERS THEN
463: -- raise an error with message "The End date is not valid"
464: hr_utility.set_message(800, 'HR_289320_END_TIME_INVALID');
465: hr_utility.raise_error;
466: end;
467: end if;
468:

Line 465: hr_utility.raise_error;

461: Exception
462: WHEN OTHERS THEN
463: -- raise an error with message "The End date is not valid"
464: hr_utility.set_message(800, 'HR_289320_END_TIME_INVALID');
465: hr_utility.raise_error;
466: end;
467: end if;
468:
469: if (p_date_end is not null) then

Line 476: hr_utility.set_message(800, 'HR_289321_START_DATE_AFTER_END');

472: or ( (p_date_end = p_date_start)
473: and (nvl(l_time_end, hr_api.g_eot) < nvl(l_time_start, hr_api.g_sot)))
474: ) then
475: -- raise an error with message "The Start date must be before the End date."
476: hr_utility.set_message(800, 'HR_289321_START_DATE_AFTER_END');
477: hr_utility.raise_error;
478: end if;
479: end if;
480:

Line 477: hr_utility.raise_error;

473: and (nvl(l_time_end, hr_api.g_eot) < nvl(l_time_start, hr_api.g_sot)))
474: ) then
475: -- raise an error with message "The Start date must be before the End date."
476: hr_utility.set_message(800, 'HR_289321_START_DATE_AFTER_END');
477: hr_utility.raise_error;
478: end if;
479: end if;
480:
481: hr_utility.set_location('Leaving:'|| l_proc, 10);

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

477: hr_utility.raise_error;
478: end if;
479: end if;
480:
481: hr_utility.set_location('Leaving:'|| l_proc, 10);
482: --
483: end chk_event_times;
484:
485: --

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

515: --
516: l_proc varchar2(72) := g_package||'chk_emp_apl';
517: --
518: begin
519: hr_utility.set_location('Entering:'|| l_proc, 10);
520: --
521: -- Whe updating only proceed with validation if :
522: -- a) The g_old_rec is current and
523: -- b) The value for employee/applicant flag has changed

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

526: or nvl(per_evt_shd.g_old_rec.emp_or_apl, hr_api.g_varchar2)
527: <> nvl(p_emp_or_apl, hr_api.g_varchar2)
528: ) then
529: --
530: hr_utility.set_location(l_proc, 20);
531: --
532: -- If employee/applicant is not null then
533: -- check if the value exists in hr_lookups
534: -- where the lookup_type = 'EMP_APL'

Line 543: hr_utility.set_message(800, 'HR_289310_EMP_APL_NOT_FOUND');

539: ,p_lookup_type => 'EMP_APL'
540: ,p_lookup_code => p_emp_or_apl
541: ) then
542: -- error invalid employee/applicant flag
543: hr_utility.set_message(800, 'HR_289310_EMP_APL_NOT_FOUND');
544: hr_utility.raise_error;
545: end if;
546: hr_utility.set_location(l_proc, 30);
547: end if;

Line 544: hr_utility.raise_error;

540: ,p_lookup_code => p_emp_or_apl
541: ) then
542: -- error invalid employee/applicant flag
543: hr_utility.set_message(800, 'HR_289310_EMP_APL_NOT_FOUND');
544: hr_utility.raise_error;
545: end if;
546: hr_utility.set_location(l_proc, 30);
547: end if;
548: end if;

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

542: -- error invalid employee/applicant flag
543: hr_utility.set_message(800, 'HR_289310_EMP_APL_NOT_FOUND');
544: hr_utility.raise_error;
545: end if;
546: hr_utility.set_location(l_proc, 30);
547: end if;
548: end if;
549: hr_utility.set_location('Leaving: '|| l_proc, 40);
550: end chk_emp_or_apl;

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

545: end if;
546: hr_utility.set_location(l_proc, 30);
547: end if;
548: end if;
549: hr_utility.set_location('Leaving: '|| l_proc, 40);
550: end chk_emp_or_apl;
551:
552: --
553: --------------------------------------------------------------------------------

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

583: --
584: l_proc varchar2(72) := g_package||'chk_event_or_interview';
585:
586: begin
587: hr_utility.set_location('Entering:'|| l_proc, 10);
588: --
589: -- Only proceed with validation if :
590: -- a) The current g_old_rec is current and
591: -- b) The value for event_or_interview has changed

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

593: if (per_evt_shd.g_old_rec.event_id is null
594: or nvl(per_evt_shd.g_old_rec.event_or_interview, hr_api.g_varchar2)
595: <> nvl(p_event_or_interview, hr_api.g_varchar2) ) then
596: --
597: hr_utility.set_location(l_proc, 20);
598: --
599: -- If event_or_interview is not null then
600: -- check if the value exists in hr_lookups
601: -- where the lookup_type = 'EVENT_INTERVIEW'

Line 611: hr_utility.set_message(800, 'HR_289311_EVT_INT_NOT_FOUND');

607: ,p_lookup_type => 'EVENT_INTERVIEW'
608: ,p_lookup_code => p_event_or_interview
609: ) then
610: -- error invalid event/interview
611: hr_utility.set_message(800, 'HR_289311_EVT_INT_NOT_FOUND');
612: hr_utility.raise_error;
613: end if;
614: hr_utility.set_location(l_proc, 30);
615: end if;

Line 612: hr_utility.raise_error;

608: ,p_lookup_code => p_event_or_interview
609: ) then
610: -- error invalid event/interview
611: hr_utility.set_message(800, 'HR_289311_EVT_INT_NOT_FOUND');
612: hr_utility.raise_error;
613: end if;
614: hr_utility.set_location(l_proc, 30);
615: end if;
616: end if;

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

610: -- error invalid event/interview
611: hr_utility.set_message(800, 'HR_289311_EVT_INT_NOT_FOUND');
612: hr_utility.raise_error;
613: end if;
614: hr_utility.set_location(l_proc, 30);
615: end if;
616: end if;
617: hr_utility.set_location('Leaving: '|| l_proc, 40);
618: end chk_event_or_interview;

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

613: end if;
614: hr_utility.set_location(l_proc, 30);
615: end if;
616: end if;
617: hr_utility.set_location('Leaving: '|| l_proc, 40);
618: end chk_event_or_interview;
619:
620: --
621: -- ---------------------------------------------------------------------------

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

671: or (ppf.current_npw_flag = 'Y' and
672: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'));
673: --
674: begin
675: hr_utility.set_location('Entering:'|| l_proc, 10);
676: --
677: hr_utility.set_location('event_id : ' || per_evt_shd.g_old_rec.event_id, 11);
678: hr_utility.set_location('old person id : ' || per_evt_shd.g_old_rec.internal_contact_person_id, 12);
679: hr_utility.set_location('new person id : ' || p_internal_contact_person_id, 13);

Line 677: hr_utility.set_location('event_id : ' || per_evt_shd.g_old_rec.event_id, 11);

673: --
674: begin
675: hr_utility.set_location('Entering:'|| l_proc, 10);
676: --
677: hr_utility.set_location('event_id : ' || per_evt_shd.g_old_rec.event_id, 11);
678: hr_utility.set_location('old person id : ' || per_evt_shd.g_old_rec.internal_contact_person_id, 12);
679: hr_utility.set_location('new person id : ' || p_internal_contact_person_id, 13);
680:
681: if ((per_evt_shd.g_old_rec.event_id is null and p_internal_contact_person_id is not null)

Line 678: hr_utility.set_location('old person id : ' || per_evt_shd.g_old_rec.internal_contact_person_id, 12);

674: begin
675: hr_utility.set_location('Entering:'|| l_proc, 10);
676: --
677: hr_utility.set_location('event_id : ' || per_evt_shd.g_old_rec.event_id, 11);
678: hr_utility.set_location('old person id : ' || per_evt_shd.g_old_rec.internal_contact_person_id, 12);
679: hr_utility.set_location('new person id : ' || p_internal_contact_person_id, 13);
680:
681: if ((per_evt_shd.g_old_rec.event_id is null and p_internal_contact_person_id is not null)
682: or (per_evt_shd.g_old_rec.event_id is not null

Line 679: hr_utility.set_location('new person id : ' || p_internal_contact_person_id, 13);

675: hr_utility.set_location('Entering:'|| l_proc, 10);
676: --
677: hr_utility.set_location('event_id : ' || per_evt_shd.g_old_rec.event_id, 11);
678: hr_utility.set_location('old person id : ' || per_evt_shd.g_old_rec.internal_contact_person_id, 12);
679: hr_utility.set_location('new person id : ' || p_internal_contact_person_id, 13);
680:
681: if ((per_evt_shd.g_old_rec.event_id is null and p_internal_contact_person_id is not null)
682: or (per_evt_shd.g_old_rec.event_id is not null
683: and nvl(per_evt_shd.g_old_rec.internal_contact_person_id, hr_api.g_number)

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

682: or (per_evt_shd.g_old_rec.event_id is not null
683: and nvl(per_evt_shd.g_old_rec.internal_contact_person_id, hr_api.g_number)
684: <> nvl(p_internal_contact_person_id, hr_api.g_number))) then
685: --
686: hr_utility.set_location(l_proc, 20);
687: --
688: -- Check that the Internal Contact Person ID is linked to a
689: -- valid person on PER_PEOPLE_F
690: --

Line 696: hr_utility.set_message(800, 'HR_51011_PER_NOT_EXIST_DATE');

692: fetch csr_valid_pers into l_business_group_id;
693: if csr_valid_pers%notfound then
694: --
695: close csr_valid_pers;
696: hr_utility.set_message(800, 'HR_51011_PER_NOT_EXIST_DATE');
697: hr_utility.raise_error;
698: --
699: end if;
700: close csr_valid_pers;

Line 697: hr_utility.raise_error;

693: if csr_valid_pers%notfound then
694: --
695: close csr_valid_pers;
696: hr_utility.set_message(800, 'HR_51011_PER_NOT_EXIST_DATE');
697: hr_utility.raise_error;
698: --
699: end if;
700: close csr_valid_pers;
701: hr_utility.set_location(l_proc, 30);

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

697: hr_utility.raise_error;
698: --
699: end if;
700: close csr_valid_pers;
701: hr_utility.set_location(l_proc, 30);
702: --
703: -- Check that the business group of the person is the same as the
704: -- business group of the event, or that cross business group profile
705: -- option is enabled.

Line 711: hr_utility.set_message(800, 'HR_289312_PERSON_NOT_IN_BG');

707:
708: if nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'N' then
709: if (p_business_group_id <> l_business_group_id) then
710: --
711: hr_utility.set_message(800, 'HR_289312_PERSON_NOT_IN_BG');
712: hr_utility.raise_error;
713: --
714: end if;
715: end if;

Line 712: hr_utility.raise_error;

708: if nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'N' then
709: if (p_business_group_id <> l_business_group_id) then
710: --
711: hr_utility.set_message(800, 'HR_289312_PERSON_NOT_IN_BG');
712: hr_utility.raise_error;
713: --
714: end if;
715: end if;
716: --

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

715: end if;
716: --
717: end if;
718: --
719: hr_utility.set_location(' Leaving:'|| l_proc, 40);
720: end chk_internal_contact_person_id;
721:
722: --
723: -- ---------------------------------------------------------------------------

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

767: where hou.organization_id = p_organization_run_by_id
768: and p_date_start between date_from and nvl(date_to, hr_api.g_eot);
769: --
770: begin
771: hr_utility.set_location('Entering:'|| l_proc, 10);
772: --
773: if ((per_evt_shd.g_old_rec.event_id is null and p_organization_run_by_id is not null)
774: or (per_evt_shd.g_old_rec.event_id is not null
775: and nvl(per_evt_shd.g_old_rec.organization_run_by_id, hr_api.g_number)

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

774: or (per_evt_shd.g_old_rec.event_id is not null
775: and nvl(per_evt_shd.g_old_rec.organization_run_by_id, hr_api.g_number)
776: <> nvl(p_organization_run_by_id, hr_api.g_number))) then
777: --
778: hr_utility.set_location(l_proc, 20);
779: --
780: -- Check that the Organization Run By is linked to a
781: -- valid organization on hr_organiztion_units
782: --

Line 788: hr_utility.set_message(800, 'HR_289313_NO_SUCH_ORGANIZATION');

784: fetch csr_valid_org into l_business_group_id;
785: if csr_valid_org%notfound then
786: --
787: close csr_valid_org;
788: hr_utility.set_message(800, 'HR_289313_NO_SUCH_ORGANIZATION');
789: hr_utility.raise_error;
790: --
791: end if;
792: close csr_valid_org;

Line 789: hr_utility.raise_error;

785: if csr_valid_org%notfound then
786: --
787: close csr_valid_org;
788: hr_utility.set_message(800, 'HR_289313_NO_SUCH_ORGANIZATION');
789: hr_utility.raise_error;
790: --
791: end if;
792: close csr_valid_org;
793: hr_utility.set_location(l_proc, 30);

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

789: hr_utility.raise_error;
790: --
791: end if;
792: close csr_valid_org;
793: hr_utility.set_location(l_proc, 30);
794: --
795: -- Check that the business group of the organization is the same as the
796: -- business group of the event or the organization is global.
797: --

Line 801: hr_utility.set_message(800, 'HR_289314_ORG_NOT_IN_THIS_BG');

797: --
798: if nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'N' then
799: if (p_business_group_id <> nvl(l_business_group_id, p_business_group_id)) then
800: --
801: hr_utility.set_message(800, 'HR_289314_ORG_NOT_IN_THIS_BG');
802: hr_utility.raise_error;
803: --
804: end if;
805: end if;

Line 802: hr_utility.raise_error;

798: if nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'N' then
799: if (p_business_group_id <> nvl(l_business_group_id, p_business_group_id)) then
800: --
801: hr_utility.set_message(800, 'HR_289314_ORG_NOT_IN_THIS_BG');
802: hr_utility.raise_error;
803: --
804: end if;
805: end if;
806: --

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

805: end if;
806: --
807: end if;
808: --
809: hr_utility.set_location(' Leaving:'|| l_proc, 40);
810: end chk_organization_run_by_id;
811:
812: --
813: -- ----------------------------------------------------------------------------

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

851: where asg.assignment_id = v_assignment_id
852: and p_date_start between effective_start_date and effective_end_date;
853: --
854: Begin
855: hr_utility.set_location('Entering:'||l_proc, 10);
856: --
857: -- Only proceed with validation if :
858: -- a) The g_old_rec is current and
859: -- b) The value for assignment has changed

Line 874: hr_utility.set_message(800, 'HR_289315_NO_SUCH_ASSIGNMENT');

870: open c_valid_asg(l_assignment_id);
871: fetch c_valid_asg into l_business_group_id;
872: if c_valid_asg%notfound then
873: close c_valid_asg;
874: hr_utility.set_message(800, 'HR_289315_NO_SUCH_ASSIGNMENT');
875: hr_utility.raise_error;
876: end if;
877: close c_valid_asg;
878: hr_utility.set_location(l_proc, 20);

Line 875: hr_utility.raise_error;

871: fetch c_valid_asg into l_business_group_id;
872: if c_valid_asg%notfound then
873: close c_valid_asg;
874: hr_utility.set_message(800, 'HR_289315_NO_SUCH_ASSIGNMENT');
875: hr_utility.raise_error;
876: end if;
877: close c_valid_asg;
878: hr_utility.set_location(l_proc, 20);
879: --

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

874: hr_utility.set_message(800, 'HR_289315_NO_SUCH_ASSIGNMENT');
875: hr_utility.raise_error;
876: end if;
877: close c_valid_asg;
878: hr_utility.set_location(l_proc, 20);
879: --
880: end if;
881: --
882: if (p_business_group_id <> nvl(l_business_group_id, p_business_group_id)) then

Line 884: hr_utility.set_message(800, 'HR_289316_ASG_NOT_IN_THIS_BG');

880: end if;
881: --
882: if (p_business_group_id <> nvl(l_business_group_id, p_business_group_id)) then
883: --
884: hr_utility.set_message(800, 'HR_289316_ASG_NOT_IN_THIS_BG');
885: hr_utility.raise_error;
886: --
887: end if;
888:

Line 885: hr_utility.raise_error;

881: --
882: if (p_business_group_id <> nvl(l_business_group_id, p_business_group_id)) then
883: --
884: hr_utility.set_message(800, 'HR_289316_ASG_NOT_IN_THIS_BG');
885: hr_utility.raise_error;
886: --
887: end if;
888:
889: hr_utility.set_location(' Leaving:'||l_proc, 30);

Line 889: hr_utility.set_location(' Leaving:'||l_proc, 30);

885: hr_utility.raise_error;
886: --
887: end if;
888:
889: hr_utility.set_location(' Leaving:'||l_proc, 30);
890: --
891: End chk_assignment_id;
892:
893: --

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

936: from hr_locations_all hln
937: where hln.location_id = p_location_id;
938: --
939: begin
940: hr_utility.set_location('Entering:'|| l_proc, 10);
941: --
942: if p_location_id is not null and p_location_id <> hr_api.g_number then
943: hr_utility.set_location(l_proc, 20);
944: --

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

939: begin
940: hr_utility.set_location('Entering:'|| l_proc, 10);
941: --
942: if p_location_id is not null and p_location_id <> hr_api.g_number then
943: hr_utility.set_location(l_proc, 20);
944: --
945: -- Check that the Location ID is linked to a
946: -- valid location on HR_LOCATIONS
947: --

Line 953: hr_utility.set_message(800, 'HR_289317_NO_SUCH_LOCATION');

949: fetch csr_valid_locn into l_business_group_id;
950: if csr_valid_locn%notfound then
951: --
952: close csr_valid_locn;
953: hr_utility.set_message(800, 'HR_289317_NO_SUCH_LOCATION');
954: hr_utility.raise_error;
955: --
956: end if;
957: close csr_valid_locn;

Line 954: hr_utility.raise_error;

950: if csr_valid_locn%notfound then
951: --
952: close csr_valid_locn;
953: hr_utility.set_message(800, 'HR_289317_NO_SUCH_LOCATION');
954: hr_utility.raise_error;
955: --
956: end if;
957: close csr_valid_locn;
958: hr_utility.set_location(l_proc, 30);

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

954: hr_utility.raise_error;
955: --
956: end if;
957: close csr_valid_locn;
958: hr_utility.set_location(l_proc, 30);
959: --
960: -- Check that the business group of the location is the same as the
961: -- business group of the event, or is global.
962: --

Line 965: hr_utility.set_message(800, 'HR_289318_LOC_NOT_IN_THIS_BG');

961: -- business group of the event, or is global.
962: --
963: if (p_business_group_id <> nvl(l_business_group_id, p_business_group_id)) then
964: --
965: hr_utility.set_message(800, 'HR_289318_LOC_NOT_IN_THIS_BG');
966: hr_utility.raise_error;
967: --
968: end if;
969: --

Line 966: hr_utility.raise_error;

962: --
963: if (p_business_group_id <> nvl(l_business_group_id, p_business_group_id)) then
964: --
965: hr_utility.set_message(800, 'HR_289318_LOC_NOT_IN_THIS_BG');
966: hr_utility.raise_error;
967: --
968: end if;
969: --
970: end if;

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

968: end if;
969: --
970: end if;
971: --
972: hr_utility.set_location(' Leaving:'|| l_proc, 40);
973: end chk_location_id;
974:
975: -- ----------------------------------------------------------------------------
976: -- |--------------------------< chk_party_id >--------------------------------|

Line 1031: hr_utility.set_location('Entering:'|| l_proc, 1);

1027: from hz_parties hzp
1028: where hzp.party_id = p_rec.party_id;
1029: --
1030: begin
1031: hr_utility.set_location('Entering:'|| l_proc, 1);
1032: --
1033: --
1034: if p_rec.party_id is not null then
1035: hr_utility.set_location(l_proc,10);

Line 1035: hr_utility.set_location(l_proc,10);

1031: hr_utility.set_location('Entering:'|| l_proc, 1);
1032: --
1033: --
1034: if p_rec.party_id is not null then
1035: hr_utility.set_location(l_proc,10);
1036: open csr_valid_party_id;
1037: fetch csr_valid_party_id into l_party_id2;
1038: if csr_valid_party_id%notfound then
1039: close csr_valid_party_id;

Line 1040: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');

1036: open csr_valid_party_id;
1037: fetch csr_valid_party_id into l_party_id2;
1038: if csr_valid_party_id%notfound then
1039: close csr_valid_party_id;
1040: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
1041: hr_utility.set_location(l_proc,20);
1042: hr_utility.raise_error;
1043: end if;
1044: close csr_valid_party_id;

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

1037: fetch csr_valid_party_id into l_party_id2;
1038: if csr_valid_party_id%notfound then
1039: close csr_valid_party_id;
1040: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
1041: hr_utility.set_location(l_proc,20);
1042: hr_utility.raise_error;
1043: end if;
1044: close csr_valid_party_id;
1045: elsif p_rec.assignment_id is not null then

Line 1042: hr_utility.raise_error;

1038: if csr_valid_party_id%notfound then
1039: close csr_valid_party_id;
1040: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
1041: hr_utility.set_location(l_proc,20);
1042: hr_utility.raise_error;
1043: end if;
1044: close csr_valid_party_id;
1045: elsif p_rec.assignment_id is not null then
1046: open csr_get_party_id;

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

1048: close csr_get_party_id;
1049: --
1050: -- derive party_id from per_all_people_f using assignment_id
1051: --
1052: hr_utility.set_location(l_proc,30);
1053: p_rec.party_id := l_party_id;
1054: end if;
1055: --
1056: hr_utility.set_location(' Leaving:'||l_proc,100);

Line 1056: hr_utility.set_location(' Leaving:'||l_proc,100);

1052: hr_utility.set_location(l_proc,30);
1053: p_rec.party_id := l_party_id;
1054: end if;
1055: --
1056: hr_utility.set_location(' Leaving:'||l_proc,100);
1057: End chk_party_id;
1058:
1059: --
1060: -- ----------------------------------------------------------------------------

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

1066: --
1067: l_proc varchar2(72) := g_package||'insert_validate';
1068: --
1069: Begin
1070: hr_utility.set_location('Entering:'||l_proc, 10);
1071:
1072: -- HR/TCA merge
1073: -- if party_id is specified, business_group_id isn't required parameter
1074: --

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

1158:
1159: --
1160: per_evt_bus.chk_df(p_rec);
1161: --
1162: hr_utility.set_location(' Leaving:'||l_proc, 20);
1163: End insert_validate;
1164: --
1165: -- ----------------------------------------------------------------------------
1166: -- |---------------------------< update_validate >----------------------------|

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

1171: --
1172: l_proc varchar2(72) := g_package||'update_validate';
1173: --
1174: Begin
1175: hr_utility.set_location('Entering:'||l_proc, 10);
1176: --
1177: -- HR/TCA merge
1178: -- if party_id is specified, business_group_id isn't required parameter
1179: if p_rec.business_group_id is not null then

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

1252:
1253: --
1254: per_evt_bus.chk_df(p_rec);
1255: --
1256: hr_utility.set_location(' Leaving:'||l_proc, 20);
1257: End update_validate;
1258: --
1259: -- ----------------------------------------------------------------------------
1260: -- |---------------------------< delete_validate >----------------------------|

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

1265: --
1266: l_proc varchar2(72) := g_package||'delete_validate';
1267: --
1268: Begin
1269: hr_utility.set_location('Entering:'||l_proc, 10);
1270: --
1271: -- Call all supporting business operations
1272: --
1273: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

1269: hr_utility.set_location('Entering:'||l_proc, 10);
1270: --
1271: -- Call all supporting business operations
1272: --
1273: hr_utility.set_location(' Leaving:'||l_proc, 20);
1274: End delete_validate;
1275: --
1276: end per_evt_bus;