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

Line 10: g_debug boolean := hr_utility.debug_enabled;

6:
7: This function is used to indicate whether the POG functionality
8: is enabled for a localisation.
9: */
10: g_debug boolean := hr_utility.debug_enabled;
11: function is_pog_enable(p_bgp_id in number)
12: return boolean
13: is
14: --

Line 22: hr_utility.trace('In is_pog_enable()');

18: --
19: begin
20: --
21: if g_debug then
22: hr_utility.trace('In is_pog_enable()');
23: end if;
24: select pbg.legislation_code
25: into l_leg_code
26: from per_business_groups_perf pbg

Line 46: hr_utility.trace('Out is_pog_enable()');

42: return TRUE;
43: end if;
44: --
45: if g_debug then
46: hr_utility.trace('Out is_pog_enable()');
47: end if;
48: end is_pog_enable;
49: --
50: /*

Line 64: hr_utility.trace('In get_group_definition()');

60: l_definition_id number;
61: begin
62: --
63: if g_debug then
64: hr_utility.trace('In get_group_definition()');
65: end if;
66: select group_definition_id
67: into l_definition_id
68: from pay_group_definitions

Line 109: hr_utility.trace('Out get_group_definition()');

105: return l_definition_id;
106: end;
107: --
108: if g_debug then
109: hr_utility.trace('Out get_group_definition()');
110: end if;
111: end get_group_definition;
112: --
113: /*

Line 136: hr_utility.trace('In get_assignment_group()');

132: l_cnt number;
133: begin
134: --
135: if g_debug then
136: hr_utility.trace('In get_assignment_group()');
137: hr_utility.trace('p_person_group_id ' || p_person_group_id );
138: hr_utility.trace('p_assignment_id ' || p_assignment_id );
139: hr_utility.trace('p_effective_start_date ' || p_effective_start_date );
140: hr_utility.trace('p_effective_end_date ' || p_effective_end_date );

Line 137: hr_utility.trace('p_person_group_id ' || p_person_group_id );

133: begin
134: --
135: if g_debug then
136: hr_utility.trace('In get_assignment_group()');
137: hr_utility.trace('p_person_group_id ' || p_person_group_id );
138: hr_utility.trace('p_assignment_id ' || p_assignment_id );
139: hr_utility.trace('p_effective_start_date ' || p_effective_start_date );
140: hr_utility.trace('p_effective_end_date ' || p_effective_end_date );
141: hr_utility.trace('p_payroll_id ' || p_payroll_id );

Line 138: hr_utility.trace('p_assignment_id ' || p_assignment_id );

134: --
135: if g_debug then
136: hr_utility.trace('In get_assignment_group()');
137: hr_utility.trace('p_person_group_id ' || p_person_group_id );
138: hr_utility.trace('p_assignment_id ' || p_assignment_id );
139: hr_utility.trace('p_effective_start_date ' || p_effective_start_date );
140: hr_utility.trace('p_effective_end_date ' || p_effective_end_date );
141: hr_utility.trace('p_payroll_id ' || p_payroll_id );
142: hr_utility.trace('p_update_row ' || p_update_row );

Line 139: hr_utility.trace('p_effective_start_date ' || p_effective_start_date );

135: if g_debug then
136: hr_utility.trace('In get_assignment_group()');
137: hr_utility.trace('p_person_group_id ' || p_person_group_id );
138: hr_utility.trace('p_assignment_id ' || p_assignment_id );
139: hr_utility.trace('p_effective_start_date ' || p_effective_start_date );
140: hr_utility.trace('p_effective_end_date ' || p_effective_end_date );
141: hr_utility.trace('p_payroll_id ' || p_payroll_id );
142: hr_utility.trace('p_update_row ' || p_update_row );
143: end if;

Line 140: hr_utility.trace('p_effective_end_date ' || p_effective_end_date );

136: hr_utility.trace('In get_assignment_group()');
137: hr_utility.trace('p_person_group_id ' || p_person_group_id );
138: hr_utility.trace('p_assignment_id ' || p_assignment_id );
139: hr_utility.trace('p_effective_start_date ' || p_effective_start_date );
140: hr_utility.trace('p_effective_end_date ' || p_effective_end_date );
141: hr_utility.trace('p_payroll_id ' || p_payroll_id );
142: hr_utility.trace('p_update_row ' || p_update_row );
143: end if;
144:

Line 141: hr_utility.trace('p_payroll_id ' || p_payroll_id );

137: hr_utility.trace('p_person_group_id ' || p_person_group_id );
138: hr_utility.trace('p_assignment_id ' || p_assignment_id );
139: hr_utility.trace('p_effective_start_date ' || p_effective_start_date );
140: hr_utility.trace('p_effective_end_date ' || p_effective_end_date );
141: hr_utility.trace('p_payroll_id ' || p_payroll_id );
142: hr_utility.trace('p_update_row ' || p_update_row );
143: end if;
144:
145: --Bug 14585781 case c

Line 142: hr_utility.trace('p_update_row ' || p_update_row );

138: hr_utility.trace('p_assignment_id ' || p_assignment_id );
139: hr_utility.trace('p_effective_start_date ' || p_effective_start_date );
140: hr_utility.trace('p_effective_end_date ' || p_effective_end_date );
141: hr_utility.trace('p_payroll_id ' || p_payroll_id );
142: hr_utility.trace('p_update_row ' || p_update_row );
143: end if;
144:
145: --Bug 14585781 case c
146: --changed the start/end date boundary condition check

Line 191: hr_utility.trace('Inserting into POG with ');

187: into l_object_group_id
188: from dual;
189: --
190: if g_debug then
191: hr_utility.trace('Inserting into POG with ');
192: hr_utility.trace('Object_group_id ' || l_object_group_id );
193: hr_utility.trace('p_effective_start_date ' || p_effective_start_date );
194: hr_utility.trace('p_effective_start_date ' || p_effective_end_date );
195: end if;

Line 192: hr_utility.trace('Object_group_id ' || l_object_group_id );

188: from dual;
189: --
190: if g_debug then
191: hr_utility.trace('Inserting into POG with ');
192: hr_utility.trace('Object_group_id ' || l_object_group_id );
193: hr_utility.trace('p_effective_start_date ' || p_effective_start_date );
194: hr_utility.trace('p_effective_start_date ' || p_effective_end_date );
195: end if;
196: insert into pay_object_groups

Line 193: hr_utility.trace('p_effective_start_date ' || p_effective_start_date );

189: --
190: if g_debug then
191: hr_utility.trace('Inserting into POG with ');
192: hr_utility.trace('Object_group_id ' || l_object_group_id );
193: hr_utility.trace('p_effective_start_date ' || p_effective_start_date );
194: hr_utility.trace('p_effective_start_date ' || p_effective_end_date );
195: end if;
196: insert into pay_object_groups
197: (object_group_id,

Line 194: hr_utility.trace('p_effective_start_date ' || p_effective_end_date );

190: if g_debug then
191: hr_utility.trace('Inserting into POG with ');
192: hr_utility.trace('Object_group_id ' || l_object_group_id );
193: hr_utility.trace('p_effective_start_date ' || p_effective_start_date );
194: hr_utility.trace('p_effective_start_date ' || p_effective_end_date );
195: end if;
196: insert into pay_object_groups
197: (object_group_id,
198: source_id,

Line 225: hr_utility.trace('Out get_assignment_group()');

221: --
222:
223: --
224: if g_debug then
225: hr_utility.trace('Out get_assignment_group()');
226: end if;
227: end get_assignment_group;
228: --
229: /*

Line 256: hr_utility.trace('In get_person_group()');

252: l_upd_end_date date;
253: begin
254: --
255: if g_debug then
256: hr_utility.trace('In get_person_group()');
257: end if;
258: l_definition_id := get_group_definition(p_definition_name);
259: --
260: select object_group_id,

Line 279: hr_utility.trace('p_update_row = '|| p_update_row);

275: -- Ensure that the object group dates
276: -- are correct
277: --
278: if g_debug then
279: hr_utility.trace('p_update_row = '|| p_update_row);
280: hr_utility.trace('l_start_date = '|| l_start_date);
281: hr_utility.trace('p_effective_start_date = '|| p_effective_start_date);
282: hr_utility.trace('l_end_date = '|| l_end_date);
283: hr_utility.trace(' p_effective_end_date = '|| p_effective_end_date);

Line 280: hr_utility.trace('l_start_date = '|| l_start_date);

276: -- are correct
277: --
278: if g_debug then
279: hr_utility.trace('p_update_row = '|| p_update_row);
280: hr_utility.trace('l_start_date = '|| l_start_date);
281: hr_utility.trace('p_effective_start_date = '|| p_effective_start_date);
282: hr_utility.trace('l_end_date = '|| l_end_date);
283: hr_utility.trace(' p_effective_end_date = '|| p_effective_end_date);
284: end if;

Line 281: hr_utility.trace('p_effective_start_date = '|| p_effective_start_date);

277: --
278: if g_debug then
279: hr_utility.trace('p_update_row = '|| p_update_row);
280: hr_utility.trace('l_start_date = '|| l_start_date);
281: hr_utility.trace('p_effective_start_date = '|| p_effective_start_date);
282: hr_utility.trace('l_end_date = '|| l_end_date);
283: hr_utility.trace(' p_effective_end_date = '|| p_effective_end_date);
284: end if;
285: if (p_update_row = 'Y') then

Line 282: hr_utility.trace('l_end_date = '|| l_end_date);

278: if g_debug then
279: hr_utility.trace('p_update_row = '|| p_update_row);
280: hr_utility.trace('l_start_date = '|| l_start_date);
281: hr_utility.trace('p_effective_start_date = '|| p_effective_start_date);
282: hr_utility.trace('l_end_date = '|| l_end_date);
283: hr_utility.trace(' p_effective_end_date = '|| p_effective_end_date);
284: end if;
285: if (p_update_row = 'Y') then
286: if (l_start_date > p_effective_start_date) then

Line 283: hr_utility.trace(' p_effective_end_date = '|| p_effective_end_date);

279: hr_utility.trace('p_update_row = '|| p_update_row);
280: hr_utility.trace('l_start_date = '|| l_start_date);
281: hr_utility.trace('p_effective_start_date = '|| p_effective_start_date);
282: hr_utility.trace('l_end_date = '|| l_end_date);
283: hr_utility.trace(' p_effective_end_date = '|| p_effective_end_date);
284: end if;
285: if (p_update_row = 'Y') then
286: if (l_start_date > p_effective_start_date) then
287: l_update := TRUE;

Line 300: hr_utility.trace('object group id = '|| l_object_group_id);

296: l_upd_end_date := l_end_date;
297: end if;
298: if (l_update = TRUE) then
299: if g_debug then
300: hr_utility.trace('object group id = '|| l_object_group_id);
301: hr_utility.trace('start date = '|| l_upd_start_date);
302: hr_utility.trace('end date = '|| l_upd_end_date);
303: end if;
304: update pay_object_groups

Line 301: hr_utility.trace('start date = '|| l_upd_start_date);

297: end if;
298: if (l_update = TRUE) then
299: if g_debug then
300: hr_utility.trace('object group id = '|| l_object_group_id);
301: hr_utility.trace('start date = '|| l_upd_start_date);
302: hr_utility.trace('end date = '|| l_upd_end_date);
303: end if;
304: update pay_object_groups
305: set start_date = l_upd_start_date,

Line 302: hr_utility.trace('end date = '|| l_upd_end_date);

298: if (l_update = TRUE) then
299: if g_debug then
300: hr_utility.trace('object group id = '|| l_object_group_id);
301: hr_utility.trace('start date = '|| l_upd_start_date);
302: hr_utility.trace('end date = '|| l_upd_end_date);
303: end if;
304: update pay_object_groups
305: set start_date = l_upd_start_date,
306: end_date = l_upd_end_date

Line 351: hr_utility.trace('Out get_person_group()');

347: --
348:
349: --
350: if g_debug then
351: hr_utility.trace('Out get_person_group()');
352: end if;
353: end get_person_group;
354: --
355: /*

Line 377: hr_utility.trace('In evaluate_asg_group()');

373: l_rows integer;
374: begin
375: --
376: if g_debug then
377: hr_utility.trace('In evaluate_asg_group()');
378: end if;
379: select distinct legislation_code, paf.business_group_id
380: into l_leg_code, l_bg_id
381: from per_business_groups_perf pbg,

Line 433: hr_utility.trace('Out evaluate_asg_group()');

429: ('pay_asg_process_grp_pkg.evaluate_asg_group:2',
430: p_group_name is not null);
431: --
432: if g_debug then
433: hr_utility.trace('Out evaluate_asg_group()');
434: end if;
435: end evaluate_asg_group;
436: --
437: /*

Line 459: hr_utility.trace('In generate_asg_group()');

455: l_asg_group_id pay_object_groups.object_group_id%type;
456: begin
457: --
458: if g_debug then
459: hr_utility.trace('In generate_asg_group()');
460: end if;
461:
462: if (p_payroll_id is not null) then
463: --

Line 487: hr_utility.trace('Out generate_asg_group()');

483: --
484: end if;
485: --
486: if g_debug then
487: hr_utility.trace('Out generate_asg_group()');
488: end if;
489: end generate_asg_group;
490: --
491: /*

Line 511: hr_utility.trace('In asg_datetracked_insert()');

507: is
508: begin
509: --
510: if g_debug then
511: hr_utility.trace('In asg_datetracked_insert()');
512: end if;
513: generate_asg_group(p_assignment_id,
514: p_person_id,
515: p_period_of_service_id,

Line 522: hr_utility.trace('Out asg_datetracked_insert()');

518: p_payroll_id
519: );
520: --
521: if g_debug then
522: hr_utility.trace('Out asg_datetracked_insert()');
523: end if;
524: end asg_datetracked_insert;
525: --
526: /*

Line 543: hr_utility.trace('In zap_object_group()');

539: l_cnt number;
540: begin
541: --
542: if g_debug then
543: hr_utility.trace('In zap_object_group()');
544: end if;
545: select parent_object_group_id
546: into l_parent_object_group_id
547: from pay_object_groups

Line 571: hr_utility.trace('Out zap_object_group()');

567: delete from pay_object_groups
568: where object_group_id = p_object_group_id;
569: --
570: if g_debug then
571: hr_utility.trace('Out zap_object_group()');
572: end if;
573: end zap_object_group;
574: --
575: /*

Line 589: hr_utility.trace('In end_date_object_group()');

585: is
586: begin
587: --
588: if g_debug then
589: hr_utility.trace('In end_date_object_group()');
590: hr_utility.trace('Object group id = '|| p_object_group_id);
591: hr_utility.trace('Effective date = '|| p_effective_end_date);
592: end if;
593: update pay_object_groups

Line 590: hr_utility.trace('Object group id = '|| p_object_group_id);

586: begin
587: --
588: if g_debug then
589: hr_utility.trace('In end_date_object_group()');
590: hr_utility.trace('Object group id = '|| p_object_group_id);
591: hr_utility.trace('Effective date = '|| p_effective_end_date);
592: end if;
593: update pay_object_groups
594: set end_date = p_effective_end_date

Line 591: hr_utility.trace('Effective date = '|| p_effective_end_date);

587: --
588: if g_debug then
589: hr_utility.trace('In end_date_object_group()');
590: hr_utility.trace('Object group id = '|| p_object_group_id);
591: hr_utility.trace('Effective date = '|| p_effective_end_date);
592: end if;
593: update pay_object_groups
594: set end_date = p_effective_end_date
595: where object_group_id = p_object_group_id;

Line 598: hr_utility.trace('Out end_date_object_group()');

594: set end_date = p_effective_end_date
595: where object_group_id = p_object_group_id;
596: --
597: if g_debug then
598: hr_utility.trace('Out end_date_object_group()');
599: end if;
600: end end_date_object_group;
601: --
602: /*

Line 640: hr_utility.trace('In asg_datetracked_delete_next()');

636: and pog_paf.end_date = p_effective_end_date_o;
637: begin
638: --
639: if g_debug then
640: hr_utility.trace('In asg_datetracked_delete_next()');
641: end if;
642: for pogrec in get_pogpaf(p_assignment_id, p_effective_end_date_o) loop
643: --
644: if g_debug then

Line 645: hr_utility.trace('Object group id = '|| pogrec.object_group_id);

641: end if;
642: for pogrec in get_pogpaf(p_assignment_id, p_effective_end_date_o) loop
643: --
644: if g_debug then
645: hr_utility.trace('Object group id = '|| pogrec.object_group_id);
646: hr_utility.trace('Effective date = '|| p_effective_end_date);
647: hr_utility.trace('p_effective_end_date_o = ' || p_effective_end_date_o);
648: end if;
649: update pay_object_groups

Line 646: hr_utility.trace('Effective date = '|| p_effective_end_date);

642: for pogrec in get_pogpaf(p_assignment_id, p_effective_end_date_o) loop
643: --
644: if g_debug then
645: hr_utility.trace('Object group id = '|| pogrec.object_group_id);
646: hr_utility.trace('Effective date = '|| p_effective_end_date);
647: hr_utility.trace('p_effective_end_date_o = ' || p_effective_end_date_o);
648: end if;
649: update pay_object_groups
650: set end_date = p_val_end_date --Bug 14585781 ,Case delete_next/future

Line 647: hr_utility.trace('p_effective_end_date_o = ' || p_effective_end_date_o);

643: --
644: if g_debug then
645: hr_utility.trace('Object group id = '|| pogrec.object_group_id);
646: hr_utility.trace('Effective date = '|| p_effective_end_date);
647: hr_utility.trace('p_effective_end_date_o = ' || p_effective_end_date_o);
648: end if;
649: update pay_object_groups
650: set end_date = p_val_end_date --Bug 14585781 ,Case delete_next/future
651: where object_group_id = pogrec.object_group_id;

Line 664: hr_utility.trace('Object group id = '|| ppfrec.object_group_id);

660: p_effective_end_date_o)
661: loop
662: --
663: if g_debug then
664: hr_utility.trace('Object group id = '|| ppfrec.object_group_id);
665: hr_utility.trace('Effective date = '|| p_effective_end_date);
666: end if;
667: update pay_object_groups
668: set end_date = p_effective_end_date

Line 665: hr_utility.trace('Effective date = '|| p_effective_end_date);

661: loop
662: --
663: if g_debug then
664: hr_utility.trace('Object group id = '|| ppfrec.object_group_id);
665: hr_utility.trace('Effective date = '|| p_effective_end_date);
666: end if;
667: update pay_object_groups
668: set end_date = p_effective_end_date
669: where object_group_id = ppfrec.object_group_id;

Line 678: hr_utility.trace('In asg_datetracked_delete_next()');

674: --
675:
676: --
677: if g_debug then
678: hr_utility.trace('In asg_datetracked_delete_next()');
679: end if;
680: end asg_datetracked_delete_next;
681: --
682: /*

Line 710: hr_utility.trace('In asg_datetracked_end_date()');

706: --
707: -- OK the assignment has ended, we need to end all the
708: -- POG PAFs that the assignment has.
709: if g_debug then
710: hr_utility.trace('In asg_datetracked_end_date()');
711: end if;
712: for pafrec in get_pogpaf(p_assignment_id, p_effective_end_date) loop
713: --
714: if g_debug then

Line 715: hr_utility.trace('pafrec.start_date ' || pafrec.start_date);

711: end if;
712: for pafrec in get_pogpaf(p_assignment_id, p_effective_end_date) loop
713: --
714: if g_debug then
715: hr_utility.trace('pafrec.start_date ' || pafrec.start_date);
716: hr_utility.trace('p_effective_end_date ' || p_effective_end_date);
717: end if;
718: if (pafrec.start_date > p_effective_end_date) then
719: zap_object_group(pafrec.object_group_id);

Line 716: hr_utility.trace('p_effective_end_date ' || p_effective_end_date);

712: for pafrec in get_pogpaf(p_assignment_id, p_effective_end_date) loop
713: --
714: if g_debug then
715: hr_utility.trace('pafrec.start_date ' || pafrec.start_date);
716: hr_utility.trace('p_effective_end_date ' || p_effective_end_date);
717: end if;
718: if (pafrec.start_date > p_effective_end_date) then
719: zap_object_group(pafrec.object_group_id);
720: else

Line 728: hr_utility.trace('Out asg_datetracked_end_date()');

724: --
725: end loop;
726: --
727: if g_debug then
728: hr_utility.trace('Out asg_datetracked_end_date()');
729: end if;
730: end asg_datetracked_end_date;
731: --
732: /*

Line 747: hr_utility.trace('In find_asg_group_definition()');

743: is
744: begin
745: --
746: if g_debug then
747: hr_utility.trace('In find_asg_group_definition()');
748: end if;
749: select pgd.name
750: into p_definition_name
751: from pay_group_definitions pgd,

Line 763: hr_utility.trace('Out find_asg_group_definition()');

759: and pog_paf.parent_object_group_id = pog_ppf.object_group_id
760: and pog_ppf.group_definition_id = pgd.group_definition_id;
761: --
762: if g_debug then
763: hr_utility.trace('Out find_asg_group_definition()');
764: end if;
765: end find_asg_group_definition;
766: --
767: -- start of Bug 14585781

Line 805: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

801: --Now Zap the object group since the change is in Correction Mode and there is no further payroll
802: zap_object_group(l_object_group_id);
803: exception
804: when NO_DATA_FOUND then
805: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
806: hr_utility.set_message_token('PROCEDURE',
807: 'pay_asg_process_grp_pkg.asg_datetracked_correction');
808: hr_utility.set_message_token('STEP','1');
809: hr_utility.raise_error;

Line 806: hr_utility.set_message_token('PROCEDURE',

802: zap_object_group(l_object_group_id);
803: exception
804: when NO_DATA_FOUND then
805: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
806: hr_utility.set_message_token('PROCEDURE',
807: 'pay_asg_process_grp_pkg.asg_datetracked_correction');
808: hr_utility.set_message_token('STEP','1');
809: hr_utility.raise_error;
810: end purge_curr_obj_group;

Line 808: hr_utility.set_message_token('STEP','1');

804: when NO_DATA_FOUND then
805: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
806: hr_utility.set_message_token('PROCEDURE',
807: 'pay_asg_process_grp_pkg.asg_datetracked_correction');
808: hr_utility.set_message_token('STEP','1');
809: hr_utility.raise_error;
810: end purge_curr_obj_group;
811:
812: begin

Line 809: hr_utility.raise_error;

805: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
806: hr_utility.set_message_token('PROCEDURE',
807: 'pay_asg_process_grp_pkg.asg_datetracked_correction');
808: hr_utility.set_message_token('STEP','1');
809: hr_utility.raise_error;
810: end purge_curr_obj_group;
811:
812: begin
813: if g_debug then

Line 814: hr_utility.trace('In asg_datetracked_correction()');

810: end purge_curr_obj_group;
811:
812: begin
813: if g_debug then
814: hr_utility.trace('In asg_datetracked_correction()');
815: end if;
816: if ( p_old_payroll_id is null
817: and p_new_payroll_id is null) then
818: --

Line 874: hr_utility.trace('Out asg_datetracked_correction()');

870: );
871:
872: end if;
873: if g_debug then
874: hr_utility.trace('Out asg_datetracked_correction()');
875: end if;
876: end asg_datetracked_correction;
877:
878: --End of Bug 14585781

Line 904: hr_utility.trace('In asg_datetracked_update()');

900: l_new_group_name pay_group_definitions.name%type;
901: begin
902: --
903: if g_debug then
904: hr_utility.trace('In asg_datetracked_update()');
905: end if;
906: if ( p_old_payroll_id is null
907: and p_new_payroll_id is null) then
908: --

Line 948: hr_utility.trace ('location X old group id = '||l_old_group_name||' new gr id = '||l_new_group_name);

944: p_new_effective_end_date,
945: l_new_group_name
946: );
947: if g_debug then
948: hr_utility.trace ('location X old group id = '||l_old_group_name||' new gr id = '||l_new_group_name);
949: hr_utility.trace ('p_assignment_id = '||p_assignment_id);
950: hr_utility.trace ('p_person_id = '||p_person_id);
951: hr_utility.trace ('p_period_of_service_id = '||p_period_of_service_id);
952: hr_utility.trace ('p_new_effective_start_date = '||p_new_effective_start_date);

Line 949: hr_utility.trace ('p_assignment_id = '||p_assignment_id);

945: l_new_group_name
946: );
947: if g_debug then
948: hr_utility.trace ('location X old group id = '||l_old_group_name||' new gr id = '||l_new_group_name);
949: hr_utility.trace ('p_assignment_id = '||p_assignment_id);
950: hr_utility.trace ('p_person_id = '||p_person_id);
951: hr_utility.trace ('p_period_of_service_id = '||p_period_of_service_id);
952: hr_utility.trace ('p_new_effective_start_date = '||p_new_effective_start_date);
953: hr_utility.trace ('p_new_effective_end_date = '||p_new_effective_end_date);

Line 950: hr_utility.trace ('p_person_id = '||p_person_id);

946: );
947: if g_debug then
948: hr_utility.trace ('location X old group id = '||l_old_group_name||' new gr id = '||l_new_group_name);
949: hr_utility.trace ('p_assignment_id = '||p_assignment_id);
950: hr_utility.trace ('p_person_id = '||p_person_id);
951: hr_utility.trace ('p_period_of_service_id = '||p_period_of_service_id);
952: hr_utility.trace ('p_new_effective_start_date = '||p_new_effective_start_date);
953: hr_utility.trace ('p_new_effective_end_date = '||p_new_effective_end_date);
954: hr_utility.trace ('p_new_payroll_id = '||p_new_payroll_id);

Line 951: hr_utility.trace ('p_period_of_service_id = '||p_period_of_service_id);

947: if g_debug then
948: hr_utility.trace ('location X old group id = '||l_old_group_name||' new gr id = '||l_new_group_name);
949: hr_utility.trace ('p_assignment_id = '||p_assignment_id);
950: hr_utility.trace ('p_person_id = '||p_person_id);
951: hr_utility.trace ('p_period_of_service_id = '||p_period_of_service_id);
952: hr_utility.trace ('p_new_effective_start_date = '||p_new_effective_start_date);
953: hr_utility.trace ('p_new_effective_end_date = '||p_new_effective_end_date);
954: hr_utility.trace ('p_new_payroll_id = '||p_new_payroll_id);
955: end if;

Line 952: hr_utility.trace ('p_new_effective_start_date = '||p_new_effective_start_date);

948: hr_utility.trace ('location X old group id = '||l_old_group_name||' new gr id = '||l_new_group_name);
949: hr_utility.trace ('p_assignment_id = '||p_assignment_id);
950: hr_utility.trace ('p_person_id = '||p_person_id);
951: hr_utility.trace ('p_period_of_service_id = '||p_period_of_service_id);
952: hr_utility.trace ('p_new_effective_start_date = '||p_new_effective_start_date);
953: hr_utility.trace ('p_new_effective_end_date = '||p_new_effective_end_date);
954: hr_utility.trace ('p_new_payroll_id = '||p_new_payroll_id);
955: end if;
956: if (l_old_group_name <> l_new_group_name) then

Line 953: hr_utility.trace ('p_new_effective_end_date = '||p_new_effective_end_date);

949: hr_utility.trace ('p_assignment_id = '||p_assignment_id);
950: hr_utility.trace ('p_person_id = '||p_person_id);
951: hr_utility.trace ('p_period_of_service_id = '||p_period_of_service_id);
952: hr_utility.trace ('p_new_effective_start_date = '||p_new_effective_start_date);
953: hr_utility.trace ('p_new_effective_end_date = '||p_new_effective_end_date);
954: hr_utility.trace ('p_new_payroll_id = '||p_new_payroll_id);
955: end if;
956: if (l_old_group_name <> l_new_group_name) then
957: generate_asg_group(p_assignment_id,

Line 954: hr_utility.trace ('p_new_payroll_id = '||p_new_payroll_id);

950: hr_utility.trace ('p_person_id = '||p_person_id);
951: hr_utility.trace ('p_period_of_service_id = '||p_period_of_service_id);
952: hr_utility.trace ('p_new_effective_start_date = '||p_new_effective_start_date);
953: hr_utility.trace ('p_new_effective_end_date = '||p_new_effective_end_date);
954: hr_utility.trace ('p_new_payroll_id = '||p_new_payroll_id);
955: end if;
956: if (l_old_group_name <> l_new_group_name) then
957: generate_asg_group(p_assignment_id,
958: p_person_id,

Line 990: hr_utility.trace('Out asg_datetracked_update()');

986:
987: end if;
988: --
989: if g_debug then
990: hr_utility.trace('Out asg_datetracked_update()');
991: end if;
992: end asg_datetracked_update;
993: --
994: /*

Line 1018: hr_utility.trace('In asg_datetracked_strt_early()');

1014: l_new_effective_start_date DATE;
1015: begin
1016: --
1017: if g_debug then
1018: hr_utility.trace('In asg_datetracked_strt_early()');
1019: hr_utility.trace('Start date = '|| p_new_effective_start_date);
1020: hr_utility.trace('Source id = '|| p_assignment_id);
1021: hr_utility.trace('Old start date = '|| p_old_effective_start_date);
1022: end if;

Line 1019: hr_utility.trace('Start date = '|| p_new_effective_start_date);

1015: begin
1016: --
1017: if g_debug then
1018: hr_utility.trace('In asg_datetracked_strt_early()');
1019: hr_utility.trace('Start date = '|| p_new_effective_start_date);
1020: hr_utility.trace('Source id = '|| p_assignment_id);
1021: hr_utility.trace('Old start date = '|| p_old_effective_start_date);
1022: end if;
1023: update pay_object_groups

Line 1020: hr_utility.trace('Source id = '|| p_assignment_id);

1016: --
1017: if g_debug then
1018: hr_utility.trace('In asg_datetracked_strt_early()');
1019: hr_utility.trace('Start date = '|| p_new_effective_start_date);
1020: hr_utility.trace('Source id = '|| p_assignment_id);
1021: hr_utility.trace('Old start date = '|| p_old_effective_start_date);
1022: end if;
1023: update pay_object_groups
1024: set start_date = p_new_effective_start_date

Line 1021: hr_utility.trace('Old start date = '|| p_old_effective_start_date);

1017: if g_debug then
1018: hr_utility.trace('In asg_datetracked_strt_early()');
1019: hr_utility.trace('Start date = '|| p_new_effective_start_date);
1020: hr_utility.trace('Source id = '|| p_assignment_id);
1021: hr_utility.trace('Old start date = '|| p_old_effective_start_date);
1022: end if;
1023: update pay_object_groups
1024: set start_date = p_new_effective_start_date
1025: where source_id = p_assignment_id

Line 1051: hr_utility.trace('Out asg_datetracked_strt_early()');

1047: end;
1048: --end of bug 12696936
1049: --
1050: if g_debug then
1051: hr_utility.trace('Out asg_datetracked_strt_early()');
1052: end if;
1053: end asg_datetracked_strt_early;
1054:
1055: --start of bug 12696936

Line 1081: hr_utility.trace('In asg_datetracked_strt_later()');

1077: l_new_effective_start_date DATE;
1078: begin
1079: --
1080: if g_debug then
1081: hr_utility.trace('In asg_datetracked_strt_later()');
1082: hr_utility.trace('Start date = '|| p_new_effective_start_date);
1083: hr_utility.trace('Source id = '|| p_assignment_id);
1084: hr_utility.trace('Old start date = '|| p_old_effective_start_date);
1085: end if;

Line 1082: hr_utility.trace('Start date = '|| p_new_effective_start_date);

1078: begin
1079: --
1080: if g_debug then
1081: hr_utility.trace('In asg_datetracked_strt_later()');
1082: hr_utility.trace('Start date = '|| p_new_effective_start_date);
1083: hr_utility.trace('Source id = '|| p_assignment_id);
1084: hr_utility.trace('Old start date = '|| p_old_effective_start_date);
1085: end if;
1086: update pay_object_groups

Line 1083: hr_utility.trace('Source id = '|| p_assignment_id);

1079: --
1080: if g_debug then
1081: hr_utility.trace('In asg_datetracked_strt_later()');
1082: hr_utility.trace('Start date = '|| p_new_effective_start_date);
1083: hr_utility.trace('Source id = '|| p_assignment_id);
1084: hr_utility.trace('Old start date = '|| p_old_effective_start_date);
1085: end if;
1086: update pay_object_groups
1087: set start_date = p_new_effective_start_date

Line 1084: hr_utility.trace('Old start date = '|| p_old_effective_start_date);

1080: if g_debug then
1081: hr_utility.trace('In asg_datetracked_strt_later()');
1082: hr_utility.trace('Start date = '|| p_new_effective_start_date);
1083: hr_utility.trace('Source id = '|| p_assignment_id);
1084: hr_utility.trace('Old start date = '|| p_old_effective_start_date);
1085: end if;
1086: update pay_object_groups
1087: set start_date = p_new_effective_start_date
1088: where source_id = p_assignment_id

Line 1114: hr_utility.trace('Out asg_datetracked_strt_later()');

1110: end;
1111:
1112: --
1113: if g_debug then
1114: hr_utility.trace('Out asg_datetracked_strt_later()');
1115: end if;
1116: end asg_datetracked_strt_later;
1117:
1118: --end of bug 12696936

Line 1153: hr_utility.trace('In asg_datetracked_ovrr_update()');

1149: --Bug 14585781,changed the cur,Case C
1150: begin
1151: --
1152: if g_debug then
1153: hr_utility.trace('In asg_datetracked_ovrr_update()');
1154: end if;
1155: asg_datetracked_update(p_assignment_id,
1156: p_person_id,
1157: p_period_of_service_id,

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

1166: -- Any POG_PAF that starts after the new start date
1167: -- then they must be removed as a they have been
1168: -- overriden
1169: if g_debug then
1170: hr_utility.trace(' p_new_effective_start_date '|| p_new_effective_start_date);
1171: hr_utility.trace('p_new_effective_end_date '|| p_new_effective_end_date);
1172: end if;
1173: for pafrec in get_pogpaf(p_assignment_id, p_new_effective_end_date) loop
1174: -- Bug 14585781, changed below condition,Case C

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

1167: -- then they must be removed as a they have been
1168: -- overriden
1169: if g_debug then
1170: hr_utility.trace(' p_new_effective_start_date '|| p_new_effective_start_date);
1171: hr_utility.trace('p_new_effective_end_date '|| p_new_effective_end_date);
1172: end if;
1173: for pafrec in get_pogpaf(p_assignment_id, p_new_effective_end_date) loop
1174: -- Bug 14585781, changed below condition,Case C
1175: if (pafrec.start_date > p_new_effective_start_date) then

Line 1182: hr_utility.trace('Out asg_datetracked_ovrr_update()');

1178: --
1179: end loop;
1180: --
1181: if g_debug then
1182: hr_utility.trace('Out asg_datetracked_ovrr_update()');
1183: end if;
1184: end asg_datetracked_ovrr_update;
1185: --
1186: /*

Line 1208: hr_utility.trace('In asg_datetracked_zap()');

1204: and pog_paf.source_type = 'PAF';
1205: begin
1206: --
1207: if g_debug then
1208: hr_utility.trace('In asg_datetracked_zap()');
1209: end if;
1210: -- all POG_PAF for the assignment must be removed
1211: for pafrec in get_pogpaf(p_assignment_id) loop
1212: --

Line 1218: hr_utility.trace('Out asg_datetracked_zap()');

1214: --
1215: end loop;
1216: --
1217: if g_debug then
1218: hr_utility.trace('Out asg_datetracked_zap()');
1219: end if;
1220: end;
1221:
1222: /*

Line 1244: hr_utility.trace('In asg_insert_trigger()');

1240: dt_mode varchar2(20);
1241: begin
1242: --
1243: if g_debug then
1244: hr_utility.trace('In asg_insert_trigger()');
1245: end if;
1246: if (is_pog_enable(p_business_group_id) = TRUE) then
1247: asg_datetracked_insert(p_assignment_id,
1248: p_person_id,

Line 1257: hr_utility.trace('Out asg_insert_trigger()');

1253: );
1254: end if;
1255: --
1256: if g_debug then
1257: hr_utility.trace('Out asg_insert_trigger()');
1258: end if;
1259: end asg_insert_trigger;
1260:
1261: /*

Line 1286: hr_utility.trace('In asg_update_trigger()');

1282: dt_mode varchar2(20);
1283: begin
1284: --
1285: if g_debug then
1286: hr_utility.trace('In asg_update_trigger()');
1287: end if;
1288: if (is_pog_enable(p_business_group_id) = TRUE) then
1289: --
1290: -- First set the Date Track mode

Line 1294: hr_utility.trace ('Location 02 dt_mode = '||dt_mode);

1290: -- First set the Date Track mode
1291: --
1292: dt_mode := PAY_POG_ALL_ASSIGNMENTS_PKG.dyt_mode;
1293: if g_debug then
1294: hr_utility.trace ('Location 02 dt_mode = '||dt_mode);
1295: end if;
1296: --Bug 14585781 added Correction mode
1297: if ( dt_mode = 'CORRECTION') then
1298:

Line 1366: hr_utility.trace('Out asg_update_trigger()');

1362: end if;
1363: end if;
1364: --
1365: if g_debug then
1366: hr_utility.trace('Out asg_update_trigger()');
1367: end if;
1368: end asg_update_trigger;
1369: --
1370: /*

Line 1390: hr_utility.trace('In asg_delete_trigger()');

1386: dt_mode varchar2(20);
1387: begin
1388: --
1389: if g_debug then
1390: hr_utility.trace('In asg_delete_trigger()');
1391: end if;
1392: if (is_pog_enable(p_business_group_id) = TRUE) then
1393: --
1394: -- First set the Date Track mode

Line 1405: hr_utility.trace ('Asg del trig - eff date = '||p_effective_end_date);

1401: --
1402: elsif ( dt_mode = 'DELETE') then
1403: --
1404: if g_debug then
1405: hr_utility.trace ('Asg del trig - eff date = '||p_effective_end_date);
1406: end if;
1407: asg_datetracked_end_date(p_assignment_id,
1408: p_effective_end_date
1409: );

Line 1421: hr_utility.trace('Out asg_delete_trigger()');

1417: end if;
1418: end if;
1419: --
1420: if g_debug then
1421: hr_utility.trace('Out asg_delete_trigger()');
1422: end if;
1423: end asg_delete_trigger;
1424: --
1425: /*

Line 1460: hr_utility.trace('In upgrade_asg()');

1456: --
1457: begin
1458: --
1459: if g_debug then
1460: hr_utility.trace('In upgrade_asg()');
1461: end if;
1462: first_row := TRUE;
1463: for asgrec in get_asg_info(p_asg_id) loop
1464: --

Line 1514: hr_utility.trace('Out upgrade_asg()');

1510: --
1511: end loop;
1512: --
1513: if g_debug then
1514: hr_utility.trace('Out upgrade_asg()');
1515: end if;
1516: end upgrade_asg;
1517: --
1518: end pay_asg_process_grp_pkg;