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

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

40: (asg.effective_start_date <= p_validation_start_date
41: and effective_end_date >=p_validation_end_date))
42: );
43: begin
44: hr_utility.set_location('Entering '||l_proc,10);
45: open c1;
46: fetch c1 into l_dummy;
47: if c1%found then
48: close c1;

Line 49: hr_utility.set_location('Leaveing '||l_proc,11);

45: open c1;
46: fetch c1 into l_dummy;
47: if c1%found then
48: close c1;
49: hr_utility.set_location('Leaveing '||l_proc,11);
50: return true;
51: end if;
52: close c1;
53: hr_utility.set_location('Leaveing '||l_proc,12);

Line 53: hr_utility.set_location('Leaveing '||l_proc,12);

49: hr_utility.set_location('Leaveing '||l_proc,11);
50: return true;
51: end if;
52: close c1;
53: hr_utility.set_location('Leaveing '||l_proc,12);
54: return false;
55: end pos_assignments_exist;
56: --
57: --

Line 76: hr_utility.set_location('Check position is submitted for PC Org validation rule:', 630);

72: --
73: begin
74: null;
75: /*
76: hr_utility.set_location('Check position is submitted for PC Org validation rule:', 630);
77: --
78: if p_rec.position_transaction_id is not null then
79: open c_position_transaction(p_rec.position_transaction_id);
80: fetch c_position_transaction into l_transaction_status;

Line 82: hr_utility.set_message(8302, 'PQH_NO_SUBMIT_CANT_CRE_POS');

78: if p_rec.position_transaction_id is not null then
79: open c_position_transaction(p_rec.position_transaction_id);
80: fetch c_position_transaction into l_transaction_status;
81: if (l_transaction_status <> 'SUBMITTED') then
82: hr_utility.set_message(8302, 'PQH_NO_SUBMIT_CANT_CRE_POS');
83: hr_utility.raise_error;
84: end if;
85: end if;
86: */

Line 83: hr_utility.raise_error;

79: open c_position_transaction(p_rec.position_transaction_id);
80: fetch c_position_transaction into l_transaction_status;
81: if (l_transaction_status <> 'SUBMITTED') then
82: hr_utility.set_message(8302, 'PQH_NO_SUBMIT_CANT_CRE_POS');
83: hr_utility.raise_error;
84: end if;
85: end if;
86: */
87: --

Line 150: hr_utility.set_message(8302, 'PQH_NO_SUBMIT_CANT_CRE_POS');

146: if p_rec.position_transaction_id is not null then
147: open c_position_transaction(p_rec.position_transaction_id);
148: fetch c_position_transaction into l_transaction_status;
149: if (l_transaction_status <> 'SUBMITTED') then
150: hr_utility.set_message(8302, 'PQH_NO_SUBMIT_CANT_CRE_POS');
151: hr_utility.raise_error;
152: end if;
153: end if;
154: */

Line 151: hr_utility.raise_error;

147: open c_position_transaction(p_rec.position_transaction_id);
148: fetch c_position_transaction into l_transaction_status;
149: if (l_transaction_status <> 'SUBMITTED') then
150: hr_utility.set_message(8302, 'PQH_NO_SUBMIT_CANT_CRE_POS');
151: hr_utility.raise_error;
152: end if;
153: end if;
154: */
155: --

Line 158: hr_utility.set_location('AVAILABILITY_STATUS_ID :'||p_rec.availability_status_id, 620);

154: */
155: --
156: --
157: --
158: hr_utility.set_location('AVAILABILITY_STATUS_ID :'||p_rec.availability_status_id, 620);
159:
160: if ((p_datetrack_mode IN ('CORRECTION', 'UPDATE','UPDATE_CHANGE_INSERT',
161: 'UPDATE_OVERRIDE')) AND
162: ('ELIMINATED'=hr_psf_shd.get_availability_status(

Line 164: hr_utility.set_location('AVAILABILITY STATUS : ELIMINATED', 621);

160: if ((p_datetrack_mode IN ('CORRECTION', 'UPDATE','UPDATE_CHANGE_INSERT',
161: 'UPDATE_OVERRIDE')) AND
162: ('ELIMINATED'=hr_psf_shd.get_availability_status(
163: p_rec.availability_status_id,p_rec.business_group_id))) then
164: hr_utility.set_location('AVAILABILITY STATUS : ELIMINATED', 621);
165: if (pqh_psf_bus.pos_assignments_exist(p_rec.position_id,
166: p_validation_start_date, p_validation_end_date)) then
167: hr_utility.set_location('ASSIGNMENTS EXIST FOR ELIMINATED POSITION', 623);
168: pqh_utility.set_message(800,'PER_POS_ELIMINATED',p_rec.organization_id);

Line 167: hr_utility.set_location('ASSIGNMENTS EXIST FOR ELIMINATED POSITION', 623);

163: p_rec.availability_status_id,p_rec.business_group_id))) then
164: hr_utility.set_location('AVAILABILITY STATUS : ELIMINATED', 621);
165: if (pqh_psf_bus.pos_assignments_exist(p_rec.position_id,
166: p_validation_start_date, p_validation_end_date)) then
167: hr_utility.set_location('ASSIGNMENTS EXIST FOR ELIMINATED POSITION', 623);
168: pqh_utility.set_message(800,'PER_POS_ELIMINATED',p_rec.organization_id);
169: pqh_utility.raise_error;
170: end if;
171: end if;

Line 175: hr_utility.set_location('Check FTE validation rule:', 630);

171: end if;
172: --
173: --
174: --
175: hr_utility.set_location('Check FTE validation rule:', 630);
176: --
177: -- Check FTE Validation Rule
178: --
179: --

Line 180: hr_utility.set_location('p_validation_start_date:'||p_validation_start_date, 630);

176: --
177: -- Check FTE Validation Rule
178: --
179: --
180: hr_utility.set_location('p_validation_start_date:'||p_validation_start_date, 630);
181: hr_utility.set_location('p_validation_end_date:'||p_validation_end_date, 630);
182: --
183: if (p_rec.position_type = 'SHARED') then
184: --

Line 181: hr_utility.set_location('p_validation_end_date:'||p_validation_end_date, 630);

177: -- Check FTE Validation Rule
178: --
179: --
180: hr_utility.set_location('p_validation_start_date:'||p_validation_start_date, 630);
181: hr_utility.set_location('p_validation_end_date:'||p_validation_end_date, 630);
182: --
183: if (p_rec.position_type = 'SHARED') then
184: --
185: open c_asg_max_count(p_rec.position_id, p_validation_start_date, p_validation_end_date);

Line 188: hr_utility.set_location('l_max_count:'||l_asg_max_count, 630);

184: --
185: open c_asg_max_count(p_rec.position_id, p_validation_start_date, p_validation_end_date);
186: fetch c_asg_max_count into l_asg_max_count;
187: close c_asg_max_count;
188: hr_utility.set_location('l_max_count:'||l_asg_max_count, 630);
189: hr_utility.set_location('Position FTE:'||p_rec.fte, 630);
190: if (l_asg_max_count > p_rec.fte) then
191: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_FTE',p_rec.organization_id);
192: pqh_utility.raise_error;

Line 189: hr_utility.set_location('Position FTE:'||p_rec.fte, 630);

185: open c_asg_max_count(p_rec.position_id, p_validation_start_date, p_validation_end_date);
186: fetch c_asg_max_count into l_asg_max_count;
187: close c_asg_max_count;
188: hr_utility.set_location('l_max_count:'||l_asg_max_count, 630);
189: hr_utility.set_location('Position FTE:'||p_rec.fte, 630);
190: if (l_asg_max_count > p_rec.fte) then
191: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_FTE',p_rec.organization_id);
192: pqh_utility.raise_error;
193: end if;

Line 194: hr_utility.set_location('Check FTE validation rule:', 630);

190: if (l_asg_max_count > p_rec.fte) then
191: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_FTE',p_rec.organization_id);
192: pqh_utility.raise_error;
193: end if;
194: hr_utility.set_location('Check FTE validation rule:', 630);
195: --
196: end if;
197: --
198: hr_utility.set_location('Check Earliest hire date validation rule:', 640);

Line 198: hr_utility.set_location('Check Earliest hire date validation rule:', 640);

194: hr_utility.set_location('Check FTE validation rule:', 630);
195: --
196: end if;
197: --
198: hr_utility.set_location('Check Earliest hire date validation rule:', 640);
199: --
200: -- Check Earliest hire date validation rule
201: --
202: --

Line 209: hr_utility.set_location('Check Earliest hire date validation rule:', 640);

205: if (not l_chk_earliest_hire_date ) then
206: pqh_utility.set_message(8302,'PQH_ASG_HIRED_BEFORE_EARLIEST',p_rec.organization_id);
207: pqh_utility.raise_error;
208: end if;
209: hr_utility.set_location('Check Earliest hire date validation rule:', 640);
210: --
211: -- Check proposed date for layoff validation rule
212: --
213: --

Line 221: hr_utility.set_location('Check proposed date for layoff validation rule:', 650);

217: --pqh_utility.set_message(8302,'PQH_LAYOFF_DT_GT_ASG_DT',p_rec.organization_id);
218: pqh_utility.set_message(8302,'PQH_ASG_DT_GT_LAYOFF_DT',p_rec.organization_id);
219: pqh_utility.raise_error;
220: end if;
221: hr_utility.set_location('Check proposed date for layoff validation rule:', 650);
222: end;
223: --
224: -- ---------------------------------------------------------------------------
225: -- |-----------------< per_asg_bus_insert_validate >--------------------|

Line 259: hr_utility.set_location('Insert Validate: Before open Position', 100);

255: where position_id = p_position_id
256: and effective_start_date > p_effective_date;
257: --
258: BEGIN
259: hr_utility.set_location('Insert Validate: Before open Position', 100);
260: if (p_rec.position_id is not null) then
261: open c_position;
262: hr_utility.set_location('Insert Validate: After open before fetch Position', 110);
263: fetch c_position into l_rec;

Line 262: hr_utility.set_location('Insert Validate: After open before fetch Position', 110);

258: BEGIN
259: hr_utility.set_location('Insert Validate: Before open Position', 100);
260: if (p_rec.position_id is not null) then
261: open c_position;
262: hr_utility.set_location('Insert Validate: After open before fetch Position', 110);
263: fetch c_position into l_rec;
264: hr_utility.set_location('Insert Validate: After fetch Position', 120);
265: if ( c_position%found) then
266: close c_position;

Line 264: hr_utility.set_location('Insert Validate: After fetch Position', 120);

260: if (p_rec.position_id is not null) then
261: open c_position;
262: hr_utility.set_location('Insert Validate: After open before fetch Position', 110);
263: fetch c_position into l_rec;
264: hr_utility.set_location('Insert Validate: After fetch Position', 120);
265: if ( c_position%found) then
266: close c_position;
267: --
268: -- Check for Assignment attached to a Seasonal Position is with in seasonal dates

Line 270: hr_utility.set_location('Insert Validate: Before Seasonal Validation', 130);

266: close c_position;
267: --
268: -- Check for Assignment attached to a Seasonal Position is with in seasonal dates
269: --
270: hr_utility.set_location('Insert Validate: Before Seasonal Validation', 130);
271: if l_rec.seasonal_flag = 'Y' then
272: if not pqh_psf_bus.chk_seasonal_dates(
273: p_position_id => p_rec.position_id,
274: p_seasonal_flag => l_rec.seasonal_flag,

Line 283: hr_utility.set_location('Insert Validate: Before Assignment Grade', 130);

279: end if;
280: --
281: -- Check whether Assignment Grade is same as Position Grade.
282: --
283: hr_utility.set_location('Insert Validate: Before Assignment Grade', 130);
284: if p_rec.grade_id <> l_rec.entry_grade_id then
285: pqh_utility.set_message(8302,'PQH_NON_POSITION_GRADE',l_rec.organization_id);
286: pqh_utility.raise_error;
287: end if;

Line 291: hr_utility.set_location('Insert Validate: greater than earliest hire date', 130);

287: end if;
288: --
289: -- Check assignment start date to be greater than earliest hire date of the position
290: --
291: hr_utility.set_location('Insert Validate: greater than earliest hire date', 130);
292: if p_rec.effective_start_date < l_rec.earliest_hire_date then
293: pqh_utility.set_message(8302,'PQH_ASG_HIRED_BEFORE_EARLIEST',l_rec.organization_id);
294: pqh_utility.raise_error;
295: end if;

Line 299: hr_utility.set_location('Insert Validate: before proposed date for Layoff', 130);

295: end if;
296: --
297: -- Check whether assignment date is before proposed date for Layoff
298: --
299: hr_utility.set_location('Insert Validate: before proposed date for Layoff', 130);
300: if (p_rec.effective_start_date > l_rec.proposed_date_for_layoff ) then
301: pqh_utility.set_message(8302,'PQH_ASG_DT_GT_LAYOFF_DT',l_rec.organization_id);
302: pqh_utility.raise_error;
303: end if;

Line 307: hr_utility.set_location('Insert Validate: SHARED position has FTE greater than', 130);

303: end if;
304: --
305: -- Validate whether a SHARED position has FTE greater than the sum of the budgeted FTE's attached to the Position
306: --
307: hr_utility.set_location('Insert Validate: SHARED position has FTE greater than', 130);
308: if (l_rec.position_type = 'SHARED') then
309: --
310: l_default_asg_fte := pqh_psf_bus.default_assignment_fte(p_rec.business_group_id);
311: --

Line 326: hr_utility.set_location('l_default_asg_fte :'||l_default_asg_fte, 135);

322: l_default_asg_fte := 1;
323: end if;
324: --
325: if not l_bgt_lt_abv_fte then
326: hr_utility.set_location('l_default_asg_fte :'||l_default_asg_fte, 135);
327: pqh_psf_bus.chk_future_pos_asg_fte(
328: p_assignment_id => p_rec.assignment_id,
329: p_position_id => p_rec.position_id,
330: p_validation_start_date => p_rec.effective_start_date,

Line 337: hr_utility.set_location('Insert Validate:Check Insert allowed', 130);

333: end if;
334: --
335: --Check Insert allowed..
336: --
337: hr_utility.set_location('Insert Validate:Check Insert allowed', 130);
338: if l_rec.position_type = 'POOLED' then
339: hr_utility.set_location('Insert Validate:POOLED', 130);
340: if pqh_psf_bus.open_status(p_rec.position_id, p_rec.effective_start_date) = 'OPEN' then
341: null;

Line 339: hr_utility.set_location('Insert Validate:POOLED', 130);

335: --Check Insert allowed..
336: --
337: hr_utility.set_location('Insert Validate:Check Insert allowed', 130);
338: if l_rec.position_type = 'POOLED' then
339: hr_utility.set_location('Insert Validate:POOLED', 130);
340: if pqh_psf_bus.open_status(p_rec.position_id, p_rec.effective_start_date) = 'OPEN' then
341: null;
342: else
343: pqh_utility.set_message(8302,'PQH_POOLED_POS_NOT_OPEN',l_rec.organization_id);

Line 346: hr_utility.set_location('Insert Validate:END POOLED', 130);

342: else
343: pqh_utility.set_message(8302,'PQH_POOLED_POS_NOT_OPEN',l_rec.organization_id);
344: pqh_utility.raise_error;
345: end if;
346: hr_utility.set_location('Insert Validate:END POOLED', 130);
347: elsif l_rec.position_type = 'SINGLE' or l_rec.position_type = 'SHARED' then
348: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
349: if pqh_psf_bus.open_status(p_rec.position_id, p_rec.effective_start_date) = 'OPEN' then
350: hr_utility.set_location('Insert Validate:OPEN', 130);

Line 348: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);

344: pqh_utility.raise_error;
345: end if;
346: hr_utility.set_location('Insert Validate:END POOLED', 130);
347: elsif l_rec.position_type = 'SINGLE' or l_rec.position_type = 'SHARED' then
348: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
349: if pqh_psf_bus.open_status(p_rec.position_id, p_rec.effective_start_date) = 'OPEN' then
350: hr_utility.set_location('Insert Validate:OPEN', 130);
351: if not l_bgt_lt_abv_fte then
352: hr_utility.set_location('p_rec.business_group_id : '||p_rec.business_group_id, 131);

Line 350: hr_utility.set_location('Insert Validate:OPEN', 130);

346: hr_utility.set_location('Insert Validate:END POOLED', 130);
347: elsif l_rec.position_type = 'SINGLE' or l_rec.position_type = 'SHARED' then
348: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
349: if pqh_psf_bus.open_status(p_rec.position_id, p_rec.effective_start_date) = 'OPEN' then
350: hr_utility.set_location('Insert Validate:OPEN', 130);
351: if not l_bgt_lt_abv_fte then
352: hr_utility.set_location('p_rec.business_group_id : '||p_rec.business_group_id, 131);
353: if l_rec.position_type = 'SINGLE' then
354: l_default_asg_fte := 1;

Line 352: hr_utility.set_location('p_rec.business_group_id : '||p_rec.business_group_id, 131);

348: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
349: if pqh_psf_bus.open_status(p_rec.position_id, p_rec.effective_start_date) = 'OPEN' then
350: hr_utility.set_location('Insert Validate:OPEN', 130);
351: if not l_bgt_lt_abv_fte then
352: hr_utility.set_location('p_rec.business_group_id : '||p_rec.business_group_id, 131);
353: if l_rec.position_type = 'SINGLE' then
354: l_default_asg_fte := 1;
355: else
356: l_default_asg_fte := pqh_psf_bus.default_assignment_fte(p_rec.business_group_id);

Line 358: hr_utility.set_location('l_default_asg_fte : '||l_default_asg_fte, 13);

354: l_default_asg_fte := 1;
355: else
356: l_default_asg_fte := pqh_psf_bus.default_assignment_fte(p_rec.business_group_id);
357: end if;
358: hr_utility.set_location('l_default_asg_fte : '||l_default_asg_fte, 13);
359: --
360: if chk_reserved_fte(p_rec.assignment_id, p_rec.person_id,
361: p_rec.position_id, l_rec.position_type,
362: p_rec.effective_start_date, l_default_asg_fte) then

Line 369: --hr_utility.set_location('POSITION RESERVED', 114);

365: p_rec.position_id,
366: p_rec.effective_start_date,
367: l_rec.organization_id,
368: l_default_asg_fte);
369: --hr_utility.set_location('POSITION RESERVED', 114);
370: --pqh_utility.set_message(8302,'PQH_POS_RESERVED',l_rec.organization_id);
371: --pqh_utility.raise_error;
372: else
373: l_future_res_date := chk_future_reserved_fte(p_rec.assignment_id, p_rec.person_id,

Line 377: hr_utility.set_message(8302,'PQH_POS_FUTURE_RESERVED');

373: l_future_res_date := chk_future_reserved_fte(p_rec.assignment_id, p_rec.person_id,
374: p_rec.position_id, l_rec.position_type,
375: p_rec.effective_start_date, hr_general.end_of_time, l_default_asg_fte);
376: if l_future_res_date is not null then
377: hr_utility.set_message(8302,'PQH_POS_FUTURE_RESERVED');
378: hr_utility.set_message_token('FUTURE_RESERVED_DATE', l_future_res_date);
379: pqh_utility.set_message_level_cd('W');
380: pqh_utility.raise_error;
381: end if;

Line 378: hr_utility.set_message_token('FUTURE_RESERVED_DATE', l_future_res_date);

374: p_rec.position_id, l_rec.position_type,
375: p_rec.effective_start_date, hr_general.end_of_time, l_default_asg_fte);
376: if l_future_res_date is not null then
377: hr_utility.set_message(8302,'PQH_POS_FUTURE_RESERVED');
378: hr_utility.set_message_token('FUTURE_RESERVED_DATE', l_future_res_date);
379: pqh_utility.set_message_level_cd('W');
380: pqh_utility.raise_error;
381: end if;
382: end if;

Line 385: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);

381: end if;
382: end if;
383: end if;
384: end if;
385: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
386: elsif (l_rec.position_type = 'NONE') then
387: null;
388: end if;
389: --

Line 391: hr_utility.set_location('Money Related Rule before chk_pos_budget', 135);

387: null;
388: end if;
389: --
390: /*
391: hr_utility.set_location('Money Related Rule before chk_pos_budget', 135);
392: l_chk_pos_budget := chk_pos_budget(p_rec.position_id, p_rec.effective_start_date);
393: hr_utility.set_location('Money Related Rule after chk_pos_budget', 136);
394: if not l_chk_pos_budget then
395: hr_utility.set_location('Money Related Rule failed', 140);

Line 393: hr_utility.set_location('Money Related Rule after chk_pos_budget', 136);

389: --
390: /*
391: hr_utility.set_location('Money Related Rule before chk_pos_budget', 135);
392: l_chk_pos_budget := chk_pos_budget(p_rec.position_id, p_rec.effective_start_date);
393: hr_utility.set_location('Money Related Rule after chk_pos_budget', 136);
394: if not l_chk_pos_budget then
395: hr_utility.set_location('Money Related Rule failed', 140);
396: pqh_utility.set_message(8302,'PQH_SUM_ASG_AMT_GT_BGT_AMT',l_rec.organization_id);
397: pqh_utility.raise_error;

Line 395: hr_utility.set_location('Money Related Rule failed', 140);

391: hr_utility.set_location('Money Related Rule before chk_pos_budget', 135);
392: l_chk_pos_budget := chk_pos_budget(p_rec.position_id, p_rec.effective_start_date);
393: hr_utility.set_location('Money Related Rule after chk_pos_budget', 136);
394: if not l_chk_pos_budget then
395: hr_utility.set_location('Money Related Rule failed', 140);
396: pqh_utility.set_message(8302,'PQH_SUM_ASG_AMT_GT_BGT_AMT',l_rec.organization_id);
397: pqh_utility.raise_error;
398: else
399: hr_utility.set_location('Money Related Rule success', 140);

Line 399: hr_utility.set_location('Money Related Rule success', 140);

395: hr_utility.set_location('Money Related Rule failed', 140);
396: pqh_utility.set_message(8302,'PQH_SUM_ASG_AMT_GT_BGT_AMT',l_rec.organization_id);
397: pqh_utility.raise_error;
398: else
399: hr_utility.set_location('Money Related Rule success', 140);
400: end if;
401: */
402: else
403: close c_position;

Line 407: hr_utility.set_location('per_asg_insert_validate End',400);

403: close c_position;
404: end if;
405: end if;
406: --
407: hr_utility.set_location('per_asg_insert_validate End',400);
408: END;
409: --
410: -- ---------------------------------------------------------------------------
411: -- |-----------------< per_asg_bus_update_validate >--------------------|

Line 453: hr_utility.set_location('Entering Procedure PQH_PSF_BUS ', 100);

449: where position_id = p_position_id
450: and effective_start_date > p_effective_date;
451: --
452: BEGIN
453: hr_utility.set_location('Entering Procedure PQH_PSF_BUS ', 100);
454: hr_utility.set_location('p_validation_start_date '||p_validation_start_date, 101);
455: hr_utility.set_location('p_validation_end_date '||p_validation_end_date, 101);
456: hr_utility.set_location('p_effective_date '||p_effective_date, 101);
457: hr_utility.set_location('p_datetrack_mode '||p_datetrack_mode, 101);

Line 454: hr_utility.set_location('p_validation_start_date '||p_validation_start_date, 101);

450: and effective_start_date > p_effective_date;
451: --
452: BEGIN
453: hr_utility.set_location('Entering Procedure PQH_PSF_BUS ', 100);
454: hr_utility.set_location('p_validation_start_date '||p_validation_start_date, 101);
455: hr_utility.set_location('p_validation_end_date '||p_validation_end_date, 101);
456: hr_utility.set_location('p_effective_date '||p_effective_date, 101);
457: hr_utility.set_location('p_datetrack_mode '||p_datetrack_mode, 101);
458:

Line 455: hr_utility.set_location('p_validation_end_date '||p_validation_end_date, 101);

451: --
452: BEGIN
453: hr_utility.set_location('Entering Procedure PQH_PSF_BUS ', 100);
454: hr_utility.set_location('p_validation_start_date '||p_validation_start_date, 101);
455: hr_utility.set_location('p_validation_end_date '||p_validation_end_date, 101);
456: hr_utility.set_location('p_effective_date '||p_effective_date, 101);
457: hr_utility.set_location('p_datetrack_mode '||p_datetrack_mode, 101);
458:
459: open c_position;

Line 456: hr_utility.set_location('p_effective_date '||p_effective_date, 101);

452: BEGIN
453: hr_utility.set_location('Entering Procedure PQH_PSF_BUS ', 100);
454: hr_utility.set_location('p_validation_start_date '||p_validation_start_date, 101);
455: hr_utility.set_location('p_validation_end_date '||p_validation_end_date, 101);
456: hr_utility.set_location('p_effective_date '||p_effective_date, 101);
457: hr_utility.set_location('p_datetrack_mode '||p_datetrack_mode, 101);
458:
459: open c_position;
460: fetch c_position into l_rec;

Line 457: hr_utility.set_location('p_datetrack_mode '||p_datetrack_mode, 101);

453: hr_utility.set_location('Entering Procedure PQH_PSF_BUS ', 100);
454: hr_utility.set_location('p_validation_start_date '||p_validation_start_date, 101);
455: hr_utility.set_location('p_validation_end_date '||p_validation_end_date, 101);
456: hr_utility.set_location('p_effective_date '||p_effective_date, 101);
457: hr_utility.set_location('p_datetrack_mode '||p_datetrack_mode, 101);
458:
459: open c_position;
460: fetch c_position into l_rec;
461:

Line 513: hr_utility.set_location('Insert Validate: SHARED position has FTE greater than', 130);

509: --
510: --
511: -- Validate whether a SHARED position has FTE greater than the sum of the budgeted FTE's attached to the Position
512: --
513: hr_utility.set_location('Insert Validate: SHARED position has FTE greater than', 130);
514: if p_rec.position_id <> nvl(l_asg.position_id, -999) then
515: if (l_rec.position_type = 'SHARED') then
516: --
517: hr_utility.set_location('before l_overlap_dates_present ', 100);

Line 517: hr_utility.set_location('before l_overlap_dates_present ', 100);

513: hr_utility.set_location('Insert Validate: SHARED position has FTE greater than', 130);
514: if p_rec.position_id <> nvl(l_asg.position_id, -999) then
515: if (l_rec.position_type = 'SHARED') then
516: --
517: hr_utility.set_location('before l_overlap_dates_present ', 100);
518: l_default_asg_fte := null;
519: --pqh_psf_bus.default_assignment_fte(p_rec.business_group_id);
520: --
521: pqh_psf_bus.CHK_ABV_FTE_GT_POS_BGT_FTE(

Line 535: hr_utility.set_location('l_default_asg_fte :'||l_default_asg_fte, 135);

531: l_default_asg_fte := 1;
532: end if;
533: --
534: if not l_bgt_lt_abv_fte then
535: hr_utility.set_location('l_default_asg_fte :'||l_default_asg_fte, 135);
536: pqh_psf_bus.chk_future_pos_asg_fte(
537: p_assignment_id => p_rec.assignment_id,
538: p_position_id => p_rec.position_id,
539: p_validation_start_date => p_validation_start_date,

Line 544: hr_utility.set_location('after chk_future_pos_asg_fte ', 100);

540: p_validation_end_date => hr_general.end_of_time,
541: p_default_asg_fte => l_default_asg_fte);
542: end if;
543: --
544: hr_utility.set_location('after chk_future_pos_asg_fte ', 100);
545: --
546: if (l_rec.position_type = 'SHARED') then
547: --
548: hr_utility.set_location('before PQH_FTE_NE_SHARED_POS_FTE_CAP ', 100);

Line 548: hr_utility.set_location('before PQH_FTE_NE_SHARED_POS_FTE_CAP ', 100);

544: hr_utility.set_location('after chk_future_pos_asg_fte ', 100);
545: --
546: if (l_rec.position_type = 'SHARED') then
547: --
548: hr_utility.set_location('before PQH_FTE_NE_SHARED_POS_FTE_CAP ', 100);
549: --
550: l_assignment_fte := pqh_psf_bus.assignment_fte(p_rec.assignment_id, p_validation_start_date);
551: if (l_rec.fte/l_rec.max_persons <> l_assignment_fte) then
552: pqh_utility.set_message(8302,'PQH_FTE_NE_SHARED_POS_FTE_CAP',l_rec.organization_id);

Line 556: hr_utility.set_location('after PQH_FTE_NE_SHARED_POS_FTE_CAP ', 100);

552: pqh_utility.set_message(8302,'PQH_FTE_NE_SHARED_POS_FTE_CAP',l_rec.organization_id);
553: pqh_utility.raise_error;
554: end if;
555: --
556: hr_utility.set_location('after PQH_FTE_NE_SHARED_POS_FTE_CAP ', 100);
557: --
558: end if;
559: --
560: --

Line 571: hr_utility.set_location('SINGLE OR SHARED', 111);

567: pqh_utility.set_message(8302,'PQH_POOLED_POS_NOT_OPEN',l_rec.organization_id);
568: pqh_utility.raise_error;
569: end if;
570: elsif l_rec.position_type = 'SINGLE' or l_rec.position_type = 'SHARED' then
571: hr_utility.set_location('SINGLE OR SHARED', 111);
572: if pqh_psf_bus.open_status(l_rec.position_id, l_rec.effective_start_date) = 'OPEN' then
573: hr_utility.set_location('OPEN', 112);
574: if not l_bgt_lt_abv_fte then
575: hr_utility.set_location('NOT l_bgt_lt_abv_fte ', 113);

Line 573: hr_utility.set_location('OPEN', 112);

569: end if;
570: elsif l_rec.position_type = 'SINGLE' or l_rec.position_type = 'SHARED' then
571: hr_utility.set_location('SINGLE OR SHARED', 111);
572: if pqh_psf_bus.open_status(l_rec.position_id, l_rec.effective_start_date) = 'OPEN' then
573: hr_utility.set_location('OPEN', 112);
574: if not l_bgt_lt_abv_fte then
575: hr_utility.set_location('NOT l_bgt_lt_abv_fte ', 113);
576: if chk_reserved_fte(p_rec.assignment_id, p_rec.person_id,
577: p_rec.position_id, l_rec.position_type,

Line 575: hr_utility.set_location('NOT l_bgt_lt_abv_fte ', 113);

571: hr_utility.set_location('SINGLE OR SHARED', 111);
572: if pqh_psf_bus.open_status(l_rec.position_id, l_rec.effective_start_date) = 'OPEN' then
573: hr_utility.set_location('OPEN', 112);
574: if not l_bgt_lt_abv_fte then
575: hr_utility.set_location('NOT l_bgt_lt_abv_fte ', 113);
576: if chk_reserved_fte(p_rec.assignment_id, p_rec.person_id,
577: p_rec.position_id, l_rec.position_type,
578: p_validation_start_date) then
579: pqh_psf_bus.reserved_error(p_rec.assignment_id,

Line 585: --hr_utility.set_location('POSITION RESERVED', 114);

581: p_rec.position_id,
582: p_validation_start_date,
583: l_rec.organization_id);
584:
585: --hr_utility.set_location('POSITION RESERVED', 114);
586: --pqh_utility.set_message(8302,'PQH_POS_RESERVED',l_rec.organization_id);
587: --pqh_utility.raise_error;
588: else
589: l_future_res_date := chk_future_reserved_fte(p_rec.assignment_id, p_rec.person_id,

Line 593: hr_utility.set_message(8302,'PQH_POS_FUTURE_RESERVED');

589: l_future_res_date := chk_future_reserved_fte(p_rec.assignment_id, p_rec.person_id,
590: p_rec.position_id, l_rec.position_type,
591: p_validation_start_date, hr_general.end_of_time);
592: if l_future_res_date is not null then
593: hr_utility.set_message(8302,'PQH_POS_FUTURE_RESERVED');
594: hr_utility.set_message_token('FUTURE_RESERVED_DATE', l_future_res_date);
595: pqh_utility.set_message_level_cd('W');
596: pqh_utility.raise_error;
597: end if;

Line 594: hr_utility.set_message_token('FUTURE_RESERVED_DATE', l_future_res_date);

590: p_rec.position_id, l_rec.position_type,
591: p_validation_start_date, hr_general.end_of_time);
592: if l_future_res_date is not null then
593: hr_utility.set_message(8302,'PQH_POS_FUTURE_RESERVED');
594: hr_utility.set_message_token('FUTURE_RESERVED_DATE', l_future_res_date);
595: pqh_utility.set_message_level_cd('W');
596: pqh_utility.raise_error;
597: end if;
598: end if;

Line 608: hr_utility.set_location('Exiting PQH_PSF_BUS', 130);

604: end if;
605: else
606: close c_position;
607: end if;
608: hr_utility.set_location('Exiting PQH_PSF_BUS', 130);
609: --
610: END;
611: --
612: -- ---------------------------------------------------------------------------

Line 678: hr_utility.set_location('Entering pqh_asg_bus_delete_validate', 10);

674: where position_id = p_position_id
675: and p_date between effective_start_date and effective_end_date;
676: --
677: begin
678: hr_utility.set_location('Entering pqh_asg_bus_delete_validate', 10);
679: l_position_id := p_rec.position_id;
680: hr_utility.set_location('l_position_id : ' || l_position_id,51);
681: hr_utility.set_location('p_assignment_id : ' || p_rec.assignment_id,51);
682: hr_utility.set_location('p_effective_date : ' || p_effective_date,51);

Line 680: hr_utility.set_location('l_position_id : ' || l_position_id,51);

676: --
677: begin
678: hr_utility.set_location('Entering pqh_asg_bus_delete_validate', 10);
679: l_position_id := p_rec.position_id;
680: hr_utility.set_location('l_position_id : ' || l_position_id,51);
681: hr_utility.set_location('p_assignment_id : ' || p_rec.assignment_id,51);
682: hr_utility.set_location('p_effective_date : ' || p_effective_date,51);
683: hr_utility.set_location('p_validation_start_date : ' || p_validation_start_date,51);
684: hr_utility.set_location('p_validation_end_date : ' || p_validation_end_date,51);

Line 681: hr_utility.set_location('p_assignment_id : ' || p_rec.assignment_id,51);

677: begin
678: hr_utility.set_location('Entering pqh_asg_bus_delete_validate', 10);
679: l_position_id := p_rec.position_id;
680: hr_utility.set_location('l_position_id : ' || l_position_id,51);
681: hr_utility.set_location('p_assignment_id : ' || p_rec.assignment_id,51);
682: hr_utility.set_location('p_effective_date : ' || p_effective_date,51);
683: hr_utility.set_location('p_validation_start_date : ' || p_validation_start_date,51);
684: hr_utility.set_location('p_validation_end_date : ' || p_validation_end_date,51);
685: hr_utility.set_location('p_datetrack_mode : ' || p_datetrack_mode,51);

Line 682: hr_utility.set_location('p_effective_date : ' || p_effective_date,51);

678: hr_utility.set_location('Entering pqh_asg_bus_delete_validate', 10);
679: l_position_id := p_rec.position_id;
680: hr_utility.set_location('l_position_id : ' || l_position_id,51);
681: hr_utility.set_location('p_assignment_id : ' || p_rec.assignment_id,51);
682: hr_utility.set_location('p_effective_date : ' || p_effective_date,51);
683: hr_utility.set_location('p_validation_start_date : ' || p_validation_start_date,51);
684: hr_utility.set_location('p_validation_end_date : ' || p_validation_end_date,51);
685: hr_utility.set_location('p_datetrack_mode : ' || p_datetrack_mode,51);
686: if l_position_id is null then

Line 683: hr_utility.set_location('p_validation_start_date : ' || p_validation_start_date,51);

679: l_position_id := p_rec.position_id;
680: hr_utility.set_location('l_position_id : ' || l_position_id,51);
681: hr_utility.set_location('p_assignment_id : ' || p_rec.assignment_id,51);
682: hr_utility.set_location('p_effective_date : ' || p_effective_date,51);
683: hr_utility.set_location('p_validation_start_date : ' || p_validation_start_date,51);
684: hr_utility.set_location('p_validation_end_date : ' || p_validation_end_date,51);
685: hr_utility.set_location('p_datetrack_mode : ' || p_datetrack_mode,51);
686: if l_position_id is null then
687: open c_position_id(p_rec.assignment_id, p_effective_date);

Line 684: hr_utility.set_location('p_validation_end_date : ' || p_validation_end_date,51);

680: hr_utility.set_location('l_position_id : ' || l_position_id,51);
681: hr_utility.set_location('p_assignment_id : ' || p_rec.assignment_id,51);
682: hr_utility.set_location('p_effective_date : ' || p_effective_date,51);
683: hr_utility.set_location('p_validation_start_date : ' || p_validation_start_date,51);
684: hr_utility.set_location('p_validation_end_date : ' || p_validation_end_date,51);
685: hr_utility.set_location('p_datetrack_mode : ' || p_datetrack_mode,51);
686: if l_position_id is null then
687: open c_position_id(p_rec.assignment_id, p_effective_date);
688: fetch c_position_id into l_position_id;

Line 685: hr_utility.set_location('p_datetrack_mode : ' || p_datetrack_mode,51);

681: hr_utility.set_location('p_assignment_id : ' || p_rec.assignment_id,51);
682: hr_utility.set_location('p_effective_date : ' || p_effective_date,51);
683: hr_utility.set_location('p_validation_start_date : ' || p_validation_start_date,51);
684: hr_utility.set_location('p_validation_end_date : ' || p_validation_end_date,51);
685: hr_utility.set_location('p_datetrack_mode : ' || p_datetrack_mode,51);
686: if l_position_id is null then
687: open c_position_id(p_rec.assignment_id, p_effective_date);
688: fetch c_position_id into l_position_id;
689: close c_position_id;

Line 691: hr_utility.set_location('l_position_id : ' || l_position_id,51);

687: open c_position_id(p_rec.assignment_id, p_effective_date);
688: fetch c_position_id into l_position_id;
689: close c_position_id;
690: end if;
691: hr_utility.set_location('l_position_id : ' || l_position_id,51);
692: --
693: if p_datetrack_mode in ('DELETE_NEXT_CHANGE', 'FUTURE_CHANGE') then
694: for r1 in c_changed_dates(l_position_id, p_validation_start_date, p_validation_end_date)
695: loop

Line 696: hr_utility.set_location('Effective Start Date : ' || r1.effective_start_date,50);

692: --
693: if p_datetrack_mode in ('DELETE_NEXT_CHANGE', 'FUTURE_CHANGE') then
694: for r1 in c_changed_dates(l_position_id, p_validation_start_date, p_validation_end_date)
695: loop
696: hr_utility.set_location('Effective Start Date : ' || r1.effective_start_date,50);
697: --
698: open c_position_fte(l_position_id, r1.effective_start_date);
699: fetch c_position_fte into l_overlap_period,l_fte, l_organization_id;
700: close c_position_fte;

Line 701: hr_utility.set_location('l_overlap_period : ' || l_overlap_period,51);

697: --
698: open c_position_fte(l_position_id, r1.effective_start_date);
699: fetch c_position_fte into l_overlap_period,l_fte, l_organization_id;
700: close c_position_fte;
701: hr_utility.set_location('l_overlap_period : ' || l_overlap_period,51);
702: --
703: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(
704: p_position_id => l_position_id,
705: p_overlap_period => l_overlap_period,

Line 726: hr_utility.set_location('l_bdgt '||l_bdgt, 101);

722: l_sum1 := pqh_psf_bus.sum_assignment_fte(l_position_id, r1.effective_start_date, p_rec.assignment_id);
723: l_sum2 := pqh_psf_bus.assignment_fte(p_rec.assignment_id, r1.effective_start_date);
724: l_sum := l_sum1 + l_sum2;
725: --
726: hr_utility.set_location('l_bdgt '||l_bdgt, 101);
727: hr_utility.set_location('l_fte '||l_fte, 101);
728: hr_utility.set_location('l_sum1'||l_sum1, 101);
729: hr_utility.set_location('l_sum2'||l_sum2, 101);
730: hr_utility.set_location('l_sum '||l_sum, 101);

Line 727: hr_utility.set_location('l_fte '||l_fte, 101);

723: l_sum2 := pqh_psf_bus.assignment_fte(p_rec.assignment_id, r1.effective_start_date);
724: l_sum := l_sum1 + l_sum2;
725: --
726: hr_utility.set_location('l_bdgt '||l_bdgt, 101);
727: hr_utility.set_location('l_fte '||l_fte, 101);
728: hr_utility.set_location('l_sum1'||l_sum1, 101);
729: hr_utility.set_location('l_sum2'||l_sum2, 101);
730: hr_utility.set_location('l_sum '||l_sum, 101);
731:

Line 728: hr_utility.set_location('l_sum1'||l_sum1, 101);

724: l_sum := l_sum1 + l_sum2;
725: --
726: hr_utility.set_location('l_bdgt '||l_bdgt, 101);
727: hr_utility.set_location('l_fte '||l_fte, 101);
728: hr_utility.set_location('l_sum1'||l_sum1, 101);
729: hr_utility.set_location('l_sum2'||l_sum2, 101);
730: hr_utility.set_location('l_sum '||l_sum, 101);
731:
732: --

Line 729: hr_utility.set_location('l_sum2'||l_sum2, 101);

725: --
726: hr_utility.set_location('l_bdgt '||l_bdgt, 101);
727: hr_utility.set_location('l_fte '||l_fte, 101);
728: hr_utility.set_location('l_sum1'||l_sum1, 101);
729: hr_utility.set_location('l_sum2'||l_sum2, 101);
730: hr_utility.set_location('l_sum '||l_sum, 101);
731:
732: --
733: if l_bdgt is not null or l_realloc is not null then

Line 730: hr_utility.set_location('l_sum '||l_sum, 101);

726: hr_utility.set_location('l_bdgt '||l_bdgt, 101);
727: hr_utility.set_location('l_fte '||l_fte, 101);
728: hr_utility.set_location('l_sum1'||l_sum1, 101);
729: hr_utility.set_location('l_sum2'||l_sum2, 101);
730: hr_utility.set_location('l_sum '||l_sum, 101);
731:
732: --
733: if l_bdgt is not null or l_realloc is not null then
734: l_bgt_realloc := nvl(l_bdgt,0) + nvl(l_realloc,0);

Line 752: hr_utility.set_location('Exiting pqh_asg_bus_delete_validate', 400);

748: end if;
749: end if;
750: end loop;
751: end if;
752: hr_utility.set_location('Exiting pqh_asg_bus_delete_validate', 400);
753: --
754: end;
755: --
756: -- ---------------------------------------------------------------------------

Line 808: hr_utility.set_location('Entering Procedure '||l_proc, 100);

804: and p_effective_date between abv.effective_start_date and abv.effective_end_date
805: and abv.unit in ('F', 'FTE');
806:
807: begin
808: hr_utility.set_location('Entering Procedure '||l_proc, 100);
809: hr_utility.set_location('p_unit '||p_unit, 101);
810: hr_utility.set_location('p_assignment_id '||nvl(p_assignment_id,-1), 102);
811: hr_utility.set_location('p_effective_date '||p_effective_date, 102);
812: open c_asg;

Line 809: hr_utility.set_location('p_unit '||p_unit, 101);

805: and abv.unit in ('F', 'FTE');
806:
807: begin
808: hr_utility.set_location('Entering Procedure '||l_proc, 100);
809: hr_utility.set_location('p_unit '||p_unit, 101);
810: hr_utility.set_location('p_assignment_id '||nvl(p_assignment_id,-1), 102);
811: hr_utility.set_location('p_effective_date '||p_effective_date, 102);
812: open c_asg;
813: fetch c_asg into l_position_id, l_person_id, l_business_group_id;

Line 810: hr_utility.set_location('p_assignment_id '||nvl(p_assignment_id,-1), 102);

806:
807: begin
808: hr_utility.set_location('Entering Procedure '||l_proc, 100);
809: hr_utility.set_location('p_unit '||p_unit, 101);
810: hr_utility.set_location('p_assignment_id '||nvl(p_assignment_id,-1), 102);
811: hr_utility.set_location('p_effective_date '||p_effective_date, 102);
812: open c_asg;
813: fetch c_asg into l_position_id, l_person_id, l_business_group_id;
814: close c_asg;

Line 811: hr_utility.set_location('p_effective_date '||p_effective_date, 102);

807: begin
808: hr_utility.set_location('Entering Procedure '||l_proc, 100);
809: hr_utility.set_location('p_unit '||p_unit, 101);
810: hr_utility.set_location('p_assignment_id '||nvl(p_assignment_id,-1), 102);
811: hr_utility.set_location('p_effective_date '||p_effective_date, 102);
812: open c_asg;
813: fetch c_asg into l_position_id, l_person_id, l_business_group_id;
814: close c_asg;
815: --

Line 816: hr_utility.set_location('l_position_id '||nvl(l_position_id,-1), 103);

812: open c_asg;
813: fetch c_asg into l_position_id, l_person_id, l_business_group_id;
814: close c_asg;
815: --
816: hr_utility.set_location('l_position_id '||nvl(l_position_id,-1), 103);
817: --
818: if p_unit in ('FTE') then
819: hr_utility.set_location('Unit is FTE:'||l_proc, 110);
820: open c_positions;

Line 819: hr_utility.set_location('Unit is FTE:'||l_proc, 110);

815: --
816: hr_utility.set_location('l_position_id '||nvl(l_position_id,-1), 103);
817: --
818: if p_unit in ('FTE') then
819: hr_utility.set_location('Unit is FTE:'||l_proc, 110);
820: open c_positions;
821: fetch c_positions into l_position_id, l_fte, l_max_persons,
822: l_position_type, l_organization_id, l_overlap_period;
823: close c_positions;

Line 825: hr_utility.set_location('Position : FTE, Head Count, Pos Type:'||

821: fetch c_positions into l_position_id, l_fte, l_max_persons,
822: l_position_type, l_organization_id, l_overlap_period;
823: close c_positions;
824: --
825: hr_utility.set_location('Position : FTE, Head Count, Pos Type:'||
826: l_fte||' - '||l_max_persons ||' - '||l_position_type, 120);
827: --
828: --
829: if l_position_type in ('SINGLE', 'SHARED') then

Line 852: hr_utility.set_location('FTE: l_sum_abv:'||l_sum_abv, 130);

848: ,p_business_group_id => l_business_group_id
849: );
850: --
851: --
852: hr_utility.set_location('FTE: l_sum_abv:'||l_sum_abv, 130);
853: hr_utility.set_location('FTE: l_pos_budget_fte:'||l_pos_budget_fte, 140);
854: hr_utility.set_location('FTE: l_realloc:'||l_realloc, 143);
855: hr_utility.set_location('FTE: l_fte:'||l_fte, 145);
856: hr_utility.set_location('FTE: p_value:'||p_value, 150);

Line 853: hr_utility.set_location('FTE: l_pos_budget_fte:'||l_pos_budget_fte, 140);

849: );
850: --
851: --
852: hr_utility.set_location('FTE: l_sum_abv:'||l_sum_abv, 130);
853: hr_utility.set_location('FTE: l_pos_budget_fte:'||l_pos_budget_fte, 140);
854: hr_utility.set_location('FTE: l_realloc:'||l_realloc, 143);
855: hr_utility.set_location('FTE: l_fte:'||l_fte, 145);
856: hr_utility.set_location('FTE: p_value:'||p_value, 150);
857: --

Line 854: hr_utility.set_location('FTE: l_realloc:'||l_realloc, 143);

850: --
851: --
852: hr_utility.set_location('FTE: l_sum_abv:'||l_sum_abv, 130);
853: hr_utility.set_location('FTE: l_pos_budget_fte:'||l_pos_budget_fte, 140);
854: hr_utility.set_location('FTE: l_realloc:'||l_realloc, 143);
855: hr_utility.set_location('FTE: l_fte:'||l_fte, 145);
856: hr_utility.set_location('FTE: p_value:'||p_value, 150);
857: --
858: if l_pos_budget_fte is not null or l_realloc is not null then

Line 855: hr_utility.set_location('FTE: l_fte:'||l_fte, 145);

851: --
852: hr_utility.set_location('FTE: l_sum_abv:'||l_sum_abv, 130);
853: hr_utility.set_location('FTE: l_pos_budget_fte:'||l_pos_budget_fte, 140);
854: hr_utility.set_location('FTE: l_realloc:'||l_realloc, 143);
855: hr_utility.set_location('FTE: l_fte:'||l_fte, 145);
856: hr_utility.set_location('FTE: p_value:'||p_value, 150);
857: --
858: if l_pos_budget_fte is not null or l_realloc is not null then
859: l_bgt_realloc := nvl(l_pos_budget_fte,0) + nvl(l_realloc,0);

Line 856: hr_utility.set_location('FTE: p_value:'||p_value, 150);

852: hr_utility.set_location('FTE: l_sum_abv:'||l_sum_abv, 130);
853: hr_utility.set_location('FTE: l_pos_budget_fte:'||l_pos_budget_fte, 140);
854: hr_utility.set_location('FTE: l_realloc:'||l_realloc, 143);
855: hr_utility.set_location('FTE: l_fte:'||l_fte, 145);
856: hr_utility.set_location('FTE: p_value:'||p_value, 150);
857: --
858: if l_pos_budget_fte is not null or l_realloc is not null then
859: l_bgt_realloc := nvl(l_pos_budget_fte,0) + nvl(l_realloc,0);
860: --

Line 880: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);

876: if (not l_abv_gt_fte) and (l_position_type = 'SHARED') then
877: --
878: -- Check Reserved
879: --
880: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
881: if pqh_psf_bus.open_status(l_position_id, p_effective_date) = 'OPEN' then
882: hr_utility.set_location('Insert Validate:OPEN', 130);
883: l_available_fte := pqh_psf_bus.available_fte(l_person_id, l_position_id, p_effective_date);
884: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);

Line 882: hr_utility.set_location('Insert Validate:OPEN', 130);

878: -- Check Reserved
879: --
880: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
881: if pqh_psf_bus.open_status(l_position_id, p_effective_date) = 'OPEN' then
882: hr_utility.set_location('Insert Validate:OPEN', 130);
883: l_available_fte := pqh_psf_bus.available_fte(l_person_id, l_position_id, p_effective_date);
884: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
885: if (nvl(p_value,0) > l_available_fte) then
886: pqh_psf_bus.reserved_error(p_assignment_id, l_person_id,

Line 884: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);

880: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
881: if pqh_psf_bus.open_status(l_position_id, p_effective_date) = 'OPEN' then
882: hr_utility.set_location('Insert Validate:OPEN', 130);
883: l_available_fte := pqh_psf_bus.available_fte(l_person_id, l_position_id, p_effective_date);
884: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
885: if (nvl(p_value,0) > l_available_fte) then
886: pqh_psf_bus.reserved_error(p_assignment_id, l_person_id,
887: l_position_id,
888: p_effective_date,

Line 896: hr_utility.set_location('Position : FTE, Head Count, Pos Type:'||

892: end if;
893: end if;
894: end if;
895: --
896: hr_utility.set_location('Position : FTE, Head Count, Pos Type:'||
897: l_fte||' - '||l_max_persons ||' - '||l_position_type, 120);
898: --
899: if (l_position_type = 'SHARED') and (l_fte/l_max_persons <> p_value) then
900: pqh_utility.set_message(8302,'PQH_FTE_NE_SHARED_POS_FTE_CAP',l_organization_id);

Line 904: hr_utility.set_location('Exiting Procedure '||l_proc, 200);

900: pqh_utility.set_message(8302,'PQH_FTE_NE_SHARED_POS_FTE_CAP',l_organization_id);
901: pqh_utility.raise_error;
902: end if;
903: end if;
904: hr_utility.set_location('Exiting Procedure '||l_proc, 200);
905: end;
906: --
907: -- ---------------------------------------------------------------------------
908: -- |----------------------< per_abv_update_validate >-------------------|

Line 966: hr_utility.set_location('Entering Procedure '||l_proc, 100);

962: and abv.unit in ('FTE')
963: and asg.assignment_id <> nvl(p_assignment_id,-999);
964:
965: begin
966: hr_utility.set_location('Entering Procedure '||l_proc, 100);
967: hr_utility.set_location('p_effective_date '||p_effective_date, 100);
968: hr_utility.set_location('p_validation_start_date '||p_validation_start_date, 100);
969: hr_utility.set_location('p_validation_end_date '||p_validation_end_date, 100);
970: hr_utility.set_location('p_datetrack_mode '||p_datetrack_mode, 100);

Line 967: hr_utility.set_location('p_effective_date '||p_effective_date, 100);

963: and asg.assignment_id <> nvl(p_assignment_id,-999);
964:
965: begin
966: hr_utility.set_location('Entering Procedure '||l_proc, 100);
967: hr_utility.set_location('p_effective_date '||p_effective_date, 100);
968: hr_utility.set_location('p_validation_start_date '||p_validation_start_date, 100);
969: hr_utility.set_location('p_validation_end_date '||p_validation_end_date, 100);
970: hr_utility.set_location('p_datetrack_mode '||p_datetrack_mode, 100);
971: hr_utility.set_location('p_unit '||p_unit, 100);

Line 968: hr_utility.set_location('p_validation_start_date '||p_validation_start_date, 100);

964:
965: begin
966: hr_utility.set_location('Entering Procedure '||l_proc, 100);
967: hr_utility.set_location('p_effective_date '||p_effective_date, 100);
968: hr_utility.set_location('p_validation_start_date '||p_validation_start_date, 100);
969: hr_utility.set_location('p_validation_end_date '||p_validation_end_date, 100);
970: hr_utility.set_location('p_datetrack_mode '||p_datetrack_mode, 100);
971: hr_utility.set_location('p_unit '||p_unit, 100);
972: if p_unit in ('FTE') then

Line 969: hr_utility.set_location('p_validation_end_date '||p_validation_end_date, 100);

965: begin
966: hr_utility.set_location('Entering Procedure '||l_proc, 100);
967: hr_utility.set_location('p_effective_date '||p_effective_date, 100);
968: hr_utility.set_location('p_validation_start_date '||p_validation_start_date, 100);
969: hr_utility.set_location('p_validation_end_date '||p_validation_end_date, 100);
970: hr_utility.set_location('p_datetrack_mode '||p_datetrack_mode, 100);
971: hr_utility.set_location('p_unit '||p_unit, 100);
972: if p_unit in ('FTE') then
973: open c_asg(p_assignment_id, p_effective_date);

Line 970: hr_utility.set_location('p_datetrack_mode '||p_datetrack_mode, 100);

966: hr_utility.set_location('Entering Procedure '||l_proc, 100);
967: hr_utility.set_location('p_effective_date '||p_effective_date, 100);
968: hr_utility.set_location('p_validation_start_date '||p_validation_start_date, 100);
969: hr_utility.set_location('p_validation_end_date '||p_validation_end_date, 100);
970: hr_utility.set_location('p_datetrack_mode '||p_datetrack_mode, 100);
971: hr_utility.set_location('p_unit '||p_unit, 100);
972: if p_unit in ('FTE') then
973: open c_asg(p_assignment_id, p_effective_date);
974: fetch c_asg into l_position_id, l_person_id, l_business_group_id;

Line 971: hr_utility.set_location('p_unit '||p_unit, 100);

967: hr_utility.set_location('p_effective_date '||p_effective_date, 100);
968: hr_utility.set_location('p_validation_start_date '||p_validation_start_date, 100);
969: hr_utility.set_location('p_validation_end_date '||p_validation_end_date, 100);
970: hr_utility.set_location('p_datetrack_mode '||p_datetrack_mode, 100);
971: hr_utility.set_location('p_unit '||p_unit, 100);
972: if p_unit in ('FTE') then
973: open c_asg(p_assignment_id, p_effective_date);
974: fetch c_asg into l_position_id, l_person_id, l_business_group_id;
975: close c_asg;

Line 976: hr_utility.set_location('Unit is FTE:'||l_proc, 110);

972: if p_unit in ('FTE') then
973: open c_asg(p_assignment_id, p_effective_date);
974: fetch c_asg into l_position_id, l_person_id, l_business_group_id;
975: close c_asg;
976: hr_utility.set_location('Unit is FTE:'||l_proc, 110);
977: open c_positions(p_validation_start_date);
978: fetch c_positions into l_position_id, l_fte, l_max_persons,
979: l_position_type, l_organization_id, l_overlap_period;
980: hr_utility.set_location('Position : FTE, Head Count, Pos Type:'||

Line 980: hr_utility.set_location('Position : FTE, Head Count, Pos Type:'||

976: hr_utility.set_location('Unit is FTE:'||l_proc, 110);
977: open c_positions(p_validation_start_date);
978: fetch c_positions into l_position_id, l_fte, l_max_persons,
979: l_position_type, l_organization_id, l_overlap_period;
980: hr_utility.set_location('Position : FTE, Head Count, Pos Type:'||
981: l_fte||' - '||l_max_persons ||' - '||l_position_type, 120);
982: if c_positions%found then
983: close c_positions;
984: hr_utility.set_location('c_positions found', 121);

Line 984: hr_utility.set_location('c_positions found', 121);

980: hr_utility.set_location('Position : FTE, Head Count, Pos Type:'||
981: l_fte||' - '||l_max_persons ||' - '||l_position_type, 120);
982: if c_positions%found then
983: close c_positions;
984: hr_utility.set_location('c_positions found', 121);
985: --
986: if l_position_type in ('SINGLE', 'SHARED') then
987: hr_utility.set_location('pos type SINGLE OR SHARED', 122);
988: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(

Line 987: hr_utility.set_location('pos type SINGLE OR SHARED', 122);

983: close c_positions;
984: hr_utility.set_location('c_positions found', 121);
985: --
986: if l_position_type in ('SINGLE', 'SHARED') then
987: hr_utility.set_location('pos type SINGLE OR SHARED', 122);
988: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(
989: p_position_id => l_position_id,
990: p_overlap_period => l_overlap_period,
991: p_assignment_start_date => p_effective_date);

Line 992: hr_utility.set_location('After chk_Overlap_dates', 123);

988: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(
989: p_position_id => l_position_id,
990: p_overlap_period => l_overlap_period,
991: p_assignment_start_date => p_effective_date);
992: hr_utility.set_location('After chk_Overlap_dates', 123);
993: if not l_overlap_dates_present then
994: hr_utility.set_location('Overlap_dates not present', 124);
995: --
996: --Validate Position Budget values with sum of Assignment Budget Values

Line 994: hr_utility.set_location('Overlap_dates not present', 124);

990: p_overlap_period => l_overlap_period,
991: p_assignment_start_date => p_effective_date);
992: hr_utility.set_location('After chk_Overlap_dates', 123);
993: if not l_overlap_dates_present then
994: hr_utility.set_location('Overlap_dates not present', 124);
995: --
996: --Validate Position Budget values with sum of Assignment Budget Values
997: open c_sum_abv(l_position_id,p_assignment_id, p_validation_start_date);
998: fetch c_sum_abv into l_sum_abv;

Line 1001: hr_utility.set_location('Before budgeted fte', 124);

997: open c_sum_abv(l_position_id,p_assignment_id, p_validation_start_date);
998: fetch c_sum_abv into l_sum_abv;
999: close c_sum_abv;
1000: --
1001: hr_utility.set_location('Before budgeted fte', 124);
1002: l_pos_budget_fte := budgeted_fte(l_position_id, p_validation_start_date);
1003: --
1004: l_realloc := pqh_reallocation_pkg.get_reallocation(
1005: p_position_id => l_position_id

Line 1015: hr_utility.set_location('FTE: l_sum_abv:'||l_sum_abv, 130);

1011: );
1012: --
1013: --
1014: --
1015: hr_utility.set_location('FTE: l_sum_abv:'||l_sum_abv, 130);
1016: hr_utility.set_location('FTE: l_pos_budget_fte:'||l_pos_budget_fte, 140);
1017: hr_utility.set_location('FTE: l_realloc:'||l_realloc, 143);
1018: hr_utility.set_location('FTE: l_fte:'||l_fte, 145);
1019: hr_utility.set_location('FTE: p_value:'||p_value, 150);

Line 1016: hr_utility.set_location('FTE: l_pos_budget_fte:'||l_pos_budget_fte, 140);

1012: --
1013: --
1014: --
1015: hr_utility.set_location('FTE: l_sum_abv:'||l_sum_abv, 130);
1016: hr_utility.set_location('FTE: l_pos_budget_fte:'||l_pos_budget_fte, 140);
1017: hr_utility.set_location('FTE: l_realloc:'||l_realloc, 143);
1018: hr_utility.set_location('FTE: l_fte:'||l_fte, 145);
1019: hr_utility.set_location('FTE: p_value:'||p_value, 150);
1020: --

Line 1017: hr_utility.set_location('FTE: l_realloc:'||l_realloc, 143);

1013: --
1014: --
1015: hr_utility.set_location('FTE: l_sum_abv:'||l_sum_abv, 130);
1016: hr_utility.set_location('FTE: l_pos_budget_fte:'||l_pos_budget_fte, 140);
1017: hr_utility.set_location('FTE: l_realloc:'||l_realloc, 143);
1018: hr_utility.set_location('FTE: l_fte:'||l_fte, 145);
1019: hr_utility.set_location('FTE: p_value:'||p_value, 150);
1020: --
1021: if l_pos_budget_fte is not null or l_realloc is not null then

Line 1018: hr_utility.set_location('FTE: l_fte:'||l_fte, 145);

1014: --
1015: hr_utility.set_location('FTE: l_sum_abv:'||l_sum_abv, 130);
1016: hr_utility.set_location('FTE: l_pos_budget_fte:'||l_pos_budget_fte, 140);
1017: hr_utility.set_location('FTE: l_realloc:'||l_realloc, 143);
1018: hr_utility.set_location('FTE: l_fte:'||l_fte, 145);
1019: hr_utility.set_location('FTE: p_value:'||p_value, 150);
1020: --
1021: if l_pos_budget_fte is not null or l_realloc is not null then
1022: l_bgt_realloc := nvl(l_pos_budget_fte,0) + nvl(l_realloc,0);

Line 1019: hr_utility.set_location('FTE: p_value:'||p_value, 150);

1015: hr_utility.set_location('FTE: l_sum_abv:'||l_sum_abv, 130);
1016: hr_utility.set_location('FTE: l_pos_budget_fte:'||l_pos_budget_fte, 140);
1017: hr_utility.set_location('FTE: l_realloc:'||l_realloc, 143);
1018: hr_utility.set_location('FTE: l_fte:'||l_fte, 145);
1019: hr_utility.set_location('FTE: p_value:'||p_value, 150);
1020: --
1021: if l_pos_budget_fte is not null or l_realloc is not null then
1022: l_bgt_realloc := nvl(l_pos_budget_fte,0) + nvl(l_realloc,0);
1023: --

Line 1024: hr_utility.set_location('l_pos_budget_fte is null', 151);

1020: --
1021: if l_pos_budget_fte is not null or l_realloc is not null then
1022: l_bgt_realloc := nvl(l_pos_budget_fte,0) + nvl(l_realloc,0);
1023: --
1024: hr_utility.set_location('l_pos_budget_fte is null', 151);
1025: if (l_bgt_realloc < nvl(l_sum_abv,0)+ nvl(p_value,0)) then
1026: hr_utility.set_location('PQH_SUM_ABV_FTE_GT_POS_BGT_FTE', 152);
1027: l_abv_gt_fte := true;
1028: ---Position Budget FTE is less than the sum of the assignment budget FTE

Line 1026: hr_utility.set_location('PQH_SUM_ABV_FTE_GT_POS_BGT_FTE', 152);

1022: l_bgt_realloc := nvl(l_pos_budget_fte,0) + nvl(l_realloc,0);
1023: --
1024: hr_utility.set_location('l_pos_budget_fte is null', 151);
1025: if (l_bgt_realloc < nvl(l_sum_abv,0)+ nvl(p_value,0)) then
1026: hr_utility.set_location('PQH_SUM_ABV_FTE_GT_POS_BGT_FTE', 152);
1027: l_abv_gt_fte := true;
1028: ---Position Budget FTE is less than the sum of the assignment budget FTE
1029: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_BGT_FTE' ,l_organization_id);
1030: pqh_utility.raise_error;

Line 1034: hr_utility.set_location('PQH_SUM_ABV_FTE_GT_POS_FTE :'||l_organization_id, 153);

1030: pqh_utility.raise_error;
1031: end if;
1032: else
1033: if (l_fte < nvl(l_sum_abv,0)+ nvl(p_value,0)) then
1034: hr_utility.set_location('PQH_SUM_ABV_FTE_GT_POS_FTE :'||l_organization_id, 153);
1035: l_abv_gt_fte := true;
1036: ---Position FTE is less than the sum of the assignment budget FTE
1037: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_FTE',l_organization_id);
1038: pqh_utility.raise_error;

Line 1042: hr_utility.set_location('Before check reserved', 154);

1038: pqh_utility.raise_error;
1039: end if;
1040: end if;
1041: --
1042: hr_utility.set_location('Before check reserved', 154);
1043: --
1044: -- Check Reserved
1045: --
1046: if (not l_abv_gt_fte) and (l_position_type = 'SHARED') then

Line 1047: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);

1043: --
1044: -- Check Reserved
1045: --
1046: if (not l_abv_gt_fte) and (l_position_type = 'SHARED') then
1047: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
1048: --if pqh_psf_bus.open_status(l_position_id, p_effective_date) = 'OPEN' then
1049: hr_utility.set_location('Insert Validate:OPEN', 130);
1050: l_available_fte := pqh_psf_bus.available_fte(l_person_id, l_position_id, p_effective_date);
1051: l_assignment_fte := nvl(pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date),0);

Line 1049: hr_utility.set_location('Insert Validate:OPEN', 130);

1045: --
1046: if (not l_abv_gt_fte) and (l_position_type = 'SHARED') then
1047: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
1048: --if pqh_psf_bus.open_status(l_position_id, p_effective_date) = 'OPEN' then
1049: hr_utility.set_location('Insert Validate:OPEN', 130);
1050: l_available_fte := pqh_psf_bus.available_fte(l_person_id, l_position_id, p_effective_date);
1051: l_assignment_fte := nvl(pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date),0);
1052: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
1053: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 133);

Line 1052: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);

1048: --if pqh_psf_bus.open_status(l_position_id, p_effective_date) = 'OPEN' then
1049: hr_utility.set_location('Insert Validate:OPEN', 130);
1050: l_available_fte := pqh_psf_bus.available_fte(l_person_id, l_position_id, p_effective_date);
1051: l_assignment_fte := nvl(pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date),0);
1052: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
1053: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 133);
1054: l_temp := l_available_fte + l_assignment_fte ;
1055: if (nvl(p_value,0) > l_temp ) then
1056: pqh_psf_bus.reserved_error(p_assignment_id, l_person_id,

Line 1053: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 133);

1049: hr_utility.set_location('Insert Validate:OPEN', 130);
1050: l_available_fte := pqh_psf_bus.available_fte(l_person_id, l_position_id, p_effective_date);
1051: l_assignment_fte := nvl(pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date),0);
1052: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
1053: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 133);
1054: l_temp := l_available_fte + l_assignment_fte ;
1055: if (nvl(p_value,0) > l_temp ) then
1056: pqh_psf_bus.reserved_error(p_assignment_id, l_person_id,
1057: l_position_id,

Line 1067: hr_utility.set_location('Before fte capacity', 155);

1063: end if;
1064: end if;
1065: end if;
1066: --
1067: hr_utility.set_location('Before fte capacity', 155);
1068: --
1069: if (l_position_type = 'SHARED') and (l_fte/l_max_persons <> p_value) then
1070: hr_utility.set_location('PQH_FTE_NE_SHARED_POS_FTE_CAP', 156);
1071: pqh_utility.set_message(8302,'PQH_FTE_NE_SHARED_POS_FTE_CAP',l_organization_id);

Line 1070: hr_utility.set_location('PQH_FTE_NE_SHARED_POS_FTE_CAP', 156);

1066: --
1067: hr_utility.set_location('Before fte capacity', 155);
1068: --
1069: if (l_position_type = 'SHARED') and (l_fte/l_max_persons <> p_value) then
1070: hr_utility.set_location('PQH_FTE_NE_SHARED_POS_FTE_CAP', 156);
1071: pqh_utility.set_message(8302,'PQH_FTE_NE_SHARED_POS_FTE_CAP',l_organization_id);
1072: pqh_utility.raise_error;
1073: end if;
1074: --

Line 1075: hr_utility.set_location('After fte capacity', 157);

1071: pqh_utility.set_message(8302,'PQH_FTE_NE_SHARED_POS_FTE_CAP',l_organization_id);
1072: pqh_utility.raise_error;
1073: end if;
1074: --
1075: hr_utility.set_location('After fte capacity', 157);
1076: --
1077: end if;
1078: end if;
1079: hr_utility.set_location('Exiting Procedure '||l_proc, 200);

Line 1079: hr_utility.set_location('Exiting Procedure '||l_proc, 200);

1075: hr_utility.set_location('After fte capacity', 157);
1076: --
1077: end if;
1078: end if;
1079: hr_utility.set_location('Exiting Procedure '||l_proc, 200);
1080: end;
1081: --
1082: --
1083: -- ---------------------------------------------------------------------------

Line 1234: hr_utility.set_location('l_person_id : '||l_person_id, 630);

1230: if p_person_id is not null and p_position_id is not null and p_effective_date is not null then
1231: if p_ex_assignment_id is null then
1232: open c_budgeted_fte(p_person_id, p_position_id);
1233: fetch c_budgeted_fte into l_assignment_fte;
1234: hr_utility.set_location('l_person_id : '||l_person_id, 630);
1235: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 630);
1236: close c_budgeted_fte;
1237: else
1238: open c_budgeted_fte_ex_asg(p_person_id, p_position_id, p_ex_assignment_id);

Line 1235: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 630);

1231: if p_ex_assignment_id is null then
1232: open c_budgeted_fte(p_person_id, p_position_id);
1233: fetch c_budgeted_fte into l_assignment_fte;
1234: hr_utility.set_location('l_person_id : '||l_person_id, 630);
1235: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 630);
1236: close c_budgeted_fte;
1237: else
1238: open c_budgeted_fte_ex_asg(p_person_id, p_position_id, p_ex_assignment_id);
1239: fetch c_budgeted_fte_ex_asg into l_assignment_fte;

Line 1240: hr_utility.set_location('l_person_id : '||l_person_id, 630);

1236: close c_budgeted_fte;
1237: else
1238: open c_budgeted_fte_ex_asg(p_person_id, p_position_id, p_ex_assignment_id);
1239: fetch c_budgeted_fte_ex_asg into l_assignment_fte;
1240: hr_utility.set_location('l_person_id : '||l_person_id, 630);
1241: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 630);
1242: close c_budgeted_fte_ex_asg;
1243: end if;
1244: end if;

Line 1241: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 630);

1237: else
1238: open c_budgeted_fte_ex_asg(p_person_id, p_position_id, p_ex_assignment_id);
1239: fetch c_budgeted_fte_ex_asg into l_assignment_fte;
1240: hr_utility.set_location('l_person_id : '||l_person_id, 630);
1241: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 630);
1242: close c_budgeted_fte_ex_asg;
1243: end if;
1244: end if;
1245: return(l_assignment_fte);

Line 1380: hr_utility.set_location('Open Status- l_availability_status:'||l_availability_status,

1376: l_availability_status_id,l_business_group_id, l_position_type, l_pos_effective_date;
1377: close c_positions;
1378: l_availability_status :=
1379: hr_psf_shd.get_availability_status(l_availability_status_id,l_business_group_id);
1380: hr_utility.set_location('Open Status- l_availability_status:'||l_availability_status,
1381: 310);
1382: hr_utility.set_location('Open Status- l_position_type:'||l_position_type,
1383: 320);
1384: l_funded_status := funded_status(p_position_id);

Line 1382: hr_utility.set_location('Open Status- l_position_type:'||l_position_type,

1378: l_availability_status :=
1379: hr_psf_shd.get_availability_status(l_availability_status_id,l_business_group_id);
1380: hr_utility.set_location('Open Status- l_availability_status:'||l_availability_status,
1381: 310);
1382: hr_utility.set_location('Open Status- l_position_type:'||l_position_type,
1383: 320);
1384: l_funded_status := funded_status(p_position_id);
1385: --
1386: hr_utility.set_location('Open Status- l_funded_status:'||l_funded_status,

Line 1386: hr_utility.set_location('Open Status- l_funded_status:'||l_funded_status,

1382: hr_utility.set_location('Open Status- l_position_type:'||l_position_type,
1383: 320);
1384: l_funded_status := funded_status(p_position_id);
1385: --
1386: hr_utility.set_location('Open Status- l_funded_status:'||l_funded_status,
1387: 320);
1388:
1389: if (l_position_type in ( 'SINGLE', 'SHARED' )) then
1390: l_vacancy_status:= vacancy_status(p_position_id, p_effective_date);

Line 1391: hr_utility.set_location('Open Status- l_vacancy_status:'||l_vacancy_status,

1387: 320);
1388:
1389: if (l_position_type in ( 'SINGLE', 'SHARED' )) then
1390: l_vacancy_status:= vacancy_status(p_position_id, p_effective_date);
1391: hr_utility.set_location('Open Status- l_vacancy_status:'||l_vacancy_status,
1392: 320);
1393: if (l_pos_effective_date <= p_effective_date)
1394: and ( l_availability_status = 'ACTIVE' )
1395: and ( l_funded_status = 'Y')

Line 1410: hr_utility.set_location('Open Status- l_open_status:'||l_open_status,

1406: else
1407: l_open_status := 'NOT_OPEN';
1408: end if;
1409: end if;
1410: hr_utility.set_location('Open Status- l_open_status:'||l_open_status,
1411: 330);
1412: /*
1413: reserved_status(p_position_id, l_reserved_status, l_resrv_start_date, l_resrv_end_date, l_resrv_person_id, l_fte_reserved);
1414: if (l_reserved_status in ( 'NEW_HIRE', 'MANAGEMENT_DISCRETION'))

Line 1590: hr_utility.set_location('Shared',101);

1586: end if;
1587: close C_ASSIGNMENTS;
1588: return(l_vacancy_status);
1589: elsif (l_position_type = 'SHARED') then
1590: hr_utility.set_location('Shared',101);
1591: open C_ASSIGNMENTS;
1592: fetch C_ASSIGNMENTS into l_assignment_id;
1593: if (C_ASSIGNMENTS%NOTFOUND) then
1594: close C_ASSIGNMENTS;

Line 1602: hr_utility.set_location('l_fte' || l_fte,102);

1598: close C_ASSIGNMENTS;
1599: l_vacancy_status := 'FILLED';
1600: l_fte := pqh_psf_bus.get_position_fte(p_position_id, p_effective_date);
1601: l_sum_asg_fte := sum_assignment_fte(p_position_id, p_effective_date);
1602: hr_utility.set_location('l_fte' || l_fte,102);
1603: hr_utility.set_location('sum_asg_fte :' || l_sum_asg_fte,102);
1604: if l_fte is not null then
1605: if nvl(l_fte,0) > nvl(l_sum_asg_fte,0) then
1606: /*if nvl(l_fte,0) >

Line 1603: hr_utility.set_location('sum_asg_fte :' || l_sum_asg_fte,102);

1599: l_vacancy_status := 'FILLED';
1600: l_fte := pqh_psf_bus.get_position_fte(p_position_id, p_effective_date);
1601: l_sum_asg_fte := sum_assignment_fte(p_position_id, p_effective_date);
1602: hr_utility.set_location('l_fte' || l_fte,102);
1603: hr_utility.set_location('sum_asg_fte :' || l_sum_asg_fte,102);
1604: if l_fte is not null then
1605: if nvl(l_fte,0) > nvl(l_sum_asg_fte,0) then
1606: /*if nvl(l_fte,0) >
1607: pqh_bdgt_actual_cmmtmnt_pkg.get_pos_budget_values(

Line 2013: hr_utility.set_location('Entering:'||'chk_position_job_grade', 10);

2009: and grade_id = p_position_grade_id;
2010: begin
2011: if (p_position_grade_id is not null) then
2012: open c1;
2013: hr_utility.set_location('Entering:'||'chk_position_job_grade', 10);
2014: fetch c1 into l_dummy;
2015: if c1%notfound then
2016: close c1;
2017: return(false);

Line 2137: hr_utility.set_location('l_business_group_id:' || l_business_group_id, 550

2133: open c_bus_grp_id(p_position_id);
2134: fetch c_bus_grp_id into l_business_group_id;
2135: close c_bus_grp_id;
2136: --
2137: hr_utility.set_location('l_business_group_id:' || l_business_group_id, 550
2138: );
2139:
2140: select budget_id, budget_unit1_id, budget_unit2_id, budget_unit3_id ,period_set_name
2141: into l_budget_id, l_budget_unit1_id, l_budget_unit2_id, l_budget_unit3_id, l_calendar

Line 2153: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);

2149: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'FTE'
2150: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'FTE'
2151: );
2152: --
2153: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
2154: hr_utility.set_location('l_calendar:' || l_calendar, 600);
2155: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
2156: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);
2157: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);

Line 2154: hr_utility.set_location('l_calendar:' || l_calendar, 600);

2150: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'FTE'
2151: );
2152: --
2153: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
2154: hr_utility.set_location('l_calendar:' || l_calendar, 600);
2155: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
2156: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);
2157: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);
2158: --

Line 2155: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);

2151: );
2152: --
2153: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
2154: hr_utility.set_location('l_calendar:' || l_calendar, 600);
2155: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
2156: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);
2157: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);
2158: --
2159: open c1(l_budget_unit1_id);

Line 2156: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);

2152: --
2153: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
2154: hr_utility.set_location('l_calendar:' || l_calendar, 600);
2155: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
2156: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);
2157: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);
2158: --
2159: open c1(l_budget_unit1_id);
2160: fetch c1 into l_unit1_name;

Line 2157: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);

2153: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
2154: hr_utility.set_location('l_calendar:' || l_calendar, 600);
2155: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
2156: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);
2157: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);
2158: --
2159: open c1(l_budget_unit1_id);
2160: fetch c1 into l_unit1_name;
2161: close c1;

Line 2168: hr_utility.set_location('l_unit1_name:' || l_unit1_name, 601);

2164: close c1;
2165: open c1(l_budget_unit3_id);
2166: fetch c1 into l_unit3_name;
2167: close c1;
2168: hr_utility.set_location('l_unit1_name:' || l_unit1_name, 601);
2169: hr_utility.set_location('l_unit2_name:' || l_unit2_name, 601);
2170: hr_utility.set_location('l_unit3_name:' || l_unit3_name, 601);
2171: exception
2172: when others then

Line 2169: hr_utility.set_location('l_unit2_name:' || l_unit2_name, 601);

2165: open c1(l_budget_unit3_id);
2166: fetch c1 into l_unit3_name;
2167: close c1;
2168: hr_utility.set_location('l_unit1_name:' || l_unit1_name, 601);
2169: hr_utility.set_location('l_unit2_name:' || l_unit2_name, 601);
2170: hr_utility.set_location('l_unit3_name:' || l_unit3_name, 601);
2171: exception
2172: when others then
2173: hr_utility.set_location('Error: ' || SQLERRM, 602);

Line 2170: hr_utility.set_location('l_unit3_name:' || l_unit3_name, 601);

2166: fetch c1 into l_unit3_name;
2167: close c1;
2168: hr_utility.set_location('l_unit1_name:' || l_unit1_name, 601);
2169: hr_utility.set_location('l_unit2_name:' || l_unit2_name, 601);
2170: hr_utility.set_location('l_unit3_name:' || l_unit3_name, 601);
2171: exception
2172: when others then
2173: hr_utility.set_location('Error: ' || SQLERRM, 602);
2174: return l_budgeted_fte;

Line 2173: hr_utility.set_location('Error: ' || SQLERRM, 602);

2169: hr_utility.set_location('l_unit2_name:' || l_unit2_name, 601);
2170: hr_utility.set_location('l_unit3_name:' || l_unit3_name, 601);
2171: exception
2172: when others then
2173: hr_utility.set_location('Error: ' || SQLERRM, 602);
2174: return l_budgeted_fte;
2175: end;
2176: hr_utility.set_location('l_budget_id:' || l_budget_id, 602);
2177: for i in c2(l_budget_id) loop

Line 2176: hr_utility.set_location('l_budget_id:' || l_budget_id, 602);

2172: when others then
2173: hr_utility.set_location('Error: ' || SQLERRM, 602);
2174: return l_budgeted_fte;
2175: end;
2176: hr_utility.set_location('l_budget_id:' || l_budget_id, 602);
2177: for i in c2(l_budget_id) loop
2178: -- row corresponding to the position is picked up
2179: hr_utility.set_location('budget_detail_id:' || i.budget_detail_id, 603);
2180: --

Line 2179: hr_utility.set_location('budget_detail_id:' || i.budget_detail_id, 603);

2175: end;
2176: hr_utility.set_location('l_budget_id:' || l_budget_id, 602);
2177: for i in c2(l_budget_id) loop
2178: -- row corresponding to the position is picked up
2179: hr_utility.set_location('budget_detail_id:' || i.budget_detail_id, 603);
2180: --
2181: for j in c3(i.budget_detail_id) loop
2182: hr_utility.set_location('budget_unit1_value:' || j.budget_unit1_value, 604);
2183: if l_unit1_name ='FTE' then

Line 2182: hr_utility.set_location('budget_unit1_value:' || j.budget_unit1_value, 604);

2178: -- row corresponding to the position is picked up
2179: hr_utility.set_location('budget_detail_id:' || i.budget_detail_id, 603);
2180: --
2181: for j in c3(i.budget_detail_id) loop
2182: hr_utility.set_location('budget_unit1_value:' || j.budget_unit1_value, 604);
2183: if l_unit1_name ='FTE' then
2184: l_budgeted_fte := nvl(l_budgeted_fte,0) + nvl(j.budget_unit1_value,0);
2185: elsif l_unit2_name ='FTE' then
2186: l_budgeted_fte := nvl(l_budgeted_fte,0) + nvl(j.budget_unit2_value,0);

Line 2192: hr_utility.set_location('l_budgeted_fte:' || l_budgeted_fte, 605);

2188: l_budgeted_fte := nvl(l_budgeted_fte,0) + nvl(j.budget_unit3_value,0);
2189: end if;
2190: end loop;
2191: end loop;
2192: hr_utility.set_location('l_budgeted_fte:' || l_budgeted_fte, 605);
2193: return l_budgeted_fte;
2194: end;
2195: --
2196: -- Function to calculate position budgeted FTE/Headcount

Line 2240: hr_utility.set_location('get_position_budgeted_fte' , 500);

2236:
2237: Begin
2238: for l_date in c_date
2239: loop
2240: hr_utility.set_location('get_position_budgeted_fte' , 500);
2241: hr_utility.set_location('p_start_date' || p_start_date, 501);
2242: hr_utility.set_location('p_end_date' || p_end_date, 502);
2243: hr_utility.set_location('p_effective_date' || l_date.start_date, 503);
2244:

Line 2241: hr_utility.set_location('p_start_date' || p_start_date, 501);

2237: Begin
2238: for l_date in c_date
2239: loop
2240: hr_utility.set_location('get_position_budgeted_fte' , 500);
2241: hr_utility.set_location('p_start_date' || p_start_date, 501);
2242: hr_utility.set_location('p_end_date' || p_end_date, 502);
2243: hr_utility.set_location('p_effective_date' || l_date.start_date, 503);
2244:
2245: l_budgeted_fte := budgeted_fte(p_position_id => p_position_id

Line 2242: hr_utility.set_location('p_end_date' || p_end_date, 502);

2238: for l_date in c_date
2239: loop
2240: hr_utility.set_location('get_position_budgeted_fte' , 500);
2241: hr_utility.set_location('p_start_date' || p_start_date, 501);
2242: hr_utility.set_location('p_end_date' || p_end_date, 502);
2243: hr_utility.set_location('p_effective_date' || l_date.start_date, 503);
2244:
2245: l_budgeted_fte := budgeted_fte(p_position_id => p_position_id
2246: ,p_budget_entity => p_budget_entity

Line 2243: hr_utility.set_location('p_effective_date' || l_date.start_date, 503);

2239: loop
2240: hr_utility.set_location('get_position_budgeted_fte' , 500);
2241: hr_utility.set_location('p_start_date' || p_start_date, 501);
2242: hr_utility.set_location('p_end_date' || p_end_date, 502);
2243: hr_utility.set_location('p_effective_date' || l_date.start_date, 503);
2244:
2245: l_budgeted_fte := budgeted_fte(p_position_id => p_position_id
2246: ,p_budget_entity => p_budget_entity
2247: ,p_effective_date => l_date.start_date

Line 2255: hr_utility.set_location('get_position_budgeted_fte '

2251: p_budgeted_fte_date := l_date.start_date;
2252: return (l_budgeted_fte);
2253: end if;
2254: end loop;
2255: hr_utility.set_location('get_position_budgeted_fte '
2256: ||'l_budgeted_fte: ' || l_budgeted_fte, 605);
2257: hr_utility.set_location('get_position_budgeted_fte '
2258: ||'p_budgeted_fte_date: ' || p_budgeted_fte_date, 606);
2259: return (l_budgeted_fte);

Line 2257: hr_utility.set_location('get_position_budgeted_fte '

2253: end if;
2254: end loop;
2255: hr_utility.set_location('get_position_budgeted_fte '
2256: ||'l_budgeted_fte: ' || l_budgeted_fte, 605);
2257: hr_utility.set_location('get_position_budgeted_fte '
2258: ||'p_budgeted_fte_date: ' || p_budgeted_fte_date, 606);
2259: return (l_budgeted_fte);
2260: exception when others then
2261: p_budgeted_fte_date := null;

Line 2310: hr_utility.set_location('get_job_budgeted_fte ', 500);

2306: l_budgeted_fte number;
2307: Begin
2308: for l_date in c_date
2309: loop
2310: hr_utility.set_location('get_job_budgeted_fte ', 500);
2311: hr_utility.set_location('p_start_date' || p_start_date, 501);
2312: hr_utility.set_location('p_end_date' || p_end_date, 502);
2313: hr_utility.set_location('p_effective_date' || l_date.start_date, 503);
2314:

Line 2311: hr_utility.set_location('p_start_date' || p_start_date, 501);

2307: Begin
2308: for l_date in c_date
2309: loop
2310: hr_utility.set_location('get_job_budgeted_fte ', 500);
2311: hr_utility.set_location('p_start_date' || p_start_date, 501);
2312: hr_utility.set_location('p_end_date' || p_end_date, 502);
2313: hr_utility.set_location('p_effective_date' || l_date.start_date, 503);
2314:
2315: l_budgeted_fte := budgeted_fte(

Line 2312: hr_utility.set_location('p_end_date' || p_end_date, 502);

2308: for l_date in c_date
2309: loop
2310: hr_utility.set_location('get_job_budgeted_fte ', 500);
2311: hr_utility.set_location('p_start_date' || p_start_date, 501);
2312: hr_utility.set_location('p_end_date' || p_end_date, 502);
2313: hr_utility.set_location('p_effective_date' || l_date.start_date, 503);
2314:
2315: l_budgeted_fte := budgeted_fte(
2316: p_job_id => p_job_id

Line 2313: hr_utility.set_location('p_effective_date' || l_date.start_date, 503);

2309: loop
2310: hr_utility.set_location('get_job_budgeted_fte ', 500);
2311: hr_utility.set_location('p_start_date' || p_start_date, 501);
2312: hr_utility.set_location('p_end_date' || p_end_date, 502);
2313: hr_utility.set_location('p_effective_date' || l_date.start_date, 503);
2314:
2315: l_budgeted_fte := budgeted_fte(
2316: p_job_id => p_job_id
2317: ,p_budget_entity => p_budget_entity

Line 2326: hr_utility.set_location('get_job_budgeted_fte '||'l_budgeted_fte: ' || l_budgeted_fte, 605);

2322: p_budgeted_fte_date := l_date.start_date;
2323: return (l_budgeted_fte);
2324: end if;
2325: end loop;
2326: hr_utility.set_location('get_job_budgeted_fte '||'l_budgeted_fte: ' || l_budgeted_fte, 605);
2327: hr_utility.set_location('get_job_budgeted_fte '||'p_budgeted_fte_date: ' || p_budgeted_fte_date, 606);
2328: return (l_budgeted_fte);
2329: exception when others then
2330: p_budgeted_fte_date := null;

Line 2327: hr_utility.set_location('get_job_budgeted_fte '||'p_budgeted_fte_date: ' || p_budgeted_fte_date, 606);

2323: return (l_budgeted_fte);
2324: end if;
2325: end loop;
2326: hr_utility.set_location('get_job_budgeted_fte '||'l_budgeted_fte: ' || l_budgeted_fte, 605);
2327: hr_utility.set_location('get_job_budgeted_fte '||'p_budgeted_fte_date: ' || p_budgeted_fte_date, 606);
2328: return (l_budgeted_fte);
2329: exception when others then
2330: p_budgeted_fte_date := null;
2331: raise;

Line 2380: hr_utility.set_location('get_org_budgeted_fte ', 500);

2376: l_budgeted_fte number;
2377: Begin
2378: for l_date in c_date
2379: loop
2380: hr_utility.set_location('get_org_budgeted_fte ', 500);
2381: hr_utility.set_location('p_start_date' || p_start_date, 501);
2382: hr_utility.set_location('p_end_date' || p_end_date, 502);
2383: hr_utility.set_location('p_effective_date' || l_date.start_date, 503);
2384:

Line 2381: hr_utility.set_location('p_start_date' || p_start_date, 501);

2377: Begin
2378: for l_date in c_date
2379: loop
2380: hr_utility.set_location('get_org_budgeted_fte ', 500);
2381: hr_utility.set_location('p_start_date' || p_start_date, 501);
2382: hr_utility.set_location('p_end_date' || p_end_date, 502);
2383: hr_utility.set_location('p_effective_date' || l_date.start_date, 503);
2384:
2385: l_budgeted_fte := budgeted_fte(

Line 2382: hr_utility.set_location('p_end_date' || p_end_date, 502);

2378: for l_date in c_date
2379: loop
2380: hr_utility.set_location('get_org_budgeted_fte ', 500);
2381: hr_utility.set_location('p_start_date' || p_start_date, 501);
2382: hr_utility.set_location('p_end_date' || p_end_date, 502);
2383: hr_utility.set_location('p_effective_date' || l_date.start_date, 503);
2384:
2385: l_budgeted_fte := budgeted_fte(
2386: p_organization_id => p_organization_id

Line 2383: hr_utility.set_location('p_effective_date' || l_date.start_date, 503);

2379: loop
2380: hr_utility.set_location('get_org_budgeted_fte ', 500);
2381: hr_utility.set_location('p_start_date' || p_start_date, 501);
2382: hr_utility.set_location('p_end_date' || p_end_date, 502);
2383: hr_utility.set_location('p_effective_date' || l_date.start_date, 503);
2384:
2385: l_budgeted_fte := budgeted_fte(
2386: p_organization_id => p_organization_id
2387: ,p_budget_entity => p_budget_entity

Line 2396: hr_utility.set_location('get_org_budgeted_fte '

2392: p_budgeted_fte_date := l_date.start_date;
2393: return (l_budgeted_fte);
2394: end if;
2395: end loop;
2396: hr_utility.set_location('get_org_budgeted_fte '
2397: ||'l_budgeted_fte: ' || l_budgeted_fte, 605);
2398: hr_utility.set_location('get_org_budgeted_fte '
2399: ||'p_budgeted_fte_date: ' || p_budgeted_fte_date, 606);
2400: return (l_budgeted_fte);

Line 2398: hr_utility.set_location('get_org_budgeted_fte '

2394: end if;
2395: end loop;
2396: hr_utility.set_location('get_org_budgeted_fte '
2397: ||'l_budgeted_fte: ' || l_budgeted_fte, 605);
2398: hr_utility.set_location('get_org_budgeted_fte '
2399: ||'p_budgeted_fte_date: ' || p_budgeted_fte_date, 606);
2400: return (l_budgeted_fte);
2401: exception when others then
2402: p_budgeted_fte_date := null;

Line 2451: hr_utility.set_location('p_start_date' || p_start_date, 500);

2447: l_budgeted_fte number;
2448: Begin
2449: for l_date in c_date
2450: loop
2451: hr_utility.set_location('p_start_date' || p_start_date, 500);
2452: hr_utility.set_location('p_end_date' || p_end_date, 500);
2453: hr_utility.set_location('p_effective_date' || l_date.start_date, 500);
2454:
2455: l_budgeted_fte := budgeted_fte(

Line 2452: hr_utility.set_location('p_end_date' || p_end_date, 500);

2448: Begin
2449: for l_date in c_date
2450: loop
2451: hr_utility.set_location('p_start_date' || p_start_date, 500);
2452: hr_utility.set_location('p_end_date' || p_end_date, 500);
2453: hr_utility.set_location('p_effective_date' || l_date.start_date, 500);
2454:
2455: l_budgeted_fte := budgeted_fte(
2456: p_grade_id => p_grade_id

Line 2453: hr_utility.set_location('p_effective_date' || l_date.start_date, 500);

2449: for l_date in c_date
2450: loop
2451: hr_utility.set_location('p_start_date' || p_start_date, 500);
2452: hr_utility.set_location('p_end_date' || p_end_date, 500);
2453: hr_utility.set_location('p_effective_date' || l_date.start_date, 500);
2454:
2455: l_budgeted_fte := budgeted_fte(
2456: p_grade_id => p_grade_id
2457: ,p_budget_entity => p_budget_entity

Line 2466: hr_utility.set_location('get_grade_budgeted_fte '

2462: p_budgeted_fte_date := l_date.start_date;
2463: return (l_budgeted_fte);
2464: end if;
2465: end loop;
2466: hr_utility.set_location('get_grade_budgeted_fte '
2467: ||'l_budgeted_fte: ' || l_budgeted_fte, 605);
2468: hr_utility.set_location('get_grade_budgeted_fte '
2469: ||'p_budgeted_fte_date: ' || p_budgeted_fte_date, 606);
2470: return (l_budgeted_fte);

Line 2468: hr_utility.set_location('get_grade_budgeted_fte '

2464: end if;
2465: end loop;
2466: hr_utility.set_location('get_grade_budgeted_fte '
2467: ||'l_budgeted_fte: ' || l_budgeted_fte, 605);
2468: hr_utility.set_location('get_grade_budgeted_fte '
2469: ||'p_budgeted_fte_date: ' || p_budgeted_fte_date, 606);
2470: return (l_budgeted_fte);
2471: exception when others then
2472: p_budgeted_fte_date := null;

Line 2606: hr_utility.set_location('p_effective_date' || p_effective_date, 600);

2602: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_unit_of_measure
2603: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_unit_of_measure
2604: );
2605: --
2606: hr_utility.set_location('p_effective_date' || p_effective_date, 600);
2607: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
2608: hr_utility.set_location('l_calendar:' || l_calendar, 600);
2609: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
2610: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);

Line 2607: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);

2603: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_unit_of_measure
2604: );
2605: --
2606: hr_utility.set_location('p_effective_date' || p_effective_date, 600);
2607: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
2608: hr_utility.set_location('l_calendar:' || l_calendar, 600);
2609: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
2610: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);
2611: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);

Line 2608: hr_utility.set_location('l_calendar:' || l_calendar, 600);

2604: );
2605: --
2606: hr_utility.set_location('p_effective_date' || p_effective_date, 600);
2607: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
2608: hr_utility.set_location('l_calendar:' || l_calendar, 600);
2609: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
2610: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);
2611: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);
2612: --

Line 2609: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);

2605: --
2606: hr_utility.set_location('p_effective_date' || p_effective_date, 600);
2607: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
2608: hr_utility.set_location('l_calendar:' || l_calendar, 600);
2609: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
2610: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);
2611: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);
2612: --
2613: open c1(l_budget_unit1_id);

Line 2610: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);

2606: hr_utility.set_location('p_effective_date' || p_effective_date, 600);
2607: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
2608: hr_utility.set_location('l_calendar:' || l_calendar, 600);
2609: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
2610: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);
2611: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);
2612: --
2613: open c1(l_budget_unit1_id);
2614: fetch c1 into l_unit1_name;

Line 2611: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);

2607: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
2608: hr_utility.set_location('l_calendar:' || l_calendar, 600);
2609: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
2610: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);
2611: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);
2612: --
2613: open c1(l_budget_unit1_id);
2614: fetch c1 into l_unit1_name;
2615: close c1;

Line 2622: hr_utility.set_location('l_unit1_name:' || l_unit1_name, 601);

2618: close c1;
2619: open c1(l_budget_unit3_id);
2620: fetch c1 into l_unit3_name;
2621: close c1;
2622: hr_utility.set_location('l_unit1_name:' || l_unit1_name, 601);
2623: hr_utility.set_location('l_unit2_name:' || l_unit2_name, 601);
2624: hr_utility.set_location('l_unit3_name:' || l_unit3_name, 601);
2625: exception
2626: when others then

Line 2623: hr_utility.set_location('l_unit2_name:' || l_unit2_name, 601);

2619: open c1(l_budget_unit3_id);
2620: fetch c1 into l_unit3_name;
2621: close c1;
2622: hr_utility.set_location('l_unit1_name:' || l_unit1_name, 601);
2623: hr_utility.set_location('l_unit2_name:' || l_unit2_name, 601);
2624: hr_utility.set_location('l_unit3_name:' || l_unit3_name, 601);
2625: exception
2626: when others then
2627: hr_utility.set_location('Error: ' || SQLERRM, 602);

Line 2624: hr_utility.set_location('l_unit3_name:' || l_unit3_name, 601);

2620: fetch c1 into l_unit3_name;
2621: close c1;
2622: hr_utility.set_location('l_unit1_name:' || l_unit1_name, 601);
2623: hr_utility.set_location('l_unit2_name:' || l_unit2_name, 601);
2624: hr_utility.set_location('l_unit3_name:' || l_unit3_name, 601);
2625: exception
2626: when others then
2627: hr_utility.set_location('Error: ' || SQLERRM, 602);
2628: return l_budgeted_fte;

Line 2627: hr_utility.set_location('Error: ' || SQLERRM, 602);

2623: hr_utility.set_location('l_unit2_name:' || l_unit2_name, 601);
2624: hr_utility.set_location('l_unit3_name:' || l_unit3_name, 601);
2625: exception
2626: when others then
2627: hr_utility.set_location('Error: ' || SQLERRM, 602);
2628: return l_budgeted_fte;
2629: end;
2630: hr_utility.set_location('l_budget_id:' || l_budget_id, 602);
2631: for i in c2(l_budget_id) loop

Line 2630: hr_utility.set_location('l_budget_id:' || l_budget_id, 602);

2626: when others then
2627: hr_utility.set_location('Error: ' || SQLERRM, 602);
2628: return l_budgeted_fte;
2629: end;
2630: hr_utility.set_location('l_budget_id:' || l_budget_id, 602);
2631: for i in c2(l_budget_id) loop
2632: -- row corresponding to the position is picked up
2633: hr_utility.set_location('budget_detail_id:' || i.budget_detail_id, 603);
2634: --

Line 2633: hr_utility.set_location('budget_detail_id:' || i.budget_detail_id, 603);

2629: end;
2630: hr_utility.set_location('l_budget_id:' || l_budget_id, 602);
2631: for i in c2(l_budget_id) loop
2632: -- row corresponding to the position is picked up
2633: hr_utility.set_location('budget_detail_id:' || i.budget_detail_id, 603);
2634: --
2635: for j in c3(i.budget_detail_id) loop
2636: hr_utility.set_location('budget_unit1_value:' || j.budget_unit1_value, 604);
2637: if l_unit1_name = p_unit_of_measure then

Line 2636: hr_utility.set_location('budget_unit1_value:' || j.budget_unit1_value, 604);

2632: -- row corresponding to the position is picked up
2633: hr_utility.set_location('budget_detail_id:' || i.budget_detail_id, 603);
2634: --
2635: for j in c3(i.budget_detail_id) loop
2636: hr_utility.set_location('budget_unit1_value:' || j.budget_unit1_value, 604);
2637: if l_unit1_name = p_unit_of_measure then
2638: l_budgeted_fte := nvl(l_budgeted_fte,0) + nvl(j.budget_unit1_value,0);
2639:
2640: elsif l_unit2_name = p_unit_of_measure then

Line 2649: hr_utility.set_location('l_budgeted_fte:' || l_budgeted_fte, 605);

2645:
2646: end if;
2647: end loop;
2648: end loop;
2649: hr_utility.set_location('l_budgeted_fte:' || l_budgeted_fte, 605);
2650: return l_budgeted_fte;
2651: end;
2652: --
2653: --

Line 2710: hr_utility.set_location('l_pos_fte : '||l_pos_fte, 131);

2706: open c1(p_position_id, p_effective_date);
2707: fetch c1 into l_fte;
2708: close c1;
2709: end if;
2710: hr_utility.set_location('l_pos_fte : '||l_pos_fte, 131);
2711: hr_utility.set_location('l_fte : '||l_fte, 131);
2712: if l_pos_fte - nvl(l_fte,0) >=0 then
2713: return l_pos_fte - nvl(l_fte,0);
2714: else

Line 2711: hr_utility.set_location('l_fte : '||l_fte, 131);

2707: fetch c1 into l_fte;
2708: close c1;
2709: end if;
2710: hr_utility.set_location('l_pos_fte : '||l_pos_fte, 131);
2711: hr_utility.set_location('l_fte : '||l_fte, 131);
2712: if l_pos_fte - nvl(l_fte,0) >=0 then
2713: return l_pos_fte - nvl(l_fte,0);
2714: else
2715: return 0;

Line 2726: hr_utility.set_location('uu: l_person_fte : '||l_person_fte, 131);

2722: l_reserved_fte number;
2723: begin
2724: l_person_fte := pqh_psf_bus.person_fte(p_person_id, p_position_id, p_effective_date, -1);
2725: l_reserved_fte := pqh_psf_bus.reserved_fte(p_person_id, p_position_id, p_effective_date);
2726: hr_utility.set_location('uu: l_person_fte : '||l_person_fte, 131);
2727: hr_utility.set_location('uu: l_reserved_fte : '||l_reserved_fte, 131);
2728: if l_reserved_fte>0 and l_person_fte - l_reserved_fte > 0then
2729: l_uu_fte := l_person_fte - l_reserved_fte;
2730: end if;

Line 2727: hr_utility.set_location('uu: l_reserved_fte : '||l_reserved_fte, 131);

2723: begin
2724: l_person_fte := pqh_psf_bus.person_fte(p_person_id, p_position_id, p_effective_date, -1);
2725: l_reserved_fte := pqh_psf_bus.reserved_fte(p_person_id, p_position_id, p_effective_date);
2726: hr_utility.set_location('uu: l_person_fte : '||l_person_fte, 131);
2727: hr_utility.set_location('uu: l_reserved_fte : '||l_reserved_fte, 131);
2728: if l_reserved_fte>0 and l_person_fte - l_reserved_fte > 0then
2729: l_uu_fte := l_person_fte - l_reserved_fte;
2730: end if;
2731: return l_uu_fte;

Line 2796: hr_utility.set_location('uu: l_person_fte : '||l_person_fte, 131);

2792: begin
2793: l_unreserved_fte := unreserved_fte(p_position_id, p_effective_date);
2794: l_nonreserved_asg_fte := nonreserved_asg_fte(p_position_id, p_effective_date);
2795: l_reserved_overused := reserved_overused(p_position_id, p_effective_date);
2796: hr_utility.set_location('uu: l_person_fte : '||l_person_fte, 131);
2797: hr_utility.set_location('uu: l_reserved_fte : '||l_reserved_fte, 131);
2798: hr_utility.set_location('uu: l_reserved_overused : '||l_reserved_overused, 131);
2799: l_temp := ((l_unreserved_fte - l_nonreserved_asg_fte) - l_reserved_overused);
2800: if l_temp > 0then

Line 2797: hr_utility.set_location('uu: l_reserved_fte : '||l_reserved_fte, 131);

2793: l_unreserved_fte := unreserved_fte(p_position_id, p_effective_date);
2794: l_nonreserved_asg_fte := nonreserved_asg_fte(p_position_id, p_effective_date);
2795: l_reserved_overused := reserved_overused(p_position_id, p_effective_date);
2796: hr_utility.set_location('uu: l_person_fte : '||l_person_fte, 131);
2797: hr_utility.set_location('uu: l_reserved_fte : '||l_reserved_fte, 131);
2798: hr_utility.set_location('uu: l_reserved_overused : '||l_reserved_overused, 131);
2799: l_temp := ((l_unreserved_fte - l_nonreserved_asg_fte) - l_reserved_overused);
2800: if l_temp > 0then
2801: l_uu_fte := l_temp;

Line 2798: hr_utility.set_location('uu: l_reserved_overused : '||l_reserved_overused, 131);

2794: l_nonreserved_asg_fte := nonreserved_asg_fte(p_position_id, p_effective_date);
2795: l_reserved_overused := reserved_overused(p_position_id, p_effective_date);
2796: hr_utility.set_location('uu: l_person_fte : '||l_person_fte, 131);
2797: hr_utility.set_location('uu: l_reserved_fte : '||l_reserved_fte, 131);
2798: hr_utility.set_location('uu: l_reserved_overused : '||l_reserved_overused, 131);
2799: l_temp := ((l_unreserved_fte - l_nonreserved_asg_fte) - l_reserved_overused);
2800: if l_temp > 0then
2801: l_uu_fte := l_temp;
2802: end if;

Line 2811: hr_utility.set_location('p_person_id : '||p_person_id, 131);

2807: l_remain_reserved_fte number;
2808: l_remain_unreserved_fte number;
2809: l_fte number:=0;
2810: begin
2811: hr_utility.set_location('p_person_id : '||p_person_id, 131);
2812: hr_utility.set_location('p_position_id : '||p_position_id, 131);
2813: hr_utility.set_location('p_effective_date : '||p_effective_date, 131);
2814: if p_person_id is not null and p_position_id is not null and p_effective_date is not null then
2815: l_remain_reserved_fte := remain_reserved_fte(p_person_id, p_position_id, p_effective_date);

Line 2812: hr_utility.set_location('p_position_id : '||p_position_id, 131);

2808: l_remain_unreserved_fte number;
2809: l_fte number:=0;
2810: begin
2811: hr_utility.set_location('p_person_id : '||p_person_id, 131);
2812: hr_utility.set_location('p_position_id : '||p_position_id, 131);
2813: hr_utility.set_location('p_effective_date : '||p_effective_date, 131);
2814: if p_person_id is not null and p_position_id is not null and p_effective_date is not null then
2815: l_remain_reserved_fte := remain_reserved_fte(p_person_id, p_position_id, p_effective_date);
2816: l_remain_unreserved_fte := remain_unreserved_fte(p_position_id, p_effective_date);

Line 2813: hr_utility.set_location('p_effective_date : '||p_effective_date, 131);

2809: l_fte number:=0;
2810: begin
2811: hr_utility.set_location('p_person_id : '||p_person_id, 131);
2812: hr_utility.set_location('p_position_id : '||p_position_id, 131);
2813: hr_utility.set_location('p_effective_date : '||p_effective_date, 131);
2814: if p_person_id is not null and p_position_id is not null and p_effective_date is not null then
2815: l_remain_reserved_fte := remain_reserved_fte(p_person_id, p_position_id, p_effective_date);
2816: l_remain_unreserved_fte := remain_unreserved_fte(p_position_id, p_effective_date);
2817: l_fte := l_remain_reserved_fte + l_remain_unreserved_fte;

Line 2818: hr_utility.set_location('l_remain_reserved_fte : '||l_remain_reserved_fte, 131);

2814: if p_person_id is not null and p_position_id is not null and p_effective_date is not null then
2815: l_remain_reserved_fte := remain_reserved_fte(p_person_id, p_position_id, p_effective_date);
2816: l_remain_unreserved_fte := remain_unreserved_fte(p_position_id, p_effective_date);
2817: l_fte := l_remain_reserved_fte + l_remain_unreserved_fte;
2818: hr_utility.set_location('l_remain_reserved_fte : '||l_remain_reserved_fte, 131);
2819: hr_utility.set_location('l_remain_unreserved_fte : '||l_remain_unreserved_fte, 131);
2820: hr_utility.set_location('l_fte : '||l_fte, 131);
2821: end if;
2822: return l_fte;

Line 2819: hr_utility.set_location('l_remain_unreserved_fte : '||l_remain_unreserved_fte, 131);

2815: l_remain_reserved_fte := remain_reserved_fte(p_person_id, p_position_id, p_effective_date);
2816: l_remain_unreserved_fte := remain_unreserved_fte(p_position_id, p_effective_date);
2817: l_fte := l_remain_reserved_fte + l_remain_unreserved_fte;
2818: hr_utility.set_location('l_remain_reserved_fte : '||l_remain_reserved_fte, 131);
2819: hr_utility.set_location('l_remain_unreserved_fte : '||l_remain_unreserved_fte, 131);
2820: hr_utility.set_location('l_fte : '||l_fte, 131);
2821: end if;
2822: return l_fte;
2823: end;

Line 2820: hr_utility.set_location('l_fte : '||l_fte, 131);

2816: l_remain_unreserved_fte := remain_unreserved_fte(p_position_id, p_effective_date);
2817: l_fte := l_remain_reserved_fte + l_remain_unreserved_fte;
2818: hr_utility.set_location('l_remain_reserved_fte : '||l_remain_reserved_fte, 131);
2819: hr_utility.set_location('l_remain_unreserved_fte : '||l_remain_unreserved_fte, 131);
2820: hr_utility.set_location('l_fte : '||l_fte, 131);
2821: end if;
2822: return l_fte;
2823: end;
2824: --

Line 2855: hr_utility.set_location('inside get_pos_budget',10);

2851: and p_effective_date between bvr.date_from and nvl(bvr.date_to,p_effective_date)
2852: and bdt.budget_version_id = bvr.budget_version_id
2853: and bdt.position_id = p_position_id;
2854: begin
2855: hr_utility.set_location('inside get_pos_budget',10);
2856: begin
2857: open c_bus_grp_id(p_position_id);
2858: fetch c_bus_grp_id into l_business_group_id;
2859: close c_bus_grp_id;

Line 2861: hr_utility.set_location('l_business_group_id:' || l_business_group_id, 20);

2857: open c_bus_grp_id(p_position_id);
2858: fetch c_bus_grp_id into l_business_group_id;
2859: close c_bus_grp_id;
2860: --
2861: hr_utility.set_location('l_business_group_id:' || l_business_group_id, 20);
2862: --
2863: select budget_id, budget_unit1_id, budget_unit2_id, budget_unit3_id ,period_set_name
2864: into l_budget_id, l_budget_unit1_id, l_budget_unit2_id, l_budget_unit3_id, l_calendar
2865: from pqh_budgets

Line 2875: hr_utility.set_location('budget is:'||l_budget_id,30);

2871: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
2872: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'
2873: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
2874: );
2875: hr_utility.set_location('budget is:'||l_budget_id,30);
2876: open c1(l_budget_unit1_id);
2877: fetch c1 into l_unit1_name;
2878: close c1;
2879: hr_utility.set_location('unit1 is:'||l_unit1_name,40);

Line 2879: hr_utility.set_location('unit1 is:'||l_unit1_name,40);

2875: hr_utility.set_location('budget is:'||l_budget_id,30);
2876: open c1(l_budget_unit1_id);
2877: fetch c1 into l_unit1_name;
2878: close c1;
2879: hr_utility.set_location('unit1 is:'||l_unit1_name,40);
2880: open c1(l_budget_unit2_id);
2881: fetch c1 into l_unit2_name;
2882: close c1;
2883: hr_utility.set_location('unit2 is:'||l_unit2_name,50);

Line 2883: hr_utility.set_location('unit2 is:'||l_unit2_name,50);

2879: hr_utility.set_location('unit1 is:'||l_unit1_name,40);
2880: open c1(l_budget_unit2_id);
2881: fetch c1 into l_unit2_name;
2882: close c1;
2883: hr_utility.set_location('unit2 is:'||l_unit2_name,50);
2884: open c1(l_budget_unit3_id);
2885: fetch c1 into l_unit3_name;
2886: close c1;
2887: hr_utility.set_location('unit3 is:'||l_unit3_name,60);

Line 2887: hr_utility.set_location('unit3 is:'||l_unit3_name,60);

2883: hr_utility.set_location('unit2 is:'||l_unit2_name,50);
2884: open c1(l_budget_unit3_id);
2885: fetch c1 into l_unit3_name;
2886: close c1;
2887: hr_utility.set_location('unit3 is:'||l_unit3_name,60);
2888: exception
2889: when others then
2890: hr_utility.set_location('some error occured',65);
2891: return l_budgeted_money;

Line 2890: hr_utility.set_location('some error occured',65);

2886: close c1;
2887: hr_utility.set_location('unit3 is:'||l_unit3_name,60);
2888: exception
2889: when others then
2890: hr_utility.set_location('some error occured',65);
2891: return l_budgeted_money;
2892: end;
2893: for i in c2(l_budget_id) loop
2894: hr_utility.set_location('budget_detail_id:'||i.budget_detail_id, 80);

Line 2894: hr_utility.set_location('budget_detail_id:'||i.budget_detail_id, 80);

2890: hr_utility.set_location('some error occured',65);
2891: return l_budgeted_money;
2892: end;
2893: for i in c2(l_budget_id) loop
2894: hr_utility.set_location('budget_detail_id:'||i.budget_detail_id, 80);
2895: -- row corresponding to the position is picked up
2896: if l_unit1_name ='MONEY' then
2897: l_budgeted_money := nvl(l_budgeted_money,0) + nvl(i.budget_unit1_value,0);
2898: elsif l_unit2_name ='MONEY' then

Line 2903: hr_utility.set_location('l_budgeted_money:'||l_budgeted_money, 90);

2899: l_budgeted_money := nvl(l_budgeted_money,0) + nvl(i.budget_unit2_value,0);
2900: elsif l_unit3_name ='MONEY' then
2901: l_budgeted_money := nvl(l_budgeted_money,0) + nvl(i.budget_unit3_value,0);
2902: end if;
2903: hr_utility.set_location('l_budgeted_money:'||l_budgeted_money, 90);
2904: end loop;
2905: hr_utility.set_location('total budgeted_money is:'||l_budgeted_money, 100);
2906: return l_budgeted_money;
2907: exception

Line 2905: hr_utility.set_location('total budgeted_money is:'||l_budgeted_money, 100);

2901: l_budgeted_money := nvl(l_budgeted_money,0) + nvl(i.budget_unit3_value,0);
2902: end if;
2903: hr_utility.set_location('l_budgeted_money:'||l_budgeted_money, 90);
2904: end loop;
2905: hr_utility.set_location('total budgeted_money is:'||l_budgeted_money, 100);
2906: return l_budgeted_money;
2907: exception
2908: when others then
2909: hr_utility.set_location('some error occured -2 ', 110);

Line 2909: hr_utility.set_location('some error occured -2 ', 110);

2905: hr_utility.set_location('total budgeted_money is:'||l_budgeted_money, 100);
2906: return l_budgeted_money;
2907: exception
2908: when others then
2909: hr_utility.set_location('some error occured -2 ', 110);
2910: return l_budgeted_money;
2911: end;
2912: --
2913: function get_pos_actuals_commitment(

Line 2942: hr_utility.set_location('inside chk_pos_budget',10);

2938: cursor c1(p_unit_id number) is select system_type_cd from
2939: per_shared_types where shared_type_id = p_unit_id;
2940: --
2941: begin
2942: hr_utility.set_location('inside chk_pos_budget',10);
2943: hr_utility.set_location('position_id is '||p_position_id,20);
2944: hr_utility.set_location('effective_date is '||to_char(p_effective_date,'dd-MM-RRRR'),30);
2945: begin
2946: open c_bus_grp_id(p_position_id);

Line 2943: hr_utility.set_location('position_id is '||p_position_id,20);

2939: per_shared_types where shared_type_id = p_unit_id;
2940: --
2941: begin
2942: hr_utility.set_location('inside chk_pos_budget',10);
2943: hr_utility.set_location('position_id is '||p_position_id,20);
2944: hr_utility.set_location('effective_date is '||to_char(p_effective_date,'dd-MM-RRRR'),30);
2945: begin
2946: open c_bus_grp_id(p_position_id);
2947: fetch c_bus_grp_id into l_business_group_id;

Line 2944: hr_utility.set_location('effective_date is '||to_char(p_effective_date,'dd-MM-RRRR'),30);

2940: --
2941: begin
2942: hr_utility.set_location('inside chk_pos_budget',10);
2943: hr_utility.set_location('position_id is '||p_position_id,20);
2944: hr_utility.set_location('effective_date is '||to_char(p_effective_date,'dd-MM-RRRR'),30);
2945: begin
2946: open c_bus_grp_id(p_position_id);
2947: fetch c_bus_grp_id into l_business_group_id;
2948: close c_bus_grp_id;

Line 2950: hr_utility.set_location('l_business_group_id:' || l_business_group_id,40);

2946: open c_bus_grp_id(p_position_id);
2947: fetch c_bus_grp_id into l_business_group_id;
2948: close c_bus_grp_id;
2949: --
2950: hr_utility.set_location('l_business_group_id:' || l_business_group_id,40);
2951: --
2952: select budget_id, budget_unit1_id, budget_unit2_id, budget_unit3_id ,period_set_name
2953: , budget_start_date, budget_end_date
2954: into l_budget_id, l_budget_unit1_id, l_budget_unit2_id, l_budget_unit3_id, l_calendar

Line 2966: hr_utility.set_location('budget exists' || l_budget_id, 50);

2962: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
2963: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'
2964: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
2965: );
2966: hr_utility.set_location('budget exists' || l_budget_id, 50);
2967: hr_utility.set_location('start_date is '||to_char(l_start_date,'dd-MM-RRRR'),55);
2968: hr_utility.set_location('end_date is '||to_char(l_end_date,'dd-MM-RRRR'),60);
2969: --
2970: select budget_version_id into l_budget_version_id

Line 2967: hr_utility.set_location('start_date is '||to_char(l_start_date,'dd-MM-RRRR'),55);

2963: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'
2964: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
2965: );
2966: hr_utility.set_location('budget exists' || l_budget_id, 50);
2967: hr_utility.set_location('start_date is '||to_char(l_start_date,'dd-MM-RRRR'),55);
2968: hr_utility.set_location('end_date is '||to_char(l_end_date,'dd-MM-RRRR'),60);
2969: --
2970: select budget_version_id into l_budget_version_id
2971: from pqh_budget_versions bvr

Line 2968: hr_utility.set_location('end_date is '||to_char(l_end_date,'dd-MM-RRRR'),60);

2964: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
2965: );
2966: hr_utility.set_location('budget exists' || l_budget_id, 50);
2967: hr_utility.set_location('start_date is '||to_char(l_start_date,'dd-MM-RRRR'),55);
2968: hr_utility.set_location('end_date is '||to_char(l_end_date,'dd-MM-RRRR'),60);
2969: --
2970: select budget_version_id into l_budget_version_id
2971: from pqh_budget_versions bvr
2972: where budget_id = l_budget_id

Line 2974: hr_utility.set_location('budget version exists' || l_budget_version_id, 70);

2970: select budget_version_id into l_budget_version_id
2971: from pqh_budget_versions bvr
2972: where budget_id = l_budget_id
2973: and p_effective_date between bvr.date_from and nvl(bvr.date_to,p_effective_date);
2974: hr_utility.set_location('budget version exists' || l_budget_version_id, 70);
2975: open c1(l_budget_unit1_id);
2976: fetch c1 into l_unit1_name;
2977: close c1;
2978: hr_utility.set_location('unit1 is ' || l_unit1_name, 80);

Line 2978: hr_utility.set_location('unit1 is ' || l_unit1_name, 80);

2974: hr_utility.set_location('budget version exists' || l_budget_version_id, 70);
2975: open c1(l_budget_unit1_id);
2976: fetch c1 into l_unit1_name;
2977: close c1;
2978: hr_utility.set_location('unit1 is ' || l_unit1_name, 80);
2979: open c1(l_budget_unit2_id);
2980: fetch c1 into l_unit2_name;
2981: close c1;
2982: hr_utility.set_location('unit2 is ' || l_unit2_name, 90);

Line 2982: hr_utility.set_location('unit2 is ' || l_unit2_name, 90);

2978: hr_utility.set_location('unit1 is ' || l_unit1_name, 80);
2979: open c1(l_budget_unit2_id);
2980: fetch c1 into l_unit2_name;
2981: close c1;
2982: hr_utility.set_location('unit2 is ' || l_unit2_name, 90);
2983: open c1(l_budget_unit3_id);
2984: fetch c1 into l_unit3_name;
2985: close c1;
2986: hr_utility.set_location('unit3 is ' || l_unit3_name, 100);

Line 2986: hr_utility.set_location('unit3 is ' || l_unit3_name, 100);

2982: hr_utility.set_location('unit2 is ' || l_unit2_name, 90);
2983: open c1(l_budget_unit3_id);
2984: fetch c1 into l_unit3_name;
2985: close c1;
2986: hr_utility.set_location('unit3 is ' || l_unit3_name, 100);
2987: exception
2988: when others then
2989: hr_utility.set_location('some error occured', 110);
2990: return null;

Line 2989: hr_utility.set_location('some error occured', 110);

2985: close c1;
2986: hr_utility.set_location('unit3 is ' || l_unit3_name, 100);
2987: exception
2988: when others then
2989: hr_utility.set_location('some error occured', 110);
2990: return null;
2991: end;
2992: --
2993: if l_unit1_name ='MONEY' then

Line 3005: hr_utility.set_location('unit1_amt is'||l_actual_commitment, 120);

3001: p_unit_of_measure_id =>l_budget_unit1_id,
3002: p_value_type =>'T',
3003: p_ex_assignment_id =>p_ex_assignment_id
3004: );
3005: hr_utility.set_location('unit1_amt is'||l_actual_commitment, 120);
3006: elsif l_unit2_name ='MONEY' then
3007: l_actual_commitment := l_actual_commitment +
3008: pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt
3009: (

Line 3018: hr_utility.set_location('unit2_amt is'||l_actual_commitment, 120);

3014: p_unit_of_measure_id =>l_budget_unit2_id,
3015: p_value_type =>'T',
3016: p_ex_assignment_id =>p_ex_assignment_id
3017: );
3018: hr_utility.set_location('unit2_amt is'||l_actual_commitment, 120);
3019: elsif l_unit3_name ='MONEY' then
3020: l_actual_commitment := l_actual_commitment +
3021: pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt
3022: (

Line 3031: hr_utility.set_location('unit3_amt is'||l_actual_commitment, 120);

3027: p_unit_of_measure_id =>l_budget_unit3_id,
3028: p_value_type =>'T',
3029: p_ex_assignment_id =>p_ex_assignment_id
3030: );
3031: hr_utility.set_location('unit3_amt is'||l_actual_commitment, 120);
3032: end if;
3033: return l_actual_commitment;
3034: exception
3035: when others then

Line 3036: hr_utility.set_location('some error occured - 2', 120);

3032: end if;
3033: return l_actual_commitment;
3034: exception
3035: when others then
3036: hr_utility.set_location('some error occured - 2', 120);
3037: return null;
3038: end;
3039: --
3040: function get_asg_actuals_commitment(

Line 3074: hr_utility.set_location('l_business_group_id:' || l_business_group_id, 600

3070: open c_bus_grp_id(p_assignment_id);
3071: fetch c_bus_grp_id into l_business_group_id;
3072: close c_bus_grp_id;
3073: --
3074: hr_utility.set_location('l_business_group_id:' || l_business_group_id, 600
3075: );
3076: --
3077: select budget_id, budget_unit1_id, budget_unit2_id, budget_unit3_id ,period_set_name
3078: , budget_start_date, budget_end_date

Line 3161: hr_utility.set_location('inside chk_pos_budget', 30);

3157: function chk_pos_budget(p_position_id in number, p_effective_date in date) return boolean is
3158: l_budgeted_money number;
3159: l_pos_actuals_commitment number;
3160: begin
3161: hr_utility.set_location('inside chk_pos_budget', 30);
3162: l_budgeted_money := budgeted_money(p_position_id,p_effective_date);
3163: l_pos_actuals_commitment := get_pos_actuals_commitment(p_position_id,p_effective_date);
3164: hr_utility.set_location('l_budgeted_money:'||l_budgeted_money, 10);
3165: hr_utility.set_location('l_pos_actuals_commitment:'||l_pos_actuals_commitment, 20);

Line 3164: hr_utility.set_location('l_budgeted_money:'||l_budgeted_money, 10);

3160: begin
3161: hr_utility.set_location('inside chk_pos_budget', 30);
3162: l_budgeted_money := budgeted_money(p_position_id,p_effective_date);
3163: l_pos_actuals_commitment := get_pos_actuals_commitment(p_position_id,p_effective_date);
3164: hr_utility.set_location('l_budgeted_money:'||l_budgeted_money, 10);
3165: hr_utility.set_location('l_pos_actuals_commitment:'||l_pos_actuals_commitment, 20);
3166: if l_budgeted_money <> -1 and l_pos_actuals_commitment <> -1 then
3167: if l_pos_actuals_commitment >l_budgeted_money then
3168: hr_utility.set_location('actual> budget', 30);

Line 3165: hr_utility.set_location('l_pos_actuals_commitment:'||l_pos_actuals_commitment, 20);

3161: hr_utility.set_location('inside chk_pos_budget', 30);
3162: l_budgeted_money := budgeted_money(p_position_id,p_effective_date);
3163: l_pos_actuals_commitment := get_pos_actuals_commitment(p_position_id,p_effective_date);
3164: hr_utility.set_location('l_budgeted_money:'||l_budgeted_money, 10);
3165: hr_utility.set_location('l_pos_actuals_commitment:'||l_pos_actuals_commitment, 20);
3166: if l_budgeted_money <> -1 and l_pos_actuals_commitment <> -1 then
3167: if l_pos_actuals_commitment >l_budgeted_money then
3168: hr_utility.set_location('actual> budget', 30);
3169: return false;

Line 3168: hr_utility.set_location('actual> budget', 30);

3164: hr_utility.set_location('l_budgeted_money:'||l_budgeted_money, 10);
3165: hr_utility.set_location('l_pos_actuals_commitment:'||l_pos_actuals_commitment, 20);
3166: if l_budgeted_money <> -1 and l_pos_actuals_commitment <> -1 then
3167: if l_pos_actuals_commitment >l_budgeted_money then
3168: hr_utility.set_location('actual> budget', 30);
3169: return false;
3170: end if;
3171: end if;
3172: return true;

Line 3185: hr_utility.set_location('l_budgeted_money:'||l_budgeted_money, 100);

3181: l_pos_actuals_cmmt_ex_asg number;
3182: l_asg_actuals_commitment number;
3183: begin
3184: l_budgeted_money := budgeted_money(p_position_id,p_effective_date);
3185: hr_utility.set_location('l_budgeted_money:'||l_budgeted_money, 100);
3186: if l_budgeted_money > -1 then
3187: l_asg_actuals_commitment := get_asg_actuals_commitment(p_ex_assignment_id,p_effective_date);
3188: hr_utility.set_location('l_asg_actuals_commitment:'||l_asg_actuals_commitment, 100);
3189: if l_asg_actuals_commitment > 0 then

Line 3188: hr_utility.set_location('l_asg_actuals_commitment:'||l_asg_actuals_commitment, 100);

3184: l_budgeted_money := budgeted_money(p_position_id,p_effective_date);
3185: hr_utility.set_location('l_budgeted_money:'||l_budgeted_money, 100);
3186: if l_budgeted_money > -1 then
3187: l_asg_actuals_commitment := get_asg_actuals_commitment(p_ex_assignment_id,p_effective_date);
3188: hr_utility.set_location('l_asg_actuals_commitment:'||l_asg_actuals_commitment, 100);
3189: if l_asg_actuals_commitment > 0 then
3190: l_pos_actuals_cmmt_ex_asg := get_pos_actuals_commitment(
3191: p_position_id,
3192: p_effective_date,

Line 3196: hr_utility.set_location('l_pos_actuals_cmmt_ex_asg:'||l_pos_actuals_cmmt_ex_asg, 100);

3192: p_effective_date,
3193: p_ex_assignment_id);
3194: l_pos_actuals_commitment := l_pos_actuals_cmmt_ex_asg+l_asg_actuals_commitment;
3195:
3196: hr_utility.set_location('l_pos_actuals_cmmt_ex_asg:'||l_pos_actuals_cmmt_ex_asg, 100);
3197: hr_utility.set_location('l_pos_actuals_commitment:'||l_pos_actuals_commitment, 100);
3198: if l_pos_actuals_cmmt_ex_asg <> -1 then
3199: if ((l_pos_actuals_cmmt_ex_asg < l_budgeted_money)
3200: and (l_pos_actuals_commitment > l_budgeted_money)) then

Line 3197: hr_utility.set_location('l_pos_actuals_commitment:'||l_pos_actuals_commitment, 100);

3193: p_ex_assignment_id);
3194: l_pos_actuals_commitment := l_pos_actuals_cmmt_ex_asg+l_asg_actuals_commitment;
3195:
3196: hr_utility.set_location('l_pos_actuals_cmmt_ex_asg:'||l_pos_actuals_cmmt_ex_asg, 100);
3197: hr_utility.set_location('l_pos_actuals_commitment:'||l_pos_actuals_commitment, 100);
3198: if l_pos_actuals_cmmt_ex_asg <> -1 then
3199: if ((l_pos_actuals_cmmt_ex_asg < l_budgeted_money)
3200: and (l_pos_actuals_commitment > l_budgeted_money)) then
3201: return true;

Line 3295: hr_utility.set_location('l_nonreserved_fte : '||l_nonreserved_fte, 131);

3291: begin
3292: open c1(p_position_id, p_effective_date,
3293: p_ex_position_extra_info_id, p_ex_person_id);
3294: fetch c1 into l_nonreserved_fte;
3295: hr_utility.set_location('l_nonreserved_fte : '||l_nonreserved_fte, 131);
3296: return nvl(l_nonreserved_fte,0);
3297: end;
3298: --
3299: function position_fte(p_position_id number, p_effective_date date) return number is

Line 3341: hr_utility.set_location('l_person_id : '||l_person_id, 630);

3337: begin
3338: if p_person_id is not null and p_position_id is not null and p_effective_date is not null then
3339: open c_budgeted_fte(p_person_id, p_position_id);
3340: fetch c_budgeted_fte into l_assignment_fte;
3341: hr_utility.set_location('l_person_id : '||l_person_id, 630);
3342: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 630);
3343: close c_budgeted_fte;
3344: end if;
3345: return(l_assignment_fte);

Line 3342: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 630);

3338: if p_person_id is not null and p_position_id is not null and p_effective_date is not null then
3339: open c_budgeted_fte(p_person_id, p_position_id);
3340: fetch c_budgeted_fte into l_assignment_fte;
3341: hr_utility.set_location('l_person_id : '||l_person_id, 630);
3342: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 630);
3343: close c_budgeted_fte;
3344: end if;
3345: return(l_assignment_fte);
3346: end;

Line 3429: hr_utility.set_location('effective date : '||r1.effective_date, 10);

3425: ,p_system_budget_unit => 'FTE'
3426: ,p_business_group_id => l_business_group_id
3427: );
3428: --
3429: hr_utility.set_location('effective date : '||r1.effective_date, 10);
3430: hr_utility.set_location('l_total_fte : '|| l_total_fte, 20);
3431: hr_utility.set_location('l_reserved_fte : '||l_reserved_fte, 30);
3432: hr_utility.set_location('l_nonreserved_asg_fte : '||l_nonreserved_asg_fte, 40);
3433: hr_utility.set_location('l_person_asg_fte : '||l_person_asg_fte, 50);

Line 3430: hr_utility.set_location('l_total_fte : '|| l_total_fte, 20);

3426: ,p_business_group_id => l_business_group_id
3427: );
3428: --
3429: hr_utility.set_location('effective date : '||r1.effective_date, 10);
3430: hr_utility.set_location('l_total_fte : '|| l_total_fte, 20);
3431: hr_utility.set_location('l_reserved_fte : '||l_reserved_fte, 30);
3432: hr_utility.set_location('l_nonreserved_asg_fte : '||l_nonreserved_asg_fte, 40);
3433: hr_utility.set_location('l_person_asg_fte : '||l_person_asg_fte, 50);
3434: hr_utility.set_location('l_poei_fte : '||l_poei_fte, 60);

Line 3431: hr_utility.set_location('l_reserved_fte : '||l_reserved_fte, 30);

3427: );
3428: --
3429: hr_utility.set_location('effective date : '||r1.effective_date, 10);
3430: hr_utility.set_location('l_total_fte : '|| l_total_fte, 20);
3431: hr_utility.set_location('l_reserved_fte : '||l_reserved_fte, 30);
3432: hr_utility.set_location('l_nonreserved_asg_fte : '||l_nonreserved_asg_fte, 40);
3433: hr_utility.set_location('l_person_asg_fte : '||l_person_asg_fte, 50);
3434: hr_utility.set_location('l_poei_fte : '||l_poei_fte, 60);
3435: hr_utility.set_location('l_position_fte : '||l_position_fte, 70);

Line 3432: hr_utility.set_location('l_nonreserved_asg_fte : '||l_nonreserved_asg_fte, 40);

3428: --
3429: hr_utility.set_location('effective date : '||r1.effective_date, 10);
3430: hr_utility.set_location('l_total_fte : '|| l_total_fte, 20);
3431: hr_utility.set_location('l_reserved_fte : '||l_reserved_fte, 30);
3432: hr_utility.set_location('l_nonreserved_asg_fte : '||l_nonreserved_asg_fte, 40);
3433: hr_utility.set_location('l_person_asg_fte : '||l_person_asg_fte, 50);
3434: hr_utility.set_location('l_poei_fte : '||l_poei_fte, 60);
3435: hr_utility.set_location('l_position_fte : '||l_position_fte, 70);
3436: hr_utility.set_location('l_budgeted_fte : '||l_budgeted_fte, 80);

Line 3433: hr_utility.set_location('l_person_asg_fte : '||l_person_asg_fte, 50);

3429: hr_utility.set_location('effective date : '||r1.effective_date, 10);
3430: hr_utility.set_location('l_total_fte : '|| l_total_fte, 20);
3431: hr_utility.set_location('l_reserved_fte : '||l_reserved_fte, 30);
3432: hr_utility.set_location('l_nonreserved_asg_fte : '||l_nonreserved_asg_fte, 40);
3433: hr_utility.set_location('l_person_asg_fte : '||l_person_asg_fte, 50);
3434: hr_utility.set_location('l_poei_fte : '||l_poei_fte, 60);
3435: hr_utility.set_location('l_position_fte : '||l_position_fte, 70);
3436: hr_utility.set_location('l_budgeted_fte : '||l_budgeted_fte, 80);
3437: hr_utility.set_location('l_realloc_fte : '||l_realloc_fte, 85);

Line 3434: hr_utility.set_location('l_poei_fte : '||l_poei_fte, 60);

3430: hr_utility.set_location('l_total_fte : '|| l_total_fte, 20);
3431: hr_utility.set_location('l_reserved_fte : '||l_reserved_fte, 30);
3432: hr_utility.set_location('l_nonreserved_asg_fte : '||l_nonreserved_asg_fte, 40);
3433: hr_utility.set_location('l_person_asg_fte : '||l_person_asg_fte, 50);
3434: hr_utility.set_location('l_poei_fte : '||l_poei_fte, 60);
3435: hr_utility.set_location('l_position_fte : '||l_position_fte, 70);
3436: hr_utility.set_location('l_budgeted_fte : '||l_budgeted_fte, 80);
3437: hr_utility.set_location('l_realloc_fte : '||l_realloc_fte, 85);
3438: --

Line 3435: hr_utility.set_location('l_position_fte : '||l_position_fte, 70);

3431: hr_utility.set_location('l_reserved_fte : '||l_reserved_fte, 30);
3432: hr_utility.set_location('l_nonreserved_asg_fte : '||l_nonreserved_asg_fte, 40);
3433: hr_utility.set_location('l_person_asg_fte : '||l_person_asg_fte, 50);
3434: hr_utility.set_location('l_poei_fte : '||l_poei_fte, 60);
3435: hr_utility.set_location('l_position_fte : '||l_position_fte, 70);
3436: hr_utility.set_location('l_budgeted_fte : '||l_budgeted_fte, 80);
3437: hr_utility.set_location('l_realloc_fte : '||l_realloc_fte, 85);
3438: --
3439: if l_budgeted_fte is not null or l_realloc_fte is not null then

Line 3436: hr_utility.set_location('l_budgeted_fte : '||l_budgeted_fte, 80);

3432: hr_utility.set_location('l_nonreserved_asg_fte : '||l_nonreserved_asg_fte, 40);
3433: hr_utility.set_location('l_person_asg_fte : '||l_person_asg_fte, 50);
3434: hr_utility.set_location('l_poei_fte : '||l_poei_fte, 60);
3435: hr_utility.set_location('l_position_fte : '||l_position_fte, 70);
3436: hr_utility.set_location('l_budgeted_fte : '||l_budgeted_fte, 80);
3437: hr_utility.set_location('l_realloc_fte : '||l_realloc_fte, 85);
3438: --
3439: if l_budgeted_fte is not null or l_realloc_fte is not null then
3440: --

Line 3437: hr_utility.set_location('l_realloc_fte : '||l_realloc_fte, 85);

3433: hr_utility.set_location('l_person_asg_fte : '||l_person_asg_fte, 50);
3434: hr_utility.set_location('l_poei_fte : '||l_poei_fte, 60);
3435: hr_utility.set_location('l_position_fte : '||l_position_fte, 70);
3436: hr_utility.set_location('l_budgeted_fte : '||l_budgeted_fte, 80);
3437: hr_utility.set_location('l_realloc_fte : '||l_realloc_fte, 85);
3438: --
3439: if l_budgeted_fte is not null or l_realloc_fte is not null then
3440: --
3441: l_bgt_realloc := nvl(l_budgeted_fte,0) + nvl(l_realloc_fte,0);

Line 3444: hr_utility.set_message(8302,'PQH_RES_FTE_GT_AVL_POS_BGT_FTE');

3440: --
3441: l_bgt_realloc := nvl(l_budgeted_fte,0) + nvl(l_realloc_fte,0);
3442: --
3443: if l_total_fte > l_bgt_realloc then
3444: hr_utility.set_message(8302,'PQH_RES_FTE_GT_AVL_POS_BGT_FTE');
3445: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));
3446: hr_utility.set_message_token('EFFECTIVE_DATE', r1.effective_date);
3447: hr_utility.raise_error;
3448: end if;

Line 3445: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));

3441: l_bgt_realloc := nvl(l_budgeted_fte,0) + nvl(l_realloc_fte,0);
3442: --
3443: if l_total_fte > l_bgt_realloc then
3444: hr_utility.set_message(8302,'PQH_RES_FTE_GT_AVL_POS_BGT_FTE');
3445: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));
3446: hr_utility.set_message_token('EFFECTIVE_DATE', r1.effective_date);
3447: hr_utility.raise_error;
3448: end if;
3449: else

Line 3446: hr_utility.set_message_token('EFFECTIVE_DATE', r1.effective_date);

3442: --
3443: if l_total_fte > l_bgt_realloc then
3444: hr_utility.set_message(8302,'PQH_RES_FTE_GT_AVL_POS_BGT_FTE');
3445: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));
3446: hr_utility.set_message_token('EFFECTIVE_DATE', r1.effective_date);
3447: hr_utility.raise_error;
3448: end if;
3449: else
3450: if l_total_fte > l_position_fte then

Line 3447: hr_utility.raise_error;

3443: if l_total_fte > l_bgt_realloc then
3444: hr_utility.set_message(8302,'PQH_RES_FTE_GT_AVL_POS_BGT_FTE');
3445: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));
3446: hr_utility.set_message_token('EFFECTIVE_DATE', r1.effective_date);
3447: hr_utility.raise_error;
3448: end if;
3449: else
3450: if l_total_fte > l_position_fte then
3451: hr_utility.set_message(8302,'PQH_RES_FTE_GT_AVL_POS_FTE');

Line 3451: hr_utility.set_message(8302,'PQH_RES_FTE_GT_AVL_POS_FTE');

3447: hr_utility.raise_error;
3448: end if;
3449: else
3450: if l_total_fte > l_position_fte then
3451: hr_utility.set_message(8302,'PQH_RES_FTE_GT_AVL_POS_FTE');
3452: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));
3453: hr_utility.set_message_token('EFFECTIVE_DATE', r1.effective_date);
3454: hr_utility.raise_error;
3455: end if;

Line 3452: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));

3448: end if;
3449: else
3450: if l_total_fte > l_position_fte then
3451: hr_utility.set_message(8302,'PQH_RES_FTE_GT_AVL_POS_FTE');
3452: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));
3453: hr_utility.set_message_token('EFFECTIVE_DATE', r1.effective_date);
3454: hr_utility.raise_error;
3455: end if;
3456: end if;

Line 3453: hr_utility.set_message_token('EFFECTIVE_DATE', r1.effective_date);

3449: else
3450: if l_total_fte > l_position_fte then
3451: hr_utility.set_message(8302,'PQH_RES_FTE_GT_AVL_POS_FTE');
3452: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));
3453: hr_utility.set_message_token('EFFECTIVE_DATE', r1.effective_date);
3454: hr_utility.raise_error;
3455: end if;
3456: end if;
3457: end loop;

Line 3454: hr_utility.raise_error;

3450: if l_total_fte > l_position_fte then
3451: hr_utility.set_message(8302,'PQH_RES_FTE_GT_AVL_POS_FTE');
3452: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));
3453: hr_utility.set_message_token('EFFECTIVE_DATE', r1.effective_date);
3454: hr_utility.raise_error;
3455: end if;
3456: end if;
3457: end loop;
3458: end;

Line 3498: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_position_type'||l_position_type , 20);

3494: fetch c_pos_fte into l_position_type,
3495: l_overlap_period, l_business_group_id;
3496: close c_pos_fte;
3497: --
3498: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_position_type'||l_position_type , 20);
3499: --
3500: --
3501: if l_position_type in ('SHARED', 'SINGLE') then
3502: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(

Line 3508: hr_utility.set_location('Entering chk_reserved_fte', 100);

3504: p_overlap_period => l_overlap_period,
3505: p_assignment_start_date => p_effective_date);
3506: if not l_overlap_dates_present then
3507:
3508: hr_utility.set_location('Entering chk_reserved_fte', 100);
3509: --
3510: open c_pos_reserved(p_position_id, p_effective_date);
3511: fetch c_pos_reserved into l_dummy;
3512: if c_pos_reserved%notfound then

Line 3513: hr_utility.set_location('Exiting chk_reserved_fte FALSE', 100);

3509: --
3510: open c_pos_reserved(p_position_id, p_effective_date);
3511: fetch c_pos_reserved into l_dummy;
3512: if c_pos_reserved%notfound then
3513: hr_utility.set_location('Exiting chk_reserved_fte FALSE', 100);
3514: close c_pos_reserved;
3515: return false;
3516: else
3517: close c_pos_reserved;

Line 3521: hr_utility.set_location('p_position_type is SINGLE ', 110);

3517: close c_pos_reserved;
3518: end if;
3519: l_available_fte := pqh_psf_bus.available_fte(p_person_id, p_position_id, p_effective_date);
3520: if l_position_type = 'SINGLE' then
3521: hr_utility.set_location('p_position_type is SINGLE ', 110);
3522: l_assignment_fte := 1;
3523: elsif p_assignment_id is not null then
3524: hr_utility.set_location('p_assignment_id is not null ', 111);
3525: l_assignment_fte := nvl(pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date),0

Line 3524: hr_utility.set_location('p_assignment_id is not null ', 111);

3520: if l_position_type = 'SINGLE' then
3521: hr_utility.set_location('p_position_type is SINGLE ', 110);
3522: l_assignment_fte := 1;
3523: elsif p_assignment_id is not null then
3524: hr_utility.set_location('p_assignment_id is not null ', 111);
3525: l_assignment_fte := nvl(pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date),0
3526: );
3527: else
3528: hr_utility.set_location('p_assignment_id is null and pos type SHARED', 112);

Line 3528: hr_utility.set_location('p_assignment_id is null and pos type SHARED', 112);

3524: hr_utility.set_location('p_assignment_id is not null ', 111);
3525: l_assignment_fte := nvl(pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date),0
3526: );
3527: else
3528: hr_utility.set_location('p_assignment_id is null and pos type SHARED', 112);
3529: l_assignment_fte := p_default_asg_fte;
3530: end if;
3531: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
3532: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 132);

Line 3531: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);

3527: else
3528: hr_utility.set_location('p_assignment_id is null and pos type SHARED', 112);
3529: l_assignment_fte := p_default_asg_fte;
3530: end if;
3531: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
3532: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 132);
3533: hr_utility.set_location('p_default_asg_fte : '||p_default_asg_fte, 133);
3534: if (l_assignment_fte > l_available_fte) then
3535: hr_utility.set_location('Exiting chk_reserved_fte TRUE', 100);

Line 3532: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 132);

3528: hr_utility.set_location('p_assignment_id is null and pos type SHARED', 112);
3529: l_assignment_fte := p_default_asg_fte;
3530: end if;
3531: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
3532: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 132);
3533: hr_utility.set_location('p_default_asg_fte : '||p_default_asg_fte, 133);
3534: if (l_assignment_fte > l_available_fte) then
3535: hr_utility.set_location('Exiting chk_reserved_fte TRUE', 100);
3536: return true;

Line 3533: hr_utility.set_location('p_default_asg_fte : '||p_default_asg_fte, 133);

3529: l_assignment_fte := p_default_asg_fte;
3530: end if;
3531: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
3532: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 132);
3533: hr_utility.set_location('p_default_asg_fte : '||p_default_asg_fte, 133);
3534: if (l_assignment_fte > l_available_fte) then
3535: hr_utility.set_location('Exiting chk_reserved_fte TRUE', 100);
3536: return true;
3537: else

Line 3535: hr_utility.set_location('Exiting chk_reserved_fte TRUE', 100);

3531: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
3532: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 132);
3533: hr_utility.set_location('p_default_asg_fte : '||p_default_asg_fte, 133);
3534: if (l_assignment_fte > l_available_fte) then
3535: hr_utility.set_location('Exiting chk_reserved_fte TRUE', 100);
3536: return true;
3537: else
3538: hr_utility.set_location('Exiting chk_reserved_fte FALSE', 100);
3539: return false;

Line 3538: hr_utility.set_location('Exiting chk_reserved_fte FALSE', 100);

3534: if (l_assignment_fte > l_available_fte) then
3535: hr_utility.set_location('Exiting chk_reserved_fte TRUE', 100);
3536: return true;
3537: else
3538: hr_utility.set_location('Exiting chk_reserved_fte FALSE', 100);
3539: return false;
3540: end if;
3541: end if;
3542: end if;

Line 3543: hr_utility.set_location('Exiting chk_reserved_fte FALSE', 420);

3539: return false;
3540: end if;
3541: end if;
3542: end if;
3543: hr_utility.set_location('Exiting chk_reserved_fte FALSE', 420);
3544: return false;
3545: end;
3546: --
3547: function chk_pos_reserve_exists(p_position_id number,

Line 3570: hr_utility.set_location('Exiting chk_pos_reserve_exists TRUE', 100);

3566: begin
3567: open c_pos_reserved(p_position_id, p_effective_date);
3568: fetch c_pos_reserved into l_dummy;
3569: if c_pos_reserved%found then
3570: hr_utility.set_location('Exiting chk_pos_reserve_exists TRUE', 100);
3571: close c_pos_reserved;
3572: return true;
3573: end if;
3574: hr_utility.set_location('Exiting chk_pos_reserve_exists FALSE', 100);

Line 3574: hr_utility.set_location('Exiting chk_pos_reserve_exists FALSE', 100);

3570: hr_utility.set_location('Exiting chk_pos_reserve_exists TRUE', 100);
3571: close c_pos_reserved;
3572: return true;
3573: end if;
3574: hr_utility.set_location('Exiting chk_pos_reserve_exists FALSE', 100);
3575: close c_pos_reserved;
3576: return false;
3577: end;
3578: --

Line 3657: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 201);

3653: where position_id = p_position_id
3654: and effective_start_date between p_validation_start_date and p_validation_end_date;
3655: --
3656: begin
3657: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 201);
3658: hr_utility.set_location('chk_future_reserved_fte p_validation_start_date: '
3659: ||p_validation_start_date, 202);
3660: hr_utility.set_location('chk_future_reserved_fte p_validation_end_date: '
3661: ||p_validation_end_date, 202);

Line 3658: hr_utility.set_location('chk_future_reserved_fte p_validation_start_date: '

3654: and effective_start_date between p_validation_start_date and p_validation_end_date;
3655: --
3656: begin
3657: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 201);
3658: hr_utility.set_location('chk_future_reserved_fte p_validation_start_date: '
3659: ||p_validation_start_date, 202);
3660: hr_utility.set_location('chk_future_reserved_fte p_validation_end_date: '
3661: ||p_validation_end_date, 202);
3662: if (p_position_id is not null) then

Line 3660: hr_utility.set_location('chk_future_reserved_fte p_validation_end_date: '

3656: begin
3657: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 201);
3658: hr_utility.set_location('chk_future_reserved_fte p_validation_start_date: '
3659: ||p_validation_start_date, 202);
3660: hr_utility.set_location('chk_future_reserved_fte p_validation_end_date: '
3661: ||p_validation_end_date, 202);
3662: if (p_position_id is not null) then
3663: if chk_pos_reserve_exists(p_position_id,
3664: p_validation_start_date) then

Line 3668: hr_utility.set_location('chk_future_reserved_fte r1.effective_start_date : '

3664: p_validation_start_date) then
3665: if (p_assignment_id is not null) then
3666: for r1 in c1(p_assignment_id, p_position_id, p_validation_start_date, p_validation_end_date)
3667: loop
3668: hr_utility.set_location('chk_future_reserved_fte r1.effective_start_date : '
3669: ||r1.effective_start_date, 203);
3670: hr_utility.set_location('chk_future_reserved_fte p_assignment_id : '||p_assignment_id, 203);
3671: hr_utility.set_location('chk_future_reserved_fte p_person_id : '||p_person_id, 203);
3672: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 203);

Line 3670: hr_utility.set_location('chk_future_reserved_fte p_assignment_id : '||p_assignment_id, 203);

3666: for r1 in c1(p_assignment_id, p_position_id, p_validation_start_date, p_validation_end_date)
3667: loop
3668: hr_utility.set_location('chk_future_reserved_fte r1.effective_start_date : '
3669: ||r1.effective_start_date, 203);
3670: hr_utility.set_location('chk_future_reserved_fte p_assignment_id : '||p_assignment_id, 203);
3671: hr_utility.set_location('chk_future_reserved_fte p_person_id : '||p_person_id, 203);
3672: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 203);
3673: hr_utility.set_location('chk_future_reserved_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3674: if chk_reserved_fte(p_assignment_id, p_person_id, p_position_id, p_position_type,

Line 3671: hr_utility.set_location('chk_future_reserved_fte p_person_id : '||p_person_id, 203);

3667: loop
3668: hr_utility.set_location('chk_future_reserved_fte r1.effective_start_date : '
3669: ||r1.effective_start_date, 203);
3670: hr_utility.set_location('chk_future_reserved_fte p_assignment_id : '||p_assignment_id, 203);
3671: hr_utility.set_location('chk_future_reserved_fte p_person_id : '||p_person_id, 203);
3672: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 203);
3673: hr_utility.set_location('chk_future_reserved_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3674: if chk_reserved_fte(p_assignment_id, p_person_id, p_position_id, p_position_type,
3675: r1.effective_start_date, p_default_asg_fte) then

Line 3672: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 203);

3668: hr_utility.set_location('chk_future_reserved_fte r1.effective_start_date : '
3669: ||r1.effective_start_date, 203);
3670: hr_utility.set_location('chk_future_reserved_fte p_assignment_id : '||p_assignment_id, 203);
3671: hr_utility.set_location('chk_future_reserved_fte p_person_id : '||p_person_id, 203);
3672: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 203);
3673: hr_utility.set_location('chk_future_reserved_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3674: if chk_reserved_fte(p_assignment_id, p_person_id, p_position_id, p_position_type,
3675: r1.effective_start_date, p_default_asg_fte) then
3676: return r1.effective_start_date;

Line 3673: hr_utility.set_location('chk_future_reserved_fte p_default_asg_fte : '||p_default_asg_fte, 203);

3669: ||r1.effective_start_date, 203);
3670: hr_utility.set_location('chk_future_reserved_fte p_assignment_id : '||p_assignment_id, 203);
3671: hr_utility.set_location('chk_future_reserved_fte p_person_id : '||p_person_id, 203);
3672: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 203);
3673: hr_utility.set_location('chk_future_reserved_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3674: if chk_reserved_fte(p_assignment_id, p_person_id, p_position_id, p_position_type,
3675: r1.effective_start_date, p_default_asg_fte) then
3676: return r1.effective_start_date;
3677: end if;

Line 3682: hr_utility.set_location('chk_future_reserved_fte r1.effective_start_date : '||r1.effective_start_date, 203);

3678: end loop;
3679: else
3680: for r1 in c2(p_position_id, p_validation_start_date, p_validation_end_date)
3681: loop
3682: hr_utility.set_location('chk_future_reserved_fte r1.effective_start_date : '||r1.effective_start_date, 203);
3683: hr_utility.set_location('chk_future_reserved_fte p_assignment_id : '||p_assignment_id, 203);
3684: hr_utility.set_location('chk_future_reserved_fte p_person_id : '||p_person_id, 203);
3685: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 203);
3686: hr_utility.set_location('chk_future_reserved_fte p_default_asg_fte : '||p_default_asg_fte, 203);

Line 3683: hr_utility.set_location('chk_future_reserved_fte p_assignment_id : '||p_assignment_id, 203);

3679: else
3680: for r1 in c2(p_position_id, p_validation_start_date, p_validation_end_date)
3681: loop
3682: hr_utility.set_location('chk_future_reserved_fte r1.effective_start_date : '||r1.effective_start_date, 203);
3683: hr_utility.set_location('chk_future_reserved_fte p_assignment_id : '||p_assignment_id, 203);
3684: hr_utility.set_location('chk_future_reserved_fte p_person_id : '||p_person_id, 203);
3685: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 203);
3686: hr_utility.set_location('chk_future_reserved_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3687: if chk_reserved_fte(p_assignment_id, p_person_id, p_position_id, p_position_type,

Line 3684: hr_utility.set_location('chk_future_reserved_fte p_person_id : '||p_person_id, 203);

3680: for r1 in c2(p_position_id, p_validation_start_date, p_validation_end_date)
3681: loop
3682: hr_utility.set_location('chk_future_reserved_fte r1.effective_start_date : '||r1.effective_start_date, 203);
3683: hr_utility.set_location('chk_future_reserved_fte p_assignment_id : '||p_assignment_id, 203);
3684: hr_utility.set_location('chk_future_reserved_fte p_person_id : '||p_person_id, 203);
3685: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 203);
3686: hr_utility.set_location('chk_future_reserved_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3687: if chk_reserved_fte(p_assignment_id, p_person_id, p_position_id, p_position_type,
3688: r1.effective_start_date, p_default_asg_fte) then

Line 3685: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 203);

3681: loop
3682: hr_utility.set_location('chk_future_reserved_fte r1.effective_start_date : '||r1.effective_start_date, 203);
3683: hr_utility.set_location('chk_future_reserved_fte p_assignment_id : '||p_assignment_id, 203);
3684: hr_utility.set_location('chk_future_reserved_fte p_person_id : '||p_person_id, 203);
3685: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 203);
3686: hr_utility.set_location('chk_future_reserved_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3687: if chk_reserved_fte(p_assignment_id, p_person_id, p_position_id, p_position_type,
3688: r1.effective_start_date, p_default_asg_fte) then
3689: return r1.effective_start_date;

Line 3686: hr_utility.set_location('chk_future_reserved_fte p_default_asg_fte : '||p_default_asg_fte, 203);

3682: hr_utility.set_location('chk_future_reserved_fte r1.effective_start_date : '||r1.effective_start_date, 203);
3683: hr_utility.set_location('chk_future_reserved_fte p_assignment_id : '||p_assignment_id, 203);
3684: hr_utility.set_location('chk_future_reserved_fte p_person_id : '||p_person_id, 203);
3685: hr_utility.set_location('chk_future_reserved_fte p_position_id : '||p_position_id, 203);
3686: hr_utility.set_location('chk_future_reserved_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3687: if chk_reserved_fte(p_assignment_id, p_person_id, p_position_id, p_position_type,
3688: r1.effective_start_date, p_default_asg_fte) then
3689: return r1.effective_start_date;
3690: end if;

Line 3723: hr_utility.set_location('chk_pos_fte_sum_asg_fte p_position_type'||p_position_type , 20);

3719: fetch c_pos_fte into p_position_type, p_position_fte,
3720: p_organization_id, l_overlap_period, l_business_group_id;
3721: close c_pos_fte;
3722: --
3723: hr_utility.set_location('chk_pos_fte_sum_asg_fte p_position_type'||p_position_type , 20);
3724: --
3725: if p_position_type = 'SHARED' then
3726: --
3727: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(

Line 3732: hr_utility.set_location('chk_pos_fte_sum_asg_fte SHARED' , 20);

3728: p_position_id => p_position_id,
3729: p_overlap_period => l_overlap_period,
3730: p_assignment_start_date => p_effective_date);
3731: if not l_overlap_dates_present then
3732: hr_utility.set_location('chk_pos_fte_sum_asg_fte SHARED' , 20);
3733: p_budgeted_fte := budgeted_fte(p_position_id, p_effective_date);
3734: --
3735: p_realloc_fte := pqh_reallocation_pkg.get_reallocation(
3736: p_position_id => p_position_id

Line 3745: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_null' , 20);

3741: ,p_business_group_id => l_business_group_id
3742: );
3743: --
3744: --
3745: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_null' , 20);
3746: if p_assignment_id is null then
3747: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is null' , 20);
3748: p_total_asg_fte := pqh_psf_bus.sum_assignment_fte(p_position_id, p_effective_date) + p_default_asg_fte;
3749: else

Line 3747: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is null' , 20);

3743: --
3744: --
3745: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_null' , 20);
3746: if p_assignment_id is null then
3747: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is null' , 20);
3748: p_total_asg_fte := pqh_psf_bus.sum_assignment_fte(p_position_id, p_effective_date) + p_default_asg_fte;
3749: else
3750: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is not null' , 20);
3751: l_sum := pqh_psf_bus.sum_assignment_fte(p_position_id, p_effective_date);

Line 3750: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is not null' , 20);

3746: if p_assignment_id is null then
3747: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is null' , 20);
3748: p_total_asg_fte := pqh_psf_bus.sum_assignment_fte(p_position_id, p_effective_date) + p_default_asg_fte;
3749: else
3750: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is not null' , 20);
3751: l_sum := pqh_psf_bus.sum_assignment_fte(p_position_id, p_effective_date);
3752: l_asg := pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date);
3753: p_total_asg_fte := l_sum + l_asg;
3754: --

Line 3755: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_sum : '||l_sum, 20);

3751: l_sum := pqh_psf_bus.sum_assignment_fte(p_position_id, p_effective_date);
3752: l_asg := pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date);
3753: p_total_asg_fte := l_sum + l_asg;
3754: --
3755: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_sum : '||l_sum, 20);
3756: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_asg : '||l_asg, 20);
3757: hr_utility.set_location('chk_pos_fte_sum_asg_fte p_total_asg_fte : '||p_total_asg_fte, 20);
3758: end if;
3759: --

Line 3756: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_asg : '||l_asg, 20);

3752: l_asg := pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date);
3753: p_total_asg_fte := l_sum + l_asg;
3754: --
3755: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_sum : '||l_sum, 20);
3756: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_asg : '||l_asg, 20);
3757: hr_utility.set_location('chk_pos_fte_sum_asg_fte p_total_asg_fte : '||p_total_asg_fte, 20);
3758: end if;
3759: --
3760: hr_utility.set_location('chk_pos_fte_sum_asg_fte end SHARED' , 20);

Line 3757: hr_utility.set_location('chk_pos_fte_sum_asg_fte p_total_asg_fte : '||p_total_asg_fte, 20);

3753: p_total_asg_fte := l_sum + l_asg;
3754: --
3755: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_sum : '||l_sum, 20);
3756: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_asg : '||l_asg, 20);
3757: hr_utility.set_location('chk_pos_fte_sum_asg_fte p_total_asg_fte : '||p_total_asg_fte, 20);
3758: end if;
3759: --
3760: hr_utility.set_location('chk_pos_fte_sum_asg_fte end SHARED' , 20);
3761: end if;

Line 3760: hr_utility.set_location('chk_pos_fte_sum_asg_fte end SHARED' , 20);

3756: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_asg : '||l_asg, 20);
3757: hr_utility.set_location('chk_pos_fte_sum_asg_fte p_total_asg_fte : '||p_total_asg_fte, 20);
3758: end if;
3759: --
3760: hr_utility.set_location('chk_pos_fte_sum_asg_fte end SHARED' , 20);
3761: end if;
3762: elsif p_position_type = 'SINGLE' then
3763: --
3764: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(

Line 3769: hr_utility.set_location('chk_pos_fte_sum_asg_fte SINGLE' , 20);

3765: p_position_id => p_position_id,
3766: p_overlap_period => l_overlap_period,
3767: p_assignment_start_date => p_effective_date);
3768: if not l_overlap_dates_present then
3769: hr_utility.set_location('chk_pos_fte_sum_asg_fte SINGLE' , 20);
3770: --
3771: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_null' , 20);
3772: if p_assignment_id is null then
3773: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is null' , 20);

Line 3771: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_null' , 20);

3767: p_assignment_start_date => p_effective_date);
3768: if not l_overlap_dates_present then
3769: hr_utility.set_location('chk_pos_fte_sum_asg_fte SINGLE' , 20);
3770: --
3771: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_null' , 20);
3772: if p_assignment_id is null then
3773: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is null' , 20);
3774: p_total_asg_fte := pqh_psf_bus.no_assignments(p_position_id, p_effective_date) + 1;
3775: else

Line 3773: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is null' , 20);

3769: hr_utility.set_location('chk_pos_fte_sum_asg_fte SINGLE' , 20);
3770: --
3771: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_null' , 20);
3772: if p_assignment_id is null then
3773: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is null' , 20);
3774: p_total_asg_fte := pqh_psf_bus.no_assignments(p_position_id, p_effective_date) + 1;
3775: else
3776: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is not null' , 20);
3777: l_sum := pqh_psf_bus.no_assignments(p_position_id, p_effective_date);

Line 3776: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is not null' , 20);

3772: if p_assignment_id is null then
3773: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is null' , 20);
3774: p_total_asg_fte := pqh_psf_bus.no_assignments(p_position_id, p_effective_date) + 1;
3775: else
3776: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is not null' , 20);
3777: l_sum := pqh_psf_bus.no_assignments(p_position_id, p_effective_date);
3778: l_asg := 1;
3779: p_total_asg_fte := l_sum + l_asg;
3780: --

Line 3781: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_sum : '||l_sum, 20);

3777: l_sum := pqh_psf_bus.no_assignments(p_position_id, p_effective_date);
3778: l_asg := 1;
3779: p_total_asg_fte := l_sum + l_asg;
3780: --
3781: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_sum : '||l_sum, 20);
3782: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_asg : '||l_asg, 20);
3783: hr_utility.set_location('chk_pos_fte_sum_asg_fte p_total_asg_fte : '||p_total_asg_fte, 20);
3784: end if;
3785: --

Line 3782: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_asg : '||l_asg, 20);

3778: l_asg := 1;
3779: p_total_asg_fte := l_sum + l_asg;
3780: --
3781: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_sum : '||l_sum, 20);
3782: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_asg : '||l_asg, 20);
3783: hr_utility.set_location('chk_pos_fte_sum_asg_fte p_total_asg_fte : '||p_total_asg_fte, 20);
3784: end if;
3785: --
3786: hr_utility.set_location('chk_pos_fte_sum_asg_fte end SINGLE' , 20);

Line 3783: hr_utility.set_location('chk_pos_fte_sum_asg_fte p_total_asg_fte : '||p_total_asg_fte, 20);

3779: p_total_asg_fte := l_sum + l_asg;
3780: --
3781: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_sum : '||l_sum, 20);
3782: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_asg : '||l_asg, 20);
3783: hr_utility.set_location('chk_pos_fte_sum_asg_fte p_total_asg_fte : '||p_total_asg_fte, 20);
3784: end if;
3785: --
3786: hr_utility.set_location('chk_pos_fte_sum_asg_fte end SINGLE' , 20);
3787: end if;

Line 3786: hr_utility.set_location('chk_pos_fte_sum_asg_fte end SINGLE' , 20);

3782: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_asg : '||l_asg, 20);
3783: hr_utility.set_location('chk_pos_fte_sum_asg_fte p_total_asg_fte : '||p_total_asg_fte, 20);
3784: end if;
3785: --
3786: hr_utility.set_location('chk_pos_fte_sum_asg_fte end SINGLE' , 20);
3787: end if;
3788: end if;
3789: hr_utility.set_location('chk_pos_fte_sum_asg_fte end ' , 20);
3790: exception when others then

Line 3789: hr_utility.set_location('chk_pos_fte_sum_asg_fte end ' , 20);

3785: --
3786: hr_utility.set_location('chk_pos_fte_sum_asg_fte end SINGLE' , 20);
3787: end if;
3788: end if;
3789: hr_utility.set_location('chk_pos_fte_sum_asg_fte end ' , 20);
3790: exception when others then
3791: p_position_type := null;
3792: p_organization_id := null;
3793: p_budgeted_fte := null;

Line 3871: hr_utility.set_location('chk_future_pos_asg_fte p_position_id : '||p_position_id, 201);

3867: where position_id = p_position_id
3868: and effective_start_date between p_validation_start_date and p_validation_end_date;
3869: --
3870: begin
3871: hr_utility.set_location('chk_future_pos_asg_fte p_position_id : '||p_position_id, 201);
3872: hr_utility.set_location('chk_future_pos_asg_fte p_validation_start_date: '||p_validation_start_date, 202);
3873: hr_utility.set_location('chk_future_pos_asg_fte p_validation_end_date: '||p_validation_end_date, 202);
3874: if (p_assignment_id is not null and p_position_id is not null) then
3875: for r1 in c1(p_assignment_id, p_position_id, p_validation_start_date, p_validation_end_date)

Line 3872: hr_utility.set_location('chk_future_pos_asg_fte p_validation_start_date: '||p_validation_start_date, 202);

3868: and effective_start_date between p_validation_start_date and p_validation_end_date;
3869: --
3870: begin
3871: hr_utility.set_location('chk_future_pos_asg_fte p_position_id : '||p_position_id, 201);
3872: hr_utility.set_location('chk_future_pos_asg_fte p_validation_start_date: '||p_validation_start_date, 202);
3873: hr_utility.set_location('chk_future_pos_asg_fte p_validation_end_date: '||p_validation_end_date, 202);
3874: if (p_assignment_id is not null and p_position_id is not null) then
3875: for r1 in c1(p_assignment_id, p_position_id, p_validation_start_date, p_validation_end_date)
3876: loop

Line 3873: hr_utility.set_location('chk_future_pos_asg_fte p_validation_end_date: '||p_validation_end_date, 202);

3869: --
3870: begin
3871: hr_utility.set_location('chk_future_pos_asg_fte p_position_id : '||p_position_id, 201);
3872: hr_utility.set_location('chk_future_pos_asg_fte p_validation_start_date: '||p_validation_start_date, 202);
3873: hr_utility.set_location('chk_future_pos_asg_fte p_validation_end_date: '||p_validation_end_date, 202);
3874: if (p_assignment_id is not null and p_position_id is not null) then
3875: for r1 in c1(p_assignment_id, p_position_id, p_validation_start_date, p_validation_end_date)
3876: loop
3877: hr_utility.set_location('chk_future_pos_asg_fte r1.effective_start_date : '||r1.effective_start_date, 203);

Line 3877: hr_utility.set_location('chk_future_pos_asg_fte r1.effective_start_date : '||r1.effective_start_date, 203);

3873: hr_utility.set_location('chk_future_pos_asg_fte p_validation_end_date: '||p_validation_end_date, 202);
3874: if (p_assignment_id is not null and p_position_id is not null) then
3875: for r1 in c1(p_assignment_id, p_position_id, p_validation_start_date, p_validation_end_date)
3876: loop
3877: hr_utility.set_location('chk_future_pos_asg_fte r1.effective_start_date : '||r1.effective_start_date, 203);
3878: hr_utility.set_location('chk_future_pos_asg_fte p_assignment_id : '||p_assignment_id, 203);
3879: hr_utility.set_location('chk_future_pos_asg_fte p_position_id : '||p_position_id, 203);
3880: hr_utility.set_location('chk_future_pos_asg_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3881: --

Line 3878: hr_utility.set_location('chk_future_pos_asg_fte p_assignment_id : '||p_assignment_id, 203);

3874: if (p_assignment_id is not null and p_position_id is not null) then
3875: for r1 in c1(p_assignment_id, p_position_id, p_validation_start_date, p_validation_end_date)
3876: loop
3877: hr_utility.set_location('chk_future_pos_asg_fte r1.effective_start_date : '||r1.effective_start_date, 203);
3878: hr_utility.set_location('chk_future_pos_asg_fte p_assignment_id : '||p_assignment_id, 203);
3879: hr_utility.set_location('chk_future_pos_asg_fte p_position_id : '||p_position_id, 203);
3880: hr_utility.set_location('chk_future_pos_asg_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3881: --
3882: chk_pos_fte_sum_asg_fte(

Line 3879: hr_utility.set_location('chk_future_pos_asg_fte p_position_id : '||p_position_id, 203);

3875: for r1 in c1(p_assignment_id, p_position_id, p_validation_start_date, p_validation_end_date)
3876: loop
3877: hr_utility.set_location('chk_future_pos_asg_fte r1.effective_start_date : '||r1.effective_start_date, 203);
3878: hr_utility.set_location('chk_future_pos_asg_fte p_assignment_id : '||p_assignment_id, 203);
3879: hr_utility.set_location('chk_future_pos_asg_fte p_position_id : '||p_position_id, 203);
3880: hr_utility.set_location('chk_future_pos_asg_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3881: --
3882: chk_pos_fte_sum_asg_fte(
3883: p_assignment_id => p_assignment_id,

Line 3880: hr_utility.set_location('chk_future_pos_asg_fte p_default_asg_fte : '||p_default_asg_fte, 203);

3876: loop
3877: hr_utility.set_location('chk_future_pos_asg_fte r1.effective_start_date : '||r1.effective_start_date, 203);
3878: hr_utility.set_location('chk_future_pos_asg_fte p_assignment_id : '||p_assignment_id, 203);
3879: hr_utility.set_location('chk_future_pos_asg_fte p_position_id : '||p_position_id, 203);
3880: hr_utility.set_location('chk_future_pos_asg_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3881: --
3882: chk_pos_fte_sum_asg_fte(
3883: p_assignment_id => p_assignment_id,
3884: p_position_id => p_position_id,

Line 3894: hr_utility.set_location('chk_future_pos_asg_fte l_position_type : '||l_position_type, 204);

3890: p_realloc_fte => l_realloc_fte,
3891: p_position_fte => l_position_fte,
3892: p_total_asg_fte => l_total_asg_fte);
3893: --
3894: hr_utility.set_location('chk_future_pos_asg_fte l_position_type : '||l_position_type, 204);
3895: hr_utility.set_location('chk_future_pos_asg_fte l_organization_id : '|| l_organization_id, 204);
3896: hr_utility.set_location('chk_future_pos_asg_fte l_budgeted_fte : '|| l_budgeted_fte, 204);
3897: hr_utility.set_location('chk_future_pos_asg_fte l_realloc_fte : '|| l_realloc_fte, 204);
3898: hr_utility.set_location('chk_future_pos_asg_fte l_position_fte : '|| l_position_fte, 204);

Line 3895: hr_utility.set_location('chk_future_pos_asg_fte l_organization_id : '|| l_organization_id, 204);

3891: p_position_fte => l_position_fte,
3892: p_total_asg_fte => l_total_asg_fte);
3893: --
3894: hr_utility.set_location('chk_future_pos_asg_fte l_position_type : '||l_position_type, 204);
3895: hr_utility.set_location('chk_future_pos_asg_fte l_organization_id : '|| l_organization_id, 204);
3896: hr_utility.set_location('chk_future_pos_asg_fte l_budgeted_fte : '|| l_budgeted_fte, 204);
3897: hr_utility.set_location('chk_future_pos_asg_fte l_realloc_fte : '|| l_realloc_fte, 204);
3898: hr_utility.set_location('chk_future_pos_asg_fte l_position_fte : '|| l_position_fte, 204);
3899: hr_utility.set_location('chk_future_pos_asg_fte l_total_asg_fte : '|| l_total_asg_fte, 204);

Line 3896: hr_utility.set_location('chk_future_pos_asg_fte l_budgeted_fte : '|| l_budgeted_fte, 204);

3892: p_total_asg_fte => l_total_asg_fte);
3893: --
3894: hr_utility.set_location('chk_future_pos_asg_fte l_position_type : '||l_position_type, 204);
3895: hr_utility.set_location('chk_future_pos_asg_fte l_organization_id : '|| l_organization_id, 204);
3896: hr_utility.set_location('chk_future_pos_asg_fte l_budgeted_fte : '|| l_budgeted_fte, 204);
3897: hr_utility.set_location('chk_future_pos_asg_fte l_realloc_fte : '|| l_realloc_fte, 204);
3898: hr_utility.set_location('chk_future_pos_asg_fte l_position_fte : '|| l_position_fte, 204);
3899: hr_utility.set_location('chk_future_pos_asg_fte l_total_asg_fte : '|| l_total_asg_fte, 204);
3900: --

Line 3897: hr_utility.set_location('chk_future_pos_asg_fte l_realloc_fte : '|| l_realloc_fte, 204);

3893: --
3894: hr_utility.set_location('chk_future_pos_asg_fte l_position_type : '||l_position_type, 204);
3895: hr_utility.set_location('chk_future_pos_asg_fte l_organization_id : '|| l_organization_id, 204);
3896: hr_utility.set_location('chk_future_pos_asg_fte l_budgeted_fte : '|| l_budgeted_fte, 204);
3897: hr_utility.set_location('chk_future_pos_asg_fte l_realloc_fte : '|| l_realloc_fte, 204);
3898: hr_utility.set_location('chk_future_pos_asg_fte l_position_fte : '|| l_position_fte, 204);
3899: hr_utility.set_location('chk_future_pos_asg_fte l_total_asg_fte : '|| l_total_asg_fte, 204);
3900: --
3901: if l_position_type = 'SHARED' then

Line 3898: hr_utility.set_location('chk_future_pos_asg_fte l_position_fte : '|| l_position_fte, 204);

3894: hr_utility.set_location('chk_future_pos_asg_fte l_position_type : '||l_position_type, 204);
3895: hr_utility.set_location('chk_future_pos_asg_fte l_organization_id : '|| l_organization_id, 204);
3896: hr_utility.set_location('chk_future_pos_asg_fte l_budgeted_fte : '|| l_budgeted_fte, 204);
3897: hr_utility.set_location('chk_future_pos_asg_fte l_realloc_fte : '|| l_realloc_fte, 204);
3898: hr_utility.set_location('chk_future_pos_asg_fte l_position_fte : '|| l_position_fte, 204);
3899: hr_utility.set_location('chk_future_pos_asg_fte l_total_asg_fte : '|| l_total_asg_fte, 204);
3900: --
3901: if l_position_type = 'SHARED' then
3902: --

Line 3899: hr_utility.set_location('chk_future_pos_asg_fte l_total_asg_fte : '|| l_total_asg_fte, 204);

3895: hr_utility.set_location('chk_future_pos_asg_fte l_organization_id : '|| l_organization_id, 204);
3896: hr_utility.set_location('chk_future_pos_asg_fte l_budgeted_fte : '|| l_budgeted_fte, 204);
3897: hr_utility.set_location('chk_future_pos_asg_fte l_realloc_fte : '|| l_realloc_fte, 204);
3898: hr_utility.set_location('chk_future_pos_asg_fte l_position_fte : '|| l_position_fte, 204);
3899: hr_utility.set_location('chk_future_pos_asg_fte l_total_asg_fte : '|| l_total_asg_fte, 204);
3900: --
3901: if l_position_type = 'SHARED' then
3902: --
3903: if l_budgeted_fte is not null or l_realloc_fte is not null then

Line 3908: hr_utility.set_message(8302,'PQH_SHARED_FUT_BFTE_LT_AFTE');

3904: --
3905: l_bgt_and_realloc_fte := nvl(l_budgeted_fte,0) + nvl(l_realloc_fte,0);
3906: --
3907: if l_bgt_and_realloc_fte < l_total_asg_fte then
3908: hr_utility.set_message(8302,'PQH_SHARED_FUT_BFTE_LT_AFTE');
3909: hr_utility.set_message_token('FUTURE_ASG_DATE', r1.effective_start_date);
3910: pqh_utility.set_message_level_cd('W');
3911: pqh_utility.raise_error;
3912: return;

Line 3909: hr_utility.set_message_token('FUTURE_ASG_DATE', r1.effective_start_date);

3905: l_bgt_and_realloc_fte := nvl(l_budgeted_fte,0) + nvl(l_realloc_fte,0);
3906: --
3907: if l_bgt_and_realloc_fte < l_total_asg_fte then
3908: hr_utility.set_message(8302,'PQH_SHARED_FUT_BFTE_LT_AFTE');
3909: hr_utility.set_message_token('FUTURE_ASG_DATE', r1.effective_start_date);
3910: pqh_utility.set_message_level_cd('W');
3911: pqh_utility.raise_error;
3912: return;
3913: end if;

Line 3916: hr_utility.set_message(8302,'PQH_SHARED_FUT_PFTE_LT_AFTE');

3912: return;
3913: end if;
3914: else
3915: if l_position_fte < l_total_asg_fte then
3916: hr_utility.set_message(8302,'PQH_SHARED_FUT_PFTE_LT_AFTE');
3917: hr_utility.set_message_token('FUTURE_ASG_DATE',r1.effective_start_date );
3918: pqh_utility.set_message_level_cd('W');
3919: pqh_utility.raise_error;
3920: return;

Line 3917: hr_utility.set_message_token('FUTURE_ASG_DATE',r1.effective_start_date );

3913: end if;
3914: else
3915: if l_position_fte < l_total_asg_fte then
3916: hr_utility.set_message(8302,'PQH_SHARED_FUT_PFTE_LT_AFTE');
3917: hr_utility.set_message_token('FUTURE_ASG_DATE',r1.effective_start_date );
3918: pqh_utility.set_message_level_cd('W');
3919: pqh_utility.raise_error;
3920: return;
3921: end if;

Line 3927: hr_utility.set_message(8302,'PQH_SINGLE_POS_FUTURE_ASG');

3923: --
3924: elsif l_position_type = 'SINGLE' then
3925: --
3926: if l_total_asg_fte > 1 then
3927: hr_utility.set_message(8302,'PQH_SINGLE_POS_FUTURE_ASG');
3928: hr_utility.set_message_token('FUTURE_ASG_DATE', r1.effective_start_date);
3929: pqh_utility.set_message_level_cd('W');
3930: pqh_utility.raise_error;
3931: return;

Line 3928: hr_utility.set_message_token('FUTURE_ASG_DATE', r1.effective_start_date);

3924: elsif l_position_type = 'SINGLE' then
3925: --
3926: if l_total_asg_fte > 1 then
3927: hr_utility.set_message(8302,'PQH_SINGLE_POS_FUTURE_ASG');
3928: hr_utility.set_message_token('FUTURE_ASG_DATE', r1.effective_start_date);
3929: pqh_utility.set_message_level_cd('W');
3930: pqh_utility.raise_error;
3931: return;
3932: end if;

Line 3939: hr_utility.set_location('chk_future_pos_asg_fte r1.effective_start_date : '||r1.effective_start_date, 203);

3935: end loop;
3936: elsif (p_assignment_id is null and p_position_id is not null) then
3937: for r1 in c2(p_position_id, p_validation_start_date, p_validation_end_date)
3938: loop
3939: hr_utility.set_location('chk_future_pos_asg_fte r1.effective_start_date : '||r1.effective_start_date, 203);
3940: hr_utility.set_location('chk_future_pos_asg_fte p_assignment_id : '||p_assignment_id, 203);
3941: hr_utility.set_location('chk_future_pos_asg_fte p_position_id : '||p_position_id, 203);
3942: hr_utility.set_location('chk_future_pos_asg_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3943: --

Line 3940: hr_utility.set_location('chk_future_pos_asg_fte p_assignment_id : '||p_assignment_id, 203);

3936: elsif (p_assignment_id is null and p_position_id is not null) then
3937: for r1 in c2(p_position_id, p_validation_start_date, p_validation_end_date)
3938: loop
3939: hr_utility.set_location('chk_future_pos_asg_fte r1.effective_start_date : '||r1.effective_start_date, 203);
3940: hr_utility.set_location('chk_future_pos_asg_fte p_assignment_id : '||p_assignment_id, 203);
3941: hr_utility.set_location('chk_future_pos_asg_fte p_position_id : '||p_position_id, 203);
3942: hr_utility.set_location('chk_future_pos_asg_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3943: --
3944: chk_pos_fte_sum_asg_fte(

Line 3941: hr_utility.set_location('chk_future_pos_asg_fte p_position_id : '||p_position_id, 203);

3937: for r1 in c2(p_position_id, p_validation_start_date, p_validation_end_date)
3938: loop
3939: hr_utility.set_location('chk_future_pos_asg_fte r1.effective_start_date : '||r1.effective_start_date, 203);
3940: hr_utility.set_location('chk_future_pos_asg_fte p_assignment_id : '||p_assignment_id, 203);
3941: hr_utility.set_location('chk_future_pos_asg_fte p_position_id : '||p_position_id, 203);
3942: hr_utility.set_location('chk_future_pos_asg_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3943: --
3944: chk_pos_fte_sum_asg_fte(
3945: p_assignment_id => p_assignment_id,

Line 3942: hr_utility.set_location('chk_future_pos_asg_fte p_default_asg_fte : '||p_default_asg_fte, 203);

3938: loop
3939: hr_utility.set_location('chk_future_pos_asg_fte r1.effective_start_date : '||r1.effective_start_date, 203);
3940: hr_utility.set_location('chk_future_pos_asg_fte p_assignment_id : '||p_assignment_id, 203);
3941: hr_utility.set_location('chk_future_pos_asg_fte p_position_id : '||p_position_id, 203);
3942: hr_utility.set_location('chk_future_pos_asg_fte p_default_asg_fte : '||p_default_asg_fte, 203);
3943: --
3944: chk_pos_fte_sum_asg_fte(
3945: p_assignment_id => p_assignment_id,
3946: p_position_id => p_position_id,

Line 3956: hr_utility.set_location('chk_future_pos_asg_fte l_position_type : '||l_position_type, 204);

3952: p_realloc_fte => l_realloc_fte,
3953: p_position_fte => l_position_fte,
3954: p_total_asg_fte => l_total_asg_fte);
3955: --
3956: hr_utility.set_location('chk_future_pos_asg_fte l_position_type : '||l_position_type, 204);
3957: hr_utility.set_location('chk_future_pos_asg_fte l_organization_id : '|| l_organization_id, 204);
3958: hr_utility.set_location('chk_future_pos_asg_fte l_budgeted_fte : '|| l_budgeted_fte, 204);
3959: hr_utility.set_location('chk_future_pos_asg_fte l_realloc_fte : '|| l_realloc_fte, 204);
3960: hr_utility.set_location('chk_future_pos_asg_fte l_position_fte : '|| l_position_fte, 204);

Line 3957: hr_utility.set_location('chk_future_pos_asg_fte l_organization_id : '|| l_organization_id, 204);

3953: p_position_fte => l_position_fte,
3954: p_total_asg_fte => l_total_asg_fte);
3955: --
3956: hr_utility.set_location('chk_future_pos_asg_fte l_position_type : '||l_position_type, 204);
3957: hr_utility.set_location('chk_future_pos_asg_fte l_organization_id : '|| l_organization_id, 204);
3958: hr_utility.set_location('chk_future_pos_asg_fte l_budgeted_fte : '|| l_budgeted_fte, 204);
3959: hr_utility.set_location('chk_future_pos_asg_fte l_realloc_fte : '|| l_realloc_fte, 204);
3960: hr_utility.set_location('chk_future_pos_asg_fte l_position_fte : '|| l_position_fte, 204);
3961: hr_utility.set_location('chk_future_pos_asg_fte l_total_asg_fte : '|| l_total_asg_fte, 204);

Line 3958: hr_utility.set_location('chk_future_pos_asg_fte l_budgeted_fte : '|| l_budgeted_fte, 204);

3954: p_total_asg_fte => l_total_asg_fte);
3955: --
3956: hr_utility.set_location('chk_future_pos_asg_fte l_position_type : '||l_position_type, 204);
3957: hr_utility.set_location('chk_future_pos_asg_fte l_organization_id : '|| l_organization_id, 204);
3958: hr_utility.set_location('chk_future_pos_asg_fte l_budgeted_fte : '|| l_budgeted_fte, 204);
3959: hr_utility.set_location('chk_future_pos_asg_fte l_realloc_fte : '|| l_realloc_fte, 204);
3960: hr_utility.set_location('chk_future_pos_asg_fte l_position_fte : '|| l_position_fte, 204);
3961: hr_utility.set_location('chk_future_pos_asg_fte l_total_asg_fte : '|| l_total_asg_fte, 204);
3962: --

Line 3959: hr_utility.set_location('chk_future_pos_asg_fte l_realloc_fte : '|| l_realloc_fte, 204);

3955: --
3956: hr_utility.set_location('chk_future_pos_asg_fte l_position_type : '||l_position_type, 204);
3957: hr_utility.set_location('chk_future_pos_asg_fte l_organization_id : '|| l_organization_id, 204);
3958: hr_utility.set_location('chk_future_pos_asg_fte l_budgeted_fte : '|| l_budgeted_fte, 204);
3959: hr_utility.set_location('chk_future_pos_asg_fte l_realloc_fte : '|| l_realloc_fte, 204);
3960: hr_utility.set_location('chk_future_pos_asg_fte l_position_fte : '|| l_position_fte, 204);
3961: hr_utility.set_location('chk_future_pos_asg_fte l_total_asg_fte : '|| l_total_asg_fte, 204);
3962: --
3963: if l_position_type = 'SHARED' then

Line 3960: hr_utility.set_location('chk_future_pos_asg_fte l_position_fte : '|| l_position_fte, 204);

3956: hr_utility.set_location('chk_future_pos_asg_fte l_position_type : '||l_position_type, 204);
3957: hr_utility.set_location('chk_future_pos_asg_fte l_organization_id : '|| l_organization_id, 204);
3958: hr_utility.set_location('chk_future_pos_asg_fte l_budgeted_fte : '|| l_budgeted_fte, 204);
3959: hr_utility.set_location('chk_future_pos_asg_fte l_realloc_fte : '|| l_realloc_fte, 204);
3960: hr_utility.set_location('chk_future_pos_asg_fte l_position_fte : '|| l_position_fte, 204);
3961: hr_utility.set_location('chk_future_pos_asg_fte l_total_asg_fte : '|| l_total_asg_fte, 204);
3962: --
3963: if l_position_type = 'SHARED' then
3964: --

Line 3961: hr_utility.set_location('chk_future_pos_asg_fte l_total_asg_fte : '|| l_total_asg_fte, 204);

3957: hr_utility.set_location('chk_future_pos_asg_fte l_organization_id : '|| l_organization_id, 204);
3958: hr_utility.set_location('chk_future_pos_asg_fte l_budgeted_fte : '|| l_budgeted_fte, 204);
3959: hr_utility.set_location('chk_future_pos_asg_fte l_realloc_fte : '|| l_realloc_fte, 204);
3960: hr_utility.set_location('chk_future_pos_asg_fte l_position_fte : '|| l_position_fte, 204);
3961: hr_utility.set_location('chk_future_pos_asg_fte l_total_asg_fte : '|| l_total_asg_fte, 204);
3962: --
3963: if l_position_type = 'SHARED' then
3964: --
3965: if l_budgeted_fte is not null or l_realloc_fte is not null then

Line 3970: hr_utility.set_message(8302,'PQH_SHARED_FUT_BFTE_LT_AFTE');

3966: --
3967: l_bgt_and_realloc_fte := nvl(l_budgeted_fte,0) + nvl(l_realloc_fte,0);
3968: --
3969: if l_bgt_and_realloc_fte < l_total_asg_fte then
3970: hr_utility.set_message(8302,'PQH_SHARED_FUT_BFTE_LT_AFTE');
3971: hr_utility.set_message_token('FUTURE_ASG_DATE', r1.effective_start_date);
3972: pqh_utility.set_message_level_cd('W');
3973: pqh_utility.raise_error;
3974: return;

Line 3971: hr_utility.set_message_token('FUTURE_ASG_DATE', r1.effective_start_date);

3967: l_bgt_and_realloc_fte := nvl(l_budgeted_fte,0) + nvl(l_realloc_fte,0);
3968: --
3969: if l_bgt_and_realloc_fte < l_total_asg_fte then
3970: hr_utility.set_message(8302,'PQH_SHARED_FUT_BFTE_LT_AFTE');
3971: hr_utility.set_message_token('FUTURE_ASG_DATE', r1.effective_start_date);
3972: pqh_utility.set_message_level_cd('W');
3973: pqh_utility.raise_error;
3974: return;
3975: end if;

Line 3978: hr_utility.set_message(8302,'PQH_SHARED_FUT_PFTE_LT_AFTE');

3974: return;
3975: end if;
3976: else
3977: if l_position_fte < l_total_asg_fte then
3978: hr_utility.set_message(8302,'PQH_SHARED_FUT_PFTE_LT_AFTE');
3979: hr_utility.set_message_token('FUTURE_ASG_DATE',r1.effective_start_date );
3980: pqh_utility.set_message_level_cd('W');
3981: pqh_utility.raise_error;
3982: return;

Line 3979: hr_utility.set_message_token('FUTURE_ASG_DATE',r1.effective_start_date );

3975: end if;
3976: else
3977: if l_position_fte < l_total_asg_fte then
3978: hr_utility.set_message(8302,'PQH_SHARED_FUT_PFTE_LT_AFTE');
3979: hr_utility.set_message_token('FUTURE_ASG_DATE',r1.effective_start_date );
3980: pqh_utility.set_message_level_cd('W');
3981: pqh_utility.raise_error;
3982: return;
3983: end if;

Line 3989: hr_utility.set_message(8302,'PQH_SINGLE_POS_FUTURE_ASG');

3985: --
3986: elsif l_position_type = 'SINGLE' then
3987: --
3988: if l_total_asg_fte > 1 then
3989: hr_utility.set_message(8302,'PQH_SINGLE_POS_FUTURE_ASG');
3990: hr_utility.set_message_token('FUTURE_ASG_DATE', r1.effective_start_date);
3991: pqh_utility.set_message_level_cd('W');
3992: pqh_utility.raise_error;
3993: return;

Line 3990: hr_utility.set_message_token('FUTURE_ASG_DATE', r1.effective_start_date);

3986: elsif l_position_type = 'SINGLE' then
3987: --
3988: if l_total_asg_fte > 1 then
3989: hr_utility.set_message(8302,'PQH_SINGLE_POS_FUTURE_ASG');
3990: hr_utility.set_message_token('FUTURE_ASG_DATE', r1.effective_start_date);
3991: pqh_utility.set_message_level_cd('W');
3992: pqh_utility.raise_error;
3993: return;
3994: end if;

Line 4091: hr_utility.set_location('l_pos_fte : '||l_pos_fte, 131);

4087: --
4088: if l_budgeted_fte is not null or l_realloc_fte is not null then
4089: l_fte := nvl(l_budgeted_fte,0) + nvl(l_realloc_fte,0);
4090: else
4091: hr_utility.set_location('l_pos_fte : '||l_pos_fte, 131);
4092: l_fte := nvl(l_pos_fte,0);
4093: end if;
4094: end if;
4095: hr_utility.set_location('l_fte : '||l_fte, 131);

Line 4095: hr_utility.set_location('l_fte : '||l_fte, 131);

4091: hr_utility.set_location('l_pos_fte : '||l_pos_fte, 131);
4092: l_fte := nvl(l_pos_fte,0);
4093: end if;
4094: end if;
4095: hr_utility.set_location('l_fte : '||l_fte, 131);
4096: return l_fte;
4097: end;
4098: --
4099: --

Line 4165: hr_utility.set_location('POSITION RESERVED2', 114);

4161: + l_reserved_overused + p_default_asg_fte;
4162: --
4163: --
4164: if (l_blank_res_pos_fte < 0) then
4165: hr_utility.set_location('POSITION RESERVED2', 114);
4166: pqh_utility.set_message(8302,'PQH_POS_RESERVED',p_organization_id);
4167: pqh_utility.raise_error;
4168: elsif ((l_total_asg_fte <= (l_blank_res_pos_fte + l_unreserved_fte))
4169: or (nvl(l_blank_res_pos_fte,0) >=

Line 4171: hr_utility.set_location('PQH_ANONYM_POS_RESERVED', 115);

4167: pqh_utility.raise_error;
4168: elsif ((l_total_asg_fte <= (l_blank_res_pos_fte + l_unreserved_fte))
4169: or (nvl(l_blank_res_pos_fte,0) >=
4170: nvl(l_asg_fte,0) + nvl(p_default_asg_fte,0))) then
4171: hr_utility.set_location('PQH_ANONYM_POS_RESERVED', 115);
4172: pqh_utility.set_message(8302,'PQH_ANONYM_POS_RESERVED',p_organization_id);
4173: pqh_utility.raise_error;
4174: else
4175: hr_utility.set_location('PQH_POS_RESERVED', 116);

Line 4175: hr_utility.set_location('PQH_POS_RESERVED', 116);

4171: hr_utility.set_location('PQH_ANONYM_POS_RESERVED', 115);
4172: pqh_utility.set_message(8302,'PQH_ANONYM_POS_RESERVED',p_organization_id);
4173: pqh_utility.raise_error;
4174: else
4175: hr_utility.set_location('PQH_POS_RESERVED', 116);
4176: pqh_utility.set_message(8302,'PQH_POS_RESERVED',p_organization_id);
4177: pqh_utility.raise_error;
4178: end if;
4179: --

Line 4407: hr_utility.set_location('budget id'||p_budget_id,1);

4403: function is_budget_commt_element(p_budget_id number,
4404: p_element_type_id number) return boolean is
4405: l_check varchar2(10);
4406: begin
4407: hr_utility.set_location('budget id'||p_budget_id,1);
4408: hr_utility.set_location('element type id'||p_element_type_id,2);
4409: select 'X'
4410: into l_check
4411: from pqh_bdgt_cmmtmnt_elmnts

Line 4408: hr_utility.set_location('element type id'||p_element_type_id,2);

4404: p_element_type_id number) return boolean is
4405: l_check varchar2(10);
4406: begin
4407: hr_utility.set_location('budget id'||p_budget_id,1);
4408: hr_utility.set_location('element type id'||p_element_type_id,2);
4409: select 'X'
4410: into l_check
4411: from pqh_bdgt_cmmtmnt_elmnts
4412: where budget_id = p_budget_id

Line 4424: hr_utility.set_location('no data',3);

4420: end if;
4421:
4422: exception
4423: when no_data_found then
4424: hr_utility.set_location('no data',3);
4425: return false;
4426: when too_many_rows then
4427: return true;
4428: when others then

Line 4469: hr_utility.set_location(l_proc||'Entering',1);

4465: l_message_level varchar2(10);
4466: l_proc varchar2(72) := 'pqh_psf_bus.chk_position_budget';
4467: begin
4468: --
4469: hr_utility.set_location(l_proc||'Entering',1);
4470: get_assignment_info(p_assignment_id, p_effective_date, l_asg_position_id, l_asg_organization_id);
4471: --
4472: hr_utility.set_location(l_proc,2);
4473: --

Line 4472: hr_utility.set_location(l_proc,2);

4468: --
4469: hr_utility.set_location(l_proc||'Entering',1);
4470: get_assignment_info(p_assignment_id, p_effective_date, l_asg_position_id, l_asg_organization_id);
4471: --
4472: hr_utility.set_location(l_proc,2);
4473: --
4474: if (l_asg_position_id is null) then
4475: hr_utility.set_location(l_proc,3);
4476: return;

Line 4475: hr_utility.set_location(l_proc,3);

4471: --
4472: hr_utility.set_location(l_proc,2);
4473: --
4474: if (l_asg_position_id is null) then
4475: hr_utility.set_location(l_proc,3);
4476: return;
4477: end if;
4478: --
4479: --

Line 4481: hr_utility.set_location(l_proc,4);

4477: end if;
4478: --
4479: --
4480: if (p_called_from = 'ASG' and p_old_position_id = l_asg_position_id ) then
4481: hr_utility.set_location(l_proc,4);
4482: return;
4483: end if;
4484: --
4485: --

Line 4488: hr_utility.set_location(l_proc,5);

4484: --
4485: --
4486: l_message_level := get_cbr_rule_level(8302,'PQH_SUM_ASG_AMT_GT_BGT_AMT',l_asg_organization_id);
4487: if (l_message_level not in ('E','W')) then
4488: hr_utility.set_location(l_proc,5);
4489: return;
4490: end if;
4491: --
4492:

Line 4493: hr_utility.set_location(l_proc||l_asg_position_id,51);

4489: return;
4490: end if;
4491: --
4492:
4493: hr_utility.set_location(l_proc||l_asg_position_id,51);
4494: --
4495: get_position_pc_budget_info(
4496: p_position_id => l_asg_position_id,
4497: p_budget_unit_cd => 'MONEY',

Line 4508: hr_utility.set_location(l_proc,6);

4504: p_budget_end_date => l_budget_end_date,
4505: p_currency_code => l_currency_code);
4506: if ( l_budget_version_id is null ) then
4507:
4508: hr_utility.set_location(l_proc,6);
4509: return;
4510: end if;
4511: hr_utility.set_location(l_proc,61);
4512: --

Line 4511: hr_utility.set_location(l_proc,61);

4507:
4508: hr_utility.set_location(l_proc,6);
4509: return;
4510: end if;
4511: hr_utility.set_location(l_proc,61);
4512: --
4513: --
4514:
4515: --

Line 4538: hr_utility.set_location(l_proc,7);

4534: pqh_utility.raise_error;
4535: return;
4536: end if;
4537: --
4538: hr_utility.set_location(l_proc,7);
4539: --
4540: end if;
4541: --
4542: --

Line 4546: hr_utility.set_location(l_proc,71);

4542: --
4543:
4544: --
4545: --
4546: hr_utility.set_location(l_proc,71);
4547: pqh_commitment_pkg.refresh_asg_ele_commitments (
4548: p_assignment_id,
4549: p_effective_date,
4550: p_element_type_id,

Line 4552: hr_utility.set_location(l_proc,8);

4548: p_assignment_id,
4549: p_effective_date,
4550: p_element_type_id,
4551: p_input_value_id);
4552: hr_utility.set_location(l_proc,8);
4553: --
4554: --
4555:
4556: --

Line 4570: hr_utility.set_location(l_proc,9);

4566: p_actual_amount => l_pos_actuals_amt,
4567: p_commitment_amount => l_pos_commitment_amt,
4568: p_total_amount => l_pos_actual_cmmt_total_amt
4569: );
4570: hr_utility.set_location(l_proc,9);
4571: --
4572: --
4573: l_pos_reallocated_out_amt :=
4574: pqh_reallocation_pkg.get_reallocated_money(

Line 4613: hr_utility.set_location(l_proc,10);

4609: + nvl(l_pos_reallocated_in_amt,0)
4610: - nvl(l_pos_reserved_amt,0);
4611: --
4612: --
4613: hr_utility.set_location(l_proc,10);
4614: --
4615: hr_utility.set_location(l_proc || ' - Budgeted Amt : '||l_pos_budgeted_amt,10);
4616: hr_utility.set_location(l_proc || ' - Actual Amt : '||l_pos_actuals_amt,10);
4617: hr_utility.set_location(l_proc || ' - Commitment Amt : '||l_pos_commitment_amt,10);

Line 4615: hr_utility.set_location(l_proc || ' - Budgeted Amt : '||l_pos_budgeted_amt,10);

4611: --
4612: --
4613: hr_utility.set_location(l_proc,10);
4614: --
4615: hr_utility.set_location(l_proc || ' - Budgeted Amt : '||l_pos_budgeted_amt,10);
4616: hr_utility.set_location(l_proc || ' - Actual Amt : '||l_pos_actuals_amt,10);
4617: hr_utility.set_location(l_proc || ' - Commitment Amt : '||l_pos_commitment_amt,10);
4618: hr_utility.set_location(l_proc || ' - Realloc Out Amt : '||l_pos_reallocated_out_amt,10);
4619: hr_utility.set_location(l_proc || ' - Realloc In Amt : '||l_pos_reallocated_in_amt,10);

Line 4616: hr_utility.set_location(l_proc || ' - Actual Amt : '||l_pos_actuals_amt,10);

4612: --
4613: hr_utility.set_location(l_proc,10);
4614: --
4615: hr_utility.set_location(l_proc || ' - Budgeted Amt : '||l_pos_budgeted_amt,10);
4616: hr_utility.set_location(l_proc || ' - Actual Amt : '||l_pos_actuals_amt,10);
4617: hr_utility.set_location(l_proc || ' - Commitment Amt : '||l_pos_commitment_amt,10);
4618: hr_utility.set_location(l_proc || ' - Realloc Out Amt : '||l_pos_reallocated_out_amt,10);
4619: hr_utility.set_location(l_proc || ' - Realloc In Amt : '||l_pos_reallocated_in_amt,10);
4620: hr_utility.set_location(l_proc || ' - Reserved Amt : '||l_pos_reserved_amt,10);

Line 4617: hr_utility.set_location(l_proc || ' - Commitment Amt : '||l_pos_commitment_amt,10);

4613: hr_utility.set_location(l_proc,10);
4614: --
4615: hr_utility.set_location(l_proc || ' - Budgeted Amt : '||l_pos_budgeted_amt,10);
4616: hr_utility.set_location(l_proc || ' - Actual Amt : '||l_pos_actuals_amt,10);
4617: hr_utility.set_location(l_proc || ' - Commitment Amt : '||l_pos_commitment_amt,10);
4618: hr_utility.set_location(l_proc || ' - Realloc Out Amt : '||l_pos_reallocated_out_amt,10);
4619: hr_utility.set_location(l_proc || ' - Realloc In Amt : '||l_pos_reallocated_in_amt,10);
4620: hr_utility.set_location(l_proc || ' - Reserved Amt : '||l_pos_reserved_amt,10);
4621: --

Line 4618: hr_utility.set_location(l_proc || ' - Realloc Out Amt : '||l_pos_reallocated_out_amt,10);

4614: --
4615: hr_utility.set_location(l_proc || ' - Budgeted Amt : '||l_pos_budgeted_amt,10);
4616: hr_utility.set_location(l_proc || ' - Actual Amt : '||l_pos_actuals_amt,10);
4617: hr_utility.set_location(l_proc || ' - Commitment Amt : '||l_pos_commitment_amt,10);
4618: hr_utility.set_location(l_proc || ' - Realloc Out Amt : '||l_pos_reallocated_out_amt,10);
4619: hr_utility.set_location(l_proc || ' - Realloc In Amt : '||l_pos_reallocated_in_amt,10);
4620: hr_utility.set_location(l_proc || ' - Reserved Amt : '||l_pos_reserved_amt,10);
4621: --
4622: --

Line 4619: hr_utility.set_location(l_proc || ' - Realloc In Amt : '||l_pos_reallocated_in_amt,10);

4615: hr_utility.set_location(l_proc || ' - Budgeted Amt : '||l_pos_budgeted_amt,10);
4616: hr_utility.set_location(l_proc || ' - Actual Amt : '||l_pos_actuals_amt,10);
4617: hr_utility.set_location(l_proc || ' - Commitment Amt : '||l_pos_commitment_amt,10);
4618: hr_utility.set_location(l_proc || ' - Realloc Out Amt : '||l_pos_reallocated_out_amt,10);
4619: hr_utility.set_location(l_proc || ' - Realloc In Amt : '||l_pos_reallocated_in_amt,10);
4620: hr_utility.set_location(l_proc || ' - Reserved Amt : '||l_pos_reserved_amt,10);
4621: --
4622: --
4623: if (l_pos_under_budgeted_amt < 0) then

Line 4620: hr_utility.set_location(l_proc || ' - Reserved Amt : '||l_pos_reserved_amt,10);

4616: hr_utility.set_location(l_proc || ' - Actual Amt : '||l_pos_actuals_amt,10);
4617: hr_utility.set_location(l_proc || ' - Commitment Amt : '||l_pos_commitment_amt,10);
4618: hr_utility.set_location(l_proc || ' - Realloc Out Amt : '||l_pos_reallocated_out_amt,10);
4619: hr_utility.set_location(l_proc || ' - Realloc In Amt : '||l_pos_reallocated_in_amt,10);
4620: hr_utility.set_location(l_proc || ' - Reserved Amt : '||l_pos_reserved_amt,10);
4621: --
4622: --
4623: if (l_pos_under_budgeted_amt < 0) then
4624: hr_utility.set_location(l_proc||'Leaving with error',11);

Line 4624: hr_utility.set_location(l_proc||'Leaving with error',11);

4620: hr_utility.set_location(l_proc || ' - Reserved Amt : '||l_pos_reserved_amt,10);
4621: --
4622: --
4623: if (l_pos_under_budgeted_amt < 0) then
4624: hr_utility.set_location(l_proc||'Leaving with error',11);
4625:
4626: pqh_utility.set_message(8302,'PQH_SUM_ASG_AMT_GT_BGT_AMT',l_asg_organization_id);
4627: -- pqh_utility.set_message_level_cd(l_message_level);
4628: pqh_utility.set_message_token('POSITION',

Line 4645: hr_utility.set_location(l_proc||'Leaving',12);

4641: */
4642: pqh_utility.raise_error;
4643: end if;
4644: --
4645: hr_utility.set_location(l_proc||'Leaving',12);
4646: --
4647: exception
4648: when others then
4649: hr_utility.set_location(substr(sqlerrm,1,120),13);

Line 4649: hr_utility.set_location(substr(sqlerrm,1,120),13);

4645: hr_utility.set_location(l_proc||'Leaving',12);
4646: --
4647: exception
4648: when others then
4649: hr_utility.set_location(substr(sqlerrm,1,120),13);
4650: raise;
4651: end;
4652:
4653: end PQH_PSF_BUS;