APPS.PER_US_IPEDS_EXP_PKG dependencies on FND_FILE

Line 52: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_reporting_date =' || p_report_date);

48: l_pr VARCHAR2(2000);
49: l_pt VARCHAR2(2000);
50: begin
51:
52: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_reporting_date =' || p_report_date);
53: l_report_date := fnd_date.canonical_to_date(p_report_date); --to_date(p_report_date,'YYYY/MM/DD HH24:MI:SS');
54: pqh_employment_category.fetch_empl_categories(p_business_group_id
55: ,l_fr
56: ,l_ft

Line 60: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_reporting_year =' || l_reporting_year);

56: ,l_ft
57: ,l_pr
58: ,l_pt);
59:
60: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_reporting_year =' || l_reporting_year);
61: l_query := 'SELECT peo.full_name name,
62: peo.employee_number employee_number,
63: decode(peo.per_information1,
64: 13, ''Ethnic Origin is "Two or More Races" and "Additional Ethnic Code" is missing'',

Line 105: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query);

101: AND ppei.person_id=peo.person_id)
102: )
103: )';
104:
105: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query);
106:
107: qryCtx := dbms_xmlgen.newContext (l_query);
108:
109: l_xml_string := '';

Line 110: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

106:
107: qryCtx := dbms_xmlgen.newContext (l_query);
108:
109: l_xml_string := '';
110: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
112:
113: l_xml_string := '';
114: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

Line 111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

107: qryCtx := dbms_xmlgen.newContext (l_query);
108:
109: l_xml_string := '';
110: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
112:
113: l_xml_string := '';
114: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
115: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

Line 114: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

110: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
112:
113: l_xml_string := '';
114: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
115: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
116:
117: --Load 5 records at a time
118: DBMS_XMLGEN.setMaxRows(qryCtx, 5);

Line 115: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
112:
113: l_xml_string := '';
114: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
115: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
116:
117: --Load 5 records at a time
118: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
119: LOOP

Line 124: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

120: --save the XML into the CLOB field
121: l_result := DBMS_XMLGEN.getXML(qryCtx);
122: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
123: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
124: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
126:
127: END LOOP;
128:

Line 125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

121: l_result := DBMS_XMLGEN.getXML(qryCtx);
122: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
123: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
124: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
126:
127: END LOOP;
128:
129: -- Get Name of the business group.

Line 139: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

135: l_xml_string := ' '|| l_business_group_name ||'
136: ' || to_char(l_report_date, 'dd-Mon-yyyy') ||'
137: ' || to_char(l_report_date, 'yyyy') ||'
138: ';
139: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
140: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
141:
142: end generate_exception_report;
143:

Line 140: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

136: ' || to_char(l_report_date, 'dd-Mon-yyyy') ||'
137: ' || to_char(l_report_date, 'yyyy') ||'
138: ';
139: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
140: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
141:
142: end generate_exception_report;
143:
144: END PER_US_IPEDS_EXP_PKG;