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

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

15: l_argument varchar2(30);
16: --
17: Begin
18: l_proc := g_package || 'chk_non_updateable_args';
19: hr_utility.set_location( ' Entering:' ||l_proc, 10);
20: --
21: -- Only proceed with validation of a row exists for
22: -- the current record in the HR schema
23: --

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

24: if not ghr_prh_shd.api_updating
25: (p_pa_routing_history_id => p_rec.pa_routing_history_id
26: ,p_object_version_number => p_rec.object_version_number
27: ) then
28: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message('PROCEDURE',l_proc);
30: hr_utility.set_message('STEP', '20');
31: end if;
32: hr_utility.set_location(l_proc,30);

Line 29: hr_utility.set_message('PROCEDURE',l_proc);

25: (p_pa_routing_history_id => p_rec.pa_routing_history_id
26: ,p_object_version_number => p_rec.object_version_number
27: ) then
28: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message('PROCEDURE',l_proc);
30: hr_utility.set_message('STEP', '20');
31: end if;
32: hr_utility.set_location(l_proc,30);
33: --

Line 30: hr_utility.set_message('STEP', '20');

26: ,p_object_version_number => p_rec.object_version_number
27: ) then
28: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message('PROCEDURE',l_proc);
30: hr_utility.set_message('STEP', '20');
31: end if;
32: hr_utility.set_location(l_proc,30);
33: --
34: if nvl(p_rec.pa_request_id,hr_api.g_number)

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

28: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message('PROCEDURE',l_proc);
30: hr_utility.set_message('STEP', '20');
31: end if;
32: hr_utility.set_location(l_proc,30);
33: --
34: if nvl(p_rec.pa_request_id,hr_api.g_number)
35: <> nvl(ghr_prh_shd.g_old_rec.pa_request_id,hr_api.g_number) then
36: l_argument := 'pa_request_id';

Line 63: hr_utility.set_location(l_proc,40);

59: l_argument := 'nature_of_action_id';
60: raise l_error;
61: end if;
62: */
63: hr_utility.set_location(l_proc,40);
64: --
65: exception
66: when l_error then
67: hr_api.argument_changed_error

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

112: where par.pa_request_id = p_pa_request_id;
113: --
114: begin
115: l_proc := g_package||'chk_pa_request_id';
116: hr_utility.set_location('Entering:'|| l_proc, 10);
117: --
118: -- Check mandatory parameters have been set
119: --
120: hr_api.mandatory_arg_error

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

122: ,p_argument => 'pa_request_id'
123: ,p_argument_value => p_pa_request_id
124: );
125: --
126: hr_utility.set_location(l_proc, 20);
127: --
128: -- Only proceed with validation if:
129: -- a) The current g_old_rec is current and
130: -- b) The routing status value has changed

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

133: l_api_updating := ghr_prh_shd.api_updating
134: (p_pa_routing_history_id => p_pa_routing_history_id
135: ,p_object_version_number => p_object_version_number
136: );
137: hr_utility.set_location(l_proc, 30);
138: --
139: if ((l_api_updating
140: and nvl(ghr_prh_shd.g_old_rec.pa_request_id, hr_api.g_number)
141: <> nvl(p_pa_request_id,hr_api.g_number))

Line 145: hr_utility.set_location(l_proc, 40);

141: <> nvl(p_pa_request_id,hr_api.g_number))
142: or
143: (NOT l_api_updating))
144: then
145: hr_utility.set_location(l_proc, 40);
146: --
147: -- Check if pa_request_id is valid
148: --
149: for rec in c_pa_req_id loop

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

154: ghr_prh_shd.constraint_error(p_constraint_name => 'GHR_PA_ROUTING_HIST_FK1');
155: end if;
156: end if;
157: --
158: hr_utility.set_location(' Leaving:'|| l_proc, 3);
159: end chk_pa_request_id;
160:
161:
162:

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

207: and gbx.groupbox_id = p_groupbox_id;
208: --
209: begin
210: l_proc := g_package||'chk_groupbox_id';
211: hr_utility.set_location('Entering:'|| l_proc, 1);
212: --
213: -- Check mandatory parameters have been set
214: hr_api.mandatory_arg_error
215: (p_api_name => l_proc

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

228: if ((l_api_updating and nvl(ghr_prh_shd.g_old_rec.groupbox_id,hr_api.g_number)
229: <> nvl(p_groupbox_id,hr_api.g_number))
230: or (NOT l_api_updating)) then
231: --
232: hr_utility.set_location(l_proc, 2);
233: --
234: -- check if the groupbox_id exists for the
235: -- routing_group_id
236: if p_groupbox_id is not null then

Line 243: hr_utility.set_location('value before raising invalid group box error'||l_grp_box,2222);

239: exit;
240: end loop;
241: --bug 4896738 skip checking for group box if it comes from process futures..
242:
243: hr_utility.set_location('value before raising invalid group box error'||l_grp_box,2222);
244: if not l_exists then
245: hr_utility.set_message(8301,'GHR_38101_INV_GROUPBOX_ID');
246: hr_utility.raise_error;
247:

Line 245: hr_utility.set_message(8301,'GHR_38101_INV_GROUPBOX_ID');

241: --bug 4896738 skip checking for group box if it comes from process futures..
242:
243: hr_utility.set_location('value before raising invalid group box error'||l_grp_box,2222);
244: if not l_exists then
245: hr_utility.set_message(8301,'GHR_38101_INV_GROUPBOX_ID');
246: hr_utility.raise_error;
247:
248: end if;
249: end if;

Line 246: hr_utility.raise_error;

242:
243: hr_utility.set_location('value before raising invalid group box error'||l_grp_box,2222);
244: if not l_exists then
245: hr_utility.set_message(8301,'GHR_38101_INV_GROUPBOX_ID');
246: hr_utility.raise_error;
247:
248: end if;
249: end if;
250: --

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

249: end if;
250: --
251: end if;
252: --
253: hr_utility.set_location(' Leaving:'|| l_proc, 3);
254: end chk_groupbox_id;
255:
256: -- ----------------------------------------------------------------------------
257: -- |---------------------------< chk_user_name>----------------------------|

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

303: where upper(user_name) = upper(p_user_name);
304:
305: begin
306: l_proc := g_package ||'chk_user_name';
307: hr_utility.set_location('Entering:'||l_proc,10);
308: --
309: -- Only proceed with validation if:
310: -- a) The current g_old_rec is current and
311: -- b) routing_user_name has changed

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

321: <> nvl(p_user_name,hr_api.g_varchar2))
322: or (NOT l_api_updating)) then
323:
324: --
325: hr_utility.set_location(l_proc, 2);
326: --
327: -- check if the user_name is valid
328: if p_user_name is not null then
329: if p_groupbox_id is not null then

Line 339: hr_utility.set_message(8301,'GHR_38103_INV_GROUPBOX_USER');

335: l_exists := true;
336: /*End Bug:6624155*/
337: --bug# 4896738
338: if not l_exists and not ghr_proc_fut_mt.g_skip_grp_box then
339: hr_utility.set_message(8301,'GHR_38103_INV_GROUPBOX_USER');
340: hr_utility.raise_error;
341: end if;
342: end if;
343: l_exists := false;

Line 340: hr_utility.raise_error;

336: /*End Bug:6624155*/
337: --bug# 4896738
338: if not l_exists and not ghr_proc_fut_mt.g_skip_grp_box then
339: hr_utility.set_message(8301,'GHR_38103_INV_GROUPBOX_USER');
340: hr_utility.raise_error;
341: end if;
342: end if;
343: l_exists := false;
344: for c_user_name_rec in c_user_name loop

Line 349: hr_utility.set_message(8301,'GHR_38102_INV_USER_NAME');

345: l_exists := true;
346: exit;
347: end loop;
348: if not l_exists then
349: hr_utility.set_message(8301,'GHR_38102_INV_USER_NAME');
350: hr_utility.raise_error;
351: end if;
352: end if;
353: end if;

Line 350: hr_utility.raise_error;

346: exit;
347: end loop;
348: if not l_exists then
349: hr_utility.set_message(8301,'GHR_38102_INV_USER_NAME');
350: hr_utility.raise_error;
351: end if;
352: end if;
353: end if;
354: --

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

351: end if;
352: end if;
353: end if;
354: --
355: hr_utility.set_location(' Leaving:'|| l_proc, 3);
356: end chk_user_name;
357: --
358:
359:

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

397: from ghr_routing_lists prl
398: where prl.routing_list_id = p_routing_list_id;
399: --
400: begin
401: hr_utility.set_location('Entering:'|| l_proc, 10);
402: --
403: -- Check mandatory parameters have been set
404: --
405: hr_utility.set_location(l_proc, 20);

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

401: hr_utility.set_location('Entering:'|| l_proc, 10);
402: --
403: -- Check mandatory parameters have been set
404: --
405: hr_utility.set_location(l_proc, 20);
406: -- Only proceed with validation if:
407: -- a) The current g_old_rec is current and
408: -- b) The routing status value has changed
409: -- c) a record is being inserted

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

411: l_api_updating := ghr_prh_shd.api_updating
412: (p_pa_routing_history_id => p_pa_routing_history_id
413: ,p_object_version_number => p_object_version_number
414: );
415: hr_utility.set_location(l_proc, 30);
416: --
417: if ((l_api_updating
418: and nvl(ghr_prh_shd.g_old_rec.routing_list_id, hr_api.g_number)
419: <> nvl(p_routing_list_id,hr_api.g_number))

Line 423: hr_utility.set_location(l_proc, 40);

419: <> nvl(p_routing_list_id,hr_api.g_number))
420: or
421: (NOT l_api_updating))
422: then
423: hr_utility.set_location(l_proc, 40);
424: --
425: -- Check if p_routing_list_id is valid
426: --
427: if p_routing_list_id is not null then

Line 437: hr_utility.set_location(' Leaving:'|| l_proc, 50);

433: end if;
434: end if;
435: end if;
436: --
437: hr_utility.set_location(' Leaving:'|| l_proc, 50);
438: end chk_routing_list_id;
439: --
440:
441:

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

484: where rlm.routing_list_id = p_routing_list_id
485: and rlm.seq_number = p_routing_seq_number;
486:
487: begin
488: hr_utility.set_location('Entering:'|| l_proc, 1);
489: --
490: -- Only proceed with validation if:
491: -- a) The current g_old_rec is current and
492: -- b) routing_seq_number has changed

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

499: if ((l_api_updating and nvl(ghr_prh_shd.g_old_rec.routing_seq_number,hr_api.g_number)
500: <> nvl(p_routing_seq_number,hr_api.g_number))
501: or (NOT l_api_updating)) then
502: --
503: hr_utility.set_location(l_proc, 2);
504: --
505: -- check if the routing_seq_number exists for the
506: -- routing_list_id
507: if p_routing_seq_number is not null then

Line 513: hr_utility.set_message(8301,'GHR_38104_INV_ROUT_SEQ_NUM');

509: l_exists := TRUE;
510: exit;
511: end loop;
512: if not l_exists then
513: hr_utility.set_message(8301,'GHR_38104_INV_ROUT_SEQ_NUM');
514: hr_utility.raise_error;
515: end if;
516: end if;
517: end if;

Line 514: hr_utility.raise_error;

510: exit;
511: end loop;
512: if not l_exists then
513: hr_utility.set_message(8301,'GHR_38104_INV_ROUT_SEQ_NUM');
514: hr_utility.raise_error;
515: end if;
516: end if;
517: end if;
518: --

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

515: end if;
516: end if;
517: end if;
518: --
519: hr_utility.set_location(' Leaving:'|| l_proc, 3);
520: end chk_rout_user_sequ_numb;
521: --
522: --
523:

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

531: l_proc varchar2(72) := g_package||'insert_validate';
532: --
533:
534: Begin
535: hr_utility.set_location('Entering:'||l_proc, 5);
536: --
537: -- Call all supporting business operations
538: --
539: -- hr_utility.set_location(l_proc, 10);

Line 539: -- hr_utility.set_location(l_proc, 10);

535: hr_utility.set_location('Entering:'||l_proc, 5);
536: --
537: -- Call all supporting business operations
538: --
539: -- hr_utility.set_location(l_proc, 10);
540: --
541: -- to check valid request_id
542: ghr_prh_bus.chk_pa_request_id(p_pa_request_id =>p_rec.pa_request_id
543: ,p_pa_routing_history_id =>p_rec.pa_routing_history_id

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

573: ,p_object_version_number => p_rec.object_version_number
574: );
575: --
576:
577: hr_utility.set_location(' Leaving:'||l_proc, 20);
578: End insert_validate;
579: --
580: -- ----------------------------------------------------------------------------
581: -- |---------------------------< update_validate >----------------------------|

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

589: l_proc varchar2(72) := g_package||'update_validate';
590: --
591:
592: Begin
593: hr_utility.set_location('Entering:'||l_proc, 5);
594: --
595: -- call chk_non_updateable_args
596: chk_non_updateable_args (p_rec => p_rec);
597:

Line 600: -- hr_utility.set_location(l_proc, 10);

596: chk_non_updateable_args (p_rec => p_rec);
597:
598: -- Call all supporting business operations
599: --
600: -- hr_utility.set_location(l_proc, 10);
601:
602: -- to check valid user_name
603: ghr_prh_bus.chk_user_name(p_user_name =>p_rec.user_name
604: ,p_groupbox_id =>p_rec.groupbox_id

Line 617: hr_utility.set_location(' Leaving:'||l_proc, 60);

613: ,p_object_version_number => p_rec.object_version_number
614: );
615: */
616:
617: hr_utility.set_location(' Leaving:'||l_proc, 60);
618: End update_validate;
619:
620:
621: -- ----------------------------------------------------------------------------

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

625: --
626: l_proc varchar2(72) := g_package||'delete_validate';
627: --
628: Begin
629: hr_utility.set_location('Entering:'||l_proc, 5);
630: --
631: -- Call all supporting business operations
632: --
633: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

629: hr_utility.set_location('Entering:'||l_proc, 5);
630: --
631: -- Call all supporting business operations
632: --
633: hr_utility.set_location(' Leaving:'||l_proc, 10);
634: End delete_validate;
635: --
636:
637: end ghr_prh_bus;