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_GB_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_gb_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 168: hr_utility.trace('Entering action_creation' );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

232:
233: l_assignment_action_id pay_assignment_actions.assignment_Action_id%type;
234: begin
235:
236: hr_utility.trace('Entering archive_historic_data');
237: hr_utility.set_location('Current assignment_action_id - p_assactid: '
238: || p_assactid, 10);
239:
240: --getting the archived assignment_action_id

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

233: l_assignment_action_id pay_assignment_actions.assignment_Action_id%type;
234: begin
235:
236: hr_utility.trace('Entering archive_historic_data');
237: hr_utility.set_location('Current assignment_action_id - p_assactid: '
238: || p_assactid, 10);
239:
240: --getting the archived assignment_action_id
241:

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

242: open get_archive_asg_id;
243: fetch get_archive_asg_id into l_assignment_action_id;
244: close get_archive_asg_id;
245:
246: hr_utility.set_location('Archived assignment_action_id - l_assignment_action_id: '
247: || l_assignment_action_id, 20);
248:
249: --Calling archive procedure to archive payments and deductions details for
250: --this assignment_action_id

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

249: --Calling archive procedure to archive payments and deductions details for
250: --this assignment_action_id
251: PAY_GB_PAYSLIP_ARCHIVE.get_pay_deduct_element_info(l_assignment_action_id);
252:
253: hr_utility.trace('Leaving archive_historic_data');
254: exception
255: when OTHERS
256: then
257: hr_utility.set_location('Exception occured in archive_historic_data: '||SQLERRM,30);

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

253: hr_utility.trace('Leaving archive_historic_data');
254: exception
255: when OTHERS
256: then
257: hr_utility.set_location('Exception occured in archive_historic_data: '||SQLERRM,30);
258: raise;
259: end archive_historic_data;
260:
261: END pay_gb_hist_arch_pkg;