[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
682:
683: exception
684:
685: when app_exception.application_exception then
686: if hr_multi_message.exception_add
687: (p_associated_column1 => 'PAY_USER_ROWS_F.ROW_LOW_RANGE_OR_NAME') then
688: raise;
689: end if;
690:
746: begin
747:
748: hr_utility.set_location('Entering:'|| l_proc, 10);
749:
750: if hr_multi_message.no_exclusive_error
751: (p_check_column1 => 'PAY_USER_ROWS_F.USER_TABLE_ID'
752: ,p_associated_column1 => 'PAY_USER_ROWS_F.ROW_HIGH_RANGE'
753: ) and (
754: not pay_pur_shd.api_updating
791:
792: exception
793:
794: when app_exception.application_exception then
795: if hr_multi_message.exception_add
796: (p_associated_column1 => 'PAY_USER_ROWS_F.ROW_HIGH_RANGE') then
797: raise;
798: end if;
799:
900: begin
901:
902: hr_utility.set_location('Entering:'|| l_proc, 10);
903:
904: if hr_multi_message.no_exclusive_error
905: ( p_check_column1 => 'PAY_USER_ROWS_F.ROW_LOW_RANGE_OR_NAME'
906: ,p_check_column2 => 'PAY_USER_ROWS_F.ROW_HIGH_RANGE'
907: ,p_associated_column1 => 'PAY_USER_ROWS_F.ROW_LOW_RANGE_OR_NAME'
908: ,p_associated_column2 => 'PAY_USER_ROWS_F.ROW_HIGH_RANGE'
975:
976: exception
977:
978: when app_exception.application_exception then
979: if hr_multi_message.exception_add
980: (p_associated_column1 => 'PAY_USER_ROWS_F.ROW_LOW_RANGE_OR_NAME' ,
981: p_associated_column2 => 'PAY_USER_ROWS_F.ROW_HIGH_RANGE' ) then
982: raise;
983: end if;
1033:
1034: Exception
1035:
1036: when app_exception.application_exception then
1037: if hr_multi_message.exception_add
1038: (p_associated_column1 => 'PAY_USER_ROWS_F.DISPLAY_SEQUENCE' ) then
1039: raise;
1040: end if;
1041:
1257: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1258: Exception
1259:
1260: when app_exception.application_exception then
1261: if hr_multi_message.exception_add
1262: (p_associated_column1 => 'PAY_USER_ROWS_F.USER_ROW_ID') then
1263: raise;
1264: end if;
1265:
1635: -- after validating the set of important attributes,
1636: -- if Multiple Message Detection is enabled and at least
1637: -- one error has been found then abort further validation.
1638: --
1639: hr_multi_message.end_validation_set;
1640:
1641: END IF;
1642: --
1643:
1647: -- Validate Important Attributes
1648: --
1649: chk_legislation_code(p_legislation_code => p_rec.legislation_code);
1650: --
1651: hr_multi_message.end_validation_set;
1652:
1653: end if;
1654: --
1655: --
1752: -- After validating the set of important attributes,
1753: -- if Multiple Message Detection is enabled and at least
1754: -- one error has been found then abort further validation.
1755: --
1756: hr_multi_message.end_validation_set;
1757: END IF;
1758: --
1759: --
1760: -- Validate Dependent Attributes
1854: -- After validating the set of important attributes,
1855: -- if Multiple Message Detection is enabled and at least
1856: -- one error has been found then abort further validation.
1857: --
1858: hr_multi_message.end_validation_set;
1859: END IF;
1860: --
1861: -- Call all supporting business operations
1862: --