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

Line 164: hr_utility.set_location('hr_date_chk.lock_row',1);

160: from per_people_f pa
161: where pa.person_id = p_person_id
162: for update of person_id;
163: begin
164: hr_utility.set_location('hr_date_chk.lock_row',1);
165: open add;
166: loop
167: fetch add into l_dummy;
168: exit when add%NOTFOUND;

Line 172: hr_utility.set_location('hr_date_chk.lock_row',2);

168: exit when add%NOTFOUND;
169: end loop;
170: close add;
171: --
172: hr_utility.set_location('hr_date_chk.lock_row',2);
173: if (p_person_type = 'E') then
174: begin
175: open pay;
176: loop

Line 200: hr_utility.set_location('hr_date_chk.lock_row',3);

196: close cost;
197: end;
198: end if;
199: --
200: hr_utility.set_location('hr_date_chk.lock_row',3);
201: open ass;
202: loop
203: fetch ass into l_dummy;
204: exit when ass%NOTFOUND;

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

203: fetch ass into l_dummy;
204: exit when ass%NOTFOUND;
205: end loop;
206: if ass%ROWCOUNT < 1 then
207: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
208: hr_utility.set_message_token('PROCEDURE', 'lock_row');
209: hr_utility.set_message_token('STEP', '1');
210: hr_utility.raise_error;
211: end if;

Line 208: hr_utility.set_message_token('PROCEDURE', 'lock_row');

204: exit when ass%NOTFOUND;
205: end loop;
206: if ass%ROWCOUNT < 1 then
207: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
208: hr_utility.set_message_token('PROCEDURE', 'lock_row');
209: hr_utility.set_message_token('STEP', '1');
210: hr_utility.raise_error;
211: end if;
212: close ass;

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

205: end loop;
206: if ass%ROWCOUNT < 1 then
207: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
208: hr_utility.set_message_token('PROCEDURE', 'lock_row');
209: hr_utility.set_message_token('STEP', '1');
210: hr_utility.raise_error;
211: end if;
212: close ass;
213: --

Line 210: hr_utility.raise_error;

206: if ass%ROWCOUNT < 1 then
207: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
208: hr_utility.set_message_token('PROCEDURE', 'lock_row');
209: hr_utility.set_message_token('STEP', '1');
210: hr_utility.raise_error;
211: end if;
212: close ass;
213: --
214: hr_utility.set_location('hr_date_chk.lock_row',4);

Line 214: hr_utility.set_location('hr_date_chk.lock_row',4);

210: hr_utility.raise_error;
211: end if;
212: close ass;
213: --
214: hr_utility.set_location('hr_date_chk.lock_row',4);
215: open app;
216: loop
217: fetch app into l_dummy;
218: exit when app%NOTFOUND;

Line 222: hr_utility.set_location('hr_date_chk.lock_row',5);

218: exit when app%NOTFOUND;
219: end loop;
220: close app;
221: --
222: hr_utility.set_location('hr_date_chk.lock_row',5);
223: open per;
224: loop
225: fetch per into l_dummy;
226: exit when per%NOTFOUND;

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

225: fetch per into l_dummy;
226: exit when per%NOTFOUND;
227: end loop;
228: if per%ROWCOUNT < 1 then
229: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
230: hr_utility.set_message_token('PROCEDURE', 'lock_row');
231: hr_utility.set_message_token('STEP', '2');
232: hr_utility.raise_error;
233: end if;

Line 230: hr_utility.set_message_token('PROCEDURE', 'lock_row');

226: exit when per%NOTFOUND;
227: end loop;
228: if per%ROWCOUNT < 1 then
229: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
230: hr_utility.set_message_token('PROCEDURE', 'lock_row');
231: hr_utility.set_message_token('STEP', '2');
232: hr_utility.raise_error;
233: end if;
234: close per;

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

227: end loop;
228: if per%ROWCOUNT < 1 then
229: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
230: hr_utility.set_message_token('PROCEDURE', 'lock_row');
231: hr_utility.set_message_token('STEP', '2');
232: hr_utility.raise_error;
233: end if;
234: close per;
235: --

Line 232: hr_utility.raise_error;

228: if per%ROWCOUNT < 1 then
229: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
230: hr_utility.set_message_token('PROCEDURE', 'lock_row');
231: hr_utility.set_message_token('STEP', '2');
232: hr_utility.raise_error;
233: end if;
234: close per;
235: --
236: end;

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

258: OR (pac.date_earned BETWEEN p_s_start_date AND p_start_date)));
259: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
260: END;
261: IF l_act_chk = 'Y' THEN
262: hr_utility.set_message(801,'HR_51810_EMP_COMPL_ACTIONS');
263: hr_utility.raise_error;
264: END IF;
265: --
266: end;

Line 263: hr_utility.raise_error;

259: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
260: END;
261: IF l_act_chk = 'Y' THEN
262: hr_utility.set_message(801,'HR_51810_EMP_COMPL_ACTIONS');
263: hr_utility.raise_error;
264: END IF;
265: --
266: end;
267: --

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

299: l_prev_end_date := l_act_term_date;
300: END LOOP;
301: CLOSE pps;
302: IF l_action_chk = 'Y' THEN
303: hr_utility.set_message(801,'HR_51811_EMP_CONTIG_POS');
304: hr_utility.raise_error;
305: END IF;
306: END;
307: end;

Line 304: hr_utility.raise_error;

300: END LOOP;
301: CLOSE pps;
302: IF l_action_chk = 'Y' THEN
303: hr_utility.set_message(801,'HR_51811_EMP_CONTIG_POS');
304: hr_utility.raise_error;
305: END IF;
306: END;
307: end;
308: --

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

341: effective_start_date and effective_end_date
342: );
343: exception
344: when no_data_found then
345: hr_utility.set_message('801','HR_7679_EMP_SUP_PAY_NOT_EXIST');
346: hr_utility.raise_error;
347: end;
348: end if;
349: if l_supervisor_id is not null then

Line 346: hr_utility.raise_error;

342: );
343: exception
344: when no_data_found then
345: hr_utility.set_message('801','HR_7679_EMP_SUP_PAY_NOT_EXIST');
346: hr_utility.raise_error;
347: end;
348: end if;
349: if l_supervisor_id is not null then
350: begin

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

359: effective_start_date and effective_end_date
360: );
361: exception
362: when no_data_found then
363: hr_utility.set_message('801','HR_7680_EMP_SUP_PAY_NOT_EXIST');
364: hr_utility.raise_error;
365: end;
366: end if;
367: end;

Line 364: hr_utility.raise_error;

360: );
361: exception
362: when no_data_found then
363: hr_utility.set_message('801','HR_7680_EMP_SUP_PAY_NOT_EXIST');
364: hr_utility.raise_error;
365: end;
366: end if;
367: end;
368: --

Line 375: hr_utility.set_location('hr_date_chk.check_for_entries',1);

371: ,p_period_of_service_id NUMBER
372: ,p_start_date DATE) is
373: v_dummy number;
374: begin
375: hr_utility.set_location('hr_date_chk.check_for_entries',1);
376: select 1
377: into v_dummy
378: from sys.dual
379: where exists (select null

Line 389: hr_utility.set_message(801,'HR_6836_EMP_REF_DATE_CHG');

385: and p.period_of_service_id = p_period_of_service_id
386: and n.assignment_id = a.assignment_id
387: and n.effective_start_date > p.date_start
388: and n.effective_start_date < p_start_date);
389: hr_utility.set_message(801,'HR_6836_EMP_REF_DATE_CHG');
390: hr_utility.raise_error;
391: --
392: exception
393: when NO_DATA_FOUND then null;

Line 390: hr_utility.raise_error;

386: and n.assignment_id = a.assignment_id
387: and n.effective_start_date > p.date_start
388: and n.effective_start_date < p_start_date);
389: hr_utility.set_message(801,'HR_6836_EMP_REF_DATE_CHG');
390: hr_utility.raise_error;
391: --
392: exception
393: when NO_DATA_FOUND then null;
394: when others then raise;

Line 404: hr_utility.set_location('hr_date_chk.check_sp_placement',1);

400: ,p_start_date DATE) is
401: v_dummy number;
402: --
403: begin
404: hr_utility.set_location('hr_date_chk.check_sp_placement',1);
405: select 1
406: into v_dummy
407: from sys.dual
408: where exists (select 1

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

416: and sp.effective_start_date > p.date_start
417: and sp.effective_start_date < p_start_date
418: );
419: --
420: hr_utility.set_message(801,'HR_6837_EMP_REF_DATE_CHG');
421: hr_utility.raise_error;
422: --
423: exception
424: when NO_DATA_FOUND then null;

Line 421: hr_utility.raise_error;

417: and sp.effective_start_date < p_start_date
418: );
419: --
420: hr_utility.set_message(801,'HR_6837_EMP_REF_DATE_CHG');
421: hr_utility.raise_error;
422: --
423: exception
424: when NO_DATA_FOUND then null;
425: when others then raise;

Line 436: hr_utility.set_location('hr_date_chk.check_sp_placement',1);

432: ,p_start_date DATE) is
433: v_dummy number;
434: --
435: begin
436: hr_utility.set_location('hr_date_chk.check_sp_placement',1);
437: select 1
438: into v_dummy
439: from sys.dual
440: where exists (select 1

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

448: and ca.effective_start_date > p.date_start
449: and ca.effective_start_date < p_start_date
450: );
451: --
452: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
453: hr_utility.raise_error;
454: --
455: exception
456: when NO_DATA_FOUND then null;

Line 453: hr_utility.raise_error;

449: and ca.effective_start_date < p_start_date
450: );
451: --
452: hr_utility.set_message(801,'HR_7860_EMP_REF_DATE_CHG');
453: hr_utility.raise_error;
454: --
455: exception
456: when NO_DATA_FOUND then null;
457: when others then raise;

Line 469: hr_utility.set_location('hr_date_chk.check_people_changes',1);

465: ,p_start_date DATE) is
466: v_dummy number;
467: --
468: begin
469: hr_utility.set_location('hr_date_chk.check_people_changes',1);
470: select 1
471: into v_dummy
472: from sys.dual
473: where exists (select 1

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

477: and p.effective_start_date <> p_start_date
478: and p.person_id = p_person_id
479: );
480: --
481: hr_utility.set_message(801,'HR_6841_EMP_REF_DATE_CHG');
482: hr_utility.raise_error;
483: --
484: exception
485: when NO_DATA_FOUND then null;

Line 482: hr_utility.raise_error;

478: and p.person_id = p_person_id
479: );
480: --
481: hr_utility.set_message(801,'HR_6841_EMP_REF_DATE_CHG');
482: hr_utility.raise_error;
483: --
484: exception
485: when NO_DATA_FOUND then null;
486: when others then raise;

Line 499: hr_utility.set_location('hr_date_chk.check_for_ass_st_chg',1);

495: ,p_start_date DATE) is
496: v_dummy number;
497: --
498: begin
499: hr_utility.set_location('hr_date_chk.check_for_ass_st_chg',1);
500: select 1
501: into v_dummy
502: from sys.dual
503: where exists (select 1

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

513: and f.person_id = a.person_id
514: and a.person_id = p_person_id
515: );
516: --
517: hr_utility.set_message(801,'HR_6838_EMP_REF_DATE_CHG');
518: hr_utility.raise_error;
519: --
520: exception
521: when NO_DATA_FOUND then null;

Line 518: hr_utility.raise_error;

514: and a.person_id = p_person_id
515: );
516: --
517: hr_utility.set_message(801,'HR_6838_EMP_REF_DATE_CHG');
518: hr_utility.raise_error;
519: --
520: exception
521: when NO_DATA_FOUND then null;
522: when others then raise;

Line 536: hr_utility.set_location('hr_date_chk.check_for_ass_chg',1);

532: ,p_start_date DATE) is
533: v_dummy number;
534: --
535: begin
536: hr_utility.set_location('hr_date_chk.check_for_ass_chg',1);
537: select 1
538: into v_dummy
539: from sys.dual
540: where exists (select 1

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

545: -- and f.assignment_type =p_assignment_type
546: and f.person_id = p_person_id
547: );
548: --
549: hr_utility.set_message(801,'HR_6839_EMP_REF_DATE_CHG');
550: hr_utility.raise_error;
551: --
552: exception
553: when NO_DATA_FOUND then null;

Line 550: hr_utility.raise_error;

546: and f.person_id = p_person_id
547: );
548: --
549: hr_utility.set_message(801,'HR_6839_EMP_REF_DATE_CHG');
550: hr_utility.raise_error;
551: --
552: exception
553: when NO_DATA_FOUND then null;
554: when others then raise;

Line 565: hr_utility.set_location('hr_date_chk.check_for_prev_emp_ass',1);

561: ,p_start_date DATE) is
562: v_dummy number;
563: --
564: begin
565: hr_utility.set_location('hr_date_chk.check_for_prev_emp_ass',1);
566: select 1
567: into v_dummy
568: from sys.dual
569: where exists (select 1

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

573: and f.assignment_type =p_assignment_type
574: and f.person_id = p_person_id
575: );
576: --
577: hr_utility.set_message(801,'HR_6840_EMP_ENTER_PERIOD');
578: hr_utility.raise_error;
579: --
580: exception
581: when NO_DATA_FOUND then null;

Line 578: hr_utility.raise_error;

574: and f.person_id = p_person_id
575: );
576: --
577: hr_utility.set_message(801,'HR_6840_EMP_ENTER_PERIOD');
578: hr_utility.raise_error;
579: --
580: exception
581: when NO_DATA_FOUND then null;
582: when others then raise;

Line 601: hr_utility.set_location('hr_date_chk.check_hire_ref_int',1);

597: begin
598: l_assignment_type:='E';
599: l_later_date:=p_start_date;
600: l_earlier_date:=p_s_start_date;
601: hr_utility.set_location('hr_date_chk.check_hire_ref_int',1);
602: --
603: if p_start_date > p_s_start_date then
604: -- VT 11/27/96 #401587
605: hr_date_chk.check_for_compl_actions(p_person_id

Line 770: hr_utility.set_location('hr_date_chk.update_hire_records',1);

766: and abv.effective_start_date = p_s_start_date;
767: --
768:
769: begin
770: hr_utility.set_location('hr_date_chk.update_hire_records',1);
771: -- Update the addresses that start at the old hire date
772: -- Providing that the addresses end date is either equal to
773: -- the new start date or greater than it.
774: update per_addresses a

Line 781: hr_utility.set_location('hr_date_chk.update_hire_records',2);

777: and nvl(a.date_to,p_start_date) >= p_start_date
778: and a.person_id = p_person_id;
779: --
780: --
781: hr_utility.set_location('hr_date_chk.update_hire_records',2);
782: update pay_personal_payment_methods_f p
783: set p.effective_start_date = p_start_date
784: where p.effective_start_date = p_s_start_date
785: and p.effective_end_date >= p_start_date

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

797: set effective_start_date = p_start_date
798: where effective_start_date = p_s_start_date
799: and placement_id = l_sp_id;
800: if sql%rowcount <1 then
801: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
802: hr_utility.set_message_token('TABLE','PER_SPINAL_POINT_PLACEMENTS_F');
803: hr_utility.raise_error;
804: end if;
805: end loop;

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

798: where effective_start_date = p_s_start_date
799: and placement_id = l_sp_id;
800: if sql%rowcount <1 then
801: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
802: hr_utility.set_message_token('TABLE','PER_SPINAL_POINT_PLACEMENTS_F');
803: hr_utility.raise_error;
804: end if;
805: end loop;
806: close ssp;

Line 803: hr_utility.raise_error;

799: and placement_id = l_sp_id;
800: if sql%rowcount <1 then
801: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
802: hr_utility.set_message_token('TABLE','PER_SPINAL_POINT_PLACEMENTS_F');
803: hr_utility.raise_error;
804: end if;
805: end loop;
806: close ssp;
807: end;

Line 809: hr_utility.set_location('hr_date_chk.update_hire_records',3);

805: end loop;
806: close ssp;
807: end;
808: --
809: hr_utility.set_location('hr_date_chk.update_hire_records',3);
810: begin
811: open cost;
812: loop
813: fetch cost into l_ca_id;

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

816: set effective_start_date = p_start_date
817: where effective_start_date = p_s_start_date
818: and COST_ALLOCATION_ID = l_ca_id;
819: if sql%rowcount <1 then
820: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
821: hr_utility.set_message_token('TABLE','PAY_COST_ALLOCATIONS_F');
822: hr_utility.raise_error;
823: end if;
824: end loop;

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

817: where effective_start_date = p_s_start_date
818: and COST_ALLOCATION_ID = l_ca_id;
819: if sql%rowcount <1 then
820: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
821: hr_utility.set_message_token('TABLE','PAY_COST_ALLOCATIONS_F');
822: hr_utility.raise_error;
823: end if;
824: end loop;
825: close cost;

Line 822: hr_utility.raise_error;

818: and COST_ALLOCATION_ID = l_ca_id;
819: if sql%rowcount <1 then
820: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
821: hr_utility.set_message_token('TABLE','PAY_COST_ALLOCATIONS_F');
822: hr_utility.raise_error;
823: end if;
824: end loop;
825: close cost;
826: end;

Line 837: hr_utility.set_location('hr_date_chk.update_hire_records',5);

833: -- This is a wider issue and this code will be left like this until all changes are made.
834: -- SASMITH 8-MAY-1998
835: --
836:
837: hr_utility.set_location('hr_date_chk.update_hire_records',5);
838: begin
839: open abv;
840: loop
841: fetch abv into l_abv_id;

Line 858: hr_utility.set_location('hr_date_chk.update_hire_records',10);

854: close abv;
855: end;
856:
857: --
858: hr_utility.set_location('hr_date_chk.update_hire_records',10);
859: --
860: -- BUG 308000 removed select min (effective_date) code
861: -- and it's reference in following code tm 19-sep-1995.
862: --

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

869: and a.assignment_type = 'E'
870: and a.person_id = p_person_id;
871: --
872: if sql%rowcount <1 then
873: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
874: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
875: hr_utility.raise_error;
876: end if;
877: --

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

870: and a.person_id = p_person_id;
871: --
872: if sql%rowcount <1 then
873: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
874: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
875: hr_utility.raise_error;
876: end if;
877: --
878: --

Line 875: hr_utility.raise_error;

871: --
872: if sql%rowcount <1 then
873: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
874: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
875: hr_utility.raise_error;
876: end if;
877: --
878: --
879: hr_utility.set_location('hr_date_chk.update_hire_records',12);

Line 879: hr_utility.set_location('hr_date_chk.update_hire_records',12);

875: hr_utility.raise_error;
876: end if;
877: --
878: --
879: hr_utility.set_location('hr_date_chk.update_hire_records',12);
880: -- keep contracts in synch with PER and ASG :
881: hr_contract_api.maintain_contracts
882: (p_person_id
883: ,p_start_date

Line 887: hr_utility.set_location('hr_date_chk.update_hire_records',15);

883: ,p_start_date
884: ,p_s_start_date);
885: --
886: --
887: hr_utility.set_location('hr_date_chk.update_hire_records',15);
888: --
889: -- update the tax records and pull back their effective start date if
890: -- the defaulting tax criteria is met.
891:

Line 893: -- if hr_utility.chk_product_install(p_product =>'Oracle Payroll', then

889: -- update the tax records and pull back their effective start date if
890: -- the defaulting tax criteria is met.
891:
892: -- Checking if payroll installed is now handled in default_tax_with_validation
893: -- if hr_utility.chk_product_install(p_product =>'Oracle Payroll', then
894: open csr_get_bg;
895: fetch csr_get_bg into l_business_group_id;
896: if csr_get_bg%NOTFOUND then
897: close csr_get_bg;

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

894: open csr_get_bg;
895: fetch csr_get_bg into l_business_group_id;
896: if csr_get_bg%NOTFOUND then
897: close csr_get_bg;
898: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
899: hr_utility.set_message_token('PROCEDURE', 'update_hire_records');
900: hr_utility.set_message_token('STEP', '1');
901: hr_utility.raise_error;
902: end if;

Line 899: hr_utility.set_message_token('PROCEDURE', 'update_hire_records');

895: fetch csr_get_bg into l_business_group_id;
896: if csr_get_bg%NOTFOUND then
897: close csr_get_bg;
898: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
899: hr_utility.set_message_token('PROCEDURE', 'update_hire_records');
900: hr_utility.set_message_token('STEP', '1');
901: hr_utility.raise_error;
902: end if;
903: close csr_get_bg;

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

896: if csr_get_bg%NOTFOUND then
897: close csr_get_bg;
898: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
899: hr_utility.set_message_token('PROCEDURE', 'update_hire_records');
900: hr_utility.set_message_token('STEP', '1');
901: hr_utility.raise_error;
902: end if;
903: close csr_get_bg;
904:

Line 901: hr_utility.raise_error;

897: close csr_get_bg;
898: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
899: hr_utility.set_message_token('PROCEDURE', 'update_hire_records');
900: hr_utility.set_message_token('STEP', '1');
901: hr_utility.raise_error;
902: end if;
903: close csr_get_bg;
904:
905: pay_us_emp_dt_tax_rules.default_tax_with_validation(p_assignment_id => null,

Line 920: hr_utility.set_location('hr_date_chk.update_hire_records',20);

916: -- end if; --end if payroll_installed
917:
918:
919: if p_app_number is not null then
920: hr_utility.set_location('hr_date_chk.update_hire_records',20);
921: begin
922: open app_ass;
923: loop
924: fetch app_ass into l_assignment_id;

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

935: and a2.assignment_type = 'A')
936: and a.assignment_id = l_assignment_id;
937: --
938: if sql%rowcount <1 then
939: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
940: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
941: hr_utility.raise_error;
942: end if;
943: end loop;

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

936: and a.assignment_id = l_assignment_id;
937: --
938: if sql%rowcount <1 then
939: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
940: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
941: hr_utility.raise_error;
942: end if;
943: end loop;
944: close app_ass;

Line 941: hr_utility.raise_error;

937: --
938: if sql%rowcount <1 then
939: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
940: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
941: hr_utility.raise_error;
942: end if;
943: end loop;
944: close app_ass;
945: --

Line 965: hr_utility.set_location('hr_date_chk.update_hire_records',25);

961: and peo.effective_start_date = p_s_start_date
962: and peo.current_applicant_flag = 'Y');
963: /* End fix for Bug 673066 */
964: --
965: hr_utility.set_location('hr_date_chk.update_hire_records',25);
966:
967: if sql%rowcount <1 then
968: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
969: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');

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

964: --
965: hr_utility.set_location('hr_date_chk.update_hire_records',25);
966:
967: if sql%rowcount <1 then
968: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
969: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');
970: hr_utility.raise_error;
971: end if;
972: end loop;

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

965: hr_utility.set_location('hr_date_chk.update_hire_records',25);
966:
967: if sql%rowcount <1 then
968: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
969: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');
970: hr_utility.raise_error;
971: end if;
972: end loop;
973: close app;

Line 970: hr_utility.raise_error;

966:
967: if sql%rowcount <1 then
968: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
969: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');
970: hr_utility.raise_error;
971: end if;
972: end loop;
973: close app;
974: end;

Line 977: hr_utility.set_location('hr_date_chk.update_hire_records',30);

973: close app;
974: end;
975: end if;
976: --
977: hr_utility.set_location('hr_date_chk.update_hire_records',30);
978: update per_people_f p
979: set p.start_date =decode(p.start_date,p_s_start_date, p_start_date,
980: p.start_date),
981: p.effective_start_date =decode(p.effective_start_date,

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

987: p.last_update_login = p_login_id
988: where p.person_id = p_person_id;
989: --
990: if sql%rowcount <1 then
991: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
992: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');
993: hr_utility.raise_error;
994: end if;
995: --

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

988: where p.person_id = p_person_id;
989: --
990: if sql%rowcount <1 then
991: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
992: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');
993: hr_utility.raise_error;
994: end if;
995: --
996: end;

Line 993: hr_utility.raise_error;

989: --
990: if sql%rowcount <1 then
991: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
992: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');
993: hr_utility.raise_error;
994: end if;
995: --
996: end;
997: --

Line 1012: hr_utility.set_location('hr_date_chk.check_apl_ref_int',1);

1008: begin
1009: l_assignment_type:='A';
1010: l_later_date:=p_start_date;
1011: l_earlier_date:=p_s_start_date;
1012: hr_utility.set_location('hr_date_chk.check_apl_ref_int',1);
1013: --
1014: if p_start_date > p_s_start_date then
1015: --
1016: hr_date_chk.check_for_ass_st_chg(p_person_id

Line 1069: hr_utility.set_location('hr_date_chk.update_appl_records',1);

1065: -- Update the addresses that start at the old hire date
1066: -- Providing that the addresses end date is either equal to
1067: -- the new start date or greater than it.
1068: --
1069: hr_utility.set_location('hr_date_chk.update_appl_records',1);
1070: update per_addresses a
1071: set a.date_from = p_start_date
1072: where a.date_from = p_s_start_date
1073: and nvl(a.date_to,p_start_date) >= p_start_date

Line 1077: hr_utility.set_location('hr_date_chk.update_appl_records',2);

1073: and nvl(a.date_to,p_start_date) >= p_start_date
1074: and a.person_id = p_person_id;
1075: --
1076: --
1077: hr_utility.set_location('hr_date_chk.update_appl_records',2);
1078: update per_assignments_f a
1079: set a.effective_start_date = p_start_date,
1080: a.last_update_date = sysdate,
1081: a.last_updated_by = p_user_id,

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

1092: having max(a2.effective_start_date)= a.effective_start_date);
1093:
1094: --
1095: if sql%rowcount <1 then
1096: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1097: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
1098: hr_utility.raise_error;
1099: end if;
1100: hr_utility.set_location('hr_date_chk.update_appl_records',3);

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

1093:
1094: --
1095: if sql%rowcount <1 then
1096: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1097: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
1098: hr_utility.raise_error;
1099: end if;
1100: hr_utility.set_location('hr_date_chk.update_appl_records',3);
1101: --

Line 1098: hr_utility.raise_error;

1094: --
1095: if sql%rowcount <1 then
1096: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1097: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
1098: hr_utility.raise_error;
1099: end if;
1100: hr_utility.set_location('hr_date_chk.update_appl_records',3);
1101: --
1102: update per_people_f p

Line 1100: hr_utility.set_location('hr_date_chk.update_appl_records',3);

1096: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1097: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
1098: hr_utility.raise_error;
1099: end if;
1100: hr_utility.set_location('hr_date_chk.update_appl_records',3);
1101: --
1102: update per_people_f p
1103: set p.start_date =decode(p.start_date,p_s_start_date, p_start_date,
1104: p.start_date),

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

1111: p.last_update_login = p_login_id
1112: where p.person_id = p_person_id;
1113: --
1114: if sql%rowcount <1 then
1115: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1116: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');
1117: hr_utility.raise_error;
1118: end if;
1119: --

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

1112: where p.person_id = p_person_id;
1113: --
1114: if sql%rowcount <1 then
1115: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1116: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');
1117: hr_utility.raise_error;
1118: end if;
1119: --
1120: -- keep contracts in synch with PER and ASG :

Line 1117: hr_utility.raise_error;

1113: --
1114: if sql%rowcount <1 then
1115: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1116: hr_utility.set_message_token('TABLE','PER_ALL_PEOPLE_F');
1117: hr_utility.raise_error;
1118: end if;
1119: --
1120: -- keep contracts in synch with PER and ASG :
1121: hr_contract_api.maintain_contracts