DBA Data[Home] [Help]

APPS.OKS_K_ACTIONS_PVT dependencies on FND_FILE

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

307: l_msg_ctr BINARY_INTEGER := 1;
308:
309: BEGIN
310:
311: fnd_file.put_line(FND_FILE.LOG,' ');
312: fnd_file.put_line(FND_FILE.LOG,'Entering OKS_K_ACTIONS_PVT.execute_qa_check_list');
313: fnd_file.put_line(FND_FILE.LOG,' ');
314:
315: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 312: fnd_file.put_line(FND_FILE.LOG,'Entering OKS_K_ACTIONS_PVT.execute_qa_check_list');

308:
309: BEGIN
310:
311: fnd_file.put_line(FND_FILE.LOG,' ');
312: fnd_file.put_line(FND_FILE.LOG,'Entering OKS_K_ACTIONS_PVT.execute_qa_check_list');
313: fnd_file.put_line(FND_FILE.LOG,' ');
314:
315: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
316: fnd_file.put_line(FND_FILE.LOG,'Calling OKC_QA_CHECK_PUB.execute_qa_check_list');

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

309: BEGIN
310:
311: fnd_file.put_line(FND_FILE.LOG,' ');
312: fnd_file.put_line(FND_FILE.LOG,'Entering OKS_K_ACTIONS_PVT.execute_qa_check_list');
313: fnd_file.put_line(FND_FILE.LOG,' ');
314:
315: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
316: fnd_file.put_line(FND_FILE.LOG,'Calling OKC_QA_CHECK_PUB.execute_qa_check_list');
317: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

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

311: fnd_file.put_line(FND_FILE.LOG,' ');
312: fnd_file.put_line(FND_FILE.LOG,'Entering OKS_K_ACTIONS_PVT.execute_qa_check_list');
313: fnd_file.put_line(FND_FILE.LOG,' ');
314:
315: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
316: fnd_file.put_line(FND_FILE.LOG,'Calling OKC_QA_CHECK_PUB.execute_qa_check_list');
317: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
318: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
319: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 316: fnd_file.put_line(FND_FILE.LOG,'Calling OKC_QA_CHECK_PUB.execute_qa_check_list');

312: fnd_file.put_line(FND_FILE.LOG,'Entering OKS_K_ACTIONS_PVT.execute_qa_check_list');
313: fnd_file.put_line(FND_FILE.LOG,' ');
314:
315: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
316: fnd_file.put_line(FND_FILE.LOG,'Calling OKC_QA_CHECK_PUB.execute_qa_check_list');
317: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
318: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
319: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
320: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);

Line 317: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

313: fnd_file.put_line(FND_FILE.LOG,' ');
314:
315: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
316: fnd_file.put_line(FND_FILE.LOG,'Calling OKC_QA_CHECK_PUB.execute_qa_check_list');
317: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
318: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
319: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
320: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
321: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);

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

314:
315: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
316: fnd_file.put_line(FND_FILE.LOG,'Calling OKC_QA_CHECK_PUB.execute_qa_check_list');
317: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
318: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
319: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
320: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
321: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
322: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);

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

315: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
316: fnd_file.put_line(FND_FILE.LOG,'Calling OKC_QA_CHECK_PUB.execute_qa_check_list');
317: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
318: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
319: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
320: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
321: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
322: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
323: fnd_file.put_line(FND_FILE.LOG,'p_qcl_id : '||p_qcl_id);

Line 320: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);

316: fnd_file.put_line(FND_FILE.LOG,'Calling OKC_QA_CHECK_PUB.execute_qa_check_list');
317: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
318: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
319: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
320: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
321: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
322: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
323: fnd_file.put_line(FND_FILE.LOG,'p_qcl_id : '||p_qcl_id);
324: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

317: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
318: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
319: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
320: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
321: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
322: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
323: fnd_file.put_line(FND_FILE.LOG,'p_qcl_id : '||p_qcl_id);
324: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
325: fnd_file.put_line(FND_FILE.LOG,' ');

Line 322: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);

318: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
319: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
320: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
321: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
322: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
323: fnd_file.put_line(FND_FILE.LOG,'p_qcl_id : '||p_qcl_id);
324: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
325: fnd_file.put_line(FND_FILE.LOG,' ');
326:

Line 323: fnd_file.put_line(FND_FILE.LOG,'p_qcl_id : '||p_qcl_id);

319: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
320: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
321: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
322: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
323: fnd_file.put_line(FND_FILE.LOG,'p_qcl_id : '||p_qcl_id);
324: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
325: fnd_file.put_line(FND_FILE.LOG,' ');
326:
327: OKC_QA_CHECK_PUB.execute_qa_check_list

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

320: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
321: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
322: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
323: fnd_file.put_line(FND_FILE.LOG,'p_qcl_id : '||p_qcl_id);
324: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
325: fnd_file.put_line(FND_FILE.LOG,' ');
326:
327: OKC_QA_CHECK_PUB.execute_qa_check_list
328: (

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

321: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
322: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
323: fnd_file.put_line(FND_FILE.LOG,'p_qcl_id : '||p_qcl_id);
324: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
325: fnd_file.put_line(FND_FILE.LOG,' ');
326:
327: OKC_QA_CHECK_PUB.execute_qa_check_list
328: (
329: p_api_version => p_api_version,

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

335: p_chr_id => p_chr_id,
336: x_msg_tbl => l_msg_tbl
337: );
338:
339: fnd_file.put_line(FND_FILE.LOG,' ');
340: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
341: fnd_file.put_line(FND_FILE.LOG,'AFTER Calling OKC_QA_CHECK_PUB.execute_qa_check_list');
342: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
343: fnd_file.put_line(FND_FILE.LOG,'OUT Parameters ');

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

336: x_msg_tbl => l_msg_tbl
337: );
338:
339: fnd_file.put_line(FND_FILE.LOG,' ');
340: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
341: fnd_file.put_line(FND_FILE.LOG,'AFTER Calling OKC_QA_CHECK_PUB.execute_qa_check_list');
342: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
343: fnd_file.put_line(FND_FILE.LOG,'OUT Parameters ');
344: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 341: fnd_file.put_line(FND_FILE.LOG,'AFTER Calling OKC_QA_CHECK_PUB.execute_qa_check_list');

337: );
338:
339: fnd_file.put_line(FND_FILE.LOG,' ');
340: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
341: fnd_file.put_line(FND_FILE.LOG,'AFTER Calling OKC_QA_CHECK_PUB.execute_qa_check_list');
342: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
343: fnd_file.put_line(FND_FILE.LOG,'OUT Parameters ');
344: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
345: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||l_return_status);

Line 342: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

338:
339: fnd_file.put_line(FND_FILE.LOG,' ');
340: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
341: fnd_file.put_line(FND_FILE.LOG,'AFTER Calling OKC_QA_CHECK_PUB.execute_qa_check_list');
342: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
343: fnd_file.put_line(FND_FILE.LOG,'OUT Parameters ');
344: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
345: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||l_return_status);
346: fnd_file.put_line(FND_FILE.LOG,'x_msg_tbl.count : '||l_msg_tbl.count);

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

339: fnd_file.put_line(FND_FILE.LOG,' ');
340: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
341: fnd_file.put_line(FND_FILE.LOG,'AFTER Calling OKC_QA_CHECK_PUB.execute_qa_check_list');
342: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
343: fnd_file.put_line(FND_FILE.LOG,'OUT Parameters ');
344: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
345: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||l_return_status);
346: fnd_file.put_line(FND_FILE.LOG,'x_msg_tbl.count : '||l_msg_tbl.count);
347: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

340: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
341: fnd_file.put_line(FND_FILE.LOG,'AFTER Calling OKC_QA_CHECK_PUB.execute_qa_check_list');
342: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
343: fnd_file.put_line(FND_FILE.LOG,'OUT Parameters ');
344: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
345: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||l_return_status);
346: fnd_file.put_line(FND_FILE.LOG,'x_msg_tbl.count : '||l_msg_tbl.count);
347: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
348: fnd_file.put_line(FND_FILE.LOG,' ');

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

341: fnd_file.put_line(FND_FILE.LOG,'AFTER Calling OKC_QA_CHECK_PUB.execute_qa_check_list');
342: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
343: fnd_file.put_line(FND_FILE.LOG,'OUT Parameters ');
344: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
345: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||l_return_status);
346: fnd_file.put_line(FND_FILE.LOG,'x_msg_tbl.count : '||l_msg_tbl.count);
347: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
348: fnd_file.put_line(FND_FILE.LOG,' ');
349:

Line 346: fnd_file.put_line(FND_FILE.LOG,'x_msg_tbl.count : '||l_msg_tbl.count);

342: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
343: fnd_file.put_line(FND_FILE.LOG,'OUT Parameters ');
344: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
345: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||l_return_status);
346: fnd_file.put_line(FND_FILE.LOG,'x_msg_tbl.count : '||l_msg_tbl.count);
347: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
348: fnd_file.put_line(FND_FILE.LOG,' ');
349:
350:

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

343: fnd_file.put_line(FND_FILE.LOG,'OUT Parameters ');
344: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
345: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||l_return_status);
346: fnd_file.put_line(FND_FILE.LOG,'x_msg_tbl.count : '||l_msg_tbl.count);
347: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
348: fnd_file.put_line(FND_FILE.LOG,' ');
349:
350:
351: -- bug 5329334

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

344: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
345: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||l_return_status);
346: fnd_file.put_line(FND_FILE.LOG,'x_msg_tbl.count : '||l_msg_tbl.count);
347: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
348: fnd_file.put_line(FND_FILE.LOG,' ');
349:
350:
351: -- bug 5329334
352: -- should loop thru l_msg_tbl(l_count).error_status to check if there are any qa errors

Line 366: fnd_file.put_line(FND_FILE.LOG,'******** Following QA Errors occured ******** ');

362:
363: -- Check if any of the QA checks have failed. If so write to log file
364: IF l_msg_tbl.count >0 THEN
365:
366: fnd_file.put_line(FND_FILE.LOG,'******** Following QA Errors occured ******** ');
367: fnd_file.put_line(FND_FILE.LOG,' ');
368:
369: l_count := l_msg_tbl.first;
370: LOOP

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

363: -- Check if any of the QA checks have failed. If so write to log file
364: IF l_msg_tbl.count >0 THEN
365:
366: fnd_file.put_line(FND_FILE.LOG,'******** Following QA Errors occured ******** ');
367: fnd_file.put_line(FND_FILE.LOG,' ');
368:
369: l_count := l_msg_tbl.first;
370: LOOP
371: IF l_msg_tbl(l_count).error_status='E' THEN

Line 373: fnd_file.put_line(FND_FILE.LOG,l_msg_ctr||' : '||l_msg_tbl(l_count).data);

369: l_count := l_msg_tbl.first;
370: LOOP
371: IF l_msg_tbl(l_count).error_status='E' THEN
372: -- write to fnd_log file
373: fnd_file.put_line(FND_FILE.LOG,l_msg_ctr||' : '||l_msg_tbl(l_count).data);
374:
375: -- reset the out parameter to Error
376: x_return_status := 'E';
377:

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

383: l_count:=l_msg_tbl.next(l_count);
384: END LOOP;
385: END IF; -- l_msg_tbl.count >0
386:
387: fnd_file.put_line(FND_FILE.LOG,' ');
388: fnd_file.put_line(FND_FILE.LOG,'Leaving OKS_K_ACTIONS_PVT.execute_qa_check_list');
389: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||x_return_status);
390: fnd_file.put_line(FND_FILE.LOG,' ');
391:

Line 388: fnd_file.put_line(FND_FILE.LOG,'Leaving OKS_K_ACTIONS_PVT.execute_qa_check_list');

384: END LOOP;
385: END IF; -- l_msg_tbl.count >0
386:
387: fnd_file.put_line(FND_FILE.LOG,' ');
388: fnd_file.put_line(FND_FILE.LOG,'Leaving OKS_K_ACTIONS_PVT.execute_qa_check_list');
389: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||x_return_status);
390: fnd_file.put_line(FND_FILE.LOG,' ');
391:
392: EXCEPTION

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

385: END IF; -- l_msg_tbl.count >0
386:
387: fnd_file.put_line(FND_FILE.LOG,' ');
388: fnd_file.put_line(FND_FILE.LOG,'Leaving OKS_K_ACTIONS_PVT.execute_qa_check_list');
389: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||x_return_status);
390: fnd_file.put_line(FND_FILE.LOG,' ');
391:
392: EXCEPTION
393: WHEN FND_API.G_EXC_ERROR THEN

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

386:
387: fnd_file.put_line(FND_FILE.LOG,' ');
388: fnd_file.put_line(FND_FILE.LOG,'Leaving OKS_K_ACTIONS_PVT.execute_qa_check_list');
389: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||x_return_status);
390: fnd_file.put_line(FND_FILE.LOG,' ');
391:
392: EXCEPTION
393: WHEN FND_API.G_EXC_ERROR THEN
394: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN