[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_ROW_ID')
64: );
65: --
205: hr_utility.set_location(' Leaving:'|| l_proc, 20);
206: --
207: exception
208: when app_exception.application_exception then
209: if hr_multi_message.exception_add
210: (p_associated_column1 => 'PAY_USER_ROWS_F.LEGISLATION_CODE'
211: ) then
212: raise;
213: end if;
407: hr_utility.set_location(' Leaving:'|| l_proc, 20);
408:
409: exception
410: when app_exception.application_exception then
411: if hr_multi_message.exception_add
412: (p_associated_column1 => 'PAY_USER_ROWS_F.USER_TABLE_ID'
413: ) then
414: raise;
415: end if;
591: begin
592:
593: hr_utility.set_location('Entering:'|| l_proc, 10);
594:
595: if hr_multi_message.no_exclusive_error
596: (p_check_column1 => 'PAY_USER_ROWS_F.USER_TABLE_ID'
597: ,p_associated_column1 => 'PAY_USER_ROWS_F.ROW_LOW_RANGE_OR_NAME'
598: ) and (
599: not pay_pur_shd.api_updating
681:
682: exception
683:
684: when app_exception.application_exception then
685: if hr_multi_message.exception_add
686: (p_associated_column1 => 'PAY_USER_ROWS_F.ROW_LOW_RANGE_OR_NAME') then
687: raise;
688: end if;
689:
745: begin
746:
747: hr_utility.set_location('Entering:'|| l_proc, 10);
748:
749: if hr_multi_message.no_exclusive_error
750: (p_check_column1 => 'PAY_USER_ROWS_F.USER_TABLE_ID'
751: ,p_associated_column1 => 'PAY_USER_ROWS_F.ROW_HIGH_RANGE'
752: ) and (
753: not pay_pur_shd.api_updating
790:
791: exception
792:
793: when app_exception.application_exception then
794: if hr_multi_message.exception_add
795: (p_associated_column1 => 'PAY_USER_ROWS_F.ROW_HIGH_RANGE') then
796: raise;
797: end if;
798:
899: begin
900:
901: hr_utility.set_location('Entering:'|| l_proc, 10);
902:
903: if hr_multi_message.no_exclusive_error
904: ( p_check_column1 => 'PAY_USER_ROWS_F.ROW_LOW_RANGE_OR_NAME'
905: ,p_check_column2 => 'PAY_USER_ROWS_F.ROW_HIGH_RANGE'
906: ,p_associated_column1 => 'PAY_USER_ROWS_F.ROW_LOW_RANGE_OR_NAME'
907: ,p_associated_column2 => 'PAY_USER_ROWS_F.ROW_HIGH_RANGE'
972:
973: exception
974:
975: when app_exception.application_exception then
976: if hr_multi_message.exception_add
977: (p_associated_column1 => 'PAY_USER_ROWS_F.ROW_LOW_RANGE_OR_NAME' ,
978: p_associated_column2 => 'PAY_USER_ROWS_F.ROW_HIGH_RANGE' ) then
979: raise;
980: end if;
1030:
1031: Exception
1032:
1033: when app_exception.application_exception then
1034: if hr_multi_message.exception_add
1035: (p_associated_column1 => 'PAY_USER_ROWS_F.DISPLAY_SEQUENCE' ) then
1036: raise;
1037: end if;
1038:
1254: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1255: Exception
1256:
1257: when app_exception.application_exception then
1258: if hr_multi_message.exception_add
1259: (p_associated_column1 => 'PAY_USER_ROWS_F.USER_ROW_ID') then
1260: raise;
1261: end if;
1262:
1632: -- after validating the set of important attributes,
1633: -- if Multiple Message Detection is enabled and at least
1634: -- one error has been found then abort further validation.
1635: --
1636: hr_multi_message.end_validation_set;
1637:
1638: END IF;
1639: --
1640:
1644: -- Validate Important Attributes
1645: --
1646: chk_legislation_code(p_legislation_code => p_rec.legislation_code);
1647: --
1648: hr_multi_message.end_validation_set;
1649:
1650: end if;
1651: --
1652: --
1749: -- After validating the set of important attributes,
1750: -- if Multiple Message Detection is enabled and at least
1751: -- one error has been found then abort further validation.
1752: --
1753: hr_multi_message.end_validation_set;
1754: END IF;
1755: --
1756: --
1757: -- Validate Dependent Attributes
1851: -- After validating the set of important attributes,
1852: -- if Multiple Message Detection is enabled and at least
1853: -- one error has been found then abort further validation.
1854: --
1855: hr_multi_message.end_validation_set;
1856: END IF;
1857: --
1858: -- Call all supporting business operations
1859: --