DBA Data[Home] [Help]

APPS.PQP_CANDM_UPG dependencies on FND_FILE

Line 276: fnd_file.new_line (fnd_file.output,1);

272: WHERE status_processing_rule_id=l_formula.status_processing_rule_id
273: AND sysdate BETWEEN effective_start_date and effective_end_date;
274:
275:
276: fnd_file.new_line (fnd_file.output,1);
277: fnd_file.put(fnd_file.output,'The Fast Formula '|| l_formula.formula_name||
278: ' is successfully upgraded and the backup of old formula is in ' || l_formula_name||l_dt||'BAK'||' .');
279: END IF;
280:

Line 277: fnd_file.put(fnd_file.output,'The Fast Formula '|| l_formula.formula_name||

273: AND sysdate BETWEEN effective_start_date and effective_end_date;
274:
275:
276: fnd_file.new_line (fnd_file.output,1);
277: fnd_file.put(fnd_file.output,'The Fast Formula '|| l_formula.formula_name||
278: ' is successfully upgraded and the backup of old formula is in ' || l_formula_name||l_dt||'BAK'||' .');
279: END IF;
280:
281:

Line 286: fnd_file.put(fnd_file.output,l_formula_name||' Formula Upgrade Failed');

282: EXCEPTION
283: ---------
284:
285: WHEN OTHERS THEN
286: fnd_file.put(fnd_file.output,l_formula_name||' Formula Upgrade Failed');
287: END;
288: END LOOP;
289: CLOSE C_FORMULA;
290: EXCEPTION

Line 294: fnd_file.put(fnd_file.output,'Formula Upgrade Failed');

290: EXCEPTION
291: ---------
292:
293: WHEN OTHERS THEN
294: fnd_file.put(fnd_file.output,'Formula Upgrade Failed');
295: END UPGRADE_FORMULA;
296:
297:
298: end PQP_CANDM_UPG;