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

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

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

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

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

Line 152: hr_utility.set_location('job_group_id '||l_job_Group_id,1);

148: --
149: begin
150: --
151: l_job_Group_id := p_job_Group_id;
152: hr_utility.set_location('job_group_id '||l_job_Group_id,1);
153: hr_utility.set_location('Entering :'||l_proc,5);
154: --
155: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
156: open csr_disp_name_exists;

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

149: begin
150: --
151: l_job_Group_id := p_job_Group_id;
152: hr_utility.set_location('job_group_id '||l_job_Group_id,1);
153: hr_utility.set_location('Entering :'||l_proc,5);
154: --
155: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
156: open csr_disp_name_exists;
157: fetch csr_disp_name_exists into l_disp_name;

Line 160: hr_utility.set_message(800,'PER_52661_DIS_NAME_EXIST_BG');

156: open csr_disp_name_exists;
157: fetch csr_disp_name_exists into l_disp_name;
158: if csr_disp_name_exists%found then
159: close csr_disp_name_exists;
160: hr_utility.set_message(800,'PER_52661_DIS_NAME_EXIST_BG');
161: hr_utility.raise_error;
162: else open csr_int_name_exists;
163: fetch csr_int_name_exists into l_int_name;
164: if csr_int_name_exists%found then

Line 161: hr_utility.raise_error;

157: fetch csr_disp_name_exists into l_disp_name;
158: if csr_disp_name_exists%found then
159: close csr_disp_name_exists;
160: hr_utility.set_message(800,'PER_52661_DIS_NAME_EXIST_BG');
161: hr_utility.raise_error;
162: else open csr_int_name_exists;
163: fetch csr_int_name_exists into l_int_name;
164: if csr_int_name_exists%found then
165: close csr_int_name_exists;

Line 166: hr_utility.set_message(800,'PER_52662_INT_NAME_EXIST_BG');

162: else open csr_int_name_exists;
163: fetch csr_int_name_exists into l_int_name;
164: if csr_int_name_exists%found then
165: close csr_int_name_exists;
166: hr_utility.set_message(800,'PER_52662_INT_NAME_EXIST_BG');
167: hr_utility.raise_error;
168: end if;
169: close csr_int_name_exists;
170: end if;

Line 167: hr_utility.raise_error;

163: fetch csr_int_name_exists into l_int_name;
164: if csr_int_name_exists%found then
165: close csr_int_name_exists;
166: hr_utility.set_message(800,'PER_52662_INT_NAME_EXIST_BG');
167: hr_utility.raise_error;
168: end if;
169: close csr_int_name_exists;
170: end if;
171: close csr_disp_name_exists;

Line 177: hr_utility.set_message(800,'PER_52663_DISP_NAME_EXISTS');

173: open csr_disp_name_no_bg;
174: fetch csr_disp_name_no_bg into l_disp_name;
175: if csr_disp_name_no_bg%found then
176: close csr_disp_name_no_bg;
177: hr_utility.set_message(800,'PER_52663_DISP_NAME_EXISTS');
178: hr_utility.raise_error;
179: else open csr_int_name_no_bg;
180: fetch csr_int_name_no_bg into l_int_name;
181: if csr_int_name_no_bg%found then

Line 178: hr_utility.raise_error;

174: fetch csr_disp_name_no_bg into l_disp_name;
175: if csr_disp_name_no_bg%found then
176: close csr_disp_name_no_bg;
177: hr_utility.set_message(800,'PER_52663_DISP_NAME_EXISTS');
178: hr_utility.raise_error;
179: else open csr_int_name_no_bg;
180: fetch csr_int_name_no_bg into l_int_name;
181: if csr_int_name_no_bg%found then
182: close csr_int_name_no_bg;

Line 183: hr_utility.set_message(800,'PER_52664_INT_NAME_EXISTS');

179: else open csr_int_name_no_bg;
180: fetch csr_int_name_no_bg into l_int_name;
181: if csr_int_name_no_bg%found then
182: close csr_int_name_no_bg;
183: hr_utility.set_message(800,'PER_52664_INT_NAME_EXISTS');
184: hr_utility.raise_error;
185: end if;
186: close csr_disp_name_no_bg;
187: end if;

Line 184: hr_utility.raise_error;

180: fetch csr_int_name_no_bg into l_int_name;
181: if csr_int_name_no_bg%found then
182: close csr_int_name_no_bg;
183: hr_utility.set_message(800,'PER_52664_INT_NAME_EXISTS');
184: hr_utility.raise_error;
185: end if;
186: close csr_disp_name_no_bg;
187: end if;
188: close csr_int_name_no_bg;

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

187: end if;
188: close csr_int_name_no_bg;
189: end if;
190: --
191: hr_utility.set_location('Leaving :'||l_proc,10);
192: end chk_unique_jgr_name;
193:
194: -- ---------------------------------------------------------------------------
195: -- |--------------------------------------------------------|

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

250: l_proc varchar2(72) := g_package||'chk_master_flag';
251: --
252: begin
253: --
254: hr_utility.set_location('Entering: '||l_proc,5);
255: --
256: if p_master_flag = 'Y'
257: --and
258: --per_jgr_shd.g_old_rec.master_flag <> p_master_flag then

Line 266: hr_utility.set_message(800,'PER_52665_MASTER_FLAG_BG');

262: open csr_master_flag_bg;
263: fetch csr_master_flag_bg into l_flag_bg;
264: if csr_master_flag_bg%found then
265: close csr_master_flag_bg;
266: hr_utility.set_message(800,'PER_52665_MASTER_FLAG_BG');
267: hr_utility.raise_error;
268: end if;
269: close csr_master_flag_bg;
270: else

Line 267: hr_utility.raise_error;

263: fetch csr_master_flag_bg into l_flag_bg;
264: if csr_master_flag_bg%found then
265: close csr_master_flag_bg;
266: hr_utility.set_message(800,'PER_52665_MASTER_FLAG_BG');
267: hr_utility.raise_error;
268: end if;
269: close csr_master_flag_bg;
270: else
271: open csr_master_flag_no_bg;

Line 275: hr_utility.set_message(800,'PER_52666_MASTER_FLAG_NBG');

271: open csr_master_flag_no_bg;
272: fetch csr_master_flag_no_bg into l_flag_no_bg;
273: if csr_master_flag_no_bg%found then
274: close csr_master_flag_no_bg;
275: hr_utility.set_message(800,'PER_52666_MASTER_FLAG_NBG');
276: hr_utility.raise_error;
277: end if;
278: close csr_master_flag_no_bg;
279: end if;

Line 276: hr_utility.raise_error;

272: fetch csr_master_flag_no_bg into l_flag_no_bg;
273: if csr_master_flag_no_bg%found then
274: close csr_master_flag_no_bg;
275: hr_utility.set_message(800,'PER_52666_MASTER_FLAG_NBG');
276: hr_utility.raise_error;
277: end if;
278: close csr_master_flag_no_bg;
279: end if;
280: --

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

277: end if;
278: close csr_master_flag_no_bg;
279: end if;
280: --
281: hr_utility.set_location('Leaving: '||l_proc,10);
282: --
283: end if;
284: --
285: end chk_master_flag;

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

320: l_proc varchar2(72) := g_package||'chk_object_version_number';
321: --
322: begin
323: --
324: hr_utility.set_location('Entering:'||l_proc, 1);
325: --
326: -- Check mandatory parameters have been set
327: --
328: hr_api.mandatory_arg_error

Line 334: hr_utility.set_location(' Leaving:'||l_proc, 3);

330: ,p_argument => 'object_version_number'
331: ,p_argument_value => p_object_version_number
332: );
333: --
334: hr_utility.set_location(' Leaving:'||l_proc, 3);
335: --
336: end chk_object_version_number;
337: --
338: -- ---------------------------------------------------------------------------

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

389: l_rep_body varchar2(30);
390: l_proc varchar2(72) := g_package||'chk_object_version_number';
391: --
392: begin
393: hr_utility.set_location('Entering: '||l_proc,5);
394: open csr_hr_jobgroup;
395: fetch csr_hr_jobgroup into l_hr_jobgroup;
396: if csr_hr_jobgroup%found then
397: hr_utility.set_message(800,'PER_52667_DEL_HR_JGR');

Line 397: hr_utility.set_message(800,'PER_52667_DEL_HR_JGR');

393: hr_utility.set_location('Entering: '||l_proc,5);
394: open csr_hr_jobgroup;
395: fetch csr_hr_jobgroup into l_hr_jobgroup;
396: if csr_hr_jobgroup%found then
397: hr_utility.set_message(800,'PER_52667_DEL_HR_JGR');
398: hr_utility.raise_error;
399: end if;
400: close csr_hr_jobgroup;
401: open csr_jobs_exist;

Line 398: hr_utility.raise_error;

394: open csr_hr_jobgroup;
395: fetch csr_hr_jobgroup into l_hr_jobgroup;
396: if csr_hr_jobgroup%found then
397: hr_utility.set_message(800,'PER_52667_DEL_HR_JGR');
398: hr_utility.raise_error;
399: end if;
400: close csr_hr_jobgroup;
401: open csr_jobs_exist;
402: fetch csr_jobs_exist into l_jobs_exist;

Line 404: hr_utility.set_message(800,'PER_52668_JGR_JOB_EXIST');

400: close csr_hr_jobgroup;
401: open csr_jobs_exist;
402: fetch csr_jobs_exist into l_jobs_exist;
403: if csr_jobs_exist%found then
404: hr_utility.set_message(800,'PER_52668_JGR_JOB_EXIST');
405: hr_utility.raise_error;
406: end if;
407: close csr_jobs_exist;
408: open csr_rep_body;

Line 405: hr_utility.raise_error;

401: open csr_jobs_exist;
402: fetch csr_jobs_exist into l_jobs_exist;
403: if csr_jobs_exist%found then
404: hr_utility.set_message(800,'PER_52668_JGR_JOB_EXIST');
405: hr_utility.raise_error;
406: end if;
407: close csr_jobs_exist;
408: open csr_rep_body;
409: fetch csr_rep_body into l_rep_body;

Line 411: hr_utility.set_message(800,'PER_52685_JGR_REP_DEL');

407: close csr_jobs_exist;
408: open csr_rep_body;
409: fetch csr_rep_body into l_rep_body;
410: if csr_rep_body%found then
411: hr_utility.set_message(800,'PER_52685_JGR_REP_DEL');
412: hr_utility.raise_error;
413: end if;
414: close csr_rep_body;
415: --

Line 412: hr_utility.raise_error;

408: open csr_rep_body;
409: fetch csr_rep_body into l_rep_body;
410: if csr_rep_body%found then
411: hr_utility.set_message(800,'PER_52685_JGR_REP_DEL');
412: hr_utility.raise_error;
413: end if;
414: close csr_rep_body;
415: --
416: hr_utility.set_location('Leaving: '||l_proc,10);

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

412: hr_utility.raise_error;
413: end if;
414: close csr_rep_body;
415: --
416: hr_utility.set_location('Leaving: '||l_proc,10);
417: --
418: end chk_delete_jgr;
419: --
420: -- ---------------------------------------------------------------------------

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

455: and fnd.id_flex_num = p_id_flex_num;
456: --
457: begin
458: --
459: hr_utility.set_location('Entering: '||l_proc,5);
460: --
461: if p_id_flex_num is not null then
462: open csr_job_structure;
463: fetch csr_job_structure into l_job_structure;

Line 466: hr_utility.set_message(800,'PER_52671_JOB_STRUC_INV');

462: open csr_job_structure;
463: fetch csr_job_structure into l_job_structure;
464: if csr_job_structure%notfound then
465: close csr_job_structure;
466: hr_utility.set_message(800,'PER_52671_JOB_STRUC_INV');
467: hr_utility.raise_error;
468: end if;
469: close csr_job_structure;
470: --

Line 467: hr_utility.raise_error;

463: fetch csr_job_structure into l_job_structure;
464: if csr_job_structure%notfound then
465: close csr_job_structure;
466: hr_utility.set_message(800,'PER_52671_JOB_STRUC_INV');
467: hr_utility.raise_error;
468: end if;
469: close csr_job_structure;
470: --
471: end if;

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

469: close csr_job_structure;
470: --
471: end if;
472: --
473: hr_utility.set_location('Leaving: '||l_proc,10);
474: --
475: end chk_job_structure;
476: --
477: -- ---------------------------------------------------------------------------

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

498: l_proc varchar2(72) := g_package||'return_legislation_code';
499: --
500: Begin
501: --
502: hr_utility.set_location('Entering:'|| l_proc, 10);
503: --
504: -- Ensure that all the mandatory parameter are not null
505: --
506: hr_api.mandatory_arg_error

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

516: -- call to this function. Just return the value in the global
517: -- variable.
518: --
519: l_legislation_code := per_jgr_bus.g_legislation_code;
520: hr_utility.set_location(l_proc, 20);
521: else
522: --
523: -- The ID is different to the last call to this function
524: -- or this is the first call to this function.

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

533: close csr_leg_code;
534: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
535: fnd_message.raise_error;
536: end if;
537: hr_utility.set_location(l_proc,30);
538: --
539: -- Set the global variables so the values are
540: -- available for the next call to this function.
541: --

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

542: close csr_leg_code;
543: per_jgr_bus.g_job_group_id := p_job_group_id;
544: per_jgr_bus.g_legislation_code := l_legislation_code;
545: end if;
546: hr_utility.set_location(' Leaving:'|| l_proc, 40);
547: return l_legislation_code;
548: end return_legislation_code;
549: --
550: -- ----------------------------------------------------------------------------

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

599: --
600: -- EDIT_HERE: Add checks to ensure non-updateable args have
601: -- not been updated.
602: --
603: hr_utility.set_location(l_proc, 30);
604: --
605: EXCEPTION
606: WHEN l_error THEN
607: hr_api.argument_changed_error

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

621: --
622: l_proc varchar2(72) := g_package||'insert_validate';
623: --
624: Begin
625: hr_utility.set_location('Entering:'||l_proc, 5);
626: --
627: -- Call all supporting business operations
628: --
629: if p_rec.business_group_id is not null then

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

640: ,p_master_flag => p_rec.master_flag);
641: --
642: per_jgr_bus.chk_job_structure(p_id_flex_num => p_rec.id_flex_num);
643: --
644: hr_utility.set_location(' Leaving:'||l_proc, 10);
645: End insert_validate;
646: --
647: -- ----------------------------------------------------------------------------
648: -- |---------------------------< update_validate >----------------------------|

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

654: --
655: l_proc varchar2(72) := g_package||'update_validate';
656: --
657: Begin
658: hr_utility.set_location('Entering:'||l_proc, 5);
659: --
660: -- Call all supporting business operations
661: --
662: if p_rec.business_group_id is not null then

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

681: (p_rec => p_rec
682: );
683: --
684: --
685: hr_utility.set_location(' Leaving:'||l_proc, 10);
686: End update_validate;
687: --
688: -- ----------------------------------------------------------------------------
689: -- |---------------------------< delete_validate >----------------------------|

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

695: l_proc varchar2(72) := g_package||'delete_validate';
696: l_int varchar2(30);
697: --
698: Begin
699: hr_utility.set_location('Entering:'||l_proc, 5);
700: --
701: -- Call all supporting business operations
702: --
703: l_int := p_rec.internal_name;

Line 704: hr_utility.set_location('internal_name '||l_int,7);

700: --
701: -- Call all supporting business operations
702: --
703: l_int := p_rec.internal_name;
704: hr_utility.set_location('internal_name '||l_int,7);
705: --
706: chk_delete_jgr
707: (p_job_group_id => p_rec.job_group_id);
708: --

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

710: --
711: chk_object_version_number
712: (p_object_version_number => p_rec.object_version_number);
713: --
714: hr_utility.set_location(' Leaving:'||l_proc, 10);
715: End delete_validate;
716: --
717: end per_jgr_bus;