DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PSTA dependencies on HR_UTILITY

Line 14: g_debug boolean := hr_utility.debug_enabled;

10:
11: g_actid number;
12: g_run_payroll_action_id number;
13: g_package varchar2 (33) := 'PAY_FI_ARCHIVE_PSTA .';
14: g_debug boolean := hr_utility.debug_enabled;
15: g_business_group_id number;
16: g_legal_employer_id number;
17: g_effective_date date;
18: g_year varchar2 (4);

Line 59: hr_utility.set_location (' Entering Function GET_PARAMETER', 10);

55: l_delimiter varchar2 (1) := ' ';
56: l_proc varchar2 (240) := g_package || ' get parameter ';
57: begin
58: if g_debug then
59: hr_utility.set_location (' Entering Function GET_PARAMETER', 10);
60: end if;
61:
62: l_start_pos := instr (' ' || p_parameter_string, l_delimiter || p_token || '=');
63:

Line 91: hr_utility.set_location (' Leaving Function GET_PARAMETER', 20);

87: end if;
88:
89: --
90: if g_debug then
91: hr_utility.set_location (' Leaving Function GET_PARAMETER', 20);
92: end if;
93:
94: return l_parameter;
95: end;

Line 139: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS', 30);

135: close csr_parameter_info;
136:
137: --
138: if g_debug then
139: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS', 30);
140: end if;
141: end get_all_parameters;
142: --
143: --

Line 209: hr_utility.set_location (' Entering Procedure RANGE_CODE', 10);

205: l_country hr_locations.country%type;
206: l_payroll_name pay_payrolls_f.payroll_name%type;
207: begin
208: if g_debug then
209: hr_utility.set_location (' Entering Procedure RANGE_CODE', 10);
210: end if;
211:
212: p_sql :=
213: 'SELECT DISTINCT person_id

Line 1785: hr_utility.set_location (' Entering Function GET_COUNTRY_NAME', 140);

1781:
1782: l_country fnd_territories_vl.territory_short_name%type;
1783: begin
1784: if g_debug then
1785: hr_utility.set_location (' Entering Function GET_COUNTRY_NAME', 140);
1786: end if;
1787:
1788: open csr_get_territory_name (p_territory_code);
1789: fetch csr_get_territory_name into l_country;

Line 1794: hr_utility.set_location (' Leaving Function GET_COUNTRY_NAME', 150);

1790: close csr_get_territory_name;
1791: return l_country;
1792:
1793: if g_debug then
1794: hr_utility.set_location (' Leaving Function GET_COUNTRY_NAME', 150);
1795: end if;
1796: end get_country_name;
1797:
1798: function get_balance_value (

Line 1839: hr_utility.trace ('SQLERR - ' || sqlerrm);

1835: )
1836: );
1837: exception
1838: when others then
1839: hr_utility.trace ('SQLERR - ' || sqlerrm);
1840: end get_balance_value;
1841: --
1842: --
1843: end pay_fi_archive_psta;