DBA Data[Home] [Help]

APPS.HR_PER_DEPLYMT_CONTACT_SWI dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

126: --
127: -- Other variables
128: l_proc varchar2(72) := g_package ||'delete_per_deplymt_contact';
129: Begin
130: hr_utility.set_location(' Entering:' || l_proc,10);
131: --
132: -- Issue a savepoint
133: --
134: savepoint delete_per_deplymt_contact_swi;

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

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

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

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

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

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

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

200: --
201: -- Reset IN OUT and set OUT parameters
202: --
203: p_return_status := hr_multi_message.get_return_status_disable;
204: hr_utility.set_location(' Leaving:' || l_proc,50);
205: end delete_per_deplymt_contact;
206:
207:
208: Procedure process_api

Line 227: --hr_utility.trace_on(null,'ORCLE');

223: l_occurrence number;
224: lv_action varchar2(30);
225:
226: BEGIN
227: --hr_utility.trace_on(null,'ORCLE');
228: hr_utility.set_location(' Entering:' || l_proc,10);
229: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
230: savepoint deployment_process_api;
231: l_parser := xmlparser.newParser;

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

224: lv_action varchar2(30);
225:
226: BEGIN
227: --hr_utility.trace_on(null,'ORCLE');
228: hr_utility.set_location(' Entering:' || l_proc,10);
229: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
230: savepoint deployment_process_api;
231: l_parser := xmlparser.newParser;
232: xmlparser.ParseCLOB(l_parser,p_document);

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

225:
226: BEGIN
227: --hr_utility.trace_on(null,'ORCLE');
228: hr_utility.set_location(' Entering:' || l_proc,10);
229: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
230: savepoint deployment_process_api;
231: l_parser := xmlparser.newParser;
232: xmlparser.ParseCLOB(l_parser,p_document);
233: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

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

231: l_parser := xmlparser.newParser;
232: xmlparser.ParseCLOB(l_parser,p_document);
233: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
234:
235: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
236:
237: l_commitElement := xmldom.makeElement(l_CommitNode);
238: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
239:

Line 252: hr_utility.set_location( l_proc||'p_return_status = '||p_return_status,38);

248: ,p_return_status => l_return_status);
249:
250:
251: p_return_status := l_return_status;
252: hr_utility.set_location( l_proc||'p_return_status = '||p_return_status,38);
253: hr_utility.set_location('Exiting:' || l_proc,40);
254: EXCEPTION
255: WHEN OTHERS THEN
256: rollback to deployment_process_api;

Line 253: hr_utility.set_location('Exiting:' || l_proc,40);

249:
250:
251: p_return_status := l_return_status;
252: hr_utility.set_location( l_proc||'p_return_status = '||p_return_status,38);
253: hr_utility.set_location('Exiting:' || l_proc,40);
254: EXCEPTION
255: WHEN OTHERS THEN
256: rollback to deployment_process_api;
257: hr_utility.trace('Exception in .process_api:' || SQLERRM );

Line 257: hr_utility.trace('Exception in .process_api:' || SQLERRM );

253: hr_utility.set_location('Exiting:' || l_proc,40);
254: EXCEPTION
255: WHEN OTHERS THEN
256: rollback to deployment_process_api;
257: hr_utility.trace('Exception in .process_api:' || SQLERRM );
258: hr_utility.set_location(' Leaving:' || l_proc,50);
259:
260: raise;
261:

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

254: EXCEPTION
255: WHEN OTHERS THEN
256: rollback to deployment_process_api;
257: hr_utility.trace('Exception in .process_api:' || SQLERRM );
258: hr_utility.set_location(' Leaving:' || l_proc,50);
259:
260: raise;
261:
262: END process_api;