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.PER_PRV_BUS dependencies on HR_UTILITY

Line 47: hr_utility.set_location('Entering:'||l_proc, 5);

43: l_api_updating boolean;
44: --
45: Begin
46: --
47: hr_utility.set_location('Entering:'||l_proc, 5);
48: --
49: l_api_updating := per_prv_shd.api_updating
50: (p_performance_review_id => p_performance_review_id,
51: p_object_version_number => p_object_version_number);

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

71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_performance_review_id;
78: --
79: -- ----------------------------------------------------------------------------

Line 121: hr_utility.set_location('Entering:'||l_proc,5);

117: where pev.event_id = p_event_id;
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: if (p_event_id is not null) then
124: l_api_updating := per_prv_shd.api_updating
125: (p_performance_review_id => p_performance_review_id

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

150: --
151: end if;
152: end if;
153: --
154: hr_utility.set_location('Leaving:'||l_proc,10);
155: --
156: End chk_event_id;
157: --
158: -- ----------------------------------------------------------------------------

Line 187: hr_utility.set_location('Entering:'||l_proc,5);

183: l_dummy number;
184:
185: begin
186:
187: hr_utility.set_location('Entering:'||l_proc,5);
188: --
189: -- Check mandatory parameters have being set.
190: --
191: hr_api.mandatory_arg_error

Line 213: hr_utility.set_location(l_proc,10);

209: <> nvl(per_prv_shd.g_old_rec.person_id,hr_api.g_number)
210: or nvl(p_review_date,hr_api.g_date)
211: <> nvl(per_prv_shd.g_old_rec.review_date,hr_api.g_date))
212: or not l_api_updating) then
213: hr_utility.set_location(l_proc,10);
214: --
215: -- check if the person exists on this date
216: --
217: open get_person;

Line 221: hr_utility.set_location(l_proc,15);

217: open get_person;
218: --
219: fetch get_person into l_dummy;
220: if get_person%notfound then
221: hr_utility.set_location(l_proc,15);
222: --
223: close get_person;
224: --
225: -- raise error as FK does not relate to PK in per_events

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

230: end if;
231: --
232: close get_person;
233: --
234: hr_utility.set_location(l_proc,20);
235: open get_dup_date;
236: fetch get_dup_date into l_dummy;
237: if get_dup_date%FOUND then
238: close get_dup_date;

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

235: open get_dup_date;
236: fetch get_dup_date into l_dummy;
237: if get_dup_date%FOUND then
238: close get_dup_date;
239: hr_utility.set_location(l_proc,25);
240: hr_utility.set_message(801,'HR_13000_SAL_DATE_NOT_UNIQUE');
241: hr_utility.raise_error;
242: end if;
243: close get_dup_date;

Line 240: hr_utility.set_message(801,'HR_13000_SAL_DATE_NOT_UNIQUE');

236: fetch get_dup_date into l_dummy;
237: if get_dup_date%FOUND then
238: close get_dup_date;
239: hr_utility.set_location(l_proc,25);
240: hr_utility.set_message(801,'HR_13000_SAL_DATE_NOT_UNIQUE');
241: hr_utility.raise_error;
242: end if;
243: close get_dup_date;
244: end if;

Line 241: hr_utility.raise_error;

237: if get_dup_date%FOUND then
238: close get_dup_date;
239: hr_utility.set_location(l_proc,25);
240: hr_utility.set_message(801,'HR_13000_SAL_DATE_NOT_UNIQUE');
241: hr_utility.raise_error;
242: end if;
243: close get_dup_date;
244: end if;
245: --

Line 246: hr_utility.set_location('Leaving:'||l_proc,30);

242: end if;
243: close get_dup_date;
244: end if;
245: --
246: hr_utility.set_location('Leaving:'||l_proc,30);
247: end chk_person_id_date;
248: --
249: -- ----------------------------------------------------------------------------
250: -- |-----------------------< chk_next_perf_review_date >----------------------|

Line 274: hr_utility.set_location('Entering:'||l_proc, 5);

270: and ppf.current_employee_flag='Y';
271: --
272: Begin
273: --
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: -- Check mandatory parameters have being set.
277: --
278: hr_api.mandatory_arg_error

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

291: or nvl(per_prv_shd.g_old_rec.review_date ,hr_api.g_date)
292: <> nvl(p_review_date,hr_api.g_date))
293: or not l_api_updating) then
294: --
295: hr_utility.set_location(l_proc, 10);
296: if(p_next_perf_review_date<=p_review_date) then
297: hr_utility.set_message(801, 'HR_51260_PYP_INVAL_PERF_DATE');
298: hr_utility.raise_error;
299: end if;

Line 297: hr_utility.set_message(801, 'HR_51260_PYP_INVAL_PERF_DATE');

293: or not l_api_updating) then
294: --
295: hr_utility.set_location(l_proc, 10);
296: if(p_next_perf_review_date<=p_review_date) then
297: hr_utility.set_message(801, 'HR_51260_PYP_INVAL_PERF_DATE');
298: hr_utility.raise_error;
299: end if;
300: open get_person;
301: fetch get_person into l_dummy;

Line 298: hr_utility.raise_error;

294: --
295: hr_utility.set_location(l_proc, 10);
296: if(p_next_perf_review_date<=p_review_date) then
297: hr_utility.set_message(801, 'HR_51260_PYP_INVAL_PERF_DATE');
298: hr_utility.raise_error;
299: end if;
300: open get_person;
301: fetch get_person into l_dummy;
302: if get_person%notfound and p_next_perf_review_date is not null then

Line 303: hr_utility.set_location(l_proc, 15);

299: end if;
300: open get_person;
301: fetch get_person into l_dummy;
302: if get_person%notfound and p_next_perf_review_date is not null then
303: hr_utility.set_location(l_proc, 15);
304: close get_person;
305: p_next_review_date_warning:=TRUE;
306: else
307: close get_person;

Line 312: hr_utility.set_location('Leaving:'||l_proc,20);

308: p_next_review_date_warning:=FALSE;
309: end if;
310: end if;
311: --
312: hr_utility.set_location('Leaving:'||l_proc,20);
313: end chk_next_perf_review_date;
314: --
315: --
316: -- ----------------------------------------------------------------------------

Line 340: hr_utility.set_location('Entering:'||l_proc, 5);

336: and paf.effective_end_date;
337: --
338: Begin
339: --
340: hr_utility.set_location('Entering:'||l_proc, 5);
341: --
342: -- Check mandatory parameters have being set.
343: --
344: hr_api.mandatory_arg_error

Line 359: hr_utility.set_location(l_proc, 10);

355: (nvl(per_prv_shd.g_old_rec.review_date ,hr_api.g_date)
356: <> nvl(p_review_date,hr_api.g_date))
357: or not l_api_updating) then
358: --
359: hr_utility.set_location(l_proc, 10);
360: if(p_assignment_id is not null
361: and p_next_perf_review_date is null) then
362: open get_frequency;
363: fetch get_frequency into l_period,l_frequency;

Line 365: hr_utility.set_location(l_proc, 15);

361: and p_next_perf_review_date is null) then
362: open get_frequency;
363: fetch get_frequency into l_period,l_frequency;
364: if get_frequency%found then
365: hr_utility.set_location(l_proc, 15);
366: close get_frequency;
367: if(l_frequency='M') THEN
368: hr_utility.set_location(l_proc, 20);
369: p_next_perf_review_date:=add_months(p_review_date,l_period);

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

364: if get_frequency%found then
365: hr_utility.set_location(l_proc, 15);
366: close get_frequency;
367: if(l_frequency='M') THEN
368: hr_utility.set_location(l_proc, 20);
369: p_next_perf_review_date:=add_months(p_review_date,l_period);
370: elsif(l_frequency='Y') THEN
371: hr_utility.set_location(l_proc, 25);
372: p_next_perf_review_date:=add_months(p_review_date,l_period*12);

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

367: if(l_frequency='M') THEN
368: hr_utility.set_location(l_proc, 20);
369: p_next_perf_review_date:=add_months(p_review_date,l_period);
370: elsif(l_frequency='Y') THEN
371: hr_utility.set_location(l_proc, 25);
372: p_next_perf_review_date:=add_months(p_review_date,l_period*12);
373: elsif(l_frequency='D') THEN
374: hr_utility.set_location(l_proc, 30);
375: p_next_perf_review_date:=p_review_date+l_period;

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

370: elsif(l_frequency='Y') THEN
371: hr_utility.set_location(l_proc, 25);
372: p_next_perf_review_date:=add_months(p_review_date,l_period*12);
373: elsif(l_frequency='D') THEN
374: hr_utility.set_location(l_proc, 30);
375: p_next_perf_review_date:=p_review_date+l_period;
376: elsif(l_frequency='W') THEN
377: hr_utility.set_location(l_proc, 35);
378: p_next_perf_review_date:=p_review_date+(l_period*7);

Line 377: hr_utility.set_location(l_proc, 35);

373: elsif(l_frequency='D') THEN
374: hr_utility.set_location(l_proc, 30);
375: p_next_perf_review_date:=p_review_date+l_period;
376: elsif(l_frequency='W') THEN
377: hr_utility.set_location(l_proc, 35);
378: p_next_perf_review_date:=p_review_date+(l_period*7);
379: else
380: hr_utility.set_location(l_proc||' '||l_frequency, 40);
381: end if;

Line 380: hr_utility.set_location(l_proc||' '||l_frequency, 40);

376: elsif(l_frequency='W') THEN
377: hr_utility.set_location(l_proc, 35);
378: p_next_perf_review_date:=p_review_date+(l_period*7);
379: else
380: hr_utility.set_location(l_proc||' '||l_frequency, 40);
381: end if;
382: else
383: hr_utility.set_location(l_proc, 50);
384: close get_frequency;

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

379: else
380: hr_utility.set_location(l_proc||' '||l_frequency, 40);
381: end if;
382: else
383: hr_utility.set_location(l_proc, 50);
384: close get_frequency;
385: end if;
386: end if;
387: end if;

Line 389: hr_utility.set_location('Leaving:'||l_proc,55);

385: end if;
386: end if;
387: end if;
388: --
389: hr_utility.set_location('Leaving:'||l_proc,55);
390: end chk_get_next_perf_review_date;
391: --
392: --
393: -- ----------------------------------------------------------------------------

Line 431: hr_utility.set_location('Entering:'|| l_proc, 5);

427: l_api_updating boolean;
428: --
429:
430: begin
431: hr_utility.set_location('Entering:'|| l_proc, 5);
432: --
433: -- Check mandatory parameters have being set.
434: --
435: hr_api.mandatory_arg_error

Line 451: hr_utility.set_location(l_proc, 10);

447: ,p_object_version_number => p_object_version_number);
448: --
449: if (l_api_updating AND (nvl(per_prv_shd.g_old_rec.performance_rating,hr_api.g_varchar2) <>
450: nvl(p_performance_rating,hr_api.g_varchar2)) OR not l_api_updating) then
451: hr_utility.set_location(l_proc, 10);
452: --
453: -- check that the p_performance_rating exists in hr_lookups.
454: --
455: if hr_api.not_exists_in_hr_lookups

Line 460: hr_utility.set_location(l_proc, 15);

456: (p_effective_date => p_review_date
457: ,p_lookup_type => 'PERFORMANCE_RATING'
458: ,p_lookup_code => p_performance_rating
459: ) then
460: hr_utility.set_location(l_proc, 15);
461: hr_utility.set_message(801,'HR_51264_PYP_INVAL_PERF_RATING');
462: hr_utility.raise_error;
463: end if;
464: --

Line 461: hr_utility.set_message(801,'HR_51264_PYP_INVAL_PERF_RATING');

457: ,p_lookup_type => 'PERFORMANCE_RATING'
458: ,p_lookup_code => p_performance_rating
459: ) then
460: hr_utility.set_location(l_proc, 15);
461: hr_utility.set_message(801,'HR_51264_PYP_INVAL_PERF_RATING');
462: hr_utility.raise_error;
463: end if;
464: --
465: end if;

Line 462: hr_utility.raise_error;

458: ,p_lookup_code => p_performance_rating
459: ) then
460: hr_utility.set_location(l_proc, 15);
461: hr_utility.set_message(801,'HR_51264_PYP_INVAL_PERF_RATING');
462: hr_utility.raise_error;
463: end if;
464: --
465: end if;
466: --

Line 467: hr_utility.set_location(' Leaving:'|| l_proc, 20);

463: end if;
464: --
465: end if;
466: --
467: hr_utility.set_location(' Leaving:'|| l_proc, 20);
468: end chk_performance_rating;
469: --
470: --
471: -- -----------------------------------------------------------------------

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

500: --
501: l_proc varchar2(72) := g_package||'chk_df';
502: --
503: begin
504: hr_utility.set_location('Entering:'||l_proc, 10);
505: --
506: if ((p_rec.performance_review_id is not null) and (
507: nvl(per_prv_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

Line 644: hr_utility.set_location(' Leaving:'||l_proc, 20);

640: ,p_attribute30_value => p_rec.attribute30
641: );
642: end if;
643: --
644: hr_utility.set_location(' Leaving:'||l_proc, 20);
645: end chk_df;
646: -- ----------------------------------------------------------------------------
647: -- |-----------------------< chk_non_updateable_args >------------------------|
648: -- ----------------------------------------------------------------------------

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

691: fnd_message.set_token('STEP ', '5');
692: fnd_message.raise_error;
693: END IF;
694: --
695: hr_utility.set_location(l_proc, 30);
696: --
697: if nvl(p_rec.person_id, hr_api.g_number) <>
698: nvl(per_prv_shd.g_old_rec.person_id
699: ,hr_api.g_number) then

Line 730: hr_utility.set_location('Entering:'||l_proc, 5);

726: where ppp.performance_review_id=p_performance_review_id;
727: --
728: Begin
729: --
730: hr_utility.set_location('Entering:'||l_proc, 5);
731: --
732: hr_api.mandatory_arg_error
733: (p_api_name => l_proc
734: ,p_argument => 'performance_review_id'

Line 742: hr_utility.set_location(l_proc,10);

738: open c_used;
739: fetch c_used into l_exists;
740: if(c_used%found) then
741: close c_used;
742: hr_utility.set_location(l_proc,10);
743: hr_utility.set_message(800,'HR_52408_PRV_PROPOSAL_EXISTS');
744: hr_utility.raise_error;
745: else
746: close c_used;

Line 743: hr_utility.set_message(800,'HR_52408_PRV_PROPOSAL_EXISTS');

739: fetch c_used into l_exists;
740: if(c_used%found) then
741: close c_used;
742: hr_utility.set_location(l_proc,10);
743: hr_utility.set_message(800,'HR_52408_PRV_PROPOSAL_EXISTS');
744: hr_utility.raise_error;
745: else
746: close c_used;
747: end if;

Line 744: hr_utility.raise_error;

740: if(c_used%found) then
741: close c_used;
742: hr_utility.set_location(l_proc,10);
743: hr_utility.set_message(800,'HR_52408_PRV_PROPOSAL_EXISTS');
744: hr_utility.raise_error;
745: else
746: close c_used;
747: end if;
748: --

Line 749: hr_utility.set_location(' Leaving:'||l_proc, 20);

745: else
746: close c_used;
747: end if;
748: --
749: hr_utility.set_location(' Leaving:'||l_proc, 20);
750: end chk_delete_performance_review;
751: --
752: -- ----------------------------------------------------------------------------
753: -- |---------------------------< insert_validate >----------------------------|

Line 761: hr_utility.set_location('Entering:'||l_proc, 5);

757: --
758: l_proc varchar2(72) := g_package||'insert_validate';
759: --
760: Begin
761: hr_utility.set_location('Entering:'||l_proc, 5);
762: --
763: per_per_bus.set_security_group_id
764: (
765: p_person_id => p_rec.person_id

Line 768: hr_utility.set_location('Entering:'||l_proc, 5);

764: (
765: p_person_id => p_rec.person_id
766: );
767: --
768: hr_utility.set_location('Entering:'||l_proc, 5);
769: --
770: -- Call all supporting business operations
771: --
772: chk_performance_review_id

Line 776: hr_utility.set_location(l_proc, 10);

772: chk_performance_review_id
773: (p_performance_review_id => p_rec.performance_review_id,
774: p_object_version_number => p_rec.object_version_number);
775: --
776: hr_utility.set_location(l_proc, 10);
777: --
778: chk_event_id
779: (p_performance_review_id => p_rec.performance_review_id,
780: p_event_id => p_rec.event_id,

Line 783: hr_utility.set_location(l_proc, 15);

779: (p_performance_review_id => p_rec.performance_review_id,
780: p_event_id => p_rec.event_id,
781: p_object_version_number => p_rec.object_version_number);
782: --
783: hr_utility.set_location(l_proc, 15);
784: --
785: chk_person_id_date(p_performance_review_id => p_rec.performance_review_id
786: ,p_object_version_number => p_rec.object_version_number
787: ,p_person_id => p_rec.person_id

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

786: ,p_object_version_number => p_rec.object_version_number
787: ,p_person_id => p_rec.person_id
788: ,p_review_date => p_rec.review_date);
789: --
790: hr_utility.set_location(l_proc, 20);
791: --
792: chk_next_perf_review_date(p_performance_review_id => p_rec.performance_review_id
793: ,p_object_version_number => p_rec.object_version_number
794: ,p_review_date => p_rec.review_date

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

801: ,p_performance_rating => p_rec.performance_rating
802: ,p_review_date => p_rec.review_date
803: ,p_object_version_number => p_rec.object_version_number);
804: --
805: hr_utility.set_location(l_proc, 25);
806: --
807: chk_df(p_rec => p_rec);
808: --
809: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

805: hr_utility.set_location(l_proc, 25);
806: --
807: chk_df(p_rec => p_rec);
808: --
809: hr_utility.set_location(' Leaving:'||l_proc, 10);
810: End insert_validate;
811: --
812: -- ----------------------------------------------------------------------------
813: -- |---------------------------< update_validate >----------------------------|

Line 821: hr_utility.set_location('Entering:'||l_proc, 5);

817: --
818: l_proc varchar2(72) := g_package||'update_validate';
819: --
820: Begin
821: hr_utility.set_location('Entering:'||l_proc, 5);
822: --
823: per_per_bus.set_security_group_id
824: (
825: p_person_id => p_rec.person_id

Line 828: hr_utility.set_location('Entering:'||l_proc, 5);

824: (
825: p_person_id => p_rec.person_id
826: );
827: --
828: hr_utility.set_location('Entering:'||l_proc, 5);
829: --
830: -- Call all supporting business operations
831: --
832: chk_non_updateable_args(

Line 839: hr_utility.set_location(l_proc, 10);

835: chk_performance_review_id
836: (p_performance_review_id => p_rec.performance_review_id,
837: p_object_version_number => p_rec.object_version_number);
838: --
839: hr_utility.set_location(l_proc, 10);
840: --
841: chk_event_id
842: (p_performance_review_id => p_rec.performance_review_id,
843: p_event_id => p_rec.event_id,

Line 846: hr_utility.set_location(l_proc, 15);

842: (p_performance_review_id => p_rec.performance_review_id,
843: p_event_id => p_rec.event_id,
844: p_object_version_number => p_rec.object_version_number);
845: --
846: hr_utility.set_location(l_proc, 15);
847: --
848: chk_person_id_date(p_performance_review_id => p_rec.performance_review_id
849: ,p_object_version_number => p_rec.object_version_number
850: ,p_person_id => p_rec.person_id

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

849: ,p_object_version_number => p_rec.object_version_number
850: ,p_person_id => p_rec.person_id
851: ,p_review_date => p_rec.review_date);
852: --
853: hr_utility.set_location(l_proc, 20);
854: --
855: chk_next_perf_review_date(p_performance_review_id => p_rec.performance_review_id
856: ,p_object_version_number => p_rec.object_version_number
857: ,p_review_date => p_rec.review_date

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

864: ,p_performance_rating => p_rec.performance_rating
865: ,p_review_date => p_rec.review_date
866: ,p_object_version_number => p_rec.object_version_number);
867: --
868: hr_utility.set_location(l_proc, 25);
869: --
870: chk_df(p_rec => p_rec);
871: --
872: --

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

869: --
870: chk_df(p_rec => p_rec);
871: --
872: --
873: hr_utility.set_location(' Leaving:'||l_proc, 10);
874: End update_validate;
875: --
876: -- ----------------------------------------------------------------------------
877: -- |---------------------------< delete_validate >----------------------------|

Line 884: hr_utility.set_location('Entering:'||l_proc, 5);

880: --
881: l_proc varchar2(72) := g_package||'delete_validate';
882: --
883: Begin
884: hr_utility.set_location('Entering:'||l_proc, 5);
885: --
886: chk_delete_performance_review (p_performance_review_id => p_rec.performance_review_id);
887: --
888: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

884: hr_utility.set_location('Entering:'||l_proc, 5);
885: --
886: chk_delete_performance_review (p_performance_review_id => p_rec.performance_review_id);
887: --
888: hr_utility.set_location(' Leaving:'||l_proc, 10);
889: End delete_validate;
890: --
891: -- ----------------------------------------------------------------------------
892: -- |--------------------< return_legislation_code >---------------------------|

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

910: --
911: l_legislation_code varchar2(150);
912: l_proc varchar2(72) := 'return_legislation_code';
913: begin
914: hr_utility.set_location('Entering: '||l_proc,10);
915: hr_api.mandatory_arg_error
916: (p_api_name => l_proc
917: ,p_argument => 'performance_review_id'
918: ,p_argument_value => p_performance_review_id

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

923: -- call to this function. Just return the value in the global
924: -- variable.
925: --
926: l_legislation_code := g_legislation_code;
927: hr_utility.set_location(l_proc,20);
928: else
929: --
930: -- The ID is different to the last call to this function
931: -- or this is the first call to this function.

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

939: close csr_leg_code;
940: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
941: fnd_message.raise_error;
942: end if;
943: hr_utility.set_location(l_proc,30);
944: --
945: -- Set the global variables so the values are available
946: -- for the next call to this function.
947: --

Line 952: hr_utility.set_location(' Leaving: '||l_proc, 40);

948: close csr_leg_code;
949: g_performance_review_id := p_performance_review_id;
950: g_legislation_code := l_legislation_code;
951: end if;
952: hr_utility.set_location(' Leaving: '||l_proc, 40);
953: --
954: return l_legislation_code;
955: end return_legislation_code;
956: --