APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on FND_CONCURRENT

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

2102: l_error_code := SQLCODE;
2103: l_error_text := SQLERRM;
2104: WSH_UTIL_CORE.PrintMsg('Interface_ALL failed with unexpected error in ' || l_action || ' ' || l_stop_id);
2105: WSH_UTIL_CORE.PrintMsg('The unexpected error is ' || l_error_text);
2106: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
2107: errbuf := 'Interface trip stop failed with unexpected error';
2108: retcode := '2';
2109: IF lock_row%ISOPEN THEN
2110: CLOSE lock_row;

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

2504: l_error_code := SQLCODE;
2505: l_error_text := SQLERRM;
2506: WSH_UTIL_CORE.PrintMsg('Interface_ALL failed with unexpected error in ' || l_action || ' ' || l_stop_batch_id);
2507: WSH_UTIL_CORE.PrintMsg('The unexpected error is ' || l_error_text);
2508: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
2509: errbuf := 'Interface trip stop failed with unexpected error';
2510: retcode := '2';
2511: IF lock_row%ISOPEN THEN
2512: CLOSE lock_row;

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

2610:
2611: END IF;
2612:
2613: <>
2614: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
2615: IF l_completion_status = 'NORMAL' THEN
2616: errbuf := 'Interface trip stop is completed successfully';
2617: retcode := '0';
2618: ELSIF l_completion_status = 'WARNING' THEN

Line 2649: FROM fnd_concurrent_requests fcr

2645: wts.last_updated_by = fnd_global.user_id,
2646: wts.last_update_date = sysdate
2647: WHERE wts.pending_interface_flag = 'P'
2648: AND EXISTS (SELECT 'request completed'
2649: FROM fnd_concurrent_requests fcr
2650: WHERE fcr.request_id = wts.request_id
2651: AND fcr.phase_code = 'C');
2652: l_recs := sql%rowcount;
2653:

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

2678: l_error_code := SQLCODE;
2679: l_error_text := SQLERRM;
2680: WSH_UTIL_CORE.PrintMsg('Interface_ALL failed with unexpected error.');
2681: WSH_UTIL_CORE.PrintMsg('The unexpected error is ' || l_error_text);
2682: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
2683: errbuf := 'Interface trip stop failed with unexpected error';
2684: retcode := '2';
2685: --
2686: IF l_debug_on THEN

Line 10365: FROM FND_CONCURRENT_REQUESTS

10361:
10362:
10363: CURSOR c_requests (p_parent_request_id NUMBER) IS
10364: SELECT request_id
10365: FROM FND_CONCURRENT_REQUESTS
10366: WHERE parent_request_id = p_parent_request_id;
10367: e_invalid_number EXCEPTION;
10368:
10369: BEGIN

Line 10461: l_dummy := FND_CONCURRENT.get_request_status(

10457:
10458: j := l_child_req_ids.FIRST;
10459: WHILE j IS NOT NULL LOOP
10460: l_dev_status := NULL;
10461: l_dummy := FND_CONCURRENT.get_request_status(
10462: request_id => l_child_req_ids(j), phase => l_phase,
10463: status => l_status,
10464: dev_phase => l_dev_phase,
10465: dev_status => l_dev_status,

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

10491: ELSE
10492: l_completion_status := 'WARNING';
10493: END IF;
10494:
10495: l_dummy := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
10496:
10497: IF l_completion_status = 'NORMAL' THEN
10498: errbuf := 'Interface trip stop is completed successfully';
10499: retcode := '0';

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

10519: WHEN e_invalid_number THEN
10520: l_completion_status := 'ERROR';
10521: l_error_code := SQLCODE;
10522: l_error_text := SQLERRM;
10523: l_dummy := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
10524: errbuf := 'Interface trip stop failed with unexpected error';
10525: retcode := '2';
10526: --
10527: IF l_debug_on THEN

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

10533: l_error_code := SQLCODE;
10534: l_error_text := SQLERRM;
10535: WSH_UTIL_CORE.PrintMsg('Interface_ALL_wrp failed with unexpected error.');
10536: WSH_UTIL_CORE.PrintMsg('The unexpected error is ' || l_error_text);
10537: l_dummy := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
10538: errbuf := 'Interface trip stop failed with unexpected error';
10539: retcode := '2';
10540: --
10541: IF l_debug_on THEN