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 204: hr_utility.set_location('Entering'||l_proc, 10);

200: where rownum<2;
201: --
202: BEGIN
203: --
204: hr_utility.set_location('Entering'||l_proc, 10);
205: l_person_name_with_id:=get_person_full_name(pPersonId)||'(person_id='||pPersonId||')';
206: open csr_offer_status;
207: fetch csr_offer_status into l_offer_status,
208: l_change_reason,

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

231: --REVIEW : The enrollment process did not run for AAAAAA for the following reason.
232: -- The person did not have an offer extended OR
233: -- The person declined the offer.
234: return false;
235: hr_utility.set_location(' Leaving:'||l_proc, 130);
236: end if;
237: --
238: END is_offer_accepted_or_extended;
239: --

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

263: ppf.current_employee_flag IS null;
264: --
265: BEGIN
266: --
267: hr_utility.set_location('Entering'||l_proc, 10);
268:
269: open csr_future_person_rec;
270: fetch csr_future_person_rec into l_person_name;
271: --

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

311: l_description_start varchar2(500);
312: l_description_end varchar2(500);
313: --
314: BEGIN
315: hr_utility.set_location('Entering'||l_proc,10);
316: hr_utility.set_location(' Person Id:'||pPersonId||' Vacancy Id:'||pVacancyid||' BusinessGroup Id:'||pBgId, 20);
317:
318: hr_utility.set_location('Calling the CP with UserName:'||fnd_global.user_name||',UserId='||fnd_global.user_id,30);
319: hr_utility.set_location('Responsibility Application Id:'||fnd_global.resp_appl_id||',Responsibility Id:'||fnd_global.resp_id,40);

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

312: l_description_end varchar2(500);
313: --
314: BEGIN
315: hr_utility.set_location('Entering'||l_proc,10);
316: hr_utility.set_location(' Person Id:'||pPersonId||' Vacancy Id:'||pVacancyid||' BusinessGroup Id:'||pBgId, 20);
317:
318: hr_utility.set_location('Calling the CP with UserName:'||fnd_global.user_name||',UserId='||fnd_global.user_id,30);
319: hr_utility.set_location('Responsibility Application Id:'||fnd_global.resp_appl_id||',Responsibility Id:'||fnd_global.resp_id,40);
320: hr_utility.set_location('Security Group Id:'||fnd_global.security_group_id, 50);

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

314: BEGIN
315: hr_utility.set_location('Entering'||l_proc,10);
316: hr_utility.set_location(' Person Id:'||pPersonId||' Vacancy Id:'||pVacancyid||' BusinessGroup Id:'||pBgId, 20);
317:
318: hr_utility.set_location('Calling the CP with UserName:'||fnd_global.user_name||',UserId='||fnd_global.user_id,30);
319: hr_utility.set_location('Responsibility Application Id:'||fnd_global.resp_appl_id||',Responsibility Id:'||fnd_global.resp_id,40);
320: hr_utility.set_location('Security Group Id:'||fnd_global.security_group_id, 50);
321:
322: fnd_message.set_name('PER','IRC_412237_CRT_ENRLM_STRTD');

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

315: hr_utility.set_location('Entering'||l_proc,10);
316: hr_utility.set_location(' Person Id:'||pPersonId||' Vacancy Id:'||pVacancyid||' BusinessGroup Id:'||pBgId, 20);
317:
318: hr_utility.set_location('Calling the CP with UserName:'||fnd_global.user_name||',UserId='||fnd_global.user_id,30);
319: hr_utility.set_location('Responsibility Application Id:'||fnd_global.resp_appl_id||',Responsibility Id:'||fnd_global.resp_id,40);
320: hr_utility.set_location('Security Group Id:'||fnd_global.security_group_id, 50);
321:
322: fnd_message.set_name('PER','IRC_412237_CRT_ENRLM_STRTD');
323: l_description_start:=substrb(fnd_message.get,1,500);

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

316: hr_utility.set_location(' Person Id:'||pPersonId||' Vacancy Id:'||pVacancyid||' BusinessGroup Id:'||pBgId, 20);
317:
318: hr_utility.set_location('Calling the CP with UserName:'||fnd_global.user_name||',UserId='||fnd_global.user_id,30);
319: hr_utility.set_location('Responsibility Application Id:'||fnd_global.resp_appl_id||',Responsibility Id:'||fnd_global.resp_id,40);
320: hr_utility.set_location('Security Group Id:'||fnd_global.security_group_id, 50);
321:
322: fnd_message.set_name('PER','IRC_412237_CRT_ENRLM_STRTD');
323: l_description_start:=substrb(fnd_message.get,1,500);
324: fnd_message.clear;

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

387: fnd_message.raise_error;
388: end if;
389: end if;
390: end if;
391: hr_utility.set_location('retcode='||retcode||' and errbuf='||errbuf, 60);
392: hr_utility.set_location(' Leaving:'||l_proc, 70);
393: --
394: END populate_Pay_Elements;
395: --

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

388: end if;
389: end if;
390: end if;
391: hr_utility.set_location('retcode='||retcode||' and errbuf='||errbuf, 60);
392: hr_utility.set_location(' Leaving:'||l_proc, 70);
393: --
394: END populate_Pay_Elements;
395: --
396:

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

411: l_proc varchar2(80) default g_package||'.populate_for_bg';
412: --
413: BEGIN
414: --
415: hr_utility.set_location('Entering'||l_proc, 10);
416: for vacancypersonQuery_rec in vacancypersonQuery(pBgId) LOOP
417: fnd_file.put_line(fnd_file.log,
418: '+---------------------------------------------------------------------------+');
419: if is_person_future_terminated(vacancypersonQuery_rec.person_id) then

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

417: fnd_file.put_line(fnd_file.log,
418: '+---------------------------------------------------------------------------+');
419: if is_person_future_terminated(vacancypersonQuery_rec.person_id) then
420: --do not run the process if the person is terminated in future.
421: hr_utility.set_location('Entering'||l_proc, 20);
422: else
423: if is_offer_accepted_or_extended(
424: vacancypersonQuery_rec.person_id,
425: vacancypersonQuery_rec.assignment_id)

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

433: end if;
434: fnd_file.put_line(fnd_file.log,
435: '+---------------------------------------------------------------------------+');
436: end loop;
437: hr_utility.set_location(' Leaving:'||l_proc, 20);
438: --
439: END populate_for_bg;
440: --
441:

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

456: l_proc varchar2(80) default g_package||'.populate_for_vacancy';
457: --
458: BEGIN
459: --
460: hr_utility.set_location('Entering'||l_proc, 10);
461: for personQuery_rec in personQuery(pVacancyId) LOOP
462: fnd_file.put_line(fnd_file.log,
463: '+---------------------------------------------------------------------------+');
464:

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

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

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

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

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

522: pil.assignment_id = paaf.assignment_id;
523: --
524: BEGIN
525: --
526: hr_utility.set_location('Entering'||l_proc, 10);
527: fnd_file.put_line(fnd_file.log,
528: '+---------------------------------------------------------------------------+');
529:
530: open csr_assignment;

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

538: l_description:=substrb(fnd_message.get,1,500);
539: fnd_message.clear;
540:
541: fnd_file.put_line(fnd_file.log,l_description);
542: hr_utility.set_location(l_proc,20);
543: --
544: else
545: close csr_assignment;
546:

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

545: close csr_assignment;
546:
547: if is_person_future_terminated(pPersonid) then
548: --do not run the process if the person is terminated in future.
549: hr_utility.set_location(l_proc,30);
550: else
551: if is_offer_accepted_or_extended(pPersonid,l_assignment_id) then
552: run_enrollment(errbuf, retcode,
553: pPersonId,

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

556: l_business_group_id);
557: end if;
558: end if;
559: end if;
560: hr_utility.set_location(' Leaving:'||l_proc, 30);
561: fnd_file.put_line(fnd_file.log,
562: '+---------------------------------------------------------------------------+');
563: --
564: END populate_for_person;

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

592: from ben_prtt_enrt_rslt_f
593: where person_id = pPersonId;
594: BEGIN
595: --
596: hr_utility.set_location('Entering '||l_proc, 10);
597: l_person_name_with_id:=get_person_full_name(pPersonId)||'(person_id='||pPersonId||')';
598: l_person_name:=get_person_full_name(pPersonId);
599: l_hire_date:=get_person_hire_date(pPersonId);
600:

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

650: --
651: end if;
652: --
653: --
654: hr_utility.set_location('Leaving '||l_proc, 20);
655: EXCEPTION
656: --
657: when others then
658: --

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

655: EXCEPTION
656: --
657: when others then
658: --
659: hr_utility.set_location(substr(SQLERRM,1,30),1234);
660: hr_utility.set_location(substr(SQLERRM,31,60),1235);
661: hr_utility.set_location(substr(SQLERRM,61,90),1236);
662: hr_utility.set_location(substr(SQLERRM,91,120),1237);
663: errbuf:=fnd_message.get;

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

656: --
657: when others then
658: --
659: hr_utility.set_location(substr(SQLERRM,1,30),1234);
660: hr_utility.set_location(substr(SQLERRM,31,60),1235);
661: hr_utility.set_location(substr(SQLERRM,61,90),1236);
662: hr_utility.set_location(substr(SQLERRM,91,120),1237);
663: errbuf:=fnd_message.get;
664: --

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

657: when others then
658: --
659: hr_utility.set_location(substr(SQLERRM,1,30),1234);
660: hr_utility.set_location(substr(SQLERRM,31,60),1235);
661: hr_utility.set_location(substr(SQLERRM,61,90),1236);
662: hr_utility.set_location(substr(SQLERRM,91,120),1237);
663: errbuf:=fnd_message.get;
664: --
665: -- Set the return parameters to indicate failure

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

658: --
659: hr_utility.set_location(substr(SQLERRM,1,30),1234);
660: hr_utility.set_location(substr(SQLERRM,31,60),1235);
661: hr_utility.set_location(substr(SQLERRM,61,90),1236);
662: hr_utility.set_location(substr(SQLERRM,91,120),1237);
663: errbuf:=fnd_message.get;
664: --
665: -- Set the return parameters to indicate failure
666: --

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

675: --REVIEW : The enrollment process errored out for the person XXXXXXX with the following message.
676: -- ERROR :
677:
678: retcode := 2;
679: hr_utility.set_location('Leaving '||l_proc, 30);
680: END run_enrollment;
681: --
682: --
683: END PER_IREC_ICD_ENRLL_PROCESS;