268: or l_offer_status='EXTENDED' THEN
269: return true;
270: end if;
271:
272: fnd_message.set_name('PER','IRC_412236_INV_OFFER_STATUS');
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:
269: return true;
270: end if;
271:
272: fnd_message.set_name('PER','IRC_412236_INV_OFFER_STATUS');
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);
270: end if;
271:
272: fnd_message.set_name('PER','IRC_412236_INV_OFFER_STATUS');
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.
271:
272: fnd_message.set_name('PER','IRC_412236_INV_OFFER_STATUS');
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
323: return false;
324: else
325: close csr_future_person_rec;
326:
327: fnd_message.set_name('PER','IRC_412243_INVALID_PERSON_ID');
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:
324: else
325: close csr_future_person_rec;
326:
327: fnd_message.set_name('PER','IRC_412243_INVALID_PERSON_ID');
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);
325: close csr_future_person_rec;
326:
327: fnd_message.set_name('PER','IRC_412243_INVALID_PERSON_ID');
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;
326:
327: fnd_message.set_name('PER','IRC_412243_INVALID_PERSON_ID');
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;
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;
372:
373: fnd_message.set_name('PER','IRC_412238_CRT_ENRLM_CMPLTD');
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;
372:
373: fnd_message.set_name('PER','IRC_412238_CRT_ENRLM_CMPLTD');
374: l_description_end:=substrb(fnd_message.get,1,500);
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;
372:
373: fnd_message.set_name('PER','IRC_412238_CRT_ENRLM_CMPLTD');
374: l_description_end:=substrb(fnd_message.get,1,500);
375: fnd_message.clear;
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;
372:
373: fnd_message.set_name('PER','IRC_412238_CRT_ENRLM_CMPLTD');
374: l_description_end:=substrb(fnd_message.get,1,500);
375: fnd_message.clear;
376:
377: if pPersonId is not null THEN
370: l_description_start:=substrb(fnd_message.get,1,500);
371: fnd_message.clear;
372:
373: fnd_message.set_name('PER','IRC_412238_CRT_ENRLM_CMPLTD');
374: l_description_end:=substrb(fnd_message.get,1,500);
375: fnd_message.clear;
376:
377: if pPersonId is not null THEN
378: l_person_name:=get_person_full_name(pPersonId);
371: fnd_message.clear;
372:
373: fnd_message.set_name('PER','IRC_412238_CRT_ENRLM_CMPLTD');
374: l_description_end:=substrb(fnd_message.get,1,500);
375: fnd_message.clear;
376:
377: if pPersonId is not null THEN
378: l_person_name:=get_person_full_name(pPersonId);
379: l_vacancy_name:=get_vacancy_name(pVacancyid);
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;
436: end if;
437: end if;
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;
436: end if;
437: end if;
438: hr_utility.set_location('retcode='||retcode||' and errbuf='||errbuf, 60);
579: --
580: if csr_assignment%notfound then
581: --
582: close csr_assignment;
583: fnd_message.set_name('PER','IRC_412239_INV_OFFER_COMP');
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:
580: if csr_assignment%notfound then
581: --
582: close csr_assignment;
583: fnd_message.set_name('PER','IRC_412239_INV_OFFER_COMP');
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);
581: --
582: close csr_assignment;
583: fnd_message.set_name('PER','IRC_412239_INV_OFFER_COMP');
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);
582: close csr_assignment;
583: fnd_message.set_name('PER','IRC_412239_INV_OFFER_COMP');
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: --
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:
648: fnd_message.set_name('PER','IRC_412240_CRT_ENRLM_INITIAT');
649: fnd_message.set_token('PERSON_NAME',l_person_name_with_id);
650: fnd_message.set_token('HIRE_DATE',l_hire_date);
651: l_description:=substrb(fnd_message.get,1,500);
652: fnd_message.clear;
645: l_person_name:=get_person_full_name(pPersonId);
646: l_hire_date:=get_person_hire_date(pAssignmentId);
647:
648: fnd_message.set_name('PER','IRC_412240_CRT_ENRLM_INITIAT');
649: fnd_message.set_token('PERSON_NAME',l_person_name_with_id);
650: fnd_message.set_token('HIRE_DATE',l_hire_date);
651: l_description:=substrb(fnd_message.get,1,500);
652: fnd_message.clear;
653:
646: l_hire_date:=get_person_hire_date(pAssignmentId);
647:
648: fnd_message.set_name('PER','IRC_412240_CRT_ENRLM_INITIAT');
649: fnd_message.set_token('PERSON_NAME',l_person_name_with_id);
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);
647:
648: fnd_message.set_name('PER','IRC_412240_CRT_ENRLM_INITIAT');
649: fnd_message.set_token('PERSON_NAME',l_person_name_with_id);
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:
648: fnd_message.set_name('PER','IRC_412240_CRT_ENRLM_INITIAT');
649: fnd_message.set_token('PERSON_NAME',l_person_name_with_id);
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(
671: where per_in_ler_id = pPerInLerId;
672: -- issue commit so that data is committed.
673: commit;
674:
675: fnd_message.set_name('PER','IRC_412241_CRT_ENRLM_SUCCESS');
676: fnd_message.set_token('PERSON_NAME',l_person_name);
677: l_description:=substrb(fnd_message.get,1,500);
678: fnd_message.clear;
679:
672: -- issue commit so that data is committed.
673: commit;
674:
675: fnd_message.set_name('PER','IRC_412241_CRT_ENRLM_SUCCESS');
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);
673: commit;
674:
675: fnd_message.set_name('PER','IRC_412241_CRT_ENRLM_SUCCESS');
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: --
674:
675: fnd_message.set_name('PER','IRC_412241_CRT_ENRLM_SUCCESS');
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
682: else
683: --
684: close c_participation;
685: -- Set the return parameters to indicate failure
686: errbuf:=fnd_message.get;
687:
688: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
689: fnd_message.set_token('PERSON_NAME',l_person_name);
690: l_description:=substrb(fnd_message.get,1,500);
684: close c_participation;
685: -- Set the return parameters to indicate failure
686: errbuf:=fnd_message.get;
687:
688: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
689: fnd_message.set_token('PERSON_NAME',l_person_name);
690: l_description:=substrb(fnd_message.get,1,500);
691: fnd_message.clear;
692:
685: -- Set the return parameters to indicate failure
686: errbuf:=fnd_message.get;
687:
688: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
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||
686: errbuf:=fnd_message.get;
687:
688: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
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: '
687:
688: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
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);
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: --
714: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
710: errbuf:=fnd_message.get;
711: --
712: -- Set the return parameters to indicate failure
713: --
714: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
715: fnd_message.set_token('PERSON_NAME',l_person_name);
716: l_description:=substrb(fnd_message.get,1,500);
717: fnd_message.clear;
718:
711: --
712: -- Set the return parameters to indicate failure
713: --
714: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
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||
712: -- Set the return parameters to indicate failure
713: --
714: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
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: '
713: --
714: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
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);