DBA Data[Home] [Help]

APPS.HR_TTP_BUS dependencies on HR_UTILITY

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

24: l_proc varchar2(72) := g_package||'set_security_group_id';
25: --
26: begin
27: --
28: hr_utility.set_location('Entering:'|| l_proc, 10);
29: --
30: -- No business group context. Security group is not applicable.
31: --
32: null;

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

30: -- No business group context. Security group is not applicable.
31: --
32: null;
33: --
34: hr_utility.set_location(' Leaving:'|| l_proc, 20);
35: --
36: end set_security_group_id;
37: --
38: --

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

64: l_proc varchar2(72) := g_package||'return_legislation_code';
65: --
66: Begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);
69: --
70: -- Ensure that all the mandatory parameter are not null
71: --
72: hr_api.mandatory_arg_error

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

82: -- call to this function. Just return the value in the global
83: -- variable.
84: --
85: l_legislation_code := hr_ttp_bus.g_legislation_code;
86: hr_utility.set_location(l_proc, 20);
87: else
88: --
89: -- The ID is different to the last call to this function
90: -- or this is the first call to this function.

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

99: close csr_leg_code;
100: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
101: fnd_message.raise_error;
102: end if;
103: hr_utility.set_location(l_proc,30);
104: --
105: -- Set the global variables so the values are
106: -- available for the next call to this function.
107: --

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

108: close csr_leg_code;
109: hr_ttp_bus.g_template_tab_page_id := p_template_tab_page_id;
110: hr_ttp_bus.g_legislation_code := l_legislation_code;
111: end if;
112: hr_utility.set_location(' Leaving:'|| l_proc, 40);
113: return l_legislation_code;
114: end return_legislation_code;
115: --
116: -- ----------------------------------------------------------------------------

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

198: l_proc varchar2(72) := g_package || 'chk_form_tab_page_id';
199: l_api_updating boolean;
200: --
201: Begin
202: hr_utility.set_location('Entering:'||l_proc, 10);
203: --
204: -- Check value has been passed
205: --
206: hr_api.mandatory_arg_error

Line 212: hr_utility.set_location(' Leaving:'||l_proc, 100);

208: ,p_argument => 'form_tab_page_id'
209: ,p_argument_value => p_form_tab_page_id
210: );
211: --
212: hr_utility.set_location(' Leaving:'||l_proc, 100);
213: End chk_form_tab_page_id;
214: --
215: -- ----------------------------------------------------------------------------
216: -- |------------------------< chk_template_canvas_id >------------------------|

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

224: l_proc varchar2(72) := g_package || 'chk_template_canvas_id';
225: l_api_updating boolean;
226: --
227: Begin
228: hr_utility.set_location('Entering:'||l_proc, 10);
229: --
230: -- Check value has been passed
231: --
232: hr_api.mandatory_arg_error

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

234: ,p_argument => 'template_canvas_id'
235: ,p_argument_value => p_template_canvas_id
236: );
237: --
238: hr_utility.set_location(' Leaving:'||l_proc, 100);
239: End chk_template_canvas_id;
240: --
241: -- ----------------------------------------------------------------------------
242: -- |------------------------< chk_tab_page_and_canvas >-----------------------|

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

263: l_tab_page_canvas_id number;
264: l_canvas_canvas_id number;
265: --
266: Begin
267: hr_utility.set_location('Entering:'||l_proc, 10);
268: --
269: l_api_updating := hr_ttp_shd.api_updating
270: (p_template_tab_page_id => p_template_tab_page_id
271: ,p_object_version_number => p_object_version_number

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

269: l_api_updating := hr_ttp_shd.api_updating
270: (p_template_tab_page_id => p_template_tab_page_id
271: ,p_object_version_number => p_object_version_number
272: );
273: hr_utility.set_location(l_proc, 20);
274: --
275: -- Only proceed with SQL validation if absolutely necessary
276: --
277: if ( ( l_api_updating

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

280: or nvl(hr_ttp_shd.g_old_rec.template_canvas_id,hr_api.g_number) <>
281: nvl(p_template_canvas_id,hr_api.g_number)))
282: or (NOT l_api_updating)) then
283: --
284: hr_utility.set_location(l_proc,30);
285: --
286: -- Check form tab page and template canvas reference same form canvas
287: --
288: open csr_form_tab_page;

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

306: fnd_message.raise_error;
307: end if;
308: close csr_template_canvas;
309: --
310: hr_utility.set_location(l_proc,40);
311: --
312: if nvl(l_tab_page_canvas_id,hr_api.g_number) <>
313: nvl(l_canvas_canvas_id,hr_api.g_number) then
314: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 322: hr_utility.set_location(' Leaving:'||l_proc, 100);

318: end if;
319: --
320: end if;
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 100);
323: End chk_tab_page_and_canvas;
324: --
325: -- ----------------------------------------------------------------------------
326: -- |------------------------------< chk_delete >------------------------------|

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

331: --
332: l_proc varchar2(72) := g_package||'chk_delete';
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: --
337: -- No additional validation required
338: --
339: null;

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

337: -- No additional validation required
338: --
339: null;
340: --
341: hr_utility.set_location(' Leaving:'||l_proc, 10);
342: End chk_delete;
343: --
344: -- ----------------------------------------------------------------------------
345: -- |---------------------------< insert_validate >----------------------------|

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

350: --
351: l_proc varchar2(72) := g_package||'insert_validate';
352: --
353: Begin
354: hr_utility.set_location('Entering:'||l_proc, 5);
355: --
356: -- Call all supporting business operations
357: -- No business group context. HR_STANDARD_LOOKUPS used for validation.
358: --

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

374: ,p_form_tab_page_id => p_rec.form_tab_page_id
375: ,p_template_canvas_id => p_rec.template_canvas_id
376: );
377: --
378: hr_utility.set_location(' Leaving:'||l_proc, 10);
379: End insert_validate;
380: --
381: -- ----------------------------------------------------------------------------
382: -- |---------------------------< update_validate >----------------------------|

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

387: --
388: l_proc varchar2(72) := g_package||'update_validate';
389: --
390: Begin
391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: -- Call all supporting business operations
394: -- No business group context. HR_STANDARD_LOOKUPS used for validation.
395: --

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

415: ,p_form_tab_page_id => p_rec.form_tab_page_id
416: ,p_template_canvas_id => p_rec.template_canvas_id
417: );
418: --
419: hr_utility.set_location(' Leaving:'||l_proc, 10);
420: End update_validate;
421: --
422: -- ----------------------------------------------------------------------------
423: -- |---------------------------< delete_validate >----------------------------|

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

428: --
429: l_proc varchar2(72) := g_package||'delete_validate';
430: --
431: Begin
432: hr_utility.set_location('Entering:'||l_proc, 5);
433: --
434: -- Call all supporting business operations
435: --
436: chk_delete

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

436: chk_delete
437: (p_rec => p_rec
438: );
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 10);
441: End delete_validate;
442: --
443: end hr_ttp_bus;