DBA Data[Home] [Help]

APPS.IRC_PURGE_OLD_DATA_PKG dependencies on FND_MESSAGE

Line 50: if(l_last_name <> fnd_message.get_string('PER','IRC_412172_ANONYMOUS_NAME')) then

46: l_employee_number := rec_person.employee_number;
47: l_last_name := rec_person.last_name;
48: --
49: /* call to hr_person_api.update_person to set the names to Anonymous */
50: if(l_last_name <> fnd_message.get_string('PER','IRC_412172_ANONYMOUS_NAME')) then
51: hr_person_api.update_person
52: (
53: p_effective_date => rec_person.effective_start_date
54: ,p_datetrack_update_mode => 'CORRECTION'

Line 58: ,p_last_name => fnd_message.get_string

54: ,p_datetrack_update_mode => 'CORRECTION'
55: ,p_person_id => rec_person.person_id
56: ,p_object_version_number => l_person_ovn
57: ,p_employee_number => l_employee_number
58: ,p_last_name => fnd_message.get_string
59: ('PER','IRC_412172_ANONYMOUS_NAME')
60: ,p_first_name => ''
61: ,p_known_as => ''
62: ,p_middle_names => ''

Line 106: fnd_message.get_string('PER','IRC_412169_PURGE_SUBJECT');

102: ) is
103: --
104: l_proc varchar2(72) := 'send_notification_to_person';
105: l_subject fnd_new_messages.message_text%type :=
106: fnd_message.get_string('PER','IRC_412169_PURGE_SUBJECT');
107: l_nid number;
108: l_name per_all_people_f.full_name%type;
109: l_message_conc_html varchar2(15600);
110: l_message_conc_text varchar2(15600);

Line 130: if l_last_name = fnd_message.get_string('PER','IRC_412172_ANONYMOUS_NAME') then

126: hr_utility.set_location('Entering Send Notification to Person:'||l_proc, 10);
127: open csr_name;
128: fetch csr_name into l_name,l_last_name;
129: close csr_name;
130: if l_last_name = fnd_message.get_string('PER','IRC_412172_ANONYMOUS_NAME') then
131: return;
132: end if;
133: --
134: open csr_getfnduser(p_person_id);

Line 141: fnd_message.set_name('PER','IRC_412170_PURGE_MESSAGE_TEXT');

137: if l_usrName is null then
138: raise_application_error (-20001,'No wf role is assigned to the candidate');
139: end if;
140: --
141: fnd_message.set_name('PER','IRC_412170_PURGE_MESSAGE_TEXT');
142: fnd_message.set_token('PERSON_FULL_NAME',l_name);
143: l_message_conc_text := fnd_message.get;
144: --
145: fnd_message.set_name('PER','IRC_412171_PURGE_MESSAGE_HTML');

Line 142: fnd_message.set_token('PERSON_FULL_NAME',l_name);

138: raise_application_error (-20001,'No wf role is assigned to the candidate');
139: end if;
140: --
141: fnd_message.set_name('PER','IRC_412170_PURGE_MESSAGE_TEXT');
142: fnd_message.set_token('PERSON_FULL_NAME',l_name);
143: l_message_conc_text := fnd_message.get;
144: --
145: fnd_message.set_name('PER','IRC_412171_PURGE_MESSAGE_HTML');
146: fnd_message.set_token('PERSON_FULL_NAME',l_name);

Line 143: l_message_conc_text := fnd_message.get;

139: end if;
140: --
141: fnd_message.set_name('PER','IRC_412170_PURGE_MESSAGE_TEXT');
142: fnd_message.set_token('PERSON_FULL_NAME',l_name);
143: l_message_conc_text := fnd_message.get;
144: --
145: fnd_message.set_name('PER','IRC_412171_PURGE_MESSAGE_HTML');
146: fnd_message.set_token('PERSON_FULL_NAME',l_name);
147: l_message_conc_html := fnd_message.get;

Line 145: fnd_message.set_name('PER','IRC_412171_PURGE_MESSAGE_HTML');

141: fnd_message.set_name('PER','IRC_412170_PURGE_MESSAGE_TEXT');
142: fnd_message.set_token('PERSON_FULL_NAME',l_name);
143: l_message_conc_text := fnd_message.get;
144: --
145: fnd_message.set_name('PER','IRC_412171_PURGE_MESSAGE_HTML');
146: fnd_message.set_token('PERSON_FULL_NAME',l_name);
147: l_message_conc_html := fnd_message.get;
148: --
149: l_nid := irc_notification_helper_pkg.send_notification(

Line 146: fnd_message.set_token('PERSON_FULL_NAME',l_name);

142: fnd_message.set_token('PERSON_FULL_NAME',l_name);
143: l_message_conc_text := fnd_message.get;
144: --
145: fnd_message.set_name('PER','IRC_412171_PURGE_MESSAGE_HTML');
146: fnd_message.set_token('PERSON_FULL_NAME',l_name);
147: l_message_conc_html := fnd_message.get;
148: --
149: l_nid := irc_notification_helper_pkg.send_notification(
150: p_person_id => p_person_id

Line 147: l_message_conc_html := fnd_message.get;

143: l_message_conc_text := fnd_message.get;
144: --
145: fnd_message.set_name('PER','IRC_412171_PURGE_MESSAGE_HTML');
146: fnd_message.set_token('PERSON_FULL_NAME',l_name);
147: l_message_conc_html := fnd_message.get;
148: --
149: l_nid := irc_notification_helper_pkg.send_notification(
150: p_person_id => p_person_id
151: ,p_subject => l_subject