APPS.PAY_WC_STATE_SURCHARGES_PKG dependencies on HR_UTILITY

Line 194: hr_utility.set_message(801, 'PAY_7362_WC_NAME_NOT_UNIQUE');

190: CLOSE chk_name;
191: --
192: IF (l_unique = 'N')
193: THEN
194: hr_utility.set_message(801, 'PAY_7362_WC_NAME_NOT_UNIQUE');
195: hr_utility.raise_error;
196: END IF;
197: --
198: OPEN chk_position;

Line 195: hr_utility.raise_error;

191: --
192: IF (l_unique = 'N')
193: THEN
194: hr_utility.set_message(801, 'PAY_7362_WC_NAME_NOT_UNIQUE');
195: hr_utility.raise_error;
196: END IF;
197: --
198: OPEN chk_position;
199: FETCH chk_position INTO l_unique;

Line 204: hr_utility.set_message(801, 'PAY_7363_WC_POS_NOT_UNIQUE');

200: CLOSE chk_position;
201: --
202: IF (l_unique = 'N')
203: THEN
204: hr_utility.set_message(801, 'PAY_7363_WC_POS_NOT_UNIQUE');
205: hr_utility.raise_error;
206: END IF;
207: --
208: END check_unique;

Line 205: hr_utility.raise_error;

201: --
202: IF (l_unique = 'N')
203: THEN
204: hr_utility.set_message(801, 'PAY_7363_WC_POS_NOT_UNIQUE');
205: hr_utility.raise_error;
206: END IF;
207: --
208: END check_unique;
209:

Line 244: hr_utility.set_message(801, 'PAY_7365_WC_DEL_POS_2_FIRST');

240: CLOSE chk_position;
241: --
242: IF (l_position_exists = 'Y')
243: THEN
244: hr_utility.set_message(801, 'PAY_7365_WC_DEL_POS_2_FIRST');
245: hr_utility.raise_error;
246: END IF;
247: END IF;
248: --

Line 245: hr_utility.raise_error;

241: --
242: IF (l_position_exists = 'Y')
243: THEN
244: hr_utility.set_message(801, 'PAY_7365_WC_DEL_POS_2_FIRST');
245: hr_utility.raise_error;
246: END IF;
247: END IF;
248: --
249: ELSIF (p_event IN ('INSERT', 'UPDATE') )

Line 260: hr_utility.set_message(801, 'PAY_7364_WC_WC_INS_POS_1_FIRST');

256: FETCH chk_position INTO l_position_exists;
257: CLOSE chk_position;
258: IF (l_position_exists = 'N')
259: THEN
260: hr_utility.set_message(801, 'PAY_7364_WC_WC_INS_POS_1_FIRST');
261: hr_utility.raise_error;
262: END IF;
263: END IF;
264: --

Line 261: hr_utility.raise_error;

257: CLOSE chk_position;
258: IF (l_position_exists = 'N')
259: THEN
260: hr_utility.set_message(801, 'PAY_7364_WC_WC_INS_POS_1_FIRST');
261: hr_utility.raise_error;
262: END IF;
263: END IF;
264: --
265: ELSE

Line 266: hr_utility.raise_error;

262: END IF;
263: END IF;
264: --
265: ELSE
266: hr_utility.raise_error;
267: END IF;
268: --
269: END check_position;
270: