165: fetch csr_template_id_valid into l_valid;
166: if csr_template_id_valid%notfound then
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
168: close csr_template_id_valid;
169: fnd_message.set_name('PAY', 'PAY_50065_BAD_USER_TEMPLATE');
170: fnd_message.raise_error;
171: end if;
172: close csr_template_id_valid;
173: hr_utility.set_location(' Leaving:'||l_proc, 15);
166: if csr_template_id_valid%notfound then
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
168: close csr_template_id_valid;
169: fnd_message.set_name('PAY', 'PAY_50065_BAD_USER_TEMPLATE');
170: fnd_message.raise_error;
171: end if;
172: close csr_template_id_valid;
173: hr_utility.set_location(' Leaving:'||l_proc, 15);
174: End chk_template_id;
201: ,p_lookup_code => p_core_object_type
202: )
203: then
204: hr_utility.set_location(' Leaving:'||l_proc, 10);
205: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
206: fnd_message.set_token('LOOKUP_TYPE', 'CORE_OBJECT_TYPE');
207: fnd_message.set_token('COLUMN', 'CORE_OBJECT_TYPE');
208: fnd_message.raise_error;
209: end if;
202: )
203: then
204: hr_utility.set_location(' Leaving:'||l_proc, 10);
205: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
206: fnd_message.set_token('LOOKUP_TYPE', 'CORE_OBJECT_TYPE');
207: fnd_message.set_token('COLUMN', 'CORE_OBJECT_TYPE');
208: fnd_message.raise_error;
209: end if;
210: hr_utility.set_location(' Leaving:'||l_proc, 20);
203: then
204: hr_utility.set_location(' Leaving:'||l_proc, 10);
205: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
206: fnd_message.set_token('LOOKUP_TYPE', 'CORE_OBJECT_TYPE');
207: fnd_message.set_token('COLUMN', 'CORE_OBJECT_TYPE');
208: fnd_message.raise_error;
209: end if;
210: hr_utility.set_location(' Leaving:'||l_proc, 20);
211: End chk_core_object_type;
204: hr_utility.set_location(' Leaving:'||l_proc, 10);
205: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
206: fnd_message.set_token('LOOKUP_TYPE', 'CORE_OBJECT_TYPE');
207: fnd_message.set_token('COLUMN', 'CORE_OBJECT_TYPE');
208: fnd_message.raise_error;
209: end if;
210: hr_utility.set_location(' Leaving:'||l_proc, 20);
211: End chk_core_object_type;
212: -- ----------------------------------------------------------------------------
363: fetch csr_comb_exists into l_exists;
364: if csr_comb_exists%found then
365: hr_utility.set_location(l_proc, 10);
366: close csr_comb_exists;
367: fnd_message.set_name('PAY', 'PAY_50126_TCO_SHAD_OBJ_EXISTS');
368: fnd_message.raise_error;
369: end if;
370: close csr_comb_exists;
371: --
364: if csr_comb_exists%found then
365: hr_utility.set_location(l_proc, 10);
366: close csr_comb_exists;
367: fnd_message.set_name('PAY', 'PAY_50126_TCO_SHAD_OBJ_EXISTS');
368: fnd_message.raise_error;
369: end if;
370: close csr_comb_exists;
371: --
372: -- Check that the shadow_object_id belongs to the template.
512: hr_utility.set_location(' Leaving:'||l_proc, 15);
513: exception
514: when l_error then
515: hr_utility.set_location(' Leaving:'||l_proc, 20);
516: fnd_message.set_name('PAY', 'PAY_50127_TCO_SHAD_NOT_FOUND');
517: fnd_message.set_token('TABLE', l_table);
518: fnd_message.raise_error;
519: when others then
520: hr_utility.set_location(' Leaving:'||l_proc, 25);
513: exception
514: when l_error then
515: hr_utility.set_location(' Leaving:'||l_proc, 20);
516: fnd_message.set_name('PAY', 'PAY_50127_TCO_SHAD_NOT_FOUND');
517: fnd_message.set_token('TABLE', l_table);
518: fnd_message.raise_error;
519: when others then
520: hr_utility.set_location(' Leaving:'||l_proc, 25);
521: raise;
514: when l_error then
515: hr_utility.set_location(' Leaving:'||l_proc, 20);
516: fnd_message.set_name('PAY', 'PAY_50127_TCO_SHAD_NOT_FOUND');
517: fnd_message.set_token('TABLE', l_table);
518: fnd_message.raise_error;
519: when others then
520: hr_utility.set_location(' Leaving:'||l_proc, 25);
521: raise;
522: End chk_shadow_object_id;
680: fetch csr_comb_exists into l_exists;
681: if csr_comb_exists%found then
682: hr_utility.set_location(l_proc, 10);
683: close csr_comb_exists;
684: fnd_message.set_name('PAY', 'PAY_50124_TCO_CORE_OBJ_EXISTS');
685: fnd_message.raise_error;
686: end if;
687: close csr_comb_exists;
688: --
681: if csr_comb_exists%found then
682: hr_utility.set_location(l_proc, 10);
683: close csr_comb_exists;
684: fnd_message.set_name('PAY', 'PAY_50124_TCO_CORE_OBJ_EXISTS');
685: fnd_message.raise_error;
686: end if;
687: close csr_comb_exists;
688: --
689: -- Check that the core_object_id exists to the template.
822: hr_utility.set_location(' Leaving:'||l_proc, 15);
823: exception
824: when l_error then
825: hr_utility.set_location(' Leaving:'||l_proc, 20);
826: fnd_message.set_name('PAY', 'PAY_50125_TCO_CORE_NOT_FOUND');
827: fnd_message.set_token('TABLE', l_table);
828: fnd_message.raise_error;
829: when others then
830: hr_utility.set_location(' Leaving:'||l_proc, 25);
823: exception
824: when l_error then
825: hr_utility.set_location(' Leaving:'||l_proc, 20);
826: fnd_message.set_name('PAY', 'PAY_50125_TCO_CORE_NOT_FOUND');
827: fnd_message.set_token('TABLE', l_table);
828: fnd_message.raise_error;
829: when others then
830: hr_utility.set_location(' Leaving:'||l_proc, 25);
831: raise;
824: when l_error then
825: hr_utility.set_location(' Leaving:'||l_proc, 20);
826: fnd_message.set_name('PAY', 'PAY_50125_TCO_CORE_NOT_FOUND');
827: fnd_message.set_token('TABLE', l_table);
828: fnd_message.raise_error;
829: when others then
830: hr_utility.set_location(' Leaving:'||l_proc, 25);
831: raise;
832: End chk_core_object_id;