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

Line 21: Fnd_file.put_line(FND_FILE.OUTPUT,'OUTPUT');

17: P_SORT_ORDER_2 IN VARCHAR2,
18: P_SUBMISSION_TYPE IN VARCHAR2) is
19: begin
20: --
21: Fnd_file.put_line(FND_FILE.OUTPUT,'OUTPUT');
22: fnd_file.put_line(FND_FILE.OUTPUT, 'p_business_group_id '|| p_business_group_id);
23: fnd_file.put_line(FND_FILE.OUTPUT, 'p_issuing_establishment '|| p_issuing_establishment);
24: fnd_file.put_line(FND_FILE.OUTPUT, 'p_dads_reference '|| p_dads_reference);
25: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_type '|| p_report_type);

Line 22: fnd_file.put_line(FND_FILE.OUTPUT, 'p_business_group_id '|| p_business_group_id);

18: P_SUBMISSION_TYPE IN VARCHAR2) is
19: begin
20: --
21: Fnd_file.put_line(FND_FILE.OUTPUT,'OUTPUT');
22: fnd_file.put_line(FND_FILE.OUTPUT, 'p_business_group_id '|| p_business_group_id);
23: fnd_file.put_line(FND_FILE.OUTPUT, 'p_issuing_establishment '|| p_issuing_establishment);
24: fnd_file.put_line(FND_FILE.OUTPUT, 'p_dads_reference '|| p_dads_reference);
25: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_type '|| p_report_type);
26: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_nature '|| p_declaration_nature);

Line 23: fnd_file.put_line(FND_FILE.OUTPUT, 'p_issuing_establishment '|| p_issuing_establishment);

19: begin
20: --
21: Fnd_file.put_line(FND_FILE.OUTPUT,'OUTPUT');
22: fnd_file.put_line(FND_FILE.OUTPUT, 'p_business_group_id '|| p_business_group_id);
23: fnd_file.put_line(FND_FILE.OUTPUT, 'p_issuing_establishment '|| p_issuing_establishment);
24: fnd_file.put_line(FND_FILE.OUTPUT, 'p_dads_reference '|| p_dads_reference);
25: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_type '|| p_report_type);
26: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_nature '|| p_declaration_nature);
27: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_type '|| p_declaration_type);

Line 24: fnd_file.put_line(FND_FILE.OUTPUT, 'p_dads_reference '|| p_dads_reference);

20: --
21: Fnd_file.put_line(FND_FILE.OUTPUT,'OUTPUT');
22: fnd_file.put_line(FND_FILE.OUTPUT, 'p_business_group_id '|| p_business_group_id);
23: fnd_file.put_line(FND_FILE.OUTPUT, 'p_issuing_establishment '|| p_issuing_establishment);
24: fnd_file.put_line(FND_FILE.OUTPUT, 'p_dads_reference '|| p_dads_reference);
25: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_type '|| p_report_type);
26: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_nature '|| p_declaration_nature);
27: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_type '|| p_declaration_type);
28: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_inclusions '|| p_report_inclusions);

Line 25: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_type '|| p_report_type);

21: Fnd_file.put_line(FND_FILE.OUTPUT,'OUTPUT');
22: fnd_file.put_line(FND_FILE.OUTPUT, 'p_business_group_id '|| p_business_group_id);
23: fnd_file.put_line(FND_FILE.OUTPUT, 'p_issuing_establishment '|| p_issuing_establishment);
24: fnd_file.put_line(FND_FILE.OUTPUT, 'p_dads_reference '|| p_dads_reference);
25: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_type '|| p_report_type);
26: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_nature '|| p_declaration_nature);
27: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_type '|| p_declaration_type);
28: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_inclusions '|| p_report_inclusions);
29: --#3553620 printing the sort_order meaning instead of sort_order code

Line 26: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_nature '|| p_declaration_nature);

22: fnd_file.put_line(FND_FILE.OUTPUT, 'p_business_group_id '|| p_business_group_id);
23: fnd_file.put_line(FND_FILE.OUTPUT, 'p_issuing_establishment '|| p_issuing_establishment);
24: fnd_file.put_line(FND_FILE.OUTPUT, 'p_dads_reference '|| p_dads_reference);
25: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_type '|| p_report_type);
26: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_nature '|| p_declaration_nature);
27: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_type '|| p_declaration_type);
28: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_inclusions '|| p_report_inclusions);
29: --#3553620 printing the sort_order meaning instead of sort_order code
30: IF p_sort_order_1 IS NULL THEN

Line 27: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_type '|| p_declaration_type);

23: fnd_file.put_line(FND_FILE.OUTPUT, 'p_issuing_establishment '|| p_issuing_establishment);
24: fnd_file.put_line(FND_FILE.OUTPUT, 'p_dads_reference '|| p_dads_reference);
25: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_type '|| p_report_type);
26: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_nature '|| p_declaration_nature);
27: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_type '|| p_declaration_type);
28: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_inclusions '|| p_report_inclusions);
29: --#3553620 printing the sort_order meaning instead of sort_order code
30: IF p_sort_order_1 IS NULL THEN
31: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '|| p_sort_order_1);

Line 28: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_inclusions '|| p_report_inclusions);

24: fnd_file.put_line(FND_FILE.OUTPUT, 'p_dads_reference '|| p_dads_reference);
25: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_type '|| p_report_type);
26: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_nature '|| p_declaration_nature);
27: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_type '|| p_declaration_type);
28: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_inclusions '|| p_report_inclusions);
29: --#3553620 printing the sort_order meaning instead of sort_order code
30: IF p_sort_order_1 IS NULL THEN
31: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '|| p_sort_order_1);
32: ELSE

Line 31: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '|| p_sort_order_1);

27: fnd_file.put_line(FND_FILE.OUTPUT, 'p_declaration_type '|| p_declaration_type);
28: fnd_file.put_line(FND_FILE.OUTPUT, 'p_report_inclusions '|| p_report_inclusions);
29: --#3553620 printing the sort_order meaning instead of sort_order code
30: IF p_sort_order_1 IS NULL THEN
31: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '|| p_sort_order_1);
32: ELSE
33: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '||hr_general.decode_lookup
34: ('FR_DADS_SORT_ORDER',p_sort_order_1));
35: END IF;

Line 33: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '||hr_general.decode_lookup

29: --#3553620 printing the sort_order meaning instead of sort_order code
30: IF p_sort_order_1 IS NULL THEN
31: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '|| p_sort_order_1);
32: ELSE
33: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '||hr_general.decode_lookup
34: ('FR_DADS_SORT_ORDER',p_sort_order_1));
35: END IF;
36: IF p_sort_order_2 IS NULL THEN
37: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '|| p_sort_order_2);

Line 37: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '|| p_sort_order_2);

33: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '||hr_general.decode_lookup
34: ('FR_DADS_SORT_ORDER',p_sort_order_1));
35: END IF;
36: IF p_sort_order_2 IS NULL THEN
37: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '|| p_sort_order_2);
38: ELSE
39: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '||hr_general.decode_lookup
40: ('FR_DADS_SORT_ORDER',p_sort_order_2));
41: END IF;

Line 39: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '||hr_general.decode_lookup

35: END IF;
36: IF p_sort_order_2 IS NULL THEN
37: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '|| p_sort_order_2);
38: ELSE
39: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '||hr_general.decode_lookup
40: ('FR_DADS_SORT_ORDER',p_sort_order_2));
41: END IF;
42: -- fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '|| p_sort_order_1);
43: -- fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '|| p_sort_order_2);

Line 42: -- fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '|| p_sort_order_1);

38: ELSE
39: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '||hr_general.decode_lookup
40: ('FR_DADS_SORT_ORDER',p_sort_order_2));
41: END IF;
42: -- fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '|| p_sort_order_1);
43: -- fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '|| p_sort_order_2);
44: fnd_file.put_line(FND_FILE.OUTPUT, 'p_submission_type '|| p_submission_type);
45: --
46: IF p_report_type ='F' OR p_report_type = 'R' THEN

Line 43: -- fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '|| p_sort_order_2);

39: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '||hr_general.decode_lookup
40: ('FR_DADS_SORT_ORDER',p_sort_order_2));
41: END IF;
42: -- fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '|| p_sort_order_1);
43: -- fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '|| p_sort_order_2);
44: fnd_file.put_line(FND_FILE.OUTPUT, 'p_submission_type '|| p_submission_type);
45: --
46: IF p_report_type ='F' OR p_report_type = 'R' THEN
47: write_user_file_report(P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID ,

Line 44: fnd_file.put_line(FND_FILE.OUTPUT, 'p_submission_type '|| p_submission_type);

40: ('FR_DADS_SORT_ORDER',p_sort_order_2));
41: END IF;
42: -- fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '|| p_sort_order_1);
43: -- fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '|| p_sort_order_2);
44: fnd_file.put_line(FND_FILE.OUTPUT, 'p_submission_type '|| p_submission_type);
45: --
46: IF p_report_type ='F' OR p_report_type = 'R' THEN
47: write_user_file_report(P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID ,
48: P_ISSUING_ESTABLISHMENT => P_ISSUING_ESTABLISHMENT,

Line 416: fnd_file.put(fnd_file.output, p_rubric_code);

412: p_user_value varchar2) is
413: --
414: BEGIN
415: --
416: fnd_file.put(fnd_file.output, p_rubric_code);
417: IF p_report_type = 'F' THEN
418: -- write the file value
419: fnd_file.put(fnd_file.output, ' '||p_file_value);
420: ELSIF p_report_type ='R' THEN

Line 419: fnd_file.put(fnd_file.output, ' '||p_file_value);

415: --
416: fnd_file.put(fnd_file.output, p_rubric_code);
417: IF p_report_type = 'F' THEN
418: -- write the file value
419: fnd_file.put(fnd_file.output, ' '||p_file_value);
420: ELSIF p_report_type ='R' THEN
421: -- put the rubric description
422: fnd_file.put(fnd_file.output, ' '||p_rubric_desc);
423: --Bug 3756137

Line 422: fnd_file.put(fnd_file.output, ' '||p_rubric_desc);

418: -- write the file value
419: fnd_file.put(fnd_file.output, ' '||p_file_value);
420: ELSIF p_report_type ='R' THEN
421: -- put the rubric description
422: fnd_file.put(fnd_file.output, ' '||p_rubric_desc);
423: --Bug 3756137
424: if p_rubric_code <> 'S41.G01.00.026' or p_file_value <> '99999' then
425: -- write the file value
426: fnd_file.put(fnd_file.output, ' '||p_file_value);

Line 426: fnd_file.put(fnd_file.output, ' '||p_file_value);

422: fnd_file.put(fnd_file.output, ' '||p_rubric_desc);
423: --Bug 3756137
424: if p_rubric_code <> 'S41.G01.00.026' or p_file_value <> '99999' then
425: -- write the file value
426: fnd_file.put(fnd_file.output, ' '||p_file_value);
427: end if;
428: --Bug 3756137
429: IF p_user_value IS NOT NULL THEN
430: -- write the user value

Line 431: fnd_file.put(fnd_file.output, ' '||p_user_value);

427: end if;
428: --Bug 3756137
429: IF p_user_value IS NOT NULL THEN
430: -- write the user value
431: fnd_file.put(fnd_file.output, ' '||p_user_value);
432: END IF;
433: END IF;
434: -- insert a line after each rubric
435: fnd_file.new_line(fnd_file.output, 1);

Line 435: fnd_file.new_line(fnd_file.output, 1);

431: fnd_file.put(fnd_file.output, ' '||p_user_value);
432: END IF;
433: END IF;
434: -- insert a line after each rubric
435: fnd_file.new_line(fnd_file.output, 1);
436: --
437: --
438: EXCEPTION
439: WHEN OTHERS THEN raise;

Line 492: fnd_file.new_line(fnd_file.output,2);

488: l_s10_heading_text :=hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_INFO');
489: l_issuing_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_NAME');
490: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
491: --
492: fnd_file.new_line(fnd_file.output,2);
493: fnd_file.put_line(fnd_file.output,l_s10_heading_text);
494: fnd_file.put_line(fnd_file.output,l_issuing_estab_text ||' : '||l_header_issue_estab);
495: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s10_cre_estab);
496: fnd_file.new_line(fnd_file.output, 1);

Line 493: fnd_file.put_line(fnd_file.output,l_s10_heading_text);

489: l_issuing_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_NAME');
490: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
491: --
492: fnd_file.new_line(fnd_file.output,2);
493: fnd_file.put_line(fnd_file.output,l_s10_heading_text);
494: fnd_file.put_line(fnd_file.output,l_issuing_estab_text ||' : '||l_header_issue_estab);
495: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s10_cre_estab);
496: fnd_file.new_line(fnd_file.output, 1);
497: --

Line 494: fnd_file.put_line(fnd_file.output,l_issuing_estab_text ||' : '||l_header_issue_estab);

490: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
491: --
492: fnd_file.new_line(fnd_file.output,2);
493: fnd_file.put_line(fnd_file.output,l_s10_heading_text);
494: fnd_file.put_line(fnd_file.output,l_issuing_estab_text ||' : '||l_header_issue_estab);
495: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s10_cre_estab);
496: fnd_file.new_line(fnd_file.output, 1);
497: --
498: -- fetch the values for s10

Line 495: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s10_cre_estab);

491: --
492: fnd_file.new_line(fnd_file.output,2);
493: fnd_file.put_line(fnd_file.output,l_s10_heading_text);
494: fnd_file.put_line(fnd_file.output,l_issuing_estab_text ||' : '||l_header_issue_estab);
495: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s10_cre_estab);
496: fnd_file.new_line(fnd_file.output, 1);
497: --
498: -- fetch the values for s10
499: FOR get_s10_rec IN csr_get_S10_rec(l_payroll_action_id) LOOP

Line 496: fnd_file.new_line(fnd_file.output, 1);

492: fnd_file.new_line(fnd_file.output,2);
493: fnd_file.put_line(fnd_file.output,l_s10_heading_text);
494: fnd_file.put_line(fnd_file.output,l_issuing_estab_text ||' : '||l_header_issue_estab);
495: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s10_cre_estab);
496: fnd_file.new_line(fnd_file.output, 1);
497: --
498: -- fetch the values for s10
499: FOR get_s10_rec IN csr_get_S10_rec(l_payroll_action_id) LOOP
500: -- print only mandatory or non-null non-mandatory fields

Line 538: fnd_file.new_line(fnd_file.output,2);

534: OPEN csr_s20_header_data(l_payroll_action_id,comp_rec.company_id);
535: FETCH csr_s20_header_data INTO l_comp_name, l_s20_cre_estab, l_hq_name, l_fisc_name;
536: CLOSE csr_s20_header_data;
537: -- write the header into the file
538: fnd_file.new_line(fnd_file.output,2);
539: fnd_file.put_line(fnd_file.output,l_s20_heading_text);
540: fnd_file.put_line(fnd_file.output,l_comp_text||' : '||l_comp_name);
541: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);
542: fnd_file.put_line(fnd_file.output,l_fisc_text||' : '||l_fisc_name);

Line 539: fnd_file.put_line(fnd_file.output,l_s20_heading_text);

535: FETCH csr_s20_header_data INTO l_comp_name, l_s20_cre_estab, l_hq_name, l_fisc_name;
536: CLOSE csr_s20_header_data;
537: -- write the header into the file
538: fnd_file.new_line(fnd_file.output,2);
539: fnd_file.put_line(fnd_file.output,l_s20_heading_text);
540: fnd_file.put_line(fnd_file.output,l_comp_text||' : '||l_comp_name);
541: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);
542: fnd_file.put_line(fnd_file.output,l_fisc_text||' : '||l_fisc_name);
543: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s20_cre_estab);

Line 540: fnd_file.put_line(fnd_file.output,l_comp_text||' : '||l_comp_name);

536: CLOSE csr_s20_header_data;
537: -- write the header into the file
538: fnd_file.new_line(fnd_file.output,2);
539: fnd_file.put_line(fnd_file.output,l_s20_heading_text);
540: fnd_file.put_line(fnd_file.output,l_comp_text||' : '||l_comp_name);
541: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);
542: fnd_file.put_line(fnd_file.output,l_fisc_text||' : '||l_fisc_name);
543: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s20_cre_estab);
544: fnd_file.new_line(fnd_file.output,1);

Line 541: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);

537: -- write the header into the file
538: fnd_file.new_line(fnd_file.output,2);
539: fnd_file.put_line(fnd_file.output,l_s20_heading_text);
540: fnd_file.put_line(fnd_file.output,l_comp_text||' : '||l_comp_name);
541: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);
542: fnd_file.put_line(fnd_file.output,l_fisc_text||' : '||l_fisc_name);
543: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s20_cre_estab);
544: fnd_file.new_line(fnd_file.output,1);
545: --

Line 542: fnd_file.put_line(fnd_file.output,l_fisc_text||' : '||l_fisc_name);

538: fnd_file.new_line(fnd_file.output,2);
539: fnd_file.put_line(fnd_file.output,l_s20_heading_text);
540: fnd_file.put_line(fnd_file.output,l_comp_text||' : '||l_comp_name);
541: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);
542: fnd_file.put_line(fnd_file.output,l_fisc_text||' : '||l_fisc_name);
543: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s20_cre_estab);
544: fnd_file.new_line(fnd_file.output,1);
545: --
546: -- Fetch S20 data

Line 543: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s20_cre_estab);

539: fnd_file.put_line(fnd_file.output,l_s20_heading_text);
540: fnd_file.put_line(fnd_file.output,l_comp_text||' : '||l_comp_name);
541: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);
542: fnd_file.put_line(fnd_file.output,l_fisc_text||' : '||l_fisc_name);
543: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s20_cre_estab);
544: fnd_file.new_line(fnd_file.output,1);
545: --
546: -- Fetch S20 data
547: FOR S20_data_rec IN csr_get_S20_data(l_payroll_action_id,

Line 544: fnd_file.new_line(fnd_file.output,1);

540: fnd_file.put_line(fnd_file.output,l_comp_text||' : '||l_comp_name);
541: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);
542: fnd_file.put_line(fnd_file.output,l_fisc_text||' : '||l_fisc_name);
543: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s20_cre_estab);
544: fnd_file.new_line(fnd_file.output,1);
545: --
546: -- Fetch S20 data
547: FOR S20_data_rec IN csr_get_S20_data(l_payroll_action_id,
548: comp_rec.company_id) LOOP

Line 664: fnd_file.new_line(fnd_file.output,2);

660: l_header_first_name,
661: l_header_last_name;
662: CLOSE csr_s30_header_data;
663: -- write the header lines for s30
664: fnd_file.new_line(fnd_file.output,2);
665: fnd_file.put_line(fnd_file.output,l_s30_heading_text);
666: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
667: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
668: fnd_file.new_line(fnd_file.output, 1);

Line 665: fnd_file.put_line(fnd_file.output,l_s30_heading_text);

661: l_header_last_name;
662: CLOSE csr_s30_header_data;
663: -- write the header lines for s30
664: fnd_file.new_line(fnd_file.output,2);
665: fnd_file.put_line(fnd_file.output,l_s30_heading_text);
666: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
667: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
668: fnd_file.new_line(fnd_file.output, 1);
669: --

Line 666: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);

662: CLOSE csr_s30_header_data;
663: -- write the header lines for s30
664: fnd_file.new_line(fnd_file.output,2);
665: fnd_file.put_line(fnd_file.output,l_s30_heading_text);
666: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
667: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
668: fnd_file.new_line(fnd_file.output, 1);
669: --
670: -- fetch s30 data archived for this company and assignment action

Line 667: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);

663: -- write the header lines for s30
664: fnd_file.new_line(fnd_file.output,2);
665: fnd_file.put_line(fnd_file.output,l_s30_heading_text);
666: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
667: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
668: fnd_file.new_line(fnd_file.output, 1);
669: --
670: -- fetch s30 data archived for this company and assignment action
671: FOR S30_data_rec IN csr_get_S30_data(l_asg_action_id,

Line 668: fnd_file.new_line(fnd_file.output, 1);

664: fnd_file.new_line(fnd_file.output,2);
665: fnd_file.put_line(fnd_file.output,l_s30_heading_text);
666: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
667: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
668: fnd_file.new_line(fnd_file.output, 1);
669: --
670: -- fetch s30 data archived for this company and assignment action
671: FOR S30_data_rec IN csr_get_S30_data(l_asg_action_id,
672: comp_rec.company_id) LOOP

Line 707: fnd_file.new_line(fnd_file.output,2);

703: l_header_start_period,
704: l_header_end_period;
705: CLOSE csr_s41_header_data;
706: -- Write the header lines
707: fnd_file.new_line(fnd_file.output,2);
708: fnd_file.put_line(fnd_file.output,l_s41_heading_text);
709: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
710: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
711: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);

Line 708: fnd_file.put_line(fnd_file.output,l_s41_heading_text);

704: l_header_end_period;
705: CLOSE csr_s41_header_data;
706: -- Write the header lines
707: fnd_file.new_line(fnd_file.output,2);
708: fnd_file.put_line(fnd_file.output,l_s41_heading_text);
709: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
710: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
711: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);
712: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);

Line 709: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);

705: CLOSE csr_s41_header_data;
706: -- Write the header lines
707: fnd_file.new_line(fnd_file.output,2);
708: fnd_file.put_line(fnd_file.output,l_s41_heading_text);
709: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
710: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
711: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);
712: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);
713: fnd_file.put_line(fnd_file.output,l_end_date_text||' : '||l_header_end_period);

Line 710: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);

706: -- Write the header lines
707: fnd_file.new_line(fnd_file.output,2);
708: fnd_file.put_line(fnd_file.output,l_s41_heading_text);
709: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
710: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
711: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);
712: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);
713: fnd_file.put_line(fnd_file.output,l_end_date_text||' : '||l_header_end_period);
714: fnd_file.new_line(fnd_file.output, 1);

Line 711: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);

707: fnd_file.new_line(fnd_file.output,2);
708: fnd_file.put_line(fnd_file.output,l_s41_heading_text);
709: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
710: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
711: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);
712: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);
713: fnd_file.put_line(fnd_file.output,l_end_date_text||' : '||l_header_end_period);
714: fnd_file.new_line(fnd_file.output, 1);
715: --

Line 712: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);

708: fnd_file.put_line(fnd_file.output,l_s41_heading_text);
709: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
710: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
711: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);
712: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);
713: fnd_file.put_line(fnd_file.output,l_end_date_text||' : '||l_header_end_period);
714: fnd_file.new_line(fnd_file.output, 1);
715: --
716: -- fetch S41 records

Line 713: fnd_file.put_line(fnd_file.output,l_end_date_text||' : '||l_header_end_period);

709: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
710: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
711: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);
712: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);
713: fnd_file.put_line(fnd_file.output,l_end_date_text||' : '||l_header_end_period);
714: fnd_file.new_line(fnd_file.output, 1);
715: --
716: -- fetch S41 records
717: FOR s41_data_rec IN csr_get_s41_data(l_asg_action_id,

Line 714: fnd_file.new_line(fnd_file.output, 1);

710: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
711: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);
712: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);
713: fnd_file.put_line(fnd_file.output,l_end_date_text||' : '||l_header_end_period);
714: fnd_file.new_line(fnd_file.output, 1);
715: --
716: -- fetch S41 records
717: FOR s41_data_rec IN csr_get_s41_data(l_asg_action_id,
718: comp_rec.company_id,

Line 767: fnd_file.new_line(fnd_file.output,2);

763: OPEN csr_s80_header_data(l_payroll_action_id,count_s80_rec.estab_id);
764: FETCH csr_s80_header_data INTO l_s80_header_estab_name;
765: CLOSE csr_s80_header_data;
766: -- write header lines for s80
767: fnd_file.new_line(fnd_file.output,2);
768: fnd_file.put_line(fnd_file.output,l_s80_heading_text);
769: fnd_file.put_line(fnd_file.output,l_s80_estab_text||' : '||l_s80_header_estab_name);
770: fnd_file.new_line(fnd_file.output, 1);
771: --

Line 768: fnd_file.put_line(fnd_file.output,l_s80_heading_text);

764: FETCH csr_s80_header_data INTO l_s80_header_estab_name;
765: CLOSE csr_s80_header_data;
766: -- write header lines for s80
767: fnd_file.new_line(fnd_file.output,2);
768: fnd_file.put_line(fnd_file.output,l_s80_heading_text);
769: fnd_file.put_line(fnd_file.output,l_s80_estab_text||' : '||l_s80_header_estab_name);
770: fnd_file.new_line(fnd_file.output, 1);
771: --
772: -- Get S80 data

Line 769: fnd_file.put_line(fnd_file.output,l_s80_estab_text||' : '||l_s80_header_estab_name);

765: CLOSE csr_s80_header_data;
766: -- write header lines for s80
767: fnd_file.new_line(fnd_file.output,2);
768: fnd_file.put_line(fnd_file.output,l_s80_heading_text);
769: fnd_file.put_line(fnd_file.output,l_s80_estab_text||' : '||l_s80_header_estab_name);
770: fnd_file.new_line(fnd_file.output, 1);
771: --
772: -- Get S80 data
773: FOR s80_data_rec IN csr_get_s80_data(l_payroll_action_id,

Line 770: fnd_file.new_line(fnd_file.output, 1);

766: -- write header lines for s80
767: fnd_file.new_line(fnd_file.output,2);
768: fnd_file.put_line(fnd_file.output,l_s80_heading_text);
769: fnd_file.put_line(fnd_file.output,l_s80_estab_text||' : '||l_s80_header_estab_name);
770: fnd_file.new_line(fnd_file.output, 1);
771: --
772: -- Get S80 data
773: FOR s80_data_rec IN csr_get_s80_data(l_payroll_action_id,
774: count_s80_rec.estab_id)LOOP

Line 796: fnd_file.new_line(fnd_file.output,2);

792: END LOOP;
793: -- WRITE S90 DATA
794: -- print header for S90
795: l_s90_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S90_TOTALS');
796: fnd_file.new_line(fnd_file.output,2);
797: fnd_file.put_line(fnd_file.output,l_s90_heading_text);
798: fnd_file.new_line(fnd_file.output, 1);
799: --
800: -- Get s90 data

Line 797: fnd_file.put_line(fnd_file.output,l_s90_heading_text);

793: -- WRITE S90 DATA
794: -- print header for S90
795: l_s90_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S90_TOTALS');
796: fnd_file.new_line(fnd_file.output,2);
797: fnd_file.put_line(fnd_file.output,l_s90_heading_text);
798: fnd_file.new_line(fnd_file.output, 1);
799: --
800: -- Get s90 data
801: FOR s90_data_rec IN csr_get_s90_data(l_payroll_action_id) LOOP

Line 798: fnd_file.new_line(fnd_file.output, 1);

794: -- print header for S90
795: l_s90_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S90_TOTALS');
796: fnd_file.new_line(fnd_file.output,2);
797: fnd_file.put_line(fnd_file.output,l_s90_heading_text);
798: fnd_file.new_line(fnd_file.output, 1);
799: --
800: -- Get s90 data
801: FOR s90_data_rec IN csr_get_s90_data(l_payroll_action_id) LOOP
802: IF p_declaration_nature = '02' THEN

Line 1169: fnd_file.put_line(fnd_file.output,p_error_warning||':'||p_rubric_code||':'||p_error_warning_message);

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
1171: fnd_file.new_line(fnd_file.output, 1);
1172:
1173: hr_utility.set_location('leaving write into file',3);

Line 1171: fnd_file.new_line(fnd_file.output, 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
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;

Line 1247: fnd_file.new_line(fnd_file.output,2);

1243: l_s10_heading_text :=hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_INFO');
1244: l_issuing_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_NAME');
1245: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
1246: --
1247: fnd_file.new_line(fnd_file.output,2);
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);

Line 1248: fnd_file.put_line(fnd_file.output,l_s10_heading_text);

1244: l_issuing_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_NAME');
1245: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
1246: --
1247: fnd_file.new_line(fnd_file.output,2);
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);

Line 1249: fnd_file.put_line(fnd_file.output,l_issuing_estab_text ||' : '||l_header_issue_estab);

1245: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
1246: --
1247: fnd_file.new_line(fnd_file.output,2);
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

Line 1250: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s10_cre_estab);

1246: --
1247: fnd_file.new_line(fnd_file.output,2);
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

Line 1251: fnd_file.new_line(fnd_file.output,1);

1247: fnd_file.new_line(fnd_file.output,2);
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

Line 1288: fnd_file.new_line(fnd_file.output,2);

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);
1291: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);
1292: fnd_file.put_line(fnd_file.output,l_fisc_text||' : '||l_fisc_name);

Line 1289: fnd_file.put_line(fnd_file.output,l_s20_heading_text);

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);
1291: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);
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);

Line 1290: fnd_file.put_line(fnd_file.output,l_comp_text||' : '||l_comp_name);

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);
1291: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);
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);

Line 1291: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);

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);
1291: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);
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: --

Line 1292: fnd_file.put_line(fnd_file.output,l_fisc_text||' : '||l_fisc_name);

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);
1291: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);
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);

Line 1293: fnd_file.put_line(fnd_file.output,l_cre_estab_text||' : '||l_s20_cre_estab);

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);
1291: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);
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

Line 1294: fnd_file.new_line(fnd_file.output,1);

1290: fnd_file.put_line(fnd_file.output,l_comp_text||' : '||l_comp_name);
1291: fnd_file.put_line(fnd_file.output,l_hq_text||' : '||l_hq_name);
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,

Line 1380: fnd_file.new_line(fnd_file.output,2);

1376: l_header_first_name,
1377: l_header_last_name;
1378: CLOSE csr_s30_header_data;
1379: -- write the header lines for s30
1380: fnd_file.new_line(fnd_file.output,2);
1381: fnd_file.put_line(fnd_file.output,l_s30_heading_text);
1382: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
1383: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
1384: fnd_file.new_line(fnd_file.output,1);

Line 1381: fnd_file.put_line(fnd_file.output,l_s30_heading_text);

1377: l_header_last_name;
1378: CLOSE csr_s30_header_data;
1379: -- write the header lines for s30
1380: fnd_file.new_line(fnd_file.output,2);
1381: fnd_file.put_line(fnd_file.output,l_s30_heading_text);
1382: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
1383: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
1384: fnd_file.new_line(fnd_file.output,1);
1385: --

Line 1382: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);

1378: CLOSE csr_s30_header_data;
1379: -- write the header lines for s30
1380: fnd_file.new_line(fnd_file.output,2);
1381: fnd_file.put_line(fnd_file.output,l_s30_heading_text);
1382: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
1383: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
1384: fnd_file.new_line(fnd_file.output,1);
1385: --
1386: -- fetch s30 data archived for this company and assignment action

Line 1383: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);

1379: -- write the header lines for s30
1380: fnd_file.new_line(fnd_file.output,2);
1381: fnd_file.put_line(fnd_file.output,l_s30_heading_text);
1382: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
1383: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
1384: fnd_file.new_line(fnd_file.output,1);
1385: --
1386: -- fetch s30 data archived for this company and assignment action
1387: FOR S30_data_rec IN csr_get_S30_data(l_asg_action_id,

Line 1384: fnd_file.new_line(fnd_file.output,1);

1380: fnd_file.new_line(fnd_file.output,2);
1381: fnd_file.put_line(fnd_file.output,l_s30_heading_text);
1382: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
1383: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
1384: fnd_file.new_line(fnd_file.output,1);
1385: --
1386: -- fetch s30 data archived for this company and assignment action
1387: FOR S30_data_rec IN csr_get_S30_data(l_asg_action_id,
1388: comp_rec.company_id) LOOP

Line 1414: fnd_file.new_line(fnd_file.output,2);

1410: l_header_start_period,
1411: l_header_end_period;
1412: CLOSE csr_s41_header_data;
1413: -- Write the header lines
1414: fnd_file.new_line(fnd_file.output,2);
1415: fnd_file.put_line(fnd_file.output,l_s41_heading_text);
1416: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
1417: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
1418: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);

Line 1415: fnd_file.put_line(fnd_file.output,l_s41_heading_text);

1411: l_header_end_period;
1412: CLOSE csr_s41_header_data;
1413: -- Write the header lines
1414: fnd_file.new_line(fnd_file.output,2);
1415: fnd_file.put_line(fnd_file.output,l_s41_heading_text);
1416: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
1417: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
1418: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);
1419: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);

Line 1416: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);

1412: CLOSE csr_s41_header_data;
1413: -- Write the header lines
1414: fnd_file.new_line(fnd_file.output,2);
1415: fnd_file.put_line(fnd_file.output,l_s41_heading_text);
1416: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
1417: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
1418: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);
1419: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);
1420: fnd_file.put_line(fnd_file.output,l_end_date_text||' : '||l_header_end_period);

Line 1417: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);

1413: -- Write the header lines
1414: fnd_file.new_line(fnd_file.output,2);
1415: fnd_file.put_line(fnd_file.output,l_s41_heading_text);
1416: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
1417: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
1418: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);
1419: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);
1420: fnd_file.put_line(fnd_file.output,l_end_date_text||' : '||l_header_end_period);
1421: fnd_file.new_line(fnd_file.output, 1);

Line 1418: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);

1414: fnd_file.new_line(fnd_file.output,2);
1415: fnd_file.put_line(fnd_file.output,l_s41_heading_text);
1416: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
1417: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
1418: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);
1419: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);
1420: fnd_file.put_line(fnd_file.output,l_end_date_text||' : '||l_header_end_period);
1421: fnd_file.new_line(fnd_file.output, 1);
1422: --

Line 1419: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);

1415: fnd_file.put_line(fnd_file.output,l_s41_heading_text);
1416: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
1417: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
1418: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);
1419: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);
1420: fnd_file.put_line(fnd_file.output,l_end_date_text||' : '||l_header_end_period);
1421: fnd_file.new_line(fnd_file.output, 1);
1422: --
1423: -- fetch S41 records

Line 1420: fnd_file.put_line(fnd_file.output,l_end_date_text||' : '||l_header_end_period);

1416: fnd_file.put_line(fnd_file.output,l_emp_name_text||' : '||l_header_emp_title||' '||l_header_first_name||' '||l_header_last_name);
1417: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
1418: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);
1419: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);
1420: fnd_file.put_line(fnd_file.output,l_end_date_text||' : '||l_header_end_period);
1421: fnd_file.new_line(fnd_file.output, 1);
1422: --
1423: -- fetch S41 records
1424: FOR s41_data_rec IN csr_get_s41_data(l_asg_action_id,

Line 1421: fnd_file.new_line(fnd_file.output, 1);

1417: fnd_file.put_line(fnd_file.output,l_emp_number_text||' : '||l_header_emp_number);
1418: fnd_file.put_line(fnd_file.output,l_emp_estab_text||' : '||l_emp_header_estab_name);
1419: fnd_file.put_line(fnd_file.output,l_start_date_text||' : '||l_header_start_period);
1420: fnd_file.put_line(fnd_file.output,l_end_date_text||' : '||l_header_end_period);
1421: fnd_file.new_line(fnd_file.output, 1);
1422: --
1423: -- fetch S41 records
1424: FOR s41_data_rec IN csr_get_s41_data(l_asg_action_id,
1425: comp_rec.company_id,

Line 1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_fr_general.get_payroll_message('PAY_75195_DADS', 'VALUE1:'||l_comp_name));

1445: -- end loop for assignment actions
1446: END LOOP;
1447: -- #3300005 Printing the warning message, when there are no employees for the given company
1448: IF l_total_employees = 0 THEN
1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_fr_general.get_payroll_message('PAY_75195_DADS', 'VALUE1:'||l_comp_name));
1450: ELSE
1451: l_total_employees := 0;
1452: END IF;
1453: -- end of exclusion for '05' decl nature code

Line 1461: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_fr_general.get_payroll_message('PAY_75198_DADS_NO_COMPANY','VALUE1:'||l_header_issue_estab));

1457: END LOOP;
1458: --
1459: -- #3300005 Printing the warning message when there are no companies in the establishment
1460: IF l_total_companies = 0 THEN
1461: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_fr_general.get_payroll_message('PAY_75198_DADS_NO_COMPANY','VALUE1:'||l_header_issue_estab));
1462: END IF;
1463: -- Get number of INSEE establishments archived
1464: FOR count_s80_rec IN csr_count_s80(l_payroll_action_id) LOOP
1465: -- Check for report inclusions

Line 1477: fnd_file.new_line(fnd_file.output,2);

1473: OPEN csr_s80_header_data(l_payroll_action_id,count_s80_rec.estab_id);
1474: FETCH csr_s80_header_data INTO l_s80_header_estab_name;
1475: CLOSE csr_s80_header_data;
1476: -- write header lines for s80
1477: fnd_file.new_line(fnd_file.output,2);
1478: fnd_file.put_line(fnd_file.output,l_s80_heading_text);
1479: fnd_file.put_line(fnd_file.output,l_s80_estab_text||' : '||l_s80_header_estab_name);
1480: fnd_file.new_line(fnd_file.output, 1);
1481: --

Line 1478: fnd_file.put_line(fnd_file.output,l_s80_heading_text);

1474: FETCH csr_s80_header_data INTO l_s80_header_estab_name;
1475: CLOSE csr_s80_header_data;
1476: -- write header lines for s80
1477: fnd_file.new_line(fnd_file.output,2);
1478: fnd_file.put_line(fnd_file.output,l_s80_heading_text);
1479: fnd_file.put_line(fnd_file.output,l_s80_estab_text||' : '||l_s80_header_estab_name);
1480: fnd_file.new_line(fnd_file.output, 1);
1481: --
1482: -- Get S80 data

Line 1479: fnd_file.put_line(fnd_file.output,l_s80_estab_text||' : '||l_s80_header_estab_name);

1475: CLOSE csr_s80_header_data;
1476: -- write header lines for s80
1477: fnd_file.new_line(fnd_file.output,2);
1478: fnd_file.put_line(fnd_file.output,l_s80_heading_text);
1479: fnd_file.put_line(fnd_file.output,l_s80_estab_text||' : '||l_s80_header_estab_name);
1480: fnd_file.new_line(fnd_file.output, 1);
1481: --
1482: -- Get S80 data
1483: FOR s80_data_rec IN csr_get_s80_data(l_payroll_action_id,

Line 1480: fnd_file.new_line(fnd_file.output, 1);

1476: -- write header lines for s80
1477: fnd_file.new_line(fnd_file.output,2);
1478: fnd_file.put_line(fnd_file.output,l_s80_heading_text);
1479: fnd_file.put_line(fnd_file.output,l_s80_estab_text||' : '||l_s80_header_estab_name);
1480: fnd_file.new_line(fnd_file.output, 1);
1481: --
1482: -- Get S80 data
1483: FOR s80_data_rec IN csr_get_s80_data(l_payroll_action_id,
1484: count_s80_rec.estab_id)LOOP

Line 1498: fnd_file.new_line(fnd_file.output,2);

1494: END LOOP;
1495: -- WRITE S90 DATA
1496: -- print header for S90
1497: l_s90_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S90_TOTALS');
1498: fnd_file.new_line(fnd_file.output,2);
1499: fnd_file.put_line(fnd_file.output,l_s90_heading_text);
1500: fnd_file.new_line(fnd_file.output,1);
1501: --
1502: -- Get s90 data

Line 1499: fnd_file.put_line(fnd_file.output,l_s90_heading_text);

1495: -- WRITE S90 DATA
1496: -- print header for S90
1497: l_s90_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S90_TOTALS');
1498: fnd_file.new_line(fnd_file.output,2);
1499: fnd_file.put_line(fnd_file.output,l_s90_heading_text);
1500: fnd_file.new_line(fnd_file.output,1);
1501: --
1502: -- Get s90 data
1503: FOR s90_data_rec IN csr_get_s90_data(l_payroll_action_id) LOOP

Line 1500: fnd_file.new_line(fnd_file.output,1);

1496: -- print header for S90
1497: l_s90_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S90_TOTALS');
1498: fnd_file.new_line(fnd_file.output,2);
1499: fnd_file.put_line(fnd_file.output,l_s90_heading_text);
1500: fnd_file.new_line(fnd_file.output,1);
1501: --
1502: -- Get s90 data
1503: FOR s90_data_rec IN csr_get_s90_data(l_payroll_action_id) LOOP
1504: IF p_declaration_nature = '02' THEN