DBA Data[Home] [Help]

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

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

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

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

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

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

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

107: close csr_leg_code;
108: hr_tcp_bus.g_template_item_context_page_i := p_template_item_context_page_i;
109: hr_tcp_bus.g_legislation_code := l_legislation_code;
110: end if;
111: hr_utility.set_location(' Leaving:'|| l_proc, 40);
112: return l_legislation_code;
113: end return_legislation_code;
114: --
115: -- ----------------------------------------------------------------------------

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

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

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

207: ,p_argument => 'template_item_context_id'
208: ,p_argument_value => p_template_item_context_id
209: );
210: --
211: hr_utility.set_location('Leaving:'||l_proc, 100);
212: End chk_template_item_context_id;
213: --
214: -- ----------------------------------------------------------------------------
215: -- |-----------------------< chk_template_tab_page_id >-----------------------|

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

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

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

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

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

285: l_tab_page_template_id number;
286: l_dummy varchar2(1);
287: --
288: Begin
289: hr_utility.set_location('Entering:'||l_proc, 10);
290: --
291: l_api_updating := hr_tcp_shd.api_updating
292: (p_template_item_context_page_i => p_template_item_context_page_i
293: ,p_object_version_number => p_object_version_number

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

291: l_api_updating := hr_tcp_shd.api_updating
292: (p_template_item_context_page_i => p_template_item_context_page_i
293: ,p_object_version_number => p_object_version_number
294: );
295: hr_utility.set_location(l_proc,20);
296: --
297: -- Only proceed with SQL validation if absolutely necessary
298: --
299: if ( ( l_api_updating

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

302: or nvl(hr_tcp_shd.g_old_rec.template_tab_page_id,hr_api.g_number) <>
303: nvl(p_template_tab_page_id,hr_api.g_number)))
304: or (NOT l_api_updating)) then
305: --
306: hr_utility.set_location(l_proc,30);
307: --
308: open csr_template_item_context;
309: fetch csr_template_item_context into l_context_template_id;
310: if csr_template_item_context%notfound then

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

326: fnd_message.raise_error;
327: end if;
328: close csr_template_tab_page;
329: --
330: hr_utility.set_location(l_proc,40);
331: --
332: -- Check context and tab page reference the same template
333: --
334: if nvl(l_context_template_id,hr_api.g_number) <>

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

338: fnd_message.set_token('STEP','30');
339: fnd_message.raise_error;
340: end if;
341: --
342: hr_utility.set_location(l_proc,50);
343: --
344: -- Check context and tab page reference the same tab stacked canvas
345: --
346: open csr_tab_stacked_canvas;

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

355: close csr_tab_stacked_canvas;
356: --
357: end if;
358: --
359: hr_utility.set_location('Leaving:'||l_proc, 100);
360: End chk_context_and_tab_page;
361: --
362: -- ----------------------------------------------------------------------------
363: -- |------------------------------< chk_delete >------------------------------|

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

368: --
369: l_proc varchar2(72) := g_package||'chk_delete';
370: --
371: Begin
372: hr_utility.set_location('Entering:'||l_proc, 5);
373: --
374: -- No additional validation required
375: --
376: null;

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

374: -- No additional validation required
375: --
376: null;
377: --
378: hr_utility.set_location(' Leaving:'||l_proc, 10);
379: End chk_delete;
380: --
381: -- ----------------------------------------------------------------------------
382: -- |---------------------------< insert_validate >----------------------------|

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

387: --
388: l_proc varchar2(72) := g_package||'insert_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 415: hr_utility.set_location(' Leaving:'||l_proc, 10);

411: ,p_template_item_context_id => p_rec.template_item_context_id
412: ,p_template_tab_page_id => p_rec.template_tab_page_id
413: );
414: --
415: hr_utility.set_location(' Leaving:'||l_proc, 10);
416: End insert_validate;
417: --
418: -- ----------------------------------------------------------------------------
419: -- |---------------------------< update_validate >----------------------------|

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

424: --
425: l_proc varchar2(72) := g_package||'update_validate';
426: --
427: Begin
428: hr_utility.set_location('Entering:'||l_proc, 5);
429: --
430: -- Call all supporting business operations
431: -- No business group context. HR_STANDARD_LOOKUPS used for validation.
432: --

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

452: ,p_template_item_context_id => p_rec.template_item_context_id
453: ,p_template_tab_page_id => p_rec.template_tab_page_id
454: );
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: End update_validate;
458: --
459: -- ----------------------------------------------------------------------------
460: -- |---------------------------< delete_validate >----------------------------|

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

465: --
466: l_proc varchar2(72) := g_package||'delete_validate';
467: --
468: Begin
469: hr_utility.set_location('Entering:'||l_proc, 5);
470: --
471: -- Call all supporting business operations
472: --
473: chk_delete

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

473: chk_delete
474: (p_rec => p_rec
475: );
476: --
477: hr_utility.set_location(' Leaving:'||l_proc, 10);
478: End delete_validate;
479: --
480: end hr_tcp_bus;