37: hr_utility.set_location(' Leaving:'|| l_proc, 20);
38: --
39: exception
40: when no_data_found then
41: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
42: fnd_message.raise_error;
43: end get_business_group_id;
44:
45: --
38: --
39: exception
40: when no_data_found then
41: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
42: fnd_message.raise_error;
43: end get_business_group_id;
44:
45: --
46: -- ---------------------------------------------------------------------------
85: close csr_sec_grp;
86: --
87: -- The primary key is invalid therefore we must error
88: --
89: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
90: fnd_message.raise_error;
91: --
92: end if;
93: close csr_sec_grp;
86: --
87: -- The primary key is invalid therefore we must error
88: --
89: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
90: fnd_message.raise_error;
91: --
92: end if;
93: close csr_sec_grp;
94: --
158: --
159: -- The primary key is invalid therefore we must error
160: --
161: close csr_leg_code;
162: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
163: fnd_message.raise_error;
164: end if;
165: hr_utility.set_location(l_proc,30);
166: --
159: -- The primary key is invalid therefore we must error
160: --
161: close csr_leg_code;
162: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
163: fnd_message.raise_error;
164: end if;
165: hr_utility.set_location(l_proc,30);
166: --
167: -- Set the global variables so the values are
463: IF NOT per_psv_shd.api_updating
464: (p_pos_structure_version_id => p_rec.pos_structure_version_id
465: ,p_object_version_number => p_rec.object_version_number
466: ) THEN
467: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
468: fnd_message.set_token('PROCEDURE ', l_proc);
469: fnd_message.set_token('STEP ', '5');
470: fnd_message.raise_error;
471: END IF;
464: (p_pos_structure_version_id => p_rec.pos_structure_version_id
465: ,p_object_version_number => p_rec.object_version_number
466: ) THEN
467: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
468: fnd_message.set_token('PROCEDURE ', l_proc);
469: fnd_message.set_token('STEP ', '5');
470: fnd_message.raise_error;
471: END IF;
472: --
465: ,p_object_version_number => p_rec.object_version_number
466: ) THEN
467: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
468: fnd_message.set_token('PROCEDURE ', l_proc);
469: fnd_message.set_token('STEP ', '5');
470: fnd_message.raise_error;
471: END IF;
472: --
473: -- EDIT_HERE: Add checks to ensure non-updateable args have
466: ) THEN
467: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
468: fnd_message.set_token('PROCEDURE ', l_proc);
469: fnd_message.set_token('STEP ', '5');
470: fnd_message.raise_error;
471: END IF;
472: --
473: -- EDIT_HERE: Add checks to ensure non-updateable args have
474: -- not been updated.