DBA Data[Home] [Help]

APPS.PER_GENERIC_HIERARCHY_PKG dependencies on HR_UTILITY

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

77: return;
78: --
79: end if;
80: --
81: hr_utility.set_location('Entering '||l_proc,10);
82: --
83: for l_count in c1 loop
84: --
85: exit when c1%notfound;

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

103: p_iteration => p_iteration+1);
104: --
105: end loop;
106: --
107: hr_utility.set_location('Leaving '||l_proc,10);
108: --
109: end validate_level_node_type;
110: --
111: -- Get parent node for the hierarchy version routine

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

122: l_proc varchar2(80) := g_package||'get_parent_node';
123: --
124: begin
125: --
126: hr_utility.set_location('Entering '||l_proc,10);
127: --
128: open c1;
129: --
130: fetch c1 into l_hierarchy_node_id;

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

130: fetch c1 into l_hierarchy_node_id;
131: --
132: close c1;
133: --
134: hr_utility.set_location('Leaving '||l_proc,10);
135: --
136: return l_hierarchy_node_id;
137: --
138: end get_parent_node;

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

165: */
166: --
167: begin
168: --
169: hr_utility.set_location('Entering '||l_proc,10);
170: --
171: open c1;
172: --
173: fetch c1 into l_count;

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

184: fnd_message.raise_error;
185: --
186: end if;
187: --
188: hr_utility.set_location('Leaving '||l_proc,10);
189: --
190: end validate_number_of_levels;
191: --
192: -- Reporting checks for the VETS reports

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

197: l_hierarchy_node_id number;
198: --
199: begin
200: --
201: hr_utility.set_location('Entering '||l_proc,10);
202: --
203: -- Vets Validation Checks include
204: --
205: -- 1) Must be Three node levels maximum

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

226: validate_level_node_type(p_hierarchy_node_id => l_hierarchy_node_id,
227: p_node_type => 'LOC',
228: p_level_number => 3);
229: --
230: hr_utility.set_location('Leaving '||l_proc,10);
231: --
232: end vets_reporting_checks;
233: --
234: -- Main routine to validate a hierarchy

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

246: and b.hierarchy_version_id = p_hierarchy_version_id;
247: --
248: begin
249: --
250: hr_utility.set_location('Entering '||l_proc,10);
251: --
252: -- Get Hierarchy Type
253: --
254: open c1;

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

275: fnd_message.raise_error;
276: --
277: end if;
278: --
279: hr_utility.set_location('Leaving '||l_proc,10);
280: --
281: end validate_hierarchy;
282: --
283: procedure copy_hierarchy(p_hierarchy_id in number,

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

335: l_c4 c4%rowtype;
336: --
337: begin
338: --
339: hr_utility.set_location('Entering '||l_proc,10);
340: --
341: -- Basically to copy a hierarchy do the following
342: --
343: -- 1) Attempt to create the hierarchy.

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

631: end loop;
632: --
633: close c2;
634: --
635: hr_utility.set_location('Leaving '||l_proc,10);
636: --
637: p_out_hierarchy_id := l_hierarchy_id;
638: --
639: commit;

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

689: l_c3 c3%rowtype;
690: --
691: begin
692: --
693: hr_utility.set_location('Entering '||l_proc,10);
694: --
695: -- 1) Create hierarchy version
696: -- 2) Create all nodes for hierarchy version
697: -- 3) Link the nodes to the correct parents

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

900: close c3;
901: --
902: p_out_hierarchy_version_id := l_hierarchy_version_id;
903: --
904: hr_utility.set_location('Leaving '||l_proc,10);
905: --
906: end copy_hierarchy_version;
907: --
908: end per_generic_hierarchy_pkg;