DBA Data[Home] [Help]

APPS.PQP_PVD_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_pvd_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_pvd_bus.g_vehicle_details_id:= p_vehicle_details_id;
142: pqp_pvd_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.vehicle_details_id is not null) and (
186: nvl(pqp_pvd_shd.g_old_rec.vhd_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.vhd_information_category, hr_api.g_varchar2) or

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

278: ,p_attribute20_value => p_rec.vhd_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.vehicle_details_id is not null) and (
323: nvl(pqp_pvd_shd.g_old_rec.vhd_attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.vhd_attribute_category, hr_api.g_varchar2) or

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

415: ,p_attribute20_value => p_rec.vhd_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 497: hr_utility.set_location('Entering:'||l_proc, 5);

493: l_proc varchar2(72) := g_package||' check_fuel_type_code';
494:
495: BEGIN
496:
497: hr_utility.set_location('Entering:'||l_proc, 5);
498:
499: IF hr_api.not_exists_in_hr_lookups
500: (p_lookup_type => 'PQP_FUEL_TYPE' ,
501: p_lookup_code => p_fuel_type_code ,

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

523: l_proc varchar2(72) := g_package||' check_vehicle_ownership';
524:
525: BEGIN
526:
527: hr_utility.set_location('Entering:'||l_proc, 5);
528:
529: IF p_vehicle_ownership NOT IN ('COMPANY','PRIVATE') THEN
530: -- Raise error as the allowed values are company,private and NULL
531: fnd_message.set_name('PQP','PQP_230521_INVALID_VEH_OWNSHP');

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

551: l_dummy VARCHAR2(1);
552:
553: BEGIN
554:
555: hr_utility.set_location('Entering:'||l_proc, 5);
556: OPEN veh_cur;
557: FETCH veh_cur INTO l_dummy;
558: IF veh_cur%FOUND THEN
559: -- Raise error as there is an assignment for the vehicle

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

579: l_default_currency_code VARCHAR2(10);
580:
581: BEGIN
582:
583: hr_utility.set_location('Entering:'||l_proc, 5);
584: l_default_currency_code := hr_general.default_currency_code (p_business_group_id
585: => p_in_business_group_id);
586:
587: IF p_currency_code <> l_default_currency_code THEN

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

604: l_proc varchar2(72) := g_package||' check_vehicle_type_code';
605:
606: BEGIN
607:
608: hr_utility.set_location('Entering:'||l_proc, 5);
609:
610: IF hr_api.not_exists_in_hr_lookups
611: (p_lookup_type => 'PQP_VEHICLE_TYPE' ,
612: p_lookup_code => p_vehicle_type_code ,

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

632: l_proc varchar2(72) := g_package||' check_negative';
633:
634: BEGIN
635:
636: hr_utility.set_location('Entering:'||l_proc, 5);
637: IF p_number_to_check < 0 THEN
638: fnd_message.set_name ('PAY','HR_7355_PPM_AMOUNT_NEGATIVE' );
639: fnd_message.set_token('ERROR','Value Cannot Be Negative');
640: fnd_message.raise_error;

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

652: --
653: l_proc varchar2(72) := g_package||'insert_validate';
654: --
655: Begin
656: hr_utility.set_location('Entering:'||l_proc, 5);
657: --
658: -- Call all supporting business operations
659: --
660: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

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

701: pqp_pvd_bus.chk_ddf(p_rec);
702: --
703: pqp_pvd_bus.chk_df(p_rec);
704: --
705: hr_utility.set_location(' Leaving:'||l_proc, 10);
706: End insert_validate;
707: --
708: -- ----------------------------------------------------------------------------
709: -- |---------------------------< update_validate >----------------------------|

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

715: --
716: l_proc varchar2(72) := g_package||'update_validate';
717: --
718: Begin
719: hr_utility.set_location('Entering:'||l_proc, 5);
720: --
721: -- Call all supporting business operations
722: --
723: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

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

769: pqp_pvd_bus.chk_ddf(p_rec);
770: --
771: pqp_pvd_bus.chk_df(p_rec);
772: --
773: hr_utility.set_location(' Leaving:'||l_proc, 10);
774: End update_validate;
775: --
776: -- ----------------------------------------------------------------------------
777: -- |---------------------------< delete_validate >----------------------------|

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

782: --
783: l_proc varchar2(72) := g_package||'delete_validate';
784: --
785: Begin
786: hr_utility.set_location('Entering:'||l_proc, 5);
787: --
788: -- Call all supporting business operations
789: --
790: pqp_pvd_bus.check_assignment_exists(p_rec.vehicle_details_id);

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

788: -- Call all supporting business operations
789: --
790: pqp_pvd_bus.check_assignment_exists(p_rec.vehicle_details_id);
791: --
792: hr_utility.set_location(' Leaving:'||l_proc, 10);
793: End delete_validate;
794: --
795: end pqp_pvd_bus;