APPS.PAY_IE_PAYPATH_TAPE dependencies on HR_UTILITY

Line 38: hr_utility.set_location('p_token_name = ' || p_token_name,20);

34:
35:
36:
37:
38: hr_utility.set_location('p_token_name = ' || p_token_name,20);
39:
40: OPEN csr_parameter_info(p_payroll_action_id,p_token_name);
41: FETCH csr_parameter_info INTO l_token_value,l_business_group_id;
42: CLOSE csr_parameter_info;

Line 47: hr_utility.set_location('l_token_value = ' || l_token_value,20);

43:
44: p_token_value := trim(l_token_value);
45:
46:
47: hr_utility.set_location('l_token_value = ' || l_token_value,20);
48: hr_utility.set_location('Leaving ' || 'get_parameters',30);
49:
50: END get_parameters;*/
51:

Line 48: hr_utility.set_location('Leaving ' || 'get_parameters',30);

44: p_token_value := trim(l_token_value);
45:
46:
47: hr_utility.set_location('l_token_value = ' || l_token_value,20);
48: hr_utility.set_location('Leaving ' || 'get_parameters',30);
49:
50: END get_parameters;*/
51:
52: --------------------------------------------------------------------------------+

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

220: p_sqlstr OUT NOCOPY VARCHAR2)
221: IS
222: l_proc_name VARCHAR2(100) := l_package || 'range_code';
223: BEGIN
224: hr_utility.set_location(l_proc_name, 10);
225: -- Changed the cursor to reduce the cost (5042843)
226: p_sqlstr := 'SELECT distinct asg.person_id
227: FROM per_periods_of_service pos,
228: per_assignments_f asg,

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

232: AND pos.period_of_service_id = asg.period_of_service_id
233: AND pos.business_group_id = ppa.business_group_id
234: AND asg.business_group_id = ppa.business_group_id
235: ORDER BY asg.person_id';
236: hr_utility.set_location(l_proc_name, 20);
237: END range_code;
238:
239: --------------------------------------------------------------------------------+
240: -- Creates assignment action id for all the valid person id's in

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

311: l_person_id VARCHAR2(15):=NULL;
312:
313: BEGIN
314:
315: --hr_utility.trace_on(NULL,'VV');
316: hr_utility.set_location(l_proc_name, 10);
317:
318: pay_ie_archive_detail_pkg.get_parameters (
319: p_payroll_action_id => p_payroll_action_id

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

312:
313: BEGIN
314:
315: --hr_utility.trace_on(NULL,'VV');
316: hr_utility.set_location(l_proc_name, 10);
317:
318: pay_ie_archive_detail_pkg.get_parameters (
319: p_payroll_action_id => p_payroll_action_id
320: , p_token_name => 'PAYROLL_ID'

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

335: , p_token_name => 'PERSON_ID'
336: , p_token_value => l_person_id);
337:
338:
339: hr_utility.set_location(l_proc_name, 20);
340:
341: FOR rec_asg IN csr_asg(p_payroll_action_id
342: ,p_start_person_id
343: ,p_end_person_id

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

368: , rec_asg.assignment_action_id);
369: --
370:
371: END LOOP;
372: hr_utility.set_location(l_proc_name, 40);
373:
374: EXCEPTION
375: WHEN OTHERS THEN
376: hr_utility.set_location('Error in assignment action code ',100);

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

372: hr_utility.set_location(l_proc_name, 40);
373:
374: EXCEPTION
375: WHEN OTHERS THEN
376: hr_utility.set_location('Error in assignment action code ',100);
377: RAISE;
378: END assignment_action_code;
379:
380: