APPS.JA_CN_FSG_XML_SUBMIT_PROG dependencies on FND_CONCURRENT

Line 206: UPDATE FND_CONCURRENT_REQUESTS

202: '', '', '', '', '', '', '', '', '', '',
203: '', '', '', '', '', '', '', '', '', ''
204: );
205: IF (X_output_option = 'Y') THEN
206: UPDATE FND_CONCURRENT_REQUESTS
207: SET
208: OUTPUT_FILE_TYPE = 'XML'
209: WHERE
210: REQUEST_ID = req_id;

Line 254: UPDATE FND_CONCURRENT_REQUESTS

250: '', '', '', '', '', '', '', '', '', '',
251: '', '', '', '', '', '', '', '', ''
252: );
253: IF (X_output_option = 'Y') THEN
254: UPDATE FND_CONCURRENT_REQUESTS
255: SET
256: OUTPUT_FILE_TYPE = 'XML'
257: WHERE
258: REQUEST_ID = req_id;

Line 342: l_complete_flag := fnd_concurrent.wait_for_request(x_xml_request_id,

338: x_result_flag := 'Error';
339: ELSE
340: COMMIT;
341: --Wait for concurrent complete
342: l_complete_flag := fnd_concurrent.wait_for_request(x_xml_request_id,
343: 1,
344: 0,
345: l_phase,
346: l_status,

Line 550: FND_CONCURRENT_PROGRAMS FCP,

546: -- Get template application id
547: SELECT APP.APPLICATION_ID
548: INTO l_template_appl
549: FROM FND_APPLICATION_VL APP,
550: FND_CONCURRENT_PROGRAMS FCP,
551: FND_CONCURRENT_REQUESTS R
552: WHERE FCP.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
553: AND R.REQUEST_ID = l_fsg_request_id
554: AND APP.APPLICATION_ID = FCP.APPLICATION_ID;

Line 551: FND_CONCURRENT_REQUESTS R

547: SELECT APP.APPLICATION_ID
548: INTO l_template_appl
549: FROM FND_APPLICATION_VL APP,
550: FND_CONCURRENT_PROGRAMS FCP,
551: FND_CONCURRENT_REQUESTS R
552: WHERE FCP.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
553: AND R.REQUEST_ID = l_fsg_request_id
554: AND APP.APPLICATION_ID = FCP.APPLICATION_ID;
555: --submit XML publisher concurrent program

Line 612: l_conc_succ := fnd_concurrent.set_completion_status(status => 'ERROR',

608: EXCEPTION
609: WHEN l_submit_request_exp
610: THEN
611: fnd_file.put_line(fnd_file.output, SQLCODE || ':' || SQLERRM);
612: l_conc_succ := fnd_concurrent.set_completion_status(status => 'ERROR',
613: message => SQLCODE || ':' ||
614: SQLERRM);
615: --log for debug
616: IF (l_proc_level >= l_dbg_level)

Line 625: l_conc_succ := fnd_concurrent.set_completion_status(status => 'ERROR',

621: SQLCODE || ':' || SQLERRM);
622: END IF; --(l_proc_level >= l_dbg_level)
623: WHEN OTHERS THEN
624: fnd_file.put_line(fnd_file.output, SQLCODE || ':' || SQLERRM);
625: l_conc_succ := fnd_concurrent.set_completion_status(status => 'ERROR',
626: message => SQLCODE || ':' ||
627: SQLERRM);
628: --log for debug
629: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)