59: hr_security.add_organization(p_organization_id,
60: p_security_profile_id);
61: -- No rows inserted - raise error to the effect.
62: if SQL%ROWCOUNT <>1 then
63: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
64: hr_utility.set_message_token('PROCEDURE','maintain_org_lists');
65: hr_utility.set_message_token('STEP','2');
66: hr_utility.raise_error;
67: end if;
60: p_security_profile_id);
61: -- No rows inserted - raise error to the effect.
62: if SQL%ROWCOUNT <>1 then
63: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
64: hr_utility.set_message_token('PROCEDURE','maintain_org_lists');
65: hr_utility.set_message_token('STEP','2');
66: hr_utility.raise_error;
67: end if;
68: --
61: -- No rows inserted - raise error to the effect.
62: if SQL%ROWCOUNT <>1 then
63: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
64: hr_utility.set_message_token('PROCEDURE','maintain_org_lists');
65: hr_utility.set_message_token('STEP','2');
66: hr_utility.raise_error;
67: end if;
68: --
69: end insert_rows;
62: if SQL%ROWCOUNT <>1 then
63: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
64: hr_utility.set_message_token('PROCEDURE','maintain_org_lists');
65: hr_utility.set_message_token('STEP','2');
66: hr_utility.raise_error;
67: end if;
68: --
69: end insert_rows;
70: --
149: and x.security_profile_id = p_security_profile_id;
150: --
151: exception
152: when no_data_found then
153: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
154: hr_utility.set_message_token('PROCEDURE','maintain_org_lists');
155: hr_utility.set_message_token('STEP','1');
156: hr_utility.raise_error;
157: when others then raise;
150: --
151: exception
152: when no_data_found then
153: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
154: hr_utility.set_message_token('PROCEDURE','maintain_org_lists');
155: hr_utility.set_message_token('STEP','1');
156: hr_utility.raise_error;
157: when others then raise;
158: end;
151: exception
152: when no_data_found then
153: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
154: hr_utility.set_message_token('PROCEDURE','maintain_org_lists');
155: hr_utility.set_message_token('STEP','1');
156: hr_utility.raise_error;
157: when others then raise;
158: end;
159: --
152: when no_data_found then
153: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
154: hr_utility.set_message_token('PROCEDURE','maintain_org_lists');
155: hr_utility.set_message_token('STEP','1');
156: hr_utility.raise_error;
157: when others then raise;
158: end;
159: --
160: if l_sec_view_all_orgs_flag = 'N' then
210: p_org_structure_version_id
211: and ose.organization_id_parent =
212: p_org_id_child);
213: --
214: hr_utility.set_message('801','HR_6190_ORG_CHILDREN_EXIST');
215: hr_utility.raise_error;
216: --
217: exception
218: when no_data_found then
211: and ose.organization_id_parent =
212: p_org_id_child);
213: --
214: hr_utility.set_message('801','HR_6190_ORG_CHILDREN_EXIST');
215: hr_utility.raise_error;
216: --
217: exception
218: when no_data_found then
219: null;
265: )
266: )
267: ) );
268: --
269: hr_utility.set_message('801','HR_6753_ORG_HIER_SP_DEL');
270: hr_utility.raise_error;
271: --
272: exception
273: when no_data_found then
266: )
267: ) );
268: --
269: hr_utility.set_message('801','HR_6753_ORG_HIER_SP_DEL');
270: hr_utility.raise_error;
271: --
272: exception
273: when no_data_found then
274: null;
339: open c1;
340: fetch c1 into l_dummy;
341: if c1%FOUND then
342: close c1;
343: hr_utility.set_message('801','HR_6740_ORG_HIER_CANT_DELETE');
344: hr_utility.raise_error;
345: end if;
346: close c1;
347: if p_hr_installed IN ('I','S') then
340: fetch c1 into l_dummy;
341: if c1%FOUND then
342: close c1;
343: hr_utility.set_message('801','HR_6740_ORG_HIER_CANT_DELETE');
344: hr_utility.raise_error;
345: end if;
346: close c1;
347: if p_hr_installed IN ('I','S') then
348: open c2;
348: open c2;
349: fetch c2 into l_dummy;
350: if c2%FOUND then
351: close c2;
352: hr_utility.set_message('801','PAY_7694_PER_NO_DEL_STRUCTURE');
353: hr_utility.raise_error;
354: end if;
355: end if;
356: --
349: fetch c2 into l_dummy;
350: if c2%FOUND then
351: close c2;
352: hr_utility.set_message('801','PAY_7694_PER_NO_DEL_STRUCTURE');
353: hr_utility.raise_error;
354: end if;
355: end if;
356: --
357: -- Bug 516069: Changed <> 'Y' to = 'I' to pick up correct value.
379: p_org_structure_version_id
380: and ose.organization_id_child =
381: p_org_structure_element_id);
382: --
383: hr_utility.set_message('801','HR_6186_ORG_DUP_CHILD');
384: hr_utility.raise_error;
385: --
386: exception
387: when no_data_found then
380: and ose.organization_id_child =
381: p_org_structure_element_id);
382: --
383: hr_utility.set_message('801','HR_6186_ORG_DUP_CHILD');
384: hr_utility.raise_error;
385: --
386: exception
387: when no_data_found then
388: null;
414: --
415: p_warning_raised :='N';
416: exception
417: when no_data_found then
418: hr_utility.set_message('801','HR_ORG_INACT_ORG');
419: p_warning_raised:='Y';
420: when others then
421: raise;
422: end check_org_active;
445: --
446: if l_result <> 'Y' then
447: --
448: close c1;
449: hr_utility.set_message('800','PER_50055_NON_POS_CTRL_STRUCT');
450: hr_utility.raise_error;
451: --
452: end if;
453: --
446: if l_result <> 'Y' then
447: --
448: close c1;
449: hr_utility.set_message('800','PER_50055_NON_POS_CTRL_STRUCT');
450: hr_utility.raise_error;
451: --
452: end if;
453: --
454: end if;