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

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

69: and p_job_id = pjr.job_id
70: and p_analysis_criteria_id = pjr.analysis_criteria_id;
71: --
72: begin
73: hr_utility.set_location('Entering :'||l_proc,1);
74: --
75: l_api_updating :=
76: per_jbr_shd.api_updating
77: (p_job_requirement_id => p_job_requirement_id,

Line 88: hr_utility.set_location(l_proc,2);

84: (not l_api_updating)) then
85: --
86: -- Checks that job is valid
87: --
88: hr_utility.set_location(l_proc,2);
89: --
90: open csr_job_exists;
91: fetch csr_job_exists into l_exists;
92: if csr_job_exists%notfound then

Line 94: hr_utility.set_message(801,'HR_51090_JOB_NOT_EXIST');

90: open csr_job_exists;
91: fetch csr_job_exists into l_exists;
92: if csr_job_exists%notfound then
93: close csr_job_exists;
94: hr_utility.set_message(801,'HR_51090_JOB_NOT_EXIST');
95: hr_utility.raise_error;
96: else
97: close csr_job_exists;
98: end if;

Line 95: hr_utility.raise_error;

91: fetch csr_job_exists into l_exists;
92: if csr_job_exists%notfound then
93: close csr_job_exists;
94: hr_utility.set_message(801,'HR_51090_JOB_NOT_EXIST');
95: hr_utility.raise_error;
96: else
97: close csr_job_exists;
98: end if;
99: --

Line 103: hr_utility.set_location(l_proc,3);

99: --
100: --
101: -- Checks the combination of job and analysis criteria
102: --
103: hr_utility.set_location(l_proc,3);
104: open csr_combo_exists;
105: fetch csr_combo_exists into l_exists;
106: if csr_combo_exists%found then
107: close csr_combo_exists;

Line 108: hr_utility.set_message(801,'HR_51109_JBR_ALREADY_EXISTS');

104: open csr_combo_exists;
105: fetch csr_combo_exists into l_exists;
106: if csr_combo_exists%found then
107: close csr_combo_exists;
108: hr_utility.set_message(801,'HR_51109_JBR_ALREADY_EXISTS');
109: hr_utility.raise_error;
110: else
111: close csr_combo_exists;
112: end if;

Line 109: hr_utility.raise_error;

105: fetch csr_combo_exists into l_exists;
106: if csr_combo_exists%found then
107: close csr_combo_exists;
108: hr_utility.set_message(801,'HR_51109_JBR_ALREADY_EXISTS');
109: hr_utility.raise_error;
110: else
111: close csr_combo_exists;
112: end if;
113: --

Line 115: hr_utility.set_location('Leaving:'||l_proc,4);

111: close csr_combo_exists;
112: end if;
113: --
114: end if;
115: hr_utility.set_location('Leaving:'||l_proc,4);
116: end chk_job_id;
117: --
118: -- ----------------------------------------------------------------------------
119: -- |----------------------< chk_position_id >---------------------------------|

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

178: and p_position_id = pjr.position_id
179: and p_analysis_criteria_id = pjr.analysis_criteria_id;
180: --
181: begin
182: hr_utility.set_location('Entering :'||l_proc,1);
183: l_api_updating :=
184: per_jbr_shd.api_updating
185: (p_job_requirement_id => p_job_requirement_id,
186: p_object_version_number => p_object_version_number);

Line 196: hr_utility.set_location(l_proc,2);

192: (not l_api_updating)) then
193: --
194: -- Checks that position is valid
195: --
196: hr_utility.set_location(l_proc,2);
197: open csr_position_exists;
198: fetch csr_position_exists into l_exists;
199: if csr_position_exists%notfound then
200: close csr_position_exists;

Line 201: hr_utility.set_message(801,'HR_51093_POS_NOT_EXIST');

197: open csr_position_exists;
198: fetch csr_position_exists into l_exists;
199: if csr_position_exists%notfound then
200: close csr_position_exists;
201: hr_utility.set_message(801,'HR_51093_POS_NOT_EXIST');
202: hr_utility.raise_error;
203: else
204: close csr_position_exists;
205: end if;

Line 202: hr_utility.raise_error;

198: fetch csr_position_exists into l_exists;
199: if csr_position_exists%notfound then
200: close csr_position_exists;
201: hr_utility.set_message(801,'HR_51093_POS_NOT_EXIST');
202: hr_utility.raise_error;
203: else
204: close csr_position_exists;
205: end if;
206: --

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

206: --
207: --
208: -- Checks the combination of position and analysis criteria
209: --
210: hr_utility.set_location(l_proc,3);
211: open csr_pos_combo_exists;
212: fetch csr_pos_combo_exists into l_exists;
213: if csr_pos_combo_exists%found then
214: close csr_pos_combo_exists;

Line 215: hr_utility.set_message(801,'HR_51110_JBR_POS_ALREADY_EXIS');

211: open csr_pos_combo_exists;
212: fetch csr_pos_combo_exists into l_exists;
213: if csr_pos_combo_exists%found then
214: close csr_pos_combo_exists;
215: hr_utility.set_message(801,'HR_51110_JBR_POS_ALREADY_EXIS');
216: hr_utility.raise_error;
217: else
218: close csr_pos_combo_exists;
219: end if;

Line 216: hr_utility.raise_error;

212: fetch csr_pos_combo_exists into l_exists;
213: if csr_pos_combo_exists%found then
214: close csr_pos_combo_exists;
215: hr_utility.set_message(801,'HR_51110_JBR_POS_ALREADY_EXIS');
216: hr_utility.raise_error;
217: else
218: close csr_pos_combo_exists;
219: end if;
220: end if;

Line 222: hr_utility.set_location('Leaving:'||l_proc,4);

218: close csr_pos_combo_exists;
219: end if;
220: end if;
221: --
222: hr_utility.set_location('Leaving:'||l_proc,4);
223: end chk_position_id;
224: --
225: -- ----------------------------------------------------------------------------
226: -- |---------------< chk_analysis_criteria_id >-------------------------------|

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

265: begin
266: --
267: -- Checks that analysis criteria is not null
268: --
269: hr_utility.set_location('Entering:'||l_proc,1);
270: --
271: hr_api.mandatory_arg_error(p_api_name => l_proc,
272: p_argument => 'analysis_criteria_id',
273: p_argument_value => p_analysis_criteria_id);

Line 275: hr_utility.set_location(l_proc,2);

271: hr_api.mandatory_arg_error(p_api_name => l_proc,
272: p_argument => 'analysis_criteria_id',
273: p_argument_value => p_analysis_criteria_id);
274: --
275: hr_utility.set_location(l_proc,2);
276: l_api_updating :=
277: per_jbr_shd.api_updating
278: (p_job_requirement_id => p_job_requirement_id,
279: p_object_version_number => p_object_version_number);

Line 289: hr_utility.set_location(l_proc, 3);

285: --
286: --
287: -- Checks that analysis criteria is valid
288: --
289: hr_utility.set_location(l_proc, 3);
290: --
291: open csr_criteria_exists;
292: fetch csr_criteria_exists into l_exists;
293: if csr_criteria_exists%notfound then

Line 295: hr_utility.set_message(801,'HR_51111_JBR_A_CR_NOT_EXIS');

291: open csr_criteria_exists;
292: fetch csr_criteria_exists into l_exists;
293: if csr_criteria_exists%notfound then
294: close csr_criteria_exists;
295: hr_utility.set_message(801,'HR_51111_JBR_A_CR_NOT_EXIS');
296: hr_utility.raise_error;
297: else
298: close csr_criteria_exists;
299: end if;

Line 296: hr_utility.raise_error;

292: fetch csr_criteria_exists into l_exists;
293: if csr_criteria_exists%notfound then
294: close csr_criteria_exists;
295: hr_utility.set_message(801,'HR_51111_JBR_A_CR_NOT_EXIS');
296: hr_utility.raise_error;
297: else
298: close csr_criteria_exists;
299: end if;
300: end if;

Line 302: hr_utility.set_location('Leaving:'||l_proc,4);

298: close csr_criteria_exists;
299: end if;
300: end if;
301: --
302: hr_utility.set_location('Leaving:'||l_proc,4);
303: end chk_analysis_criteria_id;
304: --
305: -- ----------------------------------------------------------------------------
306: -- |-------------------------< chk_job_pos >----------------------------------|

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

348: --
349: l_proc varchar2(72) := g_package||'chk_job_pos';
350: --
351: begin
352: hr_utility.set_location(' Entering:'||l_proc,1);
353: --
354: if (p_position_id is not null AND p_job_id is null) then
355: chk_position_id(p_job_requirement_id => p_job_requirement_id,
356: p_object_version_number => p_object_version_number,

Line 367: hr_utility.set_message(801, 'HR_51112_JBR_JOB_OR_POS');

363: p_job_id => p_job_id,
364: p_analysis_criteria_id => p_analysis_criteria_id,
365: p_business_group_id => p_business_group_id);
366: else
367: hr_utility.set_message(801, 'HR_51112_JBR_JOB_OR_POS');
368: hr_utility.raise_error;
369: end if;
370: --
371: hr_utility.set_location(' Leaving:'||l_proc,2);

Line 368: hr_utility.raise_error;

364: p_analysis_criteria_id => p_analysis_criteria_id,
365: p_business_group_id => p_business_group_id);
366: else
367: hr_utility.set_message(801, 'HR_51112_JBR_JOB_OR_POS');
368: hr_utility.raise_error;
369: end if;
370: --
371: hr_utility.set_location(' Leaving:'||l_proc,2);
372: end chk_job_pos;

Line 371: hr_utility.set_location(' Leaving:'||l_proc,2);

367: hr_utility.set_message(801, 'HR_51112_JBR_JOB_OR_POS');
368: hr_utility.raise_error;
369: end if;
370: --
371: hr_utility.set_location(' Leaving:'||l_proc,2);
372: end chk_job_pos;
373: --
374: -- ----------------------------------------------------------------------------
375: -- |------------------------< chk_essential >---------------------------------|

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

411: and hl.lookup_code = p_essential;
412: --
413: begin
414: --
415: hr_utility.set_location('Entering :'||l_proc,1);
416: --
417: hr_api.mandatory_arg_error(p_api_name => l_proc,
418: p_argument => 'essential',
419: p_argument_value => p_essential);

Line 421: hr_utility.set_location(l_proc,2);

417: hr_api.mandatory_arg_error(p_api_name => l_proc,
418: p_argument => 'essential',
419: p_argument_value => p_essential);
420: --
421: hr_utility.set_location(l_proc,2);
422:
423: l_api_updating :=
424: per_jbr_shd.api_updating
425: (p_job_requirement_id => p_job_requirement_id,

Line 432: hr_utility.set_location(l_proc,3);

428: if ((l_api_updating and
429: per_jbr_shd.g_old_rec.essential <> p_essential) or
430: (not l_api_updating)) then
431: --
432: hr_utility.set_location(l_proc,3);
433: --
434: open csr_essential;
435: fetch csr_essential into l_exists;
436: if csr_essential%notfound then

Line 437: hr_utility.set_message(801, 'HR_51113_JBR_ESSENTIAL');

433: --
434: open csr_essential;
435: fetch csr_essential into l_exists;
436: if csr_essential%notfound then
437: hr_utility.set_message(801, 'HR_51113_JBR_ESSENTIAL');
438: hr_utility.raise_error;
439: end if;
440: close csr_essential;
441: end if;

Line 438: hr_utility.raise_error;

434: open csr_essential;
435: fetch csr_essential into l_exists;
436: if csr_essential%notfound then
437: hr_utility.set_message(801, 'HR_51113_JBR_ESSENTIAL');
438: hr_utility.raise_error;
439: end if;
440: close csr_essential;
441: end if;
442: --

Line 443: hr_utility.set_location(' Leaving :'||l_proc,4);

439: end if;
440: close csr_essential;
441: end if;
442: --
443: hr_utility.set_location(' Leaving :'||l_proc,4);
444: --
445: end chk_essential;
446: --
447: --

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

477: --
478: l_proc varchar2(72) := g_package||'chk_df';
479: --
480: begin
481: hr_utility.set_location('Entering:'||l_proc, 10);
482: --
483: if ((p_rec.job_requirement_id is not null) and (
484: nvl(per_jbr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
485: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

577: ,p_attribute20_value => p_rec.attribute20
578: );
579: end if;
580: --
581: hr_utility.set_location(' Leaving:'||l_proc, 20);
582: end chk_df;
583: --
584: -- ---------------------------------------------------------------------------
585: -- |--------------------------< insert_validate >----------------------------|

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

588: --
589: l_proc varchar2(72) := g_package||'insert_validate';
590: --
591: Begin
592: hr_utility.set_location('Entering:'||l_proc, 5);
593: --
594: -- Call all supporting business operations
595: --
596: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

610: -- Call descriptive flexfield validation routines
611: --
612: per_jbr_bus.chk_df(p_rec => p_rec);
613: --
614: hr_utility.set_location(' Leaving:'||l_proc, 10);
615: End insert_validate;
616: --
617: -- ---------------------------------------------------------------------------
618: -- |--------------------------< update_validate >----------------------------|

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

621: --
622: l_proc varchar2(72) := g_package||'update_validate';
623: --
624: Begin
625: hr_utility.set_location('Entering:'||l_proc, 5);
626: --
627: -- Call all supporting business operations
628: --
629: -- Validate Business Group

Line 633: hr_utility.set_location(l_proc, 6);

629: -- Validate Business Group
630: --
631: hr_api.validate_bus_grp_id(p_rec.business_group_id);
632: --
633: hr_utility.set_location(l_proc, 6);
634: --
635: chk_analysis_criteria_id
636: (p_job_requirement_id => p_rec.job_requirement_id,
637: p_object_version_number => p_rec.object_version_number,

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

653: -- Call descriptive flexfield validation routines
654: --
655: per_jbr_bus.chk_df(p_rec => p_rec);
656: --
657: hr_utility.set_location(' Leaving:'||l_proc, 10);
658: End update_validate;
659: --
660: -- ---------------------------------------------------------------------------
661: -- |--------------------------< delete_validate >----------------------------|

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

664: --
665: l_proc varchar2(72) := g_package||'delete_validate';
666: --
667: Begin
668: hr_utility.set_location('Entering:'||l_proc, 5);
669: --
670: -- Call all supporting business operations
671: --
672: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

668: hr_utility.set_location('Entering:'||l_proc, 5);
669: --
670: -- Call all supporting business operations
671: --
672: hr_utility.set_location(' Leaving:'||l_proc, 10);
673: End delete_validate;
674: --
675: end per_jbr_bus;