APPS.PAY_HK_IR56_MAGTAPE dependencies on HR_UTILITY

Line 42: hr_utility.set_location('Start of range_code',1);

38: p_sql out nocopy varchar2
39: )
40: is
41: Begin
42: hr_utility.set_location('Start of range_code',1);
43: p_sql := 'SELECT distinct person_id ' ||
44: 'FROM per_people_f ppf, ' ||
45: 'pay_payroll_actions ppa ' ||
46: 'WHERE ppa.payroll_action_id = :payroll_action_id ' ||

Line 49: hr_utility.set_location('End of range_code',2);

45: 'pay_payroll_actions ppa ' ||
46: 'WHERE ppa.payroll_action_id = :payroll_action_id ' ||
47: 'AND ppa.business_group_id = ppf.business_group_id ' ||
48: 'ORDER BY ppf.person_id';
49: hr_utility.set_location('End of range_code',2);
50: End range_code;
51:
52: /********************************************************
53: * Procedure to fetch ASSIGNMENT ACTION CODE *

Line 148: hr_utility.set_location

144:
145: eit_rec check_eit%rowtype;
146: --------------------
147: Begin
148: hr_utility.set_location
149: ('Start of assignment_action_code '||
150: p_payroll_action_id || ':' ||
151: p_start_person_id || ':' ||
152: p_end_person_id,

Line 181: hr_utility.set_location('Before calling hr_nonrun_asact.insact',4);

177: OPEN next_action_id;
178: FETCH next_action_id INTO v_next_action_id;
179: CLOSE next_action_id;
180:
181: hr_utility.set_location('Before calling hr_nonrun_asact.insact',4);
182:
183: hr_nonrun_asact.insact(v_next_action_id,
184: process_rec.assignment_id,
185: p_payroll_action_id,

Line 189: hr_utility.set_location('After calling hr_nonrun_asact.insact',4);

185: p_payroll_action_id,
186: p_chunk,
187: null);
188:
189: hr_utility.set_location('After calling hr_nonrun_asact.insact',4);
190:
191:
192: hr_nonrun_asact.insint(v_next_action_id,
193: process_rec.assignment_action_id

Line 205: hr_utility.set_location('End of assignment_action_code',5);

201:
202:
203:
204: END LOOP;
205: hr_utility.set_location('End of assignment_action_code',5);
206:
207: Exception
208: When Others Then
209: If next_action_id%ISOPEN Then

Line 216: hr_utility.set_location('Exception in assignment_action_code ',20);

212: If check_eit%ISOPEN Then
213: CLOSE check_eit;
214: End If;
215:
216: hr_utility.set_location('Exception in assignment_action_code ',20);
217: RAISE;
218:
219: End assignment_action_code;
220: