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_PAY_PROPOSALS_POPULATE dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY PER_PAY_PROPOSALS_POPULATE AS
2: /* $Header: pepaprpo.pkb 120.1.12020000.2 2012/07/05 03:07:07 amnaraya ship $ */
3: g_package varchar2(33) := 'per_pay_proposals_populate.';
4: g_debug boolean := hr_utility.debug_enabled;
5: --------------------------------------------------------------------------
6: /* Procedure to get the grade that a person is on given the
7: date, assginment_id and business_group_id. If the person
8: has not had a grade set at that date then nothing is

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

47: AND asg.effective_end_date;
48:
49: l_proc varchar2(72) := g_package||'get_grade';
50: BEGIN
51: hr_utility.set_location('Entering:'||l_proc,5);
52: open grade_rates;
53: fetch grade_rates
54: INTO p_minimum_salary,
55: p_maximum_salary,

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

99: and pee.creator_type = 'SP';
100:
101: l_proc varchar2(72) := g_package||'get_element_id';
102: BEGIN
103: hr_utility.set_location('Entering:'||l_proc,5);
104:
105: open get_element;
106: fetch get_element
107: INTO p_payroll_value,p_element_entry_id;

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

118: l_format_mask VARCHAR2(40);
119:
120: l_proc varchar2(72) := g_package||'get_currency_format';
121: BEGIN
122: hr_utility.set_location('Entering:'||l_proc,5);
123: hr_utility.set_location('curcode= '||curcode,10);
124:
125: l_format_mask:= FND_CURRENCY.GET_FORMAT_MASK(curcode,30);
126: hr_utility.set_location('format= '||l_format_mask,15);

Line 123: hr_utility.set_location('curcode= '||curcode,10);

119:
120: l_proc varchar2(72) := g_package||'get_currency_format';
121: BEGIN
122: hr_utility.set_location('Entering:'||l_proc,5);
123: hr_utility.set_location('curcode= '||curcode,10);
124:
125: l_format_mask:= FND_CURRENCY.GET_FORMAT_MASK(curcode,30);
126: hr_utility.set_location('format= '||l_format_mask,15);
127: fstring:=l_format_mask;

Line 126: hr_utility.set_location('format= '||l_format_mask,15);

122: hr_utility.set_location('Entering:'||l_proc,5);
123: hr_utility.set_location('curcode= '||curcode,10);
124:
125: l_format_mask:= FND_CURRENCY.GET_FORMAT_MASK(curcode,30);
126: hr_utility.set_location('format= '||l_format_mask,15);
127: fstring:=l_format_mask;
128: hr_utility.set_location('format= '||fstring,15);
129:
130: END GET_CURRENCY_FORMAT;

Line 128: hr_utility.set_location('format= '||fstring,15);

124:
125: l_format_mask:= FND_CURRENCY.GET_FORMAT_MASK(curcode,30);
126: hr_utility.set_location('format= '||l_format_mask,15);
127: fstring:=l_format_mask;
128: hr_utility.set_location('format= '||fstring,15);
129:
130: END GET_CURRENCY_FORMAT;
131: ------------------------------------------------------------
132:

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

134: l_format_mask VARCHAR2(40);
135:
136: l_proc varchar2(72) := g_package||'get_currency_format';
137: BEGIN
138: hr_utility.set_location('Entering:'||l_proc,5);
139:
140: FND_CURRENCY.BUILD_FORMAT_MASK(format_mask => l_format_mask
141: ,field_length => 30
142: ,precision => 5

Line 144: hr_utility.set_location('format= '||l_format_mask,15);

140: FND_CURRENCY.BUILD_FORMAT_MASK(format_mask => l_format_mask
141: ,field_length => 30
142: ,precision => 5
143: ,min_acct_unit => null);
144: hr_utility.set_location('format= '||l_format_mask,15);
145: fstring:=l_format_mask;
146: hr_utility.set_location('format= '||fstring,15);
147:
148: END GET_NUMBER_FORMAT;

Line 146: hr_utility.set_location('format= '||fstring,15);

142: ,precision => 5
143: ,min_acct_unit => null);
144: hr_utility.set_location('format= '||l_format_mask,15);
145: fstring:=l_format_mask;
146: hr_utility.set_location('format= '||fstring,15);
147:
148: END GET_NUMBER_FORMAT;
149: --------------------------------------------------------------------------------
150: /* Procedure the populate the default values for a new salary proposal,

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

201: l_grade_uom VARCHAR2(30);
202:
203: l_proc varchar2(72) := g_package||'get_defaults';
204: BEGIN
205: hr_utility.set_location('Entering:'||l_proc,5);
206:
207: l_change_date:=p_date;
208:
209: GET_PREV_SALARY(l_change_date

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

324: PET.EFFECTIVE_END_DATE;
325:
326: l_proc varchar2(72) := g_package||'get_basis_details';
327: BEGIN
328: hr_utility.set_location('Entering:'||l_proc,5);
329: open c_pay_basis;
330: fetch c_pay_basis into l_pay_basis_id;
331: close c_pay_basis;
332: --

Line 345: hr_utility.set_location(l_proc,10);

341: , l_grade_basis
342: , p_element_type_id
343: , p_uom;
344: --
345: hr_utility.set_location(l_proc,10);
346: --
347: close Currency;
348:
349: if(l_pay_basis ='PERIOD' and l_pay_annualization_factor is null) then

Line 350: hr_utility.set_location(l_proc,15);

346: --
347: close Currency;
348:
349: if(l_pay_basis ='PERIOD' and l_pay_annualization_factor is null) then
350: hr_utility.set_location(l_proc,15);
351: --
352: GET_PAYROLL(p_assignment_id
353: ,p_effective_date
354: ,l_dummy

Line 359: hr_utility.set_location(l_proc,20);

355: ,l_pay_annualization_factor);
356: end if;
357: --
358: if(l_grade_basis ='PERIOD' and l_grade_annualization_factor is null) then
359: hr_utility.set_location(l_proc,20);
360:
361: GET_PAYROLL(p_assignment_id
362: ,p_effective_date
363: ,l_dummy

Line 371: hr_utility.set_location('Leaving:'||l_proc,25);

367: p_pay_basis:=l_pay_basis;
368: p_grade_basis:=l_grade_basis;
369: p_pay_annualization_factor:=l_pay_annualization_factor;
370: p_grade_annualization_factor:=l_grade_annualization_factor;
371: hr_utility.set_location('Leaving:'||l_proc,25);
372:
373: END GET_BASIS_DETAILS;
374: ---------------------------------------------------------------------------
375: /* procedure to get the previous change date */

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

398: l_last_change_date DATE;
399:
400: l_proc varchar2(72) := g_package||'get_prev_salary';
401: BEGIN
402: hr_utility.set_location('Entering:'||l_proc,5);
403: --
404: open previous_pay;
405: fetch previous_pay
406: into p_prev_salary

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

481: and prl.period_type = tpt.period_type(+);
482:
483: l_proc varchar2(72) := g_package||'get_payroll';
484: begin
485: hr_utility.set_location('Entering:'||l_proc,5);
486:
487: open payroll;
488: fetch payroll into p_payroll,p_payrolls_per_year;
489: close payroll;

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

501: l_hours_per_year number;
502:
503: l_proc varchar2(72) := g_package||'get_hours';
504: begin
505: hr_utility.set_location('Entering:'||l_proc,5);
506:
507: get_asg_hours(p_assignment_id
508: ,p_date
509: ,l_hours_per_year);

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

539: l_frequency NUMBER;
540:
541: l_proc varchar2(72) := g_package||'get_asg_hours';
542: begin
543: hr_utility.set_location('Entering:'||l_proc,5);
544:
545: open get_asg_hours;
546: fetch get_asg_hours into l_hours,l_frequency;
547:

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

623:
624: l_proc varchar2(72) := g_package||'get_norm_hours';
625: begin
626: if g_debug then
627: hr_utility.set_location('Entering:'||l_proc,5);
628: end if;
629:
630: open get_pos_hours;
631: fetch get_pos_hours into l_hours,l_frequency;

Line 637: hr_utility.set_location('get_org_hours',7);

633:
634: if l_hours is null or l_frequency is null then
635: begin
636: if g_debug then
637: hr_utility.set_location('get_org_hours',7);
638: end if;
639: open get_org_hours;
640: fetch get_org_hours into l_hours,l_frequency;
641: close get_org_hours;

Line 645: hr_utility.set_location('get_org_hours exception',8);

641: close get_org_hours;
642: exception
643: when others then
644: if g_debug then
645: hr_utility.set_location('get_org_hours exception',8);
646: end if;
647: l_hours := null;
648: l_frequency := null;
649: end;

Line 653: hr_utility.set_location('get_bus_hours',10);

649: end;
650: if l_hours is null or l_frequency is null then
651: begin
652: if g_debug then
653: hr_utility.set_location('get_bus_hours',10);
654: end if;
655: open get_bus_hours;
656: fetch get_bus_hours into l_hours,l_frequency;
657: close get_bus_hours;

Line 661: hr_utility.set_location('get_bus_hours exception',12);

657: close get_bus_hours;
658: exception
659: when others then
660: if g_debug then
661: hr_utility.set_location('get_bus_hours exception',12);
662: end if;
663: l_hours := null;
664: l_frequency := null;
665: end;

Line 670: hr_utility.set_location('Leaving:'||l_proc,15);

666: end if;
667: end if;
668: p_hours_per_year:=nvl(l_hours,0)*l_frequency;
669: if g_debug then
670: hr_utility.set_location('Leaving:'||l_proc,15);
671: end if;
672: end get_norm_hours;
673:
674: