DBA Data[Home] [Help]

APPS.IRC_REC_TEAM_MEMBERS_SWI dependencies on HR_UTILITY

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

31: --
32: -- Other variables
33: l_proc varchar2(72) := g_package ||'create_rec_team_member';
34: Begin
35: hr_utility.set_location(' Entering:' || l_proc,10);
36: --
37: -- Issue a savepoint
38: --
39: savepoint create_rec_team_member_swi;

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

84: -- messages of any type exist in the Multiple Message List.
85: -- Also disable Multiple Message Detection.
86: --
87: p_return_status := hr_multi_message.get_return_status_disable;
88: hr_utility.set_location(' Leaving:' || l_proc,20);
89: --
90: exception
91: when hr_multi_message.error_message_exist then
92: --

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

99: -- Reset IN OUT paramters and set OUT parameters
100: --
101: p_object_version_number := null;
102: p_return_status := hr_multi_message.get_return_status_disable;
103: hr_utility.set_location(' Leaving:' || l_proc,30);
104: when others then
105: --
106: -- When Multiple Message Detection is enabled catch
107: -- any Application specific or other unexpected

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

110: -- the error.
111: --
112: rollback to create_rec_team_member_swi;
113: if hr_multi_message.unexpected_error_add(l_proc) then
114: hr_utility.set_location(' Leaving:' || l_proc, 40);
115: raise;
116: end if;
117: --
118: -- Reset IN OUT parameters and set OUT parameters

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

118: -- Reset IN OUT parameters and set OUT parameters
119: --
120: p_object_version_number := null;
121: p_return_status := hr_multi_message.get_return_status_disable;
122: hr_utility.set_location(' Leaving: ' || l_proc, 50);
123: end create_rec_team_member;
124: -- ----------------------------------------------------------------------------
125: -- |------------------------< delete_rec_team_member >------------------------|
126: -- ----------------------------------------------------------------------------

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

145: from irc_rec_team_members
146: where rec_team_member_id = p_rec_team_member_id;
147:
148: Begin
149: hr_utility.set_location(' Entering:' || l_proc,10);
150: --
151: -- Issue a savepoint
152: --
153: savepoint delete_rec_team_member_swi;

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

194: -- messages of any type exist in the Multiple Message List.
195: -- Also disable Multiple Message Detection.
196: --
197: p_return_status := hr_multi_message.get_return_status_disable;
198: hr_utility.set_location(' Leaving:' || l_proc,20);
199: --
200: exception
201: when hr_multi_message.error_message_exist then
202: --

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

208: --
209: -- Reset IN OUT paramters and set OUT parameters
210: --
211: p_return_status := hr_multi_message.get_return_status_disable;
212: hr_utility.set_location(' Leaving:' || l_proc,30);
213: when others then
214: --
215: -- When Multiple Message Detection is enabled catch
216: -- any Application specific or other unexpected

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

219: -- the error.
220: --
221: rollback to delete_rec_team_member_swi;
222: if hr_multi_message.unexpected_error_add(l_proc) then
223: hr_utility.set_location(' Leaving:' || l_proc, 40);
224: raise;
225: end if;
226: --
227: -- Reset IN OUT parameters and set OUT parameters

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

226: --
227: -- Reset IN OUT parameters and set OUT parameters
228: --
229: p_return_status := hr_multi_message.get_return_status_disable;
230: hr_utility.set_location(' Leaving: ' || l_proc, 50);
231: end delete_rec_team_member;
232: -- ----------------------------------------------------------------------------
233: -- |------------------------< update_rec_team_member >------------------------|
234: -- ----------------------------------------------------------------------------

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

256: --
257: -- Other variables
258: l_proc varchar2(72) := g_package ||'update_rec_team_member';
259: Begin
260: hr_utility.set_location(' Entering:' || l_proc,10);
261: --
262: -- Issue a savepoint
263: --
264: savepoint update_rec_team_member_swi;

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

308: -- messages of any type exist in the Multiple Message List.
309: -- Also disable Multiple Message Detection.
310: --
311: p_return_status := hr_multi_message.get_return_status_disable;
312: hr_utility.set_location(' Leaving:' || l_proc,20);
313: --
314: exception
315: when hr_multi_message.error_message_exist then
316: --

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

323: -- Reset IN OUT paramters and set OUT parameters
324: --
325: p_object_version_number := l_object_version_number;
326: p_return_status := hr_multi_message.get_return_status_disable;
327: hr_utility.set_location(' Leaving:' || l_proc,30);
328: when others then
329: --
330: -- When Multiple Message Detection is enabled catch
331: -- any Application specific or other unexpected

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

334: -- the error.
335: --
336: rollback to update_rec_team_member_swi;
337: if hr_multi_message.unexpected_error_add(l_proc) then
338: hr_utility.set_location(' Leaving:' || l_proc, 40);
339: raise;
340: end if;
341: --
342: -- Reset IN OUT parameters and set OUT parameters

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

342: -- Reset IN OUT parameters and set OUT parameters
343: --
344: p_object_version_number := l_object_version_number;
345: p_return_status := hr_multi_message.get_return_status_disable;
346: hr_utility.set_location(' Leaving: ' || l_proc, 50);
347: end update_rec_team_member;
348: --
349: -- ----------------------------------------------------------------------------
350: -- |----------------------------< process_api >-------------------------------|

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

370: l_effective_date date := trunc(sysdate);
371:
372: BEGIN
373: --
374: hr_utility.set_location(' Entering:' || l_proc,10);
375: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
376: --
377: l_parser := xmlparser.newParser;
378: xmlparser.ParseCLOB(l_parser,p_document);

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

371:
372: BEGIN
373: --
374: hr_utility.set_location(' Entering:' || l_proc,10);
375: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
376: --
377: l_parser := xmlparser.newParser;
378: xmlparser.ParseCLOB(l_parser,p_document);
379: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

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

377: l_parser := xmlparser.newParser;
378: xmlparser.ParseCLOB(l_parser,p_document);
379: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
380: --
381: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
382:
383: l_commitElement := xmldom.makeElement(l_CommitNode);
384: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
385: --

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

395: end if;
396: --
397: if l_postState = '0' then
398: --
399: hr_utility.set_location('creating :' || l_proc,30);
400: --
401: create_rec_team_member
402: (p_validate => p_validate
403: ,p_rec_team_member_id => l_rec_team_member_id

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

414: );
415: --
416: elsif l_postState = '2' then
417: --
418: hr_utility.set_location('updating :' || l_proc,32);
419: --
420: update_rec_team_member
421: (p_validate => p_validate
422: ,p_rec_team_member_id => l_rec_team_member_id

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

434: );
435: --
436: elsif l_postState = '3' then
437: --
438: hr_utility.set_location('deleting :' || l_proc,33);
439: --
440: delete_rec_team_member
441: (p_validate => p_validate
442: ,p_object_version_number => l_object_version_number

Line 451: hr_utility.set_location

447: end if;
448:
449: p_return_status := l_return_status;
450:
451: hr_utility.set_location
452: ('Exiting :'|| l_proc || ': return status :'|| l_return_status || ':',40);
453:
454: end process_api;
455: --