121: when no_data_found then
122: --
123: -- No assignment found for this assignment number (and full name).
124: --
125: fnd_message.set_name('PAY','PAY_34308_RTS_NO_ASG_FOUND');
126: fnd_message.raise_error;
127: --
128: when too_many_rows then
129: --
122: --
123: -- No assignment found for this assignment number (and full name).
124: --
125: fnd_message.set_name('PAY','PAY_34308_RTS_NO_ASG_FOUND');
126: fnd_message.raise_error;
127: --
128: when too_many_rows then
129: --
130: -- More than one assignment found for this assignment number.
128: when too_many_rows then
129: --
130: -- More than one assignment found for this assignment number.
131: --
132: fnd_message.set_name('PAY','PAY_34309_RTS_MANY_ASG_FOUND');
133: fnd_message.raise_error;
134: --
135: end;
136: --
129: --
130: -- More than one assignment found for this assignment number.
131: --
132: fnd_message.set_name('PAY','PAY_34309_RTS_MANY_ASG_FOUND');
133: fnd_message.raise_error;
134: --
135: end;
136: --
137: return l_assignment_id;
209: when no_data_found then
210: --
211: -- No entry found for this assignment.
212: --
213: fnd_message.set_name('PAY','PAY_34310_RTS_NO_ENT_FOUND');
214: fnd_message.set_token('ELEMENT_NAME', p_element_name);
215: fnd_message.raise_error;
216: --
217: when too_many_rows then
210: --
211: -- No entry found for this assignment.
212: --
213: fnd_message.set_name('PAY','PAY_34310_RTS_NO_ENT_FOUND');
214: fnd_message.set_token('ELEMENT_NAME', p_element_name);
215: fnd_message.raise_error;
216: --
217: when too_many_rows then
218: --
211: -- No entry found for this assignment.
212: --
213: fnd_message.set_name('PAY','PAY_34310_RTS_NO_ENT_FOUND');
214: fnd_message.set_token('ELEMENT_NAME', p_element_name);
215: fnd_message.raise_error;
216: --
217: when too_many_rows then
218: --
219: -- More thant one entry found for this assignment.
217: when too_many_rows then
218: --
219: -- More thant one entry found for this assignment.
220: --
221: fnd_message.set_name('PAY','PAY_34311_RTS_MANY_ENT_FOUND');
222: fnd_message.set_token('ELEMENT_NAME', p_element_name);
223: fnd_message.raise_error;
224: --
225: end;
218: --
219: -- More thant one entry found for this assignment.
220: --
221: fnd_message.set_name('PAY','PAY_34311_RTS_MANY_ENT_FOUND');
222: fnd_message.set_token('ELEMENT_NAME', p_element_name);
223: fnd_message.raise_error;
224: --
225: end;
226: end if;
219: -- More thant one entry found for this assignment.
220: --
221: fnd_message.set_name('PAY','PAY_34311_RTS_MANY_ENT_FOUND');
222: fnd_message.set_token('ELEMENT_NAME', p_element_name);
223: fnd_message.raise_error;
224: --
225: end;
226: end if;
227: --
236: component_name = p_component_name
237: and nvl(legislation_code, l_leg_code) = l_leg_code;
238: exception
239: when no_data_found then
240: fnd_message.set_name('PAY','PAY_33167_RCU_INV_RETRO_COMP');
241: fnd_message.raise_error;
242: end;
243: end if;
244: --
237: and nvl(legislation_code, l_leg_code) = l_leg_code;
238: exception
239: when no_data_found then
240: fnd_message.set_name('PAY','PAY_33167_RCU_INV_RETRO_COMP');
241: fnd_message.raise_error;
242: end;
243: end if;
244: --
245: -- Set the retro entry record.
925: if l_retro_assignment_id is null then
926: --
927: -- No unprocessed retro assignment is found.
928: --
929: fnd_message.set_name('PAY','PAY_34312_RTS_NO_RTA_FOUND');
930: fnd_message.raise_error;
931: --
932: end if;
933:
926: --
927: -- No unprocessed retro assignment is found.
928: --
929: fnd_message.set_name('PAY','PAY_34312_RTS_NO_RTA_FOUND');
930: fnd_message.raise_error;
931: --
932: end if;
933:
934: if p_update_or_delete_mode = g_update_mode then