[Home] [Help]
520: -- preserving this concurrent request's
521: -- request_id in a local variable
522:
523: l_request_id := fnd_global.conc_request_id;
524: l_request_data := fnd_conc_global.request_data;
525:
526: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
527: THEN
528: FND_LOG.String
816:
817: -- Moving the parent concurrent request to Paused
818: -- status in order to start the child
819:
820: fnd_conc_global.set_req_globals
821: (
822: conc_status => 'PAUSED'
823: , request_data => '1'
824: );
2141: -- setting flag to identify that
2142: -- the batch has failed if the
2143: -- concurrent request was not terminated
2144:
2145: IF NVL(fnd_conc_global.request_data, 'X') <> 'T'
2146: THEN
2147: -- Only if the program is not terminated, we
2148: -- set the batch failed status to TRUE if a
2149: -- batch had some problems and completed with
2268: -- terminate the process.
2269:
2270: EXIT WHEN
2271: c_staging%NOTFOUND
2272: OR fnd_conc_global.request_data = 'T';
2273:
2274: -- Closing the cursor inside the loop to prevent
2275: -- ORA-1555 error. This cursor is reopened in the
2276: -- beginning of the loop during the next iteration.
2299:
2300: -- Writing the output for this worker thread
2301: -- indicating the operations carried out in it.
2302:
2303: IF FND_CONC_GLOBAL.request_data = 'T'
2304: THEN
2305: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2306: THEN
2307: FND_LOG.String
2331: END IF;
2332:
2333: ---
2334:
2335: IF NVL(fnd_conc_global.request_data, 'X') <> 'T'
2336:
2337: -- If the concurrent request is not terminated
2338: -- then the completion status is determined
2339: -- based on the outcome of the concurrent request.