DBA Data[Home] [Help]

APPS.HR_TCN_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_tcn_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_tcn_bus.g_template_canvas_id:= p_template_canvas_id;
107: hr_tcn_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 205: hr_utility.set_location('Entering:'||l_proc, 10);

201: l_api_updating boolean;
202: l_canvas_type varchar2(30);
203: --
204: Begin
205: hr_utility.set_location('Entering:'||l_proc, 10);
206: --
207: l_api_updating := hr_tcn_shd.api_updating
208: (p_template_canvas_id => p_template_canvas_id
209: ,p_object_version_number => p_object_version_number

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

207: l_api_updating := hr_tcn_shd.api_updating
208: (p_template_canvas_id => p_template_canvas_id
209: ,p_object_version_number => p_object_version_number
210: );
211: hr_utility.set_location(l_proc,20);
212: --
213: -- Only proceed with SQL validation if absolutely necessary
214: --
215: if ( ( l_api_updating

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

216: and nvl(hr_fcn_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
217: nvl(p_form_canvas_id,hr_api.g_number))
218: or (NOT l_api_updating)) then
219: --
220: hr_utility.set_location(l_proc,30);
221: --
222: -- Check value has been passed
223: --
224: hr_api.mandatory_arg_error

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

250: */
251: --
252: end if;
253: --
254: hr_utility.set_location('Leaving:'||l_proc, 100);
255: End chk_form_canvas_id;
256: --
257: -- ----------------------------------------------------------------------------
258: -- |------------------------< chk_template_window_id >------------------------|

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

266: l_proc varchar2(72) := g_package || 'chk_template_window_id';
267: l_api_updating boolean;
268: --
269: Begin
270: hr_utility.set_location('Entering:'||l_proc, 10);
271: --
272: -- Check value has been passed
273: --
274: hr_api.mandatory_arg_error

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

276: ,p_argument => 'template_window_id'
277: ,p_argument_value => p_template_window_id
278: );
279: --
280: hr_utility.set_location('Leaving:'||l_proc, 100);
281: End chk_template_window_id;
282: --
283: -- ----------------------------------------------------------------------------
284: -- |-------------------------< chk_canvas_and_window >------------------------|

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

305: l_canvas_window_id number;
306: l_window_window_id number;
307: --
308: Begin
309: hr_utility.set_location('Entering:'||l_proc, 10);
310: --
311: l_api_updating := hr_tcn_shd.api_updating
312: (p_template_canvas_id => p_template_canvas_id
313: ,p_object_version_number => p_object_version_number

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

311: l_api_updating := hr_tcn_shd.api_updating
312: (p_template_canvas_id => p_template_canvas_id
313: ,p_object_version_number => p_object_version_number
314: );
315: hr_utility.set_location(l_proc,20);
316: --
317: -- Only proceed with SQL validation if absolutely necessary
318: --
319: if ( ( l_api_updating

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

322: or nvl(hr_tcn_shd.g_old_rec.template_window_id,hr_api.g_number) <>
323: nvl(p_template_window_id,hr_api.g_number)))
324: or (NOT l_api_updating)) then
325: --
326: hr_utility.set_location(l_proc,30);
327: --
328: -- Check form canvas and template window reference the same form window
329: --
330: open csr_form_canvas;

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

348: fnd_message.raise_error;
349: end if;
350: close csr_template_window;
351: --
352: hr_utility.set_location(l_proc,40);
353: --
354: if nvl(l_canvas_window_id,hr_api.g_number) <>
355: nvl(l_window_window_id,hr_api.g_number) then
356: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

360: end if;
361: --
362: end if;
363: --
364: hr_utility.set_location('Leaving:'||l_proc, 100);
365: End chk_canvas_and_window;
366: --
367: -- ----------------------------------------------------------------------------
368: -- |------------------------------< chk_delete >------------------------------|

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

373: --
374: l_proc varchar2(72) := g_package||'chk_delete';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: -- No additional validation required
380: --
381: null;

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

379: -- No additional validation required
380: --
381: null;
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
384: End chk_delete;
385: --
386: -- ----------------------------------------------------------------------------
387: -- |---------------------------< insert_validate >----------------------------|

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

392: --
393: l_proc varchar2(72) := g_package||'insert_validate';
394: --
395: Begin
396: hr_utility.set_location('Entering:'||l_proc, 5);
397: --
398: -- Call all supporting business operations
399: -- No business group context. HR_STANDARD_LOOKUPS used for validation.
400: --

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

416: ,p_form_canvas_id => p_rec.form_canvas_id
417: ,p_template_window_id => p_rec.template_window_id
418: );
419: --
420: hr_utility.set_location(' Leaving:'||l_proc, 10);
421: End insert_validate;
422: --
423: -- ----------------------------------------------------------------------------
424: -- |---------------------------< update_validate >----------------------------|

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

429: --
430: l_proc varchar2(72) := g_package||'update_validate';
431: --
432: Begin
433: hr_utility.set_location('Entering:'||l_proc, 5);
434: --
435: -- Call all supporting business operations
436: -- No business group context. HR_STANDARD_LOOKUPS used for validation.
437: --

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

457: ,p_form_canvas_id => p_rec.form_canvas_id
458: ,p_template_window_id => p_rec.template_window_id
459: );
460: --
461: hr_utility.set_location(' Leaving:'||l_proc, 10);
462: End update_validate;
463: --
464: -- ----------------------------------------------------------------------------
465: -- |---------------------------< delete_validate >----------------------------|

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

470: --
471: l_proc varchar2(72) := g_package||'delete_validate';
472: --
473: Begin
474: hr_utility.set_location('Entering:'||l_proc, 5);
475: --
476: -- Call all supporting business operations
477: --
478: chk_delete

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

478: chk_delete
479: (p_rec => p_rec
480: );
481: --
482: hr_utility.set_location(' Leaving:'||l_proc, 10);
483: End delete_validate;
484: --
485: end hr_tcn_bus;