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

[Home] [Help]

APPS.PAY_US_MARK_W2C_PAPER dependencies on HR_UTILITY

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

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

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

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

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

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

Line 101: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 216: raise hr_utility.hr_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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