220: If (req_id = 0) Then
221: -- submission failed
222: diagn_msg('Request submission failed for batch '||l_batch_name);
223: Else
224: -- insert record into GL_AUTO_ALLOC_BAT_HIST_DET for view status form
225: diagn_msg('Request_Id:'||to_char(req_id)||
226: 'Inserting into GL_AUTO_ALLOC_BAT_HIST_DET');
227: Insert Into GL_AUTO_ALLOC_BAT_HIST_DET (
228: REQUEST_ID
222: diagn_msg('Request submission failed for batch '||l_batch_name);
223: Else
224: -- insert record into GL_AUTO_ALLOC_BAT_HIST_DET for view status form
225: diagn_msg('Request_Id:'||to_char(req_id)||
226: 'Inserting into GL_AUTO_ALLOC_BAT_HIST_DET');
227: Insert Into GL_AUTO_ALLOC_BAT_HIST_DET (
228: REQUEST_ID
229: ,PARENT_REQUEST_ID
230: ,STEP_NUMBER
223: Else
224: -- insert record into GL_AUTO_ALLOC_BAT_HIST_DET for view status form
225: diagn_msg('Request_Id:'||to_char(req_id)||
226: 'Inserting into GL_AUTO_ALLOC_BAT_HIST_DET');
227: Insert Into GL_AUTO_ALLOC_BAT_HIST_DET (
228: REQUEST_ID
229: ,PARENT_REQUEST_ID
230: ,STEP_NUMBER
231: ,PROGRAM_NAME_CODE