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 157: --IF p_effective_date < fnd_date.canonical_to_date('2005/10/01') then

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

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

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

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

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

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

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

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

223: l_noa_family_code := c_noa_family_code_rec.noa_family_code;
224: hr_utility.set_location('actual noa_family_code is ' || l_noa_family_code,2);
225: exit;
226: END LOOP;
227: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then
228: if substr(p_First_NOAC_Lookup_Code,1,1) in ('1','2','5','6','7','8')
229: and
230: l_noa_family_code not in ('AWARD','GHR_STUDENT_LOAN','GHR_INCENTIVE')
231: and

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

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

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

279: ghr_history_api.get_g_session_var(l_session);
280: if p_effective_date >= to_date('01/10/1998', 'dd/mm/yyyy') then
281: if p_effective_date < fnd_date.canonical_to_date('2006/05/01') then
282: if l_session.noa_id_correct is null then
283: if p_effective_date < fnd_date.canonical_to_date('2004/06/01') then
284: if substr(p_First_NOAC_Lookup_Code,1,1) in ('3','4','5','6','7','8') and
285: p_First_NOAC_Lookup_Code not in ('815','816','817','825','840','841','842',
286: '843','844','845','846','847','848','849','878','879')
287: and

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

318: hr_utility.raise_error;
319: end if;
320: end if; -- p_effective_date < '2004/06/01'
321: end if; --l_session.noa_id_correct is null
322: elsif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then --p_effective_date < '2006/05/01'
323: if l_session.noa_id_correct is null then
324: if substr(p_First_NOAC_Lookup_Code,1,1) in ('3','4','5','6','7','8') and
325: p_First_NOAC_Lookup_Code not in ('815','816','817','825','826','827','840','841','842',
326: '843','844','845','846','847','848','878','879')

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

440: -- 12/08/00 vravikan 01-oct-2000 New Edit
441: -- If nature of action is 600 through 610,
442: -- Then agency/subelement must be TD03
443:
444: IF p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
445: IF p_First_NOAC_Lookup_Code between '600' and '610' and
446: p_agency_subelement <> 'TD03' then
447: hr_utility.set_message(8301, 'GHR_37664_ALL_PROCEDURE_FAIL');
448: hr_utility.raise_error;

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

452: -- 12/08/00 vravikan 01-oct-2000 New Edit
453: -- If nature of action is 871,
454: -- Then Agency must be AF,AR,DD, or NV.
455:
456: IF p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
457: IF p_First_NOAC_Lookup_Code = '871' and
458: substr(p_agency_subelement,1,2) not in ('AF','AR','DD','NV') then
459: hr_utility.set_message(8301, 'GHR_37665_ALL_PROCEDURE_FAIL');
460: hr_utility.raise_error;

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

462: END IF;
463:
464: -- 370.37.2
465: -- Upd 47 23-Jun-06 Raju From 01-Apr-06 New Edit
466: IF p_effective_date >= fnd_date.canonical_to_date('2006/04/01') THEN
467: IF p_First_NOAC_Lookup_Code IN ('611','612','613') AND
468: substr(p_agency_subelement,1,2) not in ('AF','AR','DD','NV') THEN
469: hr_utility.set_message(8301, 'GHR_37164_ALL_PROCEDURE_FAIL');
470: hr_utility.raise_error;

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

561: -- 390.45.1
562: --
563: -- 12/8/00 vravikan 01-Oct-2000 New Edit
564: -- Upd 43 09-NOV-05 Raju 01-Jul-2004 Terminate the Edit Effective 01-Jul-2004
565: if p_effective_date < fnd_date.canonical_to_date('2004/07/01') then
566: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
567: if p_occ_code in ('4431')
568: and (
569: substr(p_agency_sub,1,2) not in ('LP')

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

562: --
563: -- 12/8/00 vravikan 01-Oct-2000 New Edit
564: -- Upd 43 09-NOV-05 Raju 01-Jul-2004 Terminate the Edit Effective 01-Jul-2004
565: if p_effective_date < fnd_date.canonical_to_date('2004/07/01') then
566: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
567: if p_occ_code in ('4431')
568: and (
569: substr(p_agency_sub,1,2) not in ('LP')
570: )

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

577:
578: -- 390.47.1
579: --
580: -- 12/8/00 vravikan 01-Oct-2000 New Edit
581: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
582: if p_occ_code in ('0898','1398','1598')
583: and (
584: p_agency_sub not in ('CM57')
585: )

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

1079: -- 420.17.3
1080: --
1081: -- If pay plan is NH or NJ, then grade must be 01 through 04 or asterisks
1082: --
1083: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1084: if p_to_pay_plan in ('NH', 'NJ') and
1085: p_to_grade_or_level not in ('01', '02', '03', '04') and
1086: p_to_grade_or_level is not null then
1087: hr_utility.set_message(8301, 'GHR_37877_ALL_PROCEDURE_FAIL');

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

1092: -- 420.18.3
1093: --
1094: -- If pay plan is NK, then grade must be 01 through 03 or asterisks
1095: --
1096: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1097: if p_to_pay_plan = 'NK' and
1098: p_to_grade_or_level not in ('01', '02', '03') and
1099: p_to_grade_or_level is not null then
1100: hr_utility.set_message(8301, 'GHR_37878_ALL_PROCEDURE_FAIL');

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

1107: -- 8 01/28/99 vravikan 01/10/98 New Edit
1108: -- If pay plan is FV, then grade must be 'AA' through 'MM' or asterisks
1109: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
1110: --
1111: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') and
1112: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1113: if p_to_pay_plan = 'FV' and
1114: p_to_grade_or_level not in ('AA','BB','CC','DD','EE','FF','GG','HH','II',
1115: 'JJ','KK','LL','MM') and

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

1108: -- If pay plan is FV, then grade must be 'AA' through 'MM' or asterisks
1109: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
1110: --
1111: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') and
1112: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1113: if p_to_pay_plan = 'FV' and
1114: p_to_grade_or_level not in ('AA','BB','CC','DD','EE','FF','GG','HH','II',
1115: 'JJ','KK','LL','MM') and
1116: p_to_grade_or_level is not null then

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

1126: -- If pay plan is JA, then grade must be 01 through 04 or asterisks
1127: --
1128: -- UPD 41(Bug 4567571) Raju 08-Nov-2005 Terminate from 01-Jul-2004
1129: if p_effective_date < to_date('2004/07/01','yyyy/mm/dd') then
1130: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then
1131: if p_to_pay_plan = 'JA' and
1132: p_to_grade_or_level not in ('01', '02', '03','04') and
1133: p_to_grade_or_level is not null then
1134: hr_utility.set_message(8301, 'GHR_37056_ALL_PROCEDURE_FAIL');

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

1142: -- Update Date By Effective Date Comment
1143: -- 8 01/28/99 vravikan 01/10/98 New Edit
1144: -- If pay plan is EV, then grade must be 01 through 03 or asterisks
1145: --
1146: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then
1147: if p_to_pay_plan = 'EV' and
1148: p_to_grade_or_level not in ('01', '02', '03') and
1149: p_to_grade_or_level is not null then
1150: hr_utility.set_message(8301, 'GHR_37032_ALL_PROCEDURE_FAIL');

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

1154:
1155: -- 420.22.3
1156: -- Update Date By Effective Date Comment
1157: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
1158: IF p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1159: if p_to_pay_plan = 'VM' and
1160: p_to_grade_or_level not in ('11', '12', '13', '14', '15', '96', '97') and
1161: p_to_grade_or_level is not null then
1162: hr_utility.set_message(8301, 'GHR_37227_ALL_PROCEDURE_FAIL');

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

1167: -- Update/Change Date By Effective Date Comment
1168: -- 9/2 08/09/99 vravikan 01-Mar-1999 New Edit
1169: -- If pay plan is EZ, then grade must be 01 through 08.
1170: --
1171: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
1172: if p_to_pay_plan = 'EZ' and
1173: p_to_grade_or_level not in ('01','02','03','04','05','06','07','08')
1174: and
1175: p_to_grade_or_level is not null

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

1419: -- Update/Change Date By Effective Date Comment
1420: -- 9/5 08/12/99 vravikan 01-Apr-1999 New Edit
1421: /*If pay plan is NC,
1422: Then grade must be 01 through 03.*/
1423: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1424: if p_to_pay_plan = 'NC' and
1425: p_to_grade_or_level not in ('01', '02', '03')
1426: and
1427: p_to_grade_or_level is not null

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

1435: -- 9/5 08/12/99 vravikan 01-Apr-1999 New Edit
1436: -- 18/6 10/16/02 vnarasim 01-Apr-1999 Added grade 05
1437: /*If pay plan is NO,
1438: Then grade must be 01 through 04 or asterisks.*/
1439: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1440: if p_to_pay_plan = 'NO' and
1441: p_to_grade_or_level not in ('01', '02', '03','04','05')
1442: and
1443: p_to_grade_or_level is not null

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

1450: --420.76.3
1451: -- Update/Change Date By Effective Date Comment
1452: -- 9/5 08/12/99 vravikan 01-Apr-1999 New Edit
1453: /*If pay plan is NP or NR, Then grade must be 01 through 05 or asterisks*/
1454: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1455: if p_to_pay_plan in ('NP','NR') and
1456: p_to_grade_or_level not in ('01', '02', '03','04','05')
1457: and
1458: p_to_grade_or_level is not null

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

1467: -- 18-Aug-2000 vravikan 01-May-2000 New Edit
1468: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
1469: /*If pay plan is VE , Then grade must be 01 ,02 or asterisks*/
1470: If p_effective_date >= to_date('2000/05/01', 'yyyy/mm/dd') and
1471: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1472: if p_to_pay_plan in ('VE') and
1473: p_to_grade_or_level not in ('01', '02')
1474: and
1475: p_to_grade_or_level is not null

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

1753: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
1754: hr_utility.set_message_token('PAY_PLAN','EK');
1755: hr_utility.set_message_token('AGENCY_CODE','DN');
1756: hr_utility.raise_error;
1757: elsif p_effective_date < fnd_date.canonical_to_date('2006/05/01') and
1758: ( p_to_pay_plan = 'FA' and
1759: substr(p_agency_subelement,1,2) not in ('AM','ST') ) then
1760: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
1761: hr_utility.set_message_token('PAY_PLAN','FA');

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

1760: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
1761: hr_utility.set_message_token('PAY_PLAN','FA');
1762: hr_utility.set_message_token('AGENCY_CODE','AM,ST');
1763: hr_utility.raise_error;
1764: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and
1765: ( p_to_pay_plan = 'FA' and
1766: substr(p_agency_subelement,1,2) not in ('AM') ) then
1767: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
1768: hr_utility.set_message_token('PAY_PLAN','FA');

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

1924: hr_utility.set_message_token('AGENCY_CODE','NV');
1925: hr_utility.raise_error;
1926: elsif ( p_to_pay_plan in ('NH','NJ','NK') and
1927: substr(p_agency_subelement,1,2) not in ('AF','AR','DD','NV') and
1928: p_effective_date >= fnd_date.canonical_to_date('1998/03/01') ) then
1929: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
1930: hr_utility.set_message_token('PAY_PLAN','in NH,NJ or NK');
1931: hr_utility.set_message_token('AGENCY_CODE','in AF,AR,DD or NV');
1932: hr_utility.raise_error;

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

1930: hr_utility.set_message_token('PAY_PLAN','in NH,NJ or NK');
1931: hr_utility.set_message_token('AGENCY_CODE','in AF,AR,DD or NV');
1932: hr_utility.raise_error;
1933: elsif ( p_to_pay_plan in ('AT','EV','FV') and
1934: p_effective_date >= fnd_date.canonical_to_date('1998/10/01') and
1935: p_agency_subelement <> 'TD03' ) then
1936: hr_utility.set_location('In pay plan AT', 12);
1937: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
1938: hr_utility.set_message_token('PAY_PLAN','in AT,EV or FV');

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

1946: hr_utility.set_message_token('PAY_PLAN','in JA,JB,JC,JD or JE');
1947: hr_utility.set_message_token('AGENCY_CODE','DJ02');
1948: hr_utility.raise_error;*/
1949: elsif ( p_to_pay_plan in ( 'EZ') and substr(p_agency_subelement,1,2) <> 'SE' and
1950: p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') ) then
1951: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
1952: hr_utility.set_message_token('PAY_PLAN','EZ');
1953: hr_utility.set_message_token('AGENCY_CODE','SE');
1954: hr_utility.raise_error;

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

1952: hr_utility.set_message_token('PAY_PLAN','EZ');
1953: hr_utility.set_message_token('AGENCY_CODE','SE');
1954: hr_utility.raise_error;
1955: elsif ( p_to_pay_plan in ('NC','NO','NP','NR') and substr(p_agency_subelement,1,2) <> 'NV' and
1956: p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') )
1957: then
1958: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
1959: hr_utility.set_message_token('PAY_PLAN','in NC,NO,NP or NR');
1960: hr_utility.set_message_token('AGENCY_CODE','NV');

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

1998: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
1999: hr_utility.set_message_token('PAY_PLAN','TG');
2000: hr_utility.set_message_token('AGENCY_CODE','TR35');
2001: hr_utility.raise_error;
2002: elsif p_effective_date < fnd_date.canonical_to_date('2006/05/01') and
2003: ( p_to_pay_plan in ('AF') and (p_agency_subelement not in ('AG10','CM55')
2004: and substr(p_agency_subelement,1,2) not in ('AM','IB','PU','ST')) )
2005: then
2006: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

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

2007: hr_utility.set_message_token('PAY_PLAN','AF');
2008: hr_utility.set_message_token('AGENCY_CODE','AG10,AM,CM55,IB,PU or ST');
2009: hr_utility.raise_error;
2010:
2011: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and
2012: ( p_to_pay_plan in ('AF') and (p_agency_subelement not in ('AG10','CM55')
2013: and substr(p_agency_subelement,1,2) not in ('AM','IB','PU')) )
2014: then
2015: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

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

2048: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2049: hr_utility.set_message_token('PAY_PLAN','EN');
2050: hr_utility.set_message_token('AGENCY_CODE','DN');
2051: hr_utility.raise_error;
2052: elsif p_effective_date < fnd_date.canonical_to_date('2006/05/01') and
2053: ( p_to_pay_plan in ('FE') and (p_agency_subelement not in ('AG10','CM55','AG34')
2054: and substr(p_agency_subelement,1,2) not in ('AM','HS','IB','PU','ST')) )
2055: then
2056: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

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

2056: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2057: hr_utility.set_message_token('PAY_PLAN','FE');
2058: hr_utility.set_message_token('AGENCY_CODE','AG10,AM,CM55,AG34,HS,IB,PU or ST');
2059: hr_utility.raise_error;
2060: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and
2061: ( p_to_pay_plan in ('FE') and (p_agency_subelement not in ('AG10','CM55','AG34')
2062: and substr(p_agency_subelement,1,2) not in ('AM','HS','IB','PU')) )
2063: then
2064: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

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

2064: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2065: hr_utility.set_message_token('PAY_PLAN','FE');
2066: hr_utility.set_message_token('AGENCY_CODE','AG10,AM,CM55,AG34,HS,IB or PU');
2067: hr_utility.raise_error;
2068: elsif p_effective_date < fnd_date.canonical_to_date('2006/05/01') and
2069: ( p_to_pay_plan in ('FO') and (p_agency_subelement not in ('AG10','CM55','AG34')
2070: and substr(p_agency_subelement,1,2) not in ('AM','IB','PU','ST','HS')) )
2071: then
2072: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

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

2072: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2073: hr_utility.set_message_token('PAY_PLAN','FO');
2074: hr_utility.set_message_token('AGENCY_CODE','AG10,AM,CM55,AG34,IB,PU,HS or ST');
2075: hr_utility.raise_error;
2076: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and
2077: ( p_to_pay_plan in ('FO') and (p_agency_subelement not in ('AG10','CM55','AG34')
2078: and substr(p_agency_subelement,1,2) not in ('AM','IB','PU','HS')) )
2079: then
2080: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

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

2080: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2081: hr_utility.set_message_token('PAY_PLAN','FO');
2082: hr_utility.set_message_token('AGENCY_CODE','AG10,AM,CM55,AG34,IB,PU or HS');
2083: hr_utility.raise_error;
2084: elsif p_effective_date < fnd_date.canonical_to_date('2006/05/01') and
2085: ( p_to_pay_plan in ('FP') and (p_agency_subelement not in ('AG10','CM55','AG34')
2086: and substr(p_agency_subelement,1,2) not in ('AM','HS','IB','PU','ST')) )
2087: then
2088: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

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

2088: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2089: hr_utility.set_message_token('PAY_PLAN','FP');
2090: hr_utility.set_message_token('AGENCY_CODE','AG10,AM,CM55,AG34,HS,IB,PU or ST');
2091: hr_utility.raise_error;
2092: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and
2093: ( p_to_pay_plan in ('FP') and (p_agency_subelement not in ('AG10','CM55','AG34')
2094: and substr(p_agency_subelement,1,2) not in ('AM','HS','IB','PU')) )
2095: then
2096: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');

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

2213: hr_utility.set_message_token('AGENCY_CODE','HUFH');
2214: hr_utility.raise_error;
2215: --End Bug#6469079
2216: --Begin Bug# 5073313
2217: elsif p_effective_date >= fnd_date.canonical_to_date('2006/05/01') and
2218: ( p_to_pay_plan in ('HE','HH','HL','HS','HT','HW') and substr(p_agency_subelement,1,2) <> 'HS' )
2219: then
2220: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2221: hr_utility.set_message_token('PAY_PLAN',p_to_pay_plan);

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

2222: hr_utility.set_message_token('AGENCY_CODE','HS');
2223: hr_utility.raise_error;
2224: --End bug# 5073313
2225: --Begin Bug# 5745356
2226: elsif p_effective_date >= fnd_date.canonical_to_date('2006/10/01') and
2227: ( 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' )
2228: then
2229: hr_utility.set_message(8301,'GHR_37879_ALL_PROCEDURE_FAIL');
2230: hr_utility.set_message_token('PAY_PLAN',p_to_pay_plan);

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

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

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

2417: end if;
2418:
2419: -- 440.25.2
2420: --upd47 26-Jun-06 Raju From 01-Apr-2003 Terminate the edit
2421: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then
2422: If p_first_NOAC_Lookup_Code ='893' and
2423: p_to_pay_plan ='GM' then
2424: hr_utility.set_message(8301, 'GHR_37253_ALL_PROCEDURE_FAIL');
2425: hr_utility.raise_error;

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

2485:
2486: -- 440.46.2
2487: -- 12/8/00 vravikan 01-Oct-2000 New Edit
2488: -- If nature of action is 871, Then pay plan must be GG
2489: if l_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
2490: if p_first_NOAC_Lookup_Code = '871' and
2491: p_to_pay_plan <> 'GG' then
2492: hr_utility.set_message(8301, 'GHR_37677_ALL_PROCEDURE_FAIL');
2493: hr_utility.raise_error;

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

2545: end if;
2546:
2547: -- 450.04.3
2548: --upd47 26-Jun-06 Raju From 01-Apr-2003 Terminate the edit
2549: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then
2550: if (p_to_pay_plan = 'FA' or p_to_pay_plan = 'EX') and
2551: p_pay_rate_determinant_code not in ('C','S','0') and
2552: p_pay_rate_determinant_code is not null then
2553: hr_utility.set_message(8301, 'GHR_37260_ALL_PROCEDURE_FAIL');

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

2558: -- 450.05.3
2559: -- 12/8/00 vravikan 1-oct-00 New Edit
2560: -- If Pay Plan is GH or GM,
2561: -- Then pay rate determinant may not be A,B,E,F,U, or V
2562: IF p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
2563: IF (p_to_pay_plan = 'GH' or p_to_pay_plan = 'GM')
2564: and
2565: p_pay_rate_determinant_code in ('A','B','E','F','U','V')
2566: and

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

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

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

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

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

2663: hr_utility.set_message(8301, 'GHR_37061_ALL_PROCEDURE_FAIL');
2664: hr_utility.set_message_token('PRD_LIST','0, 5, 6, 7, A, B, E, F or T');
2665: hr_utility.raise_error;
2666: end if;
2667: elsIf p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
2668: if (p_first_noa_lookup_code = '892' or
2669: p_first_noa_lookup_code = '893') and
2670: p_pay_rate_determinant_code not in ('0','5','6','7','A','B','E','F','M','T') and
2671: p_pay_rate_determinant_code is not null

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

2693: -------------------------------------------------------------------------------
2694: -- Madhuri 01-MAR-05 Retroactively end dating as of 31-JAN-2002
2695: -- UPDATE 38 Changes
2696: -------------------------------------------------------------------------------
2697: IF p_effective_date <= fnd_date.canonical_to_date('20'||'02/01/31') THEN
2698: if p_pay_rate_determinant_code = 'M' and
2699: /* This is the code for the cities of Boston, Chicago, Los Angeles, New York, Philadelphia, San Diego,
2700: San Francisco, and Washington D.C.*/
2701: (

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

2873: -------------------------------------------------------------------------------
2874: -- Update/Change Date By Effective Date Comment
2875: -- 9/4 08/10/99 vravikan 01-Mar-99 Exclude PRD T.
2876: -------------------------------------------------------------------------------
2877: If p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
2878: if (p_to_pay_plan= 'GM' or
2879: p_to_pay_plan= 'GS'
2880: ) and
2881: p_pay_rate_determinant_code in ('P','T') then