[Home] [Help]
62: --
63: -- The primary key is invalid therefore we must error
64: --
65: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
66: hr_multi_message.add
67: (p_associated_column1
68: => nvl(p_associated_column1,'PREVIOUS_JOB_ID')
69: );
70: --
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'
659: ) then
660: hr_utility.set_location(' Leaving:'|| l_proc, 30);
661: raise;
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'
736: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.END_DATE'
737: ) then
738: hr_utility.set_location(' Leaving:'|| l_proc, 50);
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'
820: ) then
821: hr_utility.set_location(' Leaving:'|| l_proc, 50);
822: raise;
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'
893: ) then
894: hr_utility.set_location(' Leaving:'|| l_proc, 40);
895: raise;
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'
966: ) then
967: hr_utility.set_location(' Leaving:'|| l_proc, 40);
968: raise;
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'
1039: ) then
1040: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1041: raise;
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'
1108: ,p_check_column3 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'
1109: ) THEN
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'
1153: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.END_DATE'
1154: ,p_associated_column3 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'
1155: ) then
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
1212: if p_all_assignments is not null then
1213: hr_utility.set_location(l_proc, 10);
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.
1236: PREVIOUS_JOB_ID'
1237: );
1238: 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'
1249: );
1250: end if;