DBA Data[Home] [Help]

APPS.FND_SUBMIT dependencies on FND_CONCURRENT_REQUESTS

Line 392: from fnd_concurrent_requests

388:
389: begin
390: select phase_code, status_code
391: into P_PHASE_CODE, P_STATUS_CODE
392: from fnd_concurrent_requests
393: where request_id = P_RS_REQUEST_ID;
394:
395: exception
396: when no_data_found then

Line 404: update fnd_concurrent_requests

400: end;
401:
402: -- Update the request phase_code and status_code to completed with error
403:
404: update fnd_concurrent_requests
405: set phase_code = 'C', status_code = 'E',
406: completion_text =
407: 'Errored during request submission using request see APIs '
408: where request_id = P_RS_REQUEST_ID;

Line 452: fnd_message.set_token('TABLE', 'fnd_concurrent_requests', FALSE);

448: return(FALSE);
449:
450: when update_failed then
451: fnd_message.set_name('FND', 'SQL-NO UPDATE');
452: fnd_message.set_token('TABLE', 'fnd_concurrent_requests', FALSE);
453: init_pvt_vars(TRUE);
454: return( FALSE );
455:
456: when invalid_program_in_set then

Line 1275: update fnd_concurrent_requests

1271: end if;
1272:
1273: -- Update back the request phase_code and status_code to the original
1274: -- values.
1275: update fnd_concurrent_requests
1276: set phase_code = P_PHASE_CODE,
1277: status_code = Decode(issubreq, 'Y', 'Z', P_STATUS_CODE),
1278: completion_text = '',
1279: is_sub_request = issubreq,

Line 1316: fnd_message.set_token('TABLE', 'fnd_concurrent_requests', FALSE);

1312: init_pvt_vars(TRUE);
1313: return ( 0 );
1314: when update_failed then
1315: fnd_message.set_name('FND', 'SQL-NO UPDATE');
1316: fnd_message.set_token('TABLE', 'fnd_concurrent_requests', FALSE);
1317: init_pvt_vars(TRUE);
1318: return( 0 );
1319: when start_time_error then
1320: fnd_message.set_name ('FND', 'CONC-Invalid Req Start Date');