DBA Data[Home] [Help]

APPS.INL_LOGGING_PVT dependencies on FND_LOG

Line 76: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL AND LENGTH(p_debug_info)>0) THEN

72: p_procedure_name IN VARCHAR2,
73: p_debug_info IN VARCHAR2)
74: IS
75: BEGIN
76: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL AND LENGTH(p_debug_info)>0) THEN
77: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,p_module_name||' '||p_procedure_name,p_debug_info);
78: -- Write on concurrent log
79: Log_Concurrent(p_module_name => p_module_name,
80: p_procedure_name => p_procedure_name,

Line 77: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,p_module_name||' '||p_procedure_name,p_debug_info);

73: p_debug_info IN VARCHAR2)
74: IS
75: BEGIN
76: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL AND LENGTH(p_debug_info)>0) THEN
77: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,p_module_name||' '||p_procedure_name,p_debug_info);
78: -- Write on concurrent log
79: Log_Concurrent(p_module_name => p_module_name,
80: p_procedure_name => p_procedure_name,
81: p_debug_info => p_debug_info,

Line 111: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

107: IS
108: l_debug_info VARCHAR2(200);
109: BEGIN
110: l_debug_info := p_var_name||': ' ||p_var_value;
111: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
112: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,p_module_name||' '||p_procedure_name,l_debug_info);
113: -- Write on concurrent log
114: Log_Concurrent(p_module_name => p_module_name,
115: p_procedure_name => p_procedure_name,

Line 112: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,p_module_name||' '||p_procedure_name,l_debug_info);

108: l_debug_info VARCHAR2(200);
109: BEGIN
110: l_debug_info := p_var_name||': ' ||p_var_value;
111: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
112: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,p_module_name||' '||p_procedure_name,l_debug_info);
113: -- Write on concurrent log
114: Log_Concurrent(p_module_name => p_module_name,
115: p_procedure_name => p_procedure_name,
116: p_debug_info => NULL,

Line 140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

136: PROCEDURE Log_BeginProc (p_module_name IN VARCHAR2,
137: p_procedure_name IN VARCHAR2)
138: IS
139: BEGIN
140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
141: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,'BEGIN(+)');
142: -- Write on concurrent log
143: Log_Concurrent(p_module_name => p_module_name,
144: p_procedure_name => p_procedure_name,

Line 141: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,'BEGIN(+)');

137: p_procedure_name IN VARCHAR2)
138: IS
139: BEGIN
140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
141: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,'BEGIN(+)');
142: -- Write on concurrent log
143: Log_Concurrent(p_module_name => p_module_name,
144: p_procedure_name => p_procedure_name,
145: p_debug_info => 'BEGIN(+)',

Line 169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

165: PROCEDURE Log_EndProc (p_module_name IN VARCHAR2,
166: p_procedure_name IN VARCHAR2)
167: IS
168: BEGIN
169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,'END(-)');
171: -- Write on concurrent log
172: Log_Concurrent(p_module_name => p_module_name,
173: p_procedure_name => p_procedure_name,

Line 170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,'END(-)');

166: p_procedure_name IN VARCHAR2)
167: IS
168: BEGIN
169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,'END(-)');
171: -- Write on concurrent log
172: Log_Concurrent(p_module_name => p_module_name,
173: p_procedure_name => p_procedure_name,
174: p_debug_info => 'END(-)',

Line 240: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

236: p_in_param_name10 IN VARCHAR2 := NULL,
237: p_in_param_value10 IN VARCHAR2 := NULL)
238: IS
239: BEGIN
240: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
241: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,' Call to '||p_call_api_name);
242: IF (p_in_param_name1 IS NOT NULL OR p_in_param_value1 IS NOT NULL) THEN
243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name1||': '||p_in_param_value1);
244: -- Write on concurrent log

Line 241: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,' Call to '||p_call_api_name);

237: p_in_param_value10 IN VARCHAR2 := NULL)
238: IS
239: BEGIN
240: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
241: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,' Call to '||p_call_api_name);
242: IF (p_in_param_name1 IS NOT NULL OR p_in_param_value1 IS NOT NULL) THEN
243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name1||': '||p_in_param_value1);
244: -- Write on concurrent log
245: Log_Concurrent(p_module_name => p_module_name,

Line 243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name1||': '||p_in_param_value1);

239: BEGIN
240: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
241: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,' Call to '||p_call_api_name);
242: IF (p_in_param_name1 IS NOT NULL OR p_in_param_value1 IS NOT NULL) THEN
243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name1||': '||p_in_param_value1);
244: -- Write on concurrent log
245: Log_Concurrent(p_module_name => p_module_name,
246: p_procedure_name => p_procedure_name,
247: p_debug_info => NULL,

Line 254: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name2||': '||p_in_param_value2);

250: p_var_value => p_in_param_value1,
251: p_debug_type => 3);
252: END IF;
253: IF (p_in_param_name2 IS NOT NULL OR p_in_param_value2 IS NOT NULL) THEN
254: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name2||': '||p_in_param_value2);
255: -- Write on concurrent log
256: Log_Concurrent(p_module_name => p_module_name,
257: p_procedure_name => p_procedure_name,
258: p_debug_info => NULL,

Line 265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name3||': '||p_in_param_value3);

261: p_var_value => p_in_param_value2,
262: p_debug_type => 3);
263: END IF;
264: IF (p_in_param_name3 IS NOT NULL OR p_in_param_value3 IS NOT NULL) THEN
265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name3||': '||p_in_param_value3);
266: -- Write on concurrent log
267: Log_Concurrent(p_module_name => p_module_name,
268: p_procedure_name => p_procedure_name,
269: p_debug_info => NULL,

Line 276: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name4||': '||p_in_param_value4);

272: p_var_value => p_in_param_value3,
273: p_debug_type => 3);
274: END IF;
275: IF (p_in_param_name4 IS NOT NULL OR p_in_param_value4 IS NOT NULL) THEN
276: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name4||': '||p_in_param_value4);
277: -- Write on concurrent log
278: Log_Concurrent(p_module_name => p_module_name,
279: p_procedure_name => p_procedure_name,
280: p_debug_info => NULL,

Line 287: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name5||': '||p_in_param_value5);

283: p_var_value => p_in_param_value4,
284: p_debug_type => 3);
285: END IF;
286: IF (p_in_param_name5 IS NOT NULL OR p_in_param_value5 IS NOT NULL) THEN
287: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name5||': '||p_in_param_value5);
288: -- Write on concurrent log
289: Log_Concurrent(p_module_name => p_module_name,
290: p_procedure_name => p_procedure_name,
291: p_debug_info => NULL,

Line 298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name6||': '||p_in_param_value6);

294: p_var_value => p_in_param_value5,
295: p_debug_type => 3);
296: END IF;
297: IF (p_in_param_name6 IS NOT NULL OR p_in_param_value6 IS NOT NULL) THEN
298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name6||': '||p_in_param_value6);
299: -- Write on concurrent log
300: Log_Concurrent(p_module_name => p_module_name,
301: p_procedure_name => p_procedure_name,
302: p_debug_info => NULL,

Line 309: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name7||': '||p_in_param_value7);

305: p_var_value => p_in_param_value6,
306: p_debug_type => 3);
307: END IF;
308: IF (p_in_param_name7 IS NOT NULL OR p_in_param_value7 IS NOT NULL) THEN
309: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name7||': '||p_in_param_value7);
310: -- Write on concurrent log
311: Log_Concurrent(p_module_name => p_module_name,
312: p_procedure_name => p_procedure_name,
313: p_debug_info => NULL,

Line 320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name8||': '||p_in_param_value8);

316: p_var_value => p_in_param_value7,
317: p_debug_type => 3);
318: END IF;
319: IF (p_in_param_name8 IS NOT NULL OR p_in_param_value8 IS NOT NULL) THEN
320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name8||': '||p_in_param_value8);
321: -- Write on concurrent log
322: Log_Concurrent(p_module_name => p_module_name,
323: p_procedure_name => p_procedure_name,
324: p_debug_info => NULL,

Line 331: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name9||': '||p_in_param_value9);

327: p_var_value => p_in_param_value8,
328: p_debug_type => 3);
329: END IF;
330: IF (p_in_param_name9 IS NOT NULL OR p_in_param_value9 IS NOT NULL) THEN
331: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name9||': '||p_in_param_value9);
332: -- Write on concurrent log
333: Log_Concurrent(p_module_name => p_module_name,
334: p_procedure_name => p_procedure_name,
335: p_debug_info => NULL,

Line 342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name10||': '||p_in_param_value10);

338: p_var_value => p_in_param_value9,
339: p_debug_type => 3);
340: END IF;
341: IF (p_in_param_name10 IS NOT NULL OR p_in_param_value10 IS NOT NULL) THEN
342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name10||': '||p_in_param_value10);
343: -- Write on concurrent log
344: Log_Concurrent(p_module_name => p_module_name,
345: p_procedure_name => p_procedure_name,
346: p_debug_info => NULL,

Line 413: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

409: p_out_param_name10 IN VARCHAR2 := NULL,
410: p_out_param_value10 IN VARCHAR2 := NULL)
411: IS
412: BEGIN
413: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
414: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,' Returning from '||p_call_api_name);
415: IF (p_out_param_name1 IS NOT NULL OR p_out_param_value1 IS NOT NULL) THEN
416: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name1||': '||p_out_param_value1);
417: -- Write on concurrent log

Line 414: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,' Returning from '||p_call_api_name);

410: p_out_param_value10 IN VARCHAR2 := NULL)
411: IS
412: BEGIN
413: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
414: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,' Returning from '||p_call_api_name);
415: IF (p_out_param_name1 IS NOT NULL OR p_out_param_value1 IS NOT NULL) THEN
416: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name1||': '||p_out_param_value1);
417: -- Write on concurrent log
418: Log_Concurrent(p_module_name => p_module_name,

Line 416: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name1||': '||p_out_param_value1);

412: BEGIN
413: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
414: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,' Returning from '||p_call_api_name);
415: IF (p_out_param_name1 IS NOT NULL OR p_out_param_value1 IS NOT NULL) THEN
416: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name1||': '||p_out_param_value1);
417: -- Write on concurrent log
418: Log_Concurrent(p_module_name => p_module_name,
419: p_procedure_name => p_procedure_name,
420: p_debug_info => NULL,

Line 427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name2||': '||p_out_param_value2);

423: p_var_value => p_out_param_value1,
424: p_debug_type => 4);
425: END IF;
426: IF (p_out_param_name2 IS NOT NULL OR p_out_param_value2 IS NOT NULL) THEN
427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name2||': '||p_out_param_value2);
428: -- Write on concurrent log
429: Log_Concurrent(p_module_name => p_module_name,
430: p_procedure_name => p_procedure_name,
431: p_debug_info => NULL,

Line 439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name3||': '||p_out_param_value3);

435: p_debug_type => 4);
436:
437: END IF;
438: IF (p_out_param_name3 IS NOT NULL OR p_out_param_value3 IS NOT NULL) THEN
439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name3||': '||p_out_param_value3);
440: -- Write on concurrent log
441: Log_Concurrent(p_module_name => p_module_name,
442: p_procedure_name => p_procedure_name,
443: p_debug_info => NULL,

Line 451: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name4||': '||p_out_param_value4);

447: p_debug_type => 4);
448:
449: END IF;
450: IF (p_out_param_name4 IS NOT NULL OR p_out_param_value4 IS NOT NULL) THEN
451: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name4||': '||p_out_param_value4);
452: -- Write on concurrent log
453: Log_Concurrent(p_module_name => p_module_name,
454: p_procedure_name => p_procedure_name,
455: p_debug_info => NULL,

Line 463: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name5||': '||p_out_param_value5);

459: p_debug_type => 4);
460:
461: END IF;
462: IF (p_out_param_name5 IS NOT NULL OR p_out_param_value5 IS NOT NULL) THEN
463: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name5||': '||p_out_param_value5);
464: -- Write on concurrent log
465: Log_Concurrent(p_module_name => p_module_name,
466: p_procedure_name => p_procedure_name,
467: p_debug_info => NULL,

Line 474: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name6||': '||p_out_param_value6);

470: p_var_value => p_out_param_value5,
471: p_debug_type => 4);
472: END IF;
473: IF (p_out_param_name6 IS NOT NULL OR p_out_param_value6 IS NOT NULL) THEN
474: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name6||': '||p_out_param_value6);
475: -- Write on concurrent log
476: Log_Concurrent(p_module_name => p_module_name,
477: p_procedure_name => p_procedure_name,
478: p_debug_info => NULL,

Line 485: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name7||': '||p_out_param_value7);

481: p_var_value => p_out_param_value6,
482: p_debug_type => 4);
483: END IF;
484: IF (p_out_param_name7 IS NOT NULL OR p_out_param_value7 IS NOT NULL) THEN
485: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name7||': '||p_out_param_value7);
486: -- Write on concurrent log
487: Log_Concurrent(p_module_name => p_module_name,
488: p_procedure_name => p_procedure_name,
489: p_debug_info => NULL,

Line 496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name8||': '||p_out_param_value8);

492: p_var_value => p_out_param_value7,
493: p_debug_type => 4);
494: END IF;
495: IF (p_out_param_name8 IS NOT NULL OR p_out_param_value8 IS NOT NULL) THEN
496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name8||': '||p_out_param_value8);
497: -- Write on concurrent log
498: Log_Concurrent(p_module_name => p_module_name,
499: p_procedure_name => p_procedure_name,
500: p_debug_info => NULL,

Line 508: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name9||': '||p_out_param_value9);

504: p_debug_type => 4);
505:
506: END IF;
507: IF (p_out_param_name9 IS NOT NULL OR p_out_param_value9 IS NOT NULL) THEN
508: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name9||': '||p_out_param_value9);
509: -- Write on concurrent log
510: Log_Concurrent(p_module_name => p_module_name,
511: p_procedure_name => p_procedure_name,
512: p_debug_info => NULL,

Line 519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name10||': '||p_out_param_value10);

515: p_var_value => p_out_param_value9,
516: p_debug_type => 4);
517: END IF;
518: IF (p_out_param_name10 IS NOT NULL OR p_out_param_value10 IS NOT NULL) THEN
519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name10||': '||p_out_param_value10);
520: -- Write on concurrent log
521: Log_Concurrent(p_module_name => p_module_name,
522: p_procedure_name => p_procedure_name,
523: p_debug_info => NULL,

Line 551: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL AND LENGTH(p_debug_info)>0) THEN

547: p_procedure_name IN VARCHAR2,
548: p_debug_info IN VARCHAR2)
549: IS
550: BEGIN
551: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL AND LENGTH(p_debug_info)>0) THEN
552: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,p_module_name||' '||p_procedure_name,p_debug_info);
553: -- Write on concurrent log
554: Log_Concurrent(p_module_name => p_module_name,
555: p_procedure_name => p_procedure_name,

Line 552: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,p_module_name||' '||p_procedure_name,p_debug_info);

548: p_debug_info IN VARCHAR2)
549: IS
550: BEGIN
551: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL AND LENGTH(p_debug_info)>0) THEN
552: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,p_module_name||' '||p_procedure_name,p_debug_info);
553: -- Write on concurrent log
554: Log_Concurrent(p_module_name => p_module_name,
555: p_procedure_name => p_procedure_name,
556: p_debug_info => p_debug_info,

Line 580: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

576: PROCEDURE Log_Exception (p_module_name IN VARCHAR2,
577: p_procedure_name IN VARCHAR2)
578: IS
579: BEGIN
580: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
581: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,p_module_name||' '||p_procedure_name,SQLERRM);
582: -- Write on concurrent log
583: Log_Concurrent(p_module_name => p_module_name,
584: p_procedure_name => p_procedure_name,

Line 581: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,p_module_name||' '||p_procedure_name,SQLERRM);

577: p_procedure_name IN VARCHAR2)
578: IS
579: BEGIN
580: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
581: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,p_module_name||' '||p_procedure_name,SQLERRM);
582: -- Write on concurrent log
583: Log_Concurrent(p_module_name => p_module_name,
584: p_procedure_name => p_procedure_name,
585: p_debug_info => SQLERRM,

Line 611: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

607: p_procedure_name IN VARCHAR2,
608: p_debug_info IN VARCHAR2 := NULL)
609: IS
610: BEGIN
611: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
612: IF p_debug_info IS NOT NULL THEN
613: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,p_module_name||' '||p_procedure_name,p_debug_info);
614: ELSE
615: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,p_module_name||' '||p_procedure_name,SQLERRM);

Line 613: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,p_module_name||' '||p_procedure_name,p_debug_info);

609: IS
610: BEGIN
611: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
612: IF p_debug_info IS NOT NULL THEN
613: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,p_module_name||' '||p_procedure_name,p_debug_info);
614: ELSE
615: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,p_module_name||' '||p_procedure_name,SQLERRM);
616: END IF;
617: -- Write on concurrent log

Line 615: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,p_module_name||' '||p_procedure_name,SQLERRM);

611: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
612: IF p_debug_info IS NOT NULL THEN
613: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,p_module_name||' '||p_procedure_name,p_debug_info);
614: ELSE
615: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,p_module_name||' '||p_procedure_name,SQLERRM);
616: END IF;
617: -- Write on concurrent log
618: Log_Concurrent(p_module_name => p_module_name,
619: p_procedure_name => p_procedure_name,

Line 644: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

640: PROCEDURE Log_UnexpecError (p_module_name IN VARCHAR2,
641: p_procedure_name IN VARCHAR2)
642: IS
643: BEGIN
644: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,p_module_name||' '||p_procedure_name,SQLERRM);
646: -- Write on concurrent log
647: Log_Concurrent(p_module_name => p_module_name,
648: p_procedure_name => p_procedure_name,

Line 645: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,p_module_name||' '||p_procedure_name,SQLERRM);

641: p_procedure_name IN VARCHAR2)
642: IS
643: BEGIN
644: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,p_module_name||' '||p_procedure_name,SQLERRM);
646: -- Write on concurrent log
647: Log_Concurrent(p_module_name => p_module_name,
648: p_procedure_name => p_procedure_name,
649: p_debug_info => SQLERRM,