DBA Data[Home] [Help]

APPS.PAY_GRADE_RULES_PKG dependencies on HR_UTILITY

Line 38: HR_UTILITY.SET_MESSAGE('801','PAY_6701_DEF_GRD_RULE_EXISTS');

34:
35: IF G1%FOUND THEN
36: CLOSE G1;
37: IF P_RATE_TYPE = 'G' THEN
38: HR_UTILITY.SET_MESSAGE('801','PAY_6701_DEF_GRD_RULE_EXISTS');
39: HR_UTILITY.RAISE_ERROR;
40: ELSE
41: HR_UTILITY.SET_MESSAGE('801','PAY_6705_DEF_RATE_POINT_EXISTS');
42: HR_UTILITY.RAISE_ERROR;

Line 39: HR_UTILITY.RAISE_ERROR;

35: IF G1%FOUND THEN
36: CLOSE G1;
37: IF P_RATE_TYPE = 'G' THEN
38: HR_UTILITY.SET_MESSAGE('801','PAY_6701_DEF_GRD_RULE_EXISTS');
39: HR_UTILITY.RAISE_ERROR;
40: ELSE
41: HR_UTILITY.SET_MESSAGE('801','PAY_6705_DEF_RATE_POINT_EXISTS');
42: HR_UTILITY.RAISE_ERROR;
43: END IF;

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

37: IF P_RATE_TYPE = 'G' THEN
38: HR_UTILITY.SET_MESSAGE('801','PAY_6701_DEF_GRD_RULE_EXISTS');
39: HR_UTILITY.RAISE_ERROR;
40: ELSE
41: HR_UTILITY.SET_MESSAGE('801','PAY_6705_DEF_RATE_POINT_EXISTS');
42: HR_UTILITY.RAISE_ERROR;
43: END IF;
44:
45: ELSE

Line 42: HR_UTILITY.RAISE_ERROR;

38: HR_UTILITY.SET_MESSAGE('801','PAY_6701_DEF_GRD_RULE_EXISTS');
39: HR_UTILITY.RAISE_ERROR;
40: ELSE
41: HR_UTILITY.SET_MESSAGE('801','PAY_6705_DEF_RATE_POINT_EXISTS');
42: HR_UTILITY.RAISE_ERROR;
43: END IF;
44:
45: ELSE
46:

Line 90: hr_utility.set_location('pay_grade_rules_pkg.pop_flds',1);

86: and r.business_group_id + 0 = p_bgroup_id;
87: --
88: begin
89: --
90: hr_utility.set_location('pay_grade_rules_pkg.pop_flds',1);
91: --
92: open c10;
93: --
94: fetch c10 into p_name,

Line 465: hr_utility.set_location('per_grade_rules_pkg.chk_emp_asgmnt_bef_del', 1);

461: and psp.parent_spine_id = p_parent_spine_id;
462:
463: begin
464: --
465: hr_utility.set_location('per_grade_rules_pkg.chk_emp_asgmnt_bef_del', 1);
466: --
467: -- Start of fix 3774889
468: /*
469: open emp_asgmnt_point;

Line 472: hr_utility.set_message(800, 'PER_289570_ASGMNT_POINT_VALUE');

468: /*
469: open emp_asgmnt_point;
470: fetch emp_asgmnt_point into l_exists;
471: IF emp_asgmnt_point%found THEN
472: hr_utility.set_message(800, 'PER_289570_ASGMNT_POINT_VALUE');
473: close emp_asgmnt_point;
474: hr_utility.raise_error;
475: END IF;
476: --

Line 474: hr_utility.raise_error;

470: fetch emp_asgmnt_point into l_exists;
471: IF emp_asgmnt_point%found THEN
472: hr_utility.set_message(800, 'PER_289570_ASGMNT_POINT_VALUE');
473: close emp_asgmnt_point;
474: hr_utility.raise_error;
475: END IF;
476: --
477: close emp_asgmnt_point;
478: --