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.OZF_WEBADI_INTERFACE_PVT dependencies on UTL_FILE

Line 905: WHERE name = 'utl_file_dir';

901: CURSOR C
902: IS
903: SELECT value
904: FROM v$parameter
905: WHERE name = 'utl_file_dir';
906:
907: CURSOR csr_get_party_site_id(cv_site_number IN VARCHAR2) IS
908: SELECT party_site_id
909: FROM hz_party_sites

Line 939: l_file utl_file.file_type;

935: l_resale_line_int_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
936: l_object_version_no_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
937: l_total_claimed_amount NUMBER := 0;
938: j NUMBER;
939: l_file utl_file.file_type;
940: l_file_dir VARCHAR2(500);
941: l_file_name VARCHAR2(3200);
942: l_text VARCHAR2(32000);
943: l_error_message VARCHAR2(3200);

Line 1183: l_file := utl_file.fopen( l_file_dir, l_file_name, 'w' , 32000);

1179: IF l_file_dir IS NOT NULL THEN
1180:
1181: l_file_name := 'ozfrsladi-'||p_batch_number||'.log';
1182: BEGIN
1183: l_file := utl_file.fopen( l_file_dir, l_file_name, 'w' , 32000);
1184: EXCEPTION
1185: WHEN UTL_FILE.INVALID_PATH THEN
1186: SELECT decode(instr(value,',',1,1), 0, value, substr(value,1,instr(value,',',1,1)-1))
1187: INTO l_file_dir

Line 1185: WHEN UTL_FILE.INVALID_PATH THEN

1181: l_file_name := 'ozfrsladi-'||p_batch_number||'.log';
1182: BEGIN
1183: l_file := utl_file.fopen( l_file_dir, l_file_name, 'w' , 32000);
1184: EXCEPTION
1185: WHEN UTL_FILE.INVALID_PATH THEN
1186: SELECT decode(instr(value,',',1,1), 0, value, substr(value,1,instr(value,',',1,1)-1))
1187: INTO l_file_dir
1188: FROM v$parameter
1189: WHERE name = 'utl_file_dir';

Line 1189: WHERE name = 'utl_file_dir';

1185: WHEN UTL_FILE.INVALID_PATH THEN
1186: SELECT decode(instr(value,',',1,1), 0, value, substr(value,1,instr(value,',',1,1)-1))
1187: INTO l_file_dir
1188: FROM v$parameter
1189: WHERE name = 'utl_file_dir';
1190: l_file := utl_file.fopen( l_file_dir, l_file_name, 'w' , 32000);
1191: END;
1192: END IF;
1193:

Line 1190: l_file := utl_file.fopen( l_file_dir, l_file_name, 'w' , 32000);

1186: SELECT decode(instr(value,',',1,1), 0, value, substr(value,1,instr(value,',',1,1)-1))
1187: INTO l_file_dir
1188: FROM v$parameter
1189: WHERE name = 'utl_file_dir';
1190: l_file := utl_file.fopen( l_file_dir, l_file_name, 'w' , 32000);
1191: END;
1192: END IF;
1193:
1194:

Line 1997: UTL_FILE.PUTF(l_file,l_text);

1993: END IF;
1994:
1995: OZF_UTILITY_PVT.debug_message('length of text '||length(l_text));
1996: OZF_UTILITY_PVT.debug_message('length of text '||length(substr(l_text,1001,1000)));
1997: UTL_FILE.PUTF(l_file,l_text);
1998: UTL_FILE.FCLOSE(l_file);
1999:
2000: EXCEPTION
2001: WHEN ozf_webadi_error THEN

Line 1998: UTL_FILE.FCLOSE(l_file);

1994:
1995: OZF_UTILITY_PVT.debug_message('length of text '||length(l_text));
1996: OZF_UTILITY_PVT.debug_message('length of text '||length(substr(l_text,1001,1000)));
1997: UTL_FILE.PUTF(l_file,l_text);
1998: UTL_FILE.FCLOSE(l_file);
1999:
2000: EXCEPTION
2001: WHEN ozf_webadi_error THEN
2002: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2004: WHEN UTL_FILE.INVALID_PATH THEN

2000: EXCEPTION
2001: WHEN ozf_webadi_error THEN
2002: x_return_status := FND_API.G_RET_STS_ERROR;
2003: raise_application_error( -20000, l_error_message);
2004: WHEN UTL_FILE.INVALID_PATH THEN
2005: RAISE_APPLICATION_ERROR(-20100,'Invalid Path');
2006: WHEN UTL_FILE.INVALID_MODE THEN
2007: RAISE_APPLICATION_ERROR(-20101,'Invalid Mode');
2008: WHEN UTL_FILE.INVALID_OPERATION then

Line 2006: WHEN UTL_FILE.INVALID_MODE THEN

2002: x_return_status := FND_API.G_RET_STS_ERROR;
2003: raise_application_error( -20000, l_error_message);
2004: WHEN UTL_FILE.INVALID_PATH THEN
2005: RAISE_APPLICATION_ERROR(-20100,'Invalid Path');
2006: WHEN UTL_FILE.INVALID_MODE THEN
2007: RAISE_APPLICATION_ERROR(-20101,'Invalid Mode');
2008: WHEN UTL_FILE.INVALID_OPERATION then
2009: RAISE_APPLICATION_ERROR(-20102,'Invalid Operation');
2010: WHEN UTL_FILE.INVALID_FILEHANDLE then

Line 2008: WHEN UTL_FILE.INVALID_OPERATION then

2004: WHEN UTL_FILE.INVALID_PATH THEN
2005: RAISE_APPLICATION_ERROR(-20100,'Invalid Path');
2006: WHEN UTL_FILE.INVALID_MODE THEN
2007: RAISE_APPLICATION_ERROR(-20101,'Invalid Mode');
2008: WHEN UTL_FILE.INVALID_OPERATION then
2009: RAISE_APPLICATION_ERROR(-20102,'Invalid Operation');
2010: WHEN UTL_FILE.INVALID_FILEHANDLE then
2011: RAISE_APPLICATION_ERROR(-20103,'Invalid Filehandle');
2012: WHEN UTL_FILE.WRITE_ERROR then

Line 2010: WHEN UTL_FILE.INVALID_FILEHANDLE then

2006: WHEN UTL_FILE.INVALID_MODE THEN
2007: RAISE_APPLICATION_ERROR(-20101,'Invalid Mode');
2008: WHEN UTL_FILE.INVALID_OPERATION then
2009: RAISE_APPLICATION_ERROR(-20102,'Invalid Operation');
2010: WHEN UTL_FILE.INVALID_FILEHANDLE then
2011: RAISE_APPLICATION_ERROR(-20103,'Invalid Filehandle');
2012: WHEN UTL_FILE.WRITE_ERROR then
2013: RAISE_APPLICATION_ERROR(-20104,'Write Error');
2014: WHEN UTL_FILE.READ_ERROR then

Line 2012: WHEN UTL_FILE.WRITE_ERROR then

2008: WHEN UTL_FILE.INVALID_OPERATION then
2009: RAISE_APPLICATION_ERROR(-20102,'Invalid Operation');
2010: WHEN UTL_FILE.INVALID_FILEHANDLE then
2011: RAISE_APPLICATION_ERROR(-20103,'Invalid Filehandle');
2012: WHEN UTL_FILE.WRITE_ERROR then
2013: RAISE_APPLICATION_ERROR(-20104,'Write Error');
2014: WHEN UTL_FILE.READ_ERROR then
2015: RAISE_APPLICATION_ERROR(-20105,'Read Error');
2016: WHEN UTL_FILE.INTERNAL_ERROR then

Line 2014: WHEN UTL_FILE.READ_ERROR then

2010: WHEN UTL_FILE.INVALID_FILEHANDLE then
2011: RAISE_APPLICATION_ERROR(-20103,'Invalid Filehandle');
2012: WHEN UTL_FILE.WRITE_ERROR then
2013: RAISE_APPLICATION_ERROR(-20104,'Write Error');
2014: WHEN UTL_FILE.READ_ERROR then
2015: RAISE_APPLICATION_ERROR(-20105,'Read Error');
2016: WHEN UTL_FILE.INTERNAL_ERROR then
2017: RAISE_APPLICATION_ERROR(-20106,'Internal Error');
2018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2016: WHEN UTL_FILE.INTERNAL_ERROR then

2012: WHEN UTL_FILE.WRITE_ERROR then
2013: RAISE_APPLICATION_ERROR(-20104,'Write Error');
2014: WHEN UTL_FILE.READ_ERROR then
2015: RAISE_APPLICATION_ERROR(-20105,'Read Error');
2016: WHEN UTL_FILE.INTERNAL_ERROR then
2017: RAISE_APPLICATION_ERROR(-20106,'Internal Error');
2018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2019: UTL_FILE.FCLOSE(l_file);
2020: -- Fix for Bug#10624065(+)

Line 2019: UTL_FILE.FCLOSE(l_file);

2015: RAISE_APPLICATION_ERROR(-20105,'Read Error');
2016: WHEN UTL_FILE.INTERNAL_ERROR then
2017: RAISE_APPLICATION_ERROR(-20106,'Internal Error');
2018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2019: UTL_FILE.FCLOSE(l_file);
2020: -- Fix for Bug#10624065(+)
2021: /*
2022: IF length( SQLERRM) > 30 THEN
2023: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));

Line 2032: UTL_FILE.FCLOSE(l_file);

2028: --END IF;
2029: -- Fix for Bug#10624065(-)
2030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2031: WHEN OTHERS THEN
2032: UTL_FILE.FCLOSE(l_file);
2033: -- Fix for Bug#10624065(+)
2034: /*
2035: IF length( SQLERRM) > 30 THEN
2036: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));