DBA Data[Home] [Help]

APPS.PAY_RESTRICT_VAL_PKG dependencies on HR_UTILITY

Line 41: HR_UTILITY.SET_MESSAGE('801','HR_6028_CUST_UNIQUE_PARAMETER');

37: OPEN C_UNIQUENESS;
38: FETCH C_UNIQUENESS INTO L_DUMMY1;
39: IF C_UNIQUENESS%FOUND THEN
40: CLOSE C_UNIQUENESS;
41: HR_UTILITY.SET_MESSAGE('801','HR_6028_CUST_UNIQUE_PARAMETER');
42: HR_UTILITY.RAISE_ERROR;
43: ELSE
44: /* check to ensure that only one value can bo allowed for same
45: restriction code if multiple restriction flag is 'N' */

Line 42: HR_UTILITY.RAISE_ERROR;

38: FETCH C_UNIQUENESS INTO L_DUMMY1;
39: IF C_UNIQUENESS%FOUND THEN
40: CLOSE C_UNIQUENESS;
41: HR_UTILITY.SET_MESSAGE('801','HR_6028_CUST_UNIQUE_PARAMETER');
42: HR_UTILITY.RAISE_ERROR;
43: ELSE
44: /* check to ensure that only one value can bo allowed for same
45: restriction code if multiple restriction flag is 'N' */
46: CLOSE C_UNIQUENESS;

Line 51: HR_UTILITY.SET_MESSAGE('801','HR_6921_CUST_MULTI_RESTRICT');

47: OPEN C_MULTIPLE_RES;
48: FETCH C_MULTIPLE_RES INTO L_DUMMY2;
49: IF C_MULTIPLE_RES%FOUND THEN
50: CLOSE C_MULTIPLE_RES;
51: HR_UTILITY.SET_MESSAGE('801','HR_6921_CUST_MULTI_RESTRICT');
52: HR_UTILITY.RAISE_ERROR;
53: ELSE
54: CLOSE C_MULTIPLE_RES;
55: NULL;

Line 52: HR_UTILITY.RAISE_ERROR;

48: FETCH C_MULTIPLE_RES INTO L_DUMMY2;
49: IF C_MULTIPLE_RES%FOUND THEN
50: CLOSE C_MULTIPLE_RES;
51: HR_UTILITY.SET_MESSAGE('801','HR_6921_CUST_MULTI_RESTRICT');
52: HR_UTILITY.RAISE_ERROR;
53: ELSE
54: CLOSE C_MULTIPLE_RES;
55: NULL;
56: END IF;

Line 332: hr_utility.raise_error;

328: OPEN C_QH_NEW;
329: FETCH C_QH_NEW INTO P_VALUE_MEANING;
330: CLOSE C_QH_NEW;
331: ELSE
332: hr_utility.raise_error;
333: END IF;
334: END POST_QUERY;
335: ------------------------------------------------------------------------------
336: FUNCTION DOWNLOAD_VALUE(P_RESTRICTION_CODE IN VARCHAR2,