[Home] [Help]
1: PACKAGE BODY PAY_BEE_SS as
2: /* $Header: pybeess.pkb 120.0.12020000.2 2013/03/22 09:02:09 bklingam noship $ */
3:
4: g_package varchar2(33) := 'PAY_BEE_SS.';
5: g_debug boolean := hr_utility.debug_enabled;
6: g_data_error exception;
7: g_item_key number;
8: g_block_id number;
9:
55:
56: --
57: IF l_transaction_id is null THEN
58: -- Start a Transaction
59: hr_utility.set_location('l_transaction_id is null THEN:'||l_proc,105);
60: hr_transaction_ss.start_transaction
61: (itemtype => p_item_type
62: ,itemkey => p_item_key
63: ,actid => p_actid
88: if l_transaction_step_id is null then
89: --
90: -- Create a transaction step
91: --
92: hr_utility.set_location('l_transaction_step_id is null then:'||l_proc,120);
93: hr_transaction_api.create_transaction_step
94: (p_validate => false
95: ,p_creator_person_id => p_login_person_id
96: --nvl(p_login_person_id, p_parent_id)
189: ,p_transaction_data => l_transaction_table);
190:
191: EXCEPTION
192: WHEN g_data_error THEN
193: hr_utility.set_location('Exception:g_data_error THEN'||l_proc,560);
194: -- -- bee_trace('Exception in create bach '||sqlerrm);
195: -- p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
196: -- p_error_message => p_error_message);
197: WHEN others THEN
194: -- -- bee_trace('Exception in create bach '||sqlerrm);
195: -- p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
196: -- p_error_message => p_error_message);
197: WHEN others THEN
198: hr_utility.set_location('Exception:Others'||l_proc,555);
199: -- -- -- bee_trace(sqlerrm);
200: -- This should be included as an out param for the procedure "create_person".
201: -- Along with this change include also the appropriate changes in the java that calls this api.
202: --
265: if l_transaction_step_id is null then
266: --
267: -- Create a transaction step
268: --
269: hr_utility.set_location('l_transaction_step_id is null then:'||l_proc,120);
270: -- -- -- bee_trace('l_transaction_step_id is null');
271:
272: hr_transaction_api.create_transaction_step
273: (p_validate => false
433: if l_transaction_step_id is null then
434: --
435: -- Create a transaction step
436: --
437: hr_utility.set_location('l_transaction_step_id is null then:'||l_proc,120);
438: ---- -- bee_trace('l_transaction_step_id is null');
439:
440: hr_transaction_api.create_transaction_step
441: (p_validate => false
586: if l_transaction_step_id is null then
587: --
588: -- Create a transaction step
589: --
590: hr_utility.set_location('l_transaction_step_id is null then:'||l_proc,120);
591: -- -- -- bee_trace('l_transaction_step_id is null');
592:
593: hr_transaction_api.create_transaction_step
594: (p_validate => false
687: if l_transaction_step_id is null then
688: --
689: -- Create a transaction step
690: --
691: hr_utility.set_location('l_transaction_step_id is null then:'||l_proc,120);
692: -- -- -- bee_trace('l_transaction_step_id is null');
693:
694: hr_transaction_api.create_transaction_step
695: (p_validate => false
1565:
1566: --
1567: IF l_transaction_id is null THEN
1568: -- Start a Transaction
1569: -- hr_utility.set_location('l_transaction_id is null THEN:'||l_proc,105);
1570: hr_transaction_ss.start_transaction
1571: (itemtype => p_item_type
1572: ,itemkey => p_item_key
1573: ,actid => p_actid
1673: l_status_wf varchar2(50);
1674: l_resp_id number ;
1675: l_user_id number;
1676: begin
1677: hr_utility.set_location('Process api',1);
1678: -- bee_trace('Entered process api');
1679: select transaction_id into l_transaction_id
1680: from hr_api_transaction_steps
1681: where transaction_step_id=p_transaction_step_id;
1815: ,p_transaction_step_id in number
1816: ,p_effective_date in varchar2 default null
1817: ) is
1818: begin
1819: hr_utility.set_location('Process dummy api',1);
1820: ---- -- bee_trace('Entered process api');
1821:
1822: end process_dummy_api;
1823: