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

Line 25: hr_utility.trace('Entering GET_CURRENT_FREQ, p_assignment_id='||p_assignment_id);

21: l_freq per_time_period_types.number_per_fiscal_year%TYPE;
22: --
23: BEGIN
24: --
25: hr_utility.trace('Entering GET_CURRENT_FREQ, p_assignment_id='||p_assignment_id);
26: --
27: OPEN get_freq;
28: FETCH get_freq INTO l_freq;
29: CLOSE get_freq;

Line 31: hr_utility.trace('Leaving GET_CURRENT_FREQ, l_freq='||l_freq);

27: OPEN get_freq;
28: FETCH get_freq INTO l_freq;
29: CLOSE get_freq;
30: --
31: hr_utility.trace('Leaving GET_CURRENT_FREQ, l_freq='||l_freq);
32: RETURN l_freq;
33: END get_current_freq;
34:
35: /*

Line 63: hr_utility.trace('Entering GET_NI_PROCESS_TYPE: p_assignment_id='||p_assignment_id);

59: AND fs.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date;
60: --
61: l_value pay_element_entry_values_f.screen_entry_value%TYPE
62: BEGIN
63: hr_utility.trace('Entering GET_NI_PROCESS_TYPE: p_assignment_id='||p_assignment_id);
64: --
65: OPEN get_value;
66: FETCH get_value INTO l_value;
67: CLOSE get_value;

Line 159: hr_utility.trace('Entering COUNT_MAIN_EAS_ENTRY, assignment_id='||p_assignment_id);

155: AND fs.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
156: AND peev.input_value_id IN (g_eas_main_iv_id, g_eas_ntpp_main_iv_id);
157: --
158: BEGIN
159: hr_utility.trace('Entering COUNT_MAIN_EAS_ENTRY, assignment_id='||p_assignment_id);
160: -- Get tax ref of current asg.
161: OPEN get_asg_tax_ref;
162: FETCH get_asg_tax_ref INTO l_asg_tax_ref;
163: CLOSE get_asg_tax_ref;

Line 165: hr_utility.trace('COUNT_MAIN_EAS_ENTRY: l_asg_tax_ref='||l_asg_tax_ref);

161: OPEN get_asg_tax_ref;
162: FETCH get_asg_tax_ref INTO l_asg_tax_ref;
163: CLOSE get_asg_tax_ref;
164: --
165: hr_utility.trace('COUNT_MAIN_EAS_ENTRY: l_asg_tax_ref='||l_asg_tax_ref);
166: --
167: OPEN get_input_value_id('EAS Scotland');
168: FETCH get_input_value_id INTO g_eas_main_iv_id;
169: CLOSE get_input_value_id;

Line 179: hr_utility.trace('COUNT_MAIN_EAS_ENTRY: After main count, l_count='||l_count);

175: OPEN get_main_count(l_asg_tax_ref);
176: FETCH get_main_count INTO l_count;
177: CLOSE get_main_count;
178: --
179: hr_utility.trace('COUNT_MAIN_EAS_ENTRY: After main count, l_count='||l_count);
180: IF l_count = 0 THEN
181: OPEN chk_prim_asg(l_asg_tax_ref);
182: FETCH chk_prim_asg INTO l_count;
183: IF chk_prim_asg%NOTFOUND THEN

Line 188: hr_utility.trace('COUNT_MAIN_EAS_ENTRY: After check primary asg, l_count='||l_count);

184: l_count := 0;
185: END IF;
186: CLOSE chk_prim_asg;
187: --
188: hr_utility.trace('COUNT_MAIN_EAS_ENTRY: After check primary asg, l_count='||l_count);
189: --
190: END IF;
191: --
192: g_count_main_eas_entry := l_count;

Line 194: hr_utility.trace('Leaving COUNT_MAIN_EAS_ENTRY: l_count='||l_count);

190: END IF;
191: --
192: g_count_main_eas_entry := l_count;
193: --
194: hr_utility.trace('Leaving COUNT_MAIN_EAS_ENTRY: l_count='||l_count);
195: RETURN l_count;
196: END count_main_eas_entry;
197:
198: FUNCTION get_main_eas_pay_date(p_assignment_id IN NUMBER) RETURN DATE IS

Line 286: hr_utility.trace('Entering GET_MAIN_EAS_PAY_DATE, p_assignment_id='||p_assignment_id||', g_asg_id='||g_asg_id);

282: AND ptp.payroll_id = l_payroll_id;
283: --
284: BEGIN
285: --
286: hr_utility.trace('Entering GET_MAIN_EAS_PAY_DATE, p_assignment_id='||p_assignment_id||', g_asg_id='||g_asg_id);
287: --
288: -- Get tax ref of current asg.
289: OPEN get_asg_tax_ref;
290: FETCH get_asg_tax_ref INTO l_asg_tax_ref, l_asg_payroll_id;

Line 297: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: l_asg_tax_ref='||l_asg_tax_ref);

293: OPEN get_asg_period_start_date;
294: FETCH get_asg_period_start_date INTO l_asg_period_start_date;
295: CLOSE get_asg_period_start_date;
296: --
297: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: l_asg_tax_ref='||l_asg_tax_ref);
298: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: l_asg_period_start_date='||fnd_date.date_to_displaydate(l_asg_period_start_date));
299: --
300: IF nvl(p_assignment_id, -1) <> nvl(g_asg_id, -999) THEN
301: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Get count again.');

Line 298: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: l_asg_period_start_date='||fnd_date.date_to_displaydate(l_asg_period_start_date));

294: FETCH get_asg_period_start_date INTO l_asg_period_start_date;
295: CLOSE get_asg_period_start_date;
296: --
297: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: l_asg_tax_ref='||l_asg_tax_ref);
298: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: l_asg_period_start_date='||fnd_date.date_to_displaydate(l_asg_period_start_date));
299: --
300: IF nvl(p_assignment_id, -1) <> nvl(g_asg_id, -999) THEN
301: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Get count again.');
302: l_count := count_main_eas_entry(p_assignment_id);

Line 301: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Get count again.');

297: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: l_asg_tax_ref='||l_asg_tax_ref);
298: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: l_asg_period_start_date='||fnd_date.date_to_displaydate(l_asg_period_start_date));
299: --
300: IF nvl(p_assignment_id, -1) <> nvl(g_asg_id, -999) THEN
301: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Get count again.');
302: l_count := count_main_eas_entry(p_assignment_id);
303: ELSE
304: l_count := g_count_main_eas_entry;
305: END IF;

Line 307: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: l_count='||l_count);

303: ELSE
304: l_count := g_count_main_eas_entry;
305: END IF;
306: --
307: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: l_count='||l_count);
308: --
309: IF nvl(l_count, 0) = 1 THEN
310: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Finding pay date on main entry.');
311: --

Line 310: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Finding pay date on main entry.');

306: --
307: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: l_count='||l_count);
308: --
309: IF nvl(l_count, 0) = 1 THEN
310: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Finding pay date on main entry.');
311: --
312: OPEN get_main_payroll_id;
313: FETCH get_main_payroll_id INTO l_payroll_id;
314: IF get_main_payroll_id%NOTFOUND THEN

Line 315: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Main entry not found.');

311: --
312: OPEN get_main_payroll_id;
313: FETCH get_main_payroll_id INTO l_payroll_id;
314: IF get_main_payroll_id%NOTFOUND THEN
315: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Main entry not found.');
316: l_payroll_id := NULL;
317: END IF;
318: CLOSE get_main_payroll_id;
319: --

Line 321: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Checking primary assignment for payroll id.');

317: END IF;
318: CLOSE get_main_payroll_id;
319: --
320: IF l_payroll_id IS NULL THEN
321: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Checking primary assignment for payroll id.');
322: OPEN get_prim_payroll_id;
323: FETCH get_prim_payroll_id INTO l_payroll_id;
324: IF get_prim_payroll_id%NOTFOUND THEN
325: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Payroll Id not found.');

Line 325: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Payroll Id not found.');

321: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Checking primary assignment for payroll id.');
322: OPEN get_prim_payroll_id;
323: FETCH get_prim_payroll_id INTO l_payroll_id;
324: IF get_prim_payroll_id%NOTFOUND THEN
325: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Payroll Id not found.');
326: l_payroll_id := NULL;
327: END IF;
328: CLOSE get_prim_payroll_id;
329: END IF;

Line 332: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: No Payroll found, Return default date.');

328: CLOSE get_prim_payroll_id;
329: END IF;
330: --
331: IF l_payroll_id IS NULL THEN
332: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: No Payroll found, Return default date.');
333: RETURN to_date('01-01-0001', 'DD-MM-YYYY');
334: ELSE
335: OPEN get_pay_date;
336: FETCH get_pay_date INTO l_pay_date;

Line 338: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Pay date not found, default date.');

334: ELSE
335: OPEN get_pay_date;
336: FETCH get_pay_date INTO l_pay_date;
337: IF get_pay_date%NOTFOUND THEN
338: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Pay date not found, default date.');
339: l_pay_date := to_date('01-01-0001', 'DD-MM-YYYY');
340: END IF;
341: CLOSE get_pay_date;
342: END IF;

Line 344: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Main entry not found, Return default date.');

340: END IF;
341: CLOSE get_pay_date;
342: END IF;
343: ELSE
344: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Main entry not found, Return default date.');
345: l_pay_date := to_date('01-01-0001', 'DD-MM-YYYY');
346: END IF;
347: --
348: hr_utility.trace('Leaving GET_MAIN_EAS_PAY_DATE: l_pay_date='||fnd_date.date_to_displaydate(l_pay_date));

Line 348: hr_utility.trace('Leaving GET_MAIN_EAS_PAY_DATE: l_pay_date='||fnd_date.date_to_displaydate(l_pay_date));

344: hr_utility.trace('GET_MAIN_EAS_PAY_DATE: Main entry not found, Return default date.');
345: l_pay_date := to_date('01-01-0001', 'DD-MM-YYYY');
346: END IF;
347: --
348: hr_utility.trace('Leaving GET_MAIN_EAS_PAY_DATE: l_pay_date='||fnd_date.date_to_displaydate(l_pay_date));
349: RETURN l_pay_date;
350: END get_main_eas_pay_date;
351:
352: FUNCTION get_main_eas_freq(p_assignment_id IN NUMBER) RETURN NUMBER IS

Line 433: hr_utility.trace('Entering GET_MAIN_EAS_FREQ, p_assignment_id='||p_assignment_id||', g_asg_id='||g_asg_id);

429: AND ptp.period_type = ptpt.period_type;
430: --
431: BEGIN
432: --
433: hr_utility.trace('Entering GET_MAIN_EAS_FREQ, p_assignment_id='||p_assignment_id||', g_asg_id='||g_asg_id);
434: --
435: -- Get tax ref of current asg.
436: OPEN get_asg_tax_ref;
437: FETCH get_asg_tax_ref INTO l_asg_tax_ref;

Line 440: hr_utility.trace('GET_MAIN_EAS_FREQ: l_asg_tax_ref='||l_asg_tax_ref);

436: OPEN get_asg_tax_ref;
437: FETCH get_asg_tax_ref INTO l_asg_tax_ref;
438: CLOSE get_asg_tax_ref;
439: --
440: hr_utility.trace('GET_MAIN_EAS_FREQ: l_asg_tax_ref='||l_asg_tax_ref);
441: --
442: IF nvl(p_assignment_id, -1) <> nvl(g_asg_id, -999) THEN
443: hr_utility.trace('GET_MAIN_EAS_FREQ: Get count again.');
444: l_count := count_main_eas_entry(p_assignment_id);

Line 443: hr_utility.trace('GET_MAIN_EAS_FREQ: Get count again.');

439: --
440: hr_utility.trace('GET_MAIN_EAS_FREQ: l_asg_tax_ref='||l_asg_tax_ref);
441: --
442: IF nvl(p_assignment_id, -1) <> nvl(g_asg_id, -999) THEN
443: hr_utility.trace('GET_MAIN_EAS_FREQ: Get count again.');
444: l_count := count_main_eas_entry(p_assignment_id);
445: ELSE
446: l_count := g_count_main_eas_entry;
447: END IF;

Line 449: hr_utility.trace('GET_MAIN_EAS_FREQ: l_count='||l_count);

445: ELSE
446: l_count := g_count_main_eas_entry;
447: END IF;
448: --
449: hr_utility.trace('GET_MAIN_EAS_FREQ: l_count='||l_count);
450: --
451: IF nvl(l_count, 0) = 1 THEN
452: hr_utility.trace('GET_MAIN_EAS_FREQ: Finding frequency on main entry.');
453: --

Line 452: hr_utility.trace('GET_MAIN_EAS_FREQ: Finding frequency on main entry.');

448: --
449: hr_utility.trace('GET_MAIN_EAS_FREQ: l_count='||l_count);
450: --
451: IF nvl(l_count, 0) = 1 THEN
452: hr_utility.trace('GET_MAIN_EAS_FREQ: Finding frequency on main entry.');
453: --
454: OPEN get_main_payroll_id;
455: FETCH get_main_payroll_id INTO l_payroll_id;
456: IF get_main_payroll_id%NOTFOUND THEN

Line 457: hr_utility.trace('GET_MAIN_EAS_FREQ: Main entry not found.');

453: --
454: OPEN get_main_payroll_id;
455: FETCH get_main_payroll_id INTO l_payroll_id;
456: IF get_main_payroll_id%NOTFOUND THEN
457: hr_utility.trace('GET_MAIN_EAS_FREQ: Main entry not found.');
458: l_payroll_id := NULL;
459: END IF;
460: CLOSE get_main_payroll_id;
461: --

Line 463: hr_utility.trace('GET_MAIN_EAS_FREQ: Checking primary assignment for payroll id.');

459: END IF;
460: CLOSE get_main_payroll_id;
461: --
462: IF l_payroll_id IS NULL THEN
463: hr_utility.trace('GET_MAIN_EAS_FREQ: Checking primary assignment for payroll id.');
464: OPEN get_prim_payroll_id;
465: FETCH get_prim_payroll_id INTO l_payroll_id;
466: IF get_prim_payroll_id%NOTFOUND THEN
467: hr_utility.trace('GET_MAIN_EAS_FREQ: Payroll Id not found.');

Line 467: hr_utility.trace('GET_MAIN_EAS_FREQ: Payroll Id not found.');

463: hr_utility.trace('GET_MAIN_EAS_FREQ: Checking primary assignment for payroll id.');
464: OPEN get_prim_payroll_id;
465: FETCH get_prim_payroll_id INTO l_payroll_id;
466: IF get_prim_payroll_id%NOTFOUND THEN
467: hr_utility.trace('GET_MAIN_EAS_FREQ: Payroll Id not found.');
468: l_payroll_id := NULL;
469: END IF;
470: CLOSE get_prim_payroll_id;
471: END IF;

Line 474: hr_utility.trace('GET_MAIN_EAS_FREQ: No Payroll found, Return 0.');

470: CLOSE get_prim_payroll_id;
471: END IF;
472: --
473: IF l_payroll_id IS NULL THEN
474: hr_utility.trace('GET_MAIN_EAS_FREQ: No Payroll found, Return 0.');
475: RETURN 0;
476: ELSE
477: OPEN get_freq;
478: FETCH get_freq INTO l_freq;

Line 480: hr_utility.trace('GET_MAIN_EAS_FREQ: Frequency not found, default to 0.');

476: ELSE
477: OPEN get_freq;
478: FETCH get_freq INTO l_freq;
479: IF get_freq%NOTFOUND THEN
480: hr_utility.trace('GET_MAIN_EAS_FREQ: Frequency not found, default to 0.');
481: l_freq := 0;
482: END IF;
483: CLOSE get_freq;
484: END IF;

Line 487: hr_utility.trace('GET_MAIN_EAS_FREQ: Main entry not found, Return 0.');

483: CLOSE get_freq;
484: END IF;
485: --
486: ELSE
487: hr_utility.trace('GET_MAIN_EAS_FREQ: Main entry not found, Return 0.');
488: l_freq := 0;
489: END IF;
490: --
491: hr_utility.trace('Leaving GET_MAIN_EAS_FREQ: l_freq='||l_freq);

Line 491: hr_utility.trace('Leaving GET_MAIN_EAS_FREQ: l_freq='||l_freq);

487: hr_utility.trace('GET_MAIN_EAS_FREQ: Main entry not found, Return 0.');
488: l_freq := 0;
489: END IF;
490: --
491: hr_utility.trace('Leaving GET_MAIN_EAS_FREQ: l_freq='||l_freq);
492: RETURN l_freq;
493: END get_main_eas_freq;
494:
495: FUNCTION get_main_entry_value(p_assignment_id IN NUMBER,

Line 599: hr_utility.trace('Entering GET_MAIN_ENTRY_VALUE, p_assignment_id='||p_assignment_id||', p_input_value_name='||p_input_value_name);

595: l_value pay_element_entry_values_f.screen_entry_value%TYPE;
596: l_count NUMBER;
597: --
598: BEGIN
599: hr_utility.trace('Entering GET_MAIN_ENTRY_VALUE, p_assignment_id='||p_assignment_id||', p_input_value_name='||p_input_value_name);
600: --
601: -- Get tax ref of current asg.
602: OPEN get_asg_tax_ref;
603: FETCH get_asg_tax_ref INTO l_asg_tax_ref;

Line 606: hr_utility.trace('GET_MAIN_EAS_ENTRY_VALUE: l_asg_tax_ref='||l_asg_tax_ref);

602: OPEN get_asg_tax_ref;
603: FETCH get_asg_tax_ref INTO l_asg_tax_ref;
604: CLOSE get_asg_tax_ref;
605: --
606: hr_utility.trace('GET_MAIN_EAS_ENTRY_VALUE: l_asg_tax_ref='||l_asg_tax_ref);
607: --
608: IF nvl(p_assignment_id, -1) <> nvl(g_asg_id, -999) THEN
609: hr_utility.trace('GET_MAIN_ENTRY_VALUE: Get count again.');
610: l_count := count_main_eas_entry(p_assignment_id);

Line 609: hr_utility.trace('GET_MAIN_ENTRY_VALUE: Get count again.');

605: --
606: hr_utility.trace('GET_MAIN_EAS_ENTRY_VALUE: l_asg_tax_ref='||l_asg_tax_ref);
607: --
608: IF nvl(p_assignment_id, -1) <> nvl(g_asg_id, -999) THEN
609: hr_utility.trace('GET_MAIN_ENTRY_VALUE: Get count again.');
610: l_count := count_main_eas_entry(p_assignment_id);
611: ELSE
612: l_count := g_count_main_eas_entry;
613: END IF;

Line 615: hr_utility.trace('GET_MAIN_ENTRY_VALUE: l_count='||l_count||

611: ELSE
612: l_count := g_count_main_eas_entry;
613: END IF;
614: --
615: hr_utility.trace('GET_MAIN_ENTRY_VALUE: l_count='||l_count||
616: ', g_asg_id='||g_asg_id||
617: ', g_eas_main_iv_id='||g_eas_main_iv_id||
618: ', g_eas_ntpp_main_iv_id='||g_eas_ntpp_main_iv_id);
619: p_count := l_count;

Line 622: hr_utility.trace('GET_MAIN_ENTRY_VALUE: Finding input value on main entry.');

618: ', g_eas_ntpp_main_iv_id='||g_eas_ntpp_main_iv_id);
619: p_count := l_count;
620: --
621: IF nvl(l_count, 0) = 1 THEN
622: hr_utility.trace('GET_MAIN_ENTRY_VALUE: Finding input value on main entry.');
623: --
624: OPEN get_input_value_id('EAS Scotland', p_input_value_name);
625: FETCH get_input_value_id INTO l_eas_iv_id;
626: CLOSE get_input_value_id;

Line 632: hr_utility.trace('GET_MAIN_ENTRY_VALUE: l_eas_iv_id='||l_eas_iv_id||', l_eas_ntpp_iv_id='||l_eas_ntpp_iv_id);

628: OPEN get_input_value_id('EAS Scotland NTPP', p_input_value_name);
629: FETCH get_input_value_id INTO l_eas_ntpp_iv_id;
630: CLOSE get_input_value_id;
631: --
632: hr_utility.trace('GET_MAIN_ENTRY_VALUE: l_eas_iv_id='||l_eas_iv_id||', l_eas_ntpp_iv_id='||l_eas_ntpp_iv_id);
633: --
634: OPEN get_main_entry_id;
635: FETCH get_main_entry_id INTO l_entry_id;
636: hr_utility.trace('GET_MAIN_ENTRY_VALUE: After get_main_entry_id, l_entry_id='||l_entry_id);

Line 636: hr_utility.trace('GET_MAIN_ENTRY_VALUE: After get_main_entry_id, l_entry_id='||l_entry_id);

632: hr_utility.trace('GET_MAIN_ENTRY_VALUE: l_eas_iv_id='||l_eas_iv_id||', l_eas_ntpp_iv_id='||l_eas_ntpp_iv_id);
633: --
634: OPEN get_main_entry_id;
635: FETCH get_main_entry_id INTO l_entry_id;
636: hr_utility.trace('GET_MAIN_ENTRY_VALUE: After get_main_entry_id, l_entry_id='||l_entry_id);
637: IF get_main_entry_id%NOTFOUND THEN
638: hr_utility.trace('GET_MAIN_ENTRY_VALUE: Input value not found on main entry, checking primary assignment.');
639: OPEN chk_prim_entry_id;
640: FETCH chk_prim_entry_id INTO l_entry_id;

Line 638: hr_utility.trace('GET_MAIN_ENTRY_VALUE: Input value not found on main entry, checking primary assignment.');

634: OPEN get_main_entry_id;
635: FETCH get_main_entry_id INTO l_entry_id;
636: hr_utility.trace('GET_MAIN_ENTRY_VALUE: After get_main_entry_id, l_entry_id='||l_entry_id);
637: IF get_main_entry_id%NOTFOUND THEN
638: hr_utility.trace('GET_MAIN_ENTRY_VALUE: Input value not found on main entry, checking primary assignment.');
639: OPEN chk_prim_entry_id;
640: FETCH chk_prim_entry_id INTO l_entry_id;
641: CLOSE chk_prim_entry_id;
642: hr_utility.trace('GET_MAIN_ENTRY_VALUE: After chk_prim_entry_id, l_entry_id='||l_entry_id);

Line 642: hr_utility.trace('GET_MAIN_ENTRY_VALUE: After chk_prim_entry_id, l_entry_id='||l_entry_id);

638: hr_utility.trace('GET_MAIN_ENTRY_VALUE: Input value not found on main entry, checking primary assignment.');
639: OPEN chk_prim_entry_id;
640: FETCH chk_prim_entry_id INTO l_entry_id;
641: CLOSE chk_prim_entry_id;
642: hr_utility.trace('GET_MAIN_ENTRY_VALUE: After chk_prim_entry_id, l_entry_id='||l_entry_id);
643: END IF;
644: CLOSE get_main_entry_id;
645: --
646: hr_utility.trace('GET_MAIN_ENTRY_VALUE: l_elntry_id='||l_entry_id);

Line 646: hr_utility.trace('GET_MAIN_ENTRY_VALUE: l_elntry_id='||l_entry_id);

642: hr_utility.trace('GET_MAIN_ENTRY_VALUE: After chk_prim_entry_id, l_entry_id='||l_entry_id);
643: END IF;
644: CLOSE get_main_entry_id;
645: --
646: hr_utility.trace('GET_MAIN_ENTRY_VALUE: l_elntry_id='||l_entry_id);
647: --
648: OPEN get_value;
649: FETCH get_value INTO l_value;
650: CLOSE get_value;

Line 652: hr_utility.trace('GET_MAIN_ENTRY_VALUE: l_value='||l_value);

648: OPEN get_value;
649: FETCH get_value INTO l_value;
650: CLOSE get_value;
651: --
652: hr_utility.trace('GET_MAIN_ENTRY_VALUE: l_value='||l_value);
653: ELSE
654: l_value := NULL;
655: END IF;
656: --

Line 657: hr_utility.trace('GET_MAIN_ENTRY_VALUE: Returning l_value='||l_value);

653: ELSE
654: l_value := NULL;
655: END IF;
656: --
657: hr_utility.trace('GET_MAIN_ENTRY_VALUE: Returning l_value='||l_value);
658: RETURN l_value;
659: END get_main_entry_value;
660:
661: FUNCTION get_main_initial_debt(p_assignment_id IN NUMBER) RETURN NUMBER IS

Line 665: hr_utility.trace('Entering GET_MAIN_INITIAL_DEBT: p_assignment_id='||p_assignment_id);

661: FUNCTION get_main_initial_debt(p_assignment_id IN NUMBER) RETURN NUMBER IS
662: l_value NUMBER;
663: l_count NUMBER;
664: BEGIN
665: hr_utility.trace('Entering GET_MAIN_INITIAL_DEBT: p_assignment_id='||p_assignment_id);
666: --
667: l_value := nvl(to_number(get_main_entry_value(p_assignment_id, 'Initial Debt', l_count)), 0);
668: --
669: hr_utility.trace('Leaving GET_MAIN_INITIAL_DEBT: l_value='||l_value);

Line 669: hr_utility.trace('Leaving GET_MAIN_INITIAL_DEBT: l_value='||l_value);

665: hr_utility.trace('Entering GET_MAIN_INITIAL_DEBT: p_assignment_id='||p_assignment_id);
666: --
667: l_value := nvl(to_number(get_main_entry_value(p_assignment_id, 'Initial Debt', l_count)), 0);
668: --
669: hr_utility.trace('Leaving GET_MAIN_INITIAL_DEBT: l_value='||l_value);
670: RETURN l_value;
671: END get_main_initial_debt;
672:
673: FUNCTION get_main_fee(p_assignment_id IN NUMBER) RETURN NUMBER IS

Line 677: hr_utility.trace('Entering GET_MAIN_FEE, p_assignment_id='||p_assignment_id);

673: FUNCTION get_main_fee(p_assignment_id IN NUMBER) RETURN NUMBER IS
674: l_value NUMBER;
675: l_count NUMBER;
676: BEGIN
677: hr_utility.trace('Entering GET_MAIN_FEE, p_assignment_id='||p_assignment_id);
678: --
679: l_value := nvl(to_number(get_main_entry_value(p_assignment_id, 'Fee', l_count)), 0);
680: --
681: hr_utility.trace('Leaving GET_MAIN_FEE: l_value='||l_value);

Line 681: hr_utility.trace('Leaving GET_MAIN_FEE: l_value='||l_value);

677: hr_utility.trace('Entering GET_MAIN_FEE, p_assignment_id='||p_assignment_id);
678: --
679: l_value := nvl(to_number(get_main_entry_value(p_assignment_id, 'Fee', l_count)), 0);
680: --
681: hr_utility.trace('Leaving GET_MAIN_FEE: l_value='||l_value);
682: RETURN l_value;
683: END get_main_fee;
684:
685: FUNCTION check_ref(p_assignment_id IN NUMBER, p_reference IN VARCHAR2) RETURN VARCHAR2 IS

Line 689: hr_utility.trace('Entering CHECK_REF, p_assignment_id='||p_assignment_id||

685: FUNCTION check_ref(p_assignment_id IN NUMBER, p_reference IN VARCHAR2) RETURN VARCHAR2 IS
686: l_main_ref pay_element_entry_values_f.screen_entry_value%TYPE;
687: l_count NUMBER;
688: BEGIN
689: hr_utility.trace('Entering CHECK_REF, p_assignment_id='||p_assignment_id||
690: ', p_reference='||p_reference);
691: --
692: l_main_ref := nvl(get_main_entry_value(p_assignment_id, 'Reference', l_count), 'Unknown');
693: hr_utility.trace('CHECK_REF: Main ref='||l_main_ref||', l_count='||l_count);

Line 693: hr_utility.trace('CHECK_REF: Main ref='||l_main_ref||', l_count='||l_count);

689: hr_utility.trace('Entering CHECK_REF, p_assignment_id='||p_assignment_id||
690: ', p_reference='||p_reference);
691: --
692: l_main_ref := nvl(get_main_entry_value(p_assignment_id, 'Reference', l_count), 'Unknown');
693: hr_utility.trace('CHECK_REF: Main ref='||l_main_ref||', l_count='||l_count);
694: --
695: IF nvl(l_count, 0) = 1 AND l_main_ref = p_reference THEN
696: -- Valid reference
697: RETURN 'Y';