APPS.OKS_INTEGRATION_UTIL_PUB dependencies on UTL_FILE

Line 504: l_file_type utl_file.file_type;

500: x_return_status OUT NOCOPY VARCHAR2) IS
501:
502: l_file_name VARCHAR2(200);
503: l_file_loc BFILE;
504: l_file_type utl_file.file_type;
505: l_location VARCHAR2(32000);
506: l_comma_loc NUMBER;
507: l_error_msg VARCHAR2(32000) := p_error_msg;
508:

Line 512: where name = 'utl_file_dir';

508:
509: cursor get_dir is
510: select value
511: from v$parameter
512: where name = 'utl_file_dir';
513:
514: Begin
515: x_return_status := OKC_API.G_RET_STS_SUCCESS;
516:

Line 533: l_file_type := utl_file.fopen(location => l_location,

529: l_location := substr(l_location, 1, l_comma_loc - 1);
530: End If;
531: End If;
532:
533: l_file_type := utl_file.fopen(location => l_location,
534: filename => l_file_name,
535: open_mode => 'a');
536:
537: utl_file.put_line(file => l_file_type,

Line 537: utl_file.put_line(file => l_file_type,

533: l_file_type := utl_file.fopen(location => l_location,
534: filename => l_file_name,
535: open_mode => 'a');
536:
537: utl_file.put_line(file => l_file_type,
538: buffer => l_error_msg );
539:
540: utl_file.fflush(file => l_file_type);
541: utl_file.fclose(l_file_type);

Line 540: utl_file.fflush(file => l_file_type);

536:
537: utl_file.put_line(file => l_file_type,
538: buffer => l_error_msg );
539:
540: utl_file.fflush(file => l_file_type);
541: utl_file.fclose(l_file_type);
542: -- End If;
543:
544: Exception

Line 541: utl_file.fclose(l_file_type);

537: utl_file.put_line(file => l_file_type,
538: buffer => l_error_msg );
539:
540: utl_file.fflush(file => l_file_type);
541: utl_file.fclose(l_file_type);
542: -- End If;
543:
544: Exception
545: when utl_file.INVALID_PATH then

Line 545: when utl_file.INVALID_PATH then

541: utl_file.fclose(l_file_type);
542: -- End If;
543:
544: Exception
545: when utl_file.INVALID_PATH then
546: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
547: x_msg_data := l_error_msg || ' Invalid Path';
548: x_msg_count:= 1;
549: OKC_API.set_message

Line 558: when utl_file.INVALID_OPERATION then

554: SQLCODE,
555: G_SQLERRM_TOKEN,
556: 'Invalid path'
557: );
558: when utl_file.INVALID_OPERATION then
559: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
560: x_msg_data := l_error_msg || ' Invalid operation';
561: x_msg_count:= 1;
562: OKC_API.set_message