67: close csr_sec_grp;
68: --
69: -- The primary key is invalid therefore we must error
70: --
71: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
72: hr_multi_message.add
73: (p_associated_column1
74: => nvl(p_associated_column1,'VEH_ALLOC_EXTRA_INFO_ID')
75: );
148: --
149: -- The primary key is invalid therefore we must error
150: --
151: close csr_leg_code;
152: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
153: fnd_message.raise_error;
154: end if;
155: hr_utility.set_location(l_proc,30);
156: --
149: -- The primary key is invalid therefore we must error
150: --
151: close csr_leg_code;
152: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
153: fnd_message.raise_error;
154: end if;
155: hr_utility.set_location(l_proc,30);
156: --
157: -- Set the global variables so the values are
222: --
223: -- The primary key is invalid therefore we must error
224: --
225: close csr_leg_code;
226: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
227: fnd_message.raise_error;
228: end if;
229: hr_utility.set_location(l_proc,30);
230: --
223: -- The primary key is invalid therefore we must error
224: --
225: close csr_leg_code;
226: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
227: fnd_message.raise_error;
228: end if;
229: hr_utility.set_location(l_proc,30);
230: --
231: -- Set the global variables so the values are
600: IF NOT pqp_vai_shd.api_updating
601: (p_veh_alloc_extra_info_id => p_rec.veh_alloc_extra_info_id
602: ,p_object_version_number => p_rec.object_version_number
603: ) THEN
604: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
605: fnd_message.set_token('PROCEDURE ', l_proc);
606: fnd_message.set_token('STEP ', '5');
607: fnd_message.raise_error;
608: END IF;
601: (p_veh_alloc_extra_info_id => p_rec.veh_alloc_extra_info_id
602: ,p_object_version_number => p_rec.object_version_number
603: ) THEN
604: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
605: fnd_message.set_token('PROCEDURE ', l_proc);
606: fnd_message.set_token('STEP ', '5');
607: fnd_message.raise_error;
608: END IF;
609: --
602: ,p_object_version_number => p_rec.object_version_number
603: ) THEN
604: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
605: fnd_message.set_token('PROCEDURE ', l_proc);
606: fnd_message.set_token('STEP ', '5');
607: fnd_message.raise_error;
608: END IF;
609: --
610: -- EDIT_HERE: Add checks to ensure non-updateable args have
603: ) THEN
604: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
605: fnd_message.set_token('PROCEDURE ', l_proc);
606: fnd_message.set_token('STEP ', '5');
607: fnd_message.raise_error;
608: END IF;
609: --
610: -- EDIT_HERE: Add checks to ensure non-updateable args have
611: -- not been updated.