eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_EMPLOYEE_SALARY dependencies on HR_UTILITY

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

102:
103: Begin
104: --
105: l_proc := 'get_employee_salary';
106: hr_utility.set_location('Entering:'||l_proc, 5);
107: --
108: --
109: -- Step 1. Fetch Assignment Details
110: --

Line 122: hr_utility.set_location('Assignment has Salary Basis', 110);

118: p_pay_basis_frequency := null;
119: If l_pay_basis_id IS NOT NULL then
120: --
121: --
122: hr_utility.set_location('Assignment has Salary Basis', 110);
123: --
124: Open Pay_Bases_Element;
125: Fetch Pay_Bases_Element into l_input_Value_id, l_basis_Annl_fctr, p_pay_basis_frequency;
126: Close Pay_Bases_Element;

Line 147: hr_utility.set_location('Get currency from grade ladder', 120);

143: --
144: -- Get grade ladder currency
145: --
146: --
147: hr_utility.set_location('Get currency from grade ladder', 120);
148: --
149: Open GrdLdr_Element;
150: Fetch GrdLdr_Element into l_dummy_iv_id;
151: Close GrdLdr_Element;

Line 159: hr_utility.set_location('Get currency from business group', 130);

155: -- Assignment is on salary basis but not on a GL.
156: -- Get currency from BG ?
157: --
158: --
159: hr_utility.set_location('Get currency from business group', 130);
160: --
161: p_currency := hr_general.DEFAULT_CURRENCY_CODE(p_business_group_id => l_business_group_id);
162: --
163: End if;

Line 177: hr_utility.set_location('Fetch Grade Ladder Element', 140);

173: --
174: If l_pgm_id is NOT NULL then
175: --
176: --
177: hr_utility.set_location('Fetch Grade Ladder Element', 140);
178: --
179: Open GrdLdr_Element;
180: Fetch GrdLdr_Element into l_input_Value_id;
181: Close GrdLdr_Element;

Line 188: hr_utility.set_location('No Salary basis and No Grade Ladder', 150);

184: --
185: -- p_status = 3 : No Salary basis and No Grade Ladder Element.
186: --
187: --
188: hr_utility.set_location('No Salary basis and No Grade Ladder', 150);
189: --
190: p_status := 3;
191: p_salary := 0;
192: p_annual_salary := 0;

Line 219: hr_utility.set_location('Computing annual salary for assignment.', 160);

215: --
216: If l_payroll_id IS NOT NULL then
217: --
218: --
219: hr_utility.set_location('Computing annual salary for assignment.', 160);
220:
221: --
222: Open csr_ann_sal(nvl(p_salary,0),l_payroll_id);
223: Fetch csr_ann_sal into p_frequency, p_annual_salary;

Line 244: hr_utility.set_location('Null Payroll for assignment.', 170);

240: --
241: -- p_status = 2 : No Payroll for assignment.
242: --
243: --
244: hr_utility.set_location('Null Payroll for assignment.', 170);
245: --
246: p_status := 2;
247: p_annual_salary := p_salary;
248:

Line 257: hr_utility.set_location('Null Input Value Id', 180);

253: --
254: -- p_status = 3 : No Salary basis and No Grade Ladder Element.
255: --
256: --
257: hr_utility.set_location('Null Input Value Id', 180);
258: --
259: p_status := 3;
260: p_salary := 0;
261: p_annual_salary := 0;

Line 271: hr_utility.set_location('Invalid Assignment id', 190);

267: --
268: p_status := -1;
269: --
270: --
271: hr_utility.set_location('Invalid Assignment id', 190);
272: --
273: End if;
274: p_annual_salary := trunc(p_annual_salary,l_precision);
275: Close csr_asg_details;

Line 278: hr_utility.set_location('Leaving:'||l_proc, 10);

274: p_annual_salary := trunc(p_annual_salary,l_precision);
275: Close csr_asg_details;
276: --
277: --
278: hr_utility.set_location('Leaving:'||l_proc, 10);
279: --
280: Exception When others then
281: --
282: hr_utility.set_location('Exception:'||l_proc, 200);

Line 282: hr_utility.set_location('Exception:'||l_proc, 200);

278: hr_utility.set_location('Leaving:'||l_proc, 10);
279: --
280: Exception When others then
281: --
282: hr_utility.set_location('Exception:'||l_proc, 200);
283: raise;
284: --
285: End get_employee_salary;
286: --

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

306: --
307: Begin
308: --
309: l_proc := 'check_grade_ladder_exists';
310: hr_utility.set_location('Entering:'||l_proc, 5);
311: --
312: Open csr_gsp;
313: Fetch csr_gsp into l_dummy;
314: If csr_gsp%notfound then

Line 316: hr_utility.set_location('No grade ladder', 7);

312: Open csr_gsp;
313: Fetch csr_gsp into l_dummy;
314: If csr_gsp%notfound then
315: p_grd_ldr_exists_flag := false;
316: hr_utility.set_location('No grade ladder', 7);
317: End if;
318: close csr_gsp;
319: --
320: p_grd_ldr_exists_flag := true;

Line 321: hr_utility.set_location('Leaving:'||l_proc, 10);

317: End if;
318: close csr_gsp;
319: --
320: p_grd_ldr_exists_flag := true;
321: hr_utility.set_location('Leaving:'||l_proc, 10);
322: --
323: --
324: Exception When others then
325: --

Line 326: hr_utility.set_location('Exception:'||l_proc, 200);

322: --
323: --
324: Exception When others then
325: --
326: hr_utility.set_location('Exception:'||l_proc, 200);
327: raise;
328: --
329: End check_grade_ladder_exists;
330: --

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

344: Begin
345: --
346: l_proc := 'check_grade_ladder_exists';
347: l_status := false;
348: hr_utility.set_location('Entering:'||l_proc, 5);
349: --
350: check_grade_ladder_exists
351: (p_business_group_id => p_business_group_id,
352: p_effective_date => p_effective_date,

Line 356: hr_utility.set_location('Found Grade ladder', 7);

352: p_effective_date => p_effective_date,
353: p_grd_ldr_exists_flag => l_status);
354: If l_status then
355: p_grd_ldr_exists_flag:= 'Y';
356: hr_utility.set_location('Found Grade ladder', 7);
357: End if;
358: --
359: p_grd_ldr_exists_flag:= 'N';
360: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 360: hr_utility.set_location('Leaving:'||l_proc, 10);

356: hr_utility.set_location('Found Grade ladder', 7);
357: End if;
358: --
359: p_grd_ldr_exists_flag:= 'N';
360: hr_utility.set_location('Leaving:'||l_proc, 10);
361: --
362: --
363: Exception When others then
364: --

Line 365: hr_utility.set_location('Exception:'||l_proc, 200);

361: --
362: --
363: Exception When others then
364: --
365: hr_utility.set_location('Exception:'||l_proc, 200);
366: raise;
367: --
368: End check_grade_ladder_exists;
369: --

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

386: Begin
387: --
388: l_precision := 2;
389: l_proc := 'pgm_to_annual';
390: hr_utility.set_location('Entering:'||l_proc, 10);
391: --
392: Open csr_cur;
393: Fetch csr_cur into l_precision;
394: Close csr_cur;

Line 426: hr_utility.set_location('Leaving:'||l_proc, 10);

422: END IF;
423: ---
424: RETURN trunc(l_ret_amount,l_precision);
425: --
426: hr_utility.set_location('Leaving:'||l_proc, 10);
427: --
428: End pgm_to_annual;
429: --
430: -----------------------------------------------------------------------------------------------------------------

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

520: Begin
521: --
522: l_continue := true;
523: l_proc := 'get_emp_proposed_salary';
524: hr_utility.set_location('Entering:'||l_proc, 5);
525: --
526: p_proposed_salary := null;
527: p_sal_chg_dt := null;
528: p_frequency := null;

Line 544: hr_utility.set_location('Get grade ladder details', 20);

540: If l_pgm_id is NOT NULL then
541: --
542: -- Get grade ladder currency
543: --
544: hr_utility.set_location('Get grade ladder details', 20);
545: --
546: Open csr_GrdLdr;
547: Fetch csr_GrdLdr into l_pgm_frequency, p_currency, l_update_sal_cd;
548: Close csr_GrdLdr;

Line 559: hr_utility.set_location('No life event on the assignment change date. Cannot compute proposed salary.', 30);

555: Fetch csr_le into l_per_in_ler_id;
556: If csr_le%notfound then
557: l_continue := false;
558: p_status := 2;
559: hr_utility.set_location('No life event on the assignment change date. Cannot compute proposed salary.', 30);
560: End if;
561: Close csr_le;
562: --
563: --

Line 570: hr_utility.set_location('No default enrolment found. Cannot compute proposed salary.', 40);

566: Fetch csr_sal into L_Cur_Sal,p_sal_chg_dt;
567: If csr_sal%notfound then
568: l_continue := false;
569: p_status := 3;
570: hr_utility.set_location('No default enrolment found. Cannot compute proposed salary.', 40);
571: End if;
572: Close csr_sal;
573: End if;
574: --

Line 580: hr_utility.set_location('Assignment has Salary Basis', 50);

576: If l_update_sal_cd = 'SALARY_BASIS' then
577: --
578: If l_pay_basis_id IS NOT NULL then
579: --
580: hr_utility.set_location('Assignment has Salary Basis', 50);
581: --
582: -- Get pay basis frequency
583: --
584: Open C_Pay_Basis;

Line 600: hr_utility.set_location('Assignment has no Salary Basis', 60);

596: --
597: -- This scenario should never occur.
598: --
599: l_continue := false;
600: hr_utility.set_location('Assignment has no Salary Basis', 60);
601: --
602: End if;
603: --
604: Else /** Using salary element **/

Line 606: hr_utility.set_location('Using salary element', 70);

602: End if;
603: --
604: Else /** Using salary element **/
605: --
606: hr_utility.set_location('Using salary element', 70);
607: If l_payroll_id is not null then
608: Open csr_payroll_freq(l_payroll_id);
609: Fetch csr_payroll_freq into p_frequency;
610: Close csr_payroll_freq;

Line 624: hr_utility.set_location('Calling pqh_gsp_utility.PGM_TO_BASIS_CONVERSION', 80);

620: --
621: If l_continue then
622: If L_Cur_Sal is not null then
623: --
624: hr_utility.set_location('Calling pqh_gsp_utility.PGM_TO_BASIS_CONVERSION', 80);
625: --
626: p_proposed_salary := pqh_gsp_utility.PGM_TO_BASIS_CONVERSION
627: (P_Pgm_ID => l_pgm_id
628: ,P_EFFECTIVE_DATE => P_Effective_Date

Line 633: hr_utility.set_location('Computing annual salary from program frequency.', 90);

629: ,P_AMOUNT => L_Cur_Sal
630: ,P_ASSIGNMENT_ID => p_assignment_id);
631: --
632: --
633: hr_utility.set_location('Computing annual salary from program frequency.', 90);
634: --
635: p_annual_salary := pgm_to_annual(p_ref_perd_cd => l_pgm_frequency,
636: p_pgm_currency => p_currency,
637: p_amount => L_Cur_Sal);

Line 646: hr_utility.set_location('Grade Ladder setup to not update salary', 120);

642: End if; /** l_continue **/
643: --
644: Else
645: --
646: hr_utility.set_location('Grade Ladder setup to not update salary', 120);
647: p_status := 4;
648: --
649: End if;
650: Else

Line 654: hr_utility.set_location(' Assignment is not on a Grade Ladder. Cannot compute proposed salary', 130);

650: Else
651: --
652: -- Assignment is not on a GL. Cannot compute proposed salary..
653: --
654: hr_utility.set_location(' Assignment is not on a Grade Ladder. Cannot compute proposed salary', 130);
655: p_status := 5;
656: --
657: --
658: End if;

Line 663: hr_utility.set_location('Leaving:'||l_proc, 10);

659: Close csr_asg_details;
660: End if;
661: --
662: --
663: hr_utility.set_location('Leaving:'||l_proc, 10);
664: --
665: Exception When others then
666: --
667: hr_utility.set_location('Exception:'||l_proc, 200);

Line 667: hr_utility.set_location('Exception:'||l_proc, 200);

663: hr_utility.set_location('Leaving:'||l_proc, 10);
664: --
665: Exception When others then
666: --
667: hr_utility.set_location('Exception:'||l_proc, 200);
668: raise;
669: --
670: End get_emp_proposed_salary;
671: --