APPS.PAY_SD_CREATE_TEMPLATES dependencies on HR_UTILITY

Line 24: hr_utility.set_location('Entering:'|| l_proc, 10);

20: l_count NUMBER(1);
21: l_file_name per_solution_cmpt_names.name%type;
22: l_proc varchar2(72) := g_package || 'POST_INSERT';
23: BEGIN
24: hr_utility.set_location('Entering:'|| l_proc, 10);
25: FOR cur_fnd_lob_rec IN csr_fnd_lob(file_id)
26: LOOP
27: /* fix for bug# 5745886 */
28: /* l_file_name := SUBSTR(cur_fnd_lob_rec.file_name,INSTR(cur_fnd_lob_rec.file_name,'/',-1)+1); */

Line 37: hr_utility.set_location(l_proc, 30);

33: FROM per_solution_cmpt_names
34: WHERE name = l_file_name;
35: --
36: IF l_count > 0 THEN
37: hr_utility.set_location(l_proc, 30);
38: UPDATE per_solution_cmpt_names SET template_file = cur_fnd_lob_rec.file_data
39: WHERE name = l_file_name;
40: END IF;
41: END LOOP;

Line 43: hr_utility.set_location(' Leaving:'||l_proc, 70);

39: WHERE name = l_file_name;
40: END IF;
41: END LOOP;
42: COMMIT;
43: hr_utility.set_location(' Leaving:'||l_proc, 70);
44: EXCEPTION
45: WHEN OTHERS THEN
46: hr_utility.set_location(' Leaving:'||l_proc, 90);
47: raise;

Line 46: hr_utility.set_location(' Leaving:'||l_proc, 90);

42: COMMIT;
43: hr_utility.set_location(' Leaving:'||l_proc, 70);
44: EXCEPTION
45: WHEN OTHERS THEN
46: hr_utility.set_location(' Leaving:'||l_proc, 90);
47: raise;
48: END post_insert;
49: END pay_sd_create_templates;