224: FETCH person_name_csr INTO l_person_name;
225: CLOSE person_name_csr;
226:
227: -- Set message parameters
228: fnd_message.set_name('HRI', p_message);
229: fnd_message.set_token('DATE',to_char(p_effective_date, 'YYYY/MM/DD'));
230: fnd_message.set_token('PERSON_NAME',l_person_name);
231:
232: -- Get the message and return it
225: CLOSE person_name_csr;
226:
227: -- Set message parameters
228: fnd_message.set_name('HRI', p_message);
229: fnd_message.set_token('DATE',to_char(p_effective_date, 'YYYY/MM/DD'));
230: fnd_message.set_token('PERSON_NAME',l_person_name);
231:
232: -- Get the message and return it
233: RETURN fnd_message.get;
226:
227: -- Set message parameters
228: fnd_message.set_name('HRI', p_message);
229: fnd_message.set_token('DATE',to_char(p_effective_date, 'YYYY/MM/DD'));
230: fnd_message.set_token('PERSON_NAME',l_person_name);
231:
232: -- Get the message and return it
233: RETURN fnd_message.get;
234:
229: fnd_message.set_token('DATE',to_char(p_effective_date, 'YYYY/MM/DD'));
230: fnd_message.set_token('PERSON_NAME',l_person_name);
231:
232: -- Get the message and return it
233: RETURN fnd_message.get;
234:
235: END get_sup_loop_message;
236:
237: