APPS.PAY_IE_PAYFILE_SEPA dependencies on HR_UTILITY

Line 51: hr_utility.set_location(l_proc_name, 10);

47: l_proc_name VARCHAR2(100) := g_package || 'range_code';
48:
49: BEGIN
50:
51: hr_utility.set_location(l_proc_name, 10);
52:
53:
54: p_sqlstr := 'SELECT distinct asg.person_id
55: FROM per_periods_of_service pos,

Line 64: hr_utility.set_location(l_proc_name, 20);

60: AND pos.period_of_service_id = asg.period_of_service_id
61: AND pos.business_group_id = ppa.business_group_id
62: AND asg.business_group_id = ppa.business_group_id
63: ORDER BY asg.person_id';
64: hr_utility.set_location(l_proc_name, 20);
65:
66: END range_code;
67:
68: --------------------------------------------------------------------------------+

Line 144: --hr_utility.trace_on(NULL,'VV');

140: l_person_id VARCHAR2(15):=NULL;
141:
142: BEGIN
143:
144: --hr_utility.trace_on(NULL,'VV');
145: hr_utility.set_location(l_proc_name, 10);
146:
147: pay_ie_archive_detail_pkg.get_parameters (
148: p_payroll_action_id => p_payroll_action_id

Line 145: hr_utility.set_location(l_proc_name, 10);

141:
142: BEGIN
143:
144: --hr_utility.trace_on(NULL,'VV');
145: hr_utility.set_location(l_proc_name, 10);
146:
147: pay_ie_archive_detail_pkg.get_parameters (
148: p_payroll_action_id => p_payroll_action_id
149: , p_token_name => 'PAYROLL_ID'

Line 168: hr_utility.set_location(l_proc_name, 20);

164: , p_token_name => 'PERSON_ID'
165: , p_token_value => l_person_id);
166:
167:
168: hr_utility.set_location(l_proc_name, 20);
169:
170: FOR rec_asg IN csr_asg(p_payroll_action_id
171: ,p_start_person_id
172: ,p_end_person_id

Line 201: hr_utility.set_location(l_proc_name, 40);

197: , rec_asg.assignment_action_id);
198: --
199:
200: END LOOP;
201: hr_utility.set_location(l_proc_name, 40);
202:
203: EXCEPTION
204: WHEN OTHERS THEN
205: hr_utility.set_location('Error in assignment action code ',100);

Line 205: hr_utility.set_location('Error in assignment action code ',100);

201: hr_utility.set_location(l_proc_name, 40);
202:
203: EXCEPTION
204: WHEN OTHERS THEN
205: hr_utility.set_location('Error in assignment action code ',100);
206: RAISE;
207: END assignment_action_code;
208:
209:

Line 329: hr_utility.set_location('--In Payee Address ',30);

325:
326: --
327: BEGIN
328:
329: hr_utility.set_location('--In Payee Address ',30);
330: --
331:
332: IF p_payee_type = 'P'
333: THEN -- Person Address

Line 347: hr_utility.set_location('--Leaving Payee Address ',30);

343: FETCH csr_get_org_address INTO p_line1,p_line2,p_line3,p_country,p_postal_code,p_geo_code;
344: CLOSE csr_get_org_address;
345: END IF;
346: --
347: hr_utility.set_location('--Leaving Payee Address ',30);
348: RETURN l_addr_ret;
349: --
350: END get_payee_address;
351:

Line 377: hr_utility.set_location('--In Core PAYEE Return ',11);

373: l_payee_type
374: ,l_payee_id
375: ,p_date_earned),1,35); --
376:
377: hr_utility.set_location('--In Core PAYEE Return ',11);
378: CLOSE csr_get_payee_type_id;
379: RETURN l_payee_name;
380:
381: ELSIF l_payee_type = 'P' OR l_payee_type = 'p'