DBA Data[Home] [Help]

APPS.HR_APPLICANT_DATAUPD dependencies on HR_UTILITY

Line 141: hr_utility.trace('Entering: '||l_proc);

137: l_rows_processed number;
138: --
139: BEGIN
140:
141: hr_utility.trace('Entering: '||l_proc);
142: l_rowcount := 0;
143: l_rows_processed := 0;
144: l_failed_apl := null;
145: l_failed_person_id := null;

Line 164: hr_utility.trace(' 10: locking application '||l_appl_rec.application_id);

160: --
161: -- ---------------------------------------------------------- +
162: -- Lock application record
163: -- ---------------------------------------------------------- +
164: hr_utility.trace(' 10: locking application '||l_appl_rec.application_id);
165: --
166: begin
167: per_apl_shd.lck
168: (p_application_id => l_appl_rec.application_id

Line 179: hr_utility.trace(' 20: locking PER and PTU records');

175: end;
176: -- ------------------------------------------------------------ +
177: -- Lock person records
178: -- ------------------------------------------------------------ +
179: hr_utility.trace(' 20: locking PER and PTU records');
180: --
181: open csr_lock_person(l_appl_rec.person_id, l_appl_rec.date_end);
182: fetch csr_lock_person into l_person_rec;
183: close csr_lock_person;

Line 192: hr_utility.trace(' 30: update person and ptu records');

188: close csr_lock_ptu;
189: -- ------------------------------------------------------------ +
190: -- update Person and PTU records
191: -- ------------------------------------------------------------ +
192: hr_utility.trace(' 30: update person and ptu records');
193: --
194: -- Fix for bug 4095315 starts here.
195: --
196: l_per_object_version_number := l_person_rec.object_version_number;

Line 211: hr_utility.trace(' 40: update application');

207: );
208: -- ---------------------------------------------------------- +
209: -- update the application
210: -- ---------------------------------------------------------- +
211: hr_utility.trace(' 40: update application');
212: --
213: per_apl_upd.upd
214: (p_application_id => l_appl_rec.application_id
215: ,p_object_version_number => l_appl_rec.object_version_number

Line 263: hr_utility.trace(' Leaving: '||l_proc);

259: -- Commit the changes.
260: --
261: commit;
262: --
263: hr_utility.trace(' Leaving: '||l_proc);
264: --
265: EXCEPTION
266: when TIMEOUT_ON_RESOURCE OR e_ResourceBusy then
267: -- The required resources are used by some other process.

Line 273: hr_utility.trace('Failed to process application '||l_failed_apl||

269: --
270: -- Fix for bug 4205784.comment out the following code.
271: --
272: --raise;
273: hr_utility.trace('Failed to process application '||l_failed_apl||
274: ' (person id = '||l_failed_person_id||')');
275:
276: else
277: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed to process application '||l_failed_apl||