252: OPEN get_details(p_asg_act_id );
253: FETCH get_details INTO p_third_party_id;
254: CLOSE get_details;
255: IF p_third_party_id IS NULL THEN
256: fnd_message.set_name('PAY', 'HR_376665_FI_THIRD_PARTY_PAYEE');
257: fnd_message.set_token('NAME',hr_general.decode_lookup('FI_FORM_LABELS','COURT_ORDER'), translate => true );
258: hr_utility.raise_error;
259: END IF;
260:
253: FETCH get_details INTO p_third_party_id;
254: CLOSE get_details;
255: IF p_third_party_id IS NULL THEN
256: fnd_message.set_name('PAY', 'HR_376665_FI_THIRD_PARTY_PAYEE');
257: fnd_message.set_token('NAME',hr_general.decode_lookup('FI_FORM_LABELS','COURT_ORDER'), translate => true );
258: hr_utility.raise_error;
259: END IF;
260:
261: ELSIF l_element_name = 'Trade Union Membership Fees' THEN
263: FETCH get_union_id INTO l_third_party_id;
264: p_third_party_id:=l_third_party_id;
265: CLOSE get_union_id;
266: IF p_third_party_id IS NULL THEN
267: fnd_message.set_name('PAY', 'HR_376665_FI_THIRD_PARTY_PAYEE');
268: fnd_message.set_token('NAME',hr_general.decode_lookup('FI_FORM_LABELS','TRADE_UNION'), translate => true );
269: hr_utility.raise_error;
270: END IF;
271:
264: p_third_party_id:=l_third_party_id;
265: CLOSE get_union_id;
266: IF p_third_party_id IS NULL THEN
267: fnd_message.set_name('PAY', 'HR_376665_FI_THIRD_PARTY_PAYEE');
268: fnd_message.set_token('NAME',hr_general.decode_lookup('FI_FORM_LABELS','TRADE_UNION'), translate => true );
269: hr_utility.raise_error;
270: END IF;
271:
272: ELSIF l_element_name = 'Pension Insurance' THEN
290: CLOSE c_pension_provider_info;
291: END IF;
292:
293: IF p_third_party_id IS NULL THEN
294: fnd_message.set_name('PAY', 'HR_376665_FI_THIRD_PARTY_PAYEE');
295: fnd_message.set_token('NAME',hr_general.decode_lookup('FI_FORM_LABELS','PEN_INS'), translate => true );
296: hr_utility.raise_error;
297: END IF;
298:
291: END IF;
292:
293: IF p_third_party_id IS NULL THEN
294: fnd_message.set_name('PAY', 'HR_376665_FI_THIRD_PARTY_PAYEE');
295: fnd_message.set_token('NAME',hr_general.decode_lookup('FI_FORM_LABELS','PEN_INS'), translate => true );
296: hr_utility.raise_error;
297: END IF;
298:
299:
313:
314: END IF;
315:
316: IF p_third_party_id IS NULL THEN
317: fnd_message.set_name('PAY', 'HR_376665_FI_THIRD_PARTY_PAYEE');
318: fnd_message.set_token('NAME',hr_general.decode_lookup('FI_FORM_LABELS','ACC_INS'), translate => true );
319: hr_utility.raise_error;
320: END IF;
321:
314: END IF;
315:
316: IF p_third_party_id IS NULL THEN
317: fnd_message.set_name('PAY', 'HR_376665_FI_THIRD_PARTY_PAYEE');
318: fnd_message.set_token('NAME',hr_general.decode_lookup('FI_FORM_LABELS','ACC_INS'), translate => true );
319: hr_utility.raise_error;
320: END IF;
321:
322: EXCEPTION