DBA Data[Home] [Help]

APPS.GHR_PSN_POS_GRP1_PK dependencies on HR_UTILITY

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

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

Line 91: hr_utility.raise_error;

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

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

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

Line 106: hr_utility.raise_error;

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

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

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

Line 121: hr_utility.raise_error;

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

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

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

Line 136: hr_utility.raise_error;

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

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

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

Line 152: hr_utility.raise_error;

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

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

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

Line 168: hr_utility.raise_error;

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

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

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

Line 183: hr_utility.raise_error;

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

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

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

Line 189: hr_utility.raise_error;

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

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

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

Line 206: hr_utility.raise_error;

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

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

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

Line 223: hr_utility.raise_error;

219: AND p_pay_plan = 'GM'
220: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2','3','4','5','7'))
221: THEN
222: hr_utility.set_message(8301, 'GHR_38437_POSN_RULES');
223: hr_utility.raise_error;
224: END IF;
225: end psn_supv_status_4;
226: --
227: --Bug 10030595 commenting this procedure since the pay plans are no longer exists

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

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

Line 239: hr_utility.raise_error;

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

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

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

Line 254: hr_utility.raise_error;

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

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

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

Line 269: hr_utility.raise_error;

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

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

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

Line 284: hr_utility.raise_error;

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