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.PAY_US_VERTEX_INTERFACE dependencies on HR_UTILITY

Line 74: hr_utility.trace('3000 -> Start create_ele_tp_usg ');

70:
71:
72: BEGIN
73: --{
74: hr_utility.trace('3000 -> Start create_ele_tp_usg ');
75: hr_utility.trace('3010 -> Parameter Values ');
76: hr_utility.trace(' p_legislation_code : '||p_legislation_code);
77: hr_utility.trace(' p_business_group_id : '||p_business_group_id);
78: hr_utility.trace(' p_element_type_id : '||p_element_type_id);

Line 75: hr_utility.trace('3010 -> Parameter Values ');

71:
72: BEGIN
73: --{
74: hr_utility.trace('3000 -> Start create_ele_tp_usg ');
75: hr_utility.trace('3010 -> Parameter Values ');
76: hr_utility.trace(' p_legislation_code : '||p_legislation_code);
77: hr_utility.trace(' p_business_group_id : '||p_business_group_id);
78: hr_utility.trace(' p_element_type_id : '||p_element_type_id);
79: hr_utility.trace(' p_element_name : '||p_element_name);

Line 76: hr_utility.trace(' p_legislation_code : '||p_legislation_code);

72: BEGIN
73: --{
74: hr_utility.trace('3000 -> Start create_ele_tp_usg ');
75: hr_utility.trace('3010 -> Parameter Values ');
76: hr_utility.trace(' p_legislation_code : '||p_legislation_code);
77: hr_utility.trace(' p_business_group_id : '||p_business_group_id);
78: hr_utility.trace(' p_element_type_id : '||p_element_type_id);
79: hr_utility.trace(' p_element_name : '||p_element_name);
80: hr_utility.trace(' run_type_id : '||p_run_type_id);

Line 77: hr_utility.trace(' p_business_group_id : '||p_business_group_id);

73: --{
74: hr_utility.trace('3000 -> Start create_ele_tp_usg ');
75: hr_utility.trace('3010 -> Parameter Values ');
76: hr_utility.trace(' p_legislation_code : '||p_legislation_code);
77: hr_utility.trace(' p_business_group_id : '||p_business_group_id);
78: hr_utility.trace(' p_element_type_id : '||p_element_type_id);
79: hr_utility.trace(' p_element_name : '||p_element_name);
80: hr_utility.trace(' run_type_id : '||p_run_type_id);
81: hr_utility.trace(' run_type_Name : '||p_run_type_name);

Line 78: hr_utility.trace(' p_element_type_id : '||p_element_type_id);

74: hr_utility.trace('3000 -> Start create_ele_tp_usg ');
75: hr_utility.trace('3010 -> Parameter Values ');
76: hr_utility.trace(' p_legislation_code : '||p_legislation_code);
77: hr_utility.trace(' p_business_group_id : '||p_business_group_id);
78: hr_utility.trace(' p_element_type_id : '||p_element_type_id);
79: hr_utility.trace(' p_element_name : '||p_element_name);
80: hr_utility.trace(' run_type_id : '||p_run_type_id);
81: hr_utility.trace(' run_type_Name : '||p_run_type_name);
82: hr_utility.trace(' p_effective_date : '||p_effective_date);

Line 79: hr_utility.trace(' p_element_name : '||p_element_name);

75: hr_utility.trace('3010 -> Parameter Values ');
76: hr_utility.trace(' p_legislation_code : '||p_legislation_code);
77: hr_utility.trace(' p_business_group_id : '||p_business_group_id);
78: hr_utility.trace(' p_element_type_id : '||p_element_type_id);
79: hr_utility.trace(' p_element_name : '||p_element_name);
80: hr_utility.trace(' run_type_id : '||p_run_type_id);
81: hr_utility.trace(' run_type_Name : '||p_run_type_name);
82: hr_utility.trace(' p_effective_date : '||p_effective_date);
83:

Line 80: hr_utility.trace(' run_type_id : '||p_run_type_id);

76: hr_utility.trace(' p_legislation_code : '||p_legislation_code);
77: hr_utility.trace(' p_business_group_id : '||p_business_group_id);
78: hr_utility.trace(' p_element_type_id : '||p_element_type_id);
79: hr_utility.trace(' p_element_name : '||p_element_name);
80: hr_utility.trace(' run_type_id : '||p_run_type_id);
81: hr_utility.trace(' run_type_Name : '||p_run_type_name);
82: hr_utility.trace(' p_effective_date : '||p_effective_date);
83:
84: ln_exists := 0;

Line 81: hr_utility.trace(' run_type_Name : '||p_run_type_name);

77: hr_utility.trace(' p_business_group_id : '||p_business_group_id);
78: hr_utility.trace(' p_element_type_id : '||p_element_type_id);
79: hr_utility.trace(' p_element_name : '||p_element_name);
80: hr_utility.trace(' run_type_id : '||p_run_type_id);
81: hr_utility.trace(' run_type_Name : '||p_run_type_name);
82: hr_utility.trace(' p_effective_date : '||p_effective_date);
83:
84: ln_exists := 0;
85: hr_utility.trace('3020 -> Checking for the existence of Element Type Usages ');

Line 82: hr_utility.trace(' p_effective_date : '||p_effective_date);

78: hr_utility.trace(' p_element_type_id : '||p_element_type_id);
79: hr_utility.trace(' p_element_name : '||p_element_name);
80: hr_utility.trace(' run_type_id : '||p_run_type_id);
81: hr_utility.trace(' run_type_Name : '||p_run_type_name);
82: hr_utility.trace(' p_effective_date : '||p_effective_date);
83:
84: ln_exists := 0;
85: hr_utility.trace('3020 -> Checking for the existence of Element Type Usages ');
86: open c_check_ele_tp_usg( p_legislation_code

Line 85: hr_utility.trace('3020 -> Checking for the existence of Element Type Usages ');

81: hr_utility.trace(' run_type_Name : '||p_run_type_name);
82: hr_utility.trace(' p_effective_date : '||p_effective_date);
83:
84: ln_exists := 0;
85: hr_utility.trace('3020 -> Checking for the existence of Element Type Usages ');
86: open c_check_ele_tp_usg( p_legislation_code
87: ,p_business_group_id
88: ,p_element_type_id
89: ,p_run_type_id

Line 93: hr_utility.trace('3030 Element Type Usages Exists Flag : '||ln_exists);

89: ,p_run_type_id
90: ,p_effective_date);
91: fetch c_check_ele_tp_usg into ln_exists;
92: close c_check_ele_tp_usg;
93: hr_utility.trace('3030 Element Type Usages Exists Flag : '||ln_exists);
94: if ln_exists = 0 then
95: --{
96: hr_utility.trace('3040 -> Creating Element_Type_USages for Element: '||
97: p_element_name ||' Run Type Type: '||p_run_type_name );

Line 96: hr_utility.trace('3040 -> Creating Element_Type_USages for Element: '||

92: close c_check_ele_tp_usg;
93: hr_utility.trace('3030 Element Type Usages Exists Flag : '||ln_exists);
94: if ln_exists = 0 then
95: --{
96: hr_utility.trace('3040 -> Creating Element_Type_USages for Element: '||
97: p_element_name ||' Run Type Type: '||p_run_type_name );
98: --
99: -- Calling API to create Element Type Usages
100: --

Line 114: hr_utility.trace('3050 -> API Calls to Create Element_Type_Usages Ended ');

110: ,p_object_version_number => l_object_version_number
111: ,p_effective_start_date => l_effective_start_date
112: ,p_effective_end_date => l_effective_end_date);
113: --
114: hr_utility.trace('3050 -> API Calls to Create Element_Type_Usages Ended ');
115: hr_utility.trace('3060 -> Successfully Element Type Usages created ');
116: --}
117: else
118: hr_utility.trace('3040 -> Element Type Exist creation skipped ');

Line 115: hr_utility.trace('3060 -> Successfully Element Type Usages created ');

111: ,p_effective_start_date => l_effective_start_date
112: ,p_effective_end_date => l_effective_end_date);
113: --
114: hr_utility.trace('3050 -> API Calls to Create Element_Type_Usages Ended ');
115: hr_utility.trace('3060 -> Successfully Element Type Usages created ');
116: --}
117: else
118: hr_utility.trace('3040 -> Element Type Exist creation skipped ');
119: end if;

Line 118: hr_utility.trace('3040 -> Element Type Exist creation skipped ');

114: hr_utility.trace('3050 -> API Calls to Create Element_Type_Usages Ended ');
115: hr_utility.trace('3060 -> Successfully Element Type Usages created ');
116: --}
117: else
118: hr_utility.trace('3040 -> Element Type Exist creation skipped ');
119: end if;
120: hr_utility.trace('3999 -> End create_ele_tp_usg ');
121: --}
122: END create_ele_tp_usg;

Line 120: hr_utility.trace('3999 -> End create_ele_tp_usg ');

116: --}
117: else
118: hr_utility.trace('3040 -> Element Type Exist creation skipped ');
119: end if;
120: hr_utility.trace('3999 -> End create_ele_tp_usg ');
121: --}
122: END create_ele_tp_usg;
123:
124:

Line 130: hr_utility.trace('1010 -> Start delete_ele_type_usages ');

126: p_business_group_id in number)
127: IS
128: BEGIN
129: --{
130: hr_utility.trace('1010 -> Start delete_ele_type_usages ');
131: delete from PAY_ELEMENT_TYPE_USAGES_F peu1
132: where EXISTS
133: (select 'x'
134: from PAY_ELEMENT_TYPE_USAGES_F peu2,

Line 144: hr_utility.trace('1020 -> End delete_ele_type_usages ');

140: and peu2.ELEMENT_TYPE_USAGE_ID = peu1.ELEMENT_TYPE_USAGE_ID
141: and peu2.legislation_code IS NULL
142: and peu2.business_group_id = p_business_group_id
143: );
144: hr_utility.trace('1020 -> End delete_ele_type_usages ');
145: --}
146: EXCEPTION
147: WHEN OTHERS THEN
148: hr_utility.trace('1030 -> WARNING: in delete_ele_type_usages ');

Line 148: hr_utility.trace('1030 -> WARNING: in delete_ele_type_usages ');

144: hr_utility.trace('1020 -> End delete_ele_type_usages ');
145: --}
146: EXCEPTION
147: WHEN OTHERS THEN
148: hr_utility.trace('1030 -> WARNING: in delete_ele_type_usages ');
149: hr_utility.trace('1040 -> ETU for VERTEX Element <'||p_element_name ||
150: '> Does not exist ');
151: END delete_ele_type_usages;
152:

Line 149: hr_utility.trace('1040 -> ETU for VERTEX Element <'||p_element_name ||

145: --}
146: EXCEPTION
147: WHEN OTHERS THEN
148: hr_utility.trace('1030 -> WARNING: in delete_ele_type_usages ');
149: hr_utility.trace('1040 -> ETU for VERTEX Element <'||p_element_name ||
150: '> Does not exist ');
151: END delete_ele_type_usages;
152:
153: FUNCTION payroll_run_exist (p_business_group_id in number

Line 160: hr_utility.trace('1100 -> Start payroll_run_exist ');

156: l_payroll_exist varchar2(10);
157: BEGIN
158: l_payroll_exist := 'N';
159: --{
160: hr_utility.trace('1100 -> Start payroll_run_exist ');
161: hr_utility.trace('1105 -> Fetching records from PAY_PAYROLL_ACTIONS ');
162: select 'Y'
163: into l_payroll_exist
164: from dual

Line 161: hr_utility.trace('1105 -> Fetching records from PAY_PAYROLL_ACTIONS ');

157: BEGIN
158: l_payroll_exist := 'N';
159: --{
160: hr_utility.trace('1100 -> Start payroll_run_exist ');
161: hr_utility.trace('1105 -> Fetching records from PAY_PAYROLL_ACTIONS ');
162: select 'Y'
163: into l_payroll_exist
164: from dual
165: where exists( select 1

Line 178: hr_utility.trace('1110 -> End payroll_run_exist ');

174: where PPA.action_type IN ('R','Q')
175: and PPA.action_status = 'C'
176: and PPA.business_group_id = p_business_group_id;
177: */
178: hr_utility.trace('1110 -> End payroll_run_exist ');
179: return l_payroll_exist;
180: --}
181: EXCEPTION
182: WHEN TOO_MANY_ROWS THEN

Line 184: hr_utility.trace('1130 -> TOO_MANY_ROWS_EXCEPTION In Function'||

180: --}
181: EXCEPTION
182: WHEN TOO_MANY_ROWS THEN
183: l_payroll_exist := 'Y';
184: hr_utility.trace('1130 -> TOO_MANY_ROWS_EXCEPTION In Function'||
185: ' payroll_run_exist ');
186: hr_utility.trace('1120 -> Payroll RUN Exist in this instance');
187: return l_payroll_exist;
188: WHEN OTHERS THEN

Line 186: hr_utility.trace('1120 -> Payroll RUN Exist in this instance');

182: WHEN TOO_MANY_ROWS THEN
183: l_payroll_exist := 'Y';
184: hr_utility.trace('1130 -> TOO_MANY_ROWS_EXCEPTION In Function'||
185: ' payroll_run_exist ');
186: hr_utility.trace('1120 -> Payroll RUN Exist in this instance');
187: return l_payroll_exist;
188: WHEN OTHERS THEN
189: l_payroll_exist := 'N';
190: hr_utility.trace('1130 -> OTHER Exception payroll_run_exist ');

Line 190: hr_utility.trace('1130 -> OTHER Exception payroll_run_exist ');

186: hr_utility.trace('1120 -> Payroll RUN Exist in this instance');
187: return l_payroll_exist;
188: WHEN OTHERS THEN
189: l_payroll_exist := 'N';
190: hr_utility.trace('1130 -> OTHER Exception payroll_run_exist ');
191: hr_utility.trace('1140 -> Payroll RUN Does not exist in this instance');
192: return l_payroll_exist;
193: END payroll_run_exist;
194:

Line 191: hr_utility.trace('1140 -> Payroll RUN Does not exist in this instance');

187: return l_payroll_exist;
188: WHEN OTHERS THEN
189: l_payroll_exist := 'N';
190: hr_utility.trace('1130 -> OTHER Exception payroll_run_exist ');
191: hr_utility.trace('1140 -> Payroll RUN Does not exist in this instance');
192: return l_payroll_exist;
193: END payroll_run_exist;
194:
195: FUNCTION Current_Tax_Interface (p_lookup_code in varchar2,

Line 212: -- hr_utility.trace_on(null, 'PPSELECTINTERFACE');

208: from pay_action_parameters
209: where parameter_name = 'WAGE_ACCUMULATION_ENABLED';
210:
211: BEGIN
212: -- hr_utility.trace_on(null, 'PPSELECTINTERFACE');
213: l_current_tax_interface := 'VERTEX';
214: l_ret_value := ' ';
215: --{
216: hr_utility.trace('1200 -> Start Current_Tax_Interface ');

Line 216: hr_utility.trace('1200 -> Start Current_Tax_Interface ');

212: -- hr_utility.trace_on(null, 'PPSELECTINTERFACE');
213: l_current_tax_interface := 'VERTEX';
214: l_ret_value := ' ';
215: --{
216: hr_utility.trace('1200 -> Start Current_Tax_Interface ');
217: hr_utility.trace('1205 -> Default Tax Interface ' ||l_current_tax_interface );
218: /* Bug#5937604: Need to set the status for the new tax interface WAGEACCUM.
219: Logic to calculate status of ENHACED interface is also modified */
220: /* Bug 6658836 PLS-00103 ERROR WHEN COMPILING PAYUSVERTEXETUSG.PKB

Line 217: hr_utility.trace('1205 -> Default Tax Interface ' ||l_current_tax_interface );

213: l_current_tax_interface := 'VERTEX';
214: l_ret_value := ' ';
215: --{
216: hr_utility.trace('1200 -> Start Current_Tax_Interface ');
217: hr_utility.trace('1205 -> Default Tax Interface ' ||l_current_tax_interface );
218: /* Bug#5937604: Need to set the status for the new tax interface WAGEACCUM.
219: Logic to calculate status of ENHACED interface is also modified */
220: /* Bug 6658836 PLS-00103 ERROR WHEN COMPILING PAYUSVERTEXETUSG.PKB
221: Had a select inside a decode statment RLN*/

Line 279: hr_utility.trace('1207 -> Return Value '||l_ret_value);

275: and prt1.business_group_id IS NULL
276: and prt1.legislation_code = 'US'
277: and prt1.run_type_id = petu.run_type_id ));
278:
279: hr_utility.trace('1207 -> Return Value '||l_ret_value);
280: hr_utility.trace('1210 -> End Current_Tax_Interface');
281: return l_ret_value;
282: --}
283: EXCEPTION

Line 280: hr_utility.trace('1210 -> End Current_Tax_Interface');

276: and prt1.legislation_code = 'US'
277: and prt1.run_type_id = petu.run_type_id ));
278:
279: hr_utility.trace('1207 -> Return Value '||l_ret_value);
280: hr_utility.trace('1210 -> End Current_Tax_Interface');
281: return l_ret_value;
282: --}
283: EXCEPTION
284: WHEN NO_DATA_FOUND

Line 291: hr_utility.trace('1215 -> Current Tax Interface element is VERTEX');

287: select decode(p_lookup_code,
288: 'STANDARD', 'In Use','Not in Use')
289: into l_ret_value
290: from DUAL;
291: hr_utility.trace('1215 -> Current Tax Interface element is VERTEX');
292: hr_utility.trace('1220 -> Return Value '||l_ret_value);
293: return l_ret_value;
294: --}
295: WHEN OTHERS THEN

Line 292: hr_utility.trace('1220 -> Return Value '||l_ret_value);

288: 'STANDARD', 'In Use','Not in Use')
289: into l_ret_value
290: from DUAL;
291: hr_utility.trace('1215 -> Current Tax Interface element is VERTEX');
292: hr_utility.trace('1220 -> Return Value '||l_ret_value);
293: return l_ret_value;
294: --}
295: WHEN OTHERS THEN
296: --{

Line 298: hr_utility.trace('1225 -> Other Exception'||substr(sqlerrm,1,30));

294: --}
295: WHEN OTHERS THEN
296: --{
297:
298: hr_utility.trace('1225 -> Other Exception'||substr(sqlerrm,1,30));
299: hr_utility.trace('1226 -> '||substr(sqlerrm,31,40));
300: hr_utility.trace('1230 -> Current Tax Interface element is VERTEX');
301: select decode(p_lookup_code,
302: 'STANDARD', 'In Use','Not in Use')

Line 299: hr_utility.trace('1226 -> '||substr(sqlerrm,31,40));

295: WHEN OTHERS THEN
296: --{
297:
298: hr_utility.trace('1225 -> Other Exception'||substr(sqlerrm,1,30));
299: hr_utility.trace('1226 -> '||substr(sqlerrm,31,40));
300: hr_utility.trace('1230 -> Current Tax Interface element is VERTEX');
301: select decode(p_lookup_code,
302: 'STANDARD', 'In Use','Not in Use')
303: into l_ret_value

Line 300: hr_utility.trace('1230 -> Current Tax Interface element is VERTEX');

296: --{
297:
298: hr_utility.trace('1225 -> Other Exception'||substr(sqlerrm,1,30));
299: hr_utility.trace('1226 -> '||substr(sqlerrm,31,40));
300: hr_utility.trace('1230 -> Current Tax Interface element is VERTEX');
301: select decode(p_lookup_code,
302: 'STANDARD', 'In Use','Not in Use')
303: into l_ret_value
304: from DUAL;

Line 305: hr_utility.trace('1240 -> Return Value '||l_ret_value);

301: select decode(p_lookup_code,
302: 'STANDARD', 'In Use','Not in Use')
303: into l_ret_value
304: from DUAL;
305: hr_utility.trace('1240 -> Return Value '||l_ret_value);
306: return l_ret_value;
307:
308: --}
309: END Current_Tax_Interface;

Line 320: hr_utility.trace('1300 -> Entering vertex_eletype_usage_exist ');

316: l_element_type_usage_exist varchar2(10);
317: BEGIN
318: l_element_type_usage_exist := 'N';
319: --{
320: hr_utility.trace('1300 -> Entering vertex_eletype_usage_exist ');
321: select 'Y'
322: into l_element_type_usage_exist
323: from pay_element_types_f pet
324: where element_name = p_element_name

Line 350: hr_utility.trace('1310 -> Element Type Usage Exist for Element '|| p_element_name);

346: 'Supplemental')
347: and prt1.business_group_id IS NULL
348: and prt1.legislation_code = 'US'
349: and prt1.run_type_id = petu.run_type_id ));
350: hr_utility.trace('1310 -> Element Type Usage Exist for Element '|| p_element_name);
351: hr_utility.trace('1320 -> Leaving vertex_eletype_usage_exist ');
352: return l_element_type_usage_exist;
353: --}
354: EXCEPTION

Line 351: hr_utility.trace('1320 -> Leaving vertex_eletype_usage_exist ');

347: and prt1.business_group_id IS NULL
348: and prt1.legislation_code = 'US'
349: and prt1.run_type_id = petu.run_type_id ));
350: hr_utility.trace('1310 -> Element Type Usage Exist for Element '|| p_element_name);
351: hr_utility.trace('1320 -> Leaving vertex_eletype_usage_exist ');
352: return l_element_type_usage_exist;
353: --}
354: EXCEPTION
355: WHEN NO_DATA_FOUND

Line 359: hr_utility.trace('1330 -> Exception NO_DATA_FOUND ');

355: WHEN NO_DATA_FOUND
356: THEN
357: --{
358: l_element_type_usage_exist := 'N';
359: hr_utility.trace('1330 -> Exception NO_DATA_FOUND ');
360: hr_utility.trace('1340 -> Element Type Usages do not Exist for Element '|| p_element_name);
361: hr_utility.trace('1350 -> Leaving vertex_eletype_usage_exist ');
362: return l_element_type_usage_exist;
363: --}

Line 360: hr_utility.trace('1340 -> Element Type Usages do not Exist for Element '|| p_element_name);

356: THEN
357: --{
358: l_element_type_usage_exist := 'N';
359: hr_utility.trace('1330 -> Exception NO_DATA_FOUND ');
360: hr_utility.trace('1340 -> Element Type Usages do not Exist for Element '|| p_element_name);
361: hr_utility.trace('1350 -> Leaving vertex_eletype_usage_exist ');
362: return l_element_type_usage_exist;
363: --}
364: WHEN OTHERS THEN

Line 361: hr_utility.trace('1350 -> Leaving vertex_eletype_usage_exist ');

357: --{
358: l_element_type_usage_exist := 'N';
359: hr_utility.trace('1330 -> Exception NO_DATA_FOUND ');
360: hr_utility.trace('1340 -> Element Type Usages do not Exist for Element '|| p_element_name);
361: hr_utility.trace('1350 -> Leaving vertex_eletype_usage_exist ');
362: return l_element_type_usage_exist;
363: --}
364: WHEN OTHERS THEN
365: --{

Line 367: hr_utility.trace('1330 -> Exception OTHERS ');

363: --}
364: WHEN OTHERS THEN
365: --{
366: l_element_type_usage_exist := 'N';
367: hr_utility.trace('1330 -> Exception OTHERS ');
368: hr_utility.trace('1340 -> Element Type Usages do not Exist for Element '|| p_element_name);
369: hr_utility.trace('1350 -> Leaving vertex_eletype_usage_exist ');
370: return l_element_type_usage_exist;
371: --}

Line 368: hr_utility.trace('1340 -> Element Type Usages do not Exist for Element '|| p_element_name);

364: WHEN OTHERS THEN
365: --{
366: l_element_type_usage_exist := 'N';
367: hr_utility.trace('1330 -> Exception OTHERS ');
368: hr_utility.trace('1340 -> Element Type Usages do not Exist for Element '|| p_element_name);
369: hr_utility.trace('1350 -> Leaving vertex_eletype_usage_exist ');
370: return l_element_type_usage_exist;
371: --}
372: END vertex_eletype_usage_exist;

Line 369: hr_utility.trace('1350 -> Leaving vertex_eletype_usage_exist ');

365: --{
366: l_element_type_usage_exist := 'N';
367: hr_utility.trace('1330 -> Exception OTHERS ');
368: hr_utility.trace('1340 -> Element Type Usages do not Exist for Element '|| p_element_name);
369: hr_utility.trace('1350 -> Leaving vertex_eletype_usage_exist ');
370: return l_element_type_usage_exist;
371: --}
372: END vertex_eletype_usage_exist;
373:

Line 431: -- hr_utility.trace_on(null, 'PPSELTAX');

427: l_us_tax_vertex_etu_exist varchar2(10);
428: lv_inclusion_flag pay_element_type_usages_f.inclusion_flag%type;
429: l_null_legislation_code pay_element_types_f.legislation_code%type;
430: BEGIN
431: -- hr_utility.trace_on(null, 'PPSELTAX');
432:
433: hr_utility.trace('2000 -> Start payustaxinterface.sql ');
434: hr_utility.trace('2005 -> Parameter Values ');
435: hr_utility.trace('2006 -> Vertex_Interface Required '||p_vertex_interface);

Line 433: hr_utility.trace('2000 -> Start payustaxinterface.sql ');

429: l_null_legislation_code pay_element_types_f.legislation_code%type;
430: BEGIN
431: -- hr_utility.trace_on(null, 'PPSELTAX');
432:
433: hr_utility.trace('2000 -> Start payustaxinterface.sql ');
434: hr_utility.trace('2005 -> Parameter Values ');
435: hr_utility.trace('2006 -> Vertex_Interface Required '||p_vertex_interface);
436: hr_utility.trace('2006 -> setting for Business Group '||to_char(p_business_group_id));
437: l_null_legislation_code := NULL;

Line 434: hr_utility.trace('2005 -> Parameter Values ');

430: BEGIN
431: -- hr_utility.trace_on(null, 'PPSELTAX');
432:
433: hr_utility.trace('2000 -> Start payustaxinterface.sql ');
434: hr_utility.trace('2005 -> Parameter Values ');
435: hr_utility.trace('2006 -> Vertex_Interface Required '||p_vertex_interface);
436: hr_utility.trace('2006 -> setting for Business Group '||to_char(p_business_group_id));
437: l_null_legislation_code := NULL;
438: --{

Line 435: hr_utility.trace('2006 -> Vertex_Interface Required '||p_vertex_interface);

431: -- hr_utility.trace_on(null, 'PPSELTAX');
432:
433: hr_utility.trace('2000 -> Start payustaxinterface.sql ');
434: hr_utility.trace('2005 -> Parameter Values ');
435: hr_utility.trace('2006 -> Vertex_Interface Required '||p_vertex_interface);
436: hr_utility.trace('2006 -> setting for Business Group '||to_char(p_business_group_id));
437: l_null_legislation_code := NULL;
438: --{
439: -- This section used to set the env for Running the Startup API

Line 436: hr_utility.trace('2006 -> setting for Business Group '||to_char(p_business_group_id));

432:
433: hr_utility.trace('2000 -> Start payustaxinterface.sql ');
434: hr_utility.trace('2005 -> Parameter Values ');
435: hr_utility.trace('2006 -> Vertex_Interface Required '||p_vertex_interface);
436: hr_utility.trace('2006 -> setting for Business Group '||to_char(p_business_group_id));
437: l_null_legislation_code := NULL;
438: --{
439: -- This section used to set the env for Running the Startup API
440: --

Line 441: hr_utility.trace('2010 -> Start Setting env for Running API ');

437: l_null_legislation_code := NULL;
438: --{
439: -- This section used to set the env for Running the Startup API
440: --
441: hr_utility.trace('2010 -> Start Setting env for Running API ');
442: hr_startup_data_api_support.enable_startup_mode('USER');
443: hr_startup_data_api_support.create_owner_definition('PAY');
444: BEGIN
445: SELECT field_name

Line 463: hr_utility.trace('2020 -> Setup completed for Running API ');

459: 'US',
460: 'ENABLE',
461: 'Y');
462: END;
463: hr_utility.trace('2020 -> Setup completed for Running API ');
464:
465: IF p_vertex_interface = 'STANDARD'
466: THEN
467: hr_utility.trace('2050 -> Payroll Run exist in this Instance');

Line 467: hr_utility.trace('2050 -> Payroll Run exist in this Instance');

463: hr_utility.trace('2020 -> Setup completed for Running API ');
464:
465: IF p_vertex_interface = 'STANDARD'
466: THEN
467: hr_utility.trace('2050 -> Payroll Run exist in this Instance');
468: /*Bug#5937604: Disable WAGE_ACCUMULATION_ENABLED parameter */
469: update pay_action_parameters
470: set parameter_value= 'N'
471: where parameter_name='WAGE_ACCUMULATION_ENABLED';

Line 484: hr_utility.trace('2060 -> Deleting Element Type Usages ');

480: THEN
481: --{
482: IF l_vertex_etu_exist = 'Y'
483: THEN
484: hr_utility.trace('2060 -> Deleting Element Type Usages ');
485: pay_us_vertex_interface.delete_ele_type_usages('VERTEX', p_business_group_id);
486: /* 4220606*/
487: pay_us_vertex_interface.delete_ele_type_usages('Workers Compensation', p_business_group_id);
488:

Line 493: hr_utility.trace('2070 -> Tax Interface Script for creating');

489: END IF;
490: --
491: -- This piece of code for creating Element_Type_Usages for
492: -- Vertex Element US_TAX_VERTEX
493: hr_utility.trace('2070 -> Tax Interface Script for creating');
494: hr_utility.trace('2080 -> Element_Type_Usages for US_TAX_VERTEX');
495: for earn in c_vertex_elements('US_TAX_VERTEX')
496: loop
497: lv_inclusion_flag := 'N';

Line 494: hr_utility.trace('2080 -> Element_Type_Usages for US_TAX_VERTEX');

490: --
491: -- This piece of code for creating Element_Type_Usages for
492: -- Vertex Element US_TAX_VERTEX
493: hr_utility.trace('2070 -> Tax Interface Script for creating');
494: hr_utility.trace('2080 -> Element_Type_Usages for US_TAX_VERTEX');
495: for earn in c_vertex_elements('US_TAX_VERTEX')
496: loop
497: lv_inclusion_flag := 'N';
498: hr_utility.trace('2090 -> Inclusion Flag '||lv_inclusion_flag);

Line 498: hr_utility.trace('2090 -> Inclusion Flag '||lv_inclusion_flag);

494: hr_utility.trace('2080 -> Element_Type_Usages for US_TAX_VERTEX');
495: for earn in c_vertex_elements('US_TAX_VERTEX')
496: loop
497: lv_inclusion_flag := 'N';
498: hr_utility.trace('2090 -> Inclusion Flag '||lv_inclusion_flag);
499: for run_type in c_run_type
500: loop
501: --{
502: hr_utility.trace('2100 -> Element Type Name '||

Line 502: hr_utility.trace('2100 -> Element Type Name '||

498: hr_utility.trace('2090 -> Inclusion Flag '||lv_inclusion_flag);
499: for run_type in c_run_type
500: loop
501: --{
502: hr_utility.trace('2100 -> Element Type Name '||
503: earn.element_name);
504: hr_utility.trace('2110 -> Run Type Name '||
505: run_type.run_type_name);
506: hr_utility.trace('2120 -> Calling '

Line 504: hr_utility.trace('2110 -> Run Type Name '||

500: loop
501: --{
502: hr_utility.trace('2100 -> Element Type Name '||
503: earn.element_name);
504: hr_utility.trace('2110 -> Run Type Name '||
505: run_type.run_type_name);
506: hr_utility.trace('2120 -> Calling '
507: || 'pay_us_vertex_interface.create_ele_tp_usg ');
508: hr_utility.trace('2130 -> For creating element_type_usages '

Line 506: hr_utility.trace('2120 -> Calling '

502: hr_utility.trace('2100 -> Element Type Name '||
503: earn.element_name);
504: hr_utility.trace('2110 -> Run Type Name '||
505: run_type.run_type_name);
506: hr_utility.trace('2120 -> Calling '
507: || 'pay_us_vertex_interface.create_ele_tp_usg ');
508: hr_utility.trace('2130 -> For creating element_type_usages '
509: || 'for '|| earn.element_name);
510: pay_us_vertex_interface.create_ele_tp_usg

Line 508: hr_utility.trace('2130 -> For creating element_type_usages '

504: hr_utility.trace('2110 -> Run Type Name '||
505: run_type.run_type_name);
506: hr_utility.trace('2120 -> Calling '
507: || 'pay_us_vertex_interface.create_ele_tp_usg ');
508: hr_utility.trace('2130 -> For creating element_type_usages '
509: || 'for '|| earn.element_name);
510: pay_us_vertex_interface.create_ele_tp_usg
511: ( p_element_type_id => earn.element_type_id
512: ,p_run_type_id => run_type.run_type_id

Line 522: hr_utility.trace('2130 -> US_TAX_VERTEX element excluded');

518: ,p_legislation_code => l_null_legislation_code
519: --earn.legislation_code
520: ,p_business_group_id => p_business_group_id);
521: -- earn.business_group_id);
522: hr_utility.trace('2130 -> US_TAX_VERTEX element excluded');
523: --}
524: end loop;
525: end loop;
526: ELSIF l_us_tax_vertex_etu_exist = 'Y'

Line 531: hr_utility.trace('2060 -> Deleting Element Type Usages ');

527: THEN
528: --{
529: IF l_vertex_etu_exist = 'Y'
530: THEN
531: hr_utility.trace('2060 -> Deleting Element Type Usages ');
532: pay_us_vertex_interface.delete_ele_type_usages('VERTEX',p_business_group_id);
533: /* 4220606 */
534: pay_us_vertex_interface.delete_ele_type_usages('Workers Compensation',p_business_group_id);
535: END IF;

Line 537: hr_utility.trace('2060 -> Tax Element US_TAX_VERTEX is Excluded');

533: /* 4220606 */
534: pay_us_vertex_interface.delete_ele_type_usages('Workers Compensation',p_business_group_id);
535: END IF;
536: -- VERTEX Element is excluded and US_TAX_VERTEX is in use
537: hr_utility.trace('2060 -> Tax Element US_TAX_VERTEX is Excluded');
538: hr_utility.trace('2070 -> Tax element VERTEX is in use');
539: END IF;
540: ELSIF p_vertex_interface = 'ENHANCED' or p_vertex_interface = 'WAGEACCUM'
541: THEN

Line 538: hr_utility.trace('2070 -> Tax element VERTEX is in use');

534: pay_us_vertex_interface.delete_ele_type_usages('Workers Compensation',p_business_group_id);
535: END IF;
536: -- VERTEX Element is excluded and US_TAX_VERTEX is in use
537: hr_utility.trace('2060 -> Tax Element US_TAX_VERTEX is Excluded');
538: hr_utility.trace('2070 -> Tax element VERTEX is in use');
539: END IF;
540: ELSIF p_vertex_interface = 'ENHANCED' or p_vertex_interface = 'WAGEACCUM'
541: THEN
542: hr_utility.trace('2050 -> Payroll Run exist in this Instance');

Line 542: hr_utility.trace('2050 -> Payroll Run exist in this Instance');

538: hr_utility.trace('2070 -> Tax element VERTEX is in use');
539: END IF;
540: ELSIF p_vertex_interface = 'ENHANCED' or p_vertex_interface = 'WAGEACCUM'
541: THEN
542: hr_utility.trace('2050 -> Payroll Run exist in this Instance');
543:
544: IF p_vertex_interface = 'ENHANCED' THEN
545: /*Bug#5937604: update pay_action_paramters */
546: update pay_action_parameters

Line 585: hr_utility.trace(

581: THEN
582: --{
583: IF l_us_tax_vertex_etu_exist = 'Y'
584: THEN
585: hr_utility.trace(
586: '2060 -> Deleting Element Type Usages US_TAX_VERTEX');
587: pay_us_vertex_interface.delete_ele_type_usages('US_TAX_VERTEX',
588: p_business_group_id);
589: END IF;

Line 593: hr_utility.trace('2070 -> Tax Interface Script for creating');

589: END IF;
590: --
591: -- This piece of code for creating Element_Type_Usages for
592: -- Vertex Element VERTEX
593: hr_utility.trace('2070 -> Tax Interface Script for creating');
594: hr_utility.trace('2080 -> Element_Type_Usages for VERTEX');
595: for earn in c_vertex_elements('VERTEX')
596: loop
597: lv_inclusion_flag := 'N';

Line 594: hr_utility.trace('2080 -> Element_Type_Usages for VERTEX');

590: --
591: -- This piece of code for creating Element_Type_Usages for
592: -- Vertex Element VERTEX
593: hr_utility.trace('2070 -> Tax Interface Script for creating');
594: hr_utility.trace('2080 -> Element_Type_Usages for VERTEX');
595: for earn in c_vertex_elements('VERTEX')
596: loop
597: lv_inclusion_flag := 'N';
598: hr_utility.trace('2090 -> Inclusion Flag '||lv_inclusion_flag);

Line 598: hr_utility.trace('2090 -> Inclusion Flag '||lv_inclusion_flag);

594: hr_utility.trace('2080 -> Element_Type_Usages for VERTEX');
595: for earn in c_vertex_elements('VERTEX')
596: loop
597: lv_inclusion_flag := 'N';
598: hr_utility.trace('2090 -> Inclusion Flag '||lv_inclusion_flag);
599: for run_type in c_run_type
600: loop
601: --{
602: hr_utility.trace('2100 -> Element Type Name '||

Line 602: hr_utility.trace('2100 -> Element Type Name '||

598: hr_utility.trace('2090 -> Inclusion Flag '||lv_inclusion_flag);
599: for run_type in c_run_type
600: loop
601: --{
602: hr_utility.trace('2100 -> Element Type Name '||
603: earn.element_name);
604: hr_utility.trace('2110 -> Run Type Name '||
605: run_type.run_type_name);
606: hr_utility.trace('2120 -> Calling '

Line 604: hr_utility.trace('2110 -> Run Type Name '||

600: loop
601: --{
602: hr_utility.trace('2100 -> Element Type Name '||
603: earn.element_name);
604: hr_utility.trace('2110 -> Run Type Name '||
605: run_type.run_type_name);
606: hr_utility.trace('2120 -> Calling '
607: || 'pay_us_vertex_interface.create_ele_tp_usg ');
608: hr_utility.trace('2130 -> For creating element_type_usages '

Line 606: hr_utility.trace('2120 -> Calling '

602: hr_utility.trace('2100 -> Element Type Name '||
603: earn.element_name);
604: hr_utility.trace('2110 -> Run Type Name '||
605: run_type.run_type_name);
606: hr_utility.trace('2120 -> Calling '
607: || 'pay_us_vertex_interface.create_ele_tp_usg ');
608: hr_utility.trace('2130 -> For creating element_type_usages '
609: || 'for '|| earn.element_name);
610: pay_us_vertex_interface.create_ele_tp_usg

Line 608: hr_utility.trace('2130 -> For creating element_type_usages '

604: hr_utility.trace('2110 -> Run Type Name '||
605: run_type.run_type_name);
606: hr_utility.trace('2120 -> Calling '
607: || 'pay_us_vertex_interface.create_ele_tp_usg ');
608: hr_utility.trace('2130 -> For creating element_type_usages '
609: || 'for '|| earn.element_name);
610: pay_us_vertex_interface.create_ele_tp_usg
611: ( p_element_type_id => earn.element_type_id
612: ,p_run_type_id => run_type.run_type_id

Line 622: hr_utility.trace('2130 -> VERTEX element excluded');

618: ,p_legislation_code => l_null_legislation_code
619: --earn.legislation_code
620: ,p_business_group_id => p_business_group_id);
621: -- earn.business_group_id);
622: hr_utility.trace('2130 -> VERTEX element excluded');
623: --}
624: end loop;
625: end loop;
626:

Line 631: hr_utility.trace('2070 -> Tax Interface Script for creating');

627: /* 4220606 */
628: --
629: -- This piece of code for creating Element_Type_Usages for
630: -- Workers Compensation
631: hr_utility.trace('2070 -> Tax Interface Script for creating');
632: hr_utility.trace('2080 -> Element_Type_Usages for Workers Compensation');
633: for earn in c_vertex_elements('Workers Compensation')
634: loop
635: lv_inclusion_flag := 'N';

Line 632: hr_utility.trace('2080 -> Element_Type_Usages for Workers Compensation');

628: --
629: -- This piece of code for creating Element_Type_Usages for
630: -- Workers Compensation
631: hr_utility.trace('2070 -> Tax Interface Script for creating');
632: hr_utility.trace('2080 -> Element_Type_Usages for Workers Compensation');
633: for earn in c_vertex_elements('Workers Compensation')
634: loop
635: lv_inclusion_flag := 'N';
636: hr_utility.trace('2090 -> Inclusion Flag '||lv_inclusion_flag);

Line 636: hr_utility.trace('2090 -> Inclusion Flag '||lv_inclusion_flag);

632: hr_utility.trace('2080 -> Element_Type_Usages for Workers Compensation');
633: for earn in c_vertex_elements('Workers Compensation')
634: loop
635: lv_inclusion_flag := 'N';
636: hr_utility.trace('2090 -> Inclusion Flag '||lv_inclusion_flag);
637: for run_type in c_run_type
638: loop
639: --{
640: hr_utility.trace('2100 -> Element Type Name '||

Line 640: hr_utility.trace('2100 -> Element Type Name '||

636: hr_utility.trace('2090 -> Inclusion Flag '||lv_inclusion_flag);
637: for run_type in c_run_type
638: loop
639: --{
640: hr_utility.trace('2100 -> Element Type Name '||
641: earn.element_name);
642: hr_utility.trace('2110 -> Run Type Name '||
643: run_type.run_type_name);
644: hr_utility.trace('2120 -> Calling '

Line 642: hr_utility.trace('2110 -> Run Type Name '||

638: loop
639: --{
640: hr_utility.trace('2100 -> Element Type Name '||
641: earn.element_name);
642: hr_utility.trace('2110 -> Run Type Name '||
643: run_type.run_type_name);
644: hr_utility.trace('2120 -> Calling '
645: || 'pay_us_vertex_interface.create_ele_tp_usg ');
646: hr_utility.trace('2130 -> For creating element_type_usages '

Line 644: hr_utility.trace('2120 -> Calling '

640: hr_utility.trace('2100 -> Element Type Name '||
641: earn.element_name);
642: hr_utility.trace('2110 -> Run Type Name '||
643: run_type.run_type_name);
644: hr_utility.trace('2120 -> Calling '
645: || 'pay_us_vertex_interface.create_ele_tp_usg ');
646: hr_utility.trace('2130 -> For creating element_type_usages '
647: || 'for '|| earn.element_name);
648: pay_us_vertex_interface.create_ele_tp_usg

Line 646: hr_utility.trace('2130 -> For creating element_type_usages '

642: hr_utility.trace('2110 -> Run Type Name '||
643: run_type.run_type_name);
644: hr_utility.trace('2120 -> Calling '
645: || 'pay_us_vertex_interface.create_ele_tp_usg ');
646: hr_utility.trace('2130 -> For creating element_type_usages '
647: || 'for '|| earn.element_name);
648: pay_us_vertex_interface.create_ele_tp_usg
649: ( p_element_type_id => earn.element_type_id
650: ,p_run_type_id => run_type.run_type_id

Line 660: hr_utility.trace('2130 -> VERTEX element excluded');

656: ,p_legislation_code => l_null_legislation_code
657: --earn.legislation_code
658: ,p_business_group_id => p_business_group_id);
659: -- earn.business_group_id);
660: hr_utility.trace('2130 -> VERTEX element excluded');
661: --}
662: end loop;
663: end loop;
664: /* 42206060 */

Line 670: hr_utility.trace('2060 -> Deleting Element Type Usages ');

666: THEN
667: --{
668: IF l_us_tax_vertex_etu_exist = 'Y'
669: THEN
670: hr_utility.trace('2060 -> Deleting Element Type Usages ');
671: pay_us_vertex_interface.delete_ele_type_usages('US_TAX_VERTEX',
672: p_business_group_id);
673: END IF;
674: -- VERTEX Element is excluded and US_TAX_VERTEX is in use

Line 675: hr_utility.trace('2060 -> Tax Element VERTEX is Excluded');

671: pay_us_vertex_interface.delete_ele_type_usages('US_TAX_VERTEX',
672: p_business_group_id);
673: END IF;
674: -- VERTEX Element is excluded and US_TAX_VERTEX is in use
675: hr_utility.trace('2060 -> Tax Element VERTEX is Excluded');
676: hr_utility.trace('2070 -> Tax element US_TAX_VERTEX is in use');
677: END IF;
678: END IF;
679: --}

Line 676: hr_utility.trace('2070 -> Tax element US_TAX_VERTEX is in use');

672: p_business_group_id);
673: END IF;
674: -- VERTEX Element is excluded and US_TAX_VERTEX is in use
675: hr_utility.trace('2060 -> Tax Element VERTEX is Excluded');
676: hr_utility.trace('2070 -> Tax element US_TAX_VERTEX is in use');
677: END IF;
678: END IF;
679: --}
680: END select_tax_interface;