82: and osv.version_number = p_version_number
83: and (osv.rowid <> p_rowid
84: or p_rowid is null));
85: --
86: hr_utility.set_message('801','HR_6077_PO_POS_DUP_VER');
87: hr_utility.raise_error;
88: --
89: exception
90: when no_data_found then
83: and (osv.rowid <> p_rowid
84: or p_rowid is null));
85: --
86: hr_utility.set_message('801','HR_6077_PO_POS_DUP_VER');
87: hr_utility.raise_error;
88: --
89: exception
90: when no_data_found then
91: null;
156: and osv.organization_structure_id = p_org_structure_id
157: and (osv.rowid <> p_rowid
158: or p_rowid is null));
159: --
160: hr_utility.set_message('801','HR_6076_PO_POS_OVERLAP');
161: hr_utility.raise_error;
162: --
163: end;
164: exception
157: and (osv.rowid <> p_rowid
158: or p_rowid is null));
159: --
160: hr_utility.set_message('801','HR_6076_PO_POS_OVERLAP');
161: hr_utility.raise_error;
162: --
163: end;
164: exception
165: when no_data_found then
188: --
189: if l_result <> 'Y' then
190: --
191: close c1;
192: hr_utility.set_message('800','PER_50055_NON_POS_CTRL_STRUCT');
193: hr_utility.raise_error;
194: --
195: end if;
196: --
189: if l_result <> 'Y' then
190: --
191: close c1;
192: hr_utility.set_message('800','PER_50055_NON_POS_CTRL_STRUCT');
193: hr_utility.raise_error;
194: --
195: end if;
196: --
197: end if;
454: from per_org_structure_elements ose
455: where ose.org_structure_version_id = p_org_Structure_Version_Id
456: );
457: --
458: hr_utility.set_message('801','HR_6204_ORG_SUBORD_EXIST');
459: hr_utility.raise_error;
460: --
461: exception
462: when no_data_found then
455: where ose.org_structure_version_id = p_org_Structure_Version_Id
456: );
457: --
458: hr_utility.set_message('801','HR_6204_ORG_SUBORD_EXIST');
459: hr_utility.raise_error;
460: --
461: exception
462: when no_data_found then
463: null;