eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_CANDM_UPG dependencies on FND_FILE

Line 138: fnd_file.put_line(fnd_file.log,'p_formula_cat:'||p_formula_cat);

134:
135:
136: BEGIN
137:
138: fnd_file.put_line(fnd_file.log,'p_formula_cat:'||p_formula_cat);
139: fnd_file.put_line(fnd_file.log,'p_formula_name:'||p_formula_name);
140:
141:
142: OPEN c_sh_formula_details;

Line 139: fnd_file.put_line(fnd_file.log,'p_formula_name:'||p_formula_name);

135:
136: BEGIN
137:
138: fnd_file.put_line(fnd_file.log,'p_formula_cat:'||p_formula_cat);
139: fnd_file.put_line(fnd_file.log,'p_formula_name:'||p_formula_name);
140:
141:
142: OPEN c_sh_formula_details;
143: LOOP

Line 151: fnd_file.put_line(fnd_file.log,'Shadow Formula Ver:'||l_sh_formula_ver);

147: l_sh_formula_ver:=get_version(l_sh_formula_text);
148: END LOOP;
149: CLOSE c_sh_formula_details;
150:
151: fnd_file.put_line(fnd_file.log,'Shadow Formula Ver:'||l_sh_formula_ver);
152:
153: OPEN c_formula_details;
154: LOOP
155: FETCH c_formula_details INTO l_formula;

Line 161: fnd_file.put_line(fnd_file.log,'Formula Prefix:'||l_formula_prefix);

157: l_formula_prefix := substr(l_formula.formula_name,0,INSTR(l_formula.formula_name,substr(p_formula_cat,2))-1);
158: --l_formula_ver := substr(l_formula.formula_text,INSTR(l_formula.formula_text,'pqgbtcam.sql')+13,6);
159: l_formula_ver := get_version(l_formula.formula_text);
160:
161: fnd_file.put_line(fnd_file.log,'Formula Prefix:'||l_formula_prefix);
162: fnd_file.put_line(fnd_file.log,'Formula Ver:'||l_formula_ver);
163:
164: IF version_compare(l_formula_ver,l_sh_formula_ver) THEN
165: fnd_file.put_line(fnd_file.log,'Upgrading Formula:'||l_formula.formula_name);

Line 162: fnd_file.put_line(fnd_file.log,'Formula Ver:'||l_formula_ver);

158: --l_formula_ver := substr(l_formula.formula_text,INSTR(l_formula.formula_text,'pqgbtcam.sql')+13,6);
159: l_formula_ver := get_version(l_formula.formula_text);
160:
161: fnd_file.put_line(fnd_file.log,'Formula Prefix:'||l_formula_prefix);
162: fnd_file.put_line(fnd_file.log,'Formula Ver:'||l_formula_ver);
163:
164: IF version_compare(l_formula_ver,l_sh_formula_ver) THEN
165: fnd_file.put_line(fnd_file.log,'Upgrading Formula:'||l_formula.formula_name);
166: l_formula_text_buffer := replace(l_sh_formula_text,'',UPPER(REPLACE(l_formula_prefix,' ','_')));

Line 165: fnd_file.put_line(fnd_file.log,'Upgrading Formula:'||l_formula.formula_name);

161: fnd_file.put_line(fnd_file.log,'Formula Prefix:'||l_formula_prefix);
162: fnd_file.put_line(fnd_file.log,'Formula Ver:'||l_formula_ver);
163:
164: IF version_compare(l_formula_ver,l_sh_formula_ver) THEN
165: fnd_file.put_line(fnd_file.log,'Upgrading Formula:'||l_formula.formula_name);
166: l_formula_text_buffer := replace(l_sh_formula_text,'',UPPER(REPLACE(l_formula_prefix,' ','_')));
167:
168: SELECT TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
169: INTO l_year

Line 221: fnd_file.put_line(fnd_file.output,'The Fast Formula '||l_formula.formula_name||' is successfully upgraded');

217: SET formula_id=ff_formulas_s.currval
218: WHERE status_processing_rule_id=l_formula.status_processing_rule_id
219: AND SYSDATE BETWEEN effective_start_date and effective_end_date;
220:
221: fnd_file.put_line(fnd_file.output,'The Fast Formula '||l_formula.formula_name||' is successfully upgraded');
222: fnd_file.put_line(fnd_file.output,'and the backup of old formula is in ' || l_formula.formula_name||'_'||l_year||'_BAK');
223: retcode:=0;
224:
225: ELSE

Line 222: fnd_file.put_line(fnd_file.output,'and the backup of old formula is in ' || l_formula.formula_name||'_'||l_year||'_BAK');

218: WHERE status_processing_rule_id=l_formula.status_processing_rule_id
219: AND SYSDATE BETWEEN effective_start_date and effective_end_date;
220:
221: fnd_file.put_line(fnd_file.output,'The Fast Formula '||l_formula.formula_name||' is successfully upgraded');
222: fnd_file.put_line(fnd_file.output,'and the backup of old formula is in ' || l_formula.formula_name||'_'||l_year||'_BAK');
223: retcode:=0;
224:
225: ELSE
226: fnd_file.put_line(fnd_file.output,'Latest version of the formula '||l_formula.formula_name||' already exists.');

Line 226: fnd_file.put_line(fnd_file.output,'Latest version of the formula '||l_formula.formula_name||' already exists.');

222: fnd_file.put_line(fnd_file.output,'and the backup of old formula is in ' || l_formula.formula_name||'_'||l_year||'_BAK');
223: retcode:=0;
224:
225: ELSE
226: fnd_file.put_line(fnd_file.output,'Latest version of the formula '||l_formula.formula_name||' already exists.');
227: retcode:=1;
228:
229: END IF;
230: END LOOP;

Line 235: fnd_file.put_line(fnd_file.output,'Formula Upgrade Failed');

231: CLOSE c_formula_details;
232:
233: EXCEPTION
234: WHEN OTHERS THEN
235: fnd_file.put_line(fnd_file.output,'Formula Upgrade Failed');
236: fnd_file.put_line(fnd_file.log,substr(SQLERRM,1,200));
237: errbuf:='Formula Upgrade Failed';
238: retcode:=2;
239: END UPGRADE_FORMULA;

Line 236: fnd_file.put_line(fnd_file.log,substr(SQLERRM,1,200));

232:
233: EXCEPTION
234: WHEN OTHERS THEN
235: fnd_file.put_line(fnd_file.output,'Formula Upgrade Failed');
236: fnd_file.put_line(fnd_file.log,substr(SQLERRM,1,200));
237: errbuf:='Formula Upgrade Failed';
238: retcode:=2;
239: END UPGRADE_FORMULA;
240: