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

Line 101: hr_utility.set_location(' get_retained_grade_details',1);

97: BEGIN
98: -- Just in case there is more than one retained grade with the same earliest start
99: -- date we have to return the one with the highest plan_table_value!!
100: -- I'm sure this is very very unlikely to happen!!
101: hr_utility.set_location(' get_retained_grade_details',1);
102: FOR cur_pei_rec IN cur_pei LOOP
103: hr_utility.set_location(' get_retained_grade_details',2);
104: IF l_record_found THEN
105: -- If we have already been here once store all the last details before we get the new ones

Line 103: hr_utility.set_location(' get_retained_grade_details',2);

99: -- date we have to return the one with the highest plan_table_value!!
100: -- I'm sure this is very very unlikely to happen!!
101: hr_utility.set_location(' get_retained_grade_details',1);
102: FOR cur_pei_rec IN cur_pei LOOP
103: hr_utility.set_location(' get_retained_grade_details',2);
104: IF l_record_found THEN
105: -- If we have already been here once store all the last details before we get the new ones
106: -- the main record group will always keep the last highest value!
107: l_last_retained_grade_rec := l_retained_grade_rec;

Line 109: hr_utility.set_location(' get_retained_grade_details person_extra_info_id' ||l_retained_grade_rec.person_extra_info_id ,3);

105: -- If we have already been here once store all the last details before we get the new ones
106: -- the main record group will always keep the last highest value!
107: l_last_retained_grade_rec := l_retained_grade_rec;
108: END IF;
109: hr_utility.set_location(' get_retained_grade_details person_extra_info_id' ||l_retained_grade_rec.person_extra_info_id ,3);
110: l_retained_grade_rec.person_extra_info_id := cur_pei_rec.person_extra_info_id;
111: -- Bug#4423679 Added date_from, date_to columns in the retained grade record.
112: l_retained_grade_rec.date_from := cur_pei_rec.date_from;
113: l_retained_grade_rec.date_to := cur_pei_rec.date_to;

Line 127: hr_utility.set_message(8301, 'GHR_38255_MISSING_RETAINED_DET');

123: OR l_retained_grade_rec.step_or_rate IS NULL
124: OR l_retained_grade_rec.pay_plan IS NULL
125: OR l_retained_grade_rec.user_table_id IS NULL
126: OR l_retained_grade_rec.pay_basis IS NULL THEN
127: hr_utility.set_message(8301, 'GHR_38255_MISSING_RETAINED_DET');
128: raise ghr_pay_calc.pay_calc_message;
129: END IF;
130: --
131: IF l_record_found THEN

Line 132: hr_utility.set_location(' get_retained_grade_details ' ,5);

128: raise ghr_pay_calc.pay_calc_message;
129: END IF;
130: --
131: IF l_record_found THEN
132: hr_utility.set_location(' get_retained_grade_details ' ,5);
133: -- only if we have previously found a retained record with the same start date do we bother
134: -- getting the values to compare
135: ghr_pay_calc.get_pay_table_value (l_retained_grade_rec.user_table_id
136: ,l_retained_grade_rec.pay_plan

Line 170: hr_utility.set_location(' get_retained_grade_details ' ,6);

166: l_retained_grade_rec := l_last_retained_grade_rec;
167: END IF;
168:
169: END IF;
170: hr_utility.set_location(' get_retained_grade_details ' ,6);
171: l_record_found := TRUE;
172:
173: END LOOP;
174:

Line 198: hr_utility.set_location(' get_retained_grade_details ' ,7);

194: IF l_noa_code = '740' THEN
195: l_retained_grade_rec.temp_step := NULL;
196: END IF;
197: -------End Temp Promotion Code changes for 703 and 866 NOACs.
198: hr_utility.set_location(' get_retained_grade_details ' ,7);
199: IF l_record_found THEN
200: hr_utility.set_location(' get_retained_grade_details ' ,7);
201: RETURN (l_retained_grade_rec);
202: ELSE

Line 200: hr_utility.set_location(' get_retained_grade_details ' ,7);

196: END IF;
197: -------End Temp Promotion Code changes for 703 and 866 NOACs.
198: hr_utility.set_location(' get_retained_grade_details ' ,7);
199: IF l_record_found THEN
200: hr_utility.set_location(' get_retained_grade_details ' ,7);
201: RETURN (l_retained_grade_rec);
202: ELSE
203: hr_utility.set_message(8301, 'GHR_38256_NO_RETAINED_GRADE');
204: raise ghr_pay_calc.pay_calc_message;

Line 203: hr_utility.set_message(8301, 'GHR_38256_NO_RETAINED_GRADE');

199: IF l_record_found THEN
200: hr_utility.set_location(' get_retained_grade_details ' ,7);
201: RETURN (l_retained_grade_rec);
202: ELSE
203: hr_utility.set_message(8301, 'GHR_38256_NO_RETAINED_GRADE');
204: raise ghr_pay_calc.pay_calc_message;
205: END IF;
206:
207: END get_retained_grade_details ;

Line 273: hr_utility.set_location(' get_expired_rg_details',1);

269: BEGIN
270: -- Just in case there is more than one retained grade with the same earliest start
271: -- date we have to return the one with the highest plan_table_value!!
272: -- I'm sure this is very very unlikely to happen!!
273: hr_utility.set_location(' get_expired_rg_details',1);
274: FOR cur_pei_rec IN cur_pei LOOP
275: hr_utility.set_location(' get_expired_rg_details',2);
276: IF l_record_found THEN
277: -- If we have already been here once store all the last details before we get the new ones

Line 275: hr_utility.set_location(' get_expired_rg_details',2);

271: -- date we have to return the one with the highest plan_table_value!!
272: -- I'm sure this is very very unlikely to happen!!
273: hr_utility.set_location(' get_expired_rg_details',1);
274: FOR cur_pei_rec IN cur_pei LOOP
275: hr_utility.set_location(' get_expired_rg_details',2);
276: IF l_record_found THEN
277: -- If we have already been here once store all the last details before we get the new ones
278: -- the main record group will always keep the last highest value!
279: l_last_retained_grade_rec := l_retained_grade_rec;

Line 281: hr_utility.set_location(' get_expired_rg_details person_extra_info_id' ||l_retained_grade_rec.person_extra_info_id ,3);

277: -- If we have already been here once store all the last details before we get the new ones
278: -- the main record group will always keep the last highest value!
279: l_last_retained_grade_rec := l_retained_grade_rec;
280: END IF;
281: hr_utility.set_location(' get_expired_rg_details person_extra_info_id' ||l_retained_grade_rec.person_extra_info_id ,3);
282: l_retained_grade_rec.person_extra_info_id := cur_pei_rec.person_extra_info_id;
283: -- Bug#4423679 Added date_from, date_to columns in the retained grade record.
284: l_retained_grade_rec.date_from := cur_pei_rec.date_from;
285: l_retained_grade_rec.date_to := cur_pei_rec.date_to;

Line 299: hr_utility.set_message(8301, 'GHR_38255_MISSING_RETAINED_DET');

295: OR l_retained_grade_rec.step_or_rate IS NULL
296: OR l_retained_grade_rec.pay_plan IS NULL
297: OR l_retained_grade_rec.user_table_id IS NULL
298: OR l_retained_grade_rec.pay_basis IS NULL THEN
299: hr_utility.set_message(8301, 'GHR_38255_MISSING_RETAINED_DET');
300: raise ghr_pay_calc.pay_calc_message;
301: END IF;
302: --
303: IF l_record_found THEN

Line 304: hr_utility.set_location(' get_expired_rg_details ' ,5);

300: raise ghr_pay_calc.pay_calc_message;
301: END IF;
302: --
303: IF l_record_found THEN
304: hr_utility.set_location(' get_expired_rg_details ' ,5);
305: -- only if we have previously found a retained record with the same start date do we bother
306: -- getting the values to compare
307: ghr_pay_calc.get_pay_table_value (l_retained_grade_rec.user_table_id
308: ,l_retained_grade_rec.pay_plan

Line 342: hr_utility.set_location(' get_expired_rg_details ' ,6);

338: l_retained_grade_rec := l_last_retained_grade_rec;
339: END IF;
340:
341: END IF;
342: hr_utility.set_location(' get_expired_rg_details ' ,6);
343: l_record_found := TRUE;
344:
345: END LOOP;
346:

Line 348: hr_utility.set_location(' get_expired_rg_details ' ,7);

344:
345: END LOOP;
346:
347: IF l_record_found THEN
348: hr_utility.set_location(' get_expired_rg_details ' ,7);
349: RETURN (l_retained_grade_rec);
350: ELSE
351: hr_utility.set_message(8301, 'GHR_38256_NO_RETAINED_GRADE');
352: raise ghr_pay_calc.pay_calc_message;

Line 351: hr_utility.set_message(8301, 'GHR_38256_NO_RETAINED_GRADE');

347: IF l_record_found THEN
348: hr_utility.set_location(' get_expired_rg_details ' ,7);
349: RETURN (l_retained_grade_rec);
350: ELSE
351: hr_utility.set_message(8301, 'GHR_38256_NO_RETAINED_GRADE');
352: raise ghr_pay_calc.pay_calc_message;
353: END IF;
354:
355: END get_expired_rg_details ;

Line 444: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');

440: p_PT_eff_end_date := cur_pay_rec.effective_end_date;
441: l_record_found := TRUE;
442: IF l_PT_value IS NULL THEN
443: -- Set tokens to give name of pay table, pay plan, grade, step and rate
444: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');
445: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
446: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
447: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
448: hr_utility.set_message_token('GRADE',p_grade_or_level);

Line 445: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );

441: l_record_found := TRUE;
442: IF l_PT_value IS NULL THEN
443: -- Set tokens to give name of pay table, pay plan, grade, step and rate
444: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');
445: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
446: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
447: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
448: hr_utility.set_message_token('GRADE',p_grade_or_level);
449: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );

Line 446: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);

442: IF l_PT_value IS NULL THEN
443: -- Set tokens to give name of pay table, pay plan, grade, step and rate
444: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');
445: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
446: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
447: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
448: hr_utility.set_message_token('GRADE',p_grade_or_level);
449: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
450: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

Line 447: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);

443: -- Set tokens to give name of pay table, pay plan, grade, step and rate
444: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');
445: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
446: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
447: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
448: hr_utility.set_message_token('GRADE',p_grade_or_level);
449: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
450: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
451: raise ghr_pay_calc.pay_calc_message;

Line 448: hr_utility.set_message_token('GRADE',p_grade_or_level);

444: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');
445: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
446: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
447: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
448: hr_utility.set_message_token('GRADE',p_grade_or_level);
449: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
450: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
451: raise ghr_pay_calc.pay_calc_message;
452: END IF;

Line 449: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );

445: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
446: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
447: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
448: hr_utility.set_message_token('GRADE',p_grade_or_level);
449: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
450: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
451: raise ghr_pay_calc.pay_calc_message;
452: END IF;
453: EXIT;

Line 450: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

446: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
447: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
448: hr_utility.set_message_token('GRADE',p_grade_or_level);
449: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
450: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
451: raise ghr_pay_calc.pay_calc_message;
452: END IF;
453: EXIT;
454: END LOOP;

Line 459: hr_utility.set_message(8301,'GHR_38257_NO_MIN_PAY_PLAN_VAL');

455: --
456: IF NOT l_record_found THEN
457: -- Set tokens to give name of pay table, pay plan, grade, step and rate
458: -- Note: the is no step!
459: hr_utility.set_message(8301,'GHR_38257_NO_MIN_PAY_PLAN_VAL');
460: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
461: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
462: hr_utility.set_message_token('GRADE',p_grade_or_level);
463: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );

Line 460: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );

456: IF NOT l_record_found THEN
457: -- Set tokens to give name of pay table, pay plan, grade, step and rate
458: -- Note: the is no step!
459: hr_utility.set_message(8301,'GHR_38257_NO_MIN_PAY_PLAN_VAL');
460: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
461: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
462: hr_utility.set_message_token('GRADE',p_grade_or_level);
463: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
464: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

Line 461: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);

457: -- Set tokens to give name of pay table, pay plan, grade, step and rate
458: -- Note: the is no step!
459: hr_utility.set_message(8301,'GHR_38257_NO_MIN_PAY_PLAN_VAL');
460: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
461: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
462: hr_utility.set_message_token('GRADE',p_grade_or_level);
463: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
464: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
465: raise ghr_pay_calc.pay_calc_message;

Line 462: hr_utility.set_message_token('GRADE',p_grade_or_level);

458: -- Note: the is no step!
459: hr_utility.set_message(8301,'GHR_38257_NO_MIN_PAY_PLAN_VAL');
460: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
461: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
462: hr_utility.set_message_token('GRADE',p_grade_or_level);
463: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
464: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
465: raise ghr_pay_calc.pay_calc_message;
466: END IF;

Line 463: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );

459: hr_utility.set_message(8301,'GHR_38257_NO_MIN_PAY_PLAN_VAL');
460: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
461: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
462: hr_utility.set_message_token('GRADE',p_grade_or_level);
463: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
464: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
465: raise ghr_pay_calc.pay_calc_message;
466: END IF;
467: --

Line 464: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

460: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
461: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
462: hr_utility.set_message_token('GRADE',p_grade_or_level);
463: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
464: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
465: raise ghr_pay_calc.pay_calc_message;
466: END IF;
467: --
468:

Line 524: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');

520: l_record_found := TRUE;
521:
522: IF l_PT_value IS NULL THEN
523: -- Set tokens to give name of pay table, pay plan, grade, step and rate
524: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');
525: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
526: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
527: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
528: hr_utility.set_message_token('GRADE',p_grade_or_level);

Line 525: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );

521:
522: IF l_PT_value IS NULL THEN
523: -- Set tokens to give name of pay table, pay plan, grade, step and rate
524: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');
525: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
526: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
527: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
528: hr_utility.set_message_token('GRADE',p_grade_or_level);
529: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );

Line 526: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);

522: IF l_PT_value IS NULL THEN
523: -- Set tokens to give name of pay table, pay plan, grade, step and rate
524: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');
525: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
526: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
527: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
528: hr_utility.set_message_token('GRADE',p_grade_or_level);
529: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
530: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

Line 527: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);

523: -- Set tokens to give name of pay table, pay plan, grade, step and rate
524: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');
525: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
526: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
527: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
528: hr_utility.set_message_token('GRADE',p_grade_or_level);
529: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
530: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
531: raise ghr_pay_calc.pay_calc_message;

Line 528: hr_utility.set_message_token('GRADE',p_grade_or_level);

524: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');
525: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
526: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
527: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
528: hr_utility.set_message_token('GRADE',p_grade_or_level);
529: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
530: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
531: raise ghr_pay_calc.pay_calc_message;
532: END IF;

Line 529: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );

525: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
526: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
527: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
528: hr_utility.set_message_token('GRADE',p_grade_or_level);
529: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
530: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
531: raise ghr_pay_calc.pay_calc_message;
532: END IF;
533: EXIT;

Line 530: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

526: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
527: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
528: hr_utility.set_message_token('GRADE',p_grade_or_level);
529: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
530: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
531: raise ghr_pay_calc.pay_calc_message;
532: END IF;
533: EXIT;
534: END LOOP;

Line 538: hr_utility.set_message(8301,'GHR_38258_NO_MAX_PAY_PLAN_VAL');

534: END LOOP;
535: --
536: IF NOT l_record_found THEN
537: -- Set tokens to give name of pay table, pay plan, grade, step and rate
538: hr_utility.set_message(8301,'GHR_38258_NO_MAX_PAY_PLAN_VAL');
539: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
540: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
541: hr_utility.set_message_token('GRADE',p_grade_or_level);
542: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );

Line 539: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );

535: --
536: IF NOT l_record_found THEN
537: -- Set tokens to give name of pay table, pay plan, grade, step and rate
538: hr_utility.set_message(8301,'GHR_38258_NO_MAX_PAY_PLAN_VAL');
539: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
540: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
541: hr_utility.set_message_token('GRADE',p_grade_or_level);
542: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
543: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

Line 540: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);

536: IF NOT l_record_found THEN
537: -- Set tokens to give name of pay table, pay plan, grade, step and rate
538: hr_utility.set_message(8301,'GHR_38258_NO_MAX_PAY_PLAN_VAL');
539: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
540: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
541: hr_utility.set_message_token('GRADE',p_grade_or_level);
542: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
543: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
544: raise ghr_pay_calc.pay_calc_message;

Line 541: hr_utility.set_message_token('GRADE',p_grade_or_level);

537: -- Set tokens to give name of pay table, pay plan, grade, step and rate
538: hr_utility.set_message(8301,'GHR_38258_NO_MAX_PAY_PLAN_VAL');
539: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
540: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
541: hr_utility.set_message_token('GRADE',p_grade_or_level);
542: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
543: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
544: raise ghr_pay_calc.pay_calc_message;
545: END IF;

Line 542: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );

538: hr_utility.set_message(8301,'GHR_38258_NO_MAX_PAY_PLAN_VAL');
539: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
540: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
541: hr_utility.set_message_token('GRADE',p_grade_or_level);
542: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
543: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
544: raise ghr_pay_calc.pay_calc_message;
545: END IF;
546: --

Line 543: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

539: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
540: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
541: hr_utility.set_message_token('GRADE',p_grade_or_level);
542: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
543: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
544: raise ghr_pay_calc.pay_calc_message;
545: END IF;
546: --
547:

Line 635: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');

631: l_record_found := TRUE;
632:
633: IF l_PT_value IS NULL THEN
634: -- Set tokens to give name of pay table, pay plan, grade, step and rate
635: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');
636: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
637: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
638: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
639: hr_utility.set_message_token('GRADE',p_grade_or_level);

Line 636: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );

632:
633: IF l_PT_value IS NULL THEN
634: -- Set tokens to give name of pay table, pay plan, grade, step and rate
635: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');
636: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
637: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
638: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
639: hr_utility.set_message_token('GRADE',p_grade_or_level);
640: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );

Line 637: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);

633: IF l_PT_value IS NULL THEN
634: -- Set tokens to give name of pay table, pay plan, grade, step and rate
635: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');
636: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
637: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
638: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
639: hr_utility.set_message_token('GRADE',p_grade_or_level);
640: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
641: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

Line 638: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);

634: -- Set tokens to give name of pay table, pay plan, grade, step and rate
635: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');
636: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
637: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
638: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
639: hr_utility.set_message_token('GRADE',p_grade_or_level);
640: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
641: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
642: raise ghr_pay_calc.pay_calc_message;

Line 639: hr_utility.set_message_token('GRADE',p_grade_or_level);

635: hr_utility.set_message(8301,'GHR_38252_NULL_PAY_PLAN_VALUE');
636: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
637: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
638: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
639: hr_utility.set_message_token('GRADE',p_grade_or_level);
640: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
641: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
642: raise ghr_pay_calc.pay_calc_message;
643: END IF;

Line 640: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );

636: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
637: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
638: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
639: hr_utility.set_message_token('GRADE',p_grade_or_level);
640: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
641: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
642: raise ghr_pay_calc.pay_calc_message;
643: END IF;
644: EXIT;

Line 641: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

637: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
638: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
639: hr_utility.set_message_token('GRADE',p_grade_or_level);
640: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
641: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
642: raise ghr_pay_calc.pay_calc_message;
643: END IF;
644: EXIT;
645: END IF;

Line 651: hr_utility.set_message(8301,'GHR_38258_NO_MAX_PAY_PLAN_VAL');

647:
648: --
649: IF NOT l_record_found THEN
650: -- Set tokens to give name of pay table, pay plan, grade, step and rate
651: hr_utility.set_message(8301,'GHR_38258_NO_MAX_PAY_PLAN_VAL');
652: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
653: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
654: hr_utility.set_message_token('GRADE',p_grade_or_level);
655: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );

Line 652: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );

648: --
649: IF NOT l_record_found THEN
650: -- Set tokens to give name of pay table, pay plan, grade, step and rate
651: hr_utility.set_message(8301,'GHR_38258_NO_MAX_PAY_PLAN_VAL');
652: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
653: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
654: hr_utility.set_message_token('GRADE',p_grade_or_level);
655: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
656: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

Line 653: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);

649: IF NOT l_record_found THEN
650: -- Set tokens to give name of pay table, pay plan, grade, step and rate
651: hr_utility.set_message(8301,'GHR_38258_NO_MAX_PAY_PLAN_VAL');
652: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
653: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
654: hr_utility.set_message_token('GRADE',p_grade_or_level);
655: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
656: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
657: raise ghr_pay_calc.pay_calc_message;

Line 654: hr_utility.set_message_token('GRADE',p_grade_or_level);

650: -- Set tokens to give name of pay table, pay plan, grade, step and rate
651: hr_utility.set_message(8301,'GHR_38258_NO_MAX_PAY_PLAN_VAL');
652: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
653: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
654: hr_utility.set_message_token('GRADE',p_grade_or_level);
655: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
656: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
657: raise ghr_pay_calc.pay_calc_message;
658: END IF;

Line 655: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );

651: hr_utility.set_message(8301,'GHR_38258_NO_MAX_PAY_PLAN_VAL');
652: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
653: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
654: hr_utility.set_message_token('GRADE',p_grade_or_level);
655: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
656: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
657: raise ghr_pay_calc.pay_calc_message;
658: END IF;
659: --

Line 656: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

652: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
653: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
654: hr_utility.set_message_token('GRADE',p_grade_or_level);
655: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
656: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
657: raise ghr_pay_calc.pay_calc_message;
658: END IF;
659: --
660: END IF; -- p_in_step_or_rate Comparison

Line 865: hr_utility.set_message(8301,'GHR_38395_NOT_CURRENT_PT');

861: PROCEDURE check_current_PT (p_PT_date IN DATE
862: ,p_eff_start_date IN DATE) IS
863: BEGIN
864: IF p_PT_date <> p_eff_start_date THEN
865: hr_utility.set_message(8301,'GHR_38395_NOT_CURRENT_PT');
866: -- hr_utility.set_message_token('PAY_TABLE_NAME',get_user_table_name(p_user_table_id) );
867: raise ghr_pay_calc.pay_calc_message;
868: END IF;
869: END check_current_PT;

Line 866: -- hr_utility.set_message_token('PAY_TABLE_NAME',get_user_table_name(p_user_table_id) );

862: ,p_eff_start_date IN DATE) IS
863: BEGIN
864: IF p_PT_date <> p_eff_start_date THEN
865: hr_utility.set_message(8301,'GHR_38395_NOT_CURRENT_PT');
866: -- hr_utility.set_message_token('PAY_TABLE_NAME',get_user_table_name(p_user_table_id) );
867: raise ghr_pay_calc.pay_calc_message;
868: END IF;
869: END check_current_PT;
870: --

Line 876: hr_utility.set_message(8301,'GHR_38396_NOT_OLD_PT');

872: ,p_eff_end_date IN DATE) IS
873: BEGIN
874: /* This procedure is no more required as per Bug 3837402 .
875: IF p_PT_date -1 <> p_eff_end_date THEN
876: hr_utility.set_message(8301,'GHR_38396_NOT_OLD_PT');
877: -- hr_utility.set_message_token('PAY_TABLE_NAME',get_user_table_name(p_user_table_id) );
878: raise ghr_pay_calc.pay_calc_message;
879: END IF;
880: */

Line 877: -- hr_utility.set_message_token('PAY_TABLE_NAME',get_user_table_name(p_user_table_id) );

873: BEGIN
874: /* This procedure is no more required as per Bug 3837402 .
875: IF p_PT_date -1 <> p_eff_end_date THEN
876: hr_utility.set_message(8301,'GHR_38396_NOT_OLD_PT');
877: -- hr_utility.set_message_token('PAY_TABLE_NAME',get_user_table_name(p_user_table_id) );
878: raise ghr_pay_calc.pay_calc_message;
879: END IF;
880: */
881: null;

Line 1166: hr_utility.set_location(' get_basic_pay_SAL894_50 After first max pay' ||l_eff_start_date,12);

1162: ,l_max_cur_basic_pay
1163: ,l_eff_start_date
1164: ,l_eff_end_date);
1165:
1166: hr_utility.set_location(' get_basic_pay_SAL894_50 After first max pay' ||l_eff_start_date,12);
1167:
1168: -- set the Pay Table efective date as this is the first lookup we have done
1169: l_PT_eff_start_date := l_eff_start_date;
1170:

Line 1180: hr_utility.set_location(' get_basic_pay_SAL894_50 Position id ' ||l_position_id,12);

1176: FOR per_pos_id in cur_per_pos(l_PT_eff_start_date-1)
1177: LOOP
1178: l_position_id := per_pos_id.position_id;
1179: l_assignment_id := per_pos_id.assignment_id;
1180: hr_utility.set_location(' get_basic_pay_SAL894_50 Position id ' ||l_position_id,12);
1181: END LOOP;
1182:
1183: IF l_assignment_id is null THEN
1184: FOR per_pos_id_2 in cur_per_pos_2

Line 1189: hr_utility.set_location(' get_basic_pay_SAL894_50 Position id ' ||l_position_id,12);

1185: LOOP
1186: l_prd_effective_date := per_pos_id_2.effective_start_date;
1187: l_position_id := per_pos_id_2.position_id;
1188: l_assignment_id := per_pos_id_2.assignment_id;
1189: hr_utility.set_location(' get_basic_pay_SAL894_50 Position id ' ||l_position_id,12);
1190: exit;
1191: END LOOP;
1192: END IF;
1193:

Line 1196: hr_utility.set_location(' get_basic_pay_SAL894_50 l_assignment_id' ||l_assignment_id,10);

1192: END IF;
1193:
1194: IF l_assignment_id is not null THEN
1195: -- This is used to get the prd.
1196: hr_utility.set_location(' get_basic_pay_SAL894_50 l_assignment_id' ||l_assignment_id,10);
1197: hr_utility.set_location(' get_basic_pay_SAL894_50 l_prd_effective_date' ||l_prd_effective_date,10);
1198:
1199: ghr_history_fetch.fetch_asgei( p_assignment_id => l_assignment_id
1200: ,p_information_type => 'GHR_US_ASG_SF52'

Line 1197: hr_utility.set_location(' get_basic_pay_SAL894_50 l_prd_effective_date' ||l_prd_effective_date,10);

1193:
1194: IF l_assignment_id is not null THEN
1195: -- This is used to get the prd.
1196: hr_utility.set_location(' get_basic_pay_SAL894_50 l_assignment_id' ||l_assignment_id,10);
1197: hr_utility.set_location(' get_basic_pay_SAL894_50 l_prd_effective_date' ||l_prd_effective_date,10);
1198:
1199: ghr_history_fetch.fetch_asgei( p_assignment_id => l_assignment_id
1200: ,p_information_type => 'GHR_US_ASG_SF52'
1201: ,p_date_effective => l_prd_effective_date

Line 1205: hr_utility.set_location(' get_basic_pay_SAL894_50 l_asg_ei_data.aei_information6 ' ||l_asg_ei_data.aei_information6 ,11);

1201: ,p_date_effective => l_prd_effective_date
1202: ,p_asg_ei_data => l_asg_ei_data
1203: );
1204:
1205: hr_utility.set_location(' get_basic_pay_SAL894_50 l_asg_ei_data.aei_information6 ' ||l_asg_ei_data.aei_information6 ,11);
1206:
1207: IF l_asg_ei_data.aei_information6 NOT IN ('A','B','E','F','U','V') THEN
1208:
1209: l_old_user_table_id := ghr_pay_calc.get_user_table_id( l_position_id , l_prd_effective_date );

Line 1210: hr_utility.set_location(' get_basic_pay_SAL894_50 l_old_user_table_id ' ||l_old_user_table_id ,13);

1206:
1207: IF l_asg_ei_data.aei_information6 NOT IN ('A','B','E','F','U','V') THEN
1208:
1209: l_old_user_table_id := ghr_pay_calc.get_user_table_id( l_position_id , l_prd_effective_date );
1210: hr_utility.set_location(' get_basic_pay_SAL894_50 l_old_user_table_id ' ||l_old_user_table_id ,13);
1211:
1212: ELSE
1213:
1214: --Get the retain grade info as on l_PT_eff_start_date-1

Line 1215: hr_utility.set_location(' get_basic_pay_SAL894_50 p_pay_calc_data.person_id' ||p_pay_calc_data.person_id,14);

1211:
1212: ELSE
1213:
1214: --Get the retain grade info as on l_PT_eff_start_date-1
1215: hr_utility.set_location(' get_basic_pay_SAL894_50 p_pay_calc_data.person_id' ||p_pay_calc_data.person_id,14);
1216: hr_utility.set_location(' get_basic_pay_SAL894_50 l_PT_eff_start_date-1' ||l_PT_eff_start_date,14);
1217: hr_utility.set_location(' get_basic_pay_SAL894_50 p_pay_calc_data.pa_request_id' ||p_pay_calc_data.pa_request_id,14);
1218:
1219: hr_utility.set_location(' get_basic_pay_SAL894_50 l_old_user_table_id ' ||l_old_user_table_id ,14);

Line 1216: hr_utility.set_location(' get_basic_pay_SAL894_50 l_PT_eff_start_date-1' ||l_PT_eff_start_date,14);

1212: ELSE
1213:
1214: --Get the retain grade info as on l_PT_eff_start_date-1
1215: hr_utility.set_location(' get_basic_pay_SAL894_50 p_pay_calc_data.person_id' ||p_pay_calc_data.person_id,14);
1216: hr_utility.set_location(' get_basic_pay_SAL894_50 l_PT_eff_start_date-1' ||l_PT_eff_start_date,14);
1217: hr_utility.set_location(' get_basic_pay_SAL894_50 p_pay_calc_data.pa_request_id' ||p_pay_calc_data.pa_request_id,14);
1218:
1219: hr_utility.set_location(' get_basic_pay_SAL894_50 l_old_user_table_id ' ||l_old_user_table_id ,14);
1220:

Line 1217: hr_utility.set_location(' get_basic_pay_SAL894_50 p_pay_calc_data.pa_request_id' ||p_pay_calc_data.pa_request_id,14);

1213:
1214: --Get the retain grade info as on l_PT_eff_start_date-1
1215: hr_utility.set_location(' get_basic_pay_SAL894_50 p_pay_calc_data.person_id' ||p_pay_calc_data.person_id,14);
1216: hr_utility.set_location(' get_basic_pay_SAL894_50 l_PT_eff_start_date-1' ||l_PT_eff_start_date,14);
1217: hr_utility.set_location(' get_basic_pay_SAL894_50 p_pay_calc_data.pa_request_id' ||p_pay_calc_data.pa_request_id,14);
1218:
1219: hr_utility.set_location(' get_basic_pay_SAL894_50 l_old_user_table_id ' ||l_old_user_table_id ,14);
1220:
1221: /* We cannot use this procedure as pa_request_id is not available as of now.

Line 1219: hr_utility.set_location(' get_basic_pay_SAL894_50 l_old_user_table_id ' ||l_old_user_table_id ,14);

1215: hr_utility.set_location(' get_basic_pay_SAL894_50 p_pay_calc_data.person_id' ||p_pay_calc_data.person_id,14);
1216: hr_utility.set_location(' get_basic_pay_SAL894_50 l_PT_eff_start_date-1' ||l_PT_eff_start_date,14);
1217: hr_utility.set_location(' get_basic_pay_SAL894_50 p_pay_calc_data.pa_request_id' ||p_pay_calc_data.pa_request_id,14);
1218:
1219: hr_utility.set_location(' get_basic_pay_SAL894_50 l_old_user_table_id ' ||l_old_user_table_id ,14);
1220:
1221: /* We cannot use this procedure as pa_request_id is not available as of now.
1222: l_retained_grade_rec := ghr_pc_basic_pay.get_retained_grade_details
1223: (p_person_id => p_pay_calc_data.person_id

Line 1234: hr_utility.set_location(' get_basic_pay_SAL894_50 temp step after loop' ||l_temp_step ,14);

1230: l_old_user_table_id := cur_pei_rec.retained_user_table_id;
1231: l_temp_step := cur_pei_rec.retained_temp_step;
1232: END LOOP;
1233:
1234: hr_utility.set_location(' get_basic_pay_SAL894_50 temp step after loop' ||l_temp_step ,14);
1235: hr_utility.set_location(' get_basic_pay_SAL894_50 l_old_user_table_id after loop' ||l_old_user_table_id ,14);
1236:
1237: --check for temp promotion and temp step is not null then use ghr_pay_calc.get_user_table_id.
1238: IF l_temp_step IS NOT NULL THEN

Line 1235: hr_utility.set_location(' get_basic_pay_SAL894_50 l_old_user_table_id after loop' ||l_old_user_table_id ,14);

1231: l_temp_step := cur_pei_rec.retained_temp_step;
1232: END LOOP;
1233:
1234: hr_utility.set_location(' get_basic_pay_SAL894_50 temp step after loop' ||l_temp_step ,14);
1235: hr_utility.set_location(' get_basic_pay_SAL894_50 l_old_user_table_id after loop' ||l_old_user_table_id ,14);
1236:
1237: --check for temp promotion and temp step is not null then use ghr_pay_calc.get_user_table_id.
1238: IF l_temp_step IS NOT NULL THEN
1239: l_old_user_table_id := ghr_pay_calc.get_user_table_id( l_position_id , l_prd_effective_date );

Line 1240: hr_utility.set_location(' get_basic_pay_SAL894_50 if l_old_user_table_id ' ||l_old_user_table_id ,15);

1236:
1237: --check for temp promotion and temp step is not null then use ghr_pay_calc.get_user_table_id.
1238: IF l_temp_step IS NOT NULL THEN
1239: l_old_user_table_id := ghr_pay_calc.get_user_table_id( l_position_id , l_prd_effective_date );
1240: hr_utility.set_location(' get_basic_pay_SAL894_50 if l_old_user_table_id ' ||l_old_user_table_id ,15);
1241: END IF;
1242:
1243: END IF;
1244:

Line 1310: hr_utility.set_message(8301, 'GHR_38587_NO_CALC_EXCEED_EX_IV');

1306: IF l_ret_basic_pay > ghr_pay_calc.get_standard_pay_table_value('EX'
1307: ,'04'
1308: ,'00'
1309: ,p_pay_calc_data.effective_date) THEN
1310: hr_utility.set_message(8301, 'GHR_38587_NO_CALC_EXCEED_EX_IV');
1311: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
1312: raise ghr_pay_calc.unable_to_calculate;
1313: ELSE
1314: p_basic_pay := l_ret_basic_pay;

Line 1311: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);

1307: ,'04'
1308: ,'00'
1309: ,p_pay_calc_data.effective_date) THEN
1310: hr_utility.set_message(8301, 'GHR_38587_NO_CALC_EXCEED_EX_IV');
1311: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
1312: raise ghr_pay_calc.unable_to_calculate;
1313: ELSE
1314: p_basic_pay := l_ret_basic_pay;
1315: p_step := '00';

Line 1326: hr_utility.set_message(8301, 'GHR_38588_NO_CALC_PAY_RET_END');

1322: END IF;
1323: ELSE -- (pay retention is being terminated)
1324: -- Do not know what to do if pay plan is ES or IE and pay retention is terminated!
1325: IF l_pay_plan = 'CA' THEN
1326: hr_utility.set_message(8301, 'GHR_38588_NO_CALC_PAY_RET_END');
1327: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
1328: raise ghr_pay_calc.unable_to_calculate;
1329: ELSE
1330: p_basic_pay := l_pos_basic_pay;

Line 1327: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);

1323: ELSE -- (pay retention is being terminated)
1324: -- Do not know what to do if pay plan is ES or IE and pay retention is terminated!
1325: IF l_pay_plan = 'CA' THEN
1326: hr_utility.set_message(8301, 'GHR_38588_NO_CALC_PAY_RET_END');
1327: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
1328: raise ghr_pay_calc.unable_to_calculate;
1329: ELSE
1330: p_basic_pay := l_pos_basic_pay;
1331: p_step := l_pos_step;

Line 1483: hr_utility.set_message(8301, 'GHR_38259_NO_WGI_STEP');

1479: END LOOP;
1480: --
1481: -- If we got here no record was returned
1482: -- set tokens to say the user table name and pay_plan that was used
1483: hr_utility.set_message(8301, 'GHR_38259_NO_WGI_STEP');
1484: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
1485: raise ghr_pay_calc.pay_calc_message;
1486: --
1487: END get_next_WGI_step;

Line 1484: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);

1480: --
1481: -- If we got here no record was returned
1482: -- set tokens to say the user table name and pay_plan that was used
1483: hr_utility.set_message(8301, 'GHR_38259_NO_WGI_STEP');
1484: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
1485: raise ghr_pay_calc.pay_calc_message;
1486: --
1487: END get_next_WGI_step;
1488: --

Line 1562: hr_utility.set_location('NAR inside wgi_per',0);

1558: l_retained_grade.grade_or_level := p_retained_grade.grade_or_level;
1559: l_retained_grade.step_or_rate := p_retained_grade.step_or_rate;
1560: l_retained_grade.temp_step := p_retained_grade.temp_step;
1561:
1562: hr_utility.set_location('NAR inside wgi_per',0);
1563: if p_retained_grade.temp_step is not null then
1564: l_step_or_rate := p_retained_grade.temp_step;
1565: l_user_table_id := p_pay_calc_data.user_table_id;
1566: l_pay_plan := p_pay_calc_data.pay_plan;

Line 1579: hr_utility.set_location('NAR inside noa_fam code = CORRECT ',5);

1575: end if;
1576:
1577: IF nvl(g_noa_family_code,'XXX') = 'CORRECT' then
1578: -- Bug 3021003
1579: hr_utility.set_location('NAR inside noa_fam code = CORRECT ',5);
1580: ghr_pay_calc.is_retained_ia(p_pay_calc_data.person_id,
1581: p_pay_calc_data.effective_date,
1582: l_retained_grade.pay_plan,
1583: l_retained_grade.grade_or_level,

Line 1588: hr_utility.set_location('NAR ret step ' ||l_retained_grade.step_or_rate,10);

1584: l_retained_grade.step_or_rate,
1585: l_retained_grade.temp_step,
1586: l_ret_flag);
1587: IF l_ret_flag = TRUE THEN
1588: hr_utility.set_location('NAR ret step ' ||l_retained_grade.step_or_rate,10);
1589: hr_utility.set_location('NAR pay plan '||p_pay_calc_data.pay_plan,20);
1590: -- Check for Temp step
1591: IF p_retained_grade.temp_step is not null then
1592: l_new_step_or_rate := get_next_WGI_step (l_retained_grade.pay_plan,l_step_or_rate);

Line 1589: hr_utility.set_location('NAR pay plan '||p_pay_calc_data.pay_plan,20);

1585: l_retained_grade.temp_step,
1586: l_ret_flag);
1587: IF l_ret_flag = TRUE THEN
1588: hr_utility.set_location('NAR ret step ' ||l_retained_grade.step_or_rate,10);
1589: hr_utility.set_location('NAR pay plan '||p_pay_calc_data.pay_plan,20);
1590: -- Check for Temp step
1591: IF p_retained_grade.temp_step is not null then
1592: l_new_step_or_rate := get_next_WGI_step (l_retained_grade.pay_plan,l_step_or_rate);
1593: ELSE

Line 1596: hr_utility.set_location('NAR new step after getting the step ' ||l_new_step_or_rate,30);

1592: l_new_step_or_rate := get_next_WGI_step (l_retained_grade.pay_plan,l_step_or_rate);
1593: ELSE
1594: l_new_step_or_rate := get_next_WGI_step (l_retained_grade.pay_plan,l_retained_grade.step_or_rate);
1595: END IF;
1596: hr_utility.set_location('NAR new step after getting the step ' ||l_new_step_or_rate,30);
1597: ELSE
1598: l_new_step_or_rate := l_step_or_rate;
1599: END IF;
1600: hr_utility.set_location('NAR new step after getting the step ' ||l_new_step_or_rate,40);

Line 1600: hr_utility.set_location('NAR new step after getting the step ' ||l_new_step_or_rate,40);

1596: hr_utility.set_location('NAR new step after getting the step ' ||l_new_step_or_rate,30);
1597: ELSE
1598: l_new_step_or_rate := l_step_or_rate;
1599: END IF;
1600: hr_utility.set_location('NAR new step after getting the step ' ||l_new_step_or_rate,40);
1601: ELSE
1602: l_new_step_or_rate := get_next_WGI_step (l_pay_plan
1603: ,l_step_or_rate);
1604: END IF;

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

1675:
1676: l_new_std_relative_rate NUMBER;
1677:
1678: BEGIN
1679: hr_utility.set_location('Entering ' || l_proc,5);
1680: -- First work out what pay table data to use
1681: --
1682: IF p_retained_grade.grade_or_level is NULL THEN
1683: hr_utility.set_location('Entering ..No Retained Grade Info.. ' || l_proc,10);

Line 1683: hr_utility.set_location('Entering ..No Retained Grade Info.. ' || l_proc,10);

1679: hr_utility.set_location('Entering ' || l_proc,5);
1680: -- First work out what pay table data to use
1681: --
1682: IF p_retained_grade.grade_or_level is NULL THEN
1683: hr_utility.set_location('Entering ..No Retained Grade Info.. ' || l_proc,10);
1684: l_user_table_id := p_pay_calc_data.user_table_id;
1685: l_pay_plan := p_pay_calc_data.pay_plan;
1686: l_grade_or_level := p_pay_calc_data.grade_or_level;
1687: l_step_or_rate := p_pay_calc_data.step_or_rate;

Line 1691: hr_utility.set_location('Entering ..Retained Grade Info.. ' || l_proc,10);

1687: l_step_or_rate := p_pay_calc_data.step_or_rate;
1688: l_pay_basis := p_pay_calc_data.pay_basis;
1689: --
1690: ELSE
1691: hr_utility.set_location('Entering ..Retained Grade Info.. ' || l_proc,10);
1692: l_user_table_id := p_retained_grade.user_table_id;
1693: l_pay_plan := p_retained_grade.pay_plan;
1694: l_grade_or_level := p_retained_grade.grade_or_level;
1695: l_step_or_rate := p_retained_grade.step_or_rate;

Line 1708: hr_utility.set_location('Calculating for GS Plan ..Basic Pay ' || l_proc,15);

1704: ,p_pay_calc_data.effective_date);
1705: --
1706: IF l_pay_plan = 'GS' THEN
1707:
1708: hr_utility.set_location('Calculating for GS Plan ..Basic Pay ' || l_proc,15);
1709: hr_utility.set_location('user_table_id..' || to_char(l_user_table_id) ,15);
1710:
1711: ghr_pay_calc.get_pay_table_value(l_user_table_id
1712: ,l_pay_plan

Line 1709: hr_utility.set_location('user_table_id..' || to_char(l_user_table_id) ,15);

1705: --
1706: IF l_pay_plan = 'GS' THEN
1707:
1708: hr_utility.set_location('Calculating for GS Plan ..Basic Pay ' || l_proc,15);
1709: hr_utility.set_location('user_table_id..' || to_char(l_user_table_id) ,15);
1710:
1711: ghr_pay_calc.get_pay_table_value(l_user_table_id
1712: ,l_pay_plan
1713: ,l_grade_or_level

Line 1720: hr_utility.set_location('Calculating for GS Plan ..Locality Pay ' || l_proc,20);

1716: ,l_basic_pay
1717: ,l_PT_eff_start_date
1718: ,l_dummy_date);
1719:
1720: hr_utility.set_location('Calculating for GS Plan ..Locality Pay ' || l_proc,20);
1721:
1722: ghr_pay_calc.get_locality_adj_894_PRDM_GS
1723: (p_user_table_id => l_user_table_id
1724: ,p_pay_plan => l_pay_plan

Line 1772: hr_utility.set_location('Calculating for GM Plan ..Basic Pay ' || l_proc,25);

1768: END IF;
1769:
1770: ELSIF l_pay_plan = 'GM' THEN
1771:
1772: hr_utility.set_location('Calculating for GM Plan ..Basic Pay ' || l_proc,25);
1773:
1774: get_basic_pay_SAL894_6step(p_pay_calc_data
1775: ,p_retained_grade
1776: ,'POSITION'

Line 1781: hr_utility.set_location('Calculating for GM Plan ..Locality Pay ' || l_proc,20);

1777: ,l_basic_pay
1778: ,l_PT_eff_start_date
1779: ,l_dummy_number);
1780:
1781: hr_utility.set_location('Calculating for GM Plan ..Locality Pay ' || l_proc,20);
1782:
1783: ghr_pay_calc.get_locality_adj_894_PRDM_GM
1784: (p_pay_calc_data => p_pay_calc_data
1785: ,p_retained_grade => p_retained_grade

Line 1809: hr_utility.set_location('Leaving .. ' || l_proc,5);

1805: p_basic_pay := nvl(l_basic_pay,0);
1806: p_PT_eff_start_date := l_PT_eff_start_date;
1807:
1808: END IF;
1809: hr_utility.set_location('Leaving .. ' || l_proc,5);
1810:
1811: EXCEPTION
1812: WHEN others THEN
1813: -- Reset IN OUT parameters and set OUT parameters

Line 1819: hr_utility.set_location('Leaving .. ' || l_proc,6);

1815: p_basic_pay := NULL;
1816: p_prd := NULL;
1817: p_PT_eff_start_date := NULL;
1818:
1819: hr_utility.set_location('Leaving .. ' || l_proc,6);
1820: RAISE;
1821: END get_basic_pay_SAL894_PRDM;
1822:
1823: ----------------------------------------------------------------------------------------

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

1869: BEGIN
1870:
1871: l_retained_grade := p_retained_grade ;
1872: l_fws_flag := 'FALSE'; ---Bug 1360547
1873: hr_utility.set_location('Entering ' || l_proc,5);
1874: -- get retained grade record if there is one, there MUST be one for 'A','B','E','F','U','V'
1875: -- and maybe one for 'M'
1876: IF p_pay_calc_data.pay_rate_determinant IN ('A','B','E','F','U','V','M') THEN
1877: -- Begin Bug# 13619633, as per bug 1929382 for 866 we are passing eff date+1 this is casuing the issue.

Line 1958: hr_utility.set_location('before Basic Pay',1000);

1954: -- all you have to do is a striaght look up on the user table given, using step,pay_plan,and
1955: -- grade given at the effective date also given
1956: -- Note: need for any conversion since it must already be in the given pay basis
1957:
1958: hr_utility.set_location('before Basic Pay',1000);
1959: FOR rec_chk_user_table in chk_user_table(p_user_table_id => p_pay_calc_data.user_table_id)
1960: LOOP
1961: l_chk_user_table := 'Y';
1962: END LOOP;

Line 1974: hr_utility.set_location('p_pay_calc_data.current_basic_pay'||p_pay_calc_data.current_basic_pay,1000);

1970: p_pay_calc_data.grade_or_level = '00' and
1971: p_pay_calc_data.step_or_rate = '00' and
1972: p_pay_calc_data.pay_rate_determinant = '0'
1973: and NVL(l_chk_user_table,'N') = 'Y' THEN
1974: hr_utility.set_location('p_pay_calc_data.current_basic_pay'||p_pay_calc_data.current_basic_pay,1000);
1975: p_pay_calc_out_data.basic_pay := p_pay_calc_data.current_basic_pay;
1976:
1977: ELSE
1978:

Line 1995: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');

1991: ,p_retained_grade
1992: ,p_pay_calc_out_data.basic_pay
1993: ,l_dummy_date);
1994: ELSE
1995: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');
1996: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
1997: raise ghr_pay_calc.unable_to_calculate;
1998: END IF;
1999: --

Line 1996: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);

1992: ,p_pay_calc_out_data.basic_pay
1993: ,l_dummy_date);
1994: ELSE
1995: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');
1996: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
1997: raise ghr_pay_calc.unable_to_calculate;
1998: END IF;
1999: --
2000: ELSE

Line 2001: hr_utility.set_message(8301, 'GHR_38260_NO_CALC_PAY_PLAN');

1997: raise ghr_pay_calc.unable_to_calculate;
1998: END IF;
1999: --
2000: ELSE
2001: hr_utility.set_message(8301, 'GHR_38260_NO_CALC_PAY_PLAN');
2002: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2003: raise ghr_pay_calc.unable_to_calculate;
2004: END IF;
2005: ELSIF SUBSTR(p_pay_calc_data.noa_family_code ,1,8) = 'GHR_SAL_' THEN

Line 2002: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);

1998: END IF;
1999: --
2000: ELSE
2001: hr_utility.set_message(8301, 'GHR_38260_NO_CALC_PAY_PLAN');
2002: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2003: raise ghr_pay_calc.unable_to_calculate;
2004: END IF;
2005: ELSIF SUBSTR(p_pay_calc_data.noa_family_code ,1,8) = 'GHR_SAL_' THEN
2006: -- For salary change family we need to further investigate the noac to determine

Line 2094: hr_utility.set_location('Calling ..SAL894_PRDM.. ' || l_proc,15);

2090: --AVR
2091: ELSIF ( l_pay_plan IN ('GS','GL','GM')
2092: AND p_pay_calc_data.pay_rate_determinant = 'M' ) THEN
2093:
2094: hr_utility.set_location('Calling ..SAL894_PRDM.. ' || l_proc,15);
2095: get_basic_pay_SAL894_PRDM (p_pay_calc_data
2096: ,p_retained_grade
2097: ,p_pay_calc_out_data.basic_pay
2098: ,p_pay_calc_out_data.out_pay_rate_determinant

Line 2100: hr_utility.set_location('Called ..SAL894_PRDM.. ' || l_proc,25);

2096: ,p_retained_grade
2097: ,p_pay_calc_out_data.basic_pay
2098: ,p_pay_calc_out_data.out_pay_rate_determinant
2099: ,p_pay_calc_out_data.PT_eff_start_date );
2100: hr_utility.set_location('Called ..SAL894_PRDM.. ' || l_proc,25);
2101:
2102: --AVR
2103:
2104:

Line 2107: hr_utility.set_message(8301, 'GHR_38520_PRD_D');

2103:
2104:
2105: --Begin Bug# 7557159
2106: ELSIF p_pay_calc_data.pay_rate_determinant = 'D' THEN
2107: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2108: raise ghr_pay_calc.open_pay_range_mesg;
2109: --End Bug# 7557159
2110: ELSE
2111: hr_utility.set_message(8301, 'GHR_38391_NO_CALC_PAY_PLAN_PRD');

Line 2111: hr_utility.set_message(8301, 'GHR_38391_NO_CALC_PAY_PLAN_PRD');

2107: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2108: raise ghr_pay_calc.open_pay_range_mesg;
2109: --End Bug# 7557159
2110: ELSE
2111: hr_utility.set_message(8301, 'GHR_38391_NO_CALC_PAY_PLAN_PRD');
2112: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2113: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
2114: raise ghr_pay_calc.unable_to_calculate;
2115: END IF;

Line 2112: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);

2108: raise ghr_pay_calc.open_pay_range_mesg;
2109: --End Bug# 7557159
2110: ELSE
2111: hr_utility.set_message(8301, 'GHR_38391_NO_CALC_PAY_PLAN_PRD');
2112: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2113: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
2114: raise ghr_pay_calc.unable_to_calculate;
2115: END IF;
2116: --

Line 2113: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);

2109: --End Bug# 7557159
2110: ELSE
2111: hr_utility.set_message(8301, 'GHR_38391_NO_CALC_PAY_PLAN_PRD');
2112: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2113: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
2114: raise ghr_pay_calc.unable_to_calculate;
2115: END IF;
2116: --
2117: ELSIF (p_pay_calc_data.effective_date >= to_date('2007/01/07','YYYY/MM/DD') AND

Line 2131: hr_utility.set_message(8301, 'GHR_38248_INV_PAY_PLAN_891');

2127: --Bug# 5132113 added pay plan GR
2128: ELSIF l_pay_plan NOT IN ('GM','GH','GR') THEN
2129: IF p_pay_calc_data.noa_code = '891' AND
2130: p_pay_calc_data.effective_date < to_date('2007/01/07','YYYY/MM/DD')THEN --Bug# 5482191
2131: hr_utility.set_message(8301, 'GHR_38248_INV_PAY_PLAN_891');
2132: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2133: raise ghr_pay_calc.pay_calc_message;
2134: --
2135: ELSIF p_pay_calc_data.noa_code IN ('867','892','893') THEN

Line 2132: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);

2128: ELSIF l_pay_plan NOT IN ('GM','GH','GR') THEN
2129: IF p_pay_calc_data.noa_code = '891' AND
2130: p_pay_calc_data.effective_date < to_date('2007/01/07','YYYY/MM/DD')THEN --Bug# 5482191
2131: hr_utility.set_message(8301, 'GHR_38248_INV_PAY_PLAN_891');
2132: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2133: raise ghr_pay_calc.pay_calc_message;
2134: --
2135: ELSIF p_pay_calc_data.noa_code IN ('867','892','893') THEN
2136: --

Line 2148: hr_utility.set_message(8301, 'GHR_38520_PRD_D');

2144: ,p_pay_calc_out_data.basic_pay
2145: ,p_pay_calc_out_data.out_step_or_rate);
2146: --Begin Bug# 7557159
2147: ELSIF p_pay_calc_data.pay_rate_determinant = 'D' THEN
2148: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2149: raise ghr_pay_calc.open_pay_range_mesg;
2150: --End Bug# 7557159
2151: ELSE
2152: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');

Line 2152: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');

2148: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2149: raise ghr_pay_calc.open_pay_range_mesg;
2150: --End Bug# 7557159
2151: ELSE
2152: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');
2153: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
2154: raise ghr_pay_calc.unable_to_calculate;
2155: END IF;
2156:

Line 2153: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);

2149: raise ghr_pay_calc.open_pay_range_mesg;
2150: --End Bug# 7557159
2151: ELSE
2152: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');
2153: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
2154: raise ghr_pay_calc.unable_to_calculate;
2155: END IF;
2156:
2157: ELSIF (p_pay_calc_data.noa_code IN ('890') AND (l_fws_flag = 'TRUE' or l_es_flag = 'TRUE')) THEN

Line 2228: hr_utility.set_message(8301, 'GHR_38520_PRD_D');

2224: ,l_dummy_date);
2225: --
2226: --Begin Bug# 7557159
2227: ELSIF p_pay_calc_data.pay_rate_determinant = 'D' THEN
2228: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2229: raise ghr_pay_calc.open_pay_range_mesg;
2230: --End Bug# 7557159
2231: ELSE
2232: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');

Line 2232: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');

2228: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2229: raise ghr_pay_calc.open_pay_range_mesg;
2230: --End Bug# 7557159
2231: ELSE
2232: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');
2233: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
2234: raise ghr_pay_calc.unable_to_calculate;
2235: END IF;
2236:

Line 2233: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);

2229: raise ghr_pay_calc.open_pay_range_mesg;
2230: --End Bug# 7557159
2231: ELSE
2232: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');
2233: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
2234: raise ghr_pay_calc.unable_to_calculate;
2235: END IF;
2236:
2237: ELSE -- All other NoaC's for the salary change family (not GM,GH)

Line 2260: hr_utility.set_message(8301, 'GHR_38520_PRD_D');

2256: ,l_dummy_date);
2257: --
2258: --Begin Bug# 7557159
2259: ELSIF p_pay_calc_data.pay_rate_determinant = 'D' THEN
2260: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2261: raise ghr_pay_calc.open_pay_range_mesg;
2262: --End Bug# 7557159
2263: ELSE
2264: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');

Line 2264: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');

2260: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2261: raise ghr_pay_calc.open_pay_range_mesg;
2262: --End Bug# 7557159
2263: ELSE
2264: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');
2265: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
2266: raise ghr_pay_calc.unable_to_calculate;
2267: END IF;
2268:

Line 2265: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);

2261: raise ghr_pay_calc.open_pay_range_mesg;
2262: --End Bug# 7557159
2263: ELSE
2264: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');
2265: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
2266: raise ghr_pay_calc.unable_to_calculate;
2267: END IF;
2268:
2269: --Pradeep commented for Title 38 Changes

Line 2284: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');

2280: ELSE -- Not 894, not 895 and must be GM, GH pay plans
2281: --
2282: --Bug# 5132113 added pay plan GR condition
2283: /*IF l_pay_plan in('GR') THEN
2284: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');
2285: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
2286: raise ghr_pay_calc.unable_to_calculate;
2287: ELS*/ --Bug# 6342011 Commented
2288: IF p_pay_calc_data.noa_code IN ('891','892') THEN

Line 2285: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);

2281: --
2282: --Bug# 5132113 added pay plan GR condition
2283: /*IF l_pay_plan in('GR') THEN
2284: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');
2285: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
2286: raise ghr_pay_calc.unable_to_calculate;
2287: ELS*/ --Bug# 6342011 Commented
2288: IF p_pay_calc_data.noa_code IN ('891','892') THEN
2289: IF p_pay_calc_data.pay_rate_determinant IN ('0','6') THEN

Line 2300: hr_utility.set_message(8301, 'GHR_38520_PRD_D');

2296: ,p_pay_calc_out_data.basic_pay
2297: ,p_pay_calc_out_data.out_step_or_rate);
2298: --Begin Bug# 7557159
2299: ELSIF p_pay_calc_data.pay_rate_determinant = 'D' THEN
2300: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2301: raise ghr_pay_calc.open_pay_range_mesg;
2302: --End Bug# 7557159
2303: ELSE
2304: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');

Line 2304: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');

2300: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2301: raise ghr_pay_calc.open_pay_range_mesg;
2302: --End Bug# 7557159
2303: ELSE
2304: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');
2305: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
2306: raise ghr_pay_calc.unable_to_calculate;
2307: END IF;
2308: --Begin Bug 5661441 AFHR change

Line 2305: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);

2301: raise ghr_pay_calc.open_pay_range_mesg;
2302: --End Bug# 7557159
2303: ELSE
2304: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');
2305: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
2306: raise ghr_pay_calc.unable_to_calculate;
2307: END IF;
2308: --Begin Bug 5661441 AFHR change
2309:

Line 2312: hr_utility.set_message(8301, 'GHR_INV_PAY_PLAN_893');

2308: --Begin Bug 5661441 AFHR change
2309:
2310: ELSIF p_pay_calc_data.noa_code IN ('893') THEN
2311: IF p_pay_calc_data.effective_date < to_date('2007/01/07','YYYY/MM/DD')THEN
2312: hr_utility.set_message(8301, 'GHR_INV_PAY_PLAN_893');
2313: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2314: hr_utility.set_message_token('NOAC',p_pay_calc_data.noa_code);
2315: raise ghr_pay_calc.pay_calc_message;
2316: ELSE

Line 2313: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);

2309:
2310: ELSIF p_pay_calc_data.noa_code IN ('893') THEN
2311: IF p_pay_calc_data.effective_date < to_date('2007/01/07','YYYY/MM/DD')THEN
2312: hr_utility.set_message(8301, 'GHR_INV_PAY_PLAN_893');
2313: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2314: hr_utility.set_message_token('NOAC',p_pay_calc_data.noa_code);
2315: raise ghr_pay_calc.pay_calc_message;
2316: ELSE
2317: IF p_pay_calc_data.pay_rate_determinant IN ('0','6') THEN

Line 2314: hr_utility.set_message_token('NOAC',p_pay_calc_data.noa_code);

2310: ELSIF p_pay_calc_data.noa_code IN ('893') THEN
2311: IF p_pay_calc_data.effective_date < to_date('2007/01/07','YYYY/MM/DD')THEN
2312: hr_utility.set_message(8301, 'GHR_INV_PAY_PLAN_893');
2313: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2314: hr_utility.set_message_token('NOAC',p_pay_calc_data.noa_code);
2315: raise ghr_pay_calc.pay_calc_message;
2316: ELSE
2317: IF p_pay_calc_data.pay_rate_determinant IN ('0','6') THEN
2318: get_basic_pay_SAL891_pos(p_pay_calc_data

Line 2328: hr_utility.set_message(8301, 'GHR_38520_PRD_D');

2324: ,p_pay_calc_out_data.basic_pay
2325: ,p_pay_calc_out_data.out_step_or_rate);
2326: --Begin Bug# 7557159
2327: ELSIF p_pay_calc_data.pay_rate_determinant = 'D' THEN
2328: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2329: raise ghr_pay_calc.open_pay_range_mesg;
2330: --End Bug# 7557159
2331: ELSE
2332: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');

Line 2332: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');

2328: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2329: raise ghr_pay_calc.open_pay_range_mesg;
2330: --End Bug# 7557159
2331: ELSE
2332: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');
2333: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
2334: raise ghr_pay_calc.unable_to_calculate;
2335: END IF;
2336: END IF;

Line 2333: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);

2329: raise ghr_pay_calc.open_pay_range_mesg;
2330: --End Bug# 7557159
2331: ELSE
2332: hr_utility.set_message(8301, 'GHR_38254_NO_CALC_PRD');
2333: hr_utility.set_message_token('PRD',p_pay_calc_data.pay_rate_determinant);
2334: raise ghr_pay_calc.unable_to_calculate;
2335: END IF;
2336: END IF;
2337:

Line 2340: hr_utility.set_message(8301, 'GHR_INV_PAY_PLAN_893');

2336: END IF;
2337:
2338: --end Bug 5661441 AFHR change
2339: ELSIF p_pay_calc_data.noa_code IN ('867') THEN --AFHR change 893 removed
2340: hr_utility.set_message(8301, 'GHR_INV_PAY_PLAN_893');
2341: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2342: hr_utility.set_message_token('NOAC',p_pay_calc_data.noa_code);
2343: raise ghr_pay_calc.pay_calc_message;
2344: --

Line 2341: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);

2337:
2338: --end Bug 5661441 AFHR change
2339: ELSIF p_pay_calc_data.noa_code IN ('867') THEN --AFHR change 893 removed
2340: hr_utility.set_message(8301, 'GHR_INV_PAY_PLAN_893');
2341: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2342: hr_utility.set_message_token('NOAC',p_pay_calc_data.noa_code);
2343: raise ghr_pay_calc.pay_calc_message;
2344: --
2345: --Begin Bug# 7557159

Line 2342: hr_utility.set_message_token('NOAC',p_pay_calc_data.noa_code);

2338: --end Bug 5661441 AFHR change
2339: ELSIF p_pay_calc_data.noa_code IN ('867') THEN --AFHR change 893 removed
2340: hr_utility.set_message(8301, 'GHR_INV_PAY_PLAN_893');
2341: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2342: hr_utility.set_message_token('NOAC',p_pay_calc_data.noa_code);
2343: raise ghr_pay_calc.pay_calc_message;
2344: --
2345: --Begin Bug# 7557159
2346: ELSIF p_pay_calc_data.pay_rate_determinant = 'D' THEN

Line 2347: hr_utility.set_message(8301, 'GHR_38520_PRD_D');

2343: raise ghr_pay_calc.pay_calc_message;
2344: --
2345: --Begin Bug# 7557159
2346: ELSIF p_pay_calc_data.pay_rate_determinant = 'D' THEN
2347: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2348: raise ghr_pay_calc.open_pay_range_mesg;
2349: --End Bug# 7557159
2350: ELSE
2351: hr_utility.set_message(8301, 'GHR_38260_NO_CALC_PAY_PLAN');

Line 2351: hr_utility.set_message(8301, 'GHR_38260_NO_CALC_PAY_PLAN');

2347: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2348: raise ghr_pay_calc.open_pay_range_mesg;
2349: --End Bug# 7557159
2350: ELSE
2351: hr_utility.set_message(8301, 'GHR_38260_NO_CALC_PAY_PLAN');
2352: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2353: raise ghr_pay_calc.unable_to_calculate;
2354: END IF;
2355: --

Line 2352: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);

2348: raise ghr_pay_calc.open_pay_range_mesg;
2349: --End Bug# 7557159
2350: ELSE
2351: hr_utility.set_message(8301, 'GHR_38260_NO_CALC_PAY_PLAN');
2352: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2353: raise ghr_pay_calc.unable_to_calculate;
2354: END IF;
2355: --
2356: END IF;

Line 2359: hr_utility.set_message(8301, 'GHR_38520_PRD_D');

2355: --
2356: END IF;
2357: --Begin Bug# 7557159
2358: ELSIF p_pay_calc_data.pay_rate_determinant = 'D' THEN
2359: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2360: raise ghr_pay_calc.open_pay_range_mesg;
2361: --End Bug# 7557159
2362: ELSE
2363: hr_utility.set_message(8301, 'GHR_38261_NO_CALC_FAMILY');

Line 2363: hr_utility.set_message(8301, 'GHR_38261_NO_CALC_FAMILY');

2359: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2360: raise ghr_pay_calc.open_pay_range_mesg;
2361: --End Bug# 7557159
2362: ELSE
2363: hr_utility.set_message(8301, 'GHR_38261_NO_CALC_FAMILY');
2364: hr_utility.set_message_token('FAMILY',p_pay_calc_data.noa_family_code);
2365: raise ghr_pay_calc.unable_to_calculate;
2366: END IF;
2367: --

Line 2364: hr_utility.set_message_token('FAMILY',p_pay_calc_data.noa_family_code);

2360: raise ghr_pay_calc.open_pay_range_mesg;
2361: --End Bug# 7557159
2362: ELSE
2363: hr_utility.set_message(8301, 'GHR_38261_NO_CALC_FAMILY');
2364: hr_utility.set_message_token('FAMILY',p_pay_calc_data.noa_family_code);
2365: raise ghr_pay_calc.unable_to_calculate;
2366: END IF;
2367: --
2368: --Begin Bug# 7557159

Line 2370: hr_utility.set_message(8301, 'GHR_38520_PRD_D');

2366: END IF;
2367: --
2368: --Begin Bug# 7557159
2369: ELSIF p_pay_calc_data.pay_rate_determinant = 'D' THEN
2370: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2371: raise ghr_pay_calc.open_pay_range_mesg;
2372: --End Bug# 7557159
2373: ELSE
2374: hr_utility.set_message(8301, 'GHR_38260_NO_CALC_PAY_PLAN');

Line 2374: hr_utility.set_message(8301, 'GHR_38260_NO_CALC_PAY_PLAN');

2370: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2371: raise ghr_pay_calc.open_pay_range_mesg;
2372: --End Bug# 7557159
2373: ELSE
2374: hr_utility.set_message(8301, 'GHR_38260_NO_CALC_PAY_PLAN');
2375: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2376: raise ghr_pay_calc.unable_to_calculate;
2377: END IF;
2378: --Begin Bug# 7557159

Line 2375: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);

2371: raise ghr_pay_calc.open_pay_range_mesg;
2372: --End Bug# 7557159
2373: ELSE
2374: hr_utility.set_message(8301, 'GHR_38260_NO_CALC_PAY_PLAN');
2375: hr_utility.set_message_token('PAY_PLAN',l_pay_plan);
2376: raise ghr_pay_calc.unable_to_calculate;
2377: END IF;
2378: --Begin Bug# 7557159
2379: ELSIF p_pay_calc_data.pay_rate_determinant = 'D' THEN

Line 2380: hr_utility.set_message(8301, 'GHR_38520_PRD_D');

2376: raise ghr_pay_calc.unable_to_calculate;
2377: END IF;
2378: --Begin Bug# 7557159
2379: ELSIF p_pay_calc_data.pay_rate_determinant = 'D' THEN
2380: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2381: raise ghr_pay_calc.open_pay_range_mesg;
2382: --End Bug# 7557159
2383: ELSE
2384: hr_utility.set_message(8301, 'GHR_38262_NO_CALC_PAY_BASIS');

Line 2384: hr_utility.set_message(8301, 'GHR_38262_NO_CALC_PAY_BASIS');

2380: hr_utility.set_message(8301, 'GHR_38520_PRD_D');
2381: raise ghr_pay_calc.open_pay_range_mesg;
2382: --End Bug# 7557159
2383: ELSE
2384: hr_utility.set_message(8301, 'GHR_38262_NO_CALC_PAY_BASIS');
2385: -- It could be either the position pay basis or the retained pay basis as to why we couldn't
2386: -- calculate
2387: IF p_pay_calc_data.pay_basis NOT IN ('PA','PH','BW') THEN
2388: hr_utility.set_message_token('PAY_BASIS',

Line 2388: hr_utility.set_message_token('PAY_BASIS',

2384: hr_utility.set_message(8301, 'GHR_38262_NO_CALC_PAY_BASIS');
2385: -- It could be either the position pay basis or the retained pay basis as to why we couldn't
2386: -- calculate
2387: IF p_pay_calc_data.pay_basis NOT IN ('PA','PH','BW') THEN
2388: hr_utility.set_message_token('PAY_BASIS',
2389: ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_PAY_BASIS'
2390: ,p_pay_calc_data.pay_basis));
2391: ELSE
2392: hr_utility.set_message_token('PAY_BASIS',

Line 2392: hr_utility.set_message_token('PAY_BASIS',

2388: hr_utility.set_message_token('PAY_BASIS',
2389: ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_PAY_BASIS'
2390: ,p_pay_calc_data.pay_basis));
2391: ELSE
2392: hr_utility.set_message_token('PAY_BASIS',
2393: ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_PAY_BASIS'
2394: ,l_pay_basis));
2395: END IF;
2396: raise ghr_pay_calc.unable_to_calculate;

Line 2399: hr_utility.set_message(8301, 'GHR_38263_NO_CALC_DUAL_ACTION');

2395: END IF;
2396: raise ghr_pay_calc.unable_to_calculate;
2397: END IF;
2398: ELSE
2399: hr_utility.set_message(8301, 'GHR_38263_NO_CALC_DUAL_ACTION');
2400: raise ghr_pay_calc.unable_to_calculate;
2401: END IF;
2402: END IF;
2403:

Line 2412: hr_utility.set_location('Leaving ' || l_proc,8);

2408: p_pay_calc_out_data := NULL;
2409: p_retained_grade := l_retained_grade;
2410:
2411: RAISE;
2412: hr_utility.set_location('Leaving ' || l_proc,8);
2413: END get_basic_pay;
2414:
2415: -- Bug#5114467 Calling proc for Calculating basic pay, locality rate and
2416: -- adjusted basic pay for employee in 'GM' pay plan and NOA 894 AC