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.

[Home] [Help]

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 338: hr_utility.set_location('Leaving ' || l_proc,100);

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

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

612: --End of 8267598
613:
614:
615: Begin
616: hr_utility.set_location('Entering ' ||l_proc,5);
617:
618: l_imm_pa_request_rec_in := p_imm_pa_request_rec; /* Added for NOCOPY changes */
619: l_capped_other_pay_in := p_capped_other_pay; /* Added for NOCOPY changes */
620:

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

617:
618: l_imm_pa_request_rec_in := p_imm_pa_request_rec; /* Added for NOCOPY changes */
619: l_capped_other_pay_in := p_capped_other_pay; /* Added for NOCOPY changes */
620:
621: hr_utility.set_location(l_proc,10);
622: ghr_history_api.get_g_session_var(l_session);
623: IF l_session.noa_id_correct is null and
624: p_imm_pa_request_rec.first_noa_code = '866' THEN
625: g_effective_date := p_imm_pa_request_rec.effective_date + 1;

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

715:
716: -- Populate all necessary record groups , for CPDF Valdiation,update/create extra infos, for agency specific edits
717: --
718:
719: hr_utility.set_location(l_proc,15);
720:
721: hr_utility.set_location('person id ' || to_char(p_imm_pa_request_rec.person_id),1);
722: ghr_sf52_pre_update.populate_record_groups
723: (

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

717: --
718:
719: hr_utility.set_location(l_proc,15);
720:
721: hr_utility.set_location('person id ' || to_char(p_imm_pa_request_rec.person_id),1);
722: ghr_sf52_pre_update.populate_record_groups
723: (
724: p_pa_request_rec => p_imm_pa_request_rec,
725: p_generic_ei_rec => p_imm_generic_ei_rec,

Line 801: hr_utility.set_location('g_dual_prior_ws'||ghr_process_sf52.g_dual_prior_ws,100);

797: p_imm_tsp_roth => l_imm_roth_tsp
798: );
799: --8267598 added this code to maintain prior work schedule as a global variable
800: --for dual actions otherwise this will contain null value
801: hr_utility.set_location('g_dual_prior_ws'||ghr_process_sf52.g_dual_prior_ws,100);
802: if l_session.pa_request_id is not null and l_session.noa_id_correct is null then
803: -- for identifying First action of Dual Action
804: for rec_chk_dual in chk_dual
805: loop

Line 897: hr_utility.set_location('g_dual_prior_ws'||ghr_process_sf52.g_dual_prior_ws,100);

893: end loop;
894: end loop;
895: end if;
896:
897: hr_utility.set_location('g_dual_prior_ws'||ghr_process_sf52.g_dual_prior_ws,100);
898: -- End of 8267598
899:
900: hr_utility.set_location(l_proc,20);
901:

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

896:
897: hr_utility.set_location('g_dual_prior_ws'||ghr_process_sf52.g_dual_prior_ws,100);
898: -- End of 8267598
899:
900: hr_utility.set_location(l_proc,20);
901:
902: -- FWFA Changes Bug#4444609
903: -- Bug#4701896
904: IF ghr_pay_calc.g_pay_table_upd_flag THEN

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

971:
972:
973: --Fetch Health Plan
974:
975: hr_utility.set_location('Health Plan ' ,20);
976:
977: ghr_api.retrieve_element_entry_value
978: ( p_element_name => 'Health Benefits'
979: ,p_input_value_name => 'Health Plan'

Line 1049: hr_utility.set_location('3 l_imm_per_group1'||l_imm_per_group1.org_appointment_auth_code1,1000);

1045: p_asg_detail_info => l_imm_asg_detail_info,
1046: p_ipa_detail_ben_cont_info => l_imm_ipa_benefits_cont
1047: --End Bug# 10181661
1048: );
1049: hr_utility.set_location('3 l_imm_per_group1'||l_imm_per_group1.org_appointment_auth_code1,1000);
1050: -- GHR Validations
1051:
1052: GHR_Validate_CHECK.Validate_CHECK
1053: (

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

1074: );
1075:
1076: -- Call to CPDF Validation
1077:
1078: hr_utility.set_location('Call to CPDF ' ,21);
1079: hr_utility.set_location('Gov Award id ' || l_imm_gov_awards.group_award,1);
1080: hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.pay_plan,1);
1081: --hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.duty_station_id,1);
1082:

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

1075:
1076: -- Call to CPDF Validation
1077:
1078: hr_utility.set_location('Call to CPDF ' ,21);
1079: hr_utility.set_location('Gov Award id ' || l_imm_gov_awards.group_award,1);
1080: hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.pay_plan,1);
1081: --hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.duty_station_id,1);
1082:
1083: --Pradeep.

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

1076: -- Call to CPDF Validation
1077:
1078: hr_utility.set_location('Call to CPDF ' ,21);
1079: hr_utility.set_location('Gov Award id ' || l_imm_gov_awards.group_award,1);
1080: hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.pay_plan,1);
1081: --hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.duty_station_id,1);
1082:
1083: --Pradeep.
1084: --Bypassing the edits for 850 and 855 actions.

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

1077:
1078: hr_utility.set_location('Call to CPDF ' ,21);
1079: hr_utility.set_location('Gov Award id ' || l_imm_gov_awards.group_award,1);
1080: hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.pay_plan,1);
1081: --hr_utility.set_location('Prior Pay Plan ' || l_imm_sf52_from_data.duty_station_id,1);
1082:
1083: --Pradeep.
1084: --Bypassing the edits for 850 and 855 actions.
1085: If NOT ( p_imm_pa_request_rec.first_noa_code in ( '850', '855' ) or

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

1124:
1125: -- Calling creation of life events procedure
1126: -- Apr 25,2005 Commented the call to create TSP Life events
1127: /*
1128: hr_utility.set_location(l_proc,120);
1129: ghr_create_ptnl_life_events.create_ptnl_tsp_ler_for_per
1130: (p_pa_request_rec => p_imm_pa_request_rec
1131: );
1132: */

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

1129: ghr_create_ptnl_life_events.create_ptnl_tsp_ler_for_per
1130: (p_pa_request_rec => p_imm_pa_request_rec
1131: );
1132: */
1133: hr_utility.set_location(l_proc,125);
1134: ghr_create_ptnl_life_events.create_ptnl_ler_for_per
1135: (p_pa_request_rec => p_imm_pa_request_rec
1136: );
1137: hr_utility.set_location(l_proc,125);

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

1133: hr_utility.set_location(l_proc,125);
1134: ghr_create_ptnl_life_events.create_ptnl_ler_for_per
1135: (p_pa_request_rec => p_imm_pa_request_rec
1136: );
1137: hr_utility.set_location(l_proc,125);
1138:
1139: -- Do database update steps.
1140: -- (procedures reside in GHR_SF52_DO_UPDATE package.
1141:

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

1141:
1142: --
1143: -- Calling Process family procedure
1144:
1145: hr_utility.set_location(l_proc,70);
1146:
1147: GHR_SF52_DO_UPDATE.Process_Family
1148: (P_Pa_request_Rec => p_imm_pa_request_rec,
1149: P_agency_code => l_agency_code );

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

1146:
1147: GHR_SF52_DO_UPDATE.Process_Family
1148: (P_Pa_request_Rec => p_imm_pa_request_rec,
1149: P_agency_code => l_agency_code );
1150: hr_utility.set_location('assignmentid aft proc fam ' || to_char(p_imm_pa_request_rec.employee_assignment_id),2);
1151: --
1152: -- calling call_extra_info_api
1153: --
1154:

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

1151: --
1152: -- calling call_extra_info_api
1153: --
1154:
1155: hr_utility.set_location(l_proc,90);
1156:
1157: --hr_utility.set_location('after populate rec gps ' ||to_char(l_imm_pos_gpr2.position_extra_info_id),1);
1158: GHR_SF52_DO_UPDATE.call_extra_info_api
1159: (P_PA_REQUEST_REC => p_imm_PA_REQUEST_REC

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

1153: --
1154:
1155: hr_utility.set_location(l_proc,90);
1156:
1157: --hr_utility.set_location('after populate rec gps ' ||to_char(l_imm_pos_gpr2.position_extra_info_id),1);
1158: GHR_SF52_DO_UPDATE.call_extra_info_api
1159: (P_PA_REQUEST_REC => p_imm_PA_REQUEST_REC
1160: ,P_Asg_Sf52 => l_imm_Asg_Sf52
1161: , P_Asg_non_Sf52 => l_imm_Asg_non_Sf52

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

1198: --
1199: -- Calling process_Salary_Info
1200: --
1201: --
1202: hr_utility.set_location(l_proc,100);
1203:
1204: GHR_SF52_DO_UPDATE.Process_salary_Info
1205: (p_pa_request_rec => p_imm_pa_request_rec
1206: ,p_wgi => l_imm_wgi

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

1210: --
1211: -- calling Process Non_salary info
1212: --
1213: -- Process_Non_Salary_Info
1214: hr_utility.set_location(l_proc,110);
1215: GHR_SF52_DO_UPDATE.Process_non_salary_Info
1216: (p_pa_request_rec => p_imm_pa_request_rec
1217: ,p_recruitment_bonus => l_imm_recruitment_bonus
1218: ,p_relocation_bonus => l_imm_relocation_bonus

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

1255: FOR l_cur_bg_id IN c_bg_id(p_imm_pa_request_rec.person_id, p_imm_pa_request_rec.effective_date) LOOP
1256: l_bg_id := l_cur_bg_id.bg_id;
1257: END LOOP;
1258:
1259: hr_utility.set_location(l_proc,120);
1260: hr_utility.set_location(' noa_family_code ' || p_imm_pa_request_rec.noa_family_code,120);
1261: hr_utility.set_location(' Person ID ' || p_imm_pa_request_rec.person_id,120);
1262: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1263: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);

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

1256: l_bg_id := l_cur_bg_id.bg_id;
1257: END LOOP;
1258:
1259: hr_utility.set_location(l_proc,120);
1260: hr_utility.set_location(' noa_family_code ' || p_imm_pa_request_rec.noa_family_code,120);
1261: hr_utility.set_location(' Person ID ' || p_imm_pa_request_rec.person_id,120);
1262: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1263: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1264: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);

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

1257: END LOOP;
1258:
1259: hr_utility.set_location(l_proc,120);
1260: hr_utility.set_location(' noa_family_code ' || p_imm_pa_request_rec.noa_family_code,120);
1261: hr_utility.set_location(' Person ID ' || p_imm_pa_request_rec.person_id,120);
1262: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1263: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1264: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);
1265: hr_utility.set_location(' p_opt_code ' || l_imm_health_benefits.enrollment,120);

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

1258:
1259: hr_utility.set_location(l_proc,120);
1260: hr_utility.set_location(' noa_family_code ' || p_imm_pa_request_rec.noa_family_code,120);
1261: hr_utility.set_location(' Person ID ' || p_imm_pa_request_rec.person_id,120);
1262: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1263: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1264: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);
1265: hr_utility.set_location(' p_opt_code ' || l_imm_health_benefits.enrollment,120);
1266: hr_utility.set_location(' p_pre_tax ' || l_imm_health_benefits.pre_tax_waiver,120);

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

1259: hr_utility.set_location(l_proc,120);
1260: hr_utility.set_location(' noa_family_code ' || p_imm_pa_request_rec.noa_family_code,120);
1261: hr_utility.set_location(' Person ID ' || p_imm_pa_request_rec.person_id,120);
1262: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1263: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1264: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);
1265: hr_utility.set_location(' p_opt_code ' || l_imm_health_benefits.enrollment,120);
1266: hr_utility.set_location(' p_pre_tax ' || l_imm_health_benefits.pre_tax_waiver,120);
1267: hr_utility.set_location(' pa_request_id ' || to_char(p_imm_pa_request_rec.pa_request_id),121);

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

1260: hr_utility.set_location(' noa_family_code ' || p_imm_pa_request_rec.noa_family_code,120);
1261: hr_utility.set_location(' Person ID ' || p_imm_pa_request_rec.person_id,120);
1262: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1263: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1264: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);
1265: hr_utility.set_location(' p_opt_code ' || l_imm_health_benefits.enrollment,120);
1266: hr_utility.set_location(' p_pre_tax ' || l_imm_health_benefits.pre_tax_waiver,120);
1267: hr_utility.set_location(' pa_request_id ' || to_char(p_imm_pa_request_rec.pa_request_id),121);
1268:

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

1261: hr_utility.set_location(' Person ID ' || p_imm_pa_request_rec.person_id,120);
1262: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1263: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1264: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);
1265: hr_utility.set_location(' p_opt_code ' || l_imm_health_benefits.enrollment,120);
1266: hr_utility.set_location(' p_pre_tax ' || l_imm_health_benefits.pre_tax_waiver,120);
1267: hr_utility.set_location(' pa_request_id ' || to_char(p_imm_pa_request_rec.pa_request_id),121);
1268:
1269:

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

1262: hr_utility.set_location(' Eff. date ' || p_imm_pa_request_rec.effective_date,120);
1263: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1264: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);
1265: hr_utility.set_location(' p_opt_code ' || l_imm_health_benefits.enrollment,120);
1266: hr_utility.set_location(' p_pre_tax ' || l_imm_health_benefits.pre_tax_waiver,120);
1267: hr_utility.set_location(' pa_request_id ' || to_char(p_imm_pa_request_rec.pa_request_id),121);
1268:
1269:
1270: Populate_Remarks(p_pa_request_id => p_imm_pa_request_rec.pa_request_id

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

1263: hr_utility.set_location(' p_business_group_id ' || l_bg_id,120);
1264: hr_utility.set_location(' p_pl_code ' || l_imm_health_benefits.health_plan,120);
1265: hr_utility.set_location(' p_opt_code ' || l_imm_health_benefits.enrollment,120);
1266: hr_utility.set_location(' p_pre_tax ' || l_imm_health_benefits.pre_tax_waiver,120);
1267: hr_utility.set_location(' pa_request_id ' || to_char(p_imm_pa_request_rec.pa_request_id),121);
1268:
1269:
1270: Populate_Remarks(p_pa_request_id => p_imm_pa_request_rec.pa_request_id
1271: ,p_to_pay_plan => p_imm_pa_request_rec.to_pay_plan

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

1343: );
1344: --
1345: -- Start of Bug # 5195518 modified related to handling of Conversion to Appointment
1346: l_temp_appt := 'N';
1347: IF ghr_utility.is_ghr_ben_fehb = 'TRUE' and p_imm_pa_request_rec.noa_family_code IN ('CONV_APP') THEN
1348: IF l_imm_health_benefits.health_plan IS NOT NULL THEN
1349: IF l_imm_health_benefits.health_plan <> 'ZZ' AND l_imm_health_benefits.enrollment NOT IN ('W','X','Y','Z') THEN
1350:
1351: for enr in get_current_enrollment (p_asg_id => p_imm_pa_request_rec.employee_assignment_id,

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

1374: -- to maintain history
1375: -- Call Benefits processing Bug 4582970
1376: IF p_imm_pa_request_rec.noa_family_code in ('APP','CONV_APP','SEPARATION') THEN
1377: -- l_temp_appt := 'N';
1378: IF ghr_utility.is_ghr_ben_fehb = 'TRUE' THEN
1379: -- Will be uncommented later
1380: IF p_imm_pa_request_rec.noa_family_code in ('SEPARATION') THEN
1381: --Added this code to validate whether HB is already enrolled before processing separation life event
1382: -- Get Program ID

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

1441: );
1442: END IF;
1443: END IF;
1444: END IF;
1445: END IF; -- IF ghr_utility.is_ghr_ben_fehb = 'TRUE
1446:
1447: IF ghr_utility.is_ghr_ben_tsp = 'TRUE' THEN
1448: IF l_imm_thrift_saving_plan.amount > 0 THEN
1449: l_amount_or_rate := 'Amount';

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

1443: END IF;
1444: END IF;
1445: END IF; -- IF ghr_utility.is_ghr_ben_fehb = 'TRUE
1446:
1447: IF ghr_utility.is_ghr_ben_tsp = 'TRUE' THEN
1448: IF l_imm_thrift_saving_plan.amount > 0 THEN
1449: l_amount_or_rate := 'Amount';
1450: l_opt_val := l_imm_thrift_saving_plan.amount;
1451: ELSIF l_imm_thrift_saving_plan.rate > 0 THEN

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

1453: l_opt_val := l_imm_thrift_saving_plan.rate;
1454: ELSE
1455: l_amount_or_rate := NULL;
1456: END IF;
1457: hr_utility.set_location(' tsp status ' || l_imm_thrift_saving_plan.status,120);
1458: hr_utility.set_location(' l_amount_or_rate ' || l_amount_or_rate,120);
1459: hr_utility.set_location(' l_opt_val ' || l_opt_val,120);
1460: IF l_amount_or_rate IS NOT NULL OR l_imm_thrift_saving_plan.status IN ('T','S') THEN
1461: ghr_benefits_eit.ghr_benefits_tsp(errbuf => l_errbuf,

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

1454: ELSE
1455: l_amount_or_rate := NULL;
1456: END IF;
1457: hr_utility.set_location(' tsp status ' || l_imm_thrift_saving_plan.status,120);
1458: hr_utility.set_location(' l_amount_or_rate ' || l_amount_or_rate,120);
1459: hr_utility.set_location(' l_opt_val ' || l_opt_val,120);
1460: IF l_amount_or_rate IS NOT NULL OR l_imm_thrift_saving_plan.status IN ('T','S') THEN
1461: ghr_benefits_eit.ghr_benefits_tsp(errbuf => l_errbuf,
1462: retcode => l_retcode,

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

1455: l_amount_or_rate := NULL;
1456: END IF;
1457: hr_utility.set_location(' tsp status ' || l_imm_thrift_saving_plan.status,120);
1458: hr_utility.set_location(' l_amount_or_rate ' || l_amount_or_rate,120);
1459: hr_utility.set_location(' l_opt_val ' || l_opt_val,120);
1460: IF l_amount_or_rate IS NOT NULL OR l_imm_thrift_saving_plan.status IN ('T','S') THEN
1461: ghr_benefits_eit.ghr_benefits_tsp(errbuf => l_errbuf,
1462: retcode => l_retcode,
1463: p_person_id => p_imm_pa_request_rec.person_id,

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

1467: p_opt_name => l_amount_or_rate,
1468: p_opt_val => l_opt_val
1469: );
1470: END IF;
1471: END IF; -- IF ghr_utility.is_ghr_ben_tsp = 'TRUE' T
1472:
1473: --Bug # 4122470 FEGLI
1474:
1475: IF p_imm_pa_request_rec.noa_family_code in ('APP','CONV_APP') THEN

Line 1477: IF ghr_utility.is_ghr_ben_fegli = 'TRUE' THEN

1473: --Bug # 4122470 FEGLI
1474:
1475: IF p_imm_pa_request_rec.noa_family_code in ('APP','CONV_APP') THEN
1476: IF l_session.noa_id_correct is null THEN
1477: IF ghr_utility.is_ghr_ben_fegli = 'TRUE' THEN
1478: IF p_imm_pa_request_rec.fegli <> 'A0' THEN
1479: ghr_benefits_eit.ghr_benefits_fegli
1480: (errbuf => l_errbuf,
1481: retcode => l_retcode,

Line 1490: END IF; -- IF ghr_utility.is_ghr_ben_FEGLI = 'TRUE'

1486: p_opt_code => p_imm_pa_request_rec.fegli,
1487: p_assignment_id => p_imm_pa_request_rec.employee_assignment_id
1488: );
1489: END IF;
1490: END IF; -- IF ghr_utility.is_ghr_ben_FEGLI = 'TRUE'
1491: END IF;
1492: END IF;
1493:
1494: END IF; -- IF p_imm_pa_request_rec.noa_family_code = 'APP'

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

1545: l_capped_other_pay number;
1546:
1547: Begin
1548: --
1549: hr_utility.set_location('Entering ' || l_proc,10);
1550: hr_utility.set_location(l_proc || p_pa_request_rec.to_position_number,12);
1551:
1552:
1553: l_pa_request_rec_in := p_pa_request_rec; /* Added for NOCOPY changes */

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

1546:
1547: Begin
1548: --
1549: hr_utility.set_location('Entering ' || l_proc,10);
1550: hr_utility.set_location(l_proc || p_pa_request_rec.to_position_number,12);
1551:
1552:
1553: l_pa_request_rec_in := p_pa_request_rec; /* Added for NOCOPY changes */
1554: g_effective_date := p_pa_request_rec.effective_date;

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

1555:
1556:
1557: l_capped_other_pay := p_capped_other_pay;
1558:
1559: hr_utility.set_location(l_proc,20);
1560: l_pa_request_rec := p_pa_request_rec;
1561:
1562: -- The foll. check ensures that the RPA is not processed
1563: -- if the TO_position(or From Position) is end dated

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

1571: l_date_end := c_pos_rec.date_end;
1572: end loop;
1573: if nvl(l_date_end,l_pa_request_rec.effective_date) < l_pa_request_rec.effective_date then
1574: -- raise error;
1575: hr_utility.set_message(8301,'GHR_38594_POSN_END_DATED');
1576: hr_utility.raise_error;
1577: end if;
1578: End if;
1579:

Line 1576: hr_utility.raise_error;

1572: end loop;
1573: if nvl(l_date_end,l_pa_request_rec.effective_date) < l_pa_request_rec.effective_date then
1574: -- raise error;
1575: hr_utility.set_message(8301,'GHR_38594_POSN_END_DATED');
1576: hr_utility.raise_error;
1577: end if;
1578: End if;
1579:
1580: Process_Immediate_Update

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

1583: p_imm_generic_ei_rec => p_generic_ei_rec,
1584: p_capped_other_pay => l_capped_other_pay
1585: );
1586: p_pa_request_rec := l_pa_request_rec;
1587: hr_utility.set_location('Assignment Id ' || to_char(p_pa_request_rec.employee_assignment_id),2);
1588:
1589: --
1590: --
1591: hr_utility.set_location('Leaving ' ||l_proc,40);

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

1587: hr_utility.set_location('Assignment Id ' || to_char(p_pa_request_rec.employee_assignment_id),2);
1588:
1589: --
1590: --
1591: hr_utility.set_location('Leaving ' ||l_proc,40);
1592:
1593: exception when others then
1594: --
1595: -- Reset IN OUT parameters and set OUT parameters