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:
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:
61: l_payroll_run_exist := pay_us_vertex_interface.payroll_run_exist(p_business_group_id);
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:
61: l_payroll_run_exist := pay_us_vertex_interface.payroll_run_exist(p_business_group_id);
62: hr_utility_trace('l_payroll_run_exist -> '|| l_payroll_run_exist);
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:
61: l_payroll_run_exist := pay_us_vertex_interface.payroll_run_exist(p_business_group_id);
62: hr_utility_trace('l_payroll_run_exist -> '|| l_payroll_run_exist);
63:
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:
61: l_payroll_run_exist := pay_us_vertex_interface.payroll_run_exist(p_business_group_id);
62: hr_utility_trace('l_payroll_run_exist -> '|| l_payroll_run_exist);
63:
64: l_vertex_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('VERTEX',p_business_group_id);
65: hr_utility_trace('l_vertex_etu_exist -> '|| l_vertex_etu_exist);
66:
61: l_payroll_run_exist := pay_us_vertex_interface.payroll_run_exist(p_business_group_id);
62: hr_utility_trace('l_payroll_run_exist -> '|| l_payroll_run_exist);
63:
64: l_vertex_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('VERTEX',p_business_group_id);
65: hr_utility_trace('l_vertex_etu_exist -> '|| l_vertex_etu_exist);
66:
67: l_us_tax_vertex_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('US_TAX_VERTEX',p_business_group_id);
68: hr_utility_trace('l_us_tax_vertex_etu_exist -> '|| l_us_tax_vertex_etu_exist);
69:
64: l_vertex_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('VERTEX',p_business_group_id);
65: hr_utility_trace('l_vertex_etu_exist -> '|| l_vertex_etu_exist);
66:
67: l_us_tax_vertex_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('US_TAX_VERTEX',p_business_group_id);
68: hr_utility_trace('l_us_tax_vertex_etu_exist -> '|| l_us_tax_vertex_etu_exist);
69:
70: l_workers_comp_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('Workers Compensation',p_business_group_id);
71: hr_utility_trace('l_workers_comp_etu_exist -> '|| l_workers_comp_etu_exist);
72:
67: l_us_tax_vertex_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('US_TAX_VERTEX',p_business_group_id);
68: hr_utility_trace('l_us_tax_vertex_etu_exist -> '|| l_us_tax_vertex_etu_exist);
69:
70: l_workers_comp_etu_exist := pay_us_vertex_interface.vertex_eletype_usage_exist('Workers Compensation',p_business_group_id);
71: hr_utility_trace('l_workers_comp_etu_exist -> '|| l_workers_comp_etu_exist);
72:
73: IF l_payroll_run_exist = 'N' THEN
74:
75: IF l_vertex_etu_exist = 'Y' THEN
72:
73: IF l_payroll_run_exist = 'N' THEN
74:
75: IF l_vertex_etu_exist = 'Y' THEN
76: hr_utility.set_location('l_vertex_etu_exist ->'|| l_vertex_etu_exist,2001);
77: pay_us_vertex_interface.delete_ele_type_usages('VERTEX'
78: , p_business_group_id);
79: END IF;
80:
78: , p_business_group_id);
79: END IF;
80:
81: IF l_us_tax_vertex_etu_exist = 'Y' THEN
82: hr_utility.set_location('IN HRAMERD, l_us_tax_vertex_etu_exist ->'|| l_us_tax_vertex_etu_exist,2001);
83: pay_us_vertex_interface.delete_ele_type_usages('US_TAX_VERTEX'
84: , p_business_group_id);
85: END IF;
86:
91:
92: OPEN c_vertex_element('VERTEX');
93: FETCH c_vertex_element INTO l_element_type_id;
94: CLOSE c_vertex_element;
95: hr_utility_trace('l_element_type_id -> '|| l_element_type_id);
96:
97: FOR run_type IN c_run_type LOOP
98: pay_us_vertex_interface.create_ele_tp_usg(p_element_type_id => l_element_type_id
99: ,p_run_type_id => run_type.run_type_id
107:
108: OPEN c_vertex_element('Workers Compensation');
109: FETCH c_vertex_element INTO l_element_type_id;
110: CLOSE c_vertex_element;
111: hr_utility_trace('l_element_type_id -> '|| l_element_type_id);
112:
113: FOR run_type IN c_run_type LOOP
114: pay_us_vertex_interface.create_ele_tp_usg
115: ( p_element_type_id => l_element_type_id
120: ,p_effective_date => run_type.effective_start_date
121: ,p_legislation_code => NULL
122: ,p_business_group_id => p_business_group_id);
123:
124: hr_utility.trace('2136 -> Workers Compensation element excluded');
125: END LOOP;
126:
127: ELSIF l_payroll_run_exist = 'Y' THEN
128: NULL;
131: END create_vertex_etu;
132:
133: --To put the trace just uncomment the below three lines.
134: --BEGIN
135: -- hr_utility.trace_on(null,'VERTEX');
136: -- g_debug := hr_utility.debug_enabled;
137: END pay_us_tax_etu_pkg;
132:
133: --To put the trace just uncomment the below three lines.
134: --BEGIN
135: -- hr_utility.trace_on(null,'VERTEX');
136: -- g_debug := hr_utility.debug_enabled;
137: END pay_us_tax_etu_pkg;