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

Line 117: hr_utility.trace('(existing) l_assactid : ' || l_assactid);

113: where act.payroll_action_id = p_info.batchid
114: and nvl(act.tax_unit_id, g_number) = nvl(l_tax_unit_id, g_number)
115: and act.assignment_id = p_info.asgid;
116:
117: hr_utility.trace('(existing) l_assactid : ' || l_assactid);
118:
119: return(l_assactid);
120:
121: exception when no_data_found then

Line 138: hr_utility.set_location('insert_assact', 20);

134: ,p_run_type_id => run_type_id
135: );
136:
137: -- Get the action id of that created.
138: hr_utility.set_location('insert_assact', 20);
139: select act.assignment_action_id
140: into l_assactid
141: from pay_assignment_actions act
142: where act.payroll_action_id = p_info.batchid

Line 146: hr_utility.trace('(new) l_assactid : ' || l_assactid);

142: where act.payroll_action_id = p_info.batchid
143: and act.assignment_id = p_info.asgid
144: and nvl(act.tax_unit_id, g_number) = nvl(l_tax_unit_id, g_number);
145:
146: hr_utility.trace('(new) l_assactid : ' || l_assactid);
147:
148: update pay_assignment_actions
149: set chunk_number = g_curr_chunk_no
150: where assignment_action_id= l_assactid;

Line 218: hr_utility.trace('batchid : ' || g_info.batchid);

214: g_info.batch_mode := l_mode;
215: g_info.action_type:= l_action_type;
216:
217: -- Output information the first time round.
218: hr_utility.trace('batchid : ' || g_info.batchid);
219: hr_utility.trace('effdate : ' || fnd_date.date_to_canonical(l_info.effdate));
220: hr_utility.trace('busgrpid : ' || g_info.busgrpid);
221: hr_utility.trace('asgid : ' || g_info.asgid);
222: hr_utility.trace('mode : ' || g_info.batch_mode);

Line 219: hr_utility.trace('effdate : ' || fnd_date.date_to_canonical(l_info.effdate));

215: g_info.action_type:= l_action_type;
216:
217: -- Output information the first time round.
218: hr_utility.trace('batchid : ' || g_info.batchid);
219: hr_utility.trace('effdate : ' || fnd_date.date_to_canonical(l_info.effdate));
220: hr_utility.trace('busgrpid : ' || g_info.busgrpid);
221: hr_utility.trace('asgid : ' || g_info.asgid);
222: hr_utility.trace('mode : ' || g_info.batch_mode);
223: hr_utility.trace('acttype : ' || g_info.action_type);

Line 220: hr_utility.trace('busgrpid : ' || g_info.busgrpid);

216:
217: -- Output information the first time round.
218: hr_utility.trace('batchid : ' || g_info.batchid);
219: hr_utility.trace('effdate : ' || fnd_date.date_to_canonical(l_info.effdate));
220: hr_utility.trace('busgrpid : ' || g_info.busgrpid);
221: hr_utility.trace('asgid : ' || g_info.asgid);
222: hr_utility.trace('mode : ' || g_info.batch_mode);
223: hr_utility.trace('acttype : ' || g_info.action_type);
224:

Line 221: hr_utility.trace('asgid : ' || g_info.asgid);

217: -- Output information the first time round.
218: hr_utility.trace('batchid : ' || g_info.batchid);
219: hr_utility.trace('effdate : ' || fnd_date.date_to_canonical(l_info.effdate));
220: hr_utility.trace('busgrpid : ' || g_info.busgrpid);
221: hr_utility.trace('asgid : ' || g_info.asgid);
222: hr_utility.trace('mode : ' || g_info.batch_mode);
223: hr_utility.trace('acttype : ' || g_info.action_type);
224:
225: end if;

Line 222: hr_utility.trace('mode : ' || g_info.batch_mode);

218: hr_utility.trace('batchid : ' || g_info.batchid);
219: hr_utility.trace('effdate : ' || fnd_date.date_to_canonical(l_info.effdate));
220: hr_utility.trace('busgrpid : ' || g_info.busgrpid);
221: hr_utility.trace('asgid : ' || g_info.asgid);
222: hr_utility.trace('mode : ' || g_info.batch_mode);
223: hr_utility.trace('acttype : ' || g_info.action_type);
224:
225: end if;
226:

Line 223: hr_utility.trace('acttype : ' || g_info.action_type);

219: hr_utility.trace('effdate : ' || fnd_date.date_to_canonical(l_info.effdate));
220: hr_utility.trace('busgrpid : ' || g_info.busgrpid);
221: hr_utility.trace('asgid : ' || g_info.asgid);
222: hr_utility.trace('mode : ' || g_info.batch_mode);
223: hr_utility.trace('acttype : ' || g_info.action_type);
224:
225: end if;
226:
227: l_info := g_info;

Line 270: hr_utility.trace('batchid : ' || p_info.batchid);

266: or nvl(g_info.runtypeid, g_number) <> nvl(run_type_id, g_number)
267: or nvl(g_info.tax_unit_id, g_number) <> nvl(p_tax_unit_id, g_number)
268: ) then
269:
270: hr_utility.trace('batchid : ' || p_info.batchid);
271:
272: g_info.asgid := p_assignment_id;
273: g_info.runtypeid := run_type_id;
274: g_info.tax_unit_id := p_tax_unit_id;

Line 281: hr_utility.trace('assignment_id : ' || p_assignment_id);

277: -- May need to insert an assignment action.
278: g_info.assactid := insert_assact(g_info, p_element_entry_id,run_type_id);
279:
280: -- Output information first time round.
281: hr_utility.trace('assignment_id : ' || p_assignment_id);
282: hr_utility.trace('business_group_id : ' || g_info.busgrpid);
283: hr_utility.trace('assignment_action_id : ' || g_info.assactid);
284: hr_utility.trace('run_type_id : ' || g_info.runtypeid);
285:

Line 282: hr_utility.trace('business_group_id : ' || g_info.busgrpid);

278: g_info.assactid := insert_assact(g_info, p_element_entry_id,run_type_id);
279:
280: -- Output information first time round.
281: hr_utility.trace('assignment_id : ' || p_assignment_id);
282: hr_utility.trace('business_group_id : ' || g_info.busgrpid);
283: hr_utility.trace('assignment_action_id : ' || g_info.assactid);
284: hr_utility.trace('run_type_id : ' || g_info.runtypeid);
285:
286: end if;

Line 283: hr_utility.trace('assignment_action_id : ' || g_info.assactid);

279:
280: -- Output information first time round.
281: hr_utility.trace('assignment_id : ' || p_assignment_id);
282: hr_utility.trace('business_group_id : ' || g_info.busgrpid);
283: hr_utility.trace('assignment_action_id : ' || g_info.assactid);
284: hr_utility.trace('run_type_id : ' || g_info.runtypeid);
285:
286: end if;
287:

Line 284: hr_utility.trace('run_type_id : ' || g_info.runtypeid);

280: -- Output information first time round.
281: hr_utility.trace('assignment_id : ' || p_assignment_id);
282: hr_utility.trace('business_group_id : ' || g_info.busgrpid);
283: hr_utility.trace('assignment_action_id : ' || g_info.assactid);
284: hr_utility.trace('run_type_id : ' || g_info.runtypeid);
285:
286: end if;
287:
288: -- Return the information.

Line 333: hr_utility.set_location('Entering: '||l_proc, 5);

329: and p_effective_date between ptp.start_date
330: and ptp.end_date;
331:
332: begin
333: hr_utility.set_location('Entering: '||l_proc, 5);
334:
335: -- Get the business group from consolidation set
336: -- and validate at same time.
337: -- Also check that payroll_id passed in is valid.

Line 391: hr_utility.trace('batch_id : ' || l_payroll_action_id);

387: 1,
388: l_time_period_id,
389: sysdate);
390:
391: hr_utility.trace('batch_id : ' || l_payroll_action_id);
392:
393: -- Crude validation of modes.
394: if(p_batch_mode not in ('STANDARD', 'NO_COMMIT')) then
395: ff_utils.assert(false, 'init_batch:1');

Line 398: hr_utility.set_location('Leaving: '||l_proc, 100);

394: if(p_batch_mode not in ('STANDARD', 'NO_COMMIT')) then
395: ff_utils.assert(false, 'init_batch:1');
396: end if;
397:
398: hr_utility.set_location('Leaving: '||l_proc, 100);
399: --
400: return(l_payroll_action_id);
401:
402: end init_batch;

Line 620: hr_utility.set_location(l_proc, 70);

616: l_info := get_batch_info(p_batch_id);
617: l_effective_date := trunc(l_info.effdate);
618: l_effective_start_date := l_effective_date;
619:
620: hr_utility.set_location(l_proc, 70);
621:
622: -- can't justify why this is used yet
623: /*
624: OPEN c_entry_exists;

Line 629: hr_utility.set_location(l_proc, 80);

625: FETCH c_entry_exists
626: INTO l_dummy;
627: IF c_entry_exists%FOUND THEN
628: CLOSE c_entry_exists;
629: hr_utility.set_location(l_proc, 80);
630: hr_utility.set_message(801,'HR_7455_PLK_ELE_ENTRY_EXISTS');
631: hr_utility.raise_error;
632: END IF;
633: CLOSE c_entry_exists;

Line 630: hr_utility.set_message(801,'HR_7455_PLK_ELE_ENTRY_EXISTS');

626: INTO l_dummy;
627: IF c_entry_exists%FOUND THEN
628: CLOSE c_entry_exists;
629: hr_utility.set_location(l_proc, 80);
630: hr_utility.set_message(801,'HR_7455_PLK_ELE_ENTRY_EXISTS');
631: hr_utility.raise_error;
632: END IF;
633: CLOSE c_entry_exists;
634: */

Line 631: hr_utility.raise_error;

627: IF c_entry_exists%FOUND THEN
628: CLOSE c_entry_exists;
629: hr_utility.set_location(l_proc, 80);
630: hr_utility.set_message(801,'HR_7455_PLK_ELE_ENTRY_EXISTS');
631: hr_utility.raise_error;
632: END IF;
633: CLOSE c_entry_exists;
634: */
635: hr_utility.set_location(l_proc, 90);

Line 635: hr_utility.set_location(l_proc, 90);

631: hr_utility.raise_error;
632: END IF;
633: CLOSE c_entry_exists;
634: */
635: hr_utility.set_location(l_proc, 90);
636: OPEN c_element_info;
637: FETCH c_element_info
638: INTO l_closed_for_entry_flag,
639: l_process_in_run_flag,

Line 650: hr_utility.set_location(l_proc, 95);

646: l_costable_type;
647:
648: IF c_element_info%NOTFOUND THEN
649: CLOSE c_element_info;
650: hr_utility.set_location(l_proc, 95);
651: hr_utility.set_message(801,'HR_6132_ELE_ENTRY_LINK_MISSING');
652: hr_utility.raise_error;
653: END IF;
654: CLOSE c_element_info;

Line 651: hr_utility.set_message(801,'HR_6132_ELE_ENTRY_LINK_MISSING');

647:
648: IF c_element_info%NOTFOUND THEN
649: CLOSE c_element_info;
650: hr_utility.set_location(l_proc, 95);
651: hr_utility.set_message(801,'HR_6132_ELE_ENTRY_LINK_MISSING');
652: hr_utility.raise_error;
653: END IF;
654: CLOSE c_element_info;
655: --

Line 652: hr_utility.raise_error;

648: IF c_element_info%NOTFOUND THEN
649: CLOSE c_element_info;
650: hr_utility.set_location(l_proc, 95);
651: hr_utility.set_message(801,'HR_6132_ELE_ENTRY_LINK_MISSING');
652: hr_utility.raise_error;
653: END IF;
654: CLOSE c_element_info;
655: --
656: hr_utility.set_location(l_proc, 100);

Line 656: hr_utility.set_location(l_proc, 100);

652: hr_utility.raise_error;
653: END IF;
654: CLOSE c_element_info;
655: --
656: hr_utility.set_location(l_proc, 100);
657: OPEN c_assignment_details;
658: FETCH c_assignment_details
659: INTO l_period_status;
660: --

Line 667: hr_utility.set_location(l_proc, 110);

663: CLOSE c_assignment_details;
664:
665: IF l_closed_for_entry_flag = 'Y' THEN
666:
667: hr_utility.set_location(l_proc, 110);
668: hr_utility.set_message(801,'HR_6064_ELE_ENTRY_CLOSED_ELE');
669: hr_utility.raise_error;
670:
671: -- Error will not be raised for VERTEX, Workers Compensation element with

Line 668: hr_utility.set_message(801,'HR_6064_ELE_ENTRY_CLOSED_ELE');

664:
665: IF l_closed_for_entry_flag = 'Y' THEN
666:
667: hr_utility.set_location(l_proc, 110);
668: hr_utility.set_message(801,'HR_6064_ELE_ENTRY_CLOSED_ELE');
669: hr_utility.raise_error;
670:
671: -- Error will not be raised for VERTEX, Workers Compensation element with
672: -- Legislation code as US. Bug No 506819

Line 669: hr_utility.raise_error;

665: IF l_closed_for_entry_flag = 'Y' THEN
666:
667: hr_utility.set_location(l_proc, 110);
668: hr_utility.set_message(801,'HR_6064_ELE_ENTRY_CLOSED_ELE');
669: hr_utility.raise_error;
670:
671: -- Error will not be raised for VERTEX, Workers Compensation element with
672: -- Legislation code as US. Bug No 506819
673:

Line 678: hr_utility.set_location(l_proc, 120);

674: ELSIF (l_period_status = 'C' AND l_process_in_run_flag = 'Y'
675: AND l_element_name not in ('US_TAX_VERTEX','VERTEX','Workers Compensation')
676: AND l_legislation_code <> 'US') THEN
677:
678: hr_utility.set_location(l_proc, 120);
679: hr_utility.set_message(801,'HR_6074_ELE_ENTRY_CLOSE_PERIOD');
680: hr_utility.raise_error;
681:
682: --

Line 679: hr_utility.set_message(801,'HR_6074_ELE_ENTRY_CLOSE_PERIOD');

675: AND l_element_name not in ('US_TAX_VERTEX','VERTEX','Workers Compensation')
676: AND l_legislation_code <> 'US') THEN
677:
678: hr_utility.set_location(l_proc, 120);
679: hr_utility.set_message(801,'HR_6074_ELE_ENTRY_CLOSE_PERIOD');
680: hr_utility.raise_error;
681:
682: --
683: -- Bugfix 2665492

Line 680: hr_utility.raise_error;

676: AND l_legislation_code <> 'US') THEN
677:
678: hr_utility.set_location(l_proc, 120);
679: hr_utility.set_message(801,'HR_6074_ELE_ENTRY_CLOSE_PERIOD');
680: hr_utility.raise_error;
681:
682: --
683: -- Bugfix 2665492
684: -- Ensure that element_link is costable if cost_allocation_keyflex_id

Line 689: hr_utility.set_location(l_proc,130);

685: -- is not null
686: --
687: ELSIF l_costable_type = 'N' and p_cost_allocation_keyflex_id IS NOT NULL THEN
688: --
689: hr_utility.set_location(l_proc,130);
690: hr_utility.set_message(801,'HR_7453_PLK_NON_COSTABLE_ELE');
691: hr_utility.set_warning;
692: --
693: END IF;

Line 690: hr_utility.set_message(801,'HR_7453_PLK_NON_COSTABLE_ELE');

686: --
687: ELSIF l_costable_type = 'N' and p_cost_allocation_keyflex_id IS NOT NULL THEN
688: --
689: hr_utility.set_location(l_proc,130);
690: hr_utility.set_message(801,'HR_7453_PLK_NON_COSTABLE_ELE');
691: hr_utility.set_warning;
692: --
693: END IF;
694:

Line 691: hr_utility.set_warning;

687: ELSIF l_costable_type = 'N' and p_cost_allocation_keyflex_id IS NOT NULL THEN
688: --
689: hr_utility.set_location(l_proc,130);
690: hr_utility.set_message(801,'HR_7453_PLK_NON_COSTABLE_ELE');
691: hr_utility.set_warning;
692: --
693: END IF;
694:
695: hr_entry.return_qualifying_conditions (p_assignment_id,

Line 702: hr_utility.set_message(801, 'HR_ELE_ENTRY_QUAL_LOS');

698: l_date_on_which_time_served_ok,
699: l_date_on_which_old_enough );
700:
701: IF l_effective_date < l_date_on_which_time_served_ok THEN
702: hr_utility.set_message(801, 'HR_ELE_ENTRY_QUAL_LOS');
703: hr_utility.set_warning;
704: ELSIF l_effective_date < l_date_on_which_old_enough THEN
705: hr_utility.set_message(801, 'HR_ELE_ENTRY_QUAL_AGE');
706: hr_utility.set_warning;

Line 703: hr_utility.set_warning;

699: l_date_on_which_old_enough );
700:
701: IF l_effective_date < l_date_on_which_time_served_ok THEN
702: hr_utility.set_message(801, 'HR_ELE_ENTRY_QUAL_LOS');
703: hr_utility.set_warning;
704: ELSIF l_effective_date < l_date_on_which_old_enough THEN
705: hr_utility.set_message(801, 'HR_ELE_ENTRY_QUAL_AGE');
706: hr_utility.set_warning;
707: END IF;

Line 705: hr_utility.set_message(801, 'HR_ELE_ENTRY_QUAL_AGE');

701: IF l_effective_date < l_date_on_which_time_served_ok THEN
702: hr_utility.set_message(801, 'HR_ELE_ENTRY_QUAL_LOS');
703: hr_utility.set_warning;
704: ELSIF l_effective_date < l_date_on_which_old_enough THEN
705: hr_utility.set_message(801, 'HR_ELE_ENTRY_QUAL_AGE');
706: hr_utility.set_warning;
707: END IF;
708:
709:

Line 706: hr_utility.set_warning;

702: hr_utility.set_message(801, 'HR_ELE_ENTRY_QUAL_LOS');
703: hr_utility.set_warning;
704: ELSIF l_effective_date < l_date_on_which_old_enough THEN
705: hr_utility.set_message(801, 'HR_ELE_ENTRY_QUAL_AGE');
706: hr_utility.set_warning;
707: END IF;
708:
709:
710: hr_utility.set_location(l_proc, 350);

Line 710: hr_utility.set_location(l_proc, 350);

706: hr_utility.set_warning;
707: END IF;
708:
709:
710: hr_utility.set_location(l_proc, 350);
711: hr_entry_api.insert_element_entry
712: (
713: p_effective_start_date => l_effective_start_date,
714: p_effective_end_date => l_effective_end_date,

Line 801: IF hr_utility.check_warning THEN

797: else
798: l_rr_sparse_jc :=FALSE;
799: end if;
800: --
801: IF hr_utility.check_warning THEN
802: l_create_warning := TRUE;
803: hr_utility.clear_warning;
804: END IF;
805: --

Line 803: hr_utility.clear_warning;

799: end if;
800: --
801: IF hr_utility.check_warning THEN
802: l_create_warning := TRUE;
803: hr_utility.clear_warning;
804: END IF;
805: --
806: -- Set all output arguments
807: --

Line 875: hr_utility.trace(' exception information ');

871: --
872: purge_batch_info;
873:
874: -- Output some final information about the error.
875: hr_utility.trace('** exception information **');
876: hr_utility.trace('l_info.batchid : ' || l_info.batchid);
877: hr_utility.trace('l_info.assactid : ' || l_info.assactid);
878: hr_utility.trace('l_info.payid : ' || l_info.payid);
879: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);

Line 876: hr_utility.trace('l_info.batchid : ' || l_info.batchid);

872: purge_batch_info;
873:
874: -- Output some final information about the error.
875: hr_utility.trace('** exception information **');
876: hr_utility.trace('l_info.batchid : ' || l_info.batchid);
877: hr_utility.trace('l_info.assactid : ' || l_info.assactid);
878: hr_utility.trace('l_info.payid : ' || l_info.payid);
879: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);
880: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);

Line 877: hr_utility.trace('l_info.assactid : ' || l_info.assactid);

873:
874: -- Output some final information about the error.
875: hr_utility.trace('** exception information **');
876: hr_utility.trace('l_info.batchid : ' || l_info.batchid);
877: hr_utility.trace('l_info.assactid : ' || l_info.assactid);
878: hr_utility.trace('l_info.payid : ' || l_info.payid);
879: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);
880: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);
881: hr_utility.trace('l_element_entry_id : ' || l_element_entry_id);

Line 878: hr_utility.trace('l_info.payid : ' || l_info.payid);

874: -- Output some final information about the error.
875: hr_utility.trace('** exception information **');
876: hr_utility.trace('l_info.batchid : ' || l_info.batchid);
877: hr_utility.trace('l_info.assactid : ' || l_info.assactid);
878: hr_utility.trace('l_info.payid : ' || l_info.payid);
879: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);
880: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);
881: hr_utility.trace('l_element_entry_id : ' || l_element_entry_id);
882: hr_utility.trace('l_object_version_number : ' || l_object_version_number);

Line 879: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);

875: hr_utility.trace('** exception information **');
876: hr_utility.trace('l_info.batchid : ' || l_info.batchid);
877: hr_utility.trace('l_info.assactid : ' || l_info.assactid);
878: hr_utility.trace('l_info.payid : ' || l_info.payid);
879: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);
880: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);
881: hr_utility.trace('l_element_entry_id : ' || l_element_entry_id);
882: hr_utility.trace('l_object_version_number : ' || l_object_version_number);
883:

Line 880: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);

876: hr_utility.trace('l_info.batchid : ' || l_info.batchid);
877: hr_utility.trace('l_info.assactid : ' || l_info.assactid);
878: hr_utility.trace('l_info.payid : ' || l_info.payid);
879: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);
880: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);
881: hr_utility.trace('l_element_entry_id : ' || l_element_entry_id);
882: hr_utility.trace('l_object_version_number : ' || l_object_version_number);
883:
884: raise;

Line 881: hr_utility.trace('l_element_entry_id : ' || l_element_entry_id);

877: hr_utility.trace('l_info.assactid : ' || l_info.assactid);
878: hr_utility.trace('l_info.payid : ' || l_info.payid);
879: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);
880: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);
881: hr_utility.trace('l_element_entry_id : ' || l_element_entry_id);
882: hr_utility.trace('l_object_version_number : ' || l_object_version_number);
883:
884: raise;
885: end adjust_balance;

Line 882: hr_utility.trace('l_object_version_number : ' || l_object_version_number);

878: hr_utility.trace('l_info.payid : ' || l_info.payid);
879: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);
880: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);
881: hr_utility.trace('l_element_entry_id : ' || l_element_entry_id);
882: hr_utility.trace('l_object_version_number : ' || l_object_version_number);
883:
884: raise;
885: end adjust_balance;
886: procedure adjust_balance

Line 1164: hr_utility.trace(' exception information ');

1160: --
1161: purge_batch_info;
1162:
1163: -- Output some final information about the error.
1164: hr_utility.trace('** exception information **');
1165: hr_utility.trace('l_info.batchid : ' || l_info.batchid);
1166: hr_utility.trace('l_info.effdate : ' || l_info.effdate);
1167: hr_utility.trace('l_info.assactid : ' || l_info.assactid);
1168: hr_utility.trace('l_info.payid : ' || l_info.payid);

Line 1165: hr_utility.trace('l_info.batchid : ' || l_info.batchid);

1161: purge_batch_info;
1162:
1163: -- Output some final information about the error.
1164: hr_utility.trace('** exception information **');
1165: hr_utility.trace('l_info.batchid : ' || l_info.batchid);
1166: hr_utility.trace('l_info.effdate : ' || l_info.effdate);
1167: hr_utility.trace('l_info.assactid : ' || l_info.assactid);
1168: hr_utility.trace('l_info.payid : ' || l_info.payid);
1169: hr_utility.trace('l_info.batch_mode : ' || l_info.batch_mode);

Line 1166: hr_utility.trace('l_info.effdate : ' || l_info.effdate);

1162:
1163: -- Output some final information about the error.
1164: hr_utility.trace('** exception information **');
1165: hr_utility.trace('l_info.batchid : ' || l_info.batchid);
1166: hr_utility.trace('l_info.effdate : ' || l_info.effdate);
1167: hr_utility.trace('l_info.assactid : ' || l_info.assactid);
1168: hr_utility.trace('l_info.payid : ' || l_info.payid);
1169: hr_utility.trace('l_info.batch_mode : ' || l_info.batch_mode);
1170: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);

Line 1167: hr_utility.trace('l_info.assactid : ' || l_info.assactid);

1163: -- Output some final information about the error.
1164: hr_utility.trace('** exception information **');
1165: hr_utility.trace('l_info.batchid : ' || l_info.batchid);
1166: hr_utility.trace('l_info.effdate : ' || l_info.effdate);
1167: hr_utility.trace('l_info.assactid : ' || l_info.assactid);
1168: hr_utility.trace('l_info.payid : ' || l_info.payid);
1169: hr_utility.trace('l_info.batch_mode : ' || l_info.batch_mode);
1170: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);
1171: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);

Line 1168: hr_utility.trace('l_info.payid : ' || l_info.payid);

1164: hr_utility.trace('** exception information **');
1165: hr_utility.trace('l_info.batchid : ' || l_info.batchid);
1166: hr_utility.trace('l_info.effdate : ' || l_info.effdate);
1167: hr_utility.trace('l_info.assactid : ' || l_info.assactid);
1168: hr_utility.trace('l_info.payid : ' || l_info.payid);
1169: hr_utility.trace('l_info.batch_mode : ' || l_info.batch_mode);
1170: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);
1171: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);
1172: hr_utility.trace('l_element_entry_id : ' || l_element_entry_id);

Line 1169: hr_utility.trace('l_info.batch_mode : ' || l_info.batch_mode);

1165: hr_utility.trace('l_info.batchid : ' || l_info.batchid);
1166: hr_utility.trace('l_info.effdate : ' || l_info.effdate);
1167: hr_utility.trace('l_info.assactid : ' || l_info.assactid);
1168: hr_utility.trace('l_info.payid : ' || l_info.payid);
1169: hr_utility.trace('l_info.batch_mode : ' || l_info.batch_mode);
1170: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);
1171: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);
1172: hr_utility.trace('l_element_entry_id : ' || l_element_entry_id);
1173: hr_utility.trace('l_object_version_number : ' || l_object_version_number);

Line 1170: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);

1166: hr_utility.trace('l_info.effdate : ' || l_info.effdate);
1167: hr_utility.trace('l_info.assactid : ' || l_info.assactid);
1168: hr_utility.trace('l_info.payid : ' || l_info.payid);
1169: hr_utility.trace('l_info.batch_mode : ' || l_info.batch_mode);
1170: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);
1171: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);
1172: hr_utility.trace('l_element_entry_id : ' || l_element_entry_id);
1173: hr_utility.trace('l_object_version_number : ' || l_object_version_number);
1174:

Line 1171: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);

1167: hr_utility.trace('l_info.assactid : ' || l_info.assactid);
1168: hr_utility.trace('l_info.payid : ' || l_info.payid);
1169: hr_utility.trace('l_info.batch_mode : ' || l_info.batch_mode);
1170: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);
1171: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);
1172: hr_utility.trace('l_element_entry_id : ' || l_element_entry_id);
1173: hr_utility.trace('l_object_version_number : ' || l_object_version_number);
1174:
1175: raise;

Line 1172: hr_utility.trace('l_element_entry_id : ' || l_element_entry_id);

1168: hr_utility.trace('l_info.payid : ' || l_info.payid);
1169: hr_utility.trace('l_info.batch_mode : ' || l_info.batch_mode);
1170: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);
1171: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);
1172: hr_utility.trace('l_element_entry_id : ' || l_element_entry_id);
1173: hr_utility.trace('l_object_version_number : ' || l_object_version_number);
1174:
1175: raise;
1176:

Line 1173: hr_utility.trace('l_object_version_number : ' || l_object_version_number);

1169: hr_utility.trace('l_info.batch_mode : ' || l_info.batch_mode);
1170: hr_utility.trace('l_effective_start_date : ' || l_effective_start_date);
1171: hr_utility.trace('l_effective_end_date : ' || l_effective_end_date);
1172: hr_utility.trace('l_element_entry_id : ' || l_element_entry_id);
1173: hr_utility.trace('l_object_version_number : ' || l_object_version_number);
1174:
1175: raise;
1176:
1177: end adjust_balance;

Line 1211: hr_utility.trace('batchid : ' || l_info.batchid);

1207:
1208: -- See if batch can be processed.
1209: l_info := get_batch_info(p_batch_id);
1210:
1211: hr_utility.trace('batchid : ' || l_info.batchid);
1212: hr_utility.trace('effdate : ' || fnd_date.date_to_canonical(l_info.effdate));
1213: hr_utility.trace('busgrpid : ' || l_info.busgrpid);
1214: hr_utility.trace('mode : ' || l_info.batch_mode);
1215:

Line 1212: hr_utility.trace('effdate : ' || fnd_date.date_to_canonical(l_info.effdate));

1208: -- See if batch can be processed.
1209: l_info := get_batch_info(p_batch_id);
1210:
1211: hr_utility.trace('batchid : ' || l_info.batchid);
1212: hr_utility.trace('effdate : ' || fnd_date.date_to_canonical(l_info.effdate));
1213: hr_utility.trace('busgrpid : ' || l_info.busgrpid);
1214: hr_utility.trace('mode : ' || l_info.batch_mode);
1215:
1216: --

Line 1213: hr_utility.trace('busgrpid : ' || l_info.busgrpid);

1209: l_info := get_batch_info(p_batch_id);
1210:
1211: hr_utility.trace('batchid : ' || l_info.batchid);
1212: hr_utility.trace('effdate : ' || fnd_date.date_to_canonical(l_info.effdate));
1213: hr_utility.trace('busgrpid : ' || l_info.busgrpid);
1214: hr_utility.trace('mode : ' || l_info.batch_mode);
1215:
1216: --
1217: -- Need to add balance adjustment support for pay_run_balances. 1st for

Line 1214: hr_utility.trace('mode : ' || l_info.batch_mode);

1210:
1211: hr_utility.trace('batchid : ' || l_info.batchid);
1212: hr_utility.trace('effdate : ' || fnd_date.date_to_canonical(l_info.effdate));
1213: hr_utility.trace('busgrpid : ' || l_info.busgrpid);
1214: hr_utility.trace('mode : ' || l_info.batch_mode);
1215:
1216: --
1217: -- Need to add balance adjustment support for pay_run_balances. 1st for
1218: -- assignment run balances then for group run balances.

Line 1257: hr_utility.trace('Asgs processed : ' || l_processed);

1253: from pay_assignment_actions act
1254: where act.payroll_action_id = l_info.batchid
1255: and act.action_status = 'C';
1256:
1257: hr_utility.trace('Asgs processed : ' || l_processed);
1258:
1259: purge_batch_info; -- any global information shut down.
1260: --
1261: -- Only commit if 'STANDARD' processing mode.

Line 1263: hr_utility.trace('STANDARD mode : COMMIT');

1259: purge_batch_info; -- any global information shut down.
1260: --
1261: -- Only commit if 'STANDARD' processing mode.
1262: if(l_info.batch_mode = 'STANDARD') then
1263: hr_utility.trace('STANDARD mode : COMMIT');
1264: commit;
1265: end if;
1266:
1267: exception

Line 1270: hr_utility.set_location(l_proc, 30);

1266:
1267: exception
1268: when others then
1269: --
1270: hr_utility.set_location(l_proc, 30);
1271: --
1272: rollback to process_batch;
1273: purge_batch_info;
1274: raise;

Line 1614: hr_utility.trace('l_formula_id : ' || l_formula_id);

1610: where element_type_id =p_ele_type
1611: and processing_rule='B'
1612: and p_effdate between effective_start_date and effective_end_date;
1613:
1614: hr_utility.trace('l_formula_id : ' || l_formula_id);
1615:
1616: -- init formula
1617: ff_exec.init_formula(l_formula_id, p_effdate, v_inputs, v_outputs);
1618:

Line 1626: hr_utility.trace('input name : ' || inp_name);

1622: -- Set up the inputs and contexts to formula.
1623: for i in v_inputs.first..v_inputs.last loop
1624: inp_name:=v_inputs(i).name;
1625: -- see if equivalent entry value
1626: hr_utility.trace('input name : ' || inp_name);
1627:
1628: begin
1629: select ee.screen_entry_value
1630: into inp_value

Line 1640: hr_utility.trace('input value : ' || inp_value);

1636: and p_effdate between iv.effective_start_date and iv.effective_end_date
1637: and p_effdate between ee.effective_start_date and ee.effective_end_date;
1638:
1639: v_inputs(i).value:=inp_value;
1640: hr_utility.trace('input value : ' || inp_value);
1641:
1642: exception
1643: when no_data_found then
1644: -- see if context

Line 1664: hr_utility.trace('output name : ' || out_name);

1660:
1661: out_name:=v_outputs(i).name;
1662: out_value:=v_outputs(i).value;
1663:
1664: hr_utility.trace('output name : ' || out_name);
1665: hr_utility.trace('output value : ' || out_value);
1666:
1667: for outputs in form_outputs(p_ele_type,p_effdate,l_formula_id,out_name)
1668: loop

Line 1665: hr_utility.trace('output value : ' || out_value);

1661: out_name:=v_outputs(i).name;
1662: out_value:=v_outputs(i).value;
1663:
1664: hr_utility.trace('output name : ' || out_name);
1665: hr_utility.trace('output value : ' || out_value);
1666:
1667: for outputs in form_outputs(p_ele_type,p_effdate,l_formula_id,out_name)
1668: loop
1669: hr_utility.trace('input_value_id: ' || to_char(outputs.input_value_id));

Line 1669: hr_utility.trace('input_value_id: ' || to_char(outputs.input_value_id));

1665: hr_utility.trace('output value : ' || out_value);
1666:
1667: for outputs in form_outputs(p_ele_type,p_effdate,l_formula_id,out_name)
1668: loop
1669: hr_utility.trace('input_value_id: ' || to_char(outputs.input_value_id));
1670: hr_utility.trace('result_rule_type: ' || outputs.result_rule_type);
1671: hr_utility.trace('severity level: ' || outputs.severity_level);
1672:
1673:

Line 1670: hr_utility.trace('result_rule_type: ' || outputs.result_rule_type);

1666:
1667: for outputs in form_outputs(p_ele_type,p_effdate,l_formula_id,out_name)
1668: loop
1669: hr_utility.trace('input_value_id: ' || to_char(outputs.input_value_id));
1670: hr_utility.trace('result_rule_type: ' || outputs.result_rule_type);
1671: hr_utility.trace('severity level: ' || outputs.severity_level);
1672:
1673:
1674: if (outputs.result_rule_type='M' and out_value is not NULL)

Line 1671: hr_utility.trace('severity level: ' || outputs.severity_level);

1667: for outputs in form_outputs(p_ele_type,p_effdate,l_formula_id,out_name)
1668: loop
1669: hr_utility.trace('input_value_id: ' || to_char(outputs.input_value_id));
1670: hr_utility.trace('result_rule_type: ' || outputs.result_rule_type);
1671: hr_utility.trace('severity level: ' || outputs.severity_level);
1672:
1673:
1674: if (outputs.result_rule_type='M' and out_value is not NULL)
1675: then

Line 1689: hr_utility.set_message(801, 'HR_51120_HRPROC_ERR_OCC_ON_FML');

1685: from ff_formulas_f
1686: where formula_id = l_formula_id
1687: and p_effdate between effective_start_date and effective_end_date;
1688:
1689: hr_utility.set_message(801, 'HR_51120_HRPROC_ERR_OCC_ON_FML');
1690: hr_utility.set_message_token('FMLANAME',l_formula_name);
1691: hr_utility.raise_error;
1692: end if;
1693: --

Line 1690: hr_utility.set_message_token('FMLANAME',l_formula_name);

1686: where formula_id = l_formula_id
1687: and p_effdate between effective_start_date and effective_end_date;
1688:
1689: hr_utility.set_message(801, 'HR_51120_HRPROC_ERR_OCC_ON_FML');
1690: hr_utility.set_message_token('FMLANAME',l_formula_name);
1691: hr_utility.raise_error;
1692: end if;
1693: --
1694: elsif (outputs.result_rule_type = 'D' and out_value is not null ) then

Line 1691: hr_utility.raise_error;

1687: and p_effdate between effective_start_date and effective_end_date;
1688:
1689: hr_utility.set_message(801, 'HR_51120_HRPROC_ERR_OCC_ON_FML');
1690: hr_utility.set_message_token('FMLANAME',l_formula_name);
1691: hr_utility.raise_error;
1692: end if;
1693: --
1694: elsif (outputs.result_rule_type = 'D' and out_value is not null ) then
1695: --

Line 1823: hr_utility.trace('l_entry_id : ' || l_entry_id);

1819:
1820:
1821: -- create ele_entry
1822: create_ee(p_ele_type,p_busgrpid,p_effdate,p_legcode,p_assignment_action_id,p_assignment_id,l_entry_id,p_balcostflg,p_costkflx_id);
1823: hr_utility.trace('l_entry_id : ' || l_entry_id);
1824:
1825: -- calc jur code name
1826: pay_core_utils.get_leg_context_iv_name
1827: ('JURISDICTION_CODE',