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.

[Home] [Help]

APPS.PAY_US_W2C_REPORTING_UTILS dependencies on HR_UTILITY

Line 86: hr_utility.set_location

82: AND UE.creator_type = 'B'
83: AND UE.legislation_code = 'US';
84: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
85: BEGIN
86: hr_utility.set_location
87: (gv_package || '.bal_db_item - opening cursor', 10);
88: -- Open the cursor
89: OPEN csr_defined_balance;
90: -- Fetch the value

Line 95: hr_utility.set_location

91: FETCH csr_defined_balance
92: INTO l_defined_balance_id;
93: IF csr_defined_balance%NOTFOUND THEN
94: CLOSE csr_defined_balance;
95: hr_utility.set_location
96: (gv_package || '.bal_db_item - no rows found ', 20);
97: hr_utility.raise_error;
98: ELSE
99: hr_utility.set_location

Line 97: hr_utility.raise_error;

93: IF csr_defined_balance%NOTFOUND THEN
94: CLOSE csr_defined_balance;
95: hr_utility.set_location
96: (gv_package || '.bal_db_item - no rows found ', 20);
97: hr_utility.raise_error;
98: ELSE
99: hr_utility.set_location
100: (gv_package || '.bal_db_item - Row fetched from cursor', 30);
101: CLOSE csr_defined_balance;

Line 99: hr_utility.set_location

95: hr_utility.set_location
96: (gv_package || '.bal_db_item - no rows found ', 20);
97: hr_utility.raise_error;
98: ELSE
99: hr_utility.set_location
100: (gv_package || '.bal_db_item - Row fetched from cursor', 30);
101: CLOSE csr_defined_balance;
102: END IF;
103: /* Return the value to the call */

Line 140: hr_utility.set_location(gv_package || '.get_payroll_action_info', 10);

136: lv_report_qualifier varchar2(50);
137: ln_business_group_id number;
138:
139: BEGIN
140: hr_utility.set_location(gv_package || '.get_payroll_action_info', 10);
141:
142: open c_payroll_action(p_payroll_action_id);
143: fetch c_payroll_action into
144: ld_start_date,

Line 150: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);

146: lv_report_type,
147: lv_report_qualifier,
148: ln_business_group_id;
149: if c_payroll_action%notfound then
150: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
151: hr_utility.trace('Payroll Action '||to_char(p_payroll_action_id)||' Not found');
152: hr_utility.raise_error;
153: end if;
154: close c_payroll_action;

Line 151: hr_utility.trace('Payroll Action '||to_char(p_payroll_action_id)||' Not found');

147: lv_report_qualifier,
148: ln_business_group_id;
149: if c_payroll_action%notfound then
150: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
151: hr_utility.trace('Payroll Action '||to_char(p_payroll_action_id)||' Not found');
152: hr_utility.raise_error;
153: end if;
154: close c_payroll_action;
155: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);

Line 152: hr_utility.raise_error;

148: ln_business_group_id;
149: if c_payroll_action%notfound then
150: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
151: hr_utility.trace('Payroll Action '||to_char(p_payroll_action_id)||' Not found');
152: hr_utility.raise_error;
153: end if;
154: close c_payroll_action;
155: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
156: p_start_date := ld_start_date;

Line 155: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);

151: hr_utility.trace('Payroll Action '||to_char(p_payroll_action_id)||' Not found');
152: hr_utility.raise_error;
153: end if;
154: close c_payroll_action;
155: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
156: p_start_date := ld_start_date;
157: p_end_date := ld_end_date;
158: p_report_type := lv_report_type;
159: p_report_qualifier := lv_report_qualifier;

Line 161: hr_utility.set_location(gv_package || '.get_payroll_action_info', 40);

157: p_end_date := ld_end_date;
158: p_report_type := lv_report_type;
159: p_report_qualifier := lv_report_qualifier;
160: p_business_group_id := ln_business_group_id;
161: hr_utility.set_location(gv_package || '.get_payroll_action_info', 40);
162: END get_payroll_action_info;
163:
164: -------------------------------------------------------------------------
165: -- Name : get_balance_value

Line 189: hr_utility.set_location(gv_package || '.get_balance_value', 10);

185: p_effective_date DATE
186: ) RETURN NUMBER IS
187: l_jurisdiction_code VARCHAR2(20);
188: BEGIN
189: hr_utility.set_location(gv_package || '.get_balance_value', 10);
190: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
191: IF p_state_abbrev <> 'FED' THEN
192: SELECT jurisdiction_code
193: INTO l_jurisdiction_code

Line 196: hr_utility.set_location(gv_package || '.get_balance_value', 20);

192: SELECT jurisdiction_code
193: INTO l_jurisdiction_code
194: FROM pay_state_rules
195: WHERE state_code = p_state_abbrev;
196: hr_utility.set_location(gv_package || '.get_balance_value', 20);
197: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
198: END IF;
199: hr_utility.trace('Balance Name : '||p_balance_name);
200: hr_utility.trace('Context');

Line 199: hr_utility.trace('Balance Name : '||p_balance_name);

195: WHERE state_code = p_state_abbrev;
196: hr_utility.set_location(gv_package || '.get_balance_value', 20);
197: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
198: END IF;
199: hr_utility.trace('Balance Name : '||p_balance_name);
200: hr_utility.trace('Context');
201: hr_utility.trace(' Tax Unit Id : '|| p_tax_unit_id);
202: hr_utility.trace(' Jurisdiction: '|| l_jurisdiction_code);
203: hr_utility.set_location('pay_us_mmref_reporting.get_balance_value', 30);

Line 200: hr_utility.trace('Context');

196: hr_utility.set_location(gv_package || '.get_balance_value', 20);
197: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
198: END IF;
199: hr_utility.trace('Balance Name : '||p_balance_name);
200: hr_utility.trace('Context');
201: hr_utility.trace(' Tax Unit Id : '|| p_tax_unit_id);
202: hr_utility.trace(' Jurisdiction: '|| l_jurisdiction_code);
203: hr_utility.set_location('pay_us_mmref_reporting.get_balance_value', 30);
204: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),

Line 201: hr_utility.trace(' Tax Unit Id : '|| p_tax_unit_id);

197: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
198: END IF;
199: hr_utility.trace('Balance Name : '||p_balance_name);
200: hr_utility.trace('Context');
201: hr_utility.trace(' Tax Unit Id : '|| p_tax_unit_id);
202: hr_utility.trace(' Jurisdiction: '|| l_jurisdiction_code);
203: hr_utility.set_location('pay_us_mmref_reporting.get_balance_value', 30);
204: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
205: p_assignment_id,

Line 202: hr_utility.trace(' Jurisdiction: '|| l_jurisdiction_code);

198: END IF;
199: hr_utility.trace('Balance Name : '||p_balance_name);
200: hr_utility.trace('Context');
201: hr_utility.trace(' Tax Unit Id : '|| p_tax_unit_id);
202: hr_utility.trace(' Jurisdiction: '|| l_jurisdiction_code);
203: hr_utility.set_location('pay_us_mmref_reporting.get_balance_value', 30);
204: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
205: p_assignment_id,
206: p_effective_date);

Line 203: hr_utility.set_location('pay_us_mmref_reporting.get_balance_value', 30);

199: hr_utility.trace('Balance Name : '||p_balance_name);
200: hr_utility.trace('Context');
201: hr_utility.trace(' Tax Unit Id : '|| p_tax_unit_id);
202: hr_utility.trace(' Jurisdiction: '|| l_jurisdiction_code);
203: hr_utility.set_location('pay_us_mmref_reporting.get_balance_value', 30);
204: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
205: p_assignment_id,
206: p_effective_date);
207: END get_balance_value;

Line 285: hr_utility.set_location(gv_package || '.preprocess_check', 10);

281: and ppa1.report_type = 'W2C'
282: and ppa1.report_qualifier = 'FED'
283: and ppa1.action_status = 'C');
284: BEGIN
285: hr_utility.set_location(gv_package || '.preprocess_check', 10);
286: lv_message_preprocess := 'Pre-Process check';
287: --
288: -- Determine whether any W-2c paper assignment action exist for W-2c mag
289: -- pick up. If not log a message for user

Line 297: hr_utility.set_location(gv_package || '.preprocess_check', 20);

293: p_year_end);
294: FETCH c_w2c_paper_exist INTO ln_count_of_w2c_paper;
295: if c_w2c_paper_exist%ROWCOUNT = 0 or c_w2c_paper_exist%NOTFOUND
296: then
297: hr_utility.set_location(gv_package || '.preprocess_check', 20);
298: /* message to user -- unable to find any W-2c Paper report for
299: genrating W-2c Mag */
300: lv_message_text := 'No W-2c paper printed for processing W-2c Mag Tape';
301: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

Line 306: hr_utility.set_location(gv_package || '.preprocess_check', 30);

302: pay_core_utils.push_token('record_name',lv_message_preprocess);
303: pay_core_utils.push_token('description',lv_message_text);
304: lb_return_value := FALSE;
305: CLOSE c_w2c_paper_exist;
306: hr_utility.set_location(gv_package || '.preprocess_check', 30);
307: else
308: CLOSE c_w2c_paper_exist;
309: lb_return_value := TRUE;
310: hr_utility.set_location(gv_package || '.preprocess_check', 30);

Line 310: hr_utility.set_location(gv_package || '.preprocess_check', 30);

306: hr_utility.set_location(gv_package || '.preprocess_check', 30);
307: else
308: CLOSE c_w2c_paper_exist;
309: lb_return_value := TRUE;
310: hr_utility.set_location(gv_package || '.preprocess_check', 30);
311: end if;
312: hr_utility.set_location(gv_package || '.preprocess_check', 40);
313: return lb_return_value;
314: END preprocess_check;

Line 312: hr_utility.set_location(gv_package || '.preprocess_check', 40);

308: CLOSE c_w2c_paper_exist;
309: lb_return_value := TRUE;
310: hr_utility.set_location(gv_package || '.preprocess_check', 30);
311: end if;
312: hr_utility.set_location(gv_package || '.preprocess_check', 40);
313: return lb_return_value;
314: END preprocess_check;
315: -- End of Function Preprocess_Check
316:

Line 350: hr_utility.set_location(gv_package || '.get_eoy_action_info', 10);

346: 'TRANSFER_GRE') = cp_w2c_tax_unit_id;
347: ln_eoy_pactid number :=0;
348: ln_eoy_asg_actid number :=0;
349: BEGIN
350: hr_utility.set_location(gv_package || '.get_eoy_action_info', 10);
351: hr_utility.trace('Effective Date '||to_char(p_eoy_effective_date,'dd-mon-yyyy') );
352: hr_utility.trace('Tax Unit Id '||to_char(p_eoy_tax_unit_id));
353: hr_utility.trace('Entered get_eoy_action_info');
354: open get_eoy_info(p_eoy_effective_date

Line 351: hr_utility.trace('Effective Date '||to_char(p_eoy_effective_date,'dd-mon-yyyy') );

347: ln_eoy_pactid number :=0;
348: ln_eoy_asg_actid number :=0;
349: BEGIN
350: hr_utility.set_location(gv_package || '.get_eoy_action_info', 10);
351: hr_utility.trace('Effective Date '||to_char(p_eoy_effective_date,'dd-mon-yyyy') );
352: hr_utility.trace('Tax Unit Id '||to_char(p_eoy_tax_unit_id));
353: hr_utility.trace('Entered get_eoy_action_info');
354: open get_eoy_info(p_eoy_effective_date
355: ,p_eoy_tax_unit_id

Line 352: hr_utility.trace('Tax Unit Id '||to_char(p_eoy_tax_unit_id));

348: ln_eoy_asg_actid number :=0;
349: BEGIN
350: hr_utility.set_location(gv_package || '.get_eoy_action_info', 10);
351: hr_utility.trace('Effective Date '||to_char(p_eoy_effective_date,'dd-mon-yyyy') );
352: hr_utility.trace('Tax Unit Id '||to_char(p_eoy_tax_unit_id));
353: hr_utility.trace('Entered get_eoy_action_info');
354: open get_eoy_info(p_eoy_effective_date
355: ,p_eoy_tax_unit_id
356: ,p_assignment_id

Line 353: hr_utility.trace('Entered get_eoy_action_info');

349: BEGIN
350: hr_utility.set_location(gv_package || '.get_eoy_action_info', 10);
351: hr_utility.trace('Effective Date '||to_char(p_eoy_effective_date,'dd-mon-yyyy') );
352: hr_utility.trace('Tax Unit Id '||to_char(p_eoy_tax_unit_id));
353: hr_utility.trace('Entered get_eoy_action_info');
354: open get_eoy_info(p_eoy_effective_date
355: ,p_eoy_tax_unit_id
356: ,p_assignment_id
357: );

Line 358: hr_utility.set_location(gv_package || '.get_eoy_action_info', 20);

354: open get_eoy_info(p_eoy_effective_date
355: ,p_eoy_tax_unit_id
356: ,p_assignment_id
357: );
358: hr_utility.set_location(gv_package || '.get_eoy_action_info', 20);
359: hr_utility.trace('Opened get_eoy_info');
360:
361: fetch get_eoy_info into ln_eoy_pactid,
362: ln_eoy_asg_actid;

Line 359: hr_utility.trace('Opened get_eoy_info');

355: ,p_eoy_tax_unit_id
356: ,p_assignment_id
357: );
358: hr_utility.set_location(gv_package || '.get_eoy_action_info', 20);
359: hr_utility.trace('Opened get_eoy_info');
360:
361: fetch get_eoy_info into ln_eoy_pactid,
362: ln_eoy_asg_actid;
363: hr_utility.trace('Fetched get_eoy_info ');

Line 363: hr_utility.trace('Fetched get_eoy_info ');

359: hr_utility.trace('Opened get_eoy_info');
360:
361: fetch get_eoy_info into ln_eoy_pactid,
362: ln_eoy_asg_actid;
363: hr_utility.trace('Fetched get_eoy_info ');
364: close get_eoy_info;
365:
366: hr_utility.trace('Closed get_eoy_info ');
367: p_eoy_pactid := ln_eoy_pactid;

Line 366: hr_utility.trace('Closed get_eoy_info ');

362: ln_eoy_asg_actid;
363: hr_utility.trace('Fetched get_eoy_info ');
364: close get_eoy_info;
365:
366: hr_utility.trace('Closed get_eoy_info ');
367: p_eoy_pactid := ln_eoy_pactid;
368: p_eoy_asg_actid := ln_eoy_asg_actid;
369: hr_utility.trace('ln_eoy_pactid = ' || to_char(ln_eoy_pactid));
370: hr_utility.trace('ln_eoy_asg_actid = ' || to_char(ln_eoy_asg_actid));

Line 369: hr_utility.trace('ln_eoy_pactid = ' || to_char(ln_eoy_pactid));

365:
366: hr_utility.trace('Closed get_eoy_info ');
367: p_eoy_pactid := ln_eoy_pactid;
368: p_eoy_asg_actid := ln_eoy_asg_actid;
369: hr_utility.trace('ln_eoy_pactid = ' || to_char(ln_eoy_pactid));
370: hr_utility.trace('ln_eoy_asg_actid = ' || to_char(ln_eoy_asg_actid));
371: hr_utility.set_location(gv_package || '.get_eoy_action_info', 30);
372: hr_utility.trace('Leaving get_eoy_action_info');
373: EXCEPTION

Line 370: hr_utility.trace('ln_eoy_asg_actid = ' || to_char(ln_eoy_asg_actid));

366: hr_utility.trace('Closed get_eoy_info ');
367: p_eoy_pactid := ln_eoy_pactid;
368: p_eoy_asg_actid := ln_eoy_asg_actid;
369: hr_utility.trace('ln_eoy_pactid = ' || to_char(ln_eoy_pactid));
370: hr_utility.trace('ln_eoy_asg_actid = ' || to_char(ln_eoy_asg_actid));
371: hr_utility.set_location(gv_package || '.get_eoy_action_info', 30);
372: hr_utility.trace('Leaving get_eoy_action_info');
373: EXCEPTION
374: when others then

Line 371: hr_utility.set_location(gv_package || '.get_eoy_action_info', 30);

367: p_eoy_pactid := ln_eoy_pactid;
368: p_eoy_asg_actid := ln_eoy_asg_actid;
369: hr_utility.trace('ln_eoy_pactid = ' || to_char(ln_eoy_pactid));
370: hr_utility.trace('ln_eoy_asg_actid = ' || to_char(ln_eoy_asg_actid));
371: hr_utility.set_location(gv_package || '.get_eoy_action_info', 30);
372: hr_utility.trace('Leaving get_eoy_action_info');
373: EXCEPTION
374: when others then
375: hr_utility.trace('Error in ' || gv_package || '.get_eoy_action_info' ||

Line 372: hr_utility.trace('Leaving get_eoy_action_info');

368: p_eoy_asg_actid := ln_eoy_asg_actid;
369: hr_utility.trace('ln_eoy_pactid = ' || to_char(ln_eoy_pactid));
370: hr_utility.trace('ln_eoy_asg_actid = ' || to_char(ln_eoy_asg_actid));
371: hr_utility.set_location(gv_package || '.get_eoy_action_info', 30);
372: hr_utility.trace('Leaving get_eoy_action_info');
373: EXCEPTION
374: when others then
375: hr_utility.trace('Error in ' || gv_package || '.get_eoy_action_info' ||
376: to_char(sqlcode) || '-' || sqlerrm);

Line 375: hr_utility.trace('Error in ' || gv_package || '.get_eoy_action_info' ||

371: hr_utility.set_location(gv_package || '.get_eoy_action_info', 30);
372: hr_utility.trace('Leaving get_eoy_action_info');
373: EXCEPTION
374: when others then
375: hr_utility.trace('Error in ' || gv_package || '.get_eoy_action_info' ||
376: to_char(sqlcode) || '-' || sqlerrm);
377: hr_utility.set_location(gv_package || '.get_eoy_action_info', 40);
378: raise hr_utility.hr_error;
379: END get_eoy_action_info;

Line 377: hr_utility.set_location(gv_package || '.get_eoy_action_info', 40);

373: EXCEPTION
374: when others then
375: hr_utility.trace('Error in ' || gv_package || '.get_eoy_action_info' ||
376: to_char(sqlcode) || '-' || sqlerrm);
377: hr_utility.set_location(gv_package || '.get_eoy_action_info', 40);
378: raise hr_utility.hr_error;
379: END get_eoy_action_info;
380:
381: /******************************************************************

Line 378: raise hr_utility.hr_error;

374: when others then
375: hr_utility.trace('Error in ' || gv_package || '.get_eoy_action_info' ||
376: to_char(sqlcode) || '-' || sqlerrm);
377: hr_utility.set_location(gv_package || '.get_eoy_action_info', 40);
378: raise hr_utility.hr_error;
379: END get_eoy_action_info;
380:
381: /******************************************************************
382: ** Range Code to pick all the distinct assignment_ids

Line 396: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 10);

392: lv_report_qualifier varchar2(30);
393: ln_business_group_id number;
394: lv_sql_string varchar2(10000);
395: BEGIN
396: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 10);
397: get_payroll_action_info ( p_payroll_action_id
398: ,ld_start_date
399: ,ld_end_date
400: ,lv_report_type

Line 404: hr_utility.trace('ld_start_date = ' || ld_start_date);

400: ,lv_report_type
401: ,lv_report_qualifier
402: ,ln_business_group_id
403: );
404: hr_utility.trace('ld_start_date = ' || ld_start_date);
405: hr_utility.trace('ld_end_date = ' || ld_end_date);
406: hr_utility.trace('lv_report_type = ' || lv_report_type);
407: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
408: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);

Line 405: hr_utility.trace('ld_end_date = ' || ld_end_date);

401: ,lv_report_qualifier
402: ,ln_business_group_id
403: );
404: hr_utility.trace('ld_start_date = ' || ld_start_date);
405: hr_utility.trace('ld_end_date = ' || ld_end_date);
406: hr_utility.trace('lv_report_type = ' || lv_report_type);
407: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
408: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
409:

Line 406: hr_utility.trace('lv_report_type = ' || lv_report_type);

402: ,ln_business_group_id
403: );
404: hr_utility.trace('ld_start_date = ' || ld_start_date);
405: hr_utility.trace('ld_end_date = ' || ld_end_date);
406: hr_utility.trace('lv_report_type = ' || lv_report_type);
407: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
408: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
409:
410: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 20);

Line 407: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);

403: );
404: hr_utility.trace('ld_start_date = ' || ld_start_date);
405: hr_utility.trace('ld_end_date = ' || ld_end_date);
406: hr_utility.trace('lv_report_type = ' || lv_report_type);
407: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
408: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
409:
410: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 20);
411:

Line 408: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);

404: hr_utility.trace('ld_start_date = ' || ld_start_date);
405: hr_utility.trace('ld_end_date = ' || ld_end_date);
406: hr_utility.trace('lv_report_type = ' || lv_report_type);
407: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
408: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
409:
410: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 20);
411:
412: if preprocess_check ( p_payroll_action_id

Line 410: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 20);

406: hr_utility.trace('lv_report_type = ' || lv_report_type);
407: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
408: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
409:
410: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 20);
411:
412: if preprocess_check ( p_payroll_action_id
413: ,ld_start_date
414: ,ld_end_date

Line 418: hr_utility.trace('W-2c Assignment picked up for processing W-2c Mag' );

414: ,ld_end_date
415: ,ln_business_group_id
416: )
417: then
418: hr_utility.trace('W-2c Assignment picked up for processing W-2c Mag' );
419: else
420: hr_utility.trace('No W-2c Assignment picked up for processing W-2c Mag');
421: end if;
422: --{

Line 420: hr_utility.trace('No W-2c Assignment picked up for processing W-2c Mag');

416: )
417: then
418: hr_utility.trace('W-2c Assignment picked up for processing W-2c Mag' );
419: else
420: hr_utility.trace('No W-2c Assignment picked up for processing W-2c Mag');
421: end if;
422: --{
423:
424: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 30);

Line 424: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 30);

420: hr_utility.trace('No W-2c Assignment picked up for processing W-2c Mag');
421: end if;
422: --{
423:
424: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 30);
425: if (lv_report_type = 'W2C' and lv_report_qualifier = 'FED') then
426: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 40);
427: lv_sql_string :=
428: 'select distinct paf.person_id

Line 426: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 40);

422: --{
423:
424: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 30);
425: if (lv_report_type = 'W2C' and lv_report_qualifier = 'FED') then
426: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 40);
427: lv_sql_string :=
428: 'select distinct paf.person_id
429: from pay_assignment_actions paa,
430: per_all_assignments_f paf,

Line 473: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 50);

469: and ppa1.report_type = ''W2C''
470: and ppa1.report_qualifier = ''FED''
471: and ppa1.action_status = ''C'')';
472: p_sqlstr := lv_sql_string;
473: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 50);
474: --hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
475: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
476: hr_utility.trace('Procedure w2c_mag_range_cursor completed successfully');
477: else

Line 474: --hr_utility.trace('p_sqlstr = ' ||p_sqlstr);

470: and ppa1.report_qualifier = ''FED''
471: and ppa1.action_status = ''C'')';
472: p_sqlstr := lv_sql_string;
473: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 50);
474: --hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
475: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
476: hr_utility.trace('Procedure w2c_mag_range_cursor completed successfully');
477: else
478: hr_utility.trace('Procedure w2c_mag_range_cursor Unsucessful ... ');

Line 475: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );

471: and ppa1.action_status = ''C'')';
472: p_sqlstr := lv_sql_string;
473: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 50);
474: --hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
475: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
476: hr_utility.trace('Procedure w2c_mag_range_cursor completed successfully');
477: else
478: hr_utility.trace('Procedure w2c_mag_range_cursor Unsucessful ... ');
479: end if;

Line 476: hr_utility.trace('Procedure w2c_mag_range_cursor completed successfully');

472: p_sqlstr := lv_sql_string;
473: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 50);
474: --hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
475: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
476: hr_utility.trace('Procedure w2c_mag_range_cursor completed successfully');
477: else
478: hr_utility.trace('Procedure w2c_mag_range_cursor Unsucessful ... ');
479: end if;
480: --}

Line 478: hr_utility.trace('Procedure w2c_mag_range_cursor Unsucessful ... ');

474: --hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
475: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
476: hr_utility.trace('Procedure w2c_mag_range_cursor completed successfully');
477: else
478: hr_utility.trace('Procedure w2c_mag_range_cursor Unsucessful ... ');
479: end if;
480: --}
481:
482: end w2c_mag_range_cursor;

Line 847: hr_utility.set_location(gv_package || '.action_creation', 10);

843: ln_serial_number pay_assignment_actions.serial_number%TYPE;
844: ln_notlocked_asgn_actid number;
845:
846: BEGIN
847: hr_utility.set_location(gv_package || '.action_creation', 10);
848: -- Corrected Assignment Action would be the W-2c Pre-Process Action_ID
849: --
850: if lp_w2c_pp_asg_action_id > 0 then
851: hr_utility.set_location(gv_package || '.action_creation', 20);

Line 851: hr_utility.set_location(gv_package || '.action_creation', 20);

847: hr_utility.set_location(gv_package || '.action_creation', 10);
848: -- Corrected Assignment Action would be the W-2c Pre-Process Action_ID
849: --
850: if lp_w2c_pp_asg_action_id > 0 then
851: hr_utility.set_location(gv_package || '.action_creation', 20);
852: ln_corrected_asg_action := lp_w2c_pp_asg_action_id;
853: end if;
854: hr_utility.set_location(gv_package || '.action_creation', 30);
855: --

Line 854: hr_utility.set_location(gv_package || '.action_creation', 30);

850: if lp_w2c_pp_asg_action_id > 0 then
851: hr_utility.set_location(gv_package || '.action_creation', 20);
852: ln_corrected_asg_action := lp_w2c_pp_asg_action_id;
853: end if;
854: hr_utility.set_location(gv_package || '.action_creation', 30);
855: --
856: -- Determine the EOY Action_ID
857: --
858: get_eoy_action_info(lp_effective_date

Line 863: hr_utility.set_location(gv_package || '.action_creation', 40);

859: ,lp_tax_unit_id
860: ,lp_assignment_id
861: ,ln_eoy_payroll_action_id
862: ,ln_eoy_assignment_action_id);
863: hr_utility.set_location(gv_package || '.action_creation', 40);
864: -- Ideally if one correction made to W-2c and Previously reported archived
865: -- values will be from YE archive. Check whether W-2c Pre-process locks
866: -- the YE Pre-process. If yes then previously reported values can be
867: -- derived from YE pre-process

Line 871: hr_utility.set_location(gv_package || '.action_creation', 50);

867: -- derived from YE pre-process
868:
869: if lp_w2c_pp_locked_actid = ln_eoy_assignment_action_id
870: then
871: hr_utility.set_location(gv_package || '.action_creation', 50);
872: ln_orig_reported_asg_action := lp_w2c_pp_locked_actid;
873: else
874: --{
875: hr_utility.set_location(gv_package || '.action_creation', 60);

Line 875: hr_utility.set_location(gv_package || '.action_creation', 60);

871: hr_utility.set_location(gv_package || '.action_creation', 50);
872: ln_orig_reported_asg_action := lp_w2c_pp_locked_actid;
873: else
874: --{
875: hr_utility.set_location(gv_package || '.action_creation', 60);
876: -- This indicates there is multiple W-2c or a Mark W-2c paper process ran
877: -- or a Federal W-2c Magnetic Process ran and reported for a set of W-2c.
878: -- Determine the last W-2c paper reported
879: OPEN get_last_reported_action(lp_business_group_id

Line 885: hr_utility.set_location(gv_package || '.action_creation', 70);

881: ,lp_effective_date
882: ,lp_person_id
883: ,lp_assignment_action_id);
884: -- ,ln_corrected_asg_action);
885: hr_utility.set_location(gv_package || '.action_creation', 70);
886: LOOP
887: FETCH get_last_reported_action INTO ln_last_w2cp_pactid,
888: ln_last_w2cp_asg_actid,
889: ln_last_w2cpp_asg_action_id;

Line 891: hr_utility.set_location(gv_package || '.action_creation', 80);

887: FETCH get_last_reported_action INTO ln_last_w2cp_pactid,
888: ln_last_w2cp_asg_actid,
889: ln_last_w2cpp_asg_action_id;
890:
891: hr_utility.set_location(gv_package || '.action_creation', 80);
892: if get_last_reported_action%ROWCOUNT = 0 then
893: hr_utility.set_location(gv_package || '.action_creation', 90);
894: hr_utility.trace('There is No other W-2c submitted to govt');
895: -- This condition will hold good if multiple W-2c paper printed

Line 893: hr_utility.set_location(gv_package || '.action_creation', 90);

889: ln_last_w2cpp_asg_action_id;
890:
891: hr_utility.set_location(gv_package || '.action_creation', 80);
892: if get_last_reported_action%ROWCOUNT = 0 then
893: hr_utility.set_location(gv_package || '.action_creation', 90);
894: hr_utility.trace('There is No other W-2c submitted to govt');
895: -- This condition will hold good if multiple W-2c paper printed
896: -- for employee but not reported to Govt. For this scenario
897: -- YE Pre-process would be considered as previously reported

Line 894: hr_utility.trace('There is No other W-2c submitted to govt');

890:
891: hr_utility.set_location(gv_package || '.action_creation', 80);
892: if get_last_reported_action%ROWCOUNT = 0 then
893: hr_utility.set_location(gv_package || '.action_creation', 90);
894: hr_utility.trace('There is No other W-2c submitted to govt');
895: -- This condition will hold good if multiple W-2c paper printed
896: -- for employee but not reported to Govt. For this scenario
897: -- YE Pre-process would be considered as previously reported
898: -- action.

Line 904: hr_utility.set_location(gv_package || '.action_creation', 100);

900: exit;
901: end if;
902: EXIT WHEN get_last_reported_action%NOTFOUND;
903: if ln_last_w2cp_asg_actid IS NOT NULL then
904: hr_utility.set_location(gv_package || '.action_creation', 100);
905: -- This scenario would exist if a W-2 correction is reported
906: -- either in paper form or in Magnetic Media
907: ln_orig_reported_asg_action := ln_last_w2cpp_asg_action_id;
908: exit;

Line 915: hr_utility.set_location(gv_package || '.action_creation', 110);

911: CLOSE get_last_reported_action;
912: --}
913: end if;
914: --
915: hr_utility.set_location(gv_package || '.action_creation', 110);
916: hr_utility.trace('Corrected Assignment_Action_ID '||
917: to_char(ln_corrected_asg_action));
918: hr_utility.trace('Originally Reported Assignment_Action_ID '||
919: to_char(ln_orig_reported_asg_action));

Line 916: hr_utility.trace('Corrected Assignment_Action_ID '||

912: --}
913: end if;
914: --
915: hr_utility.set_location(gv_package || '.action_creation', 110);
916: hr_utility.trace('Corrected Assignment_Action_ID '||
917: to_char(ln_corrected_asg_action));
918: hr_utility.trace('Originally Reported Assignment_Action_ID '||
919: to_char(ln_orig_reported_asg_action));
920:

Line 918: hr_utility.trace('Originally Reported Assignment_Action_ID '||

914: --
915: hr_utility.set_location(gv_package || '.action_creation', 110);
916: hr_utility.trace('Corrected Assignment_Action_ID '||
917: to_char(ln_corrected_asg_action));
918: hr_utility.trace('Originally Reported Assignment_Action_ID '||
919: to_char(ln_orig_reported_asg_action));
920:
921: /* Create an assignment action for this person */
922: select pay_assignment_actions_s.nextval

Line 925: hr_utility.set_location(gv_package || '.action_creation', 120);

921: /* Create an assignment action for this person */
922: select pay_assignment_actions_s.nextval
923: into ln_w2c_asg_action
924: from dual;
925: hr_utility.set_location(gv_package || '.action_creation', 120);
926: hr_utility.trace('New w2c Action = ' || to_char(ln_w2c_asg_action));
927:
928: /* Insert into pay_assignment_actions. */
929: hr_utility.trace('Creating Assignment Action');

Line 926: hr_utility.trace('New w2c Action = ' || to_char(ln_w2c_asg_action));

922: select pay_assignment_actions_s.nextval
923: into ln_w2c_asg_action
924: from dual;
925: hr_utility.set_location(gv_package || '.action_creation', 120);
926: hr_utility.trace('New w2c Action = ' || to_char(ln_w2c_asg_action));
927:
928: /* Insert into pay_assignment_actions. */
929: hr_utility.trace('Creating Assignment Action');
930:

Line 929: hr_utility.trace('Creating Assignment Action');

925: hr_utility.set_location(gv_package || '.action_creation', 120);
926: hr_utility.trace('New w2c Action = ' || to_char(ln_w2c_asg_action));
927:
928: /* Insert into pay_assignment_actions. */
929: hr_utility.trace('Creating Assignment Action');
930:
931: hr_nonrun_asact.insact(ln_w2c_asg_action
932: ,lp_assignment_id
933: ,p_payroll_action_id

Line 942: hr_utility.set_location(gv_package || '.action_creation', 130);

938: so that the W2C report will not have
939: to do an additional checking against the assignment
940: table */
941:
942: hr_utility.set_location(gv_package || '.action_creation', 130);
943: hr_utility.trace('updating asg action');
944: /*************************************************************
945: ** Update the serial number column with the assignment action
946: ** of the last two archive processes

Line 943: hr_utility.trace('updating asg action');

939: to do an additional checking against the assignment
940: table */
941:
942: hr_utility.set_location(gv_package || '.action_creation', 130);
943: hr_utility.trace('updating asg action');
944: /*************************************************************
945: ** Update the serial number column with the assignment action
946: ** of the last two archive processes
947: *************************************************************/

Line 953: hr_utility.set_location(gv_package || '.action_creation', 140);

949: lpad(ln_orig_reported_asg_action,15,0);
950: update pay_assignment_actions aa
951: set aa.serial_number = ln_serial_number
952: where aa.assignment_action_id = ln_w2c_asg_action;
953: hr_utility.set_location(gv_package || '.action_creation', 140);
954:
955: /* Interlock the w2c report action with current w2c Mag action */
956: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);
957: hr_utility.trace('Locked Action = ' || lp_assignment_action_id);

Line 956: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);

952: where aa.assignment_action_id = ln_w2c_asg_action;
953: hr_utility.set_location(gv_package || '.action_creation', 140);
954:
955: /* Interlock the w2c report action with current w2c Mag action */
956: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);
957: hr_utility.trace('Locked Action = ' || lp_assignment_action_id);
958: hr_nonrun_asact.insint(ln_w2c_asg_action
959: ,lp_assignment_action_id);
960: /*

Line 957: hr_utility.trace('Locked Action = ' || lp_assignment_action_id);

953: hr_utility.set_location(gv_package || '.action_creation', 140);
954:
955: /* Interlock the w2c report action with current w2c Mag action */
956: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);
957: hr_utility.trace('Locked Action = ' || lp_assignment_action_id);
958: hr_nonrun_asact.insint(ln_w2c_asg_action
959: ,lp_assignment_action_id);
960: /*
961: Lock all other W-2c paper action that are not yet locked by Fed W-2c

Line 971: hr_utility.set_location(gv_package || '.action_creation', 150);

967: ,lp_effective_date
968: ,lp_assignment_id
969: ,lp_assignment_action_id
970: );
971: hr_utility.set_location(gv_package || '.action_creation', 150);
972: LOOP
973: FETCH c_w2c_paper_not_locked INTO ln_notlocked_asgn_actid;
974:
975: hr_utility.set_location(gv_package || '.action_creation', 160);

Line 975: hr_utility.set_location(gv_package || '.action_creation', 160);

971: hr_utility.set_location(gv_package || '.action_creation', 150);
972: LOOP
973: FETCH c_w2c_paper_not_locked INTO ln_notlocked_asgn_actid;
974:
975: hr_utility.set_location(gv_package || '.action_creation', 160);
976: EXIT WHEN c_w2c_paper_not_locked%NOTFOUND;
977: if c_w2c_paper_not_locked%ROWCOUNT = 0 then
978: exit;
979: else

Line 980: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);

976: EXIT WHEN c_w2c_paper_not_locked%NOTFOUND;
977: if c_w2c_paper_not_locked%ROWCOUNT = 0 then
978: exit;
979: else
980: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);
981: hr_utility.trace('Locked Action = ' || ln_notlocked_asgn_actid);
982: hr_nonrun_asact.insint(ln_w2c_asg_action
983: ,ln_notlocked_asgn_actid);
984: end if;

Line 981: hr_utility.trace('Locked Action = ' || ln_notlocked_asgn_actid);

977: if c_w2c_paper_not_locked%ROWCOUNT = 0 then
978: exit;
979: else
980: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);
981: hr_utility.trace('Locked Action = ' || ln_notlocked_asgn_actid);
982: hr_nonrun_asact.insint(ln_w2c_asg_action
983: ,ln_notlocked_asgn_actid);
984: end if;
985: END LOOP;

Line 987: hr_utility.set_location(gv_package || '.action_creation', 170);

983: ,ln_notlocked_asgn_actid);
984: end if;
985: END LOOP;
986: CLOSE c_w2c_paper_not_locked;
987: hr_utility.set_location(gv_package || '.action_creation', 170);
988: end action_creation; -- End of Local function Action_Creation
989: --
990: -- Action Creation Main Logic
991: --

Line 994: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 10);

990: -- Action Creation Main Logic
991: --
992: begin
993: --{
994: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 10);
995: hr_utility.trace('Entered Mark_W2c_action_creation ');
996: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
997: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
998: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));

Line 995: hr_utility.trace('Entered Mark_W2c_action_creation ');

991: --
992: begin
993: --{
994: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 10);
995: hr_utility.trace('Entered Mark_W2c_action_creation ');
996: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
997: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
998: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
999: hr_utility.trace('p_chunk = '|| to_char(p_chunk));

Line 996: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));

992: begin
993: --{
994: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 10);
995: hr_utility.trace('Entered Mark_W2c_action_creation ');
996: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
997: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
998: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
999: hr_utility.trace('p_chunk = '|| to_char(p_chunk));
1000:

Line 997: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));

993: --{
994: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 10);
995: hr_utility.trace('Entered Mark_W2c_action_creation ');
996: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
997: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
998: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
999: hr_utility.trace('p_chunk = '|| to_char(p_chunk));
1000:
1001: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 20);

Line 998: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));

994: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 10);
995: hr_utility.trace('Entered Mark_W2c_action_creation ');
996: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
997: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
998: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
999: hr_utility.trace('p_chunk = '|| to_char(p_chunk));
1000:
1001: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 20);
1002: get_payroll_action_info(p_payroll_action_id

Line 999: hr_utility.trace('p_chunk = '|| to_char(p_chunk));

995: hr_utility.trace('Entered Mark_W2c_action_creation ');
996: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
997: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
998: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
999: hr_utility.trace('p_chunk = '|| to_char(p_chunk));
1000:
1001: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 20);
1002: get_payroll_action_info(p_payroll_action_id
1003: ,ld_start_date

Line 1001: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 20);

997: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
998: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
999: hr_utility.trace('p_chunk = '|| to_char(p_chunk));
1000:
1001: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 20);
1002: get_payroll_action_info(p_payroll_action_id
1003: ,ld_start_date
1004: ,ld_end_date
1005: ,lv_report_type

Line 1009: hr_utility.trace('ld_start_date = ' || ld_start_date);

1005: ,lv_report_type
1006: ,lv_report_qualifier
1007: ,ln_business_group_id);
1008:
1009: hr_utility.trace('ld_start_date = ' || ld_start_date);
1010: hr_utility.trace('ld_end_date = ' || ld_end_date);
1011: hr_utility.trace('lv_report_type = ' || lv_report_type);
1012: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
1013: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);

Line 1010: hr_utility.trace('ld_end_date = ' || ld_end_date);

1006: ,lv_report_qualifier
1007: ,ln_business_group_id);
1008:
1009: hr_utility.trace('ld_start_date = ' || ld_start_date);
1010: hr_utility.trace('ld_end_date = ' || ld_end_date);
1011: hr_utility.trace('lv_report_type = ' || lv_report_type);
1012: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
1013: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
1014:

Line 1011: hr_utility.trace('lv_report_type = ' || lv_report_type);

1007: ,ln_business_group_id);
1008:
1009: hr_utility.trace('ld_start_date = ' || ld_start_date);
1010: hr_utility.trace('ld_end_date = ' || ld_end_date);
1011: hr_utility.trace('lv_report_type = ' || lv_report_type);
1012: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
1013: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
1014:
1015: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 22);

Line 1012: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);

1008:
1009: hr_utility.trace('ld_start_date = ' || ld_start_date);
1010: hr_utility.trace('ld_end_date = ' || ld_end_date);
1011: hr_utility.trace('lv_report_type = ' || lv_report_type);
1012: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
1013: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
1014:
1015: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 22);
1016: open w2c_future_correction_reported(ln_business_group_id

Line 1013: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);

1009: hr_utility.trace('ld_start_date = ' || ld_start_date);
1010: hr_utility.trace('ld_end_date = ' || ld_end_date);
1011: hr_utility.trace('lv_report_type = ' || lv_report_type);
1012: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
1013: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
1014:
1015: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 22);
1016: open w2c_future_correction_reported(ln_business_group_id
1017: ,ld_start_date

Line 1015: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 22);

1011: hr_utility.trace('lv_report_type = ' || lv_report_type);
1012: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
1013: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
1014:
1015: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 22);
1016: open w2c_future_correction_reported(ln_business_group_id
1017: ,ld_start_date
1018: ,ld_end_date
1019: ,p_start_person_id

Line 1024: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 23);

1020: ,p_end_person_id
1021: );
1022: loop
1023: --{
1024: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 23);
1025: fetch w2c_future_correction_reported into ln_assignment_id,
1026: ln_person_id;
1027: if w2c_future_correction_reported%ROWCOUNT = 0 then
1028: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 24);

Line 1028: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 24);

1024: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 23);
1025: fetch w2c_future_correction_reported into ln_assignment_id,
1026: ln_person_id;
1027: if w2c_future_correction_reported%ROWCOUNT = 0 then
1028: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 24);
1029: hr_utility.trace('No Person found for whose future correction is already reported');
1030: end if;
1031: EXIT WHEN w2c_future_correction_reported%NOTFOUND;
1032: --

Line 1029: hr_utility.trace('No Person found for whose future correction is already reported');

1025: fetch w2c_future_correction_reported into ln_assignment_id,
1026: ln_person_id;
1027: if w2c_future_correction_reported%ROWCOUNT = 0 then
1028: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 24);
1029: hr_utility.trace('No Person found for whose future correction is already reported');
1030: end if;
1031: EXIT WHEN w2c_future_correction_reported%NOTFOUND;
1032: --
1033: -- If an employees future correction is already reported log a Warning to alert

Line 1037: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 25);

1033: -- If an employees future correction is already reported log a Warning to alert
1034: -- that Federal W-2c Magnetic Media will not create action for this employee
1035: --
1036: if ln_person_id is not null then
1037: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 25);
1038: open get_warning_dtls_for_ee(ln_person_id);
1039: fetch get_warning_dtls_for_ee into lv_full_name
1040: ,lv_national_identifier;
1041: close get_warning_dtls_for_ee;

Line 1042: hr_utility.trace('WARNING: Employee '||lv_full_name ||' Reported Future corrections');

1038: open get_warning_dtls_for_ee(ln_person_id);
1039: fetch get_warning_dtls_for_ee into lv_full_name
1040: ,lv_national_identifier;
1041: close get_warning_dtls_for_ee;
1042: hr_utility.trace('WARNING: Employee '||lv_full_name ||' Reported Future corrections');
1043: hr_utility.trace(' SSN = '||lv_national_identifier);
1044: /* message to user -- This employees future correction is already Reported
1045: genrating W-2c Mag */
1046: lv_record_name := 'Action_Creation';

Line 1043: hr_utility.trace(' SSN = '||lv_national_identifier);

1039: fetch get_warning_dtls_for_ee into lv_full_name
1040: ,lv_national_identifier;
1041: close get_warning_dtls_for_ee;
1042: hr_utility.trace('WARNING: Employee '||lv_full_name ||' Reported Future corrections');
1043: hr_utility.trace(' SSN = '||lv_national_identifier);
1044: /* message to user -- This employees future correction is already Reported
1045: genrating W-2c Mag */
1046: lv_record_name := 'Action_Creation';
1047: lv_message := 'Future Correction reported for this employee';

Line 1055: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 27);

1051: pay_core_utils.push_token('record_name', lv_record_name);
1052: pay_core_utils.push_token('name_or_number',lv_name);
1053: pay_core_utils.push_token('description', lv_message);
1054: end if;
1055: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 27);
1056: --}
1057: end loop;
1058: close w2c_future_correction_reported;
1059: --

Line 1068: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 30);

1064: ,ld_end_date
1065: ,p_start_person_id
1066: ,p_end_person_id
1067: );
1068: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 30);
1069: loop
1070: --{
1071: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 40);
1072: fetch get_w2c_mag_assignments into ln_assignment_id,

Line 1071: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 40);

1067: );
1068: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 30);
1069: loop
1070: --{
1071: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 40);
1072: fetch get_w2c_mag_assignments into ln_assignment_id,
1073: ln_emp_tax_unit_id,
1074: ln_person_id,
1075: ln_assignment_action_id,

Line 1079: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 50);

1075: ln_assignment_action_id,
1076: ln_w2c_pp_asg_actid,
1077: ln_w2c_pp_locked_actid;
1078:
1079: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 50);
1080:
1081: if get_w2c_mag_assignments%ROWCOUNT = 0 then
1082: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 60);
1083: hr_utility.trace('No Person found for reporting in this chunk');

Line 1082: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 60);

1078:
1079: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 50);
1080:
1081: if get_w2c_mag_assignments%ROWCOUNT = 0 then
1082: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 60);
1083: hr_utility.trace('No Person found for reporting in this chunk');
1084: end if;
1085:
1086: EXIT WHEN get_w2c_mag_assignments%NOTFOUND;

Line 1083: hr_utility.trace('No Person found for reporting in this chunk');

1079: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 50);
1080:
1081: if get_w2c_mag_assignments%ROWCOUNT = 0 then
1082: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 60);
1083: hr_utility.trace('No Person found for reporting in this chunk');
1084: end if;
1085:
1086: EXIT WHEN get_w2c_mag_assignments%NOTFOUND;
1087:

Line 1088: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 70);

1084: end if;
1085:
1086: EXIT WHEN get_w2c_mag_assignments%NOTFOUND;
1087:
1088: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 70);
1089: hr_utility.trace('ln_assignment_id =' ||ln_assignment_id);
1090: hr_utility.trace('ln_emp_tax_unit_id =' ||ln_emp_tax_unit_id);
1091: hr_utility.trace('ln_person_id =' ||ln_person_id);
1092: hr_utility.trace('ln_assignment_action_id =' ||ln_assignment_action_id);

Line 1089: hr_utility.trace('ln_assignment_id =' ||ln_assignment_id);

1085:
1086: EXIT WHEN get_w2c_mag_assignments%NOTFOUND;
1087:
1088: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 70);
1089: hr_utility.trace('ln_assignment_id =' ||ln_assignment_id);
1090: hr_utility.trace('ln_emp_tax_unit_id =' ||ln_emp_tax_unit_id);
1091: hr_utility.trace('ln_person_id =' ||ln_person_id);
1092: hr_utility.trace('ln_assignment_action_id =' ||ln_assignment_action_id);
1093: hr_utility.trace('Corrected assignment_action_id =' ||ln_w2c_pp_asg_actid);

Line 1090: hr_utility.trace('ln_emp_tax_unit_id =' ||ln_emp_tax_unit_id);

1086: EXIT WHEN get_w2c_mag_assignments%NOTFOUND;
1087:
1088: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 70);
1089: hr_utility.trace('ln_assignment_id =' ||ln_assignment_id);
1090: hr_utility.trace('ln_emp_tax_unit_id =' ||ln_emp_tax_unit_id);
1091: hr_utility.trace('ln_person_id =' ||ln_person_id);
1092: hr_utility.trace('ln_assignment_action_id =' ||ln_assignment_action_id);
1093: hr_utility.trace('Corrected assignment_action_id =' ||ln_w2c_pp_asg_actid);
1094: hr_utility.trace('action locked by Corrected assignment_action_id =' ||ln_w2c_pp_locked_actid);

Line 1091: hr_utility.trace('ln_person_id =' ||ln_person_id);

1087:
1088: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 70);
1089: hr_utility.trace('ln_assignment_id =' ||ln_assignment_id);
1090: hr_utility.trace('ln_emp_tax_unit_id =' ||ln_emp_tax_unit_id);
1091: hr_utility.trace('ln_person_id =' ||ln_person_id);
1092: hr_utility.trace('ln_assignment_action_id =' ||ln_assignment_action_id);
1093: hr_utility.trace('Corrected assignment_action_id =' ||ln_w2c_pp_asg_actid);
1094: hr_utility.trace('action locked by Corrected assignment_action_id =' ||ln_w2c_pp_locked_actid);
1095:

Line 1092: hr_utility.trace('ln_assignment_action_id =' ||ln_assignment_action_id);

1088: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 70);
1089: hr_utility.trace('ln_assignment_id =' ||ln_assignment_id);
1090: hr_utility.trace('ln_emp_tax_unit_id =' ||ln_emp_tax_unit_id);
1091: hr_utility.trace('ln_person_id =' ||ln_person_id);
1092: hr_utility.trace('ln_assignment_action_id =' ||ln_assignment_action_id);
1093: hr_utility.trace('Corrected assignment_action_id =' ||ln_w2c_pp_asg_actid);
1094: hr_utility.trace('action locked by Corrected assignment_action_id =' ||ln_w2c_pp_locked_actid);
1095:
1096: if ln_person_id is not null then

Line 1093: hr_utility.trace('Corrected assignment_action_id =' ||ln_w2c_pp_asg_actid);

1089: hr_utility.trace('ln_assignment_id =' ||ln_assignment_id);
1090: hr_utility.trace('ln_emp_tax_unit_id =' ||ln_emp_tax_unit_id);
1091: hr_utility.trace('ln_person_id =' ||ln_person_id);
1092: hr_utility.trace('ln_assignment_action_id =' ||ln_assignment_action_id);
1093: hr_utility.trace('Corrected assignment_action_id =' ||ln_w2c_pp_asg_actid);
1094: hr_utility.trace('action locked by Corrected assignment_action_id =' ||ln_w2c_pp_locked_actid);
1095:
1096: if ln_person_id is not null then
1097: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 80);

Line 1094: hr_utility.trace('action locked by Corrected assignment_action_id =' ||ln_w2c_pp_locked_actid);

1090: hr_utility.trace('ln_emp_tax_unit_id =' ||ln_emp_tax_unit_id);
1091: hr_utility.trace('ln_person_id =' ||ln_person_id);
1092: hr_utility.trace('ln_assignment_action_id =' ||ln_assignment_action_id);
1093: hr_utility.trace('Corrected assignment_action_id =' ||ln_w2c_pp_asg_actid);
1094: hr_utility.trace('action locked by Corrected assignment_action_id =' ||ln_w2c_pp_locked_actid);
1095:
1096: if ln_person_id is not null then
1097: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 80);
1098: -- This check is performed to ignore duplicate assignment when a

Line 1097: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 80);

1093: hr_utility.trace('Corrected assignment_action_id =' ||ln_w2c_pp_asg_actid);
1094: hr_utility.trace('action locked by Corrected assignment_action_id =' ||ln_w2c_pp_locked_actid);
1095:
1096: if ln_person_id is not null then
1097: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 80);
1098: -- This check is performed to ignore duplicate assignment when a
1099: -- person is having an update on assignment during the tax year.
1100: -- multiple assignment dur to update on assignment was causing
1101: -- duplicate RCW record.

Line 1113: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 90);

1109: ln_business_group_id,
1110: ln_w2c_pp_asg_actid,
1111: ln_w2c_pp_locked_actid
1112: );
1113: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 90);
1114: end if;
1115: ln_prev_person_id := ln_person_id;
1116: end if;
1117: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 100);

Line 1117: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 100);

1113: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 90);
1114: end if;
1115: ln_prev_person_id := ln_person_id;
1116: end if;
1117: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 100);
1118: --}
1119: end loop;
1120: close get_w2c_mag_assignments;
1121: hr_utility.trace('Action Creation for W2c_Magnetic_Media completed Successfully');

Line 1121: hr_utility.trace('Action Creation for W2c_Magnetic_Media completed Successfully');

1117: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 100);
1118: --}
1119: end loop;
1120: close get_w2c_mag_assignments;
1121: hr_utility.trace('Action Creation for W2c_Magnetic_Media completed Successfully');
1122: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 110);
1123: --}
1124: end w2c_mag_action_creation;
1125: -- End of Procedure mar_w2c_action_creation

Line 1122: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 110);

1118: --}
1119: end loop;
1120: close get_w2c_mag_assignments;
1121: hr_utility.trace('Action Creation for W2c_Magnetic_Media completed Successfully');
1122: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 110);
1123: --}
1124: end w2c_mag_action_creation;
1125: -- End of Procedure mar_w2c_action_creation
1126: --

Line 1128: --hr_utility.trace_on(null,'W2CMAG');

1124: end w2c_mag_action_creation;
1125: -- End of Procedure mar_w2c_action_creation
1126: --
1127: --Begin
1128: --hr_utility.trace_on(null,'W2CMAG');
1129: end pay_us_w2c_reporting_utils;