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_ILC_BUS dependencies on HR_UTILITY

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

45: l_legislation_code varchar2(150);
46: --
47: begin
48: --
49: hr_utility.set_location('Entering:'|| l_proc, 10);
50: --
51: -- Ensure that all the mandatory parameter are not null
52: --
53: hr_api.mandatory_arg_error

Line 89: hr_utility.set_location(' Leaving:'|| l_proc, 20);

85: --
86: hr_api.set_legislation_context(l_legislation_code);
87: end if;
88: --
89: hr_utility.set_location(' Leaving:'|| l_proc, 20);
90: --
91: end set_security_group_id;
92: --
93: -- ---------------------------------------------------------------------------

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

120: l_proc varchar2(72) := g_package||'return_legislation_code';
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'|| l_proc, 10);
125: --
126: -- Ensure that all the mandatory parameter are not null
127: --
128: hr_api.mandatory_arg_error

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

138: -- call to this function. Just return the value in the global
139: -- variable.
140: --
141: l_legislation_code := irc_ilc_bus.g_legislation_code;
142: hr_utility.set_location(l_proc, 20);
143: else
144: --
145: -- The ID is different to the last call to this function
146: -- or this is the first call to this function.

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

155: close csr_leg_code;
156: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
157: fnd_message.raise_error;
158: end if;
159: hr_utility.set_location(l_proc,30);
160: --
161: -- Set the global variables so the values are
162: -- available for the next call to this function.
163: --

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

164: close csr_leg_code;
165: irc_ilc_bus.g_link_id := p_link_id;
166: irc_ilc_bus.g_legislation_code := l_legislation_code;
167: end if;
168: hr_utility.set_location(' Leaving:'|| l_proc, 40);
169: return l_legislation_code;
170: end return_legislation_code;
171: --
172: -- ----------------------------------------------------------------------------

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

276: and trunc(p_effective_date) between ppf.effective_start_date
277: and ppf.effective_end_date;
278: --
279: begin
280: hr_utility.set_location('Entering:'||l_proc,10);
281: -- Check that Party_ID(Object_id) exists in per_all_people_f
282: open csr_party_id;
283: fetch csr_party_id into l_party_id;
284: hr_utility.set_location(l_proc,20);

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

280: hr_utility.set_location('Entering:'||l_proc,10);
281: -- Check that Party_ID(Object_id) exists in per_all_people_f
282: open csr_party_id;
283: fetch csr_party_id into l_party_id;
284: hr_utility.set_location(l_proc,20);
285: if csr_party_id%NOTFOUND then
286: close csr_party_id;
287: fnd_message.set_name('PER','IRC_412008_BAD_PARTY_PERSON_ID');
288: fnd_message.raise_error;

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

287: fnd_message.set_name('PER','IRC_412008_BAD_PARTY_PERSON_ID');
288: fnd_message.raise_error;
289: end if;
290: close csr_party_id;
291: hr_utility.set_location(' Leaving:'||l_proc,30);
292: exception
293: when app_exception.application_exception then
294: if hr_multi_message.exception_add
295: (p_associated_column1 =>

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

294: if hr_multi_message.exception_add
295: (p_associated_column1 =>
296: 'IRC_LINKED_CANDIDATES.PARTY_ID'
297: ) then
298: hr_utility.set_location(' Leaving:'||l_proc,40);
299: raise;
300: end if;
301: hr_utility.set_location(' Leaving:'||l_proc,50);
302: end chk_party_id;

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

297: ) then
298: hr_utility.set_location(' Leaving:'||l_proc,40);
299: raise;
300: end if;
301: hr_utility.set_location(' Leaving:'||l_proc,50);
302: end chk_party_id;
303: --
304: -- ----------------------------------------------------------------------------
305: -- |-----------------------------< chk_status >-------------------------------|

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

311: --
312: l_proc varchar2(72) := g_package||'chk_status';
313: l_not_exists boolean;
314: Begin
315: hr_utility.set_location('Entering:'||l_proc, 5);
316: --
317: if p_status is not null then
318: l_not_exists := hr_api.not_exists_in_hr_lookups
319: (p_effective_date

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

319: (p_effective_date
320: ,'IRC_CAND_LINK_STATUS'
321: ,p_status
322: );
323: hr_utility.set_location(l_proc, 10);
324: if (l_not_exists = true) then
325: -- RAISE ERROR SAYING THAT THE STATUS IS INVALID
326: fnd_message.set_name('PER','IRC_412628_INV_LINK_STATUS');
327: fnd_message.raise_error;

Line 330: hr_utility.set_location('leaving:'||l_proc, 15);

326: fnd_message.set_name('PER','IRC_412628_INV_LINK_STATUS');
327: fnd_message.raise_error;
328: end if;
329: end if;
330: hr_utility.set_location('leaving:'||l_proc, 15);
331: end chk_status;
332: --
333: -- ----------------------------------------------------------------------------
334: -- |-----------------------------< chk_cand_link >----------------------------|

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

348: and ilc.duplicate_set_id <> p_duplicate_set_id
349: and ilc.status in ('CONFIRMED','POTENTIAL');
350: --
351: Begin
352: hr_utility.set_location('Entering:'||l_proc, 10);
353: --
354: open csr_cand_link;
355: fetch csr_cand_link into l_cand_linked;
356: --

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

353: --
354: open csr_cand_link;
355: fetch csr_cand_link into l_cand_linked;
356: --
357: hr_utility.set_location(l_proc,20);
358: if csr_cand_link%FOUND then
359: close csr_cand_link;
360: fnd_message.set_name('PER','IRC_412629_ALREADY_LINKED');
361: fnd_message.raise_error;

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

360: fnd_message.set_name('PER','IRC_412629_ALREADY_LINKED');
361: fnd_message.raise_error;
362: end if;
363: close csr_cand_link;
364: hr_utility.set_location(' Leaving:'||l_proc,30);
365: --
366: exception
367: when app_exception.application_exception then
368: if hr_multi_message.exception_add

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

368: if hr_multi_message.exception_add
369: (p_associated_column1 =>
370: 'IRC_LINKED_CANDIDATES.PARTY_ID'
371: ) then
372: hr_utility.set_location(' Leaving:'||l_proc,40);
373: raise;
374: end if;
375: hr_utility.set_location(' Leaving:'||l_proc,50);
376: --

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

371: ) then
372: hr_utility.set_location(' Leaving:'||l_proc,40);
373: raise;
374: end if;
375: hr_utility.set_location(' Leaving:'||l_proc,50);
376: --
377: end chk_cand_link;
378: --
379: -- ----------------------------------------------------------------------------

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

393: where ilc.party_id = p_party_id
394: and ilc.duplicate_set_id = p_duplicate_set_id;
395: --
396: Begin
397: hr_utility.set_location('Entering:'||l_proc, 10);
398: --
399: open csr_duplcate_set;
400: fetch csr_duplcate_set into l_dup_set;
401: --

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

398: --
399: open csr_duplcate_set;
400: fetch csr_duplcate_set into l_dup_set;
401: --
402: hr_utility.set_location(l_proc,20);
403: if csr_duplcate_set%FOUND then
404: close csr_duplcate_set;
405: fnd_message.set_name('PER','IRC_412630_PTY_MARKED_AS_DUP');
406: fnd_message.raise_error;

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

405: fnd_message.set_name('PER','IRC_412630_PTY_MARKED_AS_DUP');
406: fnd_message.raise_error;
407: end if;
408: close csr_duplcate_set;
409: hr_utility.set_location(' Leaving:'||l_proc,30);
410: --
411: exception
412: when app_exception.application_exception then
413: if hr_multi_message.exception_add

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

415: 'IRC_LINKED_CANDIDATES.PARTY_ID'
416: ,p_associated_column2 =>
417: 'IRC_LINKED_CANDIDATES.DUPLICATE_SET_ID'
418: ) then
419: hr_utility.set_location(' Leaving:'||l_proc,40);
420: raise;
421: end if;
422: hr_utility.set_location(' Leaving:'||l_proc,50);
423: --

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

418: ) then
419: hr_utility.set_location(' Leaving:'||l_proc,40);
420: raise;
421: end if;
422: hr_utility.set_location(' Leaving:'||l_proc,50);
423: --
424: end chk_duplcate_set;
425: --
426: -- ----------------------------------------------------------------------------

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

433: --
434: l_proc varchar2(72) := g_package||'insert_validate';
435: --
436: Begin
437: hr_utility.set_location('Entering:'||l_proc, 10);
438: --
439: -- Call all supporting business operations
440: --
441: --

Line 455: hr_utility.set_location(' Leaving:'||l_proc, 20);

451: chk_party_id
452: (p_party_id => p_rec.party_id
453: ,p_effective_date => p_effective_date);
454: --
455: hr_utility.set_location(' Leaving:'||l_proc, 20);
456: --
457: if p_rec.target_party_id is not null then
458: --
459: chk_party_id

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

461: ,p_effective_date => p_effective_date);
462: --
463: end if;
464: --
465: hr_utility.set_location(' Leaving:'||l_proc, 30);
466: --
467: chk_status(p_status => p_rec.status
468: ,p_effective_date => p_effective_date);
469: --

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

466: --
467: chk_status(p_status => p_rec.status
468: ,p_effective_date => p_effective_date);
469: --
470: hr_utility.set_location(' Leaving:'||l_proc, 40);
471: --
472: if p_rec.status in ('CONFIRMED','POTENTIAL') then
473: --
474: chk_cand_link(p_party_id => p_rec.party_id

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

475: ,p_duplicate_set_id => p_rec.duplicate_set_id);
476: --
477: end if;
478: --
479: hr_utility.set_location(' Leaving:'||l_proc, 50);
480: --
481: chk_duplcate_set(p_party_id => p_rec.party_id
482: ,p_duplicate_set_id => p_rec.duplicate_set_id
483: );

Line 485: hr_utility.set_location(' Leaving:'||l_proc, 60);

481: chk_duplcate_set(p_party_id => p_rec.party_id
482: ,p_duplicate_set_id => p_rec.duplicate_set_id
483: );
484: --
485: hr_utility.set_location(' Leaving:'||l_proc, 60);
486: --
487: End insert_validate;
488: --
489: -- ----------------------------------------------------------------------------

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

496: --
497: l_proc varchar2(72) := g_package||'update_validate';
498: --
499: Begin
500: hr_utility.set_location('Entering:'||l_proc, 10);
501: --
502: -- Call all supporting business operations
503: --
504: --

Line 519: hr_utility.set_location(' Leaving:'||l_proc, 20);

515: (p_effective_date => p_effective_date
516: ,p_rec => p_rec
517: );
518: --
519: hr_utility.set_location(' Leaving:'||l_proc, 20);
520: --
521: chk_party_id
522: (p_party_id => p_rec.party_id
523: ,p_effective_date => p_effective_date);

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

521: chk_party_id
522: (p_party_id => p_rec.party_id
523: ,p_effective_date => p_effective_date);
524: --
525: hr_utility.set_location(' Leaving:'||l_proc, 30);
526: --
527: if p_rec.target_party_id is not null then
528: --
529: chk_party_id

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

531: ,p_effective_date => p_effective_date);
532: --
533: end if;
534: --
535: hr_utility.set_location(' Leaving:'||l_proc, 40);
536: --
537: chk_status(p_status => p_rec.status
538: ,p_effective_date => p_effective_date);
539: --

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

536: --
537: chk_status(p_status => p_rec.status
538: ,p_effective_date => p_effective_date);
539: --
540: hr_utility.set_location(' Leaving:'||l_proc, 50);
541: --
542: if p_rec.status in ('CONFIRMED','POTENTIAL') then
543: --
544: chk_cand_link(p_party_id => p_rec.party_id

Line 549: hr_utility.set_location(' Leaving:'||l_proc, 60);

545: ,p_duplicate_set_id => p_rec.duplicate_set_id);
546: --
547: end if;
548: --
549: hr_utility.set_location(' Leaving:'||l_proc, 60);
550: --
551: End update_validate;
552: --
553: -- ----------------------------------------------------------------------------

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

559: --
560: l_proc varchar2(72) := g_package||'delete_validate';
561: --
562: Begin
563: hr_utility.set_location('Entering:'||l_proc, 5);
564: --
565: -- Call all supporting business operations
566: --
567: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

563: hr_utility.set_location('Entering:'||l_proc, 5);
564: --
565: -- Call all supporting business operations
566: --
567: hr_utility.set_location(' Leaving:'||l_proc, 10);
568: End delete_validate;
569: --
570: end irc_ilc_bus;