APPS.FEM_DIM_HIER_LOADER_PKG dependencies on FND_CONCURRENT

Line 324: IF fnd_concurrent.wait_for_request(request_id=> dim_rec.request_id,

320: FOR dim_rec IN (SELECT request_id
321: FROM fem_ld_dim_requests_gt
322: WHERE request_id > 0)
323: LOOP
324: IF fnd_concurrent.wait_for_request(request_id=> dim_rec.request_id,
325: interval => c_interval,
326: max_wait => c_max_wait_time,
327: phase => l_phase,
328: status => l_status,

Line 341: l_compl_status:= fnd_concurrent.set_completion_status('ERROR',null);

337: ELSE
338: UPDATE fem_ld_dim_requests_gt
339: SET status = 'N'
340: WHERE request_id = dim_rec.request_id;
341: l_compl_status:= fnd_concurrent.set_completion_status('ERROR',null);
342: END IF;
343:
344: END IF; -- fnd_concurrent.wait_for_request (DIMENSIONS)
345:

Line 344: END IF; -- fnd_concurrent.wait_for_request (DIMENSIONS)

340: WHERE request_id = dim_rec.request_id;
341: l_compl_status:= fnd_concurrent.set_completion_status('ERROR',null);
342: END IF;
343:
344: END IF; -- fnd_concurrent.wait_for_request (DIMENSIONS)
345:
346: END LOOP; -- dim_rec
347:
348: ELSE -- 'Hierarchy'

Line 353: IF fnd_concurrent.wait_for_request(request_id=> hier_rec.request_id,

349: FOR hier_rec IN (SELECT DISTINCT request_id
350: FROM fem_ld_dim_requests_gt
351: WHERE request_id > 0)
352: LOOP
353: IF fnd_concurrent.wait_for_request(request_id=> hier_rec.request_id,
354: interval => c_interval,
355: max_wait => c_max_wait_time,
356: phase => l_phase,
357: status => l_status,

Line 370: l_compl_status:= fnd_concurrent.set_completion_status('ERROR',null);

366: ELSE
367: UPDATE fem_ld_hier_requests_gt
368: SET status = 'N'
369: WHERE request_id = hier_rec.request_id;
370: l_compl_status:= fnd_concurrent.set_completion_status('ERROR',null);
371: END IF;
372:
373: END IF; -- fnd_concurrent.wait_for_request (DIMENSIONS)
374:

Line 373: END IF; -- fnd_concurrent.wait_for_request (DIMENSIONS)

369: WHERE request_id = hier_rec.request_id;
370: l_compl_status:= fnd_concurrent.set_completion_status('ERROR',null);
371: END IF;
372:
373: END IF; -- fnd_concurrent.wait_for_request (DIMENSIONS)
374:
375: END LOOP; -- dim_rec
376:
377: END CASE; -- p_wait_for

Line 474: l_compl_status:= fnd_concurrent.set_completion_status('ERROR',null);

470: l_at_least_one := TRUE;
471: COMMIT;
472: ELSE
473: l_request_id := -10000.0; -- No records available in interface table
474: l_compl_status:= fnd_concurrent.set_completion_status('ERROR',null);
475: END IF;
476:
477: l_dummy := 0.0;
478: