58: IF NOT irc_idt_shd.api_updating
59: (p_default_posting_id => p_rec.default_posting_id
60: ,p_language => p_rec.language
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_default_posting_id => p_rec.default_posting_id
60: ,p_language => p_rec.language
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_language => p_rec.language
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: EXCEPTION
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: EXCEPTION
69: WHEN l_error THEN
119: open csr_language;
120: fetch csr_language into l_installed_flag;
121: if csr_language%notfound then
122: close csr_language;
123: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
124: fnd_message.set_token('PROCEDURE', l_proc);
125: fnd_message.set_token('STEP','10');
126: fnd_message.raise_error;
127: end if;
120: fetch csr_language into l_installed_flag;
121: if csr_language%notfound then
122: close csr_language;
123: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
124: fnd_message.set_token('PROCEDURE', l_proc);
125: fnd_message.set_token('STEP','10');
126: fnd_message.raise_error;
127: end if;
128: close csr_language;
121: if csr_language%notfound then
122: close csr_language;
123: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
124: fnd_message.set_token('PROCEDURE', l_proc);
125: fnd_message.set_token('STEP','10');
126: fnd_message.raise_error;
127: end if;
128: close csr_language;
129: --
122: close csr_language;
123: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
124: fnd_message.set_token('PROCEDURE', l_proc);
125: fnd_message.set_token('STEP','10');
126: fnd_message.raise_error;
127: end if;
128: close csr_language;
129: --
130: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then
127: end if;
128: close csr_language;
129: --
130: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then
131: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
132: fnd_message.set_token('PROCEDURE', l_proc);
133: fnd_message.set_token('STEP','20');
134: fnd_message.raise_error;
135: end if;
128: close csr_language;
129: --
130: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then
131: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
132: fnd_message.set_token('PROCEDURE', l_proc);
133: fnd_message.set_token('STEP','20');
134: fnd_message.raise_error;
135: end if;
136: --
129: --
130: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then
131: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
132: fnd_message.set_token('PROCEDURE', l_proc);
133: fnd_message.set_token('STEP','20');
134: fnd_message.raise_error;
135: end if;
136: --
137: end if;
130: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then
131: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
132: fnd_message.set_token('PROCEDURE', l_proc);
133: fnd_message.set_token('STEP','20');
134: fnd_message.raise_error;
135: end if;
136: --
137: end if;
138: --