APPS.PER_POS_STRUCTURE_ELEMENTS_PKG dependencies on HR_UTILITY

Line 59: hr_utility.set_message('801','HR_ALL_COUNT_HOLDERS');

55: --
56: l_message VARCHAR2(80);
57:
58: Begin
59: hr_utility.set_message('801','HR_ALL_COUNT_HOLDERS');
60: l_message := hr_utility.get_message;
61: -- Bug fix 3681825: Distinct added to sql to avoid counting the same holder more
62: -- than once.
63: select COUNT(DISTINCT P.PERSON_ID), '** ' || COUNT(DISTINCT P.PERSON_ID) ||' '||l_message

Line 60: l_message := hr_utility.get_message;

56: l_message VARCHAR2(80);
57:
58: Begin
59: hr_utility.set_message('801','HR_ALL_COUNT_HOLDERS');
60: l_message := hr_utility.get_message;
61: -- Bug fix 3681825: Distinct added to sql to avoid counting the same holder more
62: -- than once.
63: select COUNT(DISTINCT P.PERSON_ID), '** ' || COUNT(DISTINCT P.PERSON_ID) ||' '||l_message
64: into X_No_Holders , l_message

Line 89: hr_utility.set_message('801','HR_ALL_NO_HOLDERS');

85: and a.effective_end_date
86: and X_Session_date between p.effective_start_date
87: and p.effective_end_date;
88: if X_No_Holders = 0 then
89: hr_utility.set_message('801','HR_ALL_NO_HOLDERS');
90: X_Holder := hr_utility.get_message;
91: X_Employee_Number := NULL;
92: elsif X_No_Holders = 1 then
93: begin

Line 90: X_Holder := hr_utility.get_message;

86: and X_Session_date between p.effective_start_date
87: and p.effective_end_date;
88: if X_No_Holders = 0 then
89: hr_utility.set_message('801','HR_ALL_NO_HOLDERS');
90: X_Holder := hr_utility.get_message;
91: X_Employee_Number := NULL;
92: elsif X_No_Holders = 1 then
93: begin
94: -- Bug fix 3681825: Distinct added to sql to avoid fetching multiple rows

Line 319: hr_utility.set_message('801','HR_6012_ROW_INSERTED');

315: WHERE PSE.POS_STRUCTURE_VERSION_ID = X_Pos_Structure_Version_Id
316: AND PSE.PARENT_POSITION_ID = X_Parent_position_id
317: AND PSE.SUBORDINATE_POSITION_ID = X_Subordinate_Position_Id;
318: --
319: hr_utility.set_message('801','HR_6012_ROW_INSERTED');
320: hr_utility.raise_error;
321: exception
322: when no_data_found then
323: null;

Line 320: hr_utility.raise_error;

316: AND PSE.PARENT_POSITION_ID = X_Parent_position_id
317: AND PSE.SUBORDINATE_POSITION_ID = X_Subordinate_Position_Id;
318: --
319: hr_utility.set_message('801','HR_6012_ROW_INSERTED');
320: hr_utility.raise_error;
321: exception
322: when no_data_found then
323: null;
324: end check_unique;

Line 342: hr_utility.set_message('801','HR_6915_POS_DEL_FIRST');

338: from per_pos_structure_elements pse
339: where pse.parent_position_id = X_Subordinate_position_Id
340: and pse.pos_structure_version_id = X_Pos_Structure_version_Id);
341: --
342: hr_utility.set_message('801','HR_6915_POS_DEL_FIRST');
343: hr_utility.raise_error;
344: --
345: exception
346: when no_data_found then

Line 343: hr_utility.raise_error;

339: where pse.parent_position_id = X_Subordinate_position_Id
340: and pse.pos_structure_version_id = X_Pos_Structure_version_Id);
341: --
342: hr_utility.set_message('801','HR_6915_POS_DEL_FIRST');
343: hr_utility.raise_error;
344: --
345: exception
346: when no_data_found then
347: null;

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

356: where psp.business_group_id + 0 = X_Business_Group_Id
357: and psp.position_id = X_Subordinate_position_Id
358: and psp.position_structure_id = X_Position_Structure_Id);
359: --
360: hr_utility.set_message(801,'PAY_7694_PER_NO_DEL_STRUCTURE');
361: hr_utility.raise_error;
362: --
363: exception
364: when no_data_found then

Line 361: hr_utility.raise_error;

357: and psp.position_id = X_Subordinate_position_Id
358: and psp.position_structure_id = X_Position_Structure_Id);
359: --
360: hr_utility.set_message(801,'PAY_7694_PER_NO_DEL_STRUCTURE');
361: hr_utility.raise_error;
362: --
363: exception
364: when no_data_found then
365: null;