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