eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

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

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

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

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

114: l_proc varchar2(72) := g_package||'return_legislation_code';
115: --
116: Begin
117: --
118: hr_utility.set_location('Entering:'|| l_proc, 10);
119: --
120: -- Ensure that all the mandatory parameter are not null
121: --
122: hr_api.mandatory_arg_error

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

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

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

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

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

158: close csr_leg_code;
159: per_ctk_bus.g_task_in_checklist_id := p_task_in_checklist_id;
160: per_ctk_bus.g_legislation_code := l_legislation_code;
161: end if;
162: hr_utility.set_location(' Leaving:'|| l_proc, 40);
163: return l_legislation_code;
164: end return_legislation_code;
165: --
166: -- ---------------------------------------------------------------------------

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

183: from per_checklists ckl
184: where ckl.checklist_id = p_checklist_id;
185: --
186: begin
187: IF g_debug THEN hr_utility.set_location('Entering:'||l_proc, 10); END IF;
188:
189: --
190: hr_api.mandatory_arg_error
191: (p_api_name => l_proc

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

191: (p_api_name => l_proc
192: ,p_argument => 'p_checklist_id'
193: ,p_argument_value => p_checklist_id
194: );
195: IF g_debug THEN hr_utility.set_location('Entering:'||l_proc, 20); END IF;
196: --
197: -- Check mandatory checklist_id exists and is valid
198: --
199: open csr_ckl_id;

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

206: --
207: end if;
208: close csr_ckl_id;
209: --
210: IF g_debug THEN hr_utility.set_location('Leaving:'||l_proc, 50); END IF;
211: --
212: exception when app_exception.application_exception then
213: IF hr_multi_message.exception_add
214: (p_associated_column1 => 'PER_TASKS_INCHECKLIST.CHECKLIST_ID'

Line 216: hr_utility.set_location(' Leaving:'|| l_proc, 60);

212: exception when app_exception.application_exception then
213: IF hr_multi_message.exception_add
214: (p_associated_column1 => 'PER_TASKS_INCHECKLIST.CHECKLIST_ID'
215: ) then
216: hr_utility.set_location(' Leaving:'|| l_proc, 60);
217: raise;
218: end if;
219: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 70); END IF;
220: end chk_checklist_id;

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

215: ) then
216: hr_utility.set_location(' Leaving:'|| l_proc, 60);
217: raise;
218: end if;
219: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 70); END IF;
220: end chk_checklist_id;
221: --
222: --
223: -- ---------------------------------------------------------------------------

Line 250: hr_utility.set_location('Entering:'||l_proc, 1);

246: and tic.checklist_id = p_checklist_id;
247: --
248: begin
249: if g_debug then
250: hr_utility.set_location('Entering:'||l_proc, 1);
251: end if;
252: --
253: -- Only proceed with validation if:
254: -- a) The current g_old_rec is current and

Line 269: if g_debug then hr_utility.set_location(l_proc, 40); end if;

265: THEN
266: RETURN;
267: END IF;
268: --
269: if g_debug then hr_utility.set_location(l_proc, 40); end if;
270: --
271: -- Check mandatory checklist_task_name exists
272: --
273: if p_checklist_task_name is not null then

Line 293: if g_debug then hr_utility.set_location(l_proc, 5); end if;

289: fnd_message.set_name('PER','PER_449679_CKL_TASK_NAME_REQD');
290: fnd_message.raise_error;
291: end if;
292: --
293: if g_debug then hr_utility.set_location(l_proc, 5); end if;
294: --
295: exception when app_exception.application_exception then
296: if hr_multi_message.exception_add
297: (p_associated_column1 => 'PER_TASKS_INCHECKLIST.NAME'

Line 299: hr_utility.set_location(' Leaving:'|| l_proc, 60);

295: exception when app_exception.application_exception then
296: if hr_multi_message.exception_add
297: (p_associated_column1 => 'PER_TASKS_INCHECKLIST.NAME'
298: ) then
299: hr_utility.set_location(' Leaving:'|| l_proc, 60);
300: raise;
301: end if;
302: hr_utility.set_location(' Leaving:'|| l_proc, 70);
303: end chk_task_name;

Line 302: hr_utility.set_location(' Leaving:'|| l_proc, 70);

298: ) then
299: hr_utility.set_location(' Leaving:'|| l_proc, 60);
300: raise;
301: end if;
302: hr_utility.set_location(' Leaving:'|| l_proc, 70);
303: end chk_task_name;
304: --
305: -- ---------------------------------------------------------------------------
306: -- |----------------------------< chk_duration_uom >-------------------------|

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

321: l_api_updating boolean;
322: --
323: begin
324:
325: IF g_debug then hr_utility.set_location('Entering:'||l_proc, 10); END IF;
326: --
327: -- Only proceed with validation if:
328: -- a) The current g_old_rec is current and
329: -- b) The duration_units or duration_units_uom values are changed

Line 346: IF g_debug then hr_utility.set_location(l_proc, 40); END IF;

342: THEN
343: RETURN;
344: END IF;
345: --
346: IF g_debug then hr_utility.set_location(l_proc, 40); END IF;
347:
348: --
349: -- Checks that the target_duration_uom is valid
350: --

Line 388: IF g_debug then hr_utility.set_location(l_proc, 5); END IF;

384: fnd_message.set_name('PER', 'PER_449680_CKL_UNITS_UOM_INV');
385: fnd_message.raise_error;
386: END IF;
387: --
388: IF g_debug then hr_utility.set_location(l_proc, 5); END IF;
389: --
390: EXCEPTION when app_exception.application_exception then
391: if hr_multi_message.exception_add
392: (p_associated_column1 => 'PER_TASKS_INCHECKLIST.TARGET_DURATION_UOM'

Line 394: hr_utility.set_location(' Leaving:'|| l_proc, 60);

390: EXCEPTION when app_exception.application_exception then
391: if hr_multi_message.exception_add
392: (p_associated_column1 => 'PER_TASKS_INCHECKLIST.TARGET_DURATION_UOM'
393: ) then
394: hr_utility.set_location(' Leaving:'|| l_proc, 60);
395: raise;
396: end if;
397: hr_utility.set_location(' Leaving:'|| l_proc, 70);
398: end chk_duration_uom;

Line 397: hr_utility.set_location(' Leaving:'|| l_proc, 70);

393: ) then
394: hr_utility.set_location(' Leaving:'|| l_proc, 60);
395: raise;
396: end if;
397: hr_utility.set_location(' Leaving:'|| l_proc, 70);
398: end chk_duration_uom;
399: --
400: /*
401: -- ---------------------------------------------------------------------------

Line 425: hr_utility.set_location('Entering:'||l_proc, 1);

421: and tic.checklist_task_name = p_checklist_task_name;
422:
423: --
424: begin
425: hr_utility.set_location('Entering:'||l_proc, 1);
426: --
427: -- Check mandatory checklist_id exists if not null
428: --
429: open csr_ckl_tsk;

Line 433: hr_utility.set_message(800, 'HR_XXXX_CKL_TSK_INV_UNQ');

429: open csr_ckl_tsk;
430: fetch csr_ckl_tsk into l_dummy;
431: if csr_ckl_tsk%found then
432: close csr_ckl_tsk;
433: hr_utility.set_message(800, 'HR_XXXX_CKL_TSK_INV_UNQ');
434: hr_utility.raise_error;
435: end if;
436: close csr_ckl_tsk;
437: --

Line 434: hr_utility.raise_error;

430: fetch csr_ckl_tsk into l_dummy;
431: if csr_ckl_tsk%found then
432: close csr_ckl_tsk;
433: hr_utility.set_message(800, 'HR_XXXX_CKL_TSK_INV_UNQ');
434: hr_utility.raise_error;
435: end if;
436: close csr_ckl_tsk;
437: --
438: hr_utility.set_location(l_proc, 5);

Line 438: hr_utility.set_location(l_proc, 5);

434: hr_utility.raise_error;
435: end if;
436: close csr_ckl_tsk;
437: --
438: hr_utility.set_location(l_proc, 5);
439: --
440: end chk_ckl_tsk_unique;
441: --
442:

Line 471: hr_utility.set_location('Entering:'||l_proc, 1);

467:
468:
469: --
470: begin
471: hr_utility.set_location('Entering:'||l_proc, 1);
472: --
473: -- Check mandatory checklist_id exists if not null
474: --
475: open csr_elg_prf;

Line 479: hr_utility.set_message(800, 'HR_XXXX_CKL_TSK_INV_UNQ');

475: open csr_elg_prf;
476: fetch csr_elg_prf into l_dummy;
477: if csr_elg_prf%notfound then
478: close csr_elg_prf;
479: hr_utility.set_message(800, 'HR_XXXX_CKL_TSK_INV_UNQ');
480: hr_utility.raise_error;
481: end if;
482: close csr_elg_prf;
483: --

Line 480: hr_utility.raise_error;

476: fetch csr_elg_prf into l_dummy;
477: if csr_elg_prf%notfound then
478: close csr_elg_prf;
479: hr_utility.set_message(800, 'HR_XXXX_CKL_TSK_INV_UNQ');
480: hr_utility.raise_error;
481: end if;
482: close csr_elg_prf;
483: --
484: hr_utility.set_location(l_proc, 5);

Line 484: hr_utility.set_location(l_proc, 5);

480: hr_utility.raise_error;
481: end if;
482: close csr_elg_prf;
483: --
484: hr_utility.set_location(l_proc, 5);
485: --
486: end chk_elig_prfl_id;
487: --
488: -- ---------------------------------------------------------------------------

Line 515: hr_utility.set_location('Entering:'||l_proc, 1);

511: and beo.effective_end_date;
512:
513: --
514: begin
515: hr_utility.set_location('Entering:'||l_proc, 1);
516: --
517: -- Check mandatory checklist_id exists if not null
518: --
519: open csr_ben_obj;

Line 523: hr_utility.set_message(800, 'HR_XXXX_CKL_TSK_INV_UNQ');

519: open csr_ben_obj;
520: fetch csr_ben_obj into l_dummy;
521: if csr_ben_obj%notfound then
522: close csr_ben_obj;
523: hr_utility.set_message(800, 'HR_XXXX_CKL_TSK_INV_UNQ');
524: hr_utility.raise_error;
525: end if;
526: close csr_ben_obj;
527: --

Line 524: hr_utility.raise_error;

520: fetch csr_ben_obj into l_dummy;
521: if csr_ben_obj%notfound then
522: close csr_ben_obj;
523: hr_utility.set_message(800, 'HR_XXXX_CKL_TSK_INV_UNQ');
524: hr_utility.raise_error;
525: end if;
526: close csr_ben_obj;
527: --
528: hr_utility.set_location(l_proc, 5);

Line 528: hr_utility.set_location(l_proc, 5);

524: hr_utility.raise_error;
525: end if;
526: close csr_ben_obj;
527: --
528: hr_utility.set_location(l_proc, 5);
529: --
530: end chk_elig_obj_id;
531: */
532: --

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

564: --
565: l_proc varchar2(72) := g_package || 'chk_ddf';
566: --
567: begin
568: hr_utility.set_location('Entering:'||l_proc,10);
569: --
570: if ((p_rec.task_in_checklist_id is not null) and (
571: nvl(per_ctk_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
572: nvl(p_rec.information_category, hr_api.g_varchar2) or

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

663: ,p_attribute20_value => p_rec.information20
664: );
665: end if;
666: --
667: hr_utility.set_location(' Leaving:'||l_proc,20);
668: end chk_ddf;
669: --
670: -- ----------------------------------------------------------------------------
671: -- |------------------------------< chk_df >----------------------------------|

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

701: --
702: l_proc varchar2(72) := g_package || 'chk_df';
703: --
704: begin
705: hr_utility.set_location('Entering:'||l_proc,10);
706: --
707: if ((p_rec.task_in_checklist_id is not null) and (
708: nvl(per_ctk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

800: ,p_attribute20_value => p_rec.attribute20
801: );
802: end if;
803: --
804: hr_utility.set_location(' Leaving:'||l_proc,20);
805: end chk_df;
806: --
807: -- ----------------------------------------------------------------------------
808: -- |-----------------------< chk_non_updateable_args >------------------------|

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

866: --
867: l_proc varchar2(72) := g_package||'insert_validate';
868: --
869: Begin
870: hr_utility.set_location('Entering:'||l_proc, 5);
871: --
872: -- Call all supporting business operations
873: --
874: per_ckl_bus.set_security_group_id

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

930: per_ctk_bus.chk_df(p_rec);
931: --
932: */
933: --
934: hr_utility.set_location(' Leaving:'||l_proc, 10);
935: End insert_validate;
936: --
937: -- ----------------------------------------------------------------------------
938: -- |---------------------------< update_validate >----------------------------|

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

944: --
945: l_proc varchar2(72) := g_package||'update_validate';
946: --
947: Begin
948: hr_utility.set_location('Entering:'||l_proc, 5);
949: --
950: -- Call all supporting business operations
951: --
952: per_ckl_bus.set_security_group_id

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

1011: per_ctk_bus.chk_df(p_rec);
1012: --
1013: */
1014: --
1015: hr_utility.set_location(' Leaving:'||l_proc, 10);
1016: End update_validate;
1017: --
1018: -- ----------------------------------------------------------------------------
1019: -- |---------------------------< delete_validate >----------------------------|

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

1024: --
1025: l_proc varchar2(72) := g_package||'delete_validate';
1026: --
1027: Begin
1028: hr_utility.set_location('Entering:'||l_proc, 5);
1029: --
1030: -- Call all supporting business operations
1031: --
1032: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1028: hr_utility.set_location('Entering:'||l_proc, 5);
1029: --
1030: -- Call all supporting business operations
1031: --
1032: hr_utility.set_location(' Leaving:'||l_proc, 10);
1033: End delete_validate;
1034: --
1035: end per_ctk_bus;