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 300: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

296:
297: l_pos_ei_data per_position_extra_info%rowtype;
298: l_pos_grp1_rec per_position_extra_info%rowtype;
299:
300: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
301: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
302: l_sel_flg varchar2(2);
303:
304: l_first_action_la_code1 varchar2(30);

Line 301: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

297: l_pos_ei_data per_position_extra_info%rowtype;
298: l_pos_grp1_rec per_position_extra_info%rowtype;
299:
300: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
301: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
302: l_sel_flg varchar2(2);
303:
304: l_first_action_la_code1 varchar2(30);
305: l_first_action_la_code2 varchar2(30);

Line 703: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data

699: l_step_or_rate := '00';
700: END IF;
701:
702: BEGIN
703: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data
704: ,l_pay_calc_out_data
705: ,l_message_set
706: ,l_calculated);
707:

Line 716: g_proc := 'ghr_pay_calc';

712: -- raise msl_error;
713: END IF;
714: EXCEPTION
715: when msl_error then
716: g_proc := 'ghr_pay_calc';
717: raise;
718: when others then
719: ----BUG 3287299 Start
720: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then

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

716: g_proc := 'ghr_pay_calc';
717: raise;
718: when others then
719: ----BUG 3287299 Start
720: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then
721: l_comment := 'MSL:Error: Unadjusted Basic Pay must be entered in Employee record.';
722: ELSE
723: l_comment := 'MSL:Error: See process log for details.';
724: END IF;

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

795: ins_upd_per_extra_info
796: (p_person_id,l_effective_date, l_sel_flg, l_comment,p_mass_salary_id);
797: l_comment := NULL;
798: ------ BUG 3287299 End
799: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
800: 'Err is '||sqlerrm(sqlcode),20);
801: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
802: g_proc := 'ghr_pay_calc';
803: raise msl_error;

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

797: l_comment := NULL;
798: ------ BUG 3287299 End
799: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
800: 'Err is '||sqlerrm(sqlcode),20);
801: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
802: g_proc := 'ghr_pay_calc';
803: raise msl_error;
804: END;
805:

Line 802: g_proc := 'ghr_pay_calc';

798: ------ BUG 3287299 End
799: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
800: 'Err is '||sqlerrm(sqlcode),20);
801: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
802: g_proc := 'ghr_pay_calc';
803: raise msl_error;
804: END;
805:
806: ghr_msl_pkg.g_ses_msl_process := 'N';

Line 2176: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

2172: per_grade_definitions gdf
2173: where grd.grade_id = grd_id
2174: and grd.grade_definition_id = gdf.grade_definition_id;
2175:
2176: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2177: l_proc varchar2(72) := g_package || '.get_pay_plan_and_table_id';
2178: l_line number := 0;
2179: l_check_grade_retention VARCHAR2(200);
2180: BEGIN

Line 2288: WHEN ghr_pay_calc.pay_calc_message THEN

2284: p_pay_basis := l_retained_grade_rec.pay_basis;
2285: p_pay_table_id := l_retained_grade_rec.user_table_id;
2286: -- p_locality_percent := l_retained_grade_rec.locality_percent; --AVR 12/08/98
2287: EXCEPTION
2288: WHEN ghr_pay_calc.pay_calc_message THEN
2289: IF p_action = 'CREATE' THEN
2290: l_mslerrbuf := 'Error in Get retained grade for Person ID'||
2291: to_char(p_person_id)||
2292: 'Error is '||' Sql Err is '|| sqlerrm(sqlcode);

Line 2355: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

2351: per_grade_definitions gdf
2352: where grd.grade_id = grd_id
2353: and grd.grade_definition_id = gdf.grade_definition_id;
2354:
2355: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2356: l_proc varchar2(72) := g_package || '.get_pay_plan_and_table_id';
2357: l_line number := 0;
2358: l_check_grade_retention VARCHAR2(200);
2359: BEGIN

Line 2493: WHEN ghr_pay_calc.pay_calc_message THEN

2489: p_pay_basis := l_retained_grade_rec.pay_basis;
2490: p_pay_table_id := l_retained_grade_rec.user_table_id;
2491: -- p_locality_percent := l_retained_grade_rec.locality_percent; --AVR 12/08/98
2492: EXCEPTION
2493: WHEN ghr_pay_calc.pay_calc_message THEN
2494: IF p_action = 'CREATE' THEN
2495: l_mslerrbuf := 'Error in Get retained grade for Person ID'||
2496: to_char(p_person_id)||
2497: 'Error is '||' Sql Err is '|| sqlerrm(sqlcode);

Line 2900: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

2896: l_position_title VARCHAR2(300);
2897: l_position_number VARCHAR2(20);
2898: l_position_seq_no VARCHAR2(20);
2899: l_log_text VARCHAR2(2000) := null;
2900: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2901: l_fetch_poid_data BOOLEAN := FALSE;
2902: l_fetch_ds_data BOOLEAN := FALSE;
2903: l_fetch_agency_data BOOLEAN := FALSE;
2904: init_elig_flag BOOLEAN := FALSE;

Line 3261: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

3257: l_position_title VARCHAR2(300);
3258: l_position_number VARCHAR2(20);
3259: l_position_seq_no VARCHAR2(20);
3260: l_log_text VARCHAR2(2000) := null;
3261: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
3262: l_fetch_poid_data BOOLEAN := FALSE;
3263: l_fetch_ds_data BOOLEAN := FALSE;
3264: l_fetch_agency_data BOOLEAN := FALSE;
3265: init_elig_flag BOOLEAN := FALSE;

Line 3900: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

3896: FUNCTION check_grade_retention(p_prd in varchar2
3897: ,p_person_id in number
3898: ,p_effective_date in date) return varchar2 is
3899:
3900: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
3901: l_per_ei_data per_people_extra_info%rowtype;
3902:
3903: l_proc varchar2(72) := g_package || '.check_grade_retention';
3904:

Line 3922: WHEN ghr_pay_calc.pay_calc_message THEN

3918: IF l_retained_grade_rec.temp_step is not null THEN
3919: return 'REGULAR';
3920: END IF;
3921: EXCEPTION
3922: WHEN ghr_pay_calc.pay_calc_message THEN
3923: raise msl_error;
3924: WHEN OTHERS THEN
3925: raise;
3926: END;

Line 4424: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

4420: l_cust_in_rec ghr_mass_act_custom.ghr_mass_custom_in_rec_type;
4421: l_poi_desc varchar2(80);
4422: ----Temp Promo Changes.
4423: l_step_or_rate varchar2(30);
4424: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
4425: -- Bug# 4126137,4179270,4086677
4426: l_check_grade_retention VARCHAR2(200);
4427:
4428: begin

Line 5195: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

5191:
5192: l_pos_ei_data per_position_extra_info%rowtype;
5193: l_pos_grp1_rec per_position_extra_info%rowtype;
5194:
5195: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
5196: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
5197: l_sel_flg varchar2(2);
5198:
5199: l_first_action_la_code1 varchar2(30);

Line 5196: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

5192: l_pos_ei_data per_position_extra_info%rowtype;
5193: l_pos_grp1_rec per_position_extra_info%rowtype;
5194:
5195: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
5196: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
5197: l_sel_flg varchar2(2);
5198:
5199: l_first_action_la_code1 varchar2(30);
5200: l_first_action_la_code2 varchar2(30);

Line 5700: ghr_pay_calc.get_open_pay_table_values

5696: l_comments,p_mass_salary_id,l_cust_percent,l_ses_basic_pay); -- Added by AVR 3964284
5697: l_comments := NULL;
5698:
5699: -- Recalculate Open range basic pay with new %.
5700: ghr_pay_calc.get_open_pay_table_values
5701: (p_user_table_id => l_pay_table_id
5702: ,p_pay_plan => l_pay_plan
5703: ,p_grade_or_level => l_grade_or_level
5704: ,p_effective_date => NVL(l_effective_date,TRUNC(sysdate))

Line 5742: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data

5738:
5739: -- 3843306
5740: -- End of MSL percentage Changes
5741: begin
5742: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data
5743: ,l_pay_calc_out_data
5744: ,l_message_set
5745: ,l_calculated);
5746:

Line 5755: g_proc := 'ghr_pay_calc';

5751: -- raise msl_error;
5752: END IF;
5753: exception
5754: when msl_error then
5755: g_proc := 'ghr_pay_calc';
5756: raise;
5757: when others then
5758: ----BUG 3287299 Start
5759: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then

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

5755: g_proc := 'ghr_pay_calc';
5756: raise;
5757: when others then
5758: ----BUG 3287299 Start
5759: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then
5760: l_comment := 'MSL:Error: Unadjusted Basic Pay must be entered in Employee record.';
5761: ELSE
5762: l_comment := 'MSL:Error: See process log for details.';
5763: END IF;

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

5834: ins_upd_per_extra_info
5835: (p_person_id,l_effective_date, l_sel_flg, l_comments,p_mass_salary_id,l_cust_percent);
5836: l_comment := NULL;
5837: ------ BUG 3287299 End
5838: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
5839: 'Err is '||sqlerrm(sqlcode),20);
5840: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
5841: g_proc := 'ghr_pay_calc';
5842: raise msl_error;

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

5836: l_comment := NULL;
5837: ------ BUG 3287299 End
5838: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
5839: 'Err is '||sqlerrm(sqlcode),20);
5840: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
5841: g_proc := 'ghr_pay_calc';
5842: raise msl_error;
5843: end;
5844:

Line 5841: g_proc := 'ghr_pay_calc';

5837: ------ BUG 3287299 End
5838: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
5839: 'Err is '||sqlerrm(sqlcode),20);
5840: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
5841: g_proc := 'ghr_pay_calc';
5842: raise msl_error;
5843: end;
5844:
5845: ghr_msl_pkg.g_ses_msl_process := 'N';

Line 6797: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

6793: l_position_title VARCHAR2(300);
6794: l_position_number VARCHAR2(20);
6795: l_position_seq_no VARCHAR2(20);
6796: l_log_text VARCHAR2(2000) := null;
6797: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
6798: l_fetch_poid_data BOOLEAN := FALSE;
6799: l_fetch_ds_data BOOLEAN := FALSE;
6800: l_fetch_agency_data BOOLEAN := FALSE;
6801: init_elig_flag BOOLEAN := FALSE;

Line 7336: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

7332:
7333: l_pos_ei_data per_position_extra_info%rowtype;
7334: l_pos_grp1_rec per_position_extra_info%rowtype;
7335:
7336: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
7337: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
7338: l_sel_flg varchar2(2);
7339:
7340: l_first_action_la_code1 varchar2(30);

Line 7337: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

7333: l_pos_ei_data per_position_extra_info%rowtype;
7334: l_pos_grp1_rec per_position_extra_info%rowtype;
7335:
7336: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
7337: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
7338: l_sel_flg varchar2(2);
7339:
7340: l_first_action_la_code1 varchar2(30);
7341: l_first_action_la_code2 varchar2(30);

Line 7739: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data

7735: l_step_or_rate := '00';
7736: END IF;
7737:
7738: BEGIN
7739: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data
7740: ,l_pay_calc_out_data
7741: ,l_message_set
7742: ,l_calculated);
7743:

Line 7752: g_proc := 'ghr_pay_calc';

7748: -- raise msl_error;
7749: END IF;
7750: EXCEPTION
7751: when msl_error then
7752: g_proc := 'ghr_pay_calc';
7753: raise;
7754: when others then
7755: ----BUG 3287299 Start
7756: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then

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

7752: g_proc := 'ghr_pay_calc';
7753: raise;
7754: when others then
7755: ----BUG 3287299 Start
7756: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then
7757: l_comment := 'MSL:Error: Unadjusted Basic Pay must be entered in Employee record.';
7758: ELSE
7759: l_comment := 'MSL:Error: See process log for details.';
7760: END IF;

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

7830: ins_upd_per_ses_extra_info
7831: (p_person_id,l_effective_date, l_sel_flg, l_comment,p_mass_salary_id);
7832: l_comment := NULL;
7833: ------ BUG 3287299 End
7834: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
7835: 'Err is '||sqlerrm(sqlcode),20);
7836: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
7837: g_proc := 'ghr_pay_calc';
7838: raise msl_error;

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

7832: l_comment := NULL;
7833: ------ BUG 3287299 End
7834: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
7835: 'Err is '||sqlerrm(sqlcode),20);
7836: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
7837: g_proc := 'ghr_pay_calc';
7838: raise msl_error;
7839: END;
7840:

Line 7837: g_proc := 'ghr_pay_calc';

7833: ------ BUG 3287299 End
7834: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
7835: 'Err is '||sqlerrm(sqlcode),20);
7836: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
7837: g_proc := 'ghr_pay_calc';
7838: raise msl_error;
7839: END;
7840:
7841: ghr_msl_pkg.g_ses_msl_process := 'N';