[Home] [Help]
42: l_proc varchar2(72) := g_package||'set_security_group_id';
43: --
44: begin
45: --
46: hr_utility.set_location('Entering:'|| l_proc, 10);
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
50: hr_api.mandatory_arg_error
77: (p_security_group_id => l_security_group_id
78: );
79: end if;
80: --
81: hr_utility.set_location(' Leaving:'|| l_proc, 20);
82: end set_security_group_id;
83: --
84: -- ---------------------------------------------------------------------------
85: -- |---------------------< return_legislation_code >-------------------------|
109: l_proc varchar2(72) := g_package||'return_legislation_code';
110: --
111: Begin
112: --
113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Ensure that all the mandatory parameter are not null
116: --
117: hr_api.mandatory_arg_error
127: -- call to this function. Just return the value in the global
128: -- variable.
129: --
130: l_legislation_code := per_pjo_bus.g_legislation_code;
131: hr_utility.set_location(l_proc, 20);
132: else
133: --
134: -- The ID is different to the last call to this function
135: -- or this is the first call to this function.
144: close csr_leg_code;
145: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: end if;
148: hr_utility.set_location(l_proc,30);
149: --
150: -- Set the global variables so the values are
151: -- available for the next call to this function.
152: --
153: close csr_leg_code;
154: per_pjo_bus.g_previous_job_id := p_previous_job_id;
155: per_pjo_bus.g_legislation_code := l_legislation_code;
156: end if;
157: hr_utility.set_location(' Leaving:'|| l_proc, 40);
158: return l_legislation_code;
159: end return_legislation_code;
160: --
161: -- ----------------------------------------------------------------------------
192: --
193: l_proc varchar2(72) := g_package || 'chk_ddf';
194: --
195: begin
196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: if ((p_rec.previous_job_id is not null) and (
199: nvl(per_pjo_shd.g_old_rec.pjo_information_category, hr_api.g_varchar2) <>
200: nvl(p_rec.pjo_information_category, hr_api.g_varchar2) or
331: ,p_attribute30_value => p_rec.pjo_information30
332: );
333: end if;
334: --
335: hr_utility.set_location(' Leaving:'||l_proc,20);
336: end chk_ddf;
337: --
338: -- ----------------------------------------------------------------------------
339: -- |------------------------------< chk_df >----------------------------------|
369: --
370: l_proc varchar2(72) := g_package || 'chk_df';
371: --
372: begin
373: hr_utility.set_location('Entering:'||l_proc,10);
374: --
375: if ((p_rec.previous_job_id is not null) and (
376: nvl(per_pjo_shd.g_old_rec.pjo_attribute_category, hr_api.g_varchar2) <>
377: nvl(p_rec.pjo_attribute_category, hr_api.g_varchar2) or
508: ,p_attribute30_value => p_rec.pjo_attribute30
509: );
510: end if;
511: --
512: hr_utility.set_location(' Leaving:'||l_proc,20);
513: end chk_df;
514: --
515: -- ----------------------------------------------------------------------------
516: -- |-----------------------< chk_non_updateable_args >------------------------|
571: ,p_base_table => per_pjo_shd.g_tab_nam
572: );
573: end if;
574: --
575: hr_utility.set_location(l_proc,15);
576: if per_pjo_shd.g_old_rec.previous_employer_id <> p_rec.previous_employer_id
577: then
578: hr_api.argument_changed_error
579: (p_api_name => l_proc
622: --
623: l_proc varchar2(72) := g_package||'chk_previous_employer_id';
624: l_api_updating boolean;
625: begin
626: hr_utility.set_location('Entering:'||l_proc, 5);
627: --
628: if p_previous_employer_id is not null then
629: hr_utility.set_location(l_proc, 10);
630: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
625: begin
626: hr_utility.set_location('Entering:'||l_proc, 5);
627: --
628: if p_previous_employer_id is not null then
629: hr_utility.set_location(l_proc, 10);
630: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
631: => p_previous_job_id
632: ,p_object_version_number
633: => p_object_version_number);
635: (nvl(p_previous_employer_id,hr_api.g_number)
636: <> nvl(per_pjo_shd.g_old_rec.previous_employer_id,hr_api.g_number))
637: ) or
638: (not l_api_updating) then
639: hr_utility.set_location(l_proc, 15);
640: open csr_previous_employer_id;
641: fetch csr_previous_employer_id into l_previous_employer_id;
642: if csr_previous_employer_id%notfound then
643: hr_utility.set_location(l_proc, 20);
639: hr_utility.set_location(l_proc, 15);
640: open csr_previous_employer_id;
641: fetch csr_previous_employer_id into l_previous_employer_id;
642: if csr_previous_employer_id%notfound then
643: hr_utility.set_location(l_proc, 20);
644: close csr_previous_employer_id;
645: fnd_message.set_name('PER','HR_289537_PJO_VALID_PR_EMPR_ID');
646: fnd_message.raise_error;
647: end if;
650: end if;
651: end if;
652: end if;
653: --
654: hr_utility.set_location('Leaving:'||l_proc, 25);
655: exception
656: when app_exception.application_exception then
657: if hr_multi_message.exception_add
658: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'
656: when app_exception.application_exception then
657: if hr_multi_message.exception_add
658: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'
659: ) then
660: hr_utility.set_location(' Leaving:'|| l_proc, 30);
661: raise;
662: end if;
663: hr_utility.set_location(' Leaving:'|| l_proc, 35);
664: end chk_previous_employer_id;
659: ) then
660: hr_utility.set_location(' Leaving:'|| l_proc, 30);
661: raise;
662: end if;
663: hr_utility.set_location(' Leaving:'|| l_proc, 35);
664: end chk_previous_employer_id;
665: --
666: -- ----------------------------------------------------------------------------
667: -- |---------------------------< chk_start_end_dates >------------------------|
700: in per_previous_jobs.end_date%type) is
701: l_proc varchar2(72) := g_package||'chk_start_end_dates';
702: l_api_updating boolean;
703: begin
704: hr_utility.set_location('Entering:'||l_proc, 5);
705: --
706: if p_start_date is not null and p_end_date is not null then
707: hr_utility.set_location(l_proc, 10);
708: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
703: begin
704: hr_utility.set_location('Entering:'||l_proc, 5);
705: --
706: if p_start_date is not null and p_end_date is not null then
707: hr_utility.set_location(l_proc, 10);
708: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
709: => p_previous_job_id
710: ,p_object_version_number
711: => p_object_version_number);
716: nvl(p_end_date,hr_api.g_eot)
717: <> nvl(per_pjo_shd.g_old_rec.end_date,hr_api.g_eot))
718: ) or
719: (not l_api_updating) then
720: hr_utility.set_location(l_proc, 15);
721: if p_start_date > p_end_date then
722: hr_utility.set_location(l_proc, 20);
723: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
724: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),TRUE);
718: ) or
719: (not l_api_updating) then
720: hr_utility.set_location(l_proc, 15);
721: if p_start_date > p_end_date then
722: hr_utility.set_location(l_proc, 20);
723: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
724: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),TRUE);
725: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),TRUE);
726: fnd_message.raise_error;
727: end if;
728: end if;
729: end if;
730: --
731: hr_utility.set_location('Leaving:'||l_proc, 25);
732: exception
733: when app_exception.application_exception then
734: if hr_multi_message.exception_add
735: (p_associated_column1 => 'PER_PREVIOUS_JOBS.START_DATE'
734: if hr_multi_message.exception_add
735: (p_associated_column1 => 'PER_PREVIOUS_JOBS.START_DATE'
736: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.END_DATE'
737: ) then
738: hr_utility.set_location(' Leaving:'|| l_proc, 50);
739: raise;
740: end if;
741: hr_utility.set_location(' Leaving:'|| l_proc, 60);
742: end chk_start_end_dates;
737: ) then
738: hr_utility.set_location(' Leaving:'|| l_proc, 50);
739: raise;
740: end if;
741: hr_utility.set_location(' Leaving:'|| l_proc, 60);
742: end chk_start_end_dates;
743: --
744: -- -----------------------------------------------------------------------
745: -- |---------------------------< chk_employment_category >---------------|
782: l_lookup_code per_previous_jobs.employment_category%type
783: := p_employment_category;
784: l_api_updating boolean;
785: begin
786: hr_utility.set_location('Entering:'||l_proc, 5);
787: --
788: if p_employment_category is not null then
789: hr_utility.set_location(l_proc, 10);
790: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
785: begin
786: hr_utility.set_location('Entering:'||l_proc, 5);
787: --
788: if p_employment_category is not null then
789: hr_utility.set_location(l_proc, 10);
790: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
791: => p_previous_job_id
792: ,p_object_version_number
793: => p_object_version_number);
796: <> nvl(per_pjo_shd.g_old_rec.employment_category,hr_api.g_varchar2)
797: )
798: ) or
799: (not l_api_updating)) then
800: hr_utility.set_location(l_proc, 15);
801: l_no_lookup := hr_api.not_exists_in_leg_lookups
802: (p_effective_date => l_effective_date
803: ,p_lookup_type => l_lookup_type
804: ,p_lookup_code => l_lookup_code
802: (p_effective_date => l_effective_date
803: ,p_lookup_type => l_lookup_type
804: ,p_lookup_code => l_lookup_code
805: );
806: hr_utility.set_location(l_proc, 20);
807: if l_no_lookup = true then
808: hr_utility.set_location(l_proc, 25);
809: fnd_message.set_name('PER','HR_289538_PJO_EMPT_CAT');
810: fnd_message.raise_error;
804: ,p_lookup_code => l_lookup_code
805: );
806: hr_utility.set_location(l_proc, 20);
807: if l_no_lookup = true then
808: hr_utility.set_location(l_proc, 25);
809: fnd_message.set_name('PER','HR_289538_PJO_EMPT_CAT');
810: fnd_message.raise_error;
811: end if;
812: end if;
811: end if;
812: end if;
813: end if;
814: --
815: hr_utility.set_location('Leaving:'||l_proc, 30);
816: exception
817: when app_exception.application_exception then
818: if hr_multi_message.exception_add
819: (p_associated_column1 => 'PER_PREVIOUS_JOBS.EMPLOYMENT_CATEGORY'
817: when app_exception.application_exception then
818: if hr_multi_message.exception_add
819: (p_associated_column1 => 'PER_PREVIOUS_JOBS.EMPLOYMENT_CATEGORY'
820: ) then
821: hr_utility.set_location(' Leaving:'|| l_proc, 50);
822: raise;
823: end if;
824: hr_utility.set_location(' Leaving:'|| l_proc, 60);
825: end chk_employment_category;
820: ) then
821: hr_utility.set_location(' Leaving:'|| l_proc, 50);
822: raise;
823: end if;
824: hr_utility.set_location(' Leaving:'|| l_proc, 60);
825: end chk_employment_category;
826: --
827: -- -----------------------------------------------------------------------
828: -- |---------------------------< chk_period_years >----------------------|
858: in per_previous_jobs.object_version_number%type) is
859: l_proc varchar2(72) := g_package||'chk_period_years';
860: l_api_updating boolean;
861: begin
862: hr_utility.set_location('Entering:'||l_proc, 5);
863: --
864: if p_period_years is not null then
865: hr_utility.set_location(l_proc, 10);
866: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
861: begin
862: hr_utility.set_location('Entering:'||l_proc, 5);
863: --
864: if p_period_years is not null then
865: hr_utility.set_location(l_proc, 10);
866: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
867: => p_previous_job_id
868: ,p_object_version_number
869: => p_object_version_number);
866: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
867: => p_previous_job_id
868: ,p_object_version_number
869: => p_object_version_number);
870: hr_utility.set_location(l_proc, 15);
871: if ((l_api_updating and
872: ( nvl(p_period_years,hr_api.g_number)
873: <> nvl(per_pjo_shd.g_old_rec.period_years,hr_api.g_number)
874: )
873: <> nvl(per_pjo_shd.g_old_rec.period_years,hr_api.g_number)
874: )
875: ) or
876: (not l_api_updating)) then
877: hr_utility.set_location(l_proc, 20);
878: if p_period_years not between 0 and 99 then
879: hr_utility.set_location(l_proc, 25);
880: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
881: fnd_message.set_token('RANGE_START','0',true);
875: ) or
876: (not l_api_updating)) then
877: hr_utility.set_location(l_proc, 20);
878: if p_period_years not between 0 and 99 then
879: hr_utility.set_location(l_proc, 25);
880: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
881: fnd_message.set_token('RANGE_START','0',true);
882: fnd_message.set_token('RANGE_END','99',true);
883: fnd_message.raise_error;
884: end if;
885: end if;
886: end if;
887: --
888: hr_utility.set_location('Leaving:'||l_proc, 30);
889: exception
890: when app_exception.application_exception then
891: if hr_multi_message.exception_add
892: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PERIOD_YEARS'
890: when app_exception.application_exception then
891: if hr_multi_message.exception_add
892: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PERIOD_YEARS'
893: ) then
894: hr_utility.set_location(' Leaving:'|| l_proc, 40);
895: raise;
896: end if;
897: hr_utility.set_location(' Leaving:'|| l_proc, 50);
898: end chk_period_years;
893: ) then
894: hr_utility.set_location(' Leaving:'|| l_proc, 40);
895: raise;
896: end if;
897: hr_utility.set_location(' Leaving:'|| l_proc, 50);
898: end chk_period_years;
899: --
900: -- -----------------------------------------------------------------------
901: -- |---------------------------< chk_period_months >---------------------|
931: in per_previous_jobs.object_version_number%type) is
932: l_proc varchar2(72) := g_package||'chk_period_months';
933: l_api_updating boolean;
934: begin
935: hr_utility.set_location('Entering:'||l_proc, 5);
936: --
937: if p_period_months is not null then
938: hr_utility.set_location(l_proc, 10);
939: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
934: begin
935: hr_utility.set_location('Entering:'||l_proc, 5);
936: --
937: if p_period_months is not null then
938: hr_utility.set_location(l_proc, 10);
939: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
940: => p_previous_job_id
941: ,p_object_version_number
942: => p_object_version_number);
939: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
940: => p_previous_job_id
941: ,p_object_version_number
942: => p_object_version_number);
943: hr_utility.set_location(l_proc, 15);
944: if ((l_api_updating and
945: ( nvl(p_period_months,hr_api.g_number)
946: <> nvl(per_pjo_shd.g_old_rec.period_months,hr_api.g_number)
947: )
946: <> nvl(per_pjo_shd.g_old_rec.period_months,hr_api.g_number)
947: )
948: ) or
949: (not l_api_updating)) then
950: hr_utility.set_location(l_proc, 20);
951: if p_period_months not between 0 and 11 then
952: hr_utility.set_location(l_proc, 25);
953: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
954: fnd_message.set_token('RANGE_START','0',true);
948: ) or
949: (not l_api_updating)) then
950: hr_utility.set_location(l_proc, 20);
951: if p_period_months not between 0 and 11 then
952: hr_utility.set_location(l_proc, 25);
953: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
954: fnd_message.set_token('RANGE_START','0',true);
955: fnd_message.set_token('RANGE_END','11',true);
956: fnd_message.raise_error;
957: end if;
958: end if;
959: end if;
960: --
961: hr_utility.set_location('Leaving:'||l_proc, 30);
962: exception
963: when app_exception.application_exception then
964: if hr_multi_message.exception_add
965: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PERIOD_MONTHS'
963: when app_exception.application_exception then
964: if hr_multi_message.exception_add
965: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PERIOD_MONTHS'
966: ) then
967: hr_utility.set_location(' Leaving:'|| l_proc, 40);
968: raise;
969: end if;
970: hr_utility.set_location(' Leaving:'|| l_proc, 50);
971: end chk_period_months;
966: ) then
967: hr_utility.set_location(' Leaving:'|| l_proc, 40);
968: raise;
969: end if;
970: hr_utility.set_location(' Leaving:'|| l_proc, 50);
971: end chk_period_months;
972: --
973: -- -----------------------------------------------------------------------
974: -- |---------------------------< chk_period_days >-----------------------|
1004: in per_previous_jobs.object_version_number%type) is
1005: l_proc varchar2(72) := g_package||'chk_period_days';
1006: l_api_updating boolean;
1007: begin
1008: hr_utility.set_location('Entering:'||l_proc, 5);
1009: --
1010: if p_period_days is not null then
1011: hr_utility.set_location(l_proc, 10);
1012: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
1007: begin
1008: hr_utility.set_location('Entering:'||l_proc, 5);
1009: --
1010: if p_period_days is not null then
1011: hr_utility.set_location(l_proc, 10);
1012: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
1013: => p_previous_job_id
1014: ,p_object_version_number
1015: => p_object_version_number);
1012: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
1013: => p_previous_job_id
1014: ,p_object_version_number
1015: => p_object_version_number);
1016: hr_utility.set_location(l_proc, 15);
1017: if ((l_api_updating and
1018: ( nvl(p_period_days,hr_api.g_number)
1019: <> nvl(per_pjo_shd.g_old_rec.period_days,hr_api.g_number)
1020: )
1019: <> nvl(per_pjo_shd.g_old_rec.period_days,hr_api.g_number)
1020: )
1021: ) or
1022: (not l_api_updating)) then
1023: hr_utility.set_location(l_proc, 20);
1024: if p_period_days not between 0 and 365 then
1025: hr_utility.set_location(l_proc, 25);
1026: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1027: fnd_message.set_token('RANGE_START','0',true);
1021: ) or
1022: (not l_api_updating)) then
1023: hr_utility.set_location(l_proc, 20);
1024: if p_period_days not between 0 and 365 then
1025: hr_utility.set_location(l_proc, 25);
1026: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1027: fnd_message.set_token('RANGE_START','0',true);
1028: fnd_message.set_token('RANGE_END','365',true);
1029: fnd_message.raise_error;
1030: end if;
1031: end if;
1032: end if;
1033: --
1034: hr_utility.set_location('Leaving:'||l_proc, 30);
1035: exception
1036: when app_exception.application_exception then
1037: if hr_multi_message.exception_add
1038: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PERIOD_DAYS'
1036: when app_exception.application_exception then
1037: if hr_multi_message.exception_add
1038: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PERIOD_DAYS'
1039: ) then
1040: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1041: raise;
1042: end if;
1043: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1044: end chk_period_days;
1039: ) then
1040: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1041: raise;
1042: end if;
1043: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1044: end chk_period_days;
1045: --
1046: -- -----------------------------------------------------------------------
1047: -- |---------------------------< chk_pjo_start_end_dates >---------------|
1099: --
1100: l_proc varchar2(72) := g_package||'chk_pjo_start_end_dates';
1101: l_api_updating boolean;
1102: begin
1103: hr_utility.set_location('Entering:'||l_proc, 5);
1104: --
1105: if hr_multi_message.no_all_inclusive_error
1106: (p_check_column1 => 'PER_PREVIOUS_JOBS.START_DATE'
1107: ,p_check_column2 => 'PER_PREVIOUS_JOBS.END_DATE'
1106: (p_check_column1 => 'PER_PREVIOUS_JOBS.START_DATE'
1107: ,p_check_column2 => 'PER_PREVIOUS_JOBS.END_DATE'
1108: ,p_check_column3 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'
1109: ) THEN
1110: hr_utility.set_location('Entering:'||l_proc, 6);
1111: -- This if condition added for bug 7112425
1112: IF p_start_date is not null AND p_start_date > p_effective_date THEN
1113: fnd_message.set_name('PER','HR_INVAL_ST_DT_PJO');
1114: fnd_message.raise_error;
1112: IF p_start_date is not null AND p_start_date > p_effective_date THEN
1113: fnd_message.set_name('PER','HR_INVAL_ST_DT_PJO');
1114: fnd_message.raise_error;
1115: END IF ;
1116: hr_utility.set_location('Entering:'||l_proc, 7);
1117:
1118: if p_start_date is not null or p_end_date is not null then
1119: hr_utility.set_location(l_proc, 10);
1120: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
1115: END IF ;
1116: hr_utility.set_location('Entering:'||l_proc, 7);
1117:
1118: if p_start_date is not null or p_end_date is not null then
1119: hr_utility.set_location(l_proc, 10);
1120: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
1121: => p_previous_job_id
1122: ,p_object_version_number
1123: => p_object_version_number);
1128: nvl(p_end_date,hr_api.g_eot)
1129: <> nvl(per_pjo_shd.g_old_rec.end_date,hr_api.g_eot))
1130: ) or
1131: (not l_api_updating)) then
1132: hr_utility.set_location(l_proc, 15);
1133: open csr_pem_start_end_dates;
1134: fetch csr_pem_start_end_dates into l_previous_employer_id;
1135: if csr_pem_start_end_dates%found then
1136: hr_utility.set_location(l_proc, 20);
1132: hr_utility.set_location(l_proc, 15);
1133: open csr_pem_start_end_dates;
1134: fetch csr_pem_start_end_dates into l_previous_employer_id;
1135: if csr_pem_start_end_dates%found then
1136: hr_utility.set_location(l_proc, 20);
1137: close csr_pem_start_end_dates;
1138: fnd_message.set_name('PER','HR_289542_PJO_START_END_DATES');
1139: fnd_message.raise_error;
1140: end if;
1144: end if;
1145: end if;
1146: end if;
1147: --
1148: hr_utility.set_location('Leaving:'||l_proc, 25);
1149: exception
1150: when app_exception.application_exception then
1151: if hr_multi_message.exception_add
1152: (p_associated_column1 => 'PER_PREVIOUS_JOBS.START_DATE'
1152: (p_associated_column1 => 'PER_PREVIOUS_JOBS.START_DATE'
1153: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.END_DATE'
1154: ,p_associated_column3 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'
1155: ) then
1156: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1157: raise;
1158: end if;
1159: hr_utility.set_location(' Leaving:'|| l_proc, 35);
1160: end chk_pjo_start_end_dates;
1155: ) then
1156: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1157: raise;
1158: end if;
1159: hr_utility.set_location(' Leaving:'|| l_proc, 35);
1160: end chk_pjo_start_end_dates;
1161: --
1162: -- -----------------------------------------------------------------------
1163: -- |---------------------------< chk_all_assignments >-------------------|
1203: --
1204: l_proc varchar2(72) := g_package||'chk_all_assignments';
1205: l_api_updating boolean;
1206: begin
1207: hr_utility.set_location('Entering:'||l_proc, 5);
1208: --
1209: if hr_multi_message.no_exclusive_error
1210: (p_check_column1 => 'PER_PREVIOUS_JOBS.PREVIOUS_JOB_ID'
1211: ) then
1209: if hr_multi_message.no_exclusive_error
1210: (p_check_column1 => 'PER_PREVIOUS_JOBS.PREVIOUS_JOB_ID'
1211: ) then
1212: if p_all_assignments is not null then
1213: hr_utility.set_location(l_proc, 10);
1214: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id
1215: => p_previous_job_id
1216: ,p_object_version_number
1217: => p_object_version_number);
1219: nvl(p_all_assignments,hr_api.g_varchar2)
1220: <> nvl(per_pjo_shd.g_old_rec.all_assignments,hr_api.g_varchar2)
1221: ) or
1222: (not l_api_updating)) then
1223: hr_utility.set_location(l_proc, 15);
1224: if p_all_assignments = 'Y' or p_all_assignments = 'N' then
1225: hr_utility.set_location(l_proc, 20);
1226: if p_all_assignments = 'Y' then
1227: hr_utility.set_location(l_proc, 25);
1221: ) or
1222: (not l_api_updating)) then
1223: hr_utility.set_location(l_proc, 15);
1224: if p_all_assignments = 'Y' or p_all_assignments = 'N' then
1225: hr_utility.set_location(l_proc, 20);
1226: if p_all_assignments = 'Y' then
1227: hr_utility.set_location(l_proc, 25);
1228: open csr_pjo_assignments;
1229: fetch csr_pjo_assignments into l_previous_job_usage_id;
1223: hr_utility.set_location(l_proc, 15);
1224: if p_all_assignments = 'Y' or p_all_assignments = 'N' then
1225: hr_utility.set_location(l_proc, 20);
1226: if p_all_assignments = 'Y' then
1227: hr_utility.set_location(l_proc, 25);
1228: open csr_pjo_assignments;
1229: fetch csr_pjo_assignments into l_previous_job_usage_id;
1230: if csr_pjo_assignments%found then
1231: hr_utility.set_location(l_proc, 30);
1227: hr_utility.set_location(l_proc, 25);
1228: open csr_pjo_assignments;
1229: fetch csr_pjo_assignments into l_previous_job_usage_id;
1230: if csr_pjo_assignments%found then
1231: hr_utility.set_location(l_proc, 30);
1232: close csr_pjo_assignments;
1233: fnd_message.set_name('PER','HR_289546_PEM_ALL_ASG_MOD_NA');
1234: hr_multi_message.add
1235: (p_associated_column1 => 'PER_PREVIOUS_JOBS.
1240: close csr_pjo_assignments;
1241: end if;
1242: end if;
1243: else
1244: hr_utility.set_location(l_proc, 35);
1245: fnd_message.set_name('PER','HR_289545_PEM_VALID_ASGMT_FLAG');
1246: hr_multi_message.add
1247: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PREVIOUS_JOB_ID'
1248: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.ALL_ASSIGNMENTS'
1251: end if;
1252: end if;
1253: end if;
1254: --
1255: hr_utility.set_location('Leaving:'||l_proc, 40);
1256: end chk_all_assignments;
1257: --
1258: -- ----------------------------------------------------------------------------
1259: -- |---------------------------< insert_validate >----------------------------|
1265: --
1266: l_proc varchar2(72) := g_package||'insert_validate';
1267: --
1268: Begin
1269: hr_utility.set_location('Entering:'||l_proc, 5);
1270: --
1271: -- Call all supporting business operations
1272: hr_utility.set_location(l_proc, 10);
1273: hr_api.mandatory_arg_error
1268: Begin
1269: hr_utility.set_location('Entering:'||l_proc, 5);
1270: --
1271: -- Call all supporting business operations
1272: hr_utility.set_location(l_proc, 10);
1273: hr_api.mandatory_arg_error
1274: (p_api_name => l_proc
1275: ,p_argument => 'EFFECTIVE_DATE'
1276: ,p_argument_value => p_effective_date
1275: ,p_argument => 'EFFECTIVE_DATE'
1276: ,p_argument_value => p_effective_date
1277: );
1278: --
1279: hr_utility.set_location(l_proc, 15);
1280: chk_previous_employer_id(p_previous_employer_id
1281: => p_rec.previous_employer_id
1282: ,p_previous_job_id
1283: => p_rec.previous_job_id
1283: => p_rec.previous_job_id
1284: ,p_object_version_number
1285: => p_rec.object_version_number);
1286: --
1287: hr_utility.set_location(l_proc, 20);
1288: chk_start_end_dates(p_previous_job_id
1289: => p_rec.previous_job_id
1290: ,p_object_version_number
1291: => p_rec.object_version_number
1293: => p_rec.start_date
1294: ,p_end_date
1295: => p_rec.end_date);
1296: --
1297: hr_utility.set_location(l_proc, 25);
1298: chk_pjo_start_end_dates(p_previous_job_id
1299: => p_rec.previous_job_id
1300: ,p_previous_employer_id
1301: => p_rec.previous_employer_id
1307: => p_rec.end_date
1308: ,p_effective_date
1309: => p_effective_date); -- bug 7112425
1310: --
1311: hr_utility.set_location(l_proc, 30);
1312: chk_employment_category(p_previous_job_id
1313: => p_rec.previous_job_id
1314: ,p_object_version_number
1315: => p_rec.object_version_number
1317: => p_rec.employment_category
1318: ,p_effective_date
1319: => p_effective_date);
1320: --
1321: hr_utility.set_location(l_proc, 35);
1322: chk_period_years(p_period_years
1323: => p_rec.period_years
1324: ,p_previous_job_id
1325: => p_rec.previous_job_id
1325: => p_rec.previous_job_id
1326: ,p_object_version_number
1327: => p_rec.object_version_number);
1328: --
1329: hr_utility.set_location(l_proc, 40);
1330: chk_period_months(p_period_months
1331: => p_rec.period_months
1332: ,p_previous_job_id
1333: => p_rec.previous_job_id
1333: => p_rec.previous_job_id
1334: ,p_object_version_number
1335: => p_rec.object_version_number);
1336: --
1337: hr_utility.set_location(l_proc, 45);
1338: chk_period_days(p_period_days
1339: => p_rec.period_days
1340: ,p_previous_job_id
1341: => p_rec.previous_job_id
1341: => p_rec.previous_job_id
1342: ,p_object_version_number
1343: => p_rec.object_version_number);
1344: --
1345: hr_utility.set_location(l_proc, 50);
1346: chk_all_assignments(p_previous_job_id
1347: => p_rec.previous_job_id
1348: ,p_object_version_number
1349: => p_rec.object_version_number
1349: => p_rec.object_version_number
1350: ,p_all_assignments
1351: => p_rec.all_assignments);
1352: --
1353: hr_utility.set_location(l_proc, 55);
1354: per_pjo_bus.chk_ddf(p_rec);
1355: --
1356: hr_utility.set_location(l_proc, 60);
1357: per_pjo_bus.chk_df(p_rec);
1352: --
1353: hr_utility.set_location(l_proc, 55);
1354: per_pjo_bus.chk_ddf(p_rec);
1355: --
1356: hr_utility.set_location(l_proc, 60);
1357: per_pjo_bus.chk_df(p_rec);
1358: --
1359: hr_utility.set_location(' Leaving:'||l_proc, 65);
1360: End insert_validate;
1355: --
1356: hr_utility.set_location(l_proc, 60);
1357: per_pjo_bus.chk_df(p_rec);
1358: --
1359: hr_utility.set_location(' Leaving:'||l_proc, 65);
1360: End insert_validate;
1361: --
1362: -- ----------------------------------------------------------------------------
1363: -- |---------------------------< update_validate >----------------------------|
1369: --
1370: l_proc varchar2(72) := g_package||'update_validate';
1371: --
1372: Begin
1373: hr_utility.set_location('Entering:'||l_proc, 5);
1374: --
1375: -- Call all supporting business operations
1376: --
1377: hr_utility.set_location(l_proc, 10);
1373: hr_utility.set_location('Entering:'||l_proc, 5);
1374: --
1375: -- Call all supporting business operations
1376: --
1377: hr_utility.set_location(l_proc, 10);
1378: hr_api.mandatory_arg_error
1379: (p_api_name => l_proc
1380: ,p_argument => 'EFFECTIVE_DATE'
1381: ,p_argument_value => p_effective_date
1385: (p_effective_date => p_effective_date
1386: ,p_rec => p_rec
1387: );
1388: --
1389: hr_utility.set_location(l_proc, 20);
1390: chk_start_end_dates(p_previous_job_id => p_rec.previous_job_id
1391: ,p_object_version_number => p_rec.object_version_number
1392: ,p_start_date => p_rec.start_date
1393: ,p_end_date => p_rec.end_date);
1391: ,p_object_version_number => p_rec.object_version_number
1392: ,p_start_date => p_rec.start_date
1393: ,p_end_date => p_rec.end_date);
1394: --
1395: hr_utility.set_location(l_proc, 25);
1396: chk_employment_category(p_previous_job_id
1397: => p_rec.previous_job_id
1398: ,p_object_version_number
1399: => p_rec.object_version_number
1401: => p_rec.employment_category
1402: ,p_effective_date
1403: => p_effective_date);
1404: --
1405: hr_utility.set_location(l_proc, 30);
1406: chk_period_years(p_period_years
1407: => p_rec.period_years
1408: ,p_previous_job_id
1409: => p_rec.previous_job_id
1409: => p_rec.previous_job_id
1410: ,p_object_version_number
1411: => p_rec.object_version_number);
1412: --
1413: hr_utility.set_location(l_proc, 35);
1414: chk_period_months(p_period_months
1415: => p_rec.period_months
1416: ,p_previous_job_id
1417: => p_rec.previous_job_id
1417: => p_rec.previous_job_id
1418: ,p_object_version_number
1419: => p_rec.object_version_number);
1420: --
1421: hr_utility.set_location(l_proc, 40);
1422: chk_period_days(p_period_days
1423: => p_rec.period_days
1424: ,p_previous_job_id
1425: => p_rec.previous_job_id
1425: => p_rec.previous_job_id
1426: ,p_object_version_number
1427: => p_rec.object_version_number);
1428: --
1429: hr_utility.set_location(l_proc, 45);
1430: chk_pjo_start_end_dates(p_previous_job_id
1431: => p_rec.previous_job_id
1432: ,p_previous_employer_id
1433: => p_rec.previous_employer_id
1439: => p_rec.end_date
1440: ,p_effective_date
1441: => p_effective_date); -- bug 7112425
1442: --
1443: hr_utility.set_location(l_proc, 50);
1444: chk_all_assignments(p_previous_job_id => p_rec.previous_job_id
1445: ,p_object_version_number => p_rec.object_version_number
1446: ,p_all_assignments => p_rec.all_assignments);
1447: --
1444: chk_all_assignments(p_previous_job_id => p_rec.previous_job_id
1445: ,p_object_version_number => p_rec.object_version_number
1446: ,p_all_assignments => p_rec.all_assignments);
1447: --
1448: hr_utility.set_location(l_proc, 55);
1449: per_pjo_bus.chk_ddf(p_rec);
1450: --
1451: hr_utility.set_location(l_proc, 60);
1452: per_pjo_bus.chk_df(p_rec);
1447: --
1448: hr_utility.set_location(l_proc, 55);
1449: per_pjo_bus.chk_ddf(p_rec);
1450: --
1451: hr_utility.set_location(l_proc, 60);
1452: per_pjo_bus.chk_df(p_rec);
1453: --
1454: hr_utility.set_location(l_proc, 65);
1455: hr_utility.set_location(' Leaving:'||l_proc, 70);
1450: --
1451: hr_utility.set_location(l_proc, 60);
1452: per_pjo_bus.chk_df(p_rec);
1453: --
1454: hr_utility.set_location(l_proc, 65);
1455: hr_utility.set_location(' Leaving:'||l_proc, 70);
1456: End update_validate;
1457: --
1458: -- ----------------------------------------------------------------------------
1451: hr_utility.set_location(l_proc, 60);
1452: per_pjo_bus.chk_df(p_rec);
1453: --
1454: hr_utility.set_location(l_proc, 65);
1455: hr_utility.set_location(' Leaving:'||l_proc, 70);
1456: End update_validate;
1457: --
1458: -- ----------------------------------------------------------------------------
1459: -- |---------------------------< delete_validate >----------------------------|
1464: --
1465: l_proc varchar2(72) := g_package||'delete_validate';
1466: --
1467: Begin
1468: hr_utility.set_location('Entering:'||l_proc, 5);
1469: --
1470: -- Call all supporting business operations
1471: --
1472: hr_utility.set_location(' Leaving:'||l_proc, 10);
1468: hr_utility.set_location('Entering:'||l_proc, 5);
1469: --
1470: -- Call all supporting business operations
1471: --
1472: hr_utility.set_location(' Leaving:'||l_proc, 10);
1473: End delete_validate;
1474: --
1475: -- ---------------------------------------------------------------------------
1476: -- |--------------------------< return_leg_code >----------------------------|
1495: l_proc varchar2(72) := g_package||'return_leg_code';
1496: --
1497: Begin
1498: --
1499: hr_utility.set_location('Entering:'|| l_proc, 10);
1500: --
1501: -- Ensure that all the mandatory parameter are not null
1502: hr_api.mandatory_arg_error
1503: (p_api_name => l_proc
1509: --
1510: -- The legislation code has already been found with a previous
1511: -- call to this function. Just return the value in the global variable.
1512: l_legislation_code := per_pjo_bus.g_legislation_code;
1513: hr_utility.set_location(l_proc, 20);
1514: --
1515: else
1516: --
1517: -- The ID is different to the last call to this function
1522: if csr_leg_code%notfound then
1523: --
1524: -- The primary key is invalid therefore we must error
1525: close csr_leg_code;
1526: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1527: hr_utility.raise_error;
1528: --
1529: end if;
1530: --
1523: --
1524: -- The primary key is invalid therefore we must error
1525: close csr_leg_code;
1526: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1527: hr_utility.raise_error;
1528: --
1529: end if;
1530: --
1531: hr_utility.set_location(l_proc,30);
1527: hr_utility.raise_error;
1528: --
1529: end if;
1530: --
1531: hr_utility.set_location(l_proc,30);
1532: --
1533: -- Set the global variables so the values are
1534: -- available for the next call to this function.
1535: close csr_leg_code;
1537: per_pjo_bus.g_legislation_code := l_legislation_code;
1538: --
1539: end if;
1540: --
1541: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1542: --
1543: return l_legislation_code;
1544: --
1545: end return_leg_code;