189:
190:
191: BEGIN
192:
193: x_log_file := fnd_profile.value('CN_LOG_FILE');
194: x_log_file_dir := fnd_profile.value('UTL_FILE_LOG');
195:
196: IF ((x_log_file='Y') AND (x_log_file_dir IS NOT NULL) AND (g_log_file_open <>'Y')) THEN
197: x_request_id := fnd_global.conc_request_id;
190:
191: BEGIN
192:
193: x_log_file := fnd_profile.value('CN_LOG_FILE');
194: x_log_file_dir := fnd_profile.value('UTL_FILE_LOG');
195:
196: IF ((x_log_file='Y') AND (x_log_file_dir IS NOT NULL) AND (g_log_file_open <>'Y')) THEN
197: x_request_id := fnd_global.conc_request_id;
198:
358: END IF;
359:
360:
361: -- Replaced with the above code for Performance concern
362: --IF fnd_profile.value('CN_DEBUG') = 'Y' THEN
363: -- push( x_message_text => message_text
364: -- ,x_message_type => 'DEBUG');
365: --END IF;
366:
620: ,x_process_type VARCHAR2
621: ,p_org_id IN NUMBER) IS
622: BEGIN
623: clear;
624: g_cn_debug := fnd_profile.value('CN_DEBUG');
625: g_org_id := p_org_id;
626:
627: ins_audit_batch( x_parent_proc_audit_id
628: ,x_process_audit_id