DBA Data[Home] [Help]

APPS.PQP_VAI_BUS dependencies on HR_UTILITY

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

47: l_legislation_code varchar2(150);
48: --
49: begin
50: --
51: hr_utility.set_location('Entering:'|| l_proc, 10);
52: --
53: -- Ensure that all the mandatory parameter are not null
54: --
55: hr_api.mandatory_arg_error

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

87: --
88: hr_api.set_legislation_context(l_legislation_code);
89: end if;
90: --
91: hr_utility.set_location(' Leaving:'|| l_proc, 20);
92: --
93: end set_security_group_id;
94: --
95: -- ---------------------------------------------------------------------------

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

116: l_proc varchar2(72) := g_package||'return_legislation_code';
117: --
118: Begin
119: --
120: hr_utility.set_location('Entering:'|| l_proc, 10);
121: --
122: -- Ensure that all the mandatory parameter are not null
123: --
124: hr_api.mandatory_arg_error

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

134: -- call to this function. Just return the value in the global
135: -- variable.
136: --
137: l_legislation_code := pqp_vai_bus.g_legislation_code;
138: hr_utility.set_location(l_proc, 20);
139: else
140: --
141: -- The ID is different to the last call to this function
142: -- or this is the first call to this function.

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

151: close csr_leg_code;
152: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
153: fnd_message.raise_error;
154: end if;
155: hr_utility.set_location(l_proc,30);
156: --
157: -- Set the global variables so the values are
158: -- available for the next call to this function.
159: --

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

160: close csr_leg_code;
161: pqp_vai_bus.g_vehicle_allocation_id := p_vehicle_allocation_id;
162: pqp_vai_bus.g_legislation_code := l_legislation_code;
163: end if;
164: hr_utility.set_location(' Leaving:'|| l_proc, 40);
165: return l_legislation_code;
166: end return_legislation_code;
167: --
168:

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

190: l_proc varchar2(72) := g_package||'return_legislation_code';
191: --
192: Begin
193: --
194: hr_utility.set_location('Entering:'|| l_proc, 10);
195: --
196: -- Ensure that all the mandatory parameter are not null
197: --
198: hr_api.mandatory_arg_error

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

208: -- call to this function. Just return the value in the global
209: -- variable.
210: --
211: l_legislation_code := pqp_vai_bus.g_legislation_code;
212: hr_utility.set_location(l_proc, 20);
213: else
214: --
215: -- The ID is different to the last call to this function
216: -- or this is the first call to this function.

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

225: close csr_leg_code;
226: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
227: fnd_message.raise_error;
228: end if;
229: hr_utility.set_location(l_proc,30);
230: --
231: -- Set the global variables so the values are
232: -- available for the next call to this function.
233: --

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

234: close csr_leg_code;
235: pqp_vai_bus.g_vehicle_allocation_id := p_vehicle_allocation_id;
236: pqp_vai_bus.g_legislation_code := l_legislation_code;
237: end if;
238: hr_utility.set_location(' Leaving:'|| l_proc, 40);
239: return l_legislation_code;
240: end return_alloc_legislation_code;
241: --
242: -- ----------------------------------------------------------------------------

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

273: --
274: l_proc varchar2(72) := g_package || 'chk_ddf';
275: --
276: begin
277: hr_utility.set_location('Entering:'||l_proc,10);
278: --
279: if ((p_rec.veh_alloc_extra_info_id is not null) and (
280: nvl(pqp_vai_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
281: nvl(p_rec.information_type, hr_api.g_varchar2) or

Line 351: hr_utility.set_location('Entering inf1:'||p_rec.vaei_information1,10);

347: -- a) During update, the structure column value or any
348: -- of the attribute values have actually changed.
349: -- b) During insert.
350: --
351: hr_utility.set_location('Entering inf1:'||p_rec.vaei_information1,10);
352: hr_utility.set_location('Entering inf2:'||p_rec.vaei_information2,10);
353: hr_utility.set_location('Entering: inf3'||p_rec.vaei_information3,10);
354: hr_utility.set_location('Entering: inf4'||p_rec.vaei_information9,10);
355: hr_dflex_utility.ins_or_upd_descflex_attribs

Line 352: hr_utility.set_location('Entering inf2:'||p_rec.vaei_information2,10);

348: -- of the attribute values have actually changed.
349: -- b) During insert.
350: --
351: hr_utility.set_location('Entering inf1:'||p_rec.vaei_information1,10);
352: hr_utility.set_location('Entering inf2:'||p_rec.vaei_information2,10);
353: hr_utility.set_location('Entering: inf3'||p_rec.vaei_information3,10);
354: hr_utility.set_location('Entering: inf4'||p_rec.vaei_information9,10);
355: hr_dflex_utility.ins_or_upd_descflex_attribs
356: (p_appl_short_name => 'PQP'

Line 353: hr_utility.set_location('Entering: inf3'||p_rec.vaei_information3,10);

349: -- b) During insert.
350: --
351: hr_utility.set_location('Entering inf1:'||p_rec.vaei_information1,10);
352: hr_utility.set_location('Entering inf2:'||p_rec.vaei_information2,10);
353: hr_utility.set_location('Entering: inf3'||p_rec.vaei_information3,10);
354: hr_utility.set_location('Entering: inf4'||p_rec.vaei_information9,10);
355: hr_dflex_utility.ins_or_upd_descflex_attribs
356: (p_appl_short_name => 'PQP'
357: ,p_descflex_name => 'Vehicle Alloc Extra Info DDF'

Line 354: hr_utility.set_location('Entering: inf4'||p_rec.vaei_information9,10);

350: --
351: hr_utility.set_location('Entering inf1:'||p_rec.vaei_information1,10);
352: hr_utility.set_location('Entering inf2:'||p_rec.vaei_information2,10);
353: hr_utility.set_location('Entering: inf3'||p_rec.vaei_information3,10);
354: hr_utility.set_location('Entering: inf4'||p_rec.vaei_information9,10);
355: hr_dflex_utility.ins_or_upd_descflex_attribs
356: (p_appl_short_name => 'PQP'
357: ,p_descflex_name => 'Vehicle Alloc Extra Info DDF'
358: ,p_attribute_category => p_rec.vaei_information_category

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

418: ,p_attribute30_value => p_rec.vaei_information30
419: );
420: end if;
421: --
422: hr_utility.set_location(' Leaving:'||l_proc,20);
423: end chk_ddf;
424: --
425: -- ----------------------------------------------------------------------------
426: -- |------------------------------< chk_df >----------------------------------|

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

456: --
457: l_proc varchar2(72) := g_package || 'chk_df';
458: --
459: begin
460: hr_utility.set_location('Entering:'||l_proc,10);
461: --
462: if ((p_rec.veh_alloc_extra_info_id is not null) and (
463: nvl(pqp_vai_shd.g_old_rec.vaei_attribute_category, hr_api.g_varchar2) <>
464: nvl(p_rec.vaei_attribute_category, hr_api.g_varchar2) or

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

555: ,p_attribute20_value => p_rec.vaei_attribute20
556: );
557: end if;
558: --
559: hr_utility.set_location(' Leaving:'||l_proc,20);
560: end chk_df;
561: --
562: -- ----------------------------------------------------------------------------
563: -- |-----------------------< chk_non_updateable_args >------------------------|

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

621: --
622: l_proc varchar2(72) := g_package||'insert_validate';
623: --
624: Begin
625: hr_utility.set_location('Entering:'||l_proc, 5);
626: --
627: -- Call all supporting business operations
628: --
629: --

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

640: pqp_vai_bus.chk_ddf(p_rec);
641: --
642: -- pqp_vai_bus.chk_df(p_rec);
643: --
644: hr_utility.set_location(' Leaving:'||l_proc, 10);
645: End insert_validate;
646: --
647: -- ----------------------------------------------------------------------------
648: -- |---------------------------< update_validate >----------------------------|

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

653: --
654: l_proc varchar2(72) := g_package||'update_validate';
655: --
656: Begin
657: hr_utility.set_location('Entering:'||l_proc, 5);
658: --
659: -- Call all supporting business operations
660: --
661: --

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

676: pqp_vai_bus.chk_ddf(p_rec);
677: --
678: pqp_vai_bus.chk_df(p_rec);
679: --
680: hr_utility.set_location(' Leaving:'||l_proc, 10);
681: End update_validate;
682: --
683: -- ----------------------------------------------------------------------------
684: -- |---------------------------< delete_validate >----------------------------|

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

689: --
690: l_proc varchar2(72) := g_package||'delete_validate';
691: --
692: Begin
693: hr_utility.set_location('Entering:'||l_proc, 5);
694: --
695: -- Call all supporting business operations
696: --
697: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

693: hr_utility.set_location('Entering:'||l_proc, 5);
694: --
695: -- Call all supporting business operations
696: --
697: hr_utility.set_location(' Leaving:'||l_proc, 10);
698: End delete_validate;
699: --
700: end pqp_vai_bus;