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.

[Home] [Help]

APPS.PER_SALADMIN_UTILITY dependencies on HR_UTILITY

Line 5: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY PER_SALADMIN_UTILITY AS
2: /* $Header: pesalutl.pkb 120.25.12010000.2 2008/11/07 07:00:46 schowdhu ship $ */
3:
4: g_package Varchar2(30) := 'per_saladmin_utility.';
5: g_debug boolean := hr_utility.debug_enabled;
6:
7: function Check_GSP_Manual_Override (p_assignment_id in NUMBER, p_effective_date in DATE) RETURN VARCHAR2 is
8: Cursor Grade_Ladder Is
9: Select Nvl(Gsp_Allow_Override_Flag,'Y')

Line 181: hr_utility.set_message(801,'HR_51258_PYP_INVAL_FREQ_PERIOD');

177: elsif
178: (p_frequency = 'D') then
179: l_num_days := p_period;
180: else
181: hr_utility.set_message(801,'HR_51258_PYP_INVAL_FREQ_PERIOD');
182: hr_utility.raise_error;
183: end if;
184: --
185: -- Now return the derived date

Line 182: hr_utility.raise_error;

178: (p_frequency = 'D') then
179: l_num_days := p_period;
180: else
181: hr_utility.set_message(801,'HR_51258_PYP_INVAL_FREQ_PERIOD');
182: hr_utility.raise_error;
183: end if;
184: --
185: -- Now return the derived date
186: --

Line 359: hr_utility.trace('In per_saladmin_utility.adjust_pay_proposals');

355:
356: begin
357:
358: if g_debug then
359: hr_utility.trace('In per_saladmin_utility.adjust_pay_proposals');
360: end if;
361: for i in csr_pay_proposals loop
362: ---vkodedal fix -5941519
363: l_element_entry_end_date:=null;

Line 365: hr_utility.set_location('Proposal Id'||i.pay_proposal_id, 66);

361: for i in csr_pay_proposals loop
362: ---vkodedal fix -5941519
363: l_element_entry_end_date:=null;
364: if g_debug then
365: hr_utility.set_location('Proposal Id'||i.pay_proposal_id, 66);
366: hr_utility.set_location('Change Date'||i.change_date, 66);
367: hr_utility.set_location('Date to'||i.date_to, 67);
368: end if;
369:

Line 366: hr_utility.set_location('Change Date'||i.change_date, 66);

362: ---vkodedal fix -5941519
363: l_element_entry_end_date:=null;
364: if g_debug then
365: hr_utility.set_location('Proposal Id'||i.pay_proposal_id, 66);
366: hr_utility.set_location('Change Date'||i.change_date, 66);
367: hr_utility.set_location('Date to'||i.date_to, 67);
368: end if;
369:
370: OPEN element_entry_end_date(i.pay_proposal_id,i.change_date);

Line 367: hr_utility.set_location('Date to'||i.date_to, 67);

363: l_element_entry_end_date:=null;
364: if g_debug then
365: hr_utility.set_location('Proposal Id'||i.pay_proposal_id, 66);
366: hr_utility.set_location('Change Date'||i.change_date, 66);
367: hr_utility.set_location('Date to'||i.date_to, 67);
368: end if;
369:
370: OPEN element_entry_end_date(i.pay_proposal_id,i.change_date);
371: FETCH element_entry_end_date into l_element_entry_end_date;

Line 375: hr_utility.set_location('End Date'||l_element_entry_end_date, 70);

371: FETCH element_entry_end_date into l_element_entry_end_date;
372: CLOSE element_entry_end_date;
373:
374: if g_debug then
375: hr_utility.set_location('End Date'||l_element_entry_end_date, 70);
376: end if;
377:
378: if l_element_entry_end_date is not null and l_element_entry_end_date <> i.date_to then
379: if g_debug then

Line 380: hr_utility.set_location('End Date and date_to are not matching', 70);

376: end if;
377:
378: if l_element_entry_end_date is not null and l_element_entry_end_date <> i.date_to then
379: if g_debug then
380: hr_utility.set_location('End Date and date_to are not matching', 70);
381: end if;
382:
383: OPEN csr_next_change_date(i.change_date);
384: FETCH csr_next_change_date into l_next_change_date;

Line 406: hr_utility.set_location('About to update', 70);

402:
403: end if;
404:
405: if g_debug then
406: hr_utility.set_location('About to update', 70);
407: end if;
408:
409: update per_pay_proposals
410: set date_to =l_element_entry_end_date

Line 414: hr_utility.set_location('Updated successfully', 70);

410: set date_to =l_element_entry_end_date
411: where pay_proposal_id = i.pay_proposal_id;
412:
413: if g_debug then
414: hr_utility.set_location('Updated successfully', 70);
415: end if;
416:
417:
418: END IF;

Line 424: hr_utility.trace('OUT per_saladmin_utility.adjust_pay_proposals');

420:
421: end loop;
422:
423: if g_debug then
424: hr_utility.trace('OUT per_saladmin_utility.adjust_pay_proposals');
425: end if;
426:
427: end adjust_pay_proposals;
428:

Line 1062: hr_utility.set_location('Entering PER_SALADMIN_UTILITY.get_sal_on_basis_chg',10);

1058: and prl.period_type = tpt.period_type(+);
1059: --
1060: begin
1061: --
1062: hr_utility.set_location('Entering PER_SALADMIN_UTILITY.get_sal_on_basis_chg',10);
1063: --
1064: l_change:=null;
1065: l_new:=null;
1066: l_comps:='N'; --:REVIEW.MULTIPLE_COMPONENTS;

Line 1071: hr_utility.set_location('p_old_pay_basis_id ='||to_char(p_old_pay_basis_id),11);

1067: l_percent:= 0;
1068: --
1069: -- Fetch the details of the old pay proposal
1070: --
1071: hr_utility.set_location('p_old_pay_basis_id ='||to_char(p_old_pay_basis_id),11);
1072: hr_utility.set_location('p_new_pay_basis_id ='||to_char(p_new_pay_basis_id),11);
1073: --
1074: open get_prop_det(p_assignment_id,p_old_pay_basis_id);
1075: fetch get_prop_det into l_rec;

Line 1072: hr_utility.set_location('p_new_pay_basis_id ='||to_char(p_new_pay_basis_id),11);

1068: --
1069: -- Fetch the details of the old pay proposal
1070: --
1071: hr_utility.set_location('p_old_pay_basis_id ='||to_char(p_old_pay_basis_id),11);
1072: hr_utility.set_location('p_new_pay_basis_id ='||to_char(p_new_pay_basis_id),11);
1073: --
1074: open get_prop_det(p_assignment_id,p_old_pay_basis_id);
1075: fetch get_prop_det into l_rec;
1076: close get_prop_det;

Line 1087: hr_utility.set_location('Prev change date= '||to_char(l_prev_change_date,'dd/mm/yyyy'),12);

1083: --
1084: l_prev_change_date := l_rec.change_date +1;
1085: l_prev_salary := l_rec.proposed_salary_n;
1086: --
1087: hr_utility.set_location('Prev change date= '||to_char(l_prev_change_date,'dd/mm/yyyy'),12);
1088: hr_utility.set_location('l_prev_salary = '||to_char(l_prev_salary),13);
1089: --
1090: --Calculate the currency and pay_annualization_factor of the old salary basis
1091: --

Line 1088: hr_utility.set_location('l_prev_salary = '||to_char(l_prev_salary),13);

1084: l_prev_change_date := l_rec.change_date +1;
1085: l_prev_salary := l_rec.proposed_salary_n;
1086: --
1087: hr_utility.set_location('Prev change date= '||to_char(l_prev_change_date,'dd/mm/yyyy'),12);
1088: hr_utility.set_location('l_prev_salary = '||to_char(l_prev_salary),13);
1089: --
1090: --Calculate the currency and pay_annualization_factor of the old salary basis
1091: --
1092: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS

Line 1104: hr_utility.set_location('l_old_currency = '||l_old_currency,13);

1100: ,p_grade_basis => l_grade
1101: ,p_grade_annualization_factor => l_grade_annualization_factor
1102: ,p_element_type_id => l_element_entry_id
1103: ,p_uom => l_uom);
1104: hr_utility.set_location('l_old_currency = '||l_old_currency,13);
1105: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1106: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1107: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1108: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);

Line 1105: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);

1101: ,p_grade_annualization_factor => l_grade_annualization_factor
1102: ,p_element_type_id => l_element_entry_id
1103: ,p_uom => l_uom);
1104: hr_utility.set_location('l_old_currency = '||l_old_currency,13);
1105: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1106: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1107: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1108: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1109: hr_utility.set_location('l_grade = '||l_grade,13);

Line 1106: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);

1102: ,p_element_type_id => l_element_entry_id
1103: ,p_uom => l_uom);
1104: hr_utility.set_location('l_old_currency = '||l_old_currency,13);
1105: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1106: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1107: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1108: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1109: hr_utility.set_location('l_grade = '||l_grade,13);
1110: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);

Line 1107: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);

1103: ,p_uom => l_uom);
1104: hr_utility.set_location('l_old_currency = '||l_old_currency,13);
1105: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1106: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1107: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1108: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1109: hr_utility.set_location('l_grade = '||l_grade,13);
1110: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1111: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);

Line 1108: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);

1104: hr_utility.set_location('l_old_currency = '||l_old_currency,13);
1105: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1106: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1107: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1108: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1109: hr_utility.set_location('l_grade = '||l_grade,13);
1110: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1111: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1112: hr_utility.set_location('l_uom = '||l_uom,13);

Line 1109: hr_utility.set_location('l_grade = '||l_grade,13);

1105: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1106: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1107: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1108: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1109: hr_utility.set_location('l_grade = '||l_grade,13);
1110: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1111: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1112: hr_utility.set_location('l_uom = '||l_uom,13);
1113: --

Line 1110: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);

1106: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1107: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1108: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1109: hr_utility.set_location('l_grade = '||l_grade,13);
1110: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1111: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1112: hr_utility.set_location('l_uom = '||l_uom,13);
1113: --
1114: --

Line 1111: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);

1107: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1108: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1109: hr_utility.set_location('l_grade = '||l_grade,13);
1110: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1111: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1112: hr_utility.set_location('l_uom = '||l_uom,13);
1113: --
1114: --
1115: --Calculate the currency and pay_annualization_factor of the new salary basis

Line 1112: hr_utility.set_location('l_uom = '||l_uom,13);

1108: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1109: hr_utility.set_location('l_grade = '||l_grade,13);
1110: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1111: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1112: hr_utility.set_location('l_uom = '||l_uom,13);
1113: --
1114: --
1115: --Calculate the currency and pay_annualization_factor of the new salary basis
1116: --

Line 1121: hr_utility.set_location('l_new_currency = '||l_new_currency,13);

1117: Open csr_new_pb_details(p_new_pay_basis_id);
1118: Fetch csr_new_pb_details into l_new_currency,l_pay_basis,l_new_pay_annual_factor,l_new_uom;
1119: Close csr_new_pb_details;
1120: --
1121: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1122: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1123: hr_utility.set_location('l_new_pay_annual_factor = '||to_char(l_new_pay_annual_factor),13);
1124: --
1125: if(l_pay_basis ='PERIOD' and l_new_pay_annual_factor is null) then

Line 1122: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);

1118: Fetch csr_new_pb_details into l_new_currency,l_pay_basis,l_new_pay_annual_factor,l_new_uom;
1119: Close csr_new_pb_details;
1120: --
1121: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1122: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1123: hr_utility.set_location('l_new_pay_annual_factor = '||to_char(l_new_pay_annual_factor),13);
1124: --
1125: if(l_pay_basis ='PERIOD' and l_new_pay_annual_factor is null) then
1126: --

Line 1123: hr_utility.set_location('l_new_pay_annual_factor = '||to_char(l_new_pay_annual_factor),13);

1119: Close csr_new_pb_details;
1120: --
1121: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1122: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1123: hr_utility.set_location('l_new_pay_annual_factor = '||to_char(l_new_pay_annual_factor),13);
1124: --
1125: if(l_pay_basis ='PERIOD' and l_new_pay_annual_factor is null) then
1126: --
1127: hr_utility.set_location('Fetching Payroll frequency',13);

Line 1127: hr_utility.set_location('Fetching Payroll frequency',13);

1123: hr_utility.set_location('l_new_pay_annual_factor = '||to_char(l_new_pay_annual_factor),13);
1124: --
1125: if(l_pay_basis ='PERIOD' and l_new_pay_annual_factor is null) then
1126: --
1127: hr_utility.set_location('Fetching Payroll frequency',13);
1128: --
1129: l_new_pay_annual_factor := 1;
1130: --
1131: open csr_payroll_freq;

Line 1136: hr_utility.set_location('l_new_pay_annual_factor = '||to_char(l_new_pay_annual_factor),13);

1132: Fetch csr_payroll_freq into l_new_pay_annual_factor;
1133: Close csr_payroll_freq;
1134: end if;
1135: --
1136: hr_utility.set_location('l_new_pay_annual_factor = '||to_char(l_new_pay_annual_factor),13);
1137: /**
1138: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS
1139: (p_effective_date => p_effective_date
1140: ,p_assignment_id => p_assignment_id

Line 1150: hr_utility.set_location('l_new_currency = '||l_new_currency,13);

1146: ,p_grade_basis => l_grade
1147: ,p_grade_annualization_factor => l_grade_annualization_factor
1148: ,p_element_type_id => l_element_entry_id
1149: ,p_uom => l_uom);
1150: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1151: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1152: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1153: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1154: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);

Line 1151: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);

1147: ,p_grade_annualization_factor => l_grade_annualization_factor
1148: ,p_element_type_id => l_element_entry_id
1149: ,p_uom => l_uom);
1150: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1151: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1152: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1153: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1154: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1155: hr_utility.set_location('l_grade = '||l_grade,13);

Line 1152: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);

1148: ,p_element_type_id => l_element_entry_id
1149: ,p_uom => l_uom);
1150: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1151: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1152: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1153: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1154: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1155: hr_utility.set_location('l_grade = '||l_grade,13);
1156: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);

Line 1153: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);

1149: ,p_uom => l_uom);
1150: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1151: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1152: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1153: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1154: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1155: hr_utility.set_location('l_grade = '||l_grade,13);
1156: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1157: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);

Line 1154: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);

1150: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1151: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1152: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1153: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1154: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1155: hr_utility.set_location('l_grade = '||l_grade,13);
1156: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1157: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1158: hr_utility.set_location('l_uom = '||l_uom,13);

Line 1155: hr_utility.set_location('l_grade = '||l_grade,13);

1151: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1152: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1153: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1154: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1155: hr_utility.set_location('l_grade = '||l_grade,13);
1156: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1157: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1158: hr_utility.set_location('l_uom = '||l_uom,13);
1159: **/

Line 1156: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);

1152: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1153: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1154: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1155: hr_utility.set_location('l_grade = '||l_grade,13);
1156: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1157: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1158: hr_utility.set_location('l_uom = '||l_uom,13);
1159: **/
1160: --

Line 1157: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);

1153: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1154: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1155: hr_utility.set_location('l_grade = '||l_grade,13);
1156: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1157: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1158: hr_utility.set_location('l_uom = '||l_uom,13);
1159: **/
1160: --
1161: --

Line 1158: hr_utility.set_location('l_uom = '||l_uom,13);

1154: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1155: hr_utility.set_location('l_grade = '||l_grade,13);
1156: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1157: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1158: hr_utility.set_location('l_uom = '||l_uom,13);
1159: **/
1160: --
1161: --
1162: -- Calculate Old Annual amt and New Salary

Line 1177: hr_utility.set_location('l_prev_annual_salary = '||to_char(l_prev_annual_salary),14);

1173:
1174: l_prev_annual_salary := l_prev_salary * l_old_pay_annualization_factor;
1175: l_new := (l_prev_salary * l_old_pay_annualization_factor)/l_new_pay_annual_factor;
1176: --
1177: hr_utility.set_location('l_prev_annual_salary = '||to_char(l_prev_annual_salary),14);
1178: hr_utility.set_location('l_new = '||to_char(l_new),15);
1179: --
1180: -- If there is a new salary value and currencies of the old and new salary basis do not match, do a
1181: -- currency conversion of the new value.

Line 1178: hr_utility.set_location('l_new = '||to_char(l_new),15);

1174: l_prev_annual_salary := l_prev_salary * l_old_pay_annualization_factor;
1175: l_new := (l_prev_salary * l_old_pay_annualization_factor)/l_new_pay_annual_factor;
1176: --
1177: hr_utility.set_location('l_prev_annual_salary = '||to_char(l_prev_annual_salary),14);
1178: hr_utility.set_location('l_new = '||to_char(l_new),15);
1179: --
1180: -- If there is a new salary value and currencies of the old and new salary basis do not match, do a
1181: -- currency conversion of the new value.
1182: --

Line 1198: hr_utility.set_location('Currency rate = '||to_char(l_currency_rate),16);

1194: End if;
1195: --
1196: End if;
1197: --
1198: hr_utility.set_location('Currency rate = '||to_char(l_currency_rate),16);
1199: l_new := l_currency_rate * l_new;
1200: hr_utility.set_location('Converted rate = '||to_char(l_new),20);
1201: --
1202: --

Line 1200: hr_utility.set_location('Converted rate = '||to_char(l_new),20);

1196: End if;
1197: --
1198: hr_utility.set_location('Currency rate = '||to_char(l_currency_rate),16);
1199: l_new := l_currency_rate * l_new;
1200: hr_utility.set_location('Converted rate = '||to_char(l_new),20);
1201: --
1202: --
1203: if l_new_uom is null then
1204: l_new_uom := 'M';

Line 1223: hr_utility.set_location('proposal_reason set to null', 25);

1219: ,p_lookup_type => 'PROPOSAL_REASON'
1220: ,p_lookup_code => 'SALBASISCHG'
1221: ) then
1222: -- proposal_reason doesn't exist - set the reason to null
1223: hr_utility.set_location('proposal_reason set to null', 25);
1224: l_rec.proposal_reason :=null;
1225: else
1226: hr_utility.set_location('proposal_reason set to SALBASISCHG', 27);
1227: l_rec.proposal_reason := 'SALBASISCHG';

Line 1226: hr_utility.set_location('proposal_reason set to SALBASISCHG', 27);

1222: -- proposal_reason doesn't exist - set the reason to null
1223: hr_utility.set_location('proposal_reason set to null', 25);
1224: l_rec.proposal_reason :=null;
1225: else
1226: hr_utility.set_location('proposal_reason set to SALBASISCHG', 27);
1227: l_rec.proposal_reason := 'SALBASISCHG';
1228:
1229: end if;
1230:

Line 1238: hr_utility.set_location('Leaving PER_SALADMIN_UTILITY.get_sal_on_basis_chg ',100);

1234: g_new_sal_value := l_new;
1235: --
1236: End if;
1237: --
1238: hr_utility.set_location('Leaving PER_SALADMIN_UTILITY.get_sal_on_basis_chg ',100);
1239: --
1240: EXCEPTION
1241: WHEN others THEN
1242: --

Line 1243: hr_utility.set_location('Exception: PER_SALADMIN_UTILITY.get_sal_on_basis_chg',100);

1239: --
1240: EXCEPTION
1241: WHEN others THEN
1242: --
1243: hr_utility.set_location('Exception: PER_SALADMIN_UTILITY.get_sal_on_basis_chg',100);
1244: g_proposal_rec := null;
1245: g_new_sal_value := null;
1246: raise;
1247: --

Line 1317: hr_utility.set_location('Exception: PER_SALADMIN_UTILITY.insert_pay_proposal',100);

1313: g_new_sal_value := null;
1314:
1315: EXCEPTION
1316: WHEN others THEN
1317: hr_utility.set_location('Exception: PER_SALADMIN_UTILITY.insert_pay_proposal',100);
1318: g_proposal_rec := null;
1319: g_new_sal_value := null;
1320: raise;
1321: end;