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 200: hr_utility.set_location(l_proc_name, 10);

196: p_sqlstr OUT NOCOPY VARCHAR2)
197: IS
198: l_proc_name VARCHAR2(100) := l_package || 'range_code';
199: BEGIN
200: hr_utility.set_location(l_proc_name, 10);
201: -- Changed the cursor to reduce the cost (5042843)
202: p_sqlstr := 'SELECT distinct asg.person_id
203: FROM per_periods_of_service pos,
204: per_assignments_f asg,

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

208: AND pos.period_of_service_id = asg.period_of_service_id
209: AND pos.business_group_id = ppa.business_group_id
210: AND asg.business_group_id = ppa.business_group_id
211: ORDER BY asg.person_id';
212: hr_utility.set_location(l_proc_name, 20);
213: END range_code;
214:
215: --------------------------------------------------------------------------------+
216: -- Creates assignment action id for all the valid person id's in

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

287: l_person_id VARCHAR2(15):=NULL;
288:
289: BEGIN
290:
291: --hr_utility.trace_on(NULL,'VV');
292: hr_utility.set_location(l_proc_name, 10);
293:
294: pay_ie_archive_detail_pkg.get_parameters (
295: p_payroll_action_id => p_payroll_action_id

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

288:
289: BEGIN
290:
291: --hr_utility.trace_on(NULL,'VV');
292: hr_utility.set_location(l_proc_name, 10);
293:
294: pay_ie_archive_detail_pkg.get_parameters (
295: p_payroll_action_id => p_payroll_action_id
296: , p_token_name => 'PAYROLL_ID'

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

311: , p_token_name => 'PERSON_ID'
312: , p_token_value => l_person_id);
313:
314:
315: hr_utility.set_location(l_proc_name, 20);
316:
317: FOR rec_asg IN csr_asg(p_payroll_action_id
318: ,p_start_person_id
319: ,p_end_person_id

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

344: , rec_asg.assignment_action_id);
345: --
346:
347: END LOOP;
348: hr_utility.set_location(l_proc_name, 40);
349:
350: EXCEPTION
351: WHEN OTHERS THEN
352: hr_utility.set_location('Error in assignment action code ',100);

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

348: hr_utility.set_location(l_proc_name, 40);
349:
350: EXCEPTION
351: WHEN OTHERS THEN
352: hr_utility.set_location('Error in assignment action code ',100);
353: RAISE;
354: END assignment_action_code;
355:
356: END pay_ie_paypath_tape;