DBA Data[Home] [Help]

APPS.PQH_DOCUMENTS_WRAPPER dependencies on HR_UTILITY

Line 94: hr_utility.set_location(' Entering:' || l_proc,10);

90: l_future_versions VARCHAR2(100);
91: l_eff_disp_date date:= null;
92: l_max_future_end_dt date := null;
93: Begin
94: hr_utility.set_location(' Entering:' || l_proc,10);
95: --
96: -- Issue a savepoint
97: --
98: savepoint delete_document_swi;

Line 174: hr_utility.set_location(' p_effective_start_date' ||p_effective_start_date,21);

170: ,p_object_version_number => l_ovn
171: ,p_effective_start_date => p_effective_start_date
172: ,p_effective_end_date => p_effective_end_date
173: );
174: hr_utility.set_location(' p_effective_start_date' ||p_effective_start_date,21);
175: hr_utility.set_location(' p_effective_end_date' ||p_effective_end_date,21);
176: end loop;
177: --
178: --

Line 175: hr_utility.set_location(' p_effective_end_date' ||p_effective_end_date,21);

171: ,p_effective_start_date => p_effective_start_date
172: ,p_effective_end_date => p_effective_end_date
173: );
174: hr_utility.set_location(' p_effective_start_date' ||p_effective_start_date,21);
175: hr_utility.set_location(' p_effective_end_date' ||p_effective_end_date,21);
176: end loop;
177: --
178: --
179: ELSIF ( p_datetrack_mode = 'ZAP' ) THEN

Line 195: hr_utility.set_location(' p_effective_start_date' ||p_effective_start_date,21);

191: ,p_object_version_number => l_ovn
192: ,p_effective_start_date => p_effective_start_date
193: ,p_effective_end_date => p_effective_end_date
194: );
195: hr_utility.set_location(' p_effective_start_date' ||p_effective_start_date,21);
196: hr_utility.set_location(' p_effective_end_date' ||p_effective_end_date,21);
197: end loop;
198:
199: ELSIF ( p_datetrack_mode = 'FUTURE_CHANGE' ) THEN

Line 196: hr_utility.set_location(' p_effective_end_date' ||p_effective_end_date,21);

192: ,p_effective_start_date => p_effective_start_date
193: ,p_effective_end_date => p_effective_end_date
194: );
195: hr_utility.set_location(' p_effective_start_date' ||p_effective_start_date,21);
196: hr_utility.set_location(' p_effective_end_date' ||p_effective_end_date,21);
197: end loop;
198:
199: ELSIF ( p_datetrack_mode = 'FUTURE_CHANGE' ) THEN
200: For docAttributeCsr in csr_child_attributes

Line 255: hr_utility.set_location(' Leaving:' || l_proc,20);

251: -- messages of any type exist in the Multiple Message List.
252: -- Also disable Multiple Message Detection.
253: --
254: p_return_status := hr_multi_message.get_return_status_disable;
255: hr_utility.set_location(' Leaving:' || l_proc,20);
256: --
257: exception
258: when hr_multi_message.error_message_exist then
259: --

Line 272: hr_utility.set_location(' Leaving:' || l_proc, 30);

268: p_object_version_number := l_object_version_number;
269: p_effective_start_date := null;
270: p_effective_end_date := null;
271: p_return_status := hr_multi_message.get_return_status_disable;
272: hr_utility.set_location(' Leaving:' || l_proc, 30);
273: when others then
274: --
275: -- When Multiple Message Detection is enabled catch
276: -- any Application specific or other unexpected

Line 283: hr_utility.set_location(' Leaving:' || l_proc,40);

279: -- error.
280: --
281: rollback to delete_document_swi;
282: if hr_multi_message.unexpected_error_add(l_proc) then
283: hr_utility.set_location(' Leaving:' || l_proc,40);
284: raise;
285: end if;
286: --
287: -- Reset IN OUT and set OUT parameters

Line 293: hr_utility.set_location(' Leaving:' || l_proc,50);

289: p_object_version_number := l_object_version_number;
290: p_effective_start_date := null;
291: p_effective_end_date := null;
292: p_return_status := hr_multi_message.get_return_status_disable;
293: hr_utility.set_location(' Leaving:' || l_proc,50);
294: end delete_document;
295: --
296: end pqh_documents_wrapper;