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.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.41.12020000.3 2012/11/08 06:42:55 vsripera 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 363: hr_utility.trace('In per_saladmin_utility.adjust_pay_proposals');

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

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

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

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

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

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

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

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

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

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

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

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

406:
407: end if;
408:
409: if g_debug then
410: hr_utility.set_location('About to update', 70);
411: end if;
412:
413: update per_pay_proposals
414: set date_to =l_element_entry_end_date

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

414: set date_to =l_element_entry_end_date
415: where pay_proposal_id = i.pay_proposal_id;
416:
417: if g_debug then
418: hr_utility.set_location('Updated successfully', 70);
419: end if;
420:
421:
422: END IF;

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

424:
425: end loop;
426:
427: if g_debug then
428: hr_utility.trace('OUT per_saladmin_utility.adjust_pay_proposals');
429: end if;
430:
431: end adjust_pay_proposals;
432:

Line 1064: hr_utility.set_location('Entering PER_SALADMIN_UTILITY.handle_asg_crit_change ',1);

1060:
1061: begin
1062:
1063: ---
1064: hr_utility.set_location('Entering PER_SALADMIN_UTILITY.handle_asg_crit_change ',1);
1065: --
1066: hr_utility.set_location('p_assignment_id ='||to_char(p_assignment_id),5);
1067: hr_utility.set_location('p_effective_date ='||p_effective_date,5);
1068: --get the element entry details that's created on p_effective_date

Line 1066: hr_utility.set_location('p_assignment_id ='||to_char(p_assignment_id),5);

1062:
1063: ---
1064: hr_utility.set_location('Entering PER_SALADMIN_UTILITY.handle_asg_crit_change ',1);
1065: --
1066: hr_utility.set_location('p_assignment_id ='||to_char(p_assignment_id),5);
1067: hr_utility.set_location('p_effective_date ='||p_effective_date,5);
1068: --get the element entry details that's created on p_effective_date
1069: --because of change in element link
1070: open csr_creator_id;

Line 1067: hr_utility.set_location('p_effective_date ='||p_effective_date,5);

1063: ---
1064: hr_utility.set_location('Entering PER_SALADMIN_UTILITY.handle_asg_crit_change ',1);
1065: --
1066: hr_utility.set_location('p_assignment_id ='||to_char(p_assignment_id),5);
1067: hr_utility.set_location('p_effective_date ='||p_effective_date,5);
1068: --get the element entry details that's created on p_effective_date
1069: --because of change in element link
1070: open csr_creator_id;
1071: fetch csr_creator_id into l_creator_id,l_date_to;

Line 1074: hr_utility.set_location('l_creator_id ='||to_char(l_creator_id),10);

1070: open csr_creator_id;
1071: fetch csr_creator_id into l_creator_id,l_date_to;
1072:
1073: IF csr_creator_id%FOUND then
1074: hr_utility.set_location('l_creator_id ='||to_char(l_creator_id),10);
1075: ---get prev pay proposal details
1076: open csr_pay_proposal(p_assignment_id,l_creator_id);
1077: fetch csr_pay_proposal into l_proposal_rec;
1078:

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

1085: ,p_lookup_type => 'PROPOSAL_REASON'
1086: ,p_lookup_code => 'SALBASISCHG'
1087: ) then
1088: --proposal_reason doesn't exist - set the reason to null
1089: hr_utility.set_location('proposal_reason set to null', 25);
1090: l_proposal_rec.proposal_reason :=null;
1091: else
1092: hr_utility.set_location('proposal_reason set to SALBASISCHG', 27);
1093: l_proposal_rec.proposal_reason := 'SALBASISCHG';

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

1088: --proposal_reason doesn't exist - set the reason to null
1089: hr_utility.set_location('proposal_reason set to null', 25);
1090: l_proposal_rec.proposal_reason :=null;
1091: else
1092: hr_utility.set_location('proposal_reason set to SALBASISCHG', 27);
1093: l_proposal_rec.proposal_reason := 'SALBASISCHG';
1094: end if;
1095: --end of code change for bug 12591075
1096:

Line 1098: hr_utility.set_location('Insert a new proposal:p_effective_date:'||p_effective_date,15);

1094: end if;
1095: --end of code change for bug 12591075
1096:
1097: ----insert a new proposal and update the creator id
1098: hr_utility.set_location('Insert a new proposal:p_effective_date:'||p_effective_date,15);
1099:
1100: hr_maintain_proposal_api.insert_salary_proposal
1101: (p_pay_proposal_id => l_pay_proposal_id
1102: ,p_assignment_id => p_assignment_id

Line 1203: hr_utility.set_location('Leaving PER_SALADMIN_UTILITY.handle_asg_crit_change ',100);

1199: close csr_creator_id;
1200:
1201: --
1202: --
1203: hr_utility.set_location('Leaving PER_SALADMIN_UTILITY.handle_asg_crit_change ',100);
1204: --
1205: EXCEPTION
1206: WHEN others THEN
1207: --

Line 1208: hr_utility.set_location('Exception: PER_SALADMIN_UTILITY.handle_asg_crit_change',120);

1204: --
1205: EXCEPTION
1206: WHEN others THEN
1207: --
1208: hr_utility.set_location('Exception: PER_SALADMIN_UTILITY.handle_asg_crit_change',120);
1209: raise;
1210: --
1211: end;
1212:

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

1283: and prl.period_type = tpt.period_type(+);
1284: --
1285: begin
1286: --
1287: hr_utility.set_location('Entering PER_SALADMIN_UTILITY.get_sal_on_basis_chg',10);
1288: --
1289: l_change:=null;
1290: l_new:=null;
1291: l_comps:='N'; --:REVIEW.MULTIPLE_COMPONENTS;

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

1292: l_percent:= 0;
1293: --
1294: -- Fetch the details of the old pay proposal
1295: --
1296: hr_utility.set_location('p_old_pay_basis_id ='||to_char(p_old_pay_basis_id),11);
1297: hr_utility.set_location('p_new_pay_basis_id ='||to_char(p_new_pay_basis_id),11);
1298: --
1299: open get_prop_det(p_assignment_id,p_old_pay_basis_id);
1300: fetch get_prop_det into l_rec;

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

1293: --
1294: -- Fetch the details of the old pay proposal
1295: --
1296: hr_utility.set_location('p_old_pay_basis_id ='||to_char(p_old_pay_basis_id),11);
1297: hr_utility.set_location('p_new_pay_basis_id ='||to_char(p_new_pay_basis_id),11);
1298: --
1299: open get_prop_det(p_assignment_id,p_old_pay_basis_id);
1300: fetch get_prop_det into l_rec;
1301: close get_prop_det;

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

1308: --
1309: l_prev_change_date := l_rec.change_date +1;
1310: l_prev_salary := l_rec.proposed_salary_n;
1311: --
1312: hr_utility.set_location('Prev change date= '||to_char(l_prev_change_date,'dd/mm/yyyy'),12);
1313: hr_utility.set_location('l_prev_salary = '||to_char(l_prev_salary),13);
1314: --
1315: --Calculate the currency and pay_annualization_factor of the old salary basis
1316: --

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

1309: l_prev_change_date := l_rec.change_date +1;
1310: l_prev_salary := l_rec.proposed_salary_n;
1311: --
1312: hr_utility.set_location('Prev change date= '||to_char(l_prev_change_date,'dd/mm/yyyy'),12);
1313: hr_utility.set_location('l_prev_salary = '||to_char(l_prev_salary),13);
1314: --
1315: --Calculate the currency and pay_annualization_factor of the old salary basis
1316: --
1317: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS

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

1325: ,p_grade_basis => l_grade
1326: ,p_grade_annualization_factor => l_grade_annualization_factor
1327: ,p_element_type_id => l_element_entry_id
1328: ,p_uom => l_uom);
1329: hr_utility.set_location('l_old_currency = '||l_old_currency,13);
1330: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1331: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1332: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1333: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);

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

1326: ,p_grade_annualization_factor => l_grade_annualization_factor
1327: ,p_element_type_id => l_element_entry_id
1328: ,p_uom => l_uom);
1329: hr_utility.set_location('l_old_currency = '||l_old_currency,13);
1330: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1331: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1332: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1333: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1334: hr_utility.set_location('l_grade = '||l_grade,13);

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

1327: ,p_element_type_id => l_element_entry_id
1328: ,p_uom => l_uom);
1329: hr_utility.set_location('l_old_currency = '||l_old_currency,13);
1330: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1331: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1332: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1333: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1334: hr_utility.set_location('l_grade = '||l_grade,13);
1335: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);

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

1328: ,p_uom => l_uom);
1329: hr_utility.set_location('l_old_currency = '||l_old_currency,13);
1330: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1331: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1332: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1333: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1334: hr_utility.set_location('l_grade = '||l_grade,13);
1335: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1336: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);

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

1329: hr_utility.set_location('l_old_currency = '||l_old_currency,13);
1330: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1331: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1332: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1333: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1334: hr_utility.set_location('l_grade = '||l_grade,13);
1335: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1336: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1337: hr_utility.set_location('l_uom = '||l_uom,13);

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

1330: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1331: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1332: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1333: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1334: hr_utility.set_location('l_grade = '||l_grade,13);
1335: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1336: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1337: hr_utility.set_location('l_uom = '||l_uom,13);
1338: --

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

1331: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1332: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1333: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1334: hr_utility.set_location('l_grade = '||l_grade,13);
1335: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1336: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1337: hr_utility.set_location('l_uom = '||l_uom,13);
1338: --
1339: --

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

1332: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1333: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1334: hr_utility.set_location('l_grade = '||l_grade,13);
1335: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1336: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1337: hr_utility.set_location('l_uom = '||l_uom,13);
1338: --
1339: --
1340: --Calculate the currency and pay_annualization_factor of the new salary basis

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

1333: hr_utility.set_location('l_old_pay_annualization_factor = '||to_char(l_old_pay_annualization_factor),13);
1334: hr_utility.set_location('l_grade = '||l_grade,13);
1335: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1336: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1337: hr_utility.set_location('l_uom = '||l_uom,13);
1338: --
1339: --
1340: --Calculate the currency and pay_annualization_factor of the new salary basis
1341: --

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

1342: Open csr_new_pb_details(p_new_pay_basis_id);
1343: Fetch csr_new_pb_details into l_new_currency,l_pay_basis,l_new_pay_annual_factor,l_new_uom;
1344: Close csr_new_pb_details;
1345: --
1346: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1347: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1348: hr_utility.set_location('l_new_pay_annual_factor = '||to_char(l_new_pay_annual_factor),13);
1349: --
1350: if(l_pay_basis ='PERIOD' and l_new_pay_annual_factor is null) then

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

1343: Fetch csr_new_pb_details into l_new_currency,l_pay_basis,l_new_pay_annual_factor,l_new_uom;
1344: Close csr_new_pb_details;
1345: --
1346: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1347: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1348: hr_utility.set_location('l_new_pay_annual_factor = '||to_char(l_new_pay_annual_factor),13);
1349: --
1350: if(l_pay_basis ='PERIOD' and l_new_pay_annual_factor is null) then
1351: --

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

1344: Close csr_new_pb_details;
1345: --
1346: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1347: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1348: hr_utility.set_location('l_new_pay_annual_factor = '||to_char(l_new_pay_annual_factor),13);
1349: --
1350: if(l_pay_basis ='PERIOD' and l_new_pay_annual_factor is null) then
1351: --
1352: hr_utility.set_location('Fetching Payroll frequency',13);

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

1348: hr_utility.set_location('l_new_pay_annual_factor = '||to_char(l_new_pay_annual_factor),13);
1349: --
1350: if(l_pay_basis ='PERIOD' and l_new_pay_annual_factor is null) then
1351: --
1352: hr_utility.set_location('Fetching Payroll frequency',13);
1353: --
1354: l_new_pay_annual_factor := 1;
1355: --
1356: open csr_payroll_freq;

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

1357: Fetch csr_payroll_freq into l_new_pay_annual_factor;
1358: Close csr_payroll_freq;
1359: end if;
1360: --
1361: hr_utility.set_location('l_new_pay_annual_factor = '||to_char(l_new_pay_annual_factor),13);
1362: /**
1363: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS
1364: (p_effective_date => p_effective_date
1365: ,p_assignment_id => p_assignment_id

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

1371: ,p_grade_basis => l_grade
1372: ,p_grade_annualization_factor => l_grade_annualization_factor
1373: ,p_element_type_id => l_element_entry_id
1374: ,p_uom => l_uom);
1375: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1376: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1377: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1378: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1379: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);

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

1372: ,p_grade_annualization_factor => l_grade_annualization_factor
1373: ,p_element_type_id => l_element_entry_id
1374: ,p_uom => l_uom);
1375: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1376: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1377: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1378: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1379: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1380: hr_utility.set_location('l_grade = '||l_grade,13);

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

1373: ,p_element_type_id => l_element_entry_id
1374: ,p_uom => l_uom);
1375: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1376: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1377: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1378: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1379: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1380: hr_utility.set_location('l_grade = '||l_grade,13);
1381: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);

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

1374: ,p_uom => l_uom);
1375: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1376: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1377: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1378: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1379: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1380: hr_utility.set_location('l_grade = '||l_grade,13);
1381: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1382: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);

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

1375: hr_utility.set_location('l_new_currency = '||l_new_currency,13);
1376: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1377: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1378: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1379: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1380: hr_utility.set_location('l_grade = '||l_grade,13);
1381: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1382: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1383: hr_utility.set_location('l_uom = '||l_uom,13);

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

1376: hr_utility.set_location('l_salary_basis_name = '||l_salary_basis_name,13);
1377: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1378: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1379: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1380: hr_utility.set_location('l_grade = '||l_grade,13);
1381: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1382: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1383: hr_utility.set_location('l_uom = '||l_uom,13);
1384: **/

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

1377: hr_utility.set_location('l_pay_basis_name = '||l_pay_basis_name,13);
1378: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1379: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1380: hr_utility.set_location('l_grade = '||l_grade,13);
1381: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1382: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1383: hr_utility.set_location('l_uom = '||l_uom,13);
1384: **/
1385: --

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

1378: hr_utility.set_location('l_pay_basis = '||l_pay_basis,13);
1379: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1380: hr_utility.set_location('l_grade = '||l_grade,13);
1381: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1382: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1383: hr_utility.set_location('l_uom = '||l_uom,13);
1384: **/
1385: --
1386: --

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

1379: hr_utility.set_location('l_new_pay_annualization_factor = '||to_char(l_new_pay_annualization_factor),13);
1380: hr_utility.set_location('l_grade = '||l_grade,13);
1381: hr_utility.set_location('l_grade_annualization_factor = '||to_char(l_grade_annualization_factor),13);
1382: hr_utility.set_location('l_element_entry_id = '||to_char(l_element_entry_id),13);
1383: hr_utility.set_location('l_uom = '||l_uom,13);
1384: **/
1385: --
1386: --
1387: -- Calculate Old Annual amt and New Salary

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

1398:
1399: l_prev_annual_salary := l_prev_salary * l_old_pay_annualization_factor;
1400: l_new := (l_prev_salary * l_old_pay_annualization_factor)/l_new_pay_annual_factor;
1401: --
1402: hr_utility.set_location('l_prev_annual_salary = '||to_char(l_prev_annual_salary),14);
1403: hr_utility.set_location('l_new = '||to_char(l_new),15);
1404: --
1405: -- If there is a new salary value and currencies of the old and new salary basis do not match, do a
1406: -- currency conversion of the new value.

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

1399: l_prev_annual_salary := l_prev_salary * l_old_pay_annualization_factor;
1400: l_new := (l_prev_salary * l_old_pay_annualization_factor)/l_new_pay_annual_factor;
1401: --
1402: hr_utility.set_location('l_prev_annual_salary = '||to_char(l_prev_annual_salary),14);
1403: hr_utility.set_location('l_new = '||to_char(l_new),15);
1404: --
1405: -- If there is a new salary value and currencies of the old and new salary basis do not match, do a
1406: -- currency conversion of the new value.
1407: --

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

1419: End if;
1420: --
1421: End if;
1422: --
1423: hr_utility.set_location('Currency rate = '||to_char(l_currency_rate),16);
1424: l_new := l_currency_rate * l_new;
1425: hr_utility.set_location('Converted rate = '||to_char(l_new),20);
1426: --
1427: --

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

1421: End if;
1422: --
1423: hr_utility.set_location('Currency rate = '||to_char(l_currency_rate),16);
1424: l_new := l_currency_rate * l_new;
1425: hr_utility.set_location('Converted rate = '||to_char(l_new),20);
1426: --
1427: --
1428: if l_new_uom is null then
1429: l_new_uom := 'M';

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

1444: ,p_lookup_type => 'PROPOSAL_REASON'
1445: ,p_lookup_code => 'SALBASISCHG'
1446: ) then
1447: -- proposal_reason doesn't exist - set the reason to null
1448: hr_utility.set_location('proposal_reason set to null', 25);
1449: l_rec.proposal_reason :=null;
1450: else
1451: hr_utility.set_location('proposal_reason set to SALBASISCHG', 27);
1452: l_rec.proposal_reason := 'SALBASISCHG';

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

1447: -- proposal_reason doesn't exist - set the reason to null
1448: hr_utility.set_location('proposal_reason set to null', 25);
1449: l_rec.proposal_reason :=null;
1450: else
1451: hr_utility.set_location('proposal_reason set to SALBASISCHG', 27);
1452: l_rec.proposal_reason := 'SALBASISCHG';
1453:
1454: end if;
1455:

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

1459: g_new_sal_value := l_new;
1460: --
1461: End if;
1462: --
1463: hr_utility.set_location('Leaving PER_SALADMIN_UTILITY.get_sal_on_basis_chg ',100);
1464: --
1465: EXCEPTION
1466: WHEN others THEN
1467: --

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

1464: --
1465: EXCEPTION
1466: WHEN others THEN
1467: --
1468: hr_utility.set_location('Exception: PER_SALADMIN_UTILITY.get_sal_on_basis_chg',100);
1469: g_proposal_rec := null;
1470: g_new_sal_value := null;
1471: raise;
1472: --

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

1538: g_new_sal_value := null;
1539:
1540: EXCEPTION
1541: WHEN others THEN
1542: hr_utility.set_location('Exception: PER_SALADMIN_UTILITY.insert_pay_proposal',100);
1543: g_proposal_rec := null;
1544: g_new_sal_value := null;
1545: raise;
1546: end;