89: fetch csr_template_id_valid into l_valid;
90: if csr_template_id_valid%notfound then
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: close csr_template_id_valid;
93: fnd_message.set_name('PAY', 'PAY_50057_BAD_SOURCE_TEMPLATE');
94: fnd_message.raise_error;
95: end if;
96: close csr_template_id_valid;
97: hr_utility.set_location(' Leaving:'||l_proc, 15);
90: if csr_template_id_valid%notfound then
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: close csr_template_id_valid;
93: fnd_message.set_name('PAY', 'PAY_50057_BAD_SOURCE_TEMPLATE');
94: fnd_message.raise_error;
95: end if;
96: close csr_template_id_valid;
97: hr_utility.set_location(' Leaving:'||l_proc, 15);
98: End chk_template_id;
166: -- format.
167: --
168: when others then
169: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: fnd_message.set_name('PAY', 'PAY_50130_ETM_BAD_FLEX_COLUMN');
171: fnd_message.set_token('FLEXFIELD_COLUMN', p_flexfield_column);
172: fnd_message.raise_error;
173: end;
174: --
167: --
168: when others then
169: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: fnd_message.set_name('PAY', 'PAY_50130_ETM_BAD_FLEX_COLUMN');
171: fnd_message.set_token('FLEXFIELD_COLUMN', p_flexfield_column);
172: fnd_message.raise_error;
173: end;
174: --
175: -- Check that there are no clashes with default_value columns in
168: when others then
169: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: fnd_message.set_name('PAY', 'PAY_50130_ETM_BAD_FLEX_COLUMN');
171: fnd_message.set_token('FLEXFIELD_COLUMN', p_flexfield_column);
172: fnd_message.raise_error;
173: end;
174: --
175: -- Check that there are no clashes with default_value columns in
176: -- PAY_SHADOW_INPUT_VALUES.
179: fetch csr_default_value_clash into l_clash;
180: if csr_default_value_clash%found then
181: hr_utility.set_location(' Leaving:'||l_proc, 15);
182: close csr_default_value_clash;
183: fnd_message.set_name('PAY', 'PAY_50131_TER_SIV_CLASH');
184: fnd_message.raise_error;
185: end if;
186: close csr_default_value_clash;
187: end if;
180: if csr_default_value_clash%found then
181: hr_utility.set_location(' Leaving:'||l_proc, 15);
182: close csr_default_value_clash;
183: fnd_message.set_name('PAY', 'PAY_50131_TER_SIV_CLASH');
184: fnd_message.raise_error;
185: end if;
186: close csr_default_value_clash;
187: end if;
188: hr_utility.set_location(' Leaving:'||l_proc, 20);
419: close csr_bal_attributes;
420: hr_utility.set_location(' Leaving:'||l_proc, 75);
421: exception
422: when l_error then
423: fnd_message.set_name('PAY', 'PAY_50129_TER_INVALID_DELETE');
424: fnd_message.raise_error;
425: when others then
426: hr_utility.set_location(' Leaving:'||l_proc, 200);
427: raise;
420: hr_utility.set_location(' Leaving:'||l_proc, 75);
421: exception
422: when l_error then
423: fnd_message.set_name('PAY', 'PAY_50129_TER_INVALID_DELETE');
424: fnd_message.raise_error;
425: when others then
426: hr_utility.set_location(' Leaving:'||l_proc, 200);
427: raise;
428: End chk_delete;