DBA Data[Home] [Help]

APPS.IRC_IPT_BUS dependencies on HR_UTILITY

Line 103: hr_utility.set_location('Entering:'||l_proc,10);

99: where name = p_name
100: and language = p_language;
101: --
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;

Line 109: hr_utility.set_location('Entering:'||l_proc,20);

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)
112: or (irc_ipt_shd.g_old_rec.posting_content_id is not null
113: and irc_ipt_shd.g_old_rec.name <> p_name)) then

Line 116: hr_utility.set_location('Entering:'||l_proc,30);

112: or (irc_ipt_shd.g_old_rec.posting_content_id is not null
113: and irc_ipt_shd.g_old_rec.name <> p_name)) then
114: open csr_name;
115: fetch csr_name into l_name;
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');

Line 125: hr_utility.set_location(' Leaving:'||l_proc,35);

121: fnd_message.raise_error;
122: end if;
123: close csr_name;
124: end if;
125: hr_utility.set_location(' Leaving:'||l_proc,35);
126: exception
127: when app_exception.application_exception then
128: if hr_multi_message.exception_add
129: (p_associated_column1 => 'IRC_POSTING_CONTENTS_TL.POSTING_CONTENT_ID'

Line 131: hr_utility.set_location(' Leaving:'||l_proc, 40);

127: when app_exception.application_exception then
128: if hr_multi_message.exception_add
129: (p_associated_column1 => 'IRC_POSTING_CONTENTS_TL.POSTING_CONTENT_ID'
130: )then
131: hr_utility.set_location(' Leaving:'||l_proc, 40);
132: raise;
133: end if;
134: hr_utility.set_location(' Leaving:'||l_proc,50);
135: End chk_name;

Line 134: hr_utility.set_location(' Leaving:'||l_proc,50);

130: )then
131: hr_utility.set_location(' Leaving:'||l_proc, 40);
132: raise;
133: end if;
134: hr_utility.set_location(' Leaving:'||l_proc,50);
135: End chk_name;
136: --
137: -- ----------------------------------------------------------------------------
138: -- |---------------------------< chk_source_lang >----------------------------|

Line 154: hr_utility.set_location('Entering:'||l_proc, 10);

150: l_proc varchar2(72) := g_package || 'chk_source_lang';
151: l_installed_flag varchar2(30);
152: --
153: Begin
154: hr_utility.set_location('Entering:'||l_proc, 10);
155: --
156: -- Only proceed with SQL validation if absolutely necessary
157: --
158: hr_api.mandatory_arg_error

Line 164: hr_utility.set_location(l_proc,20);

160: ,p_argument => 'source_lang'
161: ,p_argument_value => p_source_lang
162: );
163: --
164: hr_utility.set_location(l_proc,20);
165: if ((irc_ipt_shd.g_old_rec.posting_content_id is
166: null and p_language is not null)
167: or (irc_ipt_shd.g_old_rec.posting_content_id is not null
168: and nvl(irc_ipt_shd.g_old_rec.language, hr_api.g_varchar2)

Line 171: hr_utility.set_location(l_proc,30);

167: or (irc_ipt_shd.g_old_rec.posting_content_id is not null
168: and nvl(irc_ipt_shd.g_old_rec.language, hr_api.g_varchar2)
169: <> nvl(p_language, hr_api.g_varchar2))) then
170: --
171: hr_utility.set_location(l_proc,30);
172: --
173: -- Check value has been passed
174: --
175: --

Line 189: hr_utility.set_location('Leaving:'||l_proc,40);

185: fnd_message.raise_error;
186: end if;
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');

Line 199: hr_utility.set_location('Leaving:'||l_proc, 50);

195: end if;
196: --
197: end if;
198: --
199: hr_utility.set_location('Leaving:'||l_proc, 50);
200: End chk_source_lang;
201: --
202: -- ----------------------------------------------------------------------------
203: -- |---------------------------< insert_validate >----------------------------|

Line 212: hr_utility.set_location('Entering:'||l_proc, 5);

208: --
209: l_proc varchar2(72) := g_package||'insert_validate';
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: --
215: hr_utility.set_location(l_proc, 10);
216: irc_ipt_bus.chk_source_lang

Line 215: hr_utility.set_location(l_proc, 10);

211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: --
215: hr_utility.set_location(l_proc, 10);
216: irc_ipt_bus.chk_source_lang
217: (
218: p_language => p_rec.language
219: ,p_source_lang => p_rec.source_language

Line 221: hr_utility.set_location(l_proc, 20);

217: (
218: p_language => p_rec.language
219: ,p_source_lang => p_rec.source_language
220: );
221: hr_utility.set_location(l_proc, 20);
222: irc_ipt_bus.chk_name
223: (
224: p_name => p_rec.name
225: ,p_language => p_rec.language

Line 227: hr_utility.set_location(' Leaving:'||l_proc, 30);

223: (
224: p_name => p_rec.name
225: ,p_language => p_rec.language
226: );
227: hr_utility.set_location(' Leaving:'||l_proc, 30);
228: End insert_validate;
229: --
230: -- ----------------------------------------------------------------------------
231: -- |---------------------------< update_validate >----------------------------|

Line 240: hr_utility.set_location('Entering:'||l_proc, 5);

236: --
237: l_proc varchar2(72) := g_package||'update_validate';
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: chk_non_updateable_args
242: (p_rec => p_rec
243: );
244: hr_utility.set_location(l_proc, 10);

Line 244: hr_utility.set_location(l_proc, 10);

240: hr_utility.set_location('Entering:'||l_proc, 5);
241: chk_non_updateable_args
242: (p_rec => p_rec
243: );
244: hr_utility.set_location(l_proc, 10);
245: irc_ipt_bus.chk_source_lang
246: (
247: p_language => p_rec.language
248: ,p_source_lang => p_rec.source_language

Line 250: hr_utility.set_location(l_proc, 20);

246: (
247: p_language => p_rec.language
248: ,p_source_lang => p_rec.source_language
249: );
250: hr_utility.set_location(l_proc, 20);
251: irc_ipt_bus.chk_name
252: (
253: p_name => p_rec.name
254: ,p_language => p_rec.language

Line 256: hr_utility.set_location(' Leaving:'||l_proc, 30);

252: (
253: p_name => p_rec.name
254: ,p_language => p_rec.language
255: );
256: hr_utility.set_location(' Leaving:'||l_proc, 30);
257: End update_validate;
258: --
259: -- ----------------------------------------------------------------------------
260: -- |---------------------------< delete_validate >----------------------------|

Line 269: hr_utility.set_location('Entering:'||l_proc, 5);

265: --
266: l_proc varchar2(72) := g_package||'delete_validate';
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 10);
272: End delete_validate;
273: --

Line 271: hr_utility.set_location(' Leaving:'||l_proc, 10);

267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 10);
272: End delete_validate;
273: --
274: end irc_ipt_bus;