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 PQH_UTILITY

Line 168: pqh_utility.set_message(800,'PER_POS_ELIMINATED',p_rec.organization_id);

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;
172: --

Line 169: pqh_utility.raise_error;

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;
172: --
173: --

Line 191: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_FTE',p_rec.organization_id);

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;
194: hr_utility.set_location('Check FTE validation rule:', 630);
195: --

Line 192: pqh_utility.raise_error;

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;
194: hr_utility.set_location('Check FTE validation rule:', 630);
195: --
196: end if;

Line 206: pqh_utility.set_message(8302,'PQH_ASG_HIRED_BEFORE_EARLIEST',p_rec.organization_id);

202: --
203: l_chk_earliest_hire_date := pqh_psf_bus.chk_earliest_hire_date(
204: p_position_id => p_rec.position_id, p_earliest_hire_date => p_rec.earliest_hire_date );
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: --

Line 207: pqh_utility.raise_error;

203: l_chk_earliest_hire_date := pqh_psf_bus.chk_earliest_hire_date(
204: p_position_id => p_rec.position_id, p_earliest_hire_date => p_rec.earliest_hire_date );
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

Line 217: --pqh_utility.set_message(8302,'PQH_LAYOFF_DT_GT_ASG_DT',p_rec.organization_id);

213: --
214: l_chk_prop_date_for_layoff := pqh_psf_bus.chk_prop_date_for_layoff(
215: p_position_id => p_rec.position_id, p_proposed_date_for_layoff => p_rec.proposed_date_for_layoff );
216: if (not l_chk_prop_date_for_layoff ) then
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);

Line 218: pqh_utility.set_message(8302,'PQH_ASG_DT_GT_LAYOFF_DT',p_rec.organization_id);

214: l_chk_prop_date_for_layoff := pqh_psf_bus.chk_prop_date_for_layoff(
215: p_position_id => p_rec.position_id, p_proposed_date_for_layoff => p_rec.proposed_date_for_layoff );
216: if (not l_chk_prop_date_for_layoff ) then
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;

Line 219: pqh_utility.raise_error;

215: p_position_id => p_rec.position_id, p_proposed_date_for_layoff => p_rec.proposed_date_for_layoff );
216: if (not l_chk_prop_date_for_layoff ) then
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: --

Line 276: pqh_utility.set_message(8302,'PQH_NON_SEASONAL_ASG_DATE',l_rec.organization_id);

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,
275: p_assignment_start_date => p_effective_date) then
276: pqh_utility.set_message(8302,'PQH_NON_SEASONAL_ASG_DATE',l_rec.organization_id);
277: pqh_utility.raise_error;
278: end if;
279: end if;
280: --

Line 277: pqh_utility.raise_error;

273: p_position_id => p_rec.position_id,
274: p_seasonal_flag => l_rec.seasonal_flag,
275: p_assignment_start_date => p_effective_date) then
276: pqh_utility.set_message(8302,'PQH_NON_SEASONAL_ASG_DATE',l_rec.organization_id);
277: pqh_utility.raise_error;
278: end if;
279: end if;
280: --
281: -- Check whether Assignment Grade is same as Position Grade.

Line 285: pqh_utility.set_message(8302,'PQH_NON_POSITION_GRADE',l_rec.organization_id);

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;
288: --
289: -- Check assignment start date to be greater than earliest hire date of the position

Line 286: pqh_utility.raise_error;

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;
288: --
289: -- Check assignment start date to be greater than earliest hire date of the position
290: --

Line 293: pqh_utility.set_message(8302,'PQH_ASG_HIRED_BEFORE_EARLIEST',l_rec.organization_id);

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;
296: --
297: -- Check whether assignment date is before proposed date for Layoff

Line 294: pqh_utility.raise_error;

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;
296: --
297: -- Check whether assignment date is before proposed date for Layoff
298: --

Line 301: pqh_utility.set_message(8302,'PQH_ASG_DT_GT_LAYOFF_DT',l_rec.organization_id);

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;
304: --
305: -- Validate whether a SHARED position has FTE greater than the sum of the budgeted FTE's attached to the Position

Line 302: pqh_utility.raise_error;

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;
304: --
305: -- Validate whether a SHARED position has FTE greater than the sum of the budgeted FTE's attached to the Position
306: --

Line 343: pqh_utility.set_message(8302,'PQH_POOLED_POS_NOT_OPEN',l_rec.organization_id);

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);
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

Line 344: pqh_utility.raise_error;

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);
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);

Line 370: --pqh_utility.set_message(8302,'PQH_POS_RESERVED',l_rec.organization_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,
374: p_rec.position_id, l_rec.position_type,

Line 371: --pqh_utility.raise_error;

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,
374: p_rec.position_id, l_rec.position_type,
375: p_rec.effective_start_date, hr_general.end_of_time, l_default_asg_fte);

Line 379: pqh_utility.set_message_level_cd('W');

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;
383: end if;

Line 380: pqh_utility.raise_error;

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;
383: end if;
384: end if;

Line 396: pqh_utility.set_message(8302,'PQH_SUM_ASG_AMT_GT_BGT_AMT',l_rec.organization_id);

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);
400: end if;

Line 397: pqh_utility.raise_error;

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);
400: end if;
401: */

Line 477: pqh_utility.set_message(8302,'PQH_NON_SEASONAL_ASG_DATE',l_rec.organization_id);

473: p_position_id => p_rec.position_id,
474: p_seasonal_flag => l_rec.seasonal_flag,
475: p_assignment_start_date => p_validation_start_date) then
476:
477: pqh_utility.set_message(8302,'PQH_NON_SEASONAL_ASG_DATE',l_rec.organization_id);
478: pqh_utility.raise_error;
479: end if;
480: end if;
481: end if;

Line 478: pqh_utility.raise_error;

474: p_seasonal_flag => l_rec.seasonal_flag,
475: p_assignment_start_date => p_validation_start_date) then
476:
477: pqh_utility.set_message(8302,'PQH_NON_SEASONAL_ASG_DATE',l_rec.organization_id);
478: pqh_utility.raise_error;
479: end if;
480: end if;
481: end if;
482: --

Line 487: pqh_utility.set_message(8302,'PQH_NON_POSITION_GRADE',l_rec.organization_id);

483: -- Check whether Assignment Grade is same as Position Grade.
484: --
485: if p_rec.position_id <> nvl(l_asg.position_id, -999) or p_rec.grade_id <> l_asg.grade_id then
486: if p_rec.grade_id <> l_rec.entry_grade_id then
487: pqh_utility.set_message(8302,'PQH_NON_POSITION_GRADE',l_rec.organization_id);
488: pqh_utility.raise_error;
489: end if;
490: end if;
491: --

Line 488: pqh_utility.raise_error;

484: --
485: if p_rec.position_id <> nvl(l_asg.position_id, -999) or p_rec.grade_id <> l_asg.grade_id then
486: if p_rec.grade_id <> l_rec.entry_grade_id then
487: pqh_utility.set_message(8302,'PQH_NON_POSITION_GRADE',l_rec.organization_id);
488: pqh_utility.raise_error;
489: end if;
490: end if;
491: --
492: -- Check assignment start date to be greater than earliest hire date of the position

Line 496: pqh_utility.set_message(8302,'PQH_ASG_HIRED_BEFORE_EARLIEST',l_rec.organization_id);

492: -- Check assignment start date to be greater than earliest hire date of the position
493: --
494: if p_rec.position_id <> nvl(l_asg.position_id, -999) or p_validation_start_date <> l_asg.effective_start_date then
495: if p_validation_start_date < l_rec.earliest_hire_date then
496: pqh_utility.set_message(8302,'PQH_ASG_HIRED_BEFORE_EARLIEST',l_rec.organization_id);
497: pqh_utility.raise_error;
498: end if;
499: --
500: -- Check whether assignment date is before proposed date for Layoff

Line 497: pqh_utility.raise_error;

493: --
494: if p_rec.position_id <> nvl(l_asg.position_id, -999) or p_validation_start_date <> l_asg.effective_start_date then
495: if p_validation_start_date < l_rec.earliest_hire_date then
496: pqh_utility.set_message(8302,'PQH_ASG_HIRED_BEFORE_EARLIEST',l_rec.organization_id);
497: pqh_utility.raise_error;
498: end if;
499: --
500: -- Check whether assignment date is before proposed date for Layoff
501: --

Line 503: pqh_utility.set_message(8302,'PQH_ASG_DT_GT_LAYOFF_DT',l_rec.organization_id);

499: --
500: -- Check whether assignment date is before proposed date for Layoff
501: --
502: if (p_validation_start_date > l_rec.proposed_date_for_layoff ) then
503: pqh_utility.set_message(8302,'PQH_ASG_DT_GT_LAYOFF_DT',l_rec.organization_id);
504: pqh_utility.raise_error;
505: end if;
506: end if;
507: --

Line 504: pqh_utility.raise_error;

500: -- Check whether assignment date is before proposed date for Layoff
501: --
502: if (p_validation_start_date > l_rec.proposed_date_for_layoff ) then
503: pqh_utility.set_message(8302,'PQH_ASG_DT_GT_LAYOFF_DT',l_rec.organization_id);
504: pqh_utility.raise_error;
505: end if;
506: end if;
507: --
508: -- Validate whether a SHARED position has FTE greater than the sum of the budgeted FTE's attached to the Position

Line 552: pqh_utility.set_message(8302,'PQH_FTE_NE_SHARED_POS_FTE_CAP',l_rec.organization_id);

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);
553: pqh_utility.raise_error;
554: end if;
555: --
556: hr_utility.set_location('after PQH_FTE_NE_SHARED_POS_FTE_CAP ', 100);

Line 553: pqh_utility.raise_error;

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);
553: pqh_utility.raise_error;
554: end if;
555: --
556: hr_utility.set_location('after PQH_FTE_NE_SHARED_POS_FTE_CAP ', 100);
557: --

Line 567: pqh_utility.set_message(8302,'PQH_POOLED_POS_NOT_OPEN',l_rec.organization_id);

563: if l_rec.position_type = 'POOLED' then
564: if pqh_psf_bus.open_status(l_rec.position_id, l_rec.effective_start_date) = 'OPEN' then
565: null;
566: else
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);

Line 568: pqh_utility.raise_error;

564: if pqh_psf_bus.open_status(l_rec.position_id, l_rec.effective_start_date) = 'OPEN' then
565: null;
566: else
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

Line 586: --pqh_utility.set_message(8302,'PQH_POS_RESERVED',l_rec.organization_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,
590: p_rec.position_id, l_rec.position_type,

Line 587: --pqh_utility.raise_error;

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,
590: p_rec.position_id, l_rec.position_type,
591: p_validation_start_date, hr_general.end_of_time);

Line 595: pqh_utility.set_message_level_cd('W');

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;
599: end if;

Line 596: pqh_utility.raise_error;

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;
599: end if;
600: end if;

Line 738: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_BGT_FTE',l_organization_id);

734: l_bgt_realloc := nvl(l_bdgt,0) + nvl(l_realloc,0);
735: --
736: if l_bgt_realloc < l_sum then
737: l_bgt_lt_abv_fte := true;
738: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_BGT_FTE',l_organization_id);
739: pqh_utility.raise_error;
740: end if;
741: else
742: --

Line 739: pqh_utility.raise_error;

735: --
736: if l_bgt_realloc < l_sum then
737: l_bgt_lt_abv_fte := true;
738: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_BGT_FTE',l_organization_id);
739: pqh_utility.raise_error;
740: end if;
741: else
742: --
743: if l_fte < l_sum then

Line 745: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_FTE',l_organization_id);

741: else
742: --
743: if l_fte < l_sum then
744: l_bgt_lt_abv_fte := true;
745: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_FTE',l_organization_id);
746: pqh_utility.raise_error;
747: end if;
748: end if;
749: end if;

Line 746: pqh_utility.raise_error;

742: --
743: if l_fte < l_sum then
744: l_bgt_lt_abv_fte := true;
745: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_FTE',l_organization_id);
746: pqh_utility.raise_error;
747: end if;
748: end if;
749: end if;
750: end loop;

Line 864: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_BGT_FTE',l_organization_id);

860: --
861: if (l_bgt_realloc < nvl(l_sum_abv,0)+ nvl(p_value,0)) then
862: l_abv_gt_fte := true;
863: ---Position Budget FTE is less than the sum of the assignment budget FTE
864: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_BGT_FTE',l_organization_id);
865: pqh_utility.raise_error;
866: end if;
867: else
868: if (l_fte < nvl(l_sum_abv,0)+ nvl(p_value,0)) then

Line 865: pqh_utility.raise_error;

861: if (l_bgt_realloc < nvl(l_sum_abv,0)+ nvl(p_value,0)) then
862: l_abv_gt_fte := true;
863: ---Position Budget FTE is less than the sum of the assignment budget FTE
864: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_BGT_FTE',l_organization_id);
865: pqh_utility.raise_error;
866: end if;
867: else
868: if (l_fte < nvl(l_sum_abv,0)+ nvl(p_value,0)) then
869: l_abv_gt_fte := true;

Line 871: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_FTE',l_organization_id);

867: else
868: if (l_fte < nvl(l_sum_abv,0)+ nvl(p_value,0)) then
869: l_abv_gt_fte := true;
870: ---Position FTE is less than the sum of the assignment budget FTE
871: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_FTE',l_organization_id);
872: pqh_utility.raise_error;
873: end if;
874: end if;
875: --

Line 872: pqh_utility.raise_error;

868: if (l_fte < nvl(l_sum_abv,0)+ nvl(p_value,0)) then
869: l_abv_gt_fte := true;
870: ---Position FTE is less than the sum of the assignment budget FTE
871: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_FTE',l_organization_id);
872: pqh_utility.raise_error;
873: end if;
874: end if;
875: --
876: if (not l_abv_gt_fte) and (l_position_type = 'SHARED') then

Line 900: pqh_utility.set_message(8302,'PQH_FTE_NE_SHARED_POS_FTE_CAP',l_organization_id);

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);
901: pqh_utility.raise_error;
902: end if;
903: end if;
904: hr_utility.set_location('Exiting Procedure '||l_proc, 200);

Line 901: pqh_utility.raise_error;

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);
901: pqh_utility.raise_error;
902: end if;
903: end if;
904: hr_utility.set_location('Exiting Procedure '||l_proc, 200);
905: end;

Line 1029: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_BGT_FTE' ,l_organization_id);

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;
1031: end if;
1032: else
1033: if (l_fte < nvl(l_sum_abv,0)+ nvl(p_value,0)) then

Line 1030: pqh_utility.raise_error;

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;
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);

Line 1037: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_FTE',l_organization_id);

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;
1039: end if;
1040: end if;
1041: --

Line 1038: pqh_utility.raise_error;

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;
1039: end if;
1040: end if;
1041: --
1042: hr_utility.set_location('Before check reserved', 154);

Line 1071: pqh_utility.set_message(8302,'PQH_FTE_NE_SHARED_POS_FTE_CAP',l_organization_id);

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: --
1075: hr_utility.set_location('After fte capacity', 157);

Line 1072: pqh_utility.raise_error;

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: --
1075: hr_utility.set_location('After fte capacity', 157);
1076: --

Line 1124: l_assignment_fte := pqh_utility.get_pos_budget_values(

1120: and ast.per_system_status <> 'TERM_ASSIGN';
1121: --
1122: begin
1123: /*
1124: l_assignment_fte := pqh_utility.get_pos_budget_values(
1125: p_position_id,p_effective_date,p_effective_date, 'FTE');
1126: */
1127: if p_position_id is not null then
1128: -- l_assignment_fte := 1;

Line 1167: l_assignment_fte := pqh_utility.get_pos_budget_values(

1163: and ast.per_system_status <> 'TERM_ASSIGN';
1164: --
1165: begin
1166: /*
1167: l_assignment_fte := pqh_utility.get_pos_budget_values(
1168: p_position_id,p_effective_date,p_effective_date, 'FTE');
1169: */
1170: if p_position_id is not null then
1171: -- l_assignment_fte := 1;

Line 3910: pqh_utility.set_message_level_cd('W');

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;
3914: else

Line 3911: pqh_utility.raise_error;

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;
3914: else
3915: if l_position_fte < l_total_asg_fte then

Line 3918: pqh_utility.set_message_level_cd('W');

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;
3922: end if;

Line 3919: pqh_utility.raise_error;

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;
3922: end if;
3923: --

Line 3929: pqh_utility.set_message_level_cd('W');

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;
3933: --

Line 3930: pqh_utility.raise_error;

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;
3933: --
3934: end if;

Line 3972: pqh_utility.set_message_level_cd('W');

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;
3976: else

Line 3973: pqh_utility.raise_error;

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;
3976: else
3977: if l_position_fte < l_total_asg_fte then

Line 3980: pqh_utility.set_message_level_cd('W');

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;
3984: end if;

Line 3981: pqh_utility.raise_error;

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;
3984: end if;
3985: --

Line 3991: pqh_utility.set_message_level_cd('W');

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;
3995: --

Line 3992: pqh_utility.raise_error;

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;
3995: --
3996: end if;

Line 4038: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_BGT_FTE',l_organization_id);

4034: l_bgt_realloc := nvl(l_budgeted_fte,0) + nvl(l_realloc,0);
4035: --
4036: if l_bgt_realloc < l_sum then
4037: p_bgt_lt_abv_fte := true;
4038: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_BGT_FTE',l_organization_id);
4039: pqh_utility.raise_error;
4040: end if;
4041: else
4042: if l_position_fte < l_sum then

Line 4039: pqh_utility.raise_error;

4035: --
4036: if l_bgt_realloc < l_sum then
4037: p_bgt_lt_abv_fte := true;
4038: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_BGT_FTE',l_organization_id);
4039: pqh_utility.raise_error;
4040: end if;
4041: else
4042: if l_position_fte < l_sum then
4043: p_bgt_lt_abv_fte := true;

Line 4044: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_FTE',l_organization_id);

4040: end if;
4041: else
4042: if l_position_fte < l_sum then
4043: p_bgt_lt_abv_fte := true;
4044: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_FTE',l_organization_id);
4045: pqh_utility.raise_error;
4046: end if;
4047: end if;
4048: --

Line 4045: pqh_utility.raise_error;

4041: else
4042: if l_position_fte < l_sum then
4043: p_bgt_lt_abv_fte := true;
4044: pqh_utility.set_message(8302,'PQH_SUM_ABV_FTE_GT_POS_FTE',l_organization_id);
4045: pqh_utility.raise_error;
4046: end if;
4047: end if;
4048: --
4049: exception when others then

Line 4166: pqh_utility.set_message(8302,'PQH_POS_RESERVED',p_organization_id);

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) >=
4170: nvl(l_asg_fte,0) + nvl(p_default_asg_fte,0))) then

Line 4167: pqh_utility.raise_error;

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) >=
4170: nvl(l_asg_fte,0) + nvl(p_default_asg_fte,0))) then
4171: hr_utility.set_location('PQH_ANONYM_POS_RESERVED', 115);

Line 4172: pqh_utility.set_message(8302,'PQH_ANONYM_POS_RESERVED',p_organization_id);

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);
4176: pqh_utility.set_message(8302,'PQH_POS_RESERVED',p_organization_id);

Line 4173: pqh_utility.raise_error;

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);
4176: pqh_utility.set_message(8302,'PQH_POS_RESERVED',p_organization_id);
4177: pqh_utility.raise_error;

Line 4176: pqh_utility.set_message(8302,'PQH_POS_RESERVED',p_organization_id);

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: --
4180: end;

Line 4177: pqh_utility.raise_error;

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: --
4180: end;
4181: --

Line 4267: pqh_utility.get_message_level_cd

4263: p_message_name in varchar2,
4264: p_organization_id in number) return varchar2 is
4265: l_rule_level_cd varchar2(1);
4266: begin
4267: pqh_utility.get_message_level_cd
4268: (p_organization_id => p_organization_id,
4269: p_application_id => p_application_id,
4270: p_message_name => p_message_name,
4271: p_rule_level_cd => l_rule_level_cd);

Line 4531: pqh_utility.set_message(8302,'PQH_SAL_NOT_COMMT_ELEMENT',l_asg_organization_id);

4527: l_salary_input_value_id := p_input_value_id;
4528: end if;
4529: --
4530: if (not is_budget_commt_element(l_budget_id, l_salary_element_type_id) ) then
4531: pqh_utility.set_message(8302,'PQH_SAL_NOT_COMMT_ELEMENT',l_asg_organization_id);
4532: pqh_utility.set_message_token('ELEMENT', decode_element(l_salary_element_type_id));
4533: pqh_utility.set_message_token('BUDGET', l_budget_name);
4534: pqh_utility.raise_error;
4535: return;

Line 4532: pqh_utility.set_message_token('ELEMENT', decode_element(l_salary_element_type_id));

4528: end if;
4529: --
4530: if (not is_budget_commt_element(l_budget_id, l_salary_element_type_id) ) then
4531: pqh_utility.set_message(8302,'PQH_SAL_NOT_COMMT_ELEMENT',l_asg_organization_id);
4532: pqh_utility.set_message_token('ELEMENT', decode_element(l_salary_element_type_id));
4533: pqh_utility.set_message_token('BUDGET', l_budget_name);
4534: pqh_utility.raise_error;
4535: return;
4536: end if;

Line 4533: pqh_utility.set_message_token('BUDGET', l_budget_name);

4529: --
4530: if (not is_budget_commt_element(l_budget_id, l_salary_element_type_id) ) then
4531: pqh_utility.set_message(8302,'PQH_SAL_NOT_COMMT_ELEMENT',l_asg_organization_id);
4532: pqh_utility.set_message_token('ELEMENT', decode_element(l_salary_element_type_id));
4533: pqh_utility.set_message_token('BUDGET', l_budget_name);
4534: pqh_utility.raise_error;
4535: return;
4536: end if;
4537: --

Line 4534: pqh_utility.raise_error;

4530: if (not is_budget_commt_element(l_budget_id, l_salary_element_type_id) ) then
4531: pqh_utility.set_message(8302,'PQH_SAL_NOT_COMMT_ELEMENT',l_asg_organization_id);
4532: pqh_utility.set_message_token('ELEMENT', decode_element(l_salary_element_type_id));
4533: pqh_utility.set_message_token('BUDGET', l_budget_name);
4534: pqh_utility.raise_error;
4535: return;
4536: end if;
4537: --
4538: hr_utility.set_location(l_proc,7);

Line 4626: pqh_utility.set_message(8302,'PQH_SUM_ASG_AMT_GT_BGT_AMT',l_asg_organization_id);

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',
4629: hr_general.decode_position(l_asg_position_id));
4630: pqh_utility.set_message_token('UNDER_BUDGETED_AMT',

Line 4627: -- pqh_utility.set_message_level_cd(l_message_level);

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',
4629: hr_general.decode_position(l_asg_position_id));
4630: pqh_utility.set_message_token('UNDER_BUDGETED_AMT',
4631: to_char( -l_pos_under_budgeted_amt,

Line 4628: pqh_utility.set_message_token('POSITION',

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',
4629: hr_general.decode_position(l_asg_position_id));
4630: pqh_utility.set_message_token('UNDER_BUDGETED_AMT',
4631: to_char( -l_pos_under_budgeted_amt,
4632: fnd_currency.GET_FORMAT_MASK(nvl(l_currency_code,'USD'),length(trunc(l_pos_under_budgeted_amt))+15)

Line 4630: pqh_utility.set_message_token('UNDER_BUDGETED_AMT',

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',
4629: hr_general.decode_position(l_asg_position_id));
4630: pqh_utility.set_message_token('UNDER_BUDGETED_AMT',
4631: to_char( -l_pos_under_budgeted_amt,
4632: fnd_currency.GET_FORMAT_MASK(nvl(l_currency_code,'USD'),length(trunc(l_pos_under_budgeted_amt))+15)
4633: ));
4634: /*

Line 4635: pqh_utility.set_message_token('BUDGETED',nvl(l_pos_budgeted_amt,0));

4631: to_char( -l_pos_under_budgeted_amt,
4632: fnd_currency.GET_FORMAT_MASK(nvl(l_currency_code,'USD'),length(trunc(l_pos_under_budgeted_amt))+15)
4633: ));
4634: /*
4635: pqh_utility.set_message_token('BUDGETED',nvl(l_pos_budgeted_amt,0));
4636: pqh_utility.set_message_token('ACTUALS',nvl(l_pos_actuals_amt,0));
4637: pqh_utility.set_message_token('COMMITMENT',nvl(l_pos_commitment_amt,0));
4638: pqh_utility.set_message_token('REALLOC_OUT',nvl(l_pos_reallocated_out_amt,0));
4639: pqh_utility.set_message_token('REALLOC_IN',nvl(l_pos_reallocated_in_amt,0));

Line 4636: pqh_utility.set_message_token('ACTUALS',nvl(l_pos_actuals_amt,0));

4632: fnd_currency.GET_FORMAT_MASK(nvl(l_currency_code,'USD'),length(trunc(l_pos_under_budgeted_amt))+15)
4633: ));
4634: /*
4635: pqh_utility.set_message_token('BUDGETED',nvl(l_pos_budgeted_amt,0));
4636: pqh_utility.set_message_token('ACTUALS',nvl(l_pos_actuals_amt,0));
4637: pqh_utility.set_message_token('COMMITMENT',nvl(l_pos_commitment_amt,0));
4638: pqh_utility.set_message_token('REALLOC_OUT',nvl(l_pos_reallocated_out_amt,0));
4639: pqh_utility.set_message_token('REALLOC_IN',nvl(l_pos_reallocated_in_amt,0));
4640: pqh_utility.set_message_token('RESERVED',nvl(l_pos_reserved_amt,0));

Line 4637: pqh_utility.set_message_token('COMMITMENT',nvl(l_pos_commitment_amt,0));

4633: ));
4634: /*
4635: pqh_utility.set_message_token('BUDGETED',nvl(l_pos_budgeted_amt,0));
4636: pqh_utility.set_message_token('ACTUALS',nvl(l_pos_actuals_amt,0));
4637: pqh_utility.set_message_token('COMMITMENT',nvl(l_pos_commitment_amt,0));
4638: pqh_utility.set_message_token('REALLOC_OUT',nvl(l_pos_reallocated_out_amt,0));
4639: pqh_utility.set_message_token('REALLOC_IN',nvl(l_pos_reallocated_in_amt,0));
4640: pqh_utility.set_message_token('RESERVED',nvl(l_pos_reserved_amt,0));
4641: */

Line 4638: pqh_utility.set_message_token('REALLOC_OUT',nvl(l_pos_reallocated_out_amt,0));

4634: /*
4635: pqh_utility.set_message_token('BUDGETED',nvl(l_pos_budgeted_amt,0));
4636: pqh_utility.set_message_token('ACTUALS',nvl(l_pos_actuals_amt,0));
4637: pqh_utility.set_message_token('COMMITMENT',nvl(l_pos_commitment_amt,0));
4638: pqh_utility.set_message_token('REALLOC_OUT',nvl(l_pos_reallocated_out_amt,0));
4639: pqh_utility.set_message_token('REALLOC_IN',nvl(l_pos_reallocated_in_amt,0));
4640: pqh_utility.set_message_token('RESERVED',nvl(l_pos_reserved_amt,0));
4641: */
4642: pqh_utility.raise_error;

Line 4639: pqh_utility.set_message_token('REALLOC_IN',nvl(l_pos_reallocated_in_amt,0));

4635: pqh_utility.set_message_token('BUDGETED',nvl(l_pos_budgeted_amt,0));
4636: pqh_utility.set_message_token('ACTUALS',nvl(l_pos_actuals_amt,0));
4637: pqh_utility.set_message_token('COMMITMENT',nvl(l_pos_commitment_amt,0));
4638: pqh_utility.set_message_token('REALLOC_OUT',nvl(l_pos_reallocated_out_amt,0));
4639: pqh_utility.set_message_token('REALLOC_IN',nvl(l_pos_reallocated_in_amt,0));
4640: pqh_utility.set_message_token('RESERVED',nvl(l_pos_reserved_amt,0));
4641: */
4642: pqh_utility.raise_error;
4643: end if;

Line 4640: pqh_utility.set_message_token('RESERVED',nvl(l_pos_reserved_amt,0));

4636: pqh_utility.set_message_token('ACTUALS',nvl(l_pos_actuals_amt,0));
4637: pqh_utility.set_message_token('COMMITMENT',nvl(l_pos_commitment_amt,0));
4638: pqh_utility.set_message_token('REALLOC_OUT',nvl(l_pos_reallocated_out_amt,0));
4639: pqh_utility.set_message_token('REALLOC_IN',nvl(l_pos_reallocated_in_amt,0));
4640: pqh_utility.set_message_token('RESERVED',nvl(l_pos_reserved_amt,0));
4641: */
4642: pqh_utility.raise_error;
4643: end if;
4644: --

Line 4642: pqh_utility.raise_error;

4638: pqh_utility.set_message_token('REALLOC_OUT',nvl(l_pos_reallocated_out_amt,0));
4639: pqh_utility.set_message_token('REALLOC_IN',nvl(l_pos_reallocated_in_amt,0));
4640: pqh_utility.set_message_token('RESERVED',nvl(l_pos_reserved_amt,0));
4641: */
4642: pqh_utility.raise_error;
4643: end if;
4644: --
4645: hr_utility.set_location(l_proc||'Leaving',12);
4646: --