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

Line 84: g_debug := hr_utility.debug_enabled;

80: l_proc_name VARCHAR2(100);
81:
82: BEGIN
83:
84: g_debug := hr_utility.debug_enabled;
85:
86: IF g_debug
87: THEN
88: l_proc_name := g_package||'.populate_asg_status_id';

Line 89: hr_utility.set_location('Entering procedure '||l_proc_name,100);

85:
86: IF g_debug
87: THEN
88: l_proc_name := g_package||'.populate_asg_status_id';
89: hr_utility.set_location('Entering procedure '||l_proc_name,100);
90: END IF;
91:
92: IF (NOT cached)
93: THEN

Line 123: hr_utility.set_location('Leaving procedure '||l_proc_name,100);

119: END IF;
120:
121: IF g_debug
122: THEN
123: hr_utility.set_location('Leaving procedure '||l_proc_name,100);
124: END IF;
125:
126: EXCEPTION
127: WHEN raise_no_status_type

Line 129: hr_utility.set_location('Exception No Assignment Status Type Foreign Worker Found '||l_proc_name,100);

125:
126: EXCEPTION
127: WHEN raise_no_status_type
128: THEN
129: hr_utility.set_location('Exception No Assignment Status Type Foreign Worker Found '||l_proc_name,100);
130: CLOSE get_assignment_status_id;
131: raise;
132: END populate_asg_status_id;
133:

Line 157: g_debug := hr_utility.debug_enabled;

153: l_proc_name VARCHAR2(100);
154: l_status_id per_assignment_status_types.assignment_status_type_id%TYPE;
155: BEGIN
156:
157: g_debug := hr_utility.debug_enabled;
158:
159: IF g_debug
160: THEN
161: l_proc_name := g_package||'.get_asg_status_id';

Line 162: hr_utility.set_location('Entering procedure '||l_proc_name,200);

158:
159: IF g_debug
160: THEN
161: l_proc_name := g_package||'.get_asg_status_id';
162: hr_utility.set_location('Entering procedure '||l_proc_name,200);
163: hr_utility.set_location('IN p_fw_type '||p_fw_type,200);
164: END IF;
165:
166: IF (NOT cached)

Line 163: hr_utility.set_location('IN p_fw_type '||p_fw_type,200);

159: IF g_debug
160: THEN
161: l_proc_name := g_package||'.get_asg_status_id';
162: hr_utility.set_location('Entering procedure '||l_proc_name,200);
163: hr_utility.set_location('IN p_fw_type '||p_fw_type,200);
164: END IF;
165:
166: IF (NOT cached)
167: THEN

Line 183: hr_utility.set_location('OUT l_status_id '||l_status_id,200);

179: END IF;
180:
181: IF g_debug
182: THEN
183: hr_utility.set_location('OUT l_status_id '||l_status_id,200);
184: hr_utility.set_location('Leaving procedure '||l_proc_name,200);
185: END IF;
186:
187: RETURN l_status_id;

Line 184: hr_utility.set_location('Leaving procedure '||l_proc_name,200);

180:
181: IF g_debug
182: THEN
183: hr_utility.set_location('OUT l_status_id '||l_status_id,200);
184: hr_utility.set_location('Leaving procedure '||l_proc_name,200);
185: END IF;
186:
187: RETURN l_status_id;
188:

Line 244: g_debug := hr_utility.debug_enabled;

240: l_proc_name VARCHAR2(100);
241:
242: BEGIN
243:
244: g_debug := hr_utility.debug_enabled;
245:
246: IF g_debug
247: THEN
248: l_proc_name := g_package||'.check_foreign_worker';

Line 249: hr_utility.set_location('Entering procedure '||l_proc_name,300);

245:
246: IF g_debug
247: THEN
248: l_proc_name := g_package||'.check_foreign_worker';
249: hr_utility.set_location('Entering procedure '||l_proc_name,300);
250: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,300);
251: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,300);
252: hr_utility.set_location('IN p_start_date '||p_start_date,300);
253: hr_utility.set_location('IN p_end_date '||p_end_date,300);

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

246: IF g_debug
247: THEN
248: l_proc_name := g_package||'.check_foreign_worker';
249: hr_utility.set_location('Entering procedure '||l_proc_name,300);
250: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,300);
251: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,300);
252: hr_utility.set_location('IN p_start_date '||p_start_date,300);
253: hr_utility.set_location('IN p_end_date '||p_end_date,300);
254: hr_utility.set_location('IN p_fw_type '||p_fw_type,300);

Line 251: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,300);

247: THEN
248: l_proc_name := g_package||'.check_foreign_worker';
249: hr_utility.set_location('Entering procedure '||l_proc_name,300);
250: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,300);
251: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,300);
252: hr_utility.set_location('IN p_start_date '||p_start_date,300);
253: hr_utility.set_location('IN p_end_date '||p_end_date,300);
254: hr_utility.set_location('IN p_fw_type '||p_fw_type,300);
255: END IF;

Line 252: hr_utility.set_location('IN p_start_date '||p_start_date,300);

248: l_proc_name := g_package||'.check_foreign_worker';
249: hr_utility.set_location('Entering procedure '||l_proc_name,300);
250: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,300);
251: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,300);
252: hr_utility.set_location('IN p_start_date '||p_start_date,300);
253: hr_utility.set_location('IN p_end_date '||p_end_date,300);
254: hr_utility.set_location('IN p_fw_type '||p_fw_type,300);
255: END IF;
256:

Line 253: hr_utility.set_location('IN p_end_date '||p_end_date,300);

249: hr_utility.set_location('Entering procedure '||l_proc_name,300);
250: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,300);
251: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,300);
252: hr_utility.set_location('IN p_start_date '||p_start_date,300);
253: hr_utility.set_location('IN p_end_date '||p_end_date,300);
254: hr_utility.set_location('IN p_fw_type '||p_fw_type,300);
255: END IF;
256:
257: IF (NOT cached)

Line 254: hr_utility.set_location('IN p_fw_type '||p_fw_type,300);

250: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,300);
251: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,300);
252: hr_utility.set_location('IN p_start_date '||p_start_date,300);
253: hr_utility.set_location('IN p_end_date '||p_end_date,300);
254: hr_utility.set_location('IN p_fw_type '||p_fw_type,300);
255: END IF;
256:
257: IF (NOT cached)
258: THEN

Line 279: hr_utility.set_location('OUT l_return_value '||l_return_value,300);

275: CLOSE is_foreign_worker;
276:
277: IF g_debug
278: THEN
279: hr_utility.set_location('OUT l_return_value '||l_return_value,300);
280: hr_utility.set_location('Leaving procedure '||l_proc_name,300);
281: END IF;
282:
283: RETURN NVL(l_return_value,'N');

Line 280: hr_utility.set_location('Leaving procedure '||l_proc_name,300);

276:
277: IF g_debug
278: THEN
279: hr_utility.set_location('OUT l_return_value '||l_return_value,300);
280: hr_utility.set_location('Leaving procedure '||l_proc_name,300);
281: END IF;
282:
283: RETURN NVL(l_return_value,'N');
284:

Line 314: g_debug := hr_utility.debug_enabled;

310: l_proc_name VARCHAR2(100);
311:
312: BEGIN
313:
314: g_debug := hr_utility.debug_enabled;
315:
316: IF g_debug
317: THEN
318: l_proc_name := g_package||'.check_foreign_worker';

Line 319: hr_utility.set_location('Entering procedure '||l_proc_name,400);

315:
316: IF g_debug
317: THEN
318: l_proc_name := g_package||'.check_foreign_worker';
319: hr_utility.set_location('Entering procedure '||l_proc_name,400);
320: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,400);
321: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,400);
322: hr_utility.set_location('IN p_start_date '||p_start_date,400);
323: hr_utility.set_location('IN p_end_date '||p_end_date,400);

Line 320: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,400);

316: IF g_debug
317: THEN
318: l_proc_name := g_package||'.check_foreign_worker';
319: hr_utility.set_location('Entering procedure '||l_proc_name,400);
320: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,400);
321: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,400);
322: hr_utility.set_location('IN p_start_date '||p_start_date,400);
323: hr_utility.set_location('IN p_end_date '||p_end_date,400);
324: END IF;

Line 321: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,400);

317: THEN
318: l_proc_name := g_package||'.check_foreign_worker';
319: hr_utility.set_location('Entering procedure '||l_proc_name,400);
320: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,400);
321: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,400);
322: hr_utility.set_location('IN p_start_date '||p_start_date,400);
323: hr_utility.set_location('IN p_end_date '||p_end_date,400);
324: END IF;
325:

Line 322: hr_utility.set_location('IN p_start_date '||p_start_date,400);

318: l_proc_name := g_package||'.check_foreign_worker';
319: hr_utility.set_location('Entering procedure '||l_proc_name,400);
320: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,400);
321: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,400);
322: hr_utility.set_location('IN p_start_date '||p_start_date,400);
323: hr_utility.set_location('IN p_end_date '||p_end_date,400);
324: END IF;
325:
326: IF (NOT cached)

Line 323: hr_utility.set_location('IN p_end_date '||p_end_date,400);

319: hr_utility.set_location('Entering procedure '||l_proc_name,400);
320: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,400);
321: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,400);
322: hr_utility.set_location('IN p_start_date '||p_start_date,400);
323: hr_utility.set_location('IN p_end_date '||p_end_date,400);
324: END IF;
325:
326: IF (NOT cached)
327: THEN

Line 352: hr_utility.set_location('OUT l_return_value '||l_return_value,400);

348: END IF;
349:
350: IF g_debug
351: THEN
352: hr_utility.set_location('OUT l_return_value '||l_return_value,400);
353: hr_utility.set_location('Leaving procedure '||l_proc_name,400);
354: END IF;
355:
356: RETURN NVL(l_return_value,'N');

Line 353: hr_utility.set_location('Leaving procedure '||l_proc_name,400);

349:
350: IF g_debug
351: THEN
352: hr_utility.set_location('OUT l_return_value '||l_return_value,400);
353: hr_utility.set_location('Leaving procedure '||l_proc_name,400);
354: END IF;
355:
356: RETURN NVL(l_return_value,'N');
357:

Line 417: g_debug := hr_utility.debug_enabled;

413:
414:
415: BEGIN
416:
417: g_debug := hr_utility.debug_enabled;
418:
419: IF g_debug
420: THEN
421: l_proc_name := g_package||'.check_fw_terminated';

Line 422: hr_utility.set_location('Entering procedure '||l_proc_name,500);

418:
419: IF g_debug
420: THEN
421: l_proc_name := g_package||'.check_fw_terminated';
422: hr_utility.set_location('Entering procedure '||l_proc_name,500);
423: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,500);
424: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,500);
425: hr_utility.set_location('IN p_start_date '||p_start_date,500);
426: hr_utility.set_location('IN p_end_date '||p_end_date,500);

Line 423: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,500);

419: IF g_debug
420: THEN
421: l_proc_name := g_package||'.check_fw_terminated';
422: hr_utility.set_location('Entering procedure '||l_proc_name,500);
423: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,500);
424: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,500);
425: hr_utility.set_location('IN p_start_date '||p_start_date,500);
426: hr_utility.set_location('IN p_end_date '||p_end_date,500);
427: hr_utility.set_location('IN p_fw_type '||p_fw_type,500);

Line 424: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,500);

420: THEN
421: l_proc_name := g_package||'.check_fw_terminated';
422: hr_utility.set_location('Entering procedure '||l_proc_name,500);
423: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,500);
424: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,500);
425: hr_utility.set_location('IN p_start_date '||p_start_date,500);
426: hr_utility.set_location('IN p_end_date '||p_end_date,500);
427: hr_utility.set_location('IN p_fw_type '||p_fw_type,500);
428: END IF;

Line 425: hr_utility.set_location('IN p_start_date '||p_start_date,500);

421: l_proc_name := g_package||'.check_fw_terminated';
422: hr_utility.set_location('Entering procedure '||l_proc_name,500);
423: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,500);
424: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,500);
425: hr_utility.set_location('IN p_start_date '||p_start_date,500);
426: hr_utility.set_location('IN p_end_date '||p_end_date,500);
427: hr_utility.set_location('IN p_fw_type '||p_fw_type,500);
428: END IF;
429:

Line 426: hr_utility.set_location('IN p_end_date '||p_end_date,500);

422: hr_utility.set_location('Entering procedure '||l_proc_name,500);
423: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,500);
424: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,500);
425: hr_utility.set_location('IN p_start_date '||p_start_date,500);
426: hr_utility.set_location('IN p_end_date '||p_end_date,500);
427: hr_utility.set_location('IN p_fw_type '||p_fw_type,500);
428: END IF;
429:
430: IF (NOT cached)

Line 427: hr_utility.set_location('IN p_fw_type '||p_fw_type,500);

423: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,500);
424: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,500);
425: hr_utility.set_location('IN p_start_date '||p_start_date,500);
426: hr_utility.set_location('IN p_end_date '||p_end_date,500);
427: hr_utility.set_location('IN p_fw_type '||p_fw_type,500);
428: END IF;
429:
430: IF (NOT cached)
431: THEN

Line 453: hr_utility.set_location('OUT p_act_term_date '||p_act_term_date,500);

449: CLOSE is_fw_terminated;
450:
451: IF g_debug
452: THEN
453: hr_utility.set_location('OUT p_act_term_date '||p_act_term_date,500);
454: hr_utility.set_location('OUT l_return_value '||l_return_value,500);
455: hr_utility.set_location('Leaving procedure '||l_proc_name,500);
456: END IF;
457:

Line 454: hr_utility.set_location('OUT l_return_value '||l_return_value,500);

450:
451: IF g_debug
452: THEN
453: hr_utility.set_location('OUT p_act_term_date '||p_act_term_date,500);
454: hr_utility.set_location('OUT l_return_value '||l_return_value,500);
455: hr_utility.set_location('Leaving procedure '||l_proc_name,500);
456: END IF;
457:
458: RETURN l_return_value;

Line 455: hr_utility.set_location('Leaving procedure '||l_proc_name,500);

451: IF g_debug
452: THEN
453: hr_utility.set_location('OUT p_act_term_date '||p_act_term_date,500);
454: hr_utility.set_location('OUT l_return_value '||l_return_value,500);
455: hr_utility.set_location('Leaving procedure '||l_proc_name,500);
456: END IF;
457:
458: RETURN l_return_value;
459:

Line 524: g_debug := hr_utility.debug_enabled;

520: l_status_id per_assignment_status_types.assignment_status_type_id%TYPE;
521:
522: BEGIN
523:
524: g_debug := hr_utility.debug_enabled;
525:
526: IF g_debug
527: THEN
528: l_proc_name := g_package||'.get_foreign_worker_dates';

Line 529: hr_utility.set_location('Entering procedure '||l_proc_name,600);

525:
526: IF g_debug
527: THEN
528: l_proc_name := g_package||'.get_foreign_worker_dates';
529: hr_utility.set_location('Entering procedure '||l_proc_name,600);
530: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,600);
531: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,600);
532: END IF;
533:

Line 530: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,600);

526: IF g_debug
527: THEN
528: l_proc_name := g_package||'.get_foreign_worker_dates';
529: hr_utility.set_location('Entering procedure '||l_proc_name,600);
530: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,600);
531: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,600);
532: END IF;
533:
534: IF (NOT cached)

Line 531: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,600);

527: THEN
528: l_proc_name := g_package||'.get_foreign_worker_dates';
529: hr_utility.set_location('Entering procedure '||l_proc_name,600);
530: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,600);
531: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,600);
532: END IF;
533:
534: IF (NOT cached)
535: THEN

Line 640: hr_utility.set_location('i '||i,600);

636: IF p_tab_fw_dates.COUNT > 0
637: THEN
638: FOR i IN p_tab_fw_dates.FIRST..p_tab_fw_dates.LAST
639: LOOP
640: hr_utility.set_location('i '||i,600);
641: hr_utility.set_location('start_date '||p_tab_fw_dates(i).start_date,600);
642: hr_utility.set_location('end_date '||p_tab_fw_dates(i).end_date,600);
643: hr_utility.set_location('payroll_id '||p_tab_fw_dates(i).payroll_id,600);
644: hr_utility.set_location('tax_unit_id '||p_tab_fw_dates(i).tax_unit_id,600);

Line 641: hr_utility.set_location('start_date '||p_tab_fw_dates(i).start_date,600);

637: THEN
638: FOR i IN p_tab_fw_dates.FIRST..p_tab_fw_dates.LAST
639: LOOP
640: hr_utility.set_location('i '||i,600);
641: hr_utility.set_location('start_date '||p_tab_fw_dates(i).start_date,600);
642: hr_utility.set_location('end_date '||p_tab_fw_dates(i).end_date,600);
643: hr_utility.set_location('payroll_id '||p_tab_fw_dates(i).payroll_id,600);
644: hr_utility.set_location('tax_unit_id '||p_tab_fw_dates(i).tax_unit_id,600);
645: END LOOP;

Line 642: hr_utility.set_location('end_date '||p_tab_fw_dates(i).end_date,600);

638: FOR i IN p_tab_fw_dates.FIRST..p_tab_fw_dates.LAST
639: LOOP
640: hr_utility.set_location('i '||i,600);
641: hr_utility.set_location('start_date '||p_tab_fw_dates(i).start_date,600);
642: hr_utility.set_location('end_date '||p_tab_fw_dates(i).end_date,600);
643: hr_utility.set_location('payroll_id '||p_tab_fw_dates(i).payroll_id,600);
644: hr_utility.set_location('tax_unit_id '||p_tab_fw_dates(i).tax_unit_id,600);
645: END LOOP;
646: END IF;

Line 643: hr_utility.set_location('payroll_id '||p_tab_fw_dates(i).payroll_id,600);

639: LOOP
640: hr_utility.set_location('i '||i,600);
641: hr_utility.set_location('start_date '||p_tab_fw_dates(i).start_date,600);
642: hr_utility.set_location('end_date '||p_tab_fw_dates(i).end_date,600);
643: hr_utility.set_location('payroll_id '||p_tab_fw_dates(i).payroll_id,600);
644: hr_utility.set_location('tax_unit_id '||p_tab_fw_dates(i).tax_unit_id,600);
645: END LOOP;
646: END IF;
647: hr_utility.set_location('Leaving procedure '||l_proc_name,600);

Line 644: hr_utility.set_location('tax_unit_id '||p_tab_fw_dates(i).tax_unit_id,600);

640: hr_utility.set_location('i '||i,600);
641: hr_utility.set_location('start_date '||p_tab_fw_dates(i).start_date,600);
642: hr_utility.set_location('end_date '||p_tab_fw_dates(i).end_date,600);
643: hr_utility.set_location('payroll_id '||p_tab_fw_dates(i).payroll_id,600);
644: hr_utility.set_location('tax_unit_id '||p_tab_fw_dates(i).tax_unit_id,600);
645: END LOOP;
646: END IF;
647: hr_utility.set_location('Leaving procedure '||l_proc_name,600);
648: END IF;

Line 647: hr_utility.set_location('Leaving procedure '||l_proc_name,600);

643: hr_utility.set_location('payroll_id '||p_tab_fw_dates(i).payroll_id,600);
644: hr_utility.set_location('tax_unit_id '||p_tab_fw_dates(i).tax_unit_id,600);
645: END LOOP;
646: END IF;
647: hr_utility.set_location('Leaving procedure '||l_proc_name,600);
648: END IF;
649:
650: EXCEPTION
651: WHEN OTHERS then

Line 654: hr_utility.set_location('Error in procedure '||l_proc_name,600);

650: EXCEPTION
651: WHEN OTHERS then
652: IF g_debug
653: THEN
654: hr_utility.set_location('Error in procedure '||l_proc_name,600);
655: END IF;
656:
657: END get_foreign_worker_dates;
658:

Line 701: g_debug := hr_utility.debug_enabled;

697: l_no_def_bal EXCEPTION;
698:
699: BEGIN
700:
701: g_debug := hr_utility.debug_enabled;
702:
703: IF g_debug
704: THEN
705: l_proc_name := g_package||'.get_defined_balances';

Line 706: hr_utility.set_location('Entering procedure '||l_proc_name,1000);

702:
703: IF g_debug
704: THEN
705: l_proc_name := g_package||'.get_defined_balances';
706: hr_utility.set_location('Entering procedure '||l_proc_name,1000);
707: END IF;
708:
709: l_def_bal_tab.DELETE;
710: IF p_balances_tab.COUNT > 0

Line 737: hr_utility.set_location('Leaving procedure '||l_proc_name,1000);

733: p_def_bal_tab := l_def_bal_tab;
734:
735: IF g_debug
736: THEN
737: hr_utility.set_location('Leaving procedure '||l_proc_name,1000);
738: END IF;
739: EXCEPTION
740: WHEN l_no_def_bal THEN
741: hr_utility.set_location('Exception in procedure '||l_proc_name,1000);

Line 741: hr_utility.set_location('Exception in procedure '||l_proc_name,1000);

737: hr_utility.set_location('Leaving procedure '||l_proc_name,1000);
738: END IF;
739: EXCEPTION
740: WHEN l_no_def_bal THEN
741: hr_utility.set_location('Exception in procedure '||l_proc_name,1000);
742: hr_utility.set_location('Defined Balance not found for Bal Type ID '||l_def_bal_id||' and Dimension '||p_dimension_name,1000);
743: raise;
744: WHEN OTHERS THEN
745: hr_utility.set_location('Exception others in procedure '||l_proc_name,1000);

Line 742: hr_utility.set_location('Defined Balance not found for Bal Type ID '||l_def_bal_id||' and Dimension '||p_dimension_name,1000);

738: END IF;
739: EXCEPTION
740: WHEN l_no_def_bal THEN
741: hr_utility.set_location('Exception in procedure '||l_proc_name,1000);
742: hr_utility.set_location('Defined Balance not found for Bal Type ID '||l_def_bal_id||' and Dimension '||p_dimension_name,1000);
743: raise;
744: WHEN OTHERS THEN
745: hr_utility.set_location('Exception others in procedure '||l_proc_name,1000);
746: END get_defined_balances;

Line 745: hr_utility.set_location('Exception others in procedure '||l_proc_name,1000);

741: hr_utility.set_location('Exception in procedure '||l_proc_name,1000);
742: hr_utility.set_location('Defined Balance not found for Bal Type ID '||l_def_bal_id||' and Dimension '||p_dimension_name,1000);
743: raise;
744: WHEN OTHERS THEN
745: hr_utility.set_location('Exception others in procedure '||l_proc_name,1000);
746: END get_defined_balances;
747:
748: /*
749: Name : is_le_changed

Line 795: g_debug := hr_utility.debug_enabled;

791: l_procedure VARCHAR2(200);
792:
793: BEGIN
794:
795: g_debug := hr_utility.debug_enabled;
796: IF g_debug
797: THEN
798: l_procedure := g_package||'.is_le_changed';
799: hr_utility.set_location('In procedure '||l_procedure,1000);

Line 799: hr_utility.set_location('In procedure '||l_procedure,1000);

795: g_debug := hr_utility.debug_enabled;
796: IF g_debug
797: THEN
798: l_procedure := g_package||'.is_le_changed';
799: hr_utility.set_location('In procedure '||l_procedure,1000);
800: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,1000);
801: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,1000);
802: hr_utility.set_location('IN p_time_period_id '||p_time_period_id,1000);
803: END IF;

Line 800: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,1000);

796: IF g_debug
797: THEN
798: l_procedure := g_package||'.is_le_changed';
799: hr_utility.set_location('In procedure '||l_procedure,1000);
800: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,1000);
801: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,1000);
802: hr_utility.set_location('IN p_time_period_id '||p_time_period_id,1000);
803: END IF;
804:

Line 801: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,1000);

797: THEN
798: l_procedure := g_package||'.is_le_changed';
799: hr_utility.set_location('In procedure '||l_procedure,1000);
800: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,1000);
801: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,1000);
802: hr_utility.set_location('IN p_time_period_id '||p_time_period_id,1000);
803: END IF;
804:
805: OPEN other_le_exists(p_assignment_id

Line 802: hr_utility.set_location('IN p_time_period_id '||p_time_period_id,1000);

798: l_procedure := g_package||'.is_le_changed';
799: hr_utility.set_location('In procedure '||l_procedure,1000);
800: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,1000);
801: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,1000);
802: hr_utility.set_location('IN p_time_period_id '||p_time_period_id,1000);
803: END IF;
804:
805: OPEN other_le_exists(p_assignment_id
806: ,p_tax_unit_id

Line 820: hr_utility.set_location('OUT l_return_value '||l_return_value,1000);

816: l_return_value := NVL(l_return_value,'N');
817:
818: IF g_debug
819: THEN
820: hr_utility.set_location('OUT l_return_value '||l_return_value,1000);
821: hr_utility.set_location('Leaving procedure '||l_procedure,1000);
822: END IF;
823:
824: RETURN l_return_value;

Line 821: hr_utility.set_location('Leaving procedure '||l_procedure,1000);

817:
818: IF g_debug
819: THEN
820: hr_utility.set_location('OUT l_return_value '||l_return_value,1000);
821: hr_utility.set_location('Leaving procedure '||l_procedure,1000);
822: END IF;
823:
824: RETURN l_return_value;
825:

Line 913: g_debug := hr_utility.debug_enabled;

909: LE is active as on end of period (31-Jan-2010) - Check the days marked as Foreign Worker
910: in period irrespective of LE and return as prorate factor.
911: */
912:
913: g_debug := hr_utility.debug_enabled;
914: IF g_debug
915: THEN
916: l_procedure := g_package||'.get_le_changed_prorate_factor';
917: hr_utility.set_location('In procedure '||l_procedure,1000);

Line 917: hr_utility.set_location('In procedure '||l_procedure,1000);

913: g_debug := hr_utility.debug_enabled;
914: IF g_debug
915: THEN
916: l_procedure := g_package||'.get_le_changed_prorate_factor';
917: hr_utility.set_location('In procedure '||l_procedure,1000);
918: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,1000);
919: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,1000);
920: hr_utility.set_location('IN p_time_period_id '||p_time_period_id,1000);
921: hr_utility.set_location('IN p_fw_type '||p_fw_type,1000);

Line 918: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,1000);

914: IF g_debug
915: THEN
916: l_procedure := g_package||'.get_le_changed_prorate_factor';
917: hr_utility.set_location('In procedure '||l_procedure,1000);
918: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,1000);
919: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,1000);
920: hr_utility.set_location('IN p_time_period_id '||p_time_period_id,1000);
921: hr_utility.set_location('IN p_fw_type '||p_fw_type,1000);
922: END IF;

Line 919: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,1000);

915: THEN
916: l_procedure := g_package||'.get_le_changed_prorate_factor';
917: hr_utility.set_location('In procedure '||l_procedure,1000);
918: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,1000);
919: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,1000);
920: hr_utility.set_location('IN p_time_period_id '||p_time_period_id,1000);
921: hr_utility.set_location('IN p_fw_type '||p_fw_type,1000);
922: END IF;
923:

Line 920: hr_utility.set_location('IN p_time_period_id '||p_time_period_id,1000);

916: l_procedure := g_package||'.get_le_changed_prorate_factor';
917: hr_utility.set_location('In procedure '||l_procedure,1000);
918: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,1000);
919: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,1000);
920: hr_utility.set_location('IN p_time_period_id '||p_time_period_id,1000);
921: hr_utility.set_location('IN p_fw_type '||p_fw_type,1000);
922: END IF;
923:
924: l_status_id := get_asg_status_id(p_fw_type);

Line 921: hr_utility.set_location('IN p_fw_type '||p_fw_type,1000);

917: hr_utility.set_location('In procedure '||l_procedure,1000);
918: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,1000);
919: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,1000);
920: hr_utility.set_location('IN p_time_period_id '||p_time_period_id,1000);
921: hr_utility.set_location('IN p_fw_type '||p_fw_type,1000);
922: END IF;
923:
924: l_status_id := get_asg_status_id(p_fw_type);
925:

Line 956: hr_utility.set_location('OUT l_return_value '||l_return_value,1000);

952: END IF;
953:
954: IF g_debug
955: THEN
956: hr_utility.set_location('OUT l_return_value '||l_return_value,1000);
957: hr_utility.set_location('Leaving procedure '||l_procedure,1000);
958: END IF;
959:
960: RETURN l_return_value;

Line 957: hr_utility.set_location('Leaving procedure '||l_procedure,1000);

953:
954: IF g_debug
955: THEN
956: hr_utility.set_location('OUT l_return_value '||l_return_value,1000);
957: hr_utility.set_location('Leaving procedure '||l_procedure,1000);
958: END IF;
959:
960: RETURN l_return_value;
961:

Line 1114: g_debug := hr_utility.debug_enabled;

1110: l_gen NUMBER; /* Anitha - remove it later */
1111:
1112: BEGIN
1113:
1114: g_debug := hr_utility.debug_enabled;
1115:
1116: IF g_debug
1117: THEN
1118: l_proc_name := g_package||'get_foreign_payment_amounts';

Line 1119: hr_utility.set_location('Entering l_proc_name '||l_proc_name,1000);

1115:
1116: IF g_debug
1117: THEN
1118: l_proc_name := g_package||'get_foreign_payment_amounts';
1119: hr_utility.set_location('Entering l_proc_name '||l_proc_name,1000);
1120: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,1000);
1121: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,1000);
1122: END IF;
1123:

Line 1120: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,1000);

1116: IF g_debug
1117: THEN
1118: l_proc_name := g_package||'get_foreign_payment_amounts';
1119: hr_utility.set_location('Entering l_proc_name '||l_proc_name,1000);
1120: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,1000);
1121: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,1000);
1122: END IF;
1123:
1124: IF (NOT cached)

Line 1121: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,1000);

1117: THEN
1118: l_proc_name := g_package||'get_foreign_payment_amounts';
1119: hr_utility.set_location('Entering l_proc_name '||l_proc_name,1000);
1120: hr_utility.set_location('IN p_assignment_id '||p_assignment_id,1000);
1121: hr_utility.set_location('IN p_tax_unit_id '||p_tax_unit_id,1000);
1122: END IF;
1123:
1124: IF (NOT cached)
1125: THEN

Line 1252: hr_utility.set_location('l_time_period_id '||l_time_period_id,1000);

1248: l_time_period_id := l_prorate_tab.FIRST;
1249:
1250: WHILE ( l_time_period_id IS NOT NULL)
1251: LOOP
1252: hr_utility.set_location('l_time_period_id '||l_time_period_id,1000);
1253: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_start '||l_prorate_tab(l_time_period_id).prorate_start,1000);
1254: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_end '||l_prorate_tab(l_time_period_id).prorate_end,1000);
1255: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_factor '||l_prorate_tab(l_time_period_id).prorate_factor,1000);
1256: hr_utility.set_location('l_prorate_tab(l_time_period_id).number_of_periods '||l_prorate_tab(l_time_period_id).number_of_periods,1000);

Line 1253: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_start '||l_prorate_tab(l_time_period_id).prorate_start,1000);

1249:
1250: WHILE ( l_time_period_id IS NOT NULL)
1251: LOOP
1252: hr_utility.set_location('l_time_period_id '||l_time_period_id,1000);
1253: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_start '||l_prorate_tab(l_time_period_id).prorate_start,1000);
1254: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_end '||l_prorate_tab(l_time_period_id).prorate_end,1000);
1255: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_factor '||l_prorate_tab(l_time_period_id).prorate_factor,1000);
1256: hr_utility.set_location('l_prorate_tab(l_time_period_id).number_of_periods '||l_prorate_tab(l_time_period_id).number_of_periods,1000);
1257: l_time_period_id := l_prorate_tab.NEXT(l_time_period_id);

Line 1254: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_end '||l_prorate_tab(l_time_period_id).prorate_end,1000);

1250: WHILE ( l_time_period_id IS NOT NULL)
1251: LOOP
1252: hr_utility.set_location('l_time_period_id '||l_time_period_id,1000);
1253: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_start '||l_prorate_tab(l_time_period_id).prorate_start,1000);
1254: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_end '||l_prorate_tab(l_time_period_id).prorate_end,1000);
1255: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_factor '||l_prorate_tab(l_time_period_id).prorate_factor,1000);
1256: hr_utility.set_location('l_prorate_tab(l_time_period_id).number_of_periods '||l_prorate_tab(l_time_period_id).number_of_periods,1000);
1257: l_time_period_id := l_prorate_tab.NEXT(l_time_period_id);
1258: END LOOP;

Line 1255: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_factor '||l_prorate_tab(l_time_period_id).prorate_factor,1000);

1251: LOOP
1252: hr_utility.set_location('l_time_period_id '||l_time_period_id,1000);
1253: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_start '||l_prorate_tab(l_time_period_id).prorate_start,1000);
1254: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_end '||l_prorate_tab(l_time_period_id).prorate_end,1000);
1255: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_factor '||l_prorate_tab(l_time_period_id).prorate_factor,1000);
1256: hr_utility.set_location('l_prorate_tab(l_time_period_id).number_of_periods '||l_prorate_tab(l_time_period_id).number_of_periods,1000);
1257: l_time_period_id := l_prorate_tab.NEXT(l_time_period_id);
1258: END LOOP;
1259:

Line 1256: hr_utility.set_location('l_prorate_tab(l_time_period_id).number_of_periods '||l_prorate_tab(l_time_period_id).number_of_periods,1000);

1252: hr_utility.set_location('l_time_period_id '||l_time_period_id,1000);
1253: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_start '||l_prorate_tab(l_time_period_id).prorate_start,1000);
1254: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_end '||l_prorate_tab(l_time_period_id).prorate_end,1000);
1255: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_factor '||l_prorate_tab(l_time_period_id).prorate_factor,1000);
1256: hr_utility.set_location('l_prorate_tab(l_time_period_id).number_of_periods '||l_prorate_tab(l_time_period_id).number_of_periods,1000);
1257: l_time_period_id := l_prorate_tab.NEXT(l_time_period_id);
1258: END LOOP;
1259:
1260: END IF;

Line 1294: hr_utility.set_location('l_time_period_id '||l_time_period_id,1000);

1290: ,p_output_table => l_return_tab);
1291:
1292: IF g_debug
1293: THEN
1294: hr_utility.set_location('l_time_period_id '||l_time_period_id,1000);
1295: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_start '||l_prorate_tab(l_time_period_id).prorate_start,1000);
1296: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_end '||l_prorate_tab(l_time_period_id).prorate_end,1000);
1297: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_factor '||l_prorate_tab(l_time_period_id).prorate_factor,1000);
1298: hr_utility.set_location('l_prorate_tab(l_time_period_id).number_of_periods '||l_prorate_tab(l_time_period_id).number_of_periods,1000);

Line 1295: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_start '||l_prorate_tab(l_time_period_id).prorate_start,1000);

1291:
1292: IF g_debug
1293: THEN
1294: hr_utility.set_location('l_time_period_id '||l_time_period_id,1000);
1295: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_start '||l_prorate_tab(l_time_period_id).prorate_start,1000);
1296: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_end '||l_prorate_tab(l_time_period_id).prorate_end,1000);
1297: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_factor '||l_prorate_tab(l_time_period_id).prorate_factor,1000);
1298: hr_utility.set_location('l_prorate_tab(l_time_period_id).number_of_periods '||l_prorate_tab(l_time_period_id).number_of_periods,1000);
1299: END IF;

Line 1296: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_end '||l_prorate_tab(l_time_period_id).prorate_end,1000);

1292: IF g_debug
1293: THEN
1294: hr_utility.set_location('l_time_period_id '||l_time_period_id,1000);
1295: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_start '||l_prorate_tab(l_time_period_id).prorate_start,1000);
1296: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_end '||l_prorate_tab(l_time_period_id).prorate_end,1000);
1297: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_factor '||l_prorate_tab(l_time_period_id).prorate_factor,1000);
1298: hr_utility.set_location('l_prorate_tab(l_time_period_id).number_of_periods '||l_prorate_tab(l_time_period_id).number_of_periods,1000);
1299: END IF;
1300:

Line 1297: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_factor '||l_prorate_tab(l_time_period_id).prorate_factor,1000);

1293: THEN
1294: hr_utility.set_location('l_time_period_id '||l_time_period_id,1000);
1295: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_start '||l_prorate_tab(l_time_period_id).prorate_start,1000);
1296: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_end '||l_prorate_tab(l_time_period_id).prorate_end,1000);
1297: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_factor '||l_prorate_tab(l_time_period_id).prorate_factor,1000);
1298: hr_utility.set_location('l_prorate_tab(l_time_period_id).number_of_periods '||l_prorate_tab(l_time_period_id).number_of_periods,1000);
1299: END IF;
1300:
1301: /* Alter proration Factor if Balance 'Foreign Days Worked' is set in period */

Line 1298: hr_utility.set_location('l_prorate_tab(l_time_period_id).number_of_periods '||l_prorate_tab(l_time_period_id).number_of_periods,1000);

1294: hr_utility.set_location('l_time_period_id '||l_time_period_id,1000);
1295: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_start '||l_prorate_tab(l_time_period_id).prorate_start,1000);
1296: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_end '||l_prorate_tab(l_time_period_id).prorate_end,1000);
1297: hr_utility.set_location('l_prorate_tab(l_time_period_id).prorate_factor '||l_prorate_tab(l_time_period_id).prorate_factor,1000);
1298: hr_utility.set_location('l_prorate_tab(l_time_period_id).number_of_periods '||l_prorate_tab(l_time_period_id).number_of_periods,1000);
1299: END IF;
1300:
1301: /* Alter proration Factor if Balance 'Foreign Days Worked' is set in period */
1302: IF (NVL(l_return_tab(l_fw_days_index).balance_value,0) > 0) /* Assume its always postive */

Line 1307: hr_utility.set_location('Adjusted prorate_factor '||l_prorate_tab(l_time_period_id).prorate_factor,1000);

1303: THEN
1304: l_prorate_tab(l_time_period_id).prorate_factor := NVL(l_return_tab(l_fw_days_index).balance_value,0)/l_prorate_tab(l_time_period_id).denom_factor;
1305: IF g_debug
1306: THEN
1307: hr_utility.set_location('Adjusted prorate_factor '||l_prorate_tab(l_time_period_id).prorate_factor,1000);
1308: END IF;
1309: END IF;
1310:
1311: FOR i IN l_output_tab.FIRST..l_output_tab.LAST

Line 1319: hr_utility.set_location('Anitha Value '||l_gen,1000);

1315: NVL(l_return_tab(i).balance_value,0) *
1316: l_prorate_tab(l_time_period_id).prorate_factor;
1317: l_gen := NVL(l_return_tab(i).balance_value,0) *
1318: l_prorate_tab(l_time_period_id).prorate_factor;
1319: hr_utility.set_location('Anitha Value '||l_gen,1000);
1320: END LOOP;
1321:
1322: l_time_period_id := l_prorate_tab.NEXT(l_time_period_id);
1323:

Line 1328: hr_utility.set_location('l_output_tab.defined_balance_id '||l_output_tab(i).defined_balance_id,1000);

1324: END LOOP;
1325:
1326: FOR i IN l_output_tab.FIRST..l_output_tab.LAST
1327: LOOP
1328: hr_utility.set_location('l_output_tab.defined_balance_id '||l_output_tab(i).defined_balance_id,1000);
1329: hr_utility.set_location('l_output_tab.balance_value '||l_output_tab(i).balance_value,1000);
1330: END LOOP;
1331: ELSE
1332: IF g_debug

Line 1329: hr_utility.set_location('l_output_tab.balance_value '||l_output_tab(i).balance_value,1000);

1325:
1326: FOR i IN l_output_tab.FIRST..l_output_tab.LAST
1327: LOOP
1328: hr_utility.set_location('l_output_tab.defined_balance_id '||l_output_tab(i).defined_balance_id,1000);
1329: hr_utility.set_location('l_output_tab.balance_value '||l_output_tab(i).balance_value,1000);
1330: END LOOP;
1331: ELSE
1332: IF g_debug
1333: THEN

Line 1334: hr_utility.set_location('Count = 0, no processing done!',1000);

1330: END LOOP;
1331: ELSE
1332: IF g_debug
1333: THEN
1334: hr_utility.set_location('Count = 0, no processing done!',1000);
1335: END IF;
1336: END IF; /* End Count Check */
1337:
1338: p_output_table := l_output_tab;

Line 1344: hr_utility.set_location('Leaving l_proc_name '||l_proc_name,1000);

1340: END IF; /* Not YTD case check */
1341:
1342: IF g_debug
1343: THEN
1344: hr_utility.set_location('Leaving l_proc_name '||l_proc_name,1000);
1345: END IF;
1346:
1347: END get_foreign_payment_amounts;
1348:

Line 1379: g_debug := hr_utility.debug_enabled;

1375: i_index NUMBER;
1376:
1377: BEGIN
1378:
1379: g_debug := hr_utility.debug_enabled;
1380: IF g_debug
1381: THEN
1382: l_procedure := g_package||'.get_fw_between_dates';
1383: hr_utility.set_location('Entering l_procedure '||l_procedure,1200);

Line 1383: hr_utility.set_location('Entering l_procedure '||l_procedure,1200);

1379: g_debug := hr_utility.debug_enabled;
1380: IF g_debug
1381: THEN
1382: l_procedure := g_package||'.get_fw_between_dates';
1383: hr_utility.set_location('Entering l_procedure '||l_procedure,1200);
1384: END IF;
1385:
1386: IF p_fw_tab_dates.COUNT > 0
1387: THEN

Line 1417: hr_utility.set_location('l_result_tab_dates(i_index).start_date '||l_result_tab_dates(i).start_date,1200);

1413: IF l_result_tab_dates.COUNT > 0
1414: THEN
1415: FOR i IN l_result_tab_dates.FIRST..l_result_tab_dates.LAST
1416: LOOP
1417: hr_utility.set_location('l_result_tab_dates(i_index).start_date '||l_result_tab_dates(i).start_date,1200);
1418: hr_utility.set_location('l_result_tab_dates(i_index).end_date '||l_result_tab_dates(i).end_date,1200);
1419: END LOOP;
1420: END IF;
1421: hr_utility.set_location('Leaving l_procedure '||l_procedure,1200);

Line 1418: hr_utility.set_location('l_result_tab_dates(i_index).end_date '||l_result_tab_dates(i).end_date,1200);

1414: THEN
1415: FOR i IN l_result_tab_dates.FIRST..l_result_tab_dates.LAST
1416: LOOP
1417: hr_utility.set_location('l_result_tab_dates(i_index).start_date '||l_result_tab_dates(i).start_date,1200);
1418: hr_utility.set_location('l_result_tab_dates(i_index).end_date '||l_result_tab_dates(i).end_date,1200);
1419: END LOOP;
1420: END IF;
1421: hr_utility.set_location('Leaving l_procedure '||l_procedure,1200);
1422: END IF;

Line 1421: hr_utility.set_location('Leaving l_procedure '||l_procedure,1200);

1417: hr_utility.set_location('l_result_tab_dates(i_index).start_date '||l_result_tab_dates(i).start_date,1200);
1418: hr_utility.set_location('l_result_tab_dates(i_index).end_date '||l_result_tab_dates(i).end_date,1200);
1419: END LOOP;
1420: END IF;
1421: hr_utility.set_location('Leaving l_procedure '||l_procedure,1200);
1422: END IF;
1423:
1424: p_result_tab_dates := l_result_tab_dates;
1425: