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 187: hr_utility.set_location(p_placement_id,191);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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