[Home] [Help]
52: -- 18-Sep-00 vravikan 01-Oct-99 Add Z
53: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
54: /* If rating of record (pattern) is A, Then rating of record(level) must
55: be 1,3,X or Z. */
56: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
57: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
58: if p_rating_of_record_pattern = 'A' and
59: p_rating_of_record_level not in ('1','3','X','Z') and
60: p_rating_of_record_level is not null then
76: -- 18-Sep-00 vravikan 01-Oct-99 Add Z
77: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
78: /* If rating of record (pattern) is B, Then rating of record(level) must
79: be 1,3,5,X or Z. */
80: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
81: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
82: if p_rating_of_record_pattern = 'B' and
83: p_rating_of_record_level not in ('1','3','5','X','Z') and
84: p_rating_of_record_level is not null then
100: -- 18-Sep-00 vravikan 01-Oct-99 Add Z
101: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
102: /* If rating of record (pattern) is C, Then rating of record(level) must
103: be 1,3,4,X or Z. */
104: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
105: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
106: if p_rating_of_record_pattern = 'C' and
107: p_rating_of_record_level not in ('1','3','4','X','Z') and
108: p_rating_of_record_level is not null then
124: -- 18-Sep-00 vravikan 01-Oct-99 Add Z
125: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
126: /* If rating of record (pattern) is D, Then rating of record(level) must
127: be 1,2,3,X or Z. */
128: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
129: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
130: if p_rating_of_record_pattern = 'D' and
131: p_rating_of_record_level not in ('1','2','3','X','Z') and
132: p_rating_of_record_level is not null then
149: -- 18-Sep-00 vravikan 01-Oct-99 Add Z
150: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
151: /* If rating of record (pattern) is E, Then rating of record(level) must
152: be 1,3,4,5,X or Z. */
153: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
154: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
155: if p_rating_of_record_pattern = 'E' and
156: p_rating_of_record_level not in ('1','3','4','5','X','Z') and
157: p_rating_of_record_level is not null then
173: -- 18-Sep-00 vravikan 01-Oct-99 Add Z
174: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
175: /* If rating of record (pattern) is F, Then rating of record(level) must
176: be 1,2,3,5,X or Z. */
177: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
178: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
179: if p_rating_of_record_pattern = 'F' and
180: p_rating_of_record_level not in ('1','2','3','5','X','Z') and
181: p_rating_of_record_level is not null then
197: -- 18-Sep-00 vravikan 01-Oct-99 Add Z
198: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
199: /* If rating of record (pattern) is G, Then rating of record(level) must
200: be 1,2,3,4,X or Z. */
201: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
202: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
203: if p_rating_of_record_pattern = 'G' and
204: p_rating_of_record_level not in ('1','2','3','4','X','Z') and
205: p_rating_of_record_level is not null then
221: -- 02/16/00 vravikan 1196230 Add record_level 'Z'
222: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
223: /* If rating of record (pattern) is H, Then rating of record(level) must
224: be 1,2,3,4,5,X or Z. */
225: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
226: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
227: if p_rating_of_record_pattern = 'H' and
228: p_rating_of_record_level not in ('1','2','3','4','5','X','Z') and
229: p_rating_of_record_level is not null then
252: end if;
253:
254: --471.03.3
255: -- 10/6 08/16/99 vravikan 01-Oct-99 New Edit
256: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01') then
257: if p_to_pay_plan in ('ES') and
258: (p_rating_of_record_pattern is not null and
259: p_rating_of_record_pattern in ('A','B','C','E') ) then
260: hr_utility.set_message(8301, 'GHR_37184_ALL_PROCEDURE_FAIL');
276:
277: /* void due to lack of submission date
278: --472.02.1
279: if p_rating_of_record_period is not null and
280: fnd_date.canonical_to_date(p_rating_of_record_period) > p_submission_date then
281: hr_utility.set_message(8301, 'GHR_37503_ALL_PROCEDURE_FAIL');
282: hr_utility.raise_error;
283: end if;
284: */
286: --bug description
287:
288: /*--472.02.2
289: if p_rating_of_record_period is not null and
290: fnd_date.canonical_to_date(p_rating_of_record_period) > p_effective_date then
291: hr_utility.set_message(8301, 'GHR_37504_ALL_PROCEDURE_FAIL');
292: hr_utility.raise_error;
293: end if;
294: */
306: /* If rating of record (period) is not spaces,
307: Then it must not be more than 5 years earlier than the effective date of
308: personnel action.
309: */
310: l_end_date := fnd_date.canonical_to_date(p_rating_of_record_period);
311: l_start_date := fnd_date.canonical_to_date(p_rating_of_record_per_starts);
312: if p_effective_date >= to_date('2000/10/01','yyyy/mm/dd') and
313: ((p_rating_of_record_period is not null and
314: months_between(p_effective_date,l_end_date ) > 60) or
307: Then it must not be more than 5 years earlier than the effective date of
308: personnel action.
309: */
310: l_end_date := fnd_date.canonical_to_date(p_rating_of_record_period);
311: l_start_date := fnd_date.canonical_to_date(p_rating_of_record_per_starts);
312: if p_effective_date >= to_date('2000/10/01','yyyy/mm/dd') and
313: ((p_rating_of_record_period is not null and
314: months_between(p_effective_date,l_end_date ) > 60) or
315: (p_rating_of_record_per_starts is not null and
423: -- amrchakr 26-SEP-2006 Removed the NOACS- '150','151','153',
424: -- '154','155', '157' effective from 2003/07/01
425: -------------------------------------------------------------
426: -- 500.16.2
427: if p_effective_date < fnd_date.canonical_to_date('2003/07/01') then
428: if p_first_noac_lookup_code in ('150','151','153','154','155',
429: '157','170','171','550','551',
430: '553','554','555','570','571')
431: and
833: end if;
834: -- 540.06.2
835: -- Update/Change Date By Effective Date Comment
836: -- 9/2 08/16/99 vravikan 01-Mar-1999 New Edit
837: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
838: if p_prior_pay_plan = 'EZ' and
839: p_prior_grade not between '01' and '08'
840: and
841: p_prior_grade is not null
892: -- If prior pay plan is CY,
893: -- Then prior grade must be 01 through 24 or asterisks.
894: --
895: -- Included effective date on 16-jul-1998
896: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
897: if p_prior_pay_plan = 'CY' and
898: p_prior_grade not between '01' and '24' and
899: p_prior_grade is not null then
900: hr_utility.set_message(8301, 'GHR_37874_ALL_PROCEDURE_FAIL');
934:
935: -- 540.22.2
936: -- Update/Change Date By Effective Date Comment
937: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
938: IF p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
939: if p_prior_pay_plan = 'VM' and
940: p_prior_grade not in ('11','12','13','14','15','96','97') and
941: p_prior_grade is not null
942: then
1020: -- 540.35.2
1021: --
1022: -- added on 16 jul 98 as per update 7
1023: --
1024: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1025: if p_prior_pay_plan in ('NH', 'NJ') and
1026: p_prior_grade not between '01' and '04' and
1027: p_prior_grade is not null then
1028: hr_utility.set_message(8301, 'GHR_37871_ALL_PROCEDURE_FAIL');
1033: -- 540.36.2
1034: --
1035: -- added on 16 jul 98 as per update 7
1036: --
1037: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1038: if p_prior_pay_plan = 'NK' and
1039: p_prior_grade not between '01' and '03' and
1040: p_prior_grade is not null then
1041: hr_utility.set_message(8301, 'GHR_37872_ALL_PROCEDURE_FAIL');
1059: -- 8 01/28/99 vravikan 10/01/1998 New Edit
1060: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
1061: -- If prior pay plan is FV, then prior grade must be 'AA' through 'MM' or asterisks
1062: --
1063: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') and
1064: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1065: if p_prior_pay_plan = 'FV' and
1066: p_prior_grade not in ('AA','BB','CC','DD','EE','FF','GG','HH','II',
1067: 'JJ','KK','LL','MM') and
1060: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
1061: -- If prior pay plan is FV, then prior grade must be 'AA' through 'MM' or asterisks
1062: --
1063: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') and
1064: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1065: if p_prior_pay_plan = 'FV' and
1066: p_prior_grade not in ('AA','BB','CC','DD','EE','FF','GG','HH','II',
1067: 'JJ','KK','LL','MM') and
1068: p_prior_grade is not null then
1076: -- Update Date By Effective Date Comment
1077: -- 8 01/28/99 vravikan 10/01/1998 New Edit
1078: -- If prior pay plan is EV, then prior grade must be 01 through 03 or asterisks
1079: --
1080: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then
1081: if p_prior_pay_plan = 'EV' and
1082: p_prior_grade not in ('01', '02', '03') and
1083: p_prior_grade is not null then
1084: hr_utility.set_message(8301, 'GHR_37034_ALL_PROCEDURE_FAIL');
1161: -- 540.56.2
1162: -- Update/Change Date By Effective Date Comment
1163: -- 9/5 08/13/99 vravikan 01-Apr-99 New Edit
1164: /* If prior pay plan is NC, then prior grade must be 01 through 03 */
1165: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1166: if p_prior_pay_plan = 'NC' and
1167: not( p_prior_grade in ('01','02','03') or
1168: p_prior_grade is null )
1169: then
1176: -- 9/5 08/13/99 vravikan 01-Apr-99 New Edit
1177: --upd47 26-Jun-06 Raju 01-Apr-2006 Change prior grade 04 to 05
1178: --7642919 16-Dec-08 Raju 01-Apr-2006 Included grade 04
1179: /* If prior pay plan is NO, then prior grade must be 01 through 04 */
1180: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1181: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1182: if p_prior_pay_plan = 'NO' and
1183: not( p_prior_grade in ('01','02','03','04') or
1184: p_prior_grade is null ) then
1177: --upd47 26-Jun-06 Raju 01-Apr-2006 Change prior grade 04 to 05
1178: --7642919 16-Dec-08 Raju 01-Apr-2006 Included grade 04
1179: /* If prior pay plan is NO, then prior grade must be 01 through 04 */
1180: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1181: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1182: if p_prior_pay_plan = 'NO' and
1183: not( p_prior_grade in ('01','02','03','04') or
1184: p_prior_grade is null ) then
1185: hr_utility.set_message(8301, 'GHR_37072_ALL_PROCEDURE_FAIL');
1200: -- 540.58.2
1201: -- Update/Change Date By Effective Date Comment
1202: -- 9/5 08/13/99 vravikan 01-Apr-99 New Edit
1203: /* If prior pay plan is NP or NR, then prior grade must be 01 through 05 */
1204: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1205: if p_prior_pay_plan in ( 'NP','NR') and
1206: not( p_prior_grade in ('01','02','03','04','05') or
1207: p_prior_grade is null )
1208: then
1236:
1237: /* If Prior Pay plan is VE,
1238: Then prior grade must be 01, 02, or asterisks */
1239: if p_effective_date >= to_date('2000/05/01', 'yyyy/mm/dd') and
1240: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1241: if p_prior_pay_plan = 'VE' and
1242: not( p_prior_grade in ('01','02') or
1243: p_prior_grade is null )
1244: then
1309: --upd47 26-Jun-06 Raju From 01-Apr-2006 Added 611,613
1310: -- upd51 06-Feb-07 Raju From 01-Jan-2007 Bug#5745356 add 890
1311: --BuG# 6010943 Raju Modified the p_prior_effective_date to p_effective_date
1312: --
1313: if p_effective_date < fnd_date.canonical_to_date('1998/10/01') then
1314: if p_prior_pay_plan <> p_to_pay_plan and
1315: p_prior_pay_plan is not null and
1316: p_to_pay_plan is not null and
1317: not(p_first_noac_lookup_code in ('702','703','713','721','740','741','850','855','894') or
1318: substr(p_first_noac_lookup_code,1,1)= '5') then
1319: hr_utility.set_message(8301, 'GHR_37547_ALL_PROCEDURE_FAIL');
1320: hr_utility.raise_error;
1321: end if;
1322: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1323: if p_prior_pay_plan <> p_to_pay_plan and
1324: p_prior_pay_plan is not null and
1325: p_to_pay_plan is not null and
1326: not(p_first_noac_lookup_code in ('600','601','602','603','604','605','606','607','608','609','610',
1329: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1330: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 850, 855 or 894');
1331: hr_utility.raise_error;
1332: end if;
1333: elsif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then
1334: if p_prior_pay_plan <> p_to_pay_plan and
1335: p_prior_pay_plan is not null and
1336: p_to_pay_plan is not null and
1337: not(p_first_noac_lookup_code in ('600','601','602','603','604','605','606','607','608','609','610',
1401: -- 560.04.2
1402: -- 06/25/03 vravikan By passing this edit if the
1403: -- employee on RG Temporary promotion
1404: --upd47 26-Jun-06 Raju From 01-Apr-2006 Added pay plan is other than Yx condition
1405: if P_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1406: IF GHR_GHRWS52L.g_temp_step IS NULL THEN
1407: if p_First_NOAC_Lookup_Code = '703' and
1408: p_prior_pay_rate_det_code in ('A','B','E','F','U','V') and
1409: p_pay_rate_determinant not in ('A','B','E','F','U','V') and
1538: -- Modified by Date Comments
1539: -------------------------------------------------------------------------------
1540: -- Madhuri 01-MAR-05 Retroactively end dating as of 31-JAN-2002
1541: -------------------------------------------------------------------------------
1542: IF p_prior_effective_date <= fnd_date.canonical_to_date('20'||'02/01/31') THEN
1543:
1544: ghr_history_api.get_g_session_var(l_session);
1545: If l_session.noa_id_correct is null then
1546:
1713: -------------------------------------------------------------------------------
1714: -- 560.40.2
1715: -- Update/Change Date By Effective Date Comment
1716: -- 9/4 08/10/99 vravikan 01-Mar-99 Exclude PRD T.
1717: If p_prior_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
1718: if p_prior_pay_plan in ('GM','GS') and
1719: p_prior_pay_rate_det_code in ('P','T') then
1720: hr_utility.set_message(8301, 'GHR_37063_ALL_PROCEDURE_FAIL');
1721: hr_utility.raise_error;
1904: -- Madhuri 21-JAN-2004 End Dating this edit as on 10-JAN-04
1905: -- For SES Pay Calculations
1906: --p_effective_date
1907: --upd47 26-Jun-06 Raju From 01-Jan-2004 Terminate the edit
1908: if p_effective_date < fnd_date.canonical_to_date('2004/01/01') then
1909: if (p_effective_date < to_date('2004/01/11', 'yyyy/mm/dd') and
1910: (p_prior_pay_plan = 'ES' or p_prior_pay_plan = 'FE') and
1911: (to_number(p_prior_step_or_rate) not between 1 and 6) and
1912: p_prior_step_or_rate is not null ) then
1915: end if;
1916: end if;
1917: -- 580.19.2
1918: --upd47 26-Jun-06 Raju From 01-Apr-2003 Terminate the edit
1919: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then
1920: if (p_prior_pay_rate_det_code in ('2','3','4') or
1921: p_prior_pay_rate_det_code in ('A','B','C','D','E','F','G','H','I','J',
1922: 'K','L','N','O','P','Q','R','S','T','U',
1923: 'V','W','X','Y','Z')) and
1949: -- 18-Sep-00 vravikan From the Start Add VE
1950: -- 19-MAY-04 Madhuri From Start Removed pay plan VP from list
1951: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
1952: --
1953: IF p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1954: if (p_prior_pay_plan in ('VE','VM'/*,'VP'*/)) and
1955: p_prior_grade <> '97' and
1956: (to_number(p_prior_step_or_rate) not between 0 and 10) and
1957: p_prior_step_or_rate is not null