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.PQH_REI_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 78: hr_utility.set_location(' Leaving:'|| l_proc, 20);

74: (p_security_group_id => l_security_group_id
75: );
76: end if;
77: --
78: hr_utility.set_location(' Leaving:'|| l_proc, 20);
79: --
80: end set_security_group_id;
81: --
82: -- ---------------------------------------------------------------------------

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

106: l_proc varchar2(72) := g_package||'return_legislation_code';
107: --
108: Begin
109: --
110: hr_utility.set_location('Entering:'|| l_proc, 10);
111: --
112: -- Ensure that all the mandatory parameter are not null
113: --
114: hr_api.mandatory_arg_error

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

124: -- call to this function. Just return the value in the global
125: -- variable.
126: --
127: l_legislation_code := pqh_rei_bus.g_legislation_code;
128: hr_utility.set_location(l_proc, 20);
129: else
130: --
131: -- The ID is different to the last call to this function
132: -- or this is the first call to this function.

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

141: close csr_leg_code;
142: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
143: fnd_message.raise_error;
144: end if;
145: hr_utility.set_location(l_proc,30);
146: --
147: -- Set the global variables so the values are
148: -- available for the next call to this function.
149: --

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

150: close csr_leg_code;
151: pqh_rei_bus.g_role_extra_info_id := p_role_extra_info_id;
152: pqh_rei_bus.g_legislation_code := l_legislation_code;
153: end if;
154: hr_utility.set_location(' Leaving:'|| l_proc, 40);
155: return l_legislation_code;
156: end return_legislation_code;
157: --
158: -- ----------------------------------------------------------------------------

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

199: from pqh_role_info_types reit
200: where reit.information_type = code;
201: --
202: Begin
203: hr_utility.set_location('Entering:'||l_proc, 1);
204: --
205: -- Check mandatory parameters have been set
206: --
207: hr_api.mandatory_arg_error

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

210: p_argument => 'information_type',
211: p_argument_value => p_information_type
212: );
213: --
214: hr_utility.set_location(l_proc, 2);
215: --
216: -- Check that the ACTIVE_INACTIVE_FLAG of role
217: -- Information type is active.
218: --

Line 223: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');

219: open c_role_info_type (p_information_type);
220: fetch c_role_info_type into l_flag;
221: if c_role_info_type%notfound then
222: close c_role_info_type;
223: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
224: hr_utility.raise_error;
225: end if;
226: close c_role_info_type;
227: --

Line 224: hr_utility.raise_error;

220: fetch c_role_info_type into l_flag;
221: if c_role_info_type%notfound then
222: close c_role_info_type;
223: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
224: hr_utility.raise_error;
225: end if;
226: close c_role_info_type;
227: --
228: if l_flag = 'N' then

Line 229: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');

225: end if;
226: close c_role_info_type;
227: --
228: if l_flag = 'N' then
229: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
230: hr_utility.raise_error;
231: end if;
232: --
233: hr_utility.set_location(' Leaving:'||l_proc, 3);

Line 230: hr_utility.raise_error;

226: close c_role_info_type;
227: --
228: if l_flag = 'N' then
229: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
230: hr_utility.raise_error;
231: end if;
232: --
233: hr_utility.set_location(' Leaving:'||l_proc, 3);
234: --

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

229: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
230: hr_utility.raise_error;
231: end if;
232: --
233: hr_utility.set_location(' Leaving:'||l_proc, 3);
234: --
235: End chk_role_info_type;
236: --
237: --

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

279: from pqh_roles
280: where role_id = id;
281: --
282: Begin
283: hr_utility.set_location('Entering:'||l_proc, 1);
284: --
285: -- Check mandatory parameters have been set
286: --
287: hr_api.mandatory_arg_error

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

289: p_api_name => l_proc,
290: p_argument => 'role_id',
291: p_argument_value => p_role_id
292: );
293: hr_utility.set_location(l_proc, 2);
294: --
295: -- Check that the role_id is in the pqh_roles table.
296: --
297: open c_valid_role (p_role_id);

Line 301: hr_utility.set_message(8302, 'PQH_INV_ROLE_ID');

297: open c_valid_role (p_role_id);
298: fetch c_valid_role into l_dummy;
299: if c_valid_role%notfound then
300: close c_valid_role;
301: hr_utility.set_message(8302, 'PQH_INV_ROLE_ID');
302: hr_utility.raise_error;
303: end if;
304: close c_valid_role;
305: --

Line 302: hr_utility.raise_error;

298: fetch c_valid_role into l_dummy;
299: if c_valid_role%notfound then
300: close c_valid_role;
301: hr_utility.set_message(8302, 'PQH_INV_ROLE_ID');
302: hr_utility.raise_error;
303: end if;
304: close c_valid_role;
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 3);

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

302: hr_utility.raise_error;
303: end if;
304: close c_valid_role;
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 3);
307: --
308: End chk_role_id;
309: --
310: -- ----------------------------------------------------------------------------

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

360: where information_type = code
361: and role_id = id;
362: --
363: Begin
364: hr_utility.set_location('Entering:'||l_proc, 5);
365: --
366: open c_multi_occur_flag (p_information_type);
367: fetch c_multi_occur_flag into l_multi_occur_flag;
368: --

Line 374: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');

370: -- chk_information_type should capture this error.
371: --
372: if c_multi_occur_flag%notfound then
373: close c_multi_occur_flag;
374: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
375: hr_utility.raise_error;
376: end if;
377: --
378: close c_multi_occur_flag;

Line 375: hr_utility.raise_error;

371: --
372: if c_multi_occur_flag%notfound then
373: close c_multi_occur_flag;
374: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
375: hr_utility.raise_error;
376: end if;
377: --
378: close c_multi_occur_flag;
379: --

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

376: end if;
377: --
378: close c_multi_occur_flag;
379: --
380: hr_utility.set_location(l_proc, 10);
381: --
382: open c_get_row(p_information_type, p_role_id);
383: fetch c_get_row into l_dummy;
384: if c_get_row%notfound then

Line 392: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');

388: end if;
389: close c_get_row;
390: --
391: if l_found_rei and l_multi_occur_flag = 'N' then
392: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');
393: hr_utility.raise_error;
394: end if;
395: --
396: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 393: hr_utility.raise_error;

389: close c_get_row;
390: --
391: if l_found_rei and l_multi_occur_flag = 'N' then
392: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');
393: hr_utility.raise_error;
394: end if;
395: --
396: hr_utility.set_location(' Leaving:'||l_proc, 15);
397: --

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

392: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');
393: hr_utility.raise_error;
394: end if;
395: --
396: hr_utility.set_location(' Leaving:'||l_proc, 15);
397: --
398: End chk_multiple_occurences_flag;
399: --
400: -- ----------------------------------------------------------------------------

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

435: l_error exception;
436: l_argument varchar2(30);
437: --
438: Begin
439: hr_utility.set_location('Entering:'||l_proc, 10);
440: --
441: -- Only proceed with validation if a row exists for
442: -- the current record in the HR Schema
443: --

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

443: --
444: if not pqh_rei_shd.api_updating
445: (p_role_extra_info_id => p_rec.role_extra_info_id
446: ,p_object_version_number => p_rec.object_version_number) then
447: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
448: hr_utility.set_message_token('PROCEDURE', l_proc);
449: hr_utility.set_message_token('STEP', '20');
450: end if;
451: --

Line 448: hr_utility.set_message_token('PROCEDURE', l_proc);

444: if not pqh_rei_shd.api_updating
445: (p_role_extra_info_id => p_rec.role_extra_info_id
446: ,p_object_version_number => p_rec.object_version_number) then
447: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
448: hr_utility.set_message_token('PROCEDURE', l_proc);
449: hr_utility.set_message_token('STEP', '20');
450: end if;
451: --
452: hr_utility.set_location(l_proc, 30);

Line 449: hr_utility.set_message_token('STEP', '20');

445: (p_role_extra_info_id => p_rec.role_extra_info_id
446: ,p_object_version_number => p_rec.object_version_number) then
447: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
448: hr_utility.set_message_token('PROCEDURE', l_proc);
449: hr_utility.set_message_token('STEP', '20');
450: end if;
451: --
452: hr_utility.set_location(l_proc, 30);
453: --

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

448: hr_utility.set_message_token('PROCEDURE', l_proc);
449: hr_utility.set_message_token('STEP', '20');
450: end if;
451: --
452: hr_utility.set_location(l_proc, 30);
453: --
454: if nvl(p_rec.information_type, hr_api.g_varchar2) <>
455: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) then
456: l_argument := 'information_type';

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

456: l_argument := 'information_type';
457: raise l_error;
458: end if;
459: --
460: hr_utility.set_location(l_proc, 40);
461: --
462: if nvl(p_rec.role_id, hr_api.g_number) <>
463: nvl(pqh_rei_shd.g_old_rec.role_id, hr_api.g_number) then
464: l_argument := 'role_id';

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

464: l_argument := 'role_id';
465: raise l_error;
466: end if;
467: --
468: hr_utility.set_location(' Leaving:'||l_proc, 50);
469: exception
470: when l_error then
471: hr_api.argument_changed_error
472: (p_api_name => l_proc

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

471: hr_api.argument_changed_error
472: (p_api_name => l_proc
473: ,p_argument => l_argument
474: );
475: hr_utility.set_location(l_proc, 60);
476: when others then
477: hr_utility.set_location(l_proc, 70);
478: raise;
479: end chk_non_updateable_args;

Line 477: hr_utility.set_location(l_proc, 70);

473: ,p_argument => l_argument
474: );
475: hr_utility.set_location(l_proc, 60);
476: when others then
477: hr_utility.set_location(l_proc, 70);
478: raise;
479: end chk_non_updateable_args;
480:
481:

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

513: --
514: l_proc varchar2(72) := g_package || 'chk_ddf';
515: --
516: begin
517: hr_utility.set_location('Entering:'||l_proc,10);
518: --
519: if ((p_rec.role_extra_info_id is not null) and (
520: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
521: nvl(p_rec.information_type, hr_api.g_varchar2) or

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

654: ,p_attribute30_value => p_rec.information30
655: );
656: end if;
657: --
658: hr_utility.set_location(' Leaving:'||l_proc,20);
659: end chk_ddf;
660: --
661: -- ----------------------------------------------------------------------------
662: -- |------------------------------< chk_df >----------------------------------|

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

692: --
693: l_proc varchar2(72) := g_package || 'chk_df';
694: --
695: begin
696: hr_utility.set_location('Entering:'||l_proc,10);
697: --
698: if ((p_rec.role_extra_info_id is not null) and (
699: nvl(pqh_rei_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

831: ,p_attribute30_value => p_rec.attribute30
832: );
833: end if;
834: --
835: hr_utility.set_location(' Leaving:'||l_proc,20);
836: end chk_df;
837: --
838: -- ----------------------------------------------------------------------------
839: -- |---------------------------< insert_validate >----------------------------|

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

844: --
845: l_proc varchar2(72) := g_package||'insert_validate';
846: --
847: Begin
848: hr_utility.set_location('Entering:'||l_proc, 5);
849: --
850: -- Validate Role ID
851: --
852: chk_role_id

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

865: ,p_role_id => p_rec.role_id
866: );
867: --
868: pqh_rei_bus.chk_ddf(p_rec);
869: hr_utility.set_location('Entering:'||l_proc, 10);
870:
871:
872: pqh_rei_bus.chk_df(p_rec);
873: hr_utility.set_location('Entering:'||l_proc, 15);

Line 873: hr_utility.set_location('Entering:'||l_proc, 15);

869: hr_utility.set_location('Entering:'||l_proc, 10);
870:
871:
872: pqh_rei_bus.chk_df(p_rec);
873: hr_utility.set_location('Entering:'||l_proc, 15);
874:
875: End insert_validate;
876: --
877: -- ----------------------------------------------------------------------------

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

883: --
884: l_proc varchar2(72) := g_package||'update_validate';
885: --
886: Begin
887: hr_utility.set_location('Entering:'||l_proc, 5);
888: --
889: chk_non_updateable_args
890: (p_rec => p_rec
891: );

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

891: );
892: --
893: -- Call ddf procedure to validate Developer Descipptive Flexfields
894: pqh_rei_bus.chk_ddf(p_rec);
895: hr_utility.set_location('Entering:'||l_proc, 10);
896:
897: -- Call df procedure to validate Descipptive Flexfields
898: pqh_rei_bus.chk_df(p_rec);
899: --

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

896:
897: -- Call df procedure to validate Descipptive Flexfields
898: pqh_rei_bus.chk_df(p_rec);
899: --
900: hr_utility.set_location(' Leaving:'||l_proc, 15);
901: End update_validate;
902: --
903: -- ----------------------------------------------------------------------------
904: -- |---------------------------< delete_validate >----------------------------|

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

909: --
910: l_proc varchar2(72) := g_package||'delete_validate';
911: --
912: Begin
913: hr_utility.set_location('Entering:'||l_proc, 5);
914: --
915: -- Call all supporting business operations
916: --
917: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

913: hr_utility.set_location('Entering:'||l_proc, 5);
914: --
915: -- Call all supporting business operations
916: --
917: hr_utility.set_location(' Leaving:'||l_proc, 10);
918: End delete_validate;
919: --
920: end pqh_rei_bus;