221: or l_offer_status='EXTENDED' THEN
222: return true;
223: end if;
224:
225: fnd_message.set_name('PER','IRC_412236_INV_OFFER_STATUS');
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:
222: return true;
223: end if;
224:
225: fnd_message.set_name('PER','IRC_412236_INV_OFFER_STATUS');
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);
223: end if;
224:
225: fnd_message.set_name('PER','IRC_412236_INV_OFFER_STATUS');
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.
224:
225: fnd_message.set_name('PER','IRC_412236_INV_OFFER_STATUS');
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
276: return false;
277: else
278: close csr_future_person_rec;
279:
280: fnd_message.set_name('PER','IRC_412243_INVALID_PERSON_ID');
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:
277: else
278: close csr_future_person_rec;
279:
280: fnd_message.set_name('PER','IRC_412243_INVALID_PERSON_ID');
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);
278: close csr_future_person_rec;
279:
280: fnd_message.set_name('PER','IRC_412243_INVALID_PERSON_ID');
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;
279:
280: fnd_message.set_name('PER','IRC_412243_INVALID_PERSON_ID');
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;
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;
325:
326: fnd_message.set_name('PER','IRC_412238_CRT_ENRLM_CMPLTD');
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;
325:
326: fnd_message.set_name('PER','IRC_412238_CRT_ENRLM_CMPLTD');
327: l_description_end:=substrb(fnd_message.get,1,500);
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;
325:
326: fnd_message.set_name('PER','IRC_412238_CRT_ENRLM_CMPLTD');
327: l_description_end:=substrb(fnd_message.get,1,500);
328: fnd_message.clear;
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;
325:
326: fnd_message.set_name('PER','IRC_412238_CRT_ENRLM_CMPLTD');
327: l_description_end:=substrb(fnd_message.get,1,500);
328: fnd_message.clear;
329:
330: if pPersonId is not null THEN
323: l_description_start:=substrb(fnd_message.get,1,500);
324: fnd_message.clear;
325:
326: fnd_message.set_name('PER','IRC_412238_CRT_ENRLM_CMPLTD');
327: l_description_end:=substrb(fnd_message.get,1,500);
328: fnd_message.clear;
329:
330: if pPersonId is not null THEN
331: l_person_name:=get_person_full_name(pPersonId);
324: fnd_message.clear;
325:
326: fnd_message.set_name('PER','IRC_412238_CRT_ENRLM_CMPLTD');
327: l_description_end:=substrb(fnd_message.get,1,500);
328: fnd_message.clear;
329:
330: if pPersonId is not null THEN
331: l_person_name:=get_person_full_name(pPersonId);
332: l_vacancy_name:=get_vacancy_name(pVacancyid);
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;
389: end if;
390: end if;
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;
389: end if;
390: end if;
391: hr_utility.set_location('retcode='||retcode||' and errbuf='||errbuf, 60);
532: --
533: if csr_assignment%notfound then
534: --
535: close csr_assignment;
536: fnd_message.set_name('PER','IRC_412239_INV_OFFER_COMP');
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:
533: if csr_assignment%notfound then
534: --
535: close csr_assignment;
536: fnd_message.set_name('PER','IRC_412239_INV_OFFER_COMP');
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);
534: --
535: close csr_assignment;
536: fnd_message.set_name('PER','IRC_412239_INV_OFFER_COMP');
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);
535: close csr_assignment;
536: fnd_message.set_name('PER','IRC_412239_INV_OFFER_COMP');
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: --
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:
601: fnd_message.set_name('PER','IRC_412240_CRT_ENRLM_INITIAT');
602: fnd_message.set_token('PERSON_NAME',l_person_name_with_id);
603: fnd_message.set_token('HIRE_DATE',l_hire_date);
604: l_description:=substrb(fnd_message.get,1,500);
605: fnd_message.clear;
598: l_person_name:=get_person_full_name(pPersonId);
599: l_hire_date:=get_person_hire_date(pPersonId);
600:
601: fnd_message.set_name('PER','IRC_412240_CRT_ENRLM_INITIAT');
602: fnd_message.set_token('PERSON_NAME',l_person_name_with_id);
603: fnd_message.set_token('HIRE_DATE',l_hire_date);
604: l_description:=substrb(fnd_message.get,1,500);
605: fnd_message.clear;
606:
599: l_hire_date:=get_person_hire_date(pPersonId);
600:
601: fnd_message.set_name('PER','IRC_412240_CRT_ENRLM_INITIAT');
602: fnd_message.set_token('PERSON_NAME',l_person_name_with_id);
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);
600:
601: fnd_message.set_name('PER','IRC_412240_CRT_ENRLM_INITIAT');
602: fnd_message.set_token('PERSON_NAME',l_person_name_with_id);
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:
601: fnd_message.set_name('PER','IRC_412240_CRT_ENRLM_INITIAT');
602: fnd_message.set_token('PERSON_NAME',l_person_name_with_id);
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(
624: where per_in_ler_id = pPerInLerId;
625: -- issue commit so that data is committed.
626: commit;
627:
628: fnd_message.set_name('PER','IRC_412241_CRT_ENRLM_SUCCESS');
629: fnd_message.set_token('PERSON_NAME',l_person_name);
630: l_description:=substrb(fnd_message.get,1,500);
631: fnd_message.clear;
632:
625: -- issue commit so that data is committed.
626: commit;
627:
628: fnd_message.set_name('PER','IRC_412241_CRT_ENRLM_SUCCESS');
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);
626: commit;
627:
628: fnd_message.set_name('PER','IRC_412241_CRT_ENRLM_SUCCESS');
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: --
627:
628: fnd_message.set_name('PER','IRC_412241_CRT_ENRLM_SUCCESS');
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
635: else
636: --
637: close c_participation;
638: -- Set the return parameters to indicate failure
639: errbuf:=fnd_message.get;
640:
641: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
642: fnd_message.set_token('PERSON_NAME',l_person_name);
643: l_description:=substrb(fnd_message.get,1,500);
637: close c_participation;
638: -- Set the return parameters to indicate failure
639: errbuf:=fnd_message.get;
640:
641: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
642: fnd_message.set_token('PERSON_NAME',l_person_name);
643: l_description:=substrb(fnd_message.get,1,500);
644: fnd_message.clear;
645:
638: -- Set the return parameters to indicate failure
639: errbuf:=fnd_message.get;
640:
641: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
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||
639: errbuf:=fnd_message.get;
640:
641: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
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: '
640:
641: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
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);
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: --
667: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
663: errbuf:=fnd_message.get;
664: --
665: -- Set the return parameters to indicate failure
666: --
667: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
668: fnd_message.set_token('PERSON_NAME',l_person_name);
669: l_description:=substrb(fnd_message.get,1,500);
670: fnd_message.clear;
671:
664: --
665: -- Set the return parameters to indicate failure
666: --
667: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
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||
665: -- Set the return parameters to indicate failure
666: --
667: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
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: '
666: --
667: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');
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);