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.PER_IREC_ICD_ENRLL_PROCESS dependencies on HR_UTILITY

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

244: where rownum<2;
245: --
246: BEGIN
247: --
248: hr_utility.set_location('Entering'||l_proc, 10);
249: l_person_name_with_id:=get_person_full_name(pPersonId)||'(person_id='||pPersonId||')';
250: open csr_offer_status;
251: fetch csr_offer_status into l_offer_status,
252: l_change_reason,

Line 282: hr_utility.set_location(' Leaving:'||l_proc, 130);

278: --REVIEW : The enrollment process did not run for AAAAAA for the following reason.
279: -- The person did not have an offer extended OR
280: -- The person declined the offer.
281: return false;
282: hr_utility.set_location(' Leaving:'||l_proc, 130);
283: end if;
284: --
285: END is_offer_accepted_or_extended;
286: --

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

310: ppf.current_employee_flag IS null;
311: --
312: BEGIN
313: --
314: hr_utility.set_location('Entering'||l_proc, 10);
315:
316: open csr_future_person_rec;
317: fetch csr_future_person_rec into l_person_name;
318: --

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

358: l_description_start varchar2(500);
359: l_description_end varchar2(500);
360: --
361: BEGIN
362: hr_utility.set_location('Entering'||l_proc,10);
363: hr_utility.set_location(' Person Id:'||pPersonId||' Vacancy Id:'||pVacancyid||' BusinessGroup Id:'||pBgId, 20);
364:
365: hr_utility.set_location('Calling the CP with UserName:'||fnd_global.user_name||',UserId='||fnd_global.user_id,30);
366: hr_utility.set_location('Responsibility Application Id:'||fnd_global.resp_appl_id||',Responsibility Id:'||fnd_global.resp_id,40);

Line 363: hr_utility.set_location(' Person Id:'||pPersonId||' Vacancy Id:'||pVacancyid||' BusinessGroup Id:'||pBgId, 20);

359: l_description_end varchar2(500);
360: --
361: BEGIN
362: hr_utility.set_location('Entering'||l_proc,10);
363: hr_utility.set_location(' Person Id:'||pPersonId||' Vacancy Id:'||pVacancyid||' BusinessGroup Id:'||pBgId, 20);
364:
365: hr_utility.set_location('Calling the CP with UserName:'||fnd_global.user_name||',UserId='||fnd_global.user_id,30);
366: hr_utility.set_location('Responsibility Application Id:'||fnd_global.resp_appl_id||',Responsibility Id:'||fnd_global.resp_id,40);
367: hr_utility.set_location('Security Group Id:'||fnd_global.security_group_id, 50);

Line 365: hr_utility.set_location('Calling the CP with UserName:'||fnd_global.user_name||',UserId='||fnd_global.user_id,30);

361: BEGIN
362: hr_utility.set_location('Entering'||l_proc,10);
363: hr_utility.set_location(' Person Id:'||pPersonId||' Vacancy Id:'||pVacancyid||' BusinessGroup Id:'||pBgId, 20);
364:
365: hr_utility.set_location('Calling the CP with UserName:'||fnd_global.user_name||',UserId='||fnd_global.user_id,30);
366: hr_utility.set_location('Responsibility Application Id:'||fnd_global.resp_appl_id||',Responsibility Id:'||fnd_global.resp_id,40);
367: hr_utility.set_location('Security Group Id:'||fnd_global.security_group_id, 50);
368:
369: fnd_message.set_name('PER','IRC_412237_CRT_ENRLM_STRTD');

Line 366: hr_utility.set_location('Responsibility Application Id:'||fnd_global.resp_appl_id||',Responsibility Id:'||fnd_global.resp_id,40);

362: hr_utility.set_location('Entering'||l_proc,10);
363: hr_utility.set_location(' Person Id:'||pPersonId||' Vacancy Id:'||pVacancyid||' BusinessGroup Id:'||pBgId, 20);
364:
365: hr_utility.set_location('Calling the CP with UserName:'||fnd_global.user_name||',UserId='||fnd_global.user_id,30);
366: hr_utility.set_location('Responsibility Application Id:'||fnd_global.resp_appl_id||',Responsibility Id:'||fnd_global.resp_id,40);
367: hr_utility.set_location('Security Group Id:'||fnd_global.security_group_id, 50);
368:
369: fnd_message.set_name('PER','IRC_412237_CRT_ENRLM_STRTD');
370: l_description_start:=substrb(fnd_message.get,1,500);

Line 367: hr_utility.set_location('Security Group Id:'||fnd_global.security_group_id, 50);

363: hr_utility.set_location(' Person Id:'||pPersonId||' Vacancy Id:'||pVacancyid||' BusinessGroup Id:'||pBgId, 20);
364:
365: hr_utility.set_location('Calling the CP with UserName:'||fnd_global.user_name||',UserId='||fnd_global.user_id,30);
366: hr_utility.set_location('Responsibility Application Id:'||fnd_global.resp_appl_id||',Responsibility Id:'||fnd_global.resp_id,40);
367: hr_utility.set_location('Security Group Id:'||fnd_global.security_group_id, 50);
368:
369: fnd_message.set_name('PER','IRC_412237_CRT_ENRLM_STRTD');
370: l_description_start:=substrb(fnd_message.get,1,500);
371: fnd_message.clear;

Line 438: hr_utility.set_location('retcode='||retcode||' and errbuf='||errbuf, 60);

434: fnd_message.raise_error;
435: end if;
436: end if;
437: end if;
438: hr_utility.set_location('retcode='||retcode||' and errbuf='||errbuf, 60);
439: hr_utility.set_location(' Leaving:'||l_proc, 70);
440: --
441: END populate_Pay_Elements;
442: --

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

435: end if;
436: end if;
437: end if;
438: hr_utility.set_location('retcode='||retcode||' and errbuf='||errbuf, 60);
439: hr_utility.set_location(' Leaving:'||l_proc, 70);
440: --
441: END populate_Pay_Elements;
442: --
443:

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

458: l_proc varchar2(80) default g_package||'.populate_for_bg';
459: --
460: BEGIN
461: --
462: hr_utility.set_location('Entering'||l_proc, 10);
463: for vacancypersonQuery_rec in vacancypersonQuery(pBgId) LOOP
464: fnd_file.put_line(fnd_file.log,
465: '+---------------------------------------------------------------------------+');
466: if is_person_future_terminated(vacancypersonQuery_rec.person_id) then

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

464: fnd_file.put_line(fnd_file.log,
465: '+---------------------------------------------------------------------------+');
466: if is_person_future_terminated(vacancypersonQuery_rec.person_id) then
467: --do not run the process if the person is terminated in future.
468: hr_utility.set_location('Entering'||l_proc, 20);
469: else
470: if is_offer_accepted_or_extended(
471: vacancypersonQuery_rec.person_id,
472: vacancypersonQuery_rec.assignment_id)

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

480: end if;
481: fnd_file.put_line(fnd_file.log,
482: '+---------------------------------------------------------------------------+');
483: end loop;
484: hr_utility.set_location(' Leaving:'||l_proc, 20);
485: --
486: END populate_for_bg;
487: --
488:

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

503: l_proc varchar2(80) default g_package||'.populate_for_vacancy';
504: --
505: BEGIN
506: --
507: hr_utility.set_location('Entering'||l_proc, 10);
508: for personQuery_rec in personQuery(pVacancyId) LOOP
509: fnd_file.put_line(fnd_file.log,
510: '+---------------------------------------------------------------------------+');
511:

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

510: '+---------------------------------------------------------------------------+');
511:
512: if is_person_future_terminated(personQuery_rec.person_id) then
513: --do not run the process if the person is terminated in future.
514: hr_utility.set_location('Entering'||l_proc, 20);
515: else
516: if is_offer_accepted_or_extended(
517: personQuery_rec.person_id,
518: personQuery_rec.assignment_id)

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

527: fnd_file.put_line(fnd_file.log,
528: '+---------------------------------------------------------------------------+');
529:
530: end loop;
531: hr_utility.set_location(' Leaving:'||l_proc, 20);
532: --
533: END populate_for_vacancy;
534: --
535:

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

569: pil.assignment_id = paaf.assignment_id;
570: --
571: BEGIN
572: --
573: hr_utility.set_location('Entering'||l_proc, 10);
574: fnd_file.put_line(fnd_file.log,
575: '+---------------------------------------------------------------------------+');
576:
577: open csr_assignment;

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

585: l_description:=substrb(fnd_message.get,1,500);
586: fnd_message.clear;
587:
588: fnd_file.put_line(fnd_file.log,l_description);
589: hr_utility.set_location(l_proc,20);
590: --
591: else
592: close csr_assignment;
593:

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

592: close csr_assignment;
593:
594: if is_person_future_terminated(pPersonid) then
595: --do not run the process if the person is terminated in future.
596: hr_utility.set_location(l_proc,30);
597: else
598: if is_offer_accepted_or_extended(pPersonid,l_assignment_id) then
599: run_enrollment(errbuf, retcode,
600: pPersonId,

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

603: l_business_group_id);
604: end if;
605: end if;
606: end if;
607: hr_utility.set_location(' Leaving:'||l_proc, 30);
608: fnd_file.put_line(fnd_file.log,
609: '+---------------------------------------------------------------------------+');
610: --
611: END populate_for_person;

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

639: from ben_prtt_enrt_rslt_f
640: where person_id = pPersonId;
641: BEGIN
642: --
643: hr_utility.set_location('Entering '||l_proc, 10);
644: l_person_name_with_id:=get_person_full_name(pPersonId)||'(person_id='||pPersonId||')';
645: l_person_name:=get_person_full_name(pPersonId);
646: l_hire_date:=get_person_hire_date(pAssignmentId);
647:

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

697: --
698: end if;
699: --
700: --
701: hr_utility.set_location('Leaving '||l_proc, 20);
702: EXCEPTION
703: --
704: when others then
705: --

Line 706: hr_utility.set_location(substr(SQLERRM,1,30),1234);

702: EXCEPTION
703: --
704: when others then
705: --
706: hr_utility.set_location(substr(SQLERRM,1,30),1234);
707: hr_utility.set_location(substr(SQLERRM,31,60),1235);
708: hr_utility.set_location(substr(SQLERRM,61,90),1236);
709: hr_utility.set_location(substr(SQLERRM,91,120),1237);
710: errbuf:=fnd_message.get;

Line 707: hr_utility.set_location(substr(SQLERRM,31,60),1235);

703: --
704: when others then
705: --
706: hr_utility.set_location(substr(SQLERRM,1,30),1234);
707: hr_utility.set_location(substr(SQLERRM,31,60),1235);
708: hr_utility.set_location(substr(SQLERRM,61,90),1236);
709: hr_utility.set_location(substr(SQLERRM,91,120),1237);
710: errbuf:=fnd_message.get;
711: --

Line 708: hr_utility.set_location(substr(SQLERRM,61,90),1236);

704: when others then
705: --
706: hr_utility.set_location(substr(SQLERRM,1,30),1234);
707: hr_utility.set_location(substr(SQLERRM,31,60),1235);
708: hr_utility.set_location(substr(SQLERRM,61,90),1236);
709: hr_utility.set_location(substr(SQLERRM,91,120),1237);
710: errbuf:=fnd_message.get;
711: --
712: -- Set the return parameters to indicate failure

Line 709: hr_utility.set_location(substr(SQLERRM,91,120),1237);

705: --
706: hr_utility.set_location(substr(SQLERRM,1,30),1234);
707: hr_utility.set_location(substr(SQLERRM,31,60),1235);
708: hr_utility.set_location(substr(SQLERRM,61,90),1236);
709: hr_utility.set_location(substr(SQLERRM,91,120),1237);
710: errbuf:=fnd_message.get;
711: --
712: -- Set the return parameters to indicate failure
713: --

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

722: --REVIEW : The enrollment process errored out for the person XXXXXXX with the following message.
723: -- ERROR :
724:
725: retcode := 2;
726: hr_utility.set_location('Leaving '||l_proc, 30);
727: END run_enrollment;
728: --
729: --
730: END PER_IREC_ICD_ENRLL_PROCESS;