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

Line 240: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix',10);

236: l_entry_exists varchar2(1) := 'N';
237:
238: begin
239:
240: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix',10);
241:
242: --
243: if p_asg_action_id is null then
244: l_payroll_action_id := null;

Line 261: hr_utility.raise_error;

257: open csr_payroll_action_exists;
258: fetch csr_payroll_action_exists into l_payroll_action_id,l_business_group_id;
259: if ( l_request_id = 0 or (csr_payroll_action_exists%found and p_reject_if_run_results_exist <> 'Y')) then
260: close csr_payroll_action_exists;
261: hr_utility.raise_error;
262: end if;
263: close csr_payroll_action_exists;
264:
265: return;

Line 280: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix',20);

276:
277: begin
278:
279: -- Ensure batch is valid for rollback
280: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix',20);
281:
282: select 'Y'
283: into l_check_batch_id
284: from pay_batch_headers

Line 289: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix',30);

285: where batch_id = p_batch_header_id
286: and batch_status = 'T';
287:
288: -- Get business_group_id
289: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix',30);
290:
291: select business_group_id,
292: nvl(REJECT_ENTRY_NOT_REMOVED,'N'),
293: nvl(ROLLBACK_ENTRY_UPDATES,'N'),

Line 315: hr_utility.set_message(800,'HR_289717_BEE_CANNOT_ROLLBACK');

311: fetch csr_pay_act_exists into l_pay_act_exists;
312: if csr_pay_act_exists%found and p_asg_action_id is null then
313: --
314: close csr_pay_act_exists;
315: hr_utility.set_message(800,'HR_289717_BEE_CANNOT_ROLLBACK');
316: hr_utility.raise_error;
317: --
318: end if;
319: close csr_pay_act_exists;

Line 316: hr_utility.raise_error;

312: if csr_pay_act_exists%found and p_asg_action_id is null then
313: --
314: close csr_pay_act_exists;
315: hr_utility.set_message(800,'HR_289717_BEE_CANNOT_ROLLBACK');
316: hr_utility.raise_error;
317: --
318: end if;
319: close csr_pay_act_exists;
320: --

Line 329: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix',40);

325: purge_rollback_messages(p_batch_header_id,'H');
326: end if;
327:
328: if (l_check_batch_id = 'Y') or (l_check_batch_id = 'N' and p_asg_action_id is not null) then
329: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix',40);
330:
331: open c_batch_lines;
332: fetch c_batch_lines into l_batch_line;
333:

Line 412: hr_utility.set_message(801,'PAY_52014_RUN_RESULTS_EXIST');

408: -- insert_rollback_message('L', l_batch_line.batch_line_id, 'I', false);
409: --
410: -- end if;
411: g_message_count := g_message_count + 1;
412: hr_utility.set_message(801,'PAY_52014_RUN_RESULTS_EXIST');
413: insert_rollback_message('L', l_batch_line.batch_line_id, 'F', false);
414:
415: else
416:

Line 444: hr_utility.set_message(800,'PER_289522_CANNOT_RBK_BEE_LINE');

440: commit_messages;
441: g_message_count := 0;
442: close c_batch_entries;
443: close c_batch_lines;
444: hr_utility.set_message(800,'PER_289522_CANNOT_RBK_BEE_LINE');
445: hr_utility.raise_error;
446: end;
447:
448: -- change batch line status to 'unprocessed'

Line 445: hr_utility.raise_error;

441: g_message_count := 0;
442: close c_batch_entries;
443: close c_batch_lines;
444: hr_utility.set_message(800,'PER_289522_CANNOT_RBK_BEE_LINE');
445: hr_utility.raise_error;
446: end;
447:
448: -- change batch line status to 'unprocessed'
449: --

Line 489: hr_utility.set_message(800,'PER_449031_CANNOT_RBK_BEE_ENR');

485: commit_messages;
486: g_message_count := 0;
487: close c_batch_entries;
488: close c_batch_lines;
489: hr_utility.set_message(800,'PER_449031_CANNOT_RBK_BEE_ENR');
490: hr_utility.raise_error;
491: --
492: end if;
493: end if;

Line 490: hr_utility.raise_error;

486: g_message_count := 0;
487: close c_batch_entries;
488: close c_batch_lines;
489: hr_utility.set_message(800,'PER_449031_CANNOT_RBK_BEE_ENR');
490: hr_utility.raise_error;
491: --
492: end if;
493: end if;
494:

Line 532: hr_utility.set_message(801,'PAY_52013_MIX_ROLLBACK_SUCCESS');

528: p_batch_header_id);
529: --
530: end if;
531: --
532: hr_utility.set_message(801,'PAY_52013_MIX_ROLLBACK_SUCCESS');
533: hr_utility.set_message_token('ASGN_COUNT', l_assignments_processed);
534: g_message_count := g_message_count + 1;
535: insert_rollback_message('H', p_batch_header_id, 'I', false);
536: --

Line 533: hr_utility.set_message_token('ASGN_COUNT', l_assignments_processed);

529: --
530: end if;
531: --
532: hr_utility.set_message(801,'PAY_52013_MIX_ROLLBACK_SUCCESS');
533: hr_utility.set_message_token('ASGN_COUNT', l_assignments_processed);
534: g_message_count := g_message_count + 1;
535: insert_rollback_message('H', p_batch_header_id, 'I', false);
536: --
537: -- commit;

Line 553: hr_utility.set_message(801,'PAY_52013_MIX_ROLLBACK_SUCCESS');

549: for l_ctl_rec in csr_control_lines(p_batch_header_id) loop
550: purge_rollback_messages(l_ctl_rec.batch_control_id,'C');
551: end loop;
552: --
553: hr_utility.set_message(801,'PAY_52013_MIX_ROLLBACK_SUCCESS');
554: hr_utility.set_message_token('ASGN_COUNT', l_assignments_processed);
555: g_message_count := g_message_count + 1;
556: insert_rollback_message('H', p_batch_header_id, 'I', false);
557: --

Line 554: hr_utility.set_message_token('ASGN_COUNT', l_assignments_processed);

550: purge_rollback_messages(l_ctl_rec.batch_control_id,'C');
551: end loop;
552: --
553: hr_utility.set_message(801,'PAY_52013_MIX_ROLLBACK_SUCCESS');
554: hr_utility.set_message_token('ASGN_COUNT', l_assignments_processed);
555: g_message_count := g_message_count + 1;
556: insert_rollback_message('H', p_batch_header_id, 'I', false);
557: --
558: else

Line 569: hr_utility.set_message(801,'PAY_52015_INVALID_BATCH');

565: -- processes.
566: --
567: if p_asg_action_id is null then
568: g_message_count := g_message_count + 1;
569: hr_utility.set_message(801,'PAY_52015_INVALID_BATCH');
570: insert_rollback_message('H', p_batch_header_id, 'F', false);
571: end if;
572: --
573: --

Line 583: hr_utility.set_message(800,'PER_289522_CANNOT_RBK_BEE_LINE');

579: -- Must manually reset global message counter, since concurrent
580: -- manager does not start a new session for PL/SQL stored procedures.
581: g_message_count := 0;
582: --
583: hr_utility.set_message(800,'PER_289522_CANNOT_RBK_BEE_LINE');
584: hr_utility.raise_error;
585: --
586: end if;
587: --

Line 584: hr_utility.raise_error;

580: -- manager does not start a new session for PL/SQL stored procedures.
581: g_message_count := 0;
582: --
583: hr_utility.set_message(800,'PER_289522_CANNOT_RBK_BEE_LINE');
584: hr_utility.raise_error;
585: --
586: end if;
587: --
588: -- Following only applies to previous single threaded BEE

Line 684: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',10);

680: l_parent_id NUMBER := null;
681: --
682: begin
683: --
684: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',10);
685: --
686: open csr_asg_act;
687: fetch csr_asg_act into l_rec;
688: close csr_asg_act;

Line 690: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',20);

686: open csr_asg_act;
687: fetch csr_asg_act into l_rec;
688: close csr_asg_act;
689: --
690: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',20);
691: --
692: if l_rec.batch_status = 'T' then
693: -- For bug 8971846
694: open csr_parent_req_id (fnd_global.conc_request_id);

Line 718: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',30);

714: p_assignment_id => l_rec.assignment_id,
715: p_asg_action_id => p_asg_action_id
716: );
717: --
718: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',30);
719: --
720: -- Now check o see if the batch lines have been changed. If so
721: -- then reset the control totals.
722: open csr_reset_control_total(l_rec.batch_id);

Line 727: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',40);

723: fetch csr_reset_control_total into l_rec_exists;
724: --
725: if csr_reset_control_total%found then
726: --
727: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',40);
728: --
729: for l_ctl_rec in csr_control_lines(l_rec.batch_id) loop
730: purge_rollback_messages(l_ctl_rec.batch_control_id,'C');
731: end loop;

Line 746: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',50);

742: close csr_reset_control_total;
743: --
744: end if;
745: --
746: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',50);
747: --
748: end;
749:
750: --

Line 797: hr_utility.set_location('pay_mix_rollback_pkg.set_status',10);

793: --
794: --
795: begin
796: --
797: hr_utility.set_location('pay_mix_rollback_pkg.set_status',10);
798: --
799: open csr_asg_act;
800: fetch csr_asg_act into l_rec;
801: -- IF batch doesn't exists thenno need to reset the batch status.

Line 829: hr_utility.set_location('pay_mix_rollback_pkg.set_status',20);

825: end if;
826: end if;
827:
828:
829: hr_utility.set_location('pay_mix_rollback_pkg.set_status',20);
830: --
831: -- Only purge the batch if the payroll action is purged.
832: if (l_leave_batch = 'N' and l_rec.BATCH_PROCESS_MODE = 'TRANSFER') then
833: -- Purge the batch regarless of the status of the leave_row flag.

Line 836: hr_utility.set_location('pay_mix_rollback_pkg.set_status',30);

832: if (l_leave_batch = 'N' and l_rec.BATCH_PROCESS_MODE = 'TRANSFER') then
833: -- Purge the batch regarless of the status of the leave_row flag.
834: -- and p_leave_row = false) then
835: --
836: hr_utility.set_location('pay_mix_rollback_pkg.set_status',30);
837: --
838: -- The user wants the batch to be deleted from the database.
839: payplnk.run_process(l_errbuf,
840: l_retcode,

Line 845: hr_utility.set_location('pay_mix_rollback_pkg.set_status',40);

841: l_rec.business_group_id,
842: 'PURGE',
843: l_rec.batch_id);
844: --
845: hr_utility.set_location('pay_mix_rollback_pkg.set_status',40);
846: --
847: else
848: --
849: hr_utility.set_location('pay_mix_rollback_pkg.set_status',50);

Line 849: hr_utility.set_location('pay_mix_rollback_pkg.set_status',50);

845: hr_utility.set_location('pay_mix_rollback_pkg.set_status',40);
846: --
847: else
848: --
849: hr_utility.set_location('pay_mix_rollback_pkg.set_status',50);
850: -- Change batch header status to 'unprocessed'
851: --
852: purge_rollback_messages(l_rec.batch_id,'H');
853: --

Line 858: hr_utility.set_location('pay_mix_rollback_pkg.set_status',60);

854: update pay_batch_headers
855: set batch_status = 'U'
856: where batch_id = l_rec.batch_id;
857: --
858: hr_utility.set_location('pay_mix_rollback_pkg.set_status',60);
859: --
860: end if;
861: --
862: hr_utility.set_location('pay_mix_rollback_pkg.set_status',70);

Line 862: hr_utility.set_location('pay_mix_rollback_pkg.set_status',70);

858: hr_utility.set_location('pay_mix_rollback_pkg.set_status',60);
859: --
860: end if;
861: --
862: hr_utility.set_location('pay_mix_rollback_pkg.set_status',70);
863: --
864: end;
865:
866:

Line 880: hr_utility.set_location('pay_mix_rollback_pkg.run_results_exist',10);

876:
877: begin
878:
879: begin
880: hr_utility.set_location('pay_mix_rollback_pkg.run_results_exist',10);
881:
882: if p_chk_rollback_upd = 'Y' then
883: select 'Y' into l_results_found
884: from pay_run_results prr,

Line 936: hr_utility.set_location('pay_mix_rollback_pkg.insert_rollback_message',10);

932: l_line_text pay_message_lines.line_text%type;
933: l_payroll_id number;
934:
935: begin
936: hr_utility.set_location('pay_mix_rollback_pkg.insert_rollback_message',10);
937:
938: if p_level = 'H' then -- error occurred at header level
939:
940: l_line_text := substrb(hr_utility.get_message, 1, 240);

Line 940: l_line_text := substrb(hr_utility.get_message, 1, 240);

936: hr_utility.set_location('pay_mix_rollback_pkg.insert_rollback_message',10);
937:
938: if p_level = 'H' then -- error occurred at header level
939:
940: l_line_text := substrb(hr_utility.get_message, 1, 240);
941:
942: elsif p_level = 'L' then -- error occurred at line level
943:
944: l_line_text := substrb(hr_utility.get_message, 1, 240);

Line 944: l_line_text := substrb(hr_utility.get_message, 1, 240);

940: l_line_text := substrb(hr_utility.get_message, 1, 240);
941:
942: elsif p_level = 'L' then -- error occurred at line level
943:
944: l_line_text := substrb(hr_utility.get_message, 1, 240);
945:
946: end if;
947:
948: -- Store the message information in PL/SQL tables for committing at the end of the process.

Line 957: hr_utility.raise_error;

953:
954: if p_fail then
955:
956: -- Stop the process now.
957: hr_utility.raise_error;
958:
959: end if;
960:
961: end insert_rollback_message;

Line 976: hr_utility.set_location('pay_mix_rollback_pkg.action_parameter',10);

972: param_value pay_action_parameters.parameter_value%type;
973:
974: begin
975: begin
976: hr_utility.set_location('pay_mix_rollback_pkg.action_parameter',10);
977:
978: -- attempt to find value of the parameter in the action parameter table.
979: select par.parameter_value
980: into param_value

Line 1007: hr_utility.set_location('pay_mix_rollback_pkg.commit_messages',10);

1003:
1004: i number;
1005:
1006: begin
1007: hr_utility.set_location('pay_mix_rollback_pkg.commit_messages',10);
1008:
1009: for i in 1..g_message_count loop
1010: if g_message_tbl(i) is not null and g_message_id_tbl(i) is not null then
1011: insert into pay_message_lines(

Line 1038: hr_utility.set_location('pay_mix_rollback_pkg.commit_messages',20);

1034: --
1035: -- commit;
1036: --
1037:
1038: hr_utility.set_location('pay_mix_rollback_pkg.commit_messages',20);
1039:
1040: end commit_messages;
1041:
1042: --

Line 1049: hr_utility.set_location('pay_mix_rollback_pkg.purge_rollback_messages',10);

1045:
1046: procedure purge_rollback_messages(p_source_id in number, p_msg_type varchar2) is
1047:
1048: begin
1049: hr_utility.set_location('pay_mix_rollback_pkg.purge_rollback_messages',10);
1050:
1051: delete from pay_message_lines
1052: where source_id = p_source_id
1053: and source_type = p_msg_type;