DBA Data[Home] [Help]

APPS.PER_REC_ACTIVITY_FOR_SWI dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

128: --
129: -- Other variables
130: l_proc varchar2(72) := g_package ||'delete_rec_activity_for';
131: Begin
132: hr_utility.set_location(' Entering:' || l_proc,10);
133: --
134: -- Issue a savepoint
135: --
136: savepoint delete_rec_activity_for_swi;

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

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

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

184: --
185: -- Reset IN OUT parameters and set OUT parameters
186: --
187: p_return_status := hr_multi_message.get_return_status_disable;
188: hr_utility.set_location(' Leaving:' || l_proc, 30);
189: when others then
190: --
191: -- When Multiple Message Detection is enabled catch
192: -- any Application specific or other unexpected

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

195: -- error.
196: --
197: rollback to delete_rec_activity_for_swi;
198: if hr_multi_message.unexpected_error_add(l_proc) then
199: hr_utility.set_location(' Leaving:' || l_proc,40);
200: raise;
201: end if;
202: --
203: -- Reset IN OUT and set OUT parameters

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

202: --
203: -- Reset IN OUT and set OUT parameters
204: --
205: p_return_status := hr_multi_message.get_return_status_disable;
206: hr_utility.set_location(' Leaving:' || l_proc,50);
207: end delete_rec_activity_for;
208: -- ----------------------------------------------------------------------------
209: -- |------------------------< update_rec_activity_for >-----------------------|
210: -- ----------------------------------------------------------------------------

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

225: --
226: -- Other variables
227: l_proc varchar2(72) := g_package ||'update_rec_activity_for';
228: Begin
229: hr_utility.set_location(' Entering:' || l_proc,10);
230: --
231: -- Issue a savepoint
232: --
233: savepoint update_rec_activity_for_swi;

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

270: -- messages of any type exist in the Multiple Message List.
271: -- Also disable Multiple Message Detection.
272: --
273: p_return_status := hr_multi_message.get_return_status_disable;
274: hr_utility.set_location(' Leaving:' || l_proc,20);
275: --
276: exception
277: when hr_multi_message.error_message_exist then
278: --

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

285: -- Reset IN OUT parameters and set OUT parameters
286: --
287: p_object_version_number := l_object_version_number;
288: p_return_status := hr_multi_message.get_return_status_disable;
289: hr_utility.set_location(' Leaving:' || l_proc, 30);
290: when others then
291: --
292: -- When Multiple Message Detection is enabled catch
293: -- any Application specific or other unexpected

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

296: -- error.
297: --
298: rollback to update_rec_activity_for_swi;
299: if hr_multi_message.unexpected_error_add(l_proc) then
300: hr_utility.set_location(' Leaving:' || l_proc,40);
301: raise;
302: end if;
303: --
304: -- Reset IN OUT and set OUT parameters

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

304: -- Reset IN OUT and set OUT parameters
305: --
306: p_object_version_number := l_object_version_number;
307: p_return_status := hr_multi_message.get_return_status_disable;
308: hr_utility.set_location(' Leaving:' || l_proc,50);
309: end update_rec_activity_for;
310: --
311: -- ----------------------------------------------------------------------------
312: -- |----------------------------< process_api >-------------------------------|

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

332: l_effective_date date := trunc(sysdate);
333:
334: BEGIN
335: --
336: hr_utility.set_location(' Entering:' || l_proc,10);
337: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
338: --
339: l_parser := xmlparser.newParser;
340: xmlparser.ParseCLOB(l_parser,p_document);

Line 337: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);

333:
334: BEGIN
335: --
336: hr_utility.set_location(' Entering:' || l_proc,10);
337: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
338: --
339: l_parser := xmlparser.newParser;
340: xmlparser.ParseCLOB(l_parser,p_document);
341: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

Line 343: hr_utility.set_location('Extracting the PostState:' || l_proc,20);

339: l_parser := xmlparser.newParser;
340: xmlparser.ParseCLOB(l_parser,p_document);
341: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
342: --
343: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
344:
345: l_commitElement := xmldom.makeElement(l_CommitNode);
346: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
347: --

Line 361: hr_utility.set_location('creating :' || l_proc,30);

357: end if;
358: --
359: if l_postState = '0' then
360: --
361: hr_utility.set_location('creating :' || l_proc,30);
362: --
363: create_rec_activity_for
364: (p_validate => p_validate
365: ,p_rec_activity_for_id => l_rec_activity_for_id

Line 375: hr_utility.set_location('updating :' || l_proc,32);

371: );
372: --
373: elsif l_postState = '2' then
374: --
375: hr_utility.set_location('updating :' || l_proc,32);
376: --
377: update_rec_activity_for
378: (p_validate => p_validate
379: ,p_rec_activity_for_id => l_rec_activity_for_id

Line 388: hr_utility.set_location('deleting :' || l_proc,33);

384: );
385: --
386: elsif l_postState = '3' then
387: --
388: hr_utility.set_location('deleting :' || l_proc,33);
389: --
390: -- we completely ignore deletes here as parent
391: -- recruitment_activity.process_api removes all child
392: -- recruitment_activity_for entities. This is needed to avoid

Line 400: hr_utility.set_location

396: end if;
397:
398: p_return_status := l_return_status;
399:
400: hr_utility.set_location
401: ('Exiting :'|| l_proc || ': return status :'|| l_return_status || ':',40);
402:
403: end process_api;
404: