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 80: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');

76: fetch csr_pds_exists into l_dummy;
77: if csr_pds_exists%notfound
78: and p_old_start_date is not null then
79: close csr_pds_exists;
80: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
81: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
82: hr_utility.set_message_token('STEP','1');
83: hr_utility.raise_error;
84: else

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

77: if csr_pds_exists%notfound
78: and p_old_start_date is not null then
79: close csr_pds_exists;
80: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
81: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
82: hr_utility.set_message_token('STEP','1');
83: hr_utility.raise_error;
84: else
85: close csr_pds_exists;

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

78: and p_old_start_date is not null then
79: close csr_pds_exists;
80: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
81: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
82: hr_utility.set_message_token('STEP','1');
83: hr_utility.raise_error;
84: else
85: close csr_pds_exists;
86: end if;

Line 83: hr_utility.raise_error;

79: close csr_pds_exists;
80: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
81: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
82: hr_utility.set_message_token('STEP','1');
83: hr_utility.raise_error;
84: else
85: close csr_pds_exists;
86: end if;
87: elsif p_type = 'C' then

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

89: fetch csr_pdp_exists into l_dummy;
90: if csr_pdp_exists%notfound
91: and p_old_start_date is not null then
92: close csr_pdp_exists;
93: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
94: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
95: hr_utility.set_message_token('STEP','2');
96: hr_utility.raise_error;
97: else

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

90: if csr_pdp_exists%notfound
91: and p_old_start_date is not null then
92: close csr_pdp_exists;
93: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
94: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
95: hr_utility.set_message_token('STEP','2');
96: hr_utility.raise_error;
97: else
98: close csr_pdp_exists;

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

91: and p_old_start_date is not null then
92: close csr_pdp_exists;
93: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
94: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
95: hr_utility.set_message_token('STEP','2');
96: hr_utility.raise_error;
97: else
98: close csr_pdp_exists;
99: end if;

Line 96: hr_utility.raise_error;

92: close csr_pdp_exists;
93: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
94: hr_utility.set_message_token('PROCEDURE','check_pds_pdp');
95: hr_utility.set_message_token('STEP','2');
96: hr_utility.raise_error;
97: else
98: close csr_pdp_exists;
99: end if;
100: else

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

194: open csr_pds_exists;
195: fetch csr_pds_exists into l_dummy;
196: if csr_pds_exists%found then
197: close csr_pds_exists;
198: hr_utility.set_message('800','PER_289309_ST_DATE_CHG_NOTALWD');
199: hr_utility.raise_error;
200: else
201: close csr_pds_exists;
202: end if;

Line 199: hr_utility.raise_error;

195: fetch csr_pds_exists into l_dummy;
196: if csr_pds_exists%found then
197: close csr_pds_exists;
198: hr_utility.set_message('800','PER_289309_ST_DATE_CHG_NOTALWD');
199: hr_utility.raise_error;
200: else
201: close csr_pds_exists;
202: end if;
203: else

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

209: OPEN csr_inv_new_hd;
210: FETCH csr_inv_new_hd INTO l_dummy;
211: IF csr_inv_new_hd%FOUND THEN
212: CLOSE csr_inv_new_hd;
213: hr_utility.set_message('800','HR_449762_HD_GT_PREV_PDS');
214: hr_utility.raise_error;
215: END IF;
216: CLOSE csr_inv_new_hd;
217: --

Line 214: hr_utility.raise_error;

210: FETCH csr_inv_new_hd INTO l_dummy;
211: IF csr_inv_new_hd%FOUND THEN
212: CLOSE csr_inv_new_hd;
213: hr_utility.set_message('800','HR_449762_HD_GT_PREV_PDS');
214: hr_utility.raise_error;
215: END IF;
216: CLOSE csr_inv_new_hd;
217: --
218: -- Check if old start date overlaps another PDS

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

242: IF (l_new_start_date_in_range AND NOT l_old_start_date_in_range)
243: OR
244: (NOT l_new_start_date_in_range AND l_old_start_date_in_range)
245: THEN
246: hr_utility.set_message('800','HR_449760_EMP_HD_PDS');
247: hr_utility.raise_error;
248: END IF;
249: end if; -- FPD rule check
250: --

Line 247: hr_utility.raise_error;

243: OR
244: (NOT l_new_start_date_in_range AND l_old_start_date_in_range)
245: THEN
246: hr_utility.set_message('800','HR_449760_EMP_HD_PDS');
247: hr_utility.raise_error;
248: END IF;
249: end if; -- FPD rule check
250: --
251: -- Check the new hire date with other dates on PDS

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

253: OPEN csr_new_start_date;
254: FETCH csr_new_start_date INTO l_dummy;
255: IF csr_new_start_date%FOUND THEN
256: CLOSE csr_new_start_date;
257: hr_utility.set_message('800','HR_449739_EMP_HD_ATD');
258: hr_utility.raise_error;
259: END IF;
260: CLOSE csr_new_start_date;
261: --

Line 258: hr_utility.raise_error;

254: FETCH csr_new_start_date INTO l_dummy;
255: IF csr_new_start_date%FOUND THEN
256: CLOSE csr_new_start_date;
257: hr_utility.set_message('800','HR_449739_EMP_HD_ATD');
258: hr_utility.raise_error;
259: END IF;
260: CLOSE csr_new_start_date;
261: --
262: -- Fix for 10124468

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

265: open csr_pdp_overlap;
266: fetch csr_pdp_overlap into l_dummy;
267: if csr_pdp_overlap%found then
268: close csr_pdp_overlap;
269: hr_utility.set_message('800','PER_289309_ST_DATE_CHG_NOTALWD');
270: hr_utility.raise_error;
271: else
272: close csr_pdp_overlap;
273: end if;

Line 270: hr_utility.raise_error;

266: fetch csr_pdp_overlap into l_dummy;
267: if csr_pdp_overlap%found then
268: close csr_pdp_overlap;
269: hr_utility.set_message('800','PER_289309_ST_DATE_CHG_NOTALWD');
270: hr_utility.raise_error;
271: else
272: close csr_pdp_overlap;
273: end if;
274:

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

278: open csr_pdp_exists;
279: fetch csr_pdp_exists into l_dummy;
280: if csr_pdp_exists%found then
281: close csr_pdp_exists;
282: hr_utility.set_message('800','PER_289309_ST_DATE_CHG_NOTALWD');
283: hr_utility.raise_error;
284: else
285: close csr_pdp_exists;
286: end if;

Line 283: hr_utility.raise_error;

279: fetch csr_pdp_exists into l_dummy;
280: if csr_pdp_exists%found then
281: close csr_pdp_exists;
282: hr_utility.set_message('800','PER_289309_ST_DATE_CHG_NOTALWD');
283: hr_utility.raise_error;
284: else
285: close csr_pdp_exists;
286: end if;
287: else

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

322: open csr_compl_actions;
323: fetch csr_compl_actions into l_dummy;
324: if csr_compl_actions%found then
325: close csr_compl_actions;
326: hr_utility.set_message(801,'HR_51810_EMP_COMPL_ACTIONS');
327: hr_utility.raise_error;
328: else
329: close csr_compl_actions;
330: end if;

Line 327: hr_utility.raise_error;

323: fetch csr_compl_actions into l_dummy;
324: if csr_compl_actions%found then
325: close csr_compl_actions;
326: hr_utility.set_message(801,'HR_51810_EMP_COMPL_ACTIONS');
327: hr_utility.raise_error;
328: else
329: close csr_compl_actions;
330: end if;
331: --

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

389: else
390: null;
391: end if;
392: IF l_action_chk = 'Y' THEN
393: hr_utility.set_message(801,'HR_51811_EMP_CONTIG_POS');
394: hr_utility.raise_error;
395: END IF;
396: --
397: end check_contig_pds_pdp;

Line 394: hr_utility.raise_error;

390: null;
391: end if;
392: IF l_action_chk = 'Y' THEN
393: hr_utility.set_message(801,'HR_51811_EMP_CONTIG_POS');
394: hr_utility.raise_error;
395: END IF;
396: --
397: end check_contig_pds_pdp;
398: --

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

451: effective_start_date and effective_end_date
452: );
453: exception
454: when no_data_found then
455: hr_utility.set_message('801','HR_7679_EMP_SUP_PAY_NOT_EXIST');
456: hr_utility.raise_error;
457: end;
458: end if;
459: if l_supervisor_id is not null then

Line 456: hr_utility.raise_error;

452: );
453: exception
454: when no_data_found then
455: hr_utility.set_message('801','HR_7679_EMP_SUP_PAY_NOT_EXIST');
456: hr_utility.raise_error;
457: end;
458: end if;
459: if l_supervisor_id is not null then
460: begin

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

468: effective_start_date and effective_end_date
469: );
470: exception
471: when no_data_found then
472: hr_utility.set_message('801','HR_7680_EMP_SUP_PAY_NOT_EXIST');
473: hr_utility.raise_error;
474: end;
475: end if;
476: --

Line 473: hr_utility.raise_error;

469: );
470: exception
471: when no_data_found then
472: hr_utility.set_message('801','HR_7680_EMP_SUP_PAY_NOT_EXIST');
473: hr_utility.raise_error;
474: end;
475: end if;
476: --
477: end check_supe_pay;

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

546: open csr_sp_placement_pds;
547: fetch csr_sp_placement_pds into l_dummy;
548: if csr_sp_placement_pds%found then
549: close csr_sp_placement_pds;
550: hr_utility.set_message(801,'HR_6837_EMP_REF_DATE_CHG');
551: hr_utility.raise_error;
552: else
553: close csr_sp_placement_pds;
554: end if;

Line 551: hr_utility.raise_error;

547: fetch csr_sp_placement_pds into l_dummy;
548: if csr_sp_placement_pds%found then
549: close csr_sp_placement_pds;
550: hr_utility.set_message(801,'HR_6837_EMP_REF_DATE_CHG');
551: hr_utility.raise_error;
552: else
553: close csr_sp_placement_pds;
554: end if;
555: elsif p_type = 'C' then

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

556: open csr_sp_placement_pdp;
557: fetch csr_sp_placement_pdp into l_dummy;
558: if csr_sp_placement_pdp%found then
559: close csr_sp_placement_pdp;
560: hr_utility.set_message(801,'HR_6837_EMP_REF_DATE_CHG');
561: hr_utility.raise_error;
562: else
563: close csr_sp_placement_pdp;
564: end if;

Line 561: hr_utility.raise_error;

557: fetch csr_sp_placement_pdp into l_dummy;
558: if csr_sp_placement_pdp%found then
559: close csr_sp_placement_pdp;
560: hr_utility.set_message(801,'HR_6837_EMP_REF_DATE_CHG');
561: hr_utility.raise_error;
562: else
563: close csr_sp_placement_pdp;
564: end if;
565: else

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

611: open csr_asg_rates_pdp;
612: fetch csr_asg_rates_pdp into l_dummy;
613: if csr_asg_rates_pdp%found then
614: close csr_asg_rates_pdp;
615: hr_utility.set_message(801,'PER_289851_CWK_ASG_RATE_EXISTS');
616: hr_utility.raise_error;
617: else
618: close csr_asg_rates_pdp;
619: end if;

Line 616: hr_utility.raise_error;

612: fetch csr_asg_rates_pdp into l_dummy;
613: if csr_asg_rates_pdp%found then
614: close csr_asg_rates_pdp;
615: hr_utility.set_message(801,'PER_289851_CWK_ASG_RATE_EXISTS');
616: hr_utility.raise_error;
617: else
618: close csr_asg_rates_pdp;
619: end if;
620: else

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

692: open csr_cost_pds;
693: fetch csr_cost_pds into l_dummy;
694: if csr_cost_pds%found then
695: close csr_cost_pds;
696: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
697: hr_utility.raise_error;
698: else
699: close csr_cost_pds;
700: end if;

Line 697: hr_utility.raise_error;

693: fetch csr_cost_pds into l_dummy;
694: if csr_cost_pds%found then
695: close csr_cost_pds;
696: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
697: hr_utility.raise_error;
698: else
699: close csr_cost_pds;
700: end if;
701: elsif p_type = 'C' then

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

702: open csr_cost_pdp;
703: fetch csr_cost_pdp into l_dummy;
704: if csr_cost_pdp%found then
705: close csr_cost_pdp;
706: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
707: hr_utility.raise_error;
708: else
709: close csr_cost_pdp;
710: end if;

Line 707: hr_utility.raise_error;

703: fetch csr_cost_pdp into l_dummy;
704: if csr_cost_pdp%found then
705: close csr_cost_pdp;
706: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
707: hr_utility.raise_error;
708: else
709: close csr_cost_pdp;
710: end if;
711: else

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

783: open csr_budget_pds;
784: fetch csr_budget_pds into l_dummy;
785: if csr_budget_pds%found then
786: close csr_budget_pds;
787: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
788: hr_utility.raise_error;
789: else
790: close csr_budget_pds;
791: end if;

Line 788: hr_utility.raise_error;

784: fetch csr_budget_pds into l_dummy;
785: if csr_budget_pds%found then
786: close csr_budget_pds;
787: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
788: hr_utility.raise_error;
789: else
790: close csr_budget_pds;
791: end if;
792: elsif p_type = 'C' then

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

793: open csr_budget_pdp;
794: fetch csr_budget_pdp into l_dummy;
795: if csr_budget_pdp%found then
796: close csr_budget_pdp;
797: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
798: hr_utility.raise_error;
799: else
800: close csr_budget_pdp;
801: end if;

Line 798: hr_utility.raise_error;

794: fetch csr_budget_pdp into l_dummy;
795: if csr_budget_pdp%found then
796: close csr_budget_pdp;
797: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
798: hr_utility.raise_error;
799: else
800: close csr_budget_pdp;
801: end if;
802: else

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

846: open csr_people_change;
847: fetch csr_people_change into l_dummy;
848: if csr_people_change%found then
849: close csr_people_change;
850: hr_utility.set_message(801,'HR_6841_EMP_REF_DATE_CHG');
851: hr_utility.raise_error;
852: else
853: close csr_people_change;
854: end if;

Line 851: hr_utility.raise_error;

847: fetch csr_people_change into l_dummy;
848: if csr_people_change%found then
849: close csr_people_change;
850: hr_utility.set_message(801,'HR_6841_EMP_REF_DATE_CHG');
851: hr_utility.raise_error;
852: else
853: close csr_people_change;
854: end if;
855: end check_people_changes;

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

880: open csr_person_type_change;
881: fetch csr_person_type_change into l_dummy;
882: if csr_person_type_change%found then
883: close csr_person_type_change;
884: hr_utility.set_message(800,'PER_289306_PTU_CHG_EXISTS');
885: hr_utility.raise_error;
886: else
887: close csr_person_type_change;
888: end if;

Line 885: hr_utility.raise_error;

881: fetch csr_person_type_change into l_dummy;
882: if csr_person_type_change%found then
883: close csr_person_type_change;
884: hr_utility.set_message(800,'PER_289306_PTU_CHG_EXISTS');
885: hr_utility.raise_error;
886: else
887: close csr_person_type_change;
888: end if;
889: end check_user_person_type_changes;

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

915: open csr_asg_status;
916: fetch csr_asg_status into l_dummy;
917: if csr_asg_status%found then
918: close csr_asg_status;
919: hr_utility.set_message(801,'HR_6838_EMP_REF_DATE_CHG');
920: hr_utility.raise_error;
921: else
922: close csr_asg_status;
923: end if;

Line 920: hr_utility.raise_error;

916: fetch csr_asg_status into l_dummy;
917: if csr_asg_status%found then
918: close csr_asg_status;
919: hr_utility.set_message(801,'HR_6838_EMP_REF_DATE_CHG');
920: hr_utility.raise_error;
921: else
922: close csr_asg_status;
923: end if;
924: --

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

946: open csr_asg_change;
947: fetch csr_asg_change into l_dummy;
948: if csr_asg_change%found then
949: close csr_asg_change;
950: hr_utility.set_message(801,'HR_6839_EMP_REF_DATE_CHG');
951: hr_utility.raise_error;
952: else
953: close csr_asg_change;
954: end if;

Line 951: hr_utility.raise_error;

947: fetch csr_asg_change into l_dummy;
948: if csr_asg_change%found then
949: close csr_asg_change;
950: hr_utility.set_message(801,'HR_6839_EMP_REF_DATE_CHG');
951: hr_utility.raise_error;
952: else
953: close csr_asg_change;
954: end if;
955: --

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

978: open csr_prev_asg;
979: fetch csr_prev_asg into l_dummy;
980: if csr_prev_asg%found then
981: close csr_prev_asg;
982: hr_utility.set_message(801,'HR_6840_EMP_ENTER_PERIOD');
983: hr_utility.raise_error;
984: else
985: close csr_prev_asg;
986: end if;

Line 983: hr_utility.raise_error;

979: fetch csr_prev_asg into l_dummy;
980: if csr_prev_asg%found then
981: close csr_prev_asg;
982: hr_utility.set_message(801,'HR_6840_EMP_ENTER_PERIOD');
983: hr_utility.raise_error;
984: else
985: close csr_prev_asg;
986: end if;
987: --

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

1069: dummy varchar2(2);
1070:
1071: begin
1072:
1073: hr_utility.set_location('Entering:'|| l_proc, 10);
1074:
1075: if p_new_start_date > p_old_start_date then
1076: l_start_date := p_old_start_date;
1077: l_end_date := p_new_start_date;

Line 1092: hr_utility.set_message(800,'PER_449869_PROCD_LE_EXISTS');

1088: fetch c_ben_non_GSP into dummy;
1089:
1090: if c_ben_non_GSP%found then
1091: close c_ben_non_GSP;
1092: hr_utility.set_message(800,'PER_449869_PROCD_LE_EXISTS');
1093: hr_utility.raise_error;
1094: end if;
1095:
1096: close c_ben_non_GSP;

Line 1093: hr_utility.raise_error;

1089:
1090: if c_ben_non_GSP%found then
1091: close c_ben_non_GSP;
1092: hr_utility.set_message(800,'PER_449869_PROCD_LE_EXISTS');
1093: hr_utility.raise_error;
1094: end if;
1095:
1096: close c_ben_non_GSP;
1097:

Line 1098: hr_utility.set_location('Leaving:'|| l_proc, 10);

1094: end if;
1095:
1096: close c_ben_non_GSP;
1097:
1098: hr_utility.set_location('Leaving:'|| l_proc, 10);
1099:
1100: end check_ben_enteries;
1101: --changes end for bug 6640794
1102:

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

1178:
1179: l_proc varchar2(100):= g_package||'.update_ben_GSP_enteries';
1180: begin
1181:
1182: hr_utility.set_location('Entering:'|| l_proc, 10);
1183:
1184: if p_new_start_date > p_old_start_date then
1185: l_start_date := p_old_start_date;
1186: l_end_date := p_new_start_date;

Line 1196: hr_utility.set_location('Processing Person_id '|| P_person_id, 20);

1192: open Person_Info;
1193: fetch person_info into l_BG_id ,l_new_Enrlmt_Dt;
1194: close Person_Info;
1195:
1196: hr_utility.set_location('Processing Person_id '|| P_person_id, 20);
1197:
1198: for l_ben_ptnl_ler_GSP in c_ben_ptnl_ler_GSP(l_bg_id,l_start_date, l_end_date)
1199: loop
1200: --

Line 1222: hr_utility.set_location('Processing BEN Rate:'|| l_enrt_rt_id, 30);

1218: --
1219: l_enrt_rt_id := l_ben_enrt_rt_id.enrt_rt_id;
1220: l_enrt_rt_ovn := l_ben_enrt_rt_id.object_version_number;
1221:
1222: hr_utility.set_location('Processing BEN Rate:'|| l_enrt_rt_id, 30);
1223:
1224: ben_Enrollment_Rate_api.update_Enrollment_Rate
1225: (p_enrt_rt_id => l_enrt_rt_id
1226: ,p_rt_strt_dt => l_new_Enrlmt_Dt

Line 1232: hr_utility.set_location('Processing Electable Choice:'|| l_elig_per_elctbl_chc_id, 40);

1228: ,p_effective_date => l_new_Enrlmt_Dt);
1229: --
1230: end loop;
1231:
1232: hr_utility.set_location('Processing Electable Choice:'|| l_elig_per_elctbl_chc_id, 40);
1233:
1234: ben_elig_per_elc_chc_api.update_perf_ELIG_PER_ELC_CHC
1235: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id
1236: ,p_enrt_cvg_strt_dt => l_new_Enrlmt_Dt

Line 1243: hr_utility.set_location('Processing Person Life Event:'|| l_per_in_ler_id, 50);

1239: ,p_effective_date => l_new_Enrlmt_Dt);
1240: --
1241: end loop;
1242:
1243: hr_utility.set_location('Processing Person Life Event:'|| l_per_in_ler_id, 50);
1244:
1245: ben_person_life_event_api.update_Person_Life_Event
1246: (p_per_in_ler_id => l_per_in_ler_id
1247: ,p_lf_evt_ocrd_dt => l_new_Enrlmt_Dt

Line 1266: hr_utility.set_location('Processing Potential Person Life Event:'|| l_per_in_ler_id, 60);

1262: ,P_EFFECTIVE_DATE => l_new_Enrlmt_Dt);
1263: --
1264: end loop;
1265:
1266: hr_utility.set_location('Processing Potential Person Life Event:'|| l_per_in_ler_id, 60);
1267:
1268: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
1269: (p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id
1270: ,p_lf_evt_ocrd_dt => l_new_Enrlmt_Dt

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

1272: ,p_effective_date => l_new_Enrlmt_Dt);
1273: --
1274: end loop;
1275:
1276: hr_utility.set_location('Leaving:'|| l_proc, 100);
1277:
1278: end update_ben_GSP_enteries;
1279: -- End changes for bug 8836797
1280:

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

1311: fetch pds into pds_rec;
1312: end loop pds_loop;
1313: if pds%rowcount <>1 then
1314: close pds;
1315: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1316: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
1317: hr_utility.set_message_token('STEP','1');
1318: hr_utility.raise_error;
1319: else

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

1312: end loop pds_loop;
1313: if pds%rowcount <>1 then
1314: close pds;
1315: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1316: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
1317: hr_utility.set_message_token('STEP','1');
1318: hr_utility.raise_error;
1319: else
1320: close pds;

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

1313: if pds%rowcount <>1 then
1314: close pds;
1315: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1316: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
1317: hr_utility.set_message_token('STEP','1');
1318: hr_utility.raise_error;
1319: else
1320: close pds;
1321: end if;

Line 1318: hr_utility.raise_error;

1314: close pds;
1315: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1316: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
1317: hr_utility.set_message_token('STEP','1');
1318: hr_utility.raise_error;
1319: else
1320: close pds;
1321: end if;
1322: l_object_version_number := pds_rec.object_version_number;

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

1332: fetch pdp into pdp_rec;
1333: end loop pdp_loop;
1334: if pdp%rowcount <>1 then
1335: close pdp;
1336: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1337: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
1338: hr_utility.set_message_token('STEP','2');
1339: hr_utility.raise_error;
1340: else

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

1333: end loop pdp_loop;
1334: if pdp%rowcount <>1 then
1335: close pdp;
1336: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1337: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
1338: hr_utility.set_message_token('STEP','2');
1339: hr_utility.raise_error;
1340: else
1341: close pdp;

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

1334: if pdp%rowcount <>1 then
1335: close pdp;
1336: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1337: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
1338: hr_utility.set_message_token('STEP','2');
1339: hr_utility.raise_error;
1340: else
1341: close pdp;
1342: end if;

Line 1339: hr_utility.raise_error;

1335: close pdp;
1336: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1337: hr_utility.set_message_token('PROCEDURE','hr_change_start_date_api.update_period');
1338: hr_utility.set_message_token('STEP','2');
1339: hr_utility.raise_error;
1340: else
1341: close pdp;
1342: end if;
1343: update per_periods_of_placement

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

1378: set effective_start_date = p_new_start_date
1379: where effective_start_date = p_old_start_date
1380: and placement_id = l_sp_id;
1381: if sql%rowcount <1 then
1382: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1383: hr_utility.set_message_token('TABLE','PER_SPINAL_POINT_PLACEMENTS_F');
1384: hr_utility.raise_error;
1385: end if;
1386: end loop;

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

1379: where effective_start_date = p_old_start_date
1380: and placement_id = l_sp_id;
1381: if sql%rowcount <1 then
1382: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1383: hr_utility.set_message_token('TABLE','PER_SPINAL_POINT_PLACEMENTS_F');
1384: hr_utility.raise_error;
1385: end if;
1386: end loop;
1387: close csr_ssp;

Line 1384: hr_utility.raise_error;

1380: and placement_id = l_sp_id;
1381: if sql%rowcount <1 then
1382: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1383: hr_utility.set_message_token('TABLE','PER_SPINAL_POINT_PLACEMENTS_F');
1384: hr_utility.raise_error;
1385: end if;
1386: end loop;
1387: close csr_ssp;
1388: end update_spinal_placement;

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

1417: set effective_start_date = p_new_start_date
1418: where effective_start_date = p_old_start_date
1419: and grade_rule_id = l_pgr_id;
1420: if sql%rowcount <1 then
1421: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1422: hr_utility.set_message_token('TABLE','PAY_GRADE_RULES_F');
1423: hr_utility.raise_error;
1424: end if;
1425: end loop;

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

1418: where effective_start_date = p_old_start_date
1419: and grade_rule_id = l_pgr_id;
1420: if sql%rowcount <1 then
1421: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1422: hr_utility.set_message_token('TABLE','PAY_GRADE_RULES_F');
1423: hr_utility.raise_error;
1424: end if;
1425: end loop;
1426: close csr_rate;

Line 1423: hr_utility.raise_error;

1419: and grade_rule_id = l_pgr_id;
1420: if sql%rowcount <1 then
1421: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1422: hr_utility.set_message_token('TABLE','PAY_GRADE_RULES_F');
1423: hr_utility.raise_error;
1424: end if;
1425: end loop;
1426: close csr_rate;
1427: end update_asg_rate;

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

1455: set effective_start_date = p_new_start_date
1456: where effective_start_date = p_old_start_date
1457: and COST_ALLOCATION_ID = l_ca_id;
1458: if sql%rowcount <1 then
1459: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1460: hr_utility.set_message_token('TABLE','PAY_COST_ALLOCATIONS_F');
1461: hr_utility.raise_error;
1462: end if;
1463: end loop;

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

1456: where effective_start_date = p_old_start_date
1457: and COST_ALLOCATION_ID = l_ca_id;
1458: if sql%rowcount <1 then
1459: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1460: hr_utility.set_message_token('TABLE','PAY_COST_ALLOCATIONS_F');
1461: hr_utility.raise_error;
1462: end if;
1463: end loop;
1464: close csr_cost;

Line 1461: hr_utility.raise_error;

1457: and COST_ALLOCATION_ID = l_ca_id;
1458: if sql%rowcount <1 then
1459: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1460: hr_utility.set_message_token('TABLE','PAY_COST_ALLOCATIONS_F');
1461: hr_utility.raise_error;
1462: end if;
1463: end loop;
1464: close csr_cost;
1465: end update_cost_allocation;

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

1520: open csr_get_bg;
1521: fetch csr_get_bg into l_business_group_id;
1522: if csr_get_bg%NOTFOUND then
1523: close csr_get_bg;
1524: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1525: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1526: hr_utility.set_message_token('STEP', '1');
1527: hr_utility.raise_error;
1528: end if;

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

1521: fetch csr_get_bg into l_business_group_id;
1522: if csr_get_bg%NOTFOUND then
1523: close csr_get_bg;
1524: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1525: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1526: hr_utility.set_message_token('STEP', '1');
1527: hr_utility.raise_error;
1528: end if;
1529: close csr_get_bg;

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

1522: if csr_get_bg%NOTFOUND then
1523: close csr_get_bg;
1524: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1525: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1526: hr_utility.set_message_token('STEP', '1');
1527: hr_utility.raise_error;
1528: end if;
1529: close csr_get_bg;
1530: pay_us_emp_dt_tax_rules.default_tax_with_validation

Line 1527: hr_utility.raise_error;

1523: close csr_get_bg;
1524: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1525: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1526: hr_utility.set_message_token('STEP', '1');
1527: hr_utility.raise_error;
1528: end if;
1529: close csr_get_bg;
1530: pay_us_emp_dt_tax_rules.default_tax_with_validation
1531: (p_assignment_id => null

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

1571: where a2.assignment_id = a.assignment_id
1572: and a2.assignment_type = 'A')
1573: and a.assignment_id = l_assignment_id;
1574: if sql%rowcount <1 then
1575: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1576: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
1577: hr_utility.raise_error;
1578: end if;
1579:

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

1572: and a2.assignment_type = 'A')
1573: and a.assignment_id = l_assignment_id;
1574: if sql%rowcount <1 then
1575: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1576: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
1577: hr_utility.raise_error;
1578: end if;
1579:
1580: if per_otherbg_apl_api.isMultiRegVac(l_assignment_id) then

Line 1577: hr_utility.raise_error;

1573: and a.assignment_id = l_assignment_id;
1574: if sql%rowcount <1 then
1575: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1576: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
1577: hr_utility.raise_error;
1578: end if;
1579:
1580: if per_otherbg_apl_api.isMultiRegVac(l_assignment_id) then
1581: per_otherbg_apl_api.open_otherbg_applications(l_assignment_id,p_old_start_date - 1,'CANCEL_HIRE');

Line 1605: hr_utility.set_location('Entering update_appraisals',10);

1601: AND ( pa.appraisal_period_start_date BETWEEN p_old_date AND p_new_date OR
1602: pa.appraisal_period_end_date BETWEEN p_old_date AND p_new_date)
1603: AND pa.appraisal_system_status <> 'DELETED';
1604: BEGIN
1605: hr_utility.set_location('Entering update_appraisals',10);
1606: FOR i IN csr_appraisals(p_person_id,p_old_start_date,p_new_start_date)
1607: LOOP
1608: BEGIN
1609: hr_utility.trace('Updating: appraisal:'||i.appraisal_id);

Line 1609: hr_utility.trace('Updating: appraisal:'||i.appraisal_id);

1605: hr_utility.set_location('Entering update_appraisals',10);
1606: FOR i IN csr_appraisals(p_person_id,p_old_start_date,p_new_start_date)
1607: LOOP
1608: BEGIN
1609: hr_utility.trace('Updating: appraisal:'||i.appraisal_id);
1610: UPDATE per_appraisals
1611: SET appraisal_period_start_date = i.new_start_date,
1612: appraisal_period_end_date = i.new_end_date
1613: WHERE appraisal_id = i.appraisal_id;

Line 1614: hr_utility.trace('Updated the appraisal');

1610: UPDATE per_appraisals
1611: SET appraisal_period_start_date = i.new_start_date,
1612: appraisal_period_end_date = i.new_end_date
1613: WHERE appraisal_id = i.appraisal_id;
1614: hr_utility.trace('Updated the appraisal');
1615: EXCEPTION
1616: WHEN OTHERS THEN
1617: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1618: hr_utility.set_message_token('PROCEDURE','Update_Appraisal_Row');

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

1613: WHERE appraisal_id = i.appraisal_id;
1614: hr_utility.trace('Updated the appraisal');
1615: EXCEPTION
1616: WHEN OTHERS THEN
1617: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1618: hr_utility.set_message_token('PROCEDURE','Update_Appraisal_Row');
1619: hr_utility.set_message_token('STEP','4');
1620: hr_utility.raise_error;
1621: END;

Line 1618: hr_utility.set_message_token('PROCEDURE','Update_Appraisal_Row');

1614: hr_utility.trace('Updated the appraisal');
1615: EXCEPTION
1616: WHEN OTHERS THEN
1617: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1618: hr_utility.set_message_token('PROCEDURE','Update_Appraisal_Row');
1619: hr_utility.set_message_token('STEP','4');
1620: hr_utility.raise_error;
1621: END;
1622: END LOOP;

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

1615: EXCEPTION
1616: WHEN OTHERS THEN
1617: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1618: hr_utility.set_message_token('PROCEDURE','Update_Appraisal_Row');
1619: hr_utility.set_message_token('STEP','4');
1620: hr_utility.raise_error;
1621: END;
1622: END LOOP;
1623: hr_utility.set_location('Leaving update_appraisals',80);

Line 1620: hr_utility.raise_error;

1616: WHEN OTHERS THEN
1617: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1618: hr_utility.set_message_token('PROCEDURE','Update_Appraisal_Row');
1619: hr_utility.set_message_token('STEP','4');
1620: hr_utility.raise_error;
1621: END;
1622: END LOOP;
1623: hr_utility.set_location('Leaving update_appraisals',80);
1624: END update_appraisals;

Line 1623: hr_utility.set_location('Leaving update_appraisals',80);

1619: hr_utility.set_message_token('STEP','4');
1620: hr_utility.raise_error;
1621: END;
1622: END LOOP;
1623: hr_utility.set_location('Leaving update_appraisals',80);
1624: END update_appraisals;
1625:
1626: -- PROCEDURE update_appraisals for bug#13585228 ends here
1627: --

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

1658: and a1.person_id = peo.person_id
1659: and peo.effective_start_date = p_old_start_date
1660: and peo.current_applicant_flag = 'Y');
1661: if sql%rowcount <1 then
1662: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1663: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');
1664: hr_utility.raise_error;
1665: end if;
1666: end loop;

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

1659: and peo.effective_start_date = p_old_start_date
1660: and peo.current_applicant_flag = 'Y');
1661: if sql%rowcount <1 then
1662: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1663: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');
1664: hr_utility.raise_error;
1665: end if;
1666: end loop;
1667: close csr_apl;

Line 1664: hr_utility.raise_error;

1660: and peo.current_applicant_flag = 'Y');
1661: if sql%rowcount <1 then
1662: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1663: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');
1664: hr_utility.raise_error;
1665: end if;
1666: end loop;
1667: close csr_apl;
1668: end update_apl;

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

1723: --
1724: --
1725: l_count := 0;
1726:
1727: hr_utility.set_location('update_pay_proposal',1);
1728:
1729: open prv_pay_proposals;
1730: fetch prv_pay_proposals into l_count;
1731: hr_utility.set_location('update_pay_proposal.count = '||l_count,2);

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

1727: hr_utility.set_location('update_pay_proposal',1);
1728:
1729: open prv_pay_proposals;
1730: fetch prv_pay_proposals into l_count;
1731: hr_utility.set_location('update_pay_proposal.count = '||l_count,2);
1732:
1733: if prv_pay_proposals%FOUND then
1734: close prv_pay_proposals;
1735: else

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

1733: if prv_pay_proposals%FOUND then
1734: close prv_pay_proposals;
1735: else
1736: close prv_pay_proposals;
1737: hr_utility.set_location('update_pay_proposal',10);
1738: end if;
1739:
1740: if l_count > 1 then
1741: hr_utility.set_message('800','PER_289794_HISTORIC_SAL_PRPSL');

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

1737: hr_utility.set_location('update_pay_proposal',10);
1738: end if;
1739:
1740: if l_count > 1 then
1741: hr_utility.set_message('800','PER_289794_HISTORIC_SAL_PRPSL');
1742: hr_utility.raise_error;
1743: else
1744:
1745: open get_pay_proposal;

Line 1742: hr_utility.raise_error;

1738: end if;
1739:
1740: if l_count > 1 then
1741: hr_utility.set_message('800','PER_289794_HISTORIC_SAL_PRPSL');
1742: hr_utility.raise_error;
1743: else
1744:
1745: open get_pay_proposal;
1746: loop

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

1748: exit when get_pay_proposal%NOTFOUND;
1749: -- if get_pay_proposal%FOUND then
1750: -- close get_pay_proposal;
1751: begin
1752: hr_utility.set_location('update_pay_proposal.p_new_start_date = '||to_char(p_new_start_date,'DD-MON-YYYY'),40);
1753: hr_utility.set_location('update_pay_proposal.p_old_start_date = '||to_char(p_old_start_date,'DD-MON-YYYY'),40);
1754: hr_utility.set_location('update_pay_proposal.p_person_id = '||p_person_id,40);
1755: hr_utility.set_location('update_pay_proposal.p_type = '||p_type,40);
1756: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,40);

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

1749: -- if get_pay_proposal%FOUND then
1750: -- close get_pay_proposal;
1751: begin
1752: hr_utility.set_location('update_pay_proposal.p_new_start_date = '||to_char(p_new_start_date,'DD-MON-YYYY'),40);
1753: hr_utility.set_location('update_pay_proposal.p_old_start_date = '||to_char(p_old_start_date,'DD-MON-YYYY'),40);
1754: hr_utility.set_location('update_pay_proposal.p_person_id = '||p_person_id,40);
1755: hr_utility.set_location('update_pay_proposal.p_type = '||p_type,40);
1756: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,40);
1757: --

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

1750: -- close get_pay_proposal;
1751: begin
1752: hr_utility.set_location('update_pay_proposal.p_new_start_date = '||to_char(p_new_start_date,'DD-MON-YYYY'),40);
1753: hr_utility.set_location('update_pay_proposal.p_old_start_date = '||to_char(p_old_start_date,'DD-MON-YYYY'),40);
1754: hr_utility.set_location('update_pay_proposal.p_person_id = '||p_person_id,40);
1755: hr_utility.set_location('update_pay_proposal.p_type = '||p_type,40);
1756: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,40);
1757: --
1758: update per_pay_proposals

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

1751: begin
1752: hr_utility.set_location('update_pay_proposal.p_new_start_date = '||to_char(p_new_start_date,'DD-MON-YYYY'),40);
1753: hr_utility.set_location('update_pay_proposal.p_old_start_date = '||to_char(p_old_start_date,'DD-MON-YYYY'),40);
1754: hr_utility.set_location('update_pay_proposal.p_person_id = '||p_person_id,40);
1755: hr_utility.set_location('update_pay_proposal.p_type = '||p_type,40);
1756: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,40);
1757: --
1758: update per_pay_proposals
1759: set change_date = p_new_start_date

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

1752: hr_utility.set_location('update_pay_proposal.p_new_start_date = '||to_char(p_new_start_date,'DD-MON-YYYY'),40);
1753: hr_utility.set_location('update_pay_proposal.p_old_start_date = '||to_char(p_old_start_date,'DD-MON-YYYY'),40);
1754: hr_utility.set_location('update_pay_proposal.p_person_id = '||p_person_id,40);
1755: hr_utility.set_location('update_pay_proposal.p_type = '||p_type,40);
1756: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,40);
1757: --
1758: update per_pay_proposals
1759: set change_date = p_new_start_date
1760: where change_date = p_old_start_date

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

1766: and primary_flag = 'Y'
1767: and effective_start_date = p_new_start_date
1768: and assignment_type = p_type);
1769: */
1770: hr_utility.set_location('update_pay_proposal',50);
1771: if sql%ROWCOUNT <> 1 then
1772: raise NO_DATA_FOUND;
1773: end if;
1774: exception

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

1772: raise NO_DATA_FOUND;
1773: end if;
1774: exception
1775: when NO_DATA_FOUND then
1776: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1777: hr_utility.set_message_token('PROCEDURE','Update_row');
1778: hr_utility.set_message_token('STEP','4');
1779: hr_utility.raise_error;
1780: end;

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

1773: end if;
1774: exception
1775: when NO_DATA_FOUND then
1776: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1777: hr_utility.set_message_token('PROCEDURE','Update_row');
1778: hr_utility.set_message_token('STEP','4');
1779: hr_utility.raise_error;
1780: end;
1781: -- else

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

1774: exception
1775: when NO_DATA_FOUND then
1776: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1777: hr_utility.set_message_token('PROCEDURE','Update_row');
1778: hr_utility.set_message_token('STEP','4');
1779: hr_utility.raise_error;
1780: end;
1781: -- else
1782: -- null;

Line 1779: hr_utility.raise_error;

1775: when NO_DATA_FOUND then
1776: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1777: hr_utility.set_message_token('PROCEDURE','Update_row');
1778: hr_utility.set_message_token('STEP','4');
1779: hr_utility.raise_error;
1780: end;
1781: -- else
1782: -- null;
1783: -- end if;

Line 1794: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,60);

1790: fetch get_updtd_proposal_rows into l_pay_proposal_id;
1791: exit when get_updtd_proposal_rows%NOTFOUND;
1792:
1793: BEGIN
1794: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,60);
1795: --
1796: update per_pay_proposals
1797: set last_change_date = p_new_start_date
1798: where last_change_date = p_old_start_date

Line 1801: hr_utility.set_location('update_pay_proposal',70);

1797: set last_change_date = p_new_start_date
1798: where last_change_date = p_old_start_date
1799: and pay_proposal_id = l_pay_proposal_id;
1800:
1801: hr_utility.set_location('update_pay_proposal',70);
1802:
1803: if sql%ROWCOUNT <> 1 then
1804: raise NO_DATA_FOUND;
1805: end if;

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

1804: raise NO_DATA_FOUND;
1805: end if;
1806: exception
1807: when NO_DATA_FOUND then
1808: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1809: hr_utility.set_message_token('PROCEDURE','Update_row');
1810: hr_utility.set_message_token('STEP','4');
1811: hr_utility.raise_error;
1812: end;

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

1805: end if;
1806: exception
1807: when NO_DATA_FOUND then
1808: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1809: hr_utility.set_message_token('PROCEDURE','Update_row');
1810: hr_utility.set_message_token('STEP','4');
1811: hr_utility.raise_error;
1812: end;
1813: end loop;

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

1806: exception
1807: when NO_DATA_FOUND then
1808: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1809: hr_utility.set_message_token('PROCEDURE','Update_row');
1810: hr_utility.set_message_token('STEP','4');
1811: hr_utility.raise_error;
1812: end;
1813: end loop;
1814: close get_updtd_proposal_rows;

Line 1811: hr_utility.raise_error;

1807: when NO_DATA_FOUND then
1808: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
1809: hr_utility.set_message_token('PROCEDURE','Update_row');
1810: hr_utility.set_message_token('STEP','4');
1811: hr_utility.raise_error;
1812: end;
1813: end loop;
1814: close get_updtd_proposal_rows;
1815: -- end changes for bug 8267359

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

1848: open csr_get_bg;
1849: fetch csr_get_bg into l_business_group_id;
1850: if csr_get_bg%NOTFOUND then
1851: close csr_get_bg;
1852: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1853: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1854: hr_utility.set_message_token('STEP', '1');
1855: hr_utility.raise_error;
1856: end if;

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

1849: fetch csr_get_bg into l_business_group_id;
1850: if csr_get_bg%NOTFOUND then
1851: close csr_get_bg;
1852: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1853: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1854: hr_utility.set_message_token('STEP', '1');
1855: hr_utility.raise_error;
1856: end if;
1857: close csr_get_bg;

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

1850: if csr_get_bg%NOTFOUND then
1851: close csr_get_bg;
1852: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1853: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1854: hr_utility.set_message_token('STEP', '1');
1855: hr_utility.raise_error;
1856: end if;
1857: close csr_get_bg;
1858: -- Set the correct validation start and end dates for

Line 1855: hr_utility.raise_error;

1851: close csr_get_bg;
1852: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1853: hr_utility.set_message_token('PROCEDURE', 'hr_change_start_date_api.update_tax');
1854: hr_utility.set_message_token('STEP', '1');
1855: hr_utility.raise_error;
1856: end if;
1857: close csr_get_bg;
1858: -- Set the correct validation start and end dates for
1859: -- the assignments. These are the same for all

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

1967: --
1968: --
1969: BEGIN
1970: --
1971: hr_utility.set_location('Entering:'|| l_proc, 10);
1972: l_new_effective_date := p_new_effective_date;
1973: l_new_start_date := p_new_effective_date;
1974:
1975: FOR assignment_rec in csr_assignments(p_person_id, p_new_effective_date) LOOP

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

1976: --
1977: -- for each Assignment of Person loop through.
1978: --
1979: l_assignment_id := assignment_rec.assignment_id;
1980: hr_utility.set_location('Assignment ID: '||l_assignment_id, 20);
1981: --
1982: -- Get old probation details.
1983: --
1984: open csr_probation_details(l_assignment_id, p_new_effective_date);

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

1983: --
1984: open csr_probation_details(l_assignment_id, p_new_effective_date);
1985: fetch csr_probation_details into l_date_probation_end1, l_probation_period1, l_probation_unit1;
1986: close csr_probation_details;
1987: hr_utility.set_location('Old probation details: ', 30);
1988: hr_utility.set_location('date_probation_end:'||l_date_probation_end1, 30);
1989: hr_utility.set_location('probation_period: '||l_probation_period1, 30);
1990: hr_utility.set_location('probation_unit : '||l_probation_unit1, 30);
1991: --

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

1984: open csr_probation_details(l_assignment_id, p_new_effective_date);
1985: fetch csr_probation_details into l_date_probation_end1, l_probation_period1, l_probation_unit1;
1986: close csr_probation_details;
1987: hr_utility.set_location('Old probation details: ', 30);
1988: hr_utility.set_location('date_probation_end:'||l_date_probation_end1, 30);
1989: hr_utility.set_location('probation_period: '||l_probation_period1, 30);
1990: hr_utility.set_location('probation_unit : '||l_probation_unit1, 30);
1991: --
1992: l_new_date_probation_end := null;

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

1985: fetch csr_probation_details into l_date_probation_end1, l_probation_period1, l_probation_unit1;
1986: close csr_probation_details;
1987: hr_utility.set_location('Old probation details: ', 30);
1988: hr_utility.set_location('date_probation_end:'||l_date_probation_end1, 30);
1989: hr_utility.set_location('probation_period: '||l_probation_period1, 30);
1990: hr_utility.set_location('probation_unit : '||l_probation_unit1, 30);
1991: --
1992: l_new_date_probation_end := null;
1993: --

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

1986: close csr_probation_details;
1987: hr_utility.set_location('Old probation details: ', 30);
1988: hr_utility.set_location('date_probation_end:'||l_date_probation_end1, 30);
1989: hr_utility.set_location('probation_period: '||l_probation_period1, 30);
1990: hr_utility.set_location('probation_unit : '||l_probation_unit1, 30);
1991: --
1992: l_new_date_probation_end := null;
1993: --
1994: -- Get new probation end date.

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

2009: -- then update the probation end date of this asg update.
2010: --
2011: l_effective_start_date := asg_update_rec.effective_start_date;
2012: --
2013: hr_utility.set_location('Assignment ID: '||l_assignment_id, 40);
2014: hr_utility.set_location('Effective start date.: '||l_effective_start_date, 40);
2015: --
2016: open csr_probation_details(l_assignment_id, l_effective_start_date);
2017: fetch csr_probation_details into l_date_probation_end, l_probation_period, l_probation_unit;

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

2010: --
2011: l_effective_start_date := asg_update_rec.effective_start_date;
2012: --
2013: hr_utility.set_location('Assignment ID: '||l_assignment_id, 40);
2014: hr_utility.set_location('Effective start date.: '||l_effective_start_date, 40);
2015: --
2016: open csr_probation_details(l_assignment_id, l_effective_start_date);
2017: fetch csr_probation_details into l_date_probation_end, l_probation_period, l_probation_unit;
2018: if csr_probation_details%found then

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

2021: or (l_probation_period <> l_probation_period1)
2022: or (l_probation_unit <> l_probation_unit1) then
2023: --
2024: null;
2025: hr_utility.set_location('date probation end is not updated', 50);
2026: --
2027: else
2028: --
2029: hr_utility.set_location('date probation end is updated', 60);

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

2025: hr_utility.set_location('date probation end is not updated', 50);
2026: --
2027: else
2028: --
2029: hr_utility.set_location('date probation end is updated', 60);
2030: update per_assignments_f paf
2031: set paf.date_probation_end = l_new_date_probation_end
2032: where paf.assignment_id = l_assignment_id
2033: and paf.effective_start_date = l_effective_start_date;

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

2042:
2043: --
2044: END LOOP;
2045: --
2046: hr_utility.set_location('Leaving:'|| l_proc, 90);
2047: --
2048: END UPDATE_PROBATION_END;
2049: --
2050: -- Bug 2614732 ends here.

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

2075: open csr_extra_details;
2076: fetch csr_extra_details into l_dummy;
2077: if csr_extra_details%found then
2078: close csr_extra_details;
2079: hr_utility.set_message(800,'PER_449500_EXTRA_SER_DET_EXIST');
2080: hr_utility.raise_error;
2081: end if;
2082: close csr_extra_details;
2083: --

Line 2080: hr_utility.raise_error;

2076: fetch csr_extra_details into l_dummy;
2077: if csr_extra_details%found then
2078: close csr_extra_details;
2079: hr_utility.set_message(800,'PER_449500_EXTRA_SER_DET_EXIST');
2080: hr_utility.raise_error;
2081: end if;
2082: close csr_extra_details;
2083: --
2084: end check_extra_details_of_service;

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

2118: BEGIN
2119: --
2120: -- Check if the affected assignments have any Grade ladder.
2121: --
2122: hr_utility.set_location('Entering :'||l_proc, 10);
2123: --
2124: FOR asg_rec in csr_asg_records LOOP
2125: --
2126: -- Check the grade ladder is valid after the start date is moved.

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

2124: FOR asg_rec in csr_asg_records LOOP
2125: --
2126: -- Check the grade ladder is valid after the start date is moved.
2127: --
2128: hr_utility.set_location('Entering :'||l_proc, 20);
2129: --
2130: open csr_is_pgm_valid(asg_rec.GRADE_LADDER_PGM_ID);
2131: fetch csr_is_pgm_valid into l_dummy;
2132: IF csr_is_pgm_valid%NOTFOUND THEN

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

2134: -- The grade ladder is invalid on the new start date.
2135: --
2136: close csr_is_pgm_valid;
2137: --
2138: hr_utility.set_message (800,'HR_449567_USD_INVALID_PGM');
2139: hr_utility.raise_error;
2140: --
2141: END IF;
2142: --

Line 2139: hr_utility.raise_error;

2135: --
2136: close csr_is_pgm_valid;
2137: --
2138: hr_utility.set_message (800,'HR_449567_USD_INVALID_PGM');
2139: hr_utility.raise_error;
2140: --
2141: END IF;
2142: --
2143: hr_utility.set_location('Entering :'||l_proc, 30);

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

2139: hr_utility.raise_error;
2140: --
2141: END IF;
2142: --
2143: hr_utility.set_location('Entering :'||l_proc, 30);
2144: --
2145: close csr_is_pgm_valid;
2146: --
2147: END LOOP;

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

2145: close csr_is_pgm_valid;
2146: --
2147: END LOOP;
2148: --
2149: hr_utility.set_location('Leaving :'||l_proc, 100);
2150: --
2151: END check_grade_ladder;
2152: --
2153: -- ----------------------------------------------------------------------------

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

2491: l_system_person_type per_person_types.system_person_type%TYPE;
2492: l_warn_ee varchar2(1) := 'N';
2493: --
2494: begin
2495: hr_utility.set_location('Entering:'|| l_proc, 10);
2496: --
2497: -- Check mandatory parameters have been set
2498: --
2499: hr_api.mandatory_arg_error

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

2537: fetch csr_pdp into l_pds_or_pdp_id;
2538: close csr_pdp;
2539: l_system_person_type := 'CWK';
2540: else
2541: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
2542: hr_utility.set_message_token('PROCEDURE','update_start_date');
2543: hr_utility.set_message_token('STEP','1');
2544: hr_utility.raise_error;
2545: end if;

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

2538: close csr_pdp;
2539: l_system_person_type := 'CWK';
2540: else
2541: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
2542: hr_utility.set_message_token('PROCEDURE','update_start_date');
2543: hr_utility.set_message_token('STEP','1');
2544: hr_utility.raise_error;
2545: end if;
2546: hr_utility.set_location(l_proc, 20);

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

2539: l_system_person_type := 'CWK';
2540: else
2541: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
2542: hr_utility.set_message_token('PROCEDURE','update_start_date');
2543: hr_utility.set_message_token('STEP','1');
2544: hr_utility.raise_error;
2545: end if;
2546: hr_utility.set_location(l_proc, 20);
2547: --

Line 2544: hr_utility.raise_error;

2540: else
2541: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
2542: hr_utility.set_message_token('PROCEDURE','update_start_date');
2543: hr_utility.set_message_token('STEP','1');
2544: hr_utility.raise_error;
2545: end if;
2546: hr_utility.set_location(l_proc, 20);
2547: --
2548: -- Call Before Process User Hook

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

2542: hr_utility.set_message_token('PROCEDURE','update_start_date');
2543: hr_utility.set_message_token('STEP','1');
2544: hr_utility.raise_error;
2545: end if;
2546: hr_utility.set_location(l_proc, 20);
2547: --
2548: -- Call Before Process User Hook
2549: --
2550: begin

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

2597: --
2598: IF l_old_start_date = l_new_start_date then
2599: --
2600: NULL; -- do nothing as hire dates have not actually changed.
2601: hr_utility.set_location(l_proc, 25);
2602: --
2603: ELSE
2604: --
2605: check_not_supervisor(p_person_id => p_person_id

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

2605: check_not_supervisor(p_person_id => p_person_id
2606: ,p_new_start_date => l_new_start_date
2607: ,p_old_start_date => l_old_start_date
2608: );
2609: hr_utility.set_location(l_proc, 30);
2610: --
2611: check_pds_pdp(p_person_id => p_person_id
2612: ,p_new_start_date => l_new_start_date
2613: ,p_old_start_date => l_old_start_date

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

2612: ,p_new_start_date => l_new_start_date
2613: ,p_old_start_date => l_old_start_date
2614: ,p_type => p_update_type
2615: );
2616: hr_utility.set_location(l_proc, 40);
2617: --
2618: check_un_ended_pds_pdp(p_person_id => p_person_id
2619: ,p_new_start_date => l_new_start_date
2620: --

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

2629: -- 115.30 (END)
2630: --
2631: ,p_type => p_update_type
2632: );
2633: hr_utility.set_location(l_proc, 45);
2634: check_contig_pds_pdp(p_person_id => p_person_id
2635: ,p_old_start_date => l_old_start_date
2636: ,p_type => p_update_type);
2637: hr_utility.set_location(l_proc, 50);

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

2633: hr_utility.set_location(l_proc, 45);
2634: check_contig_pds_pdp(p_person_id => p_person_id
2635: ,p_old_start_date => l_old_start_date
2636: ,p_type => p_update_type);
2637: hr_utility.set_location(l_proc, 50);
2638: --
2639: check_supe_pay(p_pds_or_pdp_id => l_pds_or_pdp_id
2640: ,p_new_start_date => l_new_start_date
2641: ,p_type => p_update_type);

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

2638: --
2639: check_supe_pay(p_pds_or_pdp_id => l_pds_or_pdp_id
2640: ,p_new_start_date => l_new_start_date
2641: ,p_type => p_update_type);
2642: hr_utility.set_location(l_proc, 60);
2643: --
2644: -- Fix for bug 3972548 starts here.
2645: --
2646: check_grade_ladder(p_person_id

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

2646: check_grade_ladder(p_person_id
2647: ,l_old_start_date
2648: ,l_new_start_date);
2649: --
2650: hr_utility.set_location(l_proc, 65);
2651: --
2652: -- Fix for bug 3972548 ends here.
2653: --
2654: if l_new_start_date > l_old_start_date then

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

2683: check_for_compl_actions(p_person_id => p_person_id
2684: ,p_old_start_date => l_old_start_date
2685: ,p_new_start_date => l_new_start_date
2686: ,p_type => p_update_type);
2687: hr_utility.set_location(l_proc, 70);
2688: --
2689: -- 115.30 (START)
2690: --
2691: else

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

2697: ,p_old_start_date => l_old_start_date
2698: ,p_new_start_date => l_new_start_date
2699: ,p_type => p_update_type);
2700: --
2701: hr_utility.set_location(l_proc, 75);
2702: end if;
2703: --
2704: -- 115.30 (END)
2705: --

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

2707: check_sp_placements(p_person_id => p_person_id
2708: ,p_pds_or_pdp_id => l_pds_or_pdp_id
2709: ,p_new_start_date => l_new_start_date
2710: ,p_type => p_update_type);
2711: hr_utility.set_location(l_proc, 80);
2712: --
2713: check_asg_rates(p_person_id => p_person_id
2714: ,p_pds_or_pdp_id => l_pds_or_pdp_id
2715: ,p_new_start_date => l_new_start_date

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

2713: check_asg_rates(p_person_id => p_person_id
2714: ,p_pds_or_pdp_id => l_pds_or_pdp_id
2715: ,p_new_start_date => l_new_start_date
2716: ,p_type => p_update_type);
2717: hr_utility.set_location(l_proc, 85);
2718: --
2719: check_cost_allocation(p_person_id => p_person_id
2720: ,p_pds_or_pdp_id => l_pds_or_pdp_id
2721: ,p_new_start_date => l_new_start_date

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

2719: check_cost_allocation(p_person_id => p_person_id
2720: ,p_pds_or_pdp_id => l_pds_or_pdp_id
2721: ,p_new_start_date => l_new_start_date
2722: ,p_type => p_update_type);
2723: hr_utility.set_location(l_proc, 90);
2724: --
2725: check_budget_values(p_person_id => p_person_id
2726: ,p_pds_or_pdp_id => l_pds_or_pdp_id
2727: ,p_new_start_date => l_new_start_date

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

2725: check_budget_values(p_person_id => p_person_id
2726: ,p_pds_or_pdp_id => l_pds_or_pdp_id
2727: ,p_new_start_date => l_new_start_date
2728: ,p_type => p_update_type);
2729: hr_utility.set_location(l_proc, 95);
2730: --
2731: check_people_changes(p_person_id => p_person_id
2732: ,p_earlier_date => l_earlier_date
2733: ,p_later_date => l_later_date

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

2731: check_people_changes(p_person_id => p_person_id
2732: ,p_earlier_date => l_earlier_date
2733: ,p_later_date => l_later_date
2734: ,p_old_start_date => l_old_start_date);
2735: hr_utility.set_location(l_proc, 100);
2736: --
2737: check_asg_st_change(p_person_id => p_person_id
2738: ,p_earlier_date => l_earlier_date
2739: ,p_later_date => l_later_date

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

2738: ,p_earlier_date => l_earlier_date
2739: ,p_later_date => l_later_date
2740: ,p_type => p_update_type
2741: ,p_old_start_date => l_old_start_date);
2742: hr_utility.set_location(l_proc, 110);
2743: --
2744: check_asg_change(p_person_id => p_person_id
2745: ,p_earlier_date => l_earlier_date
2746: ,p_later_date => l_later_date

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

2752: check_user_person_type_changes(p_person_id => p_person_id
2753: ,p_earlier_date => l_earlier_date
2754: ,p_later_date => l_later_date
2755: ,p_old_start_date => l_old_start_date);
2756: hr_utility.set_location(l_proc, 115);
2757: --
2758: -- Fix for bug 3738058 starts here.
2759: --
2760: check_extra_details_of_service(p_person_id => p_person_id

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

2760: check_extra_details_of_service(p_person_id => p_person_id
2761: ,p_old_start_date => l_old_start_date
2762: ,p_new_start_date => l_new_start_date);
2763: --
2764: hr_utility.set_location(l_proc, 117);
2765: --
2766: -- Fix for bug 3738058 ends here.
2767: --
2768: else

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

2772: check_people_changes(p_person_id => p_person_id
2773: ,p_earlier_date => l_earlier_date
2774: ,p_later_date => l_later_date
2775: ,p_old_start_date => l_old_start_date);
2776: hr_utility.set_location(l_proc, 120);
2777: --
2778: check_asg_change(p_person_id => p_person_id
2779: ,p_earlier_date => l_earlier_date
2780: ,p_later_date => l_later_date

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

2778: check_asg_change(p_person_id => p_person_id
2779: ,p_earlier_date => l_earlier_date
2780: ,p_later_date => l_later_date
2781: ,p_old_start_date => l_old_start_date);
2782: hr_utility.set_location(l_proc, 130);
2783: --
2784: check_prev_asg(p_person_id => p_person_id
2785: ,p_type => p_update_type
2786: ,p_old_start_date => l_old_start_date

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

2784: check_prev_asg(p_person_id => p_person_id
2785: ,p_type => p_update_type
2786: ,p_old_start_date => l_old_start_date
2787: ,p_new_start_date => l_new_start_date);
2788: hr_utility.set_location(l_proc, 140);
2789: --
2790: end if;
2791: --
2792: check_recur_ee(p_person_id => p_person_id

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

2792: check_recur_ee(p_person_id => p_person_id
2793: ,p_new_start_date => l_new_start_date
2794: ,p_old_start_date => l_old_start_date
2795: ,p_warn_raise => l_warn_ee);
2796: hr_utility.set_location(l_proc, 150);
2797: --
2798: --changes start for bug 6640794
2799:
2800: check_ben_enteries(p_person_id => p_person_id

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

2815: ,p.original_date_of_hire = decode(p.original_date_of_hire
2816: ,l_old_start_date, l_new_start_date,p.original_date_of_hire)
2817: where p.person_id = p_person_id;
2818: if sql%rowcount <1 then
2819: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2820: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');
2821: hr_utility.raise_error;
2822: end if;
2823: --

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

2816: ,l_old_start_date, l_new_start_date,p.original_date_of_hire)
2817: where p.person_id = p_person_id;
2818: if sql%rowcount <1 then
2819: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2820: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');
2821: hr_utility.raise_error;
2822: end if;
2823: --
2824: update per_people_f p

Line 2821: hr_utility.raise_error;

2817: where p.person_id = p_person_id;
2818: if sql%rowcount <1 then
2819: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2820: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');
2821: hr_utility.raise_error;
2822: end if;
2823: --
2824: update per_people_f p
2825: set p.start_date = (select min(ppf.effective_start_date)

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

2832: update_period(p_person_id => p_person_id
2833: ,p_old_start_date => l_old_start_date
2834: ,p_new_start_date => l_new_start_date
2835: ,p_type => p_update_type);
2836: hr_utility.set_location(l_proc, 160);
2837: --
2838: -- Update the addresses that start at the old hire date
2839: -- Providing that addresses end date either equal to new start date or greater than it.
2840: --

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

2851: end if;
2852: --bug#9266457
2853:
2854: --
2855: hr_utility.set_location(l_proc, 170);
2856: --
2857: select greatest(max(o.effective_start_date),l_new_start_date)
2858: into l_ppm_start_date
2859: from pay_org_payment_methods_f o

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

2879: where p.assignment_id = a.assignment_id
2880: and a.assignment_type = p_update_type
2881: and a.person_id = p_person_id);
2882: --
2883: hr_utility.set_location(l_proc, 180);
2884: --
2885: update_spinal_placement(p_person_id => p_person_id
2886: ,p_old_start_date => l_old_start_date
2887: ,p_new_start_date => l_new_start_date

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

2885: update_spinal_placement(p_person_id => p_person_id
2886: ,p_old_start_date => l_old_start_date
2887: ,p_new_start_date => l_new_start_date
2888: ,p_type => p_update_type);
2889: hr_utility.set_location(l_proc, 190);
2890: --
2891: update_asg_rate(p_person_id => p_person_id
2892: ,p_old_start_date => l_old_start_date
2893: ,p_new_start_date => l_new_start_date

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

2891: update_asg_rate(p_person_id => p_person_id
2892: ,p_old_start_date => l_old_start_date
2893: ,p_new_start_date => l_new_start_date
2894: ,p_type => p_update_type);
2895: hr_utility.set_location(l_proc, 190);
2896: --
2897: update_cost_allocation(p_person_id => p_person_id
2898: ,p_old_start_date => l_old_start_date
2899: ,p_new_start_date => l_new_start_date

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

2897: update_cost_allocation(p_person_id => p_person_id
2898: ,p_old_start_date => l_old_start_date
2899: ,p_new_start_date => l_new_start_date
2900: ,p_type => p_update_type);
2901: hr_utility.set_location(l_proc, 200);
2902: --
2903: update_asg_budget(p_person_id => p_person_id
2904: ,p_old_start_date => l_old_start_date
2905: ,p_new_start_date => l_new_start_date

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

2903: update_asg_budget(p_person_id => p_person_id
2904: ,p_old_start_date => l_old_start_date
2905: ,p_new_start_date => l_new_start_date
2906: ,p_type => p_update_type);
2907: hr_utility.set_location(l_proc, 210);
2908: -- Added call to update_appraisal procedure for bug#13585228
2909: update_appraisals(p_person_id => p_person_id
2910: ,p_old_start_date => l_old_start_date
2911: ,p_new_start_date => l_new_start_date);

Line 2913: hr_utility.set_location(l_proc, 211);

2909: update_appraisals(p_person_id => p_person_id
2910: ,p_old_start_date => l_old_start_date
2911: ,p_new_start_date => l_new_start_date);
2912:
2913: hr_utility.set_location(l_proc, 211);
2914:
2915: -- Closing Changes for bug#13585228
2916: --
2917: --first update ALL matching cases of the period_of_placement_date_start for integrity

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

2922: where a.period_of_placement_date_start = l_old_start_date
2923: and a.assignment_type = p_update_type
2924: and a.person_id = p_person_id;
2925: if sql%rowcount <1 then
2926: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2927: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2928: hr_utility.raise_error;
2929: end if;
2930: end if;

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

2923: and a.assignment_type = p_update_type
2924: and a.person_id = p_person_id;
2925: if sql%rowcount <1 then
2926: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2927: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2928: hr_utility.raise_error;
2929: end if;
2930: end if;
2931: --

Line 2928: hr_utility.raise_error;

2924: and a.person_id = p_person_id;
2925: if sql%rowcount <1 then
2926: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2927: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2928: hr_utility.raise_error;
2929: end if;
2930: end if;
2931: --
2932: update per_assignments_f a

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

2934: where a.effective_start_date = l_old_start_date
2935: and a.assignment_type = p_update_type
2936: and a.person_id = p_person_id;
2937: if sql%rowcount <1 then
2938: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2939: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2940: hr_utility.raise_error;
2941: end if;
2942: --

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

2935: and a.assignment_type = p_update_type
2936: and a.person_id = p_person_id;
2937: if sql%rowcount <1 then
2938: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2939: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2940: hr_utility.raise_error;
2941: end if;
2942: --
2943: -- 115.32 115.34 (START)

Line 2940: hr_utility.raise_error;

2936: and a.person_id = p_person_id;
2937: if sql%rowcount <1 then
2938: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
2939: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
2940: hr_utility.raise_error;
2941: end if;
2942: --
2943: -- 115.32 115.34 (START)
2944: --

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

2964: update_probation_end( p_person_id, l_new_start_date);
2965: --
2966: -- Bug 2614732 ends here.
2967: --
2968: hr_utility.set_location(l_proc, 220);
2969: --
2970: -- Fix for bug 3738058 starts here.
2971: --
2972: update pqp_assignment_attributes_f paa

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

2983: hr_contract_api.maintain_contracts
2984: (p_person_id => p_person_id
2985: ,p_new_start_date => l_new_start_date
2986: ,p_old_start_date => l_old_start_date);
2987: hr_utility.set_location(l_proc, 230);
2988: --
2989: update_tax(p_person_id => p_person_id
2990: ,p_new_start_date => l_new_start_date);
2991: hr_utility.set_location(l_proc, 240);

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

2987: hr_utility.set_location(l_proc, 230);
2988: --
2989: update_tax(p_person_id => p_person_id
2990: ,p_new_start_date => l_new_start_date);
2991: hr_utility.set_location(l_proc, 240);
2992: --
2993: if p_applicant_number is not null then
2994: update_apl_asg(p_person_id => p_person_id
2995: ,p_old_start_date => l_old_start_date

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

2993: if p_applicant_number is not null then
2994: update_apl_asg(p_person_id => p_person_id
2995: ,p_old_start_date => l_old_start_date
2996: ,p_new_start_date => l_new_start_date);
2997: hr_utility.set_location(l_proc, 250);
2998: --
2999: update_apl(p_person_id => p_person_id
3000: ,p_old_start_date => l_old_start_date
3001: ,p_new_start_date => l_new_start_date);

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

2998: --
2999: update_apl(p_person_id => p_person_id
3000: ,p_old_start_date => l_old_start_date
3001: ,p_new_start_date => l_new_start_date);
3002: hr_utility.set_location(l_proc, 260);
3003: --
3004: end if;
3005: --
3006: hr_utility.set_location(l_proc, 270);

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

3002: hr_utility.set_location(l_proc, 260);
3003: --
3004: end if;
3005: --
3006: hr_utility.set_location(l_proc, 270);
3007: --
3008: hr_per_type_usage_internal.change_hire_date_ptu
3009: (p_date_start => l_new_start_date
3010: ,p_old_date_start => l_old_start_date

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

3010: ,p_old_date_start => l_old_start_date
3011: ,p_person_id => p_person_id
3012: ,p_system_person_type => l_system_person_type
3013: );
3014: hr_utility.set_location(l_proc, 280);
3015: --
3016: update_pay_proposal(p_person_id => p_person_id
3017: ,p_old_start_date => l_old_start_date
3018: ,p_new_start_date => l_new_start_date

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

3016: update_pay_proposal(p_person_id => p_person_id
3017: ,p_old_start_date => l_old_start_date
3018: ,p_new_start_date => l_new_start_date
3019: ,p_type => p_update_type);
3020: hr_utility.set_location(l_proc, 290);
3021:
3022: -- Start changes for bug 8836797
3023: update_ben_GSP_enteries(p_person_id => p_person_id
3024: ,p_new_start_date => l_new_start_date

Line 3029: hr_utility.set_location(l_proc, 295);

3025: ,p_old_start_date => l_old_start_date
3026: ,p_effective_date => l_new_start_date);
3027: -- End changes for bug 8836797
3028: --
3029: hr_utility.set_location(l_proc, 295);
3030: -- Bug 13026903 starts
3031: UPDATE per_ben_identified_events
3032: SET effective_date = l_new_start_date
3033: WHERE person_id = p_person_id

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

3056: run_alu_ee(p_person_id => p_person_id
3057: ,p_old_start_date => l_old_start_date
3058: ,p_new_start_date => l_new_start_date
3059: ,p_type => p_update_type);
3060: hr_utility.set_location(l_proc, 300);
3061: --
3062: -- 115.30 (START)
3063: --
3064: else

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

3070: ,p_old_start_date => l_old_start_date
3071: ,p_new_start_date => l_new_start_date
3072: ,p_type => p_update_type);
3073: --
3074: hr_utility.set_location(l_proc, 305);
3075: end if;
3076: --
3077: -- 115.30 (END)
3078: --

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

3081: per_people12_pkg.maintain_coverage
3082: (p_person_id => p_person_id
3083: ,p_type => 'EMP'
3084: );
3085: hr_utility.set_location(l_proc, 310);
3086: end if;
3087: end if;
3088: --
3089: END IF; -- end of check that old and new start dates are actually different

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

3118: (p_module_name => 'update_start_date'
3119: ,p_hook_type => 'AP'
3120: );
3121: end;
3122: hr_utility.set_location(l_proc, 310);
3123: --
3124: -- When in validation only mode raise the Validate_Enabled exception
3125: --
3126: if p_validate then

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

3130: -- Set all output arguments
3131: --
3132: p_warn_ee := l_warn_ee;
3133: --
3134: hr_utility.set_location(' Leaving:'||l_proc, 500);
3135: exception
3136: when hr_api.validate_enabled then
3137: --
3138: -- As the Validate_Enabled exception has been raised

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

3144: -- (Any key or derived arguments must be set to null
3145: -- when validation only mode is being used.)
3146: --
3147: p_warn_ee := 'N';
3148: hr_utility.set_location(' Leaving:'||l_proc, 600);
3149: when others then
3150: --
3151: -- A validation or unexpected error has occured
3152: --

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

3155: -- set in out parameters and set out parameters
3156: --
3157: p_warn_ee := null;
3158: --
3159: hr_utility.set_location(' Leaving:'||l_proc, 700);
3160: raise;
3161: end update_start_date;
3162: --
3163: end hr_change_start_date_api;