55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
64: --
128: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
188: IF NOT per_ose_shd.api_updating
189: (p_org_structure_element_id => p_rec.org_structure_element_id
190: ,p_object_version_number => p_rec.object_version_number
191: ) THEN
192: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
193: fnd_message.set_token('PROCEDURE ', l_proc);
194: fnd_message.set_token('STEP ', '5');
195: fnd_message.raise_error;
196: END IF;
189: (p_org_structure_element_id => p_rec.org_structure_element_id
190: ,p_object_version_number => p_rec.object_version_number
191: ) THEN
192: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
193: fnd_message.set_token('PROCEDURE ', l_proc);
194: fnd_message.set_token('STEP ', '5');
195: fnd_message.raise_error;
196: END IF;
197: --
190: ,p_object_version_number => p_rec.object_version_number
191: ) THEN
192: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
193: fnd_message.set_token('PROCEDURE ', l_proc);
194: fnd_message.set_token('STEP ', '5');
195: fnd_message.raise_error;
196: END IF;
197: --
198: -- EDIT_HERE: Add checks to ensure non-updateable args have
191: ) THEN
192: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
193: fnd_message.set_token('PROCEDURE ', l_proc);
194: fnd_message.set_token('STEP ', '5');
195: fnd_message.raise_error;
196: END IF;
197: --
198: -- EDIT_HERE: Add checks to ensure non-updateable args have
199: -- not been updated.
715: ,p_organization_id => p_rec.organization_id_child
716: ,p_exists_in_hierarchy => l_exists_in_hierarchy
717: );
718: if l_exists_in_hierarchy = 'Y' then
719: fnd_message.set_name('PER', 'HR_289572_EXISTS_IN_HIERARCHY');
720: fnd_message.raise_error;
721: end if;
722: --
723: hr_utility.set_location(' Leaving:'||l_proc, 10);
716: ,p_exists_in_hierarchy => l_exists_in_hierarchy
717: );
718: if l_exists_in_hierarchy = 'Y' then
719: fnd_message.set_name('PER', 'HR_289572_EXISTS_IN_HIERARCHY');
720: fnd_message.raise_error;
721: end if;
722: --
723: hr_utility.set_location(' Leaving:'||l_proc, 10);
724: End insert_validate;
776: ,p_exists_in_hierarchy => l_exists_in_hierarchy
777: );
778:
779: if l_exists_in_hierarchy = 'Y' then
780: fnd_message.set_name('PER', 'HR_289572_EXISTS_IN_HIERARCHY');
781: fnd_message.raise_error;
782: end if;
783: */
784:
777: );
778:
779: if l_exists_in_hierarchy = 'Y' then
780: fnd_message.set_name('PER', 'HR_289572_EXISTS_IN_HIERARCHY');
781: fnd_message.raise_error;
782: end if;
783: */
784:
785: hr_utility.set_location(' Leaving:'||l_proc, 10);