DBA Data[Home] [Help]

APPS.PER_ORG_STRUCTURE_ELEMENTS_PKG dependencies on HR_UTILITY

Line 63: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 64: hr_utility.set_message_token('PROCEDURE','maintain_org_lists');

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: --

Line 65: hr_utility.set_message_token('STEP','2');

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;

Line 66: hr_utility.raise_error;

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: --

Line 153: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 154: hr_utility.set_message_token('PROCEDURE','maintain_org_lists');

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;

Line 155: hr_utility.set_message_token('STEP','1');

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: --

Line 156: hr_utility.raise_error;

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

Line 214: hr_utility.set_message('801','HR_6190_ORG_CHILDREN_EXIST');

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

Line 215: hr_utility.raise_error;

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;

Line 269: hr_utility.set_message('801','HR_6753_ORG_HIER_SP_DEL');

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

Line 270: hr_utility.raise_error;

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;

Line 343: hr_utility.set_message('801','HR_6740_ORG_HIER_CANT_DELETE');

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

Line 344: hr_utility.raise_error;

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;

Line 352: hr_utility.set_message('801','PAY_7694_PER_NO_DEL_STRUCTURE');

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: --

Line 353: hr_utility.raise_error;

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.

Line 383: hr_utility.set_message('801','HR_6186_ORG_DUP_CHILD');

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

Line 384: hr_utility.raise_error;

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;

Line 418: hr_utility.set_message('801','HR_ORG_INACT_ORG');

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;

Line 449: hr_utility.set_message('800','PER_50055_NON_POS_CTRL_STRUCT');

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: --

Line 450: hr_utility.raise_error;

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;