DBA Data[Home] [Help]

APPS.OTA_FRM_NOTIF_SUBSCRIBER_SWI dependencies on HR_UTILITY

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

27: --
28: -- Other variables
29: l_proc varchar2(72) := g_package ||'create_frm_notif_sub';
30: Begin
31: hr_utility.set_location(' Entering:' || l_proc,10);
32: --
33: -- Issue a savepoint
34: --
35: savepoint create_frm_notif_sub_swi;

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

73: -- messages of any type exist in the Multiple Message List.
74: -- Also disable Multiple Message Detection.
75: --
76: p_return_status := hr_multi_message.get_return_status_disable;
77: hr_utility.set_location(' Leaving:' || l_proc,20);
78: --
79: exception
80: when hr_multi_message.error_message_exist then
81: --

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

88: -- Reset IN OUT parameters and set OUT parameters
89: --
90: p_object_version_number := null;
91: p_return_status := hr_multi_message.get_return_status_disable;
92: hr_utility.set_location(' Leaving:' || l_proc, 30);
93: when others then
94: --
95: -- When Multiple Message Detection is enabled catch
96: -- any Application specific or other unexpected

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

99: -- error.
100: --
101: rollback to create_frm_notif_sub_swi;
102: if hr_multi_message.unexpected_error_add(l_proc) then
103: hr_utility.set_location(' Leaving:' || l_proc,40);
104: raise;
105: end if;
106: --
107: -- Reset IN OUT and set OUT parameters

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

107: -- Reset IN OUT and set OUT parameters
108: --
109: p_object_version_number := null;
110: p_return_status := hr_multi_message.get_return_status_disable;
111: hr_utility.set_location(' Leaving:' || l_proc,50);
112: end create_frm_notif_sub;
113: -- ----------------------------------------------------------------------------
114: -- |----------------------< update_frm_notif_sub >---------------------|
115: -- ----------------------------------------------------------------------------

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

132: --
133: -- Other variables
134: l_proc varchar2(72) := g_package ||'update_frm_notif_sub';
135: Begin
136: hr_utility.set_location(' Entering:' || l_proc,10);
137: --
138: -- Issue a savepoint
139: --
140: savepoint update_frm_notif_sub_swi;

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

179: -- messages of any type exist in the Multiple Message List.
180: -- Also disable Multiple Message Detection.
181: --
182: p_return_status := hr_multi_message.get_return_status_disable;
183: hr_utility.set_location(' Leaving:' || l_proc,20);
184: --
185: exception
186: when hr_multi_message.error_message_exist then
187: --

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

194: -- Reset IN OUT parameters and set OUT parameters
195: --
196: p_object_version_number := l_object_version_number;
197: p_return_status := hr_multi_message.get_return_status_disable;
198: hr_utility.set_location(' Leaving:' || l_proc, 30);
199: when others then
200: --
201: -- When Multiple Message Detection is enabled catch
202: -- any Application specific or other unexpected

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

205: -- error.
206: --
207: rollback to update_frm_notif_sub_swi;
208: if hr_multi_message.unexpected_error_add(l_proc) then
209: hr_utility.set_location(' Leaving:' || l_proc,40);
210: raise;
211: end if;
212: --
213: -- Reset IN OUT and set OUT parameters

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

213: -- Reset IN OUT and set OUT parameters
214: --
215: p_object_version_number := l_object_version_number;
216: p_return_status := hr_multi_message.get_return_status_disable;
217: hr_utility.set_location(' Leaving:' || l_proc,50);
218: end update_frm_notif_sub;
219: -- ----------------------------------------------------------------------------
220: -- |----------------------< delete_frm_notif_sub >---------------------|
221: -- ----------------------------------------------------------------------------

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

235: --
236: -- Other variables
237: l_proc varchar2(72) := g_package ||'delete_frm_notif_sub';
238: Begin
239: hr_utility.set_location(' Entering:' || l_proc,10);
240: --
241: -- Issue a savepoint
242: --
243: savepoint delete_frm_notif_sub_swi;

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

279: -- messages of any type exist in the Multiple Message List.
280: -- Also disable Multiple Message Detection.
281: --
282: p_return_status := hr_multi_message.get_return_status_disable;
283: hr_utility.set_location(' Leaving:' || l_proc,20);
284: --
285: exception
286: when hr_multi_message.error_message_exist then
287: --

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

293: --
294: -- Reset IN OUT parameters and set OUT parameters
295: --
296: p_return_status := hr_multi_message.get_return_status_disable;
297: hr_utility.set_location(' Leaving:' || l_proc, 30);
298: when others then
299: --
300: -- When Multiple Message Detection is enabled catch
301: -- any Application specific or other unexpected

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

304: -- error.
305: --
306: rollback to delete_frm_notif_sub_swi;
307: if hr_multi_message.unexpected_error_add(l_proc) then
308: hr_utility.set_location(' Leaving:' || l_proc,40);
309: raise;
310: end if;
311: --
312: -- Reset IN OUT and set OUT parameters

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

311: --
312: -- Reset IN OUT and set OUT parameters
313: --
314: p_return_status := hr_multi_message.get_return_status_disable;
315: hr_utility.set_location(' Leaving:' || l_proc,50);
316: end delete_frm_notif_sub;
317: end ota_frm_notif_subscriber_swi;