APPS.EDR_XDOC_UTIL_PKG dependencies on FND_LOG

Line 31: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

27: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
28: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
29: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_XDOC_UTIL_PKG');
30: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','DELETE_TEMP_PARAMS');
31: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
32: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
33: 'edr.plsql.EDR_XDOC_UTIL_PKG.DELETE_TEMP_PARAMS',
34: FALSE
35: );

Line 32: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

28: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
29: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_XDOC_UTIL_PKG');
30: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','DELETE_TEMP_PARAMS');
31: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
32: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
33: 'edr.plsql.EDR_XDOC_UTIL_PKG.DELETE_TEMP_PARAMS',
34: FALSE
35: );
36: end if;

Line 77: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

73: L_NLS_TERRITORY := FND_GLOBAL.NLS_TERRITORY;
74: L_CURRENT_LANG := USERENV('LANG');
75:
76: --We will log the NLS Parameters in the EVENT Level.
77: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
78: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
79: 'These are the NLS parameters for the e-record ID '||p_erecord_id);
80: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
81: 'NLS Date Format: '||L_NLS_DATE_FORMAT);

Line 78: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',

74: L_CURRENT_LANG := USERENV('LANG');
75:
76: --We will log the NLS Parameters in the EVENT Level.
77: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
78: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
79: 'These are the NLS parameters for the e-record ID '||p_erecord_id);
80: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
81: 'NLS Date Format: '||L_NLS_DATE_FORMAT);
82: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',

Line 80: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',

76: --We will log the NLS Parameters in the EVENT Level.
77: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
78: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
79: 'These are the NLS parameters for the e-record ID '||p_erecord_id);
80: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
81: 'NLS Date Format: '||L_NLS_DATE_FORMAT);
82: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
83: 'NLS Date Language: '||L_NLS_DATE_LANGUAGE);
84: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',

Line 82: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',

78: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
79: 'These are the NLS parameters for the e-record ID '||p_erecord_id);
80: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
81: 'NLS Date Format: '||L_NLS_DATE_FORMAT);
82: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
83: 'NLS Date Language: '||L_NLS_DATE_LANGUAGE);
84: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
85: 'NLS Language: '||L_NLS_LANGUAGE);
86: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',

Line 84: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',

80: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
81: 'NLS Date Format: '||L_NLS_DATE_FORMAT);
82: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
83: 'NLS Date Language: '||L_NLS_DATE_LANGUAGE);
84: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
85: 'NLS Language: '||L_NLS_LANGUAGE);
86: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
87: 'NLS Numeric Characters: '||L_NLS_NUMERIC_CHARACTERS);
88: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',

Line 86: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',

82: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
83: 'NLS Date Language: '||L_NLS_DATE_LANGUAGE);
84: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
85: 'NLS Language: '||L_NLS_LANGUAGE);
86: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
87: 'NLS Numeric Characters: '||L_NLS_NUMERIC_CHARACTERS);
88: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
89: 'NLS Sort: '||L_NLS_SORT);
90: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',

Line 88: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',

84: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
85: 'NLS Language: '||L_NLS_LANGUAGE);
86: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
87: 'NLS Numeric Characters: '||L_NLS_NUMERIC_CHARACTERS);
88: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
89: 'NLS Sort: '||L_NLS_SORT);
90: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
91: 'NLS Territory: '||L_NLS_TERRITORY);
92:

Line 90: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',

86: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
87: 'NLS Numeric Characters: '||L_NLS_NUMERIC_CHARACTERS);
88: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
89: 'NLS Sort: '||L_NLS_SORT);
90: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
91: 'NLS Territory: '||L_NLS_TERRITORY);
92:
93: end if;
94:

Line 237: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

233: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
234: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
235: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_XDOC_UTIL_PKG');
236: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','SET_TEMP_PARAMS');
237: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
238: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
239: 'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
240: FALSE
241: );

Line 238: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

234: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
235: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_XDOC_UTIL_PKG');
236: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','SET_TEMP_PARAMS');
237: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
238: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
239: 'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
240: FALSE
241: );
242: end if;

Line 314: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

310: l_src_req := GET_SERVICE_TICKET_STRING(EDR_CONSTANTS_GRP.g_service_name);
311:
312:
313: l_agent := FND_PROFILE.VALUE('APPS_JSP_AGENT');
314: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
315: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,
316: 'APPS JSP Agent is: '||l_agent);
317: end if;
318:

Line 315: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,

311:
312:
313: l_agent := FND_PROFILE.VALUE('APPS_JSP_AGENT');
314: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
315: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,
316: 'APPS JSP Agent is: '||l_agent);
317: end if;
318:
319: --Bug 5256904: Start

Line 336: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

332:
333: -- Call UTL_HTTP using EDR_XDOC_UTIL_PKG.REQUEST_HTTP package wrapper
334: l_http_response := EDR_XDOC_UTIL_PKG.REQUEST_HTTP( p_request_url => l_url);
335:
336: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
337: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,
338: 'HTTP Response from JSP: '||l_http_response);
339: end if;
340:

Line 337: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,

333: -- Call UTL_HTTP using EDR_XDOC_UTIL_PKG.REQUEST_HTTP package wrapper
334: l_http_response := EDR_XDOC_UTIL_PKG.REQUEST_HTTP( p_request_url => l_url);
335:
336: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
337: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,
338: 'HTTP Response from JSP: '||l_http_response);
339: end if;
340:
341: --Bug 5256904: Start

Line 357: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

353: l_http_response := substr(l_http_response,l_position+1);
354: l_position :=instr(l_http_response,';',1);
355: l_status := substr(l_http_response,1,l_position-1);
356:
357: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
358: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,
359: 'Status from JSP: '||l_status);
360: end if;
361:

Line 358: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,

354: l_position :=instr(l_http_response,';',1);
355: l_status := substr(l_http_response,1,l_position-1);
356:
357: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
358: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,
359: 'Status from JSP: '||l_status);
360: end if;
361:
362: l_position := instr(l_http_response,'=',1);

Line 373: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

369: l_position := instr(l_http_response,'=',1);
370: l_http_response := substr(l_http_response,l_position+1);
371: l_position :=instr(l_http_response,';',1);
372: x_error_msg := substr(l_http_response,1,l_position-1);
373: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
374: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,
375: 'Error message from JSP: '||x_error_msg);
376: end if;
377:

Line 374: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,

370: l_http_response := substr(l_http_response,l_position+1);
371: l_position :=instr(l_http_response,';',1);
372: x_error_msg := substr(l_http_response,1,l_position-1);
373: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
374: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,
375: 'Error message from JSP: '||x_error_msg);
376: end if;
377:
378: l_http_response := substr(l_http_response,l_position+1);

Line 385: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

381: l_position := instr(l_http_response,'=',1);
382: l_http_response := substr(l_http_response,l_position+1);
383: l_position :=instr(l_http_response,';',1);
384: x_output_format := substr(l_http_response,1,l_position-1);
385: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
386: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,
387: 'Output format from JSP: '||x_output_format);
388: end if;
389:

Line 386: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,

382: l_http_response := substr(l_http_response,l_position+1);
383: l_position :=instr(l_http_response,';',1);
384: x_output_format := substr(l_http_response,1,l_position-1);
385: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
386: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,
387: 'Output format from JSP: '||x_output_format);
388: end if;
389:
390: -- Bug 4731317 : end

Line 667: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

663: l_wallet := 'file:' || l_wallet;
664: utl_http.set_wallet(l_wallet);
665: end if;
666: -- Bug : 5170875 : start
667: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
668: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,
669: 'HTTP Request to JSP: '||p_request_url);
670: end if;
671: -- Bug : 5170875 : End

Line 668: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,

664: utl_http.set_wallet(l_wallet);
665: end if;
666: -- Bug : 5170875 : start
667: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
668: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,l_module_name,
669: 'HTTP Request to JSP: '||p_request_url);
670: end if;
671: -- Bug : 5170875 : End
672: l_http_response := utl_http.request( URL=> p_request_url);