APPS.PAY_US_W2C_REPORTING_UTILS dependencies on HR_UTILITY

Line 93: hr_utility.set_location

89: AND UE.creator_type = 'B'
90: AND UE.legislation_code = 'US';
91: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
92: BEGIN
93: hr_utility.set_location
94: (gv_package || '.bal_db_item - opening cursor', 10);
95: -- Open the cursor
96: OPEN csr_defined_balance;
97: -- Fetch the value

Line 102: hr_utility.set_location

98: FETCH csr_defined_balance
99: INTO l_defined_balance_id;
100: IF csr_defined_balance%NOTFOUND THEN
101: CLOSE csr_defined_balance;
102: hr_utility.set_location
103: (gv_package || '.bal_db_item - no rows found ', 20);
104: hr_utility.raise_error;
105: ELSE
106: hr_utility.set_location

Line 104: hr_utility.raise_error;

100: IF csr_defined_balance%NOTFOUND THEN
101: CLOSE csr_defined_balance;
102: hr_utility.set_location
103: (gv_package || '.bal_db_item - no rows found ', 20);
104: hr_utility.raise_error;
105: ELSE
106: hr_utility.set_location
107: (gv_package || '.bal_db_item - Row fetched from cursor', 30);
108: CLOSE csr_defined_balance;

Line 106: hr_utility.set_location

102: hr_utility.set_location
103: (gv_package || '.bal_db_item - no rows found ', 20);
104: hr_utility.raise_error;
105: ELSE
106: hr_utility.set_location
107: (gv_package || '.bal_db_item - Row fetched from cursor', 30);
108: CLOSE csr_defined_balance;
109: END IF;
110: /* Return the value to the call */

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

143: lv_report_qualifier varchar2(50);
144: ln_business_group_id number;
145:
146: BEGIN
147: hr_utility.set_location(gv_package || '.get_payroll_action_info', 10);
148:
149: open c_payroll_action(p_payroll_action_id);
150: fetch c_payroll_action into
151: ld_start_date,

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

153: lv_report_type,
154: lv_report_qualifier,
155: ln_business_group_id;
156: if c_payroll_action%notfound then
157: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
158: hr_utility.trace('Payroll Action '||to_char(p_payroll_action_id)||' Not found');
159: hr_utility.raise_error;
160: end if;
161: close c_payroll_action;

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

154: lv_report_qualifier,
155: ln_business_group_id;
156: if c_payroll_action%notfound then
157: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
158: hr_utility.trace('Payroll Action '||to_char(p_payroll_action_id)||' Not found');
159: hr_utility.raise_error;
160: end if;
161: close c_payroll_action;
162: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);

Line 159: hr_utility.raise_error;

155: ln_business_group_id;
156: if c_payroll_action%notfound then
157: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
158: hr_utility.trace('Payroll Action '||to_char(p_payroll_action_id)||' Not found');
159: hr_utility.raise_error;
160: end if;
161: close c_payroll_action;
162: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
163: p_start_date := ld_start_date;

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

158: hr_utility.trace('Payroll Action '||to_char(p_payroll_action_id)||' Not found');
159: hr_utility.raise_error;
160: end if;
161: close c_payroll_action;
162: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
163: p_start_date := ld_start_date;
164: p_end_date := ld_end_date;
165: p_report_type := lv_report_type;
166: p_report_qualifier := lv_report_qualifier;

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

164: p_end_date := ld_end_date;
165: p_report_type := lv_report_type;
166: p_report_qualifier := lv_report_qualifier;
167: p_business_group_id := ln_business_group_id;
168: hr_utility.set_location(gv_package || '.get_payroll_action_info', 40);
169: END get_payroll_action_info;
170:
171: -------------------------------------------------------------------------
172: -- Name : get_balance_value

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

192: p_effective_date DATE
193: ) RETURN NUMBER IS
194: l_jurisdiction_code VARCHAR2(20);
195: BEGIN
196: hr_utility.set_location(gv_package || '.get_balance_value', 10);
197: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
198: IF p_state_abbrev <> 'FED' THEN
199: SELECT jurisdiction_code
200: INTO l_jurisdiction_code

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

199: SELECT jurisdiction_code
200: INTO l_jurisdiction_code
201: FROM pay_state_rules
202: WHERE state_code = p_state_abbrev;
203: hr_utility.set_location(gv_package || '.get_balance_value', 20);
204: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
205: END IF;
206: hr_utility.trace('Balance Name : '||p_balance_name);
207: hr_utility.trace('Context');

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

202: WHERE state_code = p_state_abbrev;
203: hr_utility.set_location(gv_package || '.get_balance_value', 20);
204: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
205: END IF;
206: hr_utility.trace('Balance Name : '||p_balance_name);
207: hr_utility.trace('Context');
208: hr_utility.trace(' Tax Unit Id : '|| p_tax_unit_id);
209: hr_utility.trace(' Jurisdiction: '|| l_jurisdiction_code);
210: hr_utility.set_location('pay_us_mmref_reporting.get_balance_value', 30);

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

203: hr_utility.set_location(gv_package || '.get_balance_value', 20);
204: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
205: END IF;
206: hr_utility.trace('Balance Name : '||p_balance_name);
207: hr_utility.trace('Context');
208: hr_utility.trace(' Tax Unit Id : '|| p_tax_unit_id);
209: hr_utility.trace(' Jurisdiction: '|| l_jurisdiction_code);
210: hr_utility.set_location('pay_us_mmref_reporting.get_balance_value', 30);
211: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),

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

204: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
205: END IF;
206: hr_utility.trace('Balance Name : '||p_balance_name);
207: hr_utility.trace('Context');
208: hr_utility.trace(' Tax Unit Id : '|| p_tax_unit_id);
209: hr_utility.trace(' Jurisdiction: '|| l_jurisdiction_code);
210: hr_utility.set_location('pay_us_mmref_reporting.get_balance_value', 30);
211: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
212: p_assignment_id,

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

205: END IF;
206: hr_utility.trace('Balance Name : '||p_balance_name);
207: hr_utility.trace('Context');
208: hr_utility.trace(' Tax Unit Id : '|| p_tax_unit_id);
209: hr_utility.trace(' Jurisdiction: '|| l_jurisdiction_code);
210: hr_utility.set_location('pay_us_mmref_reporting.get_balance_value', 30);
211: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
212: p_assignment_id,
213: p_effective_date);

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

206: hr_utility.trace('Balance Name : '||p_balance_name);
207: hr_utility.trace('Context');
208: hr_utility.trace(' Tax Unit Id : '|| p_tax_unit_id);
209: hr_utility.trace(' Jurisdiction: '|| l_jurisdiction_code);
210: hr_utility.set_location('pay_us_mmref_reporting.get_balance_value', 30);
211: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
212: p_assignment_id,
213: p_effective_date);
214: END get_balance_value;

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

288: and ppa1.report_type = 'W2C'
289: and ppa1.report_qualifier = 'FED'
290: and ppa1.action_status = 'C');
291: BEGIN
292: hr_utility.set_location(gv_package || '.preprocess_check', 10);
293: lv_message_preprocess := 'Pre-Process check';
294: --
295: -- Determine whether any W-2c paper assignment action exist for W-2c mag
296: -- pick up. If not log a message for user

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

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

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

309: pay_core_utils.push_token('record_name',lv_message_preprocess);
310: pay_core_utils.push_token('description',lv_message_text);
311: lb_return_value := FALSE;
312: CLOSE c_w2c_paper_exist;
313: hr_utility.set_location(gv_package || '.preprocess_check', 30);
314: else
315: CLOSE c_w2c_paper_exist;
316: lb_return_value := TRUE;
317: hr_utility.set_location(gv_package || '.preprocess_check', 30);

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

313: hr_utility.set_location(gv_package || '.preprocess_check', 30);
314: else
315: CLOSE c_w2c_paper_exist;
316: lb_return_value := TRUE;
317: hr_utility.set_location(gv_package || '.preprocess_check', 30);
318: end if;
319: hr_utility.set_location(gv_package || '.preprocess_check', 40);
320: return lb_return_value;
321: END preprocess_check;

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

315: CLOSE c_w2c_paper_exist;
316: lb_return_value := TRUE;
317: hr_utility.set_location(gv_package || '.preprocess_check', 30);
318: end if;
319: hr_utility.set_location(gv_package || '.preprocess_check', 40);
320: return lb_return_value;
321: END preprocess_check;
322: -- End of Function Preprocess_Check
323:

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

353: 'TRANSFER_GRE') = cp_w2c_tax_unit_id;
354: ln_eoy_pactid number :=0;
355: ln_eoy_asg_actid number :=0;
356: BEGIN
357: hr_utility.set_location(gv_package || '.get_eoy_action_info', 10);
358: hr_utility.trace('Effective Date '||to_char(p_eoy_effective_date,'dd-mon-yyyy') );
359: hr_utility.trace('Tax Unit Id '||to_char(p_eoy_tax_unit_id));
360: hr_utility.trace('Entered get_eoy_action_info');
361: open get_eoy_info(p_eoy_effective_date

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

354: ln_eoy_pactid number :=0;
355: ln_eoy_asg_actid number :=0;
356: BEGIN
357: hr_utility.set_location(gv_package || '.get_eoy_action_info', 10);
358: hr_utility.trace('Effective Date '||to_char(p_eoy_effective_date,'dd-mon-yyyy') );
359: hr_utility.trace('Tax Unit Id '||to_char(p_eoy_tax_unit_id));
360: hr_utility.trace('Entered get_eoy_action_info');
361: open get_eoy_info(p_eoy_effective_date
362: ,p_eoy_tax_unit_id

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

355: ln_eoy_asg_actid number :=0;
356: BEGIN
357: hr_utility.set_location(gv_package || '.get_eoy_action_info', 10);
358: hr_utility.trace('Effective Date '||to_char(p_eoy_effective_date,'dd-mon-yyyy') );
359: hr_utility.trace('Tax Unit Id '||to_char(p_eoy_tax_unit_id));
360: hr_utility.trace('Entered get_eoy_action_info');
361: open get_eoy_info(p_eoy_effective_date
362: ,p_eoy_tax_unit_id
363: ,p_assignment_id

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

356: BEGIN
357: hr_utility.set_location(gv_package || '.get_eoy_action_info', 10);
358: hr_utility.trace('Effective Date '||to_char(p_eoy_effective_date,'dd-mon-yyyy') );
359: hr_utility.trace('Tax Unit Id '||to_char(p_eoy_tax_unit_id));
360: hr_utility.trace('Entered get_eoy_action_info');
361: open get_eoy_info(p_eoy_effective_date
362: ,p_eoy_tax_unit_id
363: ,p_assignment_id
364: );

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

361: open get_eoy_info(p_eoy_effective_date
362: ,p_eoy_tax_unit_id
363: ,p_assignment_id
364: );
365: hr_utility.set_location(gv_package || '.get_eoy_action_info', 20);
366: hr_utility.trace('Opened get_eoy_info');
367:
368: fetch get_eoy_info into ln_eoy_pactid,
369: ln_eoy_asg_actid;

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

362: ,p_eoy_tax_unit_id
363: ,p_assignment_id
364: );
365: hr_utility.set_location(gv_package || '.get_eoy_action_info', 20);
366: hr_utility.trace('Opened get_eoy_info');
367:
368: fetch get_eoy_info into ln_eoy_pactid,
369: ln_eoy_asg_actid;
370: hr_utility.trace('Fetched get_eoy_info ');

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

366: hr_utility.trace('Opened get_eoy_info');
367:
368: fetch get_eoy_info into ln_eoy_pactid,
369: ln_eoy_asg_actid;
370: hr_utility.trace('Fetched get_eoy_info ');
371: close get_eoy_info;
372:
373: hr_utility.trace('Closed get_eoy_info ');
374: p_eoy_pactid := ln_eoy_pactid;

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

369: ln_eoy_asg_actid;
370: hr_utility.trace('Fetched get_eoy_info ');
371: close get_eoy_info;
372:
373: hr_utility.trace('Closed get_eoy_info ');
374: p_eoy_pactid := ln_eoy_pactid;
375: p_eoy_asg_actid := ln_eoy_asg_actid;
376: hr_utility.trace('ln_eoy_pactid = ' || to_char(ln_eoy_pactid));
377: hr_utility.trace('ln_eoy_asg_actid = ' || to_char(ln_eoy_asg_actid));

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

372:
373: hr_utility.trace('Closed get_eoy_info ');
374: p_eoy_pactid := ln_eoy_pactid;
375: p_eoy_asg_actid := ln_eoy_asg_actid;
376: hr_utility.trace('ln_eoy_pactid = ' || to_char(ln_eoy_pactid));
377: hr_utility.trace('ln_eoy_asg_actid = ' || to_char(ln_eoy_asg_actid));
378: hr_utility.set_location(gv_package || '.get_eoy_action_info', 30);
379: hr_utility.trace('Leaving get_eoy_action_info');
380: EXCEPTION

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

373: hr_utility.trace('Closed get_eoy_info ');
374: p_eoy_pactid := ln_eoy_pactid;
375: p_eoy_asg_actid := ln_eoy_asg_actid;
376: hr_utility.trace('ln_eoy_pactid = ' || to_char(ln_eoy_pactid));
377: hr_utility.trace('ln_eoy_asg_actid = ' || to_char(ln_eoy_asg_actid));
378: hr_utility.set_location(gv_package || '.get_eoy_action_info', 30);
379: hr_utility.trace('Leaving get_eoy_action_info');
380: EXCEPTION
381: when others then

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

374: p_eoy_pactid := ln_eoy_pactid;
375: p_eoy_asg_actid := ln_eoy_asg_actid;
376: hr_utility.trace('ln_eoy_pactid = ' || to_char(ln_eoy_pactid));
377: hr_utility.trace('ln_eoy_asg_actid = ' || to_char(ln_eoy_asg_actid));
378: hr_utility.set_location(gv_package || '.get_eoy_action_info', 30);
379: hr_utility.trace('Leaving get_eoy_action_info');
380: EXCEPTION
381: when others then
382: hr_utility.trace('Error in ' || gv_package || '.get_eoy_action_info' ||

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

375: p_eoy_asg_actid := ln_eoy_asg_actid;
376: hr_utility.trace('ln_eoy_pactid = ' || to_char(ln_eoy_pactid));
377: hr_utility.trace('ln_eoy_asg_actid = ' || to_char(ln_eoy_asg_actid));
378: hr_utility.set_location(gv_package || '.get_eoy_action_info', 30);
379: hr_utility.trace('Leaving get_eoy_action_info');
380: EXCEPTION
381: when others then
382: hr_utility.trace('Error in ' || gv_package || '.get_eoy_action_info' ||
383: to_char(sqlcode) || '-' || sqlerrm);

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

378: hr_utility.set_location(gv_package || '.get_eoy_action_info', 30);
379: hr_utility.trace('Leaving get_eoy_action_info');
380: EXCEPTION
381: when others then
382: hr_utility.trace('Error in ' || gv_package || '.get_eoy_action_info' ||
383: to_char(sqlcode) || '-' || sqlerrm);
384: hr_utility.set_location(gv_package || '.get_eoy_action_info', 40);
385: raise hr_utility.hr_error;
386: END get_eoy_action_info;

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

380: EXCEPTION
381: when others then
382: hr_utility.trace('Error in ' || gv_package || '.get_eoy_action_info' ||
383: to_char(sqlcode) || '-' || sqlerrm);
384: hr_utility.set_location(gv_package || '.get_eoy_action_info', 40);
385: raise hr_utility.hr_error;
386: END get_eoy_action_info;
387:
388: /******************************************************************

Line 385: raise hr_utility.hr_error;

381: when others then
382: hr_utility.trace('Error in ' || gv_package || '.get_eoy_action_info' ||
383: to_char(sqlcode) || '-' || sqlerrm);
384: hr_utility.set_location(gv_package || '.get_eoy_action_info', 40);
385: raise hr_utility.hr_error;
386: END get_eoy_action_info;
387:
388: /******************************************************************
389: ** Range Code to pick all the distinct assignment_ids

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

399: lv_report_qualifier varchar2(30);
400: ln_business_group_id number;
401: lv_sql_string varchar2(10000);
402: BEGIN
403: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 10);
404: get_payroll_action_info ( p_payroll_action_id
405: ,ld_start_date
406: ,ld_end_date
407: ,lv_report_type

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

407: ,lv_report_type
408: ,lv_report_qualifier
409: ,ln_business_group_id
410: );
411: hr_utility.trace('ld_start_date = ' || ld_start_date);
412: hr_utility.trace('ld_end_date = ' || ld_end_date);
413: hr_utility.trace('lv_report_type = ' || lv_report_type);
414: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
415: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);

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

408: ,lv_report_qualifier
409: ,ln_business_group_id
410: );
411: hr_utility.trace('ld_start_date = ' || ld_start_date);
412: hr_utility.trace('ld_end_date = ' || ld_end_date);
413: hr_utility.trace('lv_report_type = ' || lv_report_type);
414: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
415: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
416:

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

409: ,ln_business_group_id
410: );
411: hr_utility.trace('ld_start_date = ' || ld_start_date);
412: hr_utility.trace('ld_end_date = ' || ld_end_date);
413: hr_utility.trace('lv_report_type = ' || lv_report_type);
414: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
415: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
416:
417: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 20);

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

410: );
411: hr_utility.trace('ld_start_date = ' || ld_start_date);
412: hr_utility.trace('ld_end_date = ' || ld_end_date);
413: hr_utility.trace('lv_report_type = ' || lv_report_type);
414: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
415: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
416:
417: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 20);
418:

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

411: hr_utility.trace('ld_start_date = ' || ld_start_date);
412: hr_utility.trace('ld_end_date = ' || ld_end_date);
413: hr_utility.trace('lv_report_type = ' || lv_report_type);
414: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
415: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
416:
417: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 20);
418:
419: if preprocess_check ( p_payroll_action_id

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

413: hr_utility.trace('lv_report_type = ' || lv_report_type);
414: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
415: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
416:
417: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 20);
418:
419: if preprocess_check ( p_payroll_action_id
420: ,ld_start_date
421: ,ld_end_date

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

421: ,ld_end_date
422: ,ln_business_group_id
423: )
424: then
425: hr_utility.trace('W-2c Assignment picked up for processing W-2c Mag' );
426: else
427: hr_utility.trace('No W-2c Assignment picked up for processing W-2c Mag');
428: end if;
429: --{

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

423: )
424: then
425: hr_utility.trace('W-2c Assignment picked up for processing W-2c Mag' );
426: else
427: hr_utility.trace('No W-2c Assignment picked up for processing W-2c Mag');
428: end if;
429: --{
430:
431: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 30);

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

427: hr_utility.trace('No W-2c Assignment picked up for processing W-2c Mag');
428: end if;
429: --{
430:
431: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 30);
432: if (lv_report_type = 'W2C' and lv_report_qualifier = 'FED') then
433: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 40);
434: lv_sql_string :=
435: 'select distinct paf.person_id

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

429: --{
430:
431: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 30);
432: if (lv_report_type = 'W2C' and lv_report_qualifier = 'FED') then
433: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 40);
434: lv_sql_string :=
435: 'select distinct paf.person_id
436: from pay_assignment_actions paa,
437: per_all_assignments_f paf,

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

477: and ppa1.report_qualifier = ''FED''
478: and ppa1.action_status = ''C'')
479: order by paf.person_id';
480: p_sqlstr := lv_sql_string;
481: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 50);
482: --hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
483: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
484: hr_utility.trace('Procedure w2c_mag_range_cursor completed successfully');
485: else

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

478: and ppa1.action_status = ''C'')
479: order by paf.person_id';
480: p_sqlstr := lv_sql_string;
481: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 50);
482: --hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
483: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
484: hr_utility.trace('Procedure w2c_mag_range_cursor completed successfully');
485: else
486: hr_utility.trace('Procedure w2c_mag_range_cursor Unsucessful ... ');

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

479: order by paf.person_id';
480: p_sqlstr := lv_sql_string;
481: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 50);
482: --hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
483: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
484: hr_utility.trace('Procedure w2c_mag_range_cursor completed successfully');
485: else
486: hr_utility.trace('Procedure w2c_mag_range_cursor Unsucessful ... ');
487: end if;

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

480: p_sqlstr := lv_sql_string;
481: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 50);
482: --hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
483: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
484: hr_utility.trace('Procedure w2c_mag_range_cursor completed successfully');
485: else
486: hr_utility.trace('Procedure w2c_mag_range_cursor Unsucessful ... ');
487: end if;
488: --}

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

482: --hr_utility.trace('p_sqlstr = ' ||p_sqlstr);
483: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
484: hr_utility.trace('Procedure w2c_mag_range_cursor completed successfully');
485: else
486: hr_utility.trace('Procedure w2c_mag_range_cursor Unsucessful ... ');
487: end if;
488: --}
489:
490: end w2c_mag_range_cursor;

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

854: ln_serial_number pay_assignment_actions.serial_number%TYPE;
855: ln_notlocked_asgn_actid number;
856:
857: BEGIN
858: hr_utility.set_location(gv_package || '.action_creation', 10);
859: -- Corrected Assignment Action would be the W-2c Pre-Process Action_ID
860: --
861: if lp_w2c_pp_asg_action_id > 0 then
862: hr_utility.set_location(gv_package || '.action_creation', 20);

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

858: hr_utility.set_location(gv_package || '.action_creation', 10);
859: -- Corrected Assignment Action would be the W-2c Pre-Process Action_ID
860: --
861: if lp_w2c_pp_asg_action_id > 0 then
862: hr_utility.set_location(gv_package || '.action_creation', 20);
863: ln_corrected_asg_action := lp_w2c_pp_asg_action_id;
864: end if;
865: hr_utility.set_location(gv_package || '.action_creation', 30);
866: --

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

861: if lp_w2c_pp_asg_action_id > 0 then
862: hr_utility.set_location(gv_package || '.action_creation', 20);
863: ln_corrected_asg_action := lp_w2c_pp_asg_action_id;
864: end if;
865: hr_utility.set_location(gv_package || '.action_creation', 30);
866: --
867: -- Determine the EOY Action_ID
868: --
869: get_eoy_action_info(lp_effective_date

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

870: ,lp_tax_unit_id
871: ,lp_assignment_id
872: ,ln_eoy_payroll_action_id
873: ,ln_eoy_assignment_action_id);
874: hr_utility.set_location(gv_package || '.action_creation', 40);
875: -- Ideally if one correction made to W-2c and Previously reported archived
876: -- values will be from YE archive. Check whether W-2c Pre-process locks
877: -- the YE Pre-process. If yes then previously reported values can be
878: -- derived from YE pre-process

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

878: -- derived from YE pre-process
879:
880: if lp_w2c_pp_locked_actid = ln_eoy_assignment_action_id
881: then
882: hr_utility.set_location(gv_package || '.action_creation', 50);
883: ln_orig_reported_asg_action := lp_w2c_pp_locked_actid;
884: else
885: --{
886: hr_utility.set_location(gv_package || '.action_creation', 60);

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

882: hr_utility.set_location(gv_package || '.action_creation', 50);
883: ln_orig_reported_asg_action := lp_w2c_pp_locked_actid;
884: else
885: --{
886: hr_utility.set_location(gv_package || '.action_creation', 60);
887: -- This indicates there is multiple W-2c or a Mark W-2c paper process ran
888: -- or a Federal W-2c Magnetic Process ran and reported for a set of W-2c.
889: -- Determine the last W-2c paper reported
890: OPEN get_last_reported_action(lp_business_group_id

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

892: ,lp_effective_date
893: ,lp_person_id
894: ,lp_assignment_action_id);
895: -- ,ln_corrected_asg_action);
896: hr_utility.set_location(gv_package || '.action_creation', 70);
897: LOOP
898: FETCH get_last_reported_action INTO ln_last_w2cp_pactid,
899: ln_last_w2cp_asg_actid,
900: ln_last_w2cpp_asg_action_id;

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

898: FETCH get_last_reported_action INTO ln_last_w2cp_pactid,
899: ln_last_w2cp_asg_actid,
900: ln_last_w2cpp_asg_action_id;
901:
902: hr_utility.set_location(gv_package || '.action_creation', 80);
903: if get_last_reported_action%ROWCOUNT = 0 then
904: hr_utility.set_location(gv_package || '.action_creation', 90);
905: hr_utility.trace('There is No other W-2c submitted to govt');
906: -- This condition will hold good if multiple W-2c paper printed

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

900: ln_last_w2cpp_asg_action_id;
901:
902: hr_utility.set_location(gv_package || '.action_creation', 80);
903: if get_last_reported_action%ROWCOUNT = 0 then
904: hr_utility.set_location(gv_package || '.action_creation', 90);
905: hr_utility.trace('There is No other W-2c submitted to govt');
906: -- This condition will hold good if multiple W-2c paper printed
907: -- for employee but not reported to Govt. For this scenario
908: -- YE Pre-process would be considered as previously reported

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

901:
902: hr_utility.set_location(gv_package || '.action_creation', 80);
903: if get_last_reported_action%ROWCOUNT = 0 then
904: hr_utility.set_location(gv_package || '.action_creation', 90);
905: hr_utility.trace('There is No other W-2c submitted to govt');
906: -- This condition will hold good if multiple W-2c paper printed
907: -- for employee but not reported to Govt. For this scenario
908: -- YE Pre-process would be considered as previously reported
909: -- action.

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

911: exit;
912: end if;
913: EXIT WHEN get_last_reported_action%NOTFOUND;
914: if ln_last_w2cp_asg_actid IS NOT NULL then
915: hr_utility.set_location(gv_package || '.action_creation', 100);
916: -- This scenario would exist if a W-2 correction is reported
917: -- either in paper form or in Magnetic Media
918: ln_orig_reported_asg_action := ln_last_w2cpp_asg_action_id;
919: exit;

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

922: CLOSE get_last_reported_action;
923: --}
924: end if;
925: --
926: hr_utility.set_location(gv_package || '.action_creation', 110);
927: hr_utility.trace('Corrected Assignment_Action_ID '||
928: to_char(ln_corrected_asg_action));
929: hr_utility.trace('Originally Reported Assignment_Action_ID '||
930: to_char(ln_orig_reported_asg_action));

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

923: --}
924: end if;
925: --
926: hr_utility.set_location(gv_package || '.action_creation', 110);
927: hr_utility.trace('Corrected Assignment_Action_ID '||
928: to_char(ln_corrected_asg_action));
929: hr_utility.trace('Originally Reported Assignment_Action_ID '||
930: to_char(ln_orig_reported_asg_action));
931:

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

925: --
926: hr_utility.set_location(gv_package || '.action_creation', 110);
927: hr_utility.trace('Corrected Assignment_Action_ID '||
928: to_char(ln_corrected_asg_action));
929: hr_utility.trace('Originally Reported Assignment_Action_ID '||
930: to_char(ln_orig_reported_asg_action));
931:
932: /* Create an assignment action for this person */
933: select pay_assignment_actions_s.nextval

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

932: /* Create an assignment action for this person */
933: select pay_assignment_actions_s.nextval
934: into ln_w2c_asg_action
935: from dual;
936: hr_utility.set_location(gv_package || '.action_creation', 120);
937: hr_utility.trace('New w2c Action = ' || to_char(ln_w2c_asg_action));
938:
939: /* Insert into pay_assignment_actions. */
940: hr_utility.trace('Creating Assignment Action');

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

933: select pay_assignment_actions_s.nextval
934: into ln_w2c_asg_action
935: from dual;
936: hr_utility.set_location(gv_package || '.action_creation', 120);
937: hr_utility.trace('New w2c Action = ' || to_char(ln_w2c_asg_action));
938:
939: /* Insert into pay_assignment_actions. */
940: hr_utility.trace('Creating Assignment Action');
941:

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

936: hr_utility.set_location(gv_package || '.action_creation', 120);
937: hr_utility.trace('New w2c Action = ' || to_char(ln_w2c_asg_action));
938:
939: /* Insert into pay_assignment_actions. */
940: hr_utility.trace('Creating Assignment Action');
941:
942: hr_nonrun_asact.insact(ln_w2c_asg_action
943: ,lp_assignment_id
944: ,p_payroll_action_id

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

949: so that the W2C report will not have
950: to do an additional checking against the assignment
951: table */
952:
953: hr_utility.set_location(gv_package || '.action_creation', 130);
954: hr_utility.trace('updating asg action');
955: /*************************************************************
956: ** Update the serial number column with the assignment action
957: ** of the last two archive processes

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

950: to do an additional checking against the assignment
951: table */
952:
953: hr_utility.set_location(gv_package || '.action_creation', 130);
954: hr_utility.trace('updating asg action');
955: /*************************************************************
956: ** Update the serial number column with the assignment action
957: ** of the last two archive processes
958: *************************************************************/

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

960: lpad(ln_orig_reported_asg_action,15,0);
961: update pay_assignment_actions aa
962: set aa.serial_number = ln_serial_number
963: where aa.assignment_action_id = ln_w2c_asg_action;
964: hr_utility.set_location(gv_package || '.action_creation', 140);
965:
966: /* Interlock the w2c report action with current w2c Mag action */
967: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);
968: hr_utility.trace('Locked Action = ' || lp_assignment_action_id);

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

963: where aa.assignment_action_id = ln_w2c_asg_action;
964: hr_utility.set_location(gv_package || '.action_creation', 140);
965:
966: /* Interlock the w2c report action with current w2c Mag action */
967: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);
968: hr_utility.trace('Locked Action = ' || lp_assignment_action_id);
969: hr_nonrun_asact.insint(ln_w2c_asg_action
970: ,lp_assignment_action_id);
971: /*

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

964: hr_utility.set_location(gv_package || '.action_creation', 140);
965:
966: /* Interlock the w2c report action with current w2c Mag action */
967: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);
968: hr_utility.trace('Locked Action = ' || lp_assignment_action_id);
969: hr_nonrun_asact.insint(ln_w2c_asg_action
970: ,lp_assignment_action_id);
971: /*
972: Lock all other W-2c paper action that are not yet locked by Fed W-2c

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

978: ,lp_effective_date
979: ,lp_assignment_id
980: ,lp_assignment_action_id
981: );
982: hr_utility.set_location(gv_package || '.action_creation', 150);
983: LOOP
984: FETCH c_w2c_paper_not_locked INTO ln_notlocked_asgn_actid;
985:
986: hr_utility.set_location(gv_package || '.action_creation', 160);

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

982: hr_utility.set_location(gv_package || '.action_creation', 150);
983: LOOP
984: FETCH c_w2c_paper_not_locked INTO ln_notlocked_asgn_actid;
985:
986: hr_utility.set_location(gv_package || '.action_creation', 160);
987: EXIT WHEN c_w2c_paper_not_locked%NOTFOUND;
988: if c_w2c_paper_not_locked%ROWCOUNT = 0 then
989: exit;
990: else

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

987: EXIT WHEN c_w2c_paper_not_locked%NOTFOUND;
988: if c_w2c_paper_not_locked%ROWCOUNT = 0 then
989: exit;
990: else
991: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);
992: hr_utility.trace('Locked Action = ' || ln_notlocked_asgn_actid);
993: hr_nonrun_asact.insint(ln_w2c_asg_action
994: ,ln_notlocked_asgn_actid);
995: end if;

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

988: if c_w2c_paper_not_locked%ROWCOUNT = 0 then
989: exit;
990: else
991: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);
992: hr_utility.trace('Locked Action = ' || ln_notlocked_asgn_actid);
993: hr_nonrun_asact.insint(ln_w2c_asg_action
994: ,ln_notlocked_asgn_actid);
995: end if;
996: END LOOP;

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

994: ,ln_notlocked_asgn_actid);
995: end if;
996: END LOOP;
997: CLOSE c_w2c_paper_not_locked;
998: hr_utility.set_location(gv_package || '.action_creation', 170);
999: end action_creation; -- End of Local function Action_Creation
1000: --
1001: -- Action Creation Main Logic
1002: --

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

1001: -- Action Creation Main Logic
1002: --
1003: begin
1004: --{
1005: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 10);
1006: hr_utility.trace('Entered Mark_W2c_action_creation ');
1007: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1008: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
1009: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));

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

1002: --
1003: begin
1004: --{
1005: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 10);
1006: hr_utility.trace('Entered Mark_W2c_action_creation ');
1007: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1008: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
1009: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1010: hr_utility.trace('p_chunk = '|| to_char(p_chunk));

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

1003: begin
1004: --{
1005: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 10);
1006: hr_utility.trace('Entered Mark_W2c_action_creation ');
1007: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1008: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
1009: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1010: hr_utility.trace('p_chunk = '|| to_char(p_chunk));
1011:

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

1004: --{
1005: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 10);
1006: hr_utility.trace('Entered Mark_W2c_action_creation ');
1007: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1008: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
1009: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1010: hr_utility.trace('p_chunk = '|| to_char(p_chunk));
1011:
1012: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 20);

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

1005: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 10);
1006: hr_utility.trace('Entered Mark_W2c_action_creation ');
1007: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1008: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
1009: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1010: hr_utility.trace('p_chunk = '|| to_char(p_chunk));
1011:
1012: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 20);
1013: get_payroll_action_info(p_payroll_action_id

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

1006: hr_utility.trace('Entered Mark_W2c_action_creation ');
1007: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
1008: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
1009: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1010: hr_utility.trace('p_chunk = '|| to_char(p_chunk));
1011:
1012: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 20);
1013: get_payroll_action_info(p_payroll_action_id
1014: ,ld_start_date

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

1008: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
1009: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
1010: hr_utility.trace('p_chunk = '|| to_char(p_chunk));
1011:
1012: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 20);
1013: get_payroll_action_info(p_payroll_action_id
1014: ,ld_start_date
1015: ,ld_end_date
1016: ,lv_report_type

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

1016: ,lv_report_type
1017: ,lv_report_qualifier
1018: ,ln_business_group_id);
1019:
1020: hr_utility.trace('ld_start_date = ' || ld_start_date);
1021: hr_utility.trace('ld_end_date = ' || ld_end_date);
1022: hr_utility.trace('lv_report_type = ' || lv_report_type);
1023: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
1024: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);

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

1017: ,lv_report_qualifier
1018: ,ln_business_group_id);
1019:
1020: hr_utility.trace('ld_start_date = ' || ld_start_date);
1021: hr_utility.trace('ld_end_date = ' || ld_end_date);
1022: hr_utility.trace('lv_report_type = ' || lv_report_type);
1023: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
1024: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
1025:

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

1018: ,ln_business_group_id);
1019:
1020: hr_utility.trace('ld_start_date = ' || ld_start_date);
1021: hr_utility.trace('ld_end_date = ' || ld_end_date);
1022: hr_utility.trace('lv_report_type = ' || lv_report_type);
1023: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
1024: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
1025:
1026: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 22);

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

1019:
1020: hr_utility.trace('ld_start_date = ' || ld_start_date);
1021: hr_utility.trace('ld_end_date = ' || ld_end_date);
1022: hr_utility.trace('lv_report_type = ' || lv_report_type);
1023: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
1024: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
1025:
1026: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 22);
1027: open w2c_future_correction_reported(ln_business_group_id

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

1020: hr_utility.trace('ld_start_date = ' || ld_start_date);
1021: hr_utility.trace('ld_end_date = ' || ld_end_date);
1022: hr_utility.trace('lv_report_type = ' || lv_report_type);
1023: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
1024: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
1025:
1026: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 22);
1027: open w2c_future_correction_reported(ln_business_group_id
1028: ,ld_start_date

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

1022: hr_utility.trace('lv_report_type = ' || lv_report_type);
1023: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
1024: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
1025:
1026: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 22);
1027: open w2c_future_correction_reported(ln_business_group_id
1028: ,ld_start_date
1029: ,ld_end_date
1030: ,p_start_person_id

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

1031: ,p_end_person_id
1032: );
1033: loop
1034: --{
1035: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 23);
1036: fetch w2c_future_correction_reported into ln_assignment_id,
1037: ln_person_id;
1038: if w2c_future_correction_reported%ROWCOUNT = 0 then
1039: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 24);

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

1035: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 23);
1036: fetch w2c_future_correction_reported into ln_assignment_id,
1037: ln_person_id;
1038: if w2c_future_correction_reported%ROWCOUNT = 0 then
1039: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 24);
1040: hr_utility.trace('No Person found for whose future correction is already reported');
1041: end if;
1042: EXIT WHEN w2c_future_correction_reported%NOTFOUND;
1043: --

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

1036: fetch w2c_future_correction_reported into ln_assignment_id,
1037: ln_person_id;
1038: if w2c_future_correction_reported%ROWCOUNT = 0 then
1039: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 24);
1040: hr_utility.trace('No Person found for whose future correction is already reported');
1041: end if;
1042: EXIT WHEN w2c_future_correction_reported%NOTFOUND;
1043: --
1044: -- If an employees future correction is already reported log a Warning to alert

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

1044: -- If an employees future correction is already reported log a Warning to alert
1045: -- that Federal W-2c Magnetic Media will not create action for this employee
1046: --
1047: if ln_person_id is not null then
1048: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 25);
1049: open get_warning_dtls_for_ee(ln_person_id);
1050: fetch get_warning_dtls_for_ee into lv_full_name
1051: ,lv_national_identifier;
1052: close get_warning_dtls_for_ee;

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

1049: open get_warning_dtls_for_ee(ln_person_id);
1050: fetch get_warning_dtls_for_ee into lv_full_name
1051: ,lv_national_identifier;
1052: close get_warning_dtls_for_ee;
1053: hr_utility.trace('WARNING: Employee '||lv_full_name ||' Reported Future corrections');
1054: hr_utility.trace(' SSN = '||lv_national_identifier);
1055: /* message to user -- This employees future correction is already Reported
1056: genrating W-2c Mag */
1057: lv_record_name := 'Action_Creation';

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

1050: fetch get_warning_dtls_for_ee into lv_full_name
1051: ,lv_national_identifier;
1052: close get_warning_dtls_for_ee;
1053: hr_utility.trace('WARNING: Employee '||lv_full_name ||' Reported Future corrections');
1054: hr_utility.trace(' SSN = '||lv_national_identifier);
1055: /* message to user -- This employees future correction is already Reported
1056: genrating W-2c Mag */
1057: lv_record_name := 'Action_Creation';
1058: lv_message := 'Future Correction reported for this employee';

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

1062: pay_core_utils.push_token('record_name', lv_record_name);
1063: pay_core_utils.push_token('name_or_number',lv_name);
1064: pay_core_utils.push_token('description', lv_message);
1065: end if;
1066: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 27);
1067: --}
1068: end loop;
1069: close w2c_future_correction_reported;
1070: --

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

1075: ,ld_end_date
1076: ,p_start_person_id
1077: ,p_end_person_id
1078: );
1079: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 30);
1080: loop
1081: --{
1082: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 40);
1083: fetch get_w2c_mag_assignments into ln_assignment_id,

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

1078: );
1079: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 30);
1080: loop
1081: --{
1082: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 40);
1083: fetch get_w2c_mag_assignments into ln_assignment_id,
1084: ln_emp_tax_unit_id,
1085: ln_person_id,
1086: ln_assignment_action_id,

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

1086: ln_assignment_action_id,
1087: ln_w2c_pp_asg_actid,
1088: ln_w2c_pp_locked_actid;
1089:
1090: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 50);
1091:
1092: if get_w2c_mag_assignments%ROWCOUNT = 0 then
1093: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 60);
1094: hr_utility.trace('No Person found for reporting in this chunk');

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

1089:
1090: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 50);
1091:
1092: if get_w2c_mag_assignments%ROWCOUNT = 0 then
1093: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 60);
1094: hr_utility.trace('No Person found for reporting in this chunk');
1095: end if;
1096:
1097: EXIT WHEN get_w2c_mag_assignments%NOTFOUND;

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

1090: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 50);
1091:
1092: if get_w2c_mag_assignments%ROWCOUNT = 0 then
1093: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 60);
1094: hr_utility.trace('No Person found for reporting in this chunk');
1095: end if;
1096:
1097: EXIT WHEN get_w2c_mag_assignments%NOTFOUND;
1098:

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

1095: end if;
1096:
1097: EXIT WHEN get_w2c_mag_assignments%NOTFOUND;
1098:
1099: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 70);
1100: hr_utility.trace('ln_assignment_id =' ||ln_assignment_id);
1101: hr_utility.trace('ln_emp_tax_unit_id =' ||ln_emp_tax_unit_id);
1102: hr_utility.trace('ln_person_id =' ||ln_person_id);
1103: hr_utility.trace('ln_assignment_action_id =' ||ln_assignment_action_id);

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

1096:
1097: EXIT WHEN get_w2c_mag_assignments%NOTFOUND;
1098:
1099: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 70);
1100: hr_utility.trace('ln_assignment_id =' ||ln_assignment_id);
1101: hr_utility.trace('ln_emp_tax_unit_id =' ||ln_emp_tax_unit_id);
1102: hr_utility.trace('ln_person_id =' ||ln_person_id);
1103: hr_utility.trace('ln_assignment_action_id =' ||ln_assignment_action_id);
1104: hr_utility.trace('Corrected assignment_action_id =' ||ln_w2c_pp_asg_actid);

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

1097: EXIT WHEN get_w2c_mag_assignments%NOTFOUND;
1098:
1099: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 70);
1100: hr_utility.trace('ln_assignment_id =' ||ln_assignment_id);
1101: hr_utility.trace('ln_emp_tax_unit_id =' ||ln_emp_tax_unit_id);
1102: hr_utility.trace('ln_person_id =' ||ln_person_id);
1103: hr_utility.trace('ln_assignment_action_id =' ||ln_assignment_action_id);
1104: hr_utility.trace('Corrected assignment_action_id =' ||ln_w2c_pp_asg_actid);
1105: hr_utility.trace('action locked by Corrected assignment_action_id =' ||ln_w2c_pp_locked_actid);

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

1098:
1099: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 70);
1100: hr_utility.trace('ln_assignment_id =' ||ln_assignment_id);
1101: hr_utility.trace('ln_emp_tax_unit_id =' ||ln_emp_tax_unit_id);
1102: hr_utility.trace('ln_person_id =' ||ln_person_id);
1103: hr_utility.trace('ln_assignment_action_id =' ||ln_assignment_action_id);
1104: hr_utility.trace('Corrected assignment_action_id =' ||ln_w2c_pp_asg_actid);
1105: hr_utility.trace('action locked by Corrected assignment_action_id =' ||ln_w2c_pp_locked_actid);
1106:

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

1099: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 70);
1100: hr_utility.trace('ln_assignment_id =' ||ln_assignment_id);
1101: hr_utility.trace('ln_emp_tax_unit_id =' ||ln_emp_tax_unit_id);
1102: hr_utility.trace('ln_person_id =' ||ln_person_id);
1103: hr_utility.trace('ln_assignment_action_id =' ||ln_assignment_action_id);
1104: hr_utility.trace('Corrected assignment_action_id =' ||ln_w2c_pp_asg_actid);
1105: hr_utility.trace('action locked by Corrected assignment_action_id =' ||ln_w2c_pp_locked_actid);
1106:
1107: if ln_person_id is not null then

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

1100: hr_utility.trace('ln_assignment_id =' ||ln_assignment_id);
1101: hr_utility.trace('ln_emp_tax_unit_id =' ||ln_emp_tax_unit_id);
1102: hr_utility.trace('ln_person_id =' ||ln_person_id);
1103: hr_utility.trace('ln_assignment_action_id =' ||ln_assignment_action_id);
1104: hr_utility.trace('Corrected assignment_action_id =' ||ln_w2c_pp_asg_actid);
1105: hr_utility.trace('action locked by Corrected assignment_action_id =' ||ln_w2c_pp_locked_actid);
1106:
1107: if ln_person_id is not null then
1108: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 80);

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

1101: hr_utility.trace('ln_emp_tax_unit_id =' ||ln_emp_tax_unit_id);
1102: hr_utility.trace('ln_person_id =' ||ln_person_id);
1103: hr_utility.trace('ln_assignment_action_id =' ||ln_assignment_action_id);
1104: hr_utility.trace('Corrected assignment_action_id =' ||ln_w2c_pp_asg_actid);
1105: hr_utility.trace('action locked by Corrected assignment_action_id =' ||ln_w2c_pp_locked_actid);
1106:
1107: if ln_person_id is not null then
1108: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 80);
1109: -- This check is performed to ignore duplicate assignment when a

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

1104: hr_utility.trace('Corrected assignment_action_id =' ||ln_w2c_pp_asg_actid);
1105: hr_utility.trace('action locked by Corrected assignment_action_id =' ||ln_w2c_pp_locked_actid);
1106:
1107: if ln_person_id is not null then
1108: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 80);
1109: -- This check is performed to ignore duplicate assignment when a
1110: -- person is having an update on assignment during the tax year.
1111: -- multiple assignment dur to update on assignment was causing
1112: -- duplicate RCW record.

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

1120: ln_business_group_id,
1121: ln_w2c_pp_asg_actid,
1122: ln_w2c_pp_locked_actid
1123: );
1124: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 90);
1125: end if;
1126: ln_prev_person_id := ln_person_id;
1127: end if;
1128: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 100);

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

1124: hr_utility.set_location(gv_package ||'.w2c_mag_action_creation', 90);
1125: end if;
1126: ln_prev_person_id := ln_person_id;
1127: end if;
1128: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 100);
1129: --}
1130: end loop;
1131: close get_w2c_mag_assignments;
1132: hr_utility.trace('Action Creation for W2c_Magnetic_Media completed Successfully');

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

1128: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 100);
1129: --}
1130: end loop;
1131: close get_w2c_mag_assignments;
1132: hr_utility.trace('Action Creation for W2c_Magnetic_Media completed Successfully');
1133: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 110);
1134: --}
1135: end w2c_mag_action_creation;
1136: -- End of Procedure mar_w2c_action_creation

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

1129: --}
1130: end loop;
1131: close get_w2c_mag_assignments;
1132: hr_utility.trace('Action Creation for W2c_Magnetic_Media completed Successfully');
1133: hr_utility.set_location(gv_package || '.w2c_mag_action_creation', 110);
1134: --}
1135: end w2c_mag_action_creation;
1136: -- End of Procedure mar_w2c_action_creation
1137: --

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

1135: end w2c_mag_action_creation;
1136: -- End of Procedure mar_w2c_action_creation
1137: --
1138: --Begin
1139: --hr_utility.trace_on(null,'W2CMAG');
1140: end pay_us_w2c_reporting_utils;