eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_MARK_W2C_PAPER dependencies on HR_UTILITY

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

86: ln_business_group_id number;
87: ln_seq_num number;
88:
89: BEGIN
90: hr_utility.set_location(gv_package || '.get_payroll_action_info', 10);
91:
92: open c_payroll_action(p_payroll_action_id);
93: fetch c_payroll_action into
94: ld_start_date,

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

97: lv_report_qualifier,
98: ln_business_group_id,
99: ln_seq_num;
100: if c_payroll_action%notfound then
101: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
102: hr_utility.trace('Payroll Action '||to_char(p_payroll_action_id)||' Not found');
103: hr_utility.raise_error;
104: end if;
105: close c_payroll_action;

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

98: ln_business_group_id,
99: ln_seq_num;
100: if c_payroll_action%notfound then
101: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
102: hr_utility.trace('Payroll Action '||to_char(p_payroll_action_id)||' Not found');
103: hr_utility.raise_error;
104: end if;
105: close c_payroll_action;
106: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);

Line 103: hr_utility.raise_error;

99: ln_seq_num;
100: if c_payroll_action%notfound then
101: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
102: hr_utility.trace('Payroll Action '||to_char(p_payroll_action_id)||' Not found');
103: hr_utility.raise_error;
104: end if;
105: close c_payroll_action;
106: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
107: p_start_date := ld_start_date;

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

102: hr_utility.trace('Payroll Action '||to_char(p_payroll_action_id)||' Not found');
103: hr_utility.raise_error;
104: end if;
105: close c_payroll_action;
106: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
107: p_start_date := ld_start_date;
108: p_end_date := ld_end_date;
109: p_report_type := lv_report_type;
110: p_report_qualifier := lv_report_qualifier;

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

110: p_report_qualifier := lv_report_qualifier;
111: p_business_group_id := ln_business_group_id;
112: p_seq_num := ln_seq_num;
113:
114: hr_utility.set_location(gv_package || '.get_payroll_action_info', 40);
115: END get_payroll_action_info;
116:
117: --------------------------------------------------------------------------
118: --Name

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

188: and ppa1.report_qualifier = 'FED'
189: and ppa1.report_category = 'RM'
190: and ppa1.action_status = 'C');
191: BEGIN
192: hr_utility.set_location(gv_package || '.preprocess_check', 10);
193: lb_return_value := TRUE;
194: ln_w2c_paper_asgn_actid := 0;
195: lv_message_text := '';
196: lv_message_preprocess := 'Pre-Process check';

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

205: FETCH get_w2c_paper_assignments INTO ln_w2c_paper_asgn_actid;
206: if (get_w2c_paper_assignments%ROWCOUNT = 0
207: or get_w2c_paper_assignments%NOTFOUND )
208: then
209: hr_utility.set_location(gv_package || '.preprocess_check', 20);
210: CLOSE get_w2c_paper_assignments;
211: /* message to user -- unable to find W-2c Paper report
212: to exclude from future tapes */
213: lv_message_text := 'No W-2c paper printed to mark and exclude from Tape';

Line 218: raise hr_utility.hr_error;

214: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
215: pay_core_utils.push_token('record_name',lv_message_preprocess);
216: pay_core_utils.push_token('description',lv_message_text);
217: lb_return_value := FALSE;
218: raise hr_utility.hr_error;
219: hr_utility.set_location(gv_package || '.preprocess_check', 30);
220: else
221: CLOSE get_w2c_paper_assignments;
222: lb_return_value := TRUE;

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

215: pay_core_utils.push_token('record_name',lv_message_preprocess);
216: pay_core_utils.push_token('description',lv_message_text);
217: lb_return_value := FALSE;
218: raise hr_utility.hr_error;
219: hr_utility.set_location(gv_package || '.preprocess_check', 30);
220: else
221: CLOSE get_w2c_paper_assignments;
222: lb_return_value := TRUE;
223: hr_utility.set_location(gv_package || '.preprocess_check', 30);

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

219: hr_utility.set_location(gv_package || '.preprocess_check', 30);
220: else
221: CLOSE get_w2c_paper_assignments;
222: lb_return_value := TRUE;
223: hr_utility.set_location(gv_package || '.preprocess_check', 30);
224: end if;
225: hr_utility.set_location(gv_package || '.preprocess_check', 40);
226: return lb_return_value;
227: END preprocess_check;

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

221: CLOSE get_w2c_paper_assignments;
222: lb_return_value := TRUE;
223: hr_utility.set_location(gv_package || '.preprocess_check', 30);
224: end if;
225: hr_utility.set_location(gv_package || '.preprocess_check', 40);
226: return lb_return_value;
227: END preprocess_check;
228: -- End of Function Preprocess_Check
229:

Line 248: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 10);

244: ln_seq_num number;
245:
246: lv_sql_string varchar2(10000);
247: BEGIN
248: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 10);
249: get_payroll_action_info(p_payroll_action_id
250: ,ld_start_date
251: ,ld_end_date
252: ,lv_report_type

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

254: ,ln_business_group_id
255: ,ln_seq_num
256: );
257:
258: hr_utility.trace('ld_start_date = ' || ld_start_date);
259: hr_utility.trace('ld_end_date = ' || ld_end_date);
260: hr_utility.trace('lv_report_type = ' || lv_report_type);
261: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
262: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);

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

255: ,ln_seq_num
256: );
257:
258: hr_utility.trace('ld_start_date = ' || ld_start_date);
259: hr_utility.trace('ld_end_date = ' || ld_end_date);
260: hr_utility.trace('lv_report_type = ' || lv_report_type);
261: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
262: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
263: hr_utility.trace('ln_seq_num = ' || to_char(ln_seq_num));

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

256: );
257:
258: hr_utility.trace('ld_start_date = ' || ld_start_date);
259: hr_utility.trace('ld_end_date = ' || ld_end_date);
260: hr_utility.trace('lv_report_type = ' || lv_report_type);
261: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
262: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
263: hr_utility.trace('ln_seq_num = ' || to_char(ln_seq_num));
264:

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

257:
258: hr_utility.trace('ld_start_date = ' || ld_start_date);
259: hr_utility.trace('ld_end_date = ' || ld_end_date);
260: hr_utility.trace('lv_report_type = ' || lv_report_type);
261: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
262: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
263: hr_utility.trace('ln_seq_num = ' || to_char(ln_seq_num));
264:
265: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 15);

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

258: hr_utility.trace('ld_start_date = ' || ld_start_date);
259: hr_utility.trace('ld_end_date = ' || ld_end_date);
260: hr_utility.trace('lv_report_type = ' || lv_report_type);
261: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
262: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
263: hr_utility.trace('ln_seq_num = ' || to_char(ln_seq_num));
264:
265: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 15);
266: if preprocess_check ( p_payroll_action_id

Line 263: hr_utility.trace('ln_seq_num = ' || to_char(ln_seq_num));

259: hr_utility.trace('ld_end_date = ' || ld_end_date);
260: hr_utility.trace('lv_report_type = ' || lv_report_type);
261: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
262: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
263: hr_utility.trace('ln_seq_num = ' || to_char(ln_seq_num));
264:
265: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 15);
266: if preprocess_check ( p_payroll_action_id
267: ,ld_start_date

Line 265: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 15);

261: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
262: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
263: hr_utility.trace('ln_seq_num = ' || to_char(ln_seq_num));
264:
265: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 15);
266: if preprocess_check ( p_payroll_action_id
267: ,ld_start_date
268: ,ld_end_date
269: ,ln_business_group_id

Line 272: hr_utility.trace('W-2c paper Assignments exist to process' );

268: ,ld_end_date
269: ,ln_business_group_id
270: )
271: then
272: hr_utility.trace('W-2c paper Assignments exist to process' );
273: else
274: hr_utility.trace('W-2c paper Assignments does not exist to process');
275: end if;
276:

Line 274: hr_utility.trace('W-2c paper Assignments does not exist to process');

270: )
271: then
272: hr_utility.trace('W-2c paper Assignments exist to process' );
273: else
274: hr_utility.trace('W-2c paper Assignments does not exist to process');
275: end if;
276:
277: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 20);
278: if lv_report_type = 'MARK_W2C_PAPER' then

Line 277: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 20);

273: else
274: hr_utility.trace('W-2c paper Assignments does not exist to process');
275: end if;
276:
277: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 20);
278: if lv_report_type = 'MARK_W2C_PAPER' then
279: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 30);
280: lv_sql_string :=
281: 'select distinct paf.person_id

Line 279: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 30);

275: end if;
276:
277: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 20);
278: if lv_report_type = 'MARK_W2C_PAPER' then
279: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 30);
280: lv_sql_string :=
281: 'select distinct paf.person_id
282: from pay_assignment_actions paa,
283: per_all_assignments_f paf,

Line 326: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 40);

322: and ppa1.report_type = ''W2C''
323: and ppa1.report_qualifier = ''FED''
324: and ppa1.action_status = ''C'')';
325: p_sqlstr := lv_sql_string;
326: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 40);
327: hr_utility.trace('p_sqlstr = ' ||substr(p_sqlstr,1,100));
328: hr_utility.trace('p_sqlstr = ' ||substr(p_sqlstr,2000,100));
329: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
330: hr_utility.trace('Procedure mark_w2c_range_cursor completed successfully');

Line 327: hr_utility.trace('p_sqlstr = ' ||substr(p_sqlstr,1,100));

323: and ppa1.report_qualifier = ''FED''
324: and ppa1.action_status = ''C'')';
325: p_sqlstr := lv_sql_string;
326: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 40);
327: hr_utility.trace('p_sqlstr = ' ||substr(p_sqlstr,1,100));
328: hr_utility.trace('p_sqlstr = ' ||substr(p_sqlstr,2000,100));
329: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
330: hr_utility.trace('Procedure mark_w2c_range_cursor completed successfully');
331:

Line 328: hr_utility.trace('p_sqlstr = ' ||substr(p_sqlstr,2000,100));

324: and ppa1.action_status = ''C'')';
325: p_sqlstr := lv_sql_string;
326: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 40);
327: hr_utility.trace('p_sqlstr = ' ||substr(p_sqlstr,1,100));
328: hr_utility.trace('p_sqlstr = ' ||substr(p_sqlstr,2000,100));
329: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
330: hr_utility.trace('Procedure mark_w2c_range_cursor completed successfully');
331:
332: else

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

325: p_sqlstr := lv_sql_string;
326: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 40);
327: hr_utility.trace('p_sqlstr = ' ||substr(p_sqlstr,1,100));
328: hr_utility.trace('p_sqlstr = ' ||substr(p_sqlstr,2000,100));
329: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
330: hr_utility.trace('Procedure mark_w2c_range_cursor completed successfully');
331:
332: else
333: hr_utility.trace('Procedure mark_w2c_range_cursor Unsucessful ... ');

Line 330: hr_utility.trace('Procedure mark_w2c_range_cursor completed successfully');

326: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 40);
327: hr_utility.trace('p_sqlstr = ' ||substr(p_sqlstr,1,100));
328: hr_utility.trace('p_sqlstr = ' ||substr(p_sqlstr,2000,100));
329: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
330: hr_utility.trace('Procedure mark_w2c_range_cursor completed successfully');
331:
332: else
333: hr_utility.trace('Procedure mark_w2c_range_cursor Unsucessful ... ');
334: end if;

Line 333: hr_utility.trace('Procedure mark_w2c_range_cursor Unsucessful ... ');

329: hr_utility.trace('length of p_sqlstr <' || to_char(length(p_sqlstr))||'>' );
330: hr_utility.trace('Procedure mark_w2c_range_cursor completed successfully');
331:
332: else
333: hr_utility.trace('Procedure mark_w2c_range_cursor Unsucessful ... ');
334: end if;
335:
336: end mark_w2c_range_cursor;
337:

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

456: lv_creation_date varchar2(20) ;
457: lv_sysdate varchar2(20) ;
458:
459: BEGIN
460: hr_utility.set_location(gv_package || '.action_creation', 10);
461: /* Create an assignment action for this person */
462:
463:
464: lv_year := to_char(ld_end_date,'YYYY'); --MOD

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

484:
485: select pay_assignment_actions_s.nextval
486: into ln_w2c_asg_action
487: from dual;
488: hr_utility.set_location(gv_package || '.action_creation', 20);
489: hr_utility.trace('New w2c Action = ' || to_char(ln_w2c_asg_action));
490:
491: /* Insert into pay_assignment_actions. */
492: hr_utility.trace('Creating Assignment Action');

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

485: select pay_assignment_actions_s.nextval
486: into ln_w2c_asg_action
487: from dual;
488: hr_utility.set_location(gv_package || '.action_creation', 20);
489: hr_utility.trace('New w2c Action = ' || to_char(ln_w2c_asg_action));
490:
491: /* Insert into pay_assignment_actions. */
492: hr_utility.trace('Creating Assignment Action');
493:

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

488: hr_utility.set_location(gv_package || '.action_creation', 20);
489: hr_utility.trace('New w2c Action = ' || to_char(ln_w2c_asg_action));
490:
491: /* Insert into pay_assignment_actions. */
492: hr_utility.trace('Creating Assignment Action');
493:
494: hr_nonrun_asact.insact(ln_w2c_asg_action
495: ,lp_assignment_id
496: ,p_payroll_action_id

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

501: so that the W2C report will not have
502: to do an additional checking against the assignment
503: table */
504:
505: hr_utility.set_location(gv_package || '.action_creation', 30);
506: hr_utility.trace('updating asg action');
507: update pay_assignment_actions aa
508: set aa.serial_number = lp_person_id
509: where aa.assignment_action_id = ln_w2c_asg_action;

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

502: to do an additional checking against the assignment
503: table */
504:
505: hr_utility.set_location(gv_package || '.action_creation', 30);
506: hr_utility.trace('updating asg action');
507: update pay_assignment_actions aa
508: set aa.serial_number = lp_person_id
509: where aa.assignment_action_id = ln_w2c_asg_action;
510:

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

509: where aa.assignment_action_id = ln_w2c_asg_action;
510:
511: /* Interlock the w2c report action with current mark w2c action */
512:
513: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);
514: hr_utility.trace('Locked Action = ' || lp_assignment_action_id);
515: hr_nonrun_asact.insint(ln_w2c_asg_action
516: ,lp_assignment_action_id);
517: hr_utility.set_location(gv_package || '.action_creation', 40);

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

510:
511: /* Interlock the w2c report action with current mark w2c action */
512:
513: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);
514: hr_utility.trace('Locked Action = ' || lp_assignment_action_id);
515: hr_nonrun_asact.insint(ln_w2c_asg_action
516: ,lp_assignment_action_id);
517: hr_utility.set_location(gv_package || '.action_creation', 40);
518:

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

513: hr_utility.trace('Locking Action = ' || ln_w2c_asg_action);
514: hr_utility.trace('Locked Action = ' || lp_assignment_action_id);
515: hr_nonrun_asact.insint(ln_w2c_asg_action
516: ,lp_assignment_action_id);
517: hr_utility.set_location(gv_package || '.action_creation', 40);
518:
519:
520: insert into pay_us_rpt_totals
521: (GRE_NAME,

Line 548: hr_utility.trace('Inserted lv_gre_name ' || lv_gre_name);

544: lv_sysdate
545: );
546:
547:
548: hr_utility.trace('Inserted lv_gre_name ' || lv_gre_name);
549: hr_utility.trace('Inserted lv_full_name ' || lv_full_name);
550: hr_utility.trace('Inserted lv_natidentifier' ||lv_national_identifier);
551: hr_utility.trace('Inserted lv_employee_number' ||lv_employee_number);
552: hr_utility.trace('Inserted lv_assignment_number' ||lv_assignment_number);

Line 549: hr_utility.trace('Inserted lv_full_name ' || lv_full_name);

545: );
546:
547:
548: hr_utility.trace('Inserted lv_gre_name ' || lv_gre_name);
549: hr_utility.trace('Inserted lv_full_name ' || lv_full_name);
550: hr_utility.trace('Inserted lv_natidentifier' ||lv_national_identifier);
551: hr_utility.trace('Inserted lv_employee_number' ||lv_employee_number);
552: hr_utility.trace('Inserted lv_assignment_number' ||lv_assignment_number);
553: hr_utility.trace('Inserted lp_aaid' ||to_char(lp_assignment_action_id));

Line 550: hr_utility.trace('Inserted lv_natidentifier' ||lv_national_identifier);

546:
547:
548: hr_utility.trace('Inserted lv_gre_name ' || lv_gre_name);
549: hr_utility.trace('Inserted lv_full_name ' || lv_full_name);
550: hr_utility.trace('Inserted lv_natidentifier' ||lv_national_identifier);
551: hr_utility.trace('Inserted lv_employee_number' ||lv_employee_number);
552: hr_utility.trace('Inserted lv_assignment_number' ||lv_assignment_number);
553: hr_utility.trace('Inserted lp_aaid' ||to_char(lp_assignment_action_id));
554:

Line 551: hr_utility.trace('Inserted lv_employee_number' ||lv_employee_number);

547:
548: hr_utility.trace('Inserted lv_gre_name ' || lv_gre_name);
549: hr_utility.trace('Inserted lv_full_name ' || lv_full_name);
550: hr_utility.trace('Inserted lv_natidentifier' ||lv_national_identifier);
551: hr_utility.trace('Inserted lv_employee_number' ||lv_employee_number);
552: hr_utility.trace('Inserted lv_assignment_number' ||lv_assignment_number);
553: hr_utility.trace('Inserted lp_aaid' ||to_char(lp_assignment_action_id));
554:
555: end action_creation; -- End of Local function Action_Creation

Line 552: hr_utility.trace('Inserted lv_assignment_number' ||lv_assignment_number);

548: hr_utility.trace('Inserted lv_gre_name ' || lv_gre_name);
549: hr_utility.trace('Inserted lv_full_name ' || lv_full_name);
550: hr_utility.trace('Inserted lv_natidentifier' ||lv_national_identifier);
551: hr_utility.trace('Inserted lv_employee_number' ||lv_employee_number);
552: hr_utility.trace('Inserted lv_assignment_number' ||lv_assignment_number);
553: hr_utility.trace('Inserted lp_aaid' ||to_char(lp_assignment_action_id));
554:
555: end action_creation; -- End of Local function Action_Creation
556: --

Line 553: hr_utility.trace('Inserted lp_aaid' ||to_char(lp_assignment_action_id));

549: hr_utility.trace('Inserted lv_full_name ' || lv_full_name);
550: hr_utility.trace('Inserted lv_natidentifier' ||lv_national_identifier);
551: hr_utility.trace('Inserted lv_employee_number' ||lv_employee_number);
552: hr_utility.trace('Inserted lv_assignment_number' ||lv_assignment_number);
553: hr_utility.trace('Inserted lp_aaid' ||to_char(lp_assignment_action_id));
554:
555: end action_creation; -- End of Local function Action_Creation
556: --
557: -- Action Creation Main Logic

Line 561: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 10);

557: -- Action Creation Main Logic
558: --
559: begin
560: --{
561: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 10);
562: hr_utility.trace('Entered Mark_W2c_action_creation ');
563: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
564: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
565: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));

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

558: --
559: begin
560: --{
561: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 10);
562: hr_utility.trace('Entered Mark_W2c_action_creation ');
563: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
564: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
565: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
566: hr_utility.trace('p_chunk = '|| to_char(p_chunk));

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

559: begin
560: --{
561: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 10);
562: hr_utility.trace('Entered Mark_W2c_action_creation ');
563: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
564: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
565: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
566: hr_utility.trace('p_chunk = '|| to_char(p_chunk));
567:

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

560: --{
561: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 10);
562: hr_utility.trace('Entered Mark_W2c_action_creation ');
563: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
564: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
565: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
566: hr_utility.trace('p_chunk = '|| to_char(p_chunk));
567:
568: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 15);

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

561: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 10);
562: hr_utility.trace('Entered Mark_W2c_action_creation ');
563: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
564: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
565: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
566: hr_utility.trace('p_chunk = '|| to_char(p_chunk));
567:
568: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 15);
569: get_payroll_action_info(p_payroll_action_id

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

562: hr_utility.trace('Entered Mark_W2c_action_creation ');
563: hr_utility.trace('p_payroll_action_id = '|| to_char(p_payroll_action_id));
564: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
565: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
566: hr_utility.trace('p_chunk = '|| to_char(p_chunk));
567:
568: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 15);
569: get_payroll_action_info(p_payroll_action_id
570: ,ld_start_date

Line 568: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 15);

564: hr_utility.trace('p_start_person_id = '|| to_char(p_start_person_id));
565: hr_utility.trace('p_end_person_id = '|| to_char(p_end_person_id));
566: hr_utility.trace('p_chunk = '|| to_char(p_chunk));
567:
568: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 15);
569: get_payroll_action_info(p_payroll_action_id
570: ,ld_start_date
571: ,ld_end_date
572: ,lv_report_type

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

573: ,lv_report_qualifier
574: ,ln_business_group_id
575: ,ln_seq_num);
576:
577: hr_utility.trace('ld_start_date = ' || ld_start_date);
578: hr_utility.trace('ld_end_date = ' || ld_end_date);
579: hr_utility.trace('lv_report_type = ' || lv_report_type);
580: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
581: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);

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

574: ,ln_business_group_id
575: ,ln_seq_num);
576:
577: hr_utility.trace('ld_start_date = ' || ld_start_date);
578: hr_utility.trace('ld_end_date = ' || ld_end_date);
579: hr_utility.trace('lv_report_type = ' || lv_report_type);
580: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
581: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
582: hr_utility.trace('ln_seq_num = ' || to_char(ln_seq_num));

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

575: ,ln_seq_num);
576:
577: hr_utility.trace('ld_start_date = ' || ld_start_date);
578: hr_utility.trace('ld_end_date = ' || ld_end_date);
579: hr_utility.trace('lv_report_type = ' || lv_report_type);
580: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
581: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
582: hr_utility.trace('ln_seq_num = ' || to_char(ln_seq_num));
583:

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

576:
577: hr_utility.trace('ld_start_date = ' || ld_start_date);
578: hr_utility.trace('ld_end_date = ' || ld_end_date);
579: hr_utility.trace('lv_report_type = ' || lv_report_type);
580: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
581: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
582: hr_utility.trace('ln_seq_num = ' || to_char(ln_seq_num));
583:
584: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 20);

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

577: hr_utility.trace('ld_start_date = ' || ld_start_date);
578: hr_utility.trace('ld_end_date = ' || ld_end_date);
579: hr_utility.trace('lv_report_type = ' || lv_report_type);
580: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
581: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
582: hr_utility.trace('ln_seq_num = ' || to_char(ln_seq_num));
583:
584: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 20);
585: open get_w2c_paper_assignments (ln_business_group_id

Line 582: hr_utility.trace('ln_seq_num = ' || to_char(ln_seq_num));

578: hr_utility.trace('ld_end_date = ' || ld_end_date);
579: hr_utility.trace('lv_report_type = ' || lv_report_type);
580: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
581: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
582: hr_utility.trace('ln_seq_num = ' || to_char(ln_seq_num));
583:
584: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 20);
585: open get_w2c_paper_assignments (ln_business_group_id
586: ,ld_start_date

Line 584: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 20);

580: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
581: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
582: hr_utility.trace('ln_seq_num = ' || to_char(ln_seq_num));
583:
584: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 20);
585: open get_w2c_paper_assignments (ln_business_group_id
586: ,ld_start_date
587: ,ld_end_date
588: ,p_start_person_id

Line 593: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 30);

589: ,p_end_person_id
590: );
591: loop
592: --{
593: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 30);
594: fetch get_w2c_paper_assignments into ln_assignment_id,
595: ln_emp_tax_unit_id,
596: ln_person_id,
597: ln_assignment_action_id;

Line 599: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 40);

595: ln_emp_tax_unit_id,
596: ln_person_id,
597: ln_assignment_action_id;
598:
599: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 40);
600:
601: if get_w2c_paper_assignments%ROWCOUNT = 0 then
602: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 50);
603: hr_utility.trace('No Person found for reporting in this chunk');

Line 602: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 50);

598:
599: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 40);
600:
601: if get_w2c_paper_assignments%ROWCOUNT = 0 then
602: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 50);
603: hr_utility.trace('No Person found for reporting in this chunk');
604: end if;
605:
606: EXIT WHEN get_w2c_paper_assignments%NOTFOUND;

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

599: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 40);
600:
601: if get_w2c_paper_assignments%ROWCOUNT = 0 then
602: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 50);
603: hr_utility.trace('No Person found for reporting in this chunk');
604: end if;
605:
606: EXIT WHEN get_w2c_paper_assignments%NOTFOUND;
607:

Line 608: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 60);

604: end if;
605:
606: EXIT WHEN get_w2c_paper_assignments%NOTFOUND;
607:
608: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 60);
609: hr_utility.trace('ln_assignment_id =' || ln_assignment_id);
610: hr_utility.trace('ln_emp_tax_unit_id =' || ln_emp_tax_unit_id);
611: hr_utility.trace('ln_person_id =' || ln_person_id);
612: hr_utility.trace('ln_assignment_action_id =' || ln_assignment_action_id);

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

605:
606: EXIT WHEN get_w2c_paper_assignments%NOTFOUND;
607:
608: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 60);
609: hr_utility.trace('ln_assignment_id =' || ln_assignment_id);
610: hr_utility.trace('ln_emp_tax_unit_id =' || ln_emp_tax_unit_id);
611: hr_utility.trace('ln_person_id =' || ln_person_id);
612: hr_utility.trace('ln_assignment_action_id =' || ln_assignment_action_id);
613:

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

606: EXIT WHEN get_w2c_paper_assignments%NOTFOUND;
607:
608: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 60);
609: hr_utility.trace('ln_assignment_id =' || ln_assignment_id);
610: hr_utility.trace('ln_emp_tax_unit_id =' || ln_emp_tax_unit_id);
611: hr_utility.trace('ln_person_id =' || ln_person_id);
612: hr_utility.trace('ln_assignment_action_id =' || ln_assignment_action_id);
613:
614: if ln_person_id is not null then

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

607:
608: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 60);
609: hr_utility.trace('ln_assignment_id =' || ln_assignment_id);
610: hr_utility.trace('ln_emp_tax_unit_id =' || ln_emp_tax_unit_id);
611: hr_utility.trace('ln_person_id =' || ln_person_id);
612: hr_utility.trace('ln_assignment_action_id =' || ln_assignment_action_id);
613:
614: if ln_person_id is not null then
615: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 70);

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

608: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 60);
609: hr_utility.trace('ln_assignment_id =' || ln_assignment_id);
610: hr_utility.trace('ln_emp_tax_unit_id =' || ln_emp_tax_unit_id);
611: hr_utility.trace('ln_person_id =' || ln_person_id);
612: hr_utility.trace('ln_assignment_action_id =' || ln_assignment_action_id);
613:
614: if ln_person_id is not null then
615: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 70);
616: action_creation(ln_person_id,

Line 615: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 70);

611: hr_utility.trace('ln_person_id =' || ln_person_id);
612: hr_utility.trace('ln_assignment_action_id =' || ln_assignment_action_id);
613:
614: if ln_person_id is not null then
615: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 70);
616: action_creation(ln_person_id,
617: ln_assignment_id,
618: ln_assignment_action_id,
619: ln_emp_tax_unit_id,

Line 623: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 80);

619: ln_emp_tax_unit_id,
620: ld_start_date,
621: ld_end_date,
622: ln_seq_num);
623: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 80);
624:
625: end if;
626: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 90);
627: --}

Line 626: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 90);

622: ln_seq_num);
623: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 80);
624:
625: end if;
626: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 90);
627: --}
628: end loop;
629: close get_w2c_paper_assignments;
630: hr_utility.trace('Action Creation for Mark_W2c_Paper completed Successfully');

Line 630: hr_utility.trace('Action Creation for Mark_W2c_Paper completed Successfully');

626: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 90);
627: --}
628: end loop;
629: close get_w2c_paper_assignments;
630: hr_utility.trace('Action Creation for Mark_W2c_Paper completed Successfully');
631: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 100);
632: --}
633: end mark_w2c_action_creation;
634: -- End of Procedure mar_w2c_action_creation

Line 631: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 100);

627: --}
628: end loop;
629: close get_w2c_paper_assignments;
630: hr_utility.trace('Action Creation for Mark_W2c_Paper completed Successfully');
631: hr_utility.set_location(gv_package || '.mark_w2c_action_creation', 100);
632: --}
633: end mark_w2c_action_creation;
634: -- End of Procedure mar_w2c_action_creation
635: --alka --

Line 650: hr_utility.set_location(gv_package || '.formated_static_header', 10);

646: lv_format2 varchar2(32000);
647:
648: BEGIN
649:
650: hr_utility.set_location(gv_package || '.formated_static_header', 10);
651: hr_utility.trace('Entered employee_header');
652:
653:
654: lv_format1 :=

Line 651: hr_utility.trace('Entered employee_header');

647:
648: BEGIN
649:
650: hr_utility.set_location(gv_package || '.formated_static_header', 10);
651: hr_utility.trace('Entered employee_header');
652:
653:
654: lv_format1 :=
655: pay_us_payroll_utils.formated_data_string (

Line 680: hr_utility.trace('Leaving employee_header');

676: p_input_string => 'Paper Creation Date'
677: ,p_bold => 'Y'
678: ,p_output_file_type => p_output_file_type) ;
679:
680: hr_utility.trace('Leaving employee_header');
681: RETURN (lv_format1);
682: END employee_header;
683:
684:

Line 706: hr_utility.set_location(gv_package || '.formated_static_data', 10);

702:
703:
704: BEGIN
705:
706: hr_utility.set_location(gv_package || '.formated_static_data', 10);
707: hr_utility.trace('Entered employee_data');
708: hr_utility.trace('ER Name = '||p_tax_unit_name);
709: hr_utility.trace('Year = '||p_year);
710: hr_utility.trace('EE Name = '||p_full_name);

Line 707: hr_utility.trace('Entered employee_data');

703:
704: BEGIN
705:
706: hr_utility.set_location(gv_package || '.formated_static_data', 10);
707: hr_utility.trace('Entered employee_data');
708: hr_utility.trace('ER Name = '||p_tax_unit_name);
709: hr_utility.trace('Year = '||p_year);
710: hr_utility.trace('EE Name = '||p_full_name);
711:

Line 708: hr_utility.trace('ER Name = '||p_tax_unit_name);

704: BEGIN
705:
706: hr_utility.set_location(gv_package || '.formated_static_data', 10);
707: hr_utility.trace('Entered employee_data');
708: hr_utility.trace('ER Name = '||p_tax_unit_name);
709: hr_utility.trace('Year = '||p_year);
710: hr_utility.trace('EE Name = '||p_full_name);
711:
712: lv_format1 :=

Line 709: hr_utility.trace('Year = '||p_year);

705:
706: hr_utility.set_location(gv_package || '.formated_static_data', 10);
707: hr_utility.trace('Entered employee_data');
708: hr_utility.trace('ER Name = '||p_tax_unit_name);
709: hr_utility.trace('Year = '||p_year);
710: hr_utility.trace('EE Name = '||p_full_name);
711:
712: lv_format1 :=
713: pay_us_payroll_utils.formated_data_string (

Line 710: hr_utility.trace('EE Name = '||p_full_name);

706: hr_utility.set_location(gv_package || '.formated_static_data', 10);
707: hr_utility.trace('Entered employee_data');
708: hr_utility.trace('ER Name = '||p_tax_unit_name);
709: hr_utility.trace('Year = '||p_year);
710: hr_utility.trace('EE Name = '||p_full_name);
711:
712: lv_format1 :=
713: pay_us_payroll_utils.formated_data_string (
714: p_input_string => p_tax_unit_name

Line 732: hr_utility.set_location(gv_package || '.formated_static_data', 20);

728: pay_us_payroll_utils.formated_data_string (
729: p_input_string => p_creation_date
730: ,p_output_file_type => p_output_file_type) ;
731:
732: hr_utility.set_location(gv_package || '.formated_static_data', 20);
733:
734:
735: hr_utility.trace('Static Data1 = ' || lv_format1);
736: hr_utility.set_location(gv_package || '.formated_static_data', 40);

Line 735: hr_utility.trace('Static Data1 = ' || lv_format1);

731:
732: hr_utility.set_location(gv_package || '.formated_static_data', 20);
733:
734:
735: hr_utility.trace('Static Data1 = ' || lv_format1);
736: hr_utility.set_location(gv_package || '.formated_static_data', 40);
737: hr_utility.trace('Built employee_data');
738:
739: return (lv_format1);

Line 736: hr_utility.set_location(gv_package || '.formated_static_data', 40);

732: hr_utility.set_location(gv_package || '.formated_static_data', 20);
733:
734:
735: hr_utility.trace('Static Data1 = ' || lv_format1);
736: hr_utility.set_location(gv_package || '.formated_static_data', 40);
737: hr_utility.trace('Built employee_data');
738:
739: return (lv_format1);
740: hr_utility.trace('Leaving employee_data');

Line 737: hr_utility.trace('Built employee_data');

733:
734:
735: hr_utility.trace('Static Data1 = ' || lv_format1);
736: hr_utility.set_location(gv_package || '.formated_static_data', 40);
737: hr_utility.trace('Built employee_data');
738:
739: return (lv_format1);
740: hr_utility.trace('Leaving employee_data');
741: END employee_data;

Line 740: hr_utility.trace('Leaving employee_data');

736: hr_utility.set_location(gv_package || '.formated_static_data', 40);
737: hr_utility.trace('Built employee_data');
738:
739: return (lv_format1);
740: hr_utility.trace('Leaving employee_data');
741: END employee_data;
742:
743:
744: PROCEDURE select_ee_details(errbuf OUT nocopy VARCHAR2,

Line 784: hr_utility.trace('Entered Main package');

780: lv_data_row varchar2(32000);
781: lv_output_file_type varchar2(240);
782:
783: BEGIN
784: hr_utility.trace('Entered Main package');
785: hr_utility.trace('p_seq_num = '||p_seq_num);
786:
787: open c_get_lookup_code(p_output_file_type);
788: fetch c_get_lookup_code into lv_output_file_type;

Line 785: hr_utility.trace('p_seq_num = '||p_seq_num);

781: lv_output_file_type varchar2(240);
782:
783: BEGIN
784: hr_utility.trace('Entered Main package');
785: hr_utility.trace('p_seq_num = '||p_seq_num);
786:
787: open c_get_lookup_code(p_output_file_type);
788: fetch c_get_lookup_code into lv_output_file_type;
789: close c_get_lookup_code;

Line 793: hr_utility.trace('Opened c_ee_details');

789: close c_get_lookup_code;
790:
791:
792: OPEN c_ee_details(p_seq_num);
793: hr_utility.trace('Opened c_ee_details');
794: LOOP
795: lv_gre_name := null;
796: lv_full_name := null;
797: lv_ssn := null;

Line 813: hr_utility.trace('Fetched c_ee_details');

809: lv_year,
810: lv_creation_date,
811: lv_sysdate;
812:
813: hr_utility.trace('Fetched c_ee_details');
814: EXIT WHEN c_ee_details%notfound;
815:
816: if c_ee_details%ROWCOUNT =1 THEN
817:

Line 874: --hr_utility.trace_on(null,'MARKW2C');

870:
871: END select_ee_details;
872:
873: Begin
874: --hr_utility.trace_on(null,'MARKW2C');
875: gv_package := 'pay_us_mark_w2c_paper';
876: gv_title := 'Assignments Marked to be Excluded from W-2c Tape';
877: END pay_us_mark_w2c_paper;