eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BUDGET_POOLS_SWI dependencies on HR_UTILITY

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

66: /*
67: If the Receiver has only one period then delete receiver and receiver period.
68: If the reciver has more than one receiver periods then delete only the given receiver period.
69: */
70: hr_utility.set_location(' Entering:' || l_proc,10);
71: If p_transaction_type = 'RD' then
72: open csr_receiver_prd_count;
73: fetch csr_receiver_prd_count into l_count;
74: close csr_receiver_prd_count;

Line 75: hr_utility.set_location(' Count :' || l_count,15);

71: If p_transaction_type = 'RD' then
72: open csr_receiver_prd_count;
73: fetch csr_receiver_prd_count into l_count;
74: close csr_receiver_prd_count;
75: hr_utility.set_location(' Count :' || l_count,15);
76:
77: open csr_receiver_id;
78: fetch csr_receiver_id into l_receiver_id, l_receiver_ovn;
79: close csr_receiver_id;

Line 86: hr_utility.set_location(' l_bdgt_trnx_amount_id :' || l_bdgt_trnx_amount_id,20);

82:
83: open csr_bdgt_trnx_amt;
84: fetch csr_bdgt_trnx_amt into l_bdgt_trnx_amount_id, l_ovn;
85: close csr_bdgt_trnx_amt;
86: hr_utility.set_location(' l_bdgt_trnx_amount_id :' || l_bdgt_trnx_amount_id,20);
87: --
88: -- Added IF condition to call delete API only when there is a row for the ID passed
89: --
90: IF l_bdgt_trnx_amount_id IS NOT NULL THEN

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

100: ,p_txn_detail_id => l_receiver_id
101: ,p_object_version_number => l_receiver_ovn
102: );
103: End if;
104: hr_utility.set_location(' Leaving:' || l_proc,25);
105: END delete_trxn_amts;
106:
107: PROCEDURE delete_trxn_dtls(p_transaction_type in varchar2 , p_bdgt_trnx_detail_id in number) is
108:

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

132: l_transaction_type varchar2(15);
133: l_proc varchar2(72) := g_package ||'delete_trxn_dtls';
134:
135: BEGIN
136: hr_utility.set_location(' Entering:' || l_proc,10);
137: If p_transaction_type in ('D','R') then
138: open csr_donor_receiver_details;
139: loop
140: fetch csr_donor_receiver_details into l_bdgt_trnx_amt_id,l_transaction_type;

Line 145: hr_utility.set_location(' l_bdgt_trnx_amt_id:' || l_bdgt_trnx_amt_id,15);

141: exit when csr_donor_receiver_details%notfound;
142:
143:
144: /* Delete all Donor/Receiver Amount Details */
145: hr_utility.set_location(' l_bdgt_trnx_amt_id:' || l_bdgt_trnx_amt_id,15);
146: hr_utility.set_location(' l_transaction_type:' || l_transaction_type,20);
147: delete_trxn_amts
148: (p_transaction_type => l_transaction_type,
149: p_bdgt_trnx_amount_id => l_bdgt_trnx_amt_id);

Line 146: hr_utility.set_location(' l_transaction_type:' || l_transaction_type,20);

142:
143:
144: /* Delete all Donor/Receiver Amount Details */
145: hr_utility.set_location(' l_bdgt_trnx_amt_id:' || l_bdgt_trnx_amt_id,15);
146: hr_utility.set_location(' l_transaction_type:' || l_transaction_type,20);
147: delete_trxn_amts
148: (p_transaction_type => l_transaction_type,
149: p_bdgt_trnx_amount_id => l_bdgt_trnx_amt_id);
150:

Line 158: hr_utility.set_location(' l_bdgt_trnx_detail_id :' || l_bdgt_trnx_detail_id ,25);

154: /* Delete Donor/Receiver Details */
155: open csr_bdgt_trnx_dtl;
156: fetch csr_bdgt_trnx_dtl into l_bdgt_trnx_detail_id, l_ovn;
157: close csr_bdgt_trnx_dtl;
158: hr_utility.set_location(' l_bdgt_trnx_detail_id :' || l_bdgt_trnx_detail_id ,25);
159: if l_bdgt_trnx_detail_id is not null then
160:
161: pqh_bdgt_pool_realloctions_api.delete_realloc_txn_dtl
162: ( p_validate => false

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

164: ,p_object_version_number => l_ovn
165: );
166: end if;
167: end if;
168: hr_utility.set_location(' Leaving:' || l_proc,30);
169: END delete_trxn_dtls;
170:
171:
172: PROCEDURE delete_bgt_transaction (p_transaction_id in number) is

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

191: l_transaction_type varchar2(15);
192: l_proc varchar2(72) := g_package ||'delete_bgt_transaction';
193:
194: BEGIN
195: hr_utility.set_location(' Entering:' || l_proc,10);
196: /* fetch all budget transaction details */
197: open csr_bdgt_trnx_details;
198: loop
199: fetch csr_bdgt_trnx_details into l_transaction_id , l_transaction_type ;

Line 201: hr_utility.set_location(' l_transaction_id :' || l_transaction_id ,15);

197: open csr_bdgt_trnx_details;
198: loop
199: fetch csr_bdgt_trnx_details into l_transaction_id , l_transaction_type ;
200: exit when csr_bdgt_trnx_details%notfound;
201: hr_utility.set_location(' l_transaction_id :' || l_transaction_id ,15);
202: hr_utility.set_location(' l_transaction_type :' || l_transaction_type ,20);
203: delete_trxn_dtls
204: (p_transaction_type => l_transaction_type
205: ,p_bdgt_trnx_detail_id => l_transaction_id );

Line 202: hr_utility.set_location(' l_transaction_type :' || l_transaction_type ,20);

198: loop
199: fetch csr_bdgt_trnx_details into l_transaction_id , l_transaction_type ;
200: exit when csr_bdgt_trnx_details%notfound;
201: hr_utility.set_location(' l_transaction_id :' || l_transaction_id ,15);
202: hr_utility.set_location(' l_transaction_type :' || l_transaction_type ,20);
203: delete_trxn_dtls
204: (p_transaction_type => l_transaction_type
205: ,p_bdgt_trnx_detail_id => l_transaction_id );
206: end loop;

Line 213: hr_utility.set_location(' l_transaction_id :' || l_transaction_id ,25);

209:
210: open csr_bdgt_transaction;
211: fetch csr_bdgt_transaction into l_transaction_id, l_ovn;
212: close csr_bdgt_transaction;
213: hr_utility.set_location(' l_transaction_id :' || l_transaction_id ,25);
214: if l_transaction_id is not null then
215: pqh_budget_pools_api.delete_reallocation_txn
216: (p_validate => false
217: ,p_transaction_id => l_transaction_id

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

218: ,p_object_version_number => l_ovn
219: ,p_effective_date => sysdate
220: );
221: end if;
222: hr_utility.set_location(' Leaving:' || l_proc,30);
223: END delete_bgt_transaction;
224:
225:
226:

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

269: l_txn_cat_id number;
270: l_proc varchar2(72) := g_package ||'delete_trxn_dtls';
271:
272: BEGIN
273: hr_utility.set_location(' Entering:' || l_proc,10);
274: open csr_txn_cat_id;
275: fetch csr_txn_cat_id into l_txn_cat_id;
276: close csr_txn_cat_id;
277: hr_utility.set_location(' Txn Cat Id :' || l_txn_cat_id , 12);

Line 277: hr_utility.set_location(' Txn Cat Id :' || l_txn_cat_id , 12);

273: hr_utility.set_location(' Entering:' || l_proc,10);
274: open csr_txn_cat_id;
275: fetch csr_txn_cat_id into l_txn_cat_id;
276: close csr_txn_cat_id;
277: hr_utility.set_location(' Txn Cat Id :' || l_txn_cat_id , 12);
278: if l_txn_cat_id is not null then
279: l_itemkey := l_txn_cat_id || '-' || p_folder_id;
280: end if;
281: hr_utility.set_location(' Item Key :' || l_itemkey , 12);

Line 281: hr_utility.set_location(' Item Key :' || l_itemkey , 12);

277: hr_utility.set_location(' Txn Cat Id :' || l_txn_cat_id , 12);
278: if l_txn_cat_id is not null then
279: l_itemkey := l_txn_cat_id || '-' || p_folder_id;
280: end if;
281: hr_utility.set_location(' Item Key :' || l_itemkey , 12);
282: /* fetch all budget transactions*/
283: open csr_bdgt_transaction;
284: loop
285: fetch csr_bdgt_transaction into l_transaction_id;

Line 295: hr_utility.set_location(' Folder Id :' || l_folder_id ,15);

291:
292: open csr_bdgt_folder;
293: fetch csr_bdgt_folder into l_folder_id, l_ovn;
294: close csr_bdgt_folder;
295: hr_utility.set_location(' Folder Id :' || l_folder_id ,15);
296:
297: if l_folder_id is not null then
298:
299: pqh_budget_pools_api.delete_reallocation_folder

Line 311: hr_utility.set_location(' Process Log Id :' || plg.process_log_id ,25);

307: --Added by kgowripe for bug#2875736
308: --For deleting the process log entries for a folder
309: FOR plg IN csr_process_log_ids
310: LOOP
311: hr_utility.set_location(' Process Log Id :' || plg.process_log_id ,25);
312: hr_utility.set_location(' OVN :' || plg.object_version_number ,35);
313:
314: pqh_process_log_api.delete_process_log(p_process_log_id => plg.process_log_id
315: ,p_object_version_number=> plg.object_version_number

Line 312: hr_utility.set_location(' OVN :' || plg.object_version_number ,35);

308: --For deleting the process log entries for a folder
309: FOR plg IN csr_process_log_ids
310: LOOP
311: hr_utility.set_location(' Process Log Id :' || plg.process_log_id ,25);
312: hr_utility.set_location(' OVN :' || plg.object_version_number ,35);
313:
314: pqh_process_log_api.delete_process_log(p_process_log_id => plg.process_log_id
315: ,p_object_version_number=> plg.object_version_number
316: ,p_effective_date => sysdate);

Line 320: hr_utility.set_location(' call to delete folder from inbox:' || l_proc,40);

316: ,p_effective_date => sysdate);
317: END LOOP;
318: -- Added by mvanakda
319: -- Bug : 2880151
320: hr_utility.set_location(' call to delete folder from inbox:' || l_proc,40);
321: wf_engine.AbortProcess(itemtype => 'PQHGEN',
322: itemkey => l_itemkey ,
323: process => 'PQH_ROUTING',
324: result => null);

Line 326: hr_utility.set_location(' Leaving:' || l_proc,45);

322: itemkey => l_itemkey ,
323: process => 'PQH_ROUTING',
324: result => null);
325:
326: hr_utility.set_location(' Leaving:' || l_proc,45);
327: Exception
328: When others then
329: Null;
330: END delete_bgt_folder;

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

356: --
357: -- Other variables
358: l_proc varchar2(72) := g_package ||'create_reallocation_folder';
359: Begin
360: hr_utility.set_location(' Entering:' || l_proc,10);
361: --
362: -- Issue a savepoint
363: --
364: savepoint create_reallocation_folder_swi;

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

406: -- messages of any type exist in the Multiple Message List.
407: -- Also disable Multiple Message Detection.
408: --
409: p_return_status := hr_multi_message.get_return_status_disable;
410: hr_utility.set_location(' Leaving:' || l_proc,20);
411: --
412: exception
413: when hr_multi_message.error_message_exist then
414: --

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

422: --
423: p_folder_id := null;
424: p_object_version_number := null;
425: p_return_status := hr_multi_message.get_return_status_disable;
426: hr_utility.set_location(' Leaving:' || l_proc, 30);
427: when others then
428: --
429: -- When Multiple Message Detection is enabled catch
430: -- any Application specific or other unexpected

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

433: -- error.
434: --
435: rollback to create_reallocation_folder_swi;
436: if hr_multi_message.unexpected_error_add(l_proc) then
437: hr_utility.set_location(' Leaving:' || l_proc,40);
438: raise;
439: end if;
440: --
441: -- Reset IN OUT and set OUT parameters

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

442: --
443: p_folder_id := null;
444: p_object_version_number := null;
445: p_return_status := hr_multi_message.get_return_status_disable;
446: hr_utility.set_location(' Leaving:' || l_proc,50);
447: end create_reallocation_folder;
448: -- ----------------------------------------------------------------------------
449: -- |------------------------< create_reallocation_txn >-----------------------|
450: -- ----------------------------------------------------------------------------

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

466: --
467: -- Other variables
468: l_proc varchar2(72) := g_package ||'create_reallocation_txn';
469: Begin
470: hr_utility.set_location(' Entering:' || l_proc,10);
471: --
472: -- Issue a savepoint
473: --
474: savepoint create_reallocation_txn_swi;

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

512: -- messages of any type exist in the Multiple Message List.
513: -- Also disable Multiple Message Detection.
514: --
515: p_return_status := hr_multi_message.get_return_status_disable;
516: hr_utility.set_location(' Leaving:' || l_proc,20);
517: --
518: exception
519: when hr_multi_message.error_message_exist then
520: --

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

528: --
529: p_transaction_id := null;
530: p_object_version_number := null;
531: p_return_status := hr_multi_message.get_return_status_disable;
532: hr_utility.set_location(' Leaving:' || l_proc, 30);
533: when others then
534: --
535: -- When Multiple Message Detection is enabled catch
536: -- any Application specific or other unexpected

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

539: -- error.
540: --
541: rollback to create_reallocation_txn_swi;
542: if hr_multi_message.unexpected_error_add(l_proc) then
543: hr_utility.set_location(' Leaving:' || l_proc,40);
544: raise;
545: end if;
546: --
547: -- Reset IN OUT and set OUT parameters

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

548: --
549: p_transaction_id := null;
550: p_object_version_number := null;
551: p_return_status := hr_multi_message.get_return_status_disable;
552: hr_utility.set_location(' Leaving:' || l_proc,50);
553: end create_reallocation_txn;
554: -- ----------------------------------------------------------------------------
555: -- |----------------------< delete_reallocation_folder >----------------------|
556: -- ----------------------------------------------------------------------------

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

569: --
570: -- Other variables
571: l_proc varchar2(72) := g_package ||'delete_reallocation_folder';
572: Begin
573: hr_utility.set_location(' Entering:' || l_proc,10);
574: --
575: -- Issue a savepoint
576: --
577: savepoint delete_reallocation_folder_swi;

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

612: -- messages of any type exist in the Multiple Message List.
613: -- Also disable Multiple Message Detection.
614: --
615: p_return_status := hr_multi_message.get_return_status_disable;
616: hr_utility.set_location(' Leaving:' || l_proc,20);
617: --
618: exception
619: when hr_multi_message.error_message_exist then
620: --

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

626: --
627: -- Reset IN OUT parameters and set OUT parameters
628: --
629: p_return_status := hr_multi_message.get_return_status_disable;
630: hr_utility.set_location(' Leaving:' || l_proc, 30);
631: when others then
632: --
633: -- When Multiple Message Detection is enabled catch
634: -- any Application specific or other unexpected

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

637: -- error.
638: --
639: rollback to delete_reallocation_folder_swi;
640: if hr_multi_message.unexpected_error_add(l_proc) then
641: hr_utility.set_location(' Leaving:' || l_proc,40);
642: raise;
643: end if;
644: --
645: -- Reset IN OUT and set OUT parameters

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

644: --
645: -- Reset IN OUT and set OUT parameters
646: --
647: p_return_status := hr_multi_message.get_return_status_disable;
648: hr_utility.set_location(' Leaving:' || l_proc,50);
649: end delete_reallocation_folder;
650: -- ----------------------------------------------------------------------------
651: -- |------------------------< delete_reallocation_txn >-----------------------|
652: -- ----------------------------------------------------------------------------

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

665: --
666: -- Other variables
667: l_proc varchar2(72) := g_package ||'delete_reallocation_txn';
668: Begin
669: hr_utility.set_location(' Entering:' || l_proc,10);
670: --
671: -- Issue a savepoint
672: --
673: savepoint delete_reallocation_txn_swi;

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

708: -- messages of any type exist in the Multiple Message List.
709: -- Also disable Multiple Message Detection.
710: --
711: p_return_status := hr_multi_message.get_return_status_disable;
712: hr_utility.set_location(' Leaving:' || l_proc,20);
713: --
714: exception
715: when hr_multi_message.error_message_exist then
716: --

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

722: --
723: -- Reset IN OUT parameters and set OUT parameters
724: --
725: p_return_status := hr_multi_message.get_return_status_disable;
726: hr_utility.set_location(' Leaving:' || l_proc, 30);
727: when others then
728: --
729: -- When Multiple Message Detection is enabled catch
730: -- any Application specific or other unexpected

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

733: -- error.
734: --
735: rollback to delete_reallocation_txn_swi;
736: if hr_multi_message.unexpected_error_add(l_proc) then
737: hr_utility.set_location(' Leaving:' || l_proc,40);
738: raise;
739: end if;
740: --
741: -- Reset IN OUT and set OUT parameters

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

740: --
741: -- Reset IN OUT and set OUT parameters
742: --
743: p_return_status := hr_multi_message.get_return_status_disable;
744: hr_utility.set_location(' Leaving:' || l_proc,50);
745: end delete_reallocation_txn;
746: -- ----------------------------------------------------------------------------
747: -- |----------------------< update_reallocation_folder >----------------------|
748: -- ----------------------------------------------------------------------------

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

769: --
770: -- Other variables
771: l_proc varchar2(72) := g_package ||'update_reallocation_folder';
772: Begin
773: hr_utility.set_location(' Entering:' || l_proc,10);
774: --
775: -- Issue a savepoint
776: --
777: savepoint update_reallocation_folder_swi;

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

820: -- messages of any type exist in the Multiple Message List.
821: -- Also disable Multiple Message Detection.
822: --
823: p_return_status := hr_multi_message.get_return_status_disable;
824: hr_utility.set_location(' Leaving:' || l_proc,20);
825: --
826: exception
827: when hr_multi_message.error_message_exist then
828: --

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

835: -- Reset IN OUT parameters and set OUT parameters
836: --
837: p_object_version_number := l_object_version_number;
838: p_return_status := hr_multi_message.get_return_status_disable;
839: hr_utility.set_location(' Leaving:' || l_proc, 30);
840: when others then
841: --
842: -- When Multiple Message Detection is enabled catch
843: -- any Application specific or other unexpected

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

846: -- error.
847: --
848: rollback to update_reallocation_folder_swi;
849: if hr_multi_message.unexpected_error_add(l_proc) then
850: hr_utility.set_location(' Leaving:' || l_proc,40);
851: raise;
852: end if;
853: --
854: -- Reset IN OUT and set OUT parameters

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

854: -- Reset IN OUT and set OUT parameters
855: --
856: p_object_version_number := l_object_version_number;
857: p_return_status := hr_multi_message.get_return_status_disable;
858: hr_utility.set_location(' Leaving:' || l_proc,50);
859: end update_reallocation_folder;
860: -- ----------------------------------------------------------------------------
861: -- |------------------------< update_reallocation_txn >-----------------------|
862: -- ----------------------------------------------------------------------------

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

879: --
880: -- Other variables
881: l_proc varchar2(72) := g_package ||'update_reallocation_txn';
882: Begin
883: hr_utility.set_location(' Entering:' || l_proc,10);
884: --
885: -- Issue a savepoint
886: --
887: savepoint update_reallocation_txn_swi;

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

926: -- messages of any type exist in the Multiple Message List.
927: -- Also disable Multiple Message Detection.
928: --
929: p_return_status := hr_multi_message.get_return_status_disable;
930: hr_utility.set_location(' Leaving:' || l_proc,20);
931: --
932: exception
933: when hr_multi_message.error_message_exist then
934: --

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

941: -- Reset IN OUT parameters and set OUT parameters
942: --
943: p_object_version_number := l_object_version_number;
944: p_return_status := hr_multi_message.get_return_status_disable;
945: hr_utility.set_location(' Leaving:' || l_proc, 30);
946: when others then
947: --
948: -- When Multiple Message Detection is enabled catch
949: -- any Application specific or other unexpected

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

952: -- error.
953: --
954: rollback to update_reallocation_txn_swi;
955: if hr_multi_message.unexpected_error_add(l_proc) then
956: hr_utility.set_location(' Leaving:' || l_proc,40);
957: raise;
958: end if;
959: --
960: -- Reset IN OUT and set OUT parameters

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

960: -- Reset IN OUT and set OUT parameters
961: --
962: p_object_version_number := l_object_version_number;
963: p_return_status := hr_multi_message.get_return_status_disable;
964: hr_utility.set_location(' Leaving:' || l_proc,50);
965: end update_reallocation_txn;
966:
967: PROCEDURE bgt_realloc_delete(p_node_type in varchar2, p_node_id in number)
968: is

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

979: */
980: l_proc varchar2(72) := g_package ||'bgt_realloc_delete';
981: BEGIN
982:
983: hr_utility.set_location(' Entering:' || l_proc,10);
984: hr_utility.set_location(' Node Type :' || p_node_type ,20);
985: --added by kgowripe for bug#2875736
986: --
987: -- Initialise Multiple Message Detection

Line 984: hr_utility.set_location(' Node Type :' || p_node_type ,20);

980: l_proc varchar2(72) := g_package ||'bgt_realloc_delete';
981: BEGIN
982:
983: hr_utility.set_location(' Entering:' || l_proc,10);
984: hr_utility.set_location(' Node Type :' || p_node_type ,20);
985: --added by kgowripe for bug#2875736
986: --
987: -- Initialise Multiple Message Detection
988: --

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

1006: delete_bgt_folder
1007: (p_folder_id => p_node_id);
1008:
1009: End if;
1010: hr_utility.set_location(' Leaving:' || l_proc,30);
1011:
1012: END bgt_realloc_delete;
1013: end pqh_budget_pools_swi;