APPS.PMI_BUILD_ONHANDSALE_SUM dependencies on FND_FILE

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

507: SELECT 1 into rows_exists
508: FROM PMI_ONHAND_SALE_SUM
509: WHERE ROWNUM = 1;
510: errbuf := FND_MESSAGE.get_string('PMI','PMI_SUMM_POPULATION_ERR');
511: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf );
512: retcode:= '2';
513: APP_EXCEPTION.Raise_exception;
514: EXCEPTION WHEN NO_DATA_FOUND THEN
515: NULL;

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

522: IF fnd_profile.defined('PMI$CONV_UOM') THEN
523: l_conv_uom1 := fnd_profile.value('PMI$CONV_UOM');
524: IF l_conv_uom1 IS NULL THEN
525: errbuf := FND_MESSAGE.get_string('PMI','PMI_SET_CONV_UOM');
526: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf );
527: retcode:= '2';
528: APP_EXCEPTION.Raise_exception;
529: END IF;
530: PV_conv_uom := l_conv_uom1;

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

532: (l_conv_uom1 <> l_conv_uom)) THEN
533: /* Delete data from summary table. now we need to populate using new conversion UOM */
534: buff32k := FND_MESSAGE.get_number('PMI','PMI_CONV_UOM_VAL_CHG') ||'-'||
535: FND_MESSAGE.get_string('PMI','PMI_CONV_UOM_VAL_CHG');
536: FND_FILE.PUT_LINE(FND_FILE.LOG, buff32k );
537: DELETE pmi_onhand_sale_sum;
538: COMMIT;
539: l_last_run_date := NULL;
540: END IF;

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

559: FND_STATS.GATHER_TABLE_STATS(l_table_owner, 'PMI_ONHAND_SALE_SUM');
560: ELSE
561: buff32k := FND_MESSAGE.get_number('PMI','PMI_CONV_UOM_PROF_MISS') ||'-'||
562: FND_MESSAGE.get_string('PMI','PMI_CONV_UOM_PROF_MISS');
563: FND_FILE.PUT_LINE(FND_FILE.LOG, buff32k );
564: retcode:= '2';
565: APP_EXCEPTION.Raise_exception;
566: END IF;
567: EXCEPTION

Line 568: WHEN FND_FILE.UTL_FILE_ERROR then

564: retcode:= '2';
565: APP_EXCEPTION.Raise_exception;
566: END IF;
567: EXCEPTION
568: WHEN FND_FILE.UTL_FILE_ERROR then
569: errbuf := substr(fnd_message.get, 1, 254);
570: retcode := 2;
571: END BUILD_SUMMARY;
572: END PMI_BUILD_ONHANDSALE_SUM;