eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_IRT_BUS dependencies on HR_UTILITY

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

79: l_proc varchar2(72) := g_package || 'chk_source_lang';
80: l_installed_flag varchar2(30);
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 10);
84: --
85: -- Only proceed with SQL validation if absolutely necessary
86: --
87:

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

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
96: --
97: hr_api.mandatory_arg_error

Line 103: hr_utility.set_location(l_proc,40);

99: ,p_argument => 'source_lang'
100: ,p_argument_value => p_source_lang
101: );
102: --
103: hr_utility.set_location(l_proc,40);
104: --
105: -- Check source language exists and is base or installed language
106: --
107: open csr_language;

Line 127: hr_utility.set_location('Leaving:'||l_proc, 100);

123: end if;
124: --
125: end if;
126: --
127: hr_utility.set_location('Leaving:'||l_proc, 100);
128: End chk_source_lang;
129: -- ----------------------------------------------------------------------------
130: -- |-----------------------< chk_site_name>-----------------------------------|
131: -- ----------------------------------------------------------------------------

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

161: where site_name = p_site_name
162: and language = p_language;
163: --
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;

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

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)
174: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
175: and irc_irt_shd.g_old_rec.site_name <> p_site_name)) then

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

174: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
175: and irc_irt_shd.g_old_rec.site_name <> p_site_name)) then
176: open csr_name;
177: fetch csr_name into l_name;
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');

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

183: fnd_message.raise_error;
184: end if;
185: close csr_name;
186: end if;
187: hr_utility.set_location(' Leaving:'||l_proc,35);
188: exception
189: when app_exception.application_exception then
190: if hr_multi_message.exception_add
191: (p_associated_column1 => 'irc_all_recruiting_sites_tl.site_name'

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

189: when app_exception.application_exception then
190: if hr_multi_message.exception_add
191: (p_associated_column1 => 'irc_all_recruiting_sites_tl.site_name'
192: )then
193: hr_utility.set_location(' Leaving:'||l_proc, 40);
194: raise;
195: end if;
196: hr_utility.set_location(' Leaving:'||l_proc,50);
197: End chk_site_name;

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

192: )then
193: hr_utility.set_location(' Leaving:'||l_proc, 40);
194: raise;
195: end if;
196: hr_utility.set_location(' Leaving:'||l_proc,50);
197: End chk_site_name;
198: --
199: --
200: -- ----------------------------------------------------------------------------

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

234: from irc_all_recruiting_sites
235: where recruiting_site_id = p_recruiting_site_id;
236: --
237: begin
238: hr_utility.set_location('Entering:'||l_proc,10);
239: --
240: -- Continue if updating and either the third party or redirection_url fields
241: -- have been updated, or if inserting.
242: --

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

239: --
240: -- Continue if updating and either the third party or redirection_url fields
241: -- have been updated, or if inserting.
242: --
243: hr_utility.set_location(l_proc,20);
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

Line 251: hr_utility.set_location(l_proc,25);

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;
254: close csr_third_party;
255: --

Line 258: hr_utility.set_location(l_proc,60);

254: close csr_third_party;
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;

Line 263: hr_utility.set_location(' Leaving:'||l_proc,70);

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
265: when app_exception.application_exception then
266: if hr_multi_message.exception_add
267: (p_associated_column1 =>

Line 270: hr_utility.set_location(' Leaving:'||l_proc,80);

266: if hr_multi_message.exception_add
267: (p_associated_column1 =>
268: 'IRC_ALL_RECRUITING_SITES_TL.REDIRECTION_URL'
269: ) then
270: hr_utility.set_location(' Leaving:'||l_proc,80);
271: raise;
272: end if;
273: hr_utility.set_location(' Leaving:'||l_proc,90);
274: end chk_redirection_url;

Line 273: hr_utility.set_location(' Leaving:'||l_proc,90);

269: ) then
270: hr_utility.set_location(' Leaving:'||l_proc,80);
271: raise;
272: end if;
273: hr_utility.set_location(' Leaving:'||l_proc,90);
274: end chk_redirection_url;
275: --
276: --
277: -- ----------------------------------------------------------------------------

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

312: from irc_all_recruiting_sites
313: where recruiting_site_id = p_recruiting_site_id;
314: --
315: begin
316: hr_utility.set_location('Entering:'||l_proc,10);
317: --
318: -- Continue if updating and either the third party or redirection_url fields
319: -- have been updated, or if inserting.
320: --

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

317: --
318: -- Continue if updating and either the third party or redirection_url fields
319: -- have been updated, or if inserting.
320: --
321: hr_utility.set_location(l_proc,20);
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

Line 329: hr_utility.set_location(l_proc,25);

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;
332: close csr_third_party;
333: --

Line 340: hr_utility.set_location(l_proc,60);

336: or ( l_third_party = 'Y'
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;

Line 345: hr_utility.set_location(' Leaving:'||l_proc,70);

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
347: when app_exception.application_exception then
348: if hr_multi_message.exception_add
349: (p_associated_column1 =>

Line 352: hr_utility.set_location(' Leaving:'||l_proc,80);

348: if hr_multi_message.exception_add
349: (p_associated_column1 =>
350: 'IRC_ALL_RECRUITING_SITES_TL.POSTING_URL'
351: ) then
352: hr_utility.set_location(' Leaving:'||l_proc,80);
353: raise;
354: end if;
355: hr_utility.set_location(' Leaving:'||l_proc,90);
356: end chk_posting_url;

Line 355: hr_utility.set_location(' Leaving:'||l_proc,90);

351: ) then
352: hr_utility.set_location(' Leaving:'||l_proc,80);
353: raise;
354: end if;
355: hr_utility.set_location(' Leaving:'||l_proc,90);
356: end chk_posting_url;
357: --
358: --
359: -- ----------------------------------------------------------------------------

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

366: --
367: l_proc varchar2(72) := g_package||'insert_validate';
368: --
369: Begin
370: hr_utility.set_location('Entering:'||l_proc, 5);
371: --
372: -- Call all supporting business operations
373: --
374: irc_irt_bus.chk_source_lang

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

375: (
376: p_language => p_rec.language
377: ,p_source_lang => p_rec.source_lang
378: );
379: hr_utility.set_location(l_proc, 10);
380: irc_irt_bus.chk_site_name(
381: p_site_name => p_rec.site_name
382: ,p_language => p_rec.language
383: );

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

380: irc_irt_bus.chk_site_name(
381: p_site_name => p_rec.site_name
382: ,p_language => p_rec.language
383: );
384: hr_utility.set_location(l_proc, 20);
385: irc_irt_bus.chk_redirection_url
386: (
387: p_redirection_url => p_rec.redirection_url
388: ,p_recruiting_site_id => p_recruiting_site_id

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

386: (
387: p_redirection_url => p_rec.redirection_url
388: ,p_recruiting_site_id => p_recruiting_site_id
389: );
390: hr_utility.set_location(l_proc, 30);
391: irc_irt_bus.chk_posting_url
392: (
393: p_posting_url => p_rec.posting_url
394: ,p_recruiting_site_id => p_recruiting_site_id

Line 396: hr_utility.set_location(l_proc, 40);

392: (
393: p_posting_url => p_rec.posting_url
394: ,p_recruiting_site_id => p_recruiting_site_id
395: );
396: hr_utility.set_location(l_proc, 40);
397: --
398: hr_utility.set_location(' Leaving:'||l_proc, 50);
399: End insert_validate;
400: --

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

394: ,p_recruiting_site_id => p_recruiting_site_id
395: );
396: hr_utility.set_location(l_proc, 40);
397: --
398: hr_utility.set_location(' Leaving:'||l_proc, 50);
399: End insert_validate;
400: --
401: -- ----------------------------------------------------------------------------
402: -- |---------------------------< update_validate >----------------------------|

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

407: --
408: l_proc varchar2(72) := g_package||'update_validate';
409: --
410: Begin
411: hr_utility.set_location('Entering:'||l_proc, 5);
412: --
413: -- Call all supporting business operations
414: -- Validate Dependent Attributes
415: --

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

421: (
422: p_language => p_rec.language
423: ,p_source_lang => p_rec.source_lang
424: );
425: hr_utility.set_location(l_proc, 10);
426: irc_irt_bus.chk_site_name(
427: p_site_name => p_rec.site_name
428: ,p_language => p_rec.language
429: );

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

426: irc_irt_bus.chk_site_name(
427: p_site_name => p_rec.site_name
428: ,p_language => p_rec.language
429: );
430: hr_utility.set_location(l_proc, 20);
431: irc_irt_bus.chk_redirection_url
432: (
433: p_redirection_url => p_rec.redirection_url
434: ,p_recruiting_site_id => p_rec.recruiting_site_id

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

432: (
433: p_redirection_url => p_rec.redirection_url
434: ,p_recruiting_site_id => p_rec.recruiting_site_id
435: );
436: hr_utility.set_location(l_proc, 30);
437: irc_irt_bus.chk_posting_url
438: (
439: p_posting_url => p_rec.posting_url
440: ,p_recruiting_site_id => p_rec.recruiting_site_id

Line 442: hr_utility.set_location(l_proc, 40);

438: (
439: p_posting_url => p_rec.posting_url
440: ,p_recruiting_site_id => p_rec.recruiting_site_id
441: );
442: hr_utility.set_location(l_proc, 40);
443: --
444: hr_utility.set_location(' Leaving:'||l_proc, 50);
445: End update_validate;
446: --

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

440: ,p_recruiting_site_id => p_rec.recruiting_site_id
441: );
442: hr_utility.set_location(l_proc, 40);
443: --
444: hr_utility.set_location(' Leaving:'||l_proc, 50);
445: End update_validate;
446: --
447: -- ----------------------------------------------------------------------------
448: -- |---------------------------< delete_validate >----------------------------|

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

453: --
454: l_proc varchar2(72) := g_package||'delete_validate';
455: --
456: Begin
457: hr_utility.set_location('Entering:'||l_proc, 5);
458: --
459: -- Call all supporting business operations
460: --
461: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

457: hr_utility.set_location('Entering:'||l_proc, 5);
458: --
459: -- Call all supporting business operations
460: --
461: hr_utility.set_location(' Leaving:'||l_proc, 10);
462: End delete_validate;
463: --
464: end irc_irt_bus;