64: open csr_application_id;
65: fetch csr_application_id into l_key;
66: if(csr_application_id%notfound) then
67: close csr_application_id;
68: fnd_message.set_name('AME', 'INVALID_APPLICATION_ID');
69: fnd_message.raise_error;
70: else
71: close csr_application_id;
72: end if;
65: fetch csr_application_id into l_key;
66: if(csr_application_id%notfound) then
67: close csr_application_id;
68: fnd_message.set_name('AME', 'INVALID_APPLICATION_ID');
69: fnd_message.raise_error;
70: else
71: close csr_application_id;
72: end if;
73: hr_utility.set_location(' Leaving:'||l_proc,30);
130: open dup_app_name;
131: fetch dup_app_name into l_exists;
132: if dup_app_name%found then
133: close dup_app_name;
134: fnd_message.set_name('PER','AME_400748_TTY_NAME_IN_USE');
135: fnd_message.raise_error;
136: end if;
137: close dup_app_name;
138: exception
131: fetch dup_app_name into l_exists;
132: if dup_app_name%found then
133: close dup_app_name;
134: fnd_message.set_name('PER','AME_400748_TTY_NAME_IN_USE');
135: fnd_message.raise_error;
136: end if;
137: close dup_app_name;
138: exception
139: when app_exception.application_exception then
216: IF NOT ame_cal_shd.api_updating
217: (p_application_id => p_rec.application_id
218: ,p_language => p_rec.language
219: ) THEN
220: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
221: fnd_message.set_token('PROCEDURE ', l_proc);
222: fnd_message.set_token('STEP ', '5');
223: fnd_message.raise_error;
224: END IF;
217: (p_application_id => p_rec.application_id
218: ,p_language => p_rec.language
219: ) THEN
220: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
221: fnd_message.set_token('PROCEDURE ', l_proc);
222: fnd_message.set_token('STEP ', '5');
223: fnd_message.raise_error;
224: END IF;
225: --
218: ,p_language => p_rec.language
219: ) THEN
220: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
221: fnd_message.set_token('PROCEDURE ', l_proc);
222: fnd_message.set_token('STEP ', '5');
223: fnd_message.raise_error;
224: END IF;
225: --
226: -- EDIT_HERE: Add checks to ensure non-updateable args have
219: ) THEN
220: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
221: fnd_message.set_token('PROCEDURE ', l_proc);
222: fnd_message.set_token('STEP ', '5');
223: fnd_message.raise_error;
224: END IF;
225: --
226: -- EDIT_HERE: Add checks to ensure non-updateable args have
227: -- not been updated.