542: FOR UPDATE NOWAIT;
543:
544: CURSOR c_request_completed(p_id NUMBER) IS
545: SELECT 1
546: FROM fnd_concurrent_requests fcr
547: WHERE fcr.request_id = p_id
548: AND fcr.phase_code = 'C'
549: AND rownum = 1;
550:
830: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_TRY_AGAIN');
831: print_output;
832: END IF;
833:
834: l_rc := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,
835: 'update_ship_method_SRS');
836: errbuf := l_errbuf;
837: retcode := l_retcode;
838:
857: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
858: END IF;
859: WSH_UTIL_CORE.printmsg(l_errbuf);
860:
861: l_rc := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,
862: 'update_ship_method_SRS');
863: errbuf := l_errbuf;
864: retcode := l_retcode;
865: