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_pdc_shd.api_updating
134: (p_person_deplymt_contact_id => p_rec.person_deplymt_contact_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_contact_id => p_rec.person_deplymt_contact_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_44609_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_44609_DPL_NOT_EXIST');
224: fnd_message.raise_error;
225: else
226: close csr_deployment;
227: end if;
228: --
305: fetch csr_check_person into l_dummy;
306: if csr_check_person%notfound then
307: close csr_check_person;
308: --
309: fnd_message.set_name('PER','HR_449610_PDC_WRONG_PERSON');
310: fnd_message.raise_error;
311: else --relationship does not belong to right person
312: close csr_check_person;
313: end if;
306: if csr_check_person%notfound then
307: close csr_check_person;
308: --
309: fnd_message.set_name('PER','HR_449610_PDC_WRONG_PERSON');
310: fnd_message.raise_error;
311: else --relationship does not belong to right person
312: close csr_check_person;
313: end if;
314: else --relationship does not exist
313: end if;
314: else --relationship does not exist
315: close csr_contact_rel;
316: --
317: fnd_message.set_name('PER','HR_449611_PDC_REL_NOT_EXIST');
318: fnd_message.raise_error;
319: end if;
320: --
321: end chk_contact_relationship_id;
314: else --relationship does not exist
315: close csr_contact_rel;
316: --
317: fnd_message.set_name('PER','HR_449611_PDC_REL_NOT_EXIST');
318: fnd_message.raise_error;
319: end if;
320: --
321: end chk_contact_relationship_id;
322: --