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.BEN_EFC_REPORTING dependencies on HR_EFC_INFO

Line 468: hr_efc_info.insert_line('-- ');

464: l_ent_desc := 'Benefit provider ledger';
465: --
466: end if;
467: --
468: hr_efc_info.insert_line('-- ');
469: hr_efc_info.insert_line('-- '||l_ent_desc||' details ');
470: hr_efc_info.insert_line('-- ');
471: --
472: l_fatal_error_val_set := p_fatal_error_val_set;

Line 469: hr_efc_info.insert_line('-- '||l_ent_desc||' details ');

465: --
466: end if;
467: --
468: hr_efc_info.insert_line('-- ');
469: hr_efc_info.insert_line('-- '||l_ent_desc||' details ');
470: hr_efc_info.insert_line('-- ');
471: --
472: l_fatal_error_val_set := p_fatal_error_val_set;
473: --

Line 470: hr_efc_info.insert_line('-- ');

466: end if;
467: --
468: hr_efc_info.insert_line('-- ');
469: hr_efc_info.insert_line('-- '||l_ent_desc||' details ');
470: hr_efc_info.insert_line('-- ');
471: --
472: l_fatal_error_val_set := p_fatal_error_val_set;
473: --
474: l_rco_count := p_rcoerr_val_set.count;

Line 671: hr_efc_info.insert_line('-- Convertable rows: '||l_tabrow_count);

667: end if;
668: --
669: if p_disp_private then
670: --
671: hr_efc_info.insert_line('-- Convertable rows: '||l_tabrow_count);
672: hr_efc_info.insert_line('-- Converted rows: '||l_conv_count);
673: hr_efc_info.insert_line('-- Adjustable rows: '||l_adjust_count);
674: hr_efc_info.insert_line('-- ');
675: --

Line 672: hr_efc_info.insert_line('-- Converted rows: '||l_conv_count);

668: --
669: if p_disp_private then
670: --
671: hr_efc_info.insert_line('-- Convertable rows: '||l_tabrow_count);
672: hr_efc_info.insert_line('-- Converted rows: '||l_conv_count);
673: hr_efc_info.insert_line('-- Adjustable rows: '||l_adjust_count);
674: hr_efc_info.insert_line('-- ');
675: --
676: end if;

Line 673: hr_efc_info.insert_line('-- Adjustable rows: '||l_adjust_count);

669: if p_disp_private then
670: --
671: hr_efc_info.insert_line('-- Convertable rows: '||l_tabrow_count);
672: hr_efc_info.insert_line('-- Converted rows: '||l_conv_count);
673: hr_efc_info.insert_line('-- Adjustable rows: '||l_adjust_count);
674: hr_efc_info.insert_line('-- ');
675: --
676: end if;
677: --

Line 674: hr_efc_info.insert_line('-- ');

670: --
671: hr_efc_info.insert_line('-- Convertable rows: '||l_tabrow_count);
672: hr_efc_info.insert_line('-- Converted rows: '||l_conv_count);
673: hr_efc_info.insert_line('-- Adjustable rows: '||l_adjust_count);
674: hr_efc_info.insert_line('-- ');
675: --
676: end if;
677: --
678: hr_efc_info.insert_line('-- Successfully Adjusted rows: '||l_succ_count||' '||l_succ_perc||'% ');

Line 678: hr_efc_info.insert_line('-- Successfully Adjusted rows: '||l_succ_count||' '||l_succ_perc||'% ');

674: hr_efc_info.insert_line('-- ');
675: --
676: end if;
677: --
678: hr_efc_info.insert_line('-- Successfully Adjusted rows: '||l_succ_count||' '||l_succ_perc||'% ');
679: --
680: if p_disp_private then
681: --
682: hr_efc_info.insert_line('-- Duplicate Succ rows: '||l_dupsuccval_count);

Line 682: hr_efc_info.insert_line('-- Duplicate Succ rows: '||l_dupsuccval_count);

678: hr_efc_info.insert_line('-- Successfully Adjusted rows: '||l_succ_count||' '||l_succ_perc||'% ');
679: --
680: if p_disp_private then
681: --
682: hr_efc_info.insert_line('-- Duplicate Succ rows: '||l_dupsuccval_count);
683: --
684: end if;
685: --
686: hr_efc_info.insert_line('-- Application errors: '||l_rco_count||' '||l_rco_perc||'% ');

Line 686: hr_efc_info.insert_line('-- Application errors: '||l_rco_count||' '||l_rco_perc||'% ');

682: hr_efc_info.insert_line('-- Duplicate Succ rows: '||l_dupsuccval_count);
683: --
684: end if;
685: --
686: hr_efc_info.insert_line('-- Application errors: '||l_rco_count||' '||l_rco_perc||'% ');
687: hr_efc_info.insert_line('-- Non Excluded failure rows: '||l_fail_count||' '||l_fail_perc||'% ');
688: hr_efc_info.insert_line('-- Exclusion rows: '||l_excl_count||' '||l_excl_perc||'% ');
689: --
690: if p_disp_private then

Line 687: hr_efc_info.insert_line('-- Non Excluded failure rows: '||l_fail_count||' '||l_fail_perc||'% ');

683: --
684: end if;
685: --
686: hr_efc_info.insert_line('-- Application errors: '||l_rco_count||' '||l_rco_perc||'% ');
687: hr_efc_info.insert_line('-- Non Excluded failure rows: '||l_fail_count||' '||l_fail_perc||'% ');
688: hr_efc_info.insert_line('-- Exclusion rows: '||l_excl_count||' '||l_excl_perc||'% ');
689: --
690: if p_disp_private then
691: --

Line 688: hr_efc_info.insert_line('-- Exclusion rows: '||l_excl_count||' '||l_excl_perc||'% ');

684: end if;
685: --
686: hr_efc_info.insert_line('-- Application errors: '||l_rco_count||' '||l_rco_perc||'% ');
687: hr_efc_info.insert_line('-- Non Excluded failure rows: '||l_fail_count||' '||l_fail_perc||'% ');
688: hr_efc_info.insert_line('-- Exclusion rows: '||l_excl_count||' '||l_excl_perc||'% ');
689: --
690: if p_disp_private then
691: --
692: hr_efc_info.insert_line('-- Duplicate Exclusion rows: '||l_dupexclval_count);

Line 692: hr_efc_info.insert_line('-- Duplicate Exclusion rows: '||l_dupexclval_count);

688: hr_efc_info.insert_line('-- Exclusion rows: '||l_excl_count||' '||l_excl_perc||'% ');
689: --
690: if p_disp_private then
691: --
692: hr_efc_info.insert_line('-- Duplicate Exclusion rows: '||l_dupexclval_count);
693: --
694: end if;
695: --
696: hr_efc_info.insert_line('-- ');

Line 696: hr_efc_info.insert_line('-- ');

692: hr_efc_info.insert_line('-- Duplicate Exclusion rows: '||l_dupexclval_count);
693: --
694: end if;
695: --
696: hr_efc_info.insert_line('-- ');
697: --
698: end if;
699: --
700: if p_rcoerr_val_set.count > 0 then

Line 702: hr_efc_info.insert_line('-- '||p_rcoerr_val_set.count||' Application errors ');

698: end if;
699: --
700: if p_rcoerr_val_set.count > 0 then
701: --
702: hr_efc_info.insert_line('-- '||p_rcoerr_val_set.count||' Application errors ');
703: hr_efc_info.insert_line('-- ');
704: --
705: for errele_num in p_rcoerr_val_set.first ..
706: p_rcoerr_val_set.last

Line 703: hr_efc_info.insert_line('-- ');

699: --
700: if p_rcoerr_val_set.count > 0 then
701: --
702: hr_efc_info.insert_line('-- '||p_rcoerr_val_set.count||' Application errors ');
703: hr_efc_info.insert_line('-- ');
704: --
705: for errele_num in p_rcoerr_val_set.first ..
706: p_rcoerr_val_set.last
707: loop

Line 709: hr_efc_info.insert_line(p_rcoerr_val_set(errele_num).id

705: for errele_num in p_rcoerr_val_set.first ..
706: p_rcoerr_val_set.last
707: loop
708: --
709: hr_efc_info.insert_line(p_rcoerr_val_set(errele_num).id
710: ||' '||p_rcoerr_val_set(errele_num).esd
711: ||' '||p_rcoerr_val_set(errele_num).eed
712: ||' '||p_rcoerr_val_set(errele_num).bgp_id
713: ||' '||p_rcoerr_val_set(errele_num).rco_name

Line 717: hr_efc_info.insert_line(' '||substr(p_rcoerr_val_set(errele_num).sql_error,1,240)

713: ||' '||p_rcoerr_val_set(errele_num).rco_name
714: ||' '||to_char(p_rcoerr_val_set(errele_num).lud,'DD-MON-YYYY')
715: );
716: --
717: hr_efc_info.insert_line(' '||substr(p_rcoerr_val_set(errele_num).sql_error,1,240)
718: );
719: --
720: end loop;
721: hr_efc_info.insert_line('-- ');

Line 721: hr_efc_info.insert_line('-- ');

717: hr_efc_info.insert_line(' '||substr(p_rcoerr_val_set(errele_num).sql_error,1,240)
718: );
719: --
720: end loop;
721: hr_efc_info.insert_line('-- ');
722: --
723: end if;
724: --
725: if p_failed_adj_val_set.count > 0 then

Line 727: hr_efc_info.insert_line('-- '||p_failed_adj_val_set.count||' Adjustment failures ');

723: end if;
724: --
725: if p_failed_adj_val_set.count > 0 then
726: --
727: hr_efc_info.insert_line('-- '||p_failed_adj_val_set.count||' Adjustment failures ');
728: hr_efc_info.insert_line('-- ');
729: --
730: for errele_num in p_failed_adj_val_set.first ..
731: p_failed_adj_val_set.last

Line 728: hr_efc_info.insert_line('-- ');

724: --
725: if p_failed_adj_val_set.count > 0 then
726: --
727: hr_efc_info.insert_line('-- '||p_failed_adj_val_set.count||' Adjustment failures ');
728: hr_efc_info.insert_line('-- ');
729: --
730: for errele_num in p_failed_adj_val_set.first ..
731: p_failed_adj_val_set.last
732: loop

Line 734: hr_efc_info.insert_line(p_failed_adj_val_set(errele_num).val_type

730: for errele_num in p_failed_adj_val_set.first ..
731: p_failed_adj_val_set.last
732: loop
733: --
734: hr_efc_info.insert_line(p_failed_adj_val_set(errele_num).val_type
735: ||' '||p_failed_adj_val_set(errele_num).id
736: ||' '||p_failed_adj_val_set(errele_num).esd
737: ||' '||p_failed_adj_val_set(errele_num).eed
738: ||' '||p_failed_adj_val_set(errele_num).bgp_id

Line 751: hr_efc_info.insert_line('-- ');

747: ||' '||p_failed_adj_val_set(errele_num).code1
748: );
749: --
750: end loop;
751: hr_efc_info.insert_line('-- ');
752: --
753: end if;
754: --
755: if l_fatal_error_val_set.count > 0 then

Line 930: hr_efc_info.insert_line('-- '||l_unqtype_set.count||' Exclusion Type Categories ');

926: -- Display unique fatal error types
927: --
928: if l_unqtype_set.count > 0 then
929: --
930: hr_efc_info.insert_line('-- '||l_unqtype_set.count||' Exclusion Type Categories ');
931: hr_efc_info.insert_line('-- ');
932: --
933: for ele_num in l_unqtype_set.first..l_unqtype_set.last
934: loop

Line 931: hr_efc_info.insert_line('-- ');

927: --
928: if l_unqtype_set.count > 0 then
929: --
930: hr_efc_info.insert_line('-- '||l_unqtype_set.count||' Exclusion Type Categories ');
931: hr_efc_info.insert_line('-- ');
932: --
933: for ele_num in l_unqtype_set.first..l_unqtype_set.last
934: loop
935: --

Line 947: hr_efc_info.insert_line(l_disp_str

943: ||' and '||l_unqtype_set(ele_num).mxcredt;
944: --
945: end if;
946: --
947: hr_efc_info.insert_line(l_disp_str
948: );
949: --
950: end loop;
951: hr_efc_info.insert_line('-- ');

Line 951: hr_efc_info.insert_line('-- ');

947: hr_efc_info.insert_line(l_disp_str
948: );
949: --
950: end loop;
951: hr_efc_info.insert_line('-- ');
952: --
953: end if;
954: --
955: -- Display unique fatal errors

Line 959: hr_efc_info.insert_line('-- '||l_unqval_set.count||' Exclusion Types ');

955: -- Display unique fatal errors
956: --
957: if l_unqval_set.count > 0 then
958: --
959: hr_efc_info.insert_line('-- '||l_unqval_set.count||' Exclusion Types ');
960: hr_efc_info.insert_line('-- ');
961: --
962: for ele_num in l_unqval_set.first..l_unqval_set.last
963: loop

Line 960: hr_efc_info.insert_line('-- ');

956: --
957: if l_unqval_set.count > 0 then
958: --
959: hr_efc_info.insert_line('-- '||l_unqval_set.count||' Exclusion Types ');
960: hr_efc_info.insert_line('-- ');
961: --
962: for ele_num in l_unqval_set.first..l_unqval_set.last
963: loop
964: --

Line 977: hr_efc_info.insert_line(l_disp_str

973: ||' and '||l_unqval_set(ele_num).mxcredt;
974: --
975: end if;
976: --
977: hr_efc_info.insert_line(l_disp_str
978: );
979: --
980: end loop;
981: hr_efc_info.insert_line('-- ');

Line 981: hr_efc_info.insert_line('-- ');

977: hr_efc_info.insert_line(l_disp_str
978: );
979: --
980: end loop;
981: hr_efc_info.insert_line('-- ');
982: --
983: end if;
984: --
985: if p_disp_exclusions then

Line 987: hr_efc_info.insert_line('-- '||l_fatal_error_val_set.count||' Exclusions ');

983: end if;
984: --
985: if p_disp_exclusions then
986: --
987: hr_efc_info.insert_line('-- '||l_fatal_error_val_set.count||' Exclusions ');
988: hr_efc_info.insert_line('-- ');
989: --
990: for errele_num in l_fatal_error_val_set.first ..
991: l_fatal_error_val_set.last

Line 988: hr_efc_info.insert_line('-- ');

984: --
985: if p_disp_exclusions then
986: --
987: hr_efc_info.insert_line('-- '||l_fatal_error_val_set.count||' Exclusions ');
988: hr_efc_info.insert_line('-- ');
989: --
990: for errele_num in l_fatal_error_val_set.first ..
991: l_fatal_error_val_set.last
992: loop

Line 994: hr_efc_info.insert_line(l_fatal_error_val_set(errele_num).faterr_code

990: for errele_num in l_fatal_error_val_set.first ..
991: l_fatal_error_val_set.last
992: loop
993: --
994: hr_efc_info.insert_line(l_fatal_error_val_set(errele_num).faterr_code
995: ||' '||l_fatal_error_val_set(errele_num).faterr_type
996: ||' '||l_fatal_error_val_set(errele_num).id
997: ||' '||l_fatal_error_val_set(errele_num).esd
998: ||' '||l_fatal_error_val_set(errele_num).val_type

Line 1016: hr_efc_info.insert_line('-- ');

1012: ||' '||l_fatal_error_val_set(errele_num).code4
1013: );
1014: --
1015: end loop;
1016: hr_efc_info.insert_line('-- ');
1017: --
1018: if l_dup_excl_val_set.count > 0 then
1019: --
1020: hr_efc_info.insert_line('-- '||l_dup_excl_val_set.count||' Duplicate Exclusions ');

Line 1020: hr_efc_info.insert_line('-- '||l_dup_excl_val_set.count||' Duplicate Exclusions ');

1016: hr_efc_info.insert_line('-- ');
1017: --
1018: if l_dup_excl_val_set.count > 0 then
1019: --
1020: hr_efc_info.insert_line('-- '||l_dup_excl_val_set.count||' Duplicate Exclusions ');
1021: hr_efc_info.insert_line('-- ');
1022: --
1023: for errele_num in l_dup_excl_val_set.first ..
1024: l_dup_excl_val_set.last

Line 1021: hr_efc_info.insert_line('-- ');

1017: --
1018: if l_dup_excl_val_set.count > 0 then
1019: --
1020: hr_efc_info.insert_line('-- '||l_dup_excl_val_set.count||' Duplicate Exclusions ');
1021: hr_efc_info.insert_line('-- ');
1022: --
1023: for errele_num in l_dup_excl_val_set.first ..
1024: l_dup_excl_val_set.last
1025: loop

Line 1027: hr_efc_info.insert_line(l_dup_excl_val_set(errele_num).faterr_code

1023: for errele_num in l_dup_excl_val_set.first ..
1024: l_dup_excl_val_set.last
1025: loop
1026: --
1027: hr_efc_info.insert_line(l_dup_excl_val_set(errele_num).faterr_code
1028: ||' '||l_dup_excl_val_set(errele_num).faterr_type
1029: ||' '||l_dup_excl_val_set(errele_num).id
1030: ||' '||l_dup_excl_val_set(errele_num).esd
1031: ||' '||l_dup_excl_val_set(errele_num).val_type

Line 1051: hr_efc_info.insert_line('-- ');

1047: --
1048: end loop;
1049: --
1050: end if;
1051: hr_efc_info.insert_line('-- ');
1052: --
1053: end if;
1054: --
1055: end if;

Line 1061: hr_efc_info.insert_line('-- '||l_success_val_set.count||' Successes ');

1057: if p_success_val_set.count > 0
1058: and p_disp_succeeds
1059: then
1060: --
1061: hr_efc_info.insert_line('-- '||l_success_val_set.count||' Successes ');
1062: hr_efc_info.insert_line('-- ');
1063: --
1064: for ele_num in l_success_val_set.first ..
1065: l_success_val_set.last

Line 1062: hr_efc_info.insert_line('-- ');

1058: and p_disp_succeeds
1059: then
1060: --
1061: hr_efc_info.insert_line('-- '||l_success_val_set.count||' Successes ');
1062: hr_efc_info.insert_line('-- ');
1063: --
1064: for ele_num in l_success_val_set.first ..
1065: l_success_val_set.last
1066: loop

Line 1068: hr_efc_info.insert_line(l_success_val_set(ele_num).id

1064: for ele_num in l_success_val_set.first ..
1065: l_success_val_set.last
1066: loop
1067: --
1068: hr_efc_info.insert_line(l_success_val_set(ele_num).id
1069: ||' '||l_success_val_set(ele_num).esd
1070: ||' '||l_success_val_set(ele_num).eed
1071: ||' '||l_success_val_set(ele_num).old_val1
1072: ||' '||l_success_val_set(ele_num).new_val1

Line 1088: hr_efc_info.insert_line('-- ');

1084: ||' '||l_success_val_set(ele_num).code4
1085: );
1086: --
1087: end loop;
1088: hr_efc_info.insert_line('-- ');
1089: --
1090: if l_dup_success_val_set.count > 0 then
1091: --
1092: hr_efc_info.insert_line('-- '||l_dup_success_val_set.count||' Duplicate Successes ');

Line 1092: hr_efc_info.insert_line('-- '||l_dup_success_val_set.count||' Duplicate Successes ');

1088: hr_efc_info.insert_line('-- ');
1089: --
1090: if l_dup_success_val_set.count > 0 then
1091: --
1092: hr_efc_info.insert_line('-- '||l_dup_success_val_set.count||' Duplicate Successes ');
1093: hr_efc_info.insert_line('-- ');
1094: --
1095: for ele_num in l_dup_success_val_set.first..l_dup_success_val_set.last
1096: loop

Line 1093: hr_efc_info.insert_line('-- ');

1089: --
1090: if l_dup_success_val_set.count > 0 then
1091: --
1092: hr_efc_info.insert_line('-- '||l_dup_success_val_set.count||' Duplicate Successes ');
1093: hr_efc_info.insert_line('-- ');
1094: --
1095: for ele_num in l_dup_success_val_set.first..l_dup_success_val_set.last
1096: loop
1097: --

Line 1098: hr_efc_info.insert_line(l_dup_success_val_set(ele_num).id

1094: --
1095: for ele_num in l_dup_success_val_set.first..l_dup_success_val_set.last
1096: loop
1097: --
1098: hr_efc_info.insert_line(l_dup_success_val_set(ele_num).id
1099: ||' '||l_dup_success_val_set(ele_num).esd
1100: ||' '||l_dup_success_val_set(ele_num).eed
1101: ||' '||l_dup_success_val_set(ele_num).old_val1
1102: ||' '||l_dup_success_val_set(ele_num).new_val1

Line 1117: hr_efc_info.insert_line('-- ');

1113: ||' '||l_dup_success_val_set(ele_num).code4
1114: );
1115: --
1116: end loop;
1117: hr_efc_info.insert_line('-- ');
1118: --
1119: end if;
1120: --
1121: end if;