DBA Data[Home] [Help]

APPS.GHR_PSN_POS_GRP1_PK dependencies on HR_UTILITY

Line 89: hr_utility.set_message(8301, 'GHR_38420_POSN_RULES');

85: is
86: begin
87: IF ( p_pos_grp1_type.flsa_category IS NULL)
88: THEN
89: hr_utility.set_message(8301, 'GHR_38420_POSN_RULES');
90: hr_utility.raise_error;
91: END IF;
92: end psn_flsa_cat;
93: --

Line 90: hr_utility.raise_error;

86: begin
87: IF ( p_pos_grp1_type.flsa_category IS NULL)
88: THEN
89: hr_utility.set_message(8301, 'GHR_38420_POSN_RULES');
90: hr_utility.raise_error;
91: END IF;
92: end psn_flsa_cat;
93: --
94: procedure psn_flsa_cat_3

Line 104: hr_utility.set_message(8301, 'GHR_38421_POSN_RULES');

100: begin
101: IF ( p_pay_plan IN ('AL', 'CA', 'ES', 'EX', 'SL', 'ST')
102: AND p_pos_grp1_type.flsa_category <> 'E')
103: THEN
104: hr_utility.set_message(8301, 'GHR_38421_POSN_RULES');
105: hr_utility.raise_error;
106: END IF;
107: end psn_flsa_cat_3;
108: --

Line 105: hr_utility.raise_error;

101: IF ( p_pay_plan IN ('AL', 'CA', 'ES', 'EX', 'SL', 'ST')
102: AND p_pos_grp1_type.flsa_category <> 'E')
103: THEN
104: hr_utility.set_message(8301, 'GHR_38421_POSN_RULES');
105: hr_utility.raise_error;
106: END IF;
107: end psn_flsa_cat_3;
108: --
109: procedure psn_funct_class_id_3

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

115: begin
116: IF ( p_pos_grp2_type.training_program_id = '53'
117: AND p_pos_grp1_type.functional_class IS NULL)
118: THEN
119: hr_utility.set_message(8301, 'GHR_38424_POSN_RULES');
120: hr_utility.raise_error;
121: END IF;
122: end psn_funct_class_id_3;
123: --

Line 120: hr_utility.raise_error;

116: IF ( p_pos_grp2_type.training_program_id = '53'
117: AND p_pos_grp1_type.functional_class IS NULL)
118: THEN
119: hr_utility.set_message(8301, 'GHR_38424_POSN_RULES');
120: hr_utility.raise_error;
121: END IF;
122: end psn_funct_class_id_3;
123: --
124: procedure psn_pos_scty_acs_1

Line 134: hr_utility.set_message(8301, 'GHR_38425_POSN_RULES');

130: IF ( p_pos_grp1_type.position_sensitivity <> '1'
131: AND p_pos_grp1_type.position_sensitivity IS NOT NULL
132: AND p_pos_grp1_type.security_access IS NULL)
133: THEN
134: hr_utility.set_message(8301, 'GHR_38425_POSN_RULES');
135: hr_utility.raise_error;
136: END IF;
137: end psn_pos_scty_acs_1;
138: --

Line 135: hr_utility.raise_error;

131: AND p_pos_grp1_type.position_sensitivity IS NOT NULL
132: AND p_pos_grp1_type.security_access IS NULL)
133: THEN
134: hr_utility.set_message(8301, 'GHR_38425_POSN_RULES');
135: hr_utility.raise_error;
136: END IF;
137: end psn_pos_scty_acs_1;
138: --
139: /* Removed as per Aug 2001 10.7 Patch and patched in April 2002 Patch for 11i

Line 150: hr_utility.set_message(8301, 'GHR_38429_POSN_RULES');

146: begin
147: IF ( p_pos_grp1_type.supervisory_status = '5'
148: AND p_pay_plan NOT IN ('AL','CA','GM','GS','SL','GG','GH','FT','FM','FG') )
149: THEN
150: hr_utility.set_message(8301, 'GHR_38429_POSN_RULES');
151: hr_utility.raise_error;
152: END IF;
153: end psn_supv_status_11;
154: */

Line 151: hr_utility.raise_error;

147: IF ( p_pos_grp1_type.supervisory_status = '5'
148: AND p_pay_plan NOT IN ('AL','CA','GM','GS','SL','GG','GH','FT','FM','FG') )
149: THEN
150: hr_utility.set_message(8301, 'GHR_38429_POSN_RULES');
151: hr_utility.raise_error;
152: END IF;
153: end psn_supv_status_11;
154: */
155: --

Line 166: hr_utility.set_message(8301, 'GHR_38433_POSN_RULES');

162: begin
163: IF ( p_pay_plan IN ('ES', 'EX', 'FE')
164: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2', '3', '8'))
165: THEN
166: hr_utility.set_message(8301, 'GHR_38433_POSN_RULES');
167: hr_utility.raise_error;
168: END IF;
169: end psn_supv_status_19;
170: --

Line 167: hr_utility.raise_error;

163: IF ( p_pay_plan IN ('ES', 'EX', 'FE')
164: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2', '3', '8'))
165: THEN
166: hr_utility.set_message(8301, 'GHR_38433_POSN_RULES');
167: hr_utility.raise_error;
168: END IF;
169: end psn_supv_status_19;
170: --
171: procedure psn_supv_status_2

Line 181: hr_utility.set_message(8301, 'GHR_38434_POSN_RULES');

177: begin
178: IF ( p_pay_plan IN ('WN', 'WS')
179: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2','3'))
180: THEN
181: hr_utility.set_message(8301, 'GHR_38434_POSN_RULES');
182: hr_utility.raise_error;
183: END IF;
184: IF ( p_pay_plan = 'WG'
185: AND p_pos_grp1_type.supervisory_status NOT IN ('4','7','8'))

Line 182: hr_utility.raise_error;

178: IF ( p_pay_plan IN ('WN', 'WS')
179: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2','3'))
180: THEN
181: hr_utility.set_message(8301, 'GHR_38434_POSN_RULES');
182: hr_utility.raise_error;
183: END IF;
184: IF ( p_pay_plan = 'WG'
185: AND p_pos_grp1_type.supervisory_status NOT IN ('4','7','8'))
186: THEN

Line 187: hr_utility.set_message(8301, 'GHR_38435_POSN_RULES');

183: END IF;
184: IF ( p_pay_plan = 'WG'
185: AND p_pos_grp1_type.supervisory_status NOT IN ('4','7','8'))
186: THEN
187: hr_utility.set_message(8301, 'GHR_38435_POSN_RULES');
188: hr_utility.raise_error;
189: END IF;
190: end psn_supv_status_2;
191: --

Line 188: hr_utility.raise_error;

184: IF ( p_pay_plan = 'WG'
185: AND p_pos_grp1_type.supervisory_status NOT IN ('4','7','8'))
186: THEN
187: hr_utility.set_message(8301, 'GHR_38435_POSN_RULES');
188: hr_utility.raise_error;
189: END IF;
190: end psn_supv_status_2;
191: --
192: procedure psn_supv_status_3

Line 204: hr_utility.set_message(8301, 'GHR_38436_POSN_RULES');

200: IF ( p_pay_plan = 'GS'
201: AND p_grade IN ('01', '02', '03', '04')
202: AND p_pos_grp1_type.supervisory_status NOT IN ('4','6','8'))
203: THEN
204: hr_utility.set_message(8301, 'GHR_38436_POSN_RULES');
205: hr_utility.raise_error;
206: END IF;
207: end psn_supv_status_3;
208: --

Line 205: hr_utility.raise_error;

201: AND p_grade IN ('01', '02', '03', '04')
202: AND p_pos_grp1_type.supervisory_status NOT IN ('4','6','8'))
203: THEN
204: hr_utility.set_message(8301, 'GHR_38436_POSN_RULES');
205: hr_utility.raise_error;
206: END IF;
207: end psn_supv_status_3;
208: --
209: procedure psn_supv_status_4

Line 221: hr_utility.set_message(8301, 'GHR_38437_POSN_RULES');

217: IF ( p_pay_plan <> 'GS'
218: AND p_pay_plan = 'GM'
219: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2','3','4','5','7'))
220: THEN
221: hr_utility.set_message(8301, 'GHR_38437_POSN_RULES');
222: hr_utility.raise_error;
223: END IF;
224: end psn_supv_status_4;
225: --

Line 222: hr_utility.raise_error;

218: AND p_pay_plan = 'GM'
219: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2','3','4','5','7'))
220: THEN
221: hr_utility.set_message(8301, 'GHR_38437_POSN_RULES');
222: hr_utility.raise_error;
223: END IF;
224: end psn_supv_status_4;
225: --
226: procedure psn_supv_status_5

Line 236: hr_utility.set_message(8301, 'GHR_38438_POSN_RULES');

232: begin
233: IF ( p_pay_plan IN ('GW', 'WW', 'YW', 'YV', 'IP', 'DW')
234: AND p_pos_grp1_type.supervisory_status <> '8')
235: THEN
236: hr_utility.set_message(8301, 'GHR_38438_POSN_RULES');
237: hr_utility.raise_error;
238: END IF;
239: end psn_supv_status_5;
240: --

Line 237: hr_utility.raise_error;

233: IF ( p_pay_plan IN ('GW', 'WW', 'YW', 'YV', 'IP', 'DW')
234: AND p_pos_grp1_type.supervisory_status <> '8')
235: THEN
236: hr_utility.set_message(8301, 'GHR_38438_POSN_RULES');
237: hr_utility.raise_error;
238: END IF;
239: end psn_supv_status_5;
240: --
241: procedure psn_supv_status_6

Line 251: hr_utility.set_message(8301, 'GHR_38439_POSN_RULES');

247: begin
248: IF ( p_pos_grp1_type.supervisory_status NOT IN ('1','2')
249: AND p_pay_plan IN ('WA','WN', 'WS', 'WQ', 'XN', 'XS'))
250: THEN
251: hr_utility.set_message(8301, 'GHR_38439_POSN_RULES');
252: hr_utility.raise_error;
253: END IF;
254: end psn_supv_status_6;
255: --

Line 252: hr_utility.raise_error;

248: IF ( p_pos_grp1_type.supervisory_status NOT IN ('1','2')
249: AND p_pay_plan IN ('WA','WN', 'WS', 'WQ', 'XN', 'XS'))
250: THEN
251: hr_utility.set_message(8301, 'GHR_38439_POSN_RULES');
252: hr_utility.raise_error;
253: END IF;
254: end psn_supv_status_6;
255: --
256: procedure psn_supv_status_8

Line 266: hr_utility.set_message(8301, 'GHR_38440_POSN_RULES');

262: begin
263: IF ( p_pay_plan = 'WB'
264: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2','6','8'))
265: THEN
266: hr_utility.set_message(8301, 'GHR_38440_POSN_RULES');
267: hr_utility.raise_error;
268: END IF;
269: end psn_supv_status_8;
270: --

Line 267: hr_utility.raise_error;

263: IF ( p_pay_plan = 'WB'
264: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2','6','8'))
265: THEN
266: hr_utility.set_message(8301, 'GHR_38440_POSN_RULES');
267: hr_utility.raise_error;
268: END IF;
269: end psn_supv_status_8;
270: --
271: procedure psn_supv_status_9

Line 281: hr_utility.set_message(8301, 'GHR_38441_POSN_RULES');

277: begin
278: IF ( p_pos_grp1_type.supervisory_status <> '6'
279: AND p_pay_plan IN ( 'LL', 'LX', 'ML', 'RL', 'WL', 'XL' ))
280: THEN
281: hr_utility.set_message(8301, 'GHR_38441_POSN_RULES');
282: hr_utility.raise_error;
283: END IF;
284: end psn_supv_status_9;
285: --

Line 282: hr_utility.raise_error;

278: IF ( p_pos_grp1_type.supervisory_status <> '6'
279: AND p_pay_plan IN ( 'LL', 'LX', 'ML', 'RL', 'WL', 'XL' ))
280: THEN
281: hr_utility.set_message(8301, 'GHR_38441_POSN_RULES');
282: hr_utility.raise_error;
283: END IF;
284: end psn_supv_status_9;
285: --
286: end ghr_psn_pos_grp1_pk;