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) 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 668: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',10);

664: --
665: --
666: begin
667: --
668: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',10);
669: --
670: open csr_asg_act;
671: fetch csr_asg_act into l_rec;
672: close csr_asg_act;

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

670: open csr_asg_act;
671: fetch csr_asg_act into l_rec;
672: close csr_asg_act;
673: --
674: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',20);
675: --
676: if l_rec.batch_status = 'T' then
677: --
678: undo_mix(

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

684: p_assignment_id => l_rec.assignment_id,
685: p_asg_action_id => p_asg_action_id
686: );
687: --
688: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',30);
689: --
690: -- Now check o see if the batch lines have been changed. If so
691: -- then reset the control totals.
692: open csr_reset_control_total(l_rec.batch_id);

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

693: fetch csr_reset_control_total into l_rec_exists;
694: --
695: if csr_reset_control_total%found then
696: --
697: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',40);
698: --
699: for l_ctl_rec in csr_control_lines(l_rec.batch_id) loop
700: purge_rollback_messages(l_ctl_rec.batch_control_id,'C');
701: end loop;

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

712: close csr_reset_control_total;
713: --
714: end if;
715: --
716: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix_asg',50);
717: --
718: end;
719:
720: --

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

750: --
751: --
752: begin
753: --
754: hr_utility.set_location('pay_mix_rollback_pkg.set_status',10);
755: --
756: open csr_asg_act;
757: fetch csr_asg_act into l_rec;
758: -- IF batch doesn't exists thenno need to reset the batch status.

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

762: end if;
763: --
764: close csr_asg_act;
765: --
766: hr_utility.set_location('pay_mix_rollback_pkg.set_status',20);
767: --
768: -- Only purge the batch if the payroll action is purged.
769: if (l_rec.purge_after_rollback = 'Y' and l_rec.BATCH_PROCESS_MODE = 'TRANSFER') then
770: -- Purge the batch regarless of the status of the leave_row flag.

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

769: if (l_rec.purge_after_rollback = 'Y' and l_rec.BATCH_PROCESS_MODE = 'TRANSFER') then
770: -- Purge the batch regarless of the status of the leave_row flag.
771: -- and p_leave_row = false) then
772: --
773: hr_utility.set_location('pay_mix_rollback_pkg.set_status',30);
774: --
775: -- The user wants the batch to be deleted from the database.
776: payplnk.run_process(l_errbuf,
777: l_retcode,

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

778: l_rec.business_group_id,
779: 'PURGE',
780: l_rec.batch_id);
781: --
782: hr_utility.set_location('pay_mix_rollback_pkg.set_status',40);
783: --
784: else
785: --
786: hr_utility.set_location('pay_mix_rollback_pkg.set_status',50);

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

782: hr_utility.set_location('pay_mix_rollback_pkg.set_status',40);
783: --
784: else
785: --
786: hr_utility.set_location('pay_mix_rollback_pkg.set_status',50);
787: -- Change batch header status to 'unprocessed'
788: --
789: purge_rollback_messages(l_rec.batch_id,'H');
790: --

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

791: update pay_batch_headers
792: set batch_status = 'U'
793: where batch_id = l_rec.batch_id;
794: --
795: hr_utility.set_location('pay_mix_rollback_pkg.set_status',60);
796: --
797: end if;
798: --
799: hr_utility.set_location('pay_mix_rollback_pkg.set_status',70);

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

795: hr_utility.set_location('pay_mix_rollback_pkg.set_status',60);
796: --
797: end if;
798: --
799: hr_utility.set_location('pay_mix_rollback_pkg.set_status',70);
800: --
801: end;
802:
803:

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

813:
814: begin
815:
816: begin
817: hr_utility.set_location('pay_mix_rollback_pkg.run_results_exist',10);
818:
819: if p_chk_rollback_upd = 'Y' then
820: select 'Y' into l_results_found
821: from pay_run_results prr,

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

869: l_line_text pay_message_lines.line_text%type;
870: l_payroll_id number;
871:
872: begin
873: hr_utility.set_location('pay_mix_rollback_pkg.insert_rollback_message',10);
874:
875: if p_level = 'H' then -- error occurred at header level
876:
877: l_line_text := substrb(hr_utility.get_message, 1, 240);

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

873: hr_utility.set_location('pay_mix_rollback_pkg.insert_rollback_message',10);
874:
875: if p_level = 'H' then -- error occurred at header level
876:
877: l_line_text := substrb(hr_utility.get_message, 1, 240);
878:
879: elsif p_level = 'L' then -- error occurred at line level
880:
881: l_line_text := substrb(hr_utility.get_message, 1, 240);

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

877: l_line_text := substrb(hr_utility.get_message, 1, 240);
878:
879: elsif p_level = 'L' then -- error occurred at line level
880:
881: l_line_text := substrb(hr_utility.get_message, 1, 240);
882:
883: end if;
884:
885: -- Store the message information in PL/SQL tables for committing at the end of the process.

Line 894: hr_utility.raise_error;

890:
891: if p_fail then
892:
893: -- Stop the process now.
894: hr_utility.raise_error;
895:
896: end if;
897:
898: end insert_rollback_message;

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

909: param_value pay_action_parameters.parameter_value%type;
910:
911: begin
912: begin
913: hr_utility.set_location('pay_mix_rollback_pkg.action_parameter',10);
914:
915: -- attempt to find value of the parameter in the action parameter table.
916: select par.parameter_value
917: into param_value

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

940:
941: i number;
942:
943: begin
944: hr_utility.set_location('pay_mix_rollback_pkg.commit_messages',10);
945:
946: for i in 1..g_message_count loop
947: if g_message_tbl(i) is not null and g_message_id_tbl(i) is not null then
948: insert into pay_message_lines(

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

971: --
972: -- commit;
973: --
974:
975: hr_utility.set_location('pay_mix_rollback_pkg.commit_messages',20);
976:
977: end commit_messages;
978:
979: --

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

982:
983: procedure purge_rollback_messages(p_source_id in number, p_msg_type varchar2) is
984:
985: begin
986: hr_utility.set_location('pay_mix_rollback_pkg.purge_rollback_messages',10);
987:
988: delete from pay_message_lines
989: where source_id = p_source_id
990: and source_type = p_msg_type;