APPS.PMI_BUILD_PROD_SUM dependencies on FND_FILE

Line 185: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf );

181: SELECT 1 into rows_exists
182: FROM PMI_PROD_SUM
183: WHERE ROWNUM = 1;
184: errbuf := FND_MESSAGE.get_string('PMI','PMI_SUMM_POPULATION_ERR');
185: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf );
186: retcode:= '2';
187: APP_EXCEPTION.Raise_exception;
188: EXCEPTION WHEN NO_DATA_FOUND THEN
189: NULL;

Line 199: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf );

195: IF fnd_profile.defined('PMI$CONV_UOM') THEN
196: l_conv_uom1 := fnd_profile.value('PMI$CONV_UOM');
197: IF l_conv_uom1 IS NULL THEN
198: errbuf := FND_MESSAGE.get_string('PMI','PMI_SET_CONV_UOM');
199: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf );
200: retcode:= '2';
201: APP_EXCEPTION.Raise_exception;
202: END IF;
203: PV_conv_uom := l_conv_uom1;

Line 209: FND_FILE.PUT_LINE(FND_FILE.LOG, buff32k );

205: (l_conv_uom1 <> l_conv_uom)) THEN
206: /* Delete data from summary table. now we need to populate using new conversion UOM */
207: buff32k := FND_MESSAGE.get_number('PMI','PMI_CONV_UOM_VAL_CHG') ||'-'||
208: FND_MESSAGE.get_string('PMI','PMI_CONV_UOM_VAL_CHG');
209: FND_FILE.PUT_LINE(FND_FILE.LOG, buff32k );
210: DELETE pmi_prod_sum;
211: COMMIT;
212: l_last_run_date := NULL;
213: END IF;

Line 239: FND_FILE.PUT_LINE(FND_FILE.LOG, buff32k );

235:
236: ELSE
237: buff32k := FND_MESSAGE.get_number('PMI','PMI_CONV_UOM_PROF_MISS') ||'-'||
238: FND_MESSAGE.get_string('PMI','PMI_CONV_UOM_PROF_MISS');
239: FND_FILE.PUT_LINE(FND_FILE.LOG, buff32k );
240: retcode:= '2';
241: APP_EXCEPTION.Raise_exception;
242: END IF;
243: EXCEPTION

Line 244: WHEN FND_FILE.UTL_FILE_ERROR then

240: retcode:= '2';
241: APP_EXCEPTION.Raise_exception;
242: END IF;
243: EXCEPTION
244: WHEN FND_FILE.UTL_FILE_ERROR then
245: errbuf := substr(fnd_message.get, 1, 254);
246: retcode := 2;
247: END BUILD_SUMMARY;
248: END PMI_BUILD_PROD_SUM;