71: --
72: -- The primary key is invalid therefore we must error
73: --
74: close csr_leg_code;
75: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
76: fnd_message.raise_error;
77: end if;
78: hr_utility.set_location(l_proc,30);
79: --
72: -- The primary key is invalid therefore we must error
73: --
74: close csr_leg_code;
75: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
76: fnd_message.raise_error;
77: end if;
78: hr_utility.set_location(l_proc,30);
79: --
80: -- Set the global variables so the values are
133: IF NOT hr_pde_shd.api_updating
134: (p_person_deplymt_eit_id => p_rec.person_deplymt_eit_id
135: ,p_object_version_number => p_rec.object_version_number
136: ) THEN
137: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
138: fnd_message.set_token('PROCEDURE ', l_proc);
139: fnd_message.set_token('STEP ', '5');
140: fnd_message.raise_error;
141: END IF;
134: (p_person_deplymt_eit_id => p_rec.person_deplymt_eit_id
135: ,p_object_version_number => p_rec.object_version_number
136: ) THEN
137: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
138: fnd_message.set_token('PROCEDURE ', l_proc);
139: fnd_message.set_token('STEP ', '5');
140: fnd_message.raise_error;
141: END IF;
142: --
135: ,p_object_version_number => p_rec.object_version_number
136: ) THEN
137: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
138: fnd_message.set_token('PROCEDURE ', l_proc);
139: fnd_message.set_token('STEP ', '5');
140: fnd_message.raise_error;
141: END IF;
142: --
143: hr_utility.set_location (l_proc, 20);
136: ) THEN
137: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
138: fnd_message.set_token('PROCEDURE ', l_proc);
139: fnd_message.set_token('STEP ', '5');
140: fnd_message.raise_error;
141: END IF;
142: --
143: hr_utility.set_location (l_proc, 20);
144: --
219: open csr_deployment;
220: fetch csr_deployment into l_dummy;
221: if csr_deployment%notfound then
222: close csr_deployment;
223: fnd_message.set_name('PER','HR_449609_DPL_NOT_EXIST');
224: fnd_message.raise_error;
225: else
226: close csr_deployment;
227: end if;
220: fetch csr_deployment into l_dummy;
221: if csr_deployment%notfound then
222: close csr_deployment;
223: fnd_message.set_name('PER','HR_449609_DPL_NOT_EXIST');
224: fnd_message.raise_error;
225: else
226: close csr_deployment;
227: end if;
228: --
332: fetch csr_get_host_bg_leg into l_host_bg_leg;
333: close csr_get_host_bg_leg;
334: --
335: if l_eit_leg <> l_host_bg_leg then
336: fnd_message.set_name('PER','HR_449653_PDE_EIT_WRONG_LEG');
337: fnd_message.raise_error;
338: end if;
339: end if;
340: else --EIT does not belong to right person
333: close csr_get_host_bg_leg;
334: --
335: if l_eit_leg <> l_host_bg_leg then
336: fnd_message.set_name('PER','HR_449653_PDE_EIT_WRONG_LEG');
337: fnd_message.raise_error;
338: end if;
339: end if;
340: else --EIT does not belong to right person
341: close csr_check_person;
338: end if;
339: end if;
340: else --EIT does not belong to right person
341: close csr_check_person;
342: fnd_message.set_name('PER','HR_449612_PDE_WRONG_PERSON');
343: fnd_message.raise_error;
344: end if;
345: else --EIT does not exist
346: close csr_extra_info;
339: end if;
340: else --EIT does not belong to right person
341: close csr_check_person;
342: fnd_message.set_name('PER','HR_449612_PDE_WRONG_PERSON');
343: fnd_message.raise_error;
344: end if;
345: else --EIT does not exist
346: close csr_extra_info;
347: fnd_message.set_name('PER','HR_449613_PDE_EIT_NOT_EXIST');
343: fnd_message.raise_error;
344: end if;
345: else --EIT does not exist
346: close csr_extra_info;
347: fnd_message.set_name('PER','HR_449613_PDE_EIT_NOT_EXIST');
348: fnd_message.raise_error;
349: end if;
350: --
351: end chk_person_extra_info_id;
344: end if;
345: else --EIT does not exist
346: close csr_extra_info;
347: fnd_message.set_name('PER','HR_449613_PDE_EIT_NOT_EXIST');
348: fnd_message.raise_error;
349: end if;
350: --
351: end chk_person_extra_info_id;
352: --