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.PER_FORMULA_FUNCTIONS dependencies on HR_UTILITY

Line 337: hr_utility.set_location(l_proc, 5);

333: --
334:
335: begin
336: --
337: hr_utility.set_location(l_proc, 5);
338:
339:
340: -- Get the formula ID from a a plsql table instead of ff_formulas_f
341: -- to improve performance of batch processes.

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

346: );
347:
348: if l_formula_id = 0 then
349: --
350: hr_utility.set_location(l_proc, 10);
351: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
352: fnd_message.set_token('1', p_formula_name);
353: fnd_message.raise_error;
354: --

Line 383: hr_utility.set_location('Prior to Run Formula '||l_proc, 10);

379: --
380: ----------------------
381: -- Run the formula. --
382: ----------------------
383: hr_utility.set_location('Prior to Run Formula '||l_proc, 10);
384: --
385: per_formula_functions.run_formula (p_formula_id => l_formula_id
386: ,p_calculation_date => p_calculation_date
387: ,p_inputs => l_inputs

Line 392: hr_utility.set_location('Run Formula Complete '||l_proc, 15);

388: ,p_outputs => l_get_outputs);
389:
390: l_continue_loop := l_get_outputs(1).value;
391: --
392: hr_utility.set_location('Run Formula Complete '||l_proc, 15);
393: -------------------------------
394: -- Test the output parameter --
395: -------------------------------
396: if l_continue_loop = 'Y' then

Line 408: hr_utility.set_location('Successful Exit '||l_proc, 20);

404: end loop;
405: --
406: end if;
407:
408: hr_utility.set_location('Successful Exit '||l_proc, 20);
409: return 0;
410: --
411: end loop_control;
412: --

Line 450: hr_utility.set_location('Prior to Run Formula '||l_proc, 10);

446: l_get_outputs(1).name := 'CONTINUE_PROCESSING_FLAG';
447: ----------------------
448: -- Run the formula. --
449: ----------------------
450: hr_utility.set_location('Prior to Run Formula '||l_proc, 10);
451: --
452: per_formula_functions.run_formula (p_formula_name => p_formula_name
453: ,p_business_group_id => p_business_group_id
454: ,p_calculation_date => p_calculation_date

Line 457: hr_utility.set_location('Run Formula Complete '||l_proc, 15);

453: ,p_business_group_id => p_business_group_id
454: ,p_calculation_date => p_calculation_date
455: ,p_inputs => l_inputs
456: ,p_outputs => l_get_outputs);
457: hr_utility.set_location('Run Formula Complete '||l_proc, 15);
458: return 0;
459: end call_formula;
460: --
461: /* =====================================================================

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

476: l_formula_id number;
477:
478: begin
479:
480: hr_utility.set_location('Entering '||l_proc, 5);
481: --
482: ------------------------
483: -- Get the formula id --
484: ------------------------

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

491: p_calculation_date => p_calculation_date
492: );
493:
494: if l_formula_id = 0 then
495: hr_utility.set_location(l_proc, 10);
496: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
497: fnd_message.set_token('1', p_formula_name);
498: fnd_message.raise_error;
499: else

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

531: l_outputs ff_exec.outputs_t;
532: --
533: begin
534:
535: hr_utility.set_location('Entering '||l_proc, 5);
536:
537: -- Cache this formula. The purpose of this is to fetch the formula name
538: -- (if the formula does not exist or is not compiled it is listed in the
539: -- error message). It is cached to prevent frequent hits on ff_formulas_f

Line 547: hr_utility.set_location(l_proc, 8);

543: p_calculation_date => p_calculation_date
544: );
545: if l_formula_name is null then
546:
547: hr_utility.set_location(l_proc, 8);
548:
549: open csr_get_ff_name;
550: fetch csr_get_ff_name into l_formula_name;
551: close csr_get_ff_name;

Line 563: hr_utility.set_location('Handle inputs '||l_proc, 10);

559: -- Initialize the formula --
560: ----------------------------
561: ff_exec.init_formula(p_formula_id, p_calculation_date, l_inputs, l_outputs);
562: --
563: hr_utility.set_location('Handle inputs '||l_proc, 10);
564: -----------------------------
565: -- Set up the input values --
566: -----------------------------
567: if l_inputs.count > 0 and p_inputs.count > 0 then

Line 578: hr_utility.set_location('Run Formula '||l_proc, 15);

574: end loop;
575: end loop;
576: end if;
577: --
578: hr_utility.set_location('Run Formula '||l_proc, 15);
579: ---------------------
580: -- Run the formula --
581: ---------------------
582: ff_exec.run_formula(l_inputs,l_outputs);

Line 584: hr_utility.set_location('Handle outputs '||l_proc, 20);

580: -- Run the formula --
581: ---------------------
582: ff_exec.run_formula(l_inputs,l_outputs);
583: --
584: hr_utility.set_location('Handle outputs '||l_proc, 20);
585: -------------------------------
586: -- Populate the output table --
587: -------------------------------
588: if l_outputs.count > 0 and p_inputs.count > 0 then

Line 603: hr_utility.set_location(l_proc, 98);

599: end if;
600:
601: exception
602: when hr_formula_error then
603: hr_utility.set_location(l_proc, 98);
604: hr_utility.set_message(hr_formula_application_id,hr_formula_message);
605: hr_utility.raise_error;
606: when others then
607: hr_utility.set_location(l_proc, 99);

Line 604: hr_utility.set_message(hr_formula_application_id,hr_formula_message);

600:
601: exception
602: when hr_formula_error then
603: hr_utility.set_location(l_proc, 98);
604: hr_utility.set_message(hr_formula_application_id,hr_formula_message);
605: hr_utility.raise_error;
606: when others then
607: hr_utility.set_location(l_proc, 99);
608: raise;

Line 605: hr_utility.raise_error;

601: exception
602: when hr_formula_error then
603: hr_utility.set_location(l_proc, 98);
604: hr_utility.set_message(hr_formula_application_id,hr_formula_message);
605: hr_utility.raise_error;
606: when others then
607: hr_utility.set_location(l_proc, 99);
608: raise;
609: end run_formula;

Line 607: hr_utility.set_location(l_proc, 99);

603: hr_utility.set_location(l_proc, 98);
604: hr_utility.set_message(hr_formula_application_id,hr_formula_message);
605: hr_utility.raise_error;
606: when others then
607: hr_utility.set_location(l_proc, 99);
608: raise;
609: end run_formula;
610: --
611: /* =====================================================================

Line 622: hr_utility.set_location(l_proc, 1);

618: --
619: l_proc varchar2(72) := g_package||'get_number';
620: --
621: begin
622: hr_utility.set_location(l_proc, 1);
623:
624: if global_number.count>0 then
625: --
626: for i in global_number.first..global_number.last loop

Line 628: hr_utility.set_location(

624: if global_number.count>0 then
625: --
626: for i in global_number.first..global_number.last loop
627: if global_number(i).name = p_name then
628: hr_utility.set_location(
629: p_name||'='||global_number(i).value||' '||l_proc, 5);
630: return global_number(i).value;
631: end if;
632: end loop;

Line 636: hr_utility.set_location(p_name||' Not Found '||l_proc, 10);

632: end loop;
633: --
634: end if;
635:
636: hr_utility.set_location(p_name||' Not Found '||l_proc, 10);
637: return null;
638: end get_number;
639: --
640: /* =====================================================================

Line 653: hr_utility.set_location(

649: l_proc varchar2(72) := g_package||'set_number';
650: j number;
651: --
652: begin
653: hr_utility.set_location(
654: 'Setting '||p_name||'='||to_char(p_value)||' '||l_proc, 5);
655: j := 0;
656: if global_number.count > 0 then
657: for i in global_number.first..global_number.last loop

Line 670: hr_utility.set_location('Error '||l_proc, 10);

666: global_number(j).value := p_value;
667: return 0;
668: exception
669: when others then
670: hr_utility.set_location('Error '||l_proc, 10);
671: return 1;
672: end set_number;
673: /* =====================================================================
674: Name : get_date

Line 685: hr_utility.set_location(l_proc, 1);

681: l_proc varchar2(72) := g_package||'get_date';
682: --
683: begin
684: --
685: hr_utility.set_location(l_proc, 1);
686:
687: if global_date.count>0 then
688: --
689: for i in global_date.first..global_date.last loop

Line 691: hr_utility.set_location(

687: if global_date.count>0 then
688: --
689: for i in global_date.first..global_date.last loop
690: if global_date(i).name = p_name then
691: hr_utility.set_location(
692: p_name||'='||global_date(i).value||' '||l_proc, 5);
693: return global_date(i).value;
694: end if;
695: end loop;

Line 699: hr_utility.set_location(p_name||' Not Found '||l_proc, 10);

695: end loop;
696: --
697: end if;
698: --
699: hr_utility.set_location(p_name||' Not Found '||l_proc, 10);
700: return null;
701: end get_date;
702: --
703: /* =====================================================================

Line 716: hr_utility.set_location(

712: l_proc varchar2(72) := g_package||'set_date';
713: --
714: j number;
715: begin
716: hr_utility.set_location(
717: 'Setting '||p_name||'='||to_char(p_value,'DD-MM-YYYY')||' '||l_proc, 5);
718: j := 0;
719: if global_date.count > 0 then
720: for i in global_date.first..global_date.last loop

Line 733: hr_utility.set_location('Error '||l_proc, 10);

729: global_date(j).value := p_value;
730: return 0;
731: exception
732: when others then
733: hr_utility.set_location('Error '||l_proc, 10);
734: return 1;
735: end set_date;
736: --
737: /* =====================================================================

Line 749: hr_utility.set_location(l_proc, 1);

745: l_proc varchar2(72) := g_package||'get_text';
746: --
747: begin
748:
749: hr_utility.set_location(l_proc, 1);
750:
751: if global_text.count>0 then
752: --
753: for i in global_text.first..global_text.last loop

Line 755: hr_utility.set_location(

751: if global_text.count>0 then
752: --
753: for i in global_text.first..global_text.last loop
754: if global_text(i).name = p_name then
755: hr_utility.set_location(
756: p_name||'='||global_text(i).value||' '||l_proc, 5);
757: return global_text(i).value;
758: end if;
759: end loop;

Line 763: hr_utility.set_location(p_name||' Not Found '||l_proc, 10);

759: end loop;
760: --
761: end if;
762:
763: hr_utility.set_location(p_name||' Not Found '||l_proc, 10);
764: return null;
765: end get_text;
766: --
767: /* =====================================================================

Line 780: hr_utility.set_location(

776: l_proc varchar2(72) := g_package||'set_text';
777: --
778: j number;
779: begin
780: hr_utility.set_location(
781: 'Setting '||p_name||'='||p_value||' '||l_proc, 5);
782: j := 0;
783: if global_text.count > 0 then
784: for i in global_text.first..global_text.last loop

Line 797: hr_utility.set_location('Error '||l_proc, 10);

793: global_text(j).value := p_value;
794: return 0;
795: exception
796: when others then
797: hr_utility.set_location('Error '||l_proc, 10);
798: return 1;
799: end set_text;
800: --
801: /* =====================================================================

Line 849: hr_utility.set_location(l_proc, 5);

845: init_global_date global_date_t;
846: init_global_text global_text_t;
847: --
848: begin
849: hr_utility.set_location(l_proc, 5);
850: global_number := init_global_number;
851: global_date := init_global_date;
852: global_text := init_global_text;
853: return 0;

Line 856: hr_utility.set_location('Error '||l_proc, 10);

852: global_text := init_global_text;
853: return 0;
854: exception
855: when others then
856: hr_utility.set_location('Error '||l_proc, 10);
857: return 1;
858: end remove_globals;
859: --
860: /* =====================================================================

Line 871: hr_utility.set_location('Clearing Numeric Globals '||l_proc, 5);

867: l_proc varchar2(72) := g_package||'clear_globals';
868: --
869: j number;
870: begin
871: hr_utility.set_location('Clearing Numeric Globals '||l_proc, 5);
872: j := 0;
873: if global_number.count > 0 then
874: for i in global_number.first..global_number.last loop
875: j := j + 1;

Line 880: hr_utility.set_location('Clearing Date Globals '||l_proc, 10);

876: global_number(i).value := null;
877: end loop;
878: end if;
879: --
880: hr_utility.set_location('Clearing Date Globals '||l_proc, 10);
881: j := 0;
882: if global_date.count > 0 then
883: for i in global_date.first..global_date.last loop
884: j := j + 1;

Line 889: hr_utility.set_location('Clearing Text Globals '||l_proc, 15);

885: global_date(i).value := null;
886: end loop;
887: end if;
888: --
889: hr_utility.set_location('Clearing Text Globals '||l_proc, 15);
890: j := 0;
891: if global_text.count > 0 then
892: for i in global_text.first..global_text.last loop
893: j := j + 1;

Line 901: hr_utility.set_location('Error '||l_proc, 10);

897: --
898: return 0;
899: exception
900: when others then
901: hr_utility.set_location('Error '||l_proc, 10);
902: return 1;
903: end clear_globals;
904: --
905: /* =====================================================================

Line 915: hr_utility.set_location(l_proc, 5);

911: --
912: l_proc varchar2(72) := g_package||'debug';
913: --
914: begin
915: hr_utility.set_location(l_proc, 5);
916: -- Bug#885806
917: -- dbms_output.put_line(p_message);
918: hr_utility.trace(p_message);
919: hr_utility.set_location(l_proc, 10);

Line 918: hr_utility.trace(p_message);

914: begin
915: hr_utility.set_location(l_proc, 5);
916: -- Bug#885806
917: -- dbms_output.put_line(p_message);
918: hr_utility.trace(p_message);
919: hr_utility.set_location(l_proc, 10);
920: return 0;
921: exception
922: when others then

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

915: hr_utility.set_location(l_proc, 5);
916: -- Bug#885806
917: -- dbms_output.put_line(p_message);
918: hr_utility.trace(p_message);
919: hr_utility.set_location(l_proc, 10);
920: return 0;
921: exception
922: when others then
923: hr_utility.set_location('Error '||l_proc, 10);

Line 923: hr_utility.set_location('Error '||l_proc, 10);

919: hr_utility.set_location(l_proc, 10);
920: return 0;
921: exception
922: when others then
923: hr_utility.set_location('Error '||l_proc, 10);
924: return 1;
925: end debug;
926: --
927: /* =====================================================================

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

935: --
936: l_proc varchar2(72) := g_package||'raise_error';
937: --
938: begin
939: hr_utility.set_location(l_proc, 10);
940: hr_formula_application_id := p_application_id;
941: hr_formula_message := p_message_name;
942: -- Start of 3294192
943: --raise hr_formula_error;

Line 944: hr_utility.set_message(p_application_id, p_message_name);

940: hr_formula_application_id := p_application_id;
941: hr_formula_message := p_message_name;
942: -- Start of 3294192
943: --raise hr_formula_error;
944: hr_utility.set_message(p_application_id, p_message_name);
945: hr_utility.raise_error;
946: -- End of 3294192
947: return 0;
948: end raise_error;

Line 945: hr_utility.raise_error;

941: hr_formula_message := p_message_name;
942: -- Start of 3294192
943: --raise hr_formula_error;
944: hr_utility.set_message(p_application_id, p_message_name);
945: hr_utility.raise_error;
946: -- End of 3294192
947: return 0;
948: end raise_error;
949: --