DBA Data[Home] [Help]

APPS.PER_PAT_BUS dependencies on HR_UTILITY

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_pat_bus.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- The following two global variables are only to be
12: -- used by the return_legislation_code function.
13: --

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

47: l_legislation_code varchar2(150);
48: --
49: begin
50: --
51: hr_utility.set_location('Entering:'|| l_proc, 10);
52: --
53: -- Ensure that all the mandatory parameter are not null
54: --
55: hr_api.mandatory_arg_error

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

87: --
88: hr_api.set_legislation_context(l_legislation_code);
89: end if;
90: --
91: hr_utility.set_location(' Leaving:'|| l_proc, 20);
92: --
93: end set_security_group_id;
94: --
95: -- ---------------------------------------------------------------------------

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

122: l_proc varchar2(72) := g_package||'return_legislation_code';
123: --
124: Begin
125: --
126: hr_utility.set_location('Entering:'|| l_proc, 10);
127: --
128: -- Ensure that all the mandatory parameter are not null
129: --
130: hr_api.mandatory_arg_error

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

140: -- call to this function. Just return the value in the global
141: -- variable.
142: --
143: l_legislation_code := per_pat_bus.g_legislation_code;
144: hr_utility.set_location(l_proc, 20);
145: else
146: --
147: -- The ID is different to the last call to this function
148: -- or this is the first call to this function.

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

157: close csr_leg_code;
158: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
159: fnd_message.raise_error;
160: end if;
161: hr_utility.set_location(l_proc,30);
162: --
163: -- Set the global variables so the values are
164: -- available for the next call to this function.
165: --

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

166: close csr_leg_code;
167: per_pat_bus.g_allocated_task_id := p_allocated_task_id;
168: per_pat_bus.g_legislation_code := l_legislation_code;
169: end if;
170: hr_utility.set_location(' Leaving:'|| l_proc, 40);
171: return l_legislation_code;
172: end return_legislation_code;
173: --
174: -- ----------------------------------------------------------------------------

Line 202: IF g_debug THEN hr_utility.set_location('Entering:'||l_proc, 10); END IF;

198: l_proc VARCHAR2(72) := g_package||'chk_name_unq';
199: l_api_updating BOOLEAN;
200: --
201: BEGIN
202: IF g_debug THEN hr_utility.set_location('Entering:'||l_proc, 10); END IF;
203: --
204: -- Only proceed with validation if:
205: -- a) The current g_old_rec is current and
206: -- b) The checklist name value has changed

Line 221: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;

217: THEN
218: RETURN;
219: END IF;
220: --
221: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
222: --
223: hr_utility.set_location(l_proc,30);
224: --
225: IF p_task_name IS NOT NULL THEN

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

219: END IF;
220: --
221: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
222: --
223: hr_utility.set_location(l_proc,30);
224: --
225: IF p_task_name IS NOT NULL THEN
226: -- Check that name is unique
227: OPEN csr_unique_name;

Line 247: IF g_debug THEN hr_utility.set_location('Leaving:'||l_proc, 40); END IF;

243: fnd_message.set_name('PER','PER_449679_CKL_TASK_NAME_REQD');
244: fnd_message.raise_error;
245: END IF;
246: --
247: IF g_debug THEN hr_utility.set_location('Leaving:'||l_proc, 40); END IF;
248: --
249: EXCEPTION
250: WHEN app_exception.application_exception THEN
251: IF hr_multi_message.exception_add

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

250: WHEN app_exception.application_exception THEN
251: IF hr_multi_message.exception_add
252: (p_associated_column1 => 'PER_ALLOCATED_TASKS.TASK_NAME'
253: ) THEN
254: hr_utility.set_location(' Leaving:'|| l_proc, 50);
255: RAISE;
256: END IF;
257: END chk_name_unq;
258: --

Line 276: IF g_debug THEN hr_utility.set_location('Entering:'||l_proc, 10); END IF;

272: l_proc VARCHAR2(72) := g_package||'chk_task_dates';
273: --
274: BEGIN
275: --
276: IF g_debug THEN hr_utility.set_location('Entering:'||l_proc, 10); END IF;
277: --
278: IF (p_target_end_date IS NOT NULL AND p_target_start_date IS NULL) OR
279: (p_actual_end_date IS NOT NULL AND p_actual_start_date IS NULL) THEN
280: --

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

277: --
278: IF (p_target_end_date IS NOT NULL AND p_target_start_date IS NULL) OR
279: (p_actual_end_date IS NOT NULL AND p_actual_start_date IS NULL) THEN
280: --
281: hr_utility.set_location(l_proc,20);
282: --
283: fnd_message.set_name('PER','PER_449676_CKL_TSK_DATE_ERR');
284: fnd_message.raise_error;
285: --

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

293: p_actual_end_date IS NOT NULL AND
294: p_actual_end_date < p_actual_start_date)
295: ) THEN
296: --
297: hr_utility.set_location(l_proc,30);
298: --
299: fnd_message.set_name('PER','PER_449677_CKL_TSK_DATE_RANGE');
300: fnd_message.raise_error;
301: --

Line 304: IF g_debug THEN hr_utility.set_location('Leaving:'||l_proc, 40); END IF;

300: fnd_message.raise_error;
301: --
302: END IF;
303: --
304: IF g_debug THEN hr_utility.set_location('Leaving:'||l_proc, 40); END IF;
305: --
306: EXCEPTION
307: WHEN app_exception.application_exception THEN
308: IF hr_multi_message.exception_add

Line 311: hr_utility.set_location(' Leaving:'|| l_proc, 50);

307: WHEN app_exception.application_exception THEN
308: IF hr_multi_message.exception_add
309: (p_associated_column1 => 'PER_ALLOCATED_TASKS.TARGET/ACTUAL_START/END_DATE'
310: ) THEN
311: hr_utility.set_location(' Leaving:'|| l_proc, 50);
312: RAISE;
313: END IF;
314: END chk_task_dates;
315: --

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

347: --
348: l_proc varchar2(72) := g_package || 'chk_ddf';
349: --
350: begin
351: hr_utility.set_location('Entering:'||l_proc,10);
352: --
353: /*
354: if ((p_rec.allocated_task_id is not null) and (
355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

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

448: );
449: end if;
450: --
451: */
452: hr_utility.set_location(' Leaving:'||l_proc,20);
453: end chk_ddf;
454: --
455: -- ----------------------------------------------------------------------------
456: -- |------------------------------< chk_df >----------------------------------|

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

486: --
487: l_proc varchar2(72) := g_package || 'chk_df';
488: --
489: begin
490: hr_utility.set_location('Entering:'||l_proc,10);
491: --
492:
493: /* if ((p_rec.allocated_task_id is not null) and (
494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

587: );
588: end if;
589: */
590: --
591: hr_utility.set_location(' Leaving:'||l_proc,20);
592: end chk_df;
593: --
594: -- ----------------------------------------------------------------------------
595: -- |-----------------------< chk_non_updateable_args >------------------------|

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

655: --
656: l_proc varchar2(72) := g_package||'insert_validate';
657: --
658: Begin
659: hr_utility.set_location('Entering:'||l_proc, 5);
660: --
661: -- Call all supporting business operations
662: --
663: per_pat_bus.chk_name_unq

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

679: per_pat_bus.chk_ddf(p_rec);
680: --
681: per_pat_bus.chk_df(p_rec);
682: --
683: hr_utility.set_location(' Leaving:'||l_proc, 10);
684: End insert_validate;
685: --
686: -- ----------------------------------------------------------------------------
687: -- |---------------------------< update_validate >----------------------------|

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

693: --
694: l_proc varchar2(72) := g_package||'update_validate';
695: --
696: Begin
697: hr_utility.set_location('Entering:'||l_proc, 5);
698: --
699: -- Call all supporting business operations
700: --
701: per_pat_bus.chk_name_unq

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

723: per_pat_bus.chk_ddf(p_rec);
724: --
725: per_pat_bus.chk_df(p_rec);
726: --
727: hr_utility.set_location(' Leaving:'||l_proc, 10);
728: End update_validate;
729: --
730: -- ----------------------------------------------------------------------------
731: -- |---------------------------< delete_validate >----------------------------|

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

736: --
737: l_proc varchar2(72) := g_package||'delete_validate';
738: --
739: Begin
740: hr_utility.set_location('Entering:'||l_proc, 5);
741: --
742: -- Call all supporting business operations
743: --
744: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

740: hr_utility.set_location('Entering:'||l_proc, 5);
741: --
742: -- Call all supporting business operations
743: --
744: hr_utility.set_location(' Leaving:'||l_proc, 10);
745: End delete_validate;
746: --
747: end per_pat_bus;