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_CHECK5 dependencies on HR_UTILITY

Line 39: hr_utility.set_message(8301, 'GHR_37501_ALL_PROCEDURE_FAIL');

35: -- 470.02.2
36: IF p_effective_date < to_date('2007/05/01','RRRR/MM/DD') then --Bug#6469079
37: if p_first_noac_lookup_code not in ('001','817') and
38: p_rating_of_record_level is null then
39: hr_utility.set_message(8301, 'GHR_37501_ALL_PROCEDURE_FAIL');
40: hr_utility.raise_error;
41: end if;
42: ELSE ---Begin Bug#6469079
43: if p_first_noac_lookup_code not in ('001','817') and

Line 40: hr_utility.raise_error;

36: IF p_effective_date < to_date('2007/05/01','RRRR/MM/DD') then --Bug#6469079
37: if p_first_noac_lookup_code not in ('001','817') and
38: p_rating_of_record_level is null then
39: hr_utility.set_message(8301, 'GHR_37501_ALL_PROCEDURE_FAIL');
40: hr_utility.raise_error;
41: end if;
42: ELSE ---Begin Bug#6469079
43: if p_first_noac_lookup_code not in ('001','817') and
44: p_rating_of_record_pattern <> 'Z' and

Line 46: hr_utility.set_message(8301, 'GHR_38426_ALL_PROCEDURE_FAIL');

42: ELSE ---Begin Bug#6469079
43: if p_first_noac_lookup_code not in ('001','817') and
44: p_rating_of_record_pattern <> 'Z' and
45: p_rating_of_record_level is null then
46: hr_utility.set_message(8301, 'GHR_38426_ALL_PROCEDURE_FAIL');
47: hr_utility.raise_error;
48: end if; --End Bug#6469079
49: END IF;
50:

Line 47: hr_utility.raise_error;

43: if p_first_noac_lookup_code not in ('001','817') and
44: p_rating_of_record_pattern <> 'Z' and
45: p_rating_of_record_level is null then
46: hr_utility.set_message(8301, 'GHR_38426_ALL_PROCEDURE_FAIL');
47: hr_utility.raise_error;
48: end if; --End Bug#6469079
49: END IF;
50:
51:

Line 63: hr_utility.set_message(8301, 'GHR_37176_ALL_PROCEDURE_FAIL');

59: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
60: if p_rating_of_record_pattern = 'A' and
61: p_rating_of_record_level not in ('1','3','X','Z') and
62: p_rating_of_record_level is not null then
63: hr_utility.set_message(8301, 'GHR_37176_ALL_PROCEDURE_FAIL');
64: hr_utility.set_message_token('REC_LEVEL','1, 3, X or Z');
65: hr_utility.raise_error;
66: end if;
67: else --Begin Bug#6469079

Line 64: hr_utility.set_message_token('REC_LEVEL','1, 3, X or Z');

60: if p_rating_of_record_pattern = 'A' and
61: p_rating_of_record_level not in ('1','3','X','Z') and
62: p_rating_of_record_level is not null then
63: hr_utility.set_message(8301, 'GHR_37176_ALL_PROCEDURE_FAIL');
64: hr_utility.set_message_token('REC_LEVEL','1, 3, X or Z');
65: hr_utility.raise_error;
66: end if;
67: else --Begin Bug#6469079
68: if p_rating_of_record_pattern = 'A' and

Line 65: hr_utility.raise_error;

61: p_rating_of_record_level not in ('1','3','X','Z') and
62: p_rating_of_record_level is not null then
63: hr_utility.set_message(8301, 'GHR_37176_ALL_PROCEDURE_FAIL');
64: hr_utility.set_message_token('REC_LEVEL','1, 3, X or Z');
65: hr_utility.raise_error;
66: end if;
67: else --Begin Bug#6469079
68: if p_rating_of_record_pattern = 'A' and
69: p_rating_of_record_level not in ('1','3','X') and

Line 71: hr_utility.set_message(8301, 'GHR_37176_ALL_PROCEDURE_FAIL');

67: else --Begin Bug#6469079
68: if p_rating_of_record_pattern = 'A' and
69: p_rating_of_record_level not in ('1','3','X') and
70: p_rating_of_record_level is not null then
71: hr_utility.set_message(8301, 'GHR_37176_ALL_PROCEDURE_FAIL');
72: hr_utility.set_message_token('REC_LEVEL','1, 3 or X');
73: hr_utility.raise_error;
74: end if; --End Bug#6469079
75: end if;

Line 72: hr_utility.set_message_token('REC_LEVEL','1, 3 or X');

68: if p_rating_of_record_pattern = 'A' and
69: p_rating_of_record_level not in ('1','3','X') and
70: p_rating_of_record_level is not null then
71: hr_utility.set_message(8301, 'GHR_37176_ALL_PROCEDURE_FAIL');
72: hr_utility.set_message_token('REC_LEVEL','1, 3 or X');
73: hr_utility.raise_error;
74: end if; --End Bug#6469079
75: end if;
76: --470.04.3

Line 73: hr_utility.raise_error;

69: p_rating_of_record_level not in ('1','3','X') and
70: p_rating_of_record_level is not null then
71: hr_utility.set_message(8301, 'GHR_37176_ALL_PROCEDURE_FAIL');
72: hr_utility.set_message_token('REC_LEVEL','1, 3 or X');
73: hr_utility.raise_error;
74: end if; --End Bug#6469079
75: end if;
76: --470.04.3
77: -- 10/6 08/13/99 vravikan 01-Oct-99 New Edit

Line 87: hr_utility.set_message(8301, 'GHR_37177_ALL_PROCEDURE_FAIL');

83: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
84: if p_rating_of_record_pattern = 'B' and
85: p_rating_of_record_level not in ('1','3','5','X','Z') and
86: p_rating_of_record_level is not null then
87: hr_utility.set_message(8301, 'GHR_37177_ALL_PROCEDURE_FAIL');
88: hr_utility.set_message_token('REC_LEVEL','1, 3, 5, X or Z');
89: hr_utility.raise_error;
90: end if;
91: else --Begin Bug#6469079

Line 88: hr_utility.set_message_token('REC_LEVEL','1, 3, 5, X or Z');

84: if p_rating_of_record_pattern = 'B' and
85: p_rating_of_record_level not in ('1','3','5','X','Z') and
86: p_rating_of_record_level is not null then
87: hr_utility.set_message(8301, 'GHR_37177_ALL_PROCEDURE_FAIL');
88: hr_utility.set_message_token('REC_LEVEL','1, 3, 5, X or Z');
89: hr_utility.raise_error;
90: end if;
91: else --Begin Bug#6469079
92: if p_rating_of_record_pattern = 'B' and

Line 89: hr_utility.raise_error;

85: p_rating_of_record_level not in ('1','3','5','X','Z') and
86: p_rating_of_record_level is not null then
87: hr_utility.set_message(8301, 'GHR_37177_ALL_PROCEDURE_FAIL');
88: hr_utility.set_message_token('REC_LEVEL','1, 3, 5, X or Z');
89: hr_utility.raise_error;
90: end if;
91: else --Begin Bug#6469079
92: if p_rating_of_record_pattern = 'B' and
93: p_rating_of_record_level not in ('1','3','5','X') and

Line 95: hr_utility.set_message(8301, 'GHR_37177_ALL_PROCEDURE_FAIL');

91: else --Begin Bug#6469079
92: if p_rating_of_record_pattern = 'B' and
93: p_rating_of_record_level not in ('1','3','5','X') and
94: p_rating_of_record_level is not null then
95: hr_utility.set_message(8301, 'GHR_37177_ALL_PROCEDURE_FAIL');
96: hr_utility.set_message_token('REC_LEVEL','1, 3, 5 or X ');
97: hr_utility.raise_error;
98: end if; --End Bug#6469079
99: end if;

Line 96: hr_utility.set_message_token('REC_LEVEL','1, 3, 5 or X ');

92: if p_rating_of_record_pattern = 'B' and
93: p_rating_of_record_level not in ('1','3','5','X') and
94: p_rating_of_record_level is not null then
95: hr_utility.set_message(8301, 'GHR_37177_ALL_PROCEDURE_FAIL');
96: hr_utility.set_message_token('REC_LEVEL','1, 3, 5 or X ');
97: hr_utility.raise_error;
98: end if; --End Bug#6469079
99: end if;
100: --470.05.3

Line 97: hr_utility.raise_error;

93: p_rating_of_record_level not in ('1','3','5','X') and
94: p_rating_of_record_level is not null then
95: hr_utility.set_message(8301, 'GHR_37177_ALL_PROCEDURE_FAIL');
96: hr_utility.set_message_token('REC_LEVEL','1, 3, 5 or X ');
97: hr_utility.raise_error;
98: end if; --End Bug#6469079
99: end if;
100: --470.05.3
101: -- 10/6 08/13/99 vravikan 01-Oct-99 New Edit

Line 111: hr_utility.set_message(8301, 'GHR_37178_ALL_PROCEDURE_FAIL');

107: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
108: if p_rating_of_record_pattern = 'C' and
109: p_rating_of_record_level not in ('1','3','4','X','Z') and
110: p_rating_of_record_level is not null then
111: hr_utility.set_message(8301, 'GHR_37178_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('REC_LEVEL','1, 3, 4, X or Z');
113: hr_utility.raise_error;
114: end if;
115: else --Begin Bug#6469079

Line 112: hr_utility.set_message_token('REC_LEVEL','1, 3, 4, X or Z');

108: if p_rating_of_record_pattern = 'C' and
109: p_rating_of_record_level not in ('1','3','4','X','Z') and
110: p_rating_of_record_level is not null then
111: hr_utility.set_message(8301, 'GHR_37178_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('REC_LEVEL','1, 3, 4, X or Z');
113: hr_utility.raise_error;
114: end if;
115: else --Begin Bug#6469079
116: if p_rating_of_record_pattern = 'C' and

Line 113: hr_utility.raise_error;

109: p_rating_of_record_level not in ('1','3','4','X','Z') and
110: p_rating_of_record_level is not null then
111: hr_utility.set_message(8301, 'GHR_37178_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('REC_LEVEL','1, 3, 4, X or Z');
113: hr_utility.raise_error;
114: end if;
115: else --Begin Bug#6469079
116: if p_rating_of_record_pattern = 'C' and
117: p_rating_of_record_level not in ('1','3','4','X') and

Line 119: hr_utility.set_message(8301, 'GHR_37178_ALL_PROCEDURE_FAIL');

115: else --Begin Bug#6469079
116: if p_rating_of_record_pattern = 'C' and
117: p_rating_of_record_level not in ('1','3','4','X') and
118: p_rating_of_record_level is not null then
119: hr_utility.set_message(8301, 'GHR_37178_ALL_PROCEDURE_FAIL');
120: hr_utility.set_message_token('REC_LEVEL','1, 3, 4 or X');
121: hr_utility.raise_error;
122: end if; --End Bug#6469079
123: end if;

Line 120: hr_utility.set_message_token('REC_LEVEL','1, 3, 4 or X');

116: if p_rating_of_record_pattern = 'C' and
117: p_rating_of_record_level not in ('1','3','4','X') and
118: p_rating_of_record_level is not null then
119: hr_utility.set_message(8301, 'GHR_37178_ALL_PROCEDURE_FAIL');
120: hr_utility.set_message_token('REC_LEVEL','1, 3, 4 or X');
121: hr_utility.raise_error;
122: end if; --End Bug#6469079
123: end if;
124: --470.06.3

Line 121: hr_utility.raise_error;

117: p_rating_of_record_level not in ('1','3','4','X') and
118: p_rating_of_record_level is not null then
119: hr_utility.set_message(8301, 'GHR_37178_ALL_PROCEDURE_FAIL');
120: hr_utility.set_message_token('REC_LEVEL','1, 3, 4 or X');
121: hr_utility.raise_error;
122: end if; --End Bug#6469079
123: end if;
124: --470.06.3
125: -- 10/6 08/13/99 vravikan 01-Oct-99 New Edit

Line 135: hr_utility.set_message(8301, 'GHR_37179_ALL_PROCEDURE_FAIL');

131: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
132: if p_rating_of_record_pattern = 'D' and
133: p_rating_of_record_level not in ('1','2','3','X','Z') and
134: p_rating_of_record_level is not null then
135: hr_utility.set_message(8301, 'GHR_37179_ALL_PROCEDURE_FAIL');
136: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, X or Z');
137: hr_utility.raise_error;
138: end if;
139: else --Begin Bug#6469079

Line 136: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, X or Z');

132: if p_rating_of_record_pattern = 'D' and
133: p_rating_of_record_level not in ('1','2','3','X','Z') and
134: p_rating_of_record_level is not null then
135: hr_utility.set_message(8301, 'GHR_37179_ALL_PROCEDURE_FAIL');
136: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, X or Z');
137: hr_utility.raise_error;
138: end if;
139: else --Begin Bug#6469079
140: if p_rating_of_record_pattern = 'D' and

Line 137: hr_utility.raise_error;

133: p_rating_of_record_level not in ('1','2','3','X','Z') and
134: p_rating_of_record_level is not null then
135: hr_utility.set_message(8301, 'GHR_37179_ALL_PROCEDURE_FAIL');
136: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, X or Z');
137: hr_utility.raise_error;
138: end if;
139: else --Begin Bug#6469079
140: if p_rating_of_record_pattern = 'D' and
141: p_rating_of_record_level not in ('1','2','3','X') and

Line 143: hr_utility.set_message(8301, 'GHR_37179_ALL_PROCEDURE_FAIL');

139: else --Begin Bug#6469079
140: if p_rating_of_record_pattern = 'D' and
141: p_rating_of_record_level not in ('1','2','3','X') and
142: p_rating_of_record_level is not null then
143: hr_utility.set_message(8301, 'GHR_37179_ALL_PROCEDURE_FAIL');
144: hr_utility.set_message_token('REC_LEVEL','1, 2, 3 or X');
145: hr_utility.raise_error;
146: end if; --End Bug#6469079
147: end if;

Line 144: hr_utility.set_message_token('REC_LEVEL','1, 2, 3 or X');

140: if p_rating_of_record_pattern = 'D' and
141: p_rating_of_record_level not in ('1','2','3','X') and
142: p_rating_of_record_level is not null then
143: hr_utility.set_message(8301, 'GHR_37179_ALL_PROCEDURE_FAIL');
144: hr_utility.set_message_token('REC_LEVEL','1, 2, 3 or X');
145: hr_utility.raise_error;
146: end if; --End Bug#6469079
147: end if;
148:

Line 145: hr_utility.raise_error;

141: p_rating_of_record_level not in ('1','2','3','X') and
142: p_rating_of_record_level is not null then
143: hr_utility.set_message(8301, 'GHR_37179_ALL_PROCEDURE_FAIL');
144: hr_utility.set_message_token('REC_LEVEL','1, 2, 3 or X');
145: hr_utility.raise_error;
146: end if; --End Bug#6469079
147: end if;
148:
149: --470.07.3

Line 160: hr_utility.set_message(8301, 'GHR_37180_ALL_PROCEDURE_FAIL');

156: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
157: if p_rating_of_record_pattern = 'E' and
158: p_rating_of_record_level not in ('1','3','4','5','X','Z') and
159: p_rating_of_record_level is not null then
160: hr_utility.set_message(8301, 'GHR_37180_ALL_PROCEDURE_FAIL');
161: hr_utility.set_message_token('REC_LEVEL','1, 3, 4, 5, X or Z');
162: hr_utility.raise_error;
163: end if;
164: else --Begin Bug#6469079

Line 161: hr_utility.set_message_token('REC_LEVEL','1, 3, 4, 5, X or Z');

157: if p_rating_of_record_pattern = 'E' and
158: p_rating_of_record_level not in ('1','3','4','5','X','Z') and
159: p_rating_of_record_level is not null then
160: hr_utility.set_message(8301, 'GHR_37180_ALL_PROCEDURE_FAIL');
161: hr_utility.set_message_token('REC_LEVEL','1, 3, 4, 5, X or Z');
162: hr_utility.raise_error;
163: end if;
164: else --Begin Bug#6469079
165: if p_rating_of_record_pattern = 'E' and

Line 162: hr_utility.raise_error;

158: p_rating_of_record_level not in ('1','3','4','5','X','Z') and
159: p_rating_of_record_level is not null then
160: hr_utility.set_message(8301, 'GHR_37180_ALL_PROCEDURE_FAIL');
161: hr_utility.set_message_token('REC_LEVEL','1, 3, 4, 5, X or Z');
162: hr_utility.raise_error;
163: end if;
164: else --Begin Bug#6469079
165: if p_rating_of_record_pattern = 'E' and
166: p_rating_of_record_level not in ('1','3','4','5','X') and

Line 168: hr_utility.set_message(8301, 'GHR_37180_ALL_PROCEDURE_FAIL');

164: else --Begin Bug#6469079
165: if p_rating_of_record_pattern = 'E' and
166: p_rating_of_record_level not in ('1','3','4','5','X') and
167: p_rating_of_record_level is not null then
168: hr_utility.set_message(8301, 'GHR_37180_ALL_PROCEDURE_FAIL');
169: hr_utility.set_message_token('REC_LEVEL','1, 3, 4, 5 or X');
170: hr_utility.raise_error;
171: end if; --End Bug#6469079
172: end if;

Line 169: hr_utility.set_message_token('REC_LEVEL','1, 3, 4, 5 or X');

165: if p_rating_of_record_pattern = 'E' and
166: p_rating_of_record_level not in ('1','3','4','5','X') and
167: p_rating_of_record_level is not null then
168: hr_utility.set_message(8301, 'GHR_37180_ALL_PROCEDURE_FAIL');
169: hr_utility.set_message_token('REC_LEVEL','1, 3, 4, 5 or X');
170: hr_utility.raise_error;
171: end if; --End Bug#6469079
172: end if;
173: --470.08.3

Line 170: hr_utility.raise_error;

166: p_rating_of_record_level not in ('1','3','4','5','X') and
167: p_rating_of_record_level is not null then
168: hr_utility.set_message(8301, 'GHR_37180_ALL_PROCEDURE_FAIL');
169: hr_utility.set_message_token('REC_LEVEL','1, 3, 4, 5 or X');
170: hr_utility.raise_error;
171: end if; --End Bug#6469079
172: end if;
173: --470.08.3
174: -- 10/6 08/13/99 vravikan 01-Oct-99 New Edit

Line 184: hr_utility.set_message(8301, 'GHR_37181_ALL_PROCEDURE_FAIL');

180: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
181: if p_rating_of_record_pattern = 'F' and
182: p_rating_of_record_level not in ('1','2','3','5','X','Z') and
183: p_rating_of_record_level is not null then
184: hr_utility.set_message(8301, 'GHR_37181_ALL_PROCEDURE_FAIL');
185: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 5, X or Z');
186: hr_utility.raise_error;
187: end if;
188: else --Begin Bug#6469079

Line 185: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 5, X or Z');

181: if p_rating_of_record_pattern = 'F' and
182: p_rating_of_record_level not in ('1','2','3','5','X','Z') and
183: p_rating_of_record_level is not null then
184: hr_utility.set_message(8301, 'GHR_37181_ALL_PROCEDURE_FAIL');
185: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 5, X or Z');
186: hr_utility.raise_error;
187: end if;
188: else --Begin Bug#6469079
189: if p_rating_of_record_pattern = 'F' and

Line 186: hr_utility.raise_error;

182: p_rating_of_record_level not in ('1','2','3','5','X','Z') and
183: p_rating_of_record_level is not null then
184: hr_utility.set_message(8301, 'GHR_37181_ALL_PROCEDURE_FAIL');
185: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 5, X or Z');
186: hr_utility.raise_error;
187: end if;
188: else --Begin Bug#6469079
189: if p_rating_of_record_pattern = 'F' and
190: p_rating_of_record_level not in ('1','2','3','5','X') and

Line 192: hr_utility.set_message(8301, 'GHR_37181_ALL_PROCEDURE_FAIL');

188: else --Begin Bug#6469079
189: if p_rating_of_record_pattern = 'F' and
190: p_rating_of_record_level not in ('1','2','3','5','X') and
191: p_rating_of_record_level is not null then
192: hr_utility.set_message(8301, 'GHR_37181_ALL_PROCEDURE_FAIL');
193: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 5 or X');
194: hr_utility.raise_error;
195: end if; --End Bug#6469079
196: end if;

Line 193: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 5 or X');

189: if p_rating_of_record_pattern = 'F' and
190: p_rating_of_record_level not in ('1','2','3','5','X') and
191: p_rating_of_record_level is not null then
192: hr_utility.set_message(8301, 'GHR_37181_ALL_PROCEDURE_FAIL');
193: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 5 or X');
194: hr_utility.raise_error;
195: end if; --End Bug#6469079
196: end if;
197: --470.09.3

Line 194: hr_utility.raise_error;

190: p_rating_of_record_level not in ('1','2','3','5','X') and
191: p_rating_of_record_level is not null then
192: hr_utility.set_message(8301, 'GHR_37181_ALL_PROCEDURE_FAIL');
193: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 5 or X');
194: hr_utility.raise_error;
195: end if; --End Bug#6469079
196: end if;
197: --470.09.3
198: -- 10/6 08/13/99 vravikan 01-Oct-99 New Edit

Line 208: hr_utility.set_message(8301, 'GHR_37182_ALL_PROCEDURE_FAIL');

204: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
205: if p_rating_of_record_pattern = 'G' and
206: p_rating_of_record_level not in ('1','2','3','4','X','Z') and
207: p_rating_of_record_level is not null then
208: hr_utility.set_message(8301, 'GHR_37182_ALL_PROCEDURE_FAIL');
209: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4, X or Z');
210: hr_utility.raise_error;
211: end if;
212: else --Begin Bug#6469079

Line 209: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4, X or Z');

205: if p_rating_of_record_pattern = 'G' and
206: p_rating_of_record_level not in ('1','2','3','4','X','Z') and
207: p_rating_of_record_level is not null then
208: hr_utility.set_message(8301, 'GHR_37182_ALL_PROCEDURE_FAIL');
209: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4, X or Z');
210: hr_utility.raise_error;
211: end if;
212: else --Begin Bug#6469079
213: if p_rating_of_record_pattern = 'G' and

Line 210: hr_utility.raise_error;

206: p_rating_of_record_level not in ('1','2','3','4','X','Z') and
207: p_rating_of_record_level is not null then
208: hr_utility.set_message(8301, 'GHR_37182_ALL_PROCEDURE_FAIL');
209: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4, X or Z');
210: hr_utility.raise_error;
211: end if;
212: else --Begin Bug#6469079
213: if p_rating_of_record_pattern = 'G' and
214: p_rating_of_record_level not in ('1','2','3','4','X') and

Line 216: hr_utility.set_message(8301, 'GHR_37182_ALL_PROCEDURE_FAIL');

212: else --Begin Bug#6469079
213: if p_rating_of_record_pattern = 'G' and
214: p_rating_of_record_level not in ('1','2','3','4','X') and
215: p_rating_of_record_level is not null then
216: hr_utility.set_message(8301, 'GHR_37182_ALL_PROCEDURE_FAIL');
217: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4 or X');
218: hr_utility.raise_error;
219: end if; --End Bug#6469079
220: end if;

Line 217: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4 or X');

213: if p_rating_of_record_pattern = 'G' and
214: p_rating_of_record_level not in ('1','2','3','4','X') and
215: p_rating_of_record_level is not null then
216: hr_utility.set_message(8301, 'GHR_37182_ALL_PROCEDURE_FAIL');
217: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4 or X');
218: hr_utility.raise_error;
219: end if; --End Bug#6469079
220: end if;
221: --470.10.3

Line 218: hr_utility.raise_error;

214: p_rating_of_record_level not in ('1','2','3','4','X') and
215: p_rating_of_record_level is not null then
216: hr_utility.set_message(8301, 'GHR_37182_ALL_PROCEDURE_FAIL');
217: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4 or X');
218: hr_utility.raise_error;
219: end if; --End Bug#6469079
220: end if;
221: --470.10.3
222: -- 10/6 08/13/99 vravikan 01-Oct-99 New Edit

Line 232: hr_utility.set_message(8301, 'GHR_37183_ALL_PROCEDURE_FAIL');

228: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
229: if p_rating_of_record_pattern = 'H' and
230: p_rating_of_record_level not in ('1','2','3','4','5','X','Z') and
231: p_rating_of_record_level is not null then
232: hr_utility.set_message(8301, 'GHR_37183_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4, 5, X or Z');
234: hr_utility.raise_error;
235: end if;
236: else --Begin Bug#6469079

Line 233: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4, 5, X or Z');

229: if p_rating_of_record_pattern = 'H' and
230: p_rating_of_record_level not in ('1','2','3','4','5','X','Z') and
231: p_rating_of_record_level is not null then
232: hr_utility.set_message(8301, 'GHR_37183_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4, 5, X or Z');
234: hr_utility.raise_error;
235: end if;
236: else --Begin Bug#6469079
237: if p_rating_of_record_pattern = 'H' and

Line 234: hr_utility.raise_error;

230: p_rating_of_record_level not in ('1','2','3','4','5','X','Z') and
231: p_rating_of_record_level is not null then
232: hr_utility.set_message(8301, 'GHR_37183_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4, 5, X or Z');
234: hr_utility.raise_error;
235: end if;
236: else --Begin Bug#6469079
237: if p_rating_of_record_pattern = 'H' and
238: p_rating_of_record_level not in ('1','2','3','4','5','X') and

Line 240: hr_utility.set_message(8301, 'GHR_37183_ALL_PROCEDURE_FAIL');

236: else --Begin Bug#6469079
237: if p_rating_of_record_pattern = 'H' and
238: p_rating_of_record_level not in ('1','2','3','4','5','X') and
239: p_rating_of_record_level is not null then
240: hr_utility.set_message(8301, 'GHR_37183_ALL_PROCEDURE_FAIL');
241: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4, 5 or X');
242: hr_utility.raise_error;
243: end if; --End Bug#6469079
244: end if;

Line 241: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4, 5 or X');

237: if p_rating_of_record_pattern = 'H' and
238: p_rating_of_record_level not in ('1','2','3','4','5','X') and
239: p_rating_of_record_level is not null then
240: hr_utility.set_message(8301, 'GHR_37183_ALL_PROCEDURE_FAIL');
241: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4, 5 or X');
242: hr_utility.raise_error;
243: end if; --End Bug#6469079
244: end if;
245:

Line 242: hr_utility.raise_error;

238: p_rating_of_record_level not in ('1','2','3','4','5','X') and
239: p_rating_of_record_level is not null then
240: hr_utility.set_message(8301, 'GHR_37183_ALL_PROCEDURE_FAIL');
241: hr_utility.set_message_token('REC_LEVEL','1, 2, 3, 4, 5 or X');
242: hr_utility.raise_error;
243: end if; --End Bug#6469079
244: end if;
245:
246: -- 471.02.3

Line 252: hr_utility.set_message(8301, 'GHR_37502_ALL_PROCEDURE_FAIL');

248: (p_rating_of_record_pattern is null or
249: p_rating_of_record_period is null or
250: ----Bug# 4753117 28-Feb-07 Veeramani adding Appraisal start date
251: p_rating_of_record_per_starts is null) then
252: hr_utility.set_message(8301, 'GHR_37502_ALL_PROCEDURE_FAIL');
253: hr_utility.raise_error;
254: end if;
255:
256: --471.03.3

Line 253: hr_utility.raise_error;

249: p_rating_of_record_period is null or
250: ----Bug# 4753117 28-Feb-07 Veeramani adding Appraisal start date
251: p_rating_of_record_per_starts is null) then
252: hr_utility.set_message(8301, 'GHR_37502_ALL_PROCEDURE_FAIL');
253: hr_utility.raise_error;
254: end if;
255:
256: --471.03.3
257: -- 10/6 08/16/99 vravikan 01-Oct-99 New Edit

Line 262: hr_utility.set_message(8301, 'GHR_37184_ALL_PROCEDURE_FAIL');

258: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01') then
259: if p_to_pay_plan in ('ES') and
260: (p_rating_of_record_pattern is not null and
261: p_rating_of_record_pattern in ('A','B','C','E') ) then
262: hr_utility.set_message(8301, 'GHR_37184_ALL_PROCEDURE_FAIL');
263: hr_utility.raise_error;
264: end if;
265: end if;
266:

Line 263: hr_utility.raise_error;

259: if p_to_pay_plan in ('ES') and
260: (p_rating_of_record_pattern is not null and
261: p_rating_of_record_pattern in ('A','B','C','E') ) then
262: hr_utility.set_message(8301, 'GHR_37184_ALL_PROCEDURE_FAIL');
263: hr_utility.raise_error;
264: end if;
265: end if;
266:
267: --471.06.1

Line 273: hr_utility.set_message(8301, 'GHR_38428_ALL_PROCEDURE_FAIL');

269:
270: if p_effective_date >= to_date('2007/05/01','RRRR/MM/DD') then
271: if p_rating_of_record_level is null and
272: p_rating_of_record_pattern not in ('Z') then
273: hr_utility.set_message(8301, 'GHR_38428_ALL_PROCEDURE_FAIL');
274: hr_utility.raise_error;
275: end if;
276: end if;
277:

Line 274: hr_utility.raise_error;

270: if p_effective_date >= to_date('2007/05/01','RRRR/MM/DD') then
271: if p_rating_of_record_level is null and
272: p_rating_of_record_pattern not in ('Z') then
273: hr_utility.set_message(8301, 'GHR_38428_ALL_PROCEDURE_FAIL');
274: hr_utility.raise_error;
275: end if;
276: end if;
277:
278:

Line 283: hr_utility.set_message(8301, 'GHR_37503_ALL_PROCEDURE_FAIL');

279: /* void due to lack of submission date
280: --472.02.1
281: if p_rating_of_record_period is not null and
282: fnd_date.canonical_to_date(p_rating_of_record_period) > p_submission_date then
283: hr_utility.set_message(8301, 'GHR_37503_ALL_PROCEDURE_FAIL');
284: hr_utility.raise_error;
285: end if;
286: */
287: --Bug# 4753117 28-Feb-07 Veeramani commented as this edit is not required as per the

Line 284: hr_utility.raise_error;

280: --472.02.1
281: if p_rating_of_record_period is not null and
282: fnd_date.canonical_to_date(p_rating_of_record_period) > p_submission_date then
283: hr_utility.set_message(8301, 'GHR_37503_ALL_PROCEDURE_FAIL');
284: hr_utility.raise_error;
285: end if;
286: */
287: --Bug# 4753117 28-Feb-07 Veeramani commented as this edit is not required as per the
288: --bug description

Line 293: hr_utility.set_message(8301, 'GHR_37504_ALL_PROCEDURE_FAIL');

289:
290: /*--472.02.2
291: if p_rating_of_record_period is not null and
292: fnd_date.canonical_to_date(p_rating_of_record_period) > p_effective_date then
293: hr_utility.set_message(8301, 'GHR_37504_ALL_PROCEDURE_FAIL');
294: hr_utility.raise_error;
295: end if;
296: */
297:

Line 294: hr_utility.raise_error;

290: /*--472.02.2
291: if p_rating_of_record_period is not null and
292: fnd_date.canonical_to_date(p_rating_of_record_period) > p_effective_date then
293: hr_utility.set_message(8301, 'GHR_37504_ALL_PROCEDURE_FAIL');
294: hr_utility.raise_error;
295: end if;
296: */
297:
298: --472.03.3

Line 303: hr_utility.set_message(8301, 'GHR_37505_ALL_PROCEDURE_FAIL');

299: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
300: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
301: if p_rating_of_record_level = 'X' and
302: p_rating_of_record_period is not null then
303: hr_utility.set_message(8301, 'GHR_37505_ALL_PROCEDURE_FAIL');
304: hr_utility.raise_error;
305: end if;
306: end if;
307:

Line 304: hr_utility.raise_error;

300: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
301: if p_rating_of_record_level = 'X' and
302: p_rating_of_record_period is not null then
303: hr_utility.set_message(8301, 'GHR_37505_ALL_PROCEDURE_FAIL');
304: hr_utility.raise_error;
305: end if;
306: end if;
307:
308: --472.04.2

Line 325: hr_utility.set_message(8301, 'GHR_37857_ALL_PROCEDURE_FAIL');

321: ((p_rating_of_record_period is not null and
322: months_between(p_effective_date,l_end_date ) > 60) or
323: (p_rating_of_record_per_starts is not null and
324: months_between(p_effective_date,l_start_date ) > 60)) then
325: hr_utility.set_message(8301, 'GHR_37857_ALL_PROCEDURE_FAIL');
326: hr_utility.raise_error;
327: end if;*/
328:
329:

Line 326: hr_utility.raise_error;

322: months_between(p_effective_date,l_end_date ) > 60) or
323: (p_rating_of_record_per_starts is not null and
324: months_between(p_effective_date,l_start_date ) > 60)) then
325: hr_utility.set_message(8301, 'GHR_37857_ALL_PROCEDURE_FAIL');
326: hr_utility.raise_error;
327: end if;*/
328:
329:
330: end chk_rating_of_rec;

Line 365: hr_utility.set_message(8301, 'GHR_37908_ALL_PROCEDURE_FAIL');

361: p_position_occupied_code <> '2'
362: and
363: p_position_occupied_code is not null
364: then
365: hr_utility.set_message(8301, 'GHR_37908_ALL_PROCEDURE_FAIL');
366: hr_utility.raise_error;
367: end if;
368: else
369: if (

Line 366: hr_utility.raise_error;

362: and
363: p_position_occupied_code is not null
364: then
365: hr_utility.set_message(8301, 'GHR_37908_ALL_PROCEDURE_FAIL');
366: hr_utility.raise_error;
367: end if;
368: else
369: if (
370: p_to_pay_plan in ('CZ','ED','EE','EF','EG','EH','EI',

Line 382: hr_utility.set_message(8301, 'GHR_37506_ALL_PROCEDURE_FAIL');

378: p_position_occupied_code <> '2'
379: and
380: p_position_occupied_code is not null
381: then
382: hr_utility.set_message(8301, 'GHR_37506_ALL_PROCEDURE_FAIL');
383: hr_utility.raise_error;
384: end if;
385: end if;
386:

Line 383: hr_utility.raise_error;

379: and
380: p_position_occupied_code is not null
381: then
382: hr_utility.set_message(8301, 'GHR_37506_ALL_PROCEDURE_FAIL');
383: hr_utility.raise_error;
384: end if;
385: end if;
386:
387: -- 500.04.3

Line 393: hr_utility.set_message(8301, 'GHR_37507_ALL_PROCEDURE_FAIL');

389: p_position_occupied_code not in ('3','4')
390: and
391: p_position_occupied_code is not null
392: then
393: hr_utility.set_message(8301, 'GHR_37507_ALL_PROCEDURE_FAIL');
394: hr_utility.raise_error;
395: end if;
396:
397: -- 500.07.2

Line 394: hr_utility.raise_error;

390: and
391: p_position_occupied_code is not null
392: then
393: hr_utility.set_message(8301, 'GHR_37507_ALL_PROCEDURE_FAIL');
394: hr_utility.raise_error;
395: end if;
396:
397: -- 500.07.2
398: if (

Line 411: hr_utility.set_message(8301, 'GHR_37508_ALL_PROCEDURE_FAIL');

407: p_to_pay_plan <>'ES'
408: and
409: p_position_occupied_code is not null
410: then
411: hr_utility.set_message(8301, 'GHR_37508_ALL_PROCEDURE_FAIL');
412: hr_utility.raise_error;
413: end if;
414:
415: --UPDATED_BY DATE COMMENTS

Line 412: hr_utility.raise_error;

408: and
409: p_position_occupied_code is not null
410: then
411: hr_utility.set_message(8301, 'GHR_37508_ALL_PROCEDURE_FAIL');
412: hr_utility.raise_error;
413: end if;
414:
415: --UPDATED_BY DATE COMMENTS
416: ------------------------------------------------------------

Line 425: hr_utility.set_message(8301, 'GHR_37509_ALL_PROCEDURE_FAIL');

421: '120','122','124','140','141','500',
422: '501','507','508','515','520',
423: '522','524','540','541') and
424: p_position_occupied_code <> '1' then
425: hr_utility.set_message(8301, 'GHR_37509_ALL_PROCEDURE_FAIL');
426: hr_utility.raise_error;
427: end if;
428:
429: --UPDATED_BY DATE COMMENTS

Line 426: hr_utility.raise_error;

422: '501','507','508','515','520',
423: '522','524','540','541') and
424: p_position_occupied_code <> '1' then
425: hr_utility.set_message(8301, 'GHR_37509_ALL_PROCEDURE_FAIL');
426: hr_utility.raise_error;
427: end if;
428:
429: --UPDATED_BY DATE COMMENTS
430: ------------------------------------------------------------

Line 444: hr_utility.set_message(8301, 'GHR_37510_ALL_PROCEDURE_FAIL');

440: p_position_occupied_code <>'2'
441: and
442: p_position_occupied_code is not null
443: then
444: hr_utility.set_message(8301, 'GHR_37510_ALL_PROCEDURE_FAIL');
445: hr_utility.raise_error;
446: end if;
447: else
448: if p_first_noac_lookup_code in ('170','171','550','551',

Line 445: hr_utility.raise_error;

441: and
442: p_position_occupied_code is not null
443: then
444: hr_utility.set_message(8301, 'GHR_37510_ALL_PROCEDURE_FAIL');
445: hr_utility.raise_error;
446: end if;
447: else
448: if p_first_noac_lookup_code in ('170','171','550','551',
449: '553','554','555','570','571')

Line 455: hr_utility.set_message(8301, 'GHR_37693_ALL_PROCEDURE_FAIL');

451: p_position_occupied_code <>'2'
452: and
453: p_position_occupied_code is not null
454: then
455: hr_utility.set_message(8301, 'GHR_37693_ALL_PROCEDURE_FAIL');
456: hr_utility.raise_error;
457: end if;
458: end if;
459:

Line 456: hr_utility.raise_error;

452: and
453: p_position_occupied_code is not null
454: then
455: hr_utility.set_message(8301, 'GHR_37693_ALL_PROCEDURE_FAIL');
456: hr_utility.raise_error;
457: end if;
458: end if;
459:
460: end chk_position_occupied;

Line 494: hr_utility.set_message(8301, 'GHR_37511_ALL_PROCEDURE_FAIL');

490: p_occupation_code is not null and
491: p_first_noac_lookup_code not in ('702','703','713','721','740','741','800','850','855') and
492: substr(p_first_noac_lookup_code,1,1) <> 5
493: then
494: hr_utility.set_message(8301, 'GHR_37511_ALL_PROCEDURE_FAIL');
495: hr_utility.raise_error;
496: end if;
497: else
498: if p_prior_occupation_code <> p_occupation_code and

Line 495: hr_utility.raise_error;

491: p_first_noac_lookup_code not in ('702','703','713','721','740','741','800','850','855') and
492: substr(p_first_noac_lookup_code,1,1) <> 5
493: then
494: hr_utility.set_message(8301, 'GHR_37511_ALL_PROCEDURE_FAIL');
495: hr_utility.raise_error;
496: end if;
497: else
498: if p_prior_occupation_code <> p_occupation_code and
499: p_prior_occupation_code is not null and

Line 505: hr_utility.set_message(8301, 'GHR_37163_ALL_PROCEDURE_FAIL');

501: p_first_noac_lookup_code not in
502: ('611','613','702','703','713','721','740','741','800','850','855','890') and
503: substr(p_first_noac_lookup_code,1,1) <> 5
504: then
505: hr_utility.set_message(8301, 'GHR_37163_ALL_PROCEDURE_FAIL');
506: hr_utility.raise_error;
507: end if;
508: end if;
509: --added for dual actions

Line 506: hr_utility.raise_error;

502: ('611','613','702','703','713','721','740','741','800','850','855','890') and
503: substr(p_first_noac_lookup_code,1,1) <> 5
504: then
505: hr_utility.set_message(8301, 'GHR_37163_ALL_PROCEDURE_FAIL');
506: hr_utility.raise_error;
507: end if;
508: end if;
509: --added for dual actions
510: elsif NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'Y' then

Line 521: hr_utility.set_message(8301, 'GHR_37511_ALL_PROCEDURE_FAIL');

517: NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in ('702','703','713','721','740','741','800','850','855') and
518: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> 5
519:
520: then
521: hr_utility.set_message(8301, 'GHR_37511_ALL_PROCEDURE_FAIL');
522: hr_utility.raise_error;
523: end if;
524: else
525: if p_prior_occupation_code <> p_occupation_code and

Line 522: hr_utility.raise_error;

518: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> 5
519:
520: then
521: hr_utility.set_message(8301, 'GHR_37511_ALL_PROCEDURE_FAIL');
522: hr_utility.raise_error;
523: end if;
524: else
525: if p_prior_occupation_code <> p_occupation_code and
526: p_prior_occupation_code is not null and

Line 535: hr_utility.set_message(8301, 'GHR_37163_ALL_PROCEDURE_FAIL');

531: NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in
532: ('611','613','702','703','713','721','740','741','800','850','855','890') and
533: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> 5
534: then
535: hr_utility.set_message(8301, 'GHR_37163_ALL_PROCEDURE_FAIL');
536: hr_utility.raise_error;
537: end if;
538: end if;
539: end if;

Line 536: hr_utility.raise_error;

532: ('611','613','702','703','713','721','740','741','800','850','855','890') and
533: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> 5
534: then
535: hr_utility.set_message(8301, 'GHR_37163_ALL_PROCEDURE_FAIL');
536: hr_utility.raise_error;
537: end if;
538: end if;
539: end if;
540: end if;

Line 549: hr_utility.set_message(8301, 'GHR_37512_ALL_PROCEDURE_FAIL');

545: if ( (p_prior_pay_plan ='LG' or p_prior_pay_plan ='ST') or
546: substr(p_prior_pay_plan,1,1)='G' ) and
547: to_number(p_prior_occupation_code) >= 2500 and
548: p_prior_occupation_code is not null then
549: hr_utility.set_message(8301, 'GHR_37512_ALL_PROCEDURE_FAIL');
550: hr_utility.set_message_token('PAY_PLAN','G-, LG, or ST');
551: hr_utility.raise_error;
552: end if;
553: ELSE

Line 550: hr_utility.set_message_token('PAY_PLAN','G-, LG, or ST');

546: substr(p_prior_pay_plan,1,1)='G' ) and
547: to_number(p_prior_occupation_code) >= 2500 and
548: p_prior_occupation_code is not null then
549: hr_utility.set_message(8301, 'GHR_37512_ALL_PROCEDURE_FAIL');
550: hr_utility.set_message_token('PAY_PLAN','G-, LG, or ST');
551: hr_utility.raise_error;
552: end if;
553: ELSE
554: if ( (p_prior_pay_plan ='ST') or

Line 551: hr_utility.raise_error;

547: to_number(p_prior_occupation_code) >= 2500 and
548: p_prior_occupation_code is not null then
549: hr_utility.set_message(8301, 'GHR_37512_ALL_PROCEDURE_FAIL');
550: hr_utility.set_message_token('PAY_PLAN','G-, LG, or ST');
551: hr_utility.raise_error;
552: end if;
553: ELSE
554: if ( (p_prior_pay_plan ='ST') or
555: substr(p_prior_pay_plan,1,1)='G' ) and

Line 558: hr_utility.set_message(8301, 'GHR_37512_ALL_PROCEDURE_FAIL');

554: if ( (p_prior_pay_plan ='ST') or
555: substr(p_prior_pay_plan,1,1)='G' ) and
556: to_number(p_prior_occupation_code) >= 2500 and
557: p_prior_occupation_code is not null then
558: hr_utility.set_message(8301, 'GHR_37512_ALL_PROCEDURE_FAIL');
559: hr_utility.set_message_token('PAY_PLAN','G-, or ST');
560: hr_utility.raise_error;
561: end if;
562: END IF;

Line 559: hr_utility.set_message_token('PAY_PLAN','G-, or ST');

555: substr(p_prior_pay_plan,1,1)='G' ) and
556: to_number(p_prior_occupation_code) >= 2500 and
557: p_prior_occupation_code is not null then
558: hr_utility.set_message(8301, 'GHR_37512_ALL_PROCEDURE_FAIL');
559: hr_utility.set_message_token('PAY_PLAN','G-, or ST');
560: hr_utility.raise_error;
561: end if;
562: END IF;
563:

Line 560: hr_utility.raise_error;

556: to_number(p_prior_occupation_code) >= 2500 and
557: p_prior_occupation_code is not null then
558: hr_utility.set_message(8301, 'GHR_37512_ALL_PROCEDURE_FAIL');
559: hr_utility.set_message_token('PAY_PLAN','G-, or ST');
560: hr_utility.raise_error;
561: end if;
562: END IF;
563:
564: -- 520.07.2

Line 570: hr_utility.set_message(8301, 'GHR_37513_ALL_PROCEDURE_FAIL');

566: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
567: if substr(p_prior_pay_plan,1,1) in ('K','W','X') and
568: to_number(p_prior_occupation_code) <= 2499 and
569: p_prior_occupation_code is not null then
570: hr_utility.set_message(8301, 'GHR_37513_ALL_PROCEDURE_FAIL');
571: hr_utility.set_message_token('PAY_PLAN','K-, W-, or X-');
572: hr_utility.raise_error;
573: end if;
574: ELSE

Line 571: hr_utility.set_message_token('PAY_PLAN','K-, W-, or X-');

567: if substr(p_prior_pay_plan,1,1) in ('K','W','X') and
568: to_number(p_prior_occupation_code) <= 2499 and
569: p_prior_occupation_code is not null then
570: hr_utility.set_message(8301, 'GHR_37513_ALL_PROCEDURE_FAIL');
571: hr_utility.set_message_token('PAY_PLAN','K-, W-, or X-');
572: hr_utility.raise_error;
573: end if;
574: ELSE
575: if substr(p_prior_pay_plan,1,1) in ('W') and

Line 572: hr_utility.raise_error;

568: to_number(p_prior_occupation_code) <= 2499 and
569: p_prior_occupation_code is not null then
570: hr_utility.set_message(8301, 'GHR_37513_ALL_PROCEDURE_FAIL');
571: hr_utility.set_message_token('PAY_PLAN','K-, W-, or X-');
572: hr_utility.raise_error;
573: end if;
574: ELSE
575: if substr(p_prior_pay_plan,1,1) in ('W') and
576: to_number(p_prior_occupation_code) <= 2499 and

Line 578: hr_utility.set_message(8301, 'GHR_37513_ALL_PROCEDURE_FAIL');

574: ELSE
575: if substr(p_prior_pay_plan,1,1) in ('W') and
576: to_number(p_prior_occupation_code) <= 2499 and
577: p_prior_occupation_code is not null then
578: hr_utility.set_message(8301, 'GHR_37513_ALL_PROCEDURE_FAIL');
579: hr_utility.set_message_token('PAY_PLAN','W-');
580: hr_utility.raise_error;
581: end if;
582: END IF;

Line 579: hr_utility.set_message_token('PAY_PLAN','W-');

575: if substr(p_prior_pay_plan,1,1) in ('W') and
576: to_number(p_prior_occupation_code) <= 2499 and
577: p_prior_occupation_code is not null then
578: hr_utility.set_message(8301, 'GHR_37513_ALL_PROCEDURE_FAIL');
579: hr_utility.set_message_token('PAY_PLAN','W-');
580: hr_utility.raise_error;
581: end if;
582: END IF;
583:

Line 580: hr_utility.raise_error;

576: to_number(p_prior_occupation_code) <= 2499 and
577: p_prior_occupation_code is not null then
578: hr_utility.set_message(8301, 'GHR_37513_ALL_PROCEDURE_FAIL');
579: hr_utility.set_message_token('PAY_PLAN','W-');
580: hr_utility.raise_error;
581: end if;
582: END IF;
583:
584: -- 520.13.2

Line 587: hr_utility.set_message(8301, 'GHR_37514_ALL_PROCEDURE_FAIL');

583:
584: -- 520.13.2
585: if p_prior_occupation_code = '0605' and
586: substr(p_agency_subelement, 1, 2) <> 'VA' then
587: hr_utility.set_message(8301, 'GHR_37514_ALL_PROCEDURE_FAIL');
588: hr_utility.raise_error;
589: end if;
590:
591: -- 520.16.2

Line 588: hr_utility.raise_error;

584: -- 520.13.2
585: if p_prior_occupation_code = '0605' and
586: substr(p_agency_subelement, 1, 2) <> 'VA' then
587: hr_utility.set_message(8301, 'GHR_37514_ALL_PROCEDURE_FAIL');
588: hr_utility.raise_error;
589: end if;
590:
591: -- 520.16.2
592: -- 28-Nov-2002 Madhuri Commented the edit.

Line 595: hr_utility.set_message(8301, 'GHR_37515_ALL_PROCEDURE_FAIL');

591: -- 520.16.2
592: -- 28-Nov-2002 Madhuri Commented the edit.
593: /* if p_prior_occupation_code = '0805' and
594: substr(p_agency_subelement, 1, 2) not in ('AF','AR','DD','NV') then
595: hr_utility.set_message(8301, 'GHR_37515_ALL_PROCEDURE_FAIL');
596: hr_utility.raise_error;
597: end if;*/
598:
599: -- 520.19.2

Line 596: hr_utility.raise_error;

592: -- 28-Nov-2002 Madhuri Commented the edit.
593: /* if p_prior_occupation_code = '0805' and
594: substr(p_agency_subelement, 1, 2) not in ('AF','AR','DD','NV') then
595: hr_utility.set_message(8301, 'GHR_37515_ALL_PROCEDURE_FAIL');
596: hr_utility.raise_error;
597: end if;*/
598:
599: -- 520.19.2
600: -- removed 2806, 2808 as per update 7 on 16-jul-98

Line 606: hr_utility.set_message(8301, 'GHR_37516_ALL_PROCEDURE_FAIL');

602:
603: if p_effective_date <= to_date('2001/07/31','yyyy/mm/dd') then
604: if p_prior_occupation_code in ('2619','2843') and
605: substr(p_agency_subelement, 1, 2) <> 'DN' then
606: hr_utility.set_message(8301, 'GHR_37516_ALL_PROCEDURE_FAIL');
607: hr_utility.raise_error;
608: end if;
609: end if;
610:

Line 607: hr_utility.raise_error;

603: if p_effective_date <= to_date('2001/07/31','yyyy/mm/dd') then
604: if p_prior_occupation_code in ('2619','2843') and
605: substr(p_agency_subelement, 1, 2) <> 'DN' then
606: hr_utility.set_message(8301, 'GHR_37516_ALL_PROCEDURE_FAIL');
607: hr_utility.raise_error;
608: end if;
609: end if;
610:
611: --520.20.2

Line 621: hr_utility.set_message(8301, 'GHR_37873_ALL_PROCEDURE_FAIL');

617: if p_effective_date <= to_date('2001/07/31','yyyy/mm/dd') and
618: p_effective_date >= to_date('1998/03/01','yyyy/mm/dd') then
619: if p_prior_occupation_code in ('2806','2808') and
620: substr(p_agency_subelement, 1, 2) NOT IN ('DN', 'IN') then
621: hr_utility.set_message(8301, 'GHR_37873_ALL_PROCEDURE_FAIL');
622: hr_utility.raise_error;
623: end if;
624: end if;
625:

Line 622: hr_utility.raise_error;

618: p_effective_date >= to_date('1998/03/01','yyyy/mm/dd') then
619: if p_prior_occupation_code in ('2806','2808') and
620: substr(p_agency_subelement, 1, 2) NOT IN ('DN', 'IN') then
621: hr_utility.set_message(8301, 'GHR_37873_ALL_PROCEDURE_FAIL');
622: hr_utility.raise_error;
623: end if;
624: end if;
625:
626: end chk_prior_occupation;

Line 662: hr_utility.set_message(8301, 'GHR_37517_ALL_PROCEDURE_FAIL');

658: p_prior_pay_basis <> 'PA'
659: and
660: p_prior_pay_basis is not null
661: then
662: hr_utility.set_message(8301, 'GHR_37517_ALL_PROCEDURE_FAIL');
663: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
664: hr_utility.raise_error;
665: end if;
666:

Line 663: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');

659: and
660: p_prior_pay_basis is not null
661: then
662: hr_utility.set_message(8301, 'GHR_37517_ALL_PROCEDURE_FAIL');
663: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
664: hr_utility.raise_error;
665: end if;
666:
667: if p_prior_pay_plan = 'KA'

Line 664: hr_utility.raise_error;

660: p_prior_pay_basis is not null
661: then
662: hr_utility.set_message(8301, 'GHR_37517_ALL_PROCEDURE_FAIL');
663: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
664: hr_utility.raise_error;
665: end if;
666:
667: if p_prior_pay_plan = 'KA'
668: and

Line 671: hr_utility.set_message(8301, 'GHR_37580_ALL_PROCEDURE_FAIL');

667: if p_prior_pay_plan = 'KA'
668: and
669: (p_prior_pay_basis <>'PA' and p_prior_pay_basis <>'PH')
670: then
671: hr_utility.set_message(8301, 'GHR_37580_ALL_PROCEDURE_FAIL');
672: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
673: hr_utility.raise_error;
674: end if;
675:

Line 672: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');

668: and
669: (p_prior_pay_basis <>'PA' and p_prior_pay_basis <>'PH')
670: then
671: hr_utility.set_message(8301, 'GHR_37580_ALL_PROCEDURE_FAIL');
672: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
673: hr_utility.raise_error;
674: end if;
675:
676: if substr(p_prior_pay_plan,1,1) = 'X' and

Line 673: hr_utility.raise_error;

669: (p_prior_pay_basis <>'PA' and p_prior_pay_basis <>'PH')
670: then
671: hr_utility.set_message(8301, 'GHR_37580_ALL_PROCEDURE_FAIL');
672: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
673: hr_utility.raise_error;
674: end if;
675:
676: if substr(p_prior_pay_plan,1,1) = 'X' and
677: p_prior_pay_basis<>'PH'then

Line 678: hr_utility.set_message(8301, 'GHR_37582_ALL_PROCEDURE_FAIL');

674: end if;
675:
676: if substr(p_prior_pay_plan,1,1) = 'X' and
677: p_prior_pay_basis<>'PH'then
678: hr_utility.set_message(8301, 'GHR_37582_ALL_PROCEDURE_FAIL');
679: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
680: hr_utility.raise_error;
681: end if;
682:

Line 679: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');

675:
676: if substr(p_prior_pay_plan,1,1) = 'X' and
677: p_prior_pay_basis<>'PH'then
678: hr_utility.set_message(8301, 'GHR_37582_ALL_PROCEDURE_FAIL');
679: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
680: hr_utility.raise_error;
681: end if;
682:
683: if p_prior_pay_plan = 'ZZ' and p_prior_pay_basis <>'WC' then

Line 680: hr_utility.raise_error;

676: if substr(p_prior_pay_plan,1,1) = 'X' and
677: p_prior_pay_basis<>'PH'then
678: hr_utility.set_message(8301, 'GHR_37582_ALL_PROCEDURE_FAIL');
679: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
680: hr_utility.raise_error;
681: end if;
682:
683: if p_prior_pay_plan = 'ZZ' and p_prior_pay_basis <>'WC' then
684: hr_utility.set_message(8301, 'GHR_37583_ALL_PROCEDURE_FAIL');

Line 684: hr_utility.set_message(8301, 'GHR_37583_ALL_PROCEDURE_FAIL');

680: hr_utility.raise_error;
681: end if;
682:
683: if p_prior_pay_plan = 'ZZ' and p_prior_pay_basis <>'WC' then
684: hr_utility.set_message(8301, 'GHR_37583_ALL_PROCEDURE_FAIL');
685: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
686: hr_utility.raise_error;
687: end if;
688: end if;

Line 685: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');

681: end if;
682:
683: if p_prior_pay_plan = 'ZZ' and p_prior_pay_basis <>'WC' then
684: hr_utility.set_message(8301, 'GHR_37583_ALL_PROCEDURE_FAIL');
685: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
686: hr_utility.raise_error;
687: end if;
688: end if;
689:

Line 686: hr_utility.raise_error;

682:
683: if p_prior_pay_plan = 'ZZ' and p_prior_pay_basis <>'WC' then
684: hr_utility.set_message(8301, 'GHR_37583_ALL_PROCEDURE_FAIL');
685: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
686: hr_utility.raise_error;
687: end if;
688: end if;
689:
690: elsif p_effective_date >= to_date('2005/05/01','yyyy/mm/dd') THEN

Line 696: hr_utility.set_message(8301, 'GHR_37517_ALL_PROCEDURE_FAIL');

692: if p_prior_pay_plan in ('AL','CA','ES','EX','GG','GH','GM','GS','SL') and
693: p_prior_pay_basis <> 'PA' and
694: p_prior_pay_basis is not null
695: then
696: hr_utility.set_message(8301, 'GHR_37517_ALL_PROCEDURE_FAIL');
697: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
698: hr_utility.raise_error;
699: end if;
700:

Line 697: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');

693: p_prior_pay_basis <> 'PA' and
694: p_prior_pay_basis is not null
695: then
696: hr_utility.set_message(8301, 'GHR_37517_ALL_PROCEDURE_FAIL');
697: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
698: hr_utility.raise_error;
699: end if;
700:
701: if p_prior_pay_plan = 'KA' and

Line 698: hr_utility.raise_error;

694: p_prior_pay_basis is not null
695: then
696: hr_utility.set_message(8301, 'GHR_37517_ALL_PROCEDURE_FAIL');
697: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
698: hr_utility.raise_error;
699: end if;
700:
701: if p_prior_pay_plan = 'KA' and
702: (p_prior_pay_basis <>'PA' and p_prior_pay_basis <>'PH')

Line 704: hr_utility.set_message(8301, 'GHR_37580_ALL_PROCEDURE_FAIL');

700:
701: if p_prior_pay_plan = 'KA' and
702: (p_prior_pay_basis <>'PA' and p_prior_pay_basis <>'PH')
703: then
704: hr_utility.set_message(8301, 'GHR_37580_ALL_PROCEDURE_FAIL');
705: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
706: hr_utility.raise_error;
707: end if;
708:

Line 705: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');

701: if p_prior_pay_plan = 'KA' and
702: (p_prior_pay_basis <>'PA' and p_prior_pay_basis <>'PH')
703: then
704: hr_utility.set_message(8301, 'GHR_37580_ALL_PROCEDURE_FAIL');
705: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
706: hr_utility.raise_error;
707: end if;
708:
709: if substr(p_prior_pay_plan,1,1) = 'X' and

Line 706: hr_utility.raise_error;

702: (p_prior_pay_basis <>'PA' and p_prior_pay_basis <>'PH')
703: then
704: hr_utility.set_message(8301, 'GHR_37580_ALL_PROCEDURE_FAIL');
705: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
706: hr_utility.raise_error;
707: end if;
708:
709: if substr(p_prior_pay_plan,1,1) = 'X' and
710: p_prior_pay_basis<>'PH'then

Line 711: hr_utility.set_message(8301, 'GHR_37582_ALL_PROCEDURE_FAIL');

707: end if;
708:
709: if substr(p_prior_pay_plan,1,1) = 'X' and
710: p_prior_pay_basis<>'PH'then
711: hr_utility.set_message(8301, 'GHR_37582_ALL_PROCEDURE_FAIL');
712: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
713: hr_utility.raise_error;
714: end if;
715:

Line 712: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');

708:
709: if substr(p_prior_pay_plan,1,1) = 'X' and
710: p_prior_pay_basis<>'PH'then
711: hr_utility.set_message(8301, 'GHR_37582_ALL_PROCEDURE_FAIL');
712: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
713: hr_utility.raise_error;
714: end if;
715:
716: if p_prior_pay_plan = 'ZZ' and p_prior_pay_basis <>'WC' then

Line 713: hr_utility.raise_error;

709: if substr(p_prior_pay_plan,1,1) = 'X' and
710: p_prior_pay_basis<>'PH'then
711: hr_utility.set_message(8301, 'GHR_37582_ALL_PROCEDURE_FAIL');
712: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
713: hr_utility.raise_error;
714: end if;
715:
716: if p_prior_pay_plan = 'ZZ' and p_prior_pay_basis <>'WC' then
717: hr_utility.set_message(8301, 'GHR_37583_ALL_PROCEDURE_FAIL');

Line 717: hr_utility.set_message(8301, 'GHR_37583_ALL_PROCEDURE_FAIL');

713: hr_utility.raise_error;
714: end if;
715:
716: if p_prior_pay_plan = 'ZZ' and p_prior_pay_basis <>'WC' then
717: hr_utility.set_message(8301, 'GHR_37583_ALL_PROCEDURE_FAIL');
718: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
719: hr_utility.raise_error;
720: end if;
721: end if;

Line 718: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');

714: end if;
715:
716: if p_prior_pay_plan = 'ZZ' and p_prior_pay_basis <>'WC' then
717: hr_utility.set_message(8301, 'GHR_37583_ALL_PROCEDURE_FAIL');
718: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
719: hr_utility.raise_error;
720: end if;
721: end if;
722: end if;

Line 719: hr_utility.raise_error;

715:
716: if p_prior_pay_plan = 'ZZ' and p_prior_pay_basis <>'WC' then
717: hr_utility.set_message(8301, 'GHR_37583_ALL_PROCEDURE_FAIL');
718: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
719: hr_utility.raise_error;
720: end if;
721: end if;
722: end if;
723: /*530.10.2 If prior pay basis is PD,

Line 739: hr_utility.set_message(8301, 'GHR_37519_ALL_PROCEDURE_FAIL');

735: if p_prior_pay_basis = 'PD' and
736: (substr(p_agency_subelement,1,2) in ('CU','FD','FL','FY') or
737: p_agency_subelement in ('TRAJ','TR35')) and
738: to_number(p_prior_basic_pay) > max_per_diem then
739: hr_utility.set_message(8301, 'GHR_37519_ALL_PROCEDURE_FAIL');
740: hr_utility.raise_error;
741: end if; */
742: --
743: --

Line 740: hr_utility.raise_error;

736: (substr(p_agency_subelement,1,2) in ('CU','FD','FL','FY') or
737: p_agency_subelement in ('TRAJ','TR35')) and
738: to_number(p_prior_basic_pay) > max_per_diem then
739: hr_utility.set_message(8301, 'GHR_37519_ALL_PROCEDURE_FAIL');
740: hr_utility.raise_error;
741: end if; */
742: --
743: --
744: /*530.07.2 If prior pay basis is PA, PH, PM, BW, or WC,

Line 776: hr_utility.set_message(8301, 'GHR_37518_ALL_PROCEDURE_FAIL');

772: (p_prior_pay_basis ='PM' and to_number(p_prior_basic_pay)> max_basic_pay ) or
773: (p_prior_pay_basis ='BW' and to_number(p_prior_basic_pay)> max_basic_pay ) or
774: (p_prior_pay_basis ='WC' and to_number(p_prior_basic_pay)> max_basic_pay )
775: then
776: hr_utility.set_message(8301, 'GHR_37518_ALL_PROCEDURE_FAIL');
777: hr_utility.raise_error;
778: END IF;
779: END IF;
780: --Begin Bug 11726461

Line 777: hr_utility.raise_error;

773: (p_prior_pay_basis ='BW' and to_number(p_prior_basic_pay)> max_basic_pay ) or
774: (p_prior_pay_basis ='WC' and to_number(p_prior_basic_pay)> max_basic_pay )
775: then
776: hr_utility.set_message(8301, 'GHR_37518_ALL_PROCEDURE_FAIL');
777: hr_utility.raise_error;
778: END IF;
779: END IF;
780: --Begin Bug 11726461
781: ELSIF p_effective_date < fnd_date.canonical_to_date('2011/02/01') then-- if after 11th Jan 2004

Line 797: hr_utility.set_location('Inside FW pay plan ',45);

793: p_prior_effective_date);
794:
795: l_prior_basic_pay := p_prior_basic_pay;
796: for pay_plan_rec in c_fw_pay_plans(p_prior_pay_plan) loop
797: hr_utility.set_location('Inside FW pay plan ',45);
798: IF p_prior_pay_basis = 'PH' THEN
799: hr_utility.set_location('Inside PH',50);
800: l_prior_basic_pay := to_char(to_number(p_prior_basic_pay)/2087);
801: END IF;

Line 799: hr_utility.set_location('Inside PH',50);

795: l_prior_basic_pay := p_prior_basic_pay;
796: for pay_plan_rec in c_fw_pay_plans(p_prior_pay_plan) loop
797: hr_utility.set_location('Inside FW pay plan ',45);
798: IF p_prior_pay_basis = 'PH' THEN
799: hr_utility.set_location('Inside PH',50);
800: l_prior_basic_pay := to_char(to_number(p_prior_basic_pay)/2087);
801: END IF;
802: end loop;
803:

Line 811: hr_utility.set_message(8301, 'GHR_38918_ALL_PROCEDURE_FAIL');

807: (p_prior_pay_basis ='PD' and NOT (to_number(l_prior_basic_pay) BETWEEN min_basic_pay AND max_basic_pay )) or
808: (p_prior_pay_basis ='BW' and NOT (to_number(l_prior_basic_pay) BETWEEN min_basic_pay AND max_basic_pay)) or
809: (p_prior_pay_basis ='WC' and NOT (to_number(l_prior_basic_pay) BETWEEN min_basic_pay AND max_basic_pay ))
810: THEN
811: hr_utility.set_message(8301, 'GHR_38918_ALL_PROCEDURE_FAIL');
812: hr_utility.set_message_token('PAY_BASIS','BW, PA, PD, PH, or WC');
813: hr_utility.raise_error;
814: END IF;
815: END IF;

Line 812: hr_utility.set_message_token('PAY_BASIS','BW, PA, PD, PH, or WC');

808: (p_prior_pay_basis ='BW' and NOT (to_number(l_prior_basic_pay) BETWEEN min_basic_pay AND max_basic_pay)) or
809: (p_prior_pay_basis ='WC' and NOT (to_number(l_prior_basic_pay) BETWEEN min_basic_pay AND max_basic_pay ))
810: THEN
811: hr_utility.set_message(8301, 'GHR_38918_ALL_PROCEDURE_FAIL');
812: hr_utility.set_message_token('PAY_BASIS','BW, PA, PD, PH, or WC');
813: hr_utility.raise_error;
814: END IF;
815: END IF;
816: --Begin Bug 11726461

Line 813: hr_utility.raise_error;

809: (p_prior_pay_basis ='WC' and NOT (to_number(l_prior_basic_pay) BETWEEN min_basic_pay AND max_basic_pay ))
810: THEN
811: hr_utility.set_message(8301, 'GHR_38918_ALL_PROCEDURE_FAIL');
812: hr_utility.set_message_token('PAY_BASIS','BW, PA, PD, PH, or WC');
813: hr_utility.raise_error;
814: END IF;
815: END IF;
816: --Begin Bug 11726461
817: ELSE -- if after 1st Feb 2011

Line 830: hr_utility.set_location('Inside FW pay plan ',45);

826: p_prior_effective_date);
827:
828: l_prior_basic_pay := p_prior_basic_pay;
829: for pay_plan_rec in c_fw_pay_plans(p_prior_pay_plan) loop
830: hr_utility.set_location('Inside FW pay plan ',45);
831: IF p_prior_pay_basis = 'PH' THEN
832: hr_utility.set_location('Inside PH',50);
833: l_prior_basic_pay := to_char(to_number(p_prior_basic_pay)/2087);
834: END IF;

Line 832: hr_utility.set_location('Inside PH',50);

828: l_prior_basic_pay := p_prior_basic_pay;
829: for pay_plan_rec in c_fw_pay_plans(p_prior_pay_plan) loop
830: hr_utility.set_location('Inside FW pay plan ',45);
831: IF p_prior_pay_basis = 'PH' THEN
832: hr_utility.set_location('Inside PH',50);
833: l_prior_basic_pay := to_char(to_number(p_prior_basic_pay)/2087);
834: END IF;
835: end loop;
836:

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

841: (p_prior_pay_basis ='PM' and NOT (to_number(l_prior_basic_pay) BETWEEN min_basic_pay AND max_basic_pay )) or
842: (p_prior_pay_basis ='BW' and NOT (to_number(l_prior_basic_pay) BETWEEN min_basic_pay AND max_basic_pay)) or
843: (p_prior_pay_basis ='WC' and NOT (to_number(l_prior_basic_pay) BETWEEN min_basic_pay AND max_basic_pay ))
844: THEN
845: hr_utility.set_message(8301, 'GHR_38918_ALL_PROCEDURE_FAIL');
846: hr_utility.set_message_token('PAY_BASIS','BW, PA, PD, PH, PM, or WC');
847: hr_utility.raise_error;
848: END IF;
849: END IF;

Line 846: hr_utility.set_message_token('PAY_BASIS','BW, PA, PD, PH, PM, or WC');

842: (p_prior_pay_basis ='BW' and NOT (to_number(l_prior_basic_pay) BETWEEN min_basic_pay AND max_basic_pay)) or
843: (p_prior_pay_basis ='WC' and NOT (to_number(l_prior_basic_pay) BETWEEN min_basic_pay AND max_basic_pay ))
844: THEN
845: hr_utility.set_message(8301, 'GHR_38918_ALL_PROCEDURE_FAIL');
846: hr_utility.set_message_token('PAY_BASIS','BW, PA, PD, PH, PM, or WC');
847: hr_utility.raise_error;
848: END IF;
849: END IF;
850:

Line 847: hr_utility.raise_error;

843: (p_prior_pay_basis ='WC' and NOT (to_number(l_prior_basic_pay) BETWEEN min_basic_pay AND max_basic_pay ))
844: THEN
845: hr_utility.set_message(8301, 'GHR_38918_ALL_PROCEDURE_FAIL');
846: hr_utility.set_message_token('PAY_BASIS','BW, PA, PD, PH, PM, or WC');
847: hr_utility.raise_error;
848: END IF;
849: END IF;
850:
851: --End Bug 11726461

Line 873: hr_utility.set_message(8301, 'GHR_37520_ALL_PROCEDURE_FAIL');

869: /* if p_prior_pay_basis = 'PD' and
870: (substr(p_agency_subelement,1,2) in ('CU','FD','FL','FY') or
871: p_agency_subelement in ('TRAJ','TR35')) and
872: to_number(p_prior_basic_pay) > max_basic_pay then
873: hr_utility.set_message(8301, 'GHR_37520_ALL_PROCEDURE_FAIL');
874: hr_utility.raise_error;
875: end if;
876: end if;*/
877:

Line 874: hr_utility.raise_error;

870: (substr(p_agency_subelement,1,2) in ('CU','FD','FL','FY') or
871: p_agency_subelement in ('TRAJ','TR35')) and
872: to_number(p_prior_basic_pay) > max_basic_pay then
873: hr_utility.set_message(8301, 'GHR_37520_ALL_PROCEDURE_FAIL');
874: hr_utility.raise_error;
875: end if;
876: end if;*/
877:
878:

Line 909: hr_utility.set_message(8301, 'GHR_37521_ALL_PROCEDURE_FAIL');

905: p_grade_or_level is not null and
906: p_prior_grade is not null and
907: (p_first_noac_lookup_code not in ( '702','703','713','740','741') and
908: substr(p_first_noac_lookup_code,1,1) <> '5') then
909: hr_utility.set_message(8301, 'GHR_37521_ALL_PROCEDURE_FAIL');
910: hr_utility.raise_error;
911: end if;
912: --Modified for dual actions
913: elsif NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'Y' then

Line 910: hr_utility.raise_error;

906: p_prior_grade is not null and
907: (p_first_noac_lookup_code not in ( '702','703','713','740','741') and
908: substr(p_first_noac_lookup_code,1,1) <> '5') then
909: hr_utility.set_message(8301, 'GHR_37521_ALL_PROCEDURE_FAIL');
910: hr_utility.raise_error;
911: end if;
912: --Modified for dual actions
913: elsif NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'Y' then
914: if (p_to_pay_plan = 'GM' or p_to_pay_plan = 'GS') and

Line 923: hr_utility.set_message(8301, 'GHR_37521_ALL_PROCEDURE_FAIL');

919: (NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) not in ( '702','703','713','740','741') and
920: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> '5') and
921: (NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in ( '702','703','713','740','741') and
922: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> '5') then
923: hr_utility.set_message(8301, 'GHR_37521_ALL_PROCEDURE_FAIL');
924: hr_utility.raise_error;
925: end if;
926: end if;
927:

Line 924: hr_utility.raise_error;

920: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> '5') and
921: (NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in ( '702','703','713','740','741') and
922: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> '5') then
923: hr_utility.set_message(8301, 'GHR_37521_ALL_PROCEDURE_FAIL');
924: hr_utility.raise_error;
925: end if;
926: end if;
927:
928: -- 540.03.2

Line 936: hr_utility.set_message(8301, 'GHR_37522_ALL_PROCEDURE_FAIL');

932: p_prior_grade not between '01' and '15'
933: and
934: p_prior_grade is not null
935: then
936: hr_utility.set_message(8301, 'GHR_37522_ALL_PROCEDURE_FAIL');
937: hr_utility.raise_error;
938: end if;
939: end if;
940:

Line 937: hr_utility.raise_error;

933: and
934: p_prior_grade is not null
935: then
936: hr_utility.set_message(8301, 'GHR_37522_ALL_PROCEDURE_FAIL');
937: hr_utility.raise_error;
938: end if;
939: end if;
940:
941: -- 540.04.2

Line 944: hr_utility.set_message(8301, 'GHR_37523_ALL_PROCEDURE_FAIL');

940:
941: -- 540.04.2
942: if p_first_noac_lookup_code = '769' and
943: p_prior_grade <> p_grade_or_level then
944: hr_utility.set_message(8301, 'GHR_37523_ALL_PROCEDURE_FAIL');
945: hr_utility.raise_error;
946: end if;
947:
948: -- 540.05.2

Line 945: hr_utility.raise_error;

941: -- 540.04.2
942: if p_first_noac_lookup_code = '769' and
943: p_prior_grade <> p_grade_or_level then
944: hr_utility.set_message(8301, 'GHR_37523_ALL_PROCEDURE_FAIL');
945: hr_utility.raise_error;
946: end if;
947:
948: -- 540.05.2
949: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007

Line 956: hr_utility.set_message(8301, 'GHR_37524_ALL_PROCEDURE_FAIL');

952: p_prior_grade not between '13' and '15'
953: and
954: p_prior_grade is not null
955: then
956: hr_utility.set_message(8301, 'GHR_37524_ALL_PROCEDURE_FAIL');
957: hr_utility.raise_error;
958: end if;
959: end if;
960:

Line 957: hr_utility.raise_error;

953: and
954: p_prior_grade is not null
955: then
956: hr_utility.set_message(8301, 'GHR_37524_ALL_PROCEDURE_FAIL');
957: hr_utility.raise_error;
958: end if;
959: end if;
960:
961: -- 540.06.2

Line 972: hr_utility.set_message(8301, 'GHR_37185_ALL_PROCEDURE_FAIL');

968: p_prior_grade not between '01' and '08'
969: and
970: p_prior_grade is not null
971: then
972: hr_utility.set_message(8301, 'GHR_37185_ALL_PROCEDURE_FAIL');
973: hr_utility.raise_error;
974: end if;
975: end if;
976: end if;

Line 973: hr_utility.raise_error;

969: and
970: p_prior_grade is not null
971: then
972: hr_utility.set_message(8301, 'GHR_37185_ALL_PROCEDURE_FAIL');
973: hr_utility.raise_error;
974: end if;
975: end if;
976: end if;
977:

Line 986: hr_utility.set_message(8301, 'GHR_37525_ALL_PROCEDURE_FAIL');

982: if p_effective_date < fnd_date.canonical_to_date('2008/04/17') then
983: if p_prior_pay_plan in ( 'CG','MG','WL','XG' ) and
984: p_prior_grade not between '01' and '15'
985: and p_prior_grade is not null then
986: hr_utility.set_message(8301, 'GHR_37525_ALL_PROCEDURE_FAIL');
987: hr_utility.set_message_token('PAY_PLAN','CG,MG,WL or XG');
988: hr_utility.raise_error;
989: end if;
990: else

Line 987: hr_utility.set_message_token('PAY_PLAN','CG,MG,WL or XG');

983: if p_prior_pay_plan in ( 'CG','MG','WL','XG' ) and
984: p_prior_grade not between '01' and '15'
985: and p_prior_grade is not null then
986: hr_utility.set_message(8301, 'GHR_37525_ALL_PROCEDURE_FAIL');
987: hr_utility.set_message_token('PAY_PLAN','CG,MG,WL or XG');
988: hr_utility.raise_error;
989: end if;
990: else
991: if p_prior_pay_plan in ( 'CG','WL','XG' ) and

Line 988: hr_utility.raise_error;

984: p_prior_grade not between '01' and '15'
985: and p_prior_grade is not null then
986: hr_utility.set_message(8301, 'GHR_37525_ALL_PROCEDURE_FAIL');
987: hr_utility.set_message_token('PAY_PLAN','CG,MG,WL or XG');
988: hr_utility.raise_error;
989: end if;
990: else
991: if p_prior_pay_plan in ( 'CG','WL','XG' ) and
992: p_prior_grade not between '01' and '15'

Line 994: hr_utility.set_message(8301, 'GHR_37525_ALL_PROCEDURE_FAIL');

990: else
991: if p_prior_pay_plan in ( 'CG','WL','XG' ) and
992: p_prior_grade not between '01' and '15'
993: and p_prior_grade is not null then
994: hr_utility.set_message(8301, 'GHR_37525_ALL_PROCEDURE_FAIL');
995: hr_utility.set_message_token('PAY_PLAN','CG,WL or XG');
996: hr_utility.raise_error;
997: end if;
998: end if;

Line 995: hr_utility.set_message_token('PAY_PLAN','CG,WL or XG');

991: if p_prior_pay_plan in ( 'CG','WL','XG' ) and
992: p_prior_grade not between '01' and '15'
993: and p_prior_grade is not null then
994: hr_utility.set_message(8301, 'GHR_37525_ALL_PROCEDURE_FAIL');
995: hr_utility.set_message_token('PAY_PLAN','CG,WL or XG');
996: hr_utility.raise_error;
997: end if;
998: end if;
999:

Line 996: hr_utility.raise_error;

992: p_prior_grade not between '01' and '15'
993: and p_prior_grade is not null then
994: hr_utility.set_message(8301, 'GHR_37525_ALL_PROCEDURE_FAIL');
995: hr_utility.set_message_token('PAY_PLAN','CG,WL or XG');
996: hr_utility.raise_error;
997: end if;
998: end if;
999:
1000: -- 540.10.2

Line 1007: hr_utility.set_message(8301, 'GHR_37526_ALL_PROCEDURE_FAIL');

1003:
1004: and
1005: p_prior_grade is not null
1006: then
1007: hr_utility.set_message(8301, 'GHR_37526_ALL_PROCEDURE_FAIL');
1008: hr_utility.raise_error;
1009: end if;
1010:
1011: -- 540.13.2

Line 1008: hr_utility.raise_error;

1004: and
1005: p_prior_grade is not null
1006: then
1007: hr_utility.set_message(8301, 'GHR_37526_ALL_PROCEDURE_FAIL');
1008: hr_utility.raise_error;
1009: end if;
1010:
1011: -- 540.13.2
1012: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007

Line 1020: hr_utility.set_message(8301, 'GHR_37527_ALL_PROCEDURE_FAIL');

1016: p_prior_grade not in ( 'CA','CM','MC','NC','OC','01','02','03','04','13','14')
1017: and
1018: p_prior_grade is not null
1019: then
1020: hr_utility.set_message(8301, 'GHR_37527_ALL_PROCEDURE_FAIL');
1021: hr_utility.raise_error;
1022: end if;
1023: end if;
1024:

Line 1021: hr_utility.raise_error;

1017: and
1018: p_prior_grade is not null
1019: then
1020: hr_utility.set_message(8301, 'GHR_37527_ALL_PROCEDURE_FAIL');
1021: hr_utility.raise_error;
1022: end if;
1023: end if;
1024:
1025: -- 540.16.2

Line 1032: hr_utility.set_message(8301, 'GHR_37528_ALL_PROCEDURE_FAIL');

1028: if p_prior_pay_plan = 'CE' and
1029: p_prior_grade not between '01' and '17' and
1030: p_prior_grade is not null
1031: then
1032: hr_utility.set_message(8301, 'GHR_37528_ALL_PROCEDURE_FAIL');
1033: hr_utility.raise_error;
1034: end if;
1035: end if;
1036:

Line 1033: hr_utility.raise_error;

1029: p_prior_grade not between '01' and '17' and
1030: p_prior_grade is not null
1031: then
1032: hr_utility.set_message(8301, 'GHR_37528_ALL_PROCEDURE_FAIL');
1033: hr_utility.raise_error;
1034: end if;
1035: end if;
1036:
1037: -- 540.17.2

Line 1048: hr_utility.set_message(8301, 'GHR_37874_ALL_PROCEDURE_FAIL');

1044: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1045: if p_prior_pay_plan = 'CY' and
1046: p_prior_grade not between '01' and '24' and
1047: p_prior_grade is not null then
1048: hr_utility.set_message(8301, 'GHR_37874_ALL_PROCEDURE_FAIL');
1049: hr_utility.raise_error;
1050: end if;
1051: end if;
1052: end if;

Line 1049: hr_utility.raise_error;

1045: if p_prior_pay_plan = 'CY' and
1046: p_prior_grade not between '01' and '24' and
1047: p_prior_grade is not null then
1048: hr_utility.set_message(8301, 'GHR_37874_ALL_PROCEDURE_FAIL');
1049: hr_utility.raise_error;
1050: end if;
1051: end if;
1052: end if;
1053:

Line 1060: hr_utility.set_message(8301, 'GHR_37529_ALL_PROCEDURE_FAIL');

1056: p_prior_grade not between '01' and '03'
1057: and
1058: p_prior_grade is not null
1059: then
1060: hr_utility.set_message(8301, 'GHR_37529_ALL_PROCEDURE_FAIL');
1061: hr_utility.raise_error;
1062: end if;
1063:
1064: -- 540.19.2

Line 1061: hr_utility.raise_error;

1057: and
1058: p_prior_grade is not null
1059: then
1060: hr_utility.set_message(8301, 'GHR_37529_ALL_PROCEDURE_FAIL');
1061: hr_utility.raise_error;
1062: end if;
1063:
1064: -- 540.19.2
1065: if p_prior_pay_plan = 'GM' and

Line 1070: hr_utility.set_message(8301, 'GHR_37530_ALL_PROCEDURE_FAIL');

1066: p_prior_grade not between '13' and '15'
1067: and
1068: p_prior_grade is not null
1069: then
1070: hr_utility.set_message(8301, 'GHR_37530_ALL_PROCEDURE_FAIL');
1071: hr_utility.raise_error;
1072: end if;
1073:
1074: -- 540.20.2

Line 1071: hr_utility.raise_error;

1067: and
1068: p_prior_grade is not null
1069: then
1070: hr_utility.set_message(8301, 'GHR_37530_ALL_PROCEDURE_FAIL');
1071: hr_utility.raise_error;
1072: end if;
1073:
1074: -- 540.20.2
1075: if p_prior_pay_plan = 'GS' and

Line 1080: hr_utility.set_message(8301, 'GHR_37531_ALL_PROCEDURE_FAIL');

1076: p_prior_grade not between '01' and '15'
1077: and
1078: p_prior_grade is not null
1079: then
1080: hr_utility.set_message(8301, 'GHR_37531_ALL_PROCEDURE_FAIL');
1081: hr_utility.raise_error;
1082: end if;
1083:
1084: -- 540.22.2

Line 1081: hr_utility.raise_error;

1077: and
1078: p_prior_grade is not null
1079: then
1080: hr_utility.set_message(8301, 'GHR_37531_ALL_PROCEDURE_FAIL');
1081: hr_utility.raise_error;
1082: end if;
1083:
1084: -- 540.22.2
1085: -- Update/Change Date By Effective Date Comment

Line 1092: hr_utility.set_message(8301, 'GHR_37532_ALL_PROCEDURE_FAIL');

1088: if p_prior_pay_plan = 'VM' and
1089: p_prior_grade not in ('11','12','13','14','15','96','97') and
1090: p_prior_grade is not null
1091: then
1092: hr_utility.set_message(8301, 'GHR_37532_ALL_PROCEDURE_FAIL');
1093: hr_utility.raise_error;
1094: end if;
1095: END IF;
1096:

Line 1093: hr_utility.raise_error;

1089: p_prior_grade not in ('11','12','13','14','15','96','97') and
1090: p_prior_grade is not null
1091: then
1092: hr_utility.set_message(8301, 'GHR_37532_ALL_PROCEDURE_FAIL');
1093: hr_utility.raise_error;
1094: end if;
1095: END IF;
1096:
1097: -- 540.25.2

Line 1105: hr_utility.set_message(8301, 'GHR_37533_ALL_PROCEDURE_FAIL');

1101:
1102: and
1103: p_prior_grade is not null
1104: then
1105: hr_utility.set_message(8301, 'GHR_37533_ALL_PROCEDURE_FAIL');
1106: hr_utility.raise_error;
1107: end if;
1108:
1109: -- 540.28.2

Line 1106: hr_utility.raise_error;

1102: and
1103: p_prior_grade is not null
1104: then
1105: hr_utility.set_message(8301, 'GHR_37533_ALL_PROCEDURE_FAIL');
1106: hr_utility.raise_error;
1107: end if;
1108:
1109: -- 540.28.2
1110: if p_prior_pay_plan = 'VP' and

Line 1115: hr_utility.set_message(8301, 'GHR_37534_ALL_PROCEDURE_FAIL');

1111: p_prior_grade not between '11' and '15'
1112: and
1113: p_prior_grade is not null
1114: then
1115: hr_utility.set_message(8301, 'GHR_37534_ALL_PROCEDURE_FAIL');
1116: hr_utility.raise_error;
1117: end if;
1118:
1119: -- 540.29.2

Line 1116: hr_utility.raise_error;

1112: and
1113: p_prior_grade is not null
1114: then
1115: hr_utility.set_message(8301, 'GHR_37534_ALL_PROCEDURE_FAIL');
1116: hr_utility.raise_error;
1117: end if;
1118:
1119: -- 540.29.2
1120: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007

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

1123: p_prior_grade not between '01' and '04'
1124: and
1125: p_prior_grade is not null
1126: then
1127: hr_utility.set_message(8301, 'GHR_37538_ALL_PROCEDURE_FAIL');
1128: hr_utility.raise_error;
1129: end if;
1130: end if;
1131:

Line 1128: hr_utility.raise_error;

1124: and
1125: p_prior_grade is not null
1126: then
1127: hr_utility.set_message(8301, 'GHR_37538_ALL_PROCEDURE_FAIL');
1128: hr_utility.raise_error;
1129: end if;
1130: end if;
1131:
1132: -- 540.31.2

Line 1138: hr_utility.set_message(8301, 'GHR_37535_ALL_PROCEDURE_FAIL');

1134: p_prior_grade not between '01' and '15'
1135: and
1136: p_prior_grade is not null
1137: then
1138: hr_utility.set_message(8301, 'GHR_37535_ALL_PROCEDURE_FAIL');
1139: hr_utility.raise_error;
1140: end if;
1141:
1142: -- 540.32.2

Line 1139: hr_utility.raise_error;

1135: and
1136: p_prior_grade is not null
1137: then
1138: hr_utility.set_message(8301, 'GHR_37535_ALL_PROCEDURE_FAIL');
1139: hr_utility.raise_error;
1140: end if;
1141:
1142: -- 540.32.2
1143: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007

Line 1150: hr_utility.set_message(8301, 'GHR_37585_ALL_PROCEDURE_FAIL');

1146: p_prior_grade not between '01' and '06'
1147: and
1148: p_prior_grade is not null
1149: then
1150: hr_utility.set_message(8301, 'GHR_37585_ALL_PROCEDURE_FAIL');
1151: hr_utility.raise_error;
1152: end if;
1153: end if;
1154:

Line 1151: hr_utility.raise_error;

1147: and
1148: p_prior_grade is not null
1149: then
1150: hr_utility.set_message(8301, 'GHR_37585_ALL_PROCEDURE_FAIL');
1151: hr_utility.raise_error;
1152: end if;
1153: end if;
1154:
1155: -- 540.33.2

Line 1163: hr_utility.set_message(8301, 'GHR_37536_ALL_PROCEDURE_FAIL');

1159: p_prior_grade not between '01' and '05'
1160: and
1161: p_prior_grade is not null
1162: then
1163: hr_utility.set_message(8301, 'GHR_37536_ALL_PROCEDURE_FAIL');
1164: hr_utility.raise_error;
1165: end if;
1166: end if;
1167:

Line 1164: hr_utility.raise_error;

1160: and
1161: p_prior_grade is not null
1162: then
1163: hr_utility.set_message(8301, 'GHR_37536_ALL_PROCEDURE_FAIL');
1164: hr_utility.raise_error;
1165: end if;
1166: end if;
1167:
1168: -- 540.34.2

Line 1174: hr_utility.set_message(8301, 'GHR_37536_ALL_PROCEDURE_FAIL');

1170: p_prior_grade not between '01' and '05'
1171: and
1172: p_prior_grade is not null
1173: then
1174: hr_utility.set_message(8301, 'GHR_37536_ALL_PROCEDURE_FAIL');
1175: hr_utility.raise_error;
1176: end if;
1177:
1178: -- 540.35.2

Line 1175: hr_utility.raise_error;

1171: and
1172: p_prior_grade is not null
1173: then
1174: hr_utility.set_message(8301, 'GHR_37536_ALL_PROCEDURE_FAIL');
1175: hr_utility.raise_error;
1176: end if;
1177:
1178: -- 540.35.2
1179: --

Line 1186: hr_utility.set_message(8301, 'GHR_37871_ALL_PROCEDURE_FAIL');

1182: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1183: if p_prior_pay_plan in ('NH', 'NJ') and
1184: p_prior_grade not between '01' and '04' and
1185: p_prior_grade is not null then
1186: hr_utility.set_message(8301, 'GHR_37871_ALL_PROCEDURE_FAIL');
1187: hr_utility.raise_error;
1188: end if;
1189: end if;
1190:

Line 1187: hr_utility.raise_error;

1183: if p_prior_pay_plan in ('NH', 'NJ') and
1184: p_prior_grade not between '01' and '04' and
1185: p_prior_grade is not null then
1186: hr_utility.set_message(8301, 'GHR_37871_ALL_PROCEDURE_FAIL');
1187: hr_utility.raise_error;
1188: end if;
1189: end if;
1190:
1191: -- 540.36.2

Line 1201: hr_utility.set_message(8301, 'GHR_37872_ALL_PROCEDURE_FAIL');

1197: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1198: if p_prior_pay_plan = 'NK' and
1199: p_prior_grade not between '01' and '03' and
1200: p_prior_grade is not null then
1201: hr_utility.set_message(8301, 'GHR_37872_ALL_PROCEDURE_FAIL');
1202: hr_utility.raise_error;
1203: end if;
1204: end if;
1205: end if;

Line 1202: hr_utility.raise_error;

1198: if p_prior_pay_plan = 'NK' and
1199: p_prior_grade not between '01' and '03' and
1200: p_prior_grade is not null then
1201: hr_utility.set_message(8301, 'GHR_37872_ALL_PROCEDURE_FAIL');
1202: hr_utility.raise_error;
1203: end if;
1204: end if;
1205: end if;
1206:

Line 1214: hr_utility.set_message(8301, 'GHR_37537_ALL_PROCEDURE_FAIL');

1210: p_prior_grade not between '01' and '25'
1211: and
1212: p_prior_grade is not null
1213: then
1214: hr_utility.set_message(8301, 'GHR_37537_ALL_PROCEDURE_FAIL');
1215: hr_utility.raise_error;
1216: end if;
1217: */
1218: -- 540.38.2

Line 1215: hr_utility.raise_error;

1211: and
1212: p_prior_grade is not null
1213: then
1214: hr_utility.set_message(8301, 'GHR_37537_ALL_PROCEDURE_FAIL');
1215: hr_utility.raise_error;
1216: end if;
1217: */
1218: -- 540.38.2
1219: -- Update Date By Effective Date Comment

Line 1230: hr_utility.set_message(8301, 'GHR_37033_ALL_PROCEDURE_FAIL');

1226: if p_prior_pay_plan = 'FV' and
1227: p_prior_grade not in ('AA','BB','CC','DD','EE','FF','GG','HH','II',
1228: 'JJ','KK','LL','MM') and
1229: p_prior_grade is not null then
1230: hr_utility.set_message(8301, 'GHR_37033_ALL_PROCEDURE_FAIL');
1231: hr_utility.raise_error;
1232: end if;
1233: end if;
1234:

Line 1231: hr_utility.raise_error;

1227: p_prior_grade not in ('AA','BB','CC','DD','EE','FF','GG','HH','II',
1228: 'JJ','KK','LL','MM') and
1229: p_prior_grade is not null then
1230: hr_utility.set_message(8301, 'GHR_37033_ALL_PROCEDURE_FAIL');
1231: hr_utility.raise_error;
1232: end if;
1233: end if;
1234:
1235: -- 540.39.2

Line 1247: hr_utility.set_message(8301, 'GHR_37034_ALL_PROCEDURE_FAIL');

1243: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then
1244: if p_prior_pay_plan = 'EV' and
1245: p_prior_grade not in ('01', '02', '03') and
1246: p_prior_grade is not null then
1247: hr_utility.set_message(8301, 'GHR_37034_ALL_PROCEDURE_FAIL');
1248: hr_utility.raise_error;
1249: end if;
1250: end if;
1251: end if;

Line 1248: hr_utility.raise_error;

1244: if p_prior_pay_plan = 'EV' and
1245: p_prior_grade not in ('01', '02', '03') and
1246: p_prior_grade is not null then
1247: hr_utility.set_message(8301, 'GHR_37034_ALL_PROCEDURE_FAIL');
1248: hr_utility.raise_error;
1249: end if;
1250: end if;
1251: end if;
1252:

Line 1261: hr_utility.set_message(8301, 'GHR_37538_ALL_PROCEDURE_FAIL');

1257: p_prior_grade not between '01' and '04'
1258: and
1259: p_prior_grade is not null
1260: then
1261: hr_utility.set_message(8301, 'GHR_37538_ALL_PROCEDURE_FAIL');
1262: hr_utility.raise_error;
1263: end if;
1264: end if;
1265:

Line 1262: hr_utility.raise_error;

1258: and
1259: p_prior_grade is not null
1260: then
1261: hr_utility.set_message(8301, 'GHR_37538_ALL_PROCEDURE_FAIL');
1262: hr_utility.raise_error;
1263: end if;
1264: end if;
1265:
1266: -- 540.43.2

Line 1272: hr_utility.set_message(8301, 'GHR_37539_ALL_PROCEDURE_FAIL');

1268: p_prior_grade not between '01' and '08'
1269: and
1270: p_prior_grade is not null
1271: then
1272: hr_utility.set_message(8301, 'GHR_37539_ALL_PROCEDURE_FAIL');
1273: hr_utility.raise_error;
1274: end if;
1275:
1276: -- 540.45.2

Line 1273: hr_utility.raise_error;

1269: and
1270: p_prior_grade is not null
1271: then
1272: hr_utility.set_message(8301, 'GHR_37539_ALL_PROCEDURE_FAIL');
1273: hr_utility.raise_error;
1274: end if;
1275:
1276: -- 540.45.2
1277: if p_prior_pay_plan = 'FP' and

Line 1284: hr_utility.set_message(8301, 'GHR_37540_ALL_PROCEDURE_FAIL');

1280: )
1281: and
1282: p_prior_grade is not null
1283: then
1284: hr_utility.set_message(8301, 'GHR_37540_ALL_PROCEDURE_FAIL');
1285: hr_utility.raise_error;
1286: end if;
1287:
1288: -- 540.46.2

Line 1285: hr_utility.raise_error;

1281: and
1282: p_prior_grade is not null
1283: then
1284: hr_utility.set_message(8301, 'GHR_37540_ALL_PROCEDURE_FAIL');
1285: hr_utility.raise_error;
1286: end if;
1287:
1288: -- 540.46.2
1289: if p_prior_pay_plan = 'FE' and

Line 1294: hr_utility.set_message(8301, 'GHR_37541_ALL_PROCEDURE_FAIL');

1290: p_prior_grade not in ('CA','CM','MC','OC','01','02','03')
1291: and
1292: p_prior_grade is not null
1293: then
1294: hr_utility.set_message(8301, 'GHR_37541_ALL_PROCEDURE_FAIL');
1295: hr_utility.raise_error;
1296: end if;
1297:
1298: -- 540.49.2

Line 1295: hr_utility.raise_error;

1291: and
1292: p_prior_grade is not null
1293: then
1294: hr_utility.set_message(8301, 'GHR_37541_ALL_PROCEDURE_FAIL');
1295: hr_utility.raise_error;
1296: end if;
1297:
1298: -- 540.49.2
1299: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007

Line 1306: hr_utility.set_message(8301, 'GHR_37542_ALL_PROCEDURE_FAIL');

1302: p_prior_grade not in ('AA','BB','CC','DD','EE')
1303: and
1304: p_prior_grade is not null
1305: then
1306: hr_utility.set_message(8301, 'GHR_37542_ALL_PROCEDURE_FAIL');
1307: hr_utility.raise_error;
1308: end if;
1309: end if;
1310:

Line 1307: hr_utility.raise_error;

1303: and
1304: p_prior_grade is not null
1305: then
1306: hr_utility.set_message(8301, 'GHR_37542_ALL_PROCEDURE_FAIL');
1307: hr_utility.raise_error;
1308: end if;
1309: end if;
1310:
1311: -- 540.52.2

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

1315: p_prior_grade not between '02' and '14'
1316: and
1317: p_prior_grade is not null
1318: then
1319: hr_utility.set_message(8301, 'GHR_37543_ALL_PROCEDURE_FAIL');
1320: hr_utility.raise_error;
1321: end if;
1322: end if;
1323:

Line 1320: hr_utility.raise_error;

1316: and
1317: p_prior_grade is not null
1318: then
1319: hr_utility.set_message(8301, 'GHR_37543_ALL_PROCEDURE_FAIL');
1320: hr_utility.raise_error;
1321: end if;
1322: end if;
1323:
1324: -- 540.55.2

Line 1330: hr_utility.set_message(8301, 'GHR_37544_ALL_PROCEDURE_FAIL');

1326: not( p_prior_grade between '01' and '15' or
1327: p_prior_grade is null or
1328: p_prior_grade = 'SL' )
1329: then
1330: hr_utility.set_message(8301, 'GHR_37544_ALL_PROCEDURE_FAIL');
1331: hr_utility.raise_error;
1332: end if;
1333:
1334: -- 540.56.2

Line 1331: hr_utility.raise_error;

1327: p_prior_grade is null or
1328: p_prior_grade = 'SL' )
1329: then
1330: hr_utility.set_message(8301, 'GHR_37544_ALL_PROCEDURE_FAIL');
1331: hr_utility.raise_error;
1332: end if;
1333:
1334: -- 540.56.2
1335: -- Update/Change Date By Effective Date Comment

Line 1343: hr_utility.set_message(8301, 'GHR_37071_ALL_PROCEDURE_FAIL');

1339: if p_prior_pay_plan = 'NC' and
1340: not( p_prior_grade in ('01','02','03') or
1341: p_prior_grade is null )
1342: then
1343: hr_utility.set_message(8301, 'GHR_37071_ALL_PROCEDURE_FAIL');
1344: hr_utility.raise_error;
1345: end if;
1346: end if;
1347: -- 540.57.2

Line 1344: hr_utility.raise_error;

1340: not( p_prior_grade in ('01','02','03') or
1341: p_prior_grade is null )
1342: then
1343: hr_utility.set_message(8301, 'GHR_37071_ALL_PROCEDURE_FAIL');
1344: hr_utility.raise_error;
1345: end if;
1346: end if;
1347: -- 540.57.2
1348: -- Update/Change Date By Effective Date Comment

Line 1360: hr_utility.set_message(8301, 'GHR_37072_ALL_PROCEDURE_FAIL');

1356: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1357: if p_prior_pay_plan = 'NO' and
1358: not( p_prior_grade in ('01','02','03','04') or
1359: p_prior_grade is null ) then
1360: hr_utility.set_message(8301, 'GHR_37072_ALL_PROCEDURE_FAIL');
1361: hr_utility.set_message_token('PRIOR_GRD','01 through 04');
1362: hr_utility.raise_error;
1363: end if;
1364: else

Line 1361: hr_utility.set_message_token('PRIOR_GRD','01 through 04');

1357: if p_prior_pay_plan = 'NO' and
1358: not( p_prior_grade in ('01','02','03','04') or
1359: p_prior_grade is null ) then
1360: hr_utility.set_message(8301, 'GHR_37072_ALL_PROCEDURE_FAIL');
1361: hr_utility.set_message_token('PRIOR_GRD','01 through 04');
1362: hr_utility.raise_error;
1363: end if;
1364: else
1365: if p_prior_pay_plan = 'NO' and

Line 1362: hr_utility.raise_error;

1358: not( p_prior_grade in ('01','02','03','04') or
1359: p_prior_grade is null ) then
1360: hr_utility.set_message(8301, 'GHR_37072_ALL_PROCEDURE_FAIL');
1361: hr_utility.set_message_token('PRIOR_GRD','01 through 04');
1362: hr_utility.raise_error;
1363: end if;
1364: else
1365: if p_prior_pay_plan = 'NO' and
1366: not( p_prior_grade in ('01','02','03','04','05') or

Line 1368: hr_utility.set_message(8301, 'GHR_37072_ALL_PROCEDURE_FAIL');

1364: else
1365: if p_prior_pay_plan = 'NO' and
1366: not( p_prior_grade in ('01','02','03','04','05') or
1367: p_prior_grade is null ) then
1368: hr_utility.set_message(8301, 'GHR_37072_ALL_PROCEDURE_FAIL');
1369: hr_utility.set_message_token('PRIOR_GRD','01 through 05');
1370: hr_utility.raise_error;
1371: end if;
1372: end if;

Line 1369: hr_utility.set_message_token('PRIOR_GRD','01 through 05');

1365: if p_prior_pay_plan = 'NO' and
1366: not( p_prior_grade in ('01','02','03','04','05') or
1367: p_prior_grade is null ) then
1368: hr_utility.set_message(8301, 'GHR_37072_ALL_PROCEDURE_FAIL');
1369: hr_utility.set_message_token('PRIOR_GRD','01 through 05');
1370: hr_utility.raise_error;
1371: end if;
1372: end if;
1373: end if;

Line 1370: hr_utility.raise_error;

1366: not( p_prior_grade in ('01','02','03','04','05') or
1367: p_prior_grade is null ) then
1368: hr_utility.set_message(8301, 'GHR_37072_ALL_PROCEDURE_FAIL');
1369: hr_utility.set_message_token('PRIOR_GRD','01 through 05');
1370: hr_utility.raise_error;
1371: end if;
1372: end if;
1373: end if;
1374: end if;

Line 1387: hr_utility.set_message(8301, 'GHR_37073_ALL_PROCEDURE_FAIL');

1383: if p_prior_pay_plan in ( 'NP','NR') and
1384: not( p_prior_grade in ('01','02','03','04','05') or
1385: p_prior_grade is null )
1386: then
1387: hr_utility.set_message(8301, 'GHR_37073_ALL_PROCEDURE_FAIL');
1388: hr_utility.raise_error;
1389: end if;
1390: end if;
1391: end if;

Line 1388: hr_utility.raise_error;

1384: not( p_prior_grade in ('01','02','03','04','05') or
1385: p_prior_grade is null )
1386: then
1387: hr_utility.set_message(8301, 'GHR_37073_ALL_PROCEDURE_FAIL');
1388: hr_utility.raise_error;
1389: end if;
1390: end if;
1391: end if;
1392:

Line 1398: hr_utility.set_message(8301, 'GHR_37545_ALL_PROCEDURE_FAIL');

1394: if p_prior_pay_plan = 'GH' and
1395: not( p_prior_grade between '13' and '15' or
1396: p_prior_grade is null )
1397: then
1398: hr_utility.set_message(8301, 'GHR_37545_ALL_PROCEDURE_FAIL');
1399: hr_utility.raise_error;
1400: end if;
1401:
1402: -- 540.61.2

Line 1399: hr_utility.raise_error;

1395: not( p_prior_grade between '13' and '15' or
1396: p_prior_grade is null )
1397: then
1398: hr_utility.set_message(8301, 'GHR_37545_ALL_PROCEDURE_FAIL');
1399: hr_utility.raise_error;
1400: end if;
1401:
1402: -- 540.61.2
1403: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007

Line 1411: hr_utility.set_message(8301, 'GHR_37546_ALL_PROCEDURE_FAIL');

1407: p_prior_grade <> '00'
1408: and
1409: p_prior_grade is not null
1410: then
1411: hr_utility.set_message(8301, 'GHR_37546_ALL_PROCEDURE_FAIL');
1412: hr_utility.raise_error;
1413: end if;
1414: end if;
1415:

Line 1412: hr_utility.raise_error;

1408: and
1409: p_prior_grade is not null
1410: then
1411: hr_utility.set_message(8301, 'GHR_37546_ALL_PROCEDURE_FAIL');
1412: hr_utility.raise_error;
1413: end if;
1414: end if;
1415:
1416: -- 540.62.2

Line 1429: hr_utility.set_message(8301, 'GHR_37421_ALL_PROCEDURE_FAIL');

1425: if p_prior_pay_plan = 'VE' and
1426: not( p_prior_grade in ('01','02') or
1427: p_prior_grade is null )
1428: then
1429: hr_utility.set_message(8301, 'GHR_37421_ALL_PROCEDURE_FAIL');
1430: hr_utility.raise_error;
1431: end if;
1432: end if;
1433:

Line 1430: hr_utility.raise_error;

1426: not( p_prior_grade in ('01','02') or
1427: p_prior_grade is null )
1428: then
1429: hr_utility.set_message(8301, 'GHR_37421_ALL_PROCEDURE_FAIL');
1430: hr_utility.raise_error;
1431: end if;
1432: end if;
1433:
1434: -- 540.63.2

Line 1445: hr_utility.set_message(8301, 'GHR_37422_ALL_PROCEDURE_FAIL');

1441: if p_prior_pay_plan = 'NB' and
1442: p_prior_grade not in ('01', '02','03','04','05','06','07','08','09')
1443: and p_prior_grade is not null
1444: then
1445: hr_utility.set_message(8301, 'GHR_37422_ALL_PROCEDURE_FAIL');
1446: hr_utility.raise_error;
1447: end if;
1448: end if;
1449: end if;

Line 1446: hr_utility.raise_error;

1442: p_prior_grade not in ('01', '02','03','04','05','06','07','08','09')
1443: and p_prior_grade is not null
1444: then
1445: hr_utility.set_message(8301, 'GHR_37422_ALL_PROCEDURE_FAIL');
1446: hr_utility.raise_error;
1447: end if;
1448: end if;
1449: end if;
1450:

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

1456: if p_prior_pay_plan in ('GL') and
1457: p_prior_grade not in ('03','04','05','06','07','08','09','10') and
1458: p_prior_grade is not null
1459: then
1460: hr_utility.set_message(8301, 'GHR_37432_ALL_PROCEDURE_FAIL');
1461: hr_utility.raise_error;
1462: end if;
1463: end if;
1464: -- End Bug# 5073313

Line 1461: hr_utility.raise_error;

1457: p_prior_grade not in ('03','04','05','06','07','08','09','10') and
1458: p_prior_grade is not null
1459: then
1460: hr_utility.set_message(8301, 'GHR_37432_ALL_PROCEDURE_FAIL');
1461: hr_utility.raise_error;
1462: end if;
1463: end if;
1464: -- End Bug# 5073313
1465:

Line 1473: hr_utility.set_message(8301, 'GHR_38158_ALL_PROCEDURE_FAIL');

1469: if p_prior_pay_plan in ('GL') and
1470: p_prior_grade > '10' and
1471: p_prior_grade is not null then
1472: --Bug# 6959477 message number 38629 is duplicated, so created new message with #38158
1473: hr_utility.set_message(8301, 'GHR_38158_ALL_PROCEDURE_FAIL');
1474: hr_utility.raise_error;
1475: end if;
1476: end if;
1477: --End Bug# 5745356

Line 1474: hr_utility.raise_error;

1470: p_prior_grade > '10' and
1471: p_prior_grade is not null then
1472: --Bug# 6959477 message number 38629 is duplicated, so created new message with #38158
1473: hr_utility.set_message(8301, 'GHR_38158_ALL_PROCEDURE_FAIL');
1474: hr_utility.raise_error;
1475: end if;
1476: end if;
1477: --End Bug# 5745356
1478:

Line 1513: hr_utility.set_message(8301, 'GHR_37547_ALL_PROCEDURE_FAIL');

1509: p_prior_pay_plan is not null and
1510: p_to_pay_plan is not null and
1511: not(p_first_noac_lookup_code in ('702','703','713','721','740','741','850','855','894') or
1512: substr(p_first_noac_lookup_code,1,1)= '5') then
1513: hr_utility.set_message(8301, 'GHR_37547_ALL_PROCEDURE_FAIL');
1514: hr_utility.raise_error;
1515: end if;
1516: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1517: if p_prior_pay_plan <> p_to_pay_plan and

Line 1514: hr_utility.raise_error;

1510: p_to_pay_plan is not null and
1511: not(p_first_noac_lookup_code in ('702','703','713','721','740','741','850','855','894') or
1512: substr(p_first_noac_lookup_code,1,1)= '5') then
1513: hr_utility.set_message(8301, 'GHR_37547_ALL_PROCEDURE_FAIL');
1514: hr_utility.raise_error;
1515: end if;
1516: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1517: if p_prior_pay_plan <> p_to_pay_plan and
1518: p_prior_pay_plan is not null and

Line 1523: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');

1519: p_to_pay_plan is not null and
1520: not(p_first_noac_lookup_code in ('600','601','602','603','604','605','606','607','608','609','610',
1521: '702','703','713','721','740','741','850','855','894') or
1522: substr(p_first_noac_lookup_code,1,1)= '5') then
1523: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1524: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 850, 855 or 894');
1525: hr_utility.raise_error;
1526: end if;
1527: elsif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then

Line 1524: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 850, 855 or 894');

1520: not(p_first_noac_lookup_code in ('600','601','602','603','604','605','606','607','608','609','610',
1521: '702','703','713','721','740','741','850','855','894') or
1522: substr(p_first_noac_lookup_code,1,1)= '5') then
1523: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1524: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 850, 855 or 894');
1525: hr_utility.raise_error;
1526: end if;
1527: elsif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then
1528: if p_prior_pay_plan <> p_to_pay_plan and

Line 1525: hr_utility.raise_error;

1521: '702','703','713','721','740','741','850','855','894') or
1522: substr(p_first_noac_lookup_code,1,1)= '5') then
1523: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1524: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 850, 855 or 894');
1525: hr_utility.raise_error;
1526: end if;
1527: elsif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then
1528: if p_prior_pay_plan <> p_to_pay_plan and
1529: p_prior_pay_plan is not null and

Line 1534: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');

1530: p_to_pay_plan is not null and
1531: not(p_first_noac_lookup_code in ('600','601','602','603','604','605','606','607','608','609','610',
1532: '611','613','702','703','713','721','740','741','850','855','894') or
1533: substr(p_first_noac_lookup_code,1,1)= '5') then
1534: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1535: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855 or 894 ');
1536: hr_utility.raise_error;
1537: end if;
1538: else

Line 1535: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855 or 894 ');

1531: not(p_first_noac_lookup_code in ('600','601','602','603','604','605','606','607','608','609','610',
1532: '611','613','702','703','713','721','740','741','850','855','894') or
1533: substr(p_first_noac_lookup_code,1,1)= '5') then
1534: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1535: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855 or 894 ');
1536: hr_utility.raise_error;
1537: end if;
1538: else
1539: if p_prior_pay_plan <> p_to_pay_plan and

Line 1536: hr_utility.raise_error;

1532: '611','613','702','703','713','721','740','741','850','855','894') or
1533: substr(p_first_noac_lookup_code,1,1)= '5') then
1534: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1535: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855 or 894 ');
1536: hr_utility.raise_error;
1537: end if;
1538: else
1539: if p_prior_pay_plan <> p_to_pay_plan and
1540: p_prior_pay_plan is not null and

Line 1545: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');

1541: p_to_pay_plan is not null and
1542: not(p_first_noac_lookup_code in ('600','601','602','603','604','605','606','607','608','609','610',
1543: '611','613','702','703','713','721','740','741','850','855','890','894') or
1544: substr(p_first_noac_lookup_code,1,1)= '5') then
1545: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1546: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855, 890, or 894');
1547: hr_utility.raise_error;
1548: end if;
1549: end if;

Line 1546: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855, 890, or 894');

1542: not(p_first_noac_lookup_code in ('600','601','602','603','604','605','606','607','608','609','610',
1543: '611','613','702','703','713','721','740','741','850','855','890','894') or
1544: substr(p_first_noac_lookup_code,1,1)= '5') then
1545: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1546: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855, 890, or 894');
1547: hr_utility.raise_error;
1548: end if;
1549: end if;
1550: --Modified for dual actions

Line 1547: hr_utility.raise_error;

1543: '611','613','702','703','713','721','740','741','850','855','890','894') or
1544: substr(p_first_noac_lookup_code,1,1)= '5') then
1545: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1546: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855, 890, or 894');
1547: hr_utility.raise_error;
1548: end if;
1549: end if;
1550: --Modified for dual actions
1551: elsif NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'Y' then

Line 1560: hr_utility.set_message(8301, 'GHR_37547_ALL_PROCEDURE_FAIL');

1556: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('702','703','713','721','740','741','850','855','894') or
1557: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1558: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('702','703','713','721','740','741','850','855','894') or
1559: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5')then
1560: hr_utility.set_message(8301, 'GHR_37547_ALL_PROCEDURE_FAIL');
1561: hr_utility.raise_error;
1562: end if;
1563: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1564: if p_prior_pay_plan <> p_to_pay_plan and

Line 1561: hr_utility.raise_error;

1557: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1558: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('702','703','713','721','740','741','850','855','894') or
1559: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5')then
1560: hr_utility.set_message(8301, 'GHR_37547_ALL_PROCEDURE_FAIL');
1561: hr_utility.raise_error;
1562: end if;
1563: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1564: if p_prior_pay_plan <> p_to_pay_plan and
1565: p_prior_pay_plan is not null and

Line 1573: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');

1569: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1570: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1571: '702','703','713','721','740','741','850','855','894') or
1572: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1573: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1574: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 850, 855 or 894');
1575: hr_utility.raise_error;
1576: end if;
1577: elsif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then

Line 1574: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 850, 855 or 894');

1570: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1571: '702','703','713','721','740','741','850','855','894') or
1572: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1573: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1574: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 850, 855 or 894');
1575: hr_utility.raise_error;
1576: end if;
1577: elsif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then
1578: if p_prior_pay_plan <> p_to_pay_plan and

Line 1575: hr_utility.raise_error;

1571: '702','703','713','721','740','741','850','855','894') or
1572: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1573: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1574: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 850, 855 or 894');
1575: hr_utility.raise_error;
1576: end if;
1577: elsif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then
1578: if p_prior_pay_plan <> p_to_pay_plan and
1579: p_prior_pay_plan is not null and

Line 1587: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');

1583: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1584: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1585: '611','613','702','703','713','721','740','741','850','855','894') or
1586: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1587: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1588: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855 or 894 ');
1589: hr_utility.raise_error;
1590: end if;
1591: else

Line 1588: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855 or 894 ');

1584: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1585: '611','613','702','703','713','721','740','741','850','855','894') or
1586: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1587: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1588: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855 or 894 ');
1589: hr_utility.raise_error;
1590: end if;
1591: else
1592: if p_prior_pay_plan <> p_to_pay_plan and

Line 1589: hr_utility.raise_error;

1585: '611','613','702','703','713','721','740','741','850','855','894') or
1586: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1587: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1588: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855 or 894 ');
1589: hr_utility.raise_error;
1590: end if;
1591: else
1592: if p_prior_pay_plan <> p_to_pay_plan and
1593: p_prior_pay_plan is not null and

Line 1601: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');

1597: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1598: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1599: '611','613','702','703','713','721','740','741','850','855','890','894') or
1600: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1601: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1602: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855, 890, or 894');
1603: hr_utility.raise_error;
1604: end if;
1605: end if;

Line 1602: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855, 890, or 894');

1598: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1599: '611','613','702','703','713','721','740','741','850','855','890','894') or
1600: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1601: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1602: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855, 890, or 894');
1603: hr_utility.raise_error;
1604: end if;
1605: end if;
1606: end if;

Line 1603: hr_utility.raise_error;

1599: '611','613','702','703','713','721','740','741','850','855','890','894') or
1600: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1601: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1602: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855, 890, or 894');
1603: hr_utility.raise_error;
1604: end if;
1605: end if;
1606: end if;
1607: end if;

Line 1638: hr_utility.set_message(8301, 'GHR_37548_ALL_PROCEDURE_FAIL');

1634: if p_First_NOAC_Lookup_Code = '741' and
1635: p_prior_pay_rate_det_code not in ('A','B','E','F','M','U','V') and
1636: p_prior_pay_rate_det_code is not null
1637: then
1638: hr_utility.set_message(8301, 'GHR_37548_ALL_PROCEDURE_FAIL');
1639: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
1640: hr_utility.raise_error;
1641: end if;
1642: ELSIF P_effective_date >= to_date('2005/05/01','YYYY/MM/DD') THEN

Line 1639: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');

1635: p_prior_pay_rate_det_code not in ('A','B','E','F','M','U','V') and
1636: p_prior_pay_rate_det_code is not null
1637: then
1638: hr_utility.set_message(8301, 'GHR_37548_ALL_PROCEDURE_FAIL');
1639: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
1640: hr_utility.raise_error;
1641: end if;
1642: ELSIF P_effective_date >= to_date('2005/05/01','YYYY/MM/DD') THEN
1643: if p_First_NOAC_Lookup_Code = '741' and

Line 1640: hr_utility.raise_error;

1636: p_prior_pay_rate_det_code is not null
1637: then
1638: hr_utility.set_message(8301, 'GHR_37548_ALL_PROCEDURE_FAIL');
1639: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
1640: hr_utility.raise_error;
1641: end if;
1642: ELSIF P_effective_date >= to_date('2005/05/01','YYYY/MM/DD') THEN
1643: if p_First_NOAC_Lookup_Code = '741' and
1644: p_prior_pay_rate_det_code not in ('A','B','E','F','U','V') and

Line 1647: hr_utility.set_message(8301, 'GHR_37548_ALL_PROCEDURE_FAIL');

1643: if p_First_NOAC_Lookup_Code = '741' and
1644: p_prior_pay_rate_det_code not in ('A','B','E','F','U','V') and
1645: p_prior_pay_rate_det_code is not null
1646: then
1647: hr_utility.set_message(8301, 'GHR_37548_ALL_PROCEDURE_FAIL');
1648: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
1649: hr_utility.raise_error;
1650: end if;
1651: END IF;

Line 1648: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');

1644: p_prior_pay_rate_det_code not in ('A','B','E','F','U','V') and
1645: p_prior_pay_rate_det_code is not null
1646: then
1647: hr_utility.set_message(8301, 'GHR_37548_ALL_PROCEDURE_FAIL');
1648: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
1649: hr_utility.raise_error;
1650: end if;
1651: END IF;
1652:

Line 1649: hr_utility.raise_error;

1645: p_prior_pay_rate_det_code is not null
1646: then
1647: hr_utility.set_message(8301, 'GHR_37548_ALL_PROCEDURE_FAIL');
1648: hr_utility.set_message_token('PRD_LIST','A, B, E, F, U, or V');
1649: hr_utility.raise_error;
1650: end if;
1651: END IF;
1652:
1653: -- 560.04.2

Line 1664: hr_utility.set_message(8301, 'GHR_37549_ALL_PROCEDURE_FAIL');

1660: p_prior_pay_rate_det_code in ('A','B','E','F','U','V') and
1661: p_pay_rate_determinant not in ('A','B','E','F','U','V') and
1662: p_pay_rate_determinant is not null
1663: then
1664: hr_utility.set_message(8301, 'GHR_37549_ALL_PROCEDURE_FAIL');
1665: hr_utility.set_message_token('PRD_CODE','A, B, E, F, U, or V');
1666: hr_utility.raise_error;
1667: end if;
1668: END IF;

Line 1665: hr_utility.set_message_token('PRD_CODE','A, B, E, F, U, or V');

1661: p_pay_rate_determinant not in ('A','B','E','F','U','V') and
1662: p_pay_rate_determinant is not null
1663: then
1664: hr_utility.set_message(8301, 'GHR_37549_ALL_PROCEDURE_FAIL');
1665: hr_utility.set_message_token('PRD_CODE','A, B, E, F, U, or V');
1666: hr_utility.raise_error;
1667: end if;
1668: END IF;
1669: ELSE

Line 1666: hr_utility.raise_error;

1662: p_pay_rate_determinant is not null
1663: then
1664: hr_utility.set_message(8301, 'GHR_37549_ALL_PROCEDURE_FAIL');
1665: hr_utility.set_message_token('PRD_CODE','A, B, E, F, U, or V');
1666: hr_utility.raise_error;
1667: end if;
1668: END IF;
1669: ELSE
1670: IF GHR_GHRWS52L.g_temp_step IS NULL THEN

Line 1677: hr_utility.set_message(8301, 'GHR_37549_ALL_PROCEDURE_FAIL');

1673: substr(p_prior_pay_plan,1,1) <> ('Y') and
1674: p_pay_rate_determinant not in ('A','B','E','F','U','V') and
1675: p_pay_rate_determinant is not null
1676: then
1677: hr_utility.set_message(8301, 'GHR_37549_ALL_PROCEDURE_FAIL');
1678: hr_utility.set_message_token('PRD_CODE','A, B, E, F, U, or V, and pay plan is other than Yx');
1679: hr_utility.raise_error;
1680: end if;
1681: END IF;

Line 1678: hr_utility.set_message_token('PRD_CODE','A, B, E, F, U, or V, and pay plan is other than Yx');

1674: p_pay_rate_determinant not in ('A','B','E','F','U','V') and
1675: p_pay_rate_determinant is not null
1676: then
1677: hr_utility.set_message(8301, 'GHR_37549_ALL_PROCEDURE_FAIL');
1678: hr_utility.set_message_token('PRD_CODE','A, B, E, F, U, or V, and pay plan is other than Yx');
1679: hr_utility.raise_error;
1680: end if;
1681: END IF;
1682: END IF;

Line 1679: hr_utility.raise_error;

1675: p_pay_rate_determinant is not null
1676: then
1677: hr_utility.set_message(8301, 'GHR_37549_ALL_PROCEDURE_FAIL');
1678: hr_utility.set_message_token('PRD_CODE','A, B, E, F, U, or V, and pay plan is other than Yx');
1679: hr_utility.raise_error;
1680: end if;
1681: END IF;
1682: END IF;
1683:

Line 1691: hr_utility.set_message(8301, 'GHR_37550_ALL_PROCEDURE_FAIL');

1687: if p_prior_pay_rate_det_code = 'C' and
1688: (p_prior_pay_plan in ('ED','EE','EF','EG','EH','EI','ZZ') or
1689: substr(p_prior_pay_plan,1,1) in ('B','W','X'))
1690: then
1691: hr_utility.set_message(8301, 'GHR_37550_ALL_PROCEDURE_FAIL');
1692: hr_utility.raise_error;
1693: end if;
1694: end if;
1695:

Line 1692: hr_utility.raise_error;

1688: (p_prior_pay_plan in ('ED','EE','EF','EG','EH','EI','ZZ') or
1689: substr(p_prior_pay_plan,1,1) in ('B','W','X'))
1690: then
1691: hr_utility.set_message(8301, 'GHR_37550_ALL_PROCEDURE_FAIL');
1692: hr_utility.raise_error;
1693: end if;
1694: end if;
1695:
1696: -- 560.07.2

Line 1701: hr_utility.set_message(8301, 'GHR_37551_ALL_PROCEDURE_FAIL');

1697: if p_prior_pay_rate_det_code = '4' and
1698: ( substr(p_prior_pay_plan,1,1) ='W' or
1699: substr(p_prior_pay_plan,1,1) ='X' )
1700: then
1701: hr_utility.set_message(8301, 'GHR_37551_ALL_PROCEDURE_FAIL');
1702: hr_utility.raise_error;
1703: end if;
1704:
1705: -- 560.10.2

Line 1702: hr_utility.raise_error;

1698: ( substr(p_prior_pay_plan,1,1) ='W' or
1699: substr(p_prior_pay_plan,1,1) ='X' )
1700: then
1701: hr_utility.set_message(8301, 'GHR_37551_ALL_PROCEDURE_FAIL');
1702: hr_utility.raise_error;
1703: end if;
1704:
1705: -- 560.10.2
1706: -- 06/25/03 vravikan By passing this edit if the

Line 1734: hr_utility.set_message(8301, 'GHR_37552_ALL_PROCEDURE_FAIL');

1730: p_pay_rate_determinant <> p_prior_pay_rate_det_code
1731: and
1732: p_pay_rate_determinant is not null
1733: then
1734: hr_utility.set_message(8301, 'GHR_37552_ALL_PROCEDURE_FAIL');
1735: hr_utility.raise_error;
1736: end if;
1737: END IF;
1738: ELSIF P_effective_date >= to_date('2005/05/01','YYYY/MM/DD') THEN

Line 1735: hr_utility.raise_error;

1731: and
1732: p_pay_rate_determinant is not null
1733: then
1734: hr_utility.set_message(8301, 'GHR_37552_ALL_PROCEDURE_FAIL');
1735: hr_utility.raise_error;
1736: end if;
1737: END IF;
1738: ELSIF P_effective_date >= to_date('2005/05/01','YYYY/MM/DD') THEN
1739: IF GHR_GHRWS52L.g_temp_step IS NULL THEN

Line 1754: hr_utility.set_message(8301, 'GHR_38986_ALL_PROCEDURE_FAIL');

1750: p_pay_rate_determinant <> p_prior_pay_rate_det_code
1751: and
1752: p_pay_rate_determinant is not null
1753: then
1754: hr_utility.set_message(8301, 'GHR_38986_ALL_PROCEDURE_FAIL');
1755: hr_utility.raise_error;
1756: end if;
1757: END IF;
1758: END IF;

Line 1755: hr_utility.raise_error;

1751: and
1752: p_pay_rate_determinant is not null
1753: then
1754: hr_utility.set_message(8301, 'GHR_38986_ALL_PROCEDURE_FAIL');
1755: hr_utility.raise_error;
1756: end if;
1757: END IF;
1758: END IF;
1759: -- FWFA Changes

Line 1768: hr_utility.set_message(8301, 'GHR_37553_ALL_PROCEDURE_FAIL');

1764: if p_prior_pay_plan in ('FA','ST','EX') and
1765: p_prior_pay_rate_det_code not in ('C','S','0') and
1766: p_prior_pay_rate_det_code is not null
1767: then
1768: hr_utility.set_message(8301, 'GHR_37553_ALL_PROCEDURE_FAIL');
1769: hr_utility.raise_error;
1770: end if;
1771:
1772: -- 560.28.2

Line 1769: hr_utility.raise_error;

1765: p_prior_pay_rate_det_code not in ('C','S','0') and
1766: p_prior_pay_rate_det_code is not null
1767: then
1768: hr_utility.set_message(8301, 'GHR_37553_ALL_PROCEDURE_FAIL');
1769: hr_utility.raise_error;
1770: end if;
1771:
1772: -- 560.28.2
1773: -- Update Date By Effective Date Comment

Line 1784: hr_utility.set_message(8301, 'GHR_37554_ALL_PROCEDURE_FAIL');

1780: if p_prior_pay_plan = 'ES' and
1781: p_prior_pay_rate_det_code not in ('C','0','2') and
1782: p_prior_pay_rate_det_code is not null
1783: then
1784: hr_utility.set_message(8301, 'GHR_37554_ALL_PROCEDURE_FAIL');
1785: hr_utility.raise_error;
1786: end if;
1787: end if;
1788:

Line 1785: hr_utility.raise_error;

1781: p_prior_pay_rate_det_code not in ('C','0','2') and
1782: p_prior_pay_rate_det_code is not null
1783: then
1784: hr_utility.set_message(8301, 'GHR_37554_ALL_PROCEDURE_FAIL');
1785: hr_utility.raise_error;
1786: end if;
1787: end if;
1788:
1789: -- 560.30.2

Line 1966: hr_utility.set_message(8301, 'GHR_37266_ALL_PROCEDURE_FAIL');

1962: substr(p_prior_duty_stn,1,2) = '54' and
1963: substr(p_prior_duty_stn,7,3) not in ('003','037')
1964: )
1965: ) then
1966: hr_utility.set_message(8301, 'GHR_37266_ALL_PROCEDURE_FAIL');
1967: hr_utility.raise_error;
1968: end if;
1969: end if;
1970: END IF; -- End of checking date <= 31 Jan 2002

Line 1967: hr_utility.raise_error;

1963: substr(p_prior_duty_stn,7,3) not in ('003','037')
1964: )
1965: ) then
1966: hr_utility.set_message(8301, 'GHR_37266_ALL_PROCEDURE_FAIL');
1967: hr_utility.raise_error;
1968: end if;
1969: end if;
1970: END IF; -- End of checking date <= 31 Jan 2002
1971: -------------------------------------------------------------------------------

Line 1980: hr_utility.set_message(8301, 'GHR_37063_ALL_PROCEDURE_FAIL');

1976: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1977: If p_prior_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
1978: if p_prior_pay_plan in ('GM','GS') and
1979: p_prior_pay_rate_det_code in ('P','T') then
1980: hr_utility.set_message(8301, 'GHR_37063_ALL_PROCEDURE_FAIL');
1981: hr_utility.raise_error;
1982: end if;
1983: else
1984: if p_prior_pay_plan in ('GM','GS') and

Line 1981: hr_utility.raise_error;

1977: If p_prior_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
1978: if p_prior_pay_plan in ('GM','GS') and
1979: p_prior_pay_rate_det_code in ('P','T') then
1980: hr_utility.set_message(8301, 'GHR_37063_ALL_PROCEDURE_FAIL');
1981: hr_utility.raise_error;
1982: end if;
1983: else
1984: if p_prior_pay_plan in ('GM','GS') and
1985: p_prior_pay_rate_det_code = 'P' then

Line 1986: hr_utility.set_message(8301, 'GHR_37556_ALL_PROCEDURE_FAIL');

1982: end if;
1983: else
1984: if p_prior_pay_plan in ('GM','GS') and
1985: p_prior_pay_rate_det_code = 'P' then
1986: hr_utility.set_message(8301, 'GHR_37556_ALL_PROCEDURE_FAIL');
1987: hr_utility.raise_error;
1988: end if;
1989: end if;
1990: end if;

Line 1987: hr_utility.raise_error;

1983: else
1984: if p_prior_pay_plan in ('GM','GS') and
1985: p_prior_pay_rate_det_code = 'P' then
1986: hr_utility.set_message(8301, 'GHR_37556_ALL_PROCEDURE_FAIL');
1987: hr_utility.raise_error;
1988: end if;
1989: end if;
1990: end if;
1991:

Line 2005: hr_utility.set_message(8301, 'GHR_38842_ALL_PROCEDURE_FAIL');

2001: IF p_prior_pay_rate_det_code = 'Z' AND
2002: p_prior_pay_plan IN ('FO','FP') AND
2003: p_agency NOT IN ('AM','GY','ST') AND
2004: substr(p_prior_duty_stn,1,2) NOT IN ('CA','MX') THEN
2005: hr_utility.set_message(8301, 'GHR_38842_ALL_PROCEDURE_FAIL');
2006: hr_utility.raise_error;
2007: END IF;
2008:
2009: end chk_prior_pay_rate_determinant;

Line 2006: hr_utility.raise_error;

2002: p_prior_pay_plan IN ('FO','FP') AND
2003: p_agency NOT IN ('AM','GY','ST') AND
2004: substr(p_prior_duty_stn,1,2) NOT IN ('CA','MX') THEN
2005: hr_utility.set_message(8301, 'GHR_38842_ALL_PROCEDURE_FAIL');
2006: hr_utility.raise_error;
2007: END IF;
2008:
2009: end chk_prior_pay_rate_determinant;
2010:

Line 2057: hr_utility.set_message(8301, 'GHR_37557_ALL_PROCEDURE_FAIL');

2053: p_to_step_or_rate is not null and
2054: p_prior_step_or_rate is not null and
2055: p_prior_step_or_rate <> p_to_step_or_rate
2056: then
2057: hr_utility.set_message(8301, 'GHR_37557_ALL_PROCEDURE_FAIL');
2058: hr_utility.raise_error;
2059: end if;
2060: ELSIF p_prior_effective_date < to_date('2007/01/01','yyyy/mm/dd') THEN
2061: if (substr(p_first_noac_lookup_code,1,1) = '7' or

Line 2058: hr_utility.raise_error;

2054: p_prior_step_or_rate is not null and
2055: p_prior_step_or_rate <> p_to_step_or_rate
2056: then
2057: hr_utility.set_message(8301, 'GHR_37557_ALL_PROCEDURE_FAIL');
2058: hr_utility.raise_error;
2059: end if;
2060: ELSIF p_prior_effective_date < to_date('2007/01/01','yyyy/mm/dd') THEN
2061: if (substr(p_first_noac_lookup_code,1,1) = '7' or
2062: substr(p_first_noac_lookup_code,1,1) = '8') and

Line 2071: hr_utility.set_message(8301, 'GHR_38159_ALL_PROCEDURE_FAIL');

2067: p_prior_step_or_rate is not null and
2068: p_prior_step_or_rate <> p_to_step_or_rate
2069: then
2070: --Bug# 6959477 message number 38805 is duplicated, so created new message with #38159
2071: hr_utility.set_message(8301, 'GHR_38159_ALL_PROCEDURE_FAIL');
2072: hr_utility.raise_error;
2073: end if;
2074: ELSIF p_prior_effective_date < to_date('2007/02/15','yyyy/mm/dd') THEN
2075: if (substr(p_first_noac_lookup_code,1,1) = '7' or

Line 2072: hr_utility.raise_error;

2068: p_prior_step_or_rate <> p_to_step_or_rate
2069: then
2070: --Bug# 6959477 message number 38805 is duplicated, so created new message with #38159
2071: hr_utility.set_message(8301, 'GHR_38159_ALL_PROCEDURE_FAIL');
2072: hr_utility.raise_error;
2073: end if;
2074: ELSIF p_prior_effective_date < to_date('2007/02/15','yyyy/mm/dd') THEN
2075: if (substr(p_first_noac_lookup_code,1,1) = '7' or
2076: substr(p_first_noac_lookup_code,1,1) = '8') and

Line 2085: hr_utility.set_message(8301, 'GHR_38156_ALL_PROCEDURE_FAIL');

2081: p_prior_step_or_rate is not null and
2082: p_prior_step_or_rate <> p_to_step_or_rate
2083: then
2084: --Bug# 6959477 message number 38584 is duplicated, so created new message with #38156
2085: hr_utility.set_message(8301, 'GHR_38156_ALL_PROCEDURE_FAIL');
2086: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 815-817, 825, 827, 840-849, 855, 866-868, 871, 878, 879, 890-894, or 899');
2087: hr_utility.raise_error;
2088: end if;
2089: ELSE

Line 2086: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 815-817, 825, 827, 840-849, 855, 866-868, 871, 878, 879, 890-894, or 899');

2082: p_prior_step_or_rate <> p_to_step_or_rate
2083: then
2084: --Bug# 6959477 message number 38584 is duplicated, so created new message with #38156
2085: hr_utility.set_message(8301, 'GHR_38156_ALL_PROCEDURE_FAIL');
2086: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 815-817, 825, 827, 840-849, 855, 866-868, 871, 878, 879, 890-894, or 899');
2087: hr_utility.raise_error;
2088: end if;
2089: ELSE
2090: if (substr(p_first_noac_lookup_code,1,1) = '7' or

Line 2087: hr_utility.raise_error;

2083: then
2084: --Bug# 6959477 message number 38584 is duplicated, so created new message with #38156
2085: hr_utility.set_message(8301, 'GHR_38156_ALL_PROCEDURE_FAIL');
2086: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 815-817, 825, 827, 840-849, 855, 866-868, 871, 878, 879, 890-894, or 899');
2087: hr_utility.raise_error;
2088: end if;
2089: ELSE
2090: if (substr(p_first_noac_lookup_code,1,1) = '7' or
2091: substr(p_first_noac_lookup_code,1,1) = '8') and

Line 2100: hr_utility.set_message(8301, 'GHR_38156_ALL_PROCEDURE_FAIL');

2096: p_prior_step_or_rate is not null and
2097: p_prior_step_or_rate <> p_to_step_or_rate
2098: then
2099: --Bug# 6959477 message number 38584 is duplicated, so created new message with #38156
2100: hr_utility.set_message(8301, 'GHR_38156_ALL_PROCEDURE_FAIL');
2101: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 827, 840-849, 855, 866-868, 871, 878, 879, 890-894, or 899');
2102: hr_utility.raise_error;
2103: end if;
2104: END IF;

Line 2101: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 827, 840-849, 855, 866-868, 871, 878, 879, 890-894, or 899');

2097: p_prior_step_or_rate <> p_to_step_or_rate
2098: then
2099: --Bug# 6959477 message number 38584 is duplicated, so created new message with #38156
2100: hr_utility.set_message(8301, 'GHR_38156_ALL_PROCEDURE_FAIL');
2101: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 827, 840-849, 855, 866-868, 871, 878, 879, 890-894, or 899');
2102: hr_utility.raise_error;
2103: end if;
2104: END IF;
2105:

Line 2102: hr_utility.raise_error;

2098: then
2099: --Bug# 6959477 message number 38584 is duplicated, so created new message with #38156
2100: hr_utility.set_message(8301, 'GHR_38156_ALL_PROCEDURE_FAIL');
2101: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 827, 840-849, 855, 866-868, 871, 878, 879, 890-894, or 899');
2102: hr_utility.raise_error;
2103: end if;
2104: END IF;
2105:
2106: -- 580.03.2

Line 2116: hr_utility.set_message(8301, 'GHR_37558_ALL_PROCEDURE_FAIL');

2112: '07','08','09','10')
2113: and
2114: p_prior_step_or_rate is not null
2115: then
2116: hr_utility.set_message(8301, 'GHR_37558_ALL_PROCEDURE_FAIL');
2117: hr_utility.raise_error;
2118: end if;
2119: end if;
2120:

Line 2117: hr_utility.raise_error;

2113: and
2114: p_prior_step_or_rate is not null
2115: then
2116: hr_utility.set_message(8301, 'GHR_37558_ALL_PROCEDURE_FAIL');
2117: hr_utility.raise_error;
2118: end if;
2119: end if;
2120:
2121: -- 580.04.2

Line 2131: hr_utility.set_message(8301, 'GHR_37559_ALL_PROCEDURE_FAIL');

2127: p_pay_rate_determinant_code in ('0','5','6','7','M') and
2128: to_number(p_prior_step_or_rate) > to_number(p_to_step_or_rate) and
2129: p_prior_step_or_rate is not null
2130: then
2131: hr_utility.set_message(8301, 'GHR_37559_ALL_PROCEDURE_FAIL');
2132: hr_utility.set_message_token('PRD_LIST','0, 5, 6, 7, or M');
2133: hr_utility.raise_error;
2134: end if;
2135: elsif p_prior_effective_date >= to_date('2005/05/01','yyyy/mm/dd') then

Line 2132: hr_utility.set_message_token('PRD_LIST','0, 5, 6, 7, or M');

2128: to_number(p_prior_step_or_rate) > to_number(p_to_step_or_rate) and
2129: p_prior_step_or_rate is not null
2130: then
2131: hr_utility.set_message(8301, 'GHR_37559_ALL_PROCEDURE_FAIL');
2132: hr_utility.set_message_token('PRD_LIST','0, 5, 6, 7, or M');
2133: hr_utility.raise_error;
2134: end if;
2135: elsif p_prior_effective_date >= to_date('2005/05/01','yyyy/mm/dd') then
2136: if p_to_pay_plan = 'GS' and

Line 2133: hr_utility.raise_error;

2129: p_prior_step_or_rate is not null
2130: then
2131: hr_utility.set_message(8301, 'GHR_37559_ALL_PROCEDURE_FAIL');
2132: hr_utility.set_message_token('PRD_LIST','0, 5, 6, 7, or M');
2133: hr_utility.raise_error;
2134: end if;
2135: elsif p_prior_effective_date >= to_date('2005/05/01','yyyy/mm/dd') then
2136: if p_to_pay_plan = 'GS' and
2137: (p_first_noac_lookup_code = '892' or

Line 2143: hr_utility.set_message(8301, 'GHR_37559_ALL_PROCEDURE_FAIL');

2139: p_pay_rate_determinant_code in ('0','5','6','7') and
2140: to_number(p_prior_step_or_rate) > to_number(p_to_step_or_rate) and
2141: p_prior_step_or_rate is not null
2142: then
2143: hr_utility.set_message(8301, 'GHR_37559_ALL_PROCEDURE_FAIL');
2144: hr_utility.set_message_token('PRD_LIST','0, 5, 6, or 7');
2145: hr_utility.raise_error;
2146: end if;
2147: end if;

Line 2144: hr_utility.set_message_token('PRD_LIST','0, 5, 6, or 7');

2140: to_number(p_prior_step_or_rate) > to_number(p_to_step_or_rate) and
2141: p_prior_step_or_rate is not null
2142: then
2143: hr_utility.set_message(8301, 'GHR_37559_ALL_PROCEDURE_FAIL');
2144: hr_utility.set_message_token('PRD_LIST','0, 5, 6, or 7');
2145: hr_utility.raise_error;
2146: end if;
2147: end if;
2148:

Line 2145: hr_utility.raise_error;

2141: p_prior_step_or_rate is not null
2142: then
2143: hr_utility.set_message(8301, 'GHR_37559_ALL_PROCEDURE_FAIL');
2144: hr_utility.set_message_token('PRD_LIST','0, 5, 6, or 7');
2145: hr_utility.raise_error;
2146: end if;
2147: end if;
2148:
2149:

Line 2157: hr_utility.set_message(8301, 'GHR_37560_ALL_PROCEDURE_FAIL');

2153: (to_number(p_prior_step_or_rate) not between 00 and 21)
2154: and
2155: p_prior_step_or_rate is not null
2156: then
2157: hr_utility.set_message(8301, 'GHR_37560_ALL_PROCEDURE_FAIL');
2158: hr_utility.raise_error;
2159: end if;
2160:
2161: -- 580.10.2

Line 2158: hr_utility.raise_error;

2154: and
2155: p_prior_step_or_rate is not null
2156: then
2157: hr_utility.set_message(8301, 'GHR_37560_ALL_PROCEDURE_FAIL');
2158: hr_utility.raise_error;
2159: end if;
2160:
2161: -- 580.10.2
2162: -- 17-Aug-00 vravikan 01-jan-2000 Delete 99 form step/rate codes

Line 2170: hr_utility.set_message(8301, 'GHR_37424_ALL_PROCEDURE_FAIL');

2166: if p_prior_pay_plan = 'GM' and p_prior_step_or_rate <> '00'
2167: and
2168: p_prior_step_or_rate is not null
2169: then
2170: hr_utility.set_message(8301, 'GHR_37424_ALL_PROCEDURE_FAIL');
2171: hr_utility.raise_error;
2172: end if;
2173: else
2174: if p_prior_pay_plan = 'GM' and

Line 2171: hr_utility.raise_error;

2167: and
2168: p_prior_step_or_rate is not null
2169: then
2170: hr_utility.set_message(8301, 'GHR_37424_ALL_PROCEDURE_FAIL');
2171: hr_utility.raise_error;
2172: end if;
2173: else
2174: if p_prior_pay_plan = 'GM' and
2175: (p_prior_step_or_rate <>'00' and p_prior_step_or_rate <>'99' )

Line 2179: hr_utility.set_message(8301, 'GHR_37561_ALL_PROCEDURE_FAIL');

2175: (p_prior_step_or_rate <>'00' and p_prior_step_or_rate <>'99' )
2176: and
2177: p_prior_step_or_rate is not null
2178: then
2179: hr_utility.set_message(8301, 'GHR_37561_ALL_PROCEDURE_FAIL');
2180: hr_utility.raise_error;
2181: end if;
2182: end if;
2183: end if;

Line 2180: hr_utility.raise_error;

2176: and
2177: p_prior_step_or_rate is not null
2178: then
2179: hr_utility.set_message(8301, 'GHR_37561_ALL_PROCEDURE_FAIL');
2180: hr_utility.raise_error;
2181: end if;
2182: end if;
2183: end if;
2184:

Line 2196: hr_utility.set_message(8301, 'GHR_37562_ALL_PROCEDURE_FAIL');

2192: if (p_effective_date < to_date('2004/01/11', 'yyyy/mm/dd') and
2193: (p_prior_pay_plan = 'ES' or p_prior_pay_plan = 'FE') and
2194: (to_number(p_prior_step_or_rate) not between 1 and 6) and
2195: p_prior_step_or_rate is not null ) then
2196: hr_utility.set_message(8301, 'GHR_37562_ALL_PROCEDURE_FAIL');
2197: hr_utility.raise_error;
2198: end if;
2199: end if;
2200: -- 580.19.2

Line 2197: hr_utility.raise_error;

2193: (p_prior_pay_plan = 'ES' or p_prior_pay_plan = 'FE') and
2194: (to_number(p_prior_step_or_rate) not between 1 and 6) and
2195: p_prior_step_or_rate is not null ) then
2196: hr_utility.set_message(8301, 'GHR_37562_ALL_PROCEDURE_FAIL');
2197: hr_utility.raise_error;
2198: end if;
2199: end if;
2200: -- 580.19.2
2201: --upd47 26-Jun-06 Raju From 01-Apr-2003 Terminate the edit

Line 2211: hr_utility.set_message(8301, 'GHR_37563_ALL_PROCEDURE_FAIL');

2207: p_prior_pay_plan not in ('WT','FA','EX') and
2208: p_prior_step_or_rate <>'00' and
2209: p_prior_step_or_rate is not null
2210: then
2211: hr_utility.set_message(8301, 'GHR_37563_ALL_PROCEDURE_FAIL');
2212: hr_utility.raise_error;
2213: end if;
2214: end if;
2215:

Line 2212: hr_utility.raise_error;

2208: p_prior_step_or_rate <>'00' and
2209: p_prior_step_or_rate is not null
2210: then
2211: hr_utility.set_message(8301, 'GHR_37563_ALL_PROCEDURE_FAIL');
2212: hr_utility.raise_error;
2213: end if;
2214: end if;
2215:
2216: -- 580.22.2

Line 2229: hr_utility.set_message(8301, 'GHR_37564_ALL_PROCEDURE_FAIL');

2225: p_cur_appt_auth_1 <> 'UAM' and p_cur_appt_auth_2 <> 'UAM' and
2226: (to_number(p_prior_step_or_rate) not between 1 and 10) and
2227: p_prior_step_or_rate is not null )
2228: then
2229: hr_utility.set_message(8301, 'GHR_37564_ALL_PROCEDURE_FAIL');
2230: hr_utility.set_message_token('PAY_PLAN_LIST','GG, GS or VP ');
2231: hr_utility.raise_error;
2232: end if;
2233: ELSE

Line 2230: hr_utility.set_message_token('PAY_PLAN_LIST','GG, GS or VP ');

2226: (to_number(p_prior_step_or_rate) not between 1 and 10) and
2227: p_prior_step_or_rate is not null )
2228: then
2229: hr_utility.set_message(8301, 'GHR_37564_ALL_PROCEDURE_FAIL');
2230: hr_utility.set_message_token('PAY_PLAN_LIST','GG, GS or VP ');
2231: hr_utility.raise_error;
2232: end if;
2233: ELSE
2234: if (p_prior_pay_plan in ('GG', 'GL', 'GS', 'VP') and

Line 2231: hr_utility.raise_error;

2227: p_prior_step_or_rate is not null )
2228: then
2229: hr_utility.set_message(8301, 'GHR_37564_ALL_PROCEDURE_FAIL');
2230: hr_utility.set_message_token('PAY_PLAN_LIST','GG, GS or VP ');
2231: hr_utility.raise_error;
2232: end if;
2233: ELSE
2234: if (p_prior_pay_plan in ('GG', 'GL', 'GS', 'VP') and
2235: (p_prior_grade between '01' and '15') and

Line 2241: hr_utility.set_message(8301, 'GHR_37564_ALL_PROCEDURE_FAIL');

2237: p_cur_appt_auth_1 <> 'UAM' and p_cur_appt_auth_2 <> 'UAM' and
2238: (to_number(p_prior_step_or_rate) not between 1 and 10) and
2239: p_prior_step_or_rate is not null )
2240: then
2241: hr_utility.set_message(8301, 'GHR_37564_ALL_PROCEDURE_FAIL');
2242: hr_utility.set_message_token('PAY_PLAN_LIST','GG, GL, GS or VP ');
2243: hr_utility.raise_error;
2244: end if;
2245: END IF;

Line 2242: hr_utility.set_message_token('PAY_PLAN_LIST','GG, GL, GS or VP ');

2238: (to_number(p_prior_step_or_rate) not between 1 and 10) and
2239: p_prior_step_or_rate is not null )
2240: then
2241: hr_utility.set_message(8301, 'GHR_37564_ALL_PROCEDURE_FAIL');
2242: hr_utility.set_message_token('PAY_PLAN_LIST','GG, GL, GS or VP ');
2243: hr_utility.raise_error;
2244: end if;
2245: END IF;
2246:

Line 2243: hr_utility.raise_error;

2239: p_prior_step_or_rate is not null )
2240: then
2241: hr_utility.set_message(8301, 'GHR_37564_ALL_PROCEDURE_FAIL');
2242: hr_utility.set_message_token('PAY_PLAN_LIST','GG, GL, GS or VP ');
2243: hr_utility.raise_error;
2244: end if;
2245: END IF;
2246:
2247: -- 580.25.2

Line 2258: hr_utility.set_message(8301, 'GHR_37565_ALL_PROCEDURE_FAIL');

2254: p_prior_grade <> '97' and
2255: (to_number(p_prior_step_or_rate) not between 0 and 10) and
2256: p_prior_step_or_rate is not null
2257: then
2258: hr_utility.set_message(8301, 'GHR_37565_ALL_PROCEDURE_FAIL');
2259: hr_utility.raise_error;
2260: end if;
2261: END IF;
2262:

Line 2259: hr_utility.raise_error;

2255: (to_number(p_prior_step_or_rate) not between 0 and 10) and
2256: p_prior_step_or_rate is not null
2257: then
2258: hr_utility.set_message(8301, 'GHR_37565_ALL_PROCEDURE_FAIL');
2259: hr_utility.raise_error;
2260: end if;
2261: END IF;
2262:
2263: -- 580.26.2

Line 2271: hr_utility.set_message(8301, 'GHR_37566_ALL_PROCEDURE_FAIL');

2267: (to_number(p_prior_step_or_rate) not between 0 and 9)
2268: and
2269: p_prior_step_or_rate is not null
2270: then
2271: hr_utility.set_message(8301, 'GHR_37566_ALL_PROCEDURE_FAIL');
2272: hr_utility.raise_error;
2273: end if;
2274: end if;
2275:

Line 2272: hr_utility.raise_error;

2268: and
2269: p_prior_step_or_rate is not null
2270: then
2271: hr_utility.set_message(8301, 'GHR_37566_ALL_PROCEDURE_FAIL');
2272: hr_utility.raise_error;
2273: end if;
2274: end if;
2275:
2276: -- 580.27.2

Line 2282: hr_utility.set_message(8301, 'GHR_37567_ALL_PROCEDURE_FAIL');

2278: (to_number(p_prior_step_or_rate) not between 0 and 28)
2279: and
2280: p_prior_step_or_rate is not null
2281: then
2282: hr_utility.set_message(8301, 'GHR_37567_ALL_PROCEDURE_FAIL');
2283: hr_utility.raise_error;
2284: end if;
2285:
2286: -- 580.29.2

Line 2283: hr_utility.raise_error;

2279: and
2280: p_prior_step_or_rate is not null
2281: then
2282: hr_utility.set_message(8301, 'GHR_37567_ALL_PROCEDURE_FAIL');
2283: hr_utility.raise_error;
2284: end if;
2285:
2286: -- 580.29.2
2287: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007

Line 2294: hr_utility.set_message(8301, 'GHR_37568_ALL_PROCEDURE_FAIL');

2290: (to_number(p_prior_step_or_rate) not between 1 and 3)
2291: and
2292: p_prior_step_or_rate is not null
2293: then
2294: hr_utility.set_message(8301, 'GHR_37568_ALL_PROCEDURE_FAIL');
2295: hr_utility.raise_error;
2296: end if;
2297: end if;
2298:

Line 2295: hr_utility.raise_error;

2291: and
2292: p_prior_step_or_rate is not null
2293: then
2294: hr_utility.set_message(8301, 'GHR_37568_ALL_PROCEDURE_FAIL');
2295: hr_utility.raise_error;
2296: end if;
2297: end if;
2298:
2299: -- 580.31.2

Line 2305: hr_utility.set_message(8301, 'GHR_37569_ALL_PROCEDURE_FAIL');

2301: (to_number(p_prior_step_or_rate) not between 1 and 14)
2302: and
2303: p_prior_step_or_rate is not null
2304: then
2305: hr_utility.set_message(8301, 'GHR_37569_ALL_PROCEDURE_FAIL');
2306: hr_utility.raise_error;
2307: end if;
2308:
2309: -- 580.32.2

Line 2306: hr_utility.raise_error;

2302: and
2303: p_prior_step_or_rate is not null
2304: then
2305: hr_utility.set_message(8301, 'GHR_37569_ALL_PROCEDURE_FAIL');
2306: hr_utility.raise_error;
2307: end if;
2308:
2309: -- 580.32.2
2310: if (p_prior_pay_plan = 'FP' and p_prior_grade between '01' and '09') and

Line 2315: hr_utility.set_message(8301, 'GHR_37570_ALL_PROCEDURE_FAIL');

2311: (to_number(p_prior_step_or_rate) not between 1 and 14)
2312: and
2313: p_prior_step_or_rate is not null
2314: then
2315: hr_utility.set_message(8301, 'GHR_37570_ALL_PROCEDURE_FAIL');
2316: hr_utility.raise_error;
2317: end if;
2318:
2319: -- 580.33.2

Line 2316: hr_utility.raise_error;

2312: and
2313: p_prior_step_or_rate is not null
2314: then
2315: hr_utility.set_message(8301, 'GHR_37570_ALL_PROCEDURE_FAIL');
2316: hr_utility.raise_error;
2317: end if;
2318:
2319: -- 580.33.2
2320: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007

Line 2327: hr_utility.set_message(8301, 'GHR_37571_ALL_PROCEDURE_FAIL');

2323: to_number(p_prior_step_or_rate) not between 1 and 5)
2324: and
2325: p_prior_step_or_rate is not null
2326: then
2327: hr_utility.set_message(8301, 'GHR_37571_ALL_PROCEDURE_FAIL');
2328: hr_utility.raise_error;
2329: end if;
2330: end if;
2331:

Line 2328: hr_utility.raise_error;

2324: and
2325: p_prior_step_or_rate is not null
2326: then
2327: hr_utility.set_message(8301, 'GHR_37571_ALL_PROCEDURE_FAIL');
2328: hr_utility.raise_error;
2329: end if;
2330: end if;
2331:
2332: -- 580.34.2

Line 2340: hr_utility.set_message(8301, 'GHR_37572_ALL_PROCEDURE_FAIL');

2336: (to_number(p_prior_step_or_rate) not between 1 and 5)
2337: and
2338: p_prior_step_or_rate is not null
2339: then
2340: hr_utility.set_message(8301, 'GHR_37572_ALL_PROCEDURE_FAIL');
2341: hr_utility.raise_error;
2342: end if;
2343: end if;
2344:

Line 2341: hr_utility.raise_error;

2337: and
2338: p_prior_step_or_rate is not null
2339: then
2340: hr_utility.set_message(8301, 'GHR_37572_ALL_PROCEDURE_FAIL');
2341: hr_utility.raise_error;
2342: end if;
2343: end if;
2344:
2345: -- 580.37.2

Line 2354: hr_utility.set_message(8301, 'GHR_37573_ALL_PROCEDURE_FAIL');

2350: (to_number(p_prior_step_or_rate) not between 1 and 10)
2351: and
2352: p_prior_step_or_rate is not null
2353: then
2354: hr_utility.set_message(8301, 'GHR_37573_ALL_PROCEDURE_FAIL');
2355: hr_utility.raise_error;
2356: end if;
2357: end if;
2358:

Line 2355: hr_utility.raise_error;

2351: and
2352: p_prior_step_or_rate is not null
2353: then
2354: hr_utility.set_message(8301, 'GHR_37573_ALL_PROCEDURE_FAIL');
2355: hr_utility.raise_error;
2356: end if;
2357: end if;
2358:
2359: -- 580.40.2

Line 2367: hr_utility.set_message(8301, 'GHR_37574_ALL_PROCEDURE_FAIL');

2363: (to_number(p_prior_step_or_rate) not between 1 and 9)
2364: and
2365: p_prior_step_or_rate is not null
2366: then
2367: hr_utility.set_message(8301, 'GHR_37574_ALL_PROCEDURE_FAIL');
2368: hr_utility.raise_error;
2369: end if;
2370: end if;
2371:

Line 2368: hr_utility.raise_error;

2364: and
2365: p_prior_step_or_rate is not null
2366: then
2367: hr_utility.set_message(8301, 'GHR_37574_ALL_PROCEDURE_FAIL');
2368: hr_utility.raise_error;
2369: end if;
2370: end if;
2371:
2372: -- 580.43.2

Line 2380: hr_utility.set_message(8301, 'GHR_37575_ALL_PROCEDURE_FAIL');

2376: (to_number(p_prior_step_or_rate) not between 1 and 5)
2377: and
2378: p_prior_step_or_rate is not null
2379: then
2380: hr_utility.set_message(8301, 'GHR_37575_ALL_PROCEDURE_FAIL');
2381: hr_utility.raise_error;
2382: end if;
2383: end if;
2384:

Line 2381: hr_utility.raise_error;

2377: and
2378: p_prior_step_or_rate is not null
2379: then
2380: hr_utility.set_message(8301, 'GHR_37575_ALL_PROCEDURE_FAIL');
2381: hr_utility.raise_error;
2382: end if;
2383: end if;
2384:
2385: -- 580.46.2

Line 2393: hr_utility.set_message(8301, 'GHR_37576_ALL_PROCEDURE_FAIL');

2389: p_prior_step_or_rate <>'00'
2390: and
2391: p_prior_step_or_rate is not null
2392: then
2393: hr_utility.set_message(8301, 'GHR_37576_ALL_PROCEDURE_FAIL');
2394: hr_utility.raise_error;
2395: end if;
2396: end if;
2397:

Line 2394: hr_utility.raise_error;

2390: and
2391: p_prior_step_or_rate is not null
2392: then
2393: hr_utility.set_message(8301, 'GHR_37576_ALL_PROCEDURE_FAIL');
2394: hr_utility.raise_error;
2395: end if;
2396: end if;
2397:
2398: -- 580.49.2

Line 2409: hr_utility.set_message(8301, 'GHR_37577_ALL_PROCEDURE_FAIL');

2405: p_prior_step_or_rate <>'00'
2406: and
2407: p_prior_step_or_rate is not null
2408: then
2409: hr_utility.set_message(8301, 'GHR_37577_ALL_PROCEDURE_FAIL');
2410: hr_utility.raise_error;
2411: end if;
2412: end if;
2413:

Line 2410: hr_utility.raise_error;

2406: and
2407: p_prior_step_or_rate is not null
2408: then
2409: hr_utility.set_message(8301, 'GHR_37577_ALL_PROCEDURE_FAIL');
2410: hr_utility.raise_error;
2411: end if;
2412: end if;
2413:
2414: -- 580.52.2

Line 2421: hr_utility.set_message(8301, 'GHR_37578_ALL_PROCEDURE_FAIL');

2417: p_prior_step_or_rate not in ('01','02','03','04','05','06')
2418: and
2419: p_prior_step_or_rate is not null
2420: then
2421: hr_utility.set_message(8301, 'GHR_37578_ALL_PROCEDURE_FAIL');
2422: hr_utility.raise_error;
2423: end if;
2424:
2425: -- 580.55.2

Line 2422: hr_utility.raise_error;

2418: and
2419: p_prior_step_or_rate is not null
2420: then
2421: hr_utility.set_message(8301, 'GHR_37578_ALL_PROCEDURE_FAIL');
2422: hr_utility.raise_error;
2423: end if;
2424:
2425: -- 580.55.2
2426: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007

Line 2433: hr_utility.set_message(8301, 'GHR_37579_ALL_PROCEDURE_FAIL');

2429: p_prior_step_or_rate <>'00'
2430: and
2431: p_prior_step_or_rate is not null
2432: then
2433: hr_utility.set_message(8301, 'GHR_37579_ALL_PROCEDURE_FAIL');
2434: hr_utility.raise_error;
2435: end if;
2436: end if;
2437:

Line 2434: hr_utility.raise_error;

2430: and
2431: p_prior_step_or_rate is not null
2432: then
2433: hr_utility.set_message(8301, 'GHR_37579_ALL_PROCEDURE_FAIL');
2434: hr_utility.raise_error;
2435: end if;
2436: end if;
2437:
2438: -- 580.57.2

Line 2443: hr_utility.set_message(8301, 'GHR_38413_ALL_PROCEDURE_FAIL');

2439: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2440: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2441: if (p_prior_pay_plan = 'IJ' and p_prior_pay_rate_det_code in ('0','7')) then
2442: if NVL(p_prior_step_or_rate, '01') not in ('01','02','03','04') then
2443: hr_utility.set_message(8301, 'GHR_38413_ALL_PROCEDURE_FAIL');
2444: hr_utility.raise_error;
2445: end if;
2446: end if;
2447: end if;

Line 2444: hr_utility.raise_error;

2440: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2441: if (p_prior_pay_plan = 'IJ' and p_prior_pay_rate_det_code in ('0','7')) then
2442: if NVL(p_prior_step_or_rate, '01') not in ('01','02','03','04') then
2443: hr_utility.set_message(8301, 'GHR_38413_ALL_PROCEDURE_FAIL');
2444: hr_utility.raise_error;
2445: end if;
2446: end if;
2447: end if;
2448: