eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_INTERVIEW dependencies on HR_UTILITY

Line 93: hr_utility.set_location('hr_interview.insert_interview',1);

89: p_int_date := p_idate;
90: --
91: BEGIN
92: --
93: hr_utility.set_location('hr_interview.insert_interview',1);
94: --
95: -- This for loop has a purpose to the lock all the assignment records
96: -- specified by the cursor
97: --

Line 102: hr_utility.set_location('hr_interview.insert_interview',2);

98: FOR ass_rec_ins IN select_ass_for_insert LOOP
99: NULL;
100: END LOOP;
101: --
102: hr_utility.set_location('hr_interview.insert_interview',2);
103: --
104: SELECT 'Y'
105: INTO p_dummy
106: FROM sys.dual

Line 120: hr_utility.set_message(801,'HR_6456_APP_ASS_FUTURE_CHANGES');

116: WHEN NO_DATA_FOUND THEN NULL;
117: END;
118: --
119: IF p_dummy = 'Y' THEN
120: hr_utility.set_message(801,'HR_6456_APP_ASS_FUTURE_CHANGES');
121: hr_utility.raise_error;
122: END IF;
123: --
124: -- Insert the Interview

Line 121: hr_utility.raise_error;

117: END;
118: --
119: IF p_dummy = 'Y' THEN
120: hr_utility.set_message(801,'HR_6456_APP_ASS_FUTURE_CHANGES');
121: hr_utility.raise_error;
122: END IF;
123: --
124: -- Insert the Interview
125: hr_utility.set_location('hr_interview.insert_interview',3);

Line 125: hr_utility.set_location('hr_interview.insert_interview',3);

121: hr_utility.raise_error;
122: END IF;
123: --
124: -- Insert the Interview
125: hr_utility.set_location('hr_interview.insert_interview',3);
126: --
127: INSERT INTO per_assignments_f
128: (
129: assignment_id

Line 317: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

313: AND p_int_date
314: BETWEEN effective_start_date and effective_end_date;
315: --
316: IF SQL%ROWCOUNT <> 1 THEN
317: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
318: hr_utility.set_message_token('PROCEDURE','INSERT_INTERVIEW');
319: hr_utility.set_message_token('STEP','3');
320: hr_utility.raise_error;
321: ELSE

Line 318: hr_utility.set_message_token('PROCEDURE','INSERT_INTERVIEW');

314: BETWEEN effective_start_date and effective_end_date;
315: --
316: IF SQL%ROWCOUNT <> 1 THEN
317: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
318: hr_utility.set_message_token('PROCEDURE','INSERT_INTERVIEW');
319: hr_utility.set_message_token('STEP','3');
320: hr_utility.raise_error;
321: ELSE
322: hr_utility.set_location('hr_interview.insert_interview',4);

Line 319: hr_utility.set_message_token('STEP','3');

315: --
316: IF SQL%ROWCOUNT <> 1 THEN
317: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
318: hr_utility.set_message_token('PROCEDURE','INSERT_INTERVIEW');
319: hr_utility.set_message_token('STEP','3');
320: hr_utility.raise_error;
321: ELSE
322: hr_utility.set_location('hr_interview.insert_interview',4);
323: --

Line 320: hr_utility.raise_error;

316: IF SQL%ROWCOUNT <> 1 THEN
317: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
318: hr_utility.set_message_token('PROCEDURE','INSERT_INTERVIEW');
319: hr_utility.set_message_token('STEP','3');
320: hr_utility.raise_error;
321: ELSE
322: hr_utility.set_location('hr_interview.insert_interview',4);
323: --
324: UPDATE per_assignments_f

Line 322: hr_utility.set_location('hr_interview.insert_interview',4);

318: hr_utility.set_message_token('PROCEDURE','INSERT_INTERVIEW');
319: hr_utility.set_message_token('STEP','3');
320: hr_utility.raise_error;
321: ELSE
322: hr_utility.set_location('hr_interview.insert_interview',4);
323: --
324: UPDATE per_assignments_f
325: SET effective_start_date = p_int_date
326: , assignment_status_type_id = p_assignment_status_type_id

Line 335: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

331: AND p_int_date
332: BETWEEN effective_start_date and effective_end_date;
333: --
334: IF SQL%ROWCOUNT <> 1 THEN
335: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
336: hr_utility.set_message_token('PROCEDURE','INSERT_INTERVIEW');
337: hr_utility.set_message_token('STEP','4');
338: hr_utility.raise_error;
339: END IF;

Line 336: hr_utility.set_message_token('PROCEDURE','INSERT_INTERVIEW');

332: BETWEEN effective_start_date and effective_end_date;
333: --
334: IF SQL%ROWCOUNT <> 1 THEN
335: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
336: hr_utility.set_message_token('PROCEDURE','INSERT_INTERVIEW');
337: hr_utility.set_message_token('STEP','4');
338: hr_utility.raise_error;
339: END IF;
340: END IF;

Line 337: hr_utility.set_message_token('STEP','4');

333: --
334: IF SQL%ROWCOUNT <> 1 THEN
335: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
336: hr_utility.set_message_token('PROCEDURE','INSERT_INTERVIEW');
337: hr_utility.set_message_token('STEP','4');
338: hr_utility.raise_error;
339: END IF;
340: END IF;
341: -- End the insert

Line 338: hr_utility.raise_error;

334: IF SQL%ROWCOUNT <> 1 THEN
335: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
336: hr_utility.set_message_token('PROCEDURE','INSERT_INTERVIEW');
337: hr_utility.set_message_token('STEP','4');
338: hr_utility.raise_error;
339: END IF;
340: END IF;
341: -- End the insert
342: END insert_interview;

Line 538: hr_utility.set_location('hr_interview.delete_interview',1);

534: -- Check if status was the only field to change
535: -- IF it is then CASE A B and C
536: --
537: -- CASE A B C D
538: hr_utility.set_location('hr_interview.delete_interview',1);
539: --
540: -- This for loop has a purpose to the lock all the assignment records
541: -- specified by the cursor
542: FOR ass_rec_del IN select_ass_for_delete LOOP

Line 546: hr_utility.set_location('hr_interview.delete_interview',2);

542: FOR ass_rec_del IN select_ass_for_delete LOOP
543: NULL;
544: END LOOP;
545: --
546: hr_utility.set_location('hr_interview.delete_interview',2);
547: --
548: -- #4894555: replaced SQL statement with function call.
549: --
550: p_dummy := chk_duplicate(p_assignment_id, p_int_date, TRUE);

Line 552: hr_utility.set_location('hr_interview.delete_interview',25);

548: -- #4894555: replaced SQL statement with function call.
549: --
550: p_dummy := chk_duplicate(p_assignment_id, p_int_date, TRUE);
551: --
552: hr_utility.set_location('hr_interview.delete_interview',25);
553: --
554: --
555: BEGIN
556: --

Line 557: hr_utility.set_location('hr_interview.delete_interview',3);

553: --
554: --
555: BEGIN
556: --
557: hr_utility.set_location('hr_interview.delete_interview',3);
558: --
559: SELECT a.assignment_status_type_id
560: INTO p_old_interview_status
561: FROM per_assignments_f a

Line 567: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

563: AND a.effective_start_date = p_int_date;
564: --
565: EXCEPTION
566: WHEN NO_DATA_FOUND THEN
567: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
568: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
569: hr_utility.set_message_token('STEP','2');
570: hr_utility.raise_error;
571: END;

Line 568: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');

564: --
565: EXCEPTION
566: WHEN NO_DATA_FOUND THEN
567: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
568: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
569: hr_utility.set_message_token('STEP','2');
570: hr_utility.raise_error;
571: END;
572: --

Line 569: hr_utility.set_message_token('STEP','2');

565: EXCEPTION
566: WHEN NO_DATA_FOUND THEN
567: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
568: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
569: hr_utility.set_message_token('STEP','2');
570: hr_utility.raise_error;
571: END;
572: --
573: IF p_dummy = 'Y' THEN

Line 570: hr_utility.raise_error;

566: WHEN NO_DATA_FOUND THEN
567: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
568: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
569: hr_utility.set_message_token('STEP','2');
570: hr_utility.raise_error;
571: END;
572: --
573: IF p_dummy = 'Y' THEN
574: --

Line 584: hr_utility.set_location('hr_interview.delete_interview',4);

580: --
581: -- delete the row that has effective start date = interview start date
582: -- done For CASE A, B, and C
583: --
584: hr_utility.set_location('hr_interview.delete_interview',4);
585: --
586: UPDATE per_assignments_f a
587: SET effective_end_date = (SELECT effective_end_date
588: FROM per_assignments_f b

Line 599: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

595: WHERE a.assignment_id = p_assignment_id
596: AND a.effective_end_date = p_int_date -1;
597: --
598: IF SQL%ROWCOUNT <> 1 THEN
599: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
600: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
601: hr_utility.set_message_token('STEP','3');
602: hr_utility.raise_error;
603: END IF;

Line 600: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');

596: AND a.effective_end_date = p_int_date -1;
597: --
598: IF SQL%ROWCOUNT <> 1 THEN
599: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
600: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
601: hr_utility.set_message_token('STEP','3');
602: hr_utility.raise_error;
603: END IF;
604: --

Line 601: hr_utility.set_message_token('STEP','3');

597: --
598: IF SQL%ROWCOUNT <> 1 THEN
599: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
600: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
601: hr_utility.set_message_token('STEP','3');
602: hr_utility.raise_error;
603: END IF;
604: --
605: hr_utility.set_location('hr_interview.delete_interview',5);

Line 602: hr_utility.raise_error;

598: IF SQL%ROWCOUNT <> 1 THEN
599: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
600: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
601: hr_utility.set_message_token('STEP','3');
602: hr_utility.raise_error;
603: END IF;
604: --
605: hr_utility.set_location('hr_interview.delete_interview',5);
606: --

Line 605: hr_utility.set_location('hr_interview.delete_interview',5);

601: hr_utility.set_message_token('STEP','3');
602: hr_utility.raise_error;
603: END IF;
604: --
605: hr_utility.set_location('hr_interview.delete_interview',5);
606: --
607: DELETE per_assignments_f a
608: WHERE a.assignment_id = p_assignment_id
609: AND a.effective_start_date = p_int_date;

Line 612: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

608: WHERE a.assignment_id = p_assignment_id
609: AND a.effective_start_date = p_int_date;
610: --
611: IF SQL%ROWCOUNT <> 1 THEN
612: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
613: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
614: hr_utility.set_message_token('STEP','4');
615: hr_utility.raise_error;
616: END IF;

Line 613: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');

609: AND a.effective_start_date = p_int_date;
610: --
611: IF SQL%ROWCOUNT <> 1 THEN
612: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
613: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
614: hr_utility.set_message_token('STEP','4');
615: hr_utility.raise_error;
616: END IF;
617: --

Line 614: hr_utility.set_message_token('STEP','4');

610: --
611: IF SQL%ROWCOUNT <> 1 THEN
612: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
613: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
614: hr_utility.set_message_token('STEP','4');
615: hr_utility.raise_error;
616: END IF;
617: --
618: END IF;

Line 615: hr_utility.raise_error;

611: IF SQL%ROWCOUNT <> 1 THEN
612: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
613: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
614: hr_utility.set_message_token('STEP','4');
615: hr_utility.raise_error;
616: END IF;
617: --
618: END IF;
619: --

Line 625: hr_utility.set_location('hr_interview.delete_interview',6);

621: -- Check for CASE A if effective_end_date = EOT then no need to ripple
622: --
623: BEGIN
624: --
625: hr_utility.set_location('hr_interview.delete_interview',6);
626: --
627: SELECT a.effective_end_date
628: INTO p_dummy_date
629: FROM per_assignments_f a

Line 635: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

631: AND p_int_date BETWEEN a.effective_start_date AND a.effective_end_date;
632: --
633: EXCEPTION
634: WHEN NO_DATA_FOUND THEN
635: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
636: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
637: hr_utility.set_message_token('STEP','5');
638: hr_utility.raise_error;
639: END;

Line 636: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');

632: --
633: EXCEPTION
634: WHEN NO_DATA_FOUND THEN
635: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
636: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
637: hr_utility.set_message_token('STEP','5');
638: hr_utility.raise_error;
639: END;
640: --

Line 637: hr_utility.set_message_token('STEP','5');

633: EXCEPTION
634: WHEN NO_DATA_FOUND THEN
635: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
636: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
637: hr_utility.set_message_token('STEP','5');
638: hr_utility.raise_error;
639: END;
640: --
641: IF p_dummy_date = TO_DATE('31/12/4712','DD/MM/YYYY') AND

Line 638: hr_utility.raise_error;

634: WHEN NO_DATA_FOUND THEN
635: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
636: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
637: hr_utility.set_message_token('STEP','5');
638: hr_utility.raise_error;
639: END;
640: --
641: IF p_dummy_date = TO_DATE('31/12/4712','DD/MM/YYYY') AND
642: p_dummy = 'N' THEN

Line 648: hr_utility.set_location('hr_interview.delete_interview',7);

644: BEGIN
645: --
646: -- CASE D when the last record no need to ripple forward.
647: --
648: hr_utility.set_location('hr_interview.delete_interview',7);
649: --
650: SELECT d.assignment_status_type_id
651: INTO p_previous_status
652: FROM per_assignments_f d

Line 658: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

654: AND d.effective_end_date = p_int_date -1;
655: --
656: EXCEPTION
657: WHEN NO_DATA_FOUND THEN
658: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
659: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
660: hr_utility.set_message_token('STEP','6');
661: hr_utility.raise_error;
662: END;

Line 659: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');

655: --
656: EXCEPTION
657: WHEN NO_DATA_FOUND THEN
658: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
659: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
660: hr_utility.set_message_token('STEP','6');
661: hr_utility.raise_error;
662: END;
663: --

Line 660: hr_utility.set_message_token('STEP','6');

656: EXCEPTION
657: WHEN NO_DATA_FOUND THEN
658: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
659: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
660: hr_utility.set_message_token('STEP','6');
661: hr_utility.raise_error;
662: END;
663: --
664: UPDATE per_assignments_f a

Line 661: hr_utility.raise_error;

657: WHEN NO_DATA_FOUND THEN
658: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
659: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
660: hr_utility.set_message_token('STEP','6');
661: hr_utility.raise_error;
662: END;
663: --
664: UPDATE per_assignments_f a
665: SET assignment_status_type_id = p_previous_status

Line 679: hr_utility.set_location('hr_interview.delete_interview',8);

675: --
676: -- Test for Case C and D a new assignment corresponds to start date of
677: -- another interview.
678: --
679: hr_utility.set_location('hr_interview.delete_interview',8);
680: --
681: SELECT MIN(e.date_start)
682: INTO p_nxt_interview_date
683: FROM per_events e

Line 687: hr_utility.trace('p_nxt_interview_date '||

683: FROM per_events e
684: WHERE e.assignment_id = p_assignment_id
685: AND e.date_start > p_int_date;
686: --
687: hr_utility.trace('p_nxt_interview_date '||
688: substr(to_char(p_nxt_interview_date,'DD-MON-YYYY'),1,11));
689: --
690: -- Test for Case B and D the assignment status changes.
691: --

Line 698: hr_utility.set_location('hr_interview.delete_interview',9);

694: IF p_dummy = 'Y' THEN
695: --
696: BEGIN
697: --
698: hr_utility.set_location('hr_interview.delete_interview',9);
699: --
700: SELECT d.assignment_status_type_id
701: INTO p_previous_status
702: FROM per_assignments_f d

Line 709: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

705: BETWEEN d.effective_start_date AND d.effective_end_date;
706: --
707: EXCEPTION
708: WHEN NO_DATA_FOUND THEN
709: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
710: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
711: hr_utility.set_message_token('STEP','7');
712: hr_utility.raise_error;
713: END;

Line 710: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');

706: --
707: EXCEPTION
708: WHEN NO_DATA_FOUND THEN
709: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
710: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
711: hr_utility.set_message_token('STEP','7');
712: hr_utility.raise_error;
713: END;
714: --

Line 711: hr_utility.set_message_token('STEP','7');

707: EXCEPTION
708: WHEN NO_DATA_FOUND THEN
709: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
710: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
711: hr_utility.set_message_token('STEP','7');
712: hr_utility.raise_error;
713: END;
714: --
715: ELSE

Line 712: hr_utility.raise_error;

708: WHEN NO_DATA_FOUND THEN
709: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
710: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
711: hr_utility.set_message_token('STEP','7');
712: hr_utility.raise_error;
713: END;
714: --
715: ELSE
716: --

Line 719: hr_utility.set_location('hr_interview.delete_interview',10);

715: ELSE
716: --
717: BEGIN
718: --
719: hr_utility.set_location('hr_interview.delete_interview',10);
720: --
721: SELECT d.assignment_status_type_id
722: INTO p_previous_status
723: FROM per_assignments_f d

Line 729: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

725: AND d.effective_end_date = p_int_date -1;
726: --
727: EXCEPTION
728: WHEN NO_DATA_FOUND THEN
729: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
730: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
731: hr_utility.set_message_token('STEP','8');
732: hr_utility.raise_error;
733: END;

Line 730: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');

726: --
727: EXCEPTION
728: WHEN NO_DATA_FOUND THEN
729: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
730: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
731: hr_utility.set_message_token('STEP','8');
732: hr_utility.raise_error;
733: END;
734: --

Line 731: hr_utility.set_message_token('STEP','8');

727: EXCEPTION
728: WHEN NO_DATA_FOUND THEN
729: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
730: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
731: hr_utility.set_message_token('STEP','8');
732: hr_utility.raise_error;
733: END;
734: --
735: END IF;

Line 732: hr_utility.raise_error;

728: WHEN NO_DATA_FOUND THEN
729: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
730: hr_utility.set_message_token('PROCEDURE','DELETE_INTERVIEW');
731: hr_utility.set_message_token('STEP','8');
732: hr_utility.raise_error;
733: END;
734: --
735: END IF;
736: --

Line 737: hr_utility.trace('p_previous_status '|| p_previous_status);

733: END;
734: --
735: END IF;
736: --
737: hr_utility.trace('p_previous_status '|| p_previous_status);
738: hr_utility.trace('p_old_interview_status '|| p_old_interview_status);
739: --
740: hr_utility.set_location('hr_interview.delete_interview',11);
741: --

Line 738: hr_utility.trace('p_old_interview_status '|| p_old_interview_status);

734: --
735: END IF;
736: --
737: hr_utility.trace('p_previous_status '|| p_previous_status);
738: hr_utility.trace('p_old_interview_status '|| p_old_interview_status);
739: --
740: hr_utility.set_location('hr_interview.delete_interview',11);
741: --
742: SELECT MIN(c.effective_start_date)

Line 740: hr_utility.set_location('hr_interview.delete_interview',11);

736: --
737: hr_utility.trace('p_previous_status '|| p_previous_status);
738: hr_utility.trace('p_old_interview_status '|| p_old_interview_status);
739: --
740: hr_utility.set_location('hr_interview.delete_interview',11);
741: --
742: SELECT MIN(c.effective_start_date)
743: INTO p_new_status_type_date
744: FROM per_assignments_f c

Line 749: hr_utility.trace('p_new_status_type_date '||

745: WHERE c.assignment_id = p_assignment_id
746: AND c.effective_start_date > p_int_date
747: AND c.assignment_status_type_id <> p_old_interview_status;
748: --
749: hr_utility.trace('p_new_status_type_date '||
750: substr(to_char(p_new_status_type_date,'DD-MON-YYYY'),1,11));
751: --
752: -- Ripple the pre interview status CASE B,C and D.
753: --

Line 754: hr_utility.set_location('hr_interview.delete_interview',12);

750: substr(to_char(p_new_status_type_date,'DD-MON-YYYY'),1,11));
751: --
752: -- Ripple the pre interview status CASE B,C and D.
753: --
754: hr_utility.set_location('hr_interview.delete_interview',12);
755: --
756: UPDATE per_assignments_f a
757: SET assignment_status_type_id = p_previous_status
758: , last_updated_by = p_last_updated_by

Line 770: hr_utility.set_location('hr_interview.delete_interview',13);

766: to_date('31/12/4712','DD/MM/YYYY')))));
767: --
768: IF SQL%ROWCOUNT = 0 THEN
769: --
770: hr_utility.set_location('hr_interview.delete_interview',13);
771: --
772: IF p_nxt_interview_date IS NULL AND p_new_status_type_date IS NULL THEN
773: --
774: hr_utility.set_location('hr_interview.delete_interview',14);

Line 774: hr_utility.set_location('hr_interview.delete_interview',14);

770: hr_utility.set_location('hr_interview.delete_interview',13);
771: --
772: IF p_nxt_interview_date IS NULL AND p_new_status_type_date IS NULL THEN
773: --
774: hr_utility.set_location('hr_interview.delete_interview',14);
775: --
776: UPDATE per_assignments_f a
777: SET assignment_status_type_id = p_previous_status
778: , last_updated_by = p_last_updated_by

Line 840: hr_utility.set_location('hr_interview.update_interview',1);

836: p_matches := 'N';
837: --
838: BEGIN
839: --
840: hr_utility.set_location('hr_interview.update_interview',1);
841: --
842: -- This for loop has a purpose to the lock all the assignment records
843: -- specified by the cursor
844: --

Line 849: hr_utility.set_location('hr_interview.update_interview',2);

845: FOR ass_rec_upd IN select_ass_for_update LOOP
846: NULL;
847: END LOOP;
848: --
849: hr_utility.set_location('hr_interview.update_interview',2);
850: --
851: SELECT 'Y'
852: INTO p_no_update
853: FROM sys.dual

Line 871: hr_utility.set_message(801,'HR_6629_APPL_STATUS_MOVE');

867: WHEN NO_DATA_FOUND THEN NULL;
868: END;
869: --
870: IF p_no_update = 'Y' THEN /* CASE D or E */
871: hr_utility.set_message(801,'HR_6629_APPL_STATUS_MOVE');
872: hr_utility.raise_error;
873: END IF;
874: --
875: hr_utility.set_location('hr_interview.update_interview',3);

Line 872: hr_utility.raise_error;

868: END;
869: --
870: IF p_no_update = 'Y' THEN /* CASE D or E */
871: hr_utility.set_message(801,'HR_6629_APPL_STATUS_MOVE');
872: hr_utility.raise_error;
873: END IF;
874: --
875: hr_utility.set_location('hr_interview.update_interview',3);
876: --

Line 875: hr_utility.set_location('hr_interview.update_interview',3);

871: hr_utility.set_message(801,'HR_6629_APPL_STATUS_MOVE');
872: hr_utility.raise_error;
873: END IF;
874: --
875: hr_utility.set_location('hr_interview.update_interview',3);
876: --
877: -- #4894555: replace SQL with function call.
878: --
879: p_dummy := chk_duplicate(p_assignment_id, p_old_int_date, FALSE);

Line 882: hr_utility.trace('p_dummy is'||p_dummy);

878: --
879: p_dummy := chk_duplicate(p_assignment_id, p_old_int_date, FALSE);
880: --
881: --
882: hr_utility.trace('p_dummy is'||p_dummy);
883: IF p_dummy = 'Y' THEN
884: --
885: hr_utility.set_location('hr_interview.update_interview',4);
886: BEGIN

Line 885: hr_utility.set_location('hr_interview.update_interview',4);

881: --
882: hr_utility.trace('p_dummy is'||p_dummy);
883: IF p_dummy = 'Y' THEN
884: --
885: hr_utility.set_location('hr_interview.update_interview',4);
886: BEGIN
887: SELECT 'Y'
888: INTO p_matches
889: FROM per_assignments_f a

Line 896: hr_utility.set_location('hr_interview.update_interview',5);

892: EXCEPTION
893: WHEN NO_DATA_FOUND THEN NULL;
894: END;
895: --
896: hr_utility.set_location('hr_interview.update_interview',5);
897: --
898: IF p_matches = 'N' THEN /* CASE A */
899: --
900: hr_utility.set_location('hr_interview.update_interview',6);

Line 900: hr_utility.set_location('hr_interview.update_interview',6);

896: hr_utility.set_location('hr_interview.update_interview',5);
897: --
898: IF p_matches = 'N' THEN /* CASE A */
899: --
900: hr_utility.set_location('hr_interview.update_interview',6);
901: UPDATE per_assignments_f a
902: SET a.effective_start_date = p_int_date
903: , a.last_updated_by = p_last_updated_by
904: , a.last_update_login = p_last_update_login

Line 910: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

906: WHERE a.assignment_id = p_assignment_id
907: AND a.effective_start_date = p_old_int_date;
908: --
909: IF SQL%ROWCOUNT <> 1 THEN
910: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
911: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
912: hr_utility.set_message_token('STEP','1');
913: hr_utility.raise_error;
914: END IF;

Line 911: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');

907: AND a.effective_start_date = p_old_int_date;
908: --
909: IF SQL%ROWCOUNT <> 1 THEN
910: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
911: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
912: hr_utility.set_message_token('STEP','1');
913: hr_utility.raise_error;
914: END IF;
915: --

Line 912: hr_utility.set_message_token('STEP','1');

908: --
909: IF SQL%ROWCOUNT <> 1 THEN
910: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
911: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
912: hr_utility.set_message_token('STEP','1');
913: hr_utility.raise_error;
914: END IF;
915: --
916: hr_utility.set_location('hr_interview.update_interview',7);

Line 913: hr_utility.raise_error;

909: IF SQL%ROWCOUNT <> 1 THEN
910: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
911: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
912: hr_utility.set_message_token('STEP','1');
913: hr_utility.raise_error;
914: END IF;
915: --
916: hr_utility.set_location('hr_interview.update_interview',7);
917: UPDATE per_assignments_f a

Line 916: hr_utility.set_location('hr_interview.update_interview',7);

912: hr_utility.set_message_token('STEP','1');
913: hr_utility.raise_error;
914: END IF;
915: --
916: hr_utility.set_location('hr_interview.update_interview',7);
917: UPDATE per_assignments_f a
918: SET a.effective_end_date = p_int_date -1
919: , a.last_updated_by = p_last_updated_by
920: , a.last_update_login = p_last_update_login

Line 926: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

922: WHERE a.assignment_id = p_assignment_id
923: AND a.effective_end_date = p_old_int_date -1;
924: --
925: IF SQL%ROWCOUNT <> 1 THEN
926: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
927: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
928: hr_utility.set_message_token('STEP','2');
929: hr_utility.raise_error;
930: END IF;

Line 927: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');

923: AND a.effective_end_date = p_old_int_date -1;
924: --
925: IF SQL%ROWCOUNT <> 1 THEN
926: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
927: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
928: hr_utility.set_message_token('STEP','2');
929: hr_utility.raise_error;
930: END IF;
931: --

Line 928: hr_utility.set_message_token('STEP','2');

924: --
925: IF SQL%ROWCOUNT <> 1 THEN
926: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
927: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
928: hr_utility.set_message_token('STEP','2');
929: hr_utility.raise_error;
930: END IF;
931: --
932: ELSE /* CASE C */

Line 929: hr_utility.raise_error;

925: IF SQL%ROWCOUNT <> 1 THEN
926: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
927: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
928: hr_utility.set_message_token('STEP','2');
929: hr_utility.raise_error;
930: END IF;
931: --
932: ELSE /* CASE C */
933: --

Line 934: hr_utility.set_location('hr_interview.update_interview',8);

930: END IF;
931: --
932: ELSE /* CASE C */
933: --
934: hr_utility.set_location('hr_interview.update_interview',8);
935: DELETE per_assignments_f a
936: WHERE a.assignment_id = p_assignment_id
937: AND a.effective_start_date = p_old_int_date;
938: --

Line 940: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

936: WHERE a.assignment_id = p_assignment_id
937: AND a.effective_start_date = p_old_int_date;
938: --
939: IF SQL%ROWCOUNT <> 1 THEN
940: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
941: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
942: hr_utility.set_message_token('STEP','3');
943: hr_utility.raise_error;
944: END IF;

Line 941: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');

937: AND a.effective_start_date = p_old_int_date;
938: --
939: IF SQL%ROWCOUNT <> 1 THEN
940: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
941: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
942: hr_utility.set_message_token('STEP','3');
943: hr_utility.raise_error;
944: END IF;
945: --

Line 942: hr_utility.set_message_token('STEP','3');

938: --
939: IF SQL%ROWCOUNT <> 1 THEN
940: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
941: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
942: hr_utility.set_message_token('STEP','3');
943: hr_utility.raise_error;
944: END IF;
945: --
946: hr_utility.set_location('hr_interview.update_interview',9);

Line 943: hr_utility.raise_error;

939: IF SQL%ROWCOUNT <> 1 THEN
940: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
941: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
942: hr_utility.set_message_token('STEP','3');
943: hr_utility.raise_error;
944: END IF;
945: --
946: hr_utility.set_location('hr_interview.update_interview',9);
947: UPDATE per_assignments_f a

Line 946: hr_utility.set_location('hr_interview.update_interview',9);

942: hr_utility.set_message_token('STEP','3');
943: hr_utility.raise_error;
944: END IF;
945: --
946: hr_utility.set_location('hr_interview.update_interview',9);
947: UPDATE per_assignments_f a
948: SET a.effective_end_date = p_int_date -1
949: , a.last_updated_by = p_last_updated_by
950: , a.last_update_login = p_last_update_login

Line 956: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

952: WHERE a.assignment_id = p_assignment_id
953: AND a.effective_end_date = p_old_int_date -1;
954: --
955: IF SQL%ROWCOUNT <> 1 THEN
956: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
957: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
958: hr_utility.set_message_token('STEP','4');
959: hr_utility.raise_error;
960: END IF;

Line 957: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');

953: AND a.effective_end_date = p_old_int_date -1;
954: --
955: IF SQL%ROWCOUNT <> 1 THEN
956: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
957: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
958: hr_utility.set_message_token('STEP','4');
959: hr_utility.raise_error;
960: END IF;
961: --

Line 958: hr_utility.set_message_token('STEP','4');

954: --
955: IF SQL%ROWCOUNT <> 1 THEN
956: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
957: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
958: hr_utility.set_message_token('STEP','4');
959: hr_utility.raise_error;
960: END IF;
961: --
962: END IF;

Line 959: hr_utility.raise_error;

955: IF SQL%ROWCOUNT <> 1 THEN
956: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
957: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
958: hr_utility.set_message_token('STEP','4');
959: hr_utility.raise_error;
960: END IF;
961: --
962: END IF;
963: --

Line 972: hr_utility.set_location('hr_interview.update_interview',10);

968: IF p_int_date > p_old_int_date THEN
969: --
970: p_no_update := 'N';
971: --
972: hr_utility.set_location('hr_interview.update_interview',10);
973: BEGIN
974: --
975: SELECT 'Y'
976: INTO p_no_update

Line 990: hr_utility.set_message(801,'HR_6629_APPL_STATUS_MOVE');

986: --
987: END;
988: --
989: IF p_no_update = 'Y' THEN
990: hr_utility.set_message(801,'HR_6629_APPL_STATUS_MOVE');
991: hr_utility.raise_error;
992: END IF;
993: --
994: hr_utility.set_location('hr_interview.update_interview',11);

Line 991: hr_utility.raise_error;

987: END;
988: --
989: IF p_no_update = 'Y' THEN
990: hr_utility.set_message(801,'HR_6629_APPL_STATUS_MOVE');
991: hr_utility.raise_error;
992: END IF;
993: --
994: hr_utility.set_location('hr_interview.update_interview',11);
995: --

Line 994: hr_utility.set_location('hr_interview.update_interview',11);

990: hr_utility.set_message(801,'HR_6629_APPL_STATUS_MOVE');
991: hr_utility.raise_error;
992: END IF;
993: --
994: hr_utility.set_location('hr_interview.update_interview',11);
995: --
996: SELECT a.assignment_status_type_id
997: INTO p_ass_status_type_id
998: FROM per_assignments_f a

Line 1003: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

999: WHERE a.assignment_id = p_assignment_id
1000: AND a.effective_end_date = p_old_int_date -1;
1001: --
1002: IF SQL%ROWCOUNT <> 1 THEN
1003: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1004: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1005: hr_utility.set_message_token('STEP','5');
1006: hr_utility.raise_error;
1007: END IF;

Line 1004: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');

1000: AND a.effective_end_date = p_old_int_date -1;
1001: --
1002: IF SQL%ROWCOUNT <> 1 THEN
1003: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1004: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1005: hr_utility.set_message_token('STEP','5');
1006: hr_utility.raise_error;
1007: END IF;
1008: --

Line 1005: hr_utility.set_message_token('STEP','5');

1001: --
1002: IF SQL%ROWCOUNT <> 1 THEN
1003: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1004: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1005: hr_utility.set_message_token('STEP','5');
1006: hr_utility.raise_error;
1007: END IF;
1008: --
1009: hr_utility.set_location('hr_interview.update_interview',12);

Line 1006: hr_utility.raise_error;

1002: IF SQL%ROWCOUNT <> 1 THEN
1003: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1004: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1005: hr_utility.set_message_token('STEP','5');
1006: hr_utility.raise_error;
1007: END IF;
1008: --
1009: hr_utility.set_location('hr_interview.update_interview',12);
1010: --

Line 1009: hr_utility.set_location('hr_interview.update_interview',12);

1005: hr_utility.set_message_token('STEP','5');
1006: hr_utility.raise_error;
1007: END IF;
1008: --
1009: hr_utility.set_location('hr_interview.update_interview',12);
1010: --
1011: INSERT INTO per_assignments_f
1012: (
1013: assignment_id

Line 1200: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1196: WHERE assignment_id = p_assignment_id
1197: AND effective_start_date = p_old_int_date;
1198: --
1199: IF SQL%ROWCOUNT <> 1 THEN
1200: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1201: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1202: hr_utility.set_message_token('STEP','6');
1203: hr_utility.raise_error;
1204: ELSE

Line 1201: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');

1197: AND effective_start_date = p_old_int_date;
1198: --
1199: IF SQL%ROWCOUNT <> 1 THEN
1200: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1201: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1202: hr_utility.set_message_token('STEP','6');
1203: hr_utility.raise_error;
1204: ELSE
1205: hr_utility.set_location('hr_interview.update_interview',13);

Line 1202: hr_utility.set_message_token('STEP','6');

1198: --
1199: IF SQL%ROWCOUNT <> 1 THEN
1200: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1201: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1202: hr_utility.set_message_token('STEP','6');
1203: hr_utility.raise_error;
1204: ELSE
1205: hr_utility.set_location('hr_interview.update_interview',13);
1206: UPDATE per_assignments_f a

Line 1203: hr_utility.raise_error;

1199: IF SQL%ROWCOUNT <> 1 THEN
1200: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1201: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1202: hr_utility.set_message_token('STEP','6');
1203: hr_utility.raise_error;
1204: ELSE
1205: hr_utility.set_location('hr_interview.update_interview',13);
1206: UPDATE per_assignments_f a
1207: SET a.effective_start_date = p_int_date

Line 1205: hr_utility.set_location('hr_interview.update_interview',13);

1201: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1202: hr_utility.set_message_token('STEP','6');
1203: hr_utility.raise_error;
1204: ELSE
1205: hr_utility.set_location('hr_interview.update_interview',13);
1206: UPDATE per_assignments_f a
1207: SET a.effective_start_date = p_int_date
1208: , a.last_updated_by = p_last_updated_by
1209: , a.last_update_login = p_last_update_login

Line 1215: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1211: WHERE assignment_id = p_assignment_id
1212: AND effective_end_date = TO_DATE('31/12/4712','DD/MM/YYYY');
1213: --
1214: IF SQL%ROWCOUNT <> 1 THEN
1215: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1216: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1217: hr_utility.set_message_token('STEP','7');
1218: hr_utility.raise_error;
1219: END IF;

Line 1216: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');

1212: AND effective_end_date = TO_DATE('31/12/4712','DD/MM/YYYY');
1213: --
1214: IF SQL%ROWCOUNT <> 1 THEN
1215: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1216: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1217: hr_utility.set_message_token('STEP','7');
1218: hr_utility.raise_error;
1219: END IF;
1220: END IF;

Line 1217: hr_utility.set_message_token('STEP','7');

1213: --
1214: IF SQL%ROWCOUNT <> 1 THEN
1215: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1216: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1217: hr_utility.set_message_token('STEP','7');
1218: hr_utility.raise_error;
1219: END IF;
1220: END IF;
1221: ELSE

Line 1218: hr_utility.raise_error;

1214: IF SQL%ROWCOUNT <> 1 THEN
1215: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1216: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1217: hr_utility.set_message_token('STEP','7');
1218: hr_utility.raise_error;
1219: END IF;
1220: END IF;
1221: ELSE
1222: -- insert back in time

Line 1224: hr_utility.set_location('hr_interview.update_interview',14);

1220: END IF;
1221: ELSE
1222: -- insert back in time
1223: --
1224: hr_utility.set_location('hr_interview.update_interview',14);
1225: SELECT a.assignment_status_type_id
1226: INTO p_ass_status_type_id
1227: FROM per_assignments_f a
1228: WHERE a.assignment_id = p_assignment_id

Line 1232: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1228: WHERE a.assignment_id = p_assignment_id
1229: AND a.effective_start_date = p_old_int_date;
1230: --
1231: IF SQL%ROWCOUNT <> 1 THEN
1232: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1233: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1234: hr_utility.set_message_token('STEP','8');
1235: hr_utility.raise_error;
1236: END IF;

Line 1233: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');

1229: AND a.effective_start_date = p_old_int_date;
1230: --
1231: IF SQL%ROWCOUNT <> 1 THEN
1232: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1233: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1234: hr_utility.set_message_token('STEP','8');
1235: hr_utility.raise_error;
1236: END IF;
1237: --

Line 1234: hr_utility.set_message_token('STEP','8');

1230: --
1231: IF SQL%ROWCOUNT <> 1 THEN
1232: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1233: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1234: hr_utility.set_message_token('STEP','8');
1235: hr_utility.raise_error;
1236: END IF;
1237: --
1238: hr_utility.set_location('hr_interview.update_interview',15);

Line 1235: hr_utility.raise_error;

1231: IF SQL%ROWCOUNT <> 1 THEN
1232: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1233: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1234: hr_utility.set_message_token('STEP','8');
1235: hr_utility.raise_error;
1236: END IF;
1237: --
1238: hr_utility.set_location('hr_interview.update_interview',15);
1239: SELECT a.effective_start_date

Line 1238: hr_utility.set_location('hr_interview.update_interview',15);

1234: hr_utility.set_message_token('STEP','8');
1235: hr_utility.raise_error;
1236: END IF;
1237: --
1238: hr_utility.set_location('hr_interview.update_interview',15);
1239: SELECT a.effective_start_date
1240: INTO p_old_prev_start_date
1241: FROM per_assignments_f a
1242: WHERE a.assignment_id = p_assignment_id

Line 1246: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1242: WHERE a.assignment_id = p_assignment_id
1243: AND a.effective_end_date = p_old_int_date -1;
1244: --
1245: IF SQL%ROWCOUNT <> 1 THEN
1246: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1247: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1248: hr_utility.set_message_token('STEP','9');
1249: hr_utility.raise_error;
1250: END IF;

Line 1247: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');

1243: AND a.effective_end_date = p_old_int_date -1;
1244: --
1245: IF SQL%ROWCOUNT <> 1 THEN
1246: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1247: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1248: hr_utility.set_message_token('STEP','9');
1249: hr_utility.raise_error;
1250: END IF;
1251: --

Line 1248: hr_utility.set_message_token('STEP','9');

1244: --
1245: IF SQL%ROWCOUNT <> 1 THEN
1246: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1247: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1248: hr_utility.set_message_token('STEP','9');
1249: hr_utility.raise_error;
1250: END IF;
1251: --
1252: -- Insert the Interview

Line 1249: hr_utility.raise_error;

1245: IF SQL%ROWCOUNT <> 1 THEN
1246: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1247: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1248: hr_utility.set_message_token('STEP','9');
1249: hr_utility.raise_error;
1250: END IF;
1251: --
1252: -- Insert the Interview
1253: hr_utility.set_location('hr_interview.update_interview',16);

Line 1253: hr_utility.set_location('hr_interview.update_interview',16);

1249: hr_utility.raise_error;
1250: END IF;
1251: --
1252: -- Insert the Interview
1253: hr_utility.set_location('hr_interview.update_interview',16);
1254: --
1255: INSERT INTO per_assignments_f
1256: (
1257: assignment_id

Line 1444: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1440: WHERE assignment_id = p_assignment_id
1441: AND effective_end_date = p_old_int_date -1;
1442: --
1443: IF SQL%ROWCOUNT <>1 THEN
1444: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1445: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1446: hr_utility.set_message_token('STEP','10');
1447: hr_utility.raise_error;
1448: ELSE

Line 1445: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');

1441: AND effective_end_date = p_old_int_date -1;
1442: --
1443: IF SQL%ROWCOUNT <>1 THEN
1444: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1445: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1446: hr_utility.set_message_token('STEP','10');
1447: hr_utility.raise_error;
1448: ELSE
1449: hr_utility.set_location('hr_interview.update_interview',17);

Line 1446: hr_utility.set_message_token('STEP','10');

1442: --
1443: IF SQL%ROWCOUNT <>1 THEN
1444: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1445: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1446: hr_utility.set_message_token('STEP','10');
1447: hr_utility.raise_error;
1448: ELSE
1449: hr_utility.set_location('hr_interview.update_interview',17);
1450: --

Line 1447: hr_utility.raise_error;

1443: IF SQL%ROWCOUNT <>1 THEN
1444: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1445: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1446: hr_utility.set_message_token('STEP','10');
1447: hr_utility.raise_error;
1448: ELSE
1449: hr_utility.set_location('hr_interview.update_interview',17);
1450: --
1451: UPDATE per_assignments_f a

Line 1449: hr_utility.set_location('hr_interview.update_interview',17);

1445: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1446: hr_utility.set_message_token('STEP','10');
1447: hr_utility.raise_error;
1448: ELSE
1449: hr_utility.set_location('hr_interview.update_interview',17);
1450: --
1451: UPDATE per_assignments_f a
1452: SET a.effective_end_date = p_int_date -1
1453: , a.last_updated_by = p_last_updated_by

Line 1461: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1457: AND effective_start_date = p_old_prev_start_date
1458: AND effective_end_date = p_old_int_date -1;
1459: --
1460: IF SQL%ROWCOUNT <> 1 THEN
1461: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1462: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1463: hr_utility.set_message_token('STEP','11');
1464: hr_utility.raise_error;
1465: END IF;

Line 1462: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');

1458: AND effective_end_date = p_old_int_date -1;
1459: --
1460: IF SQL%ROWCOUNT <> 1 THEN
1461: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1462: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1463: hr_utility.set_message_token('STEP','11');
1464: hr_utility.raise_error;
1465: END IF;
1466: END IF;

Line 1463: hr_utility.set_message_token('STEP','11');

1459: --
1460: IF SQL%ROWCOUNT <> 1 THEN
1461: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1462: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1463: hr_utility.set_message_token('STEP','11');
1464: hr_utility.raise_error;
1465: END IF;
1466: END IF;
1467: -- End the insert backward

Line 1464: hr_utility.raise_error;

1460: IF SQL%ROWCOUNT <> 1 THEN
1461: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1462: hr_utility.set_message_token('PROCEDURE','UPDATE_INTERVIEW');
1463: hr_utility.set_message_token('STEP','11');
1464: hr_utility.raise_error;
1465: END IF;
1466: END IF;
1467: -- End the insert backward
1468: END IF;