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.PQP_SHP_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 := pqp_shp_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: pqp_shp_bus.g_service_history_period_id := p_service_history_period_id;
142: pqp_shp_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 183: hr_utility.set_location('Entering:'||l_proc,10);

179: --
180: l_proc varchar2(72) := g_package || 'chk_ddf';
181: --
182: begin
183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.service_history_period_id is not null) and (
186: nvl(pqp_shp_shd.g_old_rec.shp_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.shp_information_category, hr_api.g_varchar2) or

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

278: ,p_attribute20_value => p_rec.shp_information20
279: );
280: end if;
281: --
282: hr_utility.set_location(' Leaving:'||l_proc,20);
283: end chk_ddf;
284: --
285: -- ----------------------------------------------------------------------------
286: -- |------------------------------< chk_df >----------------------------------|

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

316: --
317: l_proc varchar2(72) := g_package || 'chk_df';
318: --
319: begin
320: hr_utility.set_location('Entering:'||l_proc,10);
321: --
322: if ((p_rec.service_history_period_id is not null) and (
323: nvl(pqp_shp_shd.g_old_rec.shp_attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.shp_attribute_category, hr_api.g_varchar2) or

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

415: ,p_attribute20_value => p_rec.shp_attribute20
416: );
417: end if;
418: --
419: hr_utility.set_location(' Leaving:'||l_proc,20);
420: end chk_df;
421: --
422: -- ----------------------------------------------------------------------------
423: -- |-----------------------< chk_non_updateable_args >------------------------|

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

533: l_api_updating boolean;
534: --
535:
536: begin
537: hr_utility.set_location('Entering:'|| l_proc, 5);
538: --
539: -- Check mandatory parameters have been set
540: --
541: hr_api.mandatory_arg_error

Line 573: hr_utility.set_message(8303, 'PQP_230543_SHP_REQ_VALUES');

569: p_start_date is null and
570: p_end_date is null then
571:
572: --
573: hr_utility.set_message(8303, 'PQP_230543_SHP_REQ_VALUES');
574: hr_utility.raise_error;
575: --
576:
577: end if; -- end if of period is null check...

Line 574: hr_utility.raise_error;

570: p_end_date is null then
571:
572: --
573: hr_utility.set_message(8303, 'PQP_230543_SHP_REQ_VALUES');
574: hr_utility.raise_error;
575: --
576:
577: end if; -- end if of period is null check...
578:

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

577: end if; -- end if of period is null check...
578:
579: end if; -- end if of api updatin check...
580: --
581: hr_utility.set_location(' Leaving:'|| l_proc, 10);
582: --
583: end chk_periods;
584: --
585: -- ----------------------------------------------------------------------------

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

626: l_proc varchar2(72) := g_package||'chk_start_date';
627: l_api_updating boolean;
628: --
629: begin
630: hr_utility.set_location('Entering:'|| l_proc, 5);
631: --
632: -- Check mandatory parameters have been set
633: --
634: hr_api.mandatory_arg_error

Line 677: hr_utility.set_message(8303, 'PQP_230503_SHP_START_DT_GREAT');

673: -- value for the current record
674: --
675: if p_start_date > p_end_date then
676: --
677: hr_utility.set_message(8303, 'PQP_230503_SHP_START_DT_GREAT');
678: hr_utility.raise_error;
679: --
680: end if;
681: --

Line 678: hr_utility.raise_error;

674: --
675: if p_start_date > p_end_date then
676: --
677: hr_utility.set_message(8303, 'PQP_230503_SHP_START_DT_GREAT');
678: hr_utility.raise_error;
679: --
680: end if;
681: --
682: end if;

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

680: end if;
681: --
682: end if;
683: --
684: hr_utility.set_location(' Leaving:'|| l_proc, 10);
685: --
686: end chk_start_date;
687: --
688: --

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

741: l_api_updating boolean;
742: --
743:
744: begin
745: hr_utility.set_location('Entering:'|| l_proc, 5);
746: --
747: -- Check mandatory parameters have been set
748: --
749: hr_api.mandatory_arg_error

Line 796: hr_utility.set_message(8303, 'PQP_230504_SHP_END_DT_LESSER');

792: );
793:
794: elsif p_end_date is not null then
795:
796: hr_utility.set_message(8303, 'PQP_230504_SHP_END_DT_LESSER');
797: hr_utility.raise_error;
798:
799: elsif p_period_years is null and
800: p_period_days is null then

Line 797: hr_utility.raise_error;

793:
794: elsif p_end_date is not null then
795:
796: hr_utility.set_message(8303, 'PQP_230504_SHP_END_DT_LESSER');
797: hr_utility.raise_error;
798:
799: elsif p_period_years is null and
800: p_period_days is null then
801:

Line 802: hr_utility.set_message(8303, 'PQP_230543_SHP_REQ_VALUES');

798:
799: elsif p_period_years is null and
800: p_period_days is null then
801:
802: hr_utility.set_message(8303, 'PQP_230543_SHP_REQ_VALUES');
803: hr_utility.raise_error;
804:
805: --
806: end if; -- End if of start date is not null check..

Line 803: hr_utility.raise_error;

799: elsif p_period_years is null and
800: p_period_days is null then
801:
802: hr_utility.set_message(8303, 'PQP_230543_SHP_REQ_VALUES');
803: hr_utility.raise_error;
804:
805: --
806: end if; -- End if of start date is not null check..
807: --

Line 814: hr_utility.set_message(8303, 'PQP_230504_SHP_END_DT_LESSER');

810: -- value for the current record
811: --
812: if p_end_date < p_start_date then
813: --
814: hr_utility.set_message(8303, 'PQP_230504_SHP_END_DT_LESSER');
815: hr_utility.raise_error;
816: --
817: end if;
818: --

Line 815: hr_utility.raise_error;

811: --
812: if p_end_date < p_start_date then
813: --
814: hr_utility.set_message(8303, 'PQP_230504_SHP_END_DT_LESSER');
815: hr_utility.raise_error;
816: --
817: end if;
818: --
819: end if;

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

817: end if;
818: --
819: end if;
820: --
821: hr_utility.set_location(' Leaving:'|| l_proc, 10);
822: --
823: end chk_end_date;
824: --
825: --

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

833: --
834: l_proc varchar2(72) := g_package||'insert_validate';
835: --
836: Begin
837: hr_utility.set_location('Entering:'||l_proc, 5);
838: --
839: -- Call all supporting business operations
840: --
841: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

Line 865: hr_utility.set_location(l_proc, 7);

861:
862: end if; -- End if of start date is not null check...
863:
864: --
865: hr_utility.set_location(l_proc, 7);
866: --
867: -- Validate end date
868: --
869: chk_end_date

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

874: ,p_period_days => p_rec.period_days
875: ,p_assignment_id => p_rec.assignment_id
876: ,p_object_version_number => p_rec.object_version_number);
877: --
878: hr_utility.set_location(' Leaving:'||l_proc, 10);
879: End insert_validate;
880: --
881: -- ----------------------------------------------------------------------------
882: -- |---------------------------< update_validate >----------------------------|

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

888: --
889: l_proc varchar2(72) := g_package||'update_validate';
890: --
891: Begin
892: hr_utility.set_location('Entering:'||l_proc, 5);
893: --
894: -- Call all supporting business operations
895: --
896: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

Line 924: hr_utility.set_location(l_proc, 7);

920: ,p_object_version_number => p_rec.object_version_number);
921:
922: end if; -- end if of start date is not null check...
923: --
924: hr_utility.set_location(l_proc, 7);
925: --
926: -- Validate end date
927: --
928: chk_end_date

Line 937: hr_utility.set_location(l_proc, 8);

933: ,p_period_days => p_rec.period_days
934: ,p_assignment_id => p_rec.assignment_id
935: ,p_object_version_number => p_rec.object_version_number);
936: --
937: hr_utility.set_location(l_proc, 8);
938: --
939: chk_periods
940: (p_service_history_period_id => p_rec.service_history_period_id
941: ,p_start_date => p_rec.start_date

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

944: ,p_period_days => p_rec.period_days
945: ,p_assignment_id => p_rec.assignment_id
946: ,p_object_version_number => p_rec.object_version_number);
947: --
948: hr_utility.set_location(' Leaving:'||l_proc, 10);
949: End update_validate;
950: --
951: -- ----------------------------------------------------------------------------
952: -- |---------------------------< delete_validate >----------------------------|

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

957: --
958: l_proc varchar2(72) := g_package||'delete_validate';
959: --
960: Begin
961: hr_utility.set_location('Entering:'||l_proc, 5);
962: --
963: -- Call all supporting business operations
964: --
965: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

961: hr_utility.set_location('Entering:'||l_proc, 5);
962: --
963: -- Call all supporting business operations
964: --
965: hr_utility.set_location(' Leaving:'||l_proc, 10);
966: End delete_validate;
967: --
968: end pqp_shp_bus;