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 187: fnd_file.put_line(FND_FILE.LOG,' ');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6043: l_ruleid_tbl(i) := rec_approval_rules.rule_id;
6044: END LOOP;
6045: END IF;
6046:
6047: fnd_file.put_line(FND_FILE.LOG,' ');
6048: fnd_file.put_line(FND_FILE.LOG,'Calling OKC_XPRT_QA_PVT.qa_rules ');
6049:
6050: -- Call the QA API
6051: OKC_XPRT_QA_PVT.qa_rules

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

6044: END LOOP;
6045: END IF;
6046:
6047: fnd_file.put_line(FND_FILE.LOG,' ');
6048: fnd_file.put_line(FND_FILE.LOG,'Calling OKC_XPRT_QA_PVT.qa_rules ');
6049:
6050: -- Call the QA API
6051: OKC_XPRT_QA_PVT.qa_rules
6052: (

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

6058: x_msg_count => x_msg_count,
6059: x_msg_data => x_msg_data
6060: );
6061:
6062: fnd_file.put_line(FND_FILE.LOG,' ');
6063: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_QA_PVT.qa_rules ');
6064: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
6065: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||x_qa_status);
6066: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||x_sequence_id);

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

6059: x_msg_data => x_msg_data
6060: );
6061:
6062: fnd_file.put_line(FND_FILE.LOG,' ');
6063: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_QA_PVT.qa_rules ');
6064: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
6065: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||x_qa_status);
6066: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||x_sequence_id);
6067: fnd_file.put_line(FND_FILE.LOG,' ');

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

6060: );
6061:
6062: fnd_file.put_line(FND_FILE.LOG,' ');
6063: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_QA_PVT.qa_rules ');
6064: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
6065: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||x_qa_status);
6066: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||x_sequence_id);
6067: fnd_file.put_line(FND_FILE.LOG,' ');
6068:

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

6061:
6062: fnd_file.put_line(FND_FILE.LOG,' ');
6063: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_QA_PVT.qa_rules ');
6064: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
6065: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||x_qa_status);
6066: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||x_sequence_id);
6067: fnd_file.put_line(FND_FILE.LOG,' ');
6068:
6069: --- If any errors happen abort API

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

6062: fnd_file.put_line(FND_FILE.LOG,' ');
6063: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_QA_PVT.qa_rules ');
6064: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
6065: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||x_qa_status);
6066: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||x_sequence_id);
6067: fnd_file.put_line(FND_FILE.LOG,' ');
6068:
6069: --- If any errors happen abort API
6070: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

6063: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_QA_PVT.qa_rules ');
6064: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
6065: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||x_qa_status);
6066: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||x_sequence_id);
6067: fnd_file.put_line(FND_FILE.LOG,' ');
6068:
6069: --- If any errors happen abort API
6070: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
6071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6074: END IF;
6075:
6076: -- If QA had one or more errors, log the errors
6077: IF x_qa_status <> 'S' THEN
6078: fnd_file.put_line(FND_FILE.LOG,' ');
6079: fnd_file.put_line(FND_FILE.LOG,'Following Rules did not pass QA ');
6080: fnd_file.put_line(FND_FILE.LOG,' ');
6081: FOR rec_qa_errors IN csr_qa_errors(p_sequence_id => x_sequence_id)
6082: LOOP

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

6075:
6076: -- If QA had one or more errors, log the errors
6077: IF x_qa_status <> 'S' THEN
6078: fnd_file.put_line(FND_FILE.LOG,' ');
6079: fnd_file.put_line(FND_FILE.LOG,'Following Rules did not pass QA ');
6080: fnd_file.put_line(FND_FILE.LOG,' ');
6081: FOR rec_qa_errors IN csr_qa_errors(p_sequence_id => x_sequence_id)
6082: LOOP
6083: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||rec_qa_errors.title);

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

6076: -- If QA had one or more errors, log the errors
6077: IF x_qa_status <> 'S' THEN
6078: fnd_file.put_line(FND_FILE.LOG,' ');
6079: fnd_file.put_line(FND_FILE.LOG,'Following Rules did not pass QA ');
6080: fnd_file.put_line(FND_FILE.LOG,' ');
6081: FOR rec_qa_errors IN csr_qa_errors(p_sequence_id => x_sequence_id)
6082: LOOP
6083: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||rec_qa_errors.title);
6084: fnd_file.put_line(FND_FILE.LOG,'QA Check : '||rec_qa_errors.problem_short_desc);

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

6079: fnd_file.put_line(FND_FILE.LOG,'Following Rules did not pass QA ');
6080: fnd_file.put_line(FND_FILE.LOG,' ');
6081: FOR rec_qa_errors IN csr_qa_errors(p_sequence_id => x_sequence_id)
6082: LOOP
6083: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||rec_qa_errors.title);
6084: fnd_file.put_line(FND_FILE.LOG,'QA Check : '||rec_qa_errors.problem_short_desc);
6085: fnd_file.put_line(FND_FILE.LOG,'Problem : '||rec_qa_errors.problem_details);
6086: fnd_file.put_line(FND_FILE.LOG,'Suggestion : '||rec_qa_errors.suggestion);
6087: fnd_file.put_line(FND_FILE.LOG,' ');

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

6080: fnd_file.put_line(FND_FILE.LOG,' ');
6081: FOR rec_qa_errors IN csr_qa_errors(p_sequence_id => x_sequence_id)
6082: LOOP
6083: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||rec_qa_errors.title);
6084: fnd_file.put_line(FND_FILE.LOG,'QA Check : '||rec_qa_errors.problem_short_desc);
6085: fnd_file.put_line(FND_FILE.LOG,'Problem : '||rec_qa_errors.problem_details);
6086: fnd_file.put_line(FND_FILE.LOG,'Suggestion : '||rec_qa_errors.suggestion);
6087: fnd_file.put_line(FND_FILE.LOG,' ');
6088: END LOOP;

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

6081: FOR rec_qa_errors IN csr_qa_errors(p_sequence_id => x_sequence_id)
6082: LOOP
6083: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||rec_qa_errors.title);
6084: fnd_file.put_line(FND_FILE.LOG,'QA Check : '||rec_qa_errors.problem_short_desc);
6085: fnd_file.put_line(FND_FILE.LOG,'Problem : '||rec_qa_errors.problem_details);
6086: fnd_file.put_line(FND_FILE.LOG,'Suggestion : '||rec_qa_errors.suggestion);
6087: fnd_file.put_line(FND_FILE.LOG,' ');
6088: END LOOP;
6089:

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

6082: LOOP
6083: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||rec_qa_errors.title);
6084: fnd_file.put_line(FND_FILE.LOG,'QA Check : '||rec_qa_errors.problem_short_desc);
6085: fnd_file.put_line(FND_FILE.LOG,'Problem : '||rec_qa_errors.problem_details);
6086: fnd_file.put_line(FND_FILE.LOG,'Suggestion : '||rec_qa_errors.suggestion);
6087: fnd_file.put_line(FND_FILE.LOG,' ');
6088: END LOOP;
6089:
6090: END IF; -- qa had errors

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

6083: fnd_file.put_line(FND_FILE.LOG,'Rule Name : '||rec_qa_errors.title);
6084: fnd_file.put_line(FND_FILE.LOG,'QA Check : '||rec_qa_errors.problem_short_desc);
6085: fnd_file.put_line(FND_FILE.LOG,'Problem : '||rec_qa_errors.problem_details);
6086: fnd_file.put_line(FND_FILE.LOG,'Suggestion : '||rec_qa_errors.suggestion);
6087: fnd_file.put_line(FND_FILE.LOG,' ');
6088: END LOOP;
6089:
6090: END IF; -- qa had errors
6091: