DBA Data[Home] [Help]

APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on FND_FILE

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

226: fnd_message.set_token('PERSON_NAME',l_person_name_with_id);
227: l_description:=substrb(fnd_message.get,1,500);
228: fnd_message.clear;
229:
230: fnd_file.put_line(fnd_file.log,l_description);
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;

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

281: fnd_message.set_token('PERSON_NAME',l_person_name||'(person_id='||pPersonId||')');
282: l_description:=substrb(fnd_message.get,1,500);
283: fnd_message.clear;
284:
285: fnd_file.put_line(fnd_file.log,l_description);
286: return true;
287: end if;
288: --
289: END is_person_future_terminated;

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

330: if pPersonId is not null THEN
331: l_person_name:=get_person_full_name(pPersonId);
332: l_vacancy_name:=get_vacancy_name(pVacancyid);
333: l_bg_name:=get_business_group_name(pBgId);
334: fnd_file.put_line(fnd_file.log,l_description_start||
335: '
336: Person :'||l_person_name||
337: '
338: Person Id :'||pPersonId);

Line 339: fnd_file.put_line(fnd_file.log,

335: '
336: Person :'||l_person_name||
337: '
338: Person Id :'||pPersonId);
339: fnd_file.put_line(fnd_file.log,
340: 'Vacancy :'||l_vacancy_name||
341: '
342: Vacancy Id :'||pVacancyId);
343: fnd_file.put_line(fnd_file.log,

Line 343: fnd_file.put_line(fnd_file.log,

339: fnd_file.put_line(fnd_file.log,
340: 'Vacancy :'||l_vacancy_name||
341: '
342: Vacancy Id :'||pVacancyId);
343: fnd_file.put_line(fnd_file.log,
344: 'Business Group :'||l_bg_name||
345: '
346: Business Group Id :'||pBgId);
347: fnd_file.put_line(fnd_file.log,

Line 347: fnd_file.put_line(fnd_file.log,

343: fnd_file.put_line(fnd_file.log,
344: 'Business Group :'||l_bg_name||
345: '
346: Business Group Id :'||pBgId);
347: fnd_file.put_line(fnd_file.log,
348: '+---------------------------------------------------------------------------+');
349: --REVIEW: The iRecruitment Create Enrollment process is started.
350: -- Person : XXXXXX
351: -- Person Id : 121212

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

349: --REVIEW: The iRecruitment Create Enrollment process is started.
350: -- Person : XXXXXX
351: -- Person Id : 121212
352: populate_for_person(errbuf, retcode, pPersonId);
353: fnd_file.put_line(fnd_file.log, l_description_end);
354: --REVIEW: The iRecruitment Create Enrollment process is completed.
355:
356: else
357: if pVacancyid is not null THEN

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

356: else
357: if pVacancyid is not null THEN
358: l_vacancy_name:=get_vacancy_name(pVacancyid);
359: l_bg_name:=get_business_group_name(pBgId);
360: fnd_file.put_line(fnd_file.log,l_description_start||
361: '
362: Vacancy :'||l_vacancy_name||
363: '
364: Vacancy Id :'||pVacancyid);

Line 365: fnd_file.put_line(fnd_file.log,

361: '
362: Vacancy :'||l_vacancy_name||
363: '
364: Vacancy Id :'||pVacancyid);
365: fnd_file.put_line(fnd_file.log,
366: 'Business Group :'||l_bg_name||
367: '
368: Business Group Id :'||pBgId);
369: fnd_file.put_line(fnd_file.log,

Line 369: fnd_file.put_line(fnd_file.log,

365: fnd_file.put_line(fnd_file.log,
366: 'Business Group :'||l_bg_name||
367: '
368: Business Group Id :'||pBgId);
369: fnd_file.put_line(fnd_file.log,
370: '+---------------------------------------------------------------------------+');
371: populate_for_vacancy(errbuf, retcode, pVacancyid);
372: fnd_file.put_line(fnd_file.log, l_description_end);
373: else

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

368: Business Group Id :'||pBgId);
369: fnd_file.put_line(fnd_file.log,
370: '+---------------------------------------------------------------------------+');
371: populate_for_vacancy(errbuf, retcode, pVacancyid);
372: fnd_file.put_line(fnd_file.log, l_description_end);
373: else
374: if pBgId is not null THEN
375: l_bg_name:=get_business_group_name(pBgId);
376: fnd_file.put_line(fnd_file.log,l_description_start||

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

372: fnd_file.put_line(fnd_file.log, l_description_end);
373: else
374: if pBgId is not null THEN
375: l_bg_name:=get_business_group_name(pBgId);
376: fnd_file.put_line(fnd_file.log,l_description_start||
377: '
378: Business Group :'||l_bg_name||
379: '
380: Business Group Id :'||pBgId);

Line 381: fnd_file.put_line(fnd_file.log,

377: '
378: Business Group :'||l_bg_name||
379: '
380: Business Group Id :'||pBgId);
381: fnd_file.put_line(fnd_file.log,
382: '+---------------------------------------------------------------------------+');
383: populate_for_bg(errbuf, retcode, pBgId);
384: fnd_file.put_line(fnd_file.log, l_description_end);
385: else

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

380: Business Group Id :'||pBgId);
381: fnd_file.put_line(fnd_file.log,
382: '+---------------------------------------------------------------------------+');
383: populate_for_bg(errbuf, retcode, pBgId);
384: fnd_file.put_line(fnd_file.log, l_description_end);
385: else
386: fnd_message.set_name('PER','HR_289541_PJU_INV_BG_ID');
387: fnd_message.raise_error;
388: end if;

Line 417: fnd_file.put_line(fnd_file.log,

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

Line 434: fnd_file.put_line(fnd_file.log,

430: vacancypersonQuery_rec.PER_IN_LER_id,
431: vacancypersonQuery_rec.BUSINESS_GROUP_id);
432: end if;
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: --

Line 462: fnd_file.put_line(fnd_file.log,

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

Line 480: fnd_file.put_line(fnd_file.log,

476: personQuery_rec.PER_IN_LER_id,
477: personQuery_rec.BUSINESS_GROUP_id);
478: end if;
479: end if;
480: fnd_file.put_line(fnd_file.log,
481: '+---------------------------------------------------------------------------+');
482:
483: end loop;
484: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 527: fnd_file.put_line(fnd_file.log,

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

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

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

Line 561: fnd_file.put_line(fnd_file.log,

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

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

603: fnd_message.set_token('HIRE_DATE',l_hire_date);
604: l_description:=substrb(fnd_message.get,1,500);
605: fnd_message.clear;
606:
607: fnd_file.put_line(fnd_file.log, l_description);
608:
609: ben_irec_process.create_enrollment_for_irec(
610: p_irec_per_in_ler_id => pPerInLerId
611: ,p_person_id => pPersonId

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

629: fnd_message.set_token('PERSON_NAME',l_person_name);
630: l_description:=substrb(fnd_message.get,1,500);
631: fnd_message.clear;
632:
633: fnd_file.put_line(fnd_file.log, l_description);
634: --
635: else
636: --
637: close c_participation;

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

642: fnd_message.set_token('PERSON_NAME',l_person_name);
643: l_description:=substrb(fnd_message.get,1,500);
644: fnd_message.clear;
645:
646: fnd_file.put_line(fnd_file.log, l_description||
647: '
648: '||errbuf);
649: retcode := 2;
650: --

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

668: fnd_message.set_token('PERSON_NAME',l_person_name);
669: l_description:=substrb(fnd_message.get,1,500);
670: fnd_message.clear;
671:
672: fnd_file.put_line(fnd_file.log, l_description||
673: '
674: '||errbuf);
675: --REVIEW : The enrollment process errored out for the person XXXXXXX with the following message.
676: -- ERROR :