DBA Data[Home] [Help]

APPS.INL_LOGGING_PVT dependencies on FND_LOG

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

18: p_procedure_name IN VARCHAR2,
19: p_debug_info IN VARCHAR2)
20: IS
21: BEGIN
22: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL AND LENGTH(p_debug_info)>0) THEN
23: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,p_module_name||' '||p_procedure_name,p_debug_info);
24: END IF;
25: END Log_Statement;
26:

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

19: p_debug_info IN VARCHAR2)
20: IS
21: BEGIN
22: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL AND LENGTH(p_debug_info)>0) THEN
23: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,p_module_name||' '||p_procedure_name,p_debug_info);
24: END IF;
25: END Log_Statement;
26:
27: -- API name : Log_Variable

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

45: IS
46: l_debug_info VARCHAR2(200);
47: BEGIN
48: l_debug_info := p_var_name||': ' ||p_var_value;
49: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
50: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,p_module_name||' '||p_procedure_name,l_debug_info);
51: END IF;
52: END Log_Variable;
53:

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

46: l_debug_info VARCHAR2(200);
47: BEGIN
48: l_debug_info := p_var_name||': ' ||p_var_value;
49: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
50: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,p_module_name||' '||p_procedure_name,l_debug_info);
51: END IF;
52: END Log_Variable;
53:
54: -- API name : Log_BeginProc

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

66: PROCEDURE Log_BeginProc (p_module_name IN VARCHAR2,
67: p_procedure_name IN VARCHAR2)
68: IS
69: BEGIN
70: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
71: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,'BEGIN(+)');
72: END IF;
73: END Log_BeginProc;
74:

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

67: p_procedure_name IN VARCHAR2)
68: IS
69: BEGIN
70: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
71: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,'BEGIN(+)');
72: END IF;
73: END Log_BeginProc;
74:
75: -- API name : Log_EndProc

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

87: PROCEDURE Log_EndProc (p_module_name IN VARCHAR2,
88: p_procedure_name IN VARCHAR2)
89: IS
90: BEGIN
91: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
92: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,'END(-)');
93: END IF;
94: END Log_EndProc;
95:

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

88: p_procedure_name IN VARCHAR2)
89: IS
90: BEGIN
91: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
92: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,'END(-)');
93: END IF;
94: END Log_EndProc;
95:
96: -- API name : Log_APICallIn

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

150: p_in_param_name10 IN VARCHAR2 := NULL,
151: p_in_param_value10 IN VARCHAR2 := NULL)
152: IS
153: BEGIN
154: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
155: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,' Call to '||p_call_api_name);
156: IF (p_in_param_name1 IS NOT NULL OR p_in_param_value1 IS NOT NULL) THEN
157: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name1||': '||p_in_param_value1);
158: END IF;

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

151: p_in_param_value10 IN VARCHAR2 := NULL)
152: IS
153: BEGIN
154: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
155: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,' Call to '||p_call_api_name);
156: IF (p_in_param_name1 IS NOT NULL OR p_in_param_value1 IS NOT NULL) THEN
157: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name1||': '||p_in_param_value1);
158: END IF;
159: IF (p_in_param_name2 IS NOT NULL OR p_in_param_value2 IS NOT NULL) THEN

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

153: BEGIN
154: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
155: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,' Call to '||p_call_api_name);
156: IF (p_in_param_name1 IS NOT NULL OR p_in_param_value1 IS NOT NULL) THEN
157: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name1||': '||p_in_param_value1);
158: END IF;
159: IF (p_in_param_name2 IS NOT NULL OR p_in_param_value2 IS NOT NULL) THEN
160: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name2||': '||p_in_param_value2);
161: END IF;

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

156: IF (p_in_param_name1 IS NOT NULL OR p_in_param_value1 IS NOT NULL) THEN
157: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name1||': '||p_in_param_value1);
158: END IF;
159: IF (p_in_param_name2 IS NOT NULL OR p_in_param_value2 IS NOT NULL) THEN
160: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name2||': '||p_in_param_value2);
161: END IF;
162: IF (p_in_param_name3 IS NOT NULL OR p_in_param_value3 IS NOT NULL) THEN
163: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name3||': '||p_in_param_value3);
164: END IF;

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

159: IF (p_in_param_name2 IS NOT NULL OR p_in_param_value2 IS NOT NULL) THEN
160: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name2||': '||p_in_param_value2);
161: END IF;
162: IF (p_in_param_name3 IS NOT NULL OR p_in_param_value3 IS NOT NULL) THEN
163: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name3||': '||p_in_param_value3);
164: END IF;
165: IF (p_in_param_name4 IS NOT NULL OR p_in_param_value4 IS NOT NULL) THEN
166: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name4||': '||p_in_param_value4);
167: END IF;

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

162: IF (p_in_param_name3 IS NOT NULL OR p_in_param_value3 IS NOT NULL) THEN
163: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name3||': '||p_in_param_value3);
164: END IF;
165: IF (p_in_param_name4 IS NOT NULL OR p_in_param_value4 IS NOT NULL) THEN
166: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name4||': '||p_in_param_value4);
167: END IF;
168: IF (p_in_param_name5 IS NOT NULL OR p_in_param_value5 IS NOT NULL) THEN
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name5||': '||p_in_param_value5);
170: END IF;

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

165: IF (p_in_param_name4 IS NOT NULL OR p_in_param_value4 IS NOT NULL) THEN
166: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name4||': '||p_in_param_value4);
167: END IF;
168: IF (p_in_param_name5 IS NOT NULL OR p_in_param_value5 IS NOT NULL) THEN
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name5||': '||p_in_param_value5);
170: END IF;
171: IF (p_in_param_name6 IS NOT NULL OR p_in_param_value6 IS NOT NULL) THEN
172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name6||': '||p_in_param_value6);
173: END IF;

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

168: IF (p_in_param_name5 IS NOT NULL OR p_in_param_value5 IS NOT NULL) THEN
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name5||': '||p_in_param_value5);
170: END IF;
171: IF (p_in_param_name6 IS NOT NULL OR p_in_param_value6 IS NOT NULL) THEN
172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name6||': '||p_in_param_value6);
173: END IF;
174: IF (p_in_param_name7 IS NOT NULL OR p_in_param_value7 IS NOT NULL) THEN
175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name7||': '||p_in_param_value7);
176: END IF;

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

171: IF (p_in_param_name6 IS NOT NULL OR p_in_param_value6 IS NOT NULL) THEN
172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name6||': '||p_in_param_value6);
173: END IF;
174: IF (p_in_param_name7 IS NOT NULL OR p_in_param_value7 IS NOT NULL) THEN
175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name7||': '||p_in_param_value7);
176: END IF;
177: IF (p_in_param_name8 IS NOT NULL OR p_in_param_value8 IS NOT NULL) THEN
178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name8||': '||p_in_param_value8);
179: END IF;

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

174: IF (p_in_param_name7 IS NOT NULL OR p_in_param_value7 IS NOT NULL) THEN
175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name7||': '||p_in_param_value7);
176: END IF;
177: IF (p_in_param_name8 IS NOT NULL OR p_in_param_value8 IS NOT NULL) THEN
178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name8||': '||p_in_param_value8);
179: END IF;
180: IF (p_in_param_name9 IS NOT NULL OR p_in_param_value9 IS NOT NULL) THEN
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name9||': '||p_in_param_value9);
182: END IF;

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

177: IF (p_in_param_name8 IS NOT NULL OR p_in_param_value8 IS NOT NULL) THEN
178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name8||': '||p_in_param_value8);
179: END IF;
180: IF (p_in_param_name9 IS NOT NULL OR p_in_param_value9 IS NOT NULL) THEN
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name9||': '||p_in_param_value9);
182: END IF;
183: IF (p_in_param_name10 IS NOT NULL OR p_in_param_value10 IS NOT NULL) THEN
184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name10||': '||p_in_param_value10);
185: END IF;

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

180: IF (p_in_param_name9 IS NOT NULL OR p_in_param_value9 IS NOT NULL) THEN
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name9||': '||p_in_param_value9);
182: END IF;
183: IF (p_in_param_name10 IS NOT NULL OR p_in_param_value10 IS NOT NULL) THEN
184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_in_param_name10||': '||p_in_param_value10);
185: END IF;
186: END IF;
187: END Log_APICallIn;
188:

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

243: p_out_param_name10 IN VARCHAR2 := NULL,
244: p_out_param_value10 IN VARCHAR2 := NULL)
245: IS
246: BEGIN
247: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
248: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,' Returning from '||p_call_api_name);
249: IF (p_out_param_name1 IS NOT NULL OR p_out_param_value1 IS NOT NULL) THEN
250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name1||': '||p_out_param_value1);
251: END IF;

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

244: p_out_param_value10 IN VARCHAR2 := NULL)
245: IS
246: BEGIN
247: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
248: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,' Returning from '||p_call_api_name);
249: IF (p_out_param_name1 IS NOT NULL OR p_out_param_value1 IS NOT NULL) THEN
250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name1||': '||p_out_param_value1);
251: END IF;
252: IF (p_out_param_name2 IS NOT NULL OR p_out_param_value2 IS NOT NULL) THEN

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

246: BEGIN
247: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
248: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,' Returning from '||p_call_api_name);
249: IF (p_out_param_name1 IS NOT NULL OR p_out_param_value1 IS NOT NULL) THEN
250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name1||': '||p_out_param_value1);
251: END IF;
252: IF (p_out_param_name2 IS NOT NULL OR p_out_param_value2 IS NOT NULL) THEN
253: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name2||': '||p_out_param_value2);
254: END IF;

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

249: IF (p_out_param_name1 IS NOT NULL OR p_out_param_value1 IS NOT NULL) THEN
250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name1||': '||p_out_param_value1);
251: END IF;
252: IF (p_out_param_name2 IS NOT NULL OR p_out_param_value2 IS NOT NULL) THEN
253: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name2||': '||p_out_param_value2);
254: END IF;
255: IF (p_out_param_name3 IS NOT NULL OR p_out_param_value3 IS NOT NULL) THEN
256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name3||': '||p_out_param_value3);
257: END IF;

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

252: IF (p_out_param_name2 IS NOT NULL OR p_out_param_value2 IS NOT NULL) THEN
253: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name2||': '||p_out_param_value2);
254: END IF;
255: IF (p_out_param_name3 IS NOT NULL OR p_out_param_value3 IS NOT NULL) THEN
256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name3||': '||p_out_param_value3);
257: END IF;
258: IF (p_out_param_name4 IS NOT NULL OR p_out_param_value4 IS NOT NULL) THEN
259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name4||': '||p_out_param_value4);
260: END IF;

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

255: IF (p_out_param_name3 IS NOT NULL OR p_out_param_value3 IS NOT NULL) THEN
256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name3||': '||p_out_param_value3);
257: END IF;
258: IF (p_out_param_name4 IS NOT NULL OR p_out_param_value4 IS NOT NULL) THEN
259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name4||': '||p_out_param_value4);
260: END IF;
261: IF (p_out_param_name5 IS NOT NULL OR p_out_param_value5 IS NOT NULL) THEN
262: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name5||': '||p_out_param_value5);
263: END IF;

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

258: IF (p_out_param_name4 IS NOT NULL OR p_out_param_value4 IS NOT NULL) THEN
259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name4||': '||p_out_param_value4);
260: END IF;
261: IF (p_out_param_name5 IS NOT NULL OR p_out_param_value5 IS NOT NULL) THEN
262: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name5||': '||p_out_param_value5);
263: END IF;
264: IF (p_out_param_name6 IS NOT NULL OR p_out_param_value6 IS NOT NULL) THEN
265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name6||': '||p_out_param_value6);
266: END IF;

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

261: IF (p_out_param_name5 IS NOT NULL OR p_out_param_value5 IS NOT NULL) THEN
262: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name5||': '||p_out_param_value5);
263: END IF;
264: IF (p_out_param_name6 IS NOT NULL OR p_out_param_value6 IS NOT NULL) THEN
265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name6||': '||p_out_param_value6);
266: END IF;
267: IF (p_out_param_name7 IS NOT NULL OR p_out_param_value7 IS NOT NULL) THEN
268: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name7||': '||p_out_param_value7);
269: END IF;

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

264: IF (p_out_param_name6 IS NOT NULL OR p_out_param_value6 IS NOT NULL) THEN
265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name6||': '||p_out_param_value6);
266: END IF;
267: IF (p_out_param_name7 IS NOT NULL OR p_out_param_value7 IS NOT NULL) THEN
268: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name7||': '||p_out_param_value7);
269: END IF;
270: IF (p_out_param_name8 IS NOT NULL OR p_out_param_value8 IS NOT NULL) THEN
271: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name8||': '||p_out_param_value8);
272: END IF;

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

267: IF (p_out_param_name7 IS NOT NULL OR p_out_param_value7 IS NOT NULL) THEN
268: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name7||': '||p_out_param_value7);
269: END IF;
270: IF (p_out_param_name8 IS NOT NULL OR p_out_param_value8 IS NOT NULL) THEN
271: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name8||': '||p_out_param_value8);
272: END IF;
273: IF (p_out_param_name9 IS NOT NULL OR p_out_param_value9 IS NOT NULL) THEN
274: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name9||': '||p_out_param_value9);
275: END IF;

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

270: IF (p_out_param_name8 IS NOT NULL OR p_out_param_value8 IS NOT NULL) THEN
271: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name8||': '||p_out_param_value8);
272: END IF;
273: IF (p_out_param_name9 IS NOT NULL OR p_out_param_value9 IS NOT NULL) THEN
274: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name9||': '||p_out_param_value9);
275: END IF;
276: IF (p_out_param_name10 IS NOT NULL OR p_out_param_value10 IS NOT NULL) THEN
277: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name10||': '||p_out_param_value10);
278: END IF;

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

273: IF (p_out_param_name9 IS NOT NULL OR p_out_param_value9 IS NOT NULL) THEN
274: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name9||': '||p_out_param_value9);
275: END IF;
276: IF (p_out_param_name10 IS NOT NULL OR p_out_param_value10 IS NOT NULL) THEN
277: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,p_module_name||' '||p_procedure_name,p_out_param_name10||': '||p_out_param_value10);
278: END IF;
279: END IF;
280: END Log_APICallOut;
281:

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

297: p_procedure_name IN VARCHAR2,
298: p_debug_info IN VARCHAR2)
299: IS
300: BEGIN
301: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL AND LENGTH(p_debug_info)>0) THEN
302: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,p_module_name||' '||p_procedure_name,p_debug_info);
303: END IF;
304: END Log_Event;
305:

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

298: p_debug_info IN VARCHAR2)
299: IS
300: BEGIN
301: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL AND LENGTH(p_debug_info)>0) THEN
302: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,p_module_name||' '||p_procedure_name,p_debug_info);
303: END IF;
304: END Log_Event;
305:
306: -- API name : Log_Exception

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

318: PROCEDURE Log_Exception (p_module_name IN VARCHAR2,
319: p_procedure_name IN VARCHAR2)
320: IS
321: BEGIN
322: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
323: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,p_module_name||' '||p_procedure_name,SQLERRM);
324: END IF;
325: END Log_Exception;
326:

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

319: p_procedure_name IN VARCHAR2)
320: IS
321: BEGIN
322: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
323: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,p_module_name||' '||p_procedure_name,SQLERRM);
324: END IF;
325: END Log_Exception;
326:
327: -- API name : Log_ExpecError

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

341: p_procedure_name IN VARCHAR2,
342: p_debug_info IN VARCHAR2 := NULL)
343: IS
344: BEGIN
345: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
346: IF p_debug_info IS NOT NULL THEN
347: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,p_module_name||' '||p_procedure_name,p_debug_info);
348: ELSE
349: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,p_module_name||' '||p_procedure_name,SQLERRM);

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

343: IS
344: BEGIN
345: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
346: IF p_debug_info IS NOT NULL THEN
347: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,p_module_name||' '||p_procedure_name,p_debug_info);
348: ELSE
349: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,p_module_name||' '||p_procedure_name,SQLERRM);
350: END IF;
351: END IF;

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

345: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
346: IF p_debug_info IS NOT NULL THEN
347: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,p_module_name||' '||p_procedure_name,p_debug_info);
348: ELSE
349: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,p_module_name||' '||p_procedure_name,SQLERRM);
350: END IF;
351: END IF;
352: END Log_ExpecError;
353:

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

366: PROCEDURE Log_UnexpecError (p_module_name IN VARCHAR2,
367: p_procedure_name IN VARCHAR2)
368: IS
369: BEGIN
370: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,p_module_name||' '||p_procedure_name,SQLERRM);
372: END IF;
373: END Log_UnexpecError;
374:

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

367: p_procedure_name IN VARCHAR2)
368: IS
369: BEGIN
370: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,p_module_name||' '||p_procedure_name,SQLERRM);
372: END IF;
373: END Log_UnexpecError;
374:
375: END INL_LOGGING_PVT;