DBA Data[Home] [Help]

APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on FND_MESSAGE

Line 225: fnd_message.set_name('PER','IRC_412236_INV_OFFER_STATUS');

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:

Line 226: fnd_message.set_token('PERSON_NAME',l_person_name_with_id);

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);

Line 227: l_description:=substrb(fnd_message.get,1,500);

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.

Line 228: fnd_message.clear;

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

Line 280: fnd_message.set_name('PER','IRC_412243_INVALID_PERSON_ID');

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:

Line 281: fnd_message.set_token('PERSON_NAME',l_person_name||'(person_id='||pPersonId||')');

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);

Line 282: l_description:=substrb(fnd_message.get,1,500);

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;

Line 283: fnd_message.clear;

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;

Line 322: fnd_message.set_name('PER','IRC_412237_CRT_ENRLM_STRTD');

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');

Line 323: l_description_start:=substrb(fnd_message.get,1,500);

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);

Line 324: fnd_message.clear;

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;

Line 326: fnd_message.set_name('PER','IRC_412238_CRT_ENRLM_CMPLTD');

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

Line 327: l_description_end:=substrb(fnd_message.get,1,500);

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);

Line 328: fnd_message.clear;

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);

Line 386: fnd_message.set_name('PER','HR_289541_PJU_INV_BG_ID');

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;

Line 387: fnd_message.raise_error;

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);

Line 536: fnd_message.set_name('PER','IRC_412239_INV_OFFER_COMP');

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:

Line 537: fnd_message.set_token('PERSON_NAME',get_person_full_name(pPersonId)||'(person_id='||pPersonId||')');

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);

Line 538: l_description:=substrb(fnd_message.get,1,500);

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);

Line 539: fnd_message.clear;

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

Line 601: fnd_message.set_name('PER','IRC_412240_CRT_ENRLM_INITIAT');

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;

Line 602: fnd_message.set_token('PERSON_NAME',l_person_name_with_id);

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:

Line 603: fnd_message.set_token('HIRE_DATE',l_hire_date);

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);

Line 604: l_description:=substrb(fnd_message.get,1,500);

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:

Line 605: fnd_message.clear;

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(

Line 628: fnd_message.set_name('PER','IRC_412241_CRT_ENRLM_SUCCESS');

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:

Line 629: fnd_message.set_token('PERSON_NAME',l_person_name);

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);

Line 630: l_description:=substrb(fnd_message.get,1,500);

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

Line 631: fnd_message.clear;

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

Line 639: errbuf:=fnd_message.get;

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);

Line 641: fnd_message.set_name('PER','IRC_412242_CRT_ENRLM_ERRORED');

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:

Line 642: fnd_message.set_token('PERSON_NAME',l_person_name);

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||

Line 643: l_description:=substrb(fnd_message.get,1,500);

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: '

Line 644: fnd_message.clear;

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);

Line 663: errbuf:=fnd_message.get;

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');

Line 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:

Line 668: fnd_message.set_token('PERSON_NAME',l_person_name);

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||

Line 669: l_description:=substrb(fnd_message.get,1,500);

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: '

Line 670: fnd_message.clear;

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);