58: IF NOT pay_tfu_shd.api_updating
59: (p_template_ff_usage_id => p_rec.template_ff_usage_id
60: ,p_object_version_number => p_rec.object_version_number
61: ) THEN
62: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE ', l_proc);
64: fnd_message.set_token('STEP ', '5');
65: fnd_message.raise_error;
66: END IF;
59: (p_template_ff_usage_id => p_rec.template_ff_usage_id
60: ,p_object_version_number => p_rec.object_version_number
61: ) THEN
62: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE ', l_proc);
64: fnd_message.set_token('STEP ', '5');
65: fnd_message.raise_error;
66: END IF;
67: --
60: ,p_object_version_number => p_rec.object_version_number
61: ) THEN
62: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE ', l_proc);
64: fnd_message.set_token('STEP ', '5');
65: fnd_message.raise_error;
66: END IF;
67: --
68: -- p_template_id
61: ) THEN
62: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE ', l_proc);
64: fnd_message.set_token('STEP ', '5');
65: fnd_message.raise_error;
66: END IF;
67: --
68: -- p_template_id
69: --
135: );
136: fetch csr_uniqueness_chk into l_exists;
137: if csr_uniqueness_chk%found then
138: close csr_uniqueness_chk;
139: fnd_message.set_name('PAY', 'PAY_50207_TFU_FF_USAGE_EXISTS');
140: fnd_message.raise_error;
141: end if;
142: close csr_uniqueness_chk;
143: end if;
136: fetch csr_uniqueness_chk into l_exists;
137: if csr_uniqueness_chk%found then
138: close csr_uniqueness_chk;
139: fnd_message.set_name('PAY', 'PAY_50207_TFU_FF_USAGE_EXISTS');
140: fnd_message.raise_error;
141: end if;
142: close csr_uniqueness_chk;
143: end if;
144: End chk_unique;
173: , g_legislation_code
174: ;
175: if csr_template_info%notfound then
176: close csr_template_info;
177: fnd_message.set_name('PAY', 'PAY_50114_ETM_INVALID_TEMPLATE');
178: fnd_message.raise_error;
179: end if;
180: close csr_template_info;
181: End chk_template_id;
174: ;
175: if csr_template_info%notfound then
176: close csr_template_info;
177: fnd_message.set_name('PAY', 'PAY_50114_ETM_INVALID_TEMPLATE');
178: fnd_message.raise_error;
179: end if;
180: close csr_template_info;
181: End chk_template_id;
182: -- ----------------------------------------------------------------------------
214: open csr_object_id;
215: fetch csr_object_id into l_exists;
216: if csr_object_id%notfound then
217: close csr_object_id;
218: fnd_message.set_name('PAY', 'PAY_50208_TFU_INVALID_OBJECT');
219: fnd_message.raise_error;
220: end if;
221: close csr_object_id;
222: End chk_object_id;
215: fetch csr_object_id into l_exists;
216: if csr_object_id%notfound then
217: close csr_object_id;
218: fnd_message.set_name('PAY', 'PAY_50208_TFU_INVALID_OBJECT');
219: fnd_message.raise_error;
220: end if;
221: close csr_object_id;
222: End chk_object_id;
223: -- ----------------------------------------------------------------------------
264: open csr_exclusion_rule_id_valid;
265: fetch csr_exclusion_rule_id_valid into l_valid;
266: if csr_exclusion_rule_id_valid%notfound then
267: close csr_exclusion_rule_id_valid;
268: fnd_message.set_name('PAY', 'PAY_50100_ETM_INVALID_EXC_RULE');
269: fnd_message.raise_error;
270: end if;
271: close csr_exclusion_rule_id_valid;
272: end if;
265: fetch csr_exclusion_rule_id_valid into l_valid;
266: if csr_exclusion_rule_id_valid%notfound then
267: close csr_exclusion_rule_id_valid;
268: fnd_message.set_name('PAY', 'PAY_50100_ETM_INVALID_EXC_RULE');
269: fnd_message.raise_error;
270: end if;
271: close csr_exclusion_rule_id_valid;
272: end if;
273: end if;
322: open csr_formula_valid;
323: fetch csr_formula_valid into l_valid;
324: if csr_formula_valid%notfound then
325: close csr_formula_valid;
326: fnd_message.set_name('PAY', 'PAY_50209_TFU_INVALID_FORMULA');
327: fnd_message.raise_error;
328: end if;
329: close csr_formula_valid;
330: end if;
323: fetch csr_formula_valid into l_valid;
324: if csr_formula_valid%notfound then
325: close csr_formula_valid;
326: fnd_message.set_name('PAY', 'PAY_50209_TFU_INVALID_FORMULA');
327: fnd_message.raise_error;
328: end if;
329: close csr_formula_valid;
330: end if;
331: end if;