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.GHR_462 dependencies on FND_FILE

Line 28: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part1');

24: l_from_date:= fnd_date.canonical_to_date(p_from_date);
25: l_to_date := fnd_date.canonical_to_date(p_to_date);
26: l_fiscal_year := to_number(to_char(l_to_date,'YYYY'));
27: -- Populate the Part 1 of 462 Report
28: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part1');
29: populate_part1(
30: l_from_date,
31: l_to_date,
32: p_agency_code);

Line 33: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part2');

29: populate_part1(
30: l_from_date,
31: l_to_date,
32: p_agency_code);
33: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part2');
34: -- Populate the Part 2 of 462 Report
35: populate_part2(
36: l_from_date,
37: l_to_date,

Line 41: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part4');

37: l_to_date,
38: p_agency_code);
39: PopulatePart4Matrix;
40: -- Populate the Part 4 of 462 Report
41: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part4');
42: populate_part4(
43: l_from_date,
44: l_to_date,
45: p_agency_code);

Line 47: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part5');

43: l_from_date,
44: l_to_date,
45: p_agency_code);
46: -- Populate the Part 5 of 462 Report
47: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part5');
48: populate_part5(
49: l_from_date,
50: l_to_date,
51: p_agency_code);

Line 53: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part6');

49: l_from_date,
50: l_to_date,
51: p_agency_code);
52: -- Populate the Part 6 of 462 Report
53: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part6');
54: populate_part6(
55: l_from_date,
56: l_to_date,
57: p_agency_code);

Line 59: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part7');

55: l_from_date,
56: l_to_date,
57: p_agency_code);
58: -- Populate the Part 7 of 462 Report
59: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part7');
60: populate_part7(
61: l_from_date,
62: l_to_date,
63: p_agency_code);

Line 65: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part8');

61: l_from_date,
62: l_to_date,
63: p_agency_code);
64: -- Populate the Part 8 of 462 Report
65: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part8');
66: populate_part8(
67: l_from_date,
68: l_to_date,
69: p_agency_code);

Line 71: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part10');

67: l_from_date,
68: l_to_date,
69: p_agency_code);
70: -- Populate the Part 10 of 462 Report
71: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part10');
72: populate_part10(
73: l_from_date,
74: l_to_date,
75: p_agency_code);

Line 77: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part11');

73: l_from_date,
74: l_to_date,
75: p_agency_code);
76: -- Populate the Part 11 of 462 Report
77: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate Part11');
78: populate_part11(
79: l_from_date,
80: l_to_date,
81: p_agency_code);

Line 83: fnd_file.put_line(fnd_file.log,'Calling Procedure to write into XML File');

79: l_from_date,
80: l_to_date,
81: p_agency_code);
82: -- Write the values to XML File
83: fnd_file.put_line(fnd_file.log,'Calling Procedure to write into XML File');
84: WritetoXML(
85: p_request_id,
86: p_agency_code,
87: l_fiscal_year,

Line 92: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');

88: l_from_date,
89: l_to_date,
90: l_file_name);
91: p_output_fname := l_file_name;
92: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');
93: fnd_file.put_line(fnd_file.log,'File' || l_file_name );
94: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
95:
96: -- COMMIT;

Line 93: fnd_file.put_line(fnd_file.log,'File' || l_file_name );

89: l_to_date,
90: l_file_name);
91: p_output_fname := l_file_name;
92: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');
93: fnd_file.put_line(fnd_file.log,'File' || l_file_name );
94: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
95:
96: -- COMMIT;
97: EXCEPTION

Line 94: fnd_file.put_line(fnd_file.log,'-------------------------------------------');

90: l_file_name);
91: p_output_fname := l_file_name;
92: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');
93: fnd_file.put_line(fnd_file.log,'File' || l_file_name );
94: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
95:
96: -- COMMIT;
97: EXCEPTION
98: WHEN utl_file.invalid_path then

Line 100: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

96: -- COMMIT;
97: EXCEPTION
98: WHEN utl_file.invalid_path then
99: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
100: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
101: hr_utility.raise_error;
102: --
103: WHEN utl_file.invalid_mode then
104: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 105: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

101: hr_utility.raise_error;
102: --
103: WHEN utl_file.invalid_mode then
104: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
105: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
106: hr_utility.raise_error;
107: --
108: WHEN utl_file.invalid_filehandle then
109: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 110: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

106: hr_utility.raise_error;
107: --
108: WHEN utl_file.invalid_filehandle then
109: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
110: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
111: hr_utility.raise_error;
112: --
113: WHEN utl_file.invalid_operation then
114: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 115: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

111: hr_utility.raise_error;
112: --
113: WHEN utl_file.invalid_operation then
114: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
115: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
116: hr_utility.raise_error;
117: --
118: WHEN utl_file.read_error then
119: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 120: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

116: hr_utility.raise_error;
117: --
118: WHEN utl_file.read_error then
119: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
120: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
121: hr_utility.raise_error;
122: --
123:
124: WHEN others THEN

Line 127: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

123:
124: WHEN others THEN
125: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
126: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
127: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
128: hr_utility.raise_error;
129: END populate_sum;
130:
131: --------------------------------------------

Line 270: fnd_file.put_line(fnd_file.log,'Finished Populating Part 1.A.1 - No. of Individuals whose counseling completed within 30 days ');

266:
267: vXMLTable(vCtr).TagName := 'P1_a1';
268: vXMLTable(vCtr).TagValue := to_char(l_p1_a1);
269: vCtr := vCtr + 1;
270: fnd_file.put_line(fnd_file.log,'Finished Populating Part 1.A.1 - No. of Individuals whose counseling completed within 30 days ');
271:
272: -- Part 1.A.2 No. of Individuals counseled within 31 to 90 days.
273: FOR c_comp1 IN cur_p1_b(p_from_date, p_to_date, p_agency_code) LOOP
274: l_p1_a2 := c_comp1.p1_b_cnt;

Line 280: fnd_file.put_line(fnd_file.log,'Finished Populating Part 1.A.2 - No. of Individuals counseled within 31 to 90 days.');

276:
277: vXMLTable(vCtr).TagName := 'P1_a2';
278: vXMLTable(vCtr).TagValue := to_char(l_p1_a2);
279: vCtr := vCtr + 1;
280: fnd_file.put_line(fnd_file.log,'Finished Populating Part 1.A.2 - No. of Individuals counseled within 31 to 90 days.');
281:
282: -- Part 1.A.3 No. of Individuals counseled beyond 90 days.
283: FOR c_comp1 IN cur_p1_c(p_from_date, p_to_date, p_agency_code) LOOP
284: l_p1_a3 := c_comp1.p1_c_cnt;

Line 290: fnd_file.put_line(fnd_file.log,'Finished Populating Part 1.A.3 - No. of Individuals counseled beyond 90 days.');

286:
287: vXMLTable(vCtr).TagName := 'P1_a3';
288: vXMLTable(vCtr).TagValue := to_char(l_p1_a3);
289: vCtr := vCtr + 1;
290: fnd_file.put_line(fnd_file.log,'Finished Populating Part 1.A.3 - No. of Individuals counseled beyond 90 days.');
291:
292: -- Part 1.A.4 No. of Individuals counseled due to remands.
293:
294: FOR c_comp1 IN cur_p1_d(p_from_date, p_to_date, p_agency_code) LOOP

Line 301: fnd_file.put_line(fnd_file.log,'Finished Populating Part 1.A.4 - No. of Individuals counseled due to remands');

297:
298: vXMLTable(vCtr).TagName := 'P1_a4';
299: vXMLTable(vCtr).TagValue := to_char(l_p1_a4);
300: vCtr := vCtr + 1;
301: fnd_file.put_line(fnd_file.log,'Finished Populating Part 1.A.4 - No. of Individuals counseled due to remands');
302:
303: -- Part 1 Total No. of individuals counseled.
304: l_p1_a := l_p1_a1 + l_p1_a2 + l_p1_a3 + l_p1_a4;
305:

Line 309: fnd_file.put_line(fnd_file.log,'Finished populating Part1 - Total No. of individuals counseled');

305:
306: vXMLTable(vCtr).TagName := 'P1_a';
307: vXMLTable(vCtr).TagValue := to_char(l_p1_a);
308: vCtr := vCtr + 1;
309: fnd_file.put_line(fnd_file.log,'Finished populating Part1 - Total No. of individuals counseled');
310: -----------------------------------------------------------------------------
311: --Section 2 Non-ADR Settlements during Counseling
312: -----------------------------------------------------------------------------
313: -- Populating Counts

Line 400: fnd_file.put_line(fnd_file.log,'Finished populating Part 1 Section 2 - Non-ADR Settlements during Counseling');

396: vXMLTable(vCtr).TagName := 'P1_bamt7';
397: vXMLTable(vCtr).TagValue := '0';
398: vCtr := vCtr + 1;
399:
400: fnd_file.put_line(fnd_file.log,'Finished populating Part 1 Section 2 - Non-ADR Settlements during Counseling');
401: -----------------------------------------------------------------------------
402: -- Section 3 Non-ADR Settlements with Non-Monetory Benefits
403: -----------------------------------------------------------------------------
404:

Line 412: fnd_file.put_line(fnd_file.log,'Finished populating Part 1 - Section 3');

408:
409: vXMLTable(vCtr).TagName := 'P1_c';
410: vXMLTable(vCtr).TagValue := to_char(l_p1_c);
411: vCtr := vCtr + 1;
412: fnd_file.put_line(fnd_file.log,'Finished populating Part 1 - Section 3');
413: fnd_file.put_line(fnd_file.log,'------------End of Part1----------------');
414:
415: END populate_part1;
416:

Line 413: fnd_file.put_line(fnd_file.log,'------------End of Part1----------------');

409: vXMLTable(vCtr).TagName := 'P1_c';
410: vXMLTable(vCtr).TagValue := to_char(l_p1_c);
411: vCtr := vCtr + 1;
412: fnd_file.put_line(fnd_file.log,'Finished populating Part 1 - Section 3');
413: fnd_file.put_line(fnd_file.log,'------------End of Part1----------------');
414:
415: END populate_part1;
416:
417: PROCEDURE populate_part2(

Line 670: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 1 - No. of complaints on hand at beginning of the reporting period.');

666: vXMLTable(vCtr).TagName := 'P2_a';
667: vXMLTable(vCtr).TagValue := to_char(l_p2_a);
668: vCtr := vCtr + 1;
669: END LOOP;
670: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 1 - No. of complaints on hand at beginning of the reporting period.');
671: -- Section 2 - Complaints filed
672: FOR cur_ctr IN cur_p2_2(p_from_date,p_to_date, p_agency_code) LOOP
673: l_p2_b := cur_ctr.p2_2_cnt;
674: vXMLTable(vCtr).TagName := 'P2_b';

Line 678: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 2 - Complaints filed');

674: vXMLTable(vCtr).TagName := 'P2_b';
675: vXMLTable(vCtr).TagValue := to_char(l_p2_b);
676: vCtr := vCtr + 1;
677: END LOOP;
678: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 2 - Complaints filed');
679: -- Section 3 - Remand
680: FOR cur_ctr IN cur_p2_3(p_from_date,p_to_date, p_agency_code) LOOP
681: l_p2_c := cur_ctr.p2_3_cnt;
682: vXMLTable(vCtr).TagName := 'P2_c';

Line 686: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 3 - Remand');

682: vXMLTable(vCtr).TagName := 'P2_c';
683: vXMLTable(vCtr).TagValue := to_char(l_p2_c);
684: vCtr := vCtr + 1;
685: END LOOP;
686: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 3 - Remand');
687: -- Section 4 - Total Complaints
688: l_p2_d := l_p2_a + l_p2_b + l_p2_c;
689:
690: vXMLTable(vCtr).TagName := 'P2_d';

Line 693: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 4 - Total Complaints');

689:
690: vXMLTable(vCtr).TagName := 'P2_d';
691: vXMLTable(vCtr).TagValue := to_char(l_p2_d);
692: vCtr := vCtr + 1;
693: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 4 - Total Complaints');
694: -- Section 5 - Total Complaints that were not consolidated.
695: FOR cur_ctr IN cur_p2_5(p_from_date,p_to_date, p_agency_code) LOOP
696: l_p2_e := cur_ctr.p2_5_cnt;
697: vXMLTable(vCtr).TagName := 'P2_e';

Line 701: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 5 - Total Complaints that were not consolidated.');

697: vXMLTable(vCtr).TagName := 'P2_e';
698: vXMLTable(vCtr).TagValue := to_char(l_p2_e);
699: vCtr := vCtr + 1;
700: END LOOP;
701: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 5 - Total Complaints that were not consolidated.');
702: -- Section 6 - Total Complaints that were not consolidated and closed.
703: FOR cur_ctr IN cur_p2_6(p_from_date,p_to_date, p_agency_code) LOOP
704: l_p2_f := cur_ctr.p2_6_cnt;
705: vXMLTable(vCtr).TagName := 'P2_f';

Line 709: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 6 - Total Complaints that were not consolidated and closed.');

705: vXMLTable(vCtr).TagName := 'P2_f';
706: vXMLTable(vCtr).TagValue := to_char(l_p2_f);
707: vCtr := vCtr + 1;
708: END LOOP;
709: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 6 - Total Complaints that were not consolidated and closed.');
710: -- Section 7 - No. of consolidated complaints
711: FOR cur_ctr IN cur_p2_7(p_from_date,p_to_date, p_agency_code) LOOP
712: l_p2_g := cur_ctr.p2_7_cnt;
713: vXMLTable(vCtr).TagName := 'P2_g';

Line 717: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 7 - No. of consolidated complaints');

713: vXMLTable(vCtr).TagName := 'P2_g';
714: vXMLTable(vCtr).TagValue := to_char(l_p2_g);
715: vCtr := vCtr + 1;
716: END LOOP;
717: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 7 - No. of consolidated complaints');
718: -- Section 8 - Total Complaints that were consolidated and closed.
719: FOR cur_ctr IN cur_p2_8(p_from_date,p_to_date, p_agency_code) LOOP
720: l_p2_h := cur_ctr.p2_8_cnt;
721: vXMLTable(vCtr).TagName := 'P2_h';

Line 725: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 8 - Total Complaints that were consolidated and closed');

721: vXMLTable(vCtr).TagName := 'P2_h';
722: vXMLTable(vCtr).TagValue := to_char(l_p2_h);
723: vCtr := vCtr + 1;
724: END LOOP;
725: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 8 - Total Complaints that were consolidated and closed');
726: -- Section 9 - Complaints on hand at end of reporting period := line 4 - (line 6 + line 8)
727: l_p2_i := l_p2_d - (l_p2_f + l_p2_h);
728: vXMLTable(vCtr).TagName := 'P2_i';
729: vXMLTable(vCtr).TagValue := to_char(l_p2_i);

Line 731: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 9 - Complaints on hand at end of reporting period');

727: l_p2_i := l_p2_d - (l_p2_f + l_p2_h);
728: vXMLTable(vCtr).TagName := 'P2_i';
729: vXMLTable(vCtr).TagValue := to_char(l_p2_i);
730: vCtr := vCtr + 1;
731: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 9 - Complaints on hand at end of reporting period');
732: -- Section 10 Individual filing complaints
733: FOR cur_ctr IN cur_p2_10(p_from_date,p_to_date, p_agency_code) LOOP
734: vXMLTable(vCtr).TagName := 'P2_j';
735: vXMLTable(vCtr).TagValue := to_char(cur_ctr.p2_10_cnt);

Line 738: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 10 - Individual filing complaints');

734: vXMLTable(vCtr).TagName := 'P2_j';
735: vXMLTable(vCtr).TagValue := to_char(cur_ctr.p2_10_cnt);
736: vCtr := vCtr + 1;
737: END LOOP;
738: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 10 - Individual filing complaints');
739: -- Section 11 No. of Joint Processing Units from Consolidation of Complaints
740: FOR cur_ctr IN cur_p2_11(p_from_date,p_to_date, p_agency_code) LOOP
741: vXMLTable(vCtr).TagName := 'P2_k';
742: vXMLTable(vCtr).TagValue := to_char(cur_ctr.p2_11_cnt);

Line 745: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 11 - No. of Joint Processing Units from Consolidation of Complaints');

741: vXMLTable(vCtr).TagName := 'P2_k';
742: vXMLTable(vCtr).TagValue := to_char(cur_ctr.p2_11_cnt);
743: vCtr := vCtr + 1;
744: END LOOP;
745: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 11 - No. of Joint Processing Units from Consolidation of Complaints');
746: fnd_file.put_line(fnd_file.log,'-----------End of Part 2----------------');
747: -- End of Part 2
748: END populate_part2;
749:

Line 746: fnd_file.put_line(fnd_file.log,'-----------End of Part 2----------------');

742: vXMLTable(vCtr).TagValue := to_char(cur_ctr.p2_11_cnt);
743: vCtr := vCtr + 1;
744: END LOOP;
745: fnd_file.put_line(fnd_file.log,'Finished populating Part2 Section 11 - No. of Joint Processing Units from Consolidation of Complaints');
746: fnd_file.put_line(fnd_file.log,'-----------End of Part 2----------------');
747: -- End of Part 2
748: END populate_part2;
749:
750:

Line 1154: fnd_file.put_line(fnd_file.log,'Starting Part4 - Fields');

1150: l_P4_i18 NUMBER := 0;
1151: l_P4_i19 NUMBER := 0;
1152:
1153: BEGIN
1154: fnd_file.put_line(fnd_file.log,'Starting Part4 - Fields');
1155: -- Loop through p4 matrix PL/SQL tables
1156: FOR p4_ctr IN v_P4Matrix.FIRST .. v_P4Matrix.LAST LOOP
1157: -- If value is null, call the cursor cur_p4_novalue, else call the cursor cur_p4
1158: IF TRIM(v_P4Matrix(p4_ctr).basevalues) IS NULL THEN

Line 1163: -- fnd_file.put_line(fnd_file.log,'Finished populating Part4 ' || vXMLTable(vCtr).TagName);

1159: FOR cur_ctr IN cur_p4_novalue(p_from_date,p_to_date,v_P4Matrix(p4_ctr).claims,v_P4Matrix(p4_ctr).bases, p_agency_code) LOOP
1160: vXMLTable(vCtr).TagName := v_P4Matrix(p4_ctr).fieldname;
1161: vXMLTable(vCtr).TagValue := to_char(cur_ctr.p4_cnt);
1162: -- vCtr := vCtr + 1;
1163: -- fnd_file.put_line(fnd_file.log,'Finished populating Part4 ' || vXMLTable(vCtr).TagName);
1164:
1165: IF SUBSTR(vXMLTable(vCtr).TagName,1,4) = 'P4_e' THEN
1166: IF SUBSTR(vXMLTable(vCtr).TagName,LENGTH(vXMLTable(vCtr).TagName)-1) = '_1' THEN
1167: l_P4_e1 := l_P4_e1 + vXMLTable(vCtr).TagValue;

Line 1683: -- fnd_file.put_line(fnd_file.log,'Finished populating Part4 ' || vXMLTable(vCtr).TagName);

1679: FOR cur_ctr IN cur_p4(p_from_date,p_to_date,v_P4Matrix(p4_ctr).claims,v_P4Matrix(p4_ctr).bases,v_P4Matrix(p4_ctr).basevalues, p_agency_code) LOOP
1680: vXMLTable(vCtr).TagName := v_P4Matrix(p4_ctr).fieldname;
1681: vXMLTable(vCtr).TagValue := to_char(cur_ctr.p4_cnt);
1682: -- vCtr := vCtr + 1;
1683: -- fnd_file.put_line(fnd_file.log,'Finished populating Part4 ' || vXMLTable(vCtr).TagName);
1684:
1685: IF SUBSTR(vXMLTable(vCtr).TagName,1,4) = 'P4_e' THEN
1686: IF SUBSTR(vXMLTable(vCtr).TagName,LENGTH(vXMLTable(vCtr).TagName)-1) = '_1' THEN
1687: l_P4_e1 := l_P4_e1 + vXMLTable(vCtr).TagValue;

Line 2287: fnd_file.put_line(fnd_file.log,'Finished populating Part4 - Fields');

2283: vCtr := vCtr + 1;
2284: END LOOP;
2285: END IF;
2286: END LOOP;
2287: fnd_file.put_line(fnd_file.log,'Finished populating Part4 - Fields');
2288:
2289: l_P4_e17 := l_P4_e1 + l_P4_e2 + l_P4_e3 + l_P4_e4 + l_P4_e5 + l_P4_e6 + l_P4_e7 + l_P4_e8 + l_P4_e9 + l_P4_e10 + l_P4_e11 + l_P4_e14 + l_P4_e15 + l_P4_e16;
2290: l_P4_m17 := l_P4_m1 + l_P4_m2 + l_P4_m3 + l_P4_m4 + l_P4_m5 + l_P4_m6 + l_P4_m7 + l_P4_m8 + l_P4_m9 + l_P4_m10 + l_P4_m11 + l_P4_m14 + l_P4_m15 + l_P4_m16;
2291: l_P4_i17 := l_P4_i1 + l_P4_i2 + l_P4_i3 + l_P4_i4 + l_P4_i5 + l_P4_i6 + l_P4_i7 + l_P4_i8 + l_P4_i9 + l_P4_i10 + l_P4_i11 + l_P4_i14 + l_P4_i15 + l_P4_i16;

Line 2757: fnd_file.put_line(fnd_file.log,'Finished populating Part4 - Total fields by Issues');

2753: END IF;
2754: END LOOP;
2755: END LOOP;
2756:
2757: fnd_file.put_line(fnd_file.log,'Finished populating Part4 - Total fields by Issues');
2758: --------------
2759: vXMLTable(vCtr).TagName := 'P4_tot1_1';
2760: vXMLTable(vCtr).TagValue := to_char(l_tot1_1);
2761: vCtr := vCtr + 1;

Line 2903: fnd_file.put_line(fnd_file.log,'Finished populating Part4 - Total fields by Bases');

2899: vCtr := vCtr + 1;
2900: vXMLTable(vCtr).TagName := 'P4_tot3_16';
2901: vXMLTable(vCtr).TagValue := to_char(l_tot3_16);
2902: vCtr := vCtr + 1;
2903: fnd_file.put_line(fnd_file.log,'Finished populating Part4 - Total fields by Bases');
2904: fnd_file.put_line(fnd_file.log,'------------End of Part4----------------');
2905:
2906: END populate_part4;
2907:

Line 2904: fnd_file.put_line(fnd_file.log,'------------End of Part4----------------');

2900: vXMLTable(vCtr).TagName := 'P4_tot3_16';
2901: vXMLTable(vCtr).TagValue := to_char(l_tot3_16);
2902: vCtr := vCtr + 1;
2903: fnd_file.put_line(fnd_file.log,'Finished populating Part4 - Total fields by Bases');
2904: fnd_file.put_line(fnd_file.log,'------------End of Part4----------------');
2905:
2906: END populate_part4;
2907:
2908: PROCEDURE populate_part5(

Line 2938: fnd_file.put_line(fnd_file.log,'Finished populating Part5 - Title VII');

2934: vXMLTable(vCtr).TagValue := to_char(cur_ctr.p5_cnt);
2935: l_P5_a1 := cur_ctr.p5_cnt;
2936: vCtr := vCtr + 1;
2937: END LOOP;
2938: fnd_file.put_line(fnd_file.log,'Finished populating Part5 - Title VII');
2939: -- Age Discrimination
2940: FOR cur_ctr IN cur_p5(p_from_date,p_to_date,'20', p_agency_code) LOOP
2941: vXMLTable(vCtr).TagName := 'P5_a2';
2942: vXMLTable(vCtr).TagValue := to_char(cur_ctr.p5_cnt);

Line 2946: fnd_file.put_line(fnd_file.log,'Finished populating Part5 - Age Discrimination');

2942: vXMLTable(vCtr).TagValue := to_char(cur_ctr.p5_cnt);
2943: l_P5_a2 := cur_ctr.p5_cnt;
2944: vCtr := vCtr + 1;
2945: END LOOP;
2946: fnd_file.put_line(fnd_file.log,'Finished populating Part5 - Age Discrimination');
2947: -- Rehabilitation act
2948: FOR cur_ctr IN cur_p5(p_from_date,p_to_date,'30', p_agency_code) LOOP
2949: vXMLTable(vCtr).TagName := 'P5_a3';
2950: vXMLTable(vCtr).TagValue := to_char(cur_ctr.p5_cnt);

Line 2954: fnd_file.put_line(fnd_file.log,'Finished populating Part5 - Rehabilitation act');

2950: vXMLTable(vCtr).TagValue := to_char(cur_ctr.p5_cnt);
2951: l_P5_a3 := cur_ctr.p5_cnt;
2952: vCtr := vCtr + 1;
2953: END LOOP;
2954: fnd_file.put_line(fnd_file.log,'Finished populating Part5 - Rehabilitation act');
2955: -- Equal Pay act.
2956: FOR cur_ctr IN cur_p5(p_from_date,p_to_date,'40', p_agency_code) LOOP
2957: vXMLTable(vCtr).TagName := 'P5_a4';
2958: vXMLTable(vCtr).TagValue := to_char(cur_ctr.p5_cnt);

Line 2962: fnd_file.put_line(fnd_file.log,'Finished populating Part5 - Equal Pay act.');

2958: vXMLTable(vCtr).TagValue := to_char(cur_ctr.p5_cnt);
2959: l_P5_a4 := cur_ctr.p5_cnt;
2960: vCtr := vCtr + 1;
2961: END LOOP;
2962: fnd_file.put_line(fnd_file.log,'Finished populating Part5 - Equal Pay act.');
2963: -- Total by statutes
2964: l_P5_b := l_P5_a1 + l_P5_a2 + l_P5_a3 + l_P5_a4;
2965:
2966: vXMLTable(vCtr).TagName := 'P5_b';

Line 2969: fnd_file.put_line(fnd_file.log,'Finished populating Part5 - Total by statutes');

2965:
2966: vXMLTable(vCtr).TagName := 'P5_b';
2967: vXMLTable(vCtr).TagValue := to_char(l_P5_b);
2968: vCtr := vCtr + 1;
2969: fnd_file.put_line(fnd_file.log,'Finished populating Part5 - Total by statutes');
2970: fnd_file.put_line(fnd_file.log,'------------End of Part5----------------');
2971: END populate_part5;
2972:
2973: PROCEDURE populate_part6(

Line 2970: fnd_file.put_line(fnd_file.log,'------------End of Part5----------------');

2966: vXMLTable(vCtr).TagName := 'P5_b';
2967: vXMLTable(vCtr).TagValue := to_char(l_P5_b);
2968: vCtr := vCtr + 1;
2969: fnd_file.put_line(fnd_file.log,'Finished populating Part5 - Total by statutes');
2970: fnd_file.put_line(fnd_file.log,'------------End of Part5----------------');
2971: END populate_part5;
2972:
2973: PROCEDURE populate_part6(
2974: p_from_date in date,

Line 3076: fnd_file.put_line(fnd_file.log,'Finished populating Part6 - Total no. of closures - Withdrawals');

3072: vXMLTable(vCtr).TagName := 'P6_a1_avg';
3073: vXMLTable(vCtr).TagValue := to_char(l_P6_a1_avg);
3074: vCtr := vCtr + 1;
3075: */
3076: fnd_file.put_line(fnd_file.log,'Finished populating Part6 - Total no. of closures - Withdrawals');
3077:
3078: -- Settlements
3079: FOR cur_ctr IN cur_settlements(p_from_date,p_to_date, p_agency_code) LOOP
3080: l_P6_a2_num := cur_ctr.p6_cnt;

Line 3091: fnd_file.put_line(fnd_file.log,'Finished populating Part6 - Total no. of closures - Settlements');

3087:
3088: vXMLTable(vCtr).TagName := 'P6_a2_day';
3089: vXMLTable(vCtr).TagValue := to_char(l_P6_a2_day);
3090: vCtr := vCtr + 1;
3091: fnd_file.put_line(fnd_file.log,'Finished populating Part6 - Total no. of closures - Settlements');
3092:
3093: -- Average Days
3094: /* IF (l_P6_a2_num > 0) THEN
3095: l_P6_a2_avg := CEIL(l_P6_a2_day/l_P6_a2_num);

Line 3181: fnd_file.put_line(fnd_file.log,'Finished populating Part6 - Final Agency Actions without AJ Decisions');

3177: vCtr := vCtr + 1;
3178: vXMLTable(vCtr).TagName := 'P6_b_day';
3179: vXMLTable(vCtr).TagValue := to_char(l_P6_bday);
3180: vCtr := vCtr + 1;
3181: fnd_file.put_line(fnd_file.log,'Finished populating Part6 - Final Agency Actions without AJ Decisions');
3182: -- Final Agency action with AJ Decision ---------
3183:
3184: -- AJ Decision Fully implemented - Finding Discrimination
3185: FOR cur_ctr IN cur_total_nodays(p_from_date,p_to_date,'20', p_agency_code) LOOP

Line 3240: fnd_file.put_line(fnd_file.log,'Finished populating Part6 - AJ Decision Fully implemented');

3236: vCtr := vCtr + 1;
3237: vXMLTable(vCtr).TagName := 'P6_c1_day';
3238: vXMLTable(vCtr).TagValue := to_char(l_P6_c1_day);
3239: vCtr := vCtr + 1;
3240: fnd_file.put_line(fnd_file.log,'Finished populating Part6 - AJ Decision Fully implemented');
3241: -- Finding Discrimination
3242: -- a. AGENCY APPEALED FINDING BUT NOT REMEDY
3243: FOR cur_ctr IN cur_total_nodays(p_from_date,p_to_date,'50', p_agency_code) LOOP
3244: l_P6_c2a_1num := cur_ctr.p6_cnt;

Line 3358: fnd_file.put_line(fnd_file.log,'Finished populating Part6 - AJ Decision Not fully implemented');

3354: vXMLTable(vCtr).TagName := 'P6_c2b_avg';
3355: vXMLTable(vCtr).TagValue := to_char(l_P6_c2b_avg);
3356: vCtr := vCtr + 1;
3357: */
3358: fnd_file.put_line(fnd_file.log,'Finished populating Part6 - AJ Decision Not fully implemented');
3359: -- Finding No Discrimination
3360:
3361: -- AJ Decision Fully Implemented
3362: l_P6_c2_num := l_P6_c2a_num + l_P6_c2b_num;

Line 3427: fnd_file.put_line(fnd_file.log,'Finished populating Part6 - Final Agency Actions with AJ Decisions');

3423: vXMLTable(vCtr).TagName := 'P6_a3_avg';
3424: vXMLTable(vCtr).TagValue := to_char(l_P6_a3_avg);
3425: vCtr := vCtr + 1;
3426: */
3427: fnd_file.put_line(fnd_file.log,'Finished populating Part6 - Final Agency Actions with AJ Decisions');
3428:
3429: -- Total No. of Closures
3430: l_P6_a_num := l_P6_a1_num + l_P6_a2_num + l_P6_a3_num;
3431: l_P6_a_day := l_P6_a1_day + l_P6_a2_day + l_P6_a3_day;

Line 3450: fnd_file.put_line(fnd_file.log,'Finished populating Part6 - Total No. of Closures');

3446: vXMLTable(vCtr).TagName := 'P6_a_avg';
3447: vXMLTable(vCtr).TagValue := to_char(l_P6_a_avg);
3448: vCtr := vCtr + 1;
3449: */
3450: fnd_file.put_line(fnd_file.log,'Finished populating Part6 - Total No. of Closures');
3451: fnd_file.put_line(fnd_file.log,'------------End of Part6----------------');
3452: END populate_part6;
3453:
3454: PROCEDURE populate_part7(

Line 3451: fnd_file.put_line(fnd_file.log,'------------End of Part6----------------');

3447: vXMLTable(vCtr).TagValue := to_char(l_P6_a_avg);
3448: vCtr := vCtr + 1;
3449: */
3450: fnd_file.put_line(fnd_file.log,'Finished populating Part6 - Total No. of Closures');
3451: fnd_file.put_line(fnd_file.log,'------------End of Part6----------------');
3452: END populate_part6;
3453:
3454: PROCEDURE populate_part7(
3455: p_from_date in date,

Line 3597: fnd_file.put_line(fnd_file.log,'Finished populating Part7 - Total Complaints closed with corrective actions');

3593: END LOOP;
3594: vXMLTable(vCtr).TagName := 'P7_a_amt';
3595: vXMLTable(vCtr).TagValue := to_char(l_P7_a_amt);
3596: vCtr := vCtr + 1;
3597: fnd_file.put_line(fnd_file.log,'Finished populating Part7 - Total Complaints closed with corrective actions');
3598: -- Closures with monetary benefits
3599:
3600: -- Back pay/Front Pay
3601: FOR cur_ctr IN cur_complaints_ca_monetary(p_from_date,p_to_date,'20', p_agency_code) LOOP

Line 3639: fnd_file.put_line(fnd_file.log,'Finished populating Part7- Complaints closed with monetary benefits');

3635: vXMLTable(vCtr).TagName := 'P7_b_amt';
3636: vXMLTable(vCtr).TagValue := to_char(l_P7_b_amt);
3637: vCtr := vCtr + 1;
3638:
3639: fnd_file.put_line(fnd_file.log,'Finished populating Part7- Complaints closed with monetary benefits');
3640: -- Closures with non-monetary benefits
3641: FOR cur_ctr IN cur_complaints_ca_nm(p_from_date,p_to_date, p_agency_code) LOOP
3642: l_P7_c_num := cur_ctr.p7_cnt;
3643: END LOOP;

Line 3648: fnd_file.put_line(fnd_file.log,'Finished populating Part7 - Complaints closed with non-monetary benefits');

3644:
3645: vXMLTable(vCtr).TagName := 'P7_c_num';
3646: vXMLTable(vCtr).TagValue := to_char(l_P7_c_num);
3647: vCtr := vCtr + 1;
3648: fnd_file.put_line(fnd_file.log,'Finished populating Part7 - Complaints closed with non-monetary benefits');
3649: -- Closures with compensatory damages
3650: FOR cur_ctr IN cur_compensatory(p_from_date,p_to_date, p_agency_code) LOOP
3651: l_P7_d_num := cur_ctr.p7_cnt;
3652: l_P7_d_amt := cur_ctr.p7_amount;

Line 3661: fnd_file.put_line(fnd_file.log,'Finished populating Part7 - Complaints closed with compensatory damages');

3657: vCtr := vCtr + 1;
3658: vXMLTable(vCtr).TagName := 'P7_d_amt';
3659: vXMLTable(vCtr).TagValue := to_char(l_P7_d_amt);
3660: vCtr := vCtr + 1;
3661: fnd_file.put_line(fnd_file.log,'Finished populating Part7 - Complaints closed with compensatory damages');
3662: -- Closures with Attorney fees and costs
3663: FOR cur_ctr IN cur_complaints_ca_monetary(p_from_date,p_to_date,'10', p_agency_code) LOOP
3664: l_P7_e_num := cur_ctr.p7_cnt;
3665: l_P7_e_amt := cur_ctr.p7_amount;

Line 3674: fnd_file.put_line(fnd_file.log,'Finished populating Part7 - Complaints closed with Attorney fees and costs');

3670: vCtr := vCtr + 1;
3671: vXMLTable(vCtr).TagName := 'P7_e_amt';
3672: vXMLTable(vCtr).TagValue := to_char(l_P7_e_amt);
3673: vCtr := vCtr + 1;
3674: fnd_file.put_line(fnd_file.log,'Finished populating Part7 - Complaints closed with Attorney fees and costs');
3675: -- Types of Corrective action
3676: -- Hire Retroactive Monetary
3677: FOR cur_ctr IN cur_cmp_ca_action(p_from_date,p_to_date,'10','80', p_agency_code) LOOP
3678: l_P7_f1a_num := cur_ctr.p7_cnt;

Line 3981: fnd_file.put_line(fnd_file.log,'Finished populating Part7 - Complaints closed with corrective actions');

3977: vXMLTable(vCtr).TagName := 'P7_f13_amt';
3978: vXMLTable(vCtr).TagValue := '0';
3979: vCtr := vCtr + 1;
3980:
3981: fnd_file.put_line(fnd_file.log,'Finished populating Part7 - Complaints closed with corrective actions');
3982: fnd_file.put_line(fnd_file.log,'------------End of Part7----------------');
3983: END populate_part7;
3984:
3985: PROCEDURE populate_part8(

Line 3982: fnd_file.put_line(fnd_file.log,'------------End of Part7----------------');

3978: vXMLTable(vCtr).TagValue := '0';
3979: vCtr := vCtr + 1;
3980:
3981: fnd_file.put_line(fnd_file.log,'Finished populating Part7 - Complaints closed with corrective actions');
3982: fnd_file.put_line(fnd_file.log,'------------End of Part7----------------');
3983: END populate_part7;
3984:
3985: PROCEDURE populate_part8(
3986: p_from_date in date,

Line 4077: fnd_file.put_line(fnd_file.log,'Finished populating Part8 - Complaints pending written notification');

4073: vCtr := vCtr + 1;
4074: vXMLTable(vCtr).TagName := 'P8_a1_old';
4075: vXMLTable(vCtr).TagValue := to_char(l_p8_a1_old);
4076: vCtr := vCtr + 1;
4077: fnd_file.put_line(fnd_file.log,'Finished populating Part8 - Complaints pending written notification');
4078: -- Complaints Pending in investigation
4079: FOR cur_ctr IN cur_investigation(p_from_date, p_to_date, p_agency_code) LOOP
4080: l_p8_a2_num := cur_ctr.p8_cnt;
4081: l_p8_a2_day := cur_ctr.p8_sum;

Line 4104: fnd_file.put_line(fnd_file.log,'Finished populating Part8 - Complaints Pending in investigation');

4100: vCtr := vCtr + 1;
4101: vXMLTable(vCtr).TagName := 'P8_a2_old';
4102: vXMLTable(vCtr).TagValue := to_char(l_p8_a2_old);
4103: vCtr := vCtr + 1;
4104: fnd_file.put_line(fnd_file.log,'Finished populating Part8 - Complaints Pending in investigation');
4105: -- Complaints Pending in hearing
4106: FOR cur_ctr IN cur_hearing(p_from_date, p_to_date, p_agency_code) LOOP
4107: l_p8_a3_num := cur_ctr.p8_cnt;
4108: l_p8_a3_day := cur_ctr.p8_sum;

Line 4131: fnd_file.put_line(fnd_file.log,'Finished populating Part8 - Complaints Pending in hearing');

4127: vCtr := vCtr + 1;
4128: vXMLTable(vCtr).TagName := 'P8_a3_old';
4129: vXMLTable(vCtr).TagValue := to_char(l_p8_a3_old);
4130: vCtr := vCtr + 1;
4131: fnd_file.put_line(fnd_file.log,'Finished populating Part8 - Complaints Pending in hearing');
4132: -- Complaints Pending FAD
4133: FOR cur_ctr IN cur_agency(p_from_date, p_to_date, p_agency_code) LOOP
4134: l_p8_a4_num := cur_ctr.p8_cnt;
4135: l_p8_a4_day := cur_ctr.p8_sum;

Line 4160: fnd_file.put_line(fnd_file.log,'Finished populating Part8 - Complaints Pending FAD');

4156: vXMLTable(vCtr).TagValue := to_char(l_p8_a4_old);
4157: vCtr := vCtr + 1;
4158:
4159:
4160: fnd_file.put_line(fnd_file.log,'Finished populating Part8 - Complaints Pending FAD');
4161: l_p8_a_num := l_p8_a1_num + l_p8_a2_num + l_p8_a3_num + l_p8_a4_num;
4162: l_p8_a_day := l_p8_a1_day + l_p8_a2_day + l_p8_a3_day + l_p8_a4_day;
4163:
4164: vXMLTable(vCtr).TagName := 'P8_a_num';

Line 4170: fnd_file.put_line(fnd_file.log,'Finished populating Part8 - Totals');

4166: vCtr := vCtr + 1;
4167: vXMLTable(vCtr).TagName := 'P8_a_day';
4168: vXMLTable(vCtr).TagValue := to_char(l_p8_a_day);
4169: vCtr := vCtr + 1;
4170: fnd_file.put_line(fnd_file.log,'Finished populating Part8 - Totals');
4171: fnd_file.put_line(fnd_file.log,'------------End of Part8----------------');
4172: END populate_part8;
4173:
4174: PROCEDURE populate_part10(

Line 4171: fnd_file.put_line(fnd_file.log,'------------End of Part8----------------');

4167: vXMLTable(vCtr).TagName := 'P8_a_day';
4168: vXMLTable(vCtr).TagValue := to_char(l_p8_a_day);
4169: vCtr := vCtr + 1;
4170: fnd_file.put_line(fnd_file.log,'Finished populating Part8 - Totals');
4171: fnd_file.put_line(fnd_file.log,'------------End of Part8----------------');
4172: END populate_part8;
4173:
4174: PROCEDURE populate_part10(
4175: p_from_date in date,

Line 4563: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - ADR Pending from previous reporting period');

4559: IF (l_p10_a_day IS NULL) THEN
4560: l_p10_a_day := 0;
4561: END IF;
4562:
4563: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - ADR Pending from previous reporting period');
4564: -- Individuals Counseled through ADR
4565: FOR cur_ctr IN cur_adr(p_from_date, p_to_date,'10', p_agency_code) LOOP
4566: l_p10_b_cmp := cur_ctr.p10_cnt;
4567: l_p10_b_ant := cur_ctr.p10_prsn;

Line 4577: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Individuals Counseled through ADR');

4573:
4574: vXMLTable(vCtr).TagName := 'P10_b_ant';
4575: vXMLTable(vCtr).TagValue := to_char(l_p10_b_ant);
4576: vCtr := vCtr + 1;
4577: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Individuals Counseled through ADR');
4578:
4579: -- ADR Actions for current reporting period
4580: -- ADR Offered
4581: FOR cur_ctr IN cur_adr_offered(p_from_date, p_to_date,'10', p_agency_code) LOOP

Line 4600: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - ADR Offered');

4596: IF (l_p10_c1_day IS NULL) THEN
4597: l_p10_c1_day := 0;
4598: END IF;
4599:
4600: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - ADR Offered');
4601:
4602: -- Rejected by Complainant
4603: FOR cur_ctr IN cur_adr_actions(p_from_date, p_to_date,'10','20', p_agency_code) LOOP
4604: l_p10_c2_cmp := cur_ctr.p10_cnt;

Line 4622: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Rejected by Complainant');

4618: IF (l_p10_c2_day IS NULL) THEN
4619: l_p10_c2_day := 0;
4620: END IF;
4621:
4622: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Rejected by Complainant');
4623:
4624: -- Rejected by Agency
4625: FOR cur_ctr IN cur_adr_actions(p_from_date, p_to_date,'10','30', p_agency_code) LOOP
4626: l_p10_c3_cmp := cur_ctr.p10_cnt;

Line 4644: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Rejected by Agency');

4640: IF (l_p10_c3_day IS NULL) THEN
4641: l_p10_c3_day := 0;
4642: END IF;
4643:
4644: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Rejected by Agency');
4645:
4646: -- Total ADR
4647: l_p10_c4_cmp := l_p10_c1_cmp - (l_p10_c2_cmp + l_p10_c3_cmp);
4648: l_p10_c4_ant := l_p10_c1_ant - (l_p10_c2_ant + l_p10_c3_ant);

Line 4658: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Total ADR');

4654:
4655: vXMLTable(vCtr).TagName := 'P10_c4_ant';
4656: vXMLTable(vCtr).TagValue := to_char(l_p10_c4_ant);
4657: vCtr := vCtr + 1;
4658: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Total ADR');
4659: -- Resources Used
4660:
4661: -- Inhouse
4662: FOR cur_ctr IN cur_resources(p_from_date, p_to_date,'10','20', p_agency_code) LOOP

Line 4814: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Resources');

4810:
4811: vXMLTable(vCtr).TagName := 'P10_d_ant';
4812: vXMLTable(vCtr).TagValue := to_char(l_p10_d_ant);
4813: vCtr := vCtr + 1;
4814: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Resources');
4815: -- Techniques used
4816: -- Mediation
4817: FOR cur_ctr IN cur_techniques(p_from_date, p_to_date,'10','40', p_agency_code) LOOP
4818: l_p10_e1_cmp := cur_ctr.p10_cnt;

Line 5265: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Techniques');

5261: vXMLTable(vCtr).TagName := 'P10_e_avg';
5262: vXMLTable(vCtr).TagValue := to_char(l_P10_e_avg);
5263: vCtr := vCtr + 1;
5264: */
5265: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Techniques');
5266: -- Status of Cases
5267: -- Settlement with benefits
5268: FOR cur_ctr IN cur_case_status_settle(p_from_date, p_to_date,'10', p_agency_code) LOOP
5269: l_p10_f1a_cmp := cur_ctr.p10_cnt;

Line 5473: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Closed Complaints');

5469: vXMLTable(vCtr).TagName := 'P10_f1_avg';
5470: vXMLTable(vCtr).TagValue := to_char(l_P10_f1_avg);
5471: vCtr := vCtr + 1;
5472: */
5473: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Closed Complaints');
5474:
5475: -- Open inventory
5476: -- Formula changed to A + C4 - F1
5477: /* FOR cur_ctr IN cur_open_inventory(p_from_date, p_to_date,'10', p_agency_code) LOOP

Line 5513: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Open inventory');

5509: vXMLTable(vCtr).TagName := 'P10_f2_avg';
5510: vXMLTable(vCtr).TagValue := to_char(l_P10_f2_avg);
5511: vCtr := vCtr + 1;
5512: */
5513: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Open inventory');
5514: -- Benefits Received
5515: -- Compensatory Damages
5516: FOR cur_ctr IN cur_benefits_pt2(p_from_date, p_to_date,'10','40','30','40', p_agency_code) LOOP
5517: l_p10_g1a_cmp := cur_ctr.p10_cnt;

Line 5658: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Benefits received Monetary');

5654:
5655: vXMLTable(vCtr).TagName := 'P10_g1_amt';
5656: vXMLTable(vCtr).TagValue := to_char(l_p10_g1_amt);
5657: vCtr := vCtr + 1;
5658: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Benefits received Monetary');
5659: -- Non-Monetary
5660: -- New Hires
5661: FOR cur_ctr IN cur_benefits_nm_pt2(p_from_date, p_to_date,'10','40','70','80', p_agency_code) LOOP
5662: l_p10_g2a_cmp := cur_ctr.p10_cnt;

Line 5837: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Benefits received Non-monetary');

5833:
5834: vXMLTable(vCtr).TagName := 'P10_g2_ant';
5835: vXMLTable(vCtr).TagValue := to_char(l_p10_g2_ant);
5836: vCtr := vCtr + 1;
5837: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Benefits received Non-monetary');
5838: fnd_file.put_line(fnd_file.log,'------------End of Part10----------------');
5839: END populate_part10;
5840:
5841: PROCEDURE populate_part11(

Line 5838: fnd_file.put_line(fnd_file.log,'------------End of Part10----------------');

5834: vXMLTable(vCtr).TagName := 'P10_g2_ant';
5835: vXMLTable(vCtr).TagValue := to_char(l_p10_g2_ant);
5836: vCtr := vCtr + 1;
5837: fnd_file.put_line(fnd_file.log,'Finished populating Part10 - Benefits received Non-monetary');
5838: fnd_file.put_line(fnd_file.log,'------------End of Part10----------------');
5839: END populate_part10;
5840:
5841: PROCEDURE populate_part11(
5842: p_from_date in date,

Line 6210: fnd_file.put_line(fnd_file.log,'Starting populating Part11 - Total accepted into ADR');

6206: l_p11_b4_day NUMBER;
6207:
6208: BEGIN
6209: --
6210: fnd_file.put_line(fnd_file.log,'Starting populating Part11 - Total accepted into ADR');
6211: -- ADR Pending from previous reporting period
6212: FOR cur_ctr IN cur_adr_pending(p_from_date, p_to_date,20, p_agency_code) LOOP
6213: l_p11_a_cmp := cur_ctr.p11_cnt;
6214: l_p11_a_ant := cur_ctr.p11_prsn;

Line 6217: fnd_file.put_line(fnd_file.log,'Starting populating Part11 - End of cursor');

6213: l_p11_a_cmp := cur_ctr.p11_cnt;
6214: l_p11_a_ant := cur_ctr.p11_prsn;
6215: l_p11_a_day := cur_ctr.p11_days;
6216: END LOOP;
6217: fnd_file.put_line(fnd_file.log,'Starting populating Part11 - End of cursor');
6218:
6219: vXMLTable(vCtr).TagName := 'P11_a_cmp';
6220: vXMLTable(vCtr).TagValue := to_char(l_p11_a_cmp);
6221: vCtr := vCtr + 1;

Line 6232: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - ADR Pending from previous reporting period');

6228: IF (l_p11_a_day IS NULL) THEN
6229: l_p11_a_day := 0;
6230: END IF;
6231:
6232: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - ADR Pending from previous reporting period');
6233:
6234: -- ADR Actions for current reporting period
6235: -- ADR Offered
6236: -- Cursor changed to included the rejected ones also. Bug#3126112

Line 6255: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - ADR Offered');

6251: -- Bug#3124648
6252: IF (l_p11_b1_day IS NULL) THEN
6253: l_p11_b1_day := 0;
6254: END IF;
6255: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - ADR Offered');
6256:
6257:
6258: -- Bug#3122514 Phase shd be formal complaint 20 or above.
6259: -- Rejected by Complainant

Line 6278: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Rejected by Complainant');

6274: -- Bug#3124648
6275: IF (l_p11_b2_day IS NULL) THEN
6276: l_p11_b2_day := 0;
6277: END IF;
6278: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Rejected by Complainant');
6279:
6280: -- Bug#3122514 Phase shd be formal complaint 20 or above.
6281: -- Rejected by Agency
6282: FOR cur_ctr IN cur_adr_actions(p_from_date, p_to_date,20,'30', p_agency_code) LOOP

Line 6300: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Rejected by Agency');

6296: -- Bug#3124648
6297: IF (l_p11_b3_day IS NULL) THEN
6298: l_p11_b3_day := 0;
6299: END IF;
6300: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Rejected by Agency');
6301: -- Total ADR
6302: l_p11_b4_cmp := l_p11_b1_cmp - (l_p11_b2_cmp + l_p11_b3_cmp);
6303: l_p11_b4_ant := l_p11_b1_ant - (l_p11_b2_ant + l_p11_b3_ant);
6304: l_p11_b4_day := l_p11_b1_day - (l_p11_b2_day + l_p11_b3_day);

Line 6314: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Total accepted into ADR');

6310: vXMLTable(vCtr).TagName := 'P11_b4_ant';
6311: vXMLTable(vCtr).TagValue := to_char(l_p11_b4_ant);
6312: vCtr := vCtr + 1;
6313:
6314: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Total accepted into ADR');
6315:
6316: --------------------------------------------
6317: -- Resources Used
6318: -- Inhouse

Line 6474: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Resources');

6470:
6471: vXMLTable(vCtr).TagName := 'P11_c_ant';
6472: vXMLTable(vCtr).TagValue := to_char(l_p11_c_ant);
6473: vCtr := vCtr + 1;
6474: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Resources');
6475: -- Techniques used
6476: -- Mediation
6477: FOR cur_ctr IN cur_techniques(p_from_date, p_to_date,20,'40', p_agency_code) LOOP
6478: l_p11_d1_cmp := cur_ctr.p11_cnt;

Line 6927: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Techniques');

6923: /* vXMLTable(vCtr).TagName := 'P11_d_avg';
6924: vXMLTable(vCtr).TagValue := to_char(l_p11_d_avg);
6925: vCtr := vCtr + 1;
6926: */
6927: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Techniques');
6928: -- Status of Cases
6929: -- Settlement with benefits
6930: FOR cur_ctr IN cur_case_status_settle(p_from_date, p_to_date,20, p_agency_code) LOOP
6931: l_p11_e1a_cmp := cur_ctr.p11_cnt;

Line 7120: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Closed Status');

7116: /* vXMLTable(vCtr).TagName := 'P11_e1_avg';
7117: vXMLTable(vCtr).TagValue := to_char(l_p11_e1_avg);
7118: vCtr := vCtr + 1;
7119: */
7120: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Closed Status');
7121: -- Open inventory
7122: -- Result of (A + B4 - E1)
7123:
7124: /*(FOR cur_ctr IN cur_open_inventory(p_from_date, p_to_date,'20', p_agency_code) LOOP

Line 7160: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Open Inventory');

7156: vXMLTable(vCtr).TagValue := to_char(l_P11_e2_avg);
7157: vCtr := vCtr + 1;
7158: */
7159:
7160: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Open Inventory');
7161: -- Benefits Received
7162: -- Compensatory Damages
7163: FOR cur_ctr IN cur_benefits_pt2(p_from_date, p_to_date,20,'30','30','40', p_agency_code) LOOP
7164: l_p11_f1a_cmp := cur_ctr.p11_cnt;

Line 7304: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Benefits Received Monetary');

7300:
7301: vXMLTable(vCtr).TagName := 'P11_f1_amt';
7302: vXMLTable(vCtr).TagValue := to_char(l_p11_f1_amt);
7303: vCtr := vCtr + 1;
7304: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Benefits Received Monetary');
7305: -- Non-Monetary
7306: -- New Hires
7307: FOR cur_ctr IN cur_benefits_nm_pt2(p_from_date, p_to_date,20,'30','70','80', p_agency_code) LOOP
7308: l_p11_f2a_cmp := cur_ctr.p11_cnt;

Line 7487: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Benefits received Non Monetary');

7483:
7484: vXMLTable(vCtr).TagName := 'P11_f2_ant';
7485: vXMLTable(vCtr).TagValue := to_char(l_p11_f2_ant);
7486: vCtr := vCtr + 1;
7487: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Benefits received Non Monetary');
7488: fnd_file.put_line(fnd_file.log,'------------End of Part11 ----------------');
7489: END populate_part11;
7490:
7491: PROCEDURE WritetoXML (

Line 7488: fnd_file.put_line(fnd_file.log,'------------End of Part11 ----------------');

7484: vXMLTable(vCtr).TagName := 'P11_f2_ant';
7485: vXMLTable(vCtr).TagValue := to_char(l_p11_f2_ant);
7486: vCtr := vCtr + 1;
7487: fnd_file.put_line(fnd_file.log,'Finished populating Part11 - Benefits received Non Monetary');
7488: fnd_file.put_line(fnd_file.log,'------------End of Part11 ----------------');
7489: END populate_part11;
7490:
7491: PROCEDURE WritetoXML (
7492: p_request_id in number,