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.CS_SR_PURGE_CP dependencies on FND_CONCURRENT

Line 73: -- The function fnd_concurrent.set_completion_status

69: --
70: -- IN OUT
71: -- errbuf : This parameter is not used but is a standard
72: -- parameter for concurrent program procedures.
73: -- The function fnd_concurrent.set_completion_status
74: -- is called instead.
75: -- errcode : This parameter is not used but is a standard
76: -- parameter for concurrent program procedures.
77: -- The function fnd_concurrent.set_completion_status

Line 77: -- The function fnd_concurrent.set_completion_status

73: -- The function fnd_concurrent.set_completion_status
74: -- is called instead.
75: -- errcode : This parameter is not used but is a standard
76: -- parameter for concurrent program procedures.
77: -- The function fnd_concurrent.set_completion_status
78: -- is called instead.
79: --
80: -- IN
81: -- p_incident_id : Indicates that SR with this id needs

Line 168: * concurrent program procedures. The function fnd_concurrent.

164: * launched and the SRs are purged. This procedure waits for all the child
165: * concurrent requests to complete purging the SRs allocated to them and then
166: * ends.
167: * @param errbuf This parameter is not used but is a standard parameter for
168: * concurrent program procedures. The function fnd_concurrent.
169: * set_completion_status is called instead.
170: * @param errcode This parameter is not used but is a standard parameter
171: * for concurrent program procedures. The function fnd_concurrent.
172: * set_completion_status is called instead.

Line 171: * for concurrent program procedures. The function fnd_concurrent.

167: * @param errbuf This parameter is not used but is a standard parameter for
168: * concurrent program procedures. The function fnd_concurrent.
169: * set_completion_status is called instead.
170: * @param errcode This parameter is not used but is a standard parameter
171: * for concurrent program procedures. The function fnd_concurrent.
172: * set_completion_status is called instead.
173: * @param p_incident_id Indicates that SR with this id needs to be purged
174: * @param p_incident_status_id Indicates that SR with this status id needs
175: * to be purged

Line 325: fnd_concurrent_requests

321: IS
322: SELECT
323: request_id
324: FROM
325: fnd_concurrent_requests
326: WHERE
327: parent_request_id = c_request_id;
328:
329: BEGIN

Line 570: fnd_concurrent_requests r

566: (
567: SELECT
568: request_id
569: FROM
570: fnd_concurrent_requests r
571: , fnd_concurrent_programs p
572: WHERE
573: r.phase_code = 'C'
574: AND p.concurrent_program_id = r.concurrent_program_id

Line 571: , fnd_concurrent_programs p

567: SELECT
568: request_id
569: FROM
570: fnd_concurrent_requests r
571: , fnd_concurrent_programs p
572: WHERE
573: r.phase_code = 'C'
574: AND p.concurrent_program_id = r.concurrent_program_id
575: AND p.concurrent_program_name = 'CSSRPGP'

Line 881: IF FND_CONCURRENT.Get_Request_Status

877: , 'Worker Concurrent Request No : ' || r_child_request.request_id
878: );
879: END IF;
880:
881: IF FND_CONCURRENT.Get_Request_Status
882: (
883: request_id => r_child_request.request_id
884: , phase => l_worker_conc_req_phase
885: , status => l_worker_conc_req_status

Line 983: , 'Call to function fnd_concurrent.get_request_status failed. '

979: FND_LOG.String
980: (
981: FND_LOG.level_unexpected
982: , L_LOG_MODULE || 'collect_child_status_failed'
983: , 'Call to function fnd_concurrent.get_request_status failed. '
984: || l_main_conc_req_message
985: );
986: END IF;
987:

Line 1125: l_ret := fnd_concurrent.set_completion_status

1121:
1122: -- Setting the completion status of this concurrent
1123: -- request as COMPLETED NORMALLY
1124:
1125: l_ret := fnd_concurrent.set_completion_status
1126: (
1127: 'NORMAL'
1128: , ' '
1129: );

Line 1151: IF FND_CONCURRENT.Get_Request_Status

1147: ---
1148:
1149: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1150: THEN
1151: IF FND_CONCURRENT.Get_Request_Status
1152: (
1153: request_id => l_request_id
1154: , phase => l_main_conc_req_phase
1155: , status => l_main_conc_req_status

Line 1234: l_ret := fnd_concurrent.set_completion_status

1230: , p_msg_index_out => x_msg_index_out
1231: );
1232: END IF;
1233:
1234: l_ret := fnd_concurrent.set_completion_status
1235: (
1236: 'WARNING'
1237: , SUBSTR(x_msg_data, 1, 240)
1238: );

Line 1293: l_ret := fnd_concurrent.set_completion_status

1289: , p_msg_index_out => x_msg_index_out
1290: );
1291: END IF;
1292:
1293: l_ret := fnd_concurrent.set_completion_status
1294: (
1295: 'ERROR'
1296: , SUBSTR(x_msg_data, 1, 240)
1297: );

Line 1352: l_ret := fnd_concurrent.set_completion_status

1348: , p_msg_index_out => x_msg_index_out
1349: );
1350: END IF;
1351:
1352: l_ret := fnd_concurrent.set_completion_status
1353: (
1354: 'ERROR'
1355: , SUBSTR(x_msg_data, 1, 240)
1356: );

Line 1416: l_ret := fnd_concurrent.set_completion_status

1412: , p_msg_index_out => x_msg_index_out
1413: );
1414: END IF;
1415:
1416: l_ret := fnd_concurrent.set_completion_status
1417: (
1418: 'ERROR'
1419: , SUBSTR(x_msg_data, 1, 240)
1420: );

Line 1448: -- The function fnd_concurrent.set_completion_status

1444: --
1445: -- IN OUT
1446: -- errbuf : This parameter is not used but is a standard
1447: -- parameter for concurrent program procedures.
1448: -- The function fnd_concurrent.set_completion_status
1449: -- is called instead.
1450: -- errcode : This parameter is not used but is a standard
1451: -- parameter for concurrent program procedures.
1452: -- The function fnd_concurrent.set_completion_status

Line 1452: -- The function fnd_concurrent.set_completion_status

1448: -- The function fnd_concurrent.set_completion_status
1449: -- is called instead.
1450: -- errcode : This parameter is not used but is a standard
1451: -- parameter for concurrent program procedures.
1452: -- The function fnd_concurrent.set_completion_status
1453: -- is called instead.
1454: --
1455: -- IN
1456: -- p_worker_id : The number assigned to this worker which enables

Line 1510: * concurrent program procedures. The function fnd_concurrent.

1506: * the SR Delete API. At any point in time, several copies of this procedure
1507: * may be running in parallel since the Purge Concurrent Program will generate
1508: * multiple Worker Concurrent Programs based on its parameter no_of_workers.
1509: * @param errbuf This parameter is not used but is a standard parameter for
1510: * concurrent program procedures. The function fnd_concurrent.
1511: * set_completion_status is called instead.
1512: * @param errcode This parameter is not used but is a standard parameter
1513: * for concurrent program procedures. The function
1514: * fnd_concurrent.set_completion_status is called instead.

Line 1514: * fnd_concurrent.set_completion_status is called instead.

1510: * concurrent program procedures. The function fnd_concurrent.
1511: * set_completion_status is called instead.
1512: * @param errcode This parameter is not used but is a standard parameter
1513: * for concurrent program procedures. The function
1514: * fnd_concurrent.set_completion_status is called instead.
1515: * @param p_worker_id The number assigned to this worker which enables the
1516: * worker concurrent program to identify the SRs in the staging table that
1517: * it needs to purge
1518: * @param p_purge_set_id The concurrent request id of the parent concurrent

Line 1788: fnd_concurrent_requests r

1784: 1
1785: INTO
1786: l_row_count
1787: FROM
1788: fnd_concurrent_requests r
1789: , fnd_concurrent_programs p
1790: WHERE
1791: r.request_id = p_purge_set_id
1792: AND p.concurrent_program_id = r.concurrent_program_id

Line 1789: , fnd_concurrent_programs p

1785: INTO
1786: l_row_count
1787: FROM
1788: fnd_concurrent_requests r
1789: , fnd_concurrent_programs p
1790: WHERE
1791: r.request_id = p_purge_set_id
1792: AND p.concurrent_program_id = r.concurrent_program_id
1793: AND p.concurrent_program_name = 'CSSRPGP'

Line 2124: l_ret := fnd_concurrent.set_interim_status

2120: -- since purging this batch failed.
2121: -- however this will NOT stop the process
2122: -- from running further.
2123:
2124: l_ret := fnd_concurrent.set_interim_status
2125: (
2126: 'WARNING'
2127: , SUBSTR(x_msg_data, 1, 240)
2128: );

Line 2356: l_ret := fnd_concurrent.set_completion_status

2352: THEN
2353: -- Setting the completion status of this concurrent
2354: -- request as COMPLETED NORMALLY
2355:
2356: l_ret := fnd_concurrent.set_completion_status
2357: (
2358: 'NORMAL'
2359: , ' '
2360: );

Line 2372: l_ret := fnd_concurrent.set_completion_status

2368: 'CS'
2369: , 'CS_SR_WORKER_BATCH_FAIL'
2370: );
2371:
2372: l_ret := fnd_concurrent.set_completion_status
2373: (
2374: 'WARNING'
2375: , l_message
2376: );

Line 2388: l_ret := fnd_concurrent.set_completion_status

2384: -- request has completed with status
2385: -- NORMAL which is not correct in the
2386: -- current scenario.
2387:
2388: l_ret := fnd_concurrent.set_completion_status
2389: (
2390: 'TERMINATED'
2391: , ' '
2392: );

Line 2399: IF fnd_concurrent.get_request_status

2395: ---
2396:
2397: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2398: THEN
2399: IF fnd_concurrent.get_request_status
2400: (
2401: request_id => l_request_id
2402: , phase => l_conc_req_phase
2403: , status => l_conc_req_status

Line 2488: l_ret := fnd_concurrent.set_completion_status

2484: , p_msg_index_out => x_msg_index_out
2485: );
2486: END IF;
2487:
2488: l_ret := fnd_concurrent.set_completion_status
2489: (
2490: 'ERROR'
2491: , SUBSTR(x_msg_data, 1, 240)
2492: );

Line 2558: l_ret := fnd_concurrent.set_completion_status

2554: , p_msg_index_out => x_msg_index_out
2555: );
2556: END IF;
2557:
2558: l_ret := fnd_concurrent.set_completion_status
2559: (
2560: 'ERROR'
2561: , SUBSTR(x_msg_data, 1, 240)
2562: );