DBA Data[Home] [Help]

APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on FND_FILE

Line 277: fnd_file.put_line(fnd_file.log,l_description);

273: fnd_message.set_token('PERSON_NAME',l_person_name_with_id);
274: l_description:=substrb(fnd_message.get,1,500);
275: fnd_message.clear;
276:
277: fnd_file.put_line(fnd_file.log,l_description);
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;

Line 332: fnd_file.put_line(fnd_file.log,l_description);

328: fnd_message.set_token('PERSON_NAME',l_person_name||'(person_id='||pPersonId||')');
329: l_description:=substrb(fnd_message.get,1,500);
330: fnd_message.clear;
331:
332: fnd_file.put_line(fnd_file.log,l_description);
333: return true;
334: end if;
335: --
336: END is_person_future_terminated;

Line 381: fnd_file.put_line(fnd_file.log,l_description_start||

377: if pPersonId is not null THEN
378: l_person_name:=get_person_full_name(pPersonId);
379: l_vacancy_name:=get_vacancy_name(pVacancyid);
380: l_bg_name:=get_business_group_name(pBgId);
381: fnd_file.put_line(fnd_file.log,l_description_start||
382: '
383: Person :'||l_person_name||
384: '
385: Person Id :'||pPersonId);

Line 386: fnd_file.put_line(fnd_file.log,

382: '
383: Person :'||l_person_name||
384: '
385: Person Id :'||pPersonId);
386: fnd_file.put_line(fnd_file.log,
387: 'Vacancy :'||l_vacancy_name||
388: '
389: Vacancy Id :'||pVacancyId);
390: fnd_file.put_line(fnd_file.log,

Line 390: fnd_file.put_line(fnd_file.log,

386: fnd_file.put_line(fnd_file.log,
387: 'Vacancy :'||l_vacancy_name||
388: '
389: Vacancy Id :'||pVacancyId);
390: fnd_file.put_line(fnd_file.log,
391: 'Business Group :'||l_bg_name||
392: '
393: Business Group Id :'||pBgId);
394: fnd_file.put_line(fnd_file.log,

Line 394: fnd_file.put_line(fnd_file.log,

390: fnd_file.put_line(fnd_file.log,
391: 'Business Group :'||l_bg_name||
392: '
393: Business Group Id :'||pBgId);
394: fnd_file.put_line(fnd_file.log,
395: '+---------------------------------------------------------------------------+');
396: --REVIEW: The iRecruitment Create Enrollment process is started.
397: -- Person : XXXXXX
398: -- Person Id : 121212

Line 400: fnd_file.put_line(fnd_file.log, l_description_end);

396: --REVIEW: The iRecruitment Create Enrollment process is started.
397: -- Person : XXXXXX
398: -- Person Id : 121212
399: populate_for_person(errbuf, retcode, pPersonId);
400: fnd_file.put_line(fnd_file.log, l_description_end);
401: --REVIEW: The iRecruitment Create Enrollment process is completed.
402:
403: else
404: if pVacancyid is not null THEN

Line 407: fnd_file.put_line(fnd_file.log,l_description_start||

403: else
404: if pVacancyid is not null THEN
405: l_vacancy_name:=get_vacancy_name(pVacancyid);
406: l_bg_name:=get_business_group_name(pBgId);
407: fnd_file.put_line(fnd_file.log,l_description_start||
408: '
409: Vacancy :'||l_vacancy_name||
410: '
411: Vacancy Id :'||pVacancyid);

Line 412: fnd_file.put_line(fnd_file.log,

408: '
409: Vacancy :'||l_vacancy_name||
410: '
411: Vacancy Id :'||pVacancyid);
412: fnd_file.put_line(fnd_file.log,
413: 'Business Group :'||l_bg_name||
414: '
415: Business Group Id :'||pBgId);
416: fnd_file.put_line(fnd_file.log,

Line 416: fnd_file.put_line(fnd_file.log,

412: fnd_file.put_line(fnd_file.log,
413: 'Business Group :'||l_bg_name||
414: '
415: Business Group Id :'||pBgId);
416: fnd_file.put_line(fnd_file.log,
417: '+---------------------------------------------------------------------------+');
418: populate_for_vacancy(errbuf, retcode, pVacancyid);
419: fnd_file.put_line(fnd_file.log, l_description_end);
420: else

Line 419: fnd_file.put_line(fnd_file.log, l_description_end);

415: Business Group Id :'||pBgId);
416: fnd_file.put_line(fnd_file.log,
417: '+---------------------------------------------------------------------------+');
418: populate_for_vacancy(errbuf, retcode, pVacancyid);
419: fnd_file.put_line(fnd_file.log, l_description_end);
420: else
421: if pBgId is not null THEN
422: l_bg_name:=get_business_group_name(pBgId);
423: fnd_file.put_line(fnd_file.log,l_description_start||

Line 423: fnd_file.put_line(fnd_file.log,l_description_start||

419: fnd_file.put_line(fnd_file.log, l_description_end);
420: else
421: if pBgId is not null THEN
422: l_bg_name:=get_business_group_name(pBgId);
423: fnd_file.put_line(fnd_file.log,l_description_start||
424: '
425: Business Group :'||l_bg_name||
426: '
427: Business Group Id :'||pBgId);

Line 428: fnd_file.put_line(fnd_file.log,

424: '
425: Business Group :'||l_bg_name||
426: '
427: Business Group Id :'||pBgId);
428: fnd_file.put_line(fnd_file.log,
429: '+---------------------------------------------------------------------------+');
430: populate_for_bg(errbuf, retcode, pBgId);
431: fnd_file.put_line(fnd_file.log, l_description_end);
432: else

Line 431: fnd_file.put_line(fnd_file.log, l_description_end);

427: Business Group Id :'||pBgId);
428: fnd_file.put_line(fnd_file.log,
429: '+---------------------------------------------------------------------------+');
430: populate_for_bg(errbuf, retcode, pBgId);
431: fnd_file.put_line(fnd_file.log, l_description_end);
432: else
433: fnd_message.set_name('PER','HR_289541_PJU_INV_BG_ID');
434: fnd_message.raise_error;
435: end if;

Line 464: fnd_file.put_line(fnd_file.log,

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
467: --do not run the process if the person is terminated in future.
468: hr_utility.set_location('Entering'||l_proc, 20);

Line 481: fnd_file.put_line(fnd_file.log,

477: vacancypersonQuery_rec.PER_IN_LER_id,
478: vacancypersonQuery_rec.BUSINESS_GROUP_id);
479: end if;
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: --

Line 509: fnd_file.put_line(fnd_file.log,

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:
512: if is_person_future_terminated(personQuery_rec.person_id) then
513: --do not run the process if the person is terminated in future.

Line 527: fnd_file.put_line(fnd_file.log,

523: personQuery_rec.PER_IN_LER_id,
524: personQuery_rec.BUSINESS_GROUP_id);
525: end if;
526: end if;
527: fnd_file.put_line(fnd_file.log,
528: '+---------------------------------------------------------------------------+');
529:
530: end loop;
531: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 574: fnd_file.put_line(fnd_file.log,

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;
578: fetch csr_assignment into l_assignment_id,l_business_group_id,l_per_in_ler_id;

Line 588: fnd_file.put_line(fnd_file.log,l_description);

584: fnd_message.set_token('PERSON_NAME',get_person_full_name(pPersonId)||'(person_id='||pPersonId||')');
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;

Line 608: fnd_file.put_line(fnd_file.log,

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;
612: --

Line 654: fnd_file.put_line(fnd_file.log, l_description);

650: fnd_message.set_token('HIRE_DATE',l_hire_date);
651: l_description:=substrb(fnd_message.get,1,500);
652: fnd_message.clear;
653:
654: fnd_file.put_line(fnd_file.log, l_description);
655:
656: ben_irec_process.create_enrollment_for_irec(
657: p_irec_per_in_ler_id => pPerInLerId
658: ,p_person_id => pPersonId

Line 680: fnd_file.put_line(fnd_file.log, l_description);

676: fnd_message.set_token('PERSON_NAME',l_person_name);
677: l_description:=substrb(fnd_message.get,1,500);
678: fnd_message.clear;
679:
680: fnd_file.put_line(fnd_file.log, l_description);
681: --
682: else
683: --
684: close c_participation;

Line 693: fnd_file.put_line(fnd_file.log, l_description||

689: fnd_message.set_token('PERSON_NAME',l_person_name);
690: l_description:=substrb(fnd_message.get,1,500);
691: fnd_message.clear;
692:
693: fnd_file.put_line(fnd_file.log, l_description||
694: '
695: '||errbuf);
696: retcode := 2;
697: --

Line 719: fnd_file.put_line(fnd_file.log, l_description||

715: fnd_message.set_token('PERSON_NAME',l_person_name);
716: l_description:=substrb(fnd_message.get,1,500);
717: fnd_message.clear;
718:
719: fnd_file.put_line(fnd_file.log, l_description||
720: '
721: '||errbuf);
722: --REVIEW : The enrollment process errored out for the person XXXXXXX with the following message.
723: -- ERROR :