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_PSE_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 100: hr_utility.set_location('Entering:'|| l_proc, 10);

96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error

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

114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := per_pse_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.

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

131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --

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

140: close csr_leg_code;
141: per_pse_bus.g_pos_structure_element_id:= p_pos_structure_element_id;
142: per_pse_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ----------------------------------------------------------------------------

Line 278: hr_utility.set_message('801','HR_6915_POS_DEL_FIRST');

274: from per_pos_structure_elements pse
275: where pse.parent_position_id = p_Subordinate_position_Id
276: and pse.pos_structure_version_id = p_Pos_Structure_version_Id);
277: --
278: hr_utility.set_message('801','HR_6915_POS_DEL_FIRST');
279: hr_utility.raise_error;
280: --
281: exception
282: when no_data_found then

Line 279: hr_utility.raise_error;

275: where pse.parent_position_id = p_Subordinate_position_Id
276: and pse.pos_structure_version_id = p_Pos_Structure_version_Id);
277: --
278: hr_utility.set_message('801','HR_6915_POS_DEL_FIRST');
279: hr_utility.raise_error;
280: --
281: exception
282: when no_data_found then
283: null;

Line 307: hr_utility.set_message(801,'PAY_7694_PER_NO_DEL_STRUCTURE');

303: where psv.Pos_Structure_version_Id
304: = p_Pos_Structure_version_Id)
305: );
306: --
307: hr_utility.set_message(801,'PAY_7694_PER_NO_DEL_STRUCTURE');
308: hr_utility.raise_error;
309: --
310: exception
311: when no_data_found then

Line 308: hr_utility.raise_error;

304: = p_Pos_Structure_version_Id)
305: );
306: --
307: hr_utility.set_message(801,'PAY_7694_PER_NO_DEL_STRUCTURE');
308: hr_utility.raise_error;
309: --
310: exception
311: when no_data_found then
312: null;

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

357: l_dummy varchar2(10);
358: l_proc varchar2(100) := g_package||'chk_pos_structure_version_id';
359:
360: begin
361: hr_utility.set_location('Entering:'||l_proc, 1);
362: --
363: -- Check mandatory parameters have been set
364: --
365: hr_api.mandatory_arg_error

Line 378: hr_utility.set_message(800,'HR_289723_POS_VER_NULL');

374: );
375: --
376: --
377: if p_pos_structure_version_id is null then
378: hr_utility.set_message(800,'HR_289723_POS_VER_NULL');
379: hr_utility.raise_error;
380: else
381: --
382: hr_utility.set_location(l_proc, 5);

Line 379: hr_utility.raise_error;

375: --
376: --
377: if p_pos_structure_version_id is null then
378: hr_utility.set_message(800,'HR_289723_POS_VER_NULL');
379: hr_utility.raise_error;
380: else
381: --
382: hr_utility.set_location(l_proc, 5);
383: --

Line 382: hr_utility.set_location(l_proc, 5);

378: hr_utility.set_message(800,'HR_289723_POS_VER_NULL');
379: hr_utility.raise_error;
380: else
381: --
382: hr_utility.set_location(l_proc, 5);
383: --
384: -- Only proceed with validation if :
385: -- a) Inserting (pos_structure_version_id is non updateable)
386: --

Line 393: hr_utility.set_message(800,'HR_289724_POS_VER_INV');

389: open csr_pos_structure_versions;
390: fetch csr_pos_structure_versions into l_dummy;
391: if csr_pos_structure_versions%notfound then
392: close csr_pos_structure_versions;
393: hr_utility.set_message(800,'HR_289724_POS_VER_INV');
394: hr_utility.raise_error;
395: end if;
396: close csr_pos_structure_versions;
397:

Line 394: hr_utility.raise_error;

390: fetch csr_pos_structure_versions into l_dummy;
391: if csr_pos_structure_versions%notfound then
392: close csr_pos_structure_versions;
393: hr_utility.set_message(800,'HR_289724_POS_VER_INV');
394: hr_utility.raise_error;
395: end if;
396: close csr_pos_structure_versions;
397:
398: end if;

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

396: close csr_pos_structure_versions;
397:
398: end if;
399: end if;
400: hr_utility.set_location('Leaving:'||l_proc, 10);
401:
402: end chk_pos_structure_version_id;
403:
404: --

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

456: l_dummy varchar2(1);
457: l_proc varchar2(100) := g_package||'chk_parent_child_position_id';
458:
459: begin
460: hr_utility.set_location('Entering:'||l_proc, 1);
461: --
462: -- Check mandatory parameters have been set
463: --
464: hr_api.mandatory_arg_error

Line 477: hr_utility.set_message(800,'HR_289725_POS_NULL');

473: );
474: --
475: --
476: if p_parent_position_id is null or p_subordinate_position_id is null then
477: hr_utility.set_message(800,'HR_289725_POS_NULL');
478: hr_utility.raise_error;
479: else
480: --
481: hr_utility.set_location(l_proc, 5);

Line 478: hr_utility.raise_error;

474: --
475: --
476: if p_parent_position_id is null or p_subordinate_position_id is null then
477: hr_utility.set_message(800,'HR_289725_POS_NULL');
478: hr_utility.raise_error;
479: else
480: --
481: hr_utility.set_location(l_proc, 5);
482: --

Line 481: hr_utility.set_location(l_proc, 5);

477: hr_utility.set_message(800,'HR_289725_POS_NULL');
478: hr_utility.raise_error;
479: else
480: --
481: hr_utility.set_location(l_proc, 5);
482: --
483: -- Only proceed with validation if :
484: -- a) Inserting (parent or child position_id are non-updateable)
485: --

Line 492: hr_utility.set_message(800,'HR_289726_PARENT_POS_INV');

488: open csr_pos(p_pos_id => p_parent_position_id);
489: fetch csr_pos into l_dummy;
490: if csr_pos%notfound then
491: close csr_pos;
492: hr_utility.set_message(800,'HR_289726_PARENT_POS_INV');
493: hr_utility.raise_error;
494: end if;
495: close csr_pos;
496:

Line 493: hr_utility.raise_error;

489: fetch csr_pos into l_dummy;
490: if csr_pos%notfound then
491: close csr_pos;
492: hr_utility.set_message(800,'HR_289726_PARENT_POS_INV');
493: hr_utility.raise_error;
494: end if;
495: close csr_pos;
496:
497: hr_utility.set_location(l_proc, 20);

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

493: hr_utility.raise_error;
494: end if;
495: close csr_pos;
496:
497: hr_utility.set_location(l_proc, 20);
498: -- check child position_id exists
499: open csr_pos(p_subordinate_position_id);
500: fetch csr_pos into l_dummy;
501: if csr_pos%notfound then

Line 503: hr_utility.set_message(800,'HR_289727_CHILD_POS_INV');

499: open csr_pos(p_subordinate_position_id);
500: fetch csr_pos into l_dummy;
501: if csr_pos%notfound then
502: close csr_pos;
503: hr_utility.set_message(800,'HR_289727_CHILD_POS_INV');
504: hr_utility.raise_error;
505: end if;
506: close csr_pos;
507:

Line 504: hr_utility.raise_error;

500: fetch csr_pos into l_dummy;
501: if csr_pos%notfound then
502: close csr_pos;
503: hr_utility.set_message(800,'HR_289727_CHILD_POS_INV');
504: hr_utility.raise_error;
505: end if;
506: close csr_pos;
507:
508: hr_utility.set_location(l_proc, 30);

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

504: hr_utility.raise_error;
505: end if;
506: close csr_pos;
507:
508: hr_utility.set_location(l_proc, 30);
509: -- check if child is the same as parent
510: if p_subordinate_position_id=p_parent_position_id then
511: hr_utility.set_message(800,'HR_289481_PARENT_CHILD_EQUAL');
512: hr_utility.raise_error;

Line 511: hr_utility.set_message(800,'HR_289481_PARENT_CHILD_EQUAL');

507:
508: hr_utility.set_location(l_proc, 30);
509: -- check if child is the same as parent
510: if p_subordinate_position_id=p_parent_position_id then
511: hr_utility.set_message(800,'HR_289481_PARENT_CHILD_EQUAL');
512: hr_utility.raise_error;
513: end if;
514: -- check child is unique within the structure
515: open csr_ele;

Line 512: hr_utility.raise_error;

508: hr_utility.set_location(l_proc, 30);
509: -- check if child is the same as parent
510: if p_subordinate_position_id=p_parent_position_id then
511: hr_utility.set_message(800,'HR_289481_PARENT_CHILD_EQUAL');
512: hr_utility.raise_error;
513: end if;
514: -- check child is unique within the structure
515: open csr_ele;
516: fetch csr_ele into l_dummy;

Line 519: hr_utility.set_message(800,'HR_289728_CHILD_POS_EXISTS');

515: open csr_ele;
516: fetch csr_ele into l_dummy;
517: if csr_ele%found then
518: close csr_ele;
519: hr_utility.set_message(800,'HR_289728_CHILD_POS_EXISTS');
520: hr_utility.raise_error;
521: end if;
522: close csr_ele;
523:

Line 520: hr_utility.raise_error;

516: fetch csr_ele into l_dummy;
517: if csr_ele%found then
518: close csr_ele;
519: hr_utility.set_message(800,'HR_289728_CHILD_POS_EXISTS');
520: hr_utility.raise_error;
521: end if;
522: close csr_ele;
523:
524: end if;

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

523:
524: end if;
525: end if;
526:
527: hr_utility.set_location('Leaving:'||l_proc, 50);
528: --
529: end chk_parent_child_position_id;
530: --
531: --

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

539: --
540: l_proc varchar2(72) := g_package||'insert_validate';
541: --
542: Begin
543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: -- Call all supporting business operations
546: --
547: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

564: ,p_parent_position_id => p_rec.parent_position_id
565: ,p_subordinate_position_id => p_rec.subordinate_position_id);
566: --
567: --
568: hr_utility.set_location(' Leaving:'||l_proc, 10);
569: End insert_validate;
570: --
571: -- ----------------------------------------------------------------------------
572: -- |---------------------------< update_validate >----------------------------|

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

578: --
579: l_proc varchar2(72) := g_package||'update_validate';
580: --
581: Begin
582: hr_utility.set_location('Entering:'||l_proc, 5);
583: --
584: -- Call all supporting business operations
585: --
586: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

589: (p_rec => p_rec
590: );
591: --
592: --
593: hr_utility.set_location(' Leaving:'||l_proc, 10);
594: End update_validate;
595: --
596: -- ----------------------------------------------------------------------------
597: -- |---------------------------< delete_validate >----------------------------|

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

604: --
605: l_proc varchar2(72) := g_package||'delete_validate';
606: --
607: Begin
608: hr_utility.set_location('Entering:'||l_proc, 5);
609: --
610: -- Call all supporting business operations
611: --
612: if p_chk_children = 'Y' then

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

623: ,p_Pos_Structure_version_Id => p_rec.Pos_Structure_version_Id
624: );
625: end if;
626: --
627: hr_utility.set_location(' Leaving:'||l_proc, 10);
628: End delete_validate;
629: --
630: end per_pse_bus;