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;
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;
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
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:
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,
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;
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: --
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: --