APPS.PAY_FUNCTIONAL_AREAS_PKG dependencies on HR_UTILITY

Line 25: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');

21: OPEN csr_functional_area;
22: FETCH csr_functional_area INTO area_record;
23: IF csr_functional_area%NOTFOUND THEN
24: CLOSE csr_functional_area;
25: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
26: Hr_Utility.Set_Message_Token(
27: 'PROCEDURE',
28: 'PAY_FUNCTIONAL_AREAS_PKG.LOCK_ROW'
29: );

Line 26: Hr_Utility.Set_Message_Token(

22: FETCH csr_functional_area INTO area_record;
23: IF csr_functional_area%NOTFOUND THEN
24: CLOSE csr_functional_area;
25: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
26: Hr_Utility.Set_Message_Token(
27: 'PROCEDURE',
28: 'PAY_FUNCTIONAL_AREAS_PKG.LOCK_ROW'
29: );
30: END IF;

Line 42: Hr_Utility.Set_Message(0,'FORM_RECORD_CHANGED');

38: (area_record.description IS NULL AND p_description IS NULL))
39: THEN
40: RETURN;
41: ELSE
42: Hr_Utility.Set_Message(0,'FORM_RECORD_CHANGED');
43: Hr_Utility.Raise_Error;
44: END IF;
45: END lock_row;
46: --

Line 43: Hr_Utility.Raise_Error;

39: THEN
40: RETURN;
41: ELSE
42: Hr_Utility.Set_Message(0,'FORM_RECORD_CHANGED');
43: Hr_Utility.Raise_Error;
44: END IF;
45: END lock_row;
46: --
47: ----------------------------------------------------------------------------------

Line 84: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');

80: OPEN csr_area_rowid;
81: FETCH csr_area_rowid INTO p_row_id;
82: IF csr_area_rowid%NOTFOUND THEN
83: CLOSE csr_area_rowid;
84: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
85: Hr_Utility.Set_Message_Token(
86: 'PROCEDURE',
87: 'PAY_FUNCTIONAL_AREAS_PKG.INSERT_ROW'
88: );

Line 85: Hr_Utility.Set_Message_Token(

81: FETCH csr_area_rowid INTO p_row_id;
82: IF csr_area_rowid%NOTFOUND THEN
83: CLOSE csr_area_rowid;
84: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
85: Hr_Utility.Set_Message_Token(
86: 'PROCEDURE',
87: 'PAY_FUNCTIONAL_AREAS_PKG.INSERT_ROW'
88: );
89: END IF;

Line 109: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');

105: description = p_description
106: WHERE rowid = p_row_id;
107: --
108: IF SQL%NOTFOUND THEN
109: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
110: Hr_Utility.Set_Message_Token(
111: 'PROCEDURE',
112: 'PAY_FUNCTIONAL_AREAS_PKG.UPDATE_ROW'
113: );

Line 110: Hr_Utility.Set_Message_Token(

106: WHERE rowid = p_row_id;
107: --
108: IF SQL%NOTFOUND THEN
109: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
110: Hr_Utility.Set_Message_Token(
111: 'PROCEDURE',
112: 'PAY_FUNCTIONAL_AREAS_PKG.UPDATE_ROW'
113: );
114: END IF;

Line 127: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');

123: FROM pay_functional_areas
124: WHERE rowid = p_row_id;
125: --
126: IF SQL%NOTFOUND THEN
127: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
128: Hr_Utility.Set_Message_Token(
129: 'PROCEDURE',
130: 'PAY_FUNCTIONAL_AREAS_PKG.DELETE_ROW'
131: );

Line 128: Hr_Utility.Set_Message_Token(

124: WHERE rowid = p_row_id;
125: --
126: IF SQL%NOTFOUND THEN
127: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
128: Hr_Utility.Set_Message_Token(
129: 'PROCEDURE',
130: 'PAY_FUNCTIONAL_AREAS_PKG.DELETE_ROW'
131: );
132: END IF;

Line 160: hr_utility.set_location('PAY_FUNCTIONAL_AREAS_PKG.NAME_IS_NOT_UNIQUE',1);

156: or p_area_id is null);
157: --
158: begin
159: --
160: hr_utility.set_location('PAY_FUNCTIONAL_AREAS_PKG.NAME_IS_NOT_UNIQUE',1);
161: --
162: open csr_duplicate;
163: fetch csr_duplicate into l_dummy_number;
164: v_name_duplicated := csr_duplicate%found;