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

Line 76: hr_utility.set_location('pyhkudfs get_retro_mpf', 01);

72: i number:=0;
73: --
74: BEGIN
75: --
76: hr_utility.set_location('pyhkudfs get_retro_mpf', 01);
77: --
78: l_cum_mpf_arrs := 0;
79: l_cum_mpf_ri := 0;
80: l_old_period_id := 0;

Line 111: hr_utility.set_location('pyhkudfs get_retro_mpf', 02);

107: /*
108: ** Get the MPF RI LIMITS that were in force at the period end date
109: ** Bug 12800852, use l_period_start_date for get_table_value function
110: */
111: hr_utility.set_location('pyhkudfs get_retro_mpf', 02);
112: IF p_pay_basis <> 'Year' and
113: p_pay_basis <> 'Semi-Year' and
114: p_pay_basis <> 'Semi-Month' and /* Bug 7171659, based on Day rate times days*/
115: p_pay_basis <> 'Lunar Month' THEN

Line 147: hr_utility.trace('l_cum_mpf_arrs' || to_char(l_cum_mpf_arrs));

143: ** apply the capping to the periodic RI based on p_calc_method
144: */
145:
146:
147: hr_utility.trace('l_cum_mpf_arrs' || to_char(l_cum_mpf_arrs));
148: hr_utility.trace('l_value' || to_char(l_value));
149: hr_utility.trace('l_min_ri' || to_char(l_min_ri));
150: hr_utility.trace('l_max_ri' || to_char(l_max_ri));
151: hr_utility.trace('p_percentage' || to_char(p_percentage));

Line 148: hr_utility.trace('l_value' || to_char(l_value));

144: */
145:
146:
147: hr_utility.trace('l_cum_mpf_arrs' || to_char(l_cum_mpf_arrs));
148: hr_utility.trace('l_value' || to_char(l_value));
149: hr_utility.trace('l_min_ri' || to_char(l_min_ri));
150: hr_utility.trace('l_max_ri' || to_char(l_max_ri));
151: hr_utility.trace('p_percentage' || to_char(p_percentage));
152: hr_utility.trace('p_calc_method' ||p_calc_method);

Line 149: hr_utility.trace('l_min_ri' || to_char(l_min_ri));

145:
146:
147: hr_utility.trace('l_cum_mpf_arrs' || to_char(l_cum_mpf_arrs));
148: hr_utility.trace('l_value' || to_char(l_value));
149: hr_utility.trace('l_min_ri' || to_char(l_min_ri));
150: hr_utility.trace('l_max_ri' || to_char(l_max_ri));
151: hr_utility.trace('p_percentage' || to_char(p_percentage));
152: hr_utility.trace('p_calc_method' ||p_calc_method);
153:

Line 150: hr_utility.trace('l_max_ri' || to_char(l_max_ri));

146:
147: hr_utility.trace('l_cum_mpf_arrs' || to_char(l_cum_mpf_arrs));
148: hr_utility.trace('l_value' || to_char(l_value));
149: hr_utility.trace('l_min_ri' || to_char(l_min_ri));
150: hr_utility.trace('l_max_ri' || to_char(l_max_ri));
151: hr_utility.trace('p_percentage' || to_char(p_percentage));
152: hr_utility.trace('p_calc_method' ||p_calc_method);
153:
154: IF p_calc_method = 'RI' THEN

Line 151: hr_utility.trace('p_percentage' || to_char(p_percentage));

147: hr_utility.trace('l_cum_mpf_arrs' || to_char(l_cum_mpf_arrs));
148: hr_utility.trace('l_value' || to_char(l_value));
149: hr_utility.trace('l_min_ri' || to_char(l_min_ri));
150: hr_utility.trace('l_max_ri' || to_char(l_max_ri));
151: hr_utility.trace('p_percentage' || to_char(p_percentage));
152: hr_utility.trace('p_calc_method' ||p_calc_method);
153:
154: IF p_calc_method = 'RI' THEN
155: hr_utility.set_location('pyhkudfs get_retro_mpf', 10);

Line 152: hr_utility.trace('p_calc_method' ||p_calc_method);

148: hr_utility.trace('l_value' || to_char(l_value));
149: hr_utility.trace('l_min_ri' || to_char(l_min_ri));
150: hr_utility.trace('l_max_ri' || to_char(l_max_ri));
151: hr_utility.trace('p_percentage' || to_char(p_percentage));
152: hr_utility.trace('p_calc_method' ||p_calc_method);
153:
154: IF p_calc_method = 'RI' THEN
155: hr_utility.set_location('pyhkudfs get_retro_mpf', 10);
156: /* Bug 7535161, to separate pay period */

Line 155: hr_utility.set_location('pyhkudfs get_retro_mpf', 10);

151: hr_utility.trace('p_percentage' || to_char(p_percentage));
152: hr_utility.trace('p_calc_method' ||p_calc_method);
153:
154: IF p_calc_method = 'RI' THEN
155: hr_utility.set_location('pyhkudfs get_retro_mpf', 10);
156: /* Bug 7535161, to separate pay period */
157: IF l_month <> l_prev_month THEN
158: i:=i+1;
159: l_get_retro_value(i).l_mon_value:=0;

Line 166: hr_utility.set_location('pyhkudfs get_retro_mpf', 15);

162: l_get_retro_value(i).l_mon_value := l_get_retro_value(i).l_mon_value + l_value;
163: l_cum_mpf_ri := l_cum_mpf_ri + l_value;
164: END IF;
165: ELSIF p_calc_method = 'ER' THEN
166: hr_utility.set_location('pyhkudfs get_retro_mpf', 15);
167: /* Bug 2798013. Added the following proration logic to calculate
168: Retro MPF Liability */
169: IF p_Contributions_End_Date < l_period_start_date THEN
170: l_er_prorator := 0;

Line 208: hr_utility.trace('Anu ER p_date_from' || to_char(p_date_from,'DD/MM/YYYY'));

204:
205: ELSE
206: l_er_prorator := 1;
207: END IF;
208: hr_utility.trace('Anu ER p_date_from' || to_char(p_date_from,'DD/MM/YYYY'));
209: hr_utility.trace('p_date_to' || to_char(p_date_to,'DD/MM/YYYY'));
210: hr_utility.trace('l_period_start_date' || to_char(l_period_start_date,'DD/MM/YYYY'));
211: hr_utility.trace('l_period_end_date' || to_char(l_period_end_date,'DD/MM/YYYY'));
212: hr_utility.trace('p_ER_Liability_Start_Date' || to_char(p_ER_Liability_Start_Date,'DD/MM/YYYY'));

Line 209: hr_utility.trace('p_date_to' || to_char(p_date_to,'DD/MM/YYYY'));

205: ELSE
206: l_er_prorator := 1;
207: END IF;
208: hr_utility.trace('Anu ER p_date_from' || to_char(p_date_from,'DD/MM/YYYY'));
209: hr_utility.trace('p_date_to' || to_char(p_date_to,'DD/MM/YYYY'));
210: hr_utility.trace('l_period_start_date' || to_char(l_period_start_date,'DD/MM/YYYY'));
211: hr_utility.trace('l_period_end_date' || to_char(l_period_end_date,'DD/MM/YYYY'));
212: hr_utility.trace('p_ER_Liability_Start_Date' || to_char(p_ER_Liability_Start_Date,'DD/MM/YYYY'));
213: hr_utility.trace('l_er_prorator' || to_char(l_er_prorator));

Line 210: hr_utility.trace('l_period_start_date' || to_char(l_period_start_date,'DD/MM/YYYY'));

206: l_er_prorator := 1;
207: END IF;
208: hr_utility.trace('Anu ER p_date_from' || to_char(p_date_from,'DD/MM/YYYY'));
209: hr_utility.trace('p_date_to' || to_char(p_date_to,'DD/MM/YYYY'));
210: hr_utility.trace('l_period_start_date' || to_char(l_period_start_date,'DD/MM/YYYY'));
211: hr_utility.trace('l_period_end_date' || to_char(l_period_end_date,'DD/MM/YYYY'));
212: hr_utility.trace('p_ER_Liability_Start_Date' || to_char(p_ER_Liability_Start_Date,'DD/MM/YYYY'));
213: hr_utility.trace('l_er_prorator' || to_char(l_er_prorator));
214:

Line 211: hr_utility.trace('l_period_end_date' || to_char(l_period_end_date,'DD/MM/YYYY'));

207: END IF;
208: hr_utility.trace('Anu ER p_date_from' || to_char(p_date_from,'DD/MM/YYYY'));
209: hr_utility.trace('p_date_to' || to_char(p_date_to,'DD/MM/YYYY'));
210: hr_utility.trace('l_period_start_date' || to_char(l_period_start_date,'DD/MM/YYYY'));
211: hr_utility.trace('l_period_end_date' || to_char(l_period_end_date,'DD/MM/YYYY'));
212: hr_utility.trace('p_ER_Liability_Start_Date' || to_char(p_ER_Liability_Start_Date,'DD/MM/YYYY'));
213: hr_utility.trace('l_er_prorator' || to_char(l_er_prorator));
214:
215: /* Bug 2753292. Removed the check for min RI threshold */

Line 212: hr_utility.trace('p_ER_Liability_Start_Date' || to_char(p_ER_Liability_Start_Date,'DD/MM/YYYY'));

208: hr_utility.trace('Anu ER p_date_from' || to_char(p_date_from,'DD/MM/YYYY'));
209: hr_utility.trace('p_date_to' || to_char(p_date_to,'DD/MM/YYYY'));
210: hr_utility.trace('l_period_start_date' || to_char(l_period_start_date,'DD/MM/YYYY'));
211: hr_utility.trace('l_period_end_date' || to_char(l_period_end_date,'DD/MM/YYYY'));
212: hr_utility.trace('p_ER_Liability_Start_Date' || to_char(p_ER_Liability_Start_Date,'DD/MM/YYYY'));
213: hr_utility.trace('l_er_prorator' || to_char(l_er_prorator));
214:
215: /* Bug 2753292. Removed the check for min RI threshold */
216: l_cum_mpf_arrs := l_cum_mpf_arrs +

Line 213: hr_utility.trace('l_er_prorator' || to_char(l_er_prorator));

209: hr_utility.trace('p_date_to' || to_char(p_date_to,'DD/MM/YYYY'));
210: hr_utility.trace('l_period_start_date' || to_char(l_period_start_date,'DD/MM/YYYY'));
211: hr_utility.trace('l_period_end_date' || to_char(l_period_end_date,'DD/MM/YYYY'));
212: hr_utility.trace('p_ER_Liability_Start_Date' || to_char(p_ER_Liability_Start_Date,'DD/MM/YYYY'));
213: hr_utility.trace('l_er_prorator' || to_char(l_er_prorator));
214:
215: /* Bug 2753292. Removed the check for min RI threshold */
216: l_cum_mpf_arrs := l_cum_mpf_arrs +
217: least(((l_value * l_er_prorator) * p_percentage / 100)

Line 236: hr_utility.set_location('pyhkudfs get_retro_mpf', 20);

232: /*
233: ** Establish if its a full period RI,
234: ** if not, derive prorator for qualifying days
235: */
236: hr_utility.set_location('pyhkudfs get_retro_mpf', 20);
237:
238: /* Bug 2753272. Added p_hire_date condition */
239: /* Bug# 4314140 Modified the partial period waiver logic so that partial period waiver should be applicable only for the month
240: in which 30th day of the employment falls*/

Line 297: hr_utility.trace('p_date_from'||to_char(p_date_from,'DD/MM/YYYY'));

293: l_prorator := 0;
294: END IF;
295: END IF;
296:
297: hr_utility.trace('p_date_from'||to_char(p_date_from,'DD/MM/YYYY'));
298: hr_utility.trace('p_date_to' || to_char(p_date_to,'DD/MM/YYYY'));
299: hr_utility.trace('l_period_start_date' || to_char(l_period_start_date,'DD/MM/YYYY'));
300: hr_utility.trace('l_period_end_date' || to_char(l_period_end_date,'DD/MM/YYYY'));
301: hr_utility.trace('l_prorator' || to_char(l_prorator));

Line 298: hr_utility.trace('p_date_to' || to_char(p_date_to,'DD/MM/YYYY'));

294: END IF;
295: END IF;
296:
297: hr_utility.trace('p_date_from'||to_char(p_date_from,'DD/MM/YYYY'));
298: hr_utility.trace('p_date_to' || to_char(p_date_to,'DD/MM/YYYY'));
299: hr_utility.trace('l_period_start_date' || to_char(l_period_start_date,'DD/MM/YYYY'));
300: hr_utility.trace('l_period_end_date' || to_char(l_period_end_date,'DD/MM/YYYY'));
301: hr_utility.trace('l_prorator' || to_char(l_prorator));
302:

Line 299: hr_utility.trace('l_period_start_date' || to_char(l_period_start_date,'DD/MM/YYYY'));

295: END IF;
296:
297: hr_utility.trace('p_date_from'||to_char(p_date_from,'DD/MM/YYYY'));
298: hr_utility.trace('p_date_to' || to_char(p_date_to,'DD/MM/YYYY'));
299: hr_utility.trace('l_period_start_date' || to_char(l_period_start_date,'DD/MM/YYYY'));
300: hr_utility.trace('l_period_end_date' || to_char(l_period_end_date,'DD/MM/YYYY'));
301: hr_utility.trace('l_prorator' || to_char(l_prorator));
302:
303: /*

Line 300: hr_utility.trace('l_period_end_date' || to_char(l_period_end_date,'DD/MM/YYYY'));

296:
297: hr_utility.trace('p_date_from'||to_char(p_date_from,'DD/MM/YYYY'));
298: hr_utility.trace('p_date_to' || to_char(p_date_to,'DD/MM/YYYY'));
299: hr_utility.trace('l_period_start_date' || to_char(l_period_start_date,'DD/MM/YYYY'));
300: hr_utility.trace('l_period_end_date' || to_char(l_period_end_date,'DD/MM/YYYY'));
301: hr_utility.trace('l_prorator' || to_char(l_prorator));
302:
303: /*
304: ** Bug #2270318 - Check the RI with prorated value of Minimum Threshold

Line 301: hr_utility.trace('l_prorator' || to_char(l_prorator));

297: hr_utility.trace('p_date_from'||to_char(p_date_from,'DD/MM/YYYY'));
298: hr_utility.trace('p_date_to' || to_char(p_date_to,'DD/MM/YYYY'));
299: hr_utility.trace('l_period_start_date' || to_char(l_period_start_date,'DD/MM/YYYY'));
300: hr_utility.trace('l_period_end_date' || to_char(l_period_end_date,'DD/MM/YYYY'));
301: hr_utility.trace('l_prorator' || to_char(l_prorator));
302:
303: /*
304: ** Bug #2270318 - Check the RI with prorated value of Minimum Threshold
305: ** Also prorate the Maximum Threshold Value

Line 347: hr_utility.set_location('pyhkudfs get_retro_mpf', 50);

343: p_value2 := 0;
344: END IF;
345:
346: IF p_calc_method = 'RI' THEN
347: hr_utility.set_location('pyhkudfs get_retro_mpf', 50);
348: hr_utility.trace('l_cur_mpf_ri:'||l_cum_mpf_ri);
349: RETURN l_cum_mpf_ri;
350: ELSE
351: hr_utility.set_location('pyhkudfs get_retro_mpf', 55);

Line 348: hr_utility.trace('l_cur_mpf_ri:'||l_cum_mpf_ri);

344: END IF;
345:
346: IF p_calc_method = 'RI' THEN
347: hr_utility.set_location('pyhkudfs get_retro_mpf', 50);
348: hr_utility.trace('l_cur_mpf_ri:'||l_cum_mpf_ri);
349: RETURN l_cum_mpf_ri;
350: ELSE
351: hr_utility.set_location('pyhkudfs get_retro_mpf', 55);
352: RETURN l_cum_mpf_arrs;

Line 351: hr_utility.set_location('pyhkudfs get_retro_mpf', 55);

347: hr_utility.set_location('pyhkudfs get_retro_mpf', 50);
348: hr_utility.trace('l_cur_mpf_ri:'||l_cum_mpf_ri);
349: RETURN l_cum_mpf_ri;
350: ELSE
351: hr_utility.set_location('pyhkudfs get_retro_mpf', 55);
352: RETURN l_cum_mpf_arrs;
353: END IF;
354: END get_retro_mpf;
355: --

Line 374: hr_utility.set_location('pyhkudfs hk_scheme_val', 01);

370: and d.org_information_context = 'HK_MPF_SCHEMES';
371: --
372: BEGIN
373: --
374: hr_utility.set_location('pyhkudfs hk_scheme_val', 01);
375: --
376: v_valid_scheme := 'E';
377: open check_source (p_bus_grp_id, p_entry_value);
378: fetch check_source into v_valid_scheme;

Line 381: hr_utility.set_location('pyhkudfs hk_scheme_val', 03);

377: open check_source (p_bus_grp_id, p_entry_value);
378: fetch check_source into v_valid_scheme;
379: close check_source;
380: --
381: hr_utility.set_location('pyhkudfs hk_scheme_val', 03);
382: --
383: RETURN v_valid_scheme;
384: --
385: END hk_scheme_val;

Line 403: hr_utility.set_location('pyhkudfs hk_quarters_val', 01);

399: and d.aei_information_category = 'HR_QUARTERS_INFO_HK';
400: --
401: BEGIN
402: --
403: hr_utility.set_location('pyhkudfs hk_quarters_val', 01);
404: --
405: v_valid_quarters := 'E';
406: open check_source (p_assignment_id, p_entry_value);
407: fetch check_source into v_valid_quarters;

Line 410: hr_utility.set_location('pyhkudfs hk_quarters_val', 03);

406: open check_source (p_assignment_id, p_entry_value);
407: fetch check_source into v_valid_quarters;
408: close check_source;
409: --
410: hr_utility.set_location('pyhkudfs hk_quarters_val', 03);
411: --
412: RETURN v_valid_quarters;
413: --
414: END hk_quarters_val;