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

Line 14: hr_utility.set_location('Inside Get_Day_of_Week Function', 1110);

10: FUNCTION Get_Day_of_Week(p_date DATE) RETURN NUMBER IS
11: l_reference_date date:=to_date('01/01/1984','DD/MM/YYYY');
12: v_index number;
13: BEGIN
14: hr_utility.set_location('Inside Get_Day_of_Week Function', 1110);
15: v_index:=abs(p_date - l_reference_date);
16: v_index:=mod(v_index,7);
17: hr_utility.set_location('v_index: '||v_index, 1120);
18: RETURN v_index+1;

Line 17: hr_utility.set_location('v_index: '||v_index, 1120);

13: BEGIN
14: hr_utility.set_location('Inside Get_Day_of_Week Function', 1110);
15: v_index:=abs(p_date - l_reference_date);
16: v_index:=mod(v_index,7);
17: hr_utility.set_location('v_index: '||v_index, 1120);
18: RETURN v_index+1;
19: END Get_Day_of_Week;
20:
21: -- ----------------------------------------------------------------------------

Line 34: hr_utility.set_location('Inside Get_Wage_Days Function', 1130);

30: v_end_of_week date;
31: v_days number := 0;
32: BEGIN
33:
34: hr_utility.set_location('Inside Get_Wage_Days Function', 1130);
35: hr_utility.set_location('p_start_date: '||p_start_date, 1140);
36: hr_utility.set_location('p_end_date: '||p_end_date, 1150);
37:
38: IF p_start_date > p_end_date THEN

Line 35: hr_utility.set_location('p_start_date: '||p_start_date, 1140);

31: v_days number := 0;
32: BEGIN
33:
34: hr_utility.set_location('Inside Get_Wage_Days Function', 1130);
35: hr_utility.set_location('p_start_date: '||p_start_date, 1140);
36: hr_utility.set_location('p_end_date: '||p_end_date, 1150);
37:
38: IF p_start_date > p_end_date THEN
39: RETURN v_days;

Line 36: hr_utility.set_location('p_end_date: '||p_end_date, 1150);

32: BEGIN
33:
34: hr_utility.set_location('Inside Get_Wage_Days Function', 1130);
35: hr_utility.set_location('p_start_date: '||p_start_date, 1140);
36: hr_utility.set_location('p_end_date: '||p_end_date, 1150);
37:
38: IF p_start_date > p_end_date THEN
39: RETURN v_days;
40: END IF;

Line 46: hr_utility.set_location('v_beg_of_week: '||v_beg_of_week, 1160);

42: --and End of Week Date for End Date
43: v_beg_of_week := v_st_date - (get_day_of_week(v_st_date)-1);
44: v_end_of_week := v_en_date;
45:
46: hr_utility.set_location('v_beg_of_week: '||v_beg_of_week, 1160);
47:
48:
49: IF get_day_of_week(v_en_date) NOT IN('1') THEN
50: v_end_of_week := v_en_date + (7- get_day_of_week(v_en_date)+1);

Line 53: hr_utility.set_location('v_end_of_week: '||v_end_of_week, 1170);

49: IF get_day_of_week(v_en_date) NOT IN('1') THEN
50: v_end_of_week := v_en_date + (7- get_day_of_week(v_en_date)+1);
51: END IF;
52:
53: hr_utility.set_location('v_end_of_week: '||v_end_of_week, 1170);
54:
55: --Calculate the Total Week Days @ of 5 per week
56: v_days := ((v_end_of_week-v_beg_of_week)/7)*5;
57:

Line 70: hr_utility.set_location('v_days: '||v_days, 1180);

66: IF v_st_date = v_en_date THEN
67: v_days := 0;
68: END IF;
69: END IF;
70: hr_utility.set_location('v_days: '||v_days, 1180);
71:
72: --Adjust the Total Week Days by subtracting
73: --No of Days After the End Date
74: IF (v_end_of_week - v_en_date) >= 0 THEN

Line 78: hr_utility.set_location('Final v_days: '||v_days, 1190);

74: IF (v_end_of_week - v_en_date) >= 0 THEN
75: v_days := v_days - (v_end_of_week - v_en_date) ;
76: END IF;
77: RETURN (v_days);
78: hr_utility.set_location('Final v_days: '||v_days, 1190);
79: END Get_Wage_Days;
80:
81: -- ----------------------------------------------------------------------------
82: -- |--------------------------< Get_Prorate_Amount >--------------------------------|

Line 132: hr_utility.set_location('Inside Get_Prorate_Amount Function ' , 1200);

128: (EFFECTIVE_START_DATE <= p_application_date and EFFECTIVE_END_DATE >= p_application_date);
129:
130: BEGIN
131:
132: hr_utility.set_location('Inside Get_Prorate_Amount Function ' , 1200);
133:
134: /* This loop checks for Assignment Suspension of a given assignment in a given pay period.
135: l_count = 1 means no suspension. */
136: FOR csr_asg_dates_rec in csr_asg_dates(p_assignment_id) LOOP

Line 144: hr_utility.set_location('l_assignment_start_date: '||l_assignment_start_date, 1210);

140: l_proration_end_date := Least(p_period_end_date, l_assignment_end_date);
141: l_prorated_wage_days_temp := Get_Wage_Days(l_proration_start_date, l_proration_end_date);
142: l_prorated_wage_days := l_prorated_wage_days + l_prorated_wage_days_temp;
143:
144: hr_utility.set_location('l_assignment_start_date: '||l_assignment_start_date, 1210);
145: hr_utility.set_location('l_assignment_end_date: '||l_assignment_end_date, 1220);
146: hr_utility.set_location('l_proration_start_date: '||l_proration_start_date, 1230);
147: hr_utility.set_location('l_proration_end_date: '||l_proration_end_date, 1240);
148: hr_utility.set_location('l_prorated_wage_days_temp: '||l_prorated_wage_days_temp , 1250);

Line 145: hr_utility.set_location('l_assignment_end_date: '||l_assignment_end_date, 1220);

141: l_prorated_wage_days_temp := Get_Wage_Days(l_proration_start_date, l_proration_end_date);
142: l_prorated_wage_days := l_prorated_wage_days + l_prorated_wage_days_temp;
143:
144: hr_utility.set_location('l_assignment_start_date: '||l_assignment_start_date, 1210);
145: hr_utility.set_location('l_assignment_end_date: '||l_assignment_end_date, 1220);
146: hr_utility.set_location('l_proration_start_date: '||l_proration_start_date, 1230);
147: hr_utility.set_location('l_proration_end_date: '||l_proration_end_date, 1240);
148: hr_utility.set_location('l_prorated_wage_days_temp: '||l_prorated_wage_days_temp , 1250);
149: hr_utility.set_location('l_prorated_wage_days: '||l_prorated_wage_days, 1260);

Line 146: hr_utility.set_location('l_proration_start_date: '||l_proration_start_date, 1230);

142: l_prorated_wage_days := l_prorated_wage_days + l_prorated_wage_days_temp;
143:
144: hr_utility.set_location('l_assignment_start_date: '||l_assignment_start_date, 1210);
145: hr_utility.set_location('l_assignment_end_date: '||l_assignment_end_date, 1220);
146: hr_utility.set_location('l_proration_start_date: '||l_proration_start_date, 1230);
147: hr_utility.set_location('l_proration_end_date: '||l_proration_end_date, 1240);
148: hr_utility.set_location('l_prorated_wage_days_temp: '||l_prorated_wage_days_temp , 1250);
149: hr_utility.set_location('l_prorated_wage_days: '||l_prorated_wage_days, 1260);
150:

Line 147: hr_utility.set_location('l_proration_end_date: '||l_proration_end_date, 1240);

143:
144: hr_utility.set_location('l_assignment_start_date: '||l_assignment_start_date, 1210);
145: hr_utility.set_location('l_assignment_end_date: '||l_assignment_end_date, 1220);
146: hr_utility.set_location('l_proration_start_date: '||l_proration_start_date, 1230);
147: hr_utility.set_location('l_proration_end_date: '||l_proration_end_date, 1240);
148: hr_utility.set_location('l_prorated_wage_days_temp: '||l_prorated_wage_days_temp , 1250);
149: hr_utility.set_location('l_prorated_wage_days: '||l_prorated_wage_days, 1260);
150:
151: l_count := l_count+1;

Line 148: hr_utility.set_location('l_prorated_wage_days_temp: '||l_prorated_wage_days_temp , 1250);

144: hr_utility.set_location('l_assignment_start_date: '||l_assignment_start_date, 1210);
145: hr_utility.set_location('l_assignment_end_date: '||l_assignment_end_date, 1220);
146: hr_utility.set_location('l_proration_start_date: '||l_proration_start_date, 1230);
147: hr_utility.set_location('l_proration_end_date: '||l_proration_end_date, 1240);
148: hr_utility.set_location('l_prorated_wage_days_temp: '||l_prorated_wage_days_temp , 1250);
149: hr_utility.set_location('l_prorated_wage_days: '||l_prorated_wage_days, 1260);
150:
151: l_count := l_count+1;
152:

Line 149: hr_utility.set_location('l_prorated_wage_days: '||l_prorated_wage_days, 1260);

145: hr_utility.set_location('l_assignment_end_date: '||l_assignment_end_date, 1220);
146: hr_utility.set_location('l_proration_start_date: '||l_proration_start_date, 1230);
147: hr_utility.set_location('l_proration_end_date: '||l_proration_end_date, 1240);
148: hr_utility.set_location('l_prorated_wage_days_temp: '||l_prorated_wage_days_temp , 1250);
149: hr_utility.set_location('l_prorated_wage_days: '||l_prorated_wage_days, 1260);
150:
151: l_count := l_count+1;
152:
153: END LOOP;

Line 155: hr_utility.set_location('l_count: '||l_count, 1270);

151: l_count := l_count+1;
152:
153: END LOOP;
154:
155: hr_utility.set_location('l_count: '||l_count, 1270);
156: hr_utility.set_location('l_prorated_wage_days outside loop: '||l_prorated_wage_days, 1280);
157:
158: /* This loop fetches number of Wage Days in a pay period using Globals */
159: FOR crs_rec_globals in csr_globals_nl_average_days

Line 156: hr_utility.set_location('l_prorated_wage_days outside loop: '||l_prorated_wage_days, 1280);

152:
153: END LOOP;
154:
155: hr_utility.set_location('l_count: '||l_count, 1270);
156: hr_utility.set_location('l_prorated_wage_days outside loop: '||l_prorated_wage_days, 1280);
157:
158: /* This loop fetches number of Wage Days in a pay period using Globals */
159: FOR crs_rec_globals in csr_globals_nl_average_days
160: LOOP

Line 175: hr_utility.set_location('l_total_wage_days_per_period: '||l_total_wage_days_per_period, 1290);

171: l_total_wage_days_per_period := crs_rec_globals.g_val;
172: END IF;
173: END LOOP;
174:
175: hr_utility.set_location('l_total_wage_days_per_period: '||l_total_wage_days_per_period, 1290);
176:
177: /* Checks that Prorated wage days should not cross maximum number of wage days for that pay period.
178: Also checks for the pay periods in Feb month, if an assignment is active right from the beginning
179: till end of the Feb pay period, then also prorate wage days may come less than the desired value,

Line 186: hr_utility.set_location('l_prorated_wage_days: '||l_prorated_wage_days, 1300);

182: IF (l_prorated_wage_days > l_total_wage_days_per_period) OR (l_prorated_wage_days < l_total_wage_days_per_period AND p_period_start_date = l_proration_start_date AND p_period_end_date = l_proration_end_date AND l_count = 1) THEN
183: l_prorated_wage_days := l_total_wage_days_per_period; /* Proration not Required */
184: END IF;
185:
186: hr_utility.set_location('l_prorated_wage_days: '||l_prorated_wage_days, 1300);
187: /* Total Prorated Amount */
188: p_amount := (p_amount) *
189: (l_prorated_wage_days/l_total_wage_days_per_period);
190: p_amount := round(p_amount,2);

Line 191: hr_utility.set_location('p_amount: '||p_amount, 1310);

187: /* Total Prorated Amount */
188: p_amount := (p_amount) *
189: (l_prorated_wage_days/l_total_wage_days_per_period);
190: p_amount := round(p_amount,2);
191: hr_utility.set_location('p_amount: '||p_amount, 1310);
192:
193: l_error_flag := 0; /* Success Status */
194: RETURN l_error_flag;
195: EXCEPTION

Line 323: hr_utility.set_location('Inside Get_Previous_Year_Sal Function ', 1320);

319: AND upper(piv.name) = 'CURRENT YEAR COLUMN 6';
320:
321: BEGIN
322:
323: hr_utility.set_location('Inside Get_Previous_Year_Sal Function ', 1320);
324:
325: -- Getting Person_id for the Assignment
326: OPEN csr_get_person;
327: FETCH csr_get_person INTO p_person_id;

Line 334: hr_utility.set_location('p_person_id: '||p_person_id, 1330);

330: OPEN csr_cur_yr_col6;
331: FETCH csr_cur_yr_col6 INTO l_element_type_id,l_input_value_name;
332: CLOSE csr_cur_yr_col6;
333:
334: hr_utility.set_location('p_person_id: '||p_person_id, 1330);
335: hr_utility.set_location('l_element_type_id: '||l_element_type_id, 1340);
336: hr_utility.set_location('l_input_value_name: '||l_input_value_name, 1350);
337:
338: -- Calculation for last year's dates from current year's date.

Line 335: hr_utility.set_location('l_element_type_id: '||l_element_type_id, 1340);

331: FETCH csr_cur_yr_col6 INTO l_element_type_id,l_input_value_name;
332: CLOSE csr_cur_yr_col6;
333:
334: hr_utility.set_location('p_person_id: '||p_person_id, 1330);
335: hr_utility.set_location('l_element_type_id: '||l_element_type_id, 1340);
336: hr_utility.set_location('l_input_value_name: '||l_input_value_name, 1350);
337:
338: -- Calculation for last year's dates from current year's date.
339: -- Get previous year by subtracting 1 from current year

Line 336: hr_utility.set_location('l_input_value_name: '||l_input_value_name, 1350);

332: CLOSE csr_cur_yr_col6;
333:
334: hr_utility.set_location('p_person_id: '||p_person_id, 1330);
335: hr_utility.set_location('l_element_type_id: '||l_element_type_id, 1340);
336: hr_utility.set_location('l_input_value_name: '||l_input_value_name, 1350);
337:
338: -- Calculation for last year's dates from current year's date.
339: -- Get previous year by subtracting 1 from current year
340: -- and then get first and last date of that year */

Line 346: hr_utility.set_location('l_for_last_yr: '||l_for_last_yr, 1360);

342: l_for_last_yr := to_number(to_char(p_date_earned,'YYYY')) - 1;
343: l_end_date_last_yr := to_date('31-12-'||to_char(l_for_last_yr),'DD-MM-YYYY');
344: l_start_date_last_yr := to_date('01-01-'||to_char(l_for_last_yr),'DD-MM-YYYY');
345:
346: hr_utility.set_location('l_for_last_yr: '||l_for_last_yr, 1360);
347: hr_utility.set_location('l_end_date_last_yr: '||l_end_date_last_yr, 1370);
348: hr_utility.set_location('l_start_date_last_yr: '||l_start_date_last_yr, 1380);
349:
350: -- Getting Defined_Balance_Type_Id of 12 balances required to calculate

Line 347: hr_utility.set_location('l_end_date_last_yr: '||l_end_date_last_yr, 1370);

343: l_end_date_last_yr := to_date('31-12-'||to_char(l_for_last_yr),'DD-MM-YYYY');
344: l_start_date_last_yr := to_date('01-01-'||to_char(l_for_last_yr),'DD-MM-YYYY');
345:
346: hr_utility.set_location('l_for_last_yr: '||l_for_last_yr, 1360);
347: hr_utility.set_location('l_end_date_last_yr: '||l_end_date_last_yr, 1370);
348: hr_utility.set_location('l_start_date_last_yr: '||l_start_date_last_yr, 1380);
349:
350: -- Getting Defined_Balance_Type_Id of 12 balances required to calculate
351: -- Remunuration Report Col6 Value

Line 348: hr_utility.set_location('l_start_date_last_yr: '||l_start_date_last_yr, 1380);

344: l_start_date_last_yr := to_date('01-01-'||to_char(l_for_last_yr),'DD-MM-YYYY');
345:
346: hr_utility.set_location('l_for_last_yr: '||l_for_last_yr, 1360);
347: hr_utility.set_location('l_end_date_last_yr: '||l_end_date_last_yr, 1370);
348: hr_utility.set_location('l_start_date_last_yr: '||l_start_date_last_yr, 1380);
349:
350: -- Getting Defined_Balance_Type_Id of 12 balances required to calculate
351: -- Remunuration Report Col6 Value
352:

Line 449: hr_utility.set_location('l_balance_amount: '||l_balance_amount, 1390);

445: (l_min_date, l_end_date_last_yr);
446: -- l_balance_amount := l_balance_amount * (261/l_wage_days);
447: END IF;
448: CLOSE csr_min_date;
449: hr_utility.set_location('l_balance_amount: '||l_balance_amount, 1390);
450: l_bal_total_amt := l_bal_total_amt + NVL(l_balance_amount,0);
451:
452: END LOOP; -- assg
453: END IF;

Line 455: hr_utility.set_location('l_bal_total_amt: '||l_bal_total_amt, 1400);

451:
452: END LOOP; -- assg
453: END IF;
454: END LOOP; -- def_bal_count
455: hr_utility.set_location('l_bal_total_amt: '||l_bal_total_amt, 1400);
456:
457: -- Checking for Terminated Assignments
458: For def_bal_count in 1..12 LOOP
459: IF l_def_bal_type_id(def_bal_count) IS NOT NULL THEN

Line 476: hr_utility.set_location('l_balance_amount: '||l_balance_amount, 1410);

472: (l_min_date, l_end_date_last_yr);
473: -- l_balance_amount := l_balance_amount * (261/l_wage_days);
474: END IF;
475: CLOSE csr_min_date;
476: hr_utility.set_location('l_balance_amount: '||l_balance_amount, 1410);
477: l_bal_total_amt := l_bal_total_amt + NVL(l_balance_amount,0);
478: END LOOP; -- assg
479: END IF;
480: END LOOP; -- def_bal_count

Line 482: hr_utility.set_location('l_bal_total_amt before calling ABP function: '||l_bal_total_amt, 1420);

478: END LOOP; -- assg
479: END IF;
480: END LOOP; -- def_bal_count
481:
482: hr_utility.set_location('l_bal_total_amt before calling ABP function: '||l_bal_total_amt, 1420);
483: -- Final Amount
484:
485: l_bal_total_amt := l_bal_total_amt +
486: pqp_pension_functions.get_abp_entry_value(p_business_group

Line 492: hr_utility.set_location('l_bal_total_amt after calling ABP function: '||l_bal_total_amt, 1430);

488: ,p_assignment_id
489: ,l_element_type_id
490: ,l_input_value_name);
491:
492: hr_utility.set_location('l_bal_total_amt after calling ABP function: '||l_bal_total_amt, 1430);
493: hr_utility.set_location('p_previous_er_column_6: '||p_previous_er_column_6, 1440);
494:
495: p_bal_total_amt := round((l_bal_total_amt + p_previous_er_column_6),2);
496:

Line 493: hr_utility.set_location('p_previous_er_column_6: '||p_previous_er_column_6, 1440);

489: ,l_element_type_id
490: ,l_input_value_name);
491:
492: hr_utility.set_location('l_bal_total_amt after calling ABP function: '||l_bal_total_amt, 1430);
493: hr_utility.set_location('p_previous_er_column_6: '||p_previous_er_column_6, 1440);
494:
495: p_bal_total_amt := round((l_bal_total_amt + p_previous_er_column_6),2);
496:
497: p_prev_year_sal := p_bal_total_amt;

Line 498: hr_utility.set_location('p_prev_year_sal: '||p_prev_year_sal, 1450);

494:
495: p_bal_total_amt := round((l_bal_total_amt + p_previous_er_column_6),2);
496:
497: p_prev_year_sal := p_bal_total_amt;
498: hr_utility.set_location('p_prev_year_sal: '||p_prev_year_sal, 1450);
499:
500: Return 0;
501:
502: EXCEPTION

Line 530: hr_utility.set_location('Inside Get_Or_Life_Savings_Basis function ', 1460);

526: AND p_date_earned BETWEEN effective_start_date AND
527: effective_end_date;
528: BEGIN
529:
530: hr_utility.set_location('Inside Get_Or_Life_Savings_Basis function ', 1460);
531:
532: -- Funtion to derive the override savings basis
533: -- for Life Savings. This is applicable only
534: -- to the basis calculation method Pre Defined Balances

Line 552: hr_utility.set_location('l_element_type_id: '||l_element_type_id, 1470);

548: ELSE
549: CLOSE c_ele_cur;
550: END IF;
551:
552: hr_utility.set_location('l_element_type_id: '||l_element_type_id, 1470);
553: --
554: -- Derive the value of the input as of 1 Jan or the hire date
555: --
556: p_override_basis := pqp_pension_functions.get_abp_entry_value

Line 563: hr_utility.set_location('p_override_basis: '||p_override_basis, 1480);

559: ,p_assignment_id => p_assignment_id
560: ,p_element_type_id => l_element_type_id
561: ,p_input_value_name => 'Override Annual Savings Basis');
562:
563: hr_utility.set_location('p_override_basis: '||p_override_basis, 1480);
564:
565: IF p_override_basis > 0 THEN
566: -- Indicator that the override has been done and that
567: -- the overriden value is > 0

Line 632: --hr_utility.trace_on(NULL,'NJ');

628: AND pdb.balance_dimension_id = pbd.balance_dimension_id;
629:
630: begin
631:
632: --hr_utility.trace_on(NULL,'NJ');
633: hr_utility.set_location('Inside LCLD Function', 100);
634: hr_utility.set_location('p_date_earned: '||p_date_earned, 200);
635: hr_utility.set_location('p_assignment_id: '||p_assignment_id, 300);
636: hr_utility.set_location('p_num_saved_yrs: '||p_num_saved_yrs, 400);

Line 633: hr_utility.set_location('Inside LCLD Function', 100);

629:
630: begin
631:
632: --hr_utility.trace_on(NULL,'NJ');
633: hr_utility.set_location('Inside LCLD Function', 100);
634: hr_utility.set_location('p_date_earned: '||p_date_earned, 200);
635: hr_utility.set_location('p_assignment_id: '||p_assignment_id, 300);
636: hr_utility.set_location('p_num_saved_yrs: '||p_num_saved_yrs, 400);
637: hr_utility.set_location('p_lcld_limit: '||p_lcld_limit, 500);

Line 634: hr_utility.set_location('p_date_earned: '||p_date_earned, 200);

630: begin
631:
632: --hr_utility.trace_on(NULL,'NJ');
633: hr_utility.set_location('Inside LCLD Function', 100);
634: hr_utility.set_location('p_date_earned: '||p_date_earned, 200);
635: hr_utility.set_location('p_assignment_id: '||p_assignment_id, 300);
636: hr_utility.set_location('p_num_saved_yrs: '||p_num_saved_yrs, 400);
637: hr_utility.set_location('p_lcld_limit: '||p_lcld_limit, 500);
638: hr_utility.set_location('l_current_year: '||l_current_year, 900);

Line 635: hr_utility.set_location('p_assignment_id: '||p_assignment_id, 300);

631:
632: --hr_utility.trace_on(NULL,'NJ');
633: hr_utility.set_location('Inside LCLD Function', 100);
634: hr_utility.set_location('p_date_earned: '||p_date_earned, 200);
635: hr_utility.set_location('p_assignment_id: '||p_assignment_id, 300);
636: hr_utility.set_location('p_num_saved_yrs: '||p_num_saved_yrs, 400);
637: hr_utility.set_location('p_lcld_limit: '||p_lcld_limit, 500);
638: hr_utility.set_location('l_current_year: '||l_current_year, 900);
639:

Line 636: hr_utility.set_location('p_num_saved_yrs: '||p_num_saved_yrs, 400);

632: --hr_utility.trace_on(NULL,'NJ');
633: hr_utility.set_location('Inside LCLD Function', 100);
634: hr_utility.set_location('p_date_earned: '||p_date_earned, 200);
635: hr_utility.set_location('p_assignment_id: '||p_assignment_id, 300);
636: hr_utility.set_location('p_num_saved_yrs: '||p_num_saved_yrs, 400);
637: hr_utility.set_location('p_lcld_limit: '||p_lcld_limit, 500);
638: hr_utility.set_location('l_current_year: '||l_current_year, 900);
639:
640: -- Fetch the value of global in the present year and

Line 637: hr_utility.set_location('p_lcld_limit: '||p_lcld_limit, 500);

633: hr_utility.set_location('Inside LCLD Function', 100);
634: hr_utility.set_location('p_date_earned: '||p_date_earned, 200);
635: hr_utility.set_location('p_assignment_id: '||p_assignment_id, 300);
636: hr_utility.set_location('p_num_saved_yrs: '||p_num_saved_yrs, 400);
637: hr_utility.set_location('p_lcld_limit: '||p_lcld_limit, 500);
638: hr_utility.set_location('l_current_year: '||l_current_year, 900);
639:
640: -- Fetch the value of global in the present year and
641: -- multiply it with number of years saved.

Line 638: hr_utility.set_location('l_current_year: '||l_current_year, 900);

634: hr_utility.set_location('p_date_earned: '||p_date_earned, 200);
635: hr_utility.set_location('p_assignment_id: '||p_assignment_id, 300);
636: hr_utility.set_location('p_num_saved_yrs: '||p_num_saved_yrs, 400);
637: hr_utility.set_location('p_lcld_limit: '||p_lcld_limit, 500);
638: hr_utility.set_location('l_current_year: '||l_current_year, 900);
639:
640: -- Fetch the value of global in the present year and
641: -- multiply it with number of years saved.
642: open c_gbl_value(l_current_year);

Line 646: hr_utility.set_location('l_gbl_value_temp: '||l_gbl_value_temp, 1200);

642: open c_gbl_value(l_current_year);
643: fetch c_gbl_value into l_gbl_value_temp;
644: close c_gbl_value;
645:
646: hr_utility.set_location('l_gbl_value_temp: '||l_gbl_value_temp, 1200);
647:
648: l_gbl_value := fnd_number.canonical_to_number(l_gbl_value_temp);
649:
650: hr_utility.set_location('l_gbl_value: '||l_gbl_value, 800);

Line 650: hr_utility.set_location('l_gbl_value: '||l_gbl_value, 800);

646: hr_utility.set_location('l_gbl_value_temp: '||l_gbl_value_temp, 1200);
647:
648: l_gbl_value := fnd_number.canonical_to_number(l_gbl_value_temp);
649:
650: hr_utility.set_location('l_gbl_value: '||l_gbl_value, 800);
651:
652: l_lcld_limit := p_num_saved_yrs * l_gbl_value;
653:
654: -- Round off the value to 2 decimal places.

Line 657: hr_utility.set_location('p_lcld_limit: '||p_lcld_limit, 1100);

653:
654: -- Round off the value to 2 decimal places.
655: p_lcld_limit := round(l_lcld_limit,2);
656:
657: hr_utility.set_location('p_lcld_limit: '||p_lcld_limit, 1100);
658: return 0; /* 0 means success, and l_lcld_limit has to be an out variable.*/
659:
660: hr_utility.trace_off();
661:

Line 660: hr_utility.trace_off();

656:
657: hr_utility.set_location('p_lcld_limit: '||p_lcld_limit, 1100);
658: return 0; /* 0 means success, and l_lcld_limit has to be an out variable.*/
659:
660: hr_utility.trace_off();
661:
662: Exception
663: WHEN OTHERS THEN
664: p_error_msg :='SQL-ERRM :'||SQLERRM;