55: IF NOT irc_ipt_shd.api_updating
56: (p_posting_content_id => p_rec.posting_content_id
57: ,p_language => p_rec.language
58: ) THEN
59: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE ', l_proc);
61: fnd_message.set_token('STEP ', '5');
62: fnd_message.raise_error;
63: END IF;
56: (p_posting_content_id => p_rec.posting_content_id
57: ,p_language => p_rec.language
58: ) THEN
59: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE ', l_proc);
61: fnd_message.set_token('STEP ', '5');
62: fnd_message.raise_error;
63: END IF;
64: --
57: ,p_language => p_rec.language
58: ) THEN
59: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE ', l_proc);
61: fnd_message.set_token('STEP ', '5');
62: fnd_message.raise_error;
63: END IF;
64: --
65: End chk_non_updateable_args;
58: ) THEN
59: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE ', l_proc);
61: fnd_message.set_token('STEP ', '5');
62: fnd_message.raise_error;
63: END IF;
64: --
65: End chk_non_updateable_args;
66: --
102: Begin
103: hr_utility.set_location('Entering:'||l_proc,10);
104: if (p_name is null)
105: then
106: fnd_message.set_name('PER','IRC_412029_IPT_NAME_MND');
107: fnd_message.raise_error;
108: end if;
109: hr_utility.set_location('Entering:'||l_proc,20);
110: if ((irc_ipt_shd.g_old_rec.posting_content_id is
103: hr_utility.set_location('Entering:'||l_proc,10);
104: if (p_name is null)
105: then
106: fnd_message.set_name('PER','IRC_412029_IPT_NAME_MND');
107: fnd_message.raise_error;
108: end if;
109: hr_utility.set_location('Entering:'||l_proc,20);
110: if ((irc_ipt_shd.g_old_rec.posting_content_id is
111: null)
116: hr_utility.set_location('Entering:'||l_proc,30);
117: if (csr_name%found)
118: then
119: close csr_name;
120: fnd_message.set_name('PER','IRC_412122_DUPLICATE_POST_NAME');
121: fnd_message.raise_error;
122: end if;
123: close csr_name;
124: end if;
117: if (csr_name%found)
118: then
119: close csr_name;
120: fnd_message.set_name('PER','IRC_412122_DUPLICATE_POST_NAME');
121: fnd_message.raise_error;
122: end if;
123: close csr_name;
124: end if;
125: hr_utility.set_location(' Leaving:'||l_proc,35);
178: open csr_language;
179: fetch csr_language into l_installed_flag;
180: if csr_language%notfound then
181: close csr_language;
182: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
183: fnd_message.set_token('PROCEDURE', l_proc);
184: fnd_message.set_token('STEP','10');
185: fnd_message.raise_error;
186: end if;
179: fetch csr_language into l_installed_flag;
180: if csr_language%notfound then
181: close csr_language;
182: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
183: fnd_message.set_token('PROCEDURE', l_proc);
184: fnd_message.set_token('STEP','10');
185: fnd_message.raise_error;
186: end if;
187: close csr_language;
180: if csr_language%notfound then
181: close csr_language;
182: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
183: fnd_message.set_token('PROCEDURE', l_proc);
184: fnd_message.set_token('STEP','10');
185: fnd_message.raise_error;
186: end if;
187: close csr_language;
188: --
181: close csr_language;
182: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
183: fnd_message.set_token('PROCEDURE', l_proc);
184: fnd_message.set_token('STEP','10');
185: fnd_message.raise_error;
186: end if;
187: close csr_language;
188: --
189: hr_utility.set_location('Leaving:'||l_proc,40);
187: close csr_language;
188: --
189: hr_utility.set_location('Leaving:'||l_proc,40);
190: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then
191: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
192: fnd_message.set_token('PROCEDURE', l_proc);
193: fnd_message.set_token('STEP','20');
194: fnd_message.raise_error;
195: end if;
188: --
189: hr_utility.set_location('Leaving:'||l_proc,40);
190: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then
191: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
192: fnd_message.set_token('PROCEDURE', l_proc);
193: fnd_message.set_token('STEP','20');
194: fnd_message.raise_error;
195: end if;
196: --
189: hr_utility.set_location('Leaving:'||l_proc,40);
190: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then
191: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
192: fnd_message.set_token('PROCEDURE', l_proc);
193: fnd_message.set_token('STEP','20');
194: fnd_message.raise_error;
195: end if;
196: --
197: end if;
190: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then
191: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
192: fnd_message.set_token('PROCEDURE', l_proc);
193: fnd_message.set_token('STEP','20');
194: fnd_message.raise_error;
195: end if;
196: --
197: end if;
198: --