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.GHR_MSL_PKG dependencies on GHR_PAY_CALC

Line 296: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

292:
293: l_pos_ei_data per_position_extra_info%rowtype;
294: l_pos_grp1_rec per_position_extra_info%rowtype;
295:
296: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
297: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
298: l_sel_flg varchar2(2);
299:
300: l_first_action_la_code1 varchar2(30);

Line 297: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

293: l_pos_ei_data per_position_extra_info%rowtype;
294: l_pos_grp1_rec per_position_extra_info%rowtype;
295:
296: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
297: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
298: l_sel_flg varchar2(2);
299:
300: l_first_action_la_code1 varchar2(30);
301: l_first_action_la_code2 varchar2(30);

Line 696: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data

692: l_step_or_rate := '00';
693: END IF;
694:
695: BEGIN
696: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data
697: ,l_pay_calc_out_data
698: ,l_message_set
699: ,l_calculated);
700:

Line 709: g_proc := 'ghr_pay_calc';

705: -- raise msl_error;
706: END IF;
707: EXCEPTION
708: when msl_error then
709: g_proc := 'ghr_pay_calc';
710: raise;
711: when others then
712: ----BUG 3287299 Start
713: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then

Line 713: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then

709: g_proc := 'ghr_pay_calc';
710: raise;
711: when others then
712: ----BUG 3287299 Start
713: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then
714: l_comment := 'MSL:Error: Unadjusted Basic Pay must be entered in Employee record.';
715: ELSE
716: l_comment := 'MSL:Error: See process log for details.';
717: END IF;

Line 789: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||

785: ins_upd_per_extra_info
786: (p_person_id,l_effective_date, l_sel_flg, l_comment,p_mass_salary_id);
787: l_comment := NULL;
788: ------ BUG 3287299 End
789: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
790: 'Err is '||sqlerrm(sqlcode),20);
791: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
792: g_proc := 'ghr_pay_calc';
793: raise msl_error;

Line 791: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);

787: l_comment := NULL;
788: ------ BUG 3287299 End
789: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
790: 'Err is '||sqlerrm(sqlcode),20);
791: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
792: g_proc := 'ghr_pay_calc';
793: raise msl_error;
794: END;
795:

Line 792: g_proc := 'ghr_pay_calc';

788: ------ BUG 3287299 End
789: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
790: 'Err is '||sqlerrm(sqlcode),20);
791: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
792: g_proc := 'ghr_pay_calc';
793: raise msl_error;
794: END;
795:
796: ghr_msl_pkg.g_ses_msl_process := 'N';

Line 2148: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

2144: per_grade_definitions gdf
2145: where grd.grade_id = grd_id
2146: and grd.grade_definition_id = gdf.grade_definition_id;
2147:
2148: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2149: l_proc varchar2(72) := g_package || '.get_pay_plan_and_table_id';
2150: l_line number := 0;
2151: l_check_grade_retention VARCHAR2(200);
2152: BEGIN

Line 2260: WHEN ghr_pay_calc.pay_calc_message THEN

2256: p_pay_basis := l_retained_grade_rec.pay_basis;
2257: p_pay_table_id := l_retained_grade_rec.user_table_id;
2258: -- p_locality_percent := l_retained_grade_rec.locality_percent; --AVR 12/08/98
2259: EXCEPTION
2260: WHEN ghr_pay_calc.pay_calc_message THEN
2261: IF p_action = 'CREATE' THEN
2262: l_mslerrbuf := 'Error in Get retained grade for Person ID'||
2263: to_char(p_person_id)||
2264: 'Error is '||' Sql Err is '|| sqlerrm(sqlcode);

Line 2327: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

2323: per_grade_definitions gdf
2324: where grd.grade_id = grd_id
2325: and grd.grade_definition_id = gdf.grade_definition_id;
2326:
2327: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2328: l_proc varchar2(72) := g_package || '.get_pay_plan_and_table_id';
2329: l_line number := 0;
2330: l_check_grade_retention VARCHAR2(200);
2331: BEGIN

Line 2465: WHEN ghr_pay_calc.pay_calc_message THEN

2461: p_pay_basis := l_retained_grade_rec.pay_basis;
2462: p_pay_table_id := l_retained_grade_rec.user_table_id;
2463: -- p_locality_percent := l_retained_grade_rec.locality_percent; --AVR 12/08/98
2464: EXCEPTION
2465: WHEN ghr_pay_calc.pay_calc_message THEN
2466: IF p_action = 'CREATE' THEN
2467: l_mslerrbuf := 'Error in Get retained grade for Person ID'||
2468: to_char(p_person_id)||
2469: 'Error is '||' Sql Err is '|| sqlerrm(sqlcode);

Line 2870: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

2866: l_position_title VARCHAR2(300);
2867: l_position_number VARCHAR2(20);
2868: l_position_seq_no VARCHAR2(20);
2869: l_log_text VARCHAR2(2000) := null;
2870: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2871: l_fetch_poid_data BOOLEAN := FALSE;
2872: l_fetch_ds_data BOOLEAN := FALSE;
2873: l_fetch_agency_data BOOLEAN := FALSE;
2874: init_elig_flag BOOLEAN := FALSE;

Line 3228: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

3224: l_position_title VARCHAR2(300);
3225: l_position_number VARCHAR2(20);
3226: l_position_seq_no VARCHAR2(20);
3227: l_log_text VARCHAR2(2000) := null;
3228: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
3229: l_fetch_poid_data BOOLEAN := FALSE;
3230: l_fetch_ds_data BOOLEAN := FALSE;
3231: l_fetch_agency_data BOOLEAN := FALSE;
3232: init_elig_flag BOOLEAN := FALSE;

Line 3848: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

3844: FUNCTION check_grade_retention(p_prd in varchar2
3845: ,p_person_id in number
3846: ,p_effective_date in date) return varchar2 is
3847:
3848: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
3849: l_per_ei_data per_people_extra_info%rowtype;
3850:
3851: l_proc varchar2(72) := g_package || '.check_grade_retention';
3852:

Line 3870: WHEN ghr_pay_calc.pay_calc_message THEN

3866: IF l_retained_grade_rec.temp_step is not null THEN
3867: return 'REGULAR';
3868: END IF;
3869: EXCEPTION
3870: WHEN ghr_pay_calc.pay_calc_message THEN
3871: raise msl_error;
3872: WHEN OTHERS THEN
3873: raise;
3874: END;

Line 4370: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

4366: l_cust_in_rec ghr_mass_act_custom.ghr_mass_custom_in_rec_type;
4367: l_poi_desc varchar2(80);
4368: ----Temp Promo Changes.
4369: l_step_or_rate varchar2(30);
4370: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
4371: -- Bug# 4126137,4179270,4086677
4372: l_check_grade_retention VARCHAR2(200);
4373:
4374: begin

Line 5133: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

5129:
5130: l_pos_ei_data per_position_extra_info%rowtype;
5131: l_pos_grp1_rec per_position_extra_info%rowtype;
5132:
5133: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
5134: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
5135: l_sel_flg varchar2(2);
5136:
5137: l_first_action_la_code1 varchar2(30);

Line 5134: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

5130: l_pos_ei_data per_position_extra_info%rowtype;
5131: l_pos_grp1_rec per_position_extra_info%rowtype;
5132:
5133: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
5134: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
5135: l_sel_flg varchar2(2);
5136:
5137: l_first_action_la_code1 varchar2(30);
5138: l_first_action_la_code2 varchar2(30);

Line 5589: ghr_pay_calc.get_open_pay_table_values

5585: l_comments,p_mass_salary_id,l_cust_percent,l_ses_basic_pay); -- Added by AVR 3964284
5586: l_comments := NULL;
5587:
5588: -- Recalculate Open range basic pay with new %.
5589: ghr_pay_calc.get_open_pay_table_values
5590: (p_user_table_id => l_pay_table_id
5591: ,p_pay_plan => l_pay_plan
5592: ,p_grade_or_level => l_grade_or_level
5593: ,p_effective_date => NVL(l_effective_date,TRUNC(sysdate))

Line 5631: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data

5627:
5628: -- 3843306
5629: -- End of MSL percentage Changes
5630: begin
5631: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data
5632: ,l_pay_calc_out_data
5633: ,l_message_set
5634: ,l_calculated);
5635:

Line 5644: g_proc := 'ghr_pay_calc';

5640: -- raise msl_error;
5641: END IF;
5642: exception
5643: when msl_error then
5644: g_proc := 'ghr_pay_calc';
5645: raise;
5646: when others then
5647: ----BUG 3287299 Start
5648: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then

Line 5648: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then

5644: g_proc := 'ghr_pay_calc';
5645: raise;
5646: when others then
5647: ----BUG 3287299 Start
5648: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then
5649: l_comment := 'MSL:Error: Unadjusted Basic Pay must be entered in Employee record.';
5650: ELSE
5651: l_comment := 'MSL:Error: See process log for details.';
5652: END IF;

Line 5725: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||

5721: ins_upd_per_extra_info
5722: (p_person_id,l_effective_date, l_sel_flg, l_comments,p_mass_salary_id,l_cust_percent);
5723: l_comment := NULL;
5724: ------ BUG 3287299 End
5725: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
5726: 'Err is '||sqlerrm(sqlcode),20);
5727: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
5728: g_proc := 'ghr_pay_calc';
5729: raise msl_error;

Line 5727: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);

5723: l_comment := NULL;
5724: ------ BUG 3287299 End
5725: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
5726: 'Err is '||sqlerrm(sqlcode),20);
5727: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
5728: g_proc := 'ghr_pay_calc';
5729: raise msl_error;
5730: end;
5731:

Line 5728: g_proc := 'ghr_pay_calc';

5724: ------ BUG 3287299 End
5725: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
5726: 'Err is '||sqlerrm(sqlcode),20);
5727: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
5728: g_proc := 'ghr_pay_calc';
5729: raise msl_error;
5730: end;
5731:
5732: ghr_msl_pkg.g_ses_msl_process := 'N';

Line 6656: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

6652: l_position_title VARCHAR2(300);
6653: l_position_number VARCHAR2(20);
6654: l_position_seq_no VARCHAR2(20);
6655: l_log_text VARCHAR2(2000) := null;
6656: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
6657: l_fetch_poid_data BOOLEAN := FALSE;
6658: l_fetch_ds_data BOOLEAN := FALSE;
6659: l_fetch_agency_data BOOLEAN := FALSE;
6660: init_elig_flag BOOLEAN := FALSE;

Line 7190: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

7186:
7187: l_pos_ei_data per_position_extra_info%rowtype;
7188: l_pos_grp1_rec per_position_extra_info%rowtype;
7189:
7190: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
7191: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
7192: l_sel_flg varchar2(2);
7193:
7194: l_first_action_la_code1 varchar2(30);

Line 7191: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

7187: l_pos_ei_data per_position_extra_info%rowtype;
7188: l_pos_grp1_rec per_position_extra_info%rowtype;
7189:
7190: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
7191: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
7192: l_sel_flg varchar2(2);
7193:
7194: l_first_action_la_code1 varchar2(30);
7195: l_first_action_la_code2 varchar2(30);

Line 7591: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data

7587: l_step_or_rate := '00';
7588: END IF;
7589:
7590: BEGIN
7591: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data
7592: ,l_pay_calc_out_data
7593: ,l_message_set
7594: ,l_calculated);
7595:

Line 7604: g_proc := 'ghr_pay_calc';

7600: -- raise msl_error;
7601: END IF;
7602: EXCEPTION
7603: when msl_error then
7604: g_proc := 'ghr_pay_calc';
7605: raise;
7606: when others then
7607: ----BUG 3287299 Start
7608: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then

Line 7608: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then

7604: g_proc := 'ghr_pay_calc';
7605: raise;
7606: when others then
7607: ----BUG 3287299 Start
7608: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then
7609: l_comment := 'MSL:Error: Unadjusted Basic Pay must be entered in Employee record.';
7610: ELSE
7611: l_comment := 'MSL:Error: See process log for details.';
7612: END IF;

Line 7684: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||

7680: ins_upd_per_ses_extra_info
7681: (p_person_id,l_effective_date, l_sel_flg, l_comment,p_mass_salary_id);
7682: l_comment := NULL;
7683: ------ BUG 3287299 End
7684: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
7685: 'Err is '||sqlerrm(sqlcode),20);
7686: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
7687: g_proc := 'ghr_pay_calc';
7688: raise msl_error;

Line 7686: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);

7682: l_comment := NULL;
7683: ------ BUG 3287299 End
7684: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
7685: 'Err is '||sqlerrm(sqlcode),20);
7686: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
7687: g_proc := 'ghr_pay_calc';
7688: raise msl_error;
7689: END;
7690:

Line 7687: g_proc := 'ghr_pay_calc';

7683: ------ BUG 3287299 End
7684: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
7685: 'Err is '||sqlerrm(sqlcode),20);
7686: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
7687: g_proc := 'ghr_pay_calc';
7688: raise msl_error;
7689: END;
7690:
7691: ghr_msl_pkg.g_ses_msl_process := 'N';