DBA Data[Home] [Help]

APPS.PAY_RTT_BUS dependencies on HR_UTILITY

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

38: l_proc varchar2(72) := g_package||'set_security_group_id';
39: --
40: begin
41: --
42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: /*
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --

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

72: (p_security_group_id => l_security_group_id
73: );
74: --
75: */
76: hr_utility.set_location(' Leaving:'|| l_proc, 20);
77: --
78: end set_security_group_id;
79: --
80: -- ---------------------------------------------------------------------------

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

109: l_proc varchar2(72) := g_package||'return_legislation_code';
110: --
111: Begin
112: --
113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Ensure that all the mandatory parameter are not null
116: --
117: hr_api.mandatory_arg_error

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

130: -- call to this function. Just return the value in the global
131: -- variable.
132: --
133: l_legislation_code := pay_rtt_bus.g_legislation_code;
134: hr_utility.set_location(l_proc, 20);
135: else
136: --
137: -- The ID is different to the last call to this function
138: -- or this is the first call to this function.

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

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

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

157: pay_rtt_bus.g_run_type_id := p_run_type_id;
158: pay_rtt_bus.g_language := p_language;
159: pay_rtt_bus.g_legislation_code := l_legislation_code;
160: end if;
161: hr_utility.set_location(' Leaving:'|| l_proc, 40);
162: return l_legislation_code;
163: end return_legislation_code;
164: --
165: -- ----------------------------------------------------------------------------

Line 272: hr_utility.trace('l_rt_id is: '||to_char(p_run_type_id));

268: l_rt_id number;
269: --
270: Begin
271: --
272: hr_utility.trace('l_rt_id is: '||to_char(p_run_type_id));
273: OPEN csr_chk_rt_id;
274: FETCH csr_chk_rt_id into l_rt_id;
275: IF csr_chk_rt_id%NOTFOUND THEN
276: --

Line 278: hr_utility.set_message(801, 'HR_33999_RTT_INV_ID');

274: FETCH csr_chk_rt_id into l_rt_id;
275: IF csr_chk_rt_id%NOTFOUND THEN
276: --
277: CLOSE csr_chk_rt_id;
278: hr_utility.set_message(801, 'HR_33999_RTT_INV_ID');
279: hr_utility.raise_error;
280: END IF;
281: CLOSE csr_chk_rt_id;
282: --

Line 279: hr_utility.raise_error;

275: IF csr_chk_rt_id%NOTFOUND THEN
276: --
277: CLOSE csr_chk_rt_id;
278: hr_utility.set_message(801, 'HR_33999_RTT_INV_ID');
279: hr_utility.raise_error;
280: END IF;
281: CLOSE csr_chk_rt_id;
282: --
283: END chk_run_type_id;

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

343: l_leg_code varchar2(10);
344: l_exists varchar2(10);
345: --
346: BEGIN
347: hr_utility.set_location('Entering: '||l_proc,5);
348: --
349: -- Only need to opent the cursor if run_type_name is not null
350: --
351: if p_run_type_name is not null then

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

348: --
349: -- Only need to opent the cursor if run_type_name is not null
350: --
351: if p_run_type_name is not null then
352: hr_utility.set_location(l_proc, 10);
353: --
354: OPEN get_startup_data;
355: FETCH get_startup_data into l_bg_id, l_leg_code;
356: CLOSE get_startup_data;

Line 362: hr_utility.set_message(801,'HR_33998_RTT_DUP_NAME');

358: OPEN csr_tl_name_exists(l_bg_id, l_leg_code);
359: FETCH csr_tl_name_exists into l_exists;
360: IF csr_tl_name_exists%FOUND THEN
361: --
362: hr_utility.set_message(801,'HR_33998_RTT_DUP_NAME');
363: hr_utility.raise_error;
364: END IF;
365: hr_utility.set_location(l_proc, 15);
366: CLOSE csr_tl_name_exists;

Line 363: hr_utility.raise_error;

359: FETCH csr_tl_name_exists into l_exists;
360: IF csr_tl_name_exists%FOUND THEN
361: --
362: hr_utility.set_message(801,'HR_33998_RTT_DUP_NAME');
363: hr_utility.raise_error;
364: END IF;
365: hr_utility.set_location(l_proc, 15);
366: CLOSE csr_tl_name_exists;
367: end if;

Line 365: hr_utility.set_location(l_proc, 15);

361: --
362: hr_utility.set_message(801,'HR_33998_RTT_DUP_NAME');
363: hr_utility.raise_error;
364: END IF;
365: hr_utility.set_location(l_proc, 15);
366: CLOSE csr_tl_name_exists;
367: end if;
368: hr_utility.set_location('Leaving: '||l_proc, 20);
369: end chk_tl_run_type_name;

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

364: END IF;
365: hr_utility.set_location(l_proc, 15);
366: CLOSE csr_tl_name_exists;
367: end if;
368: hr_utility.set_location('Leaving: '||l_proc, 20);
369: end chk_tl_run_type_name;
370: -- ----------------------------------------------------------------------------
371: -- |---------------------------< insert_validate >----------------------------|
372: -- ----------------------------------------------------------------------------

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

377: --
378: l_proc varchar2(72) := g_package||'insert_validate';
379: --
380: Begin
381: hr_utility.set_location('Entering:'||l_proc, 5);
382: --
383: chk_run_type_id(p_run_type_id => p_run_type_id);
384: --
385: hr_utility.set_location(l_proc, 10);

Line 385: hr_utility.set_location(l_proc, 10);

381: hr_utility.set_location('Entering:'||l_proc, 5);
382: --
383: chk_run_type_id(p_run_type_id => p_run_type_id);
384: --
385: hr_utility.set_location(l_proc, 10);
386: --
387: chk_tl_run_type_name(p_run_type_id => p_rec.run_type_id
388: ,p_language => p_rec.language
389: ,p_run_type_name => p_rec.run_type_name);

Line 391: hr_utility.set_location(l_proc, 15);

387: chk_tl_run_type_name(p_run_type_id => p_rec.run_type_id
388: ,p_language => p_rec.language
389: ,p_run_type_name => p_rec.run_type_name);
390: --
391: hr_utility.set_location(l_proc, 15);
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 20);
394: End insert_validate;
395: --

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

389: ,p_run_type_name => p_rec.run_type_name);
390: --
391: hr_utility.set_location(l_proc, 15);
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 20);
394: End insert_validate;
395: --
396: -- ----------------------------------------------------------------------------
397: -- |---------------------------< update_validate >----------------------------|

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

402: --
403: l_proc varchar2(72) := g_package||'update_validate';
404: --
405: Begin
406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: -- Call all supporting business operations
409: --
410: chk_run_type_id(p_run_type_id => p_rec.run_type_id);

Line 412: hr_utility.set_location(l_proc, 10);

408: -- Call all supporting business operations
409: --
410: chk_run_type_id(p_run_type_id => p_rec.run_type_id);
411: --
412: hr_utility.set_location(l_proc, 10);
413: --
414: -- RET 12-DEC-2001 removed as run_type_name is no longer updateable. Made this
415: -- change as run type name is the key for uploading run types via the ldt.
416: --

Line 423: hr_utility.set_location(l_proc, 15);

419: ,p_language => p_rec.language
420: ,p_run_type_name => p_rec.run_type_name);
421: */
422: --
423: hr_utility.set_location(l_proc, 15);
424: --
425: hr_utility.set_location(l_proc, 20);
426: chk_non_updateable_args
427: (p_rec => p_rec

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

421: */
422: --
423: hr_utility.set_location(l_proc, 15);
424: --
425: hr_utility.set_location(l_proc, 20);
426: chk_non_updateable_args
427: (p_rec => p_rec
428: );
429: --

Line 430: hr_utility.set_location(' Leaving:'||l_proc, 25);

426: chk_non_updateable_args
427: (p_rec => p_rec
428: );
429: --
430: hr_utility.set_location(' Leaving:'||l_proc, 25);
431: End update_validate;
432: --
433: -- ----------------------------------------------------------------------------
434: -- |---------------------------< delete_validate >----------------------------|

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

439: --
440: l_proc varchar2(72) := g_package||'delete_validate';
441: --
442: Begin
443: hr_utility.set_location('Entering:'||l_proc, 5);
444: --
445: -- Call all supporting business operations
446: --
447: chk_run_type_id(p_run_type_id => p_rec.run_type_id);

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

445: -- Call all supporting business operations
446: --
447: chk_run_type_id(p_run_type_id => p_rec.run_type_id);
448: --
449: hr_utility.set_location(' Leaving:'||l_proc, 10);
450: End delete_validate;
451: --
452: end pay_rtt_bus;