DBA Data[Home] [Help]

APPS.PMI_BUILD_PROD_SUM dependencies on FND_MESSAGE

Line 184: errbuf := FND_MESSAGE.get_string('PMI','PMI_SUMM_POPULATION_ERR');

180: BEGIN
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

Line 198: errbuf := FND_MESSAGE.get_string('PMI','PMI_SET_CONV_UOM');

194: /* Check for Conversion UOM is defined or not */
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;

Line 207: buff32k := FND_MESSAGE.get_number('PMI','PMI_CONV_UOM_VAL_CHG') ||'-'||

203: PV_conv_uom := l_conv_uom1;
204: IF ((l_last_run_date IS NOT NULL) AND
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;

Line 208: FND_MESSAGE.get_string('PMI','PMI_CONV_UOM_VAL_CHG');

204: IF ((l_last_run_date IS NOT NULL) AND
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;

Line 237: buff32k := FND_MESSAGE.get_number('PMI','PMI_CONV_UOM_PROF_MISS') ||'-'||

233: FND_STATS.GATHER_TABLE_STATS(l_table_owner, 'PMI_PROD_SUM');
234:
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;

Line 238: FND_MESSAGE.get_string('PMI','PMI_CONV_UOM_PROF_MISS');

234:
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;

Line 245: errbuf := substr(fnd_message.get, 1, 254);

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;