DBA Data[Home] [Help]

APPS.IRC_PURGE_OLD_DATA_PKG dependencies on FND_MESSAGE

Line 54: ,p_last_name => fnd_message.get_string

50: ,p_datetrack_update_mode => 'CORRECTION'
51: ,p_person_id => rec_person.person_id
52: ,p_object_version_number => l_person_ovn
53: ,p_employee_number => l_employee_number
54: ,p_last_name => fnd_message.get_string
55: ('PER','IRC_412172_ANONYMOUS_NAME')
56: ,p_first_name => ''
57: ,p_known_as => ''
58: ,p_middle_names => ''

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

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

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

130: if l_usrName is null then
131: raise_application_error (-20001,'No wf role is assigned to the candidate');
132: end if;
133: --
134: fnd_message.set_name('PER','IRC_412170_PURGE_MESSAGE_TEXT');
135: fnd_message.set_token('PERSON_FULL_NAME',l_name);
136: l_message_conc_text := fnd_message.get;
137: --
138: fnd_message.set_name('PER','IRC_412171_PURGE_MESSAGE_HTML');

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

131: raise_application_error (-20001,'No wf role is assigned to the candidate');
132: end if;
133: --
134: fnd_message.set_name('PER','IRC_412170_PURGE_MESSAGE_TEXT');
135: fnd_message.set_token('PERSON_FULL_NAME',l_name);
136: l_message_conc_text := fnd_message.get;
137: --
138: fnd_message.set_name('PER','IRC_412171_PURGE_MESSAGE_HTML');
139: fnd_message.set_token('PERSON_FULL_NAME',l_name);

Line 136: l_message_conc_text := fnd_message.get;

132: end if;
133: --
134: fnd_message.set_name('PER','IRC_412170_PURGE_MESSAGE_TEXT');
135: fnd_message.set_token('PERSON_FULL_NAME',l_name);
136: l_message_conc_text := fnd_message.get;
137: --
138: fnd_message.set_name('PER','IRC_412171_PURGE_MESSAGE_HTML');
139: fnd_message.set_token('PERSON_FULL_NAME',l_name);
140: l_message_conc_html := fnd_message.get;

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

134: fnd_message.set_name('PER','IRC_412170_PURGE_MESSAGE_TEXT');
135: fnd_message.set_token('PERSON_FULL_NAME',l_name);
136: l_message_conc_text := fnd_message.get;
137: --
138: fnd_message.set_name('PER','IRC_412171_PURGE_MESSAGE_HTML');
139: fnd_message.set_token('PERSON_FULL_NAME',l_name);
140: l_message_conc_html := fnd_message.get;
141: --
142: l_nid := irc_notification_helper_pkg.send_notification(

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

135: fnd_message.set_token('PERSON_FULL_NAME',l_name);
136: l_message_conc_text := fnd_message.get;
137: --
138: fnd_message.set_name('PER','IRC_412171_PURGE_MESSAGE_HTML');
139: fnd_message.set_token('PERSON_FULL_NAME',l_name);
140: l_message_conc_html := fnd_message.get;
141: --
142: l_nid := irc_notification_helper_pkg.send_notification(
143: p_person_id => p_person_id

Line 140: l_message_conc_html := fnd_message.get;

136: l_message_conc_text := fnd_message.get;
137: --
138: fnd_message.set_name('PER','IRC_412171_PURGE_MESSAGE_HTML');
139: fnd_message.set_token('PERSON_FULL_NAME',l_name);
140: l_message_conc_html := fnd_message.get;
141: --
142: l_nid := irc_notification_helper_pkg.send_notification(
143: p_person_id => p_person_id
144: ,p_subject => l_subject