DBA Data[Home] [Help]

APPS.HR_PER_DEPLYMT_EIT_SWI dependencies on HR_UTILITY

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

25: -- Other variables
26: l_per_deplymt_eit_id number;
27: l_proc varchar2(72) := g_package ||'create_per_deplymt_eit';
28: Begin
29: hr_utility.set_location(' Entering:' || l_proc,10);
30: --
31: -- Issue a savepoint
32: --
33: savepoint create_per_deplymt_eit_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_eit_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_eit;
112: -- ----------------------------------------------------------------------------
113: -- |------------------------< delete_per_deplymt_eit >------------------------|
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_eit';
129: Begin
130: hr_utility.set_location(' Entering:' || l_proc,10);
131: --
132: -- Issue a savepoint
133: --
134: savepoint delete_per_deplymt_eit_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_eit_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_eit;
206:
207: -- ----------------------------------------------------------------------------
208: -- |------------------------< process_api >-----------------------------------|

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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