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

Line 106: hr_utility.set_location('Entering: '||l_proc, 5);

102: l_proc varchar2(72) := 'PAY_VOID_REVERSAL_PKG.CHECK_WRITER_WRAPPER';
103: --
104: begin
105:
106: hr_utility.set_location('Entering: '||l_proc, 5);
107:
108: l_request_id := 0;
109:
110: --

Line 116: hr_utility.set_location(l_proc, 10);

112: fetch c_sequence into l_asg_set_id;
113: close c_sequence;
114: --
115:
116: hr_utility.set_location(l_proc, 10);
117:
118: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_format);
119: if l_format is not null then
120: hr_utility.trace(l_format);

Line 120: hr_utility.trace(l_format);

116: hr_utility.set_location(l_proc, 10);
117:
118: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_format);
119: if l_format is not null then
120: hr_utility.trace(l_format);
121: else
122: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');
123: l_format := 'DD-MM-YYYY';
124: end if;

Line 122: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');

118: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_format);
119: if l_format is not null then
120: hr_utility.trace(l_format);
121: else
122: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');
123: l_format := 'DD-MM-YYYY';
124: end if;
125:
126: -- if group 1

Line 131: hr_utility.set_location(l_proc, 20);

127: -- Derive payroll name, consolidation set from pay_payroll_actions
128: -- Derive the previous check writer details from pay_payroll_actions
129: IF p_group_id = 1 THEN
130:
131: hr_utility.set_location(l_proc, 20);
132:
133: SELECT DISTINCT ppa.payroll_action_id
134: ,ppa.payroll_id
135: ,ppp.org_payment_method_id

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

178: AND to_date (p_end_date
179: ,l_format) BETWEEN popmf.effective_start_date
180: AND popmf.effective_end_date;
181:
182: hr_utility.set_location(l_proc, 30);
183:
184: -- get the sort sequence
185: select lookup_code into l_sort_sequence
186: from hr_lookups

Line 197: hr_utility.set_location(l_proc, 40);

193: and lookup_code='PAYUSCHK';
194: --
195: END IF;
196:
197: hr_utility.set_location(l_proc, 40);
198:
199: -- Create Assignment Set and add this employee
200: l_asg_set_name := 'VR_asg_set_' || to_char(p_check_assignment_action)||l_asg_set_id;
201:

Line 210: hr_utility.set_location(l_proc, 50);

206: p_payroll_id => check_details_rec.payroll_id,
207: p_assignment_set_name => l_asg_set_name,
208: p_formula_id => null);
209:
210: hr_utility.set_location(l_proc, 50);
211:
212: -- Adding this assignment to the the assignment_set
213:
214: HR_ASSIGNMENT_SET_AMDS_PKG.insert_row(

Line 220: hr_utility.set_location(l_proc, 60);

216: p_assignment_id => check_details_rec.assignment_id,
217: p_assignment_set_id => l_asg_set_id,
218: p_include_or_exclude => 'I');
219:
220: hr_utility.set_location(l_proc, 60);
221:
222: commit;
223:
224:

Line 225: hr_utility.trace('Details for submitting the check writer');

221:
222: commit;
223:
224:
225: hr_utility.trace('Details for submitting the check writer');
226: hr_utility.trace('========================================');
227: hr_utility.trace('check_details_rec.consolidation_set_name ' || check_details_rec.consolidation_set_name);
228: hr_utility.trace('check_details_rec.start_date ' || fnd_date.date_to_canonical(check_details_rec.start_date));
229: hr_utility.trace('p_end_date ' || p_end_date);

Line 226: hr_utility.trace('========================================');

222: commit;
223:
224:
225: hr_utility.trace('Details for submitting the check writer');
226: hr_utility.trace('========================================');
227: hr_utility.trace('check_details_rec.consolidation_set_name ' || check_details_rec.consolidation_set_name);
228: hr_utility.trace('check_details_rec.start_date ' || fnd_date.date_to_canonical(check_details_rec.start_date));
229: hr_utility.trace('p_end_date ' || p_end_date);
230: hr_utility.trace('l_sort_sequence ' || l_sort_sequence);

Line 227: hr_utility.trace('check_details_rec.consolidation_set_name ' || check_details_rec.consolidation_set_name);

223:
224:
225: hr_utility.trace('Details for submitting the check writer');
226: hr_utility.trace('========================================');
227: hr_utility.trace('check_details_rec.consolidation_set_name ' || check_details_rec.consolidation_set_name);
228: hr_utility.trace('check_details_rec.start_date ' || fnd_date.date_to_canonical(check_details_rec.start_date));
229: hr_utility.trace('p_end_date ' || p_end_date);
230: hr_utility.trace('l_sort_sequence ' || l_sort_sequence);
231: hr_utility.trace('l_check_style ' || l_check_style);

Line 228: hr_utility.trace('check_details_rec.start_date ' || fnd_date.date_to_canonical(check_details_rec.start_date));

224:
225: hr_utility.trace('Details for submitting the check writer');
226: hr_utility.trace('========================================');
227: hr_utility.trace('check_details_rec.consolidation_set_name ' || check_details_rec.consolidation_set_name);
228: hr_utility.trace('check_details_rec.start_date ' || fnd_date.date_to_canonical(check_details_rec.start_date));
229: hr_utility.trace('p_end_date ' || p_end_date);
230: hr_utility.trace('l_sort_sequence ' || l_sort_sequence);
231: hr_utility.trace('l_check_style ' || l_check_style);
232: hr_utility.trace('new check number ' || p_start_check_number);

Line 229: hr_utility.trace('p_end_date ' || p_end_date);

225: hr_utility.trace('Details for submitting the check writer');
226: hr_utility.trace('========================================');
227: hr_utility.trace('check_details_rec.consolidation_set_name ' || check_details_rec.consolidation_set_name);
228: hr_utility.trace('check_details_rec.start_date ' || fnd_date.date_to_canonical(check_details_rec.start_date));
229: hr_utility.trace('p_end_date ' || p_end_date);
230: hr_utility.trace('l_sort_sequence ' || l_sort_sequence);
231: hr_utility.trace('l_check_style ' || l_check_style);
232: hr_utility.trace('new check number ' || p_start_check_number);
233: hr_utility.trace('p_overriding_check_date ' || p_overriding_check_date);

Line 230: hr_utility.trace('l_sort_sequence ' || l_sort_sequence);

226: hr_utility.trace('========================================');
227: hr_utility.trace('check_details_rec.consolidation_set_name ' || check_details_rec.consolidation_set_name);
228: hr_utility.trace('check_details_rec.start_date ' || fnd_date.date_to_canonical(check_details_rec.start_date));
229: hr_utility.trace('p_end_date ' || p_end_date);
230: hr_utility.trace('l_sort_sequence ' || l_sort_sequence);
231: hr_utility.trace('l_check_style ' || l_check_style);
232: hr_utility.trace('new check number ' || p_start_check_number);
233: hr_utility.trace('p_overriding_check_date ' || p_overriding_check_date);
234: hr_utility.trace('Assignment Set ' || l_asg_set_id);

Line 231: hr_utility.trace('l_check_style ' || l_check_style);

227: hr_utility.trace('check_details_rec.consolidation_set_name ' || check_details_rec.consolidation_set_name);
228: hr_utility.trace('check_details_rec.start_date ' || fnd_date.date_to_canonical(check_details_rec.start_date));
229: hr_utility.trace('p_end_date ' || p_end_date);
230: hr_utility.trace('l_sort_sequence ' || l_sort_sequence);
231: hr_utility.trace('l_check_style ' || l_check_style);
232: hr_utility.trace('new check number ' || p_start_check_number);
233: hr_utility.trace('p_overriding_check_date ' || p_overriding_check_date);
234: hr_utility.trace('Assignment Set ' || l_asg_set_id);
235: hr_utility.trace('========================================');

Line 232: hr_utility.trace('new check number ' || p_start_check_number);

228: hr_utility.trace('check_details_rec.start_date ' || fnd_date.date_to_canonical(check_details_rec.start_date));
229: hr_utility.trace('p_end_date ' || p_end_date);
230: hr_utility.trace('l_sort_sequence ' || l_sort_sequence);
231: hr_utility.trace('l_check_style ' || l_check_style);
232: hr_utility.trace('new check number ' || p_start_check_number);
233: hr_utility.trace('p_overriding_check_date ' || p_overriding_check_date);
234: hr_utility.trace('Assignment Set ' || l_asg_set_id);
235: hr_utility.trace('========================================');
236: hr_utility.trace('check_details_rec.payroll_name ' || check_details_rec.payroll_name);

Line 233: hr_utility.trace('p_overriding_check_date ' || p_overriding_check_date);

229: hr_utility.trace('p_end_date ' || p_end_date);
230: hr_utility.trace('l_sort_sequence ' || l_sort_sequence);
231: hr_utility.trace('l_check_style ' || l_check_style);
232: hr_utility.trace('new check number ' || p_start_check_number);
233: hr_utility.trace('p_overriding_check_date ' || p_overriding_check_date);
234: hr_utility.trace('Assignment Set ' || l_asg_set_id);
235: hr_utility.trace('========================================');
236: hr_utility.trace('check_details_rec.payroll_name ' || check_details_rec.payroll_name);
237:

Line 234: hr_utility.trace('Assignment Set ' || l_asg_set_id);

230: hr_utility.trace('l_sort_sequence ' || l_sort_sequence);
231: hr_utility.trace('l_check_style ' || l_check_style);
232: hr_utility.trace('new check number ' || p_start_check_number);
233: hr_utility.trace('p_overriding_check_date ' || p_overriding_check_date);
234: hr_utility.trace('Assignment Set ' || l_asg_set_id);
235: hr_utility.trace('========================================');
236: hr_utility.trace('check_details_rec.payroll_name ' || check_details_rec.payroll_name);
237:
238:

Line 235: hr_utility.trace('========================================');

231: hr_utility.trace('l_check_style ' || l_check_style);
232: hr_utility.trace('new check number ' || p_start_check_number);
233: hr_utility.trace('p_overriding_check_date ' || p_overriding_check_date);
234: hr_utility.trace('Assignment Set ' || l_asg_set_id);
235: hr_utility.trace('========================================');
236: hr_utility.trace('check_details_rec.payroll_name ' || check_details_rec.payroll_name);
237:
238:
239: -- Derive the values before

Line 236: hr_utility.trace('check_details_rec.payroll_name ' || check_details_rec.payroll_name);

232: hr_utility.trace('new check number ' || p_start_check_number);
233: hr_utility.trace('p_overriding_check_date ' || p_overriding_check_date);
234: hr_utility.trace('Assignment Set ' || l_asg_set_id);
235: hr_utility.trace('========================================');
236: hr_utility.trace('check_details_rec.payroll_name ' || check_details_rec.payroll_name);
237:
238:
239: -- Derive the values before
240: -- use this for date conversion

Line 268: hr_utility.set_location(l_proc, 70);

264: argument14 => l_asg_set_id, -- Assignment Set,
265: argument15 => 'CHQVNR' -- tell cheque writer its being called from VnR
266: );
267:
268: hr_utility.set_location(l_proc, 70);
269:
270: commit;
271:
272: -- As we will wait for the request to get completed, insert the child request

Line 278: hr_utility.trace('Submitted request with ' || l_request_id);

274:
275: pay_flow_requests_pkg.insert_child_request(p_check_assignment_action,
276: l_request_id);
277:
278: hr_utility.trace('Submitted request with ' || l_request_id);
279:
280: -- Wait for this concurrent request to finish
281: l_wait_outcome := fnd_concurrent.wait_for_request(
282: request_id => l_request_id,

Line 292: hr_utility.set_location(l_proc, 80);

288: message => l_message);
289:
290: p_srs_request_id := l_request_id;
291:
292: hr_utility.set_location(l_proc, 80);
293:
294: /*
295: -- Get the payroll action for the check writer and update the assignment_set_id to null
296: open c_get_payrl_action(p_start_check_number);

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

314: HR_ASSIGNMENT_SETS_PKG.delete_row(p_asg_set_rowid); */
315:
316: commit;
317:
318: hr_utility.set_location('Leaving: '||l_proc, 90);
319:
320: exception
321: when others then
322: p_srs_request_id := -1;

Line 364: hr_utility.set_location('Entering: '||l_proc, 5);

360: --
361: BEGIN
362: --
363:
364: hr_utility.set_location('Entering: '||l_proc, 5);
365:
366: l_request_id := 0;
367:
368: -- if group 1

Line 374: hr_utility.set_location(l_proc, 10);

370: -- Assign all the relevant SRS params
371:
372: IF p_group_id = 1 THEN
373:
374: hr_utility.set_location(l_proc, 10);
375:
376: select ppa.payroll_action_id, paa.serial_number
377: into l_payroll_action_id, l_start_cheque_number
378: from pay_payroll_actions ppa, pay_assignment_actions paa

Line 384: hr_utility.set_location(l_proc, 21);

380: and paa.assignment_action_id = p_check_assignment_action;
381:
382: END IF;
383:
384: hr_utility.set_location(l_proc, 21);
385:
386: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_format);
387: if l_format is not null then
388: hr_utility.trace(l_format);

Line 388: hr_utility.trace(l_format);

384: hr_utility.set_location(l_proc, 21);
385:
386: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_format);
387: if l_format is not null then
388: hr_utility.trace(l_format);
389: else
390: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');
391: l_format := 'DD-MM-YYYY';
392: end if;

Line 390: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');

386: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_format);
387: if l_format is not null then
388: hr_utility.trace(l_format);
389: else
390: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');
391: l_format := 'DD-MM-YYYY';
392: end if;
393:
394:

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

405: argument4 => to_number(l_start_cheque_number,'9999999999999999'), -- Start Check Number
406: argument5 => to_number(l_start_cheque_number,'9999999999999999') -- End check number
407: );
408:
409: hr_utility.set_location(l_proc, 30);
410:
411: p_srs_request_id := l_request_id;
412:
413: commit;

Line 415: hr_utility.set_location('Leaving: '||l_proc, 40);

411: p_srs_request_id := l_request_id;
412:
413: commit;
414:
415: hr_utility.set_location('Leaving: '||l_proc, 40);
416:
417: exception
418: when others then
419: p_srs_request_id := -1;

Line 461: hr_utility.set_location('Entering: '||l_proc, 5);

457: l_format varchar2(100);
458: --
459: begin
460:
461: hr_utility.set_location('Entering: '||l_proc, 5);
462:
463: l_request_id := 0;
464:
465: IF p_group_id = 1 THEN

Line 467: hr_utility.set_location(l_proc, 10);

463: l_request_id := 0;
464:
465: IF p_group_id = 1 THEN
466:
467: hr_utility.set_location(l_proc, 10);
468:
469: select distinct(paa.assignment_action_id),ppa.payroll_id,
470: paa.assignment_id, ppp.pre_payment_id, paa2.serial_number
471: into l_prepayment_asg_action, l_payroll_id, l_assignment_id,

Line 489: hr_utility.trace(l_format);

485: END IF;
486:
487: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_format);
488: if l_format is not null then
489: hr_utility.trace(l_format);
490: else
491: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');
492: l_format := 'DD-MM-YYYY';
493: end if;

Line 491: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');

487: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_format);
488: if l_format is not null then
489: hr_utility.trace(l_format);
490: else
491: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');
492: l_format := 'DD-MM-YYYY';
493: end if;
494:
495: hr_utility.set_location(l_proc, 20);

Line 495: hr_utility.set_location(l_proc, 20);

491: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');
492: l_format := 'DD-MM-YYYY';
493: end if;
494:
495: hr_utility.set_location(l_proc, 20);
496:
497:
498: l_request_id := fnd_request.submit_request (
499: application => 'PAY',

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

510: argument7 => l_pre_payment_id, -- pre payment id
511: argument8 => p_reason -- reason
512: );
513:
514: hr_utility.set_location(l_proc, 30);
515:
516: p_srs_request_id := l_request_id;
517: commit;
518:

Line 519: hr_utility.set_location('Leaving: '||l_proc, 40);

515:
516: p_srs_request_id := l_request_id;
517: commit;
518:
519: hr_utility.set_location('Leaving: '||l_proc, 40);
520:
521: exception
522: when others then
523: p_srs_request_id := -1;

Line 578: hr_utility.set_location('Entering: '||l_proc, 5);

574: l_format varchar2(100);
575: --
576: BEGIN
577:
578: hr_utility.set_location('Entering: '||l_proc, 5);
579:
580: l_request_id := 0;
581: l_already_ran := 'N';
582:

Line 593: hr_utility.trace(l_format);

589: dbms_lock.sleep(5*l_temp);
590:
591: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_format);
592: if l_format is not null then
593: hr_utility.trace(l_format);
594: else
595: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');
596: l_format := 'DD-MM-YYYY';
597: end if;

Line 595: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');

591: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_format);
592: if l_format is not null then
593: hr_utility.trace(l_format);
594: else
595: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');
596: l_format := 'DD-MM-YYYY';
597: end if;
598:
599:

Line 606: hr_utility.set_location(l_proc, 10);

602: open get_pay_run_asg_action(p_check_assignment_action);
603: fetch get_pay_run_asg_action into l_payroll_run_asg_action;
604: close get_pay_run_asg_action ;
605:
606: hr_utility.set_location(l_proc, 10);
607:
608: select ppa.payroll_id, ppa.consolidation_set_id,
609: papf.business_group_id,
610: ppa.action_type, ppa.action_status,

Line 624: hr_utility.set_location(l_proc, 20);

620: papf.effective_end_date;
621:
622: END IF;
623:
624: hr_utility.set_location(l_proc, 20);
625:
626: -- check if reversal is already run for this payroll action
627: -- typically happens when multiple cheque payments are attached to a single employee
628: begin

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

656: argument6 => payroll_action_rec.action_status, -- action_status
657: argument7 => fnd_date.date_to_canonical(to_date(p_effective_date,l_format)), -- effective_date
658: argument8 => l_payroll_run_asg_action -- assignment_action_id for payroll run
659: );
660: hr_utility.set_location(l_proc, 30);
661: end if;
662:
663: p_srs_request_id := l_request_id;
664:

Line 667: hr_utility.set_location('Leaving: '||l_proc, 40);

663: p_srs_request_id := l_request_id;
664:
665: commit;
666:
667: hr_utility.set_location('Leaving: '||l_proc, 40);
668:
669: exception
670: when others then
671: p_srs_request_id := -1;