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 135: hr_utility.set_message(8301,'GHR_38583_PAY_CAP3');

131: ELSE
132: p_locality_adj := p_locality_adj;
133: p_adj_basic_pay := p_adj_basic_pay;
134: ghr_msl_pkg.g_ses_bp_capped := TRUE;
135: hr_utility.set_message(8301,'GHR_38583_PAY_CAP3');
136: hr_utility.raise_error;
137: END IF;
138: END IF;
139:

Line 136: hr_utility.raise_error;

132: p_locality_adj := p_locality_adj;
133: p_adj_basic_pay := p_adj_basic_pay;
134: ghr_msl_pkg.g_ses_bp_capped := TRUE;
135: hr_utility.set_message(8301,'GHR_38583_PAY_CAP3');
136: hr_utility.raise_error;
137: END IF;
138: END IF;
139:
140: END adj_basic_pay_cap;

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

230: FOR cur_ESSL_equivalent_rec IN cur_ESSL_equivalent(p_pay_plan)
231: LOOP
232: ll_pay_plan := cur_ESSL_equivalent_rec.equivalent_pay_plan;
233: END LOOP;
234: hr_utility.set_location('INSIDE perf_cert loop'||p_org_id,123453);
235: hr_utility.set_location('INSIDE perf_cert loop'||p_effective_date,123453);
236: hr_utility.set_location('INSIDE perf_cert loop'||p_pay_plan,123453);
237: hr_utility.set_location('INSIDE perf_cert loop'||p_agency_code,123453);
238: --

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

231: LOOP
232: ll_pay_plan := cur_ESSL_equivalent_rec.equivalent_pay_plan;
233: END LOOP;
234: hr_utility.set_location('INSIDE perf_cert loop'||p_org_id,123453);
235: hr_utility.set_location('INSIDE perf_cert loop'||p_effective_date,123453);
236: hr_utility.set_location('INSIDE perf_cert loop'||p_pay_plan,123453);
237: hr_utility.set_location('INSIDE perf_cert loop'||p_agency_code,123453);
238: --
239: -- 1st LEVEL CHECK

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

232: ll_pay_plan := cur_ESSL_equivalent_rec.equivalent_pay_plan;
233: END LOOP;
234: hr_utility.set_location('INSIDE perf_cert loop'||p_org_id,123453);
235: hr_utility.set_location('INSIDE perf_cert loop'||p_effective_date,123453);
236: hr_utility.set_location('INSIDE perf_cert loop'||p_pay_plan,123453);
237: hr_utility.set_location('INSIDE perf_cert loop'||p_agency_code,123453);
238: --
239: -- 1st LEVEL CHECK
240: -- CHECK if Agency level certification exists

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

233: END LOOP;
234: hr_utility.set_location('INSIDE perf_cert loop'||p_org_id,123453);
235: hr_utility.set_location('INSIDE perf_cert loop'||p_effective_date,123453);
236: hr_utility.set_location('INSIDE perf_cert loop'||p_pay_plan,123453);
237: hr_utility.set_location('INSIDE perf_cert loop'||p_agency_code,123453);
238: --
239: -- 1st LEVEL CHECK
240: -- CHECK if Agency level certification exists
241: --

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

243: p_agency_code,
244: ll_pay_plan)
245: LOOP
246: l_cert := TRUE;
247: hr_utility.set_location('INSIDE perf_cert AGNCY loop'||p_org_id,123453);
248: END LOOP;
249:
250: IF NOT l_cert THEN
251: --

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

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

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

267: p_org_id,
268: ll_pay_plan)
269: LOOP
270: l_cert := TRUE;
271: hr_utility.set_location('INSIDE perf_cert ORG loop'||p_org_id,123453);
272: END LOOP;
273: END IF;
274:
275: END IF;

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

479: l_pay_cap_in_data.supervisory_allowance := p_supervisory_allowance;
480: l_pay_cap_in_data.staffing_differential := p_staffing_differential;
481: l_pay_cap_in_data.pa_request_id := p_pa_request_id;
482:
483: hr_utility.set_location('One ',1);
484: l_retention_allowance := p_retention_allowance;
485: l_retention_allow_percentage := p_retention_allow_percentage;
486: l_au_overtime := p_au_overtime;
487: l_availability_pay := p_availability_pay;

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

556: ,p_effective_date => p_effective_date
557: ,p_value => l_to_ap_premium_pay_indicator
558: ,p_multiple_error_flag => l_multi_error_flag);
559:
560: hr_utility.set_location('Two ',1);
561: -- Bug 710431 If PRD is ABEFU or V then get retained grade details
562: --
563: IF l_pay_cap_in_data.pay_rate_determinant IN ('A','B','E','F','U','V') THEN
564: -- use retained details...

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

656: IF NOT (pay_cap_chk_ttl_38( l_pos_ei_valid_grade.poei_information12,
657: l_pos_ei_valid_grade.poei_information13,
658: l_converted_adj_basic_pay,
659: p_effective_date)) THEN
660: hr_utility.set_message(8301,'GHR_37448_PAY_CAP_TTL38');
661: hr_utility.raise_error;
662: END IF;
663:
664: --Bug# 5132113

Line 661: hr_utility.raise_error;

657: l_pos_ei_valid_grade.poei_information13,
658: l_converted_adj_basic_pay,
659: p_effective_date)) THEN
660: hr_utility.set_message(8301,'GHR_37448_PAY_CAP_TTL38');
661: hr_utility.raise_error;
662: END IF;
663:
664: --Bug# 5132113
665: --Begin Bug# 7557159

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

669: ,'02'
670: ,'00'
671: ,l_pay_cap_in_data.effective_date);
672: IF l_pay_cap_amount < l_converted_adj_basic_pay THEN
673: hr_utility.set_message(8301,'GHR_38186_IG_PAY_CAP1');
674: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
675: hr_utility.raise_error;
676: END IF;
677: --End Bug# 7557159

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

670: ,'00'
671: ,l_pay_cap_in_data.effective_date);
672: IF l_pay_cap_amount < l_converted_adj_basic_pay THEN
673: hr_utility.set_message(8301,'GHR_38186_IG_PAY_CAP1');
674: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
675: hr_utility.raise_error;
676: END IF;
677: --End Bug# 7557159
678: ELSIF l_pay_plan in ( 'ES','EP','EV','IE','AL','AA','SL','IP','ST','CA','EE', 'FE' ) THEN

Line 675: hr_utility.raise_error;

671: ,l_pay_cap_in_data.effective_date);
672: IF l_pay_cap_amount < l_converted_adj_basic_pay THEN
673: hr_utility.set_message(8301,'GHR_38186_IG_PAY_CAP1');
674: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
675: hr_utility.raise_error;
676: END IF;
677: --End Bug# 7557159
678: ELSIF l_pay_plan in ( 'ES','EP','EV','IE','AL','AA','SL','IP','ST','CA','EE', 'FE' ) THEN
679: -- } 1

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

684: -- { 2
685: IF ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date) )
686: THEN
687: -- { 3 -- check for pay plans initially then check for certification
688: hr_utility.set_location('CERTIFIED',123455);
689:
690: IF (l_pay_plan in ('ES','EP','EV','IE') ) THEN
691: --Begin Bug# 7633783
692: IF l_pay_cap_in_data.pay_rate_determinant = 'D' THEN

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

701: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
702: ,'02'
703: ,'00'
704: ,l_pay_cap_in_data.effective_date);
705: hr_utility.set_location('INSIDE EX-02',123456);
706: hr_utility.set_location('pay cap amt :'||l_pay_cap_amount,1234567890);
707: END IF;
708: ELSIF (l_pay_plan in ('SL','ST','IP') ) THEN
709: --Begin Bug# 6807868, coded as per the Pay cap master chart

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

702: ,'02'
703: ,'00'
704: ,l_pay_cap_in_data.effective_date);
705: hr_utility.set_location('INSIDE EX-02',123456);
706: hr_utility.set_location('pay cap amt :'||l_pay_cap_amount,1234567890);
707: END IF;
708: ELSIF (l_pay_plan in ('SL','ST','IP') ) THEN
709: --Begin Bug# 6807868, coded as per the Pay cap master chart
710: --Begin Bug# 7633783 added PRD S

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

786: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
787:
788: l_converted_total_salary := l_converted_adj_basic_pay + nvl(l_other_pay_amount,0);
789: ---Warning Message
790: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');
791: l_adj_basic_mesg_flag := 1;
792: END IF;
793:
794: -- } 1 else cond

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

841:
842: l_converted_total_salary := l_converted_adj_basic_pay + nvl(l_other_pay_amount,0);
843: -- Bug 5663050 End
844:
845: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');
846: l_adj_basic_mesg_flag := 1;
847: END IF;
848: ELSIF get_job_from_pos(l_pay_cap_in_data.effective_date, p_to_position_id) IN ('0602','0680')
849: AND (l_pay_plan = 'YG' OR

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

878:
879: l_converted_total_salary := l_converted_adj_basic_pay + nvl(l_other_pay_amount,0);
880: -- Bug 5663050 End
881:
882: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');
883: l_adj_basic_mesg_flag := 1;
884: END IF;
885: END IF;
886: -- Bug 5482191 End

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

955: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
956:
957: l_converted_total_salary := l_converted_adj_basic_pay + nvl(l_other_pay_amount,0);
958: ---Warning Message
959: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');
960: l_adj_basic_mesg_flag := 1;
961: END IF;
962: --END IF;
963:

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

1014: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
1015:
1016: l_converted_total_salary := l_converted_adj_basic_pay + nvl(l_other_pay_amount,0);
1017: ---Warning Message
1018: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');
1019: l_adj_basic_mesg_flag := 1;
1020: END IF;
1021: --END IF;
1022:

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

1074: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
1075:
1076: l_converted_total_salary := l_converted_adj_basic_pay + nvl(l_other_pay_amount,0);
1077: ---Warning Message
1078: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');
1079: l_adj_basic_mesg_flag := 1;
1080: END IF;
1081: ELSIF ( nvl(l_au_overtime,0) = 0 ) AND (nvl(l_availability_pay,0) = 0) THEN
1082:

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

1108: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
1109:
1110: l_converted_total_salary := l_converted_adj_basic_pay + nvl(l_other_pay_amount,0);
1111: ---Warning Message
1112: hr_utility.set_message(8301,'GHR_38581_PAY_CAP1');
1113: l_adj_basic_mesg_flag := 1;
1114: END IF;
1115: END IF; */
1116: END IF;

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

1114: END IF;
1115: END IF; */
1116: END IF;
1117: -- } 1
1118: hr_utility.set_location('Before entering TPC logic CTS'||l_converted_total_salary,1);
1119: hr_utility.set_location('p_noa_code is '||p_noa_code,1);
1120: --Begin Bug# 7557159
1121: IF l_pay_plan in('IG') THEN
1122: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

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

1115: END IF; */
1116: END IF;
1117: -- } 1
1118: hr_utility.set_location('Before entering TPC logic CTS'||l_converted_total_salary,1);
1119: hr_utility.set_location('p_noa_code is '||p_noa_code,1);
1120: --Begin Bug# 7557159
1121: IF l_pay_plan in('IG') THEN
1122: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
1123: ,'01'

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

1123: ,'01'
1124: ,'00'
1125: ,l_pay_cap_in_data.effective_date);
1126: IF l_pay_cap_amount < l_converted_total_salary THEN
1127: hr_utility.set_message(8301,'GHR_38187_IG_PAY_CAP2');
1128: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1129: hr_utility.raise_error;
1130: END IF;
1131:

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

1124: ,'00'
1125: ,l_pay_cap_in_data.effective_date);
1126: IF l_pay_cap_amount < l_converted_total_salary THEN
1127: hr_utility.set_message(8301,'GHR_38187_IG_PAY_CAP2');
1128: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1129: hr_utility.raise_error;
1130: END IF;
1131:
1132: --End Bug# 7557159

Line 1129: hr_utility.raise_error;

1125: ,l_pay_cap_in_data.effective_date);
1126: IF l_pay_cap_amount < l_converted_total_salary THEN
1127: hr_utility.set_message(8301,'GHR_38187_IG_PAY_CAP2');
1128: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1129: hr_utility.raise_error;
1130: END IF;
1131:
1132: --End Bug# 7557159
1133: --Bug# 5132113

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

1136: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VX',
1137: '00','00',l_pay_cap_in_data.effective_date);
1138: -- Begin Bug# 7034637
1139: IF l_pay_cap_amount < l_converted_total_salary THEN
1140: hr_utility.set_message(8301,'GHR_38586_PAY_CAP6');
1141: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1142: hr_utility.raise_error;
1143: END IF;
1144: -- End Bug# 7034637

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

1137: '00','00',l_pay_cap_in_data.effective_date);
1138: -- Begin Bug# 7034637
1139: IF l_pay_cap_amount < l_converted_total_salary THEN
1140: hr_utility.set_message(8301,'GHR_38586_PAY_CAP6');
1141: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1142: hr_utility.raise_error;
1143: END IF;
1144: -- End Bug# 7034637
1145: --Bug# 5132113

Line 1142: hr_utility.raise_error;

1138: -- Begin Bug# 7034637
1139: IF l_pay_cap_amount < l_converted_total_salary THEN
1140: hr_utility.set_message(8301,'GHR_38586_PAY_CAP6');
1141: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1142: hr_utility.raise_error;
1143: END IF;
1144: -- End Bug# 7034637
1145: --Bug# 5132113
1146: -- Bug#4168256 Added pay plan EV

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

1162: ELSIF ( l_pay_plan in ( 'ES','EP','EV','IE') ) THEN --Removed FE bug#5931199
1163: -- Performance Certification Changes
1164: IF ( perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, p_effective_date)
1165: ) THEN
1166: hr_utility.set_location('INSIDE VZ-02',12345);
1167: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('VZ'
1168: ,'00'
1169: ,'00'
1170: ,l_pay_cap_in_data.effective_date);

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

1201: ,l_pay_cap_in_data.effective_date);
1202: END IF;
1203:
1204: --
1205: hr_utility.set_location('CTS '||l_converted_total_salary,2);
1206: hr_utility.set_location('PC '||l_pay_cap_amount,3);
1207:
1208: -- MADHURI add logic to check for from basic and to basic
1209: -- let not the user chaneg the basic if he is moved from cert to not cert

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

1202: END IF;
1203:
1204: --
1205: hr_utility.set_location('CTS '||l_converted_total_salary,2);
1206: hr_utility.set_location('PC '||l_pay_cap_amount,3);
1207:
1208: -- MADHURI add logic to check for from basic and to basic
1209: -- let not the user chaneg the basic if he is moved from cert to not cert
1210: --

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

1219: ,p_effective_date => p_effective_date
1220: ,p_value => l_current_basic_pay
1221: ,p_multiple_error_flag => l_multi_error_flag);
1222: if nvl(p_basic_pay,0) >= nvl(l_current_basic_pay,0) then
1223: hr_utility.set_location('Inside the Retro calc -- l_converted_total_sal '||l_converted_total_salary,1);
1224:
1225: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
1226: ,p_input_value_name => 'Amount'
1227: ,p_assignment_id => l_assignment_id

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

1228: ,p_effective_date => p_effective_date
1229: ,p_value => l_ret_allow_from_ele
1230: ,p_multiple_error_flag => l_multi_error_flag);
1231:
1232: hr_utility.set_location('Inside the Retro calc RA'||l_ret_allow_from_ele,2);
1233: hr_utility.set_location('Inside the Retro calc l_RA'||l_retention_allowance,3);
1234:
1235: ---Bug 2653521. Calculate the total salary with Old retention Allowance and Comapre with
1236: -------------- the pay cap amount. If the total salary is >= the pay cap amount then no

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

1229: ,p_value => l_ret_allow_from_ele
1230: ,p_multiple_error_flag => l_multi_error_flag);
1231:
1232: hr_utility.set_location('Inside the Retro calc RA'||l_ret_allow_from_ele,2);
1233: hr_utility.set_location('Inside the Retro calc l_RA'||l_retention_allowance,3);
1234:
1235: ---Bug 2653521. Calculate the total salary with Old retention Allowance and Comapre with
1236: -------------- the pay cap amount. If the total salary is >= the pay cap amount then no
1237: -------------- need to increase the retention allowance. But if it is lesser then increase

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

1275: END IF;
1276:
1277:
1278:
1279: hr_utility.set_location('l_converted_total_sal '||l_converted_total_salary,4);
1280:
1281: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
1282: ,p_input_value_name => 'Amount'
1283: ,p_assignment_id => l_assignment_id

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

1285: ,p_value => l_810_ra
1286: ,p_multiple_error_flag => l_multi_error_flag);
1287:
1288: IF l_converted_total_salary > l_pay_cap_amount THEN
1289: hr_utility.set_location('Inside TP loop '||l_pay_cap_amount,4);
1290: l_adjust_op_amt := l_converted_total_salary - l_pay_cap_amount;
1291: if l_adjust_op_amt < 0 then
1292: l_adjust_op_amt := l_adjust_op_amt * -1;
1293: end if;

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

1310: --Pradeep for Bug 3306515.
1311:
1312: l_temp_ret_allo_percentage := trunc((l_temp_ret_allowance/p_basic_pay)*100,2);
1313:
1314: hr_utility.set_location('l_difference is '||l_difference,1);
1315: if p_noa_code <> '810' then
1316: if nvl(l_retention_allowance,0) > 0 then
1317: ----- Raise pay_cap_failed Raise Error Message
1318: --Pradeep Changed this error message for Bug 3306515.

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

1315: if p_noa_code <> '810' then
1316: if nvl(l_retention_allowance,0) > 0 then
1317: ----- Raise pay_cap_failed Raise Error Message
1318: --Pradeep Changed this error message for Bug 3306515.
1319: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');
1320: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1321: hr_utility.set_message_token('CAL_OP_PERC' ,l_temp_ret_allo_percentage );
1322: l_non_810_error := TRUE;
1323: l_pay_cap_message := TRUE;

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

1316: if nvl(l_retention_allowance,0) > 0 then
1317: ----- Raise pay_cap_failed Raise Error Message
1318: --Pradeep Changed this error message for Bug 3306515.
1319: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');
1320: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1321: hr_utility.set_message_token('CAL_OP_PERC' ,l_temp_ret_allo_percentage );
1322: l_non_810_error := TRUE;
1323: l_pay_cap_message := TRUE;
1324: raise pay_cap_failed;

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

1317: ----- Raise pay_cap_failed Raise Error Message
1318: --Pradeep Changed this error message for Bug 3306515.
1319: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');
1320: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1321: hr_utility.set_message_token('CAL_OP_PERC' ,l_temp_ret_allo_percentage );
1322: l_non_810_error := TRUE;
1323: l_pay_cap_message := TRUE;
1324: raise pay_cap_failed;
1325: -------hr_utility.raise_error;

Line 1325: -------hr_utility.raise_error;

1321: hr_utility.set_message_token('CAL_OP_PERC' ,l_temp_ret_allo_percentage );
1322: l_non_810_error := TRUE;
1323: l_pay_cap_message := TRUE;
1324: raise pay_cap_failed;
1325: -------hr_utility.raise_error;
1326: end if;
1327: end if;
1328:
1329: if l_810_ra is null AND nvl(l_retention_allowance,0) > 0 then

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

1342: -- l_capped_other_pay := l_pay_cap_amount - l_converted_adj_basic_pay;
1343: -- Bug # 4102958 changes end
1344: end if;
1345:
1346: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);
1347: -- Bug#3228580 Added Call to convert the Amount into the corresponding pay basis.
1348: l_difference := ghr_pay_calc.convert_amount(l_converted_total_salary - l_pay_cap_amount
1349: , 'PA'
1350: ,l_pay_basis);

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

1369: l_other_pay_amount :=
1370: nvl(l_retention_allowance,0) + nvl(l_au_overtime,0) + nvl(l_availability_pay,0)
1371: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
1372: end if;
1373: hr_utility.set_location('l_converted_total_salary is '||l_converted_total_salary,1);
1374: hr_utility.set_location('l_v_capped_other_pay is '||l_v_capped_other_pay,1);
1375: hr_utility.set_location('l_supervisory_allowance is '||l_supervisory_allowance,1);
1376: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);
1377:

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

1370: nvl(l_retention_allowance,0) + nvl(l_au_overtime,0) + nvl(l_availability_pay,0)
1371: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
1372: end if;
1373: hr_utility.set_location('l_converted_total_salary is '||l_converted_total_salary,1);
1374: hr_utility.set_location('l_v_capped_other_pay is '||l_v_capped_other_pay,1);
1375: hr_utility.set_location('l_supervisory_allowance is '||l_supervisory_allowance,1);
1376: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);
1377:
1378: /* for Bug 3306515 instead of Warning Message give an error message

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

1371: + nvl(l_supervisory_allowance,0) + nvl(l_staffing_differential,0);
1372: end if;
1373: hr_utility.set_location('l_converted_total_salary is '||l_converted_total_salary,1);
1374: hr_utility.set_location('l_v_capped_other_pay is '||l_v_capped_other_pay,1);
1375: hr_utility.set_location('l_supervisory_allowance is '||l_supervisory_allowance,1);
1376: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);
1377:
1378: /* for Bug 3306515 instead of Warning Message give an error message
1379: when supervisory allowance is present and give warning message

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

1372: end if;
1373: hr_utility.set_location('l_converted_total_salary is '||l_converted_total_salary,1);
1374: hr_utility.set_location('l_v_capped_other_pay is '||l_v_capped_other_pay,1);
1375: hr_utility.set_location('l_supervisory_allowance is '||l_supervisory_allowance,1);
1376: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);
1377:
1378: /* for Bug 3306515 instead of Warning Message give an error message
1379: when supervisory allowance is present and give warning message
1380: and adjust the % when no supervisory is available.

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

1387: ,p_effective_date => p_effective_date
1388: ,p_value => l_ele_supervisory
1389: ,p_multiple_error_flag => l_multi_error_flag);
1390:
1391: hr_utility.set_location('l_ele_supervisory is '||l_ele_supervisory,1);
1392:
1393: if nvl(l_v_capped_other_pay,0) <> nvl(l_capped_other_pay,0) then
1394: --hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');
1395: IF nvl(l_supervisory_allowance ,0) <> l_ele_supervisory THEN

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

1390:
1391: hr_utility.set_location('l_ele_supervisory is '||l_ele_supervisory,1);
1392:
1393: if nvl(l_v_capped_other_pay,0) <> nvl(l_capped_other_pay,0) then
1394: --hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');
1395: IF nvl(l_supervisory_allowance ,0) <> l_ele_supervisory THEN
1396: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');
1397: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1398: hr_utility.set_message_token('CAL_OP_PERC',l_retention_allow_percentage);

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

1392:
1393: if nvl(l_v_capped_other_pay,0) <> nvl(l_capped_other_pay,0) then
1394: --hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');
1395: IF nvl(l_supervisory_allowance ,0) <> l_ele_supervisory THEN
1396: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');
1397: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1398: hr_utility.set_message_token('CAL_OP_PERC',l_retention_allow_percentage);
1399: p_pay_cap_message := TRUE;
1400: raise pay_cap_failed;

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

1393: if nvl(l_v_capped_other_pay,0) <> nvl(l_capped_other_pay,0) then
1394: --hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');
1395: IF nvl(l_supervisory_allowance ,0) <> l_ele_supervisory THEN
1396: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');
1397: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1398: hr_utility.set_message_token('CAL_OP_PERC',l_retention_allow_percentage);
1399: p_pay_cap_message := TRUE;
1400: raise pay_cap_failed;
1401: ELSE

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

1394: --hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');
1395: IF nvl(l_supervisory_allowance ,0) <> l_ele_supervisory THEN
1396: hr_utility.set_message(8301,'GHR_38893_PAY_CAP7');
1397: hr_utility.set_message_token('PAY_CAP_AMT',l_pay_cap_amount);
1398: hr_utility.set_message_token('CAL_OP_PERC',l_retention_allow_percentage);
1399: p_pay_cap_message := TRUE;
1400: raise pay_cap_failed;
1401: ELSE
1402: hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');

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

1398: hr_utility.set_message_token('CAL_OP_PERC',l_retention_allow_percentage);
1399: p_pay_cap_message := TRUE;
1400: raise pay_cap_failed;
1401: ELSE
1402: hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');
1403: END IF;
1404:
1405: end if;
1406:

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

1406:
1407:
1408: ELSIF l_converted_total_salary < l_pay_cap_amount THEN
1409: l_capped_other_pay := NULL;
1410: hr_utility.set_location('l_capped_other_pay is '||l_capped_other_pay,1);
1411: ELSIF l_converted_total_salary = l_pay_cap_amount THEN
1412:
1413: if nvl(l_810_ra ,0) > nvl(l_retention_allowance,0) then
1414: ----Basically no change in the capped other pay

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

1440: END IF;
1441: IF l_pay_cap_amount < l_converted_total_salary THEN
1442: l_converted_total_salary := l_pay_cap_amount;
1443: l_capped_other_pay := l_converted_total_salary - l_converted_adj_basic_pay;
1444: hr_utility.set_message(8301,'GHR_38585_PAY_CAP5'); -- Bug 5663050
1445: END IF;
1446: -- Bug 5482191 End
1447: -- Bug 5663050 Start
1448: ELSIF get_job_from_pos(l_pay_cap_in_data.effective_date, p_to_position_id) IN ('0602','0680')

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

1456: ,l_pay_cap_in_data.effective_date);
1457: IF l_pay_cap_amount < l_converted_total_salary THEN
1458: l_converted_total_salary := l_pay_cap_amount;
1459: l_capped_other_pay := l_converted_total_salary - l_converted_adj_basic_pay;
1460: hr_utility.set_message(8301,'GHR_38585_PAY_CAP5');
1461: END IF;
1462: END IF;
1463: -- Bug 5663050 End
1464: END IF;

Line 1674: hr_utility.raise_error;

1670: ,p_message_set => p_message_set
1671: ,p_total_pay_check => p_total_pay_check);
1672:
1673: IF p_message_set THEN
1674: hr_utility.raise_error;
1675: END IF;
1676:
1677: END do_pay_caps_sql;
1678: