187: begin
188:
189: RULEC := 0;
190: P_RULES := empty_drules;
191: userid := FND_GLOBAL.user_id;
192: respid := FND_GLOBAL.resp_id;
193: respapplid := FND_GLOBAL.resp_appl_id;
194: loginid := FND_GLOBAL.login_id;
195: last_rule_id := 0;
188:
189: RULEC := 0;
190: P_RULES := empty_drules;
191: userid := FND_GLOBAL.user_id;
192: respid := FND_GLOBAL.resp_id;
193: respapplid := FND_GLOBAL.resp_appl_id;
194: loginid := FND_GLOBAL.login_id;
195: last_rule_id := 0;
196:
189: RULEC := 0;
190: P_RULES := empty_drules;
191: userid := FND_GLOBAL.user_id;
192: respid := FND_GLOBAL.resp_id;
193: respapplid := FND_GLOBAL.resp_appl_id;
194: loginid := FND_GLOBAL.login_id;
195: last_rule_id := 0;
196:
197: -- find any debug rules available for this component instance.
190: P_RULES := empty_drules;
191: userid := FND_GLOBAL.user_id;
192: respid := FND_GLOBAL.resp_id;
193: respapplid := FND_GLOBAL.resp_appl_id;
194: loginid := FND_GLOBAL.login_id;
195: last_rule_id := 0;
196:
197: -- find any debug rules available for this component instance.
198: -- if request_id is passed then use DRC_REQ else DRC_NON_REQ cursor.
562: dr_rec.component_appl_id, dr_rec.start_time,
563: dr_rec.end_time, repetition_counter+1, log_file, -- fix for bug 3787995
564: node_name, dr_rec.user_Id, dr_rec.responsibility_id,
565: dr_rec.resp_appl_id, dr_rec.debug_option_name,
566: dr_rec.debug_option_value, sysdate, fnd_global.user_id,
567: sysdate, fnd_global.user_id, fnd_global.login_id,
568: dr_rec.comments, comp_inst_id); --Added for Bug 3788285.For showing request_id
569:
570:
563: dr_rec.end_time, repetition_counter+1, log_file, -- fix for bug 3787995
564: node_name, dr_rec.user_Id, dr_rec.responsibility_id,
565: dr_rec.resp_appl_id, dr_rec.debug_option_name,
566: dr_rec.debug_option_value, sysdate, fnd_global.user_id,
567: sysdate, fnd_global.user_id, fnd_global.login_id,
568: dr_rec.comments, comp_inst_id); --Added for Bug 3788285.For showing request_id
569:
570:
571: -- added db_rule_enabled as a fix for bug 3787995
688: icx_session_id,
689: user_id,
690: resp_appl_id,
691: resp_id,
692: fnd_global.security_group_id
693: );
694:
695: else
696: if ( fnd_log.g_transaction_context_id is null ) then
694:
695: else
696: if ( fnd_log.g_transaction_context_id is null ) then
697: transaction_id := fnd_log_repository.init_trans_int_with_context
698: (fnd_global.conc_request_id,
699: fnd_global.form_id,
700: fnd_global.form_appl_id,
701: fnd_global.conc_process_id,
702: fnd_global.conc_queue_id,
695: else
696: if ( fnd_log.g_transaction_context_id is null ) then
697: transaction_id := fnd_log_repository.init_trans_int_with_context
698: (fnd_global.conc_request_id,
699: fnd_global.form_id,
700: fnd_global.form_appl_id,
701: fnd_global.conc_process_id,
702: fnd_global.conc_queue_id,
703: fnd_global.queue_appl_id,
696: if ( fnd_log.g_transaction_context_id is null ) then
697: transaction_id := fnd_log_repository.init_trans_int_with_context
698: (fnd_global.conc_request_id,
699: fnd_global.form_id,
700: fnd_global.form_appl_id,
701: fnd_global.conc_process_id,
702: fnd_global.conc_queue_id,
703: fnd_global.queue_appl_id,
704: icx_sec.g_session_id,
697: transaction_id := fnd_log_repository.init_trans_int_with_context
698: (fnd_global.conc_request_id,
699: fnd_global.form_id,
700: fnd_global.form_appl_id,
701: fnd_global.conc_process_id,
702: fnd_global.conc_queue_id,
703: fnd_global.queue_appl_id,
704: icx_sec.g_session_id,
705: fnd_global.user_id,
698: (fnd_global.conc_request_id,
699: fnd_global.form_id,
700: fnd_global.form_appl_id,
701: fnd_global.conc_process_id,
702: fnd_global.conc_queue_id,
703: fnd_global.queue_appl_id,
704: icx_sec.g_session_id,
705: fnd_global.user_id,
706: fnd_global.resp_appl_id,
699: fnd_global.form_id,
700: fnd_global.form_appl_id,
701: fnd_global.conc_process_id,
702: fnd_global.conc_queue_id,
703: fnd_global.queue_appl_id,
704: icx_sec.g_session_id,
705: fnd_global.user_id,
706: fnd_global.resp_appl_id,
707: fnd_global.resp_id,
701: fnd_global.conc_process_id,
702: fnd_global.conc_queue_id,
703: fnd_global.queue_appl_id,
704: icx_sec.g_session_id,
705: fnd_global.user_id,
706: fnd_global.resp_appl_id,
707: fnd_global.resp_id,
708: fnd_global.security_group_id
709: );
702: fnd_global.conc_queue_id,
703: fnd_global.queue_appl_id,
704: icx_sec.g_session_id,
705: fnd_global.user_id,
706: fnd_global.resp_appl_id,
707: fnd_global.resp_id,
708: fnd_global.security_group_id
709: );
710: else
703: fnd_global.queue_appl_id,
704: icx_sec.g_session_id,
705: fnd_global.user_id,
706: fnd_global.resp_appl_id,
707: fnd_global.resp_id,
708: fnd_global.security_group_id
709: );
710: else
711: transaction_id := fnd_log.g_transaction_context_id;
704: icx_sec.g_session_id,
705: fnd_global.user_id,
706: fnd_global.resp_appl_id,
707: fnd_global.resp_id,
708: fnd_global.security_group_id
709: );
710: else
711: transaction_id := fnd_log.g_transaction_context_id;
712: end if;