78: and (p_backpay_set_id is null))) then
79: return; -- Row successfully locked, no changes.
80: end if;
81: --
82: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
83: app_exception.raise_exception;
84: --
85: end lock_row;
86: -----------------------------------------------------------------------------
127: and db.balance_type_id = P_BALANCE_TYPE_ID
128: and br.input_value_id = P_INPUT_VALUE_ID);
129: exception
130: when NO_DATA_FOUND then
131: fnd_message.set_name('PAY', 'HR_7036_BACK_RULE_DUP');
132: fnd_message.raise_error;
133: end;
134: --
135: end std_insert_checks;
128: and br.input_value_id = P_INPUT_VALUE_ID);
129: exception
130: when NO_DATA_FOUND then
131: fnd_message.set_name('PAY', 'HR_7036_BACK_RULE_DUP');
132: fnd_message.raise_error;
133: end;
134: --
135: end std_insert_checks;
136: -----------------------------------------------------------------------------
182: group by bf1.input_value_id, bf2.balance_type_id
183: having count(0) > 1);
184: exception
185: when NO_DATA_FOUND then
186: fnd_message.set_name('PAY', 'HR_7037_BACK_RULES_DUP_BAL');
187: fnd_message.raise_error;
188: end;
189: --
190: end chk_overlap_bal_feeds;
183: having count(0) > 1);
184: exception
185: when NO_DATA_FOUND then
186: fnd_message.set_name('PAY', 'HR_7037_BACK_RULES_DUP_BAL');
187: fnd_message.raise_error;
188: end;
189: --
190: end chk_overlap_bal_feeds;
191: -----------------------------------------------------------------------------