DBA Data[Home] [Help]

APPS.RRS_SITE_UDA_BULKLOAD_INTF dependencies on ERROR_HANDLER

Line 85: -- Opens Error_Handler debug session, only if Debug session is not already open.

81: ----------------------------------------------------------------
82: IF (G_DEBUG = 1) THEN
83:
84: ----------------------------------------------------------------------------------
85: -- Opens Error_Handler debug session, only if Debug session is not already open.
86: ----------------------------------------------------------------------------------
87: IF (Error_Handler.Get_Debug <> 'Y') THEN
88: Open_Debug_Session_Internal;
89: END IF;

Line 87: IF (Error_Handler.Get_Debug <> 'Y') THEN

83:
84: ----------------------------------------------------------------------------------
85: -- Opens Error_Handler debug session, only if Debug session is not already open.
86: ----------------------------------------------------------------------------------
87: IF (Error_Handler.Get_Debug <> 'Y') THEN
88: Open_Debug_Session_Internal;
89: END IF;
90: END IF;
91: END Open_Debug_Session;

Line 106: Error_Handler.initialize();

102: l_log_output_dir VARCHAR2(512);
103: l_log_return_status VARCHAR2(99);
104: l_errbuff VARCHAR2(999);
105: BEGIN
106: Error_Handler.initialize();
107: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);
108:
109: OPEN c_get_utl_file_dir;
110: FETCH c_get_utl_file_dir INTO l_log_output_dir;

Line 107: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);

103: l_log_return_status VARCHAR2(99);
104: l_errbuff VARCHAR2(999);
105: BEGIN
106: Error_Handler.initialize();
107: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);
108:
109: OPEN c_get_utl_file_dir;
110: FETCH c_get_utl_file_dir INTO l_log_output_dir;
111: IF c_get_utl_file_dir%FOUND THEN

Line 123: -- This sets Debug value so that Error_Handler.Get_Debug returns 'Y' --

119: G_ERROR_FILE_NAME := G_ERROR_TABLE_NAME||'_'||to_char(sysdate, 'DDMONYYYY_HH24MISS')||'.err';
120:
121: -----------------------------------------------------------------------
122: -- To open the Debug Session to write the Debug Log. --
123: -- This sets Debug value so that Error_Handler.Get_Debug returns 'Y' --
124: -----------------------------------------------------------------------
125: Error_Handler.Open_Debug_Session(
126: p_debug_filename => G_ERROR_FILE_NAME
127: ,p_output_dir => l_log_output_dir

Line 125: Error_Handler.Open_Debug_Session(

121: -----------------------------------------------------------------------
122: -- To open the Debug Session to write the Debug Log. --
123: -- This sets Debug value so that Error_Handler.Get_Debug returns 'Y' --
124: -----------------------------------------------------------------------
125: Error_Handler.Open_Debug_Session(
126: p_debug_filename => G_ERROR_FILE_NAME
127: ,p_output_dir => l_log_output_dir
128: ,x_return_status => l_log_return_status
129: ,x_error_mesg => l_errbuff

Line 150: Error_Handler.Write_debug(p_msg);

146:
147: PROCEDURE Developer_Debug(p_msg IN VARCHAR2) IS
148: l_err_msg VARCHAR2(240);
149: BEGIN
150: Error_Handler.Write_debug(p_msg);
151: EXCEPTION
152: WHEN OTHERS THEN
153: l_err_msg := SUBSTRB(SQLERRM, 1,240);
154: FND_FILE.put_line(FND_FILE.LOG, 'LOGGING SQL ERROR => '||l_err_msg);

Line 164: -- Close Error_Handler debug session, only if Debug session is already open.

160: PROCEDURE Close_Debug_Session IS
161:
162: BEGIN
163: -----------------------------------------------------------------------------
164: -- Close Error_Handler debug session, only if Debug session is already open.
165: -----------------------------------------------------------------------------
166: IF (Error_Handler.Get_Debug = 'Y') THEN
167: Error_Handler.Close_Debug_Session;
168: END IF;

Line 166: IF (Error_Handler.Get_Debug = 'Y') THEN

162: BEGIN
163: -----------------------------------------------------------------------------
164: -- Close Error_Handler debug session, only if Debug session is already open.
165: -----------------------------------------------------------------------------
166: IF (Error_Handler.Get_Debug = 'Y') THEN
167: Error_Handler.Close_Debug_Session;
168: END IF;
169:
170: END Close_Debug_Session;

Line 167: Error_Handler.Close_Debug_Session;

163: -----------------------------------------------------------------------------
164: -- Close Error_Handler debug session, only if Debug session is already open.
165: -----------------------------------------------------------------------------
166: IF (Error_Handler.Get_Debug = 'Y') THEN
167: Error_Handler.Close_Debug_Session;
168: END IF;
169:
170: END Close_Debug_Session;
171: -----------------------------------------------

Line 284: IF (Error_Handler.Get_Debug = 'Y') THEN

280: AND data_set_id = p_data_set_id;
281: BEGIN
282:
283: Write_Conclog('Processing the User Defined Attributes ' );
284: IF (Error_Handler.Get_Debug = 'Y') THEN
285: l_debug_level := 3; --continue writing to the Debug Log opened.
286: ELSE
287: l_debug_level := 0; --Since Debug log is not opened, donot open Debug log for User-Attrs also.
288: END IF;

Line 460: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2

456: ,p_entity_index => l_entity_index_counter --IN NUMBER
457: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
458: --,p_debug_level => p_debug_level --IN NUMBER
459: ,p_debug_level => l_debug_level --IN NUMBER
460: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
461: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
462: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
463: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
464: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

Line 566: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2

562: ,p_entity_index => l_entity_index_counter --IN NUMBER
563: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
564: --,p_debug_level => p_debug_level --IN NUMBER
565: ,p_debug_level => l_debug_level --IN NUMBER
566: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
567: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
568: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
569: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
570: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

Line 661: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2

657: ,p_entity_index => l_entity_index_counter --IN NUMBER
658: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
659: --,p_debug_level => p_debug_level --IN NUMBER
660: ,p_debug_level => l_debug_level --IN NUMBER
661: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
662: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
663: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
664: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
665: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

Line 718: ERROR_HANDLER.Log_Error(

714: -- within our Business Object's processing) --
715: -------------------------------------------------------------------
716: Write_Conclog('****Dumping the List of Error messages into the Concurrent Log***');
717:
718: ERROR_HANDLER.Log_Error(
719: p_write_err_to_inttable => 'N'
720: ,p_write_err_to_conclog => 'Y'
721: ,p_write_err_to_debugfile => 'Y'
722: );