DBA Data[Home] [Help]

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

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

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

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

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

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

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

105: close csr_leg_code;
106: hr_tip_bus.g_template_item_tab_page_id := p_template_item_tab_page_id;
107: hr_tip_bus.g_legislation_code := l_legislation_code;
108: end if;
109: hr_utility.set_location(' Leaving:'|| l_proc, 40);
110: return l_legislation_code;
111: end return_legislation_code;
112: --
113: -- ----------------------------------------------------------------------------

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

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

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

205: ,p_argument => 'template_item_id'
206: ,p_argument_value => p_template_item_id
207: );
208: --
209: hr_utility.set_location('Leaving:'||l_proc, 100);
210: End chk_template_item_id;
211: --
212: -- ----------------------------------------------------------------------------
213: -- |-----------------------< chk_template_tab_page_id >-----------------------|

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

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

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

231: ,p_argument => 'template_tab_page_id'
232: ,p_argument_value => p_template_tab_page_id
233: );
234: --
235: hr_utility.set_location('Leaving:'||l_proc, 100);
236: End chk_template_tab_page_id;
237: --
238: -- ----------------------------------------------------------------------------
239: -- |-------------------------< chk_item_and_tab_page >------------------------|

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

279: l_tab_page_template_id number;
280: l_dummy varchar2(1);
281: --
282: Begin
283: hr_utility.set_location('Entering:'||l_proc, 10);
284: --
285: l_api_updating := hr_tip_shd.api_updating
286: (p_template_item_tab_page_id => p_template_item_tab_page_id
287: ,p_object_version_number => p_object_version_number

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

285: l_api_updating := hr_tip_shd.api_updating
286: (p_template_item_tab_page_id => p_template_item_tab_page_id
287: ,p_object_version_number => p_object_version_number
288: );
289: hr_utility.set_location(l_proc,20);
290: --
291: -- Only proceed with SQL validation if absolutely necessary
292: --
293: if ( ( l_api_updating

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

296: or nvl(hr_tip_shd.g_old_rec.template_tab_page_id,hr_api.g_number) <>
297: nvl(p_template_tab_page_id,hr_api.g_number)))
298: or (NOT l_api_updating)) then
299: --
300: hr_utility.set_location(l_proc,30);
301: --
302: open csr_template_item;
303: fetch csr_template_item into l_item_template_id;
304: if csr_template_item%notfound then

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

320: fnd_message.raise_error;
321: end if;
322: close csr_template_tab_page;
323: --
324: hr_utility.set_location(l_proc,40);
325: --
326: -- Check item and tab page reference the same template
327: --
328: if nvl(l_item_template_id,hr_api.g_number) <>

Line 336: hr_utility.set_location(l_proc,50);

332: fnd_message.set_token('STEP','30');
333: fnd_message.raise_error;
334: end if;
335: --
336: hr_utility.set_location(l_proc,50);
337: --
338: -- Check item and tab page reference the same tab stacked canvas
339: --
340: open csr_tab_stacked_canvas;

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

349: close csr_tab_stacked_canvas;
350: --
351: end if;
352: --
353: hr_utility.set_location('Leaving:'||l_proc, 100);
354: End chk_item_and_tab_page;
355: --
356: -- ----------------------------------------------------------------------------
357: -- |------------------------------< chk_delete >------------------------------|

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

362: --
363: l_proc varchar2(72) := g_package||'chk_delete';
364: --
365: Begin
366: hr_utility.set_location('Entering:'||l_proc, 5);
367: --
368: -- No additional validation required
369: --
370: null;

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

368: -- No additional validation required
369: --
370: null;
371: --
372: hr_utility.set_location(' Leaving:'||l_proc, 10);
373: End chk_delete;
374: --
375: -- ----------------------------------------------------------------------------
376: -- |---------------------------< insert_validate >----------------------------|

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

381: --
382: l_proc varchar2(72) := g_package||'insert_validate';
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);
386: --
387: -- Call all supporting business operations
388: -- No business group context. HR_STANDARD_LOOKUPS used for validation.
389: --

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

405: ,p_template_item_id => p_rec.template_item_id
406: ,p_template_tab_page_id => p_rec.template_tab_page_id
407: );
408: --
409: hr_utility.set_location(' Leaving:'||l_proc, 10);
410: End insert_validate;
411: --
412: -- ----------------------------------------------------------------------------
413: -- |---------------------------< update_validate >----------------------------|

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

418: --
419: l_proc varchar2(72) := g_package||'update_validate';
420: --
421: Begin
422: hr_utility.set_location('Entering:'||l_proc, 5);
423: --
424: -- Call all supporting business operations
425: -- No business group context. HR_STANDARD_LOOKUPS used for validation.
426: --

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

446: ,p_template_item_id => p_rec.template_item_id
447: ,p_template_tab_page_id => p_rec.template_tab_page_id
448: );
449: --
450: hr_utility.set_location(' Leaving:'||l_proc, 10);
451: End update_validate;
452: --
453: -- ----------------------------------------------------------------------------
454: -- |---------------------------< delete_validate >----------------------------|

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

459: --
460: l_proc varchar2(72) := g_package||'delete_validate';
461: --
462: Begin
463: hr_utility.set_location('Entering:'||l_proc, 5);
464: --
465: -- Call all supporting business operations
466: --
467: chk_delete

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

467: chk_delete
468: (p_rec => p_rec
469: );
470: --
471: hr_utility.set_location(' Leaving:'||l_proc, 10);
472: End delete_validate;
473: --
474: end hr_tip_bus;