DBA Data[Home] [Help]

APPS.OKL_ECC_DEF_PVT dependencies on FND_LOG

Line 131: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_ECC_DEF_PVT.CREATE_ECC';

127: lx_eccv_rec okl_eccv_rec;
128: lp_eco_tbl okl_eco_tbl;
129: lx_eco_tbl okl_eco_tbl;
130: i number;
131: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_ECC_DEF_PVT.CREATE_ECC';
132: l_debug_enabled varchar2(10);
133: is_debug_procedure_on boolean;
134: is_debug_statement_on boolean;
135: l_api_name CONSTANT varchar2(30) := 'create_ecc';

Line 142: ,fnd_log.level_procedure);

138:
139: BEGIN
140: l_debug_enabled := okl_debug_pub.check_log_enabled;
141: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
142: ,fnd_log.level_procedure);
143:
144: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
145: okl_debug_pub.log_debug(fnd_log.level_procedure
146: ,l_module

Line 145: okl_debug_pub.log_debug(fnd_log.level_procedure

141: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
142: ,fnd_log.level_procedure);
143:
144: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
145: okl_debug_pub.log_debug(fnd_log.level_procedure
146: ,l_module
147: ,'begin debug OKLRECCB.pls call create_ecc');
148: END IF;
149: -- check for logging on STATEMENT level

Line 151: ,fnd_log.level_statement);

147: ,'begin debug OKLRECCB.pls call create_ecc');
148: END IF;
149: -- check for logging on STATEMENT level
150: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
151: ,fnd_log.level_statement);
152:
153: -- call START_ACTIVITY to create savepoint, check compatibility
154: -- and initialize message list
155:

Line 174: okl_debug_pub.log_debug(fnd_log.level_statement

170: lp_eco_tbl := p_eco_tbl; --validate header
171: l_return_status := validate_header(lp_eccv_rec); -- write to log
172:
173: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
174: okl_debug_pub.log_debug(fnd_log.level_statement
175: ,l_module
176: ,'Function okl_ecc_def_pvt.validate_header returned with status ' ||
177: l_return_status);
178: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 198: okl_debug_pub.log_debug(fnd_log.level_statement

194: ,lp_eccv_rec
195: ,lx_eccv_rec); -- write to log
196:
197: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
198: okl_debug_pub.log_debug(fnd_log.level_statement
199: ,l_module
200: ,'okl_ecc_pvt.insert_row returned with status ' ||
201: l_return_status ||
202: ' x_msg_data ' ||

Line 226: okl_debug_pub.log_debug(fnd_log.level_statement

222: ,x_msg_data
223: ,lp_eco_tbl
224: ,lx_eco_tbl); -- write to log
225: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
226: okl_debug_pub.log_debug(fnd_log.level_statement
227: ,l_module
228: ,'okl_eco_pvt.insert_row returned with status ' ||
229: l_return_status ||
230: ' x_msg_data ' ||

Line 246: okl_debug_pub.log_debug(fnd_log.level_procedure

242: okl_api.end_activity(x_msg_count => x_msg_count
243: ,x_msg_data => x_msg_data);
244:
245: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
246: okl_debug_pub.log_debug(fnd_log.level_procedure
247: ,l_module
248: ,'end debug OKLRECCB.pls call create_ecc');
249: END IF;
250:

Line 294: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_ECC_DEF_PVT.UPDATE_ECC';

290: lx_eco_tbl okl_eco_tbl;
291: i number;
292: j number;
293: l number;
294: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_ECC_DEF_PVT.UPDATE_ECC';
295: l_debug_enabled varchar2(10);
296: is_debug_procedure_on boolean;
297: is_debug_statement_on boolean;
298: l_api_name CONSTANT varchar2(30) := 'update_ecc';

Line 305: ,fnd_log.level_procedure);

301:
302: BEGIN
303: l_debug_enabled := okl_debug_pub.check_log_enabled;
304: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
305: ,fnd_log.level_procedure);
306:
307: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
308: okl_debug_pub.log_debug(fnd_log.level_procedure
309: ,l_module

Line 308: okl_debug_pub.log_debug(fnd_log.level_procedure

304: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
305: ,fnd_log.level_procedure);
306:
307: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
308: okl_debug_pub.log_debug(fnd_log.level_procedure
309: ,l_module
310: ,'begin debug OKLRECCB.pls call update_ecc');
311: END IF; -- check for logging on STATEMENT level
312: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 313: ,fnd_log.level_statement);

309: ,l_module
310: ,'begin debug OKLRECCB.pls call update_ecc');
311: END IF; -- check for logging on STATEMENT level
312: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
313: ,fnd_log.level_statement);
314:
315: -- call START_ACTIVITY to create savepoint, check compatibility
316: -- and initialize message list
317:

Line 342: okl_debug_pub.log_debug(fnd_log.level_statement

338: ,lp_eccv_rec
339: ,lx_eccv_rec); -- write to log
340:
341: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
342: okl_debug_pub.log_debug(fnd_log.level_statement
343: ,l_module
344: ,'okl_ecc_pvt.update_row returned with status ' ||
345: l_return_status ||
346: ' x_msg_data ' ||

Line 385: okl_debug_pub.log_debug(fnd_log.level_statement

381: ,x_msg_data
382: ,lp_eco_crt_tbl
383: ,lx_eco_crt_tbl); -- write to log
384: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
385: okl_debug_pub.log_debug(fnd_log.level_statement
386: ,l_module
387: ,'okl_eco_pvt.insert_row returned with status ' ||
388: l_return_status ||
389: ' x_msg_data ' ||

Line 406: okl_debug_pub.log_debug(fnd_log.level_statement

402: ,x_msg_count
403: ,x_msg_data
404: ,lp_eco_rmv_tbl); -- write to log
405: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
406: okl_debug_pub.log_debug(fnd_log.level_statement
407: ,l_module
408: ,'okl_eco_pvt.delete_row returned with status ' ||
409: l_return_status ||
410: ' x_msg_data ' ||

Line 427: okl_debug_pub.log_debug(fnd_log.level_procedure

423: okl_api.end_activity(x_msg_count => x_msg_count
424: ,x_msg_data => x_msg_data);
425:
426: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
427: okl_debug_pub.log_debug(fnd_log.level_procedure
428: ,l_module
429: ,'end debug OKLRECCB.pls call update_ecc');
430: END IF;
431: