DBA Data[Home] [Help]

APPS.PAY_FR_DADS_F_PKG dependencies on HR_UTILITY

Line 1166: hr_utility.set_location('Entering the procedure Write into file',1);

1162: p_error_warning_message varchar2) is
1163: --
1164: BEGIN
1165: --
1166: hr_utility.set_location('Entering the procedure Write into file',1);
1167:
1168: -- Print the error message
1169: fnd_file.put_line(fnd_file.output,p_error_warning||':'||p_rubric_code||':'||p_error_warning_message);
1170: -- insert a line after each rubric

Line 1173: hr_utility.set_location('leaving write into file',3);

1169: fnd_file.put_line(fnd_file.output,p_error_warning||':'||p_rubric_code||':'||p_error_warning_message);
1170: -- insert a line after each rubric
1171: fnd_file.new_line(fnd_file.output, 1);
1172:
1173: hr_utility.set_location('leaving write into file',3);
1174:
1175: END write_into_file;
1176: --
1177:

Line 1203: --hr_utility.trace_on (null, 'AY_FOR_TRACE');

1199: END get_sort_rubrics;
1200: --
1201: BEGIN
1202: -- fetch the sort order rubrics
1203: --hr_utility.trace_on (null, 'AY_FOR_TRACE');
1204: hr_utility.set_location('Entered the procedure control_proc',1);
1205: l_sort_rubric1 := get_sort_rubrics(p_sort_order_1);
1206: -- As p_sort_order_2 is not a mandatory parameter
1207: IF p_sort_order_2 IS NOT NULL THEN

Line 1204: hr_utility.set_location('Entered the procedure control_proc',1);

1200: --
1201: BEGIN
1202: -- fetch the sort order rubrics
1203: --hr_utility.trace_on (null, 'AY_FOR_TRACE');
1204: hr_utility.set_location('Entered the procedure control_proc',1);
1205: l_sort_rubric1 := get_sort_rubrics(p_sort_order_1);
1206: -- As p_sort_order_2 is not a mandatory parameter
1207: IF p_sort_order_2 IS NOT NULL THEN
1208: l_sort_rubric2 := get_sort_rubrics(p_sort_order_2);

Line 1230: hr_utility.set_location('Retreived Sort Orders ',2);

1226: l_value := null;
1227: END IF;
1228:
1229: -- fetch the payroll action
1230: hr_utility.set_location('Retreived Sort Orders ',2);
1231: OPEN csr_payroll_action;
1232: FETCH csr_payroll_action INTO l_payroll_action_id;
1233: CLOSE csr_payroll_action;
1234: -- Check for report inclusions

Line 1236: hr_utility.set_location('Entering S10 ',3);

1232: FETCH csr_payroll_action INTO l_payroll_action_id;
1233: CLOSE csr_payroll_action;
1234: -- Check for report inclusions
1235: IF P_REPORT_INCLUSIONS ='ORG' OR P_REPORT_INCLUSIONS='ALL' THEN
1236: hr_utility.set_location('Entering S10 ',3);
1237: -- WRITE S10 DATA
1238: -- print header for S10
1239: OPEN csr_s10_header_data(l_payroll_action_id);
1240: FETCH csr_s10_header_data INTO l_header_issue_estab, l_s10_cre_estab;

Line 1252: hr_utility.set_location('Printing the header ',4);

1248: fnd_file.put_line(fnd_file.output,l_s10_heading_text);
1249: fnd_file.put_line(fnd_file.output,l_issuing_estab_text ||' : '||l_header_issue_estab);
1250: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s10_cre_estab);
1251: fnd_file.new_line(fnd_file.output,1);
1252: hr_utility.set_location('Printing the header ',4);
1253: -- fetch the values for s10
1254: FOR get_s10_rec IN csr_get_S10_rec(l_payroll_action_id) LOOP
1255: -- write the values of S10
1256: write_into_file (get_s10_rec.rubric_code,

Line 1273: hr_utility.set_location('Entered into the company procedure ',5);

1269: --#3300005 Incrementing the number of companies by 1
1270: l_total_companies := l_total_companies + 1;
1271: -- Check for report inclusions
1272: IF P_REPORT_INCLUSIONS ='ORG' OR P_REPORT_INCLUSIONS='ALL' THEN
1273: hr_utility.set_location('Entered into the company procedure ',5);
1274: -- WRITE S20 DATA
1275: -- print header for S20
1276: -- get lookup meanings
1277: l_s20_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_INFO');

Line 1286: hr_utility.set_location('Printing the S20 header values',6);

1282: -- get cursor values
1283: OPEN csr_s20_header_data(l_payroll_action_id,comp_rec.company_id);
1284: FETCH csr_s20_header_data INTO l_comp_name, l_s20_cre_estab, l_hq_name, l_fisc_name;
1285: CLOSE csr_s20_header_data;
1286: hr_utility.set_location('Printing the S20 header values',6);
1287: -- write the header into the file
1288: fnd_file.new_line(fnd_file.output,2);
1289: fnd_file.put_line(fnd_file.output,l_s20_heading_text);
1290: fnd_file.put_line(fnd_file.output,l_comp_text||' : '||l_comp_name);

Line 1296: hr_utility.set_location('Printing the S20 error values',7);

1292: fnd_file.put_line(fnd_file.output,l_fisc_text||' : '||l_fisc_name);
1293: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s20_cre_estab);
1294: fnd_file.new_line(fnd_file.output,1);
1295: --
1296: hr_utility.set_location('Printing the S20 error values',7);
1297: -- Fetch S20 data
1298: FOR S20_data_rec IN csr_get_S20_data(l_payroll_action_id,
1299: comp_rec.company_id) LOOP
1300: IF S20_data_rec.rubric_code = 'S20.G01.00.004.002' and l_value is not null THEN