3:
4: g_debug BOOLEAN;
5:
6: /****************************************************************************
7: Name : HR_UTILITY_TRACE
8: Description : This function prints debug messages during diagnostics mode.
9: *****************************************************************************/
10: PROCEDURE hr_utility_trace(trc_data VARCHAR2) IS
11: BEGIN
6: /****************************************************************************
7: Name : HR_UTILITY_TRACE
8: Description : This function prints debug messages during diagnostics mode.
9: *****************************************************************************/
10: PROCEDURE hr_utility_trace(trc_data VARCHAR2) IS
11: BEGIN
12: IF g_debug THEN
13: hr_utility.trace(trc_data);
14: END IF;
9: *****************************************************************************/
10: PROCEDURE hr_utility_trace(trc_data VARCHAR2) IS
11: BEGIN
12: IF g_debug THEN
13: hr_utility.trace(trc_data);
14: END IF;
15: END hr_utility_trace;
16:
17:
11: BEGIN
12: IF g_debug THEN
13: hr_utility.trace(trc_data);
14: END IF;
15: END hr_utility_trace;
16:
17:
18: /*****************************************************************************
19: Name : create_vertex_etu
52: l_element_type_id pay_element_types_f.element_type_id%TYPE;
53:
54: BEGIN
55:
56: hr_utility_trace('pay_us_tax_etu_pkg.create_vertex_etu ');
57: hr_utility_trace('p_effective_date -> ' || p_effective_date);
58: -- hr_utility_trace('p_organization_id -> ' || p_organization_id);
59: -- hr_utility_trace('p_org_info_type_code -> ' || p_org_info_type_code);
60: l_payroll_run_exist := pay_us_vertex_interface.payroll_run_exist(p_business_group_id);
53:
54: BEGIN
55:
56: hr_utility_trace('pay_us_tax_etu_pkg.create_vertex_etu ');
57: hr_utility_trace('p_effective_date -> ' || p_effective_date);
58: -- hr_utility_trace('p_organization_id -> ' || p_organization_id);
59: -- hr_utility_trace('p_org_info_type_code -> ' || p_org_info_type_code);
60: l_payroll_run_exist := pay_us_vertex_interface.payroll_run_exist(p_business_group_id);
61: hr_utility_trace('l_payroll_run_exist -> '|| l_payroll_run_exist);
54: BEGIN
55:
56: hr_utility_trace('pay_us_tax_etu_pkg.create_vertex_etu ');
57: hr_utility_trace('p_effective_date -> ' || p_effective_date);
58: -- hr_utility_trace('p_organization_id -> ' || p_organization_id);
59: -- hr_utility_trace('p_org_info_type_code -> ' || p_org_info_type_code);
60: l_payroll_run_exist := pay_us_vertex_interface.payroll_run_exist(p_business_group_id);
61: hr_utility_trace('l_payroll_run_exist -> '|| l_payroll_run_exist);
62:
55:
56: hr_utility_trace('pay_us_tax_etu_pkg.create_vertex_etu ');
57: hr_utility_trace('p_effective_date -> ' || p_effective_date);
58: -- hr_utility_trace('p_organization_id -> ' || p_organization_id);
59: -- hr_utility_trace('p_org_info_type_code -> ' || p_org_info_type_code);
60: l_payroll_run_exist := pay_us_vertex_interface.payroll_run_exist(p_business_group_id);
61: hr_utility_trace('l_payroll_run_exist -> '|| l_payroll_run_exist);
62:
63: l_vertex_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('VERTEX',p_business_group_id);
57: hr_utility_trace('p_effective_date -> ' || p_effective_date);
58: -- hr_utility_trace('p_organization_id -> ' || p_organization_id);
59: -- hr_utility_trace('p_org_info_type_code -> ' || p_org_info_type_code);
60: l_payroll_run_exist := pay_us_vertex_interface.payroll_run_exist(p_business_group_id);
61: hr_utility_trace('l_payroll_run_exist -> '|| l_payroll_run_exist);
62:
63: l_vertex_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('VERTEX',p_business_group_id);
64: hr_utility_trace('l_vertex_etu_exist -> '|| l_vertex_etu_exist);
65:
60: l_payroll_run_exist := pay_us_vertex_interface.payroll_run_exist(p_business_group_id);
61: hr_utility_trace('l_payroll_run_exist -> '|| l_payroll_run_exist);
62:
63: l_vertex_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('VERTEX',p_business_group_id);
64: hr_utility_trace('l_vertex_etu_exist -> '|| l_vertex_etu_exist);
65:
66: l_us_tax_vertex_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('US_TAX_VERTEX',p_business_group_id);
67: hr_utility_trace('l_us_tax_vertex_etu_exist -> '|| l_us_tax_vertex_etu_exist);
68:
63: l_vertex_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('VERTEX',p_business_group_id);
64: hr_utility_trace('l_vertex_etu_exist -> '|| l_vertex_etu_exist);
65:
66: l_us_tax_vertex_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('US_TAX_VERTEX',p_business_group_id);
67: hr_utility_trace('l_us_tax_vertex_etu_exist -> '|| l_us_tax_vertex_etu_exist);
68:
69: l_workers_comp_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('Workers Compensation',p_business_group_id);
70: hr_utility_trace('l_workers_comp_etu_exist -> '|| l_workers_comp_etu_exist);
71:
66: l_us_tax_vertex_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('US_TAX_VERTEX',p_business_group_id);
67: hr_utility_trace('l_us_tax_vertex_etu_exist -> '|| l_us_tax_vertex_etu_exist);
68:
69: l_workers_comp_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('Workers Compensation',p_business_group_id);
70: hr_utility_trace('l_workers_comp_etu_exist -> '|| l_workers_comp_etu_exist);
71:
72: --
73: -- #13840577 Added the check for US payroll installations before
74: -- creating the element type usages for VERTEX and workers compensation
74: -- creating the element type usages for VERTEX and workers compensation
75: -- elements
76: --
77: IF ((l_payroll_run_exist = 'N')
78: AND hr_utility.chk_product_install(
79: p_product => 'Oracle Payroll',
80: p_legislation => 'US',
81: p_language => 'US')) THEN
82:
80: p_legislation => 'US',
81: p_language => 'US')) THEN
82:
83: IF l_vertex_etu_exist = 'Y' THEN
84: hr_utility.set_location('l_vertex_etu_exist ->'|| l_vertex_etu_exist,2001);
85: pay_us_vertex_interface.delete_ele_type_usages('VERTEX'
86: , p_business_group_id);
87: END IF;
88:
86: , p_business_group_id);
87: END IF;
88:
89: IF l_us_tax_vertex_etu_exist = 'Y' THEN
90: hr_utility.set_location('IN HRAMERD, l_us_tax_vertex_etu_exist ->'|| l_us_tax_vertex_etu_exist,2001);
91: pay_us_vertex_interface.delete_ele_type_usages('US_TAX_VERTEX'
92: , p_business_group_id);
93: END IF;
94:
99:
100: OPEN c_vertex_element('VERTEX');
101: FETCH c_vertex_element INTO l_element_type_id;
102: CLOSE c_vertex_element;
103: hr_utility_trace('l_element_type_id -> '|| l_element_type_id);
104:
105: FOR run_type IN c_run_type LOOP
106: pay_us_vertex_interface.create_ele_tp_usg(p_element_type_id => l_element_type_id
107: ,p_run_type_id => run_type.run_type_id
115:
116: OPEN c_vertex_element('Workers Compensation');
117: FETCH c_vertex_element INTO l_element_type_id;
118: CLOSE c_vertex_element;
119: hr_utility_trace('l_element_type_id -> '|| l_element_type_id);
120:
121: FOR run_type IN c_run_type LOOP
122: pay_us_vertex_interface.create_ele_tp_usg
123: ( p_element_type_id => l_element_type_id
128: ,p_effective_date => run_type.effective_start_date
129: ,p_legislation_code => NULL
130: ,p_business_group_id => p_business_group_id);
131:
132: hr_utility.trace('2136 -> Workers Compensation element excluded');
133: END LOOP;
134:
135: ELSIF l_payroll_run_exist = 'Y' THEN
136: NULL;
139: END create_vertex_etu;
140:
141: --To put the trace just uncomment the below three lines.
142: --BEGIN
143: -- hr_utility.trace_on(null,'VERTEX');
144: -- g_debug := hr_utility.debug_enabled;
145: END pay_us_tax_etu_pkg;
140:
141: --To put the trace just uncomment the below three lines.
142: --BEGIN
143: -- hr_utility.trace_on(null,'VERTEX');
144: -- g_debug := hr_utility.debug_enabled;
145: END pay_us_tax_etu_pkg;