64: fetch c2 into l_type;
65: if l_type <> p_node_type then
66: --
67: close c2;
68: fnd_message.set_name('PER','HR_289050_LEVEL_NODE_MISMATCH');
69: fnd_message.set_token('LEVEL',p_level_number);
70: fnd_message.set_token('TYPE',p_node_type);
71: fnd_message.raise_error;
72: --
65: if l_type <> p_node_type then
66: --
67: close c2;
68: fnd_message.set_name('PER','HR_289050_LEVEL_NODE_MISMATCH');
69: fnd_message.set_token('LEVEL',p_level_number);
70: fnd_message.set_token('TYPE',p_node_type);
71: fnd_message.raise_error;
72: --
73: end if;
66: --
67: close c2;
68: fnd_message.set_name('PER','HR_289050_LEVEL_NODE_MISMATCH');
69: fnd_message.set_token('LEVEL',p_level_number);
70: fnd_message.set_token('TYPE',p_node_type);
71: fnd_message.raise_error;
72: --
73: end if;
74: --
67: close c2;
68: fnd_message.set_name('PER','HR_289050_LEVEL_NODE_MISMATCH');
69: fnd_message.set_token('LEVEL',p_level_number);
70: fnd_message.set_token('TYPE',p_node_type);
71: fnd_message.raise_error;
72: --
73: end if;
74: --
75: close c2;
88: --
89: if p_iteration = p_level_number and
90: l_count.node_type <> p_node_type then
91: --
92: fnd_message.set_name('PER','HR_289050_LEVEL_NODE_MISMATCH');
93: fnd_message.set_token('LEVEL',p_level_number);
94: fnd_message.set_token('TYPE',p_node_type);
95: fnd_message.raise_error;
96: --
89: if p_iteration = p_level_number and
90: l_count.node_type <> p_node_type then
91: --
92: fnd_message.set_name('PER','HR_289050_LEVEL_NODE_MISMATCH');
93: fnd_message.set_token('LEVEL',p_level_number);
94: fnd_message.set_token('TYPE',p_node_type);
95: fnd_message.raise_error;
96: --
97: end if;
90: l_count.node_type <> p_node_type then
91: --
92: fnd_message.set_name('PER','HR_289050_LEVEL_NODE_MISMATCH');
93: fnd_message.set_token('LEVEL',p_level_number);
94: fnd_message.set_token('TYPE',p_node_type);
95: fnd_message.raise_error;
96: --
97: end if;
98: --
91: --
92: fnd_message.set_name('PER','HR_289050_LEVEL_NODE_MISMATCH');
93: fnd_message.set_token('LEVEL',p_level_number);
94: fnd_message.set_token('TYPE',p_node_type);
95: fnd_message.raise_error;
96: --
97: end if;
98: --
99: validate_level_node_type
176: --
177: if l_count < p_min_levels or
178: l_count > p_max_levels then
179: --
180: fnd_message.set_name('PER','HR_289051_LEVEL_ERROR');
181: fnd_message.set_token('NUM_LEVELS',l_count);
182: fnd_message.set_token('MIN',p_min_levels);
183: fnd_message.set_token('MAX',p_max_levels);
184: fnd_message.raise_error;
177: if l_count < p_min_levels or
178: l_count > p_max_levels then
179: --
180: fnd_message.set_name('PER','HR_289051_LEVEL_ERROR');
181: fnd_message.set_token('NUM_LEVELS',l_count);
182: fnd_message.set_token('MIN',p_min_levels);
183: fnd_message.set_token('MAX',p_max_levels);
184: fnd_message.raise_error;
185: --
178: l_count > p_max_levels then
179: --
180: fnd_message.set_name('PER','HR_289051_LEVEL_ERROR');
181: fnd_message.set_token('NUM_LEVELS',l_count);
182: fnd_message.set_token('MIN',p_min_levels);
183: fnd_message.set_token('MAX',p_max_levels);
184: fnd_message.raise_error;
185: --
186: end if;
179: --
180: fnd_message.set_name('PER','HR_289051_LEVEL_ERROR');
181: fnd_message.set_token('NUM_LEVELS',l_count);
182: fnd_message.set_token('MIN',p_min_levels);
183: fnd_message.set_token('MAX',p_max_levels);
184: fnd_message.raise_error;
185: --
186: end if;
187: --
180: fnd_message.set_name('PER','HR_289051_LEVEL_ERROR');
181: fnd_message.set_token('NUM_LEVELS',l_count);
182: fnd_message.set_token('MIN',p_min_levels);
183: fnd_message.set_token('MAX',p_max_levels);
184: fnd_message.raise_error;
185: --
186: end if;
187: --
188: hr_utility.set_location('Leaving '||l_proc,10);
257: --
258: if c1%notfound then
259: --
260: close c1;
261: fnd_message.set_name('PER','HR_289052_HIER_NOT_FOUND');
262: fnd_message.raise_error;
263: --
264: end if;
265: --
258: if c1%notfound then
259: --
260: close c1;
261: fnd_message.set_name('PER','HR_289052_HIER_NOT_FOUND');
262: fnd_message.raise_error;
263: --
264: end if;
265: --
266: close c1;
270: vets_reporting_checks(p_hierarchy_version_id => p_hierarchy_version_id);
271: --
272: else
273: --
274: fnd_message.set_name('PER','HR_289053_HIER_TYPE_UNKNOWN');
275: fnd_message.raise_error;
276: --
277: end if;
278: --
271: --
272: else
273: --
274: fnd_message.set_name('PER','HR_289053_HIER_TYPE_UNKNOWN');
275: fnd_message.raise_error;
276: --
277: end if;
278: --
279: hr_utility.set_location('Leaving '||l_proc,10);
349: fetch c1 into l_c1;
350: --
351: if c1%notfound then
352: --
353: fnd_message.set_name('PER','HR_289054_NO_HIERARCHY');
354: fnd_message.raise_error;
355: --
356: end if;
357: --
350: --
351: if c1%notfound then
352: --
353: fnd_message.set_name('PER','HR_289054_NO_HIERARCHY');
354: fnd_message.raise_error;
355: --
356: end if;
357: --
358: close c1;
700: --
701: fetch c1 into l_c1;
702: if c1%notfound then
703: --
704: fnd_message.set_name('PER','HR_289055_NO_VERSION');
705: fnd_message.raise_error;
706: --
707: end if;
708: --
701: fetch c1 into l_c1;
702: if c1%notfound then
703: --
704: fnd_message.set_name('PER','HR_289055_NO_VERSION');
705: fnd_message.raise_error;
706: --
707: end if;
708: --
709: close c1;