261: between nvl(p_start_date, ppa.effective_date) and p_effective_date
262: and ppa.action_type in ('R', 'Q', 'B', 'I', 'V');
263: end if;
264: else
265: fnd_message.set_name('PAY', 'PAY_JP_INV_DIMENSION_LEVEL');
266: fnd_message.set_token('DIMENSION_LEVEL', p_dimension_level);
267: fnd_message.raise_error;
268: end if;
269: --
262: and ppa.action_type in ('R', 'Q', 'B', 'I', 'V');
263: end if;
264: else
265: fnd_message.set_name('PAY', 'PAY_JP_INV_DIMENSION_LEVEL');
266: fnd_message.set_token('DIMENSION_LEVEL', p_dimension_level);
267: fnd_message.raise_error;
268: end if;
269: --
270: return l_assignment_action_id;
263: end if;
264: else
265: fnd_message.set_name('PAY', 'PAY_JP_INV_DIMENSION_LEVEL');
266: fnd_message.set_token('DIMENSION_LEVEL', p_dimension_level);
267: fnd_message.raise_error;
268: end if;
269: --
270: return l_assignment_action_id;
271: exception
341: and ppa.time_period_id = l_assignment_rec.time_period_id
342: and ppa.effective_date <= p_effective_date
343: and ppa.action_type in ('R', 'Q', 'B', 'I', 'V');
344: else
345: fnd_message.set_name('PAY', 'PAY_JP_INV_DIMENSION_LEVEL');
346: fnd_message.set_token('DIMENSION_LEVEL', p_dimension_level);
347: fnd_message.raise_error;
348: end if;
349: exception
342: and ppa.effective_date <= p_effective_date
343: and ppa.action_type in ('R', 'Q', 'B', 'I', 'V');
344: else
345: fnd_message.set_name('PAY', 'PAY_JP_INV_DIMENSION_LEVEL');
346: fnd_message.set_token('DIMENSION_LEVEL', p_dimension_level);
347: fnd_message.raise_error;
348: end if;
349: exception
350: when no_data_found then
343: and ppa.action_type in ('R', 'Q', 'B', 'I', 'V');
344: else
345: fnd_message.set_name('PAY', 'PAY_JP_INV_DIMENSION_LEVEL');
346: fnd_message.set_token('DIMENSION_LEVEL', p_dimension_level);
347: fnd_message.raise_error;
348: end if;
349: exception
350: when no_data_found then
351: return null;