DBA Data[Home] [Help]

APPS.FND_SUBMIT dependencies on FND_CONCURRENT_REQUESTS

Line 418: from fnd_concurrent_requests

414:
415: begin
416: select phase_code, status_code
417: into P_PHASE_CODE, P_STATUS_CODE
418: from fnd_concurrent_requests
419: where request_id = P_RS_REQUEST_ID;
420:
421: exception
422: when no_data_found then

Line 430: update fnd_concurrent_requests

426: end;
427:
428: -- Update the request phase_code and status_code to completed with error
429:
430: update fnd_concurrent_requests
431: set phase_code = 'C', status_code = 'E',
432: completion_text =
433: 'Errored during request submission using request see APIs '
434: where request_id = P_RS_REQUEST_ID;

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

474: return(FALSE);
475:
476: when update_failed then
477: fnd_message.set_name('FND', 'SQL-NO UPDATE');
478: fnd_message.set_token('TABLE', 'fnd_concurrent_requests', FALSE);
479: init_pvt_vars(TRUE);
480: return( FALSE );
481:
482: when invalid_program_in_set then

Line 1329: update fnd_concurrent_requests

1325: end if;
1326:
1327: -- Update back the request phase_code and status_code to the original
1328: -- values.
1329: update fnd_concurrent_requests
1330: set phase_code = P_PHASE_CODE,
1331: status_code = Decode(issubreq, 'Y', 'Z', P_STATUS_CODE),
1332: completion_text = '',
1333: is_sub_request = issubreq,

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

1366: init_pvt_vars(TRUE);
1367: return ( 0 );
1368: when update_failed then
1369: fnd_message.set_name('FND', 'SQL-NO UPDATE');
1370: fnd_message.set_token('TABLE', 'fnd_concurrent_requests', FALSE);
1371: init_pvt_vars(TRUE);
1372: return( 0 );
1373: when start_time_error then
1374: fnd_message.set_name ('FND', 'CONC-Invalid Req Start Date');