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

Line 189: hr_utility.set_location(p_placement_id,191);

185: and p_effective_date between effective_start_date
186: and effective_end_date;
187:
188: begin
189: hr_utility.set_location(p_placement_id,191);
190: hr_utility.set_location(p_effective_start_date,192);
191: hr_utility.set_location(p_effective_end_date,193);
192: hr_utility.set_location(p_assignment_id,194);
193: hr_utility.set_location(p_parent_spine_id,195);

Line 190: hr_utility.set_location(p_effective_start_date,192);

186: and effective_end_date;
187:
188: begin
189: hr_utility.set_location(p_placement_id,191);
190: hr_utility.set_location(p_effective_start_date,192);
191: hr_utility.set_location(p_effective_end_date,193);
192: hr_utility.set_location(p_assignment_id,194);
193: hr_utility.set_location(p_parent_spine_id,195);
194: hr_utility.set_location(p_increment_number,196);

Line 191: hr_utility.set_location(p_effective_end_date,193);

187:
188: begin
189: hr_utility.set_location(p_placement_id,191);
190: hr_utility.set_location(p_effective_start_date,192);
191: hr_utility.set_location(p_effective_end_date,193);
192: hr_utility.set_location(p_assignment_id,194);
193: hr_utility.set_location(p_parent_spine_id,195);
194: hr_utility.set_location(p_increment_number,196);
195: hr_utility.set_location(p_original_increment_number,197);

Line 192: hr_utility.set_location(p_assignment_id,194);

188: begin
189: hr_utility.set_location(p_placement_id,191);
190: hr_utility.set_location(p_effective_start_date,192);
191: hr_utility.set_location(p_effective_end_date,193);
192: hr_utility.set_location(p_assignment_id,194);
193: hr_utility.set_location(p_parent_spine_id,195);
194: hr_utility.set_location(p_increment_number,196);
195: hr_utility.set_location(p_original_increment_number,197);
196: hr_utility.set_location(p_sequence_number,198);

Line 193: hr_utility.set_location(p_parent_spine_id,195);

189: hr_utility.set_location(p_placement_id,191);
190: hr_utility.set_location(p_effective_start_date,192);
191: hr_utility.set_location(p_effective_end_date,193);
192: hr_utility.set_location(p_assignment_id,194);
193: hr_utility.set_location(p_parent_spine_id,195);
194: hr_utility.set_location(p_increment_number,196);
195: hr_utility.set_location(p_original_increment_number,197);
196: hr_utility.set_location(p_sequence_number,198);
197: hr_utility.set_location(p_next_sequence_number,199);

Line 194: hr_utility.set_location(p_increment_number,196);

190: hr_utility.set_location(p_effective_start_date,192);
191: hr_utility.set_location(p_effective_end_date,193);
192: hr_utility.set_location(p_assignment_id,194);
193: hr_utility.set_location(p_parent_spine_id,195);
194: hr_utility.set_location(p_increment_number,196);
195: hr_utility.set_location(p_original_increment_number,197);
196: hr_utility.set_location(p_sequence_number,198);
197: hr_utility.set_location(p_next_sequence_number,199);
198: hr_utility.set_location(p_spinal_point_id,200);

Line 195: hr_utility.set_location(p_original_increment_number,197);

191: hr_utility.set_location(p_effective_end_date,193);
192: hr_utility.set_location(p_assignment_id,194);
193: hr_utility.set_location(p_parent_spine_id,195);
194: hr_utility.set_location(p_increment_number,196);
195: hr_utility.set_location(p_original_increment_number,197);
196: hr_utility.set_location(p_sequence_number,198);
197: hr_utility.set_location(p_next_sequence_number,199);
198: hr_utility.set_location(p_spinal_point_id,200);
199: hr_utility.set_location(p_step_id,201);

Line 196: hr_utility.set_location(p_sequence_number,198);

192: hr_utility.set_location(p_assignment_id,194);
193: hr_utility.set_location(p_parent_spine_id,195);
194: hr_utility.set_location(p_increment_number,196);
195: hr_utility.set_location(p_original_increment_number,197);
196: hr_utility.set_location(p_sequence_number,198);
197: hr_utility.set_location(p_next_sequence_number,199);
198: hr_utility.set_location(p_spinal_point_id,200);
199: hr_utility.set_location(p_step_id,201);
200: hr_utility.set_location(p_new_step_id,202);

Line 197: hr_utility.set_location(p_next_sequence_number,199);

193: hr_utility.set_location(p_parent_spine_id,195);
194: hr_utility.set_location(p_increment_number,196);
195: hr_utility.set_location(p_original_increment_number,197);
196: hr_utility.set_location(p_sequence_number,198);
197: hr_utility.set_location(p_next_sequence_number,199);
198: hr_utility.set_location(p_spinal_point_id,200);
199: hr_utility.set_location(p_step_id,201);
200: hr_utility.set_location(p_new_step_id,202);
201: --

Line 198: hr_utility.set_location(p_spinal_point_id,200);

194: hr_utility.set_location(p_increment_number,196);
195: hr_utility.set_location(p_original_increment_number,197);
196: hr_utility.set_location(p_sequence_number,198);
197: hr_utility.set_location(p_next_sequence_number,199);
198: hr_utility.set_location(p_spinal_point_id,200);
199: hr_utility.set_location(p_step_id,201);
200: hr_utility.set_location(p_new_step_id,202);
201: --
202: -- get the full name and assignment number of the employee

Line 199: hr_utility.set_location(p_step_id,201);

195: hr_utility.set_location(p_original_increment_number,197);
196: hr_utility.set_location(p_sequence_number,198);
197: hr_utility.set_location(p_next_sequence_number,199);
198: hr_utility.set_location(p_spinal_point_id,200);
199: hr_utility.set_location(p_step_id,201);
200: hr_utility.set_location(p_new_step_id,202);
201: --
202: -- get the full name and assignment number of the employee
203: --

Line 200: hr_utility.set_location(p_new_step_id,202);

196: hr_utility.set_location(p_sequence_number,198);
197: hr_utility.set_location(p_next_sequence_number,199);
198: hr_utility.set_location(p_spinal_point_id,200);
199: hr_utility.set_location(p_step_id,201);
200: hr_utility.set_location(p_new_step_id,202);
201: --
202: -- get the full name and assignment number of the employee
203: --
204: hr_utility.set_location('full name and assignment number',120);

Line 204: hr_utility.set_location('full name and assignment number',120);

200: hr_utility.set_location(p_new_step_id,202);
201: --
202: -- get the full name and assignment number of the employee
203: --
204: hr_utility.set_location('full name and assignment number',120);
205: select distinct substr(pap.full_name,1,60),paa.assignment_number,paa.payroll_id,
206: substr(org.name ,1,60)
207: into l_full_name,l_assignment_number,l_payroll_id,l_org_name
208: from per_all_people_f pap,

Line 223: hr_utility.set_location(' Pay scale name',121);

219:
220: --
221: -- get the pay scale name
222: --
223: hr_utility.set_location(' Pay scale name',121);
224: hr_utility.set_location('parent_spine_id'||p_parent_spine_id,121);
225: select pps.name
226: into l_pay_scale
227: from per_parent_spines pps

Line 224: hr_utility.set_location('parent_spine_id'||p_parent_spine_id,121);

220: --
221: -- get the pay scale name
222: --
223: hr_utility.set_location(' Pay scale name',121);
224: hr_utility.set_location('parent_spine_id'||p_parent_spine_id,121);
225: select pps.name
226: into l_pay_scale
227: from per_parent_spines pps
228: where pps.parent_spine_id = p_parent_spine_id;

Line 233: hr_utility.set_location('grade name',122);

229:
230: --
231: -- get the grade name
232: --
233: hr_utility.set_location('grade name',122);
234: select substr(pg.name,1,30),pgs.grade_spine_id
235: into l_grade_name,l_grade_spine_id
236: from per_grades_vl pg,
237: per_spinal_point_steps_f sps,

Line 251: hr_utility.set_location('max step_id for the pay scale',123);

247:
248: --
249: -- get the max step_id for the pay scale
250: --
251: hr_utility.set_location('max step_id for the pay scale',123);
252: select max(sps2.sequence)
253: into l_step_id
254: from per_spinal_point_steps_f sps2
255: where sps2.grade_spine_id = p_grade_spine_id

Line 263: hr_utility.set_location('ceiling step id for the assignment',124);

259: --
260: -- select the ceiling step id for the pay scale and the special
261: -- ceiling step id fro the assignment
262: --
263: hr_utility.set_location('ceiling step id for the assignment',124);
264: hr_utility.set_location('p_assignment_id:'||p_assignment_id,124);
265: hr_utility.set_location('p_new_step_id:'||p_new_step_id,124);
266: hr_utility.set_location('p_step_id:'||p_step_id,124);
267: hr_utility.set_location('p_effective_start_date:'||p_effective_start_date,124);

Line 264: hr_utility.set_location('p_assignment_id:'||p_assignment_id,124);

260: -- select the ceiling step id for the pay scale and the special
261: -- ceiling step id fro the assignment
262: --
263: hr_utility.set_location('ceiling step id for the assignment',124);
264: hr_utility.set_location('p_assignment_id:'||p_assignment_id,124);
265: hr_utility.set_location('p_new_step_id:'||p_new_step_id,124);
266: hr_utility.set_location('p_step_id:'||p_step_id,124);
267: hr_utility.set_location('p_effective_start_date:'||p_effective_start_date,124);
268: --

Line 265: hr_utility.set_location('p_new_step_id:'||p_new_step_id,124);

261: -- ceiling step id fro the assignment
262: --
263: hr_utility.set_location('ceiling step id for the assignment',124);
264: hr_utility.set_location('p_assignment_id:'||p_assignment_id,124);
265: hr_utility.set_location('p_new_step_id:'||p_new_step_id,124);
266: hr_utility.set_location('p_step_id:'||p_step_id,124);
267: hr_utility.set_location('p_effective_start_date:'||p_effective_start_date,124);
268: --
269: select distinct pgs.ceiling_step_id,

Line 266: hr_utility.set_location('p_step_id:'||p_step_id,124);

262: --
263: hr_utility.set_location('ceiling step id for the assignment',124);
264: hr_utility.set_location('p_assignment_id:'||p_assignment_id,124);
265: hr_utility.set_location('p_new_step_id:'||p_new_step_id,124);
266: hr_utility.set_location('p_step_id:'||p_step_id,124);
267: hr_utility.set_location('p_effective_start_date:'||p_effective_start_date,124);
268: --
269: select distinct pgs.ceiling_step_id,
270: nvl(paa.special_ceiling_step_id,pgs.ceiling_step_id)

Line 267: hr_utility.set_location('p_effective_start_date:'||p_effective_start_date,124);

263: hr_utility.set_location('ceiling step id for the assignment',124);
264: hr_utility.set_location('p_assignment_id:'||p_assignment_id,124);
265: hr_utility.set_location('p_new_step_id:'||p_new_step_id,124);
266: hr_utility.set_location('p_step_id:'||p_step_id,124);
267: hr_utility.set_location('p_effective_start_date:'||p_effective_start_date,124);
268: --
269: select distinct pgs.ceiling_step_id,
270: nvl(paa.special_ceiling_step_id,pgs.ceiling_step_id)
271: into l_ceiling_step_id, l_special_ceiling_step_id

Line 290: hr_utility.set_location('CEILINGS - Special: '||l_special_ceiling_step_id,125);

286: and sps.effective_end_date
287: and p_effective_start_date between spp.effective_start_date
288: and spp.effective_end_date;
289: --
290: hr_utility.set_location('CEILINGS - Special: '||l_special_ceiling_step_id,125);
291: hr_utility.set_location('Pay Scale Ceiling : '||l_ceiling_step_id,125);
292: hr_utility.set_location('Entering csr_sequence_number',125);
293: hr_utility.set_location('Lookup Code : '||l_lookup_code,125);
294: --

Line 291: hr_utility.set_location('Pay Scale Ceiling : '||l_ceiling_step_id,125);

287: and p_effective_start_date between spp.effective_start_date
288: and spp.effective_end_date;
289: --
290: hr_utility.set_location('CEILINGS - Special: '||l_special_ceiling_step_id,125);
291: hr_utility.set_location('Pay Scale Ceiling : '||l_ceiling_step_id,125);
292: hr_utility.set_location('Entering csr_sequence_number',125);
293: hr_utility.set_location('Lookup Code : '||l_lookup_code,125);
294: --
295: -- Set the lookup code for the reason for employee being included in

Line 292: hr_utility.set_location('Entering csr_sequence_number',125);

288: and spp.effective_end_date;
289: --
290: hr_utility.set_location('CEILINGS - Special: '||l_special_ceiling_step_id,125);
291: hr_utility.set_location('Pay Scale Ceiling : '||l_ceiling_step_id,125);
292: hr_utility.set_location('Entering csr_sequence_number',125);
293: hr_utility.set_location('Lookup Code : '||l_lookup_code,125);
294: --
295: -- Set the lookup code for the reason for employee being included in
296: -- the report

Line 293: hr_utility.set_location('Lookup Code : '||l_lookup_code,125);

289: --
290: hr_utility.set_location('CEILINGS - Special: '||l_special_ceiling_step_id,125);
291: hr_utility.set_location('Pay Scale Ceiling : '||l_ceiling_step_id,125);
292: hr_utility.set_location('Entering csr_sequence_number',125);
293: hr_utility.set_location('Lookup Code : '||l_lookup_code,125);
294: --
295: -- Set the lookup code for the reason for employee being included in
296: -- the report
297: --

Line 303: hr_utility.set_location('opening cursor',125);

299: -- ------------------------------------------------------------------
300: -- Open cursor to discover if future record existed.
301: -- ------------------------------------------------------------------
302: open csr_sequence_number;
303: hr_utility.set_location('opening cursor',125);
304: fetch csr_sequence_number into l_sequence_number,l_parent_spine_id;
305: if csr_sequence_number%found then
306: hr_utility.set_location('cursor found',126);
307: hr_utility.set_location('l_sequence_number'||l_sequence_number,126);

Line 306: hr_utility.set_location('cursor found',126);

302: open csr_sequence_number;
303: hr_utility.set_location('opening cursor',125);
304: fetch csr_sequence_number into l_sequence_number,l_parent_spine_id;
305: if csr_sequence_number%found then
306: hr_utility.set_location('cursor found',126);
307: hr_utility.set_location('l_sequence_number'||l_sequence_number,126);
308: hr_utility.set_location('p_sequence_number:'||p_sequence_number,126);
309: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,126);
310: hr_utility.set_location('l_parent_spine_id'||l_parent_spine_id,126);

Line 307: hr_utility.set_location('l_sequence_number'||l_sequence_number,126);

303: hr_utility.set_location('opening cursor',125);
304: fetch csr_sequence_number into l_sequence_number,l_parent_spine_id;
305: if csr_sequence_number%found then
306: hr_utility.set_location('cursor found',126);
307: hr_utility.set_location('l_sequence_number'||l_sequence_number,126);
308: hr_utility.set_location('p_sequence_number:'||p_sequence_number,126);
309: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,126);
310: hr_utility.set_location('l_parent_spine_id'||l_parent_spine_id,126);
311: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,126);

Line 308: hr_utility.set_location('p_sequence_number:'||p_sequence_number,126);

304: fetch csr_sequence_number into l_sequence_number,l_parent_spine_id;
305: if csr_sequence_number%found then
306: hr_utility.set_location('cursor found',126);
307: hr_utility.set_location('l_sequence_number'||l_sequence_number,126);
308: hr_utility.set_location('p_sequence_number:'||p_sequence_number,126);
309: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,126);
310: hr_utility.set_location('l_parent_spine_id'||l_parent_spine_id,126);
311: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,126);
312: hr_utility.set_location('p_increment_number:'||p_increment_number,126);

Line 309: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,126);

305: if csr_sequence_number%found then
306: hr_utility.set_location('cursor found',126);
307: hr_utility.set_location('l_sequence_number'||l_sequence_number,126);
308: hr_utility.set_location('p_sequence_number:'||p_sequence_number,126);
309: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,126);
310: hr_utility.set_location('l_parent_spine_id'||l_parent_spine_id,126);
311: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,126);
312: hr_utility.set_location('p_increment_number:'||p_increment_number,126);
313: -- ------------------------------------------------------------------

Line 310: hr_utility.set_location('l_parent_spine_id'||l_parent_spine_id,126);

306: hr_utility.set_location('cursor found',126);
307: hr_utility.set_location('l_sequence_number'||l_sequence_number,126);
308: hr_utility.set_location('p_sequence_number:'||p_sequence_number,126);
309: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,126);
310: hr_utility.set_location('l_parent_spine_id'||l_parent_spine_id,126);
311: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,126);
312: hr_utility.set_location('p_increment_number:'||p_increment_number,126);
313: -- ------------------------------------------------------------------
314: -- update done as sequence number <= next sequence number

Line 311: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,126);

307: hr_utility.set_location('l_sequence_number'||l_sequence_number,126);
308: hr_utility.set_location('p_sequence_number:'||p_sequence_number,126);
309: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,126);
310: hr_utility.set_location('l_parent_spine_id'||l_parent_spine_id,126);
311: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,126);
312: hr_utility.set_location('p_increment_number:'||p_increment_number,126);
313: -- ------------------------------------------------------------------
314: -- update done as sequence number <= next sequence number
315: -- l_sequence_number = sequence number of next record for placement

Line 312: hr_utility.set_location('p_increment_number:'||p_increment_number,126);

308: hr_utility.set_location('p_sequence_number:'||p_sequence_number,126);
309: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,126);
310: hr_utility.set_location('l_parent_spine_id'||l_parent_spine_id,126);
311: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,126);
312: hr_utility.set_location('p_increment_number:'||p_increment_number,126);
313: -- ------------------------------------------------------------------
314: -- update done as sequence number <= next sequence number
315: -- l_sequence_number = sequence number of next record for placement
316: -- ------------------------------------------------------------------

Line 320: hr_utility.set_location('Insert done but flagged as future change',127);

316: -- ------------------------------------------------------------------
317: if l_sequence_number >= p_sequence_number
318: and l_parent_spine_id = p_parent_spine_id
319: and l_grade_spine_id = p_grade_spine_id then
320: hr_utility.set_location('Insert done but flagged as future change',127);
321: l_lookup_code := 'EXC_INC_1';
322: -- ------------------------------------------------------------------
323: -- Check that ceiling step id hasn't been reached
324: -- ------------------------------------------------------------------

Line 326: hr_utility.set_location('Ceiling step id reached',130);

322: -- ------------------------------------------------------------------
323: -- Check that ceiling step id hasn't been reached
324: -- ------------------------------------------------------------------
325: elsif (p_new_step_id = l_ceiling_step_id) then
326: hr_utility.set_location('Ceiling step id reached',130);
327: l_lookup_code := 'EXC_INC_2';
328: -- ------------------------------------------------------------------
329: -- Check that special ceiling step id hasn't been reached
330: -- ------------------------------------------------------------------

Line 332: hr_utility.set_location('Special ceiling step id reached',131);

328: -- ------------------------------------------------------------------
329: -- Check that special ceiling step id hasn't been reached
330: -- ------------------------------------------------------------------
331: elsif (p_new_step_id = l_special_ceiling_step_id) then
332: hr_utility.set_location('Special ceiling step id reached',131);
333: l_lookup_code := 'EXC_INC_3';
334: -- ------------------------------------------------------------------
335: -- Check to see if max step id for pay scale reached
336: -- ------------------------------------------------------------------

Line 338: hr_utility.set_location('Max step id for pay scale reached',132);

334: -- ------------------------------------------------------------------
335: -- Check to see if max step id for pay scale reached
336: -- ------------------------------------------------------------------
337: elsif (l_step_id = p_new_step_id) then
338: hr_utility.set_location('Max step id for pay scale reached',132);
339: l_lookup_code := 'EXC_INC_4';
340: -- ------------------------------------------------------------------
341: -- Check increment number was greater than the number of steps
342: -- available for the pay scale

Line 346: hr_utility.set_location('Increment number changed',129);

342: -- available for the pay scale
343: -- ------------------------------------------------------------------
344: elsif (p_original_increment_number <> p_increment_number)
345: and p_increment_number <> 0 then
346: hr_utility.set_location('Increment number changed',129);
347: l_lookup_code := 'EXC_INC_5';
348: -- ------------------------------------------------------------------
349: -- Future grade scale change
350: -- ------------------------------------------------------------------

Line 352: hr_utility.set_location('Future grade change',129);

348: -- ------------------------------------------------------------------
349: -- Future grade scale change
350: -- ------------------------------------------------------------------
351: elsif (p_grade_spine_id <> l_grade_spine_id) then
352: hr_utility.set_location('Future grade change',129);
353: l_lookup_code := 'EXC_INC_1';
354: end if;
355: --
356: elsif csr_sequence_number%notfound or

Line 368: hr_utility.set_location('cursor not found',127);

364: l_flag := 'N';
365: end if;
366: close csr_future_record;
367: --
368: hr_utility.set_location('cursor not found',127);
369: hr_utility.set_location('l_sequence_number:'||l_sequence_number,127);
370: hr_utility.set_location('p_sequence_number:'||p_sequence_number,127);
371: hr_utility.set_location('l_parent_spine_id:'||l_parent_spine_id,127);
372: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,127);

Line 369: hr_utility.set_location('l_sequence_number:'||l_sequence_number,127);

365: end if;
366: close csr_future_record;
367: --
368: hr_utility.set_location('cursor not found',127);
369: hr_utility.set_location('l_sequence_number:'||l_sequence_number,127);
370: hr_utility.set_location('p_sequence_number:'||p_sequence_number,127);
371: hr_utility.set_location('l_parent_spine_id:'||l_parent_spine_id,127);
372: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,127);
373: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,127);

Line 370: hr_utility.set_location('p_sequence_number:'||p_sequence_number,127);

366: close csr_future_record;
367: --
368: hr_utility.set_location('cursor not found',127);
369: hr_utility.set_location('l_sequence_number:'||l_sequence_number,127);
370: hr_utility.set_location('p_sequence_number:'||p_sequence_number,127);
371: hr_utility.set_location('l_parent_spine_id:'||l_parent_spine_id,127);
372: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,127);
373: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,127);
374: hr_utility.set_location('p_increment_number:'||p_increment_number,127);

Line 371: hr_utility.set_location('l_parent_spine_id:'||l_parent_spine_id,127);

367: --
368: hr_utility.set_location('cursor not found',127);
369: hr_utility.set_location('l_sequence_number:'||l_sequence_number,127);
370: hr_utility.set_location('p_sequence_number:'||p_sequence_number,127);
371: hr_utility.set_location('l_parent_spine_id:'||l_parent_spine_id,127);
372: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,127);
373: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,127);
374: hr_utility.set_location('p_increment_number:'||p_increment_number,127);
375: hr_utility.set_location('***********************',127);

Line 372: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,127);

368: hr_utility.set_location('cursor not found',127);
369: hr_utility.set_location('l_sequence_number:'||l_sequence_number,127);
370: hr_utility.set_location('p_sequence_number:'||p_sequence_number,127);
371: hr_utility.set_location('l_parent_spine_id:'||l_parent_spine_id,127);
372: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,127);
373: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,127);
374: hr_utility.set_location('p_increment_number:'||p_increment_number,127);
375: hr_utility.set_location('***********************',127);
376: hr_utility.set_location('p_step_id:'||p_step_id,128);

Line 373: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,127);

369: hr_utility.set_location('l_sequence_number:'||l_sequence_number,127);
370: hr_utility.set_location('p_sequence_number:'||p_sequence_number,127);
371: hr_utility.set_location('l_parent_spine_id:'||l_parent_spine_id,127);
372: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,127);
373: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,127);
374: hr_utility.set_location('p_increment_number:'||p_increment_number,127);
375: hr_utility.set_location('***********************',127);
376: hr_utility.set_location('p_step_id:'||p_step_id,128);
377: hr_utility.set_location('l_ceiling_step_id:'||l_ceiling_step_id,128);

Line 374: hr_utility.set_location('p_increment_number:'||p_increment_number,127);

370: hr_utility.set_location('p_sequence_number:'||p_sequence_number,127);
371: hr_utility.set_location('l_parent_spine_id:'||l_parent_spine_id,127);
372: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,127);
373: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,127);
374: hr_utility.set_location('p_increment_number:'||p_increment_number,127);
375: hr_utility.set_location('***********************',127);
376: hr_utility.set_location('p_step_id:'||p_step_id,128);
377: hr_utility.set_location('l_ceiling_step_id:'||l_ceiling_step_id,128);
378: hr_utility.set_location('l_special_ceiling_step_id:'||l_special_ceiling_step_id,128);

Line 375: hr_utility.set_location('***********************',127);

371: hr_utility.set_location('l_parent_spine_id:'||l_parent_spine_id,127);
372: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,127);
373: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,127);
374: hr_utility.set_location('p_increment_number:'||p_increment_number,127);
375: hr_utility.set_location('***********************',127);
376: hr_utility.set_location('p_step_id:'||p_step_id,128);
377: hr_utility.set_location('l_ceiling_step_id:'||l_ceiling_step_id,128);
378: hr_utility.set_location('l_special_ceiling_step_id:'||l_special_ceiling_step_id,128);
379: hr_utility.set_location('l_step_id:'||l_step_id,128);

Line 376: hr_utility.set_location('p_step_id:'||p_step_id,128);

372: hr_utility.set_location('p_parent_spine_id:'||p_parent_spine_id,127);
373: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,127);
374: hr_utility.set_location('p_increment_number:'||p_increment_number,127);
375: hr_utility.set_location('***********************',127);
376: hr_utility.set_location('p_step_id:'||p_step_id,128);
377: hr_utility.set_location('l_ceiling_step_id:'||l_ceiling_step_id,128);
378: hr_utility.set_location('l_special_ceiling_step_id:'||l_special_ceiling_step_id,128);
379: hr_utility.set_location('l_step_id:'||l_step_id,128);
380: hr_utility.set_location('l_flag:'||l_flag,128);

Line 377: hr_utility.set_location('l_ceiling_step_id:'||l_ceiling_step_id,128);

373: hr_utility.set_location('p_original_increment_number:'||p_original_increment_number,127);
374: hr_utility.set_location('p_increment_number:'||p_increment_number,127);
375: hr_utility.set_location('***********************',127);
376: hr_utility.set_location('p_step_id:'||p_step_id,128);
377: hr_utility.set_location('l_ceiling_step_id:'||l_ceiling_step_id,128);
378: hr_utility.set_location('l_special_ceiling_step_id:'||l_special_ceiling_step_id,128);
379: hr_utility.set_location('l_step_id:'||l_step_id,128);
380: hr_utility.set_location('l_flag:'||l_flag,128);
381: --

Line 378: hr_utility.set_location('l_special_ceiling_step_id:'||l_special_ceiling_step_id,128);

374: hr_utility.set_location('p_increment_number:'||p_increment_number,127);
375: hr_utility.set_location('***********************',127);
376: hr_utility.set_location('p_step_id:'||p_step_id,128);
377: hr_utility.set_location('l_ceiling_step_id:'||l_ceiling_step_id,128);
378: hr_utility.set_location('l_special_ceiling_step_id:'||l_special_ceiling_step_id,128);
379: hr_utility.set_location('l_step_id:'||l_step_id,128);
380: hr_utility.set_location('l_flag:'||l_flag,128);
381: --
382: -- ------------------------------------------------------------------

Line 379: hr_utility.set_location('l_step_id:'||l_step_id,128);

375: hr_utility.set_location('***********************',127);
376: hr_utility.set_location('p_step_id:'||p_step_id,128);
377: hr_utility.set_location('l_ceiling_step_id:'||l_ceiling_step_id,128);
378: hr_utility.set_location('l_special_ceiling_step_id:'||l_special_ceiling_step_id,128);
379: hr_utility.set_location('l_step_id:'||l_step_id,128);
380: hr_utility.set_location('l_flag:'||l_flag,128);
381: --
382: -- ------------------------------------------------------------------
383: -- Check if record not inserted

Line 380: hr_utility.set_location('l_flag:'||l_flag,128);

376: hr_utility.set_location('p_step_id:'||p_step_id,128);
377: hr_utility.set_location('l_ceiling_step_id:'||l_ceiling_step_id,128);
378: hr_utility.set_location('l_special_ceiling_step_id:'||l_special_ceiling_step_id,128);
379: hr_utility.set_location('l_step_id:'||l_step_id,128);
380: hr_utility.set_location('l_flag:'||l_flag,128);
381: --
382: -- ------------------------------------------------------------------
383: -- Check if record not inserted
384: -- ------------------------------------------------------------------

Line 390: hr_utility.set_location('No insert done as future change',128);

386: and l_flag = 'Y'
387: and p_new_step_id <> l_ceiling_step_id
388: and p_new_step_id <> l_special_ceiling_step_id
389: and p_new_step_id <> l_step_id then
390: hr_utility.set_location('No insert done as future change',128);
391: l_lookup_code := 'EXC_4';
392: -- ------------------------------------------------------------------
393: -- Check that ceiling step id hasn't been reached
394: -- ------------------------------------------------------------------

Line 399: hr_utility.set_location('Ceiling step id reached',130);

395: elsif (p_new_step_id = l_ceiling_step_id) then
396: if p_update = 'Y' then
397: l_lookup_code := 'EXC_INC_2';
398: else
399: hr_utility.set_location('Ceiling step id reached',130);
400: l_lookup_code := 'EXC_1';
401: end if;
402: -- ------------------------------------------------------------------
403: -- Check that special ceiling step id hasn't been reached

Line 409: hr_utility.set_location('Special ceiling step id reached',131);

405: elsif (p_new_step_id = l_special_ceiling_step_id) then
406: if p_update = 'Y' then
407: l_lookup_code := 'EXC_INC_3';
408: else
409: hr_utility.set_location('Special ceiling step id reached',131);
410: l_lookup_code := 'EXC_2';
411: end if;
412: -- ------------------------------------------------------------------
413: -- Check to see if max step id for pay scale reached

Line 419: hr_utility.set_location('Max step id for pay scale reached',132);

415: elsif (l_step_id = p_new_step_id) then
416: if p_update = 'Y' then
417: l_lookup_code := 'EXC_INC_4';
418: else
419: hr_utility.set_location('Max step id for pay scale reached',132);
420: l_lookup_code := 'EXC_3';
421: end if;
422: end if;
423: end if;

Line 432: hr_utility.set_location('No payroll set when using business rule for next pay period.',133);

428: -- ----------------------------------------------------------------------
429:
430: if l_lookup_code is null and l_payroll_id is null then
431:
432: hr_utility.set_location('No payroll set when using business rule for next pay period.',133);
433: l_lookup_code := 'EXC_5';
434:
435: end if;
436: