54: IF NOT irc_irt_shd.api_updating
55: (p_recruiting_site_id => p_rec.recruiting_site_id
56: ,p_language => p_rec.language
57: ) THEN
58: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE ', l_proc);
60: fnd_message.set_token('STEP ', '5');
61: fnd_message.raise_error;
62: END IF;
55: (p_recruiting_site_id => p_rec.recruiting_site_id
56: ,p_language => p_rec.language
57: ) THEN
58: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE ', l_proc);
60: fnd_message.set_token('STEP ', '5');
61: fnd_message.raise_error;
62: END IF;
63: --
56: ,p_language => p_rec.language
57: ) THEN
58: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE ', l_proc);
60: fnd_message.set_token('STEP ', '5');
61: fnd_message.raise_error;
62: END IF;
63: --
64: End chk_non_updateable_args;
57: ) THEN
58: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE ', l_proc);
60: fnd_message.set_token('STEP ', '5');
61: fnd_message.raise_error;
62: END IF;
63: --
64: End chk_non_updateable_args;
65: --
107: open csr_language;
108: fetch csr_language into l_installed_flag;
109: if csr_language%notfound then
110: close csr_language;
111: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
112: fnd_message.set_token('PROCEDURE', l_proc);
113: fnd_message.set_token('STEP','10');
114: fnd_message.raise_error;
115: end if;
108: fetch csr_language into l_installed_flag;
109: if csr_language%notfound then
110: close csr_language;
111: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
112: fnd_message.set_token('PROCEDURE', l_proc);
113: fnd_message.set_token('STEP','10');
114: fnd_message.raise_error;
115: end if;
116: close csr_language;
109: if csr_language%notfound then
110: close csr_language;
111: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
112: fnd_message.set_token('PROCEDURE', l_proc);
113: fnd_message.set_token('STEP','10');
114: fnd_message.raise_error;
115: end if;
116: close csr_language;
117: --
110: close csr_language;
111: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
112: fnd_message.set_token('PROCEDURE', l_proc);
113: fnd_message.set_token('STEP','10');
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
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;
123: 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;
123: end if;
124: --
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;
123: end if;
124: --
125: end if;
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;
123: end if;
124: --
125: end if;
126: --
164: Begin
165: hr_utility.set_location('Entering:'||l_proc,10);
166: if (p_site_name is null)
167: then
168: fnd_message.set_name('PER','IRC_412104_RSE_NAME_NULL');
169: fnd_message.raise_error;
170: end if;
171: hr_utility.set_location('Entering:'||l_proc,20);
172: if ((irc_irt_shd.g_old_rec.recruiting_site_id is
165: hr_utility.set_location('Entering:'||l_proc,10);
166: if (p_site_name is null)
167: then
168: fnd_message.set_name('PER','IRC_412104_RSE_NAME_NULL');
169: fnd_message.raise_error;
170: end if;
171: hr_utility.set_location('Entering:'||l_proc,20);
172: if ((irc_irt_shd.g_old_rec.recruiting_site_id is
173: null)
178: hr_utility.set_location('Entering:'||l_proc,30);
179: if (csr_name%found)
180: then
181: close csr_name;
182: fnd_message.set_name('PER','IRC_412105_RSE_NAME_EXIST');
183: fnd_message.raise_error;
184: end if;
185: close csr_name;
186: end if;
179: if (csr_name%found)
180: then
181: close csr_name;
182: fnd_message.set_name('PER','IRC_412105_RSE_NAME_EXIST');
183: fnd_message.raise_error;
184: end if;
185: close csr_name;
186: end if;
187: hr_utility.set_location(' Leaving:'||l_proc,35);
255: --
256: if (l_third_party = 'Y'
257: and p_redirection_url is not null) then
258: hr_utility.set_location(l_proc,60);
259: fnd_message.set_name('PER','IRC_412096_BAD_TP_REDIR_URL');
260: fnd_message.raise_error;
261: end if;
262: end if;
263: hr_utility.set_location(' Leaving:'||l_proc,70);
256: if (l_third_party = 'Y'
257: and p_redirection_url is not null) then
258: hr_utility.set_location(l_proc,60);
259: fnd_message.set_name('PER','IRC_412096_BAD_TP_REDIR_URL');
260: fnd_message.raise_error;
261: end if;
262: end if;
263: hr_utility.set_location(' Leaving:'||l_proc,70);
264: exception
337: and p_posting_url is null)
338: )
339: then
340: hr_utility.set_location(l_proc,60);
341: fnd_message.set_name('PER','IRC_412097_BAD_TP_POSTING_URL');
342: fnd_message.raise_error;
343: end if;
344: end if;
345: hr_utility.set_location(' Leaving:'||l_proc,70);
338: )
339: then
340: hr_utility.set_location(l_proc,60);
341: fnd_message.set_name('PER','IRC_412097_BAD_TP_POSTING_URL');
342: fnd_message.raise_error;
343: end if;
344: end if;
345: hr_utility.set_location(' Leaving:'||l_proc,70);
346: exception