eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_FSG_XML_SUBMIT_PROG dependencies on FND_CONCURRENT

Line 209: UPDATE FND_CONCURRENT_REQUESTS

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

Line 257: UPDATE FND_CONCURRENT_REQUESTS

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

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

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

Line 553: FND_CONCURRENT_PROGRAMS FCP,

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

Line 554: FND_CONCURRENT_REQUESTS R

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

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

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

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

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

Line 1359: UPDATE FND_CONCURRENT_REQUESTS

1355: '', '', '', '', '', '', '', '', '', ''
1356: );
1357:
1358: IF (pv_output_option = 'Y') THEN
1359: UPDATE FND_CONCURRENT_REQUESTS
1360: SET
1361: OUTPUT_FILE_TYPE = 'XML'
1362: WHERE
1363: REQUEST_ID = ln_reqid_fsg;

Line 1368: --sub-request id from the table 'fnd_concurrent_requests' for the FSG - CFS report.

1364: END IF;
1365: COMMIT;
1366:
1367: --(4.2)Waiting for the 'Cash Flow Statement - FSG' completed, and then retrive the
1368: --sub-request id from the table 'fnd_concurrent_requests' for the FSG - CFS report.
1369: IF ln_reqid_fsg<>0
1370: THEN
1371: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_fsg
1372: ,interval => ln_waiting_interval

Line 1371: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_fsg

1367: --(4.2)Waiting for the 'Cash Flow Statement - FSG' completed, and then retrive the
1368: --sub-request id from the table 'fnd_concurrent_requests' for the FSG - CFS report.
1369: IF ln_reqid_fsg<>0
1370: THEN
1371: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_fsg
1372: ,interval => ln_waiting_interval
1373: ,phase => lv_fsg_req_phase
1374: ,status => lv_fsg_req_status
1375: ,dev_phase => lv_dev_phase

Line 1436: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_cal

1432: --(4.4)Waiting for the 'Cash flow statement - Calculation' successfully completed
1433: -- and then submit concurrent program 'Cash Flow Statement - Combination'.
1434: IF ln_reqid_cal<>0
1435: THEN
1436: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_cal
1437: ,interval => ln_waiting_interval
1438: ,phase => lv_cal_req_phase
1439: ,status => lv_cal_req_status
1440: ,dev_phase => lv_dev_phase

Line 1481: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_csf_comb_req_id

1477: --(4.5)Waiting for the 'Cash flow statement - Combination' completed
1478: --get its status
1479: IF ln_csf_comb_req_id<>0
1480: THEN
1481: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_csf_comb_req_id
1482: ,interval => ln_waiting_interval
1483: ,phase => lv_comb_req_phase
1484: ,status => lv_comb_req_status
1485: ,dev_phase => lv_dev_phase

Line 1530: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_convert

1526: --(5.1)Waiting for the 'Report Item Data Convert program' completed
1527: --get its status
1528: IF ln_reqid_convert<>0
1529: THEN
1530: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_convert
1531: ,interval => ln_waiting_interval
1532: ,phase => lv_convert_req_phase
1533: ,status => lv_convert_req_status
1534: ,dev_phase => lv_dev_phase

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

1562: ELSIF lv_convert_req_status_code='E'
1563: THEN
1564: lv_error_flag:='E';
1565: END IF; --lv_comb_req_status_code='C'
1566: END IF; --FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_convert
1567: ELSE
1568: lv_error_flag:='E';
1569: END IF; --ln_reqid_convert<>0
1570:

Line 1582: END IF; --FND_CONCURRENT.Wait_For_Request(request_id => l_reqid_comb

1578: ELSIF lv_comb_req_status_code='E'
1579: THEN
1580: lv_error_flag:='E';
1581: END IF; --lv_comb_req_status_code='C'
1582: END IF; --FND_CONCURRENT.Wait_For_Request(request_id => l_reqid_comb
1583: ELSE
1584: lv_error_flag:='E';
1585: END IF; --l_reqid_comb<>0
1586:

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

1601: END IF;
1602:
1603: IF lv_error_flag='W'
1604: THEN
1605: lb_error_status:=FND_CONCURRENT.Set_Completion_Status(status => 'WARNING'
1606: ,message => ''
1607: );
1608: ELSIF lv_error_flag='E'
1609: THEN

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

1606: ,message => ''
1607: );
1608: ELSIF lv_error_flag='E'
1609: THEN
1610: lb_error_status:=FND_CONCURRENT.Set_Completion_Status(status => 'ERROR'
1611: ,message => ''
1612: );
1613: END IF;
1614:

Line 2357: UPDATE FND_CONCURRENT_REQUESTS

2353: '', '', '', '', '', '', '', '', '', ''
2354: );
2355:
2356: IF (pv_output_option = 'Y') THEN
2357: UPDATE FND_CONCURRENT_REQUESTS
2358: SET
2359: OUTPUT_FILE_TYPE = 'XML'
2360: WHERE
2361: REQUEST_ID = ln_reqid_fsg;

Line 2366: --sub-request id from the table 'fnd_concurrent_requests' for the FSG - CFS report.

2362: END IF;
2363: COMMIT;
2364:
2365: --(4.2)Waiting for the 'Cash Flow Statement - FSG' completed, and then retrive the
2366: --sub-request id from the table 'fnd_concurrent_requests' for the FSG - CFS report.
2367: IF ln_reqid_fsg<>0
2368: THEN
2369: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_fsg
2370: ,interval => ln_waiting_interval

Line 2369: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_fsg

2365: --(4.2)Waiting for the 'Cash Flow Statement - FSG' completed, and then retrive the
2366: --sub-request id from the table 'fnd_concurrent_requests' for the FSG - CFS report.
2367: IF ln_reqid_fsg<>0
2368: THEN
2369: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_fsg
2370: ,interval => ln_waiting_interval
2371: ,phase => lv_fsg_req_phase
2372: ,status => lv_fsg_req_status
2373: ,dev_phase => lv_dev_phase

Line 2434: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_cal

2430: --(4.4)Waiting for the 'Cash flow statement - Calculation' successfully completed
2431: -- and then submit concurrent program 'Cash Flow Statement - Combination'.
2432: IF ln_reqid_cal<>0
2433: THEN
2434: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_cal
2435: ,interval => ln_waiting_interval
2436: ,phase => lv_cal_req_phase
2437: ,status => lv_cal_req_status
2438: ,dev_phase => lv_dev_phase

Line 2479: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_csf_comb_req_id

2475: --(4.5)Waiting for the 'Cash flow statement - Combination' completed
2476: --get its status
2477: IF ln_csf_comb_req_id<>0
2478: THEN
2479: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_csf_comb_req_id
2480: ,interval => ln_waiting_interval
2481: ,phase => lv_comb_req_phase
2482: ,status => lv_comb_req_status
2483: ,dev_phase => lv_dev_phase

Line 2533: END IF; --FND_CONCURRENT.Wait_For_Request(request_id => l_reqid_comb

2529: ELSIF lv_comb_req_status_code='E'
2530: THEN
2531: lv_error_flag:='E';
2532: END IF; --lv_comb_req_status_code='C'
2533: END IF; --FND_CONCURRENT.Wait_For_Request(request_id => l_reqid_comb
2534: ELSE
2535: lv_error_flag:='E';
2536: END IF; --l_reqid_comb<>0
2537:

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

2552: END IF;
2553:
2554: IF lv_error_flag='W'
2555: THEN
2556: lb_error_status:=FND_CONCURRENT.Set_Completion_Status(status => 'WARNING'
2557: ,message => ''
2558: );
2559: ELSIF lv_error_flag='E'
2560: THEN

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

2557: ,message => ''
2558: );
2559: ELSIF lv_error_flag='E'
2560: THEN
2561: lb_error_status:=FND_CONCURRENT.Set_Completion_Status(status => 'ERROR'
2562: ,message => ''
2563: );
2564: END IF;
2565: