DBA Data[Home] [Help]

APPS.HXC_RET_RULE_GRP_COMP_API dependencies on HR_UTILITY

Line 10: g_debug boolean := hr_utility.debug_enabled;

6: g_package varchar2(33) := ' hxc_ret_rule_grp_comp_api.';
7:
8: g_entity_type varchar2(16) := 'RETRIEVAL_RULES';
9:
10: g_debug boolean := hr_utility.debug_enabled;
11:
12: -- ----------------------------------------------------------------------------
13: -- |--------------------< create_ret_rule_grp_comp>--------------------------|
14: -- ----------------------------------------------------------------------------

Line 64: g_debug := hr_utility.debug_enabled;

60: l_object_version_number hxc_entity_group_comps.object_version_number%TYPE;
61: l_ret_rule_grp_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE;
62: --
63: begin
64: g_debug := hr_utility.debug_enabled;
65: --
66:
67: --
68: if g_debug then

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

66:
67: --
68: if g_debug then
69: l_proc := g_package||' create_ret_rule_grp_comp';
70: hr_utility.set_location('Entering:'|| l_proc, 10);
71: end if;
72: --
73: -- Issue a savepoint if operating in validation only mode
74: --

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

74: --
75: savepoint create_ret_rule_grp_comp;
76: --
77: if g_debug then
78: hr_utility.set_location(l_proc, 20);
79: end if;
80:
81: chk_rr_unique ( p_ret_rule_grp_comp_id => p_ret_rule_grp_comp_id
82: ,p_retrieval_rule_grp_id => p_retrieval_rule_grp_id

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

131: );
132: end;
133: --
134: if g_debug then
135: hr_utility.set_location(l_proc, 30);
136: end if;
137: --
138: -- Process Logic
139: --

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

138: -- Process Logic
139: --
140: --
141: if g_debug then
142: hr_utility.set_location(l_proc, 40);
143: end if;
144: --
145: -- call row handler
146: --

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

184: ,p_attribute30 => p_attribute30
185: ,p_called_from_form => p_called_from_form );
186: --
187: if g_debug then
188: hr_utility.set_location(l_proc, 50);
189: end if;
190: --
191: -- Call After Process User Hook
192: --

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

235: );
236: end;
237: --
238: if g_debug then
239: hr_utility.set_location(l_proc, 60);
240: end if;
241: --
242: -- When in validation only mode raise the Validate_Enabled exception
243: --

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

245: raise hr_api.validate_enabled;
246: end if;
247: --
248: if g_debug then
249: hr_utility.set_location(' Leaving:'||l_proc, 70);
250: end if;
251: --
252: -- Set all output arguments
253: --

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

270: p_ret_rule_grp_comp_id := null;
271: p_object_version_number := null;
272: --
273: if g_debug then
274: hr_utility.set_location(' Leaving:'||l_proc, 80);
275: end if;
276: --
277: when others then
278: --

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

278: --
279: -- A validation or unexpected error has occured
280: --
281: if g_debug then
282: hr_utility.trace('In exeception');
283: end if;
284: ROLLBACK TO create_ret_rule_grp_comp;
285: raise;
286: --

Line 340: g_debug := hr_utility.debug_enabled;

336: l_proc varchar2(72);
337: l_object_version_number hxc_entity_group_comps.object_version_number%TYPE := p_object_version_number;
338: --
339: begin
340: g_debug := hr_utility.debug_enabled;
341: --
342: if g_debug then
343: l_proc := g_package||' update_ret_rule_grp_comp';
344: hr_utility.set_location('Entering:'|| l_proc, 10);

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

340: g_debug := hr_utility.debug_enabled;
341: --
342: if g_debug then
343: l_proc := g_package||' update_ret_rule_grp_comp';
344: hr_utility.set_location('Entering:'|| l_proc, 10);
345: end if;
346: --
347: -- Issue a savepoint if operating in validation only mode
348: --

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

348: --
349: savepoint update_ret_rule_grp_comp;
350: --
351: if g_debug then
352: hr_utility.set_location(l_proc, 20);
353: end if;
354:
355: chk_rr_unique ( p_ret_rule_grp_comp_id => p_ret_rule_grp_comp_id
356: ,p_retrieval_rule_grp_id => p_retrieval_rule_grp_id

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

405: );
406: end;
407: --
408: if g_debug then
409: hr_utility.set_location(l_proc, 30);
410: end if;
411: --
412: -- Process Logic
413: --

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

454: ,p_called_from_form => p_called_from_form );
455: --
456: --
457: if g_debug then
458: hr_utility.set_location(l_proc, 40);
459: end if;
460: --
461: -- Call After Process User Hook
462: --

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

506: );
507: end;
508: --
509: if g_debug then
510: hr_utility.set_location(l_proc, 50);
511: end if;
512: --
513: -- When in validation only mode raise the Validate_Enabled exception
514: --

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

516: raise hr_api.validate_enabled;
517: end if;
518: --
519: if g_debug then
520: hr_utility.set_location(' Leaving:'||l_proc, 60);
521: end if;
522: --
523: -- Set all output arguments
524: --

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

539: --
540: p_object_version_number := null;
541: --
542: if g_debug then
543: hr_utility.set_location(' Leaving:'||l_proc, 60);
544: end if;
545: --
546: when others then
547: --

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

547: --
548: -- A validation or unexpected error has occured
549: --
550: if g_debug then
551: hr_utility.trace('In exeception');
552: end if;
553: ROLLBACK TO update_ret_rule_grp_comp;
554: raise;
555: --

Line 574: g_debug := hr_utility.debug_enabled;

570: --
571: l_proc varchar2(72);
572: --
573: begin
574: g_debug := hr_utility.debug_enabled;
575: --
576:
577: if g_debug then
578: l_proc := g_package||'delete_ret_rule_grp_comp';

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

575: --
576:
577: if g_debug then
578: l_proc := g_package||'delete_ret_rule_grp_comp';
579: hr_utility.set_location('Entering:'|| l_proc, 10);
580: end if;
581: --
582: -- Issue a savepoint if operating in validation only mode
583: --

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

583: --
584: savepoint delete_ret_rule_grp_comp;
585: --
586: if g_debug then
587: hr_utility.set_location(l_proc, 20);
588: end if;
589:
590: -- Call Before Process User Hook
591:

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

603: );
604: end;
605: --
606: if g_debug then
607: hr_utility.set_location(l_proc, 30);
608: end if;
609: --
610: -- Process Logic
611: --

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

615: ,p_object_version_number => p_object_version_number
616: );
617: --
618: if g_debug then
619: hr_utility.set_location(l_proc, 40);
620: end if;
621: --
622: -- Call After Process User Hook
623: --

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

641: raise hr_api.validate_enabled;
642: end if;
643: --
644: if g_debug then
645: hr_utility.set_location(' Leaving:'||l_proc, 50);
646: end if;
647: --
648: exception
649: --

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

729: --
730: BEGIN
731: if g_debug then
732: l_proc := g_package||'chk_rr_unique';
733: hr_utility.set_location('Entering:'||l_proc, 5);
734: end if;
735:
736: -- check that rr is unique within the grouping
737:

Line 745: hr_utility.set_message(809, 'HXC_EGC_RR_NOT_UNIQUE');

741: --
742: IF l_error IS NOT NULL
743: THEN
744: --
745: hr_utility.set_message(809, 'HXC_EGC_RR_NOT_UNIQUE');
746: hr_utility.raise_error;
747: --
748: END IF;
749: --

Line 746: hr_utility.raise_error;

742: IF l_error IS NOT NULL
743: THEN
744: --
745: hr_utility.set_message(809, 'HXC_EGC_RR_NOT_UNIQUE');
746: hr_utility.raise_error;
747: --
748: END IF;
749: --
750: OPEN csr_chk_rr_ret_proc;

Line 757: hr_utility.set_message(809, 'HXC_EGC_RR_RETRIEVAL_DUP');

753: --
754: IF l_error IS NOT NULL
755: THEN
756: --
757: hr_utility.set_message(809, 'HXC_EGC_RR_RETRIEVAL_DUP');
758: hr_utility.raise_error;
759: --
760: END IF;
761: --

Line 758: hr_utility.raise_error;

754: IF l_error IS NOT NULL
755: THEN
756: --
757: hr_utility.set_message(809, 'HXC_EGC_RR_RETRIEVAL_DUP');
758: hr_utility.raise_error;
759: --
760: END IF;
761: --
762: if g_debug then

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

759: --
760: END IF;
761: --
762: if g_debug then
763: hr_utility.set_location('Leaving:'||l_proc, 20);
764: end if;
765: --
766: END chk_rr_unique;
767: --