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

Line 136: hr_utility.set_message(8301,'GHR_38583_PAY_CAP3');

132: p_adj_basic_pay := p_adj_basic_pay;
133: ghr_msl_pkg.g_ses_bp_capped := TRUE;
134: --9309268 added the global variable
135: ghr_msl_pkg.g_msl_bp_paycap := p_pay_cap;
136: hr_utility.set_message(8301,'GHR_38583_PAY_CAP3');
137: hr_utility.raise_error;
138: END IF;
139: END IF;
140:

Line 137: hr_utility.raise_error;

133: ghr_msl_pkg.g_ses_bp_capped := TRUE;
134: --9309268 added the global variable
135: ghr_msl_pkg.g_msl_bp_paycap := p_pay_cap;
136: hr_utility.set_message(8301,'GHR_38583_PAY_CAP3');
137: hr_utility.raise_error;
138: END IF;
139: END IF;
140:
141: END adj_basic_pay_cap;

Line 245: hr_utility.set_location('INSIDE perf_cert loop'||p_org_id,123453);

241: FOR cur_ESSL_equivalent_rec IN cur_ESSL_equivalent(p_pay_plan)
242: LOOP
243: ll_pay_plan := cur_ESSL_equivalent_rec.equivalent_pay_plan;
244: END LOOP;
245: hr_utility.set_location('INSIDE perf_cert loop'||p_org_id,123453);
246: hr_utility.set_location('INSIDE perf_cert loop'||p_effective_date,123453);
247: hr_utility.set_location('INSIDE perf_cert loop'||p_pay_plan,123453);
248: hr_utility.set_location('INSIDE perf_cert loop'||p_agency_code,123453);
249: --

Line 246: hr_utility.set_location('INSIDE perf_cert loop'||p_effective_date,123453);

242: LOOP
243: ll_pay_plan := cur_ESSL_equivalent_rec.equivalent_pay_plan;
244: END LOOP;
245: hr_utility.set_location('INSIDE perf_cert loop'||p_org_id,123453);
246: hr_utility.set_location('INSIDE perf_cert loop'||p_effective_date,123453);
247: hr_utility.set_location('INSIDE perf_cert loop'||p_pay_plan,123453);
248: hr_utility.set_location('INSIDE perf_cert loop'||p_agency_code,123453);
249: --
250: -- 1st LEVEL CHECK

Line 247: hr_utility.set_location('INSIDE perf_cert loop'||p_pay_plan,123453);

243: ll_pay_plan := cur_ESSL_equivalent_rec.equivalent_pay_plan;
244: END LOOP;
245: hr_utility.set_location('INSIDE perf_cert loop'||p_org_id,123453);
246: hr_utility.set_location('INSIDE perf_cert loop'||p_effective_date,123453);
247: hr_utility.set_location('INSIDE perf_cert loop'||p_pay_plan,123453);
248: hr_utility.set_location('INSIDE perf_cert loop'||p_agency_code,123453);
249: --
250: -- 1st LEVEL CHECK
251: -- CHECK if Agency level certification exists

Line 248: hr_utility.set_location('INSIDE perf_cert loop'||p_agency_code,123453);

244: END LOOP;
245: hr_utility.set_location('INSIDE perf_cert loop'||p_org_id,123453);
246: hr_utility.set_location('INSIDE perf_cert loop'||p_effective_date,123453);
247: hr_utility.set_location('INSIDE perf_cert loop'||p_pay_plan,123453);
248: hr_utility.set_location('INSIDE perf_cert loop'||p_agency_code,123453);
249: --
250: -- 1st LEVEL CHECK
251: -- CHECK if Agency level certification exists
252: --

Line 261: hr_utility.set_location('INSIDE perf_cert AGNCY loop'||p_org_id,123453);

257: ll_pay_plan,
258: l_business_group_id)
259: LOOP
260: l_cert := TRUE;
261: hr_utility.set_location('INSIDE perf_cert AGNCY loop'||p_org_id,123453);
262: END LOOP;
263:
264: IF NOT l_cert THEN
265: --

Line 274: hr_utility.set_location('INSIDE perf_cert AGNCY SUB loop'||p_org_id,123453);

270: ll_pay_plan,
271: l_business_group_id)
272: LOOP
273: l_cert := TRUE;
274: hr_utility.set_location('INSIDE perf_cert AGNCY SUB loop'||p_org_id,123453);
275: END LOOP;
276:
277: IF NOT l_cert THEN
278: --

Line 287: hr_utility.set_location('INSIDE perf_cert ORG loop'||p_org_id,123453);

283: ll_pay_plan,
284: l_business_group_id)
285: LOOP
286: l_cert := TRUE;
287: hr_utility.set_location('INSIDE perf_cert ORG loop'||p_org_id,123453);
288: END LOOP;
289: END IF;
290:
291: END IF;

Line 521: hr_utility.set_location('One ',1);

517: l_pay_cap_in_data.supervisory_allowance := p_supervisory_allowance;
518: l_pay_cap_in_data.staffing_differential := p_staffing_differential;
519: l_pay_cap_in_data.pa_request_id := p_pa_request_id;
520:
521: hr_utility.set_location('One ',1);
522: l_retention_allowance := p_retention_allowance;
523: l_retention_allow_percentage := p_retention_allow_percentage;
524: l_au_overtime := p_au_overtime;
525: l_availability_pay := p_availability_pay;

Line 598: hr_utility.set_location('Two ',1);

594: ,p_effective_date => p_effective_date
595: ,p_value => l_to_ap_premium_pay_indicator
596: ,p_multiple_error_flag => l_multi_error_flag);
597:
598: hr_utility.set_location('Two ',1);
599: -- Bug 710431 If PRD is ABEFU or V then get retained grade details
600: --
601: IF l_pay_cap_in_data.pay_rate_determinant IN ('A','B','E','F','U','V') THEN
602: -- use retained details...

Line 701: hr_utility.set_message(8301,'GHR_37448_PAY_CAP_TTL38');

697: IF NOT (pay_cap_chk_ttl_38( l_pos_ei_valid_grade.poei_information12,
698: l_pos_ei_valid_grade.poei_information13,
699: l_converted_adj_basic_pay,
700: p_effective_date)) THEN
701: hr_utility.set_message(8301,'GHR_37448_PAY_CAP_TTL38');
702: hr_utility.raise_error;
703: END IF;
704: END IF;--Bug# 13815085
705:

Line 702: hr_utility.raise_error;

698: l_pos_ei_valid_grade.poei_information13,
699: l_converted_adj_basic_pay,
700: p_effective_date)) THEN
701: hr_utility.set_message(8301,'GHR_37448_PAY_CAP_TTL38');
702: hr_utility.raise_error;
703: END IF;
704: END IF;--Bug# 13815085
705:
706: --Bug# 5132113

Line 715: hr_utility.set_message(8301,'GHR_38186_IG_PAY_CAP1');

711: ,'02'
712: ,'00'
713: ,l_pay_cap_in_data.effective_date);
714: IF l_pay_cap_amount < l_converted_adj_basic_pay THEN
715: hr_utility.set_message(8301,'GHR_38186_IG_PAY_CAP1');
716: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
717: hr_utility.raise_error;
718: END IF;
719: --End Bug# 7557159

Line 716: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);

712: ,'00'
713: ,l_pay_cap_in_data.effective_date);
714: IF l_pay_cap_amount < l_converted_adj_basic_pay THEN
715: hr_utility.set_message(8301,'GHR_38186_IG_PAY_CAP1');
716: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
717: hr_utility.raise_error;
718: END IF;
719: --End Bug# 7557159
720: ELSIF l_pay_plan in ( 'ES','EP','EV','IE','AL','AA','SL','IP','ST','CA','EE', 'FE' ) THEN

Line 717: hr_utility.raise_error;

713: ,l_pay_cap_in_data.effective_date);
714: IF l_pay_cap_amount < l_converted_adj_basic_pay THEN
715: hr_utility.set_message(8301,'GHR_38186_IG_PAY_CAP1');
716: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
717: hr_utility.raise_error;
718: END IF;
719: --End Bug# 7557159
720: ELSIF l_pay_plan in ( 'ES','EP','EV','IE','AL','AA','SL','IP','ST','CA','EE', 'FE' ) THEN
721: -- } 1

Line 729: hr_utility.set_location('CERTIFIED',123455);

725: ELSIF l_pay_plan in ( 'ES','EP','EV','IE','SL','IP','ST') THEN --Removed FE bug#5931199
726: -- { 2
727: IF ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date) ) THEN
728: -- { 3 -- check for pay plans initially then check for certification
729: hr_utility.set_location('CERTIFIED',123455);
730:
731: IF (l_pay_plan in ('ES','EP','EV','IE') ) THEN
732: --Begin Bug# 7633783
733: IF l_pay_cap_in_data.pay_rate_determinant = 'D' THEN

Line 746: hr_utility.set_location('INSIDE EX-02',123456);

742: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
743: ,'02'
744: ,'00'
745: ,l_pay_cap_in_data.effective_date);
746: hr_utility.set_location('INSIDE EX-02',123456);
747: hr_utility.set_location('pay cap amt :'||l_pay_cap_amount,1234567890);
748: END IF;
749: ELSIF (l_pay_plan in ('SL','ST','IP') ) THEN
750: --Begin Bug# 6807868, coded as per the Pay cap master chart

Line 747: hr_utility.set_location('pay cap amt :'||l_pay_cap_amount,1234567890);

743: ,'02'
744: ,'00'
745: ,l_pay_cap_in_data.effective_date);
746: hr_utility.set_location('INSIDE EX-02',123456);
747: hr_utility.set_location('pay cap amt :'||l_pay_cap_amount,1234567890);
748: END IF;
749: ELSIF (l_pay_plan in ('SL','ST','IP') ) THEN
750: --Begin Bug# 6807868, coded as per the Pay cap master chart
751: --Begin Bug# 7633783 added PRD S

Line 865: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');

861: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
862:
863: l_converted_total_salary := l_converted_adj_basic_pay + nvl(l_other_pay_amount,0);
864: ---Warning Message
865: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');
866: l_adj_basic_mesg_flag := 1;
867: END IF;
868:
869: -- } 1 else cond

Line 913: hr_utility.set_message(8301,'GHR_38186_IG_PAY_CAP1');

909:
910: --End bug# 8650322
911: --Begin bug# 8324201
912: IF l_pay_cap_in_data.pay_rate_determinant = '2' AND ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date)) THEN
913: hr_utility.set_message(8301,'GHR_38186_IG_PAY_CAP1');
914: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
915: hr_utility.raise_error;
916: ELSE
917: --End bug# 8324201

Line 914: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);

910: --End bug# 8650322
911: --Begin bug# 8324201
912: IF l_pay_cap_in_data.pay_rate_determinant = '2' AND ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date)) THEN
913: hr_utility.set_message(8301,'GHR_38186_IG_PAY_CAP1');
914: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
915: hr_utility.raise_error;
916: ELSE
917: --End bug# 8324201
918:

Line 915: hr_utility.raise_error;

911: --Begin bug# 8324201
912: IF l_pay_cap_in_data.pay_rate_determinant = '2' AND ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date)) THEN
913: hr_utility.set_message(8301,'GHR_38186_IG_PAY_CAP1');
914: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
915: hr_utility.raise_error;
916: ELSE
917: --End bug# 8324201
918:
919: -- Bug 5663050 Start

Line 939: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');

935:
936: l_converted_total_salary := l_converted_adj_basic_pay + nvl(l_other_pay_amount,0);
937: -- Bug 5663050 End
938:
939: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');
940: l_adj_basic_mesg_flag := 1;
941: END IF;
942: END IF;
943: ELSIF get_job_from_pos(l_pay_cap_in_data.effective_date, p_to_position_id) IN ('0602','0680')

Line 977: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');

973:
974: l_converted_total_salary := l_converted_adj_basic_pay + nvl(l_other_pay_amount,0);
975: -- Bug 5663050 End
976:
977: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');
978: l_adj_basic_mesg_flag := 1;
979: END IF;
980: END IF;
981: -- Bug 5482191 End

Line 1066: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');

1062: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
1063:
1064: l_converted_total_salary := l_converted_adj_basic_pay + nvl(l_other_pay_amount,0);
1065: ---Warning Message
1066: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');
1067: l_adj_basic_mesg_flag := 1;
1068: END IF;
1069: --END IF;
1070:

Line 1125: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');

1121: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
1122:
1123: l_converted_total_salary := l_converted_adj_basic_pay + nvl(l_other_pay_amount,0);
1124: ---Warning Message
1125: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');
1126: l_adj_basic_mesg_flag := 1;
1127: END IF;
1128: --END IF;
1129:

Line 1185: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');

1181: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
1182:
1183: l_converted_total_salary := l_converted_adj_basic_pay + nvl(l_other_pay_amount,0);
1184: ---Warning Message
1185: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');
1186: l_adj_basic_mesg_flag := 1;
1187: END IF;
1188: ELSIF ( nvl(l_au_overtime,0) = 0 ) AND (nvl(l_availability_pay,0) = 0) THEN
1189:

Line 1219: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');

1215: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
1216:
1217: l_converted_total_salary := l_converted_adj_basic_pay + nvl(l_other_pay_amount,0);
1218: ---Warning Message
1219: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');
1220: l_adj_basic_mesg_flag := 1;
1221: END IF;
1222: END IF; */
1223: END IF;

Line 1225: hr_utility.set_location('Before entering TPC logic CTS'||l_converted_total_salary,1);

1221: END IF;
1222: END IF; */
1223: END IF;
1224: -- } 1
1225: hr_utility.set_location('Before entering TPC logic CTS'||l_converted_total_salary,1);
1226: hr_utility.set_location('p_noa_code is '||p_noa_code,1);
1227: --Begin Bug# 7557159
1228: IF l_pay_plan in('IG') THEN
1229: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

Line 1226: hr_utility.set_location('p_noa_code is '||p_noa_code,1);

1222: END IF; */
1223: END IF;
1224: -- } 1
1225: hr_utility.set_location('Before entering TPC logic CTS'||l_converted_total_salary,1);
1226: hr_utility.set_location('p_noa_code is '||p_noa_code,1);
1227: --Begin Bug# 7557159
1228: IF l_pay_plan in('IG') THEN
1229: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1230: ,'01'

Line 1234: hr_utility.set_message(8301,'GHR_38187_IG_PAY_CAP2');

1230: ,'01'
1231: ,'00'
1232: ,l_pay_cap_in_data.effective_date);
1233: IF l_pay_cap_amount < l_converted_total_salary THEN
1234: hr_utility.set_message(8301,'GHR_38187_IG_PAY_CAP2');
1235: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1236: hr_utility.raise_error;
1237: END IF;
1238:

Line 1235: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);

1231: ,'00'
1232: ,l_pay_cap_in_data.effective_date);
1233: IF l_pay_cap_amount < l_converted_total_salary THEN
1234: hr_utility.set_message(8301,'GHR_38187_IG_PAY_CAP2');
1235: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1236: hr_utility.raise_error;
1237: END IF;
1238:
1239: --End Bug# 7557159

Line 1236: hr_utility.raise_error;

1232: ,l_pay_cap_in_data.effective_date);
1233: IF l_pay_cap_amount < l_converted_total_salary THEN
1234: hr_utility.set_message(8301,'GHR_38187_IG_PAY_CAP2');
1235: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1236: hr_utility.raise_error;
1237: END IF;
1238:
1239: --End Bug# 7557159
1240: --Bug# 5132113

Line 1247: hr_utility.set_message(8301,'GHR_38586_PAY_CAP6');

1243: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VX',
1244: '00','00',l_pay_cap_in_data.effective_date);
1245: -- Begin Bug# 7034637
1246: IF l_pay_cap_amount < l_converted_total_salary THEN
1247: hr_utility.set_message(8301,'GHR_38586_PAY_CAP6');
1248: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1249: hr_utility.raise_error;
1250: END IF;
1251: -- End Bug# 7034637

Line 1248: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);

1244: '00','00',l_pay_cap_in_data.effective_date);
1245: -- Begin Bug# 7034637
1246: IF l_pay_cap_amount < l_converted_total_salary THEN
1247: hr_utility.set_message(8301,'GHR_38586_PAY_CAP6');
1248: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1249: hr_utility.raise_error;
1250: END IF;
1251: -- End Bug# 7034637
1252: --Bug# 5132113

Line 1249: hr_utility.raise_error;

1245: -- Begin Bug# 7034637
1246: IF l_pay_cap_amount < l_converted_total_salary THEN
1247: hr_utility.set_message(8301,'GHR_38586_PAY_CAP6');
1248: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1249: hr_utility.raise_error;
1250: END IF;
1251: -- End Bug# 7034637
1252: --Bug# 5132113
1253: -- Bug#4168256 Added pay plan EV

Line 1274: hr_utility.set_location('INSIDE VZ-02',12345);

1270: ELSIF ( l_pay_plan in ( 'ES','EP','EV','IE') ) THEN --Removed FE bug#5931199
1271: -- Performance Certification Changes
1272: IF ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date)
1273: ) THEN
1274: hr_utility.set_location('INSIDE VZ-02',12345);
1275: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'
1276: ,'00'
1277: ,'00'
1278: ,l_pay_cap_in_data.effective_date);

Line 1313: hr_utility.set_location('CTS '||l_converted_total_salary,2);

1309: ,l_pay_cap_in_data.effective_date);
1310: END IF;
1311:
1312: --
1313: hr_utility.set_location('CTS '||l_converted_total_salary,2);
1314: hr_utility.set_location('PC '||l_pay_cap_amount,3);
1315:
1316: -- MADHURI add logic to check for from basic and to basic
1317: -- let not the user chaneg the basic if he is moved from cert to not cert

Line 1314: hr_utility.set_location('PC '||l_pay_cap_amount,3);

1310: END IF;
1311:
1312: --
1313: hr_utility.set_location('CTS '||l_converted_total_salary,2);
1314: hr_utility.set_location('PC '||l_pay_cap_amount,3);
1315:
1316: -- MADHURI add logic to check for from basic and to basic
1317: -- let not the user chaneg the basic if he is moved from cert to not cert
1318: --

Line 1331: hr_utility.set_location('Inside the Retro calc -- l_converted_total_sal '||l_converted_total_salary,1);

1327: ,p_effective_date => p_effective_date
1328: ,p_value => l_current_basic_pay
1329: ,p_multiple_error_flag => l_multi_error_flag);
1330: if nvl(p_basic_pay,0) >= nvl(l_current_basic_pay,0) then
1331: hr_utility.set_location('Inside the Retro calc -- l_converted_total_sal '||l_converted_total_salary,1);
1332:
1333: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
1334: ,p_input_value_name => 'Amount'
1335: ,p_assignment_id => l_assignment_id

Line 1340: hr_utility.set_location('Inside the Retro calc RA'||l_ret_allow_from_ele,2);

1336: ,p_effective_date => p_effective_date
1337: ,p_value => l_ret_allow_from_ele
1338: ,p_multiple_error_flag => l_multi_error_flag);
1339:
1340: hr_utility.set_location('Inside the Retro calc RA'||l_ret_allow_from_ele,2);
1341: hr_utility.set_location('Inside the Retro calc l_RA'||l_retention_allowance,3);
1342:
1343: ---Bug 2653521. Calculate the total salary with Old retention Allowance and Comapre with
1344: -------------- the pay cap amount. If the total salary is >= the pay cap amount then no

Line 1341: hr_utility.set_location('Inside the Retro calc l_RA'||l_retention_allowance,3);

1337: ,p_value => l_ret_allow_from_ele
1338: ,p_multiple_error_flag => l_multi_error_flag);
1339:
1340: hr_utility.set_location('Inside the Retro calc RA'||l_ret_allow_from_ele,2);
1341: hr_utility.set_location('Inside the Retro calc l_RA'||l_retention_allowance,3);
1342:
1343: ---Bug 2653521. Calculate the total salary with Old retention Allowance and Comapre with
1344: -------------- the pay cap amount. If the total salary is >= the pay cap amount then no
1345: -------------- need to increase the retention allowance. But if it is lesser then increase

Line 1387: hr_utility.set_location('l_converted_total_sal '||l_converted_total_salary,4);

1383: END IF;
1384:
1385:
1386:
1387: hr_utility.set_location('l_converted_total_sal '||l_converted_total_salary,4);
1388:
1389: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
1390: ,p_input_value_name => 'Amount'
1391: ,p_assignment_id => l_assignment_id

Line 1397: hr_utility.set_location('Inside TP loop '||l_pay_cap_amount,4);

1393: ,p_value => l_810_ra
1394: ,p_multiple_error_flag => l_multi_error_flag);
1395:
1396: IF l_converted_total_salary > l_pay_cap_amount THEN
1397: hr_utility.set_location('Inside TP loop '||l_pay_cap_amount,4);
1398: l_adjust_op_amt := l_converted_total_salary - l_pay_cap_amount;
1399: if l_adjust_op_amt < 0 then
1400: l_adjust_op_amt := l_adjust_op_amt * -1;
1401: end if;

Line 1422: hr_utility.set_location('l_difference is '||l_difference,1);

1418: --Pradeep for Bug 3306515.
1419:
1420: l_temp_ret_allo_percentage := trunc((l_temp_ret_allowance/p_basic_pay)*100,2);
1421:
1422: hr_utility.set_location('l_difference is '||l_difference,1);
1423: if p_noa_code <> '810' then
1424: if nvl(l_retention_allowance,0) > 0 then
1425: ----- Raise pay_cap_failed Raise Error Message
1426: --Pradeep Changed this error message for Bug 3306515.

Line 1427: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');

1423: if p_noa_code <> '810' then
1424: if nvl(l_retention_allowance,0) > 0 then
1425: ----- Raise pay_cap_failed Raise Error Message
1426: --Pradeep Changed this error message for Bug 3306515.
1427: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');
1428: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1429: hr_utility.set_message_token('CAL_OP_PERC' ,l_temp_ret_allo_percentage );
1430: l_non_810_error := TRUE;
1431: l_pay_cap_message := TRUE;

Line 1428: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);

1424: if nvl(l_retention_allowance,0) > 0 then
1425: ----- Raise pay_cap_failed Raise Error Message
1426: --Pradeep Changed this error message for Bug 3306515.
1427: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');
1428: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1429: hr_utility.set_message_token('CAL_OP_PERC' ,l_temp_ret_allo_percentage );
1430: l_non_810_error := TRUE;
1431: l_pay_cap_message := TRUE;
1432: raise pay_cap_failed;

Line 1429: hr_utility.set_message_token('CAL_OP_PERC' ,l_temp_ret_allo_percentage );

1425: ----- Raise pay_cap_failed Raise Error Message
1426: --Pradeep Changed this error message for Bug 3306515.
1427: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');
1428: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1429: hr_utility.set_message_token('CAL_OP_PERC' ,l_temp_ret_allo_percentage );
1430: l_non_810_error := TRUE;
1431: l_pay_cap_message := TRUE;
1432: raise pay_cap_failed;
1433: -------hr_utility.raise_error;

Line 1433: -------hr_utility.raise_error;

1429: hr_utility.set_message_token('CAL_OP_PERC' ,l_temp_ret_allo_percentage );
1430: l_non_810_error := TRUE;
1431: l_pay_cap_message := TRUE;
1432: raise pay_cap_failed;
1433: -------hr_utility.raise_error;
1434: end if;
1435: end if;
1436:
1437: if l_810_ra is null AND nvl(l_retention_allowance,0) > 0 then

Line 1454: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);

1450: -- l_capped_other_pay := l_pay_cap_amount - l_converted_adj_basic_pay;
1451: -- Bug # 4102958 changes end
1452: end if;
1453:
1454: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);
1455: -- Bug#3228580 Added Call to convert the Amount into the corresponding pay basis.
1456: l_difference := ghr_pay_calc.convert_amount(l_converted_total_salary - l_pay_cap_amount
1457: , 'PA'
1458: ,l_pay_basis);

Line 1481: hr_utility.set_location('l_converted_total_salary is '||l_converted_total_salary,1);

1477: l_other_pay_amount :=
1478: nvl(l_retention_allowance,0) + nvl(l_au_overtime,0) + nvl(l_availability_pay,0)
1479: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
1480: end if;
1481: hr_utility.set_location('l_converted_total_salary is '||l_converted_total_salary,1);
1482: hr_utility.set_location('l_v_capped_other_pay is '||l_v_capped_other_pay,1);
1483: hr_utility.set_location('l_supervisory_allowance is '||l_supervisory_allowance,1);
1484: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);
1485:

Line 1482: hr_utility.set_location('l_v_capped_other_pay is '||l_v_capped_other_pay,1);

1478: nvl(l_retention_allowance,0) + nvl(l_au_overtime,0) + nvl(l_availability_pay,0)
1479: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
1480: end if;
1481: hr_utility.set_location('l_converted_total_salary is '||l_converted_total_salary,1);
1482: hr_utility.set_location('l_v_capped_other_pay is '||l_v_capped_other_pay,1);
1483: hr_utility.set_location('l_supervisory_allowance is '||l_supervisory_allowance,1);
1484: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);
1485:
1486: /* for Bug 3306515 instead of Warning Message give an error message

Line 1483: hr_utility.set_location('l_supervisory_allowance is '||l_supervisory_allowance,1);

1479: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
1480: end if;
1481: hr_utility.set_location('l_converted_total_salary is '||l_converted_total_salary,1);
1482: hr_utility.set_location('l_v_capped_other_pay is '||l_v_capped_other_pay,1);
1483: hr_utility.set_location('l_supervisory_allowance is '||l_supervisory_allowance,1);
1484: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);
1485:
1486: /* for Bug 3306515 instead of Warning Message give an error message
1487: when supervisory allowance is present and give warning message

Line 1484: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);

1480: end if;
1481: hr_utility.set_location('l_converted_total_salary is '||l_converted_total_salary,1);
1482: hr_utility.set_location('l_v_capped_other_pay is '||l_v_capped_other_pay,1);
1483: hr_utility.set_location('l_supervisory_allowance is '||l_supervisory_allowance,1);
1484: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);
1485:
1486: /* for Bug 3306515 instead of Warning Message give an error message
1487: when supervisory allowance is present and give warning message
1488: and adjust the % when no supervisory is available.

Line 1499: hr_utility.set_location('l_ele_supervisory is '||l_ele_supervisory,1);

1495: ,p_effective_date => p_effective_date
1496: ,p_value => l_ele_supervisory
1497: ,p_multiple_error_flag => l_multi_error_flag);
1498:
1499: hr_utility.set_location('l_ele_supervisory is '||l_ele_supervisory,1);
1500:
1501: if nvl(l_v_capped_other_pay,0) <> nvl(l_capped_other_pay,0) then
1502: --hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');
1503: IF nvl(l_supervisory_allowance ,0) <> l_ele_supervisory THEN

Line 1502: --hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');

1498:
1499: hr_utility.set_location('l_ele_supervisory is '||l_ele_supervisory,1);
1500:
1501: if nvl(l_v_capped_other_pay,0) <> nvl(l_capped_other_pay,0) then
1502: --hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');
1503: IF nvl(l_supervisory_allowance ,0) <> l_ele_supervisory THEN
1504: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');
1505: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1506: hr_utility.set_message_token('CAL_OP_PERC',l_retention_allow_percentage);

Line 1504: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');

1500:
1501: if nvl(l_v_capped_other_pay,0) <> nvl(l_capped_other_pay,0) then
1502: --hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');
1503: IF nvl(l_supervisory_allowance ,0) <> l_ele_supervisory THEN
1504: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');
1505: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1506: hr_utility.set_message_token('CAL_OP_PERC',l_retention_allow_percentage);
1507: p_pay_cap_message := TRUE;
1508: raise pay_cap_failed;

Line 1505: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);

1501: if nvl(l_v_capped_other_pay,0) <> nvl(l_capped_other_pay,0) then
1502: --hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');
1503: IF nvl(l_supervisory_allowance ,0) <> l_ele_supervisory THEN
1504: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');
1505: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1506: hr_utility.set_message_token('CAL_OP_PERC',l_retention_allow_percentage);
1507: p_pay_cap_message := TRUE;
1508: raise pay_cap_failed;
1509: ELSE

Line 1506: hr_utility.set_message_token('CAL_OP_PERC',l_retention_allow_percentage);

1502: --hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');
1503: IF nvl(l_supervisory_allowance ,0) <> l_ele_supervisory THEN
1504: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');
1505: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1506: hr_utility.set_message_token('CAL_OP_PERC',l_retention_allow_percentage);
1507: p_pay_cap_message := TRUE;
1508: raise pay_cap_failed;
1509: ELSE
1510: hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');

Line 1510: hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');

1506: hr_utility.set_message_token('CAL_OP_PERC',l_retention_allow_percentage);
1507: p_pay_cap_message := TRUE;
1508: raise pay_cap_failed;
1509: ELSE
1510: hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');
1511: END IF;
1512:
1513: end if;
1514:

Line 1518: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);

1514:
1515:
1516: ELSIF l_converted_total_salary < l_pay_cap_amount THEN
1517: l_capped_other_pay := NULL;
1518: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);
1519: ELSIF l_converted_total_salary = l_pay_cap_amount THEN
1520:
1521: if nvl(l_810_ra ,0) > nvl(l_retention_allowance,0) then
1522: ----Basically no change in the capped other pay

Line 1559: hr_utility.set_message(8301,'GHR_38187_IG_PAY_CAP2');

1555: END IF;
1556: IF l_pay_cap_amount < l_converted_total_salary THEN
1557: --Begin bug# 8324201
1558: IF l_pay_cap_in_data.pay_rate_determinant = '2' AND ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date)) THEN
1559: hr_utility.set_message(8301,'GHR_38187_IG_PAY_CAP2');
1560: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1561: hr_utility.raise_error;
1562: ELSE
1563: --End bug# 8324201

Line 1560: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);

1556: IF l_pay_cap_amount < l_converted_total_salary THEN
1557: --Begin bug# 8324201
1558: IF l_pay_cap_in_data.pay_rate_determinant = '2' AND ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date)) THEN
1559: hr_utility.set_message(8301,'GHR_38187_IG_PAY_CAP2');
1560: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1561: hr_utility.raise_error;
1562: ELSE
1563: --End bug# 8324201
1564: l_converted_total_salary := l_pay_cap_amount;

Line 1561: hr_utility.raise_error;

1557: --Begin bug# 8324201
1558: IF l_pay_cap_in_data.pay_rate_determinant = '2' AND ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date)) THEN
1559: hr_utility.set_message(8301,'GHR_38187_IG_PAY_CAP2');
1560: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1561: hr_utility.raise_error;
1562: ELSE
1563: --End bug# 8324201
1564: l_converted_total_salary := l_pay_cap_amount;
1565: l_capped_other_pay := l_converted_total_salary - l_converted_adj_basic_pay;

Line 1566: hr_utility.set_message(8301,'GHR_38585_PAY_CAP5'); -- Bug 5663050

1562: ELSE
1563: --End bug# 8324201
1564: l_converted_total_salary := l_pay_cap_amount;
1565: l_capped_other_pay := l_converted_total_salary - l_converted_adj_basic_pay;
1566: hr_utility.set_message(8301,'GHR_38585_PAY_CAP5'); -- Bug 5663050
1567: END IF;
1568: END IF;
1569: -- Bug 5482191 End
1570: -- Bug 5663050 Start

Line 1583: hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');

1579: ,l_pay_cap_in_data.effective_date);
1580: IF l_pay_cap_amount < l_converted_total_salary THEN
1581: l_converted_total_salary := l_pay_cap_amount;
1582: l_capped_other_pay := l_converted_total_salary - l_converted_adj_basic_pay;
1583: hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');
1584: END IF;
1585: END IF;
1586: -- Bug 5663050 End
1587: END IF;

Line 1798: hr_utility.raise_error;

1794: ,p_message_set => p_message_set
1795: ,p_total_pay_check => p_total_pay_check);
1796:
1797: IF p_message_set THEN
1798: hr_utility.raise_error;
1799: END IF;
1800:
1801: END do_pay_caps_sql;
1802: