DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_GROUP_API dependencies on HR_UTILITY

Line 8: g_debug boolean := hr_utility.debug_enabled;

4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_timekeeper_group_api.';
7:
8: g_debug boolean := hr_utility.debug_enabled;
9:
10: -- ----------------------------------------------------------------------------
11: -- |--------------------------< create_timekeeper_group >---------------------|
12: -- ----------------------------------------------------------------------------

Line 71: g_debug := hr_utility.debug_enabled;

67: l_object_version_number hxc_tk_groups.object_version_number%TYPE;
68: l_tk_group_id hxc_tk_groups.tk_group_id%TYPE;
69: --
70: begin
71: g_debug := hr_utility.debug_enabled;
72: --
73:
74: --
75: if g_debug then

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

73:
74: --
75: if g_debug then
76: l_proc := g_package||' create_timekeeper_group';
77: hr_utility.set_location('Entering:'|| l_proc, 10);
78: end if;
79: --
80: -- Issue a savepoint if operating in validation only mode
81: --

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

90:
91: hxc_timekeeper_group_api.chk_tk_resource_id ( p_tk_resource_id => p_tk_resource_id );
92:
93: if g_debug then
94: hr_utility.set_location(l_proc, 20);
95: end if;
96: --
97: -- Call Before Process User Hook
98: --

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

112: );
113: end;
114: --
115: if g_debug then
116: hr_utility.set_location(l_proc, 30);
117: end if;
118: --
119: -- Process Logic
120: --

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

119: -- Process Logic
120: --
121: --
122: if g_debug then
123: hr_utility.set_location(l_proc, 40);
124: end if;
125: --
126: -- call row handler
127: --

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

132: ,p_object_version_number => l_object_version_number
133: ,p_business_group_id => p_business_group_id);
134: --
135: if g_debug then
136: hr_utility.set_location(l_proc, 50);
137: end if;
138: --
139: -- Call After Process User Hook
140: --

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

154: );
155: end;
156: --
157: if g_debug then
158: hr_utility.set_location(l_proc, 60);
159: end if;
160: --
161: -- When in validation only mode raise the Validate_Enabled exception
162: --

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

164: raise hr_api.validate_enabled;
165: end if;
166: --
167: if g_debug then
168: hr_utility.set_location(' Leaving:'||l_proc, 70);
169: end if;
170: --
171: -- Set all output arguments
172: --

Line 193: hr_utility.set_location(' Leaving:'||l_proc, 80);

189: p_tk_group_id := null;
190: p_object_version_number := null;
191: --
192: if g_debug then
193: hr_utility.set_location(' Leaving:'||l_proc, 80);
194: end if;
195: --
196: when others then
197: --

Line 201: hr_utility.trace('In exeception');

197: --
198: -- A validation or unexpected error has occured
199: --
200: if g_debug then
201: hr_utility.trace('In exeception');
202: end if;
203: ROLLBACK TO create_timekeeper_group;
204: raise;
205: --

Line 268: g_debug := hr_utility.debug_enabled;

264: l_proc varchar2(72);
265: l_object_version_number hxc_tk_groups.object_version_number%TYPE := p_object_version_number;
266: --
267: begin
268: g_debug := hr_utility.debug_enabled;
269: --
270: if g_debug then
271: l_proc := g_package||' update_timekeeper_group';
272: hr_utility.set_location('Entering:'|| l_proc, 10);

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

268: g_debug := hr_utility.debug_enabled;
269: --
270: if g_debug then
271: l_proc := g_package||' update_timekeeper_group';
272: hr_utility.set_location('Entering:'|| l_proc, 10);
273: end if;
274: --
275: -- Issue a savepoint if operating in validation only mode
276: --

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

285:
286: hxc_timekeeper_group_api.chk_tk_resource_id ( p_tk_resource_id => p_tk_resource_id );
287:
288: if g_debug then
289: hr_utility.set_location(l_proc, 20);
290: end if;
291: --
292: -- Call Before Process User Hook
293: --

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

307: );
308: end;
309: --
310: if g_debug then
311: hr_utility.set_location(l_proc, 30);
312: end if;
313: --
314: -- Process Logic
315: --

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

324: );
325: --
326: --
327: if g_debug then
328: hr_utility.set_location(l_proc, 40);
329: end if;
330: --
331: -- Call After Process User Hook
332: --

Line 350: hr_utility.set_location(l_proc, 50);

346: );
347: end;
348: --
349: if g_debug then
350: hr_utility.set_location(l_proc, 50);
351: end if;
352: --
353: -- When in validation only mode raise the Validate_Enabled exception
354: --

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

356: raise hr_api.validate_enabled;
357: end if;
358: --
359: if g_debug then
360: hr_utility.set_location(' Leaving:'||l_proc, 60);
361: end if;
362: --
363: -- Set all output arguments
364: --

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

379: --
380: p_object_version_number := null;
381: --
382: if g_debug then
383: hr_utility.set_location(' Leaving:'||l_proc, 60);
384: end if;
385: --
386: when others then
387: --

Line 391: hr_utility.trace('In exeception');

387: --
388: -- A validation or unexpected error has occured
389: --
390: if g_debug then
391: hr_utility.trace('In exeception');
392: end if;
393: ROLLBACK TO update_timekeeper_group;
394: raise;
395:

Line 445: g_debug := hr_utility.debug_enabled;

441: --
442: l_proc varchar2(72);
443: --
444: begin
445: g_debug := hr_utility.debug_enabled;
446: --
447:
448: if g_debug then
449: l_proc := g_package||'delete_timekeeper_group';

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

446: --
447:
448: if g_debug then
449: l_proc := g_package||'delete_timekeeper_group';
450: hr_utility.set_location('Entering:'|| l_proc, 10);
451: end if;
452: --
453: -- Issue a savepoint if operating in validation only mode
454: --

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

457: hxc_timekeeper_group_api.chk_delete (
458: p_tk_group_id => p_tk_group_id );
459:
460: if g_debug then
461: hr_utility.set_location(l_proc, 20);
462: end if;
463: --
464: -- Call Before Process User Hook
465: --

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

477: );
478: end;
479: --
480: if g_debug then
481: hr_utility.set_location(l_proc, 30);
482: end if;
483: --
484: -- Process Logic
485: --

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

489: ,p_object_version_number => p_object_version_number
490: );
491: --
492: if g_debug then
493: hr_utility.set_location(l_proc, 40);
494: end if;
495: --
496: -- Call After Process User Hook
497: --

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

515: raise hr_api.validate_enabled;
516: end if;
517: --
518: if g_debug then
519: hr_utility.set_location(' Leaving:'||l_proc, 50);
520: end if;
521: --
522: exception
523: --

Line 581: g_debug := hr_utility.debug_enabled;

577: --
578: l_dup_name varchar2(5) := NULL;
579: --
580: BEGIN
581: g_debug := hr_utility.debug_enabled;
582:
583: if g_debug then
584: l_proc := g_package||'chk_name';
585: hr_utility.set_location('Entering:'||l_proc, 5);

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

581: g_debug := hr_utility.debug_enabled;
582:
583: if g_debug then
584: l_proc := g_package||'chk_name';
585: hr_utility.set_location('Entering:'||l_proc, 5);
586: end if;
587: --
588: -- check that the name has been entered
589: --

Line 593: hr_utility.set_message(809, 'HXC_TEG_NAME_MAND');

589: --
590: IF ( p_tk_group_name IS NULL )
591: THEN
592: --
593: hr_utility.set_message(809, 'HXC_TEG_NAME_MAND');
594: hr_utility.raise_error;
595: --
596: END IF;
597: if g_debug then

Line 594: hr_utility.raise_error;

590: IF ( p_tk_group_name IS NULL )
591: THEN
592: --
593: hr_utility.set_message(809, 'HXC_TEG_NAME_MAND');
594: hr_utility.raise_error;
595: --
596: END IF;
597: if g_debug then
598: hr_utility.set_location('Processing:'||l_proc, 10);

Line 598: hr_utility.set_location('Processing:'||l_proc, 10);

594: hr_utility.raise_error;
595: --
596: END IF;
597: if g_debug then
598: hr_utility.set_location('Processing:'||l_proc, 10);
599: end if;
600: --
601: -- check that the name is unique
602: --

Line 610: hr_utility.set_message(809, 'HXC_TEG_NAME_DUP');

606: --
607: IF ( l_dup_name IS NOT NULL )
608: THEN
609: --
610: hr_utility.set_message(809, 'HXC_TEG_NAME_DUP');
611: hr_utility.raise_error;
612: --
613: END IF;
614: --

Line 611: hr_utility.raise_error;

607: IF ( l_dup_name IS NOT NULL )
608: THEN
609: --
610: hr_utility.set_message(809, 'HXC_TEG_NAME_DUP');
611: hr_utility.raise_error;
612: --
613: END IF;
614: --
615: if g_debug then

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

612: --
613: END IF;
614: --
615: if g_debug then
616: hr_utility.set_location('Leaving:'||l_proc, 20);
617: end if;
618: --
619: END chk_name;
620: --

Line 657: hr_utility.set_message(809, 'HXC_TEG_INVALID_TK_RESOURCE_ID');

653: FETCH csr_chk_tk_resource_id INTO l_dummy;
654:
655: IF csr_chk_tk_resource_id%NOTFOUND
656: THEN
657: hr_utility.set_message(809, 'HXC_TEG_INVALID_TK_RESOURCE_ID');
658: hr_utility.raise_error;
659: END IF;
660:
661: CLOSE csr_chk_tk_resource_id;

Line 658: hr_utility.raise_error;

654:
655: IF csr_chk_tk_resource_id%NOTFOUND
656: THEN
657: hr_utility.set_message(809, 'HXC_TEG_INVALID_TK_RESOURCE_ID');
658: hr_utility.raise_error;
659: END IF;
660:
661: CLOSE csr_chk_tk_resource_id;
662:

Line 714: g_debug := hr_utility.debug_enabled;

710: l_emp_rec csr_get_full_name%ROWTYPE;
711:
712: BEGIN
713:
714: g_debug := hr_utility.debug_enabled;
715:
716: if g_debug then
717: l_proc := 'get_user_profiles';
718: hr_utility.set_location('Entering:'||l_proc, 10);

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

714: g_debug := hr_utility.debug_enabled;
715:
716: if g_debug then
717: l_proc := 'get_user_profiles';
718: hr_utility.set_location('Entering:'||l_proc, 10);
719: end if;
720:
721: l_user_person_id := fnd_global.employee_id;
722:

Line 724: hr_utility.trace('gaz - person id is '||to_char(l_user_person_id));

720:
721: l_user_person_id := fnd_global.employee_id;
722:
723: if g_debug then
724: hr_utility.trace('gaz - person id is '||to_char(l_user_person_id));
725: end if;
726:
727: IF ( l_user_person_id IS NULL OR l_user_person_id = -1 )
728: THEN

Line 729: hr_utility.set_message(809, 'HXC_TEG_NO_PERSON_FOR_USER');

725: end if;
726:
727: IF ( l_user_person_id IS NULL OR l_user_person_id = -1 )
728: THEN
729: hr_utility.set_message(809, 'HXC_TEG_NO_PERSON_FOR_USER');
730: hr_utility.raise_error;
731: END IF;
732:
733: l_override := fnd_profile.value('HXC_TIMEKEEPER_OVERRIDE');

Line 730: hr_utility.raise_error;

726:
727: IF ( l_user_person_id IS NULL OR l_user_person_id = -1 )
728: THEN
729: hr_utility.set_message(809, 'HXC_TEG_NO_PERSON_FOR_USER');
730: hr_utility.raise_error;
731: END IF;
732:
733: l_override := fnd_profile.value('HXC_TIMEKEEPER_OVERRIDE');
734:

Line 816: g_debug := hr_utility.debug_enabled;

812: l_proc varchar2(72);
813:
814: BEGIN
815:
816: g_debug := hr_utility.debug_enabled;
817:
818: if g_debug then
819: l_proc := 'get_people';
820: hr_utility.set_location('Entering:'||l_proc, 10);

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

816: g_debug := hr_utility.debug_enabled;
817:
818: if g_debug then
819: l_proc := 'get_people';
820: hr_utility.set_location('Entering:'||l_proc, 10);
821: end if;
822:
823: IF ( p_populate_type = 'ASG_SET' )
824: THEN

Line 827: hr_utility.set_location('Entering:'||l_proc, 20);

823: IF ( p_populate_type = 'ASG_SET' )
824: THEN
825:
826: if g_debug then
827: hr_utility.set_location('Entering:'||l_proc, 20);
828: end if;
829:
830: OPEN csr_get_asg_people;
831: FETCH csr_get_asg_people INTO l_people_rec;

Line 847: hr_utility.set_location('Entering:'||l_proc, 30);

843:
844: CLOSE csr_get_asg_people;
845:
846: if g_debug then
847: hr_utility.set_location('Entering:'||l_proc, 30);
848: end if;
849:
850: ELSE -- p_populate_type must be ORGANIZATION
851:

Line 853: hr_utility.set_location('Entering:'||l_proc, 40);

849:
850: ELSE -- p_populate_type must be ORGANIZATION
851:
852: if g_debug then
853: hr_utility.set_location('Entering:'||l_proc, 40);
854: end if;
855:
856: OPEN csr_get_org_people;
857: FETCH csr_get_org_people INTO l_people_rec;

Line 874: hr_utility.set_location('Entering:'||l_proc, 50);

870:
871: CLOSE csr_get_org_people;
872:
873: if g_debug then
874: hr_utility.set_location('Entering:'||l_proc, 50);
875: end if;
876:
877: END IF; -- p_populate_type
878:

Line 880: hr_utility.set_location('Entering:'||l_proc, 60);

876:
877: END IF; -- p_populate_type
878:
879: if g_debug then
880: hr_utility.set_location('Entering:'||l_proc, 60);
881: end if;
882:
883: RETURN l_people_tab;
884: