DBA Data[Home] [Help]

APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on FND_MESSAGE

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

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:

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

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

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

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.

Line 275: fnd_message.clear;

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

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

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:

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

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

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

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;

Line 330: fnd_message.clear;

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;

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

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

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

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

Line 371: fnd_message.clear;

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;

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

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

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

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

Line 375: fnd_message.clear;

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

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

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;

Line 434: fnd_message.raise_error;

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

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

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:

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

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

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

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

Line 586: fnd_message.clear;

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

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

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;

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

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:

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

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

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

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:

Line 652: fnd_message.clear;

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(

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

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:

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

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

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

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

Line 678: fnd_message.clear;

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

Line 686: errbuf:=fnd_message.get;

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

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

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:

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

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

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

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

Line 691: fnd_message.clear;

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

Line 710: errbuf:=fnd_message.get;

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

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

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

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

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

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

Line 717: fnd_message.clear;

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