eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SA_HIST_ARCH_PKG dependencies on HR_UTILITY

Line 23: hr_utility.trace('Entering get_parameters');

19: l_token_value varchar2(50) := null;
20:
21: begin
22:
23: hr_utility.trace('Entering get_parameters');
24:
25: hr_utility.set_location('p_token_name: ' || p_token_name,10);
26:
27: open csr_parameter_info(p_payroll_action_id,

Line 25: hr_utility.set_location('p_token_name: ' || p_token_name,10);

21: begin
22:
23: hr_utility.trace('Entering get_parameters');
24:
25: hr_utility.set_location('p_token_name: ' || p_token_name,10);
26:
27: open csr_parameter_info(p_payroll_action_id,
28: p_token_name);
29: fetch csr_parameter_info into l_token_value;

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

30: close csr_parameter_info;
31:
32: p_token_value := l_token_value;
33:
34: hr_utility.set_location('l_token_value: ' || l_token_value,20);
35:
36: hr_utility.trace('Leaving get_parameters');
37: exception
38: when OTHERS

Line 36: hr_utility.trace('Leaving get_parameters');

32: p_token_value := l_token_value;
33:
34: hr_utility.set_location('l_token_value: ' || l_token_value,20);
35:
36: hr_utility.trace('Leaving get_parameters');
37: exception
38: when OTHERS
39: then
40: hr_utility.set_location('Exception occured in get_parameters: '||SQLERRM,30);

Line 40: hr_utility.set_location('Exception occured in get_parameters: '||SQLERRM,30);

36: hr_utility.trace('Leaving get_parameters');
37: exception
38: when OTHERS
39: then
40: hr_utility.set_location('Exception occured in get_parameters: '||SQLERRM,30);
41: raise;
42: end get_parameters;
43:
44: /**------------------------------------------------------------

Line 57: hr_utility.trace('Entering range_cursor');

53: l_payroll_id number := null;
54:
55: begin
56:
57: hr_utility.trace('Entering range_cursor');
58:
59: pay_sa_hist_arch_pkg.get_parameters (
60: p_payroll_action_id => pactid
61: , p_token_name => 'PAYROLL_NAME'

Line 64: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);

60: p_payroll_action_id => pactid
61: , p_token_name => 'PAYROLL_NAME'
62: , p_token_value => l_payroll_id);
63:
64: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
65:
66: if l_payroll_id is null then
67: --
68: -- Use full cursor not restricting by payroll

Line 70: hr_utility.trace('Range Cursor Not using Payroll Restriction');

66: if l_payroll_id is null then
67: --
68: -- Use full cursor not restricting by payroll
69: --
70: hr_utility.trace('Range Cursor Not using Payroll Restriction');
71: sqlstr := 'SELECT DISTINCT person_id
72: FROM per_people_f ppf,
73: pay_payroll_actions ppa
74: WHERE ppa.payroll_action_id = :payroll_action_id

Line 81: hr_utility.trace('Range Cursor using Payroll Restriction');

77: else
78: --
79: -- The Payroll ID was used as parameter, so restrict by this
80: --
81: hr_utility.trace('Range Cursor using Payroll Restriction');
82: sqlstr := 'SELECT DISTINCT ppf.person_id
83: FROM per_all_people_f ppf,
84: pay_payroll_actions ppa,
85: per_all_assignments_f paaf

Line 93: hr_utility.trace('Leaving range_cursor');

89: AND paaf.payroll_id = '|| to_char(l_payroll_id)||
90: ' ORDER BY ppf.person_id';
91: end if;
92:
93: hr_utility.trace('Leaving range_cursor');
94: exception
95: when OTHERS
96: then
97: sqlstr := 'select 1 '||

Line 102: hr_utility.set_location('Exception occured in range_cursor: '||SQLERRM,30);

98: '/* ERROR - Employer Details Fetch failed with: '||
99: sqlerrm(sqlcode)||' */ '||
100: 'from dual where to_char(:payroll_action_id) = dummy';
101:
102: hr_utility.set_location('Exception occured in range_cursor: '||SQLERRM,30);
103: raise;
104: end range_cursor;
105:
106: /**------------------------------------------------------------

Line 167: hr_utility.trace('Entering action_creation' );

163: l_payroll_id number := null;
164: l_bg_id number := null;
165: lockingactid varchar2(100);
166: begin
167: hr_utility.trace('Entering action_creation' );
168:
169: get_parameters(pactid,'PAYROLL_NAME',l_payroll_id);
170: get_parameters(pactid,'P_START_DATE',l_start_date);
171: get_parameters(pactid,'P_END_DATE',l_end_date);

Line 178: hr_utility.set_location('l_payroll_id :' ||l_payroll_id ,10);

174: into l_bg_id
175: from pay_payroll_actions
176: where payroll_action_id = pactid;
177:
178: hr_utility.set_location('l_payroll_id :' ||l_payroll_id ,10);
179: hr_utility.set_location('l_start_date :' ||l_start_date ,10);
180: hr_utility.set_location('l_end_date :' ||l_end_date ,10);
181: hr_utility.set_location('l_bg_id :' ||l_bg_id ,10);
182: hr_utility.set_location('stperson :' ||stperson ,10);

Line 179: hr_utility.set_location('l_start_date :' ||l_start_date ,10);

175: from pay_payroll_actions
176: where payroll_action_id = pactid;
177:
178: hr_utility.set_location('l_payroll_id :' ||l_payroll_id ,10);
179: hr_utility.set_location('l_start_date :' ||l_start_date ,10);
180: hr_utility.set_location('l_end_date :' ||l_end_date ,10);
181: hr_utility.set_location('l_bg_id :' ||l_bg_id ,10);
182: hr_utility.set_location('stperson :' ||stperson ,10);
183: hr_utility.set_location('endperson :' ||endperson ,10);

Line 180: hr_utility.set_location('l_end_date :' ||l_end_date ,10);

176: where payroll_action_id = pactid;
177:
178: hr_utility.set_location('l_payroll_id :' ||l_payroll_id ,10);
179: hr_utility.set_location('l_start_date :' ||l_start_date ,10);
180: hr_utility.set_location('l_end_date :' ||l_end_date ,10);
181: hr_utility.set_location('l_bg_id :' ||l_bg_id ,10);
182: hr_utility.set_location('stperson :' ||stperson ,10);
183: hr_utility.set_location('endperson :' ||endperson ,10);
184:

Line 181: hr_utility.set_location('l_bg_id :' ||l_bg_id ,10);

177:
178: hr_utility.set_location('l_payroll_id :' ||l_payroll_id ,10);
179: hr_utility.set_location('l_start_date :' ||l_start_date ,10);
180: hr_utility.set_location('l_end_date :' ||l_end_date ,10);
181: hr_utility.set_location('l_bg_id :' ||l_bg_id ,10);
182: hr_utility.set_location('stperson :' ||stperson ,10);
183: hr_utility.set_location('endperson :' ||endperson ,10);
184:
185: for asgrec in get_arch_action_det(l_payroll_id,l_bg_id,l_start_date,l_end_date)

Line 182: hr_utility.set_location('stperson :' ||stperson ,10);

178: hr_utility.set_location('l_payroll_id :' ||l_payroll_id ,10);
179: hr_utility.set_location('l_start_date :' ||l_start_date ,10);
180: hr_utility.set_location('l_end_date :' ||l_end_date ,10);
181: hr_utility.set_location('l_bg_id :' ||l_bg_id ,10);
182: hr_utility.set_location('stperson :' ||stperson ,10);
183: hr_utility.set_location('endperson :' ||endperson ,10);
184:
185: for asgrec in get_arch_action_det(l_payroll_id,l_bg_id,l_start_date,l_end_date)
186: loop

Line 183: hr_utility.set_location('endperson :' ||endperson ,10);

179: hr_utility.set_location('l_start_date :' ||l_start_date ,10);
180: hr_utility.set_location('l_end_date :' ||l_end_date ,10);
181: hr_utility.set_location('l_bg_id :' ||l_bg_id ,10);
182: hr_utility.set_location('stperson :' ||stperson ,10);
183: hr_utility.set_location('endperson :' ||endperson ,10);
184:
185: for asgrec in get_arch_action_det(l_payroll_id,l_bg_id,l_start_date,l_end_date)
186: loop
187: select pay_assignment_actions_s.nextval

Line 201: hr_utility.trace('Leaving action_creation' );

197: object_type => 'ASG',
198: object_id => asgrec.assignment_action_id
199: );
200: end loop;
201: hr_utility.trace('Leaving action_creation' );
202: exception
203: when OTHERS
204: then
205: hr_utility.set_location('Exception occured in action_creation: '||SQLERRM,30);

Line 205: hr_utility.set_location('Exception occured in action_creation: '||SQLERRM,30);

201: hr_utility.trace('Leaving action_creation' );
202: exception
203: when OTHERS
204: then
205: hr_utility.set_location('Exception occured in action_creation: '||SQLERRM,30);
206: raise;
207: end action_creation;
208:
209: procedure archinit(p_payroll_action_id in number) is

Line 211: hr_utility.trace('Entering archinit');

207: end action_creation;
208:
209: procedure archinit(p_payroll_action_id in number) is
210: begin
211: hr_utility.trace('Entering archinit');
212: null;
213: hr_utility.trace('Leaving archinit');
214: end archinit;
215:

Line 213: hr_utility.trace('Leaving archinit');

209: procedure archinit(p_payroll_action_id in number) is
210: begin
211: hr_utility.trace('Entering archinit');
212: null;
213: hr_utility.trace('Leaving archinit');
214: end archinit;
215:
216: /**------------------------------------------------------------
217: ** Name : archive_historic_data

Line 265: hr_utility.trace('Entering archive_historic_data');

261: l_effective_date date;
262:
263: begin
264:
265: hr_utility.trace('Entering archive_historic_data');
266: hr_utility.set_location('Current assignment_action_id - p_assactid: '
267: || p_assactid, 10);
268:
269: --getting the archived assignment_action_id

Line 266: hr_utility.set_location('Current assignment_action_id - p_assactid: '

262:
263: begin
264:
265: hr_utility.trace('Entering archive_historic_data');
266: hr_utility.set_location('Current assignment_action_id - p_assactid: '
267: || p_assactid, 10);
268:
269: --getting the archived assignment_action_id
270:

Line 275: hr_utility.set_location('Archived assignment_action_id - l_assignment_action_id: '

271: open get_archive_asg_id;
272: fetch get_archive_asg_id into l_assignment_action_id;
273: close get_archive_asg_id;
274:
275: hr_utility.set_location('Archived assignment_action_id - l_assignment_action_id: '
276: || l_assignment_action_id, 20);
277:
278: open get_run_action_det(l_assignment_action_id);
279: fetch get_run_action_det into l_assignment_id, l_run_asg_action_id, l_effective_date;

Line 294: hr_utility.trace('Leaving archive_historic_data');

290: p_assignment_id => l_assignment_id,
291: p_payroll_action_id => l_payroll_action_id,
292: p_effective_date => l_effective_date ) ;
293:
294: hr_utility.trace('Leaving archive_historic_data');
295: exception
296: when OTHERS
297: then
298: hr_utility.set_location('Exception occured in archive_historic_data: '||SQLERRM,30);

Line 298: hr_utility.set_location('Exception occured in archive_historic_data: '||SQLERRM,30);

294: hr_utility.trace('Leaving archive_historic_data');
295: exception
296: when OTHERS
297: then
298: hr_utility.set_location('Exception occured in archive_historic_data: '||SQLERRM,30);
299: raise;
300: end archive_historic_data;
301:
302: END pay_sa_hist_arch_pkg;