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_CA_RULES dependencies on HR_UTILITY

Line 160: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');

156: if lv_gre_type = 'T4/RL1' then
157: p_tax_unit_id := ln_t4_rl1_gre;
158: else
159: p_tax_unit_id := null;
160: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');
161: pay_core_utils.push_message(801,'PAY_74161_MISSING_GRE','P');
162: hr_utility.raise_error;
163: end if;
164:

Line 162: hr_utility.raise_error;

158: else
159: p_tax_unit_id := null;
160: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');
161: pay_core_utils.push_message(801,'PAY_74161_MISSING_GRE','P');
162: hr_utility.raise_error;
163: end if;
164:
165: elsif lv_run_type_gre = 'T4A/RL1' then
166:

Line 175: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');

171: if lv_gre_type = 'T4A/RL1' then
172: p_tax_unit_id := ln_t4a_rl1_gre;
173: else
174: p_tax_unit_id := null;
175: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');
176: pay_core_utils.push_message(801,'PAY_74161_MISSING_GRE','P');
177: hr_utility.raise_error;
178: end if;
179:

Line 177: hr_utility.raise_error;

173: else
174: p_tax_unit_id := null;
175: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');
176: pay_core_utils.push_message(801,'PAY_74161_MISSING_GRE','P');
177: hr_utility.raise_error;
178: end if;
179:
180: elsif lv_run_type_gre = 'T4A/RL2' then
181:

Line 187: hr_utility.trace('in lv_gre_type = T4A/RL2');

183: fetch cur_check_gre_type into lv_gre_type;
184: close cur_check_gre_type;
185:
186: if lv_gre_type = 'T4A/RL2' then
187: hr_utility.trace('in lv_gre_type = T4A/RL2');
188: p_tax_unit_id := ln_t4a_rl2_gre;
189: else
190: p_tax_unit_id := null;
191: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');

Line 191: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');

187: hr_utility.trace('in lv_gre_type = T4A/RL2');
188: p_tax_unit_id := ln_t4a_rl2_gre;
189: else
190: p_tax_unit_id := null;
191: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');
192: pay_core_utils.push_message(801,'PAY_74161_MISSING_GRE','P');
193: hr_utility.raise_error;
194: end if;
195:

Line 193: hr_utility.raise_error;

189: else
190: p_tax_unit_id := null;
191: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');
192: pay_core_utils.push_message(801,'PAY_74161_MISSING_GRE','P');
193: hr_utility.raise_error;
194: end if;
195:
196: else
197:

Line 275: hr_utility.trace('Add Custom XML starts here .... ');

271:
272:
273: BEGIN
274:
275: hr_utility.trace('Add Custom XML starts here .... ');
276:
277: l_payroll_action_id
278: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
279: l_override_cpa_code

Line 284: hr_utility.trace('l_payroll_action_id = ' ||

280: := pay_magtape_generic.get_parameter_value('OVERRIDE_CPA_CODE');
281: l_dd_type
282: := pay_magtape_generic.get_parameter_value('MAGTAPE_REPORT_ID');
283:
284: hr_utility.trace('l_payroll_action_id = ' ||
285: to_char(l_payroll_action_id));
286: hr_utility.trace('l_override_cpa_code = ' || l_override_cpa_code);
287:
288: OPEN cur_ppa(l_payroll_action_id);

Line 286: hr_utility.trace('l_override_cpa_code = ' || l_override_cpa_code);

282: := pay_magtape_generic.get_parameter_value('MAGTAPE_REPORT_ID');
283:
284: hr_utility.trace('l_payroll_action_id = ' ||
285: to_char(l_payroll_action_id));
286: hr_utility.trace('l_override_cpa_code = ' || l_override_cpa_code);
287:
288: OPEN cur_ppa(l_payroll_action_id);
289: FETCH cur_ppa
290: INTO l_payment_date,

Line 294: hr_utility.trace('l_payment_date = ' || to_char(l_payment_date));

290: INTO l_payment_date,
291: l_direct_deposit_date;
292: CLOSE cur_ppa;
293:
294: hr_utility.trace('l_payment_date = ' || to_char(l_payment_date));
295: hr_utility.trace('l_direct_deposit_date = ' ||
296: to_char(l_direct_deposit_date));
297: SELECT
298: decode(l_dd_type, 'NOVA_SCOT',to_char(l_direct_deposit_date,'YYDDD'),

Line 295: hr_utility.trace('l_direct_deposit_date = ' ||

291: l_direct_deposit_date;
292: CLOSE cur_ppa;
293:
294: hr_utility.trace('l_payment_date = ' || to_char(l_payment_date));
295: hr_utility.trace('l_direct_deposit_date = ' ||
296: to_char(l_direct_deposit_date));
297: SELECT
298: decode(l_dd_type, 'NOVA_SCOT',to_char(l_direct_deposit_date,'YYDDD'),
299: 'TD', to_char(l_direct_deposit_date,'DDMMYY'),

Line 322: hr_utility.trace('Add Custom XML ends here .......');

318: ''|| l_dd_date || '' ||
319: '' || l_override_cpa_code || '';
320:
321: pay_core_files.write_to_magtape_lob(l_text);
322: hr_utility.trace('Add Custom XML ends here .......');
323:
324: END add_custom_xml;
325:
326: FUNCTION work_schedule_total_hours(

Line 381: hr_utility.trace('Getting ID_FLEX_NUM for CA legislation ');

377: c_ws_tab_name := 'COMPANY WORK SCHEDULES';
378:
379: /* get ID FLEX NUM */
380: --IF pay_us_rules.g_id_flex_num IS NULL THEN
381: hr_utility.trace('Getting ID_FLEX_NUM for CA legislation ');
382: OPEN get_id_flex_num;
383: FETCH get_id_flex_num INTO l_id_flex_num;
384: -- pay_us_rules.g_id_flex_num := l_id_flex_num;
385: CLOSE get_id_flex_num;

Line 388: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);

384: -- pay_us_rules.g_id_flex_num := l_id_flex_num;
385: CLOSE get_id_flex_num;
386: --END IF;
387:
388: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
389: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
390: hr_utility.trace('assignment_action_id=' || assignment_action_id);
391: hr_utility.trace('assignment_id=' || assignment_id);
392: hr_utility.trace('business_group_id=' || p_bg_id);

Line 389: hr_utility.trace('l_id_flex_num '||l_id_flex_num);

385: CLOSE get_id_flex_num;
386: --END IF;
387:
388: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
389: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
390: hr_utility.trace('assignment_action_id=' || assignment_action_id);
391: hr_utility.trace('assignment_id=' || assignment_id);
392: hr_utility.trace('business_group_id=' || p_bg_id);
393: hr_utility.trace('p_range_start=' || p_range_start);

Line 390: hr_utility.trace('assignment_action_id=' || assignment_action_id);

386: --END IF;
387:
388: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
389: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
390: hr_utility.trace('assignment_action_id=' || assignment_action_id);
391: hr_utility.trace('assignment_id=' || assignment_id);
392: hr_utility.trace('business_group_id=' || p_bg_id);
393: hr_utility.trace('p_range_start=' || p_range_start);
394: hr_utility.trace('p_range_end=' || p_range_end);

Line 391: hr_utility.trace('assignment_id=' || assignment_id);

387:
388: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
389: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
390: hr_utility.trace('assignment_action_id=' || assignment_action_id);
391: hr_utility.trace('assignment_id=' || assignment_id);
392: hr_utility.trace('business_group_id=' || p_bg_id);
393: hr_utility.trace('p_range_start=' || p_range_start);
394: hr_utility.trace('p_range_end=' || p_range_end);
395: hr_utility.trace('element_entry_id=' || element_entry_id);

Line 392: hr_utility.trace('business_group_id=' || p_bg_id);

388: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
389: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
390: hr_utility.trace('assignment_action_id=' || assignment_action_id);
391: hr_utility.trace('assignment_id=' || assignment_id);
392: hr_utility.trace('business_group_id=' || p_bg_id);
393: hr_utility.trace('p_range_start=' || p_range_start);
394: hr_utility.trace('p_range_end=' || p_range_end);
395: hr_utility.trace('element_entry_id=' || element_entry_id);
396: hr_utility.trace('date_earned ' || date_earned);

Line 393: hr_utility.trace('p_range_start=' || p_range_start);

389: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
390: hr_utility.trace('assignment_action_id=' || assignment_action_id);
391: hr_utility.trace('assignment_id=' || assignment_id);
392: hr_utility.trace('business_group_id=' || p_bg_id);
393: hr_utility.trace('p_range_start=' || p_range_start);
394: hr_utility.trace('p_range_end=' || p_range_end);
395: hr_utility.trace('element_entry_id=' || element_entry_id);
396: hr_utility.trace('date_earned ' || date_earned);
397:

Line 394: hr_utility.trace('p_range_end=' || p_range_end);

390: hr_utility.trace('assignment_action_id=' || assignment_action_id);
391: hr_utility.trace('assignment_id=' || assignment_id);
392: hr_utility.trace('business_group_id=' || p_bg_id);
393: hr_utility.trace('p_range_start=' || p_range_start);
394: hr_utility.trace('p_range_end=' || p_range_end);
395: hr_utility.trace('element_entry_id=' || element_entry_id);
396: hr_utility.trace('date_earned ' || date_earned);
397:
398: /* get work schedule_name */

Line 395: hr_utility.trace('element_entry_id=' || element_entry_id);

391: hr_utility.trace('assignment_id=' || assignment_id);
392: hr_utility.trace('business_group_id=' || p_bg_id);
393: hr_utility.trace('p_range_start=' || p_range_start);
394: hr_utility.trace('p_range_end=' || p_range_end);
395: hr_utility.trace('element_entry_id=' || element_entry_id);
396: hr_utility.trace('date_earned ' || date_earned);
397:
398: /* get work schedule_name */
399: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN

Line 396: hr_utility.trace('date_earned ' || date_earned);

392: hr_utility.trace('business_group_id=' || p_bg_id);
393: hr_utility.trace('p_range_start=' || p_range_start);
394: hr_utility.trace('p_range_end=' || p_range_end);
395: hr_utility.trace('element_entry_id=' || element_entry_id);
396: hr_utility.trace('date_earned ' || date_earned);
397:
398: /* get work schedule_name */
399: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN
400: IF l_id_flex_num IS NOT NULL THEN

Line 401: hr_utility.trace('getting work schedule name ');

397:
398: /* get work schedule_name */
399: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN
400: IF l_id_flex_num IS NOT NULL THEN
401: hr_utility.trace('getting work schedule name ');
402: OPEN get_ws_name (l_id_flex_num,--pay_ca_rules.g_id_flex_num,
403: date_earned,
404: assignment_id);
405: FETCH get_ws_name INTO p_ws_name;

Line 410: hr_utility.trace('Work Schedule not found ');

406: CLOSE get_ws_name;
407: END IF;
408:
409: IF p_ws_name IS NULL THEN
410: hr_utility.trace('Work Schedule not found ');
411: return 0;
412: END IF;
413:
414: hr_utility.trace('Work Schedule '||p_ws_name);

Line 414: hr_utility.trace('Work Schedule '||p_ws_name);

410: hr_utility.trace('Work Schedule not found ');
411: return 0;
412: END IF;
413:
414: hr_utility.trace('Work Schedule '||p_ws_name);
415:
416: --changed to select the work schedule defined
417: --at the business group level instead of
418: --hardcoding the default work schedule

Line 447: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');

443: -- Check for valid range
444: IF v_range_start > v_range_end THEN
445: --
446: RETURN v_total_hours;
447: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
448: -- hr_utility.raise_error;
449: --
450: END IF;
451:

Line 448: -- hr_utility.raise_error;

444: IF v_range_start > v_range_end THEN
445: --
446: RETURN v_total_hours;
447: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
448: -- hr_utility.raise_error;
449: --
450: END IF;
451:
452: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this

Line 555: hr_utility.trace('Starting pay_ca_rules.get_file_creation_number !!!!');

551: l_dd_format VARCHAR2(30);
552:
553: BEGIN
554:
555: hr_utility.trace('Starting pay_ca_rules.get_file_creation_number !!!!');
556:
557: OPEN cur_paid;
558: FETCH cur_paid
559: INTO l_legislative_parameter,

Line 571: hr_utility.trace('payroll_action_id = ' || to_char(pactid));

567: l_legislative_parameter);
568: l_dd_format := pay_core_utils.get_parameter('MAGTAPE_REPORT_ID',
569: l_legislative_parameter);
570:
571: hr_utility.trace('payroll_action_id = ' || to_char(pactid));
572: hr_utility.trace('l_org_pm_id = ' || to_char(l_org_pm_id));
573: hr_utility.trace('l_bg_id = ' || to_char(l_bg_id));
574: hr_utility.trace('l_legislative_parameter = ' || l_legislative_parameter);
575: hr_utility.trace('l_override_file_no = ' || l_override_file_no);

Line 572: hr_utility.trace('l_org_pm_id = ' || to_char(l_org_pm_id));

568: l_dd_format := pay_core_utils.get_parameter('MAGTAPE_REPORT_ID',
569: l_legislative_parameter);
570:
571: hr_utility.trace('payroll_action_id = ' || to_char(pactid));
572: hr_utility.trace('l_org_pm_id = ' || to_char(l_org_pm_id));
573: hr_utility.trace('l_bg_id = ' || to_char(l_bg_id));
574: hr_utility.trace('l_legislative_parameter = ' || l_legislative_parameter);
575: hr_utility.trace('l_override_file_no = ' || l_override_file_no);
576: hr_utility.trace('l_dd_format = ' || l_dd_format);

Line 573: hr_utility.trace('l_bg_id = ' || to_char(l_bg_id));

569: l_legislative_parameter);
570:
571: hr_utility.trace('payroll_action_id = ' || to_char(pactid));
572: hr_utility.trace('l_org_pm_id = ' || to_char(l_org_pm_id));
573: hr_utility.trace('l_bg_id = ' || to_char(l_bg_id));
574: hr_utility.trace('l_legislative_parameter = ' || l_legislative_parameter);
575: hr_utility.trace('l_override_file_no = ' || l_override_file_no);
576: hr_utility.trace('l_dd_format = ' || l_dd_format);
577:

Line 574: hr_utility.trace('l_legislative_parameter = ' || l_legislative_parameter);

570:
571: hr_utility.trace('payroll_action_id = ' || to_char(pactid));
572: hr_utility.trace('l_org_pm_id = ' || to_char(l_org_pm_id));
573: hr_utility.trace('l_bg_id = ' || to_char(l_bg_id));
574: hr_utility.trace('l_legislative_parameter = ' || l_legislative_parameter);
575: hr_utility.trace('l_override_file_no = ' || l_override_file_no);
576: hr_utility.trace('l_dd_format = ' || l_dd_format);
577:
578: IF l_override_file_no IS NOT NULL THEN

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

571: hr_utility.trace('payroll_action_id = ' || to_char(pactid));
572: hr_utility.trace('l_org_pm_id = ' || to_char(l_org_pm_id));
573: hr_utility.trace('l_bg_id = ' || to_char(l_bg_id));
574: hr_utility.trace('l_legislative_parameter = ' || l_legislative_parameter);
575: hr_utility.trace('l_override_file_no = ' || l_override_file_no);
576: hr_utility.trace('l_dd_format = ' || l_dd_format);
577:
578: IF l_override_file_no IS NOT NULL THEN
579: file_no := l_override_file_no;

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

572: hr_utility.trace('l_org_pm_id = ' || to_char(l_org_pm_id));
573: hr_utility.trace('l_bg_id = ' || to_char(l_bg_id));
574: hr_utility.trace('l_legislative_parameter = ' || l_legislative_parameter);
575: hr_utility.trace('l_override_file_no = ' || l_override_file_no);
576: hr_utility.trace('l_dd_format = ' || l_dd_format);
577:
578: IF l_override_file_no IS NOT NULL THEN
579: file_no := l_override_file_no;
580: ELSE

Line 589: hr_utility.trace('file_no = ' || file_no);

585: pactid ,
586: l_bg_id) ;
587: END IF;
588:
589: hr_utility.trace('file_no = ' || file_no);
590: hr_utility.trace('Ending pay_ca_rules.get_file_creation_number !!!!');
591:
592: END get_file_creation_no;
593:

Line 590: hr_utility.trace('Ending pay_ca_rules.get_file_creation_number !!!!');

586: l_bg_id) ;
587: END IF;
588:
589: hr_utility.trace('file_no = ' || file_no);
590: hr_utility.trace('Ending pay_ca_rules.get_file_creation_number !!!!');
591:
592: END get_file_creation_no;
593:
594: end pay_ca_rules;