DBA Data[Home] [Help]

APPS.IRC_APL_TRACK_PURGE_PKG dependencies on HR_UTILITY

Line 135: hr_utility.set_location('Entering Purge Records:'||l_proc, 10);

131: --
132: --
133: begin
134: --
135: hr_utility.set_location('Entering Purge Records:'||l_proc, 10);
136: hr_utility.set_location('Delete Applicant Profile Snapshot:'||l_proc, 20);
137:
138:
139:

Line 136: hr_utility.set_location('Delete Applicant Profile Snapshot:'||l_proc, 20);

132: --
133: begin
134: --
135: hr_utility.set_location('Entering Purge Records:'||l_proc, 10);
136: hr_utility.set_location('Delete Applicant Profile Snapshot:'||l_proc, 20);
137:
138:
139:
140: --To Print the Log For the Applicant Profile Snapshot deletion

Line 152: hr_utility.set_location('Print Delete Snapshot:'||l_proc,25);

148: ,p_profile_snapshot_id => rec_apl_profile_snapshot.profile_snapshot_id
149: ,p_object_version_number => rec_apl_profile_snapshot.object_version_number
150: );
151: --
152: hr_utility.set_location('Print Delete Snapshot:'||l_proc,25);
153: l_print_info := rpad(nvl(to_char(rec_apl_profile_snapshot.profile_snapshot_id),' '),20) ||
154: rpad(nvl(to_char(rec_apl_profile_snapshot.person_id),' '),10);
155: --
156: fnd_file.put_line(fnd_file.log,l_print_info);

Line 161: hr_utility.set_location('Delete Applicant Document Snapshot:'||l_proc, 30);

157:
158: End loop;
159: --
160:
161: hr_utility.set_location('Delete Applicant Document Snapshot:'||l_proc, 30);
162:
163: --To Print the Log For the Document Snapshot deletion
164: irc_apl_track_purge_pkg.print_log_msg(p_print_process => 'DOC');
165: --

Line 179: hr_utility.set_location('Print Delete Document:'||l_proc,35);

175: ,p_type => rec_apl_doc_snapshot.type
176: ,p_purge => l_doc_purge
177: );
178: --
179: hr_utility.set_location('Print Delete Document:'||l_proc,35);
180: l_print_info := rpad(nvl(to_char(rec_apl_doc_snapshot.document_id),' '),20) ||
181: rpad(nvl(to_char(rec_apl_doc_snapshot.person_id),' '),10);
182: --
183: fnd_file.put_line(fnd_file.log,l_print_info);

Line 187: hr_utility.set_location('Delete Saved Search Criteria:'||l_proc, 40);

183: fnd_file.put_line(fnd_file.log,l_print_info);
184: End loop;
185: --
186:
187: hr_utility.set_location('Delete Saved Search Criteria:'||l_proc, 40);
188:
189: --To Print the Log For the Saved Search Criteria deletion
190: irc_apl_track_purge_pkg.print_log_msg(p_print_process => 'SRC');
191: --

Line 200: hr_utility.set_location('Print Delete Search Criteria:'||l_proc,45);

196: ,p_saved_search_criteria_id => rec_saved_search_criteria.saved_search_criteria_id
197: ,p_object_version_number => rec_saved_search_criteria.object_version_number
198: );
199: --
200: hr_utility.set_location('Print Delete Search Criteria:'||l_proc,45);
201: l_print_info := rpad(nvl(to_char(rec_saved_search_criteria.saved_search_criteria_id),' '),30) ||
202: rpad(nvl(to_char(rec_saved_search_criteria.vacancy_id),' '),10);
203: --
204: fnd_file.put_line(fnd_file.log,l_print_info);

Line 208: hr_utility.set_location('Delete Applicant Profile Access:'||l_proc, 50);

204: fnd_file.put_line(fnd_file.log,l_print_info);
205: End loop;
206: --
207:
208: hr_utility.set_location('Delete Applicant Profile Access:'||l_proc, 50);
209:
210: --To Print the Log For the Applicant Profile Access deletion
211: irc_apl_track_purge_pkg.print_log_msg(p_print_process => 'ACC');
212: --

Line 221: hr_utility.set_location('Print Delete PROFILE ACCESS:'||l_proc,55);

217: ,p_apl_profile_access_id => rec_apl_profile_access.apl_profile_access_id
218: ,p_object_version_number => rec_apl_profile_access.object_version_number
219: );
220: --
221: hr_utility.set_location('Print Delete PROFILE ACCESS:'||l_proc,55);
222: l_print_info := rpad(nvl(to_char(rec_apl_profile_access.apl_profile_access_id),' '),30) ||
223: rpad(nvl(to_char(rec_apl_profile_access.person_id),' '),10);
224: --
225: fnd_file.put_line(fnd_file.log,l_print_info);

Line 229: hr_utility.set_location('Leaving Purge Records:'||l_proc, 100);

225: fnd_file.put_line(fnd_file.log,l_print_info);
226: End loop;
227: --
228:
229: hr_utility.set_location('Leaving Purge Records:'||l_proc, 100);
230:
231: end purge_records;
232: --
233: -- ----------------------------------------------------------------------------

Line 245: hr_utility.set_location('Entering Purge Record Process:'||l_proc, 10);

241: l_proc varchar2(72) := g_package ||'purge_record_process';
242: --
243: begin
244: --
245: hr_utility.set_location('Entering Purge Record Process:'||l_proc, 10);
246: --
247: irc_apl_track_purge_pkg.purge_records
248: (p_months => p_months
249: );

Line 253: hr_utility.set_location('Leaving Purge Record Process:'||l_proc, 70);

249: );
250: --
251: retcode := 0;
252: --
253: hr_utility.set_location('Leaving Purge Record Process:'||l_proc, 70);
254:
255: exception
256: when others then
257: --

Line 258: hr_utility.set_location('Leaving Purge Record Process:'||l_proc, 80);

254:
255: exception
256: when others then
257: --
258: hr_utility.set_location('Leaving Purge Record Process:'||l_proc, 80);
259: rollback;
260: --
261: -- Set the return parameters to indicate failure
262: --