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_CHANGE_START_DATE_API dependencies on HR_UTILITY

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

67: fetch csr_pds_exists into l_dummy;
68: if csr_pds_exists%notfound
69: and p_old_start_date is not null then
70: close csr_pds_exists;
71: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
72: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
73: hr_utility.set_message_token('STEP','1');
74: hr_utility.raise_error;
75: else

Line 72: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');

68: if csr_pds_exists%notfound
69: and p_old_start_date is not null then
70: close csr_pds_exists;
71: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
72: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
73: hr_utility.set_message_token('STEP','1');
74: hr_utility.raise_error;
75: else
76: close csr_pds_exists;

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

69: and p_old_start_date is not null then
70: close csr_pds_exists;
71: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
72: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
73: hr_utility.set_message_token('STEP','1');
74: hr_utility.raise_error;
75: else
76: close csr_pds_exists;
77: end if;

Line 74: hr_utility.raise_error;

70: close csr_pds_exists;
71: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
72: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
73: hr_utility.set_message_token('STEP','1');
74: hr_utility.raise_error;
75: else
76: close csr_pds_exists;
77: end if;
78: elsif p_type = 'C' then

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

80: fetch csr_pdp_exists into l_dummy;
81: if csr_pdp_exists%notfound
82: and p_old_start_date is not null then
83: close csr_pdp_exists;
84: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
85: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
86: hr_utility.set_message_token('STEP','2');
87: hr_utility.raise_error;
88: else

Line 85: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');

81: if csr_pdp_exists%notfound
82: and p_old_start_date is not null then
83: close csr_pdp_exists;
84: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
85: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
86: hr_utility.set_message_token('STEP','2');
87: hr_utility.raise_error;
88: else
89: close csr_pdp_exists;

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

82: and p_old_start_date is not null then
83: close csr_pdp_exists;
84: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
85: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
86: hr_utility.set_message_token('STEP','2');
87: hr_utility.raise_error;
88: else
89: close csr_pdp_exists;
90: end if;

Line 87: hr_utility.raise_error;

83: close csr_pdp_exists;
84: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
85: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
86: hr_utility.set_message_token('STEP','2');
87: hr_utility.raise_error;
88: else
89: close csr_pdp_exists;
90: end if;
91: else

Line 180: hr_utility.set_message('800','PER_289309_ST_DATE_CHG_NOTALWD');

176: open csr_pds_exists;
177: fetch csr_pds_exists into l_dummy;
178: if csr_pds_exists%found then
179: close csr_pds_exists;
180: hr_utility.set_message('800','PER_289309_ST_DATE_CHG_NOTALWD');
181: hr_utility.raise_error;
182: else
183: close csr_pds_exists;
184: end if;

Line 181: hr_utility.raise_error;

177: fetch csr_pds_exists into l_dummy;
178: if csr_pds_exists%found then
179: close csr_pds_exists;
180: hr_utility.set_message('800','PER_289309_ST_DATE_CHG_NOTALWD');
181: hr_utility.raise_error;
182: else
183: close csr_pds_exists;
184: end if;
185: else

Line 195: hr_utility.set_message('800','HR_449762_HD_GT_PREV_PDS');

191: OPEN csr_inv_new_hd;
192: FETCH csr_inv_new_hd INTO l_dummy;
193: IF csr_inv_new_hd%FOUND THEN
194: CLOSE csr_inv_new_hd;
195: hr_utility.set_message('800','HR_449762_HD_GT_PREV_PDS');
196: hr_utility.raise_error;
197: END IF;
198: CLOSE csr_inv_new_hd;
199: --

Line 196: hr_utility.raise_error;

192: FETCH csr_inv_new_hd INTO l_dummy;
193: IF csr_inv_new_hd%FOUND THEN
194: CLOSE csr_inv_new_hd;
195: hr_utility.set_message('800','HR_449762_HD_GT_PREV_PDS');
196: hr_utility.raise_error;
197: END IF;
198: CLOSE csr_inv_new_hd;
199: --
200: -- Check if old start date overlaps another PDS

Line 228: hr_utility.set_message('800','HR_449760_EMP_HD_PDS');

224: IF (l_new_start_date_in_range AND NOT l_old_start_date_in_range)
225: OR
226: (NOT l_new_start_date_in_range AND l_old_start_date_in_range)
227: THEN
228: hr_utility.set_message('800','HR_449760_EMP_HD_PDS');
229: hr_utility.raise_error;
230: END IF;
231: end if; -- FPD rule check
232: --

Line 229: hr_utility.raise_error;

225: OR
226: (NOT l_new_start_date_in_range AND l_old_start_date_in_range)
227: THEN
228: hr_utility.set_message('800','HR_449760_EMP_HD_PDS');
229: hr_utility.raise_error;
230: END IF;
231: end if; -- FPD rule check
232: --
233: -- Check the new hire date with other dates on PDS

Line 239: hr_utility.set_message('800','HR_449739_EMP_HD_ATD');

235: OPEN csr_new_start_date;
236: FETCH csr_new_start_date INTO l_dummy;
237: IF csr_new_start_date%FOUND THEN
238: CLOSE csr_new_start_date;
239: hr_utility.set_message('800','HR_449739_EMP_HD_ATD');
240: hr_utility.raise_error;
241: END IF;
242: CLOSE csr_new_start_date;
243: --

Line 240: hr_utility.raise_error;

236: FETCH csr_new_start_date INTO l_dummy;
237: IF csr_new_start_date%FOUND THEN
238: CLOSE csr_new_start_date;
239: hr_utility.set_message('800','HR_449739_EMP_HD_ATD');
240: hr_utility.raise_error;
241: END IF;
242: CLOSE csr_new_start_date;
243: --
244: elsif p_type = 'C' then

Line 249: hr_utility.set_message('800','PER_289309_ST_DATE_CHG_NOTALWD');

245: open csr_pdp_exists;
246: fetch csr_pdp_exists into l_dummy;
247: if csr_pdp_exists%found then
248: close csr_pdp_exists;
249: hr_utility.set_message('800','PER_289309_ST_DATE_CHG_NOTALWD');
250: hr_utility.raise_error;
251: else
252: close csr_pdp_exists;
253: end if;

Line 250: hr_utility.raise_error;

246: fetch csr_pdp_exists into l_dummy;
247: if csr_pdp_exists%found then
248: close csr_pdp_exists;
249: hr_utility.set_message('800','PER_289309_ST_DATE_CHG_NOTALWD');
250: hr_utility.raise_error;
251: else
252: close csr_pdp_exists;
253: end if;
254: else

Line 293: hr_utility.set_message(801,'HR_51810_EMP_COMPL_ACTIONS');

289: open csr_compl_actions;
290: fetch csr_compl_actions into l_dummy;
291: if csr_compl_actions%found then
292: close csr_compl_actions;
293: hr_utility.set_message(801,'HR_51810_EMP_COMPL_ACTIONS');
294: hr_utility.raise_error;
295: else
296: close csr_compl_actions;
297: end if;

Line 294: hr_utility.raise_error;

290: fetch csr_compl_actions into l_dummy;
291: if csr_compl_actions%found then
292: close csr_compl_actions;
293: hr_utility.set_message(801,'HR_51810_EMP_COMPL_ACTIONS');
294: hr_utility.raise_error;
295: else
296: close csr_compl_actions;
297: end if;
298: --

Line 360: hr_utility.set_message(801,'HR_51811_EMP_CONTIG_POS');

356: else
357: null;
358: end if;
359: IF l_action_chk = 'Y' THEN
360: hr_utility.set_message(801,'HR_51811_EMP_CONTIG_POS');
361: hr_utility.raise_error;
362: END IF;
363: --
364: end check_contig_pds_pdp;

Line 361: hr_utility.raise_error;

357: null;
358: end if;
359: IF l_action_chk = 'Y' THEN
360: hr_utility.set_message(801,'HR_51811_EMP_CONTIG_POS');
361: hr_utility.raise_error;
362: END IF;
363: --
364: end check_contig_pds_pdp;
365: --

Line 422: hr_utility.set_message('801','HR_7679_EMP_SUP_PAY_NOT_EXIST');

418: effective_start_date and effective_end_date
419: );
420: exception
421: when no_data_found then
422: hr_utility.set_message('801','HR_7679_EMP_SUP_PAY_NOT_EXIST');
423: hr_utility.raise_error;
424: end;
425: end if;
426: if l_supervisor_id is not null then

Line 423: hr_utility.raise_error;

419: );
420: exception
421: when no_data_found then
422: hr_utility.set_message('801','HR_7679_EMP_SUP_PAY_NOT_EXIST');
423: hr_utility.raise_error;
424: end;
425: end if;
426: if l_supervisor_id is not null then
427: begin

Line 439: hr_utility.set_message('801','HR_7680_EMP_SUP_PAY_NOT_EXIST');

435: effective_start_date and effective_end_date
436: );
437: exception
438: when no_data_found then
439: hr_utility.set_message('801','HR_7680_EMP_SUP_PAY_NOT_EXIST');
440: hr_utility.raise_error;
441: end;
442: end if;
443: --

Line 440: hr_utility.raise_error;

436: );
437: exception
438: when no_data_found then
439: hr_utility.set_message('801','HR_7680_EMP_SUP_PAY_NOT_EXIST');
440: hr_utility.raise_error;
441: end;
442: end if;
443: --
444: end check_supe_pay;

Line 491: hr_utility.set_message(801,'HR_6837_EMP_REF_DATE_CHG');

487: open csr_sp_placement_pds;
488: fetch csr_sp_placement_pds into l_dummy;
489: if csr_sp_placement_pds%found then
490: close csr_sp_placement_pds;
491: hr_utility.set_message(801,'HR_6837_EMP_REF_DATE_CHG');
492: hr_utility.raise_error;
493: else
494: close csr_sp_placement_pds;
495: end if;

Line 492: hr_utility.raise_error;

488: fetch csr_sp_placement_pds into l_dummy;
489: if csr_sp_placement_pds%found then
490: close csr_sp_placement_pds;
491: hr_utility.set_message(801,'HR_6837_EMP_REF_DATE_CHG');
492: hr_utility.raise_error;
493: else
494: close csr_sp_placement_pds;
495: end if;
496: elsif p_type = 'C' then

Line 501: hr_utility.set_message(801,'HR_6837_EMP_REF_DATE_CHG');

497: open csr_sp_placement_pdp;
498: fetch csr_sp_placement_pdp into l_dummy;
499: if csr_sp_placement_pdp%found then
500: close csr_sp_placement_pdp;
501: hr_utility.set_message(801,'HR_6837_EMP_REF_DATE_CHG');
502: hr_utility.raise_error;
503: else
504: close csr_sp_placement_pdp;
505: end if;

Line 502: hr_utility.raise_error;

498: fetch csr_sp_placement_pdp into l_dummy;
499: if csr_sp_placement_pdp%found then
500: close csr_sp_placement_pdp;
501: hr_utility.set_message(801,'HR_6837_EMP_REF_DATE_CHG');
502: hr_utility.raise_error;
503: else
504: close csr_sp_placement_pdp;
505: end if;
506: else

Line 543: hr_utility.set_message(801,'PER_289851_CWK_ASG_RATE_EXISTS');

539: open csr_asg_rates_pdp;
540: fetch csr_asg_rates_pdp into l_dummy;
541: if csr_asg_rates_pdp%found then
542: close csr_asg_rates_pdp;
543: hr_utility.set_message(801,'PER_289851_CWK_ASG_RATE_EXISTS');
544: hr_utility.raise_error;
545: else
546: close csr_asg_rates_pdp;
547: end if;

Line 544: hr_utility.raise_error;

540: fetch csr_asg_rates_pdp into l_dummy;
541: if csr_asg_rates_pdp%found then
542: close csr_asg_rates_pdp;
543: hr_utility.set_message(801,'PER_289851_CWK_ASG_RATE_EXISTS');
544: hr_utility.raise_error;
545: else
546: close csr_asg_rates_pdp;
547: end if;
548: else

Line 598: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');

594: open csr_cost_pds;
595: fetch csr_cost_pds into l_dummy;
596: if csr_cost_pds%found then
597: close csr_cost_pds;
598: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
599: hr_utility.raise_error;
600: else
601: close csr_cost_pds;
602: end if;

Line 599: hr_utility.raise_error;

595: fetch csr_cost_pds into l_dummy;
596: if csr_cost_pds%found then
597: close csr_cost_pds;
598: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
599: hr_utility.raise_error;
600: else
601: close csr_cost_pds;
602: end if;
603: elsif p_type = 'C' then

Line 608: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');

604: open csr_cost_pdp;
605: fetch csr_cost_pdp into l_dummy;
606: if csr_cost_pdp%found then
607: close csr_cost_pdp;
608: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
609: hr_utility.raise_error;
610: else
611: close csr_cost_pdp;
612: end if;

Line 609: hr_utility.raise_error;

605: fetch csr_cost_pdp into l_dummy;
606: if csr_cost_pdp%found then
607: close csr_cost_pdp;
608: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
609: hr_utility.raise_error;
610: else
611: close csr_cost_pdp;
612: end if;
613: else

Line 663: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');

659: open csr_budget_pds;
660: fetch csr_budget_pds into l_dummy;
661: if csr_budget_pds%found then
662: close csr_budget_pds;
663: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
664: hr_utility.raise_error;
665: else
666: close csr_budget_pds;
667: end if;

Line 664: hr_utility.raise_error;

660: fetch csr_budget_pds into l_dummy;
661: if csr_budget_pds%found then
662: close csr_budget_pds;
663: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
664: hr_utility.raise_error;
665: else
666: close csr_budget_pds;
667: end if;
668: elsif p_type = 'C' then

Line 673: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');

669: open csr_budget_pdp;
670: fetch csr_budget_pdp into l_dummy;
671: if csr_budget_pdp%found then
672: close csr_budget_pdp;
673: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
674: hr_utility.raise_error;
675: else
676: close csr_budget_pdp;
677: end if;

Line 674: hr_utility.raise_error;

670: fetch csr_budget_pdp into l_dummy;
671: if csr_budget_pdp%found then
672: close csr_budget_pdp;
673: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
674: hr_utility.raise_error;
675: else
676: close csr_budget_pdp;
677: end if;
678: else

Line 715: hr_utility.set_message(801,'HR_6841_EMP_REF_DATE_CHG');

711: open csr_people_change;
712: fetch csr_people_change into l_dummy;
713: if csr_people_change%found then
714: close csr_people_change;
715: hr_utility.set_message(801,'HR_6841_EMP_REF_DATE_CHG');
716: hr_utility.raise_error;
717: else
718: close csr_people_change;
719: end if;

Line 716: hr_utility.raise_error;

712: fetch csr_people_change into l_dummy;
713: if csr_people_change%found then
714: close csr_people_change;
715: hr_utility.set_message(801,'HR_6841_EMP_REF_DATE_CHG');
716: hr_utility.raise_error;
717: else
718: close csr_people_change;
719: end if;
720: end check_people_changes;

Line 749: hr_utility.set_message(800,'PER_289306_PTU_CHG_EXISTS');

745: open csr_person_type_change;
746: fetch csr_person_type_change into l_dummy;
747: if csr_person_type_change%found then
748: close csr_person_type_change;
749: hr_utility.set_message(800,'PER_289306_PTU_CHG_EXISTS');
750: hr_utility.raise_error;
751: else
752: close csr_person_type_change;
753: end if;

Line 750: hr_utility.raise_error;

746: fetch csr_person_type_change into l_dummy;
747: if csr_person_type_change%found then
748: close csr_person_type_change;
749: hr_utility.set_message(800,'PER_289306_PTU_CHG_EXISTS');
750: hr_utility.raise_error;
751: else
752: close csr_person_type_change;
753: end if;
754: end check_user_person_type_changes;

Line 784: hr_utility.set_message(801,'HR_6838_EMP_REF_DATE_CHG');

780: open csr_asg_status;
781: fetch csr_asg_status into l_dummy;
782: if csr_asg_status%found then
783: close csr_asg_status;
784: hr_utility.set_message(801,'HR_6838_EMP_REF_DATE_CHG');
785: hr_utility.raise_error;
786: else
787: close csr_asg_status;
788: end if;

Line 785: hr_utility.raise_error;

781: fetch csr_asg_status into l_dummy;
782: if csr_asg_status%found then
783: close csr_asg_status;
784: hr_utility.set_message(801,'HR_6838_EMP_REF_DATE_CHG');
785: hr_utility.raise_error;
786: else
787: close csr_asg_status;
788: end if;
789: --

Line 815: hr_utility.set_message(801,'HR_6839_EMP_REF_DATE_CHG');

811: open csr_asg_change;
812: fetch csr_asg_change into l_dummy;
813: if csr_asg_change%found then
814: close csr_asg_change;
815: hr_utility.set_message(801,'HR_6839_EMP_REF_DATE_CHG');
816: hr_utility.raise_error;
817: else
818: close csr_asg_change;
819: end if;

Line 816: hr_utility.raise_error;

812: fetch csr_asg_change into l_dummy;
813: if csr_asg_change%found then
814: close csr_asg_change;
815: hr_utility.set_message(801,'HR_6839_EMP_REF_DATE_CHG');
816: hr_utility.raise_error;
817: else
818: close csr_asg_change;
819: end if;
820: --

Line 847: hr_utility.set_message(801,'HR_6840_EMP_ENTER_PERIOD');

843: open csr_prev_asg;
844: fetch csr_prev_asg into l_dummy;
845: if csr_prev_asg%found then
846: close csr_prev_asg;
847: hr_utility.set_message(801,'HR_6840_EMP_ENTER_PERIOD');
848: hr_utility.raise_error;
849: else
850: close csr_prev_asg;
851: end if;

Line 848: hr_utility.raise_error;

844: fetch csr_prev_asg into l_dummy;
845: if csr_prev_asg%found then
846: close csr_prev_asg;
847: hr_utility.set_message(801,'HR_6840_EMP_ENTER_PERIOD');
848: hr_utility.raise_error;
849: else
850: close csr_prev_asg;
851: end if;
852: --

Line 924: hr_utility.set_message('800','PER_449825_OP_LE_EXISTS');

920: fetch c_ben into dummy;
921:
922: if c_ben%found then
923: close c_ben;
924: hr_utility.set_message('800','PER_449825_OP_LE_EXISTS');
925: hr_utility.raise_error;
926: end if;
927:
928: close c_ben;

Line 925: hr_utility.raise_error;

921:
922: if c_ben%found then
923: close c_ben;
924: hr_utility.set_message('800','PER_449825_OP_LE_EXISTS');
925: hr_utility.raise_error;
926: end if;
927:
928: close c_ben;
929:

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

963: fetch pds into pds_rec;
964: end loop pds_loop;
965: if pds%rowcount <>1 then
966: close pds;
967: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
968: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
969: hr_utility.set_message_token('STEP','1');
970: hr_utility.raise_error;
971: else

Line 968: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');

964: end loop pds_loop;
965: if pds%rowcount <>1 then
966: close pds;
967: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
968: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
969: hr_utility.set_message_token('STEP','1');
970: hr_utility.raise_error;
971: else
972: close pds;

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

965: if pds%rowcount <>1 then
966: close pds;
967: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
968: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
969: hr_utility.set_message_token('STEP','1');
970: hr_utility.raise_error;
971: else
972: close pds;
973: end if;

Line 970: hr_utility.raise_error;

966: close pds;
967: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
968: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
969: hr_utility.set_message_token('STEP','1');
970: hr_utility.raise_error;
971: else
972: close pds;
973: end if;
974: l_object_version_number := pds_rec.object_version_number;

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

984: fetch pdp into pdp_rec;
985: end loop pdp_loop;
986: if pdp%rowcount <>1 then
987: close pdp;
988: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
989: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
990: hr_utility.set_message_token('STEP','2');
991: hr_utility.raise_error;
992: else

Line 989: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');

985: end loop pdp_loop;
986: if pdp%rowcount <>1 then
987: close pdp;
988: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
989: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
990: hr_utility.set_message_token('STEP','2');
991: hr_utility.raise_error;
992: else
993: close pdp;

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

986: if pdp%rowcount <>1 then
987: close pdp;
988: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
989: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
990: hr_utility.set_message_token('STEP','2');
991: hr_utility.raise_error;
992: else
993: close pdp;
994: end if;

Line 991: hr_utility.raise_error;

987: close pdp;
988: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
989: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
990: hr_utility.set_message_token('STEP','2');
991: hr_utility.raise_error;
992: else
993: close pdp;
994: end if;
995: update per_periods_of_placement

Line 1034: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');

1030: set effective_start_date = p_new_start_date
1031: where effective_start_date = p_old_start_date
1032: and placement_id = l_sp_id;
1033: if sql%rowcount <1 then
1034: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1035: hr_utility.set_message_token('TABLE','PER_SPINAL_POINT_PLACEMENTS_F');
1036: hr_utility.raise_error;
1037: end if;
1038: end loop;

Line 1035: hr_utility.set_message_token('TABLE','PER_SPINAL_POINT_PLACEMENTS_F');

1031: where effective_start_date = p_old_start_date
1032: and placement_id = l_sp_id;
1033: if sql%rowcount <1 then
1034: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1035: hr_utility.set_message_token('TABLE','PER_SPINAL_POINT_PLACEMENTS_F');
1036: hr_utility.raise_error;
1037: end if;
1038: end loop;
1039: close csr_ssp;

Line 1036: hr_utility.raise_error;

1032: and placement_id = l_sp_id;
1033: if sql%rowcount <1 then
1034: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1035: hr_utility.set_message_token('TABLE','PER_SPINAL_POINT_PLACEMENTS_F');
1036: hr_utility.raise_error;
1037: end if;
1038: end loop;
1039: close csr_ssp;
1040: end update_spinal_placement;

Line 1073: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');

1069: set effective_start_date = p_new_start_date
1070: where effective_start_date = p_old_start_date
1071: and grade_rule_id = l_pgr_id;
1072: if sql%rowcount <1 then
1073: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1074: hr_utility.set_message_token('TABLE','PAY_GRADE_RULES_F');
1075: hr_utility.raise_error;
1076: end if;
1077: end loop;

Line 1074: hr_utility.set_message_token('TABLE','PAY_GRADE_RULES_F');

1070: where effective_start_date = p_old_start_date
1071: and grade_rule_id = l_pgr_id;
1072: if sql%rowcount <1 then
1073: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1074: hr_utility.set_message_token('TABLE','PAY_GRADE_RULES_F');
1075: hr_utility.raise_error;
1076: end if;
1077: end loop;
1078: close csr_rate;

Line 1075: hr_utility.raise_error;

1071: and grade_rule_id = l_pgr_id;
1072: if sql%rowcount <1 then
1073: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1074: hr_utility.set_message_token('TABLE','PAY_GRADE_RULES_F');
1075: hr_utility.raise_error;
1076: end if;
1077: end loop;
1078: close csr_rate;
1079: end update_asg_rate;

Line 1111: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');

1107: set effective_start_date = p_new_start_date
1108: where effective_start_date = p_old_start_date
1109: and COST_ALLOCATION_ID = l_ca_id;
1110: if sql%rowcount <1 then
1111: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1112: hr_utility.set_message_token('TABLE','PAY_COST_ALLOCATIONS_F');
1113: hr_utility.raise_error;
1114: end if;
1115: end loop;

Line 1112: hr_utility.set_message_token('TABLE','PAY_COST_ALLOCATIONS_F');

1108: where effective_start_date = p_old_start_date
1109: and COST_ALLOCATION_ID = l_ca_id;
1110: if sql%rowcount <1 then
1111: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1112: hr_utility.set_message_token('TABLE','PAY_COST_ALLOCATIONS_F');
1113: hr_utility.raise_error;
1114: end if;
1115: end loop;
1116: close csr_cost;

Line 1113: hr_utility.raise_error;

1109: and COST_ALLOCATION_ID = l_ca_id;
1110: if sql%rowcount <1 then
1111: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1112: hr_utility.set_message_token('TABLE','PAY_COST_ALLOCATIONS_F');
1113: hr_utility.raise_error;
1114: end if;
1115: end loop;
1116: close csr_cost;
1117: end update_cost_allocation;

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

1172: open csr_get_bg;
1173: fetch csr_get_bg into l_business_group_id;
1174: if csr_get_bg%NOTFOUND then
1175: close csr_get_bg;
1176: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1177: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1178: hr_utility.set_message_token('STEP', '1');
1179: hr_utility.raise_error;
1180: end if;

Line 1177: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');

1173: fetch csr_get_bg into l_business_group_id;
1174: if csr_get_bg%NOTFOUND then
1175: close csr_get_bg;
1176: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1177: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1178: hr_utility.set_message_token('STEP', '1');
1179: hr_utility.raise_error;
1180: end if;
1181: close csr_get_bg;

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

1174: if csr_get_bg%NOTFOUND then
1175: close csr_get_bg;
1176: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1177: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1178: hr_utility.set_message_token('STEP', '1');
1179: hr_utility.raise_error;
1180: end if;
1181: close csr_get_bg;
1182: pay_us_emp_dt_tax_rules.default_tax_with_validation

Line 1179: hr_utility.raise_error;

1175: close csr_get_bg;
1176: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1177: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1178: hr_utility.set_message_token('STEP', '1');
1179: hr_utility.raise_error;
1180: end if;
1181: close csr_get_bg;
1182: pay_us_emp_dt_tax_rules.default_tax_with_validation
1183: (p_assignment_id => null

Line 1227: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');

1223: where a2.assignment_id = a.assignment_id
1224: and a2.assignment_type = 'A')
1225: and a.assignment_id = l_assignment_id;
1226: if sql%rowcount <1 then
1227: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1228: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
1229: hr_utility.raise_error;
1230: end if;
1231: end loop;

Line 1228: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');

1224: and a2.assignment_type = 'A')
1225: and a.assignment_id = l_assignment_id;
1226: if sql%rowcount <1 then
1227: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1228: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
1229: hr_utility.raise_error;
1230: end if;
1231: end loop;
1232: close csr_apl_asg;

Line 1229: hr_utility.raise_error;

1225: and a.assignment_id = l_assignment_id;
1226: if sql%rowcount <1 then
1227: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1228: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
1229: hr_utility.raise_error;
1230: end if;
1231: end loop;
1232: close csr_apl_asg;
1233: end update_apl_asg;

Line 1269: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');

1265: and a1.person_id = peo.person_id
1266: and peo.effective_start_date = p_old_start_date
1267: and peo.current_applicant_flag = 'Y');
1268: if sql%rowcount <1 then
1269: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1270: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');
1271: hr_utility.raise_error;
1272: end if;
1273: end loop;

Line 1270: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');

1266: and peo.effective_start_date = p_old_start_date
1267: and peo.current_applicant_flag = 'Y');
1268: if sql%rowcount <1 then
1269: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1270: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');
1271: hr_utility.raise_error;
1272: end if;
1273: end loop;
1274: close csr_apl;

Line 1271: hr_utility.raise_error;

1267: and peo.current_applicant_flag = 'Y');
1268: if sql%rowcount <1 then
1269: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1270: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');
1271: hr_utility.raise_error;
1272: end if;
1273: end loop;
1274: close csr_apl;
1275: end update_apl;

Line 1320: hr_utility.set_location('update_pay_proposal',1);

1316: --
1317: --
1318: l_count := 0;
1319:
1320: hr_utility.set_location('update_pay_proposal',1);
1321:
1322: open prv_pay_proposals;
1323: fetch prv_pay_proposals into l_count;
1324: hr_utility.set_location('update_pay_proposal.count = '||l_count,2);

Line 1324: hr_utility.set_location('update_pay_proposal.count = '||l_count,2);

1320: hr_utility.set_location('update_pay_proposal',1);
1321:
1322: open prv_pay_proposals;
1323: fetch prv_pay_proposals into l_count;
1324: hr_utility.set_location('update_pay_proposal.count = '||l_count,2);
1325:
1326: if prv_pay_proposals%FOUND then
1327: close prv_pay_proposals;
1328: else

Line 1330: hr_utility.set_location('update_pay_proposal',10);

1326: if prv_pay_proposals%FOUND then
1327: close prv_pay_proposals;
1328: else
1329: close prv_pay_proposals;
1330: hr_utility.set_location('update_pay_proposal',10);
1331: end if;
1332:
1333: if l_count > 1 then
1334: hr_utility.set_message('800','PER_289794_HISTORIC_SAL_PRPSL');

Line 1334: hr_utility.set_message('800','PER_289794_HISTORIC_SAL_PRPSL');

1330: hr_utility.set_location('update_pay_proposal',10);
1331: end if;
1332:
1333: if l_count > 1 then
1334: hr_utility.set_message('800','PER_289794_HISTORIC_SAL_PRPSL');
1335: hr_utility.raise_error;
1336: else
1337:
1338: open get_pay_proposal;

Line 1335: hr_utility.raise_error;

1331: end if;
1332:
1333: if l_count > 1 then
1334: hr_utility.set_message('800','PER_289794_HISTORIC_SAL_PRPSL');
1335: hr_utility.raise_error;
1336: else
1337:
1338: open get_pay_proposal;
1339: loop

Line 1345: hr_utility.set_location('update_pay_proposal.p_new_start_date = '||to_char(p_new_start_date,'DD-MON-YYYY'),40);

1341: exit when get_pay_proposal%NOTFOUND;
1342: -- if get_pay_proposal%FOUND then
1343: -- close get_pay_proposal;
1344: begin
1345: hr_utility.set_location('update_pay_proposal.p_new_start_date = '||to_char(p_new_start_date,'DD-MON-YYYY'),40);
1346: hr_utility.set_location('update_pay_proposal.p_old_start_date = '||to_char(p_old_start_date,'DD-MON-YYYY'),40);
1347: hr_utility.set_location('update_pay_proposal.p_person_id = '||p_person_id,40);
1348: hr_utility.set_location('update_pay_proposal.p_type = '||p_type,40);
1349: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,40);

Line 1346: hr_utility.set_location('update_pay_proposal.p_old_start_date = '||to_char(p_old_start_date,'DD-MON-YYYY'),40);

1342: -- if get_pay_proposal%FOUND then
1343: -- close get_pay_proposal;
1344: begin
1345: hr_utility.set_location('update_pay_proposal.p_new_start_date = '||to_char(p_new_start_date,'DD-MON-YYYY'),40);
1346: hr_utility.set_location('update_pay_proposal.p_old_start_date = '||to_char(p_old_start_date,'DD-MON-YYYY'),40);
1347: hr_utility.set_location('update_pay_proposal.p_person_id = '||p_person_id,40);
1348: hr_utility.set_location('update_pay_proposal.p_type = '||p_type,40);
1349: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,40);
1350: --

Line 1347: hr_utility.set_location('update_pay_proposal.p_person_id = '||p_person_id,40);

1343: -- close get_pay_proposal;
1344: begin
1345: hr_utility.set_location('update_pay_proposal.p_new_start_date = '||to_char(p_new_start_date,'DD-MON-YYYY'),40);
1346: hr_utility.set_location('update_pay_proposal.p_old_start_date = '||to_char(p_old_start_date,'DD-MON-YYYY'),40);
1347: hr_utility.set_location('update_pay_proposal.p_person_id = '||p_person_id,40);
1348: hr_utility.set_location('update_pay_proposal.p_type = '||p_type,40);
1349: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,40);
1350: --
1351: update per_pay_proposals

Line 1348: hr_utility.set_location('update_pay_proposal.p_type = '||p_type,40);

1344: begin
1345: hr_utility.set_location('update_pay_proposal.p_new_start_date = '||to_char(p_new_start_date,'DD-MON-YYYY'),40);
1346: hr_utility.set_location('update_pay_proposal.p_old_start_date = '||to_char(p_old_start_date,'DD-MON-YYYY'),40);
1347: hr_utility.set_location('update_pay_proposal.p_person_id = '||p_person_id,40);
1348: hr_utility.set_location('update_pay_proposal.p_type = '||p_type,40);
1349: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,40);
1350: --
1351: update per_pay_proposals
1352: set change_date = p_new_start_date

Line 1349: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,40);

1345: hr_utility.set_location('update_pay_proposal.p_new_start_date = '||to_char(p_new_start_date,'DD-MON-YYYY'),40);
1346: hr_utility.set_location('update_pay_proposal.p_old_start_date = '||to_char(p_old_start_date,'DD-MON-YYYY'),40);
1347: hr_utility.set_location('update_pay_proposal.p_person_id = '||p_person_id,40);
1348: hr_utility.set_location('update_pay_proposal.p_type = '||p_type,40);
1349: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,40);
1350: --
1351: update per_pay_proposals
1352: set change_date = p_new_start_date
1353: where change_date = p_old_start_date

Line 1363: hr_utility.set_location('update_pay_proposal',50);

1359: and primary_flag = 'Y'
1360: and effective_start_date = p_new_start_date
1361: and assignment_type = p_type);
1362: */
1363: hr_utility.set_location('update_pay_proposal',50);
1364: if sql%ROWCOUNT <> 1 then
1365: raise NO_DATA_FOUND;
1366: end if;
1367: exception

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

1365: raise NO_DATA_FOUND;
1366: end if;
1367: exception
1368: when NO_DATA_FOUND then
1369: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1370: hr_utility.set_message_token('PROCEDURE','Update_row');
1371: hr_utility.set_message_token('STEP','4');
1372: hr_utility.raise_error;
1373: end;

Line 1370: hr_utility.set_message_token('PROCEDURE','Update_row');

1366: end if;
1367: exception
1368: when NO_DATA_FOUND then
1369: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1370: hr_utility.set_message_token('PROCEDURE','Update_row');
1371: hr_utility.set_message_token('STEP','4');
1372: hr_utility.raise_error;
1373: end;
1374: -- else

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

1367: exception
1368: when NO_DATA_FOUND then
1369: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1370: hr_utility.set_message_token('PROCEDURE','Update_row');
1371: hr_utility.set_message_token('STEP','4');
1372: hr_utility.raise_error;
1373: end;
1374: -- else
1375: -- null;

Line 1372: hr_utility.raise_error;

1368: when NO_DATA_FOUND then
1369: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1370: hr_utility.set_message_token('PROCEDURE','Update_row');
1371: hr_utility.set_message_token('STEP','4');
1372: hr_utility.raise_error;
1373: end;
1374: -- else
1375: -- null;
1376: -- end if;

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

1410: open csr_get_bg;
1411: fetch csr_get_bg into l_business_group_id;
1412: if csr_get_bg%NOTFOUND then
1413: close csr_get_bg;
1414: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1415: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1416: hr_utility.set_message_token('STEP', '1');
1417: hr_utility.raise_error;
1418: end if;

Line 1415: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');

1411: fetch csr_get_bg into l_business_group_id;
1412: if csr_get_bg%NOTFOUND then
1413: close csr_get_bg;
1414: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1415: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1416: hr_utility.set_message_token('STEP', '1');
1417: hr_utility.raise_error;
1418: end if;
1419: close csr_get_bg;

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

1412: if csr_get_bg%NOTFOUND then
1413: close csr_get_bg;
1414: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1415: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1416: hr_utility.set_message_token('STEP', '1');
1417: hr_utility.raise_error;
1418: end if;
1419: close csr_get_bg;
1420: -- Set the correct validation start and end dates for

Line 1417: hr_utility.raise_error;

1413: close csr_get_bg;
1414: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1415: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1416: hr_utility.set_message_token('STEP', '1');
1417: hr_utility.raise_error;
1418: end if;
1419: close csr_get_bg;
1420: -- Set the correct validation start and end dates for
1421: -- the assignments. These are the same for all

Line 1533: hr_utility.set_location('Entering:'|| l_proc, 10);

1529: --
1530: --
1531: BEGIN
1532: --
1533: hr_utility.set_location('Entering:'|| l_proc, 10);
1534: l_new_effective_date := p_new_effective_date;
1535: l_new_start_date := p_new_effective_date;
1536:
1537: FOR assignment_rec in csr_assignments(p_person_id, p_new_effective_date) LOOP

Line 1542: hr_utility.set_location('Assignment ID: '||l_assignment_id, 20);

1538: --
1539: -- for each Assignment of Person loop through.
1540: --
1541: l_assignment_id := assignment_rec.assignment_id;
1542: hr_utility.set_location('Assignment ID: '||l_assignment_id, 20);
1543: --
1544: -- Get old probation details.
1545: --
1546: open csr_probation_details(l_assignment_id, p_new_effective_date);

Line 1549: hr_utility.set_location('Old probation details: ', 30);

1545: --
1546: open csr_probation_details(l_assignment_id, p_new_effective_date);
1547: fetch csr_probation_details into l_date_probation_end1, l_probation_period1, l_probation_unit1;
1548: close csr_probation_details;
1549: hr_utility.set_location('Old probation details: ', 30);
1550: hr_utility.set_location('date_probation_end:'||l_date_probation_end1, 30);
1551: hr_utility.set_location('probation_period: '||l_probation_period1, 30);
1552: hr_utility.set_location('probation_unit : '||l_probation_unit1, 30);
1553: --

Line 1550: hr_utility.set_location('date_probation_end:'||l_date_probation_end1, 30);

1546: open csr_probation_details(l_assignment_id, p_new_effective_date);
1547: fetch csr_probation_details into l_date_probation_end1, l_probation_period1, l_probation_unit1;
1548: close csr_probation_details;
1549: hr_utility.set_location('Old probation details: ', 30);
1550: hr_utility.set_location('date_probation_end:'||l_date_probation_end1, 30);
1551: hr_utility.set_location('probation_period: '||l_probation_period1, 30);
1552: hr_utility.set_location('probation_unit : '||l_probation_unit1, 30);
1553: --
1554: l_new_date_probation_end := null;

Line 1551: hr_utility.set_location('probation_period: '||l_probation_period1, 30);

1547: fetch csr_probation_details into l_date_probation_end1, l_probation_period1, l_probation_unit1;
1548: close csr_probation_details;
1549: hr_utility.set_location('Old probation details: ', 30);
1550: hr_utility.set_location('date_probation_end:'||l_date_probation_end1, 30);
1551: hr_utility.set_location('probation_period: '||l_probation_period1, 30);
1552: hr_utility.set_location('probation_unit : '||l_probation_unit1, 30);
1553: --
1554: l_new_date_probation_end := null;
1555: --

Line 1552: hr_utility.set_location('probation_unit : '||l_probation_unit1, 30);

1548: close csr_probation_details;
1549: hr_utility.set_location('Old probation details: ', 30);
1550: hr_utility.set_location('date_probation_end:'||l_date_probation_end1, 30);
1551: hr_utility.set_location('probation_period: '||l_probation_period1, 30);
1552: hr_utility.set_location('probation_unit : '||l_probation_unit1, 30);
1553: --
1554: l_new_date_probation_end := null;
1555: --
1556: -- Get new probation end date.

Line 1575: hr_utility.set_location('Assignment ID: '||l_assignment_id, 40);

1571: -- then update the probation end date of this asg update.
1572: --
1573: l_effective_start_date := asg_update_rec.effective_start_date;
1574: --
1575: hr_utility.set_location('Assignment ID: '||l_assignment_id, 40);
1576: hr_utility.set_location('Effective start date.: '||l_effective_start_date, 40);
1577: --
1578: open csr_probation_details(l_assignment_id, l_effective_start_date);
1579: fetch csr_probation_details into l_date_probation_end, l_probation_period, l_probation_unit;

Line 1576: hr_utility.set_location('Effective start date.: '||l_effective_start_date, 40);

1572: --
1573: l_effective_start_date := asg_update_rec.effective_start_date;
1574: --
1575: hr_utility.set_location('Assignment ID: '||l_assignment_id, 40);
1576: hr_utility.set_location('Effective start date.: '||l_effective_start_date, 40);
1577: --
1578: open csr_probation_details(l_assignment_id, l_effective_start_date);
1579: fetch csr_probation_details into l_date_probation_end, l_probation_period, l_probation_unit;
1580: if csr_probation_details%found then

Line 1587: hr_utility.set_location('date probation end is not updated', 50);

1583: or (l_probation_period <> l_probation_period1)
1584: or (l_probation_unit <> l_probation_unit1) then
1585: --
1586: null;
1587: hr_utility.set_location('date probation end is not updated', 50);
1588: --
1589: else
1590: --
1591: hr_utility.set_location('date probation end is updated', 60);

Line 1591: hr_utility.set_location('date probation end is updated', 60);

1587: hr_utility.set_location('date probation end is not updated', 50);
1588: --
1589: else
1590: --
1591: hr_utility.set_location('date probation end is updated', 60);
1592: update per_assignments_f paf
1593: set paf.date_probation_end = l_new_date_probation_end
1594: where paf.assignment_id = l_assignment_id
1595: and paf.effective_start_date = l_effective_start_date;

Line 1608: hr_utility.set_location('Leaving:'|| l_proc, 90);

1604:
1605: --
1606: END LOOP;
1607: --
1608: hr_utility.set_location('Leaving:'|| l_proc, 90);
1609: --
1610: END UPDATE_PROBATION_END;
1611: --
1612: -- Bug 2614732 ends here.

Line 1641: hr_utility.set_message(800,'PER_449500_EXTRA_SER_DET_EXIST');

1637: open csr_extra_details;
1638: fetch csr_extra_details into l_dummy;
1639: if csr_extra_details%found then
1640: close csr_extra_details;
1641: hr_utility.set_message(800,'PER_449500_EXTRA_SER_DET_EXIST');
1642: hr_utility.raise_error;
1643: end if;
1644: close csr_extra_details;
1645: --

Line 1642: hr_utility.raise_error;

1638: fetch csr_extra_details into l_dummy;
1639: if csr_extra_details%found then
1640: close csr_extra_details;
1641: hr_utility.set_message(800,'PER_449500_EXTRA_SER_DET_EXIST');
1642: hr_utility.raise_error;
1643: end if;
1644: close csr_extra_details;
1645: --
1646: end check_extra_details_of_service;

Line 1684: hr_utility.set_location('Entering :'||l_proc, 10);

1680: BEGIN
1681: --
1682: -- Check if the affected assignments have any Grade ladder.
1683: --
1684: hr_utility.set_location('Entering :'||l_proc, 10);
1685: --
1686: FOR asg_rec in csr_asg_records LOOP
1687: --
1688: -- Check the grade ladder is valid after the start date is moved.

Line 1690: hr_utility.set_location('Entering :'||l_proc, 20);

1686: FOR asg_rec in csr_asg_records LOOP
1687: --
1688: -- Check the grade ladder is valid after the start date is moved.
1689: --
1690: hr_utility.set_location('Entering :'||l_proc, 20);
1691: --
1692: open csr_is_pgm_valid(asg_rec.GRADE_LADDER_PGM_ID);
1693: fetch csr_is_pgm_valid into l_dummy;
1694: IF csr_is_pgm_valid%NOTFOUND THEN

Line 1700: hr_utility.set_message (800,'HR_449567_USD_INVALID_PGM');

1696: -- The grade ladder is invalid on the new start date.
1697: --
1698: close csr_is_pgm_valid;
1699: --
1700: hr_utility.set_message (800,'HR_449567_USD_INVALID_PGM');
1701: hr_utility.raise_error;
1702: --
1703: END IF;
1704: --

Line 1701: hr_utility.raise_error;

1697: --
1698: close csr_is_pgm_valid;
1699: --
1700: hr_utility.set_message (800,'HR_449567_USD_INVALID_PGM');
1701: hr_utility.raise_error;
1702: --
1703: END IF;
1704: --
1705: hr_utility.set_location('Entering :'||l_proc, 30);

Line 1705: hr_utility.set_location('Entering :'||l_proc, 30);

1701: hr_utility.raise_error;
1702: --
1703: END IF;
1704: --
1705: hr_utility.set_location('Entering :'||l_proc, 30);
1706: --
1707: close csr_is_pgm_valid;
1708: --
1709: END LOOP;

Line 1711: hr_utility.set_location('Leaving :'||l_proc, 100);

1707: close csr_is_pgm_valid;
1708: --
1709: END LOOP;
1710: --
1711: hr_utility.set_location('Leaving :'||l_proc, 100);
1712: --
1713: END check_grade_ladder;
1714: --
1715: -- ----------------------------------------------------------------------------

Line 2045: hr_utility.set_location('Entering:'|| l_proc, 10);

2041: l_system_person_type per_person_types.system_person_type%TYPE;
2042: l_warn_ee varchar2(1) := 'N';
2043: --
2044: begin
2045: hr_utility.set_location('Entering:'|| l_proc, 10);
2046: --
2047: -- Check mandatory parameters have been set
2048: --
2049: hr_api.mandatory_arg_error

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

2087: fetch csr_pdp into l_pds_or_pdp_id;
2088: close csr_pdp;
2089: l_system_person_type := 'CWK';
2090: else
2091: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
2092: hr_utility.set_message_token('PROCEDURE','update_start_date');
2093: hr_utility.set_message_token('STEP','1');
2094: hr_utility.raise_error;
2095: end if;

Line 2092: hr_utility.set_message_token('PROCEDURE','update_start_date');

2088: close csr_pdp;
2089: l_system_person_type := 'CWK';
2090: else
2091: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
2092: hr_utility.set_message_token('PROCEDURE','update_start_date');
2093: hr_utility.set_message_token('STEP','1');
2094: hr_utility.raise_error;
2095: end if;
2096: hr_utility.set_location(l_proc, 20);

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

2089: l_system_person_type := 'CWK';
2090: else
2091: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
2092: hr_utility.set_message_token('PROCEDURE','update_start_date');
2093: hr_utility.set_message_token('STEP','1');
2094: hr_utility.raise_error;
2095: end if;
2096: hr_utility.set_location(l_proc, 20);
2097: --

Line 2094: hr_utility.raise_error;

2090: else
2091: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
2092: hr_utility.set_message_token('PROCEDURE','update_start_date');
2093: hr_utility.set_message_token('STEP','1');
2094: hr_utility.raise_error;
2095: end if;
2096: hr_utility.set_location(l_proc, 20);
2097: --
2098: -- Call Before Process User Hook

Line 2096: hr_utility.set_location(l_proc, 20);

2092: hr_utility.set_message_token('PROCEDURE','update_start_date');
2093: hr_utility.set_message_token('STEP','1');
2094: hr_utility.raise_error;
2095: end if;
2096: hr_utility.set_location(l_proc, 20);
2097: --
2098: -- Call Before Process User Hook
2099: --
2100: begin

Line 2151: hr_utility.set_location(l_proc, 25);

2147: --
2148: IF l_old_start_date = l_new_start_date then
2149: --
2150: NULL; -- do nothing as hire dates have not actually changed.
2151: hr_utility.set_location(l_proc, 25);
2152: --
2153: ELSE
2154: --
2155: check_not_supervisor(p_person_id => p_person_id

Line 2159: hr_utility.set_location(l_proc, 30);

2155: check_not_supervisor(p_person_id => p_person_id
2156: ,p_new_start_date => l_new_start_date
2157: ,p_old_start_date => l_old_start_date
2158: );
2159: hr_utility.set_location(l_proc, 30);
2160: --
2161: check_pds_pdp(p_person_id => p_person_id
2162: ,p_new_start_date => l_new_start_date
2163: ,p_old_start_date => l_old_start_date

Line 2166: hr_utility.set_location(l_proc, 40);

2162: ,p_new_start_date => l_new_start_date
2163: ,p_old_start_date => l_old_start_date
2164: ,p_type => p_update_type
2165: );
2166: hr_utility.set_location(l_proc, 40);
2167: --
2168: check_un_ended_pds_pdp(p_person_id => p_person_id
2169: ,p_new_start_date => l_new_start_date
2170: --

Line 2183: hr_utility.set_location(l_proc, 45);

2179: -- 115.30 (END)
2180: --
2181: ,p_type => p_update_type
2182: );
2183: hr_utility.set_location(l_proc, 45);
2184: check_contig_pds_pdp(p_person_id => p_person_id
2185: ,p_old_start_date => l_old_start_date
2186: ,p_type => p_update_type);
2187: hr_utility.set_location(l_proc, 50);

Line 2187: hr_utility.set_location(l_proc, 50);

2183: hr_utility.set_location(l_proc, 45);
2184: check_contig_pds_pdp(p_person_id => p_person_id
2185: ,p_old_start_date => l_old_start_date
2186: ,p_type => p_update_type);
2187: hr_utility.set_location(l_proc, 50);
2188: --
2189: check_supe_pay(p_pds_or_pdp_id => l_pds_or_pdp_id
2190: ,p_new_start_date => l_new_start_date
2191: ,p_type => p_update_type);

Line 2192: hr_utility.set_location(l_proc, 60);

2188: --
2189: check_supe_pay(p_pds_or_pdp_id => l_pds_or_pdp_id
2190: ,p_new_start_date => l_new_start_date
2191: ,p_type => p_update_type);
2192: hr_utility.set_location(l_proc, 60);
2193: --
2194: -- Fix for bug 3972548 starts here.
2195: --
2196: check_grade_ladder(p_person_id

Line 2200: hr_utility.set_location(l_proc, 65);

2196: check_grade_ladder(p_person_id
2197: ,l_old_start_date
2198: ,l_new_start_date);
2199: --
2200: hr_utility.set_location(l_proc, 65);
2201: --
2202: -- Fix for bug 3972548 ends here.
2203: --
2204: if l_new_start_date > l_old_start_date then

Line 2237: hr_utility.set_location(l_proc, 70);

2233: check_for_compl_actions(p_person_id => p_person_id
2234: ,p_old_start_date => l_old_start_date
2235: ,p_new_start_date => l_new_start_date
2236: ,p_type => p_update_type);
2237: hr_utility.set_location(l_proc, 70);
2238: --
2239: -- 115.30 (START)
2240: --
2241: else

Line 2251: hr_utility.set_location(l_proc, 75);

2247: ,p_old_start_date => l_old_start_date
2248: ,p_new_start_date => l_new_start_date
2249: ,p_type => p_update_type);
2250: --
2251: hr_utility.set_location(l_proc, 75);
2252: end if;
2253: --
2254: -- 115.30 (END)
2255: --

Line 2261: hr_utility.set_location(l_proc, 80);

2257: check_sp_placements(p_person_id => p_person_id
2258: ,p_pds_or_pdp_id => l_pds_or_pdp_id
2259: ,p_new_start_date => l_new_start_date
2260: ,p_type => p_update_type);
2261: hr_utility.set_location(l_proc, 80);
2262: --
2263: check_asg_rates(p_person_id => p_person_id
2264: ,p_pds_or_pdp_id => l_pds_or_pdp_id
2265: ,p_new_start_date => l_new_start_date

Line 2267: hr_utility.set_location(l_proc, 85);

2263: check_asg_rates(p_person_id => p_person_id
2264: ,p_pds_or_pdp_id => l_pds_or_pdp_id
2265: ,p_new_start_date => l_new_start_date
2266: ,p_type => p_update_type);
2267: hr_utility.set_location(l_proc, 85);
2268: --
2269: check_cost_allocation(p_person_id => p_person_id
2270: ,p_pds_or_pdp_id => l_pds_or_pdp_id
2271: ,p_new_start_date => l_new_start_date

Line 2273: hr_utility.set_location(l_proc, 90);

2269: check_cost_allocation(p_person_id => p_person_id
2270: ,p_pds_or_pdp_id => l_pds_or_pdp_id
2271: ,p_new_start_date => l_new_start_date
2272: ,p_type => p_update_type);
2273: hr_utility.set_location(l_proc, 90);
2274: --
2275: check_budget_values(p_person_id => p_person_id
2276: ,p_pds_or_pdp_id => l_pds_or_pdp_id
2277: ,p_new_start_date => l_new_start_date

Line 2279: hr_utility.set_location(l_proc, 95);

2275: check_budget_values(p_person_id => p_person_id
2276: ,p_pds_or_pdp_id => l_pds_or_pdp_id
2277: ,p_new_start_date => l_new_start_date
2278: ,p_type => p_update_type);
2279: hr_utility.set_location(l_proc, 95);
2280: --
2281: check_people_changes(p_person_id => p_person_id
2282: ,p_earlier_date => l_earlier_date
2283: ,p_later_date => l_later_date

Line 2285: hr_utility.set_location(l_proc, 100);

2281: check_people_changes(p_person_id => p_person_id
2282: ,p_earlier_date => l_earlier_date
2283: ,p_later_date => l_later_date
2284: ,p_old_start_date => l_old_start_date);
2285: hr_utility.set_location(l_proc, 100);
2286: --
2287: check_asg_st_change(p_person_id => p_person_id
2288: ,p_earlier_date => l_earlier_date
2289: ,p_later_date => l_later_date

Line 2292: hr_utility.set_location(l_proc, 110);

2288: ,p_earlier_date => l_earlier_date
2289: ,p_later_date => l_later_date
2290: ,p_type => p_update_type
2291: ,p_old_start_date => l_old_start_date);
2292: hr_utility.set_location(l_proc, 110);
2293: --
2294: check_asg_change(p_person_id => p_person_id
2295: ,p_earlier_date => l_earlier_date
2296: ,p_later_date => l_later_date

Line 2306: hr_utility.set_location(l_proc, 115);

2302: check_user_person_type_changes(p_person_id => p_person_id
2303: ,p_earlier_date => l_earlier_date
2304: ,p_later_date => l_later_date
2305: ,p_old_start_date => l_old_start_date);
2306: hr_utility.set_location(l_proc, 115);
2307: --
2308: -- Fix for bug 3738058 starts here.
2309: --
2310: check_extra_details_of_service(p_person_id => p_person_id

Line 2314: hr_utility.set_location(l_proc, 117);

2310: check_extra_details_of_service(p_person_id => p_person_id
2311: ,p_old_start_date => l_old_start_date
2312: ,p_new_start_date => l_new_start_date);
2313: --
2314: hr_utility.set_location(l_proc, 117);
2315: --
2316: -- Fix for bug 3738058 ends here.
2317: --
2318: else

Line 2326: hr_utility.set_location(l_proc, 120);

2322: check_people_changes(p_person_id => p_person_id
2323: ,p_earlier_date => l_earlier_date
2324: ,p_later_date => l_later_date
2325: ,p_old_start_date => l_old_start_date);
2326: hr_utility.set_location(l_proc, 120);
2327: --
2328: check_asg_change(p_person_id => p_person_id
2329: ,p_earlier_date => l_earlier_date
2330: ,p_later_date => l_later_date

Line 2332: hr_utility.set_location(l_proc, 130);

2328: check_asg_change(p_person_id => p_person_id
2329: ,p_earlier_date => l_earlier_date
2330: ,p_later_date => l_later_date
2331: ,p_old_start_date => l_old_start_date);
2332: hr_utility.set_location(l_proc, 130);
2333: --
2334: check_prev_asg(p_person_id => p_person_id
2335: ,p_type => p_update_type
2336: ,p_old_start_date => l_old_start_date

Line 2338: hr_utility.set_location(l_proc, 140);

2334: check_prev_asg(p_person_id => p_person_id
2335: ,p_type => p_update_type
2336: ,p_old_start_date => l_old_start_date
2337: ,p_new_start_date => l_new_start_date);
2338: hr_utility.set_location(l_proc, 140);
2339: --
2340: end if;
2341: --
2342: check_recur_ee(p_person_id => p_person_id

Line 2346: hr_utility.set_location(l_proc, 150);

2342: check_recur_ee(p_person_id => p_person_id
2343: ,p_new_start_date => l_new_start_date
2344: ,p_old_start_date => l_old_start_date
2345: ,p_warn_raise => l_warn_ee);
2346: hr_utility.set_location(l_proc, 150);
2347: --
2348: --changes start for bug 6640794
2349:
2350: check_ben_enteries(p_person_id => p_person_id

Line 2368: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');

2364: ,p.original_date_of_hire = decode(p.original_date_of_hire
2365: ,l_old_start_date, l_new_start_date,p.original_date_of_hire)
2366: where p.person_id = p_person_id;
2367: if sql%rowcount <1 then
2368: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2369: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');
2370: hr_utility.raise_error;
2371: end if;
2372: --

Line 2369: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');

2365: ,l_old_start_date, l_new_start_date,p.original_date_of_hire)
2366: where p.person_id = p_person_id;
2367: if sql%rowcount <1 then
2368: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2369: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');
2370: hr_utility.raise_error;
2371: end if;
2372: --
2373: update per_people_f p

Line 2370: hr_utility.raise_error;

2366: where p.person_id = p_person_id;
2367: if sql%rowcount <1 then
2368: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2369: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');
2370: hr_utility.raise_error;
2371: end if;
2372: --
2373: update per_people_f p
2374: set p.start_date = (select min(ppf.effective_start_date)

Line 2385: hr_utility.set_location(l_proc, 160);

2381: update_period(p_person_id => p_person_id
2382: ,p_old_start_date => l_old_start_date
2383: ,p_new_start_date => l_new_start_date
2384: ,p_type => p_update_type);
2385: hr_utility.set_location(l_proc, 160);
2386: --
2387: -- Update the addresses that start at the old hire date
2388: -- Providing that addresses end date either equal to new start date or greater than it.
2389: --

Line 2396: hr_utility.set_location(l_proc, 170);

2392: where a.date_from = l_old_start_date
2393: and nvl(a.date_to,l_new_start_date) >= l_new_start_date
2394: and a.person_id = p_person_id;
2395: --
2396: hr_utility.set_location(l_proc, 170);
2397: --
2398: update pay_personal_payment_methods_f p
2399: set p.effective_start_date = l_new_start_date
2400: where p.effective_start_date = l_old_start_date

Line 2409: hr_utility.set_location(l_proc, 180);

2405: where p.assignment_id = a.assignment_id
2406: and a.assignment_type = p_update_type
2407: and a.person_id = p_person_id);
2408: --
2409: hr_utility.set_location(l_proc, 180);
2410: --
2411: update_spinal_placement(p_person_id => p_person_id
2412: ,p_old_start_date => l_old_start_date
2413: ,p_new_start_date => l_new_start_date

Line 2415: hr_utility.set_location(l_proc, 190);

2411: update_spinal_placement(p_person_id => p_person_id
2412: ,p_old_start_date => l_old_start_date
2413: ,p_new_start_date => l_new_start_date
2414: ,p_type => p_update_type);
2415: hr_utility.set_location(l_proc, 190);
2416: --
2417: update_asg_rate(p_person_id => p_person_id
2418: ,p_old_start_date => l_old_start_date
2419: ,p_new_start_date => l_new_start_date

Line 2421: hr_utility.set_location(l_proc, 190);

2417: update_asg_rate(p_person_id => p_person_id
2418: ,p_old_start_date => l_old_start_date
2419: ,p_new_start_date => l_new_start_date
2420: ,p_type => p_update_type);
2421: hr_utility.set_location(l_proc, 190);
2422: --
2423: update_cost_allocation(p_person_id => p_person_id
2424: ,p_old_start_date => l_old_start_date
2425: ,p_new_start_date => l_new_start_date

Line 2427: hr_utility.set_location(l_proc, 200);

2423: update_cost_allocation(p_person_id => p_person_id
2424: ,p_old_start_date => l_old_start_date
2425: ,p_new_start_date => l_new_start_date
2426: ,p_type => p_update_type);
2427: hr_utility.set_location(l_proc, 200);
2428: --
2429: update_asg_budget(p_person_id => p_person_id
2430: ,p_old_start_date => l_old_start_date
2431: ,p_new_start_date => l_new_start_date

Line 2433: hr_utility.set_location(l_proc, 210);

2429: update_asg_budget(p_person_id => p_person_id
2430: ,p_old_start_date => l_old_start_date
2431: ,p_new_start_date => l_new_start_date
2432: ,p_type => p_update_type);
2433: hr_utility.set_location(l_proc, 210);
2434: --
2435: --first update ALL matching cases of the period_of_placement_date_start for integrity
2436: --
2437: if p_update_type='C' then

Line 2444: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');

2440: where a.period_of_placement_date_start = l_old_start_date
2441: and a.assignment_type = p_update_type
2442: and a.person_id = p_person_id;
2443: if sql%rowcount <1 then
2444: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2445: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2446: hr_utility.raise_error;
2447: end if;
2448: end if;

Line 2445: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');

2441: and a.assignment_type = p_update_type
2442: and a.person_id = p_person_id;
2443: if sql%rowcount <1 then
2444: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2445: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2446: hr_utility.raise_error;
2447: end if;
2448: end if;
2449: --

Line 2446: hr_utility.raise_error;

2442: and a.person_id = p_person_id;
2443: if sql%rowcount <1 then
2444: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2445: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2446: hr_utility.raise_error;
2447: end if;
2448: end if;
2449: --
2450: update per_assignments_f a

Line 2456: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');

2452: where a.effective_start_date = l_old_start_date
2453: and a.assignment_type = p_update_type
2454: and a.person_id = p_person_id;
2455: if sql%rowcount <1 then
2456: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2457: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2458: hr_utility.raise_error;
2459: end if;
2460: --

Line 2457: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');

2453: and a.assignment_type = p_update_type
2454: and a.person_id = p_person_id;
2455: if sql%rowcount <1 then
2456: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2457: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2458: hr_utility.raise_error;
2459: end if;
2460: --
2461: -- 115.32 115.34 (START)

Line 2458: hr_utility.raise_error;

2454: and a.person_id = p_person_id;
2455: if sql%rowcount <1 then
2456: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2457: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2458: hr_utility.raise_error;
2459: end if;
2460: --
2461: -- 115.32 115.34 (START)
2462: --

Line 2486: hr_utility.set_location(l_proc, 220);

2482: update_probation_end( p_person_id, l_new_start_date);
2483: --
2484: -- Bug 2614732 ends here.
2485: --
2486: hr_utility.set_location(l_proc, 220);
2487: --
2488: -- Fix for bug 3738058 starts here.
2489: --
2490: update pqp_assignment_attributes_f paa

Line 2505: hr_utility.set_location(l_proc, 230);

2501: hr_contract_api.maintain_contracts
2502: (p_person_id => p_person_id
2503: ,p_new_start_date => l_new_start_date
2504: ,p_old_start_date => l_old_start_date);
2505: hr_utility.set_location(l_proc, 230);
2506: --
2507: update_tax(p_person_id => p_person_id
2508: ,p_new_start_date => l_new_start_date);
2509: hr_utility.set_location(l_proc, 240);

Line 2509: hr_utility.set_location(l_proc, 240);

2505: hr_utility.set_location(l_proc, 230);
2506: --
2507: update_tax(p_person_id => p_person_id
2508: ,p_new_start_date => l_new_start_date);
2509: hr_utility.set_location(l_proc, 240);
2510: --
2511: if p_applicant_number is not null then
2512: update_apl_asg(p_person_id => p_person_id
2513: ,p_old_start_date => l_old_start_date

Line 2515: hr_utility.set_location(l_proc, 250);

2511: if p_applicant_number is not null then
2512: update_apl_asg(p_person_id => p_person_id
2513: ,p_old_start_date => l_old_start_date
2514: ,p_new_start_date => l_new_start_date);
2515: hr_utility.set_location(l_proc, 250);
2516: --
2517: update_apl(p_person_id => p_person_id
2518: ,p_old_start_date => l_old_start_date
2519: ,p_new_start_date => l_new_start_date);

Line 2520: hr_utility.set_location(l_proc, 260);

2516: --
2517: update_apl(p_person_id => p_person_id
2518: ,p_old_start_date => l_old_start_date
2519: ,p_new_start_date => l_new_start_date);
2520: hr_utility.set_location(l_proc, 260);
2521: --
2522: end if;
2523: --
2524: hr_utility.set_location(l_proc, 270);

Line 2524: hr_utility.set_location(l_proc, 270);

2520: hr_utility.set_location(l_proc, 260);
2521: --
2522: end if;
2523: --
2524: hr_utility.set_location(l_proc, 270);
2525: --
2526: hr_per_type_usage_internal.change_hire_date_ptu
2527: (p_date_start => l_new_start_date
2528: ,p_old_date_start => l_old_start_date

Line 2532: hr_utility.set_location(l_proc, 280);

2528: ,p_old_date_start => l_old_start_date
2529: ,p_person_id => p_person_id
2530: ,p_system_person_type => l_system_person_type
2531: );
2532: hr_utility.set_location(l_proc, 280);
2533: --
2534: update_pay_proposal(p_person_id => p_person_id
2535: ,p_old_start_date => l_old_start_date
2536: ,p_new_start_date => l_new_start_date

Line 2538: hr_utility.set_location(l_proc, 290);

2534: update_pay_proposal(p_person_id => p_person_id
2535: ,p_old_start_date => l_old_start_date
2536: ,p_new_start_date => l_new_start_date
2537: ,p_type => p_update_type);
2538: hr_utility.set_location(l_proc, 290);
2539: --
2540: if p_update_type = 'E' then
2541: --
2542: -- 115.30 (START)

Line 2561: hr_utility.set_location(l_proc, 300);

2557: run_alu_ee(p_person_id => p_person_id
2558: ,p_old_start_date => l_old_start_date
2559: ,p_new_start_date => l_new_start_date
2560: ,p_type => p_update_type);
2561: hr_utility.set_location(l_proc, 300);
2562: --
2563: -- 115.30 (START)
2564: --
2565: else

Line 2575: hr_utility.set_location(l_proc, 305);

2571: ,p_old_start_date => l_old_start_date
2572: ,p_new_start_date => l_new_start_date
2573: ,p_type => p_update_type);
2574: --
2575: hr_utility.set_location(l_proc, 305);
2576: end if;
2577: --
2578: -- 115.30 (END)
2579: --

Line 2586: hr_utility.set_location(l_proc, 310);

2582: per_people12_pkg.maintain_coverage
2583: (p_person_id => p_person_id
2584: ,p_type => 'EMP'
2585: );
2586: hr_utility.set_location(l_proc, 310);
2587: end if;
2588: end if;
2589: --
2590: END IF; -- end of check that old and new start dates are actually different

Line 2610: hr_utility.set_location(l_proc, 310);

2606: (p_module_name => 'update_start_date'
2607: ,p_hook_type => 'AP'
2608: );
2609: end;
2610: hr_utility.set_location(l_proc, 310);
2611: --
2612: -- When in validation only mode raise the Validate_Enabled exception
2613: --
2614: if p_validate then

Line 2622: hr_utility.set_location(' Leaving:'||l_proc, 500);

2618: -- Set all output arguments
2619: --
2620: p_warn_ee := l_warn_ee;
2621: --
2622: hr_utility.set_location(' Leaving:'||l_proc, 500);
2623: exception
2624: when hr_api.validate_enabled then
2625: --
2626: -- As the Validate_Enabled exception has been raised

Line 2636: hr_utility.set_location(' Leaving:'||l_proc, 600);

2632: -- (Any key or derived arguments must be set to null
2633: -- when validation only mode is being used.)
2634: --
2635: p_warn_ee := 'N';
2636: hr_utility.set_location(' Leaving:'||l_proc, 600);
2637: when others then
2638: --
2639: -- A validation or unexpected error has occured
2640: --

Line 2647: hr_utility.set_location(' Leaving:'||l_proc, 700);

2643: -- set in out parameters and set out parameters
2644: --
2645: p_warn_ee := null;
2646: --
2647: hr_utility.set_location(' Leaving:'||l_proc, 700);
2648: raise;
2649: end update_start_date;
2650: --
2651: end hr_change_start_date_api;