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_HK_IR56_REPORT dependencies on HR_UTILITY

Line 41: --hr_utility.trace_on(null, 'pay_hk_ir56_report');

37: procedure range_code
38: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
39: p_sql out nocopy varchar2) is
40: begin
41: --hr_utility.trace_on(null, 'pay_hk_ir56_report');
42: hr_utility.set_location('Start of range_code',1);
43:
44: p_sql := 'select distinct person_id ' ||
45: 'from per_people_f ppf, ' ||

Line 42: hr_utility.set_location('Start of range_code',1);

38: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
39: p_sql out nocopy varchar2) is
40: begin
41: --hr_utility.trace_on(null, 'pay_hk_ir56_report');
42: hr_utility.set_location('Start of range_code',1);
43:
44: p_sql := 'select distinct person_id ' ||
45: 'from per_people_f ppf, ' ||
46: 'pay_payroll_actions ppa ' ||

Line 51: hr_utility.set_location('End of range_code',2);

47: 'where ppa.payroll_action_id = :payroll_action_id ' ||
48: 'and ppa.business_group_id = ppf.business_group_id ' ||
49: 'order by ppf.person_id';
50:
51: hr_utility.set_location('End of range_code',2);
52: end range_code;
53: ------------------------------------------------------------------------
54: -- This procedure is used to restrict the Assignment Action Creation.
55: -- It calls the procedure that actually inserts the Assignment Actions.

Line 152: --hr_utility.trace_on(null, 'pay_hk_ir56_report');

148: WHERE pai.locked_action_id = paa.assignment_action_id)
149: ;
150:
151: begin
152: --hr_utility.trace_on(null, 'pay_hk_ir56_report');
153: hr_utility.set_location('Start of assignment_action_code '||
154: p_payroll_action_id || ':' ||
155: p_start_person_id || ':' || p_end_person_id,3);
156:

Line 153: hr_utility.set_location('Start of assignment_action_code '||

149: ;
150:
151: begin
152: --hr_utility.trace_on(null, 'pay_hk_ir56_report');
153: hr_utility.set_location('Start of assignment_action_code '||
154: p_payroll_action_id || ':' ||
155: p_start_person_id || ':' || p_end_person_id,3);
156:
157: --

Line 205: hr_utility.set_location('Before calling hr_nonrun_asact.insact',4);

201: p_start_person_id,
202: p_end_person_id)
203: loop
204:
205: hr_utility.set_location('Before calling hr_nonrun_asact.insact',4);
206:
207: l_x_hk_archive_message :=
208: pay_hk_ir56_report.get_archive_value('X_HK_ARCHIVE_MESSAGE',
209: process_rec.assignment_action_id);

Line 231: hr_utility.set_location('After calling hr_nonrun_asact.insint',4);

227: p_chunk,
228: null);
229: end if;
230:
231: hr_utility.set_location('After calling hr_nonrun_asact.insint',4);
232:
233: end loop;
234: elsif l_error = 1 then
235: raise_application_error(-20001, 'Cannot submit FULL IR56B report, Full Run Already Submitted') ;

Line 242: hr_utility.set_location('End of assignment_action_code',5);

238: else
239: raise_application_error(-20001, 'Cannot submit IR56B report') ;
240: end if;
241:
242: hr_utility.set_location('End of assignment_action_code',5);
243: --hr_utility.trace_off;
244:
245: end assignment_action_code;
246:

Line 243: --hr_utility.trace_off;

239: raise_application_error(-20001, 'Cannot submit IR56B report') ;
240: end if;
241:
242: hr_utility.set_location('End of assignment_action_code',5);
243: --hr_utility.trace_off;
244:
245: end assignment_action_code;
246:
247: -----------------------------------------------------------------------------

Line 292: --hr_utility.trace_on(null, 'pay_hk_ir56_report');

288: and business_group_id is null
289: and legislation_code = 'HK' ;
290:
291: begin
292: --hr_utility.trace_on(null, 'pay_hk_ir56_report');
293:
294: -- Get all of the parameters needed to submit the report. Parameters defined
295: -- in the concurrent program definition are passed through here by the PAR
296: -- process. End the loop by the exception clause because we don't know

Line 301: hr_utility.set_location('Start submit_report',1);

297: -- what order the parameters will be in.
298:
299: -- Default the parameters in case they are not found.
300:
301: hr_utility.set_location('Start submit_report',1);
302: l_archive_action_id := 0;
303: l_full_or_partial := ' ';
304: l_assignment_id := 0;
305:

Line 333: hr_utility.set_location(' prm_names (' || l_count || ') : ' ||

329: l_assignment_id :=
330: to_number(pay_mag_tape.internal_prm_values(l_count));
331: end if;
332:
333: hr_utility.set_location(' prm_names (' || l_count || ') : ' ||
334: pay_mag_tape.internal_prm_names(l_count), 10);
335: hr_utility.set_location(' prm_values (' || l_count || ') : ' ||
336: pay_mag_tape.internal_prm_values(l_count), 10);
337:

Line 335: hr_utility.set_location(' prm_values (' || l_count || ') : ' ||

331: end if;
332:
333: hr_utility.set_location(' prm_names (' || l_count || ') : ' ||
334: pay_mag_tape.internal_prm_names(l_count), 10);
335: hr_utility.set_location(' prm_values (' || l_count || ') : ' ||
336: pay_mag_tape.internal_prm_values(l_count), 10);
337:
338: end loop;
339: exception

Line 341: hr_utility.set_location('No data found',1);

337:
338: end loop;
339: exception
340: when no_data_found then
341: hr_utility.set_location('No data found',1);
342: null;
343: when value_error then
344: hr_utility.set_location('Value error',1);
345: null;

Line 344: hr_utility.set_location('Value error',1);

340: when no_data_found then
341: hr_utility.set_location('No data found',1);
342: null;
343: when value_error then
344: hr_utility.set_location('Value error',1);
345: null;
346: end;
347:
348: hr_utility.set_location('submit_report : Parameters obtained',1);

Line 348: hr_utility.set_location('submit_report : Parameters obtained',1);

344: hr_utility.set_location('Value error',1);
345: null;
346: end;
347:
348: hr_utility.set_location('submit_report : Parameters obtained',1);
349: hr_utility.set_location(' payroll action id : ' || l_payroll_action_id,1);
350: hr_utility.set_location(' archive action id : ' || l_archive_action_id,1);
351: hr_utility.set_location(' full or partial : ' || l_full_or_partial,1);
352: hr_utility.set_location(' assignment id : ' || l_assignment_id, 2);

Line 349: hr_utility.set_location(' payroll action id : ' || l_payroll_action_id,1);

345: null;
346: end;
347:
348: hr_utility.set_location('submit_report : Parameters obtained',1);
349: hr_utility.set_location(' payroll action id : ' || l_payroll_action_id,1);
350: hr_utility.set_location(' archive action id : ' || l_archive_action_id,1);
351: hr_utility.set_location(' full or partial : ' || l_full_or_partial,1);
352: hr_utility.set_location(' assignment id : ' || l_assignment_id, 2);
353:

Line 350: hr_utility.set_location(' archive action id : ' || l_archive_action_id,1);

346: end;
347:
348: hr_utility.set_location('submit_report : Parameters obtained',1);
349: hr_utility.set_location(' payroll action id : ' || l_payroll_action_id,1);
350: hr_utility.set_location(' archive action id : ' || l_archive_action_id,1);
351: hr_utility.set_location(' full or partial : ' || l_full_or_partial,1);
352: hr_utility.set_location(' assignment id : ' || l_assignment_id, 2);
353:
354: -- Default the number of report copies to 0.

Line 351: hr_utility.set_location(' full or partial : ' || l_full_or_partial,1);

347:
348: hr_utility.set_location('submit_report : Parameters obtained',1);
349: hr_utility.set_location(' payroll action id : ' || l_payroll_action_id,1);
350: hr_utility.set_location(' archive action id : ' || l_archive_action_id,1);
351: hr_utility.set_location(' full or partial : ' || l_full_or_partial,1);
352: hr_utility.set_location(' assignment id : ' || l_assignment_id, 2);
353:
354: -- Default the number of report copies to 0.
355:

Line 352: hr_utility.set_location(' assignment id : ' || l_assignment_id, 2);

348: hr_utility.set_location('submit_report : Parameters obtained',1);
349: hr_utility.set_location(' payroll action id : ' || l_payroll_action_id,1);
350: hr_utility.set_location(' archive action id : ' || l_archive_action_id,1);
351: hr_utility.set_location(' full or partial : ' || l_full_or_partial,1);
352: hr_utility.set_location(' assignment id : ' || l_assignment_id, 2);
353:
354: -- Default the number of report copies to 0.
355:
356: l_number_of_copies := 0;/*Reverted fix for 2810178 */

Line 376: hr_utility.set_location('submit_report : Submit request',3);

372:
373: -- Submit the report
374:
375: begin
376: hr_utility.set_location('submit_report : Submit request',3);
377:
378: -- Need to supply the parameters with keywords because it's a postscript report
379: -- and the option version=2.0b set in the SRS definition uses a keyword, hence
380: -- all the parameters need to as well.

Line 453: hr_utility.set_location('end submit_report', 5);

449: pay_mag_tape.internal_prm_values(1) := '2';
450: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
451: pay_mag_tape.internal_prm_values(2) := l_formula_id;
452:
453: hr_utility.set_location('end submit_report', 5);
454: --hr_utility.trace_off;
455:
456: end submit_report;
457:

Line 454: --hr_utility.trace_off;

450: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
451: pay_mag_tape.internal_prm_values(2) := l_formula_id;
452:
453: hr_utility.set_location('end submit_report', 5);
454: --hr_utility.trace_off;
455:
456: end submit_report;
457:
458: -----------------------------------------------------------------------------

Line 483: hr_utility.set_location('Start of get archive value ',1);

479: and fue.user_entity_name = c_archive_name;
480:
481: begin
482:
483: hr_utility.set_location('Start of get archive value ',1);
484:
485: open csr_get_archive_value(p_archive_name,
486: p_assignment_action_id);
487: fetch csr_get_archive_value into l_value;

Line 495: hr_utility.set_location('End of get archive value ',2);

491: end if;
492:
493: close csr_get_archive_value;
494:
495: hr_utility.set_location('End of get archive value ',2);
496:
497: return(l_value);
498:
499: exception