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 99: g_debug := hr_utility.debug_enabled; -- get debug status

95: WHERE pdp.person_id = l_person_id
96: AND pdp.date_start = l_pdp_date_start;
97:
98: BEGIN
99: g_debug := hr_utility.debug_enabled; -- get debug status
100: IF g_debug THEN
101: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
102: END IF;
103:

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

97:
98: BEGIN
99: g_debug := hr_utility.debug_enabled; -- get debug status
100: IF g_debug THEN
101: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
102: END IF;
103:
104: --
105: -- Fetch the desired assignment details.

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

112: --
113: -- Bug 3240313 starts here.
114: --
115: IF g_debug THEN
116: hr_utility.set_location( g_package || l_proc, 10);
117: END IF;
118:
119: IF csr_get_assignment_info%notfound then
120: OPEN csr_get_new_asg_info;

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

129: --
130: CLOSE csr_get_assignment_info;
131:
132: IF g_debug THEN
133: hr_utility.set_location( g_package || l_proc, 20);
134: END IF;
135:
136: if p_new_prim_flag = 'Y' and
137: (p_new_end_date <> p_eot and p_new_end_date is not null) then

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

176: -- really used at the moment.
177: --
178: IF l_assignment_type <> 'C' THEN
179: IF g_debug THEN
180: hr_utility.set_location( g_package || l_proc, 30);
181: END IF;
182:
183:
184: -- Start changes for bug 9644377

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

205: -- End changes for bug 9644377
206:
207: ELSIF l_assignment_type = 'C' THEN
208: IF g_debug THEN
209: hr_utility.set_location( g_package || l_proc, 40);
210: END IF;
211:
212:
213: -- Start changes for bug 9644377

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

238:
239: p_prim_change_flag := 'N';
240: --
241: IF g_debug THEN
242: hr_utility.set_location( 'Leaving ' ||g_package || l_proc, 50);
243: END IF;
244:
245: end iud_update_primary;
246: -----------------------------------------------------------------------------

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

283: --
284: l_proc varchar2(12) := 'update_group';
285: --
286: begin
287: g_debug := hr_utility.debug_enabled; -- get debug status
288: IF g_debug THEN
289: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
290: END IF;
291:

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

285: --
286: begin
287: g_debug := hr_utility.debug_enabled; -- get debug status
288: IF g_debug THEN
289: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
290: END IF;
291:
292: if p_pg_id <> -1 then
293: --

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

309: c := fnd_flex_ext.breakup_segments(l_xname,l_delimiter,l_ch_seg);
310: fnd_profile.get('ICX_DATE_FORMAT_MASK',l_dateformat);
311:
312: IF g_debug THEN
313: hr_utility.set_location( g_package || l_proc, 10);
314: END IF;
315:
316: For x in c_seg(l_flexnum) loop
317:

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

332: -- p_group_name := l_xname;
333: end if;
334: --End of Fix 2762904
335: IF g_debug THEN
336: hr_utility.set_location( g_package || l_proc, 20);
337: END IF;
338: update pay_people_groups
339: set group_name = l_xname
340: where people_group_id = P_PG_ID

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

357: */
358: end if;
359: --
360: IF g_debug THEN
361: hr_utility.set_location( 'Leaving ' || g_package || l_proc, 30);
362: END IF;
363: end update_group;
364: -----------------------------------------------------------------------------
365:

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

400:
401: begin
402:
403: -- if g_debug then
404: hr_utility.set_location('Entering:'|| l_proc, 10);
405: -- end if;
406: --
407: -- The outer procedure has already establish that an update is
408: -- required. This sub-procedure uses an autonomous transaction

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

425: close csr_scl_lock;
426:
427:
428: -- if g_debug then
429: hr_utility.set_location(l_proc, 20);
430: -- end if;
431: --
432: -- Lock obtained by this transaction, updating the concatenated
433: -- segment string should be performed.

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

454: end if;
455:
456:
457: -- if g_debug then
458: hr_utility.set_location('Leaving:'|| l_proc, 30);
459: -- end if;
460:
461: Exception
462: When HR_Api.Object_Locked then

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

465: -- It can be assumed that another transaction has locked the
466: -- row and is performing the update. Hence the error can
467: -- be suppressed without raising it to the end user.
468: --
469: hr_utility.set_location('Leaving:'|| l_proc, 40);
470: end update_scl_auto;
471:
472: begin
473: --

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

472: begin
473: --
474:
475: --if g_debug then
476: hr_utility.set_location('Entering:'|| l_proc, 10);
477: --end if;
478: --
479: -- First find out if it is necessary to update the concatenated
480: -- segment string column. This select is being done to avoid the

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

512: end if;
513: --
514:
515: --if g_debug then
516: hr_utility.set_location('Leaving:'|| l_proc, 20);
517: --end if;
518:
519: end update_scl;
520: -----------------------------------------------------------------------------

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

568: --
569: l_proc varchar2(16) := 'do_cancel_reterm';
570: --
571: begin
572: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
573: hrentmnt.maintain_entries_asg(
574: p_ass_id,
575: p_bg_id,
576: 'CNCL_TERM',

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

591: null,
592: l_entries_chng);
593: end if;
594: --
595: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);
596: end do_cancel_reterm;
597: ----------------------------------------------------------------------------
598: procedure future_del_cleanup(
599: p_ass_id number,

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

613: begin
614: --
615: -- The 2 0's are last_updated_by, last_update_login.
616: --
617: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
618: hr_assignment.del_ref_int_delete(
619: p_ass_id,
620: p_grd_id,
621: 'FUTURE',

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

628: l_future_spp_warning);
629:
630: p_future_spp_warnings := l_future_spp_warning;
631: --
632: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);
633: end future_del_cleanup;
634: ----------------------------------------------------------------------------
635: procedure tidy_up_ref_int(
636: p_mode varchar2,

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

652: -- 'END' and when the row is opened up using 'FUTURE_CHANGE' or
653: -- 'DELETE_NEXT_CHANGE'.
654: --
655: begin
656: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
657: l_mode := p_mode;
658: --
659: if l_mode = 'END' then
660: l_new_end_date := p_sess_date;

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

677: l_old_end_date,
678: 0, 0, p_cost_warning);
679: --
680:
681: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);
682: end tidy_up_ref_int;
683: ----------------------------------------------------------------------------
684: procedure terminate_entries(
685: p_per_sys_st varchar2,

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

687: p_sess_date date,
688: p_val_st_date date) is
689: l_start_date date;
690: begin
691: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F1_PKG.terminate_entries' , 5);
692: if p_per_sys_st = 'END' then
693: l_start_date := p_sess_date;
694: else
695: l_start_date := p_val_st_date;

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

711: -- This is to ensure that assignments cannot be 'opened up' past the Period
712: -- of Service End Date.
713: --
714: begin
715: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F1_PKG.set_end_date' , 5);
716:
717: update per_assignments_f a
718: set a.effective_end_date = P_NEW_END_DATE
719: where a.assignment_id = P_ASS_ID

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

752: -- Maintain element entries for insert/update/delete
753: --
754: begin
755: --
756: hr_utility.set_location('per_assignments_f1_pkg.maintain_entries',1);
757: hr_utility.set_location('p_old_pg_id :'||to_char(p_old_pg_id),1);
758: hr_utility.set_location('p_new_pg_id :'||to_char(p_new_pg_id),1);
759:
760: if p_dt_upd_mode is null then

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

753: --
754: begin
755: --
756: hr_utility.set_location('per_assignments_f1_pkg.maintain_entries',1);
757: hr_utility.set_location('p_old_pg_id :'||to_char(p_old_pg_id),1);
758: hr_utility.set_location('p_new_pg_id :'||to_char(p_new_pg_id),1);
759:
760: if p_dt_upd_mode is null then
761: if p_dt_del_mode is null then

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

754: begin
755: --
756: hr_utility.set_location('per_assignments_f1_pkg.maintain_entries',1);
757: hr_utility.set_location('p_old_pg_id :'||to_char(p_old_pg_id),1);
758: hr_utility.set_location('p_new_pg_id :'||to_char(p_new_pg_id),1);
759:
760: if p_dt_upd_mode is null then
761: if p_dt_del_mode is null then
762: l_mode := 'INSERT';

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

792: if l_mode = 'DELETE' then
793: l_val_start_date := l_val_start_date + 1;
794: end if;
795: --
796: hr_utility.set_location('per_assignments_f1_pkg.maintain_entries',2);
797:
798: hrentmnt.maintain_entries_asg(
799: P_ASSIGNMENT_ID => p_ass_id,
800: P_OLD_PAYROLL_ID => p_old_pay_id,

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

1086: --
1087: ---------------------------------------------------------
1088: begin
1089: --
1090: hr_utility.set_location('Entering : '||l_proc,10);
1091: hr_utility.set_location(l_proc||' Update Mode: '||p_upd_mode,11);
1092: hr_utility.set_location(l_proc||' p_sess_date = '||p_sess_date,12);
1093: --
1094: hr_utility.set_location('peasg01t.pkb.post_update..p_grd_id:' || p_grd_id,11); -- Bug#13960540

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

1087: ---------------------------------------------------------
1088: begin
1089: --
1090: hr_utility.set_location('Entering : '||l_proc,10);
1091: hr_utility.set_location(l_proc||' Update Mode: '||p_upd_mode,11);
1092: hr_utility.set_location(l_proc||' p_sess_date = '||p_sess_date,12);
1093: --
1094: hr_utility.set_location('peasg01t.pkb.post_update..p_grd_id:' || p_grd_id,11); -- Bug#13960540
1095: hr_utility.set_location('peasg01t.pkb.post_update..p_s_grd_id:' || p_s_grd_id,11);

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

1088: begin
1089: --
1090: hr_utility.set_location('Entering : '||l_proc,10);
1091: hr_utility.set_location(l_proc||' Update Mode: '||p_upd_mode,11);
1092: hr_utility.set_location(l_proc||' p_sess_date = '||p_sess_date,12);
1093: --
1094: hr_utility.set_location('peasg01t.pkb.post_update..p_grd_id:' || p_grd_id,11); -- Bug#13960540
1095: hr_utility.set_location('peasg01t.pkb.post_update..p_s_grd_id:' || p_s_grd_id,11);
1096: hr_utility.set_location('peasg01t.pkb.post_update..p_old_org_id:' || p_old_org_id,11);

Line 1094: hr_utility.set_location('peasg01t.pkb.post_update..p_grd_id:' || p_grd_id,11); -- Bug#13960540

1090: hr_utility.set_location('Entering : '||l_proc,10);
1091: hr_utility.set_location(l_proc||' Update Mode: '||p_upd_mode,11);
1092: hr_utility.set_location(l_proc||' p_sess_date = '||p_sess_date,12);
1093: --
1094: hr_utility.set_location('peasg01t.pkb.post_update..p_grd_id:' || p_grd_id,11); -- Bug#13960540
1095: hr_utility.set_location('peasg01t.pkb.post_update..p_s_grd_id:' || p_s_grd_id,11);
1096: hr_utility.set_location('peasg01t.pkb.post_update..p_old_org_id:' || p_old_org_id,11);
1097: hr_utility.set_location('peasg01t.pkb.post_update..p_new_org_id:' || p_new_org_id,11);
1098: hr_utility.set_location('peasg01t.pkb.post_update..p_old_emp_cat:' || p_old_emp_cat,11);

Line 1095: hr_utility.set_location('peasg01t.pkb.post_update..p_s_grd_id:' || p_s_grd_id,11);

1091: hr_utility.set_location(l_proc||' Update Mode: '||p_upd_mode,11);
1092: hr_utility.set_location(l_proc||' p_sess_date = '||p_sess_date,12);
1093: --
1094: hr_utility.set_location('peasg01t.pkb.post_update..p_grd_id:' || p_grd_id,11); -- Bug#13960540
1095: hr_utility.set_location('peasg01t.pkb.post_update..p_s_grd_id:' || p_s_grd_id,11);
1096: hr_utility.set_location('peasg01t.pkb.post_update..p_old_org_id:' || p_old_org_id,11);
1097: hr_utility.set_location('peasg01t.pkb.post_update..p_new_org_id:' || p_new_org_id,11);
1098: hr_utility.set_location('peasg01t.pkb.post_update..p_old_emp_cat:' || p_old_emp_cat,11);
1099: hr_utility.set_location('peasg01t.pkb.post_update..p_new_emp_cat:' || p_new_emp_cat,11); -- Bug#13960540

Line 1096: hr_utility.set_location('peasg01t.pkb.post_update..p_old_org_id:' || p_old_org_id,11);

1092: hr_utility.set_location(l_proc||' p_sess_date = '||p_sess_date,12);
1093: --
1094: hr_utility.set_location('peasg01t.pkb.post_update..p_grd_id:' || p_grd_id,11); -- Bug#13960540
1095: hr_utility.set_location('peasg01t.pkb.post_update..p_s_grd_id:' || p_s_grd_id,11);
1096: hr_utility.set_location('peasg01t.pkb.post_update..p_old_org_id:' || p_old_org_id,11);
1097: hr_utility.set_location('peasg01t.pkb.post_update..p_new_org_id:' || p_new_org_id,11);
1098: hr_utility.set_location('peasg01t.pkb.post_update..p_old_emp_cat:' || p_old_emp_cat,11);
1099: hr_utility.set_location('peasg01t.pkb.post_update..p_new_emp_cat:' || p_new_emp_cat,11); -- Bug#13960540
1100: --

Line 1097: hr_utility.set_location('peasg01t.pkb.post_update..p_new_org_id:' || p_new_org_id,11);

1093: --
1094: hr_utility.set_location('peasg01t.pkb.post_update..p_grd_id:' || p_grd_id,11); -- Bug#13960540
1095: hr_utility.set_location('peasg01t.pkb.post_update..p_s_grd_id:' || p_s_grd_id,11);
1096: hr_utility.set_location('peasg01t.pkb.post_update..p_old_org_id:' || p_old_org_id,11);
1097: hr_utility.set_location('peasg01t.pkb.post_update..p_new_org_id:' || p_new_org_id,11);
1098: hr_utility.set_location('peasg01t.pkb.post_update..p_old_emp_cat:' || p_old_emp_cat,11);
1099: hr_utility.set_location('peasg01t.pkb.post_update..p_new_emp_cat:' || p_new_emp_cat,11); -- Bug#13960540
1100: --
1101: p_warning := null;

Line 1098: hr_utility.set_location('peasg01t.pkb.post_update..p_old_emp_cat:' || p_old_emp_cat,11);

1094: hr_utility.set_location('peasg01t.pkb.post_update..p_grd_id:' || p_grd_id,11); -- Bug#13960540
1095: hr_utility.set_location('peasg01t.pkb.post_update..p_s_grd_id:' || p_s_grd_id,11);
1096: hr_utility.set_location('peasg01t.pkb.post_update..p_old_org_id:' || p_old_org_id,11);
1097: hr_utility.set_location('peasg01t.pkb.post_update..p_new_org_id:' || p_new_org_id,11);
1098: hr_utility.set_location('peasg01t.pkb.post_update..p_old_emp_cat:' || p_old_emp_cat,11);
1099: hr_utility.set_location('peasg01t.pkb.post_update..p_new_emp_cat:' || p_new_emp_cat,11); -- Bug#13960540
1100: --
1101: p_warning := null;
1102: --

Line 1099: hr_utility.set_location('peasg01t.pkb.post_update..p_new_emp_cat:' || p_new_emp_cat,11); -- Bug#13960540

1095: hr_utility.set_location('peasg01t.pkb.post_update..p_s_grd_id:' || p_s_grd_id,11);
1096: hr_utility.set_location('peasg01t.pkb.post_update..p_old_org_id:' || p_old_org_id,11);
1097: hr_utility.set_location('peasg01t.pkb.post_update..p_new_org_id:' || p_new_org_id,11);
1098: hr_utility.set_location('peasg01t.pkb.post_update..p_old_emp_cat:' || p_old_emp_cat,11);
1099: hr_utility.set_location('peasg01t.pkb.post_update..p_new_emp_cat:' || p_new_emp_cat,11); -- Bug#13960540
1100: --
1101: p_warning := null;
1102: --
1103: -- If the assignment was updated to End Assign then value would

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

1112: l_per_sys_st := p_per_sys_st;
1113: --
1114: end if;
1115: --
1116: hr_utility.trace('Reentry Point is '||to_char(p_re_entry_point));
1117: hr_utility.trace('l_per_sys_st is '||l_per_sys_st);
1118: --
1119: if p_re_entry_point = 1 then
1120: --

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

1113: --
1114: end if;
1115: --
1116: hr_utility.trace('Reentry Point is '||to_char(p_re_entry_point));
1117: hr_utility.trace('l_per_sys_st is '||l_per_sys_st);
1118: --
1119: if p_re_entry_point = 1 then
1120: --
1121: goto RE_ENTRY_POINT_1;

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

1127: end if;
1128: --
1129: if p_prim_change_flag = 'Y' then
1130: --
1131: hr_utility.set_location(l_proc,20);
1132: --
1133: iud_update_primary( p_upd_mode,
1134: p_new_prim_flag,
1135: p_val_st_date,

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

1141: p_prim_change_flag);
1142: --
1143: end if;
1144: --
1145: hr_utility.set_location(l_proc,30);
1146: --
1147: update_group( p_new_pg_id,
1148: p_group_name,
1149: p_bg_id);

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

1147: update_group( p_new_pg_id,
1148: p_group_name,
1149: p_bg_id);
1150: --
1151: hr_utility.set_location(l_proc,40);
1152: --
1153: update_scl(
1154: p_scl_id,
1155: p_scl_concat);

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

1155: p_scl_concat);
1156: --
1157: if p_upd_mode = 'UPDATE_OVERRIDE' then
1158: --
1159: hr_utility.set_location(l_proc,50);
1160: --
1161: hr_assignment_internal.maintain_spp_asg
1162: (p_assignment_id => p_ass_id
1163: ,p_datetrack_mode => p_upd_mode

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

1183: p_val_end_date,
1184: p_upd_mode,
1185: l_dummy_warning);
1186: --
1187: hr_utility.set_location(l_proc,60);
1188: --
1189: --
1190: -- If datetrack mode is not UPDATE_OVERRIDE
1191: --

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

1213: -- Start of 3335915
1214: /*
1215: -- Start of Fix for Bug 2849080
1216: --
1217: hr_utility.set_location('p_was_end_assign'||p_was_end_assign,2);
1218: hr_utility.set_location('l_per_sys_st '||l_per_sys_st,2);
1219:
1220: IF (p_grd_id is not null ) and (p_grd_id = p_s_grd_id) then
1221: -- start of fix for bug 3053428

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

1214: /*
1215: -- Start of Fix for Bug 2849080
1216: --
1217: hr_utility.set_location('p_was_end_assign'||p_was_end_assign,2);
1218: hr_utility.set_location('l_per_sys_st '||l_per_sys_st,2);
1219:
1220: IF (p_grd_id is not null ) and (p_grd_id = p_s_grd_id) then
1221: -- start of fix for bug 3053428
1222: IF l_per_sys_st = 'END' then

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

1239: CLOSE csr_spp_id;
1240: -- -- End of fix for bug 3053428
1241: ElSe
1242:
1243: hr_utility.set_location('Ass Eff dt matching ',2);
1244:
1245: OPEN csr_grade_step;
1246: FETCH csr_grade_step
1247: INTO l_placement_id,l_object_version_number,l_step_id, l_spp_end_date,l_spp_st_date;

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

1247: INTO l_placement_id,l_object_version_number,l_step_id, l_spp_end_date,l_spp_st_date;
1248:
1249:
1250: IF csr_grade_step%found then
1251: hr_utility.set_location('Record Found ',2);
1252: select max(effective_end_date)
1253: into l_max_spp_date
1254: from per_spinal_point_placements_f
1255: where placement_id = l_placement_id;

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

1253: into l_max_spp_date
1254: from per_spinal_point_placements_f
1255: where placement_id = l_placement_id;
1256:
1257: hr_utility.set_location('PD: Max SPP End Dt '|| l_max_spp_date,2);
1258: hr_utility.set_location('PD: Current SPP end dt '||l_spp_end_date,2);
1259: hr_utility.set_location('PD: Val Dt '|| p_val_st_date,2);
1260: hr_utility.set_location('PD: Current SPP st dt '||l_spp_st_date,2);
1261:

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

1254: from per_spinal_point_placements_f
1255: where placement_id = l_placement_id;
1256:
1257: hr_utility.set_location('PD: Max SPP End Dt '|| l_max_spp_date,2);
1258: hr_utility.set_location('PD: Current SPP end dt '||l_spp_end_date,2);
1259: hr_utility.set_location('PD: Val Dt '|| p_val_st_date,2);
1260: hr_utility.set_location('PD: Current SPP st dt '||l_spp_st_date,2);
1261:
1262: IF (l_spp_st_date = p_val_st_date) THEN

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

1255: where placement_id = l_placement_id;
1256:
1257: hr_utility.set_location('PD: Max SPP End Dt '|| l_max_spp_date,2);
1258: hr_utility.set_location('PD: Current SPP end dt '||l_spp_end_date,2);
1259: hr_utility.set_location('PD: Val Dt '|| p_val_st_date,2);
1260: hr_utility.set_location('PD: Current SPP st dt '||l_spp_st_date,2);
1261:
1262: IF (l_spp_st_date = p_val_st_date) THEN
1263: l_datetrack_mode := 'CORRECTION';

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

1256:
1257: hr_utility.set_location('PD: Max SPP End Dt '|| l_max_spp_date,2);
1258: hr_utility.set_location('PD: Current SPP end dt '||l_spp_end_date,2);
1259: hr_utility.set_location('PD: Val Dt '|| p_val_st_date,2);
1260: hr_utility.set_location('PD: Current SPP st dt '||l_spp_st_date,2);
1261:
1262: IF (l_spp_st_date = p_val_st_date) THEN
1263: l_datetrack_mode := 'CORRECTION';
1264: ELSIF (l_max_spp_date = l_spp_end_date) THEN

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

1266: ELSE
1267: l_datetrack_mode := 'UPDATE_CHANGE_INSERT';
1268: END IF;
1269:
1270: hr_utility.set_location('PD: Date Track Mode '||l_datetrack_mode,2);
1271:
1272:
1273: hr_utility.set_location('Calling upadate_spp from post_update ',2);
1274: hr_utility.set_location('effective_date : '||p_val_st_date,2);

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

1269:
1270: hr_utility.set_location('PD: Date Track Mode '||l_datetrack_mode,2);
1271:
1272:
1273: hr_utility.set_location('Calling upadate_spp from post_update ',2);
1274: hr_utility.set_location('effective_date : '||p_val_st_date,2);
1275: hr_utility.set_location('datetrack_mode : '||l_datetrack_mode,2);
1276: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1277: hr_utility.set_location('OVN : '||l_object_version_number,2);

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

1270: hr_utility.set_location('PD: Date Track Mode '||l_datetrack_mode,2);
1271:
1272:
1273: hr_utility.set_location('Calling upadate_spp from post_update ',2);
1274: hr_utility.set_location('effective_date : '||p_val_st_date,2);
1275: hr_utility.set_location('datetrack_mode : '||l_datetrack_mode,2);
1276: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1277: hr_utility.set_location('OVN : '||l_object_version_number,2);
1278: hr_utility.set_location('Step Id : '||l_step_id,2);

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

1271:
1272:
1273: hr_utility.set_location('Calling upadate_spp from post_update ',2);
1274: hr_utility.set_location('effective_date : '||p_val_st_date,2);
1275: hr_utility.set_location('datetrack_mode : '||l_datetrack_mode,2);
1276: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1277: hr_utility.set_location('OVN : '||l_object_version_number,2);
1278: hr_utility.set_location('Step Id : '||l_step_id,2);
1279: hr_utility.set_location('Effective Start date : '||l_effective_start_date,2);

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

1272:
1273: hr_utility.set_location('Calling upadate_spp from post_update ',2);
1274: hr_utility.set_location('effective_date : '||p_val_st_date,2);
1275: hr_utility.set_location('datetrack_mode : '||l_datetrack_mode,2);
1276: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1277: hr_utility.set_location('OVN : '||l_object_version_number,2);
1278: hr_utility.set_location('Step Id : '||l_step_id,2);
1279: hr_utility.set_location('Effective Start date : '||l_effective_start_date,2);
1280: hr_utility.set_location('Efective end date : '||l_effective_end_date,2);

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

1273: hr_utility.set_location('Calling upadate_spp from post_update ',2);
1274: hr_utility.set_location('effective_date : '||p_val_st_date,2);
1275: hr_utility.set_location('datetrack_mode : '||l_datetrack_mode,2);
1276: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1277: hr_utility.set_location('OVN : '||l_object_version_number,2);
1278: hr_utility.set_location('Step Id : '||l_step_id,2);
1279: hr_utility.set_location('Effective Start date : '||l_effective_start_date,2);
1280: hr_utility.set_location('Efective end date : '||l_effective_end_date,2);
1281: hr_utility.set_location ('Session Date : '||p_sess_date, 2);

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

1274: hr_utility.set_location('effective_date : '||p_val_st_date,2);
1275: hr_utility.set_location('datetrack_mode : '||l_datetrack_mode,2);
1276: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1277: hr_utility.set_location('OVN : '||l_object_version_number,2);
1278: hr_utility.set_location('Step Id : '||l_step_id,2);
1279: hr_utility.set_location('Effective Start date : '||l_effective_start_date,2);
1280: hr_utility.set_location('Efective end date : '||l_effective_end_date,2);
1281: hr_utility.set_location ('Session Date : '||p_sess_date, 2);
1282:

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

1275: hr_utility.set_location('datetrack_mode : '||l_datetrack_mode,2);
1276: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1277: hr_utility.set_location('OVN : '||l_object_version_number,2);
1278: hr_utility.set_location('Step Id : '||l_step_id,2);
1279: hr_utility.set_location('Effective Start date : '||l_effective_start_date,2);
1280: hr_utility.set_location('Efective end date : '||l_effective_end_date,2);
1281: hr_utility.set_location ('Session Date : '||p_sess_date, 2);
1282:
1283:

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

1276: hr_utility.set_location('placement_id : '||l_placement_id ,2);
1277: hr_utility.set_location('OVN : '||l_object_version_number,2);
1278: hr_utility.set_location('Step Id : '||l_step_id,2);
1279: hr_utility.set_location('Effective Start date : '||l_effective_start_date,2);
1280: hr_utility.set_location('Efective end date : '||l_effective_end_date,2);
1281: hr_utility.set_location ('Session Date : '||p_sess_date, 2);
1282:
1283:
1284: hr_sp_placement_api.update_spp

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

1277: hr_utility.set_location('OVN : '||l_object_version_number,2);
1278: hr_utility.set_location('Step Id : '||l_step_id,2);
1279: hr_utility.set_location('Effective Start date : '||l_effective_start_date,2);
1280: hr_utility.set_location('Efective end date : '||l_effective_end_date,2);
1281: hr_utility.set_location ('Session Date : '||p_sess_date, 2);
1282:
1283:
1284: hr_sp_placement_api.update_spp
1285: (p_effective_date => p_val_st_date

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

1292:
1293:
1294:
1295:
1296: hr_utility.set_location('Call to update_SPP finished ',2);
1297:
1298: END IF;
1299: CLOSE csr_grade_step;
1300:

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

1308:
1309: if (p_s_grd_id <> p_grd_id) or
1310: (p_grd_id is null and p_s_grd_id is not null) then
1311: --
1312: hr_utility.set_location(l_proc||'Grade ID = '||p_grd_id,70);
1313: hr_utility.set_location(l_proc||'Asg ID = '||p_ass_id,71);
1314: hr_utility.set_location(l_proc||'Val Start Date = '||p_val_st_date,72);
1315: --
1316: -- Check that the effective date of the process is not less than the min

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

1309: if (p_s_grd_id <> p_grd_id) or
1310: (p_grd_id is null and p_s_grd_id is not null) then
1311: --
1312: hr_utility.set_location(l_proc||'Grade ID = '||p_grd_id,70);
1313: hr_utility.set_location(l_proc||'Asg ID = '||p_ass_id,71);
1314: hr_utility.set_location(l_proc||'Val Start Date = '||p_val_st_date,72);
1315: --
1316: -- Check that the effective date of the process is not less than the min
1317: -- effective start date for the spp record for the assignment

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

1310: (p_grd_id is null and p_s_grd_id is not null) then
1311: --
1312: hr_utility.set_location(l_proc||'Grade ID = '||p_grd_id,70);
1313: hr_utility.set_location(l_proc||'Asg ID = '||p_ass_id,71);
1314: hr_utility.set_location(l_proc||'Val Start Date = '||p_val_st_date,72);
1315: --
1316: -- Check that the effective date of the process is not less than the min
1317: -- effective start date for the spp record for the assignment
1318: -- If it is then the process will not be able to update the current step

Line 1327: hr_utility.raise_error;

1323: --
1324: if l_min_start_date > p_val_st_date then
1325: --
1326: fnd_message.set_name('PER', 'HR_289771_SPP_MIN_START_DATE');
1327: hr_utility.raise_error;
1328: --
1329: end if;
1330: --
1331: close csr_min_spp_date;

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

1329: end if;
1330: --
1331: close csr_min_spp_date;
1332: --
1333: hr_utility.set_location(l_proc,80);
1334: --
1335: hr_assignment_internal.maintain_spp_asg
1336: (p_assignment_id => p_ass_id
1337: ,p_datetrack_mode => p_upd_mode

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

1345: end if;
1346: --
1347: <>
1348: --
1349: hr_utility.set_location(l_proc||' RE_ENTRY_POINT_1 ',90);
1350: --
1351: if l_per_sys_st = 'END' then
1352: --
1353: hr_utility.set_location(l_proc,100);

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

1349: hr_utility.set_location(l_proc||' RE_ENTRY_POINT_1 ',90);
1350: --
1351: if l_per_sys_st = 'END' then
1352: --
1353: hr_utility.set_location(l_proc,100);
1354: --
1355: -- Date Effectively Delete any of the assignments' children
1356: -- records.
1357: -- The following tables are affected

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

1364: -- within this IF construct.
1365: --
1366: if p_re_entry_point = 1 then
1367: --
1368: hr_utility.set_location(l_proc,110);
1369: --
1370: goto RE_ENTRY_POINT_1a;
1371: --
1372: end if;

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

1372: end if;
1373: --
1374: l_calling_proc := 'POST_UPDATE';
1375: --
1376: hr_utility.set_location(l_proc,120);
1377: --
1378: hr_assignment.del_ref_int_delete
1379: (p_ass_id,
1380: null,

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

1387: p_val_end_date,
1388: p_upd_mode,
1389: l_future_spp_warnings);
1390: --
1391: hr_utility.set_location(l_proc,130);
1392: --
1393: p_future_spp_warning := l_future_spp_warnings;
1394: --
1395: -- NB l_cost_Warning is not set in this scenario.

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

1411: */
1412: --
1413: -- Fix for bug 4278579 ends here.
1414: --
1415: hr_utility.set_location(l_proc,140);
1416: --
1417: -- Pass null dt delete mode to ensure it is null.
1418: --
1419: hr_utility.set_location(l_proc,150);

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

1415: hr_utility.set_location(l_proc,140);
1416: --
1417: -- Pass null dt delete mode to ensure it is null.
1418: --
1419: hr_utility.set_location(l_proc,150);
1420: --
1421: maintain_entries
1422: (p_upd_mode,
1423: null,

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

1453: l_cost_warning);
1454: --
1455: -- Fix for bug 4278579 ends here.
1456: --
1457: hr_utility.set_location(l_proc,160);
1458: --
1459: if l_raise_warning in ('Y','S') then
1460: --
1461: hr_utility.set_location(l_proc,170);

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

1457: hr_utility.set_location(l_proc,160);
1458: --
1459: if l_raise_warning in ('Y','S') then
1460: --
1461: hr_utility.set_location(l_proc,170);
1462: --
1463: if l_raise_warning = 'Y' then
1464: --
1465: hr_utility.set_location(l_proc,180);

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

1461: hr_utility.set_location(l_proc,170);
1462: --
1463: if l_raise_warning = 'Y' then
1464: --
1465: hr_utility.set_location(l_proc,180);
1466: --
1467: p_warning := 'HR_7016_ASS_ENTRIES_CHANGED';
1468: --
1469: else

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

1467: p_warning := 'HR_7016_ASS_ENTRIES_CHANGED';
1468: --
1469: else
1470: --
1471: hr_utility.set_location(l_proc,190);
1472: --
1473: p_warning := 'HR_7442_ASS_SAL_ENT_CHANGED';
1474: --
1475: end if;

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

1480: end if;
1481: --
1482: <>
1483: --
1484: hr_utility.set_location(l_proc||' RE_ENTRY_POINT_1a ',200);
1485: --
1486: terminate_entries
1487: (l_per_sys_st,
1488: p_ass_id,

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

1488: p_ass_id,
1489: p_sess_date,
1490: p_val_st_date);
1491: --
1492: hr_utility.set_location(l_proc,210);
1493: --
1494: -- Now delete any pay proposals which have a change date
1495: -- after the end of this assignment.
1496: --

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

1497: delete_any_pay_proposals
1498: (p_ass_id,
1499: p_val_st_date);
1500: --
1501: hr_utility.set_location(l_proc,220);
1502: --
1503: end if; -- if l_per_sys_st = 'END'
1504: --
1505: <>

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

1503: end if; -- if l_per_sys_st = 'END'
1504: --
1505: <>
1506: --
1507: hr_utility.set_location(l_proc||' RE_ENTRY_POINT2 ',230);
1508: --
1509: if l_per_sys_st <> 'END' then
1510: --
1511: hr_utility.set_location(l_proc,240);

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

1507: hr_utility.set_location(l_proc||' RE_ENTRY_POINT2 ',230);
1508: --
1509: if l_per_sys_st <> 'END' then
1510: --
1511: hr_utility.set_location(l_proc,240);
1512: --
1513: -- If UPDATE_OVERRIDE caused TERM_ASSIGNs to be removed this may have
1514: -- caused the END DATE to move.
1515: -- If so, the new_end_date will be NOT NULL.

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

1518: -- within this IF construct.
1519: --
1520: if p_re_entry_point = 2 then
1521: --
1522: hr_utility.set_location(l_proc,250);
1523: --
1524: goto RE_ENTRY_POINT_2a;
1525: --
1526: end if;

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

1526: end if;
1527: --
1528: if p_new_end_date is not null then
1529: --
1530: hr_utility.set_location(l_proc,260);
1531: --
1532: set_end_date(p_new_end_date,
1533: p_ass_id);
1534: --

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

1533: p_ass_id);
1534: --
1535: end if;
1536: --
1537: hr_utility.set_location(l_proc,270);
1538: --
1539: do_cancel_reterm
1540: (p_ass_id,
1541: p_bg_id,

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

1543: p_cancel_lspd,
1544: p_reterm_atd,
1545: p_reterm_lspd);
1546: --
1547: hr_utility.set_location(l_proc,280);
1548: --
1549: -- bug 5190394 added if condition
1550: if l_per_sys_st = 'TERM_ASSIGN' and p_val_st_date is not null
1551: and (p_old_per_sys_st = l_per_sys_st) then

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

1572: p_old_emp_cat, -- Added for Bug#13960540
1573: p_new_emp_cat, -- Added for Bug#13960540
1574: l_raise_warning);
1575: --
1576: hr_utility.set_location(l_proc,290);
1577: --
1578: if l_raise_warning in ('Y','S') then
1579: --
1580: hr_utility.set_location(l_proc,300);

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

1576: hr_utility.set_location(l_proc,290);
1577: --
1578: if l_raise_warning in ('Y','S') then
1579: --
1580: hr_utility.set_location(l_proc,300);
1581: --
1582: if l_raise_warning = 'Y' then
1583: --
1584: hr_utility.set_location(l_proc,310);

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

1580: hr_utility.set_location(l_proc,300);
1581: --
1582: if l_raise_warning = 'Y' then
1583: --
1584: hr_utility.set_location(l_proc,310);
1585: --
1586: p_warning := 'HR_7016_ASS_ENTRIES_CHANGED';
1587: --
1588: else

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

1586: p_warning := 'HR_7016_ASS_ENTRIES_CHANGED';
1587: --
1588: else
1589: --
1590: hr_utility.set_location(l_proc,320);
1591: --
1592: p_warning := 'HR_7442_ASS_SAL_ENT_CHANGED';
1593: --
1594: end if;

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

1600: end if; -- bug 5190394
1601: --
1602: <>
1603: --
1604: hr_utility.set_location(l_proc||' RE_ENTRY_POINT_2a',330);
1605: --
1606: if l_per_sys_st = 'TERM_ASSIGN' and
1607: p_val_st_date is not null then
1608: --

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

1608: --
1609: if (p_old_per_sys_st <> l_per_sys_st) -- #2404335
1610: then
1611: --
1612: hr_utility.set_location(l_proc,340);
1613:
1614: terminate_entries(l_per_sys_st,
1615: p_ass_id,
1616: p_sess_date,

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

1616: p_sess_date,
1617: p_val_st_date);
1618: end if;
1619: --
1620: hr_utility.set_location(l_proc,350);
1621: --
1622: delete_any_pay_proposals(p_ass_id,
1623: p_val_st_date);
1624: --

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

1638: -- So a cursor is used to return the current assignment values, to pass to
1639: -- the pog procedure. The 'old' values were stored in a global record, as
1640: -- part of the pre_update_bundle procedure, ready for use here.
1641: --
1642: hr_utility.set_location(l_proc,355);
1643:
1644: OPEN asg_details(p_ass_id, p_sess_date);
1645: FETCH asg_details into cur_asg_rec;
1646: IF asg_details%NOTFOUND THEN

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

1644: OPEN asg_details(p_ass_id, p_sess_date);
1645: FETCH asg_details into cur_asg_rec;
1646: IF asg_details%NOTFOUND THEN
1647: CLOSE asg_details;
1648: hr_utility.trace('no rows for cur_asg_rec');
1649: ELSE
1650: CLOSE asg_details;
1651: END IF;
1652: --

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

1650: CLOSE asg_details;
1651: END IF;
1652: --
1653:
1654: hr_utility.set_location(l_proc,357);
1655:
1656: pay_pog_all_assignments_pkg.after_update
1657: (p_effective_date => p_sess_date
1658: ,p_datetrack_mode => p_upd_mode

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

1993: ,P_PROJECTED_ASSIGNMENT_END_O
1994: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
1995: );
1996: --
1997: hr_utility.set_location('Leaving : '||l_proc,999);
1998: --
1999: end post_update;
2000: -----------------------------------------------------------------------------
2001: procedure post_insert(

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

2151: --
2152: l_proc varchar2(11) := 'post_insert';
2153: --
2154: begin
2155: g_debug := hr_utility.debug_enabled; -- get debug status
2156: IF g_debug THEN
2157: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
2158: END IF;
2159:

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

2153: --
2154: begin
2155: g_debug := hr_utility.debug_enabled; -- get debug status
2156: IF g_debug THEN
2157: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
2158: END IF;
2159:
2160: if p_prim_change_flag = 'Y' then
2161: --

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

2176: --
2177: end if;
2178: --
2179: IF g_debug THEN
2180: hr_utility.set_location( g_package || l_proc, 10);
2181: END IF;
2182: update_group(
2183: p_pg_id,
2184: p_group_name,

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

2184: p_group_name,
2185: p_bg_id);
2186: --
2187: IF g_debug THEN
2188: hr_utility.set_location( g_package || l_proc, 20);
2189: END IF;
2190: update_scl(
2191: p_scl_id,
2192: p_scl_concat);

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

2196: -- NB to_char(0)'s are last_updated_by and last_update_login which
2197: -- are varchar2 parameters in load_budget_values.
2198: --
2199: IF g_debug THEN
2200: hr_utility.set_location( g_package || l_proc, 30);
2201: END IF;
2202: hr_assignment.load_budget_values(
2203: p_ass_id,
2204: p_bg_id,

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

2209: --
2210: -- To load default assignment cost allocations
2211: --
2212: IF g_debug THEN
2213: hr_utility.set_location( g_package || l_proc, 40);
2214: END IF;
2215: declare
2216: l_position_id number;
2217: --

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

2225: fetch c_position into l_position_id;
2226: close c_position;
2227: --
2228: IF g_debug THEN
2229: hr_utility.set_location( g_package || l_proc, 45);
2230: END IF;
2231: hr_assignment.load_assignment_allocation
2232: (p_assignment_id => p_ass_id
2233: ,p_business_group_id => p_bg_id

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

2238: -- Insert element entries for new assignment, 1st 2 parameters are
2239: -- dt update and delete modes - ensure these are null.
2240: --
2241: IF g_debug THEN
2242: hr_utility.set_location( g_package || l_proc, 50);
2243: END IF;
2244: maintain_entries(
2245: null,
2246: null,

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

2277: -- handler user hook, hence has many parameters that are not available here.
2278: -- So a cursor is used to return the values, to pass to the pog procedure.
2279: --
2280: IF g_debug THEN
2281: hr_utility.set_location( g_package || l_proc, 60);
2282: END IF;
2283: OPEN asg_details(p_ass_id, p_sess_date);
2284: FETCH asg_details into ins_asg_rec;
2285: IF asg_details%NOTFOUND THEN

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

2283: OPEN asg_details(p_ass_id, p_sess_date);
2284: FETCH asg_details into ins_asg_rec;
2285: IF asg_details%NOTFOUND THEN
2286: CLOSE asg_details;
2287: hr_utility.trace('no rows for asg_details');
2288: ELSE
2289: CLOSE asg_details;
2290: END IF;
2291: --

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

2289: CLOSE asg_details;
2290: END IF;
2291: --
2292: IF g_debug THEN
2293: hr_utility.set_location( g_package || l_proc, 70);
2294: END IF;
2295: dt_api.validate_dt_mode
2296: (p_effective_date => p_sess_date
2297: ,p_datetrack_mode => 'INSERT'

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

2302: ,p_validation_end_date => l_ved
2303: );
2304: --
2305: IF g_debug THEN
2306: hr_utility.set_location( g_package || l_proc, 80);
2307: END IF;
2308:
2309: pay_pog_all_assignments_pkg.after_insert
2310: (p_effective_date => p_sess_date

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

2422: ,P_PO_LINE_ID => ins_asg_rec.po_line_id
2423: ,P_PROJECTED_ASSIGNMENT_END => ins_asg_rec.projected_assignment_end
2424: );
2425: IF g_debug THEN
2426: hr_utility.set_location( 'Leaving ' || g_package || l_proc, 10);
2427: END IF;
2428:
2429: end post_insert;
2430: -----------------------------------------------------------------------------

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

2481: l_bg_id number;
2482: --
2483: begin
2484: --
2485: hr_utility.set_location('Entering : '||l_proc,10);
2486: --
2487: --
2488: hr_assignment_internal.maintain_spp_asg
2489: (p_assignment_id => p_ass_id

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

2492: ,p_validation_end_date => p_val_end_date
2493: ,p_grade_id => p_grd_id
2494: ,p_spp_delete_warning => l_future_spp_warnings);
2495: --
2496: hr_utility.set_location(l_proc,20);
2497: --
2498: if p_del_mode in ('FUTURE_CHANGE', 'DELETE_NEXT_CHANGE') then
2499: --
2500: l_calling_proc := 'POST_DELETE';

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

2498: if p_del_mode in ('FUTURE_CHANGE', 'DELETE_NEXT_CHANGE') then
2499: --
2500: l_calling_proc := 'POST_DELETE';
2501: --
2502: hr_utility.set_location(l_proc||' / '||p_del_mode,30);
2503: --
2504: future_del_cleanup
2505: (p_ass_id,
2506: p_grd_id,

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

2529: else
2530: --
2531: l_calling_proc := 'POST_DELETE';
2532: --
2533: hr_utility.set_location(l_proc,40);
2534:
2535: hr_assignment.del_ref_int_delete(
2536: p_ass_id,
2537: p_grd_id,

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

2569: -- deleting them, as this improves performance.
2570: --
2571: l_calling_proc := 'POST_DELETE';
2572: --
2573: hr_utility.set_location(l_proc,50);
2574:
2575: hr_assignment.del_ref_int_delete(
2576: p_ass_id,
2577: null,

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

2587: end if;
2588: --
2589: if p_prim_change_flag = 'Y' then
2590: --
2591: hr_utility.set_location(l_proc,60);
2592:
2593: iud_update_primary(
2594: p_del_mode,
2595: p_new_prim_flag,

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

2621: end if;
2622: --
2623: end if;
2624: --
2625: hr_utility.set_location(l_proc,70);
2626:
2627: do_cancel_reterm(
2628: p_ass_id,
2629: p_bg_id,

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

2633: p_reterm_lspd);
2634: --
2635: -- Pass null p_upd_mode.
2636: --
2637: hr_utility.set_location(l_proc,80);
2638:
2639: maintain_entries
2640: (null,
2641: p_del_mode,

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

2685: -- So a cursor is used to return those values that are not available to this
2686: -- procedure. The 'old' values have been selected into a record in the
2687: -- pre_delete procedure
2688: --
2689: hr_utility.set_location(l_proc,90);
2690: OPEN cur_asg_details(p_ass_id, p_sess_date);
2691: FETCH cur_asg_details into l_esd, l_ovn, l_bg_id;
2692: IF cur_asg_details%NOTFOUND THEN
2693: CLOSE cur_asg_details;

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

2690: OPEN cur_asg_details(p_ass_id, p_sess_date);
2691: FETCH cur_asg_details into l_esd, l_ovn, l_bg_id;
2692: IF cur_asg_details%NOTFOUND THEN
2693: CLOSE cur_asg_details;
2694: hr_utility.trace('no rows from cur_asg_details');
2695: --
2696: -- if ZAP mode no rows returned, setup l_ovn and l_esd
2697: --
2698: IF p_del_mode = 'ZAP' THEN

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

2698: IF p_del_mode = 'ZAP' THEN
2699: l_ovn := per_assignments_f2_pkg.g_old_asg_rec.object_version_number;
2700: l_esd := per_assignments_f2_pkg.g_old_asg_rec.effective_start_date;
2701: ELSE
2702: hr_utility.trace('Not zap - error');
2703: END IF;
2704: ELSE
2705: CLOSE cur_asg_details;
2706: END IF;

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

2706: END IF;
2707: --
2708: -- call temporary POG package
2709: --
2710: hr_utility.set_location(l_proc,100);
2711: pay_pog_all_assignments_pkg.after_delete
2712: (p_effective_date => p_sess_date
2713: ,p_datetrack_mode => p_del_mode
2714: ,p_validation_start_date => p_val_st_date

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

2939: ,P_PROJECTED_ASSIGNMENT_END_O
2940: => per_assignments_f2_pkg.g_old_asg_rec.projected_assignment_end
2941: );
2942: --
2943: hr_utility.set_location('Leaving : '||l_proc,999);
2944: --
2945: end post_delete;
2946: -----------------------------------------------------------------------------
2947: END PER_ASSIGNMENTS_F1_PKG;