DBA Data[Home] [Help]

APPS.BOM_TEST_SUBSCR_PKG dependencies on ERROR_HANDLER

Line 51: Error_Handler.initialize();

47: l_debug_file_dir := SUBSTR(l_debug_file_dir, 1, INSTR(l_debug_file_dir, ',') - 1);
48: END IF;
49: l_log_file := 'BOM_TEST_SUBSCR'||'_'||TO_CHAR(SYSDATE, 'DDMONYYYY_HH24MISS')||'.err';
50:
51: Error_Handler.initialize();
52: Error_Handler.Set_Debug('Y');
53: Error_Handler.Open_Debug_Session(
54: p_debug_filename => l_log_file
55: ,p_output_dir => l_debug_file_dir

Line 52: Error_Handler.Set_Debug('Y');

48: END IF;
49: l_log_file := 'BOM_TEST_SUBSCR'||'_'||TO_CHAR(SYSDATE, 'DDMONYYYY_HH24MISS')||'.err';
50:
51: Error_Handler.initialize();
52: Error_Handler.Set_Debug('Y');
53: Error_Handler.Open_Debug_Session(
54: p_debug_filename => l_log_file
55: ,p_output_dir => l_debug_file_dir
56: ,x_return_status => l_log_return_status

Line 53: Error_Handler.Open_Debug_Session(

49: l_log_file := 'BOM_TEST_SUBSCR'||'_'||TO_CHAR(SYSDATE, 'DDMONYYYY_HH24MISS')||'.err';
50:
51: Error_Handler.initialize();
52: Error_Handler.Set_Debug('Y');
53: Error_Handler.Open_Debug_Session(
54: p_debug_filename => l_log_file
55: ,p_output_dir => l_debug_file_dir
56: ,x_return_status => l_log_return_status
57: ,x_error_mesg => l_errbuff

Line 62: Error_HandLer.Write_Debug(p_debug_message => 'Event Name'|| ' = '||l_event_name );

58: );
59:
60: l_event_name := p_event.getEventName();
61: l_event_key := p_event.GetEventKey();
62: Error_HandLer.Write_Debug(p_debug_message => 'Event Name'|| ' = '||l_event_name );
63: Error_HandLer.Write_Debug(p_debug_message => 'Event Key '|| ' = '||l_event_key );
64:
65: l_param_list := p_event.getparameterlist;
66: IF l_param_list IS NOT NULL THEN

Line 63: Error_HandLer.Write_Debug(p_debug_message => 'Event Key '|| ' = '||l_event_key );

59:
60: l_event_name := p_event.getEventName();
61: l_event_key := p_event.GetEventKey();
62: Error_HandLer.Write_Debug(p_debug_message => 'Event Name'|| ' = '||l_event_name );
63: Error_HandLer.Write_Debug(p_debug_message => 'Event Key '|| ' = '||l_event_key );
64:
65: l_param_list := p_event.getparameterlist;
66: IF l_param_list IS NOT NULL THEN
67: FOR i IN l_param_list.FIRST..l_param_list.LAST LOOP

Line 70: Error_HandLer.Write_Debug(p_debug_message => l_param_name|| ' = '||l_param_value );

66: IF l_param_list IS NOT NULL THEN
67: FOR i IN l_param_list.FIRST..l_param_list.LAST LOOP
68: l_param_name := l_param_list(i).getname;
69: l_param_value := l_param_list(i).getvalue;
70: Error_HandLer.Write_Debug(p_debug_message => l_param_name|| ' = '||l_param_value );
71: END LOOP;
72: END IF;
73: Error_Handler.Close_Debug_Session;
74: RETURN 'SUCCESS';

Line 73: Error_Handler.Close_Debug_Session;

69: l_param_value := l_param_list(i).getvalue;
70: Error_HandLer.Write_Debug(p_debug_message => l_param_name|| ' = '||l_param_value );
71: END LOOP;
72: END IF;
73: Error_Handler.Close_Debug_Session;
74: RETURN 'SUCCESS';
75: EXCEPTION WHEN OTHERS THEN
76: l_error := SQLERRM;
77: l_err_text := 'Error : '||TO_CHAR(SQLCODE)||'---'||l_err_text;

Line 78: Error_Handler.Add_Error_Message( p_message_text => l_err_text, p_message_type => 'E');

74: RETURN 'SUCCESS';
75: EXCEPTION WHEN OTHERS THEN
76: l_error := SQLERRM;
77: l_err_text := 'Error : '||TO_CHAR(SQLCODE)||'---'||l_err_text;
78: Error_Handler.Add_Error_Message( p_message_text => l_err_text, p_message_type => 'E');
79: Error_Handler.Close_Debug_Session;
80: RETURN 'ERROR';
81: END bom_test_subscription;
82:

Line 79: Error_Handler.Close_Debug_Session;

75: EXCEPTION WHEN OTHERS THEN
76: l_error := SQLERRM;
77: l_err_text := 'Error : '||TO_CHAR(SQLCODE)||'---'||l_err_text;
78: Error_Handler.Add_Error_Message( p_message_text => l_err_text, p_message_type => 'E');
79: Error_Handler.Close_Debug_Session;
80: RETURN 'ERROR';
81: END bom_test_subscription;
82:
83: PROCEDURE SET_BOM_EVENT_INFO