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.HXC_TK_GROUP_QUERY_API dependencies on HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: hxctkgqapi.pkb 120.2 2005/09/23 09:20:33 rchennur noship $ */
3: --
4: -- Package Variables
5: --
6: g_debug boolean := hr_utility.debug_enabled;
7: g_package varchar2(33) := ' hxc_tk_group_query_api.';
8:
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< create_tk_group_query >---------------------|

Line 72: g_debug :=hr_utility.debug_enabled;

68: l_object_version_number hxc_tk_group_queries.object_version_number%TYPE;
69: l_tk_group_query_id hxc_tk_group_queries.tk_group_query_id%TYPE;
70: --
71: begin
72: g_debug :=hr_utility.debug_enabled;
73: --
74: --
75: if g_debug then
76: l_proc := g_package||' create_tk_group_query';

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

73: --
74: --
75: if g_debug then
76: l_proc := g_package||' create_tk_group_query';
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 92: hr_utility.set_location(l_proc, 20);

88:
89: hxc_tk_group_query_api.chk_tk_group_id ( p_tk_group_id => p_tk_group_id );
90:
91: if g_debug then
92: hr_utility.set_location(l_proc, 20);
93: end if;
94: --
95: -- Call Before Process User Hook
96: --

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

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

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

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

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

132: ,p_system_user => p_system_user
133: ,p_object_version_number => l_object_version_number );
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 159: hr_utility.set_location(l_proc, 60);

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

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

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

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

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

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

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

Line 273: g_debug :=hr_utility.debug_enabled;

269: l_object_version_number hxc_tk_group_queries.object_version_number%TYPE := p_object_version_number;
270: --
271: begin
272: --
273: g_debug :=hr_utility.debug_enabled;
274: if g_debug then
275: l_proc := g_package||' update_tk_group_query';
276: hr_utility.set_location('Entering:'|| l_proc, 10);
277: end if;

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

272: --
273: g_debug :=hr_utility.debug_enabled;
274: if g_debug then
275: l_proc := g_package||' update_tk_group_query';
276: hr_utility.set_location('Entering:'|| l_proc, 10);
277: end if;
278: --
279: -- Issue a savepoint if operating in validation only mode
280: --

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

287:
288: hxc_tk_group_query_api.chk_tk_group_id ( p_tk_group_id => p_tk_group_id );
289:
290: if g_debug then
291: hr_utility.set_location(l_proc, 20);
292: end if;
293: --
294: -- Call Before Process User Hook
295: --

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

310: );
311: end;
312: --
313: if g_debug then
314: hr_utility.set_location(l_proc, 30);
315: end if;
316: --
317: -- Process Logic
318: --

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

327: ,p_object_version_number => l_object_version_number );
328: --
329: --
330: if g_debug then
331: hr_utility.set_location(l_proc, 40);
332: end if;
333: --
334: -- Call After Process User Hook
335: --

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

350: );
351: end;
352: --
353: if g_debug then
354: hr_utility.set_location(l_proc, 50);
355: end if;
356: --
357: -- When in validation only mode raise the Validate_Enabled exception
358: --

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

360: raise hr_api.validate_enabled;
361: end if;
362: --
363: if g_debug then
364: hr_utility.set_location(' Leaving:'||l_proc, 60);
365: end if;
366: --
367: -- Set all output arguments
368: --

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

383: --
384: p_object_version_number := null;
385: --
386: if g_debug then
387: hr_utility.set_location(' Leaving:'||l_proc, 60);
388: end if;
389: --
390: when others then
391: --

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

391: --
392: -- A validation or unexpected error has occured
393: --
394: if g_debug then
395: hr_utility.trace('In exeception');
396: end if;
397: ROLLBACK TO update_tk_group_query;
398: raise;
399:

Line 449: g_debug :=hr_utility.debug_enabled;

445: --
446: l_proc varchar2(72) ;
447: --
448: begin
449: g_debug :=hr_utility.debug_enabled;
450: --
451:
452: if g_debug then
453: l_proc := g_package||'delete_tk_group_query';

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

450: --
451:
452: if g_debug then
453: l_proc := g_package||'delete_tk_group_query';
454: hr_utility.set_location('Entering:'|| l_proc, 10);
455: end if;
456: --
457: -- Issue a savepoint if operating in validation only mode
458: --

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

461: hxc_tk_group_query_api.chk_delete (
462: p_tk_group_query_id => p_tk_group_query_id );
463:
464: if g_debug then
465: hr_utility.set_location(l_proc, 20);
466: end if;
467: --
468: -- Call Before Process User Hook
469: --

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

481: );
482: end;
483: --
484: if g_debug then
485: hr_utility.set_location(l_proc, 30);
486: end if;
487: --
488: -- Process Logic
489: --

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

493: ,p_object_version_number => p_object_version_number
494: );
495: --
496: if g_debug then
497: hr_utility.set_location(l_proc, 40);
498: end if;
499: --
500: -- Call After Process User Hook
501: --

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

519: raise hr_api.validate_enabled;
520: end if;
521: --
522: if g_debug then
523: hr_utility.set_location(' Leaving:'||l_proc, 50);
524: end if;
525: --
526: exception
527: --

Line 582: g_debug :=hr_utility.debug_enabled;

578: --
579: l_dup_name varchar2(5) := NULL;
580: --
581: BEGIN
582: g_debug :=hr_utility.debug_enabled;
583: if g_debug then
584: l_proc := g_package||'chk_name';
585: hr_utility.trace('Params are: ');
586: hr_utility.trace('tk group id is : '||to_char(p_tk_Group_id));

Line 585: hr_utility.trace('Params are: ');

581: BEGIN
582: g_debug :=hr_utility.debug_enabled;
583: if g_debug then
584: l_proc := g_package||'chk_name';
585: hr_utility.trace('Params are: ');
586: hr_utility.trace('tk group id is : '||to_char(p_tk_Group_id));
587: hr_utility.trace('tk group query id is : '||to_char(p_tk_Group_query_id));
588: hr_utility.set_location('Entering:'||l_proc, 5);
589: end if;

Line 586: hr_utility.trace('tk group id is : '||to_char(p_tk_Group_id));

582: g_debug :=hr_utility.debug_enabled;
583: if g_debug then
584: l_proc := g_package||'chk_name';
585: hr_utility.trace('Params are: ');
586: hr_utility.trace('tk group id is : '||to_char(p_tk_Group_id));
587: hr_utility.trace('tk group query id is : '||to_char(p_tk_Group_query_id));
588: hr_utility.set_location('Entering:'||l_proc, 5);
589: end if;
590: --

Line 587: hr_utility.trace('tk group query id is : '||to_char(p_tk_Group_query_id));

583: if g_debug then
584: l_proc := g_package||'chk_name';
585: hr_utility.trace('Params are: ');
586: hr_utility.trace('tk group id is : '||to_char(p_tk_Group_id));
587: hr_utility.trace('tk group query id is : '||to_char(p_tk_Group_query_id));
588: hr_utility.set_location('Entering:'||l_proc, 5);
589: end if;
590: --
591: -- check that the name has been entered

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

584: l_proc := g_package||'chk_name';
585: hr_utility.trace('Params are: ');
586: hr_utility.trace('tk group id is : '||to_char(p_tk_Group_id));
587: hr_utility.trace('tk group query id is : '||to_char(p_tk_Group_query_id));
588: hr_utility.set_location('Entering:'||l_proc, 5);
589: end if;
590: --
591: -- check that the name has been entered
592: --

Line 597: hr_utility.set_message(809, 'HXC_TEGQ_NAME_MAND');

593: IF ( p_group_query_name IS NULL )
594: THEN
595: --
596:
597: hr_utility.set_message(809, 'HXC_TEGQ_NAME_MAND');
598: hr_utility.raise_error;
599: --
600: END IF;
601: if g_debug then

Line 598: hr_utility.raise_error;

594: THEN
595: --
596:
597: hr_utility.set_message(809, 'HXC_TEGQ_NAME_MAND');
598: hr_utility.raise_error;
599: --
600: END IF;
601: if g_debug then
602: hr_utility.set_location('Processing:'||l_proc, 10);

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

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

Line 614: hr_utility.set_message(809, 'HXC_TEGQ_NAME_DUP');

610: --
611: IF ( l_dup_name IS NOT NULL )
612: THEN
613: --
614: hr_utility.set_message(809, 'HXC_TEGQ_NAME_DUP');
615: hr_utility.raise_error;
616: --
617: END IF;
618: --

Line 615: hr_utility.raise_error;

611: IF ( l_dup_name IS NOT NULL )
612: THEN
613: --
614: hr_utility.set_message(809, 'HXC_TEGQ_NAME_DUP');
615: hr_utility.raise_error;
616: --
617: END IF;
618: --
619: if g_debug then

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

616: --
617: END IF;
618: --
619: if g_debug then
620: hr_utility.set_location('Leaving:'||l_proc, 20);
621: end if;
622: --
623: END chk_name;
624: --

Line 649: g_debug :=hr_utility.debug_enabled;

645: FROM hxc_tk_groups tkg
646: WHERE tkg.tk_group_id = p_tk_group_id );
647:
648: BEGIN
649: g_debug :=hr_utility.debug_enabled;
650: if g_debug then
651: l_proc := 'chk_tk_group_id';
652: hr_utility.set_location('Entering:'||l_proc, 10);
653: end if;

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

648: BEGIN
649: g_debug :=hr_utility.debug_enabled;
650: if g_debug then
651: l_proc := 'chk_tk_group_id';
652: hr_utility.set_location('Entering:'||l_proc, 10);
653: end if;
654: hr_api.mandatory_arg_error
655: (p_api_name => l_proc
656: ,p_argument => 'TK_GROUP_ID'

Line 665: hr_utility.set_message(809, 'HXC_TKGQ_INVALID_TK_GROUP_ID');

661: FETCH csr_chk_tk_group_id INTO l_dummy;
662:
663: IF csr_chk_tk_group_id%NOTFOUND
664: THEN
665: hr_utility.set_message(809, 'HXC_TKGQ_INVALID_TK_GROUP_ID');
666: hr_utility.raise_error;
667: END IF;
668:
669: CLOSE csr_chk_tk_group_id;

Line 666: hr_utility.raise_error;

662:
663: IF csr_chk_tk_group_id%NOTFOUND
664: THEN
665: hr_utility.set_message(809, 'HXC_TKGQ_INVALID_TK_GROUP_ID');
666: hr_utility.raise_error;
667: END IF;
668:
669: CLOSE csr_chk_tk_group_id;
670:

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

668:
669: CLOSE csr_chk_tk_group_id;
670:
671: if g_debug then
672: hr_utility.set_location('Leaving:'||l_proc, 20);
673: end if;
674: END chk_tk_group_id;
675:
676: -- ----------------------------------------------------------------------------

Line 723: g_debug :=hr_utility.debug_enabled;

719: FROM hxc_tk_group_queries tkgq
720: WHERE tkgq.tk_group_id = p_tk_group_id;
721:
722: BEGIN
723: g_debug :=hr_utility.debug_enabled;
724: if g_debug then
725: l_proc := 'maintain_tk_group_query';
726: hr_utility.trace('Params are :');
727: hr_utility.trace('tk group query id is : '||to_char(p_tk_group_query_id));

Line 726: hr_utility.trace('Params are :');

722: BEGIN
723: g_debug :=hr_utility.debug_enabled;
724: if g_debug then
725: l_proc := 'maintain_tk_group_query';
726: hr_utility.trace('Params are :');
727: hr_utility.trace('tk group query id is : '||to_char(p_tk_group_query_id));
728: hr_utility.trace('tk group id is : '||to_char(p_tk_group_id));
729: hr_utility.set_location('Entering:'||l_proc, 10);
730: end if;

Line 727: hr_utility.trace('tk group query id is : '||to_char(p_tk_group_query_id));

723: g_debug :=hr_utility.debug_enabled;
724: if g_debug then
725: l_proc := 'maintain_tk_group_query';
726: hr_utility.trace('Params are :');
727: hr_utility.trace('tk group query id is : '||to_char(p_tk_group_query_id));
728: hr_utility.trace('tk group id is : '||to_char(p_tk_group_id));
729: hr_utility.set_location('Entering:'||l_proc, 10);
730: end if;
731: -- chk to see if a tk group query row already exists

Line 728: hr_utility.trace('tk group id is : '||to_char(p_tk_group_id));

724: if g_debug then
725: l_proc := 'maintain_tk_group_query';
726: hr_utility.trace('Params are :');
727: hr_utility.trace('tk group query id is : '||to_char(p_tk_group_query_id));
728: hr_utility.trace('tk group id is : '||to_char(p_tk_group_id));
729: hr_utility.set_location('Entering:'||l_proc, 10);
730: end if;
731: -- chk to see if a tk group query row already exists
732:

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

725: l_proc := 'maintain_tk_group_query';
726: hr_utility.trace('Params are :');
727: hr_utility.trace('tk group query id is : '||to_char(p_tk_group_query_id));
728: hr_utility.trace('tk group id is : '||to_char(p_tk_group_id));
729: hr_utility.set_location('Entering:'||l_proc, 10);
730: end if;
731: -- chk to see if a tk group query row already exists
732:
733: OPEN csr_chk_group_query;

Line 740: hr_utility.trace('tk group query not found');

736: IF ( csr_chk_group_query%NOTFOUND )
737: THEN
738:
739: if g_debug then
740: hr_utility.trace('tk group query not found');
741: end if;
742: -- create tk group query
743:
744: hxc_tk_group_query_api.create_tk_group_query

Line 754: hr_utility.trace('new tk group query id is : '||to_char(l_tk_group_query_id));

750: ,p_include_exclude => 'I'
751: ,p_system_user => 'S' );
752:
753: if g_debug then
754: hr_utility.trace('new tk group query id is : '||to_char(l_tk_group_query_id));
755: end if;
756:
757: END IF;
758:

Line 762: hr_utility.trace('tk group query found');

758:
759: CLOSE csr_chk_group_query;
760:
761: if g_debug then
762: hr_utility.trace('tk group query found');
763: hr_utility.trace('old tk group query id is : '||to_char(l_tk_group_query_id));
764: end if;
765: p_tk_group_query_id := l_tk_group_query_id;
766:

Line 763: hr_utility.trace('old tk group query id is : '||to_char(l_tk_group_query_id));

759: CLOSE csr_chk_group_query;
760:
761: if g_debug then
762: hr_utility.trace('tk group query found');
763: hr_utility.trace('old tk group query id is : '||to_char(l_tk_group_query_id));
764: end if;
765: p_tk_group_query_id := l_tk_group_query_id;
766:
767: if g_debug then

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

764: end if;
765: p_tk_group_query_id := l_tk_group_query_id;
766:
767: if g_debug then
768: hr_utility.set_location('Leaving:'||l_proc, 20);
769: end if;
770: END maintain_tk_group_query;
771: --
772: END hxc_tk_group_query_api;