APPS.CSTPSMCW dependencies on FND_CONCURRENT

Line 112: FROM fnd_concurrent_requests fcr

108: l_stmt_num := 10;
109:
110: SELECT nvl(max(fcr.request_id), -1)
111: INTO l_req_id
112: FROM fnd_concurrent_requests fcr
113: WHERE program_application_id = 702
114: AND concurrent_program_id = l_program_id
115: AND argument1 = TO_CHAR(p_org_id)
116: AND phase_code <> 'C'

Line 127: FROM fnd_concurrent_programs fcp

123: /* Check if a Standard Cost Update is Running */
124: l_stmt_num := 20;
125: SELECT concurrent_program_id
126: INTO l_cmcicu_prog_id
127: FROM fnd_concurrent_programs fcp
128: WHERE fcp.application_id = 702
129: AND fcp.concurrent_program_name = 'CMCICU';
130:
131: l_req_id := -1;

Line 136: FROM fnd_concurrent_requests fcr

132:
133: l_stmt_num := 30;
134: SELECT nvl(max(fcr.request_id), -1)
135: INTO l_req_id
136: FROM fnd_concurrent_requests fcr
137: WHERE program_application_id = 702
138: AND concurrent_program_id = l_cmcicu_prog_id
139: AND argument1 = TO_CHAR(p_org_id)
140: AND phase_code = 'R';

Line 145: l_cmcicu_status := FND_CONCURRENT.WAIT_FOR_REQUEST(l_req_id,

141:
142: l_stmt_num := 40;
143:
144: IF (l_req_id <> -1) THEN
145: l_cmcicu_status := FND_CONCURRENT.WAIT_FOR_REQUEST(l_req_id,
146: l_interval,
147: l_maxwait,
148: l_phase,
149: l_status,

Line 274: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);

270: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code
271: ||' '
272: ||l_err_msg,1,240));
273:
274: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
275:
276: WHEN UPDATE_QUANTITY_ISSUE_FAILURE THEN
277: ROLLBACK;
278: l_err_msg := SUBSTR('CSTPSMCW.LOT_COST_TXN_PROCESSOR('

Line 285: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);

281: ||SQLERRM,1,240
282: ||': '||l_error_buf);
283: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
284:
285: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
286:
287: WHEN INSERT_MMT_FAILURE THEN
288: ROLLBACK;
289: l_err_msg := SUBSTR('CSTPSMCW.LOT_COST_TXN_PROCESSOR('

Line 296: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);

292: ||SQLERRM,1,240
293: ||': '||l_error_buf);
294: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
295:
296: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
297:
298: WHEN OTHERS THEN
299: ROLLBACK;
300: l_err_code := NULL;

Line 308: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);

304: ||SQLERRM,1,240);
305:
306: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
307:
308: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
309:
310: END lot_txn_cost_processor;
311:
312: ----------------------------------------------------------------------------

Line 484: FROM FND_CONCURRENT_REQUESTS

480: INTO l_prog_application_id,
481: l_program_id,
482: l_login_id,
483: l_user_id
484: FROM FND_CONCURRENT_REQUESTS
485: WHERE request_id = p_request_id;
486:
487:
488: /* If Transaction is BONUS at First Operation and Queue Introperation