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.OKC_XPRT_UTIL_PVT dependencies on FND_FILE

Line 189: fnd_file.put_line(FND_FILE.LOG,' ');

185: l_model := 'Rules';
186: END IF;
187:
188: -- Check the cz_db_logs table for any messages and write to log file
189: fnd_file.put_line(FND_FILE.LOG,' ');
190: fnd_file.put_line(FND_FILE.LOG,'Import Summary for '||l_model||' Run Id : '||p_run_id);
191: fnd_file.put_line(FND_FILE.LOG,' ');
192:
193:

Line 190: fnd_file.put_line(FND_FILE.LOG,'Import Summary for '||l_model||' Run Id : '||p_run_id);

186: END IF;
187:
188: -- Check the cz_db_logs table for any messages and write to log file
189: fnd_file.put_line(FND_FILE.LOG,' ');
190: fnd_file.put_line(FND_FILE.LOG,'Import Summary for '||l_model||' Run Id : '||p_run_id);
191: fnd_file.put_line(FND_FILE.LOG,' ');
192:
193:
194: -- write to debug log file

Line 191: fnd_file.put_line(FND_FILE.LOG,' ');

187:
188: -- Check the cz_db_logs table for any messages and write to log file
189: fnd_file.put_line(FND_FILE.LOG,' ');
190: fnd_file.put_line(FND_FILE.LOG,'Import Summary for '||l_model||' Run Id : '||p_run_id);
191: fnd_file.put_line(FND_FILE.LOG,' ');
192:
193:
194: -- write to debug log file
195: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 208: fnd_file.put_line(FND_FILE.LOG,'---------- CZ_DB_LOGS ----------------------------- ');

204: '110: Run Id : '||p_run_id);
205: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
206: G_MODULE||l_api_name,
207: '110:---------- CZ_DB_LOGS ----------------------------- ');
208: fnd_file.put_line(FND_FILE.LOG,'---------- CZ_DB_LOGS ----------------------------- ');
209:
210: FOR csr_db_logs_rec IN csr_db_logs
211: LOOP
212: l_rec_number := l_rec_number +1;

Line 213: fnd_file.put_line(FND_FILE.LOG,' ');

209:
210: FOR csr_db_logs_rec IN csr_db_logs
211: LOOP
212: l_rec_number := l_rec_number +1;
213: fnd_file.put_line(FND_FILE.LOG,' ');
214: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
215: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
216: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
217: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);

Line 214: fnd_file.put_line(FND_FILE.LOG,'* Record : '||l_rec_number||' ');

210: FOR csr_db_logs_rec IN csr_db_logs
211: LOOP
212: l_rec_number := l_rec_number +1;
213: fnd_file.put_line(FND_FILE.LOG,' ');
214: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
215: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
216: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
217: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
218: fnd_file.put_line(FND_FILE.LOG,' ');

Line 215: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);

211: LOOP
212: l_rec_number := l_rec_number +1;
213: fnd_file.put_line(FND_FILE.LOG,' ');
214: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
215: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
216: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
217: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
218: fnd_file.put_line(FND_FILE.LOG,' ');
219: fnd_file.put_line(FND_FILE.LOG,' ');

Line 216: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);

212: l_rec_number := l_rec_number +1;
213: fnd_file.put_line(FND_FILE.LOG,' ');
214: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
215: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
216: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
217: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
218: fnd_file.put_line(FND_FILE.LOG,' ');
219: fnd_file.put_line(FND_FILE.LOG,' ');
220:

Line 217: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);

213: fnd_file.put_line(FND_FILE.LOG,' ');
214: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
215: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
216: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
217: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
218: fnd_file.put_line(FND_FILE.LOG,' ');
219: fnd_file.put_line(FND_FILE.LOG,' ');
220:
221: -- write to debug log file

Line 218: fnd_file.put_line(FND_FILE.LOG,' ');

214: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
215: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
216: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
217: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
218: fnd_file.put_line(FND_FILE.LOG,' ');
219: fnd_file.put_line(FND_FILE.LOG,' ');
220:
221: -- write to debug log file
222: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 219: fnd_file.put_line(FND_FILE.LOG,' ');

215: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
216: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
217: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
218: fnd_file.put_line(FND_FILE.LOG,' ');
219: fnd_file.put_line(FND_FILE.LOG,' ');
220:
221: -- write to debug log file
222: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 243: fnd_file.put_line(FND_FILE.LOG,'CZ IMPORT API Return Status : '||p_import_status);

239:
240: -- If CZ import returns ERROR then there was a database or fatal error
241: -- write to log and Abort the next steps of writing to log
242: IF (p_import_status = G_RET_STS_UNEXP_ERROR) THEN
243: fnd_file.put_line(FND_FILE.LOG,'CZ IMPORT API Return Status : '||p_import_status);
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
246: fnd_file.put_line(FND_FILE.LOG,'CZ IMPORT API Return Status : '||p_import_status);
247: RAISE FND_API.G_EXC_ERROR;

Line 246: fnd_file.put_line(FND_FILE.LOG,'CZ IMPORT API Return Status : '||p_import_status);

242: IF (p_import_status = G_RET_STS_UNEXP_ERROR) THEN
243: fnd_file.put_line(FND_FILE.LOG,'CZ IMPORT API Return Status : '||p_import_status);
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
246: fnd_file.put_line(FND_FILE.LOG,'CZ IMPORT API Return Status : '||p_import_status);
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249:
250:

Line 252: fnd_file.put_line(FND_FILE.LOG,' CZ_XFR_RUN_RESULTS');

248: END IF;
249:
250:
251: -- Check the summary of the import run results
252: fnd_file.put_line(FND_FILE.LOG,' CZ_XFR_RUN_RESULTS');
253: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------');
254: fnd_file.put_line(FND_FILE.LOG,RPAD('Import Table',25,' ')||
255: ' Disposition'||
256: ' Record Status'||

Line 253: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------');

249:
250:
251: -- Check the summary of the import run results
252: fnd_file.put_line(FND_FILE.LOG,' CZ_XFR_RUN_RESULTS');
253: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------');
254: fnd_file.put_line(FND_FILE.LOG,RPAD('Import Table',25,' ')||
255: ' Disposition'||
256: ' Record Status'||
257: ' Total Records'

Line 254: fnd_file.put_line(FND_FILE.LOG,RPAD('Import Table',25,' ')||

250:
251: -- Check the summary of the import run results
252: fnd_file.put_line(FND_FILE.LOG,' CZ_XFR_RUN_RESULTS');
253: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------');
254: fnd_file.put_line(FND_FILE.LOG,RPAD('Import Table',25,' ')||
255: ' Disposition'||
256: ' Record Status'||
257: ' Total Records'
258: );

Line 259: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------');

255: ' Disposition'||
256: ' Record Status'||
257: ' Total Records'
258: );
259: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------');
260:
261: -- write to debug log file
262: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
263: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 275: fnd_file.put_line(FND_FILE.LOG,RPAD(csr_xfr_run_results_rec.imp_table,25,' ')||' '||

271:
272: FOR csr_xfr_run_results_rec IN csr_xfr_run_results
273: LOOP
274: l_rec_number := l_rec_number +1;
275: fnd_file.put_line(FND_FILE.LOG,RPAD(csr_xfr_run_results_rec.imp_table,25,' ')||' '||
276: RPAD(csr_xfr_run_results_rec.disposition,11,' ')||' '||
277: RPAD(csr_xfr_run_results_rec.rec_status,13,' ')||' '||
278: RPAD(csr_xfr_run_results_rec.records,13,' ')
279: );

Line 281: fnd_file.put_line(FND_FILE.LOG,' ');

277: RPAD(csr_xfr_run_results_rec.rec_status,13,' ')||' '||
278: RPAD(csr_xfr_run_results_rec.records,13,' ')
279: );
280: /*
281: fnd_file.put_line(FND_FILE.LOG,' ');
282: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
283: fnd_file.put_line(FND_FILE.LOG,'Import Table : '||csr_xfr_run_results_rec.imp_table);
284: fnd_file.put_line(FND_FILE.LOG,'Disposition : '||csr_xfr_run_results_rec.disposition);
285: fnd_file.put_line(FND_FILE.LOG,'Record Status : '||csr_xfr_run_results_rec.rec_status);

Line 282: fnd_file.put_line(FND_FILE.LOG,'* Record : '||l_rec_number||' ');

278: RPAD(csr_xfr_run_results_rec.records,13,' ')
279: );
280: /*
281: fnd_file.put_line(FND_FILE.LOG,' ');
282: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
283: fnd_file.put_line(FND_FILE.LOG,'Import Table : '||csr_xfr_run_results_rec.imp_table);
284: fnd_file.put_line(FND_FILE.LOG,'Disposition : '||csr_xfr_run_results_rec.disposition);
285: fnd_file.put_line(FND_FILE.LOG,'Record Status : '||csr_xfr_run_results_rec.rec_status);
286: fnd_file.put_line(FND_FILE.LOG,'Total Records : '||csr_xfr_run_results_rec.records);

Line 283: fnd_file.put_line(FND_FILE.LOG,'Import Table : '||csr_xfr_run_results_rec.imp_table);

279: );
280: /*
281: fnd_file.put_line(FND_FILE.LOG,' ');
282: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
283: fnd_file.put_line(FND_FILE.LOG,'Import Table : '||csr_xfr_run_results_rec.imp_table);
284: fnd_file.put_line(FND_FILE.LOG,'Disposition : '||csr_xfr_run_results_rec.disposition);
285: fnd_file.put_line(FND_FILE.LOG,'Record Status : '||csr_xfr_run_results_rec.rec_status);
286: fnd_file.put_line(FND_FILE.LOG,'Total Records : '||csr_xfr_run_results_rec.records);
287: fnd_file.put_line(FND_FILE.LOG,' ');

Line 284: fnd_file.put_line(FND_FILE.LOG,'Disposition : '||csr_xfr_run_results_rec.disposition);

280: /*
281: fnd_file.put_line(FND_FILE.LOG,' ');
282: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
283: fnd_file.put_line(FND_FILE.LOG,'Import Table : '||csr_xfr_run_results_rec.imp_table);
284: fnd_file.put_line(FND_FILE.LOG,'Disposition : '||csr_xfr_run_results_rec.disposition);
285: fnd_file.put_line(FND_FILE.LOG,'Record Status : '||csr_xfr_run_results_rec.rec_status);
286: fnd_file.put_line(FND_FILE.LOG,'Total Records : '||csr_xfr_run_results_rec.records);
287: fnd_file.put_line(FND_FILE.LOG,' ');
288: fnd_file.put_line(FND_FILE.LOG,' ');

Line 285: fnd_file.put_line(FND_FILE.LOG,'Record Status : '||csr_xfr_run_results_rec.rec_status);

281: fnd_file.put_line(FND_FILE.LOG,' ');
282: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
283: fnd_file.put_line(FND_FILE.LOG,'Import Table : '||csr_xfr_run_results_rec.imp_table);
284: fnd_file.put_line(FND_FILE.LOG,'Disposition : '||csr_xfr_run_results_rec.disposition);
285: fnd_file.put_line(FND_FILE.LOG,'Record Status : '||csr_xfr_run_results_rec.rec_status);
286: fnd_file.put_line(FND_FILE.LOG,'Total Records : '||csr_xfr_run_results_rec.records);
287: fnd_file.put_line(FND_FILE.LOG,' ');
288: fnd_file.put_line(FND_FILE.LOG,' ');
289: */

Line 286: fnd_file.put_line(FND_FILE.LOG,'Total Records : '||csr_xfr_run_results_rec.records);

282: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
283: fnd_file.put_line(FND_FILE.LOG,'Import Table : '||csr_xfr_run_results_rec.imp_table);
284: fnd_file.put_line(FND_FILE.LOG,'Disposition : '||csr_xfr_run_results_rec.disposition);
285: fnd_file.put_line(FND_FILE.LOG,'Record Status : '||csr_xfr_run_results_rec.rec_status);
286: fnd_file.put_line(FND_FILE.LOG,'Total Records : '||csr_xfr_run_results_rec.records);
287: fnd_file.put_line(FND_FILE.LOG,' ');
288: fnd_file.put_line(FND_FILE.LOG,' ');
289: */
290:

Line 287: fnd_file.put_line(FND_FILE.LOG,' ');

283: fnd_file.put_line(FND_FILE.LOG,'Import Table : '||csr_xfr_run_results_rec.imp_table);
284: fnd_file.put_line(FND_FILE.LOG,'Disposition : '||csr_xfr_run_results_rec.disposition);
285: fnd_file.put_line(FND_FILE.LOG,'Record Status : '||csr_xfr_run_results_rec.rec_status);
286: fnd_file.put_line(FND_FILE.LOG,'Total Records : '||csr_xfr_run_results_rec.records);
287: fnd_file.put_line(FND_FILE.LOG,' ');
288: fnd_file.put_line(FND_FILE.LOG,' ');
289: */
290:
291:

Line 288: fnd_file.put_line(FND_FILE.LOG,' ');

284: fnd_file.put_line(FND_FILE.LOG,'Disposition : '||csr_xfr_run_results_rec.disposition);
285: fnd_file.put_line(FND_FILE.LOG,'Record Status : '||csr_xfr_run_results_rec.rec_status);
286: fnd_file.put_line(FND_FILE.LOG,'Total Records : '||csr_xfr_run_results_rec.records);
287: fnd_file.put_line(FND_FILE.LOG,' ');
288: fnd_file.put_line(FND_FILE.LOG,' ');
289: */
290:
291:
292: -- write to debug log file

Line 321: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------');

317: END IF;
318:
319: END LOOP;
320:
321: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------');
322:
323: -- For Rule Import, if the return status is Error read message from cz_imp_rules
324: IF p_model_type = 'R' THEN
325: -- Check if any rules had error

Line 330: fnd_file.put_line(FND_FILE.LOG,'Following Rules Could not be imported');

326: OPEN csr_rule_imp_dtls;
327: FETCH csr_rule_imp_dtls INTO l_name, l_message;
328: IF csr_rule_imp_dtls%FOUND THEN
329: -- one or more rules in ERROR
330: fnd_file.put_line(FND_FILE.LOG,'Following Rules Could not be imported');
331: fnd_file.put_line(FND_FILE.LOG,'-----------------------------------------------');
332: -- set out status to Error
333: x_return_status := G_RET_STS_ERROR;
334: END IF;

Line 331: fnd_file.put_line(FND_FILE.LOG,'-----------------------------------------------');

327: FETCH csr_rule_imp_dtls INTO l_name, l_message;
328: IF csr_rule_imp_dtls%FOUND THEN
329: -- one or more rules in ERROR
330: fnd_file.put_line(FND_FILE.LOG,'Following Rules Could not be imported');
331: fnd_file.put_line(FND_FILE.LOG,'-----------------------------------------------');
332: -- set out status to Error
333: x_return_status := G_RET_STS_ERROR;
334: END IF;
335: CLOSE csr_rule_imp_dtls;

Line 343: fnd_file.put_line(FND_FILE.LOG,' ');

339:
340: FOR csr_rule_imp_dtls_rec IN csr_rule_imp_dtls
341: LOOP
342: l_rule_number := l_rule_number +1;
343: fnd_file.put_line(FND_FILE.LOG,' ');
344: fnd_file.put_line(FND_FILE.LOG,'--------------- Record : '||l_rule_number||' --------------');
345: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||csr_rule_imp_dtls_rec.name);
346: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_rule_imp_dtls_rec.msg);
347: fnd_file.put_line(FND_FILE.LOG,' ');

Line 344: fnd_file.put_line(FND_FILE.LOG,'--------------- Record : '||l_rule_number||' --------------');

340: FOR csr_rule_imp_dtls_rec IN csr_rule_imp_dtls
341: LOOP
342: l_rule_number := l_rule_number +1;
343: fnd_file.put_line(FND_FILE.LOG,' ');
344: fnd_file.put_line(FND_FILE.LOG,'--------------- Record : '||l_rule_number||' --------------');
345: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||csr_rule_imp_dtls_rec.name);
346: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_rule_imp_dtls_rec.msg);
347: fnd_file.put_line(FND_FILE.LOG,' ');
348:

Line 345: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||csr_rule_imp_dtls_rec.name);

341: LOOP
342: l_rule_number := l_rule_number +1;
343: fnd_file.put_line(FND_FILE.LOG,' ');
344: fnd_file.put_line(FND_FILE.LOG,'--------------- Record : '||l_rule_number||' --------------');
345: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||csr_rule_imp_dtls_rec.name);
346: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_rule_imp_dtls_rec.msg);
347: fnd_file.put_line(FND_FILE.LOG,' ');
348:
349: END LOOP;

Line 346: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_rule_imp_dtls_rec.msg);

342: l_rule_number := l_rule_number +1;
343: fnd_file.put_line(FND_FILE.LOG,' ');
344: fnd_file.put_line(FND_FILE.LOG,'--------------- Record : '||l_rule_number||' --------------');
345: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||csr_rule_imp_dtls_rec.name);
346: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_rule_imp_dtls_rec.msg);
347: fnd_file.put_line(FND_FILE.LOG,' ');
348:
349: END LOOP;
350:

Line 347: fnd_file.put_line(FND_FILE.LOG,' ');

343: fnd_file.put_line(FND_FILE.LOG,' ');
344: fnd_file.put_line(FND_FILE.LOG,'--------------- Record : '||l_rule_number||' --------------');
345: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||csr_rule_imp_dtls_rec.name);
346: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_rule_imp_dtls_rec.msg);
347: fnd_file.put_line(FND_FILE.LOG,' ');
348:
349: END LOOP;
350:
351: END IF; -- for Rule Import only

Line 2034: fnd_file.put_line(FND_FILE.LOG,' ');

2030: END LOOP; -- l_tmpl_csr
2031: CLOSE csr_templates;
2032:
2033: -- Put the parameters in log file
2034: fnd_file.put_line(FND_FILE.LOG,' ');
2035: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
2036: fnd_file.put_line(FND_FILE.LOG,'p_calling_mode: '||p_calling_mode);
2037: fnd_file.put_line(FND_FILE.LOG,'p_template_id: '||p_template_id);
2038: fnd_file.put_line(FND_FILE.LOG,'xprt_request_id: '||FND_GLOBAL.CONC_REQUEST_ID);

Line 2035: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

2031: CLOSE csr_templates;
2032:
2033: -- Put the parameters in log file
2034: fnd_file.put_line(FND_FILE.LOG,' ');
2035: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
2036: fnd_file.put_line(FND_FILE.LOG,'p_calling_mode: '||p_calling_mode);
2037: fnd_file.put_line(FND_FILE.LOG,'p_template_id: '||p_template_id);
2038: fnd_file.put_line(FND_FILE.LOG,'xprt_request_id: '||FND_GLOBAL.CONC_REQUEST_ID);
2039: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 2036: fnd_file.put_line(FND_FILE.LOG,'p_calling_mode: '||p_calling_mode);

2032:
2033: -- Put the parameters in log file
2034: fnd_file.put_line(FND_FILE.LOG,' ');
2035: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
2036: fnd_file.put_line(FND_FILE.LOG,'p_calling_mode: '||p_calling_mode);
2037: fnd_file.put_line(FND_FILE.LOG,'p_template_id: '||p_template_id);
2038: fnd_file.put_line(FND_FILE.LOG,'xprt_request_id: '||FND_GLOBAL.CONC_REQUEST_ID);
2039: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
2040: fnd_file.put_line(FND_FILE.LOG,' ');

Line 2037: fnd_file.put_line(FND_FILE.LOG,'p_template_id: '||p_template_id);

2033: -- Put the parameters in log file
2034: fnd_file.put_line(FND_FILE.LOG,' ');
2035: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
2036: fnd_file.put_line(FND_FILE.LOG,'p_calling_mode: '||p_calling_mode);
2037: fnd_file.put_line(FND_FILE.LOG,'p_template_id: '||p_template_id);
2038: fnd_file.put_line(FND_FILE.LOG,'xprt_request_id: '||FND_GLOBAL.CONC_REQUEST_ID);
2039: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
2040: fnd_file.put_line(FND_FILE.LOG,' ');
2041:

Line 2038: fnd_file.put_line(FND_FILE.LOG,'xprt_request_id: '||FND_GLOBAL.CONC_REQUEST_ID);

2034: fnd_file.put_line(FND_FILE.LOG,' ');
2035: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
2036: fnd_file.put_line(FND_FILE.LOG,'p_calling_mode: '||p_calling_mode);
2037: fnd_file.put_line(FND_FILE.LOG,'p_template_id: '||p_template_id);
2038: fnd_file.put_line(FND_FILE.LOG,'xprt_request_id: '||FND_GLOBAL.CONC_REQUEST_ID);
2039: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
2040: fnd_file.put_line(FND_FILE.LOG,' ');
2041:
2042: IF (p_calling_mode = 'PUBLISH') THEN

Line 2039: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

2035: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
2036: fnd_file.put_line(FND_FILE.LOG,'p_calling_mode: '||p_calling_mode);
2037: fnd_file.put_line(FND_FILE.LOG,'p_template_id: '||p_template_id);
2038: fnd_file.put_line(FND_FILE.LOG,'xprt_request_id: '||FND_GLOBAL.CONC_REQUEST_ID);
2039: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
2040: fnd_file.put_line(FND_FILE.LOG,' ');
2041:
2042: IF (p_calling_mode = 'PUBLISH') THEN
2043: -- Update all the Question order records that have question_rule_status as PENDINGPUB

Line 2040: fnd_file.put_line(FND_FILE.LOG,' ');

2036: fnd_file.put_line(FND_FILE.LOG,'p_calling_mode: '||p_calling_mode);
2037: fnd_file.put_line(FND_FILE.LOG,'p_template_id: '||p_template_id);
2038: fnd_file.put_line(FND_FILE.LOG,'xprt_request_id: '||FND_GLOBAL.CONC_REQUEST_ID);
2039: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
2040: fnd_file.put_line(FND_FILE.LOG,' ');
2041:
2042: IF (p_calling_mode = 'PUBLISH') THEN
2043: -- Update all the Question order records that have question_rule_status as PENDINGPUB
2044: UPDATE Okc_Xprt_Question_Orders

Line 6245: fnd_file.put_line(FND_FILE.LOG,' ');

6241: l_ruleid_tbl(i) := rec_approval_rules.rule_id;
6242: END LOOP;
6243: END IF;
6244:
6245: fnd_file.put_line(FND_FILE.LOG,' ');
6246: fnd_file.put_line(FND_FILE.LOG,'Calling OKC_XPRT_QA_PVT.qa_rules ');
6247:
6248: -- Call the QA API
6249: OKC_XPRT_QA_PVT.qa_rules

Line 6246: fnd_file.put_line(FND_FILE.LOG,'Calling OKC_XPRT_QA_PVT.qa_rules ');

6242: END LOOP;
6243: END IF;
6244:
6245: fnd_file.put_line(FND_FILE.LOG,' ');
6246: fnd_file.put_line(FND_FILE.LOG,'Calling OKC_XPRT_QA_PVT.qa_rules ');
6247:
6248: -- Call the QA API
6249: OKC_XPRT_QA_PVT.qa_rules
6250: (

Line 6260: fnd_file.put_line(FND_FILE.LOG,' ');

6256: x_msg_count => x_msg_count,
6257: x_msg_data => x_msg_data
6258: );
6259:
6260: fnd_file.put_line(FND_FILE.LOG,' ');
6261: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_QA_PVT.qa_rules ');
6262: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
6263: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||x_qa_status);
6264: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||x_sequence_id);

Line 6261: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_QA_PVT.qa_rules ');

6257: x_msg_data => x_msg_data
6258: );
6259:
6260: fnd_file.put_line(FND_FILE.LOG,' ');
6261: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_QA_PVT.qa_rules ');
6262: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
6263: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||x_qa_status);
6264: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||x_sequence_id);
6265: fnd_file.put_line(FND_FILE.LOG,' ');

Line 6262: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

6258: );
6259:
6260: fnd_file.put_line(FND_FILE.LOG,' ');
6261: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_QA_PVT.qa_rules ');
6262: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
6263: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||x_qa_status);
6264: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||x_sequence_id);
6265: fnd_file.put_line(FND_FILE.LOG,' ');
6266:

Line 6263: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||x_qa_status);

6259:
6260: fnd_file.put_line(FND_FILE.LOG,' ');
6261: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_QA_PVT.qa_rules ');
6262: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
6263: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||x_qa_status);
6264: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||x_sequence_id);
6265: fnd_file.put_line(FND_FILE.LOG,' ');
6266:
6267: --- If any errors happen abort API

Line 6264: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||x_sequence_id);

6260: fnd_file.put_line(FND_FILE.LOG,' ');
6261: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_QA_PVT.qa_rules ');
6262: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
6263: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||x_qa_status);
6264: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||x_sequence_id);
6265: fnd_file.put_line(FND_FILE.LOG,' ');
6266:
6267: --- If any errors happen abort API
6268: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 6265: fnd_file.put_line(FND_FILE.LOG,' ');

6261: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_QA_PVT.qa_rules ');
6262: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
6263: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||x_qa_status);
6264: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||x_sequence_id);
6265: fnd_file.put_line(FND_FILE.LOG,' ');
6266:
6267: --- If any errors happen abort API
6268: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
6269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6276: fnd_file.put_line(FND_FILE.LOG,' ');

6272: END IF;
6273:
6274: -- If QA had one or more errors, log the errors
6275: IF x_qa_status <> 'S' THEN
6276: fnd_file.put_line(FND_FILE.LOG,' ');
6277: fnd_file.put_line(FND_FILE.LOG,'Following Rules did not pass QA ');
6278: fnd_file.put_line(FND_FILE.LOG,' ');
6279: FOR rec_qa_errors IN csr_qa_errors(p_sequence_id => x_sequence_id)
6280: LOOP

Line 6277: fnd_file.put_line(FND_FILE.LOG,'Following Rules did not pass QA ');

6273:
6274: -- If QA had one or more errors, log the errors
6275: IF x_qa_status <> 'S' THEN
6276: fnd_file.put_line(FND_FILE.LOG,' ');
6277: fnd_file.put_line(FND_FILE.LOG,'Following Rules did not pass QA ');
6278: fnd_file.put_line(FND_FILE.LOG,' ');
6279: FOR rec_qa_errors IN csr_qa_errors(p_sequence_id => x_sequence_id)
6280: LOOP
6281: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||rec_qa_errors.title);

Line 6278: fnd_file.put_line(FND_FILE.LOG,' ');

6274: -- If QA had one or more errors, log the errors
6275: IF x_qa_status <> 'S' THEN
6276: fnd_file.put_line(FND_FILE.LOG,' ');
6277: fnd_file.put_line(FND_FILE.LOG,'Following Rules did not pass QA ');
6278: fnd_file.put_line(FND_FILE.LOG,' ');
6279: FOR rec_qa_errors IN csr_qa_errors(p_sequence_id => x_sequence_id)
6280: LOOP
6281: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||rec_qa_errors.title);
6282: fnd_file.put_line(FND_FILE.LOG,'QA Check : '||rec_qa_errors.problem_short_desc);

Line 6281: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||rec_qa_errors.title);

6277: fnd_file.put_line(FND_FILE.LOG,'Following Rules did not pass QA ');
6278: fnd_file.put_line(FND_FILE.LOG,' ');
6279: FOR rec_qa_errors IN csr_qa_errors(p_sequence_id => x_sequence_id)
6280: LOOP
6281: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||rec_qa_errors.title);
6282: fnd_file.put_line(FND_FILE.LOG,'QA Check : '||rec_qa_errors.problem_short_desc);
6283: fnd_file.put_line(FND_FILE.LOG,'Problem : '||rec_qa_errors.problem_details);
6284: fnd_file.put_line(FND_FILE.LOG,'Suggestion : '||rec_qa_errors.suggestion);
6285: fnd_file.put_line(FND_FILE.LOG,' ');

Line 6282: fnd_file.put_line(FND_FILE.LOG,'QA Check : '||rec_qa_errors.problem_short_desc);

6278: fnd_file.put_line(FND_FILE.LOG,' ');
6279: FOR rec_qa_errors IN csr_qa_errors(p_sequence_id => x_sequence_id)
6280: LOOP
6281: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||rec_qa_errors.title);
6282: fnd_file.put_line(FND_FILE.LOG,'QA Check : '||rec_qa_errors.problem_short_desc);
6283: fnd_file.put_line(FND_FILE.LOG,'Problem : '||rec_qa_errors.problem_details);
6284: fnd_file.put_line(FND_FILE.LOG,'Suggestion : '||rec_qa_errors.suggestion);
6285: fnd_file.put_line(FND_FILE.LOG,' ');
6286: END LOOP;

Line 6283: fnd_file.put_line(FND_FILE.LOG,'Problem : '||rec_qa_errors.problem_details);

6279: FOR rec_qa_errors IN csr_qa_errors(p_sequence_id => x_sequence_id)
6280: LOOP
6281: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||rec_qa_errors.title);
6282: fnd_file.put_line(FND_FILE.LOG,'QA Check : '||rec_qa_errors.problem_short_desc);
6283: fnd_file.put_line(FND_FILE.LOG,'Problem : '||rec_qa_errors.problem_details);
6284: fnd_file.put_line(FND_FILE.LOG,'Suggestion : '||rec_qa_errors.suggestion);
6285: fnd_file.put_line(FND_FILE.LOG,' ');
6286: END LOOP;
6287:

Line 6284: fnd_file.put_line(FND_FILE.LOG,'Suggestion : '||rec_qa_errors.suggestion);

6280: LOOP
6281: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||rec_qa_errors.title);
6282: fnd_file.put_line(FND_FILE.LOG,'QA Check : '||rec_qa_errors.problem_short_desc);
6283: fnd_file.put_line(FND_FILE.LOG,'Problem : '||rec_qa_errors.problem_details);
6284: fnd_file.put_line(FND_FILE.LOG,'Suggestion : '||rec_qa_errors.suggestion);
6285: fnd_file.put_line(FND_FILE.LOG,' ');
6286: END LOOP;
6287:
6288: END IF; -- qa had errors

Line 6285: fnd_file.put_line(FND_FILE.LOG,' ');

6281: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||rec_qa_errors.title);
6282: fnd_file.put_line(FND_FILE.LOG,'QA Check : '||rec_qa_errors.problem_short_desc);
6283: fnd_file.put_line(FND_FILE.LOG,'Problem : '||rec_qa_errors.problem_details);
6284: fnd_file.put_line(FND_FILE.LOG,'Suggestion : '||rec_qa_errors.suggestion);
6285: fnd_file.put_line(FND_FILE.LOG,' ');
6286: END LOOP;
6287:
6288: END IF; -- qa had errors
6289: