158: end if;
159: --
160: Exception
161: when invalid_status_stnd then
162: fnd_message.set_name('PAY', 'PAY_33697_SPR_STND_MISMATCH');
163: l_message := fnd_message.get;
164: hr_data_pump.fail('get_assignment_status_type_id', l_message);
165: raise;
166: when invalid_status_badjust then
159: --
160: Exception
161: when invalid_status_stnd then
162: fnd_message.set_name('PAY', 'PAY_33697_SPR_STND_MISMATCH');
163: l_message := fnd_message.get;
164: hr_data_pump.fail('get_assignment_status_type_id', l_message);
165: raise;
166: when invalid_status_badjust then
167: fnd_message.set_name('PAY', 'PAY_33698_SPR_BADJUST_MISMATCH');
163: l_message := fnd_message.get;
164: hr_data_pump.fail('get_assignment_status_type_id', l_message);
165: raise;
166: when invalid_status_badjust then
167: fnd_message.set_name('PAY', 'PAY_33698_SPR_BADJUST_MISMATCH');
168: l_message := fnd_message.get;
169: hr_data_pump.fail('get_assignment_status_type_id', l_message);
170: raise;
171: when others then
164: hr_data_pump.fail('get_assignment_status_type_id', l_message);
165: raise;
166: when invalid_status_badjust then
167: fnd_message.set_name('PAY', 'PAY_33698_SPR_BADJUST_MISMATCH');
168: l_message := fnd_message.get;
169: hr_data_pump.fail('get_assignment_status_type_id', l_message);
170: raise;
171: when others then
172: hr_data_pump.fail('get_assignment_status_type_id', sqlerrm, p_assignment_status,