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

Line 1793: hr_utility.set_location('c_avr_from_parent l_ACTY_BASE_RT_ID'||l_ACTY_BASE_RT_ID,100);

1789: ---------------------------------------------------------------
1790: -- START OF BEN_ACTY_VRBL_RT_F ----------------------
1791: ---------------------------------------------------------------
1792: --
1793: hr_utility.set_location('c_avr_from_parent l_ACTY_BASE_RT_ID'||l_ACTY_BASE_RT_ID,100);
1794: for l_parent_rec in c_avr_from_parent(l_ACTY_BASE_RT_ID) loop
1795: --
1796: l_mirror_src_entity_result_id := l_out_abr_result_id ;
1797: --

Line 1887: hr_utility.set_location('l_avr_rec.vrbl_rt_prfl_id '||l_avr_rec.vrbl_rt_prfl_id,100);

1883: for l_avr_rec in c_avr_drp(l_parent_rec.acty_vrbl_rt_id,l_mirror_src_entity_result_id,'AVR') loop
1884: -----------------------------------------------------------------------------------------
1885: -- Call to VAPRO
1886: -----------------------------------------------------------------------------------------
1887: hr_utility.set_location('l_avr_rec.vrbl_rt_prfl_id '||l_avr_rec.vrbl_rt_prfl_id,100);
1888: create_vapro_results
1889: (
1890: p_validate => p_validate
1891: ,p_copy_entity_result_id => l_out_avr_result_id

Line 3076: hr_utility.set_location('l_parent_rec.bnft_vrbl_rt_id '|| l_parent_rec.bnft_vrbl_rt_id,100);

3072: l_out_bvr_result_id := l_copy_entity_result_id ;
3073: end if;
3074: --
3075: end loop;
3076: hr_utility.set_location('l_parent_rec.bnft_vrbl_rt_id '|| l_parent_rec.bnft_vrbl_rt_id,100);
3077: hr_utility.set_location('l_mirror_src_entity_result_id '|| l_mirror_src_entity_result_id,100);
3078: for l_bvr_rec in c_bvr_drp(l_parent_rec.bnft_vrbl_rt_id,l_mirror_src_entity_result_id,'BVR1') loop
3079: -----------------------------------------------------------------------------------------
3080: -- Call to VAPRO

Line 3077: hr_utility.set_location('l_mirror_src_entity_result_id '|| l_mirror_src_entity_result_id,100);

3073: end if;
3074: --
3075: end loop;
3076: hr_utility.set_location('l_parent_rec.bnft_vrbl_rt_id '|| l_parent_rec.bnft_vrbl_rt_id,100);
3077: hr_utility.set_location('l_mirror_src_entity_result_id '|| l_mirror_src_entity_result_id,100);
3078: for l_bvr_rec in c_bvr_drp(l_parent_rec.bnft_vrbl_rt_id,l_mirror_src_entity_result_id,'BVR1') loop
3079: -----------------------------------------------------------------------------------------
3080: -- Call to VAPRO
3081: -----------------------------------------------------------------------------------------

Line 3082: hr_utility.set_location('l_bvr_rec ',100);

3078: for l_bvr_rec in c_bvr_drp(l_parent_rec.bnft_vrbl_rt_id,l_mirror_src_entity_result_id,'BVR1') loop
3079: -----------------------------------------------------------------------------------------
3080: -- Call to VAPRO
3081: -----------------------------------------------------------------------------------------
3082: hr_utility.set_location('l_bvr_rec ',100);
3083: create_vapro_results
3084: (
3085: p_validate => p_validate
3086: ,p_copy_entity_result_id => l_out_bvr_result_id

Line 3834: hr_utility.set_location('l_parent_rec.actl_prem_vrbl_rt_id '|| l_parent_rec.actl_prem_vrbl_rt_id,100);

3830: l_out_apv_result_id := l_copy_entity_result_id ;
3831: end if;
3832: --
3833: end loop;
3834: hr_utility.set_location('l_parent_rec.actl_prem_vrbl_rt_id '|| l_parent_rec.actl_prem_vrbl_rt_id,100);
3835: hr_utility.set_location('l_mirror_src_entity_result_id '|| l_mirror_src_entity_result_id,100);
3836: for l_apv_rec in c_apv_dpr(l_parent_rec.actl_prem_vrbl_rt_id,l_mirror_src_entity_result_id,'APV') loop
3837: -----------------------------------------------------------------------------------------
3838: -- Call to VAPRO

Line 3835: hr_utility.set_location('l_mirror_src_entity_result_id '|| l_mirror_src_entity_result_id,100);

3831: end if;
3832: --
3833: end loop;
3834: hr_utility.set_location('l_parent_rec.actl_prem_vrbl_rt_id '|| l_parent_rec.actl_prem_vrbl_rt_id,100);
3835: hr_utility.set_location('l_mirror_src_entity_result_id '|| l_mirror_src_entity_result_id,100);
3836: for l_apv_rec in c_apv_dpr(l_parent_rec.actl_prem_vrbl_rt_id,l_mirror_src_entity_result_id,'APV') loop
3837: -----------------------------------------------------------------------------------------
3838: -- Call to VAPRO
3839: -----------------------------------------------------------------------------------------

Line 3840: hr_utility.set_location('l_apv_rec ',100);

3836: for l_apv_rec in c_apv_dpr(l_parent_rec.actl_prem_vrbl_rt_id,l_mirror_src_entity_result_id,'APV') loop
3837: -----------------------------------------------------------------------------------------
3838: -- Call to VAPRO
3839: -----------------------------------------------------------------------------------------
3840: hr_utility.set_location('l_apv_rec ',100);
3841: create_vapro_results
3842: (
3843: p_validate => p_validate
3844: ,p_copy_entity_result_id => l_out_apv_result_id

Line 4285: hr_utility.set_location('Start create_drpar_results',100);

4281:
4282: l_dummy varchar2(1);
4283:
4284: begin
4285: hr_utility.set_location('Start create_drpar_results',100);
4286: l_number_of_copies := p_number_of_copies ;
4287:
4288: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
4289: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;

Line 5425: hr_utility.set_location('end create_drpar_results',100);

5421: ---------------------------------------------------------------
5422: -- END OF BEN_PCT_FL_TM_FCTR ----------------------
5423: ---------------------------------------------------------------
5424: end if;
5425: hr_utility.set_location('end create_drpar_results',100);
5426: end create_drpar_results ;
5427: --
5428:
5429: procedure create_vrb_rt_elg_prf_results

Line 7970: hr_utility.set_location('l_vrbl_rt_prfl_id'||l_vrbl_rt_prfl_id,100);

7966: --
7967: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
7968: l_vrbl_rt_prfl_id := p_vrbl_rt_prfl_id ;
7969: --
7970: hr_utility.set_location('l_vrbl_rt_prfl_id'||l_vrbl_rt_prfl_id,100);
7971: for l_vpf_rec in c_vpf(l_vrbl_rt_prfl_id,l_mirror_src_entity_result_id,'VPF') loop
7972: --
7973: l_table_route_id := null ;
7974: open ben_plan_design_program_module.g_table_route('VPF');

Line 8442: hr_utility.set_location('START OF BEN_ASNT_SET_RT_F ',100);

8438: ---------------------------------------------------------------
8439: -- START OF BEN_ASNT_SET_RT_F ----------------------
8440: ---------------------------------------------------------------
8441: --
8442: hr_utility.set_location('START OF BEN_ASNT_SET_RT_F ',100);
8443: --
8444: for l_parent_rec in c_asr_from_parent(l_VRBL_RT_PRFL_ID) loop
8445: --
8446: l_mirror_src_entity_result_id := l_out_vpf_result_id ;

Line 8450: hr_utility.set_location('l_asnt_set_rt_id '||l_asnt_set_rt_id,100);

8446: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
8447:
8448: --
8449: l_asnt_set_rt_id := l_parent_rec.asnt_set_rt_id ;
8450: hr_utility.set_location('l_asnt_set_rt_id '||l_asnt_set_rt_id,100);
8451: --
8452: for l_asr_rec in c_asr(l_parent_rec.asnt_set_rt_id,l_mirror_src_entity_result_id,'ASR') loop
8453: --
8454: l_table_route_id := null ;

Line 8497: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);

8493: l_mapping_column_name1,
8494: l_mapping_column_name2,
8495: p_copy_entity_txn_id);
8496: --
8497: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
8498: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
8499: ben_copy_entity_results_api.create_copy_entity_results(
8500: p_copy_entity_result_id => l_copy_entity_result_id,
8501: p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 8498: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);

8494: l_mapping_column_name2,
8495: p_copy_entity_txn_id);
8496: --
8497: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
8498: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
8499: ben_copy_entity_results_api.create_copy_entity_results(
8500: p_copy_entity_result_id => l_copy_entity_result_id,
8501: p_copy_entity_txn_id => p_copy_entity_txn_id,
8502: p_result_type_cd => l_result_type_cd,

Line 8572: hr_utility.set_location('END OF BEN_ASNT_SET_RT_F ',100);

8568: --
8569: end loop;
8570: --
8571: end loop;
8572: hr_utility.set_location('END OF BEN_ASNT_SET_RT_F ',100);
8573: ---------------------------------------------------------------
8574: -- END OF BEN_ASNT_SET_RT_F ----------------------
8575: ---------------------------------------------------------------
8576: ---------------------------------------------------------------

Line 8912: hr_utility.set_location('END OF BEN_CMBN_AGE_LOS_RT_F',100);

8908: ,p_effective_date => p_effective_date
8909: );
8910: end loop;
8911: end loop;
8912: hr_utility.set_location('END OF BEN_CMBN_AGE_LOS_RT_F',100);
8913: ---------------------------------------------------------------
8914: -- END OF BEN_CMBN_AGE_LOS_RT_F ----------------------
8915: ---------------------------------------------------------------
8916: ---------------------------------------------------------------

Line 8920: hr_utility.set_location('START OF BEN_COMP_LVL_RT_F',100);

8916: ---------------------------------------------------------------
8917: -- START OF BEN_COMP_LVL_RT_F ----------------------
8918: ---------------------------------------------------------------
8919: --
8920: hr_utility.set_location('START OF BEN_COMP_LVL_RT_F',100);
8921: for l_parent_rec in c_clr_from_parent(l_VRBL_RT_PRFL_ID) loop
8922: --
8923: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
8924:

Line 8928: hr_utility.set_location('l_comp_lvl_rt_id '||l_comp_lvl_rt_id,100);

8924:
8925: --
8926: l_comp_lvl_rt_id := l_parent_rec.comp_lvl_rt_id ;
8927: --
8928: hr_utility.set_location('l_comp_lvl_rt_id '||l_comp_lvl_rt_id,100);
8929: for l_clr_rec in c_clr(l_parent_rec.comp_lvl_rt_id,l_mirror_src_entity_result_id,'CLR') loop
8930: --
8931: l_table_route_id := null ;
8932: open ben_plan_design_program_module.g_table_route('CLR');

Line 9016: hr_utility.set_location(' l_parent_rec.comp_lvl_rt_id '||l_parent_rec.comp_lvl_rt_id,100);

9012: end if;
9013: --
9014: end loop;
9015: --
9016: hr_utility.set_location(' l_parent_rec.comp_lvl_rt_id '||l_parent_rec.comp_lvl_rt_id,100);
9017: for l_clr_rec in c_clr_drp(l_parent_rec.comp_lvl_rt_id,l_mirror_src_entity_result_id,'CLR') loop
9018: create_drpar_results
9019: (
9020: p_validate => p_validate

Line 9036: hr_utility.set_location('END OF BEN_COMP_LVL_RT_F',100);

9032: ,p_effective_date => p_effective_date
9033: );
9034: end loop;
9035: end loop;
9036: hr_utility.set_location('END OF BEN_COMP_LVL_RT_F',100);
9037: ---------------------------------------------------------------
9038: -- END OF BEN_COMP_LVL_RT_F ----------------------
9039: ---------------------------------------------------------------
9040: ---------------------------------------------------------------

Line 9146: hr_utility.set_location('START OF BEN_EE_STAT_RT_F',100);

9142: ---------------------------------------------------------------
9143: -- START OF BEN_EE_STAT_RT_F ----------------------
9144: ---------------------------------------------------------------
9145: --
9146: hr_utility.set_location('START OF BEN_EE_STAT_RT_F',100);
9147: for l_parent_rec in c_esr_from_parent(l_VRBL_RT_PRFL_ID) loop
9148: --
9149: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
9150:

Line 9156: hr_utility.set_location('l_parent_rec.ee_stat_rt_id '||l_parent_rec.ee_stat_rt_id,100);

9152: l_ee_stat_rt_id := l_parent_rec.ee_stat_rt_id ;
9153: --
9154: for l_esr_rec in c_esr(l_parent_rec.ee_stat_rt_id,l_mirror_src_entity_result_id,'ESR') loop
9155: --
9156: hr_utility.set_location('l_parent_rec.ee_stat_rt_id '||l_parent_rec.ee_stat_rt_id,100);
9157: l_table_route_id := null ;
9158: open ben_plan_design_program_module.g_table_route('ESR');
9159: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9160: close ben_plan_design_program_module.g_table_route ;

Line 9201: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);

9197: l_mapping_column_name1,
9198: l_mapping_column_name2,
9199: p_copy_entity_txn_id);
9200: --
9201: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
9202: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
9203: --
9204: ben_copy_entity_results_api.create_copy_entity_results(
9205: p_copy_entity_result_id => l_copy_entity_result_id,

Line 9202: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);

9198: l_mapping_column_name2,
9199: p_copy_entity_txn_id);
9200: --
9201: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
9202: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
9203: --
9204: ben_copy_entity_results_api.create_copy_entity_results(
9205: p_copy_entity_result_id => l_copy_entity_result_id,
9206: p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 9278: hr_utility.set_location('END OF BEN_EE_STAT_RT_F ',100);

9274: --
9275: end loop;
9276: --
9277: end loop;
9278: hr_utility.set_location('END OF BEN_EE_STAT_RT_F ',100);
9279: ---------------------------------------------------------------
9280: -- END OF BEN_EE_STAT_RT_F ----------------------
9281: ---------------------------------------------------------------
9282: ---------------------------------------------------------------

Line 9490: hr_utility.set_location('START OF BEN_GRADE_RT_F',100);

9486: ---------------------------------------------------------------
9487: -- START OF BEN_GRADE_RT_F ----------------------
9488: ---------------------------------------------------------------
9489: --
9490: hr_utility.set_location('START OF BEN_GRADE_RT_F',100);
9491: for l_parent_rec in c_grr_from_parent(l_VRBL_RT_PRFL_ID) loop
9492: --
9493: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
9494:

Line 9498: hr_utility.set_location('l_grade_rt_id '||l_grade_rt_id,100);

9494:
9495: --
9496: l_grade_rt_id := l_parent_rec.grade_rt_id ;
9497: --
9498: hr_utility.set_location('l_grade_rt_id '||l_grade_rt_id,100);
9499: for l_grr_rec in c_grr(l_parent_rec.grade_rt_id,l_mirror_src_entity_result_id,'GRR') loop
9500: --
9501: l_table_route_id := null ;
9502: open ben_plan_design_program_module.g_table_route('GRR');

Line 9554: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);

9550: l_mapping_column_name1,
9551: l_mapping_column_name2,
9552: p_copy_entity_txn_id);
9553: --
9554: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
9555: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
9556:
9557: ben_copy_entity_results_api.create_copy_entity_results(
9558: p_copy_entity_result_id => l_copy_entity_result_id,

Line 9555: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);

9551: l_mapping_column_name2,
9552: p_copy_entity_txn_id);
9553: --
9554: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
9555: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
9556:
9557: ben_copy_entity_results_api.create_copy_entity_results(
9558: p_copy_entity_result_id => l_copy_entity_result_id,
9559: p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 9629: hr_utility.set_location('END OF BEN_GRADE_RT_F',100);

9625: --
9626: end loop;
9627: --
9628: end loop;
9629: hr_utility.set_location('END OF BEN_GRADE_RT_F',100);
9630: ---------------------------------------------------------------
9631: -- END OF BEN_GRADE_RT_F ----------------------
9632: ---------------------------------------------------------------
9633: ---------------------------------------------------------------

Line 9738: hr_utility.set_location('START OF BEN_HRS_WKD_IN_PERD_RT_F ',100);

9734: ---------------------------------------------------------------
9735: -- START OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------
9736: ---------------------------------------------------------------
9737: --
9738: hr_utility.set_location('START OF BEN_HRS_WKD_IN_PERD_RT_F ',100);
9739: for l_parent_rec in c_hwr_from_parent(l_VRBL_RT_PRFL_ID) loop
9740: --
9741: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
9742:

Line 9746: hr_utility.set_location('l_hrs_wkd_in_perd_rt_id '||l_hrs_wkd_in_perd_rt_id,100);

9742:
9743: --
9744: l_hrs_wkd_in_perd_rt_id := l_parent_rec.hrs_wkd_in_perd_rt_id ;
9745: --
9746: hr_utility.set_location('l_hrs_wkd_in_perd_rt_id '||l_hrs_wkd_in_perd_rt_id,100);
9747: for l_hwr_rec in c_hwr(l_parent_rec.hrs_wkd_in_perd_rt_id,l_mirror_src_entity_result_id,'HWR') loop
9748: --
9749: l_table_route_id := null ;
9750: open ben_plan_design_program_module.g_table_route('HWR');

Line 9836: hr_utility.set_location('l_parent_rec.hrs_wkd_in_perd_rt_id '||l_parent_rec.hrs_wkd_in_perd_rt_id,100);

9832: --
9833: end loop;
9834: --
9835: for l_hwr_rec in c_hwr_drp(l_parent_rec.hrs_wkd_in_perd_rt_id,l_mirror_src_entity_result_id,'HWR') loop
9836: hr_utility.set_location('l_parent_rec.hrs_wkd_in_perd_rt_id '||l_parent_rec.hrs_wkd_in_perd_rt_id,100);
9837: create_drpar_results
9838: (
9839: p_validate => p_validate
9840: ,p_copy_entity_result_id => l_out_hwr_result_id

Line 9855: hr_utility.set_location('END OF BEN_HRS_WKD_IN_PERD_RT_F ',100);

9851: ,p_effective_date => p_effective_date
9852: );
9853: end loop;
9854: end loop;
9855: hr_utility.set_location('END OF BEN_HRS_WKD_IN_PERD_RT_F ',100);
9856: ---------------------------------------------------------------
9857: -- END OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------
9858: ---------------------------------------------------------------
9859: ---------------------------------------------------------------

Line 9966: hr_utility.set_location('START OF BEN_LGL_ENTY_RT_F ',100);

9962: ---------------------------------------------------------------
9963: -- START OF BEN_LGL_ENTY_RT_F ----------------------
9964: ---------------------------------------------------------------
9965: --
9966: hr_utility.set_location('START OF BEN_LGL_ENTY_RT_F ',100);
9967: for l_parent_rec in c_ler_from_parent(l_VRBL_RT_PRFL_ID) loop
9968: --
9969: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
9970:

Line 9974: hr_utility.set_location('l_lgl_enty_rt_id '||l_lgl_enty_rt_id,100);

9970:
9971: --
9972: l_lgl_enty_rt_id := l_parent_rec.lgl_enty_rt_id ;
9973: --
9974: hr_utility.set_location('l_lgl_enty_rt_id '||l_lgl_enty_rt_id,100);
9975: for l_ler_rec in c_ler(l_parent_rec.lgl_enty_rt_id,l_mirror_src_entity_result_id,'LER1') loop
9976: --
9977: l_table_route_id := null ;
9978: open ben_plan_design_program_module.g_table_route('LER1');

Line 10032: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);

10028: l_mapping_column_name1,
10029: l_mapping_column_name2,
10030: p_copy_entity_txn_id);
10031: --
10032: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
10033: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
10034:
10035: ben_copy_entity_results_api.create_copy_entity_results(
10036: p_copy_entity_result_id => l_copy_entity_result_id,

Line 10033: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);

10029: l_mapping_column_name2,
10030: p_copy_entity_txn_id);
10031: --
10032: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
10033: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
10034:
10035: ben_copy_entity_results_api.create_copy_entity_results(
10036: p_copy_entity_result_id => l_copy_entity_result_id,
10037: p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 10110: hr_utility.set_location('END OF BEN_LGL_ENTY_RT_F ',100);

10106: --
10107: end loop;
10108: --
10109: end loop;
10110: hr_utility.set_location('END OF BEN_LGL_ENTY_RT_F ',100);
10111: ---------------------------------------------------------------
10112: -- END OF BEN_LGL_ENTY_RT_F ----------------------
10113: ---------------------------------------------------------------
10114: ---------------------------------------------------------------

Line 10118: hr_utility.set_location('START OF BEN_LOA_RSN_RT_F ',100);

10114: ---------------------------------------------------------------
10115: -- START OF BEN_LOA_RSN_RT_F ----------------------
10116: ---------------------------------------------------------------
10117: --
10118: hr_utility.set_location('START OF BEN_LOA_RSN_RT_F ',100);
10119: for l_parent_rec in c_lar_from_parent(l_VRBL_RT_PRFL_ID) loop
10120: --
10121: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
10122:

Line 10126: hr_utility.set_location('l_loa_rsn_rt_id '||l_loa_rsn_rt_id,100);

10122:
10123: --
10124: l_loa_rsn_rt_id := l_parent_rec.loa_rsn_rt_id ;
10125: --
10126: hr_utility.set_location('l_loa_rsn_rt_id '||l_loa_rsn_rt_id,100);
10127: for l_lar_rec in c_lar(l_parent_rec.loa_rsn_rt_id,l_mirror_src_entity_result_id,'LAR') loop
10128: --
10129: l_table_route_id := null ;
10130: open ben_plan_design_program_module.g_table_route('LAR');

Line 10196: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);

10192: l_mapping_column_name1,
10193: l_mapping_column_name2,
10194: p_copy_entity_txn_id);
10195: --
10196: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
10197: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
10198: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
10199: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
10200: --

Line 10197: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);

10193: l_mapping_column_name2,
10194: p_copy_entity_txn_id);
10195: --
10196: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
10197: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
10198: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
10199: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
10200: --
10201:

Line 10198: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);

10194: p_copy_entity_txn_id);
10195: --
10196: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
10197: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
10198: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
10199: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
10200: --
10201:
10202: ben_copy_entity_results_api.create_copy_entity_results(

Line 10199: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);

10195: --
10196: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
10197: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
10198: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
10199: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
10200: --
10201:
10202: ben_copy_entity_results_api.create_copy_entity_results(
10203: p_copy_entity_result_id => l_copy_entity_result_id,

Line 10282: hr_utility.set_location('END OF BEN_LOA_RSN_RT_F ',100);

10278: --
10279: end loop;
10280: --
10281: end loop;
10282: hr_utility.set_location('END OF BEN_LOA_RSN_RT_F ',100);
10283: ---------------------------------------------------------------
10284: -- END OF BEN_LOA_RSN_RT_F ----------------------
10285: ---------------------------------------------------------------
10286: ---------------------------------------------------------------

Line 10385: hr_utility.set_location('l_parent_rec.los_rt_id '||l_parent_rec.los_rt_id,100);

10381: --
10382: end loop;
10383: --
10384: for l_lsr_rec in c_lsr_drp(l_parent_rec.los_rt_id,l_mirror_src_entity_result_id,'LSR') loop
10385: hr_utility.set_location('l_parent_rec.los_rt_id '||l_parent_rec.los_rt_id,100);
10386: create_drpar_results
10387: (
10388: p_validate => p_validate
10389: ,p_copy_entity_result_id => l_out_lsr_result_id

Line 10512: hr_utility.set_location('START OF BEN_ORG_UNIT_RT_F',100);

10508: ---------------------------------------------------------------
10509: -- START OF BEN_ORG_UNIT_RT_F ----------------------
10510: ---------------------------------------------------------------
10511: --
10512: hr_utility.set_location('START OF BEN_ORG_UNIT_RT_F',100);
10513: for l_parent_rec in c_our_from_parent(l_VRBL_RT_PRFL_ID) loop
10514: --
10515: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
10516:

Line 10520: hr_utility.set_location('l_org_unit_rt_id '||l_org_unit_rt_id,100);

10516:
10517: --
10518: l_org_unit_rt_id := l_parent_rec.org_unit_rt_id ;
10519: --
10520: hr_utility.set_location('l_org_unit_rt_id '||l_org_unit_rt_id,100);
10521: for l_our_rec in c_our(l_parent_rec.org_unit_rt_id,l_mirror_src_entity_result_id,'OUR') loop
10522: --
10523: l_table_route_id := null ;
10524: open ben_plan_design_program_module.g_table_route('OUR');

Line 10653: hr_utility.set_location('END OF BEN_ORG_UNIT_RT_F',100);

10649: --
10650: end loop;
10651: --
10652: end loop;
10653: hr_utility.set_location('END OF BEN_ORG_UNIT_RT_F',100);
10654: ---------------------------------------------------------------
10655: -- END OF BEN_ORG_UNIT_RT_F ----------------------
10656: ---------------------------------------------------------------
10657: ---------------------------------------------------------------

Line 10782: hr_utility.set_location('START OF BEN_PER_TYP_RT_F ',100);

10778: ---------------------------------------------------------------
10779: -- START OF BEN_PER_TYP_RT_F ----------------------
10780: ---------------------------------------------------------------
10781: --
10782: hr_utility.set_location('START OF BEN_PER_TYP_RT_F ',100);
10783: for l_parent_rec in c_ptr_from_parent(l_VRBL_RT_PRFL_ID) loop
10784: --
10785: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
10786:

Line 10790: hr_utility.set_location('l_per_typ_rt_id '||l_per_typ_rt_id,100);

10786:
10787: --
10788: l_per_typ_rt_id := l_parent_rec.per_typ_rt_id ;
10789: --
10790: hr_utility.set_location('l_per_typ_rt_id '||l_per_typ_rt_id,100);
10791: for l_ptr_rec in c_ptr(l_parent_rec.per_typ_rt_id,l_mirror_src_entity_result_id,'PTR') loop
10792: --
10793: l_table_route_id := null ;
10794: open ben_plan_design_program_module.g_table_route('PTR');

Line 10837: hr_utility.set_location('l_parent_rec.per_typ_rt_id '||l_parent_rec.per_typ_rt_id,100);

10833: l_mapping_column_name2,
10834: p_copy_entity_txn_id);
10835: --
10836:
10837: hr_utility.set_location('l_parent_rec.per_typ_rt_id '||l_parent_rec.per_typ_rt_id,100);
10838: ben_copy_entity_results_api.create_copy_entity_results(
10839: p_copy_entity_result_id => l_copy_entity_result_id,
10840: p_copy_entity_txn_id => p_copy_entity_txn_id,
10841: p_result_type_cd => l_result_type_cd,

Line 10913: hr_utility.set_location('END OF BEN_PER_TYP_RT_F ',100);

10909: --
10910: end loop;
10911: --
10912: end loop;
10913: hr_utility.set_location('END OF BEN_PER_TYP_RT_F ',100);
10914: ---------------------------------------------------------------
10915: -- END OF BEN_PER_TYP_RT_F ----------------------
10916: ---------------------------------------------------------------
10917: ---------------------------------------------------------------

Line 11272: hr_utility.set_location('START OF BEN_PYRL_RT_F',100);

11268: ---------------------------------------------------------------
11269: -- START OF BEN_PYRL_RT_F ----------------------
11270: ---------------------------------------------------------------
11271: --
11272: hr_utility.set_location('START OF BEN_PYRL_RT_F',100);
11273: for l_parent_rec in c_pr__from_parent(l_VRBL_RT_PRFL_ID) loop
11274: --
11275: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
11276:

Line 11280: hr_utility.set_location('l_pyrl_rt_id '||l_pyrl_rt_id,100);

11276:
11277: --
11278: l_pyrl_rt_id := l_parent_rec.pyrl_rt_id ;
11279: --
11280: hr_utility.set_location('l_pyrl_rt_id '||l_pyrl_rt_id,100);
11281: for l_pr__rec in c_pr_(l_parent_rec.pyrl_rt_id,l_mirror_src_entity_result_id,'PR_') loop
11282: --
11283: l_table_route_id := null ;
11284: open ben_plan_design_program_module.g_table_route('PR_');

Line 11339: hr_utility.set_location('l_parent_rec.pyrl_rt_id '||l_parent_rec.pyrl_rt_id,100);

11335: --
11336:
11337: l_copy_entity_result_id := null;
11338: l_object_version_number := null;
11339: hr_utility.set_location('l_parent_rec.pyrl_rt_id '||l_parent_rec.pyrl_rt_id,100);
11340: ben_copy_entity_results_api.create_copy_entity_results(
11341: p_copy_entity_result_id => l_copy_entity_result_id,
11342: p_copy_entity_txn_id => p_copy_entity_txn_id,
11343: p_result_type_cd => l_result_type_cd,

Line 11414: hr_utility.set_location('END OF BEN_PYRL_RT_F',100);

11410: --
11411: end loop;
11412: --
11413: end loop;
11414: hr_utility.set_location('END OF BEN_PYRL_RT_F',100);
11415: ---------------------------------------------------------------
11416: -- END OF BEN_PYRL_RT_F ----------------------
11417: ---------------------------------------------------------------
11418: ---------------------------------------------------------------

Line 11422: hr_utility.set_location('START OF BEN_PY_BSS_RT_F ',100);

11418: ---------------------------------------------------------------
11419: -- START OF BEN_PY_BSS_RT_F ----------------------
11420: ---------------------------------------------------------------
11421: --
11422: hr_utility.set_location('START OF BEN_PY_BSS_RT_F ',100);
11423: for l_parent_rec in c_pbr_from_parent(l_VRBL_RT_PRFL_ID) loop
11424: --
11425: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
11426:

Line 11430: hr_utility.set_location('l_py_bss_rt_id '||l_py_bss_rt_id,100);

11426:
11427: --
11428: l_py_bss_rt_id := l_parent_rec.py_bss_rt_id ;
11429: --
11430: hr_utility.set_location('l_py_bss_rt_id '||l_py_bss_rt_id,100);
11431: for l_pbr_rec in c_pbr(l_parent_rec.py_bss_rt_id,l_mirror_src_entity_result_id,'PBR') loop
11432: --
11433: l_table_route_id := null ;
11434: open ben_plan_design_program_module.g_table_route('PBR');

Line 11474: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);

11470: l_mapping_column_name1,
11471: l_mapping_column_name2,
11472: p_copy_entity_txn_id);
11473: --
11474: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
11475: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
11476: --
11477: l_copy_entity_result_id := null;
11478: l_object_version_number := null;

Line 11475: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);

11471: l_mapping_column_name2,
11472: p_copy_entity_txn_id);
11473: --
11474: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
11475: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
11476: --
11477: l_copy_entity_result_id := null;
11478: l_object_version_number := null;
11479: ben_copy_entity_results_api.create_copy_entity_results(

Line 11553: hr_utility.set_location('END OF BEN_PY_BSS_RT_F ',100);

11549: --
11550: end loop;
11551: --
11552: end loop;
11553: hr_utility.set_location('END OF BEN_PY_BSS_RT_F ',100);
11554: ---------------------------------------------------------------
11555: -- END OF BEN_PY_BSS_RT_F ----------------------
11556: ---------------------------------------------------------------
11557: ---------------------------------------------------------------

Line 12616: hr_utility.set_location('START OF BEN_COMPTNCY_RT_F',100);

12612: ---------------------------------------------------------------
12613: -- START OF BEN_COMPTNCY_RT_F ----------------------
12614: ---------------------------------------------------------------
12615: --
12616: hr_utility.set_location('START OF BEN_COMPTNCY_RT_F',100);
12617: for l_parent_rec in c_cty_from_parent(l_VRBL_RT_PRFL_ID) loop
12618: --
12619: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
12620:

Line 12690: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);

12686: l_mapping_column_name1,
12687: l_mapping_column_name2,
12688: p_copy_entity_txn_id);
12689: --
12690: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
12691: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
12692: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
12693: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
12694: --

Line 12691: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);

12687: l_mapping_column_name2,
12688: p_copy_entity_txn_id);
12689: --
12690: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
12691: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
12692: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
12693: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
12694: --
12695:

Line 12692: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);

12688: p_copy_entity_txn_id);
12689: --
12690: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
12691: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
12692: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
12693: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
12694: --
12695:
12696: l_copy_entity_result_id := null;

Line 12693: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);

12689: --
12690: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
12691: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
12692: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
12693: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
12694: --
12695:
12696: l_copy_entity_result_id := null;
12697: l_object_version_number := null;

Line 12776: hr_utility.set_location('END OF BEN_COMPTNCY_RT_F',100);

12772: --
12773: end loop;
12774: --
12775: end loop;
12776: hr_utility.set_location('END OF BEN_COMPTNCY_RT_F',100);
12777: ---------------------------------------------------------------
12778: -- END OF BEN_COMPTNCY_RT_F ----------------------
12779: ---------------------------------------------------------------
12780: ---------------------------------------------------------------

Line 12784: hr_utility.set_location('START OF BEN_JOB_RT_F',100);

12780: ---------------------------------------------------------------
12781: -- START OF BEN_JOB_RT_F ----------------------
12782: ---------------------------------------------------------------
12783: --
12784: hr_utility.set_location('START OF BEN_JOB_RT_F',100);
12785: for l_parent_rec in c_jrt_from_parent(l_VRBL_RT_PRFL_ID) loop
12786: --
12787: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
12788:

Line 12844: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);

12840: l_mapping_column_name1,
12841: l_mapping_column_name2,
12842: p_copy_entity_txn_id);
12843: --
12844: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
12845: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
12846: --
12847:
12848: l_copy_entity_result_id := null;

Line 12845: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);

12841: l_mapping_column_name2,
12842: p_copy_entity_txn_id);
12843: --
12844: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
12845: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
12846: --
12847:
12848: l_copy_entity_result_id := null;
12849: l_object_version_number := null;

Line 12924: hr_utility.set_location('END OF BEN_JOB_RT_F',100);

12920: --
12921: end loop;
12922: --
12923: end loop;
12924: hr_utility.set_location('END OF BEN_JOB_RT_F',100);
12925: ---------------------------------------------------------------
12926: -- END OF BEN_JOB_RT_F ----------------------
12927: ---------------------------------------------------------------
12928:

Line 12933: hr_utility.set_location('START OF BEN_PSTN_RT_F ',100);

12929: ---------------------------------------------------------------
12930: -- START OF BEN_PSTN_RT_F ----------------------
12931: ---------------------------------------------------------------
12932: --
12933: hr_utility.set_location('START OF BEN_PSTN_RT_F ',100);
12934: for l_parent_rec in c_pst_from_parent(l_VRBL_RT_PRFL_ID) loop
12935: --
12936: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
12937:

Line 12984: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);

12980: l_mapping_column_name1,
12981: l_mapping_column_name2,
12982: p_copy_entity_txn_id);
12983: --
12984: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
12985: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
12986:
12987: -- To store effective_start_date of position
12988: -- for Mapping - Bug 2958658

Line 12985: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);

12981: l_mapping_column_name2,
12982: p_copy_entity_txn_id);
12983: --
12984: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
12985: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
12986:
12987: -- To store effective_start_date of position
12988: -- for Mapping - Bug 2958658
12989: --

Line 13073: hr_utility.set_location('END OF BEN_PSTN_RT_F ',100);

13069: --
13070: end loop;
13071: --
13072: end loop;
13073: hr_utility.set_location('END OF BEN_PSTN_RT_F ',100);
13074: ---------------------------------------------------------------
13075: -- END OF BEN_PSTN_RT_F ----------------------
13076: ---------------------------------------------------------------
13077: ---------------------------------------------------------------

Line 13081: hr_utility.set_location('START OF BEN_QUAL_TITL_RT_F ',100);

13077: ---------------------------------------------------------------
13078: -- START OF BEN_QUAL_TITL_RT_F ----------------------
13079: ---------------------------------------------------------------
13080: --
13081: hr_utility.set_location('START OF BEN_QUAL_TITL_RT_F ',100);
13082: for l_parent_rec in c_qtr_from_parent(l_VRBL_RT_PRFL_ID) loop
13083: --
13084: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
13085:

Line 13132: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);

13128: l_mapping_column_name1,
13129: l_mapping_column_name2,
13130: p_copy_entity_txn_id);
13131: --
13132: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
13133: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
13134: --
13135:
13136: l_copy_entity_result_id := null;

Line 13133: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);

13129: l_mapping_column_name2,
13130: p_copy_entity_txn_id);
13131: --
13132: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
13133: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
13134: --
13135:
13136: l_copy_entity_result_id := null;
13137: l_object_version_number := null;

Line 13213: hr_utility.set_location('END OF BEN_QUAL_TITL_RT_F ',100);

13209: --
13210: end loop;
13211: --
13212: end loop;
13213: hr_utility.set_location('END OF BEN_QUAL_TITL_RT_F ',100);
13214: ---------------------------------------------------------------
13215: -- END OF BEN_QUAL_TITL_RT_F ----------------------
13216: ---------------------------------------------------------------
13217: ---------------------------------------------------------------

Line 15073: hr_utility.set_location(' end create_vapro_results ',100);

15069: ---------------------------------------------------------------
15070: ---------------------------------------------------------------
15071: -- END OF BEN_VRBL_RT_PRFL_F ----------------------
15072: ---------------------------------------------------------------
15073: hr_utility.set_location(' end create_vapro_results ',100);
15074: end create_vapro_results;
15075: --
15076: procedure create_bnft_pool_results
15077: (