DBA Data[Home] [Help]

APPS.PER_ORG_STRUCTURES_PKG dependencies on HR_UTILITY

Line 57: hr_utility.set_message('801', 'HR_289521_GLOBAL_SEC_PROFILE');

53: and ( psp.business_group_id + 0 = p_business_group_id
54: or psp.business_group_id is null);
55: exception
56: when no_data_found then
57: hr_utility.set_message('801', 'HR_289521_GLOBAL_SEC_PROFILE');
58: hr_utility.set_message_token('PROCEDURE', 'form_startup');
59: hr_utility.set_message_token('STEP', '1');
60: hr_utility.raise_error;
61: end;

Line 58: hr_utility.set_message_token('PROCEDURE', 'form_startup');

54: or psp.business_group_id is null);
55: exception
56: when no_data_found then
57: hr_utility.set_message('801', 'HR_289521_GLOBAL_SEC_PROFILE');
58: hr_utility.set_message_token('PROCEDURE', 'form_startup');
59: hr_utility.set_message_token('STEP', '1');
60: hr_utility.raise_error;
61: end;
62: end form_startup;

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

55: exception
56: when no_data_found then
57: hr_utility.set_message('801', 'HR_289521_GLOBAL_SEC_PROFILE');
58: hr_utility.set_message_token('PROCEDURE', 'form_startup');
59: hr_utility.set_message_token('STEP', '1');
60: hr_utility.raise_error;
61: end;
62: end form_startup;
63: ------------------------------------------------------------------------------

Line 60: hr_utility.raise_error;

56: when no_data_found then
57: hr_utility.set_message('801', 'HR_289521_GLOBAL_SEC_PROFILE');
58: hr_utility.set_message_token('PROCEDURE', 'form_startup');
59: hr_utility.set_message_token('STEP', '1');
60: hr_utility.raise_error;
61: end;
62: end form_startup;
63: ------------------------------------------------------------------------------
64: PROCEDURE check_name_unique(p_name VARCHAR2

Line 82: hr_utility.set_message('801','PER_7901_SYS_DUPLICATE_RECORDS');

78: and upper(os.name) = upper(p_name)
79: and (os.rowid <> p_rowid
80: or p_rowid is null));
81: --
82: hr_utility.set_message('801','PER_7901_SYS_DUPLICATE_RECORDS');
83: hr_utility.raise_error;
84: --
85: exception
86: when no_data_found then null;

Line 83: hr_utility.raise_error;

79: and (os.rowid <> p_rowid
80: or p_rowid is null));
81: --
82: hr_utility.set_message('801','PER_7901_SYS_DUPLICATE_RECORDS');
83: hr_utility.raise_error;
84: --
85: exception
86: when no_data_found then null;
87: when others then raise;

Line 111: hr_utility.set_message('801','HR_6085_PO_POS_ONE_PRIMARY');

107: and os.primary_structure_flag = p_primary_flag
108: and (os.rowid <> p_rowid
109: or p_rowid is null));
110: --
111: hr_utility.set_message('801','HR_6085_PO_POS_ONE_PRIMARY');
112: hr_utility.raise_error;
113: --
114: exception
115: when no_data_found then null;

Line 112: hr_utility.raise_error;

108: and (os.rowid <> p_rowid
109: or p_rowid is null));
110: --
111: hr_utility.set_message('801','HR_6085_PO_POS_ONE_PRIMARY');
112: hr_utility.raise_error;
113: --
114: exception
115: when no_data_found then null;
116: when others then raise;

Line 171: hr_utility.set_message('800','PER_50053_POS_CTRL_DUPLICATED');

167:
168: if c1%found then
169: --
170: close c1;
171: hr_utility.set_message('800','PER_50053_POS_CTRL_DUPLICATED');
172: hr_utility.raise_error;
173: --
174: end if;
175:

Line 172: hr_utility.raise_error;

168: if c1%found then
169: --
170: close c1;
171: hr_utility.set_message('800','PER_50053_POS_CTRL_DUPLICATED');
172: hr_utility.raise_error;
173: --
174: end if;
175:
176: close c1;

Line 187: hr_utility.set_message('800', 'PER_50054_POS_CTRL_CHILD');

183:
184: if c2%found then
185: --
186: close c2;
187: hr_utility.set_message('800', 'PER_50054_POS_CTRL_CHILD');
188: hr_utility.raise_error;
189: --
190: end if;
191:

Line 188: hr_utility.raise_error;

184: if c2%found then
185: --
186: close c2;
187: hr_utility.set_message('800', 'PER_50054_POS_CTRL_CHILD');
188: hr_utility.raise_error;
189: --
190: end if;
191:
192: close c2;

Line 223: hr_utility.set_message('801','HR_6084_PO_POS_HAS_HIER_VER');

219: p_organization_structure_id
220: );
221: -- Id I get to here then there's exists a row
222: -- so error
223: hr_utility.set_message('801','HR_6084_PO_POS_HAS_HIER_VER');
224: hr_utility.raise_error;
225: exception
226: when no_data_found then
227: null;

Line 224: hr_utility.raise_error;

220: );
221: -- Id I get to here then there's exists a row
222: -- so error
223: hr_utility.set_message('801','HR_6084_PO_POS_HAS_HIER_VER');
224: hr_utility.raise_error;
225: exception
226: when no_data_found then
227: null;
228: end;