[Home] [Help]
57: --
58: -- The primary key is invalid therefore we must error
59: --
60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
61: hr_multi_message.add
62: (p_associated_column1
63: => nvl(p_associated_column1,'USER_COLUMN_INSTANCE_ID')
64: );
65: --
315: ,p_from_date => p_validation_start_date
316: ,p_to_date => p_validation_end_date))) Then
317: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
318: fnd_message.set_token('TABLE_NAME','user rows');
319: hr_multi_message.add
320: (p_associated_column1 => pay_uci_shd.g_tab_nam || '.USER_ROW_ID');
321: End If;
322: --
323: Exception
531: hr_utility.set_location(' Leaving:'|| l_proc, 20);
532: --
533: exception
534: when app_exception.application_exception then
535: if hr_multi_message.exception_add
536: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.LEGISLATION_CODE'
537: ) then
538: raise;
539: end if;
637: hr_utility.set_location(' Leaving:'|| l_proc, 20);
638:
639: exception
640: when app_exception.application_exception then
641: if hr_multi_message.exception_add
642: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'
643: ) then
644: raise;
645: end if;
735: hr_utility.set_location(' Leaving:'|| l_proc, 20);
736:
737: exception
738: when app_exception.application_exception then
739: if hr_multi_message.exception_add
740: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
741: ) then
742: raise;
743: end if;
818: begin
819:
820: hr_utility.set_location('Entering:'|| l_proc, 10);
821:
822: if hr_multi_message.no_exclusive_error
823: (p_check_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'
824: ,p_check_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
825: ,p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'
826: ,p_associated_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
842:
843: exception
844:
845: when app_exception.application_exception then
846: if hr_multi_message.exception_add
847: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID',
848: p_associated_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID') then
849: raise;
850: end if;
940:
941: hr_utility.set_location(' Entering:'||l_proc, 10);
942: --
943:
944: if hr_multi_message.no_exclusive_error
945: (p_check_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
946: ,p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.VALUE'
947: ) and (
948: not pay_uci_shd.api_updating
1055: hr_utility.set_location(' Leaving:'||l_proc, 50);
1056:
1057: Exception
1058: when app_exception.application_exception then
1059: if hr_multi_message.exception_add
1060: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.VALUE') then
1061: raise;
1062: end if;
1063:
1111: -- after validating the set of important attributes,
1112: -- if Multiple Message Detection is enabled and at least
1113: -- one error has been found then abort further validation.
1114: --
1115: hr_multi_message.end_validation_set;
1116: END IF;
1117: --
1118:
1119: if hr_startup_data_api_support.g_startup_mode not in ('GENERIC','USER') then
1122: -- Validate Important Attributes
1123: --
1124: chk_legislation_code(p_legislation_code => p_rec.legislation_code);
1125: --
1126: hr_multi_message.end_validation_set;
1127:
1128: end if;
1129: --
1130: --
1205: -- After validating the set of important attributes,
1206: -- if Multiple Message Detection is enabled and at least
1207: -- one error has been found then abort further validation.
1208: --
1209: hr_multi_message.end_validation_set;
1210: END IF;
1211: --
1212: --
1213: -- Validate Dependent Attributes
1271: -- After validating the set of important attributes,
1272: -- if Multiple Message Detection is enabled and at least
1273: -- one error has been found then abort further validation.
1274: --
1275: hr_multi_message.end_validation_set;
1276: END IF;
1277: --
1278: -- Call all supporting business operations
1279: --