APPS.ERROR_HANDLER dependencies on V$PARAMETER

Line 2192: l_utl_file_dir v$parameter.value%TYPE; --bug 16265816/16449758, fix ora-6502 error

2188: , x_error_mesg IN OUT NOCOPY VARCHAR2
2189: )
2190: IS
2191: l_found NUMBER := 0;
2192: l_utl_file_dir v$parameter.value%TYPE; --bug 16265816/16449758, fix ora-6502 error
2193: BEGIN
2194:
2195: x_return_status := FND_API.G_RET_STS_SUCCESS;
2196:

Line 2211: FROM v$parameter

2207: END IF;
2208: if G_HAS_UTL_FILE_DIR = 'N' then
2209: select value
2210: INTO l_utl_file_dir
2211: FROM v$parameter
2212: WHERE name = 'utl_file_dir';
2213: G_HAS_UTL_FILE_DIR := 'Y';
2214: G_UTL_FILE_DIR := l_utl_file_dir;
2215: else

Line 2226: ' value in v$parameter for name = utl_file_dir ';

2222: THEN
2223: x_error_mesg := 'Debug Session could not be started because the ' ||
2224: ' output directory name is invalid. ' ||
2225: ' Output directory must be one of the directory ' ||
2226: ' value in v$parameter for name = utl_file_dir ';
2227: x_return_status := FND_API.G_RET_STS_ERROR;
2228: Error_Handler.Set_Debug;
2229: RETURN;
2230: END IF;

Line 2261: l_utl_file_dir v$parameter.value%TYPE; --bug 16265816/16449758, fix ora-6502 error

2257: IS
2258: l_found NUMBER := 0;
2259: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type :=
2260: p_mesg_token_tbl;
2261: l_utl_file_dir v$parameter.value%TYPE; --bug 16265816/16449758, fix ora-6502 error
2262: BEGIN
2263:
2264: -- Enhancement
2265: -- If BO is called by Open interface don't call this code.

Line 2272: FROM v$parameter

2268: else
2269: if G_HAS_UTL_FILE_DIR = 'N' then
2270: select value
2271: INTO l_utl_file_dir
2272: FROM v$parameter
2273: WHERE name = 'utl_file_dir';
2274: G_HAS_UTL_FILE_DIR := 'Y';
2275: G_UTL_FILE_DIR := l_utl_file_dir;
2276: else

Line 2290: ' value in v$parameter for name = utl_file_dir ' ||

2286: , p_message_text =>
2287: ' Debug Session could not be started because the ' ||
2288: ' output directory name is invalid. ' ||
2289: ' Output directory must be one of the directory ' ||
2290: ' value in v$parameter for name = utl_file_dir ' ||
2291: ' If unsure leave out the value and the log will '||
2292: ' be written to /sqlcom/log '
2293: , x_mesg_token_tbl => l_mesg_token_tbl
2294: );