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

Line 81: FND_FILE.NEW_LINE(fnd_file.output, 1);

77: || rpad('-',20,'-')
78: || ' '
79: || rpad('-',50,'-');
80:
81: FND_FILE.NEW_LINE(fnd_file.output, 1);
82: fnd_file.put_line(fnd_file.output,l_line_1);
83: fnd_file.put_line(fnd_file.output,l_line_3);
84:
85: END log_dk_ehol_card_header;

Line 82: fnd_file.put_line(fnd_file.output,l_line_1);

78: || ' '
79: || rpad('-',50,'-');
80:
81: FND_FILE.NEW_LINE(fnd_file.output, 1);
82: fnd_file.put_line(fnd_file.output,l_line_1);
83: fnd_file.put_line(fnd_file.output,l_line_3);
84:
85: END log_dk_ehol_card_header;
86:

Line 83: fnd_file.put_line(fnd_file.output,l_line_3);

79: || rpad('-',50,'-');
80:
81: FND_FILE.NEW_LINE(fnd_file.output, 1);
82: fnd_file.put_line(fnd_file.output,l_line_1);
83: fnd_file.put_line(fnd_file.output,l_line_3);
84:
85: END log_dk_ehol_card_header;
86:
87: PROCEDURE log_dk_ehol_card_body AS

Line 92: FND_FILE.NEW_LINE(fnd_file.output, 1);

88: l_line varchar2(1000);
89:
90: BEGIN
91:
92: FND_FILE.NEW_LINE(fnd_file.output, 1);
93:
94: IF l_proc_tab.COUNT <> 0 THEN
95: FOR i IN l_proc_tab.first..l_proc_tab.last
96: LOOP

Line 97: fnd_file.put_line(fnd_file.output,rpad(l_proc_tab(i).p_assg_number,16,' ')

93:
94: IF l_proc_tab.COUNT <> 0 THEN
95: FOR i IN l_proc_tab.first..l_proc_tab.last
96: LOOP
97: fnd_file.put_line(fnd_file.output,rpad(l_proc_tab(i).p_assg_number,16,' ')
98: ||rpad(l_proc_tab(i).p_absence_start,26,' ')||rpad(l_proc_tab(i).p_duration,21,' ')||l_proc_tab(i).p_proc_msg);
99: END LOOP;
100: END IF;
101:

Line 105: fnd_file.put_line(fnd_file.output,rpad(nvl(l_err_tab(i).p_assg_number,' '),16,' ')

101:
102: IF l_err_tab.COUNT <> 0 then
103: FOR i IN l_err_tab.first..l_err_tab.last
104: LOOP
105: fnd_file.put_line(fnd_file.output,rpad(nvl(l_err_tab(i).p_assg_number,' '),16,' ')
106: ||rpad(nvl(to_char(l_err_tab(i).p_absence_start),' '),26,' ')||rpad(l_err_tab(i).p_duration,21,' ')||l_err_tab(i).p_err_msg);
107: END LOOP;
108: END IF;
109:

Line 831: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

827:
828: hr_utility.set_location('organization id = ' ||g_legal_employer_id,102);
829: IF g_legal_employer_id IS NULL THEN
830: hr_utility.set_message(801, 'PAY_377024_DK_LEGAL_EMPLOYER_E');
831: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
832: hr_utility.raise_error;
833: END IF;
834:
835: OPEN csr_get_hol_entity(g_legal_employer_id,g_effective_date,g_business_group_id);

Line 910: FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request made for l_ass_no'||l_ass_no);

906: RAISE e_record_too_long;
907: END IF;
908:
909:
910: FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request made for l_ass_no'||l_ass_no);
911: FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request made for l_cvr_no'||l_cvr_no);
912: FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request made for year'||l_year);
913:
914: OPEN csr_le_people(l_ass_no,l_cvr_no,l_start_date);

Line 911: FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request made for l_cvr_no'||l_cvr_no);

907: END IF;
908:
909:
910: FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request made for l_ass_no'||l_ass_no);
911: FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request made for l_cvr_no'||l_cvr_no);
912: FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request made for year'||l_year);
913:
914: OPEN csr_le_people(l_ass_no,l_cvr_no,l_start_date);
915: FETCH csr_le_people into rg_le_people;

Line 912: FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request made for year'||l_year);

908:
909:
910: FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request made for l_ass_no'||l_ass_no);
911: FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request made for l_cvr_no'||l_cvr_no);
912: FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request made for year'||l_year);
913:
914: OPEN csr_le_people(l_ass_no,l_cvr_no,l_start_date);
915: FETCH csr_le_people into rg_le_people;
916: IF csr_le_people%NOTFOUND THEN

Line 944: FND_FILE.PUT_LINE(fnd_file.log, 'No element links for Override Holiday Duration ');

940: OPEN csr_ele_link('Override Holiday Duration',l_payroll_id);
941: FETCH csr_ele_link INTO l_ele_link_id ;
942: IF csr_ele_link%NOTFOUND THEN
943: CLOSE csr_ele_link;
944: FND_FILE.PUT_LINE(fnd_file.log, 'No element links for Override Holiday Duration ');
945: hr_utility.raise_error;
946: END IF;
947: CLOSE csr_ele_link;
948:

Line 953: FND_FILE.PUT_LINE(fnd_file.log, 'No element links for Absent Holiday Card Request ');

949: OPEN csr_ele_link('Absent Holiday Card Request',l_payroll_id);
950: FETCH csr_ele_link INTO l_ele_link_id;
951: IF csr_ele_link%NOTFOUND THEN
952: CLOSE csr_ele_link;
953: FND_FILE.PUT_LINE(fnd_file.log, 'No element links for Absent Holiday Card Request ');
954: hr_utility.raise_error;
955: END IF;
956: CLOSE csr_ele_link;
957:

Line 962: FND_FILE.PUT_LINE(fnd_file.log, 'No element links for Holiday Card Payment Request ');

958: OPEN csr_ele_link('Holiday Card Payment Request',l_payroll_id);
959: FETCH csr_ele_link INTO l_ele_link_id;
960: IF csr_ele_link%NOTFOUND THEN
961: CLOSE csr_ele_link;
962: FND_FILE.PUT_LINE(fnd_file.log, 'No element links for Holiday Card Payment Request ');
963: hr_utility.raise_error;
964: END IF;
965: CLOSE csr_ele_link;
966: l_last_yr := to_char(TRUNC(l_start_date,'YEAR') - 1, 'RRRR');

Line 1016: FND_FILE.PUT_LINE(fnd_file.log, 'l_assg_id'||l_assg_id);

1012: , l_holidays
1013: , NULL
1014: , l_year ) ;
1015:
1016: FND_FILE.PUT_LINE(fnd_file.log, 'l_assg_id'||l_assg_id);
1017: FND_FILE.PUT_LINE(fnd_file.log, 'l_ass_no'||l_ass_no);
1018: FND_FILE.PUT_LINE(fnd_file.log, 'l_year'||l_year);
1019: FND_FILE.PUT_LINE(fnd_file.log, 'l_cvr_no'||l_cvr_no);
1020: FND_FILE.PUT_LINE(fnd_file.log, 'g_absence_attendance_type_id'||g_absence_attendance_type_id);

Line 1017: FND_FILE.PUT_LINE(fnd_file.log, 'l_ass_no'||l_ass_no);

1013: , NULL
1014: , l_year ) ;
1015:
1016: FND_FILE.PUT_LINE(fnd_file.log, 'l_assg_id'||l_assg_id);
1017: FND_FILE.PUT_LINE(fnd_file.log, 'l_ass_no'||l_ass_no);
1018: FND_FILE.PUT_LINE(fnd_file.log, 'l_year'||l_year);
1019: FND_FILE.PUT_LINE(fnd_file.log, 'l_cvr_no'||l_cvr_no);
1020: FND_FILE.PUT_LINE(fnd_file.log, 'g_absence_attendance_type_id'||g_absence_attendance_type_id);
1021: FND_FILE.PUT_LINE(fnd_file.log, 'g_company_name'||g_company_name);

Line 1018: FND_FILE.PUT_LINE(fnd_file.log, 'l_year'||l_year);

1014: , l_year ) ;
1015:
1016: FND_FILE.PUT_LINE(fnd_file.log, 'l_assg_id'||l_assg_id);
1017: FND_FILE.PUT_LINE(fnd_file.log, 'l_ass_no'||l_ass_no);
1018: FND_FILE.PUT_LINE(fnd_file.log, 'l_year'||l_year);
1019: FND_FILE.PUT_LINE(fnd_file.log, 'l_cvr_no'||l_cvr_no);
1020: FND_FILE.PUT_LINE(fnd_file.log, 'g_absence_attendance_type_id'||g_absence_attendance_type_id);
1021: FND_FILE.PUT_LINE(fnd_file.log, 'g_company_name'||g_company_name);
1022: FND_FILE.PUT_LINE(fnd_file.log, 'g_cvr_no'||g_cvr_no);

Line 1019: FND_FILE.PUT_LINE(fnd_file.log, 'l_cvr_no'||l_cvr_no);

1015:
1016: FND_FILE.PUT_LINE(fnd_file.log, 'l_assg_id'||l_assg_id);
1017: FND_FILE.PUT_LINE(fnd_file.log, 'l_ass_no'||l_ass_no);
1018: FND_FILE.PUT_LINE(fnd_file.log, 'l_year'||l_year);
1019: FND_FILE.PUT_LINE(fnd_file.log, 'l_cvr_no'||l_cvr_no);
1020: FND_FILE.PUT_LINE(fnd_file.log, 'g_absence_attendance_type_id'||g_absence_attendance_type_id);
1021: FND_FILE.PUT_LINE(fnd_file.log, 'g_company_name'||g_company_name);
1022: FND_FILE.PUT_LINE(fnd_file.log, 'g_cvr_no'||g_cvr_no);
1023: FND_FILE.PUT_LINE(fnd_file.log, 'g_se_no'||g_se_no);

Line 1020: FND_FILE.PUT_LINE(fnd_file.log, 'g_absence_attendance_type_id'||g_absence_attendance_type_id);

1016: FND_FILE.PUT_LINE(fnd_file.log, 'l_assg_id'||l_assg_id);
1017: FND_FILE.PUT_LINE(fnd_file.log, 'l_ass_no'||l_ass_no);
1018: FND_FILE.PUT_LINE(fnd_file.log, 'l_year'||l_year);
1019: FND_FILE.PUT_LINE(fnd_file.log, 'l_cvr_no'||l_cvr_no);
1020: FND_FILE.PUT_LINE(fnd_file.log, 'g_absence_attendance_type_id'||g_absence_attendance_type_id);
1021: FND_FILE.PUT_LINE(fnd_file.log, 'g_company_name'||g_company_name);
1022: FND_FILE.PUT_LINE(fnd_file.log, 'g_cvr_no'||g_cvr_no);
1023: FND_FILE.PUT_LINE(fnd_file.log, 'g_se_no'||g_se_no);
1024:

Line 1021: FND_FILE.PUT_LINE(fnd_file.log, 'g_company_name'||g_company_name);

1017: FND_FILE.PUT_LINE(fnd_file.log, 'l_ass_no'||l_ass_no);
1018: FND_FILE.PUT_LINE(fnd_file.log, 'l_year'||l_year);
1019: FND_FILE.PUT_LINE(fnd_file.log, 'l_cvr_no'||l_cvr_no);
1020: FND_FILE.PUT_LINE(fnd_file.log, 'g_absence_attendance_type_id'||g_absence_attendance_type_id);
1021: FND_FILE.PUT_LINE(fnd_file.log, 'g_company_name'||g_company_name);
1022: FND_FILE.PUT_LINE(fnd_file.log, 'g_cvr_no'||g_cvr_no);
1023: FND_FILE.PUT_LINE(fnd_file.log, 'g_se_no'||g_se_no);
1024:
1025:

Line 1022: FND_FILE.PUT_LINE(fnd_file.log, 'g_cvr_no'||g_cvr_no);

1018: FND_FILE.PUT_LINE(fnd_file.log, 'l_year'||l_year);
1019: FND_FILE.PUT_LINE(fnd_file.log, 'l_cvr_no'||l_cvr_no);
1020: FND_FILE.PUT_LINE(fnd_file.log, 'g_absence_attendance_type_id'||g_absence_attendance_type_id);
1021: FND_FILE.PUT_LINE(fnd_file.log, 'g_company_name'||g_company_name);
1022: FND_FILE.PUT_LINE(fnd_file.log, 'g_cvr_no'||g_cvr_no);
1023: FND_FILE.PUT_LINE(fnd_file.log, 'g_se_no'||g_se_no);
1024:
1025:
1026: create_timestamp_entry ( l_start_date

Line 1023: FND_FILE.PUT_LINE(fnd_file.log, 'g_se_no'||g_se_no);

1019: FND_FILE.PUT_LINE(fnd_file.log, 'l_cvr_no'||l_cvr_no);
1020: FND_FILE.PUT_LINE(fnd_file.log, 'g_absence_attendance_type_id'||g_absence_attendance_type_id);
1021: FND_FILE.PUT_LINE(fnd_file.log, 'g_company_name'||g_company_name);
1022: FND_FILE.PUT_LINE(fnd_file.log, 'g_cvr_no'||g_cvr_no);
1023: FND_FILE.PUT_LINE(fnd_file.log, 'g_se_no'||g_se_no);
1024:
1025:
1026: create_timestamp_entry ( l_start_date
1027: , rg_le_people.assg_id

Line 1051: -- FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request suceeded for'||l_proc_tab(proc_cnt).p_cpr_number);

1047: l_proc_tab(proc_cnt).p_proc_msg := 'Processed';
1048:
1049: END IF;
1050:
1051: -- FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request suceeded for'||l_proc_tab(proc_cnt).p_cpr_number);
1052: FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request suceeded for'||l_proc_tab(proc_cnt).p_assg_number);
1053: proc_cnt := proc_cnt + 1;
1054:
1055:

Line 1052: FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request suceeded for'||l_proc_tab(proc_cnt).p_assg_number);

1048:
1049: END IF;
1050:
1051: -- FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request suceeded for'||l_proc_tab(proc_cnt).p_cpr_number);
1052: FND_FILE.PUT_LINE(fnd_file.log, 'Holiday Pay request suceeded for'||l_proc_tab(proc_cnt).p_assg_number);
1053: proc_cnt := proc_cnt + 1;
1054:
1055:
1056: EXCEPTION

Line 1064: FND_FILE.PUT_LINE(fnd_file.log, l_err_tab(err_cnt).p_err_msg);

1060: fnd_message.set_name('PAY','PAY_DK_WRONG_ENTITLEMENT');
1061:
1062: -- Return the message to the ConcMgr (This msg will appear in the log file)
1063: l_err_tab(err_cnt).p_err_msg := fnd_message.get();
1064: FND_FILE.PUT_LINE(fnd_file.log, l_err_tab(err_cnt).p_err_msg);
1065: -- l_err_tab(err_cnt).emp_name := g_hol_card_emp(i).emp_name;
1066: -- l_err_tab(err_cnt).p_cpr_number := l_cvr_no;
1067: l_err_tab(err_cnt).p_assg_number := l_ass_no;
1068: l_err_tab(err_cnt).p_absence_start := l_start_date;

Line 1078: FND_FILE.PUT_LINE(fnd_file.log, l_err_tab(err_cnt).p_err_msg);

1074: fnd_message.set_name('PAY','PAY_INVALID_CPR_NUMBER');
1075:
1076: -- Return the message to the ConcMgr (This msg will appear in the log file)
1077: l_err_tab(err_cnt).p_err_msg := fnd_message.get();
1078: FND_FILE.PUT_LINE(fnd_file.log, l_err_tab(err_cnt).p_err_msg);
1079: -- l_err_tab(err_cnt).emp_name := g_hol_card_emp(i).emp_name;
1080: -- l_err_tab(err_cnt).p_cpr_number := l_cvr_no;
1081: l_err_tab(err_cnt).p_assg_number := l_ass_no;
1082: l_err_tab(err_cnt).p_absence_start := l_start_date;

Line 1096: FND_FILE.PUT_LINE(fnd_file.log, l_err_tab(err_cnt).p_err_msg);

1092: fnd_message.set_name('PAY','PAY_DK_ASSG_NOT_FOUND');
1093:
1094: -- Return the message to the ConcMgr (This msg will appear in the log file)
1095: l_err_tab(err_cnt).p_err_msg := fnd_message.get();
1096: FND_FILE.PUT_LINE(fnd_file.log, l_err_tab(err_cnt).p_err_msg);
1097: -- l_err_tab(err_cnt).emp_name := g_hol_card_emp(i).emp_name;
1098: -- l_err_tab(err_cnt).p_cpr_number := l_cvr_no;
1099: l_err_tab(err_cnt).p_assg_number := l_ass_no;
1100: l_err_tab(err_cnt).p_absence_start := l_start_date;

Line 1111: FND_FILE.PUT_LINE(fnd_file.log, l_err_tab(err_cnt).p_err_msg);

1107: fnd_message.set_name('PAY','PAY_DK_USE_HOLIDAY_CARD');
1108:
1109: -- Return the message to the ConcMgr (This msg will appear in the log file)
1110: l_err_tab(err_cnt).p_err_msg := fnd_message.get();
1111: FND_FILE.PUT_LINE(fnd_file.log, l_err_tab(err_cnt).p_err_msg);
1112: -- l_err_tab(err_cnt).emp_name := g_hol_card_emp(i).emp_name;
1113: -- l_err_tab(err_cnt).p_cpr_number := l_cvr_no;
1114: l_err_tab(err_cnt).p_assg_number := l_ass_no;
1115: l_err_tab(err_cnt).p_absence_start := l_start_date;

Line 1123: FND_FILE.PUT_LINE(fnd_file.log, l_err_tab(err_cnt).p_err_msg);

1119: WHEN abs_term_date THEN
1120: retcode := g_warning;
1121: fnd_message.set_name('PER', 'PER_7715_ABS_TERM_PROJ_DATE');
1122: l_err_tab(err_cnt).p_err_msg := fnd_message.get();
1123: FND_FILE.PUT_LINE(fnd_file.log, l_err_tab(err_cnt).p_err_msg);
1124:
1125: -- l_err_tab(err_cnt).emp_name := g_hol_card_emp(i).emp_name;
1126: -- l_err_tab(err_cnt).p_cpr_number := l_cvr_no;
1127: l_err_tab(err_cnt).p_assg_number := l_ass_no;

Line 1324: fnd_file.put_line(fnd_file.log,'Total employees requesting E-Holiday absence = ' ||g_count_employee);

1320: END IF;
1321:
1322:
1323: END LOOP;
1324: fnd_file.put_line(fnd_file.log,'Total employees requesting E-Holiday absence = ' ||g_count_employee);
1325: hr_utility.set_location ('Total employees requesting E-Holiday absence = ' ||g_count_employee,400);
1326: hr_utility.set_location(' leaving Procedure printelements',10);
1327:
1328: EXCEPTION

Line 1451: fnd_file.put_line(fnd_file.log,'exception: '||SQLERRM);

1447: when xmldom.INUSE_ATTRIBUTE_ERR then
1448: raise_application_error(-20120, 'In use attr error');
1449:
1450: WHEN others then
1451: fnd_file.put_line(fnd_file.log,'exception: '||SQLERRM);
1452: fnd_file.put_line(fnd_file.log,'exception: '||SQLCODE);
1453: hr_utility.raise_error;
1454:
1455: END read_hol_card;

Line 1452: fnd_file.put_line(fnd_file.log,'exception: '||SQLCODE);

1448: raise_application_error(-20120, 'In use attr error');
1449:
1450: WHEN others then
1451: fnd_file.put_line(fnd_file.log,'exception: '||SQLERRM);
1452: fnd_file.put_line(fnd_file.log,'exception: '||SQLCODE);
1453: hr_utility.raise_error;
1454:
1455: END read_hol_card;
1456: