DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on GHR_PAY_CALC

Line 185: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

181:
182: l_pos_ei_data per_position_extra_info%rowtype;
183: l_pos_grp1_rec per_position_extra_info%rowtype;
184:
185: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
186: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
187: l_sel_flg varchar2(2);
188:
189: l_first_action_la_code1 varchar2(30);

Line 186: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

182: l_pos_ei_data per_position_extra_info%rowtype;
183: l_pos_grp1_rec per_position_extra_info%rowtype;
184:
185: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
186: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
187: l_sel_flg varchar2(2);
188:
189: l_first_action_la_code1 varchar2(30);
190: l_first_action_la_code2 varchar2(30);

Line 491: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data

487: l_pay_calc_in_data.open_range_out_basic_pay := NULL;
488: END IF;
489:
490: BEGIN
491: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data
492: ,l_pay_calc_out_data
493: ,l_message_set
494: ,l_calculated);
495:

Line 503: g_proc := 'ghr_pay_calc';

499: l_mlcerrbuf := hr_utility.get_message;
500: END IF;
501: EXCEPTION
502: when mlc_error then
503: g_proc := 'ghr_pay_calc';
504: raise;
505: when others then
506: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then
507: l_comment := 'MLC:Error: Unadjusted Basic Pay must be entered in Employee record.';

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

502: when mlc_error then
503: g_proc := 'ghr_pay_calc';
504: raise;
505: when others then
506: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then
507: l_comment := 'MLC:Error: Unadjusted Basic Pay must be entered in Employee record.';
508: ELSE
509: l_comment := 'MLC:Error: See process log for details.';
510: END IF;

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

578: ins_upd_per_extra_info
579: (per.person_id,l_effective_date, l_sel_flg, l_comment,p_mass_salary_id);
580: l_comment := NULL;
581: ------ BUG 3287299 End
582: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
583: 'Err is '||sqlerrm(sqlcode),20);
584: l_mlcerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
585: g_proc := 'ghr_pay_calc';
586: raise mlc_error;

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

580: l_comment := NULL;
581: ------ BUG 3287299 End
582: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
583: 'Err is '||sqlerrm(sqlcode),20);
584: l_mlcerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
585: g_proc := 'ghr_pay_calc';
586: raise mlc_error;
587: END;
588:

Line 585: g_proc := 'ghr_pay_calc';

581: ------ BUG 3287299 End
582: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
583: 'Err is '||sqlerrm(sqlcode),20);
584: l_mlcerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
585: g_proc := 'ghr_pay_calc';
586: raise mlc_error;
587: END;
588:
589: l_new_basic_pay := l_pay_calc_out_data.basic_pay;

Line 1362: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

1358:
1359: l_pos_ei_data per_position_extra_info%rowtype;
1360: l_pos_grp1_rec per_position_extra_info%rowtype;
1361:
1362: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
1363: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
1364: l_sel_flg varchar2(2);
1365:
1366: l_first_action_la_code1 varchar2(30);

Line 1363: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

1359: l_pos_ei_data per_position_extra_info%rowtype;
1360: l_pos_grp1_rec per_position_extra_info%rowtype;
1361:
1362: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
1363: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
1364: l_sel_flg varchar2(2);
1365:
1366: l_first_action_la_code1 varchar2(30);
1367: l_first_action_la_code2 varchar2(30);

Line 1701: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data

1697: l_comments,p_mass_salary_id);
1698: l_comments := NULL;
1699:
1700: begin
1701: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data
1702: ,l_pay_calc_out_data
1703: ,l_message_set
1704: ,l_calculated);
1705:

Line 1714: g_proc := 'ghr_pay_calc';

1710: -- raise mtc_error;
1711: END IF;
1712: exception
1713: when mtc_error then
1714: g_proc := 'ghr_pay_calc';
1715: raise;
1716: when others then
1717: ----BUG 3287299 Start
1718: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then

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

1714: g_proc := 'ghr_pay_calc';
1715: raise;
1716: when others then
1717: ----BUG 3287299 Start
1718: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then
1719: l_comment := 'MSL:Error: Unadjusted Basic Pay must be entered in Employee record.';
1720: ELSE
1721: l_comment := 'MSL:Error: See process log for details.';
1722: END IF;

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

1784: ins_upd_per_extra_info
1785: (p_person_id,l_effective_date, l_sel_flg, l_comments,p_mass_salary_id);
1786: l_comment := NULL;
1787: ------ BUG 3287299 End
1788: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
1789: 'Err is '||sqlerrm(sqlcode),20);
1790: l_mtcerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
1791: g_proc := 'ghr_pay_calc';
1792: raise mtc_error;

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

1786: l_comment := NULL;
1787: ------ BUG 3287299 End
1788: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
1789: 'Err is '||sqlerrm(sqlcode),20);
1790: l_mtcerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
1791: g_proc := 'ghr_pay_calc';
1792: raise mtc_error;
1793: end;
1794:

Line 1791: g_proc := 'ghr_pay_calc';

1787: ------ BUG 3287299 End
1788: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
1789: 'Err is '||sqlerrm(sqlcode),20);
1790: l_mtcerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
1791: g_proc := 'ghr_pay_calc';
1792: raise mtc_error;
1793: end;
1794:
1795: l_new_basic_pay := l_pay_calc_out_data.basic_pay;

Line 2480: ghr_pay_calc.get_special_pay_table_value

2476: ,p_mass_salary_id
2477: ,l_sel_flg);
2478:
2479: hr_utility.set_location('Entering Before get_special_table_pay_table_value ' || l_proc,60);
2480: ghr_pay_calc.get_special_pay_table_value
2481: (p_pay_plan => l_pay_plan
2482: ,p_grade_or_level => l_grade_or_level
2483: ,p_step_or_rate => null
2484: ,p_user_table_id => l_user_table_id

Line 2494: IF ghr_pay_calc.LEO_position (l_dummy

2490: --
2491:
2492: --5 pp_grd check
2493: IF NOT l_pp_grd_exists THEN
2494: IF ghr_pay_calc.LEO_position (l_dummy
2495: ,l_position_id
2496: ,l_dummy
2497: ,l_dummy
2498: ,l_effective_date) AND l_grade_or_level between 03 and 10 THEN

Line 3802: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

3798: FUNCTION check_grade_retention(p_prd in varchar2
3799: ,p_person_id in number
3800: ,p_effective_date in date) return varchar2 is
3801:
3802: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
3803: l_per_ei_data per_people_extra_info%rowtype;
3804:
3805: l_proc varchar2(72) := g_package || '.check_grade_retention';
3806:

Line 3822: WHEN GHR_PAY_CALC.PAY_CALC_MESSAGE THEN

3818: return 'REGULAR';
3819: end if;
3820: -- Bug 3315432 Need to write into process log if retained grade record is expired
3821: EXCEPTION
3822: WHEN GHR_PAY_CALC.PAY_CALC_MESSAGE THEN
3823: raise mlc_error;
3824: WHEN OTHERS THEN
3825: raise;
3826: END;

Line 4319: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

4315: l_cust_in_rec ghr_mass_act_custom.ghr_mass_custom_in_rec_type;
4316: l_poi_desc varchar2(80);
4317: ----Temp Promo Changes.
4318: l_step_or_rate varchar2(30);
4319: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
4320: l_check_grade_retention varchar2(30);
4321: begin
4322: g_proc := 'create_mass_act_prev';
4323: hr_utility.set_location('Entering ' || l_proc,5);

Line 4369: when ghr_pay_calc.pay_calc_message THEN

4365: if l_retained_grade_rec.temp_step is not null then
4366: l_step_or_rate := l_retained_grade_rec.temp_step;
4367: end if;
4368: exception
4369: when ghr_pay_calc.pay_calc_message THEN
4370: l_mlcerrbuf := ' Retained Grade record is invalid for this Employee ';
4371: raise mlc_error;
4372: when others then
4373: l_mlcerrbuf := 'Preview - Others error in Get retained grade '||

Line 4634: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

4630: l_cust_in_rec ghr_mass_act_custom.ghr_mass_custom_in_rec_type;
4631: l_poi_desc varchar2(80);
4632: ----Temp Promo Changes.
4633: l_step_or_rate varchar2(30);
4634: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
4635: l_check_grade_retention varchar2(30);
4636: begin
4637: g_proc := 'create_mass_act_prev';
4638: hr_utility.set_location('Entering ' || l_proc,5);

Line 4685: when ghr_pay_calc.pay_calc_message THEN

4681: if l_retained_grade_rec.temp_step is not null then
4682: l_step_or_rate := l_retained_grade_rec.temp_step;
4683: end if;
4684: exception
4685: when ghr_pay_calc.pay_calc_message THEN
4686: l_mlcerrbuf := ' Retained Grade record is invalid for this Employee ';
4687: raise mlc_error;
4688: when others then
4689: l_mlcerrbuf := 'Preview - Others error in Get retained grade '||