DBA Data[Home] [Help]

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

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

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

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

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

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

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

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

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

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

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

163: close csr_leg_code;
164: per_pac_bus.g_allocated_checklist_id := p_allocated_checklist_id;
165: per_pac_bus.g_legislation_code := l_legislation_code;
166: end if;
167: hr_utility.set_location(' Leaving:'|| l_proc, 40);
168: return l_legislation_code;
169: end return_legislation_code;
170: --
171: -- ----------------------------------------------------------------------------

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

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

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

215: THEN
216: RETURN;
217: END IF;
218: --
219: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
220: --
221: hr_utility.set_location(l_proc,10);
222: --
223: IF p_checklist_name IS NOT NULL THEN

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

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

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

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

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

248: WHEN app_exception.application_exception THEN
249: IF hr_multi_message.exception_add
250: (p_associated_column1 => 'PER_ALLOCATED_CHECKLISTS.CHECKLIST_NAME'
251: ) THEN
252: hr_utility.set_location(' Leaving:'|| l_proc, 40);
253: RAISE;
254: END IF;
255: END chk_name_unq;
256: --

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

288: --
289: l_proc varchar2(72) := g_package || 'chk_ddf';
290: --
291: begin
292: hr_utility.set_location('Entering:'||l_proc,10);
293: --
294: /*
295: if ((p_rec.allocated_checklist_id is not null) and (
296: nvl(per_pac_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

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

389: );
390: end if;
391: */
392: --
393: hr_utility.set_location(' Leaving:'||l_proc,20);
394: end chk_ddf;
395: --
396: -- ----------------------------------------------------------------------------
397: -- |------------------------------< chk_df >----------------------------------|

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

427: --
428: l_proc varchar2(72) := g_package || 'chk_df';
429: --
430: begin
431: hr_utility.set_location('Entering:'||l_proc,10);
432: --
433: /*
434: if ((p_rec.allocated_checklist_id is not null) and (
435: nvl(per_pac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

528: );
529: end if;
530: --
531: */
532: hr_utility.set_location(' Leaving:'||l_proc,20);
533: end chk_df;
534: --
535: -- ----------------------------------------------------------------------------
536: -- |-----------------------< chk_non_updateable_args >------------------------|

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

597: --
598: l_proc varchar2(72) := g_package||'insert_validate';
599: --
600: Begin
601: hr_utility.set_location('Entering:'||l_proc, 5);
602: --
603: -- Call all supporting business operations
604: --
605: per_pac_bus.chk_name_unq

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

615: per_pac_bus.chk_ddf(p_rec);
616: --
617: per_pac_bus.chk_df(p_rec);
618: --
619: hr_utility.set_location(' Leaving:'||l_proc, 10);
620: End insert_validate;
621: --
622: -- ----------------------------------------------------------------------------
623: -- |---------------------------< update_validate >----------------------------|

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

629: --
630: l_proc varchar2(72) := g_package||'update_validate';
631: --
632: Begin
633: hr_utility.set_location('Entering:'||l_proc, 5);
634: --
635: -- Call all supporting business operations
636: --
637: per_pac_bus.chk_name_unq

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

653: per_pac_bus.chk_ddf(p_rec);
654: --
655: per_pac_bus.chk_df(p_rec);
656: --
657: hr_utility.set_location(' Leaving:'||l_proc, 10);
658: End update_validate;
659: --
660: -- ----------------------------------------------------------------------------
661: -- |---------------------------< delete_validate >----------------------------|

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

666: --
667: l_proc varchar2(72) := g_package||'delete_validate';
668: --
669: Begin
670: hr_utility.set_location('Entering:'||l_proc, 5);
671: --
672: -- Call all supporting business operations
673: --
674: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

670: hr_utility.set_location('Entering:'||l_proc, 5);
671: --
672: -- Call all supporting business operations
673: --
674: hr_utility.set_location(' Leaving:'||l_proc, 10);
675: End delete_validate;
676: --
677: end per_pac_bus;