DBA Data[Home] [Help]

APPS.PQH_TXN_CAT_DOCUMENTS_SWI dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

125: --
126: -- Other variables
127: l_proc varchar2(72) := g_package ||'delete_txn_cat_document';
128: Begin
129: hr_utility.set_location(' Entering:' || l_proc,10);
130: --
131: -- Issue a savepoint
132: --
133: savepoint delete_txn_cat_document_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_txn_cat_document_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_txn_cat_document;
206: --- svorugan--
207:
208: -- ----------------------------------------------------------------------------

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

230: from pqh_txn_category_documents
231: where transaction_category_id = p_transaction_category_id;
232:
233: Begin
234: hr_utility.set_location(' Entering:' || l_proc,10);
235: --
236: -- Issue a savepoint
237: --
238: savepoint delete_txn_cat_document_swi;

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

288: -- messages of any type exist in the Multiple Message List.
289: -- Also disable Multiple Message Detection.
290: --
291: p_return_status := hr_multi_message.get_return_status_disable;
292: hr_utility.set_location(' Leaving:' || l_proc,20);
293: --
294: exception
295: when hr_multi_message.error_message_exist then
296: --

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

302: --
303: -- Reset IN OUT parameters and set OUT parameters
304: --
305: p_return_status := hr_multi_message.get_return_status_disable;
306: hr_utility.set_location(' Leaving:' || l_proc, 30);
307: when others then
308: --
309: -- When Multiple Message Detection is enabled catch
310: -- any Application specific or other unexpected

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

313: -- error.
314: --
315: rollback to delete_txn_cat_document_swi;
316: if hr_multi_message.unexpected_error_add(l_proc) then
317: hr_utility.set_location(' Leaving:' || l_proc,40);
318: raise;
319: end if;
320: --
321: -- Reset IN OUT and set OUT parameters

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

320: --
321: -- Reset IN OUT and set OUT parameters
322: --
323: p_return_status := hr_multi_message.get_return_status_disable;
324: hr_utility.set_location(' Leaving:' || l_proc,50);
325: end delete_group;
326: -- ----------------------------------------------------------------------------
327:
328:

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

348: --
349: -- Other variables
350: l_proc varchar2(72) := g_package ||'update_txn_cat_document';
351: Begin
352: hr_utility.set_location(' Entering:' || l_proc,10);
353: --
354: -- Issue a savepoint
355: --
356: savepoint update_txn_cat_document_swi;

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

394: -- messages of any type exist in the Multiple Message List.
395: -- Also disable Multiple Message Detection.
396: --
397: p_return_status := hr_multi_message.get_return_status_disable;
398: hr_utility.set_location(' Leaving:' || l_proc,20);
399: --
400: exception
401: when hr_multi_message.error_message_exist then
402: --

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

409: -- Reset IN OUT parameters and set OUT parameters
410: --
411: p_object_version_number := l_object_version_number;
412: p_return_status := hr_multi_message.get_return_status_disable;
413: hr_utility.set_location(' Leaving:' || l_proc, 30);
414: when others then
415: --
416: -- When Multiple Message Detection is enabled catch
417: -- any Application specific or other unexpected

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

420: -- error.
421: --
422: rollback to update_txn_cat_document_swi;
423: if hr_multi_message.unexpected_error_add(l_proc) then
424: hr_utility.set_location(' Leaving:' || l_proc,40);
425: raise;
426: end if;
427: --
428: -- Reset IN OUT and set OUT parameters

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

428: -- Reset IN OUT and set OUT parameters
429: --
430: p_object_version_number := l_object_version_number;
431: p_return_status := hr_multi_message.get_return_status_disable;
432: hr_utility.set_location(' Leaving:' || l_proc,50);
433: end update_txn_cat_document;
434: end pqh_txn_cat_documents_swi;