APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on FND_CONCURRENT

Line 1643: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');

1639: l_error_code := SQLCODE;
1640: l_error_text := SQLERRM;
1641: WSH_UTIL_CORE.PrintMsg('Interface_ALL failed with unexpected error in ' || l_action || ' ' || l_stop_id);
1642: WSH_UTIL_CORE.PrintMsg('The unexpected error is ' || l_error_text);
1643: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
1644: errbuf := 'Interface trip stop failed with unexpected error';
1645: retcode := '2';
1646: IF lock_row%ISOPEN THEN
1647: CLOSE lock_row;

Line 2019: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');

2015: l_error_code := SQLCODE;
2016: l_error_text := SQLERRM;
2017: WSH_UTIL_CORE.PrintMsg('Interface_ALL failed with unexpected error in ' || l_action || ' ' || l_stop_batch_id);
2018: WSH_UTIL_CORE.PrintMsg('The unexpected error is ' || l_error_text);
2019: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
2020: errbuf := 'Interface trip stop failed with unexpected error';
2021: retcode := '2';
2022: IF lock_row%ISOPEN THEN
2023: CLOSE lock_row;

Line 2125: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');

2121:
2122: END IF;
2123:
2124: <>
2125: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
2126: IF l_completion_status = 'NORMAL' THEN
2127: errbuf := 'Interface trip stop is completed successfully';
2128: retcode := '0';
2129: ELSIF l_completion_status = 'WARNING' THEN

Line 2160: FROM fnd_concurrent_requests fcr

2156: wts.last_updated_by = fnd_global.user_id,
2157: wts.last_update_date = sysdate
2158: WHERE wts.pending_interface_flag = 'P'
2159: AND EXISTS (SELECT 'request completed'
2160: FROM fnd_concurrent_requests fcr
2161: WHERE fcr.request_id = wts.request_id
2162: AND fcr.phase_code = 'C');
2163: l_recs := sql%rowcount;
2164:

Line 2193: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');

2189: l_error_code := SQLCODE;
2190: l_error_text := SQLERRM;
2191: WSH_UTIL_CORE.PrintMsg('Interface_ALL failed with unexpected error.');
2192: WSH_UTIL_CORE.PrintMsg('The unexpected error is ' || l_error_text);
2193: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
2194: errbuf := 'Interface trip stop failed with unexpected error';
2195: retcode := '2';
2196: --
2197: IF l_debug_on THEN

Line 8980: FROM FND_CONCURRENT_REQUESTS

8976:
8977:
8978: CURSOR c_requests (p_parent_request_id NUMBER) IS
8979: SELECT request_id
8980: FROM FND_CONCURRENT_REQUESTS
8981: WHERE parent_request_id = p_parent_request_id;
8982: e_invalid_number EXCEPTION;
8983:
8984: BEGIN

Line 9076: l_dummy := FND_CONCURRENT.get_request_status(

9072:
9073: j := l_child_req_ids.FIRST;
9074: WHILE j IS NOT NULL LOOP
9075: l_dev_status := NULL;
9076: l_dummy := FND_CONCURRENT.get_request_status(
9077: request_id => l_child_req_ids(j), phase => l_phase,
9078: status => l_status,
9079: dev_phase => l_dev_phase,
9080: dev_status => l_dev_status,

Line 9110: l_dummy := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');

9106: ELSE
9107: l_completion_status := 'WARNING';
9108: END IF;
9109:
9110: l_dummy := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
9111:
9112: IF l_completion_status = 'NORMAL' THEN
9113: errbuf := 'Interface trip stop is completed successfully';
9114: retcode := '0';

Line 9138: l_dummy := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');

9134: WHEN e_invalid_number THEN
9135: l_completion_status := 'ERROR';
9136: l_error_code := SQLCODE;
9137: l_error_text := SQLERRM;
9138: l_dummy := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
9139: errbuf := 'Interface trip stop failed with unexpected error';
9140: retcode := '2';
9141: --
9142: IF l_debug_on THEN

Line 9152: l_dummy := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');

9148: l_error_code := SQLCODE;
9149: l_error_text := SQLERRM;
9150: WSH_UTIL_CORE.PrintMsg('Interface_ALL_wrp failed with unexpected error.');
9151: WSH_UTIL_CORE.PrintMsg('The unexpected error is ' || l_error_text);
9152: l_dummy := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
9153: errbuf := 'Interface trip stop failed with unexpected error';
9154: retcode := '2';
9155: --
9156: IF l_debug_on THEN