DBA Data[Home] [Help]

APPS.IRC_IID_BUS dependencies on FND_MESSAGE

Line 242: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

238: (p_effective_date => p_effective_date
239: ,p_interview_details_id => p_rec.interview_details_id
240: ,p_object_version_number => p_rec.object_version_number
241: ) THEN
242: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE ', l_proc);
244: fnd_message.set_token('STEP ', '5');
245: fnd_message.raise_error;
246: END IF;

Line 243: fnd_message.set_token('PROCEDURE ', l_proc);

239: ,p_interview_details_id => p_rec.interview_details_id
240: ,p_object_version_number => p_rec.object_version_number
241: ) THEN
242: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE ', l_proc);
244: fnd_message.set_token('STEP ', '5');
245: fnd_message.raise_error;
246: END IF;
247: --

Line 244: fnd_message.set_token('STEP ', '5');

240: ,p_object_version_number => p_rec.object_version_number
241: ) THEN
242: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE ', l_proc);
244: fnd_message.set_token('STEP ', '5');
245: fnd_message.raise_error;
246: END IF;
247: --
248: -- Add checks to ensure non-updateable args have

Line 245: fnd_message.raise_error;

241: ) THEN
242: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE ', l_proc);
244: fnd_message.set_token('STEP ', '5');
245: fnd_message.raise_error;
246: END IF;
247: --
248: -- Add checks to ensure non-updateable args have
249: -- not been updated.

Line 332: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

328: --
329: -- An unhandled or unexpected error has occurred which
330: -- we must report
331: --
332: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
333: fnd_message.set_token('PROCEDURE', l_proc);
334: fnd_message.set_token('STEP','15');
335: fnd_message.raise_error;
336: End dt_update_validate;

Line 333: fnd_message.set_token('PROCEDURE', l_proc);

329: -- An unhandled or unexpected error has occurred which
330: -- we must report
331: --
332: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
333: fnd_message.set_token('PROCEDURE', l_proc);
334: fnd_message.set_token('STEP','15');
335: fnd_message.raise_error;
336: End dt_update_validate;
337: --

Line 334: fnd_message.set_token('STEP','15');

330: -- we must report
331: --
332: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
333: fnd_message.set_token('PROCEDURE', l_proc);
334: fnd_message.set_token('STEP','15');
335: fnd_message.raise_error;
336: End dt_update_validate;
337: --
338: -- ----------------------------------------------------------------------------

Line 335: fnd_message.raise_error;

331: --
332: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
333: fnd_message.set_token('PROCEDURE', l_proc);
334: fnd_message.set_token('STEP','15');
335: fnd_message.raise_error;
336: End dt_update_validate;
337: --
338: -- ----------------------------------------------------------------------------
339: -- |--------------------------< dt_delete_validate >--------------------------|

Line 429: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

425: --
426: -- An unhandled or unexpected error has occurred which
427: -- we must report
428: --
429: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
430: fnd_message.set_token('PROCEDURE', l_proc);
431: fnd_message.set_token('STEP','15');
432: fnd_message.raise_error;
433: --

Line 430: fnd_message.set_token('PROCEDURE', l_proc);

426: -- An unhandled or unexpected error has occurred which
427: -- we must report
428: --
429: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
430: fnd_message.set_token('PROCEDURE', l_proc);
431: fnd_message.set_token('STEP','15');
432: fnd_message.raise_error;
433: --
434: End dt_delete_validate;

Line 431: fnd_message.set_token('STEP','15');

427: -- we must report
428: --
429: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
430: fnd_message.set_token('PROCEDURE', l_proc);
431: fnd_message.set_token('STEP','15');
432: fnd_message.raise_error;
433: --
434: End dt_delete_validate;
435:

Line 432: fnd_message.raise_error;

428: --
429: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
430: fnd_message.set_token('PROCEDURE', l_proc);
431: fnd_message.set_token('STEP','15');
432: fnd_message.raise_error;
433: --
434: End dt_delete_validate;
435:
436: --

Line 458: fnd_message.set_name('PER','IRC_412471_INV_INT_STATUS');

454: );
455: hr_utility.set_location(l_proc, 10);
456: if (l_not_exists = true) then
457: -- RAISE ERROR SAYING THAT THE STATUS IS INVALID
458: fnd_message.set_name('PER','IRC_412471_INV_INT_STATUS');
459: fnd_message.raise_error;
460: end if;
461: hr_utility.set_location('leaving:'||l_proc, 15);
462: end chk_status;

Line 459: fnd_message.raise_error;

455: hr_utility.set_location(l_proc, 10);
456: if (l_not_exists = true) then
457: -- RAISE ERROR SAYING THAT THE STATUS IS INVALID
458: fnd_message.set_name('PER','IRC_412471_INV_INT_STATUS');
459: fnd_message.raise_error;
460: end if;
461: hr_utility.set_location('leaving:'||l_proc, 15);
462: end chk_status;
463: --

Line 487: fnd_message.set_name('PER','IRC_412472_INV_INT_RESULT');

483: );
484: hr_utility.set_location(l_proc, 10);
485: if (l_not_exists = true) then
486: -- RAISE ERROR SAYING INVALID RESULT
487: fnd_message.set_name('PER','IRC_412472_INV_INT_RESULT');
488: fnd_message.raise_error;
489: end if;
490: hr_utility.set_location('leaving:'||l_proc, 15);
491: end chk_result;

Line 488: fnd_message.raise_error;

484: hr_utility.set_location(l_proc, 10);
485: if (l_not_exists = true) then
486: -- RAISE ERROR SAYING INVALID RESULT
487: fnd_message.set_name('PER','IRC_412472_INV_INT_RESULT');
488: fnd_message.raise_error;
489: end if;
490: hr_utility.set_location('leaving:'||l_proc, 15);
491: end chk_result;
492: --

Line 510: fnd_message.set_name('PER','IRC_412473_INT_FDBK_MANDATORY');

506: --
507: if p_rec.status = 'COMPLETED' then
508: if p_rec.feedback is null then
509: -- raise error saying feedback is mandatory when status is complete
510: fnd_message.set_name('PER','IRC_412473_INT_FDBK_MANDATORY');
511: fnd_message.raise_error;
512: end if;
513: if p_rec.result is null then
514: -- raise error saying result is mandatory when status is complete

Line 511: fnd_message.raise_error;

507: if p_rec.status = 'COMPLETED' then
508: if p_rec.feedback is null then
509: -- raise error saying feedback is mandatory when status is complete
510: fnd_message.set_name('PER','IRC_412473_INT_FDBK_MANDATORY');
511: fnd_message.raise_error;
512: end if;
513: if p_rec.result is null then
514: -- raise error saying result is mandatory when status is complete
515: fnd_message.set_name('PER','IRC_412474_INT_RSLT_MANDATORY');

Line 515: fnd_message.set_name('PER','IRC_412474_INT_RSLT_MANDATORY');

511: fnd_message.raise_error;
512: end if;
513: if p_rec.result is null then
514: -- raise error saying result is mandatory when status is complete
515: fnd_message.set_name('PER','IRC_412474_INT_RSLT_MANDATORY');
516: fnd_message.raise_error;
517: else
518: irc_iid_bus.chk_result(p_rec => p_rec
519: ,p_effective_date => p_effective_date

Line 516: fnd_message.raise_error;

512: end if;
513: if p_rec.result is null then
514: -- raise error saying result is mandatory when status is complete
515: fnd_message.set_name('PER','IRC_412474_INT_RSLT_MANDATORY');
516: fnd_message.raise_error;
517: else
518: irc_iid_bus.chk_result(p_rec => p_rec
519: ,p_effective_date => p_effective_date
520: );

Line 527: fnd_message.set_name('PER','IRC_412475_RESULT_NOT_NULL');

523: if p_rec.result is not null then
524: --
525: -- RESULT SHOULD BE NULL FOR INCOMPLET INTERVIEWS
526: --
527: fnd_message.set_name('PER','IRC_412475_RESULT_NOT_NULL');
528: fnd_message.raise_error;
529: --
530: end if;
531: if p_rec.feedback is not null then

Line 528: fnd_message.raise_error;

524: --
525: -- RESULT SHOULD BE NULL FOR INCOMPLET INTERVIEWS
526: --
527: fnd_message.set_name('PER','IRC_412475_RESULT_NOT_NULL');
528: fnd_message.raise_error;
529: --
530: end if;
531: if p_rec.feedback is not null then
532: --

Line 535: fnd_message.set_name('PER','IRC_412476_FEEDBACK_NOT_NULL');

531: if p_rec.feedback is not null then
532: --
533: -- FEEDBACK SHOULD BE NULL FOR INCOMPLET INTERVIEWS
534: --
535: fnd_message.set_name('PER','IRC_412476_FEEDBACK_NOT_NULL');
536: fnd_message.raise_error;
537: end if;
538: end if;
539: hr_utility.set_location('leaving:'||l_proc, 10);

Line 536: fnd_message.raise_error;

532: --
533: -- FEEDBACK SHOULD BE NULL FOR INCOMPLET INTERVIEWS
534: --
535: fnd_message.set_name('PER','IRC_412476_FEEDBACK_NOT_NULL');
536: fnd_message.raise_error;
537: end if;
538: end if;
539: hr_utility.set_location('leaving:'||l_proc, 10);
540: end chk_completed;

Line 559: fnd_message.set_name('PER','IRC_412477_PLND_ST_CANT_CHNG');

555: if (p_old_status <> p_new_status) then
556: if p_old_status = 'PLANNED' then
557: if (p_new_status = 'RESCHEDULED' or p_new_status = 'COMPLETED') then
558: -- raise error saying that status can not change to RESCHEDULED or COMPLETED
559: fnd_message.set_name('PER','IRC_412477_PLND_ST_CANT_CHNG');
560: fnd_message.raise_error;
561: end if;
562: elsif p_old_status = 'CONFIRMED' then
563: if (p_new_status = 'PLANNED') then

Line 560: fnd_message.raise_error;

556: if p_old_status = 'PLANNED' then
557: if (p_new_status = 'RESCHEDULED' or p_new_status = 'COMPLETED') then
558: -- raise error saying that status can not change to RESCHEDULED or COMPLETED
559: fnd_message.set_name('PER','IRC_412477_PLND_ST_CANT_CHNG');
560: fnd_message.raise_error;
561: end if;
562: elsif p_old_status = 'CONFIRMED' then
563: if (p_new_status = 'PLANNED') then
564: -- raise error saying that status can not change to PLANNED.

Line 565: fnd_message.set_name('PER','IRC_412478_CNFRM_ST_CANT_CHNG');

561: end if;
562: elsif p_old_status = 'CONFIRMED' then
563: if (p_new_status = 'PLANNED') then
564: -- raise error saying that status can not change to PLANNED.
565: fnd_message.set_name('PER','IRC_412478_CNFRM_ST_CANT_CHNG');
566: fnd_message.raise_error;
567: end if;
568: elsif p_old_status = 'CANCELLED' then
569: -- raise error saying that status can not change for CANCELLED interview

Line 566: fnd_message.raise_error;

562: elsif p_old_status = 'CONFIRMED' then
563: if (p_new_status = 'PLANNED') then
564: -- raise error saying that status can not change to PLANNED.
565: fnd_message.set_name('PER','IRC_412478_CNFRM_ST_CANT_CHNG');
566: fnd_message.raise_error;
567: end if;
568: elsif p_old_status = 'CANCELLED' then
569: -- raise error saying that status can not change for CANCELLED interview
570: fnd_message.set_name('PER','IRC_412479_CNCLD_ST_CANT_CHNG');

Line 570: fnd_message.set_name('PER','IRC_412479_CNCLD_ST_CANT_CHNG');

566: fnd_message.raise_error;
567: end if;
568: elsif p_old_status = 'CANCELLED' then
569: -- raise error saying that status can not change for CANCELLED interview
570: fnd_message.set_name('PER','IRC_412479_CNCLD_ST_CANT_CHNG');
571: fnd_message.raise_error;
572: elsif p_old_status = 'RESCHEDULED' then
573: if (p_new_status = 'PLANNED') then
574: -- raise error saying that status can not change to PLANNED or COMPLETED

Line 571: fnd_message.raise_error;

567: end if;
568: elsif p_old_status = 'CANCELLED' then
569: -- raise error saying that status can not change for CANCELLED interview
570: fnd_message.set_name('PER','IRC_412479_CNCLD_ST_CANT_CHNG');
571: fnd_message.raise_error;
572: elsif p_old_status = 'RESCHEDULED' then
573: if (p_new_status = 'PLANNED') then
574: -- raise error saying that status can not change to PLANNED or COMPLETED
575: fnd_message.set_name('PER','IRC_412480_RSCHL_ST_CANT_CHNG');

Line 575: fnd_message.set_name('PER','IRC_412480_RSCHL_ST_CANT_CHNG');

571: fnd_message.raise_error;
572: elsif p_old_status = 'RESCHEDULED' then
573: if (p_new_status = 'PLANNED') then
574: -- raise error saying that status can not change to PLANNED or COMPLETED
575: fnd_message.set_name('PER','IRC_412480_RSCHL_ST_CANT_CHNG');
576: fnd_message.raise_error;
577: end if;
578: elsif p_old_status = 'HOLD' then
579: if (p_new_status = 'PLANNED') then

Line 576: fnd_message.raise_error;

572: elsif p_old_status = 'RESCHEDULED' then
573: if (p_new_status = 'PLANNED') then
574: -- raise error saying that status can not change to PLANNED or COMPLETED
575: fnd_message.set_name('PER','IRC_412480_RSCHL_ST_CANT_CHNG');
576: fnd_message.raise_error;
577: end if;
578: elsif p_old_status = 'HOLD' then
579: if (p_new_status = 'PLANNED') then
580: -- raise error saying that status can not change to PLANNED or HOLD

Line 581: fnd_message.set_name('PER','IRC_412481_HOLD_ST_CANT_CHNG');

577: end if;
578: elsif p_old_status = 'HOLD' then
579: if (p_new_status = 'PLANNED') then
580: -- raise error saying that status can not change to PLANNED or HOLD
581: fnd_message.set_name('PER','IRC_412481_HOLD_ST_CANT_CHNG');
582: fnd_message.raise_error;
583: end if;
584: elsif p_old_status = 'COMPLETED' then
585: if (p_new_status <> 'COMPLETED') then

Line 582: fnd_message.raise_error;

578: elsif p_old_status = 'HOLD' then
579: if (p_new_status = 'PLANNED') then
580: -- raise error saying that status can not change to PLANNED or HOLD
581: fnd_message.set_name('PER','IRC_412481_HOLD_ST_CANT_CHNG');
582: fnd_message.raise_error;
583: end if;
584: elsif p_old_status = 'COMPLETED' then
585: if (p_new_status <> 'COMPLETED') then
586: -- raise error saying that status can not change for COMPLETED interview

Line 587: fnd_message.set_name('PER','IRC_412482_CMPLT_ST_CANT_CHNG');

583: end if;
584: elsif p_old_status = 'COMPLETED' then
585: if (p_new_status <> 'COMPLETED') then
586: -- raise error saying that status can not change for COMPLETED interview
587: fnd_message.set_name('PER','IRC_412482_CMPLT_ST_CANT_CHNG');
588: fnd_message.raise_error;
589: end if;
590: end if;
591: end if;

Line 588: fnd_message.raise_error;

584: elsif p_old_status = 'COMPLETED' then
585: if (p_new_status <> 'COMPLETED') then
586: -- raise error saying that status can not change for COMPLETED interview
587: fnd_message.set_name('PER','IRC_412482_CMPLT_ST_CANT_CHNG');
588: fnd_message.raise_error;
589: end if;
590: end if;
591: end if;
592: --

Line 612: fnd_message.set_name('PER','IRC_412483_INV_EVENT_ID');

608: open csr_event_exists;
609: fetch csr_event_exists into l_rec_exists;
610: if (csr_event_exists%notfound) then
611: -- raise an error saying the event does not exist
612: fnd_message.set_name('PER','IRC_412483_INV_EVENT_ID');
613: fnd_message.raise_error;
614: end if;
615: close csr_event_exists;
616:

Line 613: fnd_message.raise_error;

609: fetch csr_event_exists into l_rec_exists;
610: if (csr_event_exists%notfound) then
611: -- raise an error saying the event does not exist
612: fnd_message.set_name('PER','IRC_412483_INV_EVENT_ID');
613: fnd_message.raise_error;
614: end if;
615: close csr_event_exists;
616:
617: end chk_event_id;

Line 683: fnd_message.set_name('PER','IRC_412484_INV_INT_DETAILS_ID');

679: ,p_new_status => p_rec.status);
680: end if;
681: else
682: -- raise error saying that record does not exist
683: fnd_message.set_name('PER','IRC_412484_INV_INT_DETAILS_ID');
684: fnd_message.raise_error;
685: end if;
686: close csr_old_status;
687: irc_iid_bus.chk_completed(p_rec => p_rec

Line 684: fnd_message.raise_error;

680: end if;
681: else
682: -- raise error saying that record does not exist
683: fnd_message.set_name('PER','IRC_412484_INV_INT_DETAILS_ID');
684: fnd_message.raise_error;
685: end if;
686: close csr_old_status;
687: irc_iid_bus.chk_completed(p_rec => p_rec
688: ,p_effective_date => p_effective_date