86: --
87:
88: if ((irc_irt_shd.g_old_rec.recruiting_site_id is null and p_language is not null)
89: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
90: and nvl(irc_irt_shd.g_old_rec.language, hr_api.g_varchar2)
91: <> nvl(p_language, hr_api.g_varchar2))) then
92: --
93: hr_utility.set_location(l_proc,30);
94: --
87:
88: if ((irc_irt_shd.g_old_rec.recruiting_site_id is null and p_language is not null)
89: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
90: and nvl(irc_irt_shd.g_old_rec.language, hr_api.g_varchar2)
91: <> nvl(p_language, hr_api.g_varchar2))) then
92: --
93: hr_utility.set_location(l_proc,30);
94: --
95: -- Check value has been passed
93: hr_utility.set_location(l_proc,30);
94: --
95: -- Check value has been passed
96: --
97: hr_api.mandatory_arg_error
98: (p_api_name => l_proc
99: ,p_argument => 'source_lang'
100: ,p_argument_value => p_source_lang
101: );
114: fnd_message.raise_error;
115: end if;
116: close csr_language;
117: --
118: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then
119: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
120: fnd_message.set_token('PROCEDURE', l_proc);
121: fnd_message.set_token('STEP','20');
122: fnd_message.raise_error;
244: --
245: if ((irc_irt_shd.g_old_rec.recruiting_site_id is
246: null)
247: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
248: and nvl(irc_irt_shd.g_old_rec.redirection_url,hr_api.g_varchar2)
249: <> nvl(p_redirection_url,hr_api.g_varchar2)))
250: then
251: hr_utility.set_location(l_proc,25);
252: open csr_third_party;
245: if ((irc_irt_shd.g_old_rec.recruiting_site_id is
246: null)
247: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
248: and nvl(irc_irt_shd.g_old_rec.redirection_url,hr_api.g_varchar2)
249: <> nvl(p_redirection_url,hr_api.g_varchar2)))
250: then
251: hr_utility.set_location(l_proc,25);
252: open csr_third_party;
253: fetch csr_third_party into l_third_party;
322: --
323: if ((irc_irt_shd.g_old_rec.recruiting_site_id is
324: null)
325: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
326: and nvl(irc_irt_shd.g_old_rec.posting_url,hr_api.g_varchar2)
327: <> nvl(p_posting_url,hr_api.g_varchar2)))
328: then
329: hr_utility.set_location(l_proc,25);
330: open csr_third_party;
323: if ((irc_irt_shd.g_old_rec.recruiting_site_id is
324: null)
325: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
326: and nvl(irc_irt_shd.g_old_rec.posting_url,hr_api.g_varchar2)
327: <> nvl(p_posting_url,hr_api.g_varchar2)))
328: then
329: hr_utility.set_location(l_proc,25);
330: open csr_third_party;
331: fetch csr_third_party into l_third_party;