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

Line 85: hr_utility.set_location('Entering ' ||l_proc,5);

81: l_to_grade_or_level ghr_pa_requests.to_grade_or_level%type;
82: -- Bug # 7269520
83:
84: begin
85: hr_utility.set_location('Entering ' ||l_proc,5);
86: --Added Condition for the bug 6398933
87: If NOT (p_first_noa_code in ('840','841','842','843','844','845','846','847','848','849','878','879','885','886','887','889')
88: or (p_first_noa_code = '002' and
89: p_second_noa_code in ('840','841','842','843','844','845','846','847','848','849','878','879','885','886','887','889'))

Line 109: hr_utility.set_location('From Global varaible Fetchig the retained Grade details ' ||l_proc,20);

105:
106: -- l_retained_grade_info := ghr_pc_basic_pay.get_retained_grade_details(p_person_id => p_person_id
107: -- ,p_effective_date => p_effective_date);
108:
109: hr_utility.set_location('From Global varaible Fetchig the retained Grade details ' ||l_proc,20);
110:
111: l_retained_grade_info := ghr_sf52_do_update.g_retained_grade_info;
112: -- l_retained_grade := l_retained_grade_info.grade_or_level||'-'||l_retained_grade_info.pay_plan;
113:

Line 117: hr_utility.set_location('l_retained_grade ' || l_retained_grade, 30);

113:
114: --Bug# 6075814 vmididho to display PayPlan-Gradeorlevel
115: l_retained_grade := l_retained_grade_info.pay_plan||'-'||l_retained_grade_info.grade_or_level;
116:
117: hr_utility.set_location('l_retained_grade ' || l_retained_grade, 30);
118:
119: /*l_description := REPLACE(SUBSTR(l_remark.description,0,INSTR(l_remark.description,'_',1)-1)||l_retained_grade||
120: SUBSTR(l_remark.description,INSTR(l_remark.description,'_',1)+ LENGTH(l_retained_grade),
121: (INSTR(l_remark.description,'_',INSTR(l_remark.description,'_',1)+10))- (INSTR(l_remark.description,'_',1)+ LENGTH(l_retained_grade)))||

Line 134: hr_utility.set_location('l_description ' || l_description, 40);

130: p_information5 => NULL,
131: p_desc_out => l_description
132: );
133:
134: hr_utility.set_location('l_description ' || l_description, 40);
135:
136: ghr_pa_remarks_api.create_pa_remarks
137: (p_validate => false
138: ,p_pa_request_id => p_pa_request_id

Line 337: hr_utility.set_location('Leaving ' || l_proc,100);

333: end loop;
334: end if;
335: -- Bug # 7573846
336:
337: hr_utility.set_location('Leaving ' || l_proc,100);
338: end Populate_Remarks;
339:
340:
341:

Line 543: hr_utility.set_location('Entering ' ||l_proc,5);

539: AND cin.user_column_id = col.user_column_id
540: AND NVL(p_imm_pa_request_rec.effective_date,TRUNC(SYSDATE)) BETWEEN cin.effective_start_date AND cin.effective_end_date;
541: --End Bug# 4691288
542: Begin
543: hr_utility.set_location('Entering ' ||l_proc,5);
544:
545: l_imm_pa_request_rec_in := p_imm_pa_request_rec; /* Added for NOCOPY changes */
546: l_capped_other_pay_in := p_capped_other_pay; /* Added for NOCOPY changes */
547:

Line 548: hr_utility.set_location(l_proc,10);

544:
545: l_imm_pa_request_rec_in := p_imm_pa_request_rec; /* Added for NOCOPY changes */
546: l_capped_other_pay_in := p_capped_other_pay; /* Added for NOCOPY changes */
547:
548: hr_utility.set_location(l_proc,10);
549: ghr_history_api.get_g_session_var(l_session);
550: IF l_session.noa_id_correct is null and
551: p_imm_pa_request_rec.first_noa_code = '866' THEN
552: g_effective_date := p_imm_pa_request_rec.effective_date + 1;

Line 643: hr_utility.set_location(l_proc,15);

639:
640: -- Populate all necessary record groups , for CPDF Valdiation,update/create extra infos, for agency specific edits
641: --
642:
643: hr_utility.set_location(l_proc,15);
644:
645: hr_utility.set_location('person id ' || to_char(p_imm_pa_request_rec.person_id),1);
646: ghr_sf52_pre_update.populate_record_groups
647: (

Line 645: hr_utility.set_location('person id ' || to_char(p_imm_pa_request_rec.person_id),1);

641: --
642:
643: hr_utility.set_location(l_proc,15);
644:
645: hr_utility.set_location('person id ' || to_char(p_imm_pa_request_rec.person_id),1);
646: ghr_sf52_pre_update.populate_record_groups
647: (
648: p_pa_request_rec => p_imm_pa_request_rec,
649: p_generic_ei_rec => p_imm_generic_ei_rec,

Line 722: hr_utility.set_location(l_proc,20);

718: p_imm_retirement_info => l_imm_retirement_info
719:
720: );
721:
722: hr_utility.set_location(l_proc,20);
723:
724: -- FWFA Changes Bug#4444609
725: -- Bug#4701896
726: IF ghr_pay_calc.g_pay_table_upd_flag THEN

Line 798: hr_utility.set_location('Health Plan ' ,20);

794:
795:
796: --Fetch Health Plan
797:
798: hr_utility.set_location('Health Plan ' ,20);
799:
800: ghr_api.retrieve_element_entry_value
801: ( p_element_name => 'Health Benefits'
802: ,p_input_value_name => 'Health Plan'

Line 897: hr_utility.set_location('Call to CPDF ' ,21);

893: );
894:
895: -- Call to CPDF Validation
896:
897: hr_utility.set_location('Call to CPDF ' ,21);
898: hr_utility.set_location('Gov Award id ' || l_imm_gov_awards.group_award,1);
899: hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.pay_plan,1);
900: --hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.duty_station_id,1);
901:

Line 898: hr_utility.set_location('Gov Award id ' || l_imm_gov_awards.group_award,1);

894:
895: -- Call to CPDF Validation
896:
897: hr_utility.set_location('Call to CPDF ' ,21);
898: hr_utility.set_location('Gov Award id ' || l_imm_gov_awards.group_award,1);
899: hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.pay_plan,1);
900: --hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.duty_station_id,1);
901:
902: --Pradeep.

Line 899: hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.pay_plan,1);

895: -- Call to CPDF Validation
896:
897: hr_utility.set_location('Call to CPDF ' ,21);
898: hr_utility.set_location('Gov Award id ' || l_imm_gov_awards.group_award,1);
899: hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.pay_plan,1);
900: --hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.duty_station_id,1);
901:
902: --Pradeep.
903: --Bypassing the edits for 850 and 855 actions.

Line 900: --hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.duty_station_id,1);

896:
897: hr_utility.set_location('Call to CPDF ' ,21);
898: hr_utility.set_location('Gov Award id ' || l_imm_gov_awards.group_award,1);
899: hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.pay_plan,1);
900: --hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.duty_station_id,1);
901:
902: --Pradeep.
903: --Bypassing the edits for 850 and 855 actions.
904: If NOT ( p_imm_pa_request_rec.first_noa_code in ( '850', '855' ) or

Line 946: hr_utility.set_location(l_proc,120);

942:
943: -- Calling creation of life events procedure
944: -- Apr 25,2005 Commented the call to create TSP Life events
945: /*
946: hr_utility.set_location(l_proc,120);
947: ghr_create_ptnl_life_events.create_ptnl_tsp_ler_for_per
948: (p_pa_request_rec => p_imm_pa_request_rec
949: );
950: */

Line 951: hr_utility.set_location(l_proc,125);

947: ghr_create_ptnl_life_events.create_ptnl_tsp_ler_for_per
948: (p_pa_request_rec => p_imm_pa_request_rec
949: );
950: */
951: hr_utility.set_location(l_proc,125);
952: ghr_create_ptnl_life_events.create_ptnl_ler_for_per
953: (p_pa_request_rec => p_imm_pa_request_rec
954: );
955: hr_utility.set_location(l_proc,125);

Line 955: hr_utility.set_location(l_proc,125);

951: hr_utility.set_location(l_proc,125);
952: ghr_create_ptnl_life_events.create_ptnl_ler_for_per
953: (p_pa_request_rec => p_imm_pa_request_rec
954: );
955: hr_utility.set_location(l_proc,125);
956:
957: -- Do database update steps.
958: -- (procedures reside in GHR_SF52_DO_UPDATE package.
959:

Line 963: hr_utility.set_location(l_proc,70);

959:
960: --
961: -- Calling Process family procedure
962:
963: hr_utility.set_location(l_proc,70);
964:
965: GHR_SF52_DO_UPDATE.Process_Family
966: (P_Pa_request_Rec => p_imm_pa_request_rec,
967: P_agency_code => l_agency_code );

Line 968: hr_utility.set_location('assignmentid aft proc fam ' || to_char(p_imm_pa_request_rec.employee_assignment_id),2);

964:
965: GHR_SF52_DO_UPDATE.Process_Family
966: (P_Pa_request_Rec => p_imm_pa_request_rec,
967: P_agency_code => l_agency_code );
968: hr_utility.set_location('assignmentid aft proc fam ' || to_char(p_imm_pa_request_rec.employee_assignment_id),2);
969: --
970: -- calling call_extra_info_api
971: --
972:

Line 973: hr_utility.set_location(l_proc,90);

969: --
970: -- calling call_extra_info_api
971: --
972:
973: hr_utility.set_location(l_proc,90);
974:
975: --hr_utility.set_location('after populate rec gps ' ||to_char(l_imm_pos_gpr2.position_extra_info_id),1);
976: GHR_SF52_DO_UPDATE.call_extra_info_api
977: (P_PA_REQUEST_REC => p_imm_PA_REQUEST_REC

Line 975: --hr_utility.set_location('after populate rec gps ' ||to_char(l_imm_pos_gpr2.position_extra_info_id),1);

971: --
972:
973: hr_utility.set_location(l_proc,90);
974:
975: --hr_utility.set_location('after populate rec gps ' ||to_char(l_imm_pos_gpr2.position_extra_info_id),1);
976: GHR_SF52_DO_UPDATE.call_extra_info_api
977: (P_PA_REQUEST_REC => p_imm_PA_REQUEST_REC
978: ,P_Asg_Sf52 => l_imm_Asg_Sf52
979: , P_Asg_non_Sf52 => l_imm_Asg_non_Sf52

Line 1019: hr_utility.set_location(l_proc,100);

1015: --
1016: -- Calling process_Salary_Info
1017: --
1018: --
1019: hr_utility.set_location(l_proc,100);
1020:
1021: GHR_SF52_DO_UPDATE.Process_salary_Info
1022: (p_pa_request_rec => p_imm_pa_request_rec
1023: ,p_wgi => l_imm_wgi

Line 1031: hr_utility.set_location(l_proc,110);

1027: --
1028: -- calling Process Non_salary info
1029: --
1030: -- Process_Non_Salary_Info
1031: hr_utility.set_location(l_proc,110);
1032: GHR_SF52_DO_UPDATE.Process_non_salary_Info
1033: (p_pa_request_rec => p_imm_pa_request_rec
1034: ,p_recruitment_bonus => l_imm_recruitment_bonus
1035: ,p_relocation_bonus => l_imm_relocation_bonus

Line 1074: hr_utility.set_location(l_proc,120);

1070: FOR l_cur_bg_id IN c_bg_id(p_imm_pa_request_rec.person_id, p_imm_pa_request_rec.effective_date) LOOP
1071: l_bg_id := l_cur_bg_id.bg_id;
1072: END LOOP;
1073:
1074: hr_utility.set_location(l_proc,120);
1075: hr_utility.set_location(' noa_family_code ' || p_imm_pa_request_rec.noa_family_code,120);
1076: hr_utility.set_location(' Person ID ' || p_imm_pa_request_rec.person_id,120);
1077: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1078: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);

Line 1075: hr_utility.set_location(' noa_family_code ' || p_imm_pa_request_rec.noa_family_code,120);

1071: l_bg_id := l_cur_bg_id.bg_id;
1072: END LOOP;
1073:
1074: hr_utility.set_location(l_proc,120);
1075: hr_utility.set_location(' noa_family_code ' || p_imm_pa_request_rec.noa_family_code,120);
1076: hr_utility.set_location(' Person ID ' || p_imm_pa_request_rec.person_id,120);
1077: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1078: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1079: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);

Line 1076: hr_utility.set_location(' Person ID ' || p_imm_pa_request_rec.person_id,120);

1072: END LOOP;
1073:
1074: hr_utility.set_location(l_proc,120);
1075: hr_utility.set_location(' noa_family_code ' || p_imm_pa_request_rec.noa_family_code,120);
1076: hr_utility.set_location(' Person ID ' || p_imm_pa_request_rec.person_id,120);
1077: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1078: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1079: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);
1080: hr_utility.set_location(' p_opt_code ' || l_imm_health_benefits.enrollment,120);

Line 1077: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);

1073:
1074: hr_utility.set_location(l_proc,120);
1075: hr_utility.set_location(' noa_family_code ' || p_imm_pa_request_rec.noa_family_code,120);
1076: hr_utility.set_location(' Person ID ' || p_imm_pa_request_rec.person_id,120);
1077: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1078: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1079: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);
1080: hr_utility.set_location(' p_opt_code ' || l_imm_health_benefits.enrollment,120);
1081: hr_utility.set_location(' p_pre_tax ' || l_imm_health_benefits.pre_tax_waiver,120);

Line 1078: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);

1074: hr_utility.set_location(l_proc,120);
1075: hr_utility.set_location(' noa_family_code ' || p_imm_pa_request_rec.noa_family_code,120);
1076: hr_utility.set_location(' Person ID ' || p_imm_pa_request_rec.person_id,120);
1077: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1078: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1079: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);
1080: hr_utility.set_location(' p_opt_code ' || l_imm_health_benefits.enrollment,120);
1081: hr_utility.set_location(' p_pre_tax ' || l_imm_health_benefits.pre_tax_waiver,120);
1082: hr_utility.set_location(' pa_request_id ' || to_char(p_imm_pa_request_rec.pa_request_id),121);

Line 1079: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);

1075: hr_utility.set_location(' noa_family_code ' || p_imm_pa_request_rec.noa_family_code,120);
1076: hr_utility.set_location(' Person ID ' || p_imm_pa_request_rec.person_id,120);
1077: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1078: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1079: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);
1080: hr_utility.set_location(' p_opt_code ' || l_imm_health_benefits.enrollment,120);
1081: hr_utility.set_location(' p_pre_tax ' || l_imm_health_benefits.pre_tax_waiver,120);
1082: hr_utility.set_location(' pa_request_id ' || to_char(p_imm_pa_request_rec.pa_request_id),121);
1083:

Line 1080: hr_utility.set_location(' p_opt_code ' || l_imm_health_benefits.enrollment,120);

1076: hr_utility.set_location(' Person ID ' || p_imm_pa_request_rec.person_id,120);
1077: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1078: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1079: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);
1080: hr_utility.set_location(' p_opt_code ' || l_imm_health_benefits.enrollment,120);
1081: hr_utility.set_location(' p_pre_tax ' || l_imm_health_benefits.pre_tax_waiver,120);
1082: hr_utility.set_location(' pa_request_id ' || to_char(p_imm_pa_request_rec.pa_request_id),121);
1083:
1084:

Line 1081: hr_utility.set_location(' p_pre_tax ' || l_imm_health_benefits.pre_tax_waiver,120);

1077: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1078: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1079: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);
1080: hr_utility.set_location(' p_opt_code ' || l_imm_health_benefits.enrollment,120);
1081: hr_utility.set_location(' p_pre_tax ' || l_imm_health_benefits.pre_tax_waiver,120);
1082: hr_utility.set_location(' pa_request_id ' || to_char(p_imm_pa_request_rec.pa_request_id),121);
1083:
1084:
1085: Populate_Remarks(p_pa_request_id => p_imm_pa_request_rec.pa_request_id

Line 1082: hr_utility.set_location(' pa_request_id ' || to_char(p_imm_pa_request_rec.pa_request_id),121);

1078: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1079: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);
1080: hr_utility.set_location(' p_opt_code ' || l_imm_health_benefits.enrollment,120);
1081: hr_utility.set_location(' p_pre_tax ' || l_imm_health_benefits.pre_tax_waiver,120);
1082: hr_utility.set_location(' pa_request_id ' || to_char(p_imm_pa_request_rec.pa_request_id),121);
1083:
1084:
1085: Populate_Remarks(p_pa_request_id => p_imm_pa_request_rec.pa_request_id
1086: ,p_to_pay_plan => p_imm_pa_request_rec.to_pay_plan

Line 1158: IF ghr_utility.is_ghr_ben_fehb = 'TRUE' and p_imm_pa_request_rec.noa_family_code IN ('CONV_APP') THEN

1154: );
1155: --
1156: -- Start of Bug # 5195518 modified related to handling of Conversion to Appointment
1157: l_temp_appt := 'N';
1158: IF ghr_utility.is_ghr_ben_fehb = 'TRUE' and p_imm_pa_request_rec.noa_family_code IN ('CONV_APP') THEN
1159: IF l_imm_health_benefits.health_plan IS NOT NULL THEN
1160: IF l_imm_health_benefits.health_plan <> 'ZZ' AND l_imm_health_benefits.enrollment NOT IN ('W','X','Y','Z') THEN
1161:
1162: for enr in get_current_enrollment (p_asg_id => p_imm_pa_request_rec.employee_assignment_id,

Line 1189: IF ghr_utility.is_ghr_ben_fehb = 'TRUE' THEN

1185: -- to maintain history
1186: -- Call Benefits processing Bug 4582970
1187: IF p_imm_pa_request_rec.noa_family_code in ('APP','CONV_APP','SEPARATION') THEN
1188: -- l_temp_appt := 'N';
1189: IF ghr_utility.is_ghr_ben_fehb = 'TRUE' THEN
1190: -- Will be uncommented later
1191: IF p_imm_pa_request_rec.noa_family_code in ('SEPARATION') THEN
1192: --Added this code to validate whether HB is already enrolled before processing separation life event
1193: -- Get Program ID

Line 1256: END IF; -- IF ghr_utility.is_ghr_ben_fehb = 'TRUE

1252: );
1253: END IF;
1254: END IF;
1255: END IF;
1256: END IF; -- IF ghr_utility.is_ghr_ben_fehb = 'TRUE
1257:
1258: IF ghr_utility.is_ghr_ben_tsp = 'TRUE' THEN
1259: IF l_imm_thrift_saving_plan.amount > 0 THEN
1260: l_amount_or_rate := 'Amount';

Line 1258: IF ghr_utility.is_ghr_ben_tsp = 'TRUE' THEN

1254: END IF;
1255: END IF;
1256: END IF; -- IF ghr_utility.is_ghr_ben_fehb = 'TRUE
1257:
1258: IF ghr_utility.is_ghr_ben_tsp = 'TRUE' THEN
1259: IF l_imm_thrift_saving_plan.amount > 0 THEN
1260: l_amount_or_rate := 'Amount';
1261: l_opt_val := l_imm_thrift_saving_plan.amount;
1262: ELSIF l_imm_thrift_saving_plan.rate > 0 THEN

Line 1268: hr_utility.set_location(' tsp status ' || l_imm_thrift_saving_plan.status,120);

1264: l_opt_val := l_imm_thrift_saving_plan.rate;
1265: ELSE
1266: l_amount_or_rate := NULL;
1267: END IF;
1268: hr_utility.set_location(' tsp status ' || l_imm_thrift_saving_plan.status,120);
1269: hr_utility.set_location(' l_amount_or_rate ' || l_amount_or_rate,120);
1270: hr_utility.set_location(' l_opt_val ' || l_opt_val,120);
1271: IF l_amount_or_rate IS NOT NULL OR l_imm_thrift_saving_plan.status IN ('T','S') THEN
1272: ghr_benefits_eit.ghr_benefits_tsp(errbuf => l_errbuf,

Line 1269: hr_utility.set_location(' l_amount_or_rate ' || l_amount_or_rate,120);

1265: ELSE
1266: l_amount_or_rate := NULL;
1267: END IF;
1268: hr_utility.set_location(' tsp status ' || l_imm_thrift_saving_plan.status,120);
1269: hr_utility.set_location(' l_amount_or_rate ' || l_amount_or_rate,120);
1270: hr_utility.set_location(' l_opt_val ' || l_opt_val,120);
1271: IF l_amount_or_rate IS NOT NULL OR l_imm_thrift_saving_plan.status IN ('T','S') THEN
1272: ghr_benefits_eit.ghr_benefits_tsp(errbuf => l_errbuf,
1273: retcode => l_retcode,

Line 1270: hr_utility.set_location(' l_opt_val ' || l_opt_val,120);

1266: l_amount_or_rate := NULL;
1267: END IF;
1268: hr_utility.set_location(' tsp status ' || l_imm_thrift_saving_plan.status,120);
1269: hr_utility.set_location(' l_amount_or_rate ' || l_amount_or_rate,120);
1270: hr_utility.set_location(' l_opt_val ' || l_opt_val,120);
1271: IF l_amount_or_rate IS NOT NULL OR l_imm_thrift_saving_plan.status IN ('T','S') THEN
1272: ghr_benefits_eit.ghr_benefits_tsp(errbuf => l_errbuf,
1273: retcode => l_retcode,
1274: p_person_id => p_imm_pa_request_rec.person_id,

Line 1282: END IF; -- IF ghr_utility.is_ghr_ben_tsp = 'TRUE' T

1278: p_opt_name => l_amount_or_rate,
1279: p_opt_val => l_opt_val
1280: );
1281: END IF;
1282: END IF; -- IF ghr_utility.is_ghr_ben_tsp = 'TRUE' T
1283: END IF; -- IF p_imm_pa_request_rec.noa_family_code = 'APP'
1284: -- End of Bug # 5195518
1285:
1286: ghr_history_api.post_update_process;

Line 1338: hr_utility.set_location('Entering ' || l_proc,10);

1334: l_capped_other_pay number;
1335:
1336: Begin
1337: --
1338: hr_utility.set_location('Entering ' || l_proc,10);
1339: hr_utility.set_location(l_proc || p_pa_request_rec.to_position_number,12);
1340:
1341:
1342: l_pa_request_rec_in := p_pa_request_rec; /* Added for NOCOPY changes */

Line 1339: hr_utility.set_location(l_proc || p_pa_request_rec.to_position_number,12);

1335:
1336: Begin
1337: --
1338: hr_utility.set_location('Entering ' || l_proc,10);
1339: hr_utility.set_location(l_proc || p_pa_request_rec.to_position_number,12);
1340:
1341:
1342: l_pa_request_rec_in := p_pa_request_rec; /* Added for NOCOPY changes */
1343: g_effective_date := p_pa_request_rec.effective_date;

Line 1348: hr_utility.set_location(l_proc,20);

1344:
1345:
1346: l_capped_other_pay := p_capped_other_pay;
1347:
1348: hr_utility.set_location(l_proc,20);
1349: l_pa_request_rec := p_pa_request_rec;
1350:
1351: -- The foll. check ensures that the RPA is not processed
1352: -- if the TO_position(or From Position) is end dated

Line 1364: hr_utility.set_message(8301,'GHR_38594_POSN_END_DATED');

1360: l_date_end := c_pos_rec.date_end;
1361: end loop;
1362: if nvl(l_date_end,l_pa_request_rec.effective_date) < l_pa_request_rec.effective_date then
1363: -- raise error;
1364: hr_utility.set_message(8301,'GHR_38594_POSN_END_DATED');
1365: hr_utility.raise_error;
1366: end if;
1367: End if;
1368:

Line 1365: hr_utility.raise_error;

1361: end loop;
1362: if nvl(l_date_end,l_pa_request_rec.effective_date) < l_pa_request_rec.effective_date then
1363: -- raise error;
1364: hr_utility.set_message(8301,'GHR_38594_POSN_END_DATED');
1365: hr_utility.raise_error;
1366: end if;
1367: End if;
1368:
1369: Process_Immediate_Update

Line 1376: hr_utility.set_location('Assignment Id ' || to_char(p_pa_request_rec.employee_assignment_id),2);

1372: p_imm_generic_ei_rec => p_generic_ei_rec,
1373: p_capped_other_pay => l_capped_other_pay
1374: );
1375: p_pa_request_rec := l_pa_request_rec;
1376: hr_utility.set_location('Assignment Id ' || to_char(p_pa_request_rec.employee_assignment_id),2);
1377:
1378: --
1379: --
1380: hr_utility.set_location('Leaving ' ||l_proc,40);

Line 1380: hr_utility.set_location('Leaving ' ||l_proc,40);

1376: hr_utility.set_location('Assignment Id ' || to_char(p_pa_request_rec.employee_assignment_id),2);
1377:
1378: --
1379: --
1380: hr_utility.set_location('Leaving ' ||l_proc,40);
1381:
1382: exception when others then
1383: --
1384: -- Reset IN OUT parameters and set OUT parameters