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

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

39: l_proc varchar2(72) := g_package||'set_security_group_id';
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

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

70: hr_api.set_security_group_id
71: (p_security_group_id => l_security_group_id
72: );
73: --
74: hr_utility.set_location(' Leaving:'|| l_proc, 20);
75: --
76: end set_security_group_id;
77: --
78: -- ---------------------------------------------------------------------------

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

101: l_proc varchar2(72) := g_package||'return_legislation_code';
102: --
103: Begin
104: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error

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

119: -- call to this function. Just return the value in the global
120: -- variable.
121: --
122: l_legislation_code := per_rol_bus.g_legislation_code;
123: hr_utility.set_location(l_proc, 20);
124: else
125: --
126: -- The ID is different to the last call to this function
127: -- or this is the first call to this function.

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

136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are
143: -- available for the next call to this function.
144: --

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

145: close csr_leg_code;
146: per_rol_bus.g_role_id := p_role_id;
147: per_rol_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
152: --
153: -- ---------------------------------------------------------------------------

Line 201: hr_utility.set_location('Entering:'||l_proc, 1);

197: and p_effective_date between per.effective_start_date
198: and per.effective_end_date;
199: --
200: begin
201: hr_utility.set_location('Entering:'||l_proc, 1);
202: --
203: -- Check mandatory person_id is set
204: --
205: if p_person_id is null then

Line 206: hr_utility.set_message(800, 'HR_52891_INC_PERSON_ID_NULL');

202: --
203: -- Check mandatory person_id is set
204: --
205: if p_person_id is null then
206: hr_utility.set_message(800, 'HR_52891_INC_PERSON_ID_NULL');
207: hr_utility.raise_error;
208: end if;
209: --
210: hr_utility.set_location(l_proc, 5);

Line 207: hr_utility.raise_error;

203: -- Check mandatory person_id is set
204: --
205: if p_person_id is null then
206: hr_utility.set_message(800, 'HR_52891_INC_PERSON_ID_NULL');
207: hr_utility.raise_error;
208: end if;
209: --
210: hr_utility.set_location(l_proc, 5);
211: -- --

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

206: hr_utility.set_message(800, 'HR_52891_INC_PERSON_ID_NULL');
207: hr_utility.raise_error;
208: end if;
209: --
210: hr_utility.set_location(l_proc, 5);
211: -- --
212: if (p_role_id is null) then
213: hr_utility.set_location(l_proc, 10);
214: --

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

209: --
210: hr_utility.set_location(l_proc, 5);
211: -- --
212: if (p_role_id is null) then
213: hr_utility.set_location(l_proc, 10);
214: --
215: -- Check that the person_id is in the per_people_f view on the effective_date
216: --
217: open csr_person_id;

Line 221: hr_utility.set_message(800, 'HR_52896_INC_FK_NOT_FOUND');

217: open csr_person_id;
218: fetch csr_person_id into l_dummy;
219: if csr_person_id%notfound then
220: close csr_person_id;
221: hr_utility.set_message(800, 'HR_52896_INC_FK_NOT_FOUND');
222: hr_utility.raise_error;
223: end if;
224: close csr_person_id;
225: end if;

Line 222: hr_utility.raise_error;

218: fetch csr_person_id into l_dummy;
219: if csr_person_id%notfound then
220: close csr_person_id;
221: hr_utility.set_message(800, 'HR_52896_INC_FK_NOT_FOUND');
222: hr_utility.raise_error;
223: end if;
224: close csr_person_id;
225: end if;
226: --

Line 227: hr_utility.set_location(' Leaving:'||l_proc, 15);

223: end if;
224: close csr_person_id;
225: end if;
226: --
227: hr_utility.set_location(' Leaving:'||l_proc, 15);
228: --
229: end chk_person_id;
230:
231: -- ----------------------------------------------------------------------------

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

239: l_proc varchar2(72) := g_package||'chk_dates';
240: --
241: begin
242: --
243: hr_utility.set_location('Entering: '||l_proc,5);
244: --
245: if p_end_date is NOT NULL then
246: if p_start_date > p_end_date then
247: hr_utility.set_message(800,'PER_52675_END_START_DATE');

Line 247: hr_utility.set_message(800,'PER_52675_END_START_DATE');

243: hr_utility.set_location('Entering: '||l_proc,5);
244: --
245: if p_end_date is NOT NULL then
246: if p_start_date > p_end_date then
247: hr_utility.set_message(800,'PER_52675_END_START_DATE');
248: hr_utility.raise_error;
249: end if;
250: end if;
251: --

Line 248: hr_utility.raise_error;

244: --
245: if p_end_date is NOT NULL then
246: if p_start_date > p_end_date then
247: hr_utility.set_message(800,'PER_52675_END_START_DATE');
248: hr_utility.raise_error;
249: end if;
250: end if;
251: --
252: hr_utility.set_location('Leaving: '||l_proc,10);

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

248: hr_utility.raise_error;
249: end if;
250: end if;
251: --
252: hr_utility.set_location('Leaving: '||l_proc,10);
253: --
254: end chk_dates;
255:
256: -- ----------------------------------------------------------------------------

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

292: l_proc varchar2(72) := g_package||'chk_emp_rights';
293: --
294: begin
295: --
296: hr_utility.set_location('Entering: '||l_proc,5);
297: --
298: if p_end_of_rights_date is NOT NULL then
299: if p_emp_rights_flag = 'N' then
300: hr_utility.set_message(800,'PER_52676_EMP_RIGHTS_NO');

Line 300: hr_utility.set_message(800,'PER_52676_EMP_RIGHTS_NO');

296: hr_utility.set_location('Entering: '||l_proc,5);
297: --
298: if p_end_of_rights_date is NOT NULL then
299: if p_emp_rights_flag = 'N' then
300: hr_utility.set_message(800,'PER_52676_EMP_RIGHTS_NO');
301: hr_utility.raise_error;
302: elsif p_end_date is NOT NULL then
303: if p_end_of_rights_date < p_end_date then
304: hr_utility.set_message(800,'PER_52677_EMP_RIGHTS_DATE');

Line 301: hr_utility.raise_error;

297: --
298: if p_end_of_rights_date is NOT NULL then
299: if p_emp_rights_flag = 'N' then
300: hr_utility.set_message(800,'PER_52676_EMP_RIGHTS_NO');
301: hr_utility.raise_error;
302: elsif p_end_date is NOT NULL then
303: if p_end_of_rights_date < p_end_date then
304: hr_utility.set_message(800,'PER_52677_EMP_RIGHTS_DATE');
305: hr_utility.raise_error;

Line 304: hr_utility.set_message(800,'PER_52677_EMP_RIGHTS_DATE');

300: hr_utility.set_message(800,'PER_52676_EMP_RIGHTS_NO');
301: hr_utility.raise_error;
302: elsif p_end_date is NOT NULL then
303: if p_end_of_rights_date < p_end_date then
304: hr_utility.set_message(800,'PER_52677_EMP_RIGHTS_DATE');
305: hr_utility.raise_error;
306: end if;
307: end if;
308: end if;

Line 305: hr_utility.raise_error;

301: hr_utility.raise_error;
302: elsif p_end_date is NOT NULL then
303: if p_end_of_rights_date < p_end_date then
304: hr_utility.set_message(800,'PER_52677_EMP_RIGHTS_DATE');
305: hr_utility.raise_error;
306: end if;
307: end if;
308: end if;
309: --

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

306: end if;
307: end if;
308: end if;
309: --
310: hr_utility.set_location('Leaving: '||l_proc,10);
311: --
312: end chk_emp_rights;
313:
314: -- ----------------------------------------------------------------------------

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

375: and job_id = p_job_id;
376: --
377: begin
378: --
379: hr_utility.set_location('Entering: '||l_proc,5);
380: --
381: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
382: open csr_bg;
383: fetch csr_bg into l_person_bgid, l_jgr_bgid;

Line 385: hr_utility.set_message(800,'PER_52678_INV_BG');

381: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
382: open csr_bg;
383: fetch csr_bg into l_person_bgid, l_jgr_bgid;
384: if l_jgr_bgid <> l_person_bgid then
385: hr_utility.set_message(800,'PER_52678_INV_BG');
386: hr_utility.raise_error;
387: end if;
388: close csr_bg;
389: end if;

Line 386: hr_utility.raise_error;

382: open csr_bg;
383: fetch csr_bg into l_person_bgid, l_jgr_bgid;
384: if l_jgr_bgid <> l_person_bgid then
385: hr_utility.set_message(800,'PER_52678_INV_BG');
386: hr_utility.raise_error;
387: end if;
388: close csr_bg;
389: end if;
390: --

Line 394: hr_utility.set_message(800,'PER_52679_INV_JOB_GROUP');

390: --
391: open csr_valid_job_group;
392: fetch csr_valid_job_group into l_job_group;
393: if csr_valid_job_group%notfound then
394: hr_utility.set_message(800,'PER_52679_INV_JOB_GROUP');
395: hr_utility.raise_error;
396: else
397: open csr_job_in_jgr;
398: fetch csr_job_in_jgr into l_job_in_jgr;

Line 395: hr_utility.raise_error;

391: open csr_valid_job_group;
392: fetch csr_valid_job_group into l_job_group;
393: if csr_valid_job_group%notfound then
394: hr_utility.set_message(800,'PER_52679_INV_JOB_GROUP');
395: hr_utility.raise_error;
396: else
397: open csr_job_in_jgr;
398: fetch csr_job_in_jgr into l_job_in_jgr;
399: if csr_job_in_jgr%notfound then

Line 400: hr_utility.set_message(800,'PER_52680_ROLE_NOT_JGR');

396: else
397: open csr_job_in_jgr;
398: fetch csr_job_in_jgr into l_job_in_jgr;
399: if csr_job_in_jgr%notfound then
400: hr_utility.set_message(800,'PER_52680_ROLE_NOT_JGR');
401: hr_utility.raise_error;
402: end if;
403: close csr_job_in_jgr;
404: end if;

Line 401: hr_utility.raise_error;

397: open csr_job_in_jgr;
398: fetch csr_job_in_jgr into l_job_in_jgr;
399: if csr_job_in_jgr%notfound then
400: hr_utility.set_message(800,'PER_52680_ROLE_NOT_JGR');
401: hr_utility.raise_error;
402: end if;
403: close csr_job_in_jgr;
404: end if;
405: close csr_valid_job_group;

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

403: close csr_job_in_jgr;
404: end if;
405: close csr_valid_job_group;
406: --
407: hr_utility.set_location('Leaving: '||l_proc,10);
408: --
409: end chk_job_group;
410: --
411: -- ----------------------------------------------------------------------------

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

446: and organization_id = p_organization_id;
447: --
448: begin
449: --
450: hr_utility.set_location('Entering: '||l_proc,5);
451: --
452: if p_organization_id is NOT NULL then
453: open csr_rep_jgr;
454: fetch csr_rep_jgr into l_rep_jgr;

Line 456: hr_utility.set_message(800,'PER_52681_INV_REP_BODY');

452: if p_organization_id is NOT NULL then
453: open csr_rep_jgr;
454: fetch csr_rep_jgr into l_rep_jgr;
455: if csr_rep_jgr%notfound then
456: hr_utility.set_message(800,'PER_52681_INV_REP_BODY');
457: hr_utility.raise_error;
458: end if;
459: close csr_rep_jgr;
460: end if;

Line 457: hr_utility.raise_error;

453: open csr_rep_jgr;
454: fetch csr_rep_jgr into l_rep_jgr;
455: if csr_rep_jgr%notfound then
456: hr_utility.set_message(800,'PER_52681_INV_REP_BODY');
457: hr_utility.raise_error;
458: end if;
459: close csr_rep_jgr;
460: end if;
461: --

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

458: end if;
459: close csr_rep_jgr;
460: end if;
461: --
462: hr_utility.set_location('Entering: '||l_proc,10);
463: --
464: end chk_rep_body;
465: -- ----------------------------------------------------------------------------
466: -- |-----------------------< chk_flags >--------------------------------------|

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

494: l_proc varchar2(72) := g_package||'chk_flags';
495: --
496: begin
497: --
498: hr_utility.set_location('Entering: '||l_proc,5);
499: --
500: if p_primary_contact_flag is NOT NULL then
501: if p_primary_contact_flag not in ('Y','N') then
502: hr_utility.set_message(800,'PER_52682_PRIM_CON_FLAG');

Line 502: hr_utility.set_message(800,'PER_52682_PRIM_CON_FLAG');

498: hr_utility.set_location('Entering: '||l_proc,5);
499: --
500: if p_primary_contact_flag is NOT NULL then
501: if p_primary_contact_flag not in ('Y','N') then
502: hr_utility.set_message(800,'PER_52682_PRIM_CON_FLAG');
503: hr_utility.raise_error;
504: end if;
505: end if;
506: if p_emp_rights_flag is NOT NULL then

Line 503: hr_utility.raise_error;

499: --
500: if p_primary_contact_flag is NOT NULL then
501: if p_primary_contact_flag not in ('Y','N') then
502: hr_utility.set_message(800,'PER_52682_PRIM_CON_FLAG');
503: hr_utility.raise_error;
504: end if;
505: end if;
506: if p_emp_rights_flag is NOT NULL then
507: if p_emp_rights_flag not in('Y','N') then

Line 508: hr_utility.set_message(800,'PER_52683_EMP_RIGHTS_FLAG');

504: end if;
505: end if;
506: if p_emp_rights_flag is NOT NULL then
507: if p_emp_rights_flag not in('Y','N') then
508: hr_utility.set_message(800,'PER_52683_EMP_RIGHTS_FLAG');
509: hr_utility.raise_error;
510: end if;
511: end if;
512: --

Line 509: hr_utility.raise_error;

505: end if;
506: if p_emp_rights_flag is NOT NULL then
507: if p_emp_rights_flag not in('Y','N') then
508: hr_utility.set_message(800,'PER_52683_EMP_RIGHTS_FLAG');
509: hr_utility.raise_error;
510: end if;
511: end if;
512: --
513: hr_utility.set_location('Entering: '||l_proc,10);

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

509: hr_utility.raise_error;
510: end if;
511: end if;
512: --
513: hr_utility.set_location('Entering: '||l_proc,10);
514: --
515: end chk_flags;
516: -- ----------------------------------------------------------------------------
517: -- ----------------------------------------------------------------------------

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

548: --
549: l_proc varchar2(72) := g_package || 'chk_ddf';
550: --
551: begin
552: hr_utility.set_location('Entering:'||l_proc,10);
553: --
554: if ((p_rec.role_id is not null) and (
555: nvl(per_rol_shd.g_old_rec.role_information_category, hr_api.g_varchar2) <>
556: nvl(p_rec.role_information_category, hr_api.g_varchar2) or

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

647: ,p_attribute20_value => p_rec.role_information20
648: );
649: end if;
650: --
651: hr_utility.set_location(' Leaving:'||l_proc,20);
652: end chk_ddf;
653: --
654: -- ----------------------------------------------------------------------------
655: -- |------------------------------< chk_df >----------------------------------|

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

685: --
686: l_proc varchar2(72) := g_package || 'chk_df';
687: --
688: begin
689: hr_utility.set_location('Entering:'||l_proc,10);
690: --
691: if ((p_rec.role_id is not null) and (
692: nvl(per_rol_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

784: ,p_attribute20_value => p_rec.attribute20
785: );
786: end if;
787: --
788: hr_utility.set_location(' Leaving:'||l_proc,20);
789: end chk_df;
790: --
791: -- ----------------------------------------------------------------------------
792: -- |-----------------------< chk_non_updateable_args >------------------------|

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

864: --
865: l_proc varchar2(72) := g_package||'insert_validate';
866: --
867: Begin
868: hr_utility.set_location('Entering:'||l_proc, 5);
869: --
870: -- Call all supporting business operations
871: --
872: -- Call parent person table's set security group id function.

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

896: per_rol_bus.chk_ddf(p_rec);
897: --
898: per_rol_bus.chk_df(p_rec);
899: --
900: hr_utility.set_location(' Leaving:'||l_proc, 10);
901: End insert_validate;
902: --
903: -- ----------------------------------------------------------------------------
904: -- |---------------------------< update_validate >----------------------------|

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

910: --
911: l_proc varchar2(72) := g_package||'update_validate';
912: --
913: Begin
914: hr_utility.set_location('Entering:'||l_proc, 5);
915: --
916: -- Call all supporting business operations
917: --
918: per_rol_bus.chk_job_group(p_job_id => p_rec.job_id

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

947: per_rol_bus.chk_ddf(p_rec);
948: --
949: per_rol_bus.chk_df(p_rec);
950: --
951: hr_utility.set_location(' Leaving:'||l_proc, 10);
952: End update_validate;
953: --
954: -- ----------------------------------------------------------------------------
955: -- |---------------------------< delete_validate >----------------------------|

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

960: --
961: l_proc varchar2(72) := g_package||'delete_validate';
962: --
963: Begin
964: hr_utility.set_location('Entering:'||l_proc, 5);
965: --
966: -- Call all supporting business operations
967: --
968: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

964: hr_utility.set_location('Entering:'||l_proc, 5);
965: --
966: -- Call all supporting business operations
967: --
968: hr_utility.set_location(' Leaving:'||l_proc, 10);
969: End delete_validate;
970: --
971: -- Start of fix 2497485
972: -- ----------------------------------------------------------------------------