59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'FUNCTION_ID')
67: );
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
203: fetch csr_legislation_code into l_exists ;
204:
205: if csr_legislation_code%notfound then
206: close csr_legislation_code;
207: fnd_message.set_name('PAY', 'PAY_33177_LEG_CODE_INVALID');
208: fnd_message.raise_error;
209: end if;
210: close csr_legislation_code;
211:
204:
205: if csr_legislation_code%notfound then
206: close csr_legislation_code;
207: fnd_message.set_name('PAY', 'PAY_33177_LEG_CODE_INVALID');
208: fnd_message.raise_error;
209: end if;
210: close csr_legislation_code;
211:
212: hr_utility.set_location(' Leaving:'|| l_proc, 20);
375: --
376: -- The Alias Name cannot be same as Name.
377: --
378: if (p_alias_name = p_name) then
379: fnd_message.set_name('FF','FF_52245_BAD_ALIAS_NAME');
380: fnd_message.raise_error;
381: end if;
382:
383: -- Special character can not be used in alias name.
376: -- The Alias Name cannot be same as Name.
377: --
378: if (p_alias_name = p_name) then
379: fnd_message.set_name('FF','FF_52245_BAD_ALIAS_NAME');
380: fnd_message.raise_error;
381: end if;
382:
383: -- Special character can not be used in alias name.
384: --
445: IF NOT ff_ffn_shd.api_updating
446: (p_function_id => p_rec.function_id
447: ,p_object_version_number => p_rec.object_version_number
448: ) THEN
449: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
450: fnd_message.set_token('PROCEDURE ', l_proc);
451: fnd_message.set_token('STEP ', '5');
452: fnd_message.raise_error;
453: END IF;
446: (p_function_id => p_rec.function_id
447: ,p_object_version_number => p_rec.object_version_number
448: ) THEN
449: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
450: fnd_message.set_token('PROCEDURE ', l_proc);
451: fnd_message.set_token('STEP ', '5');
452: fnd_message.raise_error;
453: END IF;
454: --
447: ,p_object_version_number => p_rec.object_version_number
448: ) THEN
449: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
450: fnd_message.set_token('PROCEDURE ', l_proc);
451: fnd_message.set_token('STEP ', '5');
452: fnd_message.raise_error;
453: END IF;
454: --
455: --
448: ) THEN
449: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
450: fnd_message.set_token('PROCEDURE ', l_proc);
451: fnd_message.set_token('STEP ', '5');
452: fnd_message.raise_error;
453: END IF;
454: --
455: --
456: if nvl(p_rec.business_group_id, hr_api.g_number) <>
504:
505: IF (p_insert) THEN
506:
507: if p_business_group_id is not null and p_legislation_code is not null then
508: fnd_message.set_name('PAY', 'PAY_33179_BGLEG_INVALID');
509: fnd_message.raise_error;
510: end if;
511:
512: hr_startup_data_api_support.chk_startup_action
505: IF (p_insert) THEN
506:
507: if p_business_group_id is not null and p_legislation_code is not null then
508: fnd_message.set_name('PAY', 'PAY_33179_BGLEG_INVALID');
509: fnd_message.raise_error;
510: end if;
511:
512: hr_startup_data_api_support.chk_startup_action
513: (p_generic_allowed => TRUE