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_GRP_QUERY_CRITERIA_API dependencies on HR_UTILITY

Line 8: g_debug boolean := hr_utility.debug_enabled;

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

Line 35: g_debug :=hr_utility.debug_enabled;

31: l_tk_group_query_criteria_id hxc_tk_group_query_criteria.tk_group_query_criteria_id%TYPE;
32: l_tk_group_query_id hxc_tk_group_queries.tk_group_query_id%TYPE;
33: --
34: begin
35: g_debug :=hr_utility.debug_enabled;
36: --
37: -- hr_utility.trace_on(trace_mode=>NULL, session_identifier=>'GAZ');
38: --
39: if g_debug then

Line 37: -- hr_utility.trace_on(trace_mode=>NULL, session_identifier=>'GAZ');

33: --
34: begin
35: g_debug :=hr_utility.debug_enabled;
36: --
37: -- hr_utility.trace_on(trace_mode=>NULL, session_identifier=>'GAZ');
38: --
39: if g_debug then
40: l_proc := g_package||' create_tk_grp_query_criteria';
41: hr_utility.set_location('Entering:'|| l_proc, 10);

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

37: -- hr_utility.trace_on(trace_mode=>NULL, session_identifier=>'GAZ');
38: --
39: if g_debug then
40: l_proc := g_package||' create_tk_grp_query_criteria';
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: end if;
43: --
44: -- Issue a savepoint if operating in validation only mode
45: --

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

57: p_tk_group_query_id => l_tk_group_query_id
58: ,p_tk_group_id => p_tk_group_id
59: );
60: if g_debug then
61: hr_utility.trace('the tk group query id is '||to_char(l_tk_group_query_id));
62: end if;
63:
64: hxc_tk_grp_query_criteria_api.chk_criteria_unique (
65: p_tk_group_query_criteria_id => p_tk_group_query_criteria_id

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

70:
71: hxc_tk_grp_query_criteria_api.chk_tk_group_query_id ( p_tk_group_query_id => l_tk_group_query_id );
72:
73: if g_debug then
74: hr_utility.set_location(l_proc, 20);
75: end if;
76: --
77: -- Call Before Process User Hook
78: --

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

92: );
93: end;
94: --
95: if g_debug then
96: hr_utility.set_location(l_proc, 30);
97: end if;
98: --
99: -- Process Logic
100: --

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

99: -- Process Logic
100: --
101: --
102: if g_debug then
103: hr_utility.set_location(l_proc, 40);
104: end if;
105: --
106: -- call row handler
107: --

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

113: ,p_object_version_number => l_object_version_number );
114: --
115:
116: if g_debug then
117: hr_utility.set_location(l_proc, 50);
118: end if;
119: --
120: -- Call After Process User Hook
121: --

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

135: );
136: end;
137: --
138: if g_debug then
139: hr_utility.set_location(l_proc, 60);
140: end if;
141: --
142: -- When in validation only mode raise the Validate_Enabled exception
143: --

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

145: raise hr_api.validate_enabled;
146: end if;
147: --
148: if g_debug then
149: hr_utility.set_location(' Leaving:'||l_proc, 70);
150: end if;
151: --
152: -- Set all output arguments
153: --

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

171: p_tk_group_query_criteria_id := null;
172: p_object_version_number := null;
173: --
174: if g_debug then
175: hr_utility.set_location(' Leaving:'||l_proc, 80);
176: end if;
177: --
178: when others then
179: --

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

179: --
180: -- A validation or unexpected error has occured
181: --
182: if g_debug then
183: hr_utility.trace('In exeception');
184: end if;
185: ROLLBACK TO create_tk_grp_query_criteria;
186: raise;
187: --

Line 216: g_debug :=hr_utility.debug_enabled;

212: l_object_version_number hxc_tk_group_query_criteria.object_version_number%TYPE := p_object_version_number;
213: --
214: begin
215: --
216: g_debug :=hr_utility.debug_enabled;
217: if g_debug then
218: l_proc := g_package||' update_tk_grp_query_criteria';
219: hr_utility.set_location('Entering:'|| l_proc, 10);
220: end if;

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

215: --
216: g_debug :=hr_utility.debug_enabled;
217: if g_debug then
218: l_proc := g_package||' update_tk_grp_query_criteria';
219: hr_utility.set_location('Entering:'|| l_proc, 10);
220: end if;
221: --
222: -- Issue a savepoint if operating in validation only mode
223: --

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

245: , p_criteria_type => p_criteria_type
246: , p_criteria_id => p_criteria_id );
247:
248: if g_debug then
249: hr_utility.set_location(l_proc, 20);
250: end if;
251: --
252: -- Call Before Process User Hook
253: --

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

267: );
268: end;
269: --
270: if g_debug then
271: hr_utility.set_location(l_proc, 30);
272: end if;
273: --
274: -- Process Logic
275: --

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

283: ,p_object_version_number => l_object_version_number );
284: --
285: --
286: if g_debug then
287: hr_utility.set_location(l_proc, 40);
288: end if;
289: --
290: -- Call After Process User Hook
291: --

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

305: );
306: end;
307: --
308: if g_debug then
309: hr_utility.set_location(l_proc, 50);
310: end if;
311: --
312: -- When in validation only mode raise the Validate_Enabled exception
313: --

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

315: raise hr_api.validate_enabled;
316: end if;
317: --
318: if g_debug then
319: hr_utility.set_location(' Leaving:'||l_proc, 60);
320: end if;
321: --
322: -- Set all output arguments
323: --

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

338: --
339: p_object_version_number := null;
340: --
341: if g_debug then
342: hr_utility.set_location(' Leaving:'||l_proc, 60);
343: end if;
344: --
345: when others then
346: --

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

346: --
347: -- A validation or unexpected error has occured
348: --
349: if g_debug then
350: hr_utility.trace('In exeception');
351: end if;
352: ROLLBACK TO update_tk_grp_query_criteria;
353: raise;
354:

Line 377: g_debug :=hr_utility.debug_enabled;

373: l_proc varchar2(72) ;
374: --
375: begin
376: --
377: g_debug :=hr_utility.debug_enabled;
378: -- hr_utility.trace_on(trace_mode=>NULL, session_identifier=>'GAZ');
379: if g_debug then
380: l_proc := g_package||'delete_tk_grp_query_criteria';
381: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 378: -- hr_utility.trace_on(trace_mode=>NULL, session_identifier=>'GAZ');

374: --
375: begin
376: --
377: g_debug :=hr_utility.debug_enabled;
378: -- hr_utility.trace_on(trace_mode=>NULL, session_identifier=>'GAZ');
379: if g_debug then
380: l_proc := g_package||'delete_tk_grp_query_criteria';
381: hr_utility.set_location('Entering:'|| l_proc, 10);
382: end if;

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

377: g_debug :=hr_utility.debug_enabled;
378: -- hr_utility.trace_on(trace_mode=>NULL, session_identifier=>'GAZ');
379: if g_debug then
380: l_proc := g_package||'delete_tk_grp_query_criteria';
381: hr_utility.set_location('Entering:'|| l_proc, 10);
382: end if;
383: --
384: -- Issue a savepoint if operating in validation only mode
385: --

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

388: hxc_tk_grp_query_criteria_api.chk_delete (
389: p_tk_group_query_criteria_id => p_tk_group_query_criteria_id );
390:
391: if g_debug then
392: hr_utility.set_location(l_proc, 20);
393: end if;
394: --
395: -- Call Before Process User Hook
396: --

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

408: );
409: end;
410: --
411: if g_debug then
412: hr_utility.set_location(l_proc, 30);
413: end if;
414: --
415: -- Process Logic
416: --

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

420: ,p_object_version_number => p_object_version_number
421: );
422: --
423: if g_debug then
424: hr_utility.set_location(l_proc, 40);
425: end if;
426: --
427: -- Call After Process User Hook
428: --

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

446: raise hr_api.validate_enabled;
447: end if;
448: --
449: if g_debug then
450: hr_utility.set_location(' Leaving:'||l_proc, 50);
451: end if;
452: --
453: exception
454: --

Line 506: g_debug :=hr_utility.debug_enabled;

502: --
503: l_dummy varchar2(5) := NULL;
504: --
505: BEGIN
506: g_debug :=hr_utility.debug_enabled;
507: if g_debug then
508: l_proc := g_package||'chk_criteria_type';
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: end if;

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

505: BEGIN
506: g_debug :=hr_utility.debug_enabled;
507: if g_debug then
508: l_proc := g_package||'chk_criteria_type';
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: end if;
511:
512: hr_api.mandatory_arg_error
513: (p_api_name => l_proc

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

515: ,p_argument_value => p_criteria_type
516: );
517:
518: if g_debug then
519: hr_utility.set_location('Processing:'||l_proc, 10);
520: end if;
521: --
522: -- check that the criteria type is valid
523: --

Line 528: hr_utility.set_location('Processing:'||l_proc, 20);

524: OPEN csr_chk_criteria_type;
525: FETCH csr_chk_criteria_type INTO l_dummy;
526:
527: if g_debug then
528: hr_utility.set_location('Processing:'||l_proc, 20);
529: end if;
530:
531: IF csr_chk_criteria_type%NOTFOUND
532: THEN

Line 534: hr_utility.set_location('Processing:'||l_proc, 30);

530:
531: IF csr_chk_criteria_type%NOTFOUND
532: THEN
533: if g_debug then
534: hr_utility.set_location('Processing:'||l_proc, 30);
535: end if;
536:
537: hr_utility.set_message(809, 'HXC_TEGQC_INV_CRITERIA_TYPE');
538: hr_utility.raise_error;

Line 537: hr_utility.set_message(809, 'HXC_TEGQC_INV_CRITERIA_TYPE');

533: if g_debug then
534: hr_utility.set_location('Processing:'||l_proc, 30);
535: end if;
536:
537: hr_utility.set_message(809, 'HXC_TEGQC_INV_CRITERIA_TYPE');
538: hr_utility.raise_error;
539: END IF;
540:
541: if g_debug then

Line 538: hr_utility.raise_error;

534: hr_utility.set_location('Processing:'||l_proc, 30);
535: end if;
536:
537: hr_utility.set_message(809, 'HXC_TEGQC_INV_CRITERIA_TYPE');
538: hr_utility.raise_error;
539: END IF;
540:
541: if g_debug then
542: hr_utility.set_location('Processing:'||l_proc, 40);

Line 542: hr_utility.set_location('Processing:'||l_proc, 40);

538: hr_utility.raise_error;
539: END IF;
540:
541: if g_debug then
542: hr_utility.set_location('Processing:'||l_proc, 40);
543: end if;
544:
545: CLOSE csr_chk_criteria_type;
546:

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

544:
545: CLOSE csr_chk_criteria_type;
546:
547: if g_debug then
548: hr_utility.set_location('Leaving:'||l_proc, 50);
549: end if;
550:
551: END chk_criteria_type;
552:

Line 592: hr_utility.set_message(809, 'HXC_TEGQC_INVALID_CRITERIA_ID');

588: FETCH csr_chk_assignment_id INTO l_dummy;
589:
590: IF ( csr_chk_assignment_id%NOTFOUND )
591: THEN
592: hr_utility.set_message(809, 'HXC_TEGQC_INVALID_CRITERIA_ID');
593: hr_utility.raise_error;
594: END IF;
595:
596: CLOSE csr_chk_assignment_id;

Line 593: hr_utility.raise_error;

589:
590: IF ( csr_chk_assignment_id%NOTFOUND )
591: THEN
592: hr_utility.set_message(809, 'HXC_TEGQC_INVALID_CRITERIA_ID');
593: hr_utility.raise_error;
594: END IF;
595:
596: CLOSE csr_chk_assignment_id;
597:

Line 606: hr_utility.set_message(809, 'HXC_TEGQC_INVALID_CRITERIA_ID');

602: FETCH csr_chk_person_id INTO l_dummy;
603:
604: IF ( csr_chk_person_id%NOTFOUND )
605: THEN
606: hr_utility.set_message(809, 'HXC_TEGQC_INVALID_CRITERIA_ID');
607: hr_utility.raise_error;
608: END IF;
609:
610: CLOSE csr_chk_person_id;

Line 607: hr_utility.raise_error;

603:
604: IF ( csr_chk_person_id%NOTFOUND )
605: THEN
606: hr_utility.set_message(809, 'HXC_TEGQC_INVALID_CRITERIA_ID');
607: hr_utility.raise_error;
608: END IF;
609:
610: CLOSE csr_chk_person_id;
611:

Line 640: g_debug :=hr_utility.debug_enabled;

636: FROM hxc_tk_group_queries tkgq
637: WHERE tkgq.tk_group_query_id = p_tk_group_query_id );
638:
639: BEGIN
640: g_debug :=hr_utility.debug_enabled;
641: if g_debug then
642: l_proc := 'chk_tk_group_query_id';
643: hr_utility.set_location('Processing:'||l_proc, 5);
644: end if;

Line 643: hr_utility.set_location('Processing:'||l_proc, 5);

639: BEGIN
640: g_debug :=hr_utility.debug_enabled;
641: if g_debug then
642: l_proc := 'chk_tk_group_query_id';
643: hr_utility.set_location('Processing:'||l_proc, 5);
644: end if;
645:
646: hr_api.mandatory_arg_error
647: (p_api_name => l_proc

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

649: ,p_argument_value => p_tk_group_query_id
650: );
651:
652: if g_debug then
653: hr_utility.set_location('Processing:'||l_proc, 10);
654: end if;
655:
656: OPEN csr_chk_tk_group_query_id;
657: FETCH csr_chk_tk_group_query_id INTO l_dummy;

Line 660: hr_utility.set_location('Processing:'||l_proc, 20);

656: OPEN csr_chk_tk_group_query_id;
657: FETCH csr_chk_tk_group_query_id INTO l_dummy;
658:
659: if g_debug then
660: hr_utility.set_location('Processing:'||l_proc, 20);
661: end if;
662:
663: IF csr_chk_tk_group_query_id%NOTFOUND
664: THEN

Line 666: hr_utility.set_location('Processing:'||l_proc, 30);

662:
663: IF csr_chk_tk_group_query_id%NOTFOUND
664: THEN
665: if g_debug then
666: hr_utility.set_location('Processing:'||l_proc, 30);
667: end if;
668:
669: hr_utility.set_message(809, 'HXC_TKGQC_INV_TK_GRP_QUERY_ID');
670: hr_utility.raise_error;

Line 669: hr_utility.set_message(809, 'HXC_TKGQC_INV_TK_GRP_QUERY_ID');

665: if g_debug then
666: hr_utility.set_location('Processing:'||l_proc, 30);
667: end if;
668:
669: hr_utility.set_message(809, 'HXC_TKGQC_INV_TK_GRP_QUERY_ID');
670: hr_utility.raise_error;
671: END IF;
672:
673: CLOSE csr_chk_tk_group_query_id;

Line 670: hr_utility.raise_error;

666: hr_utility.set_location('Processing:'||l_proc, 30);
667: end if;
668:
669: hr_utility.set_message(809, 'HXC_TKGQC_INV_TK_GRP_QUERY_ID');
670: hr_utility.raise_error;
671: END IF;
672:
673: CLOSE csr_chk_tk_group_query_id;
674:

Line 676: hr_utility.set_location('Processing:'||l_proc, 40);

672:
673: CLOSE csr_chk_tk_group_query_id;
674:
675: if g_debug then
676: hr_utility.set_location('Processing:'||l_proc, 40);
677: end if;
678:
679: END chk_tk_group_query_id;
680:

Line 776: hr_utility.set_message(809, 'HXC_TKGQC_INV_PARAMS_CRITERIA');

772: CLOSE csr_get_employee_number;
773:
774: ELSE
775:
776: hr_utility.set_message(809, 'HXC_TKGQC_INV_PARAMS_CRITERIA');
777: hr_utility.raise_error;
778:
779: END IF;
780:

Line 777: hr_utility.raise_error;

773:
774: ELSE
775:
776: hr_utility.set_message(809, 'HXC_TKGQC_INV_PARAMS_CRITERIA');
777: hr_utility.raise_error;
778:
779: END IF;
780:
781: RETURN l_criteria;

Line 821: g_debug :=hr_utility.debug_enabled;

817:
818: l_proc varchar2(72) ;
819:
820: BEGIN
821: g_debug :=hr_utility.debug_enabled;
822: if g_debug then
823: l_proc := 'chk_criteria_unique';
824: hr_utility.set_location('Entering:'||l_proc, 5);
825: end if;

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

820: BEGIN
821: g_debug :=hr_utility.debug_enabled;
822: if g_debug then
823: l_proc := 'chk_criteria_unique';
824: hr_utility.set_location('Entering:'||l_proc, 5);
825: end if;
826:
827: OPEN csr_chk_unique;
828: FETCH csr_chk_unique INTO l_dummy;

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

827: OPEN csr_chk_unique;
828: FETCH csr_chk_unique INTO l_dummy;
829:
830: if g_debug then
831: hr_utility.set_location('Processing:'||l_proc, 10);
832: end if;
833:
834: IF ( csr_chk_unique%FOUND )
835: THEN

Line 838: hr_utility.set_location('Processing:'||l_proc, 20);

834: IF ( csr_chk_unique%FOUND )
835: THEN
836:
837: if g_debug then
838: hr_utility.set_location('Processing:'||l_proc, 20);
839: end if;
840:
841: hr_utility.set_message(809, 'HXC_TKGQC_DUP_CRITERIA');
842: hr_utility.raise_error;

Line 841: hr_utility.set_message(809, 'HXC_TKGQC_DUP_CRITERIA');

837: if g_debug then
838: hr_utility.set_location('Processing:'||l_proc, 20);
839: end if;
840:
841: hr_utility.set_message(809, 'HXC_TKGQC_DUP_CRITERIA');
842: hr_utility.raise_error;
843:
844: END IF;
845:

Line 842: hr_utility.raise_error;

838: hr_utility.set_location('Processing:'||l_proc, 20);
839: end if;
840:
841: hr_utility.set_message(809, 'HXC_TKGQC_DUP_CRITERIA');
842: hr_utility.raise_error;
843:
844: END IF;
845:
846: if g_debug then

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

843:
844: END IF;
845:
846: if g_debug then
847: hr_utility.set_location('Leaving:'||l_proc, 30);
848: end if;
849:
850: END chk_criteria_unique;
851: