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_RAA_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_raa_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_raa_bus.g_recruitment_activity_id := p_recruitment_activity_id;
147: per_raa_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 188: hr_utility.set_location('Entering:'||l_proc,10);

184: --
185: l_proc varchar2(72) := g_package || 'chk_df';
186: --
187: begin
188: hr_utility.set_location('Entering:'||l_proc,10);
189: --
190: if ((p_rec.recruitment_activity_id is not null) and (
191: nvl(per_raa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

283: ,p_attribute20_value => p_rec.attribute20
284: );
285: end if;
286: --
287: hr_utility.set_location(' Leaving:'||l_proc,20);
288: end chk_df;
289: --
290: -- ----------------------------------------------------------------------------
291: -- |-----------------------< chk_non_updateable_args >------------------------|

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

396: from per_recruitment_activities
397: where name = p_name;
398: --
399: begin
400: hr_utility.set_location('Entering:'||l_proc,10);
401: --
402: hr_api.mandatory_arg_error
403: (p_api_name => l_proc
404: ,p_argument => 'NAME'

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

407: --
408: l_api_updating := per_raa_shd.api_updating
409: (p_recruitment_activity_id => p_recruitment_activity_id
410: ,p_object_version_number => p_object_version_number);
411: hr_utility.set_location(l_proc,20);
412: if(l_api_updating and
413: p_name <>
414: NVL(per_raa_shd.g_old_rec.name,hr_api.g_varchar2)
415: ) or (NOT l_api_updating) then

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

412: if(l_api_updating and
413: p_name <>
414: NVL(per_raa_shd.g_old_rec.name,hr_api.g_varchar2)
415: ) or (NOT l_api_updating) then
416: hr_utility.set_location(l_proc,30);
417: open csr_name;
418: fetch csr_name into l_name;
419: --
420: if(csr_name%found) then

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

417: open csr_name;
418: fetch csr_name into l_name;
419: --
420: if(csr_name%found) then
421: hr_utility.set_location(l_proc,40);
422: close csr_name;
423: fnd_message.set_name('PER','IRC_412123_DUPLICATE_REC_ACTIV');
424: fnd_message.raise_error;
425: end if;

Line 429: hr_utility.set_location(' Leaving:'||l_proc,50);

425: end if;
426: close csr_name;
427: end if;
428: --
429: hr_utility.set_location(' Leaving:'||l_proc,50);
430: exception
431: when app_exception.application_exception then
432: if hr_multi_message.exception_add
433: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.NAME'

Line 435: hr_utility.set_location(' Leaving:'||l_proc,60);

431: when app_exception.application_exception then
432: if hr_multi_message.exception_add
433: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.NAME'
434: ) then
435: hr_utility.set_location(' Leaving:'||l_proc,60);
436: raise;
437: end if;
438: hr_utility.set_location(' Leaving:'||l_proc,70);
439: end chk_name;

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

434: ) then
435: hr_utility.set_location(' Leaving:'||l_proc,60);
436: raise;
437: end if;
438: hr_utility.set_location(' Leaving:'||l_proc,70);
439: end chk_name;
440: --
441: -- -----------------------------------------------------------------------------
442: -- |----------------------< chk_authorising_person_id >------------------------|

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

499: or (ppt.system_person_type = 'CWK' and
500: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'));
501: --
502: begin
503: hr_utility.set_location('Entering:'||l_proc,10);
504: --
505: l_api_updating :=
506: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
507: hr_utility.set_location(l_proc,20);

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

503: hr_utility.set_location('Entering:'||l_proc,10);
504: --
505: l_api_updating :=
506: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
507: hr_utility.set_location(l_proc,20);
508: if p_authorising_person_id is not null then
509: if (l_api_updating and
510: p_authorising_person_id <>
511: NVL(per_raa_shd.g_old_rec.authorising_person_id,hr_api.g_number)

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

511: NVL(per_raa_shd.g_old_rec.authorising_person_id,hr_api.g_number)
512: ) or (NOT l_api_updating) then
513:
514: -- check that authorising_person_id exists in per_all_people_f.
515: hr_utility.set_location(l_proc,30);
516: open csr_authorising_person_id;
517: fetch csr_authorising_person_id into l_authorising_person_id;
518: if csr_authorising_person_id%NOTFOUND then
519: close csr_authorising_person_id;

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

521: fnd_message.raise_error;
522: end if;
523: close csr_authorising_person_id;
524: -- check that system person type is EMP or CWK.
525: hr_utility.set_location(l_proc,40);
526: open csr_system_person_type;
527: fetch csr_system_person_type into l_system_person_type;
528: if csr_system_person_type%NOTFOUND then
529: close csr_system_person_type;

Line 538: hr_utility.set_location(' Leaving:'||l_proc,50);

534: --
535: end if;
536: end if;
537: --
538: hr_utility.set_location(' Leaving:'||l_proc,50);
539: exception
540: when app_exception.application_exception then
541: if hr_multi_message.exception_add
542: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.AUTHORISING_PERSON_ID'

Line 544: hr_utility.set_location(' Leaving:'||l_proc,60);

540: when app_exception.application_exception then
541: if hr_multi_message.exception_add
542: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.AUTHORISING_PERSON_ID'
543: ) then
544: hr_utility.set_location(' Leaving:'||l_proc,60);
545: raise;
546: end if;
547: hr_utility.set_location(' Leaving:'||l_proc,70);
548: --

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

543: ) then
544: hr_utility.set_location(' Leaving:'||l_proc,60);
545: raise;
546: end if;
547: hr_utility.set_location(' Leaving:'||l_proc,70);
548: --
549: end chk_authorising_person_id;
550: --
551: -- -----------------------------------------------------------------------------

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

593: select null from HR_ALL_ORGANIZATION_UNITS hao
594: where hao.organization_id = p_run_by_organization_id;
595: --
596: begin
597: hr_utility.set_location('Entering:'||l_proc,10);
598: --
599: l_api_updating :=
600: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
601: hr_utility.set_location(l_proc,20);

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

597: hr_utility.set_location('Entering:'||l_proc,10);
598: --
599: l_api_updating :=
600: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
601: hr_utility.set_location(l_proc,20);
602: if p_run_by_organization_id is not null then
603: if (l_api_updating and
604: p_run_by_organization_id <>
605: NVL(per_raa_shd.g_old_rec.run_by_organization_id,hr_api.g_number))

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

605: NVL(per_raa_shd.g_old_rec.run_by_organization_id,hr_api.g_number))
606: or (NOT l_api_updating) then
607:
608: -- check that run_by_organization_id exists in per_all_people_f.
609: hr_utility.set_location(l_proc,30);
610: open csr_run_by_organization_id;
611: fetch csr_run_by_organization_id into l_run_by_organization_id;
612: if csr_run_by_organization_id%NOTFOUND then
613: close csr_run_by_organization_id;

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

618: --
619: end if;
620: --
621: end if;
622: hr_utility.set_location(' Leaving:'||l_proc,40);
623: exception
624: when app_exception.application_exception then
625: if hr_multi_message.exception_add
626: (p_associated_column1=> 'PER_RECRUITMENT_ACTIVITIES.RUN_BY_ORGANIZATION_ID'

Line 628: hr_utility.set_location(' Leaving:'||l_proc,50);

624: when app_exception.application_exception then
625: if hr_multi_message.exception_add
626: (p_associated_column1=> 'PER_RECRUITMENT_ACTIVITIES.RUN_BY_ORGANIZATION_ID'
627: ) then
628: hr_utility.set_location(' Leaving:'||l_proc,50);
629: raise;
630: end if;
631: hr_utility.set_location(' Leaving:'||l_proc,60);
632: --

Line 631: hr_utility.set_location(' Leaving:'||l_proc,60);

627: ) then
628: hr_utility.set_location(' Leaving:'||l_proc,50);
629: raise;
630: end if;
631: hr_utility.set_location(' Leaving:'||l_proc,60);
632: --
633: end chk_run_by_organization_id;
634: --
635: -- ----------------------------------------------------------------------------

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

694: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'));
695:
696: --
697: begin
698: hr_utility.set_location('Entering:'||l_proc,10);
699: --
700: l_api_updating :=
701: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
702: hr_utility.set_location(l_proc,20);

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

698: hr_utility.set_location('Entering:'||l_proc,10);
699: --
700: l_api_updating :=
701: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
702: hr_utility.set_location(l_proc,20);
703: if p_internal_contact_person_id is not null then
704: if (l_api_updating and
705: p_internal_contact_person_id <>
706: NVL(per_raa_shd.g_old_rec.internal_contact_person_id,hr_api.g_number))

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

706: NVL(per_raa_shd.g_old_rec.internal_contact_person_id,hr_api.g_number))
707: or (NOT l_api_updating) then
708:
709: -- check that internal_contact_person_id exists in per_all_people_f.
710: hr_utility.set_location(l_proc,30);
711: open csr_internal_contact_person_id;
712: fetch csr_internal_contact_person_id into l_internal_contact_person_id;
713: if csr_internal_contact_person_id%NOTFOUND then
714: close csr_internal_contact_person_id;

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

717: end if;
718: close csr_internal_contact_person_id;
719:
720: -- check that system person type is EMP or CWK.
721: hr_utility.set_location(l_proc,40);
722: open csr_system_person_type;
723: fetch csr_system_person_type into l_system_person_type;
724: if csr_system_person_type%NOTFOUND then
725: close csr_system_person_type;

Line 733: hr_utility.set_location(' Leaving:'||l_proc,50);

729: close csr_system_person_type;
730: --
731: end if;
732: end if;
733: hr_utility.set_location(' Leaving:'||l_proc,50);
734: exception
735: when app_exception.application_exception then
736: if hr_multi_message.exception_add
737: (p_associated_column1 =>

Line 740: hr_utility.set_location(' Leaving:'||l_proc,60);

736: if hr_multi_message.exception_add
737: (p_associated_column1 =>
738: 'PER_RECRUITMENT_ACTIVITIES.INTERNAL_CONTACT_PERSON_ID'
739: ) then
740: hr_utility.set_location(' Leaving:'||l_proc,60);
741: raise;
742: end if;
743: hr_utility.set_location(' Leaving:'||l_proc,70);
744: --

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

739: ) then
740: hr_utility.set_location(' Leaving:'||l_proc,60);
741: raise;
742: end if;
743: hr_utility.set_location(' Leaving:'||l_proc,70);
744: --
745: end chk_internal_contact_person_id;
746: --
747: -- -----------------------------------------------------------------------------

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

813: r2.parent_recruitment_activity_id = prior r2.recruitment_activity_id
814: start with r2.parent_recruitment_activity_id = p_recruitment_activity_id);
815: --
816: begin
817: hr_utility.set_location('Entering:'||l_proc,10);
818: --
819: l_api_updating :=
820: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
821: hr_utility.set_location(l_proc,20);

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

817: hr_utility.set_location('Entering:'||l_proc,10);
818: --
819: l_api_updating :=
820: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
821: hr_utility.set_location(l_proc,20);
822:
823: if p_parent_recruitment_activity is not null then
824: if (l_api_updating and
825: (p_parent_recruitment_activity <>

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

830: or (NOT l_api_updating) then
831:
832: -- Checks that parent recruitment activity id exists in
833: -- PER_RECRUITMENT_ACTIVITIES.
834: hr_utility.set_location(l_proc,30);
835: open csr_parent_recruitment_activit;
836: fetch csr_parent_recruitment_activit into l_parent_recruitment_activity_;
837: if csr_parent_recruitment_activit%NOTFOUND then
838: close csr_parent_recruitment_activit;

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

840: fnd_message.raise_error;
841: end if;
842: close csr_parent_recruitment_activit;
843:
844: hr_utility.set_location(l_proc,35);
845: if p_recruitment_activity_id is not null then
846: -- Checks that parent_recruitment_activity_id is not equal to
847: -- recruitment_activity_id of current row.
848: hr_utility.set_location(l_proc,40);

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

844: hr_utility.set_location(l_proc,35);
845: if p_recruitment_activity_id is not null then
846: -- Checks that parent_recruitment_activity_id is not equal to
847: -- recruitment_activity_id of current row.
848: hr_utility.set_location(l_proc,40);
849: if p_parent_recruitment_activity = p_recruitment_activity_id then
850: fnd_message.set_name('PER','PER_289434_RAA_INV_PARENT_ACTI');
851: fnd_message.raise_error;
852: end if;

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

853: -- Checks that parent_recruitment_activity_id is not equal to
854: -- recruiment_activity_id of any row for which
855: -- parent_recruitment_activity_id
856: -- is equal to recruitment_id of current row.
857: hr_utility.set_location(l_proc,50);
858: open csr_recruitment_activity_id;
859: fetch csr_recruitment_activity_id into l_recruitment_activity_id;
860: if csr_recruitment_activity_id%NOTFOUND then
861: close csr_recruitment_activity_id;

Line 871: hr_utility.set_location(' Leaving:'||l_proc,60);

867: --
868: end if;
869: end if;
870: --
871: hr_utility.set_location(' Leaving:'||l_proc,60);
872: exception
873: when app_exception.application_exception then
874: if hr_multi_message.exception_add
875: (p_associated_column1 =>

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

874: if hr_multi_message.exception_add
875: (p_associated_column1 =>
876: 'PER_RECRUITMENT_ACTIVITIES.PARENT_RECRUITMENT_ACTIVITY_ID'
877: ) then
878: hr_utility.set_location(' Leaving:'||l_proc,70);
879: raise;
880: end if;
881: hr_utility.set_location(' Leaving:'||l_proc,80);
882: --

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

877: ) then
878: hr_utility.set_location(' Leaving:'||l_proc,70);
879: raise;
880: end if;
881: hr_utility.set_location(' Leaving:'||l_proc,80);
882: --
883: end chk_parent_recruitment_activit;
884: --
885: -- -----------------------------------------------------------------------------

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

932: and
933: (p_date_start between fc.start_date_active and fc.end_date_active);
934: --
935: begin
936: hr_utility.set_location('Entering:'||l_proc,10);
937: --
938: l_api_updating :=
939: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
940: hr_utility.set_location(l_proc,20);

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

936: hr_utility.set_location('Entering:'||l_proc,10);
937: --
938: l_api_updating :=
939: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
940: hr_utility.set_location(l_proc,20);
941: if p_currency_code is not null then
942: if (l_api_updating and
943: p_currency_code <>
944: NVL(per_raa_shd.g_old_rec.currency_code,hr_api.g_number))

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

944: NVL(per_raa_shd.g_old_rec.currency_code,hr_api.g_number))
945: or (NOT l_api_updating) then
946:
947: -- check that currency_code exists in FND_CURRENCIES.
948: hr_utility.set_location(l_proc,30);
949: open csr_currency_code;
950: fetch csr_currency_code into l_currency_code;
951: if csr_currency_code%NOTFOUND then
952: close csr_currency_code;

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

957: --
958: end if;
959: end if;
960: --
961: hr_utility.set_location(' Leaving:'||l_proc,40);
962: exception
963: when app_exception.application_exception then
964: if hr_multi_message.exception_add
965: (p_associated_column1 =>

Line 968: hr_utility.set_location(' Leaving:'||l_proc,50);

964: if hr_multi_message.exception_add
965: (p_associated_column1 =>
966: 'PER_RECRUITMENT_ACTIVITIES.CURRENCY_CODE'
967: ) then
968: hr_utility.set_location(' Leaving:'||l_proc,50);
969: raise;
970: end if;
971: hr_utility.set_location(' Leaving:'||l_proc,60);
972: end chk_currency_code;

Line 971: hr_utility.set_location(' Leaving:'||l_proc,60);

967: ) then
968: hr_utility.set_location(' Leaving:'||l_proc,50);
969: raise;
970: end if;
971: hr_utility.set_location(' Leaving:'||l_proc,60);
972: end chk_currency_code;
973: --
974: -- -----------------------------------------------------------------------------
975: -- |-------------------< chk_recruiting_site_id >------------------------------|

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

1016: select null from IRC_ALL_RECRUITING_SITES irs
1017: where irs.recruiting_site_id = p_recruiting_site_id;
1018: --
1019: begin
1020: hr_utility.set_location('Entering:'||l_proc,10);
1021: --
1022: l_api_updating :=
1023: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1024: hr_utility.set_location(l_proc,20);

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

1020: hr_utility.set_location('Entering:'||l_proc,10);
1021: --
1022: l_api_updating :=
1023: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1024: hr_utility.set_location(l_proc,20);
1025: if p_recruiting_site_id is not null then
1026: if (l_api_updating and
1027: p_recruiting_site_id <>
1028: NVL(per_raa_shd.g_old_rec.recruiting_site_id,hr_api.g_number)

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

1028: NVL(per_raa_shd.g_old_rec.recruiting_site_id,hr_api.g_number)
1029: ) or (NOT l_api_updating) then
1030:
1031: -- check that recruiting_site_id exists in IRC_ALL_RECRUITING_SITES.
1032: hr_utility.set_location(l_proc,30);
1033: open csr_recruiting_site_id;
1034: fetch csr_recruiting_site_id into l_recruiting_site_id;
1035: if csr_recruiting_site_id%NOTFOUND then
1036: close csr_recruiting_site_id;

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

1040: close csr_recruiting_site_id;
1041: end if;
1042: end if;
1043: --
1044: hr_utility.set_location(' Leaving:'||l_proc,40);
1045: exception
1046: when app_exception.application_exception then
1047: if hr_multi_message.exception_add
1048: (p_associated_column1 =>

Line 1051: hr_utility.set_location(' Leaving:'||l_proc,50);

1047: if hr_multi_message.exception_add
1048: (p_associated_column1 =>
1049: 'PER_RECRUITMENT_ACTIVITIES.RECRUITING_SITE_ID'
1050: ) then
1051: hr_utility.set_location(' Leaving:'||l_proc,50);
1052: raise;
1053: end if;
1054: hr_utility.set_location(' Leaving:'||l_proc,60);
1055: end chk_recruiting_site_id;

Line 1054: hr_utility.set_location(' Leaving:'||l_proc,60);

1050: ) then
1051: hr_utility.set_location(' Leaving:'||l_proc,50);
1052: raise;
1053: end if;
1054: hr_utility.set_location(' Leaving:'||l_proc,60);
1055: end chk_recruiting_site_id;
1056: --
1057: -- -----------------------------------------------------------------------------
1058: -- |-------------------< chk_posting_content_id >------------------------------|

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

1099: select null from IRC_POSTING_CONTENTS ipc
1100: where ipc.posting_content_id = p_posting_content_id;
1101: --
1102: begin
1103: hr_utility.set_location('Entering:'||l_proc,10);
1104: --
1105: l_api_updating :=
1106: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1107: hr_utility.set_location(l_proc,20);

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

1103: hr_utility.set_location('Entering:'||l_proc,10);
1104: --
1105: l_api_updating :=
1106: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1107: hr_utility.set_location(l_proc,20);
1108: if p_posting_content_id is not null then
1109: if (l_api_updating and
1110: p_posting_content_id <>
1111: NVL(per_raa_shd.g_old_rec.posting_content_id,hr_api.g_number)

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

1111: NVL(per_raa_shd.g_old_rec.posting_content_id,hr_api.g_number)
1112: ) or (NOT l_api_updating) then
1113:
1114: -- check that posting_content_id exists in IRC_POSTING_CONTENTS.
1115: hr_utility.set_location(l_proc,30);
1116: open csr_posting_content_id;
1117: fetch csr_posting_content_id into l_posting_content_id;
1118: if csr_posting_content_id%NOTFOUND then
1119: close csr_posting_content_id;

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

1123: close csr_posting_content_id;
1124: end if;
1125: end if;
1126: --
1127: hr_utility.set_location(' Leaving:'||l_proc,40);
1128: exception
1129: when app_exception.application_exception then
1130: if hr_multi_message.exception_add
1131: (p_associated_column1 =>

Line 1134: hr_utility.set_location(' Leaving:'||l_proc,50);

1130: if hr_multi_message.exception_add
1131: (p_associated_column1 =>
1132: 'PER_RECRUITMENT_ACTIVITIES.POSTING_CONTENT_ID'
1133: ) then
1134: hr_utility.set_location(' Leaving:'||l_proc,50);
1135: raise;
1136: end if;
1137: hr_utility.set_location(' Leaving:'||l_proc,60);
1138: end chk_posting_content_id;

Line 1137: hr_utility.set_location(' Leaving:'||l_proc,60);

1133: ) then
1134: hr_utility.set_location(' Leaving:'||l_proc,50);
1135: raise;
1136: end if;
1137: hr_utility.set_location(' Leaving:'||l_proc,60);
1138: end chk_posting_content_id;
1139: --
1140: -- -----------------------------------------------------------------------------
1141: -- |-----------------------------< chk_dates >--------------------------------|

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

1181: l_proc varchar2(72) := g_package || 'chk_date_start';
1182: l_api_updating boolean;
1183: --
1184: begin
1185: hr_utility.set_location('Entering:'||l_proc,10);
1186: --
1187: l_api_updating :=
1188: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1189: hr_utility.set_location(l_proc,20);

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

1185: hr_utility.set_location('Entering:'||l_proc,10);
1186: --
1187: l_api_updating :=
1188: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1189: hr_utility.set_location(l_proc,20);
1190: if (l_api_updating and
1191: (NVL(p_date_start,hr_api.g_eot) <> per_raa_shd.g_old_rec.date_start
1192: or NVL(p_date_end,hr_api.g_eot) <>
1193: NVL(per_raa_shd.g_old_rec.date_end,hr_api.g_eot))

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

1192: or NVL(p_date_end,hr_api.g_eot) <>
1193: NVL(per_raa_shd.g_old_rec.date_end,hr_api.g_eot))
1194: ) or (NOT l_api_updating) then
1195: -- Checks that date_start is not null.
1196: hr_utility.set_location(l_proc,30);
1197: if p_date_start is null then
1198: fnd_message.set_name('PER','PER_289438_RAA_START_DATE_REQ');
1199: hr_multi_message.add
1200: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.DATE_START'

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

1202: -- Call to raise any errors on multi-message list
1203: hr_multi_message.end_validation_set;
1204: else
1205: -- Checks that date_start is not later then corresponding date_end
1206: hr_utility.set_location(l_proc,40);
1207: if p_date_start > p_date_end then
1208: fnd_message.set_name('PER','HR_6021_ALL_START_END_DATE');
1209: hr_multi_message.add
1210: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.DATE_START'

Line 1217: hr_utility.set_location(' Leaving:'||l_proc,50);

1213: end if;
1214: end if;
1215: end if;
1216: --
1217: hr_utility.set_location(' Leaving:'||l_proc,50);
1218: end chk_dates;
1219: --
1220: -- -----------------------------------------------------------------------------
1221: -- |-----------------------------< chk_type >----------------------------------|

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

1261: l_api_updating boolean;
1262: l_ret boolean;
1263: --
1264: begin
1265: hr_utility.set_location('Entering:'||l_proc,10);
1266: --
1267: l_api_updating :=
1268: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1269: hr_utility.set_location(l_proc,20);

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

1265: hr_utility.set_location('Entering:'||l_proc,10);
1266: --
1267: l_api_updating :=
1268: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1269: hr_utility.set_location(l_proc,20);
1270: if p_type is not null then
1271: if (l_api_updating and
1272: p_type <> NVL(per_raa_shd.g_old_rec.type,hr_api.g_varchar2))
1273: or (NOT l_api_updating) then

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

1272: p_type <> NVL(per_raa_shd.g_old_rec.type,hr_api.g_varchar2))
1273: or (NOT l_api_updating) then
1274:
1275: -- Checks that type is validated against hr_lookups.
1276: hr_utility.set_location(l_proc,30);
1277: l_ret := hr_api.not_exists_in_hr_lookups(
1278: p_effective_date => p_effective_date
1279: ,p_lookup_type => 'REC_TYPE'
1280: ,p_lookup_code => p_type);

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

1284: end if;
1285: end if;
1286: end if;
1287: --
1288: hr_utility.set_location(' Leaving:'||l_proc,40);
1289: exception
1290: when app_exception.application_exception then
1291: if hr_multi_message.exception_add
1292: (p_associated_column1 =>

Line 1295: hr_utility.set_location(' Leaving:'||l_proc,50);

1291: if hr_multi_message.exception_add
1292: (p_associated_column1 =>
1293: 'PER_RECRUITMENT_ACTIVITIES.TYPE'
1294: ) then
1295: hr_utility.set_location(' Leaving:'||l_proc,50);
1296: raise;
1297: end if;
1298: hr_utility.set_location(' Leaving:'||l_proc,60);
1299: end chk_type;

Line 1298: hr_utility.set_location(' Leaving:'||l_proc,60);

1294: ) then
1295: hr_utility.set_location(' Leaving:'||l_proc,50);
1296: raise;
1297: end if;
1298: hr_utility.set_location(' Leaving:'||l_proc,60);
1299: end chk_type;
1300: --
1301: -- -----------------------------------------------------------------------------
1302: -- |---------------------------< chk_date_closing >----------------------------|

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

1341: l_proc varchar2(72) := g_package || 'chk_date_closing';
1342: l_api_updating boolean;
1343: --
1344: begin
1345: hr_utility.set_location('Entering:'||l_proc,10);
1346: --
1347: l_api_updating :=
1348: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1349: hr_utility.set_location(l_proc,20);

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

1345: hr_utility.set_location('Entering:'||l_proc,10);
1346: --
1347: l_api_updating :=
1348: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1349: hr_utility.set_location(l_proc,20);
1350: if p_date_closing is not null then
1351: if (l_api_updating and
1352: (NVL(p_date_closing,hr_api.g_eot) <>
1353: NVL(per_raa_shd.g_old_rec.date_closing,hr_api.g_eot)

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

1354: or p_date_start <> per_raa_shd.g_old_rec.date_start))
1355: or (NOT l_api_updating) then
1356:
1357: -- Checks that date_start is not later then corresponding date_closing
1358: hr_utility.set_location(l_proc,30);
1359: if p_date_start > p_date_closing then
1360: fnd_message.set_name('PER','HR_6114_RAC_CLOSE_DATE');
1361: fnd_message.raise_error;
1362: end if;

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

1362: end if;
1363: end if;
1364: end if;
1365: --
1366: hr_utility.set_location(' Leaving:'||l_proc,40);
1367: exception
1368: when app_exception.application_exception then
1369: if hr_multi_message.exception_add
1370: (p_associated_column1 =>

Line 1373: hr_utility.set_location(' Leaving:'||l_proc,50);

1369: if hr_multi_message.exception_add
1370: (p_associated_column1 =>
1371: 'PER_RECRUITMENT_ACTIVITIES.DATE_CLOSING'
1372: ) then
1373: hr_utility.set_location(' Leaving:'||l_proc,50);
1374: raise;
1375: end if;
1376: hr_utility.set_location(' Leaving:'||l_proc,60);
1377: end chk_date_closing;

Line 1376: hr_utility.set_location(' Leaving:'||l_proc,60);

1372: ) then
1373: hr_utility.set_location(' Leaving:'||l_proc,50);
1374: raise;
1375: end if;
1376: hr_utility.set_location(' Leaving:'||l_proc,60);
1377: end chk_date_closing;
1378: --
1379: -- -----------------------------------------------------------------------------
1380: -- |------------------------------< chk_status >-------------------------------|

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

1421: l_api_updating boolean;
1422: l_ret boolean;
1423: --
1424: begin
1425: hr_utility.set_location('Entering:'||l_proc,10);
1426: --
1427: l_api_updating :=
1428: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1429: hr_utility.set_location(l_proc,20);

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

1425: hr_utility.set_location('Entering:'||l_proc,10);
1426: --
1427: l_api_updating :=
1428: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1429: hr_utility.set_location(l_proc,20);
1430: if p_status is not null then
1431: if (l_api_updating and
1432: p_status <> NVL(per_raa_shd.g_old_rec.status,hr_api.g_varchar2))
1433: or (NOT l_api_updating) then

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

1432: p_status <> NVL(per_raa_shd.g_old_rec.status,hr_api.g_varchar2))
1433: or (NOT l_api_updating) then
1434:
1435: -- Checks that status is validated against hr_lookups.
1436: hr_utility.set_location(l_proc,30);
1437: l_ret := hr_api.not_exists_in_hr_lookups(
1438: p_effective_date => p_effective_date
1439: ,p_lookup_type => 'REC_STATUS'
1440: ,p_lookup_code => p_status);

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

1444: end if;
1445: end if;
1446: end if;
1447: --
1448: hr_utility.set_location(' Leaving:'||l_proc,40);
1449: exception
1450: when app_exception.application_exception then
1451: if hr_multi_message.exception_add
1452: (p_associated_column1 =>

Line 1455: hr_utility.set_location(' Leaving:'||l_proc,50);

1451: if hr_multi_message.exception_add
1452: (p_associated_column1 =>
1453: 'PER_RECRUITMENT_ACTIVITIES.STATUS'
1454: ) then
1455: hr_utility.set_location(' Leaving:'||l_proc,50);
1456: raise;
1457: end if;
1458: hr_utility.set_location(' Leaving:'||l_proc,60);
1459: end chk_status;

Line 1458: hr_utility.set_location(' Leaving:'||l_proc,60);

1454: ) then
1455: hr_utility.set_location(' Leaving:'||l_proc,50);
1456: raise;
1457: end if;
1458: hr_utility.set_location(' Leaving:'||l_proc,60);
1459: end chk_status;
1460: --
1461: -- -----------------------------------------------------------------------------
1462: -- |--------------------------< chk_actual_cost >------------------------------|

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

1498: l_proc varchar2(72) := g_package || 'chk_actual_cost';
1499: l_api_updating boolean;
1500: --
1501: begin
1502: hr_utility.set_location('Entering:'||l_proc,10);
1503: --
1504: l_api_updating :=
1505: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1506: hr_utility.set_location(l_proc,20);

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

1502: hr_utility.set_location('Entering:'||l_proc,10);
1503: --
1504: l_api_updating :=
1505: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1506: hr_utility.set_location(l_proc,20);
1507: if p_actual_cost is not null then
1508: if (l_api_updating and
1509: p_actual_cost <>
1510: NVL(per_raa_shd.g_old_rec.actual_cost,hr_api.g_number))

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

1510: NVL(per_raa_shd.g_old_rec.actual_cost,hr_api.g_number))
1511: or (NOT l_api_updating) then
1512:
1513: -- Checks that actual_cost is greater then zero
1514: hr_utility.set_location(l_proc,30);
1515: if p_actual_cost < 0 then
1516: fnd_message.set_name( 'PER','PAY_6779_DEF_CURR_UNIT_ZERO');
1517: fnd_message.raise_error;
1518: end if;

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

1518: end if;
1519: end if;
1520: end if;
1521: --
1522: hr_utility.set_location(' Leaving:'||l_proc,40);
1523: exception
1524: when app_exception.application_exception then
1525: if hr_multi_message.exception_add
1526: (p_associated_column1 =>

Line 1529: hr_utility.set_location(' Leaving:'||l_proc,50);

1525: if hr_multi_message.exception_add
1526: (p_associated_column1 =>
1527: 'PER_RECRUITMENT_ACTIVITIES.ACTUAL_COST'
1528: ) then
1529: hr_utility.set_location(' Leaving:'||l_proc,50);
1530: raise;
1531: end if;
1532: hr_utility.set_location(' Leaving:'||l_proc,60);
1533: --

Line 1532: hr_utility.set_location(' Leaving:'||l_proc,60);

1528: ) then
1529: hr_utility.set_location(' Leaving:'||l_proc,50);
1530: raise;
1531: end if;
1532: hr_utility.set_location(' Leaving:'||l_proc,60);
1533: --
1534: end chk_actual_cost;
1535: --
1536: -- -----------------------------------------------------------------------------

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

1573: l_proc varchar2(72) := g_package || 'chk_planned_cost';
1574: l_api_updating boolean;
1575: --
1576: begin
1577: hr_utility.set_location('Entering:'||l_proc,10);
1578: --
1579: l_api_updating :=
1580: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1581: hr_utility.set_location(l_proc,20);

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

1577: hr_utility.set_location('Entering:'||l_proc,10);
1578: --
1579: l_api_updating :=
1580: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1581: hr_utility.set_location(l_proc,20);
1582: if p_planned_cost is not null then
1583: if (l_api_updating and
1584: p_planned_cost <>
1585: NVL(per_raa_shd.g_old_rec.planned_cost,hr_api.g_number))

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

1585: NVL(per_raa_shd.g_old_rec.planned_cost,hr_api.g_number))
1586: or (NOT l_api_updating) then
1587:
1588: -- Checks that planned_cost is greater then zero
1589: hr_utility.set_location(l_proc,30);
1590: if p_planned_cost < 0 then
1591: fnd_message.set_name( 'PER','PAY_6779_DEF_CURR_UNIT_ZERO');
1592: fnd_message.raise_error;
1593: end if;

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

1593: end if;
1594: end if;
1595: end if;
1596: --
1597: hr_utility.set_location(' Leaving:'||l_proc,40);
1598: exception
1599: when app_exception.application_exception then
1600: if hr_multi_message.exception_add
1601: (p_associated_column1 =>

Line 1604: hr_utility.set_location(' Leaving:'||l_proc,50);

1600: if hr_multi_message.exception_add
1601: (p_associated_column1 =>
1602: 'PER_RECRUITMENT_ACTIVITIES.PLANNED_COST'
1603: ) then
1604: hr_utility.set_location(' Leaving:'||l_proc,50);
1605: raise;
1606: end if;
1607: hr_utility.set_location(' Leaving:'||l_proc,60);
1608: --

Line 1607: hr_utility.set_location(' Leaving:'||l_proc,60);

1603: ) then
1604: hr_utility.set_location(' Leaving:'||l_proc,50);
1605: raise;
1606: end if;
1607: hr_utility.set_location(' Leaving:'||l_proc,60);
1608: --
1609: end chk_planned_cost;
1610: --
1611: -- ----------------------------------------------------------------------------

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

1617: --
1618: l_proc varchar2(72) := g_package||'insert_validate';
1619: --
1620: Begin
1621: hr_utility.set_location('Entering:'||l_proc, 5);
1622: --
1623: -- Validate Important Attributes
1624: --
1625: -- Call all supporting business operations

Line 1637: hr_utility.set_location(l_proc,6);

1633: -- After validating the set of important attributes,
1634: -- if Mulitple message detection is enabled and at least
1635: -- one error has been found then abort further validation.
1636: --
1637: hr_utility.set_location(l_proc,6);
1638: hr_multi_message.end_validation_set;
1639: --
1640: -- Validate Dependent Attributes
1641: --

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

1638: hr_multi_message.end_validation_set;
1639: --
1640: -- Validate Dependent Attributes
1641: --
1642: hr_utility.set_location(l_proc,10);
1643: per_raa_bus.CHK_NAME(p_name => p_rec.name
1644: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1645: ,p_object_version_number => p_rec.object_version_number);
1646: --

Line 1647: hr_utility.set_location(l_proc,12);

1643: per_raa_bus.CHK_NAME(p_name => p_rec.name
1644: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1645: ,p_object_version_number => p_rec.object_version_number);
1646: --
1647: hr_utility.set_location(l_proc,12);
1648: hr_utility.set_location(l_proc,15);
1649: per_raa_bus.CHK_POSTING_CONTENT_ID(
1650: p_posting_content_id => p_rec.posting_content_id
1651: ,p_recruitment_activity_id => p_rec.recruitment_activity_id

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

1644: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1645: ,p_object_version_number => p_rec.object_version_number);
1646: --
1647: hr_utility.set_location(l_proc,12);
1648: hr_utility.set_location(l_proc,15);
1649: per_raa_bus.CHK_POSTING_CONTENT_ID(
1650: p_posting_content_id => p_rec.posting_content_id
1651: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1652: ,p_object_version_number => p_rec.object_version_number);

Line 1654: hr_utility.set_location(l_proc,16);

1650: p_posting_content_id => p_rec.posting_content_id
1651: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1652: ,p_object_version_number => p_rec.object_version_number);
1653: --
1654: hr_utility.set_location(l_proc,16);
1655: per_raa_bus.CHK_recruiting_site_id(
1656: p_recruiting_site_id => p_rec.recruiting_site_id
1657: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1658: ,p_object_version_number => p_rec.object_version_number);

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

1656: p_recruiting_site_id => p_rec.recruiting_site_id
1657: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1658: ,p_object_version_number => p_rec.object_version_number);
1659: --
1660: hr_utility.set_location(l_proc,20);
1661: per_raa_bus.CHK_DATES(
1662: p_date_start => p_rec.date_start
1663: ,p_date_end => p_rec.date_end
1664: ,p_recruitment_activity_id => p_rec.recruitment_activity_id

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

1663: ,p_date_end => p_rec.date_end
1664: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1665: ,p_object_version_number => p_rec.object_version_number);
1666: --
1667: hr_utility.set_location(l_proc,25);
1668: per_raa_bus.CHK_TYPE(
1669: p_type => p_rec.type
1670: ,p_effective_date => p_rec.date_start
1671: ,p_recruitment_activity_id => p_rec.recruitment_activity_id

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

1670: ,p_effective_date => p_rec.date_start
1671: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1672: ,p_object_version_number => p_rec.object_version_number);
1673: --
1674: hr_utility.set_location(l_proc,40);
1675: per_raa_bus.CHK_DATE_CLOSING(
1676: p_date_closing => p_rec.date_closing
1677: ,p_date_start => p_rec.date_start
1678: ,p_recruitment_activity_id => p_rec.recruitment_activity_id

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

1677: ,p_date_start => p_rec.date_start
1678: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1679: ,p_object_version_number => p_rec.object_version_number);
1680: --
1681: hr_utility.set_location(l_proc,45);
1682: per_raa_bus.CHK_STATUS(
1683: p_status => p_rec.status
1684: ,p_effective_date => p_rec.date_start
1685: ,p_recruitment_activity_id => p_rec.recruitment_activity_id

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

1684: ,p_effective_date => p_rec.date_start
1685: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1686: ,p_object_version_number => p_rec.object_version_number);
1687: --
1688: hr_utility.set_location(l_proc,50);
1689: per_raa_bus.CHK_AUTHORISING_PERSON_ID(
1690: p_authorising_person_id => p_rec.authorising_person_id
1691: ,p_date_start => p_rec.date_start
1692: ,p_recruitment_activity_id => p_rec.recruitment_activity_id

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

1691: ,p_date_start => p_rec.date_start
1692: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1693: ,p_object_version_number => p_rec.object_version_number);
1694: --
1695: hr_utility.set_location(l_proc,55);
1696: per_raa_bus.CHK_RUN_BY_ORGANIZATION_ID(
1697: p_run_by_organization_id => p_rec.run_by_organization_id
1698: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1699: ,p_object_version_number => p_rec.object_version_number);

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

1697: p_run_by_organization_id => p_rec.run_by_organization_id
1698: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1699: ,p_object_version_number => p_rec.object_version_number);
1700: --
1701: hr_utility.set_location(l_proc,60);
1702: per_raa_bus.CHK_INTERNAL_CONTACT_PERSON_ID(
1703: p_internal_contact_person_id =>
1704: p_rec.internal_contact_person_id
1705: ,p_date_start => p_rec.date_start

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

1705: ,p_date_start => p_rec.date_start
1706: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1707: ,p_object_version_number => p_rec.object_version_number);
1708: --
1709: hr_utility.set_location(l_proc,65);
1710: per_raa_bus.CHK_PARENT_RECRUITMENT_ACTIVIT(
1711: p_parent_recruitment_activity
1712: => p_rec.parent_recruitment_activity_id
1713: ,p_date_start => p_rec.date_start

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

1714: ,p_business_group_id => p_rec.business_group_id
1715: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1716: ,p_object_version_number => p_rec.object_version_number);
1717: --
1718: hr_utility.set_location(l_proc,70);
1719: per_raa_bus.CHK_CURRENCY_CODE(
1720: p_currency_code => p_rec.currency_code
1721: ,p_date_start => p_rec.date_start
1722: ,p_recruitment_activity_id => p_rec.recruitment_activity_id

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

1721: ,p_date_start => p_rec.date_start
1722: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1723: ,p_object_version_number => p_rec.object_version_number);
1724: --
1725: hr_utility.set_location(l_proc,75);
1726: per_raa_bus.CHK_ACTUAL_COST(
1727: p_actual_cost => p_rec.actual_cost
1728: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1729: ,p_object_version_number => p_rec.object_version_number);

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

1727: p_actual_cost => p_rec.actual_cost
1728: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1729: ,p_object_version_number => p_rec.object_version_number);
1730: --
1731: hr_utility.set_location(l_proc,80);
1732: per_raa_bus.CHK_PLANNED_COST(
1733: p_planned_cost => p_rec.planned_cost
1734: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1735: ,p_object_version_number => p_rec.object_version_number);

Line 1737: hr_utility.set_location(l_proc,85);

1733: p_planned_cost => p_rec.planned_cost
1734: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1735: ,p_object_version_number => p_rec.object_version_number);
1736: --
1737: hr_utility.set_location(l_proc,85);
1738: per_raa_bus.chk_df(p_rec => p_rec);
1739: --
1740: hr_utility.set_location(' Leaving:'||l_proc, 90);
1741: End insert_validate;

Line 1740: hr_utility.set_location(' Leaving:'||l_proc, 90);

1736: --
1737: hr_utility.set_location(l_proc,85);
1738: per_raa_bus.chk_df(p_rec => p_rec);
1739: --
1740: hr_utility.set_location(' Leaving:'||l_proc, 90);
1741: End insert_validate;
1742: --
1743: -- ----------------------------------------------------------------------------
1744: -- |---------------------------< update_validate >----------------------------|

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

1749: --
1750: l_proc varchar2(72) := g_package||'update_validate';
1751: --
1752: Begin
1753: hr_utility.set_location('Entering:'||l_proc, 5);
1754: --
1755: -- Validate Important Attributes
1756: --
1757: -- Call all supporting business operations

Line 1769: hr_utility.set_location(l_proc,6);

1765: -- After validating the set of important attributes,
1766: -- if Mulitple message detection is enabled and at least
1767: -- one error has been found then abort further validation.
1768: --
1769: hr_utility.set_location(l_proc,6);
1770: hr_multi_message.end_validation_set;
1771: --
1772: -- Validate Dependent Attributes
1773: --

Line 1774: hr_utility.set_location(l_proc,7);

1770: hr_multi_message.end_validation_set;
1771: --
1772: -- Validate Dependent Attributes
1773: --
1774: hr_utility.set_location(l_proc,7);
1775: chk_non_updateable_args
1776: (p_rec => p_rec
1777: );
1778: --

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

1775: chk_non_updateable_args
1776: (p_rec => p_rec
1777: );
1778: --
1779: hr_utility.set_location(l_proc,10);
1780: per_raa_bus.CHK_NAME(p_name => p_rec.name
1781: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1782: ,p_object_version_number => p_rec.object_version_number);
1783: --

Line 1784: hr_utility.set_location(l_proc,12);

1780: per_raa_bus.CHK_NAME(p_name => p_rec.name
1781: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1782: ,p_object_version_number => p_rec.object_version_number);
1783: --
1784: hr_utility.set_location(l_proc,12);
1785: --
1786: hr_utility.set_location(l_proc,15);
1787: per_raa_bus.CHK_POSTING_CONTENT_ID(
1788: p_posting_content_id => p_rec.posting_content_id

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

1782: ,p_object_version_number => p_rec.object_version_number);
1783: --
1784: hr_utility.set_location(l_proc,12);
1785: --
1786: hr_utility.set_location(l_proc,15);
1787: per_raa_bus.CHK_POSTING_CONTENT_ID(
1788: p_posting_content_id => p_rec.posting_content_id
1789: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1790: ,p_object_version_number => p_rec.object_version_number);

Line 1792: hr_utility.set_location(l_proc,16);

1788: p_posting_content_id => p_rec.posting_content_id
1789: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1790: ,p_object_version_number => p_rec.object_version_number);
1791: --
1792: hr_utility.set_location(l_proc,16);
1793: per_raa_bus.CHK_recruiting_site_id(
1794: p_recruiting_site_id => p_rec.recruiting_site_id
1795: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1796: ,p_object_version_number => p_rec.object_version_number);

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

1793: per_raa_bus.CHK_recruiting_site_id(
1794: p_recruiting_site_id => p_rec.recruiting_site_id
1795: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1796: ,p_object_version_number => p_rec.object_version_number);
1797: hr_utility.set_location(l_proc,20);
1798: per_raa_bus.CHK_DATES(
1799: p_date_start => p_rec.date_start
1800: ,p_date_end => p_rec.date_end
1801: ,p_recruitment_activity_id => p_rec.recruitment_activity_id

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

1800: ,p_date_end => p_rec.date_end
1801: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1802: ,p_object_version_number => p_rec.object_version_number);
1803: --
1804: hr_utility.set_location(l_proc,25);
1805: per_raa_bus.CHK_TYPE(
1806: p_type => p_rec.type
1807: ,p_effective_date => p_rec.date_start
1808: ,p_recruitment_activity_id => p_rec.recruitment_activity_id

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

1807: ,p_effective_date => p_rec.date_start
1808: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1809: ,p_object_version_number => p_rec.object_version_number);
1810: --
1811: hr_utility.set_location(l_proc,40);
1812: per_raa_bus.CHK_DATE_CLOSING(
1813: p_date_closing => p_rec.date_closing
1814: ,p_date_start => p_rec.date_start
1815: ,p_recruitment_activity_id => p_rec.recruitment_activity_id

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

1814: ,p_date_start => p_rec.date_start
1815: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1816: ,p_object_version_number => p_rec.object_version_number);
1817: --
1818: hr_utility.set_location(l_proc,45);
1819: per_raa_bus.CHK_STATUS(
1820: p_status => p_rec.status
1821: ,p_effective_date => p_rec.date_start
1822: ,p_recruitment_activity_id => p_rec.recruitment_activity_id

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

1821: ,p_effective_date => p_rec.date_start
1822: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1823: ,p_object_version_number => p_rec.object_version_number);
1824: --
1825: hr_utility.set_location(l_proc,50);
1826: per_raa_bus.CHK_AUTHORISING_PERSON_ID(
1827: p_authorising_person_id => p_rec.authorising_person_id
1828: ,p_date_start => p_rec.date_start
1829: ,p_recruitment_activity_id => p_rec.recruitment_activity_id

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

1828: ,p_date_start => p_rec.date_start
1829: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1830: ,p_object_version_number => p_rec.object_version_number);
1831: --
1832: hr_utility.set_location(l_proc,55);
1833: per_raa_bus.CHK_RUN_BY_ORGANIZATION_ID(
1834: p_run_by_organization_id => p_rec.run_by_organization_id
1835: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1836: ,p_object_version_number => p_rec.object_version_number);

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

1834: p_run_by_organization_id => p_rec.run_by_organization_id
1835: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1836: ,p_object_version_number => p_rec.object_version_number);
1837: --
1838: hr_utility.set_location(l_proc,60);
1839: per_raa_bus.CHK_INTERNAL_CONTACT_PERSON_ID(
1840: p_internal_contact_person_id =>
1841: p_rec.internal_contact_person_id
1842: ,p_date_start => p_rec.date_start

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

1842: ,p_date_start => p_rec.date_start
1843: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1844: ,p_object_version_number => p_rec.object_version_number);
1845: --
1846: hr_utility.set_location(l_proc,65);
1847: per_raa_bus.CHK_PARENT_RECRUITMENT_ACTIVIT(
1848: p_parent_recruitment_activity
1849: =>
1850: p_rec.parent_recruitment_activity_id

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

1853: per_raa_shd.g_old_rec.business_group_id
1854: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1855: ,p_object_version_number => p_rec.object_version_number);
1856: --
1857: hr_utility.set_location(l_proc,70);
1858: per_raa_bus.CHK_CURRENCY_CODE(
1859: p_currency_code => p_rec.currency_code
1860: ,p_date_start => p_rec.date_start
1861: ,p_recruitment_activity_id => p_rec.recruitment_activity_id

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

1860: ,p_date_start => p_rec.date_start
1861: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1862: ,p_object_version_number => p_rec.object_version_number);
1863: --
1864: hr_utility.set_location(l_proc,75);
1865: per_raa_bus.CHK_ACTUAL_COST(
1866: p_actual_cost => p_rec.actual_cost
1867: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1868: ,p_object_version_number => p_rec.object_version_number);

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

1866: p_actual_cost => p_rec.actual_cost
1867: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1868: ,p_object_version_number => p_rec.object_version_number);
1869: --
1870: hr_utility.set_location(l_proc,80);
1871: per_raa_bus.CHK_PLANNED_COST(
1872: p_planned_cost => p_rec.planned_cost
1873: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1874: ,p_object_version_number => p_rec.object_version_number);

Line 1876: hr_utility.set_location(l_proc,85);

1872: p_planned_cost => p_rec.planned_cost
1873: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1874: ,p_object_version_number => p_rec.object_version_number);
1875: --
1876: hr_utility.set_location(l_proc,85);
1877: per_raa_bus.chk_df(p_rec => p_rec);
1878: --
1879: hr_utility.set_location(' Leaving:'||l_proc, 90);
1880: End update_validate;

Line 1879: hr_utility.set_location(' Leaving:'||l_proc, 90);

1875: --
1876: hr_utility.set_location(l_proc,85);
1877: per_raa_bus.chk_df(p_rec => p_rec);
1878: --
1879: hr_utility.set_location(' Leaving:'||l_proc, 90);
1880: End update_validate;
1881: --
1882: -- ----------------------------------------------------------------------------
1883: -- |---------------------------< delete_validate >----------------------------|

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

1888: --
1889: l_proc varchar2(72) := g_package||'delete_validate';
1890: --
1891: Begin
1892: hr_utility.set_location('Entering:'||l_proc, 5);
1893: --
1894: -- Call all supporting business operations
1895: --
1896: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1892: hr_utility.set_location('Entering:'||l_proc, 5);
1893: --
1894: -- Call all supporting business operations
1895: --
1896: hr_utility.set_location(' Leaving:'||l_proc, 10);
1897: End delete_validate;
1898: --
1899: end per_raa_bus;