APPS.JA_CN_FSG_XML_BANK_PKG dependencies on FND_CONCURRENT

Line 277: UPDATE FND_CONCURRENT_REQUESTS

273: '',
274: '',
275: '');
276: IF (X_output_option = 'Y') THEN
277: UPDATE FND_CONCURRENT_REQUESTS
278: SET OUTPUT_FILE_TYPE = 'XML'
279: WHERE REQUEST_ID = req_id;
280: END IF;
281: ELSE

Line 315: UPDATE FND_CONCURRENT_REQUESTS

311: TO_CHAR(X_SUBREQUEST_ID),
312: X_appl_deflt_name,
313: chr(0));
314: IF (X_output_option = 'Y') THEN
315: UPDATE FND_CONCURRENT_REQUESTS
316: SET OUTPUT_FILE_TYPE = 'XML'
317: WHERE REQUEST_ID = req_id;
318: END IF;
319: END IF;

Line 328: v_request_flag := fnd_concurrent.wait_for_request(request_id => req_id,

324: ELSE
325: X_concurrent_request_id := req_id;
326:
327: COMMIT;
328: v_request_flag := fnd_concurrent.wait_for_request(request_id => req_id,
329: INTERVAL => ln_waiting_interval,
330: max_wait => 0,
331: phase => lv_fsg_req_phase,
332: status => lv_fsg_req_status,

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

424: x_result_flag := 'Error';
425: ELSE
426: COMMIT;
427: --Wait for concurrent complete
428: l_complete_flag := fnd_concurrent.wait_for_request(x_xml_request_id,
429: 1,
430: 0,
431: l_phase,
432: l_status,

Line 633: FND_CONCURRENT_PROGRAMS FCP,

629: -- Get template application id
630: SELECT APP.APPLICATION_ID
631: INTO l_template_appl
632: FROM FND_APPLICATION_VL APP,
633: FND_CONCURRENT_PROGRAMS FCP,
634: FND_CONCURRENT_REQUESTS R
635: WHERE FCP.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
636: AND R.REQUEST_ID = l_fsg_request_id
637: AND APP.APPLICATION_ID = FCP.APPLICATION_ID;

Line 634: FND_CONCURRENT_REQUESTS R

630: SELECT APP.APPLICATION_ID
631: INTO l_template_appl
632: FROM FND_APPLICATION_VL APP,
633: FND_CONCURRENT_PROGRAMS FCP,
634: FND_CONCURRENT_REQUESTS R
635: WHERE FCP.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
636: AND R.REQUEST_ID = l_fsg_request_id
637: AND APP.APPLICATION_ID = FCP.APPLICATION_ID;
638: --submit XML publisher concurrent program

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

685: END IF; --( g_proc_level >= g_dbg_level)
686: EXCEPTION
687: WHEN l_submit_request_exp THEN
688: fnd_file.put_line(fnd_file.output, SQLCODE || ':' || SQLERRM);
689: l_conc_succ := fnd_concurrent.set_completion_status(status => 'ERROR',
690: message => SQLCODE || ':' ||
691: SQLERRM);
692: --log for debug
693: IF (l_proc_level >= l_dbg_level) THEN

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

697: SQLCODE || ':' || SQLERRM);
698: END IF; --(l_proc_level >= l_dbg_level)
699: WHEN OTHERS THEN
700: fnd_file.put_line(fnd_file.output, SQLCODE || ':' || SQLERRM);
701: l_conc_succ := fnd_concurrent.set_completion_status(status => 'ERROR',
702: message => SQLCODE || ':' ||
703: SQLERRM);
704: --log for debug
705: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

Line 1592: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_convert,

1588:
1589: --(5.1)Waiting for the 'Report Item Data Convert program' completed
1590: --get its status
1591: IF ln_reqid_convert <> 0 THEN
1592: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_convert,
1593: interval => ln_waiting_interval,
1594: phase => lv_convert_req_phase,
1595: status => lv_convert_req_status,
1596: dev_phase => lv_dev_phase,

Line 1621: END IF; --FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_convert

1617: --Completed with 'Error'
1618: ELSIF lv_convert_req_status_code = 'E' THEN
1619: lv_error_flag := 'E';
1620: END IF; --lv_comb_req_status_code='C'
1621: END IF; --FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_convert
1622: ELSE
1623: lv_error_flag := 'E';
1624: END IF; --ln_reqid_convert<>0
1625: END IF;

Line 1628: lb_error_status := FND_CONCURRENT.Set_Completion_Status(status => 'WARNING',

1624: END IF; --ln_reqid_convert<>0
1625: END IF;
1626:
1627: IF lv_error_flag = 'W' THEN
1628: lb_error_status := FND_CONCURRENT.Set_Completion_Status(status => 'WARNING',
1629: message => '');
1630: ELSIF lv_error_flag = 'E' THEN
1631: lb_error_status := FND_CONCURRENT.Set_Completion_Status(status => 'ERROR',
1632: message => '');

Line 1631: lb_error_status := FND_CONCURRENT.Set_Completion_Status(status => 'ERROR',

1627: IF lv_error_flag = 'W' THEN
1628: lb_error_status := FND_CONCURRENT.Set_Completion_Status(status => 'WARNING',
1629: message => '');
1630: ELSIF lv_error_flag = 'E' THEN
1631: lb_error_status := FND_CONCURRENT.Set_Completion_Status(status => 'ERROR',
1632: message => '');
1633: END IF;
1634:
1635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FSG:End');