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_CPDF_CHECK3 dependencies on FND_DATE

Line 160: --IF p_effective_date < fnd_date.canonical_to_date('2005/10/01') then

156: hr_utility.raise_error;
157: end if;
158: -- Begin Bug# 4567571
159:
160: --IF p_effective_date < fnd_date.canonical_to_date('2005/10/01') then
161: IF p_effective_date < fnd_date.canonical_to_date('2006/01/01') then
162: IF p_First_NOAC_Lookup_Code NOT IN ('001','817') and
163: p_Race_National_Region IS NULL THEN
164: hr_utility.set_message(8301, 'GHR_37280_ALL_PROCEDURE_FAIL');

Line 161: IF p_effective_date < fnd_date.canonical_to_date('2006/01/01') then

157: end if;
158: -- Begin Bug# 4567571
159:
160: --IF p_effective_date < fnd_date.canonical_to_date('2005/10/01') then
161: IF p_effective_date < fnd_date.canonical_to_date('2006/01/01') then
162: IF p_First_NOAC_Lookup_Code NOT IN ('001','817') and
163: p_Race_National_Region IS NULL THEN
164: hr_utility.set_message(8301, 'GHR_37280_ALL_PROCEDURE_FAIL');
165: hr_utility.raise_error;

Line 167: --elsif p_effective_date >= fnd_date.canonical_to_date('2005/10/01') then

163: p_Race_National_Region IS NULL THEN
164: hr_utility.set_message(8301, 'GHR_37280_ALL_PROCEDURE_FAIL');
165: hr_utility.raise_error;
166: END IF;
167: --elsif p_effective_date >= fnd_date.canonical_to_date('2005/10/01') then
168: ELSIF p_effective_date >= fnd_date.canonical_to_date('2006/01/01') THEN
169: if p_First_NOAC_Lookup_Code not in ('001','817')
170: and p_effective_date < to_date('2006/07/01','yyyy/mm/dd')then
171: IF (p_Race_National_Region is null and p_ethnic_race_info is null) then

Line 168: ELSIF p_effective_date >= fnd_date.canonical_to_date('2006/01/01') THEN

164: hr_utility.set_message(8301, 'GHR_37280_ALL_PROCEDURE_FAIL');
165: hr_utility.raise_error;
166: END IF;
167: --elsif p_effective_date >= fnd_date.canonical_to_date('2005/10/01') then
168: ELSIF p_effective_date >= fnd_date.canonical_to_date('2006/01/01') THEN
169: if p_First_NOAC_Lookup_Code not in ('001','817')
170: and p_effective_date < to_date('2006/07/01','yyyy/mm/dd')then
171: IF (p_Race_National_Region is null and p_ethnic_race_info is null) then
172: hr_utility.set_message(8301, 'GHR_38990_ALL_PROCEDURE_FAIL');

Line 219: IF p_effective_date < fnd_date.canonical_to_date('2011/02/01') then

215: hr_utility.set_message(8301, 'GHR_37287_ALL_PROCEDURE_FAIL');
216: hr_utility.raise_error;
217: end if;
218: --Begin Bug 11726461
219: IF p_effective_date < fnd_date.canonical_to_date('2011/02/01') then
220: --Begin Bug 10189715
221: if p_first_noac_lookup_code not in ('001','817') and
222: p_rating_of_record_pattern <> 'Z' and
223: p_rating_of_record_level is null then

Line 242: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then

238: l_noa_family_code := c_noa_family_code_rec.noa_family_code;
239: hr_utility.set_location('actual noa_family_code is ' || l_noa_family_code,2);
240: exit;
241: END LOOP;
242: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then
243: if substr(p_First_NOAC_Lookup_Code,1,1) in ('1','2','5','6','7','8')
244: and
245: l_noa_family_code not in ('AWARD','GHR_STUDENT_LOAN','GHR_INCENTIVE')
246: and

Line 296: if p_effective_date < fnd_date.canonical_to_date('2006/05/01') then

292: --upd49 08-Jan-07 Raju From 01-Jun-2004 Bug#5619873 Add 826,827
293: -- upd51 06-Feb-07 Raju From 01-Jan-2007 Bug#5745356 add noa 849,885,886,887,889
294: ghr_history_api.get_g_session_var(l_session);
295: if p_effective_date >= to_date('01/10/1998', 'dd/mm/yyyy') then
296: if p_effective_date < fnd_date.canonical_to_date('2006/05/01') then
297: if l_session.noa_id_correct is null then
298: if p_effective_date < fnd_date.canonical_to_date('2004/06/01') then
299: if substr(p_First_NOAC_Lookup_Code,1,1) in ('3','4','5','6','7','8') and
300: p_First_NOAC_Lookup_Code not in ('815','816','817','825','840','841','842',

Line 298: if p_effective_date < fnd_date.canonical_to_date('2004/06/01') then

294: ghr_history_api.get_g_session_var(l_session);
295: if p_effective_date >= to_date('01/10/1998', 'dd/mm/yyyy') then
296: if p_effective_date < fnd_date.canonical_to_date('2006/05/01') then
297: if l_session.noa_id_correct is null then
298: if p_effective_date < fnd_date.canonical_to_date('2004/06/01') then
299: if substr(p_First_NOAC_Lookup_Code,1,1) in ('3','4','5','6','7','8') and
300: p_First_NOAC_Lookup_Code not in ('815','816','817','825','840','841','842',
301: '843','844','845','846','847','848','849','878','879')
302: and

Line 337: elsif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then --p_effective_date < '2006/05/01'

333: hr_utility.raise_error;
334: end if;
335: end if; -- p_effective_date < '2004/06/01'
336: end if; --l_session.noa_id_correct is null
337: elsif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then --p_effective_date < '2006/05/01'
338: if l_session.noa_id_correct is null then
339: if substr(p_First_NOAC_Lookup_Code,1,1) in ('3','4','5','6','7','8') and
340: p_First_NOAC_Lookup_Code not in ('815','816','817','825','826','827','840','841','842',
341: '843','844','845','846','847','848','878','879')

Line 406: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

402:
403: -- 370.20.2
404: -- 17-Aug-00 vravikan From the Start Delete Staffing Differential
405: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
406: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
407: if p_First_NOAC_Lookup_Code ='810' and
408: p_First_Action_NOA_Code1 is null and
409: p_First_Action_NOA_Code2 is null and
410: (p_Retention_Allowance is null and

Line 461: IF p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then

457: -- 12/08/00 vravikan 01-oct-2000 New Edit
458: -- If nature of action is 600 through 610,
459: -- Then agency/subelement must be TD03
460:
461: IF p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
462: IF p_First_NOAC_Lookup_Code between '600' and '610' and
463: p_agency_subelement <> 'TD03' then
464: hr_utility.set_message(8301, 'GHR_37664_ALL_PROCEDURE_FAIL');
465: hr_utility.raise_error;

Line 473: IF p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then

469: -- 12/08/00 vravikan 01-oct-2000 New Edit
470: -- If nature of action is 871,
471: -- Then Agency must be AF,AR,DD, or NV.
472:
473: IF p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
474: IF p_First_NOAC_Lookup_Code = '871' and
475: substr(p_agency_subelement,1,2) not in ('AF','AR','DD','NV') then
476: hr_utility.set_message(8301, 'GHR_37665_ALL_PROCEDURE_FAIL');
477: hr_utility.raise_error;

Line 483: IF p_effective_date >= fnd_date.canonical_to_date('2006/04/01') THEN

479: END IF;
480:
481: -- 370.37.2
482: -- Upd 47 23-Jun-06 Raju From 01-Apr-06 New Edit
483: IF p_effective_date >= fnd_date.canonical_to_date('2006/04/01') THEN
484: IF p_First_NOAC_Lookup_Code IN ('611','612','613') AND
485: substr(p_agency_subelement,1,2) not in ('AF','AR','DD','NV') THEN
486: hr_utility.set_message(8301, 'GHR_37164_ALL_PROCEDURE_FAIL');
487: hr_utility.raise_error;

Line 522: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN

518:
519: -- 390.10.1
520: -- 12/12/01 Change 2200 to 2500
521: -- U58 Raju 01-jan-2010 Bug 9503972
522: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
523: if ( substr(p_to_pay_plan,1,1) = 'G' or p_to_pay_plan = 'LG' or
524: p_to_pay_plan = 'ST' ) and
525: to_number(p_occ_code) >= 2500 and
526: p_occ_code is not null then

Line 545: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN

541: END IF;
542:
543: -- 390.16.1
544: -- U58 Raju 01-jan-2010 Bug 9503972
545: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
546: if substr(p_to_pay_plan,1,1) in ('W','X', 'K') and
547: (to_number(p_occ_code) < 2499) then
548: hr_utility.set_message(8301, 'GHR_37209_ALL_PROCEDURE_FAIL');
549: hr_utility.set_message_token('PAY_PLAN','W-, X-, or K-');

Line 601: if p_effective_date < fnd_date.canonical_to_date('2004/07/01') then

597: -- 390.45.1
598: --
599: -- 12/8/00 vravikan 01-Oct-2000 New Edit
600: -- Upd 43 09-NOV-05 Raju 01-Jul-2004 Terminate the Edit Effective 01-Jul-2004
601: if p_effective_date < fnd_date.canonical_to_date('2004/07/01') then
602: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
603: if p_occ_code in ('4431')
604: and (
605: substr(p_agency_sub,1,2) not in ('LP')

Line 602: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then

598: --
599: -- 12/8/00 vravikan 01-Oct-2000 New Edit
600: -- Upd 43 09-NOV-05 Raju 01-Jul-2004 Terminate the Edit Effective 01-Jul-2004
601: if p_effective_date < fnd_date.canonical_to_date('2004/07/01') then
602: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
603: if p_occ_code in ('4431')
604: and (
605: substr(p_agency_sub,1,2) not in ('LP')
606: )

Line 618: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

614: -- 390.47.1
615: --
616: -- 12/8/00 vravikan 01-Oct-2000 New Edit
617: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
618: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
619: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
620: if p_occ_code in ('0898','1398','1598')
621: and (
622: p_agency_sub not in ('CM57')

Line 619: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then

615: --
616: -- 12/8/00 vravikan 01-Oct-2000 New Edit
617: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
618: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
619: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
620: if p_occ_code in ('0898','1398','1598')
621: and (
622: p_agency_sub not in ('CM57')
623: )

Line 633: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN

629: end if;
630: -- 390.07.2
631: -- 12/12/01 Change 2200 to 2500
632: -- U58 Raju 01-jan-2010 Bug 9503972
633: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
634: if ( p_to_pay_plan = 'ST' or p_to_pay_plan ='LG' or
635: substr(p_to_pay_plan,1,1) = 'G') and
636: to_number(p_occ_code) >= 2500 and
637: p_occ_code is not null then

Line 655: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN

651: END IF;
652:
653: -- 390.13.2
654: -- U58 Raju 01-jan-2010 Bug 9503972
655: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
656: if substr(p_to_pay_plan,1,1) in ('W', 'X', 'K') and
657: to_number(p_occ_code) <= 2499 and
658: p_occ_code is not null then
659: hr_utility.set_message(8301, 'GHR_37213_ALL_PROCEDURE_FAIL');

Line 1084: if p_effective_date < fnd_date.canonical_to_date('2008/04/17') then

1080: -- Update Date By Effective Date Comment
1081: -- 9 04/29/99 vravikan Add Pay Plans CG,MG
1082: -- UPD 56 8309414 Raju 17-Apr-2008 Remove pay plan MG
1083: -- U58 Raju 01-jan-2010 Bug 9503972
1084: if p_effective_date < fnd_date.canonical_to_date('2008/04/17') then
1085: if p_to_pay_plan in ( 'CG','MG','WL','XG' )
1086: and p_to_grade_or_level not in
1087: ('01', '02', '03', '04', '05', '06', '07', '08',
1088: '09', '10', '11', '12', '13', '14', '15')

Line 1094: ELSIF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN

1090: hr_utility.set_message(8301, 'GHR_37221_ALL_PROCEDURE_FAIL');
1091: hr_utility.set_message_token('PAY_PLAN','CG,MG,WL, or XG');
1092: hr_utility.raise_error;
1093: end if;
1094: ELSIF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
1095: if p_to_pay_plan in ( 'CG','WL','XG' )
1096: and p_to_grade_or_level not in
1097: ('01', '02', '03', '04', '05', '06', '07', '08',
1098: '09', '10', '11', '12', '13', '14', '15')

Line 1118: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN

1114: end if;
1115:
1116: -- 420.04.3
1117: -- U58 Raju 01-jan-2010 Bug 9503972
1118: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
1119: if (p_to_pay_plan = 'WS' or p_to_pay_plan ='XH') and
1120: p_to_grade_or_level not in
1121: ('01', '02', '03', '04', '05', '06', '07', '08', '09', '10',
1122: '11', '12', '13', '14', '15', '16', '17', '18', '19') and

Line 1142: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1138: END IF;
1139:
1140: -- 420.07.3
1141: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1142: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1143: if (p_to_pay_plan = 'FA' and p_pay_rate_determinant_code <> 'S')
1144: and
1145: p_to_grade_or_level not in ('CA', 'CM', 'MC', 'NC', 'OC',
1146: '01', '02', '03', '04', '13', '14')

Line 1157: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1153: end if;
1154: -- 420.10.3
1155: -- removed pay plan 'CY'
1156: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1157: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1158: if p_to_pay_plan ='CE' and
1159: p_to_grade_or_level not in ('01', '02', '03', '04', '05', '06', '07', '08', '09', '10',
1160: '11', '12', '13', '14', '15', '16', '17')
1161: and

Line 1171: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1167: end if;
1168: -- 420.11.3
1169: -- added for the april release as per update 6 manual
1170: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1171: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1172: if p_to_pay_plan ='CY' and
1173: p_to_grade_or_level not in ('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12',
1174: '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24')
1175: and

Line 1209: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then

1205: --
1206: -- If pay plan is NH or NJ, then grade must be 01 through 04 or asterisks
1207: --
1208: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
1209: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
1210: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1211: if p_to_pay_plan in ('NH', 'NJ') and
1212: p_to_grade_or_level not in ('01', '02', '03', '04') and
1213: p_to_grade_or_level is not null then

Line 1210: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then

1206: -- If pay plan is NH or NJ, then grade must be 01 through 04 or asterisks
1207: --
1208: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
1209: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
1210: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1211: if p_to_pay_plan in ('NH', 'NJ') and
1212: p_to_grade_or_level not in ('01', '02', '03', '04') and
1213: p_to_grade_or_level is not null then
1214: hr_utility.set_message(8301, 'GHR_37877_ALL_PROCEDURE_FAIL');

Line 1225: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then

1221: --
1222: -- If pay plan is NK, then grade must be 01 through 03 or asterisks
1223: --
1224: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
1225: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
1226: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1227: if p_to_pay_plan = 'NK' and
1228: p_to_grade_or_level not in ('01', '02', '03') and
1229: p_to_grade_or_level is not null then

Line 1226: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then

1222: -- If pay plan is NK, then grade must be 01 through 03 or asterisks
1223: --
1224: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
1225: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
1226: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1227: if p_to_pay_plan = 'NK' and
1228: p_to_grade_or_level not in ('01', '02', '03') and
1229: p_to_grade_or_level is not null then
1230: hr_utility.set_message(8301, 'GHR_37878_ALL_PROCEDURE_FAIL');

Line 1243: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1239: -- If pay plan is FV, then grade must be 'AA' through 'MM' or asterisks
1240: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
1241: --
1242: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1243: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1244: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') and
1245: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1246: if p_to_pay_plan = 'FV' and
1247: p_to_grade_or_level not in ('AA','BB','CC','DD','EE','FF','GG','HH','II',

Line 1244: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') and

1240: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
1241: --
1242: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1243: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1244: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') and
1245: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1246: if p_to_pay_plan = 'FV' and
1247: p_to_grade_or_level not in ('AA','BB','CC','DD','EE','FF','GG','HH','II',
1248: 'JJ','KK','LL','MM') and

Line 1245: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313

1241: --
1242: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1243: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1244: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') and
1245: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1246: if p_to_pay_plan = 'FV' and
1247: p_to_grade_or_level not in ('AA','BB','CC','DD','EE','FF','GG','HH','II',
1248: 'JJ','KK','LL','MM') and
1249: p_to_grade_or_level is not null then

Line 1263: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then

1259: -- If pay plan is JA, then grade must be 01 through 04 or asterisks
1260: --
1261: -- UPD 41(Bug 4567571) Raju 08-Nov-2005 Terminate from 01-Jul-2004
1262: if p_effective_date < to_date('2004/07/01','yyyy/mm/dd') then
1263: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then
1264: if p_to_pay_plan = 'JA' and
1265: p_to_grade_or_level not in ('01', '02', '03','04') and
1266: p_to_grade_or_level is not null then
1267: hr_utility.set_message(8301, 'GHR_37056_ALL_PROCEDURE_FAIL');

Line 1280: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then

1276: -- 8 01/28/99 vravikan 01/10/98 New Edit
1277: -- If pay plan is EV, then grade must be 01 through 03 or asterisks
1278: --
1279: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
1280: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
1281: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then
1282: if p_to_pay_plan = 'EV' and
1283: p_to_grade_or_level not in ('01', '02', '03') and
1284: p_to_grade_or_level is not null then

Line 1281: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then

1277: -- If pay plan is EV, then grade must be 01 through 03 or asterisks
1278: --
1279: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
1280: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
1281: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then
1282: if p_to_pay_plan = 'EV' and
1283: p_to_grade_or_level not in ('01', '02', '03') and
1284: p_to_grade_or_level is not null then
1285: hr_utility.set_message(8301, 'GHR_37032_ALL_PROCEDURE_FAIL');

Line 1294: IF p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313

1290:
1291: -- 420.22.3
1292: -- Update Date By Effective Date Comment
1293: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
1294: IF p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1295: if p_to_pay_plan = 'VM' and
1296: p_to_grade_or_level not in ('11', '12', '13', '14', '15', '96', '97') and
1297: p_to_grade_or_level is not null then
1298: hr_utility.set_message(8301, 'GHR_37227_ALL_PROCEDURE_FAIL');

Line 1308: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1304: -- 9/2 08/09/99 vravikan 01-Mar-1999 New Edit
1305: -- If pay plan is EZ, then grade must be 01 through 08.
1306: --
1307: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1308: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1309: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
1310: if p_to_pay_plan = 'EZ' and
1311: p_to_grade_or_level not in ('01','02','03','04','05','06','07','08')
1312: and

Line 1309: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then

1305: -- If pay plan is EZ, then grade must be 01 through 08.
1306: --
1307: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1308: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1309: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
1310: if p_to_pay_plan = 'EZ' and
1311: p_to_grade_or_level not in ('01','02','03','04','05','06','07','08')
1312: and
1313: p_to_grade_or_level is not null

Line 1323: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1319: end if;
1320:
1321: -- 420.25.3
1322: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1323: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1324: if p_to_pay_plan = 'VN' and
1325: p_to_grade_or_level not in ('01', '02', '03', '04', '05', '06', '08',
1326: '09', '11', '12', '13', '14', '15')
1327: and

Line 1346: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN

1342: end if;
1343:
1344: -- 420.31.3
1345: -- U58 Raju 01-jan-2010 Bug 9503972
1346: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
1347: if (p_to_pay_plan = 'WG' or p_to_pay_plan = 'XF') and
1348: p_to_grade_or_level not in
1349: ('01', '02', '03', '04', '05', '06', '07', '08',
1350: '09', '10', '11', '12', '13', '14', '15') and

Line 1396: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1392: */
1393:
1394: -- 420.40.3
1395: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1396: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1397: if p_to_pay_plan = 'DR' and
1398: p_to_grade_or_level not in ('01', '02', '03', '04') and
1399: p_to_grade_or_level is not null
1400: then

Line 1408: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1404: end if;
1405:
1406: -- 420.41.3
1407: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1408: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1409: if (p_to_pay_plan = 'ND' or p_to_pay_plan = 'NT' )
1410: and
1411: p_to_grade_or_level not in ('01', '02', '03', '04',
1412: '05', '06')

Line 1422: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1418: end if;
1419: end if;
1420: -- 420.42.3
1421: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1422: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1423: if p_to_pay_plan = 'NG'
1424: and
1425: p_to_grade_or_level not in ('01', '02', '03', '04',
1426: '05')

Line 1448: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN

1444: end if;
1445:
1446: -- 420.45.3
1447: -- U58 Raju 01-jan-2010 Bug 9503972
1448: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
1449: if p_to_pay_plan = 'FP' and
1450: p_to_grade_or_level not in ('01', '02', '03', '04', '05',
1451: '06', '07', '08', '09', 'AA',
1452: 'BB', 'CC', 'DD', 'EE') and

Line 1482: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then

1478: end if;
1479:
1480: -- 420.50.3
1481: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
1482: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
1483: if p_to_pay_plan = 'AF' and
1484: p_to_grade_or_level not in ('AA', 'BB', 'CC', 'DD', 'EE') and
1485: p_to_grade_or_level is not null then
1486: hr_utility.set_message(8301, 'GHR_37236_ALL_PROCEDURE_FAIL');

Line 1493: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then

1489: end if;
1490:
1491: -- 420.51.3
1492: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
1493: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
1494: if p_to_pay_plan = 'FM' and
1495: p_to_grade_or_level not in ('13', '14','15')
1496: and
1497: p_to_grade_or_level is not null

Line 1506: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then

1502: end if;
1503:
1504: -- 420.52.3
1505: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
1506: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
1507: if p_to_pay_plan = 'FG' and
1508: p_to_grade_or_level not in ('01', '02', '03', '04', '05', '06',
1509: '07', '08', '09', '10','11', '12', '13', '14', '15')
1510: and

Line 1520: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then

1516: end if;
1517:
1518: -- 420.53.3
1519: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
1520: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
1521: if p_to_pay_plan = 'FC' and
1522: p_to_grade_or_level not in ('02', '03', '04', '05', '06', '07', '08',
1523: '09', '10', '11', '12', '13', '14')
1524: and

Line 1562: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1558: end if;
1559:
1560: -- 420.60.3
1561: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1562: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1563: if (p_to_pay_plan = 'SL' or p_to_pay_plan = 'XE') and
1564: p_to_grade_or_level <>'00'
1565: and
1566: p_to_grade_or_level is not null

Line 1595: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1591: end if;
1592:
1593: -- 420.73.3
1594: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1595: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1596: if p_to_pay_plan = 'NY' and
1597: p_to_grade_or_level not in ('01', '02', '03', '04')
1598: and
1599: p_to_grade_or_level is not null

Line 1612: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1608: -- 9/5 08/12/99 vravikan 01-Apr-1999 New Edit
1609: /*If pay plan is NC,
1610: Then grade must be 01 through 03.*/
1611: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1612: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1613: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1614: if p_to_pay_plan = 'NC' and
1615: p_to_grade_or_level not in ('01', '02', '03')
1616: and

Line 1613: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then

1609: /*If pay plan is NC,
1610: Then grade must be 01 through 03.*/
1611: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1612: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1613: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1614: if p_to_pay_plan = 'NC' and
1615: p_to_grade_or_level not in ('01', '02', '03')
1616: and
1617: p_to_grade_or_level is not null

Line 1632: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1628: -- 18/6 10/16/02 vnarasim 01-Apr-1999 Added grade 05
1629: /*If pay plan is NO,
1630: Then grade must be 01 through 04 or asterisks.*/
1631: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1632: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1633: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1634: if p_to_pay_plan = 'NO' and
1635: p_to_grade_or_level not in ('01', '02', '03','04','05')
1636: and

Line 1633: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then

1629: /*If pay plan is NO,
1630: Then grade must be 01 through 04 or asterisks.*/
1631: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1632: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1633: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1634: if p_to_pay_plan = 'NO' and
1635: p_to_grade_or_level not in ('01', '02', '03','04','05')
1636: and
1637: p_to_grade_or_level is not null

Line 1650: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1646: -- Update/Change Date By Effective Date Comment
1647: -- 9/5 08/12/99 vravikan 01-Apr-1999 New Edit
1648: /*If pay plan is NP or NR, Then grade must be 01 through 05 or asterisks*/
1649: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1650: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1651: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1652: if p_to_pay_plan in ('NP','NR') and
1653: p_to_grade_or_level not in ('01', '02', '03','04','05')
1654: and

Line 1651: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then

1647: -- 9/5 08/12/99 vravikan 01-Apr-1999 New Edit
1648: /*If pay plan is NP or NR, Then grade must be 01 through 05 or asterisks*/
1649: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1650: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1651: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1652: if p_to_pay_plan in ('NP','NR') and
1653: p_to_grade_or_level not in ('01', '02', '03','04','05')
1654: and
1655: p_to_grade_or_level is not null

Line 1669: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313

1665: -- 18-Aug-2000 vravikan 01-May-2000 New Edit
1666: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
1667: /*If pay plan is VE , Then grade must be 01 ,02 or asterisks*/
1668: If p_effective_date >= to_date('2000/05/01', 'yyyy/mm/dd') and
1669: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1670: if p_to_pay_plan in ('VE') and
1671: p_to_grade_or_level not in ('01', '02')
1672: and
1673: p_to_grade_or_level is not null

Line 1685: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1681: -- Update/Change Date By Effective Date Comment
1682: -- 18-Aug-00 vravikan 01-Jun-2000 New Edit
1683: /*If pay plan is NB, Then grade must be 01 through 09 or asterisks*/
1684: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1685: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1686: If p_effective_date >= to_date('1999/06/01', 'yyyy/mm/dd') then
1687: if p_to_pay_plan in ('NB') and
1688: p_to_grade_or_level not in ('01', '02','03','04','05','06','07','08','09')
1689: and

Line 1960: elsif p_effective_date < fnd_date.canonical_to_date('2006/05/01') and

1956: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
1957: hr_utility.set_message_token('PAY_PLAN','EK');
1958: hr_utility.set_message_token('AGENCY_CODE','DN');
1959: hr_utility.raise_error;
1960: elsif p_effective_date < fnd_date.canonical_to_date('2006/05/01') and
1961: ( p_to_pay_plan = 'FA' and
1962: substr(p_agency_subelement,1,2) not in ('AM','ST') ) then
1963: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
1964: hr_utility.set_message_token('PAY_PLAN','FA');

Line 1967: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and

1963: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
1964: hr_utility.set_message_token('PAY_PLAN','FA');
1965: hr_utility.set_message_token('AGENCY_CODE','AM,ST');
1966: hr_utility.raise_error;
1967: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and
1968: ( p_to_pay_plan = 'FA' and
1969: substr(p_agency_subelement,1,2) not in ('AM') ) then
1970: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
1971: hr_utility.set_message_token('PAY_PLAN','FA');

Line 2129: elsif p_effective_date < fnd_date.canonical_to_date('2008/04/17') and

2125: hr_utility.set_message_token('PAY_PLAN','in CG,EO or EM');
2126: hr_utility.set_message_token('AGENCY_CODE','FD');
2127: hr_utility.raise_error;
2128: --Begin Bug# 8309414 remove pay plan MG eff 17-apr-08
2129: elsif p_effective_date < fnd_date.canonical_to_date('2008/04/17') and
2130: ( p_to_pay_plan in ('MG','MS','MX') and substr(p_agency_subelement,1,2) <> 'HU' ) then
2131: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2132: hr_utility.set_message_token('PAY_PLAN','in MG,MS or MX');
2133: hr_utility.set_message_token('AGENCY_CODE','HU');

Line 2155: p_effective_date >= fnd_date.canonical_to_date('1998/03/01') ) then

2151: hr_utility.set_message_token('AGENCY_CODE','NV');
2152: hr_utility.raise_error;
2153: elsif ( p_to_pay_plan in ('NH','NJ','NK') and
2154: substr(p_agency_subelement,1,2) not in ('AF','AR','DD','NV') and
2155: p_effective_date >= fnd_date.canonical_to_date('1998/03/01') ) then
2156: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2157: hr_utility.set_message_token('PAY_PLAN','in NH,NJ or NK');
2158: hr_utility.set_message_token('AGENCY_CODE','in AF,AR,DD or NV');
2159: hr_utility.raise_error;

Line 2161: p_effective_date >= fnd_date.canonical_to_date('1998/10/01') and

2157: hr_utility.set_message_token('PAY_PLAN','in NH,NJ or NK');
2158: hr_utility.set_message_token('AGENCY_CODE','in AF,AR,DD or NV');
2159: hr_utility.raise_error;
2160: elsif ( p_to_pay_plan in ('AT','EV','FV') and
2161: p_effective_date >= fnd_date.canonical_to_date('1998/10/01') and
2162: p_agency_subelement <> 'TD03' ) then
2163: hr_utility.set_location('In pay plan AT', 12);
2164: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2165: hr_utility.set_message_token('PAY_PLAN','in AT,EV or FV');

Line 2177: p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') ) then

2173: hr_utility.set_message_token('PAY_PLAN','in JA,JB,JC,JD or JE');
2174: hr_utility.set_message_token('AGENCY_CODE','DJ02');
2175: hr_utility.raise_error;*/
2176: elsif ( p_to_pay_plan in ( 'EZ') and substr(p_agency_subelement,1,2) <> 'SE' and
2177: p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') ) then
2178: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2179: hr_utility.set_message_token('PAY_PLAN','EZ');
2180: hr_utility.set_message_token('AGENCY_CODE','SE');
2181: hr_utility.raise_error;

Line 2183: p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') )

2179: hr_utility.set_message_token('PAY_PLAN','EZ');
2180: hr_utility.set_message_token('AGENCY_CODE','SE');
2181: hr_utility.raise_error;
2182: elsif ( p_to_pay_plan in ('NC','NO','NP','NR') and substr(p_agency_subelement,1,2) <> 'NV' and
2183: p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') )
2184: then
2185: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2186: hr_utility.set_message_token('PAY_PLAN','in NC,NO,NP or NR');
2187: hr_utility.set_message_token('AGENCY_CODE','NV');

Line 2229: elsif p_effective_date < fnd_date.canonical_to_date('2006/05/01') and

2225: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2226: hr_utility.set_message_token('PAY_PLAN','TG');
2227: hr_utility.set_message_token('AGENCY_CODE','TR35');
2228: hr_utility.raise_error;
2229: elsif p_effective_date < fnd_date.canonical_to_date('2006/05/01') and
2230: ( p_to_pay_plan in ('AF') and (p_agency_subelement not in ('AG10','CM55')
2231: and substr(p_agency_subelement,1,2) not in ('AM','IB','PU','ST')) )
2232: then
2233: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

Line 2238: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and

2234: hr_utility.set_message_token('PAY_PLAN','AF');
2235: hr_utility.set_message_token('AGENCY_CODE','AG10,AM,CM55,IB,PU or ST');
2236: hr_utility.raise_error;
2237:
2238: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and
2239: ( p_to_pay_plan in ('AF') and (p_agency_subelement not in ('AG10','CM55')
2240: and substr(p_agency_subelement,1,2) not in ('AM','IB','PU')) )
2241: then
2242: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

Line 2279: elsif p_effective_date < fnd_date.canonical_to_date('2006/05/01') and

2275: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2276: hr_utility.set_message_token('PAY_PLAN','EN');
2277: hr_utility.set_message_token('AGENCY_CODE','DN');
2278: hr_utility.raise_error;
2279: elsif p_effective_date < fnd_date.canonical_to_date('2006/05/01') and
2280: ( p_to_pay_plan in ('FE') and (p_agency_subelement not in ('AG10','CM55','AG34')
2281: and substr(p_agency_subelement,1,2) not in ('AM','HS','IB','PU','ST')) )
2282: then
2283: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

Line 2287: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and

2283: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2284: hr_utility.set_message_token('PAY_PLAN','FE');
2285: hr_utility.set_message_token('AGENCY_CODE','AG10,AM,CM55,AG34,HS,IB,PU or ST');
2286: hr_utility.raise_error;
2287: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and
2288: ( p_to_pay_plan in ('FE') and (p_agency_subelement not in ('AG10','CM55','AG34')
2289: and substr(p_agency_subelement,1,2) not in ('AM','HS','IB','PU')) )
2290: then
2291: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

Line 2295: elsif p_effective_date < fnd_date.canonical_to_date('2006/05/01') and

2291: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2292: hr_utility.set_message_token('PAY_PLAN','FE');
2293: hr_utility.set_message_token('AGENCY_CODE','AG10,AM,CM55,AG34,HS,IB or PU');
2294: hr_utility.raise_error;
2295: elsif p_effective_date < fnd_date.canonical_to_date('2006/05/01') and
2296: ( p_to_pay_plan in ('FO') and (p_agency_subelement not in ('AG10','CM55','AG34')
2297: and substr(p_agency_subelement,1,2) not in ('AM','IB','PU','ST','HS')) )
2298: then
2299: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

Line 2303: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and

2299: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2300: hr_utility.set_message_token('PAY_PLAN','FO');
2301: hr_utility.set_message_token('AGENCY_CODE','AG10,AM,CM55,AG34,IB,PU,HS or ST');
2302: hr_utility.raise_error;
2303: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and
2304: ( p_to_pay_plan in ('FO') and (p_agency_subelement not in ('AG10','CM55','AG34')
2305: and substr(p_agency_subelement,1,2) not in ('AM','IB','PU','HS')) )
2306: then
2307: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

Line 2311: elsif p_effective_date < fnd_date.canonical_to_date('2006/05/01') and

2307: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2308: hr_utility.set_message_token('PAY_PLAN','FO');
2309: hr_utility.set_message_token('AGENCY_CODE','AG10,AM,CM55,AG34,IB,PU or HS');
2310: hr_utility.raise_error;
2311: elsif p_effective_date < fnd_date.canonical_to_date('2006/05/01') and
2312: ( p_to_pay_plan in ('FP') and (p_agency_subelement not in ('AG10','CM55','AG34')
2313: and substr(p_agency_subelement,1,2) not in ('AM','HS','IB','PU','ST')) )
2314: then
2315: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

Line 2319: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and

2315: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2316: hr_utility.set_message_token('PAY_PLAN','FP');
2317: hr_utility.set_message_token('AGENCY_CODE','AG10,AM,CM55,AG34,HS,IB,PU or ST');
2318: hr_utility.raise_error;
2319: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and
2320: ( p_to_pay_plan in ('FP') and (p_agency_subelement not in ('AG10','CM55','AG34')
2321: and substr(p_agency_subelement,1,2) not in ('AM','HS','IB','PU')) )
2322: then
2323: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

Line 2460: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and

2456: hr_utility.set_message_token('AGENCY_CODE','HUFH');
2457: hr_utility.raise_error;
2458: --End Bug#6469079
2459: --Begin Bug# 5073313
2460: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and
2461: ( p_to_pay_plan in ('HE','HH','HL','HS','HT','HW') and substr(p_agency_subelement,1,2) <> 'HS' )
2462: then
2463: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2464: hr_utility.set_message_token('PAY_PLAN',p_to_pay_plan);

Line 2469: elsif p_effective_date >= fnd_date.canonical_to_date('2006/10/01') and

2465: hr_utility.set_message_token('AGENCY_CODE','HS');
2466: hr_utility.raise_error;
2467: --End bug# 5073313
2468: --Begin Bug# 5745356
2469: elsif p_effective_date >= fnd_date.canonical_to_date('2006/10/01') and
2470: ( p_to_pay_plan in ('HA','HB','HC','HD','HF','HG','HI','HJ','HK','HM','HN','HO',',HP','HQ','HR','HV','HX','HY','HZ') and substr(p_agency_subelement,1,2) <> 'HS' )
2471: then
2472: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2473: hr_utility.set_message_token('PAY_PLAN',p_to_pay_plan);

Line 2478: elsif p_effective_date >= fnd_date.canonical_to_date('2010/09/01') and

2474: hr_utility.set_message_token('AGENCY_CODE','HS');
2475: hr_utility.raise_error;
2476: --End bug# 5745356
2477: --Begin Bug# 10189715
2478: elsif p_effective_date >= fnd_date.canonical_to_date('2010/09/01') and
2479: ( p_to_pay_plan in ('HU') and substr(p_agency_subelement,1,2) <> 'HS' )
2480: then
2481: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2482: hr_utility.set_message_token('PAY_PLAN',p_to_pay_plan);

Line 2514: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

2510: -- 420.05.3
2511: -- 11/5 12/14/99 vravikan 01-Aug-1999 Delete the Pay Plan DG
2512: -- Renumbered from 440.05.3 for the april release
2513: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2514: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2515: if ( p_effective_date >= to_date('19'||'99/08/01','yyyy/mm/dd') ) then
2516: if (
2517: p_to_pay_plan in ('DA','DS','DT')
2518: and

Line 2579: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

2575: end if;
2576: end if;
2577: -- 440.10.2
2578: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2579: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2580: If (
2581: p_first_NOAC_Lookup_Code = '480' or p_first_NOAC_Lookup_Code='762'
2582: )
2583: and

Line 2599: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

2595: -- Update Date By Effective Date Comment
2596: -- 9 05/03/99 vravikan Added Pay Plan MS
2597: -- 10/30/03 Ashley Deleted Pay Plan EO
2598: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2599: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2600: hr_utility.set_location('to pay plan is ' || p_to_pay_plan ,10);
2601: hr_utility.set_location('from pay plan is ' || p_prior_pay_plan ,10);
2602: If p_first_NOAC_Lookup_Code = '879'
2603: and

Line 2624: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then

2620: -- 17-Aug-00 vravikan From the Start Add NB
2621: -- Dec 01 Patch 12/10/01 vravikan Delete OC
2622: -- 10/30/03 Ashley Added Pay Plans CM and EM
2623: --upd47 26-Jun-06 Raju From 01-Apr-2003 Terminate the edit
2624: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then
2625: if p_effective_date >= to_date('1999/11/01', 'yyyy/mm/dd') then
2626: If p_first_NOAC_Lookup_Code = '891' and
2627: p_to_pay_plan not in ('CG','CM','EM','EO','FM','GH','GM',
2628: 'NC','ND','NG','NH','NJ','NK','NO','NP','NR','NT',

Line 2680: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then

2676: end if;
2677:
2678: -- 440.25.2
2679: --upd47 26-Jun-06 Raju From 01-Apr-2003 Terminate the edit
2680: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then
2681: If p_first_NOAC_Lookup_Code ='893' and
2682: p_to_pay_plan ='GM' then
2683: hr_utility.set_message(8301, 'GHR_37253_ALL_PROCEDURE_FAIL');
2684: hr_utility.raise_error;

Line 2748: if l_effective_date >= fnd_date.canonical_to_date('2000/10/01') then

2744:
2745: -- 440.46.2
2746: -- 12/8/00 vravikan 01-Oct-2000 New Edit
2747: -- If nature of action is 871, Then pay plan must be GG
2748: if l_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
2749: if p_first_NOAC_Lookup_Code = '871' and
2750: p_to_pay_plan <> 'GG' then
2751: hr_utility.set_message(8301, 'GHR_37677_ALL_PROCEDURE_FAIL');
2752: hr_utility.raise_error;

Line 2808: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then

2804: end if;
2805:
2806: -- 450.04.3
2807: --upd47 26-Jun-06 Raju From 01-Apr-2003 Terminate the edit
2808: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then
2809: if (p_to_pay_plan = 'FA' or p_to_pay_plan = 'EX') and
2810: p_pay_rate_determinant_code not in ('C','S','0') and
2811: p_pay_rate_determinant_code is not null then
2812: hr_utility.set_message(8301, 'GHR_37260_ALL_PROCEDURE_FAIL');

Line 2821: IF p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then

2817: -- 450.05.3
2818: -- 12/8/00 vravikan 1-oct-00 New Edit
2819: -- If Pay Plan is GH or GM,
2820: -- Then pay rate determinant may not be A,B,E,F,U, or V
2821: IF p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
2822: IF (p_to_pay_plan = 'GH' or p_to_pay_plan = 'GM')
2823: and
2824: p_pay_rate_determinant_code in ('A','B','E','F','U','V')
2825: and

Line 2836: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

2832:
2833:
2834: -- 450.10.3
2835: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2836: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2837: if p_pay_rate_determinant_code = 'C' and
2838: (
2839: p_to_pay_plan in ('ED','EE','EF','EG','EH','EI','ZZ')
2840: or

Line 2856: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

2852: -- 11-DEC-08 AVR from start of edit Modified the edit to
2853: -- include the PRD-D
2854: --
2855: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2856: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2857: if p_to_pay_plan = 'ES' and
2858: p_pay_rate_determinant_code <> 'C'
2859: and
2860: p_pay_rate_determinant_code <> '0'

Line 2919: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then

2915: -- Update/Change Date By Effective Date Comment
2916: -- 9/4 08/10/99 vravikan 01-Mar-99 Add PRD T.
2917: -- UPD 43(Bug 4567571) Raju 09-Nov-2005 Delete PRD M effective date from 01-May-2005
2918: --upd47 26-Jun-06 Raju From 01-Apr-2003 Terminate the edit
2919: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then
2920: If p_effective_date >= fnd_date.canonical_to_date('20'||'05/05/01') then
2921: if (p_first_noa_lookup_code = '892' or
2922: p_first_noa_lookup_code = '893') and
2923: p_pay_rate_determinant_code not in ('0','5','6','7','A','B','E','F','T') and

Line 2920: If p_effective_date >= fnd_date.canonical_to_date('20'||'05/05/01') then

2916: -- 9/4 08/10/99 vravikan 01-Mar-99 Add PRD T.
2917: -- UPD 43(Bug 4567571) Raju 09-Nov-2005 Delete PRD M effective date from 01-May-2005
2918: --upd47 26-Jun-06 Raju From 01-Apr-2003 Terminate the edit
2919: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then
2920: If p_effective_date >= fnd_date.canonical_to_date('20'||'05/05/01') then
2921: if (p_first_noa_lookup_code = '892' or
2922: p_first_noa_lookup_code = '893') and
2923: p_pay_rate_determinant_code not in ('0','5','6','7','A','B','E','F','T') and
2924: p_pay_rate_determinant_code is not null

Line 2930: elsIf p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then

2926: hr_utility.set_message(8301, 'GHR_37061_ALL_PROCEDURE_FAIL');
2927: hr_utility.set_message_token('PRD_LIST','0, 5, 6, 7, A, B, E, F or T');
2928: hr_utility.raise_error;
2929: end if;
2930: elsIf p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
2931: if (p_first_noa_lookup_code = '892' or
2932: p_first_noa_lookup_code = '893') and
2933: p_pay_rate_determinant_code not in ('0','5','6','7','A','B','E','F','M','T') and
2934: p_pay_rate_determinant_code is not null

Line 2960: IF p_effective_date <= fnd_date.canonical_to_date('20'||'02/01/31') THEN

2956: -------------------------------------------------------------------------------
2957: -- Madhuri 01-MAR-05 Retroactively end dating as of 31-JAN-2002
2958: -- UPDATE 38 Changes
2959: -------------------------------------------------------------------------------
2960: IF p_effective_date <= fnd_date.canonical_to_date('20'||'02/01/31') THEN
2961: if p_pay_rate_determinant_code = 'M' and
2962: /* This is the code for the cities of Boston, Chicago, Los Angeles, New York, Philadelphia, San Diego,
2963: San Francisco, and Washington D.C.*/
2964: (

Line 3130: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

3126: -------------------------------------------------------------------------------
3127:
3128: -- 450.40.3
3129: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
3130: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
3131: if p_pay_rate_determinant_code = 'P' and
3132: p_agency <>'VA' then
3133: hr_utility.set_message(8301, 'GHR_37267_ALL_PROCEDURE_FAIL');
3134: hr_utility.raise_error;

Line 3144: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

3140: -- Update/Change Date By Effective Date Comment
3141: -- 9/4 08/10/99 vravikan 01-Mar-99 Exclude PRD T.
3142: -------------------------------------------------------------------------------
3143: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
3144: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
3145: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
3146: if (p_to_pay_plan= 'GM' or
3147: p_to_pay_plan= 'GS'
3148: ) and

Line 3145: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then

3141: -- 9/4 08/10/99 vravikan 01-Mar-99 Exclude PRD T.
3142: -------------------------------------------------------------------------------
3143: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
3144: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
3145: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
3146: if (p_to_pay_plan= 'GM' or
3147: p_to_pay_plan= 'GS'
3148: ) and
3149: p_pay_rate_determinant_code in ('P','T') then