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

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

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

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

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

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

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

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

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

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

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

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

56: -- <> nvl(ghr_pdh_shd.g_old_rec.nature_of_action_id,hr_api.g_number) then
57: -- l_argument := 'nature_of_action_id';
58: -- raise l_error;
59: -- end if;
60: hr_utility.set_location(l_proc,40);
61: --
62: exception
63: when l_error then
64: hr_api.argument_changed_error

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

109: from ghr_position_descriptions gpd
110: where gpd.position_description_id = p_position_description_id;
111: --
112: begin
113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Check mandatory parameters have been set
116: --
117: hr_api.mandatory_arg_error

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

119: ,p_argument => 'position_description_id'
120: ,p_argument_value => p_position_description_id
121: );
122: --
123: hr_utility.set_location(l_proc, 20);
124: --
125: -- Only proceed with validation if:
126: -- a) The current g_old_rec is current and
127: -- b) The routing status value has changed

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

130: l_api_updating := ghr_pdh_shd.api_updating
131: (p_pd_routing_history_id => p_pd_routing_history_id
132: ,p_object_version_number => p_object_version_number
133: );
134: hr_utility.set_location(l_proc, 30);
135: --
136: if ((l_api_updating
137: and nvl(ghr_pdh_shd.g_old_rec.position_description_id, hr_api.g_number)
138: <> nvl(p_position_description_id,hr_api.g_number))

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

138: <> nvl(p_position_description_id,hr_api.g_number))
139: or
140: (NOT l_api_updating))
141: then
142: hr_utility.set_location(l_proc, 40);
143: --
144: -- Check if position_description_id is valid
145: --
146: for rec in c_pos_desc_id loop

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

151: ghr_pdh_shd.constraint_error(p_constraint_name => 'GHR_PD_ROUTING_HIST_FK1');
152: end if;
153: end if;
154: --
155: hr_utility.set_location(' Leaving:'|| l_proc, 3);
156: end chk_position_description_id;
157:
158:
159:

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

203: and gbx.routing_group_id = gpd.routing_group_id
204: and gbx.groupbox_id = p_groupbox_id;
205: --
206: begin
207: hr_utility.set_location('Entering:'|| l_proc, 1);
208: --
209: -- Check mandatory parameters have been set
210: hr_api.mandatory_arg_error
211: (p_api_name => l_proc

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

224: if ((l_api_updating and nvl(ghr_pdh_shd.g_old_rec.groupbox_id,hr_api.g_number)
225: <> nvl(p_groupbox_id,hr_api.g_number))
226: or (NOT l_api_updating)) then
227: --
228: hr_utility.set_location(l_proc, 2);
229: --
230: -- check if the groupbox_id exists for the
231: -- routing_group_id
232: if p_groupbox_id is not null then

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

234: l_exists := true;
235: exit;
236: end loop;
237: if not l_exists then
238: hr_utility.set_message(8301,'GHR_38101_INV_GROUPBOX_ID');
239: hr_utility.raise_error;
240: end if;
241: end if;
242: --

Line 239: hr_utility.raise_error;

235: exit;
236: end loop;
237: if not l_exists then
238: hr_utility.set_message(8301,'GHR_38101_INV_GROUPBOX_ID');
239: hr_utility.raise_error;
240: end if;
241: end if;
242: --
243: end if;

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

241: end if;
242: --
243: end if;
244: --
245: hr_utility.set_location(' Leaving:'|| l_proc, 3);
246: end chk_groupbox_id;
247:
248: -- ----------------------------------------------------------------------------
249: -- |---------------------------< chk_user_name>----------------------------|

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

306: WHERE UPPER(user_name) = UPPER(p_user_name)
307: AND user_name LIKE UPPER(p_user_name); */
308:
309: begin
310: hr_utility.set_location('Entering:'||l_proc,10);
311: --
312: -- Only proceed with validation if:
313: -- a) The current g_old_rec is current and
314: -- b) routing_user_name has changed

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

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

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

334: l_exists := true;
335: exit;
336: end loop;
337: if not l_exists then
338: hr_utility.set_message(8301,'GHR_38103_INV_GROUPBOX_USER');
339: hr_utility.raise_error;
340: end if;
341: end if;
342: l_exists := false;

Line 339: hr_utility.raise_error;

335: exit;
336: end loop;
337: if not l_exists then
338: hr_utility.set_message(8301,'GHR_38103_INV_GROUPBOX_USER');
339: hr_utility.raise_error;
340: end if;
341: end if;
342: l_exists := false;
343: for c_user_name_rec in c_user_name loop

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

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

Line 349: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 513: hr_utility.raise_error;

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

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

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

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

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

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

534: hr_utility.set_location('Entering:'||l_proc, 5);
535: --
536: -- Call all supporting business operations
537: --
538: -- hr_utility.set_location(l_proc, 10);
539: --
540: -- to check valid position_description_id
541: ghr_pdh_bus.chk_position_description_id
542: (p_position_description_id =>p_rec.position_description_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_pdh_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_pdh_bus;