70: close csr_sec_grp;
71: --
72: -- The primary key is invalid therefore we must error
73: --
74: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
75: hr_multi_message.add
76: (p_associated_column1
77: => nvl(p_associated_column1,'RATING_SCALE_ID')
78: );
161: --
162: -- The primary key is invalid therefore we must error
163: --
164: close csr_leg_code;
165: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
166: fnd_message.raise_error;
167: end if;
168: hr_utility.set_location(l_proc,30);
169: --
162: -- The primary key is invalid therefore we must error
163: --
164: close csr_leg_code;
165: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
166: fnd_message.raise_error;
167: end if;
168: hr_utility.set_location(l_proc,30);
169: --
170: -- Set the global variables so the values are
220: IF NOT per_rsl_shd.api_updating
221: (p_rating_scale_id => p_rec.rating_scale_id,
222: p_language => p_rec.language )
223: THEN
224: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
225: fnd_message.set_token('PROCEDURE ', l_proc);
226: fnd_message.set_token('STEP ', '5');
227: fnd_message.raise_error;
228: END IF;
221: (p_rating_scale_id => p_rec.rating_scale_id,
222: p_language => p_rec.language )
223: THEN
224: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
225: fnd_message.set_token('PROCEDURE ', l_proc);
226: fnd_message.set_token('STEP ', '5');
227: fnd_message.raise_error;
228: END IF;
229: --
222: p_language => p_rec.language )
223: THEN
224: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
225: fnd_message.set_token('PROCEDURE ', l_proc);
226: fnd_message.set_token('STEP ', '5');
227: fnd_message.raise_error;
228: END IF;
229: --
230:
223: THEN
224: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
225: fnd_message.set_token('PROCEDURE ', l_proc);
226: fnd_message.set_token('STEP ', '5');
227: fnd_message.raise_error;
228: END IF;
229: --
230:
231: End chk_non_updateable_args;
341: hr_utility.set_location(l_proc, 10);
342: close csr_name_exists;
343: hr_utility.set_location(to_char(l_exists), 99);
344: if l_exists is null then
345: fnd_message.set_name('PER', 'HR_52696_RSC_NAME_IN_GLOB');
346: fnd_message.raise_error;
347: else
348: fnd_message.set_name('PER', 'HR_52697_RSC_NAME_IN_BUSGRP');
349: fnd_message.raise_error;
342: close csr_name_exists;
343: hr_utility.set_location(to_char(l_exists), 99);
344: if l_exists is null then
345: fnd_message.set_name('PER', 'HR_52696_RSC_NAME_IN_GLOB');
346: fnd_message.raise_error;
347: else
348: fnd_message.set_name('PER', 'HR_52697_RSC_NAME_IN_BUSGRP');
349: fnd_message.raise_error;
350: end if;
344: if l_exists is null then
345: fnd_message.set_name('PER', 'HR_52696_RSC_NAME_IN_GLOB');
346: fnd_message.raise_error;
347: else
348: fnd_message.set_name('PER', 'HR_52697_RSC_NAME_IN_BUSGRP');
349: fnd_message.raise_error;
350: end if;
351: end if;
352: close csr_name_exists;
345: fnd_message.set_name('PER', 'HR_52696_RSC_NAME_IN_GLOB');
346: fnd_message.raise_error;
347: else
348: fnd_message.set_name('PER', 'HR_52697_RSC_NAME_IN_BUSGRP');
349: fnd_message.raise_error;
350: end if;
351: end if;
352: close csr_name_exists;
353: end if;