DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on GHR_PAY_CALC

Line 187: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

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

Line 188: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

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

Line 500: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data

496: l_pay_calc_in_data.open_range_out_basic_pay := NULL;
497: END IF;
498:
499: BEGIN
500: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data
501: ,l_pay_calc_out_data
502: ,l_message_set
503: ,l_calculated);
504:

Line 512: g_proc := 'ghr_pay_calc';

508: l_mlcerrbuf := hr_utility.get_message;
509: END IF;
510: EXCEPTION
511: when mlc_error then
512: g_proc := 'ghr_pay_calc';
513: raise;
514: when others then
515: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then
516: l_comment := 'MLC:Error: Unadjusted Basic Pay must be entered in Employee record.';

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

511: when mlc_error then
512: g_proc := 'ghr_pay_calc';
513: raise;
514: when others then
515: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then
516: l_comment := 'MLC:Error: Unadjusted Basic Pay must be entered in Employee record.';
517: ELSE
518: l_comment := 'MLC:Error: See process log for details.';
519: END IF;

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

589: ins_upd_per_extra_info
590: (per.person_id,l_effective_date, l_sel_flg, l_comment,p_mass_salary_id);
591: l_comment := NULL;
592: ------ BUG 3287299 End
593: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
594: 'Err is '||sqlerrm(sqlcode),20);
595: l_mlcerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
596: g_proc := 'ghr_pay_calc';
597: raise mlc_error;

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

591: l_comment := NULL;
592: ------ BUG 3287299 End
593: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
594: 'Err is '||sqlerrm(sqlcode),20);
595: l_mlcerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
596: g_proc := 'ghr_pay_calc';
597: raise mlc_error;
598: END;
599:

Line 596: g_proc := 'ghr_pay_calc';

592: ------ BUG 3287299 End
593: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
594: 'Err is '||sqlerrm(sqlcode),20);
595: l_mlcerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
596: g_proc := 'ghr_pay_calc';
597: raise mlc_error;
598: END;
599:
600: l_new_basic_pay := l_pay_calc_out_data.basic_pay;

Line 1388: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

1384:
1385: l_pos_ei_data per_position_extra_info%rowtype;
1386: l_pos_grp1_rec per_position_extra_info%rowtype;
1387:
1388: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
1389: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
1390: l_sel_flg varchar2(2);
1391:
1392: l_first_action_la_code1 varchar2(30);

Line 1389: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

1385: l_pos_ei_data per_position_extra_info%rowtype;
1386: l_pos_grp1_rec per_position_extra_info%rowtype;
1387:
1388: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
1389: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
1390: l_sel_flg varchar2(2);
1391:
1392: l_first_action_la_code1 varchar2(30);
1393: l_first_action_la_code2 varchar2(30);

Line 1730: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data

1726: l_comments,p_mass_salary_id);
1727: l_comments := NULL;
1728:
1729: begin
1730: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data
1731: ,l_pay_calc_out_data
1732: ,l_message_set
1733: ,l_calculated);
1734:

Line 1743: g_proc := 'ghr_pay_calc';

1739: -- raise mtc_error;
1740: END IF;
1741: exception
1742: when mtc_error then
1743: g_proc := 'ghr_pay_calc';
1744: raise;
1745: when others then
1746: ----BUG 3287299 Start
1747: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then

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

1743: g_proc := 'ghr_pay_calc';
1744: raise;
1745: when others then
1746: ----BUG 3287299 Start
1747: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' then
1748: l_comment := 'MSL:Error: Unadjusted Basic Pay must be entered in Employee record.';
1749: ELSE
1750: l_comment := 'MSL:Error: See process log for details.';
1751: END IF;

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

1815: ins_upd_per_extra_info
1816: (p_person_id,l_effective_date, l_sel_flg, l_comments,p_mass_salary_id);
1817: l_comment := NULL;
1818: ------ BUG 3287299 End
1819: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
1820: 'Err is '||sqlerrm(sqlcode),20);
1821: l_mtcerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
1822: g_proc := 'ghr_pay_calc';
1823: raise mtc_error;

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

1817: l_comment := NULL;
1818: ------ BUG 3287299 End
1819: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
1820: 'Err is '||sqlerrm(sqlcode),20);
1821: l_mtcerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
1822: g_proc := 'ghr_pay_calc';
1823: raise mtc_error;
1824: end;
1825:

Line 1822: g_proc := 'ghr_pay_calc';

1818: ------ BUG 3287299 End
1819: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
1820: 'Err is '||sqlerrm(sqlcode),20);
1821: l_mtcerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
1822: g_proc := 'ghr_pay_calc';
1823: raise mtc_error;
1824: end;
1825:
1826: l_new_basic_pay := l_pay_calc_out_data.basic_pay;

Line 2520: ghr_pay_calc.get_special_pay_table_value

2516: ,p_mass_salary_id
2517: ,l_sel_flg);
2518:
2519: hr_utility.set_location('Entering Before get_special_table_pay_table_value ' || l_proc,60);
2520: ghr_pay_calc.get_special_pay_table_value
2521: (p_pay_plan => l_pay_plan
2522: ,p_grade_or_level => l_grade_or_level
2523: ,p_step_or_rate => null
2524: ,p_user_table_id => l_user_table_id

Line 2534: IF ghr_pay_calc.LEO_position (l_dummy

2530: --
2531:
2532: --5 pp_grd check
2533: IF NOT l_pp_grd_exists THEN
2534: IF ghr_pay_calc.LEO_position (l_dummy
2535: ,l_position_id
2536: ,l_dummy
2537: ,l_dummy
2538: ,l_effective_date) AND l_grade_or_level between 03 and 10 THEN

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 3868: WHEN GHR_PAY_CALC.PAY_CALC_MESSAGE THEN

3864: return 'REGULAR';
3865: end if;
3866: -- Bug 3315432 Need to write into process log if retained grade record is expired
3867: EXCEPTION
3868: WHEN GHR_PAY_CALC.PAY_CALC_MESSAGE THEN
3869: raise mlc_error;
3870: WHEN OTHERS THEN
3871: raise;
3872: END;

Line 4367: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

4363: l_cust_in_rec ghr_mass_act_custom.ghr_mass_custom_in_rec_type;
4364: l_poi_desc varchar2(80);
4365: ----Temp Promo Changes.
4366: l_step_or_rate varchar2(30);
4367: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
4368: l_check_grade_retention varchar2(30);
4369: begin
4370: g_proc := 'create_mass_act_prev';
4371: hr_utility.set_location('Entering ' || l_proc,5);

Line 4417: when ghr_pay_calc.pay_calc_message THEN

4413: if l_retained_grade_rec.temp_step is not null then
4414: l_step_or_rate := l_retained_grade_rec.temp_step;
4415: end if;
4416: exception
4417: when ghr_pay_calc.pay_calc_message THEN
4418: l_mlcerrbuf := ' Retained Grade record is invalid for this Employee ';
4419: raise mlc_error;
4420: when others then
4421: l_mlcerrbuf := 'Preview - Others error in Get retained grade '||

Line 4688: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

4684: l_cust_in_rec ghr_mass_act_custom.ghr_mass_custom_in_rec_type;
4685: l_poi_desc varchar2(80);
4686: ----Temp Promo Changes.
4687: l_step_or_rate varchar2(30);
4688: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
4689: l_check_grade_retention varchar2(30);
4690: begin
4691: g_proc := 'create_mass_act_prev';
4692: hr_utility.set_location('Entering ' || l_proc,5);

Line 4739: when ghr_pay_calc.pay_calc_message THEN

4735: if l_retained_grade_rec.temp_step is not null then
4736: l_step_or_rate := l_retained_grade_rec.temp_step;
4737: end if;
4738: exception
4739: when ghr_pay_calc.pay_calc_message THEN
4740: l_mlcerrbuf := ' Retained Grade record is invalid for this Employee ';
4741: raise mlc_error;
4742: when others then
4743: l_mlcerrbuf := 'Preview - Others error in Get retained grade '||