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_IE_MEDICAL_ADJUST dependencies on FND_FILE

Line 74: fnd_file.put_line(FND_FILE.LOG,'Value of p_bg_id is '||p_bg_id);

70:
71: BEGIN
72:
73: hr_utility.set_location('Entering '||g_package||l_proc_name,2000);
74: fnd_file.put_line(FND_FILE.LOG,'Value of p_bg_id is '||p_bg_id);
75: fnd_file.put_line(FND_FILE.LOG,'Value of p_eff_date is '||p_eff_date);
76: fnd_file.put_line(FND_FILE.LOG,'Value of p_asg_id is '||p_asg_id);
77: fnd_file.put_line(FND_FILE.LOG,'Value of p_benefit_type is '||p_benefit_type);
78: fnd_file.put_line(FND_FILE.LOG,'Value of p_validate_commit is '||p_validate_commit);

Line 75: fnd_file.put_line(FND_FILE.LOG,'Value of p_eff_date is '||p_eff_date);

71: BEGIN
72:
73: hr_utility.set_location('Entering '||g_package||l_proc_name,2000);
74: fnd_file.put_line(FND_FILE.LOG,'Value of p_bg_id is '||p_bg_id);
75: fnd_file.put_line(FND_FILE.LOG,'Value of p_eff_date is '||p_eff_date);
76: fnd_file.put_line(FND_FILE.LOG,'Value of p_asg_id is '||p_asg_id);
77: fnd_file.put_line(FND_FILE.LOG,'Value of p_benefit_type is '||p_benefit_type);
78: fnd_file.put_line(FND_FILE.LOG,'Value of p_validate_commit is '||p_validate_commit);
79:

Line 76: fnd_file.put_line(FND_FILE.LOG,'Value of p_asg_id is '||p_asg_id);

72:
73: hr_utility.set_location('Entering '||g_package||l_proc_name,2000);
74: fnd_file.put_line(FND_FILE.LOG,'Value of p_bg_id is '||p_bg_id);
75: fnd_file.put_line(FND_FILE.LOG,'Value of p_eff_date is '||p_eff_date);
76: fnd_file.put_line(FND_FILE.LOG,'Value of p_asg_id is '||p_asg_id);
77: fnd_file.put_line(FND_FILE.LOG,'Value of p_benefit_type is '||p_benefit_type);
78: fnd_file.put_line(FND_FILE.LOG,'Value of p_validate_commit is '||p_validate_commit);
79:
80: --

Line 77: fnd_file.put_line(FND_FILE.LOG,'Value of p_benefit_type is '||p_benefit_type);

73: hr_utility.set_location('Entering '||g_package||l_proc_name,2000);
74: fnd_file.put_line(FND_FILE.LOG,'Value of p_bg_id is '||p_bg_id);
75: fnd_file.put_line(FND_FILE.LOG,'Value of p_eff_date is '||p_eff_date);
76: fnd_file.put_line(FND_FILE.LOG,'Value of p_asg_id is '||p_asg_id);
77: fnd_file.put_line(FND_FILE.LOG,'Value of p_benefit_type is '||p_benefit_type);
78: fnd_file.put_line(FND_FILE.LOG,'Value of p_validate_commit is '||p_validate_commit);
79:
80: --
81: -- Get Element information

Line 78: fnd_file.put_line(FND_FILE.LOG,'Value of p_validate_commit is '||p_validate_commit);

74: fnd_file.put_line(FND_FILE.LOG,'Value of p_bg_id is '||p_bg_id);
75: fnd_file.put_line(FND_FILE.LOG,'Value of p_eff_date is '||p_eff_date);
76: fnd_file.put_line(FND_FILE.LOG,'Value of p_asg_id is '||p_asg_id);
77: fnd_file.put_line(FND_FILE.LOG,'Value of p_benefit_type is '||p_benefit_type);
78: fnd_file.put_line(FND_FILE.LOG,'Value of p_validate_commit is '||p_validate_commit);
79:
80: --
81: -- Get Element information
82: --

Line 267: --fnd_file.put_line(fnd_file.log,'p_bg_id: '||p_bg_id||' p_eff_date: '||p_eff_date||' p_asg_id: '||p_asg_id||' p_benefit_type: '||p_benefit_type||' p_validate_commit: '||p_validate_commit);

263: hr_utility.set_location('p_asg_id '||p_asg_id,1005);
264: hr_utility.set_location('p_benefit_type '||p_benefit_type,1005);
265: hr_utility.set_location('p_validate_commit '||p_validate_commit,1005);
266:
267: --fnd_file.put_line(fnd_file.log,'p_bg_id: '||p_bg_id||' p_eff_date: '||p_eff_date||' p_asg_id: '||p_asg_id||' p_benefit_type: '||p_benefit_type||' p_validate_commit: '||p_validate_commit);
268:
269: retcode := 0;
270: l_effective_date := fnd_date.canonical_to_date(p_eff_date);
271:

Line 276: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);

272: hr_utility.set_location('l_effective_date'||to_char(l_effective_date),1010);
273: hr_utility.set_location('Deleting PL table l_Med_pl_table',1010);
274: l_Med_pl_table.delete;
275:
276: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
277: fnd_file.put_line(FND_FILE.OUTPUT,'Date:'||to_char(l_effective_date)||' IE Medical Insurance Upgrade Process');
278: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
279: fnd_file.put_line(FND_FILE.OUTPUT,' ');
280:

Line 277: fnd_file.put_line(FND_FILE.OUTPUT,'Date:'||to_char(l_effective_date)||' IE Medical Insurance Upgrade Process');

273: hr_utility.set_location('Deleting PL table l_Med_pl_table',1010);
274: l_Med_pl_table.delete;
275:
276: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
277: fnd_file.put_line(FND_FILE.OUTPUT,'Date:'||to_char(l_effective_date)||' IE Medical Insurance Upgrade Process');
278: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
279: fnd_file.put_line(FND_FILE.OUTPUT,' ');
280:
281: fnd_file.put_line(FND_FILE.LOG,l_under_line);

Line 278: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);

274: l_Med_pl_table.delete;
275:
276: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
277: fnd_file.put_line(FND_FILE.OUTPUT,'Date:'||to_char(l_effective_date)||' IE Medical Insurance Upgrade Process');
278: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
279: fnd_file.put_line(FND_FILE.OUTPUT,' ');
280:
281: fnd_file.put_line(FND_FILE.LOG,l_under_line);
282: fnd_file.put_line(FND_FILE.LOG,'Date:'||to_char(l_effective_date)||' IE Medical Insurance Upgrade Process');

Line 279: fnd_file.put_line(FND_FILE.OUTPUT,' ');

275:
276: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
277: fnd_file.put_line(FND_FILE.OUTPUT,'Date:'||to_char(l_effective_date)||' IE Medical Insurance Upgrade Process');
278: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
279: fnd_file.put_line(FND_FILE.OUTPUT,' ');
280:
281: fnd_file.put_line(FND_FILE.LOG,l_under_line);
282: fnd_file.put_line(FND_FILE.LOG,'Date:'||to_char(l_effective_date)||' IE Medical Insurance Upgrade Process');
283: fnd_file.put_line(FND_FILE.LOG,l_under_line);

Line 281: fnd_file.put_line(FND_FILE.LOG,l_under_line);

277: fnd_file.put_line(FND_FILE.OUTPUT,'Date:'||to_char(l_effective_date)||' IE Medical Insurance Upgrade Process');
278: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
279: fnd_file.put_line(FND_FILE.OUTPUT,' ');
280:
281: fnd_file.put_line(FND_FILE.LOG,l_under_line);
282: fnd_file.put_line(FND_FILE.LOG,'Date:'||to_char(l_effective_date)||' IE Medical Insurance Upgrade Process');
283: fnd_file.put_line(FND_FILE.LOG,l_under_line);
284: fnd_file.put_line(FND_FILE.LOG,' ');
285:

Line 282: fnd_file.put_line(FND_FILE.LOG,'Date:'||to_char(l_effective_date)||' IE Medical Insurance Upgrade Process');

278: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
279: fnd_file.put_line(FND_FILE.OUTPUT,' ');
280:
281: fnd_file.put_line(FND_FILE.LOG,l_under_line);
282: fnd_file.put_line(FND_FILE.LOG,'Date:'||to_char(l_effective_date)||' IE Medical Insurance Upgrade Process');
283: fnd_file.put_line(FND_FILE.LOG,l_under_line);
284: fnd_file.put_line(FND_FILE.LOG,' ');
285:
286: l_assignment_id := p_asg_id;

Line 283: fnd_file.put_line(FND_FILE.LOG,l_under_line);

279: fnd_file.put_line(FND_FILE.OUTPUT,' ');
280:
281: fnd_file.put_line(FND_FILE.LOG,l_under_line);
282: fnd_file.put_line(FND_FILE.LOG,'Date:'||to_char(l_effective_date)||' IE Medical Insurance Upgrade Process');
283: fnd_file.put_line(FND_FILE.LOG,l_under_line);
284: fnd_file.put_line(FND_FILE.LOG,' ');
285:
286: l_assignment_id := p_asg_id;
287: l_report_item_type := p_benefit_type;

Line 284: fnd_file.put_line(FND_FILE.LOG,' ');

280:
281: fnd_file.put_line(FND_FILE.LOG,l_under_line);
282: fnd_file.put_line(FND_FILE.LOG,'Date:'||to_char(l_effective_date)||' IE Medical Insurance Upgrade Process');
283: fnd_file.put_line(FND_FILE.LOG,l_under_line);
284: fnd_file.put_line(FND_FILE.LOG,' ');
285:
286: l_assignment_id := p_asg_id;
287: l_report_item_type := p_benefit_type;
288: /*

Line 295: fnd_file.put_line(FND_FILE.OUTPUT,'Reportable Item Type cannot be null. You must enter valid Reportable Item Type');

291: END IF;
292:
293: IF l_report_item_type = '-1' THEN
294: l_report_item_type := NULL;
295: fnd_file.put_line(FND_FILE.OUTPUT,'Reportable Item Type cannot be null. You must enter valid Reportable Item Type');
296: raise_application_error(-20001,'Reportable Item Type cannot be null. You must enter valid Reportable Item Type');
297: END IF;
298: */
299: -- get element_type_Id;

Line 324: fnd_file.put_line(FND_FILE.OUTPUT,l_string);

320: || lpad('Assignment Number',25,' ')
321: ||lpad('Assignment ID',20,' ')
322: ||lpad('Report Item',20,' ')
323: ||lpad('Taxable Value',30,' ');
324: fnd_file.put_line(FND_FILE.OUTPUT,l_string);
325: fnd_file.put_line(FND_FILE.LOG,l_string);
326:
327: l_string := NULL;
328: l_string := lpad('=========================',35,' ')

Line 325: fnd_file.put_line(FND_FILE.LOG,l_string);

321: ||lpad('Assignment ID',20,' ')
322: ||lpad('Report Item',20,' ')
323: ||lpad('Taxable Value',30,' ');
324: fnd_file.put_line(FND_FILE.OUTPUT,l_string);
325: fnd_file.put_line(FND_FILE.LOG,l_string);
326:
327: l_string := NULL;
328: l_string := lpad('=========================',35,' ')
329: || lpad('=================',25,' ')

Line 333: fnd_file.put_line(FND_FILE.OUTPUT,l_string);

329: || lpad('=================',25,' ')
330: ||lpad('=============',20,' ')
331: ||lpad('===========',20,' ')
332: ||lpad('=====================',30,' ');
333: fnd_file.put_line(FND_FILE.OUTPUT,l_string);
334: fnd_file.put_line(FND_FILE.LOG,l_string);
335:
336: hr_utility.set_location('l_assignment_id:'||l_assignment_id,1050);
337: hr_utility.set_location('l_input_val_id_med:'||l_input_val_id_med,1050);

Line 334: fnd_file.put_line(FND_FILE.LOG,l_string);

330: ||lpad('=============',20,' ')
331: ||lpad('===========',20,' ')
332: ||lpad('=====================',30,' ');
333: fnd_file.put_line(FND_FILE.OUTPUT,l_string);
334: fnd_file.put_line(FND_FILE.LOG,l_string);
335:
336: hr_utility.set_location('l_assignment_id:'||l_assignment_id,1050);
337: hr_utility.set_location('l_input_val_id_med:'||l_input_val_id_med,1050);
338: hr_utility.set_location('l_ele_type_id:'||l_ele_type_id,1050);

Line 366: fnd_file.put_line(FND_FILE.OUTPUT,l_string);

362: IF counter <> 0 and l_temp_assg_id <> l_csr_assig_act.assignment_id THEN
363: -- Here display Emp Name, assignment number, assignment_id and total result value.
364: l_string := null;
365: l_string := lpad(nvl(l_full_name,' '),35,' ')|| lpad(nvl(l_assig_number,' '),25,' ')||lpad(nvl(l_assign_id,' '),20,' ')||lpad(nvl(l_report_item_type,' '),20,' ')||lpad(to_char(l_result_val_num),30,' ');
366: fnd_file.put_line(FND_FILE.OUTPUT,l_string);
367: dbms_output.put_line(l_string);
368: --utl_file.put_line (vOutHandle, l_string);
369: END IF;
370:

Line 396: fnd_file.put_line(FND_FILE.OUTPUT,l_string);

392:
393: -- Here display Emp Name, assignment number, assignment_id and total result value.
394: l_string := null;
395: l_string := lpad(nvl(l_full_name,' '),35,' ')|| lpad(nvl(l_assig_number,' '),25,' ')||lpad(nvl(l_assign_id,' '),20,' ')||lpad(nvl(l_report_item_type,' '),20,' ')||lpad(to_char(l_csr_assig_act.result_value),30,' ');
396: fnd_file.put_line(FND_FILE.OUTPUT,l_string);
397:
398: fnd_file.put_line(FND_FILE.LOG,l_string);
399:
400: -- populate PL table only in Commit mode and

Line 398: fnd_file.put_line(FND_FILE.LOG,l_string);

394: l_string := null;
395: l_string := lpad(nvl(l_full_name,' '),35,' ')|| lpad(nvl(l_assig_number,' '),25,' ')||lpad(nvl(l_assign_id,' '),20,' ')||lpad(nvl(l_report_item_type,' '),20,' ')||lpad(to_char(l_csr_assig_act.result_value),30,' ');
396: fnd_file.put_line(FND_FILE.OUTPUT,l_string);
397:
398: fnd_file.put_line(FND_FILE.LOG,l_string);
399:
400: -- populate PL table only in Commit mode and
401: IF p_validate_commit = 'IE_VALIDATE_COMMIT'
402: AND l_c_already_run <> 1

Line 414: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);

410:
411: --
412: hr_utility.set_location('After cursor loop csr_assig_act',1060);
413: --
414: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
415: fnd_file.put_line(FND_FILE.LOG,l_under_line);
416: hr_utility.set_location('p_validate_commit:'||p_validate_commit,1080);
417: hr_utility.set_location('l_Med_pl_table.COUNT:'||l_Med_pl_table.COUNT,1080);
418: --

Line 415: fnd_file.put_line(FND_FILE.LOG,l_under_line);

411: --
412: hr_utility.set_location('After cursor loop csr_assig_act',1060);
413: --
414: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
415: fnd_file.put_line(FND_FILE.LOG,l_under_line);
416: hr_utility.set_location('p_validate_commit:'||p_validate_commit,1080);
417: hr_utility.set_location('l_Med_pl_table.COUNT:'||l_Med_pl_table.COUNT,1080);
418: --
419: IF p_validate_commit = 'IE_VALIDATE_COMMIT' AND l_Med_pl_table.COUNT > 0

Line 440: fnd_file.put_line(FND_FILE.LOG,' ');

436: hr_utility.set_location('After calling procedure Medical_Balance_Adjust:',1090);
437: /*
438: EXCEPTION
439: WHEN OTHERS THEN
440: fnd_file.put_line(FND_FILE.LOG,' ');
441: fnd_file.put_line(FND_FILE.LOG,'Error encountered for assignment ID:'||l_Med_pl_table(l_index).l_m_asg_id);
442: fnd_file.put_line(FND_FILE.LOG,sqlerrm);
443: Hr_Utility.set_location('Error encountered for assignment ID:'||l_Med_pl_table(l_index).l_m_asg_id,1100);
444: Hr_Utility.set_location('SQLERRM :'||sqlerrm,1100);

Line 441: fnd_file.put_line(FND_FILE.LOG,'Error encountered for assignment ID:'||l_Med_pl_table(l_index).l_m_asg_id);

437: /*
438: EXCEPTION
439: WHEN OTHERS THEN
440: fnd_file.put_line(FND_FILE.LOG,' ');
441: fnd_file.put_line(FND_FILE.LOG,'Error encountered for assignment ID:'||l_Med_pl_table(l_index).l_m_asg_id);
442: fnd_file.put_line(FND_FILE.LOG,sqlerrm);
443: Hr_Utility.set_location('Error encountered for assignment ID:'||l_Med_pl_table(l_index).l_m_asg_id,1100);
444: Hr_Utility.set_location('SQLERRM :'||sqlerrm,1100);
445: ROLLBACK;

Line 442: fnd_file.put_line(FND_FILE.LOG,sqlerrm);

438: EXCEPTION
439: WHEN OTHERS THEN
440: fnd_file.put_line(FND_FILE.LOG,' ');
441: fnd_file.put_line(FND_FILE.LOG,'Error encountered for assignment ID:'||l_Med_pl_table(l_index).l_m_asg_id);
442: fnd_file.put_line(FND_FILE.LOG,sqlerrm);
443: Hr_Utility.set_location('Error encountered for assignment ID:'||l_Med_pl_table(l_index).l_m_asg_id,1100);
444: Hr_Utility.set_location('SQLERRM :'||sqlerrm,1100);
445: ROLLBACK;
446: */

Line 467: fnd_file.put_line(FND_FILE.LOG,l_under_line);

463: --
464: END IF;
465: ELSE
466: --
467: fnd_file.put_line(FND_FILE.LOG,l_under_line);
468: fnd_file.put_line(FND_FILE.log,'This process has already been run.');
469: fnd_file.put_line(FND_FILE.LOG,l_under_line);
470: --
471: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);

Line 468: fnd_file.put_line(FND_FILE.log,'This process has already been run.');

464: END IF;
465: ELSE
466: --
467: fnd_file.put_line(FND_FILE.LOG,l_under_line);
468: fnd_file.put_line(FND_FILE.log,'This process has already been run.');
469: fnd_file.put_line(FND_FILE.LOG,l_under_line);
470: --
471: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
472: fnd_file.put_line(FND_FILE.OUTPUT,'This process has already been run.');

Line 469: fnd_file.put_line(FND_FILE.LOG,l_under_line);

465: ELSE
466: --
467: fnd_file.put_line(FND_FILE.LOG,l_under_line);
468: fnd_file.put_line(FND_FILE.log,'This process has already been run.');
469: fnd_file.put_line(FND_FILE.LOG,l_under_line);
470: --
471: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
472: fnd_file.put_line(FND_FILE.OUTPUT,'This process has already been run.');
473: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);

Line 471: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);

467: fnd_file.put_line(FND_FILE.LOG,l_under_line);
468: fnd_file.put_line(FND_FILE.log,'This process has already been run.');
469: fnd_file.put_line(FND_FILE.LOG,l_under_line);
470: --
471: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
472: fnd_file.put_line(FND_FILE.OUTPUT,'This process has already been run.');
473: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
474: --
475: END IF;

Line 472: fnd_file.put_line(FND_FILE.OUTPUT,'This process has already been run.');

468: fnd_file.put_line(FND_FILE.log,'This process has already been run.');
469: fnd_file.put_line(FND_FILE.LOG,l_under_line);
470: --
471: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
472: fnd_file.put_line(FND_FILE.OUTPUT,'This process has already been run.');
473: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
474: --
475: END IF;
476: --hr_utility.trace_off;

Line 473: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);

469: fnd_file.put_line(FND_FILE.LOG,l_under_line);
470: --
471: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
472: fnd_file.put_line(FND_FILE.OUTPUT,'This process has already been run.');
473: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
474: --
475: END IF;
476: --hr_utility.trace_off;
477: -- Display the last assignment picked, outside the loop

Line 481: fnd_file.put_line(FND_FILE.OUTPUT,l_string);

477: -- Display the last assignment picked, outside the loop
478: /*
479: l_string := null;
480: l_string := lpad(nvl(l_full_name,' '),35,' ')|| lpad(nvl(l_assig_number,' '),25,' ')||lpad(nvl(l_assign_id,' '),20,' ')||lpad(nvl(l_report_item_type,' '),20,' ')||lpad(to_char(l_result_val_num),30,' ');
481: fnd_file.put_line(FND_FILE.OUTPUT,l_string);
482: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
483: dbms_output.put_line(l_string);
484: */
485:

Line 482: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);

478: /*
479: l_string := null;
480: l_string := lpad(nvl(l_full_name,' '),35,' ')|| lpad(nvl(l_assig_number,' '),25,' ')||lpad(nvl(l_assign_id,' '),20,' ')||lpad(nvl(l_report_item_type,' '),20,' ')||lpad(to_char(l_result_val_num),30,' ');
481: fnd_file.put_line(FND_FILE.OUTPUT,l_string);
482: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
483: dbms_output.put_line(l_string);
484: */
485:
486: hr_utility.set_location('Leaving '||g_package||l_proc_name,1000);

Line 490: fnd_file.put_line(FND_FILE.LOG,'..'||'SQL-ERRM :'||SQLERRM);

486: hr_utility.set_location('Leaving '||g_package||l_proc_name,1000);
487:
488: EXCEPTION
489: WHEN Others THEN
490: fnd_file.put_line(FND_FILE.LOG,'..'||'SQL-ERRM :'||SQLERRM);
491: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
492: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1000);
493: hr_utility.set_location('Leaving '||g_package||l_proc_name,1000);
494: raise;

Line 491: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);

487:
488: EXCEPTION
489: WHEN Others THEN
490: fnd_file.put_line(FND_FILE.LOG,'..'||'SQL-ERRM :'||SQLERRM);
491: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
492: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1000);
493: hr_utility.set_location('Leaving '||g_package||l_proc_name,1000);
494: raise;
495: END;