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

Line 56: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/25') then

52:
53: --170.04.1
54: -- Update Date By Effective Date Comment
55: -- ? 05/06/99 vravikan 04/25/99 Fegli changes
56: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/25') then
57: if p_to_basic_pay = '0'
58: and
59: p_to_pay_plan <> 'VC'
60: and

Line 100: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then

96: --Venkat 03/27/2000 -- Bug # 1246822 -- replacing or with and
97:
98: -- 180.02.1
99: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Sep-2006 Terminate the edit
100: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then
101: if (substr(upper(p_duty_station_lookup_code),1,2) between 'AA' and 'ZZ')
102: and (substr(p_duty_station_lookup_code,1,2)<>'US'
103: and -- Bug # 1246822
104: substr(p_duty_station_lookup_code,2,1)<>'Q' )

Line 114: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then

110: end if;
111: end if;
112: -- 180.04.1
113: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Sep-2006 Terminate the edit
114: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then
115: if (p_to_pay_plan = 'WG' or p_to_pay_plan = 'WL')
116: and
117: p_agency_subelement not in ('AFNG','AFZG','ARNG')
118: and

Line 135: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then

131: end if;
132: end if;
133: -- 180.07.1
134: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Sep-2006 Terminate the edit
135: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then
136: if p_to_pay_plan = 'GS'
137: and
138: p_agency_subelement not in ('AFNG','AFZG','ARNG')
139: and

Line 158: if p_effective_date > fnd_date.canonical_to_date('2007/09/06') then

154: end if;
155: end if;
156: -- 180.09.1
157: -- UPD 56 (Bug# 8309414) edit adding eff 07-sep-2007
158: if p_effective_date > fnd_date.canonical_to_date('2007/09/06') then
159: IF (NOT(substr(p_duty_station_lookup_code,1,2) between '00' and '99') AND
160: substr(p_duty_station_lookup_code,1,2) NOT IN ('AQ','CQ','GQ','JQ','LQ','MQ','RQ','VQ','WQ') )
161: AND p_flsa_category <>'E' THEN
162: hr_utility.set_message(8301, 'GHR_37452_ALL_PROCEDURE_FAIL');

Line 197: if p_effective_date < fnd_date.canonical_to_date('2006/10/01') then

193: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Oct-2006 change 0470-0493 to 0470-0487
194: -- remove occu code 1540
195: --Bug # 9471636 17-Mar-2010 Mani Added 1501
196: -- U58 Raju 01-jan-2010 Bug 9503972
197: if p_effective_date < fnd_date.canonical_to_date('2006/10/01') then
198:
199: if (p_to_occ_code in
200: ('0020','0101','0110','0140','0150','0170','0180','0184'
201: ,'0185','0190','0193','0401','0403','0457','0460','0601'

Line 227: elsif p_effective_date < fnd_date.canonical_to_date('2010/01/01') then

223: then
224: hr_utility.set_message(8301, 'GHR_37008_ALL_PROCEDURE_FAIL');
225: hr_utility.raise_error;
226: end if;
227: elsif p_effective_date < fnd_date.canonical_to_date('2010/01/01') then
228: if (p_to_occ_code in
229: ('0020','0101','0110','0140','0150','0170','0180','0184'
230: ,'0185','0190','0193','0401','0403','0457','0460','0601'
231: ,'0602','0610','0644','0660','0662','0665','0668','0680'

Line 292: if p_effective_date < fnd_date.canonical_to_date('2006/10/01') then

288: -- 200.07.1
289: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Oct-2006 change 0470-0493 to 0470-0487
290: -- remove occu code 1540
291: --Bug # 9471636 17-Mar-2010 Mani Added 1501
292: if p_effective_date < fnd_date.canonical_to_date('2006/10/01') then
293: if (p_to_occ_code not in
294: ('0020','0101','0110','0140','0150','0170','0180','0184'
295: ,'0185','0190','0193','0401','0403','0457','0460','0601'
296: ,'0602','0610','0644','0660','0662','0665','0668','0680'

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

480:
481: -- 610.16.1
482: -- UPD 43(Bug 4567571) Raju 09-Nov-2005 Delete PRD M effective date from 01-May-2005
483: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
484: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
485: if p_effective_date < fnd_date.canonical_to_date('2005/05/01') then
486: if p_retain_grade is not null and
487: p_pay_rate_determinant_code not in ('A','B','E','F','M','U','V')
488: then

Line 485: if p_effective_date < fnd_date.canonical_to_date('2005/05/01') then

481: -- 610.16.1
482: -- UPD 43(Bug 4567571) Raju 09-Nov-2005 Delete PRD M effective date from 01-May-2005
483: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
484: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
485: if p_effective_date < fnd_date.canonical_to_date('2005/05/01') then
486: if p_retain_grade is not null and
487: p_pay_rate_determinant_code not in ('A','B','E','F','M','U','V')
488: then
489: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');

Line 493: elsif p_effective_date >= fnd_date.canonical_to_date('2005/05/01') then

489: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');
490: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
491: hr_utility.raise_error;
492: end if;
493: elsif p_effective_date >= fnd_date.canonical_to_date('2005/05/01') then
494: if p_retain_grade is not null and
495: p_pay_rate_determinant_code not in ('A','B','E','F','U','V')
496: then
497: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');

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

554: -- 620.02.1
555: -- If Pay rate determinant is A, B, E, F, U, or V,
556: -- Then retained pay plan may not be GH or GM
557: -- 12/8/00 vravikan 01-Oct-2000 New Edit
558: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
559: if p_pay_rate_determinant_code is not null and
560: p_pay_rate_determinant_code in ('A','B','E','F','U','V') and
561: p_retain_pay_plan in ('GH','GM') then
562: hr_utility.set_message(8301, 'GHR_37663_ALL_PROCEDURE_FAIL');

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

683: */
684:
685: -- 630.07.1
686: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
687: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
688: if (p_pay_rate_determinant_code ='U'
689: or
690: p_pay_rate_determinant_code = 'V')
691: and

Line 721: IF p_effective_date < fnd_date.canonical_to_date('2013/01/01') THEN

717: -- 640.11.1
718: --Bug# 10189715 added retirement plans O, P
719: --Bug# 13572333 added nvl for p_fers_coverage
720: --Bug# 15941036 added Retirement codes KR,LR,MR,NR,OR,PR
721: IF p_effective_date < fnd_date.canonical_to_date('2013/01/01') THEN
722: if p_retirement_plan_code in ('K','L','M','N','O','P')
723: and NVL(p_fers_coverage,'#') NOT IN ( 'A', 'E' )
724: then
725: hr_utility.set_message(8301, 'GHR_37024_ALL_PROCEDURE_FAIL');

Line 742: IF p_effective_date < fnd_date.canonical_to_date('2013/01/01') THEN

738: --End Bug# 15941036
739: -- 640.14.1
740: --Bug# 10189715 added retirement plans O
741: --Bug# 15941036 added Retirement codes KR,LR,MR,NR,OR,PR
742: IF p_effective_date < fnd_date.canonical_to_date('2013/01/01') THEN
743: if (p_fers_coverage = 'A'
744: or
745: p_fers_coverage = 'E')
746: and

Line 910: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_period), 'yyyy'))

906: hr_utility.raise_error;
907: end if;
908:
909: -- 472.00.3
910: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_period), 'yyyy'))
911: NOT BETWEEN 1900 and 2099 then
912: hr_utility.set_message(8301, 'GHR_37891_ALL_PROCEDURE_FAIL');
913: hr_utility.raise_error;
914: end if;

Line 916: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_per_starts), 'yyyy'))

912: hr_utility.set_message(8301, 'GHR_37891_ALL_PROCEDURE_FAIL');
913: hr_utility.raise_error;
914: end if;
915: --Bug# 4753117 28-Feb-07 Veeramani adding edit for the Appraisal start date
916: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_per_starts), 'yyyy'))
917: NOT BETWEEN 1900 and 2099 then
918: hr_utility.set_message(8301, 'GHR_37891_ALL_PROCEDURE_FAIL');
919: hr_utility.raise_error;
920: end if;