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.PER_ASSIGNMENTS_F1_PKG dependencies on HR_UTILITY

Line 91: g_debug := hr_utility.debug_enabled; -- get debug status

87: WHERE pdp.person_id = l_person_id
88: AND pdp.date_start = l_pdp_date_start;
89:
90: BEGIN
91: g_debug := hr_utility.debug_enabled; -- get debug status
92: IF g_debug THEN
93: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
94: END IF;
95:

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

89:
90: BEGIN
91: g_debug := hr_utility.debug_enabled; -- get debug status
92: IF g_debug THEN
93: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
94: END IF;
95:
96: --
97: -- Fetch the desired assignment details.

Line 107: hr_utility.set_location( g_package || l_proc, 10);

103: --
104: -- Bug 3240313 starts here.
105: --
106: IF g_debug THEN
107: hr_utility.set_location( g_package || l_proc, 10);
108: END IF;
109:
110: IF csr_get_assignment_info%notfound then
111: OPEN csr_get_new_asg_info;

Line 123: hr_utility.set_location( g_package || l_proc, 20);

119: --
120: CLOSE csr_get_assignment_info;
121:
122: IF g_debug THEN
123: hr_utility.set_location( g_package || l_proc, 20);
124: END IF;
125:
126: if p_new_prim_flag = 'Y' and
127: (p_new_end_date <> p_eot and p_new_end_date is not null) then

Line 170: hr_utility.set_location( g_package || l_proc, 30);

166: -- really used at the moment.
167: --
168: IF l_assignment_type <> 'C' THEN
169: IF g_debug THEN
170: hr_utility.set_location( g_package || l_proc, 30);
171: END IF;
172:
173:
174: hr_assignment.update_primary(

Line 186: hr_utility.set_location( g_package || l_proc, 40);

182: 0);
183:
184: ELSIF l_assignment_type = 'C' THEN
185: IF g_debug THEN
186: hr_utility.set_location( g_package || l_proc, 40);
187: END IF;
188:
189:
190: hr_assignment.update_primary_cwk(

Line 206: hr_utility.set_location( 'Leaving ' ||g_package || l_proc, 50);

202:
203: p_prim_change_flag := 'N';
204: --
205: IF g_debug THEN
206: hr_utility.set_location( 'Leaving ' ||g_package || l_proc, 50);
207: END IF;
208:
209: end iud_update_primary;
210: -----------------------------------------------------------------------------

Line 251: g_debug := hr_utility.debug_enabled; -- get debug status

247: --
248: l_proc varchar2(12) := 'update_group';
249: --
250: begin
251: g_debug := hr_utility.debug_enabled; -- get debug status
252: IF g_debug THEN
253: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
254: END IF;
255:

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

249: --
250: begin
251: g_debug := hr_utility.debug_enabled; -- get debug status
252: IF g_debug THEN
253: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
254: END IF;
255:
256: if p_pg_id <> -1 then
257: --

Line 277: hr_utility.set_location( g_package || l_proc, 10);

273: c := fnd_flex_ext.breakup_segments(l_xname,l_delimiter,l_ch_seg);
274: fnd_profile.get('ICX_DATE_FORMAT_MASK',l_dateformat);
275:
276: IF g_debug THEN
277: hr_utility.set_location( g_package || l_proc, 10);
278: END IF;
279:
280: For x in c_seg(l_flexnum) loop
281:

Line 300: hr_utility.set_location( g_package || l_proc, 20);

296: -- p_group_name := l_xname;
297: end if;
298: --End of Fix 2762904
299: IF g_debug THEN
300: hr_utility.set_location( g_package || l_proc, 20);
301: END IF;
302: update pay_people_groups
303: set group_name = l_xname
304: where people_group_id = P_PG_ID

Line 325: hr_utility.set_location( 'Leaving ' || g_package || l_proc, 30);

321: */
322: end if;
323: --
324: IF g_debug THEN
325: hr_utility.set_location( 'Leaving ' || g_package || l_proc, 30);
326: END IF;
327: end update_group;
328: -----------------------------------------------------------------------------
329:

Line 368: hr_utility.set_location('Entering:'|| l_proc, 10);

364:
365: begin
366:
367: -- if g_debug then
368: hr_utility.set_location('Entering:'|| l_proc, 10);
369: -- end if;
370: --
371: -- The outer procedure has already establish that an update is
372: -- required. This sub-procedure uses an autonomous transaction

Line 393: hr_utility.set_location(l_proc, 20);

389: close csr_scl_lock;
390:
391:
392: -- if g_debug then
393: hr_utility.set_location(l_proc, 20);
394: -- end if;
395: --
396: -- Lock obtained by this transaction, updating the concatenated
397: -- segment string should be performed.

Line 422: hr_utility.set_location('Leaving:'|| l_proc, 30);

418: end if;
419:
420:
421: -- if g_debug then
422: hr_utility.set_location('Leaving:'|| l_proc, 30);
423: -- end if;
424:
425: Exception
426: When HR_Api.Object_Locked then

Line 433: hr_utility.set_location('Leaving:'|| l_proc, 40);

429: -- It can be assumed that another transaction has locked the
430: -- row and is performing the update. Hence the error can
431: -- be suppressed without raising it to the end user.
432: --
433: hr_utility.set_location('Leaving:'|| l_proc, 40);
434: end update_scl_auto;
435:
436: begin
437: --

Line 440: hr_utility.set_location('Entering:'|| l_proc, 10);

436: begin
437: --
438:
439: --if g_debug then
440: hr_utility.set_location('Entering:'|| l_proc, 10);
441: --end if;
442: --
443: -- First find out if it is necessary to update the concatenated
444: -- segment string column. This select is being done to avoid the

Line 463: hr_utility.set_location('Leaving:'|| l_proc, 20);

459: end if;
460: --
461:
462: --if g_debug then
463: hr_utility.set_location('Leaving:'|| l_proc, 20);
464: --end if;
465:
466: end update_scl;
467: -----------------------------------------------------------------------------

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

515: --
516: l_proc varchar2(16) := 'do_cancel_reterm';
517: --
518: begin
519: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
520: hrentmnt.maintain_entries_asg(
521: p_ass_id,
522: p_bg_id,
523: 'CNCL_TERM',

Line 542: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);

538: null,
539: l_entries_chng);
540: end if;
541: --
542: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);
543: end do_cancel_reterm;
544: ----------------------------------------------------------------------------
545: procedure future_del_cleanup(
546: p_ass_id number,

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

560: begin
561: --
562: -- The 2 0's are last_updated_by, last_update_login.
563: --
564: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
565: hr_assignment.del_ref_int_delete(
566: p_ass_id,
567: p_grd_id,
568: 'FUTURE',

Line 579: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);

575: l_future_spp_warning);
576:
577: p_future_spp_warnings := l_future_spp_warning;
578: --
579: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);
580: end future_del_cleanup;
581: ----------------------------------------------------------------------------
582: procedure tidy_up_ref_int(
583: p_mode varchar2,

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

599: -- 'END' and when the row is opened up using 'FUTURE_CHANGE' or
600: -- 'DELETE_NEXT_CHANGE'.
601: --
602: begin
603: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
604: l_mode := p_mode;
605: --
606: if l_mode = 'END' then
607: l_new_end_date := p_sess_date;

Line 628: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);

624: l_old_end_date,
625: 0, 0, p_cost_warning);
626: --
627:
628: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);
629: end tidy_up_ref_int;
630: ----------------------------------------------------------------------------
631: procedure terminate_entries(
632: p_per_sys_st varchar2,

Line 638: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F1_PKG.terminate_entries' , 5);

634: p_sess_date date,
635: p_val_st_date date) is
636: l_start_date date;
637: begin
638: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F1_PKG.terminate_entries' , 5);
639: if p_per_sys_st = 'END' then
640: l_start_date := p_sess_date;
641: else
642: l_start_date := p_val_st_date;

Line 662: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F1_PKG.set_end_date' , 5);

658: -- This is to ensure that assignments cannot be 'opened up' past the Period
659: -- of Service End Date.
660: --
661: begin
662: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F1_PKG.set_end_date' , 5);
663:
664: update per_assignments_f a
665: set a.effective_end_date = P_NEW_END_DATE
666: where a.assignment_id = P_ASS_ID

Line 697: hr_utility.set_location('per_assignments_f1_pkg.maintain_entries',1);

693: -- Maintain element entries for insert/update/delete
694: --
695: begin
696: --
697: hr_utility.set_location('per_assignments_f1_pkg.maintain_entries',1);
698: hr_utility.set_location('p_old_pg_id :'||to_char(p_old_pg_id),1);
699: hr_utility.set_location('p_new_pg_id :'||to_char(p_new_pg_id),1);
700:
701: if p_dt_upd_mode is null then

Line 698: hr_utility.set_location('p_old_pg_id :'||to_char(p_old_pg_id),1);

694: --
695: begin
696: --
697: hr_utility.set_location('per_assignments_f1_pkg.maintain_entries',1);
698: hr_utility.set_location('p_old_pg_id :'||to_char(p_old_pg_id),1);
699: hr_utility.set_location('p_new_pg_id :'||to_char(p_new_pg_id),1);
700:
701: if p_dt_upd_mode is null then
702: if p_dt_del_mode is null then

Line 699: hr_utility.set_location('p_new_pg_id :'||to_char(p_new_pg_id),1);

695: begin
696: --
697: hr_utility.set_location('per_assignments_f1_pkg.maintain_entries',1);
698: hr_utility.set_location('p_old_pg_id :'||to_char(p_old_pg_id),1);
699: hr_utility.set_location('p_new_pg_id :'||to_char(p_new_pg_id),1);
700:
701: if p_dt_upd_mode is null then
702: if p_dt_del_mode is null then
703: l_mode := 'INSERT';

Line 737: hr_utility.set_location('per_assignments_f1_pkg.maintain_entries',2);

733: if l_mode = 'DELETE' then
734: l_val_start_date := l_val_start_date + 1;
735: end if;
736: --
737: hr_utility.set_location('per_assignments_f1_pkg.maintain_entries',2);
738: hrentmnt.maintain_entries_asg(
739: p_ass_id,
740: p_old_pay_id,
741: p_new_pay_id,

Line 1018: hr_utility.set_location('Entering : '||l_proc,10);

1014: --
1015: ---------------------------------------------------------
1016: begin
1017: --
1018: hr_utility.set_location('Entering : '||l_proc,10);
1019: hr_utility.set_location(l_proc||' Update Mode: '||p_upd_mode,11);
1020: hr_utility.set_location(l_proc||' p_sess_date = '||p_sess_date,12);
1021: --
1022: p_warning := null;

Line 1019: hr_utility.set_location(l_proc||' Update Mode: '||p_upd_mode,11);

1015: ---------------------------------------------------------
1016: begin
1017: --
1018: hr_utility.set_location('Entering : '||l_proc,10);
1019: hr_utility.set_location(l_proc||' Update Mode: '||p_upd_mode,11);
1020: hr_utility.set_location(l_proc||' p_sess_date = '||p_sess_date,12);
1021: --
1022: p_warning := null;
1023: --

Line 1020: hr_utility.set_location(l_proc||' p_sess_date = '||p_sess_date,12);

1016: begin
1017: --
1018: hr_utility.set_location('Entering : '||l_proc,10);
1019: hr_utility.set_location(l_proc||' Update Mode: '||p_upd_mode,11);
1020: hr_utility.set_location(l_proc||' p_sess_date = '||p_sess_date,12);
1021: --
1022: p_warning := null;
1023: --
1024: -- If the assignment was updated to End Assign then value would

Line 1037: hr_utility.trace('Reentry Point is '||to_char(p_re_entry_point));

1033: l_per_sys_st := p_per_sys_st;
1034: --
1035: end if;
1036: --
1037: hr_utility.trace('Reentry Point is '||to_char(p_re_entry_point));
1038: hr_utility.trace('l_per_sys_st is '||l_per_sys_st);
1039: --
1040: if p_re_entry_point = 1 then
1041: --

Line 1038: hr_utility.trace('l_per_sys_st is '||l_per_sys_st);

1034: --
1035: end if;
1036: --
1037: hr_utility.trace('Reentry Point is '||to_char(p_re_entry_point));
1038: hr_utility.trace('l_per_sys_st is '||l_per_sys_st);
1039: --
1040: if p_re_entry_point = 1 then
1041: --
1042: goto RE_ENTRY_POINT_1;

Line 1052: hr_utility.set_location(l_proc,20);

1048: end if;
1049: --
1050: if p_prim_change_flag = 'Y' then
1051: --
1052: hr_utility.set_location(l_proc,20);
1053: --
1054: iud_update_primary( p_upd_mode,
1055: p_new_prim_flag,
1056: p_val_st_date,

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

1062: p_prim_change_flag);
1063: --
1064: end if;
1065: --
1066: hr_utility.set_location(l_proc,30);
1067: --
1068: update_group( p_new_pg_id,
1069: p_group_name,
1070: p_bg_id);

Line 1072: hr_utility.set_location(l_proc,40);

1068: update_group( p_new_pg_id,
1069: p_group_name,
1070: p_bg_id);
1071: --
1072: hr_utility.set_location(l_proc,40);
1073: --
1074: update_scl(
1075: p_scl_id,
1076: p_scl_concat);

Line 1080: hr_utility.set_location(l_proc,50);

1076: p_scl_concat);
1077: --
1078: if p_upd_mode = 'UPDATE_OVERRIDE' then
1079: --
1080: hr_utility.set_location(l_proc,50);
1081: --
1082: hr_assignment_internal.maintain_spp_asg
1083: (p_assignment_id => p_ass_id
1084: ,p_datetrack_mode => p_upd_mode

Line 1108: hr_utility.set_location(l_proc,60);

1104: p_val_end_date,
1105: p_upd_mode,
1106: l_dummy_warning);
1107: --
1108: hr_utility.set_location(l_proc,60);
1109: --
1110: --
1111: -- If datetrack mode is not UPDATE_OVERRIDE
1112: --

Line 1138: hr_utility.set_location('p_was_end_assign'||p_was_end_assign,2);

1134: -- Start of 3335915
1135: /*
1136: -- Start of Fix for Bug 2849080
1137: --
1138: hr_utility.set_location('p_was_end_assign'||p_was_end_assign,2);
1139: hr_utility.set_location('l_per_sys_st '||l_per_sys_st,2);
1140:
1141: IF (p_grd_id is not null ) and (p_grd_id = p_s_grd_id) then
1142: -- start of fix for bug 3053428

Line 1139: hr_utility.set_location('l_per_sys_st '||l_per_sys_st,2);

1135: /*
1136: -- Start of Fix for Bug 2849080
1137: --
1138: hr_utility.set_location('p_was_end_assign'||p_was_end_assign,2);
1139: hr_utility.set_location('l_per_sys_st '||l_per_sys_st,2);
1140:
1141: IF (p_grd_id is not null ) and (p_grd_id = p_s_grd_id) then
1142: -- start of fix for bug 3053428
1143: IF l_per_sys_st = 'END' then

Line 1164: hr_utility.set_location('Ass Eff dt matching ',2);

1160: CLOSE csr_spp_id;
1161: -- -- End of fix for bug 3053428
1162: ElSe
1163:
1164: hr_utility.set_location('Ass Eff dt matching ',2);
1165:
1166: OPEN csr_grade_step;
1167: FETCH csr_grade_step
1168: INTO l_placement_id,l_object_version_number,l_step_id, l_spp_end_date,l_spp_st_date;

Line 1172: hr_utility.set_location('Record Found ',2);

1168: INTO l_placement_id,l_object_version_number,l_step_id, l_spp_end_date,l_spp_st_date;
1169:
1170:
1171: IF csr_grade_step%found then
1172: hr_utility.set_location('Record Found ',2);
1173: select max(effective_end_date)
1174: into l_max_spp_date
1175: from per_spinal_point_placements_f
1176: where placement_id = l_placement_id;

Line 1178: hr_utility.set_location('PD: Max SPP End Dt '|| l_max_spp_date,2);

1174: into l_max_spp_date
1175: from per_spinal_point_placements_f
1176: where placement_id = l_placement_id;
1177:
1178: hr_utility.set_location('PD: Max SPP End Dt '|| l_max_spp_date,2);
1179: hr_utility.set_location('PD: Current SPP end dt '||l_spp_end_date,2);
1180: hr_utility.set_location('PD: Val Dt '|| p_val_st_date,2);
1181: hr_utility.set_location('PD: Current SPP st dt '||l_spp_st_date,2);
1182:

Line 1179: hr_utility.set_location('PD: Current SPP end dt '||l_spp_end_date,2);

1175: from per_spinal_point_placements_f
1176: where placement_id = l_placement_id;
1177:
1178: hr_utility.set_location('PD: Max SPP End Dt '|| l_max_spp_date,2);
1179: hr_utility.set_location('PD: Current SPP end dt '||l_spp_end_date,2);
1180: hr_utility.set_location('PD: Val Dt '|| p_val_st_date,2);
1181: hr_utility.set_location('PD: Current SPP st dt '||l_spp_st_date,2);
1182:
1183: IF (l_spp_st_date = p_val_st_date) THEN

Line 1180: hr_utility.set_location('PD: Val Dt '|| p_val_st_date,2);

1176: where placement_id = l_placement_id;
1177:
1178: hr_utility.set_location('PD: Max SPP End Dt '|| l_max_spp_date,2);
1179: hr_utility.set_location('PD: Current SPP end dt '||l_spp_end_date,2);
1180: hr_utility.set_location('PD: Val Dt '|| p_val_st_date,2);
1181: hr_utility.set_location('PD: Current SPP st dt '||l_spp_st_date,2);
1182:
1183: IF (l_spp_st_date = p_val_st_date) THEN
1184: l_datetrack_mode := 'CORRECTION';

Line 1181: hr_utility.set_location('PD: Current SPP st dt '||l_spp_st_date,2);

1177:
1178: hr_utility.set_location('PD: Max SPP End Dt '|| l_max_spp_date,2);
1179: hr_utility.set_location('PD: Current SPP end dt '||l_spp_end_date,2);
1180: hr_utility.set_location('PD: Val Dt '|| p_val_st_date,2);
1181: hr_utility.set_location('PD: Current SPP st dt '||l_spp_st_date,2);
1182:
1183: IF (l_spp_st_date = p_val_st_date) THEN
1184: l_datetrack_mode := 'CORRECTION';
1185: ELSIF (l_max_spp_date = l_spp_end_date) THEN

Line 1191: hr_utility.set_location('PD: Date Track Mode '||l_datetrack_mode,2);

1187: ELSE
1188: l_datetrack_mode := 'UPDATE_CHANGE_INSERT';
1189: END IF;
1190:
1191: hr_utility.set_location('PD: Date Track Mode '||l_datetrack_mode,2);
1192:
1193:
1194: hr_utility.set_location('Calling upadate_spp from post_update ',2);
1195: hr_utility.set_location('effective_date : '||p_val_st_date,2);

Line 1194: hr_utility.set_location('Calling upadate_spp from post_update ',2);

1190:
1191: hr_utility.set_location('PD: Date Track Mode '||l_datetrack_mode,2);
1192:
1193:
1194: hr_utility.set_location('Calling upadate_spp from post_update ',2);
1195: hr_utility.set_location('effective_date : '||p_val_st_date,2);
1196: hr_utility.set_location('datetrack_mode : '||l_datetrack_mode,2);
1197: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1198: hr_utility.set_location('OVN : '||l_object_version_number,2);

Line 1195: hr_utility.set_location('effective_date : '||p_val_st_date,2);

1191: hr_utility.set_location('PD: Date Track Mode '||l_datetrack_mode,2);
1192:
1193:
1194: hr_utility.set_location('Calling upadate_spp from post_update ',2);
1195: hr_utility.set_location('effective_date : '||p_val_st_date,2);
1196: hr_utility.set_location('datetrack_mode : '||l_datetrack_mode,2);
1197: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1198: hr_utility.set_location('OVN : '||l_object_version_number,2);
1199: hr_utility.set_location('Step Id : '||l_step_id,2);

Line 1196: hr_utility.set_location('datetrack_mode : '||l_datetrack_mode,2);

1192:
1193:
1194: hr_utility.set_location('Calling upadate_spp from post_update ',2);
1195: hr_utility.set_location('effective_date : '||p_val_st_date,2);
1196: hr_utility.set_location('datetrack_mode : '||l_datetrack_mode,2);
1197: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1198: hr_utility.set_location('OVN : '||l_object_version_number,2);
1199: hr_utility.set_location('Step Id : '||l_step_id,2);
1200: hr_utility.set_location('Effective Start date : '||l_effective_start_date,2);

Line 1197: hr_utility.set_location('placement_id : '||l_placement_id ,2);

1193:
1194: hr_utility.set_location('Calling upadate_spp from post_update ',2);
1195: hr_utility.set_location('effective_date : '||p_val_st_date,2);
1196: hr_utility.set_location('datetrack_mode : '||l_datetrack_mode,2);
1197: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1198: hr_utility.set_location('OVN : '||l_object_version_number,2);
1199: hr_utility.set_location('Step Id : '||l_step_id,2);
1200: hr_utility.set_location('Effective Start date : '||l_effective_start_date,2);
1201: hr_utility.set_location('Efective end date : '||l_effective_end_date,2);

Line 1198: hr_utility.set_location('OVN : '||l_object_version_number,2);

1194: hr_utility.set_location('Calling upadate_spp from post_update ',2);
1195: hr_utility.set_location('effective_date : '||p_val_st_date,2);
1196: hr_utility.set_location('datetrack_mode : '||l_datetrack_mode,2);
1197: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1198: hr_utility.set_location('OVN : '||l_object_version_number,2);
1199: hr_utility.set_location('Step Id : '||l_step_id,2);
1200: hr_utility.set_location('Effective Start date : '||l_effective_start_date,2);
1201: hr_utility.set_location('Efective end date : '||l_effective_end_date,2);
1202: hr_utility.set_location ('Session Date : '||p_sess_date, 2);

Line 1199: hr_utility.set_location('Step Id : '||l_step_id,2);

1195: hr_utility.set_location('effective_date : '||p_val_st_date,2);
1196: hr_utility.set_location('datetrack_mode : '||l_datetrack_mode,2);
1197: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1198: hr_utility.set_location('OVN : '||l_object_version_number,2);
1199: hr_utility.set_location('Step Id : '||l_step_id,2);
1200: hr_utility.set_location('Effective Start date : '||l_effective_start_date,2);
1201: hr_utility.set_location('Efective end date : '||l_effective_end_date,2);
1202: hr_utility.set_location ('Session Date : '||p_sess_date, 2);
1203:

Line 1200: hr_utility.set_location('Effective Start date : '||l_effective_start_date,2);

1196: hr_utility.set_location('datetrack_mode : '||l_datetrack_mode,2);
1197: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1198: hr_utility.set_location('OVN : '||l_object_version_number,2);
1199: hr_utility.set_location('Step Id : '||l_step_id,2);
1200: hr_utility.set_location('Effective Start date : '||l_effective_start_date,2);
1201: hr_utility.set_location('Efective end date : '||l_effective_end_date,2);
1202: hr_utility.set_location ('Session Date : '||p_sess_date, 2);
1203:
1204:

Line 1201: hr_utility.set_location('Efective end date : '||l_effective_end_date,2);

1197: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1198: hr_utility.set_location('OVN : '||l_object_version_number,2);
1199: hr_utility.set_location('Step Id : '||l_step_id,2);
1200: hr_utility.set_location('Effective Start date : '||l_effective_start_date,2);
1201: hr_utility.set_location('Efective end date : '||l_effective_end_date,2);
1202: hr_utility.set_location ('Session Date : '||p_sess_date, 2);
1203:
1204:
1205: hr_sp_placement_api.update_spp

Line 1202: hr_utility.set_location ('Session Date : '||p_sess_date, 2);

1198: hr_utility.set_location('OVN : '||l_object_version_number,2);
1199: hr_utility.set_location('Step Id : '||l_step_id,2);
1200: hr_utility.set_location('Effective Start date : '||l_effective_start_date,2);
1201: hr_utility.set_location('Efective end date : '||l_effective_end_date,2);
1202: hr_utility.set_location ('Session Date : '||p_sess_date, 2);
1203:
1204:
1205: hr_sp_placement_api.update_spp
1206: (p_effective_date => p_val_st_date

Line 1217: hr_utility.set_location('Call to update_SPP finished ',2);

1213:
1214:
1215:
1216:
1217: hr_utility.set_location('Call to update_SPP finished ',2);
1218:
1219: END IF;
1220: CLOSE csr_grade_step;
1221:

Line 1233: hr_utility.set_location(l_proc||'Grade ID = '||p_grd_id,70);

1229:
1230: if (p_s_grd_id <> p_grd_id) or
1231: (p_grd_id is null and p_s_grd_id is not null) then
1232: --
1233: hr_utility.set_location(l_proc||'Grade ID = '||p_grd_id,70);
1234: hr_utility.set_location(l_proc||'Asg ID = '||p_ass_id,71);
1235: hr_utility.set_location(l_proc||'Val Start Date = '||p_val_st_date,72);
1236: --
1237: -- Check that the effective date of the process is not less than the min

Line 1234: hr_utility.set_location(l_proc||'Asg ID = '||p_ass_id,71);

1230: if (p_s_grd_id <> p_grd_id) or
1231: (p_grd_id is null and p_s_grd_id is not null) then
1232: --
1233: hr_utility.set_location(l_proc||'Grade ID = '||p_grd_id,70);
1234: hr_utility.set_location(l_proc||'Asg ID = '||p_ass_id,71);
1235: hr_utility.set_location(l_proc||'Val Start Date = '||p_val_st_date,72);
1236: --
1237: -- Check that the effective date of the process is not less than the min
1238: -- effective start date for the spp record for the assignment

Line 1235: hr_utility.set_location(l_proc||'Val Start Date = '||p_val_st_date,72);

1231: (p_grd_id is null and p_s_grd_id is not null) then
1232: --
1233: hr_utility.set_location(l_proc||'Grade ID = '||p_grd_id,70);
1234: hr_utility.set_location(l_proc||'Asg ID = '||p_ass_id,71);
1235: hr_utility.set_location(l_proc||'Val Start Date = '||p_val_st_date,72);
1236: --
1237: -- Check that the effective date of the process is not less than the min
1238: -- effective start date for the spp record for the assignment
1239: -- If it is then the process will not be able to update the current step

Line 1248: hr_utility.raise_error;

1244: --
1245: if l_min_start_date > p_val_st_date then
1246: --
1247: fnd_message.set_name('PER', 'HR_289771_SPP_MIN_START_DATE');
1248: hr_utility.raise_error;
1249: --
1250: end if;
1251: --
1252: close csr_min_spp_date;

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

1250: end if;
1251: --
1252: close csr_min_spp_date;
1253: --
1254: hr_utility.set_location(l_proc,80);
1255: --
1256: hr_assignment_internal.maintain_spp_asg
1257: (p_assignment_id => p_ass_id
1258: ,p_datetrack_mode => p_upd_mode

Line 1270: hr_utility.set_location(l_proc||' RE_ENTRY_POINT_1 ',90);

1266: end if;
1267: --
1268: <>
1269: --
1270: hr_utility.set_location(l_proc||' RE_ENTRY_POINT_1 ',90);
1271: --
1272: if l_per_sys_st = 'END' then
1273: --
1274: hr_utility.set_location(l_proc,100);

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

1270: hr_utility.set_location(l_proc||' RE_ENTRY_POINT_1 ',90);
1271: --
1272: if l_per_sys_st = 'END' then
1273: --
1274: hr_utility.set_location(l_proc,100);
1275: --
1276: -- Date Effectively Delete any of the assignments' children
1277: -- records.
1278: -- The following tables are affected

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

1285: -- within this IF construct.
1286: --
1287: if p_re_entry_point = 1 then
1288: --
1289: hr_utility.set_location(l_proc,110);
1290: --
1291: goto RE_ENTRY_POINT_1a;
1292: --
1293: end if;

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

1293: end if;
1294: --
1295: l_calling_proc := 'POST_UPDATE';
1296: --
1297: hr_utility.set_location(l_proc,120);
1298: --
1299: hr_assignment.del_ref_int_delete
1300: (p_ass_id,
1301: null,

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

1308: p_val_end_date,
1309: p_upd_mode,
1310: l_future_spp_warnings);
1311: --
1312: hr_utility.set_location(l_proc,130);
1313: --
1314: p_future_spp_warning := l_future_spp_warnings;
1315: --
1316: -- NB l_cost_Warning is not set in this scenario.

Line 1336: hr_utility.set_location(l_proc,140);

1332: */
1333: --
1334: -- Fix for bug 4278579 ends here.
1335: --
1336: hr_utility.set_location(l_proc,140);
1337: --
1338: -- Pass null dt delete mode to ensure it is null.
1339: --
1340: hr_utility.set_location(l_proc,150);

Line 1340: hr_utility.set_location(l_proc,150);

1336: hr_utility.set_location(l_proc,140);
1337: --
1338: -- Pass null dt delete mode to ensure it is null.
1339: --
1340: hr_utility.set_location(l_proc,150);
1341: --
1342: maintain_entries
1343: (p_upd_mode,
1344: null,

Line 1372: hr_utility.set_location(l_proc,160);

1368: l_cost_warning);
1369: --
1370: -- Fix for bug 4278579 ends here.
1371: --
1372: hr_utility.set_location(l_proc,160);
1373: --
1374: if l_raise_warning in ('Y','S') then
1375: --
1376: hr_utility.set_location(l_proc,170);

Line 1376: hr_utility.set_location(l_proc,170);

1372: hr_utility.set_location(l_proc,160);
1373: --
1374: if l_raise_warning in ('Y','S') then
1375: --
1376: hr_utility.set_location(l_proc,170);
1377: --
1378: if l_raise_warning = 'Y' then
1379: --
1380: hr_utility.set_location(l_proc,180);

Line 1380: hr_utility.set_location(l_proc,180);

1376: hr_utility.set_location(l_proc,170);
1377: --
1378: if l_raise_warning = 'Y' then
1379: --
1380: hr_utility.set_location(l_proc,180);
1381: --
1382: p_warning := 'HR_7016_ASS_ENTRIES_CHANGED';
1383: --
1384: else

Line 1386: hr_utility.set_location(l_proc,190);

1382: p_warning := 'HR_7016_ASS_ENTRIES_CHANGED';
1383: --
1384: else
1385: --
1386: hr_utility.set_location(l_proc,190);
1387: --
1388: p_warning := 'HR_7442_ASS_SAL_ENT_CHANGED';
1389: --
1390: end if;

Line 1399: hr_utility.set_location(l_proc||' RE_ENTRY_POINT_1a ',200);

1395: end if;
1396: --
1397: <>
1398: --
1399: hr_utility.set_location(l_proc||' RE_ENTRY_POINT_1a ',200);
1400: --
1401: terminate_entries
1402: (l_per_sys_st,
1403: p_ass_id,

Line 1407: hr_utility.set_location(l_proc,210);

1403: p_ass_id,
1404: p_sess_date,
1405: p_val_st_date);
1406: --
1407: hr_utility.set_location(l_proc,210);
1408: --
1409: -- Now delete any pay proposals which have a change date
1410: -- after the end of this assignment.
1411: --

Line 1416: hr_utility.set_location(l_proc,220);

1412: delete_any_pay_proposals
1413: (p_ass_id,
1414: p_val_st_date);
1415: --
1416: hr_utility.set_location(l_proc,220);
1417: --
1418: end if; -- if l_per_sys_st = 'END'
1419: --
1420: <>

Line 1422: hr_utility.set_location(l_proc||' RE_ENTRY_POINT2 ',230);

1418: end if; -- if l_per_sys_st = 'END'
1419: --
1420: <>
1421: --
1422: hr_utility.set_location(l_proc||' RE_ENTRY_POINT2 ',230);
1423: --
1424: if l_per_sys_st <> 'END' then
1425: --
1426: hr_utility.set_location(l_proc,240);

Line 1426: hr_utility.set_location(l_proc,240);

1422: hr_utility.set_location(l_proc||' RE_ENTRY_POINT2 ',230);
1423: --
1424: if l_per_sys_st <> 'END' then
1425: --
1426: hr_utility.set_location(l_proc,240);
1427: --
1428: -- If UPDATE_OVERRIDE caused TERM_ASSIGNs to be removed this may have
1429: -- caused the END DATE to move.
1430: -- If so, the new_end_date will be NOT NULL.

Line 1437: hr_utility.set_location(l_proc,250);

1433: -- within this IF construct.
1434: --
1435: if p_re_entry_point = 2 then
1436: --
1437: hr_utility.set_location(l_proc,250);
1438: --
1439: goto RE_ENTRY_POINT_2a;
1440: --
1441: end if;

Line 1445: hr_utility.set_location(l_proc,260);

1441: end if;
1442: --
1443: if p_new_end_date is not null then
1444: --
1445: hr_utility.set_location(l_proc,260);
1446: --
1447: set_end_date(p_new_end_date,
1448: p_ass_id);
1449: --

Line 1452: hr_utility.set_location(l_proc,270);

1448: p_ass_id);
1449: --
1450: end if;
1451: --
1452: hr_utility.set_location(l_proc,270);
1453: --
1454: do_cancel_reterm
1455: (p_ass_id,
1456: p_bg_id,

Line 1462: hr_utility.set_location(l_proc,280);

1458: p_cancel_lspd,
1459: p_reterm_atd,
1460: p_reterm_lspd);
1461: --
1462: hr_utility.set_location(l_proc,280);
1463: --
1464: -- bug 5190394 added if condition
1465: if l_per_sys_st = 'TERM_ASSIGN' and p_val_st_date is not null
1466: and (p_old_per_sys_st = l_per_sys_st) then

Line 1485: hr_utility.set_location(l_proc,290);

1481: p_old_pg_id, -- Added for bug#3924690
1482: p_new_pg_id, -- Added for bug#3924690
1483: l_raise_warning);
1484: --
1485: hr_utility.set_location(l_proc,290);
1486: --
1487: if l_raise_warning in ('Y','S') then
1488: --
1489: hr_utility.set_location(l_proc,300);

Line 1489: hr_utility.set_location(l_proc,300);

1485: hr_utility.set_location(l_proc,290);
1486: --
1487: if l_raise_warning in ('Y','S') then
1488: --
1489: hr_utility.set_location(l_proc,300);
1490: --
1491: if l_raise_warning = 'Y' then
1492: --
1493: hr_utility.set_location(l_proc,310);

Line 1493: hr_utility.set_location(l_proc,310);

1489: hr_utility.set_location(l_proc,300);
1490: --
1491: if l_raise_warning = 'Y' then
1492: --
1493: hr_utility.set_location(l_proc,310);
1494: --
1495: p_warning := 'HR_7016_ASS_ENTRIES_CHANGED';
1496: --
1497: else

Line 1499: hr_utility.set_location(l_proc,320);

1495: p_warning := 'HR_7016_ASS_ENTRIES_CHANGED';
1496: --
1497: else
1498: --
1499: hr_utility.set_location(l_proc,320);
1500: --
1501: p_warning := 'HR_7442_ASS_SAL_ENT_CHANGED';
1502: --
1503: end if;

Line 1513: hr_utility.set_location(l_proc||' RE_ENTRY_POINT_2a',330);

1509: end if; -- bug 5190394
1510: --
1511: <>
1512: --
1513: hr_utility.set_location(l_proc||' RE_ENTRY_POINT_2a',330);
1514: --
1515: if l_per_sys_st = 'TERM_ASSIGN' and
1516: p_val_st_date is not null then
1517: --

Line 1521: hr_utility.set_location(l_proc,340);

1517: --
1518: if (p_old_per_sys_st <> l_per_sys_st) -- #2404335
1519: then
1520: --
1521: hr_utility.set_location(l_proc,340);
1522:
1523: terminate_entries(l_per_sys_st,
1524: p_ass_id,
1525: p_sess_date,

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

1525: p_sess_date,
1526: p_val_st_date);
1527: end if;
1528: --
1529: hr_utility.set_location(l_proc,350);
1530: --
1531: delete_any_pay_proposals(p_ass_id,
1532: p_val_st_date);
1533: --

Line 1551: hr_utility.set_location(l_proc,355);

1547: -- So a cursor is used to return the current assignment values, to pass to
1548: -- the pog procedure. The 'old' values were stored in a global record, as
1549: -- part of the pre_update_bundle procedure, ready for use here.
1550: --
1551: hr_utility.set_location(l_proc,355);
1552:
1553: OPEN asg_details(p_ass_id, p_sess_date);
1554: FETCH asg_details into cur_asg_rec;
1555: IF asg_details%NOTFOUND THEN

Line 1557: hr_utility.trace('no rows for cur_asg_rec');

1553: OPEN asg_details(p_ass_id, p_sess_date);
1554: FETCH asg_details into cur_asg_rec;
1555: IF asg_details%NOTFOUND THEN
1556: CLOSE asg_details;
1557: hr_utility.trace('no rows for cur_asg_rec');
1558: ELSE
1559: CLOSE asg_details;
1560: END IF;
1561: --

Line 1563: hr_utility.set_location(l_proc,357);

1559: CLOSE asg_details;
1560: END IF;
1561: --
1562:
1563: hr_utility.set_location(l_proc,357);
1564:
1565: pay_pog_all_assignments_pkg.after_update
1566: (p_effective_date => p_sess_date
1567: ,p_datetrack_mode => p_upd_mode

Line 1906: hr_utility.set_location('Leaving : '||l_proc,999);

1902: ,P_PROJECTED_ASSIGNMENT_END_O
1903: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
1904: );
1905: --
1906: hr_utility.set_location('Leaving : '||l_proc,999);
1907: --
1908: end post_update;
1909: -----------------------------------------------------------------------------
1910: procedure post_insert(

Line 2064: g_debug := hr_utility.debug_enabled; -- get debug status

2060: --
2061: l_proc varchar2(11) := 'post_insert';
2062: --
2063: begin
2064: g_debug := hr_utility.debug_enabled; -- get debug status
2065: IF g_debug THEN
2066: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
2067: END IF;
2068:

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

2062: --
2063: begin
2064: g_debug := hr_utility.debug_enabled; -- get debug status
2065: IF g_debug THEN
2066: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
2067: END IF;
2068:
2069: if p_prim_change_flag = 'Y' then
2070: --

Line 2089: hr_utility.set_location( g_package || l_proc, 10);

2085: --
2086: end if;
2087: --
2088: IF g_debug THEN
2089: hr_utility.set_location( g_package || l_proc, 10);
2090: END IF;
2091: update_group(
2092: p_pg_id,
2093: p_group_name,

Line 2097: hr_utility.set_location( g_package || l_proc, 20);

2093: p_group_name,
2094: p_bg_id);
2095: --
2096: IF g_debug THEN
2097: hr_utility.set_location( g_package || l_proc, 20);
2098: END IF;
2099: update_scl(
2100: p_scl_id,
2101: p_scl_concat);

Line 2109: hr_utility.set_location( g_package || l_proc, 30);

2105: -- NB to_char(0)'s are last_updated_by and last_update_login which
2106: -- are varchar2 parameters in load_budget_values.
2107: --
2108: IF g_debug THEN
2109: hr_utility.set_location( g_package || l_proc, 30);
2110: END IF;
2111: hr_assignment.load_budget_values(
2112: p_ass_id,
2113: p_bg_id,

Line 2122: hr_utility.set_location( g_package || l_proc, 40);

2118: --
2119: -- To load default assignment cost allocations
2120: --
2121: IF g_debug THEN
2122: hr_utility.set_location( g_package || l_proc, 40);
2123: END IF;
2124: declare
2125: l_position_id number;
2126: --

Line 2138: hr_utility.set_location( g_package || l_proc, 45);

2134: fetch c_position into l_position_id;
2135: close c_position;
2136: --
2137: IF g_debug THEN
2138: hr_utility.set_location( g_package || l_proc, 45);
2139: END IF;
2140: hr_assignment.load_assignment_allocation
2141: (p_assignment_id => p_ass_id
2142: ,p_business_group_id => p_bg_id

Line 2151: hr_utility.set_location( g_package || l_proc, 50);

2147: -- Insert element entries for new assignment, 1st 2 parameters are
2148: -- dt update and delete modes - ensure these are null.
2149: --
2150: IF g_debug THEN
2151: hr_utility.set_location( g_package || l_proc, 50);
2152: END IF;
2153: maintain_entries(
2154: null,
2155: null,

Line 2184: hr_utility.set_location( g_package || l_proc, 60);

2180: -- handler user hook, hence has many parameters that are not available here.
2181: -- So a cursor is used to return the values, to pass to the pog procedure.
2182: --
2183: IF g_debug THEN
2184: hr_utility.set_location( g_package || l_proc, 60);
2185: END IF;
2186: OPEN asg_details(p_ass_id, p_sess_date);
2187: FETCH asg_details into ins_asg_rec;
2188: IF asg_details%NOTFOUND THEN

Line 2190: hr_utility.trace('no rows for asg_details');

2186: OPEN asg_details(p_ass_id, p_sess_date);
2187: FETCH asg_details into ins_asg_rec;
2188: IF asg_details%NOTFOUND THEN
2189: CLOSE asg_details;
2190: hr_utility.trace('no rows for asg_details');
2191: ELSE
2192: CLOSE asg_details;
2193: END IF;
2194: --

Line 2196: hr_utility.set_location( g_package || l_proc, 70);

2192: CLOSE asg_details;
2193: END IF;
2194: --
2195: IF g_debug THEN
2196: hr_utility.set_location( g_package || l_proc, 70);
2197: END IF;
2198: dt_api.validate_dt_mode
2199: (p_effective_date => p_sess_date
2200: ,p_datetrack_mode => 'INSERT'

Line 2209: hr_utility.set_location( g_package || l_proc, 80);

2205: ,p_validation_end_date => l_ved
2206: );
2207: --
2208: IF g_debug THEN
2209: hr_utility.set_location( g_package || l_proc, 80);
2210: END IF;
2211:
2212: pay_pog_all_assignments_pkg.after_insert
2213: (p_effective_date => p_sess_date

Line 2329: hr_utility.set_location( 'Leaving ' || g_package || l_proc, 10);

2325: ,P_PO_LINE_ID => ins_asg_rec.po_line_id
2326: ,P_PROJECTED_ASSIGNMENT_END => ins_asg_rec.projected_assignment_end
2327: );
2328: IF g_debug THEN
2329: hr_utility.set_location( 'Leaving ' || g_package || l_proc, 10);
2330: END IF;
2331:
2332: end post_insert;
2333: -----------------------------------------------------------------------------

Line 2388: hr_utility.set_location('Entering : '||l_proc,10);

2384: l_bg_id number;
2385: --
2386: begin
2387: --
2388: hr_utility.set_location('Entering : '||l_proc,10);
2389: --
2390: --
2391: hr_assignment_internal.maintain_spp_asg
2392: (p_assignment_id => p_ass_id

Line 2399: hr_utility.set_location(l_proc,20);

2395: ,p_validation_end_date => p_val_end_date
2396: ,p_grade_id => p_grd_id
2397: ,p_spp_delete_warning => l_future_spp_warnings);
2398: --
2399: hr_utility.set_location(l_proc,20);
2400: --
2401: if p_del_mode in ('FUTURE_CHANGE', 'DELETE_NEXT_CHANGE') then
2402: --
2403: l_calling_proc := 'POST_DELETE';

Line 2405: hr_utility.set_location(l_proc||' / '||p_del_mode,30);

2401: if p_del_mode in ('FUTURE_CHANGE', 'DELETE_NEXT_CHANGE') then
2402: --
2403: l_calling_proc := 'POST_DELETE';
2404: --
2405: hr_utility.set_location(l_proc||' / '||p_del_mode,30);
2406: --
2407: future_del_cleanup
2408: (p_ass_id,
2409: p_grd_id,

Line 2436: hr_utility.set_location(l_proc,40);

2432: else
2433: --
2434: l_calling_proc := 'POST_DELETE';
2435: --
2436: hr_utility.set_location(l_proc,40);
2437:
2438: hr_assignment.del_ref_int_delete(
2439: p_ass_id,
2440: p_grd_id,

Line 2476: hr_utility.set_location(l_proc,50);

2472: -- deleting them, as this improves performance.
2473: --
2474: l_calling_proc := 'POST_DELETE';
2475: --
2476: hr_utility.set_location(l_proc,50);
2477:
2478: hr_assignment.del_ref_int_delete(
2479: p_ass_id,
2480: null,

Line 2494: hr_utility.set_location(l_proc,60);

2490: end if;
2491: --
2492: if p_prim_change_flag = 'Y' then
2493: --
2494: hr_utility.set_location(l_proc,60);
2495:
2496: iud_update_primary(
2497: p_del_mode,
2498: p_new_prim_flag,

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

2524: end if;
2525: --
2526: end if;
2527: --
2528: hr_utility.set_location(l_proc,70);
2529:
2530: do_cancel_reterm(
2531: p_ass_id,
2532: p_bg_id,

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

2536: p_reterm_lspd);
2537: --
2538: -- Pass null p_upd_mode.
2539: --
2540: hr_utility.set_location(l_proc,80);
2541:
2542: maintain_entries
2543: (null,
2544: p_del_mode,

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

2579: -- So a cursor is used to return those values that are not available to this
2580: -- procedure. The 'old' values have been selected into a record in the
2581: -- pre_delete procedure
2582: --
2583: hr_utility.set_location(l_proc,90);
2584: OPEN cur_asg_details(p_ass_id, p_sess_date);
2585: FETCH cur_asg_details into l_esd, l_ovn, l_bg_id;
2586: IF cur_asg_details%NOTFOUND THEN
2587: CLOSE cur_asg_details;

Line 2588: hr_utility.trace('no rows from cur_asg_details');

2584: OPEN cur_asg_details(p_ass_id, p_sess_date);
2585: FETCH cur_asg_details into l_esd, l_ovn, l_bg_id;
2586: IF cur_asg_details%NOTFOUND THEN
2587: CLOSE cur_asg_details;
2588: hr_utility.trace('no rows from cur_asg_details');
2589: --
2590: -- if ZAP mode no rows returned, setup l_ovn and l_esd
2591: --
2592: IF p_del_mode = 'ZAP' THEN

Line 2596: hr_utility.trace('Not zap - error');

2592: IF p_del_mode = 'ZAP' THEN
2593: l_ovn := per_assignments_f2_pkg.g_old_asg_rec.object_version_number;
2594: l_esd := per_assignments_f2_pkg.g_old_asg_rec.effective_start_date;
2595: ELSE
2596: hr_utility.trace('Not zap - error');
2597: END IF;
2598: ELSE
2599: CLOSE cur_asg_details;
2600: END IF;

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

2600: END IF;
2601: --
2602: -- call temporary POG package
2603: --
2604: hr_utility.set_location(l_proc,100);
2605: pay_pog_all_assignments_pkg.after_delete
2606: (p_effective_date => p_sess_date
2607: ,p_datetrack_mode => p_del_mode
2608: ,p_validation_start_date => p_val_st_date

Line 2837: hr_utility.set_location('Leaving : '||l_proc,999);

2833: ,P_PROJECTED_ASSIGNMENT_END_O
2834: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
2835: );
2836: --
2837: hr_utility.set_location('Leaving : '||l_proc,999);
2838: --
2839: end post_delete;
2840: -----------------------------------------------------------------------------
2841: END PER_ASSIGNMENTS_F1_PKG;