DBA Data[Home] [Help]

APPS.IRC_REFERRAL_INFO_SWI dependencies on HR_UTILITY

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

71: WHERE PERSON_ID=p_object_id;
72: --
73: l_party_id number;
74: Begin
75: hr_utility.set_location(' Entering:' || l_proc,10);
76: --
77: -- Issue a savepoint
78: --
79: savepoint create_referral_info_swi;

Line 100: hr_utility.set_location(' p_object_id: '||p_object_id ,11);

96: irc_irf_ins.set_base_key_value
97: (p_referral_info_id => p_referral_info_id
98: );
99: --
100: hr_utility.set_location(' p_object_id: '||p_object_id ,11);
101: --
102: IF P_OBJECT_TYPE='PERSON' THEN
103: --
104: open csr_get_party_id;

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

172: -- messages of any type exist in the Multiple Message List.
173: -- Also disable Multiple Message Detection.
174: --
175: p_return_status := hr_multi_message.get_return_status_disable;
176: hr_utility.set_location(' Leaving:' || l_proc,20);
177: --
178: exception
179: when hr_multi_message.error_message_exist then
180: --

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

189: p_object_version_number := null;
190: p_start_date := null;
191: p_end_date := null;
192: p_return_status := hr_multi_message.get_return_status_disable;
193: hr_utility.set_location(' Leaving:' || l_proc, 30);
194: when others then
195: --
196: -- When Multiple Message Detection is enabled catch
197: -- any Application specific or other unexpected

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

200: -- error.
201: --
202: rollback to create_referral_info_swi;
203: if hr_multi_message.unexpected_error_add(l_proc) then
204: hr_utility.set_location(' Leaving:' || l_proc,40);
205: raise;
206: end if;
207: --
208: -- Reset IN OUT and set OUT parameters

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

210: p_object_version_number := null;
211: p_start_date := null;
212: p_end_date := null;
213: p_return_status := hr_multi_message.get_return_status_disable;
214: hr_utility.set_location(' Leaving:' || l_proc,50);
215: end create_referral_info;
216: -- ----------------------------------------------------------------------------
217: -- |-------------------------< update_referral_info >--------------------|
218: -- ----------------------------------------------------------------------------

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

270: --
271: -- Other variables
272: l_proc varchar2(72) := g_package ||'update_referral_info';
273: Begin
274: hr_utility.set_location(' Entering:' || l_proc,10);
275: --
276: -- Issue a savepoint
277: --
278: savepoint update_referral_info_swi;

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

352: -- messages of any type exist in the Multiple Message List.
353: -- Also disable Multiple Message Detection.
354: --
355: p_return_status := hr_multi_message.get_return_status_disable;
356: hr_utility.set_location(' Leaving:' || l_proc,20);
357: --
358: exception
359: when hr_multi_message.error_message_exist then
360: --

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

369: p_object_version_number := l_object_version_number;
370: p_start_date := null;
371: p_end_date := null;
372: p_return_status := hr_multi_message.get_return_status_disable;
373: hr_utility.set_location(' Leaving:' || l_proc, 30);
374: when others then
375: --
376: -- When Multiple Message Detection is enabled catch
377: -- any Application specific or other unexpected

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

380: -- error.
381: --
382: rollback to update_referral_info_swi;
383: if hr_multi_message.unexpected_error_add(l_proc) then
384: hr_utility.set_location(' Leaving:' || l_proc,40);
385: raise;
386: end if;
387: --
388: -- Reset IN OUT and set OUT parameters

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

390: p_object_version_number := l_object_version_number;
391: p_start_date := null;
392: p_end_date := null;
393: p_return_status := hr_multi_message.get_return_status_disable;
394: hr_utility.set_location(' Leaving:' || l_proc,50);
395: end update_referral_info;
396: ---
397: end IRC_REFERRAL_INFO_SWI;